Sunday, October 13, 2013

S.GRACE PAUL REGAN. OCE, PMP

S.GRACE PAUL REGAN. OCE, PMP       regan.gpr@gmail.com                                                                                                                              
Project Manager Oracle ERP/SCM Expert                     Waha Mall, Al-Dajeej, Kuwait           
Mobile: +965 (97100377)      http://www.onlyoracleapps.blogspot.com                              


Summary
10 + years of experience in manufacturing industry systems, Project Management, Supply Chain activities, Oracle Apps implementation, Support and ETRM/CTRM support. 
PMI-Project Management Professional (PMP), Oracle Certified Expert and OPN Certified Specialist Consultant. 
Completed 11i & R12 Implementation successfully in a Multi Org scenario.
Worked as Project Manager and Leader for critical projects with extreme schedule & high value.
9 + years of experience in Oracle Application: In which I have worked with Oracle Order Management/ Shipping/ Advanced Pricing, Purchasing, i-Procurement, i-Sourcing, i-Supplier, Inventory, Engineering, BOM, MRP, Costing-SLA,WIP and OPM in releases 11i & R12.
Working experience on Oracle SQL, Forms, Reports & Oracle XML Reports 
Experience in doing gap analysis, Customizations, Personalization & Extensions.
Worked in Oracle Apps Release 11 and 12 with India Localization.
Expertise in Test Plan Preparation, Unit Testing, System Integration, CRP, UAT, end user training.
Used Oracle AIM Document methodology (MD50, CV40, TE20, TE50, BP80, BR100, BR150) & Oracle Unified Method.
Successfully completed many training programs for Oracle University on Oracle Distribution & Manufacturing Modules.
Worked for various clients across the globe onshore, interacted and worked with the teams in USA, Netherland, Germany, Bahrain, Saudi-Arabia, Dubai, Sri-Lanka, Pakistan, Australia, China and Kuwait in gathering the requirements, providing solution for various projects throughout implementation and support lifecycle.
Exposed to diverse internal and external technical environments, recognized for ability to manage multiple tasks simultaneously.
Proven ability to lead and motivate teams to maximize levels of productivity. Experience in leading Oracle 11i and R-12 Implementation projects across the globe involving various business practices
Well versed in Supply Chain Management (SCM) Process, Procedures and Project Management. Can work on different verticals. 
Aware of auditing and re-engineering of business process to enhance the overall performance.
Excellent people management skills and regarded as one of the best leaders in previous projects.


Certification    
1. PMI – Project Management Professional (PMP)
2. Oracle 11i – Procurement Implementation Champion 
3. Oracle 11i – Process Manufacturing Implementation Champion
4. Oracle 11i -  Discrete Manufacturing Implementation Champion
5. Oracle 11i -  Discrete Manufacturing Pre-Sales Champion
6. Oracle 11i  -  Oracle Sales Champion
7. Oracle R12.1 Supply Chain Management Sales Specialist
8. Oracle R 12.1 Financial Management Presales Specialist
9. Oracle R12: E-Business Essentials
10. Oracle R 12: Supply Chain Certified Expert Consultant, Purchasing
11. Oracle R 12: Supply Chain Certified Expert Consultant, Order Management
12. Oracle Database 11g: SQL Fundamentals
Both Assessment and Proficiency

Educational Qualification
Master of Business Administration (Systems)
Bachelor of Computer Application
Diploma in Advanced Client/Server Applications

Oracle Skills
Oracle Applications :            Oracle Applications 11i & R-12 (Distribution & Manufacturing)
Oracle Inventory, Oracle Purchasing, Oracle Order Management, Oracle WIP, Oracle Engineering/BOM, Oracle Sourcing, Oracle i-Supplier, Oracle i-Procurement, Oracle Process Manufacturing.
Documentation : AIM, Camtasia, Oracle UPK, iBooks (Mac OS)
Query : Sql-Pl/SQL
GUI’s : Visual Basic 6.0 and Developer 2000 6 (Forms and Reports)

