Avinash Dudani 🏎

Business Intelligence Analyst and Data Engineering Enthusiast

Hello World! 🌎

🎯 Avinash is a Data analyst, Data Engineering Enthusiast an advocate of life long learning.
🏄‍♂️ He provides consulting services to clients and believes in adding value and contributing to the community. 💬 In his free time, provides solutions on the Microsoft Fabric Community. and is a Fabric Superuser as a bi-product.

Technical Skills:

Work Experience

**Data Analyst @ Canadian Forces Morales and Welfare Services (July 2022 - Present)**

Procurement Consultant @ KLB Group (September 2021 - June 2022)

• Collaborate with stakeholders. Gather business objectives. Translate requirements into user stories using Visio.
• Extract and gather data from multiple sources using T-SQL. Data transformation using DAX and Power Query. • Process Automation using a conjunction of cloud services and connectors such as Power Automate, Sharepoint and PowerApps.

**Inventory Coordinator @ Marche GoodFood (December 2020 - August 2021)**

• Fulfilled Kanban requests of over 200+ SKUs, promoting customer-centricity and order fulfillment.
• Maintained the ERP accuracy of 500+ locations, ensuring food integrity through FEFO adherence using Microsoft Dynamics 365.
• Automated inventory reports and dashboards in Excel using advanced Excel functions, Power Query M and Power Pivot .

Education

Master's in Industrial Engineering | Concordia University (March 2022)

Bachelor of Technology : Mechanical Engingeering | Vellore Institute of Technology (July 2018)

Certifications

📪 Contact me via: LinkedIn

Avinash Dudani's Projects

adventure-works-sales-analysis

Problem Statements: Analyze historical sales and profit and territory. Identify bestselling products and attributed customers and regions. Forecast revenue for the next 7 periods. Execute pricing scenario analysis to understand increase in product cost.

airbnb_listinganalysis

Problem Statement: Imagine you/ a group of friends are going on a trip to Amsterdam and plan on renting out an Airbnb. You are looking for the best listings with positive reviews and a low average price per person.

avixd

Config files for my GitHub profile.

calendartable_with_dax

Code samples of a calendar table using DAX

excelautomation_powerautomatedesktopworkflow

Use case: A portable and automated workflow, to be run on demand. Functionalities: Workflow extracted and read data from a given SQL server instance. Prompt input for location of Excel file to write on. Segmentation and aggregations, given conditions. Ran a developed macro in VBA, verifying the workflow output.

financialstatement

Custom Balance Sheet for Budgeting

multiplelinearregressioninpython

Multiple linear regression to predict Profit based on Administration spend, Marketing spends, R&D spend and State. Also, understand the trend and correlation.