Candidates About

 

Kevin R. Lewis

DATABASE ADMINISTRATOR

 

 

Skilled Database Administrator with a career working in Database and Human Resources Information Systems (HRIS) Administration.  My experience includes administration of Oracle 11g and Postgres, ADP, Ceridian, and PeopleSoft.  An accomplished career focused on communicating management level goals and regulations with employee level needs. Sustain a charismatic liaison with outside dignitaries with a strong focus on creating and building permanent business relationships.  In past 10 years alone, developed and implemented modifications to HRIS database that have enhanced both work and cost efficiency. In addition, I have acquired technical knowledge on several database platforms developing and modifying data structures.  

 

Database Administration (Oracle 11g) / Data Integrity / HRIS Testing / Project Management / Section 125 / Team Leadership / On-Boarding / Training Planning / Employee Relations / HRIS Strategic Planning / Vendor Relations / Applicant Tracking Systems (ATS)

 

Professional Experience

 

Benefits System Analyst, Akima, LLC, Reston, VA                    October 2017 – Present

System analyst for Akima, LLC.  Gathering requirements for system improvements. Data-mining of data information and processing benefits data system adjustments. Implementation of SCA/CBA benefits agreements to ensure compliance.  While maintaining the confidentially of employee and company privacy information.

 

Skills

- Data Modeling                                                                  - Data Validation

- Ad Hoc Data Reporting                                                   - Database Administration

- Requirements Gathering                                                  - SCA & CBA Benefits Administration

- CostPoint HRIS Administration                                  - FMLA & COBRA Compliance

 

Key Projects & Achievements

·         Implementation of the CBAS benefits enrollment system

 

 

Senior Data Analyst, Harkcon, Inc. Washington, D.C.               June 2015 – September 2017

Workforce analyst for DHS (Department of Homeland Security) Manpower and Organization Division.  Gathering requirements and detailing mission objectives for department leads. Creating reports for senior level DHS staff.  Database Administration of DHS position information.

 

Skills

- Data Modeling                                                                 - Data Validation

- Cyber Security Research                                               - Cyber Security Debriefing

- Ad Hoc Data Reporting                                                  - Database Administration

- SQL Coding                                                                      - Requirements Gathering

 

Key Projects & Achievements

·         Cyber Security research for Issue team under Department of Homeland Security

·         Development of Position Management System for Department of Homeland Security

·         Development of Staffing Modeling System for Department of Homeland Security

·         Data dictionary collection of important Department of Homeland Security

 

 

HRIS Project Leader, Mosaic Community Services, Timonium, MD               Jan 2015 – April 2015

Human Resources HRIS project leader for a Non-Profit in Maryland. Implementing Ceridian DayForce HRIS software.  While maintaining the confidentially of employee and company privacy information.

 

Skills

- Employee Records                                                            - Auditing

- Annual Trainings Administrator/Trainer                      - Applicant Tracking Systems (ATS)

- DayForce HRIS Administration                                  - EEOC/AAP Compliance

- Benefits Analysis                                                              - Employee Relations

- Exit interviews                                                                   - Health Benefit (Section 125) & 401K

- Workman Compensation Compliance                         - I-9 (E-Verify) & H1B-Visa documents

- FMLA & COBRA Compliance                                      - Salary Compensation Data Analyzing

- HIPAA Compliance                                                         - Reporting SQL coding                  

 

Key Projects & Achievements

·         Implementation of Ceridian DayForce HRIS System.

 

HRIS Analyst, Imagine Schools, Washington, D.C.                Oct 2013 – December 2014

Human Resources Manager for a Public Charter School in the Washington, D.C. area. Managing ADP/Payroll administration, employee relations, and payroll.  While maintaining the confidentially of employee and company privacy information.

 

Skills

- Employee Records                                                            - Auditing

- Annual Trainings Administrator/Trainer                      - On boarding

- Payroll/HRB ADP Administration                             - EEOC/AAP Compliance

- Benefits Analysis                                                              - Employee Relations

- Exit interviews                                                                   - Health Benefit (Section 125) & 401K

- Workman Compensation Compliance                         - I-9 (E-Verify) & H1B-Visa documents

- FMLA & COBRA Compliance                                      - Unemployment Claims Representation

- HIPAA Compliance                                                         - Salary Compensation Data Analyzing

- Applicant Tracking Systems (ATS)

 

Key Projects & Achievements

·         Employee compliance auditing for Imagine Schools records

 

HR GENERALIST/HRIS ANALYST, HealthStream, Laurel, MD                                    September 2011 – May 2013

Managing benefits/plans administration, employee relations, and Human Resources information system administration. Implemented several new technologies (ADP- HRB) to enhance services to our executives, managers, and employees; including leveraging web-based SAAS applications technology for teaching and learning. Running reporting data directly to management level staff. While maintaining the confidentially of employee and company privacy information.

                           

Skills

- Human Resources Information System (ADP)         - Employee Records

