• Over 7 years of experience as anOracle Applications R12/11i E Business Suite Techno Functional Consultant, with expertise in General Ledger GL , Account Payables AP , Accounts Receivable AR , Fixed Assets FA , Purchasing PO , Inventory INV , Order Management OM , e-Commerce Gateway ECE , Bill of Materials BOM , Costing, Work in Process WIP andEnterprise Asset Management eAM .
• Ability to troubleshoot and recommend suggestions to resolve conflicts between business requirements and standard System Functionality.
• Experience with Oracle applications including Technical roles and supervisory positions in all phases of design, development and implementation of Oracle E-Business Suite.
• Expertise in the design and development of RICE Reports, Interfaces, Conversions Enhancements components in the area of technical design, development, Integration testing and deployment.
• Expertise in developing and customizing Reports and Forms in Oracle E-Business Suite R12/11i, Oracle Reports/Forms 10g/9i/6i, Workflow, XML Publisher 5.6.3/5.6.2.
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Extensive development experience in creating stored procedures, Packages, Triggers, Functions, Indexes and Views.
• Proficient in Performance Tuning of SQL statements using EXPLAIN PLAN, SQLTRACE and TKPROF.
• Proficient in personalizing Oracle Forms using FORMS PERSONALIZATION.
• Experience in using Oracle tools like SQL Navigator, SQL Loader, Data Loader, FND LOAD, SQL developer and TOAD.
• Highly skilled in Oracle Order to Cash O2C and Procure to Pay P2P Process.
• Experience in customizing oracle workflows based on the business requirement.
• Proficient in project documentation including BR100, MR100 and MD050.
• Excellent Project Development and Technical skills.
• Ability to communicate business Goals and Objectives in an effective way.
• Attention to details with good Organizational and communication skills.
• Implementation expertise on Business requirements gathering, Requirement Mapping Conference Room Piloting , Solution Design, Setups, Strategize and prepare Test Plan for Unit Testing, SIT and UAT, Generating Trace and Explain plans, User Training, Documentation Test scripts, Presentations, Version control, Training Materials, Workshops contents, Quick Reference manuals.

• Programming Languages : SQL, PL/SQL, Kintana, PVCS
• GUI Reporting Tools : SQL Plus9.0, SQL Loader, Forms10g/6i,Reports10g/6i, TOAD
• 8.6.1/7.4,SQL Navigator, Workflow, Forms Personalization
• Databases : Oracle 11g/10g/9i/ 8i/8.0/7.3
• Application Software :MS-Word/Excel/PowerPoint
• ERP : Oracle Applications R12/11i General Ledger GL , Accounts
• Receivable AR , Accounts Payables AP , Fixed Assets FA , Purchasing PO , Inventory INV , Order Management OM ,e-Commerce Gateway ECE , Bill of Materials BOM , Costing, Work in Progress WIP and Enterprise Asset Management eAM

• Data Mapping
• Conversions
• Reports and Forms development
• Sql and Pl/Sql Coding
• Documentation
• End user Training
• Post implementation Support

Confidential

Oracle Techno-functional Consultant

• Conducting gap analysis with client to discuss the possibilities of R12 Upgrade vs. Implementation.
• Worked on Oracle eAM to import Items using standard APIs and Interfaces.
• Developed a Custom Form and Outbound Interface in Accounts Receivable to send Oracle Order Information to JDE system.
• Worked on EDI orders Implementation.
• Worked on enhancements of Customer Facing Document Reports in Quoting and Service Contracts SC.
• Developed the Service and Contracts SC parts of the Population Report, monitored the report performance and handled data issues like missing contracts, invalid contract end date, null territory id.
• Developed PL/SQL Procedures to convert data in custom tables to service contracts using Service Contract SC APIs.
• Developed a new inbound interface for importing the shipping data from legacy system to oracle applications using pick confirm and ship confirm API's for supplies orders.
• Involved in CRP implementation phase and also in preparation of BR100, BP040, BP080 documents.
• Interaction with Business Users to understand better their pain points and Key requirements.
• Developed an outbound interface program to transfer Invoices.
• Developed reports and customized standard Oracle reports using Report Builder 10g and BI/XML Publisher.
• Created forms personalization's based on business requirements.
• Designing and Developing Demo sessions for the Modules with the Respective users for R12 Environment.
• Configure the Assets system to Route Capital Assets through Project module as appropriate to record depreciation monthly.
• Prepared detailed test scripts on Invoicing with rules and demonstrated the functionality to the users.
• Prepared test cases to evaluate multiple RICE components.
• Gathering Business Requirements for Upgrade considerations and documenting them.
• Trained the users and explained the basic flows of the financial modules.
• Created conversion programs for Data Migration of the master data and transaction data.
• Involved in UAT and SIT with preparation of test scripts.
• Involved in Invoice Print Program customizations.

