SUMMARY:

• 5 Years of experience in Information Technology, involving in Design, Analysis and Implementation of applications using Oracle Applications and Oracle Development tools
• Extensively worked in Oracle Applications Release 11i Modules – Inventory (INV), Purchasing (PO), Order Management (OM), Accounts Receivables (AR), Account Payables (AP), General Ledger (GL), Bill Of Materials (BOM), Shipping (WSH), Oracle Process Manufacturing (OPM), Service Contracts
• Designed and customized reports as per the business requirements using Oracle Reports 6i/9i and Discoverer 9i/10g
• Designed and customized reports using XML Publisher in AP, PO, INV and AR modules
• Worked on the Order-to-Cash and Procure-to-Pay process flows
• Worked on various customizations and created reports, subscriptions on noetix reporting tool
• Extensive experience in Implementation, Customization, and Support for Oracle Applications using Oracle development and reporting tools like SQL*Loader, PL/SQL, TOAD, SQL*Plus, Reports 6i and Discoverer 9i/10g
• Interact with various business users and translate functional requirements to technical specifications
• Proficient in building reports in Discoverer 9i administrator including maintenance of Business Areas and Work Books
• Extensively worked on PL/SQL Stored Procedures, Functions, Stored Packages, Database Triggers, and knowledge of various PL/SQL packages
• Worked extensively with development team members in resolving issues by creating TAR(s) and obtaining one-off solutions
• Experience in trouble shooting EDI issues and mark view images
• Experience in writing design documents (AIMS) MD50s and MD70s
• Experience in Application System Administration activities like registering Concurrent Programs, application user set up, defining responsibilities, value sets and registering reports
• Proficient in understanding client’s needs and generating, modifying existing customized reports according to the requirements and specifications
• Demonstrated ability to work as part of a team with aggressive time schedules

Skills Summary:

Oracle Applications

Oracle Applications 11i - PO, AR, AP, GL, OM, INV, OPM

Operating Systems

MS-DOS, UNIX, Sun Solaris 2.6, LINUX, Windows XP/NT/2000/98/95

Languages / Tools

SQL, PL/SQL, SQL*Plus 9.0, SQL*Loader, C, C++, Toad 8.0

RDBMS

Oracle 9i/8i, SQL Server 2000

GUI Tools

Reports 6i/9i, XML Publisher, Discoverer Administrator 9i/10g, Crystal Reports 8/9, MS Visio, Noetix

Certifications:

• Certified in Noetix Views Customization.

Professional Experience:

Confidential,California – July 2009 to Present
Oracle Applications Business Systems Analyst

Responsibilities:
As a team member, responsible for various reporting needs in OM, INV, AR, AP and OPM modules and provide solutions based on the business and user requirements

• Worked on noetix reporting tool as an administrator and responsible for creating and maintaining the folders.
• Involved in the analysis, design, planning and implementation phase of various projects and responsible for gathering requirements from business users and technical development
• Worked on noetix platform and responsible for creating various noetix reports and perform maintenance activities like full regeneration of views, security only regeneration in metabuilder
• Worked on upgrade of noetix views from 5.8.3 to 5.8.6 and customize them based on the user requirements
• Customized various pl/sql packages based on the business and user requirements in AR, AP and PO.
• Worked on upgrade of Noetix platform from 5.6 to 5.7 and supported post upgrade issues
• Developed reports using sql and pl/sql and created subscriptions in Noetix to deliver on a specific day and time based on the user requirements
• Trouble-shoot production issues by debugging the code and make changes accordingly
• Interacted with various business users to understand the requirements and troubleshoot the issues
• Interacted with various business users to understand the requirements and provide solutions accordingly
• Resolved many production support issues when the noetix user interface went down by starting the services and tracking the event log
• Created noetix dashboards to view the variations in business operations and provide recommendations to improve the business
• Customized various pl/sql packages based on the business requirements in OM, AR and INV modules
• Worked on customizing and developing various discoverer reports based on user requirements in OM and PO modules
• Worked on designing various XML Publisher reports by creating data templates and XML files in

AR, AP modules

• Created users, roles and shared the reports based on the security to the users
• Created ad hoc workbooks using Discoverer plus, Discoverer desktop and shared the workbooks with the designated users only
• Supported in-house migration project to go-live and supported post go-live issues
• Working on the customizations in compatible with R12 as we are in the process of upgrading Oracle EBS from 11.5.10.2 to R12.1.3

