SUMMARY:

• 9+ years of rich IT experience within high stake projects
• Hands on in - depth technical experience in design, development, unit testing, deployment and post-production support of Oracle EBS RICEWF components with PL*SQL and writing Unix Shell Scripts
• Strong experience of Oracle 11i / R12 General Ledger (GL, COA, GCS, FSG), AGIS, Accounts Payables (AP), Oracle Payment, Accounts Receivables (AR), Cash Management (CE), Order Management (OM), Service Contracts (SC), EB Tax, Fixed Assets (FA), Purchasing (PO), Oracle i-Procurement, Oracle i-Expense, ADI, Sys-Admin, SLA and Web ADI.
• Good knowledge and working experience of Oracle 11i / R12 Install Base (IB), Inventory (INV), Bills of Materials (BOM), Work in Process (WIP), Workflow Administrator, Oracle Approvals Management (AME) and Costing.
• Experience in Cost Management (CST), Process Manufacturing (GMA), Project Manufacturing (PJM), Quality (QA)
• Good knowledge and working experience of Reporting Tools like Discoverer Reports, XML Publishers, BI Reports and Business Objects (BO) Universe.
• Basic knowledge and working experience of Virtual Traders (VT) and RevPro Applications.
• Performing all kinds of tests including Smoke, UAT, End to End, Integration, Functional, Stress, Regression, System testing, Data Driven, and Performance.
• Worked on the RICE Components like Inbound and outbound interfaces, Conversions, Form customizations, Reports and other Objects, Prepared functional specifications MD50 for all the RICE Objects.
• Have been involved in resolving issues related to the RICE objects in Conference Room Pilot CRP, User acceptance testing UAT and Production Go-Live in various projects and developed strong project full life cycle expertise in implementation projects. Have worked under tremendous work pressure environment and devised strategy and changes in technical design and program as per the varying requirement of clients.
• Experienced in BI Publisher, RDF report, Forms and Forms Personalization
• Strong performance tuning experience, troubleshooting and resolving issues of high complexity with no supervision
• Report development experience with Java and XML
• Excellent presentation skills with the ability to communicate ideas in both technical & business-friendly language
• In-depth knowledge of Oracle API’s as well as REST/SOAP web services
• Excellent Technical knowledge in Order to Cash(O2C), Oracle Financials, Record to Report processes (R2R) and Procure to Pay(P2P)
• Review requirements document, propose and design solutions, create technical design, deployment and other required documents
• Setup EDI 855 Purchase Order Acknowledgements.
• Setup EDI 997 Functional Acknowledgements.
• Wrote custom packages to define the Trading partners in the e-commerce gateway module, update the EDI details in the corresponding modules

TECHNICAL SKILLS:

Languages: Core Java, Pl/Sql, XML and UNIX

ERP: Oracle Application (EBS 12.2.4)

Database: Oracle, MySQL

Tools: EBS R12/11i, Eclipse, JDeveloper, Visual Studio 2015, Toad, MKS, CVS, Tibco Business Works, Tortoise SVN, HP Kintana, Tibco ADB, JavaScript, UML, Apache Tile, Design Pattern Oxygen XML editor, Visio, HP Quality Center, Tomcat, Jboss, WebSphere and Git

PROFESSIONAL EXPERIENCE:

Confidential, Mountain View, California.

Software Developer

Responsibility:

