SUMMARY:

• Around 10 years of extensive experience in Business Intelligence and Data Warehousing, Design and Implementation of ETL Processes on large scale and small scale projects
• Experience in working on different domains Risk Management, Healthcare, Health and Welfare & Finance.
• Executed End - to-End implementation of Data warehouse project.
• Strong expertise in ETL - INFORMATICA.
• INFORMATICA 8 Administration experience.
• INFORMATICA IDQ experience.
• Netezza and MPP experience.
• INFORMATICA pushdown optimization and Power Exchange experience.
• Expertise on scheduling tools - Control M, Autosys.
• Good knowledge of Oracle Data Integrator 10.1.3.5.
• Experience in Data Modeling using ER Studio and Architecture design experience in OLAP applications.
• Experience of Python Scripting.
• Knowledge of MDM.
• Experience in ingestion, storage, querying, processing and analysis of Big Data using Hadoop technologies and solutions.
• Knowledge of Hadoop ecosystem - HDFS, MapReduce using Python, Hive, Pig, Sqoop, Flume, Oozie, HBase.
• Experience in PowerExchange for integration of Hadoop with PowerCenter to extract and load data.
• Experience in Tableau, Business objects reporting.
• Experience in writing UNIX shell scripts.
• Good SQL/PLSQL experience.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts.
• Got client appreciation from Fidelity, Sapient and Feather in Cap Award from ACS.

TECHNICAL SKILLS:

Database: Oracle 11g/10g/12c Exadata, SQL Server 2012, Sybase, Teradata, Netezza

Operating Systems: UNIX, LINUX, AIX, Windows 95/NT/XP, Solaris.

Programming Languages: C++, SQL, PL/SQL, UNIX Shell scripts, XML, HQL, PIG, Map Reduce using Python

ETL Tools: Informatica 7/8/9/10, Oracle Data Integrator 10.1.3.5

Data Modeling Tool: ER Studio Data Architect 9.5

OLAP: OBIEE 10g 10.1, Tableau 9.2, Business Objects 6.5

Database Tools: Toad 12.1, SQL Developer 2.1.1.64, SQL Server Management studio 2012, Rapid Sql

Automation Tools: Control M, Autosys R11.3 and Informatica scheduler

Test Management tools: Quality Center

Version Control Tool: WinCvs 1.3.13.2, ClearCase

Other Tools: Tivoli Storage Manager, Winscp, Editplus, Rally

PROFESSIONAL EXPERIENCE:

Confidential

DW Lead

Responsibilities:

• Effectively Coordinate and discuss with the Users, Business Intelligence Leader, and the Process leads to clarify their requirements and gather additional information regarding the request to be developed
• Creating weekly status and monthly status reports and metrics.
• Analysis of the specifications provided by the client BAs.
• Created Highwatermark process for loading the incremental data.
• Creation of technical design documents and Technical release document to promote code from Development to QA and Production environment.
• Development of Informatica ETL code.
• SCD1, SCD2, SCD 7 (hybrid) implementation.
• Used HIVE to read the dialysis machine/CHAIRSIDE data in form of logs.
• Assisted BI developer in Tableau dashboard/report creation.
• Bug fixing for production issues.
• Performance tuning the code using pushdown optimization and other Informatica and database best practices.

Environment: Informatica Power Center 9.5.1, Tableau 9.2,Business Objects, Autosys, Oracle 11g, Netezza, Exadata, Sql Server 2013, SQL/PLSQL, Toad, Python Scripts, AIX, MS SharePoint and MS Office applications .

Confidential, Houston

Lead ETL Developer/ Data Modeler

Responsibilities:

• Analysis of the specifications provided by the client BAs.
• Design of technical design documents.
• Development of Informatica ETL code.
• SCD1, SCD2 implementation.
• Tableau dashboard analysis.
• Data quality analysis using Informatica analyst and data lineage using Informatica metadata manager 9.5
• ER Studio Data Model development.
• Helping in creating Taxonomy and data dictionary.

Environment: Informatica Power Center 9.1, Tableau 8.2, SQL Server 2012,Oracle 10g, Toad, SQL/PLSQL, UNIX, ER Studio Data Architect 9.5, MS Office.

Confidential, Portland Maine

Sr. ETL Lead Developer/Admin

Responsibilities:

• Involved in identifying the source systems and gathering the business requirements and defining the architecture.
• Code/Design reviews.
• Creating ETL mappings to assist business.
• SCD1, SCD2, SCD3 implementation for history management in the mart.
• ETL/Informatica Admin activities like repository backup, Integration service configuration, User, Folder creation and permission setup, Connection creation.
• Used Informatica powerexchange to perform ETL with Hadoop for user experience data mart.
• Wrote map reduce code using Pig Latin and python
• Worked with HIVE DDLs and Hive Query language (HQLs).
• SQOOP for large dataset transfer between Hadoop and RDBMs.
• Creating the design documents and test plan strategy for migration purposes.
• Created dashboards using Tableau.
• Providing support to production batch loads to offshore team.
• Performance tuning the code.
• Deployment of ETL code to higher environments via Folder and xml migration.
• Tivoli storage Manager backups and file restore to servers.
• Assisting FTP and pgp encryption.
• Analyzing, implementing and integration of sources into existing data mart applications.

