SUMMARY

• IT professional with 15 years of experience in Oracle E - Business Suite(EBS), from application design, development, customization to complete conversion of legacy systems to Oracle Applications (Oracle EBS 11i/R12), and providing Tier-3 production & maintenance support, user training. Strong hands-on experience and proficiency of end-to end implementation in following Oracle Financials, Manufacturing, Supply Chain, HRMS and CRM modules:
• Currently working with Emerson as Principal Developer / Solution Architect (Techno-Functional) for a global business process harmonization project in Oracle Rel R12.2.5.
• Experience as a Techno Functional Lead / Project Lead managing a big implementation across the world in with supporting and developing business processes and completely four imlementations in R12.
• Experience in O2C ( Order To Cash ) and P2P ( Procure to Pay ) cycles process and configuring the system with changes specific to R12.2.5 upgrade .
• Expertise on Oracle Cloud as Infrastructure and Cloud CPQ (Configure, Price & Oracle integration with Oracle EBS Quoting and EBS Configurator.
• Excellent leadership abilities, which leverage vast implementation skills on various Oracle modules.
• Expertise for resolving functional & process issue related to financial, manufacturing and distribution modules and responsible for requirement gathering and designing technical documents
• Expert on Oracle technologies stack, AOL, Developer APIs & Sys Admin, PL/SQL, SQL, SQL Loader, Forms Personalization, Forms Customizations, oracle workflow builder, Forms, Oracle Reports, Java, Discoverer, BI Publisher (XML), REST API, SOA and Oracle databases, UNIX/LINUX scripting and BigMachines Extensible Language (BML) scripting in CPQ Cloud as SaaS.
• Experience in designing and development of Reports, Interfaces, Conversions and Extensions (CEMLI previously known as RICE in 11i), Performance tuning, debugging and PL/SQL Coding.
• Possess good knowledge in Oracle Order to Cash module and Release 12 SLA features.
• Managing and providing guidance to development team for implementing the global solution.
• Resource planning, resource organization, prioritization of work and task activities.
• Experience in Analysis and functional and technical architectural design of business requirements
• E experience in gathering business requirements, analyzing and preparing GAP analysis.
• Technical Review and Analysis of the global objects which are used amongst multiple BUs.
• Excellent experience in developing custom applications (Forms, Reports and PL/SQL), customizations, interfaces, Conversions using ORACLE API's, open Interfaces.
• Experience in KINTANA migration, PVCS and Share Points Issue Tracker.
• Ability to adapt in new environments with different organizations and learn fast to deliver the projects.
• A strong analytical skill for complex problem solving skills.
• Assisting in Conference Room Pilot ( CRP ), System Integration testing ( SIT ), User Acceptance Testing ( UAT ), user training and Issue resolution with Internal IT team members and business users over the full life cycle implementation .
• Excellent written and verbal communication skills and the ability to interact professionally with a diverse group of executives, business leaders, managers and subject matter experts .

PROFESSIONAL EXPERIENCE

Confidential

Principle Developer (Solution Architect)

Responsibilities:

• Implementing JDI process sales offices, business units and manufacturing locations across the globe and require making changes in global forms & trade documents which are using in day to day business.
• Design global design new sites/BUs which adhere existing business processes across globe.
• Based on the distribution facility going live with release, either we implemented Back to Back SO PO or Used Intercompany Drop ship. And design the solution and flows for these processes.
• Developing new requirements of Global forms which have done in following area:
• Working on sales order entry form / quoting form enhancements which have lots of complex design using additional four libraries
• Expert in optimising the performance of Find Customer (Blue man search), ATP, Global Order promising, manufacture lead time functionality and custom designs.
• Analyze, design, develop, configure, Implement Credit / Reinvoice with AME approval functionality for transforming order entry users’ frustrations into joyful experience
• Expert in designing the Oracle Workflows process. Support production issue in OM header/ lines, Quoting approval and PO approval oracle workflows processes.

Confidential Solution Architect

Responsibilities:

• Designing basic Order to Cash Flow for Sales offices and supporting interfaces to achieve flow.
• Based on the distribution facility, we either implemented Back to Back SO PO or Used Intercompany Drop ship. Designed the solution and flows for these processes.
• Implemented Credit Check process using Oracle Credit Management.
• Design the Credit / Re-Invoice process for all Emerson BU’s for return and credit sales orders to optimize the business process rather using oracle Credit and Invoice order process.
• Implemented and configure the Global Order promising process across all business
• Implemented Sales Office Inventory requirements using Oracle Workflow based Product Life Management module
• Integrated Oracle Shipping to an external System called TRAX for Shipping.
• Integrated Oracle OM to an external system called Trade Sphere for Export Compliance.
• Implemented Oracle Incentive Commissions approval process using AME.
• Implement Oracle R12 Sub Ledger Accounting features.

Solution Architect

Confidential

Responsibilities:

• Understand Oracle Cloud ERP implementation modules including Financials and Procurements
• Worked on integration tools such as Oracle Integration Cloud, Oracle SOA Suite and Oracle Cloud Service using REST API and JSON format in design.
• Worked on technical design of Oracle CPQ Cloud (formerly known as Big Machines CPQ) with EBS Configurator and EBS Quoting Integration
• Published design and research on Oracle CPQ Cloud and Microsoft Dynamics 365
• Modifying these Custom Components and test these in R12.
• Log Oracle SR’s for oracle functionalities which are not working in R12 and resolve the oracle issues.
• As Onsite technical architect I worked with DBA’s for upgrade related activities, patch applications, resolving technical issues and also identifying potential issues due to upgrade and resolve these.
• Identifying the Components which will need redesign due to Upgrade to r12.
• Analysing all OM related Workflows and identifying the key changes in R12 which will potentially impact R11 features already implemented.
• Redesigning the Workflows and implemented with exact same functionality.
• Redesigning the OTC Cycle processes built in R11i to support Multi Level Distribution for the Sales offices across all world areas. These OTC Cycle is already implemented in 11i and it was not working in R12 after upgrade.
• Assisting in Conference Room Pilot (CRP), System Integration testing (SIT), User Acceptance Testing (UAT), User Training and Issue resolution with Internal IT team members and business users over the full life cycle implementation.

Confidential

Sr. Technical Consultant

Responsibilities:

• Worked as Development Lead of GSO/GQF/JDI/Configuration/Advance Pricing & Global objects.
• Excellence in development of all new/enhancement activities like TECHNICAL DESIGN and DEVELOPMENT of forms, reports, interfaces, conversions, Extensions and Work Flow.
• Providing direction and support for solution design to development/functional team members.
• Experience in oracle application production support activities pertaining to manufacturing and SCM modules as part of production application support team for Oracle EBS Applications.
• Involved in the upgrade and implementation of the Applications, which included changes to the custom forms, reports, migration of the various modules data.
• Develop & execute strategic business plans for various Global forms customizations.
• Involved in the business set-ups and Profiles for new requirements releases as well as bug fixes.
• Designed and developed business requirement for setting-up Models (sub-models) within the model in Oracle Configuration.
• Customized Sales Order forms to configure models automatically when user enters a Model.
• Involved in maintaining and testing Work Flow customizations to determine if the Item is a hub-stock or buy item and defining sourcing rule dynamically.
• Involved in maintenance and testing of Advance Pricing modifier and qualifier set-ups and customized Sales Oder form to execute pricing for various actions.
• Modified Client Extension, hook provided by Oracle, to modify the general ledger accounts for certain inventory transactions.
• Developed several oracle reports, form, triggers, procedures and packages, concurrent Programs to meet the business requirements.
• Worked on oracle alerts for the Users/Business Analysts in case of set-ups/functionality issues.
• Expertise in setup of Oracle EBS Sys Admin and AOL Objects and configuration
• Designed Flexfield Structures, Segments, Value Sets and Values according to user requirements.
• Expertise in High Level Design, Detail Design Document, Diagram Flow Design base on project.
• Expertise in functional specification and technical specification documents, testing scripts, oracle EBS functional and system configurations, setup and Implementation plan documents.

Confidential

Senior Consultant

Responsibilities:

• Requirement Gathering, Designed Solution Architectures & solution proposals as per requirements.
• Responsible for management, execution and communication requirements for the full project life cycle in Oracle Applications i.e. SCM, CRM and Financial modules.
• Responsible for managing project resources for maintaining an effective communication with project team and business users / clients / customers.
• Managing the project and co-coordinating with client for their data conversion from Legacy system to Oracle Application for suppliers, Invoice sales order, items, Item cost and pricing, sales persons, Invoices & Receipts in receivables, project and resource management, install base, service contract, customers & their support contacts.
• Provide Functional and Technical specifications for specific development of Interfaces and conversions programs as per client requirement.
• Work with development team to clarify requirements / specifications to deliver objective on time.
• Customization oracle forms using Custom.pll and forms personalization as per client requirements.
• Responsible for implementing serial control functionality in Inventory and Order Management.
• Responsible for development of an interface to track budget variance for profit and loss account which is occurred due to fluctuation of FOREX exchange rate during the fiscal year and process will calculate budget variance in budgeted set of books
• Developed shell scripts and cron jobs to schedule and run batch processes in Concurrent Manager.
• Developed Invoice Import Interface program that imports invoices from an external source into Oracle tables after validation.
• Involved in the Implementation of Applications Release of R12, which included Financials, Distribution and project management modules and developed the below conversions/interfaces to convert data from legacy system to Oracle Applications (R12)
• Implemented the serial control functionality in oracle inventory for manufacturing organization, where as designed the below interfaces and reports.
• Designed sales report customer and sales representative wise
• Designed supplier outstanding reports for pending payments
• Developed Unix scripts to achieve the processed files
• Developed program to read flat files & stores in staging table to generate sales order using API’s
• Developed program to complete WIP jobs & initiate inventory transaction worker for online stock update in oracle inventory.
• Developed sales order interface to complete sales order process.
• Developed custom form (Forms6i) to define budgeted rate in general ledger.
• Developed an interface to calculate budgeted variance to track budgeted variance, which is occurred due to fluctuation of FOREX exchange rate during the fiscal year.