SUMMARY

• 9+ years of experience in Design, Development, Administration and Implementation of Oracle HCM Cloud (R4 - R13 21A).
• 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, Time and Labor (OTL), Compensation module, ESS and MSS.
• 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 experience on Fusion HCM projects, involved in People Soft HCM Upgrade project and production support project.
• Skilled on Fusion HCM utilities like HCM Data Loader (HDL), FBL Loader, Spreadsheet Loader, Payroll Batch Loader, BIP reports and HCM Extracts.
• Good Experience in HCM Data Loader File Generation/file preparation.
• Good knowledge on identify the mandatory columns for HCM data loader Objects.
• Hands on Experience in integration of PeopleSoft 9.1 to Fusion Applications (11.1.11) using HCM Data Loader. Prepared Design, mapping documents and HDL templates for Fusion Applications.
• Involved from scratch with BenefiX Team to implement BenXML extract from Fusion Applications to various Benefits Carriers.
• Have good knowledge on HCM Security Implementation includes Abstract roles, Job roles, Duty roles, Data role templates, HCM Security Profiles.
• Worked on different issues raised while UAT testing in Upgrade project as well as support project
• Expertise in Developing complex custom Reports, Analysis, Infolets, Dashboards, Alerts using Oracle Transactional Business Intelligence (OTBI) and Business Intelligence Publisher (BIP).
• Good experience in Development of Inbound and Outbound Interfaces with multiple Third-party applications.
• Sufficient knowledge on Oracle EBS HRMS modules (Core HR)
• Proficient in writing SQL Queries, stored procedures, functions, packages, using PL/SQL, SQL.
• Strong focus on best practices, methodologies, excellent analytical, problem-solving and decision-making skills.
• Having good communication skills to understand the documentation like: "Functional Design Document-MD050", "Technical Design Document-MD070" as well as communicating knowledge.

TECHNICAL SKILLS:

Oracle Fusion Applications: (rel4-rel13), HCM Data Loader, Payroll Batch Loader (PBL), File Based Loader (FBL v1.1), Oracle HCM Extracts, Oracle Spread Sheet Loader, Security Console, Oracle Identity Management (OIM) and Oracle Authorization Policy Manager (APM), HCM Workflows/Approvals, Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Business Intelligence Publisher (BIP), Oracle Transactional Business Intelligence (OTBI), Infolets, HCM Web Services, ATOM Feeds, Oracle Business Process Management Work list (BPM), SQL, PL/SQL.

ERP: Oracle HCM Fusion, PeopleSoft HCM

People Tools: People Tools, Application Designer, Application Engine, Process Scheduler, Data Mover Workflow.

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

Reporting: OBIEE, OTBI, SQR, PS/Query

Integration Tools: file Layout, Integration Broker, Component InterfaceExcelToCI Languages people Code, SQL, C, Java, HTML

RDBMS: Oracle, SQL Server.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Senior Oracle HCM Techno Functional Consultant

Responsibilities:

• Currently working as On-site Technical Consultant to support and assistance the Project Managers and Technical Services Manager, Global HRIS for implementation and other enhancements of Oracle Cloud HCM Modules such as Core HR, Benefits, Payroll, Talent Management, Absence and OTL.
• Aided the Operations team in resolving production issues, as needed.
• Documented the processes and transferred the knowledge and trained HRIS team members on deliverables.
• Coordinated with cross-functional teams to collect the requirements for designing and developing Oracle HCM Cloud RICE objects.
• Actively participated in transformation of legacy data into Oracle Cloud acceptable format using HDL, PBL and uploaded the data to HCM Cloud.
• Developed and maintained reports and coordinated with multiple business units for the validation.
• Developed HCM Extracts and ADP interfaces.
• Developed Fast Formulas for Absence Management and OTL.
• Involved in design and development aspects of the integrations between Oracle Cloud HCM application and third parties.
• Involved in the Oracle Global Payroll Implementation Project and responsible for monitoring the ADP Global Payroll Extract.
• Created custom payroll flows and scheduled on different frequencies.
• Customized the predefined approval workflows such as post-approval activities or additional stages.
• Co-ordinate with oracle MOS team for the activities and issues in SAAS model of fusion application implementation.

