PROFILE SUMMARY:

• Experience as an ETL Senior Consultant/Project Manager/Lead with a great amount of IT experience working with customers in verticals like Food&Beverage, Transportation, Healthcare, Insurance, Finance, Consumer Electronics, Government and Energy&Utilities.
• Possesses sound knowledge of Data Warehousing and ETL Design, excellent People Management Skills and Leadership Skills.
• Certified in Informatica, and expert - level experience with Informatica 9.5.1 and the older versions.
• Experience in ETL Technical Design, OBIA, DAC, Solution Construction, Project Management, Resourcing, Cost&Effort Estimations and mentoring junior resources.
• Excellent written and verbal communication skills and rapport with Customer, Senior Management and Team.
• Leadership, motivational skills, highly self motivated, teaming skills, ability to advise the customer, proactive.
• Ability to communicate effectively. I.e. possess effective communication skills (verbal and written).
• Interpersonal communication skills, interpersonal relationship skills and Relationship Management skills.
• Strong Analytical abilities, strong problem solving skills and ability to translate business requirements into technical solutions, Design skills, Understanding of coding standards, Knowledge of processes.

TECHNICAL SKILLS:

Business Intelligence: Informatica PowerCenter 9.5.1, OBIEE OBIA 7.9.6.4, DAC 11.1.1.6.4 , Informatica Metadata Manager 9.5.1, Informatica PowerExchange for SAP NetWeaver, Informatica PowerCenter Mapping Architect for Visio, Informatica PowerCenter 8.6.1 and older versions, Informatica PowerExchange for VSAM, Data Warehousing, SAP BusinessObjects

Languages: SQL, PL/SQL, Python, Linux/Unix Shell Scripting

DBMS: Oracle 11g, PostgreSQL 9.4.6, Microsoft SQL Server .0, DB2

OS/Environment: Red Hat Linux, AIX Unix, Windows Server 2008 R2

Source Systems: PeopleSoft ERP, SAP, Mainframe Legacy VSAM Files

Tools: Microsoft Office Suite, Microsoft Project, MS PowerPoint, MS Excel, MS SharePoint, MS SQL Server Management Studio 11.0, Toad, Oracle SQL Developer, SQL Navigator, DB2 Visualizer, PL/SQL Developer, FileZilla, Putty, Tera Term, WinSCP, BMC Remedy, JIRA

WORK EXPERIENCE:

ETL Senior Consultant

Confidential

Responsibilities:

• To create ETL technical design specification documents.
• To design ETL Informatica solutions for the customer, on the assigned projects.
• To provide daily status reports to the customer on the progress of the project.
• To support the client through ETL Requirements, Build/Test and Production Implementation phases, in multiple projects.
• To knowledge transfer documents and facilitate training to transition the ETL solution to the client’s team.

ETL Senior Consultant

Confidential, Memphis, TN

Responsibilities:

• To create ETL technical design specification documents.
• To design&develop new OBIA Informatica tasks to load data into the Oracle BAW (Business Analytics Warehouse).
• To work on customizing the existing pre-built out-of-the-box OBIA Informatica mappings to extend the functionality as per the design.
• To add and schedule Informatica tasks through the DAC (Data Warehouse Administration Console).
• To support the client through ETL Requirements, Build/Test and Production Implementation phases, in multiple projects.

ETL Senior Consultant

Confidential

Responsibilities:

• To create technical design specification documents, delegate work to the offshore team and to review the code and unit test results.
• To design&develop new Informatica mappings to load data into the Oracle BAW (Business Analytics Warehouse).
• To work on customizing the existing pre-built OBIA Informatica mappings that came out of the box from OBIEE.
• To add and schedule Informatica tasks through the DAC (Data Warehouse Administration Console).
• To develop Python and Linux scripts to accomplish various task associated with Flat File ETL loads.

ETL Senior Consultant

Confidential

Responsibilities:

• To create ETL technical design specification documents.
• To design&develop new OBIA Informatica tasks to load data into the Oracle BAW (Business Analytics Warehouse).
• To work on customizing the existing pre-built out-of-the-box OBIA Informatica mappings to extend the functionality as per the design.
• To add and schedule Informatica tasks through the DAC (Data Warehouse Administration Console).
• To support the client through ETL Requirements, Build/Test and Production Implementation phases, in multiple projects.

ETL Senior Consultant

Confidential

Responsibilities:

• To create technical design specification documents, delegate work to the offshore team and to review the code and unit test results.
• To design&develop new Informatica mappings to load data into the Oracle BAW (Business Analytics Warehouse).
• To work on customizing the existing pre-built OBIA Informatica mappings that came out of the box from OBIEE.
• To add and schedule Informatica tasks through the DAC (Data Warehouse Administration Console).
• To develop Python and Linux scripts to accomplish various task associated with Flat File ETL loads.

