Management Data

ANDY GOMEZ

708-***-**** **** W DEVON SUITE ***, ROSEMONT, IL 60018 ******@*********.***

SQL – UltiPro CONSULTANT

AREAS EXPERTISE

OF

SQL / UltiPro Consultant Project Management

Solution Concept to Execution Systems Analysis & Design

Translating Business Data into Action Innovative Application of Technology

Web Application Design / Development HR/Payroll Systems

Database Application Development Digital Signage Solutions

Database Application Development Digital Out of Home Solutions

Process Improvement / Business Efficiency Digital Signage Integration

CORE COMPETENCIES

Unique competency in translating business issues into IT solutions including opportunity identification,

requirements development, delivery, support, and analysis.

Full lifecycle experience in scoping, designing, developing, deploying, and supporting enterprise scale business

applications and business intelligence software.

Hands-on experience leading all stages of system analysis efforts, including requirements definition, design,

architecture, testing, and support.

Outstanding leadership abilities; able to coordinate and direct all phases of project-based efforts while

managing, motivating, and leading project team initiatives.

Adept at architecting SQL database-driven applications and solutions to optimize business process

performance and productivity.

Proficient in UltiPro, UltiPro .NET, UltiPro ASP, UltiPro BackOffice, MS SQL Server, T-SQL Programming,

SQL Management Studio/Enterprise Manager, SQL Server Integration Services (SSIS), DTS, Cognos 8,

MySQL, ASP 3.0, JavaScript, Dream Weaver, Adobe Photoshop etc.

PROFESSIONAL PROFILE

GOSA GROUP Rosemont, IL Apr. 2008 – Present

Senior Consultant / Partner

Founder of independent consulting firm, specializing in information technology consulting services,

UltiPro Consulting, business system architecture & integration, data warehousing & business intelligence

solutions and web application development.

Responsible for formulating the strategic goals and objectives of the organization, as well as developing

strategic partnerships and alliances.

Responsible for managing all aspects of project life cycle from scope of work through deliverables,

follow-up and relationship management.

Senior UltiPro System and Technical Consultant specializing in implementation, front and back end

customization.

Deliver industry-focused client success by providing UltiPro consulting, technical and managed services

for deployment, implementation, management and optimization of UltiPro HRMS and Payroll Suites.

Recent Projects:

o Reyes Holdings – Rosemont, IL (2011-2012)

Design and Develop a Work-flow management system. The application is utilized used by

HR employees outside of North America to maintain human resources data for their

respective locations. The underlying data feeds into existing master people database, which

is a MSSQL Kronos database. Create the database design to allow for custom controls and

layouts for multiple language functionality. Create all underlying stored procedures and

reports associated with the management system.

Assist client with custom SQL, ASP and ASP.NET functionality for UltiPro product to

allow client to create add-on functionality of Open Enrollment product. Support team in

their efforts of Open Enrollment and provide insight as how to best process the data within

the constraints of SQL and UltiPro.

Created and implemented an SSO (Single-Sign-On) bridge from UltiPro to both Enwisen

and Kronos. Implementation allows users to automatically log into the two systems after

they have successfully logged into UltiPro. The SSO includes a language feature which

allows users to automatically bring over the language which was chosen within UltiPro

Created a custom add onto their ASP Open Enrollment platform which gave Reyes the

ability to turn specific features on and off as well as use their internal calculations for

specific benefits.

Create and inbound and outbound SSO (Single-Sign-On) with an internal performance

management system. The integration allows Reyes Holdings the ability to use UltiPro as the

core portal to link to multiple sites without forcing users to log in into multiple applications.

Created Work Flow management system to integrate with Kronos and UltiPro.

Ultimate Software Weston, FL (2011-2012)

o

o Coordinate and Project Manage an upgrade of vendor interfaces using the 834

platform. A recent government mandate called for an upgrade of vendor interfaces to

move from a 4010 platform to a 5010 platform. Ultimate Software asked for our

expertise to upgrade a majority of their clients due to our expertise with the process.

o Successfully converted and upgraded all clients who had an aggressive timeline

o Collaborated with Ultimate Software to create a process to efficiently upgrade vendor

interfaces including client contact and project management.

o Worked with SaaS - Hosted Clients as well as Enterprise Clients guiding them through

the upgrade process from 4010 to 5010.

o Clients included but not limited to: TIVO, Nicor Gas, NuStar, Hancock Holdings,

University of Louisville, Amerisure, Amphenol, Blyth, Kish,Culligan Commerce Bank

Solar World – Rosemont, IL (2012)

o

Created and implemented multiple UltiPro Vendor Custom Interfaces Including but not

limited to:

o VSP Vision Interface

o Kaiser Medical Interface

o Standard Interface File

o Assist with 834 5010 Interface Upgrades

