SUMMARY

• Over 13+ Years of Experience in Oracle EBS Implementation, Requirements gathering, Upgrade & Support projects.
• Have Experience as Onsite - Offshore Coordinator for Oracle R12/ADF Based Application and handled a Project Releases to UAT/PROD.
• Actively involved in requirement gathering sessions with legacy users to understand AS-IS processes. Designed and discussed on technical challenges proposing Oracle EBS solutions.
• Been enthusiastic and self-motivated team member with good communication skills both verbally and written. Have good people's skills in terms of Business users co-ordination in providing clarifications. Would be willing to work independently or as part of a team.
• Worked on Oracle EBS Full Cycle Implementations (AIM methodology) involving all Financial & SCM Modules . working experience in P2P and Order To Cash flows. Worked in Fixed Assets, Project Accounting (PA), AP, AR, GL, Purchasing, iProcurement, OM, Advanced Pricing, Shipping, Inventory. Involved in functional requirements definitions, functional test scripts, set up /configuration of the Financial/Inv modules.
• Experience in all phases of Software Development Life Cycle (SDLC) including Analysis, Specification, Development, Maintenance, Testing and Documentation and Production Support. Rich Experience with SR follow ups & resolutions.
• Knowledgeable with SLA, MOAC, AME etc. Good working experience with Trading Community Architecture (TCA).
• Strong hands on experience in RICEW development, Customizations in Oracle R12.1.3 /11i, Oracle 9i/ 11i Workflow 2.6, Discoverer (4.1, 10g) environments.
• Strong experience and understanding on modules such as Fixed Assets, Project Accounting, Project costing and Project billing and related flows. Had exposure to CRM related modules (Service Contracts, Install Base and Oracle Claims management).
• Worked on Interfaces & web services using BPEL, (SOA) architecture involving Oracle JDeveloper.
• Highly motivated team player with good communication and peoples skills both verbally and written.
• Proven ability to work creatively and analytically in a problem-solving environment. Willingness to take up challenging tasks, Adaptive to new Global environments.

TECHNICAL SKILLS

Operating Systems: Windows XP/NT/2000/98, Unix, Red Hat Linux

Languages: ADF BC4J,PL/SQL, HTML, JAVA2.0, JDBC2.0, C++ Unix Shell Scripting, WSDL,XML,XSLT

Data bases: Oracle 8.x/9.x /11g

Tools: & IDE’s: SQL*plus,Toad,SQL*Loader,Discoverer4i/10g,Reports/Forms(6i/10g),Workflow Builder2.6, Jdeveloper10g&11g, XML/BI Publisher,OBIEE 11g

Frameworks: OC4J,OAF, ADF

SOA Technologies: Web Services, BPEL, OSB, ESB, Oracle AIA Technologies

Application/Web Servers: Web logic, Oracle 9i AS

PROFESSIONAL EXPERIENCE

Confidential, Clearwater, FL

Oracle EBS Designer and Developer

Environment: OracleEBS/Applications-R12.1.3,Oracle, OM, Shipping, Inventory, Advanced Pricing, AR, TCA, XML Publisher, Oracle 11g, and PL/SQL,SQL Loader, JSONAs one of the largest suppliers in the promotional products industry, BIC Graphic offers the most comprehensive product assortment with the widest variety of decoration methods . BIC Graphic operates five manufacturing facilities across the United States with three facilities in Florida and two facilities in Minnesota

Responsibilities:

• Involved in Designing and Developing the Integration ( QP Price list, AR Invoice, EBS Customer Sales Rep ) between ODS and EBS . EBS data was extracted in JSON format and sent to ODS using specific URL's.
• Developed Full Load file type data type extractions for above for given period of transactional duration.
• Supported user testing and SIT for the above components and helped in installing to Production with necessary MD120's .
• Developed the Program which would derive Shipping Priority score for the Shipment deliveries based on business criterias.Made changes to Order Import /EDI programs for the Split line functionality.

Confidential, Denver Downtown,CO

Oracle EBS Designer and Developer

Environment: OracleEBS/Applications-R12.1.3,Oracle EPBCS, Purchasing, Inventory, GL, XML Publisher, Oracle 11g, and PL/SQL,SQL Loader, HR/Payroll. RTD has implemented R12 for maintenance of Procurement, Employees and automation of other budgeting &accounting operations . Oracle & Maintenance group requires ongoing Production support on premises for bug fixing. RTD is implementing Oracle Enterprise Public Sector Budgeting Cloud Services for GL .

Responsibilities:

