Andy Gelernter

678.571.5950   www.LinkedIn.com/in/AndyGelernter

Andy@HRDataSolutions.com / geter@mindspring.com

About Andy · Career History · Education

Career History

2007 – Now UltiPro / UKG Pro Consultant

Highlights · Consultant for Enterprise and Mid-market clients

· Historical data corrections

· Imported Employee data using SQL and ACCESS

· Created and modified data exports

· Data exports of both Company Business Rules and Employee Demographics/History

· Creation of COGNOS Analytics reports

· Conversion of COGNOS Impromptu 7 reports to COGNOS BI 8

· Creation of Benefit exports

· Setup of new Earnings, Deductions, Benefits, and PTO/Accrual plans

· Modification of GL Rules

· Time-clock imports

· Configuration of Employee and Manager Self Service

· Worked with IT department to enhance existing procedures for UltiPro / UKG Pro upgrades, backups, restores, and change control

Technologies UltiPro / UKG Pro HRMS; COGNOS Analytics, 10, 8, & Impromptu 7; SQL; Access; and Microsoft Office

2003 – 2007 Gevity / HRAmerica / Dovetail Group

In April 2006, Dovetail’s Professional Services department merged into HRAmerica. In February 2007, HRAmerica was acquired by Gevity.

Gevity

Director, Professional Services for UltiPro / UKG Pro HRMS Product Suite

Highlights · Position focus was Professional Services and Sales Engineering Support

· Developed Professional Services plans to capture additional revenue from existing Clients

· Part of team working to develop Marketing material and processes for Professional Services

· Part of team that developed Gevity Edge Select (UltiPro / UKG Pro) training presentation for BDMs

· Conducted initial BDM training for rollout of Gevity Edge Select (UltiPro / UKG Pro) platform

· Developed sales presentation scripts for BDMs

· Part of team that developed new Gevity Edge Select Process Flows

· Facilitated development of Blueprint Analysis tool spreadsheet model for data gathering

· Developed GES Implementation Analysis form for BDMs

· Work with BDM’s in a sales engineering role as the technical consultant

· Manage Ultimate Software relationship for outsourcing of their clients to us for implementation

· Meet with sales prospects demonstrating UltiPro / UKG Pro and solving how it meets their needs.

Technologies UltiPro / UKG Pro HRMS, COGNOS Impromptu, COGNOS PowerPlay, COGNOS IWR, SQL, Microsoft CRM, Project, Visio, Access, PowerPoint, Microsoft Office, and Windows (2000/XP)

HRAmerica

Vice President, Implementation & Professional Services for UltiPro / UKG Pro HRMS Product Suite

Highlights · Developed Implementation Process Flow to standardized new client implementations

· Developed a new client Needs Analysis used for Sales turnover to Implementation

· Instituted weekly client status meetings, status reports and an in-depth work-plan methodology

· Additional role as Application Consultant for demonstrating UltiPro / UKG Pro solution for sales prospects

· Dept responsible for implementing Ultimate Software’s Intersourcing & Enterprise clients

Key Clients Denny Hecker, National Diagnostics, Youth Advocates, MODEC, Nuclear Energy Institute, North America Bus, APCO, Hoot WINC, MSC Development, NAMSA, NC Alliance of Public Health Agencies, Pattons.

Processes Used HRAmerica methodology guides client through the full conversion process from Kickoff to HRAmerica processing client’s payroll. Key tools in the process include Sales Needs Analysis, Implementation Blueprint, Implementation Process Flow, Status Reports / Work-Plans, and Payroll Processing Turnover Procedures. Project life-cycles include knowledge transfer from Sales, front-end analysis and data gathering of client’s business rules using the Implementation Blueprint. Database configuration included peer reviews and client reviews with formal signoffs. An integrated communications plan included both clients and other HRA departments including payroll, benefits, and tax.

Technologies UltiPro / UKG Pro HRMS, COGNOS Impromptu, COGNOS PowerPlay, COGNOS IWR, SQL, Microsoft CRM, Access, PowerPoint, VPN, Microsoft Office, and Windows (2000/XP)

The Dovetail Group

Director of Professional Services for UltiPro / UKG Pro HRMS Product Suite

Highlights · Implementation of UltiPro / UKG Pro HRMS

· Creation of COGNOS Impromptu reports

· Every UltiPro / UKG Pro project implemented within budget

· Restructured Professional Services department

· Created time and resource estimating methodology resulting in no under-bided projects

· Developed pricing structure for UltiPro sales bids to help maximize profitability

· Revised Dovetail’s contracts to clarify both Client and Dovetail responsibilities

· Designed and developed a Needs Analysis tool used by Sales to qualify prospects

· Initiated intensive Sales Department training

