Back to Developers
Dev Gupta

Dev Gupta

Analyst

Mumbai, Maharashtra
85
Profile Score

About

Analyst-focused professional with experience in data analysis, reporting, and reconciliation across business operations. Skilled in Excel, SQL, and Power BI, with a track record of integrating external datasets for geo-based insights and market expansion. Adept at collaborating with cross-functional teams and transforming complex data into clear, actionable intelligence.

Skills & Expertise (29)

MS Excel Advanced
8.0/10
3
Years Exp
Tableau Intermediate
7.6/10
2
Years Exp
Power BI Intermediate
7.6/10
2
Years Exp
SQL Intermediate
7.3/10
2
Years Exp
Reconciliation Financial Regulations Income Tax TDS GST Inventory Management auditing Accounting Stakeholder Reporting Process Improvement Forecasting KPI Tracking Data Analysis Business Requirements Gathering MIS Reporting Financial Analysis Market Analysis Business Analysis MS Word MIS SUMIFS VLOOKUP Pivot Tables MySql MS PowerPoint

Work Experience

Business Support Executive

Aegis Covenant Private Limited

Sep 2025 - Present

Conducted data analysis and reporting, turning complex datasets into actionable business strategy. Executed accurate calculations and reconciliations, ensuring data integrity across large business datasets. Automated MIS reporting in Excel, reducing manual effort by 30%. Collaborated with cross-functional teams to provide timely data support and drive process improvements. Integrated external datasets, improving regional performance insights by 25%.

Business Analyst Intern

AI Variant

Mar 2024 - Dec 2024

Structured unclean data in Excel using filters, formulas, and formatting for dashboard creation. Built interactive dashboards in Power BI and Tableau to visualize trends and support MIS reporting. Conducted exploratory data analysis using MySQL, leveraging relational databases for structured insights. Identified correlations and patterns in complex datasets, translating findings into actionable visual summaries.

Account and Tax Assistant

CA Hariharan and Company

Jun 2023 - Jul 2024

Managed accounting, taxation, GST filings and financial audits, ensuring compliance with statutory regulations. Utilized advanced Excel functions (Pivot Tables, SUMIFS) to support financial reporting, ledger maintenance and improve data accuracy. Performed reconciliations for GSTR 1 (sales) and GSTR 3B (purchase) filings, achieving 100% compliance and accuracy. Processed credit/debit note entries and reconciled client accounts, maintaining financial integrity across multiple portfolios.

Presentation Specialist

Integreon

Dec 2024 - May 2025

Created high-quality PowerPoint presentations aligned with client specifications and instructions. Maintained consistency in design, layout, and formatting across all presentations. Developed presentations that met client requirements using client-provided information and data. Delivered 50+ client presentations with 100% accuracy, attention to detail, and on-time completion.

Education

Bachelor of Commerce - Lala Lajpatrai College of Commerce and Economics

2020 - 2023 · Afghanistan

Certifications

AI Dashboards using Microsoft Power BI

Skill Nation · 2025

EXCLER - Business Analyst

· 2024

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceMar 2026

Availability Details

Relocation

Depends on Offer

Skills (29)

MS Excel Tableau Power BI SQL Reconciliation Financial Regulations Income Tax TDS GST Inventory Management +19 more