SUMMARY:

• 8+ years of Software Life Cycle Experience in System Analysis, Design, Development Implementation, Maintenance, and Testing of Data Warehouse and Data Integration Applications using ETL tools like Informatica Power center 9.1/8.x/7.x
• Experience in developing and maintaining logical and physical data models for data warehouse applications using tools like Erwin and ER - Studio.
• Experience in ETL (Extract Transform Load) Data Warehouse experience using Informatica Power center, Informatica Power Mart, Repository Admin console, Repository Manager, Designer, Workflow manager, Work flow Monitor, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Mapplets, Mappings, Workflows, Sessions, Re-Usable Transformations and mapping.
• Expertise in Data Warehousing concepts like Star schema, Snowflake schema, Fact table and Dimension Table.
• Extensively worked wif various Active and Passive transformations.
• Worked wif reusable objects like reusable Transformation and Mapplets.
• Extensively used SQL Override function in Source Qualifier Transformation.
• Expertise in designing & coding Stored Procedures, Functions, Triggers using PL/SQL.
• Good Knowledge of reporting tools such as Congo's and Business objects.
• Designed and Implemented Data Marts like AROE, MORRIS for BI repots.
• Created and edited custom objects and custom fields in Sales force and checked teh field level Securities.
• Created customized applications and modules for existing applications.
• Converted data into a format dat can be accessed on any operating system.
• Communicate wif teh clients and develop a customized database modeling application
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• B2B transformations used in technology for extracting data from any file, document, or message, regardless of format, complexity, or size and transforming it into a usable form.
• Managed teh (B2B DT) business process wif external partners wif efficiently and integrated data from outside strategy.
• Solid Expertise in Informatica Performance Tuning and Error Handling.
• Tuned teh mapping designs & queries while loading data into Data Warehouse & general purpose databases. Experience in Integration of various data sources like Oracle, PL\SQL, Netezza, MS Access, and SQL Server in to staging area.
• Responsible for Performance Tuning at teh Session Level, Mapping Level, Source Level, and teh Target Level.
• Created UNIX shell scripts to access data and move data from Production to Development.
• Good knowledge on UNIX Shell and PERL scripting. Developed UNIX scripts and scheduled ETL Loads.
• Coordination in preparing project plans wif managers and development team to make sure project plans are correct and are in time.
• A good team player wif excellent communication, analytical, verbal & writing skills.
• Flexible enough to work in a variety of environments & capable to take up new tasks as me am self motivated &quick learner.
• Experience in development of Oracle Client/Server applications, on UNIX platform.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x/5.x, MSSIS, DAC

Databases: MSSQL server 2000/2005/2008, MS Access, Teradata, Oracle 10g/9i/8i, DB2, MS Access97/2000

Languages: SQL, PL/SQL, T-SQL, SQL*Loader, SQL*Plus, C, C++, Transact SQL, ANSI SQL, SQL Scripting, Awk, HTML, DHTML, UNIX Shell Scripting, PERL Programming

Scheduling Tool: Autosys, Tivoli

Operating Systems: Windows 98/2000/XP/Vista/7, UNIX

Office Tools: MS Office, Microsoft Visio, MS Visual Source Safe

Other Tools: Toad, Rapid SQL

Windows Utility Packages: Excel, Access, PowerPoint, Word

PROFESSIONAL EXPERIENCE:

Confidential, Mechanicsburg, PA

Sr. ETL (Informatica) Developer

Responsibilities:

• Developed complex ETL mappings using Informatica to move data from our operational database to our data warehouse.
• Developed complex Informatica mappings using Filter, Sorter, Aggregator, Look up, stored procedure, expression, Joiner, Router transformations for populating target table in efficient manner.
• Extensively used Informatica client tools Designer, workflow manager and workflow monitor.
• Used SQL in a DB2 environment to write queries to extract data.
• Worked on Re-pricing of teh Drug project to modify teh current process of re-pricing and be more efficient in teh way we handle different formats of files and how we analyze teh file using Informatica.
• Used Informatica to transform, process, and load data in to our data warehouse.
• Worked wif loading data from ODS source into Staging tables and staging tables to delimited flat files.
• Wrote SQL-Overrides and used filter conditions in source qualifier theirby improved teh performance of teh mapping using informatica designer..
• Fine tuned ETL mappings by identifying performance bottlenecks and deploying established solutions.
• Created Logical and Physical model of teh re-pricing application.
• Used Session Partitioning to speed up data reads and reduce load times.
• Involved in teh installation of informatica client.
• Created ETL mappings and workflows using Informatica to extract data from flat files (CSV, Text) and loads to warehouse.
• Created staging tables to load teh data in warehouse to perform ETL tasks using informatica.
• Worked wif Business Analyst to finalize Data Model, functional and detailed technical requirements.
• Created technical documentation describing ETL task implementation.
• Established a process to develop and deploy code in a team.
• Worked on a production support tickets to fix teh issues.
• Worked on CMS (MMDR, MPWR, BEQ response and Marx response files etc) project to load teh files received into warehouse using Informatica.
• Performed unit testing and QA testing and created documents for teh code to work in efficient manner.
• Developed transforms and jobs to keep track of teh changes made by teh Re-formatter application and update teh warehouse table accordingly.
• Created Logical and Physical model of teh re-pricing application.
• Worked wif Mantis bug tracking system to create mantis for teh issue tracking and project management.
• Involved in daily run of Pharmacy and Drug data to production warehouse.
• Used SVN Repo Browser for revision control of source files.
• Used Putty to execute Jobs.

