Luke Hill Email & Phone Number

Accomplished senior analyst and systems managerTrusted business partner and advisor at all levels from execs to the frontline, possessing a thorough generalist understanding and appreciation of the wider operational HR landscape having practiced in international businessesSystems and technology enthusiast, prolific problem solver, process improver and creator of practical technical solutionsPassionate about data, analytics and BI applications, particularly MS Excel, Power BI and Power QuerySuperuser of all MS Office applications-- KNOWLEDGE & EXPERIENCE --EXCEL -- POWER BI -- POWER QUERY:Demonstrable understanding of advanced conceptsDetailed knowledge of keyboard shortcuts / sequencesComplex formulas and nesting in various languages: Excel, DAX, Power Query (M), VBA/macrosError detection and resolutionPivotTables incl. Calculated Fields & Items; SlicersTables; Charts; PivotChartsDashboard designForm creation using Developer toolsBuilding and executing macrosData ValidationNamed RangesConditional FormattingSheet & Workbook ProtectionMicrosoft Query and PowerPivotSUPERUSER OF HRIS & BI SYSTEMS:Analytics: Power BI, Power Query, SAP Business Objects; QlikviewHR/Payroll: CHRIS21 [Frontier]; iQ [Cintra]; PyramidHReLearning: Learn [Kallidus]; LearnForce [Kineo/e3]; LearnDash [Wordpress]Recruitment/ATS: eArcu; iGrasp [Lumesse]Content: MS SharePointAppraisal: Perform [Kallidus]TECHNICAL PROCESS:Data & MI: service delivery; innovation; qualityPay Review & Bonus: admin leadership [data templates; verification & approval; financial/cost analysis]Proficiency dealing with multiple currencies and complex conversion calculationsOrg. design strategy: delivery support; ownership of technical mechanisms [data, MI, charting]eLearning authoring [Articulate Storyline]Policy / procedure writing & revisionOPERATIONAL PROCESS:Day-to-day management of HR dept.ER adviceGeneral admin (letters, contracts, exit interview, onboarding, induction)End-to-end recruitmentPayroll (calculation & support)Employee survey administration

Listed skills include Employee Relations, Recruiting, Employee Training, Project Management, and 52 others.