Summary

• A distinguished IT professional with more than 8 years of Professional experience on Oracle Applications as a Techno-Functional consultant in Oracle ERP Application R12, 11i
• Worked on System Study, Design, Development, and Post implementation maintenance and support of Oracle Applications E-Business Suite.
• Oracle Apps Techno Functional Consultant with experience MFG, SCM and PO modules.
• Expert-level Supply Chain professional experience in, Leadership, Information Technology, Consulting, Strategic Problem Solving, Financial, Cost Management and Change Management.
• Trusted project management leader skilled with a reputation for flawless execution of large ERP/SAP and supply chain projects.
• Trained financial development and cost analysis director with demonstrated proficiency working with Fortune 500 clients.
• Supply chain authority who improves business functionality with comprehensive analysis, development, design, and oversight of business tools that increase operations success.
• Outstanding Functional/Technical knowledge in Oracle Applications Oracle Financials like GL-General Ledger, AP-Accounts Payables, AR-Accounts Receivables ,FA-Fixed Assets, CM-Cash Management ,
• PO-Oracle Purchasing, OM Order Management/Advanced Pricing , Supply Chain Management SCM Manufacturing INV-Inventory, WIP-Work in Progress, BOM-Bills of Materials ,Install Base, Service Contracts ,iExpenses , iProcurement and AOL Application Object Library .
• Main focus on Implementation, Upgrade, Support and tuning of Oracle Financials, Oracle Manufacturing and Oracle Purchasing, Order Management and Supply Chain modules.
• Experienced in ERP Applications Client Server Technologies, along with Development, Testing, Support, Upgrade and Tuning of Oracle Financials, Oracle Manufacturing, Oracle Purchasing, Order Management and Sales.
• Experience in all phases of the Software Development Life Cycle SDLC in an ERP environment.
• Strong implementation knowledge of O2C Order to Cash , P2P Procure to Pay and Drop Ship end to end Cycles.
• Excellent skills in SQL, PL/SQL, Developer 6i/2000 Oracle Forms and Reports , Discoverer Reports
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Designed Reports based upon specifications and also determined reporting needs based upon specifications.
• Hands on experience in implementing RICE Oracle Reports 6i/Forms 6i, Interfaces, Conversions, Extensions components, workflows, Oracle Alerts, Lookups, OA Framework OAF , XML Publisher Reports.
• Extensive experience in design, development, customization and implementation of various business applications in different platforms using Client-Server Technologies.
• Created a lot of Complex, Optimized data queries and performed constant QA checks.
• Hands on experience in using various Oracle technologies to effectively implement an end-to-end solution to an organization's strategic goals and objectives including: Oracle 11i E-Business Suite, Oracle Discoverer, Oracle Application Server and Oracle PL/SQL and SQL and Oracle RDBMS, Oracle Developer Oracle Forms and Reports Developer
• Possess good expertise in developing programs using SQL loader, Toad and PL/SQL procedures to transfer data from legacy systems with knowledge in Unix Shell Scripting.
• Perform and maintain logs to track reporting activities.
• Good Knowledge of Multi organization Access control MOAC architecture and understanding of MOAC Impact on custom programs development like report, forms, and workflow PL/SQL packages.
• Experience in development of concurrent programs, customization and modifications of reports.
• Extensive experience in designing, developing and testing the RICE components Reports, Interfaces, Conversions, Extensions as per Oracle Standards.
• Possess good project management skills and also have lead in many projects.
• Strong familiarity with AIM methodology in creating BRD, MD-50, MD-70, MD-120 and also testing documents throughout multiple Projects.
• Knowledge and Experience of TCA Trading Community Architecture .
• Expertise in developing custom reports in XML Publisher.
• Demonstrated ability to identify root causes/ debugging of problems and troubleshoot, considering both long and short-term impact of proposed solutions and developed workable solutions
• Onsite coordination experience and work with the offshore team to knowledge transfer and development support.
• An Excellent Team Player with good problem solving approach having strong communication, leadership skills and ability to work in a time-constrained and team-oriented environment.
• Extensive Functional Technical skills in the area of Business User Interaction, System Requirement gathering, Application Development, Customizations and Implementation of software applications in client-server, database and enterprise software environments.
• Provided insights to the Enterprise Architect regarding supporting a data warehouse and structuring a team around it, including roles and responsibilities, a governance model, relationships to other initiatives and groups such as a sector Information Technology solution.

