SUMMARY

• Over 8+ years of diversified experience as an Oracle Apps Consultant in the Analysis, Design, Development,Implementation, Customization and Supporting of Oracle Applications in Procure to Pay (P2P), Order to Cash (O2C), and Assets to GL Cycle’s Using Multi - Org concepts having good experience in various stages of Software Development Life Cycle Process (SDLC) and its deliverables in ERP Sector.
• Strong background in development and customization of RICE objects in ORACLE General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Purchasing (PO),Fixed Assets (FA), HR andOracle Inventory modules.
• Involved in requirements gathering workshops, prepared as-is (BP-040), To-Be (BP080), GAP analysis, setups (BR-100), Functional design (MD050), Technical Design (MD070) documents using AIM methodology.
• Expertise in design and development of Interface/Conversion programs for Enterprise level integrationoflegacy systems into Oracle Applications using open interfaces and APIs.
• Good knowledge in development of Custom interfaces, APIs, building control files, dealing with Application Object Library (AOL), reports and workflows.
• Extensive exposure in development and customization of reports by using Report 6i/9i/10g and XML/Bi Publisher, Discoverer.
• Adept experience in developing components for Supply Chain Modules (SCM) like Order Management (OM), Inventory (INV) and Shipping and Manufacturing modules like Bill of Materials (BOM) and Work in Progress (WIP).
• Experienced in Development Customization, Personalization and Registration of Oracle forms6i/9i/10g/11g, Discoverer 9i/10g and XML Publisher.
• Customized several Oracle reports and also developed several custom reports using Oracle Reports 6i/9i/10g and registered them in Oracle Applications.
• Capable of Optimizing SQL and PL/SQL scripts and creation of concurrent programs to execute requests, reports, stored procedures andUNIX shell scripts.
• Extensive experience in Oracle backend objects like: Database Tables, Views, Indexes, Triggers, Stored Procedures, Functions, and Packages.
• Strong understanding on underlying data structures in Financial Modules and good knowledge on Application Object Library (AOL).
• Ability to utilize the Project methodologies, good understanding on Business terminology, quickly adaptable to new environments and innovative technologies.
• Good team player having excellent interpersonal, presentation, oral and written communication skills.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications R12/11i (PO, AP, AR, GL, OM, HR, Inventory, IExpense, IProcurement, and others).

RDBMS: Oracle (11g/10g, 9i, 8i), MS Access.

Tools: Developer Suite (Reports10g/9i/6i), Discoverer 4i/10g, XML Publisher, Work-flow Builder,and TOAD (10.6.0 & 12.0.0).

Operating Systems: Unix, Windows XP, Windows NT

Languages: SQL, PL/SQL, UNIX, C and C++

Web Tools: HTML, MS Front page

Other Tools: MS Office, HP Quality Centre, Secure shell.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Software Programmer

Responsibilities:

• Understanding the existing documentation and preparing new documentation for the changes.
• Interacted with Business users to get required inputs on design and existing issues in production.
• Participated in code review sessions and TFSD walk through sessions to understand the existing complex revenue application.
• Worked on the design review sessions and documented the changes for the existing revenue management application.
• Consolidated the requirements for feeding the revenue application from different ERP’s having newly integrated WebEx orders.
• Worked on a code changes for future transaction batch job as part of WebEx integration.
• Extensively worked on reporting the business impact due to development effort and communicated them with Business team on timely basis.
• Worked on an application for linked OM orders and AR invoices to leverage the revenue management application.
• Made changes to the existing code to provide user to link multiple deals to NGCCRM specific profiles.
• Extensively worked on link, re-link and de-link the profiles and sales orders and tested the functionality of the application.
• Worked on testing the inherited hierarchy of the deferrals from profile level to the sales order level.
• End-to-end testing of the application with variable user inputs and wide scenarios to ensure the changes reflected at all levels.
• Supported the test cycles and worked on the production data fixes for the month end issues in the production.
• Communicated with the offshore on daily basis on task allocation and resource sharing for the modules assigned.

Environment: Oracle Applications R12, OM, AR GL, PL/SQL, Secure shell, HP Quality Centre ALM, Reports 10g, UNIX, TOAD, PVCS, Kintana.

Confidential, Milwaukee, WI

Oracle Enterprise Programmer Analyst/R12 Support

Responsibilities:

• Analyzing and understanding the userrequirements and moving forward on priority solutions for key stakeholders.
• Meet and discuss with Business analysts to determine the business and functional impact of the issues.
• Proposing feasible solutions for Business users, matching the technical and system requirements and getting the approvals from team-leads and users/stakeholders.
• Extensively worked on AP, AR, PO and GL modules to develop and change the PO customized reports, AP Work-flow alerts and AR Interfaces.
• Creating new Value-sets and updating look-ups as per the Business/user requirements and making changes to code ensuring expected end-user results.
• Worked on customization of Sys Admin reports using people tables to get the security audit details for contingent workers along with employees.
• Query optimization and performance tuning of Alert queries, report queries, PL/SQL procedures and Interfaces using Oracle hints and reduced the run-time in production.
• Worked on identifying the formatting issues for GL expenditure reports with large datasets and ensure rectifying them with proper changes at report level and query level.
• Working closely with end-users and business analysts to get the results fromuser-acceptance-testing and do necessary follow-up on test-feedback and proposals.
• Worked with DBA’s and production coordinator to communicate oracle recommendations from Meta-link to install patches and changing profile options accordingly.
• Following the standard procedures for development and change requests, tracking changes, maintaining and updating AOL documentation as per the MCW standards.
• Created MD-120’s for all the change requests (CR’s) that I have worked and sent for reviews to confirm right time for migration occurrence.

