Resume

Sign in

Project Manager

Location:
United States
Posted:
August 27, 2012

Contact this candidate

Resume:

Resume

Name : Milind Gangan

Profile:

An experienced ETL Architect, Data Warehouse Architect,Datastage SME, Project Manager, Solution Architect, Technical Lead, System Analyst and Developer with over 16+ years of experience in Information Technology Industry. Specialized in Oracle, PL/SQL, ETL Tools (DATASTAGE). Has work experience on Data warehousing Projects, Data Migration Projects, Data Integration Project and ODS Project.

Hardware and Software Environment:

Operating Systems : Windows NT, Novell Netware, SCO Unix, VAX-VMS, DOS

Application Software : SQL Server, VB Script, Oracle 7.x, 8.x 9.x, Developer 2000 (Forms 4.5, Reports 2.5), Oracle Application Server (4.0), Forms 4.0, Forms*3.0, ReportWriter 2.0, Power Builder 4.0.

Languages : PL/SQL, HTML, Foxpro 2.5/ 2.0, Foxbase+, Cobol, C, Pro*C

Tools : TOAD, SQL Server tools – DTS (Data Transmission Services), BCP (Block copy Program), Analog (Log File Analyzer), Report Magic for Analog (Report writer for Analog), ErWin, CRYSTAL REPORT, COGNOS – ADMINISTRATOR, TRANSFORMER

ETL Tools : DATASTAGE, INFORMATICA, GENIO

ISMS AUDIT : Undergone Training for Information Security Management System Internal Auditor. Involved in ISMS Auditing of Datamatics Technology Ltd.

TRAINING : Training from Ascential on DataStage Enterprise Edition (PX)

Professional Exams : Passed Teradata Basics V2R5 Exam

Completed Domain Certification Program (Healthcare)

Completed Data Architect training

PROFESSIONAL EXPERIENCE

Project Experience Highlights:

1. Project Title : ICDW Assessment and Due Diligence

Client : J P Morgan Chase, Columbus

Period : Nov 2011 onwards

Position : Solution Architect

Location : USA

Role:

• Understand Business requirement

• Preparing list of tasks to be done

• Proposing solution

• Preparing Estimation sheet

• Preparing resource load sheet

• Understanding IBM Banking Datawarehouse Model

2. Project Title : Facet Roseta Data Integration

Client : Blue Shield Of California, USA

Period : Aug 2009 To Oct 2011

Position : Technical Manager (ETL)

Location : India - USA

Team Size : 35

Environment : Informatica

Description : It is healthcare data integration project.It consist of integrate data from Facet and legacy system into Rosetta Data Marts

Role:

• Preparing resource load for project

• Preparing templates for ETL artifacts

• Review High Level Requirement Document

• Review Detailed requirement Document

• Prepare ETL architecture for Solution Architecture document

• Preparing Data Integration Framework

• Defining activities, deliverables and ownership

• Define Job Process

• Analyzing of mapping sheets

• Preparation and Review of Low Level Technical Document.

• Building and Managing the team on various modules

• Leading, Analysis, Design of jobs

• Involved in the recruitment process for Informatica skill set

3. Project Title : Telecom NZ Inventory Data Migration

Client : Telecom New Zealand

Period : Feb 2009 – July 2009

Position : ETL Architect

Location : New Zealand

Team Size : 10

Environment : DATASTAGE

Description : It is telecom data migration project.It consist of data migration from ICMS legacy system to Netcracker target application.

Role:

• Writing Response document

• Preparing resource load for project

• Preparing templates for ETL artifacts

• Educating team for ETL artifacts

• Review High Level Requirement Document

• Review Detailed requirement Document

• Prepare ETL architecture for Solution Architecture document

• Preparing Data Migration Framework

• Defining activities, deliverables and ownership

• Define bottom up strategy for Data Analysis

• Define Job Process

• Analyzing of mapping sheets

• Preparation and Review of Low Level Technical Document.

