Workday HRIS & Reporting Analyst

AAKANKSHA RUKMANNA RANGDAL

Albany, NY +1-518-***-**** ****************@*****.***

PROFESSIONAL SUMMARY

HRIS and Workday Analyst with 1+ year of experience supporting Workday HCM, HRIS reporting, workflow documentation, data validation, UAT, and cross-functional system support across public-sector and university environments. Experienced in translating hire, job change, termination, payroll, benefits, compensation, time tracking, and absence requirements into user stories, process maps, report requirements, test scenarios, and SOPs. Skilled in Workday Report Writer concepts, calculated fields, EIB-style CSV data loads, Excel reconciliation, SQL validation, Jira, Confluence, SharePoint, HR dashboards, and data integrity checks for Workday Analyst, HRIS Analyst, and Workday Reporting Analyst roles.

TECHNICAL SKILLS

Workday & HRIS: Workday HCM, Core HCM, Workday Business Processes, Worker Data, Supervisory Organizations, Position Management, Job Profiles, Cost Centers, Employee Self-Service, Manager Self-Service, Security Groups, Role-Based Security, HRIS Support

Workday Functional Support: Hire, Job Change, Termination, Payroll Data Support, Benefits Administration, Compensation Data Review, Time Tracking, Absence Management, Open Enrollment Support, Life Event Changes Workday Reporting: Workday Report Writer, Custom Reports, Advanced Reports, Calculated Fields, Prompts, Filters, Report Scheduling, Headcount Reporting, Payroll Reporting, Benefits Reporting, Compensation Reporting, HR Dashboards, Dashboard Validation, Exception Reporting

Data Management & Integrations: EIB Inbound and Outbound Support, CSV Data Loads, SFTP, Data Mapping, Field Mapping, Data Validation, Data Cleansing, Data Reconciliation, Error Log Review, Integration Testing, Data Integrity, Employee Data Audits Business Analysis & Testing: Requirements Gathering, User Stories, Acceptance Criteria, Process Mapping, UAT Test Scripts, Test Execution, Defect Tracking, Change Requests, SOP Documentation, Stakeholder Communication Tools: Microsoft Excel, Pivot Tables, VLOOKUP, XLOOKUP, Power Query, SQL, Jira, Confluence, SharePoint, Microsoft Office PROFESSIONAL EXPERIENCE

PROFESSIONAL EXPERIENCE

Workday Business Systems Analyst Jun 2025 - Present New York State Office of Information Technology Services Albany, NY

• Gathered Workday HCM and HRIS requirements from HR operations, IT teams, and agency users through Jira and Confluence, reducing sprint clarification by 22% for employee workflow changes.

• Assessed hire, job change, termination, time tracking, and absence workflows against approval rules and acceptance criteria, helping HR teams validate Workday business process behavior before release.

• Built EIB-style CSV reconciliation templates for worker data, cost centers, job profiles, and payroll exceptions, supporting review of 420+ HRIS records across validation cycles.

• Defined Workday reporting requirements for headcount, employee status, pending approvals, benefits eligibility, and compensation changes, improving HR dashboard validation and exception reporting for operations review.

• Validated employee self-service updates, worker profile changes, approval routing, and eligibility checks through 32 UAT scenarios, improving functional readiness before production deployment.

• Coordinated Jira defect triage with product owners, QA analysts, developers, and HR users, helping retest fixes and close Workday workflow issues before release sign-off.

• Reviewed field mappings, validation rules, CSV errors, and data reconciliation results with technical teams, reducing the risk of incorrect HRIS updates reaching downstream reporting.

• Maintained Confluence SOPs, SharePoint approvals, role-based security notes, report scheduling checks, and UAT evidence, improving traceability from Workday requirements to tested system updates. HRIS Analyst Intern Feb 2025 - Jun 2025

New York State Office of Information Technology Services Albany, NY

• Captured Workday reporting needs from HR operations, IT, and agency users, turning onboarding and service intake requirements into sprint-ready user stories for dashboard delivery.

