SUMMARY

• Over 10 years of Experience in Oracle Applications EBS(11i/R12) E - Business Suite Modules this includes Oracle Financial Modules (GL,AP,AR), Manufacturing& Distribution Modules (PO,OM and INV), Service Contracts,InstallBase,Advance Pricing and Procurement Contracts and System Administration.
• Extensive experience in Order-to-Cash, HRMS and Procure-to-Pay Business flows of Oracle Applications 11i/12i.
• Extensive experience in Financials, SCM and CRM modules of Oracle Applications 11i/12i.
• Expertise in Reports, Interfaces, Conversions, and Extensions (RICE) and ability to work in most of the Oracle Application modules.
• Experience in Migration of data, Validation of data and Loading data using SQL*Loader from legacy system to Oracle Applications.
• Extensive Knowledge in Creating Procedures, Packages, Functions using SQL and PL/SQL.
• Strong programming experience in using Front-end tools like Report 6i/9i, Discoverer4i/10g, XML publisher, Forms 6i/9i, PL/SQL and TOAD and OAF personalizations
• Perspicacity in System Administrator activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, profile options as per the requirement
• Having good knowledge in Application Implementation Methodology (AIM).
• Familiarity in developing Project related design documents like MD70, MD50, CV60, MD120, and TE20.
• Strong Communication, Presentation and Analytical Skills. Proven Skills as an efficient Team Member in System Analysis, Designing, Development, Customization, Migration and Documentation.
• Experience in writing Unit test plans and Unit testing.
• Ability to create detailed technical design, code, test, debugs, document, and maintain applications required
• Worked directly with end users and other developers to define requirements, review design, develop and test assigned components
• Extensively worked on ETL extractions and SOAP service to call web services.
• A highly motivated, energetic individual and a Consummate Team Player with ability to lead a team by example and motivate them to achieve desired objectives

TECHNICAL SKILLS

Oracle Applications: Oracle Applications EBS(11i /R12).

Operating Systems: UNIX, Windows, Confidential Solaris.

Languages: SQL, PL/SQL, C, Shell Scripts and OAF

RDBMS: Oracle 8i/9i/10g.

Development Tools: Oracle Reports builder 6i/10g, Discoverer4i/10g, Form Builder, BI publisher.

Other Software: SQL*Loader, MSOffice, TOAD, Winscp, Putty, PPM, Perforce, SVN, SCM/CCM, OAF, Tracker, bit bucket, JIRA

PROFESSIONAL EXPERIENCE

Confidential

Oracle apps Developer

Responsibilities:

• Developed new report Integrated Payroll Benefit Issuance Detail Claiming Report using BI publisher
• Developed MED weekly Alert Report detail report by using BI Publisher.
• Extensively worked on project documents like CV60, Use cases, MD70 and TE20's.
• Solved day to day techno functional issues in AP, AR modules.
• Worked on employee conversions in HRMS
• Worked on Integrated payroll with HRMS adhoc reports using BI Publisher.
• Worked on employed contacts conversion in HRMS
• Resolving Functional hurdles for the smooth functioning of Technical Developers wise Setup and Test Scenarios through front end.

Environment: Oracle Applications EBS 11i/12i, AP, AR, GL,HRMS, TCA, Pl/SQL, SQL*Plus, SQL*Loader, SCM/CCMBI Publisher, spring tool suite, JIRA, BitBucket

Confidential

Oracle apps Techno-Functional Consultant

Responsibilities:

• Worked on various conversions activities as apart of implementation, conversions developed are Customer Conversion, Supplier conversion and Invoices conversion
• Designed COA structure as per SIGMA accounting pattern.
• Set up the COA structure and Periods as per the calendar.
• Developed Outbound Interfaces for GAX9 R and JV9 XML Payments.
• Prepared the Use cases-DSDD and provided to the state Users for CQ’s
• Extensively worked in designing project specific documents like CV60’s, MD70’s, MD120’s, TE20’s as Per the requirement using functional design documents (FDD).
• Supporting to ongoing Issues in Operations project.
• Resolving Functional hurdles for the smooth functioning of Technical Developers wise Setup and Test Scenarios through front end.
• Worked on Sigma Changes in all impacted interfaces.
• Worked in cloud Medicaid project which is integrated with oracle cloud service.
• Worked on Cash receipts processes and developed cash activity reports
• Involved in designing configuration documents, test scripts and also assisted users in User Acceptance Testing (UAT).
• Worked on warrant reconciliation process and developed the report by using XML Publisher
• Solved day-to-day techno functional issues.
• Generated the Payment cycle reports for each provider by using XML Publisher
• Worked on OAF personalization’s on supplier page and Customer page

Environment: Oracle Applications EBS 11i/12i, AP, AR, GL, TCA, Pl/SQL, SQL*Plus, SQL*Loader, Jira, Stash, OAF, Oracle applications Cloud Integration

Confidential

Oracle apps Technical Consultant

Responsibilities:

• Involved in the development, updating and monitoring of business and action plans in Order to cash modules like OM, AR and Service contracts.
• Resolving Functional hurdles for the smooth functioning of Technical Developers wise Setup and Test Scenarios through front end.
• Developed new packages for service contract claim item entitlement checks.
• Developed new packages for equipment in force check.
• Experience delivering in an Agile environment, including discrete functional packages for incremental builds for custom packages and procedures
• Extensively worked in designing project specific documents like CV60’s, MD70’s, MD120’s, TE20’s as Per the requirement using functional design documents (FDD).
• Experience delivering in an agile environment, including discrete functional packages for incremental builds

Environment: Oracle Applications EBS 11i/12i, OM, Service Contracts, AR, AP, Install Base, Pl/SQL, SQL*Plus, SQL*Loader, Jira, Stash, BI Publisher

Confidential

Oracle apps Technical Consultant

Responsibilities:

• Involved in the development, updating and monitoring of business and action plans in procure to pay modules
• Resolving Functional hurdles for the smooth functioning of Technical Developers wise Setup and Test Scenarios through front end.
• Developed the POC’s on procurement contracts which are feasible for functional requirements.
• Developed new Packages for Contracts conversion from CMS to Oracle.
• Developed new Xml Report for Procurement Contract Risk Report and emailed with bursting concept to the user.
• Developed new Xml Report for Financial Commitment Report and emailed with bursting concept to the user.
• Developed new Xml Report for Expiring Contracts Report.
• Worked on adding custom fields in Procurement contract page by using OAF.
• Developed new Xml Report for Estimated Contract Value Against Actuals Report
• Developed Outbound interface for Oracle Project Commitments Outbound to Lucernex
• Developed Outbound interface for Oracle PA Actual Cost to Lucernex
• Played a critical role in developing the test scenarios for various Scenarios, functional testing, defects finding and testing/following up till resolution
• Worked on employee conversions in HRMS
• Extensively worked in designing project specific documents like CV60’s, MD70’s, MD120’s, TE20’s as Per the requirement using functional design documents (FDD).

Environment: Oracle Applications EBS 11i/12i, Procurement Contracts, HRMS,PA, AP, BI Publisher, Pl/SQL, SQL*Plus, SQL*Loader, Reports 10g, UNIX, PPM, SVN

Confidential

Oracle apps Technical Consultant

Responsibilities:

• Understanding existing and new business system and developed the below components
• Involved in the development, updating and monitoring of business and action plans in Order-to-Cash modules
• Resolving Functional hurdles for the smooth functioning of Technical Developers wise Setup and Test Scenarios through front end.
• Involved in migration of upgrade objects to R12 Instance.
• Prepared Testing TE020 documents and migration scripts.
• Unit testing and system integration testing of the developed code.
• Developed new Packages for Start and Stop Time from Oracle to RDS.
• Developed new Packages for Customer Orders by Item by Day from Oracle to Food link system
• Developed new Packages for Inventory Adjustments from Outside Storage Facility from EDI to Oracle
• Developed the new form for pricing matrix Form.
• Developed new Packages for Expected PO’s to Outside Storage Selection Facility.
• Played a critical role in developing the test scenarios for various Scenarios, functional testing, defects finding and testing/following up till resolution
• Extensively worked in designing project specific documents like CV60’s, MD70’s, MD120’s, TE20’s as per the requirement using functional design documents (FDD).

Environment: Oracle Applications EBS 11i/12i, Modules (AP, GL, INV, PO), Pl/SQL, SQL*Plus, SQL*Loader, Reports 10g, BI Publisher, UNIX, Forms Builder 10g.

Confidential

Oracle apps Technical Consultant

Responsibilities:

• Involved in end to end implementation of Confidential -Vertex project moving entire Tax system from Tax ware to Vertex system.
• Extensively worked in designing Technical design documents (TDD) like MD70 as per the requirement using Functional design documents (FDD).
• Successfully developed a custom interface programs to load the data from a spread sheet into custom table which is based on a front end form which includes inserting, updating and deleting the valid data on the table making the job easy for users.
• Developed new Packages for Confidential vertex tax audit analysis.
• Modify the code for the existing Tax effective components in procure to pay modules.
• Developed the new Financials Confidential Vertex tax state detail report by using Discoverer 10g
• Developed the Financials new Confidential Vertex tax Transaction Report by using Discoverer 10g
• Developed the Financials new Confidential Vertex Tax Legal Entity Summary Report by using Discoverer10g
• Developed the Financials new Confidential Vertex Division Detail Report
• Developed the SFTP shell scripts. Played Key role for Impact analysis of shell scripts for Re platform of application server
• Worked on developing several reports using Discoverer 10g and also trained the team to work on Discoverer reports
• Worked on uploading and downloading LDT’s for concurrent programs, value sets, and templates using fnd load command to migrate the data from once instance to other instance.
• Fully involved in assisting and coordinating with the offshore team members on the components developed by them.

Environment: Oracle Applications EBS11i/R12 General Ledger (GL), Account Receivables (AR), Account Payables (AP), Pl/SQL, SQL*Plus, SQL*Loader, Reports 10g, XML Publisher, UNIX, Windows XP.

Confidential

Oracle apps Technical Consultant

