Todd Wohlrabe Email & Phone Number

Decatur, Illinois, United States

Monitors and maintains the day to day data processes (SSIS tasks, automated services, etc...) for the analytics group. Administers the Tableau Server including developing views and dashboards, supporting user access and licensing, and optimizing tasks. Database owner who creates, updates and maintains tables, stored procedures, views, indexes, etc...Key Achievements• Created new database combining 3 legacy databases and develop all relevant processes• Improved stored procedures for determining freight rail rates by reducing run time by 85%• Developed system for identifying problematic indexes that provides queries to improve performance• Recreated preexisting ETL and update stored procedures resulting in saving 15% across all scripts• Created system of takes Tableau Visuals and automatically emailing them to non-Tableau usersRelevant Expertise• Coded, Tested, and Executed SSMS Tables, Indexes, Stored Procedures, etc...• Installed, Configured, and Maintained Tableau Server and administered user security• Created complex visuals and dashboards in Tableau Desktop• Used C# and Javascript in developing web applications• Developed and maintained C# scripts for accessing and executing DB2 scripts

Lincolnshire, Illinois, United States

Took client data to create profile and ad-hoc reports for internal data analysis and to spot inconsistencies in the data. Performed numerous data cleansing techniques from manual work to fully automated editing system. Loaded and reconciled said data to the mainframe.Key Achievements • Created new report process that validates balance data before loading to production • Created new edit report that saves conversion manager 4% of time and can be used on future clients • Created a set of SQL queries that cut down the number of non-recordkeeper duplicate rows by 25% • Acted as coach / mentor / leader to junior associates with respect to standards and best practicesRelevant Expertise • Code / Test / Execute Informatica mappings, edits, and processes to facilitate data importation • Transformed data from flat files to CICS mainframe environment (OS/390) • Staging relational databases in Unix built with DB2 architecture and ODBC connections • Submitted batch processing JCL jobs on the command line as well as in Control-M

Chicago, Illinois, United States

Responsible for daily data uploads from 50+ mobile computers to application database. Accountable for daily data validation for completeness and correctness of said data.