Jeffrey Fletcher, Phd, Mpa Email & Phone Number

Des Moines, Ia, Us

Des Moines, Iowa

Leading the Bureau’s programming processing and programming requirements associated with secondary CTE data received from Iowa’s school districts, as well as the development of the state performance accountability plan as required by the Carl D. Perkins federal legislation. Leading the development, negotiations, and monitoring of the performance accountability plan for each of the fifteen community colleges and community school districts in Iowa as required by the Carl D. Perkins federal legislation.Lead for IowaGrants system updates, maintenance, and management of state and federal grants, as well as creating guidance documents, resources, and delivering webinars to the field for technical assistance for state’s secondary and postsecondary sub-recipients. Developing and maintaining professional working relationships with K – 12 school district officials and other partners that are responsible for CTE data and accountability. Providing Bureau staff with analysis and reports associated with each year-end state and federal reporting, particularly as it relates to career and technical education performance.

West Des Moines, Iowa

Creating and analyzing weekly, monthly and quarterly key reports that track agency, territory, region product, niche, and/or state level performance.Analysis includes determining the cause of year-over-year differences, understanding and communicating components of a data element or variance; ensuring data used in a report has a comparable basis and is able to explain its data source.Managing Access, Excel, SQL databases and database connections to ensure scheduled and ad-hoc reporting is accurate, including table/query management.Identifying and troubleshooting situations when data appears incorrect or inconsistent and recommending solutions to resolve the situation.Exploring and implementing solutions to improve the efficiency of reporting and analysis.Developing ad-hoc queries and reports from multiple data sources (Access, Excel, SQL, and others) to support internal and external customer requests.Designing special reports and analysis based on limited information requests and determining appropriate and comparable data be used to fit all special requests.Helping insurance agents understand how their production is helping them achieve commission and bonus levels and explaining what data is available to help them maintain the quality of their book of business from a loss ratio perspective.

Ames, Ia

Responsible for the importing, cleaning, organizing, analyzing, forecasting and visualizing 10+ years of business pricing, raw material use from a SAP system that utilizes Excel, RStudio and Tableau. Design data experiment oversight to investigate and reveal trending and patterns for the development of predictive models to enable the company to better manage their business. Adapt multiple statistical testing techniques to discover conclusions and relationships.Cut material and logistic costs, saving nearly $500K. Raw materials and freight costs continued to increase, impacting profit margin. Cleaned, analyzed and visualized five years of raw data from company SAP and ERP systems. Pinpointed and forecast specific raw materials and feed stocks where the company could save money. Savings opportunities for raw materials amounted to hundreds of thousands in savings annually.Created interactive dashboards to visualize and forecast procurement data. Transformed raw data from CSV Excel files into valuable insights. Used collaborative approach to solicit business requirements and concepts from leadership. Demonstrated the value of Tableau by developing automated dashboards with advanced analytics and visuals. United data from company SAP system and made causal and relationship models of business processes.

Ankeny, Iowa

dba Mom's Meals NourishCare Managed the revenue cycle reporting function. Partnered with cross-functional teams and leadership to increase business effectiveness. Helped meet strategic plans by improving data quality. Developed standard scorecards, ROI, data metrics, value added information and performance KPI’s. Collaborated on internal database design improvements for better reporting systems. Improved cost, throughput, front-end and revenue cycle and billing efficiencies. Lowered bad debt from 7% to ~5%. Company write-offs for bad debts gradually increased to 7%. Tasked to determine the cause and eliminate inefficiencies. Worked through years of raw data covering financials, accounts receivable, sales, and claims. Found opportunities and tightened up processes in create a best practice environment. In six months, write offs and bad debt trended down companywide. Improved cost, throughput, front-end and revenue cycle/billing efficiencies by turning raw data into value-added information and reports using a combination of Excel, Access, and RStudio.Applied knowledge of business to provide strategy and policy recommendations by synthesizing raw data to frame stories, trends, and forecasts for C-level leadership.Developed standard scorecards, data quality matrices, and KPI’s for performance management and incentive programs and ROI models to track results for process changes.Conducted exploratory data experiments and created valuable reports out of assumed unusable information. Consulted with other business units to identify cross-functional data analytics needs.Collaborated on internal database design improvements (Microsoft Dynamics AX and CRM) for better reporting functionality.

Ames, Ia

Improved data collection management, relational databases, processes, and statistical analyses by working and partnering with university IT personnel in addition to troubleshooting problems, generating reports, and producing stable solutions. Lowered administrative inefficiencies by 25%. Campus inefficiencies hindered operations output and the student experience. Led research projects and institutional research, market research, strategic planning and policy efforts. Streamlined departmental processes and operations. Increased student placement by 5%, student retention by 4% and cut processing and administrative inefficiencies by 25%.Delivered information projects 37% faster than average completion time. Historical processes and reports were slow and inaccurate due to paper documents. Used SharePoint, Qualtrics, MS Excel, SAS, and Access to reorganize and mechanize processes. Streamlined efforts in the compilation and dissemination of accreditation materials. Projects became best practice model for future academic departments to follow.Led research projects and initiatives, e.g., institutional research, market research, strategic planning and policy strategies.Involved directly in the technical build-out of university data warehouse; query tools, data flows, and dashboard designs. Worked with faculty and administrators to identify analytical needs, defining business requirements, report designs, and analyses.Translated business needs into actionable insights by partnering with university IT to enhance university data warehouse and data management. Fashioned new ways to streamline departmental processes and operations: Scholarships ($200K per year), student placement, curriculum plans, outcomes assessments, course fees and catalog updates, and web page information and forms.

Ames, Ia

Supervised a team of undergraduate teaching assistants, and ensured the development of their professional skills.Invented unique spreadsheets and surveys to manage and organize courses along with resolving student questions/concerns effectively.

Eden Prairie, Mn

Created innovative PivotTables and PivotCharts for dissemination across multiple mediums to share information in the production of policy briefs and reports.Organized the enhancement of a variety of administrative tasks and operations by creating different approaches and fresh ideas.

Chanhassen, Mn

Application of skills in verbal communication, promotion, customer service, sales, and customer relations

Chaska, Mn

Assembled heating and cooling radiator coils according to specifications.

Doctor Of Philosophy (Ph.D.), Education, Educational Leadership, Graduate School

Activities and Societies: Pi Sigma Alpha

Master’S Degree, Public Administration, Graduate School

Activities and Societies: Graduate teaching assistant in the political science department, Vice President of MPA clubGraduated with honors.

Bachelor’S Degree, Political Science

Activities and Societies: Pi Sigma Alpha, WSU Rugby, Political Science AssociationDeans List - Fall 2007, Spring 2008, Fall 2008, Spring.