Sales Data

Mohan Premachandra

**** **** ***** ****, **** ***, Toronto, M3A1Y6

Phone: 647-***-**** E-Mail: *****.****@*****.***

~ An experienced Category Analyst in CPG, Retail & E-Commerce Industry ~

PROFILE

Strong Market Research experience in CPG, E-Commerce and Retail Industry.

Strong experience in Data Mining, Data Analysis and insights

Experienced in working both independently and as a team.

SKILL SET

AC Nielsen (Analytics application)

IRI Syndicated Databases (Analytics application)

SQL/SAP Basic Overview

MS Office (Access, Excel & Power point)

PROFESSIONAL EXPERIENCE

RANK Technologies – Analytical Services

A global business intelligence and insights provider for organizations in CPG/Retail and Advertising and media sectors.

RANK Technologies (Analytics team) Bangalore, India. Dec 2016 – June 2017

Analyst

Create impactful reports/power point presentations that summarize key findings, trends and actionable insights to the business.

Extracting, preparing, and analyzing large data sets using in-house tools.

Worked on Adhoc Analysis like SWOT Analysis, Sales Decomposition Tree, Promotional Analysis, Volumetric Performance Analysis, New Item Product Trends, Marketing Mix Analysis (using 4Ps) and Pricing Trends.

Ensure accuracy of data to maintain the integrity of analytic reports.

Provide reports to the sales team on National, Regional and market level sales data.

Helped automate reports so that it takes lesser time to run and is error free.

Lead point of contact for data analysis and other analytical support for sales and marketing teams.

Trouble shoot issues reported by client on the tools.

GRAND&TOY – Office Supplies Industry

Grand & Toy is a leading provider of workplace products and solutions serving Canadian businesses.

GRAND&TOY (Merchandising & Operations) Toronto, Canada. August 2014 – Oct 2015

Category Analyst

Develop and maintain key performance reports (KPIs) for various levels of the organization.

Responsible for both recurring and adhoc deliverables

Analyze product and pricing competitiveness and liaise with the Category Manager and Inventory Manager to refine pricing tactic strategies and product assortment.

Managing multiple requests such as Category Review Support/Analytics, SKU rationalization, Promo effectiveness/Recommendations.

Creating monthly topline reports and presentations to deliver actionable insights to issues arising from short and long term business needs to optimize overall sales.

Created SOP’s to document all reporting instructions.

Comparing Categorical Analysis and measuring the share contribution with overall E-Commerce Market Share on Weekly basis.

Integrating mutiple internal data sources like Essbase, HFA & PCR Tool for Specific reports to import additional parameters to KPI reports.

GENPACT (Business Unit: IRI, US clients)

Genpact is a global leader in business process and technology management providing services in Sales and Marketing Analytics, IT and Finance. Here I worked for IRI – a US based Market Research company providing analytical services to Fortune Global 500 CPG, retail and healthcare companies.

GENPACT (IRI US Client Solutions GOC), Bangalore, India. March 2011 – August 2013

Senior Analyst

Research, analyze and report data on market content, using syndicated databases to provide solutions to clients in Consumer Packaged Goods and Retail Industry.

Prepared standard scorecard reports (assessment of sales performance, promotional performance and brand market shares) using multiple internal and syndicated data sources for marketing operations.

Was single point of contact for clients and was power user of IRI syndicated data.

Updated scorecard reports on monthly basis, or as required, and tracked progress.

Integrated and analyzed client data against competitor data on a monthly basis to measure sales efficiency.

During annual restatement performed data validation (review of database to fix inaccuracies and/or update product hierarchy) as per specs provided by client.

Helped clients transition reports from AC Nielsen to IRI analytical tool.

OTHER SKILLS

Strong Excel knowledge, Advanced Excel formulae – Vlookup, Count if, Sum if, Index, Match etc. Pivot tables and Charts for reporting and data analysis.

Inventory Analysis, Business Insights, Forecasting.

Have used Mintel reports, Hoovers alerts for insights.

Logical thinker and have the ability to analyze data.

Active team player and also competent individual contributor.

EDUCATION

Post Graduate Certificate program in Marketing Research & Analytics from Centennial College, Toronto, Canada.(2013-2014)

MBA Marketing from Bangalore University, India (2008 – 2010)

References available upon request

Contact this candidate