We provide IT Staff Augmentation Services!

Oracle Technical Consultant Resume

PROFILE:

  • 7.8 years of experience in Oracle Modules (AP, AR, PO, GL, SLA, FAH, FA, T&E, iProcurement, HRMS,HCM, SSHR, Payroll) as a Senior Oracle EBS Technical Consultant. Have worked in several assignments as EBS developer that included various implementations, developments, Enhancement to existing Implementation, Upgrades and Support projects.
  • Solid Expertise in developing PLSQL packages, Procedures, Functions, Triggers, Forms, Reports, XML Publisher Reports, BI Publisher Reports, Oracle Alert, Web ADI, OAF and Workflow in different Oracle modules as per the business requirement.
  • Extensive experience in all phases of full life - cycle Oracle Application implementation (I.e. Definition, High Level Design, Detail Design, Development, Deployment, Testing, Integration, Maintenance and Support).
  • Proficient in building interfaces (inbound and outbound), Conversions, Reports, Forms in different Oracle modules.
  • Good understanding in Oracle table structure, usage of APIs in Oracle Modules likes AP, AR, GL, FAH, Purchasing, SLA, HRMS and HCM.
  • Have experience in working in e-commerce Gateway and worked closely with EDI team to transfer data between EDI and Oracle.
  • Strong working knowledge in Oracle R12 and Oracle 11i, SQL, SQL*Plus, PL/SQL, SQL Loader, File Based Loader, Forms builder, Report Builder, Oracle Workflow Builder, BI Publisher, JDeveloper, WINSCP and Putty.
  • Proficient with documentation using Oracle AIM Methodology (i.e. MD70, MD50, MD120, TE20) or any other client specific implementation methodology.
  • Extensive experience in all phases of full life-cycle Oracle Application implementation (I.e. Definition, High Level Design, Detail Design, Development, Deployment, Testing, Integration, Maintenance and Support)
  • Extensive experience in creating test plans/scripts and coordinating all the testing cycles; unit testing, system integration testing, system testing and user acceptance testing.
  • A strong team player with excellent planning, analytical and interpersonal skills related to gathering of business requirements, documentation, developing functional designs, providing functional solutions, system configuration and training end users.
  • Strong communication skills with a proven ability to interact with end users, developers, project management and executive management.
  • Exceptionally well organized with strong work ethics and willingness to work persistently to achieve employer objectives and always delivered on time.
  • Ability to quickly adapt to changing environments professionally and personally.

TECHNICAL EXPIERENCE:

Operating Systems: Windows 7/ME/XP/2000/98/95, Linux

ERP Package: Oracle Applications (12.2.6,12.1.3, 12.1.2, 11.5.10.2,11.5.10), R12-AP,AR, PO, GL, FAH,SLA,T&E, HRMS, HCM, R11 - AP, AR, PO, GL,FA,PA, T&E,iProceurement

Programming Languages: SQL,PL/SQL, Unix

Database: Oracle9i, Oracle 10g, Oracle 11g

Oracle Tool: SQL Developer, PL/SQL Developer, SQL Plus, Oracle Report Builder, XML Publisher, Oracle WEB ADI, Workflow Builder, Jdeveloper, Adhoc Reports, Bursting, Oracle Fast Formula, BI publisher 10g, BI Publisher 11g

Other Tools Worked on: Microsoft Office Suite 2003,07,10 - MS Office, MS PowerPoint, MS Excel, MS Access, MS Project, MS Vision, SQL Loader

Ticketing Tool: BMC Remedy 7.1, BMC Remedy 8.1, Service Now

Special Tools: Clear case Code Repository, Kintana Migration Tool, WinScp,Putty., Control-M Tool, JIRA dashboard, ALM

Documentation Methodology: Aim- Application Implementation Methodology, Agile, etc

Technical Area: Oracle Interfaces, Oracle Workflow, Oracle BI Publisher Reports, Oracle Alerts, Oracle XML Publisher Reports, Oracle RDF Reports, Oracle AME Rules, Oracle Web ADI, Oracle OA Frame Work Personalisation, Oracle SQL Loader, File Based Loader

Basic Understanding: System Administration, Oracle (SQL,PL/SQL),XML Publisher

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Technical Consultant

Responsibilities:

  • Developed PLSQL packages, Procedures, Functions, Reports, XML Publisher Reports, BI Publisher Reports, Oracle Alert, Web ADI, OAF and Workflow in different Oracle modules as per the business requirement.
  • Designed MD70, MD120, TE20 Documents for Each and Every Assigned Component.
  • Worked on development of many components in various Oracle modules.
  • Developed many components as per the business requirements that include various interfaces, Conversions, XML Publisher Reports, enhancements to existing process etc.
  • Worked on customization of workflows.
  • Worked on WEB ADI, Oracle Alert and OAF.
  • Involved in conducting Unit testing through TE20 test cases and Integration testing of all the components designed.
  • Migrated all objects of assigned components to different Oracle instances..
  • Conducted User Acceptance Testing to provide training to the client about Oracle Applications navigation and forms
  • In depth knowledge of Oracle Applications modules, including functionality and underlying database tables, APIs, standard Concurrent Programs and Reports in various Oracle modules.
  • Provided complete training to the end users and other Internal Team members.
  • Interacted with Oracle Support Team for various Oracle standard Issues.

