SUMMARY:

• Over 7 years of IT experience with a focus on Sales, Pharma, Insurance and Health care industry including 6 years in designing, developing, implementing and supporting Data Warehouses, data marts and data integration projects.
• Hands on experience in ETL(Extraction, Transformation and Loading) processes using Informatica Power Center 9.1/8.6/8.1/7.1
• Extensively worked on Developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads from various sources such as Oracle, Flat Files, Cobol, DB2, SQL Server etc.
• Involved in Understanding client Requirements, Analysis of Functional specification, Technical specification, Review of Technical Specification.
• Involved in identifing bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they confirm to the business needs and redesign the existing mappings for improving the performance.
• Strong understanding of data warehouse Architecture and Designing principles like Star Schema, Snowflake Schema and Multidimensional Modeling.
• Participated in Full life cycle development of Data Warehouse Systems such as Analysis, Design, Development, Testing & Technical Documentation.
• Developed Mappings using Type 1, Type 2 SCD logic to load data into Dimension tables
• Implemented Performance Tuning techniques at application, database, and system levels.
• Experience in Informatica Composite Data Virtualization, PowerExchange and Change Data Capture(CDC).
• Experience in configuration, performance tuning, installation of Informatica, & Integration of various data sources like Oracle, MS SQL Server, XML, Flat files into the staging area and Design ETL processes that span multiple projects.
• Used XML Source qualifier transformation to extract data from XML sources
• Created database objects like Tables, Views, Synonyms and Indexes from Logical database design document
• Experience in writing, testing and implementation of the Stored Procedures, Functions and triggers using Oracle PL/SQL.
• Knowledge on Talend
• Good team player with excellent communication and interpersonal skills.
• Posses strong analytical & problem solving skills.

TECHNICAL SKILLS:

Data Warhousing ETL: Informatica Power Center 9.1/8.6/8.1/7.1 , Talend, Fact & Dimension tables, Physical and Logical Data Modeling

RDBMS: DB2,Oracle 11g/9i/8i, MS SQL Server 2008/2005, Teradata

Database Languages: SQL, PL/SQL, SQL*Plus, Unix, Shell Scripting

Office Package: MS - Office 2007/XP/2003/2000

Environment: Unix, Windows XP/2000

Exposure to: Cognos Reporting Tool

PROFESSIONAL EXPERIENCE:

Confidential, Lansdale, PA

Informatica Developer/Analyst

Responsibilities:

• Involved in discussions and meetings with the business users for better understanding of the business and also with different source and target systems from where data is pulled in and pushed off.
• Collecting the Requirements from the client, by the document called Functional Requirement Specification(FRS)
• Analyze those documents, upon schedule the meetings with business users and update those requirements.
• Prepare the Interface Functional Specification(IFS) and Interface Data Mapping(IDM) documents by following the business template and getting approval from respective SME’s
• Extensively worked on Informatica client Tools, Repository Manager, Designer, Workflow manager, Workflow monitor for debugging the code.
• Hands on experience with source Analyzer, Target designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Developed complex mappings in Informatica by using different transformations like Source Qualifier, Look-Up, SQL, Joiner, Aggregator, Filter, Stored Procedure, Expression, Router, Update Strategy and Sequence generator.
• Exported and imported mappings between different informatica folders and also Repositories.
• Created sessions, reusable worklets in workflow manager and schedule the sessions to run at a specified frequency.
• Excuted sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre\post SQL.
• Used session logs to debug the sessions.
• Worked and applied the informatica Data Virtualization on integration.
• Integrate data from desperate sources without physical data movement by Informatica Data Virtualization
• Worked on unix shell scripts. Developed unix shell scripts to run pmcmd functionality to start and stop the sessions
• Responsible for keeping the change requests(CR’s) made to code and code developed for the downstream applications using CLEAR CASE.
• Schedule Informatica sessions and workflows by using Autosys Scheduler
• Responsible for providing Knowledge transfer sessions on various application for off-shore and on-site teams.
• Involved in System testing and User Acceptance Testing(UAT).

