Power BI
ISH KHURANA
Sales Analyst
Pune,Maharashtra
Summary
Results-driven Sales Analyst offering 12 years of experience analyzing and reporting on sales data. Well-organized and systematic professional well-versed in creating forecasts for future sales trends and informing and suggesting ways to improve profitability. In-depth knowledge of current economic trends, SWOT analysis and Analytical tools. Ambitious individual committed to implementing business solutions to boost profitability and productivity.
Overview
14
14
years of professional experience
8
8
years of post-secondary education
3
3
Languages
Work History
Sales Analyst
Hansgrohe India Pvt. Ltd.
Pune
03.2020 - Current
- Handling Sales reporting and analytics team.
- Responsible for sales forecasting techniques and strategic planning to verify sales and profitability of products, lines and services.
- Gathered, organized and analyzed data, resolved discrepancies and modeled information.
- Developed accurate sales forecasts by analyzing sales feedback and wrote reports for senior leadership.
- Generates bar graphs, trend lines and pie charts to represent sales data to management.
- Developed tools and processes to help improve operational efficiency and enhance sales team productivity.
- Sales CRM Training to Sales Employees.
- Responsible for Digital projects for the organization.
Sales Analyst
Viega India Pvt. Ltd
Gurugram
09.2018 - 02.2020
- Generating Monthly Business reports and dashboards
- Assisting VP Sales & Marketing for Sales Budget Planning and Forecasting
- Tracking secondary Sales and Indirect dealer sales tracking
- Sales Staff Incentive calculation
- Dealer Rebate calculation and monthly performance tracking
- Tracking trade schemes performance
- Working closely with Finance, Legal and Marketing and other teams for organization success
- CRM Reports & Analysis
- Analyzing Business Funnel via CRM
- Publishing CRM Reports to Sales staff and management
- Tracking competition activities by collecting data from Sales Team and other sources
- Sales reporting process standardization with the help of relevant departments
- Sales Staff Training - Providing CRM training to sales staff
- Providing Excel and PowerPoint training to sales staff.
Deputy Manager
Max Life Insurance Company Limited
Gurugram
11.2016 - 09.2018
- Compensation Calculations of Sales Distribution Basis their Performance - Ensures accuracy and timeliness of reports/extracts
- Data collation in the required formats from IT extracts and other sources i.e.different departments
- Calculates the incentive per scheme
- Automation of reports to enhance team productivity
- Provide incentive summaries/trends and other reports to management (or internal customers)
- Coordination with cross functions like BPMA team, HR Team, etc
- For smooth running of inflow & outflow of data
- Provide MIS support for new initiatives
- Query Handling and Exception Management - Examine/research issues and respond to queries accordingly
- Adherence to TAT & ensure customer centricity
- Proper tracking of Exception and closure post coordination with different team
- Data Analysis & Automation - Qualitative analysis on the variances - Provide quality & incentive trend analysis for management decision-making
- Simulations for new schemes setups - Suggest corrective measures/new means to manage outages
- Handle Ad-hoc analysis requirements for the senior management team
- Support for launch of MIS automation system on as required basis
- Compliance and Audit - Compliance of Incentive Scheme provided by HR for all bonuses - Maintaining the Process Notes & get it approved from relevant authorities - Documentation of Schemes, Plans & agreements - Process Standardization.
Senior Executive
Jade eServices Pvt Ltd (Jabong.com)
Gurugram
10.2014 - 11.2016
- Budget Planning and Data Analysis - Planning Company and Purchase level Seasonal Budget based out of Past Trend, Gross & Net
- Margins, Discounts and Inventory Cover
- Compiling Seasonal Budget on Category & Brand level planned based on OTB with Category manager / planner
- Responsible to analyze data for providing actionable insights to the Management
- Analyze trends of multiple factors like (Revenue, Margin, Discounts, Inventory coverand etc.) to increase sales
- Monthly Stock Analysis based on Ageing and Stock Cover
- Daily Website Pricing Analysis (Negative Margin, Discount on New Stock & Non Discounted old Ageing Stock Report)
- Reporting and Adhocs - Closely monitor all categories Budget vs
- Actuals in all terms
- Working on Business Dashboard (having multiple parameters) for Management
- Tracks PO Issued vs
- Stocks Inward
- Publish Season Sell through Performance report of the season
- Coordination with Category team for liquidating the old Stock
- Support on ad hoc data and dashboard requirements
- Automation to enhance team performance - Developed a tool for Monitoring Sell through Performance weekly
- Developed a tool for deriving Company level Sales and Margin Budget
- Developed and update PO tool by weekly.
Executive
Kohler India Corporation Pvt. Ltd, MIS
Gurugram
11.2012 - 10.2014
- Data Interpretation and Management (Routine) like Weekly Reports/ Monday Reports,
- Monthly Reports, Daily Reports
- Tracking primary / secondary sales / days of stock
- Generating Sales Dashboard and presentations for management to review Regional Team
- Assisting the Head Sales for Annual Sales budget
- Analyzing forecast & coordinating with logistics manager / planner
- Tracking the success rate of various Trade Schemes
- Calculate the Annual Dealer Sales Rebate
- Incentive Calculations for PAN India Sales Team
- Check and process the documents for the new outlet opening
- Co-ordination with Marketing Team for timely store opening
- Supporting PAN India sales team with desired reports and data as required
- Coordination with regional MIS coordinators for Reports / MIS / Trade Marketing reports
- Worked with various Teams like Marketing, Supply Chain and Finance on special projects.
Sales MIS Coordinator
Kelly Services India Pvt. Ltd. (Kohler)
Gurugram
04.2011 - 11.2012
- Tracking daily sales and create helpful reports for the sales team
- Tracking pending shipment and pending payments
- Coordinating with Sales Team to get Annual Sales Plan - Compiling pricing quotation given to sales team by Finance
- Updating Monthly Sales Mapping data to the database
- Checking and processing the documents for opening the new Outlets
- Working and Tracking on Dealer Sales Rebate - Supporting PAN India sales team with desired reports and data.
Sales Trainee
Citibank, NRI Banking
Gurugram
05.2010 - 04.2011
- Calling to the clients for confirmation of NRE & NRO A/C opening
- Completing the documentation for new A/C opening
- Coordinating with Operations team to Process the A/C opening forms
- Publishing Sales report
- Supporting to NR Sales Team with desired reports and data.
Education
Diploma in Software Engineering -
NIIT
Delhi 07.2006 - 03.2009
Bachelor of Arts - Economics
Nandini Nagar Mahavidyalaya
Nawabganj, Gonda 07.2006 - 03.2009
XII - Fine Arts
Sri Gandhi Vidyalaya Inter College (U.P Board)
Nawabganj, Gonda 07.2004 - 03.2006
High School Diploma -
J.H.M.H.S. School
Nawabganj, Gonda 07.2003 - 03.2004
Senior Management Programme -
Indian Institute of Management
Nagpur 04.2023 - Current
Skills
Data Analytics, Data Modeling, Reporting skills, Quantitative analysis, ROI familiarity, Sales Planning, Multitasking Abilities, Forecast tracking, Understanding of Digital Transformation, Team Building
undefinedSoftware
SAP Analytical Cloud
SAP SD
MS Excel
MS Power Point
MS SQL
MS Access
VBA Macro
MS Power Query
Power BI
Interests
Data Analytics
Sales Planning
Sales Reporting
Digital Development
Data Modelling
Business Intelligence
Hobbies
Research on work-related activities, Travelling at new places, Photography and Cooking.
Timeline
Senior Management Programme -
Indian Institute of Management
04.2023 - Current
Sales Analyst
Hansgrohe India Pvt. Ltd.
03.2020 - Current
Sales Analyst
Viega India Pvt. Ltd
09.2018 - 02.2020
Deputy Manager
Max Life Insurance Company Limited
11.2016 - 09.2018
Senior Executive
Jade eServices Pvt Ltd (Jabong.com)
10.2014 - 11.2016
Executive
Kohler India Corporation Pvt. Ltd, MIS
11.2012 - 10.2014
Sales MIS Coordinator
Kelly Services India Pvt. Ltd. (Kohler)
04.2011 - 11.2012
Sales Trainee
Citibank, NRI Banking
05.2010 - 04.2011
Diploma in Software Engineering -
NIIT
07.2006 - 03.2009
Bachelor of Arts - Economics
Nandini Nagar Mahavidyalaya
07.2006 - 03.2009
XII - Fine Arts
Sri Gandhi Vidyalaya Inter College (U.P Board)
07.2004 - 03.2006
High School Diploma -
J.H.M.H.S. School
07.2003 - 03.2004
Similar Profiles
Priyanka ThakarPriyanka Thakar
Assistant Manager Admin and HR at Hansgrohe India Pvt. LtdAssistant Manager Admin and HR at Hansgrohe India Pvt. Ltd
Ethan PhillipsEthan Phillips
Sales development manager at HansgroheSales development manager at Hansgrohe
ALBY MOL SEBASTIANALBY MOL SEBASTIAN
Business Development Manager at HansgroheBusiness Development Manager at Hansgrohe
Pratik JainPratik Jain
Packaged App Development Senior Analyst at AccenturePackaged App Development Senior Analyst at Accenture
Bhushan PatilBhushan Patil
MS SQL/ETL Developer at Shradha AI Technologies LtdMS SQL/ETL Developer at Shradha AI Technologies Ltd