Project Data

S ubha Arumugam

Technology Lead

M obile: 817-***-****

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

PROFESSIONAL SUM MARY :

Around 7+ years of experience in Information Technology with a strong

back ground in Analyzing, Designing, Developing, Implementing and

Testing of Data Warehouse development.

Good understanding of relational database management systems like

O racle, DB2, and SQL Server and extensively worked on Data In tegration

using Informatica and Abinitio for the Extraction, t ransformation and

loading of data from various database source systems.

Good knowledge of Installing and Configuring Power Center 7/8/9

Experience in preparing design documents - M apping Documents, H LDs

and L LDs for ETL jobs and Database engines

Good understanding of warehousing concepts, staging tables, ODS,

D imensions, Facts and Star Schema

Hands on experience in ETL Informatica Production support activities.

Strong experience in identifying performance bottle neck in Informatica mappings,

sessions and systems and eliminating it for better performance

Well Experienced in doing Error Handling and Troubleshooting using various log files.

Good knowledge on Informatica Metadata manager and Informatica power

exchange

Experienced in complete life cycle Implementation of data warehouse.

Good knowledge on Teradata, External loaders – Mul ti Load, TPump, and

Fast Load and Fast Export.

Extensive hands-on expertise using Informatica 8 and Abinitio with

s trong business understanding in Retail Industry.

E xperience in Creating Physical data modeling using Erwin data

modeler.

Experience in Informatica mapping specification documentation, tuning

mappings to increase performance, proficient in using Informatica Server

M anager to create and schedule workflows.

Expertise in designing and Developing complex Mappings using Informatica Power Center

T ransformations –Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator,

Stored Procedure, Sorter, Sequence Generator and Rank.

Extensive experience in Retail and Logistics industries.

Technical Skills:

E TL Tools: A binitio, Informatica8 and Informatica9

Reporting Tools: Micro strategy

Data Modeling Tools: E rwin 3.x/4.x

Databases: SQL Server 2005, Oracle 10g/9i, DB2, Teradata

Scheduling Tools: Autosys, Control-M

Operating System: M S–Windows 9x/NT/2000/XP, UN IX

M ethodologies: Agile

P rofessional Experience:

1. P roject Name : I CC P roduction Support

Client : N ike

Description of the project:

The purpose of the project is to provide 24/7 support. The landscape

i ncludes integration of various Nike’s applications like supply chain planning,

E DI, HR and Pay roll etc. The data t ransfer between these applications is

designed using integration technologies like Informatica, Fusion and Egate

etc. The responsibility is to do defect fixes, and minor and major

enhancements, ensure the SLAs are met and delivered.

R ole : Technology Lead

Responsibilities :

• Provide 24x7 operational supports on holidays and weekends.

• Conduct impact analysis of issues logged, prioritize and

ensure that production support is provided as per the

committed SLAs.

• Monitor and provide support to workflows and provide expert

k nowledge on all workflow designs.

• Monitor all alerts and escalate all issues for all procedures

and systems.

• Attend routine knowledge t ransfer sessions conducted by

Development/Release team.

• Support the creation of the `Go L ive` plan and manage the

assigned activities in the plan.

• Coordinate with various teams and raise support t icket for all

issues, analyze root cause and assist in efficient resolution of

a ll production processes.

• Recommend use of support materials to end-users such as

t raining materials, quick reference guides, on-line help, etc.

• Assist all customers and provide production support for all

designs and perform tests on all installation process for

i nfrastructure.

• Perform all tests on production applications and prepare

recovery procedures for all applications and provide upgrade

to same.

• Have to provide the value added points and t ry to improve the

current process much better. Contribute to the requirements

elicitation process by creating assigned parts of the

requirements documentation with guidance from supervisors.

: Jan 2013 t o t ill date

Du ration

E TL tool : I nformatica and EDI

Database : O racle 8i and Teradata

2. P roject Name : Phoenix Remediation and Africa Balancing

C lient : N ike

Description of the project:

Phoenix remediation project involves the payment information made by

t he Customer to Nike. EDI Translator receives data from t rading partners.

E DI Translator t ranslates data in to a f lat file. T he f lat files are then

t ransferred to SAP.

The 3PL warehouse sends a Daily Open Delivery Status (via the Delivery

B alancing link) to N I KE. This Informatica link feeds the SAP Delivery

B alance report, which shows any Delivery discrepancies between the 3PL and

SAP.

T he 3PL will return an Inventory Balance file (via EDI 846) nightly after all