• Building and Managing the team on various modules

• Leading, Analysis, Design of jobs

• Involved in the recruitment process for Datastage skill set

4. Project Title : GMAC LAO Profitability Analysis

Client : GMAC, USA

Period : Feb 2008 - Jan 2009

Position : Project Manager (Technical)

Location : Pune

Team Size : 18

Environment : DATASTAGE

Description : It is end-to-end datawarehouse project.It consist of ODS and 2 Data Mart

for Profitability Analysis Reports

Role:

• Writing Response document

• Preparing estimation for project

• Requirement gathering

• Data Modeling

• Preparation and analyzing of mapping sheets

• Analysis and preparation of HLD for new modules.

• Preparation and Review of Low Level Technical Document.

• ETL Architect

• Building and Managing the team on various modules

• Leading, Analysis, Design, Development & Testing of jobs

• Regular conference calls with Client and Onsite Team

• Involved in the recruitment process for Datastage skill set

• Monitoring team

• People Management

• Project Management

5. Project Title : OMD

Client : Western Union, USA

Period : Aug 2007 – Jan 2008

Position : Project Manager

Location : Mumbai

Team Size : 8

Environment : DATASTAGE

Description : Implementation of various modules in Data Warehousing using Datastage (Server & PX)

Role:

• Writing Response document

• Preparing estimation for project

• Requirement gathering

• Data Modeling

• Analysis and preparation of HLD for new modules.

• Preparation of Technical Application Document.

• Preparation and analyzing of mapping sheets

• Building and Managing the team on various modules

• Leading, Analysis, Design, Development & Testing of jobs

• Regular conference calls with Client and Onsite Team

• Involved in the recruitment process for Datastage skill set

• Monitoring team

6. Period : Dec 2006 – Jul 2007

Position : Practice Lead

Location : Mumbai

Environment : DATASTAGE

Role:

• Building and Managing the team in Datastage

• Involved in the recruitment process for Datastage skill set

• People Management

• Writing Response document

• Preparing estimation for project

• Technical support on Datastage on various project

• Regular conference calls with Client and Onsite Team

7. Project Title : SSC

Client : State Street, USA

Period : Jul 2005 – Nov 2006

Position : Project Management / Technical Lead

Location : Mumbai

Team Size : 5

Environment : DATASTAGE, SYBASE

Description : Implementation of various modules in Data Warehousing using Datastage (Server & PX)

Role:

• Building and Managing the team on various modules.

• Leading, Analysis, Design, Development & Testing of jobs

• Analysis and preparation of HLD for new modules.

• Preparation of Technical Application Document.

• Preparing/Reviewing Query log sheets and test case scenario documents.

• Preparation and analyzing of mapping sheets.

• Regular conference calls with Client and Onsite Team

• Involved in the recruitment process for Datastage skill set

• Monitoring team

• Applying QMS in project

8. Project Title : AIU, JAPAN

Client : AIU – ASCENTIAL, JAPAN

Period : AUGUST 2004 – June 2005

Position : Technical Lead

Location : Mumbai, Japan

Team Size : 8

Environment : DATA-STAGE, Oracle

Description:

AIU i.e. AIG, JAPAN is General and Life Insurance Company. They have data in sequential file. They have 4 line of business – AUTO, ACTSPA, Casualty, Cliams. They want data to get migrated in Oracle database.

Role:

Migrate data from sequential file to oracle database after applying necessary business rules by using Datastage Tool.

9. Project Title : DHL, UK

Client : DHL – ASCENTIAL, UK

Period : March 2004 – August 2004

Position : Technical Lead

Location : UK

Team Size : 8

Environment : DATA-STAGE, Oracle

Description:

DHL has legacy system at 18 different locations. They want to integrate all systems into one Seibel system. In order to integrate all system they have to migrate data from different location.

Role:

Migrate data from 18 different locations into one SIBEL system by using Datastage Tool.

