Résumé for Eric R. Forkrud

1012 Dixie Dr.
Hemet, CA. 92543
(818) 642-4351

Home - Blog

Skills

Work History

2019-07 to Present: Spruce Grove Hospitality - Database Administrator

34843 Rancho California Road, Temecula, CA 92591
(951) 587-9463
  • Implement an ERP system using Microsoft Dynamics NAV
  • Implement Property Management System using Cenium
  • Manage Backup System
  • Build new Servers for POS System using LS Retail and LS Hospitality
  • Implement EMV Credit Cards with ChargeLogic/DataCap and Shift4

2017-08 to Present: Pacific Coast Expert Networking LLC - CEO

1012 Dixie Dr, Hemet, CA 92543
(818) 642-4351
  • Built a PowerShell Wrapper that would take a list of custom ScriptLets from the server, run the the ScriptLet and then transmit the results back to the server for processing reducing labor for the Asset Tracking for an organization to fully automated.
  • Built a WCF component that would transmit and receive data for the PowerShell Wrapper and store the information with in an SQL Database.
  • Built a Database Synchronization tool that will duplicate the schema and specific records from a "Master" database to slaved databases for specific customers, reducing the updating labor from a day to a monitoring mechanism.
  • Built a Service Monitor that will ensure that specific services are running and responding appropriately. If a service is not running or responding, it will restart the service.
  • Maintained an ASP ERP website using VB6, ASP Classic, AJAX and MS SQL as a back end
  • Enhanced Existing MS Access CRM Database for more automation and ease of use.
  • Enhanced ASP Application to new State requirements and to automatically download employee Timecard Transactions, calculating their missed punches or double punches and using the information to inform the supervisor of the lack of required hours for the Patient to Nursing/CNA ratio, reducing the time from three hours a day, every day to a manual review of the report taking half an hour.

2009-04 to 2017-06: ECi M1 - Developer

3191 W Temple Ave # 140, Pomona, CA 91768
(800) 959-3373
  • Analyse and design reports from given data into a report driven by the data in a Crystal Reports environment. 
  • Create and design customer driven training materials for ERP Software.
  • Create technical documentation for ERP Software.
  • Train customers from training materials in a classroom setting.
  • Work with customers to train them to implement and use the ERP Software.
  • Write custom code to allow the user to follow their standard operating procedures or enhance current processes.

2002-01 to 2012-12: Pacific Coast Expert Networking - Owner

(818) 642-4351
  • Created an N-Tiered Web Application with ASP.Net (VB), AJAX and an SQL back end to handle Sales, Jobs, Shipping, Invoicing and Payments for Label manufacturer from an Access Database, speeding up the processing of orders from thirty minutes per transaction to four minutes.
  • Repaired and Maintained Windows 2003 Servers with Exchange and Active Directory, reducing the average server down time from once a month, or more, to about three times a year.
  • Designed and created websites for customers using ASP.net, PHP HTML and SQL back end information.
  • Scheduled and went onsite for customers and repaired system computers when necessary.
  • Fixed, designed and implemented computers, servers and networks.

1998-06 to 2008-03: All Saints HealthCare - Information Technology Administrator

11810 Saticoy St. North Hollywood, CA. 91605-1415
(818) 982-4600
  • Created procedure for analysis and reporting of admission and discharge trends for yearly reports reducing the time from one week to two days.
  • Wrote ASP application to handle company asset and inventory management through MS SQL database, eliminating weeks of manual entry each year.
  • Wrote ASP application to handle importing, reviewing and editing the timekeeping information. This then allows the user to input the Census information and generate the monthly required excel document stating the Nursing/CNA/Respiratory Therapist to Patient Ratio. This website reduced the labor to build the monthly state reporting from fifty hours to less than two hours a month.
  • Wrote MS Access application to handle certification requirements and report expirations and application to monitor CNA Training requirement and interface with the certification database reducing the Staff Developers overhead on handling nursing licenses and renewals from two hours for each renewal to a few minutes.
  • Implemented conversion utility from AccuMed Add-On Classic and Barcode Ancillary system Resource, eliminating a week of manual entry between the Supply Department and Billing every month.
  • Design, Enhance and maintain network environment and servers.
  • Developed and implemented HIPAA procedures, documentation and training material per state requirements.

Education