SUMMARY:

• Over 11 years of experience as a Techno/Functional Oracle EBS Consultant.
• Expert in Oracle Applications R11i /R12 using Oracle SQL/PLSQL, Oracle Developer Suite (Forms and Reports), Oracle XML/BI Publisher and Oracle Workflow, WEB ADI, Discoverer Reports, OBIEE Reports.
• Experienced in working with the Business to gather requirements.
• Multiple full Life Cycle implementations, rollouts and upgrade projects from 11i to R12.
• Experienced in: Procure to Pay, Order to Cash, operations and Operations and Record to Report - GL, AP, AR, CM, iExpense, SLA, PO, OM, INV, SLA, OPM etc.
• Proficient in RICEWF - Reports, Interfaces, Conversions, Forms, Workflow development and customizations. Expertise in Report Development and customization, XML/BI Publisher, Discoverer, OBIEE Reports.
• Gathered detailed requirements, designed, developed complex interfaces.
• Developed conversion programs (with external packages) to import data from various legacy systems into Oracle Applications using PL/SQL, SQL*Loader
• Experience in UNIX and shell scripting. Proficient in Oracle Fusion Forms 10 g, Workflow.
• Experience in preparing AIM documents like MD050, MD070, CV040, CV060 etc.

TECHNICAL SKILLS:

Technology Experience: Oracle RDF, BI Publisher, XML Publisher Reports, OBIEE Reports, Conversions, Extensions, Interfaces, Forms, Workflows, Shell Scripting and UNIX functions, WEB ADI, OAF.

Functional Experience: Procure to Pay, Order to Cash, operations and Operations and Record to Report - GL, AP, AR, CM, iExpense, SLA, PO, OM, INV, SLA, OPM etc.

Databases: Oracle 11g, Oracle10G & Oracle 9i, SQL Server

Tools: Oracle Reports Developer, Oracle Forms Developer, Oracle Workflow Builder, SQL Developer, TOAD, PLSQL Developer, SQL Loader, Kintana, HP Quality Centre

PROFESSIONAL EXPERIENCE:

Confidential, Wisconsin

Lead Oracle Applications Techno Functional Consultant

Responsibilities:

• As a technical consultant have supported the OPM module for Schreiber foods.
• Worked on the Germany Integration Project.
• Created new OBIEE reports as a part of Germany Integration.
• Created Barcode reports which helps user to scan the Batch for Germany integration.
• Created reports for five different languages, depending on the p selected by the user.
• Worked on Oracle form personalization and Oracle form customizations as per the requirement for Germany integration.
• Worked on Raw Material Control for McD project.
• Raw Material Control for McD project was crucial project which helped Confidential by saving plenty of money.
• Worked on Oracle form customization of Batch Reconciliation custom form for Raw Material Control for McD project.
• In Raw Material Control for McD project have created New Form Personalization’s on Oracle standard Batch form for achieving the requirements.
• Wrote technical design documents for conversions, extensions, interfaces, and reports.
• Created Oracle service requests (SRs) for troubleshooting and fixing the bugs.
• Created and modified multiple custom OBIEE Reports as per the requirement by the business.
• Done OAF personalization’s as per the requirement by the business in the service request.
• Created new and modified existing Oracle WEB ADI for different requirements by the business.
• Created Business Events for custom process in Oracle as per the given requirements.
• Fixed the bugs in the Custom Traceability system.
• Worked with Oracle Support team for the Oracle standard issues.
• Tuned Oracle SQL queries which was causing the slowness of the reports and custom processes.
• Worked with DBA team for applying any patch requested by Oracle as fix in Dev, UAT and then Production instance.
• Did Patch impact analysis for the patches for the fix provided by the Oracle for the standard issues.
• Worked with business and created a plan for doing testing before applying the patch with business persons.
• Modified multiple reports as requested by business as a part of support activity.
• Done object migration of objects reports using SVN and Flex deploy.
• Created Oracle Business event for calling custom event while assigning the item to an organization.
• Created Oracle Trigger on Standard Oracle table for one of the requirement.
• Worked on Incidents and Service requests assigned to me as a part of support activity.
• Attended weekly status meeting for Support activities and projects.
• Created Technical documents like MD70 and MD120 for projects.
• Appreciated by business timely basis for getting things done on time and helping business to grow.