• Drafted Workday Report Writer layouts for employee status, pending approvals, onboarding progress, and benefits eligibility, giving HR teams 9 standardized fields for reporting review.

• Documented calculated field logic, prompts, filters, and report testing steps in Confluence, helping QA analysts and business users validate reports with fewer follow-up questions.

• Reconciled 165+ HRIS records across worker data, job profiles, cost centers, and missing values using Excel validation rules to improve Workday reporting accuracy.

• Logged Jira defects with screenshots, test results, and stakeholder comments for reporting issues, shortening Workday report follow-up turnaround by 1 business day during sprint testing.

• Supported report output validation for approvals, employee record updates, eligibility checks, and dashboard results, helping teams confirm Workday-aligned reporting before release. HR Systems Intern Aug 2024 - Feb 2025

University at Albany Albany, NY

• Streamlined student support and staff request workflows by documenting intake forms, approval steps, status changes, and ownership rules, reducing manual coordination effort by 18%.

• Designed Excel trackers with Pivot Tables, XLOOKUP, and Power Query to monitor request status, issue categories, follow-up owners, and completion dates for daily operations review.

• Audited 135+ support records for missing fields, duplicate entries, outdated statuses, and incomplete request details, improving data quality before staff reporting cycles.

• Converted staff feedback into current-state and future-state process notes for intake routing, approvals, service ownership, and reporting needs, helping technical teams plan clearer system updates.

• Tested form submissions, required fields, search results, status changes, and dashboard views through 16 workflow validation scenarios, improving release readiness for internal enhancements.

• Consolidated submitted requests, open items, completion timelines, and follow-up gaps using Excel and Power Query, reducing weekly reporting preparation time by nearly 3 hours. PROJECTS

Workday HCM, Payroll & Benefits Operations Support Project

• Built a Workday HCM transaction reference model for hire, job change, termination, open enrollment, and life event workflows, linking worker data, supervisory organizations, job profiles, cost centers, and approval routing.

• Created payroll and benefits audit templates in Excel using XLOOKUP, Pivot Tables, and data validation to review earnings, deductions, enrollment status, pay changes, and missing worker fields across 180 sample records.

• Prepared functional notes for ESS, MSS, eligibility checks, compensation updates, and exception handling, giving HR users a clear review guide for transaction accuracy and audit readiness. Workday Reporting, People Analytics & Workforce Dashboard Project

• Developed a Workday reporting catalog for headcount, turnover, approvals, benefits, payroll exceptions, and compensation using custom fields, prompts, filters, calculated fields, and report scheduling.

• Applied SQL and Excel validation checks to compare HRIS source data with report outputs, flagging duplicate worker IDs, inactive cost centers, invalid employee statuses, and missing department values before review.

• Structured workforce dashboard requirements for HR operations and people analytics users, defining 11 KPI views that improved visibility into employee movement, approval aging, and eligibility trends. Workday Integration, Payroll Cost Allocation & Reconciliation Project

• Designed EIB-style inbound and outbound file layouts using CSV structures, field mapping rules, required value checks, and error log notes to support HR, payroll, benefits, and finance data exchange review.

• Built SQL and Excel reconciliation checks to compare source files, transformed records, and outbound totals, helping identify rejected rows, duplicate values, missing fields, and payroll cost allocation mismatches.

• Documented integration testing steps for file validation, SFTP handoff review, payroll cost allocation, exception tracking, and stakeholder sign-off, improving traceability across Workday data and reconciliation workflows. EDUCATION

Master of Science in Computer Science Aug 2023 - May 2025 University at Albany Albany, NY

Bachelor of Technology in Electronics and Computer Engineering Aug 2019 - Jun 2023 Sreenidhi Institute of Science and Technology Hyderabad, India CERTIFICATIONS

• Workday Essential Training - LinkedIn Learning

• Human Resources Foundations - LinkedIn Learning

• HR as a Business Partner - LinkedIn Learning

• Excel Essential Training - LinkedIn Learning

• Google Data Analytics Professional Certificate - Coursera

• Business Analysis & Process Management - Coursera

Contact this candidate