Sql Server Human Resources

Judy Bloom *********@***.*** 620-***-****

www.jlbloom.com

Apr 2011 Heald College, LLC /Corinthian College Inc San

Francisco, CA Special Projects

. Development of special needs compensation database. Ad hoc reporting

as needed. Conversion projects, concerns and issues as they arise.

. Working with all departments to develop, support, administer, and

maintain SQL Server 2005, MS Access, Impromptu/Cognos Report Writer,

FTP protocols and scripting, data extraction, data modeling, ETL, ad

hoc reporting and electronic report distribution.

Oct 2009 - Apr 2011 Heald College, LLC San Francisco, CA

Corporate Director of Employee Services

. Plan and manage the overall design, implementation, communication, and

administration of benefits programs ( 401K, Medical, Dental, Vision,

etc). Ensure that the programs adhere to current regulations and

support the organization's strategic objectives.

. Job/Salary administration of policies and procedures - job codes,

salary ranges, performance evaluations, annual merit and promotions.

. Manage and directs payroll, and benefits staff for 2500+ employees at

multiple locations within the U.S. within compliance with federal and

state guidelines.

. Manage development, data integrity, and security for the UltiPro HRIS

system.

. Functional lead in accounting reconciliation - GL, 401K, payroll

transfers, and benefits.

. Heald Project Lead for Payroll and Benefits during conversion to

Corinthian College PeopleSoft systems.

Oct 2008 - Oct 2009 Heald College LLC San Francisco, CA

HRIS/Payroll Manager

. Manage and directs payroll, staff for 1500 + employees at multiple

locations within the U.S. within compliance with federal and state

guidelines.

. Manage development, data integrity, and security for the UltiPro HRIS

system.

. Functional lead in accounting reconciliation - GL, 401K, payroll

transfers, and benefits.

. Project Lead and trainer in all HR/Payroll/Benefits implementations -

Legiant Time and Attendance, Benefit carriers, Compensation, new

divisions.

. Maintain support and enhance UltiPro HRIS in all phases - HR/Payroll,

benefits, worker's compensation, recruitment, compensation,

performance approval, ESS, MSS and web access.

Oct 2008 - Oct 2009 Heald College LLC San Francisco, CA

HRIS Analyst

. Manage development, data integrity, and security for the UltiPro HRIS

system.

. Project lead and technical lead for Online Benefits web development

and subsequent online enrollment. End-to end implementation, all

benefits functions brought in house and retired all third party

administrators, to include change management, training and support.

. Maintain support and enhance UltiPro HRIS in all phases - HR/Payroll,

benefits, worker's compensation, recruitment, compensation,

performance approval, ESS, MSS and web access.

. Working with all departments to develop, support, administer, and

maintain SQL Server 2005, MS Access, Impromptu/Cognos Report Writer,

FTP protocols and scripting, data extraction, data modeling, ETL, ad

hoc reporting and electronic report distribution.

2006 - 2008 Toshiba America Medical Systems Tustin, CA

Senior HRIS Analyst/Programmer/DBA

. Project Lead in all HR/Payroll implementations - KRONOS, Virtual Edge,

Benefit Vendors, Compensation, new divisions.

. Maintain support and enhance HRIS in all phases - HR/Payroll,

benefits, worker's compensation, recruitment, compensation,

performance evaluation, web access.

. Working with all departments to develop, support, administer, and

maintain SQL Server 2000, SQL Server 2005, MSAccess, Impromptu/Cognos

Administrator - Report Writer, FTP protocols and scripting, data

extraction, data modeling, ETL, ad hoc reporting and electronic report

distribution for all areas.

2005 - 2007 First Medical Management Long Beach, CA

Application Systems Analyst/Programmer

. Project lead for HR/Payroll implementation of UltiPro.

. Established benefits web enrollment. Working with third-party vendors

to develop and maintain weekly benefit file.

. Working with all departments to develop, support, administer, and

maintain SQL Server 2000, VBA, ADO, ODBC, Access, Crystal Reports,

ODBC, Access, Impromptu/Cognos Administrator - Report Writer, Affinity

for systems integration, data extraction, data modeling, ETL, ad hoc

reporting and electronic report distribution for all areas.

2001 - 2005 Casa Grande Regional Medical Center Casa Grande, AZ

Programmer/ HR Analyst

. Develop, support, administer, and maintains SQL Server 2000, VBA, ADO,

ODBC, MSAccess, Crystal Reports, HL-7 Interface, 400 SQL, AS400,

Siemens MedSeries 4 and KRONOS for systems integration, data

extraction, data modeling, ETL, ad hoc reporting and electronic report

distribution for human resources, finance, health information

management, materials, and clinical areas.

. Develop, support, administer, and maintain a HRIS in compliance with

JACHO and employment standards. Maintain AS400 interfaces for

payroll/Personnel/HRIS from Siemens MedSeries4 System.

1998 - 2001 Hunter Douglas Wood Products, Inc. Casa Grande, AZ

MIS Manager/Systems Administrator

. Senior IT Project Lead SAP implementation.

. Participate in end-to end SAP implementation, change management,

training and support.

. Document business requirements and work with business partners on

appropriate design decisions.

. Responsible for all IS/IT issues for multiple facilities.

. Develop, support, administer and maintain MSAccess databases for all

phases of business- marketing, warehouse management, inventory

control, barcoding, planning and reporting functionality.

. Developed interface between SAP on Unix/Informix platform, with

MSAccess frontend on Windows 98.

. Establish and maintain IS/IT budget for fiscal year.

1995 - 1998 Treffers Precision, Inc./Praxair Phoenix, AZ

Cost Analyst/MIS Analyst

. Pricing, estimating and quoting the repair of aerospace parts.

. Assist sales, marketing, accounting, FAA and manufacturing as

required.

. Internal auditor - ISO9000 standard.

. Developed, supported, administered and maintained MSAccess databases

for business.

Education

Pre-Certification SPHR Prep Boston, MA 2011

San Francisco State University San Francisco, CA 2009-2010

Human Resources Certification

Ultimate Software USA 2005 - present

Kronos Irvine, CA 2005-2007

SQL Server 2000 Phoenix, AZ 2002

SAP-AMERICA USA 1998-1999

Contact this candidate