SUMMARY

• Around 7 years of Information Technology experience in the analysis, design, development, testing, implementation and support for Data Warehousing projects.
• Extensive experience in interaction with users and functional team for gathering the business requirements, functional specifications and estimation of efforts.
• Extensive experience in production support processes, incident management, change management and release management.
• Good experience in HealthCare Claims
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 9.x/8.x/7.x ETL tool.
• Experience on HIPAA standards, ICD9/ICD10, EDI transactions & ... versions.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Experienced and comfortable working on various databases like SQL Server, Oracle, DB2 UDB, Teradata.
• Well conversant with test case design, test case execution, test data preparation, SDLC concepts, Defect Life cycle

TECHNICAL SKILLS

• ETL Tools: Informatica 9.x/8.x/7.1, SSIS, Ab Initio, Data Stage
• BI Tools: Hyperion Essbase, SSAS, SSRS, Cognos, Business Objects
• Databases: DB2 V9.1, Oracle 11g, SQL PL, SQL Server 2008,Teradata, Microsoft PDW
• SCMVC: VSS, Team foundation server, Clear Quest, Clear Case, IBM CMVC
• Operating Systems: UNIX, Linux, Windows XP/2003 server, Sun Solaris
• Other tools: Erwin, ERStudio, Infosphere Data Architect, MS Office, Excel, and Visio
• Languages: UNIX Scripting, Perl, SQL, PL/SQL, XML
• Testing Tools: HP Quality Center 9.2/8.0, Mercury Quality Center 8.0/Test Director, Clear Case

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential - Atlanta, GA

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Involved in analyzing different modules of facets system and EDI interfaces to understand the source system and source data.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Involved in analyzing the ICD 9 and ICD 10 for the data mapping from ICD 9 - ICD 10 and ICD 10 - ICD 9 in source and target level.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Followed with HIPPA and Hl-7 standards as per the company guidelines for healthcare data.
• Involved in healthcare coding such as CPT-4, HCPCS, etc.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved with the healthcare claims processing 837, 835.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0 and experience in PMCMD Informatica commands.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.

Environment: Informatica 9.5, Oracle 11g, SQL server 2008 R2, SQL, PL/SQL, Toad 10.6, SQL Loader, Unix, Flat files.

Informatica Developer

Confidential - South San Francisco, CA

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing and support for production environment.
• Extracted, Transformed and Loaded data into Oracle database using Informatica mappings and complex transformations (Aggregator, Joiner, Lookup, Update Strategy, Source Qualifier, Filter, Router and Expression).
• Designed and developed the Informatica workflows/sessions to extract, transform and load the data into Target.
• Mapping of Data Elements for XPF keyword file
• Participated in all Facets of the software development cycle including providing input on requirement specifications, high level design documents, and user's guides.
• Involved in writing windows batch code execute the PMCMD and PMREP commands and PMREP files
• Created Views in Oracle and Sql Server to analyze the Data Assurance.
• Expertise in the optimization of the performance of the Designed workflows processes in Informatica and to identify the bottlenecks in different areas after the full volume system run.
• Involved in ICD-9 4010 data analyzing with data analyst to define the structure of dimension and facts.
• Used debugger to test the mapping and fixed the bugs
• Used Pended claims data in XC and built keyword for XPF batch
• Worked extensively on the HIPPA 4010 transactions and HIPPA 5010 transactions as the source data like 834, 8001, 835, 277, 276 and more.
• Developed the Test Scripts and performed the Unit Tests on the ETL mappings.
• Developed Informatica mappings to load the data into oracle database.
• Created the Data Flow Diagrams to check the dependency.
• Scheduling the sessions to extract the data into warehouse database on Business requirements.
• Created and maintained the shell scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Implemented the Change Data Capture using Informatica power exchange for Facets data.
• Improved performance of the jobs using various performance tuning techniques.
• Successful code migration from DEV to Testing & Production environment
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval
• Prepared the Functional and Technical Documentation.

Environment: Informatica Power Center 9.0.1, Oracle 10g, SQL Server 2008, Share Point, TOAD 9.0.1, UNIX, Autosys r11, MS Visio 2003, JDE 9.x.

Informatica Developer

Confidential - Minneapolis, MN

Responsibilities:

• Responsible for the debugging, creating mapping, running maps etc. by using Informatica Power Center.
• Configured and running test session, workflow using Workflow Manager.
• Performed Unit Testing for various modules.
• Responsible to submit EDI 837 x12 files through UNIX servers and end-to-end data validation like from Legacy to Facets system and also verified batch job process.
• Developed the complex mappings using Informatica.
• Wrote Queries, and Optimization Queries.
• Indexing columns and verify usage of indexes and query performance through Explain Plan table.
• Created oracle stored procedures, cursors, sequences and triggers.
• Performance tuning of the mappings and sessions.
• Conduct reviews of project documents including requirements, technical design, test plan and test cases.
• Developed mappings between Legacy applications to Facets claim system applications.
• Reviewed the mappings.
• Provide support technical guidance to Team members.
• Created migration reports and Work with ETL admins to coordinate code migrations.
• Supported for SIT, UAT and Production performance issues.

Environment: Informatica Power Center 9.0.1, Oracle, Mainframes, SQL Server 2008, TOAD 9.0.1, UNIX, Autosys r11, MS Visio 2003.

Informatica Developer

Confidential - Richmond, VA

Responsibilities:

• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Developed ETL mappings in Informatica Power Center Designer using various transformations like Source Qualifier, Normalizer, Router, Expression, Filter, Connected and Unconnected Lookup, Update Strategy, Sequence Generator etc.
• Provided training to the developers on Informatica tools (Designer, Workflow Manager, Workflow Monitor and Repository Manager) and Best Practices.
• Developed reusable transformation and mapplets.
• Created different steps of reconciliation for to match the records count and validations.
• Expertise in the optimization of the performance of the Designed workflows processes in Informatica and to identify the bottlenecks in different areas after the full volume system run.
• Extensive use of Command tasks, Decision tasks, email tasks in the workflow design.
• Used debugger to test the mapping and fixed the bugs
• Developed the Test Scripts and performed the Unit Tests on the ETL mappings.
• Created and scheduled UNIX scripts to control the ETL processes.
• Used TOAD front-end tools to issue SQL commands matching the business requirements to Oracle RDBMS.
• Developed test cases, conducted unit tests, and migrated from development to test and production environment.
• Worked with HP Quality Center to interact with testing team.

Environment: Informatica Power Center 8.6.1, Unix, DB2, MS Excel, Oracle, PL/SQL, SQL Server 2008, Windows NT 4.0, Erwin 4.5

ETL Developer

Confidential - IN

Responsibilities:

• Analysis of the ERP system to pull data as per GSDW structure ad requirements.
• Gap analysis for all the mandatory columns for GSDW.
• Co-ordination with the ERP team during the analysis and design phase
• Enhancement of reports and addition of data elements using BO Universe
• Development of ETL mapping and Reports along with Unit Test, Integration Testing.
• Documentation as per dPMM methodology.