SUMMARY

• 8+ years of experience in providing cost effective solutions in Oracle Domain.
• Experience in requirement gathering, analysis, solution design, development, implementation, set up, testing, customization, troubleshooting, maintenance, support, and data migration.
• Experienced and involved in functionality of Oracle Applications R12 modules such as Purchasing, iProcurement, General Ledger, Account Payables and Technically Involved in Account Payables, Account Receivables, General Ledger, Order Management, Inventory, Purchasing, iProcurement and Project Accounting.
• Extensive experience with understanding the client requirement and preparation of Functional specification documents.
• Excellent customer management and experience with integrated value chains.
• Strong knowledge in business flow and involving with various teams in developing the components and migrating to various instances like working with DBA’s in migrating the changes, Access Management team in proving various server and other access regarding component development.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers, and other database objects using SQL and PL/SQL.
• Expertise in writing SQL and PL/SQL scripts to improve the Performance.
• Experience in generating Reports and registering concurrent programs/reports.
• Experience in generating Business Intelligence Report and Oracle Reports.
• Experienced in designing Data Conversion programs both inbound and outbound to integrate Oracle Applications modules to import data from various sources using PL/SQL, SQL*Loader.
• Proficient in developing concurrent programs using SQL and PL/SQL.
• Highly skilled in developing and testing applications using Stored Procedures, Functions, Packages and Database Triggers.
• Experience in implementing Business cycles like Order to Cash (O2C) and Procure to Pay (P2P) cycles.
• Experience in utilizing standard Oracle API’s for conversion programs.
• Ability to communicate well at the user level and technical levels and to breakdown complex problems into manageable parts and develop alternative solutions
• Self - starter with potential, initiative and a positive attitude. Able to meet very stringent deadlines and always deliver the package
• Keen and enthusiastic with constant desire to learn and a commitment to excel.

TECHNICAL SKILLS

ORACLE ERP: Oracle Applications 11i and R12

FUNCTIONAL MODULES: Inventory, Order Management, iProcurement, Purchasing, Advance Pricing.

TECHNICAL MODULES: INV, PO, OM, iPROCURMENT, AP, AR, GL, FA and PA

LANGUAGES: SQL, PL/SQL, SQL*PLUS.

OPERATING SYSTEMS: UNIX, MS-DOS, Windows95/NT/2000/XP and Linux.

SCRIPTING LANGUAGES: XML and HTML

TOOLS: /UTILITIES: SQL*Loader, Report Builder, BI Publishers, Workflow Builder, JDeveloper, PLSQL Developer, TOAD, SQL * Plus Meteor, CA WorkStation, Portfolio Project Management (PPM), SVN tortoise repository and winCVS repository.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Oracle App Lead Consultant

Responsibilities:

• Understanding user requirement, analyzing risk factor and accordingly creating functional design documents like CV40 and MD50.
• Experience in creating Setup Configuration document, Steps Analysis and solution design document for user.
• Based on the functional design document analyzing technical challenges and accordingly designing technical design documents.
• Make utilizing all the resources from Off-shore team in developing components.
• Experience in developing PL SQL packages, procedures, functions, triggers and advance SQL scripts.
• Strong experience in business process like P2P and O2C both technical and functionally.
• Handled various components like WebADI, Workflows, Reports and conversions on Account Payables, General Ledgers and Purchasing Modules
• Developed several reports at limited bandwidth Payables reports like Cash requirement summary report, Invoice on holds report, Invoice encoding request Report and General ledger reports like Account analysis report, profit and loss report, Foreign exchange report both in balances and accounts.
• Developed payment process request interface.
• Worked closely with DBA team on migrating data from DEV to DEV, DEV to Production and Oracle Production to user production by scheduling ESP Jobs which automates the migration on daily basis.
• Worked with access management team for multiple users in order to deploying the request changes.
• Patch Analysis and replicating changes from one instance to another.
• As a lead having strong business flow understanding and team management skills.

Environment: Oracle 12.1.3 PO, AP, GL modules, Reports 6i Oracle, XML Publisher, PL/SQL, Work Flows, CA Work Station, Stored Procedures, Windows95/NT.

Confidential, Houston, TX

Oracle App Techno Functional Consultant

Responsibilities:

• Understanding the current Business process and preparation of As-Is documentation.
• Setup Configuration - BR100 Preparation & Mapping of Business Process by understating the user requirements.
• Worked on all the setups for the INV, AP, I-Procurement, Procurement Contracts, Purchasing for inbound and outbound transactions.
• Performed all the setups for the Quoting Module in relation to Order Management.
• Designed CV40 document for Account payable conversion and designed data migration templates based on user requirement.
• Conducting CRP 1 Testing and CRP 2 Testing to super users.
• Conducting UAT - End to End Integration testing
• Performing out the Production Setups.
• Post production support
• Functional Business Support, and resolving day-to-day critical issues.
• Coordinating with Technical team and taking Ownership in delivering the Components.
• Understanding of new tool like METEOR for conversion and designing the code accordingly.
• Troubling shooting programming issue, supporting Citrix related issues.
• Maintaining team work order sheet and handling the off-shore team.
• Designed RDF reports for Commercial invoices for the US region and supported production issues related with it.
• Worked on the Mass update change from standard error and provided the solution for the functionality.
• Worked on year ending process and SQL performance tuning.
• Handling Support related issue and designing release note and test related documents.
• Created MD70 for the new changes/Enhancements on AR Interfaces like BillTrust and O2C functionality like Interface Trip Stop Errors.
• Proficient in SQL tuning the packages, procedures and enhance the performance related issues in real time environment
• Worked on the XML Publisher reports of java concurrent program type related with PO and AP.
• Developed Conversion packages for Banks, Branches and Accounts.
• Coordinated the Offshore Development activities as a lead and played a Vital role in the code reviewing process, design and production support.
• Worked on the Documentation MD70 and Migration checklist activities.

