SUMMARY

• An IT professional with more than 8 years of experience as Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 8i, 9i, 10g & 11g in Production, Staging, Development environments..
• Strong knowledge of order to cash (O2C) and procure to pay (P2P) business flows.
• Good technical development skills in developing Reports, Interfaces, Conversions and Extensions (RICE) components.
• Setup Global Inventory (INV) profile options, Purchasing (PO) profile options and Order Management (OM) profile options. Involved in new enhancements for the project, like customization, creating new sub inventories and location in different organizations and setting up new location mapping for different transactions. (INV, PO, AP and OM).
• Proficient in SQL, PL/SQL, UNIX, Linux Shell scripting, Perl Scripting and Oracle 10g/9i/8i
• Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents using AIM Methodologies.
• Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Extensively worked on Discoverer, which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
• Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes, Shell scripting, Performance Tuning.
• Extensive experience in developing and customizing numerous Forms using Oracle Forms, reports using Reports implementing bind and lexical parameters and generated various XML/BI Publisher reports, which included working on report development objects like data templates and RTF’s.
• Excellent knowledge of AOL (Application Object Library) and System Administration.
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Very good Knowledge and understanding of Application Object Library (AOL) and Trading Community Architecture (TCA).
• Proficient in creation of database objects like stored procedures, functions, packages, tables, indexes, triggers, snapshots etc. Good experience in performing data migrations, data loads using ETL tools
• Transferred and retrieved data to and from FTP Servers to Oracle Database.
• Extensively utilized the Application Object Library (AOL) to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.
• Extensively worked on Oracle Discoverer, which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
• Implemented SQL*Loader to load data into tables and also used DBMS Utility package.
• Experienced in Performance Tuning and analyzing using TKPROF, SQL Trace, and Explain Plan.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• 24/7 Support and effectively to production & development issues and taking responsibility for seeing those issues through resolution.
• Have strong interpersonal skills along with proficient written and verbal skills. Overall strength lies in precise translation of business requirements into technical documents.
• Proven ability to quickly learn and apply new technologies with strong technical background.
• Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

TECHNICAL SKILLS

Oracle Applications: Oracle E-Business suite R12/11i OM, INV, GL, AP, AR, PO, FA, AOL, BOM, I-Procurement and System Administration.

Application Tools: Reports 10g/9i, Discoverer 10g/6i, XML Publisher 5.6.3/5.6.2 , Oracle Forms 10g/9i, TOAD, SQL*PLUS, Export, Import, SQL*Loader, Oracle JDeveloper.

Operating Systems: Windows XP/7, UNIX, Linux, AIX, MS-DOS.

Languages: SQL, PL/SQL, C, C++, Java Script, PHP, Java, HTML, XML.

Scripting Languages: Unix Shell scripts, Perl.

RDBMS: Oracle 12c/11g/10g, SQL Server 2000.

PROFESSIONAL EXPERIENCE

Confidential, CHICAGO

ORACLE APPS TECHNO FUNCTIONAL CONSULTANT

Responsibilities:

• Customized the Oracle Seeded Order Management Transaction Type workflow to add workflow functions for email Notifications when the order is booked using Workflow Builder.
• Possesses an in depth knowledge on Business Flows of Order to Cash and Procure to Pay.
• Experience in defining processes relative to Order to Cash, Procure to Pay, Close Processing, and reporting.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Developed PERL Shell scripts to automate repetitive database processes.
• Involved in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all the ETL needs.
• Expert level experience in Oracle Forms 11g, Reports, PL/SQL, Discoverer, BI (XML) Publisher
• Created Purchase Order Notification Report for Advanced Supply Chain Planning (ASCP).
• Worked with end users, clients, and data quality personnel to design and code complex data mapping, transformation and integration scripts in PL/SQL to move information from legacy Confidential into the ORACLE data warehouse/CDR, running on Windows NT clients with UNIX servers
• Personalized the Receiving Transactions Form in Inventory according to the client’s requirement.
• Worked in Data Conversions between Legacy systems and Oracle Applications in the areas of Inventory, Order Management and Bills of Material (BOM).
• ASCP souring rules configuration to allow ATP and OM’s SO scheduling process to define “source from” calculation based on customer site’s region.
• Built custom reports using Oracle 11g Reports using Report Builder to fulfill the business requirements of the client.
• Customized the standard Workflow Items and process such as Order Headers and Order Lines.
• Developed Bar-coded Packing Slip Report and Bar-coded Package labels.
• Developed reports in Perl for our end users.
• Documentation &Coordination between different Cross commits (ETL, Mainframe, Source File)
• Developed interface to load Requisitions data corresponding to Bulk Supply Sales Orders to Oracle Purchasing using PL/SQL Packages and Procedures and auto-create Blanket Releases.
• Worked onOracle Apexto load the Oracle Forms in to an Oracle Application Express Project and generated an initial Apex Application.
• Created ETL design specifications.
• Assisted with ORACLE HR configuration and installation issues, enabled PGP encryption concurrent with the use of FTP within the HR application by use of stored PL/SQL in conjunction with UNIX Korn shell scripts
• Designed and developed custom Outbound Pricing Process for corporate customers using PL/SQL Packages, shell scripts for Aviation operating unit.
• Created tables, sequences, views. Wrote and maintained stored procedures, PL/SQL and SQL statements, and triggers to be used in Oracle environment. Created standardized exceptions handling.
• Experience in PLSQL Interfaces, PLSQL APIs, Conversions, Customization and Development of Forms, Workflows and Reports.
• Analyzed, designed and developed Oracle Forms 11g queries, layout, report triggers, parameter form, data models
• Designed and developed custom Outbound Pricing Process for corporate customers using PL/SQL Packages, shell scripts for Aviation operating unit.
• Created and modified several PERL Scripts according to the changing needs of the project and client requirements
• Imported Requisition Details (Requisition Import) using SQL* Loader and PL/SQL. Wrote programs to insert update and validate values into the PO requisition Interface tables for each requisition line.
• Involved in writing Technical Design Document (MD070) as per Oracle AIM Methodology.
• Developed an Interface Program to import Supplier Invoices from legacy system into Oracle AP.
• Developed an Interface Program to import customers, locations, customer’s sites and customer contacts by using the TCA APIs.
• Migration of existing software from IBM AS/400 into SUN Linux financial software called C.C.R.I.S. (Commercial Credit Receivable Inventory System)
• Involved in development of custom reports using Reports 10g and XML BI Publisher.
• Customized standard AP Invoice Aging to run the report based on ‘as of date’.
• Developed integration between Oracle Shipping and FedEx, shipping software tools to populate the shipping address based on delivery name.
• Developed AP Expense Report interface to load the invoices from multiple sources like Legal Invoices, Quarterly Payroll, OfficeMax, Charitable Contributions, Travel EFT etc., into Accounts Payable in a periodic basis.
• Involved in development of custom reports using Reports 10g and XML BI Publisher.
• Designed and developed custom user editor form using Oracle Forms 11g.
• Defining descriptive Key Flex fields, Key Flex fields, Set of Books, Accounts, and Approval rules for Journal Entries, Reconciliation, Post Journals, Year End Closing and Period Closing in GL
• Customized standard AR Invoice Print report to print Project Number at invoice header.
• Designed and developed Auto Lockbox to load receipts and invoices into Oracle Receivables.

Environment: Oracle Applications R12/11i (PA, AR, AP, PO, OM, INV, BOM, I-Procurement), Oracle RDBMS 12c, Reports 10g, Forms 10g, SQL* Loader, Discoverer 10g,SQL/ PL/SQL, AIX OS, Workflow builder 2.6, XML publisher, TOAD.

Confidential -WI

ORACLE TECHNO FUNCTIONAL CONSULTANT

Responsibilities:

• Ample functional knowledge of the Order To Cash(O2C) and Procure To pay(P2P) cycles of Oracle Applications e-Business Suite, with experience in the analysis, design, and development of business, Oracle Financials and Oracle Distribution environments.
• Inventory Items configuration for OPM, ASCP, Forecast, ISO and Quality capable.
• Business Requirements Mapping for Projects, Advanced Supply Chain Planning (ASCP), OPM, INV, BOM, PO.
• Involved in development of custom reports using Reports 10g and XML BI Publisher.
• Maintained 13 applications which are engaged with different technologies like Perl, Shell scripting, MySQL, Oracle SQL & PL/SQL.
• Involve in Data Extraction, Transformation and Loading (ETL process) from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Facilitated migration of R&D2’s code and development environments from PC network to UNIX, including extensive UNIX shell programming.
• Business process flows of Order to Cash Flow, Order to Ship, Order to Drop Shipment, Customer Invoice to Cash, Order to Status Inquiry, Supplier Invoice to Payment, Procure to pay.
• Designed wide variety of reports in Order Management with BI/XML Publisher.
• Worked with Sales Orders Open Interface in Oracle Order management module to import Sales Orders from flat files.
• Built custom reports using Oracle 10g Reports using Report Builder to fulfill the business requirements of the client.
• Worked on Personalization of forms such as making fields mandatory, Validating fields using custom code in triggers.
• Development of UNIX Shell Scripts for processing EDI files
• Developed item interface in inventory (INV) to import the item information from the legacy system into oracle inventory (INV) using SQL*Loader and PL/SQL validations.
• Customized the Customer Form using Custom.pll to Activate/Inactivate the Active check box based on the users and the responsibilities, implemented zoom functionality in custom forms.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Designed and developed custom user editor form using Oracle Forms 10g
• Migrated the Application Server from Solaris Server to Virtual Linux Red Hat server with latest Perl modules and updated environment.
• Involved in carrying over the Customizations and Extensions done on the Oracle reports, Oracle forms and PL/SQL programs using Oracle Apps version R12.
• Developing Upgrade-Fallback Unix Shell Scripts and Data Conversion Perl/Shell Scripts
• Implemented form personalization in some forms based on client requirement.
• Developed PL/SQL scripts to load data from external system to Fixed Assets interface tables.
• Involved in design of AIM (Application Implementation Methodology) documents (MD-050, MD-070) for all conversion and interfaces.
• Developed PO Detail and PO Summary category Report Using Discoverer10g.
• Worked extensively on the customization of Auditor Reports using BI/XML Publisher and resolved open issues with the existing custom reports and also involved in the development of new ones.
• Extensively worked on RICE Components to view, transfer and modify the data in the same or different system.
• Designed menus and responsibilities to different level of users in the organization.
• Personalized many Oracle standard Forms as per the Client requirements.
• Developed many reports and designed to view output in different formats like PDF, EXCEL, RTF and HTML using BI/XML Publisher.
• Customized the report called Backorder Detail Report which is used to review all customer orders that have been backordered using Oracle Reports 10g.
• Extensively Used before Report and After Report Triggers, Lexical Parameters in developing Oracle Reports to run the report for the TOP 10 Vendors or Customers based on the User Parameter.
• Developed reports in Payables to send a Notification to AP/Buyer/Requestor of Invoices on Hold.
• Involved in customer conversion from legacy system into Oracle Accounts Receivable by using Customer Interface.
• Participated in the analysis of Physical Data Model for ETL mapping and process flow diagrams to develop Data Mart design.
• Development of UNIX Shell and Perl Scripts for pre-processing daily usage VOD flat-files coming from Cable TV providers (Cox Cable, Confidential, Rentrak etc)
• Customized various Concurrent Programs and AR Aging Reports in Oracle Receivables and Oracle Payables to run independently irrespective of Responsibility using SRW packages.
• Involved in migrating the data into Oracle Apps from the Excel Sheets using open interface / Oracle API, Oracle utilities and third party tools (Data Loader).
• Developed several Procedures and Database Triggers as per Business requirement.
• Involved in performance tuning of various packages and reports and done code fixes to improve the performance in OM and AR modules using Explain Plan, TKPROF, Hints and TOAD.
• Developed Extracts in GL and AR modules and the extracted files are sent via FTP to other systems using the UNIX Shell Script.

Environment: Oracle Apps Financials EBS R12 (GL, AR, AP), PO, INV, OM, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, TOAD, Workflow Builder.

Confidential, LOS ANGELES, CA

ORACLE APPS TECHNO FUNCTIONAL CONSULTANT

Responsibilities:

• Developed Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports.
• Worked with Sales Orders Open Interface in Oracle Order management module to import Sales Orders from legacy system to Oracle Order Management by using the Oracle API.
• Imported ITEMS from legacy system to Oracle Inventory by using the standard item import program through a custom package that validates individual records.
• Implemented Oracle GL, INV modules to meet Business requirements of the client.
• Involved in carrying over the Customizations and Extensions done on the Oracle reports, Oracle forms and PL/SQL programs using Oracle Apps version 11.5.8 to 11.5.10.
• Developed Custom Packages, Procedures for validating the Summary balances and Detail Transactions from the legacy system, imported them into interface table and submitted the Journal Import program to populate base tables.
• Worked on preparing functional and technical document (MD050 & MD070) according to client and user requirements.
• Worked on extracting information from Oracle Applications base tables to Intermediate tables for outbound interfaces.
• Worked with Informatica to create ETL mappings and schedule workflow
• Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans and Trace Sessions.
• Customized the GL Account Analysis Report based on the Clients requirement. .
• Involved in designing various reports like Inactive items report, Bill of materials item listing reports, GL detail report using Oracle Reports 10g.
• Developed PL/SQL procedures, functions and packages.
• Created the materialized views and also created the partitioning tables.
• Worked on database triggers for automatically updating the tables.
• Created host programs using UNIX shell scripting for remote database access and ftp of files to the supplier site database.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Created various lookups, Value sets, user defined tables.
• Performed the unit test cases for all the identified impacted items and documenting the same for user acceptance test.

Environment: Oracle Applications 11i, Oracle 11g Database, UNIX, Oracle Reports 10g and PL/SQL.

Confidential, PHOENIX, AZ

ORACLE APPS TECHNICAL CONSULTANT

Responsibilities:

• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program.
• Customized Reports like the Order Summary Report, Pick Slip Report and Packing Slip Report in Order Management using XML/BI publisher.
• Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.
• Developed a Customized XML/BI Publisher report for On-Hand-Quantity available for all the items in every sub-inventory, which belonged to a particular Organization in the inventory module.
• Developed control file to load sales orders created in legacy system into staging tables using SQL * loader then validated data and inserted into Order Management interface tables.
• Interacting with Business users, gathering and analyzing requirements and Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• Customized a new workflow process in Order Entry to keep track of the Sales Order and sending the notifications correspondingly.
• Released holds using OE ORDER PUB API and adjusted line adjustments.
• Developed PL/SQL Procedures for Customer interface using Trading Community Architecture (TCA) in Accounts Receivables according to Client Requirements.
• Followed (MD50) functional documents and written the technical (MD70) specifications, provided support for end users and documented the modifications.
• Involved in Auto Invoice Interface to load invoices automatically from legacy systems to Oracle Receivables Interface tables.
• Loaded the data into AR PAYMENTS INTERFACE ALL. Validated and imported the data into AR base tables.
• Customized various XML/BI Publisher Reports using RTF templates and defined their respective Templates and Data Definitions.
• Converted Supplier Payment History Report in Account Payables from Report 6i to XML/BI Publisher.
• Customized AR Aging 4 and 7 Bucket reports in Account Receivables.
• Worked extensively on System Administration responsibility by doing set ups in AR, AP and GL Modules.
• Modified Privileges for Users using System Administration responsibility depending upon various Organizations.
• Worked with Application Object Library (Defined executable, programs, linked with responsibilities, defined DFF and value sets).
• Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using the recommended AIM documentation.

Environment: Oracle Applications R11i, GL, AR, AP, PO, INV, FA, OM, iExpenses, Oracle 10g, D2K, Forms 9i, Reports 9i, Discoverer 6i, Workflow, XML/BI Publisher and TOAD.

Confidential

ORACLE TECHNICAL CONSULTANT

Responsibilities:

• Worked as a team member to implement and develop interfaces according to business requirements for Purchasing (PO), Inventory (INV) and Receivables (AR).
• Involved in Open Transaction Interface to import transactions from legacy system to Inventory and set up Transaction Manager as background program to import validated data from interface table periodically.
• Developed custom interface program to load inventory (INV) Adjustment data from external system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables as Account Alias Receipts and Account Alias Issues.
• Developed Alerts in Inventory Modules.
• Customized Reports in PO, AR and AP like Printed Purchase Order Report, Aging 4 Bucket Report etc using Reports 9i.
• Used FND REQUEST API to submit concurrent Programs from PL/SQL program.
• Involved in setup and customization of Oracle Payables and data conversion from legacy system into Oracle Payables.
• Imported Requisitions from legacy system to Purchasing through Requisition Open Interface.
• Used SQL*Loader and UTL FILE Packages for data conversion and interfaces.
• Created new business areas, workbooks according to user requirements and also involved in creating reports using Discoverer 6i.
• Registered Reports, SQL*Loader Scripts and PL/SQL Packages as Concurrent Programs using System Administrator Responsibility.

Environment: Oracle Financials 10g, Oracle 10g, Discoverer 6i, Forms 9i and Reports 9i.