ANITHA ATLURI

****, ******** ***,

SCHENECTADY, NY

513-***-****

abxvxy@r.postjobfree.com

Professional Summary:

Around 6 years of experience in Analysis, Design, Development and Implementation of Data warehouse

systems, which include expertise in Informatica, Oracle and SQL Server.

Business Intelligence solutions in data warehousing and decision support systems using ETL tools Informatica

Power Center and work with reporting team to generate reports in Cognos.

Experience in Informatica Power Center Client (including Designer, Workflow Manager, Workflow Monitor,

Repository Manager)

Experience in Data Warehouse development working with Data conversion, Data migration and (ETL)

Extraction/Transformation/Loading using Informatica Power Center with Oracle and Teradata.

Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files,

Oracle into a common target area such as Staging, Data Warehouse and Data Marts.

Knowledge in Troubleshooting and Performance tuning of Informatica mappings and sessions

Monitoring Informatica jobs and analyzing the run time statistics.

Experience with Data Warehouse and BI methodologies (Kimball-Star, Inman-Snowflake Schemas), and strong

understanding of Relational, Multi-Dimensional Database concepts and OLAP Cubes.

Knowledge on OLTP/OLAP System Study, developing Database Schemas like Star schema and Snowflake

schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling

Expertise in implementing complex business rules using different Transformations, Mappings and Mapplets

Expertise in Database design, ER Modeling, DDL, DML and SQL using Oracle, Teradata and SQL Server.

Well Versed with SQL Development Tools like TOAD and SQL Developer.

Have good idea about the onsite-offshore model.

Flexible and versatile to adapt to new environment and working on new projects.

Committed to continuous improvement, excellent communications, and project management skills. Self-

disciplined, focused, solid teamwork and a team player.

Excellent analytical and problem solving skills and ease working within a team and independently. Good

communication and presentation skills.

Technical Skills

O.S UNIX, Windows NT/XP/Vista, Mac OS X.

Languages C, C++, Core Java, SQL, PL/SQL

Web Servers Apache Tomcat.

Databases Oracle, SQL Server, Teradata

Application tools Informatica, MS Office.

EDUCATION

BS/Information Technology Jawaharlal Nehru Technological University Hyderabad, INDIA

Professional Experience:

GE Aviation, Cincinnati, OH Mar’12 –Till Date

ETL Developer

GE Aviation is one of the largest manufacturers of aircraft engines in the world. GE has shop floors in global

locations to cater services to all the customers of aircraft engines.

A. Data quality of parts and invoices is a critical item for business success and growth at GE Aviation. Goal of

this project is to evaluate for pre and post invoice data in the Sales and Cost Data Warehouse. Data Quality

Scorecards are built that will provide feedback mechanism to shop floor users and managers for evaluation

and developing data correction processes in source systems.

Responsibilities:

• Involved in Technical Design discussions, analyzed requirements and Interacted with data modelers, data

support teams to get the enterprise data for High level specs and an effective data model that was made

consistent/reusable across multiple source systems (Shop floors).

• Participated in design reviews to make recommendations on performance, architecture and fault tolerance.

• Worked with business analysts to identify appropriate sources for data warehouse and to document business

needs for decision support for data.

• Involved in Discussions on developing an effective data model that can be implemented as per the MLDM

standards.

• Enhancing the ETL logic in various transformations: Lookup, Expression, Filter, Router, Sorter, Aggregator

etc.

• Created and used parameter files and mapping parameters at run time.

• Created workflows using Workflow manager for different tasks like sending email notifications, timer that

triggers when an event occurs, and sessions to run a mapping.

• Tuned Mappings for optimum performance.

• Created reusable ETL components and maintenance of ETL mappings.

• Involved in creating Test Cases and conducting Test Case Walk Troughs' with the testing Team.

• Involved in unit testing, regression and User acceptance testing

Environment: Informatica Power Center 9.1, Cognos, Oracle 10g, Teradata, UNIX, TOAD.

B. Goal of this project is to enhancement and automation of existing MS Access reports utilizing Informatica and

emailing the extracts to the business users on weekly basis. The existing system had cleansed, transformed

and aggregated data coming from shops floors. But there was no automation and the Targets were Flat files

on which dashboards were hard to develop. So ETL Logic was developed to enhance the system according to

the requirements given by functional users to be able to build reports on the data warehouse.

Responsibilities:

• Requirements gathering from business / functional users

• Analyze the logic being implemented in MS Access and developed ETL code to extract and load data into

Teradata database.

• Various kinds of the transformations were used to implement simple and complex business logic.

Transformations used are: Connected & Unconnected Lookups, Router, Expressions, Source Qualifier,

Aggregators, Filters, Sequence Generator, etc.

• Integrated sources from different databases and flat files.

• 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.

• Created and used different tasks like Decision, Event Wait and E-mail.

• Involved in creating Test Cases and conducting Test Case Walk Troughs' with the testing Team.

Environment: Informatica Power Center 9.1, Oracle 10g, Teradata, UNIX TOAD.

CISCO Systems, San Jose, CA Jun ’11 – Feb’12

ETL Developer

Cisco Systems, Inc. – one of the world’s largest IT solutions firm. Cisco operates in six markets America,

Europe, Middle East and Africa, Asia Pacific, Japan and Latin America. Cisco has evolved from a two products

(routing and switching) to eight products with Integrated Advanced Technologies such as IP Telephony, Security,

Storage, Optical, and Wireless with more to come this year. This project is to address Orders and Sales reporting

requirements of various products. These reporting requirements would source data from various eservices

modules such as Service Request, Customer, Work Order, Installed Base and Service Contracts.

Responsibilities:

• Analyzed business requirements and worked closely with the various application teams and business teams

to develop ETL procedures that are consistent across all applications and systems.

• Worked with heterogeneous sources from various channels like Oracle, flat files.

• Created Several Informatica Mappings to populate the data into dimensions and fact tables.

• Involved in the development of Informatica mappings and also tuned them for optimum performance, and

Batch Design.

• Extensively used ETL to load data from multiple sources to Staging area using Informatica Power Center.

Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.

Knowledge of Identifying Facts and Dimensions tables.

• Extensively used Source Qualifier Transformation and wrote SQL-Overrides, used filter conditions in source

qualifier thereby improving performance of the mapping.

• Used Debugger to test the data flow and fix the mappings.

• Uploaded the data in incremental fashion by using batches & sessions on Informatica Server Manager.

• Used Various Transformations like Expression, Aggregator, Filter, Router, Joiner, Look Up, Update strategy,

Source Qualifier, Sequence generator and Stored Procedure in many mappings.

• Created workflows using Workflow manager for different tasks like sending email notifications, timer that

triggers when an event occurs, and sessions to run a mapping.

• Actively coordinated with testing team in the testing phase and helped the team to understand the

dependency chain of the whole project.

Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL*PLUS, UNIX, Windows 2000,

CVS CAREMARK, HYD,INDIA Oct ’10 – May‘11

ETL Developer

The project objective is enhancing the existing EDW system with the changes occurred in the source systems.

The existing EDW system has the cleansed, transformed and aggregated data for the Recap and RxClaims.

There had been some changes in the source due to the business. Due to this, functional team required to add 25

fields to the EDW system along with their business rules. This activity involves corresponding changes to source

definitions, target definitions, staging area and ETL logic changes from staging to the EDW tables.

Responsibilities:

• Enhancing the source and target definitions using Source analyzer and warehouse designer to incorporate

the new fields added in the source and Target.

• Enhancing the source to staging and staging to EDW ETL mappings by adding the new fields and the

corresponding business logic.

• Enhancing the ETL logic in various transformations: Lookup, Expression, Filter, Router, Sorter, Aggregator etc.

• Extensively worked on Performance Bottlenecks to improve the performance of the sessions and workflows.

• Written SQL overrides in source qualifier according to the business requirements.

• Prepared the unit test cases for all the mappings to test the enhancements.

• Supporting the QA team for integration and system testing.

• Supporting the UAT and production implementation activities.

• Worked with flat files as part of the data is coming from the flat files.

• Created DDLs for new tables and updated DDLs for the existing tables in the data mart.

Environment: Informatica Power Center 8.1.1, Oracle 10g, UNIX, TOAD.

Country Insurance and Financial Services Nov’09- Sept ’10

ETL Developer

Country Insurance and Financial Services is a corporate firm broadly engaged in providing solutions for

Financial and Insurance applications. A temporary Financial Security Office (FSO) was established in 2005 to

coordinate various projects throughout the organization. In November 2007, the FSO was replaced with a new

structure of five financial security committees to guide projects.

Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse and to document business

needs for decision support for data.

• Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework.

• In-depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various

phases such as Requirements, Analysis/Design, Development and Testing.

• Interact with data modeler, data support teams to get the enterprise data for High level specs

• Developed mappings, Sessions and workflows in Informatica Power center.

• Extensively used Lookup transformation and Update Strategy transformation to update SCD’s.

• Extensively utilized the Debugger utility to test the mappings.

• Extensively worked on Performance Bottlenecks to improve the performance of the sessions and workflows.

• Written SQL overrides in source qualifier according to the business requirements.

Environment: Informatica Power center 8.1.1, Oracle 10g, TOAD

Excellus Jul’08 –Oct’09

ETL Developer

The project objectives involve the design and deployment of the Health Plan Enterprise Data Warehouse

(EDW) Release 4.0 (R4.0) with flexible access for reporting and statistical analysis. The objective of Release 4.0 is

to further enhance architecture including but not limited to the physical data model, source data utilized, extract,

transform and load (ETL) routines and reporting platforms to support various requirements for Medical Economics,

Medicare Finance, Pricing, Health Care Affairs and Sales and Marketing.

Responsibilities:

• Extensively used Informatica Client tools – Source Analyzer, Warehouse Designer, Mapping Designer,

Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.

• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router,

Joiner, Source Qualifier, Expression, Sorter and Sequence Generator transformations.

• Analyzed business process and gathered core business requirements.

• Interacted with business analysts and end users.

• Involved in source data analysis.

• Participated in preparing the test cases and supported the QA team during the testing phase.

• Involved in identifying the bottle necks and tuning to improve the Performance.

• Implemented Type 1 Dimension logic in mappings using Informatica Designer

Environment: Informatica Power Center 8.1.1, Oracle 10g, UNIX

Emblem Health, HYD, INDIA Dec ’07 – May’08

ETL Developer

Emblem Health is one of the leading health care clients in North America and helps its clients to how to invest money

in the market. The project is designed to convert the data from the old systems to the database. The conversion

involved in migrate the data from legacy systems in to Database level.

Responsibilities:

• Got Informatica training and got involved in Testing phases of the project

• Involved in creating Test Cases and conducting Test Case Walk Troughs' with the QA Team.

• Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided

feedback to nail down the bugs

• Created reusable ETL components and maintenance of ETL mappings.

• Automated the ETL process through scheduling and exception routines, performance tuning, performance

testing and Optimization of existing processes.

• Designed and Developed the ETL Load Strategy Documents.

• Monitored Loads and sent emails about load statistics to the developers.

Environment: Informatica Power Center 8.1.1, Oracle 10g, Toad, UNIX

Contact this candidate