Manager Data

Surya Kalidindi

Phone: 814-***-****

Email: *****.*********@*****.***

Summary

. About 7 years of total IT experience in the Business Requirements

Analysis, Application Design, Dimensional data modeling, Development,

Testing, Implementation and maintenance of Data warehouse

applications, Client Server applications and Web applications.

. 7 years of extensive experience in Data Warehousing using Informatica

Power Center 8.x/7.x/6.x/5.x, Power Mart 6.x/5.x with expertise in

design, development and implementation of ETL processes.

. Involved in the data analysis for source and target systems, good

understanding of Data Warehousing concepts (Kimball/Inmon),

Dimensional Modeling using Star schema and Snow- Flake schema for

faster, effective querying and Business Analysis Requirements.

. Expertise in translating business requirements into feasible technical

ETL specifications, identifying key deliverables and defining

timelines from an Enterprise perspective.

. Strong Experience with Informatica Designer, Repository Manager,

Workflow Manager and Power Exchange.

. Expertise in implementing complex Business rules by creating complex

mappings/mapplets, reusable transformations and Partitioning Sessions.

. Strong experience in Informatica administration, performance tuning

and monitoring.

. Proficient in writing SQL queries and working knowledge of PL/SQL and

T-SQL coding.

. Extensively worked on various databases and experience in Integration

of various data sources like Oracle, SQL Server, DB2, Teradata, SAP,

XML and Flat Files.

. Experience in working with different operating systems like HP UNIX,

AIX UNIX, and Windows NT/2000.

. Strong business understanding knowledge of Consumer, Health care,

Insurance and financial industries with functional expertise in Sales

& Marketing and Supply-chain systems.

. Experience in the successful implementation of ETL solution between an

OLTP and OLAP database in support of DSS/BI with expertise in all

phases of SDLC.

Education Qualifications

* Bachelor of Technology (I.T), University of Madras, India.

Technical Skills

ETL Tools Informatica 8.x/7.x/6.x/5.x, (Power Mart, Power Center,

Power Exchange (CDC)), Ab Initio Co>Operating system

(2.13.1/2.13/2.12.2), Informatica Data Quality,

Informatica Data explorer, EME and SAP BW.

Reporting Tools Business Objects XI r2/r1/6.5/6.1/5.1, IBM Cognos 8

Data Modeling Erwin 4.5/3.5, MS-Visio

Tools

Automation Tools Win Runner, Test Director, QTP

Databases Oracle 10g/9i/8i, MS SQL Server 2000/2005,TeraData

V2R4/V2R5, DB2

Database Toad, SQL*Loader, SQL Navigator, BTEQ

Utilities

Languages C, C++, JAVA, ABAP, COBOL, Visual Basic, K-Shell,

T-SQL, PL/SQL

Web Technologies XML, HTML, DHTML, JavaScript, ASP, VB Script.

Operating Windows 9X/2000/XP/NT, MS-Dos, HP-UX, Unix, IBM AIX

Systems 4.3/4.2 and Solaris

Professional Experience

Delmonte Foods, PA

Mar 09 to present

Sr. Data warehouse Developer

Responsibilities:

* Involved in gathering detailed requirements and creating ETL technical

specifications for multiple projects.

* Assisted the Project lead in identifying key deliverables and defining

timelines from an Enterprise perspective.

* Designed and developed complex Extract, transform and load (ETL)

solutions by translating detail design requirements into feasible

technical implementations using Informatica.

* Developed mappings and mapplets by using various advanced features of

Informatica like mapping variables, mapping parameters, Incremental

load and Incremental aggregation.

* Worked closely with the BI team in analyzing the reporting

requirements to design the database tables and tuning the report

performance.

* Developed slowly changing dimension mappings of Type 2 to bring in the

data from the sources like Wal-Mart POS and ACN systems into Data

warehouse.

* Designed and developed CDC (real-time) mappings that connect to DB2

using Informatica Power Exchange.

* Created and executed comprehensive unit test plans based on system and

