Lee Thames Email & Phone Number

Jacksonville, Fl, Us

Jacksonville, Florida, United States

Lead contact with IT on migration of HD Supply AR Data into SnowflakeManage consolidation of key metrics across 2 systems.Build reporting tables and queries in Snowflake to be published in TableauConsolidate reports across 2 AR teams

Jacksonville, Florida Area

Built SharePoint site, sub-sites and permissions for all departments Credit Services - Collections, Credit, Cash Applications, Billing, Customer Master and Reporting.Created SQL Library for SSMS queries and store procedures and implemented version control on over 60 Daily, Weekly, Monthly, Ad-Hoc reports as well as 3 ETLs.Partnered with Billtrust to automate loading of invoices to 5 customer’s 3rd part portals. Currently more than 5,000 invoices per month.Lead Customer Master Team to decrease backlog of requests from over 900 to 200 and transition team to HD Supply management.

Jacksonville, Florida Area

Responsible for one Sr Analyst delivery of daily, weekly and monthly Accounts Receivable SQL reports. Provide ad-hoc information and analysis as requested by collection supervisor and management.Additional Responsibilities – • Manage Reserve on Doubtful Accounts.• Assembled various independent reports and created uniform monthly Credit and Collections report.• Standardized over 10 weekly reports on a single table loaded from Data Warehouse• Standardized over 7 ad-hoc reports to speed up deliver to collectors and customers.• Partnered with IT Data Warehouse Team to Build and deploy over 5 SQL/Report Builder reports to the Report Portal

Jacksonville, Florida Area

Responsible for managing 10 to 15 SQL Developers supporting Mortgage Servicers, Attorneys, Operations and Finance producing ad-hoc reports and stored procedure development for Crystal Reports deployed via Business Objects web portal. The reporting environment uses MS SQL 2012 databases populated from replicated production tables.Additional responsibilities include managing special reporting requiring large SQL ETL jobs which aggregate data daily for Performance Reporting for Mortgage Servicers, Attorneys and Operations.>> Lead development of Billing reporting for Finance and SLA reporting for Operations and Servicers. The Billing and SLAs jobs span more than 40 Services (Foreclosure and Bankruptcy) and 15 clients.>> Managed completion of more than 500 report changes (requests) in 2014. >> Lead migration of 4 Databases from SQL 2008 to SQL 2012. Approximately 250 SQL Jobs, 50 tables, 15 LOVs, and 500 Crystal Reports.>> Manage report security for Operations, Servicers and Attorneys.

Jacksonville, Florida Area

Responsible for Client and internal reporting and analysis. Create and manage dashboards to drive strategic plan.>> Automated and deployed via SSRS report portal over 45 reports supporting HBA, DRG and Short Stay audit programs. These included weekly, monthly and parameterized reports for both internal operations and external client use.>> Developed, deployed and supported dashboard system of more than 25 linked Excel Spreadsheets aggregating results across 12 programs, 14 clients and 2 operations divisions.>> Utilized SSIS to load data from Client provided Excel spreadsheets to automate reports for more than 5 programs and processes.>> Deployed OLAP cube via SSAS for Retail Pharmacy program.>> Performed four-year statistical analysis of % Net Savings of completed HBA Audits. Results showed decreasing net savings but no correlation to the variables used in the analysis. >> Supported existing SAS reporting

Reporting and Performance Data Analytics Led team of 10 analysts supporting over 20 Clients. The team provided operational reporting, client reporting, contractual Service Level Agreement (SLA) reporting, and analysis globally.Led Development of SLA Management Tool to manage risk of $4M in monthly penalties. Reported on over 300 SLAs weekly; 700 SLAs Monthly - across 20 clients in all 4 Global Regions and 10 Service Centers in 8 CountriesCreated new ‘graphical-only’ reports to pro-actively support the two largest Global HR BPO Implementations in history >>Real-Time volume reports to identify intra-day spikes requiring operations attention >>Real-Time reports for key SLAs alerting operations to potential process problems >>Daily Trended Volume reports versus planned volumes to alert operations to potential staffing issuesTo further isolate problem areas the reports were divided by Service Tower and Region:Call Center, Payroll, HR, Benefits, Recruiting, Compensation, Learning, and ITAsia Pacific, Europe/Africa/Middle East, Latin America and North America, Delivered monthly Dashboard/Scorecard for Employee Care Business Unit. Managed collection and reporting of over 50 metrics to Sr. ManagementLed team to create and deploy over 2,500 report on Business Objects Report Portal in 4 yearsManaged creation of Processes and deployed workflow in SharePoint– >>Report Development Life Cycle >>Work Request ProcessSupported building, training and right-shoring of work to peer Analyst team in India to reduce cost of staffing growth and support Asia OperationsLed and responsible for HR Management Data/Reporting/Business Intelligence Strategic Plan 6-Sigma Green Belt

Led IT Asset Management initiative from inception. Developed business case, directed cross-functional team through RFP process for tool selection.Implemented Asset Management tool and Auto-Discovery Tool (LANDesk) for more than 10,000 Desktops and 700 Servers.Drove change in company on contract management, desktop refresh/support processes, procurement, warehousing/inventory service, disposal, and desktop software licensing

Responsible for $80 million O/E and $5 million Capital budgets.Collaborated with Operations leadership to provide ROI analysis and financial models for initiatives, including Microsoft Enterprise Licensing Agreement in 2001.Report and forecast financial results monthly.

For Conrail Acquisition; responsible for managing Reports and Measures Team. Represented Technology with Business Partners to coordinate work across entire company and ensure a smooth transition on Split Day.

Responsible for managing CSX’s $25 million Leased Services and $20 million Capital Budgets. Managed billing under the CSX/AT&T Managed Services Agreement. Focal point for Communications Performance Improvement Initiatives.

Teaching Assistant

Project Manager, Estimator, Purchaser on Prime Federal Government Contracts throughout the East Coast.

Applied Mathematics Masters Program

33 Graduate Mathematics Hours

Ba, Applied Mathematics