Workday Hcm Business Process
Resume:
Kalpana Rayasam
ad3coj@r.postjobfree.com
Summary:
●IT professional with overall 8+ years of experience working on Workday HCM, HRIS, Recruiting, On- boarding, Time tracking, Absence Management, Talent Reporting, Benefits, Payroll, Base Compensation and Integration.
●Good Knowledge in developing integrations like EIB & Studio integrations and Report writer, BIRT report in HCM & Finance, using transformation XSLT, developed XML code and XPath navigation.
●Proficient in Development of Advanced, Matrix, Composite, Custom Reports and Workday Calculated Fields in Core HR, Benefits, and Payroll.
●Good understanding of Integrations including Web Services, SaaS, Workday Architecture, Business Process Framework.
●Experience in creating Several Custom Reports on Ad-Hoc and Schedule Basis for Users and Support Team in Benefits, Time Tracking, Advance Compensation, Absence Management and Payroll.
●Good understanding of Integrations to develop including Web Services, Workday Architecture, Business Process Framework, integrate Workday HR with recruiting systems, developing simple and advanced matrix custom reports for integration.
●Experienced in configuring Compensation framework, providing support and guidance to a geographically distributed workforce and/or HR Business Community to meet client requirements.
●Thorough knowledge of HR processes such as employee record maintenance, Payroll, Benefits, Security, Pay Planning, Performance Management/Talent Management, On-boarding.
●Experience in implementation of Workday HCM for various HR modules which includes Benefits, Payroll, Recruiting, Talent Management, Change Management, Compensation. Expertise in analysis of client's HR/Payroll business needs through client working sessions and day to day support of Workday HCM, Security, Compensation and Reporting issues.
●Core areas of expertise in the Workday HCM include Workday Absence Management, Integration, Compensation (salary based on different grades, allowances), performance management, Time Management, Business Process (Hiring and Termination) and Security like Role/User/Job Based Security groups.
●Extensively involved in trouble shooting and fixing problems at development, system testing and post- production stages for various HRMS modules.
●Consult with business stake holders to understand business problems and translate them into functional and non-functional requirements.
●Defined Test Strategy and Test Approach, Managed the Overall test project plan, time tracking, defect management, issue resolution and risk management.
Technical Skills:
Workday skills: Workday HCM, Workday conversions, Workday Report Writer, iLoads, core connectors and Workday Studio.
Document Processing: MS PowerPoint, MS Project, MS Visio, MS Web, MS Excel.
Databases: Oracle, SQL, MYSQL, PL/SQL.
Qualification:
●Masters of Business Administration from Sri Venkateswara University. 2007
●Bachelor of Commerce (Computer Applications) from Sri Venkateswara University.
Professional Experience:
Johnson & Johnson Oct 2023 - Present
United States · Remote
Workday Analyst
Responsibilities:
●Configure, Develop and Test Cloud Connect HCM between Workday and External Systems Participating in re-engineering of Core HCM, Benefits, Compensation and Payroll BPs.
●Involved in gathering requirements and formulating the requirements for formatted reports.
●Assigning Organization Roles and Role based Security for employee.
●Create Compensation for new hire employees, Review employee hire, and edit workday accounts and resetting the passwords.
●Leveraging EIB configuration to transform the format of Workday reports into the required field format using XSLT.
●Worked on Reports to create custom reports using Workday Report Writer to meet the business needs of HR and Payroll application report consumer groups.
●Hands on experience in Standard Reports, Calculated fields and Custom reports Created and maintained custom and ad-hoc reports as well as, run scheduled reports needed by end-users and Create custom Workday reports and modify/troubleshoot existing custom reports using Calculated Fields.
●Experienced to work with Workday Report Writer creating Advanced, Matrix & Composite reports for HR Data.
●Collaborated extensively with SMEs to configure environments with all necessary business application configurations and setups to align with operational requirements.
●Experience creating new custom metrics using Matrix reports and publish values for metrics for periods.
●Experience configuring Executive workforce scorecard and custom scorecards
●Created Report Groups and scheduled for leaders with custom excel template
●Worked on reporting for whole enterprise which contains 4 different companies
●Create and debug calculated fields to optimize the performance of custom reports.
●Created surveys & Questionnaire in workday for different life cycle surveys for HR data
●Worked with service Now, An incident management tool for managing the incidents and new report requests
●Participated in requirement gathering meetings and translated business requirements into technical design documents/ report visualization specification design documents.
●Using EIB configuration, transformed the format of workday report into required file format using XSLT.
●Synthesized and translated Business data needs into creative visualizations in Tableau
●Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards and other Business Objects Applications in new environment.
●Built reports using Framework Manager and published the package.
●Accessed published package using Cognos Connection.
●Prepared Unit Test Cases and performed testing in the development environment.
●Created Query Subjects in Framework Manager as stored procedure source with parameter mapping.
●Maintained and published Framework Model.
●Analyzed existing Crystal reports and incorporate the calculation in the Framework Model.
●Initially the Framework Manager Query Subject was pointed to SQL Server2000 as database and all the reports have been developed. In final, the same Framework Manager is deployed to Oracle 9.1 and all the ReportNet reports made to run successfully on both the platform.
●Created drill-thru reports and cross-tab reports in Report Studio.
Client: Salesforce Inc, Dallas April 2022 – Oct 2023
Workday Consultant
● Working for Create Position Management system. Create Position, Edit, Edit Restriction for Unfilled position and Close/freeze position in the Workday systems.
● Extensively I am working on report corrections / Creating new reports / Tweaking reports / Creating calculate fields for new reports.
●I have been doing the Smoke Testing to find the defects in the new build, also have experience in UAT
●I ensure that data is loaded correctly. For example 1-1 validation for all data points.
●Tracking and resolving SFTP (FileZilla WinZip, Cyberduck and other tools) issues.
●Have experience in loading both outbound & inbound data using integrations. And run the EIB extracts
●Worked for the PM Center of Excellence team and played a major role in the Transitioning into workday's Job management to Position Management System.
● Ensure that the validation and maintenance of workforce plans, ensuring data integrity in the PM system, participate in user acceptance testing and deliver workforce analytics and reports
● Perform Mass bulk loads for the position creation in workday in the Position management
● Verify the accuracy of data, locate and correct data errors
●Extensively I am working on report corrections / Creating new reports / Tweaking reports / Creating calculate fields for new reports.
●Setup and validated the various Eligibility Rules and Event Rules and worked on the Eligibility Configuration fields.
●I have been doing the Smoke Testing to find the defects in the new build, also have experience in UAT
●Performing testing, deployment systems integration, which includes testing & executing thepilot/implementation/deployment of new or enhanced hardware or software.
●I ensure that data is loaded correctly. For example 1-1 validation for all data points.
● Creating / updating and maintaining the documentation for the current build which can be reused as check points for the upcoming builds.
Client: Bank of America, Dallas August 2019 – April 2022
Workday Consultant
Responsibilities:
●A Created Supervisory organizations, Location hierarchies, Region and Region hierarchies, Cost Center and Cost Center hierarchies and Custom organization types, working with staffing models like position management, headcount management & job management.
●Created Compensation Rules (Eligibility rules), Compensation Plans, Compensation Grade and Grade profiles and Compensation Packages.
●Setup Business Process steps, such as Action, Approval, Approval Chain and Checklist, and how they work and integrate with Security Groups. Created the various type of Validation and Condition Rule for the efficient performance of Business Process framework.
●Configured Security Group by creating and assigning Role-Based, User-Based and Job-Based groups with security policies, which plays a vital role in configuring Workday.
●Create Functional Design documents and maintain configuration documents for the end users and technical team.
●Worked closely with the Workday implementation partner, business users and technical staffs to replace the legacy systems (ADP) with Workday HCM
●Worked and configured, testing and implementing of payroll system in Workday like (Workday Payroll, Workday Time Tracking)
●Configure, Develop and Test Cloud Connect HCM between Workday and External Systems Participating in re-engineering of Core HCM, Benefits, Compensation and Payroll BPs.
●Involved in gathering requirements and formulating the requirements for formatted reports.
●Assigning Organization Roles and Role based Security for employee.
●Create Compensation for new hire employees, Review employee hire, and edit workday accounts and resetting the passwords
●Worked on Reports to create custom reports using Workday Report Writer to meet the business needs of HR and Payroll application report consumer groups.
●Hands on experience in Standard Reports, Calculated fields and Custom reports Created and maintained custom and ad-hoc reports as well as, run scheduled reports needed by end-users and Create custom Workday reports and modify/troubleshoot existing custom reports using Calculated Fields.
●Experienced to work with Workday Report Writer creating Advanced, Matrix & Composite reports for HR Data.
●Experience creating new custom metrics using Matrix reports and publish values for metrics for periods.
●Experience configuring Executive workforce scorecard and custom scorecards
●Created Report Groups and scheduled for leaders with custom excel template
●Worked on reporting for whole enterprise which contains 4 different companies
●Create and debug calculated fields to optimize the performance of custom reports.
●Created surveys & Questionnaire in workday for different life cycle surveys for HR data
●Worked with service Now, An incident management tool for managing the incidents and new report requests
●Participated in requirement gathering meetings and translated business requirements into technical design documents/ report visualization specification design documents
●Synthesized and translated Business data needs into creative visualizations in Tableau
●Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards and other Business Objects Applications in new environment.
●Built reports using Framework Manager and published the package.
●Accessed published package using Cognos Connection.
●Prepared Unit Test Cases and performed testing in the development environment.
●Created Query Subjects in Framework Manager as stored procedure source with parameter mapping.
●Maintained and published Framework Model.
●Analyzed existing Crystal reports and incorporate the calculation in the Framework Model.
●Initially the Framework Manager Query Subject was pointed to SQL Server2000 as database and all the reports have been developed. In final, the same Framework Manager is deployed to Oracle 9.1 and all the ReportNet reports made to run successfully on both the platform.
●Created drill-thru reports and cross-tab reports in Report Studio.
Cognos Developer/Tableau
American Modern Insurance Group, Cincinnati, Ohio Oct 2016-Aug 17
American Insurance is one among the oldest mutual insurers in the United States. They provide Auto, Home and Life Insurance. American is a direct writer of personal insurance with auto, homeowners, personal excess liability and marine coverage’s. The company is known in the insurance industry for its financial strength and exceptional customer service. The project is to implement design/development analytical reports/dashboards for marketing teams by blending Adobe Marketing Cloud data with other data sources using Tableau.
●Participated in requirement gathering meetings and translated business requirements into technical design documents/ report visualization specification design documents.
●Synthesized and translated Business data needs into creative visualizations in Tableau.
●Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards and other Business Objects Applications in new environment.
●Designed DataMart to accommodate views/tables (AGG tables) with various calculated metrics from DW (Fact & Dimension) data to suffice source needs for Tableau reporting.
●Created Data Flow Diagrams (DFDs) to define flow of data through the system and to create overview of reporting database layers/DataMart’s.
●Extracted digital marketing data from Adobe Marketing Cloud in Tableau Data Extract (TDE) format by connecting to Adobe Site Catalyst for developing Business Intelligence dashboards.
●Refreshed the Tableau Extract in production server using scheduler.
●Used Data Blending, Groups, combine Adobe Marketing Cloud data and other aggregated data, spotlight into compare and analyze data in different perspective.
●Developed various reports using best practices and different visualizations such as Lollypop Charts, Donut Charts, Funnel Charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles, Scatter Plots, etc.,
●Developed reports comparing multiple measures using Individual Axes, Blended Axes, and Dual Axes.
●Built complex calculations using advance functions such as ATTR, DATEDIFF, STR, Ifs, Nested Ifs, SUMIF, COUNTIF, LOOKUPs and Quick Table calculations.
●Created Actions in Dashboards for interactivity, to compare & analyze data in different perspectives and to easily navigate through different dashboards enabling users to drill down to more detail data.
●Created SQL scripts for testing and validating data on various reports, dashboards, and scorecards and handled performance issues effectively in Tableau.
●Involved in administrating Tableau server and creating tab admin scripts for automating backup procedures through windows scheduler.
●Worked in user management, group management and permission management for accessing dashboards based on security requirement.
●Deployed Tableau dashboards in production after user acceptance test clearance.
●Developed other supporting documentation such as source to target mapping documents, business logic flows, process flows, requirements traceability matrix, etc.
●Provided 24/7 customer support to tableau users.
Environment:
Tableau (Desktop/Server), Oracle, MS SQL Server, TOAD, Teradata SQL Assistant, Desk, UNIX, MS VISIO, Microsoft (Word, Access, Excel, Outlook).
Cognos BI Developer
Avis Budget Group, Parsippany NJ
Apr 2014 – Sep 2016
●Conducted requirements gathering sessions and interacted with business process owners to understand the functionality required.
●Analyzed and optimized the process. Prepared Business Requirements Document and then converted the business requirements into Functional Specifications and Technical Specifications.
●Worked in Reports studio, Query studio.
●Prepared meeting minutes and distributed to various participants and for artifacts purposes.
●Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
●Implemented data level and object level security in Framework manager.
●Created prompts, calculations, conditions & filters in the report as well as in the Framework Manager.
●Created Dashboards and modified the existing Dashboards using Report Studio.
●Created Drill through Reports and also used Conditional Formatting extensively.
●Improved performance of the Reports.
●Set up required permissions in the Cognos Portals for the User group for security purposes.
●Document the list of changes that impact the reports using MS Word and MS Excel.
Environment:
Cognos 8.3 BI, Framework Manager, Cognos Connection, Metric Studio, Impromptu 7.4,Cognos Power Play Transformer 7.4,Windows 2003 server.
Contact this candidate