Saquib Ali
Business Intelligence Analyst/Engineer II
Pune
Summary
Experienced Business Intelligence Engineer with 6.5+ year of experience and skilled in designing, implementing, and maintaining data infrastructure. Proficient in gathering and analyzing business requirements, delivering actionable insights using BI tools such as SQL, Python, Quicksight, and AWS services. Collaborative problem-solver with a track record of driving strategic initiatives and optimizing processes. Committed to staying updated on emerging trends in business intelligence
Overview
7
7
years of professional experience
4
4
years of post-secondary education
1
1
Certification
Work History
Business Intelligence Analyst/Engineer II
Amazon
Pune
10.2022 - Current
- Utilized AWS services for Website Search Analytics, delving into click-stream metadata to decipher customer behavior and establish vital metrics like Search events, Bounce Rates, and Click through rates, thereby amplifying the evaluation of website performance
- Engineered more than 20 Extract, Transform, Load (ETL) pipelines harnessing the power of Big Data technologies within AWS, including Glue, Lambda, Datanet etc
- Orchestrated the analysis of Product Attribute Reclassification, resulting in the discovery of an opportunity generating an additional $25MM in yearly Gross Product Sales
- Implemented Fulfillment Channel Optimization by crafting recommendation analyses that demonstrated potential savings of $121MM in inventory costs through strategic inventory reallocation among different fulfillment channels, with an accompanying increase in inventory turns from 3.4 to 5.3.
Business Intelligence Analyst/Engineer I
Amazon
Pune
10.2020 - 09.2022
- Created multiple business dashboards which helped business leaders track business operations in a timely manner. Enabling this capability helped increase visibility into product/business performance, identify gaps and transform existing solutions which needed improvement
- Built 15+ dashboards and drove multiple analysis covering area across Site Performance, Fraud and Abuse, Supplier performance, Product Setup, Website Engagement etc
- Vendor Imagery: Created entitlement analysis to improve existing process of procuring Product Images. Reduced Time to Site of 50+ suppliers from 19 days to 15 days which added additional $35MM Gross Product Sales to business
- Price Publication and Monitoring Dashboard: Developed comprehensive solution for monitoring price publications on website, encompassing the creation of ETL pipelines, data models, and exploratory data analysis (EDA). Created alarms for identifying any surge or drop in product price points. This capability helped business owners to monitor price point publication issues in near real time. The dashboard helped identify incorrect pricing for 2000 styles and that had an estimated $ impact of 6M inventory cost
- Product Setup Service: Created full-fledged dashboard which drives real time actions in terms of new item setup. This dashboard gives visibility into what items are getting created, what are the attributes being setup, attribute mismatch between systems and supplier specific alarms. Through this dashboard, monthly efforts of 8 days were saved
- Built multiple ETL pipelines by sourcing data from multiple data warehouses. These pipelines drove critical actions in optimizing supply chain operations.
Decision Scientist
Mu Sigma Business Solutions
Bangalore
06.2017 - 09.2020
- Single handedly developed, deployed and maintained Controller Performance Dashboard. This dashboard helped in identifying low performing industrial assets and raised an alert for site reps to take necessary actions
- Performed multiple statistical modelling iterations using various classification algorithms to predict growth of pathogen in the institutional assets for a Leading Fortune 300 Chemical Company.
- Achieved an accuracy of 85%. Proposed solution led to identifying risk of pathogen in real time, alternatively a lab test would have taken 20 days
- Developed Sales Forecasting Model for a leading Chemical Company in US for a total of 21 divisions. Models were built using an ensemble of different Time series techniques - Holt Winters and ARIMAx.
Education
Bachelor of Engineering - Electronics and Telecommunication
Army Institute of Technology, Pune
Pune, India 01.2013 - 04.2017
Skills
Strong Industry and domain expertise
Business Intelligence Analysis - SQL, Python, MS Excel, Jupyter Notebook
Database Management
ETL development
Statistical Analysis and Machine Learning
Data Visualization and dashboard design - Quicksight
Agile Development
Design thinking and problem solving
Project Management and Organizational skills
Strong Industry and domain expertise
Certification
Decision Scientist (Mu Sigma)
Timeline
Business Intelligence Analyst/Engineer II
Amazon
10.2022 - Current
Business Intelligence Analyst/Engineer I
Amazon
10.2020 - 09.2022
Decision Scientist (Mu Sigma)
03-2019
Decision Scientist
Mu Sigma Business Solutions
06.2017 - 09.2020
Bachelor of Engineering - Electronics and Telecommunication
Army Institute of Technology, Pune
01.2013 - 04.2017