• Involving requirements gathering .Involving Designing and developing complex GL integrations with EPBCS and data extractions programs .
• Involving in Production support and releases . Fixed reports in HR /Payroll, Inventory and supporting RICE Objects .
• Developed complex Pricing Category Assignment Conversion /Interface program to as for Blending Inventory Parts in Master /Other Orgs. .
• Actively involving in R12.2.5 implementation for Knottingly, UK site for Global Blending automation project .
• Actively involving in UAT sessions, follow ups and Issue resolutions, fixes and Support enhancements on a Critical Custom ADF Order Management screens and backened processing . Discuss on requirements for new RICE objects as necessary
• Involved in RICE Object development such as ‘Order Confirmation report’, Pl/Sql package scripts, data loading using SQL* Loader programs and Interfaces.
• Developed Request Shp Date / Pack Size defaulting mechanism using CUSTOM.pll and Forms Personalization .
• Developed and supported the application issues on Pricing /Order processing Programs using API’s QP PREQ PUB.PRICE REQUEST, OE ORDER PUB.Process Order.
• Developing the OBIEE Dash board and Analysis reports for Reconcialtion between Syste21 and Oracle EBS systems for PARALLEL . PO/SO/MFG Dashboards created are helpful for Senior management and Stakeholders to take decision on GO-Live schedule for KNOTTINGLY roll out and Project planning further .
• Designed and Customized the seeded ENGCSTEP.wft Work Flow for necessary document attachment verification by business groups as required in PIM Inventory Item creation /management .

Confidential, Wilmington, OH

Oracle EBS Techno Functional Designer and Developer

Environment: OracleEBS/Applications-R12.1.3 iProcurement, Receivables, GL, Purchasing, Inventory, Payables, XML Publisher, Oracle 11g, and PL/SQL,SQL Loader

Responsibilities:

• Participated in requirement gathering sessions for (RTP- Roberts Truck Parts ) Division Parts migration(Legacy- Oracle EBS) and maintenance business automation. Performed GAP Analysis and proposed few Implementation design options to the Manager and team. Performed necessary sample test processes.
• Initiated Oracle process design &analysis meeting within team members, Integration team and Business analysts.
• Designed and Developed ‘Fuel Tank Fill’ Interface to Oracle EBS which records Daily basis Fuel consumption at various Terminals.
• Involved in AR invoice interface setups.
• Designed and Developed RTP Parts migration to Oracle EBS across all service centers.
• Involved in automating the Invoice creation process for new and existing Operating Units with Accounting manager & team .Developed the AR Invoice interface to cater the Invoice (AR ) creation from legacy.
• Developed Email notification program using BI/XML Publisher to notify AR administrator on Interface related errors.
• Developed BPA Invoice template for one of the Division .
• Took lead in support and design efforts by doing research and study when required .
• Took lead role in deploying, testing the Daly rates Interface by facilitating necessary meetings with Third parties after market research, coordinated through Production deployment, engaged in proposing the contract sign offs further.
• Make sure that the Sourcing setups are done so that best possible price is defaulted on to the requisition either from the Purchase Agreements or Quotations
• Involved in setting up new Inventory Org, Sub Inventory and planning .Set up ASL and BPA related configurations

Confidential

Oracle EBS Application Engineer (Technical Developer)

