PROFESSIONAL SUMMARY:

** ***** ** ********** ** Techno-Functional consultant in Oracle E-business suite 11i/R12 with extensive knowledge and experience in implementation, customization, interfaces, conversion, integration, upgrade/migration, designing/developing extensions to Oracle Applications and hands on experience with Production Support.

Extensively used Oracle Apps Financial and Distribution modules like Inventory, Order Management, Purchasing, Accounts Payables, Receivables, General Ledger, Fixed Assets, iExpenses, iProcurement, Project Costing and shared HRMS.

Strong hands on experience in Application System Administration. Activities like user setup, defining responsibilities, values sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs and providing support to apps users for any Technical or functional issues.

Experience with PTP (Procure-to-pay) and OTC (Order-to-cash) business process scenarios with full cycle implementations, upgrade and support projects.

Extensive experience in working with PL/SQL Stored procedures, triggers, packages using Oracle 10g/11g database, Performance tuning.

Experience in Development and Customization of Reports/XML Publisher/Discoverer/Alerts/AME API.

Expertise in Design, Development and Customization of RICE (Reports, Interface, Data Conversions and Extensions/Workflows) using SQL, PL/SQL and SQL*Loader.

Worked on OAF components and SHELL Scripts for Automation

Experience in RevPro Revenue Application, Tax Engine Sabrix and Markview Kofax

Extensive experience in development of Custom Forms using Template.fmb, customization of existing Oracle forms using Custom.pll/Forms Personalization.

Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.

Worked in all aspects of Software Development Life Cycle including System Analysis, Software Design, Development, Implementation, Testing and Support.

Very Good knowledge and working experience on credit card interfaces and SOA integration.

Assisted project manager in defining project scope, time & effort estimates and deliverable management.

Excellent analytical and critical thinking, creative problem solving, quick learning, interpersonal and client interfacing skills.

TECHNICAL SKILLS

ERP : Oracle Applications EBS 11i and R12

Modules : General Ledger, Accounts Payables, Account Receivables, Project Costing, Fixed Asset, Purchasing, Inventory, Order Management, iExpenses, iProcurement, Shared HRMS.

Processes : Procure to Pay, Order to cash

Operating Systems : UNIX, Windows

Database : Oracle 10g/11g

Project Mgmt Tools : Microsoft Project

Configuration Mgmt Tools : Clear Case, SharePoint and Kintana

Tools and Utilities : Oracle Discoverer 9i/10g, XML Publisher, SQL * Loader, Toad, SQL *plus, Forms 6i/9i/10g, Reports 6i/9i/10g, Workflow builder and JDeveloper

Languages : C, SQL, PL/SQL, Java

Web Languages : HTML, XML

Client: NetApp, CA Sep 2013-Present

Project: Support

Summary: NetApp Inc. provides network Storage solutions that enable virtualization, cloud computing and storage efficiency to improve efficiency, agility and big data. I am working on support issues which are raised by users. It’s related to Finance, Project Accounting and Customer Data Hub modules. It includes Markview, Sabrix, Revpro and Discoverer etc.

Environment: Oracle E-business suite iProcurement, iExpense, PO, AP, AR, GL, FA, PA, OM, INV, Shared HRMS

Responsibilities:

Worked as Onsite support technical lead and co-ordinate with offshore team for support activities.

Worked on day to day support tickets and meets the SLA timings

Provide MONTH End/QTR End support to the users for closing the periods for AR, AP, FA, REVPRO and GL

Worked on the issue related to AP Payment Batches confirmation

Worked on the issue related to Expense report creation and invoice creation against expenses.

Worked on the AR, AP, GL Interface error corrections

Worked on the AP Credit Card load process issues

Worked on the AR Invoice Import Stuck due to Sabrix issues

Worked on the Journal reversal and approval issues

Worked on Fixed Asset Depreciation program issue.

Worked on ERP to Hyperion data extract issues.

Worked on General ledger transfer program

Worked on AR Receipts stuck in Aceva collection tool.

Worked on Iexpense and Iprocurement approval issue

Worked on ERP to EBI data sync up

Worked on customer merge

Worked on PR Approval workflow and Auto PO related issue.

Worked on employee and user creation issues in ERP HRMS, these data flows from PeopleSoft

Worked on PO XML Report and AR Invoice PDF generation report and storing in ECM Application.

Involved in the tuning of 11i applications (includes PL/SQL, SQL scripts) using explain plan and TKPROf.

Worked on Standard and Customization components bug fixes.

Worked on CMAT Interface issue

Worked on Markview batch process.

Worked on undo accounting AP Issue.

Worked on discoverer report issues.

Worked on pay on receipts Invoice issue.

Worked on system improvement activities and providing value adds to clients.

Worked on Sabrix, 170 Markview applications

Debugging REQAPPRV, APEXP workflows.

Clearing interface errors in month end periods.

Worked on bug fix on oracle patches.

Worked on WEBADI Journal issues.

