Summary:

• Total of 13 years of professional IT experience in Analysis, Design, Development, Testing and implementation of various Data warehouse and software Applications.
• Over 8 years of extensive experience on Informatica Power Center with strong understanding and knowledge of Extraction, Transformation and Loading of Data from heterogeneous source system like Flat files, Excel, XML, Oracle, Teradata.
• Extensively involved in ETL Data warehousing using Informatica Power Center 7.x/8.x/9 Designer tools like Source Analyzer, Target Designer, Mapping Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like Sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse.
• Very strong in SQL joins, Nested Queries, Unions, Multi-table joins.
• Experience in scheduling the batch jobs using workflow monitor, DAC Scheduling, Tivoli TWS , Autosys and FTP methods.
• Worked with Dimensional Data warehouse in Star and Snowflake Schemas, created slowly changing SCD Type I/II/III dimension mappings.
• Expertise in using SQL Loader to load Data from external files to Oracle Database.
• Experience working with Oracle Data Integrator ODI , Oracle warehouse builder.
• Experience in optimizing the performance of SQL scripts and Oracle database/application tuning.
• Experience in coding using SQL, SQL Plus, PL/SQL, Procedures/Functions, Triggers and Packages.
• Worked on SAAS environment where data is accessed from anywhere.
• Developed Batch jobs using UNIX shells scripts PMCMD commands, sftp commands to automate the process of loading, pushing and pulling data from different servers.
• Good experience in performing supporting Unit testing, System Integration Testing SIT , UAT and production support for issues raised by application users.
• Strong managerial skills and good experience in managing and coordinating the project and providing project status to the stakeholders of the project.
• Experienced as an data warehouse house architect.
• Experienced in logical and Physical data modeling of staging and warehouse environments using Data modeling tool like Erwin, Relational Rose, and Oracle Designer.
• Diverse background with fast Learning and creative Analytical abilities with good Technical, communication and Interpersonal skills.

TECHNICAL SKILLS:

EXPERIENCE:

onfidential

Confidential is a subsidiary of Confidential companies specializing in IT services. Confidential was formed 7 years ago and is committed to providing world-class technology services to its clients Confidential Responsible for inistering and optimizing a pre-existing Informatics ETL environment and providing operational support and develop reliable and complex ETL processes to support maintenance and new development related to Telematics initiative.

Responsibilities:

• Responsible for support of business teams in addressing of operational system issues as well as requests for new capabilities
• Integration Manager for different modules in HISNA for Cassiopaedatawarehouse for managing Hyundai Leasing and Financing/Daybreak application.
• Develop design to incorporate new ODS datawarehouse and CRM datawarehouse to Report the Leasing and Financing Information to Credit Bureau companies.
• ETL Integration for the interfaces with near real time datawarehouse like CRM and EDW Enterprise Datawarehouse and source and Target Stage datawarehouse.
• Requirements gathering with Functional team on reporting Metro 2 format for consumer reports to Credit Bureau.
• Responsible for the operational support of Informatica environment including but not limited to automation, job scheduling, dependencies, monitoring, maintenance, security, and administration
• Implements on-going optimization and tuning of Informatica mappings.
• Supports and enhances existing Informatica environment and develops new, complex ETL processes to support additional design, development and deployment of the new Telematics capabilities
• Manage Unix scripts to support file transmissions and placing the files in appropriate target locations for external vendors using Control M scheduler which has the functionality of scheduling the batches and capable of doing file transfer to External vendor locations.
• Manage the file validation scripts which are specific to inbound interfaces The credit Bureau files which are received from external vendors.
• Tibco JMS integration with Informatica for Real time updates for data warehouse.
• Designs and implements complex ETL processes
• ETL design to maintain Common error handling and logging mechanism framework. Prototype for the same was build and is being implemented by the team, which captures ETL run error, Job status, email to the admin and business stake holders and capturing the Etl last run date information.

Confidential

Sr.ETL Architect

Good Technology is an enterprise software and security company specializing in secure business mobility. Good empowers users worldwide through our Good for Enterprise and Good for You products, and manages a secure, world-class network operations center Confidential Good Technology's secure solutions work to keep corporate and personal data safe, secure, and accessible. Good Technology's services are used by major organizations, including 50 of the Fortune 100 as well as enterprise customers in 90 countries operating on over 200 carriers. Good Technology has partnerships with industry leaders Confidential , and leading systems integrators.

