Summary
Overview
Work History
Education
Skills
Websites
Certification
Hobbies
Languages
Portfolio
Timeline
BusinessAnalyst
Yining Esther

Yining Esther

Summary

Passion for helping people find lasting joy through personal development and aiding those with mental health challenges with resilience and mindset training.


4+ years of experience, success in SME funding strategy. Refined interpersonal communication and negotiation skills in past working relationships.

Overview

11
11
years of professional experience
4
4
Certification

Work History

Assistant Manager

National University of Singapore Business School
Singapore
06.2023 - 07.2023

Joined as Assistant Manager under NUS Business School Dean’s Office. Job scope includes business development for internship/graduate opportunities, organizing and managing recruitment events, conducting student training workshops, analyzing large amounts of student graduate employment and

internship data from different sources (eg. Internal surveys, GES), designing eDMs and publicity materials on Canva, providing students with career advice. Currently in training phase.

Key accomplishment(s) as detailed below:

  • Research: Researched and discovered 3 relevant graduate and management associate opportunities that were added to infographics from 12 accounting firms.
  • Organization (Work preparation): Used data validation, today(), eomonth() and conditional formatting to organize daily tasks by day and time. Plotted important events and timelines on excel in Gantt chart format. Created structure map on Excel for over 100 files on MSTeams with direct links to team sections and folders and tooltips for each link for quick reference and navigation of folders and files.
  • Teamwork and Process Improvement: Implemented Word drop down list content control for filling up work forms according to alphabetical order, reducing human typos and time to fill each form by 3-5 seconds for the administration and operations team.
  • Learning: Finished 6-7 modules of assigned e-learning within 1 day. Self-learned basic work processes for handling enquiries on CPF exemption letters, credit bearing and non-credit bearing internships in a week.

Reason(s) for resignation: Change in family circumstances, need more flexible work arrangement.

Finance Manager

向日葵软件(天津)有限公司
05.2017 - 11.2021

Analyzed industry trends of healthcare in China and Singapore and provided strategic recommendations to CEO. Prepared marketing materials and financial forecasting for application of municipal government grants for startups. Prepared GL and other financial data for tax and financial reporting purposes. Handled full spectrum of taxes including corporate tax, personal income tax, VAT, stamp duty. Performed ad hoc duties as needed (Drafting of company policy – finance and human resource, for instance AR credit policy). Key accomplishment(s) as detailed below:

  • Provided strategic advice for investment through corporate partnerships, obtained government funding of 500K Yuan for joint research project with Tianjin Polytechnic University and local hospital in 2017.
  • Successfully applied for and obtained tech startup certification issued by Tianjin Science and Technology Commission
  • Used prudent financial management strategy to avoid business bankruptcy during COVID.


Please visit https://kxjs.tj.gov.cn/BSFW9672/XMGL4742/XMLX1772/202010/t20201014_3950875.html and download the word attachment for proof of government funding given to 向日葵软件(天津)有限公司. Kindly refer to no 95 in that list for the amount of municipal funding given and research project details.

Research Intern

National Institute of Education
02.2016 - 05.2016

Joined as Research Intern, administered different types of psychometric tests to children aged five that tests cognitive abilities in language and mathematical tasks as well as socio-emotional competencies using Theory of Mind (TOM). Took part in Special Interest Group and participated in training course for SPSS to broaden understanding of developmental psychology and statistical tools. Key accomplishment(s) as detailed below:

  • Conducted literature review on bilingualism and impact on socio-emotional outcomes independently.
  • Consolidated key findings into insights from over twenty literatures on bilingualism and socio-emotional wellbeing of Asians and Westerners in one week.
  • Drafted thirteen-page proposal on two new research areas in the Singapore and Asian context in one week. In depth exploration of the link between bilingualism, academic performance and socio-emotional wellbeing and indirect effects of bilingualism on socio-emotional outcomes through its documented effects on neural development.

Management Intern

KPMG Services Pte Ltd
12.2012 - 02.2013

