SUMMARY

• Having 7 years of extensive experience in IT industry as Oracle applications techno functional consultant.
• Proficient in AR, GL, FA, OM, PO and INV modules. Effectively involved in gathering & analyzing business requirements, translating them to technical requirements.
• Experience in various SDLC phase like Requirement Analysis, Project Planning, Design, Coding, Testing and Implementation phases
• Effectively involved in EBS R12 Implementation, Upgrade and Production Support Projects.
• Having very good knowledge in AR month end & reconcile process.
• Experience includes execution of Oracle Applications implementations including the exposure to e - Business suite R12, numerous Application Support projects with high level of Customer Satisfaction.
• Expert in PLSQL & SQL tuning concepts
• Hands on experience in various reporting tools like BI Publisher, XML Publisher & Oracle Discoverer.
• Good expertise in Oracle forms personalization, shell scripting.
• Expert in development of RICEW Components.
• Having very good knowledge in converting business requirement into design requirements and doing proof on concepts for client demos.
• Involved in various testing cycles like SIT, CAT etc. and prepare test scenarios for the same.
• Implemented AIM methodology during the development of objects.
• Self-motivated and dedicated fast learner with good communication, interpersonal skills and Conversant with SOX Procedures.
• Experience in Data Loader and ADI Tools.

TECHNICAL SKILLS

ERP Releases: Oracle Applications 11i, 12.1.1

ERP Modules: Expertise Oracle Receivables, General Ledger, Oracle Order Management,, Inventory, Purchasing, Fixed Assets Exposure to HRMS,OPM(Oracle Process Manufacturing)

ERP Methodology: AIM

Languages: PL/SQL, SQLOracle Tools Oracle Discoverer 10g, XML/BI Publisher, Oracle Forms / Reports 6i, SQL Loader, SQL Plus, PL/SQ, Oracle Forms Personalization, Shell Scripting, Oracle Workflow builder.

Data Archiving Tool: Informatica Informia Archive 5.3 for (Oracle Apps R12)

PROFESSIONAL EXPERIENCE

Confidential

BSA (Business System Analyst)

Responsibilities:

• Developed various Conversions like Items, Item Categories in Inventory.
• Developed Sales org Assignment Program.
• Developed UDA Item attributes program.
• Customization and enhancements of adhoc reports using BI Publisher/XML Publisher and Discoverer.
• Creating design documents for customer requirements and prepared technical design documents and coding.
• Involved in Performance Tuning of team objects.

Confidential

Techno Functional Consultant

Responsibilities:

• Developed various Interfaces like Receipts, AR Invoices, Sales Orders, and GL etc.
• Developed various conversions like Customers, Suppliers.
• Worked on Move order API "INV MOVEORDER PUB" for processing move order automatically in Order Management.
• Developed Fixed Asset Numbering program using Form Personalization.
• Create new GL Code combinations related mappings between Oracle and legacy system.
• Troubleshooting interfaces in Oracle including GL Interface, AR Invoices etc.
• Developed shell scripts for generating dynamic SQL* loader control files for inbound files coming from various source systems.
• Developed Employee Interface, which contains person creation, assignment of employee, Updation and termination of employee.
• Developed custom workflow in HRMS for the Employee address details changes.
• Developed various adhoc reports for AR, OM using BI Publisher.
• Preparing automatic loader scripts for AOL components (Ldt files).
• Developed Sales Order Acknowledgement report with BARCODE functionality and Form personalization.
• Developed XML layouts for standard Sales Order Acknowledgment and Packing Slip reports in OM.
• Involved in Performance Tuning of team objects.
• 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 object migrations in various instances and perform end to end scenarios as part of system integration testing.
• Creating design documents for customer requirements and shared the same with developers to prepare technical design documents and coding.
• Lead for knowledge transfer sessions while handover the objects from Development team to Support team.
• Prepared test scenario documents for System Integration Testing and Customer Acceptance Testing.

Environment: Oracle Applications Release 12, Unix, Oracle 10g, BI Publisher, Workflow builder, Oracle pl/sql, Oracle

Confidential

Sr. Oracle Techno- Functional Consultant

Responsibilities:

• Analyze & provide estimates of RICEW components and share the same with project teams
• Developed GL Interface program to validate and import Journals into GL.
• Customization on Bank Interface program & Payaway Bacs Payment File program.
• Worked on Shipping API’s and Shipping Transaction Form Personalization.
• Worked on Purchase Order Interface program.
• Developed report for Deferred Revenue.
• Developed Multi lingual invoice print report using XML publisher.
• Impact analysis of Reports in various modules due to upgration and provide design solutions for reports customizations.
• Preparing automatic loader scripts for AOL components (Ldt files).
• Customization and enhancements of adhoc reports using BI Publisher/XML Publisher and Discoverer.
• Preparing installation instruction document templates.
• Developed custom views and procedures to ease of business requirements.
• 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

Environment: Oracle Applications Release 12, Linux, Oracle 10g, BI Publisher

Confidential

Oracle Techno- Functional Consultant

Responsibilities:

• Developed interface to archive the Intransit status Trips in shipping module.
• Customizations on standard reports to support the archive functionality.
• Tested the custom reports and interfaces after archiving activity and thereby rendering support for day to day business activities.
• Prepared Business Requirement Documents with the Business rules Associated with to archive the daily transactional data across different Operating units for 9 fiscal year until Sep-2007.
• Attended session from Informatica team understanding its N-Tier archiving process.
• Prepared Business Test scripts with the Business rules associated with it to test the data integrity of archived data.
• Coordinated the Kick off meetings and discussion to impart knowledge to the users on the archiving Tool provided by Applimation and its approach for archiving the data.
• Coordinated meeting and interactions with the Business users at their plants and facilitated discussions with end-users/managers to gather functional requirements to match their Business process with the Business rules provided by the Data archiving tool.
• Analyzed the Non-Archival data that is being failed by a business rule and analyzing the cause for it with the Super users of the Business.
• Incorporated the scope of framing new business rules for archiving the non-archival data.
• Extensively involved in writing Business logic mapped queries to get the filtered data for archiving.
• Coordinating with client through Concalls and WEBEX sessions to have timely meeting discussion to carry out the project deadlines dates on time.

