SUMMARY

• 11 years’ experience in Oracle Applications as a Techno - functional consultant with good knowledge in coding and testing of software applications and having in-depth knowledge in Oracle Application 11i/R12(12.0.6,12.1.1,12.1.3), Framework9i, OAF,ADF,SOA, XML/ BI Publisher, OBIEE, Discoverer10g, Oracle9i/10g/11g, Forms6i/10g, Reports6i/ 10g, Oracle Alerts, Oracle J-developer(10g), Oracle Applications, workflow Builder2.6, PL/SQL, Triggers
• Worked extensively in Oracle Applications Release 11i and R12 covering all Financials which includes Oracle General Ledger, Oracle Receivables, Oracle Payables, Oracle Fixed Assets, Cash Management, Oracle Purchasing, I-procurement, oracle order management,
• Experience in coordinating the calls in Onshore and Offshore Teams
• Good Experience in implementing the entire Order-to-Cash (O2C) and Procure-to-Pay (P2P) life cycles
• Experience in creating, modifying Forms6i/10g, OAF pages for extending and customizing applications as per the business needs
• Served as Team lead for multiple oracle implementations and various key projects
• Documenting business requirements, analyzing impact of the changes, preparing functional, technical specifications, developing, configuring and performing unit testing as well as assisting the users in the UAT phase, all of this following oracle AIM methodology.
• Involved in project rollouts and implementations facilitating the better usage of the system, as well as maintenance and support e-business environments by providing techno functional support of operational business implementations.
• Extensive technical experience in RICEW (Reports, Forms, Interfaces, Conversions and Workflows) Components
• Excellent technical skills in developing Extensions, Interfaces and Conversions in the domain of Oracle Applications E-business suite
• Experience working with Oracle Self Service applications, JDeveloper, Key Flex fields, Descriptive Flex fields, Profile Options, System Administrator activities (Creating Users, Responsibilities, Menus, and Functions) and Oracle Concurrent Manager
• Extensive experience in preparation and Review of BRDs, Gap Documents, MD50, MD70, Test Strategy and Test Plan Documents.
• Extensive experience in communicating with users, Functional team to assist them in gathering requirements and preparation of the MD 50 documents
• Sound knowledge of oracle application Framework and MVC architecture
• Excellent Communication skills, interpersonal skills and strong analytical & problem solving abilities
• Agile in learning and doing things in effective manner.

TECHNICAL SKILLS

Oracle Financials: oracle General Ledger(mass, planning and funding budgets ), Oracle payables, Oracle Receivables, Oracle projects, Cash management, Oracle Fixed Assets, I-Expenses, I-Procurement, ME

Oracle Distributions: Oracle Purchasing, Oracle order management, I-Procurement

Oracle Manufacturing: Oracle Inventory, Oracle order management

Oracle SCM: Service Contract

Technologies: PL/SQL, Reports6i/10g,Forms6i/10g,Sql loader, XML Publisher, Workflow, MS office, Toad, Sql Developer, SQL*plus, Shell Scripting, FND loader script, C, C++, Core Java, JDeveloper, ADF, OAF, Putty, Win sap, PVCS, HTML, DHTML, XML, Kintana, Oracle applications Release R12,115.10.2,11.5.10 &11.5.9, oracle 8i/9i/10g,OraRRP tool, Web logic server

Web Technologies: HTML, DHTML, XML

Advanced Technical tools: OAF, ADF, SOA, Web logic Server, Forms and Reports 11g,BI Reports, OBIEE, Fusion middle ware

PROFESSIONAL EXPERIENCE

Confidential, BOCA Florida

Sr. Techno-functional Consultant

Responsibilities:

• Developed UI fragments, templates and bounded task flows using J-developer 11g
• Developed Customers and Projects Interface
• Used pl/sql developer to import the customer information provided in the form of flat files into staging tables
• Developed invoice holds report using Discoverer.
• Analyze the Functional specification received from client.
• Analyze the Business requirement documents and knowledge transfer sessions.
• Customize and convert existing RDF reports that will run compatible as per the new multi-org structure and user requirement.
• Coordinated with the offshore team to get the requests done.
• Daily Development Interaction with Technical leads for status and any other outstanding issues.
• Worked as a Member of the Production support system to address day to day issues.
• Prepared the Technical Design documents, Installation documents and Unit Test Case documents.
• Implemented procedures for debugging and integration of all assigned software products.
• Provided technical assistance for designing and development of ADF task flows for business processes.
• Supported technical team members for integration functions with web services and business components.
• Participated in all phases of application and product development lifecycle through Oracle ADF technologies.

Environment: OAF, Oracle PL/SQL, Oracle R12 (12.1.3), Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 6i (Forms, Reports and Workflow), XML Publisher, Oracle Database, JDeveloper, TOAD, Projects

Confidential, Miami, FL

Oracle P2P Technical Lead

Responsibilities:

