SUMMARY

• Over 12 years of IT experience which involves developing Oracle custom applications and performing Oracle E Business suite design, development, upgrade, production support and functional testing projects of Oracle ERP (EBS) R12 and 11i which includes Oracle Financials (GL, AP, AR, FA, PA and Cash Management), SCM (OM, PO, INV), Procurement (iProcurement and iSupplier Portal), OLFM (Oracle Lease Finance Management) and CRM (Service Contracts, Install base, Field Sales and Tele Sales).
• Expertise in implementing RICE (Reports, Interfaces, Conversions, Extensions) components in the area of technical design, development, Integration testing and deployment.
• Work experience in PL/SQL, Oracle Developer Suite (Forms/Reports), XML/BI Publisher, OAF, Personalization, Workflow, Web ADI, Unix Shell scripting, Application Developer and System Administrator responsibility tasks.
• Solid understanding of Oracle EBS database/table structures and the integration and impacts between modules.
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Adapting to the business process and design, development of the custom requirements to fulfill the business needs.
• Good working experience in modeling, automation, and continuous improvement of business processes, routing information of any type according to user - defined business rules using Oracle Workflow.
• Good understanding of Oracle Applications Architecture.
• Proficient in understanding the concepts and hierarchical structure of Multi Org.
• Hands-on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, workarounds, interfaces, user training.
• Hands on experience in development and customizations of XML and BI Publisher Reports using RTF and Excel Layout design.
• Good Expertise in Customization (Custom.pll), Alerts and Personalization of oracle Forms
• Well Versed with process flows like Application to Booking, Invoice to Receipt and Quote to Termination in OLFM.
• Well versed with process flows like Procure to Pay and Order to Cash.
• Good Expertise in TCA Architecture and API Programming.
• Experience in the preparation of Functional Design, Technical Design documents and System Test scripts for Extensions, Data Conversion/Migrations, Inbound / Outbound interfaces, Reports, Forms and Customizations.
• Strong programming experience in creating stored procedures, APIs, packages, functions, triggers, views, collections (nested tables and arrays), records, sequences, materialized views, constraints and other database objects using SQL scripts and PL/SQL and also experienced in fine-tuning code for better performance.
• Excellent knowledge of AOL (Application Object Library) and System Administration Modules
• Expertise in using tools like TOAD, SQL *PLUS, SQL Navigator, SQL Developer, WINSCP, UNIX, SQL*Loader, Forms builder, Reports builder, Kintana, Remedy, Quality Center, CA SCM and Service Now.
• Experienced in Reporting and Tracking Defects by using Bug Tracking tool such as Quality Center
• Absolutely capable of working in a fast paced, dynamic, team-oriented environment with 24x7 support.

TECHNICAL SKILLS

• Domain: Telecom, Net working, Insurance, Research and Gaming
• ERP: Oracle Applications EBS 11i 11.0.3, 11.5.9, 11.5.10.2, R12 12.0.3, 12.1.3
• Oracle Apps Modules: OLFM(Oracle Lease and Finance Management), Financials(GL,AP,AR,CM and PA), SCM(OM,PO,INV), CRM( Service Contracts, Install base, Field Sales and Tele Sales) and Procurement (iProcurement and iSupplier Portal)
• Database: Oracle RDBMS 8.x, 9.X & 10G
• Software Tools: Developer 2000, Discoverer, XML/BI Publisher, RDF Reports, Forms Builder, Workflow Builder, JDeveloper, WEB ADI, SQL, PL/SQL & Oracle SQL Loader, Kintana, PVCS, CA SCM, SVN, Artifactory, Service Now,Quality Center and AOTS
• Operating System: Windows NT, UNIX, Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, Shelton, CT

Technical Support Lead

Scope: Oracle R12 Production Support

Environment: Oracle Applications 12.2.3, SQL, PL/SQL, Workflow Builder, SQL Loader, SQL Developer, Unix, SVN, Putty, WinSCP3 and Remedy.

Modules: OLFM, AR and GL

Responsibilities:

• Working with business users and resolving tickets which are raised by them as part of day to day business transactions.
• Address Daily Lease contracts status report issues which are flowed from other systems to oracle OLFM.
• Good knowledge of Lease Contract Authoring/Booking, Good understanding of Rebook, Transfer and Assumption, Renewal, Release and Upgrade processes.
• Implementing code changes if required as part of bug fixing in production support activities.
• Involved in Month-end activities and worked on Quote creation and update print lead days APIs in OLFM.
• Fixed critical performance issues of Daily scheduled jobs which are running long as part of production support.
• Performed end to end testing of Customizations, Unit Testing and Integration testing.
• Worked on Quote creation issues when quotes are pulled by different systems from oracle OLFM system.
• Worked on fixing of OLFM Credit memo issues and customer bill to, ship to and install site address issues.

Confidential, Atlanta, GA

Support Lead

Scope: Oracle R12 Production Support

Environment: Oracle Applications 12.1.3, SQL, PL/SQL,Forms6i, Reports 6i, XML/BI Reports, Workflow Builder, AOTS, Alerts, Unix Shell Scripting, PVCS, Putty, WinSCP3

Modules: PO, OM, AP, AR and GL

