Summary
Overview
Work History
Education
Skills
Personal Information
References
Timeline
AdministrativeAssistant
Celeste Williams

Celeste Williams

East London

Summary

As a seasoned HR Data Analyst with a deep understanding of Human Resources and a proven track record in harnessing the power of data, that can bring a unique blend of expertise in HRIS systems, SQL, and Microsoft Power BI to drive data-driven decision-making and enhance organizational effectiveness.
A career journey that has been marked by a commitment to HR excellence and a focus on optimizing data to inform strategic HR decisions. Having successfully navigated complex HRIS landscapes, including SAP HR and Workday, streamlining data extraction, reporting, and analytics processes to provide valuable insights into workforce trends and performance metrics. Conscientious and compassionate Human Resources professional with drive for helping employers recruit, develop and retain qualified candidates. Skilled at partnering with management teams to build employee-centric cultures promoting positive morale and optimizing productivity. Motivating and positive with excellent interpersonal, coaching and communication skills. Accomplished Human Resources Consultant with hands-on HR management experience and broad knowledge of HR metrics for benchmarking, measuring, analyzing and articulating value and ROI of HR initiatives, practices and policies. Guides, trains and supports clients in areas of strategic human capital management, employment law compliance, employee relations, organizational development, workers' compensation administration and overall development of best practices in human resources. Demonstrates strong business acumen and possesses entrepreneurial spirit with genuine desire to proactively and consistently deliver results for clients and internal teams.

Overview

18
18
years of professional experience

Work History

HR Consultant (Consultant/Contract)

Khulani Managed Solutions Pty Ltd
01.2021 - Current
  • HR Data Analyst
  • Collects and compiles HR metrics and data from variety of sources including Human Resource Information System (HRIS) and payroll outputs, management and employee surveys, exit interviews, employment records, government labor statistics, competitors’ practices, and other sources.
  • Create visually compelling and interactive dashboards using Microsoft Power BI to communicate HR metrics and trends to key stakeholders.
  • Analyzes data and statistics for trends and patterns with attention to recruitment, hiring practices, motivation, turnover, and compliance with employment laws and regulations.
  • Based on metrics and analysis, makes recommendations for policies and activities to improve organizational culture including suggestions to attract and hire qualified candidates, to motivate and retain employees, to address staffing issues, and to maintain legal compliance.
  • Ensures compliance with data privacy regulations and best practices.
  • Payroll Management
  • Full-cycle processing of monthly payroll for group of companies including salaries, leave, benefits, provident fund, taxes, and other deductions.
  • Preparation and submission of statutory documents: EMP201/ SARS payment documents, etc.
  • Providing support during external audits for Compliance requirements.
  • Staying up to date with legislative changes: taxation, minimum wages, etc.
  • Facilitating and application of WSP Submissions.
  • Assisted and guided clients on HR procedures and program development by devising performance evaluations, job descriptions and industry-standard salary ranges
  • Facilitated onboarding sessions and on-the-job training for new hires bolstering position knowledge and skillset
  • Partnered with senior leadership to establish and develop corporate and HR policies and procedures
  • Facilitated successful policy implementation and enforcement to maintain legal and operational compliance
  • Created and implemented forward-thinking initiatives to improve employee engagement
  • Collaborated with managers to identify and address employee relations issues
  • Improved organizational filing systems for confidential employee records, resulting in improved accessibility and efficiency
  • Collected and analyzed information to monitor compliance outcomes and identify and address trends of non-compliant behavior

HR Information Management Consultant

Absa Bank
04.2009 - 12.2020
  • Collects and compiles HR metrics and data from variety of sources including Human Resource information system (HRIS) and payroll outputs, management, and employee surveys, exit interviews, employment records, government labor statistics, competitors’ practices, and other sources.
  • Leverage SAP HR and Workday systems to retrieve and consolidate HR data for reporting and analysis.
  • Collaborate with HR business partners to define data requirements and develop customized reports and dashboards to support HR initiatives.
  • Analyzes data and statistics for trends and patterns with attention to recruitment, hiring practices, motivation, turnover, and compliance with employment laws and regulations.
  • Based on metrics and analysis, makes recommendations for policies and activities to improve organizational culture including suggestions to attract and hire qualified candidates, to motivate and retain employees, to address staffing issues, and to maintain legal compliance.
  • Provide customized research reports, highlighting main findings and key points, and effectively.
  • Convert data extracts into relevant reports and data sets as required. This includes compiling management information (MI) and any other ad-hoc queries while adhering to agreed deadlines.
  • Adhere to core Data Governance disciplines as defined by DGO (Data Governance Organization) when performing business intelligence activities within SBU (business unit). This includes data quality management, information lifecycle management and information security and privacy.
  • Conduct integrity checks on all extracted data to ensure correct data is incorporated into reports.
  • Managed multiple deadlines across several businesses to meet dynamic needs of multiple clients.
  • Analyzed problematic areas to provide recommendations and solutions.
  • Created and developed detailed work plans to meet business priorities and deadlines.
  • Overseeing HR data of substantial workforce exceeding 40,000 employees. My responsibilities encompassed managing significant portion of this staff's HR information to ensure accurate reporting statistics. Additionally, I spearheaded data quality checks, ensuring reliability and precision of our data sets for strategic decision-making

