A result oriented analyst with progressive roles. Broad analytical and computer expertise gained from IT, media, healthcare, payroll services, entertainment and aerospace industries. Expertise in: reporting, budgeting, forecasting, planning, calculating commission, managing leases, preparing financial reports, screening rebate and price protection. Key strengths: SQL, data mining, financial tracking, problem solving, and multi-tasking. Skilled: data integrity, consolidating financial data, customizing management report structures.
-
Sales Analytics AnalystAddictive Mobility Jun 2017 - Dec 2017Toronto, Canada AreaResponsible for extracting top line sales revenue and pricing data from Netsuite and other mobile ad-tech platforms to perform in-depth analysis on sales revenue, performance, territories, productivity, budget, forecast and KPI. As well, to create baseline for operational changes and actions to increase overall sales productivity• Created and delivered sales report for weekly, monthly and YTD sales revenue of each sales rep. key takeaways i.e. variances, revenue, pipelines, holding companies & agencies campaigns analysis.• Created monthly sales report to summarize monthly, quarterly and YTD business performance & results.• Produced daily reporting deliverables i.e. speedometer, KPI, dashboard, matrices to check health of the business, and to provide recommendations to senior management if sales were on track to meet budget.• Made pricing adjustments, recommendations and scenario analysis on different products and services in order to maximize revenues and optimize resources.• Analyzed media spending patterns by holding companies, agencies and brands. Investigated root cause of campaigns when spending patterns consisted of huge variances.• Paced sales revenue by reassigned sales territories when were not actively pursued.• Assisted annual budget process by analyzing previous revenue, territories and agencies performance. • Assisted media forecast and Request for Proposal (RFPs) of the likelihood if deals would go through.• Analyzed sales reps activities (i.e. phone calls, meetings, time ins/outs etc) to determine if their effort was justifiable against the revenue generated.
-
Crm AnalystMedcan Health Management Nov 2014 - Nov 2016Toronto, Canada AreaResponsible for analyzing, researching and providing medical data and other KPI insights by extracting them from Microsoft SQL server. These included identified trends, setup sales dashboard and advance data analysis in order to provide and assist strategies and operations direction of the company.• Managed and delivered data required for marketing and sales campaigns, which included developing and testing target strategies, creating hypothesis and making recommendations. • Disseminated metrics for overall client base engagement and strategic business initiatives.• Assisted the Sales teams to identify patient medical conditions for future business opportunities. • Assisted Finance to analyze patient feedback for physician performance compensation.• Sent and collected monthly newsletter and weekly A/B testing marketing campaign statistics for B2B and B2C from Salesforce (Pardot), Mailchimp and Google Analytics. Analyzed the segmentation results in Tableau (i.e. delivery rate, open rate, click rate, bounce rate, unsubscribe rate, sent time etc).• Designed and ran various patient satisfaction surveys that complied with CASL and DNC rules via Survey Monkey after their clinic visits. Collected and analyzed results, then calculated the Net Promoter Scores (NPS) for team leaders to follow-up with the patient clinical experience
-
Analyst, Sales And FinanceAutomatic Data Processing (Adp) Jan 2010 - Nov 2014Toronto, Canada AreaResponsible for reporting approximately $50M annual revenue. Managed about $5.5M annual commission payment for the entire Canadian sales force of about 300 sales associates• Developed analysis models, reported metrics, KPI and delivered reports on a weekly, monthly, quarterly and annual basis for senior executive teams• Analyzed and integrated sales data and compensation payments by segment and region to facilitate product and strategic planning development. • Supported Financial Planning &Analysis, Sales Operations/Audit, Global Compensation and other functional groups to finalize annual sales commission and compensation plans• Forecasted monthly commission payments and provided data to Accounting department.• Reviewed and linked compensation plans to the correct sales roles and groups.• Managed and maintained the overall Canadian monthly commission process in Oracle I.e. created/terminated of sales personnel, monitored sales numbers, uploaded quota, commission tiers, bonuses, sales incentives, contests, gift cards etc.
-
Senior Planning AnalystCineplex Entertainment Jan 2006 - Sep 2009Responsible for planning about $900M annual corporate budgets and 130 theatre budgets. Responsible for reporting approximately $13M of weekly box office and $4M weekly concession revenue.• Prepared annual budget and forecast templates by retrieving 5-year of historical data. Consolidated budget and forecast data, compiled cash flow statements and calendarized P&L for senior executives, regional directors and board members for approval.• Uploaded annual budget into PeopleSoft. Downloaded to cross-check the accuracy of data allocation by regions, entities, and Head Office departments.• Prepared data for quarterly strategic planning meetings and monthly budget package. • Reconciled, analyzed and explained the YoY, MoM and prior year actual vs. budget variances.• Assisted Operation and Business Development groups with new theatre construction and closure proposals by reviewing the performance as compared to budgets.
Andre Chen Education Details
-
Graduate Centre Of Applied TechnologyApplied Information Technology -
Memorial University Of NewfoundlandFinance
Frequently Asked Questions about Andre Chen
What is Andre Chen's role at the current company?
Andre Chen's current role is Andre Chen.
What schools did Andre Chen attend?
Andre Chen attended Graduate Centre Of Applied Technology, Memorial University Of Newfoundland.
Not the Andre Chen you were looking for?
-
-
Andre Chen
Canada -
-
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial