SUMMARY

• Over 16 years of experience as an Oracle Applications ERP and Middle ware Technologies like SOA, B2B and OSB.
• Certified from Oracle as “Oracle Cloud Platform Application Integration 2021 Specialist”
• Strong Design and Development skills coupled with strong implementation skills spanning Full Life cycle implementations (11i, R12), Application Rollouts (R12) and Production support (11i, R12).
• Extensive expertise in Oracle Fusion Cloud application, integration - (Oracle SOA Suite 11g/12c, Oracle Integration Cloud) and security-Oracle Identity Governance (OIM and GRC)
• Technical activities include Interfacing with users, identifying functional and technical gaps, estimating work, architecting system interactions, designing custom solutions, programming, scheduling, producing documentation and providing production support.
• Prepared functional and technical design documents for customizations and conversions using AIM documentation methodology (MD, CV, BR etc.).
• Highly conversant with various modules of Oracle Financials (GL, AP, AR),FA, Project Accounting, Manufacturing/Supply Chain/Distribution (INV, PO, BOM, OM), WIP, System Administration and AOL.
• Designed and developed CEMLI (Customization, Extension, Modification, Localization, and Integration) and RICEW (Reports, Interfaces (Inbound and Outbound), Conversions, Extensions and Workflow) Components in Procure-to-Pay (P2P), Order-to-Cash (OTC), Drop Shipment, Internal Sales Order (ISO) cycles.
• Knowledge in Packages, Materialized views, Indexes and database design in ORACLE(Stored procedures, triggers, objects)
• Have very strong experience in interface design, customizations, integrating disparate systems, and data conversion.
• Expert in JDEVELOPER, Workflow Builder, Oracle Application Framework (OAF) applications, customization and extension of OAF pages.
• Thorough knowledge of Oracle Apps Data model and how to leverage the data for effective reporting using tools like Discoverer, Oracle Reports and BI Publisher (RTF, eText, XSL and Bursting Templates).
• Supporting Period end closing activities in Inventory and financial modules like (AP, AR and GL)
• Thorough knowledge on Form Personalization’s and Form Customizations along with CUSTOM.pll in handling various Business requirements.
• Solid experience in Database design, creation and management of schemas, APIs, writing stored procedures, functions, triggers, DDL, DML, SQL query performance tuning with hints.
• Participated in multiple CRP(s), including UAT and go-live phases of the projects. Provided support during Go-Live and post Go-Live activities.

TECHNICAL SKILLS

ERP: 11.5.10,R12.1.3

Modules: GL, AP, AR, FA, OM, Shipping, OKC, INV, BOM, PO, WIP,HRMS,AOL,OIC and TCA, Project Accounting and Billing.

Technologies Used: SQL, PL/SQL, Forms, Reports, BI Publisher, Forms Personalization, Alerts, OAF, Workflow and AOL, SOA Gateway, Unix/Host Shell Scripts and JDeveloper

Tools: TOAD, SQL Plus, Putty, SQL Developer, SQL*Loader, FTP, TELNET, WINSCP, FNDLOAD, Discoverer, Reports6i & 10g and Forms 6i & 10g, Workflow Builder, JDeveloper 10g & 11g, XML Publisher, UTL FILE

Version Control Tools: Visual Source Safe, Kintana, NSI,RMT and SVN

Operating Systems: Windows 95/ 98/ NT/ 2000/ XP, MS DOS, Linux, UNIX Environment

PROFESSIONAL EXPERIENCE

Confidential - New Jersey

Middleware Support Resource and EBS Technical Lead

Responsibilities:

• Actively involved in ICS integration for Orders.
• GTM Integration with Oracle ERP Order management modules.
• Handled postproduction support for ICS Integration.
• Been working with SOA, B2B Enhancements, and it’s EDI Messages.
• Providing critical support for running Business in US Business hours.
• Making sure validating SOA INFRA Health by running different queries.
• Co-Ordination with O2C and R2R EBS Teams for making sure of Order and Invoice Cycles.
• Been following AIM Methodologies for Technical design and developments.
• Designing solutions for Enhancements and responsible for Migrations.
• Designing Volume testing cycle and helps developers to execute same.
• Co-Ordination with different trading partners and make sure business run smoothly.

Confidential

Technical Lead

Responsibilities:

• Leading team of 12 Technical Members and weekly status technical team meeting.
• Design Technical specifications and transfer to Offshore team.
• Developing complex RICE Components and High Critical Components.
• Interact with Business customers to understand and document the changes.
• Have worked Integration procedures with Move medical, SFDC, Model N, Concur, EDI and other systems.
• Designed webservices for Move medical Order integration.
• Have designed and developed for Items Integrations with ICS.
• Have knowledge to talk with SOA Team and finding out solution with all 3rd party systems.
• Have involved actively with performance tuning of codes for different components.
• Co-ordinating all technical team member’s efforts and summarize them in a weekly status meeting.
• Leading System administrator team by providing directions to reach right approvers and understanding User Access request process.
• Leading issue resolutions for GRC Process and Conflicts.
• Lead the deliverables by coordinating with all technical/testing team members to ensure functionality is delivered on agreed solution.
• Co-ordinating OIM team with HRIS team for resolving Birth right roles and making sure all new joiners get their credentials.
• Perform gap analysis to determine our e-Business suite’s system configuration and development changes.
• Design and implement applications and system modifications.
• Coordinate the work between the team and define strategies to showcase the continuous improvement on business intelligence related activities.
• Work closely with management, application development and users on system solutions to solve business problems.
• Leading team by improve application support standards, recommend new equipment or implement software packages.
• Making sure all technical team would follow Oracle AIM documents and follow Integra SOPs.
• Train staff and users to work with computer systems and programs.
• Actively participating in technical design reviews.
• Gathering requirements from Functional team and translate into technical requirements.
• Handling all high priority incidents and providing technical solutions.
• Actively involved all Business meetings and providing technical inputs for future implementations.
• Involve in Performance improvement discussions related Oracle Programs and Echo System and application systems to serve new purposes.
• Analyze and design business requirements on standalone systems using techniques such as structured analysis and data modeling integration.
• Involve in system capacity planning, performance tuning, monitoring and troubleshooting the application and business issues.
• Design data solutions for traditional enterprise business.

Confidential

Rollout Sysadmin and Sr Developer

Responsibilities:

• Supporting Period end closing activities in Inventory and financial modules like (AP, AR and GL)
• Gathering requirements from Business users and Functional resources
• Design MD070 Docs for all RICE Components.
• Transforming Business requirements into technical solutions and passing same to Offshore.
• Handling Complex objects at Onsite
• Handling R12 Rollout Sysadmin Activities as per Integra process.
• Actively involved in ICS integration for Customers and items.

Confidential

Technical Lead

Responsibilities:

• Have been working as Onsite Manger to manage Six Resources at offshore
• Supporting Period end closing activities in Inventory and financial modules like (AP, AR and GL)
• Gathering requirements from Business users and Functional resources
• Design MD070 Docs for all RICE Components.
• Transforming Business requirements into technical solutions and passing same to Offshore.
• Handling Complex objects at Onsite
• Designed and Developed Technical Specification for Sales incentive compensation quota upload.
• Designed and Developed Technical Specification for Compensation Statement report.
• Review the Offshore Developed components before releasing to Pre-Prod instance.
• Developed Generic locator logic for one of Inventory cycle.
• Worked on Order Line Workflow with Pricing Customization.
• Developed OM related Queries for Metric evaluation of TEI Rollout
• Developed Sales Order Detail report and live visibility Report.
• Developed HRMS Queries like Future Dated, Current Employee and Termination Queries for Oracle Identity Management.
• Developed Sales Rep Credit logic for different Sales Persons.
• Developed PO Number derivation logic in cXML code.
• Developed AP Outbound interfaces programs for BOA
• Primarily worked for Roles and Responsibility migration for Different Roll outs.
• Developed Audit related queries for Access systems.
• Developed different excel reports for PO, INV, OM, AP, AR and GL modules.
• 11i Access Co - Coordinator for all Business Users.
• Worked on AME workflow Customizations
• Developed Unix Shell Scripts
• Developed OAF personalization and extensions.

Confidential

Technical Lead

Responsibilities:

• As Onsite Technical Lead, am responsible to deliver Supplier, Customer Conversions.
• Developed Order Import and AP Invoice programs for R12.
• Developed Customer OTM Reports in R12.
• Developed Check printing templates for Different US Banks.
• Have Developed Technical Specification and Test Scripts for all Developments.

Confidential - Buffalo, New York

Technical Lead

Responsibilities:

• As a Technical lead and am responsible for all delivering of technical components.
• Monitoring of Technical components status and expedite solution to deliver components.
• Have Developed Ten Different XML reports with Barcodes and also excel Reports.
• Passing Functional Requirements to Offshore Team and also make sure the deliverables on time with a Quality output.
• Responsible to conduct CRP and UAT Session for all Technical components and design solution methodology for out coming new enhancements and issues in CRP and UAT Sessions.
• Have Developed Technical Specification and Test Scripts for all Developments.
• Have designed Parsing Solution with OAF Pages.
• Supporting Period end closing activities in Inventory and financial modules like (AP, AR and GL)
• Have Designed Big screen display in both form and OAF Page.
• Have developed Form personalization to launch XML reports.
• Have developed single unique program to launch different Loftware Labels and with different printers.
• Have developed automation procedure for packing slip and picking audit report.
• Have done Setups related to Users and also designed Responsibilities related to MSCA module.
• Have been reviewed and developed Migration scripts for R12