Technical Skills

• ERP : Oracle E-Business Suite: Versions 12i/11.5.10/11.0.3
• Modules : Order Management OM , Inventory INV , Bills Of Materials BOM , Account Receivables AR ,Purchase Order PO ,Fixed Assets FA , Account Payables AP ,General Ledger GL , Cash Management CM , Application Object Library AOL , Work In Process WIP , Material Resource Planning MRP , Flex fields, TCA, CRM, Service Contracts, Service Fields, SYSADMIN, INSTALLBASE
• Tools : Toad, SQL Loader, PL/SQL Developer, Discoverer,
• Data Loader, BI/XML Publisher, Load Runner
• GUI : Developer 6i, Developer 2000, Forms 6i/10g, Reports 6i/10g
• Programming Languages: SQL, PL/SQL, C, C , Java, HTML5, PHP, UNIX Shell Scripting
• Database : Oracle 9i/10g/11g, Microsoft SQL Server 2010, MS Access
• Operating Systems: Windows 98/2000/NT/XP/7/8,UNIX Solaris, HP-UX , Linux.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Consultant

Responsibilities:

• Worked on various financial modules AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables .
• Worked as an Technical and Oracle Applications Techno-Functional Consultant
• Develop AP/AR/GL/PO reports using discoverer which include the following
• PO requisition reports,
• AR sales profit report with cost of goods,
• GL Summary Report.
• Loaded the vendor's information from the legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.
• Techno-functional analyst for reporting and interfaces of Oracle EBS in OM, AR and AP modules.
• Developed, documented and implemented automated marketing processes within CRM.
• Developed Custom OAF Screens to create, update and delete records in OLFM module.
• In XML/BI Publisher created a data definition from generated XML.
• As per the company requirements, created and implemented XML/BI Publisher reports for different products like PO, AP and GL.
• Imported new, changed and completed sales orders from legacy system to oracle using order import order management open interface .
• Customized MODULES AP, AR GL, FA in Multi Org environment.
• Developed/Converted most of the existing text reports to excel format using XML/BI Publisher
• Assist in troubleshooting production support issues relating to Receivables invoicing and Vertex Geo Coding and Tax Reporting.
• Migrated AP Invoice interface to load data from legacy system to AP interface tables.
• Migrated custom interfaces on the Oracle AR and Oracle AP from oracle 11i to R12.
• Developed reports to handle multi-currency exchange gain and losses.
• Worked with AP Team to reconcile AP with General Ledger by running Accounts Payable Trail Balance report, Posted invoice register report, posted payment register report and Unaccounted Transaction report.
• Imported Open Payables Invoices from legacy system into Oracle AP using Ap-Invoices-Interface and Ap-Invoice-Lines-Interface tables.
• Worked on the Budget Upload Open Interface to load the data from legacy systems to the
• GL-Budget-Interface table using SQL Loader.
• Worked on Oracle Application Framework OAF to develop custom solutions for iExpense and iProcurement module. Development involves analyzing MD50 Functional Spec and then writing MD70 Technical Spec .
• Worked on rounding customizations using OAF. This involves customizing and extending controller CO and entity object EO.
• Worked on Oracle Order Import API to validate and load the PO information to the interface tables.
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level
• Set-up of invoices, debit and credit memos, guarantees, transaction types
• Created updating adjustment of invoices, debit memos, credit memos
• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components.
• Implemented Auto Lock Box by importing data into staging table by writing control file according to bank transmission format.
• Imported Invoices using Auto-invoice program and applied receipts using Auto-Lock Box
• Modified custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Developed Business Areas, Custom folders, Item classes, Hierarchies in Discoverer Administration Edition
• Modified Workbooks based on the Custom Folders with parameters, cascading parameters, conditions, calculations using Discoverer Plus and Discoverer Desktop.
• Involved in Performance tuning of the discoverer reports.
• Customized the existing workflow by adding notifications at the time of Purchase Order approval and also involved in customizing Requisition package in iProcurement modules as client requirements
• Development/modification of custom reports in purchasing and payables.
• Developed PL/SQL procedures to validate the data and insert the validate data into Oracle Standard interface tables.

