Professional Profile

• More than 8 years of experience in Information Technology with a strong background in Analysis Design Development Implementation of Data warehousing in ETL process using Informatica Power Center 8.x/7.x/6.x/5.x. Power Mart Repository Admin Console Repository Manager Designer Datamart OLAP OLTP.
• Experienced in all phases of Software Development Life Cycle SDLC .
• Good knowledge of Data warehouse concepts and principles of Ralph-Kimball and Bill-Inmon methodologies Star Schema Snowflake SCD Surrogate keys Normalization/De normalization Facts and Dimensions tables Physical and Logical data Using Erwin for Data Marts and Staging Database.
• Extensive development experience for the Extraction Transformation and Loading of data from multiple disparate sources such as Oracle MS SQL Server DB2 Teradata Flat Files XML Files into ODS Operational Data Store and EDW Enterprise Data Warehouse systems.
• Solid Expertise in Creating Migration Document and expertise in creating Functional and Technical Documentation for ETL.
• Have extensively worked in developing ETL for supporting Data Extraction transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer Warehouse Designer Transformation Developer Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers Expressions Filters Joiners Routers Union Unconnected / Connected Lookups and Aggregators.
• Strong Experience in developing Sessions/tasks Worklets Workflows using Workflow Manager Tools - Task Developer Workflow Worklet Designer.
• Expertise in implementing complex business rules by creating re-usable transformations Mapplets and Mappings.
• Extensive knowledge in handling slowly changing dimensions type.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on experience in Performance Tuning of sources targets transformations and sessions.
• Good experience in data profiling and data cleansing activities and documenting the ETL process flow for better maintenance and analyzing the process flow.
• Solid Expertise in Oracle Stored Procedures Triggers Cursors Indexes Functions Table Partitions and experienced in working with Oracle using SQL PL/SQL SQL Plus SQL Loader TOAD.
• Strong Knowledge in optimizing database performance.
• Well Experienced in Doing Error Handling and Troubleshooting using various log files.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Experience in UNIX shell scripting CRON FTP and file management in various UNIX environments.
• Expertise in creating Test Plans and writing Test Cases.
• Expertise in doing Unit Testing Integration Testing System Testing and Data Validation for Developed Informatica Mappings.
• Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member.

Technical Skills

• ETL Tools Informatica 8.x/7.x/6.x/5.x Power Center/Power Mart Designer Workflow Manager Workflow Monitor Server Manager Power Connect
• Data Modeling Erwin 4.0/3.5 Star Schema Modelling Snow Flake Modelling
• Databases Oracle 10g/9i/8i MS SQL Server 2005/2000 DB2 Teradata v2r6/v2r5
• OLAP Tools Cognos 8.0/7.0/6.0
• Languages SQL PL/SQL Unix Shell Script Visual Basic HTML XML
• Tools Toad SQL Loader SQL Navigator
• Operating Systems Windows 2003/2000/NT AIX Sun Solaris Linux

Confidential

ETL Lead Developer/ ETL Architect

PCS provides correctional facilities with a full range of inmate communications services by developing custom telecommunication solutions that enable inmates to communicate with their friends and family. They provide variety of products to Inmate from debits cards collect calls prepaid to emails and electronic communication services. The Projects involved re-designing the Debit processing system OLTP system . The New transaction system involved integrating 33 different facilities into one central payment debit processing system. The transactional system was based of xml XSD webservices java and flat files. Flat files and xml were loaded into databases. The datawarehouse was designed for the multiple transaction OLTP systems. The OLAP system involved multiple fact tables and conformed dimensions.

Responsibilities

• Provide technical oversight and subject matter expertise to developers and database administrators in support of the construction of Facts Dimension and confidence in data and other user facing business intelligence applications.
• Perform acceptance testing of system development or process improvements to ensure implementation meets with documented specifications.
• Documented ETL test plans test cases test scripts test procedures assumptions and validations expected results cases installation and troubleshooting process in production.
• Installed and configured development and production environments ETL standards for new OLTP system that was replacing the legacy. Worked with DBA to migrate OLTP and OLAP systems from MYSQL to Oracle 11.5.10. EBS
• Managed day-to-day operational aspects of the project and scope. Provide information to business clients regarding technology directions and translate technology opportunities into integration solutions.
• Identified appropriate resources. Kept open communication with functional managers.
• Data Analysis primarily Identifying Data Sets Source Data Source Meta Data Data Definitions and Data Formats. Designed and developed a common XML schema to accommodate the web services and file solution for ETL integration.
• Defined common reusable unified XML Source qualifier for all the sites that were integrated. For web services that were consumed by Informatica common XML target was designed all sites wide.
• Implemented powers connect for web services solution. Worked with Java team to incorporate the user defined functions wrote error strategy for Java transformation.
• Setup and debug existing javacode callable apis callable functions with help java developers to be used as java transformation.
• Wrote java transformation to make calls for runnable and callable interfaces at vendor systems to extract information. Convert user defined callable java code and parsing logic to business rules and finally to Informatica mappings.
• Design and develop architecture to accommodate 33 different debit and inmate system to one central processing payment system.
• Analyzed the existing Legacy system which was based on java MySQL met with the end users and business users in order to define the requirements.
• Analyzed Designed and developed logical and physical data model to accommodate new debit integration and web services.
• Extract data from legacy to new system using scripts packages and Mappings.
• Planned and Migrated the move of database i.e. moving all the newly designed integration from pims-1 MYSQL to oracle. Wrote interfacing scripts sync jobs using Informatica mappings and SSIS packages.
• Implemented CDC for debit transactions and billing system for two OLTP systems to capture changes to multiple tables using power exchange.
• Organized and scheduled complex workflows to load different sites at same instance without blocking tables and without delays in posting payments. Executed sessions sequential and concurrent batches for proper execution of mappings and sent e-mail using server manager.
• Created Informatica mappings and workflows to integrate site across nation. Created debit refund and prepaid processes per business rules.
• Provided reporting on transactions statistics loaded site wise. Provided the requirement for debit balances daily /monthly basis.
• Suggest and guide cognos developers for report layouts report formats for daily debit daily inmate transactions reports. Designed and developed the refund process for all sites.

