Manager Project

Alagar Pitchai

+1-302-***-****/ *******@*****.***

pROFESSIONAL SUMMARY

. 10+ YEARS IT EXPERIENCE

7+ years Data Warehousing (DW) Consultant experience

7+ years experience as Specialist/Developer in Informatica power

center (PC), Business Objects, Oracle and SQL Server

3+ year experience in Data Modeling/Data Analyst/DW Architect

Domain Experiences: Finance, Power & Energy, Automobile and

Pharmaceutical.

. Good Exposure in all phases of data warehousing life cycle including

planning, analysis, design, development, implementation and

maintenance of DW and data marts.

. Hands on experience in design and development of Logical, Conceptual

and Physical Data Models using Erwin and MS Visio.

. In my data warehousing career have played various roles from Developer

to Architect and have got extensive experience in ETL Informatica PC

7.x/8.6.1 & BusinessObjects 5i/6.x.

. Extensively used IDQ to manage data quality projects & plans in wide

range of scenarios.

. Hands on experience in handling/processing large volume of data in

business critical environments.

. Extensive database experience using Oracle 10g/9i/8i, UDB DB2, MS

Access, SQL, PL/SQL, SQL*Plus, SQL*Loader and TOAD.

. Good in Data Analysis, Data Profiling, Data Management,

Troubleshooting, Reverse Engineering and Performance tuning in various

level of ETL Process and BI Reports

. Experience in programming language Java, JSP, HTML, VB Script in the

entire Software Development Life Cycle (SDLC).

. Having good experience in Large volume of data, Complex business logic

and Aggressive deadline environments.

. Have good experience in offshore/onsite model.

. Proactive and self starter with the great ability of leadership.

skillset SUMMARY

DATA WAREHOUSING TOOLS INFORMATICA PC-7.X/8.6.1, BUSINESS OBJECTS 5I/6.5.1

Modeling Tools ERwin and MS Visio

DBMS DB2-UDB, Sybase, Oracle, SQL Server2005 & MS-Access

Programming Languages Java, JSP, HTML, VB Script, Excel Macro and PL/SQL

Project Management Tools Microsoft Project Plan

Operating Systems Windows, UNIX/LINUX

PROFESSIONAL EXPERIENCE

BOEHRINGER-INGELHEIM PHARMACEUTICALS INC., DANBURY, CT NOV'2009 - TILL

DATE

Role: ETL Architect/ Data Modeler

Project Name: Prescription Medicines Foundation Project

Description:

The Integrated Data Foundation project (IDF or Foundation) is an initiative

of Prescription Medicines to develop the basic components of a Prescription

Medicines Data Warehouse, integrating key information and making this

information accessible from a common location to support future reporting

and extraction processes.

Responsibilities:

. Reviewed and analyzed the BRD to derive the functional requirements

document and assisted in the preparation of System Requirement

Specifications and ETL Design Document.

. Involved in creating Preliminary Specifications document, Bus Matrix

and Issue document based on the BRD

. Worked with requirements analysts to determine business information

requirements, create logical data designs and collaborate with design

groups for final design and implementation.

. Involved in preparing Logical and Physical (STAR) data model by

following Ralph Kimball Paradigm.

. Involved in Source Data Analysis, ETL Process flow and the schema

objects with necessary Indexes, Partitions.

. Held Business Decomposition meetings to flesh out questions, issues,

and requirements.

. Performed gap analysis between existing systems and go-forward

requirements identifying areas for consolidation of business

processes.

. Maintained requirements traceability matrices for audit purposes.

. Developed Use Cases to demonstrate Business and Technical teams with

different scenarios and obtained consensus in the solution.

. Performed User Acceptance Testing for solutions.

. Created Test plans, performed unit testing for BPM process, reported

defects and status to the Management and Stakeholders.

. Involved in Analyzing the Risk and Benefits of each requirement and

change request and prioritize them accordingly.

. Optimized/Tuned the existing Informatica mapping in various level (

Source Qualifier, Transformations and Target) by avoiding bottleneck

to get better performance without disturbing the existing system

functionalities.

. Involved in MDM - Master Data Management project to integrate the

