Karan Rawat

• 2.5+ years experienced professional along with 1.8 years of relevant experience in Data Analytics.
• Experience in the SQL, Tableau , Alteryx and Advance Excel with industry project applications.
• Expert in SQL Server Management Studio (SSMS),Tableau and Alteryx . Created some of the complex data transformations logics, end to end processing and expert in Data Visualization.
• Novice level knowledge in Python.
• Trained on ETL methodology for supporting data extraction, transformation and loading processing.

• Alteryx - 2022
• Tableau- 2022
• SQL Server Management Studio - 2022
• Advance Excel - 2021

1)  Project Title : HR Analytics- Attrition Model

Enviroment : Python,Tableau, Sql

This is an internal project to BOA , where we had to standardise the HR data received every month in different files and upload in the Tableau dashboard. Also some ad hoc analysis were done as part of this project using Python, like predicting attrition in certain client accounts, understating the misuse of Work from home policy etc.

Roles and Responsibilities:

• Design a dashboard using Tableau from the HR data processed Via Python.
• Automate the process of data preparation using Python that will take the input data in different files and output in one csv to be uploaded in Tableau
• Design an Attrition model and incorporate the outcome in Tableau.
• Validate the model using test – train split.
• Maintain the historical data and design incremental load strategy.
• Mask the sensitive data and perform the ad- hoc analysis

2)  Project Title : India retail sector Growth forecast

Domain : Retail Sector

Project Details

Major Responsibilities

My major responsibility was   to perform Descriptive analytics and data preparing for modelling team

• Assisted meddling team in writing codes in Python for an   Arimax model on Macro economic factors like GDP, Consumer Confidence Index,   House hold savings, real disposable incomes, Unemployment rate to forecast   the growth rate for retail sector in eleven countries, using Oxford economics   data.

• Model validations, outlier detections, data preparation for   Tableau etc.

Environment :

Python , ARIMAX time series forecasting model,   Tableau dashboard

3)  Project Title: Order to cash dashboard

This project is Retail Project; it contains two phases for data management and dashboard design. In the first phase we had to process the historical data of 3yrs and make different transformations on it as requested by client. Then in second phase we had to design the Tableau dashboard on the processed data. There was also some basic regression model build in SAS based on the processed data.

The goal of the project was to provide a visualization on the no how many days the clients take to pay a given invoice past the allocated transaction due date.

Roles & Responsibilities:

• Met with the clients to define business requirements relating to dashboard needs.
• Worked closely with the client to define various transformations to be done on source data.
• Assisted with the design of processes and requirements for dashboard.
• Written SAS code to process the data and designed dashboard.
• Testing the visualization for data accuracy and consistency.

• Star performer award in current company in 2022.
• Participated in technical competition and won a team award.

• Passport available : No
• Father's Name : Surender Singh
• Date of Birth : 20/09/1996
• Gender : Male
• Maritial status : Single