Confidential, IL

Sr. Oracle HCM Techno Functional Consultant

Responsibilities:

• Worked as On-site Techno Functional Consultant for implementation of Core HR, Compensation, Benefits, Payroll modules.
• Involved in requirement gathering and data collection from the client to demonstrate the functionality offered in fusion and complete the fit-gap analysis.
• Worked with thepayrollproject team to trouble-shoot data migration issues and to load Confidential HR /payrolldata intoOracleHR /Payrollin preparation for parallel run.
• Develop integrations, extractions usingHCMextracts and BIPwhich help integrate client’s data across external systemsand Payroll systems to fulfill business requirement.
• Written fast formula for Payroll Batch Loader andHCMextracts.
• Responsible for writing the Functional design documents for the Legacy PeopleSoft Queries and new requirements in Fusion.
• Developed custom HCM extracts for seamless integration with ADP Payroll.
• Build complex business requirements such as General Wage Increase, Step Progression, Daily Movement Reports using Business Intelligence Publisher.
• Created different Dashboards such as Job Adders, Manager Dashboard, Person Number Generations using Oracle Transactional Business Intelligence.
• Lead the Core HR, Compensation, Payroll Reporting with off shore team to have the timely deliverables.
• Involved in initiating the Employee Self Service (ESS) transactions such as View Total Compensation Statement, View Payslip, View End of Year Tax Forms.
• Configured custom Workflow routing rules for all Manager Self-services and Employee Self-services with help of Area Responsibilities.
• Involved in managing approval rules and notifications for Human Capital Management.
• Participated in UAT and supported the client to resolve the issues on demand.
• Responsible for Train the Trainer activity on Core HR, Payroll, Security.
• Created and used security profiles and identified the HCM objects that need them.
• Worked with the Production support team to resolve the issues and successful fixes in Dev and Production environments.

Confidential, NY

Sr. Oracle HCM Techno Functional Consultant

Responsibilities:

• Implemented Core HR, Talent Management modules in Cloud environments.
• Responsible for business requirements gathering, process analysis and design, gap analysis, functional system design and specification, development of system tests, and training documentation
• Perform extraction and transformation from PeopleSoft, execute data loads inHCMcloud using spreadsheet loader, HDL, PBL to synchronize setup and transaction data.
• Build Custom Security to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Created custom roles like Human Resource Specialist, Performance Manager, Line Manager, and Super User Roles and configured complete Security as per client requirements.
• Configured approval policies for the Hire an Employee, Promote, Transfer, and Terminate tasks using the Manage Approval Rules and Notifications for Human Capital Management interface.
• Participated in detailed Payroll requirement information gathering needed for Reports Customization.
• Tested All the Tasks and business process flows related Payroll, Global HR and Talent Management.
• Involved in the upgrade activities of instance to rel12 during the implementation.
• Trained the managers in understanding the Manager Self Service (MSS) transactions such as name and address, time entry, emergency contacts, paid time off balances, and skill competencies.
• Developed Custom Reports, Analysis and Infolets using BIP and OBIEE.
• Prepared Test Scenarios and Test Scripts for Core HR, MSS, ESS and Security.

Confidential, MA

Sr. Techno Functional Consultant

Responsibilities:

• Responsible for developing standardized Global HCM business processes across spectrum
• Implemented Core HR, Benefits, Payroll, and Compensation, Talent Management and Taleo Recruiting and On-boarding in Cloud environments.
• Functional lead responsible for global implementations of Oracle HCM Cloud (Fusion) and Taleo Recruiting and On-boarding modules.
• 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.
• Lead the Conversion team for complete migration of 7 yrs. Historical core HR and Talent Data from Legacy PeopleSoft 9.0 system using: HDL and PBL.
• Supported the Team for Managing New Configuration Profile, User Groups & User Types.
• Responsible for solutioning and development of complete custom integration from scratch, between Taleo (TEE) and Oracle Fusion HCM application using Oracle SOA CS (Service Oriented Architecture Cloud service).
• Responsible for development of Custom BIP Reports, OTBI Analysis, Infolets and HCM Extracts to integrate with Third Party Applications like: Concur, Schwab etc.
• Develop system documentation, business requirements and support the development of end-user training.
• Provide support for Internal Users of the Taleo Recruiting Application.
• Created the security profiles individually and included them in appropriate HCM data roles. Helped the team on using relevant security profile task.
• Configure the Workflow approval policy by arranging approvers in the required order, defining approval rules for each approver, and submitting the approval policy.
• 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.

