SUMMARY

• 19 years of experience out of which around 11.5 Years in design, development, testing implementation and support of Oracle Applications EBS Suite which includes Oracle Financial & Supply Chain Modules (GL, AP, AR, CM, PO, OM, SLA, EB Tax, Vertex O series and AME) and System Administration.
• Worked on EBS Suite versions (11.5.4, 11.5.9, 11.5.10, R12.1.1, R12.1.3 & R12.2.4).
• Worked as a Team Lead and handled projects which include implementation, Customizations development and Support at onsite.
• Well versed with the Project management tools OTRS, Assyst, PVCS, PPM, Clarity & Service Now
• Proven Skills as an efficient Team Lead in System Analysis, Designing, Development, Customization, Migration and Documentation.
• Involved in implementation, Upgrade and Support of Oracle Applications E - Business Suite using SQL, PL/SQL, Developer Suite 10g, with hands-on experience of various RICE components and Workflow.
• Experience managing technical quality deliverable/ resource/schedule/risks throughout the project, working extensively under onsite-offshore model using AIM Methodology.
• Strong analytical, interpersonal and troubleshooting skills and ability to work in a fast-paced and team-oriented environment. Extensive experience in maintaining development plan, tasks allocation, task monitoring, establishing/monitoring quality process, study/audit of existing business process and preparation of issue logs, requirement gathering, user interaction, gap analysis, technical data mapping and analysis
• Worked with Oracle Support, using Metalink, to resolve issues using knowledge base, SR/TAR.
• Performed Unit testing, Integration testing & User Acceptance testing of the Applications.
• Developed the Documentation Process of the application with end-user training.
• Production Support experience in Procure-2-Pay (p2p), Sales Order to Cash (O2C) and Finance Processes.
• Implemented Vertex O for O2C (Sales Order to Cash) & P2P (procure to Pay) cycles.
• Technically proficient and possess excellent written and verbal communication skills. Have good team leadership skills and invariably meet client expectations.
• Well versed with complete SDLC (gathering Business Requirements, Analysis, Design, Implementation and Testing) cycle.
• Managed Planning and Stakeholder Communication for the Change Management Process.
• Strong analytical, design and problem solving skills. Result oriented, self-starter and able to work with minimum guidance.
• Proven ability to understand business problems and apply technology to formulate workable solutions.
• Ability to quickly adapt to different project environments and an excellent Team Lead/ Team member.
• Skilled in swiftly ramping up projects with competent skills and ensuring on time deliverables.

TECHNICAL SKILLS

Domain: Financials, Retail, Hospitality, Gaming

ERP: Oracle Applications EBS 11i 11.5.4, 11.5.9, 11.5.10, R12 12.1.1, 12.1.3, R12.2.4

Oracle Apps Modules: General Ledger, Account Payables, Account Receivables, Cash Management, Fixed Assets, Purchase Order and AOL, Sysadmin, AME (Approval Management Enterprise), EB Tax, Vertex O Series

Databases: Oracle RDBMS 8.x, 9.X & 10G

Software Tools: Developer 2000, Discoverer, XML Publisher, RDF Reports, Forms Builder, Workflow Builder, Data Loader, WEB ADI, MS Office, SQL, PL/SQL & Oracle SQL Loader, Assyst, PVCS, PPM (Project Portfolio Management), Service Now

Operating Systems: Windows NT, UNIX, Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, Rancho Cordova, CA

Senior Oracle Applications Financial Developer

Responsibilities:

• Created/customized/personalized OAF forms
• Implementation involves data from different sources to flow to Oracle Applications through a series of custom and standard programs.
• Mapping the client requirement and providing them the best possible solution
• Mapping of Data template columns with legacy systems
• Involved in development/modification/bug-fixing of different RICE components
• Scheduling of multiple tasks (Daily Interfaces/Month End Process) and handling the errors/rejections
• Overall Status Reporting, Issue Resolution and handling of escalations
• Handling all Support related issues of financial modules.
• Discussing issues week-wise with the client on status review.
• Understand the new requirements & document the same.