Environment: Informatica Power Center 9.1/8.6, DB2, Oracle 11g/9i/8i, PL/SQL,SQL Server 2008, SQL, PL/SQL, Toad, Autosys, SQL Loader, Windows.

Confidential, Akron, OH

ETL Developer

Responsibilities:

• Assisted Business Analyst with drafting the requirements, implementing design and development of various components of ETL for various applications.
• Worked exclusively on performing the ETL to Level 1 as is staging, Level 2 staging, DW load based on the business rules and transformation specifications.
• Applied Data Virtualization, to acesss data faster, to lower the costs for company and to provides a single access point to manage and view data.
• Extensively used Transformation Language functions in the mappings to produce the desired results.
• Used session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.
• Analyzed requirements from the users and created, reviewed the specifications for the ETL.
• Designed Incremental strategy, Created Reusable Transformations, Mapplets, Mappings/Sessions/Workflows etc.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Implemented Slowly Changing Dimensions (SCD, Both Type 1 & 2).
• Worked with complex mapping using transformations such as Expression, Router, Lookup, Filter, Joiner, SQ, Stored Procedures and Aggregator.
• Worked on existing mapping for the performance tuning to reduce the total ETL process time.

Environment: Informatica Power Center 9.0/8.6, Oracle 10g, PL/SQL, Windows NT, Flat files (fixed width/delimited), MS-Excel, UNIX shell scripting.

Confidential, St.Louis, MO

ETL Developer

Responsibilities:

• Analyzed, inspected and laid the framework for Claims process Engine, a process designed and customized by external vendors for the client.
• Comprehensively analyzed and systematically documented the end-to-end flow of the Inbound and Outbound claims file (834 HIPAA).
• Extensively Worked in Processing Structured and Unstructured data.
• Informatica B2B Data Transformation supports transformations and mappings, via XML, of most healthcare industry standards including HIPAA 275,277.
• Resolved the anomalies arising in the file processing across individual stages of data flow.
• Deduced the business rules and process rules from the stored procedures that were an active part of the MEMBER’S load reporting layer.
• Designed, Developed and unit tested the ETL process for loading the Medicaid/Medicare records across STAGE, LOAD and ACCESS schemas.
• Accomplished the Provider directory load (a five step sequential process) using informatica for the states of AZ and FL.
• Extended the functionalities of existing ETL process of Medicaid for Medicare.
• Extensively worked on the transformations like Source Qualifier, Filter, Joiner, Aggregator, XML, Expression and Lookup.
• Used session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.
• Maintained documents for Design reviews, Engineering Reviews, ETL Technical specifications, Unit test plans, Migration checklists and Schedule plans.
• Worked with HIPPA 5010 for reduces risk and provides flexibility and complete bi-directional transaction crosswalk transactions.

Environment: Informatica Power Center 8.1/7.1.3, HIPPA5010, SSIS, SQL server 2005, T-SQL, Oracle 10g, DTS, Windows NT, VB, Flat files (fixed width/delimited), MS-Excel, UNIX shell scripting.

Confidential

Database Developer

Responsibilities:

• Maintaining the data coming from the OLTP systems.
• Tuned the database queries to improve the performance of the query and indexing strategies.
• Coded database triggers to record the changes made to the database objects.
• Coded functions and stored procedures to perform the user defined functions and execute the required query when ever needed.
• Document the work performed each day.
• Helped coding shell scripts for database scripting.
• Establishing an application's security measures during development of Application in collaboration with DBAs.
• Involved in Physical schema implementation, objects like table-space, table rollback segments.
• Created database structures, objects and their modification as and when needed.
• Managed users & roles for database security.
• Maintained system security, control and monitor user access to database
• Assigned predefined profiles and roles to the users to maintain database security, CPU activity, idle time and quota management on table-spaces.

Environment: Oracle 9i, SQL Plus, PL/SQL, Windows 2000