Ahsan Khan
Skokie,IL
Summary
8+ years of experience in Business Data Analytics , Information Technology IT, Agile and Lean Manufacturing. Impactfully analyzed large data sets and coming up with data-driven insights for technology companies and business enterprises. Worked in teams of 8-12 team members emphasizing and showcasing communication, hard work, leadership, analytical and critical thinking as the KPIs of success. Ready to meet, exceeds business goals, requirements and expectations.
Overview
9
9
years of professional experience
2
2
Certification
Work History
Business Data Analyst
Freelance
Chicago, IL
02.2020 - Current
- Implemented a metrics-driven approach to evaluate customer service performance; created and tracked 10+ KPIs, resulting in a 20% decrease in average response time and a 15% increase in customer satisfaction using Excel by creating and maintaining dashboards, metrics, pivot charts, and KPIs for an a business.
- Spearheaded the development of Excel and Tableau dashboards for an ecommerce startup; delivered weekly sales and marketing updates and increased online sales by 20% in 6 months.
- Create, build and maintain SQL and NoSQL databases, data systems, and analysis of data reorganization in a readable format by analyzing the data to determine its quality, meaning, effectiveness and impact.
- Achieved 87% accurate machine learning model prediction rate using different statistical models after sorting, filtering, cleaning, organizing and validation of input data using Python's visualization, data analytical and machine learning package libraries: Pandas, NumPy, Matplotlib, Scikit-learn and Seaborn.
- Provide analysis reports helping business stakeholders to understand data analysis and visualization steps aiding them in important business decisions based on various facts, trends and analyses.
- Provided evaluative judgment based on analysis of information in complicated and unique situations and contributed to formulation of standards and strategies for functional areas.
Manufacturing Systems Analytical Tech
Abbott
Gurnee, IL
02.2021 - 02.2023
- Troubleshooted data coming from different machines by analyzing Excel files and using other tools for diagnostic, testing, analysis, data collection, visualization purposes for KPIs improvement ,progress and performance tracking.
- Reported data and analyses using IBM Maximo and Microsoft Excel to conduct measurements specified in design verification plans, documentation, and tabulate results, providing engineering test reports in order to develop countermeasures and corrective actions.
- Volunteered extra hours for 3+ months helping the company in achieving its business goals and requirements.
- Studied 10+ product manuals and technical documentation of 200+ pages each which includes every functional aspect of the product, including common issues, technical diagrams, aiding in Root Cause Analysis (RCA).
- Applied Agile, 5s, Lean Six Sigma, and other relevant principles in order to improve efficiency of maintenance processes & data collection.
Service Analyst Associate
Walmart
Skokie, IL
08.2014 - 01.2021
- Reviewed incident and request ticket queues and provided prompt service, investigated root causes and created defect tickets (60+/wk).
- Analyzing and Troubleshooting computer desktops, laptops, and printers hardware and software with a focus on Windows and Linux.
- Managed and maintained Fujifilm computer database to keep track of orders and supplies and make sure there were no issues with optimization of customer orders when they came to pick up their orders.
- Supported company operations and growth by volunteering extra 100+ hours every year.
- Customer requirement prioritization was achieved by trained newly hired associates by emphasizing visualization of customer service as the Key Performance Indicator of success.
- Worked with engineers and technical staff to recommend hardware and software adjustments and resolve design flaws.
Education
Bachelor of Science - Computer Science
University of The People (UoPeople)
Pasadena, CASkills
- Excel ,SQL and Tableau
- Agile
- Python
- Data/Business Analytics
- SQL
- Microsoft Excel
- Tableau
- KPI Dashboards
- Data Visualization
- Problem Solving
- Machine Learning
- Data analysis
- Predictive modeling
- Business process mapping
- Strategic planning
Certification
- Google Business Intelligence Professional Certificate
https://www.credly.com/go/AjiKaaOs
- IBM Data Analysis & Visualization Foundations Specialization (V2)
https://www.credly.com/go/29fOFHhR
Timeline
Manufacturing Systems Analytical Tech
Abbott
02.2021 - 02.2023
Business Data Analyst
Freelance
02.2020 - Current
Service Analyst Associate
Walmart
08.2014 - 01.2021
Bachelor of Science - Computer Science
University of The People (UoPeople)