Post Job Free

Resume

Sign in

Power BI, data analysis, SQL, Macros

Location:
Waterloo, ON, Canada
Posted:
February 21, 2024

Contact this candidate

Resume:

RHYTHM KULSHRESHTHA

Waterloo, ON 226-***-**** ad3sx6@r.postjobfree.com LinkedIn Profile

PROFESSIONAL EXPERIENCE

FLANAGAN FOODSERVICE

Role: Data Visualization and Insights Analyst Location: Kitchener, ON Industry: Foodservice, Supply Chain Duration: Jan 2022 – Present Technologies: Power BI, Excel, PL/SQL, Power Automate, Oracle 12c, JDA Warehouse Management Responsibilities:

Utilized data analytics to design and develop interactive dashboards, providing insightful visualizations of key performance indicators (KPIs) and metrics to support data-driven decision making.

Imported and manipulated data to create data models using Power BI, enabling the creation of KPIs and scorecards to track and monitor business performance, while analyzing trends over time.

Designed and built reports with drill down functionality, enabling users to explore data in more detail and identify underlying factors driving trends and performance using data modeling in the query editor, table relationships, and DAX.

Conducted user training and provided ongoing support to ensure effective use of dashboards, reports, and models while maintaining data integrity and security by adhering to data governance policies and procedures.

Analyzed complex datasets, identifying key patterns and trends that led to a 15% increase in operational efficiency.

Continuously reviewed and improved data visualizations, dashboards, reports, and models to ensure accuracy, relevance, and usability, demonstrating a commitment to excellence in data-driven decision making.

Developed innovative data visualizations and dashboards using Power BI, providing actionable insights that contributed to a 10% boost in sales revenue.

CONDUENT

Role: Data Analyst Location: Noida, India

Industry: Defined Benefits, Mergers and Acquisitions Duration: July 2018 – Dec 2019 Technologies: SQL, SAP Analytics, Macros, Excel, MS Project, Tableau, HPQC Responsibilities:

Conducted in-depth data analysis, using advanced Excel functions such as V-Lookup, Pivot Tables, Pivot Charts, and Maps, to create compelling graphs, charts, and analysis that provided valuable insights into sales performance and opportunities.

Utilized advanced SQL techniques to extract and manipulate data, resulting in a 20% reduction in processing time for critical business reports.

Provided timely status reports to project stakeholders, highlighting module milestones and any changes to the schedule, facilitating effective communication and collaboration.

Designed reports considering client’s technical knowledge to make fast, easy and informed decisions. ALIGHT SOLUTIONS (Formerly Aon Hewitt)

Role: Senior Business Analyst Location: Noida, India Industry: Defined Benefits Duration: Feb 2016 – June 2018 Technologies: MSQuery, SQL, IBM Mainframe, IBM DB2, JIRA, Visio Responsibilities:

Created and maintained comprehensive module plans, outlining project goals, timelines, and milestones to ensure the timely completion of multiple modules.

Developed detailed timelines for each module, identifying critical paths and dependencies, to streamline project execution and increase efficiency.

Initiated and managed a knowledge-sharing initiative within the organization, conducting training sessions that improved the data analytics skills of team members, resulting in a 28% increase in data analysis efficiency across departments.

Delegated responsibilities to team members based on their strengths and skills, and regularly tracked their progress, providing support and guidance to ensure timely and successful module completion.

Demonstrated strong leadership skills, driving team cohesion and collaboration, while ensuring that all deliverables met or exceeded quality standards

SKILL SUMMARY

Programing & Database: MySQL, SPSS, Oracle 12c, SQL Server 2016, PL/SQL, MS Access Tools: Microsoft 365, Google Office Suite, JDA, Blue Yonder, Linux, HPQC, JIRA, MS-Excel, Share Point Visualization Tools: Power BI, Data Analysis Expressions (DAX), Tableau Desktop Machine Learning: Linear and Logistic Regression, Decision Tree, Time Series Analysis Certifications: Yellow Belt – Lean Six Sigma

EDUCATION

Supply Chain Management Post-Graduate Diploma - 2021 Project Management Post-Graduate Diploma – 2020

Information Technology Bachelor of Technology - 2016 PROJECT PORTFOLIO

Category Scorecard

Designed and implemented a dynamic Category Scorecard using Power BI, leveraging DAX to analyze raw data. Empowered Category Managers to compare KPIs across categories and against benchmarks, facilitating quick identification of improvement areas. Provided actionable insights to aid decision-making. For instance, revealing a 2.8% increase in distinct customers for entire Company versus a 2.4% decrease for Category. The tool doesn't replace internal reports but enhances Category Management's ability to improve outcomes.

Competitor and Region Report

Developed a robust CFR Report utilizing Power BI, offering a comprehensive performance overview. Enabled stakeholders to make informed decisions by drilling down into growth opportunities and identifying underperforming regions.

For instance, pinpointing competitors surpassing brand name ketchup in street sales or identifying customers under Sales Rep B who have discontinued purchasing canned olives. The report serves the Category Management Team, supplementing rather than replacing internal reports, for enhanced decision-making capabilities.

Vendor Fill Rate Dashboard

Engineered an Excel Vendor Fill Rate Dashboard empowering Category Managers to efficiently compare vendor fill rates. The tool facilitates accountability, enabling proactive discussions to uphold service level agreements. Through dynamic visuals and data-driven insights, the Category Management Team can effectively ensure vendor performance aligns with expectations. This Excel Dashboard complements existing internal reports without replacing them, streamlining vendor management for improved decision-making. Global Bike International

This academic project consisted of creating graphs, charts and providing analysis on how to improve sales of an international bike company by using raw data available. There was a heavy focus on V- Lookup, Pivot Tables, Pivot Charts, Maps, and using Excel functions to extract actionable information from available raw data.



Contact this candidate