10. Project Title : Experian – Vantage

Client : Experian - Ascetial USA, LA

Period : Jan 2004 – Feb 2004

Position : Technical Analyst

Location : USA

Team Size : 4

Environment : DATA-STAGE, Oracle

Description:

Experian is preparing Datawarehouse for Vantage. So they want create FACT and Dimension Table.

Role: Create Datastage Jobs to create Dimension and Fact table for Datawarehouse.

11. Project Title : One SAP

Client : Celanese – Bearing Point USA, Dallas

Period : Sep 2003 – Dec 2003

Position : Technical Analyst

Location : USA

Team Size : 4

Environment : DATA-STAGE, SQL Server, SAP

Description:

Celanese has SAP at different location. They want to integrate into one SAP. So they want to migrate SAP data at different location into one SAP.

Role:

Interact with SAP system and functional experts and understand business process logic to define ETL strategy.

Architect ETL solutions using DataStage for SAP and Legacy systems. SAP Instance Consolidation in SCM Module (PIR), BW Invoices History Conversion, Sales History, Profitability Analysis

Period : June 2003 – Aug 2003

Involved in ISMS Auditing of Datamatics Technology Ltd.

12. Project Title : Accounts Warehouse

Client : Datamatics Technologies Ltd.

Period : Nov 2002 – May 2003

Position : Analyst

Location : India

Team Size : 4

Environment : DATA-STAGE, COGNOS, Oracle 9i, SQL Server

Description:

The project included developing a data warehouse for the Accounts department of Datamatics Technologies Ltd. The information required for the accounts personnel is retrieved from various heterogeneous transaction databases like Tally, Excel and SQL Sever. The data warehouse is being built so that the company management and the analysts have an exact view of the status of the company.

Role:

• Analyzing the requirements

• Designing the star – schema

• Mapping of data from source systems to the warehouse

• Transforming the data using the ETL tool Ardent Datastage

• Create the cubes required for storing the data in multi-dimensional structure using Cognos Transformer.

• Designing of different snapshots of the data warehouse and generation of reports using Cognos Powerplay and Impromptu

13. Project Title : PARTNERRE NRA PROJECT

Client : CSC-PartnerRe – USA

Period : Sep 2001 - Oct 2002

Position : Technical Analyst

Location : Greenwich, USA

Team Size : 4

Environment : DATA-STAGE

Role : Involved in systems analysis, Estimation, Technical Expert

Description:

As part of the release of a Global Re-insurance application for all its locations, PartnerRe wants to migrate its existing applications at GREENWICH and BERMUDA to application. This involves migrating Re-insurance systems currently operating in heterogeneous environments to a uniform Client/Server architecture application – SICS/NT a computer sciences corporation (CSC) product

14. Project Title : PARTNERRE NRA PROJECT

Client : CSC-PartnerRe – Switzerland

Period : Mar 2001 to Sep 2001

Position : Technical Analyst

Location : Mumbai-India, Zurich-Switzerland

Team Size : 4

Environment : Heterogeneous

Description As part of the release of a Global Re-insurance application for all its locations, PartnerRe wants to migrate its existing applications at the different locations to application. This involves migrating Re-insurance systems currently operating in heterogeneous environments to a uniform Client/Server architecture application – SICS/nt a computer sciences corporation (CSC) product

Role:

• Involved in systems analysis and scoping

• Estimation and project planning

• Proposal preparation

15. Period : Jan 2001 to Feb 2001

Position : Analyst

Location : Datamatics Ltd, India

Description:

Undergone training and orientation on:

• Datawarehousing Concepts and Methodolgies

• Hummingbird Genio ETL tool

• Informix Datastage ETL

• Brio Reporting tools

16. Project : Utopia (Datawarehousing Project) for Alta Vista, U.K.

Period : Jul 2000 to Dec 2000

Position : Analyst /Programmer

Location : United Kingdom (UK), Maidenhead

Team Size : 5

