SUMMARY

• 7+ years’ of Experience as an Oracle Applications E - Business (EBS) technical & functional consultant in implementation, support, design and deployment of Oracle Financials and Supply Chain Management modules.
• Hands-on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, work around, interfaces, user training.
• Experience in Oracle Applications implementation, upgrade and Post Production support projects.
• Extensively worked on Oracle Applications wif Distribution/Supply Chain Modules (OM-Order Management, INV-Inventory, PO -Purchasing) Financial modules (GL-General Ledger, AP-Oracle Accounts Payables, AR-Oracle Accounts Receivables).
• Strong knowledge in sub-ledger flows, Order to Cash and Procure to Pay processes
• Worked on Various Technical Documents using AIM (Application Implementation and Methodology)
• Very Good Understanding of Multi Org and TCA (Trading Community Architecture) concepts.
• Excellent knowledge of Oracle 10g environments wif expertise in SQL, PL/SQL, Oracle Forms (6i & 10g) and Oracle Reports(6i & 10g).
• Exposure to PL/SQL advanced concepts like composite data types (Collections and Records).
• Experience in designing and developing reports using XML/BI Publisher.
• Excellent development skills in RICE (Reports, Interfaces, Conversions and Extensions) components in the domain of Oracle E-Business Suite Essentials.
• Expertise in Design and development of interface and conversions in R12 using PL/SQL, SQL*Loader, UTL File.
• Strong coding experience in PL/SQL development using Packages, stored procedures, functions, triggers, views and indexes.
• Experience in moving objects across instances using UNIX Shell Scripting.
• Experience in TARs/SRs using Oracle Metalink in working wif Oracle Support to resolve issues wif Oracle applications standard functionality.
• Knowledgeable in Performance Tuning of Queries.
• Having hands on experience in MySQL to create and manipulate data objects.
• Knowledge on Python Scripting and PHP application.
• Strong ability to manage project tasks wif changing priorities and tight deadlines.
• Good Interpersonal, Reporting, trouble shooting and Communication skills.

TECHNICAL SKILLS

ERP: Oracle EBS R12 (12.1.3) and 11i (11.5.9, 11.5.10).

Oracle EBS Modules: SCM (PO, INV, OM), Financials (GL, AP, AR).

GUI Packages: Report Builder (6i & 10g), Form Builder (6i & 10g), Apex (3.1 & 4.1), Workflow builder and BI Publisher.

Database: Oracle (11g, 10g, 9i), MySQL, RDBMS.

Programming Languages: SQL, PL/SQL, MySQL, XSD, XML, WSDL, UNIX Shell Scripting.

Tools: SQL plus, PL/SQL Developer, Toad (SQL, MySQL), SQL*Loader, Workflow, Putty, WINSCP, Tortoise SVN.

Environment: s: Windows server 2010 and Linux.

Knowledge based tools: Oracle Metalink, Oracle forums, Oracle Technical magazine and eTRM.

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

Oracle E-Business Technical consultant

Responsibilities:

• Designed and development of Reports and packages in financial module.
• Documented functional features and behavior of required customizations using AIM methodology.
• Successfully completed development of AP and GL balance conversions using standard Interfaces and API’s from legacy system to Oracle base tables in R12.
• Technical involvement in the development and maintenance of interfaces, reports, forms, personalizations and workflows, across E-business Suite modules.
• Extensively involved in Oracle E-business Suite upgrade analysis from R11i to R12 - impact analysis on all custom RICEW components and user acceptance test planning.
• Prepared test cases for Account Payables module.
• Designed and developed custom report for GRN.
• Defining concurrent programs, executables and Value sets
• Extensively interacted wif Oracle metalink support to raise TAR/SRs and their resolution.
• Personalized standard forms and developed new forms according to the client specific business requirements, using Oracle Forms.
• Customized standard reports and created new reports as per the business requirements, using Oracle Reports.
• Design and documented MD70 for reports and forms.

Environment: Oracle E-Business Applications R12, TOAD, Oracle 10g, Reports 10g, forms 10g, SQL*Plus, PL/SQL, SQL*Loader, WINSCP, UNIX Shell Scripting and Putty.

Confidential

Oracle E-Business Technical consultant

Responsibilities:

