PROFESSIONAL SUMMARY

• Around 15 years of IT experience in ERP including Designing, Development, Testing and Implementation of Oracle EBS Applications
• Primarily focused on Oracle E - Business Suite development methodologies coupled with R12 Implementation, Upgrade, Customization and Production support with multiple full life cycle implementations experience
• Experienced on Oracle Procurement Cloud and Process cloud Service.
• Experienced in designing and developing Oracle Reports, Interfaces, Conversions, Extensions and Workflow (RICEW), Oracle Applications Framework (OAF) components, Oracle WEB-ADI, DB objects using SQL & PL/SQL, SQL*Loader, XML/BI Publisher, Linux Scripting.
• Worked extensively in Oracle Applications R12/11i implementation, Upgrade, enhancement & customization of various modules
• Strong working knowledge of business flows like Order-to-Cash (OTC) and Procure-to-Pay (PTP) along with the dependencies and relationships between Oracle Applications modules.
• Involved in 4 complete system development life cycle projects having analytical skills necessary to satisfy development, testing documentation, and Change Management requirements.
• Good Knowledge on Version control tools like Bitbucket, SVN, Flex Deploy, Git hub.
• Good Knowledge on Service now change management tools.
• Worked in Upgrade project to Migrate Customizations, Reports using FNDLOAD
• Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers views, sequences, Materialized views, Constraints, and other database objects using SQL and Advanced PL/SQL.
• Experienced on Third Party Systems like Loft ware, GL Wand, Report Wand, Aventx, VISTA and VPOM.
• Experience in Application System Administration activities like application user setup, defining responsibilities, registering menus, Request Sets, Flex Fields, Profile Options, value sets, forms, reports and concurrent programs and assigning them to request groups
• Good knowledge on oracle AIM Methodology Written MD070 Technical Document, MD050 Functional Document, TE020 Testing Document and CV060 conversion mapping documents respectively
• Performed application settings, testing of business scenarios and user training
• Good knowledge in using tools like TOAD, Edit plus, SQL Developer.
• Strong analytical, interpersonal, and troubleshooting skills and ability to work in a fast-paced and team- oriented environment
• Having Exposure on cloud Architecture.
• Highly efficient in working closely withOraclesupport to resolve seeded application issues by creating and monitoringOracleService Requests (SR)

SKILLS AND CAPABILITIES

ERP: Oracle Applications Release 12, 11i

ERP Modules: OM, WSH, WMS, GL, AP, AR, CM, FA, INV, PO, PA

Oracle Technologies: BI Publisher, Web ADI, OBIEE, ODI

Databases: Oracle 12c

Languages: SQL, PL/SQL, XML, Java, JSP

Tools & IDEs: TOAD, FTP, Data Loader, SQL*Loader, Developer suite 10g

Operating Systems: UNIX, Windows NT/XP/98/2000

PROFESSIONAL EXPERIENCE

Confidential, CO

Designation Techno Functional Consultant

Responsibilities:

• Involved in Implementation of Oracle Procurement Cloud
• Designed and Developed Interface to import Sales Orders and AR Invoices in Order to Cash (OTC).
• Designed and developed Process Cloud Service (PCS) workflows.
• Involved in Implementing Loftware Labelling to print shipping Documents.
• Involved in the Analysis of the customizations for R12.2.9 Upgrade Project.
• Designed and Developed Interface Payment with G Treasury system
• Good Experience in Mobile Supply Chain Application (MCSA)
• Involved in the day-to-day production support activities
• Experienced in developing reports from Report Wand, GL Wand
• Designed and Developed EDI 850 for Sales Orders.
• Involved in Implementing and supporting third party system like Aventx to send email
• Involved in implementing Vista plus software to store the month end reports to share point.
• Involved with Business in gathering requirements during the change control process
• Involved in Database Performance Tuning using Oracle Hints, explain plan, Partitioning, and Indexes.
• Created Dashboards, Critical Reports in Answers with power bi
• Modified the standard reports according to the customized requirements.
• Developed several Oracle reports using XML/BI Publisher INV, WSH, AR, PO, and OM Modules.
• Support during Month End Process.
• Developed Interfaces for Black line Project.
• GAP analysis between the existing Legacy reports, new requirements
• Experienced in working with network-based APIs, preferably REST/JSON or XML/SOAP
• Good Knowledge with change management and configuration management with Service now.
• Good Knowledge with Agile Development Methodologies using tools like Jira.

