SUMMARY:

• Have 14 years of experience in implementing and supporting of Data Warehouse and Data Migration Projects.
• Strong experience in implementing Data warehouse/Data migration techniques from the scratch Using ETL tools such as Informatica 9.1/8.6/7.3 and BODI/BODS/BODQ which involves source code customization, testing, debugging and maintenance of complex systems.
• Worked 5 years in Europe as an SAP Data Migration(ETL Architect) specialist.
• Rich experience in huge SAP Data Migration projects from End to end using ETL implementations.
• As an ETL Architect, Provided technical consulting and guidance to development teams for the design and development of highly complex or critical ETL architecture.
• As an ETL Architect, Identifies opportunities for new architectural initiatives; makes recommendations on the increasing scalability and robustness of ETL platforms and solutions.
• As an ETL Architect, Performed short and long term strategic business activities - by developing, enhancing and maintaining operational information and models.
• Worked on Power Exchange for Change Data Capture on real time data.
• Worked on MDM and Data Governance techniques.
• Worked on Metadata management.
• Proven Technical Leader in large and complex data intensive solutions.
• Determines organizational strategies for data integrity validation processes. Establishes policies and best practices for optimizing ETL data throughput/accessibility.
• Good experience in Telecom,Health Care & Insurance domains.
• Experience in Oracle, DB2, and Teradata databases and extensively worked in Erwin,Autosys,UNIX, SQL, PL/SQL programming.
• Work on the BTEQ,MLOAD,TPT utilities and tune the low performance queries
• Individual contributor to the Project as a Technical member.
• Knowledge on Performance Tuning in Informatica.
• Good experience in supporting complex Financial Warehouse systems.
• Conduct impact assessment and determine size of effort based on requirements.
• Good experience in fast paced Agile Environment.
• Thorough understanding of Software Development Life Cycle (SDLC), involved in various phases - Requirements, Analysis/Design, Development and implementation.
• Worked on performance tuning in huge volumes of data warehouse systems.
• Good understanding of Business Processes and Data warehousing Concepts.
• Perform as an active, leading role in shaping and enhancing overall ETL Informatica architecture.
• Quick learner with a desire to work in a team oriented environment.
• Experience in Onsite-Offshore model.
• Effectively communicate with Business Users and Stakeholders.
• Expertise in ETL activities like Data Extraction, Data Modeling, and Loading (Full/Delta upload).

TECHNICAL SKILLS:

Tools: ETL (Informatica 9.1, 8.6, SAP BODI XI),DAC,Erwin,Gromit,Rally

Language: C, C++, Java, SQL, PL/SQL,LSMW

Databases: Teradata,DB2,SQL Server 2000/2005, Oracle 8i/9i/10g, MySQL, MS Access

Operating Systems: Windows family, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Architect/Tech Manager

Environment: Informatica V 9.1/8.6,, Teradata, UNIX shell scripts,Erwin,Rally,Gromit

Responsibilities:

• Participating in User story discussions and working on the requirements.
• Designing the warehouse by identifying the dimensions and facts.
• Responsible for sprint closures and releases.
• Coordinate with offshore team and guiding them in the smooth delivery in a fast paced Agile environment.
• Closely work with product owners and Scrum masters to ensure that deliverables are in line with the plan.
• Handled more than 30 TB of data in Fact tables.
• Proactively work with upstream and down stream application teams and mitigate the risks if any.
• Resolve the data issues and design issues by coordinating with cube teams
• Gather and document client requirements and translate these into process and system architecture designs
• Work with Partner/Customer Project Managers to scope projects and develop statements of work, project plans, and risk analysis
• Provide technical thought leadership and actively participate in the application design, implementation, and roll-out efforts.
• Responsible for Data Governance and data standards.
• Design the technical specification using the Gromit mapping tool and coordinate the deliverables.
• Work on the BTEQ,MLOAD,TPT utilities and tune the low performance queries.
• Extensively work on Hierarchies(ADRM) and design the tables in warehouse to handle levels of information.
• Participate in system test processes and make sure all the testing scenario's be tested.

