About Me
Experienced Data 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
Sales Performance Analysis using MySQL and Power BI
​
​
Power BI file ->
​
​
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.
​
​
​
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 file ->
​
​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.
​
​
EXPERIENCE
Programmer Analyst,
Cognizant Technology Solutions
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