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 automation of tasks

- 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 quantifiable metrics and queries to highlight Suspicious Transactions- Implemented Standardized reporting templates for financial institutions- Conducted data extraction, verification and data cleaning for systems’ data migration- Performed data visualization using SAS and Tableau to better understand cases- Gained valuable insights and appreciation for Singapore's law enforcing agencies

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• Updated and edited daily reports that are crucial to business operations for sales and admissions team• Communicated improvement to reports, addressed report issues and managed tasks on JIRA• Created, checked and managed reports on Salesforce and other customer data management and CRM systems

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• Mentored and motivated Polytechnic students in proposal writing and idea pitching for their Final Year Project• Planned with other student mentors to deliver a holistic and comprehensive 5 session training for the students

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 and school personnels is crucial and bridge the 3 sides together-Lead the Finance committee in planning and execution of the orders for all aspects of the camp that require expenditure. (Every expenditure must be within budget and done within a certain time-span to meet the requirements made by school)-Collaborate with other Sub-Committees to promote the camp-Assist Marketing team in making the video

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• Brainstormed on new campaigns ideas and execution to create awareness of social isolation faced by senior citizens • Negotiated and formed marketing collaterals with external Design, Public Relations, and Consulting stakeholders• Facilitated cluster outings for senior citizens, took care of them and interacted with them throughout the event• Systematized the Standard Operating Procedure of Fundraising Department into SOP documents for future interns

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 Next-of-Kin emotionally stable)

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).

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.