UKG & IBM Cognos Solutions Architect

Phil Nguyen

UKG Solutions Architect IBM Cognos BI Developer Workflow Automation Engineer

Irvine, CA • 714-***-**** • ***********@*****.*** PROFESSIONAL SUMMARY

Techno-functional UKG subject-matter expert with 10+ years of hands-on experience. Deep specialization in IBM Cognos BI report development, dashboarding, and alert design. Delivers across the full implementation lifecycle, from project scoping, configuration, and data migration through go-live, production support, and optimization. A trusted advisor who translates complex business requirements into scalable, user-friendly solutions that help leaders focus on actionable data. CORE SKILLS

UKG Pro: Core HCM, Payroll, Benefits, Recruiting, Onboarding, Performance, Compensation, Learning, Position Automation, People Assist, Document Manager, Platform Configuration, Role Security, Back Office IBM Cognos BI: Report Studio, Query Studio, Event Studio, Framework Manager, Custom SQL, Reports as a Service (RaaS) API, SFTP Report Exports

UKG Time: WFM Dimensions, UltiPro Time Management (UTM), UltiPro Time and Attendance (UTA) Analytics & Visualization: Tableau, Microsoft Power BI, Google Looker, Chart.js, HTML / CSS Data & Automation: Microsoft SQL, Python (pandas), Power Query, Power Automate, VBA, REST & SOAP APIs, JSON / XML Platforms & Integrations: Workday, ADP, Rippling, Paycom, Ceridian Dayforce, Deel, Sprout.hr, GreytHR, PayAsia, Fidelity, PlanSource, Shareworks, NetSuite, Dynamics 365 Business Central, Expensify, Concur, Salesforce, Lattice PROFESSIONAL EXPERIENCE

UKG Post-Live Consultant Columbus Hospitality (via Robert Half) Columbus, OH Mar 2026 – Present

● Serve as UKG subject-matter expert on a post-go-live implementation, resolving issues across Core HCM, Cognos BI, NetSuite integration, and GL exports.

● Delivered immediate value by building attrition, benefits participation, overtime, and daily pay dashboards in Cognos BI.

● Developed a custom Cognos Framework Manager package joining the base administrator model with WFM data, unlocking daily hours and overtime reporting against pay-accrual planning for Accounting.

● Built a custom GL export in Cognos BI, joining pay history, GL, and Job tables with custom platform-configured fields, then integrated it with NetSuite via RaaS API and SFTP as a backup. UKG Implementation Consultant Complete Care Management Toms River, NJ Jun 2025 – Mar 2026

● Owned the reporting and data-transformation workstream for an enterprise ADP-to-UKG Pro migration spanning 90+ facilities and 14,000+ employees.

● Developed reports in both ADP and UKG to extract, map, and validate employee and payroll data throughout the migration.

● Built automated pipelines in Power Query and Power Automate that transformed ADP exports into UKG-ready import files, replacing manual data mapping and reformatting.

● Created custom Cognos BI reports across HR, Finance, Benefits, Payroll, and IT departments.

● Helped implement Freshservice and built Cognos Event Studio automations that detect UKG events, alert the right stakeholders, and trigger Freshservice to automatically create and route tickets to the correct department. UKG Consultant (Contract) ALKU Andover, MA Mar 2025 – Present (project-based)

● Serve on a recurring project basis as UKG subject-matter expert for ALKU's clients, delivering short-term configuration, automation, and self-service reporting engagements.

● Implemented job architecture for 10K+ employees and 15K+ job codes, including custom leveling, salary grades, and country-specific configurations.

● Launched UKG Position Automation to give clients greater visibility and control over open positions (“seats”) within the org structure.

● Deployed UKG WFM Shift Fill with custom Core integration to match nursing staff to shifts by skill and certification, with SMS alerts to admins, managers, and staff.

● Designed Cognos reports and manager dashboards supporting performance cycles to drive engagement and self- service adoption.

HRIS Manager BarkBox New York, NY Dec 2023 – Mar 2025

● Led UKG integrations with Lattice and Sprout.hr to streamline global performance and payroll operations.

● Built branded IBM Cognos reports and HTML email alerts (Event Studio) to improve data delivery and executive visibility.

● Implemented future-dated and retroactive job-change workflows in Manager Self-Service, backed by custom Cognos audit reports and alerts joining transaction and effective dates for accuracy and compliance.

● Positioned UKG Pro architecture for Workday migration by aligning configuration, cleansing data, and supporting transition planning.

HRIS Manager MISTRAS Group Princeton, NJ Feb 2022 – Dec 2023

● Drove an automation-first approach to improve data integrity and streamline workflows for leadership.

● Managed a team of HRIS specialists through training, support, and growth-focused development plans.

● Established internal controls for system access and data validation to meet SOC 1 and SOC 2 audit standards.

● Oversaw all core HRIS projects, including integrations, file feeds, and module implementations. HRIS Analyst o9 Solutions Dallas, TX Nov 2020 – Feb 2022

● Served as lead system and data administrator for UKG Pro.

● Created executive-facing People Analytics reports in IBM Cognos covering demographics, headcount growth, and attrition.

● Engineered API integrations between UKG and GreytHR to automate employee data sync across HR platforms.

● Implemented Recruiting, Onboarding, Performance, and Compensation modules in UKG. UKG System Consultant Mosaic Nashville, TN Jul 2019 – Nov 2020

● Led end-to-end UKG HRIS implementations, including scoping, data migration, and system configuration.

● Assessed current-state UKG setups and designed execution plans for future-state improvements.

● Authored client-facing SOPs to support ongoing system use and maintenance.

● Wrote SQL scripts for data cleansing, validation, and migration across HRIS environments. Business Intelligence Support Ultimate Software Santa Ana, CA Apr 2018 – May 2019

● Developed custom, billable IBM Cognos reports, dashboards, and packages for Ultimate Software clients.

● Diagnosed and resolved Report Studio errors across client reporting environments. Account Manager Ultimate Software Santa Ana, CA May 2016 – Apr 2018

● Managed post-sale relationships for 20+ enterprise accounts totaling $2M ARR.

● Maintained 90%+ customer satisfaction (CSAT) and a strong Net Promoter Score (NPS) quarterly. EDUCATION & CERTIFICATIONS

B.A. in Psychology, University of California, Santa Barbara Fundamental Payroll Certification (FPC), American Payroll Association

Contact this candidate