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.

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.

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.

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.

• 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.
• 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.

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.

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.

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.

• 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.

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