Assisted Associates and Senior Associates in preparation of audit working papers. Computed accounting figure on audit working papers. Cleaned management account figures data. Updated hundreds of clients’ corporate shareholdings records for final stage of audit. Learned the use of KPMG’s E-Audit system. Key accomplishment(s) as detailed below:

  • Received positive appraisal and offered full time position upon graduation.

Finance Intern

Nexia TS Public Accounting Corporation
05.2012 - 08.2012

Managed the Billings and Collections (B&C) cycle. Daily update of B&C schedules using Excel PivotTables, issuance of invoices from MYOB Accounting, recording of check payments and updating of AR records for 6 departments. Analysis of B&C data using PivotTable and VLookup to guarantee accuracy of month to date totals. Assisted Manager with generating aging and other accounting reports from MYOB Accounting system. Key accomplishment(s) as detailed below:

  • Received positive appraisal and met NUS’ compulsory internship requirement.

Events Team Leader

AIESEC in NUS
09.2012 - 02.2013

Selected as Events Team Leader by OGX Department Head. Planned agenda and logistics for 3 events. Managed external communications with event participants, speakers, logistics support and vendors. Key accomplishment(s) as detailed below:

  • Obtained free photographic support from NUSSU VPC by negotiating for potential long-term partnership with AIESEC.
  • Events were ranked as best compared to prior years.

Human Resource Director

AIESEC in NUS
12.2012 - 02.2013

Recommended by OGX Department head to help with January recruitment. Planned recruitment marketing, manpower allocation for recruitment events and interview schedules. Identified gaps in recruitment events and proposed improvements to talent pipelining and marketing of value proposition of MEP. In charge of external communications with applications, trainers and members of AIESEC HR department. Prepared professional meeting minutes for committee meetings. Key accomplishment(s) as detailed below:

  • Invited by HR department head to work on more HR projects

Education

Bachelor of Business Administration - Accountancy

National University of Singapore
Singapore
02.2016

Skills

  • Microsoft Excel/PowerPoint (Intermediate)
  • SQL (Beginner)
  • Tableau (Beginner)
  • R (Beginner)

Certification

  • Google Data Analytics Professional Certificate (Coursera, Jan 2023)
  • Finance & Quantitative Modeling for Analysts Specialization (University of Pennsylvania, Coursera, Feb 2023)
  • Data Analysis and Presentation Skills the PwC Approach Specialization (PwC, Coursera, May 2023)
  • Content Marketing Certification (HubSpot Academy, July 2023)

Hobbies

I love to sing whenever I am free and was previously part of choir in my secondary school years. I also occasionally do sketch drawings of favorite anime characters like Conan and Nausicaa. 

Languages

Chinese (Mandarin)
Bilingual or Proficient (C2)
English
Bilingual or Proficient (C2)

Portfolio

Google Data Analytics Capstone Project

URL: https://rpubs.com/esthers/bikesharingcasestudy

  • Completed the course in one month
  • Cleaned, filtered and extracted data using Excel and SQL (BigQuery)
  • Created data visualizations using Excel, R and Tableau

Monetization Strategy Case Study, Apr 2023

Portfolio available upon request

  • Completed case study in 2 days

Article on Budget 2023, Apr 2023

Portfolio available upon request

  • Completed research article and presentation slides in 5 days
  • Designed infographics using Wondershare-Edraw (free)

Market Research Plan, Jul 2023

Portfolio available upon request

  • Came up with 19 research topics based on buyer personas in 2 days
  • Estimated size of target audience for each buyer persona group using statistics from SingStat and other sources

Timeline

Assistant Manager

National University of Singapore Business School
06.2023 - 07.2023

Finance Manager

向日葵软件(天津)有限公司
05.2017 - 11.2021

Research Intern

National Institute of Education
02.2016 - 05.2016

Management Intern

KPMG Services Pte Ltd
12.2012 - 02.2013

Human Resource Director

AIESEC in NUS
12.2012 - 02.2013

Events Team Leader

AIESEC in NUS
09.2012 - 02.2013

Finance Intern

Nexia TS Public Accounting Corporation
05.2012 - 08.2012

Bachelor of Business Administration - Accountancy

National University of Singapore
Yining Esther