CONSULTANT PROFILE

UltiPro Cognos BI / Reports Developer

Profile

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.

Skills

UltiPro Core HCM

Talent Acquisition

Cognos

Onboarding

Excel

File Feeds

Payroll

Life Events

Audit

Report Studio

Open Enrollment

Events Studio

Accounting

Compliance

LOA

UTM

Payroll

Benefits

Professional Experience

ROCKCREST HRIS Consultants

2019

Present

-

UltiPro Cognos BI / Reports Developer (Remote)

CleanSlate Centers

2017

2019

-

UltiPro Manager / Reports Developer

Behavioral Health Network, Inc.,

2010

2017

-

Payroll Manager

More career information available upon request.

Education, Certifications & Training

Northeastern University, Boston, MA, 2001

Bachelor's Degree, Business Administration, Accounting (GPA: 3.73)

Golden Key Honor’s Society Member

Additional information

Please complete the below form to request a full resume, schedule a phone screen or to speak to one of our recruiters about this consultant. Our consultants are usually available for phone screen within 24-48 hours and can start an assignment within 1-4 weeks. 

Consultant Ref:

991

Work Status:

US Citizen

City:

Jacksonville

State:

Florida

Availability:

Immediate

Ability to travel:

No

Ability to relocate:

No

Talk to one of our recruiters to learn more about this consultant.
Step 1 / 2
Your contact information.