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.
Consultant Ref:
226
Work Status:
US Citizen
City:
Irvine
State:
California
Availability:
Immediate
Ability to travel:
Yes
Ability to relocate:
No
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.