Data Manager

Harshitha Potluri

Sr. Informatica Developer

Summary

Over 6 years of experience working with ETL Architecture using Informatica Power Center

9.1/9.0.1x/8.6.1x/8.5/8.1/7.x.

Proficient in Extraction, Transformation and Loading of data from various sources like Flat files, Cobol,

Excel, XML, DB2, Oracle, SQL Server, Teradata.

Well versed in developing and testing complex mappings, using transformation like Filter, Router,

Expression, Aggregator, Connected and Unconnected Lookup, Source Qualifier, Update strategy, Sequence

Generator, Normalizer, Rank, Stored Procedure, XML Source Qualifier, Joiner and more.

Expert knowledge in Relational and Dimensional Modelling techniques such as Snowflake Schema, Star

Schema, ODS, Fact and Dimensional table and OLAP.

Vast Knowledge in Data Warehouse Development Life Cycle where all dimensions of development

including Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses

and Data Marts using Informatica Power Center.

Very good experience in the field of Information Technology with expert knowledge in Database and Software

Development Life Cycle.

Streamlined in testing data flow by using Debugger and tuning the Data Warehouse which includes Oracle

SQL query tuning and Informatica Power center for finding out bottlenecks.

Good knowledge in working with Slowly Changing Dimension (SCD) Management type 1 and 2.

Worked on high volume datasets from various sources like Oracle, SQL Server, Flat Files and XML.

Served as developer on Informatica components that included Source Analyzer, Target Designer,

Transformation Developer, Mapplet Designer and Mapping Designer.

Analyzing business user’s needs, developing expanded data warehouse reporting and ETL routines to support

reporting needs.

Involved in the Migration process from Development, Test and Production Environments.

Good knowledge in UNIX Shell Scripting and Autosys for scheduling the Workflows.

Experienced in working with large teams in a Data Warehousing Environment.

Self-motivated, a very quick learner and a good team player.

Good communication skills, learning skills with strong presentation and ability to interact with people at any

levels.

Technical Skills

ETL Tools/Data Informatica Power Center 9.1.0/9.0.1/8.6.1/8.5/8.1/7.1, Data Mart, OLAP, OLTP,

Warehousing Informatica Power exchange 8.x/9.1.0

Languages SQL, PL/SQL, MY SQL, UNIX Shell Script, XML

Data Modeling Star Schema, Snowflake Schema, Fact and Dimension Tables, Physical and

Logical data Modeling, Erwin 4.0

Environment Windows NT/2000/Windows XP/Windows Vista/ Windows 7,UNIX, MS Visio, MS-

DOS

Data Bases Oracle 11g/10g/9i, MS SQL Server 2005/2008, DB2, Teradata

Other Tools and Flat File, SQL Plus, SQL Navigator, Autosys, TOAD, MS-Office

Utilities

Education

• Bachelor of Technology in Electronics and Communications Technology, JNTUK, India. Month & Year

Degree received : May, 2008

Professional Experience

Client: Sallie Mae, Fishers, IN

Role: Senior Informatica Developer/ Consultant: Harshitha Potluri

Name of Employer: Vamsi Katta and City: Fremont & State Located : California

Duration: Feb 2014 – March 20, 2015

Sallie Mae is a Multibillion dollar publicly traded American corporation whose major operations involve

servicing, originating and collecting student loans. Sallie Mae now is in process of separation and forming two

completely independent companies, Sallie Mae and Navient. Under Sallie Mae OpSys which is an abbreviation

for Private Credit Operational System, is an Informatica application running on top of an Oracle database. OpSys

supports real-time and batch interfaces and processing executes seven days a week and supports daily, weekly and

monthly processing schedules. Cognizant (CTS) is the main vendor under which OpSys was operated for Sallie

Mae.

Responsibilities:

• Designed High Level Technical System Design (HHTSD) and Low Level Technical System Design

(LLTSD) for OpSys according to the business needs which involved source to target documentation along

with business analysis.

• Involved in developing ETL workflows using Informatica for periodic data loads from source to Client

data-bases.

• Monitor Performance, troubleshoot and tune ETL processes as required as well as validated and verified

the data in the Client databases.

• Created various types of mapping for OpSys using transformations like lookup, filter, expression,

aggregator, union, joiner, router, sorter, sequence generator and update strategy.

• Troubleshoot basic to high complexity coding/configuration issues encountered in the development or

production environments working with software vendors as needed.

• Extensive experience working with TOAD to run SQL queries and Stored Procedure for Unit Testing

• In charge of designing, development and implementing Informatica ETL process layers.

• Created several informatica session parameters and workflow parameters as required.

• Involved in debugging of mappings using break points, testing of stored procedure and functions as well

as testing Informatica sessions, commands, batches and the target data.

• Used the Power Center tool set to update customer databases, working both independently and within a

team environment.

• Involved in writing various UNIX Shell scripting command tasks like create, delete, ftp and archive tasks.

• Created various ETL codes based on source to target documentation and system designs to fulfill the need

of the business.

• Executed Slowly Changing Dimension (SCD) Type 1 and Type 2 for inserting and updating Target tables.