Environment: Oracle Applications R12, Purchasing, AP, AR, HR and GL, AP Workflow Alerts, XML Publisher, Reports 10g, UNIX, TOAD, SSH SFTP, SSH Secure Shell, Star-team Cross Platform Client-2006

Confidential, Warren, NJ

Oracle Apps Technical Analyst

Responsibilities:

• Designed customizations, interface/conversion mapping, pre production testing, and related documentation.
• Developed and customized Financial Modules Interacted with end users to gather requirements and Draft specifications for development Phase.
• Written an API for Converting the Invoice Payments(AP) and was able to convert all the Historical Invoice Payment History into Production.
• Registered customized Oracle reports and BI/XML Publisher reports using System Administrator and Application Developer.
• Did Accounts Payable set up and covered Vendor Maintenance, Invoice Processing,Payments, Payment Reconciliation and Period Close Process.
• Responsible for running Receivables open interface, imported data into RA interface tables and used the Auto Invoice to import the customer invoices.
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
• Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.
• Strong Oracle RICE development experience in all AP, AR, FA, GL, PO and OM Modules.
• Responsible for converting the entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production.
• Utilized Forms Personalization utility to call a PLSQL procedure and updated the AR Descriptive flex fields with Depot Repair flex field data.
• Experience in System Administration activities like Managing Concurrent Programs and Responsibilities.
• Designed and developed Asset Conversion by running Mass Additions Concurrent Program to transfer the data from interface to base tables in Fixed Assets (FA).
• Setting upmulti Currency processing, revaluations and consolidations in General Ledger module.

Environment: Oracle Applications R12/11i - AP, AR, Purchasing, GL, FA, Cash Management, OM, INV, Work Flow, OA Framework, Forms 9i, Reports 9i, Discoverer 4.1/9.0.2, XML publisher, UNIX, TOAD.

Confidential, San Diego, CA

Oracle Apps System Analyst

Responsibilities:

• Implementation of Oracle Receivables including setup of system options, payment terms, transaction types, transaction sources, auto accounting, banks, receipt methods, receipt classes, tax codes.
• Defined the custom lookup values in AOL & project accounting and assigned dependent value sets.
• Designed custom forms and reports for the requirements of the clients and integrated them with Confidential system.
• Involved in complete cycle testing of process flow and reconciliation of revenue data received from external system and transferred to Confidential and posted to GL
• Participated in user testing, helped in migration to production.
• Providing production support of Oracle financials, including following

Environment: OracleApplications11.5.10.2(PA,AR,GL,AP,PO),Oracle,10g(SQL,PL/SQL),TOAD.

Confidential, San Diego, CA

Application Analyst/Developer

Responsibilities:

• Imported and validate transaction data from other financial systems and create Invoices, debit memos, credit memos in Oracle receivables via the Oracle Auto Invoice open interface
• Functional setup of OM, e.g. order types, line types, hold, price list, Release Sequence rule, item categories, flex field setups etc.
• Resolving all kinds of technical issues spanning from OE, INV, AP, AR, and GL.
• Involved in business process analysis, design, planning, implementation, user testing coordination and acceptance related to project implementations.
• Involved in the Technical Design for Interfaces.
• Interface directly with business system teams and end-users.
• Performance tuning of oracle programs.
• Data extractions from Oracle to give the information to data warehousing data mart.
• Worked in PL/SQL, Forms, Reports and UNIX Shell Scripting

Environment: Oracle Applications 11i (11.5.10.2), Oracle 10g, GL, AP, Purchasing, AR, INV, OM, Workflow Administrator, Forms9i and Reports9i, Discoverer 10g, UNIX, PLSQL Developer.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Designing and building reports using Oracle Report Designer.
• Created several SQL queries, procedures, functions, packages and several database objects.
• Preparation of class structure and sequence diagrams using Rational Rose
• Using views for designing and building reports.
• Used cursors and collections for accessing complex data resulted from joining a large number of tables
• Extracted data into comma or pipe delimited files using UTL FILE package/utility.
• Involved in testing backend SQL queries for query optimization.
• Developed several packages that are used in oracle forms and reports.
• Tuned the applications to enhance the speed by utilizing Indexing, SQL HINTS and Materialized Views.
• Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands.
• Preparing documentation for all reports.

Environment: Oracle Database 9i, Developer Suite Forms6i/Reports6i, UNIX, SQL*Developer.

Confidential

Oracle Developer

Responsibilities:

• Coordinated with the business users to collect requirements.
• Prepared requirement specification document that gives the comprehensive details about the requirements worked on logical and physical data modeling.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data-mart.
• Participated in System test case preparation and execution.
• Prepared unit test cases and executed the same.
• Worked on tuning the SQL Queries for better performance.
• Performance tuning: Partitioning the fact tables and materialized views to enhance the performance.
• Developed Reports to extract the monthly sales information.
• Customized and developed Reports and Forms using Forms 6i and Reports 6i.

Environment: Oracle, SQL, PL/SQL, Developer/2000 (Forms 4.5, Reports 2.5), UNIX and Windows NT.