Ankita Agarwal

ac4ngi@r.postjobfree.com; 201-***-****

Professional Summary:

8+ years’ experience in development and design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Informatica Power Center.

Experience in diversified fields in Data Warehousing. Worked on various projects involving Data warehousing using Informatica Power Center 8.6, Power Center 9.1, Power Center 9.6, Power Center 10.1 and Power Exchange 9.6

Expertise in designing and developing mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, and update strategy.

Expertise in Developing Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings and Workflows and Backup, Recovery.

Experience in performance tuning of Informatica Sources, Targets, Mappings, and Transformations & Sessions.

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.

Knowledge of different Schemas (Star and Snow Flake Schemas) for query and business analysis requirements.

Experience in creating UNIX shell scripts.

Experience in integration of various data sources like SQL Server, Oracle, Tera Data, Flat files, DB2 Mainframes into the staging area, and Knowledge of Power Exchange.

Strong data base experience in Oracle 10g/9i/8.x/7.x, MS SQL server 2005/2008, DB2 and MySQL

Expertise SQL Query tuning for better performance.

Expertise in development of stored procedures and functions to develop business rules.

Competency in understanding business application, business dataflow, and data relation.

Ability to rapidly learn new concepts together with excellent interpersonal skills.

Excellent skills in understanding business needs and converting them into technical solutions.

Excellent problem solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.

Technical Skills:

ETL Tools

Informatica Power Center 9.6/9.1/8.6/8.5/8.1/7.1, Power Exchange for DB2

Databases

SQL Server 2005/2008, Oracle 10g/9i/8i/8, Teradata, My SQL, MS-Access, DB2 8.0

Languages

SQL, UNIX Shell Scripting

Operating System

UNIX, LINUX, Windows XP Professional/2000/NT/7/10

Scheduling Tool

Informatica Work scheduler, Appworx

DB Tools:

SQL*Plus, SQL*Loader, TOAD, SQL Navigator

Professional Experience:

Client: Genworth Financial, Richmond, VA Apr 2017 - Till Date

Role: Sr. Informatica Developer

Genworth is a financial services company providing financial security and protection through our Mortgage Insurance and Long-Term Care Insurance businesses.

GFB Migration project:

The reason behind is that during several Severity 1 incidents and external audits, it was discovered that Genworth was not equipped to handle major service outages and could not test a majority of their critical systems disaster recovery plans. ETL/HCE fell into this scenario having DR environments and was very cumbersome to manage.

Roles and Responsibilities:

Responsible for requirement gathering, user meetings, discussing the issues to be resolved and translated the user inputs into ETL design documents.

Responsible for documenting the requirements, translating the requirements into system solutions and developing the implementation plan as per the schedule.

Active involvement in development for the Migration of DWH in Mortgage domain from INFORMATICA 9.5.1 (legacy) to INFORMATICA 9.6.1 (GFB).

Using INFORMATICA Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, SQL server and flat files).

Used various transformations like the Lookup, Expression, Update strategy, Filter, Router, Joiner, Source Qualifier, etc.

Involved in requirements gathering and design of data warehouse to integrate data from various source systems.

Performed unit testing of SCD type 2 mappings as well as the Truncate and Load mappings.

Created various Session/Mapping parameters and parameter files.

Wrote complex SQL procedures to insert the records of the created parameters for a respective workflow, into the control tables.

Created packages to promote the code developed into other environments using Harvest.

Documented INFORMATICA mappings in Excel spread sheet.

Worked on various kinds of relational sources and targets like the Oracle, SQL Server and also the file sources.

Involved in Modify the dimensional model, database structure, and ETL jobs to support upcoming project (lending transformation) changes.

Involved in leveraging the conformed dimensions.

Involved in creating data feed to outside vendors using ETL jobs.

Involved in development work of various enhancements to support LT project.

Re-created the workflows from the legacy system to the new GFB system and tested them and fixed the errors.

Involved in the GFB standardization.

Co-ordinated with the offshore team for testing the various workflows as part of GFB standardization process.

Performed unit testing on the code developed and wrote the various test cases.

Created the basic UNIX shell scripts to relate the INFORMATICA sessions and the records inserted into the control tables for the session parameters.

Environment: INFORMATICA 9.5/9.6, Power exchange 9.5/9.6 Oracle, DB2, SQL Server databases, Mainframe (Power Center).

Ameriprise Financial, Inc., Minneapolis, MN Apr 2013 - Apr 2015

Role: Informatica Developer

Description: Ameriprise Financial, Inc. is one of the leading diversified financial services companies in the U.S. Ameriprise Financial engages in business through its subsidiaries who provide a wide range of financial planning, products and services designed to be utilized as solutions for its clients’ cash and liquidity, asset accumulation, income, protection, and estate and wealth transfer needs, including wealth management, asset management, insurance, annuities and estate planning. I worked as a Lead Informatica developer in FAM project. It’s the Financial Analytics and Modelling data store which gets its data from different Annuity systems. The data will be refreshed in this data store on weekly and monthly basis after all the transformation rules have been applied on the data. This will be a single and central source of truth for all the downstream modelling application and reporting needs