Worked with Ultimate Software to automate interfaces with vendor using the UDES

(UltiPro Data Exchange System).

Created custom reports to assist in vendor billing and data clean up.

Assisted client in the setup of their Active Enrollment and Open Enrollment.

Aided the transition from .ASP to .NET advising on the different aspects of the system

which would be impacted.

Corizon – St. Louis, MO / Brentwood, TN (2011-2012)

o

o Successfully assisted in the implementation of a companywide HR and payroll system

conversion from UltiPro to PeopleSoft. The implementation includes the analysis,

mapping and creation of customized reports, exports and validation of UltiPro data

prior to the conversion into PeopleSoft.

o Developed and guided the mapping documents from UltiPro to PeopleSoft for the

purposes of the implementation.

o Assisted in payroll balance parallels by providing reports and balance checks on source

data as well as processed payroll.

o Worked with Corizon staff members and PeopleSoft Consultants during the

implementation to set up, convert and validate the source data in comparisons to the

converted data. Provided reports to assure that the data validation.

o Assisted in the set-up of new deductions for a subset of employees who were remaining

on UltiPro

o Developed custom interfaces for new vendors in the UltiPro System for the sub-set

population which was to remain in UltiPro.

Towne Park Inc – Annapolis, MD (2010-2012)

o

o Assisted in the implementation of UltiPro Open Enrollment which included the set-up

of benefits, vendor selection, interface creation/updates and custom validation reports.

Coordinated with client and vendors to obtain and receive approval of benefits so that

employees may receive their cards for the following calendar year.

o Set up new interfaces and processes which allow automation and proactive reporting.

Develop imports and exports for new vendors as well as upgrades to existing vendor

o

interfaces.

Kenco – Nashville, TN (2011)

o

Successfully implemented vendor interfaces from UltiPro to multiple vendors. The process

included creation of the exports and set up of automation.

Guided employee within Kenco on how to best use the UltiPro System

Provided guidance on system set-up for best interface results and data maintenance

Project Manage the UDES set up and process by working with vendors and Ultimate

Software Staff to provide aggressive timelines in line with implementation.

Amedisys, Inc – Baton Rouge, LA (2009-2010)

o

Serve as a resource to develop and manage all technical aspects of the UltiPro system.

These tasks included the development of custom vendor and internal interfaces along with

the management of upgrading and testing multiple Test and Production environments.

Serve as a database administrator assisting in all functions from development to

management and upgrading.

Consulted, developed and implemented a companywide consolidation of employee records

from working in multiple companies to a consolidation into one company record with

multiple locations. The consolidation was in preparation for the HR and payroll system

conversion.

Successfully assisted in the implementation of a companywide HR and payroll system

conversion from UltiPro to PeopleSoft. The implementation includes the analysis, mapping

and creation of customized reports, exports and validation.

Worked with Price Waterhouse Cooper Consultants during the implementation to set up,

convert and validate the source data in comparisons to the converted data. Provided reports

to assure that the data was valid prior to import.

Additional Tasks Include:

o Conversion of company acquisitions from multiple sources into UltiPro

o Define and verify functional and technical designs and specifications

o Create and maintain vendor and internal interfaces including custom. The interfaces

range from standard medical and dental to custom E-Forms.

o Handle integration issues and manage solutions

o Implement upcoming updates to UltiPro in both Test and Production

o Serve as the system administrator of the UltiPro installations on Test and Production

o Provide backups of production UltiPro databases as needed to developers and testers

o Convert existing UltiPro data to consolidate location/company

o Consult on data reorganization requirements

o Serve as an UltiPro resource for vendors and non HR/Payroll staff members

o Support teams with experience in UltiPro development and guidelines proposals

o Ensure delivery quality of developed products and applications

o Handle integration issues and manage solutions

o Manage tasks on an aggressive timeline

Advocate Health Care – Oak Brook, IL (2010)

o

Developed a custom web solution to be utilized as a legacy viewer of UltiPro data. The Client

moved away from UltiPro but still needed a manner in which to retrieve data which was stored

in the UltiPro database. We provided a series of custom stored procedures and web applets

which will allow Advocate the ability to search and view clients from their intranet in an

effective and efficient manner. Due to our expertise in on UltiPro we were able to deliver a

product at the cost of their internal development estimate.

Texas Roadhouse Inc – Louisville, KY (2010)

o

Creation and update of existing benefit interfaces to coincide with vendor and plan updates.

Analysis of current benefit plans and how they translate to the vendor. Create automation of the

interfaces to alleviate time for hr/payroll and it staff.

Youth Consulting Services (YCS) – Newark, NJ (2009-2011)

o

Migrated and consolidated company benefits from various vendors to achieve a central

o

management location within UltiPro. Upon completion of consolation of benefits and

verification with vendors a series of automated SQL exports were created based upon

