CONSULTANT PROFILE

UltiPro Data Migration & Integrations Consultant

Profile
  • Strong Data Migration, Integrations & Conversion Consulting experience.

  • Business Analysis for finance and payroll systems. 

  • MS Access VBA Automation. 

  • Excel/VBA Automation. Kronos Implementation Support. 

  • UltiPro Back-Office TSQL. 

  • Data Analysis and Archiving. 

  • SQL Architecture/ETL. 

  • Success Factors/Knowledge Spot app support. 

  • Workday to UltiPro ETL file comparison. 

  • Informatica ETL workflows for financial data.


Recent project experience includes:


Client 1) 

  • Ultimate Software to Workday migration. 

  • Troubleshooting custom data migration tools into UltiPro onboarding wizard from Kenexa Brass Ring. 

  • Built data structures to archive Brass Ring into SQL Server and wrote custom queries for Recruiting, Payroll, and HR.  

  • Administered Success Factors/Knowledge Spot. 

  • Created Oracle SQL for HR Benefits extraction.  

  • Custom reports from UltiPro SQL Server back end for wages, checks, archiving data and legal documents.


Client 2)

  • ADP to UltiPro migration.

  • SQL upgrades for 40 MS Access applications to SQL 2008, 2012 DTS/SSIS/SSRS packages. Created Informatica Workflows for employee/contractor import into Coupa software.  

  • Kronos Workforce 6.1 and Teletime database administration. 

  • Administered MS Access applications related to time and attendance tracking. 

  • Wrote Transact SQL queries to provide evidence of SOX compliance for Auditors.  

  • Managed claims applications for Salvage, Total Loss, SIU, and Legal Tracking MS Access applications. 

  • Automated advertising leads and Actuary data warehouse data load.


Client 3)

  • Architected data cleansing reporting data mart. 

  • Architected cleansing feedback reports to 30 divisions using MS Access VBA automation. Automated Informatica ETL for GL Labor Ledger migration from UC Path to UCI Medical Center. Automated data extraction from DB2. 

  • Analyzed and automated generation of Health Sciences Compensation plan using VBA from MS Access to Excel.

Skills

UltiPro

VBA

ADP

Access

Kronos

Excel

PoepleSoft

TSQL

ETL

DB2

SQL

SQL Server

Oracle Database

SSIS

SSRS

DTS

C++

C#

Professional Experience

University

2018

Present

-

HRIS Data Conversion Consultant

Financial Services Company

2016

2018

-

HRIS Migration Consultant

Insurance Company

2005

2016

-

HRIS Systems Analyst

More career information available upon request.

Education, Certifications & Training

Western Governors University

Bachelor of Science degree program / Information Technology


California State University, Long Beach

Bachelor of Science degree program / Computer Science


Los Angeles Harbor College, Wilmington,  CA

Associate of Arts Degree, Liberal Arts

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:

226

Work Status:

US Citizen

City:

Irvine

State:

California

Availability:

Immediate

Ability to travel:

Yes

Ability to relocate:

No

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