Max Mok Email & Phone Number

Singapore

- Solution Architect, successfully remediate existing AWS EC2 tech stack to Modernized Tech Stack

- Technical Lead Emerging Markets , Data Quality- Data and Analytics Market Engagement Lead, successfully roll out and enable Data and Analytics capabilities to AP Markets- Scrum master and Construction Manager for Redshift Datawarehouse Project team in APAC - Successfully Implement of Data Migration Service in AWS, Matillion jobs- Successfully implemented Data Integration, Data warehouse for China Project- Lead a team of data architects, data analysts offshore and onshore- Responsible for developing and maintaining data structures (Physical and Logical Models) and repository of definitions of the data and data structures. On Oracle, Redshift

- Requirement sessions with users. Provide POC, demos and presentations. - Design Microstrategy BI visualization dashboards for users analytics- Create functional and technical documents. - Plan, design and model Enterprise datawarehouse- Design and model Microstrategy Architect. (Schema Objects, Facts and Metrics)- Meet development team to understand upstream data sources (Outsystems, SAP BW)- Plan, design and create informatica ETL jobs

- Work with a data analytics team in delivering and supporting GIC data needs for investment analytics and reporting.- Design, build and maintain an analytics data warehouse, streamline and harmonise data from GIC’s different sources, and provide customized data services to power the various analytics and reporting platforms.- Provide day-to-day operational advisory to business users.- Provide technical leadership and guidance to junior team members and vendors.

International Business Park

- Lead and Work with the ETL team to implement changes to the warehouse model as well as the ETL extraction process. - Lead and manage report staff to make the changes to existing Reports to cater for the new system. The reports are both located in MSTR or even direct batch programs hitting the databases.- Train and share data knowledge of the Business logic and Technical knowhow on the data model. Train end users on MSTR so that they are able to use and run MSTR reports.- Maintenance of Microstrategy Servers including Administration, Upgrades. Setting guidelines and making sure all different Microstrategy Servers are in sync- Project: As part of implement a new billing system, required to analyse the impact of all data sources to the Datawarehouse or Microstrategy.- Create the definition of logical and physical data models for the project. (MSTR)- Modification of existing Schema objects (Attributes, facts) to cater for the changes. And creation of New Dashboards, Reports, Attributes to the system. - Troubleshoot and resolve data, system issues and performance issues.

Dbs Tower 2

- Serve as a liaison and facilitator between ETL team and Reporting team to assist in addressing and resolving IT software issues. Involving the datawarehouse model and performance issues.- Work closely with Microstrategy vendor to ensure delivery of new dashboards and resolutions of incidents, problems, within the agreed timelines.- Successfully trained users in Asia and Europe offices on MSTR features and abilities.- Created multiple Web Dashboards based on user requirements.- Successfully implemented and creating of mobile dashboards on ipad.- Successfully converted multiple cubes from Cognos to microstrategy. This includes creating of new Projects, new Schema objects, Facts, metrics, filters and Sample Dashboards.- Set up and installed Microstrategy onto AWS and also on physical production servers (Vienna Office).- Successfully upgraded Microstrategy from 8 to 9. Completed upgrade MSTR 9 to 9.2.1m

Creating of Daily Sales reports by using VBA scripts, extract data directly from the Oracle database.Part of Microstrategy Datawarehouse Project. Current datawarehouse is restructured and converted into MSTR 8.Administrator and architect of the MSTRGetting new user requirements for creation of reports.Creation of the Bill Simulation application that is able to calculate the estimated revenue earned in the future if a new bill plan is to be released. Create a Softbill Application which is able to calculate the customers' usage like the billing system

System Analyst, It

Business Admin, Business