PROFESSIONAL SUMMARY

• 8 + years of experience in the IT industry with excellent experience in DW & BI and Healthcare domain
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment
• Good experience in working with business analysts to identify, study and understand requirements and translated them into ETL code in Requirement Analysis phase
• Expertise in creating Mappings, preparing ETL Design documents, Unit Test Case documents
• Proficient in the Integration of various data sources with multiple relational databases like Oracle10g, MS SQL Server, Mainframe and Flat Files into the staging area, ODS, Data Warehouse and Data Mart
• Expertise in creating Datamaps from copybooks using Informatica Power Exchange Navigator.
• Good knowledge in interacting with Informatica Data Quality (IDQ)
• Expertise in data profiling, standardization and structuring the data using Informatica IDQ
• Experience in Informatica Data Quality Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ
• Experience in creating profiles and scorecards using IDQ developer and Analyst
• Experience in defining rules and maintaining reference table data using IDQ developer and Analyst
• Extensively worked on developing and debugging Informatica mappings, sessions and workflows
• Expertise on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables
• Expertise in writing SQL Queries using Oracle and SQL Server in validating data into Data Warehouse/ETL applications
• Experience in writing, testing and implementation of the PL/SQL stored procedures, functions, and packages

TECHNICAL EXPERTISE

ETL Tools: Informatica Power Center 9.x/8.x, Informatica Data Quality, Informatica Power Exchange, Abinitio

Databases: Oracle 11g/10g, Teradata, SQL Server 2000

Scripting Languages: SQL, PL/SQL, UNIX Shell Script

Other Tools: Toad, SQL Developer, SQL Assistant, WinScp, Putty,IBM Rational ClearQuest

Operating Systems: Windows, UNIX, Linux

Scheduling Tools: Tidal, Tivoli Workload Scheduler

Versioning Tools: Software Change Manager

Data Modeling: Physical, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow - Flake, FACT, Dimensions

PROFESSIONAL EXPERIENCE

Confidential Michigan, Detriot

Sr. Informatica Developer

Responsibilities:

• Prepare functional and technical specification design document for building EDW Dental Claims foundation layer.
• Involved in Requirement Analysis, ETL Design and Development
• Coordinating with CPDM Team and with the Program team, Data Modeler, Informatica Admin and DBA to close the Mapping Spec related queries and changes.
• Responsible for delivering the Informatica artifacts for Dental EDW layer that includes DNOA, Local MA & NASCO FEP source data.
• Review the deliverables and ensure that all are quality deliverables on delivering to client by reviewing the code and testing the deliverables.
• Involved in understanding the existing ABC process of BCBSM and implementing the reusable components in data feed application.
• Managing the versioning of the mappings, scripts, documents in version controlled tool SCM
• Performance tuning for Informatica jobs and Oracle complex queries using appropriate query plans
• Prepared and implemented automated UNIX scripts to execute the end to end history load process
• Developed mappings to load large amount of data from different sources to staging area, mappings for load the data from staging area to Dimension and Daily/Monthly Facts
• Created transformations and mappings using Informatica IDQ to move data from multiple sources into targets
• Utilized Informatica IDQ to complete initial data profiling and matching/removing duplicate data
• Created column level profiles, join profiles & scorecards from the profile results
• Created rules in Analyst and used them as mapplets in Developer tool
• Experienced in standardizing data using reference tables
• Integrated mappings developed using IDQ with power center
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues
• Involved in creation of Test Plans, Test Cases, and Test Execution based on mapping specs to validate the platform data
• Responsible for educating the production support team about the process that is being built newly for EDW Dental claims foundation layer.

Environment: Informatica Power Center 9.5.1,Informatica Power exchange, Informatica Data Quality(IDQ), oracle 11g/10g, Unix, Shell Script, Tivoi, TOAD,IBM Rational ClearQuest

Confidential, Portland, OR

Sr. Informatica Developer

Responsibilities:

• Understanding existing legacy system and extensively worked on the requirement definition and analysis in support of Data Warehousing efforts
• Participating in Business, Functional requirement walk through
• Using Transformations to clean the data from staging area as per the Data Warehouse requirements
• Extraction, Transformation and loading of data from oracle, flat file sources into oracle database
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL
• Worked with Informatica Data Quality Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ
• Used IDQ for data profiling, standardization and structuring the data
• Created join profiles, column level profiles and generated scorecards from profile results
• Experienced in standardizing data using reference tables
• Integrated mappings developed using IDQ with power center
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures
• Successfully Implemented Slowly Changing Dimensions (SCD). Used Type 2 dimension to keep the history changes
• Partitioned Sessions for concurrent loading of data into the target tables
• Involved in Error handling strategies, Unit, System testing, UNIX test scripts, test scripts and fix bugs in the application
• Troubleshoot and tune SQL using EXPLAIN PLAN
• Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands, batch jobs
• Developed and implemented the UNIX shell script for the start and stop procedures of the sessions
• Created and Monitored Tasks, Workflows and Worklets using Workflow Manager
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes

