Portfolio - Vikas Gupta

About Me

Welcome to my portfolio!

I’m Vikas Gupta, a Data Analyst with a diverse background in teaching and technical support. I bring a unique combination of communication skills and problem-solving expertise. My teaching experience allows me to simplify complex concepts, while my time as a technical support engineer sharpened my ability to troubleshoot and perform under pressure.

In my journey into data analytics, I’ve gained proficiency in Power BI , Excel and SQL, working on projects that transform complex data into actionable insights. I aim to leverage my past experiences to deeply understand business needs and deliver data-driven solutions that drive impactful decisions.

I’m passionate about continuous learning and excited to apply my skills to real-world challenges. I look forward to connecting with professionals in the field, contributing to meaningful projects, and growing within the dynamic world of data analytics.

Key Skills

Effective Communication

Data Visualization

Data Optimization

Stake Holder Management

Presentation

My Projects

Sales and Financial Analysis

Domain/Function: FMCG

Integrated Business Performance Dashboard: Finance, Sales, Marketing, and Supply Chain Analysis

Domain/Function: Sales, Marketing and Marketing

Comprehensive Analytics Solution for Hotel Management

Domain/Function: Hospitality Domain

Electric Vehicle Analysis

Domain/Function: Energy and Transportation Analytics

Lok Sabha Election Analysis

Domain/Function: Political & Media Analytics

Ad-Hoc Insights

Domain/Function: Sales, Marketing and Finance

My Experience

Empower Pragati Pvt. Ltd. & Learnet Skills Ltd.

Vocational Teacher/Trainer (IT/ITES)

· Worked as a Vocational Teacher in various companies for almost 7 years. Where I have used Advance Excel for compiling multiple sets of student assessment data and keep track of their progress and determine their current performance level.

· Also analyses Students wise result report with comparison from last performances in Advance Excel.

· Highlight important data, such as students at risk of failing or those excelling.

· Create charts and graphs to visually represent performance trends, attendance patterns, or resource utilization.

· Track KPIs such as pass rates, attendance, or teacher through custom visual reports.

mCARBON Tech Innovation

March 2014 – June 2017

Technical Support Engineer (mCARBON Tech Innovation Pvt. Ltd, Noida, Uttar Pradesh.)

· Handled MIS of Airtel LOAN Recovery, TTT and Cashback and other VAS services using Advance Excel.

· Identifying patterns and trends in data sets and reporting the results back to the relevant members of the business.

· Analyze customer data by region, plan type or usage. For example, a pivot table can track monthly revenue per user across different customer segments.

· Use charts and graphs to show network performance (e.g., dropped calls) over time or by location.

· Use interactive visuals (e.g., line charts, bar graphs) to track trends such as revenue growth by customer segment, or the usage trends.

· Implement slicers to filter data by customer segment, location, or service type for more detailed analysis.

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/vikas-gupta-a86039110/

Call Me

+91 9717524840

GitHub

https://github.com/Vikas-engg1

Vikas Gupta

Data Aspirant

1

4

1