Ketan Kaushal
Hyderabad
Summary
Data Analyst with over 6 years of experience in Retail Analysis, specializing in predictive and statistical analysis, Azure Databricks, Spark SQL, Power BI, and data automation. Proven track record in delivering key insights, optimizing data-driven processes, and developing advanced data models for business impact. Experienced in Power BI dashboards, DAX calculations, and automation solutions using Power Automate. Skilled in translating complex datasets into actionable strategies for business growth. Results-oriented Analyst skillful in managing and breaking down large volumes of information. Proactive at heading off issues in operations, workflow and production by uncovering trends affecting business success.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data Analytics Analyst II
Blue Yonder
05.2022 - Current
- Gathering requirements from stakeholders to understand and streamline requirements on document.
- Connect with multiple teams and tech teams to gather information on required tables.
- Perform ETL process on data and push it in our Azure Datalake for consumption in our Power BI reports.
- Use Spark SQL in Azure Databricks environment for Data cleaning and aggregation and analysis.
- Build data models for better efficiency of visuals and measure created.
- Build reports and publish it in production environment for our leadership use.
- Build automated alerts using Power Automate to alert business leaders for any specific goals.
Data Analyst
Amazon
07.2021 - 04.2022
- Gather requirements from stakeholders to understand requirements and data gathering.
- Worked on building and maintaining Daily, Weekly and Monthly reports for providing visual and statistical representation of data.
- Used QuickSight and Advance Excel for creating reports and charts.
- SQL for Data cleaning and aggregation and analysis.
- Built data pipelines and scheduled the same in AWS (S3 environment).
(Analyst) Product Development
Harman India
07.2019 - 07.2021
- Gather requirements from stakeholders to understand their needs
- Works on Data gathering, Data Cleaning and Modelling, and performing analyses
- Used MySQL, Excel for Data Extraction from various sources Power BI reporting for providing visual and statistical representation of data.
Analyst
VICE IT VENTURES
12.2017 - 05.2019
- Supported in handling database part of project
- Worked mainly involved data gathering, analyses and visualization part
- Interpret data and analyze results and provide ongoing reports.
Education
Bachelor in Technology, Computer Science Engineering - B.Tech (Computer Science)
L.P.U.
Jalandhar01.2018
H.S.C. -
K.V. 3, Delhi Cantt - 10
New Delhi05.2011
Skills
- SQL
- Power BI
- Azure Databricks
- Azure Datalake
- Power Automate
- ETL
- Predictive Analysis
- Statistical Analysis
Projects
Quality Metrics Dashboard, 05/2022, Present
- Responsibilities lies in extracting the data and consume the same for creating reports.
- Working with SQL queries on Databricks for the data extraction part.
- Perform data related functions including: analysis, cleansing and mapping.
- Databricks, SQL, Power BI, Advance Excel
Amazon Foods, 07/2021, 04/2022
- Responsibilities lies in extracting the data and consume the same for creating reports.
- Working with SQL queries for the data extraction part.
- Perform data related functions including: analysis, cleansing and mapping., SQL, AWS QuickSight, Advance Excel
IRI, 07/2019, 07/2021
- Performed reconciliation techniques like Auto & Smart for the models to perform data analysis and generating summary metrics of the data.
- Worked with SQL queries for data extraction part.
- Worked closely with internal teams to generate insights, solve problems and build dashboards.
- Communicated with stakeholders to make critical decisions., SQL, Power BI, Advance Excel
Personal Information
Title: Data Analyst
Certification
- MS Power BI Data Analyst Certification (June'24 - June'25)
Timeline
Data Analytics Analyst II
Blue Yonder
05.2022 - Current
Data Analyst
Amazon
07.2021 - 04.2022
(Analyst) Product Development
Harman India
07.2019 - 07.2021
Analyst
VICE IT VENTURES
12.2017 - 05.2019
Bachelor in Technology, Computer Science Engineering - B.Tech (Computer Science)
L.P.U.
H.S.C. -
K.V. 3, Delhi Cantt - 10
- MS Power BI Data Analyst Certification (June'24 - June'25)
Similar Profiles
Monica HochbergMonica Hochberg
Global GTM Talent Acquisition Lead | Sr. Recruiter at Blue YonderGlobal GTM Talent Acquisition Lead | Sr. Recruiter at Blue Yonder
Sandip TripathySandip Tripathy
Product Manager at Blue YonderProduct Manager at Blue Yonder
Kapil SuriKapil Suri
Sr Software Engineer at Blue YonderSr Software Engineer at Blue Yonder