Mohan Asangi Email & Phone Number

United Arab Emirates

Dubai, Ae

Technology advisory to multiple business entities within the Emirates Group for Data Science, AI, BI Reporting and Analytics solution domain. Evaluate, recommend and implement BI and Analytics technology solution components for specific business challenges and act as a consultant to the Head of business departments.Overhaul of the entire Data landscape of the Emirates Group with a Cloud-first strategy implementation. Capability fitment evaluation and implementation of Cloud Data warehouse for Emirates group, with selection, design and delivery of “SNOWFLAKE” Cloud Warehouse on the Azure Platform.Lead the “Tech Enabler” scrum team responsible for the technical enablement functions required for the Emirates Group Analytics “Architectural Runway” comprising Informatica Power Centre ETL Toolset, Oracle Exadata Data Delivery platform and Microstrategy BI for the presentation and analysis layer.Architected, designed and facilitated the delivery of the entire Airline Competitor analysis capability for Emirates Commercial depts. sourcing data from MIDT, DDS and Accelya, ingesting it into the data lake, processing and applying business rules and moving the processed data sets into a high performing star schema in Oracle Exadata exposed to Microstrategy. Supported the data modelling and information transformation design from the source data sets into Hadoop and then to Exadata/MicrostrategyManaged the growth of the Microstrategy platform from a 50 user Dubai based implementation to a 3000+ user worldwide community of Sales departments for Emirates Commercial. Facilitated the upgrade of the group wide deployment of Microstrategy from Version 9.6 to the platform release Version 10.4Designed and architected the analytics layer for the Airline Fare Ladder implementation for Revenue Optimization, comprising 50Billion Rows as the main fact table, with less than 10s response times on the Microstrategy layer

Dubai, Ae

Evaluation, selection, design, development and implementation of Exadata for the Enterprise Data Warehouse Serving Layer, which is one of the key components of the Emirates Group's Enterprise Intelligence and Analytics capability. Involved in the design, testing and implementation of the entire 'Lift & Shift' from Oracle 12C to Exadata RAC implementation. Strategic roadmap and implementation of the Enterprise wide BI serving layer. Architected, designed and developed strategic datawarehouse for Airline Commercial Business Intelligence with Oracle 12C and Microstrategy. Exploited the In-memory features for meeting some very exacting requirements on Booked, ticketed, flown, MIDT and forward booking analysis.Conceptualise, design, develop and implement the Emirates Data Lake using Lambda Architecture principles. Key technologies used: HDFS, Spark, Storm, Flume, Hive with the streaming data coming from Res/Check-in systems over TIBCO. Mashing conventional BI tools and technologies viz., Mcrostrategy, Business Objects, Jaspersoft with Hadoop. Trialled Datameer and Kibana for data prep and visualisation.Use case exploration in multiple business areas of airline marketing & communications, Commercial operations, airport & airline operations, airline service delivery, aircraft engineering, and various others. Actively involved on various Big Data and Industrial Analytics initiatives for aircraft operations from Conceptualisation, Proof of Value and Execution. Evaluation, selection, design and Implementation of Microstrategy and Teradata for the Emirates Group. Designed and developed the semantic layer over the Teradata Airline and Hospitality Data Model.'Productionised' Hadoop & HDFS for extreme processing of structured data in Airline Fare Rule processing, using standard HP brick servers. POC's on Analytic appliances, Data Visualisation tools and Machine Learning algorithms.

Dubai, Ae

Manage the critical business intelligence tool-set for the Emirates group, which is the basis of 60 key DSS, BI and Analytics applications ranging from Revenue Optimization, Airport Operations, Flight Operations, Engineering, Management Accounting and Financial Applications domains. Responsibilities comprising short/medium/long-term BI tools roadmap, 3rd Party Vendor Management, Change Management, Tool Evaluation/Selection/Upgrade and complete Data Architecture Design for some of the key projects.Responsible for supporting the software development, software testing and business intelligence tools to various IT projects in Emirates.Lead a team of high performing technology professionals, which acts as an architecture and systems design consultancy to guide various IT projects in Emirates group effectively harnessing Business Intelligence and Java Technologies across the Airline domain.

Dubai, Ae

Delivered BI, Airline Pricing and OLTP applications in the Airline Revenue Optimisation domain. Specialised in Business Intelligence systems with deployments of Business Objects and Oracle Express applications.Principal Business Analyst and Architect for the AQUA, (Decision Support and Business Intelligence solution for Emirates Revenue Optimization, Fare analysis and Fare Tracking) and Emirates Fares and Rules Repository, a data warehousing decision support system for Emirates Pricing, which is now a key building block for various decision support and revenue optimization applicationsDelivered automation requirements and systems analysis for Pricing Department Process. Systems Improvements to FACTS (Fare Analysis, Control and Tracking System), LSOM (Outstation Module for Sales Staff), Interline pricing analysis systems

Mumbai, Maharastra, In

SME for Stock Market Trading systems, Settlement Systems, Debt Markets & Government Securities Trading for analysis and automation requirements of National Stock Exchange.Designed and delivered Securities Settlement and Holding system, which is a Back office cum Custodial software which facilitates securities as well as funds accounting for the SGL Department of the NSCCL, integrating the processes and operations. System interfaces with multiple exchanges, multiple depositories as well as multiple clearing corporations but has been primarily designed considering the Reserve Bank of India as a single clearing corporation and depository. The product features include Application Processing for Clients, Dematerialization, Rematerialization, Inter City Transfers, Trades settlement for/between constituents, Corporate Actions and Billing among other features.Business analyst for the Securities Listing system, which is a database of all the securities, which have been listed or permitted to be traded on the WDM segment of the National Stock Exchange. Other than maintaining the exhaustive information regarding a security, the listing system facilitates processing for listing / permitting a security, maintenance of off-market trades reported by brokers and compliance of listing agreement among other features.Business analyst and user acceptance testing for the MIBID/MIBOR which is the acronym for the Mumbai Inter Bank Bid and Offer Rate, which is the reference rate for the call money market at Mumbai. The system basically accepts bid and offer rates on the overnight call money from various banks. It then statistically purges all outliers using a method called boot strapping and then calculates the reference rates at various standard deviations. The user then chooses the reference rate calculated depending on that day’s volatility in the call market. This rate is then disseminated to the market as an online feed to various news agencies.

Design of material handling systems for effective usage of space and shot blasting exposure. Capacity planning and MonitoringPre-sales activities for Sales and Marketing department.

Cmmi V1.2, Process Governance

Mba, Finance, Systems

Diploma, Quality Management & Systems

B.E., Production Engineering

High School Certificate, Electrical, Mechanics & Engineering Drawing