SUMMARY:

• Over 8 years of experience as an Oracle Applications R12/11i (E Business Suite) Techno Functional consultant, with expertise in Oracle Financials modules (AP, AR and GL), Manufacturing Modules(OM, INV, Shipping, PO) and Service and Depot Repair module
• Hands on experience to upgrade Oracle On - Premise solution to Oracle IAAS Cloud based solution which involves lot of coordination, analytical skills, complete architectural knowledge of application and strong technical skills.
• Expertise in implementing RICE (Reports, Interfaces, Conversions, Extensions) components in the area of technical design, development, Integration testing and deployment using open interfaces and APIs.
• Plan and integrate architectural frameworks for Oracle applications with other applications and translate toOracle intelligence
• Strong Knowledge and full hands on experience in Order to Cash (O2C) and Procure to Pay (P2P) Cycle and other Oracle Application modules like OM, PO, AP, AR, WMS and GL.
• Extensively worked on changing the reports according to client requirements and Optimizing the Report Performance using XML publisher and Oracle report builder
• Strong Knowledge in creating Analytical reports/KPI/Dashboards using Power BI, Discoverer Reports and working knowledge of Oracle Analytics Cloud(BICS).
• Sound knowledge on EDI implementations and integration with Oracle apps.
• Full knowledge on Loftware labeling system where managed and created new labels for shipping, packaging material for different vendors
• Solely managed the activities like design, development, coding, testing and End-user .
• Substantial development experience in creating stored procedures, Packages, Triggers, Functions, Indexes etc.
• Proficient in Performance Tuning SQL statements using EXPLAIN PLAN, AUTOTRACE, SQLTRACE and TKPROF.
• Good working knowledge in designing technical documents using AIM Methodologies (MD50 and MD70).
• Experience in using Oracle tools like SQL Navigator, SQL*Loader, Data Loader, FND LOAD, SQLdeveloper and TOAD.
• Automation by writing PLSQL scripts to trouble shoot the bugs.
• Good experience in Remote database administration using WinScp software, remote desktop, Filezilla and Putty
• Good hold on Unix commands and shell scripting
• 24x7 Production Support, customer interactions, team-player, and ability to handle multiple tasks independently.
• Understanding the gaps between systems and providing the analysis and solution for same
• Acted as the primary liaison between the client departments and the Information systems department to collect requirements, business process information and documented them in BR Document post analysis of all risks associated with them and mitigate them.
• Keen learner of new technologies includes Artificial Intelligence, Python and Block Chain etc.

TECHNICAL SKILLS:

ERP Applications: Oracle EBS R12/11i

Modules: Oracle Order Management, Accounts Payable, Oracle PurchasingOracle Service contract module, Oracle Install Base, Oracle Cash Management, Oracle Fixed Assets, General Ledger

Languages/Frameworks: SQL, PL/SQL, JAVA, OAF and Oracle SOA

GUI/Tools: JDeveloper, Oracle Forms, SQL*Loader, SQL*Plus, SQL DeveloperToad, Oracle Apex

Databases: Oracle and MySQL

Reporting Tools: Oracle Reports, Oracle Discoverer, BI/XML Publisher Reports

PROFESSIONAL EXPERIENCE:

Confidential, Webster, NY

Senior Oracle EBS Developer

Responsibilities:

• Production application services - The services include maintenance to production applications to correct faults (fix when broken), performance monitoring, and problem support.
• Production database services - The services include database administration, maintenance to production databases to correct faults (fix when broken), performance and data growth monitoring, and purging and archiving of data. Provide ERP Application support by handling day-to-day issues
• Provide bug fixes to resolve these issues.
• Consolidation of user requirements to technical documents.
• Create custom tables, views and materialized views.
• Develop PL/SQL packages, procedures and functions.
• View Object extension for several OAF pages to display a new custom attribute column in the LOV.
• Developed new OAF pages through JDeveloper10G/11G.
• Worked on Customizations of OAF Pages.
• Write UNIX Shell scripts for coping and moving files to and from the server.
• Attending Review calls, team meetings and knowledge sharing meetings.
• Involved in Procure to Pay (P2P) & Order to Cash (O2C) business flow.
• Worked on Payables Standard Invoice Interface to import Invoices data into Oracle AP base tables. Various validations are performed on the staging table data.
• Designed and developed PO requisition interface to load PO requisitions from the legacy System into oraclepurchasing (PO) using SQL*Loader and PL/SQL validations
• Design and Developed Budget Over Head report which shows each account and summary account level what is the Budget amount and Actual Amount in Oracle GL.
• Design and Developed Custom Check format for the new operating unit.
• Design and developed Supplier Remittance Advice Email in Payables.
• Design and Developed Inventory Monthly Transaction report and Inventory Monthly Balances report MD050, MD070 using BI Publisher.
• Developed Auto Invoice Interface which imports invoices, credit memos and debit memos into OracleReceivables (AR) module using SQL*Loader and PL/SQL validations.
• Designed and Developed the Item Import, Item Assignment and used the Standard Interface Program to import.
• Design and Developed Contract's Expiration Report to send to email of Resource Managers using XML Bursting technique in BI Publisher
• Developed new programs to integrate the data from Oracle to BO system to generate reports.
• Customized Reports in Account Receivables using XML/BI Publisher.
• Working with the users and fixing the issues related to SIT testing.
• Worked on Resolving Tickets, databases to fix issues and data growth monitoring.
• Used Putty, SSH, Telnet for UNIX login to check the server logs.
• Customization of forms, reports, xml publisher reports.

