OBJECTIVE

• Creative and innovative oracle professional that enjoys challenges, seeks opportunity to learn and improve skills. Looking for position where I can effectively utilize my expertise in project management and enterprise resource planning implementation.

SUMMARY

• Over 7.5 years of experience in Oracle HCM/HRMS as Oracle Apps Techno functional Consultant in Analysis, Design, Data Modelling, Implementation of Business Applications using the Oracle Relational Database Management System.
• Experience with the Software Development Life Cycle (SDLC) process - performing detailed analysis, collecting requirements, technical specifications, development and unit testing, integration and production installation and support.
• Experience in Design, Development, Customization and Implementation of business applications using Oracle Applications, SQL, PL/SQL, Oracle 10g/9i/8i/7.x, and reports6i.
• Worked in diverse environments such as Sumtotal systems Learning Management System, Oracle Learning Management, Success Factor Learning Management System, Docent, eLearning and Oracle Applications HRMS modules
• Good experience with Implementation and customization of Oracle Learning Management, Core HR, Self Service HR (ESSHR, MSSHR), I Recruitment, Payroll, Oracle Time and Labor, Oracle Advanced Benefits, Human Resource Intelligence, Talent Management.
• Exposure to oracle AIM methodology.
• Experience in converting oracle reports into stylish PDF format using XML publisher.

TECHNICAL SKILLS

ERP modules: Oracle HRMS Application modules such as Core HR, Payroll, Oracle Time and Labor (OTL), Oracle Advance Benefits (OAB),Oracle Learning Management (OLM), Self-service, IRecruitment, Human Resource Intelligence (HRI), Web ADI, Alerts, Approval Management Engine(AME)

Software: Oracle E-Business Suite 11.5.10.2, R12, Oracle Database 10g, PL/SQL, SQL, XML Publisher.

Tools: TOAD, Data Loader, SQL Loader, Approval Management Engine, Web ADI.

PROFESSIONAL EXPERIENCE

Confidential, NC

Oracle Apps Techno Functional Consultant

Responsibilities:

• Planned, performed and managed tasks and activities throughout the SDLC for Pricing, Utility Growth and sample allocation budgeting and forecasting projects simultaneously.
• Analyzed the business problems and communicated to the development team
• Acquired Knowledge of software usability principles in the process of creating the test plans for the application.
• Configuration set-ups for Core HR, SSHR (Key and Descriptive flex fields, Organizations, Hierarchies, Lookups, Menus, Functions).Methodology used was Agile.
• Interacted with the “Users” by interviewing them, by preparing questionnaires and getting feedback.
• Conducted the feedback session with the client on the performance and utility of the forecasting system. Identified stakeholders, critical success factors, challenges and a contextual use case diagram
• Acted as a liaison between Business and development teams to come up with Design specifications. Conducted JAD sessions to ensure that the design was in sync with the requirement specification document.
• Implemented Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Data Flow Diagrams, Activity Diagrams, and Sequence Diagram.
• Worked on AIM Methodology to build design documents MD050, BR100 for system configuration change to Oracle Applications.
• Published the weekly status reports and documents in for senior management.
• Performed functionality testing, prioritized the issues identified during UAT and coordinated with development team to prioritize work.

Environment: Oracle database 10g, Oracle E-Business suite 11.5.10(HRI, Core HR, SSHR, OLM), Reports 6i, TOAD, SQL * Loader, PL/SQL.

Confidential, Chicago, IL

Oracle Apps Techno Functional

Responsibilities:

• Part of entire phase of the project which include initial operations analysis, business process evaluation, testing,, conversions, Customizations and documentation.
• Estimate the amount of work required to implement software component and ensuring that the targets are met.
• Responsible for developing plans with team members, project managers and ensure that the team adheres to agreed timelines.
• Work with developers and QA team to ensure best practices through regular code reviews and troubleshooting program errors.
• Developed script for custom validations
• Developed migration script for updating the base tables using oracle API's
• Defining Lookups and value sets and modifying the existing one using LDT’s as per new organization structure. .
• Involve in end-to-end support to quality assurance team for their testing and UAT Testing for Business users before releasing the new requirements in production.

Environment: Oracle database 10g, Oracle E-Business suite 11.5.10(HRI, Core HR, SSHR,IRecruitment, OLM), Reports 6i, TOAD, SQL * Loader, PL/SQL, Data Loader, Unix shell scripting.

Confidential

Staff Consultant

Responsibilities:

• Successfully managed & implemented all three upgrade projects in a record time without any cost/ budget overrun and trained business users.
• Responsible for HRMS upgrade project forecasting, resource planning, project management, guiding team, client coordination, complete functionality & feature change analysis patch analysis, regression testing, UAT, issue resolution & implementation of upgrade projects.
• Direct interacting with client to understand their Human resource management complexities, key pain points, improvements possible from Oracle HRMS.
• Scoped & analyzed HRMS functionality enhancements to the product based on clients’ requirements & guided the development team to deliver the same. Created test cases and included the same in knowledge repository for next upgrade.
• Involved in SSHR personalization, customization of setups, developed many critical enhancement like online payslip customization, stop annual leave to go negative and resolved many critical payroll performance issues, costing issues, talent management issues etc
• Providing HRMS techno functional support to 32000 users of client in HRMS, Dubai Payroll Self-service HR, IRecruitment, Oracle Time & Labor (OTL),OLM(oracle learning management),Oracle Performance management (OPM) and other custom modules.
• Made HRMS system stabilize, reduced number of issues via root cause analysis of many critical issues & repetitive issues and provided fixes and suggested viable workarounds in case no easy fix existed.

Environment: Oracle database 10g, Oracle E-Business suite R12 (OTL, Core HR, SSHR, OLM and HRI, OPM), Reports 6i, TOAD, SQL, AME, and WEB ADI.

Confidential

Techno Functional Consultant (Module Lead)

Responsibilities:

• Actively participated in client interaction and meetings for understanding the requirements.
• Involvement in preparation of Functional Design Documents and Technical Design Documents.
• Involved in documenting the requirements of the clients and Analyzing them by identifying the Gaps and Fits in the System by using AIM Methodology.
• Study and analysis of the functional configuration of elements in Oracle Applications
• Implemented Core HR, SSHR, OLM, Payroll, OTL (Key and Descriptive flex fields, Organizations, Hierarchies, Lookups, Menus, Functions).
• Creating Elements, Linking the elements, Payment Methods
• Involved in identifying the hierarchy’s of the Organization and Positions.
• Responsible for cross-functional coordination within the organization to meet all requirements of the client
• Coded and debugged the Stored Procedures, Packages in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
• Responsible for preparation of User Manual and delivery of the Custom Components.
• Preparation of Technical Design Document.(MD 70)
• Unit testing of the Packages/ Procedures/Functions and other objects developed.
• Involve in end-to-end support to quality assurance team for their testing and UAT Testing for Business users before releasing the new requirements in production.

Environment: Oracle database 10g, Oracle E-Business suite R12 (Payroll, Core HR, SSHR, IRecruitment and OTL), Reports 6i, TOAD, SQL .

Confidential

Techno Functional Consultant

Responsibilities:

• Involved in the meetings for the As-Is Process of the Client System
• Involved in the Client meetings for the Requirements gathering of the proposed system.
• Involved in documenting the requirements of the clients and analyzing them by identifying the Gaps and Fits in the System by using AIM Methodology.
• Study and Analysis of the functional configuration of elements in Oracle Applications
• Worked on the OTL setup and Payroll Setup/Creation of Elements, Salary Basis, Element Links, Element Sets and Assignment Sets.
• Understanding the legacy systems and its conversion to Oracle Applications.
• Created Alerts according to the requirement and worked on the Oracle Approval Management Engine for the hierarchy
• Preparation of Technical Design Document.(MD 70), BR 30 ( Business Requirement Solutions), BR 100 (Define Application Set ups)
• Used BEE (Batch Element Entry) to upload the bulk element entries.
• Involved in Payroll Creation Setup and running Payroll, Quick Pays, Prepayments.
• Worked on the System Defined reports in Oracle Applications as per the requirement.
• Involved in identifying the reports and coordination with the technical team for the output of the reports

Environment: Oracle database 10g, Oracle E-Business suite R12 (Payroll, Core HR, IRecruitment, OLM and HRI), Reports 6i, TOAD, SQL, AME, and WEB ADI.

Confidential

Techno Functional Consultant

Responsibilities:

• Involved in the s on the enhanced features of Oracle 12.1 release
• Communicating with Business users for understanding of the requirements
• Involved in Preparing the Business scenarios and test cases
• Interaction with the development team on the enhanced features
• Involved in preparing White Paper on Quick start implementation by using configuration workbench

Environment: Oracle database 10g, Oracle E-Business suite R12 (Core HR, SSHR, OLM).