CCE IIT Mandi – Himshikhar Program in Data Science (Ongoing):<ul><li>Pursuing advanced training in Data Science through the Himshikhar Summer Residential Program at CCE IIT Mandi.</li><li>Building strong foundations in Python, SQL, Statistics, and data-driven problem solving.</li><li>Learning Machine Learning concepts, algorithms, and their real-world business applications.</li><li>Developing analytical skills to extract insights from structured and unstructured datasets.</li><li>Working on hands-on projects and case studies involving data cleaning, visualization, and predictive modeling.</li><li>Gaining exposure to Business Analytics techniques for data-informed decision-making.</li><li>Applying industry-relevant tools and methodologies to solve practical business and analytical challenges.</li><li>Enhancing skills in communicating insights through reports, dashboards, and data storytelling.</li></ul>

HIMSHIKHAR 2026 - Summer Residential Program in Data Scinece

<ul><li>Developed proficiency in spreadsheet fundamentals for organizing and managing data efficiently.</li><li>Applied data cleaning, formatting, and validation techniques to improve data quality.</li><li>Created charts and visualizations to analyze trends and communicate insights effectively.</li><li>Utilized Pivot Tables and Pivot Charts for data aggregation and summary reporting.</li><li>Built interactive dashboards using filters, slicers, and dynamic reporting features.</li><li>Implemented lookup functions such as VLOOKUP, HLOOKUP, INDEX, and MATCH for data retrieval.</li><li>Performed what-if analysis to evaluate different business scenarios and support decision-making.</li><li>Gained hands-on experience in transforming raw data into meaningful insights for reporting and analysis.</li></ul>

Spreadsheet

<ul><li>Learned the fundamentals of databases and Database Management Systems (DBMS).</li><li>Gained an understanding of relational databases, tables, rows, and columns.</li><li>Explored core SQL concepts for storing, retrieving, and managing data.</li><li>Practiced basic SQL commands such as SELECT, WHERE, ORDER BY, and LIMIT.</li><li>Developed foundational knowledge of querying and filtering data from databases.</li><li>Understood the role of SQL in data analysis and database management.</li></ul>

Introduction to SQL

<ul><li>Lead managing member for intradepartmental events in the Life Sciences department, overseeing planning, coordination, and smooth execution.</li><li>Arranged logistics, schedules, and on-ground management for college events, coordinating with faculty and student volunteers.</li><li>Participated in numerous school-level extracurricular performances, including cultural and stage events, building confidence and public-speaking skills.</li><li>Managed the CRM portal for multiple electronic home appliance service centres, handling customer records, service requests, and follow-ups.</li><li>Ran operations at an electronics repair shop, interacting with customers, tracking work orders, and supporting training of repair staff.</li></ul>

Bachelor of Science

Biotechnology

Intermediate (Class XII)

Science

Matriculation (Class X)

Not Applicable

Sharda University, Greater Noida

India

Aspiring Business Analyst with a strong foundation in Biotechnology and a growing expertise in Data Science, Analytics, and Business Intelligence. Currently pursuing Data Science programs through Newton School and the CCE IIT Mandi Himshikhar Program, where I am developing skills in Python, SQL, Power BI, Statistics, Machine Learning, and data visualization.

Passionate about transforming raw data into meaningful insights that support strategic decision-making and business growth. Adept at analyzing trends, identifying opportunities, and creating data-driven solutions to solve real-world business problems. Eager to leverage analytical thinking, domain knowledge, and technical skills to help organizations optimize performance and make informed decisions.

As part of the project<ul><li>Analyzed 97,499+ IT support ticket records to identify trends in ticket volume, resolution time, issue severity, and customer satisfaction, enabling data-driven decision-making.</li><li>Designed an interactive dashboard with KPI cards, slicers, and visualizations to monitor ticket performance by priority, category, agent, and time period.</li><li>Performed data cleaning and validation, identifying missing and inconsistent values across multiple attributes to improve data quality and reporting accuracy.</li><li>Evaluated IT agent performance using metrics such as tickets handled, average resolution time, and satisfaction scores to identify training and workforce optimization opportunities.</li><li>Conducted trend and correlation analysis to examine relationships between ticket severity, resolution time, ticket categories, and customer satisfaction levels.</li><li>Generated actionable business insights through cost-benefit and operational analysis, supporting recommendations on staffing, training programs, and technology investments to improve service efficiency.</li></ul>

MITALI GARGIndia

Social Accounts

Achievements

Projects

IT Tickets Analysis using Spreadsheet

Education

Sharda University

White Leaf Public School, Bawana , Delhi

St. Francis School , Shamli ,UP

Certificates

HIMSHIKHAR 2026 - Summer Residential Program in Data Scinece

Spreadsheet

Introduction to SQL

Skills