Calvin Tan Email & Phone Number

Singapore

Singapore

IRIS concise is a management consulting firm (Part of IRIS Worldwide) that offers CRM solutions, data-driven insights and digital transformation to management teams at leading MNCsData-Driven marketing• Regional monthly reporting of EDM/PUSH campaigns for 6 product lines across 8 markets in APAC and generate actionable insights to optimize CRM strategy• Dealt with a massive database of more than 100M+, data extraction through Google BigQuery and SAP Hybris to facilitate deep dive analysis on sales conversions, targeting strategy, segmentation modeling, engagement behavior, multi-channel efforts, customer retention• Metrics measurement such as open rates, click through rates, contact frequency of different markets through email campaign product tagging and grouping• Identified manual repetition process in monthly reporting process, streamline the process into an automated program using python to run google BigQuery codes, successfully implemented the program to decrease human error and steps taken to achieve result to team members• Conduct SQL knowledge sharing session weekly to other team personnel who is keen in picking up SQL skillsetClient: Samsung

Singapore

Singapore

• Analyzed survey data from several different industry across APAC region, to ensure that anomalies within the data were investigated and resolved in a timely manner• Coordinated and created data cleaning and validation process with survey leaders to ensure data accuracy• Conducted statistical analysis using the cleaned dataset, and generate into individual position reports for remuneration benchmarking• Performed ad-hoc request for consultant using Excel and customized SQL queries to extract and format requested information• Investigated and resolved issues regarding the integrity of dataflow in database• Requirement gatherings, timeline management, and resource allocation for project with management group• Provided technical support on online delivery platform for consultant and client• Create User Acceptance Test (UAT) for system wide testing

Singapore

• Requirement gatherings of website design and layout from C-Level• Coordinate with marketing team on content management to be published on website• Mined data from multiple sources to produce report in MS Excel using advanced features (VLOOKUP, Index, Match etc.)• Performed ad-hoc request for consultant using Excel and customized SQL queries to extract and format requested information• Produced ad-hoc reports using advance Excel spreadsheet functions• Provided technical support for client’s account

Singapore

• Analyze buyer behavior and implement marketing technique to drive sales• Schedule staffs for their shift works, job scope allocation, and other daily operation task• Stock level management, promotion planning with suppliers, counter measurement for ageing stock• Lead a team of 6 in the store to achieve sales targets, maintain daily store operations, and neutralize dispute between customer and staff