Rafiq Ramzan Ali

Experience

• 

  Soneri Bank Limited

  Mar 2003 - Oct 2005

  Junior Officer Finance

  Worked as a Junior Officer in the Finance and Accounts Division of the Bank. Major assignments/responsibilities were:★ Reconciliation and maintenance of records of bank’s investment in Shares, Mutual Funds, Term Finance Certificates, Equity Investment Transactions (Badla/COT), monitoring return thereon, liasing with stock brokers for settlement under T+3 system and its weekly reporting to the central bank..★ Revaluation of marked to market (MTM) securities and passing its journal entries.★ Monthly preparation of branch wise administrative expense report of bank, its comparison with monthly budget and reasons for variances.★ Collection of data from branches for consolidation and its reconciliation for statutory accounts, credit rating and for calculating CAR (Capital Adequacy Ratio).★ Preparation of general vouchers of daily transactions i.e. sale and purchase of shares, COT, revaluation, inter branch transactions and their posting using SONAWARE (core banking system).★ Designed/administered following databases using MS-Access:1. Soneri Bank Employees’ Provident Fund System (Administered only)2. Quarterly Report of Condition (Administered only)3. Office Check List4. Branch wise Administrative Expense Recording System5. LIMS (Library Information Management System) Show less

• 

  United Bank Limited

  Oct 2005 - Jun 2012

  A lead role in implementation of Oracle Hyperion Planning® application, Essbase and Hyperion Financial Reporting (HFR) for budgeting, forecasting and its reporting needs of the bank and liasing with consultants for entire implementation of Hyperion and post implementation changes.Hyperion Planning:==============★ Preparing 6+6 (6 months actual+6 months forecast), 9+3 forecasts, budget at bank level & individual business units and defining budget drivers forming basis for budget. ★ Overall administration of the application which includes necessary system changes and set up required to initiate and manage budget process i.e. setting substitution variables, running required business rules (BRs) and copying actual data for budgeting. ★ Creating forms for users for entering forecast & budget data, assigning user access rights and assigning event based business rules with forms. ★ Creating & provisioning users, assigning them required roles, maintenance and security of metadata. Creating and maintenance of different versions of the budget including final version. ★ Creating and maintaining alias tables for reporting Islamic and conventional bank reports. Providing end user training analysis support as needed.Essbase:=======★ Creating, launching, editing business rules & calc scripts used for data clear, data copy, aggregation, allocation, reporting currencies, calculating default outline calculation, custom calculations. ★ Maintaining & creating substitution variables required for running business rules for actual & budget data aggregations and calculations. ★ Maintaining security of business rules & calc scripts and creating RTPs (Run-time prompts). ★ Daily data backups and restoring backups. ★ Creating data load rule files and loading data into Essbase. Show less Hyperion Financial Data Quality Management (FDQM):========================================★ Monthly loading of actual data of domestic & overseas operations from ERP application and ensuring validity and integrity of data from source system. ★ Creating locations script, import groups & periods to import specific data performing data validations. ★ Maintenance of metadata mapping tables. ★ Creating rules for data import transformations.Hyperion Financial Reporting:=====================★ Creating standard financial reports for difference business units and on total bank level. Working with business users for gathering requirements of new reports and/or enhancement in available reports. ★ Creating reports with drill-down functionality for further analysis by business users. ★ Setting POV members and performing calculations as per reporting requirements. ★ Creating budget book of related reports which contains budget numbers at business units and bank level.Hyperion Smart View:================★ Creating fully automated dashboard controlled, custom formatted and user-friendly reports on MS Excel using Smart View add-in and power of Excel VBA for financial review presentation slides. ★ Creating ad-hoc interactive reports for quick variance analysis by performing drill-down functions. ★ Creating automated ratio analysis and related graphs on bank-level. Show less For the purpose of productive MIS functions, Oracle Financial is used to provide analytical, accurate and timely information and to upgrade and automate the reporting system in the Bank. Major assignments were:★ Designing reports on Oracle Financial for end users according to their requirements and generation of reports using Oracle Application Desktop Integrator (ADI) for management review, providing reports to respective business units and responsible for their queries by doing drill down functions.★ Preparing MPR (Monthly Performance Report) for monthly financial review of management which includes Balance Sheet, Profit & Loss Account and other statements of all business units (including overseas operation), passing necessary adjustments to adjust the profitability/position of various businesses.★ Monthly preparation of key figures of all branches of Commercial Banking Business at region, district and branch level.★ Preparation of profitability reports of bank’s products like UBL Wallet, Hamrah, Tezraftaar, Click N Remit and loss making branches.★ Other operations like opening of new account codes in the in the Model Chart of Account, their mapping, creation of new groups/rollups and ensuring data integrity using Oracle Financial and CDB (Central Database) on Oracle Discoverer. Show less

  • Finance Officer

    Jun 2009 - Jun 2012

  • Officer Finance

    Jan 2009 - Jun 2012

  • Officer Finance

    Oct 2005 - Dec 2008
• 

  Soneri Bank Limited (Central Office)

  Jun 2012 - Apr 2016

  Financial Planning & Analysis (FP&A)

  A lead role in liaising with consultants in entire implementation of Oracle Applications i.e. Oracle Financial General Ledger (OFGL), Oracle Hyperion and OBIEE (Oracle Business Intelligence) & Oracle Hyperion Planning by analyzing reporting needs of the bank, coordinating with consultants & IT Division, performing UATs and post-implementation changes, production of monthly MIS and other analytical reports from OFGL, analysis of business results and providing workable solutions to the bank with respect to the reporting requirements.★ Key role in the monthly financial close process, including month-end journal entries preparation and account reconciliations.★ Handling activities pertaining to the daily cycle for the production of various MIS reports (Balance Sheet, P&L & Admin. Expenses) on OFGL and reports distribution to respective users.★ Maintaining hierarchies, mappings and responsible for execution of monthly FTP & cost allocation rules on OFGL to present correct profitability positions of branches.★ Working with IT division to identify and resolve data, system and process issues on ad hoc basis to ensure data validity and reporting reliability.★ Preparing monthly customer, branch profitability and Mancom (Management Committee) presentation slides.★ Created and administering software application for branch-wise automated distribution of OFGL reports to individual branches through e-mail.★ Responsible for maintenance of primary and secondary ledgers, accounting setups, calendars, periods and budgets.★ Quarterly Peer Bank/Bench marking Analysis.★ Analyze current processes for process improvements and automation opportunities, prepare and implement recommendations to increase efficiency. Show less

• 

  United Bank Limited

  Apr 2016 - Dec 2016

  Senior Business Analyst

  Working as a part of team providing support of core banking system (Symbols) globally. Major responsibilities are as below:★ Liaise with business and development teams to provide system solutions according to business or regulatory requirements, ensure solutions delivered are sound to meet those requirements and getting UATs signed-off.★ Troubleshoot issues identified by business to identify problems and coordinating with end users towards resolution. ★ Analyzing report requirements and creating operational reports for users. ★ Assisting in management of static data which is used to set parameters at bank level and creating accounting entries based on the defined events.★ Creating SOPs to ensure consistency and getting approved from respective business area. ★ Preparing flow charts and presentations for existing business workflow.★ Corresponding with vendors and Pakistan Software Export Board (PSEB) for payments pertaining to maintenance contracts and change requests (CRs). Show less

• 

  HBL - Habib Bank Limited

  Jan 2017 - now

  Senior Manager Finance Systems