Confidential, Seattle, WA

Designation Techno Functional Consultant

Responsibilities:

• Involved in the Implémentation and Post Go-live support of Oracle Applications
• Involved in functional support in Order-to-Cash and Purchase-to-Pay modules
• Worked on Customer conversion to bring the data from legacy system to new R12 instance
• Developed an Interface between Third party system and OM module to create the sales orders
• Designed and Developed Auto Lock Box for AR Receipts.
• Designed and Developed Payables Interfaces with Subledger Accounting (SLA) Customization.
• Involved in developing financial accounting hub (FAH) reports
• Involved in the setup of Order-to-Cash (O2C) Receivables processes includingRevenue Recognition, Collections, Invoicing; understanding of integration with Order Management, Inventory, GL, CM
• Designed and developed a onetime script to cancel the high volume of sales orders in OM.
• Involved in various extensions inOrderManagement& Purchasing
• Developed Customized Project Accounting reports using BI Publisher
• Developed customized Accounts Payable Trial Balance Report using BI Publisher
• Modified PO, BPA, CPA, and RFQ Style sheet Reports successfully.
• Worked on the setup ofRevenueRecognitionin AR module
• Used X-query method in one of the reports and developed Bursting Report.
• Customized BI Publisher reports such as Check Printing, Sales Invoice Report, Asset Tracking Report
• Created various reports in EBTax for understanding the rate flow
• Define WSDL for SOA process and tested with SOAP UI.
• Developed Matrix Report and used sub template, Data template BI Publisher Reports.
• Developed Sales Dashboard in OBIEE
• Developed ODI interface to maintain the Parts Dimension table
• Modified the standard reports according to the customized requirements.
• Designed and developed XML Publisher data template and Bursting Reports.
• Review of Code and Design documents.
• Used STAT tool for migrating the code from one instance to other
• Used SVN tool for Code change management and service now ticketing tool

Confidential, Irving, TX

Designation Techno Functional Consultant

Responsibilities:

• Involved in the Implémentation and Post Go-live support of Oracle Applications
• Involved in Requirement gathering and Analysis, Data Mapping and Client interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (TechnicalSpec).
• Involved in functional Testing of the custom components
• Involved in EB TAX Testing
• Development of conversion program for importing invoices, Suppliers, customers, Transactions, Fixed Assets from legacy system to Oracle using open interface
• Define WSDL for SOA process, partner links, BPEL process templates and developed process logic definition.
• Designed and Developed WEBADI Interface to import Sales orders from a text file.
• Worked on Order Settlement process through AR receipt creation and closure
• Worked on Custom AR Report AR Invoice Print to Billtrust using Oracle Reports Builder 10g.
• Customized Dunning Letters standard templates as per business requirements in Account Receivables
• Developed custom Reports in Order Management to achieve the business requirements.
• Used FND LOAD extensively for downloading LDTs for Concurrent Programs, XML Data definitions and Templates, Menus, Value Sets, Request sets, form personalization migration to TEST, UAT and production environments
• Designed and developed WEB ADI components to Upload AP Invoice from a text file.
• Modified the standard reports according to the customized requirements.
• Designed and developed XML Bursting Reports.
• Worked on migrating components using FNDLOAD
• Creation of the Interfaces to external systems
• Used RTF, e-text and Microsoft excel templates for BI Publisher reports to meet various report design requirements. Used OA MEDIA to print Company logos dynamically in BI Publisher
• Worked with the users, BA team, DBAs closely on a daily basis and communicating with the business team if any gaps and providing the solution as per the requirement before the delivery timelines

