Farhan Shaikh
@farhanshaikh1
Financial analyst leveraging Excel and Power BI to drive smarter decisions.
What I'm looking for
I’m a results-driven financial analyst with 10+ years of experience in data management, reporting, and credit analysis within banking. I combine disciplined data work with practical business insight to help stakeholders make faster, more accurate decisions.
At National Bank of Pakistan, I’ve led portfolio monitoring and review by generating monthly and quarterly reports for Technology Upgradation Fund (TUF) and SME Finance targets. I use advanced Excel (PivotTables, VLOOKUP, macros) to optimize reporting accuracy, and I’ve supported regulatory compliance by coordinating with SBP and the Ministry of Finance during audits and reporting.
I also strengthened how data is handled end-to-end—gathering and cleansing General Ledger (GL) data and improving reliability by 30% through consistent validation techniques. Earlier, as a Relationship Manager in the SME division, I streamlined MIS reporting, delivered executive summaries with key financial insights, and reduced manual entry by 40% while boosting reporting accuracy.
Before that, as a Credit Officer in Retail Credits, I performed creditworthiness evaluations and industry risk analyses and managed a credit portfolio worth Rs. 350Mn. In parallel, I’ve worked on freelance analytics—building KPI dashboards for a strategy simulation and developing an NPV model that translates scientific risk into monthly cash-flows with a risk-adjusted return at an 11% discount.
Experience
Work history, roles, and key accomplishments
Senior Relationship Manager
National Bank of Pakistan
Jan 2017 - Present (9 years 4 months)
Produced monthly/quarterly TUF and SME-target reports using advanced Excel (PivotTables, VLOOKUP, macros) to improve reporting accuracy. Managed GL data cleansing and validation, increasing data reliability by 30%, and coordinated with SBP and the Ministry of Finance for compliance in audit/reporting processes.
Freelance Financial Analyst
Freelance
Built a 5-round strategy simulation to stress-test AI vs. human-only teams, tracking ROI, leverage, and market share in real time. Engineered KPI dashboards and round-by-round analytics that converted 1,200+ data points into go/no-go recommendations and developed a 9-year NPV model for an anti-infective drug program using risk-adjusted returns at an 11% discount rate.
Relationship Manager - SME
National Bank of Pakistan
May 2014 - Dec 2016 (2 years 7 months)
Led MIS reporting for SME financing, improving visibility into SME portfolio performance through streamlined data aggregation. Implemented data tracking and reporting improvements that reduced manual entry by 40% while boosting reporting accuracy and supporting executive decision-making.
Credit Officer - Retail Credits
Bankal Habib Limited
Sep 2008 - May 2012 (3 years 8 months)
Performed creditworthiness evaluations and industry risk analyses while managing a retail credit portfolio worth Rs. 350Mn. Designed custom credit exposure reporting and supported credit approval report development and annual exposure reviews for scheduled reporting.
Education
Degrees, certifications, and relevant coursework
Institute of Bankers Pakistan (IBP)
Banking Diploma (JAIBP), Banking
2019 -
Completed the JAIBP Banking Diploma program from the Institute of Bankers Pakistan in 2019.
University of Karachi
Master of Commerce, Commerce
2007 -
Earned an M.Com (Master of Commerce) from the University of Karachi in 2007.
University of Karachi
Bachelor of Commerce, Commerce
2005 -
Earned a B.Com (Bachelor of Commerce) from the University of Karachi in 2005.
Availability
Location
Authorized to work in
Job categories
Interested in hiring Farhan?
You can contact Farhan and 90k+ other talented remote workers on Himalayas.
Message FarhanFind your dream job
Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!
