Data Analyst Sales

Sugam Shrestha

Denver, CO 347-***-**** **********@*****.***

Seeking Job as Data Analyst and Demand Planner with over seven years’ experience in the Data Analyst, Requirement Gathering, Financial & Demand planner in multinational consumer goods.

Professional Experience

Unilever Limited — Nepal/Singapore

Assistant Manager Demand Planning/ Data Analyst May 2015 – Jul 2019

Worked closely with the project management team to analyze and consolidate request requirements to improve the decision planning process and meeting project deadlines.

Defined data requirements and report layouts at various levels and brands for business to review.

Lead sales and operating plan meeting on long term and short terms plans related to demand, supply, capacity requirement, NMSCC, SLOB, etc.

Review historical sales and promotional data at all hierarchy of brands to identify right trends, patterns, outliners for forecasting future sales.

Interact with cross functional teams to understand the data requirements, demand drivers, promotional schemes and share the actual data in their required layouts.

Conduct and lead business plan meetings with various stakeholders and highlight the data insights on periodic business cycles.

Close monthly business sales plan with stakeholders and communicate final plan to cross functional teams.

Determine project scope and deliverables in accordance with the user supplied requirements while keeping in mind the senior management business strategies Preparation of Business Requirement Document (BRD's) on various new and enhancement projects Worked extensively with SMEs in understanding and documenting their requirements.

Used Business Intelligence Reporting Tool to create KPIs and Scorecards to improve corporate profitability measures and comparative financial analysis

Category Commercial and Finance Officer Apr 2012 – May 2015

Finalized a rolling five-year strategic plan for the business based on analysis of business drivers and forecasts of growth and brand profitability.

Informed pricing and trade promotion decisions as well as brand and marketing investments across the company by providing detailed financial analysis.

Monitored trade and financial working capital to ensure proper fund application, comparing expenses against the budget and completing monthly financial statements to track spending.

Conducted periodic cash forecasting to identify changing financing needs across the business.

Evaluated capital proposals for important projects using effective financial models.

Implemented cost-saving measures to facilitate growth and improve margins.

Reviewed the financial viability of existing and new product launches and re-launches.

Oversee creation of demand forecasts for supply procurement and distribution, liaising with sales channel managers, financial teams, and other business leaders for impactful management.

Facilitate development of demand management systems and continuous improvement initiatives.

Generate business cases related to consumer promotions to inform decisions and evaluate return on investments.

Analyze sales tracker results against plans to determine results and influence future changes.

Supervise price change program and evaluate its impact on profitability.

Education

Master’s in Information Technology Project Management, Wilmington University, USA. 2020 GPA: 3.98/4.0

MBA in Finance, Kathmandu University School of Management, Nepal. 2012 GPA: 3.7/4.0

SKILLS

Data Analyst Project Scheduling Microsoft Excel Data management Project Quality Management SQL Continuous Improvement Supply Chain Optimization Microsoft Project Analysis, Modeling, and Design Project and Change Management Project Scope Development and Management Demand Planning Forecasting

Contact this candidate