General 
Operating System : DOS, WIN 98, Millennium, Vista, Win-7, 8 and Linux, Mac OS
RDBMS : Oracle 8i/9i/10g
Office tools : Micro soft Access, Excel, Word & Power Point, Paint, Microsoft                        
Project Plan, Adobe Acrobat Professional
SolArc Right Angle : Functional Setup and Support experience.
Project # 15  
Project : Tamdeen Group 
Duration : Aug-13 – Till Date
Role : Project Manager & Lead for SCM (Inventory, Purchasing, Costing, OPM)
Version : 12.1.3
Team Size          : 6 Members
Working Through: Diyar United Company

Responsibilities
Implementation of Oracle Version (12.1.3)  SCM, Finance and HRMS Modules from the scratch starting from Requirement Gathering through Application Setup documentation till go-live and Project Handover. 
Working through all the Planning Phases of implementation following OUM methodology. 
Worked with finance to setup OPM SLA Costing methods.
Assisted in Conversion design for items from legacy system 
Working on user training and perpetration of SOP. 
Working on finalization of various OPM Costing related reports. 
MUP (Maximum Utilization of Product) strategy was developed to avoid customizations. 


Project # 14:
Project  : Kuwait Red Crescent Society (KRCS)
Duration  : July-13 – Till Date
Role  : Project Manager & Lead for SCM (Inventory, Purchasing, Costing, Services)
Version  : 12.1.3
Team Size           : 5 Members
Working Through: Diyar United Company, Kuwait

Responsibilities
Implementation of Oracle Version (12.1.3)  SCM Modules from the scratch starting from Requirement Gathering through Application Setup documentation till go-live and Project Handover. 
Working through all the Planning Phases of implementation following OUM methodology. 
Assisting in creation of detailed WBS & WBS Dictionary, Activity list, Network Diagram, Estimate Activity duration, setting up Quality Standards and Risk Identification relevant to Oracle SCM Modules. 
Preparing Business Specific Requirement gathering document and strategy to extract the at-most business specific complex process that will enhance the future business model mapping and GAP analysis. 
Identify how to exploit the current systems and more importantly given the forward agenda 
determine what is needed to support the business for the future.

Project # 13:
Project    : Kuwait Stock Exchange (KSE)
Duration    : July-13 – Till Date
Role  : Project Manager and Lead for SCM (Inventory, Purchasing & Costing)
Version  : 12.1.3
Team Size  : 5 Members
Working Through: Diyar United Company, Kuwait

Responsibilities
Upgrade of Oracle Version (11.510.2 with 10G to 12.1.3 with 11G) SCM Modules from the scratch starting from Requirement Gathering through Application upgrade documentation till go-live and Project Handover. 
Working in Identification of all the present business process setup in (11.5.10.2 with 10G) Reports, Customizations, Extensions and Interfaces to be validated for compatibility with the new upgraded instance.  
Expert in providing technical direction on identified GAP to migrate all the present customization from the older version to the upgraded (12.1.3) version. 
Will be working on all Master Data interface (Items, Opening Balance, Purchase Order, etc…)
Will be responsible to handle any project critical issues relevant to SCM module upgrade, On Demand Severity One Service Request will be raised with Oracle to resolve the critical issues.  

Project # 12:
Project   : Kuwait Petroleum Corporation (KPC)
Duration   : Sep-12 – Till Date
Role   : Project Lead Consultant for SolArc Right Angle (ETRM)
Team Size   : 4 Members
Working Through : Diyar United Company, Kuwait 

Responsibilities
Business requirements definition - Take ambiguous and complex business problems in ETRM space, using user interviews and business assessment and assess the current state and define the business requirements for the future state solution.
Business processes design: Based on the business requirements and constraints drive innovative ideas, define the opportunity set, and recommend processes and solutions for the future state.
Solution design: Using your product expertise map the business requirements and processes to an ETRM product (Openlink-SRA) and identify the options for implementing the requirements in the product. 
Prototype the identified options in the product, work with users to close on the recommend option and for the selected options identify the configuration and customizations required in the product.
Solution Planning - Help define and scope solutions and provide inputs to plan the execution of the solution.
Quality Assurance: Helping define the test strategy and test catalog for end to end testing of the solution. Act as a subject matter SME and help execute and validate the test scenarios within an ETRM SolArc solution
Provide day to day support for upcoming user issues and concerns. 
Working in parallel with user and technical consultant in bring all development activities up to mark as per client’s requirement. 


