Oracle Hrms Technical Consultant Resume
Itasca, IL
SUMMARY
- 7 + years of IT experience as an Oracle apps technical consultant and worked on Oracle Applications 11i and R12 systems.
- Apart from Technical expertise, having functional knowledge in Oracle HRMS modules - Core HR, Oracle Payroll, SSHR, Advanced Benefits
- Technical expertise in Oracle Supply Chain modules - Oracle Inventory, Order Management and Purchasing.
- Expertise working experience on design, implementation, and postproduction support and up gradation projects to various clients who implemented Oracle e-business suite.
- Expertise in design, development and customization of RICE (Reports, Interfaces, Conversions and Extensions) using PL/SQL, SQL Loader and UTL file.
- Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications
- Solid Knowledge and understanding of AOL/FND architecture and Applications
- Extensive experience on creating inbound, outbound interface scripts and performed conversions for loading data into Oracle applications and exporting data from Oracle application system to flats files and process the data files to other legacy system users.
- Worked on different API's related to modules like Core HR, Payroll etc.
- Excellent understanding of Multi Org concepts.
- Expertise in Order to Cash (O2C) and Procure to Pay (P2P) business flows.
- Expertise in Customizing Oracle reports and developing custom reports by using Oracle Reports Builder, Discoverer and XML/BI Publisher.
- Worked on Oracle Alert Notifications and Form Personalization,
- Developed Workflows to send notifications based on the business rules.
- Worked extensively, in and out on conversions. Involved in conversion process right from design, pre-conversion/data-cleansing, extract, validate and interface the data from legacy systems into staging tables and then to interface tables.
- Expertise in writing PL/SQL Packages, PL/SQL Procedures, Functions, Triggers, Packages and Advanced PL/SQL and SQL * Loader scripts.
- Expertized in Performance Tuning using SQL Trace, and Explain Plan.
- Worked with Oracle APIs (Application Programming Interface) to register executables, concurrent programs and execute the request set from backend.
- Excellent working knowledge in UNIX shell scripting.
- Well experienced in all phases of project life cycle such as project planning, requirements gathering, analysis, design, development, implementation, enhancements, testing and documentation.
- Resolved Critical Production Issues during Support.
- Designed various Technical and Functional documents like MD050, MD070 and MD120 based on Standard AIM Templates
- Expertise in working with development tools like SQL developer and TOAD.
- Excellent analytical skills, logical reasoning, and interpersonal skills.
TECHNICAL SKILLS
ERP: Oracle Applications 11i,R12
Operating Systems: Windows 7, Windows Vista, XP, NT, UNIX
Database: Oracle RDMS, ORACLE 11g/10g/9i/8i
Languages: SQL, PL/SQL, C, C++, HTML, UNIX shell scripting
Oracle Tools: Oracle Reports 10g/6i, XML Publisher 5.6, Discoverer 10g, Workflow 2.6, Oracle Forms 10g/6i
Oracle Utilities: SQL*Loader
Other Tools: SQL*Plus, SQL Developer, Toad 8.0, 9.0, Putty, WINSCP
PROFESSIONAL EXPERIENCE
Confidential, Itasca, IL
Oracle HRMS Technical Consultant
Responsibilities:
- Worked on the Data migration activities of Core HR/Payroll through conversion scripts (like employee creation, assignment, job, contacts, phones, address, bank details, element entry, pay proposals etc.)
- Development of new reports (XML, Discoverer and RDF)
- Defining New Users, Creating Responsibilities and assign responsibilities to the Users.
- Defining Request Groups, functions, menus, Assigning Request Group to Users.
- Defining Key Flex fields and value sets.
- Performed Unit testing.
- Worked extensively, in and out on conversions. Involved in conversion process right from design, pre-conversion/data-cleansing, extract, validate and interface the data from legacy systems into staging tables and then to interface tables.
- Worked on Oracle Alerts, PL/SQL Alerts.
- Worked on Workflow Customizations to send notifications.
- Worked on Fast Formulas.
- Worked on the Bank file Transfer interface and also few internal interfaces like Payroll Costing Interfaces, FND user interfaces where the Program is set create the FND User and also attach the Employee Self Service responsibility to the user.
- Worked on custom interfaces critical to business.
- Worked on few Third Party Benefit Interfaces both Outbound and Inbound Interfaces
- Designed various Technical and Functional documents like MD050, MD070 and MD120
- Prepared deployment documents for moving custom developed reports and forms from development instance to production after code testing.
- Involved in all phases of project life cycle such as project planning, requirements gathering, analysis, design, development, implementation, testing and documentation.
- Developed custom discoverer reports those were critical to business as a part of postproduction support and also provided relevant documentation such as MD50, MD70 and MD120.
- Prepared Technical Design Documents based on Standard AIM Templates.
- Worked on CEMLI for PL/SQL Packages, Concurrent programmers, Reports and SQL objects etc.
- Involved in testing the migrated components.
- Enhancing the existing objects while migrating from 11i to R12.
Environment: Oracle Applications 11.5.10.2, R12, Oracle 10g database, SQL Developer, XML Publisher, Discoverer, Reports Builder, Forms Builder.
Confidential, Oxnard, CA
Oracle HRMS Technical Consultant
Responsibilities:- Developed New Reports (Discoverer and XML reports) and also modified the existing ones as per the client requirement.
- Developed technical MD70 specification using functional MD50 document for application customization and enhancement.
- Involved in analyzing and developing the code as per MD50.
- Worked on custom interfaces critical to business.
- Resolved Critical Production Issues.
- Worked on different API's related to Core HR, Payroll and OAB.
- Resolved issues in the Benefit Interfaces as a part of the support.
- Enhanced the existing process with new functionality to meet the client requirements.
- Created database objects like tables, views, functions, procedures, triggers etc.
- Involved in developing reports, alerts, concurrent programs, AOL objects etc. as per the business requirements.
- Worked on Fast formulas.
- Worked extensively, in and out on conversions. Involved in conversion process right from design, pre-conversion/data-cleansing, extract, validate and interface the data from legacy systems into staging tables and then to interface tables.
- Performed Unit Testing.
- Prepared deployment documents for moving custom developed reports and forms from development instance to production after code testing.
- Prepared Technical Design Documents based on Standard AIM Templates.
Environment: Oracle Applications R12, Oracle 10g database, SQL Developer, XML Publisher, Discoverer, Reports Builder, Forms Builder
Confidential, Camarillo, CA
Oracle Apps Technical Consultant
Responsibilities:
- Proactive role as a Techno functional Consultant in Supply Chain Management modules including P2P and O2C cycles
- Played immense role in various phases of SDLC like Requirement Gathering, Analysis, Development, Unit Testing, and Deployment.
- Converted oracle RDF reports into XML reports
- Developed some adhoc reports by extracting the data from the SQL queries as per the requirement
- Performed administrative work such as creating users, menus, attaching forms to menus, assigning responsibilities etc
- Involved in analyzing and developing the code as per MD50.
- Worked on few HRMS conversions.
- Created MD70 document as per the MD50 document provided.
- Involved in developing reports, alerts, concurrent programs, AOL objects etc. as per the business requirements.
- Enhanced the existing process with new functionality to meet the client requirements.
- Created database objects like tables, views, functions, procedures, Packages triggers etc.
- Worked with Conversions and Interfaces using API and Standard Programs.
- Proficient in customizing the Forms through Form Personalization and Custom PLL.
- Developed shell script for file transfer and data loading to automate interface programs.
- Implemented code for creating new Items using Standard Item Interface Program.
- Created a new workflowPWRAUTOBKfor notification and customizedCREATEPOworkflow.
- Steered calls and meetings with the Clients to enhance the productivity ofthe system.
- Provided KT and training sessions to the team members.
- Coordinated with the team members for project enhancements and support.
- Proactively identify and fix issues in the system that has critical business impact.
- Created status reports and updated clients on regular basis as per the process.
- Participated in audits along with quality team, to gauge team productivity, ensure code version control and logging of bug fixes.
Environment: Oracle EBS 11i, Oracle 10g Database
Confidential
Oracle Apps Developer
Responsibilities:
- Gathering functional requirements and created technical documents for custom reports, script files.
- Wrote PL/SQL programs for implementing validation rules and loading data from staging tables to interface tables.
- Involved in analyzing and developing the code as per MD50.
- Created MD70 document as per the MD50 document provided.
- Created database objects like tables, views, functions, procedures, triggers etc.
- Enhanced the existing process with new functionality to meet the client requirements.
- Involved in developing reports, concurrent programs, AOL objects etc. as per the business requirements.
- Developed inbound interface to load purchase order details into purchasing base tables from legacy systems.
- Extensively worked on FND LOAD for migrating concurrent programs, value sets, descriptive flex fields, lookups from one instance to another.
- Developed shell script for file transfer and data loading to automate interface programs.
- Registered the shell scripts as concurrent programs and created a scheduling process that invokes the scripts periodically.
- Played vital role in resolving business critical issues in PL/SQL Packages, Reports etc.