SUMMARY:

• Over 7 Years of Experience in a wide range of projects covering multiple domains and involved in requirements gathering, design, development, testing.
• Extensive experience on Informatica Power Center with strong business understanding and knowledge of Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Excel, XML, Oracle, SQL Server.
• Strong knowledge in Kimball and Inmon methodology and models, Dimensional modeling using Star schema and Snowflake schema.
• Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon, surrogate key assignment, data masking and CDC Change Data Capture .
• Extensively worked on Informatica Designer Tools Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer and Workflow Manager Tools Task Developer, Worklet and Workflow Designer .
• Developed Slowly Changing Dimension Mappings of type I and type II .
• Experience in implementing the complex business rules by creating transformations Expression, Aggregator, Unconnected and Connected Lookups, Router, Rank, Update Strategy, Java, HTTP , and developing complex Mapplets and Mappings.
• Excellent skills in retrieving/manipulating data by writing simple/ complex SQL Queries and optimizing SQL.
• Worked with different source systems like Flat Files, XML and Rational Databases.
• Involved in performance tuning of ETL code.
• Experience/Exposure with Fine Tuning Informatica Mappings, Sessions and workflows.
• Excellent in coding using SQL, SQL Plus, PL/SQL, Procedures/Functions, Triggers and Packages.
• Used UNIX Shell scripting for automation of the process, invoking Informatica sessions.
• Experience in scheduling the batch jobs using UC4, Autosys, and Tidal scheduling tools.
• Excellent communication skills, good organizational skills, self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly and learn fast
• Excellent team member with problem solving and troubleshooting skills.

TECHINCAL SKILLS:

C,C ,Java, XML ,HTML, PowerExchange, Informatica Power Center 9x/8x/7x. Autosys, Tidal, UC4, VSS ,Oracle 8i/9i/10g, Ms Access, SQL Server, My SQL, Toad 7.6/8.0, DbVisualizer, SQL plus, Windows XP/NT/2000, UNIX, LINUX, SQL,PL/SQL,SQL Plus,XML,Unix Shell Scripting, TCP/IP, HTTP, FTP.

WORK EXPERIENCE:

Confidential

Sr. DW/ETL Analyst

Confidential:-

• Emblem Health is fully committed to complying with ICD-10, the new HIPAA standard for the medical data code sets for diagnosis and inpatient hospital procedures that will become effective on October 1, 2014. Our successful. Migration to ICD-10 is critical to maintaining high-quality health care coverage and customer satisfaction. In this process we tested following areas
• ETL Remediation
• DB Remediation
• Vendor Management Reports inbound/outbound
• Cognos Reports

Responsibilities:

• Worked on data analysis to understand business needs.
• Responsible for Data Extraction and Transformation from disparate sources like Oracle, flat files, and Loading to Oracle using Informatica Power Center.
• Involved in designing of Informatica Mappings by translating the business requirements.
• Involved in Performance Tuning and optimization of Informatica mappings and session.
• Created Unix Scripts for End to End process flow.
• Created Autosys JIL scripts for Automation of jobs
• Created Technical Design Documents/Low Level Design Documents/Run Book.
• Worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer
• Designed flow diagrams in Visio to help team to understand data flow.
• Creating Complex Mappings/Workflows as per the Business Logic.
• Demonstrate good people skills, ability to motivate assigned staff
• Demonstrate good oral and written communication skills
• Analyzing the BRD and TRD and raising the concerns, pros and corns in the weekly meetings
• Analyzed the Systems and Requirements gathering, Data Analysis, wrote test cases in ALM and reviewed test cases.
• Suggesting the Environment Access requirement to the top management
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Update Strategy, joiner and Rank transformations.
• Implemented Informatica Power Center for building Oracle Data Warehouse from different OLTP systems
• Implemented bulk load method with SQL Loader for loading history data to staging area.
• Defined UNIX Batch scripts for automation of execution of Informatica workflows.
• Analyzing Data columns given by the development team which is helpful for QA Testing.
• Analyzing the tools for ICD9 to ICD10 Mappings
• Assigning test case to the Developer/Business owner and set the priority of it.
• Validated column row level data using SQL/PLSQL.
• Wrote complex SQL scripts to retrieve data for analysis in Source and Target.
• Performing Regression test to ensure quality output.
• Worked on integration testing.
• Worked on UAT testing before production release.
• Performed smoke test on ETL environments.
• Worked on data and non-data validations
• Worked on Scenario/Scheduling validations.
• Validated inbound/outbound vendor feed files before accepting and sending to/from vendors.
• Validated Cognos Reports with sample ICD10 data
• We followed Test Cycle process to validate ICD10 Remediation. That Process involves the following steps
• Smoke testing
• Baseline testing
• Test line /Compare testing
• Functional testing