Project # 11:
Project : Kazema Global Holding, Kuwait
Duration : May 12 – Sep 12
Role : Project Manager & Lead for SCM (Inventory, Purchasing, Order Management)
Team Size          : 5 Members
Working Through: Diyar United Company, Kuwait

Responsibilities
Lead Sr. Consultant for Inventory, Purchasing & Order Management 
Worked on three years accumulated year end closing Process, with accrual clear off and helped for smooth year end closing with encumbrance accounting enabled with some operating units.
Rolled out implementation for several operating units
Working on all support issues related to Purchasing, Inventory and Order Management
Developing and deploying Oracle XML customized reports as per clients requirement

Project # 10:
Project : Kuwait Oil Tanker Company (KOTC), Kuwait
Duration : Mar 09 – May 12
Role : Project Lead for SCM (Inventory, Purchasing, i-Sourcing and i-Supplier)
Team Size         : 6 Members
Working Through: Diyar United Company, Kuwait

Responsibilities
To take up the lead for Oracle Inventory, Oracle  Purchasing, Oracle i-Sourcing and Oracle i-Supplier
Complete working and management knowledge on end to end Supply Chain across all departments in the company including shipping SCM activity. 
Working on the first year end closing Process, with all accrual clear off and helped for smooth year end closing with encumbrance accounting enabled.
Working on all support issues related to Purchasing, Inventory, i-Supplier and i-Sourcing.
Developing and deploying Oracle XML customized reports.
Started to create issue database and maintain by priority with step by step answers for the users to handle the issue independently 
Registering suppliers with oracle i-Sourcing maintaining  discussion follow-up with suppliers
Completely configuring oracle i-Sourcing and i-Supplier for efficient procurement process
Restructuring custom interface program process between custom receipt programs with Receiving Transaction Processor.
Simplified and automated the process of invoicing 
Preparing MD-50 documents then and there for new technical requirements and data mapping.
Worked to close long term pending issues with root cause analysis and documented 
Trained all Fleet users in i-Sourcing and i-Supplier 
Interacting with client in all aspects in any case of functional issue and help the resolve at the earliest with root cause analysis.
Working with PO workflow issue and hierarchy authority customization issues
Working with encumbrance accounting process involved with procurement and the effect over year end closing and month closing of modules (Inventory and Purchasing)
Implementing inventory planning for Gas branch users
Working on i-Sourcing AME approval flow hierarchy with custom code.
I have prepared planning and strategy report to maintain training chart among users to get them trained with multiple job responsibilities to help the client user team help each other with vacation on time. As always there will be a backup for employee. 
Working as the key member for IT Researchers group for in-house business enhancements. 

Project # 9:
Project : Powerwave Technologies, Hyderabad, India
Duration : Feb 08 – Aug 08 / Sep 08 – Mar 09
Role : Project Manager for Rollout of Indian Line of Business for Oracle Inventory, Oracle  
  Purchasing, Oracle Order Management, Oracle Warehouse Management System and   
  Oracle Planning in R-12
Team Size : 4 Members
Working Through: Quest Am Software, India 

Responsibilities

To take up the lead to rollout of Indian Line Of Business for Oracle Inventory, Oracle  Purchasing, Oracle Order Management, Oracle Warehouse Management System, Oracle Planning, Oracle Fixed Asset, Oracle Accounts Payable, Oracle Accounts Receivables and Oracle General Ledger
Lead the team to complete the rollout work in a  narrow time frame with India Localization patch application
Started from RD till BR-100 following AIM methodology with all deliverables
Leading weekly meeting to ensure that we are in the safe ground on the project phase
Mapping end to end business needs and analyzing Gap.
Coordinating with Oracle in resolving all kind of Service Request and follow up till closure across modules
Advising the client follow the right track of functionality to get the best out from Oracle Application.
Training the users on both Base Apps and India Localization functionality.
Leading the team to keep the track of issues closed and current issues, through systematic plan and detailed documentation using issue tracker.
Interacting with client in all aspects in any case of functional issue and help the resolve at the earliest with root cause analysis.
Estimating the entire project time frame with anticipated risk
Helping the client to follow the best practice for data base security during the rollout phase
Working in resolving all the functional related issues in all the modules rolled out
Prepared Back-up detailed chart to intimate the point of backup in maintaining a safe zone through the roll out phase of the project.
Complete end to end transaction using India Localization was tested with Production Data 