Confidential

Oracle EBS Developer

Responsibilities:

  • Developed PLSQL packages, Procedures, Functions, Reports, XML Publisher Reports, BI Publisher Reports, Oracle Alert, Web ADI, OAF and Workflow in different Oracle modules as per the business requirement.
  • Designed MD70, MD120, TE20 Documents for Each and Every Assigned Component.
  • Worked on development of many components in various Oracle modules.
  • Developed many components as per the business requirements that include various interfaces, Conversions, XML Publisher Reports, enhancements to existing process etc.
  • Worked on customization of workflows.
  • Worked on WEB ADI, Oracle Alert, OAF.
  • Involved in conducting Unit testing through TE20 test cases and Integration testing of all the components designed.
  • Migrated all objects of assigned components to different Oracle instances..
  • Conducted User Acceptance Testing to provide training to the client about Oracle Applications navigation and forms
  • In depth knowledge of Oracle Applications modules, including functionality and underlying database tables, APIs, standard Concurrent Programs and Reports in various Oracle modules.
  • Provided complete training to the end users and other Internal Team members.
  • Interacted with Oracle Support Team for various Oracle standard Issues.

Confidential

Oracle Financial Developer

Responsibilities:

  • Supported Existing Standard and Custom system functionalities.
  • Developed many components as per the business requirements
  • Worked on performance tuning of few Reports in 11i Oracle.
  • Worked on Support assignments in Oracle 11i finance modules which involve working and resolving with tickets, Creating Change Requests for migration of resolved incidents and tickets to Production environment.
  • Developed PLSQL packages, Procedures, Functions, Reports, XML Publisher Reports, BI Publisher Reports, Oracle Alert, Web ADI, OAF and Workflow in different Oracle modules as per the business requirement.
  • Designed MD70, MD120, TE20 Documents for Each and Every Assigned Component.
  • Worked on development of many components in various Oracle modules.
  • Developed many components as per the business requirements that include various interfaces, Conversions, XML Publisher Reports, enhancements to existing process etc.
  • Worked on customization of workflows.
  • Worked on WEB ADI, Oracle Alert, OAF.
  • Worked on small enhancements in Oracle 11i in AP, AR, PO, GL, FA etc.
  • In depth knowledge of Oracle Applications Finance modules, including functionality and underlying database tables, Standard Programs and APIs.
  • Interacted with Oracle Support Team for various Oracle standard Issues. Created SR with Oracle and followed the steps mentioned by Oracle for many Oracle standard issues.

Confidential

Oracle HRMS/HCM Techno-Functional Developer

Responsibilities:

  • Analysed business requirements through BRDs
  • Supported Existing Standard and Custom system functionalities.
  • Developed many components which includes interfaces, Conversions, Oracle RDF reports and XML publisher Reports as per the business requirements.
  • Developed PLSQL packages, Procedures, Functions, Reports, XML Publisher Reports, BI Publisher Reports, Oracle Alert, Web ADI, OAF and Workflow in different Oracle modules as per the business requirement.
  • Worked on Oracle R12 Core HR, SSHR, CWB modules.
  • Expertise in Oracle Taleo, Oracle Fusion (Talent Module).
  • Worked on Oracle AME integration.
  • Worked on Oracle Workflow, Web ADI, Alert and OAF.
  • Conducted User Acceptance Testing to provide training to the client about Oracle Applications navigation and forms
  • Facilitated smooth testing during SIT and UAT for Core HR and Self Service HR and played a vital role in tracking/resolving all issues.
  • Conducted data validations for all the Work Structures (Locations, Organizations, Organization hierarchy, Position, Jobs, Grades, Grade Rates, etc) as well as assignment data.
  • Provided post go live support for more than 150 Interfaces, different Workflows, data issues in PROD.
  • Provided complete training to the end users.
  • Interacted with Oracle Support Team for various Oracle standard Issues.

Confidential

Oracle HRMS Technical Consultant

Responsibilities:

  • Prepared MD70 for various newly developed components on Core HR and SS HR.
  • Developed several inbound and Outbound Oracle Interfaces, Conversions.
  • Developed PLSQL packages, Procedures, Functions, Reports, XML Publisher Reports, BI Publisher Reports, Oracle Alert, Web ADI, OAF and Workflow in different Oracle modules as per the business requirement.
  • Developed BI publisher Reports.
  • Worked on design and development of several Oracle Alerts, Workflows and Web ADI during this period.
  • Prepared Adhoc Reports based on specific requirements.
  • Defined personalization within Self-Service to meet business requirements.
  • Setup and tested Manager Self-Service and Employee Self-Service responsibilities and menus.
  • Done Unit Testing, Integration Testing and User acceptance testing of all the developed components.
  • Provided technical support during the user acceptance testing
  • Worked during Data Conversion requirements from Legacy and 11i Systems.
  • Worked on numerous remedy tickets raised during this period related to Oracle HRMS after GOLIVE.
  • Managed the payroll of all employees throughout several departments.

Hire Now