Environment: Oracle Applications R12/11.5.10, Reports 6i/10g, SQL, PL/SQL of Oracle 9i/10g, PL/SQL on UNIX, Windows 2000/NT environment, Java, JSP, Forms 6i/10g, Discoverer10g, XML/BI Publisher, SCM, Toad, SQL Loader.

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Developed PL/SQL procedures, functions and packages for validating the invoice data before importing it into Account Receivables interface tables.
• Worked on journal import interface program to import journal data from legacy system into GL base tables.
• Estimated work effort for application configuration based on CRM applications.
• Worked with GL tables, AR Interface, Customer Interface and GL interface GL INTERFACE, GL BUDGET INTERFACE .
• Worked on Auto Lockbox Open interface for automatic processing of receipts in AR module.
• Migrated an Item Conversion to import legacy inventory item data into Oracle base tables.
• Involved in Open Transaction Interface to import transactions from legacy system to Oracle Inventory and set up Transaction Manager as background program to import validated data from interface table periodically.
• Financial products, Stream Generation Templates and Accounting templates are basic financial setups of OLFM.
• Integrated and implemented Vertex, which auto calculates and applies state and local taxes on taxable items and provides reports.
• Used SQL Loader and UTL FILE packages for data conversion and interfaces.
• Customized the reports for Financial Module GL, AP, and AR using Report Builder.
• Involved in Requirement Analysis, Design and Develop custom applications in OAF. This involves analyzing MD50 Functional Spec and then writing MD70 Technical Spec
• Migrated Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports from 11i to R12.
• Responsible for the implementation of Oracle Order Management / Quoting with Configurator, CDL and Configurator Extensions, BOM, WIP, Inventory, Shipping, Advanced Pricing, Installed Based and Advanced Supply Chain Planning with Global Order Promising for a manufacturing company with different business units.
• Developed an interface for monthly import of journal entries from payroll running on a legacy system by using the journal import interface provided by Oracle General Ledger.
• Registered customized reports and concurrent program/sets using System Administrator and Application Developer responsibilities.
• Worked on performance tuning of existing reports and PL/SQL programs.
• Developed customized reports using XML Publisher Discoverer.
• Worked on Oracle Discoverer Admin for creating item classes, custom folders and parameterized reports for OM, AR, AP and PO modules.
• Developed Auto Invoice Master Program to Import Customer invoices ,Credit memos and Debit memos
• Setup transaction types, invoices, guarantees, deposit, and credit memos, debit memos
• Worked on discoverer desktop for creating various workbooks based on custom folders.
• Customized Oracle standard reports like AP and AR Aging Reports, Open PO report and changed the output format to XML and created new templates for XML Publisher to display in pdf or excel format.
• Converted custom forms using Forms 6i in Installed base for global update of instance.
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle
• Form Builder 6i.
• Contributed to the project planning, staffing and budgeting activities for a new Primary Insurance Data Warehouse build out in SAP-BW. Participated as the Business Information Architect and managed the Technical Business Specialists for the program. Developed a DW Strategy document. Participated in the evaluation of reporting functionality between SAP BW 3.5 and SAP BI 7 toward making a recommendation on the timing for upgrading.
• Build-out of Architecture and Governance s future state data landscape of Operational Data Stores and a Data Warehouse to provide consistent, high quality data for reporting and downstream applications.
• Customized sales order form using Form personalization.
• Gathered requirements, wrote functional MD050 and technical MD070 specifications, provided recommendations for user concerns and implement process and system modification.

