PROFILE SUMMARY

• Over all 9 Years of Experience as Senior Technical consultant in Oracle E-Business Suite 11i and R12 .
• Proficient in Technical Analysis, Configuration and testing of new Development customization of existing systems, involving Technical expertise on different modules GL, AP, AR, PA and HRMS of Oracle ERP.
• Good Functional Knowledge on Procure to Pay P2P Cycle.
• Good Exposure in Financial Modules AP,AR,GL
• Very good experience in Oracle Apps R12
• Good experience in production support
• Very Good experience in analysis and debugging production issues.
• Very Good Experience in interaction with users
• Knowledge on preparation functional test scripts.
• Good Experience in creating service request and communicating with oracle support team.
• Design and development of interface, conversion programs and Workflow Customization to integrate Oracle Applications modules and external packages and custom applications and to import data from various sources into Oracle Applications using PL/SQL, SQL Loader and Worked on Unix shell scripting.
• Modules and registered reports in AOL and System Administration.
• Experience in Implementation and Migration Projects.
• Involved in Oracle Apps. Interface Enhancement, Workflow Customization, Report Customization and other regular activities like Registering Forms and Reports, creation of Users, Responsibilities etc.
• Excellent technical experience in SQL Plus, PL/SQL, SQL Loader, Developer 2000.
• Ability of Adopting New Technologies and Trends without any special training.
• Proficiently participated in the training needs and organized trainings to enhance the efficiency and quality of work
• Well versed with Development and Implementation of large application oriented project.
• Excellent communication skills, good interpersonal skills and am dedicated, disciplined and a good team player.

SOFTWARE SKILLS

• ERP : Oracle Applications R12,11i AOL, Sys Admin, AP,AR, GL,
• HRMS, PA, INV and OM
• Database : Oracle 8i/9i/10g
• Languages : PL/SQL, SQL
• Front End Applications : Oracle Apps Release12, Oracle Apps Release11i,
• Reports10g, Reports6i, Workflow Builder, Oracle Alerts.
• GUI : Report Builder Oracle Report 6i/9i .
• Other Tools : TOAD, SQL Developer, sql plus, WinSCP, TeamForge and
• HP ALM Quality Center
• Operating System : Windows 95/98/2000, UNIX

Project Experience

Confidential

Oracle Applications

Confidential is one of the worlds largest electronic transaction processing companies, headquartered in Atlanta, Georgia, USA. Global Payments has operations located throughout the United States, Canada, the United Kingdom, Europe and the Asia-Pacific region to serve millions of consumers and merchants, hundreds of organizations and financial institutions and scores of government agencies that use Global Payments acquiring, processing, network communication, Internet, gaming and consumer money transfer services.Global Payments also provides comprehensive business-to-business payment card and processing services, such as cash management, financial electronic data interchange, management information and reporting services.

RESPONSIBILITIES:

• Designed Technical Documents MD070, MD120.
• Customized Reports and Involved in testing of the reports.
• Supporting all critical Sev1 and Sev2 issues and providing the solutions to resolve the issues.
• Analysis/Review creation of Technical Specifications, Installations and MD120 Configuration document.
• Customized Reports and Involved in testing of the reports.
• Developed new reports and interfaces as per business requirement.
• Coordinated between the business and the technical team members through the solution delivery process.
• Performed the responsibility of system administrator, which involved registering and managing the concurrent programs and database objects.
• Registered Concurrent Programs, Executables, Forms, Functions, SQL Loader, Package and Report and run them as a request set.
• Provide solution both technically and functionally
• Gather the requirement from end user
• Designed MD50 specifications for Customization of Reports Development.
• Involved in the Unit testing and Integration testing of customizations.
• Support, Development and enhancement of Oracle application implemented for different Custom modules.
• Used procedures and SQL Loader scripts in implementing Custom Interface to validate and import Custom data from legacy systems.
• Creation of value sets in various modules of the applications.
• Overall Status Reporting, Issue Resolution and handling of escalations and onsite communication.
• Provide weekly status to manager about the progress of the project.

Confidential coils. Kaycan is one of the world's leading vinyl and aluminum siding and coil producers. They operate more than 100's of branches scattered all over the world. The project is outlined for developing BI apps for Finance and Supply Chain Management and for customizations according to the requirement.

RESPONSIBILITIES:

• Developed PL/SQL stored procedures, functions and triggers Followed MD50 functional documents and designed the MD70 technical specifications, provided support for end users and documented the modifications.
• Created database objects like tables, views, synonyms, indexes, and sequences.
• Create and update technical specification documents as part of Oracle's AIM methodology.
• Writing PL/SQL Programs for implementing validation rules and loading data from staging tables to Interface Tables.
• Executing concurrent programs from PL/SQL.
• As a technical consultant, responsible for Communicating to the end users, Requirements analysis, Functional Specification Documents, Designing Specifications, Coding, Testing, Change Management and support of the Customizations and application extension.
• Involved in post-production support, bug fixing and enhancements of RICE objects
• Involved in development of new XML Reports and customized existing reports as per requirements.
• Defining Concurrent Executables, Programs.
• Registered AOL Objects across instances using FNDLOAD scripts.
• Responsible for preparing the technical specification document from the functional requirements Document, designing, Programming
• Done the enhancements raised in the Technical design Documents.
• Responsible for delivery of the objects
• Responsible for each components are correct and good to go for production release.
• Conduct Technical analysis for developing new exports.

My Role in AP support as Technical Consultant, I am responsible for the global Supporting Components from Payables module. This project is a Supporting of Payables module of Oracle Application 11i and R12 giving fixes to the functional and technical issues and also regular interaction with customer to resolve the issues.