Environment: OracleEBS/Applications-R 12.0.6/12.1.3 (PO,PA, Oracle Payments, Payables, FA, Project Costing, XML Publisher, Reports, Oracle 10g/12C, Workflow Builder, SQL*Loader, Shell Scripts, and PL/SQL,OAF

Responsibilities:

• Participated in requirement gathering sessions, discussions on day to day basis with the Business analysts, business teams from various functions.
• Took lead in all support and technical efforts at client place by Co-Ordinating with the Business on requirements gathering .Held necessary meetings with various business teams and Third parties.
• Took lead role in deploying, testing the Daly rates Interface by facilitating necessary meetings with Third parties after market research, coordinated through Production deployment, engaged in proposing the contract sign offs further.
• Closely worked with other groups such as Hosting/Finance/ Integration teams to come up with project plans for upgrade by considering dependencies within EBS and other applications.
• Developed ISO20022 ACH format Payment files for domestic and International entities, this will enable the direct transmission of Payments from Oracle without any manual intervention. Involved in Production migration and handled necessary support. Held weekly meetings with Bank IT technical staff through development, UAT cycles and lead the Production migration and support further.
• Designed and Developed the Workday to Oracle EBS integration solution using GL INTERFACE
• Responsible for creation and review of design documents, unit test plans, code.
• Developed Payment Check formats for more than one Entities.
• Involved in customization and development of Positive Pay file for Bank Payments.
• Developed concurrent programs using R12 API’s upon requests from Business teams, which helped them to have better Insight into their Transactions.
• Worked on analyzing and modifying existing interfaces (Inbound) related to Project Costing .
• Handled many Production support issues /analysis as required by Business in their day to day activities.
• Involved in redesigning some of the existing Interfaces in GL/AP and developed necessary enhancements.
• Involved in Supplier Bank and Payment Process setups.
• Analyzed and Upgraded all the RICEW components during all CRP phases in the process of Oracle Up gradation and involved in technical cut over plans. Involved in RICEW estimations, testing cycles. During this process held meetings discussions with business on various reports usages & analysis.
• Involved and took as Technical lead role during COUP(Oracle Upgrade Project) and supported through Go Live cutover .Followed up with Oracle Support for SR resolutions.
• Gathered business requirements and defined business processes, participated in set ups and test scenarios . Configured in Electronic Payments and payment process profiles. Involved in Journals/GL related set ups .
• Raised and followed up on SR's with Oracle support.
• Customized the PO Approval workflow to change the notifications.
• Developed SQL scripts and Reports when requested by Business team on day to day interactions Eg. Asset source lines, Bank branch exception reports, Suppliers /sites of EFT payment method etc.

Confidential

Oracle EBS Technical Consultant

Environment: Oracle EBS 11i, R12, BPEL 11.1.1.6, Oracle10g,XML Publisher

Responsibilities:

• Participated in requirement gathering sessions with the Business analysts.
• Designed and Developed the interface for Quote to Order Integration and BSA Creation.
• Involved in developing the Item Price list Integration for the Quote lines which were ‘Won’ and ‘Submit’ Status.
• Developed the complex Integration between on Shop floor Annealing Operation and CAPS System.
• Involved in Forms personalization on Quotes workbench to invoke the Integration.
• Designed and developed a Comprehensive Payables Open Interface and Items On hand Conversion Programs.
• Developed and customized custom PL/SQL packages as part of existing Shop floor Custom application and Involved in Release Migration.
• Involved in multiple Oracle forms’ (Custom) changes and enhancements as part of COD Shop floor Operations and CAPS System.
• Involved in Code Fixes & Unit Testing and coordinated the integration testing and system testing efforts as part of Release migrations.
• Responsible for Kintana migrations of various components also using the PVCS for versions control.

Confidential

Oracle EBS Technical Lead

Environment: Oracle ADF BC, JSF, BPEL, WSDL, SOAP, R12 (Service Contracts/AR, Trade Management, Oracle Install Base, EB Tax, Payables)

Responsibilities:

• Have been Involving in production Support & Enhancements Releases Of Oracle EBS & Custom ADF application (Warranty Application).
• Worked as Onsite coordinator and Lead in a New Enhancement Project ‘I Warranty Registration Extension Project’.
• Coordinate with offshore team on a day to day basis and provide guidance on various RICEW components and ensure unit testing of the delivered components in a timely fashion.
• Have been handling the Issue Configuration Tracker and coordinating on and Assigning on Incident Tickets in Offshore-Onsite Model.
• Developed SOA WEB-Services using BPEL (Ver. 11.1.1.5.0 ) for feeding EBS Data to Web Portal for Contract Registration information reports. Developed XML Schemas for validation of Webservices.
• Designed and lead effort with offshore team on development of the Warranty Registration & Extension.
• Involved Issue Analysis and Estimations in Custom Developed ADF Application which is called ‘I Warranty’ and Analysis.
• Involved in Client business team meetings for requirements analysis and coordinated the implantation of Bug fixing process.
• Involved in ADF Code Fixes using extending View Objects, View Links, Entity Objects, and Application Modules etc. Written Method Call activity for method bindings. Involved in Code Migration to WebLogic Server.
• Developed ADF Business components based on Oracle Database. Involved in changing the existing ADF Page fragments, JSPX. Developed Pop Up window using ADF Table.
• Developed the Service Contracts conversion programs for existing service contracts.
• Took active participation in Issue Resolutions and scheduling meetings during SIT & UAT Runs.

Confidential

Oracle EBS Analyst

Environment: Oracle EBS R12, 12.1.3(Order Inventory, Oracle BOM, Oracle Purchasing, Oracle AR), Oracle11g, SQL Developer

Responsibilities:

• Developed Coding standards and Common Utilities helping development efforts.
• Work with business stake holders in identifying the legacy data that need to be migrated to oracle and carrying out regression testing and validation of data upon migration from legacy applications on to the targeted oracle apps instance.
• Designed and Developed all data conversion programs in Inventory / Payables modules.
• Involved in Integration of Software Printer with Oracle Warehouse in Label Printing Using INV SYNC PRINT REQUEST.SYNC PRINT REQUEST API.
• Handled Form - Personalization, CUSTOM.PLL for some of the business Requirements
• Involved in Performance Tuning of the various Conversion /Interface design developmment components.