Environment : SQL Server – DTS, BCP, Analog – Log file Analyzer, Report Magic for Analog (Report Writer for Analog), VB Script

Description:

Alta Vista has its own search engine. This is project of dataware-housing of query hits and web log analysis of shopping division. There are three phases. Phase I is Analog Tool, Phase II is Data Transmission Services tool and Phase III is Writing VBScript for converting Apache and Netscape Log File into IIS Log format..

Role:

• He was responsible for analyzing log files, staging table, Datawarehouse tables and usage of tools like Analog, Report Magic for Analog, DTS (Data Transmission Services), BCP (Block Copy Program).

• Involved in implementation, customization of software and managing the project.

17. Project : Merchandising Systems for Richter Systems, Netherlands

Period : Nov 1999 to Jun 2000

Position : Analyst/Programmer

Location : Netherlands

Team Size : 17

Environment : Oracle 7.3, Developer 2000, Designer 2000, PL/SQL, TOAD Tool, PVCS, Windows NT 4.0

Description:

This Product has many modules such as PO Entry, Receipts, Distributions, Transfers, Sales, Pre-allocation plan, Replenishment. He was responsible for Transfer Module in this system.

Role:

He was responsible for analyzing customer requirements, writing technical specifications, development of forms, reports, database procedures, database triggers, testing, preparing data models, optimizing queries, writing table creation scripts.

18. Project : Work Registration System for SAGRO

Period : Jan 1999 – Sep 1999

Position : Module Leader/Analyst/Programmer

Location : India

Team Size : 6

Environment : Oracle 8i, OAS (Oracle Application Server 4.0), Developer 2000, PL/SQL, TOAD Windows NT 4.0

Description:

The System calculates consumption of manpower hours, machines, auxiliary machines, vehicles and fuels per project of subsidiary. It also calculates overtime cost and surcharges over project

Role:

He was responsible for analyzing customer requirements, writing technical specifications, development of forms, reports, database procedures, database triggers, testing, preparing data models, optimizing queries, writing table creation scripts, Performance Tuning, designing the database in Oracle 8I and creating various HTML pages using the PL/SQL cartridge on OAS 4.0.

19. Project : Tours & Travel System for Softlines

Period : Sep 1998 – Dec 1998

Position : Analyst/Programmer

Location : U.K.

Team Size : 7

Environment : Oracle 7.3, PL/SQL, Windows-NT

Description : The system consists of various stored procedures and database triggers.

Role : Responsible to develop and write unit test plan for many procedures and DB triggers.

20. Project : Reuters Interface for ICICI Bank

Period : Jan’98 – Aug’98

Location : India

Position : Analyst/Programmer

Team Size : 4

Environment : Oracle 7.2, Developer 2000 (Forms 4.5, Reports 2.5), PL/SQL, Forms*3.0, Pro*C, UNIX

Description:

The Reuters Interface comprises of a C and Pro* C program to transfer data from a Reuters server onto an Oracle server.

Role:

Involved in analyzing the requirements and writing the stored procedures to update/insert Reuter data in the corresponding tables under certain conditions.

21. Project : Upgrading FOREX package for ICICI Bank

Period : Jan 98 – Aug 98

Location : India

Position : Analyst/Programmer

Team Size : 4

Environment : Oracle 7.2, Developer 2000 (Forms 4.5, Reports 2.5), PL/SQL, Forms*3.0, Pro*C, UNIX

Description:

The project runs parallel to the Reuters interface project. This system is a FOREX package, developed in Forms*3.0 with reports written in Pro*C.

Role:

Role consisted of maintaining the complete package and analyzing the requirements and rewriting the forms of the Merchant transactions module from Forms*3.0 into Forms 4.5.

22. Project : Daily Wages System for Government of Maharashtra

Period : Aug 97 – Dec 97

Location : India

Position : Module Leader/Analyst/Programmer

Team Size : 5

