SUMMARY

• Highly experienced Techno - Functional consultant with 8+ years of experience in Oracle E - Business Suite of Applications.
• Advanced Knowledge in Oracle Applications R12/11i, across Discrete and Financial modules like Order Management (OM), Inventory (INV), BOM, Purchasing (PO), Cash Management (CE), General Ledger (GL), Account Payables (AP), Account Receivables (AR) and Fixed Assets (FA).
• Extensively worked on Techno-functional responsibilities include interfacing with users, identifying functional and technical gaps, estimates, designing custom solutions, development, leading developers, producing documentation, and production support.
• Expertise in implementing RICEW components (Reports, Interfaces, Conversions, Extensions and Workflows) in areas of design, development, Integration and deployment.
• Effectively communicated to understand client’s requirements of the business and prepared BRD and Functional documents.
• Expertise in implementing Order to Cash (O2C) and Procure to Pay (P2P) business process flows.
• Extensively worked onOracle Discovererincluding report developments, administration, configuring and End User Layer (EUL)
• Effectively conductedrequirement gathering, fit/gap analysis, process mapping and user training.
• Expertise in using Application Program Interfaces (API) to create Inbound/Outbound interfaces and automated processes.
• Extensive working experience in Reports development using XML Publisher, Oracle Discoverer, Oracle Reports, EIS Reporting, OBIEE and Hyperion Reporting.
• Involved in Global implementations and worked with large group of business users and Onsite & Offshore model projects.
• Proficient in using Multiple Reporting Currencies (MRC) and Multi Org feature and implemented them in interfaces, Oracle reports and custom processes.
• Extensive experience in using PL/SQL and create backend objects like Database Triggers, Stored Procedures, Functions, collections, records, views and Packages.
• Developed and customized various Forms using Oracle Forms Builder. Extensively worked on CUSTOM.PLL and forms Personalization.
• Good Experience in System Administration and AOL activities like Defining Responsibilities, Values sets, Registering menus, Reports, Concurrent programs, request sets, flex-fields, Profile options etc.,
• Extensive development of Custom Oracle Reports from scratch with and without BI Publisher tool.
• Proficient with Oracle Discoverer and its components including Discoverer Administrator, Desktop and Plus.
• Expert experience in using Application Object Library (AOL) to define value sets.
• Effectively created and maintained database like Tables, Views, Indexes, Sequences, Database links, Roles and privileges.
• Proficient in using AIM methodology and created documents such as MD -50, MD-70 and MD-120.
• Conducted CRP sessions with stake holders and super users for the business to enhance productivity.
• Implemented various i-modules including iSupplier, iProcurement, iExpenses and iReceivables.
• Collaborated with Users to analyze current processes and partnered with Developers, DBA and Analysts to design and implement new features that increased efficiency.
• Good experience in SQL*Loader and UTL FILE for uploading flat file data into Staging Tables, preparing the test and data migration documents
• Well versed with FNDLOAD utility to migrate concurrent programs, request sets, value sets and other AOL Objects between various application instances.
• Resolved various performance related issues on Oracle Forms, PLSQL Interface processes and Reports by using tuning techniques like Indexing, Partitioning, Hints and TKPROF.
• Worked very closely with Oracle Support for resolving various Service Requests raised and different Severity levels and provided 24/7 support as of when required.
• Well versed with client-server environment and tools like SQL *PLUS, SQL Developer 10g, SQL Loader, TOAD, Data Loader, Quality Center, SSH Client, Remedy, Kintana Tool, WINSCP, Putty, CMS,PANAYA, JIRA, VSS and others. .
• Experienced in communicating effectively with clients to handle business problems, and excellent Organizational skills.
• Self-motivated with solid management skills, capable of leading and motivating individuals and ability to effectively manage time and multiple projects.

TECHNICAL SKILLS

ERP Systems: Oracle Application R12 (12.2.4, 12.1.3, 12.0.6, 12.0.4), 11i (11.5.10.2, 11.5.9)