Confidential

ETL Architect&Business Analyst

Environment: Informatica V 9.1/8.6, Sql server 2008, Teradata, DB2, UNIX shell scripts.

Responsibilities:

• Ensured that data loading into Data warehouse is properly cleansed and validated with all the business rules so that good quality of data can be considered for the decision support systems.
• Also validated key information such as PHI about the members and implemented encrypted logics on the data for the end users who work on the day to day to reports .
• Incorporated the secured views process and maintained cross walk tables in that in order to trace back to the original data for any quality issues.
• Monthly metrics run on the production data for all the KPI's and will be validated for any load issues and after that we will release the load to users.
• After smooth monthly load we run monthly statistics on the KPI's and will be posted into intranet for top level management reviews.
• As a ETL architect ensures that data can be reliable trusted and that team can be made accountable for any adverse event that happens because of low data quality.
• Improved performance of ETL Operations by recommending appropriate techniques and streamlining the process.
• Integrated UHCP Medico system business successfully into existing EDM data warehouse.
• Responsible for various requirement implementations and sign off from various end business users, technical and QA team.
• Created SOWs, BRDs and Functional specification and design documents for various projects and well versed with the processes.
• Handled complex Claim process system Enterprise Data Mart (EDM).
• Utilized my strong domain knowledge in Healthcare and compliance data needs to finalize the solutions for various projects.
• Individual contributor to the Project as a Technical member.
• Involved in developing shell scripts, PL/SQL Procedures for the applications.
• Understanding the design and verifying its Business logics as per requirements.
• Developing Mappings as per given design, and raising issues where ever problem arises.
• Unit Testing the ETL’s with test data and Involved in peer reviews.
• Worked on most of transformations and implemented complex mappings.
• Responsible for resolving and/or driving the resolution to issues and risks through evaluation of differing opinions to negotiate resolution and priority.
• Optimizing performance for session taking huge data and amount.
• Code changes and Coding new programs - Enhancements.
• Direct interaction with client through status calls and emails at all stages.
• Performed post Load QA checks and trend analysis on the production data.
• Defined and explored various operational solutions for implementation of new business requirements without impacting the existing architecture standards.
• Identify opportunities for further enhancements and refinements to the ETL standards and processes.
• Responsible for preparing Functional and ETL Technical design documents.
• Effectively managed a list of issues and risks, identifying owner, priority, timelines, and other relevant information.
• Conducted and presentations to the business stakeholders on various development and operational processes, applications and new value add initiatives.
• Created Work Orders/Prompts for various Light enhancements and have been responsible for successful implementation of the enhancements.
• Ensures high quality, adherence to standards and best practices, high performance, and scalable, repeatable processes and deliverables.
• Given inputs for the architectural changes for the existing book of business while integrating the UHCP.
• Effectively managed a list of issues and risks, identifying owner, priority, timelines, and other relevant information.

Confidential

ETL Architect/Tech Lead

Environment: Informatica V8.6, Sql server 2008, Teradata, DB2, Microstrategy.

Responsibilities:

• Handling complex Facts and Dimension table loads.
• Closely monitoring UAT phase and responds to users very quickly in case of any issues.
• Identify opportunities for further enhancements and refinements to the ETL standards and processes.
• Responsible for preparing Functional and ETL Technical design documents.
• Ensures high quality, adherence to standards and best practices, high performance, and scalable, repeatable processes and deliverables.
• Collect the weekly Status reports on the developments of the project and cascade them to High level management.
• Effectively communicate with Business Users and Stakeholders.
• Created documentation for technical and supports point of view.
• Contributes to project success by providing technical leadership on assigned projects.
• Analyze application and data integration problems, provide alternatives and recommend corrective action

Confidential

ETL Support Lead

Environment: Informatica V8.6, DAC,SQL,PL/SQL, DB2, UNIX shell scripts, Autosys, OBIEE.

Responsibilities:

• Responsible for preparing ETL enhancement design documents.
• Handling complex financial applications like E1 (Enterprise one), Atlas.
• Monitoring daily running production jobs and responds to users very quickly in case of any issues.
• Identify opportunities for further enhancements and refinements to the ETL standards and processes.
• Ensures high quality, adherence to standards and best practices, high performance, and scalable, repeatable processes and deliverables.
• Perform monthly extracts from data warehouse and results will be sent to finance team for analyzing.
• Ensured 100% SLA’s are met.
• Working on performance tuning in order to finish all running production jobs in time.
• Collect the weekly reports on the developments of the project.
• Understanding the new functional and Technical Specifications and identifying measures, dimensions.
• Effectively communicate with Business Users and Stakeholders.
• Created documentation for technical and supports point of view.
• Lead the team. Responsible for Cross ETL and BI
• Contributes to project success by providing technical leadership on assigned projects.
• Provide input and recommendations on design/technical issues to Project Manager/Senior Managers.
• Develop mappings with performance, accuracy and efficiency to achieve operational objectives.
• Analyze application and data integration problems, provide alternatives and recommend corrective actions.
• Understanding new requirements of projects, preparing Functional Specs, Technical Specs, Impact analysis, Customization, creating Test cases & sign offs.

Confidential

Data Migration Lead

Environment: SAP R3,Business objects XI V3.1 (BODI,BODS,BODQ), Sql server 2005.

Responsibilities:

• Actively involved in requirement gathering, gap analysis, Design and implementation.
• Responsible for preparing ETL design documents.
• Evaluates and recommends ETL solutions to meet user needs.
• Ability to define and implement approaches to load and extract data from data sources.
• Identify opportunities for further enhancements and refinements to the ETL standards and processes.
• Work with technical teams on the technical issues of SAP BO DI tool.
• Transform all the business requirements into successful data loading process.
• Building trust with Quality of deliverables and Managing expectations with consistency
• Transparency with the IATA team and raise the issues + be part of the solution
• Proactively manage a realistic balance between innovation and delivery.
• Take personal responsibility while delivering the complex data objects.

Confidential

ETL Architect/ETL Technical Manager

Environment: Informatica 7.x, Sql server 2005, DB2, SAP, LSMW

Responsibilities:

• Handled all the responsibilities very effectively in the fields of all data conversion (IDB, ETL, DQT, and LSMW) areas.
• Designed FS, TS for the complex objects for which data is coming from the various legacy systems.
• Coordinated with the offshore team and as well as local client team for all the necessary actions.
• Anticipated peak workloads and managed very well without any issues
• Managed and coordinated very well for the complex changes in the objects so that they will not impact the project plans.
• Planning, analyzing and defining high-level software strategies and solutions through business, functional and technical expertise.
• Supervising the design and implementation of analyses that will identify requirements Related to people, processes and technology.
• Implementing or supervising the implementation of the technical infrastructure
• Integrating technical and application components.
• Designing the framework of a technical infrastructure.
• Supervising the designing, coding and testing of program modules.
• Supervising the maintenance, repair and tuning of applications; directing user support activities; managing preventive maintenance activities.
• As an experienced person in the Nestle France went to the Spain, Netherlands, Italy markets for assistance during their critical phases of the projects.

Confidential

Senior Developer

Environment: Informatica 7.x, DB2,LSMW,Sql server,Oracle

Responsibilities:

• Developed complex ETL mappings and delivered in time.
• Coordinating with client as a market coordinator for smooth delivery of UK & UP objects and this involved leading the team in a knowledge transfer from client site, setting up the process for trouble shooting the problems in developmental activity.
• Involved in the first 24x7 operations for the Support Services for UK & UP market.
• Planning the 24x7 operations by leveraging the existing resources helped streamline the support operations and provide an integrated approach to supporting the ETL.

Confidential

ETL Consultant

Environment: Informatica, Oracle.

Responsibilities:

• Developed SALES DATAMART
• Extracted data from Flat files and Oracle Database using Informatica
• Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations using most of the available transformations
• Dealt with the slowly changing dimensions.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions, using Informatica ETL tool.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Scheduled and monitored transformation processes using Informatica Server Manager.
• Communicated project status and escalated issues to management