Confirmed dimension which is being used by multiple application.

. Involved in Change Management and Damage Control process.

Environment: Windows NT/2000/XP, SQL Server 2005, Oracle 9i/10g,

Informatica PC 7.x/8.6.1, IDE, IDQ, VBA Macros, XML, MS Project, Erwin 7.2,

Zai*Net, SQL/PLSQL

Exelon Inc., Kennett Square, PA Feb'2007 -

Oct'2009

Role: Sr.ETL Developer/ Data Modeler /DW Architect

Project Name: Trade, Forward Price, Journal Entry and DPS

Description:

Financial accounting and Operational accounting of Exelon were using the

Trade and DPS Data Marts in their Daily profit statement, Monthly/Quarterly

account close process. Risk Analytics team is using the Forward Price data

mart to forecast the commodity price across all market. JE data mart is

being used to book the journal and reconciling the invoices with actuals.

Responsibilities:

. Involved in identifying the Key Performance Indicators (KPIs),

Dimension information by analyzing the BRD and discussing with

Business users to build the dimensional model.

. Based on the BRD choose the application to be used for each interface

to meet the business need.

. Worked proactively and communicated the subsequent business

application/users in case of any delay/error based on the

criticality/availability of the system.

. Involved in preparing Logical and Physical data model, Source Data

Analysis, ETL Process flow and the schema objects with necessary

Indexes, Partitions.

. Defined the row level security strategies with enterprise standard to

adopt the SOX compliance and to keep the audit trail for every change.

. Involved in defining the dependency between the processes, and make

sure new additional processes are having necessary dependency and

mode.

. Worked with DW Project Manager, Business Analyst and other BI

developers to Design/Develop the ETL Strategies of the DW & Data

Marts.

. Extensively used IDE to profile and analyze the source data and

Prepared and executed quality plans for necessary dimensional

attributes using IDQ.

. Involved in publishing IDQ reports on Intranet and send them via email

to respective BA.

. Performed detailed data analysis and development of dimensional data

models and end-to-end design of processes to ETL into STAR dimension

data models.

. Performed Audit Tracking, Data Cleansing and DQ check in both Source

and DW side.

. Helping/Guiding team members in schema objects creation and data

migrating between environments.

. Drafted Test Plans, Back out plans and Contingency measures during the

Production Patches/Fixes for the existing applications.

. Working as Database expert to come up with ad-hoc queries for user

requirements and Performance tuning in SQL queries by inducing BULK

COLLECT, necessary Index/Partition.

. Effectively used various operational components in IDQ to standardize

and enhance the dimensional attributes.

. Involved in creating various complex reports slice & dice, Pivot,

Drill reports for complex business rules.

. Design and Developed Universe to meet the business rules and created

necessary business rule related filters to give better performance.

Environment: Windows NT/2000/XP, SQL Server 2005, Oracle 9i/10g, LIMA,

Informatica PC 7.1.4/8.6.1, IDE, IDQ, VBA Macros, XML, MS Project, Business

Objects XI (Web Intelligence, Designer, Desktop Intelligence), ERwin,

Zai*Net, SQL/PLSQL & Java

Johnson Diversey, Racine, WI Aug'2006 - Feb'2007

Role: Technical Lead

Project Name: DSIS (Distributed Sales Information System) Mart and Finance

(AR/AR/GL) Mart

Description:

The objective of the DSIS data mart is to provide high level sales

information across all regions daily. DSIS mart is used to generate the PDS

reports to Sr. level Business manager to track SIP on a daily basis to help

them to make business decision. Finance Data mart is being effectively used

by Finance team for month end financial close and regular day to day

reconciliation process.

Responsibilities:

. As Onsite Technical Lead Interacted with Business Users and Business

Analysts to understand and document the requirements and translate the

requirements to technical specifications for Universes in

BusinessObjects and ETL Mappings in Informatica.

. Developed Business Information Model and identified the key

transactions for each of the Source Systems.

. Involved in JAD sessions with SMEs and business users to analyze and

gather the high level requirements.

. Worked with Business to understand the requirements, active

participation in data model discussions, Developed Informatica

mappings using standards, Naming Conventions to load data into fact

