Joyce Grace Zheng Tianjiao Email & Phone Number

Singapore

- Working in DBS under Data Ingestion Project- Built and managed metadata and data infrastructures- Conducted UAT and QA deployments for data ingestion, using big data tools and SQL (Apache Superset)- Communicated with data managers to define data sources, requirements, data definitions and attributes, configuration, data lineage, optimization and.

- Managed Suspicious Transaction Reports from various financial institutions- Designed data transformation and data mapping methods- Monitored the relevancy and accuracy of data, identified inconsistency in data using Excel VBA, Power Query, MS Access and Power BI- Assisted in digitization of data analysis system and various rounds of UAT- Developed.

Singapore

- Validated, consolidated, and reconciled clients' financial data, monthly bank statements and parsed data using Python Script - Created and maintained Tableau Dashboards to monitor and analyze investment portfolios of High-Net-Worth Individuals

Singapore

• Managed and validated important pipeline reports and daily sales and admissions reports sent to CEO and directors
• Supported the development and automation of reports through MS Excel, MS Access, MS SQL Server, VBA
• Liaised with IT and Business stakeholders to ensure Business-IT project success for analytical projects
• Identified and implemented key technologies for optimizing crucial reporting processes and reporting effectiveness
• Supported team in new data science initiatives such as Machine Learning and data visualization
• Consolidated quarterly Executive Leadership Team meeting notes and discussion

Singapore

• Audited, cleaned and organized research data using Excel Tools for research conducted in all 12 countries
• Analyzed and reported data, insights, findings for Lenovo mystery shopping marketing research wave 2

• HOPE CHURCH UNIVERSITY CAMP | Communications Team Apr 2017 – Jul 2017
• Co-led the publicity team to come up with camp preview video, T-Shirt, tote bag and logo for 500 students
• Edited and created the videos and photographs using Adobe Premiere Pro and Illustrator and Adobe Lightroom CC
• Led and coordinated with a team of 10 volunteer photographers to cover the 4 days 3 nights campSMU SICS CAMP | Finance Deputy Apr 2015 – Aug 2015
• Co-led the finance team in budgeting, sourcing sponsorships and communicating with external vendors
• Collaborated with other teams to come up with camp themes and promote camp to the incoming freshmenPROJECT ROOKIE, BUSINESS SOCIETY EVENT | Student Mentor May 2015 – Aug 2015

Bras Basar

-Deputy Finance Director: Budgeting, source for sponsorship, liaise with external vendors-High Level of Interaction and communication skills-Look ahead; anticipate the next step (set time-line and goal for the committee)-Negotiate and share camp objectives with vendors and school personnels from Office of Student Life-Timely update both team and vendors.

Central Singapore

• Coordinated with donors and sponsors for the inaugural Silver Bow Charity Dinner and annual Flag Day Fundraising
• Designed, conceptualized and created EDMs, Newsletters, event posters, Facebook posts and media coverage report
• Covered major events; ie. Inaugural Magic Makeover that received more than 300 views for Facebook Live Feed
• Represented Organization in events by sponsors and guests; took photographs and posted on Facebook Page
• Assisted with the first Lions Befrienders TV Commercial brainstorming, storyboarding, filming and production
• Chaired weekly team meetings to provide critical feedbacks, key updates and bridge any communication gaps

Singapore

• Recorded and documented carefully all company expenditures, claims and revenue streams
• Forecasted and projected the company’s revenue and growth for the next few years
• Created new brand positioning and company vision by reclassifying company product offerings
• Designed professional product brochures with new company brand image using Adobe Photoshop
• Assisted part-time employees to pitch a new product to clients, successfully closed 3 corporate deals

Singapore

-Assisted in creating Invoice and Purchase Order of IT services for different companies and governemental organizations.-Involved in the annual forecast and budget exercise to estimate expenditures for the remaining months of the year-Liaised with external organizations

Yishun

-Calm worried Patients’ Next-of-Kin-Update the Next-of-Kin on the condition and check-up or treatment progress of the patients -Understand the feelings that the Next-of-Kin may have-Balance the interest of the doctors and the Next-of-Kin (control the number of Next-of-Kin asking the doctors questions or checking on the progress at the same time keep the.

Bachelor Of Business Administration (B.B.A.), Marketing And Finance

Activities and Societies: SMUX Organised various camps Participated in many voluntary work Embarked on adventures to Perak (Malaysia) and.

Bachelor Of Business Administration (B.B.A.), Finance And Marketing

Activities and Societies: SMUX (Extreme sports CCA), Xseed (go overseas for extreme sports) Excelled in Analytical Skills, Asia Pacific.