SUMMARY OF SKILLS

Over 7+ Years of IT experience as a Sr.ETL Developer in analysis, design, development and implementation of Client/Server and Data warehouse applications using Oracle, MS SQL server on Windows and UNIX platforms. IT experience ranges from Banking, health insurance and manufacturing industries with strong Development knowledge. Experience in the full Software Development Life Cycle (SDLC) using the Waterfall Model and Rational Unified Process (RUP) with a good understanding of Agile Methodology.

CORE STRENGTHS

• Development
• Healthcare
• Banking
• Quality Center
• Informatica Power Center 8.6/8.5/8.1/7.1/6.1
• Erwin 4.0/3.5
• Toad
• Unix
• Star and Snowflake schemas.
• SDLC
• SCD
• PL/SQL, TSQL

Data Warehousing

Informatica Power Center 8.6.1/8.1.1/7.1.3/6.2/5.1.2, Repository Manager Workflow Manager, Workflow Monitor and Informatica Server.

Data Modeling

Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling,  Fact and Dimensions Tables, Physical and Logical Data Modeling.

Databases

Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Plus, SQL*Loader, TOAD.

Programming

SQL, PL/SQL, SQL*Plus, C.

Version Control System

CVS, Rational Clear case.

Bug Tracking Tools

Rational Clear quest, Quality Center.

Operating System

Windows 2000/XP, Solaris, Linux.

Other Tools

Visio, MS-Office (MS-Word, Excel, Power Point)

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI Aug 2011 – Present 
Sr. Informatica Developer

I was involved in a project called BHI (Blue Health Intelligence). BHI brings together the healthcare experience of more than 54 million Blue Cross and Blue Shield members nationwide in a safe and secure database. Blue Health Intelligence (BHI) is a Blue-branded initiative involving numerous Blue Plans, the Association and Consortium Health Plans (CHP). BHI is the largest centralized national data warehouse that aggregates standardized medical and pharmacy claims, membership and account information from the BHI participating Plans. The data is accessible by each participating Plan to support their internal analysis and reports.

Responsibilities:

• Coordinated and analyzed the existing business, system and reporting requirements for IDR and Workforce Dashboard projects.
• Gathered and documented the user requirements and report specifications on regular basis to maintain the integrity of the development.
• Held various interactive meetings with different users and business analysts for a clear understanding of the Business requirements and to bridge the gap between user needs and tool functionalities.
• Interacted with Data modelers and involved in data modeling of the project.
• Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• Worked closely with data modelers on Erwin tool for dimensional modeling (Star schema).
• Used Informatica 8.6.1 to extract, transform and load data from multiple input sources like flat files, SQL Server into Oracle 9i/10g database.
• Created Mappings, Mapplet and Transformations using the Designer and developed Informatica sessions as per the business requirement.
• Worked on Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer and Transformations, Informatics Repository Manager, Workflow Manager and Monitor.
• Used most of the transformations such as the B2B Data Transformation, Expression, Lookup, Joiner, Router, Filter, Aggregator and Sequence Generators.
• Worked with different types of partition techniques like key range, pass through, Round Robin and Hash partitioning.
• Generated Reusable Transformations, Mapplets and used them extensively in many mappings.
• Involved in performance tuning on Informatica mappings.
• Involved in Data integration and Data quality analysis.
• Developed mappings to implement complex logic of SCD2, incremental Aggregation, and Cumulative Calculations etc.
• Developed and configured various Tasks, Sessions and Workflows. Monitored Repository services, Integration Services.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the activities.
• Extensively worked on UNIX shell scripting, Job scheduling using Autosys and Ctrl-M schedulers.
• Involved in Production support in resolving issues.
• Involved in Unit testing and System Testing of Informatica mappings and Workflows.
• Responsible for Testing and Validation of the code in the mappings using the data populated

Environment: Informatica Power Center 8.6.1, Power exchange, Oracle 9i/10g,SQL, PL/SQL, Toad 9.7.2, Erwin 7.3, Main Frames, Cognos, Tivoli, Windows NT, XML, Unix Shell Scripting.

