SUMMARY:

• Over 8 plus years of Oracle Applications system experience across multiple streams in the product suite - Financials, Supply Chain Management (SCM), Human Resources (HRMS) and Customer Relationship Management (CRM) as well Financial Services modules like Property Management, Lease Management and Treasury
• Experience in all phases of the Software development life cycle (SDLC) in an ERP environment.
• Experience in various Oracle technologies like ADF, SOA, OBIEE, BI-Apps, OA Framework, Forms, Reports, AME, Workflow, BPEL, Discoverer and XML / BI Publisher
• Involved in pre-sales demonstrations of various Oracle technology products, e.g.: SOA Suite, OBIEE, BI-Apps, ADF
• Techno-Functional consultant with expertise in General Ledger (GL), Account Payable (AP), Account Receivable (AR), Fixed Assets (FA), Cash Management (CM), Purchasing (PO), Order Management (OM), Inventory (INV), Shipping (WSH), Discrete Manufacturing (ODM), Process Manufacturing (OPM), Advanced Pricing (QP), I-Procurement and AOL objects
• Extensive Experience in 11i & R12 implementation and roll-out of SCM modules like PO, INV and OM
• Hands on experience in 11i & R12 implementation and roll-out of financial modules like GL, AP, AR and FA
• Experience in Software Development Life Cycle including Analysis, Design, Development, Implementation, Testing and Post Production Support using Oracle Applications R12 (12.1.3), 11i (11.5.9,11.5.10.2)
• Experience in Customization and Implementation of Oracle Reports 6i/9i/10g, Forms 6i/9i/10g
• Good Experience in business flows like Procure to Pay, Order to Cash and Drop Ship Cycles
• Good Knowledge in Oracle Application Framework (OAF)
• Experience in development & customization of XML/BI Publisher and Discoverer Reports
• Extensive experience with XML/BI Publisher, Oracle 9i Discoverer, JDeveloper, Developer, Form builder, Report Builder, Workflow Builder, Kintana, VSS, PuTTY, Toad, SQL Developer, SQL* Loader, SQL and PL/ SQL programming on Windows and UNIX with Oracle database
• Experience in I-Store, I-Expenses, eBtax and TCA modules
• Extensively Worked on AIM documents like MD050, MD070 and MD120
• Experience in completed R12 implementations in Financials, HRMS, SCM modules
• Experience in development and extension RICE(Reports, Interfaces, Conversions, Extensions, Forms and Workflow) components using SQL and PL/SQL, Customization of forms using CUSTOM.pll, reports using XML Publisher and exposure to Workflow, Web PLSQL, JTF, MSCA, OAF, ADF using jDeveloper 9i, 10g, 11g and development of business reports using OBIEE
• Areas of expertise include in Receivables, Payables, Inventory, Order Management, Purchase Orders, BOM, Trading community Architecture, Telesales, Quoting, Service Contracts (OKS), iStore, iProcurement, iExpenses, iRecruitment, iSupplier and HR Modules such as Employee Self Service, Oracle Time and Labor, Oracle Learning Management, Benefits, Payroll and Fusion Talent Management sub-modules such as Goal Management, Performance Management and compensation management in ERP modules
• Good functional knowledge in O2C and P2P cycles, HR Modules, and Fusion Talent Management
• Experience in registration/migration of Forms, Reports, OAF UI pages, ADF Pages, PLSQL programs and XML Publisher Reports
• Migration of legacy data to oracle using SQL*Loader and UTL FILE utilities
• Experience in using Bug Management Tools such as Bugzilla, Footprints, Numara Track IT and STAR JIRA
• Functional experience across e-business suite modules: Services, Customer Care, Install Base, Trading Community Architecture (TCA) and Marketing, Receivables, Payables, General Ledger, Treasury, HRMS, Performance Management, Payroll, Projects, Inventory, Order Management, Purchasing, Work in Process (WIP), Bill of Material (BOM).

TECHNICAL SKILLS:

ERP Application Version: - Oracle 11i, R12, Fusion.

