Learn Data Skills
Beta
PRAVEENKUMAR Venkatesan

PRAVEENKUMAR Venkatesan

Data Analyst

Concordia University

Technologies

My Portfolio Highlights

My New Course

Introduction to Power BI

My New Workbook

Calculate Shifts, Percent Change, and Windows on Time Series

My New Track

Power BI Fundamentals

My New Course

Introduction to Power BI

Algorithmic visionary, building bridges between data and knowledge.

My Work

Take a look at my latest work.

course

Data Manipulation with pandas

course

Introduction to Power BI

DataLab

Calculate Shifts, Percent Change, and Windows on Time Series

course

Data Manipulation with pandas

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

Pratt & Whitney Canada | Sep 2023 - Present

Senior Data Analyst

N/A

Pratt & Whitney Canada | Jan 2023 - Sep 2023

Data Analyst

-- Extracting data from multiple sources, cleaning them and Designing visual metrics, reports, performance charts, and scorecards by using Microsoft Power BI to Support Customer Manager's business decisions -- Forecasted overdue orders by using Machine learning models (ARIMA, SARIMA, LSTM) so that the company can able to make strategic planning. -- Converting VBA code into python script to automate some manual process and avoiding human error -- Audit existing data to identify issues related to accuracy, completeness, and integrity. Interpret data issues to identify corrective actions for reporting practices.
Show More

Maison Battat Inc. | May 2022 - Dec 2022

Business Planning and Forecasting Analyst

-- Created the dashboards and reports (Monthly, Weekly) in Power BI which was used by the marketing team across all the countries. -- Developed Forecasting model which predict sales numbers for 12 brands and 800 SKUs which were worth of 25 Million USD. -- Perform ad-hoc analysis and share recommendations and insights about Sales, Inventory, Purchase Orders to the Stakeholders. -- Collaborating with the marketing team and sharing inputs about promoting products through AMS, and PPC. -- Working closely with VP and founder for strategy and new product launches.

Snapcommerce | Jan 2022 - Apr 2022

Supply Data Analyst Intern

-- Responsible for Creating Dashboards (Weekly, Monthly), alerts, reports in Looker, BI tool as per Business requirements (KPI). -- Clean, Organize and update the data into Pipedrive, CRM Software. -- Dive deep into the data to find out the root cause for trends and share them with the Manager to make data-driven decisions. -- Compare Supplier pricing with Google Benchmark price to make sure to onboard suppliers whose product prices are less. -- Used JIRA as a Workload Management tool and Confluence for documenting the project.

Amazon | Jul 2020 - Aug 2021

Catalog Associate

-- Worked in Purchase Quantity Variance team as a Catalogue Associate. -- Eliminated 10,000 unique defects by diving deep into purchase orders and invoices there by updating correct identifier in the Amazon catalogue. -- Improved one of the key operational goals (Repeat Rate) agreed to the stakeholder from 16% to 11% by implementing process improvement strategies. -- Worked in Piolet program and shared required data to the project lead in the timely manner -- Responsible for sharing Daily queue status to the Senior Managers

Urban Company | Sep 2019 - Apr 2020

Business Development Associate

-- Worked in all the category in Beauty and Wellness vertical. -- Responsible for Maintaining category End to End. -- Revamped Spa at home Category by improving the professional utilization from 23 to 35 and reduced the request loss from 23% to 6%. -- Improved the activity of the professionals in Spa at home category from 75% to 90% and reduced Fulfillment Bad Customer Experience from 4% to 2.5% -- Helped the category manager in making the Hub planning for every month.

My Education

Take a look at my formal education

Master's degree, Industrial EngineeringConcordia University | 2023
Bachelor of Engineering - BE, Aeronautics/Aviation/Aerospace Science and Technology, GeneralKumaraguru College of Technology | 2019

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free