Payroll Administrator

Giant Payroll Group LTD (UK)
01.2008 - 01.2009
  • Managing three executive payroll clients consisting of +- 15000 clients (staff members)
  • Administer and check payroll is successfully processed on daily basis
  • Monitor daily advances and process before SLA
  • Checking timesheets on daily basis
  • Send timesheet DX files to IT for generating and exporting to payroll system
  • Communicate with client regarding queries and resolve in required SLA
  • Issue weekly and monthly payslips, invoices, and credit notes
  • Liaise with HMRC (tax revenue) regarding tax rebates, statements of earnings and tax code changes
  • Process National Insurance exemptions for over contractors over age of 60
  • (When reaching certain age, no longer have to pay national insurance)
  • Process CSA orders (child support agency) in time for pay run and also AOE (attachment order of earnings) to be deducted from contractors pay on request from council
  • Check end of day new starters and leavers list, update payroll system for next day.
  • Performed calculations in overtime, vacation, and sick hours to provide accurate data to payroll processing database.
  • Uploaded time records into computer system and made adjustments to create accurate database for payroll processing functions.
  • Verified and submitted timekeeping information for accurate and efficient payroll processing.
  • Calculated payroll deductions by accurately using ADP Payroll and processed payroll to meet preset requirements.
  • Submitted reports on payroll activities.

Payroll Administrator

Mott Macdonald LTD (UK)
04.2008 - 09.2008
  • Handle daily payroll queries
  • Enter payroll data on ADP system
  • Enter starters and leavers on ADP payroll system
  • Filing, faxing and drafting letters to Inland Revenue
  • Completing P45, P46, P85 for Inland Revenue
  • Process end of month Payslips and distribution
  • Liaise on phone and face to face with staff members
  • Liaise with various investment managers
  • Liaise with HR and Pensions department
  • Run reports on payroll system and exporting to Excel files for distribution to various departments for assessment.
  • Performed calculations in overtime, vacation, and sick hours to provide accurate data to payroll processing database.
  • Uploaded time records into computer system and made adjustments to create accurate database for payroll processing functions.
  • Submitted reports on payroll activities.
  • Verified and submitted timekeeping information for accurate and efficient payroll processing.
  • Calculated payroll deductions by accurately using Lawson Payroll System and processed payroll to meet preset requirements.

Payroll Clerk

Absa Bank LTD
01.2006 - 01.2008
  • Utilize SAP payroll system to process payroll transactions accurately and efficiently for staff count of +-40000.
  • Maintain employee payroll records and ensure data integrity.
  • Calculate wages, overtime, and deductions based on hours worked and statutory requirements.
  • Process and verify employee time and attendance records.
  • Respond to employee inquiries regarding payroll-related matters.
  • Collaborate with HR and finance departments to ensure accurate and timely payroll processing.
  • Generate payroll reports and assist in audits as necessary.
  • Stay updated with changes in payroll regulations and laws to ensure compliance.
  • Performed calculations in overtime, vacation, and sick hours to provide accurate data to payroll processing database.
  • Uploaded time records into computer system and made adjustments to create accurate database for payroll processing functions.
  • Submitted reports on payroll activities.
  • Verified and submitted timekeeping information for accurate and efficient payroll processing.
  • Calculated payroll deductions by accurately using SAP HR and processed payroll to meet preset requirements.
  • Processed new hire paperwork and documents.
  • Updated employee files with new details such as changes in address or salary levels.

Education

Certificate in Career Boost With Power BI - Analytics

Exodus Experts
Online
10.2023

Certificate in Introduction To Data Analytics - Analytics

Simplilearn Skillup
Online
10.2023

High School Diploma -

Princeton Senior Secondary High School
Cape Town
12.2002

Skills

  • HR Data Reporting
  • SAP HR
  • Microsoft Power BI
  • Employee Relations
  • Payroll Management
  • Workday
  • Pay Space Payroll
  • QuickBooks
  • SQL

Personal Information

  • Notice Period: 2 Weeks
  • Gender: Female
  • Nationality: South African
  • Driving License: Yes

References

  • Edwina Tyesi, Khulani Management Solutions, Director, edwina@khulanims.co.za
  • Mirie Van Wyk, ABSA BANK LTD, HRMI Manager, mirievw@absa.co.za
  • Wendy Klein, HDMI Investments, Director, wendy@hdmi-invest.co.za

Timeline

HR Consultant (Consultant/Contract)

Khulani Managed Solutions Pty Ltd
01.2021 - Current

HR Information Management Consultant

Absa Bank
04.2009 - 12.2020

Payroll Administrator

Mott Macdonald LTD (UK)
04.2008 - 09.2008

Payroll Administrator

Giant Payroll Group LTD (UK)
01.2008 - 01.2009

Payroll Clerk

Absa Bank LTD
01.2006 - 01.2008

Certificate in Career Boost With Power BI - Analytics

Exodus Experts

Certificate in Introduction To Data Analytics - Analytics

Simplilearn Skillup

High School Diploma -

Princeton Senior Secondary High School
Celeste Williams