Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Akhila Chebolu

Lisle,IL

Summary

Senior Business Intelligence Analyst with 5+ years of experience in workforce planning, labor allocation, and operational analytics across retail, finance, energy, and manufacturing. Demonstrates expertise in store productivity analysis, in-store analytics, and demand forecasting to enhance staff efficiency and effectively manage expenses. Proven expertise in AI-driven insights, A/B testing frameworks, and predictive modeling to drive business performance. Adept at partnering with HR and Finance to support hiring projections, staff planning, and budget alignment. Strong record of building executive-ready dashboards (Power BI, Tableau) and translating AI model outputs into actionable recommendations for business leaders. Proven expertise in financial modeling, portfolio analytics, and statistical analysis for decision support. Strong collaboration record with investment teams and stakeholders across different domains.

Overview

7
7
years of professional experience

Work History

Senior Business Intelligence Analyst (AI) – Enterprise Analytics & Finance Projects

Chevron North America
08.2024 - Current
  • Developed financial simulation models for capital budgeting across real assets and infrastructure portfolios and led the creation of OPEX forecasting dashboards for the Finance department, integrating budget planning and variance analysis across business units.
  • Automated reporting of project-level risk metrics using Python and Snowflake, improving transparency across business units.
  • Built and automated Power BI dashboards for investment portfolios and Sales & Marketing, integrating portfolio cost drivers, investment scenarios, actual vs. forecast comparisons, POS analytics, campaign tracking, lost sales analysis, and product mix optimization to support strategic decision-making and drive business insights.
  • Conducted model time failure and AI-driven consumer Sentiment analysis and Opinion mining, to improve product reliability and enhance the voice-of-customer strategy for QA Engineering and Customer Service departments. Built Power BI dashboards to visualize sentiment trends, customer satisfaction levels, and emerging topics across platforms.
  • Built APIs for live financial model consumption by strategic planning teams, and integrated AWS API Gateway, Lambda, S3, PostgreSQL (Aurora/RDS), Redshift, and SAP Concur endpoints to automate report extractions via SFTP for BI reporting and finance dashboards.
  • Deployed advanced analytics pipelines using Glue, Athena, and EMR for ETL processing, with CloudWatch/CloudTrail monitoring and IAM/KMS securing sensitive financial data.
  • Conducted industrial physical inventory counts, validated stock data against system records in Oracle EBS, and reconciled discrepancies to deliver accurate, audit-ready reports that improved data reliability and supported warehouse decision-making.
  • Configured MCP server for HubSpot CRM using Claude, enabling seamless integration and optimized CRM workflows.

Business Intelligence Analyst – Energy Forecasting & Use Case Modeling

National Grid (via Sierra Consulting Inc)
05.2023 - 07.2024
  • Built time series models to forecast budgeted vs. actual capital expenditures across grid modernization projects.
  • Developed predictive models for electricity demand and consumption patterns using Python and statistical modeling, increasing forecasting accuracy by 20%.
  • Partnered with the finance team to create Python tools that calculated asset depreciation risk for CAPEX and return impact.
  • Deployed analytics BI dashboards using Streamlit for scenario planning across energy infrastructure projects.
  • Built AI-enhanced solutions using Azure AI Foundry to enable predictive analytics and intelligent automation within Power Apps, improving decision-making efficiency.
  • Built predictive analytics workflows on SageMaker AI with integrated Glue/EMR ETL jobs; implemented monitoring via CloudWatch and automated data reconciliation through Step Functions and Event Bridge.
  • Track fuel usage, route efficiency, and vehicle maintenance. Analyze fleet costs and carbon emissions to support ESG (Environmental, Social, and Governance) goals.

Quantitative Data Analyst – Business Intelligence & Reporting

CVS Health (via Arche Group Inc)
08.2022 - 04.2023
  • Led the development of financial impact models for pricing strategies across the retail and PBM divisions.
  • Development of Tableau dashboards for pharmacy claims, prior authorizations, and formulary utilization, used by senior leadership to monitor efficiency.
  • Created Python tools for ROI analysis on private label launches using historical performance and customer segmentation.
  • Presented insights into strategy and finance leadership using Tableau and Python visualization libraries.
  • Designed and automated Power Automate flows and developed model-driven and canvas apps in Power Apps, leveraging Dataverse and Dataflows for real-time data ingestion, transformation, and seamless integration across enterprise workflows, apps, and dashboards.
  • Automated extraction, transformation, and loading of pharmacy claims data using AWS Glue, Lambda, and S3 into Aurora/RDS and Redshift for Tableau dashboards, while ensuring secure, compliant pipelines with IAM, KMS, Cognito, monitoring via CloudTrail/CloudWatch, and reliable event-driven notifications through SQS/SNS.

