HELLO
I AM
AYUSH MAURYA

About me

About Me

Results-driven Data Analyst with 3+ years of experience in SQL, Power BI, Databricks, and cloud analytics. Proven track record in optimizing data workflows, reducing reporting time by 40%, and delivering actionable insights for strategic decision-making in Infra & Reality sectors.

DATA ANALYTICS
DATA ENGINEERING
BUSINESS INTELLIGENCE

Technical Skills

BI & Visualization

Power BI (DAX, Power Query, RLS), Looker Studio, Advanced Excel.

Databases & ETL

SQL (MS SQL Server, MySQL, BigQuery), ETL/ELT, Data Warehousing.

Analytics & Statistics

Forecasting, Regression, Time Series Analysis, Clustering, A/B Testing.

Core Competencies

Data Modeling, Data Cleaning & Transformation, KPI Development, Dashboard Automation, Stakeholder Reporting.

Professional Experience

Data Analyst | A.K. Infra & Reality Developers Pvt. Ltd. — Lucknow, India Dec 2023 - Present

  • Engineered enterprise-scale Power BI dashboards integrating sales, finance, and operations data, accelerating reporting workflows by 40% for 50+ stakeholders.
  • Designed and automated SQL-based ETL pipelines, reducing data processing errors by 25% and saving 10+ hours per week.
  • Implemented Row-Level Security (RLS) and optimized data models, improving dashboard refresh performance by 30%.
  • Developed demand forecasting models for construction materials, enabling 12% cost optimization.
  • Unified contractor and vendor ledgers into centralized reconciliation dashboards for finance leadership.

Junior Data Analyst | Core Integra Consulting Services — Lucknow, India Dec 2021 - Nov 2023

  • Automated SQL queries and Excel dashboards, improving operational efficiency by 30%.
  • Cleaned, transformed, and validated datasets exceeding 250,000+ records, ensuring reporting accuracy.
  • Built KPI dashboards in Looker Studio to improve stakeholder visibility and decision-making.
  • Applied predictive analytics and regression modeling to improve campaign ROI by 9%.

Key Projects

HR Analytics Dashboard

Attrition and hiring trend analysis using Power BI & SQL.

Instagram Data Analytics

Engagement analysis on 700+ records using MySQL.

KPMG Data Analytics

Virtual Internship focusing on ETL pipeline design, data quality assessment, and BI dashboards.

Education

  • M.Sc. Mathematics — J.S University | 2023
  • B.Sc. Mathematics — J.S University | 2021
  • Diploma in Electrical Engineering — Integral University | 2018

Certifications

  • Databricks Certified Data Engineer Associate
  • Google Data Analytics Professional Certificate — Coursera (2024)
  • Microsoft Power BI Certification — Infosys Springboard

Let's Connect



+91 8960548859


ayush5196@gmail.com


linkedin.com/in/ayushmaurya5196
Portfolio created by Ayush Maurya
Visit My Website