Confidential, Tampa, FL Oct 2009-July 2011
Power Center Developer

Confidential. provides managed care services exclusively for government sponsored health care programs, focusing on Medicaid and Medicare. The company served approximately 2.2 million members as of march 31st 2010. I worked in a project called Void and Replace where the Void and Replace project develop a new functionality to Void and Replace encounters to be submitted to the state. Encounters submitted by third party vendors or providers to Well care or from Well care to state can be void or replaced due to errors or rules regarding services and payments. I was involved in developing the data which are loaded in ODS DB. Also worked on EDI’s and claims reconciliation system which get the triggers based claims EDI’s. Worked on HIPAA Transactions and Code Sets Standards such as 837/835, 270/271, 276/277 transactions.

Responsibilities:

• Involved with Business Analyst in requirements gathering, business analysis and project co-ordination.
• Analyzed the source data coming from different sources like Oracle, flat files, XML, DB2, SQL Server and worked with business users and developers to develop the model.
• Developed data Mappings between source systems and warehouse components.
• Worked closely with data population developers, multiple business units and a data solutions engineer to identify key information that will enhance business decision-making.
• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping Designer, Workflow Manager, Mapplets and Reusable Transformations.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• Used Power Exchange to extract DB2 Source from mainframe server.
• Developed and tested all the back end programs, Informatica mappings and update processes.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Extensively worked in the performance tuning of the mappings, ETL Procedures and processes.
• Worked on removing bottlenecks for the optimum usage of sources, transformations and targets.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.
• Responsible for coordinating with the offshore team.
• Worked with Tivoli for Scheduling and Monitoring of jobs.
• Used SQL loader to load data from flat files to Oracle target database.
• Involved in migrating repositories from one environment to another environment.
• Wrote stored procedures and triggers in Oracle for managing consistency and referential integrity across data mart.
• Involved in reading, writing, customizing and debugging Unix Shell scripts for automation of ETL process.

Environment: Informatica Power Center 8.1.1, Power exchange Sun Solaris, Oracle 9i/10g, SQL Server 2000, PL/SQL, SQL*Loader,Tivoli, Erwin7.1, TOAD 9.6, Windows XP

Confidential, Richardson, TX Jan 2008 – Sep 2009 
Informatica/SSIS Developer

Confidential is a brand of telecommunication services in USA. This Project is basically developed for AT&T for building a data mart and OLAP reports for order management, strategic testing and tactical call center/customer relationship Management. This data mart stores historical information about Local, Long Distance and Voice Mail. This system extracts data from order management system database (OLTP).

Responsibilities:

• Analyzed various Schemas for Implementation and Modeled the Data Warehousing Data marts using Star Schema.
• Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.
• Extracted data form flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed complex mappings & mapplets in Informatica to load the data using different transformations.
• Created and Monitored Sessions and Batches using Server Manager.
• Extensively used various Performance tuning Techniques to improve the session performance (Partitioning etc).
• Successfully moved the Sessions and Batches from the development to production environment.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Generated completion messages and status reports using Workflow manager.
• Created workflows and worklets for designed mappings.
• Developed mappings and loaded data on to the relational database. Worked on Dimension as well as Fact tables.
• Extensively used PL/SQL Procedures/Functions to build business rules.
• Defined, created, published and maintained cubes using Power Play.
• Created User conditions and Filters to improve the report generation.

Environment: ETL-Informatica 8.1.1-Power Center, Oracle9I, DB2, Flat files, SQL, PL/SQL,

Confidential, Pennington- Hopewell, NJ, May 2007- Dec 2007 
ETL Developer

The Project objective is to achieve single point of reference to get the customer data from various databases. The system helps the customer service representatives to deal and transact with the customers. The different departmental financial data marts are mapped to central Data Warehouse. The data from different operational source are transformed in to dimensional and fact tables of Data Warehouse. The various web/reports like Credit Profile, Product Profile, Funds Transfer and Billing profile are generated frequently.

