Michael Xia

• Recent MSc Business Analytics graduate specializing in data analytics to provide business solutions, with prior internship experience as data analyst.
• Learned and applied project management, quantitative and analytical capability with sound knowledge about data analytics and database; Clean, model, and analyze data proficiently while utilizing programming languages like Python and R; Demonstrate expertise in managing both SQL and NoSQL databases, extracting valuable insights.
• Demonstrated ability to contribute to teams with minimal training; Extensive leadership experience gained through university academic and extracurricular activities.

Data Analyst, Intern                                               Feb 2023  – May 2023

EssenceMediacom, Singapore                                                                  

• Executed ad-hoc analysis about advertising revenue and retention rate by analyzing over 218,000 records in BigQuery by leveraging on SQL language to analyze on the media team’s marketing campaign outcomes.
• Participated in building data automation pipeline to extract campaign leads data from multiple sources such as website publishers and pre-processes data using python to support the updates of Cloud Reporting Dashboard on Looker Studio.

Project Engineer, Intern                                           May 2021  – Jul 2021

Peak Ocean Group, Singapore                                                                  

• Successfully completed CRM system and database migration project to reduce the data retrieval and uploading time by 15% within 7 weeks.
• Executed transfer of talents information to new CRM system by updating 500 pieces of CVs in one week’s duration to which made the company in using the new system seamlessly without any failure. 
• Audited talents information stored in CRM system by addition and modification of 260 resumes and ensured the accuracy of information.

Shipping Operation Analyst, Intern                        Aug 2020  – Dec 2020

ChemChina, Singapore                                                                             

• Consolidated over 200 sets of contracts written in English and Mandarin about crude oil trade; historical costs of shipment freight were calculated on time for demurrage claims to be submitted to the management. 
• Calculated amount of shipping costs using allegro software based on banking information and charter parties to apply urgency to update over 100 invoices on schedule. 
• Identified 35 specific voyages near last drydock from 305 voyages in past 2.5 years which assisted risk department control costs arising from crude oil loss within three days.

MSc Business Analytics 

• Nanyang Business School, Nanyang Technological University, Singapore • 2023