Over 19 years of experience as Oracle Professional in Analysis, Design and Implementation of Business Applications and development of Custom ERPs having fully integrated Information System consisted of Financials, Inventory Management, Sales and Incentive Calculation, Purchase, HR / Payroll, Production Management System (varies company to company) along with Executive Dashboards. Moreover, involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. Transferable skills include:
✓ Oracle Forms & Reports (10g, 11g)
✓ Oracle Application Express (APEX)
✓ Oracle Application Server Deployment
✓ Business Intelligence - QlikView
✓ Oracle Database
✓ Backups and Recovery Management
✓ Connectivity of Databases with Oracle MySQL, MS SQL Server)
✓ IT Infrastructure Management
Working as Senior Manager I.T with Hunbul Tex Pvt. Ltd.
Responsibilities
Heading IT Department.
Automated all departments of the company.
Developed Complete Financial System (Replaced SAP) handling all Payables, Receivables, Asset management, HRMS & Payroll, Inventory Management System, Point of Sales for outlets, Final Accounts, Executive Dashboards, Reporting Dashboards, Production Processes (Few).
Timely enhancements in the systems.
Executive Dashboards in oracle APEX
Developed POS system for outlets.
Heading IT Department. Reporting to Director. Responsible for all In-House software development in Oracle Database 11gR2 and Forms & Reports 10g.
Firstly I upgraded all applications running in older version (Database 10g and Forms 6i) to Oracle Forms & Reports 10g (OAS 10g) and databse 11gR2 and removed bugs and optimized the software by eliminating unnecessary posting processes.
Then after 1 and a half year, management asked me to developed a complete integrated ERP which must includes all the modules of the company and also having the Executive Dashboards for Directors and Managers showing all the required activities on a single screen and details on a single click. The ERP took about 1 year to develop and finalize and now it is running smoothly.
This ERP includes following modules:
1-Accounts and Finance
2-Sales and Marketing (Includes SMS to the customers)
3-Purchases
4-Inventory
5-Production Management
6-Payroll and Attendance
7-Sales Tax Management System
Developed following systems at ELAN.
1. Attendance Management System
2. Leaves Management system
3. Payroll Management System [ Office Staff ]
4. Payroll Management System [ Labor Staff (Hourly Rate)]
5. Gate Pass Management system
Worked as Senior Manager IT at ALiVE Group. Leading and Managing all IT Projects of the Company. Currently I am working on the following projects:
1. *** DIRECTORATE GENERAL PROCUREMENT ARMY ***
Developed complete “Procurement Management System” in Oracle Database 12c and Oracle Forms & Reports 11gR2 with Weblogic Server. DGP Army deals in Purchasing and Procurement for Pakistan Army. The process of procurement in DGP Army is such a complicated system. We developed it successfully which includes:
Receipt of Indents from all over Pakistan (Pak Army)
Approvals for processing indents for Publication in Newspapers
Approval for issuance of Tender Documents
Issuance of Tender Documents (Auto Generated)
Approvals for Bidding
Bidding
Sending Bids for Technical Scrutiny.
Approvals for Tender Opening
Tender Opening
Comparative Statement (Auto)
Approvals of Comparative Statement
Purchase Proposal
Approvals of Purchase Proposal
Draft Contract
Final Contract
Post Contract Management
2. COUNTER TERRORISM DEPARTMENT (Punjab Police)
This system deals with the Criminals (Terrorists) Record and their activities. Details are Confidential.
3. Pakistan Ordinance Factory – WAH Cantt.
Inventory Management System – On Going.
4. Heavy Industries – Texila
Inventory Management System – On Going.
Responsibilities:
a. Project Management
b. Leading Software Development
c. Software Testing Q&A
d. Deployment of Team on different projects
e. Installation and Configuration of Database Server
f. Installation and Configuration of Application Server / Weblogic Server, Webutil etc.
g. System Analysis
h. Assigning duties to the programmers
i. Managing Network Team for deployment on different projects.
j. Weekly group discussion with Programmers and Network team to resolve the problems (if any).
k. Correspondence with the clients.
l. Monthly meetings with Director(s) regarding running projects.
5. Other Projects:
1. Bee Jee & Sons Accounting System
Provided complete accounting system, developed in Oracle 8 and Forms & Reports 6i. Includes AP, AR, GL and Trial with miscellaneous reporting.
2. Revenue Society Water Billing
Monthly Water & Utilities billing to the residents. Developed in Oracle database 10g and Forms & Reports 6i.
3. Revenue Society Accounts
Complete accounts developed in Oracle database 10g and Forms & Reports 6i.
4. Revenue Society Plot Transfer System (with Biometric)
Plot transfer system developed in Oracle database 10g and Forms & Reports 10g with Application Server
5. Fancy Packages Pvt. Ltd. Inventory Management
Complete Inventory Management System with Sales & Deliveries, developed in oracle database 10 and Forms & Reports 10g.
6. Afzal Spinning Mills. Accounts
Developed complete Accounting system with Inventory / Stores and Sales Management System. Developed in Oracle database 10g and Forms and Reports 10g with Application Server 10g.
7. Anchor Sourcing Accounts & Inventory
Developed complete Accounting system with Inventory / Stores and Sales Management System. Developed in Oracle database 10g and Forms and Reports 10g with Application Server 10g
8. Pak Duck Textiles Accounts & Inventory
Developed complete Accounting system with Inventory / Stores and Sales Management System. Developed in Oracle database 10g and Forms and Reports 10g with Application Server 10g
9. Metron International Accounts & Project Management
Developed complete Accounting system with Project Costing Management System. Developed in Oracle database 10g and Forms and Reports 10g with Application Server 10g.
Worked at Samin Textiles Limited as “Deputy Manager Systems” for 5 years. I was team lead in the Systems Department and directly reporting to G.M Systems. I worked on Oracle Forms & Reports 10g here and converted 6i applications into 10g, as well as I developed some new applications for different departments.
Assigning tasks to the programmers was also my responsibility. Moreover, system analysis for new developments was also my job. I worked on the following systems in Samin Textiles:
1-Developed Yarn Procurement System in Oracle Forms 10g.
2-Upgraded Local Sales System in Oracle Forms 10g.
3-Development of new reports and forms required by different departments.
4-Maintained third party software (HR & Attendance) purchased from different software house.
5-Configured Oracle Application Server 10g (Forms & reports services) for deployment of applications of Oracle Forms 10g.
6-Conversion of existing 6i applications into Oracle Forms 10g.
Played key role in the implementation of SAP.
Key role in implementation of ERP (SAP).
1-Assisting General Manager Systems in ERP (SAP) Implementation
2-Arrangement of master data for the SAP consultants.
3-Preparation of “As-Is Study” of existing systems of Samin Textiles for SAP consultants to produce the Blue Prints.
4-Conduct trainings for key users and end users as lead trainer.
5-Keeping check and balance on users’ data entries in SAP.
6-Evaluation of users’ requirements and proposing adequate and effective solutions.
7-Supervising the month closing process (reconciliation and balancing).
8-Cancellations and Reversals.
9-Coordination with SAP consultants regarding any configuration required by system.
Key Achievements
Lead the team for “in-house software development”.
1-Successful deployment of Yarn Management System (Forms 10g)
2-Successful deployment of Local Sales System (Forms 10g)
3-Successful implementation of SAP.
4-Successfully prepared system analysis reports for consultants to produce blue prints
5-Successfully developed the SAP Training material.
6-Successfully conduct SAP trainings
Worked as Programmer in Dawood Spinning Mills for 2 years. Managed Data collection and report formation for Trainings to the end users. Conducted meetings with Heads of the Departments regarding betterment of the software systems and new developments as well. Organized internal and external IT trainings.
Key Achievements
1-Successfully developed and implemented Complete Payroll system
2-Successfully organized more than 20 in-house IT trainings in one year.
Worked at Nishat Mills Limited as Programmer for 2 years. I had been working on many systems here. I developed Local Sales System, Grieg Inventory Management and IGP & OGP. As well as the troubleshooting of existing system like Accounts, Costing, Payroll etc. was also my responsibility.
Assisted the Senior Programmers. Part of the Developers team in programming side. Developed software for Pension Fund Deptt in Oracle 8 and Developer 2000. Assisted Head of the Department of Pension Fund in issuance of monthly pension and developed reports as per requirements of the department. Successfully developed and deployed my first software for Pension Fund Dept