About Me
Experienced Business Analyst with a strong Information Technology background. Proficient in data analysis tools such as Excel, SQL, R, and Python. Advanced skills in analytics and visualization tools like QlikView, Qlik Sense, Power BI, and Tableau. Proven ability to excel in fast-paced environments, handling multiple priorities. Strategic thinker leveraging data-driven insights for planning and delivering impactful C-suite presentations. Holds a Master of Management with a specialization in Business Data Analytics, demonstrating a driven and analytical mindset.
EDUCATION
2022-2023
Master of Management
University of Windsor
-
GPA: 88%. 2nd Place for the National Bank of Canada Case competition
-
Courses: Accounting, Finance, Predictive Modeling, Data Acquisition & Management
2016-2020
Bachelor of Technology
UPES, Dehradun
-
Bachelors degree in Applied Petroleum Engineering
-
Courses: Courses: Java, C Programming, Statistics, Thermodynamics, Fluid Mechanics
MY SKILLSET
SQL
80%
PYTHON
75%
POWER BI
95%
R
90%
EXCEL
85%
Portfolio of Projects
Model to Predict Salary of graduates from Universities in FT 100
Tools - R studio and Excel
R codes ->
Description
I compiled the last decade's university rankings from the Financial Times Top 100 into an Excel sheet. Subsequently, I created a predictive model using linear regression to estimate the weighted salary of graduates from leading business schools worldwide. This approach aimed to enhance insights into the potential earning trajectories of graduates based on historical ranking data.
HR Analytics dashboard in Power BI
Power BI Dashboard ->
Description
I implemented ETL to move sales data from MySQL to Power BI, handling datasets from 10 GB to 100 GB. I created a robust data model for detailed sales analysis and used Power BI for clear and interactive visuals, making it easy for stakeholders to understand and explore sales trends.
Sales Performance Analysis using MySQL and Power BI
Power BI Dashboard ->
Description
Implemented ETL processes to transfer sales data from MySQL to Power BI, managing datasets of 10 GB to 100 GB for efficient analytics. Developed a strong data model for in-depth sales analysis and utilized Power BI for dynamic visualizations, enabling effective exploration of sales trends by stakeholders.
EXPERIENCE
Business Data Analyst,
Canadian Tire
Sep 2024 – Present
-
Developed and conducted a/b testing on Power BI dashboards for monitoring and tracking of the key Supply chain KPI metrics such as on-time delivery, inventory levels, and shipping costs.
-
Automated the report generation by developing Python codes and query processing in Microsoft Access databases for process improvements in tracking retail data.
-
Streamlined data extraction and operational task automation using SQL queries and DAX codes, reducing the reporting time by 30%.
-
Improved reporting efficiency by building custom metrics and Key Performance Indicators using advanced DAX calculations, reducing reporting turnaround time from 5 days to 2 days.
-
Improved database performance by query optimization techniques, reducing query execution time by 40% and enhancing the database performance.
Inventory Data Analyst,
Rogers Communications
July 2024 – Aug 2024
-
Performed exploratory data analysis (EDA) and data preparation, including handling missing values, to uncover trends and improve the accuracy of inventory forecasts worth $3.5 million.
-
Coordinated with suppliers and contractors to guarantee timely delivery of materials and manage the scheduling of returns and storage in the operational systems.
-
Performed comprehensive checks and assessments on predictive models before deployment, ensuring accuracy and efficiency.
Data Analyst,
Philips India
Sep 2020 – Aug 2022
-
Integrated 3rd party shipment data with QlikView and Qlik Sense, reducing processing time by 20% through advanced visualization and analytics techniques.
-
Performed ETL, filtering, aggregation, data cleaning, and pre-processing on raw data using Python and MS SQL (SSIS, SSMS) to generate datasets for conducting analysis.
-
Used Excel (VBA and Macros) to generate ad-hoc MIS reports, visualizations for analysing and interpreting financial data(working capital, cash flow, revenue per employee etc.).
-
Collaborated with developers in an agile environment to deploy applications in the production environment, ensuring seamless integration and functionality.
-
Utilized Power BI and Tableau for dynamic visualization, transforming complex datasets into insightful visual reports that showcased prominent trends in the KPI’s.
CONTACT
Thank you for visiting my website. If you have any queries or would like to discuss a potential project, please feel free to get in touch using the information below.
Email: shivanshus2024@outlook.com
Phone: +1-905-782-0653