We provide IT Staff Augmentation Services!

Oracle Applications Techno Functional Consultant Resume

SUMMARY

  • Oracle Certified Techno - Functional Consultant wif around 12 years of extensive experience in User Requirement Study, Analysis, Solution Design, Development, Implementation, Set Up, Testing, Customization, Maintenance, Support, Data Migration and Reporting
  • Certified professional scrum master wif over five years of managing teams
  • More TEMPthan 8 years of experience at client location
  • Experience in business process analysis, mapping and module configuration. Primary areas of concentration has been Oracle Applications Order Management, Install Base (IB), and Field Service(FS), Service Contracts wif exposure to WIP/BOM, Accounts receivables(AR),Quoting
  • Experienced in Oracle Release 12 RICE implementation
  • Strong in noledge of Oracle Tools including SQL, PL/SQL, SQL Loader, TOAD.
  • Extensive experience in Application Object Library (AOL), System Administration for Registration of Forms, Reports, other concurrent programs,workflow administration, business events
  • Performs unit and integration tests for constructed code to ensure functional completeness and TEMPhas commendable hands on experience in Hp Quality Center Tool for testing
  • Performed integration evaluation between Oracle and sales force.com and TEMPhas high-level experience on salesforce.com
  • Managed multiple modules, key activities entail designing, mentoring team, interfacing wif clients and staff during project cycles and meeting different milestones and delivery dates
  • Extensive experience of designing Oracle Forms & Reports 9i,workflow builder including creation of triggers, program unit, blocks, templates and dealing wif data model, Layout editor, navigation and tuning
  • Involved in Design and develop database objects and structures for data storage, retrieval and reporting according to project specifications including the creation, modification, testing, performance tuning, and review of tables, stored procedures, database functions, and triggers
  • Skilled in resource management(Managing 6-7 Resources offshore and onsite)
  • Experienced in production support of customizations
  • Experienced in all stages of documentations in the implementation life cycle(SDLC)
  • Comprehensive problem solving abilities, excellent verbal and written communication skills, strong interpersonal skills, willingness to learn, leadership skills, and team Player

TECHNICAL SKILLS

ERP: Oracle applications 11i/R12 Order Management Order to Cash, Install Base, Service Contracts, Quoting, CRMHigh level Knowledge on oracle Receivables, Customer Master integration wif salesforce.com, Purchasing, Human Resources, Field Service

Database: Oracle 10g, 9i, 8i

Operating Systems: UNIX and WINDOWS XP

Languages: SQL, PL/SQL,, basic Unix Shell scripting

Tools/Utilities: Toad, SQL*Plus, SQL*Loader, Oracle Forms 6i, Reports 6i, workflow builder, xml publisher

HP Quality: Center, BMC Action Remedy, Apache Subversion(SVN)

Microsoft Visual Source: Safe(VSS), Service Now,Salesforce.com, Quest Stat tools,Heat

MS Tools: MS Word, Excel, Power Point, Publisher, Visio

PROFESSIONAL EXPERIENCE

Confidential

Oracle Applications Techno functional consultant

Responsibilities:

  • Coordinated and managed the activities between offshore development team and onsite business team for various business enabled enhancements
  • Completed gap analysis and changes for CRM modules in R12.0.4 to R12.2.5 upgrade
  • Designed and implemented new service offerings and integrated from quoting to oracle service contracts
  • Developed and supported oracle to Getpaid interface file creation
  • Developed and Supported custom UWQ UI for Service Request management
  • Worked in Design/development/Functional Evaluation on extensive customizations Install Base /Quoting/ Service Contract /Field Service modules of Oracle EBS
  • Planned and executed functional evaluation for various customizations in Quoting/Install Base/Service contracts /Field Service Modules
  • Planned and executed various customizations in Quoting/Install Base/Service contracts /Field Service Modules
  • Actively involved in daily production support of various oracle modules Install Base /Quoting/ Service Contract /Field Service/Customer Master/HR
  • Manage offshore and onsite teams day to day activity
  • Provide timely project status report to client
  • Requirement Gathering and elicitation of business requirement
  • Creating Functional and technical designs
  • Involved in design and development of complex customization to support specific business scenario
  • Responsible for creation/monitoring and progress of Oracle Service Request in ERP/CRM modules over Oracle Support link(metalink)
  • Involved in documentingthe businessprocess by identifying the requirements
  • Involved in deciding ample design and development method/technology
  • Involved in functional test planning and execution
  • Testing - Functional Testing, Integration Testing and prepared test scripts TE20,TE40
  • Prepared various requirement documents(MD050,BRC), Design documents(MD070,SD60)
  • Designed and created various database objects like Tables, Indexes, Views, Triggers, Synonyms
  • Responsible for writing SQL queries, creating Packages, Stored Procedures, Procedures, Functions, Triggers, Cursors and Materialized views using TOAD, SQL Developer, SQL*Plus in Oracle 10g

