SUMMARY:

• Oracle application Technical Lead with 10 plus years of experience in Information Technology Industry.
• Global experience: worked in APAC, US, UAE region.
• Worked as Technical Lead in multiple projects at Onsite and Offshore for many clients working with Fujitsu.
• Worked on Multiple Modules (Account Receivables AR, Account Payables AP, Purchasing PO, Inventory INV, General Ledger GL, Sub Ledger Accounting XLA, Order Management OM) in the entire tenure with Fujitsu.
• Worked on multiple end to end Integration projects.
• Worked on Multiple Support Projects.
• Worked on R12 upgrade Projects (11i to R12(12.1.3))
• Worked on R12 upgrade Rollup Patching project (R12 12.1.1 to R12 12.1.3).
• Worked on Agile and Waterfall methodologies in different projects.
• Adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion.
• Involved with study of existing system, 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.
• Conducted designing test automation strategies, Functional Acceptance testing (FAT), created test scenarios, test plans and performed inspection of test scripts.
• 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.
• Sound knowledge in SQL Loader, writing database trigger, stored packages, cursors, PL/SQL tables, sequences, procedures, function, and error handling
• Good technical development skills in developing Interfaces, data conversions, BI Publisher Reports, Forms, Workflows, Business Events in the domain of Oracle Applications E - Business, OAF Form Personalization’s. Oracle WEB ADI
• Superior communication, organizational, and interpersonal skills.
• Successful in recognizing problems, troubleshooting solutions and reaching project goals on time.

TECHNICAL SKILLS:

ERPs: Oracle Applications E-Business Suite of versions 11i/R12 (PO, INV, WMS, AP, AR, OPM, AOL, P2P, OM)

LANG/ TECH: SQL, PL/SQL, XML Publisher, WEB ADI, UNIX Shell Scripts

DATABASES: Oracle 11g/10g/9i

TOOLS: SQL*Plus, Discoverer Reports, SQL*Loader, XML Publisher, Report Builder 6i/10g, Form Builder 6i/10g, PL/SQL Developer, Toad, Oracle Reports, BI Publisher, Oracle frame work, OBIEE Reports, Oracle Forms, Oracle Workflows, Oracle Alerts

EXPERIENCE:

Confidential, Wisconsin

Responsibilities:

• Working with the support team for Schreiber for supporting Oracle Process Manufacturing Module.
• Worked on the Germany Integration Project.
• Created new reports as a part of Germany Integration.
• Created Barcode reports which helps user to scan the Batch for Germany integration.
• Created reports for different five different languages, depending on the p selected by the user.
• Did form personalization’s for 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 Schreiber by saving plenty of money.
• In Raw Material Control for McD project I have Customized Batch Reconciliation custom form for Raw Material Control for McD project.
• In Raw Material Control for McD project Created New Form Personalization’s on Oracle standard Batch form for achieving the requirements.
• Simultaneously I was involved, working with the support team.
• Working in support team I was involved working on different incidents and Service request tickets.
• 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 which business.
• 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.
• Ran Patch Analyzer reports and did impact analysis for the patches and 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 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.
• Attending 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

Responsibilities:

• Involved in the end to end implementation project where we have implemented the GT Nexus system (SAAS) as part of the acquisition work to integrate Big Heart Pet Brands to the JMS systems.
• Involved in 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.
• Involved in UAT and created the UAT testing documents and followed up with business.
• Providing support to users during go-live by way of problem solving and instructions.
• 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.
• 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).
• Coordinating with Business and Banks for any file transaction related issues.
• Did the SFTP platform changes successfully as requested by PNC Bank at different applications.
• Coordinated with Bank for the SFTP platform change and coordinated with Business.
• Coordinating with Business for the requirement gathering for any issues and pass them to Offshore team as per the requirements.
• Actively involved in the financial period close and Year end closure activities.
• Following up 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.
• Supported Apex forms issues while working in AMS project.
• Coordinating weekly incident status meetings with business and offshore team.
• Involved in the prioritization meetings.
• Attended the Prioritization Meeting (CAB) every week.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.
• Use Oracle E-Business Suite applications for accounts payable/accounts receivable (AP/AR), general ledger, fixed assets, and cash management, supporting data extraction, filtering, and validation.
• Simultaneously Worked on Rollup patch upgrade project where we upgraded the version of Oracle from (12.1.1 to 12.1.3).
• In Rollup Patch upgradation project worked with Business and provided them the details regarding the changes after applying the patch.
• Involved in the UAT plan by coordinating with business after applying the patch for each application.
• Worked with Oracle for the issues we found in the standard functionality while UAT.
• Worked in Enhancement Work Team (EWT) project with JMS where we 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 Buisness Relationship management and coordinated with business and support team for any monthed year end or any production related issues.
• Coordinated the Year end process by scheduling all the year end meetings between business team.
• Created tickets, attended Prioratization meetings and followups on the tickets and coordinated with support and business team.
• Created New Financial Calender with new business activities which help business to identfy the process/activities they need to follow month.

