PROFESSIONAL SUMMARY:

• 9 years of IT experience in Data Warehousing (Informatica Power Center, Informatica Power Mart), Oracle (SQL, PL/SQL) and IBM Mainframes.
• Strong knowledge in Data Modeling (Relational, dimensional, Star and Snowflake Schema), identifying FACT and Dimensions Tables, Physical and Logical Database design using ERWIN .
• Worked extensively with complex mappings using different transformations to implement complex rules.
• Experience in Slowly Changing Dimensions (Type 1, Type 2 and Type 3), OLAP, Data Reports and Surrogate keys, Normalization/De normalization.
• Proficient in using TOAD, SQL* PLUS for developing stored procedures, functions, views, triggers and complex queries using Oracle PL/SQL.
• Involved in complete Life Cycle of Data Warehousing Project.
• Experience in integration of various data sources like Oracle, XML, IBM Mainframe Flat files, DB2 into the staging area.
• Involved in supporting and performing Unit testing, System Integration testing, UAT and Production support for issues raised by application users.
• Experience in writing UNIX Shell Scripts in UNIX environment for automation of the process, pre - processing data and worked with Autosys for scheduling Workflows.
• Experience in preparing the ETL Specifications and Technical Design documents.
• Experience in developing Mainframe Applications in Cobol, CICS, DB2, VSAM and JCL.

TECHNICAL SKILLS:

ETL: Informatica 8.x/9.xScheduling Tool: Autosys, Informatica, Control-M, CA-7, ZEKE

Databases: Oracle11g/10g, DB2 v.9, TERADATA 14

Operating Systems: Windows All Versions, UNIX

Programming: SQL, PL/SQL, Cobol, JCL, CICS, HTML, XML, DHTML

Other Tools: SQL*Loader, SQL*Plus, TOAD, BTEQ, FASTLOAD, TPUMP, File-Aid, Spufi, TSO, ENDEVOR, XPEDITOR,FILEAID, PLATINUM,SPUFI,FILEAID for DB2,QMF, DFSORT, Insync, InterTest, Changeman,, BMC Tools

Scripting Languages: UNIX Shell Scripting

Methodologies: E-R Modeling, Star Schema, Snowflake Schema

Data Modeling Tool: Erwin 4.5/3.5

EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

• Worked closely with Business analysts and Data architects to understand and analyze the user requirements.
• Extract data from Mainframes using Power Exchange and Cobol files for creating specific reports for clients which can be related to Medicaid Claims, Management and Administrative Reporting Subsystem (MARS) and Surveillance and Utilization Review Subsystem (SURS).
• Full knowledge on the MMIS system and all the subsystems.
• Worked on the MEDICAID Subsystems - Claims, Recipient, Prior Authorization,, TPL SURS and MARS.
• Created Adhoc reports for Clients to create Claims Count including Suspended, Denied and History (paid) for Analytical purpose.
• Used various transformations like Filter, Expression, Sequence Generator, Lookup, Update Strategy, Joiner, and Union to develop robust mappings in the Informatica Designer.
• Performed Unit Testing, which validates if data is mapped correctly or not and provides a qualitative check of overall data flow and the deposited data in Target Tables.
• Responsible for Performance tuning in Informatica Power Center at the Target Level, Source level, Mapping Level, Session Level, and System Level.
• Involved in System Integration Testingto check whether all the applications Mainframe, ETL & Databases are working fine as an end-to-end process.
• Developed Mapping parameters and Variables to support SQL override.
• Created Mapplets to use them in different mappings.
• Worked with Update strategy transformation using functions like DD INSERT, DD UPDATE, DD REJECT, and DD DELETE
• Extensively worked in the performance tuning of the PL/SQL Procedures and also created new ones for updating the Version Indicator as part of ICD-10 Project.
• Handled various Claim loads like Daily Loads, Weekly Loads, Monthly Loads and Quarterly Loads using Incremental Loading Technique
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor
• Coordinated deployments that include Informatica deployments as well as Unix Shell Script.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.

