Bushra Haque
Newnan,GA
Summary
Data-driven Supply Chain and Business Intelligence Analyst and a recent M.S. graduate in Industrial Engineering from the Georgia Institute of Technology with expertise in forecasting, inventory optimization, and large-scale data analysis. Skilled in SQL, Python, R, and Power BI (DAX), with a proven track record of building and automating forecasting pipelines, designing algorithms for data-driven models and reports, migrating legacy systems, and improving decision-making across supply chain networks. Adept at delivering insights that align demand planning, vendor management, and financial performance.
Overview
5
5
years of professional experience
Work History
Supply Chain Business Intelligence Analyst
Genuine Parts Company - NAPA
03.2024 - Current
- Designed and automated a forecasting system from scratch in Google BigQuery using SQL (ARIMA+ and AutoML) and Python, generating monthly forecasts for Field Lines at SKU and Supply Channel (vendor-to-store direct/via DC) levels. Built Power BI reports to map forecasts against historical sales trends and actuals enhancing accuracy and decision-making by integrating order projections that accounted for on-hand inventory and open inventory holes reducing forecasting time from ~30 days for 2 FLs to 30 minutes for 98 FLs and VMAPE values from > 20% to < 2%.
- Automated the Category Store Budget Exception Policy in GBQ using stored procedures by calculating Upper Control Limits (UCLs) for store sales. This replaced manual budget-setting with a scalable pipeline, increasing auditability and consistency across 17440 stores.
- Led three high-visibility PTS (Potential to Sell) projects for GPC's "Pulse" app leveraging GBQ and Power BI (DAX):
– PTS vs. Assortment Quadrant Analysis: Built quadrant-based dashboards to identify SKUs with PTS > 50 but not stocked and PTS < 50 but stocked, quantifying missed opportunities in sales units and dollars.
– Zero/Null PTS Diagnostics: Built SQL-based root cause framework to trace missing PTS values (e.g., stocking gaps, hierarchy misalignments, scoring rules and boosting, model exclusions), reducing blind spots in forecasting.
– Worst-Out Returns Ranking: Developed GBQ-based ranking to flag low-performing parts at store level for return to DCs, improving shelf efficiency and aligning stocking with demand. - Migrated legacy Qlik dashboards into BigQuery + Power BI, including a transfer app (tracking stock flows between DCs) and inventory bucket reports (categorizing SKUs by both units sell through and sales recency).
- Integrated factory discounts and promotions into forecasting outputs, aligning supplier performance with GPC’s category sales plans and accurately predict sales.
Supply Chain Analyst Intern
Michelin Connected Fleet
05.2023 - 12.2023
- Developed forecasts by analyzing sales data to identify demand sources, trends, and variability at both product family and primary item levels, which was used to synchronize promotion strategies, special events, and new product introductions.
- Analyzed production capacity and inventory levels, aligning operations schedule using SQL, establishing optimal inventory targets, and implementing demand-driven strategies resulting in a 20% reduction in stockouts and 15% increase in on-time delivery performance.
- Built a sales-demand dashboard and an S&OP through cross-functional collaboration to overlay demand and supply and provide the insight.
- Created dashboards and visualizations with Python, PowerBI (DAX), and Excel 3D Maps to map North American installers, analyze device installation patterns, SO acceptance rates, and delivery performance to optimize third-party installer selection based on installer performance.
- Streamlined high-priority, time-consuming tasks in Operations by automating them with VBA programming in Excel, cutting SO processing times from approximately 120 minutes to 30 minutes.
Order Fulfillment Analyst
Micron Technology Inc.
07.2021 - 07.2022
- Increased order confirmation rate from 85% by suggesting changes in order confirmation timeline between Amazon US, Amazon UK and Amazon CA, which reduced lead times for Micron CPG.
- Prepared an order distribution methodology based on previous confirmation trends and implemented order allocation and stock distribution methods.
- Designed reconciliation procedures to reduce errors and improve accuracy.
- Accelerated the transition of CPG from physical hubs to virtual hubs during the CPG-Micron integration.
Business Analyst Intern
Capillary Technologies
01.2021 - 06.2021
- Designed and automated monitoring and reconciliation procedures of the company’s customer data with the back-end data to acquire data capture percentage and summary.
- Implemented the monitoring procedures to identify and eliminate errors and reach 100% accuracy.
- Developed a method of analyzing the customer data from FTP by capturing it directly into Firebase and Grafana and by-passing storage of data in S3 Browser.
Education
Master of Science - Industrial Engineering
Georgia Institute of Technology
Atlanta, GA12.2023
Bachelor of Engineering - Industrial Engineering
Shri Ramdeobaba College of Engineering And Management
Nagpur, India06.2021
Skills
- SQL (GBQ, SSMS, Spark)
- Python (GBQ Notebook, VSCode, Jupyter Notebook)
- R Programming
- Tableau
- Power BI (DAX language)
- MS Excel (VBA programming, PowerPivot, LOOKUP, Macros)
- MS Access
- SAP ERP
- Demand Forecasting and Automation (ARIMA/AutoML)
- Industrial Engineering (Lean Six Sigma/Kaizen/Continuous Improvement/PFMEA)
- Simulation (Simio/Simul8/AnyLogic)
- Optimization (PLEX/Guorbi)
Accomplishments
- Summa Cum Laude - Industrial Engineering Branch, RCOEM
- Executive Head, Indian Institution of Industrial Engineering (IIIE)
- Technical Head, Industrial Engineering Society (IES)
Timeline
Supply Chain Business Intelligence Analyst
Genuine Parts Company - NAPA
03.2024 - Current
Supply Chain Analyst Intern
Michelin Connected Fleet
05.2023 - 12.2023
Order Fulfillment Analyst
Micron Technology Inc.
07.2021 - 07.2022
Business Analyst Intern
Capillary Technologies
01.2021 - 06.2021
Master of Science - Industrial Engineering
Georgia Institute of Technology
Bachelor of Engineering - Industrial Engineering
Shri Ramdeobaba College of Engineering And Management
Similar Profiles
Alexis Nicole WhiteAlexis Nicole White
Strategic Business Transformation Manager at Genuine Parts Company /NAPA Auto PartsStrategic Business Transformation Manager at Genuine Parts Company /NAPA Auto Parts
Robert RayRobert Ray
Assistant store manger at Genuine Parts Company (Napa Auto Parts Corporate stores)Assistant store manger at Genuine Parts Company (Napa Auto Parts Corporate stores)
Wesley OathoutWesley Oathout
Supervisor at Genuine Parts Company - NAPASupervisor at Genuine Parts Company - NAPA
SEAN HARTZOGSEAN HARTZOG
Lieutenant Court House Security at Coweta County Sheriff's OfficeLieutenant Court House Security at Coweta County Sheriff's Office
Latanya S. BucknerLatanya S. Buckner
Director of Financial Administration II- Professional Education at Georgia Institute of TechnologyDirector of Financial Administration II- Professional Education at Georgia Institute of Technology