Power Bi Machine Learning

SAWAR GUPTA

+1-682-***-**** • ************@*****.*** • linkedin.com/in/sawar-gupta-07b602168/ • github.com/sawargupta07 SUMMARY

Analyst with experience in machine learning, data analysis, and business strategy, leveraging tools such as Power BI, SQL, Excel and Python. Proficient in extracting insights from complex datasets, developing financial forecasts, and designing interactive dashboards to support data driven decision making. Adept in communicating analytical findings and passionate about using innovative techniques to deliver impactful results and improve operational efficiency. EDUCATION

M.S. Data Science August 2023 - May 2025

University of Texas at Arlington, TX 3.9/4.0 GPA

Integrated B.Tech + M.Tech in Computer Science Engineering August 2017 - July 2022 Gautam Buddha University, India 8.0/10.0 GPA

TECHNICAL SKILLS

Programming: Python(pandas, scikit-learn, TensorFlow, PyTorch), SQL Data Analysis: Statistical modelling, Forecasting, GAAP Reporting, Data Preprocessing, Visualization, Exploratory Data Analysis. Design and Modeling Tools: Power BI, Geospatial Mapping, Advanced Excel, Microsoft Office, Documentation Soft Skills: Analytical Thinking, Leadership, Communication, Change Management, Collaborative, Resilient Certifications: A/B testing, Microsoft Power BI

PROFESSIONAL EXPERIENCE

The University of Texas at Arlington, TX: Student Assistant - University Center Operations Feburary 2024– May 2025

• Led operations for 50+ campus events, managing logistics, A/V tech, cross functional teams, and real time issue resolution to ensure seamless execution.

• Streamlined event workflows, tracked resource allocation, and collaborated with stakeholders, developing strong analytical, coordi- nation, and client facing skills.

• Quickly adapted to dynamic challenges and acquired new technical and operational skillsets in fast paced environments. NeurIOT Technology Solutions, Noida, India: Junior Data Scientist August 2022– July 2023

• Built and maintained, user friendly analytics system that made data insights available 30% quicker by improving information flow.

• Worked with diverse teams to design a smart search system that cut wait times for data from 5 seconds to under 2, making information almost instantly accessible.

TechSci Research, Noida, India: Research Associate January 2022 – June 2022

• Conducted primary and secondary market research for global and Indian Information and Communications Technology (ICT) and Infrastructure markets, delivering actionable insights for high value clients.

• Designed and developed market estimation models in Excel, improving forecast precision by 20% and uncovering key trends.

• Created insightful dashboards in Power BI, streamlining data visualization and supporting strategic decision-making. PROJECTS

Dallas Restaurant Health Data Analysis

• Analyzed 75,000 Dallas restaurant health inspection records (2016–2024) using NLP, geospatial analysis, and predictive modeling, achieving an R of 39.02% and a mean absolute error (MAE) of 4.14 to uncover compliance trends and actionable insights..

• Identified underserved ZIP codes (e.g., 75289, 75228) and categorized restaurants through TF-IDF vectorization and K-Means.

• Developed an interactive Django-based website with Power BI visualizations, enabling users to explore inspection scores, trends, and geospatial patterns, fostering public awareness and transparency. Tesla Financial Performance Analysis

• Analyzed Tesla’s financial performance (2020–2023) using Python, focusing on revenue trends, profitability margins, and ROE, and forecasted revenues for 2024–2026 with Holt-Winters Exponential Smoothing, estimating continued growth.

• Designed an interactive Power BI dashboard with dynamic slicers, KPIs, and custom branding, highlighting key insights such as Tesla’s average revenue growth rate of 46.9% and a forecasted revenue of approximately $118.75 billion for 2025. New Delhi Traffic Insight: LSTM and Emissions Mapping

• Developed a LSTM model to forecast New Delhi’s Traffic Congestion Index (TCI), achieving over 90% prediction accuracy, further created a vehicular Carbon Monoxide (CO) emission inventory, incorporating TCI data, which contributed to emission reduction policies; published findings in a thesis on climate change mitigation. Thesis LEADERSHIP & ACTIVITIES

• Recipient, Maverick Advantage Distinction – University of Texas at Arlington

• College of Engineering Senator in the University of Texas at Arlington Student Government.

• Chair, Legislative Special Affairs Committee, UTA Student Government.

• Founding President, Data Analytics and Technology Association, College of Engineering, UTA.

• Events Manager, Engineering Student Council.

Contact this candidate