Business Intelligence & Quantitative Analyst

Morgan Stanley (via Tata Consultancy Services (TCS))
07.2018 - 07.2021
  • Built and maintained Python-based valuation and forecasting models for fixed income, structured products, and multi-asset portfolios, leveraging machine learning techniques with Scikit-learn (including logistic regression and time series methods) for predictive analytics and credit risk modeling.
  • Developed scalable AWS data pipelines using EMR, Glue, Redshift, Lambda, S3, and CloudWatch to automate reporting workflows with Code Commit, stress-testing, and scenario modeling, integrating these models to deliver actionable insights for investment strategy and risk management.
  • Supported credit risk modeling initiatives by building probability of default models using logistic regression and time series techniques to support structured product and credit risk analytics and monitor stress-testing jobs.
  • Developed performance attribution and scenario modeling tools for equity and multi-asset portfolios, collaborating with front-office stakeholders to automate stress testing and enhance investment strategy analysis.

Mainframe Developer

Tata Consultancy Services (TCS)
07.2018 - 02.2020
  • Designed, developed, and maintained CICS transaction screens, TCMs, and GUI interfaces to streamline financial reporting and portfolio operations.
  • Worked with Natural/ADABAS and z/OS mainframe environments to develop, modify, and decommission batch and online jobs, ensuring system reliability and compliance with business requirements.
  • Collaborated with cross-functional teams to migrate mainframe systems to Java-based platforms, modernizing application workflows and enabling integration with cloud-based analytics solutions.

Education

Master's in Management Sciences and Quantitative Methods - Business Analytics

Texas A&M University
Commerce, TX
08.2022

Bachelor's in Computer Science & Engineering - undefined

Andhra University
04.2018

Skills

  • Programming & Scripting: Python, R, SQL, Java, JavaScript
  • Cloud & Data Platforms:
  • AWS: S3, Lambda, EC2, RDS/Aurora, Redshift, Glue, Athena, EMR, SageMaker, Comprehend, API Gateway, Step Functions, Event Bridge, CloudWatch, CloudTrail, SQS, SNS, MQ, DMS
  • Azure: AI Foundry, Power Apps, Power Automate, Dataverse, Dataflows
  • Other Databases/Platforms: Snowflake, Oracle, PostgreSQL, Teradata, Google Cloud Big Query
  • Business Intelligence & Visualization: Power BI, Tableau, Streamlit, Jupyter, Flask, Docker, MicroStrategy, Cognos, Qlik
  • ERP, Finance & Workflow Systems: SAP Concur, Chrome River, Oracle ERP, Salesforce, EDI, OMS, Jira, ServiceNow (ITSM)
  • Workforce Management & Analytics:
  • Labor optimization & expense control analysis
  • Workforce planning, employee filing rates, hiring projections, staff planning
  • Store operations analytics, demand forecasting, in-store analytics
  • AI/Computer Vision model translation to business insights
  • A/B testing & operational experiments
  • Agile project management
  • Finance & Analytics: VaR, Time Series Forecasting, Portfolio Optimization, Scenario Analysis, Monte Carlo Simulation, Predictive Modeling, Corporate Finance, Asset Allocation, Private Credit, Real Assets, Fixed Income, OPEX, CAPEX
  • Productivity & Collaboration: Microsoft Office Suite, SharePoint, GitHub

Accomplishments

  • Standing O Award – Chevron North America (2025): Honored for exceptional collaboration and delivering high-impact projects focused on cost reduction, operational efficiency, and stakeholder value.
  • Champion – College-Level Hackathon, Texas A&M University (2022): Directed a team to achieve top recognition through strategic collaboration and innovative problem-solving.

Timeline

Senior Business Intelligence Analyst (AI) – Enterprise Analytics & Finance Projects

Chevron North America
08.2024 - Current

Business Intelligence Analyst – Energy Forecasting & Use Case Modeling

National Grid (via Sierra Consulting Inc)
05.2023 - 07.2024

Quantitative Data Analyst – Business Intelligence & Reporting

CVS Health (via Arche Group Inc)
08.2022 - 04.2023

Business Intelligence & Quantitative Analyst

Morgan Stanley (via Tata Consultancy Services (TCS))
07.2018 - 07.2021

Mainframe Developer

Tata Consultancy Services (TCS)
07.2018 - 02.2020

Master's in Management Sciences and Quantitative Methods - Business Analytics

Texas A&M University

Bachelor's in Computer Science & Engineering - undefined

Andhra University

Similar Profiles

CREATE PROFILE
Akhila Chebolu