Environment: Oracle E-Business Suite R12 (12.2.5), Unix, JDevloper11g, Reports 10g, Forms 10g, Discoverer 11g, SQL*Loader, TOAD, Unix Shell Script, XML/BI Publisher, OA Framework(OAF).

Confidential, San Francisco, CA

Oracle EBS Developer

Responsibilities:

• Provided technical support, development and implementation of Oracle R12 solutions in a multi organization environment
• Identified recurring issues in support and proposed an efficient solution with development plan and estimates for stakeholders
• Provided proactive technical solutions for any issues and communicated the same with stakeholders
• Point of contact for support and development tasks in Oracle Financials environment
• Worked business analyst to prepare technical design documents and give estimates for the deliverables, developing technical documentation using AIM methodologies and following SOX procedures
• Used PL/SQL collections, UTL FILE, DBMS SQL and bulk binding while creating PL/SQL objects
• Wrote shell scripts for file transfers to external and internal systems
• Developed/integrated new projects in financial modules (AR, AP, GL, CM and Purchasing)
• Worked with Business Analyst to understand the business requirements and translate in to technical specifications
• Worked with System Administrator and Oracle support for coordinating support and maintenance of OracleSystem
• Provided custom solutions for internal/third party interfaces, reporting and Oracle upgrades
• Facilitated technical design and development of bank integration in inbound/outbound interfaces
• Worked with Business team to ensure that all configurations/setup made the interface/extensions work
• Worked with business team to understand the SOX and Audit pain points and automated the process to make the SOX/Audit practice easier
• Automated the product addition in Oracle Financial systems for revenue recognition
• Developed OAF pages and customization of OAF pages in iProcurement space
• Implemented the GIT and review board process to fit in SCRUM process
• Developed Oracle BI publisher Reports (XML Reports)

Environment: SQL, PL/SQL, Java/OAF, BI/XML Reports, GIT, Shell Scripting, AP, AR, PO, CM, Fixed Assets

Confidential, Rockville, MD

Senior Oracle EBS Developer

Responsibilities:

• Worked on OAF reports. Worked on OAF forms.
• Interaction with client/end users & updating the status. the end users and preparing end user material.
• Attending Review calls, team meetings and knowledge sharing meetings.
• Worked on UNIX to upload the data into database tables.
• Worked BRSD rejection reason Interface to upload all the rejected orders.
• Developed PLSQL code for OAF forms.
• Worked on developing Customer Account update, Customer Profile updates Conversion in AR.
• Developed SQL Loader program to import PO Receipts data file into staging table from third party system.
• Worked on Technical Document and development of Sales Contract Conversion.
• Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables.
• Customized AR Aging 4 and 7 Bucket reports in Account Receivables AR, Chart of Account Detail Listing Report using XML/BI Publisher.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes using Report Builder.
• Developed Receivable label report which included barcode designing in it using XML/BI Publisher.
• Order Details screen - Created an Order detail report in XML Publisher and integrated the Report in OAF. Worked on objects of OAF extension based on the small changes required by the client.
• Creating LDT files for Menus, Functions, and Concurrent programs.
• Customized Purchase Order (PO) Form using Custom.pll for comparing the unit price entered with the component prices entered in the descriptive flex fields.
• Developed OAF forms to view the manager details, user details.
• Preparing End user manuals to all the developed pages.
• Create custom tables, views and materialized views.
• Develop PL/SQL packages, procedures and functions.
• Worked on Monthly calculation run, and Quarterly calculation run for EBU Reseller.

Environment: Oracle E-Business Suite R12(12.2.2), XML/BI Publisher, Reports 10g, JDeveloper11g, Forms 10g, SQL*Loader, TOAD, OA Framework(OAF).

Confidential, CA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Created PL/SQL procedures, functions, triggers as needed
• Developed complex technical changes in PL/SQL and SQL queries
• Developed Customer API in Oracle Receivables
• Developed Customer Conversion
• Developed Data Conversion programs for service contracts
• Worked on Process Lockbox inbound integration script
• Employed Service Contracts Module (Order to Cash cycle): solved critical issues in Service Contract billing
• Performance tuned SQL queries to improve the run time results
• Worked on Oracle workflow issues and enhancements (OM Order Line Workflow and service contract Order Line Workflow) and personalization in Service Contracts form
• Developed lookup form using Oracle Forms to display the order information, invoice information and Service Contract information based on customer PO information
• Solved issues in Oracle AME workflow
• Developed reports using Oracle XML publisher: modified existing rtf report based on business needs
• Interacted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data flow
• Prepared technical design documents based on requirements.
• Prepared MD070 document for the PL/SQL and Report objects developed

Environment: SQL, PL/SQL, Java/OAF, BI/XML Reports, GIT, Shell Scripting, AR, GL, Order to Cash, Install Base