Power Bi Data Analyst

EKANSH GUPTA

**** ********* **, ******, ** 469-***-**** ***************@*****.*** https://www.linkedin.com/in/ekanshgupta68

Professional Summary

Business-focused Analytics & BI professional with 4+ years of experience translating complex data into actionable insights across sales, supply chain, finance, and cloud customer success programs. Microsoft Certified: Power BI Data Analyst Associate (PL-300). Expert in Power BI, SQL, and DAX with a track record of enabling enterprise-wide decision-making through executive-level storytelling, scalable dashboards, predictive models, and strategic recommendations. Adept at collaborating with technical and business leaders to deliver measurable impact.

SKILLS AND CERTIFICATIONS

Certifications: Microsoft Certified: Power BI Data Analyst Associate (PL-300)

BI Tools: Power BI, Power BI Report Builder, SSRS, Tableau, MicroStrategy, Alteryx

Data & ETL: SQL, PostgreSQL, Oracle, Power Query (M), DAX, Airflow DAG, DBT, SSIS

Languages: Python, Java

Version Control & Collaboration: Git, JIRA, Confluence, Monday.com

Other Tools: Salesforce, Microsoft Excel (Advanced), MS Project, Trello, Power Automate

EDUCATION

The University of Texas at Dallas, Master of Science, Information Technology and Management Dec 2022

Uttar Pradesh Technical University, Bachelor of Technology, Computer Science Engineering May 2018

PROFESSIONAL EXPERIENCE

Core-Mark International, Dallas Sep 2022 – Present

Data Analyst

Delivered 50+ enterprise Power BI dashboards with DAX and Power Query, boosting executive reporting efficiency by 35%.

Designed and implemented SQL-based ETL processes with the help of SSIS, custom scripts and automation, streamlining data pipelines and enhancing data quality.

Integrated cloud-based data sources like Power BI Admin API & Snowflake into enterprise dashboards, delivering near real-time insights to executives.

Analyzed sales and supply chain data to uncover performance gaps, providing actionable strategies that improved SLA adherence by 15%.

Configured 20+ Power BI workspaces and managed access for 1000+ users, streamlining content distribution across business units.

Built and scheduled 50+ automated dataset refreshes using power automate and utilize Power BI Admin APIs for refresh diagnostics, reducing refresh failures by 60% and improving data reliability.

Implemented row-level security (RLS) and governed data access for senior executives and cross-functional teams, improving compliance and trust in insights.

Mentored 4 junior analysts, reducing report development cycle time by 20% and standardizing best practices.

Presented quarterly KPI dashboards and strategic recommendations to VP-level leadership, directly influencing operational and investment decisions.

Built predictive models to forecast SKU demand across regions using Python and historical sales data, Improved forecast accuracy to 92%, enabling better inventory allocation.

eBay, Austin May 2022 – Aug 2022

Business System Intern

Designed interactive Power BI dashboards to monitor sales and marketing KPIs, improving visibility and execution by 18%.

Built automated processes to streamline seller activity tracking, saving ~15,000 hours annually.

Leveraged DAX measures and calculated columns to enhance data insights and ensure alignment with marketing KPIs.

Collaborated with Customer Success Managers to analyze engagement data, identifying high-risk accounts and reducing churn by 8%.

Infodat International Inc, Houston Jan 2022 - May 2022

Data Analyst Intern

Built ETL pipelines with DBT, transforming raw data for analysis and reducing data processing time by 25%.

Developed predictive models to forecast product demand, improving inventory management and reducing stockouts by 10%.

Developed automated workflows in Airflow to streamline data ingestion, enhancing the reliability and timeliness of business insights.

Novelvox Softwares India Private Limited, India

Associate Software Developer Apr 2018 - Nov 2020

Designed and maintained SQL databases for business analytics, ensuring data integrity and accessibility for cross-functional teams.

Proactively initiated and managed end-to-end projects, from data pipeline development to final reporting, providing actionable recommendations to leadership.

Designed an application to display customer information from different databases and Salesforce using Java and SQL.

Contact this candidate