Environment Informatics Power Center 8.6 8.1 power connect eclipse Java. Power exchange Congo s 8.0 Embarcadero MySQL Oracle 11g/11.5.10 RAC SQL Developer MS SQL Server 2008/2005 SQL server Integration services 2005 2008 Windows NT 4.0 Win XP

Confidential

Project 1 Blue Core Enrollment

This project is specifically designed for the migration of all the existing subscribers from RTMS to a new system Metavante and eliminating all the duplicate subscribers from the RTMS system. All the subscribers extracted from the RTMS and Metavante are merged together into one file and this file will be transferred to the Vendors. The goal is a centralized integrated set of enterprise information to be used as the basis for all the vendors. Data is extracted/transformed/loaded using Informatics Power Center and some UNIX scripts are also used.

Project 2 Department of Revenue DOR

In an effort to ensure all enrolled members receive the appropriate 1099-HC Blue Cross Blue Shield of Massachusetts BCBSMA have elected to issue 1099-HC statements to all subscribers residing in Massachusetts by January 31 2009 for subscribers enrolled as of December 31 2008

For 1099-HC 2008 tax year reporting the Department of Revenue DOR and Division of Insurance DOI have advised carriers of proposed coding changes to the 1099 HC form submitted to tax payers. The change is in order to translate the Coverage From and To Dates provided in the 1099 XML file sent to DOR and thereby simplify how each tax payer will fill out their 1099 HC tax schedule.

This project is designed to extract the data from the flat files which is sorted based on the subscriber coverage effective date and coverage through date which is then transformed as per the business logic using Informatics as an ETL tool and loaded to the XML file.

Responsibilities

• Analyzing the Source systems.
• Extensively participated in the requirement gathering meetings with the end users to understand the process in the current RTMS system.
• Involved in the preparation of High level Design document based on the design discussions with end users.
• Creation of mapping specification documents for the Onsite and Offshore team to start the coding work.
• Involved in the preparation of unit test cases templates for the team members.
• Responsible for mentoring and assigning tasks to other developers.
• Extensively involved in reviewing designs and mappings to ensure compliance to standards and processes.
• Precise Documentation was done for all mappings and workflows.
• Trouble shooting Informatics mappings for any failures.
• Involved in smoke testing of the code in higher environments and making sure that the code is working fine in all the environments.
• Giving Knowledge sharing sessions to the production team about the code walk through and the steps that needs to be followed for running the workflow.
• Prepared UAT Unit acceptance testing plans to support the customers during UAT phase and resolve the issues based on priority level as per our UAT specs.
• Scheduled jobs using Workflow manager.
• Expertise in Migrating Informatics and Informatics Applications to higher versions and trouble shooting the issues.
• Sending the weekly status report to the customer as well as to the total team of the project.

Environment Informatica 8.5 Flat Files Sun Solaris UNIX XML Files

Confidential

Confidential is a World wide Pharmaceutical company manufacturing different types of Products. The Project Involved in Identifying user Requirements and Analyzing the Existing Data Source and IMS data to Build Product Platforms into Standardized Datawarehouse / Datamart.

Responsibilities

• Responsible for Business Analysis and Requirements Collection.
• Interpret the information from various operational sources from Novartis to create a road map for the Data warehouse designing.
• Designed and developed Informatica mappings for data loads and data cleansing. Extensively used almost all of the transformations of Informatica including complex lookups Stored Procedures Update Strategy and others.
• Involved in the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Creating the Entity relationship diagrams and maintaining the corresponding documentation for corporate data dictionary with all the attributes table names and constraints.
• Defining entities attribute and relationships. Worked on data granularity and cardinality.
• Maintained warehouse metadata naming standards and warehouse standards for future application development.
• Testing and Validation of the mappings.
• Extracted data from various sources such as IMS Data DB2 and Oracle.
• Tuning the Informatica Repository and Mappings for optimum performance and scheduling ETL Sessions.
• Created and maintain several custom reports for the client using Business Objects
• Analysis of Reporting requirements and User Interviews.

