Ketan Rawat
Summary
Dynamic and results-oriented professional with a Master of Computer Application and specialized training in Data Analytics. Adept at leveraging technical expertise and analytical Skills to derive actionable insights from complex data sets. Proficient in Python , SQL, Tableau and Excel with a proven track record of effectively communicating insights to derive strategic decision making.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Process Associate
SandMartin Consultants Private
09.2022 - Current
Streamlined the handling and visualization of large data sets by creating visualizations and implementing formatting techniques.
Increased accuracy in data processing by conducting regular quality checks and implementing corrective measures when necessary.
Education
Master of Computer Applications - Data Science And Computer Applications
Chandigarh University
Mohali, India08.2024
Bachelor of Computer Applications - Computer And Information Sciences
Chaudhary Ranbir Singh University
Jind08.2022
Intermediate Education -
D.A.V Public School
Jind03.2019
Skills
- Language and Skills: SQL, Python, MS Excel, Statistical Analysis, and Exploratory Data Analysis
- SQL: DBMS, RDBMS, DDL, DML, DQL, JOINS, SUB Queries, Window Functions
- Machine Learning: Regression Model, Classification Model, Descriptive Statistics
- Python: NumPy, Pandas, Matplotlib, Seaborn, Scikit-Learn
- MS Excel: INDEX/MATCH, VLOOKUP and HLOOKUP, Logical Functions, Pivot Table, Charts
- Data Visualization tools: MS Excel, Power BI, Tableau
- Soft Skills: Problem Solving, Presentation, Collaborative, Adaptive, Logical and Visual thinking
Certification
Certifications:
- Completed Data analytics 360 degree certification course from Training YA.
- Completed Google Data Studio online certification from The Digital Adda
Projects
- Vrinda Store Data Analysis (Microsoft Excel)
Objective : Vrinda store wants to create an annual Sales report for 2023. So that Vrinda can understand their customers and grow more sales in 2024.
Description: Created a dashboard for Annual sales, So that one can easily see the Profit and Loss insights. Added slicer for customizable KPI according to time and categories.
Key Skills: Excel functions, Pivot charts, Pivot table, Statistical analysis.
- Digital Music Store Data analysis (SQL):
Objective : Analyze the Music playlist database to extract meaningful insight and inform data driven decision-making in the music industry.
Description : The project seeks to optimize marketing strategies, enhance customer experience, and maximize the revenue for the digital music store. Through the SQL queries the project aims to provide the actionable insights to derive business decision and improve overall performance.
Key Skills : SQL, DDL, DML, JOINS, DQL Commands
Personal Information
Date of Birth - 20-July-2001
Current Location - Jind(Haryana)
Work Flexibility: Open to various locations, including remote, hybrid, and office based settings, ensuring adaptability for optimal performance and contribution in diverse work environments.
Timeline
Process Associate
SandMartin Consultants Private
09.2022 - Current
Master of Computer Applications - Data Science And Computer Applications
Chandigarh University
Bachelor of Computer Applications - Computer And Information Sciences
Chaudhary Ranbir Singh University
Intermediate Education -
D.A.V Public School
Similar Profiles
Jishnu R PanickerJishnu R Panicker
Senior Finance Executive-FP&A at 91 Springboard Business Hub Private LimitedSenior Finance Executive-FP&A at 91 Springboard Business Hub Private Limited
Keano BeurskensKeano Beurskens
Server at Sandmartin PubServer at Sandmartin Pub
Arti NaikArti Naik
Cluster Manager at Medifit Consultants Private LimitedCluster Manager at Medifit Consultants Private Limited
Afreen FatimaAfreen Fatima
Process associate at GenpactProcess associate at Genpact
Srinithi MSrinithi M
Process Associate at HanDigital Pvt LtdProcess Associate at HanDigital Pvt Ltd