Business Analyst Power Bi

JIGNA CHAUDHARY Business Analyst Data-Driven Decision Maker Driving Insights & Operational Impact

720-***-**** ********@*****.*** LinkedIn GitHub Denver, CO Data-driven Business Analytics graduate student with 8+ years of professional experience in operations, reporting, and cross- functional coordination. Skilled in collecting, analyzing, and visualizing data using Excel, SQL, Python, Tableau and Power BI to support planning, scheduling, and service efficiency. Detail-oriented and organized, with proven success in streamlining workflows, improving reporting accuracy, and enabling data-informed decisions. Currently pursuing an MS in Business Analytics at the University of Colorado Denver, with strong interest in transit planning, service development, and operational analysis. SKILLS

• Certifications: AWS Academy Graduate – Cloud Foundations; Coursera – Operations Research (Models and Applications)

• GIS & Mapping Tools: ArcMap GIS (runcutting, scheduling, mapping), Google Maps API, Folium (Python-based spatial analysis).

• Data Collection & Analysis: Field data gathering (ridership, routes, schedules, pedestrian access), descriptive statistics, survey analysis (Qualtrics, Excel, SQL, Python).

• Data Visualization & Reporting: Power BI (DAX, dashboards), Tableau (mapping & route visualization), Excel (PivotTables, VBA), Matplotlib, Seaborn.

• Programming & Databases: Python (Pandas, NumPy, Sklearn), R, SQL (CTE, Joins, Views), PostgreSQL, Snowflake, SQL Server, AWS.

• Modeling & Forecasting: Regression, Hypothesis Testing, Forecasting (ARIMA/SARIMA), Clustering (K-Means), Random Forest, Optimization (PuLP).

• GIS & Mapping Tools: ArcMap GIS (runcutting, scheduling, mapping), Google Maps API, Folium (Python-based spatial analysis).

• Operations & Planning: Process Optimization, Scheduling Support, UAT, SOP Creation, Risk Mitigation, Cross-functional Collaboration, SharePoint, Jira.

PROFESSIONAL EXPERIENCE

Teaching & Research Assistant August 2025 – Present University of Colorado Colorado, (USA)

• Prepared instructional materials and graded assignments/quizzes, ensuring fairness and accuracy in graduate-level courses.

• Mentored students on database design (ERDs, schemas, SQL), Agile methods, and AI-driven applications, bridging theory with practice.

• Delivered constructive feedback using standardized rubrics, improving clarity in evaluations and boosting student performance.

• Collaborated with professors to streamline assessments and enhance course delivery, increasing student engagement across Canvas, Zoom, and Panopto.

• Supported faculty research through data collection, literature review, and preliminary analysis, strengthening ongoing academic projects.

Digital Education & Teaching Analytics Support October 2024-August 2025 University of Colorado Colorado, (USA)

• Designed and analyzed academic surveys in Qualtrics, Excel, and Python, generating insights that improved course delivery, grading accuracy, and student engagement for 200+ learners.

• Built automated Excel and Power BI dashboards, streamlining KPI reporting and enabling data-driven curriculum planning.

• Partnered with faculty to manage digital platforms (Canvas, Zoom, Panopto), ensuring seamless proctoring and reliable access for 100+ students per session.

• Tested and documented Unity-based AR/VR prototypes, driving innovation in instructional design and enhancing digital learning experiences.

• Organized course content and grading rubrics via SharePoint, improving collaboration, version control, and alignment with strategic goals.

Assistant Manager – Business Operations & Analytics June 2017-August 2024 Aadhar Housing Finance Limited (A Blackstone Group Company) Mumbai, (India)

• Streamlined workflows and deployed a WhatsApp-based chatbot, improving customer engagement and reducing service response time by 25%.

• Monitored interaction data using SQL and Excel, compiling structured datasets to track usage patterns and improve service planning interventions.

• Automated weekly performance reporting with Excel and Power BI (DAX, KPIs), reducing manual effort by 20% while improving schedule reliability and consistency in reporting.

• Visualized regional and employee KPIs in Tableau using Snowflake/PostgreSQL, comparable to mapping ridership and route-level performance for decision-making.

• Facilitated digital adoption by creating SOPs and training 400+ branch teams, ensuring operational readiness and improving adoption of scheduling and planning tools.

• Coordinated budgeting, vendor communication, and reconciliations via AWS Cloud and Excel, strengthening cost efficiency and resource allocation.

• Consolidated insights into centralized MIS dashboards, enabling leadership to evaluate system-wide performance and plan future improvements.

PROJECTS

Denver International Airport-Non-Airlines Revenue Forecasting

• Analyzed 5 years of non-airline revenue data (60,000+ records) from Denver International Airport using Python (Pandas, NumPy), R, and Google Sheets to identify revenue trends, seasonality, and growth drivers.

• Built and validated forecasting models including ARIMA, SARIMA, and machine learning algorithms (Linear Regression, Random Forest), supporting data-driven decisions for capacity planning, budgeting, and future expansion efforts. Denver Airbnb Listings Analysis

• Performed exploratory data analysis (EDA) on 5,016 Airbnb listings using Python (Pandas, NumPy), and applied clustering and predictive models (Random Forest, Linear Regression) to identify pricing trends and evaluate host performance.

• Developed an AI-powered chatbot using OpenAI and Lang Chain to provide dynamic super host recommendations, integrating real-time data and prompt engineering to enhance user experience and support decision-making. Meals on Wheels – Volunteer Delivery Optimization Project

• Analyzed 251 client delivery records using Python and GAMS, applying clustering and mixed-integer programming to streamline volunteer delivery routes.

• Developed a cost-efficient delivery model for Meals on Wheels, optimizing 11 parking zones to serve 73 clients with 4 volunteers, reducing average walking distance by 25% and eliminating route overlaps. EDUCATION

Master of Science in Business Analytics August 2024- May 2026 University of Colorado Denver, GPA:4/4 CO,USA

Relevant Coursework: Statistical Analysis, Computing for Business Analytics, Prescriptive Analytics, Cloud Computing Concepts, Tools, and Security (AWS Academy)

Master of Management Studies – Finance August 2014- May 2016 University of Mumbai Mumbai, India

Finance (Top Ranker)

HONORS AND AWARDS

Ace Corporate Employee of the Year June 2020

Aadhar Housing Finance Limited Mumbai, India

Recognized for spearheading operational improvements and driving measurable business growth through data-backed insights and stakeholder collaboration.

Performance Certification August 2018

Aadhar Housing Finance Limited Mumbai, India

Commended for market research and forecasting efforts that directly contributed to the successful NCD (Non-Convertible Debenture) launch.

Contact this candidate