Responsibilities:

• Analyzed the sources, targets, transformed, mapped and loading the data into targets using Informatica.
• Used various transformations like Aggregator, Ranker, Lookup transformation, Filter transformation, Update transformation, stored procedure transformations etc.
• Define data flow by introducing staging, transaction, data warehouse and data mart area. This design provided more control on data flow and data validation.
• Developed several Universes and extracted simple and complex reports using Business Objects.
• Created sessions using server Manager.
• Design and creation of Catalogs and Power Play models.
• Created complex detail, summary report, sub-reports and drill-through reports with prompts.
• Created Oracle views and materialized views to improve the performance of the reports. These views were then imported to the catalogs.
• Created Oracle functions and imported those functions into impromptu as user defined functions.
• Developed Unix Shell scripts and PL/SQL procedures.
• Interacted with business analysts, data architects and application developer to develop a data model.
• Created logical and physical data models for the star schema using ERWIN 4.1, creating DDL scripts for static dimensions.
• Developed Entity Relationship/data models, gap analysis, requirements document, and ETL specifications.
• Practical understanding of the Database schemas like Star Schema and Snow Flake Schema used in relational and dimensional modelling. .
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Implemented dimensional model(logical and physical)data model in existing architecture using Erwin Developed logical and physical data models for Central model consolidation

Environment: Informatica PowerCenter 7.1, Business Objects Designer 6.1, Impromptu web reports (IWR 6.0), IIS 4.0, PL/SQL, Oracle 8.0/8i, Unix and Win NT.

Confidential, NYC, NY Nov 2006- Apr 2007
ETL Developer

This project is done for Confidential, in the credit card division, built a Data warehouse on customer-centric to analyze transactions across finance, marketing, risk collections, and consumer relations. The Data Warehouse is growing in analytical richness with customer data successfully implemented.

Responsibilities:

• Analyzed various Schemas for Implementation and Modeled the Data Warehousing Data marts using Star Schema.
• Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.
• Extracted data form flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed complex mappings & mapplets in Informatica to load the data using different transformations.
• Created and Monitored Sessions and Batches using Server Manager.
• Extensively used various Performance tuning Techniques to improve the session performance (Partitioning etc).
• Successfully moved the Sessions and Batches from the development to production environment.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Created workflows and worklets for designed mappings.
• Developed mappings and loaded data on to the relational database. Worked on Dimension as well as Fact tables.
• Extensively used PL/SQL Procedures/Functions to build business rules.
• Defined, created, published and maintained cubes using Power Play.
• Created User conditions and Filters to improve the report generation.

Environment: Informatica Power Center 7.1.3, Sun Solaris, Oracle 9i/10g, SQL Server 2000, PL/SQL, SQL*Loader, Erwin4.3, TOAD 9, Windows XP pro.

Confidential Dec 2004 – Oct 2006

PL/SQL developer

This software is responsible for maintaining information about the Employees, Company, Branches, Departments, Employee Salary Rates, Employee Achievements and Memos

Responsibilities:

• Created entity relationship diagrams, data diagrams and process models for existing data and for new development using Designer/2000 diagramming tools. Forward engineered logical models into physical data warehouse tables using Designer/2000 Database Design Wizard tool. Generated and modified Designer/2000 DDL SQL for implementation in development, test, and production environments.
• Wrote triggers and stored procedures for data warehouse transformation processes and extract processes using PL/SQL. Enhanced transformation procedures that loaded data into fact and dimension tables from staging tables. Wrote scripts to create tables, sequences, indices and constraints, and to populate and update tables in data warehouse. Analyzed and documented requirements for PL/SQL code required for extraction of data from data warehouse, and loading of data into the warehouse via staging tables.
• Designed UML diagrams – use case diagrams, class diagram and object diagrams to map the business process flow and project development.

Environment: Designer/2000, PL/SQL, Oracle 7, Rational rose UML