StAROfLiGht Cy

To tell you more about myself, I am a data visualization specialist currently working in a finance industry (DBS Bank). In DBS Bank, I create dashboards for management and stakeholders to report financial figures so as better understand and evaluate the performance of the company. For instance, one of the dashboards I have created is the wealth dashboard, to analyse the wealth sector in DBS.

The process would usually start by understanding the stakeholders requirements , before engineering the data in python and placing into Tableau to create the visualization. From the dashboards created we can identify top performing sectors within the various countries, with the ability to drill down to find out the reasons why (to the product/user/currency pair levels). We can also identify product/ccypairs/users that are top performing, improving, deproving or underperforming to give insights to stakeholders to action upon.

Besides the wealth consumer banking sector, we also work closely with the treasure and markets sector (TnM) to build dashboards that provide insights and reporing purposes for management as well (for CEO Review). Similarly, we have to analyse the country, product, customer segments, users and currency pairs to identify trends as well as anolmalies. I would give presentations to key stakeholders through Tableau as well as create power point slides as and when needed.

The main softwares I use are Tableau/TableauPrep/Server, SQL (as and when needed) and Python ( a little).

DBS Bank Oct 2021 to Present

Data Visualisation Specialist

Data analyst visualization specialist that builds dashboards for stakeholders to analyse the performance of the company. Provide analytical insights and business intelligence to the various stakeholders in terms of which sector/country/product/currencies are better or worse performing. Identifying trends and analomies to help stakeholders provide valuable feedback to the traders.

