Amitoj Sidhu, Mba Email & Phone Number

Vancouver, British Columbia, Canada

• Spearheaded transition of team dashboards from Salesforce to Power BI by linking Salesforce withPower BI using historical data of ~20,000 accounts and ~5,000 cases• Developed multiple dashboards for the team summarizing the team’s performance metrics, providinga clear analysis of the team’s performance on a weekly and monthly basis• Worked closely with the Revenue Operations team to create, maintain, and automate multipleperiodic reports highlighting company’s operational and financial performance in Power BI• Performed data transformations and imports from various sources (often CSV and SQL) into thecompany’s product and handled escalated data processing cases• Worked with colleagues across different teams to develop processes around the design, development,and testing of data transformation, extraction, and training activities• Created automations to transform data received in multiple Excel files from clients, into oneconsolidated file at the click of a button, using Power Query and VBA, saving the team ~ 20 manhours, and enabling 50 percent quicker TAT for the client• Created a process flow using Power automate to send an email to the team when a case is created inSalesforce, minimizing cases getting missed by ~ 30 percent• Used Power Automate to create an automation to notify the team and download data files receivedfrom a client via email, and save it in the respective client’s files location

Vancouver, Canada Area

Project lead for teams of 4-6 consultants in a client facing environment.

Vancouver, British Columbia, Canada

Assisted non for profit clients in optimizing process and running day to day operations during COVID.

Worked on clients in cutting edge of technology and assisted them in market entry, mapping competitive landscape, and launching products.

Vancouver, Canada Area

• Worked on complex files and court orders to assess the eligibility of the taxpayers’ claims.• Updated registry information on taxpayers’ accounts as per the court orders or the agreement to assist in assessing future claims.• Reviewed the work to junior reviewers to assess the accuracy of their work.• Contacted taxpayers and representatives via written correspondence and requesting information to assess the validity of the claims.• Assessed the validity of claims and made necessary adjustments based on information submitted.

Surrey

• Liaise with manufacturers on reputed trade websites for purchasing hardware directly from manufacturers instead of local wholesalers. This reduced the company’s hardware costs by 40%.• Spearheaded efforts to change workflow with existing vendors; suggested them to supply partly finished products which reduced the manufacturing time and reduced the raw materials’ cost by 20%.• Established new inventory management system, using the existing in-house software to track product consumption more accurately. The new system imported historical data to facilitate trend identification and reduced the backorder levels by 20% in less than 3 months.• Coordinated with existing supplier to develop new packaging for products to reduce damages during shipping. Analyzed the most frequent parts damaged and ordered packaging with thicker corners and edges. New packaging reduced the damages by 50%.

Surrey, Canada

• Negotiated long-term synergistic contracts with suppliers to reduce costs, to reduce the costs by 10%.• Developed Excel spreadsheets to capture sales data (pricing, volume, promotions) and structured them into relevant reports, cross tabs, and graphs that facilitated trend identification and improved decision making.

Master Of Business Administration - Mba, 3.9

Activities and Societies: Represented Sauder School of Business at for Portfolio Case Competition at Yale School of Management. and Global.

Economic Analysis Of High Tech Industries, Honors

Worked with MBAs to analyze the economic concepts and frameworks of high tech industries. Developed insights on the effects of market.

Certificate In Data Science And Big Data Analytics, Data Science And Machine Learning, 100%

• Mastered techniques such as clustering, classification, and PCA which aids in converting raw data into predictive models/graphs. •.

Bachelor’S Degree, Science

• Concentrated in Biological Science • Relevant Coursework: Advanced Statistics, Experimental Techniques, Biotechnology

Associate’S Degree, Science

• Gained knowledge in Calculus, Biology, Physics and other science courses at intermediate level