We provide IT Staff Augmentation Services!

Oracle Ebs (e-business Suite ) Techno - Functional Consultant (hcm) Resume

4.00 Rating

Lexington, MA

SUMMARY

  • Oracle Apps Techno Functional Consultant with around 8 years experience and exposure to Development and maintenance activities (The City Schools), Development and Enhancement activities ( Confidential, Confidential and Al - Rahba Hospital).
  • Played different roles like Technical Analyst, and Techno functional consultant and Developer in my career.
  • Experience in large commercial systems involving various aspects of software development life cycle, which includes requirement gathering, design, coding, testing, product-solution implementation and end-user support.
  • Working experience in Oracle Financial Module including AP, AR, GL, HCM module including Core HRMS, Payroll, SSHR, OLM and Property Management Module.
  • Have good understanding of the functional concepts in Core HRMS, Payroll, SSHR, OLM and Property Management Module.
  • Extensive hands on coding and design experience in SQL and PL-SQL procedures, packages and functions. Also have working experience with API’s (Application Programming Interfaces).
  • Expertise in SQL Tuning to improve the performance of the existing system.
  • Excellent Technical skills in developing RICE components.
  • Worked in developing Interfaces. Working experience with SQL Loaders.
  • Experience in development of forms using Oracle Form builder 6i and 10g.
  • Experience in development of reports using Oracle Reports builder 6i and 10g.
  • Knowledge in development of reports using XML Publisher, BI Publisher and Discoverer Reports.
  • Have experience in Oracle Apps Framework (OAF).
  • Having sound knowledge in various stages of software development life cycle (SDLC) gathering and analyzing the requirements, converting the specifications into functional and technical design documents, coding and testing.
  • Possess Strong troubleshooting skills as I have worked in the support phase for multiple projects.
  • Excellent communication skills with leadership qualities & open to innovative ideas to develop a creative solution for challenging client needs.

TECHNICAL SKILLS

  • Data Migration & Integration
  • Oracle API's / Open Interfaces
  • Oracle WEB ADI's
  • Oracle SQL / PL/SQL
  • Oracle Forms/Reports/Discoverer
  • Oracle BI Publisher
  • Oracle XML Publisher
  • Oracle Alerts
  • Oracle AME
  • OAF Pages / D2k Forms Personalization
  • Custom Forms for Oracle EBS (E-BUSINESS SUITE ) R12
  • Oracle Workflow
  • OAF
  • OBIEE

PROFESSIONAL EXPERIENCE

Confidential, Lexington, MA

Oracle EBS (E-BUSINESS SUITE ) Techno - Functional Consultant (HCM)

Responsibilities:

  • Developed the scripts needed for migration and registered concurrent programs and performed unit testing.
  • Focusing on technical solutions for the enhancements assigned.
  • Writing the technical design document MD070 after reading MD050, prepare installation routine MD120 and unit test TE20 for the requirement and documenting BR100s.
  • Documentation according to AIM methodology
  • Involved in Post production Support, work involved supporting Apps, support in Training.
  • Reports Development using Oracle Reports Builder, XML Publisher, BI Publisher and Discoverer
  • Legacy System Data Migration of Persons, Assignments Oracle Apps API's
  • Configuring Persons Extra/Special Information for Oracle Core HR
  • Creating Concurrent Programs for Reports/PL/SQL Execution
  • Responsible for Break/Fix during testing phases.
  • Writing User Hooks for Oracle Learning Management and Absence Management
  • Configuring Persons Extra/Special Information for Oracle Core HR and Selfservice Modules
  • Configuring Descriptive FlexFields and Lookups
  • Creating Concurrent Programs for Reports/PL/SQL Execution
  • Configuring Approvals Management Engine / Workflow
  • Involved in Requirements Analysis, Design, Data Mapping and Client Interaction.
  • Designed/developed tables, views, various SQL queries, stored procedures, functions, packages, to pull the required data.
  • Object Migration to PRODUCTION using FND LOAD.
  • Documentation according to AIM methodology
  • Managed the smooth deployment and migration working with DBAs.
  • Capture functional requirements and translation into technical requirements.
  • Writing Fast Formula's for Oracle Payroll Oracle HRMS Functional Tasks
  • Explore the full end to end implementation in Core HR, Payroll, SSHRM and recruitment
  • Responsibilities & User Creation, Key & Descriptive Flex Fields and Value Sets, Business Groups, Profiles, Jobs, Grades, Positions, Locations, Organizations & Organization Hierarchies, People Management, Form Personalization. Elements Description and Link, Absence types, Accrual Plan, Accrual Formula, Carryover Formula, Accrual Bands, Net Calc Rules, Employee Assignment etc.
  • Elements, Element Links, Salary Basis, Employee Assignment, GL Integration, Payroll Processing, Payroll Run, Prepayments, Costing, Transfer to GL etc
  • Configure SIT’s on SSHR Pages, Configure Employee Self Service, Manager Self Service, Configure Function and Menus, Configure Appraisals, Leave of Absence, Configure Payslips for Employees.
  • Configure Job Vacancies, Job Offers, Applicants Creation, Configure external Candidate / Visitor home page, Employee home page for jobs. Configure iRecruitment manager and Recruiter responsibilities.
  • Rating Scales, Competencies, Appraisals Templates, PM Plan, Appraisals etc.
  • Courses, Classes, Enrollment, Learner Self Service, Personalization.
  • Upload and Download Data through Integrators, Defining Layouts, Letter Generation, Employee Data, Salary Proposals etc
  • Payroll Formulas, Global Values, Input values with conditional logic, User Tables
  • Transaction Type, Rules, Attributes, Action Type, Approver Group, Sequential & Parallel Approval Setup of SSHR, iRecruitment and OLM.

