• Architecting Data Models and Data Strategy for Sage
• Application Portfolio Rationalization Exercise across 24 Countries.
• Leading Joint design sessions with business users and reporting staff for defining DW & ODS Standard
• Developing Metadata Strategy, Data Stewardship, Master Data Management (MDM),AWS,Bigdata Hadoop & Advanced Analytics
• Developing Roadmap standards &procedures, tools & technology for SAGE

Thorough working knowledge of EU data protection legislation (GDPR

Platform: Teradata, AWS, MSSQL Server, Python, PowerBI, Informatica Cloud,ER Studio,MuleSoft. Domain: Product Based Responsibilities/ Accomplishments include: Led and managed the RFP process, evaluated the responses and selected the vendor & tools. Implemented ODS & Moving to Data Lake for BI & DWH Capabilities. Developed the BI Strategy and a 3 year BI roadmap in alignment with the corporate goals. Led the tool standardization exercise to minimize the BI tools used in the organization. Currently leading and managing an enterprise-wide effort of identifying the Key Performance Indicators (KPIs) across all the domains of the organization. These KPIs will be used to develop a corporate dashboard to facilitate fact based decision making. As part of requirements gathering capturing and managing business definitions/ metadata. Leading/Facilitating joint design sessions with business users and reporting staff. Conducting data profiling to identify & analyze data quality issues. Building and maintaining relationships with the business partners to keep their active engagement in the BI projects. Brainstorming sessions with Team to gather requirements and to identify gaps and major pain points. Involved in the team in defining and delivering BICC deliverables like Data Quality, Metadata Strategy, Data Stewardship, Master Data Management (MDM), Communications, Best Practices, Standards, Policies, and Training. Established a Business Intelligence Competency Center (BICC) which involved developing roadmap, people& organization, process & methods, standards & procedures, tools & technology, and governance all around DWH Business Intelligence. Utilized the iterative phased approach to create data marts. Conducted risk workshop to identify, plan, and mitigate those risks. Provided strong technical leadership to the project team. Developed the ramp up and the deployment strategy.

• Handling change requests and requirements and support the IT and business Stakeholders
• Performance Tuning/Developing Optimized Stored Procedure for CDW
• Proactively DWH Optimization and Architectural Changes
• Expert with management tools - View Point,TASM,Teradata Studio,TASM
• Performance Reports on Teradata system & Implementing Optimization
• Handling team of 6 People
• data modeling and ETL modeling

Platform: Teradata ETL: Datastage Domain: Banking Responsibilities/ Accomplishments include: Performance Tuning/Developing Optimized Stored Procedure for CDW Proactively generating Performance Reports on the system and come up with opportunities to optimize the Application. Implementing Optimum Stats Collection Mechanism to have performance Optimization. Worked on SLA based environment. Handling P1 and P2 level performance issues with providing solutions within SLA and provide detail RCA. Ticket resolution and request fulfilment for the Release management. Performed query optimization and assisted ETL developers and users by analyzing DBQL data, explain plan and join strategy and Partitioning large tables to improve performance of sqls Identifying bad performing queries/ stored procedures and Re-Writing Queries/ stored procedures as per the Teradata best Practices and Improving the Performance of the same Responsibilities include creating project plan, resource estimates, and budgeting for this phase based on Jira Agile Scrum Setup developing high-level plans & estimates Suggesting Architectural changes to the Customer Architects Helping Teradata Performance Engineering team for CDW High Priority Ticket resolution and request fulfilment for the Release management. Meeting the SLAs to deliver the reports to the business users. Team Management responsibilities: Managing team of Senior Teradata Experts using Agile framework. Integrating new team into Customer processes. Managing release process from developers side. Managing backlog of the team. Decision making and problem solving on wide variety of technological issues. Conducting technical interviews with new hires and performance interviews with team members.

ETL: DataStage,Informatica, Unix Shell scripting Reporting: Business Object/ Tableau Domain: Insurance, Retail Technologies Used: Teradata 14.10, Datastage, BTEQ, TPT,SAS,FASTLOAD, Teradata SQL, Teradata Stored Procedures, Shell Scripting,Contol M,Crontab,Teradata ViewPoint,Oracle PL-SQL,SAS,SAS Studio Products Used: Teradata DB, Teradata PDCR, Windows Server, Remedy, Jira. Responsibilities/ Accomplishments include: Projects: 1) Kesko-EDW KESKO Finland (BI-Teradata Project Development) Requirement Analysis and Estimation for the Project Design of PDM and implementation from Teradata Translating the logical Model to the Physical Model. Profiling the Data for Column level Compression. Efficient SQL & exposure to query tuning. Developing Stored Procedure/Views for different Layers & suggesting Optimization & Design and Development of Customised Semantic Layer. Extensive expertise in analyzing performance, tuning, working with large volumes of data. Optimizing and re-writing the Teradata queries & Performance Tuning of Semantic Layer. Project BI/ASM Lead Teradata DBA: Kesko BI ASM Services Teradata & IF Insurance Teradata DW Support service: Working on different assignments like Skew Analysis, Join index Analysis, stats analysis, PPI analysis, Conducted risk workshop to identify, plan, and mitigate those risks. Analysing System for highly CPU/IO consuming queries and providing concrete solutions, guiding developers for best practices in Teradata. Analysing Performance of System from TASM Perspective, Recommending TASM changes as per the requirement. Performing Monthly TASM analysis and presenting to client. Tweaking TASM Rules/Workload Throttles as per the Requirement Attending Calls with Client along with Weekly Report preparation and analysis Actively involved with P1 issues and providing solutions within the given SLA. Coordinating with GSC for P1 issues. Scheduling Automated Alerts for bad running jobs on the system through Shell script Creating Test and Development environments and granting access/privileges based on requirement. Performing Code review for queries send by development team. Reviewing code for performance issue and to ensure queries are as per coding standard and providing DBA sign-off. Solving ad hoc requests for access rights, query tuning, space management, Lock release etc. as per the user requirement. Performing Data Copy request (Backup and restore) for data movement from one server to another using NetBackup tool, help project Team for environment preparation. Worked on MVC analysis for few production tables for space saving on Production systems. Tracking Capacity requirement before any production implementation and ensuring estimated space availability, in order to ensure smooth loads after production Implementation. Creation and maintenance of new environments, databases, users, roles. User Management (Creating users, assigning profiles, roles depending on users specification according to the organizational policies.) Manage and maintain data in production and non-production databases. Manages ticket queues to ensure items such as requests, incidents, and changes are assigned the proper priority. Designing Teradata objects & Application Dba activities (user creation, role creation, profile creation, Performance Tuning, Stats collection). Expert in advanced Teradata concepts like Join strategy, Index choice, Performance Optimization, Compression Having working experience in PDCR Support the application development teams for technical issues. Teradata Upgrades/Migration Coordinating with Customer Data Architect and Data Modeling. Team Management responsibilities: Managing team of Senior Teradata DBA and ETL Developers and Reporting. Representing the CAB for Critical Approval and Priority Issue from Operational Perspective Managing release process from Both Operational and Project Perspective. Decision making and problem solving on wide variety of technological issues. Conducting technical interviews with new hires and performance interviews with team members.