Environment: Oracle Applications R12. RDBMS Oracle 10g, OA Frame work

Confidential

Oracle Applications Techno functional consultant

Responsibilities:

  • Working as a liaison between business and IT team at client location for more TEMPthan 4 years
  • Analyzed gap for 11i to R12 conversion in service contracts and installed base for Oracle
  • Worked in Design/development/Functional Evaluation on extensive customizations in order Management, Install Base /Quoting/ Service Contract modules of Oracle EBS
  • Planned and executed functional evaluation for various customizations in Order Management/Quoting/Install Base/Service contracts Modules
  • Thoroughly involved in functional evaluations of sales force.com to oracle integration for customer master /quoting and order management
  • Designed /Developed Quote to Order integration for custom Requirements
  • Requirement Gathering and elicitation of business requirement
  • Creating Functional and technical designs
  • Involved in design and development of complex customization to support specific business scenario
  • Responsible for interaction wif business users and process teams for validating the requirements
  • Responsible for creation/monitoring and progress of Oracle Service Request in ERP/CRM modules over Oracle Support link(metalink)
  • Involved in documentingthe businessprocess by identifying the requirements
  • Involved in deciding ample design and development method/technology
  • Involved in functional test planning and execution
  • Testing - Functional Testing, Integration Testing and prepared test scripts TE20,TE40
  • Prepared various requirement documents(MD050,BRC), Design documents(MD070,SD60)
  • Worked salesforce.com data loader and certain administrative functionalities on high level
  • Designed and created various database objects like Tables, Indexes, Views, Triggers, Synonyms
  • Responsible for writing SQL queries, creating Packages, Stored Procedures, Procedures, Functions, Triggers, Cursors and Materialized views using TOAD, SQL Developer, SQL*Plus in Oracle 10g

Environment: Oracle Applications R12. RDBMS Oracle 10g, OA Frame work

Confidential

Oracle Apps Technical Consultant

Responsibilities:

  • Creating technical designs
  • Designed and developed fully customized form for service contract creation and maintenance in Oracle Apps
  • Analyzed gap, designed and executed Field Service data conversion from legacy system to Oracle Apps (11i)
  • Designed and developed daily business reporting statistics for client at high level
  • Creating technical designs
  • Development - Coding of adhoc concurrent programs, forms,reports
  • Testing - Functional Testing, Integration Testing
  • Imapact Analysis
  • Co-ordination wif Onsite functional team
  • Conversion from legacy application to oracle EBS for various ERP and CRM modules
  • Designed and created various database objects like Tables, Indexes, Views, Triggers, Synonyms
  • Responsible for writing SQL queries, creating Packages, Stored Procedures, Procedures, Functions, Triggers, Cursors and Materialized views using TOAD, SQL Developer, SQL*Plus in Oracle 10g
  • Worked on Forms customization and form personalization.
  • Worked on Reports 6i and workflow builder
  • Prepared various requirement documents(MD050,BRC), Design documents(MD070,SD60)
  • Environment: Oracle Applications 12(Advanced Collections). RDBMS Oracle 10g, Oracle Forms, XML Publisher

Confidential

Oracle Apps Technical Consultant

Responsibilities -

  • Creating technical designs
  • Developing day to day enhancement and production bug fixes
  • Mentoring and guiding offshore team
  • Co-ordination wif onsite team, IKON process group
  • Unit Testing
  • Responsible for timely delivery of developed components

Environment: Oracle Applications 11i (Service Contracts, Field Service, Install Base, Order Management). RDBMS Oracle 9i

Hire Now