Akash Singh

Akash Singh

Power BI Developer
India

نبذة عني

Results-driven Data Analyst and Power BI Developer with 5+ years of experience in SQL, data visualization, and business intelligence. Proven track record of transforming complex datasets into actionable insights, automat…

الخبرة

Data Analyst & BI Developer

Dialmaz Export (Diamond & Jewellery Industry)
Jun 2022 - حتى الآن · 4 سنوات 1 شهر

Developed interactive Power BI dashboards integrated with SQL, improving management decision-making speed and data accessibility.
Wrote and optimized complex SQL queries (CTEs, Window Functions, Joins) to analyze large datasets and extract business insights.
Reduced manual reporting effort by 40–50% by automating daily, weekly, and monthly MIS reporting systems using SQL and Google Apps Script.
Designed and built end-to-end ETL data pipelines for data cleaning, validation, and consolidation across multiple sources.
Created inventory and stock reporting systems enabling real-time visibility into business operations.
Automated email reporting systems with scheduled triggers, eliminating manual follow-ups.
Developed an internal Helpdesk and workflow automation system, significantly reducing process turnaround times.
Collaborated with senior management to define KPIs and deliver data-driven insights through structured dashboards.
Automated Google Sheets and Forms using Google Apps Script to eliminate repetitive manual tasks.

Data Analyst & BI Developer

Dialmaz Export (Diamond & Jewellery Industry)
Jun 2022 - حتى الآن · 4 سنوات 1 شهر

Developed interactive Power BI dashboards integrated with SQL, improving management decision-making speed and data accessibility., Wrote and optimized complex SQL queries (CTEs, Window Functions, Joins) to analyze large datasets and extract business insights., Reduced manual reporting effort by 40–50% by automating daily, weekly, and monthly MIS reporting systems using SQL and Google Apps Script., Designed and built end-to-end ETL data pipelines for data cleaning, validation, and consolidation across multiple sources., Created inventory and stock reporting systems enabling real-time visibility into business operations., Automated email reporting systems with scheduled triggers, eliminating manual follow-ups., Developed an internal Helpdesk and workflow automation system, significantly reducing process turnaround times., Collaborated with senior management to define KPIs and deliver data-driven insights through structured dashboards., Automated Google Sheets and Forms using Google Apps Script to eliminate repetitive manual tasks.

Senior MIS Executive

Paras Buildtech India Pvt. Ltd. (Real Estate)
Nov 2021 - Jun 2022 · 7 أشهر

Prepared comprehensive MIS reports for operations, maintenance, and cost tracking across multiple real estate project sites.
Managed multi-site data reporting covering expenses, manpower utilization, and operational efficiency metrics.
Developed Power BI dashboards to track project-level sales and revenue trends with real-time drill-down analysis.
Integrated multiple data sources into a centralized reporting system for unified visibility.

Senior MIS Executive

Paras Buildtech India Pvt. Ltd. (Real Estate)
Nov 2021 - Jun 2022 · 7 أشهر

Prepared comprehensive MIS reports for operations, maintenance, and cost tracking across multiple real estate project sites., Managed multi-site data reporting covering expenses, manpower utilization, and operational efficiency metrics., Developed Power BI dashboards to track project-level sales and revenue trends with real-time drill-down analysis., Integrated multiple data sources into a centralized reporting system for unified visibility.

Data Analyst / MIS Executive (DME)

Eagle Group (Media Broadcast)
Oct 2020 - Dec 2021 · 1 سنة 2 أشهر

Prepared daily, weekly, and monthly MIS reports and presented data insights to reporting managers.
Automated email reminders for pending tasks and MIS distribution using Google Apps Script.
Maintained staff dashboards and coordinated with process managers for timely data collation and reporting.
Developed FMS forms auto-filled by employee submissions, eliminating manual data entry.
Configured Google Sheets add-ons (Form Ranger, Form Publisher, Mail Merge) to streamline workflows.
Created PowerPoint presentations summarizing operational data for senior stakeholders.
Maintained shift schedules and staff checklists with automated tracking functionality.
Prepared technical comparisons and LPP documents for project tender requirements.

Data Analyst / MIS Executive (DME)

Eagle Group (Media Broadcast)
Oct 2020 - Dec 2021 · 1 سنة 2 أشهر

Prepared daily, weekly, and monthly MIS reports and presented data insights to reporting managers., Automated email reminders for pending tasks and MIS distribution using Google Apps Script., Maintained staff dashboards and coordinated with process managers for timely data collation and reporting., Developed FMS forms auto-filled by employee submissions, eliminating manual data entry., Configured Google Sheets add-ons (Form Ranger, Form Publisher, Mail Merge) to streamline workflows., Created PowerPoint presentations summarizing operational data for senior stakeholders., Maintained shift schedules and staff checklists with automated tracking functionality., Prepared technical comparisons and LPP documents for project tender requirements.

المهارات

إكسل ماي إس كيو إل بايثون (لغة برمجة) خادم SQL الاستخبارات التجارية نمذجة البيانات جداول بيانات جوجل باور بي آي SQL DAX ETL Pipelines Data Cleaning & Transformation KPI Dashboard Development MIS Reporting Google Apps Script VBA Automation Power Query Inventory & Sales Analytics Workflow Automation CTEs Window Functions Star Schema Data Cleaning Data Transformation VBA Joins Stored Procedures Report Automation ETL Pipeline Development Star Schema Design KPI Analysis Inventory Management Sales & Revenue Analytics Trend Analysis Top/Bottom Analysis Google Sites Google Forms Google Drive PowerPoint
الإبلاغ عن هذا الملف الشخصي؟