UltiPro Cognos BI / Reports Developer

Experienced in developing the following BI Cognos Reports:

Accounting

• Allocation Report

• Detailed Financial MTD, YTD Hours & Earnings Reports

• Employee Changes past 7 days (for A/P Updates)

• Payroll GL Recon Report (Detailed Ungrouped Segments)

• PTO Liability Report (with Allocations)

• Summary 401K Upload Format Reports

Compliance

• Required Medical Tests up to date

• Terminations in past 15 days

Conversion

• Detailed Accumulator Reports QTD & YTD Earnings, Deductions and Taxes.

• Job Code Creation Report (if changing for new system).

Human Resources

• Annual Benefits Analysis Census Reports (by Benefit Type)

• Communications Reports (Birthdays/Anniversaries/Promotions)

• Employee Engagement Updates (Vendor file)

• Employee Listings (Headcounts/Active/Term/by Job/Etc)

• Dependent Verification (Employees with dependents on group insurance)

• OIG Exclusion Report

• Open Enrollment Reports - Vendor Specific Templates

• Organization Chart Program Updates (Vendor file)

• Per Diem Employees reaching 1000 hrs and Eligible for 401k participation

• PTO Reports (Balances, year-end projections)

• Reconciliation Report for any Deduction to Vendor Bill

IT/IS

• 401K upload to Vendor files (before EDI files were in place)

• Active Directory Updates files (Scheduled)

• MS Outlook Updates for Group email members

• Power BI EE Data Upload Report

Maintenance/Audit

• Employee Self Service Entry Anomalies

• Manager Self Service Anomalies

• User Roles assignment errors

• UTM Access Group errors/time zone errors

Payroll

• Bureau of Labor Statistics – Monthly Report

• Earnings Reports – select by earnings code/date range/employee/dept

• Live Checks Report

• LOA Reports – Start/Expected end dates and PTO balance.

• Pre-Check Analysis Report – used to catch errors before posting payroll

• Special Qualifying Bonus Payroll upload Reports

• UTM reports (non-cognos) Missed Punches and Time Off requests reports.