Confidential

Designation Techno Functional Consultant

Responsibilities:

• Involved in the Development of reusable components of Oracle Applications
• Involved development of in AP, AR, GL, CM, FA, PA and BOM Interfaces
• Developed Interface to import Sales orders from various systems using API
• Involved in Pick Release process, Pick Confirm process and Ship Confirm process during Shipping Execution process using standard shipping API’s
• Developed custom Reports in Order Management to achieve the business requirements.
• Developed Custom Interface in Project Accounting to import new Projects
• Developed Interface to load Receivables Invoices from an external system, contract base toOracle using Auto Invoice Concurrent Programs
• Extensively worked on development and customization ofOracleRICE components as per business needs
• Defining Journal line types, Journal Entry description, Mapping Sets
• Worked on create accounting and transfer Journal Entries to GL.
• Worked on various conversion programs including Supplier Master Data, Customer Meta Data, Items, AP Invoices, Purchase Orders, price lists and On hand quantity Conversions.
• Uploaded the values for all Value sets using Data load in set up steps of General Ledger, Fixed Assets, and Accounts Payables and Cash Management modules including System Administration set-ups.
• Developed interface programs to load the data from external systems intoOraclePurchasing (PO) and Payables Invoices tables.
• Extensively developed SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables

Confidential

Designation Senior Technical Consultant

Responsibilities:

• Involved in the Implementation and Support activities of Oracle Applications
• Worked on Migrating the reports and customizations using FNDLOAD as part of upgrade process
• Involved in supplier data and supplier Bank data conversion from legacy system to ERP
• Designed and worked on custom programs and functional setups as per the client requirements in Inventory & Order Management modules along with O2C cycle.
• Coordinated with the Business Teams during CRP sessions, providing feasible solutions and additional support during testing phase
• Creation of Database tables and other objects, developing Reports by using Oracle Developer suite
• Involved in the Migration of 11i Custom Financial Reports to R12. This includes understanding the source code of 11i reports, developing and modifying them to fit as per the R12 solution design.
• Developed Custom BI Reports, which includes Graphs
• Developed Dynamic Column Reports with BI Publisher
• Designed and developed the New Alerts, Work Flows and XML Publisher Reports meeting the business requirements.
• Worked on migrating components using FNDLOAD

Confidential

Designation Technical Consultant

Responsibilities:

• Involved in the Implementation and Support activities of Oracle Applications.
• Designed and developed Reports in PTP process.
• Developed Customized Project Accounting reports using BI Publisher.
• Developed Custom Interface in Project Accounting to import new Projects.
• Worked on Order Import to bring the orders from legacy system, which is already made available in flat file to Oracle Applications R12 using Order import concurrent program.
• Involved in supplier data and supplier Bank data conversion from legacy system to ERP.
• Creation of Database tables and other objects, developing Reports by using Oracle Developer suite.
• Designed and developed New Alerts, Work Flows and XML Publisher Reports to meet the business requirements.
• Designed and developed XML Bursting Reports.
• Designed and developed Project Accounting and Financial Reports.
• Involved in Development of XSL-FO report from the standard RFQ report

Confidential

Designation Techno- Functional Consultant

Responsibilities:

• Involved in the Rollout of Implementation and Post Go-live support of Oracle Applications.
• Preparing financial project documents like BP080, BR100, TE40 and SOPs in line with AIM terminology
• Involved in Integrating the OTC and PTP process
• Developed Interface to import Sales orders third party system (Active Retail) using API
• Developed custom Reports in Order Management to achieve the business requirements.
• To do the setups and Training in KUT, UAT and finally PROD instances for all financial modules (GL, AP, AR, FA, CM and E-business Tax )
• Developing FSG reports like Balance sheet, Income statement etc.
• Handling post production functional support issues related to Financial modules
• Interacting with functional users to understand the business issues and troubleshooting the problems.
• Developed the integration between ABILITY (Legacy system) and Oracle Receivables
• Monitored Interfaces, Concurrent Programs & for the monthly closure
• To resolve the production support issues on time within defined SLA’s. Responsible for the technical Issues in Interfaces
• Developed new Concurrent Programs, executables and registered to responsibility.
• Engaged in Testing of Technical/Interface enhancements
• Development of Custom Reports
• Development of conversion program for importing invoices, Suppliers, customers, Transactions, Fixed Assets from legacy system to Oracle using open interface

