Krishna Reddy 6a6z6t

Krishna Reddy Ph: 07411601569 [email protected] 5/5.5/20 Professional Summary: •

• • • • • • • • • •

Having around 4 years of work experience in IT Industry in Analysis, Design, Development, Maintenance and of various software applications mainly in Data Warehousing(Informatica Power Center), Oracle (SQL, PL/SQL) and Windows environments in industry verticals like Manufacturing, Retail, and Healthcare. Extensive Knowledge of Informatica Designer and Workflow Manager. Hands on experience in deg different mappings using available Trasformations according to the requirement. Hands on experience in Tuning mappings, identifying and resolving performance bottlenecks using Performance tuning techniquies in various levels like sources, targets, mappings and sessions. Expert in deg and developing of complicate ETL mappings using Informatica PowerCenter. Exposure in Star-Schema,Snow-flake schema,Data modeling,Staging and ODS concepts.. Good knowledge on Fact and Dimensional tables. Good knowledge on UNIX Commands. Sound knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, Stored Procedures and Triggers Preparing the Documentation for the mappings according to the Business Requirements. Team player, motivated and dynamic with excellent oral and written communication skills

Experience Organization Tata Consultancy Services, Bangalore.

Technical Skills

Duration Sep 2007 – Till Date

Operating Systems

Windows 9x, Windows XP,DOS, Unix

Tools

Informatica7.1/8.6,Toad,ESP.

Languages

C, SQL, PL/SQL.

Databases

ORACLE 9i and 10g.

Web Related

HTML, XML.

Methodology

Snow-flake Schema/Star schema.

Projects Profile: Project 1: Project Name Client Duration Team Size Environment (with skill versions)

DFS Store Ops BI Project MIDAS MART ,US Dec 2010-Tilldate 5 Software Tools: Informatica Power Center 8.6 Database: Oracle 10g O/s: Windows XP (Development) and UNIX

Project Description: Midas is a global company, which runs the largest supermarket chain. The goal of this project is to provide Sales Analysis and purchase Analysis reports for the Management of Supermarket to take the Business Decisions. This project involves Retail business for Entertainment, Sports, Toiletries, and Food grains, Cosmetics etc. The whole process has been automated and the entire extraction, transformation and loading process has been done with help of INFORMATICA. Responsibilities: • Developed Informatica mappings to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, UpdateStrategy, SequenceGenerator, er, Filter, Rank and Router transformations. • Data migration from one environment to another environment using ETL Informatica tool. • Analyzing the existing code. • Extracting, Transforming and Loading the data from Source to Staging and Staging to Target according to the Business requirements. • Created Test scripts for informatica mappings. • Involved into source code review. • Created Sessions, Reusable Worklets in Workflow Manager and scheduled the sessions to run at a specified frequency. • Created Informatica ETL code from functional and technical specs. • Tuned SQL statements for end s creating custom reports. • Reviewed and tested existing Informatica code. Project 2:

Project Name Client Role

BI Infrastructure Norelco Consumer Products Co Team member

Duration Team Size Environment (with skill versions)

Jan 2010- Oct 2010 4 Software Tools: Informatica Power Center 8.1.1 Database: Oracle 10g O/s: Windows XP, UNIX

Project Description: Norelco is a leading manufacturer of men's personal grooming products, including electric razors, beard and mustache trimmers, and hair clippers. Norelco is dedicated to developing grooming solutions for men through research, leading-edge technology, and innovation. Being a market leader in its own niche, marketing team needs an eye on the sales figures, and collect as much information about it as possible. This data is then analyzed statically using advanced scientific methods to foresee trends and patterns in sales and make important business decisions like deg new marketing campaign, introducing new product, discontinue non-performing product etc. Responsibilities:

• Used ETL tools Informatica for extraction, Transformation and loading data into data warehouse. • Used various Transformations like Expression, Filter, er and Lookup to migrate clean and maintain data. • Created test scripts and involved in deployment activities. • Performance Tuning and Debugging of existing ETL processes. • Successfully Implemented Slowly Changing Dimensions. Used Type 2 dimension to keep the history changes. • Prepared Mapping documents. • Created Sessions, reusable Worklets in Workflow Manager and scheduled the sessions to run at a specified frequency. Project 3: Project Name Client Role Duration Team Size Environment (with skill versions)

ASBI (Advanced Services Business Intelligence) Eli Lilly, Indiana Team member Jan2009 to Dec 2009 5 Software Tools: Informatica Power Center 7.1.1 Database: Oracle 9i O/s: Windows NT.)

Project Description: This Data Warehouse is constructed to stage the Sales & Distribution and Inventory related data for Eli Lilly Pharmaceuticals (Pharmaceuticals and Hospital related products). Informatica

was used to Extracting data from source system to target systems. There are numerous sources of data coming into the warehouse including Oracle and flat files. Responsibilities: 

        

Extensively worked in the performance tuning of programs, ETL procedures and processes. Error checking and testing of the ETL procedures and programs using Informatica session log. Data migration from one environment to another environment using ETL Informatica tool. Developed Unix Shell scripts and Perl Scripts to extract and convert data from different legacy systems in databases. Worked extensively with central data repository and pharmaceutical R&D domain. Involved in Pre clinical safety measures and drug safety evaluations. Worked extensively on Oracle database 9i and flat files as data sources. Developed and fine-tuned PL/SQL stored procedures to increase the performance. Huge volumes of Data extraction from legacy systems and ed into Oracle using SQL*Loader and PL/SQL. Developed UNIX shell scripts to automate applications, Schedule jobs, develop interfaces. Performed integrated testing for various mappings. Tested the data and data integrity among various sources and targets.

Project 4: Project Name Client Role Duration Team Size Environment (with skill versions)

Business Metrics Initiatives Morgan Stanley, New York Informatica Developer Sep2007 to Nov 2008 3 Software Tools: Informatica Power Center 7.1 Database: Oracle 8i O/s: Windows NT.

Project Description: This project is developed for delivering daily basis data from different legacy source system to the end client/ request and maintaining different applications such as Business Metrics Dashboard, Management Dashboard and Views, Month end Applications, Market Data application etc. These applications are used by the s and managers for analyzing the data and reports. In this application we are using Informatica as ETL and Teradata and SQL as database and for report purpose BO is used.

Responsibilities: •

Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems such as Oracle, Flat files, etc. feeds using Informatica Power Center, PL/SQL.

• • • • • • •

Installed and configured Informatica Power Center 7.1 and Informatica Client tools. Extensively worked on Power Center Designer (Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, and Mapplet Designer). Extensively used Transformations like Aggregator, Router, er, Expression, Lookup, Update Strategy, and Sequence Generator. Extensively worked in the performance tuning of programs, ETL procedures and processes. Error checking and testing of the ETL procedures and programs using Informatica session log. Data migration from one environment to another environment using ETL Informatica tool . Developed Unix Shell scripts to extract and convert data from different legacy systems in databases. Performed integrated testing for various mappings. Tested the data and data integrity among various sources and targets.

Personal Profile: Name Nationality Date of Birth Status Address

: Krishna Reddy : Indian : 01/06/1985 : Single : No- 254, 8th cross, Aswath Nagar Marathahalli, Bangalore-37.