Confidential

Responsibilities:

• Worked as Onsite Technical Lead in WIP, INV and OM Modules.
• (Onsite Technical Lead worked in complex customizations and monitored offshore team of 2 Members)
• As a Technical lead and am responsible for all delivering of technical components.
• Monitoring of Technical components status and expedite solution to deliver components.
• Have Developed Ten Different XML reports with Barcodes and also excel Reports.
• Passing Functional Requirements to Offshore Team and also make sure the deliverables on time with a Quality output.
• Have Developed Technical Specification and Test Scripts for all Developments.
• Responsible to conduct CRP and UAT Session for all Technical components and design solution methodology for out coming new enhancements and issues in CRP and UAT Sessions.
• Have designed different programs to launch different Loftware labels.
• Have been reviewed and developed Migration scripts for R12

Confidential - Buffalo, New York

Technical Lead

Responsibilities:

• Have Customized Standard Pick Selection Generation
• Have Customized OM Workflow to get RMA Credit decision functionality.
• Have customized Pricing Engine to get markup value.
• Have developed ship method default - automatic mechanism.
• Have populated all internal order attributes based on Sub inventory setup.
• Have done Setups related to Users and also designed Responsibilities related to AP, AR, and GL modules.
• Have been reviewed and developed Migration scripts for R12
• Have developed OAF Page customization to capture sunshine act expenses.
• Have worked in Form personalization in OAF Pages and other OM and PO Screens.
• Supporting Period end closing activities in Inventory and financial modules like (AP, AR and GL).
• Have been monitored team to develop around 20 XML Reports in AR, PO, INV and OM Modules.
• Passing Functional Requirements to Offshore Team and also make sure the deliverables on time with a Quality output.
• Have Developed Technical Specification and Test Scripts for all Developments.
• Worked on AME workflow Customizations
• Developed Unix Shell Scripts

Confidential

Senior Techno Functional consultant

Responsibilities:

• Have configured PA Templates for Different countries like US, ME, AUS and SG
• Worked in PO Account Generator Workflow.
• Have migrated Customization related to COR and AP Interfaces to R12 Applications.
• Have done Automation of Forecast Siebel b/w R12 application and Siebel.
• Have done Setups related to Users and also designed Responsibilities related to AP, AR, FA, GL and PA modules.
• Have also developed Customer Migration scripts for R12
• Have worked in Form personalization in OAF Pages.
• Have worked in Tuning SQL statements to improve execution performance
• Have developed various UNIX Shell scripts for loading data into staging tables.
• Have developed various automatic batch script to identify various data error as a part of pro active steps.
• Worked on AME workflow Customizations

Confidential

Responsibilities:

• Worked as senior techno functional consultant in INV, PO, OM and Financial GL, AP, AR, FA Modules.
• Supporting and Developing Interfaces and reports for the Financials modules
• Working on PA Auto accounting customization.
• Supporting Period end closing activities in Inventory and financial modules like (AP, AR and GL)
• Changing the XML reports and interfaces as per the requirement.
• Reconciliation of the GL with Sub Ledger Modules
• Developed Discoverer reports
• Developed Integration B/w Hyperion and GL modules.
• Developed Confidential Customer Centric related check print report for US and CA Operating units.
• Developed Integration B/w AP and Legacy System.
• Implemented the Confidential Business rules and Customer facing report for Change Order Process and it is additional Oracle Standard System.
• Worked on AME workflow Customizations
• Developed Unix Shell Scripts
• Developed OAF personalization and extensions.

Confidential

Responsibilities:

• Supporting and Developing Interfaces and reports.
• Worked on PA Auto accounting customization.
• Developed Projects profitability report, resource utilization report etc.
• Changing the reports and interfaces as per the requirement.

Confidential

Responsibilities:

• Developing XML Reports and Inbound and outbound Interfaces with shell scripts.
• Involved in Data conversion for projects, budgets and agreements.
• Supporting Period end closing activities in Inventory and financial modules like (AP, AR and GL)
• Maintained Integration between RP32 Legacy and INV and OM modules.
• Created outbound interface programs for AP and RP32 Legacy systems.