Databases: Oracle 9i/10g/11g, SQL Server 2003

Programming Languages: SQL, PL/SQL, HTML, XML, Java, UNIX Scripting, PERL Scripting

Operating Systems: HP UNIX, Windows XP/2007, Sun Solaris, AIX, Oracle Linux.

Development Tools: TOAD, SQL PLUS, SQL Developer.

Development Utilities: SQL*LOADER, UTL FILE, DBMS Utilities, Job Schedulers, FND LOAD

Reporting Tools: Reports Builder 6i/10g, Discoverer 4i/10g, XML/BI Publisher, OBIEE 10g

UI Tools: Forms Builder 6i/9i/10g, ADF, JDeveloper

Other Tools: Secure Shell, Putty, WinSCP, Workflow Builder, Kintana, AUTOSYS, ESP

Version Control Software: Rational Clear Case, VSS, PVCS

SR/ Ticketing systems: Smile, SYSAID, HP Quality Center, JIRA, PANAYA

PROFESSIONAL EXPERIENCE

Confidential, Billerica, MA

Sr. Oracle Oracle E-Business Suite Techno-Functional Analyst

Responsibilities:

• Authored various documentation including technical specifications (MD200) and Installation documents (MD120) for all the customizations.
• Conducted requirements walk through to understand requirements properly and for getting required clarifications. Preparing solution design documents based on system requirement documents
• Involved in developing various SQL, PLSQL and UNIX shell scripts for conversion programs and interfaces, developed custom oracle forms and reports, performed forms personalization, Customization of OAF pages based on the functional specifications provided.
• Developed and extended functionality of various RICEW components in modules like OM, INV, AR, AP, CM, GL and PO.
• Worked on various conversion programs including Supplier Master Data, Customer Meta Data, Items, Open Sales Orders, AP Invoices, Purchase Orders, price lists and On hand quantity Conversions
• Developed interface programs to load the data from external systems into Oracle purchasing (PO) and Payables Invoices tables.
• Wrote SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• Developed custom reports using Report 10g and XML Publisher. Customized various seeded reports to in corporate business functionality and generate spreadsheet outputs.
• Developed Operational Dashboards for business to view current health of the organizations.
• Designed and developed Custom Trial Balance reports to help Business cross validate converted Journals and Balances before and after data conversion.
• Provided post go-live support and involved in user training sessions.
• Personalized Invoices form in Accounts Payables (AP) and Transactions form in Account Receivables (AR) to restrict data access.
• Worked on code retrofitting for more than Fifty assigned objects (CEMLIS) as per panaya tool identified changes and suggested with the possible code retrofit options
• Updated production data from ERP to data warehouse tables by developing various packages and procedures.
• Involved in numerous cross-functional meetings for requirement gathering, design, development, Integration and unit testing of various RICE components.
• Created and modified PL/SQL API for creation of assets retirement and Mass additions in interface table in FA module.
• Extensively worked on conversion of PL/SQL and SQL *Plus programs for R12 compliance.
• Designed and developed Customer Invoice, Exception reports and Purchase Order Report using XML Publisher.
• Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures, forms and reports.
• Customized PO Account Generator Workflow and Requisition Account Generator Workflow for Generating Project Charge Account.
• Work with the users, BA team, DBAs closely on daily basis and communicating with the business team if any gaps and providing the solution as per the requirement before the delivery time lines.
• Participating in preparing the promotion documents for all assigned objects.

Environment: Oracle Applications R 12.2.4/11.5.10.2 (AP, GL, AR, PO, INV, OM, iExpenses, iProcurement), SQL, PL/SQL, Reports Builder 10g, Forms 10g, Windows 2007, XML/BI Publisher, SQL*Loader, TOAD, HP Quality Center, Winscp, Workflow Builder

Confidential, Port Huron, MI

Sr. Oracle Techno-Functional Consultant

Responsibilities:

• Involved in requirement gathering, fit/gap analysis, specification design, unit and integration testing, data conversion, development, documentation, user training, production support.
• Migrated GL and AP custom interfaces and reports from 11i to R12.
• Prepared various Functional (MD50) documents, Technical (MD70) design documents and Conversion Mapping Documents (CV40) as per customer requirements.
• Designed and developed several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development.
• Imported Legacy Journals data into GL using Journal import interface.
• Wrote PL/SQL packages for different validations, for processing data in order to create Valid POs and Receipts and for populating the PO interface tables and utilized import programs to populate the base tables.
• Created requisition to procure goods and service with supplier information, delivery instructions, multiple accounting distributions, and notes to buyers, approvers, and receivers.
• Worked on SQL* Loader to load all the data given in flat files with various special characters and comma delimiters.
• Involved in Identifying the customization objects in 11i and participating the Technical design and code development. Customizing the data tables and code retrofitting
• Developed new reports using Report Builder and also customized seeded reports in purchasing (PO) module.
• Created and implemented new and custom XML/BI Publisher reports for modules like PO, AP and GL.
• Modified forms to define Profile Options, Descriptive and Key Flex fields.
• Configured business applications to support business requirements.
• Created Concurrent Programs, Executables, Request sets, Users, and Responsibilities.
• Developed Workflow to send notification to the business users and custom program to utilize EMM utility to page the support group.
• Resolved the defects which are raised by testing team in quality center tool
• Involved in preparing test plan and test cases for unit testing and system integration testing
• Defined value sets, flex fields, registering menus, forms, reports, concurrent programs, and providing support to apps user for any technical issues
• Created UNIX shell scripts and CRON jobs to automate interface programs on daily basis.
• Writing scripts to automate reports to run in batch for given time period.
• Interacted with end users to gather requirements and Draft specifications during development Phase.
• Developed Custom Interface Program for Creation of AR cash receipts in AR modules using standard API.
• Developed validation program to load currency rates data into interface tables and run the standard program to Load foreign currency rates into GL.
• Created Data Definition and Data template using XML publisher and attached data definition to data template.
• Developed an interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.
• Created custom program to create AP invoices for employee PCARD transactions and recorded those transactions into AP module.
• Customized standard Positive Pay payment process and created e-Text outbound template and Payment format and attached Positive pay payment format to check printing Payment Process Profile.
• Involved in customization of several standard reports to serve important business processes very specific to the client.
• Developed complex Discoverer reports by understanding client business requirements.

Environment: Oracle Applications R 12.1.3/11.5.10 , Reports 6i/10g, SQL, PL/SQL Developer, Forms 6i/10g, XML/BI Publisher, SQL*Loader, TOAD, Discoverer 10g

Confidential, San Francisco, CA

Sr. Oracle Applications EBS Consultant

Responsibilities:

• Provided design, support and customizations for Oracle iProcurement, Purchase Order, AP and GL modules to meet client requirements.
• Created Custom, Simple, Complex folders, Business Areas, workbooks and assigned privileges and registered the reports on Oracle Applications.
• Customized workbooks by adding additional functionality (conditions, calculations, parameters, sorting) and scheduling them for the users.
• Written shell script to move CSV file from shared drive to server and then load them in to the temp tables using SQL LOADER.Modified Procedures and Packaged according to new Oracle standard tables in R12.1.3.
• Developed custom interface program for automation of Items into inventory.
• Effectively worked on approvals and configured AME (Approval Management Engine) for Requisition and Purchase Order Approvals.
• Defined and Customized iProcurement and Purchasing related Responsibilities, Functions, Menus and Sub-Menus as per BRD documents.
• Created Document Workflow for Requisition to PO Autocreate process and Account Generator as per business requirements.
• Provided support on purchasing issues like PO’s stuck in workflows & maintenance of purchasing hierarchies.
• Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL*Loader and did all the necessary validations before loading into AP INVOICES INTERFACE, AP INVOICE LINES INTERFACE tables and Calling Payable Import Program
• Worked on interface tables of purchasing to update purchase order line details and wrote PL/SQL codes to validate data and used concurrent program to load the data into base tables.
• Developed custom reports AR RECEIPT REPORT, AP PETTY CASH EXPENSE REPORT, DEBIT NOTE PRINT VOUCHER REPORT, AP INVOICE VOUCHER REPORT using XML/BI Publisher.
• Loaded Legacy Journals data into interface tables and then populated the base tables of GL by running standard API
• Company Transaction Register Report to keep track of inter company revenues, assets, liabilities and expenses
• Designed and Developed AR Invoice Import interface program to load AR Invoices into Oracle E Business Suite.
• Created SRs on Metalink to resolve application issues and bugs
• Designed and Developed custom Workflow for Requisition to Purchase Order creation.