and dimension tables.

. Managing/Coordinating the Enhancement releases from requirement

gathering, Design, Development, System testing, QA and Production

deployment between teams.

. As a Technical lead, involved Snowflake Data Modeling both LDM, PDM

Preparation

. Responsible for creating the repository and setting up the universe,

document, security domain and various universe connections for

different environment like Dev, QA, UAT and Production.

. Involved in performance tuning in various level of ETL mappings.

Environment: Windows NT/2000, SQL Server 2000, Business Objects 5i/6.x, Web

Intelligence 2.7, Enterprise Edition (Reporter, Designer, Supervisor,

Broadcast Agent, BCA Publisher, Auditor), Application Foundation 6.5.1,

Performance Manager, Dashboard Manager, Informatica PC 7.1.1, VBA Macros,

MS Project, Stored Procedures, Sagent, Data Mirror and ERwin

AoA and VWoA, Rochester Hills, MI Jan'2006 - Jun'2006

Role: Sr.DW Consultant

Project Name: TREAD (Transportation Recall Enhancement, Accountability and

Documentation)

Description:

The objective of this TREAD Data mart is to provide the information about a

vehicle to government. This module has several subject areas like, Consumer

Complaints, TACS, FRED, Production Counts and Warranty Claims. Warranty

claim mart is built from data sheets which are all sourced from various

field officers and provide the high level warranty claim detail from the

integrated DW.

Responsibilities:

. Create session tasks for each mappings and workflows to run the

sessions using Informatica Workflow Manager. Monitor scheduled and

running workflows using Workflow Monitor.

. Performed simple and complex transformations (Aggregator, Expression,

Lookup, Joiner, Sequence Generator, Sorter, Stored Procedure, Update

Strategy, etc.,) as part of Mapping between source and target.

. As Informatica Administrator, Involved in Install and configure/

Upgrade and Configure Informatica client tools (Repository Manager,

Designer, Workflow Manager, Workflow Monitor), Repository server,

Informatica server, create repository, register Informatica server

with the repository on windows and Unix platforms.

. Meta data/Repository Management for Informatica.

. Provided technical assistance by responding to inquiries regarding

errors, problems, or questions with programs/interfaces

. Developed UNIX Shell scripts for scheduling the jobs

. Created PL/SQL to implement complex business logic for better

performance

. Involved in Universe Creation, resolving the loop, creating the

necessary dimension objects, measure objects

. Extensively used Calculations, Variables, Breaks, @AggregateAwareness,Query prompt, Rank, Sorting, Drill down, Slice and Dice, Alerts for

creating Sales and Profit reports.

Environment: Windows 2000/XP, Oracle 9i, SQL plus, BusinessObjects 6.5.1,

TOAD, PL/SQL, SQL*Loader, VBA Macros, MS Visio, XML, Informatica PC 7.1, HP-

UNIX.

Citigroup, Singapore Sep'2004 - Oct'2005

Role: DW Consultant

Project Name: APAC Retail Banking SOP/SIP, Customer Portfolio Tracker

Description:

The objective of the SOP/SIP portal is to track and improve the performance

of the relationship managers. This enabled the users to perform analytics,

based on various Investments. Also various reports enabled Portfolio

Manager to track Rebalance Analyze Net Sales Quitter/Redeemer/Sleeper

Information based on the balances of the various customer holdings with the

bank.

Responsibilities:

. According to the business logic created various transformations like

Source Qualifier, Lookup, Stored Procedure, Sequence Generator,

Router, Filter, Aggregator, Joiner, Expression, Union, Update

Strategy And Sorter

. Involved in fixing invalid mappings, testing of Stored Procedures and

Functions, Unit and Integrating testing of Informatica Sessions,

Batches and the Target Data.

. Analyzed Session Log files in case the session failed to resolve

errors in mapping or session configurations

. Creation of Sessions and executing them to load the data from the

source system using Informatica Server Manager.

. Performance tuning of sources, targets, mappings and SQL queries in

the transformations

. Performed Incremental loading by means of loading recently

modified/added record into DW

. Developing Auto prompts to give end users a choice of different

filtering criteria each time they run the report.