· Routinely meet with sales prospects demonstrating UltiPro / UKG Pro & solving how it meets their needs

· Facilitated development of over 70 Job Aids covering all aspects of day-to-day UltiPro / UKG Pro tasks

· Significantly reduced implementation timelines

· Created standardized procedures for everything from documentation to client communications

· Instituted weekly client status meetings, status reports and an in-depth work-plan to follow

· Developed Microsoft Access import methodologies for Employee data and Opening Balances

· Developed and maintained a common library of SQL queries used for implementation

Key Clients King & Spalding, Youth Villages, Georgia Farm Bureau, The Bankers Bank, US Lumber, Ogletree Deakins, The Virginia Lottery, Aradigm, Lifeguard Transportation, Team One Logistics, I-Car, Industrial Distribution Group, Passport Health, Home Federal Bank, and Siemens Logistics.

Processes Used Dovetail methodology guides client projects through the full UltiPro conversion process from Kickoff to Go Live. The Project Blueprint is the front-end analysis tool used to insure complete replication of the client’s business rules. Implementation using a blended solution of SQL queries, Access databases, and directly mapping legacy SQL tables to UltiPro tables. Project management guidelines require a completely integrated communications throughout the project. Continuous client training using a combination of solutions including: face-to-face sessions, web-meetings, job aids, and Ultimate training classes. A complete sign-off plan requiring the client to verify every step of the way that every business rule from the Blueprint is configured in UltiPro / UKG Pro. We use a series of formal client reviews that lead up to our detailed Turnover Books to Ultimate. Dovetail implements the full range of functionality including Backoffice, Payroll, all areas of employee HR data, the Web Portal for manager and employee self-service, workflows, GL, benefit enrollment, and the business intelligence tools.

Technologies UltiPro / UKG Pro HRMS, COGNOS Impromptu, SQL, Microsoft Project, Access, PowerPoint, VPN, Microsoft Office, and Windows (2000/XP)

2002 - 2003 Consultant

Highlights Training Analyst, Instructional Designer, University Professor, Business Process Developer, and classroom instructor for various projects.

Technologies PeopleSoft, Authorware, Visio 2000, Microsoft Project, Microsoft Office, Windows 2000, and Mac OS X

Projects include:

Employee Retirement System of Georgia (ERSGA)

Instructional Designer for ERSGA’s business process update of PeopleSoft. PeopleSoft modules include HRMS (Human Resource Management System), Payroll, and Pension. Developed Business Processes on Benefit Estimates and Create Payee. Designed and developed training manual, instructor guide, and job aids on Benefit Estimates training course.

Teacher Retirement System of Georgia (TRSGA)

Instructional Designer and Trainer for TRSGA’s new ERP management system created by BearingPoint (KPMG). Designed and developed training manuals, instructor guides, and job aids. Classroom instructor for Fundamentals, Master Payroll, New Retirement Setup and Payroll, Processing Death Benefits, and Benefit Adjustments training courses.

The Coca-Cola Company

Lead Instructional Designer for a The Coca-Cola Company New Employee On-Boarding program. Responsible for the definition of detailed requirements for the New Employee On-Boarding program worldwide, including: training strategy, communication plan, and deployment plan. Key objective is to move the new employee orientation program from an instructor-led approach to a multi-delivery approach of self-study and web-based training. Responsibilities included:

• Development of Orientation Strategy and Needs Analysis to determine the new course subjects and topics;
• High-level Training Strategy, Communication Plan, and Deployment Plan;
• Proposed solution of four-level orientation spanning the first year of employment, and involving the new employee, the hiring manager, the associated team, and a mentor.
• Development of a Content Audit and Gap Analysis of the old program.

American InterContinental University

Adjunct Professor for the Visual Communications department teaching DMD 101, Survey of Digital Media. This night class was taught 2 nights per week.

Georgia Health Partnership (GHP)

Senior Training Analyst responsible for the development of the GHP Comprehensive Training Plan. The GHP is comprised of ACS, Inc. and the State of Georgia. GHP is tasked with a system implementation that will give patients, doctors, pharmacists, health care providers, and insurance companies a single access point to the four Georgia health care programs: Medicaid, PeachCare for Kids, State Health Benefit Plan (SHBP), and the University System’s Board of Regents.

The GHP Comprehensive Training Plan provides a strategic-executable plan for training rollout to Providers, Members, Field Representatives, Operations, and State personnel on all system components. Training courses will cover MultiHealthNet (single-claims processing), Web Portal, Call Centers, Member ID Swipe Cards, HIPAA Compliance, and paper processes. Responsibilities include:

• Development of Department Training Plan Reference Guide and Templates;
• Conducted interviews and provided guidance to Department Supervisors in Training Plan development;
• Development and instructional guidance for:

o Job Task Analysis;

o Course Identification Matrix;

o Audience/Course Matrix;

o Comprehensive Course Catalog;

o Gap Analysis Tools;

o Operations Training Approach and Methodology;

• Contributed to Organizational Development Plan through Business Analysis;
• Conducted Knowledge Transfer learning sessions for ACS Training Coordinators.

Atlanta Cad Services

Classroom Instructor for various 3 and 4-day classes on Authorware 6.

Quick Start, Georgia Department of Technical and Adult Education

Developed a Training Needs Assessment to identify universal job skills that are common across all typical Head Quarter Operation’s job-positions. This included identifying department names, their responsibilities, and staffing patterns; job-position names, their responsibilities, and skills; and classifying each job-position into one of five job-family classifications. Then all job-position skills were analyzed to identify where ‘across-the-board’ training modules can be developed.

1999 – 2002 Realm Communications, Inc.

Manager, Web & Multimedia Department

Highlights Created a profitable Web and Multimedia department, selected staff, setup and standardized processes and procedures, created winning proposals and bids, and moved the company away from a print only business to an integrated service provider. In addition, developed project-pricing guidelines using solid leading-edge concepts and methodologies. Position included significant client and vendor relationship management.

Key Clients BellSouth, CMD, NCR, PerkinElmer, S1 Corporation, InterCept Group, Georgia Freight Bureau, and UPS

Processes Used Taken projects through the full life cycle of client idea to product rollout. Starting with the initial project study front-end analysis including needs assessment, task analysis, and client goals and objectives. Developed project proposals, which include pricing and timelines. Conducted formal client reviews, followed by integrated testing and proofing.

Project Types Internet, Intranet, Extranet, Web-Based Training, and Sales & Marketing CDs.

Technologies ASP, ColdFusion, HTML, DHTML, JavaScript, VB, SQL, Dreamweaver UltraDev, Homesite, InterDev, Visual Studio, Director, Photoshop, Illustrator, Premiere, SoundEdit, Acrobat, PowerPoint, Microsoft Office, Windows (95/98/NT/2000), Macs, and PalmPilots

1996 – 1999 Consultant

Highlights Instructional Designer, and CBT/WBT/Multimedia developer for various projects. Activities included project manager, instructional design, storyboarding, & authoring/programming.

Clients Centurion Inc., BellSouth, Engineered Multimedia, SciTrek, Nortel Networks, Bianco Hopkins, AT&T, Riverwood International, Knowledge Networks, UPS, Spektragrafika, Prudential Securities, Carter Center, Pettus Media, Allyn & Bacon Publishing, and American Bible Society

Markets Manufacturing, Technical, Maintenance, Human Resources (PeopleSoft), Call Centers, Financial, Sales Force, and K-12 Education

Project Types Kiosk, Computer-Based Training (CBT), Web-Based Training (WBT), and Multimedia Sales & Marketing Tools

Technologies Authorware, Director, ToolBook, Dreamweaver, Homesite, Photoshop, Premiere, SoundEdit, Acrobat, PowerPoint, Microsoft Office, Windows (3.1/95/98) and Macs

1991 – 1996 Quick Start, Georgia Department of Technical and Adult Education

Instructional Designer and CBT Developer

Highlights Instructional designer/developer for various training projects. Activities included managing, writing, designing, and evaluation of projects across a range of industries.

Processes Used All phases of the Instructional Design process including performing comprehensive needs analysis/project studies, developing goals, objectives, and mastery checks. Developed training methodologies used for each project from classroom to manuals to CBT to blended solutions.

Clients Anheuser-Busch, Metal Container Corp., General Mills, Holiday Inn, GTE Mobilnet, Proctor & Gamble’s Sundor Division, Shaw Industries Carpet Division, Western Wheel, Industrial Boiler, Contel Cellular, Medaphis Corp., Artrac, Asset Care, Shop ‘N Chek, and Sony Corp.

Project Types CBT, instructor led training, training manuals, job aids, and multimedia applications.

Technologies Software applications include Authorware, Quest, Linkway, Microticcit, ICONAuthor, Director, Photoshop, Avid, Premiere, SoundEdit, Microsoft Office, Windows (3.1/95), and Macs.

1989 – 1990 Floyd Design

Instructional Designer and CBT Developer

• Authored Hurricane Hugo, an award winning interactive laserdisc application for K-12 education. This program made extensive use of CNN video footage and on-site interviews conducted during and after the hurricane to teach not only about hurricanes, but also about how they affect history and lives.

• Developed multimedia presentations using both ABC and CNN’s news footage for the vice-president of education of IBM to demonstrate at K-12 teacher conferences. Topics included both Martin Luther King, Jr. and the 1980 Democratic National Convention.

About Andy · Career History · Education