the specifications of the vendor. Exports were scheduled for automation which resulted

in a clean integration and drastic reduction in man-hours reviewing data on various

systems. As part of the automation the files were encrypted via PGP and used FTP for

transmission of data. The keys were imported into the client side and programmed to

automate after SQL created the files. YCS has eliminated the dual entry of vendor

systems and now has an effective integration with their vendors. The export file types

included .txt, 834 Format and .csv.

o Created custom calculations for benefits for benefits/payroll team for medical and

dental packages. The calculations are based off the employee’s salary grade.

o Set up new deduction plans and calculations to allow for a more efficient payroll

process.

Graphic Packaging (GP) – Atlanta, GA (2009)

o

Assisted in the implementation of a companywide HR and payroll system conversion from

UltiPro to SAP. The implementation included the analysis, mapping and creation of customized

exports for the purposes of a company conversion and validation from UltiPro to SAP. Created

custom extracts for master file, parallel and go-live conversions resulting in clean and translated

data which was formatted as to the requirements and specifications of SAP. The company wide

conversion was successful and implementation of custom extracts allowed for the balancing and

validation of all employee records.

ULTIMATE SOFTWARE GROUP, INC. Weston, FL Oct. 2004 – Apr. 2008

Technical / System Consultant

Assisted in engineering the design process, methodology and tools for which the team used to construct

3rd party interfaces, as well as the implementation of integration platform in the core product offering.

Assisted in the formation and success of the 3rd Party Data Integration Team. Responsible for growing

this business unit from 5 to 25 employees within two years.

Designed, developed and supported 100+ 3rd party interfaces for an extensive client base spanning all

major vertical markets.

Architected and implemented numerous data integration and process automation solutions to

accommodate clients requiring non-standard core-product functionality.

Analyzed, evaluated and re-engineered clients’ business process, as well as coached them in the

effectively implementing and managing the change process.

Assisted in Training of new consultants so that they may be equipped with the proper SQL techniques,

coding skills and personal skills for the Technical Consultants position

Received over 20 “Performance for Perfections Pins” in 2008 for exceptional level of client service.

Nominated for 2007 Corporate & Service MVP Awards.

DIGITAL MINDS, INC / TOUCHQUESTTM Rosemont, IL Nov. 2002 – Present

Co-Founder / Advisor

Co-Founder and partner of independent full service Digital Signage software firm, specializing in the

Hospitality, Office Space, Corporate environments and Convention Center markets.

Implement a full scale 30 screen digital signage implementation with the Radisson Blu Aqua Chicago.

The flagship hotel integrates with event information from Micros and provides hotel way finding as well

as concierge level information for in and around the hotel.

Successfully implemented a digital signage platform to all Radissons in North and South America. The

implementation provides hardware and software to manage content from a central location and provide

brand messaging to each property guest from both the corporate and hotel level. The implementation

included over 200 properties across 2 continentals.

Assisted in the initial design and development of signage products including TouchQuest Concierge,

TouchQuest Office and TQ-FlyteBoard, Menu Boards. (Further Detail visit www.touchquest.com)

Responsible developing strategic partnerships and alliances including software and hardware alliances

including: LG, NEC, Remote Media (UK), Iadea and Peerless Mounts.

Responsible securing contracts with companies which include: Westin Hotels, Donald E Stephens

Convention Center, Sheraton Hotels, Crowne Plaza, Aloft Hotels, Grubb & Ellis, Carlson Hotels and

CBRE.

Creator of TQ FlyteBoard – a Digital Signage Board located in High Traffic travel related areas (ie

Hotels) displaying real-time flight information via XML feeds and redistributed in an easy to read and

customizable fashion. The product has been successfully installed in over 75 properties across the

continental US and Canada.

Clients include:

o Carlson Hotel Group (Radisson, Country Inn & Suites)

o Hyatt, Starwood Hotels (Westin, Aloft, Element)

o Hilton, Cox Communications, QVC

EXTENDED CARE INFORMATION NETWORK (ACQUIRED BY ALLSCRIPTS)

Chicago, IL Mar. 2002 – Oct. 2004

Database Analyst / Business Consultant

Analyzed and documented functional and technical business requirements of the client/project, as well

as responsible for the analysis and development of system data migration solutions.

Successfully implemented the upgrade of custom and standard reports from SQL 2000 / ASP 2.0 to

SQL 2005 / ASP.NET for the extendedcare.com product line.

Supported client and departmental requests with their analytical and reporting needs; in the areas of

benchmarking, statistical reports, ROI analysis, and productivity analysis.

Developed and maintained a productive working relationships with engagement team members and

client personnel at all levels.

EDUCATION

DePaul University, Chicago, IL

Bachelor of Science Information Systems

Minor in Business Administration

Contact this candidate