National Bank of Pakistan                     (Jan. 2005 - Till Date)

 (Incharge EDP Audit & Automation Department - AAO Multan)

OG-II/MIS Officer

          Job Description

            Audit Management System:

          I’m administrating the Audit Management System (AMS) in Area Audit Office Multan which comprises 193 branches of four Regions. The major activity of Area Audit Office is to perform audit and report the irregularities to higher management through Area Audit Chiefs. Functions of AMS are as under: -

[                        AMS automates and provides assistance in National Bank of Pakistan (NBP) Audit & Inspection Group activities.

[                        AMS copes with all issues regarding Audit of branches. It provides the complete solution and helps the auditors to record their observations, maintain the related working papers and generate the reports.

[                        System also provide the help on various levels like reporting irregularities, development of Executive Summary, Review the Audit Check List, Key Risk and Objectives related to audit of a particular functional area.

[                        Due to AMS Processing Department in Area Audit Office could easily review, process the reports and report the significant issues to Regional and Head Office Management for monitoring and evaluation of compliance and rectification status.

            Information System Audit:

                   I’m responsible to supervise for Information System (IS) Audit of Regional Computer Center and Main Stack Branches. IS auditing is “The process of collecting and evaluating evidence to determine whether information systems and IT environments adequately safeguard assets, maintain data and system integrity, provide relevant and reliable information, achieve organizational goals effectively, consume resources efficiently, and have in effect internal controls that provide reasonable assurance that operational and control objectives will be met.”

                   Major applications of IS Audit are as under: -

There are about 31 business applications catering to the business information needs of NBP. Applications are categorized into two broad categories: -

1.       AS/400 based Applications

2.       PC based Applications

            AS/400 based Applications:

°       Branch Back Office (BBO) to support both manual as well as PC-Based Branches and to maintain a database of their transactions in the AS/400 server at the Head Office.

 Ã‚°      Weekly Scheduled Telegram (WST) System tracks assets and liabilities of each Branch on a weekly basis and then consolidates branch-wise weekly position of assets and liabilities. The application assists the management to calculate Region-wise Liquidity Ratio, Cash Reserve Ratio and sector-wise circulation of money.

°      Profit & Loss System is used to maintain the records of PLS Account holders for the branches computerized under Batch mode. Each of such Branches reports its daily transactions.

°      Current Account System (CAS) provides facility to maintain the records of Current Account holders for the Branches computerized under the Batch mode. The branches report their daily transactions.

°      Demand Loan System records the details of loans given to NBP employees and maintains the history of such loans.

°      Inter Bank Reconciliation (IBR) System has the basic objective of reconciliation of entries and capturing all types of data of domestic Branches and Head Office, related to this System.

°      Provident Fund (PF) System keeps historical data of employees’ Provident Fund contribution and calculates interest / profit on outstanding balances on a half-yearly basis. This application provides complete record of transactions in the Provident Fund together with details of the outstanding loans.

°      Government Account System (GAS) is used to process the data gathered from the Branches that are involved in tax collection. It generates tax collection reports for Finance Division of the Government of Pakistan and State Bank of Pakistan (SBP).

°      NBP General Accounts’ basic purpose is to maintain data related to general accounts and to generate data for the Inter Branch Reconciliation System.

°      Payroll System is designed to prepare salary of Bank’s employees. This application generates the payroll of the employees.

°      Medical System has been designed to process transactions relating to the medical facilities availed by the employees.

°      Fixed Deposit System has been designed to record the Term Deposits certificates issued by NBP to its customers.

°      Small and Target Loan System is used for maintaining the record of Small Loans sanctioned by NBP in accordance with the targets given by SBP.

            PCB Based Applications:

°      Annual Confidential Reports (ACR) System is used to prepared reports for higher authorities to help them take a decision in awarding prizes, promotion etc. to their employees.

°      Banking Integrated System (BIS) has been developed for automation of the Branches of NBP that are operating in batch processing mode. It is an enhanced version of Branch Back Office (BBO) system that is installed in over 600 Branches. BIS has been designed and developed for Client / Server architecture, using FoxPro v2.6 for DOS, in which the user enters the transactions on the client side. This application covers about ninety percent activities of the Branch.

°      Drafts Payable (DP) is running in almost 600 Branches. It has been developed in FoxPro v2.6 for DOS. Some of the activities of the Branch that run through DP are ï€Â Mail Transfer / Demand Draft Issue, ï€Â Mail Transfer / Demand Draft Payment, ï€Â Receipt of Advice. The database resides on a machine (server) where the executable and program files of the application reside. A client machine accesses this application over a peer-to-peer network. The number of client machines can be set up depending upon the volume of work of the Branch. One client machine is used at the Main Branch. The modules to be installed in the Branch can be configured through the Administrator module of the application.

°      Pakistan Atomic Energy Commission (PAEC) Payroll System maintains the salaries of employees of Pakistan Atomic Energy Commission.

°      Prudential Classified Advances (PCA) System, through this system every Branch of NBP reports the prudential classified advances on many types of formats to respective (Regional Head Quarters) RHQs where the data is entered in the PCA system. This system helps in transferring data on diskettes, CDs or Flash Drives rather than on printing sheets.

°      Foreign Exchange Letter of Credit System (FELCS), NBP’s Branches issue FELCS to their customers. The Branches report their corresponding FELCS to the Head Office and a record of each Branch’s FELC is maintained at the International Division. This record may be Sector-wise, Circle-wise, Commodity-wise and Branch-wise. This system has been developed to provide information of Foreign Exchange Letters of Credit to the State Bank of Pakistan on a monthly basis.

°      Foreign Exchange Reconciliation (FER) System, Exchange Transactions take place in foreign countries either through NBP’s own Branches or through another Bank working as NBP’s agent in that country. This system has been developed for reconciliation of these entries.

°      Foreign Exchange Transactions (FET) System takes place in a branch may be made through DD, MT, TT, etc. The Treasury Management Group at the Head Office gathers this information from NBP’s authorized Foreign Exchange Branches on daily basis. The main purpose of this system is to prepare a daily journal and a daily balance sheet for onward submission to SBP.

°      Foreign Exchange Transactions at Branches System, branches have to report the Foreign Exchange Transactions to Head Office on daily basis, which is done through this application and submitted to Head Office on diskettes/CDs or Flash Drives.

°      Transport Information System is used to keep record of any type of information pertaining to Bank's vehicles like purchases, sale of vehicles, claims, etc.

°      F-47 (Profit & Loss Account) System is used to provide and maintain Profit & Loss Account of Bank's Branches and their respective Zones at Head Office.

°      F-48 (Balance Sheet) System prepares the balance sheet of Branches and Zones, on prescribed format, at Head Office.

°      Liabilities & Assets System is being used for collecting information of assets and liabilities of Branches through Zones at Head Office. Moreover, it compiles various reports about the Bank's assets & liability position on monthly basis.

°      Haj Balloting System is used for drawing names of staff of the Bank for performing Hajj on Bank’s expense.

°      Hajj System is run on Hajj booths allocated for providing facilities to pilgrims going for Hajj. The main purpose of the system is to calculate Foreign Exchange quota for each pilgrim.

°      Foreign Exchange Vouchers System, the Bank has made agreements with some Foreign Exchange Agencies to act as its agents in the foreign countries.

°      Audit Memo System is to preserve audit reports of different Branches for future reference.

°      Credit Information Bureau System assists the Credit Group in collecting information on monthly basis for the borrowers.

°      Cheque and Payment Order System, all Payment Orders and cheques, issued by the Finance Group, are printed through this system. Daily data is merged in the payment history, which is maintained in the system for future use.

°      National Investment Trust System keeps track of the dividends awarded by NIT to its customers through the NBP’s Main Branch. Different summary reports are generated on a daily basis.

°      Auto Deal, Money Market and Securities Trading System (ADAMS) is the core business application for automation of Treasury Operations at the Bank. The application provides on-line real time computing environment with parameterized controls. The application also provides complete integration of front, middle and back office functional units with Branches, and effective controls and reporting structure of Treasury Operations of the Bank.

Haseeb Waqas Group of Companies  (Dec. 2001 - Jan. 2005)

(Software Engineer)

          Job Description

          I developed following Projects:

·                     Accounting System:

          Supervised the development of an Accounting System using Developer6i and Oracle8.1.7 as Back-end, which covered all accounting requirements of all companies of the Group.

·                     Fixed Assets Management System:

                   [       The main purpose of this system to keep the complete record of assets of all companies of the Group. I have managed all aspects e.g. depreciation, addition, disposal, partial disposal, addition and current book value of assets.

·                     Share Management System:

                   [       Share Management System manages the in-house share registrar services e.g. complete information of shareholders and transfer of share certificates, splitting & merging certificates, pattern of shareholding, beneficial ownership, dividends, bonus shares, right shares & zakat exemptions etc.

·                     I was responsible for decision making reports, warehouse management reports, analysis and write down feasible reports for new and old systems.

·                     I was also responsible for conversion and technical support of existing applications.

Environment:

          Oracle8.1.7, Developer6i, MS Windows 2000

Vision Consulting Limited                   (June 1999 - Dec. 2001)

(MIS Incharge)

          Job Description

·                     Installation of equipment and software in the offices of the Company and clients.

·                     Coordination between Company and clients.

·                     And I was responsible for conversion and technical support of existing applications.

·                     I was involved in the analysis, design and development of “My Office Accountant” an online accounting system for small medium and large firms. My Office Accountant system built from the ground up for the Internet.

          My Office Accountant Environment

          My Office Accountant system’s online solution revolutionizes the way you do business, through: -

·         Anytime/anywhere access. Unlike traditional accounting software, you can securely review and interact with the My Office Accountant System from any Internet-connected computer—at the office, at home, or on the road—at any time, day or night.

·         Self-service connectivity. Give employees, clients, customers, vendors, bankers, auditors, and other designated personnel the level of control you specify, enabling them to enter transactions, review reports, and track business processes on their own from wherever they are located.

·         Collaborative accounting. Work online with a virtually unlimited cast of business participants in any number of different offices or cities. All parties can view and interact with the most current accounting data and reports—simultaneously.

Environment:

          Oracle8.1.7, Developer6i, Rational Rose, MS Windows 2000

Skill Set:

            Languages:

         · PL/SQL, Java, UML, C++, Visual Basic 6.0

Databases:

         Ã‚· Oracle8.1.7, MS SQL Server, MS Access

Software Packages:

         · PowerBuilder7.0, Rational Rose, JDK1.3, Java Web Server, 

           Dreamviewer4. Jbuilder3.0, Tomcat, JpadPro3.7, Adobe 

           PageMill3.0, NetObject Fusion4.0, MS Project.

            Operating System:

           Ã‚· MS Windows 95/98/2000, MS Windows NT, Window XP

             Professional