Home

Ravalika - Oracle Cloud HCM Techno Functional Consultant

[email protected]

Location: Dallas, Texas, USA

Relocation: Anywhere

Visa:

Ravalika P Phone: (973)821-7447 __________________________________________________________________________________________________ PROFESSIONAL SUMMARY: Experienced and Energetic professional with 8+ years of hands on in HR and HR Information Systems and implementation of Oracle Cloud HCM Fusion applications by facilitating sessions, workshops, developing and delivering end-user training, project management, and preparing and presenting project briefings to executives. Delivered optimum benefits, with technical proficiency, to employers and clients with deep belief in their missions Expertise in Oracle Fusion Cloud HCM offerings - Workforce Deployment (Global HR, Payroll, Workforce, Time and Labor (OTL), Absence Management) and Workforce Development (Talent Review, Performance, Goal and Succession managements. Compensation Management (benefits, Incentive and Total Compensation). Strong Experience on Taleo functionality like Import candidates (ready to hire) from Taleo Recruiting to Oracle Fusion HCM using the TCC(Taleo Connect Client) Scripting process and Import-export schedule process errors resolutions. Expert in delivery of the Oracle HCM Cloud applications, analysis of 'as is' and 'to be' business processes and mapping those processes to Fusion HR functionalities, defining and documenting Oracle and non-Oracle standard solutions. Extensively worked on Implementation planning, Fit/Gap Analysis, design changes and providing alternatives to the clients on product limitations. Worked on complete lifecycle implementations involving Data allotment, Requirements gathering, Business Process Re-engineering, Configuration, Development, Troubleshooting, Training and production support environment. Experience in multiple full end to end life-cycle implementation of all major cloud modules in both fresh and conversion projects from various legacy systems. Excel in interacting with the project team members responsible for developing reports, interfaces, data conversion programs, and application extensions and able to lead discussions during business requirement meetings. Excellent ability to learn and deliver the assignments in given time frame and ability to work on multiple projects with excellent communications skills. Experience in configuring and working with functional set up manager and enterprise level configurations across Oracle HCM Fusion Modules. Experienced in configuring Workflow routing rules for all Manager Self-services (MSS), Employee Self-services (ESS), approvals, security configurations, handling daily HR transactional errors and BPM error handling. Experience in Customizing Cloud HCM Security components like Data Role, Job Role, Duty Role, Security Profiles, Abstract roles and well versed with aggregate privileges and assigning duty roles. Extensively involved in Enterprise level design sessions and helped in HR and Payroll one-time setups and Involved in third party integration to and from Cloud HCM. Experience in Oracle HCM (EBS/Fusion), including workflow and alerts; PL/SQL and Fusion Middleware Object Design, Development & Testing phases. Experience in Creating custom reports and analytics using OBIEE/OTBI(Oracle Transactional Business Intelligence), and BI Publisher in various Cloud HCM subject areas and good knowledge in HCM Extracts functionality and ODI(Oracle Data Integrator) tools. Excellent experience in Design and develop HDL scripts to load SQL stored procedure for performing complex transformation which would require data from multiple SQL tables to create the HDL to load the bulk data into Oracle cloud Applications. Developed many HDL (HCM Data Loader) files for conversion and data fix activities by creating custom BI Publisher Reports as per the business requirement. Developed HCL Scripts for complex business objects like Worker object which has five levels in object hierarchy, ranging from worker component to assignment, salary, grade steps and assignment extra information. Developed HDL/BI Reports for very high volume of Employee data, more than 70,000 records, did through testing and reconciliation to make sure there are no performance issues or data errors. Assisted end users with documenting new business procedures and test scripts for CRP & UAT. Developed BI (Business Intelligence)/OTBI (Oracle Transactional Business Intelligence) Reports in Core HR, Payroll and Compensation modules. Develop reports to report Salary history and incentives for the past 5 years. Developed reports to track employees performance and write few day-to-day business specific reports like terms, Certifications and License expiry, Visa expiry information to business to trigger users to take next steps. TECHNICAL SKILLS: Oracle HCM Extracts, Oracle Fast Formulas, Oracle SQL and PL/SQL,HDL (HCM Data Loader), BI Publisher (Business Intelligence), OTBI (Oracle Transactional Business Intelligence),SQL developer, SQL*Plus, SQL*Loader, TortoiseSVN, WinSCP, Managed Beans, Model-View-Controller, Task Flows, DBCS, , SoapUI, REST Services, Oracle Fusion Applications, Oracle Cloud HCM. EDUCATION: BACHELOR S IN INFORMATION TECHNOLOGY FROM JNTU (2014). PROFESSIONAL EXPERIENCE Client: Acosta Role: Oracle Cloud HCM Techno Functional Consultant Duration: April 2021- Till date Responsibilities: Develop a separate HCM extract for each vendor based on design document. Develop various types of BI (Business Intelligence) Templates like eText template, XSL (XML Style Sheet) Template and RTF Templates to produce various fixed length report layouts, Excel Reports and PDF Reports. Develop the process to schedule the interfaces based on vendor frequency specifications to move the files automatically to vendor location. HDL (HCM Data Loader) is the format that requires creating for each data load into Oracle cloud Applications. Each HDL object has a different format, so understand the data and create the Oracle SQL Tables and PL/SQL packages, procedures and functions to create the HDL load files for each (Employee, Job, Salary and certificates) load. Analyze each vendor s requirements, create the design document and develop the interfaces based on each vendor specifications like no of fields, employee eligibility criteria, fields and file formats, and transmission of the file to each vendor location. Write the SQL Queries to build the complex queries to use in Fast formulas. Develop Complex Fast Formulas to dynamically derive HCM Extract Parameters for calculating various HCM or payroll related attributes like Salary, Bonus, Incentives and Over Time Pay. Create Custom Value Sets to overcome the limitation of custom SQL Functions in HCM Extracts and derive various Employees, Payroll attributes from the HCM Database as per the business requirements. Develop the relations between each data points like Person, Assignment, Terminations, Salary and Document of records etc. Develop SSH File Transfer Protocol (SFTP) scripts to send the secure files to above vendors. Log the interface errors, which will be used for troubleshooting in case of any issues. Create schedulers to execute the process/services for specified intervals. Custom Applications Development using Oracle Cloud JCS(ADF/DBCS/VBCS) environment. Build complex transaction synchronization logic to handle large volume of transactions involving multiple servers and databases. Perform high degree of application tuning to minimize the network load, latency and significantly reduce the bandwidth and storage related costs associated with various cloud software vendors. Out of the box thinking while integrating nonflexible cloud applications with business-critical applications. Validated integrations using OIC (Oracle Integration Cloud) to provide data to third party systems from HCM Develop services to read input files as UTF-8 encoded, convert to xml, and apply data transformations. Oracle Bulk data loads, Custom Reports development and Oracle Compensation Technical Integration. High degree of SQL Query performance tuning by reviewing complex SQL Query execution paths, trace files and construct the best optimizer hints to ensure the best consistent performance with the applications developed. Support Testing and Production fixes; create supporting documents required for design, development, unit testing and deployments. Communicate with business/application teams to gather requirements and create a high-level design documents, mapping documents and service level design documents. Create deployment instructions document for admin teams. Create deployment builds for respective production releases and validate post deployment. Support SIT/UAT/Performance testing support for the services developed for every release. Monitor live traffic to verify response times and volume. Support maintenance team for any issue in production and apply fixes if any by process. Troubleshoot for any issues and apply fixes. Client: BCBS (Blue Cross Blue Shield), Role: Oracle Cloud HCM Integrations Duration: DEC 2018- JAN 2021 Responsibilities: Developed BI publisher reports in Benefits, HR and Payroll area and developed HCM Extracts for various interfaces. Documenting Business requirement for the new integrations from Taleo to Fusion HCM. Data Loading/Conversions using HCM Data loader (HDL) and spreadsheet loaders. Experience in generating templates for Employee, Organization and Department imports into Taleo Cloud using TCC integration. Handled complete technical team and integrations in phase-I of the project from Fusion to third party applications like Taleo and ADP Payroll. Facilitated Workshops for Business Requirement gathering, CRP and UAT. Assisted end users with documenting new business procedures and test scripts for CRP & UAT. Expert in setting up enterprise structure, workforce structure and span business process like understanding and interpreting fast formulas, profile and workforce directory management and Security (Security Profiles, Data, Job and Duty Roles), HCM Data Loader (HDL), HCM Extracts. Managing & creating Flex Fields like Extensible, Descriptive Flex Fields, and Values Sets. Data Loading/Conversions using HCM Data loader (HDL) and spreadsheet loaders. Experience in developing HCM Extracts/BI Reports for Global HR, Payroll Interface. Import candidates (ready to hire) from Taleo Recruiting to Fusion HCM using the Import Oracle Taleo Recruiting Cloud Service Data process and Import-export schedule process errors resolutions. Implemented Core HR, Benefits and Compensation modules as part of Phase-I of the Project and currently implementing: Goals, Performance, Succession Planning and Talent Review as part of Phase-II of the project. Extensively worked on Goal Plans, Questionnaire, Performance scale, Appraisal Template and Performance Document under talent management sections. Running workshop sessions analyzing client requirements and recommending future state process and solution design in CRP (Conference Room Pilot) Programmer. Analyze business requirements and developing effective configuration solutions. 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. Lead the Conversion team for complete migration of 7 yrs. Historical core HR and Talent Data from Legacy system using: HDL and PBL. Extensively used Security Console to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles. Developed custom HCM Extracts, BIP Reports, OTBI Analysis and implemented the new concept of Infolets for Dashboards. 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. Developed the reports using scheduling triggers to notify the Developed OTBI reports for HR users to view and validate employee data using existing subject areas. Subject areas are functionally secured using Oracle Fusion Duty Roles. Person Selection Fast Formula - To run the benefit evaluation processes. HCM Extract Rule Fast Formula - To identify the Pay group change. Common configurations in Core HR area like DFF, EFF and lookups. Setting up the DFFs at Job and Assignment Level to capture more information. Client: Charles Schwab Corporation Role: Sr. Oracle Fusion HCM Techno-Functional Consultant Duration: OCT 2016- NOV 2018 Responsibilities: Driving and documenting business requirements and procedures obtain sign off to ensure client alignment of proposed solution. Part of business process workshops/CRPs and requirements gathering sessions and support clients in defining relevant processes. Provided business consulting support and facilitates discovery workshops. Developed the Fast formulas for Applaud time entry, Accrual plans and Input validations - (Oracle Fast Formula, PL/SQL and AOL components). Fast Formulas for Fusion HCM Extractions. Person Selection Fast Formula - To run the benefit evaluation processes. HCM Extract Rule Fast Formula - To identify the Pay group change. Configured security objects including Management Hierarchies, Regions, Locations, edited Domain and Business process security policies, Tenant setup and created reports to meet customer requirements. Worked on requirements, process flows, and solution design of the modules for an R12 Coordinate with QA team and ensure the product is bug free and ensure all test cases and scenarios are covered. Perform Starter steps like Create Implementation Users; View all data roles, Load/Manage Geographies. Set up and Maintained Enterprise structure and Workforce structures. Experience in working both tier and three tier employment models with single and multiple assignments. Worked on coexistence model integrations, HCM extracts, BI publisher OTBI/OBIEE. Managed functional support for core HR process, Compensation, Business Process and Security Groups. Defined setups of Core HR, Self Service HR, Payroll, Oracle Time and Labor (OTL), iRecruitment and Performance Management (PMS) modules to map the business requirements into Product functionality. Support experience in Oracle Advanced Benefits (OAB) and Oracle Learning Management (OLM). Provided roadmap document, executive summary and strategy for upgrade to current release for two modules, Absence Management and Time and Labour. Expert understanding and configuring legal entities, TRU, PSU, Legal employers LDG, Business unit set assignments, job configurations, employment models and distinguish tree setups. Worked on allocated checklists for the onboarding asset management and scheduled worker/managerial tasks. Interpreted areas of responsibility tasks in the Cloud HCM. Worked on Absence Integrations with Payroll, OTL and Workforce scheduling. Involved in Complete Functional Setups for SSHR, OTL and PTO modules. Developed Functional and Technical Design document for HR, OTL, Absence Management and CWB Extensions. Generated analyses using OTBI for Global HR, Goal and Performance Management subject areas. Created various accrual and qualification absence plans and absence types where employees are restricted so that they can record absence only of a specific duration. Configured medical and personal leave categories and pulled the same to the HR and Payroll reporting purposes. Proficient in preparing E-Text template & RTF file formats for Absence, Core-HR & Talent modules. Configuring the performance templets and making the changes into the template in multiple languages. Implemented Performance module and integrated annual and quarterly templates for the compensation workbench. Worked on profile rating models, review periods, questions and questioner templates also implemented annual performance process flow. Implemented end to end performance and goal management and extensively worked on adding and editing the goals, setting the status of goals and deciding the accessibility of goals. Configured various levels of employee and manager portraits and dashboards. Specialised BI reports for talent management modules and helped in developing HCM Extracts for Global HR, Absence and Talent modules. Designed custom reporting and interfaces to meet client and audit requirements. Supported client in Oracle Cloud UI personalization's and customizations for end users and coordinating with Oracle for SRs, new product releases, upgrades/patches/fixes. Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc. Import candidates (ready to hire) from Taleo Recruiting to Fusion HCM using the Import Oracle Taleo Recruiting Cloud Service Data process and Import-export schedule process errors resolutions. Streamline Recruiting & On boarding processes with Core HR applications. Configure Requisition & Candidate files, Requisition approvals, Candidate Selection Workflows (CSW), Candidate Communication Agent (CCA), Configure Source Tracking, Evaluation Management, Recruiting Centre (welcome centre, Theme& Logo, Communications Channel in Taleo Recruiting. Client: Capgemini Technology services, India Role: Oracle Systems Analyst Duration: Jun 2014 Sept 2015 Responsibilities: Attend Business Process and Knowledge Transition Sessions with IT & Business Owners and Mapping Customers requirements into Oracle. Involved in various Functional setups of HRMS, Payroll, Inventory, Purchasing. Interacted with client during the Implementation process, Involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping with Oracle Application for CANADA localization. Documentation (BR100, Setup document), design and validation of setup. Requirements mapping, configuration, issue resolution, training, testing and support for HRMS and SCM. Involved in resolving day-to-day issues in the support environment. Maintaining issue tracker, took part during Go live in the Production. Keywords: quality analyst user interface business intelligence information technology golang procedural language