• Make sure that Quality Assurance test plans are well executed before releasing product enhancements for

User Acceptance Testing.

• Identified bottlenecks in source, target mappings and sessions and had to tune them for optimum

performance.

• Involved in Twenty four hour production support once a week every two months on a periodic basis.

• Attended On-call Turnover meeting, account meeting, status meeting and other weekly and bi-weekly

meetings related to the project.

Environment: Informatica 9.1.0, Informatica Power Exchange 9.1.0, Toad 11.5, Oracle 11g, SQL, PL/SQL,

Windows 7, UNIX.

Client: Covidien, Mansfield, MA

Role: Senior Informatica Developer/ Consultant : Harshitha Potluri

Name of Employer: Vamsi Katta and City: Fremont & State Located : California

Duration: Aug 2012- Nov 2013

Covidien is a global healthcare products leader dedicated to innovation and long-term growth. They create

innovative medical solutions for better patient outcomes and delivers value through clinical leadership and

excellence. Covidien identify clinical needs and translate them into proven products and procedures. Over the

years, Covidien is a leading provider for number of medical advances including contrast media, pulse

oximetry, electro surgery, surgical stapling and laparoscopic instrumentation. The Data warehouse in Covidien

tracks the information about the sales management, customer details and charge backs by maintaining the

information in the oracle database as target database and then generating the reports based on the requirements.

Responsibilities:

• Designed ETL processes by leveraging SQL scripting and Enterprise Data Integration tools.

• Extracted structured and unstructured data from source systems, transforming them to fit

dimensional models. Data source formats include relational databases, flat files and non-relational

structures such as XML.

• Assisted with the mapping of processes, monitoring the data and analyzing data sources.

• Worked with Client with extensive data integration and transformation.

• Used various active and passive transformations such as Aggregator, Expression, Router, Filter,

Sorter, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control,

cleansing, and data movement.

• Comprehensively used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in

the Joiner Transformation.

• Creating/Building and Running Sessions/workflows and worklets using the Workflow Manager/

Workflow Monitor.

• Designed and implemented proper error handling procedures.

• Prepared and maintained technical documentation for all new or modified Repository objects and

ETL Mapping.

• Involved in designing of Star Schema based data model with dimensions and facts.

• Participated in designing of new data warehouse tables as per need.

• Designed and conducted unit tests for new or changed repository objects and ETL mappings.

• Extensive experience in Performance Tuning where I need to Identify and fix bottlenecks and

tune the complex Informatica mappings for better Performance.

• Responsible for creating staging area through informatica tool.

• Briefly worked with CDC (Change Data Capture) using Informatica Power Center.

• Converted Business processes into Informatica mappings for building Data marts.

• Monitored and optimized the performance of the ETL routines and environment.

• Used Workflow Manager for Creating, Validating, Testing and running the sequential, parallel,

and initial and Incremental Load.

• Performed migration strategies between development, test and production repositories.

Environment: Informatica 9.0.1/8.6.1, SQL server 2008, Oracle 10g/11g, SQL, PL/SQL, DB2, Erwin, UNIX,

Windows XP.

Client: UCB Pharma, Smyrna, Georgia

Role: Senior Informatica Developer/ Consultant : Harshitha Potluri

Name of Employer: Vamsi Katta and City: Fremont & State Located : California

Duration: June 2011- May 2012

UCB Pharma is a biopharmaceutical company that is focused on the development and discovery of

innovative medicines and solutions to transform the lives of people living with severe diseases of the immune

system and nervous system. The UCB Pharma has been designing, implementing and operating its Customer

Master, Operational DB and Data Mart of UCB Pharma Business Information Architecture. To carry out the

task we are maintaining Databases, namely Raw DB, Operational Database (ODB) & Data Mart DB

(DM_DB). The Process of Data movement can be in done in 3 phases, in the first phase data movement is

between UCB to Raw DB, in the second phase Raw DB to Operational DB and in the third phase Operational

DB to Data Mart DB by using various business logics as per need.

Responsibilities:

• Created mappings using Flat Files and Relational Targets.

• Performed data analysis, assist data analysts with mapping data from existing systems and helped

generate required SDLC documentation.

• Assist the Development Lead in developing project plans to ensure Informatica solutions are executed

flawlessly.

• Worked with logical and physical database designs using model viewers.

• Involved in writing the SQL and PL/SQL procedures and program blocks for data extraction,

transformation and loading.

• Extensively worked with Transformations like Router, Normalizer, Lookup, Aggregator, Expression and

Update Strategy Transformations.

• Key tasks included source-target analysis, design of source-target mapping specifications, development of

Informatica mappings and workflows and end to end testing of interfaces.

• Used Lookup Transformation to access data from tables, which are not the source for mapping and also

used Unconnected Lookup to improve performance.

• Created and implemented Informatica workflows.

• Automation of ETL processes with scheduling tools and exception-handling procedures.

• Optimized code performance by analyzing indexes, joins and views.

• Involved in Inserting the new records and Expire the old records using the built-in's DD_UPDATE,

DD_DELETE, and DD_INSERT.