warehouse t ransaction batches for the days are run. This process supports

reconciling the inventory at the 3PL warehouse, to the summary inventory

records in Nike SAP Inventory.

Role : Technology Lead

Responsibilities :

• Contribute to the requirements elicitation process by creating

assigned parts of the requirements documentation with

guidance from supervisors.

• Participate in creating application architecture document to

p rovide deliverables in line with architectural requirements.

• Create low level design artifacts independently and high level

design artifacts with guidance and supports prototyping

t h rough creation of POCs.

• Deliver high quality code deliverables and supports peers in

quality checks such that design requirements are met.

• Create the user documentation for the assigned sub-modules.

• ETL design Process and Created ETL mappings that reads

data from different legacy systems.

• Created module that does error reporting through automated

mail to user.

• Developed Reusable objects, Mappings and Workflows.

• Involved in peer, in ternal and external reviews.

• Lead validation activities for the assigned sub-modules for all

t ypes of testing e.g. Functional, In tegration, System, User

experience.

• Support the creation of the `Go L ive` plan and manage the

assigned activities in the plan.

: Aug 2012 t o Dec 2012

Du ration

E TL tool : I nformatica

Database : O racle 8i and Teradata

3. P roject Name : Engineering Asset Management

Client : BNSF

Description of the project:

The purpose of this project is to implement the single Asset Repository

for

Engineering data using NRX Asset Hub software. Asset Hub is an enterprise

solution for Asset Information Management and Governance that extends an

organization’s Enterprise Information Management capabilities to address

t he unique and critical requirements associated with managing Asset Data.

T he extracting, t ransformation and loading the legacy data into Asset hub is

done using Informatica

Role : Technology Lead

Responsibilities :

• Worked closely with business users to understand the

requirements, needs and use cases for loading the data into

Asset Hub

• Extracted data from various Sources like Oracle, Excel

Spread sheets, XML and DB2

• Designed, developed Informatica mappings, enabling the

extract, t ransport and loading of the data into Asset Hub.

• Created & configured Workflows and Sessions to t ransport

t he data to target using Informatica Workflow Manager.

• Developed Sessions using Informatica Workflow Manager.

• Involved in tuning the Informatica objects to increase the

Performance of the Informatica loads.

• Worked in coding UN IX scripts to automate multiple ETL

Jobs.

• Tested the data and data integrity among various sources and

t argets.

: Jan 2011 t o July 2012

Du ration

E TL tool : I nformatica

Database : O racle 8i

4. P roject Name : Fleet Reporting Data Store

C lient : PEPSI

Description of the project:

Fleet reporting Data store project involves extracting data from

M ul tiple Application DBs (WCMS, RPM, RFM and SDW) and loading i t in

Data store tables to enable reporting out of them in phase 2 of the project.

E TL used in this project is Informatica.

Role : Developer

Responsibilities :

• Involved in the Requirements gathering, Analysis and support

of Data Warehousing efforts.

• Involved in H igh level, Detailed and low level designs.

• Worked on Power Center client tools to perform ETL to

extract, t ransform and load data from Oracle, SQL Server,

and f lat files to Oracle.

• Used various t ransformations like Aggregator, Joiner,

E xpression, Filter and Router, Lookup, Update Strategy,

Sequence Generator to t ransform the data.

• Co-ordinating with the onsite team for prod activities.

• Coding and unit testing in Informatica

• Involved in the data migration

• Took the ownership of the DB activities

: August2010 to December 2010

Du ration

: I nformatica

E TL tool

:

Database SQL Developer

5. P roject Name : GP Account Planning I n tegrated Data

Foundation(Phase 4)

C lient : GP

Description of the project:

Georgia Pacific is implementing a new Trade Management strategy. A

key aspect of this strategy is, moving to a “Pay for Performance” model where

on the amount of t rade funds spent at the retailer would be based on

achieving certain performance parameters. The phase 4 of the project is to

i mprove the usability experience of planning and in period management

using the TMS and Account Planning applications.

Role : Developer

Responsibilities :

• Worked in different phases of project life cycle (Design,

Development and Testing).

• Extensively worked on Power Center Client Tools like Power

center Designer, Workflow Manager and Workflow Monitor

• Worked with DBA to create physical data model

• Involved in Extraction, Transformation and Loading (ETL)

P rocess using Abinitio

• Handled and Supported Continuous f low Component.

• Automation of Ab initio graphs using Control-M Jobs

: August2009 to July 2010

Du ration

: A binitio