Environment: SQL, PLSQL, Oracle10g, Ultra edit, Informatica-8.1, QC/ALM, TOAD, MS Office, UNIX, Windows-XP/Windows-7, Cognos 8.2/10.4.

Confidential

ETL Informatica Developer

The purpose of the project is to track revenue for all H B Carriers. Initial implementation of Revenue Tracking for H B carrier UHC, the revenue tracking system loaded the Confidential commission and controller files into a staging table, so that the data could be matched against expected revenue and subsequently stored in permanent tables in the Revenue Tracking schema

Responsibilities:

• Understanding functional specification, data model requirement and ETL specification document.
• Worked extensively on Informatica client tools such as Designer, Workflow manager, Workflow Monitor.
• Worked on Informatica transformations such as Source Qualifier, Filter, Update Strategy, Union, Sorter, Expression, Aggregator, Joiner, Connected Unconnected Lookup transformation, Sequence Generator etc.
• Developed re-usable transformations, Mapplets following the Informatica best practices.
• Coordinated deployments that include Informatica deployments as well as Unix Shell Scripts, Database DDL, DML Scripts.
• Created Source definitions from Flat Files , complicated CSV files and loaded to a relational warehouse.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Target.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Involved in designing of Informatica mappings by translating the business requirements.
• Extensively involved in performance tuning of the Informatica Mappings/Sessions by increasing the caching size, overriding the existing SQL.
• Configured Workflows with email task, which would send mail with session, log Failure of a Session and for Target Failed Rows..
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Migrated Mappings, Sessions and Common Objects from Development to Test and to Production.
• Performed the Unit Testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables.

Environment: Informatica Power Center9.1, Flat files, csv files, Oracle 10g, TOAD.

Confidential

ETL Informatica Developer

Shire is one of the world's leading specialty biopharmaceutical companies. Worked on production issues and enhancements for multiple application Confidential Accounts Data Insight , PMM Promotional Material Management .

Responsibilities:

• Meet with Client and stakeholders to define requirements and identify solution designs for work requests.
• Involved in maintenance, enhancement and/or design and develop complex modules and those that interface with other applications.
• Prioritize and address production defects by closely working with the business and analysts.
• Support and monitor the ongoing production issues. Sending communication to business users on daily basis. Performed data quality checks/Sanity checks to validate the input data based on the cleansing rules. Configuring the loads for Daily and Full Loads On Demand .
• Creating/ modifying Informatica Mappings and UC4 jobs to incorporate the business logic for daily loads. Parameterize and automating the jobs.
• Designed Complex Informatica mappings with transformations such as Aggregator, Expression, Joiner, Filter, Source Qualifier, Union Transformation, connected/unconnected Lookups, Update Strategy, Java, HTTP and Router to transform and load the data from and to flat files, Excel, XML, CSV and relational tables.
• Identified and tracked the slowly changing dimensions Type 1, 2, 6 , heterogeneous Sources and determined the hierarchies in dimensions. Created and Configured Workflows, Worklets and Sessions to transport the data to target using Informatica Workflow Manager.
• Involved in writing UNIX shell/Perl scripts in KSH to FTP the files between the systems and to load data from files to database. Also send daily feeds through FTP to down streams systems.
• Performed unit testing on the Informatica code using the Informatica Debugger and by manually checking through Sql Queries.
• Performed informatica and UC4 code migration between dev, QA, PPRD environments.

Environment: Informatica Power Center 9.0.1, UNIX Shell, Oracle 10g, Flat Files, PL/SQL, SQL Assistant, Netezza, WinSQl, SQLDBX, Toad, SQL Developer, Linux, UC4,XML,CSV, Perl Scripts, Filezilla, Winscp.

Confidential

ETL Informatica Developer