Environment: Oracle Apps 11.5.8/10.2, GL, AP, AR, PO, OM, Oracle 9i, Pl/SQL, SQL Plus, SQL Loader, Reports 6i, Forms 6i, XML Publisher, Warehouse Management, Discoverer, Java, AWS, REStFul, Oracle Configurator, Shell Scripting, TOAD, PVCS, UNIX.

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Worked as an Technical and Oracle Applications Techno-Functional Consultant
• Worked on various financial modules AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables .
• R12 Oracle Configurator, CDL and Configurator extensions, Quote / Order to Cash Order Management, Oracle Advanced Pricing, Inventory, Bills of Material, Installed Base and PLM Advanced Product Catalog for a major Payroll and Benefit processing provider with MACD / TSO solution.
• Multi-site or global implementations of Oracle EBS Applications bull Ideally experience with Oracle Lease and Financial Management OLFM implementations support
• Worked with form personalization for customizing Oracle forms.
• Develop AP/AR/GL/PO reports using discoverer which include the following
• PO requisition reports, AR sales profit report with cost of goods, GL Summary Report.
• Developed Documentation Templates such as Data Mapping, Functional, Technical and Testing like CV60, MD70 using AIM.
• Techno-functional analyst for reporting and interfaces of Oracle EBS in Service Contracts, AR and AP modules
• 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.
• Techno-functional analyst for reporting and interfaces of Oracle EBS in integration with GL, AR, AP and PO, iProcurement modules.
• Strong Vertex functional technical experience
• Lead offshore team in developing Item Conversion program to import Items from custom applications at terminated manufacturing plants.
• As a Sr. Oracle Techno Functional consultant responsible for Enhancements and Production support of RICE components in GL, SLA, AP, PO and AR with BI / XML Publisher Reports.
• Customization of PO Approval workflow process to ensure the notification is send to next in hierarchy if the first approver doesn't respond using workflow builder and also to stop sending emails upon update of PO for second time onwards.
• Developing PL/SQL code to obtain the required functionality.
• Changed the existing forms and reports of customized Accounts Receivables.
• Troubleshooting of the Order Management OM and Inventory INV modules within Oracle Applications.
• Tuned customized application including reports and back end programs by using different application tuning techniques.
• Worked on complete Software development Lifecycle SDLC, from gathering requirements to deployment .
• Interfaced legacy system GL data using Journal Import. Run Journal Import to load data into GL JE BATCHES, GL JE HEADERS and GL JE LINES tables.
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts.

Environment: Oracle Applications 11i, GL, AR, AP, PO, Reports 6i, PL/SQL, SQL Loader, SQL Plus, TOAD, Discoverer, SOA, UNIX, JDeveloper, Shell scripts

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Worked as an Technical and Oracle Applications Techno-Functional Consultant
• Worked with the functional team while extracting non-Oracle data and Converting to Oracle with validations.
• Designed Developed AP Invoice Open Interface and AP Invoice Audit Report for the different Sources in Oracle Payables.
• Work with functional setups to create AP invoice sources, Accounting flex field, Chart of accounts.
• In-Depth understanding on how Vertex operates and Sales Tax space as well as Order to Cash and or Purchase to Pay concepts
• Implementation and Customization of MODULES AP, AR GL, FA in Multi Org environment.
• Responsible for creation of MD070s for AP Invoice import.
• Customized and developed various reports to user community for day to day operational support in Receivables, General Ledger, Purchasing and Payables and Fixed Assets Module.
• Responsibilities included technical design, development and support for Order to Cash and Procure to Pay business processes.
• Developed a custom layout XML format according to the user specifications and worked on incorporating it to the standard print Purchase Order and Invoice reports using XML Publisher BI Publisher .
• Developed conversion program for validating and importing Open AR Transactions Invoices from legacy system to Oracle interface tables. Used Auto invoice Master Program to load the interface table data into Oracle AR base tables.
• Created new custom reports in XML/BI Publisher and used Template, sub Template method for a creating single report with multiple Layouts
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level
• Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Worked with the GL Journal Import, AP Invoices, AR Invoices, Item conversions
• Developed custom forms and reports to correct interface errors and send the error messages to legacy system owners.
• Using SQL Loader loaded the data into staging table, Developed PL/SQL packages to validate the data and load into interface tables.
• Involved in the development of TCA Model.
• Involved in Developed Advanced Shipment Notice ASN process and printing.
• Designed and Developed the Commission payments project, which loads the all rep groups and percentages information to the custom tables.
• Involved in migrating developed objects between instances. Developed custom shell scripts to create synonyms and grant necessary permissions for the objects which are being migrated into new instances.
• Developed an outbound interface to export GL data to third party systems, also inbound interfaces to import into GL by populating GL Interface Table.
• Extensively involved in developing Technical Design Documents MD70 using Application Implementation Methodology AIM .
• Developed new and customized existing Oracle and Discoverer reports as per the user request.
• Involved in testing existing FSG reports.
• Developed AIM Documentations for the components.
• Involved in Peer review and Unit testing.
• Involved in resolving daily business issues in Quick time.

Environment: Oracle Apps 11.5.8, Procure-2-Pay, Oracle 10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, AP, GL, PO, AR, OM, INV, TCA, JDeveloper, TOAD, Discoverer, XML Publisher, SQL Developer, Forms 6i , UNIX, Shell Scripting, WINDOWS XP.

Confidential

Oracle Applications Techno-Functional consultant

Responsibilities:

• Actively involved in full implementation of E-business suit including gathering the requirements from the user and understanding their business model.
• Worked as an Technical and Oracle Applications Techno-Functional Consultant
• Worked on various financial modules AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables .
• Worked in getting the requirements from the users and involved in functional setups in financial modules.
• Defined the descriptive flex fields on Sales orders and Invoices to facilitate additional information.
• Support the users when loading AP Invoice and other payment activities like printing payment registers and checks.
• Develop AP/AR/GL/PO reports using discoverer which include the following
• PO requisition reports,
• AR sales profit report with cost of goods,
• GL Summary Report.
• Customized seeded reports as per the requirement like Customized the standard Purchase Requisition Status report in purchasing and scheduled payment report.
• Created new reports and Customized standard reports in PO such as Expected Receipts Report, Printed Requisitions Report and Purchase Order Detail Report.
• Developed Documentation Templates such as Data Mapping, Functional, Technical and Testing like CV60, MD70 using AIM.
• As a Techno Functional consultant, Played a key role in upgrading oracle 11.5.7 to R12 for P2P and O2C Tracks
• Involved in generation of FSG reports according to the client requirement and consolidated automated financial statements using Financial Statement Generator FSG .
• Involved in writing interface program to load the data from external systems into Oracle purchasing PO interface tables.
• Developed AP Invoice Conversion and vendors conversion programs.
• Customization of PO Approval workflow process to ensure the notification is send to next in hierarchy if the first approver doesn't respond using workflow builder and also to stop sending emails upon update of PO for second time onwards.
• Tuned customized application including reports and back end programs by using different application tuning techniques.
• Customized the PO entry form to ensure Revision field is not null when item is entered.
• Defined request sets with concurrent programs to run in stages depending on the output generated by each request.
• Developed Interfaces for Oracle Applications modules, XML Publisher, Oracle Discoverer, OA Frame work etc in co-ordination with the functional consultants.
• Worked on items in Inventory.
• Imported Bills and Routings through BOM Interfaces.
• Developed Work Order Interface to import discrete job information into oracle apps base tables.
• Developed PL/SQL Packages, Procedures and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables.
• Developed custom workflows for tracking service requests, and notifying users about the status of these service requests.
• Developed custom reports in GL: Journal Batch Summary Report, Account Analysis Report and AP: Invoice on Hold Report, Supplier Paid Invoice History Report etc.

Environment: Oracle Applications 11i, GL, AR, AP, PO, Reports 6i, PL/SQL, SQL Loader, SQL Plus, TOAD, UNIX, Shell scripts.

Confidential

Oracle Applications Techno-Functional consultant

Responsibilities:

• Involved in the complete Order to Cash, Procure to pay cycle, Oracle Grants and Projects implementation.
• Worked as an Technical and Oracle Applications Techno-Functional Consultant
• Developed Auto Invoice Interface program to import invoices from legacy systems to Oracle Receivables.
• Used SQL Loader for import into custom tables and PL/SQL for complete validation of data and inserting into interface tables.
• As a Techno functional Consultant, responsible for Analysis, design, development, testing and implementation of customized Oracle ERP solutions for new implementations and upgrades
• Preparation of SQL Loader Control Program and PL/SQL script with validation to upload data from flat file to oracle Applications base tables.
• Configured, tested and built all the financials modules AP, AR, CE, GL and assisted in the Oracle Projects setup.
• Development of GL Daily Rates Inbound Interface to upload data from flat file to Oracle Applications base tables.
• Created CUSTOM JAVA TOP on server for customized OAF pages.
• Created new OAF pages which includes custom simple search, advanced search, PPR partial page rendering select option, committing data through EO Entity Objects .
• Developed new Custom Oracle 6i, SQL, PL/SQL Reports as per the business requirement.
• Customized of AP invoice aging report as per client requirement.
• Preparing the MD070 Documents based on MD050 for each component.
• Developing Custom Interface Programs and XML Publisher reports.
• Extensively utilized the application object library to register SQL LOADER programs, PL/SQL procedures, forms and reports.
• Developed reports for Order management, BOM modules.
• Development and customization of reports.
• Integration Objects Cross checking with Account Payable, Account Receivables General Ledger Modules.
• Create and define template and data definitions for Open Purchase Order report. Conditionally display company logo information based on run time parameters.

Environment: Oracle Applications 11i OM, PO, FA, GL, GA, AP, AR , Workflow Builder, SQL Loader, PL/SQL, Developer 2000/6i, JDeveloper, XML Publisher, TOAD.