Key responsibilities: Building a solid relationship with a customer by becoming a trusted advisor to the clients decision makers through establishing credibility and expertise in DWH BI applications and other Teradata solutions. Changing/ Re-designing the SQLs Capturing and managing source to target mappings. Optimizing and re writing the Teradata queries. Translating the logical Model to the Physical Model. Profiling the Data for Column level Compression. Fixing the existing Data issue for the BI Analysts. Designed and developed project document templates based on End Users requirements and training Manuals Established and maintained engagements with the business partners regarding on-boarding of the data ensuring the integrity of the data. Established and enforced a standard format for the delivery of the data to the Enterprise Data Warehouse (EDW). Facilitated discussions with data owners and business partners to get conformance around reference data and hierarchies. Used the Joint Application Development (JAD) in a war room environment to ensure that the aggressive timelines are met. Conducted presentations for the senior leadership to communicate the status and escalate any issues requiring their intervention. Led the requirements gathering effort, analyzed the requirements, and created the scope. Worked with the Subject Matter Experts (SMEs) to obtain buy-in on the common definitions. Planned the entire Data Warehousing initiative from requirements gathering, analysis, design, identifying and analyzing the source systems, to data quality, to ETL, and to the end user data access. Tuning most resource consuming Teradata Procedures and BTEQ,ETL and SQLs &Changing/ Re-designing the SQLs