Confidential is a Confidential based, specialty healthcare solutions Company, focused on high-value branded products and specialty generics. Aggregate Spending represents the total, cumulative amount spent by healthcare manufacturers, including pharmaceutical, biotechnology and medical device organizations, on individual healthcare professionals Confidential and healthcare organizations Confidential through payments, gifts, honoria, travel, and other means. populate the Data Warehouse with data to be used for reporting and analysis of Endo Aggregate Spending.

Responsibilities:

• Meet with Client and stakeholders to define requirements and identify solution designs for work requests.
• Work in all the SDLC process Requirements Gathering, Design, Development, System Test
• Involved in maintenance, enhancement and/or design and develop complex modules and those that interface with other applications.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• Reviewed existing retirement process to identify bottle necks and redesigned process to increase the performance and reduced total time frame.
• Design, Build, and Test enhancements to the ETL
• Perform Data analysis and enhance quality assurance checks
• Standardizing the ETL Code and Process.
• Investigate complex issues that require deep technical skill
• Worked on Informatica transformations such as Source Qualifier, Filter, Update Strategy, Union, Sorter, Expression, Aggregator, Joiner, Connected Unconnected Lookup transformation, Sequence Generator etc.
• Developed re-usable transformations, Mapplets following the Informatica best practices.
• Coordinated deployments that include Informatica deployments as well as Unix Shell Scripts, Database DDL, DML Scripts.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Target.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Involved in designing of Informatica mappings by translating the business requirements.
• Extensively involved in performance tuning of the Informatica Mappings/Sessions by increasing the caching size, overriding the existing SQL.
• Configured Workflows with email task, which would send mail with session, log Failure of a Session and for Target Failed Rows..
• Created Tidal jobs for Automating Informatica workflows, batch processes and Session schedule.
• Performed the Unit Testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables.

Environment: Informatica Power Center 9.0, Flat files,SQL Server, WinSql, Neteeza, Tidal, Microstratergy.

Confidential

ETL Informatica Developer

One of the Confidential. The company's products and services are focused on rare inherited disorders, kidney disease, orthopedics, cancer, transplant and immune disease. It implements commercial products. The objective is to achieve the sales of the product and parties using them from various source systems.

Responsibilities:

• Understanding functional specification, data model requirement and ETL specification document.
• Worked extensively on Informatica client tools such as Designer, Workflow manager, Workflow Monitor.
• Worked on Informatica transformations such as Source Qualifier, Filter, Update Strategy, Union, Sorter, Expression, Aggregator, Joiner, Connected Unconnected Lookup transformation, Sequence Generator etc.
• Developed re-usable transformations, Mapplets following the Informatica best practices.
• Coordinated deployments that include Informatica deployments as well as Unix Shell Scripts, Database DDL, DML Scripts.
• Created Source definitions from Flat Files and loaded to a relational warehouse.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Target.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Involved in designing of Informatica mappings by translating the business requirements.
• Extensively involved in performance tuning of the Informatica Mappings/Sessions by increasing the caching size, overriding the existing SQL.
• Configured Workflows with email task, which would send mail with session, log Failure of a Session and for Target Failed Rows..
• Created Shell scripts for Automating of Worklets, batch processes and Session schedule
• using PMCMD
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Migrated Mappings, Sessions and Common Objects from Development to Test and to Production.
• Performed the Unit Testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables.

Environment: Informatica Power Center8.6.1, Flat files, Oracle 10g, MS SQL Server, UNIX, TOAD, Tidal scheduling tool.

Confidential

ETL Developer

Confidential is a leading global financial service. The purpose of the project is to provide a central repository of home mortgage, mortgage broker partner private lender partner information, loan Subscriber Information, Billing Information and vendor Information data. The objective is to achieve single point of reference to get the customer data from the various databases. Distributed data residing in heterogeneous data sources is consolidated into the target enterprise DW database.

Responsibilities:

• Extensively worked with Informatica Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Designed the mappings between sources files and databases to operational staging targets.
• Implemented Slowly Changing Dimension SCD Type 1 and Type 2 for maintaining the history.
• Translated Business specifications into PL/SQL code. Designed, Developed and fine-tuned Oracle Stored Procedures and triggers.
• Developed various mapplets and transformations, and validated and fine-tuned the ETL logic coded into Power Center Mappings.
• Responsible for validating the Informatica mappings against the pre-defined ETL design standards.
• Performance tuning by identifying bottlenecks of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Increased the cache size for Aggregator, Lookup and Joiner transformation in appropriate mappings to increase the performance.
• Created various Oracle database SQL, PL/SQL objects like Indexes,stored procedures,views and functions for Data Import/Export.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Used CDC for moving data from Source to Target to identify the data in the source system that has changed since the last extraction with the help of CDC.
• Developed various shell scripts for different purposes. For example, starting workflow, reset sequence generators, purge database tables.
• Performed Unit Testing and Integration Testing of Mappings and Workflows

Environment: Informatica Power Center 8.6.1 Repository Manager, Designer, Workflow Manager, and Workflow Monitor , Oracle 10g, SQL/PLSQL Flat Files, Toads, UNIX Shell Scripting, and MS Excel.

Confidential

ETL Developer

Confidential was established in Confidential as Group Health Association of Confidential, a small health cooperative with a handful of subscribers and premiums of less than 2000. Today, Emblem Health is the largest not-for-profit health insurance company in Confidential, offering a full range of medical, hospital, dental, mental health, and vision and prescription drug. Confidential currently provides services for more than 2.6 million individuals.

Responsibilities:

• Understanding functional specification, data model requirement and ETL specification document.
• Extracting sources and targets into informatica from database..
• Used Informatica Designer to create complex mappings using different transformations to move data to Oracle database.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse using different transformations like Source Qualifier, Expression, Filter, Router, Lookup, Aggregator, Rank, Update Strategy and Joiner.
• Extracted Oracle , Transformed and Loaded data into Flat files using Informatica mappings and complex transformations Aggregator, Joiner, Lookup, Update Strategy, Source Qualifier, Filter, Router and Expression .
• Used FTP connection browser available in Informatica Workflow manager.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Target.
• Involved in designing ETL data load strategy for SCD type1, 2 Dimensions and Fact tables.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using server manager.
• Extensively involved in performance tuning of the Informatica Mappings/Sessions by increasing the caching size, overriding the existing SQL.
• Responsible for ETL process under development, test and production environments.
• Handled Production issues and monitored Informatica workflows in production.

Environment: Informatica Power Center 8.6 Designer, Workflow Manager, workflow monitor , Oracle 10g, SQL Navigator 5.0, Windows NT

Confidential

Database Developer:

• Description: Confidential provides a simplified approach to online advertising. As a program adppc advertising is the first of its kind in online advertising, serving advertisers with Strategize-Implement Optimize mode. Adppc is committed to transforming the way online advertising functions.
• Affiliate: An affiliate program is usually offered by a merchant to promote his product service. Adppc lists advertisers, Publishers and Writers through its affiliate program. All you need to do, to sign up is register on adppc Affiliates and select the category of your choice. Post links on your site. All three programs offered are listed and you can choose the program most suited to you.
• Writers: This site allows you to write at your own convenience, on a range of subjects adppc posts a list of topics for the required articles. All you need to do, to access this and sign up with adppc, select specific projects. You can choose single or multiple writing projects. Specifications will be posted and once you have completed your article, all you have to do is to log in to your account and post it.
• Net: One of the easiest ways to earn money through your web site is to host ads. This way, you are driving some of your traffic to partner sites in return for commissions. What's more, with contextual marketing technology, it is possible to have ads that are relevant to your topic to be posted on your sites. By signing up with Adppc Net, you can have ads posted on your site and earn when your visitors click on them. These ads are text ads and can be customized to fit within your site's layout

Responsibilities:

• Written complex SQL queries using joins and sub queries.
• Data modelling using Rational Ross.
• Involved in Backup and Data Recovery.
• Developed Data Access classes to build dynamic SQL Statements and access data from the database.
• Involved in all phases of SDLC from requirement, design, and development and testing.
• Used TOAD as our development environment.
• Involved in Maintenance of the System.
• Involved in Normalization of data.
• Wrote SQL queries and PL/SQL procedures for JDBC
• Used phpMyAdmin tool to handle the administration of MySQL Server over the web.
• Optimized and tuned the queries for faster and better performance.

Environment: HTML,UNIX,MySQL, XML, SQlyog, phpMyAdmin, Windows XP.