SUMMARY

• 8 years of experience working with Fortune 100 companies delivering Oracle solutions.
• 3 years of experience in Design, development, Conversion, Customization, interfacing and implementation of Oracle E - Business Suite Applications R12.
• 7+ years of experience in the Oracle E-Business Suite Applications 11i Implementation, Customization, and Supporting Projects.
• Extensive technical and functional expertise on Modules like Oracle Payables, Oracle Receivables, Order Management, Oracle Purchasing, Oracle General Ledger.
• Strong programming knowledge in creating Procedures, Functions, Packages, Triggers, Reports and registering them as Concurrent programs and other database objects using SQL and PL/SQL.
• Experience in Conversion Data between Legacy and Oracle using standard Oracle Programs
• Experience in developing XML Publisher & Discoverer reports.
• Good exposure to P2P and O2C cycles.
• Responsible for understanding and analyzing the provided RICE component specifications and developing solutions by using Developer 2000 and PL/SQL
• Good exposure to Oracle Application Implementation Methodology (AIM 3.0)
• Experience in designing, developing, customizing and supporting the Inbound and Outbound Interfaces in Oracle Applications which includes AP, PO, AR, OM, INV, GL modules.
• Good Debugging skills and good at using Exceptions and Error Handling.
• Experience in Performance Tuning using Explain Plan, TKPROF, and Trace Analysis.
• Experience on personalization’s using Forms Personalization
• Good communication skills, Analytical and problem solving Skills, Efficient Team Player, Openness for help, willing to travel, Optimistic attitude and Enthusiastic.
• Experience in creating TAR/SR and worked with Oracle support on SR’s of various priorities.
• Preparation of Test plans, Test data and execution of test cases to ensure application functionality meets the user’s requirements

TECHNICAL SKILLS

ERP: Oracle E-Business Suite Applications 11i (AP, GL, PO, AR, OM, INV, FA, CM), Oracle Process Management, Oracle Release 12, AOL, Sys Admin.

Languages: SQL, PL/SQL, C, Java, HTML

GUI Tools: XML Publisher, Discoverer, Reports 6i/10g, Forms6i.

Tools: & utilities: TOAD, SQL * Loader, SQL * PLUS, Data Loader, SQL Developer, Putty, Workflow Builder

RDBMS: Oracle 8i / 9i/10g

Operating Systems: Windows 98/XP/2000 and UNIX

PROFESSIONAL EXPERIENCE

Confidential - NJ

Techno-Functional consultant

Responsibilities:

• Involved in requirements gathering, analysis, development, QA and post-production support.
• Performed GAP analysis to ensure that the requirements are captured properly.
• Strong experience in working on ADI’s.
• Worked on analyzing different components as a result of physical and logical separation of MHF and MHE.
• Worked as a Member of the Production support system to address day to day issues.
• Provide production support by monitoring day to day processes, timely fix of the production problems encountered, data fixes and execution of the monthly, quarterly, yearly end batch processes and troubleshoot the issues for business users and business analyst.
• Worked on different inbound interfaces like Lawson to Oracle and Ariba to Oracle .
• Coordinate with business clients, support the application and implement the process as per specifications provided.
• Answer the technical queries, driving the product initiatives and metric collection and analysis
• Handled many of the technical issues such as Creation of Data Conversion script. Developing Interface programs, Custom forms, Custom reports, and Functionality customization
• Developed End User Training Documents
• Worked on SEPA and ACH payments.
• Worked on solving defects raised by QA team.

Environment: Oracle Applications R12 (AP, AR, GL, FA, CM and PO), AOL, Sys Admin, eBtax UNIX, Forms 6i, Reports 6i, XML Publisher reports, Toad, putty, winscp.

Confidential - TX

Techno-Functional consultant

Responsibilities:

• Involved in various activities like development of xml publisher reports, Form Personalization, Data Conversions and Interfaces.
• Involved in designing database packages using PL/SQL and optimizing them for best throughput.
• Strong experience in working on ADI’s.
• Provide the enhancements to the pre-existing objects in the current ERP system by coordinating with the functional team.
• Providing fixes to the Oracle apps support related issues that may come up during the production phase.
• This also includes the application users in understanding the application and setting up the environment up and running.
• Provide production support by monitoring day to day processes, timely fix of the production problems encountered, data fixes and execution of the monthly, quarterly, yearly end batch processes and troubleshoot the issues for business users and business analyst.
• Discuss business solutions with Confidential business analysts in resolving existing problems and improving the application stability.
• Coordinate with business clients, support the application and implement the process as per specifications provided.
• Requirements gathering and analysis, time estimates, preparing design documentation, design reviews, development testing and deployment of application enhancements, project planning.
• Answer the technical queries, driving the product initiatives and metric collection and analysis
• Worked on eBtax.
• Involved in Bank Loads of different countries.
• Review work products and deploying the application in the test environment and initiate the process of user acceptance testing.
• It includes fixing of bugs and fixing technical errors that may come up during the phase.

Environment: Oracle Applications R12(AP,AR, OM, GL, FA, CM and PO), AOL, Sys Admin, eBtax UNIX, Forms 6i, Reports 6i, XML Publisher reports, Toad, putty, winscp.

Confidential - CA

Techno-Functional consultant

Responsibilities:

• Involved in Customer Account Group sprint.
• Worked on form Customization to create a Dialog message on an LOV.
• Worked on bug fix of conversion code.
• Worked on developing a new fixed file format 20 in ORTF form using PL/SQL and Oracle.
• ORTF is an industry standard format for transmitting patient data between pharmacies.
• Created manifestations to deploy the code in UAT and other instances.
• Created new fields on ORTF form and made mappings accordingly.
• Created MQC design documents and code documents for Req ID.
• Involved in meetings on webex to discuss requirement gatherings.