Confidential, Orrville, OH

Lead Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked on the end to end implementation project where have implemented the GT Nexus system (SAAS) as part of the acquisition work to integrate Big Heart Pet Brands to the JMS systems.
• Worked on RICE data conversion, developing, customizing report and interfaces.
• Created Technical Documents and Migration Documents working in the integration project with JMS.
• Participated in meetings with business heads to gather the required process flow and developing functional specification.
• Worked on UAT and created the UAT testing documents and followed up with business.
• Provided support to users during go-live by way of problem solving and instructions.
• Created Documentation for User’s related to Big Heart Integration issues.
• Created test scripts for UAT (User Acceptance Testing) in Unit testing documentation with detailed testing of all the modules Involved in development of RICE components as per business requirement.
• Wrote technical design documents for conversions, extensions, interfaces, and reports.
• Created Oracle service requests (SRs) to fix the issues.
• Worked as an Onsite Track lead in the support team for JMS for supporting Oracle Financial applications (Accounts payable/accounts receivable (AP/AR), General Ledger, Fixed Assets, and Cash Management).
• Coordinated with Business and Banks for any file transaction related issues.
• Did the SFTP platform changes successfully as requested by the PNC Bank at different applications.
• Coordinated with Bank for the SFTP platform change and coordinated with Business.
• Involved in Customer Conversions to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs
• Developed AUTOLOCKBOX Interface to load data that is received from bank into interface tables (AR PAYMENTS INTERFACE ALL), from interface table to the Base Interim tables and finally to the base table.
• Actively worked on the financial period close and Year end closure activities and issues.
• Worked with business, offshore team and Infra team for any system or application maintenance plans.
• Worked on Kintana (Tortoise SVN) to migrate any changes to prod.
• Coordinating weekly incident status meetings with business and offshore team.
• Attended the prioritization meetings.
• Attended the (CAB) meetings every week.
• Worked on Version Control software to check-in codes and integrated with Kintana for file migration.
• Used FND-LOAD to migrate Concurrent programs, Request sets, forms menus and Personalization, by downloading the LDT files
• Simultaneously Worked on Rollup patch upgrade project where upgraded the version of Oracle from (12.1.1 to 12.1.3).
• Did Patch Analysis and worked with Business and provided them the details regarding the changes taing place after applying the patch.
• Worked on the UAT plan by coordinating with business after applying the patch for each application.
• Worked on modification of the check layout as per the new Printer setup for printing the checks as per the given MICR design for the checks by different banks.
• Developed AP Positive pay Extract Report in Oracle Payables which will extract the Canadian transactions from source systems and sent to bank.
• Worked on journal import interface program to import journal data from legacy system into GL Base tables.
• Coordinated with Bank and Business to complete testing of the check.
• Worked with Oracle for the issues found in the standard functionality while UAT.
• Worked in Enhancement Work Team (EWT) project with JMS where worked on various enhancement requests in different applications.
• Created STW Co pack Attainment report which help business to see all the history of the different Purchase Orders (STW Orders, PO release, Factory Direct and Make and Move Orders).
• Worked on the existing Ware House reports.
• Simultaneously worked as a BRM Business Relationship management and coordinated with business and support team for any month end, yearend or any production related issues.
• Coordinated the Year end process by scheduling all the yearend meetings between business team.
• Created tickets, attended Prioritization meetings and follow-ups on the tickets and coordinated with support and business team.
• Created New Financial Calendar with new business activities which help business to identify the process/activities they need to follow month.
• Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.

Confidential, Ann Arbor, MI

Senior Oracle Applications Techno Functional Consultant

Responsibilities:

• Confidential was an Upgrade project (11i to R12 12.1.2) from US region.
• Worked on Tracking down all the list functionality and objects by going through Upgrade using analysis document provided by Oracle and planned the testing scenarios accordingly.
• Worked with Oracle for the issues found in the standard functionality while UAT.
• Worked on fixing the responsibility, menu and function issues in R12.
• Migrated of the fixed objects from R12 one instance to other instances using FNDLOAD commands.
• Created migration Document MD120 for migration of any technical objects after retrofitting them.
• Worked with business support technical team to provide them the technical information about with new functionality in R12.
• Created and maintained documentation related to delivering support to existing usage of applications or to proposing new alternatives or process changes.
• Modified EFT Outbound interface program for payment process request.
• Retrofitted reports, PLSQL packages as a part of upgrade.
• Actively involved in discussions with the onsite team.

Confidential, Cleveland, OH

Senior Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked on the implementation project Phase-1A in a series of phases at Koyo.
• Worked on modifications of multiple reports like PO Print, Bill of Lading, Pack Slip and Sales Order Acknowledgement for Spanish Language.
• Worked on the reports for (Banamax to Banamax and Banamax to Other Banks) from scratch, which was a show stopper object in the project.
• Lead offshore technical team working in Confidential project.
• Involved in the requirement gathering meetings with direct client and creating Technical MD70 and Migration MD120 documents as per the requirements.
• Worked on conversion for Attaching Bank to supplier level.
• Worked on conversion for Work Order Less Completion.

Confidential, Houston, TX

Senior Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked on the R12 upgrade Projects (11i to R12 (12.1.3)).
• Worked on retrofitting the 11i objects across different oracle modules to make them compatible with R12 features and functionality.
• Worked closely with Business and Technical team to retrofit objects while upgrade.
• Led cross functional discussion with business users to address critical upgrade issues.
• Worked with Procure to Pay teams to test cross module customizations/interfaces.
• Worked with business users to test customizations during test cycles including UAT and SIT. Drafted Integration Test scripts and Unit Test scripts in across applications.
• Facilitated issue resolution meeting with the users to successfully resolve and close issues.
• Worked with business support technical team to provide them the technical information about with new functionality in R12.
• Created migration Document MD120 for migration of any technical objects after retrofitting them.
• Worked on migration of customizations including personalization, workflow, lookups, concurrent programs
• Worked on the customization of Reports in R12 to match the 11i report.
• Worked on the customization of UNIX based programs like lock box to match the 11i.
• Worked on the Migration of objects using driver files as per the standard process used in Kirby.
• Participated in detailed discussions with the onsite team to understand the functional requirements.
• Production Support post Go-live on closing issues.

Confidential, Lincolnshire, IL

Senior Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked on Confidential APAC Integration of 3PLwith Oracle.
• Developed custom process for SRA (Stock Receipt Advice), which replaced Oracle Forms and make an alternate way out of doing different transactions in bulk. Program also has custom exception program for custom and seeded error tracking.
• Created test scripts for UAT (User Acceptance Testing) in Unit testing documentation with detailed testing of all the modules Involved in development of RICE components as per business requirement.
• Developed test scenarios, scripts, and conducted functional tests for integrations.
• Followed up with Oracle for gathering all the possible validations can add for these transactions and created a document for the same.
• Following are the transactions use to do using a single SRA process:
• PO Receipt’s
• ASN Receipt’s
• IR Receipt’s
• RMA Receipt’s
• WIP PUTAWAY
• GQA Transfer
• SHORT PICK TRANSFER
• Return to Vendor
• Cycle count adjustment.
• Created out bound interface for ASN Changes on 3PL working with Confidential project.
• Prepared Technical document MD70, MD120.

Confidential, Upper Marlboro, MD

Senior Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked on EDI 889 out Bound Interface Conversions
• Performed member management for all the new items added every week.
• Supported the day today technical issues in cross modules in Oracle apps.
• Done changes as per the requirements given by the client in Oracle Reports, PLSQL Packages, Oracle Forms.

Confidential, CA

Senior Oracle Applications Techno Functional Consultant

Responsibilities:

• Working as an IT Consultant in Confidential project.
• Worked on data Integration from Demantra to SNO (External tool).
• Created a query as per project requirement.

Confidential