E TL tool

: O racle 8i

D atabase

Data Model T ool : E rwin

6. P roject Name : GP Account Planning I n tegrated Data

Foundation and Reporting(Phase2)

Client : GP

Description of the project:

Georgia Pacific is implementing a new Trade Management strategy. A

key aspect of this strategy is, moving to a “Pay for Performance” model

w here on the amount of t rade funds spent at the retailer would be based on

achieving certain performance parameters. Phase 2 of the project included

creation of an integrated data foundation to support historical reporting.

R ole : Developer

R esponsibilities :

• Requirements gathering and analysis

• Preparing H igh level, Detailed and low level designs.

• Develop unit, system and In tegration test plans

• Coding and unit testing in Abinitio

• System testing

• Co-ordinating with the onsite team for prod activities

D u ration : October2008 to July2009.

E T L tool : A binitio

D atabase : O racle 8i

7. P roject Name :Discount Usage and Pe rformance

A nalysis(GAP)

Client : GAP

Description of the project:

This project involves in developing the reports which will be used to

verify the specific discounts perform within specific locations. I t also

compares the t ransaction with specific discounts with each other. This

w ill allow individual merchants a complete Analysis of the Discount

Usage.

R ole : Developer

Responsibilities :

• Requirements gathering and analysis.

• Designed and implemented Micro Strategy reports by creating projects,

a tt ributes, hierarchies, metrics, fil ters and templates.

• Designed several metrics, fil ters, custom groups, prompts and

consolidated objects for the development of reports.

• Optimized the performance of MicroStrategy platform by implementing

suitable report design processes.

• Develop unit and system test plans.

• Coding and unit testing.

Du ration : July2008 to September2008

Reporting Tool : Micro strategy

Database : Teradata

8. P roject Name : Db2 Warehouse Viper 2 Beta

Client : IBM

Description of the project:

T he application that is suggested for DB2 warehouse viper beta

testing is to analyze and link the unstructured data/ information

p resent in the outside world with the actual sales data of a retail store,

t he unstructured information can be in the form of blog messages or

survey information. Scope of this tool is to extract the information from

t he structured and unstructured data and then display i t as a report.

T hese reports can be used for multidimensional-analysis or used as

i nput for data-mining. This can also be implemented as a solution and

can bring about a change in technology and business t rend in BI space.

Role : Developer

Responsibilities :

• Develop unit and system test plans.

• Prepared low level design documents

• Conducted unit and system-level testing.

• Creation of test plan, test strategy and test approach.

Involved in Daily and Weekly Status meetings

•

• Tested the tool and generated the report.

Du ration : September2007 to June2008

W indows :Client: Windows XP Professional Edition, SP2

Server: Windows 2003 Enterprise Edition, 32 bit,

SP1, R2

9. P roject Name : M etadata Analyser

C lient : I nfosys Technologies Ltd.

Description of the project:

T he project involves development of the Meta Data Impact

A nalyzer Tool for Infosys Technologies L td. The Meta Data Impact

A nalyzer is a tool developed to face the challenges of Metadata

management and to enhance the quality of Metadata management

p rocesses. The Meta Data Impact Analyzer can connect to a database or

an ETL tool and retrieve the tables and fields. The tool can add, modify

and delete fields and study the impact of the mentioned operations on

t he fields. The tool summarizes the impact and displays it for the user

for assessment. The fields added to study impact can also be saved and

can be opened later to work further. The impact can be fixed later to

establish the impact. The tool provides an easy to use user interface for

t he operations. The tool eliminates the manual analysis of the metadata

and makes changes without user intervention.

: Developer

R ole

Responsibilities:

• Preparation of Requirement analysis document

• Developed various Informatica objects including mappings,

workflows and sessions as per the requirements

• Parameterized all Informatica sessions.

• Actively involved in preparation of the technical system design

document.

• Preparation of test plans.

• To Query the repository table and to display the workflow,

mapping and session for a particular table name

D u ration : January 2007 to August 2007

H a rdwa re : In tel Based platforms

Software : Java, Eclipse

Tools Used : M icro strategy and Informatica

Database Used : Oracle

Certifications:

Micro strategy Certified Project Designer

I nformatica Exam N: Power Center 7 Mapping Design

Informatica Exam P: Power Center 7 Advanced Mapping Design

SI 101 Abinitio Foundation Course.

Infosys IQ1 Certification: In t roduction to Infosys Project Processes and Tools

Retail Basics of CPG retailing

Contact this candidate