Prashant Gupta

Software Engineer

Noida, Uttar Pradesh, India7 yrs experience

Key Highlights

7+ years of experience in BI and Data Analytics.
Expert in Power BI and Advanced DAX for reporting.
Proven track record in stakeholder collaboration and data governance.

Stackforce AI infers this person is a Data Analytics Specialist with expertise in SaaS and cloud-based analytics.

Contact

gupta.prash005@gmail.com LinkedIn

Skills

Core Skills

Data AnalyticsBusiness Intelligence

Other Skills

Microsoft FabricSQLPower BIGCP BigQueryDAXPower AutomateData ModelsGoogle Cloud Platform (GCP)Azure DatabricksBig Data AnalyticsSales OperationsOperations ManagementMicrosoft Power AutomateAdvanced ExcelData Mining

About

BI & Data Analytics Specialist with 7+ years of experience in Power BI, Advanced DAX, SQL, Microsoft Fabric, and GCP BigQuery. Expertise in designing scalable, high-performance dashboards, building optimized data models, implementing Row-Level Security (RLS), and integrating Fabric Lakehouse with Power BI using Direct Lake mode. Proven ability to deliver KPI-driven reporting solutions aligned with business and operational metrics, with strong experience in stakeholder collaboration, data governance, performance tuning, and cloud-based analytics.

Experience

7 yrs

Total Experience

1 yr 2 mos

Average Tenure

1 yr 2 mos

Current Experience

Walmart

Software Developer

Mar 2025 – Present · 1 yr 2 mos · Remote

Developed Microsoft Fabric pipelines to ingest Salesforce data into Lakehouse/Delta architecture, leveraging SQL transformations for near-real-time data updates and reliability.
Built advanced Power BI reports by integrating data from GCP BigQuery and Microsoft Fabric, using DAX and custom SQL logic to deliver actionable business insights.
Automated Power Automate workflows for pipeline event alerts and scheduled refreshes across Fabric and GCP, reducing manual effort and ensuring data consistency.
Optimized SQL queries and data models across GCP BigQuery and Microsoft Fabric, improving query performance and dashboard refresh times by 40%.
Implemented secure data governance and access control within Power BI and Fabric Lakehouse, ensuring compliance and accuracy across cross-platform analytics.

Microsoft FabricSQLPower BIGCP BigQueryDAXPower Automate+2

Classic home, inc.

Senior Data Analyst

Sep 2024 – Mar 2025 · 6 mos · Noida, Uttar Pradesh, India · On-site

Refined Power Automate flows for scheduled updates, reducing manual effort and tasks.
Implemented strategic adjustments to data models that boosted report accuracy and reliability achieving a 15% increase in user satisfaction scores from stakeholders relying on data insights for strategic initiatives.
Utilized Google Cloud Platform (GCP) Console to manage and optimize data pipelines, ensuring seamless integration with Power BI for real-time analytics and improved data accessibility.

Power AutomateData ModelsGoogle Cloud Platform (GCP)Data Analytics

Publicis groupe

Associate Data Analytics

Nov 2023 – Aug 2024 · 9 mos · Gurugram, Haryana, India · On-site

Extracted and validated data from diverse platforms including CM360, DV360, Google Ads, Meta, and databases using SQL queries, ensuring data accuracy and compliance.
Utilized Power BI and DAX to build interactive dashboards, improving response time by 70% and customer reach by 75% through actionable insights.
Devised SQL scripts for taxonomy validation, improving data accuracy by 80% through systematic identification and rectification of non-compliant data entries, thereby mitigating potential regulatory risks.
Used Power Automate to streamline ad campaign workflows, boosting CTRs by 70% and reducing CPA by 70%.

SQLPower BIDAXPower AutomateData Analytics

Ey

Associate Data Analyst

Oct 2021 – Oct 2023 · 2 yrs · Gurugram, Haryana, India · On-site

Led data-driven GST compliance for 5 companies, optimizing 70-80 registrations and achieving a 70% reduction in notice issues through SQL analysis, filing and communication.
Deployed financial forecasting models using Power BI and SQL integrating historical data and economic trends to predict revenue and expenses with 80% accuracy.
Crafted interactive Power BI dashboards that visually represented business trends, leading to a 65% improvement in accuracy and efficiency.

SQLPower BIData Analytics

Upgrad

Data Analyst

Sep 2020 – Sep 2021 · 1 yr · Noida, Uttar Pradesh, India · Remote

Utilized SQL and BI tools to analyze student profiles, enhancing communication strategies by 80%.
Optimized data extraction and workflows using SQL, improving application review efficiency by 40%.
Developed and automated data pipelines in GCP BigQuery using SQL, reducing data processing time by 35% and improving report accuracy.
Built interactive Power BI dashboards by integrating data from BigQuery and on-premise SQL sources, enabling data-driven decision-making across departments.
Leveraged SQL and GCP analytics tools to perform large-scale data analysis, uncovering performance trends that improved operational efficiency by 25%.

SQLPower BIGCP BigQueryData Analytics

Square yards

Data Analyst

Jan 2019 – Aug 2020 · 1 yr 7 mos · Lucknow · On-site

Conducted industry analysis using SQL revealing a 15% sales growth and 20% boost in customer acquisition, enhancing business strategies through sales trend and customer behavior analysis.
Enforced lead scoring and strategically prioritized prospects, contributing to a 70% boost in lead quality and conversion rates.
Designed and deployed data pipelines on Google Cloud Platform (GCP) using BigQuery and SQL, optimizing data processing time by 40% and enabling real-time business reporting.
Built interactive Power BI dashboards integrating data from GCP and on-premise SQL databases, delivering actionable insights that improved decision-making efficiency across sales and marketing teams by 30%.

SQLGCP BigQueryPower BIData Analytics