Environment: Informatica Power center 9.x/8.x, Informatica Data Quality(IDQ Developer, Analyst), oracle 11g/10g, UNIX, Unix Shell Script, Tivoli, TOAD, WinScp

Confidential - Michigan, Detriot

Sr. Informatica Developer

Responsibilities:

• Involved in the complete life cycle of the project
• Based on analysis of source system present design document into client. So that client can have full utilization of data available into source system
• Understanding the Requirement Specifications, preparing the Functional and technical design documents
• Written documentation to describe program development, logic, coding, testing, changes and corrections, optimized the mappings by changing the logic and reduced running time
• Included error-handling and exception handling by logging in the error tables and sending an alert message via e-mail to the concerned distributions list
• Responsible for migration of code to QA environment, and extending the support for the QA and UAT for fixing the bugs
• Involved in bug fixing of the current production issues, and delivery in a short time frame
• Developed the source definitions, target definitions to extract data from flat files, relational sources and Salesforce Objects
• Created different transformations for applying the key business rules and functionalities on the source data
• Involved in performance tuning of sources, targets, mappings, and sessions. Also involved in tuning of SQL queries
• Manage coordination between onsite/offshore teams and BA
• Developing test plan and scripts, conducting testing, and dealing with business partners to conduct end-user acceptance testing
• Worked on integration testing of all the modules and preparation of test plans
• Ensuring that all production changes are processed according to release management policies and procedures
• Ensuring that appropriate levels of quality assurance have been met for all new and existing applications / CRs.
• Ensuring that application changes are fully documented, supportable
• Worked on various tickets and monthly release
• Reviewed Informatica mappings and test cases before delivering to Client

Environment: Informatica Powercenter 9.x/8.x, Informatica Power Exchange, oracle 11g/10g, UNIX, Unix Shell Script, Tivoli, TOAD, WinScp, IBM Rational ClearQuest

Confidential

Sr. Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the CSCORE project
• Analyze source systems like SJPRD, CFNPRD, and QTCPRD & BVPRD for purchase, receipts, invoice, and involve hold and payments related data
• Based on analysis of source system present design document into client. So that client can have full utilization of data available into source system
• Created Mapplets, reusable transformations and used them in different mappings
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager
• Implemented parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions
• Validation of Informatica mappings for source compatibility due to version changes at the source
• Implemented daily and weekly audit process for the Claims subject area to ensure Data warehouse is matching with the source systems for critical reporting metrics
• Involved in writing SQL scripts, stored procedures and functions and debugging them
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements
• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues
• Coordinate with the client team, and present on a weekly basis to the client the progress and issues related to the project
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community
• Reviewed Informatica mappings and test cases before delivering to Client

Environment: Informatica Power center 9.x/8.x, oracle 11g/10g, Unix, Unix Shell Script, TOAD, SQL Assistant

Confidentia

Informatica Consultant

Responsibilities:

• Building, Maintaining and Tuning ETL mapping to load data from XML source to Relational Pre Staging, then from Pre Staging to Staging, then from Staging to Data ware house using Informatica Power Center 7.1.1 & 8.1
• Worked with heterogeneous source to Extracted data from Oracle database, XML and flat files and loaded to a relational Oracle warehouse
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for cleanup and update purposes
• Validating the reporting objects in the reporter against the design specification document
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Reviewed Informatica mappings and test cases before delivering to Client
• Written Test Cases for ETL to compare Source and Target database systems
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations
• Ensured that the mappings are correct and conducted data validation testing
• Worked with production team to resolve data issues in Production database

Environment: Informatica 7.1.1 & 8.1, SQL Server 2000/2005

Confidential

ETL Developer

Responsibilities:

• Developed standard and reusable mappings and Mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter
• Extensive use of Persistent cache to reduce session processing time
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions
• Used Debugger to test the data flow and fix the mappings
• Developed shell scripts for file transferring
• Created Tasks, Workflows, and Sessions to move the data at specific intervals on demand using Workflow Manager
• Involved in Unit testing, Iterative testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements
• Preparing and using test data/cases to verify accuracy and completeness of ETL process
• Created and monitored workflows and task using Informatica Powercenter Workflow Manager

Environment: Informatica Powercenter 7.1.3, Oracle, SQL Server, Windows XP, UNIX, UNIX Shell Script, TOAD