Shivam Rathod
Indore
Summary
Detail-oriented Data Analyst with extensive experience in data analysis and application support. Proficient in SQL, Python, and MS Excel for data extraction, cleaning, and visualization. Demonstrated success in root cause analysis and translating complex data into actionable insights. Committed to enhancing data quality and supporting data-driven decision-making in a dynamic environment.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Data Analyst Intern
Bithub technologies
pune, india
02.2025 - Current
- Utilized MS Excel functions, including Pivot Tables and Power Query, to clean and analyze large datasets.
- Developed dashboards and reports in Excel to monitor KPIs, trends, and performance metrics.
- Executed SQL queries for data extraction and analysis from relational databases.
- Conducted data cleaning and validation through advanced Excel formulas and SQL checks.
- Performed trend and variance analysis to facilitate informed business decision-making.
- Automated recurring reports with SQL queries and Excel templates to minimize manual effort.
Application Support Engineer
Codify Software Services
11.2020 - 07.2023
- Analyzed SQL databases to identify trends, anomalies, and performance bottlenecks for data-driven decisions.
- Performed root cause analysis using logs, job failures, and system metrics to identify recurring issues.
- Supported automation initiatives, decreasing manual checks and operational effort by 30%.
- Used UNIX commands and shell scripting to automate data extraction and support ad-hoc analysis.
- Conducted performance analysis on slow-running queries, enhancing data retrieval efficiency.
IT Specialist
K.K Convent School
07.2017 - 07.2020
- Maintained and troubleshot school networks, servers, and internet connectivity
- Designed and delivered engaging IT lessons on programming, networking, and database management
- Taught students fundamental and advanced concepts in computing and software applications, including SQL, Python, and Linux, significantly improving their technical skills
Education
M.tech - Data Science
School of data science and forecasting
Indore05.2025
B.Tech - Computer Science Engineering
Shreejee institute of technology and management
Khargone02.2017
Skills
- SQL proficiency
- python
- data analysis
- data handling
- PL/SQL
- UNIX
- Application Support
- data analytics
- Data Visualisation
- SQL querying
- Microsoft Excel
Languages
English
Hindi
Training
SQL and UNIX Certification, DBS Solution, Expert
Certification
- Sql and unix certification DBS solution .
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Data Analyst Intern
Bithub technologies
02.2025 - Current
Application Support Engineer
Codify Software Services
11.2020 - 07.2023
IT Specialist
K.K Convent School
07.2017 - 07.2020
M.tech - Data Science
School of data science and forecasting
B.Tech - Computer Science Engineering
Shreejee institute of technology and management