Project # 8:
Project : Expresso Telecom, Dubai
Duration : Aug 08 – Sep 08
Role : Project Manager to Implement Oracle Distribution and Oracle Finance-R-12
Team Size : 5 Members
Working Through: Quest Am Software, India Pvt. Ltd.

Responsibilities
To lead the Oracle Functional Team in the Road Map to Implement Oracle Financials and Oracle Distribution in the given short duration of time (2 Months)
To look over the integration of Oracle Modules with the third Party Billing System
Started from the Requirement Gathering, GAP, Future Business Model Mapping and the final configuration
Each and every step in the implementation is viewed by another implementer as an audit process. This makes us walk in a rope, a minor mistake would be fatal and would be blown beyond proportion

Project # 7:
Project :  MTC (ZAIN) – Saudi Arabia/Bahrain               
Duration :  Aug 07 – Jan 08
Role :  Lead Sr. Functional Consultant to implement Oracle Inventory, Oracle Purchasing & 
   Oracle i-procurement in Oracle Application 11.5.10.2
Team Size : 6 –Members
Worked Through: Quest Am Software, India Pvt. Ltd.

Responsibilities
To do the complete implementation of Oracle Inventory, Oracle Purchasing and Oracle i-procurement according to clients requirement in a short duration of period (3-months).
Started from the scratch RD-documents and prepared all the deliverables as per the client’s requirement and our commitment till BR.
GAP analysis was done and was documented then and there to ensure end to end product delivery with the full satisfaction from the client
Advised the client with the Best Industrial practice with our previous experience and which they realized in the later phase of Implementation and product usage
We have followed the Application Implementation Methodology (AIM) to make our deliverables perfect with the client as per our agreed scope
We have helped the client as well as our Technical Team to develop several third party interfaces as our Billing Solution was completely maintained by an third party application tool
Helping Technical Guys in preparing customized report and let them understand the exact requirement of the client at the same time to convince the client everything cannot be customized in a report.
Prepare detailed backup plan of Oracle Instance then and there to maintain a safe zone till we go-live
UAT training was also completed as per plan for all the three modules for more than 30 employees.
We have gone live with no major issues and now extending our hands to several more roll-out of new implementation project

Project # 6:
Project :  Oracle APAC (Colombo - Sri Lanka, Lahore – Pakistan)
Duration :  Mar 07 – Jun 07     
Training   :  Sui Southern Gas Company Limited / Techno Ed, Pakistan
Worked Through:  Quest Am Software, India Pvt. Ltd.

Modules Trained

1. Oracle Inventory
2. Oracle Purchasing
3. Oracle Order Management
4. Oracle Engineering and Bill of Material (BOM & Engg)
5. Oracle Work in Process (WIP)
6. Oracle Planning (MRP)
7. Oracle Cost Management

It was an full-fledged training for the people from manufacturing industry to help them get an good hold of all Manufacturing and Costing Module before Implementing them
We did an pilot set up and run with their live data to capture all the Manufacturing and Costing flow
Mapped most of their Business Gaps
Detailed structure of how to go about documentation was made.
Accounting Transactions from entry till posting to GL was done successfully to meet the client’s requirement.

Training Experience
As a Trainer successfully completed many training program on Oracle Applications Distribution and Manufacturing modules.
Trained Key users as well as Head of the Department on Oracle Application Implementation Process, Distribution and Planning.

Project #5
Project : Nardeen Lighting Company, Riyadh, Saudi       
Duration : Nov 06 – Feb 07
Role : Functional Lead for Oracle Manufacturing (BOM, WIP, ENGG) 11.5.10.2
Worked Through: Quest Am Software, India Pvt. Ltd. /Chain-sys 

Responsibilities
My responsibility as a Functional Consultant is to take the lead role in implementation of Oracle Bill Of Material , Work In Process and Engineering modules
Active team member in resolving all the Functional Related issue in both manufacturing and distribution modules
Resolved challenging issues with affiliated modules interfacing with oracle 
Conducting weekly status meeting and help the needy to push up the project phase
Having live interactions with clients to make them understand the fix or to get appropriate details from them to further work on the fix. Also to get the functional enhancements from them to accelerate the business process. 
Involved in data mapping regarding clients requirements over technical issues.
Worked in creating all the AIM documents from the RD-20,BP-30,40,MD-50,MD-70,CV-30,CV-60,BR-80 and BR-100.
Creating CF-250, MD-200 Specifications, Requirements of Reports and giving user training over enhancement request completion, Custom implementation documents
Working with the business with various exercise and practice to bring down the customization in the project.
To find root cause and made the case study and case history for all the technical updates and customization with creating issue tracker sheet module wise.

