Data Warehouse

S AI N EERUKONDA

Cell: 248-***-**** ***.**********@*****.***

D ATA W AREHOUSE AND I NFORMATICA P ROFESSIONAL

Hands on over 8 years of experience in architecture, analysis, design, development, and testing of data

integration and data warehouse applications. Experienced in ETL, data integration, data quality of various

OLAP databases and warehouse appliances.Experienced in writing Hadoop Hive scripts.

Skilled Informatica professional experienced in the development of complex mappings, mapplets,

reusable objects, and SQL. Expertise in Netezza, performance tuning, writing complex UNIX Shell scripts

including parallel processing, and calling Informatica Work Flows.

Proven Data Warehouse developer with extensive knowledge of dimensional modeling, Star and

Snowflake schemas and the data warehouse development project Lifecycle.

PROFESSIONAL EXPERIENCE

CLASSMATES ONLINE INC ; Seattle, WA 09/2008 Present

BI D EVELOPER (CM D ATA WAREHOUSE )

The main objective of CM Data warehouse is to store the daily click stream data for Classmates

Domestic and International.This click stream data will be used for reporting purposes by the business users

throughout the world.

R ESPONSIBILITIES :

Gathered requirements and architected data integration/ETL solutions using Informatica and

•

Netezza SQL.

Performed Impact Analysis and provided solutions for Enhancement Requests from the ETL

•

perspective.

Was responsible for writing complex Informatica mappings and advanced NZSQL scripts to load

•

larger data sets.

Suggested and implemented best practices and lessons learned for complex ETL solutions.

•

Simplified development and maintenance of Data Warehouse by creating re usable objects in

•

Informatica and SQL.

Successfully implemented generic scripts to pull the data from the Hive (Big data) to Netezza

•

database.

Extensively involved in performance tuning by determining various bottlenecks in Informatica by

•

using advanced functionality like push down optimization, and using SQL scripts.

Improved data quality by doing the data cleansing of source data using various functions in

•

Informatica.

Was responsible for converting Oracle stored procedures to Informatica/Netezza based solutions.

•

Performed RCA (Root Cause Analysis) in order to identify root causes for production defects.

•

Conducted code walk through of programs for defects, semantics and standards checking.

•

Created detailed development support operations guide for offshore and on site team members of

•

free borders.

Provided 24/7 on call support for Informatica, Unix Shell Scripts and Oracle PL/SQL programs.

•

A CCOMPLISHMENTS :

Improved performance of the ETL process from 8 hours to 6 hours.

•

Delivered analytical capability to business with respect to 10 different types of user generated

•

content on Social networking sites by developing and integrating ETL processes using Informatica

mappings and Netezza.

Led several POCs (proof of concept) for Classmates Warehouse including enabling push down

•

optimization in Informatica, Netezza bulk loader and several other projects.

Successfully converted Oracle stored procedures to Netezza.

•

SME (Subject Matter Expert) for analyzing various UGC types, email data and order data.

•

E NVIRONMENT :

Saikumar Neerukonda Page 1 of 5

I nformatica Power Center 9.0.1, Netezza 6.0, Oracle 11g, Hadoop,Hive, Microstrtegy,CA ERWIN,

Informatica DQ 9.0.1, Informatica DX and Linux

Safeco Insurance ; Seattle, WA 06/2008 09/2008

ETL D EVELOPER /A DMINISTRATOR (S AFECO I NSURAN CE D ATA WAREHOUSE )

D EVELOPMENT /M AINTENAN CE R ESPONSIBILITIES :

Prepared the Detail Design Document from the requirements specification document.

•

Tuned performance of Informatica session for large data files by increasing block size, data cache

•

size.

Develop ETL processes using Informatica, Teradata fast load,Multi load scripts

•

Extracted data stored in different databases such as Oracle 9i, SQL server, Flat files and to load

•

data into staging tables first and then into Teradata.

Actively participated in the client meetings and suggested solutions for critical tasks.

•

Administer the Repository by creating Folders and logins for Group Members.

•

Involved in Upgrading the Informatica Repository from 7.1 to 8.1

•

A CCOMPLISHMENTS :

Successfully Implemented Informatica ETL/Administration standards.

•

E NVIRONMENT :

Informatica Power Center 8.1, Oracle9i, Teradata, Windows, SQL Server

GE Global Risk Management ; Stamford, CT 06/2006 12/2007

ETL D EVELOPER /A DMINISTRATOR (GRM D ATA WAREHOUSE )

O VERVIEW :

