SUMMARY:

• Confidential has around 11+ years of experience as a Techo / Functional Consultant in developing ERP, migration, and customization of Oracle Apps E - Business suite 11i, r12.
• Worked-on development and customization of Oracle Apps components like Oracle Reports, conversions and interfaces in General Ledger, Account Payables, Account Receivables, Purchase Order, Order Management and Inventory Management, wrote several PL/SQL interface code, created several oracle reports as per user requirements.
• In depth knowledge of P2P and O2C Cycle.
• Experienced in understanding of rules, functions and logic involved in any business and accordingly mapping them to Oracle Apps.
• Strong Coding, testing & debugging Experience in ERP using Oracle Technologies.
• Excellent skills in developing packages, functions, procedures, stored procedures, triggers, tables, indexes, customized views, utilizing Oracle PL/SQL database programming and language.
• Having strong experience with the Oracle Relational Data Base Management System, writing stored procedures, SQL, PL/SQL and XML Publisher
• Excellent communication, inter-personal, analytical and documentation skills.
• Dedicated, hardworking individual with the intercommunication skills to work at different levels of the organization.
• Have decent understanding of AIM methodology(MD50, MD70 & BR 100 documents)

COMPETENCIES

Verticals: Finance, Manufacturing, Travel and Tourism and Telecom

Domains / Programming Skills: ORACLE Apps 11i and SCM (PO, OM, Inventory, iStore), Finance (AP, AR & GL) SQL, PL/SQL and Oracle Retail ReSA 12.0.5 Core Java, C, C++

Tools & Techniques: Toad, WinSCP, FileZilla Putty, ftp

Databases: Oracle 9i/10G

Software Tools: Developer 6i,2000(Forms & Reports), PL/SQL SQL*Loader, BI Publisher, Oracle Discoverer Work Flow

Operating Systems: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Technologies and Modules: Oracle Apps R12, PO, Inventory and Order Management and PL/SQL

Techno Functional Consultant

Responsibilities:

• Working as a single point of contact for clients and onshore team.
• In addition to technical responsibilities of support, also, handling a team of 5 members for Purchasing (PO), Order Management (OM) and Inventory modules.
• Involved in development & debugging of custom Oracle (RDF) and XML Publisher reports.
• Debugs/Monitors 6 interfaces (Standard as well as custom) on daily basis to maintain smooth functioning of project and Clearing all interface related errors as well.
• Creating Alerts to track recurring issues monitoring them and prepare detailed solution documents on critical issues.
• Proactively monitoring the batch jobs on a daily basis and also created automated script to log the errors and work on it before the client comes to know about it.
• Closely working on identifying issues and work with Development team to take them to closure.
• Conduct trial runs of programs and software applications to be sure, they produce desired information and the instructions are correct.
• Root Cause Analysis for the user’s issues & tickets.
• Identifying & analyzing BUGS in application.
• Correct errors by making appropriate changes and rechecking the program to ensure that the desired results are produced.
• Analyzing customer queries, working on defects, identifying root cause and providing solutions.
• Resolving critical production defects and providing workarounds/permanent fix. Involving in brainstorming for future implementation/release and current defects/improvements to collect estimates for requirements and delivery timelines.

Confidential

Technologies: Oracle Apps R12, XML Publisher, Report Developer, IBI, Discoverer and PL/SQL

Techno Functional Consultant

Responsibilities:

• Developing the custom report using IBI, Discoverer and XML Publisher. Worked on migration and customization of packages, procedures (API, Interfaces) for AP, PO and GL modules. Wrote control file to populate data into temporary tables using SQL*Loader utility.
• Created following custom reports: Open PO Report PO Status Report AP Find Sales Channels For PO's and Open Internal Requisitions
• Responsible for requirement analysis till creation of technical solution design and developing and delivering objects
• Involved in preparing documents for SysAdmin team for creating executable, concurrent programs, value sets and parameters etc for the interface developed.
• Worked on Production issues of P2P and O2C Cycles.
• Responsible to handle issue related to pick release, ship confirm and order creation through EDI, Interface and manually.
• Resolved standard open interface issue and resolutions.
• Wrote control file to populate data into temporary tables using SQL* Loader utility
• Resolved standard open interface issue and resolutions.(rcv transactions interface, mtl transactions interface and order import)
• Responsible for data migration from legacy system into oracle for GL, daily rates, supplier conversion, AP open interface, sales order open interface, PO open interface, on-hand quantities interface.
• Providing active support (UAT, Production Deployment and warranty support as a part of release) for Oracle reports.

Confidential

Technologies: Oracle Apps R12, Report Developer and PL/SQL

Technical Consultant

Responsibilities:

• Providing Functional Support for Oracle EBIZ at times (Done necessary setups including Profiles, Lookups, Menus, Personalization). Creation of test data as per the test cases.
• Worked on fine tuning several custom reports.
• High and Low Level Design preparation for generating user friendly O/Ps, providing necessary inputs and preparing MD070 (Technical Design) documents. Analyzing and deep diving into the core APIs of BI publisher and providing a custom solution to the problem.
• Development, modification and enhancement of financials (GL, AP, Payments, PO, iExpense, iProcurement), XML Publisher reports, including various reports for AP transactions, payments, audit, inter-company reconciliation, and PO analysis.
• Created below custom reports: Requisition Report, AP invoice Detail Report etc.
• Worked on following conversion

Confidential

Technologies: Oracle Retail 12.0.5 and Oracle Apps R12, Oracle 10 g

Techno Functional Consultant

Responsibilities:

• Solved production issue on integration between Oracle Retail and Oracle Apps Financials.
• Worked on P2P and O2C Cycle.
• Develop the loyalty package which is creating the *.csv file from retail database and ftped the file to the Inbound directory in Biztalk.
• Develop the outbound interface to extract the data from oracle applications base tables into flat files.
• Taking care of sales related activities such as Issue Resolution and RCA for the Issues, RCA of Sales Mismatch between the systems and Sales Reconciliation for ABRL.
• Resolved incorrect tax calculation issue occurring in various stores of ABRL at POS level thereby reducing tax payable of approximately 55 lac rupees and RC of which led us to a product bug in Navision POS.
• Providing ad-hoc reports based on business requirement for both ABRL
• Developing scripts on ad hoc basis to get the business process smoothened and automated to an extent in their daily activities.

Technologies: Oracle Application 11i, PL/SQL, Report6i

Confidential

Designer and Developer

Responsibilities:

• Development of code as per the business requirements
• Hard coded analysis for various RICE objects.
• Downloading and Uploading the *.ldt file for alert, value sets, Concurrent Programs, Request Group, Request Sets and packaged them in a zip file including shells scripts to migrate them in various instances and upgraded version (11.5.10) .
• Unit testing and system integration testing of the developed code.
• Creation of MD-70 documents.
• Providing fixes to the issues identified in testing phase.
• Packaging of the developed component to be deployed in production environment.
• Provide production support for the deployed project till it is stabilized.
• Received client appreciations for the projects I worked on.
• Develop the *.csv file through package using utl file package.

Confidential

Technologies: Oracle Applications, Forms 6i, Reports 6i

Techno Functional Consultant

Responsibilities:

• Interfaces Worked On GL Open Interface: Importing journals from legacy system into Oracle Apps.
• Done setups for new enhancement like adding Form Function, Menu, Creating Concurrent Program, Executables and Request Sets, adding the Concurrent Program to Request Groups.
• Development and Customization of new reports
• Adding and modifying the DFF, Creating user tables, Creating Lookups, Creating Alerts, Creating Messages
• Trained end users in Oracle General Ledger & Oracle Payables prepared the documents.
• Handling Technical design and Development of Oracle E-Business Suite custom application.
• Creating value sets, request sets and setting profile options.
• Defining concurrent programs, executables and Flex field structures.
• Worked on Procure to Pay Cycle.

Confidential

Technologies: Oracle Applications, Forms 6i, Reports 6i

Techno Functional Consultant

Responsibilities:

• Involved in Forms and Reports development, registration and customization from various modules.
• Development of Interfaces and Conversion to validate and load data from legacy and feeder system to Oracle applications
• Design and Developing Descriptive flex fields. Concurrent program and Concurrent Program Executable value sets, look ups, alert, profile and message dictionary. Register Function and Menu Creation of Application users and Responsibilities.
• Write code in PL/SQL using Coding standards and APIs in Oracle applications.
• Importing Information into Oracle Applications through SQL* Loader.
• Table creation, table handling, writing stored procedures, function, Packages, database trigger, indexes and packages.
• Worked on Order to cash cycle.
• Functional Expertise to provide expert consultancy on integration and functionality of GL, AP, PO Modules in Oracle applications.
• Good Knowledge about P2P Cycle.
• Prepare Set up Documents and Trained end users.
• Post Implementation Support.

Confidential

Technologies - Oracle Applications, Forms 6i, Reports 6i

Technical Consultant

Responsibilities:

• Creating Control Files to load data from Flat Files
• Involved in coding logic for interface program for invoice interface (Payable Open interface).
• Followed the Coding standards while doing the Customization according to the Client requirement.
• Development of re-usable objects likes objects libraries, program units.
• Development of standard template for reports.
• Development of stored procedures and visual attributes for GUI
• Query option was provided as per user requirements
• Wrote PL/SQL Libraries, Packages, Sub Programs, Cursors and Trigger.