Environment: Oracle 12.1.3 OM, INV, iProcurement, PO, AR, AP,P2P, O2C modules, Forms6i, Reports 6i Oracle, XML Publisher, PL/SQL, WorkFlows, Stored Procedures, Windows95/NT.

Confidential, Tampa, FL

Oracle Apps Techno Functional Consultant

Responsibilities:

• Team member of development team, involved in customizations of various Oracle manufacturing modules like Order Management, Inventory, PO, AP and AR.
• Involved in the complete life cycle of software development: Analysis, Design, Development, Testing and Implementation
• Have done Technical designs for conversion documents of AP, GL and PO modules.
• Extensive experience in technical specification design, development, unit testing Oracle e-business suite of Applications.
• Worked on the Custom Order organizer form to customize the Order fill % based on the reservation set.
• Worked on the production issues on Generic FTP Shell script to improve the performance.
• Created complex validation units based on Value Sets and list of values by creating various views and tables
• Created Value Sets and attaching those value sets to the value set name for the parameters of the report or PL/SQL Packages.
• Implementation of business specific custom programs by writing PL/SQL stored procedures.
• Created Custom forms for specific users and assigned those forms to their menus to restrict their accessibility
• Supported on Workflow issue for approval to increase the CEO time to maximum.
• Worked on AP Invoice Interface using WEBadi to transfer the data.
• Worked on Performance Issue like GL Account Analysis Report such as Profit and loss report and GL balances.
• Worked on the Work Order extraction and configuration of the custom club orders and the end to end process of Pick release and Ship confirmation.
• Defined concurrent program and assigned to request groups
• Created and register Tables in Oracle Application
• Developed custom XML reports using Report 6i for generating the orders that have got the invoices. Also, validated the date columns by writing plsql script in the value set at the front end
• Designed and developed numerous packages and procedures utilizing various seeded APIs to UPDATE task assignment status from one to other and also to load data from temporary tables into Oracle base table
• Created DB Triggers, Functions, Packages, Stored Procedures, Views, Sequences, Synonyms at the back end using SQL and PL/SQL

Environment: Oracle R12 OM, INV, PO modules, Reports 6i Oracle, XML Publisher, PL/SQL, Stored Procedures, Windows95/NT.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Developed Purchasing Analysis Report By vendor.
• Customized Physical Inventory Count Report.
• Developed Invoice Details Report.
• Developed Customer Related Invoices Report
• Developed PO Receipts Relation Report.
• Development of monthly Value of Work done (VOWD) Report.
• Development of Actual cost and budgets account and Report which gives detail report for Actuals and Budgets.
• Involved in Development of Interfaces.
• Registrations of Concurrent Programs and Executable.
• Development and Customization of Reports.
• Defining Value sets and Lookups.
• Provided Support to Rice Components.
• Developed item import interface.
• Developed AP Open Interface to Validate invoice data from legacy system into Oracle Apps base tables.
• Developed the purchase order interface to load the purchase order data from legacy system into oracle Apps TABLES.
• Developed new package to extract the Invoice details from Invoice base tables into flat files by using UTL FILE.Developed item import interface for Project creation and work plan from staging table and then to primavera.
• Developed Technical documents and Release notes for every component migrated to Production Instance.

Environment: Oracle Apps Implementation Release 12 Modules: PA, AP, PO, INV and SQL, PL-SQL, Reports 10g/6i, Putty, Winscp 3, Windows XP/2003.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Involved in developing the BI Reports.
• Involved in developing the Inbound and outbound Interfaces.
• Registrations of Concurrent Programs and executable.
• Creation of Value sets in various Modules of the application.
• Preparation and Execution of unit test case.
• Developed Vendor Received Quantity report.
• Developed Invoice Payment Status Report.
• Developed Customers Shipment Details Report.
• Customized Credit Transfer Report.
• Developed GL Interface to upload data from legacy system into Oracle Apps PO base tables.
• Developed Item Upload Interface to upload data from legacy system into Oracle Apps INV base tables.
• Developed new Package to extract the Purchase order release details from Oracle PO base Tables into flat files by using UTL FILE.

Environment: Oracle Apps Release 11i (11.5.10.2), Modules: AP, PO, INV and SQL, PL-SQL, Reports 10g/6i, Putty, Winscp 3, Windows XP/2003 and UNIX Server.

Confidential

Oracle Apps Technical consultant

Responsibilities:

• Team member of development team, involved in customizations and Process flows in various Oracle ERP Modules like OM, PO, INV.
• Creation of Service Requests and diligently following with Oracle support for problem resolution.
• Actively participated in Defects resolutions.
• Raising & Tracking SR’s for weekly, Daily Migrations Refresh.
• Successfully Prepared Remigration Builds of different instances with no issues.
• Checked log reports & Took immediate action for all types of issues.
• Actively participated in client interaction and meetings.
• Maintained Quality Centre up to date for all Migrations & Remigrations Successfully
• Developed reports for printing invoices sent to various customers for cross verification purpose.
• Created PL/SQL View and Materialized views for the Price Book Generation.
• Generated Error File as Excel Sheet and send it to the appropriate Email through PL/SQL package concurrent program.
• Preparing the Solution Design documents and Technical Design documents
• Testing all the application and PL/SQL components for providing quality assurance and various kinds of hints and outer joins.
• Tuning all the application components for better performance and throughput.
• Worked on 24/7 environment (baseball and Christmas leaves)

Environment: Oracle Apps Implementation Release 11i (11.5.10.2), Modules: AP, GL, PO, INV and SQL, PL-SQL, Reports 10g/6i, Putty, Winscp 3, Windows XP/2003 and UNIX Server.