Biju Joseph
Oracle Retail Consultant Phone: (+971) 504259378
Email: bijuambalan@gmail.com
Profile
An Oracle Retail Techno Functional Consultant with 17+ years of experience including 6 years in managing IT Division and 11 years of experience in Oracle Retail (RMS) and Warehouse Management (RWMS) including implementation, roll out, post go live support, customization, system design & development (Oracle SQL), external system integration, data migrations and Reports design (Crystal Reports). Seeking a Managerial position to leverage my experience, skills and expertise to enhance Retail ERP or any other Retail Business Applications.
Skills
• Project Design
• Solution and Coding
Process Automation.
Retail Systems
o Oracle Retail Management(RMS)
o Oracle Retail Warehouse Management System(RWMS)
o Store Inventory Management(SIM)
o
Databases
• Oracle 11g & 10g
•
Technical Expertise
• SQL, PL/SQL Coding
• Oracle Apex
• Toad
• Crystal Report
Skills & Expertise Experience
Oracle Retail Consultant (Techno-Functional)
Paris Gallery; Dubai — May 2012–Present
Promoted as Oracle Retail Consultant for Paris Gallery Group, given full responsibility to maintain Oracle Retail Modules (RMS and RWMS). Responsible for new implementations, customizations, solution design for new business requirements, data integration and program building. During the course of the role, I have managed multiple key projects concurrently, provided solutions to many business requirements that includes customizations and external data integrations.
Key Responsibilities of the role:
? Setup and configure fresh implementation of Oracle ERP (RMS & RWMS) to our franchisee companies located multiple locations in Gulf region.
? Provide solutions for the business requirements which can be easily adopted within the technical landscape of the Company.
? System design and development of any new requirement from the scratch.
? Provide effective solutions for the Gaps found within the requirements and the capability of the solution.
? Design and Develop systems to integrate internal and external software.
? Report design and development in Crystal Reports (Expert) and Oracle Reports (intermediate).
? Coordinate with Business Intelligence team and provide SQL queries to enable ad hoc reporting for end users.
? Provide 24/7 Support to retail operations to entire group of companies.
Key Projects:
E-commerce Project (April-2018)
Build a fully automated and integrated solution in ERP Platform
Managed Project plan for implementation of E-commerce Site for Paris Gallery (online.parisgallery.com). Led the project and Built the technical architecture and development for the integrated solution combining various Internal Systems such as the ERP (RMS, RWMS and SIM) etc. with the Magento platform. As a result of our project, end to end automated solution was available which enhanced the customer satisfaction and helped the company transform from a Brick and Mortar Company to Omni Channel Commerce Company.
Retail Implementations:
Oracle Retail Setup for Paris Gallery Qatar (UAT Done)
Started in June 2017 : Project lead
Led the Oracle Retail Part of the ERP Implementation for Paris Gallery Qatar. Mapped the Oracle Retail System to the Business requirements of the client which included both retail and distribution functionality.
Responsibilities:
? Demonstrate features of the existing ERP module to the Client (RMS & RWMS)
? System Requirement study with business team and develop the GAP Analysis Document.
? Submit retail business Project Plan with management.
? Provide effective solutions for the Gaps found within the requirements and the capability of the solution.
? Advocate for the adoption and implementation of industry wide best practices.
? End to End System configuration (RMS, RWMS and SIM).
? Setup & load master data.
? Build reusable customization components for resolution of additional client requirements not covered by the vanilla implementation.
? Enhance usability of the ERP System by suggesting and building additional report.
Oracle Retail Rollout for Paris Gallery – Sultanate of Oman
June 2015 until Feb 2016: Project lead
Successful Rollout of Oracle Retail Solution for a Joint Venture company utilizing existing project plans and strategies. Helped company to deliver the project on-time and on-cost.
Responsibilities:
? System Requirement study with business team.
? Submit Project Plan with management.
? End to End System configuration (RMS, RWMS and SIM).
? Setup & load master data.
? Roll out, post go-live support, customization.
Enhancements:
ERPTools (an Utility tool): designed and developed to support business to have better reports, loading masters, replenishment load based on sales history, create PO and Transfers and many warehouse operations.
APIs :
• RMS : Designed and developed Item Master creation (RMS), Excel Upload, along with Ranging feature and Item publish in POS & RPM.
• RMS : Transfer Creation (Excel Upload): This will support multiple type transfers including markup calculation based on from/to location combination.
• RMS : Purchase Order (Excel Upload), Replenishment upload based on sales history & replenishment method.
• RWMS : Customized allocation for orders created thru Allocation Module, Backend ASN/PO Receipts, Appointment/Container wise put away, Block/Unblock locations, Inventory Adjustments(Excel Upload), Quality Audit etc..
System Integrations:
Integrated service department system (Oracle Apps Purchasing Module) to RWMS:
This involves publish data in RWMS tables from Apps and allow all processes of RWMS work smoothly and post the data into staging tables instead of publishing messages to RMS.
Integrated Ecommerce with RMS, RWMS, SIM and ReSA : Fully integrated solution from Ecommerce Order allocation till shipment that involves automatic transfer creation from nearest stock available store/warehouse based on warehouse delivery schedule, publishing messages to related modules, handling sales returns and stock and price updates to Ecommerce system.
Oracle Retail Business Analyst
Paris Gallery; Dubai-Jan 2009 – May 2012.
Paris Gallery, A privately held business group in the Middle East with core interests in beauty and lifestyle products and services.
Selected as Oracle Retail Business Analyst for Group Oracle Retail, Distribution and RWMS Implementation and given responsibility to do all configuration and migration jobs related to Distribution companies (Gulf Beauty International and Tazweed) that includes warehouse setup, Master setup in RMS and history migration, end to end testing, end user support and Management reporting.
Key Projects:
Oracle Retail Implementation for Paris Gallery UAE and Distribution business for Gulf Beauty Intl and Tazweed.
Jan 2009 till Aug 2010: Project core team member.
Responsibilities :
As a core team member of the implementation team was given responsibility to attend discussions with business team and external vendor regarding business requirements, business solution by system, SOPs, gap analyses & customization, solution mapping, system setup, data migration, testing, end user training, UAT and post go-live support.
? System configured for 56 stores and 1 large warehouse with 4 Facilities.
? A new business process configured in SIM to map the requirement of warehouse operations for a sister company.
Oracle Retail Implementation for Paris Gallery LLC – Bahrain Region
March 2010 till Aug 2010: Project core team member.
Responsibilities :
Roll out Retail business solution for sister company with same business line located in different gulf region configured by utilizing project documents from previous implementation.
I was responsible for System Setup, End to End System Testing (RMS, RWMS and SIM), load master data, Conduct UAT and user Training, post go-live support and resolve system issues through Oracle Support.
System mapped for 6 stores and 1 medium level warehouse with 2 Facilities.
IT in Charge
Gulfbeauty International LLC (Sister Concern of Paris Gallery Group): A Leading Distribution company of a luxury Brands Perfumes, Cosmetics, Fashion jewelry etc. in the Middle East.
September 2001 to Dec 2008
Responsibilities:
? Manage IT department and Manage IT Procurement.
? Implementation, customization, maintenance and support of group retail software.
? Database administration Oracle8i.
Computer Programmer
Data Devices: January 1999 to August 2001
Data Devices is a leading software consultancy in Kerala, India, which concentrate in the hospitality industry. It delivers exclusive Software for Three to Five Star category Hotels and Resorts. Apart from Hotel Software Data devices undertakes computerization of Large Organizations include Exporters, Studios, Distributors, Financial Organizations and Building constructors
Education
Course Institute Place Year
OCP - Oracle (9i) Sites Power Dubai 2004
GNX (GNIIT Software Exports) NIIT Madras 1995-1998
(5 Semesters)Bachelor Degree in Arts Mahatma Gandhi University Cochin 1992
References.
Mr.Amit Kumar, Paris gallery, IT Program Manager PH : 0504596794
Mr.Rateesh, Paris gallery, IT Technical Manager PH : 0564305767