Environment: Oracle 11.5.10.2, Oracle R12, Unix, PL/SQL, SQL, Oracle Reports 6i.

Confidential

Oracle Techno- Functional Consultant

Responsibilities:

• Worked on AR Receipts Conversion, to convert receipts data from legacy system to AR module. This was very complex conversion .as complex logic was involved during the conversion, which included all the functionality of AR Receipts.
• Worked on AR Receipts interface, which is similar to the Receipts conversion.
• Developed Payroll interfaces.
• Involved in setting up Customers, Bank Accounts, Bank branches, Receipt Classes, Receipt Methods, Receipt DFF, Payment Methods, and Receivables Activities.
• Worked on new implementations of RICE and customization of existing RICE components and enhancements.
• Developed a shell script for common data loading purpose, which got widely used across all conversions.
• Prepared CV060’s, MD70’s and MD120’s.
• 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.

Environment: Oracle Applications R12, Database 10g, Unix, Oracle Forms, Oracle Reports, Oracle Discoverer, Visual Source safe, Oracle XML Publisher

Confidential, NJ

Oracle Consultant

Responsibilities:

• Designed Fixed Assets Conversion which is a conversion from legacy systems
• Worked on GL Transactions conversion.
• Worked on an outbound interface Positive Payee file outbound interface for generating a payment file for BoA.
• Involved in setting up.
• Payment Terms, Suppliers, Banks, Request Sets, Location Flex fields, Asset Key flex fields, Asset Books(Tax & Corporate), Category flex fields, Asset Types.
• Incorporated Barcode functionality in reports.
• Coordinated on Production support issues from near shore (Boston) for their different operating units.
• Worked on new implementations of RICE and customization of existing RICE components and enhancements.
• Prepared CV060, MD070 and MD120 as part of the development process.

Environment: - Oracle Applications 11i (11.5.10), Database 10g, Windows 2003, XML Publisher, Oracle Reports, Oracle Forms, Windows command files( instead of Unix Shell Scripts), Oracle JDeveloper.

Confidential, Libertyville, IL

Oracle Analyst

Responsibilities:

• Worked on an outbound interface for payables module (Processing EFD Payment formats).
• Worked on inbound interfaces for receivables module.
• Developed barcode reports using XML publisher for carrier labels (Oracle Shipping).
• Worked on Order Management, developed Shipper Reports related to K & C (Custom module).
• Developed Carrier interface reports in XML Publisher related to Order Management.
• Customized AR Invoice report.
• Developed XML publisher reports for CRM, Inventory module.
• Developed Oracle discoverer reports for Fixed Assets Module.
• Worked on Forms personalization for two standard forms (Sales Order form and fixed assets) in Order management and Fixed Assets.
• Involved in setups:
• Payables Payment Formats, Payment Programs, Control Payables Periods
• Define Banks for Suppliers, Document types, Payables Lookups, Payables Options, Payment terms, Payables Documents.
• Developed Oracle 6i reports for modules including, Shipping and Inventory etc.
• Worked on new implementations of RICE and customization of existing RICE components and enhancements.
• Prepared CV060, MD070, MD120 and CM040 as part of the development process.

Environment: - Oracle Applications 11i (11.5.10), Database 10g, Unix, XML Publisher, Oracle JDeveloper, Oracle forms, Oracle reports, Oracle discoverer, Order Management, Shipping and Inventory Modules.

Confidential, Pittsburgh, PA

Oracle Technical Consultant

Responsibilities:

• Developed Customer conversion Master import program.
• Developed Inbound interface program for Open receivable Invoices.
• Developed Address labels report in Order Management using XML Publisher
• Developed Sales Order Acknowledgment report in Order Management using XML Publisher and Form Personalization.
• Verified data integrity issues and job failures and resolving the failures on the fly.
• Monitored jobs closely and informing the concerned teams so that the jobs are restarted immediately without affecting the production process.

Environment: Oracle Applications 11i (11.5.10), Database 10g, Unix, XML Publisher, Oracle JDeveloper, Oracle forms, Oracle reports

Confidential, CA

Oracle Technical Consultant

Responsibilities:

• Developing/customizing Pl/sql program units using dynamic sql.
• Enhancement and support for GL, FA and AR modules.
• Responsible for recording the test cases for various modules.
• Customized various existing forms and reports.
• Involved in migrating the objects.
• Developed new custom forms and reports as per the business requirements for the end users.
• Involved in test case requirements, functionality, designed testing strategy and approach.
• Defined the procedure of testing and successfully generating result sets for the same.

Environment: Oracle applications 11.5.8, Oracle 10g, Oracle AOL, Data Loader

Confidential

Oracle Developer

Responsibilities:

• Developed Receipts Interface Program, which will convert Navis, receipts to Oracle receipts using Oracle Standard API.
• Imported Fixed Assets data using Data loader and ADI tools.
• Developed BACS and SWIFT format reports.
• Responsible for recording the test cases for various modules.
• Studied the test case requirements and functionality, designed testing strategy and approach.
• Defined the procedure of testing and successfully generating results sets for the same.

Environment: Oracle Applications 11i (11.5.8), Oracle Database 9, Oracle repots, Oracle plsql, Visual Source safe.Modules Involved: FA, PO, AP, and A