SUMMARY

• 8+ years of experience in Design, Development, Administration and Implementation of Oracle HCM Cloud (R10, R11) and Oracle Applications both 11i & R12 HRMS modules
• Configuring the product based on the customer’s business requirement and simulating the functional set up. Implementation of the enhancement requirements on the simulated environment and evaluating the functionality.
• End to end implementation experience in Global HR, Payroll, Absence management, Talent Management, Profile Management and Compensation modules.
• Interacted with clients during the Implementation process, Involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping with Oracle cloud and Application.
• Good leadership and commination skills, on time deliveries, multi - tasking and assisting clients in the selection, implementation planning, fit/gap analysis, conference room pilots, configuration, testing, training to diversified users, rollout, post-implementation support of Oracle Fusion HCM cloud/SaaS solutions at various customer sites, POC’s and CRP.
• Experience in developing functional and technical design and documentation forOracleApplications using data conversions, interfaces, custom reporting.
• Involved in the defining of absence plans as per the client requirement both Accrual absence and qualification plans.
• Experience in managing HR data requests and Assemble, analyze and format data into useable reports.
• Experienced in configuring Workflow routing rules for all Manager Self-services and Employee Self-services.
• Excellent experience in Data loading into FusionHCMusingHCMData Loader Tool which includes the Workforce structure data, Worker data, Work relationships data, and Salary info.
• Trained the end users in working with the Oracle modules provided technical expertise.
• Experience in retrieving Data using SQL queries.
• Strong functional documentation skills, created BR110, BR150, MD50, MD70 and TE040 for the implementation of HCM Modules
• Solved the issues for UAT Training as per Priority and updated status Sheet.
• Responsible for interacting with business partners to identify information needs and business requirements for Setups.

TECHNICAL SKILLS

Functional: Global Human Resources, Benefits, Payroll, Performance Management, Goal Management, Absence Management, Talent Review & Succession Planning, Compensation Management and Security

Oracle EBS HCM: Human Resources, Payroll, Self Service HR (Manager/Employee)Advanced Benefits, Standard Benefits, Time and Labor, iLearning, iRecruitment, Compensation Workbench, Performance Management, and Application

Database & Tools: Oracle 11.X, 10.X, Oracle 9.X, Oracle 8.X, Oracle 7.X, Oracle Discoverer, PL*SQL

Operating Systems: UNIX, Linux, Windows NT, XP, Vista, 7, Windows 8

Office Automation Software: MS Office, Access, Project, Outlook, Visio

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Senior HCM Cloud Consultant

Responsibilities:

• Responsible for developing standardized Global HCM business processes across spectrum
• Implemented Core HR, SSHR, Payroll, Benefits, Compensation, Talent Management and Taleo Learn in a SAAS on - premise and Cloud environments.
• Extensively worked on goal plans, questionnaire, performance scale, appraisal template and performance document under talent management sections.
• Developed multiple Fast Formulas of different types like Person selection, Comp Default necessary for Comp Calculations for Plans like Merit and Lump Sum Pay, Variable Pay, ABBR Plans.
• Analyze business requirements and developing TEMPeffective configuration solutions.
• Functional lead responsible for global implementations of Oracle HCM Cloud (Fusion).
• Responsible for business requirements gathering, process analysis and design, gap analysis, functional system design and specification, development of system tests, business process procedures and training documentation
• Analyze, design and develop best practice business changes through technology solutions.
• Leading, facilitating and consulting on HCM Applications best practices.
• Running workshop sessions analyzing client requirements and recommending future state process and solution design.
• Developing project plan and deliver in line with Fusion Implementation Road map and Methodology.
• Demonstrating the expertise in the design, execution of implementation and testing.
• Responsible for successful testing of developed solution including User Acceptance Testing and working with the users to validate the solution.
• Supporting customers through all phases of the implementation project lifecycle, including post production optimization activities.
• Worked on problems of moderate scope where analysis of situations or data requires a review of a variety of factors.
• Sharing suggestions and thoughts to halp optimize implementation methodology.
• Configured and setup Oracle Fusion HCM Core HR as per business requirement.

Confidential, Merrimack NH

Senior HCM Cloud Consultant

Responsibilities:

• Extensively worked on global HR and payroll modules.
• Ensure that the application meets the business requirements and system goals fulfill end user requirements, and to identify and resolve system issues.
• Part of business process workshops/CRPs and requirements gathering sessions and support clients in defining relevant processes.
• UseOracleFusion Functional Setup Manager (FSM) to implement Global HR.
• Perform Starter steps like Create Implementation Users, View All data roles, Load/Manage Geographies.
• Manage EnterpriseHCMInformation and Legal EntityHCMInformation.
• Set up and Maintain Enterprise structure and Workforce structures.
• Involved in the complete testing of the Employee Transfers and 2-Tier and 3-Tier employment model.
• Driving and documenting business requirements and procedures, obtain sign off to ensure Client alignment of proposed solution.
• Very strong in the configuration of the US Payroll elements, salary basis and payroll configuration.
• Write Payroll Fast formulas, Coordination with Payroll Costing Team and provide all task details for Payroll Calculation, Taxation, Pay Terms and Conditions, Setting up Cost Allocation Key Fellfield task to configure the structure for legislative data group.
• Taleo with Recruiting and on boarding.
• DevelopHCMExtracts/OBI Reports for Global HR.
• Tested All the Tasks and business process flows related Payroll, Global HR and Talent Management.
• Build Custom Security toOracleHCMCloudwhich includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Ensure that the application meets the business requirement and system goals fulfil end user requirements, and to identify and resolve system issues.

Confidential, Burbank, CA

Oracle HRMS Functional Lead

Responsibilities:

• Worked as Oracle functional consultant as part of Oracle HRMS implementation for Oracle Core HR, CWB and OAB.
• Worked on Functional Setup Manager in Test Sandbox Instance and test the different assigned Tasks of Core HR & Payroll.
• Setup eligibility profiles, enrolment requirements, life events, benefit groups at program, plan and option levels as required.
• Identify the changes that need to be incorporated in each release and coordinate with change management and release management teams during deployment.
• Development of HDL inbound Zip file which includes the different Business Objects dat files And Unit test the load data in test instance.
• Gather requirements, questionnaire sign off, MD 50 and MD 120 documentation. Involved in setting up key flex field segments (Job, Grade, People Group, Position, Cost Allocation and Competence).
• Advise HRIS about theOraclebest practices, AIM methodology, minimize data redundancy, and automate concurrent process.
• Involved in conducting CRP1, CRP2, test data preparation and test scenario preparation.
• Involved in conversion requirements, converting people data, assignment data and salary data.
• Held regular meetings with the implementation team members, client staff and client technology providers to monitor tasks, update plan activities and expedite issues until the client’s “Go-Live” date.
• Conducted informal/formal training for the business owners and stakeholders to introduce them to the Oracle R12 functionality.
• Setup programs, plan types, plans for medical, supplemental and CORBA benefits.
• Verify existing PL/SQL packages and develop new ones as required by the HRIS team.
• Modify existing third party vendor interfaces and develop new vendor interfaces as required.

Confidential

Oracle HRMS Functional consultant

Responsibilities:

• Part of a team implementing Oracle R12 H Set-up employee self-service to for updating employee personal data on-line.
• Assist Functional team in Business Requirement Specification (BR100) for HR and Payroll.
• Customized management self-service for viewing and updating multiple employee status data. RMS modules HR, Advance Benefits, OTL and Payroll.
• Setup all organizations, locations, elements, element links, costing, job titles, payrolls, bank details, cost centers, worker’s compensation codes/rates, Global Values, Application Utility Lookups, Security Profiles and reports within the Oracle HRMS module for all applicable localizations, Setup HR related Descriptive Flex Fields, Key Flex Fields, Validation Sets, Special Information Types, Security Profile attachments, users, responsibilities, request sets and menus under the System Administrator responsibility.
• Participated in detailed Payroll requirement information gathering needed for Reports Customization.
• Extensively worked on 401K interface for payroll bi-weekly employees.
• Was involved in process of setting up Hiring Applicants and Terminating employees.
• Maintenance of Employee Information through Oracle Apps including Personal Details, Educational Qualifications, Skill Profile, Work Experience and Joining Data.
• Worked on Open Enrollment process and defined Flex credit programs.
• Worked on Transferring Timecards to BEE.
• Designed programs to upload time from Time force to OTL data conversion including time and attributes for OTL module.
• Extensively involved in setting up Date tracking modes and termination process.
• Designed M50 documentation for payroll and HR conversions.
• Performed troubleshooting and resolved issues found in parallel tests scripts, validated payroll setup, payroll elements and payroll fast formulas.
• Designed applications extensions for custom retro pay process based on time skip in OTL and payroll interface.
• Worked on functional design for conversions of Jobs, Extra Information Types, Personal Payment Methods, Elements using Oracle seeded API’s.
• Scheduled and executed the design, implementation and unit test of new development, enhancements, bug fixes and production updates.

Confidential

SQL & PL/SQL developer/Tester

Responsibilities:

• WroteSQL, PL/SQL programs required to retrieve data using cursors and exception handling.
• Developed back end interfaces usingPL/SQLstored packages, procedures, functions, Collections, Object types and Triggers.
• Involved in the data transfer and creating tables from various tables, coding usingPL/SQL, packages, stored procedures and triggers.
• DevelopSQLand PL/SQLscripts to transfer tables across the schemas and databases.
• Creatingindexeson tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Coordinated with DBA in creating and managing tables, indexes, DB links and privileges.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Worked with business analyst anddevelopersin setting up test data