Areas of Expertise

  • Programming & Databases: MySQL, SQL, Python (NumPy, pandas, SciPy, scikit-learn, Keras, TensorFlow, nltk), ETL, Linux, SAP HANA
  • Data Analysis & Modeling: Qualitative and Quantitative Analysis, Linear/Logistic Regression & Classification (Decision Tree, Random Forest, XGBoost, SVM, Neural Networks), Machine Learning, and Design of Experiments (DoE), A/B Testing, DMAIC - Six Sigma
  • Business Intelligence & Dashboards: Tableau, Power BI, Matplotlib, Seaborn, Excel Charts
  • Excel Modeling & Statistical Analysis Tools: Excel Modeling and Statistical Analysis tools: Solver, Solver Table, Precision Tree, Risk modeling, Monte Carlo Simulations (@Risk), Hypothesis Testing, Trend Analysis, Co-relation analysis, Statistical Methods (chi-squared, t-test, etc.), what-if analysis
  • Website Analytics: Google Analytics, Squizmatrix, Site Improve
  • Other Tools: Microsoft Excel (VLOOKUP, Pivot Tables, Macros), Microsoft Office Suite (Word, PowerPoint), Power Apps, Smartsheet, SAP ERP, GitHub, Jupyter, Google Colab, Minitab
  • Business Analysis: Agile Methodologies, Project Management, Requirements Gathering, User Requirements, Process Improvement, Technical Writing, Process Documentation, User Acceptance Testing, Quality Assurance
  • Certifications: Lean Six Sigma - Greenbelt, Python for Data Science by IBM

Work Experience

Data Analyst/Webmaster

February 2024 - June 2024

  • Data Extraction (Excel, VBA), ETL (Python), and Database (Access): Developed a comprehensive Mine Subsidence Database for claims management by extracting data from 7k+ email attachments using Excel and VBA, performing data cleaning and transformation with Python, and loading 200k rows of data into an Access database through an ETL pipeline.
  • Access Forms and SQL: Designed intuitive Access form-based UI streamlining the Mine Subsidence claims process through interactive forms with the backend built using SQL to interface with the database.
  • Website Analytics Tools and Content Management (Smartsheet): Optimized website maintenance, resolving 90%+ known issues via website analytics tools. Standardized website content management through Smartsheet form.
  • Automation (Excel, VBA): Automated organization of 2000+ enforcement documents into folders, reducing purge time from 2 weeks to 30 minutes.
  • Data Visualization (Power BI), ETL, and SQL: Generated interactive Power BI dashboards visualizing KPIs (open claims, valid claims, payouts, county claims) for data-driven decision-making, with the data sourced from multiple databases through ETL processes and SQL queries.

Business Analyst

January 2021 - June 2022

  • Collaboration: Collaborated with cross-functional SAP ERP Support teams, bridging business goals and technical requirements for global clients in energy, telecom, and manufacturing.
  • System Management: Oversaw SAP S4, BW, HR, and HANA DB architecture, achieving a 50% reduction in downtime through maintenance and process enhancements.
  • Data Analysis: Extracted insights from 10 SAP environments using SQL, Excel, and HANA, delivering cost savings of $50K through dashboards and reports.
  • Operational Efficiency: Streamlined task planning, addressing ad-hoc stakeholder requests promptly, and reducing ticket backlog by 40% within 3 months.

Research Aide

June 2023 - December 2023

  • Real-time Object Detection: Led YOLO v5 and YOLO v8 based object detection of diabetes-related medical devices in online videos, boosting information credibility.
  • Dataset Development: Extracted and annotated 5000 images, playing a key role in developing a robust dataset for training and validation.
  • Bolstering Information Accuracy Ensured accuracy on 50+ websites for reliable healthcare decisions, elevating website credibility by 40%.

Education

W.P. Carey School of Business
@ Arizona State University

Master of Science in Business Analytics
GPA: 4.0 | Graduated Summa cum laude
August 2022 - May 2023
Tempe, Arizona

Relevant Coursework: Data Analytics, Data Mining, Data Driven Quality Management, Statistical Modeling, Supply Chain Analytics, Advanced Marketing Analytics, and Business Intelligence



Gujarat Technological University

Bachelor of Engineering in Electronics and Communication Engineering
CGPA: 7.6 | First Class with Distiction
August 2016 - August 2020
Ahmedabad, India

Relevant Coursework: Python, C, MATLAB, HTML/CSS

Project Highlights

Workforce & Staffing Forecasting

Engineered a data pipeline for efficient analysis, developed a predictive police staffing model, and created dashboards, saving $50,000 for the City of Surprise P.D.

Lean Six Sigma - Case Study

Streamlined operations, cutting cycle time by 15% through Lean Six Sigma methodologies and DMAIC-root cause analysis. Enhanced analytics with Tableau.

Solar Energy Analysis

Developed accurate predictive models for electricity demand and solar production, enhancing efficiency by 35% and achieving significant cost reductions through strategic capacity planning and demand management.

Social Media Analysis

Employed PRAW Reddit API to scrape 175k comments from popular movie subreddits. Utilized NLP, Power BI, and BERT for insightful data-driven decisions and interactive visualization.

Hand Gesture Recognition using Open CV

Created a computer vision solution with MediaPipe for 90%+ accurate real-time hand gesture recognition, enabling hands-free desktop control and receiving positive user feedback.

Delivery Route Optimization using Integer Programming

Optimized delivery routes with Excel-based integer and linear programming models, reducing mileage by 20%, minimizing fuel usage, and cutting transportation costs by 12%.