• Analyze the Functional specification received from client.
• Analyze the Business requirement documents and knowledge transfer sessions.
• Design and developed user interface components usingADF Rich Faces.
• Integration between the java and oracle applications.
• Customizations and personalization for forms and oaf pages.
• Developed xml reports from the foundation
• Designed and developed migration scripts for all activities and GL migration.
• Used SQL *Loader control file to import the customer information provided in the form of flat files into staging tables
• Developed PL/SQL program to perform validations and to relate customers with addresses, contacts, banks and profiles and move the data from staging table to interface tables
• Developed custom reports for billing history by client and Invoices by client report using Discoverer.
• Designed and customized the following reports using Oracle Reports Builder 6i in OM and Service Contracts commission payment details form developed at AR
• Responsible for developedADF Data Controlsfrom Web Services and Java Components

Environment: ADF,OAF, Oracle PL/SQL, Oracle E-biz Applications 11i and R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 6i (Forms, Reports and Workflow), XML Publisher, Oracle Database, JDeveloper, SQL Navigator, TOAD.

Confidential

Sr.Oracle Techno-functional lead

Responsibilities:

• Developed the BI Publisher reports
• Created the suppliers and employers in purchasing module
• As per the new requirement I have incorporated the intercompany logic at all interfaces
• Created the requisitions and purchase orders
• Fixed the issues at workflow packages.
• Personalized OAF page at I-procurement
• Requirement Gathering and Analysis
• High Level Design
• P2P cycle implementation
• Functional and Technical Documentation
• Development and Coding
• Added new DFF fields at Invoice Summery form 6i
• RICE objects developed

Environment: ADF,OAF, Oracle PL/SQL, Oracle E-biz Applications 11i and R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 6i (Forms, Reports and Workflow), XML Publisher, Oracle Database, JDeveloper, SQL Navigator, TOAD.

Confidential

Sr.Oracle Techno-functional

Responsibilities:

• Rebuild charge account for oracle application frame work.
• Responsible to do analysis and find out process gaps on recurring issues and publish a “Root Cause Analysis Report”.
• Invoice hold approval workflow, I expense workflow, Purchasing Requisition workflow(add some part of code above packages)
• Print purchase order xml Report extension
• Interacting and working with the Users for the issues and the bug fixing.
• Involved in Preparing the clarification document, Technical documents as per AIM methodology, Test case Documents
• Developed new scratch from at AR

Environment: OAF, Oracle PL/SQL, Oracle E-biz Applications 11i and R12, Oracle Order Management, Oracle Advanced Pricing, Inventory, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Developer 6i (Forms, Reports and Workflow), XML Publisher, Oracle Database, JDeveloper, SQL Navigator, TOAD.

Confidential, TX

Oracle Functional

Responsibilities:

• Supplier search form developer from starting and register in purchasing responsibility
• Extended VO & CO
• Added some columns in existing region
• Change the business logic in process form request
• Developed PPR page in Inventory
• Collecting inputs and providing the specifications in a functional design document to technical team to develop the reports and customizations for the client.
• Preparing weekly status reports to be send to client

Environment: OAFramework10g, Workflow builder2.6 Oracle 9.2.0.5.0, 10g Release 2 Oracle Apps R12.0.6, Discoverer 10 G, Report Builder 6i, 10g Form Builder 6i, 10g UNIX, Toad

Confidential, New York

Oracle PL/SQL

Responsibilities:

• Requisition interface done in I procurement module
• Print perchance order
• Change requisition approval workflow notification.
• Developed Advance pricing from in OM

Environment: OA Framework, Oracle 9i, PL/SQL, Report Builder 6i, Form Builder 6i, XML Publisher, Discoverer 10G

Confidential, Boston, MA

Oracle Developer

Responsibilities:

• Developed and Reviewed & tested the deliverable components as per standards and guidelines provided by client
• Testing rdf /xml reports in client’s testing environment(Development, QA, Production)
• XML reports on OM, AR, OPM and AP.
• Discoverer reports in development.
• Workflow developments for OPM module.
• Developed Interfaces for OPM module
• New oracle apps forms developed varies modules

Environment: Report Builder 6i, Form Builder 6i, XML Publisher, Discoverer 10G

Confidential

Oracle Developer

Responsibilities:

• Responsible for preparing Test scripts, Setup documents, Standard Operating Procedures, Other documents.
• Preparing Problem Description note highlighting the issue as well as the expected behavior (capturing screen shots and error log files of problem areas wherever necessary)
• Resolving tickets related to Financial Modules in Remedy tool set by user.
• Providing production Support Purchasing
• The PO approval hierarchy assignment as well as providing hierarchy details as per client request
• Provided report that would show the remaining quantity details as of date for any PO as per client requirement
• New Supplier creation and assigning bank to the corresponding supplier at site level.
• Automation process for supplier Invoice upload
• Customized oracle standard cheque print report to print cheque as per Indian rupee format and fields included as per client requirement
• Bill Run process.
• Journal import and AR Period closure.
• Automated the process for assigning sales person to the corresponding customer site level.
• Monitoring and support of daily run customer interface

Environment: Oracle applications R12 for Finance modules (GL, AP, AR, CM, FA, PO, INV, OM) Oracle 9.2.0.5.0, 10g Release 2