- Act as the Technical Consultant for the HRMS Professional Services team servicing Epicor HCM and UKG Pro clients and assist with answering technical questions inquired by a client.- Primary responsibilities include installs, upgrades, data conversions, customizations, interfaces and HCM support.- Complete/review the data conversion mapping from client's HR data source to Epicor HCM and UKG Pro and perform data conversion process using T-SQL scripts in SQL Server.- Work with client to determine the purpose of the customization request, define specification document, create customization and test customized pages within the HCM application using C#.- Create and define client custom reports for Epicor HCM using T-SQL stored procedures and SQL Server Report Builder 2.0/3.0.- Analyze business requirements for file exports/imports of HR related data including payroll systems (ADP products, iVue and Paychex) and other custom internal systems for clients.- Develop and test HR data export procedures based on business requirements using T-SQL and C#.- Develop HR data import procedures based on business requirements and validate imported HR data to ensure accuracy based on client specifications.- Implement client HR data imports and exports within project timeline and budget.- Document file specification including file format, specific HR data fields and data scenarios for import and export processes.- Train end users on the workflow of the import and export processes.- Support and troubleshoot interfaces for clients.- Identify data inconsistencies and assist client in resolving.- Document and share acquired knowledge of best practices with co-workers.- Help rollout Microsoft Teams throughout the company. Phased approach to move from multiple third party applications to Microsoft Teams for communication/collaboration and virtual meetings.

- Provide technical expertise in the administration, maintenance, analysis, testing and implementation for purchased or in-house developed software required for County wide business operation.- Defines project milestones and develops test data and applies technical procedures to prove logic and application of programming instructions.- Provides analysis of options and alternatives for application implementation and administration.- Work with vendor for vendor supported applications, acting as the technical liaison between the vendor and internal customer.- Develops tests to troubleshoot problems, plan, test and implement solutions.- Supports current ITIL Standards.- Currently Supporting the following applications: Accela Automation, CarteGraph, Contract Management, HVAC, Permits Plus, Rhythmyx, SAP, VAST, Weatherization- Provide Database Administration on multiple SQL Servers including 2005 and 2008.- Develop stored procedures, views and SSIS packages for reporting.- Provide support for SAP Basis Administration including user creation/maintenance, updating workflows, running transports, reviewing daily/weekly tasks, and assisting with patches/upgrades.- Assist vendor and users with the Permit Plus and CarteGraph data scrub and data conversion/configuration to Accela Automation. Assist with the conversion of existing reports built/stored in Business Objects Enterprise to SQL Server Reporting Services.

- Provide Tier III level of product support, problem resolution, training, and IT/Human Resources consulting for SPECTRUM's clients.- Troubleshoot escalated calls from the Product Support department and assisted in resolving problems and/or complex issues from Professional Services, Development and occasionally Network Services. Act as a liaison between multiple departments in SPECTRUM. - Identify problem areas and bugs in the iVantage system and created fixes that would later be added to future hotfixes/releases.- Document problems/bugs identified in the iVantage system into SPECTRUM's SCR database to notify Development about issue. Updated the SCR entry with fix once identified.- Create knowledge base to assist all departments about problem and resolution for future reference.- Perform upgrades to the iVantage system for SPECTRUM hosted clients - upgrading current version to the most up-to-date version of iVantage. Sometimes this involved upgrading from one platform (SQL2000) to a different platform (SQL2005).- Perform iVantage installations for clients at a billable rate running in different environments - single server, split server and on virtual servers.- Perform Disaster Recovery of the iVantage system for clients at a billable rate when their server(s) crash and do not have a backup system available.- Perform Server Moves for clients at a billable rate - move entire iVantage system from one environment to another. Assisted in setting up new environment, installing software, moving data, finalizing testing.- Assist with importing data into SQL tables.- Utilize Microsoft SQL Server 2000/2005/2008 – create databases, create/modify queries, create/modify stored procedures, create/modify objects, and troubleshoot advanced stored procedures.- SQL Server Performance Monitoring and Database Administration for iVantage system.- Utilize Crystal Reports 9 & XI to assist clients in building advanced/complex reports.

- Provide Tier III level of product support, problem resolution, training, and IT/Human Resources consulting for SPECTRUM's clients.- Troubleshoot escalated calls from the Product Support department and assisted in resolving problems and/or complex issues from Professional Services, Development and occasionally Network Services. Act as a liaison between multiple departments in SPECTRUM. - Identify problem areas and bugs in the iVantage system and created fixes that would later be added to future hotfixes/releases.- Document problems/bugs identified in the iVantage system into SPECTRUM's SCR database to notify Development about issue. Updated the SCR entry with fix once identified.- Create knowledge base to assist all departments about problem and resolution for future reference.- Perform upgrades to the iVantage system for SPECTRUM hosted clients - upgrading current version to the most up-to-date version of iVantage. Sometimes this involved upgrading from one platform (SQL2000) to a different platform (SQL2005).- Perform iVantage installations for clients at a billable rate running in different environments - single server, split server and on virtual servers.- Perform Disaster Recovery of the iVantage system for clients at a billable rate when their server(s) crash and do not have a backup system available.- Perform Server Moves for clients at a billable rate - move entire iVantage system from one environment to another. Assisted in setting up new environment, installing software, moving data, finalizing testing.- Assist with importing data into SQL tables.- Utilize Microsoft SQL Server 2000/2005/2008 – create databases, create/modify queries, create/modify stored procedures, create/modify objects, and troubleshoot advanced stored procedures.- SQL Server Performance Monitoring and Database Administration for iVantage system.- Utilize Crystal Reports 9 & XI to assist clients in building advanced/complex reports.

- Provided Tier II/III level of product support, problem resolution, training, and IT/Human Resources consulting for SPECTRUM Human Resource Systems clients. - Utilized Microsoft SQL Server 2000/2005/2008 – created databases, created/modified queries, created/modified stored procedures, created/modified objects, and troubleshot advanced stored procedures.- SQL Server Performance Monitoring and Database Administration for iVantage HRIS system.- Performed Server Moves for clients - move entire HRIS system from one environment to another. Assisted in setting up new environment, installing software, moving data, finalizing testing.- Utilized Crystal Reports 9 & XI to assist clients in building iVantage reports and helping publish them to the HRIS system.- Taught Beginner/Advanced level classes in iVantage HRIS, Business Objects XI Reporting, and Microsoft SQL Server 2000/2005 Administration to HR staff, Managers, and IT Professionals.- Presented Webinars, online web sessions using GoToMeeting, which focus on particular areas in the iVantage system that clients can attend and ask questions.- Performed GoToAssist sessions which focus on particular areas in the iVantage system on a client by client request.

- Maintained and updated client's existing web site.- Created, maintained and updated client's new realty web site. Updated periodically for new listings and agent profiles.- Responsible for creating listing brochures and flyers.- Perform daily maintenance on office PCs to run more efficiently.- Created Microsoft PowerPoint presentations on how to use Microsoft products more efficiently. Provided a better understanding of how to use Microsoft Word, Excel and Outlook.- Setup email accounts for each of the real estate agent in the company.

- Gryphon Solutions started out by creating web designs for personal use. It then expanded to also include web hosting and other business services.- Provided assistance in low cost domain registration.- Business services included the creation of banner designs, business brochures, business cards, flyers, letterheads, mailers/postcards and PowerPoint presentations.

- The project was to create a Help System that will be a sub-system of their current internal Dashboard 2.0 system - served as online documentation to help better understand life-cycle of products.- Facilitated user interaction throughout the Course Development Process.