AKSHAY DURGE

Data Analyst

Pune, India 5+ yrs exp 90 · Outstanding

About

Data Analyst with 1.5+ years of experience and 2.5+ years as MIS Executive, specializing in data analysis, business intelligence, and reporting automation. Proficient in Advanced Excel (VLOOKUP, Pivot Tables, Power Query, Macros), SQL (CTEs, stored procedures), and Power BI (DAX, KPI dashboards). Skilled in EDA, data cleaning, ETL pipelines, and translating raw data into actionable insights. Experienced in stakeholder collaboration and data-driven decision-making.

Skills & Expertise (44)

Python Intermediate

7.5/10

Years Exp

DAX Intermediate

7.5/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

ETL Intermediate

6.5/10

Years Exp

Git Intermediate

6.0/10

Years Exp

Tableau Intermediate

6.0/10

Years Exp

Data Factory Data Wrangling Statistical Analysis MS Office Suite Hypothesis Testing Sentiment Analysis A/B testing Data Storytelling Azure Google Colab Synapse AWS pgadmin4 Redshift S3 Athena QuickSight Jupyter Notebook KPI Dashboards HLOOKUP Index-match Pivot Tables Power Query Macros VBA Postgresql SQL Server SQLite Data Validation Pandas NumPy Matplotlib Seaborn BeautifulSoup Requests scikit-learn EDA VLOOKUP

Work Experience

Data Analyst

Secular Software Pvt Ltd

Jan 2025 - Present

Collaborated with 5+ stakeholders; extracted and analyzed 7M+ records using advanced SQL (CTEs, window functions, joins), enabling 28% faster data-driven decision-making. Engineered 8+ automated Power BI dashboards using DAX and Power Query, enabling real-time KPI monitoring and reducing manual reporting effort by 45%. Developed Excel-based MIS reporting templates (VLOOKUP, INDEX-MATCH, Pivot Tables), cutting report delivery time by 30% across cross-functional teams. Partnered with 4 cross-functional teams to convert business problems into data models and analytical reports, improving performance outcomes by 22% and ROI.

MIS Executive

Spectrum Consultant Pvt India Ltd

Mar 2021 - Dec 2024

Processed 50,000+ records/month using Advanced Excel and SQL with 99.8% data accuracy, supporting MIS reporting and business intelligence needs. Spearheaded design and upkeep of 20+ MIS reports and Power BI dashboards, slashing turnaround time by 30% and expediting critical stakeholder decisions. Streamlined Excel workflows using VLOOKUP, HLOOKUP, Pivot Tables, Power Query, and Macros, reducing manual effort by 40%. Automated recurring monthly reports via Excel Macros and SQL stored procedures, saving 10+ hours/month in manual processing.