Key responsibilities: FDW: Financial Datawarehouse Extensively worked in data Extraction, Transformation and loading from source to target system using Bteq, Fast Load. Performance & Quality Check Review. Unit Test case preparation, Coding and Unit Testing. Quality check for code and Test Results. Suggesting best practices to ETL developers to improve performance of the code. Involved in writing scripts for loading data to target data Warehouse for Bteq, Fast Load, and MultiLoad. Analyzing sessions with for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received. Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts. Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system. IDA: DWH Market/support and development, Application development, ETL development & Support PW: Campaign Management & Development for Customer Fund Data MasterData: DB support and Enhancement Technologies Used: Teradata 14.10, Datastage, BTEQ, TPT,SAS,FASTLOAD, Teradata SQL, Teradata Stored Procedures, Shell Scripting,Contol M,Crontab,Teradata ViewPoint,Oracle PL-SQL,SAS,SAS Studio Products Used: Teradata DB, Teradata PDCR, Windows Server, Remedy, Jira.

• Requirement Analysis and Estimation for the Project
• Design of PDM and implementation from Teradata
• Translating the logical Model to the Physical Model.
• Profiling the Data for Column level Compression.
• Efficient SQL & exposure to query tuning.
• Developing Stored Procedure/Views for different Layers & suggesting Optimization & Design and Development of Customised Semantic Layer.
• Extensive expertise in analyzing performance, tuning, working with large volumes of data.
• Optimizing and re-writing the Teradata queries & Performance Tuning of Semantic Layer

• Working on different assignments like Skew Analysis, Join index Analysis, stats analysis, PPI analysis, Conducted risk workshop to identify, plan, and mitigate those risks.
• Analysing System for highly CPU/IO consuming queries and providing concrete solutions, guiding developers for best practices in Teradata.
• Analysing Performance of System from TASM Perspective, Recommending TASM changes as per the requirement. Performing Monthly TASM analysis and presenting to client.
• Tweaking TASM Rules/Workload Throttles as per the Requirement
• Attending Calls with Client along with Weekly Report preparation and analysis
• Actively involved with P1 issues and providing solutions within the given SLA. Coordinating with GSC for P1 issues.
• Scheduling Automated Alerts for bad running jobs on the system through Shell script
• Creating Test and Development environments and granting access/privileges based on requirement.
• Performing Code review for queries send by development team. Reviewing code for performance issue and to ensure queries are as per coding standard and providing DBA sign-off.
• Solving ad hoc requests for access rights, query tuning, space management, Lock release etc. as per the user requirement.
• Performing Data Copy request (Backup and restore) for data movement from one server to another using NetBackup tool, help project Team for environment preparation.
• Worked on MVC analysis for few production tables for space saving on Production systems.
• Tracking Capacity requirement before any production implementation and ensuring estimated space availability, in order to ensure smooth loads after production Implementation.
• Creation and maintenance of new environments, databases, users, roles.
• User Management (Creating users, assigning profiles, roles depending on user’s specification according to the organizational policies.)
• Manage and maintain data in production and non-production databases.
• Manages ticket queues to ensure items such as requests, incidents, and changes are assigned the proper priority.
• Designing Teradata objects & Application Dba activities (user creation, role creation, profile creation, Performance Tuning, Stats collection).
• Expert in advanced Teradata concepts like Join strategy, Index choice, Performance Optimization, Compression Having working experience in PDCR
• Support the application development teams for technical issues. Teradata Upgrades/Migration
• Coordinating with Customer Data Architect and Data Modeling.

Team Management responsibilities:

• Managing team of Senior Teradata DBA and ETL Developers and Reporting.
• Representing the CAB for Critical Approval and Priority Issue from Operational Perspective
• Managing release process from Both Operational and Project Perspective.
• Decision making and problem solving on wide variety of technological issues.
• Conducting technical interviews with new hires and performance interviews with team members.

• Extensively worked in data Extraction, Transformation and loading from source to target system using Bteq, Fast Load.
  Performance & Quality Check Review.
• Unit Test case preparation, Coding and Unit Testing.
• Quality check for code and Test Results.
• Suggesting best practices to ETL developers to improve performance of the code.
• Involved in writing scripts for loading data to target data Warehouse for Bteq, Fast Load, and MultiLoad.
• Analyzing sessions with for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received.
• Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
• Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.

IDA: DWH Market/support and development, Application development, ETL development & Support

PW: Campaign Management & Development for Customer Fund Data

MasterData: DB support and Enhancement

Technologies Used: Teradata 14.10, Datastage, BTEQ, TPT,SAS,FASTLOAD, Teradata SQL, Teradata Stored Procedures, Shell Scripting,ContolM,Crontab,TeradataViewPoint,Oracle PL-SQL,SAS,SAS Studio

Products Used: Teradata DB, Teradata PDCR, Windows Server, Remedy, Jira.