Phil M. Email & Phone Number

(Contract role with A.B. Data)Provide subject matter expertise and mentoring to a small communications firm in the area of Cognos Analytics data extraction and reporting / dashboardingCustomer is in their first year “post go-live” and has no stand-alone HRIS team, so am assisting a developer with no previous experience in HR or benefits reporting who is supporting both HR and finance/payroll reporting requests. Advising on proper way to pull data out of the Cognos cube and how to properly assemble various HR and payroll related queriesContract is expected to be short-term and is only a few hours per week

Contract role with UKG Serve as a UKG certified regional integration consultant on UKG's Global Integration Services maintenance team providing support to UKG customers to help modify existing SQL-based integrationsWork closely with each client across various industries and their associated vendors to define, develop, test and deploy required changes to various types of SQL integrations including 401(k), 834 files, and HR demographic files requiredSchedule and conduct meetings with clients and vendors as required to discuss specifications, documentation and coding requirementsClosed 39 Service Requests in the first 120 days with no requests needing to be reopened.

Nashville, Tennessee, United States

Create and maintain data integration solutions as part of a team of developers who provide expertise across a range of technologies. Apps include Cognos/UKG People Analytics, Powershell, SQL Server (SSMS) version 18.Created master data mapping and interface layout specification spreadsheets for over 25 interfaces in support of Kronos to UKG Pro conversion project as part of the Interfaces and Reporting team in the Enterprise Data Management groupSupported current company effort to convert both HR and Payroll systems from Kronos HR and ADP payroll to UKG Pro HR and Dimensions. Continue to support certain Kronos WIM interfaces until the HCM and payroll conversion is completeDeveloping approximately 30 Cognos Analytics extract reports Earned Mulesoft Certified Developer (Level 1), expires 9/26/2023. Novice still learning how to make connections, develop flows and implement API calls. Currently working on making SOAP API calls to UKG Pro to run pre-defined SOAP reports.

Greater Nashville Area, Tn

Created and maintain outbound Prudential 401k interface from scratch in response to switching 401(k) plan administrators for 2020. Sending contributions, loan payment and demographic information for over 12K employees on two pay cycles and over $10M per year. Created using T-SQL (SQL Server 2012) and Powershell ISE for Windows 10. Tested internally to be accurate with the official internal finance reporting.Rewrote primary benefits employee demographic interface from existing EDW code to source it directly from Kronos via Powershell and SQL scripting. This sends a full file of ~17K employees to Benefit Focus each day. Created and maintain outbound interface file to support Daily Pay benefit offered to employees through third party vendor.Created and maintain outbound interface file to support NAVEX Ethics Point demographic reporting requirements.Created and maintain Kronos WFC 8.1 WIM interface to remove labor level transfer sets from terminated employees. Created and maintain SSH authentication keys to support sFTP connection with vendor. Imported and use public pgp key from same vendor to encrypt outbound file using gpg (Gnu pgp utility).Maintain coding and development support for other interfaces as well including demographics files sent to Pay Factors, Concur, Lippincott Solutions, Equifax, Healthstream and a weekly Bank of America HSA/FSA contributions file.Maintain coding and WIM support for a number of WIM interfaces (cloud based WFC 8.1) including ATK Update, iCIMs Hire Import, Time Data Exports (for ADP EPIP file generation), iCIMs Employee Export, Training Event import, Pay Rate Change, AD Email and Username import.Build, maintain and provide coding support for internal reports such as Kronos Meal and Rest Break report, Accrual Change report, Daily Labor report, Prudential quarterly and yearly contributions and compensation reports.

Created third-party Principal Financial Group interface for 401(k)/(l) deduction amounts for over 100K employees. Approximately $300 million a year in deductions sent via this interface file with a first-time accuracy rate of 99.99% when compared to the general ledger.Created third-party Talx interface for employment verification and income verification services for 135K+ employees. Four years of providing this data with no significant changes to code in the past three years and zero complaints from employees in the past two years about data accuracy.Created third-party Business Solver interface to prepare a daily census file of all active and selected termed employees for use in determining benefits eligibility and deductions required for over 100K employees. Research requests for suspected census discrepancies have dropped to an average of 5 requests per month over the last 2 years, down from approximately 10 requests per month at inception.Created third-party FMLASource interface to provide a weekly census file of all employees who may have eligible hours that should be considered in the event of request for FMLA for over 100K employees. Established process with senior HR management and vendor to identify and add new facilities that may be missing from the file.• Authored Cognos reports to for 3 different payroll processing centers on 401(k)/(l) and Health and Welfare benefit loads mentioned above along with load errors and exceptions and internal quality control reports for HRISLoading weekly 401K/409L deduction changes files from the Principal Financial Group into the employee deduction record on Ultipro using a custom built import for all employees in CHS who had changes to their deduction percentages or amounts Loading weekly Health and Welfare changes files from Business Solver into the employee deduction record on Ultipro using a custom built import for all employees in CHS who had changes to their deduction amounts