- Annual Trainings Administrator/Trainer                      - Auditing

- Life Insurance Claims Administration                          - EEOC/AAP Compliance

- Benefits Analysis                                                              - Employee Relations

- Exit interviews                                                                   - Health Benefit (Section 125) & 401K

- Workman Compensation Compliance                         - I-9 (E-Verify) & H1B-Visa documents

- FMLA & COBRA Compliance                                      - Unemployment Claims Representation

- HIPAA Compliance                                                         - Talent Management

- On boarding                                                                       - Training development

- Ad Hoc reporting development                                      - SAAS applications Administration                               

- Users/passwords administration                                     - Salary Compensation Data Analyzing

- Applicant Tracking Systems (ATS)

 

Key Projects & Achievements

·         Scheduling, administrating, and tracking of companywide trainings in Insight Institution.

·         Team Leader of Connectivity and member of Safety Committee, Green Team, Wellness Team and point of contact for HealthStream Employee Engagement Agenda.

·         Implementation of new application tracking system.

·         Implementation of new employee evaluation software and point of contact for all inquiries.

·         Implementation of full version of ADP Human Resources Information System (HRIS).

 

 

HRIS ANALYST/JR. BENEFITS ADMINISTRATOR, Constellation Energy (Aerotek Contractor), Baltimore, MD April 2011 – July 2011

Administration of employee benefits for a vital energy company within the United States. Provide pension and life insurance policy administration for the HR – Direct team. Maintained employee benefits in the company HRMS systems.  Utilizing Business Intelligence tools to compile Reporting. While maintaining the confidentially of employee and company privacy information.

 

Skills

- Human Resources Information System (PeopleSoft)             - Employee Records

- Life Insurance Claims Administration                                          - Pension Policy Administration (WyPen)

- Benefits Analysis                                                                              - QDROs Administration

- Exit Calculations                                                                               - Health Benefits & Pension

- Business Intelligence (SSRS)                                                         - SQL querying

- Reporting SQL coding

 

Key Projects & Achievements

·         Pension & Life Insurance administration for leading Energy Company.

·         Payroll exit calculation for the payroll department.

·         PeopleSoft administration for Company HRMS.

·         Point of contact for QDROs claims for the Legal Department.

 

HUMAN RESOURCES HRIS/BENEFITS COORDINATOR, Intercultural Family Services, Philadelphia, PA   July 2006 – Feb 2011 (Bettinger Contractor Jan 2006 – July 2006)

Hire to promote exemplary and ethical Human Resources standards for both management and non-management staff. I provided HRIS administration of data and benefits to a social service company in the Greater Philadelphia area. Updated old Human Resources data management practices with new innovated green practices. Resulting in resources cost saving projects; while promoting a more efficient and more responsive Human Resources Department. While maintaining the confidentially of employee and company privacy information.

 

Skills

- Human Resources Information System (Solomon)               - EEOC Compliance

- Workman Compensation Compliance                                         - I-9 & H1B-Visa documents

- Employment Verifications                                                              - Interviewing & Recruitment

- FMLA & COBRA Compliance                                                      - Health Benefits (Section 125) & 403B plans

- Unemployment Claims Representation                                       - Open-Enrollment

- Investigation                                                                                      - Employee Records

- ERISA and HIPAA Compliance                                                    - Training Administration

- Salary Compensation Data Analyzing                                       - SQL Database administration

 

Key Projects & Achievements

·         Advised and coordinated Implementation of Human Resource Information System (HRIS) while maintaining relationship with outside vendor consultant, until completion of project.

·         Created and modified HRIS procedures and manual. Trained all Human Resources team members.

 

Education

UNIVERSITY OF CONNECTICUT, Storrs, CT

Bachelor of Arts, Graduated

 

Computer Skills

Languages: Python, SQL, PLSQL, and HTML

Operating Systems: Windows 10, Windows 7, Windows Vista, Windows XP, Windows 2003, Windows NT, and Linux

Internet: Chrome, Internet Explorer, Safari, and FireFox

Applications: CostPoint HRIS system, Oracle 11g., Postgres, Ceridian DayForce system, Ceridian HPL system (TimePro), ADP system (HRB, E-Time, and payroll), Insight Institution-learning software, Windsx (security software), WyPen HRIS system, PeopleSoft HRIS system, Solomon HRIS system, MS Office Suite 2007 (MS Access, MS Excel, MS Outlook, MS PowerPoint, and MS Publisher) Word Perfect, SPSS, OpenOffice, and Goldmine

 

Activities & Awards:

Oracle 11g Database Administration I                                                                                  2017

ONLC Training Center

 

Certificate of Completion, Scarlett Leadership Institute                                          2012

Leadership Development Program

 

Leadership Award                                                                                                      Spring of 1999

Winner

 

Air Force R.O.T.C Detachment #114                                                                        Inducted 1997 – 2000

Member

 

Air Force JR.O.T.C                                                                                       Inducted 1995 – 1997

Member