Anmoldeep Singh Sahdev Email & Phone Number

Mississauga, Ontario, Canada

Mississauga, Ontario, Canada

• Continued development of Digital Service Portfolio (DSP) Finance Plan for upcoming Ricoh Canada fiscal years utilizing SQL and Microsoft Excel to mine and clean over $2 billion in financial data
• Performed comprehensive data cleaning and mining of Salesforce sales records for all Ricoh Canada’s campaigns for FY19-24 using Salesforce mining, Microsoft Excel’s dynamic array functions, and Power BI data.
• Designed and developed Power BI dashboard to present Marketing Accepted Leads (MALs), Sales Accepted Leads (SALs), Sales Qualified Leads (SQLs), and Won Leads from FY19-24 by incorporating stacked column charts and.

Mississauga, Ontario, Canada

• Developed Digital Service Portfolio's (DSP's) future fiscal year Business plans by mining and cleaning previous years' financial data using SQL and Microsoft Excel
• Analyzed and restructured the financial data to ensure alignment with the DSP data model to ensure organizational efficiency and decision-making capabilities by employing SQL
• Developed comprehensive statistical models to identify hidden sales trends, identify profitable customers, and empower stakeholder decisions by utilizing predictive and dynamic visuals in Power BI

Mississauga, Ontario, Canada

• Analyzed and Reported Return-on-Investment of Ricoh Canada’s sales for over 100 Ontario Hospital and Healthcare Service Providers using Power BI and Pivot Charts to highlight growth opportunities
• Constructed Digital Service Portfolio (DSP) dashboard on Power BI servers by leveraging SQL and Microsoft Excel sales data to facilitate accurate calculations and enhanced decision-making for branches in the US.
• Optimized Power BI reports to ensure synchronization with Salesforce data and MDM reports for consistent insights

Mississauga, Ontario, Canada

• Analyzed Ricoh Canada’s sales of over 150 MFPs using Pivot Charts to highlight growth in remanufacturing opportunities
• Managed a Canadian Indigenous Nations market research project leading to an increase in 20% sales opportunities by researching and collecting data on Indigenous bands with revenue $99 million and above
• Formulated 15 Indigenous nations’ Institutional Call Plans to create a business conversation knowledge base by evaluating investment opportunities, annual revenue, and key initiatives

Toronto, Ontario, Canada

• Collected and analyzed over 60 clients’ performance to boost campaign metrics by 25% using Periscope
• Increased impressions by 200,000+ and 2x the CTR by serving as HubSpot team lead by controlling pipeline activities, tracking analytics for over 100 clients, and providing analysis to improve client outreach
• Strengthened and formulated Excel spreadsheets by automating HVP project lists and constructing client prospect lists

New Delhi, Delhi, India

• Executed supply chain analytics that increased sales by INR 1 million for 250 Pharmaceutical clients by testing product implementation and inventory tools
• Improved company sales by 50% during the COVID-19 outbreak by efficiently utilizing Google Analytics for digital marketing, business development, and product designing strategies in the manufacturing industry
• Designed product inventory and labels to improve sales efficiency by effectively using Adobe editing tools

Honors Mathematics, Mathematics

High School Diploma, Computer Science, 91%

Activities and Societies: Astronomy Club, Theatre, Photography Club, Special Olympics Bharat