SUMMARY:

• Over 10 years of hands on experience in the software industry.
• Currently working as an ETL Architect, with End to End Data warehouse designing skills.
• “Informatica Certified Developer”
• Very Good hands on experience in Informatica Power Center.
• Expertise in Relational Data Modeling with very good focus on creating Physical Models and Dimensional Data Modeling in designing Datamart and Datawarehouse
• Experienced in design and implementation of Star Schema, Snowflake Schema.
• Experience in writing complex SQL and PL/SQL in oracle/Netezza.
• Excellent Analytical, communication and interpersonal skills, with the ability to manage responsibilities individually or as part of a team environment.
• Project Lead - managing delivery, team, and allocation of tasks.
• Proven client-facing skills, outstanding project success record, communication and collaboration excellence.
• Good understanding of reporting tools, with some past experience in OBIEE.
• Very good ability to handle Projects from end to end, involving ETL Architecture, Designing, Database designing, Reporting and front end.
• Very good Analytical ability and quick learner to adapt to any BI technology ETL/Reporting/Database.
• Experience in UNIX and WINDOWS environment
• Scheduling Tools CTRL-M, Tidal
• Getting Trained in Informatica MDM.

TECHNICAL SKILLS:

Business Intelligence: Data Warehousing, Informatica 9.5, Cognos 8, OWB, OBIEE 10.1.3.4,ODI 10.1.3

Database: Oracle 10g, Netezza

Languages: SQL, PL/SQL

Scheduling Tools: CTRL-M, Tidal

PROFESSIONAL EXPERIENCE:

Confidential, NY

ETL Architect/Team Leader/ Programmer

Responsibilities:

• Designing of Overall ETL Architecture.
• Database Architecture designing.
• Detailed designing and coding of modules assigned.
• Code Review and Migration.
• Managing the Overall Project from client side.
• Work closely with developers to improve the overall design and performance of ETLs.
• Decode complex Queries to lay out a design of Informatica mappings.
• Perform Integration testing
• Production Support and Issue resolution
• Convert Complex Queries into PLSQL programs to be executed from Informatica.

Environment: Informatica Power Center 9.1, Netezza, SQL, PLSQL, Tidal, UNIX

Confidential, NY

ETL Architect/Team Leader/ Programmer

Responsibilities:

• Understand and Decode existing ABAP code.
• Development of Informatica Code.
• ETL Architecture and Development of Error Reporting Module.
• Overall Testing of the Project for Business Sign off.
• Perform Integration testing
• Production Support and Issue resolution
• Coordinate with Micro strategy team for Production testing.
• Understand Business Pain Points and change in requirement in Report and lead to execute CRs in ETL.
• Perform Data testing to Match Production Data with Existing SAP reports.

Environment: Informatica 9.5, SAP-ABAP, SQL, Netezza, Tidal, UNIX

Confidential

Team Leader / Programmer

Responsibilities:

• Understanding the Business and reporting requirement.
• ETL architecture and Design.
• Development of SQL and PLSQL code.
• Development of Informatica Code.
• Overall Testing of the Project.

Environment: Informatica 8, SQL/PLSQL, Oracle 10g, UNIX

Confidential

Team Leader / Programmer

Responsibilities:

• Analysis of existing code.
• Architecture and Design changes
• Development of SQL and PLSQL code.
• Development of Informatica Code.
• Changes/Testing in OBIEE code.
• Overall Testing of the Project.

Environment: Informatica 8, SQL/PLSQL, Oracle 10g, OBIEE, UNIX

Confidential

Team Leader / Programmer

Responsibilities:

• Understanding the requirement of ORA from Product Strategy team.
• Understanding the functionality of ORA from Product Managers.
• Understanding and implementing the database design.
• Creation of Architecture and Design documents.
• Creation of ODI Code.

Environment: ODI, OBIEE, SQL, PL/SQL

Confidential

Team Leader / Programmer

Responsibilities:

• Understanding the requirement of CCA from Product Strategy team.
• Understanding the functionality of CCA from Product Managers.
• Understanding and implementing the database design.
• Creation of Architecture and Design documents.
• Creation of ODI and Informatica Code.
• Creation of test reports in Cognos 8.1.
• RPD design & creation of Dashboards in Answers (OBIEE).
• Testing and Debugging of the code.

Environment: Informatica, ODI, OBIEE, SQL, PL/SQL

Confidential

Programmer

Responsibilities:

• Understanding the functionality of Pasteur.
• Understanding the Data model and existing ETL code.
• Enhancement to the existing Data model.
• Creation of OWB code.
• Creation of RPD and Answers in OBIEE.
• Testing and Debugging of the code.

Environment: OWB, OBIEE, SQL, PL/SQL

Confidential

Responsibilities:

• Understanding the functionality of Pasteur.
• Understanding the Data model and existing PL/SQL code.
• Creation of PL/SQL code.
• Analyzing and tuning the PL/SQL code.
• Testing and Debugging of the code.

Environment: OBIEE, SQL, PL/SQL

Confidential

Programmer

Responsibilities:

• Understanding the Functionality of EMTA
• Understanding and implementing the database design
• Creation of Informatica Code
• Creation of Cognos Code
• Testing and Debugging of the code
• Production Support

Environment: Informatica, Congo’s, PL/SQL

Confidential

Programmer

Responsibilities:

• Understanding the business process of the OWS and the functionality of IFS
• Understanding of existing Informatica code
• Creation of Informatica code for Inbound and Outbound Interfaces
• Creation of PL/SQL code
• Unit testing and debugging

Environment: Informatica, PL/SQL, UNIX, Windows

Confidential

Programmer, coordinator

Responsibilities:

• Understanding the Functionality of MRM
• Understanding and implementing the database design
• Creation of Informatica Code
• Creation of Cognos Code
• Client/Onsite coordination.
• Testing and Debugging of the new and existing code
• Production Support

Environment: Informatica, PL/SQL, Windows

Confidential

Programmer, coordinator, Group Leader

Responsibilities:

• Understanding the Functionality of MAXIMO
• Understanding and implementing the database design for Inventory in Confidential shops
• Gathering the requirements through Client/Onsite coordination.
• Creation of Informatica Code
• Testing and Debugging of the new and existing code
• Production Support

Environment: Informatica, PL/SQL, Windows