Environment: Informatica Power Center 9.1.0, DB2, Flat files, Windows NT, Mantis Bug Tracker, UNIX, Shell Script, Java Script, Tortoise SVN, Winscp, Putty, IBM Data Studio 3.1.

Confidential, Irvine, CA

Sr. ETL Informatica Developer

Responsibilities:

• Worked wif business analyst for requirement gathering, business analysis and testing and project- coordination using interviews, document analysis, business process descriptions, scenarios and workflow analysis.
• Developed business requirements document (BRD) based on business objectives, facilitated joint sessions.
• Worked on IDQ file configuration at user's machines and resolved teh issues.
• Analyzed business and system requirements to identify system impacts.
• Created flow diagrams and charts.
• Responsible for writingSQLqueries, stored procedures, views, triggers,T-SQL.
• Created teh Detail Design Documents which has teh ETL technical specifications for teh given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings wif teh clients for teh Approval of teh process.
• Analyzed teh existing mapping logic to determine teh reusability of teh code.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type me & II in different mappings as per teh requirements.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Created, Tested and debugged teh Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL developer.
• Developed restart token on UNIX server for Real-time Informatica workflows and customized real-time Power Exchange workflows.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Used OBIEEDAC to Schedule teh Informatica mappings in teh correct order, dependencies between them based on teh sources and targets.
• Configured teh workflow to remember teh last time data was extracted from teh source and configured parameter for each mapping so dat only changed records can be extracted teh next time it is run.
• Created Xcelsius dashboards for teh ORM (Owner Relation Management) application
• Extensively used sed, awk commands to remove header, trailer in flat files. Ran file watcher jobs to check for a output file in a particular location
• Extensively used Alerts while creating teh Dashboards (Xcelsius).
• Created and maintained teh Shell Scripts and Parameter files in UNIX for teh proper execution of Informatica workflows in different environments.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test & supported teh UAT for teh client.
• Performing ETL & database code migrations across environments.

Environment: Informatica Power Center 9.1/8.6, Power Exchange 9.1, IDQ, Toad, UNIX Shell Scripting, Oracle, SQL Server, T-SQL, Flat Files, Mercury Quality Center, MS Project, HL7, IBM Initiate, NCA Mainframes for CA7 Job Scheduler.

Confidential, Tampa, FL

Sr. ETL (Informatica)/PL/SQL Developer

Responsibilities:

• Interacted wif business representatives for requirement analysis and to define business and functional specifications.
• Delivered responsibilities as Analyst and Programmer including interaction wif Business Users for Requirements Gathering, Creating Technical Specifications, Design, Development, and Production Support & Maintenance.
• Analyzed data source, extracted, transformed, and loaded data in to target data warehouse based on teh requirement specification using Power Center and PL/SQL developer
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Involved in teh documentation of HIPAA 4010 and 5010 changes to EDI 837 and 820 Transactions.
• Worked wif various heterogeneous sources such as Oracle10g/11g, and Flat Files to load teh data into teh target Oracle data warehouse.
• Strong experience on 4010 and conversion.
• Involved in Premium Reconciliation (Remits and Enrollment) process for Medicaid.
• Worked on Excelys 6.0 upgrade process.
• Developed complex Informatica mappings using Filter, Sorter, Aggregator, Look up, stored procedure, Joiner, Router transformations for populating target table in efficient manner.
• Strong experience in doing unit testing and creating documents.
• Involved in UAT and QA testing.
• Provided strong QA and UAT support.
• Worked wif Unicenter Workload Control Center for production scheduler jobs.
• Resolved teh production support tickets.
• Strong experience on OLAP (Online Analytical Processing).
• Extensively Used Transformations like Source Qualifier, Expression, Filter, Aggregator, joiner, lookup, Sequence Generator, Router, Sorter and Stored Procedures, Java Transformations. And used debugger to test teh mappings and fixed teh bugs.
• Analyzed teh session and error logs for troubleshooting Data mappings and sessions.
• Implemented efficient and effective performance tuning procedures.
• Worked on oracle partitioning for performance tuning.
• Strong experience on Oracle SQL and PL/SQL Languages.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader.
• Imported tables from TeraData using DB connections to power center designer.
• Extensively used teh Informatica Debugger for debugging teh Mappings to check teh Business rules implemented correctly or not.
• Good experience in UNIX shell scripts in Unix Environment.
• Developed and tested all teh informatica Data mappings, sessions and workflows - involving several Tasks.