Project # 4:
Project : FLOW SERVE, Nederland             
Duration : Aug 06 - NOV 06  
Role : Functional Lead for INV/PO/OM/BOM/WIP/ENGG Oracle Applications 11.5.10
Worked Through: Quest Am Software, India Pvt. Ltd. /Chain-sys

Responsibilities
My responsibility as a Functional Consultant with Flow serve-NETHERLANDS is to manage the complete Solution and Design related to PO/INV related to their process flow, Configure the Inventory, Purchasing module of Oracle apps 11i.
Understand the present (AS-IS) process and map the same into Oracle apps.
Did GAP analysis Parameterization
Finalization of Set-Up parameters, profiles User Document and BR-100
Test the Business Solutions in controlled environment (CRP-4) along-with critical interfaces
Did the Global Production set up 
Key Consultant to setup Inventory, Purchasing, Quality and Order Management
Configure Oracle Inventory (INV) and Oracle Purchase (PO)
Create Responsibilities and User menus with the help of System Administrator Verify Production readiness, ensure timely production, Tracking of TAR and tried to close any open GAP as early as possible.
Training to End users on Oracle Applications and documentation of User Manuals
Coordinate the Team to ensure testing various scenario of integrated Testing
Coordinate with Technical Consultants and Key users to map migration data 
Implementation of Standard functionality of the Following Modules of Oracle Applications using AIM (Application Implementation Methodology)
Report weekly strategy plan to the Team, Client and Key Users
Plan the deliverables and prior work schedule with approvals from the client 
Track all the pending issues after each CRP’s and closed the issues with proper documentation.
Helped the client to keep the track of issues closed and current issues, through systematic plan and detailed documentation.
Extensively worked on Purchase Receipts, Locator controlled with projects
Co-ordinate with Technical team for stages of Receipts and with all technical issues.

Project # 3:
Project : GENPACT – Software Solutions, Hyderabad, India
Duration : Nov 05 - July 06
Role                   : Functional Lead for INV/PO/OM/ASCP/ITC/AR/SSP-5
                            NRPS – Project (Network Reliability Products and Services) US, Australia, 
                            Germany)
Worked Through : Quest Am Software, India Pvt. Ltd. /Chain-sys

Responsibilities
My responsibility as a Functional Consultant is to give live production support for issues in Inventory, Purchasing, Order Management, Advanced Supply Chain Planning, Internet Time Card, Accounts Receivables, Self Service Procurement – 5
Active team member in resolving all the Functional Related issue in up gradation from 11.5.8 to 11.5.10
Resolved challenging issues with affiliated modules interfacing with oracle 
To take up as Functional Lead for the offshore team, which plays the biggest support role for U.K based support of our project.
I was sole responsible to submit strategy report over the number of service request raised by our community and to monitor each and every service request to report progress.
As the lead, I have to submit the performance report of our team every weekend to our P.M to state to the business what we are to their needs. 
Having live interactions with clients to make them understand the fix or to get appropriate details from them to further work on the fix. Also to get the functional enhancements from them to accelerate the business process. 
Involved in data mapping regarding clients requirements over technical issues.
Creating CF-250, MD-200 Specifications, and Requirements of Reports and giving user training over enhancement request completion.
Working with the business with various exercise and practice to bring down the case volume and succeeded achieving targets.
To find root cause fix for long pending issues and drive the case to closure.
Worked with all extended modules affiliated to oracle such as GECARS, AR to IBS, PO to IBS, SSP-5, CMF, SMF and APEX 

Project # 2:
Project : SICAL, Chennai, India                                
Duration : Aug   04– Oct 05                       
Role                  : Functional application consultant for INV/PO/OM, 11.5.9, India Localization
Worked Through: Quest Am Software, India Pvt. Ltd. /Chain-sys

