Muhammad Junaid Rana, Manager Oracle / Oracle Solution Architect

Muhammad Junaid Rana

Manager Oracle / Oracle Solution Architect

Lamprell Energy Limited

Location
United Arab Emirates - Sharjah
Education
Master's degree, Information Technonology
Experience
20 years, 3 Months

Share My Profile

Block User


Work Experience

Total years of experience :20 years, 3 Months

Manager Oracle / Oracle Solution Architect at Lamprell Energy Limited
  • United Arab Emirates - Sharjah
  • My current job since August 2013

As solution architect worked on group wide implementation of Oracle ERP application covering Financials, SCM, Projects, Planning, Production and HCM functions.

Designed and lead development / implementation of
• Time allocation system based on Oracle and ASP.Net platforms which are integrated to Oracle HCM and Projects.
• Manpower forecast application using ASP.Net which is integrated to Oracle HCM, Primavera and Projects applications to provide timely forecast to business for admin and labour manpower requirements for the projects.
• Estimation application based on Oracle platform fully integrated with SCM, Projects and SCM functions covering all elements of estimation from materials to manpower.
• Application to simplify and control the petty expense purchase requests and creation of auto PO and invoice back in Oracle Financials based on approved requests
• Project cost forecast application to simplify forecast generation process, integrated to Oracle Projects, HCM and other custom applications
• WorkPack application based on ASP.Net to monitor/control the activities and report progress/productivity in Fabrication yard which is integrated with Oracle SCM, HCM and Projects
• Process improvements related to inventory planning and auto generation of material requisitions and purchase orders based on inventory levels
• Interactive live dashboard application based on ASP.Net and Qlik sense, fully integrated to ERP and custom application to provide single reporting platform to executive management.
• Application for generation of final accounts for management reporting using ASP.Net integrated to Oracle Financials for live data feeds

Worked on integration of pipe shop fabrication software by 3R solutions Germany with Oracle SCM for pipe shop of Lamprell.

Worked on process design project for the newly established fabrication business “International Maritime Industries (IMI)” in Saudi, a joint venture between ARAMCO, Lamprell, Hyundai Heavy industries and Bahri. IFS is the solution selected for IMI.

Participated in evaluation of different solutions for production control system for Lamprell which includes review of systems offered by Siemens, AVEVA, IFS and Omega systems.

Provide support to Six Sigma team for designing and delivering solutions for business optimization initiatives using Oracle and ASP.Net platform

Completed Six Sigma yellow belt training.

Assistant Manager Oracle Functional at Intelligent Corporate Solution (Bukhatir Group) UAE
  • United Arab Emirates - Sharjah
  • January 2008 to August 2013

Completed 3 full cycle implementations of Oracle in below mentioned entities covering Finance, Procurement, Order Management, Inventory and Manufacturing functions

• Emitac Group (3 entities)
• Terrazzo Group of companies (4 entities)
• German Gulf enterprises

Conducted system audit of Plymed Fze and delivered a report stating detailed business requirements, weaknesses in existing Application and recommended Improvements.

Consultant - Supervising Senior at PWC
  • Pakistan - Lahore
  • February 2004 to October 2008

Completed 4 full cycle implementations of Oracle application on below projects covering Financials, Procurement, Inventory, Order Management and Advanced Supply Chain Planning functions

• Dawlance Group of Companies (3 entities)
• Fazal Cloth Mills
• Ibrahim Fibres Limited

Education

Master's degree, Information Technonology
  • at Virtual University Of Pakistan
  • March 2021
Diploma, CA Finalist
  • at Institute of Chartered Accountants of Pakistan
  • September 2003
Bachelor's degree, Economics
  • at Islamia University
  • December 2002

Specialties & Skills

Project Management
Solution Design
Business Process Mapping
Oracle Functional
Project Management and Reporting
Oracle Financials
Oracle Purchasing
Oracle Order Management
Oracle Primavera
Oracle Projects
Microsoft M 365

Languages

English
Expert

Training and Certifications

ITIL Foundation (Certificate)
PRince 2 Practitioner (Certificate)
Six Sigma Yellow belt (Training)
Training Institute:
Six Sigma