SUMMARY:

• Software Professional with an excellent record of architecting & delivering complex and high performance solutions by using a practical patterns - based approach to achieve stated objectives within limits of time, budget and stakeholder’s satisfaction.
• Expertise in extending oracle applications through custom applications development, Enhancements, Customizing, Developing and Configuring Oracle Applications.
• Continuous excel to implement best practices to improve efficiency and productivity of supply chain applications to meet the business goals and objectives
• Hands-on Experience in Procure to Pay (P2P) and Order to Cash (O2C) business process areas and end-to-end transaction flows
• Hands-on Experience in Cassandra Data Model Design.
• Process & Methodology (Oracle AIM).
• Consist Competencies in Implementation, Customization, upgradation of Oracle Applications- eBusiness Suite
• Technical leadership with responsibility for delivering technical services and delivery of on-time, Quality data
• Have worked for following Major Organizations in implementation of Oracle Supply Chain and Manufacturing projects in various capacities.
• Holding Bachelor Degree in Computer Science and Engineering.
• Sound communication skills, result oriented, open to learning new technologies and a good team player
• Overall Experience 16+ Years with combined experience as Oracle Technical Expert in the areas of Oracle Manufacturing and Oracle Distributions area, Reporting, Analytics, Datawarehouseing, and Enterprise Architecting

TECHNICAL SKILLS:

RDBMS: Oracle

DBMS (No-SQL): Cassandra, Knowledge of MongoDB

ELT: ODI (Oracle Data Integrator)

Data Replication Package Software: GoldenGate

Tools: Oracle Developer2000, Forms 3.0/4.5/6.0, Reports 2.5/6.0, Toad, Shell Scripting, SQL, PL/SQL

Analytical Tool: Tableau, OBIEE

Reports: BI Publisher, XML Publisher

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, California

Senior Tech Lead / IT Consultant

Tasks and Responsibilities:

• Moved Oracle ERP Custom Reports onto Cassandra (NO-SQL) to reduce the load on ERP Instance and meet the business SLAs. As part of this project, we have leveraged Oracle GG (Golden Gate) to capture the incremental changes and integrated with ODI (Oracle Data Integrator ) ELT tool to generate DFS to move the data from Oracle ERP to Cassandra in near realtime using Cassandra Bulk Loader.
• Designed Cassandra Data Model.
• As part of building the reports using the Cassandra we have leveraged Spark to process large volume of datasets
• Design and develop the technical solutions (Oracle ERP) in co-ordination with Solution Architects
• Redesigned the Cost Rollup program for better processing times utilizing the Bills of Material standard APIs and advanced Oracle concepts.
• Leveraged Order Import Interface program to import New, Change and Completed Sales orders or Returns from other applications.
• Leveraged Auto Invoice Interface to Import Receivables transactions from external systems
• Configuration of Concurrent Managers.
• Designed and Implemented Pricing related Enterprise Discount Management System (EDMS) transaction engine
• Designed and Implemented Custom Applications extending Service Contracts and Install Base Module capabilities
• Negotiate technical and non-technical solutions that both satisfy the business user and confirm to the technical architecture.
• Coordinating closely with Technical development team, functional testing team for the smooth delivery of the component.
• Mentor the team on complex business issues to arrive at the technical solutions to be implemented
• Review the code designed and developed by the team.
• Analyzing the issues on Production System and resolving them
• Involved in Developing Oracle Reports using XML Publisher

Environment: Oracle Applications 12.1.3, Oralce 11g

Work Area: Order Management, BOM, Inventory, WIP, Application Object Library,Service Contracts, Install Base, Cassandra, Oracle Gloden Gate, Oracle Data Integrator, Spark.

Consultant

Tasks and Responsibilities:

• Worked on solution design and setup of Oracle Inventory, Order Entry/Management,Oracle Receivables, Bills of Material and Work in Process as per the client requirements and suggested business process changes.
• Design, Develop and Implementation of various processes in Oracle Applications by mapping the existing processes.
• Designed and developed Custom PL/SQL APIs to extend Oracle Application functionality in the areas of Order Entry/Managment, Bills of Material, Oracle Receivables & Work In Process.
• Involved in resolution of functional issues related to Oracle Manufacturing and Distribution during implementation of modules
• Setup and maintenance of alerts and notifications
• Extensive usage of standard Oracle Application APIs while porting the custom functionality onto Oracle Applications.
• Involved in External Systems integration with Oracle Applications.
• Negotiate technical and non-technical solutions that both satisfy the business user and conform to the technical architecture.
• Developed UNIX Shell Scripts for migration of DFF to different Environments.
• Provided post production support for all issues - standard, custom, and some legacy system issues.
• Involved in Preparation of Technical Design Documents( MD70) as per Oracle AIM
• Developed Implementation foot print with connecting points to legacy and Oracle Apps
• Mentor the team on complex business issues to arrive at the technical solutions to be implemented.
• Applied the comprehensive knowledge of field of specialization in Oracle Manufacturing
• Organized discovery sessions to identify the integration points, interfaces and conversions