Responsibilities:

• Working with business in understanding business requirements and translating them to system requirements and functional specifications.
• Developed interface program to transfer sales order cost to project accounting
• Performed the whole Order Cycle, which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order
• Developed a program using Oracle standard APIs to customize splitting of delivery detail lines order management
• Order Import functional changes to update store location ILN as delivery address in oracle apps.
• Involved in Unit Testing, Testing Customization and Integration testing.
• Conducted User Acceptance Testing (UAT) sessions with Business Users, Financial Users and Purchasing Users
• Proficient in designing and requirements for RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion, Data Migration
• Developed, coordinated, and implemented plans to test business and functional processes and quality assurance testing.
• Raising SR's on critical R12 Implementation issues and following up with Oracle, Code Migration / Testing / Implementations on all the PO / AP / OM related issues, and supporting deployment of the new functionality and help production support in resolving issues in production
• Documented standards and procedures, Developed product documentation and training materials.
• Business process mapping with all standard and customized modules.
• Processing of Vendors, Vendor Sites, and Banks details as per the client requirements
• Assisting Business for Business Acceptance Testing and obtain Sign off
• Trouble shoots questions/problems from the user community with Oracle Application issues.
• Handling on Post Implementation supports and Patches updates to the custom modules and components.
• Other responsibilities included: supporting users, diagnosing and resolving problems, implementing solutions and documenting business processes.
• Heavily involved in customization of RICE objects including Data Migration.
• Supported the month-end close process
• Developed lot of SQL scripts for data validations and reconciliation.
• I was also involved in migrating the existing responsibilities, users and custom objects in the instance consolidation project.
• Developed few screens and customized the existing Seeded Forms per the Business Requirements.
• Customized some Seeded Workflows and created some new Workflows using workflow builder tool.
• Helped business identify and reconciliation of the data for the defects that in the system that caused lot of issues.

Confidential

Team Lead

Scope: Oracle R12 Implementation

Environment: Oracle Applications 12.1.3, SQL, PL/SQL, Reports 6i, XML/BI Reports, Workflow Builder, OAF, Unix Shell Scripting, PVCS, Putty, WinSCP

Modules: OLFM, AR, Service Contracts and Install Base

Responsibilities:

• Managed a team of 10 offshore developers - task allocation, monitoring the development, acted as a liaison between functional consultants and development team
• Developed various Custom reports, Customized existing reports according to the functional specifications using Reports 10g and XML publisher with template as RTF, EXCEL
• Analyzed the existing system and made changes to the design that helped the company to develop many reports that were very useful to the top level management
• Resolving the defects which are raised during UAT phase and updating the defect status in Quality Center tool.
• Testing OLFM flows like Application to Booking, Invoice to Receipt and Quote to Termination as part of BI Publisher Reports SIT Testing.
• Lead the development team and driven the User Acceptance Testing for signoff.
• Version controlling thru SVN and migrating solutions to test and production instances thru KINTANA.
• Did many enhancements to the existing program that needed the changes for business requirements?
• Creating flows like Application to Booking, Invoice to Receipt and Quote to Termination to test different scenarios as part of unit testing.
• Developed a lot of new programs and made changes to the existing programs for quarterly and monthly releases.
• Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system. Developed a program to inactivate the vendors
• Fixing defects which are raised in Quality Control tool as part of UAT testing.
• Registered the Concurrent Programs, Forms, Reports and Requests Sets in AOL and System Administration
• Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL. Extensively participated in developing technical documents (MD70)
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements

Confidential

Oracle Techno-Functional Consultant

Scope: Oracle R12 Implementation

Environment: Oracle Applications 12.0.3, SQL, PL/SQL, Reports 6i, XML/BI Reports, Workflow Builder, OAF, Unix Shell Scripting, PVCS, Putty, WinSCP

Integration Tool: iStudio

Modules: AR, GL, Tele Sales and Field Sales

Responsibilities:

• Analyzed Internal & External Source systems, Functional Business Documents, and Reporting Requirements
• Developed Taurus Inbound interface to bring the SME customer data into eQ to make them avail of special discounts, rebates and to earn loyalty points.
• Developed Data Integrity XML Report to measure KPIs of customer data of account managers and sending the output of report by email.
• Responsible for working with Oracle product support team on Production critical issues to ensure quick resolution.
• Document & communicate changes throughout the user organization, supporting change management & compliance.
• Customized e-Business Center form by using Custom.pll and Form personalization
• Developed new XML Reports, Discoverer Reports and Customized oracle standard RDF reports as per business requirement.
• Customized Standard Service Request Form in Tele Sales using CUSTOM.pll files and form personalization
• Lead and coordinated end to end support for Performance Test, Load Test and Smoke Test walkthrough of functional flow of application and review test scripts prepared by the team for quality and functionality
• Customized Service Request workflow to generate the authority number for FREEQUENT INSURER service request type
• Involved in the migration of Reports by making necessary PL/SQL changes to the reports
• Tracking, coordinating, revisiting the plan as required, executing and monitoring the project progress
• Developed inbound and outbound interface for SME customer data from PRIME system to eQ Quest
• Have done Form personalization in telesales and OAF page personalization in Sales online as per business requirement