SUMMARY:

• Ten plus years of IT/ Engineering experience as ETL Team Lead / Architect / Senior Data Warehouse Developer
• Technical proficiency in Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling, Development, Testing, Creating Report and Documentation.
• Lead offshore teams and provided technical guidance to team members
• Nine Plus years of Informatica PowerCenter 9.6/9.5/8.6/8.1 experience
• Three Plus years of Business Intelligence experience using Crystal reports Enterprise XI, SSRS, Business Objects XI R2/R3 and OLAP.
• Nine Plus years of experience using Netezza, Oracle, DB2, MS SQL Server, SQL, XML, PL/SQL, SQL*Plus and SQL*Loader
• Nine Plus years of experience in PL/SQL Stored Procedures, Packages, .NET, C#.
• Good understanding of Dimensional Data Modeling experience using Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling using ERWIN 4.5/4.0.
• Good experience in different industries including Health Insurance, Financial, Retail and Publishing.
• Experience in all aspects of the Software Development Life Cycle which includes Analysis, Design, Development, Testing, Implementation and Support with specific focus on development.
• Experience in coordinating with Business Analysts, QA team, DBA team and End Users at various stages of Software life cycle.
• Experience in Scrum, Agile Methodology.

TECHNICAL SKILLS:

Data Warehouse: Informatica PowerCenter 9.6/9.1/8.6/7.1 Business Objects Data Integrator (BODI), PowerMart 9.0/8.2, PowerConnect, OLAP, OLTP, SSIS

BI & Reporting: Crystal Report XI/9.0, SSRS, Cognos 8.0, Business Objects XI R2/R3

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional, ERWIN 4.5/4.0

Databases: Netezza, Oracle 12i/11g/10g, MS SQL Server 2005/2000, MySQL, Postgres, IBM DB2, PL/SQL, SQL*Loader, Developer 2000

Languages: PL/SQL, Java, C, C++, VB

PROFESSIONAL EXPERIENCE:

Confidential, Santa Ana, CA

ETL Team Lead/Architect

Responsibilities:

• Interacted with Business Community, Business Analysts and Database Administrators to identify and analyze business requirements for new and existing projects.
• Lead offshore team and provided technical guidance to team members
• Lead projects in different phases of analysis, design, coding, testing and documentation.
• Extensively worked on Data Modeling, Start Schema, Data Marts, ODS, MDM and ETL Methodologies
• Created Technical Design Document
• Extensive development using Informatica 9.6/9.1, testing, debugging and finally implementing requirements.
• Performance tuning of ETL code
• Worked extensively on PL/SQL DML and DDL statements and Stored Procedures.
• Lead review process of Data Model, Data mapping, and testing for related projects.
• Implemented Scrum Methodology and Software Development Life Cycle.

Confidential, Wichita, KS

Senior ETL Developer/Lead

Responsibilities:

• Interacted with the Business Community, QA team and Database Administrators to identify and analyze the business requirements for new or existing project and data realties.
• Performed both ETL Architect and Developer role.
• Involved in creating Technical Design Document, coding by using Informatica 8.6, testing, debugging and finally implementing the requirement.
• Involved in creating reports using Business Objects, Cognos.
• Lead the review process of Data mapping and testing for related projects.
• Mentored junior developers and people from other background.

Confidential, Lewisville, TX

Senior ETL Developer

Responsibilities:

• Lead projects in different phases of analysis, design, coding, testing and documentation.
• Extensively worked on Data Modeling, Data Marts, and ETL Methodologies
• Involved in creating Technical Design Document, coding by using Informatica 8.6, testing, debugging and finally implementing the requirement.
• Performed Code review for related projects and mentored junior developers with best practices.
• Worked on Production support to maintain the existing code.
• Implemented Agile Methodology and Software Development Life Cycle.

Confidential, Buffalo, NY

ETL Tech Lead

Responsibilities:

• Interacted with the ETL Architect, End User and Business Analysts to identify and analyze the business requirements for new or existing project.
• Worked and updated the existing Data Modeling using Erwin 4.5 to improve overall efficiency.
• Lead the review process of Data Model, Data mapping, Data quality and testing for related projects.
• Involved in creating Technical Design Document, coding by using Informatica 8.5, testing, debugging and finally implementing the requirement.
• Designed and Developed PL/SQL stored procedures and packages to create generic programs.
• Involved in Performance Tuning of the existing project and improved the functionality of the code.
• Created simple report for upper management using Business Objects R2.
• Created Best Practice documentation and mentored junior developers.

Confidential, Parsippany, NJ

Team Lead

Responsibilities:

• Lead a medium Project with 3 off - shore developers and 1 on-site developer.
• Interacted with the business community and database administrators to identify the business requirements.
• Extensively worked on Architecture, Design, Performance tuning, Code review and Implementation.
• Worked extensively on different framework of .NET

Confidential, Houston, TX

Informatica Developer

Responsibilities:

• Wrote documentation to describe program development, logic, coding, testing, changes and corrections to build Monthly Data mart and Bank Card Services Data Warehouse.
• Implemented Aggregator, Sorter, Router, Filter, Joiner, Expression, Lookup, Update Strategy, Union and Sequence Generator transformations.
• Used Debugger to test the mapping and fixed the bugs.
• Developed Test Cases for Unit, Integration and System testing and provided solutions for Test Reports.

Confidential

Application Developer

Responsibilities:

• Worked on different framework of .NET
• Instrumental in designing the database with the help of Entity Relationship diagrams and models.
• Participated in design and development of all the tables, views in Oracle.
• Wrote PL/SQL stored procedures/functions to build business rules, requirements.