SUMMARY:

• 7+ years of experience as an Oracle SCM Techno - Functional Consultant in various phases of Software Development Life Cycle including requirements gathering, analysis, design, implementation, maintenance and production support in Oracle E-Business Suite applications R12 (12.1.3, 12.0.6) and 11i (11.5.10.2, 11.5.9).
• Experience for about 5 years on Order to cash (O2C) life cycles, Quote to Cash Q2C, Procure to Pay (P2P) and Supply Chain business flows.
• Extensive knowledge in Oracle EBS Distribution Modules including Inventory (INV), Order Management (OM), Purchasing (PO).
• Strong technical knowledge on PL/SQL commands & scripts, PL SQL packages and experience of Unix Shell Scripts ( ksh / csh ) in various Applications.
• Hands on experience in SQL performance tuning and strong knowledge in data analysis.
• Good exposure on design and development of RICE Components and involved in implementation and support projects.
• Good understanding on functional flows Order 2Cash, Procure 2Pay and technical architecture of R12 - INV, PO, BOM, WIP, AP, AR, Shipping and OM.
• Worked on various projects for building custom reports for Oracle clients like Oracle XMLP, Discoverer and BI Publisher reports.
• Experience in preparing Functional Design Documents like MD050, TE020.
• Core Team member in development, implementation and support of ShipConsole product, an oracle validated shipping solution. ShipConsole is the premier solution for shipping execution and management for Oracle. It provides multi-carrier online shipping, label printing, and shipment tracking.
• Key member in designing various custom applications like Address Validation, Freight Shopping and Denied Party Screening which is directly integrated with Java Web-Services using HTTP call from Oracle packages.
• Interacted with users, fixed the bugs, developed test plans and provides daily production support.
• Worked on calling web services from oracle applications for ShipConsole Cloud Solutions.
• Had hands on experience working on various oracle modules on finance and supply chain management.
• Team member in implementation of Fusion Financials - Internal Pilot Project.
• Fair Knowledge in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions.
• Developed new Concurrent Programs, Custom Forms, Reports and Flex Field Customizations for various clients.
• Experience in Customization of Standard Oracle Workflows .
• Experience in New Form development .
• Has extensive hands-on experience in developing database triggers, stored procedures, functions and packages.
• Developed Interfaces using APIs and Interface tables.
• Experience in interacting with clients while being responsible for deliverables and ability to work with limited resources, capable of multi-tasking, planning works around concurrent and time sensitive deliveries.
• Experience in Using Version control tools CVS, PVCS and tools like ZOHO, HPQC and Kintana
• Documentation experience, keeping in line with the AIM Methodology.

TECHNICAL SKILLS:

Domain: Oracle EBS Suite Applications R12.1.X, 11i Ver11.5.10.2 Modules (INV, PO, BOM, WIP, WSH, AP, AR and OM) and P2P and O2C cycles.

Software: Oracle Forms & Reports, BI Publisher, XML Publisher, OA Framework

Database: Oracle 10g/11g, essbase, MS SQL Server

Languages: SQL*Plus, PL/SQL, C, XML, UNIX shell scripts

Operating System: Solaris, Linux

Tools /DB/Packages: SQL * Plus, JDeveloper, Toad, XML Publisher, Reports 10g & 6i, Soap UI.

PROFESSIONAL EXPEREINCE:

Confidential, Cherryhill, NJ

Oracle Techno-Functional Cosultant

• Key member in handling oracle upgrade project from R12.1 to R12.2 version
• Reponisble in managing all the objects in database for code readiness for R12.2.5 and implment same in 12c Database.
• Worked on Order to Cash cycles implementaitona in R12.2. and testing.
• Worked on Mnafuctiong modules issues in BOM and WIP.
• Working on custom application errors to fix and migrate to Production.
• Checking compitabilities of various objects in upgraded version and modifing those that are not compitable to meet the new standards.
• Identify and drop obsolete objects in Production to improve performance.
• PL/SQL coding for fixing various issue for the upgrade to database 12c.
• Working with variuos teams for Oracle Database standards for future developments.
• Working with Oracle Team for issues/bugs realated to 12.2 applcation issues.
• Handling issues to apadt new upgraded oracle environment.
• Handle database objects to abide newer latest version of 12c database.
• Train and prepare development team onshore and offshore on the standrards of the upgraded version of Oracle Applicaitions 12.2.