ERP Modules: Techno-Functional Skills in Accounts Payables(AP), Accounts Receivables(AR), INV, OM, PO, BOM, TCA, Telesales, Collections, iPayments, iExpenses, iRecruitment, iStore

Technical Skills in iSetup, Quoting, Service Contracts (OKS), iSupplier, Sourcing:

Techno: Functional Skills in HR Modules such as ESS, OTL, OLM, Benefits, Payroll and Fusion Talent Management sub-modules such as Goal Management, Performance Management and Compensation Management, Oracle Forms (6i/9i/10g), Oracle Reports (6i/9i/10g), Oracle Workflow Builder, XML/BI Publisher, JDeveloper, VSS, PuTTY, SQL, PL/SQL, UNIX, Shell Scripting, XML, HTML, C and JAVA:

Web Framework: -AK Forms, JTF (Java Technology Foundation for CRM Applications), OAF (Oracle Application Framework for E-business Suite applications), MSCA/MWA (Mobile wireless Architecture for SCM Applications) and ADF (Application Development Framework for open source fusion applications), Web PLSQL, ADF Mobile, Fusion ADF

Methodology: -Application Implementation Methodology (AIM)

Tools: - Toad, SQL * Loader, PL/SQL Developer, Discoverer, Data LoaderGUI: - Forms 6i, OAF using JDeveloper 9i/10g/11g, Eclipse 3.2.2.

Programming Languages: -SQL & PL/SQL, C, C++, FORTRAN, JAVA, JavaScript, HTML5, PHP.

Database: - Oracle 8i/9i/10g, SQL Server 2000, MS Access, Sybase, DB2

Project Management Tools: - Microsoft Projects, Visio Editor, PM Smart

Configuration Management: - WinCVS, IBM Web sphere Clear case, Mercury Kintana and

Bug Management Tools: - BugZilla, Footprints, Numara Track IT, STAR JIRA

Java Technologies: - JDBC, JAVA, Servlet, JSP, JavaScript, EJB, RMI, Swing, Hibernate, Spring.

Web Servers: - Apache Tomcat, OC4J, Oracle Application Server, Web Logic

Utilities: - IE 5.0/5.5, Netscape 4.7/6.0, Mozilla, Chrome, Putty, WinSCP

Integration Tools: - XML Gateway 11.5.9, Oracle Workflow 2.6, Business Even System (BES),Message Designer 2.6,Oracle 9i Interconnect iStudio with AQ, DB and FTP Adapters, Oracle BPEL Process Manager with Orchestration and Rules Engine, 10 g Release 2 (10.1.2),CMSDK, Oracle Alerts:

Other Tools/Utilities: - Toad, SQL Developer, Oracle Work Flow Builder, MS Word, Optio, MS Visio, MS project, SMA, Web sphere, XML, BMC, Vault, Visual Source Safe (VSS), Mercury ITG, Sub-version, Test Directory (TD), QC, Support Magic (SM), SQL* Loader, Import/Export utilities, IBM Clear case, Clear quest, Prima Vera, Heat, CVS

Operating Systems: - Windows 98, 2000, NT, XP, 7, UNIX (Solaris, HP-UX), Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Oracle Applications Techno-Functional Consultant

Responsibilities:

• iExpense and iProcurement approval process and self-service screen customizations
• Data loader and interface programs in AR and Treasury modules
• Design, Develop, Review, Deploy RICE(Reports, Interfaces, Conversions, Extensions, Forms and Workflow) components and AOL objects as part issue fix and enhancement requests
• Testing rdf /xml reports in client’s testing environment(Development, QA, Production)
• XML reports on OM, AR, OPM and AP
• Discoverer reports in development.
• Workflow developments for OPM module
• Developed Interfaces for OPM module
• Updated MD50, MD70 and MD120 documents according to the R12.
• Configure Oracle WMS.
• Build and Support new Interface with WMS system.
• Perform code review of the work packets delivered by off-shore or onsite team to make sure it meets the Client WMS standards.
• Involve expert in cross functional teams to provide recommendations impacting functions and peripheral functions surrounding WMS.
• Provides recommendations for development, improvement or simplification as necessary.
• Product Support in 11i and R12.
• Handling Procurement to Pay process for Goods
• Processing services
• Data conversion from 11.5.10 production to R12
• Modification of the P2P Process flow to replacing of PR Line in PO, which involved iProcurement requisitions OAF page, AME Change, Workflow Change
• Engaged in Creation of new accounting rules to defer revenue, assigning the new accounting rule to existing transaction types