Environment: Oracle Applications R12.1.1, Reports 6i/10g, SQL, PL/SQL Developer, Forms 6i/10g, Windows 2000/NT environment, XML/BI Publisher, SQL*Loader, TOAD, Discoverer

Confidential

Oracle Applications EBS Consultant

Responsibilities:

• Designed and configured Custom extension using Order Management processing constraints to restrict cancellation or updates of a Sales Order once the PO is created for a Back to Back process.
• Worked with the client team in understanding the business processes to prepare the business requirements definition documents.
• Developed custom Reports in GL such as Account Analysis Report, customized Trial Balance Report and Inter-
• Participated in client meetings to gather the required process flows and developing business process documents.
• Carrying out requirement gathering, requirement analysis, high level and granular level mapping, gap analysis, setups, functional and technical extensions and modifications, unit testing, stress testing, integration testing, and CRP’s related to the split scenario and post production data cleansing.
• Setup profile options to support multi-org, multi reporting currency, Document sequence & assign sequences.
• Worked with super users to gather requirements and design documents for code conversion.
• Implemented Item Cross References to enable substitution item and cross-reference during Order entry.
• Created new processes in Order Management (OM) to process COGS account from order type for intercompany transactions rather than inventory.
• Defined picking rules in OM, defined roles & grants in OM.
• Defined price list, price breaks for items & defined modifiers & qualifiers in Advance pricing.
• Designed Order Import API for orders, RMA’s, and defined release rules for JMS pick rules.
• Defined Source, holds, credit holds, transaction flex field, transaction type, grouping rule to support OM order types.
• Defined order management transaction types to classify sales documents.
• Resolved issues related to Order flows in Order Management.
• Created User documents using User Productivity Kit (UPK) for all Modules used in the project. Published the UPK at Server Side.
• Completed End User training on all modules which are in the project using User Productivity Kit.
• Interacted and worked with the development team to solve various code bugs and developed new functionality enhancements.
• Conducted UATs, and created test plans and test scripts and test cases.
• Interacted with offshore technical team on daily basis to resolve critical production issues..
• Worked with oracle support team for resolving various bugs, resolving Service Requests, production critical issues, and analyzing patches.

Environment: Oracle Applications R12.0.4, Reports 6i/10g, SQL, PL/SQL Developer, Forms 6i/10g, Windows 2000/NT environment, XML/BI Publisher, SQL*Loader, TOAD, Discoverer

Confidential

Oracle Applications EBS consultant

Responsibilities:

• Performed design, coding, implementation and support and customized and developed reports as per client requirements.
• Worked on different modules like AP, AR, PO, and GL.
• Developed New Forms and Reports and creating Executables, Concurrent programs and request sets as per Client requirement.
• Developed PL/SQL programs for validations and analysed the tables.
• Designed, developed, tested and supported interfaces, which are implemented as concurrent programs in the new 11i implementation, to validate, translate and transfer General Ledger.
• Developed various Quarter end and Year end reports for the Higher Management review in AP like Top Ten vendor payments, Overall Payments history, Employee and Tax Payments etc.,
• Personalized various forms to include additional information such as adding IBAN number on Invoice, mandatory description for Invoice Header line, etc.,
• Developed XL Downloadable version of Budget Activity in Discoverer for the users to analyze, change and upload the latest version of the current forecast through web ADI.
• Modified the Tyco Custom Check template to reflect the changes requested by the users for limiting the number of lines appearing on the single page, Length and font of different fields on the check and bank code location.
• Designed and developed the whole process of extracting data from multiple XML Log files downloaded from bank, and sending out single email with attached log report in legitimate format.
• Supported the team with Post production issues. Acted as a Maintenance technical support for guiding users understanding the new system and solve daily problems.
• Developed Procedures, Packages, Triggers and Functions and wrote Procedures using Oracle supplied Packages.
• Created value sets, Database Views, Sequences and tables as per the client’s requirement.
• Created users, registered reports scheduled the concurrent programs.
• Responsible for preparing procedures, functions, packages as per the client’s requirements.
• Validations have done in front-end and as well in backend using triggers.