The Risk Exposure Monitoring development effort within the Global Risk Management is designed to

provide GRM employees at all levels with easy access to the exposure data that they need. Data will be

collected from each GE Capital business globally. The Risk Exposure Monitoring project includes the

creation of an Enterprise Data Warehouse for GRM, to meet specific business needs and feed a number of

Data Marts. The data files that populate the Data Warehouse will be supplied by the various GEC

businesses. The Informatica maps are used for the implementation of the business rules and for the

creation of data used in reports.

R ESPONSIBILITIES :

Captured Business requirements and analyzing the current GRM business processes and system.

•

Prepared the Detail Design Document from the requirements specification document.

•

Defined responsibilities, assigning the work from functional & technical perspectives and reviewing

•

deliverables.

Requirements gathering and Impact Analysis for Change Requests or Enhancements and testing.

•

Tuned performance of Informatica session for large data files by increasing block size, data cache

•

size.

Worked on Teradata utilities like BTEQ, FastLoad Fast Load, Multi Load Scripts.

•

Understanding the Transformations carried out in the sample feeds and ascertaining the correct

•

outcome or possible causes of error.

Extracted data stored in different databases such as Oracle 9i, SQL server, Flat files and to load

•

into Teradata database.

Documentation of the New Process and knowledge Transition to the Support Groups

•

Administer the Repository by creating Folders and logins for Group Members.

•

E NVIRONMENT :

Informatica Power Center 8.1/7.1/6.1, Informatica Power Connect/Power Exchange, Teradata,

Oracle10g, MS SQL Server, UNIX, Teradata Fastload, Multi load Scripts, Cognos, Business

Objects Sun Solaris 5.8 UNIX, and Windows NT 4.0

GE Asset Management ; Stamford, CT 06/2005 05/2006

E TL D EVELOPER (GEAM D ATA WAREHOUSE )

O VERVIEW :

GE Asset Management is a wholly owned subsidiary of GE (General Electric) that is in to Funds

Management and Portfolio Management business. The main objective of GEAM Data warehouse is to store

all the holding, Security and transaction information from all the businesses under GE Insurance. GEAM

provides an active bottom up approach to manage a full range of U.S Equity, International Equity, Fixed

Income, Asset Allocation and Money market strategies. It also offers a family of Mutual Funds designed to

meet a wide variety of Investment needs.

R ESPONSIBILITIES :

Designed and executed Test cases and obtained the desired results.

•

Developed Informatica Mappings for Type2 Slowly Changing Dimensions.

•

Prepared Detail Technical Design Document from the requirement specification document.

•

Redesigned ETL mappings to improve data quality.

•

Created Mapplets, worklets and Reusable Transformations Using Informatica

•

Establishing & monitoring the processes for Issue Management, Change Management and Quality

•

Management.

Understanding the Transformations carried out in the sample feeds and ascertaining the correct

•

outcome or possible causes of error.

Worked out the impact analysis of the existing source systems against the users' new

•

requirements.

E NVIRONMENT :

Informatica PowerCenter 7.1/6.1, Power connect, Oracle 9i, TOAD, UNIX, SAP, ALE IDOC, SQL, PL/SQL,

Sun Solaris 5.8 UNIX, Windows NT 4.0.

Home Depot ;04/2004 06/2005

ETL D EVELOPER

R ESPONSIBILITIES :

Develop ETL processes using: Informatica, SQL scripts.

•

E NVIRONMENT :

Informatica PowerCenter 6.1, Oracle 8i, UNIX, SQL, PL/SQL, UNIX, Windows NT.

T ECHNICAL S KILLS

Data integration: Informatica PowerMart/PowerCenter v5x 9x on UNIX and Windows; SQL

Data Warehouse Appliances: Netezza 6.0, 3.x/4.x

Data Quality and Profiling: IDQ

DBMS: Netezza, Oracle 11g,Teradata, Postgresql, MySQL, Access

Server operating systems: UNIX/Linux, Windows.

Programming/Scripting Languages: Oracle PL/SQL, UNIX Shell Scripting (Ksh/Csh),Python, Java

Big Data: Hadoop, Hive .

C OURSES

• Informatica 9.0.1 Administration

• Netezza 6.0: NPS Appliance usage & NPS Appliance Advanced Conce

E DUCATION

M aster of Computer Applications

Bharathidasan University, Thiruchirapally, India

Saikumar Neerukonda Page 3 of 5

B achelor of Science

Nagarjuna University, Guntur, India

C ITIZENSHIP

India H1B

Contact this candidate