Environment: Oracle Applications 12.1.3, AP, iProcurement, OA Framework, AR Interface to GL from HSR, Automation of Receipts and Remittances, Oracle Collections, Oracle iPayment, OM, Java, SQL, PL/SQL, Discoverer, Workflow, Forms, Reports

Confidential, Bloomington, IL

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Upgrade Development and Production support for Oracle E-Business Suite 12.1.3 version of Master Data Management and iStore modules using SQLPLUS, shell scripting, Oracle Components for Java (OC4J), Oracle Application Server, Oracle Applications Framework, JDeveloper, Application Development Framework and BPEL Processes with Oracle Workflow
• Customize standard Unmapped Subsidiary Accounts report using Oracle Reports as per the user requirements for General Ledger Consolidation purposes
• Participated in R12 upgrade project - upgrading from 11.5.10.2 to R 12.1.3.
• Customized forms to make changes related to R12 for MOAC changes and tables changes
• Developed Custom Order Entry screen for user convenience and developed an interface to import these sales orders into OM
• Developed major enhancements required for business process in Order to Cash and Procure-to-Pay cycles
• Redeveloped various custom components for R12 upgrade which invoices PL/SQL packages, views, Triggers, Value sets, AOL components
• Involved in developing custom XML/BI Publisher reports like Open Sales Orders Summary, Purchase Order Summary
• Worked on the technical design and implementation of custom CFS OM Blood Pricing application and the design of the eProgesa (Third party System) to CFS (Oracle e-Business Suite) interface
• Involved in AP Check Printing Setups
• Customized Order Management Header and Line workflows to meet business requirements
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom
• Developed Shipping Report to show data from Install Base and Service Contracts data using Discoverer
• Involved in creating Discoverer reports to generate Purchase Order reports
• Worked on different interfaces like importing AR invoices from one of third party legacy system which validates and submits a standard interface program
• Developed custom AR INTERFACE program which validates and modifies data in the interface tables. This program is designed to update Sales order based data in AR interface tables. Validations and changes based on different custom tables and forms
• Experienced in project costing including Load project costs from sub ledger and Capture costs in a timely manner.
• Developed an outbound Interface to export GL data to third party systems, also inbound Interfaces to import into GL by populating GL INTERFACE table
• Designed and developed a program to convert Bill Rate Schedules of Project Accounting
• Developed the programs for to convert projects, tasks, budgets, Agreement and funding, event and cost as a part of Project Accounting
• Involved in setting up punch out stores in I-Procurement
• Developed and customized various custom reports like PO Requisition Details Report, Open PO Report by Buyer, Open Receipts Report and PO Unsourced Requisitions Report in Reports 10g builder
• Customized the program PRC-Generate Cost Accounting Events for Oracle Projects Integration
• Customized the SLA Accounting Events Page with OAF personalization and Extensions
• Quote creation using Oracle Quoting module
• Selecting and Sizing customer flow meter products using a custom J2EE based web application called ‘GPSS’ deployed in Oracle APPS
• Configuring the selected product using Oracle Configurator

Environment: Oracle Applications 12.1.3, REVPRO, AP, AR, GL, SLA, OA Framework, Core Java and Web Services, JSP, Servlet