Confidential

Senior Oracle Techno-Functional Consultant

• Perfomed a Techo-Funcitonal Consultant role to deploy ship console product for variuos Oracle application implemented clients and customize the product to cater their need.
• Performed Setup and Configuration of E-Business Suite Rel. R12 modules(OM, INV) for the Procure-to-Pay (P2P), Quote to Cash Q2C and Order-to-Cash (O2C) cycles.
• Good hands on techincal expierence on Order Management and Invetory modules in Supply chain Management module.
• Lead onshore-offshore coordination of several small to midsize projects for varouis clients.
• Wrote PL/SQL packages for different validations, for processing data by the ship console product.
• Worked on solution design and setup of Inventory & Order Management as per the client requirements and suggested business process changes.
• Worked Oracle forms to navigate back and forth JAVA applications.
• Assisted with migration and deployment strategies.
• Frequently communicated with and managed customers.
• Provided diagnostics utilizing SQL and PLSQL and drafted reports upon analysis completion.
• Was in constant communication with customers throughout.
• Completed impact analysis of setup changes.
• Helped the team in solving critical issues.
• Performed incremental setups.
• Tested script preparations and engaged in integration and pilot testing.
• Completed analysis of SCM strategies and drafted evaluative client reports.
• Created functional design documents (MD.050) for customizing forms to address business requirements and to address the labeling requirements.
• Prepared training documents and assisted in user training in OM & INV modules
• Negotiate technical and non-technical solutions that both satisfy the business user and conform to the technical architecture.
• Requirements Gathering, Data Migration, Extensive work on RICE components that include Reports (RDF and XML Publisher)
• Developed new RDF reports and also XML publisher reports.
• Developed new form in the custom Module
• Prepare MD070 and MD050 for the SR’s.
• Preparing Unit Test Documents.
• Customized the existing forms as per the business requirement.
• Created the shell scripts to migrate the developed objects across the instances.
• Created form personalization as per the business requirement.
• Conducted and coordinated CRPs, UAT - unit testing, integrated testing

Technologies: Oracle E-Business Suite Release 12 (OM, INV, PO), Oracle Reports, Oracle Form Personalization, XMLP Reports, JasperSoft Reports, PL/SQL Developer, PL/SQL.

Confidential

Oracle EBS Techinical Consultant

• Handled delvelopment and deployment of a custom application that will identifiy denied parties for the booked orders of a given range of dates.
• It also apply holds to the order that are found to be booked with denied party addresses and aslo update flag on the party site address and inactive them immediately.
• UPS denied party web-service is used in HTTP call from Oracle packages in framing and parsing response.
• Development of custom XMLP reports that identifies denied party addresses though a concurrent programs from scratch.
• Analyzing the requirements and discuss with Functional users and prepare Technical documents.
• Lead the design and development for 5 Oracle reports
• Responsible for all RICE deliverables.
• Gathering requirements and preparing MD 70 and TE20 and MD120 documents.
• Provided complete training and documentation for technical staff
• Involved in performance tuning of SQL queries
• Created UNIX scripts to migrate the objects from one instance to other.
• Involved in converting Oracle Standard Reports into XML Reports.
• Involved in registration of various AOL objects Functions, Value set, Concurrent programs.
• Designed and Developed necessary feeder system i.e. staging tables, validation routines using SQL* Loader, SQL and PL/SQL procedures
• Creating Data Definitions, Template in Oracle XML Publisher Administrator.
• Prepared Build Notes and Unit Test Scripts for the respective objects.

Technologies: Oracle E-Business Suite Release 12 (OM, INV, PO), Oracle BI Publisher Reports, XMLP Reports, Oracle Workflow Builder, Toad, PL/SQL Developer, SQL*Plus, PL/SQL.

Confidential, Bowling Green, KY

Functional/ Business Analyst - Oracle E-Business Suite Applications

