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.

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 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
• Redesigned daily reporting process for a high volume client which reduced job failures by 95%.

• 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.
• Produced monthly financial executive summary for parent company and executives.
• Created and… Show more
• Created and maintained capital expenditure ROI model.
• Led annual budgeting and quarterly forecasting processes

Bachelor Of Arts, Economics And Spanish

Masters, Business Administration; Finance