SUMMARY:

• 10 years of Upgrade, Implementation and Support experience in Oracle e - Business suite with technical and functional proficiency in Finance modules and purchasing
• Strong techno-functional expertise in Oracle EBS Finance, procure to pay, Oracle Time and Labor Oracle HRMS and General Ledger modules.
• Over 4 years of experience at Onsite in customer facing roles including development and support roles in multiple capacities.
• Worked extensively on various Technical aspects including development/customization and production support activities in Oracle applications environment.
• Hands-on involvement in business requirement, GAP analysis, process mapping, solution analysis, development, source control and deployment.
• Technically proficient in RICEWF components (Reports, Interfaces, Conversions, Extensions,Workflow).
• Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
• Expertise on designing and implementing Oracle Alerts and Lookups.
• Developed new Concurrent Programs, Custom Forms, Reports and Flex Field Customizations.
• Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.
• Worked on OAF pages customizations
• Worked on advanced PLSQL

TECHNICAL SKILLS:

Domain: Good exposure to Oracle Applications in finance modules like Account Receivables, Account Payables, General Ledger and Sub Ledger Accounting and Purchasing.

Technical: SQL, PL/SQL, Oracle Reports, Oracle Forms, SQL * LOADER, SQL*Plus, Toad, SQL developer.

PROFESSIONAL EXPERIENCE:

Confidential, Tulsa, OK

Oracle Apps Techno functional Consultant

Responsibilities:

• Responsible for analyzing & troubleshooting complex issues and implementing solutions .Work with peers, and business analysts to create project specification and determine implementation details.
• Maintain current applications which include bug fixes, feature enhancements and performance tuning
• RA Marketing Implementation AP,AR and GL
• Understanding technical requirements for AP and PO and Inventory modules - P2P cycle -
• Purging P2P modules' interface data
• Provided solution for iExpense Payroll related support, AP Trial Balance issues, Invoice Validation error handling, PO receipt interface errors, AP Payment process issues etc.
• Responsible for Journal Imports from all other modules like Accounts Payables (AP) and Account Receivables (AR) into General Ledger (GL).
• Worked on the development of interfaces and Customizing Oracle Reports touching various modules such as AR,AP and GL.
• Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.
• Worked AUTOLOCKBOX Interface to load data that is received from bank into interface tables (AR PAYMENTS INTERFACE ALL), from interface table to the Base Interim tables and finally to the base table.
• Developed UNIX Shell scripts to FTP the flat file from External Server to Oracle UNIX Server location
• Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.
• Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
• Used Version Control (tortoise subversion) to maintain code changes.
• Worked on Expense distribution Williams custom module for Time and labor
• Worked on the development activities as part of issue resolution. Perform Unit Testing, Migrate to next environments, assist user testing and closing the tickets.
• R12 Upgrade Activities
• Extensively worked on RICEWF
• Worked on OAF pages customizations
• Worked on oracle HRMS interfaces
• Worked on advanced PLSQSL
• Provided technical design document for Credit risk modernization project.

Environment: Oracle Applications R12, Oracle 10g, TOAD, AP, AR, GL, PO,Forms10g and Reports10g, Discoverer 10g, UNIX, PL/SQL Developer, XML Publisher,Oracle EBS 11.5.10,Oracle R12.1.3,Java

Confidential, Ohio

Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.
• Extensively participated in developing technical documents (MD70).
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements.
• Provided data flow design of custom tables used in various process.

Environment: Oracle Applications R12, Oracle 10g, TOAD, AP, AR, GL,PO, Forms10g and Reports10g, Discoverer 10g, UNIX, PL/SQL Developer, XML Publisher, Oracle R12.1.3

Confidential

Senior Project Engineer - Production Support

Responsibilities:

• Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
• Co-ordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.
• Creation of database objects like tables, views, Indexes on tables, synonyms, materialized views, Stored procedures, packages using oracle tools like SQL* plus.
• Involved in moving the data from flat files to staging area tables using SQL* Loader.
• Wrote SQL Loader control file for flat file data from other departments and scheduled them in UNIX to load every night in Production Environment.
• Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Managed problems, enhancement, and new functionality requests to meet changes in the business needs.

Environment: Oracle Applications 11i, Oracle 10g, TOAD, AP, AR, PO,GL, Forms 6i and Reports 6i, Discoverer 10g, UNIX, PL/SQL Developer, Oracle 11.5.10

Confidential, Minneapolis, MN

Oracle PL/SQL Developer

Responsibilities:

• Worked in the project as an important resource from development phase to post production phase for a successful data conversion.
• Developed, modified, and optimized complex queries for data conversion and modification.
• Developed, debugged, and modified stored procedures, tables, views, user-defined functions etc in order to convert the legacy data to be in sync with the application (EAMS).
• Involved in Writing Backend Procedures, Functions & Packages in PL/SQL.
• Data migration and Conversion done utilizing Oracle utilities: SQL Loader, Export/Import.
• Experience in database performance tuning and query optimization.
• Experience in performance tuning sessions/workflows, target, source and mappings.
• Responsible for coding the New forms and complete the enhancements in the existing Forms using forms 10g.
• Responsible for developing the new reports Using reports 10g.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Extensively used SQL *Loader to load Data from flat files to Database tables in Oracle.
• Scheduled jobs in oracle/UNIX using job scheduler/Crontab to run schema analysis, packages and day to day jobs.
• Written UNIX shell scripts to automate post conversion processes.

Environment: Oracle Applications 11i, Oracle 10g, TOAD, AP, AR, GL, Forms 6i and Reports 6i, UNIX, PL/SQL Developer

Confidential, Minneapolis, MN

Project Engineer

Responsibilities:

• Developed Scripts to create tables, functions, stored procedures, Triggers, Packages, Indexes, and Views.
• Worked extensively on procedures to extract the data Developed new reports to extract the invoice data, shipping data, sales orders information etc.
• Worked on customizing the oracle reports
• Worked on data conversion and interfaces
• Worked on enhancements of existing customized objects.
• Worked on SQL*Loader Scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.
• Developed Oracle Alerts and Lookups.
• Imported data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.

Environment: Oracle Applications 11i, Oracle 10g, TOAD, AP, AR, GL, Forms 6i and Reports 6i, UNIX, PL/SQL Developer