Environment: Oracle Application 12.0.6

Confidential

Oracle EBS (E-BUSINESS SUITE ) Technical Consultant

Responsibilities:

  • Focusing on technical solutions for the enhancements assigned.
  • Reports Development using Oracle Reports Builder and XML Publisher
  • Adhoc Reports Development using Oracle Discoverer Plus and Discoverer Desktop
  • Legacy System Data Migration of Persons, Assignments, Payroll, Learning Management and iRecruitment using Oracle Apps API's
  • Interfaced GL data from external system to the Mobility GL System.
  • Workflow Customization and AME Configration
  • D2k/OAF Forms Personalization for Oracle Core HR and Selfservice Modules
  • Writing User Hooks for Oracle Learning Management and Absence Management
  • Configuring Approvals Management Engine / Workflow
  • Oracle Custom Forms Development using Oracle Forms 10g2
  • OAF Pages for Reporting Purposes using Oracle jDeveloper patch set for EBS (E-BUSINESS SUITE ) 12.1.3
  • Upgradation Support from 12.0.6 to 12.1.3
  • Documentation according to AIM methodology

Environment: Oracle Application 12.0.6 and 12.1.3

Confidential

Oracle EBS (E-BUSINESS SUITE ) Technical Consultant (HCM)

Responsibilities:

  • Involved in Requirements Analysis, Design, Data Mapping and Client Interaction.
  • Developement and bug fixing of the Core HRMS, Payroll and Selfservice reports.
  • Focusing on technical solutions for the enhancements assigned.
  • Involved in Post production Support, work involved supporting Apps, support in Training.
  • Reports Development using Oracle Reports Builder and XML Publisher and Oracle Discoverer.
  • Data Migration of Persons, Assignments and Payroll using Oracle Apps API's
  • Configuring Persons Extra/Special Information for Oracle Core HR and Selfservice Modules
  • Creating Concurrent Programs for Reports/PL/SQL Execution

Environment: Oracle Application 12.0.6

Confidential

Senior Officer ERP (Techno-Functional)

Responsibilities:

  • Development/Modification of Oracle Reports of different Modules like AR, AP, HRMS, Payroll, Billing in Oracle Report Builder.
  • Modification of Forms in Oracle Form Builder.
  • Development and testing of database objects using PL/SQL
  • Providing support and troubleshooting of Customized Module BILLING which is linked with AR.
  • Support of existing Modules.
  • Deployment of oracle forms and reports on Oracle Application Server.
  • Creating Procedures to use Standard APIS to upload data in different modules.
  • Managing Table Space.
  • Applying Patches.
  • Running different Scripts and Quires as required by users in Toad.
  • System Administration Task like Creating Users, Responsibilities, Functions, Menus, Value Sets, Request Groups etc.
  • System Admin tasks of HRMS and PAYROLL.

Environment: Oracle Application 11.5.10

We'd love your feedback!