Responsibilities:

• Developed New Xml Report for Delivery Note Report By using Report6i and BI Publisher in order management, shipping
• Developed New Xml Report for Shortage and Damage Report By using Report6i and BI Publisher
• Developed New Xml Report for Request For Quotation Report By using Report6i and BI Publisher
• Developed New Xml Report for Purchase Order Report By using Report6i and BI Publisher
• Developed New Xml Report for Total Sales Report By using Report6i and BI Publisher.
• Developed New Xml Report for Issued and Non Issued Order Report by using Report6i and BI Publisher.
• Completely involved in end to end implementation of Xml publisher for building More than 20 reports which Includes requirement gathering, developing and assisting users in testing the reports.
• Worked on uploading and downloading LDT’s for concurrent programs, value sets, and templates using fnd load command to migrate the data from once instance to other instance.
• Extensively worked in designing Functional design documents (FDD) and Technical design documents (TDD) like MD50 and MD70 as per the requirement using BR100 documents.
• Trained end users on the new developments and assisted them to perform User Acceptance Testing by describing step-by-step process to be followed to run oracle applications.

Environment: Oracle Applications EBS R12, Order Management (OM), Purchasing (PO), Inventory (INV), Pl/SQL, SQL*Plus, SQL*Loader, Reports 10g, XML Publisher, UNIX, Windows XP.

Confidential

Oracle apps Techno Functional Consultant

Responsibilities:

• Developed packages for Search IB Instance and Save Adjustments.
• Developed Packages for creation of Orders, Order Contracts, Order Contract Roles
• Developed Procedures for creation of Splitting and Termination of Ib’s
• Developed Procedures for Assigning Contract Groups to Contracts
• Developed Procedure for adding existing contract details to the service line based on contract number
• Developed the Eclipse Usage report by Using Oracle Discoverer 10g
• Developed the new report for contract renewal by Using Oracle Discoverer 10g
• Developed the new report the contract which were in the DPL hold by using discoverer 10g
• Responsible to migrate developed components from test instance to Production Instance
• Developed the new reports for Internal Fulfilment Report and by Internal Non-Fulfilment Report Using Oracle Discoverer 10g
• Developed the new report for Rule Engine Report by Using Oracle Discoverer 10g
• Extensively worked in designing Business requirement documents (BR100), Functional design documents (FDD) and Technical design documents (TDD) like MD50 and MD70 as per the requirement using BR100 documents.
• Involved in designing configuration documents, test scripts and also assisted users in User Acceptance Testing (UAT).

Environment: Oracle Applications EBS11i, Service Contracts (OKC), Install base (IB), Order Management (OM), Advance Pricing (QP), Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, Discoverer 10g, UNIX, Windows 7.

Confidential

Oracle apps Techno Functional Consultant

Responsibilities:

• Involved in the areas of testing and supporting the functional setups in Service Contracts, IB and as well as BOM and Inventory applications
• Monitoring and Rectifying the errors of Various inbound and out bound interfaces and resolving them to as easy to end user
• Solved day-to-day techno functional issues
• Support the client in troubleshooting functional issues on an ongoing basis
• Participating in Crisis Calls and Tech calls to resolve the issues on a priority basis
• Checking & validating the QA check package for contracts activation
• Working on pricing of items by using dynamic formulas as per the scenarios in Advanced Pricing.
• Fixing issues in Service Contracts related to Pricing, Service Availability & QA check
• Creating Child tickets and interacting with DBAs and end-users
• Participating in Knowledge Transfer Sessions
• Creating Bugster Entries and Raising GCN Entries
• Creating PRDB (Problem Resolution Database) Entries (i.e., Knowledge Management)
• Extensively involved in designing and developing (MD70) and (MD50) documents which is also used to train the end users regarding the business process.
• Involved in creating some front end forms as per the requirement.
• Trained Users on the new developments and assisted them to perform User Acceptance Testing by describing step-by-step process to be followed to run oracle applications.

Environment: Oracle Applications EBS 11i, Service Contracts (OKC), Install base (IB), Order Management (OM), Advance Pricing(QP), Inventory (INV),Service Requests, Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, Discoverer 10g, UNIX, Confidential Solaris OS,PRDB,GCN

Confidential

Oracle apps Technical Consultant

Responsibilities:

• Developed AP invoices conversion program, GL Import Interface and Closed/cancelled PO outbound interfaces
• Rejected/Return Quantity Vendor Report - This Report shows all the orders for which the received items are rejected by the Quality/Inspection team and show the Rejected/Returned Items with the days between to the Vendor.
• AP Cleared invoice report - This Report will show all the Payables cleared Invoices to be sorted by Invoice groups.
• Custom report to list PO-s waiting for Approval (related to PO Approvals) - This report lists all the purchase orders that are waiting for approval for given number of days.
• Purchasing Matching report - This report is developed to generate a report of all the purchase orders which are matching the match approvals like 2-way, 3- way, and 4-way.

Environment: Oracle Applications EBS 11i, Account Payables (AP), Inventory (INV), Purchasing (PO), Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, UNIX, Windows XP.