• Responsibilities included gathering user requirements and preparation of business requirement documents ( Confidential / Confidential ).
• Key member in developement and deployement of multiple custom applications like Freight Shopping and Address Validaiton program which has tight integration with Order management and Inventory modules.
• Created many new concurrent programs to automate the process.
• Freight Shopping is a form personolization that gets triggered from Order Manager to showcase various freight rates for each carrier for the given items in the booked order.
• Users can select and update a chioce of ship methods that are configured and active in oracle based on the freight rates shown by the applciation using Public API’s.
• Address Validation is custom cocurrent program that can validate address for give range on sales order booked dates and identify the invalid addresses.
• It also pull up address type and address classification for all the valid address.
• It uses UPS or FedEx webserivices to validate the given address that is framed and parsed by concurrent program.
• Address valdiation is tightly integrated with Order Management responsibility.
• Customization and development of reports Order Management module.
• Created various new value sets as per customer requirement.
• Customization and development of reports Purchasing module.
• Loading the data from external files to temporary table by using SQL*Loader, validated the data and then inserted the resulted data in the Inventory base table.
• Involved in required functional setups and form personalization.
• Reviewing the progress of issues with Project Manager.
• Involved in client discussions and gathered information directly with client.
• Responsible for User Accepting testing (UAT), Functional testing and System testing.
• Supported system for 24/7 basis if required.
• Understanding Functional Design and get the clarification, preparing technical design document based on AIM methodology standards.
• Developed reports using XML Publisher and also converted some standard reports to XML reports.
• Developed new reports in Oracle R12 using 10g report builder.
• Reviewing functional specification and get clarifications from onsite, Preparing technical specification, Coding and unit testing, preparing documents like UTP and installation instructions.
• Proposing solutions for the requirements and Involving in status calls.
• Registered Concurrent Programs and custom Applications using System Administration.
• Test the developed code as per the cases given in FDD and fixing bugs.
• Designed MD070, TE20 and developed the code to meet the client’s requirements MD120, for extracting the correct data to meet the client requirements.
• Worked extensively in XMLP reports.
• Preparing Unit Test Plan and Installation Documents

Technologies: Oracle E-Business Suite Release 12 (OM, INV, PO, AP, AR), Oracle Reports, Oracle Form Personalization, Oracle XMLP Reports.

Confidential, Dallas, TX

Oracle E-Business Suite Functional/ Test Analyst - Oracle Applications

• Performed Setup and Configuration of E-Business Suite Rel. 11i modules(PO, OM, INV, AP, AR, PA) for the Procure-to-Pay (P2) and Order-to-Cash (O2C) cycles.
• Gathered user requirements from end-users of legacy ERP systems and mapped them to E-Business Suite Order Management, Purchasing and Inventory modules. Developed training guides and conducted training sessions for end-users. Wrote requirement documents( Confidential / Confidential ) and worked effectively with new users to train them in the use of Oracle E-Business Suite.
• Tested SCM for Oracle E-Business using PO, AP, OM, Inventory, AR etc. Created customers, sales orders, booked sales orders, checked for availability of material. Created Pick Release, Drop shipment, RMAs etc.
• Created, tested, and verified POs, Negotiations, BPAs, Releases, and Receipts. Created and tested invoices, debit memos, credit memos, etc. and payments. Used HP Quality Test and Test Director for logging defects and defect tracking. Execute Regression testing and closing of system defects.
• Setting up of complete order cycle setups from order entry in order management to ship confirm in shipping execution
• Setting up of Document types, buyer, supplier and approved supplier list in purchasing module
• Gathering requirements and preparing MD 50, MD 70.
• Worked on PO Conversion.
• Preparing Solution Design Documents for the developments.
• Interacting with clients to get the requirements and support activities.
• Involved in regular Support Activities.
• Involved in Unit Testing of the developed objects.
• Responsible in developing Sales Order Interface using the Standard API’s
• Prepared training materials to the business users

Technologies: Oracle E-Business Suite 11.5.9/ R12 (AP, AR, OM, PO, INV). Oracle Forms, Oracle Reports, Oracle Workflow Builder, Toad, PL/SQL Developer, SQL*Plus, PL/SQL.