Responsibilities
My responsibility as a Functional Consultant is  Configure the Order Management, Inventory, Purchasing module of Oracle apps 11i
Tax Type Setups, TDS Setups, Supplier Master Creation, payment Terms, Transaction Types  using India Localization
Studying client processes, developing AS-IS and TO-BE maps, assisting in implementation.
Responsible to Capture Functional & Technical requirements in interaction with the Client.
Mapping the business requirements in relation to new functionality in Oracle Application.
TO-BE design to meet the client needs.
Provided solutions to the Client by the way of workarounds in the application to cater to their needs.
Set up flex field definitions.
Worked with the technical team for the forms, reports and work flow customization.
Solved the issues in shipping interface, Move order transaction, PO matching, internal sales orders.
Improved the performance of Apps

Project # 1:
Project : Flow serve India Controls Pvt. Ltd. (Whitefield’s – Bangalore)
Duration : Sep 03 – July 04          
Role : Functional application consultant for INV/PO/OM/Advanced Pricing
Worked Through: Quest Am Software, India Pvt. Ltd. /Chain-sys

Responsibilities
My responsibility as a Functional Consultant with Flow serve is to manage the complete Solution and Design related to PO/INV/OM related to their process flow, Configure the Order Management, Inventory, Purchasing module of Oracle apps 11i.
Understand the present (AS-IS) process and map the same into Oracle apps.
Define & Document To-Be (Future) Business Processes for the company 
Design of To Be Business Process,
Did GAP analysis Parameterization
Test the Business Solutions in controlled environment (CRP) along-with critical interfaces
Finalization of Set-Up parameters and profiles 
User Acceptance Testing using full scale data
Create Responsibilities and User menus with the help of System Administrator Verify Production readiness, Ensure timely production and post-production trouble shooting
Training to End users on Oracle Applications and documentation of User Manuals
Configure Oracle Inventory (INV), Oracle Order Management (OM), Oracle Purchase (PO), 
Implementation of Standard functionality of the Following Modules of Oracle Applications using AIM (Application Implementation Methodology)
Extensively worked on Purchase Receipts. 
Co-ordinate with Technical team for stages of Receipts. 

Non-Oracle Apps experience:

Industrial Experience                 May 02 - May 03

I have a year of technical experience in various area of SPIC (Southern Petrochemical Industries Corporation Ltd.,)

About The Organization
Southern Petrochemical Industries Corporation Limited, short - named SPIC, is a giant petrochemical Complex, one of the largest manufacturers of nitrogenous and phosphate fertilizer, in Southern part of India producing 1600 TPD (Tones per day) of Urea, 1200 TPD of Ammonia and 1500 TPD of Di-Ammonium Phosphate (D.A.P). 

Work Accomplished:
Raising Requisition, purchase order, SRS, Internal Requisitions tax calculations for Sales Orders
Complete domain knowledge on end to end supply chain activity. 
R&D Expenditure report Project wise with the potential profit analysis.
Involved in physical count and year-end inventory closing procedures with Inventory Control
Pilot Plant Operation
Control Room Operation (PLC/PC Control Room) for Pyrazinamide Project
Experience in using glass reactors for batch operations 
Day to Day sampling analysis using Gas Chromatography
Utility Plant Operation
Batch Wise Reaction Processing
Supervising (more than 100 Technical Labors)
Water Treatment Plant (With Bio-Reactors)(Waste and sewage)
Handling all kinds of Hazardous Chemicals and Solvents (Acidic and Basic)
Invented hydrogen balloon barrel indicator for R & D purpose
Working knowledge of hexo and endo thermic reactions on positive and negative atmospheric pressure
Independent operational knowledge of Pneumatic high pressure compressors, gear pumps, 50 TR chillers and other utility plant operation. 

Training
Undergone Inplant Training in S.P.I.C. (Southern Petrochemical Industries Corporation Ltd.,) for three months from 14.12.1998 to 05-03-1999.

Operational Plants:
DAP – Di-ammonium Phosphate Plant
Phosphoric Acid Plant
Sulpheric Acid Plant
R & D Pilot Plant 

Permanent Address:
NO: 6 - 1st Cross Street, 
Agastheeswarar Nagar,
Polichalour, 
Chennai – 600074
Tamil Nadu.
India.