Manager Data

Saisathya NavaneethaKrishnan

*****,************,*********,*****.*****:704-***-****.Email:**********@*****.***

SUMMARY:

• Around 7 years of total IT experience focusing on Data warehousing and Informatica ETL

process.

• 1 year of experience in Data Migration from Oracle to Teradata platform.

• SDLC: 6 years of IT experience in all aspects of analytics/data warehousing. I have been key in

delivering innovative database /data warehousing solutions using Informatica tool to the

Insurance, Finance and Telecom Industries.

• Developed mappings in Informatica to load the data from various sources into the Data

warehouse using different transformations like Source Qualifier, Sorter, Expression, Lookup,

Aggregator, Update Strategy and Joiner.

• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica

sessions as well as performance tuning of mappings and sessions.

• Databases: 6 years of experience using Oracle 10g, SQL, TOAD.

• ETL Performance Tuning: Broad Experience in ETL tuning including effective use of Table

Partitions, Sub Partitions and performance tuning at transformations.

• Understanding of Dimensional Data Modeling using Ralph Kimball Approach, Star/Snowflake

Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.

• Superior communication skills, strong decision making and organizational skills along with

outstanding analytical and problem solving skills to undertake challenging jobs. Able to work

well independently and also in a team by helping to troubleshoot technology and business related

problems.

• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post

session operations.

EDUCATION:

Bachelor of Engineering in Electronics and Communication in Periyar Maniammai College of

Technology for Women under Anna University, Chennai (2004-2008).

TECHNICAL SKILLS:

Operating Systems : Windows 7/XP.

Programming Languages : C, C++, SQL, PL/ SQL and UNIX.

Databases : Oracle 10g, Teradata.

ETL Tool : Informatica Power Center 8.6.1.

Others : Microsoft Word, Microsoft Excel, Outlook

PROFESSIONAL EXPERIENCE

Client : ING, NY, US

Project Title : Application Development and support (ADS)

Role : Informatica Developer

Duration : Jan 2013 to Mar 2015

Description : Voya Financial is a financial, retirement, investment and insurance

company based in New York, New York. Formerly a full subsidiary of ING Group N.V., ING U.S. was

rebranded as Voya Financial in 2014.Voya Financial, Inc. is composed of premier retirement, investment

and insurance companies serving the financial needs of approximately 13 million individual and

institutional customers in the United States. The company’s vision is to be America’s Retirement

Company and its guiding principle is centered on solving the most daunting financial challenge facing

Americans today retirement readiness.

Application Development and support (ADS) is a development project. The source files received from

OMNI are processed and transformed into informatica compatible format and loaded into the respective

dimension and fact tables in the data warehouse.

Responsibilities:

• Created technical specification for extraction, cleaning, transformation and loading data into

various tables and defining coding standards.

• Worked on ETL processes such as creating mappings using various transformations including

Aggregator, Lookup, Joiner, Stored Procedure, Source Qualifier, Expression, Filter, Router,

Update Strategy and Union.

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

• Developed Workflows to run multiple sessions that are sequential in nature.

• Used parameters and variables at different mappings and sessions.

• Used Debugger to fix errors in the mappings and to check the data flow.

• Partitioned sessions for parallel loading of data into the target tables.

• Executed workflows using pmcmd command.

• Optimized the performance of the mappings by various tests on sources, targets and

transformations. Identified the Bottlenecks, removed the Bottlenecks and implemented

performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency

and performance.

• Identified opportunities for business process improvement and initiated efforts to make

improvements.

• Agile team interaction.

• Assisted in designing test plans, test scenarios and test cases for unit and integration testing.

Environment: Informatica 8.6.1, Oracle 10g, UNIX shell scripting.

Infosys Technologies Limited, Chennai, India March 2009 to July 2012

Client : Time Warner Cable, US

Project Title : Billing System Event (BSE)

Role : Informatica Developer

Duration : January 2011 to July 2012

Description : Time Warner Cable (TWC) (formerly Warner Cable Communications) is

an American national cable television company that operates in 28 states and has 31 operating divisions.

Billing System Event (BSE) is an enhancement project that includes ETL logic and Oracle. The major

events handled are LOSANGELES and SANDIEGO site merge, CSG release I and II, NATIONAL and

LOSANGELES site merge, CAROLINA site merge I and II.

My Responsibilities:

• Designed ETL process using Informatica Designer to load the data from various source databases

and flat files to target data warehouse in Oracle.

• Involved in creating tasks in Workflow Manager such as sessions, event wait/raise, and

assignment, e-mail, and command to execute mappings.

• Optimized mappings using transformation features like Aggregator, filter, Joiner, Expression,

Lookups.

• Created parameter based mappings, Router and lookup and SQL transformations.

• Created mapplets to reuse the transformation in several mappings.

• Used Workflow Monitor to monitor the workflows.

