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.
• Worked on 3 ebs implementations and 2 ebs production support projects.
• 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,12.2.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 Functional Lead

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

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.
• Led the technical team on Inventory and Payables RICE components deliverables
• Developed Customer Conversion to get legacy customer data into Oracle EBS.
• Implementing code changes if required as part of bug fixing in production support activities.
• Addressing contract update issues like Customer Privilege, SBR, etc.
• Developed Credit Memo application program to apply on AR Invoices.
• 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.
• Developed AR Auto Invoice interface program to process invoices from SAP.
• Good Understanding Lockbox interface program.
• Proper documentation of the product developed and verification of the RICE products developed by the team as reviewer.
• 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

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

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
• Developed AP invoice conversion program to transfer the data from legacy into oracle ebs.
• 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

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

Responsibilities:

• Managed a team of 10 offshore developers - task allocation, monitoring the development, acted as a liaison between functional consultants and development team
• Developed variousCustom reports, Customized existing reportsaccording to the functional specifications usingReports 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.
• Worked on new implementations of RICE and customization of existing RICE components and enhancements.
• 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.
• Managed a small support/development team supporting daily business needs and develop RICE components. Played dual role of manager and developer/analyst
• Worked onAuto Invoice Interface Programto validate and load credit memos, debit memos and invoices from legacy system. Developed a program toinactivate the vendors
• Fixing defects which are raised in Quality Control tool as part of UAT testing.
• Registered theConcurrent Programs, Forms, Reports and Requests Sets inAOLand 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 developingtechnical documents (MD70)
• Extensively involved inSQL tuning, troubleshooting, debuggingand fixing the code and made the changes according to the new business requirements

Confidential

Oracle Techno-Functional Consultant

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

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.
• Worked on new implementations of RICE and customization of existing RICE components and enhancements.
• 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 testscripts 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

Confidential

Oracle Techno-Functional Consultant

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

Responsibilities:

• Responsible for Implementation, support and managing different third party applications.
• Gathering, refining, and documentation of the business rules, functional and technical requirements
• Developed new PL/SQL procedures, functions and Packages
• Involved in Code and AOL programs migration to CRP testing environment from DEV
• Raised Oracle SR with Oracle for problems that needed Oracle Assistance; followed up on SRs and implemented solution given by Oracle
• Developed and Customized PL/SQL Reports
• Worked as a configuration manager for this project that involves tracking versions of all documents and maintaining all configurable objects like code and other artifacts related to all RICE objects.
• Involved in migration of stored procedure/triggers/packages and functions
• Customized interface program to send out one single notification every run for all the delivery numbers with errors, instead of sending one email notification for each Delivery Number.
• Performed the whole Order Cycle, which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order
• Understanding the integration of custom applications with Oracle Apps and troubleshoot issues.
• Deployment of production data fixes to production instance
• Experience in working with Oracle Utilities like SQL*Loader, UTL FILE Package and Interfaces. Analyze the technical problems in the system and come out with the most feasible solution provide users with the necessary documentation for entering the transaction into the system using the correct stored procedure
• Developed and Customized PL/SQL Reports

Confidential

Oracle Techno-Functional Consultant

Environment: Oracle Applications 11.5.10.2, SQL, PL/SQL, Reports 6i, XML ReportsPVCS, Putty, WinSCP

Responsibilities:

• Prepared MD070 Technical Design Documents and MD120 Installation Instruction Documents for various RICE objects as per RICE components design and build standards of AIM methodology.
• Understanding the integration of custom applications with Oracle Apps and troubleshoot issues.
• Responsible for new deployment/enhancement in Reports, pl/sql interfaces, shell programs, Custom interfaces.
• Worked on creating adhoc Discoverer Reports on the E-Business Suite modules.
• Developed programs for extracting PO and Receipt Data from Oracle purchasing.
• Involved in complete lifecycle testing
• Interacting with a group of developers for migrating the server side, client side files to different instances and specify documentation specifications for the release notes.
• Implemented Oracle Alerts, Workflow Builder, Menus and Functions as part of the overall solutions
• Developed a pl/sql package using the UTL FILE utility to write the data into the flat file on the specified oracle ftp directory
• Worked on Data conversions which includes data cleaning, data validations and loading the data from various legacy systems to Oracle Apps environments:
• Provided post production support for all issues - standard, custom, and some legacy system issues
• Development of the Interfaces, Conversions and Extensions
• Involved in Enhancements to various XML publisher Reports for OM Module
• Migrated enrollment data from Legacy systems into Oracle Trading Community Architecture(TCA)