FKK0
Fawad Khurram Khan
House 1978, Precinct 12, Bahria Town Karachi.
- |
Date of Birth: 12/12/1997-linkedin.com/in/FawadKhanIBA
Summary Statement
I am eager to contribute and positively impact society. Through my learning and experiences, I always aim to
deepen and broaden my existing knowledge and skill set, working to constantly increase my value.
Academic Qualification
Power BI Data Analyst Associate
MBA
Microsoft Certification
IBA, Karachi
BS Accounting & Finance
IBA, Karachi
3.21 CGPA
2020
Inter (Pre-Engineering)
Adamjee Govt. Science College
85.33 % (A+)
2015
--
Skills
Power BI | MS Power Platform | Python Visualization | Figma (UI Design) | MS Access | Adobe Photoshop
Work Experience
Aga Khan University
Since Nov 23
Specialist, Risk Management Department
Data Analyses & Reporting
• Created dashboard showing AKU-wide risks, bifurcating them by entities, departments, risk ratings etc.
regularly presented to president and the board of trustees.
• Automated the cleaning and transformation of the risk register keeping relevant data, mappings and
formatting.
• Managed the RSM 4Risk system upgradation project (project plan, scope, timeline, software mapping and
data migration) and trained the users to operate the system to manage their relevant risks.
Departmental Operations
• Conducted meetings with AKU-wide managements to understand their perceptions of the risks they face
and discussing and finalizing the validity, likelihoods, root causes, intensity, actions and internal controls
for these risks.
Graduate Trainee
Discovery
Phase
Nov 21-Feb 22
•
•
•
•
•
•
•
•
•
•
•
•
Nov 21-Nov 23
Financial Budgeting
& Planning Office
Feb 22-Aug 22
HR Business
Partners Office
Aug 22-Feb 23
Data Analytics
Office
Feb 23-Aug 23
Chief Nursing
Officer’s Office
Aug 23-Nov 23
Data Analyses & Reporting
Created Power BI dashboards for various departments including HR, IT and Finance.
Identified and tracked KPIs for hospital as well as respective departments.
Created and maintained an excel-based hiring tracker to maintain the recruitment KPIs of the HR
department, made user friendly by automating using advanced features like VBA, Named Ranges etc.
During IT rotation, assisted various departments in data extraction, dashboard creation & management.
Communications
Created quarterly newsletters for the Nursing Division, highlighting their crucial role.
Beautified existing dashboards and made their UI/UX more interactive, professional and user-friendly
using tools like Figma and Power BI built-in functionalities.
Made various presentations to hospital leaders throughout my journey including
• ‘Increasing Employee Engagement through Low-cost/ No-cost Initiatives’ to VP HR
• ‘Cost/Benefit Analyses of Nursing Scholarships at AKU’ to the Chief Nursing Officer
During HR rotation, served as the focal person for user departments for staffing data and hiring requests.
Departmental Operations
Finance Worked with health industry experts like Advisory Board to create an industry comparison of AKU
with respect to its US-based peers in terms of financial and volumetric ratios while also highlighting the
due considerations for such comparison.
Business Analyzed trends of AI usage for hospital operations globally and the ways we can leverage
relevant tools to gain a competitive cost advantages especially for the work-intensive nursing area.
Business Carried out exploratory and statistical data analyses on the patient demographics, patient visit
times, and seasonal patterns along with key recommendations for operational improvements for the CEO
while at Data Analytics Office.
HR Carried out onboardings/exit interviews/employee engagement activities during HR rotation.
Slide 7
FKK0
U
Fawad Khurram Khan,-T05:17:44.318
A. F. Ferguson & Co.
Jun 20-Nov 21
Assurance Department
• Part of the assurance team that audited K-Electric's receivables in line with the NEPRA regulations and with
implications on the country's circular debt crises.
• Headed the team that coordinated with various survey agencies to document proofs for the above
engagements.
• Conducted various cash and inventory counts for banks/companies.
Internships
Lucky Cement Ltd. (Treasury Department)
Dec 19-Jan 20
• Prepared calculation models of Islamic financing ratios, banking exposures and asset valuation
• Presented findings on best Shariah-compliant short-term investments for the company in the Treasury
Department.
Signify Pakistan (Tax & Treasury Department)
Jul 19-Sep 19
• Made invoice templates, bank reconciliations, calculated income tax on imports.
• Organized a CSR event in coordination with HR dept. at Kashif Iqbal Thalassemia Care Center.
State Bank of Pakistan
Research Enumerator, Research Department
• Surveyed CFOs of 100+ listed companies in Pak for gauging overall business confidence.
Aug 18-Apr 19
Major Projects / Extra-curriculars
Major Projects
• Carried out various statistical analyses using Python and Jupiter Notebook as a platform as part of Business
Intelligence course.
• Created a detailed marketing plan for a new granola bar product including primary & secondary market
research, 4 Ps, branding & budgeting as part of Marketing Management course.
• Made a report on the stock valuation of Colgate Palmolive and predicted its outlook as part of a Business
Finance Project.
• Made use of a wide variety of research tools and resources like Passport by Euromonitor, JSTOR journals, FT
Markets Data, Refinitiv Eikon DataStream and World Advertising Research Centre (WARC) as part of
resources provided by the university.
• Interviewed renowned corporate trainers & HR personnel and conducted secondary research to prepare a
report on modern recruitment practices followed globally and locally in various industries.
• Presented solutions for a real-life case study of Inventory Management issues at GSK Pakistan’s warehouse.
• Made financial models and forecasts for biggest corporations in Pakistan like Lucky Cement, Fatima Fertilizer
and Millat Tractors as part of projects.
Extra-curriculars
• Regularly participated in sessions of KHI Toastmasters Club, ICAP Chapter during time at A.F. Ferguson & Co.
• Mentored and gave Power BI trainings to interns at AKU placed in various departments.
• Volunteered as an organizer in Flood Relief Donation Drive at the AKU main campus, raising millions in
donations.
• I enjoy playing cricket, badminton and table tennis and look forward to swimming occasionally.
