Thomas W. Flecke, Mba Email & Phone Number

Louisville, Kentucky, United States

Louisville, Kentucky Area

Managed team of four consultants. Subject matter expert (SME) for claims and provider data, reporting and analysis. • Automated 100+ ETL projects via Python.• Created complex queries using SQL Server, Oracle, DB2 and PostgreSQL (Netezza).• Built dynamic user-friendly reports using SSRS, Qlikview and Tableau.• Built positive relationships with multiple groups throughout the organization.• Created and implemented plan resulting in having multiple coverage in all areas of… Show more Managed team of four consultants. Subject matter expert (SME) for claims and provider data, reporting and analysis. • Automated 100+ ETL projects via Python.• Created complex queries using SQL Server, Oracle, DB2 and PostgreSQL (Netezza).• Built dynamic user-friendly reports using SSRS, Qlikview and Tableau.• Built positive relationships with multiple groups throughout the organization.• Created and implemented plan resulting in having multiple coverage in all areas of reporting. • Standardized production team’s project workflow resulting in improved customer communication and shortened project completion time. • Developed associates’ skills by holding monthly sessions to improve consulting techniques, advanced SQL skills and Python skills. • Created consulting guide and implemented peer reviews resulting in greater data accuracy, reduced rework and higher customer satisfaction. • Completed coaching guides with each team member to determine each member’s motivation triggers. Show less

Louisville, Kentucky Area

• Optimized and maintained SAS-based ETL processes. • Decreased report update time from two days to two hours. • Created standardized templates to provide business managers with a tool to facilitate budgeting.

Louisville, Kentucky Area

• Automated existing manual reports via MS Access resulting in increased customer confidence in the data.• Decreased the time required to update the reports from 6 hours per week to 1 hour resulting in $72K in annual savings. • Worked with multiple departments to design a Sales Agent compensation tracker where sales agents could compare their results to other agents. Sales quickly increased, as top agents received bonuses.

Louisville, Kentucky Area

• Created first automated agent status report at SHPS-Medicaid. Compared actual versus goal, ranking against other agents and the three specific areas where each agent most needed to improve. • Automated existing but previously manual reports. Automation decreased the time required to update and distribute reports from approximately one hour to five minutes per day.• Created tools that clearly showed how specific operational decisions impacted financials positively or negatively.… Show more • Created first automated agent status report at SHPS-Medicaid. Compared actual versus goal, ranking against other agents and the three specific areas where each agent most needed to improve. • Automated existing but previously manual reports. Automation decreased the time required to update and distribute reports from approximately one hour to five minutes per day.• Created tools that clearly showed how specific operational decisions impacted financials positively or negatively. Show less

Louisville, Kentucky Area

• Created Cognos cubes, SSRS reports and Excel reports to support 8 clients plus internal departments. • Proactively determined needs of Finance department, gathered requirements and built new SSIS packages, • Trained users how to use latest version of Cognos. Conducted training sessions for multiple teams to instruct how to effectively manipulate Cognos cubes and Reporting Services reports.• Streamlined reports to run faster, consistently on-time and accurately. • Redesigned… Show more • Created Cognos cubes, SSRS reports and Excel reports to support 8 clients plus internal departments. • Proactively determined needs of Finance department, gathered requirements and built new SSIS packages, • Trained users how to use latest version of Cognos. Conducted training sessions for multiple teams to instruct how to effectively manipulate Cognos cubes and Reporting Services reports.• Streamlined reports to run faster, consistently on-time and accurately. • Redesigned daily reporting process for a high volume client which reduced job failures by 95%.• Designed, implemented and maintained data warehouses using SQL Server. Show less

• Built budgeting model and led budgeting process. Received Executive Award.• Led process improvement, standardization and automation efforts. Achieved significant time savings: o Forecast process - saved 30 hours of updating time per quarter. o Intra-month trending - saved 10 hours of updating time per week.o Variance analysis - saved 10 hours of updating per month.• Produced monthly financial executive summary for parent company and executives.• Created and… Show more • Built budgeting model and led budgeting process. Received Executive Award.• Led process improvement, standardization and automation efforts. Achieved significant time savings: o Forecast process - saved 30 hours of updating time per quarter. o Intra-month trending - saved 10 hours of updating time per week.o Variance analysis - saved 10 hours of updating per month.• Produced monthly financial executive summary for parent company and executives.• Created and maintained capital expenditure ROI model.• Led annual budgeting and quarterly forecasting processes • Headed monthly review meetings with executives and call center managers. Show less

Bachelor Of Arts, Economics And Spanish

Masters, Business Administration; Finance