Environment: Informatica PowerCenter 8.6/8.1, Oracle 10g/11g, SQL Server, TeraData, PL/SQL, XML, Flat files, UNIX, Shell scripts, Windows NT, Autosys server

Confidential, Texas

ETL Developer

Responsibilities:

• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Used most of teh transformations such as teh Source qualifier, Aggregators, lookups, Filters, Sequence Generator and Update strategy.
• Developed transformations, mappings, sessions and workflows in Informatica to load target database and tuned mappings for improving performance.
• Involved in Data Extraction from heterogeneous source systems like Oracle, DB2 and flat files.
• Used mapping parameters and variables to meet teh business requirement
• Wrote UNIX shell scripts to execute Informatica Workflows.
• Developed universe and reports using Business objects.
• Worked on Business Objects reports like drill down reports, master detail reports, etc.
• Worked on enhancing teh reports according to business rules.
• Created teh Test cases for Unit Test and involved in Unit testing.

Environment: Informatics Power Center 8.6 Business Objects 6.1, T-SQL, Oracle 8i, DB2, UNIX, SQL, PL/SQL, Toad

Confidential, Cleveland, OH

Sr. ETL (Informatica) Developer

Responsibilities:

• Developed FRD (Functional requirement Document) and data architecture document. Conducted Impact and feasibility analysis.
• Worked wif Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
• Analyzed data source, extracted, transformed, and loaded data in to target data warehouse based on teh requirement specification using Power Center.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Involved in teh documentation of HIPAA 5010 changes to EDI 837, 834, 835, 276, 277 Transactions.
• Worked wif various heterogeneous sources such as Oracle10g, DB2, XML and Flat Files to load teh data into teh target Oracle data warehouse.
• Worked wif FACETS Team for HIPAA Claims Validation and Verification Process (Pre-Adjudication)
• Developed complex Informatica mappings using Filter, Sorter, Aggregator, Look up, stored procedure, Joiner, Router transformations for populating target table in efficient manner.
• Strong experience on OLAP (Online Analytical Processing).
• Analyzed teh session and error logs for troubleshooting Data mappings and sessions.
• Developed slowly changed dimensions (SCD) Type1, Type 2 for loading data into Dimensions and Facts
• Implemented efficient and effective performance tuning procedures.
• Worked on oracle partitioning for performance tuning.
• Strong experience on Oracle SQL, PL/SQL Languages, MS SQL Server.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader.
• Strong experience on data quality, data cleansing using data explorer.
• Solved common name and address data problems by Informatica Data Quality's (IDQ) address cleansing and identity matching rules, which reduce project risk and make teh quick.
• Extensively used teh Informatica Debugger for debugging teh Mappings to check teh Business rules implemented correctly or not.
• Resolved teh production support tickets using solution manager.
• Good experience in UNIX shell scripts in Unix Environment.
• Developed and tested all teh informatica Data mappings, sessions and workflows - involving several Tasks.
• Involved Conducted and participated in process improvement discussions and recommending possible outcomes and focused on production application stability and enhancements.

Environment: Informatica Power Center 8.6/8.1, Oracle 10g, DB2, SQL, PL/SQL, XML, Flat files, TOAD 7.3, UNIX, Shell scripts, Windows NT

Confidential

ETL Informatica Developer

Responsibilities:

• Prepared Functional/Technical Specification documents from BRD (Business Requirement Document) / Customer Requirements
• Involved in giving teh estimate for teh project
• Worked on Informatica PowerCenter components Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Involved in creation of data warehouse star schema using Data modeling tool Erwin
• Involved in Data Extraction from heterogeneous source systems like Oracle, DB2 and flat files.
• Created Informatica mappings, sessions and workflows to populate data into Fact and Dimension tables
• According to teh business logic created various transformations like Source Qualifier, Lookup, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, Normalizer and Update Strategy.
• Created reusable transformations and used in various mappings.
• Performance tuning of targets, sources, mappings and SQL queries in teh transformations.
• Developed mappings to implement type 1 and type 2 slowly changing dimensions.
• Used mapping parameters and variables to meet teh business requirement.
• Used various debugging techniques to debug teh mappings.
• Developed Informatica parameter files.
• Involved in doing reviews.
• Involved in creation of Stored Procedures using PL/SQL.
• Wrote UNIX shell scripts to execute Informatica Workflows.
• Mentored and guided teh junior developers.
• Created JIL scripts using teh job scheduling tool Autosys.
• Performed extensive SQL querying on Oracle database for data validation.
• Unit tested teh maps by running SQL queries on source and target.
• Tested data necessary to validate ETL code using positive and negative scenarios.
• Created Test cases, Test data and involved in Unit Testing to find teh business rules applied correctly.

Environment: Informatica Power Center 8.x, Oracle 10g, SQL, PL/SQL, T-SQL, DB2, Stored Procedures, UNIX, Autosys, Rapid SQL, ERWIN 4.0