Environment: Informatica Power Center 9/8.6, Erwin, UNIX Shell Scripting, BTEQ, FASTLOAD, TPUMP, Oracle 11g/10g, PL/SQL,UNIX Shell Scripting, TOAD.

Confidential, Dallas, Tx

Informatica Developer

Responsibilities:

• Involved in entire SDLC process from requirements analysis, design, testing and implementation for loading the data warehouse.
• Designed the ETL processes using Informatica to load data from Oracle Db, CSV files, and SQL server to target databases.
• Created complex SCD type 1 & type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Strategy Transformations.
• Performed data manipulations using various Informatica Transformations like Aggregate, Filter, Normalizer, Sequence Generator etc.
• Working on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Written SQL overrides in source Qualifier in order to filter the data more effectively at the source level.
• Generated UNIX shell scripts for automating daily load processes.
• Successfully migrated the mappings to the testing and production environment.

Environment: Informatica Power Center 9/8.6, Erwin, UNIX Shell Scripting, SQL server 2008 R2,Oracle 11g/10g, PL/SQL,UNIX Shell Scripting, TOAD

Confidential, Newark, NJ

Informatica Developer

Responsibilities:

• Performed major role in understanding the business requirements and designing and loading the data into data mart (ETL)
• Used ETL (Informatica) to load data from source to ODS.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Union, Rank, Normalizer, Update strategy and Router transformations for populating target table.
• Implemented slowly changing dimension (SCD) Type 1 and Type 2 forChange data capture.
• Created SQL queries, Packages, Functions, Procedures, Views, and Database Triggers.
• Worked with Workflow Manager for the creation of Worklets, Sessions, E-mail notifications, Decision and to Schedule jobs.
• Involved in Performance tuning of the Informatica mappings using various components likes Parameter files, caching.
• DevelopedUNIX Shell Scripts and PL/SQL procedures.
• Maintained warehouse metadata, naming standards and warehouse standards for future

Environment: Informatica Power Center 9.1, Erwin, T-SQL, SQL Server 2012/2008 R2/2005, Oracle 10g/9i, SQL Server Management Studio, UNIX Scripting, Autosys

Confidential, NY

Informatica Developer

Responsibilities:

• Worked closely with business team to finalize on the validation rules that need to be applied outside Informatica ETLs.
• Participated in meetings with business analysts for requirement gathering (BRD), business analysis, to understand the user requirements and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Implemented source file watching mechanism using UNIX shell scripts.
• Worked with UNIX administration team to develop maintenance scripts to archive data files and delete log files.
• Worked with Informatica administration and integration teams to migrate code to higher environments without any glitches

Environment: Informatica Power Center 8.6.1,Oracle 10g/9i, SQL* PLUS, PL/SQL, Toad, ERWIN, Linux, Unix Shell Scripting, Autosys

Confidential

Mainframe Developer

Responsibilities:

• Designed CICS maps using BMS, coded & tested CICS/COBOL/DB2 application programs and Added new fields to the CICS screens.
• Developed batch and online programming (COBOL, DB2, CICS, JCL, VSAM, DB2 stored procedures, Cataloged procedures, In-stream procedures, Control Cards, SDF II screens) as per ISO standards; also prepared the documentation up-to-date using MS-Office and VISIO.
• Prepared test scripts, plans and involved in Unit Testing, System Integration Testing, User Acceptance Testing and fixed identified issues as part of UAT using File-Aid, COBOL, JCL,Xpeditor, QMF, SPUFI and CICS; verified the test data using random spot checking.
• Involved in finding and fixing logical errors while performing Peer Reviews of all Subsystems.
• Used Zeke as Workload Management tool.
• Conducted Business and Technical analysis, interaction with clients as well as with End-users.
• Extensively used SPUFI, QMF, File-Aid for DB2 to validate queries for better results before implementing.

Environment: DB2 (Database), COBOL, CICS, JCL, VSAM, EZtrieve, Changeman, Xpeditor, Fileaid, Spufi, QMF, ZEKE