• Created daily and weekly workflows and scheduled to run based on business needs.

• Created Daily/weekly ETL process which maintained 100GB of data in target database.

• Developed PL/SQL stored procedures & triggers for implementing business rules and

transformations.

• Involved in Unit Testing and Integration Testing.

Environment: Informatica 8.6.1, Oracle 10g, UNIX shell scripting

Client : Royal Bank of Scotland, UK

Project Title : Aggregator and Ranking Factor (ANRF)

Role : Informatica Developer

Duration : August 2010 to December 2010

Description : Royal Bank of Scotland ranks among the global leaders in corporate

banking and securities, transaction banking, asset management, private banking and wealth management

and have a significant private and business banking franchise in, urban and suburban areas mostly in UK,

US and India.

Aggregator and Ranking Factor (ANRF) – is a project for Insurance Domain. The RBS insurance mainly

divided into two categories of Motor and Home. The ETL logic gets involved in Home insurance and its

respective enhancements.

Responsibilities:

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

Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow

Manager.

• Designed and developed Mapplets, shortcuts for faster development, standardization and

reusability purposes.

• Ensured the correct application of the business rules through data query after the data is loaded

into the Data Warehouse.

• Worked with DBA's in creating tables, views, stored procedures and function in Oracle for

refreshing the data and scheduling them periodically.

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

concurrent Sessions and scheduling them to run at specified time.

• Used pre-session and post-session scripts for dropping and recreating indexes before and after

loading data into target table to optimize performance for bulk loading.

• Designed and implemented processes using Parameter file to override mapping parameter,

mapping variables, Workflow Variables, Session Parameters, ftp Session and Source-Target

Application Connection parameters.

• Implemented UNIX and Informatica variables to synchronize the development, test, preprod and

breakfix and Production environments.

• Used UNIX Shell scripts for various functionalities.

• Handled the Integration testing of both Home and Motor Insurance.

• Involved in production support to resolve the issues and complete the nightly process.

Environment: Informatica 8.6.1, Oracle 10g

Client : AT & T, US

Project Title : AT & T Business Solution (ABS) In Sales Track

Role : Informatica Developer

Duration : Mar 2009 to July 2010

Description : AT&T is the largest provider of fixed telephony in the United States,

and is also a provider of broadband and subscription television services.

AT & T Business Solution (ABS) is a data migration project which comes under Sales track of AT & T.

Due to the business need and reliability issues; Database of Metadata was migrated from Oracle Database

to Teradata Database.

Responsibilities:

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business

Analysis to Development, Testing, Deployment and Documentation.

• Involved in designing the new database schema and conversion of all the Oracle queries into the

Teradata compatible format.

• Developed the BTEQ scripts to fetch the correct data using the Teradata database.

• Developed, tested and implemented Bteq scripts for DML, DDL and retrieval statements.

• Involved in testing the BTEQ scripts and comparing the result with Oracle database data.

• Involved in tuning the BTEQ scripts upon Business requirements.

• Extracting thousands of data from the database for data analysis.

• Developed views based on user and/or reporting requirements.

• Worked on data warehouses with sizes from 30-50 Terabytes.

• Performance tuned and optimized various complex SQL queries.

• Coordinated with the business analysts and developers to discuss issues in interpreting the

requirement.

Environment: Informatica 8.6.1, Teradata BTEQ scripting

NOUS Info systems, Bangalore India May 2008 – Mar 2009

Client : Arbitron Inc.,

Project Title : Anomaly Reporting

Role : Informatica Mapping Developer

Description : Arbitron is an international media and marketing research firm primarily

serving radio, cable, advertising agencies, advertisers, outdoor and out-of-home media, through its

Scarborough joint venture, broadcast television and print media. The main objective of this project is to

load the Data Warehouse about the details regarding the spending power of the population. The source

data will be provided as flat files and Oracle files. This data will be loaded to the staging area. From the

staging area the data will be loaded to a data warehouse. This data warehouse is used for business

analysis. The aim is to develop an application for getting reports for day to day operations by the Arbitron

Encoding team using the Enterprise Data Warehouse. The application generates a report on a daily basis

giving details of anomalies by media entity for a particular media day. Encoding Operations team uses

these reports to determine various anomalies associated to various media entities and follow up with

media station to rectify the anomalies.

Responsibilities:

• Mapping Business requirements to technical architecture

• Involved in preparing the Detail Design Document.

• Worked on Dimension Mappings like Rule dim, Rule Parameter dim, Hour dim, Engg dim, Time

Zone dim, Media dim.

• Worked on Transaction and the fact mappings like PPM Monitor Fact, APL Clock Drift Fact,

Mention Day Fact and Mention HR Fact. Creating mappings, reusable transformations in

Mapping Designer.

• Involved in Unit Testing

Environment: Informatica 8.6.1, Oracle 10g.

Contact this candidate