Environment: Informatica Power Center 8.6.1, Cloudera Hadoop, Tableau, HP-UX 9000/800, Linux - etl server, Oracle 10g,Teradata, SQL/PLSQL, Toad, Tivoli Storage Manager, AIX, Microsoft Share Point, MS Office.

Confidential

Sr. ETL Developer

Responsibilities:

• Developed key components of the application using: Informatica
• Control M Job scheduling.
• Oracle PL/SQL development.
• UNIX Shell Scripting.
• Worked at client site and interacting with business for requirement gathering
• Supported the ODS for daily Transactional business.

Environment: Informatica Power Center 8.6.1/8.5.1, Control M 6.3.01, Sybase, Oracle 10g, SQL/PLSQL, UNIX, Microsoft Share Point, Visio, MS Office.

Confidential

Sr. Developer

Responsibilities:

• As an Informatica Developer, my roles and responsibilities include of mappings development as well as production support.
• Gathering the business request from Client and discuss with concerned onsite Business analyst about the requirement
• Creating INFORMATICA mappings in version 8.6.0.
• Handling HR Ongoing Issues.
• Prepared ETL Design Documents.
• Designing the logic for ETL mappings.
• Development and Testing of Informatica mappings.
• Business objects universe / report creation.
• Providing resolutions to production failures.
• Involved in bug fixing based on the testing results.

Environment: Informatica 8.6.0, Business Object 6, Cybermation, Sybase, Oracle 10g, AIX, UNIX shell script, PL/SQL.

Confidential

ETL Developer

Responsibilities:

• Creating INFORMATICA mappings in version 7.1.4, 8.6.1 using INFORMATICA Power Connect for SAP.
• Creating similar scenarios in INFORMATICA as made in Oracle Data Integrator.
• Testing performance of INFORMATICA Vs Oracle Data Integrator mappings.
• Testing the Knowledge Modules i.e. LKM and RKM in Oracle Data Integrator.
• Building the SDE adaptor for OBIEE in Oracle Data Integrator.
• Mapping the Source SAP system functional modules to functional modules in OBIEE Data warehouse staging schema.
• Testing the SILOS for loading data to OBIEE (Business Analytics Warehouse).
• Analysis of the specifications provided by the client.
• Prepared ELT Design Documents.
• Designing the logic for ELT mappings.
• Development and Testing of Informatica mappings.
• Development and Testing of Oracle Data Integrator mappings.
• Implementing history in target using Change data and Z Table concept.
• Validating the interfaces by testing the data on Oracle side and SAP side.

Environment: Informatica Power Center 8.6.1, Oracle Data Integrator 10.1.3.5, Oracle 10g, UNIX, SQL/PLSQL, SAP R/3, MS office, Microsoft Share Point, Control M

Confidential

ETL Developer

Responsibilities:

• Administrator activities like repository backup.
• Analysis of the specifications provided by the client.
• Contributed to Data modeling of Enterprise Data Warehouse.
• Prepared ETL Design Documents.
• Setting up the process for ETL which involve designing the wrapper programs, deciding the workflow etc.
• Designed Data Load plan for Dims and Facts.
• Deployed ETL mappings and workflows at Client end.
• Implementation and Development of SCD 1 and SCD2 Dimensions.
• Designing the logic for ETL mappings.
• Development and Testing of Informatica mappings.
• Deployed and tested ETL code in Fidelity SIT/UAT/PERF.
• Named the Fact and Dimension Tables according to the naming conventions provided by Fidelity.
• Created jobs, batches, monitored job flow in Control M and through Cron in Satyam.
• Control M Job Scheduler/Designer/Architect (Module Lead) for automation of workflows.
• Worked on oracle tables and did performance tuning at ETL level and database level.
• Also had a role in UNIX support person at offshore.
• Did debugging of shell scripts.

Environment: Informatica Power Center 8.1.1, Control-M 6.3.01, Oracle, Erstudio7.5, Webfocus 7.6.2, AIX, Toad, SQL, PLSQL, MS office

Confidential

Informatica Developer

Responsibilities:

• Understand the current architecture, existing Informatica Jobs
• Analysis of the specifications provided by the client.
• Design of technical design documents.
• Review of code and helping onsite in development of Informatica mappings.
• Loading of the tables through ETL process.
• Testing - Unit Testing and Integration Testing.

Environment: Informatica Power Center 7.1.1, Oracle, Business Objects, UNIX, MS office