SUMMARY:

• Around 12 years of IT and relevant experience as Oracle Applications confidential  consultant mainly involved in Business analysis, feasibility study, design and coding phase of the projects.
• Involved in Gap analysis, Requirements Analysis, application design, development, Upgrade and testing phases of Oracle applications.
• Involved in identifying the AS - IS and TO-BE business processes and providing techno-functional solutions to the business.
• Experience in preparing Configuration documents (BR100), Installation Documents, design documents (MD070\Technical Specification Documents), End to End test scripts and providing user trainings.
• Implemented Oracle Applications R12 (12.1.3) for Confidential, Schaumburg as technical architect providing design and feasibility study for BOM, INV and OM modules.
• Implemented Oracle Applications R12 (12.0.4) for Confidential, Abudhabi as technical developer providing design for Oracle Financials AP, GL, Fixed Assets and PO.
• Good functional knowledge in OM, INV, BOM, PO,WIP, Advanced Pricing, iProcurement, AP, AR and GL.
• Expertise in providing Technical solutions for Order to Cash and Procure to Pay modules.
• Involved in development and Customization of Interfaces, Concurrent Programs, PL/SQL Procedures & Packages, good knowledge in developing XML Publisher Reports and SQL performance tuning issues, Advanced PLSQL, SQL Loader, JSON Formats, Xml, XSD, WEBADIs, Workflows and OAF personalization’s and Customizations.
• Having strong knowledge in handling technical components in upgrade to higher versions of Applications. Involved in two upgrades from 11.5.6 to R12 Upgrade (Re-Implementation) and 11.5.9 to 11.5.10 upgrade.
• Expertise in Writing SQL queries, Procedures and having strong knowledge on reports.
• Experience in developing conversion programs and open interfaces for Data Migration to Oracle Applications from Legacy Systems.
• Experience in imparting training to user groups, preparing training manuals, design documentation (BR100), Functional specifications (MD50), Technical specifications (MD070), Business Process Diagrams, Module Specific & End-to-End Test Scripts.

PROFESSIONAL EXPERIENCE:

Confidential, Clearwater, FL

Oracle EBS Senior Developer

Responsibilities:

• Building Auto Move Order Creation process for Sales Orders WIP Jobs and Pick Ticketing & Auto Label Barcode reports.
• Developing Data Migrations\Integrations packages for Oracle confidential Data (Sales Orders, Sales Rep, Pricing, Customer Contacts, Products. Etc) to Mongo DB. Designing JSON formats\JSON Data for confidential Data which feeds Mongo DB.
• Analysing the requirements and giving the various technical feasible solutions to meet the functionality.
• Working with SOA teams for developing plsql packages for Website Sales Orders and Customer creation process.
• Providing technical solutions for Oracle confidential  ERP for the modules - Order Management, Inventory, BOM, Inventory, Purchasing, Accounts Payable, AR and General Ledger.
• Performs enhancements, explanations of how to perform tasks or bug fixes that could result from problems with the base functionality or problems caused by some form of customization.
• Ensure that systems are developed and implemented according to all published standards.

Confidential, Anchorage, AK

Oracle EBS Senior Developer\Lead

Responsibilities:

• Responsible for Day to Day and Period Close Activities.
• Understanding the Requirements and analysing/documenting the efforts required for Technical Design for each custom object and also giving various possible technical solutions for the enhancement Requests and new developments.
• Analysing the requirements and giving the various technical feasible solutions to meet the functionality.
• Monitoring, fixing, testing and debugging day to day support tickets and ensure they get resolved in stipulated timelines without missing SLA’s.
• Working with end users and IT teams for daily support activities and ensure the business flows are smooth in the system. Ensure users test and confirm properly before we apply any technical fixes or functional workarounds.
• Pro-actively participating in Major Patching on half yearly basis by connecting with End Users, IT Team and DBA’s. Ensure users & IT Team test, do a complete end to end tests and signoff all the standard and custom functionality works fine before go-live of Major patching.
• Provide functional and technical support to users of the Oracle EBS ERP for the modules - Order Management, Inventory, BOM, Enterprise Asset Management, Inventory, Purchasing, Accounts Payable, AR and General Ledger.
• Perform OAF Customizations and Personalization’s.
• Performs work assignments related to enhancements, explanations of how to perform tasks or bug fixes that could result from problems with the base functionality or problems caused by some form of customization.
• Ensure that systems are developed and implemented according to all published standards.
• Share technical expertise with other analysts and clients by consulting individually with them, by providing formal and informal training and by directing the development and distribution of formal and informal documentation.

Confidential, Columbus, OH

Technical Lead for Manufacturing Track & SCM track

Responsibilities:

• Performing requirements gathering.
• Creation and finalization of templates, data model, data Migration programs, data formats that will be leveraged for all different Legacy Systems.
• Participating in System Validation Demo sessions and understanding Fits and Gaps related to requirements.
• Understanding the Requirements and analysing/documenting the efforts required for Technical Design for each custom object and also giving various possible technical solutions.
• Analysing the requirements and giving the various technical feasible solutions to meet the functionality.
• Building WEBADIs to load Items, Item Costs, BOMs and Routings for the system Validation Demo.
• Perform OAF Customizations and Personalization’s.
• Assisting Functional teams technically to complete system Validation Demo for Manufacturing and SCM modules successfully.
• Identifying existing Data Migration programs, Check what ENP functional team suggests, Review and finalize which will be best to use for sites rollout.
• Knowledge sharing and Onsite - Offshore Coordination.

Confidential, Eden Prairie, MN

Oracle EBS Developer

Responsibilities:

• Performing requirements gathering.
• Creation and finalization of templates, data model, data Migration programs, data formats that will be leveraged across all the waves for INV, BOM, Costing, PO, OM modules.
• Identifying existing Data Migration programs, check what EPM functional team suggests, Review and finalize which will be best to use for sites rollout.
• Capturing pain points related to MDM through sessions with confidential.
• Define basic validation rules (technical Rules such as column can’t be null) as part of template finalization.
• Prepare Cross reference file having all values from Oracle which can be used for site specific data mapping. Define Data Validation Report & layout.
• Prepare checklist for required/optional setups and pre-requisites across all modules in scope.
• Build Data Migration Programs as generic as possible so it can be used for other RMT waves.
• Profiling Master Data (Inventory, BOM), Loading the data, validate the Data and make the data ready for Business process.
• Finalize Data Cleansing Rules, Coordinate with extraction team to clean data and standardize the data extraction in source system.
• Knowledge sharing and Onsite - Offshore Coordination.

Confidential, Schaumburg, IL

Oracle EBS Techno Functional Consultant

Responsibilities:

• Involved in discussions with Customers for gathering the requirements for BOM, INV, Costing and Order Management related conversions and Interfaces
• Prepared Customer Requirements and Development Requirement documents for BOM, INV, Costing and Order Management.
• Develop conversion programs to convert various master level data (Inventory, BOM, Costing data) from regional Oracle 11i instances and SAP to Oracle Global R12 instance.
• Technical INV, BOM and OM architect providing solutions and design for Conversions, Interfaces and Report designs.
• Involved in Global BOM design and their solution activities along with their functional setups.
• Develop interfaces from external systems to Global Oracle R12 instance.
• Setting up the POC instance to determine the “To-Be” process.
• Presenting the Customer Requirements and Development Requirement documents to
• Business and IT Users for getting the approvals.
• Involving in GAP Analysis for Customer Requirements.
• Providing Estimations, Code Version control, Code development and Unit testing.
• Knowledge sharing and Onsite - Offshore Coordination.

Confidential, CA.

Oracle EBS Developer

Responsibilities:

• New Developments and Enhancements for the existing Advance Search page in OCM application.
• Development of new procedures and functions using Advanced Plsql to get the new business process.
• Testing scripts and validations as per user requirements and preparing unit test cases.
• Development of new Oracle API’S for Linking, Delinking and Moving in Service Contracts and Install Base.

Confidential

Oracle EBS Developer

Responsibilities:

• Development and Enhancements of Custom XML Publisher Reports as per the requirements.
• Involved in development of Custom components like Migrations, Interfaces (Especially GL Interface), Packages, Procedures, functions, Custom.pll and Forms Personalization’s.
• Developed Cheque Report for the client to print on Preprint Stationary and integrating with the Applications which is entirely different in R12.
• Customized Workflows to send notifications when required.
• Knowledge sharing and Onsite - Offshore Coordination.
• Took the responsibility of migrating the data and all technical components into Oracle system (PRODUCTION) by being there at onsite. Day to Day Support Activities.

Confidential

Oracle EBS Developer

Responsibilities:

• Upgrading the Custom Reports, Packages and Custom Forms to R12 standards and ensuring that it works fine like the older version.
• Development of Scripts to update the id columns of Custom Tables with reference to standard tables.
• Migrating all the Custom components from 11.5.6 to R12 and ensuring them all work as per the previous version.

Confidential

Oracle EBS Developer

Responsibilities:

• Development and Enhancements of Custom XML Publisher Reports as per the requirements.
• Involved in development of Custom components like Conversions, Interfaces (Especially GL Interface), Packages, Procedures and functions.
• Worked with Custom.pll and Forms Personalization’s.
• Involved in development of test scripts and end to end application testing after the data migrations.