Environment: Sun Solaris, Oracle Server 8.1.6/8.1.7, SQL* Loader, Shell

Scripting, Informatica PC 6.x, SQL, PL/SQL, Export/Import, Business Objects

5.x/6.x, Application Foundation 6.1a (Performance Manager, Dashboard

Manager)

AmerisourceBergen Drugs Corporation, CA Jun'2003 -

Aug'2004

Role: DW Consultant

Project Name: AmerisourceBergen Data Consolidation-Interlinx

Description:

Involved in designing, transformation and testing process. The Objective of

this project is creating Text files with certain format and feed it into

MSI program which is running in the Mainframe System and getting Customer

and Contract related reports from the WEB. The Interlinx ETL load processes

like daily, History, system assurance, reconciliation and sync are involved

in this project.

Responsibilities:

. Worked on Informatica PC 5.1 tools - Source Analyzer, Warehouse

Designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable

Transformations.

. Developed materialized view and summary tables necessary for

structured and ad-hoc reporting.

. Conducted performance tuning on Targets, Sources, Mappings & Sessions

to identify bottlenecks.

. Associated in the process of designing LDM, PDM and DFD

. Created server sessions for the transformations and mappings.

Scheduled server sessions for the mappings at predetermined time

intervals.

. Used Workflow Manager for Creating, Validating, Testing and running

the sequential and concurrent Sessions and scheduling them to run at

specified time.

. Designed and Created Universe, Classes and Objects. Applied typical

conditions to different classes and objects like count, sum, max, and

min in Business Objects.

. Created Aliases and Contexts for resolving Loops and developed

Hierarchies to support drill down reports in Business Objects.

Environment: Informatica 5.1, Oracle 9i, Sybase, SQL, PL/SQL, ERwin 4.0,

TOAD, SQL Server 2000, Business Objects 5.1(Designer, Reporter)

Ashok Leyland, Chennai, India Jul'2002 -

Jun'2003

Role: BI Developer

Project Name: Production Data Mart

Description:

Production data mart helps the management in effective production planning

and scheduling, efficient utilization of man, machine and materials, and

overall control of production process Stores Performance in terms of

supplying the required materials to Line and Shop as per the requirements,

ABC, VED Analysis. Production Performance in terms of Planned Vs Production

Responsibilities:

. Responsible for development of ETL processes to load data from

different sources into the target warehouse by applying applicable

business logic on Transformation mappings.

. Involved in collecting and reporting ETL process statistics and design

and implementation of ETL alerts severity and the groups responsible

for handling the errors.

. Created Oracle PL/SQL Stored Procedure to implement complex business

logic for good performance

. Created Stored Procedures and used them in the mappings as connected

and unconnected Stored Procedure Transformations.

. Used Type 2 SCD Mapping to insert new Dimensions and update Dimensions

in the Target and maintain the history.

. Presented the features of BusinessObjects to the end-users to enable

them to develop queries and reports easily.

. Involved in Report formatting, Slice & dice, Master Sectioning,

Drilling with respect to hierarchy

Environment: Sun Solaris 7.0, Windows NT, Informatica 5, SQL Server, Oracle

7.x, SQL, PL/SQL, SQL*Plus, Sybase, Business Objects 5.0.

Sree Ayyanar Mills, Virudhunagar, India May'2000 -

July'2002

I worked for Sree Ayyanar Mills(P) Ltd., Virudhunagar, India from May 2000

to July 2002. I started my carrier as Programmer-Trainee then got promoted

as a Programmer/EDP-In-Charge. Also In-charge for Management Information

System (MIS). During this time I was involved in development of different

kinds of projects like Integrated Information System, Inventory Management

System, Sales and Procurement Management System. During this time I worked

on Java, Javascript, JBuilder 5.0, JavaBeans, JMS, JSP, Servlet, NetBean,

Windows, HTML, XML, XSLT, Oracle, SQL Server 2000, FoxPro 2.6 and Novell

NetWare

EDUCATION

B.E (COMPUTER SCIENCE AND ENGINEERING), KAMARAJ UNIVERSITY, MADURAI, INDIA.

Contact this candidate