SUMMARY:

• IT professional with around 9+ years of extensive working experience in Business Intelligence, Data Warehousing, ETL, Reporting technologies and 7+ years as Tech Lead/Informatica Specialist/Architect.
• Strong working experience with various clients ranging from Insurance, Healthcare, Finance, Pharmaceutical, Manufacturing, Media and Entertainment Domains.
• Very strong experience in Informatica Power center suite which includes Mapping Developer, Workflow Manager, Workflow Monitor, Admin Console and Repository Manager.
• Have worked as Powercenter Admin and the duties included installation, upgrades, hotfixes, user access, deployment to various environments, grants.
• Strong experience in Administration and development with Informatica Power Exchange tool for CDC, Datamaps,etc. Also have exposure to Informatica data services, Salesforce sources and targets.
• Have good experience in BO XI, Universe Design, Report Development
• Strong experience in IBM COGNOS Framework manager, Query Studio, Report Studio.
• Experience in design and development of DataWarehouse, Marts and ODS.
• Expert in designing the ETL architecture, Load Strategy, Data Flow.
• Played Business Analyst for some time alongside ETL Lead role which involved business interaction, understanding the requirements, Data Analysis and designing Techno - functional mapping documents.
• Solid understanding of Data Modelling (Star and Snow Flake Schemas), Physical and Logical models, DWH concepts, ER diagrams, Data Flow Diagrams/Process Diagrams.
• Elaborate experience in databases like Oracle and IBM DB2 and database tools like TOAD, AQT, Rapid-SQL, PL-SQL Developer. SQL Developer, MongoDB-JSON.
• Experience and exposure to Big Data concepts, Hadoop, Pig, Hive, scoop.
• Extensive experience in Performance Tuning and optimizing ETL process and coming up with the best design to obtain superior performance.
• Have also worked on creating UNIX shell scripts to automate the ETL process.
• Good understanding of PL/SQL procedures, functions, triggers and other database components.
• Have knowledge on SSIS/RS, BO Data Integrator and Pentaho Kettle(Open Source) ETL tools.
• Excellent soft skills, team building skills. Have played Team Lead/ Technical Lead roles for various projects and handled team as big as 10-12.
• Extensively involved in system analysis development and implementation of Datawarehouse systems (SDLC).
• Good Experience in creation of Quality related documents (Function specification, ETL architecture design, High Level and Low Level design, and Unit Test Case documents).
• Fast Learner, good communication and presentation skills, ability to quickly adapt to the technical environment coupled with very positive user interaction & team spirit.

TECHNICAL SKILLS:

BI, ETL, Reporting Tools: Informatica Powercenter, Informatica Powerexchange, Administration, Informatica Data Services, Salesforce, Business Objects, COGNOS, Data Warehousing, SSIS/RS, Pentaho Kettle Data Integration Tool

Databases: Oracle, IBM DB2, MS SQL Server, SQL, PL/SQL, MongoDB-JSON

Operating System: Windows 10,8,7,XP/NT/2000/98/95, Unix, Mac OS

Scripting Languages: UNIX Shell Script, Batch File, Linux

Others: Rational Rose Product Suite, MS-Project, Visio, Control-M, Maestro and GECS schedulers, JIRA, Remedy, Versioning tools like VSS, Harvest, IJC, SVN

Domains: Annuity & Life Insurance, Manufacturing, Healthcare, Claim processing, Pharmaceutical, Finance, Corporate HR, Media and Entertainment

PROFESSIONAL EXPERIENCE:

Confidential, NJ

BI Architect/Lead

Responsibilities:

• Performed role of a BI Architect/ Lead which includes requirement analysis, designing the Data model, Enterprise ETL Architecture, hands on development, testing, documentation, production deployment, coordinate/lead the team and ensure quality and on-time deliverables.
• Worked on Informatica Power Center, Power Exchange to develop ETL processes.
• Use COGNOS Framework Manager. Query Report/Studio to develop reports.
• Involved working on Oracle 11g databases, designing and creating tables, relations, constraints, indexes.
• Also developed UNIX Shell Scripts to automate the ETL processes.
• Used ERWIN Tool to design Data models.
• Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
• Have built performance-tuned systems with maximum optimization, reusability and ease of operation.
• Created Function specification, High level design document (ETL design architecture) and Low level design document and Unit Test Case, deployment and operational document.
• Role also involves leading the team members, assigning and reviewing their work.

Environment: Informatica Power center (9.1), PowerExchange, IBM COGNOS, ERWIN, Oracle, SQL, UNIX, IJC, CRON job scheduling, Windows XP.

Confidential, NYC

Informatica Specialist /Admin

Responsibilities:

• Performed role of a Informatica Specialist/Informatica Admin which includes requirement analysis, design, development, testing, documentation, production deployment and Administrator tasks.
• Designed ETL Architure using Informatica for implementing various phases of EDW build.
• Worked on Informatica Power Center to develop mappings, sessions and workflows.
• Integrated 4 data sources into EDW, built stage layer and the Warehouse layer.
• Built new ETL process and enhancing some of current processes.
• Involved working on Oracle 10g database, designing and creating tables, relations, constraints, indexes.
• Also developed UNIX Shell Scripts to automate the ETL processes.
• Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
• Have built performance-tuned systems with maximum optimization, reusability and ease of operation.
• Created Function specification, High level design document (ETL design architecture) and Low level design document and Unit Test Case, deployment and operational document.
• Role also involves leading the team members, assigning and reviewing their work.

Environment: Informatica Power center (v8.6.1/9.1), PowerExchange, Oracle, SQL, UNIX, CRON job scheduling, Windows XP.

Confidential, NYC

Informatica Lead

Responsibilities:

• Performed role of a Informatica Lead which includes responsibilities like requirement analysis, building new ETL process, migrating existing ones to Informatica and enhancements, development, test, documentation and production deployment.
• Also built data models, Marts as part of new ETL processes and to enable data exchange with external systems.
• Worked on Informatica PowerCenter to develop mappings, sessions and workflows.
• Involved working on Oracle database, design and create tables, relations, constraints, indexes. Used database tools like TAOD, AQT, Rapid SQL.
• Worked on BO XI to create Reports.
• Also developed UNIX Shell Scripts to automate the ETL processes.
• Also worked on BO Data Integrator to understand and migrate ETL code to Informatica.
• Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
• Have built performance-tuned systems with maximum optimization, reusability and ease of operation.
• Created Function specification, High level design document (ETL design architecture) and Low level design document and Unit Test Case, deployment and operational document.
• Role also involved leading the onshore and offshore team members.

Environment: Informatica (version 9.1), Oracle 10g, SQL, PL/SQL, UNIX, BO XI, GECS scheduling, Windows XP.

Confidential, NJ

Tech Lead/Sr. ETL Developer

Responsibilities:

• Performed role of a Tech Lead/Sr. ETL Developer which includes requirement analysis, design, development, testing, documentation and production deployment.
• Worked on Informatica Power Center to develop mappings, sessions and workflows.
• Used Informatica Power Exchange tool to read source data and generate feeds to external systems.
• Integrated 34 admin systems into IBDW, built stage and stage history layer with error checking strategies.
• Built new ETL process and enhancing some of current processes.
• Worked on ACORD data model which is global standard for Insurance domain, built Marts to enable data exchange with external systems.
• Involved working on IBM DB2 database, designing and creating tables, relations, constraints, indexes.
• Also developed UNIX Shell Scripts to automate the ETL processes.
• Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
• Have built performance-tuned systems with maximum optimization, reusability and ease of operation.
• Created Function specification, High level design document (ETL design architecture) and Low level design document and Unit Test Case, deployment and operational document.
• Role also involved leading the onshore and offshore team members, assigning and reviewing their work.

Environment: Informatica Power center (v8.6/9.1), PowerExchange, IBM-DB2, SQL, UNIX, Maestro scheduling, Windows XP.

Confidential

Responsibilities:

• Performed role of a Tech Lead/Sr. ETL Developer which includes requirement analysis, design, development, testing, documentation and production deployment.
• Worked on Informatica PowerCenter to develop mappings, sessions and workflows.
• Used Informatica PowerExchange tool to read source data and generate feeds to external systems.
• There were 16 life and 5 annuity admins integrated into IBDW and carried to ODS.
• Built stage and stage history layer with error checking strategies.
• The project implemented Standard Feed and Pre-processor architecture which is a standardized, reusable method of loading all the admin source systems with reduced complexity.
• Worked on ACORD data model which is global standard for Insurance domain, built Marts to enable data exchange with external systems.
• Involved working on IBM DB2 database, designing and creating tables, relations, constraints, indexes.
• Also developed UNIX Shell Scripts to automate the ETL processes.
• Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
• Have built performance-tuned systems with maximum optimization, reusability and ease of operation.
• Created Function specification, High level design document (ETL design architecture) and Low level design document and Unit Test Case, deployment and operational document.
• Role also involved leading the onshore and offshore team members, assigning and reviewing their work.

Environment: Informatica Powercenter(v8.6), PowerExchange, IBM-DB2, SQL, UNIX, Maestro scheduling, Windows XP.

Confidential

Responsibilities:

• Performed role of a Tech Lead/Sr. ETL Developer which includes requirement analysis, design, development, testing, documentation and production deployment.
• Worked on Informatica Power Center to develop mappings, sessions and workflows.
• Used Informatica Power Exchange tool to read source data and generate feeds to external systems.
• There were daily, weekly and monthly processes. The vendor files provided in mainframe landing area are to be loaded into the CIDW and then Itracker mart using informatica.
• Involved working on IBM DB2 and Oracle databases, designing and creating tables, relations, constraints, indexes.
• Also developed UNIX Shell Scripts to automate the ETL processes.
• Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
• Have built performance-tuned systems with maximum optimization, reusability and ease of operation.
• Created Function specification, High level design document (ETL design architecture) and Low level design document and Unit Test Case, deployment and operational document.

Environment: Informatica Power center (v8.5), Power Exchange, IBM-DB2, Oracle, SQL, UNIX, Maestro scheduling, Windows XP.

Confidential

ETL Developer/Designer

Responsibilities:

• Performed role of a ETL Designer/Developer which includes requirement analysis, design, documentation
• Worked on Pentaho Kettle to develop the ETL jobs.
• Involved working on IBM DB2 and Oracle databases, designing and creating tables, relations, constraints, indexes.
• Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
• Have built performance-tuned systems with maximum optimization, reusability and ease of operation.
• Created Function specification, High level design document (ETL design architecture) and Low level design document and Unit Test Case, deployment and operational document.

Environment: Pentaho Kettle, IBM-DB2, Oracle, SQL, Windows XP.

Confidential

Informatica ETL Developer

Responsibilities:

• Performed role of a ETL Developer which includes requirement analysis, design, development, testing, documentation and production deployment.
• Worked on Informatica Power Center to develop mappings, sessions and workflows.
• Built Staging layer with error checks, WH and Marts to enable data exchange with external systems.
• Involved working on Oracle database, designing and creating tables, relations, constraints, indexes, PL-SQL functions and procedures.
• Also developed UNIX Shell Scripts to automate the ETL processes.
• Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
• The weekly historical load of data from different geographic locations like NA, LA, WE, CE, AAI, GC, NEA. The system developed used to receive SAP-BW file from Gillete which was then converted into P & G standards and loaded into the ADW system.
• The process was designed to run on a weekly basis for all the 7 different regions. The weekly run timings for different regions were different
• Have built performance-tuned systems with maximum optimization, reusability and ease of operation.
• Created Function specification, High level design document (ETL design architecture) and Low level design document and Unit Test Case, deployment and operational document.
• Role also involved leading the onshore and offshore team members, assigning and reviewing their work.

Environment: Informatica Power center(v7 & 8), Oracle, SQL, UNIX, Control M schedulers, Harvest versioning tool, VSS, Windows XP.

Confidential

Responsibilities:

• Performed role of a ETL Developer which includes requirement analysis, design, development, testing, documentation and production deployment.
• Worked on Informatica Power Center to develop mappings, sessions and workflows.
• Built Staging layer with error checks, WH and Marts to enable data exchange with external systems.
• Involved working on Oracle database, designing and creating tables, relations, constraints, indexes, PL-SQL functions and procedures.
• Also developed UNIX Shell Scripts to automate the ETL processes.
• Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
• The weekly historical load of data from different geographic locations like NA, LA, WE, CE, AAI, GC, NEA. This system ran separately on weekly basis for all the above mentioned 7 locations. The weekly run timings for different regions were different.
• Have built performance-tuned systems with maximum optimization, reusability and ease of operation.
• Created Function specification, High level design document (ETL design architecture) and Low level design document and Unit Test Case, deployment and operational document.
• Role also involved leading the onshore and offshore team members, assigning and reviewing their work.

Environment: Informatica Power center (v7 & 8), Oracle, SQL, UNIX, Control M schedulers, Harvest versioning tool, VSS, Windows XP.

Confidential

Business Objects Report Developer

Responsibilities:

• Performed role of a BO Report Developer which includes requirement and impact analysis, design, development, testing, documentation and production deployment.
• Worked on Business Objects to develop reports.
• Built complex universe and reports with prompts, custom template and design with daily, weekly, quarterly and yearly frequencies.
• Involved working on Oracle Discoverer to understand existing report and convert them to BO.
• Responsibility also involved designing and creating tables, relations, constraints, indexes.
• Extensively involved in writing SQL queries (sub queries and join conditions)
• Have built performance-tuned systems with maximum optimization, reusability and ease of operation.
• Had some exposure to Oracle Apps forms in due course.
• Created Function specification, High level design document (design architecture) and Low level design document and Unit Test Case, deployment and operational document.
• Role also involved leading the onshore and offshore team members, assigning and reviewing their work.

Environment: Business Objects (v6.0) Oracle, SQL, Oracle Discover, Windows XP.