Mary Tan Email & Phone Number

Cbd

Auckland Cbd

Auckland, New Zealand

National Hauora Coalition (NHC) is a Maori-led Primary Health Organisation (PHO) in Auckland. As a Data Analyst in Mohio team, I mainly focus on maintaining and monitoring databases and providing accurate and secured reports to support internal and external stakeholders and support key business decisions.The responsibilities include reporting, analysis, database design and provision of reporting analysis for national primary care network, ManaKidz school based clinics, and various research and social investment programmes.A mix of the following skills and experience:1. Database query, design and administration (Microsoft SQL Server with T-SQL, SSIS)2. Data process (ETL)3. Reporting (SSRS & Excel)4. Microsoft Environments (Word, Excel, Outlook, SharePoint, etc.)5. Using tools such as bug tracking, case management and source control6. Ability to troubleshooting, test and be able to implement or recommend solutions

New Zealand

Working Holiday Gap Year

Beijing City, China

IMS Health founded in 1954 is the largest vendor of U.S. physician prescribing data. It is an American company that provides information, services and technology for the healthcare industry. Most of the famous medicine companies are our clients. It is a global company, with 7,600+ employees and a presence in 100+ countries worldwide. (NYSE: IMS) IMS Health (Beijing Office) has 300+ employees, and my team AA (Advanced Analysis) has almost 100 employees.My responsibilities:1. Analyse healthcare data of U.S. market. Finish projects for Gilead, Novo Nordisk and Abbott.2. Program with SAS and SQL tools to provide statistical methodology support in delivery.3. Cooperate with American colleagues to apply statistical design and methodology to meet clients’ information need, conduct statistical analyses to derive conclusions.4. Prepare for analysis plans and statistical reports, perform validation of statistical analysis.

Beijing City, China

Caterpillar, ranks Top200 in Fortune Global 500 company, is the world's largest manufacturer of earthmoving, construction and mining equipment. (NYSE:CAT)Caterpillar (China) Investment Co., Ltd. was established in Beijing in 1996. To date, Caterpillar has invested in 27 manufacturing facilities in China.My responsibilities:1. Prepare multiple facilities’ capacity target data for suppliers from SAP system and Company Database.2. Analyse suppliers’ data and research capacity gaps through data analysis.3. Participate Caterpillar Hydraulic Excavator Supplier 5 years’ Capacity Planning Project, develop supplier manufacturing value stream mapping and collect data on efficiency and cycle time.4. Consolidate and validate suppliers’ capacity data and identify their capacity constraints so as to make recommendations for improvement. Support suppliers to develop capacity expansion plans.

Beijing City, China

Schneider Electric (SE), a Fortune Global 500 company, is a French multinational corporation that specializes in energy management and automation solutions, spanning hardware, software, and services. (Paris Stock Exchange: SCHN)Schneider (Beijing) Medium Voltage Co., Ltd. (SBMV) was founded in 1997. It has a factory and two layers office of 12000 square meters and hundreds of staff.My responsibilities:1. Take charge of writing and updating all kinds of instructions and training workers to use instructions online.2. Responsible for design and presentation of product flow and safety evacuation diagrams for the annual audit. 3. Support my supervisor in checking goods and reforming process flow.

Master’S Degree, Logistics Engineering, 3.69/4

Main Courses: Econometrics, Advanced Mathematical Statistics and Application, Advanced Mathematical Programming, Project Management.

Bachelor’S Degree, Electronic Commerce, 3.44/4

Main Courses: Management Economics, Applied Statistics, Management Accounting, Management Operational Research, Database Technologies (SQL.