Senior Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked on the project EAI at onsite UAE
• Emirates Advanced Investments (EAI) is a business development and investment company based in Abu Dhabi, UAE. The strategy of EAI is to explore and develop new investment dimensions in the local economy. EAI was established on 2006. Since then, EAI has unleashed several investment initiatives that have been transformed into successful profitable operations.
• Created test scripts for UAT (User Acceptance Testing) in Unit testing documentation with detailed testing of all the modules Involved in development of RICE components as per business requirement.
• Analyzed the impact and functionality of various custom applications interfacing with the ERP system.
• Conducted unit as well as integration testing.
• Prepared System Test Plan
• Extensively coordinated with the offshore support team for monitoring the issues.
• Worked on conversions of data.
• Develop Pages using OAF, Worked on EO Extension, VO Extension and CO Extension.
• Worked on various interfaces in Payroll, Purchasing area.
• Worked on various Alerts for sending notifications. (Passport Expiry, Gate Pass Expiry etc.)
• Developed various XML Publisher Reports pertaining to HR, Payroll module.
• Worked on Fast formulas pertaining to Payroll, Absence, and Compensation module.
• Worked on PA Billing Extension using Oracle hooks for EAI Project
• Worked on Payroll to PA Interface for EAI Project
• Developed AP Invoice Interface for EAI Project
• Worked on Purchase Order Conversion using Web ADI for EAI Project
• Created Delivery Note Report for EAI Project
• Responsible for testing of key business processes as per client requirement.
• Development Environment: Oracle Application R12, Oracle 10g

Confidential

Senior Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked on the project Confidential at onsite UAE
• Adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion
• Conducted designing test automation strategies, Functional Acceptance testing (FAT), created test scenarios, test plans and performed inspection of test scripts.
• Worked on Offshore Co-ordination - Documentation, technical design, development and reporting.
• Worked on Scheduling weekly project review status meetings with offshore team and Client Manager.
• Worked on preparing the Functional (MD50), Technical (MD70) design document and Conversion Data Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables and for implementation
• Worked on form customization, Form Personalization’s, Alerts
• Worked on modifications of CUSTOM FORMS
• Created Oracle Policy and Sub Inventory Securitization Form using which an individual user who will be authorized to carry out any kind of inward or outward transactions from and to that Sub inventory. The business requires control over the transactions between specific sub inventories
• Created ASN (Advance Shipment Form) Custom Form for Confidential Project
• Created Trip Update Custom Form for Confidential Project
• Created Material Picking Custom Form for Confidential Project
• Created EAM Equipment power unit Mapping Custom Report for Confidential Project
• Created Alert for Approved Purchase Order for Confidential Project
• Created Daily Work Request Custom Report for Confidential Project
• Created Work Order Detail Custom Report for Confidential Project
• Created Discoverer Reports for Purchasing.
• Done Form Personalization’s working with Confidential Project

Confidential, Upper Marlboro, MD

Senior Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked on the project DPI
• DPI is based on R12
• Worked on EDI out Bound Interface Conversions
• Worked on EDI 889 out Bound Interface Conversions
• Worked on EDI 810 out Bound Interface Conversions
• Worked on EDI 850 out Bound Interface Conversions
• Worked on NON-EDI out Bound Interface Conversions

Confidential

Senior Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked on the project Confidential
• Craeted form customization, Form Personalization’s, Alerts
• Worked on modifications of CUSTOM FORMS.
• Created test scripts for UAT (User Acceptance Testing) in Unit testing documentation with detailed testing of all the modules Involved in development of RICE components as per business requirement.
• Adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion
• Worked on POS (Point - Of - Sales) integration process
• Worked on GRN Costing form
• Created new Adjust Immediate Form in OPM
• Created new Material Transaction Form in OPM
• Created new Miscellaneous Issue Form in OPM
• Done OPM Inventory conversion for Torex Integration
• Done Inventory Item Update conversion for Torex Integration
• Done Organization Assignment to Inventory conversion for Torex Integration
• Done Inventory Posting Conversion for Torex Integration
• Done AR Transaction Conversion for Torex Integration
• Done AP Invoice Conversion for Torex Integration
• Done Sales Order Conversion for Torex Integration
• Done Item Price List Conversion for Torex Integration
• Done OPM Inventory Item Transfer Conversion for Torex Integration
• Worked on “ABE GENERAL LEDGER BASE CURRENCY COMPANY WISE” Report in GL