SUMMARY:

• Highly motivated, dynamic professional having over 9+ years of experience in requirements, design, Analysis Configuration Management, development, testing, implementation, customization, maintenance and support of business applications in Oracle HCM domain specialized in Oracle Fusion HCM Cloud and Oracle Application R12.
• Good Expertise and implementation experience on Fusion HCM Offerings: Talent Management, Workforce Deployment (Core HR), Workforce Development (Goal Management, Performance Management, Talent Review and Succession), Absence Management, and, Security.
• Experience in building new reports and troubleshooting the existing reports using Fusion reposting tool OTBI (Oracle Transactional Business Intelligence).
• Strong understanding in Performance Management set ups like Performance Process Flows, Talent Eligibility Profiles, configuring Performance Document.
• Strong understanding in Fusion Security Model and creating roles and various security Profiles.
• Oracle Fusion subject matter expert providing best - practice guidance on HCM business
• Extensive technical experience in Data Conversion & Interfaces, Customization & Development of Reports, Forms, Oracle Workflow, OA Framework, ADF.
• Good Knowledge on Procure to Pay and Order to Cash Cycles.
• Good Knowledge on KBX reporting tool for payroll.
• Experienced as an Oracle Applications EBS Technical Consultant
• Extensive technical expertise in Oracle HRMS with core HR, ADP Payroll and Self Service as main modules.
• Expertise in implementing RICE (Reports, Interfaces, Conversions, Extensions) components in the area of technical design, development, Integration testing and deployment.
• Part of the End to End implementation life cycle. The implementation cycle Initial Kick-Off, Requirement Gathering, Effort Estimation, Client Approvals, Solution design - Technical Design Document, Configuration and Release Planning, Testing Cycle - Testing Document, Implementation Instruction for UAT and finally ensuring project is successfully implemented within the timelines processes.
• Experience includes full lifecycle implementations of Oracle Applications release 12 covering HRMS modules: Core HRMS, Absence Management & Self Service and HCM Fusion Implementation for Workforce Deployment, Workforce Development, and Talent Management.
• Strong Knowledge on Fusion Functional Setup Manager.

TECHNICAL SKILLS:

ERP: Oracle HCM Fusion, PeopleSoft HCM

People Tools: People Tools, Application Designer, Application Engine, Process Scheduler, Data

Scripts: PowerShell Scripting

Reporting: OBIEE, OTBI, SQR, PS/Query

Integration Tools: file Layout, Integration Broker, Component Interface, ExcelToCI

Languages: people Code, SQL, C, Java, HTML

RDBMS: Oracle, SQL Server.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Oracle HCM Developer

Responsibilities:

• Involved in successful implementation of HCM Cloud (Talent Management - Goals, Performance, Profiles, Talent Review & Succession Planning)
• Involved in requirement gathering, analysis, design, data conversion and Implementation and Support.
• Took active part in Post GO-Live support team for Oracle Fusion Talent Management.
• Responsible for File Based Loader (FBL) for worker details includes loading of person data, employment data, experience, skills & competencies, Training etc.
• Worked on developing HCM extracts as part of outbound interfaces.
• Worked on creating BI publisher reports.
• Involved in gathering requirements and prepare technical design document for development and setup documents.
• Created/Customized the reports to get data output in required format.
• Analyze business requirements, perform Fit- Gap analysis and developing effective configuration solutions.
• Configured Performance Management set ups like Performance Process Flows, Talent Eligibility Profiles, and Performance Document.
• Well versed with the setup of Work Structures - Location, Organization, Job and Grade in HR
• Implemented customized fast formula for PAYROLL deduction elements.
• Identified and addressed client needs: building solid relationships with clients, developing an awareness of Firm services.
• Involved in a full life cycle implementation of Oracle HR / Payroll.
• Conducted requirements Analysis through workshops with users at all levels.
• Documented HR and Payroll future Business processes
• Configured Oracle HR, Self Service HR and Payroll to support the to be business processes.
• Worked closely with applications technical staff to assist in design and coding of PL/SQL.
• Administration duties included creating new application users, responsibilities and menus.
• Conducted user training and wrote system and user documentation.
• Written many PL/SQL procedures, functions and packages to meet the customer requirements
• Provided Oracle Application support in the following modules: HRMS, Self Service, PTO, Performance management, Compensation Workbench, Oracle Time and labor, Ceridian PAYROLL Created an implementation project to maintain the setup of specific business processes and activities for Fusion HCM, Global HR.

Environment: PeopleSoft, SQR Process, Oracle Applications 11i/R12 (AP, AR, PO, GL), Oracle Database 10g, Oracle Application Framework, Oracle Fusion HCM Release11, Oracle Fusion HCM 12

Confidential, Sterling, VA

Oracle HCM Consultant

Responsibilities:

• Implementing Talent Management (Goal management, Performance management, Talent Review), Absence Management.
• Analyze business requirements, perform Fit- Gap analysis and developing effective configuration solutions.
• Served as the Leave of Absence primary point of contact for phone, emails, and mail communications with employees, management, our HR team and 3rd party entities.
• Evaluated current process for improvement when applicable.
• Provided instruction to employees and training for managers and HR staff on appropriate procedure for all types of leaves.
• Developed, generated and presented reports to analyze leave data and trends
• Provided accurate tracking of all leaves - from start dates, to return dates, intermittent leaves, pay, benefits, etc.
• Reviewed, updated and maintained all Leave of Absence Management policies to ensure legal compliance, ensure proper distribution and integration with all other departments and training of HR and non-HR Managers.
• Analyzed business requirements and developed effective configuration solutions.
• Part of business process workshops, CRPs and supported clients in defining relevant processes.
• Configure custom Workflow routing rules for all Manager Self-services and Employee Self-services.
• Built Custom Security to Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Experience in Developing Fusion HCM extracts
• Created Multiple OTBI Reports and worked on BI Reports and HCM extracts.
• Preparation of HDL Data Templates to upload client Data into Fusion application.
• Preparation of Custom reports, data models and analysis according to client requirements.
• Developed HCM Extracts Reports and responsible for transferring the data to third party systems on daily basis.
• Personalized Cloud UI using Sandbox to meet business requirement.
• Loaded business objects which includes the Workforce structure data, Worker data, Work relationships data, Salary, Jobs, Locations, Content Type, Content Items, Ratings, Establishments (Institutions), Talent Profiles, etc using Spreadsheet Loader, HCM Data loader (HDL), and Payroll batch Loader (PBL).
• Developed HCM Extracts for Global HR, Benefits and Payroll Interface.
• Created BI reports and Analytics
• Ensured highest level of customer service and responsiveness throughout the leave of absence management process with employees, managers, our HR team and 3rd party entities throughout the leave of absence management process.
• Configurations related to Absence Management and Talent Management.
• Creating Absence Management Set ups like Shifts, Patterns, and Work Schedules.
• Creating Absence Plans, Absence Types, and Absence Reasons as per the business requirement.
• Writing Absence Fast Formulas for Absence Type validations and accruals.
• Configuring Performance Management set ups like Performance Process Flows, Talent Eligibility Profiles, and Performance Document.

Environment: PeopleSoft, SQR Process, Oracle Applications 11i/R12 (AP, AR, PO, GL), Oracle Database 10g, Oracle Application Framework, Oracle Fusion HCM Release11, Oracle Fusion HCM 12.

Confidential, Bronx, NY

Oracle EBS Consultant

Responsibilities:

• System was designed and built to consolidate many disparate systems and move the business to a shared service model.
• Performed GAP analysis and specification of custom extensions, time entry rules, custom timecards and interfaces required by the Business.
• Involved in the design and quality assurance of elements and highly complex fast formulas.
• Worked closely with employees from the client at all levels to collect requirements through workshops and meetings to ensure that design met the business requirements.
• Worked closely with solution architect to ensure OTL information flowed correctly into Payroll and Finance and was costed and paid correctly.
• Worked with technical consultants to ensure custom extensions and reports were developed accurately.
• Customized standard Oracle Applications (EBS) reports and developed custom reports on financials (AR, AP, GL), SCM modules
• In preparation for EBS R11 to R12 Upgrade developed training guides and conducted training in the following areas:
• Common R11 code changes required for R12 SQL scripts and PL/SQL packages, procedures, functions, DB Links and other DB objects.
• BI Publisher with Oracle Reports
• Developed Java database application to automate migration of custom database object in support of Oracle EBS R11 to R12 upgrade.
• BI Publisher with XML Data Template
• Project followed the AIM methodology. Created documents including BP80s, MD50s, BR100, TE20s and TE40s.
• Highly involved in the solution CRPs, Unit Testing, System testing, UAT and Parallel run.

Environment: PeopleSoft, SQR Process, Oracle Applications 11i/R12 (AP, AR, PO, GL), Oracle Database 10g, Oracle Application Framework, Oracle Fusion Release 11, Oracle Fusion HCM 12, SQL/PL

Confidential, Tampa, FL

ERP Consultant

Responsibilities:

• Developed business architecture using requirements such as scope, processes, alternatives, and risks.
• Analyzed client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Involved in Leading a technical team for understanding the various technicalities and functionalities of the various customizations done in the system.
• Conducted 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client’s needs are met.
• Communicated client’s business requirements by constructing easy-to-understand data and process models.
• Involved in File Based Loader (FBL) for worker details that includes loading of person data, employment data, experience, skills & competencies, Training etc.
• Well versed with the setup of Work Structures - Location, Organization, Job and Grade in HR.
• Generated analyses using OTBI for Global HR, Goal and Performance Management subject areas.
• Configured end to end performance document life cycle.
• Production Support - Troubleshooting Production Payroll issues and solution.

Environment: Oracle, SQL/PLSQL, PeopleSoft,SQR.

Confidential, Dallas, TX

ERP Consultant

Responsibilities:

• Developed business architecture using requirements such as scope, processes, alternatives, and risks.
• Analyzed client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Involved in Leading a technical team for understanding the various technicalities and functionalities of the various customizations done in the system.
• Conducted 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client’s needs are met.
• Communicated client’s business requirements by constructing easy-to-understand data and process models.
• Supported Oracle HCM Applications (Core HR, payroll, Talent Management, Compensation and performance management) implementation
• Assist Functional team in Business Requirement Specification for HRMS and Payroll
• Participated in implementation of ERP system and integrated with different Systems like Oracle HRMS and Oracle Payroll.
• Supported the Development of Oracle extensions and support skills
• Provided input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Engaged client to gather software requirements/business rules, and ensure alignment with development teams.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object types and Triggers.
• Translated stakeholder requirements into over 10 different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.
• Drafted and maintained business requirements and align them with functional and technical requirements.
• Facilitated monthly meetings with clients to document requirements and explore potential solutions.