SUMMARY

• 10 years of experience in software development comprising of working on ETL, Datawarehouses, Databases and BI.
• Hands on experience as an ETL architect with experience in designing and leading development and implementation of ETL solutions for complex ETL systems.
• Expertise in developing resource constrained and cost constrained technical solutions in ETL and Informatica based on business requirements adhering to organization architectural and quality standards.
• Worked extensively in requirements gathering, effort estimations and solution design and development.
• Worked extensively in technology evaluation and decision making on technologies apt for a project.
• In - depth knowledge and strong programming skills in Informatica, Oracle, SQLServer.
• Wide area of expertise in resolving performance issues and production issues of ETL jobs.
• Good knowledge of various information systems and architecture standards for building ETL solutions.
• Excellent problem solving, issue analysis and impact analysis skills of production and pre-production technical issues.
• Experience working in Healthcare, Financial and Automotive domains.
• Good experience in owning and delivering end to end software product deliverables right from requirements gathering to design to getting development done from technical teams, supporting testing processes to delivering end product to client and providing support during warranty period.
• Excellent team player with strong problem solving skills, interpersonal, oral and written communication skills, highly motivated and adaptive with ability to grasp things quickly.
• Good managerial skills, hands on experiences as a team lead for technical development teams.
• Expertise in building datawarehouses using star and snowflake schemas.
• Experience in relational database design in Oracle.
• Experience in developing batch jobs in Oracle.
• Experience working on Informatica PowerCenter9.x and PowerExchange, Oracle 11i, SQLServer2008, Netezza, UNIX.
• Experience in different scheduling tools like Autosys and CA7.
• Good knowledge of Business Intelligence and Data Warehousing.
• Experienced in Agile Scrum methodology.
• Good training skills, experience in conducting training workshops on Oracle, PL/SQL and Informatica.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.x

RDBMS: Oracle, SQLServer, MySQL, Netezza

Tools: TOAD, PL/SQL Developer

Languages: PL/SQL, SQL

Data Modeling: ERwin, Power Designer

Data Profiling: Informatica Data Quality

Scheduling tools: CA7, Autosys, Tiwoli

Version Control: Harvest, VSS

Others: Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Michigan

Informatica Technical Lead / ETL Architect / Sr. Informatica Developer

Responsibilities:

• Requirements gathering, capturing the technical scope involved, deriving the extent of ETL involvement needed in the overall project involving US markets.
• Proposing ETL design for end to end solution starting with data extraction from customer interfaces to data processing, storage and routing data to SAP.
• Reviewing and proposing changes to the data model based on ETL processing involved.
• Estimating efforts (time and resources) for implementing the ETL solution for US markets.
• Documenting the ETL designs for business sign off.
• Capturing differences between Canada and US market requirements, estimating efforts involved in developing new jobs for Canada market and modifying US jobs per Canada market needs.
• ETL code development using Informatica tool to develop the finance related jobs.
• Reviewing the code design periodically to include maximum possibility for reusability so that the code could be reused for Canada markets with minimal changes.
• Regular performance analysis of ETL jobs to check for bottlenecks and addressing them.
• Scheduling of the ETL jobs in Tiwoli.
• Production go live and Hypercare support of the ETL jobs in production.
• Issue analysis for production issues for identifying the root cause for job failure and classifying them as data issues or domain issues.
• Accommodating existing jobs to fix the domain issues and proposing data fixes to address data issues in production.
• Modifying existing ETL jobs to accommodate for dealing with Canada market data while making sure that US market data is not impacted in any way.
• Introducing parallel processing of US and Canada data in ETL jobs to develop the final combined solution for supporting the finance part of TDI with the scope to scale the solution for all class of vehicles.
• Production Hypercare support of the combined solution and fixing data and domain issues.

Confidential, Cleveland, Ohio

ETL Architect / Informatica Technical Lead

Responsibilities:

• Requirements gathering, business needs and project scope capturing for the project. Capturing technical requirements from the business requirements shared by Business Analysts.
• Designing multiple feasible long term and short term ETL approaches for end to end data flow/processing from sources into the data warehouse.
• Documenting the various approaches and the pros and cons, the resources and the effort involved, the estimated dates and tentative plan of development, testing and implementation phases for the purpose of decision making on the finalized approach.
• Designing the architecture for the ETL process end to end flow based on the finalized approach. Estimating the resources and ETL effort involved in the finalized approach and submitting the plan on the ETL work.
• Ongoing discussions with the BA, data modeler for designing the data mart structure, capturing the dependencies and optimizing the SCD type for each of the table in the data mart.
• Orientations to the ETL technical team on the architecture, design, approach and development involved in the project on an ongoing basis to facilitate the development phase of the project.
• ETL component development of mappings, sessions, workflows for various ETL jobs using PowerCentre and PowerExchange. Working on automated scheduling of the ETL jobs based on the frequency and the need of the data loads.
• Designing and developing reusable components for optimization.
• Regular performance analysis for checking the bottlenecks and working on redesigns to clear performance bottlenecks.
• Data analysis for data quality maintenance.
• Consolidating requirements based on client discussions, analyzing source data and creating STM (source to target map) documents for ETL processes.
• Creating design documents for ETL processes and architecture diagrams for data flow across different data marts.
• Writing technical documents for technical design, system testing and implementation tasks.
• Code reviews.
• Leading offshore team, coordinating and assigning day to day tasks and getting development done from offshore.

Confidential, Louisville, Kentucky

Sr. Informatica & SQLServer Developer

Responsibilities:

• Creating mappings in Informatica, creating and running workflows in Informatica for loading data from flat files to SQLServer tables in EBM module.
• Updating existing design documents in ETG and CCG modules.
• Consolidating functional business requirements, designing technical flow documents for EBM module.
• Analysis of requirements and code development in Netezza for provider data processing, provider ranking in ETG module.
• Analysis of requirements and code development in SQLServer for EBM module.
• Code review of Netezza scripts in other modules for requirements discrepancies and standardization process.
• Data analysis for issues raised in UAT and fixing of the issues in scripts for ETG module.
• Developing automated scripts for refresh of Netezza tables.
• Modification of Unix scripts to automate running of Netezza scripts.
• Analysis of business specific data in flat file form for design and creation of target tables in SQLServer database.

Confidential

Sr. Oracle Developer

Responsibilities:

• Consolidating functional requirements, creating LLD documents of the module based on interactions with client.
• Creation of stored procedures to implement core business logics in account receivables and payables sub modules.
• Creation of stored procedures to generate reports.
• Done Interfacing of external system with Oracle Financials module.
• Internal code reviews.
• Taking module functionality introductory sessions.
• Taking project internal PL/SQL training sessions for trainees.
• Worked on Oracle Reports 6i.

Confidential

SAS Developer

Responsibilities:

• Creating procedures, functions.
• Working with base SAS, creating SAS macros and SAS stored procedures.
• Created and published reports in SAS.
• Created database updating automation script using C# and ADO.NET.

Confidential

Quality Analyst

Responsibilities:

• Configuration management of the project using Microsoft VSS.
• Periodic status review of work products.
• Metrics data collection.
• Delivery Inspections.
• Monthly process audits.

Confidential

Quality Analyst

Responsibilities:

• Configuration management of the project using Microsoft VSS.
• Periodic status review of work products.
• Metrics data collection.
• Delivery Inspections.
• Monthly process audits.