validation requirements.

* Reporting status, identifying risks/issues/mitigation actions and

meeting commitments.

* Prepared Implementation plans that assist Database Administrators to

deploy the code from Testing to Production environments.

* Involved in Unit, Integration, system, and performance testing levels

and also worked closely with the end users during user acceptance

testing.

* Investigated and resolved problems with supported applications in an

on-call production support environment.

Environment: Informatica Power Center 8.1.1/8.6.1, Power Exchange (CDC),

Metadata manager, I2 Demand Manager, Oracle 10g, SQL Server 2005, SQL

Navigator 5.5, Toad 9.7.2, PL/SQL, IBM Cognos 8, Windows XP, HP Unix, MS

Excel, Tivoli.

Delmonte Foods, PA

Sep 07 to Oct

08

Sr. Data warehouse Developer

Responsibilities:

* Interacted with the business users and database administrators to

identify the business requirements and data realties.

* Designed an efficient and reliable ETL mechanism for loading the data

into I2 Demand manager as per the ABPP requirements.

* Designed new database tables in staging area to meet business

information needs and documented the Mapping specifications, which is

a guideline for ETL Coding.

* Partnered with the project manager to define deliverables, work

breakdown, level of effort estimates and delivery timeframes for the

ETL processes.

* Designed and developed various kinds of mappings using transformations

like Expression, Aggregator, Stored Procedure, Lookup, Filter, Joiner,

Rank, Router, Update Strategy and Normalizer.

* Involved in the Deployment of Informatica mappings from development to

testing and then to production environments.

* Enforced ETL standards, Naming conventions and wrote ETL flow

documentation for Stage and ABPP and uploaded the documentation to

SharePoint server.

* Used agile development approach for few projects.

* Used FTP connections to transfer flat files between i2 demand manager,

Phoenix, BPCS, Siebel and SCP systems.

* Created and executed comprehensive unit test plans, developed test

cases, assisted with integration and system test plans.

* Extensively involved in writing the SQL queries for testing the ETL

approach implemented using Informatica.

* Provided support for all ETL interfaces in APS environment, which

includes identifying bottlenecks/errors during data loads and

transformations due to requirement changes, unexpected data volume and

data quality changes.

Environment: Informatica Power Center 7.1.1/8.1.1, I2 Demand Manager,

Oracle 10g/9i, SQL Server 2005, SQL Navigator 5.5, SQL, Windows XP, HP

Unix, MS Excel, Tivoli.

Aetna Health care, CT

Nov 05 to Aug

07

Data warehouse Developer

Responsibilities:

* Involved in Dimensional modeling (Star Schema) of the Data warehouse

and used Erwin 3.5 to design the business process, grain, dimensions

and measured facts.

* Extracted the data from the flat files and other RDBMS databases

(Oracle and Teradata) into staging area and populated into Data

warehouse.

* Used various transformations like Filter, Expression, Sequence

Generator, Update Strategy, Joiner, Stored Procedure and Union to

develop robust mappings in the Informatica Designer.

* Extensively migrated data from different source system such as flat

files to ODS, Data marts and Data warehouse.

* Performed tuning of Informatica Mappings for optimum performance.

* Standardized parameter files to define session parameters such as

database connection for sources targets, last updated dates for

Incremental loads and many default values of fact tables.

* Created sessions, configured workflows to extract data from various

sources, transformed data and loading into data warehouse.

* Used Type 1 SCD and Type 2 SCD mappings to update Slowly Changing

Dimension Tables.

* Monitor troubleshoots batches and sessions for weekly and Monthly

extracts from various data sources across all platforms to the target

database.

* Determined how much of the data is in SAP ABAP, identify other data

gaps, and recommend additional data that is in SAP ABAP but not

requested by the users, since it is strongly related to the requested

data.

* Created a high-level design to extract the SAP ABAP data

using Informatica and put the data into Oracle data warehouse.

* Involved in Performance tuning at source, target, mappings, sessions,

