Johann Cheng

User Growth & Engagement

• Conduct Intros/Demos to users based on their analytics maturity level.
• Constantly seek improvements to our tools and how to make it useful to the business.
• Build a trusting partnership with the business, specifically the sales team to ensure that our tools are well utilized and their work becomes more efficient and data driven.

These are the results for the year 2024 Q1-Q3:

• 25.3% increase in dashboard views, compared to previous period.
• 50% increase in new users engaging our dashboards, compared to previous period.
• Garnered 16 success stories from users with seniority ranging from analyst to directors.

Projects

Data Quality

• Worked closely over 6 months with various functional teams in Finance, Technology, Sales and from various locations in APAC, London and Luxembourg to review and aligned our financial figures hosted in Salesforce and Finance database.

These are the results:

• Total of XXXBn GBP reviewed.
• Previously two houses of data now become consolidated into one allowing for greater trust in the figures and insights users see in Salesforce.

AI Translation

• Worked closely with business users across APAC to garner cost savings requirements via external translation services for their decks, PDFs etc.
• Ran a pilot of 4 months to approximate cost savings if translation was done in house.
• Coordinated with development team in London to priorities request based on cost savings business case.

[On going project]

Ad Hocs

• Analysis work using SQL and/or Salesforce Reports for users.
• Advocate of our internal chat GPT; participated in a booth to showcase the features of the tool.

• Company Overview: Contract position supporting internal users worldwide
• Collaborated with different departments (Business Intelligence, Engineering, Sales, Marketing) on various projects aimed to achieve the following: Increase qualification rates by Sales Reps by 37% within 4 months of on-boarding via improvement of lead quality and focus areas based on data analysis
• Implemented and participated in brainstorming various ML models to our infrastructure (Google Plx) to surface high potential leads
• Manage monthly communications regarding changes to lead trends and overall business key metrics to give direction to reps and high level snapshot and projection of current business landscape to senior management
• Reduce FTE time savings by 20-25% via automation of Leads/Opportunities uploads and updates in SFDC
• Proficient in debugging SQL script; debugged Google PLX scripts within 4 months of on boarding to resume BAUs
• Efficient in responding to support tickets; SLA ranging from half a man-day to 5 man-days till verification of completion by submitter, depending on priority and complexity of tickets
• Improved interface of team members using the SFDC interface by building new features(flows) to ensure data hygiene and strengthen support towards the sales team, for eg, email reminders when an opportunity is monetising
• Consolidation and improved efficiency of back end workflows from 50+ workflow rules to 5
• Act as an SME for overall Global (EMEA, APAC, LATAM, NA) in SFDC; 1 - From gaining regions' managers nuanced requirements and ensuring it fits into the global context
• 2 - Working with team members in different regions to train them on how to use SFDC (UAT)
• 3 - Gaining feedback on current implementations and constantly seeking innovative measures to share amongst different regions

• Sales revenue analysis across different business units and different accounts within the region to determine QoQ and YoY variances and attributing factors with the intention of forecasting future performance
• Highlight key strategic customers in the SGMY region to determine proportion of business maintained in that account for strategic initiatives
• Create and maintain a dashboard for businesses in the region
• Manage 30+ Growth initiatives in the SGMY region (From budgeting and fund management to tracking project milestones)
• Prioritize high business impact projects and created an automate dashboard to visualize projects dynamically on Excel
• Effectively manage stakeholders (Finance, Project Leaders, Business Leaders) so as to ensure smooth progressions of projects

• Work closely with Salesforce Business Analysts to support local Shopee countries
• Supporting Business Analysts during project testing and implementation to ensure business requirements are translated into output that fulfills business needs
• Conduct testing (UAT) with relevant parties to improve Salesforce CRM design and structure
• Project coordination of Salesforce projects
• Document, manage and prioritize user requests for system changes
• Pickup and solve the operational issues that are reported by the user
• Monitor status of data integration with Salesforce as part of the daily SOP
• Learned querying using Salesforce Object Query Language (SOQL) to extract data and edit data using developer console query editor
• Involved in generating weekly login statistics to measure users activeness on Salesforce
• Facilitated end to end projects from gathering business requirements to creating relevant reports used by users
• Regular involvement in data validation to ensure accurate data is being synced