Quality Assurance Sql Server
Resume:
Derek Wilson
PO Box ***
Somerset, MA *****
*****.******@***************.***
EXPERIENCE:
Aug 2000 - Independent Ceridian Consultant
Present - Certified as a Ceridian Implementation Consultant
- Expert knowledge of HPL/Source 500 including system setup, customization, security, and reporting
- Expert knowledge of Ceridian’s mainframe and payroll processing procedures
- Expert knowledge of SQL Server including all aspects of development, programming, and analysis
Sample of Current/Former Clients:
Citizens Financial Group
- Completed initial conversion from legacy Ceridian HR/Payroll product to Source 550 including system
setup, custom security requirements, set up of company level benefit plans, development of interfaces
to third party vendors, and all employee level data imports for 6,500 Active employees and over 13,000
Terminated employees
- Completed multiple conversions of acquired banks as employee base grew from 6,500 to over 35,000
Active employees
- Performed modifications to several standard screens within Source 550 including Training,
Performance Review, Skills, and Certification screens (as well as many Core employee data screens)
using Ceridian’s standard tools
- Developed several new custom screens and made modifications to several standard screens (including
the Employee Profile) using backdoor tools to meet the client’s detailed requirements
- Modified a standard employee-level screen to store company-level data using backdoor tools
- Developed custom PTO module in Source 550 including a feed to/from Time and Attendance system
- Developed multiple triggers in SQL Server to automatically pass data between tables in order to
simplify the data entry process
Louis Dreyfus
- Completed initial conversion from a variety of separate data sources to Ceridian HPL including
conversions for international employees and non-paid personnel
- Converted complex company and employee level Position Control data in Union environment
- Developed tool that allowed client to process bonus payments as live checks through a standard payroll
batch for employees with EFT’s
- Developed tool to allow retro paycheck calculations based on annual compensation adjustments
- Assisted with the analysis of security requirements and implementation of security design including
creating users/groups/roles and developing screen, row, and column level security
- Developed complex reports using Ceridian’s reporting tools and SQL query scripts to meet client’s
need for time critical reports
Regeneron Pharmaceuticals, Inc.
- Completed initial conversion from SAP to Ceridian HPL for pharmaceutical company including the
development of an automated tool used to audit converted data
- Assisted in development of interactive web-based organization chart
- Developed custom health and wellness screen including custom interface to third party system
- Enhanced custom triggers developed by Ceridian to provide more efficient/accurate movement of
employee data
- Set up custom batch configurations along with data import templates to allow for more efficient entry
of weekly pay data
Aug 1998 - Sarla Software - Seekonk, Massachusetts
Jul 2000 Implementation Manager
- Managed a national team of software engineers responsible for HRIS conversions from
DOS/mainframe platforms to client/server systems including all aspects of configuration,
customizations, interfaces, and reporting
- Responsible for sales and analysis of new projects including pricing estimates and conversion
specifications and documentation
- Developed comprehensive training program for new engineers and advanced training for seasoned
engineers
Dec 1995 - Fleet Financial Group: Business Consulting Division - Johnston, Rhode Island
Jul 1998 Database Administrator / Quality Assurance Analyst
- Developed a variety of relational databases used to capture customer problem experiences
- Performed statistical analysis of corporate databases to identify efficiency opportunities
- Y2K Project Coordinator
- Developed Disaster Recovery plan
_________________________________________________________________________________________
EDUCATION:
1995 - 1999 Bryant University, Smithfield, Rhode Island
MBA Computer Information Systems
1986 - 1990 Cedarville University, Cedarville, Ohio
B.A. Business Administration
_________________________________________________________________________________________
REFERENCES: Client and Ceridian references available upon request
__________________________________________________________________________________
Contact this candidate