SUMMARY

• Ten years of expertise in data warehousing projects including Data Integration, Data Migration, Data Enablement, Enterprise Data Management and Enterprise Data quality using Informatica
• Five years of expertise in leading the ETL projects throughout the project life cycle right from requirements elicitation till production support
• Proficient at design and implementation of Optimized, high quality, robust ETL solutions as per the business requirements
• In depth understanding of Enterprise Data Warehouse Architecture, data warehouse modeling approaches Ralph’s dimensional modeling and Inmon’s normalized data modeling and good exposure to the Data Vault modeling, a database modeling method
• Extensive experience working with Informatica power center, Informatica Data Quality Analyst and Developer, relational databases Oracle, Teradata and heterogeneous data sources including FLAT files, Excels and XML
• Good exposure to Informatica Cloud, Business Objects Data Services and Open Source ETL tool Pentaho
• Exposure to reporting tools Business Objects and Micro Strategy
• Exposure to PL/SQL
• Good understanding of Oracle and Teradata Architectures
• Strong at analyzing and building complex SQL Queries in Oracle and Teradata
• Expertise in Job scheduling tool $U(Dollar Universe) and exposure to DAC, Autosys
• Expertise in deployment tools HP - Kintana, ICART
• Good exposure to automation of jobs using UNIX Shell scripts, Linux Scripting
• Well versed with performance tuning of ETLS and SQLs in Oracle and Teradata
• Extensive experience in implementing projects using Agile (kanban) and waterfall methodologies
• Expertise in detail oriented documentations and converting the Business requirements into technical design documents
• Well recognized for the high quality deliverables
• Good at gaining functional knowledge and applying it to deliver extra value to the business teams
• Strong analytical, problem solving skills, passionate towards challenging jobs
• Excellent communication skills and abilities to interact with various cross functional teams including business teams to ensure the successful delivery of the projects
• Quick adaptability to new tools, technologies with abilities to work as a good independent player and a very good team player as well

TECHNICAL SKILLS

ETL Tools : Informatica 8.6/9.5, BODS, Pentaho, Informatica Cloud

Data Quality Tools: IDQ Analyst, Developer

RDBMS Tools : Toad, SQL Assistant, SQL Developer

RDBMS : Oracle9i/10g/11g/R12, Teradata

Version Control Tools: PVCS, SVN

Deployment Tools: Kintana, ICART

Job Scheduling Tools: Dollar Universe, DAC,Autosys

Scripting Languages: Unix Shell Script, Linux Scripting

Business Intelligence Tools: Business Objects, MicroStrategy

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer

Confidential, Herndon, VA

Responsibilities:

• Elicitation of requirements
• Review the requirements from business
• Source system analysis
• High level and Detail level designing
• Designing Data Quality Solutions as per the business requirements
• Development and review of ETLs part of the data quality solutions
• Resolve performance bottlenecks by optimizing the mappings, sessions and workflows
• Development of JILs in Autosys to schedule the jobs
• Testing the ETLs and Autosys jobs
• Build and deployment of baselines to higher environments
• Support SIT and UAT phases
• Ensuring successful delivery of the project within the timelines defined

Environment: Informatica Power center, Informatica IDQ Analyst, IDQ Developer, Oracle, Unix, BO, EDW, Autosys, SVN, ICART

Sr. Informatica Developer

Confidential, Herndon, VA

Responsibilities:

• Elicitation of requirements
• Review the requirements from business
• Source system analysis
• High level and Detail level designing
• Designing Data Quality Solutions as per the business requirements
• Development and review of ETLs part of the data quality solutions
• Resolve performance bottlenecks by optimizing the mappings, sessions and workflows
• Development of JILs in Autosys to schedule the jobs
• Testing the ETLs and Autosys jobs
• Build and deployment of baselines to higher environments
• Support SIT and UAT phases
• Ensuring successful delivery of the project within the timelines defined

Environment: Informatica Power center, Informatica IDQ Analyst, IDQ Developer, Oracle, Unix, BO, EDW, Autosys, SVN, ICART,M MicroStrategy

Sr. Informatica Developer

Confidential, Herndon, VA

Responsibilities:

• Elicitation of requirements
• Review the requirements from business
• Source system analysis
• High level and Detail level designing
• Designing Data Quality Solutions as per the business requirements
• Development and review of ETLs part of the data quality solutions
• Resolve performance bottlenecks by optimizing the mappings, sessions and workflows
• Development of JILs in Autosys to schedule the jobs
• Testing the ETLs and Autosys jobs
• Build and deployment of baselines to higher environments
• Support SIT and UAT phases
• Ensuring successful delivery of the project within the timelines defined

Environment: Informatica Power center, Informatica IDQ Analyst, IDQ Developer, Oracle, Unix, BO, EDW, Autosys, SVN, ICART,Microstrategy

Sr. Business Intelligence Engineer

Confidential, Raleigh, NC

Responsibilities:

• Interaction with business team for the elicitation of requirements
• Source system Analysis
• Impact Analysis
• Designing ETLs as per the business requirements
• Development of ETLs
• Implementation of Change Data Capture (CDC) for slowly changing dimensions (SCD type1,type2 and type3)
• Loading data into Dimensions and Cubes, adding new dimensions and cubes to the existing environment using TM1
• Manage TM1 data through TM1 Reports (Active Form & Slice)
• Deployment of TM1 data into production environment preparation of unit test case documents
• Unit testing at various levels of the ETLs
• Scheduling ETLs in the job scheduling tool DAC
• Testing the Scheduled jobs
• Code Reviews
• Root Cause Analysis and resolution of the issues in Production
• Resolve performance bottlenecks by optimizing the mappings, sessions and workflows

Environment: Informatica, BODS, Pentaho, Infomatica Cloud, SFDC, SAP, Oracle, Linux, BO, EDW, BAW, Data Vault, DAC.

Technology Lead and Developer

Confidential, San Jose, CA

Responsibilities:

• Interaction with business team for the elicitation of requirements
• Source system Analysis
• Coordination with offshore and cross functional teams
• High level and Detail level Designing
• Designing ETLs as per the business requirements
• Development and Review of ETLs
• Preparation of unit test case documents
• Unit testing at various levels of the ETLs
• Resolution of performance bottlenecks by optimizing the ETLs using Push down optimization (PDO) and session partitioning
• Development of scheduling jobs in the job scheduling tool $U
• Testing the Scheduling jobs
• Documentation: Technical specification documents
• Creation of packages in the tool Kintana to migrate the code from one environment to other
• To ensure successful delivery of the project within the defined timelines
• Release Management

Environment: Informatica, Oracle, Teradata, Unix, PVCS, Kintana, Dollar Universe

Technology Lead and Developer

Confidential, San Jose, CA

Responsibilities:

• Source system Analysis
• Coordination with offshore and cross functional teams
• High level and Detail level Designing
• Designing ETLs as per the business requirements
• Development and Review of ETLs
• Preparation of unit test case documents
• Unit testing at various levels of the ETLs
• Resolve performance bottlenecks by optimizing the mappings, sessions and workflows
• Development of scheduling jobs in the job scheduling tool $U
• Testing the Scheduling jobs
• Documentation: Technical specification documents
• Creation of packages in the tool Kintana to migrate the code from one environment to other
• To ensure successful delivery of the project within the defined timelines
• Release Management

Environment: Informatica, Oracle, UNIX, PVCS, Kintana, Dollar Universe

Technology Lead and Developer

Confidential, San Jose, CA

Responsibilities:

• Source system Analysis
• Coordination with offshore and cross functional teams
• High level and Detail level Designing
• Designing ETLs as per the business requirements
• Development and Review of ETLs
• Preparation of unit test case documents
• Unit testing at various levels of the ETLs
• Resolve performance bottlenecks by optimizing the mappings, sessions and workflows
• Development of scheduling jobs in the job scheduling tool $U
• Testing the Scheduling jobs
• Documentation: Technical specification documents
• Creation of packages in the tool Kintana to migrate the code from one environment to other
• To ensure successful delivery of the project within the defined timelines
• Release Management

Environment: Informatica, Teradata, Oracle, UNIX, PVCS, Kintana, Dollar Universe