Caroline Dyens

- Self-trained on UKG Dimensions > watched demos, went through process guides, connected with the business and technical teams – grew up to speed to facilitate successful training sessions - Prepared training materials > designed PowerPoint presentations, prepared test profiles – delivered dedicated support documentation - Led training sessions for France employees, managers and time administrators > managed demos, supported specific needs – allowed final users to be familiar with the system and be ready for its daily use on implementation day - Carried out an analysis of pay codes and time off in UKG Dimensions > classified values, described input processes, provided recommendations and best practices, prepared a support documentation for final users – delivered the analysis for use as part of the post Go Live system corrections and adjustments with the technical team

- Designed Power BI multipage reports to visualize locations, activities, logistics and financial flows > consolidated 4+ million data rows from 20+ Excel sources, performed multiple thorough analyses – delivered a holistic performance diagnosis - Set up a performance improvement plan > facilitated 9 work sessions with 20 managers, reviewed business rules and processes, identified and described 6 improvement projects, optimized 2 main divisions within the business unit, participated in the prioritization process to build a performance improvement portfolio – simplified the business unit footprint, proposed more efficient logistics solutions - Coached an intern student > provided training, coaching and support in Excel, Power BI, and data analysis – confidently handed over the use and maintenance of the Power BI reports to the intern student at the end of my assignment

- Developed and rolled out Data Governance across key businesses (bills of materials, raw materials, customers, finished goods) > reviewed and adjusted the Data Governance methodology, created a template catalog, built an automated plan tracker – provided a framework and tools for Data Governance implementation - Managed projects and supervised delivery in Agile > acted as a Product Owner and Delivery Manager, managed a team of 3 to 6 members, planned sprints and PIs, supervised activities, ensured on-time delivery – delivered all Data Governance deliverables, cleansed data in scope, implemented data quality at the source

- Improved the process of report promotion to production > ran an audit, qualified processes, designed and implemented a SharePoint-based tracking solution – eliminated double development, reduced the process from several days to a few hours - Implemented the gatekeeper process > created an activity tracker, organized weekly meetings to review and approve each new report – reassured the steering team in preparation for audits, reduced the number of new reports, saved time, improved development productivity - Controlled and monitored custom reports > implemented an Excel solution to identify duplicates and obsolete reports, enhanced the existing – cleared the database, optimized the user experience - Defined best practices > determined naming conventions and report definitions structures and contents – offered a consistent and standard system environment, simplified maintenance and audit

- Managed data migration activities from Oracle HRMS to Workday HCM > managed remotely 40+ local data stewards across as many countries, assigned tasks via an automated SharePoint follow-up process, tracked deadlines, partnered with HR IT project teams in Pittsburgh headquarters – met synchronization expectations and delivery deadlines - Collected data, automated data control, transformed data > identified and analyzed data scope, collected data by country and data type within an iterative control process, secured and verified data via Excel – assured data quality and reliability (data accuracy over 95% of scope at Go Live)

- Implemented Oracle HRMS in EMEA > acted as an interface between the technical team and Human Resources, tracked deadlines and deliverables, organized and led progress meetings, supported countries in the selection of payroll system, trained users – ensured teams were operational at Go Live, transferred the Single Source of Truth of data from local systems to ERP - Developed Excel and InfoPath multilingual Smart Forms > collected processes, centralized lists of values management on SharePoint for easier use and maintenance, automated forms with functions/formulas rather than macros, processed testing – assured data quality, optimized and rationalized processes, allowed for automated data upload into Oracle HRMS via WebADI - Contributed to the validation of business process design > reviewed and adjusted all HR processes – delivered the global standardization of HR processes and the definition of specifications for workflows development in Workday and ServiceNow - Increased data quality and accuracy • rewarded with a PPG Human Resources Award in 2011 > audited data and identified recurring inaccuracies, developed a recurring reporting process, organized and led bimonthly status meetings with Data Owners, supported and trained Data Owners in their data cleansing, tracked corrections – cleansed data on the long term, reduced the number of inaccuracies from 30% to less than 1% (of data volume) - Shaped data structure, developed KPIs, analytics, reporting, dashboards and visualization > ran on-demand data analyses, developed and fed periodic KPIs, created data visualization – highlighted trends, managed costs, supported budgeting - Led acquisitions system integration > collected, validated and converted data, trained users – met data delivery deadlines and data quality requirements - Provided technical and functional support, trained end-users on Oracle HRMS & Discoverer

- Consulting > developed automations and interfaces - Coaching > coached HR data analysts and executive assistants - Training > Excel & VBA, SharePoint, Outlook, InfoPath

- Controlled and analyzed project methodology - Developed Excel VBA tools for automated tracking of project tasks and activities - Administered SharePoint sites and e-learning documentation - Led training sessions on Cognos reporting