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