Responsibilities:

Gathered requirements from business analysts and designed and developed functional and technical specifications, Incorporated identified factors into Informatica mappings to build Data Warehouse.

Developed Transformation logic and designed various complex mappings in the Designer for data load and data cleansing.

Implemented SCD-Type 1/Type 2/Type 3 and Fact Tables.

Accessed the mainframe file by creating data maps in Power exchange.

Developed mappings, mapplets using Informatica Designer to integrate data from various sources like Oracle, PeopleSoft, COBOL, flat files and DB2 and loaded into target including Teradata, Oracle.

Created reusable mapplets, transformations and mappings using Informatica Designer.

Focused on fixed and de-limited flat files, also worked with direct and indirect flat files

Schedule the Informatica jobs using APP WAX scheduler

Created MFT scripts to transfer the files to Business LAN

Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows

Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.

Created mapping using various Transformations like update strategy, lookup, stored procedure, router, filter, JAVA, SQL, Sequence generator, Joiner, aggregate and expression transformations in extracting data in compliance with business logic developed.

Created Sessions, Reusable Worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.

Hands on experience in handling large volumes of data in production environments.

Created medium to complex PL/SQL stored procedure for Integration with Informatica using Oracle 10g

Environment: Informatica Power Center 9.1/8.6, Oracle 9i 10g, PL/SQL, SQL Server 2000, Flat files, COBOL, SQL loader, UNIX Shell Scripts

Oracle Corporation Bangalore INDIA, Dec 2010 –Oct 2012

Role: Informatica Developer

Description: Core Logic warehouse is built to load the data of Customers, Loan Plans and Transactions from different sources through Informatica server and generating reports on quarterly basis to help the business Analysis.

Responsibilities:

Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouse.

Developed mappings to extract data from SQL Server, Oracle, Flat files, XML files, and load into Data warehouse using the Mapping Designer.

Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.

Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.

Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.

Written Queries, procedures, created Indexes, primary keys and data bases testing.

Defects were tracked, reviewed and analyzed.

Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.

Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.

Worked with Reporting team to Generate reports using BO.

Identified sources, targets, mappings and sessions and tuned them to improve performance.

Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc.

Used command line mode to embed pmcmd commands in to shell scripts and used pmcmd, pmrep commands in Interactive mode to access repository and workflows.

Environment: Informatica PowerCenter 8.1/7.1, Oracle 9i, PL/SQL, SQL Server 2000, Flat files, Sql loader, UNIX Shell Scripts, BO.

Oracle Corporation Bangalore INDIA,

Role: Informatica Developer

Client: Scottsdale Insurance

Worked for a Scottsdale Insurance client on Actuarial Data Warehousing Project.

Project Description:

Scottsdale Insurance is a leading provider of insurance and other financial services to millions of individual and institutional customers throughout the United States.

Actuarial data warehousing project for life insurance business was to replace the manual processes done to calculate reserves by automating it through ETL processes. This process also involves replacement of old valuation system with new valuation system. Valuation data processed through new valuation system is stored in Valuation Database (Oracle 11g). Posting sheets are generated from Valuation Database with the help of Business Object reports. Posting sheet reports generated from BO are then posted to General Ledger.

Tools/Languages used: Informatica Power center, Oracle 11g, UNIX, WinSCP, Putty

Contributions:

oTo understand and document the business requirements from the respective business teams.

oTo study and analyze the source data.

oConduct meeting with the business teams to clarify queries regarding requirement and get signoff on the requirements.

oCreate & review Informatica mappings/sessions/workflows on the basis of the low level design documents.

oConduct code reviews for other members of the team.

oPrepare unit test cases and perform unit testing.

oPrepare integration test cases and perform integration testing.

oRepeating the Individual modules and integration testing cycles after bug fixes.

Provide weekly status to customer

i-Flex Solutions, Mumbai, INDIA May 2008 – Nov 2010

Role: ETL Developer

Client: Verizon

Description: Verizon is a global leader in delivering innovation in communications, information and entertainment. This project is to develop the DWH to store the data of customers, calling plans, contract details, etc. from different sources through Informatica and generating reports for business analysis’s to improve the business. Veri per is the project to monitor the wireless problems in different regions and see the performance of wireless service in different regions, and also identify the serious problems in the wireless services across different regions.

Responsibilities:

Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.

Created new mappings according to business rules to extract data from different sources, transform and load target databases.

Debugged the failed mappings and fixed them.

Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.

Modified the mappings according to the new changes and implemented the persistent cache in several mappings for better performance.

Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.

Involved in writing stored procedures and shell scripts for automating the execution of jobs in pre and post sessions to modify parameter files, prepare data sources.

Identified the issues in sources, targets, mappings and sessions and tuned them to improve performance.

Created and used reusable mapplets and worklets to reduce the redundancy.

Developed robust Informatica mappings and fine-tuned them to process lot of input records.

Environment: Informatica power center, Oracle9i, SQL, PL/SQL, Solaris, MS Vision, and MS-Access.

Contact this candidate