PROFESSIONAL SUMMARY:

• Having 8+ years’ experience in Oracle EBS and Teaching. Proficient in Oracle EBS R12, SQL, PL/SQL, Forms, Reports, XML Publisher, SQL*Loader, Workflow, OBIEE, OAF, RICE Development as well JAVA/J2EE, .Net, Web Service(SOAP/REST), Web Development, Testing.
• Having hands on experience in Oracle EBS applications functional configuration, business processes flow, AIM Documentation, data structures in OM, PO, INV, Advanced pricing and Quoting, GL, AR, AP, AOL.
• Highly Expertise in techno functional support of Procure to Pay and Order to Cash cycles.
• Experience in creating, modifying Forms6i/10g, OAF pages for extending and customizing applications as per the business needs.
• Experience in preparing the technical and functional requirement documents like MD50, MD70, TE40 and TE20. Good team player, excellent communication skills.

TECHNICAL SKILLSET

Oracle Technologies: Database Oracle 9i/10g, Oracle EBS 11i/R12

Oracle Financials: General Ledger GL, Receivables AR, Payables AP, Sub ledger SLA

Oracle SCM: Inventory INV, Order management OM, Purchasing PO

Database: Oracle 9i/10g, MS SQL Server, PGAdmin4

Oracle Development: SQL, PL/SQL, TOAD, Developer, Forms/Reports/Workflow Builder, Sql*Loader

Reports Development: OBIEE, Discoverer, Noetix, IBM Cognos, Tableau

Web technology: SOA, Java/J2EE, JDeveloper, Eclipse, XML, SOAP/RESTfull Web services

Programming Languages: C, C++, .Net, C#, JAVA, VB Script, JAVA Script, HTML, CSS, MVC

Others: UNIX, Shell Scripting, PGAdmin4, MS SQL Server, SOA, ADF/OAF, HP ALM

WORK EXPERIENCE:

Confidential, Woburn MA

Oracle Consultant

• As aSCMFunctional Analyst supported the Supply Chain modules: Order Management (OM), Purchasing (PO), Inventory (INV) of Release 12.1.3
• Contributed validating Oracle R12 Upgrade technical and functional deliveries by system integrator PWC
• Performed high level analysis of AS IS 11i business processes, Oracle R12 Upgrade steps
• R12 Upgrade impact analysis on technology, customization, data structure, API, process and new features
• Performed health check of new R12 instance EBS configuration, processes flow navigations and data
• Identified R12 Upgrade API changes and fixed invalid objects calling API and validated changes
• Prepared, Reviewing and approving theFunctional, Design and Unit test documents.
• Hands on changed RICE, configuration, pl/sql packages, forms, reports, folders, OAF, AOL
• Reviewed, monitored DBA installation, cloning, Refresh, Patching, R12 Upgrade, code promotion
• Reviewed R12 FMW technology stack integration of Weblogic, OEM, B2B SOA, OBIEE, ODI
• Managed Infra environment, team WBS, reviews, change approval, configuration management
• Validated developed PLSQL Packages and procedure for Inventory and PO Transaction Interface
• Updated conversion methodology for Purchase Order Interfaces, Items, Categories, Item Costs, Sub - Inv, On hand, BOM, Pricing, HR locations, Folders.
• Worked on the data loader to load data from Spreadsheet to Oracle EBS Suit Inventory.
• Worked with P2P business users to understand the requirements and review old test cases to add new ones.
• Worked onOracleInventory module - setting up Item Master, Defining Item Attributes, Item Templates, Item Categories, Item Catalogs, Min Max and Re-Order point planning, Cycle Counting, Physical Inventory, etc.
• Worked on the setups of the Material Resource Planning (MRP) module - setup planning parameters, plan options, etc.
• Worked on setting up order verification holds and new customer credit check holds in OM
• Performed setups & did integration testing for split shipment, drop shipment process, RMA process, shipping parameters with Quoting, Order Management & custom made 'Scheduling & Dispatch' modules
• Prepared SQL Query for Data Analysis, Data Modeling and Architectural design for Projects
• Prepared test cases, test scenarios, test data mining and executed Unit/CRP/UAT testing
• Provided user system support for data loader, interfaces clean up, concurrent program executions, testing
• Logged testing defects, worked with developers/DBA for fixes, code change approvals and code promotion
• Conducted sessions for users to give them knowledge about how the system is going to work.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Performed post upgrade functional configuration, customization changes and system verifications
• Enhancement and Support, which involved giving Production support by interacting with user for, trouble tickets and establishing the process to be followed.

Environment: Oracle EBS R12.2.4 SCM & Finance, Oracle Developer, Discoverer, OBIEE Answer, Developer, Cognos, HP ALM, HPUFT