Environment Informatica PowerCenter 6.2/5.1 Syncsort for UNIX Oracle 8i/9i Business Objects 5.1 MS SQL Server 2000 DB2 SQL PL/SQL SQL Plus SQL Loader Erwin 4x HP-UX Unix Shell Scripts Sun Solaris WindowsNT4.0

Confidential

ETL Developer

The project involved developing an integrated Data Warehouse system to meet the demands of detailed targeted customer data and sales analysis. The Data Warehouse was designed with expansion in mind as the final stage of this project was to incorporate atomic level detail data.

Responsibilities

• Created/modified Informatica ETL mappings that map the source data from the mainframe system to the target Oracle database and the data warehouse based on requirement.
• Efficiently gathered the heterogeneous sources developed the mappings to transform data to Data Mart using Informatica to synchronize with specification.
• Used aggregator lookup expression stored procedure filters in the mappings.
• Used Sequence Generator Transformation to create surrogate keys for dimension tables.
• Scheduled workflows from backend using PMCMD command.
• Used ETL to extract and load data from Oracle and flat files to Oracle.
• Created various transformations such as Update Strategy Look Up Joiner Filter and Router Transformations.
• Developed mapping to load and Maintain data in slowly changing dimensions.
• Facilitated performance tuning of Sessions and Mappings.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Involved in Post Production support and resolved production issues.
• Actively Involved in Unit testing integration testing of the mappings.
• Creating Tables Indexes Triggers in Different Environments.
• Created re-usable Sessions non re-usable sessions email tasks Control tasks and Link tasks and integrated the above in workflows.
• Used TOAD to develop oracle PL/SQL DDL s and Stored Procedures.
• Used Union Intersection minus and Master/Detail in the source qualifier sequel overrides.
• Tuned performance of Informatica session for large data files by increasing block size data cache size sequence buffer length and target based commit interval.
• Written SQL overrides in source Qualifier according to business requirements.
• Written pre session and post session scripts in mappings.
• Used Workflow Manager for Creating Validating Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Extensively worked in the performance tuning of the programs ETL Procedures and processes.
• Developed PL/SQL procedures for processing business logic in the database.

Environment Informatica 8.1/7.1 Oracle 9i PL/SQL SQL Windows 2000 UNIX sun Solaris

Confidential

Datawarehouse/Informatica Developer

Confidential Health is the leading provider of products services and technologies supporting the health care industry. The primary responsibility of my role in this project was to design and develop the ETL procedures to support the extraction manipulation and insertion of data into a new Information System which also included ensuring that all the data extractions from a number of key source systems conform to the local standards.

Responsibilities

• Involved in design and development of data warehouse environment liaison to business users and/or technical teams gathering requirement specification documents and presenting and identifying data sources targets and report generation.
• Involved in design and maintenance of logical and physical Datawarehouse schemas using ERWIN.
• Consolidate data from various departments into the data warehouse by identify the common data and solve the discrepancy on data values and created various data marts.
• Worked on Informatica Power Center 6.2 tool - Source Analyzer warehouse designer Mapping Designer Mapplet Designer Workflow Manager Repository Manager and Transformation Developer.
• Using Informatica Designer designed Mappings which populated the Data into the Target Star Schema on Oracle 8i Instance.
• Maintained stored definitions transformation rules and targets definitions using Informatica repository Manager.
• Created launched scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions
• Optimized Query Performance Session Performance and Reliability.
• Extensively used Normalizer for COBOL source files from S-390 Mainframe system Router Lookup Filter Union Expression Aggregator Update Strategy Transformations.
• Setup the data mart on Oracle database by running the SQL scripts from ERWIN designer.
• Translation of Business processes into Informatica mappings for building Data marts.
• Involved in the Migration process from Development Test and Production Environments.
• Automation of job processing establish automatic email notification to the concerned persons.
• Involved in Design Development and Implementation of Enterprise Wide Reporting system using Cognos Suite.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Wrote stored procedures and triggers in Oracle 8i for managing consistency and referential integrity across data mart.
• Tuning the Mappings for Optimum Performance Dependencies and Batch Design.
• Worked with Informatica Best Practices guidelines to minimize performance issues.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Scheduled the batches to be run using the Workflow Manager.
• Involved in identifying bugs in existing mappings by analyzing the data flow evaluating transformations and fixing the bugs so that they conform to the business needs.
• Implemented Reporting solution using Cognos.
• Created Catalogs using Cognos Impromptu selecting/joining tables in Catalog creating Folders Subfolders and Calculations etc.
• Created the reports of type crosstab Drill down Sub reports Chart template Summary reports etc.

Environment Informatica Power Center 6.2/5.1 Sun Solaris 7 Oracle 8.i SQL Server 2000 PL/SQL SQL Loader Cognos Erwin 3.5 Windows NT 4.0 Perl 5.x Microsoft Excel 2000