Environment: Oracle Applications R12 AP, GL, AR, FA, PO, OM, ECE, INV,WIP, BOM, eAM , Oracle 10g, SQL Loader, TOAD, Forms10g, Reports10g, BI Publisher, Workflow, UNIX Shell Scripting.

Confidential

Oracle Applications Techno-functional Consultant

• Perform internal analysis and implementation of R12 EBS. Develop Business process flows for AR and AP respective modules and identify the gaps.
• Present the identified gaps and work with business owners/users in the design sessions. Mapped the future state process requirements in AP and AR.
• Configured GL, AP and AR. Worked in Revenue Recognition functionality considering accounting and audit requirements.
• As part of Conversions from legacy to Oracle systems, developed conversion programs as per business requirements.
• Developed reports and customized standard Oracle reports using Report Builder 10g and BI/XML Publisher.
• Created forms personalization's based on business requirements.
• Define system options, Accounting Option, Lookups, Define suppliers, Payment Terms, customers Accounting rules and Receivables transaction source, transaction types.
• Assisted in developing and testing of invoices from third party systems
• Led the test sessions for GL, AP and AR modules. Performed unit, End to End tests and assisted in UAT sessions with preparation of test scripts TE40.
• Perform develop and document systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality.
• Performed role of Primary support analyst providing production support of Oracle GL, AP, AR, modules covering huge client base.
• Implementation of Basic setups of Project Accounting modules Costing and billing and trained the users on basic flow of project accounting process.

Environment: Oracle Applications R12 AP, GL, AR, FA, PO, OM, ECE, INV, WIP, BOM, eAM , Oracle 10g, SQL Loader, TOAD, Forms10g, Reports10g, BI Publisher, UNIX Shell Scripting.

Confidential

• Involved in implementation of eAM module
• Mapping fields from existing legacy system to Oracle system and creating conversion programs.
• Components include Migration Programs, Interfaces, Reports, Forms Personalization
• Worked on business requirements and documentation
• Interaction with the Product Management, Quality Assurance team and support teams

Environment: SQL, PL/SQL, Oracle E-Business Suite, Reports, Forms, Forms Personalization, XML publisher

Techinal Consultant

Confidential

• Implementation of new requirements and code changes
• Verified the components in PO module to rectify runtime issues
• Fixing of post go-live issues
• Creating oracle service requests and interacting with oracle support for resolving critical issues and bugs

Environment: SQL, PL/SQL, Oracle E-Business Suite, Reports, Forms, Forms Personalization, XML publisher

Technical Consultant

Confidential

• Fixing Quality Issues and reducing the runtime of reports.
• Testing components and making changes to existing components.
• Working on new requirements from business which involved using Oracle reports builder and XML publisher.
• Interaction with the Product Management, Quality Assurance team and support teams

Environment: SQL, PL/SQL, Oracle E-Business Suite, Reports, XML publisher

Techinal Lead

Confidential

• Implementation of new requirements and code changes.
• Worked on modules involving Inventory, Order Management and Purchasing
• SIT and UAT testing for RICE components
• Monitoring and helping the team members
• Fixing of post go-live issues
• Worked on business requirements and documentation

Environment: SQL, PL/SQL, Oracle E-Business Suite, Reports, XML publisher