Environment: Oracle Applications R11.5.10.2 (OM, AR, PO, AP, GL, INV, OPM), Oracle 11g, R12.1.3, Reports, Noetix, Discoverer, XML Publisher, Unix, PL/SQL and Toad 8.0

Confidential,Pennsylvania – October 2008 to June 2009
Oracle Applications Technical Consultant

Responsibilities:
As a team member, responsible for various Production support activities in AR, INV, WSH. Worked on various EDI issues, customization of pl/sql packages and procedures, oracle reports, running jobs for mark view images and performed various system administration activities

• Customized various pl/sql packages based on the business and user requirements in AR, INV, AP, PO.
• Resolved many EDI issues comparing the EDI and data warehouse tables and troubleshooting the data missing in the data warehouse tables and verifying the data in both the tables
• Resolved the invoice rejection issues in the EDI data files, corrected and updated the data accordingly in the EDI tables in Production
• Involved in gathering business requirements from users and responsible for technical development
• Trouble-shoot production issues by debugging the pl/sql packages and make the code changes accordingly
• Interacted with various business users to understand the requirements and troubleshoot the issues
• Running the job for mark view image files, check the log files and troubleshoot issues with the attachment of the images and data in the files
• Registered customized applications, Programs, Executables and created various request sets based on the requirements
• Developed a complex report to manipulate the credit memo’s, adjustments, invoices and balance out the amounts in the AR distributions table and the custom Scripnet table based on the business requirements
• Designed a unix shell script to remove the header, trailer or both in the zip files and ftp the modified file to another server according to the user requirements
• Designed a technical specification document for the DBLink usage of the in-active databases used by various packages and procedures
• Worked on Vantive tool box and Kintana to create tickets, to respond on user requests, get approvals for move-up of customized reports to Production

Environment: Oracle Applications R11.0.3 (AR, INV, AP, GL, PO), Oracle 9i, Reports, Sun Solaris, PL/SQL and Toad 9.0

Confidential,Phoenix – June 2008 to October 2008
Oracle Applications Technical Consultant

Responsibilities:
As a team member, responsible for conversion of data in AP and INV based on the business and user requirements by validating the data using pl/sql packages and procedures and perform system administration activities

• Designed technical specifications document (MD 70) based on functional requirement specifications document (MD 50)
• Interacted with the functional team and business users to understand the business requirements
• Responsible for the extraction of Supplier Sites into a flat file according to the business and user requirements
• Developed scripts using Oracle SQL*Loader and UTL_FILE utilities
• Developed a SQL*Loader program, which will populate the data from a flat file into a staging table and registered that as a concurrent program
• Developed pl/sql program to perform validations before loading the supplier sites from staging table into AP_SUPPLIER_SITES_INT interface table
• Used Supplier Sites Open Interface program to load Supplier Sites in Oracle Payables
• Developed pl/sql packages and procedures to validate and load the On hand Quantity data into MTL_TRANSACTIONS_INTERFACE and MTL_TRANSACTION_LOTS_INTERFACE tables
• Used Process Transaction Open Interface program to load the On hand Quantity data in Oracle Inventory
• Worked in the support system, performed the responsibility of system administration which involved creating users, setting up the user profiles, registering and managing the concurrent programs
• Involved in developing new Lookup Types, DFF’s, Value Sets and Values for supporting the reports developed
• Customized various PL/SQL packages and worked on converting these packages and various

Oracle 6i reports into XML Publisher reports

• Registered customized applications, Programs, Executables and worked extensively in creating Value Sets and Request Sets

Environment: Oracle Applications R11.5.10.1 (AP, PO, INV, AR, GL), Oracle 9i, Reports, XML Publisher, UNIX, PL/SQL, SQL*Loader and Toad 8.0

Confidential,Wisconsin – August 2007 to May 2008
Oracle Applications Technical Consultant

Responsibilities:
As a team member, responsible for designing and customizations of various Oracle and XML Publisher reports, packages, procedures and functions in OM, PO, AR, INV and MRP modules based on the business and user requirements

• Designed and customized various Oracle reports in OM, AR, INV, PO, BOM
• Worked on designing various XML Publisher reports by creating data templates and XML files in

AR, WSH and OM modules

• Prepared technical specifications document (MD 70) , test scripts (TE20) and deployment documents (MD120) based on the functional requirement specifications (MD 50)
• Customized various PL/SQL packages and worked on converting these packages and various

