SHIVAM KUMAR
Delhi
Summary
Detail-oriented and analytical professional with expertise in data analytics and HVAC systems. Proficient in SQL, Power BI, Excel, and Python, with a proven ability to derive actionable insights and optimize processes. Skilled in technical troubleshooting, preventive maintenance, and team collaboration. Seeking to leverage technical expertise and analytical skills to contribute to data-driven decision-making.
Overview
3
3
years of professional experience
1
1
Certification
Work History
HVAC Technician
Lion Pvt. Ltd.
Noida
07.2023 - 07.2024
- Diagnosed and resolved HVAC system malfunctions, improving system efficiency by 15%.
- Conducted preventive maintenance, reducing system breakdowns by 20%.
- Utilized advanced diagnostic tools to identify and resolve technical issues.
- Collaborated with engineers to optimize operational workflows and system performance.
- Trained junior technicians, enhancing team productivity by 25%.
HVAC Assistant
New Weather Pvt. Ltd.
New Delhi
06.2021 - 12.2021
- Assisted in the installation and maintenance of HVAC systems in both residential and commercial properties
- Performed troubleshooting to identify and resolve complex HVAC issues with a focus on efficiency and accuracy
- Maintained detailed records of maintenance work and service reports to streamline operational processes
- Collaborated with electricians and plumbers to ensure seamless HVAC integration into building structures
Education
Bachelor of Computer Applications -
Amity University
Noida04.2027
Diploma in Refrigeration and Air Conditioning Technology -
Babasaheb Ambedkar Technical Educational Society
New Delhi01.2020
High School Diploma -
St. Martin Diocesan School
New Delhi03.2018
Skills
- SQL
- Power BI
- Excel
- Python
- NumPy
- Pandas
- MySQL
- Data Cleaning
- Query Optimization
- Power BI Dashboards
- Interactive Reports
- Installation
Certification
Certified Data Analyst: Skillovilla (SQL, Power BI, Excel, Data Visualization)
Projects
SQL Airline Database Project
- Designed and implemented a relational database for an airline system using MySQL.
- Created optimized SQL queries for data extraction, cleaning, and manipulation.
- Improved query performance by 20%, enabling faster data retrieval and analysis.
Power BI Dashboard for ShopWest Store
- Manipulated and transformed raw data into actionable insights using Power Query and DAX.
- Created interactive dashboards to visualize sales trends and customer behavior.
Funnel Analysis & Data Manipulation
- Conducted funnel analysis on customer data to identify bottlenecks in the sales process.
- Cleaned and manipulated large datasets using Python (Pandas) and SQL, ensuring 100% data accuracy.
- Created visualizations to present findings to stakeholders, supporting data-driven decision-making.
Timeline
HVAC Technician
Lion Pvt. Ltd.
07.2023 - 07.2024
HVAC Assistant
New Weather Pvt. Ltd.
06.2021 - 12.2021
Bachelor of Computer Applications -
Amity University
Diploma in Refrigeration and Air Conditioning Technology -
Babasaheb Ambedkar Technical Educational Society
High School Diploma -
St. Martin Diocesan School
Similar Profiles
MD YOUSUF ALIMD YOUSUF ALI
Accounts Assistant at Lion Steel and re-rolling mills (PVT) Ltd.Accounts Assistant at Lion Steel and re-rolling mills (PVT) Ltd.
Mervin D'SilvaMervin D'Silva
Senior Client Director at Lion & Lion Digital MalaysiaSenior Client Director at Lion & Lion Digital Malaysia
Tawana DavisTawana Davis
Armed Security Officer at Blue Lion TacticalArmed Security Officer at Blue Lion Tactical
Suraj SethSuraj Seth
Automation Test Engineer at Tata Consultancy Services LtdAutomation Test Engineer at Tata Consultancy Services Ltd
AMAN SHARMAAMAN SHARMA
Jr. Buisness Analyst at Vidya Online Services Pvt Ltd.Jr. Buisness Analyst at Vidya Online Services Pvt Ltd.