Milan Desai

Milan Desai

Senior Professional at MasterCard

Information Technology and Services

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you and Milan Desai know in common
  • Get introduced to Milan Desai
  • Contact Milan Desai directly

View Milan's full profile

Milan Desai's Overview

  • ICFAI (Distance Learning)
  • University of Mumbai

500+ connections

Milan Desai's Summary

*10+ years of experience in IT industry especially in Decision support Systems (DSS), Enterprise Data Warehouse (EDW) design- Data Mapping, development, Testing and Deployment and Application Production Support, Project Management and Service Management.

* Strong knowledge base in ETL,ELT, ELTL applications for Data Warehouses and Datamarts using DataStage (Server & Parallel Extender) 8.1/7.5/7.1, UNIX Shell Scripting, Mainframe JCL scripting, Pearl Scripting and databases like Oracle and Teradata

* Played significant role in various phases of project life cycle, such as requirements gathering, functional & technical design, testing, Production Support and implementation. Creation of SLA and OLA as per business and system requirements.

*Excellent team leader with good problem-solving, trouble-shooting and Cross functional communication capabilities, Quick Learner, highly motivated, result oriented and can motivate and give directions to team, matched with ability to manage stress and time effectively.

Specialties: DataStage (Server & Parallel Extender)8.5/8.1/7.5/7.1, UNIX Shell Scripting with databases like Teradata(Bteq, Mload, Tpump, Fastload, FastExport,TPT) and Oracle(SQL,PL/SQL), Netezza, ODI(Sunopsis),
Moody's Analytics FERMAT-ALM,
OBIEE, Hyperion Essbase Cubes.
Hadoop, Hive, Pig, HBase, Sqoop, Flume, Spark Framework.
R, Perl and Python with Hadoop.

Milan Desai's Experience

Senior Professional


Public Company; 5001-10,000 employees; MA; Information Technology and Services industry

June 2013Present (1 year 4 months) Singapore

Member of Global Data-Warehouse Solutions Team

System Analyst

Standard Chartered Bank

Public Company; 10,001+ employees; STAN; Banking industry

April 2011June 2013 (2 years 3 months) Singapore

Project goal is to fulfil following requirements of Business.
•Interest rate & liquidity scenario analysis
•Behavioural and Contractual cash-flow analysis
•FSA Liquidity Regulatory Reporting.
•MAS 613 Minimum Liquid Assets reporting.
•Balance-sheet Analytics.

Responsibilities (Senior Team Member):

•Intensive data analysis
•Responsible for stability of production environment, ensuring the Fermat application has maximum availability and remain within SLA.
•Stakeholder management (Spread across 19 countries, at various organization levels), by various modes of communications.
•Incident management, Problem Management, Change management.
•Continual Service improvement, by filling technical/functional gaps.
•Coordinating with various teams (Development/Infra/Business) to accurate deliver the goals of the Application.
•Upgrade of the Moody’s FERMAT Application from version 5.3 to 10.x
•Database migration from Oracle 10g to Oracle-RAC 11g.

Environment: Moody's Analytics - FERMAT(Asset Liability Management ,Liquidity Reporting Modules), Datastage 8.1, 8.5, Oracle 10g,11g, Oracle RAC 11g, Oracle Business Intelligence Enterprise Edition.

Technical Consultant

Infforay worked for OCBC Bank

Privately Held; 51-200 employees; Information Technology and Services industry

May 2010April 2011 (1 year) Singapore

Program–SIBS Standardisation:
New version of Silverlake Integrated Banking System (SIBS) is implemented, and Bank-wide operations are impacted.
• Analysis of the Entire EDW operations, identifying the impacted areas.
• Preparing the EDW History-Data Conversion Approach.
• Designing and Data-mapping, Preparing Testing Strategy.
Environment: – Teradata 12, Datastage 7.5(IBM-AIX), Oracle ODI(Sunopsis), Control M

Project–Enterprise General Ledger Reconciliation (GL Recon):
Consolidation and Standardization of EDW data reconciliation with Oracle GL
• Requirement gathering.
• Analysis of the Existing System, to Identify Technical gaps.
• Provide scalable architecture possible within the existing framework to fill the technical and functional gaps.
• Automate Manual QA checks.
Environment: – Teradata 12, Datastage 7.5, Oracle GL, Oracle ODI(Sunopsis), Control M .

Project – Batch Optimization
• Analysis of the Existing System, to identify the bottle neck in process flow.
• Suggested and implemented slicing of data for large tables eating up more processing time.
Environment: – Teradata 12, Control M, Oracle ODI(Sunopsis).

Application Dev.-Team Lead

JP Morgan

Public Company; 10,001+ employees; JPM; Financial Services industry

August 2009May 2010 (10 months) Mumbai Area, India

Project – Credit Card Services:
Sourcing daily transaction data coming from EDS/TSYS processors, to load DW and OLTP databases for reports and front-end online applications.
• Understanding of the Business Functionality, Defect Fixing, Code Review.
• Team Building (Recruiting).
• Actively involved in laying Processes for configuration management.
• Visited Onshore (Chicago) for 2 weeks for Knowledge transition.
Environment: – Datastage 8.1(IBM-AIX), Oracle RAC, Clear case, Clear Quest

Associate Technical Consultant

Teradata India Pvt. Ltd.

Public Company; 5001-10,000 employees; TDC; Information Technology and Services industry

March 2008August 2009 (1 year 6 months) Mumbai Area, India

Client – Lenovo
Manufacturing EDW:
Operational data from SAP-BW was extracted via Open Hub extract stage and was loaded in staging area and form staging area was loaded to core tables using Datastage jobs.