• Developed the intercompany automation to provide waterfall report and post to GL
• Developed the R2R for Rev - share amortization
• Developed the R12 to Virtual Trader data extraction for single tier and multi-tier orders and contracts
• Developed the E-fulfillment letters to the customers
• Developed the royalty report to provide the amount per SKU for each partner for a period
• Developed new enhancements in i-store for order post processing
• Developed interface for price list defaulting
• Developed the interface for related item asset Promo code
• Created As-Is and To Be Process Flows and Accounting Entries for each Stage of Buy Sell Processes from OM/SC to AR, AR to GL including VT Intercompany (ICO) Accounting Flows and RevPro Waterfall / Deferred Balance Journals.
• Presented and demonstrated the solution and approach for Cross Functional Receipts.
• Created Functional Specification Documents (FSD) for proposed designs, solutions and approaches.
• Provided the solution to standard RevPro (third party software and application) Waterfall and Deferred Balance Report to specially cater to the need of Statutory Requirements where the Calendar and Currency is different from Primary Ledger.
• Provided write up and training documents to Business Users to handle the Audit and/or Statutory requirements related on SLA, RevPro Waterfall and Revenue Deferred Balance Reports, AR to GL Recon Report and few other processes.
• Provided Go-live support for all Buy sell related processes, that includes but not limited to AR, OM, SC, INV, GL, VT (ICO Transactions), and RevPro processes.
• Designing integrations between O2C (Order-to-Cash) systems - including Oracle Applications (E-Business Suite) R12, and other internal systems. Gathering requirements, designing solutions, configuration changes, setting up Proof of Concept (POC) demos, designing customizations/extensions, testing solutions, generating/performing test scripts, writing documentation, etc. Primary Oracle modules: Order Management (OM); Accounts Receivable (AR), General Ledger (GL).
• Designing changes to the existing Oracle Applications (E-Business Suite) R11i system and its related systems (including a custom quoting system, and a custom software licensing system). Gathering requirements, designing solutions, configuration changes, setting up Proof of Concept (POC) demos, designing customizations/extensions, testing solutions, generating/performing test scripts, writing documentation, etc. Primary Oracle modules: Order Management (OM), Accounts Receivable (AR). Secondary: Service Contracts (OKS), Install Base (IB/CSI).
• Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Requirements Gathering, Development, Testing and Production Integration of Oracle E-Business Suite Modules including Extensions-Customizations.
• Vast experience and developed several interfaces and conversions viz. RICE components from legacy systems to Oracle Applications and within several modules in Oracle applications.
• Experienced in solving client related production issues on the HCM and General Ledger module and enabling the client to streamline their business processes and logging Oracle Service Request to resolve issues. Reviewing and Performance tuning of SQL and PL-SQL procedures, functions and packages using SQL Trace and TKPROF utility
• Designed Ship Confirm Interface to pick release sales orders in business operating unit as soon as corresponding factory sales orders got ship confirmed.
• Developed PO interface to import PO orders from legacy systems. Used APIs to update quantities and to cancel Orders. Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in Accounts Receivables. Defined the descriptive flex fields and key flex fields

Confidential, Seattle, WA

Technology Analyst

Responsibility:

• Resolve production incidents
• Develop interface AR data to custom application
• Work on istore application to interface Orders to R12
• Onsite - Offshore coordination
• Creation of Journals & Post, Journal Approval Configuration & Testing
• Created Reverse Journals Setups & Process, Data Access Set Setups & Process, Security Rules Setups & Process along with Cross Validation Rules Setups & Process
• Completed and updated setup for financial modules (GL, AP, AR, (AP/AR Netting), FA, CE, AGIS, Oracle Payment, EB-Tax for newly added Legal Entity including setup required to support Maestro Jobs schedules.
• Completed Unit Test, QA Test and UAT to Test Business Processes/Test Scenarios.
• Resolved defects for QA and UAT testing for all financial modules.
• Prepared incremental BR100 GL, AP, AR, FA, CE, AGIS, Oracle Payment, EB-Tax for newly added Legal Entity and getting the same approved through HP Project and Portfolio Management (PPM).
• Coordination with PROD Team to complete setup and conversions.

Confidential, New York

Technology Analyst

Responsibility:

• Developed Interfaces to create internal Purchase Order Requisitions and Purchase Orders.
• Lead offshore team in developing Customer/Account Receivables/Supplier Conversion program to import Items from custom applications/11i system to R12 systems.
• Developed Conversion program to extract data from different sources like Oracle, Flat files, External files/systems and transformed the data based on Business requirements and loading into Oracle target database using oracle standard APIs.
• Involved in Performance testing, User Acceptance testing support of the application and participated in Code and Design Reviews, Status meetings and Walkthroughs.
• Developed shell scripts to send out automatic notifications in case of success and errors to reduce manual monitoring during conversion cutover.
• Developed inbound interfaces for major US bank to interface the invoice transaction to oracle system for payment activities done through bank to suppliers.
• Responsible for support activities on an on - demand basis for both custom applications and Oracle Applications.
• Worked on AR, OM and GL to maintain consistency between legacy system and Oracle Apps. The interface components include 'Journal Import', 'Payables Invoice Import', 'AR Invoice Import' etc.
• Designed and customized custom Forms using Oracle Forms 6i.
• Developed a custom GL interface using APIs to load journal entries from 11i/external application.
• Developed AR approval workflow to send user notification for approval based on hierarchy defined in system. Approvers can able to reject/approve/deny or route the notification to another approver.
• Customized Auto Adjustment to the AR invoices.
• Developed ARMS Interface to load the open AR Invoices to ARMS database/tool from oracle EBS application.
• Developed interface to transmit the batch payments through Paymetric system.
• Worked on month-end open/closing activities for AR and GL module.
• Customized Aging 7 bucket report to extract open transaction into various aging buckets.
• Worked on gap analysis, application design, application configuration, application customization and personalization.
• Resolved Production tickets with a quick turnover time.
• Worked on maintenance/support project and involved Requirement Gathering, Design Analysis and Release Planning meetings with client stakeholders.
• As part of tuning, created Indexes, hints on tables when necessary and made sure the cost of the query executions meets the standards set by the DBAs.
• Documented the development process as per AIM standards and norms for each object along with the test cases.
• Worked on R12 upgrade and vertex upgrade project.
• Customized AR Multi Ship-to Tax program to create tax lines from multiple sources (OM, OKS, etc.)
• Customized to sync the Bill-to and ship-to site usages between Customer Standard and Customer Contact Center.
• Customized to update product line population for Service Contracts, Service Orders and Manual AR Invoices.

Confidential

Technology Analyst

Responsibility:

• Developed Inbound process to integrate the iRecruitment data between oracle EBS and third - party application by using APIs.
• Developed shell scripts to schedule Oracle concurrent programs
• Developed an outbound interface program to transfer Invoice and GL extracts from Oracle to legacy system.
• As part of Conversions from the legacy main frame systems, developed Sales Order and Item conversion based on the business requirements
• Created Stored Procedures, Functions, Caching, Packages & Triggers, Cursors, Collections using SQL and PL/SQL.
• Implemented RICE components i.e., Reports, Interfaces, Conversions and Extensions in the domain of Oracle E-Business
• Suite and strong skills in AOL, Sys Admin and workflow.
• Extensive implementation of AOL concepts like Concurrent Programs, Request Sets, Key Flex Fields, Descriptive Flex Fields, registration of forms, tables and columns. Creating users, menus, form functions, responsibilities and function security.
• Developed modules in Oracle Applications Supply Chain, Procure to Pay(P2P), Order Management(OM), Purchasing (PO), Warehouse Management Systems (WMS), Shipping, Sub Ledger Accounting (SLA)/ Financial Accounting Hub (FAH), General Ledger(GL), Bills of Materials(BOM), Account Receivables(AR), Account Payables(AP), and AOL.
• Worked on Order to Cash (O2C) and Procure to Pay (P2P) business flows.
• Adept at development and customization of Reports, Interfaces, Conversions and Extensions (RICE components) in the domain of Oracle Applications E-Business Suite (Oracle EBS) using SQL, PL/SQL, UNIX Shell scripts and SQL*Loader in the domain of Oracle Applications.
• Extensively worked as System Admin with responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications.
• Enabled client in CEMLI, used AOL/FND architecture and Applications experience in Implementing Trading Community Architecture (TCA) to develop complex trading communities.
• Implemented Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle
• Applications using Oracle open interfaces and Oracle Public APIs.

Confidential

Software Engineer

Responsibility:

• This Project involved implementing of Oracle Applications 11i. Responsibilities included writing conversions and interfaces, customization and development of reports using Reports 6i, Discoverer 10g and XML Publisher and customizing forms using Forms 6i in GL, AP, AR and OM.
• Responsible for gathering Business Requirements, creation of Technical Design Documents and user Documents.
• Worked extensively on Customer Conversion using interface tables to import customer data from Legacy system. Was involved in data mapping, and interaction with functional consultant and business users.
• Developed a custom item interface program for loading legacy items information into Inventory Item Interface tables, by validating items according to their predefined item categories and category sets.
• Designed and developed Order Import Interface for daily and weekly feeds of orders.
• Developed Vendor conversion program to import vendors from the legacy system into Oracle with required validations.
• Customized AR account status Report, and AP Trial Balance report using Report 6i tool.
• Designed and developed reports using combination of Report 6i and XML publisher for modules like Purchasing and Order management.
• Developed reports in Discoverer 10g and created various business areas, user views, custom folders and joins for reporting. Created Workbooks based on the Custom
• Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop.
• Involved in Workflow customization for approval hierarchy level in Purchasing.
• Developed interfaces integrating Vertex O - series with Oracle Modules OM and AR.
• Created several Requests and Request Set to attach the PL/SQL procedures, SQL*Loader routine and Reports with Application.
• Perform responsibilities of maintaining and developing code. Handle the tasks of implementing the module in java ensuring compatibility in tools and interfaces.
• Responsible for reviewing and gathering requirements for various software modules
• Perform the tasks of designing software
• Created Pub/Sub Adapters and BW process in Tibco.
• Created the web service in Java.
• Developed the java code for web service using Spring, JDBC, J2EE and JAXB.
• Responsible for the creation of adapter in java using spring.
• Created XSL and xml related components.
• Involved in PL-SQL related components.
• Involved in creating Tibco related components.
• Responsible for creating External Systems and Agents in OTM.
• Preparing UTP for the components.
• Creating handlers and services in the Web service Gateway.
• Kintana related deployments.
• Mentoring freshers.
• Responsible for code development in java.
• Creating web services in java.
• Deploying code using kintana.
• Tibco related deployment.
• Gateway configurations
• Involved in PL-SQL related components.
• Perform responsibilities of maintaining and developing code.
• Handle the tasks of implementing the module in java ensuring compatibility in tools and interfaces.
• Responsible for reviewing and gathering requirements for various software modules
• Handling critical components for monthly /quarterly releases.