Confidential

Designation Techno- Functional Consultant

Responsibilities:

• Outbound of Suppliers, Items & PO’s to TABS.
• Transfer of Inventory Item Transactions from TABS to Oracle Inventory (Inbound with respect to Oracle APPS)
• Designed and Developed Interface to import Sales orders from TABS system using Interface Tables in Order Management.
• Design and developed the XML reports like Order Status report, Packing Slip report etc.
• Developed custom Reports in Order Management to achieve the business requirements.
• Designed and Developed GL Interface to import Journals.
• Interface the Invoices for sales in Shops, Roaming Customers, Interconnect Customers to Oracle Receivables
• Interface the Receipts to Oracle Receivables.
• Interface the invoices to Accounts Payables, to be paid to the suppliers for using their services for roaming calls.
• Interface the invoices and receipts relating to Postpaid Transactions in the form JV to Oracle General Ledger
• Interface the movement of stock (Items) from one shop to another. This was done in Order management as an internal sales order.
• To do the setups in KUT, UAT and finally PROD instances for the above interfaces
• To give training to key users and provide assistance to them in UAT
• To Prepare Test scripts for UAT.
• To resolve the production support issues on time within defined SLA’s for the above interfaces

Confidential

Functional Consultant

Responsibilities:

• Involved in the Roll-out of Implementation and Post Go-live support of Oracle Applications.
• Interacting with Business users, gathering and analyzing requirements.
• Preparing financial project documents like BP080, BR100, TE40 and SOPs in line with AIM terminology
• To do the setups and Training in KUT, UAT and finally PROD instances for all financial modules (GL, AP, AR, FA, CM and E-business Tax )
• Developing FSG reports like Balance sheet, Income statement etc.
• Designed and Developed Interface for Oracle Order-to-Cash from Third Party Systems.
• Handling post production support functional issues related to Financial modules
• Interacting with functional users to understand the business issues and troubleshooting the problems.
• Developed the integration between Homisco Post paid billing system with Oracle ERP.
• Developed the integration between of Active Retail system with Oracle ERP
• Responsible for the technical Issues in Interfaces.
• Monitored Interfaces, Concurrent Programs & for the month End closure.
• Developed new Concurrent Programs, executables and registered to responsibility.
• Engaged in Testing of Technical/Interface enhancements.
• Development of Custom Reports.
• Development of conversion program for importing AP invoices, Suppliers, customers, AR Transactions, Fixed Assets from legacy system to Oracle using open interface.

Confidential

Designation Technical Consultant

Responsibilities:

• Interacting with Business users, gathering and analyzing requirements
• Worked extensively on Finance modules (AP, AR, GL, and CM)
• Developed the integration of Accounts Payables with the legacy system this includes the creation of invoices, Applying Prepayments to the standard invoices.
• Developed the integration of Accounts Receivable with a legacy system for customer creation
• Developed the integration of GL Inbound interface program to Upload Journal entries
• Developed the Outbound Interface to Integrate with Third Party systems Such as Payments to Banks
• Converted data from legacy system to Oracle EBS
• Designed and developed the custom Reports to meet the business requirements.
• Responsible for Project tracking and preparing Technical Documents
• Coordinated the Global Production Support Team, Users, and Oracle Support in resolving issues related to standard functionality and bugs in Oracle Apps
• Responsible for establishing and maintaining an adequate internal control structure and procedures for financial reporting to comply with Sarbanes-Oxley Act (SOX)
• Responsible for Creating/Managing Users, Responsibilities, Concurrent Executables, Concurrent Programs
• Solving issues such as Period closing issues, Accounting and Posting problems, Data corruption issues