Farrukh Awan Email & Phone Number

Us Denim Mills (Pvt.) Ltd.

Lahore, Punjab, Pakistan

Seeing over IT Dept that includes Software(Oracle E-BS & In-House Applications) & Infrastructure.

Rawalpindi

Development of software for Military Lands & Cantonments (MoD) Nationwide for Better Services to residence of cantonments as well as better working of HQML&C and individual Cantonment Offices.I have a role where >I manage 14 team members for following tasks:>I design Project Timeline and ensure completion.>I Plan implementation process on Test sites and Pilot sites.•Development & Implementation of Establishment (HRM), Budget & Accounts, Land & Revenue, OWFC, Education, Health, Legal, Town Planning, Inventory & Procurement along other modules.•Development of Web sites of Cantonment Offices and HQMLC.•Development of Mobile Apps (Complaint Management, Document Verification, Attendance)•Server Related Tasks.•Tuning of Oracle Database.

Lahore

• Decision making for software improvements to work better and implementing security rules.• Member of I.T Task Force committee.• Lead all I.T operation and administration tasks.• Training of junior staff.• Conduction of I.T Audit with external Auditors.

Lahore

• Successfully Up-gradation of Oracle E-BS from 11i to R12 as Project Manager• Troubleshooting of Oracle Financials/SCP/Manufacturing and give guidelines to user to speed up work with minimum errors• Interfacing with in-house developed software using DB-Link• Customization in PO/PR & OM notification summary.• Workflow development for customized modules.• To manage Month/Year end oracle Tasks by Closing old Periods and Opening new ones, Sequences, Transaction types and Calendar• Integration of Customized In House developed Applications with Oracle R12 using Oracle Forms• Fine-tuning of Oracle APPS by Maintaining different schedule tasks/concurrent processes and running jobs.• Managing Oracle Application/Database Servers by configuring, testing, patching and schedule monitoring and cloning• Service Request management with Oracle• Developments of New Reports and Managing of Old reports with End-User requirements.o In-House developed software• To study System Workflow and give guidelines to developers for implementing securities• To ensure Planning Tasks by Defining Objectives for Software Developers, Providing budgets, SOP's• Implementing new technologies.• XML Publisher• Oracle Alerts• Oracle Email Alerts Procedures

Multiple Locations

• Worked on Inventory, Purchasing, Order Management, AR, AP, Discrete Manufacturing and GL Modules at a technical level• Created Key & Descriptive Flex fields, Value Sets and provided Maintenance• Carried on Data uploading using interface tables, PL/SQL, SQL Loader and Data Loader• Developed Reports as per functional Design and Technical Design requirements using PL/SQL. The reports related to Inventory, Purchasing, payables, receivables, general ledger, order management and discrete manufacturing• Carried on Integration and Development of detailed functions and procedures providing value addition to clients’ business needs.• Worked in detail on the development of CitiDirect (Integration of Oracle Payments to Citi Bank)• Worked on Oracle Java Forms Personalization and Web Base personalization.• Patching and cloning of Servers• Oracle Application Up-gradation from 12.1.1 to 12.1.3• Server installation and troubleshooting• Obtained understanding of the transaction flows of Oracle Financial Modules(GL,AP,AR) and Oracle Supply Chain Modules (Purchasing, Inventory and Discrete Manufacturing)

Lahore

Sui Northern Gas Pipelines Limited (SNGPL)Project Details: LMK Resources Pakistan is implementing HR, Payroll & Supply Chain Management modules in Sui Northern Gas Pipelines Limited (SNGPL). Complete procure-to-pay cycle is being mapped in R12 Applications and necessary customization is being done to include complete tendering processes currently running in the organization. Moreover, a huge number of inventory items are being transacted & managed through Oracle ERP Applications.

Lahore

Worked as Internee as ERP Consultant

2010 Bs Hons, Computer Science

Activities and Societies: E-Gaming Team

2005 Fs.C, Pre Engineering; Physics, Chem, Bio; Math