Environment: OracleApplications 11i (AP, AR, PO, GL) Oracle 9i/10g, SLQ Plus, PL/SQL, Forms6i, Reports6i, SQL Loader, TOAD, UNIX, WINSCP, Putty.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Involved in the development of Outbound Interface to export the data from oracle application base tables into legacy system
• Imported Invoices using Auto-invoice program and applied receipts using Auto-Lock Box
• Extensively worked on Oracle Reports 6i/10g and Oracle forms 6i/10g which includes Finance and SCM module reports.
• Developed custom Material Issue form to transact the material against a Purchase Requisition to various requesting departments and stores based on the availability of the on Hand quantity of the stock.
• Provided high level estimations to the project manager by task breakdown for different teams and identifying the dependencies.
• Wrote detailed technical design documents for some of the core functionalities and helped the team members on others. Functioned closely with the delivery team to implement the changes.
• Worked on Custom pll's in the process of upgrade.
• Created logical and physical database objects - tables, indexes, referential integrity constraints, and triggers to development needs.
• Worked on interface tables of purchasing to update purchase order line details and wrote PL/SQL codes to validate data and used concurrent program to load the data into base tables.
• Developed custom reports AR RECEIPT REPORT, AP PETTY CASH EXPENSE REPORT, DEBIT NOTE PRINT VOUCHER REPORT, AP INVOICE VOUCHER REPORT using XML/BI Publisher.
• Developed PURCHASING ACTIVITY REPORT, OVERDUE VENDOR SHIPMENTS REPORT, BUYERS REQUISITION ACTION REQUIRED REPORT using Oracle Reports 10g.
• Worked on Form personalization in Order Management and Purchasing.
• Used FNDLOAD to move the AOL objects from one instance to other instance.
• Working on Post production support to resolve the issues in day to day business process around the Finance and SCM modules.
• Trouble shoot issues in P2P like PO Approval workflow, AP Invoice Interface, Payment processing and AR Auto Invoice Interface.
• Involved with study of existing system, prepared the Technical (MD70) design document and Conversion Mapping Document (CV40) as per the AIM standards.

Environment: Oracle Apps 11.5.10.2 (GL, AP, PO, AR, OM, WSH, INV, HR), Oracle, Reports 6i, Forms 6i, XML Publisher, Toad, UNIX, PL/SQL

Confidential

Oracle Applications Consultant

Responsibilities:

• Assisted in database Creation, configuring tnsnames, listener, sqlnet files.
• Developed PL/SQL Procedures for execute different Business Logic in Reports and Forms.
• Extensively Developed PL/SQL Procedures and Triggers to for Business Process defined by the Analyst.
• Developed and customized Oracle Reports according to the Client requirement in Account Payables Module.
• Developed Payment Alerts in Payables Module.
• Worked on Oracle Form Personalization to enable and disable the fields.
• Implemented Form personalization like serial number should be unique in assets form in fixed assets module.
• Implemented Form personalization like invoice date should be equal to the distribution date in account payables.
• Prepared MD070 and MD120 which gives the complete installation document for Custom components.

Environment: Oracle Apps 11.5.10 Modules: (GL, AP, PO, AR, OM, WSH, INV), Oracle, Reports 6i, Forms 6i, Toad, UNIX, PL/SQL