Confidential, CA

Oracle EBS SCM Consultant

• Provided production trouble tickets support, interface maintenance and month end close support
• Core team member forOracleEBS: SCM (Inv, OM and purchasing, Advanced Pricing and Quoting) and Financials (GL, AP, AR)etc
• Worked closely with the onsite team on High level analysis of current Order Fulfilment processes;
• Developed several enhancements to the Business Processes on the Order to Cash side and Worked on the entire Order to Cash cycle.
• Worked on Back to back order, drop shipment order, RMA etc
• Worked on the setups of Positional Hierarchy Approval Hierarchy inOraclePurchasing.
• Worked on defining the Purchasing and Receiving Option inOraclePurchasing.
• Defined Buyers and setup their roles inOraclePurchasing.
• Design & Delivery of user requirements workshops coveringOracleOrder Management, Shipping, Advanced Pricing, Inventory, Bill of Materials, & Configuration
• Developed scripts, queries, and reports in SQL and PL/SQL for data extraction and manipulation
• Worked onOracleApplication Framework (OAF) to develop custom solutions forQuoting, Order Management, and Customer Master andPricingModules.
• Development involves analyzing MD50 (Functional Spec) and then writing MD70 (TechnicalSpec).
• Created security function model using OAF (Java EE Framework) -It will make sure thequotinginfo would be displayed only to authorized sales representatives.
• Responsible for converting a Quote(OracleiStore andOracleQuote) to an Order, integrateadvancedpricing and configuration solution, re-designing the order entry and upfront validation process for fulfilling their order life cycles usingOracleR12.
• Created new databases, users, roles, tables, views, triggers, packages, procedures, functions, materialized views, directories
• Used SQL*Loader to import third party data from CSV files to staging tables for further analysis and processing.
• Debugged and developed various inbound and outbound interfaces to send files to other practices
• Modified SO Line workflow to add notifications and supported PO Approval customization
• Configured & scheduled various Concurrent Programs, Value sets and alerts
• Validated developed PLSQL Packages and procedure for Inventory and PO Transaction Interface
• Analyzed SQL statements and designed indexes to improve response of queries.
• Performance Tuning done by using Explain plan and query optimization techniques and created necessary indexes.
• Performed the form personalization, OAF personalization for Order management and EAM.
• Prepared Test Scenarios and test Script for Order Management, Purchasing and Inventory
• Executed test script with end user as part of Unit/CRP/UAT testing
• Provided user system support for data loader, interfaces clean up, concurrent program executions, testing
• Developed materials to assist end user in new functionalities of Purchasing, Supplier and Order-to-cash modules.
• Logged testing defects, worked with developers/DBA for fixes, code change approvals and code promotion
• Supported multiple environments (development QA and production).
• Migrated data between system(s) upon a system upgrade and software upgrade.
• Prepared design documents to share among the group to facilitate knowledge sharing .

Environment: Oracle R12, SQL Developer, SQL/PLSQL, HP ALM, OBIEE, Form Builder, Report Builder, Workflow builder, XML Publisher, UNIX, JAVA/J2EE

Confidential, Pittsburgh PA

Oracle SCM Techno Functional Consultant

• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications R12 Procure to Pay Modules (Account Payables (AP), Account Receivables (AR), General Ledger (GL), Purchasing (PO), Inventory (INV), Order Management (OM).
• Converting Functional Documents into Technical Documents using AIM methodology and Client specific methodologies.
• Customized and modified the existing forms using Form builder according to the requirement of the Business user.
• Responsible for Form Personalization, Reports Customization, RTF/XSL-FO template creation.
• Developed the XML Publisher reports on the Inventory module for Packing Slip and PO Vendor Invoices.
• Developing Inbound and outbound Interface codes to interact between Legacy and Oracle Apps systems
• Loading data into interface tables and running the standard import programs to push the data into standard tables from interface tables
• Creating Lookups and Value sets where ever needed which avoids hard coding in the PL/SQL coding
• Worked to improve the performance of the system by tuning and restructuring PL/SQL units for optimum performance.
• Used FTP to transfer the files into different servers as needed by the business users.
• Created temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Ensures that all the assigned deliverables are completed on time and with impeccable quality.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Initiating RFC (Request for change) process of change management for any kind of change in production application and implementing the changes as approved in RFC.
• Resolving production support process / methods, troubleshooting and proposing solutions using a change management process in Production Environment
• Informing and supervising monthly down time of applications at time of reconciliation or any change implementation.

Environment: Oracle 10G/11G, TOAD, SQL/PLSQL, HP ALM, OBIEE, SQL Loader, XML Publisher, UNIX, JAVA/J2EE, MS SQL Server