Authored drug screen report run in Cognos that utilizes SQL Server generated SHA hash value and double randomizes the selection of employees by one or more facilities for monthly screening selection. Assisted implementation team in preparing data for conversion to Ultipro from HMS payroll systems by building automated Excel and Access utilities to prepare worksheets for opening balance analysis of earnings, deductions and taxes Created Access database to automatically scrape the State of Pennsylvania tax web site for local and school district tax information in support of converting PA facilities. This eliminated all manual labor previously associated with gathering this information and thenceforth was used by payroll once a year to update rates.

MS Access database maintenance/development to a defined standard as part of a team of analysts in support of Billing Operations, Member Operations, Partner Operations, Cash and MarketingMade enhancements to Claims Reconciliation database (MS Access) used by Member Operations to automate creation of “Rollforward” report that rolls totals of insurance claims incurred, denied and paid from The Hartford into one spreadsheetBuilt new Postcard Survey database to meet updated business requirements to send postcard notices to customersAssisted with development and automation of Cognos business intelligence reports Revamped letter generation process for hard decline responses from previous Word mail-merge setup to Access generated lettersBuilt Chargeback database using MS Access in support of Billing OperationsConverted legacy Point of Enrollment letter database to updated MS Access standardProposed deployment of Toad For Data Analyst to assist with late-night SQL execution and automated report generation. Proposal accepted and TDA deployed to 4 reporting analysts

Wrote Over 100,000 lines of SQL code that delivered 12 variations of monthly detail and summary data deliverables for booking and revenue reserve reports to senior directors and AVPs via TOAD for Data Analyst script automation with Excel outputCreate the licensing department's first original in-house reserve forecast projection utilizing more than 90 ODBC pass-through queries against several Oracle 11g databases to forecast worst-case at-risk revenue earned but not received up to six months ahead.Automated Excel reports, update pass-through queries, maintained and enhanced existing Access code in databases supporting sales, marketing, legal, financial and executive reporting needs. Develop reports and automation tools as needed.Created user-level documentation and Access database management workflow processes.Assisted project manager in the creation/development of new critical reports driven by key performance indicators using Toad for Data Analysis. Twelve daily reports and 3 monthly reports deployed to production. Provided first-level programming support for 30+ Access databases. Updated VBA code, modified code and forms, and created new code modules as necessary to meet business requirements.

Tracked disease management and lifestyle management services provided to over 25,000 health plan members per month.Created:• Oracle 9i scripts to process member, billing, health plan and program data. • Spreadsheets necessary to fulfill the monthly invoicing and revenue booking procedures for a business unit with over $7M in annualized revenues. • Ad-hoc queries to respond to RFI's of Finance Director, Information Technology, and Accounting colleagues. • Created and updated billing procedures documentation.

Assisted in monitoring the status of over 1K Windows and 1K Unix servers as part of the Nashville Regional Data Center corporate data center computer operations team. Participate in routine daily team operations to include automated tape library retrieval and loading for disaster recovery, tape placement and retrieval from individual servers, executing backup and restore jobs, running occasional print jobs, and monitoring and reporting on PEM alerts affecting server status. Periodically included loading updated ICD and DLG codes onto Meditech servers and supported inventory management by processing in new equipment into BMC Remedy Configuration management database

Execute the daily processes of backup tape placement, retrieval and storage as part of the computer operations and tape library team for approximately 5K tapes per day.

B.S.B.A., Business Administration And Management, General, Magna Cum Laude

Activities and Societies: Delta Epsilon Sigma

Associate Of Arts And Sciences (A.A.S.), Computer Information Systems