Project Manager

Confidential

Responsibilities:

• To participate in the initial assessment study of the client’s current Informatica environment and document it.
• To provide technical suggestions on how to build Informatica environments based on best industry practices, and to come up with an SOW that is specific for the client’s requirements.
• To guide and work with the Informatica resource, on building the Informatica 9.5.1 environments for the client and also migrating the existing code to the new environments.
• To review and sign off the Smoke Test, Code Migration and Regression test of the Informatica jobs in the newly created environments.
• To create the Project Sign Off/ Closure document and get it signed off from the client.

ETL Senior Consultant

Confidential

Responsibilities:

• To perform requirements analysis.
• To develop technical specification documents by translating the existing Oracle stored procedures in the form of specs.
• To design the Informatica solution, after getting sign off from the customer on the specs.
• To conduct code review and to suggest any changes/performance improvements in the code.

ETL Project Lead

Confidential

Responsibilities:

• To come up with the Informatica Analysis-phase approach for the impact analysis of the SAP systems merger.
• To develop a large number of Informatica Metadata Repository queries to automate the analysis phase of the project, which in-turn help save a lot of efforts and cost, as compared to manual analysis of interfaces.
• To develop Oracle PL/SQL Stored Procedures to aid in the automation of the impact analysis, to help save cost.
• To contribute to the Architectural Design Document for the Informatica solution architecture for the implementation phase.
• To come up with the Effort estimates, Cost estimates and Resource plan for the project.

ETL Designer

Confidential

Responsibilities:

• Drafting and developing Source to Target Design documents for the developers to code the programs/mappings that load into the Enterprise Data Warehouse;
• Drafting and developing detailed design documents, including Extract, Transform, Load (ETL) instructions for the developers to code the Informatica mappings;
• Designing Informatica SAP BCI (Business Content Integration) mappings to extract data from SAP system and to load into a Microsoft SQL Server relational Database;
• Ensuring that the development team delivers the unit-tested code on time, and coordinating the migration of the code across environments after System Integration Testing and User Acceptance Testing.

ETL Senior Consultant

Confidential

Responsibilities:

• To lead and co-ordinate the ETL Informatica efforts in implementing the data mart, and to work with and mentor the Development team, DBA, Verification and validation team, Risk team and Senior management to work through the various challenges and to take care of delivery.
• Creating low level design documents for ETL developers.
• Performing code review and approving the code to higher environment.
• Designed Error handling / Exception handling strategies and implemented using Informatica.
• Worked extensively on Informatica Metadata Repository (OPB) queries.

Project Manager

Confidential

Responsibilities:

• Solution Delivery Transformation Program (US) is an Application Maintenance and Application Development Project in which Confidential ; USA has outsourced the application maintenance/development of the Data Warehousing applications to Confidential Technologies.
• The scope of the project involves application maintenance/development of the entire Data Warehousing solution that is majorly segregated into two Data Warehousing environments; Upstate New York and Downstate New York, in both places the business being the same, supporting the Power and Gas related financial, power-plant related, gas pipe network and flow related and customer related statistical data management and reporting.
• The upstate system is a Data Warehouse hosted on DB2 supported by DataStage on the ETL front and BusinessObjects on the Reporting front. The downstate system is a collection of Data Marts hosted on Oracle supported by Informatica on the ETL space and MicroStrategy on the Reporting space.
• Received a Feather in my cap (FIMC) Award from Confidential for the excellent Delivery and Management of the NG project and for exceeding customer expectations.
• In addition to the Application Maintenance, Confidential US Business had multiple enhancements (Application Development works) in the pipeline.
• Each enhancement is being treated as an Application Development project. The project gets kicked off based on business priority and availability of funds in the respective business unit
• In such a space demand for resources keeps fluctuating and there are frequent changes in the overall team structure.
• Developed standard checklists, Implementation Plan, Quality Assurance Plan, Templates of various deliverables which helped program to meet the fluctuating demands on project front and quick ramp up/ramp downs.

ETL Project Lead

Confidential

Responsibilities:

• To come up with designs, defining technical solutions, and to code, test, debug and deliver Informatica PowerCenter mappings and workflows and Informatica PowerExchange Datamaps.
• To train the team and to make sure to bring them up to speed on features of the ETL tool (Informatica) on Change Management/Version Control, Deployment Groups, Labeling etc.
• Mentor and assist other developers on various technical challenges/version control concerns/ clearing various doubts on ETL tool related specific questions as and when needed.
• Interaction with the Infocrossing data analyst to get clarity in the conversion requirements for specific VSAM files.