• Developed complex mappings also involving Slowly Changing Dimensions (SCD) Type-I and Type-II

mappings in Informatica to load the data from various sources.

• Used Repository manager to create Repository, User groups, Users and managed users by setting up their

privileges and profile.

• Used tools like TOAD to run SQL queries and validate the data.

• Evaluated the performance issues in the DataMart’s which included analyzing query plans by involving

the DBA’s for the SQL override lookups.

• Extracted data from various sources like Teradata and relational databases (Oracle).

• Used Debugger to test and track the path of the source data and also to check the errors in mapping.

• Worked with fellow employees and client team members in planning, design development of ETL

solutions.

Environment: Informatica 8.6.1, SQL server 2008, DB2, SQL, PL/SQL, SQL Navigator, Oracle 10g, TOAD,

Erwin, Autosys, Teradata, UNIX, Windows XP.

Client: JP Morgan Chase, Wilmington, DE

Role: Informatica ETL Developer/ Consultant: Harshitha Potluri

Name of Employer: Vamsi Katta and City: Fremont & State Located : California

Duration: April 2010- May 2011

The JP Morgan Chase is one of the oldest financial institutions in the USA. It is an American

multinational banking corporation of securities, investment and retail. JP Morgan Chase is one of the Big four

banks in the United States of America with Bank of America, Citigroup and Wells Fargo. It ranks as the

largest bank in the USA by Assets. The Project in the JP Morgan Chase involved building data warehouse and

data marts and integrating the new product to fit in the existing warehouse.

Responsibilities:

• Designed and developed Mappings using Mapping Designer to load the data from various sources using

different transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, Ranker,

Joiner, Stored Procedure, Update Strategy and Re-usable transformations.

• Created Sessions, Workflows and Worklets for data loads using Workflow Manager.

• Involved in designing the technical design of data model and reviewing the physical data model design.

• Created various Tasks, arranged related task in different worklets, arranged different worklets in

workflow depending upon their inter dependencies in workflow Manger.

• Created and modified Oracle Database tables as per the design needs and applied constraints to maintain

complete Referential Integrity and creating indexes for performance and loading the data into Oracle

database tables.

• Worked with BI team and actively participated in discussion with users for gathering requirements and to

provide accrete data for report.

• Involved in creating various types of UNIX scripts which helped the ETL scheduling jobs and helped in

initial validations of various tasks.

• Converted the SQL and PL/SQL Procedures to Informatica mappings.

• Created scripts for various database objects related to the data model which involve in creation of schema,

tables, sequences, views, Materialized views, constraints, and indexes.

• Created in designing of star schema based data model with dimensions and facts.

• Involved in Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop

optimum solutions for data warehouse deliverables.

• Held various interactive meetings with different users and business analysts for a clear understanding of

the Business needs and to bridge the gap between user needs and tool functionalities.

Environment: Informatica Power center 8.6.1, UNIX, Windows XP, Informatica Power Exchange, Oracle 9i,

Flat Files, SQL/PLSQL, and SQL Server 2008.

Client: Xerox Business Services, Austin, TX

Role: Informatica Developer/ Consultant: Harshitha Potluri

Name of Employer: Vamsi Katta and City: Fremont & State Located : California

Duration: Feb 2009 – March 2010

Xerox has been a leader in document technology and services in the past half century. It is the top

enterprise for business process and document management, offering global services from claims

reimbursement and automated toll transactions to customer care centers and HR Benefits management. The

responsibility as an ETL developer was to design, develop, test, maintenance and support of complex data

extracts, transformation as per business needs.

Responsibilities:

• Used Informatica Power center for building the data warehouse and DataMart’s which focused on

the transformations namely Expression, Sequence Generator, Stored Procedures, Filter, Unconnected and

Connected Lookup, Aggregator and HTTP transformation.

• Debugging of invalid mappings by using break points, testing of Informatica sessions, testing of

stored procedures and functions, batches and the target Data.

• Worked on various different independent schemas around the database creation.

• Worked closely with data modelers on Erwin tool for dimensional modeling of Star schema.

• Worked on performance tuning by creating indexing, hints, used explain plans and analyzing the

database.

• Created technical design specifications for mappings, sessions and workflows.

• Extensively worked with aggregate functions like Min, Max, First, Average and last in the

Aggregator Transformation.

• Used re-usable transformations, mappings and mapplets confirming to the Business rules.

• Involved in Various Data Cleansing and Data Conversion Functions in various transformation.

• Widely used SQL Override function in Source Qualifier Transformation.

• Reviewed the performance issues in the DataMart like analyzing and optimizing query by linking

the DBA’s for the SQL override look up’s.

• Reviewed, analyzed, and modified programming systems including encoding, testing, debugging

and documenting programs.

• Set up informatica Schedules to execute the designed workflows in timely fashion.

• Worked closely with the reporting team to create various reports.

• Worked for a combination of Relational and dimensional data modeling.

Environment: Informatica Power Center 8.6.1, Oracle 9i, PL/SQL, Toad 7.2, Flat file, Autosys, Erwin,

Windows XP, XML, SQL Server.

Contact this candidate