Responsibilities:

• Developed Informatica maps to design and Load the Revenue data from the Requirements by the client. Informatica Version: 9.1
• Few complex maps to handle the Hierarchy of customer products like the product code, desc, Region etc was taken care. Most of the table sources come from multiple Oracle legacy systems.
• The billing and adjustments data load to take care of Incremental ETL data load to the Daily snapshot table.
• Transformations used like Source Qualifier, Lookups connected and unconnected lookup, Lookup overrides, Filter, Router, Expression.
• Maintain the Informatica coding standards like shortcut, Migration and deployment procedures while loading data.
• Unit testing data validations.
• Schedule the ETL using the DAC Data warehouse Administration Console scheduler.
• The end result was to develop OBIEE reports in R12 environment taken care by the Reporting team for customer reporting.
• Requirements gathering and working as solution architect for New project requirement on existing design.
• Develop HDL, Framework and Logical Solution design doc for implementation of the New project

Confidential

Sr. Informatica Lead

Description:

Confidential is a health insurance and Health care company headquartered in Pasadena CA. It has developed a data warehouse called Supply Chain Management. The Supply Link project is to build a multi star schema integrated data warehouse to support supply chain reporting needs in an effective and efficient manner.

Responsibilities:

• Involved in enhancement for implementing new regional data roll out. Incorporating additional columns requested by the business.
• Interact with business for preparing the mapping documents.
• Develop the Design documents to incorporate the changes for the enhancement.
• Maintain the Functional Specification Design docs and the Data Model and Mapping documents in the STAR team which maintains the Version of the documents.
• Implementing the Health check remediation process from Informatica coding standard point of view like saving session logs by timestamp, eliminating duplicate sources and other performance improvement issues.
• Worked as SME role on requirements gathering on the Supply link project.
• Maintenance of data warehouse using data warehouse Administration Console.
• Providing status report on Daily jobs loaded in the target data warehouse.
• Informatica Admin role for doing repository maintenance, Code review and Deployment activities. And add new users and maintaining logon credentials and providing security permissions.
• Troubleshooting in case of any production issue on an event of a job failure.
• Status reporting on the ongoing and planned activities with realistic estimates to stakeholders of the project.
• Working as a consultant architect providing High level designs and help in designing the system for the application to support the BI and Supply link data warehouse.
• Generated and analyzed compare reports.
• Update and modify the data model for the project supply link project as per the business requirement. Come up with the Logical and Physical model and implement the changes in the backend.
• Production support through Remedy.

Environment: Informatica Power Center 9, Oracle 11g, OBIA ETL adaptors, Tivoli Workflow Scheduler,

Oracle SQL Developer, UNIX Shell Scripting.

Confidential

Sr. Informatica Lead and ETL Solution Architect

Description:

Confidential is a health insurance and Health care company. It is the largest publicly-traded company focused exclusively on meeting the needs of those enrolled in publicly-funded healthcare programs such and Medicare. A data warehouse has been built for cash reserve calculations, customer information sales tracking. Theitecture involved moving data from Legacy systems to relational tables in the staging area, moving staging data to the Data Mart and finally moving data to the Multi-Dimensional Data Warehouse, which is stored in Oracle 10g. The Project Medicare Advantage/Cost Encounter Data Submission MAEDS a part of National Medicare Finance NMF track is build an application KPMETA to process, store and track Medicare Cost and Advantage encounter data reportable to CMS Center of Medicaid and Medicare . All input and output encounter data will be in the CCF Claims Centric File format defined by the EDI track. Confidential will also provide an extract of its encounter and status data to MIA group for reporting and analysis.

Responsibilities:

• Involved in designing the process for getting the data from all systems to Data Warehousing system as a architect consultant in the project.
• Performed major role in understanding the business requirements and designing and loading data into data warehouse ETL .
• Collection of data source information from all the legacy systems and existing data stores.
• Gathering all technical and business requirements.
• Design the end to end solution of loading data in data acquisition layer Staging Area and Claims.
• Responsible for designing the end to end process to capture Audit, Balance and control information of the end to end project.
• Informatica Admin role for doing repository maintenance, Code review and Deployment activities. And add new users and maintaining logon credentials and providing security permissions.
• Maintenance of data warehouse using data warehouse Administration Console.
• Led design and development of End to End ETL solution.
• Create Informatica ETL mappings to extract data from VSAM files and load into staging area.
• Creation of Informatica mappings to read data from different staging areas apply all business rules and load in claims canonical.
• Experience in Design and Development ETL mappings.
• Used aggregator, lookup, expression, stored procedure, filter in the mapping.
• Accountable for increasing the performance through identify the bottleneck methods.
• Used Advanced Transformations like stored procedure, unconnected, and Transformations.
• Hands on experience in Transaction Control Transformation, TCL.
• Utilization of Job Schedulers like Tivolli to schedule the jobs using pmcmd command.
• Used Constraint based load technique CBL as advance transformations.
• Data modeling.
• Working as a consultant architect providing High level designs and help in designing the system for the application to support the BI and Supply link data warehouse.
• Managing and monitoring the ETL team of 3 developers and reporting the progress to management. Scheduling daily calls with the Business for QA and Status.

Environment: Informatica Power Center 8.6, Oracle 11g, Tivolli Workflow Scheduler, Oracle SQL Developer,

UNIX Shell Scripting. Erwin DM, Visio.

Confidential

Sr. Informatica Lead

Description:

This was a Data warehousing ETL scripting project where Confidential Business information across various Data Source systems would be extracted per different regions, loaded into the delimited file extracts for usiness analysis and reporting. This project extracts data from the WITS regional data source systems and our extract queries run against the Teradata database and created flat file extracts for the Business. There are weekly Full extracts and Daily Increment and Update Extracts. The records are updated using the Hashing function in Teradata.

Responsibilities:

• Involved in complete understanding of business requirement and involved in analyzing the sources to load in Oracle warehouse.
• Designed Sources to Targets mappings from SQL Server, Excel/Flat files to Oracle using Informatica Power Center.
• Worked with DBA and Data Modellers for project coordination.
• Responsible for Detail design of each interface.
• Involved in complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Developed SDE mappings to load large amount of data from different sources to staging area, SID mappings for load the data from staging area to target system.
• Implemented slowly changing dimension Type 1 and Type 2 for Change data capture using Version control.
• Created Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Implemented various tasks like Event wait, Event Raise and E-mail etc.
• Created Shell scripts for Automating of Worklets, batch processes and Session schedule using PMCMD.
• Used Oracle Data Integrator ODI to improve inter-application dialog by having interfaces executed asynchronously.
• Created various Oracle database SQL, PL/SQL objects like Indexes, stored procedures, views and functions for Data Import/Export.
• Tuning the Informatica mappings to increase the performance.
• Wrote test plans and executed it at Unit testing and also supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily jobs.
• Performed System testing and unit testing.
• Managing and monitoring the ETL team of 3 developers and reporting the progress to management. Scheduling daily calls with the Business for QA and Status.

Confidential

Description:

This was a Data warehousing project where Business information across various Data Source systems would be consolidated, loaded into the warehouse as per a pre-defined Enterprise Data warehouse Model in order to raise the quality level of business analysis and reporting. This project extracts data from various source systems and collates it together in a data warehouse. This data warehouse maintains historical data as well.

Responsibilities:

• Involved in Requirement Analysis, ETL Design and Development for extracting the data which is stored in different sources like Oracle, SQL Server, Sybase, and DB2.
• Analyzed, designed and developed an environment that would facilitate the use of Informatica to transform data coming from Igraspoltp into Adim data marts.
• Developed complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, worklets, workflows for the mapping to run daily, biweekly based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Data encryption/masking transformation used as a part of confidential user data implementation.
• Implemented Slowly Changing Dimension type2 methodology in Informatica.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Tuned SQL, PL/SQL Queries in Source qualifier Transformation for better performance.
• Created and executed unit test cases for various scenarios for all the mappings, workflows and scheduling workflows through Autosys.

ETL Informatica Developer OBIEE

Description:

This project is to capture all the 837's coming into care first through Pipeline gateway into Canonical. The first step was to capture 837s from Pipeline into a Data Acquisition DA Layer. The second step is to extract the 837 data elements from this DA layer and store it in the Claims Canonical.

Responsibilities:

• Used ETL Informatica to frame load data strategy from source to DWH.
• Involved in designing of mappings framework and load design architecture.
• Create Reusable Transformations, alter or override default query in source qualifier.
• Design ETL Mappings as the requirement.
• Faster execution of SQL query on windows environment.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Used Informatica Data Migration to decrease the risk and minimize the errors.
• Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements.
• Responsible for performance tuning for several ETL mappings, Mapplets, workflow session executions.
• Used UNIX Shell scripting for automation of the process, invoking PL/SQL procedures, and Informatica sessions.
• Connecting the software using SAAS application tool
• Designed and Developed Oracle PL/SQL procedures, performed Data Import/Export, Data Conversions and Data Cleansing operations.
• Writing queries in SQL for checking the Source and Target Tables Row Count.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in unit testing and identified new requirements/concerns. Scheduling and rerunning failed jobs as required.

ETL Informatica Developer Description:

The Confidential , IL The Confidential is the nation's largest publicly held personal lines insurer. The scope of the project is to build Data Marts for business analysis departments, such as generation, transmission, distribution and customer satisfaction.

Responsibilities:

• Developed Logical and physical database designs for the transaction system.
• Performance tuning on sources, targets, mappings and SQL queries in the transformations.
• Created reusable transformations and Mapplets based on the business rules to ease the development.
• Developed mappings to implement type 2 slowly changing dimensions.
• Created and implemented the Unix shell script for the start and stop procedures of the sessions.
• Used various Informatica Error handling technique to debug failed session.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision Used various debugging techniques to debug the mappings.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Created Materialized view for summary data to improve the query performance.

Confidential

Senior ETL Developer

Description:

The project consisted of providing a financial support system BI project Support and development of Business Intelligence Solution. It included providing Site BI solution to ING Bank Singapore to help the Business user and the IT operations in maintaining banking transaction and Business operations data warehouse.

Confidential Sr. ETL Developer

Description: Manufacturing Data Integration

To address data requirements and reporting needs of Lilly manufacturing sites nearly 20 sites , MI CS has developed MDI Manufacturing Data Integration data warehouse. Data from critical business applications such as ERP, Lab Systems and Event Management systems is integrated in MDIProvides Site BI solution to IBO to help the manufacturing plants monitor improve efficiency and quality in Mfg operations

Responsibilities:

As a Project Lead handling team size of 4 was responsible for the following:

• Carry out requirement analysis and Feasibility study.
• Manage Resource loading and Project budget Estimates.
• Conducting project dashboard activities, PMR and Audits from time to time.
• Creation and validation of Informatica mapping design document.

Confidential

Senior Developer

Description:

Confidential The Victorian Curriculum and Assessment Authority is a statutory authority of the government of Victoria responsible for the provision of curriculum and assessment programs for students in Victoria State, Australia.

Responsibilities:

• Collaborated in the data warehouse front-end and backend design.
• Business Requirement need and scope of analysis for implementation of the new APS data warehouse.
• Involved in Reporting requirement gathering and develop new and efficient reporting strategy from the existing reporting system.
• Performed in analysis design and documentation of HLD for Data warehouse.
• Informatica ETL Designer is used for Extraction and Transformation of data from the existing system.

Environment: Business Objects 6.5, SAS BI DI ETL Studio, Oracle 10g, Relational Rose Data modeling tool, SQL Developer.

Confidential

BI Developer Business Intelligence

Confidential Consumer Group businesses comprise the financial service sector's most diverse consumer product offerings banking services, credit cards, loans and insurance. The company works mainly on industry-leading advanced technology, has a strong worldwide presence and is powerful global franchise in Citibank. Citigroup is the first financial services company in the U.S. to bring together banking, insurance, and investments under one umbrella.

Desktop Support/Developer

Confidential is the world's second largest Cargo Container Company having an annual turnover of 4 Billion. Global Tracking System GTS tracks Container movement worldwide. GTS receives messages form Message Originators spread across the globe. It validates and tracks these messages and sends them to Internal Container Management ICM System situated at London