RESPONSIBILITIES:

• Technical and Functional assistance to the users.
• Involved in upgrade activities from ERP version 11.5.9 to 11.5.10.2 and 11.5.10.2 to R12
• Production Support Implementation issues, Training, Month end, year-end activities.
• Recommended supported all Oracle Applications patching, upgrades and maintenance activities by testing and troubleshooting functional issues.
• Managed Oracle Service Requests SR's to resolution effectively.
• Actively involved in month end yearend closing activities with business users.
• Involved in analyzing and understanding of the Service Requests clearly.
• Involved in answering clients convincingly to meet the client satisfaction.
• Involved efficiently in resolving the issues concerned to the SR's which are raised through Meta link within a given time period.
• Supporting all critical Sev1 and Sev2 issues and providing the solutions to resolve the issues.
• Handled critical technical requirements of the customer and provided the solution with work around and with related data fixes
• Having good technical and functional knowledge of Payables application and elaborate the functionality and explain to the customer for all consultative issues.
• Helping to all functional people on payables, cash management and I-expense module Technical concepts.
• Handled critical withholding tax issues and performance issues
• Resolved many period close issues.

Modules Involved AP, AR HRMS

• Confidential is a cement Industry, PCIL majorly involves in manufacturing, Sales, Inventory and logistics.
• My role in PCIL as a senior consultant, Work involves interacting with the client functional IT team to collect the requirements and interact with other team members and get it executed.
• Worked on a PCIL Discount Run Form where its functionality like managing dealers is providing discounts based on various conditions. However Oracle does not have any standard functionality in Receivable module, PCIL Discount Run Form is developed to view the given discount to the customer at various levels like example branches and Go-downs based on location, transaction quantity, and transaction amount To survive and grow in this sector one of the main requirement is managing dealers.

RESPONSIBILITIES:

• Client Interaction, collecting requirements from PCIL.
• Analyze requirements and provide support to Team members.
• Conduct Technical analysis for developing new exports.
• Updating of Technical documents, Unit Test documents and Setup documents.
• Trouble shooting route cause, Rework and defect analyze.
• Review the Design docs, Testing etc

Oracle Applications 11i and R12, Oracle 10g

Technical Consultan

• is the market leader in the Dutch telecoms market. KPN International offers a sophisticated portfolio of IP and data services that provide corporate customers, internet service providers and carriers with intelligent network solutions. The foundation for those solutions is the international KPN fiber-optic network, which spans 22 European countries, plus worldwide connections.
• My role as a developer and onsite coordinator, Work involves interacting with the client functional IT team to collect the requirements and interact with offshore team members and get it executed from offshore. Also assist in Project management activities. The project is to work on various enhancement tasks related to oracle apps implementation at KPN Telecom. It includes up gradation of Oracle Apps, Implementation of new Modules, Major and Minor Enhancements of Oracle Business Suite 11i and currently involved in up gradation project from 11i to R12 instance.
• Parallely involved in some below short term projects.
• In Telfort Integration project did outbound interfaces.
• ProjectM developed customized XML Reports.

RESPONSIBILITIES:

• Client Interaction, collecting requirements.
• Analyse requirements and provide support to offshore.
• Developing Export Programs.
• Work Flow Customization for Leave of Absence and email notifications.
• Conduct Technical analysis for developing new exports.
• Updating of Technical documents, Unit Test documents and Setup documents.
• Trouble shooting route cause analyze, Rework and defect analyze.
• Review the Design docs, Testing etc

Technical Consultant

states called Maine, Vermont, New Hampshire, from Verizon, another Tele Communication firm in US. Under the FairPoint Nor'Easter program, Capgemini is supporting FairPoint Communications, Inc in acquiring and operating all from Verizon's New England states including Vermont, New Hampshire and Maine. This program will consist of a variety of sub-projects which collectively support the transition of the Verizon operations to FairPoint. The program will thus involve the transition of organizations and people, system capabilities and system data as well as business processes and business operations from Verizon to FairPoint . FairPoint is implementing Oracle Applications 11i HRMS, Purchasing, Inventory, Payables, Receivables, Fixed Assets, Project Accounting and General Ledger.

RESPONSIBILITIES:

• Customization and Developing of Inbound and outbound Interfaces.
• Preparation of SQL Loader scripts.
• Creation of upl files Registered Executables and Concurrent Programs.
• Creation of MD070 For functional design documents and Test cases.
• Helping functional consultant in Self-service activities.
• Involved in client discussions for resolving the issues.
• Responsible for creating Responsibilities, Users and assigning them to the Users.

This Project Contains Different Modules like Books, Works, Cash Management, Fixed Assets, Payroll. I have involved various modules like Books and works modules. I have developed forms, reports, PL/SQL programs for books, works modules. These modules integrated with cash management, Purchasing. Books module contains the chart of accounts, General Ledger, Trail Balance, Adjustment journal. In works module making invoices, payments for contractors and posting to Books section, Making TDS Payments, TDS Reports, Creation of vendors and work orders.

RESPONSIBILITIES:

• Royal Forex maintains fixed period exchange rates per period and it requires paying currency rate as per the date of invoice, not the payment date.
• Supported to the team working on interface development and reports development implementing Oracle Applications 11i.
• Involved in a feeder program that will transfer the Accounting data from the Legacy Accounting System to the GL Interface table.
• Developed a custom package to import the items to the interface table and use standard import program.
• Involved in analysis, designing and developing process
• Developed Pl/SQL Libraries, Packages, Sub Programs, Cursors and Triggers
• Interact with Functional Experts and users of the System for the Improvement of the System Study, Analysis and Design