Summary:

• Over 12 years of experience working in IT industry with 10 years of experience in Data warehouse, data marts and ETL development, maintenance, testing, business requirements analysis, administration and documentation.
• Experienced in designing and implementing star, snowflake dimensional model.
• Experience in designing and implementing 3NF data model.
• Experienced in implementing conformed and slowly changing dimension of all type.
• Experienced in requirement gathering, architecture, analysis, designing and developing of DWH projects.
• Has worked as Data Architect/ETL Architect in developing and implementing the DWH solutions across functional domains like Telecom, Retail, hospitality and Insurance
• Experience working in production support environment
• Proficient in Informatica administration work including installing and configuring Informatica PowerCenter and repository servers on Windows and UNIX platforms, backup and recovery, folder and user account maintenance.
• Experience in Informatica 9.0/8.6/8.1 client tools - Designer, Repository Manager and Workflow Manager.
• Experience in ORACLE, Netezza ,DB2, Teradata and Aster database programming
• Knowledge of reporting tools like Cognos, BO and MSTR.
• Knowledge of reporting tools like Micro-Strategy, Business Object, Tableu.
• Experience working individually and also in teams of different sizes. Had managed the team size of up to 25 peoples.

Technical skills:

Professional Experience:

Confidential

Lead Data Architect

Responsibilities:

• Guiding and mentoring the team.
• Work with client director and manager to define the strategic roadmap.
• Working as a Data Architect which involves defining the logical data model, physical data model and data mappings.
• Responsible for defining conformed dimension, facts and integrate them with the Enterprise logical data model.
• Worked on defining the model for Self Service BI. There are no canned reports and business can pretty much slice and dice the data on adhoc basis. The solution is implemented on HDFS/ASTER/Tableau suite and also on Teradata/MSTR suite.
• Responsible for both normalized data modelling and dimensional data modelling.
• Responsible for interacting with and business analysts, business users, SMEs.

Environment:

Oracle 11g, UNIX, Erwin, Teradata, Aster

Confidential

Solution Architect

Responsibilities:

• Working as a Solution Architect which involves Defining the data model and ETL architecture.
• Create the Physical Data model, Logical Data model, Technical Design, high level low level design documents, creating ETL specifications, test cases documents for all the new mappings developed for production applications in compliance with SDLC processes
• Responsible for interacting with and business analysts, business users, SMEs technical architects.
• Defined and Delivered Re-usable metadata capture solution.
• Delivered many re-usable components.
• Responsible for End to End delivery of Design and Code

Environment:

Oracle 11g, UNIX, Erwin, Quest TOAD 9.0, Visio 2003, Microsoft Project 2003, Microsoft Visual SourceSafe

Confidential

Data Architect

Responsibilities:

• Working as a Consultant which involves creating Data Model, Data Mapping, ETL design and leading ETL development using Informatica PowerCenter client tools
• Create the Technical Design, high level low level design documents, creating ETL specifications, test cases documents for all the new mappings developed for production applications in compliance with SDLC processes
• Responsible for interacting with and business analysts, business users, SMEs technical architects whenever there is a need for the redesign of the existing ETLs and process improvements
• Responsible for overall quality of deliverables.
• Delivered many re-usable components.
• Responsible for mentoring the new resources brought into the team
• Responsible for End to End delivery of Design and Code

Environment:

Informatica PowerCenter 8.6, IBM DB2, AIX UNIX 5.3, OS/400, DB2/400, Erwin, Widows XP, Quest TOAD 9.0, Visio 2003, Microsoft Project 2003, Microsoft Visual SourceSafe ,

Confidential

ETL Lead

Responsibilities:

• Exclusively design ETL Logging and Reject re-processing logic.
• Design and develop Key-Map logic to enhance performance
• Working as a ETL Tech Lead.
• Responsible for creating ETL design and leading ETL development using Informatica PowerCenter client tools
• Responsible for preparing and tracking Project Plan.
• Preparing ETL Estimates and negotiating the same with client.
• Create the Technical Design, high level low level design documents.
• Create ETL specifications, test cases documents for all the mappings developed.
• Responsible for overall quality of deliverables.
• Delivered many re-usable components.
• Responsible for mentoring the new resources brought into the team
• Responsible for End to End delivery of Design and Code
• Performed the code reviews
• Created ETL CoE Standards document for ETL compliance

Environment:

Informatica PowerCenter 8.1/7.1.4, Oracle 10g, IBM DB2, HP UNIX, Widows XP, Quest TOAD 8.0, Workflow Manager, Data Flux, First Logic and Microsoft Visio 2003

Confidential

ETL Tech Lead/Informatica Administrator

Responsibilities:

Support Lead/ADMIN WORK:

• Responsible for updating and configuring Informatica 8.1.1 to Informatica 8.6.1
• Responsible for setting up of High Availability Informatica environment.
• Responsible to complete loading the data into DWH with in SLA.
• The SLA met percentage is in the range of 98.2 -99.99
• Responsible for tuning the existing mappings so as to reduce the total data load run time
• Responsible for delivering many tuning projects to clients.
• Responsible for delivering many functionality enhancement projects to client.
• Design and develop the Netezza archiving strategy.
• Environment:
• Informatica Power Center 8.1.1, Oracle 10g, Sun Solaris 5.9, Windows XP, Windows 2003 Server, Quest TOAD 8.0, Netezza

Confidential

Tech Lead

Responsibilities:

• Code reviews for the code developed by peer developers
• Carried source control on behalf of the team
• Responsible for preparing and tracking Project Plan.
• Preparing ETL Estimates and negotiating the same with client.
• Create the Technical Design, high level low level design documents.
• Create ETL specifications, test cases documents for all the mappings developed.
• Responsible for overall quality of deliverables.
• Delivered many re-usable components.
• Responsible for mentoring the new resources brought into the team
• Performed the code reviews

Environment:

Data Stage Server edition, Oracle 9, Sun Solaris, Windows XP, Windows 2003 Server, Quest TOAD 8.0

Confidential

Tech Lead

Responsibilities:

• Code reviews of the code developed.
• Carried source control.
• Create the Technical Design, high level low level design documents.
• Create ETL specifications, test cases documents for all the mappings developed.
• Responsible for overall quality of deliverables.
• Responsible for mentoring the new resources brought into the team

Environment:

Informatica 7.1, Oracle 9, Sun Solaris, Windows XP, Windows Server, TOAD

Confidential

Software Developer

Responsibilities:

• Code reviews of the code developed.
• Developing ETL mappings
• Carried source control.
• Create the Technical Design, high level low level design documents.
• Create ETL specifications, test cases documents for all the mappings developed.
• Responsible for overall quality of deliverables.
• Responsible for mentoring the new resources brought into the team

Environment:

Informix, C, C , Unix, Informatica, Cognos

Confidential

ASET

Responsibilities:

• Data modeling in Master-Craft.
• Code development using Q , Power Builder.
• Peer review of the code.

Environment:

Oracle, C , Q , Power Builder, Tuxedo, Master Craft