Karandeep Singh
Senior Advisor - GTM
Gurgaon,HR
Summary
Prudent Business Intelligence Advisor with 15 years providing various teams with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keen support business growth by leveraging intelligence assets to predict and reveal optimal business strategies. Exceptional communicator, relationship builder and portfolio manager for clients with varying wishes. Become an asset for the organization by truly depicting professionalism in all areas of work.
Overview
3
3
Certifications
8
8
years of post-secondary education
13
13
years of professional experience
Work History
Senior Advisor - GTM
Dell EMC
Gurgaon, Haryana
12.2020 - Current
- APJ Lead for Go To Market division (Part of Finance Team) within Consumer & Small Business segment - Dell.
- Responsible for global head count analysis for 17 countries and Global Productivity Scorecard. Working on Power BI, SQL, Excel & Tableau server for multiple reports ,scorecards and analysis.
- Analyzing performance for APJ Sales team compared to Outlook and AOP plan
Sales Operations Sr. Advisor
Dell EMC
Gurgaon, Haryana
07.2018 - 11.2020
- Completed Global & Country/Region Level CSB Scorecard automation – now QoE Scorecard being handled by GBO Org.
- Developed Global CSB Retail WSI Scorecard & data collation automation process using Power BI & Excel VBA.
- Developed GBS Global Scorecard 1.0 & 2.0 in Excel & Power BI respectively showing Halo KPIs.
- Developed and automated Global Backlog Outlook Report for CSB.
- Automated Global AR Report with Country & Segment level views for CSB.
- Various analysis and data visualization projects to support Global Sales teams within Consumer & Small business segment.
Product Marketing Advisor
Dell EMC
Gurgaon, Haryana
08.2015 - 06.2018
- SPIFF management for North America – includes SPIFF plan finalization, target setting, roll out and ensure timely & accurate report by SPIFF reporting team.
- Business Planning lead for NA – includes Channel level URM target setting for each Channel and finalizing EOQ Inventory goal (Forecast, WK06 & 10 OL).
- Global Executive Dashboard for SLT and Finance controllers.
- Customer Level Analysis for US & EMEA business – Offline & Online Customer trends based on LOBs and Segment, QoQ & YoY.
- LOB Level Analysis dashboard/report in Power BI for all Regions.
- Top Configuration Level Phasing Report for NA to check pricing efficiency.
- NA & EMEA dashboards & reports in Power BI for Sales, Marketing and Ops team.
Sales Support Sr. Analyst
DELL EMC
Gurgaon, Haryana
06.2013 - 07.2015
- Working on backward and forward looking/forecast analysis.
- Helping Sales & Marketing team with weekly Review Deck which included Sales, Inventory & Receipts.
- Help Leadership team with Operational Review Decks for SLT which helped in dropping product Inventory by 10% QoQ.
- Reporting Sales Channel wise performance based on forecast for each channel resulting in 15% revenue growth YoY.
- Developed Bidding Model in Excel using VBA.
- Developed BI dashboard for visualization, using Excel & VBA for US business.
Business Support Analyst
Dell International Services
Mohali, Punjab
12.2010 - 06.2013
- Prepared Operations Review Deck for US, Canada and Enterprise level.
- Prepared Entity Review deck for inbound teams in US Care segment.
- Handled SMS Project in US Customer Care segment.
- Performed weekly Root cause analysis for dissatisfied customers based on CX scrubs.
Advanced Resolution Expert
Dell International Services
Mohali, Punjab
12.2007 - 11.2010
- Responsible for Customer care related queries on Chat queue.
- Developed agent performance reports including Halo KPIs
Education
MBA - International Business
03.2011 - 03.2013
Bachelor of Arts - Fine Arts
05.2001 - 06.2005
High School Diploma -
04.2000 - 03.2001
High School Diploma -
04.1997 - 03.1998
Skills
Microsoft Excel
SQL
Power BI
Tableau
Excel VBA
Business Development
Business Intelligence Analysis
Consultancy and advisory
Database Management
Data Analysis Tool Design
Reading books
I am into reading self development books like The Code of Extraordinary mind, Ego is the Enemy, Principles, Atomic Habits etc
Certification
Learing Excel 2016 - LinkedIn Learning
Timeline
Senior Advisor - GTM - Dell EMC
12.2020 - Current
Learing Excel 2016 - LinkedIn Learning
10-2019
HTML Essential Training (2017) - LinkedIn Learning
10-2018
Sales Operations Sr. Advisor - Dell EMC
07.2018 - 11.2020
Product Marketing Advisor - Dell EMC
08.2015 - 06.2018
Sales Support Sr. Analyst - DELL EMC
06.2013 - 07.2015
VBA Essentials - Chandoo.org
06-2012
Vinayaka Missions University (VMU) - MBA, International Business
03.2011 - 03.2013
Business Support Analyst - Dell International Services
12.2010 - 06.2013
Advanced Resolution Expert - Dell International Services
12.2007 - 11.2010
Institute Of Advanced Studies In Education - Bachelor of Arts, Fine Arts
05.2001 - 06.2005
S.D. Public School - High School Diploma,
04.2000 - 03.2001
Guru Nanak Public School - High School Diploma,
04.1997 - 03.1998