HELLO
I AM
AYUSH MAURYA

Data Analyst - The bridge between business and technology!

About me

About Me

Data Analyst with 4+ years of experience building SQL-driven data pipelines, analytical data models, and business reporting systems. Proven impact including 40% faster reporting, 25% reduction in data errors, and 12% cost optimization through forecasting models. Databricks Certified Data Engineer Associate with strong expertise in SQL, data modeling, ETL pipelines, and relational databases.

DATA ANALYTICS
DATA ENGINEERING
BUSINESS INTELLIGENCE

Technical Skills

Querying & Databases

SQL (Joins, CTEs, Window Functions), Query Optimization, MS SQL Server, MySQL, BigQuery, PostgreSQL.

Data Modeling & Pipelines

Star Schema, Fact-Dimension Modeling, Data Warehousing Concepts, ETL/ELT, Data Cleaning, Data Transformation.

Statistical Analysis

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

BI & Analytics

Power BI (DAX, Power Query, RLS), Looker Studio, KPI Reporting, Dashboard Automation, Stakeholder Reporting.

Professional Experience

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

  • Designed SQL-driven data pipelines and transformation workflows integrating sales, finance, and operational datasets for centralized analytics.
  • Structured analytical data models improving reporting efficiency by 40% for 50+ stakeholders.
  • Implemented row-level security and optimized data relationships, improving query efficiency and dashboard refresh performance by 30%.
  • Developed demand forecasting models enabling 12% procurement cost optimization.
  • Consolidated contractor and vendor financial records into centralized data reconciliation models for finance analytics.

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

  • Automated SQL queries and reporting workflows improving 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.

Product Sales Analytics

In-depth analysis of global sales metrics using Power BI & DAX.

KPMG Virtual Internship

ETL pipeline design, data quality assessment, and BI dashboards.

Blank Zero Tracking

Database management (Google Sheets) and Data Studio visualization (Q3-Q4 2024).

Weather Data Scraping

Python script using `requests` to fetch real-time weather and location data.

Retail Analytics Data Warehouse

Designed a star-schema using SQL with fact & dimension tables for transactional analytics.

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