Environment: Oracle Applications 11.0.3, PVCS, Kintana, Oracle Developer 2000

Oracle EBS: Order Entry/Management, Oracle Receivables, BOM, WIP, Oracle Inventory,Application Object Library

Senior Consultant

Tasks and Responsibilities:

• Lead Technical Consultant
• Involved in Preparation & Review of Technical Design Documents(MD70) adhering to canon standards
• Design and develop the technical solution in co-ordination with business users
• Review the code designed and developed by the team
• Involved in Customization of Standard Contracts Authoring form.
• Mentor the team on complex business issues to arrive at the technical solutions to be implemented
• Performed to deliver the projects under tight schedules by overcoming the technology challenges

Environment: Oracle Applications 11i, Oracle Developer 2000, Oracle, UNIX Shell Scripting

Work Area: Oracle Service Contracts, Install Base.

Senior Technical Consultant

Tasks and Responsibilities:

• Technical consultant leading the team of Onsite and Offshore while Implementing Supply Chain Modules and Legacy System conversion project.
• SPOC for all technical aspects of the conversion including leading technical consultants in customizing Oracle Applications 11.0.3 Modules utilizing AOL and the developer/2000 toolset.
• Customization of standard Oracle Application forms adhering to Application Coding Standards.
• Preparation Technical Design Documents (MD70) as per the Oracle AIM methodologies
• Extensively implanted customization to Standard Customer Form in Accounts Receivables.
• Designed and developed Master security form to implement custom security on customer form
• Developed custom PL/SQL program to modify the existing planning and forecasting using the BOM explosion API and invoking the standard WIP job
• Developed Mail Notifications with the details of the lines those are not fulfilled for WIP job creation based on the functionality
• An automated and scalable solution for managing customer corporate receivables and credit exposure. Customize the standard Oracle Credit check to Line level
• Streamline the period closing and reduce it to one day.
• Designed and developed business user specific reports
• Designed and developed Order Import Interface process
• Developed Outbound Invoice Program to send invoice details to web services in flat file format
• Coordinated numerous Oracle Application data conversion implementation projects while implementation.

Environment: Oracle Applications 11.0.3, Oracle Developer 2000, HP- UNIX

Work Area: Order Entry (11.0.3), Oracle Receivables, BOM, WIP, Oracle Inventory

Technical Consultant

Tasks and Responsibilities:

• Lead Technical Consultant Leading the team of Onsite and Offshore while implementing the Oracle Purchasing, Oracle Payables & Oracle Alerts.
• Participated at the various stages of the implementation from Business Requirement gathering, Analysis, Design, Development and Implementation.
• SPOC for all the technical aspects of the conversion including leading technical consultants in customizing several Oracle Applications 10.7NCA utilizing AOL and the developer/2000 toolset and maintaining custom/standard applications relating to the 24/7 production oracle 10.7NCA system.
• Extensive customization of Purchase order form, Release form
• Customized the Oracle standard flexBuilder to generate Charge account based on Category.
• Designed and Developed PL/SQL package to upload items.
• Designed and developed the auto creation of purchase releases
• Design, development and implementation of Event and Periodic Alerts
• Customization of Standard oracle application forms and reports adhering to the applications coding standards.
• Responsible for delivery of components defect free.

Environment: Oracle Applications 10.7 NCA (GUI)

Work Area: Oracle Inventory,Oracle Purchasing, Oracle Paybles & Oracle Alerts

Consultant

Tasks and Responsibilities:

• Technical Consultant.
• Developed custom PL/SQL program for Annual Physical Inventory valuation by extending the Oracle Applications.
• Designed and Developed Extraction API for extracting the Purchase order Information
• Designed and developed the weighted average costing program using standard BOM explosion API
• Designed and developed custom reports using SQL Reports 1.1.

Environment: Oracle Applications 10.6 CUI, Oracle, Oracle Forms 2.3, Oracle Reports 1.1Work

Area: Oracle Inventory, BOM, Oracle Cost Managment and Oracle Purchasing.

Programmer

Tasks and Responsibilities:

• Design and Development of FAS and HRMS Systems
• Participated in Testing and Implementation.

Environment: Oracle 7.3, Oracle Developer 2000 Suite