Saeed Jafri

Experience

• 

  HBL

  Mar 2012 - Jul 2014

  Software Officer (Report Developer)

  • Involved in gathering the user requirements and developed reports.• Debugged reports and deployed them into the system.• Developed various types of reports that included cross tab, tabular, sub report, matrix, ad hoc, parameterized and cascading reports for all users.• Monitored the performance and optimized SQL queries for maximum efficiency.• Involved extensively with the development team in carrying out the Unit testing of the applications.

• 

  Bci Services PVT LTD

  Jul 2014 - May 2016

  Software Development Officer (BI Report Developer)

  • Designed and managed Half Yearly and Yearly Statements for general accounts, home and car financing accounts as per requirement of State Bank of Pakistan.• Developed, maintained, and managed analytical and operational mission-critical business reports based on Sybase Info Maker, Sybase Power Builder, SQL Power Wabit and Crystal report tools.• Report development highlights: - Reconciliation reports used for Nostro accounts or internal audits. - Analysis reports used to apprehend deposit positioning of corporate and general accounts in Burj Bank.• Performed complex ad-hoc SQL queries for immediate access to data that was required by users.• Provided audit data to regulatory authorities and auditors as required.• Provided end-user training to educate users on technical aspects of extracting reports and their usage. - Accomplishment: Reduced time and made reports more efficient and accurate. Show less

• 

  Burj Bank Limited

  May 2016 - Aug 2016

  Software Development Officer (BI Report Developer)

  • Involved in month-end and year-end closing procedures that included Profit Calculation System- PCS process for easier access and control of data. • Worked intensively with the Core Banking System Team for troubleshooting and solving any issues occurring in the course of routine banking.• Designed and developed reports for identifying U.S. person status and their account details.• Developed comprehensive reports for anti-money laundering – AML team on SQL Power Wabit tool for minimizing frauds and enhancing effectiveness of controls. • Designed and integrated dashboard reports for corporate accounts, their current deposit positioning and comparison on day-to-day, monthly and yearly basis, top 10 depositors.• Maintained different in-house and outsourced applications and services and troubleshot any issues that arose and coordinated with concerned person or vendor to resolve them quickly and effectively. - Accomplishment: Saved the company significant dollars and time that provided easier accessibility to documents. Show less

• 

  Curve Dental

  May 2017 - Oct 2023

  • Involved in the development and improvement of the BI team processes in an agile environment.• Analyzed the data and designed, created, and developed dashboards, reports and KPIs for financial, patients, practice, appointments, and other categories of dental practice.• Wrote complex SQL queries for ETL jobs in Talend and for reports.• Improved and optimized SQL queries for maximum efficiency.• Reviewed the queries and ETL jobs as part of peer review process.• Analyzed the latest trends to improve dashboards and reports as part of UX team.• Coordinated with business, UX team, developers, QA, and other stakeholders to ensure that projects are delivered on time.• Involved extensively in the selection process of new BI solution that included investigating and testing different solutions, presenting them to business and finalizing the new BI solution.• Led the team in deployment of a new solution called Sisense. It involved deployment of the new software, creating data models, designing the dashboards, reports and KPIs in Sisense, testing the content and publishing it to customers. • Worked in the Jira to break up the bigger projects into smaller pieces and complete them in sprints.• Documented the BI processes and specifications of the contents in Confluence.• Involved extensively with QA team to test the dashboards, reports and KPIs. - Accomplishment: Developed insightful dashboards and reports for the customers that helped them make meaningful decisions and saved considerable time. Show less

  • Business Intelligence Developer

    Aug 2017 - Oct 2023

  • Business Intelligence Analyst

    May 2017 - Aug 2017
• 

  Intelident Solutions

  Oct 2023 - now

  Senior Software Engineer