• Wealth and T&M Sales Performance Dashboard ( Contains around 15-20 dashboards of sales performance dashboards (overview, country, product, customer segment, user segment, new wins )
  • Purpose of these dashboards are the analyse the performance of DBS’s Wealth and TnM sectors 
  • Overview Dashboards – Incalcates key snapshots of important information that represents the performance of the company as a whole.
  • Country Dashboards – Drills down into the performance of each of the individual countries to understand their performance
  • Product Dashboards – Idenitfy top performing products/poor performing products
  • Customer Segment Dashboards – Analyse the sectors within countries
  • User Segment Dashboards – Idenitfy top performers/improvers/decliners/underperformers
  • New wins Dashboard – Identify and analyse new wins that happen recently
• Data Wall dashboards (T&M Overview Sales, FXD, EQD, HR, IRS, CRT)
  • T&M Overview Sales – Overview sales performance for the T&M department
  • FXD – Analysing FXD ‘s performance in terms of volume/number of trades for the various countries, customer segments as well as currencies.
  • EQD – Analyse top performing equities/stocks/markets/product/currencies in the various segment/countries
  • HR – Understand the diversity of the population (age, gender of the employees in the various countries
  • IRS – Analyse the new product launch interest rate swaps (errors, segment, tenor and users)
  • CRT – Credit Risk Dashboard – Understand the sales of the credit risk trading department in terms of segment, country, currencies
• FXPA (User interaction) Dashboard
  • To understand click stream data and help management to understand which sector is performing better/worse
  • Come out with insights to improve the UI/UX design and help users use the platform better
  • Monitor the usage of the platform
• Management Report Dashboards (PSC, PGB, CEO Review, Product Overview Dashboards)
  • Creating dashboards for management reporting purposes. Dashboards include sales performance for department as well as the company as a whole.
  • PSC, PGB, CEO Review are overview management reporting dashboards to showcase the performance of the bank as a whole
  • Product Overview Dashboards are overview management reporting dashboards to showcase the performance of the bank’s products in terms of volume, profit, transaction count, user count and customer count.
• Ad-hoc Data Requests
  • Provide stakeholders with data as and when requested.

Maha Chemicals Sep 2020 to Sep 2021

Regional Data Analyst Associate

Design, build and enhance visual analytics assets to ensure the continued relevance and usage of the dashboards for stakeholders to provide business intelligence, data visualization and advanced analytics support. Help automate refreshment of extracts to provide scalability and reusability of dashboards. Support ad-hoc requests from business users by querying from sql.

• Marketing Analytics Dashboard (Facebook, Instagram, Linkedin in Tableau dashboard)
  • Gathering 300 excel sheets from all social media , Put in Tableau Prep for data manipulation, final presenting in Tableau dashboard for insights. Analyse which BU has the most effective marketing campaign, which region has the highest reach/impressions/engagement, which post has garnered the most impression/reach/engagement
• Website Analytics Dashboard (Data studio of Maha Chemical’s Website and Chem On Ecommerce platform dashboards)
  • Used Google analytics to track website performance and gather data. Placed data in data studio for analyse and insights (Where does most of our traffic come from, demographics of traffic, which landing page has the most views/clicks, which article has the most impact)
• HR Analytics Dashboard (Employee and Company’s HR performance)
  • Gather excel sheets from company’s system and put in tableau dashboard for data manipulation. Placed in tableau dashboard for insights (Analyse company’s employee demographics as a whole. Which department has the most number of employees, proportion of part-time full time staff) Employee level dashboard has data of all the employee in maha (age, gender, picture, qualification, salary, bonus, kor)
• Sales Performance Dashboard (Sales performance analytics on sales people, business units, country level on tableau dashboard)
  • Gather data from SAP (Queryed from SQL, then placed in tableau prep for data manipulation and dashboarding in tableau. Every business unit has a dashboard (4 business units in total) Analyse and insights: Actual sales VS budgeted sales, percentage of the budget achieved (yearly and monthly), YTD sales and profit prior and current year, sales employee ranking on sales and profit performance, included blanket sales order data as well as CRM data. Working closely with stakeholders to ensure the use of data as a strategic asset.
• Business Units Dashboard on Sales Performance (LS, ST, EM and IS in Tableau)
• Adhoc Data Requests for all departments
  • Query data using SQL to provide stakeholders so as to help them in their daily strategic and operational business decisions.
• SQL query stored procedures (Landed cost, Sales, Profit)
  • Create stored procedures in sql that needs to be use on a monthly basis. Example: Landed cost of items needs to be reviewed monthly.
• Machine learning pricing strategy in R (Multiple linear regression model)
  • Queried data from SAP using SQL, placed in R for data manipulation and analyse. Landed cost and quantity found to be a huge factor in determining the price of an item.

DBS Bank Oct 2018 to Aug 2019

Wealth Planning Manager

Comply with business and regulatory compliance risks before financially advising consumers. Took 8 MAS and IBF examination papers to better understand insurance and financial products in the financial industry.

• Consumer Banking Group Financial Advisor
• Achieve sales target consistently, total of over 100k APE. 
• Sell Insurance endowments, home loans and unit trust. 
  • Attended seminars to learn more about the top 5 funds to invest and sell. 
  • Attended roadshows
  • Understand the requirements of consumer’s financial risk before recommending suitable financial products
  • Transacted home loans for customers requiring a mortgage loan
  • Transacted endowments and unit trust based on customer’s risk appetite 

Teaching Assistant Apr 2017 – Jul 2017

 

• Selected to assist professors in 2 Master of Business Administration Courses (Strategy Consulting and Entrepreneur Finance)
• Evaluated postgraduate students’ class participation contributions
• Corresponded with senior management from established companies such as Mastercard

OCBC Bank (Internship) Apr 2016 – Jul 2016

 

Group Technology and Risk Department

• Coordinate meetings with various stakeholders
• Project management of movement of capital and human resources of merger with Bank of Singapore
• Secretarial duties for meetings and project management

Johnson & Johnson (Final Year Project) Aug 2017 to Dec 2017

• Collaborated with Johnson and Johnson on the final year Analytics Practicum project.
• Created a database for Johnson Baby Oil using R by collating and cleaning all data regarding Johnson Baby Oil (Bill of Materials, Distribution Centres, Purchase Finish Goods, Volume, SKU, Variant and etc.)
• Worked closely with Johnson & Johnson by having regular weekly meetings to meet targets and datelines.
• Input the finalized Mastertable into Tableau to present visualisations
• Generated useful insights of the products life cycle from procurement to sales and reduce cost in operations
  • Which manufacturing plant is producing the oil at the lowest cost. Which chemical in the SKU is the most cost effective. Labour cost in a certain plant is more expensive than the other.

Suu Balm (Final Year Project) Nov 2016 to Jan 2017

• Created a marketing campaign for Suu Balm to expand into the China market
• Attained A for this module.
• Marketing campaign included Business Model Canvas, branding, execution plan, prototyping as well as financials.

­­­­Singapore Management University ( SMU ) Aug 2013 – Dec 2017

Bachelor of Business Management (Graduated in Dec 2017)

• Majoring in Marketing & Analytics

Neoma Business School, France (International Exchange Programme) Aug 2016 – Dec 2016

• Achieved distinction in International Marketing Strategy, Services Marketing, Web Marketing and Sustainable Development in a Global Economy