and system levels.

* Provided change data capture (CDC) and real time support from

Mainframe, SQL server and Oracle database using Informatica Power

Exchange.

* Developed UNIX shell scripts to move source files to archive

directory.

* Extensively used SQL Assistant to run queries on Teradata during unit

testing.

Environment: Informatica Power Center 7.1/8.1, Power Exchange (CDC), Oracle

10g/9i, Teradata V2R5.1, DB2, Mainframe, SAP ABAP, SQL, PL/SQL, SQL*

Loader, Erwin 3.5,VB, ASP.net, TOAD 7.0, Star Schema, UNIX Shell Scripts,

Business Objects XI r1/6.5, Flat files, MS-Office, Windows XP IBM AIX.

Hartford Insurance, CT

Mar 05 to Oct

05

Data warehouse Developer

Responsibilities:

* Designed and maintained logical and physical Data warehouse schemas

using ERWIN.

* Consolidate data from various departments into the data warehouse by

identify the common data and solve the discrepancy on data values and

created various data marts.

* Involved in the requirement definition and analysis in support of Data

Warehouse and ODS efforts.

* Developed ETL mappings, transformations using Informatica Power Center

6.1.

* Extensively used Informatica client tools - Source Analyzer, Warehouse

designer, Mapping Designer, Mapplet Designer, Transformation

Developer, Informatica Repository Manager and Informatica Workflow

Manager.

* Designed and developed transformation rules (business rules) to

generate consolidated (fact/summary) data using Informatica ETL (Power

center) tool.

* Maintained stored definitions, transformation rules and targets

definitions using Informatica repository Manager.

* Developed data Mappings between source systems and warehouse

components using Mapping Designer

* Worked extensively on different types of transformations like source

qualifier, expression, Aggregator, Router, filter, update strategy,

lookup, sorter, Normalizer, Union, Stored Procedure and sequence

generator.

* Created, launched & scheduled Workflows/sessions. Involved in the

Performance Tuning of Mappings and Sessions

* Used Informatica repository manager to backup and migrate metadata in

development, Test and production systems.

* Involved in Design, Development and Implementation of Enterprise Wide

Reporting system using Cognos Suite.

* Supported to Production team for solving the issues.

* Written documentation to describe program development, logic, coding,

testing, changes and corrections.

Environment: Informatica Power Center 6.1, Oracle 9i, MS SQL Server 2000,

Teradata V2R4, T-Sql, ERWIN 3.5, Toad 7.3, Sybase, Unix Shell Scripts, UDB

DB2, Business Objects 6.5, HP-UX 11i,Test Director, Sun Solaris 5.4, SQL,

PL/SQL.

ANZ Bank, Sydney, Australia

Aug 03 to Jan 05

ETL Developer

Responsibilities:

* Created Stored Procedures to transform the Data and worked extensively

in PL/SQL for various needs of the transformations while loading the

data.

* Used Informatica -Designer for developing mappings, using

transformations, which includes aggregation, Updating, lookup, and

summation. Developed sessions using Server Manager and improved the

performance details.

* Created transformations like Aggregate, Expression, Filter, Sequence

Generator, Joiner, and Stored procedure transformations.

* Created reusable transformations called mapplets and used them in

mappings in case of reuse of the transformations in different

mappings.

* Involved in the process design documentation of the Data Warehouse

Dimensional Upgrades. Extensively used Informatica for loading the

historical data from various tables for different departments.

* Involved in creating Technical Specification Document (TSD) for the

project.

* Involved in gathering business requirements, logical modeling,

physical database design, data sourcing and data transformation, data

loading, SQL and performance tuning.

* Involved in the development of Data Mart and populating the data marts

using Informatica.

* Created sessions to run the mappings. Created mapplets to improve the

Performance

Environment: Informatica 6.2, Windows 2000, Oracle8i, Teradata V2R4, DB2,

PL/SQL, SQL, Sybase, Cognos, Windows 2000/NT.

Contact this candidate