Environment: Oracle Applications 12.2.4 (GL, AP, AR, CM,) Oracle 10g, Oracle Developer Suite 10g

Confidential, Wooster, Oh

Oracle R12 Techno Functional

Responsibilities:

• Gathering, refining, and documentation of the business rules, functional and technical requirements.
• Performed AGIS setups.
• Worked on EBTAX regime, taxes, tax statuses and tax rates setups.
• Worked on SLA setups.
• Implementation involves data from different sources to flow to Oracle Applications through a series of custom and standard programs.
• Worked on EB-Tax reports Development/Customizations.
• Mapping the client requirement and providing them the best possible solution
• Mapping of Data template columns with legacy systems
• Involved in development/modification/bug-fixing of different RICE components
• Scheduling of multiple tasks (Daily Interfaces/Month End Process) and handling the errors/rejections
• Overall Status Reporting, Issue Resolution and handling of escalations
• Handling all Support related issues of financial modules.
• Discussing issues week-wise with the client on status review.
• Understand the new requirements & document the same.

Environment: Oracle Applications 12.2.4 (GL, AP, AR, CM, OM, EBTAX), Oracle 10g, Oracle Developer Suite 10g

Confidential, Waukegan, IL

Technical Developer

Responsibilities:

• Gathering, refining, and documentation of the business rules, functional and technical requirements.
• Performed GAP analysis and prepared solution presentation for review.
• Worked on EBTAX for US & India Localizations. Worked on EBTAX regime, taxes, tax statuses and tax rates setups.
• Worked on SLA setups.
• Worked on EBTAX to Vertex O series integration by upgrading Vertex Q Series to Vertex O Series.
• Implementation involves data from different sources to flow to Oracle Applications through a series of custom and standard programs.
• Implemented Vertex O for O2C (Sales Order to Cash, Service Contracts) & P2P (procure to Pay) cycles.
• Worked on EB-Tax reports Development/Customizations.
• Mapping the client requirement and providing them the best possible solution
• Mapping of Data template columns with legacy systems
• Worked on ISuppliers
• Involved in development/modification/bug-fixing of different RICE components
• Scheduling of multiple tasks (Daily Interfaces/Month End Process) and handling the errors/rejections
• Overall Status Reporting, Issue Resolution and handling of escalations
• Handling all Support related issues of financial modules.
• Discussing issues week-wise with the client on status review.
• Understand the new requirements & document the same.

Environment: Oracle Applications 12.1.3 (GL, AP, AR, CM, OM, CRM, Service Contracts, Install Base, EBTAX, VERTEX O Series), Oracle 10g, Oracle Developer Suite 10g

Confidential, Parsippany, NJ

Technical Specialist (Lead)

Responsibilities:

• Leading support team at offshore successfully to meet the technical milestones as per business plan ensuring quality and schedules.
• Establishing quality processes and ensuring processes are followed as per defined standards and guidelines.
• Wrote SQL Scripts to create, alter, and drop database objects like tables, views, and sequences.
• Worked with the Oracle Support Team for TAR/Service Requests for some issues on the Purchasing and Payables.
• Worked on EBTAX for US & India Localizations. Worked on EBTAX regime, taxes, tax statuses and tax rates setups.
• Unit testing and System testing (with various other systems deployed in the organization) for the applications built and customization performed.
• Worked on Install Base & Service contracts
• Modified the custom forms, reports, pl/sql programs for changes in Vendor, Payables, and Payments modules tables.
• Worked O2C (Sales Order to Cash) and P2P (Procure to Pay) Cycles and support.
• Worked on defining SLA for financial modules for US region & Canada
• Used Oracle Form Personalization for some Form Customizations.
• Responsible for writing Functional (MD050), Technical Specification (MD070) and Test Scripts.
• Performed Technical review of the code and mentoring juniors in the team.
• Developed Unix Shell Scripts to migrate the objects and ldt files to different instances.
• Developed Auto Lock Box interface in Oracle Receivables using proper validation and loaded the data.
• Logging/following up Service Requests with Oracle Support.
• Worked on AR Statement Cycle Process.
• Worked on SLA setups.
• Worked on EB-Tax reports Development/Customizations
• Scheduling/Monitoring of Oracle Statement Cycle Process across the Operating Units.
• Worked on Month End Activities to close the periods in time.
• Development/ Customizations of reports, interfaces, enhancements.
• Handling all Support related issues of financial modules.
• Worked on AP Invoice approval workflow (AME) in routing of Invoices/Payments approval
• User problem resolution and query handling.
• Discussing issues week-wise with the client on status review through ASSYST
• Mapping of Data template columns with legacy system
• Involved in development/modification/bug-fixing of different RICE components
• Planning & Estimation of new developments and customizations.
• Registering of Reports/Concurrent Programs/Executables etc.,
• Understanding the new requirements, documenting the same.

Environment: Oracle Applications 11.5.10 (AP GL, AP, AR, CM, PO, AME, CRM, Install Base), Oracle 10g, Oracle Developer Suite 10g, Oracle Forms 6i, Reports 6i, TOAD, UNIX, BI (XML) Publisher, PL/SQL

Confidential

Technical Specialist (Lead)

Responsibilities:

• Interacting with CxO level (CFO, CIO, CTO, etc.,) on project review meetings and strategies.
• Responsible for Implementation, support and managing different applications (ZRMS, POS, SMART SHOP)
• Gathering, refining, and documentation of the business rules, functional and technical requirements.
• Involved in Code and AOL programs migration to CRP testing environment from DEV.
• Wrote SQL Scripts to create, alter, and drop database objects like tables, views, and sequences.
• Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures, forms and reports.
• Worked on Business process flow billing to third party tools (SMARTSHOP/POS/ZRMS to AP, AR & GL and periods closing.
• Created test scripts for every level of testing from unit testing stage to integration testing.
• Implementation involves data from different sources to flow to Oracle Applications through a series of custom and standard programs.
• 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 Custom EDI Outbound Interfaces (Check Printing/NEFT/RTGS/Wire) Transactions with different Banks.
• Implemented PGP (64 bit) Encryption/decryption tool for Payment files.
• Developed concurrent programs and scheduled jobs as per the requirement.
• Worked on Up-gradation from 11i to R12.
• Worked P2P (Procure to Pay) Cycle and support.
• Worked on EBTAX for India Localizations. Worked on EBTAX regime, taxes, tax statuses and tax rates setups.
• Worked on defining SLA for financial modules for US region & Canada
• Worked on EB-Tax reports Development/Customizations.
• Integration of custom forms with standard PO and AR modules.
• Worked actively to trouble shoot defects and problem during the string and user acceptance testing and resolve production issues.
• Converted RDF reports to XML reports.
• Implemented the AP Invoice approval workflow (AME) to handle the routing of Invoices/Payments
• Preparing MD50, MD70 & MD 120 documents for the deliverables using Application Implementation Methodology (AIM).
• Responsible for delivery interfaces, customizations, developments and setup issues.
• Mapping the client requirement and providing them the best possible solution
• Mapping of Data template columns with legacy systems
• Involved in development/modification/bug-fixing of different RICE components
• Scheduling of multiple tasks (Daily Interfaces/Month End Process) and handling the errors/rejections
• Overall Status Reporting, Issue Resolution and handling of escalations
• Handling all Support related issues of financial modules.
• Discussing issues week-wise with the client on status review.
• Understand the new requirements & document the same.
• Raising SR/TAR with Oracle Metalink, priority based on severity of the problem and follow up of SR/TAR’s, updating of same if required, and expediting User/DBA action on receipt of solution

Environment: Oracle Applications 11.5.9/R12.1.1 (AP GL, AP, AR, CM, PO & AME), Oracle 10g, Oracle Developer Suite 10g, Oracle Forms 6i, Reports 6i, TOAD, UNIX, BI (XML) Publisher, Workflow, PL/SQL

Confidential

Sr. Consultant

Responsibilities:

• Developed various technical objects like Tables, Views, SQL*Loader, Data Loader, Packages, Procedures, Functions, Sequences, Synonyms and Materialized View for different processes.
• Extensively developed the RICE components in the major financial modules like GL, AP, AR
• Personalized few forms to restrict users from entering journals or doing wrong transactions based on certain criteria.
• Registered Forms, Reports, PL/SQL Packages, and UNIX Shell Scripting with AOL with parameters & incompatibilities.
• Thoroughly Unit tested all the developed technical objects.
• Properly documented all the developed objects with MD0.50, MD0.70 and BP0.70 using Application Implementation Methodology (AIM).
• Provided technical support during integration testing, quick fixed code bugs.
• Interactions with users
• Development/ Customizations of reports
• Registering of Report with Oracle Applications
• Defining Concurrent Programs and Executables etc.
• Testing the Developed components with Front end Forms

Environment: Oracle Applications 11.5.10 (GL, AP, AR, CM & AME), Oracle 10g, Oracle Developer Suite 10g, Oracle Forms 6i, Reports 6i, TOAD, UNIX, BI (XML) Publisher, PL/SQL

Confidential

Consultant

Responsibilities:

• Up gradation of interface objects from 11.5.4 to 11.5.10
• Developed Interfaces, Conversions, Reports using SQL, PL/SQL Packages, Procedures, Functions, SQL*LOADER, Data loader
• Activating descriptive flex fields to capture additional information for the client not available in standard Oracle forms, set up Suppliers and Banks for AP use.
• Designed and developed Auto Lock Box interface in Oracle Receivables using proper validation and loaded the data.
• Worked on EBTAX for US & India Localizations. Worked on EBTAX regime, taxes, tax statuses and tax rates setups.
• Worked on defining SLA for financial modules for US region & Canada
• Worked on EB-Tax reports Development/Customizations.
• Worked O2C (Sales Order to Cash) and P2P (Procure to Pay) Cycles and support.
• Customized Standard Oracle Reports and built custom reports using Oracle Report builder and integrated them with the Oracle Applications as per Business Requirements.
• Registration of Program: Registered Reports, SQL*LOADER, PL/SQL Packages, UNIX Shell Script with Oracle AOL.
• Defined Value Sets, Concurrent Executable, Concurrent Program, Request sets and attached in Request Group.
• Performed SQL tuning activities to enhance the performance of customized PL/SQL programs.
• Worked on UNIX Scripts & Commands for reporting needs.
• Prepared design documents (MD0.50) and technical documents (MD0.70) for all the customizations.
• Handling all Support related issues of financial modules.

Environment: Oracle Applications 11.5.4/11.5.10 (GL, AP, AR, CM, PO & AME), Oracle 9i, Oracle Forms 6i, Reports 6i, TOAD, UNIX, PL/SQL

Confidential

Consultant

Responsibilities:

• Designed & developed Database components specific to Services & Product like Tables, Materialized Views, Procedures, Indexes, Grants and PL/SQL Packages.
• Developed/Customized RDF reports
• Developed/Customized Forms
• Performed SQL tuning activities to enhance the performance of customized PL/SQL programs.
• Worked on UNIX Scripts & Commands for reporting needs.
• Designed and developed various custom packages, procedures and functions in PL/SQL.
• Involved in creation of views for various processes.

Environment: Oracle 9i, Oracle Forms 6i, Reports 6i, TOAD, UNIX, PL/SQL