Oracle ERP Consultant
House # B-224 Block 14
Gulistan-e-Jauhar, Karachi, Pakistan
Phone: +9221-34023939 /+92300-2136143
Looking to expand my career related to my profession with committed & dedicated people, which will help me to explore myself fully and realize my potential. In the face of my being selected, I would work towards fulfilling the Organization’s goals and expectations and I am confident of meeting them successfully.
· 2 Years of Project Management experience in Oracle Applications ERP Solution implementation including R12 Implementation in Discrete Manufacturing Modules (BOM/WIP/Costing) and Supply Chain Modules (PO/INV/SOR/OM).
· Over 10 years of IT experience with strong Database Development of business application software using Oracle tools.
· 8+ years of local and foreign procurement of goods and services experience under PPRA rules, World Bank and Engineering council guidelines.
· Full life cycle implementation of Oracle 11i./ R12 (PO/INV/SOR/OM/BOM/WIP/Costing) including manual testing, designing and developing test methodologies and test plan.
Project Management: Thorough knowledge of:
Ø Cross-functional project management concepts, methods and practices
Ø Information Technology applications, processes, software and equipment
Ø Business systems design and business process management
Ø Testing techniques and methodologies
A results-driven professional with strong client-centric skills and an agile approach to project management
Procurement: Experience and knowledge of purchasing processes, managing tenders and contracts, Proven experience of providing highly effective supplier management and development.
Oracle Tool: Forms and Reports 10G/9i/6i, SQL PLUS, SQL*Loader, Oracle Discoverer, Oracle OA Framework / Jdeveloper, BI, Oracle 10G/9i/8i, Developer 2000.
Languages: PL/SQL, VB, DotNet, C, C++.
Operating System: Windows 8/7/ XP, Windows NT/98/95, Windows 2000, Unix and DOS 6.x
ERP: ORACLE Applications 11i / R12.
ü Bachelor of Computer Sciences – 1999
(1st division from University of Karachi, Karachi, Pakistan)
ü Dot Net Applications Certification – 2005
(NED University of Engineering and Technology, Karachi, Pakistan)
ü Oracle 9i Certification – 2003
(Orasoft Training Institute, Karachi, Pakistan)
o Capacity building on Public Procurement Rules and Procedures (NIP – PPRA, Islamabad, Pakistan)
o Supply Chain Management (Rousing Executive Development Centre – LUMS, Lahore, Pakistan)
o Oracle Discrete Manufacturing Modules (BOM/WIP/Costing) (Colombo, Srilanka)
o Oracle HRMS (Colombo, Srilanka)
o Oracle Projects (Colombo, Srilanka)
Merit Packaging Limited. http://www.meritpack.com July 2016 to Date
(A Lakson Group Company)
Manager IT & ERP
o Manage Information Technology and Computer Systems.
o Plan, Organize and Control IT and electronic data.
o Ensure security of data, network access and backup systems.
o Maintain annual budget and ensure cost effectiveness.
o Responsible for leading all the projects related to new module implementations in Oracle ERP.
o Administer already implemented modules (AP/AR/GL/FA/CM /OM/PO/INV/BOM/WIP/CST)
o Adhere to Project Management practices and business change control process.
o To Develop and maintain standard report repository and build ad-hoc reports in ERP when required by the management.
o Lead and resolve ERP related service issues.
o Interface with the DBA, server & storage administrators to design proactive management processes that ensure ERP application availability & performance.
Sui Southern Gas Company Ltd. http://www.ssgc.com.pk/ssgc/aboutus March 2003 to June 2016
Deputy Manager (ERP Project Coordinator)
o Performed as Project Coordinator managing Project Management activities of R12 implementation Key deliverables produced were:
Ø MS Project Planning of R12 Implementation spanning Design to Deploy Project Phases
Ø MS Project Planning of R12 Implementation Cutover plans
Ø Tracking Project Deliverables with Multiple Project Teams
Ø Project Status Metrics Data Collection, Tracking & Reporting
Ø Cutover Execution Tracking & Reporting
o Provide initial review on procurement activities including contracting, deal memos, and tendering.
o Update procurement system of supplier selections and evaluation and keep database of quality approved suppliers up-to-date
o Prepare monthly reports by collecting department’s operational performance against targets and deliver it for review, approval and distribution by procurement manager
o Implement developed mechanisms to ensure procurement cycle lead time reduction,
o Ensure that Procurement negotiated prices are the best and continuously improve procurement services performance measures and ensure that procurement staff do the same
o Facilitated and actively participated in all phases of the Implementation cycle, to include Requirements Gathering & Analysis, System Design, Development, Testing, and Implementation.
o Create process maps representing current processes, future processes and business baseline of Company.
o Developed and tested the Purchasing, Inventory, and Discrete Manufacturing Modules Test Cases.
o Conducted CRP and UAT Sessions and derived customization.
o Preparation of user guides, training material, presentations and verifying AIMs technical
o Successfully Implemented Oracle Discrete Manufacturing modules (BOM/WIP/Costing) 11i.
Assistant Manager (MIS / ERP)
o Focal Point / team member for the implementation of Oracle Purchasing, Inventory, Sourcing modules
o Created PO Approval hierarchy as per user requirements. Configured the workflow for requisition and PO approval and auto creation of purchase orders during requisition import.
o Defining Suppliers Supplier Performance Evaluation.
o Defining Items Locations, Organizations, Unit of Measure etc.
o Purchase Requisitions import, Creating Requisitions using templates.
o Creating internal requisitions, Auto creating requests for quotations.
o Managing Standard P.O., Blanket Purchase Agreements, Planned and Contract P.O., Auto creation of P.O.
o Managing P.O. Receipts, Defining document security.
o Customization of Oracle forms & Reports of purchasing module.
o Setup organizations and set of books in a multi org structure, including carrying out consolidation and translation in primary and reporting set of books before switching to multi org. Imported requisitions using Core Purchasing interface tables.
o Defined Standard API s for PL/SQL procedures.
o Customized Oracle default workflow API s.
o Developing and Customizing Reports
o Customized data by adding calculations, summaries and functions.
o Queried from different database tables as per the requirement.
o Using Portfolio, reports were presented Created List Reports and Cross Tab Reports and Drill Through reports.
o Created the Business Mix report and Top Ten reports.
o Created reports in HTML format for easy navigation of data from web browser.
o Database Administration
o Created tables, synonyms, sequences, views and PL/SQL stored procedures.
o Enforced database integrity using primary keys and foreign keys.
o Created PL/SQL functions to facilitate business functions and calculations
o Database development
o Installed and configured oracle 8i/9i.
o Configured tnsnames and Sqlnet files
o Created instances, schemas, users, profiles and roles.
o Managed users, privileges and roles.
System Support Engineer
o Designed software for several departments, which included:
o Assisted in implementing Medical System in company medical centers of remote areas.
o Responsible for taking backups and trouble shooting.
o Conducted training for doctors educating them about in-house developed software.
o Developed Vehicle Management System for the Department using Oracle9i. The software was designed to maintain vehicle information i.e., taxation, fueling, maintenance and employee’s information.
o Designed a File Management System for the department using Oracle9i. The software tracks the file and maintains the current status of the file at a phase, from user request level to purchase order.
Zillion Software January 2000 to February 2003
o Develop various Oracle Applications using PL/SQL, SQL*Plus, Forms, Reports and Application Object Library.
o Design of tables, databases, forms, and reports; connected forms with Oracle Applications.
o Gathered application requirements and provided design recommendations.
o Design custom data models that integrated with Oracle Applications.
Available on request.
1996 / 1999
B.S. Computer Science at University of Karachi
01-JUL-16 / Present
Manager - IT & ERP at Merit Packaging Limited
01-MAR-2002 / 30-JUN-2016
Deputy Manager - ERP at Sui Southern Gas Company Limited