Confidential, Ann Arbor, MI

Responsibilities:

• Tecumseh was an Upgrade project from US region.
• Track down all the list functionality and objects by going through Upgrade analysis document provided by Oracle and planned the testing scenarios accordingly.
• Worked with Oracle for the issues we found in the standard functionality while UAT.
• Worked on fixing the responsibility, menu and function issues in R12.
• Migration 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.
• Create and maintain 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

Responsibilities:

• Worked on the implementation project Phase-1A in a series of phases at Confidential .
• 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

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

Responsibilities:

• 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 we can add for these transactions and created a document for the same.
• Following are the transactions we 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.
• Worked on the out bound interface for ASN Changes on 3PL working with Confidential project.
• Prepared Technical document MD70, MD120.

Confidential, Upper Marlboro, MD

Responsibilities:

• Worked on EDI 889 Out Bound Interface Conversions
• Working as a Demantra offshore consultant.
• Provided Support to client on Demantra and ASCP.
• Performed the activity of NEW PRODUCT INTRDUCTION into Demantra from ASCP on the weekly basis.
• Performed member management for all the new items added every week.
• Done changes as per the requirements given by the client in Oracle Reports, PLSQL Packages, Oracle Forms.

Confidential

IT Consultant

Responsibilities:

• Worked on data Integration from Demantra to SNO (External tool).
• Created a query as per project requirement.

Confidential

Responsibilities:

• 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, 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.
• Oracle Application R12, Oracle 10g

Confidential

Responsibilities:

• 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.
• Offshore Co-ordination - Documentation, technical design, development and reporting.
• Scheduled weekly project review status meetings with offshore team and Client Manager.
• Involved with study of existing system, 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
• Done form customization, Form Personalization’s, Alerts
• Created Web services working in Confidential project.
• 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

Confidential

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

Responsibilities:

• Done 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

Confidential

Responsibilities:

• Developed reports including customization to standard Oracle reports using XML publisher
• Creating various SQL Queries and PLSQL packages as per the project requirements

Confidential

Responsibilities:

• Worked for various clients in the project TOYOTA BOSHOKU AMERICA
• Worked in EDI Team
• Implementation Modules OM,INV
• Providing support for various objects
• Developed reports including customization to standard Oracle reports using XML publisher
• Interfaces to import data from legacy to standard oracle tables
• Worked on Customer Cross conversion
• Created on Oracle Shipping Pack List Report
• Create LPN Report in XML PUBLISHER

Environment: Oracle Apps 10.2.0.3.0 , Forms 10g, Reports 10g, Reports XML, Oracle 9i

Confidential

Responsibilities:

• Worked for various clients in the project Confidential
• Worked in EDI Team
• Implementation Modules OM
• Providing support for various objects
• Did Forms customizations using Personalization’s
• Developed reports including customization to standard Oracle reports using XML publisher
• Interfaces to import data from legacy to standard oracle tables
• Quality management of all deliverables, testing of all objects for proper functionality and coding standards
• Requirement precise development of objects in efficient manner
• Worked on Oracle Shipping to FPS Interface
• Worked on Freight Pay System to Oracle Payables Invoice Interface
• Worked on Invoice Validation Program
• Designing of EDI process by identifying legacy fields vs Confidential field mappings
• Wrote Stored procedures and packages for data load
• Created packages for Order To Cash cycle for Confidential
• Worked on Oracle Forms and Oracle Reports working in Confidential
• Worked on Purchase Order, Inventory for other Project

Environment: Oracle Apps 11.5.10, Forms 10g, Reports 10g, Reports XML, Oracle 9i