Worked Revenue RevPro Application issues.

Client: Brocade Communication Systems, CA Dec 2008-Aug 2013

Project: Development/Migration

Summary: Brocade Communications Systems, Inc. is an American technology company specializing in data and storage networking products. I have worked on revenue code stamping, Hyperion data extract,

Allocated corporate sell thru ADF and road runner project migration.

Environment: Oracle E-business suite iProcurement, iExpense, PO, AP, AR, GL, FA, OM, INV, Shared HRMS

Responsibilities:

Involving in the requirement study, estimation, design and development.

Developed outbound Interfaces from OM, AR and GL Data to Custom tables.

Developed PL/SQL Matrix Operational Report.

Involved code review and performance improvement.

Worked on OAF Customization like VO extension, Search Page LOV creation and Personalization.

Worked on XML Reports

Developed Employee Rate Schedules Interface from HRMS to Projects

Developed IT Employee Extract, IT Projects, Rate Schedules Extracts to Hyperion Team

Shell Scripting using SCP Command from one server to another server

Data Base Modeling and preparing data flow diagram.

Defining Quick Codes, distribution lists and Descriptive Flex fields.

Developing ACST processing logic using Oracle PL/SQL.

Implement ADF security and integrate with Oracle E-Business suite.

Testing and code review for other team members.

Developing components for the workflow, conversions and XML reports.

Worked on E-Biz modules like iExpense, AP, AR, GL, FA and PO Components.

Worked on AR invoice XML report.

Worked on AR invoice conversion and PO conversion.

Mentor to fresher’s in the team.

Worked on international sabrix project

Involved testing on big patch implementation project.

Client: Indo Count, India May 2008 - Oct 2008

Project: Implementation

Summary: Indo Count Industries Ltd. Is a India based manufacturer and exporter of cotton yarn and knitted fabrics in both greige And dyed form. We have implemented Oracle Applications R12 for Indian localization for Manufacturing, Sales and Finance Modules.

Environment: Oracle E-business suiteR12 PO, AP, AR, OM, INV.

Responsibilities:

Developing and customizing reports, Form Personalization and XML Publisher Reports in modules OM and AR.

Customized Supplier PO Account Generator Workflow.

Worked on Item conversion and update items interface.

Worked on check printing report.

Worked on Project Costing API

Calling API Package dynamically whenever changes from front end.

Helping to team by writing Customer Bill to address Query

Developed AP Prepayment report.

Client: W N S Global Services, India Dec 2007- Apr 2008

Project: Imodules Implementation

Summary: WNS Global Services is a recognized leader in business process outsourcing (BPO). Implemented position hierarchy approvals for transaction of imodules.

Environment: Oracle E-business suite 11i, iProcurement, iExpense, iReceivables and FA

Responsibilities:

Developing and customizing interfaces, HRMS API interface, AME approval package, reports, alerts

Worked on modules like iProcurement, iExpense, iReceivables, Shared HRMS, AR and FA Queries

Worked on Position Hierarchy Setup and AME Rules creation and package calling.

Worked on D2K Reports for AR invoice report, AP check printing.

Worked on fixed asset reports.

Worked on discoverer reports.

Customized Oracle extension package.

Fixed asset register report

Client: Mitsubishi, India Mar 2007- Nov 2007

Project: Implementation

Summary: Mitsubishi is one of the leaders in the manufacturing industry. This Project was to implement oracle applications 11.5.10 at client location in Indian localization. Implementation was performed in core business areas such as Manufacturing, sales and finance.

Environment: Oracle E-business suite 11i HRMS, PO, AP, OM, INV, BOM, WIP, AR and GL

Responsibilities:

Developed and customized Reports of PO, INV, OM, AR, AP, GL Module and Conversions.

Extensively worked on Discoverer Reports

Worked Item Conversion, Supplier Conversion.

Worked on the technical team responsible for the technical aspects

Helped to OM Conversion API Solution.

Worked on Purchase Order Update using API.

Developed AP payment report.

Client: Kotak, India Sep 2006- Feb 2007

Project: Support & Development

Summary: Kotak Mahindra is one of India's leading financial conglomerates, offering complete financial solutions that encompass every sphere of life. From commercial banking, to stock broking, to mutual funds, to life insurance, to investment Banking, the group caters to the financial needs of individuals and corporate. This project was to customize existing Oracle applications 11.5.10

Environment: Oracle E-business suite 11i HRMS, PO, AP.

Responsibilities:

Developed and customized Reports for HRMS Modules Offer letters and production support.

Prepared Unit Test cases, Installation scripts, Preparation of rollout Document.

Worked on Alerts and Customer Invoice report and Sales order report.

Worked on D2K Complex Reports.

Support the customized reports issues.

Reverse the termination of employee records.

Involved in Development of Item master, Supplier Master interfaces

Worked on Functional and technical documents

Worked on Periodic and Event Alerts.

Contact this candidate