Confidential . - WI

HCM Techno Functional Consultant

Responsibilities:

• Studied the requirement and prepared high-level and Low-level design documents to configure the application and outlining the Integration framework.
• Involved in requirement gathering and data collection for various integrations with third party applications.
• Lead the Integrations team with off shore team to have the timely deliverables.
• Designed and configured the implementation project and business objects (like Legal Entity, Legislative Data group and Elements) in Fusion Applications.
• Designed the Data gathering Templates for Client as per FBL process.
• Involved in the upgrade activities of instance to rel10 during the implementation.
• Developed Custom reports, Analysis, Dashboards and Alerts using BIP.
• Developed custom HCM extracts for seamless integration with ADP Payroll.
• Worked on BenXML Benefit Extract in association with BenefiX Team to process Benefit Carrier Data from Fusion HCM applications.
• Configured BenXML extract and various Benefit Carriers information in Fusion Applications.

Confidential, TX

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.
• Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR.
• Perform Starter steps like Create Implementation Users, View All data roles, Load/Manage Geographies.
• Manage Enterprise HCM Information and Legal Entity HCM Information.
• 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.
• Provided Support for Taleo (TBE) and Fusion HCM rel 8 Integration. Revamped the complete process of integration and educated the client to follow the required standards for seamless integration.
• Design and Built the custom Integration architecture between Oracle Fusion HCM and Taleo TBE.
• Lead the Integrations team with off shore team to have the timely deliverables.
• Develop HCM Extracts/OBI Reports for Global HR.
• Tested All the Tasks and business process flows related Payroll, Global HR and Talent Management.
• Build Custom Security to Oracle HCM Cloud which 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

Fusion Cloud HCM Consultant.

Responsibilities:

• Involved in integrating the gathering and documenting the tasks and the task lists required for the Fusion applications Co-Existence Implementation with PeopleSoft 9.1 HCM application with Oracle.
• Involved in the creation of data templates required for the creation of business objects, used in Co-Existence Implementation.
• Created and designed the implementation project and business objects (like Legal Entity and Legislative Data group) in Fusion Applications.
• Run the Extract process to generate the cross-reference files from Fusion required for Coexistence.
• Configured the PeopleSoft system using the Domain Value Maps (DVMs) to extract the data in the fusion understandable format by FT EXTRACT process.
• Loaded the data using LOAD HCM DATA process into fusion applications.
• Configured and ran a compensation cycle in fusion applications for the employees populated from PeopleSoft.
• Loaded the back feed from Fusion applications to the PeopleSoft 9.1 HCM as the source of the data is still in PeopleSoft using FT LOAD process.
• Explored and analyzed the functionality of the various offerings present in Fusion Applications.
• Getting updated with the news, releases and information on enhancements and development of fusion applications from Oracle.
• Developed Custom BIP Reports, Analysis and Alerts.

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.
• 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, unit test of new development, enhancements and bug fixes.

Confidential

PL/SQL Developer.

Responsibilities:

• Wrote SQL, PL/SQL programs required to retrieve data using cursors and exception handling.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections and Object types.
• Involved in the data transfer and creating tables from various tables, coding using PL/SQL, packages, stored procedures and triggers.
• Develop SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Creating indexes on 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.
• Partitioned the fact tables and materialized views to enhance the performance.
• Coordinated with DBA in creating and managing tables, indexes, DB links and privileges.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked with business analyst and developers in setting up test data.