Faraz Ahmad Khan
Summary
Dynamic Business Analyst with a proven track record, enhancing supply chain efficiency and driving data-driven decision-making through expert SQL/T-SQL analysis and impactful stakeholder management. Excelled in deploying Power BI and Tableau dashboards, showcasing a blend of technical proficiency and strategic insight.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Business Analyst
Bazaar Technologies
Karachi, Pakistan
11.2021 - 08.2022
- Utilized SQL queries and data analysis techniques to monitor and optimize inventory levels using SQL Server 2019.
- Led the development and deployment of a Power BI-driven business intelligence dashboard, granting stakeholders instant access to critical performance metrics for informed, data-driven decision-making.
- Assisted in the creation of technical documentation including process flow diagrams, use cases, functional specifications, network diagrams .
- Utilized ticketing tools such as ServiceNow and Azure DevOps for tracking progress on open tickets.
- Constructed and sustained interactive data visualization dashboards using Tableau.
- Implemented strategies to prevent stockouts and ensure optimal stock visibility. Managed procurement processes for multiple locations, enhancing supply chain efficiency
Technical Business Analyst II
Pakistan Oxygen Limited
Karachi, Pakistan
08.2021 - 11.2021
- Designed complex SQL queries for retrieval and manipulation of data from multiple sources.
- Conducted market analysis to support strategy planning and project funding.
- Managed communication with cross-functional teams to ensure timely execution of training and project development initiatives.
- Managed communication with cross-functional teams to ensure timely execution of training and project development initiatives.
- Documented business requirements from stakeholders, formulating relevant stories in Azure DevOps.
- Worked closely with IT personnel to identify potential issues before they arise.
- Constructed interactive dashboards for visualizing insights generated from econometric models using Tableau and Power BI tools.
Supply Chain Intern
Sanofi Aventis
Karachi, Pakistan
06.2020 - 08.2020
- Planned and forecasted material needs, scheduled orders, and managed inventory.
- Utilized MS Excel and Power BI to generate reports and dashboards for management review.
- Identified cost-saving opportunities, and recommended process improvements.
- Identified cost-saving opportunities and recommended process improvements.
Finance Intern
Abbott Pakistan
Karachi, Pakistan
06.2020 - 08.2020
- Developed, executed, and evaluated marketing plans to improve on-ground presence for Abbott's products.
- Collaborated with the Finance Planning & Analysis team to identify process gaps and gain a better understanding of the financial planning process.
- Designed the Accounts Receivable / Accounts Payable process for Abbott Nutrition.
- Designed the Accounts Receivable / Accounts Payable process for Abbott Nutrition.
Education
Master of Science - Information Systems
Cleveland State University
Cleveland, OH05-2025
BBA -
Institute of Business Management
Karachi, Pakistan09-2021
Skills
- Data visualization
- SQL / T-SQL proficiency
- Systems analysis
- Microsoft Office Suite
- Software development life cycle
- Reporting and documentation
- Requirements gathering
- Stakeholder management
- Agile and Waterfall methodologies
- Microsoft SQL Server, MySQL
- Tableau, Power BI
- Azure DevOps, Jira
- SAS
- Data analysis
- User acceptance testing
Certification
- ORACLE CLOUD INFRASTRUCTURE
- ORACLE CLOUD DATA MANAGEMENT
Timeline
Business Analyst
Bazaar Technologies
11.2021 - 08.2022
Technical Business Analyst II
Pakistan Oxygen Limited
08.2021 - 11.2021
Supply Chain Intern
Sanofi Aventis
06.2020 - 08.2020
Finance Intern
Abbott Pakistan
06.2020 - 08.2020
Master of Science - Information Systems
Cleveland State University
BBA -
Institute of Business Management
Similar Profiles
Fatima NadeemFatima Nadeem
National Category Manager at Bazaar TechnologiesNational Category Manager at Bazaar Technologies
Ahmad ShoukatAhmad Shoukat
IT Support Executive at Bazaar TechnologiesIT Support Executive at Bazaar Technologies
Umair KhanUmair Khan
Executive Operation (Logistics Supply Chain) at Bazaar TechnologiesExecutive Operation (Logistics Supply Chain) at Bazaar Technologies