Environment: Oracle Applications (AR, OM),Oracle Release12, SVN Tortoise, eBtax, UNIX, Forms 10g, PLSQL Developer, Toad, putty, win scp.

Confidential, Mason - OH

Techno-Functional consultant

Responsibilities:

• Involved in requirements gathering from business users.
• Created technical design documents to meet requirements.
• Involved in data mapping and conversion programs for moving items revisions from legacy systems into Oracle Inventory tables.
• Imported legacy journals in GL module using SQL loader and Journal Import.
• Used XML publisher to extract some of the Oracle seeded reports to excel format.
• Worked on Form Personalization to meet customer requirements in modules covering Payables.
• Defined new responsibilities, menus, hierarchies, security rules, and approval groups for users.
• Also included, restricting users access to certain forms and form functions using function security.
• Created multiple triggers, stored procedures, and packages as part of the design.
• Worked on Unix scripts to submit the concurrent programs and also for sending mail with Log file Attachment to users.
• Closely worked with DBA’s in applying patches. Logged service requests with Metalink for all severity issues.
• Created Oracle alerts as per the requirements.
• Responsible for running Receivables open interface, imported data into RA interface tables and used the Auto Invoice to import customer invoices.
• Designed Inv Job Work Register Report using Custom table.

Environment: Oracle Applications 11.5.10.2(AP, AR, GL, PO, INV, OM, FA, CM), Oracle Release12, SQL * Loader, UNIX, Forms 6i, Reports6i, PLSQL Developer, XML Publisher.

Confidential, CA

Technical Consultant

Responsibilities:

• Worked on coding of interfaces, RDF Reports and XML Reports.
• Designing of Technical Documentation like MD070, cv060.
• Worked on Suppliers conversion program to transfer legacy system data into Oracle EBS.
• Auditing of Test Cases of AP, PO, OM and AR modules.
• Creating and Debugging of Packages and Procedures & Functions.
• Designed table Scripts, File loader Scripts to move objects from one instance to other.
• Worked on PO Conversion to upload legacy systems data into Oracle 11i database
• Worked on Inbound Release Creation and Cancellation.
• Developed Release Outbound Interface.
• Developed PL/SQL Package to send automated mail to Suppliers using smtp connection.
• Designed VAT 515 Excel Upload Program using PL/SQL package.
• Developed Purchase Order Impex Report using xml publisher.
• Designed AR Daily Sales Report using Discoverer
• Customized PLA Report
• Developed Form ARE1 Report following the steps of standard Form ARE1 Report.
• Designed Payable Voucher Report using xml publisher
• Developed Central Excise Duty Payable Report in Discoverer for Excel format.
• Designed Price Break Details Report in Discoverer for output format in Excel
• Designed Cost Reduction Report using rtf Template.
• Developed Kanban Card label Report where Barcode was incorporated.
• Designed TKM Parts Shelf Label Report where no of Labels per page was fixed.
• Developed TKM Physical Inventory listing Report (PDF) in xml template where no of lines per page was fixed to 40.
• Designed TKM Detail pending Del note Report using rtf template.

Environment: Oracle Applications 11.5.10.2, Discoverer, XML Publisher, Forms 6i, Reports 6i, Toad, Modules-AP, PO, AR, OM, FA, CM Unix Scripting

Confidential

Technical Consultant

Responsibilities:

• Worked on coding of interfaces and Reports.
• Designing of Technical Documentation like MD200.
• Auditing of Test Cases of AP and AR module.
• Debugging Packages and Procedures.
• Involved in launching GE-support central cases and interactions with DBA’s and Clients
• Worked on TRL Tax Reporting Ledger Interface to upload legacy systems data into Oracle 11i database and ftp to the Corporate Tax Server.
• Developed Inventory Outbound Interface capturing Item and other information.
• Developed Purchase Order Outbound Interface to write data into flat file through UTL Package.
• Involved in Coding of different Packages and Procedures required as per client
• Written different SQL scripts to move the source objects from an instance to other and for varied purposes.
• Designed Request Sets and Concurrent Programs for uploading data into the Value Sets
• Developed Invoice Matching Report prior to PO Wise
• Developed Report to show PO’s in Pending Status by vendor wise.
• Customized AP Payment terms report.
• Worked on Item Categories details with Cost Report.

Environment: Oracle Applications 11.5.10, Forms 6i, Reports 6i, SQL*Loader, SQL Developer, SABRIX - AP, SABRIX-AR, Modules-AP, PO, AR, OM, Unix Scripting

Confidential

Technical Developer

Responsibilities:

• Preparation of Technical Documentation.
• Performed Functional and Sanitary testing for AP module.
• Testing - unit testing & integration testing.
• Preparation of SQL Loader scripts.
• Involved in Client meetings.
• Worked on Suppliers & Supplier Sites Conversion.
• Developed Payables Outbound interface to write approved Invoices into flat file using UTL Package.
• Customized Invoice Aging Report.
• Developed Move Order Report.
• Customized Invoice Register Report
• Customized a Payables form to accept invoices dated between 25th and the end of the month.
• Adding the Triggers in Form Level, Block Level and Item Level.
• Attaching Calendar to Date Fields.
• Updating who columns.

Environment: Oracle Applications 11.5.10, Forms 6i, Reports 6i, Sql * Loader, Toad, Modules-GL, AP, PO, Unix Scripting

Confidential

Technical Consultant

Responsibilities:

• Developed Reports as per client requirement.
• Developed Forms as per client requirement
• Developed PL/SQL Packages, Procedures and Functions.

Environment: D2k & Oracle 8.0