SUMMARY:

• Total 9 years of Oracle Applications Techno - Functional experience with Oracle Applications (R12, 11i, 11.5.9) and legacy Business Application Development projects which integrates with Oracle EBS. Manage, mentor offshore support & project development team, encourage team to open-up for suggestion / solutions. Eliminate process bottleneck, improvise & guide team to triage for customer service. Hands-on and strong knowledge in Oracle Reports/SQL/PLSQL /OAF/XML Publisher/SCM/OM and Interface/Conversion experience. Intermediate levels expertize in Oracle BI EE analytical & BI publisher report development and novice in SOA application integration.
• Experience in analysis, design, development and testing of OLTP business applications - web based & Client/Server environment. Extensive experience in Schema Structure design, performance tuning & optimization, debugging, testing and business support. Involved in review and gap analyses, process improvement & requirement gathering and technical design. Good analytical and problem solving skills, document writing skills, interpersonal and leadership skills.
• Technical Lead in two R12 upgrade projects from 11.5.X version having primary business modules O2C, P2P and SCM.
• Design & develop custom solution that closely integrate and/or enhance Oracle EBS functionality.
• Handled Production Support issues and technical design in times of creating Data Conversion script, Developing Interface programs, Custom forms, Custom reports, XML Reports, Form Personalization, OAF Personalization and OAF Page development and Functionality customization.
• Assist in creating, enhancing support process and monitoring document and standardize custom development; production move process.
• Watching out Continuous Process Improvements. Work with the process manager to improvise process and eliminate GAP’s.
• Worked on 11i / R12: Financial Modules (Accounts Receivable AR, Accounts Payable-AP, General Ledger-GL) & Distribution Modules (Purchase Order-PO (PROCUREMENT), Inventory-INV, Order Management - OM, Manufacturing and Scheduling- M&S.
• Proficient in Application Object Library (AOL) and System Administrator..
• Good knowledge of the TCA (Trading Community Architecture) model architecture in 11i & R12.
• Excellent experience using PL/SQL (Packages, Procedures, Functions, Triggers, Complex Data Conversion Scripts) and Oracle Reports and Oracle Forms.
• Good Experience working with 3rd party tools such as PL/SQL Developer, TOAD, and SQL Developer etc.
• Develop; debug triggers, procedures, packages, functions and views.
• Query optimization, performance tuning.
• Good Experience with technical documentation and User Manuals.
• Provided Hands-On User .
• Competent in precise translation of requirements into deliverable solution, ability to communicate and interact while being an excellent team player.

TECHNICAL SKILLS:

Technology and Tools: Oracle Application Suite (R12, 11i) Oracle Manufacturing & SCM: Order Management (OM), Inventory (INV), Bill of Materials (BOM), Purchasing (PO), Manufacturing and Scheduling (M&S), ASCP Oracle Financials: Accounts Receivables (AR), Accounts Payables (AP), Payments (IBY) General Ledger (GL) Oracle CRM: Service Contract, Install Base, TCA. Application Object Library, System administrator and AIM. Development Tools/ Utilities Developer6i Forms and Reports Oracle Developer Suite 10G Forms and Reports XML Publisher and Jdeveloper (OAF) OBIEE Analytical and BI publisher reporting RDBMS Oracle 11g / 10g/9i LANGUAGES: SQL/PLSQL, Java

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Applications and integration Analyst

Responsibilities:

• Work with clients to understand problem areas and scope for improvisation.
• Write, analyze, review, and rewrite programs, using Oracle technology.
• Engage with team of s/w Eng. programmers for development and analysis of complex software programs.
• Analyze user requirements, procedures & problems to provide solution to automate or improve existing systems.
• Analyze, understand and trouble shoot software issues.
• Testing and Deployment of Oracle modules.
• Requirements analysis and Techno- Functional design of software applications.
• Documentation of technical and functional specifications and design.

Confidential

Oracle Applications Consultant - EBS Application and integration lead & onsite coordinator

Responsibilities:

• Analyze, understand and trouble shoot software issues.
• Customize Extend and Enhance Oracle Applications systems.
• Testing and Deployment of Oracle modules.
• Requirements analysis and Techno- Functional design of software applications.
• Documentation of technical and functional specifications and design.
• Write, analyze, review, and rewrite programs, using Oracle technology.
• Engage with team of s/w Eng. programmers for development and analysis of complex software programs.
• Analyze user requirements, procedures & problems to provide solution to automate or improve existing systems.
• Work as part of a project team to coordinate database development and determine project scope and limitations.
• Analyze, Gather requirements, determine project scope and limitations, work and coordinate with offshore for development.
• Production issue support and incident resolution and service.
• Alarm potential issue / Incident identified and suggest work around (if any) while working to troubleshoot for permanent fix.
• Status reporting, monitoring and controlling incident management.
• Conversion, data migration, integration and upgrade within oracle applications.
• Assist in planning production move change request and maintenance.Gentran EDI system to EDI service provider SPS
• Migration support of EDI customer mapping - 850, 856 and 810.
• Upgrade outbound and Inbound FTP / SFTP transmission mechanism.
• Build EDI-EBS reconciliation System
• Build / rewrite Positive Pay transmission
• Upgrade Check printing system.
• Oracle I/PM (imaging and process management) project implementation support with external vendor.
• New XML Documents, integration Interface development
• AR Invoice Doc with Barcode Development, PO Document Enhancement
• Design, Develop integration interface to identify AR, PO, BOL & MBOL documents in EBS transfer in BATCH / ONLINE mode via FTP to IPM inbound process folder
• 170 system Data, TIFF conversion (2008 to JAN cutover) - Build extract Script and TIFF images into potable format importable by IPM.
• Shipping Label Printing - Printer pooling upgrade to support multiple location label printing.
• Migration of EDI 852 customer mapping to SPS EDI provider SPS from in-house Gentran EDI system.
• Branding of Shipping Documents for Dynamic Ship To Compliance
• Confidential 170Systems Image Archive Application - Design and development using OAF for retrieval archived .
• Dick's Cross Dock implementation for Consolidated PO by DC - Solution developed.
• Numerous Discoverer reports enhancement, development and fix performance issues
• Implementation of production scheduling with ASCP ( Advance Supply Chain Planning)Unused locator cleanup with optimized system utilization, Zero business impact.
• Purge data in identified BA as per recommendation provided by Oracle extended support engineer.
• Move Order barcode report and Request sub & printing automation
• Huge discoverer objects clean. Gained performance / Space, paved easy GoldenGate synchronization.
• Imaging Reconciliation report. IGA-TO-IPM. Invoice and Customer PO’s.
• Single and Bulk pick slip barcode report development
• Production scheduling migration support
• WMS Locator and picking optimization migration support
• Implementation of B2B2C business model using SOA and Oracle E-commerce gateway.
• End customer(EC) place order on EBAGS side with his shipping address.
• Confidential receives EC order from EBAGS via SPS EDI 850.
• EC order imported in Oracle Order Management, Booked, 940-WSO to 3PL provider (Saddle Creek Logistics) and place on 3PL Hold for Order.
• SL ships order to EC address and send 945-WSA.
• Upon 945 receipts, do 3PL unhold & ship confirm against 3PL sub inv.
• Transmit 856 ASN and 810 to EBAGS.
• Min / Max planning to generate replenish stock at 3PL location.
• Item UOM Conversation MP to EA for replenishment move order.
• Generate move order BOL to ship EA to SL’s location.
• Upgrade to Distributed ASCP to R12.
• Customized Planning Detail Report (PDR).
• Oracle EBS upgrade to R12.1.3
• Retrofit and port customization to R12.
• Upgrade/Test integration system - ASCP, OTM 6.3, Oracle I/PM, EDI, GETAPID and Bank transmissions.
• R12 Check Printing using XML publisher.
• Oracle EBS upgrade to R12.1.3
• Retrofit and port customization to R12.
• Upgrade/Test integration system - ASCP, OTM 6.3, Oracle I/PM, EDI, GETAPID and Bank transmissions.
• R12 Check Printing using XML publisher.
• Oracle BI EE (OBIEE)implementation
• Migration of discoverer report to OBIEE
• Build analysis and BI publisher reports from OBIEE.
• Dicks Sporting Goods customer PO consolidation for Order processing and shipment project - Direct to Store, Direct to Distribution Center, Marked to Store.
• Mass Update for Bill To Location field
• Positive pay file for new bank implementation PNC.
• Pending putaway reconciliation report - WIP, PO, Inter Org, RMA and Drop ship orders
• Confidential Distribution workbench - Custom for to enhance picking and shipping process.

Confidential

Oracle Applications Consultant

Responsibilities:

• Understanding the existing form based functionality
• Technical Assessment and solutions design.
• Development of the business components using OA framework technology.
• Prepared technical design document.
• Developed scripts to create and modify the custom database objects, without effecting existing form based functionality.
• Extracted the ldt script that helps in easy migration of application objects between the instances.
• Developed configuration document and installation scripts.

Confidential

Oracle Applications Consultant

Responsibilities:

• Migration of Custom form and Custom Reports from 11.5.9 to R12.
• Identify the obsolete objects in custom reports / program and modify according with new tables structure / Objects and MOAC architecture.
• Understanding the functional requirements and provide the solutions.
• Used Form Personalization feature for customization of forms.
• Understanding the requirement of Job Scheduling workbench and developed custom concurrent program for linking the discrete job and sales order.
• Workaround solutions for oracle seeded reports - India Cash / Bank Book, Open Account AP Balance Listing Report.
• Data Fix solution for AP Invoices WF Approval process.
• Developed Custom Reports - Final Payment Register and Send Separate Remittance Advices.
• Migrated Items to new inventory organization using Item Open Interface.
• Developed API to apply India Localization - Item Classification for item in the new inventory organization.
• Developed API for India Localization - Create Taxes, Tax Category and Item Category (Localization).
• Prepared configuration document and customization documents. the client technical team in understanding the form personalization.
• Developed a custom solution for planning in Manufacturing and Scheduling.
• Post go-live support.

Confidential

Oracle Applications Consultant

Responsibilities:

• Understanding the As Is functionality of legacy application.
• Understanding the business process and developed the use cases.
• Developed the test cases based on the use cases.
• Understanding the data to passed between legacy application and iStore application.
• Customization of standard istore pages
• Participated in gap analysis and application deep dive sessions with business and technical teams.
• Reviewed the BRD/FRD.
• Proposed changes to the requirements as per the existing architecture.
• Prepared and reviewed the test cases document for completeness.
• Interacted across the teams to analyze and mitigate upstream/downstream impacts.

Confidential

Oracle Applications Consultant

Responsibilities:

• Identifying and Creating Business Components.
• Designing and Developing SSWA UI pages.
• Coding Business logic and validation rules.
• Identified and created LOV / dependent LOV windows
• Developing PL/SQL API for validating data.
• Deploying the Business Components in oracle Application.
• Defining Form Functions, Concurrent Programs.
• Defining Responsibilities and assigning to user.

Confidential

Oracle Applications Consultant

Responsibilities:

• Involved in understanding the issues.
• Resolved issue of adding a new record to a table region and saving.
• Implemented the Update and Hyper link functionality in search region.
• Implemented the dependent LOV functionality to validate the data.
• Resolved an updating issue in a form.
• Resolved the issues in XML report.

Confidential

Oracle Applications Consultant

Responsibilities:

• Involved in creation of Custom Schema
• Involved in creation of Custom application top.
• Registration of Custom Application with oracle applications.
• Schema Structure Design - Identifying and creation of the tables/views.
• Develop procedures and packages to validate data and achieve the functionality.
• Developed custom reports and forms.
• Registered concurrent program, forms and reports with oracle applications AOL.
• Defined new Responsibilities.
• Worked with the test engineer to explain the functionality of the tool and helped them in preparation of test cases.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Worked on developing an interface to be used for importing invoices using Auto invoice.
• Using Sql Loader data was loaded from the flat file to the staging table and after due validations the data was moved to the interface tables.
• Worked on developing an interface to be used for importing open invoices using Payables Open Interface Program
• Wrote SQL*Loader script to migrate the data from text file to interface tables and after due validations the data was moved to interface tables.
• Worked on the supplier import open interface for loading supplier information into Payables.
• Involved in creating Technical Documents (MD70) using AIM methodologies.
• Defined Concurrent Programs, Executables.
• Developed Custom Reports.