Data Analyst Power Bi

GAZAL GANDHI

720-***-**** ********@********.*** https://www.linkedin.com/in/gazal-gandhi-0a0625140 PROFILE: Dynamic Analytics Professional with 5+ years of experience, recognized for strong analytical skills, affirmed by 83% efficiency gains through predictive modelling and managed terabyte-scale datasets using SQL. Proven track record in requirement gathering, leading to $23M in cost savings and generating $3M in annual revenue. Enhanced rocket system design by 15% and boosted data accuracy using Python and Power BI. Holds a Master’s in Business Analytics degree, and served as a Graduate Teacher’s Assistant for Python and R for 100+ students.

EDUCATION:

University Of Colorado – Leeds School of Business Master of Science: Business Analytics Boulder, CO, USA 07/2023 - 12/2024 The NorthCap University, Gurugram Bachelor of Technology: Computer Science Gurugram, Haryana, India 08/2015 - 05/2019 TECHNICAL SKILLS:

Python(Pandas, NumPy, Matplotlib, Plotly), SQL(Snowflake), ETL/ELT Solutions, Power BI, Tableau, JIRA, SAFe Agile, Microsoft Platform(VBA, Excel, PowerPoint), Azure(Data Factory & Databricks), Data Security and Governance, ERP Systems (SAP) WORK EXPERIENCE:

University Of Colorado 01/2024 - 05/2024

Data Analyst

Reduced employee churn from 12% to 7% by identifying pivotal factors, at a Fortune 100 company, using Optimized Extreme Gradient Boosting model achieving 83% model accuracy.

Analysed workforce attrition, quantifying $23 million in potential savings and driving operational improvements. Delivered insights through detailed reports and presentations to key stakeholders. University Of Colorado - Sounding Rocket Laboratory 06/2023 – 12/2023 Data Analyst

Executed EDA on telemetry and sensor data from test flights, resulting in a 20% increase in data accuracy and reliability.

Incorporated refined data to achieve a 15% improvement in the design and optimization of rocket systems.

Minimized idle periods to 5% through diligent maintenance of data-driven visualizations with Tableau and SQL, displaying KPIs, and performance inconsistencies, empowering engineers to proactively address the issues in our rocket system. IBM 11/2019-05/2023

Data Analyst

Led and mentored six cross-functional, geographically dispersed teams to balance business goals with sustained profitability.

Developed Python logic and optimized SQL queries to extract terabyte-sized datasets and communicated insights through Power BI dashboards to technical and non-technical stakeholders.

Collaborated with Engineers and Data Scientists to come up with Analytics Requirement Documents (ARD) and operational task logs demanded by the business user, increasing bottom-line gains by 21%, and resulting in recognition from business users.

Conducted an A/B test to evaluate the effectiveness of “Personalized Wellness Interventions” on patient engagement metrics, using Python/SQL EDA. Partnered with the data science team and led project management using JIRA.

Increased efficiency by 15%, converting $3M in annual expenses into revenue through automated sound solutions, earning clients accolades for innovative implementations.

Led a team of 4 analysts to build Power BI dashboards and built Python scripts to automate reports and jobs scheduling, saving 56 hours/week of manual work, while reducing analytics bandwidth by 20%, and gaining leadership adoption.

Engineered SQL queries and reports within SAP BW/BI to support decision-making, extracting critical data from SAP modules and delivering insights to cross-functional teams.

Utilized Data Bricks for data transformation and implemented an ETL pipeline via Azure Data Factory and Logic Apps to streamline data integration and data migration across multiple systems.

Performed AWS admin duties using IAM by Data Governance framework to enhance data quality, integrity, and overall management.

Virtuosos Solutions Pvt Ltd. (Internship) 06/2018 - 06/2019 Data Analyst

Reduced non-productive time to 5% by creating data driven Power BI dashboards and SQL queries, highlighting KPIs and performance issues, and empowering engineers to take proactive measures.

Optimized reporting using advanced Excel(SUM, INDEX, MATCH, VLOOKUP) and VBA automation, saving 5-6 hours/week of manual work. Created dynamic reports using Pivot tables, reducing time and boosting accuracy.

Contact this candidate