Qazi Usman Shahid
H/No *** Main Road Sector H, Phase 8
Bahria Town Islamabad.
Cell: +92-345-*******
E-mail: ad3x0t@r.postjobfree.com
WORK HISTORY
Askari Bank (Information Technology Group)
Global shared services, GSS
Telenor, Pakistan
Mobilink, Orascom,Islamabad
Assistant Vice President Application Management and Manager Oracle ERP
Duration: Jun-2015 till Today
Implement of Oracle ERP Module and build ERM interface DWH.
Providing support and administration of Post GO-LIVE
Implement OFSAA Basel and Market Risk.
ALM/LRM data warehoused from different sources, Flexcube, ADAMS, WEBTECH, Credit Cards, Lease, oracle Financial
for data to be analyzed in ALM/LRM.
Work as Project manager to gather information from RISK team department and deploy the solution
ALM
LRM
Market Risk
IFRS16
FTP
Year end/Month end EBS closing in Bank
Assist in year end month closing by providing ad-hoc reports and reconcile data of different data in bank
NexCash and ACMS Digital Payment solution
Gather requirement from Corporate and retail business and deploy the customized digital solution for payments, utility bill, collection that include schools, Corporate companies across country
Managing DR DRILL for different solution across the company
Managed Oracle Web Service INTERFACE with Oracle Fexcube using RT service with SOAP Request.
Implement oracle property manager IFRS compliance in Bank to document 500 leases and its payment. Project has been successfully deployed.
Upgrade Oracle financial 12.1.1 to 12.2.9 and database to 12 to 19 C
Part of team in upgrade project, Assist vendor in requirement gathering with in different department in organization and deploy project within timelines
Customization of Withholding tax for vendor on New tax in Oracle Financial from Property Manager to Payables ordinance i.e slab wise for property manager leases exported to payables
UAT Regular meeting with business in order to provide best solution and complete UAT for different project within Organization to successful go-live
BI Publisher (RTF file)Custom report development in ebS to fulfill business requiremennt
SQL * Loader to load huge number of asset for Islamic banking in eBS
Can handle huge file in SQL loader
Manage Workflow/AME for Payables, GL and made different approval group for approving of Invoice and JV based of operating unit, amount etc
Year End reconciliation in Handling Large data in Oracle GL to AP, FA, PO to assist end user to timely closing of books
Technical document using MD 70, MD 50 documentation. In addition high level design,functional design, technical document and project plan for different project are made and archived in organization Library.
Oracle support. Managing and administration ebs AP,GL,FA,PN,PO,Inventory) module and provide support first line support as per agreed SLA with business. Creation of SR with Oracle and deploy solution within timelines
Implement New company/Ledger setup in Ebs for Islamic ledger in Askari Bank
Management of ERP across Bank and administration of ACMS application across 400 bank branches by implementing projects and strong customer relationship.
Managing development team and DBA team to successfully implementing projects.
Managing vendor and stakeholders.Implemeted Oracle upgrades
Project manager/Team Lead OBIEE. Managing support and development Global OBIEE solution, Global ERP Project, Norway
Working as ERP Specialist and Project Manager in Telenor Shared service
Duration: Sep-2007 till Jan-2015
Working as ERP Team Lead and Senior Software Development ERP in Orascom, MOBILINK.
Duration: Feb-2005 till Aug-2007
Levington Technology
Working as IT consultant, from Jul 2002 to 01-FEB-2005. Being part of Levington Technology and team lead for my department, I have successfully completed many projects
Duration Jul 2002 to 01-FEB-2005
Future Component
Solutions
Worked with FCS as a Developer
Duration May 2000 to 01-JUN-2002
Mobilink, Islamabad
Six Month Internship in Mobilink IT Department
Duration Dec-1999 to Jun-2000
WORK EXPERIENCES
Askari Bank (Information Technology Group)
Telenor Shared Services Center
Mobilink,
Orascom, Islamabad
Project Manager Implementation of Property manager and Oracle eBS up gradation to 19 C and 12.9
Ferguson is implementing PM and EBS upgrade to 12.9 . Database migration to 19C
Develop Project planned keep track key of deliverables
Communication across Project Team member and Project Implementation
Provide PM Team effective workplace.
Assist PM to coordinate with database team and super user and key stakeholder.
Keep update and communicate to key state holders.
Develop customized Property manager reporting
OFSAA ALM module implementation (Treasury/RMD)
Implement OFSAA ALM asset liability module in Organization to assist RMD and treasury
Working knowledge in Flexcube of customer data, its limits, Customer lending data, Contract details (funded and non-funded), outstanding balance, markup position
Assist treasury and Risk department in customized solution like WEBTech and ADAM for Foreign currency and Trading
LOS Loan Originating system
Implement LOS system in organization
Project manager of Implement Oracle module AP,FA,GL, PO for Islamic Ledger
lead the full implementation by managing and implement oracle module.
Lead the technical customization of Project
Lead the technical team for project.
Project Manager of Migration of bulk Assest using Oracle API in Askari book code
It involve 50,000 asset in which expene code, unit, assignment and location has been changed by using Oracle API transfer
Manager ERP & Support Cash Management Solution
Administration and Managing Oracle ERP.
Implement Oracle AP,AR,CM,FA,GL interface
Migration of Assets from external source into Oracle Fixed asset
Oracle Payables interface to import Rent Invoices
Provide pre and Post month support.
Managing Month end closing and team to develop in house software development and Oracle RICE to facilitate different department in the Organization.
Provide automation to different department in Organization by analysis their day to day needs.
Implement the Askari Islamic ledger by Implementing AP, Gl, FA and PO. Implement day end, month end process.
Managing and providing support to customized ACMS application
That is cash management solution implemented in all bank branches
Create and close SR at Oracle to close month activities.
Management of Development team, DBA to deliver smooth deliveries
Strong communication skills and customer support.
Management of ACMS application in bank by implementing payment solution of various companies like DHA, utility payment and many more
Team lead and Service delivery Manager OBIEE (GLOBAL ERP Project, Norway)
Provide support and development deliveries for Global OBIEE Business unit, which include Bangladesh & Telenor Pakistan.
Mentors Team member and help them in their daily routine task.
Manage the delivery as per Service KPI
Monitor GP and TP support service
Develop customer and vendor relationship effectively by working on JIRA application
Assure and improving the quality of deliveries.
Coordinate team efforts for implementation, support of OBIEE.
Supervise the Technical activities.
Presentation to GERP BU of OBIEE solution Dtac, Serbia.
Proven analytical and problem solving skills
Good understanding of Oracle business process
Good understanding of Oracle Financial Module
Good communication skills (oral/written)
Oversees the development of and executes the deployment plans for the customer, including new solutions development, assessment of option from vendors, etc., owning the results/solutions from end-to-end
Maintaining and coordination of Incident and request in Service desk effectively for TP & GP.
Maintaining and analyzing the Change Request (CR) in ESD, execute the development, deployed and UAT plan with end user.
Arranging meeting with end customer on daily basis, helping and providing support on month end closing. (MEC)
Act as first point of contact for escalation of issue, coordinate with customer to facilitate and resolve issue.
Maintain and arrange 24/7 support in case of severity level issues.
In depth knowledge of business process and can identify the root cause of critical issues
Service Delivery Manager for Serbia (Global ERP Project)
Presentation to customers on OBIEE solution, understanding their business need, perform the GAP analyses, Make plan for development work
CPM and OBIEE report analysis for Bangladesh, GP rollout
Reporting analysis of Global first rollout, Bangladesh which includes P2P, O2C,R2C, R2R property Manger.
Implement the Property Manager for Telenor Norge in Telenor Group
Global ERP Project in Telenor Group of companies
Part of Implementation team to implement R12 in first roll-out Bangladesh.
Gathering requirement from BU and designing process to implement the solution.
Part of Application team to do As-Is in Bangladesh which include RICE document to show Integration, Customization, Reports, Forms.
Suggests the solution to provide standardize process for BU on the Global Level process.
Maintain good relationship with Vendor.
Global Pre-ERP Project, Norway
Designing Oracle Process (procure to pay P2P, Receivable to Case R2C,
I-expense, Property manager, record to report R2R) using best industry practice in Telenor Group to make standardize process for group.
Part of Technical Integration team to implement Oracle interface using Cassini and Oracle Bpel.
Service Management Specialist.
Develop report of service line finance incident and change request and present monthly report to higher management.
Extract report from service line Help desk application for IT management.
Managing and support service line of Finance department as per agreed SLA. Handle team to resolve incidents and coordinate with 3rd party vendor, Teito. Handing change request and escalation of Finance service line.
Provide Application support in Telenor group of Oracle Financials that include AP/AR/GL/FA/PO.
•Help and support new user in entering Invoice and payment in AP module. Loading bank statement in CM. entering Transaction and receipt in AR. Support end user in closing of Month end in GL/AP/AR and FA.Support end user in entering PR and entering receipt.
•Conduct in house end user training session and prepare user manuals
•Develop & Manage project plans for Projects.
•Gathering User requirements and specification, informing about timeline and implement the solution.
•Define new business processes.
•To coordinate and manage SIT (System Integration Testing) Team and UAT (User Acceptance Testing) Team.
•Coordination and interaction with releases with CM (Change Management) team & RM (Release management) teams of Teito,
Support Vendor.
•Maintain the vendor’s (Tieto) relationship
•Conduct training session for end users to ensure the correct and proper use of business systems.
• Oracle personalization to assist end users in smooth line business process.
•Expertise in Design, Development and Customization of RICE (Reports, Interface, Data Conversions and Extensions/Customization) using SQL, PL/SQL, UNIX Shell scripts and SQL*Loader
•Part of Team in implementing Oracle Project in Telenor
•Moved the custom code, discoverer reports to test instances, production using FNDLAOD
•Registered Concurrent Programs and Request Sets in AOL and System Administration
•Involved in the reconciliation of data migrated
•Database development included writing PL/SQL stored procedures, triggers, cursor and functions.
•Ensure end-user satisfaction and new requirements to be met in a timely manner within the cost projections and with quality
•Support implementation of Software including development, testing and roll-out.
•Support the Problem Notification process including development of fixes, testing and implementation.
•Implement the systems using the approved Methodology (including analysis, design, writing functional specs and testing)
•Evaluating projects for implementation including developing and business cases
•Develop Discoverer Reports
Project Manager/Technical Lead of AP Interface
The Interface is to load commission Invoices for AP in quick time and facilitate end user to perform month end activities efficiently. User can load
bulk of invoice by just running concurrent program
Project Manager of Interface Project between Point of Sale and Account Receivable
Project has been deployed in production and its up and running.
The project is about to load AR transaction, its account and Tax using Auto-invoice and AR Import program. Which include to setup Auto-invoice and project documentation and covers all the D1, D2, D3, D4 Telenor project methodology.
Project Manager/Technical Lead of Cash Management Interface
The project is to upload customized Bank statement file into Cash management which facilitate user to mage Auto reconciliation process faster and reporting to make higher management reporting effective. Project which Include designing, execution, implementation and testing phase (UAT). Swift940 and BAI2 format can also be loaded in CM.
Part of UAT team of Atlas upgrade project in Telenor group
Telenor has methodology of release to cater any issue in Oracle production server after passing System integration (SI) testing and User acceptance testing UAT. Organize end user training to perform testing and implement the solution in release
Implement the iSupplier Portal
Part of team to Implement the iSuppler portal in Telenor group in Norway.
Configuration setup in system administrator to enable it.
Create supplier user who can view Invoice, PO and payments.
Working knowledge of iProcurement.
Oracle iProcurement is the self-service requisitioning application that controls employee spending. Oracle iProcurement provides a Web-based shopping system that allows employees to create, manage, and track their own orders while the Purchasing department retains central control.
Project Manager of Auto Rent Charging Project in Property Manager
Project was to identify and clear the leases that are stuck in AP interface and reconcile the PM data with AP data. Define new invoice grouping rule and also develop customized PM report.
Functional and Technical Support to Property Manager Module which Invoice grouping rule and support customization done in AP to import PN invoice done by Accenture, Norway.
Support Electronic Payment system in Telenor
Coordinate with Support vendor (Tieto) and bank technical team for smooth payments processing.
Part of Implementation Team to implement Oracle Financial Module which includes AP/GL/FA/CM/PR/PO to all Telenor group companies and also provide support to Oracle Financial modules
Working for support/Enhancement of Oracle HRMS solution across Telenor group from May-08 to Dec-08.
My responsibilities include the technical support for smooth execution of following HRMS modules along with co-ordination and development of change requests related to HRMS domain.
Oracle Core HRMS (Basic Employee data Management)
Oracle Compensation & Benefits.
Oracle Customized Report:
Requirement gathering, design and development of AP report which includes
AP WHT Report by Supplier report
AP Invoice Payment Report etc
Un-invoice Receipt Report in PO
FA listing and source report
Exception report to show invoice from AP Interface.
Supplier Creditor listing Report
Supplier master report
Property Manager report to reconcile data from AP and PN
AR Report include Invoice voucher report, Receipt report etc.
Develop Purchasing KPI report showing different cases from PR to PO and to PO to Shipment till invoice and also showing aging analysis. It showing Pending PR/PO and PO with Invoices/without Invoice etc it cover different cases and helpful for higher management.
OracleBI Discoverer Report
Develop Oracle discover report for Telenor, Norway.
ERP Team Lead in Mobilink (Oracle Financial)
Management & Administrator of Oracle Financial, 11.5.7
that include AP,GL,AR,CM,PO,PR module
Responsible for Month end Closing of AP/GL/FA/CM which include Issue resolution at Technical & functional level and Streamlined Month End Activities.
Part of Team to Implement Oracle Financial 11.5.10
AP/GL, AR, CM, PO, PR module and assist Intracom Jordon company to implement Oracle financial
Provide Data for GL Account Mapping/DFF opened in Application
Provide data User wise for AP/GL/FA to enter in OF 11.5.10
Setup of AP/GL Modules, Closing Accounting Period.
Development of In-house Software and provide support to existing Application
Management & Backup/Recovery of running Software Database
Raising & Managing TAR on Metalink Oracle corporation and resolve issue In Oracle Application.
Managing Bank Reconciliation Issue in Cash management module.
Daily Troubleshooting of Oracle Financial issue which include Invoice entry issue/Pr-PO issue/Bank statement issue/check Printing Issue etc at User End
Development of Customized Report for AP,GL,TAX Department which cater the Business needs of Mobilink Finance
Daily SQL Based Reports for Users which facilities Users.
Develop interface for AP/AR user can upload invoice by Just one Click.
User Manuals and Technical Manual for the Software development for the Company.
Coordinate with end user
Develop and support In house Oracle/Oracle Web based Project it Includes:
Check Printing Software
Bank Reconciliation Software
Utility Bill Software
Advance Software
Lease Line Software
Physical verification of BTS sites
Development of Software which catering business needs and minimize Data entry for Users and speed up the Process and made User Manuals and Technical Manual for the Software development for the Company.
Module :: Account Payables, Account Receivable, Cash Management,
Fixed Assets, Procurement.
AR Interface Project
Project has been deployed in production and its up and running.
The project is about to load AR transaction using Auto-invoice and AR Import program. Which include to setup Auto-invoice and project documentation and covers all the D1, D2, D3, D4 Telenor project methodology
Module:Account Receivable, Auto Invoice Program in AR
AP Interface Project
Project is load AP commission Invoice in AP module by using data loader in quick way.
Module: Account Payables
Project Cash Management Interface
Project management of implementing Cash Management interface and it include designing, execution, implementation and testing phase. The project is to upload customized Bank statement file into Cash management which facilitate user to mage Auto reconciliation process faster and reporting to make higher management reporting effective.
Project Include documentation that include D1 (Analysis phase), D2 (Design Phase), D3 Execution Phase, D4 Implementation phase and test case, It also include High level design Document, Functional Design Document and Project Presentation. Its also descript Risk factor
Module:CM
KPI Reports (Procurement)
Different Reports have been developed to cater activities from PR to PO and includes PR-PO details, pending PR, PO vendor vise detail and detail of status of all PR either it has PO or not, invoice entered or not etc.
Tools: Oracle Report Developer
Advances & Expense Claim software
It covers the overall process of Advances & Expanse Claims and will be implemented in Mobilink across different location, auto upload data of different Modules in OF and minimize the Data entry at User Level.
Tools: Oracle Form Developer, Oracle 10G as Database
Web Based Electricity
& PTCL (Mobilink)
Web Based, Nation wide implemented software which capture all the entries from various Location, and system auto generate Report to Mail to bank for Transfer for Funds, Bank Reconciliation Report etc.
Tools: Developer Suite, Oracle 9i as Database, WEB Parameterized Report
Lease Line Software
Mobilink
It keep track of the Billing of Lease Line of Company, and load Bill from PTCL and produce Different report which show Variance, Actual Bill Detail etc,
Tools: Oracle Form Developer, Oracle 9i as Database
Electricity Utility Bill
Mobilink (Finance Department)
It Load data from Various department inside the company and keep track of amount deposited in Bank, produce Bank Reconciliation Statement
Tools: Oracle Form Developer, Oracle 9i as Database
WEB Based Electricity Utility Bill
Mobilink (Finance Department)
It Load data from Variance department inside the company and keep track of amount deposited in Bank, produce Bank Reconciliation Statement
Forms Runs in Internet Explorer,
Tools: Developer Suite, Oracle 9i as Database, WEB Parameterized Report
Physical Verification of BTS (Site)
Finance Department Mobilink
It captures the entries of all the BTS installed in Pakistan, and show different Reports in which tell the Variance of Model installed from company
Books
Tools: Oracle Form Developer, Oracle 9i as Database
Bank Reconciliation System Mobilink
It cover the Complete Bank Reconciliation Process of Every Franchise, Its has Cash, Cheque, Credit Cards module, and Funds Transfer, Bank Charges, Vouchers making.
Its has Different Report, Inception Reports, User wise Report
Tools: Oracle Form Developer, Oracle 9i as Database
WEB Based Bank Reconciliation System Mobilink
It cover the Complete Bank Reconciliation Process of Every Franchise, Its has Cash, Cheque, Credit Cards module, and Funds Transfer, Bank Charges, Vouchers making. Forms Run in Internet Explorer
Its has Different Report, Inception Reports, User wise Report
Tools: Oracle Developer Suite, Oracle 9i as Database, WEB Reports
Petty Cash Software
Mobilink
It covers the Cash management Of the Company, Daily Petty cash Given to Employee and Produce Reports Month Wise, Department Wise, Employee Wise Etc Reports to Show the Cash Opening Balances and Closing balances
Tools: Oracle Form Developer, Oracle 9i as Database
Monopoly Control Authority of Pakistan,
Islamabad
It has different Modules i.e. Admin Section, Legal Section, Library section. Admin section covers the user right management/security. Legal section covers the High/Supreme court case management.
Library system cover the book Profile registration and issue/Receive of Books,
It has different report which cover all the area of the system
Tools: Lotus Notes/Domino 6.0,Oracle 9i as Database
COM Embedding in ASP, Crystal report Embedding in Internet Explorer
E-Workflow Manager is Company product and its browser based Application, which run on LAN/WAN. It large project and has different modules, E-Workflow is the complete solution of Office Automation and have section of HR, Project Management etc also Provide Graphical Report for Higher Management.
Tools: Visual Basic 6.0 (COM), Asp, SQL Server 7.0,Crystal Report 8/9
Accuprint & Packaging (Pvt) Limited, Lahore
The job includes computerizing Sale, Purchase and Inventory of the company and integrated with the Accounting System.
Tools: Oracle Form Developer, Oracle 9i as Database
Lt-Biz work Flow (ERP)
Its ERP solution and its also Company Product, its has HR module, Sale Module, Purchase Module, Accounting Module Use Active X control i.e Sheridan control, True DB Grid
Tools: Oracle Form Developer, Oracle 9i as Database
PMIS (Property Management Information System)
The Job includes computerizing and keep track of track of all letting and selling of property. It has different report that fills the client’s need.
Its Provide complete solution to Property Dealers
Tools: Visual Basic 6.0, MS Access
Ministry of Women of Pakistan, Islamabad
Its includes the Questionnaire which has different parts that include descriptive question, MCQs, True False, Yes/No, This will be filled by the MNA/MPA/Senators of Pakistan, Its has different report in Graphical form which forecast the tendency of MNA/MPA/Senators towards one Project
Tools: Visual Basic 6.0, Ms Access 2000
Accounting System for Housing Societies, Islamabad
The job includes to Computerize the Accounting System of Housing Society and it covers the complete Accounting cycle
And produce reports of Accounts i.e. Ledgers, Income Statements, Charts of Accounts etc.
Tools: Visual Basic 6.0, MS Access, Crystal Report 8.0
ASP free E-mail facility
The job includes to develop free Email facility for Future component Solution
Tools: Database design using MS Access, HTML, Dream weaver 4.0, Designing of site using Adobe Hand, Coral Draw 5.0, ASP
Accounting System of NGO
Work as Team Member. The job includes computerizing the Accounting System of German NGO.
Tools: Visual Basic 6.0, MS Access, Crystal Report 8.0
Inventory & Accounting System of Diplomatic Enclave PSO (Pump)
The job includes Inventory Control and Financial Accounting System of PSO pump
Tools: Visual Basic 6.0, MS Access, Crystal Report 8.0
Inventory Control System of CSD Head office, Rawalpindi
Its private Project. The job includes Demand generation of all items in different shops of CSD by comparing demand of previous 3 years, then increase demand by 50 % if there is increasing trend in
Previous 3 years else increase 25% of demand.
It also has records of Vehicle, employees, and amount paid. It
Have different reports according to the demand of the System.
Tools: Oracle 8.0, Developer 2000
Leave Application System HR Mobilink, Islamabad
Its keeps record of Leave of Mobilink employees, Award LFO every year, Report for higher Management
Tools: Oracle 8.0, Developer 2000
Mobilink GSM Reward program, Islamabad
A loyalty program, which rewards customers for using Mobilink services, Having Reports.
Tools: Oracle 8.0, Developer 2000
Star link Net club, Rawalpindi.
The job entailed to computerize the complete records of Net club, in which administrator has all the access to assigning PC to user and software keep track of all the user log in time, logout time, billing and history of all user. Tools: Oracle 8.0, Developer 2000
Library System of (NTM) Islamabad.
The job entailed to computerize the complete record of NTM programs and to easily
Tools: Oracle 8.0, Developer 2000
Computerized Annual papers of Preston University, Rawalpindi
I worked as a part of a tem to computerize the Annual paper system.
Tools: Visual Basic 5.0, Ms Access
International Training:
Training on Property Management module from Oracle, Srilanka.
Training on OA Framework from Oracle, Singapore.
National Training:
Training on PMP, Pakistan.
Training on AP/AR/CM/FA from Oracle, Islamabad
Training on Antiterrorism Course by OSALP, Islamabad (Level 1)
Training on VB.Net, CRTC, Islamabad
Certification
Oracle AP Financial certified (part 1)
EDUCATION
MCS (Master in Computer Science) 2000
Preston University (Pakistan Higher commission Recognized)
Rawalpindi, Pakistan
BSC
Govt. Gordon Collage, Rawalpindi
SKILLS
Oracle Financial 11.5.7/11.5.10
Oracle R12
Oracle Database 10G,9i,8i
Lotus Notes/Domino 6.0
MS Visual Basic 6.0
Toad
Oracle Developer 2000
HTML/ASP
SQL plus/Loader
PL/SQL and TOAD
SQL-Server 2000
Crystal Report 8/9/10
Oracle Discoverer
Oracle BI
APPLICATION
Oracle Financial (AP/GL/FA/AR/CM/PR/PO)
OA Framework
Oracle Property Manager
Visual Source Safe
MS Office 97-2000
MS Visio 5.0
Coral Draw 5.0
SQL 7.0/8.0, SQL* Net
OTHER ACCOMPLISHMENTS & ACTIVITIES
Leadership
Oracle Financial Team Lead in Mobilink (2006-2007)
VB Team Lead
Executive member of the Academy of Knowledge (Regd) Govt. of Punjab)
Honors & Awards
Winner of Best Employee Monthly Award in Mobilink in MAR-2006
Letter of Appreciation from Levington Technology in Year 2004
Letter of Appreciation from Future Component Solution 2002-2003
Letter of Appreciation Punjab University (Won Quiz Competition)
Secured 2nd position in MS Second (Summer Semester) 1998.
Languages
I can speak English and Urdu
Extra Curricular Activities
Table Tennis, Cricket, Chess