Project Manager
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 : ********@*****.***
********@*****.***
********@*******.***
Contact this candidate