• Estimate the time and resource requirements of ETL development work.
• Design and development of Datastage Jobs to load Master Tables, Staging Tables, Core Tables.
• Follow the progress of ETL development and how it meets estimate and actual timelines.
• Challenge was to handle Unicode data (Chinese characters).
• Conversion of Server jobs to Parallel.
Environment: – Datastage 7.5/8.1(Windows 2003), Teradata, SAP-BW, Perl scripting as Wrapper, Teradata BTEQ.

Client – Saint Paul Travelers:
Project-Monthly LossDB:
Monthly data for following subject areas Claim, Coverage, Amounts and Reference was sourced from Teradata Staging area and after transformations and validation of business rules through Datastage was loaded in EDW.
• Design, development, Testing and Implementation of Datastage Job flows.
• Initial Operational Support and change requests, Defect fixing cycles for the delivered code.
• Documentation of the delivered code

Project-Change History File:
As part of Merger activity of two organization History data of Saint-Paul was to merge with Travelers’ EDW
• Development of new subject area (CHF-Change History File) including the whole cycle starting from Business requirement understanding, POC on new subject area to final delivery of the jobs developed.
• Documentation of the delivered code
Environment: – Datastage 7.5(IBM AIX), Teradata, Shell scripting as Wrapper, Teradata BTEQ, Datastage Versioning Tool.

Senior Software Engineer

Larsen & Toubro Infotech

Privately Held; 10,001+ employees; Information Technology and Services industry

October 2007March 2008 (6 months) Mumbai Area, India

Client – Freescale Semiconductors:
Project-DS UPGRADE 7.5.1 to 8.0.1:
• Automated data check application.
• Dual test environment for future upgrades.
• Creating test cases for thorough testing for 500+ jobs.
Environment: – Datastage 7.5/8.1(IBM AIX), Teradata, Shell scripting as Wrapper, Teradata BTEQ.

Project – LOT Master:
Creating Data-mart for manufacturing data
• Business Requirement gathering. Designing Prototype.
• POC with Real-time Data warehousing using Websphere Capabilities of Datastage 8.1.
Environment: – Datastage 8.1(IBM AIX), Teradata.

Deputy Manager

Reliance Communications

Public Company; 10,001+ employees; RCOM; Telecommunications industry

November 2004September 2007 (2 years 11 months) Mumbai Area, India

ETL Application Development (DSS)
Responsibilities(Team Member):
• Develop ETL Job, Trouble shooting of Errors in Production Jobs.
• Documentation of jobs

ETL Application Support (DSS)
Responsibilities(Team Member):
• Tuning and Optimization of Job flow to meet Business SLA.
• Maintaining and updating Run Book, as per new releases and changes.
• Automated housekeeping on different mount points on Production Servers.

Audio – Visual Project Team Member

Environment: – Datastage 7.1(Sun OS), Oracle10g, Bash Shell scripting as Wrapper, PL/SQL, SQL Loader, Datastage Versioning Tool, Datastage Scheduler.

Juniour Project Engg.

Automation & Controls

June 2004November 2004 (6 months) Mumbai Area, India

Projects of PLC (Programmable Logic Controller),
AC DRIVES & SCADA (Supervisory Control and Data Acquisition) including control wiring of PLC panels, Motor control panels.

Project - OSP SCADA RTU PANEL INSTALLATION for Reliance Communications
Project - Autoclave Data Logging System for AMAR EQUIP

Milan Desai's Skills & Expertise

  1. Data Warehousing
  2. ETL
  3. Teradata
  4. Oracle
  5. Datastage
  6. PL/SQL
  7. Business Intelligence
  8. Requirements Gathering
  9. Unix Shell Scripting
  10. SDLC
  11. Business Analysis
  12. Telecommunications
  13. Data Modeling
  14. Software Project Management
  15. OBIEE
  16. Databases
  17. Business Requirements
  18. Solution Architecture
  19. Oracle SQL
  20. Data Mapping
  21. Software Consulting
  22. Data Integration
  23. Requirements Analysis
  24. Testing
  25. Shell Scripting
  26. AIX
  27. SQL Tuning
  28. Visual Basic
  29. Hadoop
  30. Apache Pig
  31. Hive
  32. Datastage Qualitystage
  33. Teradata FSLDM
  34. Teradata CLDM
  35. Teradata MLDM
  36. ELT
  37. Sqoop
  38. HBase
  39. Metadata Management
  40. ITIL v3 Foundations Certified
  41. Functional Specifications
  42. Technical Documentation
  43. IT Service Management
  44. IBM Infosphere Information Server
  45. Incident Management
  46. Change Management
  47. Problem Management
  48. Business Objects

View All (48) Skills View Fewer Skills

Milan Desai's Education

ICFAI (Distance Learning)

Diploma in Business Management, Business Management


MBA(Distance Learning)

Currently In Progress

University of Mumbai

Bachelor of Engineering, Instrumentation


Activities and Societies: Student Member of International Society of Automation (ISA)

Milan Desai's Additional Information


Representation of Data-- Visualisation, R with Hadoop.

Groups and Associations:

Contact Milan for:

  • job inquiries
  • expertise requests
  • business deals
  • reference requests
  • getting back in touch

View Milan Desai’s full profile to...

  • See who you and Milan Desai know in common
  • Get introduced to Milan Desai
  • Contact Milan Desai directly

View Milan's full profile

Not the Milan Desai you were looking for? View more »

Viewers of this profile also viewed...