Environment : Oracle 7.2, Developer 2000 (Forms 4.5, Reports 2.5), PL/SQL, Windows NT

Description:

The system consists of a Daily Wages calculation procedure for each worker

Role:

Responsibility was to carry out the system analysis, schedule the work over the team, carry out the development and test the system.

23. Project : Advanced Sales Automation Program for Sales Express Pvt. Ltd.

Period : Jan’97 – Jul’97

Location : India

Position : Module Leader/Analyst/Programmer

Team Size : 8

Environment : Oracle 7.1, Developer 2000 (Forms 4.5, Reports 2.5), PL/SQL, Windows NT

Description:

The system contains Warehouse system, Accounts Receivables Reports, Sales and Distribution Reports.

Role:

Responsibility was to carry out the system analysis & specification, schedule the work over the team, carry out the development and test the system.

24. Project : Credit Appraisal System for Banking Organization

Period : Aug’96 – Dec’96

Location : India

Position : Analyst/Programmer

Team Size : 4

Environment : Oracle, PowerBuilder 4.0

Description : The system was used for consulting customer credit data.

Role:

He prepared the specifications, developed and tested several types of screens & reports. Furthermore he used the Backup and Restore Tools to create a custom tool for Data Conversion i.e. Data from FoxPro to Oracle and from Oracle to FoxPro.

25. Project : Payroll System for Indian Institute of Bankers

Period : Jan’96 – Jul’96

Location : India

Position : Module leader/Analyst/Programmer

Team Size : 8

Environment : Oracle, Forms 4.5, Report Writer 2.0

Description:

The system includes Data Entry of Employee details, various Master Table Maintenance modules and Calculations of salary details.

Role:

Responsibility was to carry out the system analysis & specification, schedule the work over the team, do coding of forms & reports, write procedures & triggers, monitor and test the work by the team, test the system and oversee the implementation

26. Project : Bank Examination System for Indian Institute of Bankers

Period : Apr’95 – Dec’95

Location : India

Position : Module Leader/Analyst/Programmer

Team Size : 8

Environment : Oracle, Forms 4.0, Report Writer 2.0

Description:

The system was developed for pre-examination, post examination-pre evaluation and post examination–post evaluation for a bank training institute

Role:

He was responsible for the System requirement study, specification, prototyping, coding, scheduling of work, testing and implementation.

27. Project : Production and Material Costing System

Period : Jan 95 – Mar 95

Location : India

Position : Analyst/Programmer

Team Size : 4

Environment : Oracle 7.0, Forms 3.0

Role:

He was involved in the System specification, coding (mainly forms, reports, some procedures) testing and implementation.

28. Project : Orders and Supplies System

Period : Jul 94 – Dec 94

Location : India

Position : Analyst/Programmer

Team Size : 1

Environment : Oracle 7.0 Forms 3.0. Foxpro 2.5

Role:

He was responsible for Rewriting of existing application and also involved in “reverse engineering” the specifications and rebuilding parts of the system.

Role : Analyst/Programmer

Duration : Aug 90 – Jun 94

Environment : COBOL, Foxbase+, Foxpro 2+, SCO Unix, Netware

Responsibilities:

Was involved in pre-sales support, demonstration, installation, customization & implementation of Multi-Company Accounting Package (MAP). During this period also involved in analysis, development and implementation of various commercial applications including Accounting System, Payroll System, Portfolio Management System etc

OTHER DETAILS:

Education Qualification:

Bachelor of Commerce, 1986 – 62%

Diploma in Computer Software Technology, 1987 – 72%

Masters in Computer Management, 1990 Distinction - 74%

Contact Details:

605/D, ‘SUMER CASTLE’

L.B.S. MARG, THANE (W)

INDIA, 400601

Tel. No. (Res.) +91-22- 25471355

Mobile: +91-989*******

e-mail : a2bive@r.postjobfree.com

a2bive@r.postjobfree.com

a2bive@r.postjobfree.com



Contact this candidate