Confidential, NY

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Analysis of Oracle E-Business Suite 11.5.10 existing systems to assess the cost and effort required for the upgrade to Oracle E-Business Suite 12.1.3 system for OLM modules, iProcurement, ESS
• Did performance tuning of existing Oracle forms as well as created new Oracle forms using different built-in as well as User-defined functions and procedures.
• Responsible for gathering details of existing 11.5.10 systems from client
• Upgrade system in various instances by upgrading the custom forms, reports and custom pl/sql programs/processes.
• Involved in testing of the 11.5.10.2 upgrade system in various instances
• Preparation of the High Customization listing documents following HCLT processes
• Technical Assessment and Migration Plan
• Support for AP, AR, GL, FA modules
• Worked on solving the behavioral difference issues between 10g and 11g forms debugging the errors.
• Prepared the documentation of Forms and Reports.
• Resolving day to day issues based on tickets or calls
• Modified XML Publisher report for FA Asset listing Report (FA) to add few columns
• Developed Conversion program for Importing Purchase Order
• Worked on P2P Process
• Modified Custom Foreign tax, US Tax and Tax settlement program for inbound interface
• Logged, viewed, accessed, monitored, followed up, and closed Service Requests (SR) online - Oracle MetaLink
• Developed Technical Documents (MD70) for various RICE objects as per RICE (Reports, Interfaces, Conversions, Extensions, Forms and Workflow) components design
• Experience includes coding Interface Programs using PL/SQL procedures to load data into the interface tables from legacy systems
• Involved in uploading historical GL Balances through conversion program for various entities
• Worked on SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the intermediate tables
• The PO approval hierarchy assignment as well as providing hierarchy details as per client request
• Provided report that would show the remaining quantity details as of date for any PO.
• Changed the existing forms and reports of customized Accounts Receivables.
• Design customizations to import invoices and customers into Accounts Receivable, receipts into Accounts Receivables
• Analyze the various project requirements and transferring the knowledge to offshore team. Identifying and developing the reusable modules and templates, this will help in improving the productivity of the team
• New Supplier creation and assigning bank to the corresponding supplier at site level.
• Automation process for supplier Invoice upload
• Customized oracle standard cheque print report to print cheque as per Indian rupee format and fields included as per client requirement Receivables
• Bill Run process
• Journal import and AR Period closure
• Automated the process for assigning sales person to the corresponding customer site level
• Monitoring and support of daily run customer interface.

Environment: Oracle applicationsR11, R12, Finance modules (GL, AP, AR, CM, FA, PO, INV, OM), Goal Management, Performance Management, Compensation Workbench, JDeveloper, Install Base (IB), Service Contracts (SC), Field Services (FS), Oracle Quoting and Inventory (INV) modules and uploading the data to Accounts Receivables (AR), Order Management (OM).

Confidential, Charlotte, NC

Oracle Applications Technical consultant

Responsibilities:

• Involved in building interfaces between Oracle Accounts Payables (AP), order management (OM), Purchasing (PO), Accounts Receivables (AR) and Third party systems and provided functional input
• Design and Developed OM Sales Order Interface to bring in Sales orders on a regular basis from the legacy system.
• Designed, documented and developed staging tables, conversion routines, Custom PL/SQL API’s for converting Inventory Items, AR Invoices and Receipts, Customers using TCA, Open Purchase Orders, Open Requisitions, AP Open Invoices, Suppliers, Supplier Sites, and Supplier Contacts from legacy system to Oracle Applications
• Worked on Order Import to convert all open orders from Legacy to Oracle
• Worked on customization on Receivable interface as per the client requirement to split the freight lines into multiple freight lines
• Setup Tax Codes, Expenditure Type, Payable Options, Payables/ Purchasing Lookups, Signing Limits, Employee as Suppliers, Expense Report templates, Payment terms, Banks, Bank Accounts, Payables Payment Documents, Automatic Payment Programs, Payment Formats, Flex Fields
• Customized Sales Order form and was also involved in developing new form to display Delivery Information in Oracle Order Management
• Worked on iPayments and developed an interface from AP to bank to transmit payment file for various payments
• Designed and developed process to calculate Average cost per sub-inventory and update the information on transactions
• Customized many reports like Pick Slip, packing Slip, Mailing Label for shipping and Credit Order Detail, Orders by Item, Order Detail & Summary Reports, Payments Overdue Report, Orders for Suspense Account, and Sales Quote for Order Management and Credit memo Account verification report, AR Revenue extract report for AR and also created new reports as per client requests.
• Imported Bills and Routings through BOM Interfaces.
• Developed Work Order Interface to import discrete job information into oracle apps base tables.
• Involved in generation of FSG reports according to the client requirement and consolidated automated financial statements using Financial Statement Generator (FSG).
• Developed AP Invoice Conversion and vendors conversion programs.
• Developed custom workflows for tracking service requests, and notifying users about the status of these service requests.
• Designed and developed adhoc Discoverer reports