Oracle 6i reports into XML Publisher reports by creating data templates

• Interacted with the functional team to understand the business requirements and worked with the

users in testing the reports
Designed XML Publisher reports in AR, MRP and OM modules:

• Customer Credit Card Payment By Date Range Report
• Planned Order Extract By Vendor Report
• Milwaukee Public Schools Invoice Edit Report

Worked on designing various XML Publisher reports using oracle functions in the data

• templates according to the business requirements

Customized various oracle reports 6i in OM, PO modules:

• Daily Credits Report
• PO Experience Export Report
• Orders Extract Summary Report

Analysis of all scenarios an order line can go through, and issues that may occur during the full lifecycle of an order
Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer

Environment: Oracle Applications R11.5.10.2 (OM, AR, INV, WSH, BOM, MRP), Oracle 10g, UNIX, Reports 6i, XML Publisher, PL/SQL, SQL Developer

Confidential,California (Confidential) – Jan 2007 to July 2007
Oracle Applications Technical Consultant

Responsibilities:
Worked as a Technical Consultant for new Oracle Applications Implementation. Customizations include Oracle reports, Discoverer reports, packages, procedures, functions and custom tables
Interacted with the functional team to understand the business and user requirements
Worked on building Business Areas, Discoverer Workbooks and parameterized reports for the Modules INV, PO and OM using Discoverer 9i
Built Workbooks in Discoverer 9i and edited the existing workbooks by adding additional functionality (conditions, calculations, parameters, sorting, etc.) and scheduling workbooks for a user
Involved in verifying the leads, opportunities, quotes and orders using Sales Online
Worked on Order-to-Cash and Procure-to-Pay process flows
Designed and customized reports using Oracle Reports Builder 6i in OM and Service Contracts:

• Sales Order Report with Contract Details
• Holds Release Report
• Product Transaction Listing by Product

Interacted with users to design and develop the interface from legacy and third party system to Oracle Application release 11i
Used SQL *Loader control file to import the customer information provided in the form of flat files into staging tables
Worked on designing various XML Publisher reports by creating data templates and XML files in PO, AR, INV and OM modules
Registered XML Publisher reports using System Administrator and Application Developer
Developed PL/SQL program to perform validations and to relate customers with addresses, contacts, banks and profiles and move the data from staging table to interface tables
Used Customer Interface standard program to load customer details in Oracle Receivables
Designed and customized reports using Discoverer 9i in AR and OM:

• Product Transaction Listing by Customer
• Daily/Weekly/Monthly Sales Order Report
  

Environment: Oracle Applications R11.5.10.2 (OM, PO, AR, INV, BOM), Discoverer 9i, Oracle 9i, UNIX, Reports 6i, PL/SQL, SQL*Loader and Toad 8.0

Eagle Global Logistics, Houston, Texas (for Swaray’s Inc) – Jan 2006 to Jan 2007
Oracle Applications Technical Consultant

Responsibilities:
As a team member, responsible for full-life cycle implementation of Oracle Applications 11i- Modules PO, AR and INV. Customization of various Discoverer and Oracle Reports based on the business and user requirements

• Involved in system study, requirements analysis, gap analysis and design documentation
• Prepared technical specifications document (MD 70) based on the functional requirement specifications (MD 50)
• Worked on Oracle Discoverer Admin for creating item classes, custom folders and parameterized reports for AR and PO modules
• Extensively worked on Format Triggers, Formula Columns, Summary Columns and Placeholder Columns for developing the reports using Oracle Reports Builder 6i
• Designed and customized reports like New Customer Setup Report and Contract Price List Report using Oracle Reports 6i
• Registered customized reports and concurrent program/sets using System Administrator and Application Developer
• Imported the source data from an existing application into staging tables using AXE Engine (custom process)
• Developed PL/SQL packages and procedures to validate and move the data from staging tables into PO interface tables
• Used Import Standard Purchase Orders and Receiving Transaction Processor interface programs to create purchase orders and receipts in Oracle Purchasing

Environment: Oracle Applications R11.5.10 (PO, INV, AR), Discoverer 9i, Oracle 9i, LINUX, Reports 6i, PL/SQL, SQL*Loader and Toad 8.0

Education:

Master of Science

Bachelor of Technology
(Electronics and Communication Engineering)