Hal Bergee Email & Phone Number

Atlanta, Ga, Us

Worthington, Ohio, Us

Atlanta, Georgia, Us

Defining and developing BI applications to measure and improve healthcare systems performance for the 6 domains of quality of care, i.e safe, timely, effective, efficient, equitable, and patient centered. Supporting internal software development, administration, and database design as well as end user requirements analysis.

Dallas, Tx, Us

Developed the comprehensive MS SQL Server Data Mart via, Views, Tables, Stored Procedures, and the associated Business Intelligence design to provide competitive advantages for their Direct and Email Marketing campaigns. Provided file conversions required for efficient database reporting.

Atlanta, Georgia, Us

Provided the data integration and developed a MS Access VBA application for The Home Depot Global Supply Chain POD, Chargeback, and Repayment data from multiple DB2 sources with data drill-down menus, multi-tab spreadsheet creation, file creation, and dashboard reporting capability at the Platform, Location, Vendor, Dept, PO Number, and Invoice Number levels saving the company millions in previously unidentified costs. Worked with internal personnel on the data validation and provided the documentation outlining the application. Also created a utility for ongoing updates. Accommodated multiple design changes and completed the requested changes ahead of the target schedule.

. Provided extensive tier three support to all areas, i.e. Clients, Operations, Tax, Accounting, Pensions, Insurance, including the setup of appropriate EDs for taxation, the balancing of payroll to liabilities and liabilities to cash, the reconciliation/correction of quarterly tax forms, e.g. Federal 941, Annual FUTA, State, SUI, Locals, taxable wages and tax amounts, the labor distribution and GL setup/reconciliation as needed, the setup of time accruals, verification of ACH accounts and amounts, and provided solutions where necessary to accomplish client needs, protect business relationships, or meet contractual requirements. Always focused on providing responsive and reliable client service. Utilizing Qlikview BI software developed a Management Sales Dashboard integrating databases from four disparate systems including the core Bank CRM system, multiple Access databases and our core Payroll System. As a result of this development the Sales Team benefited by having a single view of their sales efforts from the original referral through the downstream process to the close and ultimate new start of a client on the books, and Management benefited with the ability to measure the results against established targets along with the capability of reporting data by year, month, day as of any date selected and by any combination of associated additional filters selected. Now, estimated, actual, and projected revenue is available on a current basis for competitive strategic planning. . Provided the parallel testing and actual documentation results to the corporate project office verifying the new system’s integrity for payroll, liability, ACH data and transaction processing. . Lawson PwHRSource Payroll Implementation, Evolution Payroll Installation, Setup, QA Testing/Validation, Data Conversion, Data Reconciliation.. Developed detail design specifications and coding required for EDI partner multi-client interfaces and reporting.