• Developed inbound Interfaces to import flat file process right from design in PO module.
• Developed custom layouts (in XML & XSL-FO format) according to the user specifications.
• Successfully designed Interface programs wif advanced PL/SQL concepts of collections and records.
• Worked on incorporating custom layouts to the standard Print Purchase Order, Invoice and General Ledger reports using XML Publisher (BI publisher).
• Implemented multi-org financial systems using Oracle EBS modules such as GL, AR, AP, and FA.
• Supported wif Oracle form personalization to limit the access control for specific users.
• Dealt wif Oracle custom report issues like adding additional parameters, list of values based on Operating units and additional columns for Vendor Balances for GL account/Location.
• Customization of Oracle Account Analysis report to Account Analysis report by Employee.
• Customizing Aging Analysis report wif additional layout in report RTF.
• Generating Shell Script to pick data file from server and insert data into staging tables in General Ledger on daily basis and creating backup files.
• Involved in setting workflow notification mailer for in-bound and out-bound processing.
• Documented and designed MD 70 for custom reports based on provided MD50.
• Interacted wif Functional and DBA teams to discuss and involved in bug fixing on Daily basis.

Environment: Oracle E-Business Applications R12, TOAD, Oracle 10g, Reports 10g, forms 10g, Workflow builder, SQL*Plus, PL/SQL, WINSCP, UNIX Shell Scripting, Putty.

Confidential

Oracle E-Business Technical consultant

Responsibilities:

• Involved in implementation of the complete life cycle of Order to Cash.
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OM base tables.
• Worked exclusively on Oracle E-Business Suite (EBS) - upgrading from 11i to R12.
• Designed and Developed Staging tables, Data Conversion, SQL Loader Program and Custom PL/SQL API(Interfaces) to import the data from legacy system into OM using Order Import Concurrent Program.
• Worked on the implementation of Order to Cash (O2C) cycle including Order Entry, Order Booking, Pick Release, Ship Confirm, and Interfacing to Receivables.
• Created custom templates wif Data Definitions for XML Publisher and Developed reports using reports 9i/10g and registered as XML reports in applications.
• Configuration of Key Flex Fields, Descriptive Flex Fields, Profiles, Value Sets, Lookups, Transaction Types.
• Personalization of Oracle forms like, Order Entry and Material Transactions forms as per the client’s requirements, using Oracle Forms.
• Developed and registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer.
• Developed Custom Order Hold and Discounts program using OM and Advanced pricing module through PL/SQL.

Environment: Oracle E-Business Applications R12, TOAD, Oracle 10g, SQL*Plus, PL/SQL, SQL*Loader, Reports 10g, forms 10g, XML Publisher, WINSCP, UNIX Shell Scripting and Putty.

Confidential

Oracle E-Business Technical consultant

Responsibilities:

• Involved in Up-gradation from 11i to R12 environment.
• Worked on various modules OM, INV, PO, AP, AR and GL.
• Performed script changes on validating invalid objects wif R12 compliant.
• Successfully troubleshoot performance issues of Oracle Apps R12.1.2, and this is my third case of successful performance tuning of Oracle EBS Applications.
• Developed multiple custom reports in PO, AP and GL modules using Oracle Reports 10g and XML Publisher.
• Developed SQL Loader scripts and PL/SQL scripts for validating and inserting the data into interface tables and tan populated the Oracle base tables by using standard API.
• Loaded GL Flex values data from staging tables into GL base tables through fnd flex loader apis.
• Modifying stored procedures and functions to meet the requirements of the end user.
• Rebuilding queries for custom reports and custom objects involving AP, SLA and GL.
• Rewriting Alerts for India Localization, Order Acknowledgement and Credit hold acknowledgement.
• Involved in scripting Customer and Supplier API’s to update party and Supplier names and addresses using hz party v2pub and pos vendor pub pkg respectively.
• Involved in developing Oracle Workflow for necessary notifications and approval process.
• Developed custom reports using the XML Publisher to meet the requirements of the client.
• Effectively used Oracle Reports for generating PDF reports according to the client’s requirements.
• Involved in UAT1 and UAT2 testing till the objects are moved to Production Instance.
• Moving of concurrent programs and value sets from 11i to R12 using FNDLOAD and Shell Scripting.

Environment: Oracle E-Business Applications R12, TOAD, Oracle 10g, SQL*Plus, PL/SQL, Reports 10g, XML Publisher, Workflow builder, WINSCP, UNIX Shell Scripting and Putty.