Environment: Oracle Applications Release R12 / 11i / 11.5.10, FA, AP, PO, GL, Oracle 10g, SQL, SQL*PLUS, SQL*Loader, UTL Scripts, TOAD, PL/SQL, Shell Scripting, SDLC Source Control, Discoverer10g.

Confidential, New York

Oracle Applications Technical consultant

Responsibilities:

• Business Process and User Requirement analysis and preparation of specification document.
• Mapping the requirements in financials
• Defining Suppliers, Supplier Sites, Supplier Bank Account Assignment, Payables Batch Source, Payment Terms and distribution Sets
• Defining Journal Sources, Categories and Document Sequences for each journal Category. Defining Security Rules, Cross-validation rules, Account-Combinations
• Involved with cycles like Procure to Pay (P2P) and Order to Cash (O2C) functionally and then technically
• Review/Create/Modify the Reports RDF and Forms in Oracle 10g.
• Unit Test Cases for Testing of above modules and moving the same to production environment
• Involved in managing concurrent programs, application user setup, defining responsibilities, registering forms and reports.
• Involved in designingof required end user formsusing Oracle forms 10g.
• Creating Users, various Responsibilities and assigned to respective users, created Menus, Request Groups, Data-Groups, and Request-set. Also created Value-set, DFF’s and changing Profile Option as per requirement
• Resolving the issues on PO components like Requisitions, Purchase Orders and Receiving
• Similarly, resolving the issues on AP components like Invoices, Payments, and Banks & Suppliers
• Month end Closing Process (P2P Cycle)
• Defined Editors, Created List of Values and Record Groups in Oracle Forms 10g.
• Involved with developing Items data migration, AR Invoices and AP invoices data migration and Lot Migration
• Worked on Item Interface with assigning Item categories, On-Hand Quantity Conversions, PO Requisitions Inbound Interface, Purchase Order Inbound Interface, Customer Interface, AP Invoice Interface, GL Journal Import Interface and Supplier, sites and supplier contacts conversion
• Created numerous web based Forms and Reports using Oracle Developer 10g.
• Customized sales order form to book an order only on weekdays and Customized PO form to do not generate a PO if the price is less than some amount
• Customized Workflow to apply the holds whenever order is booked for particular customer and Customized Workflow to send the notification whenever order is booked for particular customer. Customized AP Remittance workflow in Payables
• Involved with Unit testing and system integration testing during testing phase. Followed AIM methodology to build TE20, TE40, CV 60, MD120, MD 70 documents.

Environment: Oracle Applications Financial Suite R11.5.10 (AP, GL, AR, OM, PO, INV, HR, CM), Oracle database 10g. XML Publisher, Discoverer Reports, Oracle Alerts and UNIX

Confidential

Oracle Applications Technical consultant

Responsibilities:

• Involved in handling various assignments in development/maintenance/support role in an Oracle Financials 11i implementation
• Involved in transferring the Suppliers, Products & Services, Business Classifications and Supplier Users in to the Production instance
• Involved in migrating the data from the legacy systems to oracle for Parties, Customers, AP Invoices, AR Invoices, Install Base, OKS Contracts, Purchase Orders, GL Periods, Quotes, Projects, Items and Bill of Materials
• Developed custom workflows in different modules like PO approval, AP Invoices
• Developed a report for MHM Commission Approval for sales representatives
• Setting up employees and roles in the Oracle Self Service module
• Created interfaces for BOM, Routing, WIP and Items
• Involved in functional setups of OM,PO, PA, INV, BOM, WIP and Routing
• Analyzed and Designed the DB schema using Oracle 9i database to include Header, Lines and other table in all the modules
• Creating Forms and Reports to accommodate the business functionality of the MHM
• Prepare high level design documents, DLD and User manuals
• Developed the custom programs for the below conversions.
• OM Item Substitution Conversion
• OM Item Conditioning Conversion
• Developed RMA Receipt Report using Reports 10g.
• Composing and testing the business rules for the components designed
• Involved in the personal and technical training activities
• Personalization of components using Oracle Forms Personalization and OAF
• Provided support for conversions Customers, AR Invoices, Vendors, Items, Categories, Purchase Orders, Requisitions, iSupplier User, Supplier Products & Services, GL Account details, GL Budget details and interfaces ACH Payments, UMS, Maximus, CIS/Enquesta, Lockbox in different instances like CRP5, SIT, UAT and Production
• Developed and Customized Customer Statement Printing, Dunning Letter Printing using XML Publisher
• Involved in various activities like Technical Design, Unit Test Design, Development, Testing and Release Pack and participated in Code walkthrough sessions, also involved in reviewing the technical Design Documents, Test Cases, Build and Release Pack reviews. And also involved in coordinating with offshore team in daily status calls
• Involved in supporting the delivered conversions and Interface objects. Involved in meetings with users and onsite team
• Involved in importing Open PO Closed Invoices and Payments from the legacy system to Oracle Payables system. Open PO Closed Invoices Conversion is the process to create Invoices (matched to open POs) and related Payments for imported invoices
• Developed various outbound interfaces for HRMS Module like AFLAC and CIGNA
• Involved in importing Invoices from legacy system UMS to 11.5.10 Oracle Payables system using Payables Open Interface import Program

Environment: Oracle Database 8i, Oracle Forms and Reports and XML Publisher, OAF, Java, JSP, XML, XSL, OAS, Oracle 10g, Oracle AQ, Workflow Builder, TOAD. SQL, PL/SQL, Reports 6i, TOAD, SQL*LOADER, Designer 2000.

Confidential

Oracle Applications Technical consultant

Responsibilities:

• Design and develop various RICE (Reports, Interfaces, Conversions, Extensions, Forms and Workflow) components part of critical Oracle iProcurement Implementation
• Development of Oracle SOAP API for validating the external data from a web service
• Involved various other customizations using PLSQL, forms, reports development which are part of Direct Fulfillment.
• Created Custom solutions around the Receiving Interface and Requisitions of the iProcurement Implementation using Oracle Application Framework
• Developed BI/XML publisher reports/XML Reporting in DF & Purchasing Modules
• Application maintenance. Provided fixes to production issues under support
• Conversion of existing Forms 5 to Forms 6i and Reports to Reports 6i.
• Analyzed and Designed the DB schema using Oracle database to include Header, Lines and Approvers table in all the modules Inventory, Order Management and Purchasing
• Creating the Return Orders and validating the data for testing purposed in OM
• Design of the components with help of MD 70 design document
• Design and Develop the complex SQL Queries, Reports, Oracle & Java API’s
• Designed the forms for front end interface for the users using Forms 6i.
• Developed ADHOC Queries and Reports for Users to check status at various levels
• Interacting with the business team to provide the best possible technical solution
• Providing Unit Test Results for the components designed and developed

Environment: Oracle E-Business Suite R11i (11.5.10), Solaris OS(Unix based), Windows XP, PL/SQL, SHELL SCRIPT, Java/J2ee, Oracle 6i Forms and Reports, Oracle Discoverer, Oracle 9i, Workflow Builder, TOAD, Oracle Application Framework, Oracle Application Server, Oracle 11i Quoting Module.