VIPUL GOUR
Data Analyts
About Me
👋 Welcome to my Portfolio
I am a Data Analyst with 1.6 years of hands-on experience, passionate about transforming raw data into meaningful insights that support smarter business decisions. I enjoy exploring datasets, identifying trends, and converting complex information into clear, actionable insights. For me, data is not just numbers—it tells a story that creates impact.
I have worked extensively with SQL, Excel, and BI tools to analyze data, automate reporting, and build interactive dashboards that help teams track performance and make data-driven decisions.
🔍 Core Skills: Data analysis, dashboard development, SQL querying, data cleaning, and automation using Python (Pandas, NumPy, Matplotlib).
📊 Tools: SQL | Python | Power BI | Excel | DAX | ETL | Data Visualization
🌱 I continuously work on real-world projects and keep upgrading my skills to stay aligned with industry needs.
🤝 Let’s connect and share ideas around data and analytics.
1
Excel Project
Key Skills
My Experience
AtliQ Technologies — Data Analyst Intern
Remote (WFH) | April–May
- Cleaned and transformed business datasets using Microsoft Excel, SQL, and Power Query, resolving missing values, duplicates, and formatting inconsistencies to improve data quality and reporting accuracy.
- Performed ad-hoc analysis and variance analysis in Excel and Microsoft Power BI, identifying business trends, order fluctuations, and reporting anomalies to support strategic decision-making.
- Designed and optimized complex MySQL queries for data extraction, validation, and reporting, ensuring data consistency and analytical reliability.
- Automated client reporting workflows through Excel-based reporting solutions, reducing manual effort and improving turnaround efficiency.
- Analyzed 5G telecom performance data, tracking operational KPIs, revenue impact, and customer usage behavior to generate actionable business insights.
- Built an interactive Microsoft Power BI dashboard for Shield Insurance, enabling stakeholders to monitor customer acquisition, revenue growth, and key performance metrics through dynamic visual analytics.
Allied Engineers — Data Analyst
Delhi | Jan 2024 – Jun 2025
- Optimized reporting workflows using Advanced Excel and Python, achieving 99% data accuracy while supporting 12+ client projects across India, Kuwait, and Saudi Arabia.
- Conducted Level 1 & Level 2 site data analysis across 100+ locations, identifying operational risks and prioritizing corrective actions, reducing issue response time by 25%.
- Automated reporting workflows using Advanced Excel (VLOOKUP, Pivot Tables, lookup functions), reducing 2+ hours of manual effort daily and improving reporting efficiency by 30%.
- Developed and presented bi-weekly analytical reports on operational site performance, helping stakeholders identify the top 3 root causes of equipment failures, contributing to a 20% improvement in operational reliability.
- Collaborated with cross-functional teams on corrosion mitigation and asset integrity analysis, driving a 15% improvement in asset performance KPIs and strengthening compliance with safety standards.
Intervie Tech — Data Analyst Intern
Remote (WFH) | Dec 2023 – Jan 2024
- Cleaned and transformed 50K+ rows of raw data using Python (pandas) and Microsoft Excel, resolving inconsistencies and improving data accuracy to 98% for reliable business reporting.
- Built interactive dashboards in Microsoft Power BI to monitor sales performance, customer acquisition, and churn metrics, reducing reporting turnaround time by 40%.
- Performed Exploratory Data Analysis (EDA) on 50K+ records, uncovering trends, patterns, and 3+ actionable business insights that supported stakeholder decision-making.
- Partnered with marketing and finance teams to align analytical outputs with business objectives, improving cross-functional reporting accuracy and data-driven decision-making.
Awards & Certificate
Let's Work Together!
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.