Confidential

Oracle E-Business Technical consultant

Responsibilities:

• Custom Data Cleansing packages to normalize, validate, extract, de-duplicate and interface the legacy Supplier and Customer data tables wif MySQL.
• Stabilize the data and analysis of data by running existing reports and to analyze the behavior of the procedures, functions and triggers.
• Design of objects structure and objects for creating repository to migrate all the objects wifin the MySQL database.
• Extensively used Exception Handling for the ease of debugging and displaying the error messages in the application.
• Worked extensively, in and out on conversions. Involved in conversion process right from design, pre-conversion/data-cleansing, reconciliation of converted data to deployment of conversion packages onto go-live sites.
• Developed a custom API to create and update Projects (PA PROJECT PUB) using collections and records. Create related Tasks and Sub-tasks for respective Project.
• Developed a custom layouts (in XML & PDF format) according to the user specifications and worked on incorporating it to the standard and blanket Print Purchase Order, Invoice and General Ledger reports using XML Publisher (BI publisher).
• Customization of Vendor Balances report wif Location in excel format based on Report summary parameter (Supplier, Supplier Site or Invoice).
• Defining value sets, concurrent programs, registering custom reports, scheduling concurrent programs.
• Supported wif Oracle custom form and reports issues developed based on custom objects and custom triggers.
• Supporting custom interfaces to maintain an uninterrupted data flow between legacy systems and EBS.
• Involved wif Investigating on business application related issue and perform root cause analysis and bug fix.

Environment: Oracle E-Business Applications R12, TOAD, Oracle 10g, SQL*Plus, PL/SQL, Reports 10g, forms 10g, WINSCP, UNIX Shell Scripting and Putty.

Confidential

MySQL Developer

Responsibilities:

• Running python scripts to load data into the custom tables wif necessary customizations in the script.
• Developed a custom procedures and functions to validate loaded data in the custom objects and to move them into base tables.
• Creating procedure and functions to identify data validation and data integrity issues while loading data through python scripts.
• Creating views and index based on the tables and their columns.
• Developing scripts to generate weekly and monthly reports for reconciliation and disbursements.
• Creating procedure to update exchange rates based on the file provided by the user.
• Creating procedure to call all the functions and procedures created to generate reports based on monthly, weekly and daily basis.
• Holding calls wif the end user to discuss the issues wif respect to data integrity and issues related to the reports generated for daily, weekly and monthly.
• Generating sales summary reports and payment reports using MySQL scripts while running the report generation from PHP application.

Environment: PHP, Python, MySQL, TOAD for MySQL, Oracle Reports 6i, Putty.

Confidential

Oracle E-Business Developer

Responsibilities:

• Worked in Oracle Back-end PL/SQL Development me.e. Stored Procedures, Packages.
• Created logical and physical database objects - table spaces, tables, views, synonyms, indexes, referential integrity constraints, and triggers to development needs.
• Prepared requirement specification document dat gives the comprehensive details about the requirements.
• Extensively used UTL FILE utility for data extract into flat files from Oracle EBS.
• Developed conversion Programs for Open Invoices in AP and open balances in GL.
• Devloped Functions & Triggers using TOAD as development tool.
• Created Materialized Views to reduce query run time for the end user.
• Involved in taking backups and exports, FTP in UNIX environment.
• Developed Reports to extract the monthly information in Inventory, AP and GL.
• Developed custom reports and added columns in the existing reports according to the requirement.
• Coordinated wif the business users to collect requirements.

Environment: Oracle E-Business Applications 11i, SQL, PL/SQL, TOAD, Oracle Reports 6i, WINSCP, UNIX Shell Scripting and Putty.

Confidential

Oracle Developer

Responsibilities:

• Worked in Oracle Back-end PL/SQL Development me.e. Stored Procedures, Packages
• Created logical and physical database objects - table spaces, tables, views, synonyms, indexes, referential integrity constraints, and triggers to development needs.
• Involved in Code Review, Code Walk Through, and Unit Testing.
• Developed Inventory stock ledger lot report dat gives the comprehensive details Inventory.
• Developed custom Invoice Aging Analysis report.

Environment: Oracle E-Business Applications 11i, SQL, PL/SQL, TOAD, Oracle Reports 6i, WINSCP, UNIX Shell Scripting and Putty