Todd Daniels Email & Phone Number

Springfield IL

• Hired as a full time colleague after 8 years of consulting to head up multiple IT initiatives. Included in these initiatives:
• Implement a BI strategy for the enterprise, utilizing Microsoft Power BI for analytics to empower executive management to make organizational decisions. Designing the data architecture and creating all the ETL.
• Upgrade an existing SSIS SQL Server 2008 R2 production environment to SQL 2016. Design a roadmap and action plan to upgrade hundreds of packages to the new environment and standardize and optimize those packages in.
• Maintain Powershell scripts to help automate SQL servers as well as other processes in the organization.
• Generate install scripts to help automate the installation of an ever growing number of SQL Server servers (VM and physical).
• Upgrade an existing SQL Server Reporting Services 2005 environment to SQL 2016. Current system has over 1000 reports and 2000 subscriptions. Design a project plan and action plan to ease the pain of upgrading the.

• Senior Data Conversion Specialist
• Responsible for the analysis of customer data in legacy systems and ancillary data sources. Designed all data conversion tasks, including mapping, extraction, cleansing and validation.
• Created data models for PensionGold’s ad-hoc reporting solution as well as enhancements to the user front end.

Springfield, IL

Client: Hospital Sisters Health Systems (8 Years)Involved in upgrading both in-house and vendor databases (many several TBs in size) as well as do a SQL Server “sizing and performance” check to see which servers could be consolidated. Helped instruct client with Backup/Recover and High Availability strategies. Designed reports in Reporting Services to help.

Elgin, IL

• Designed and implemented several systems to help streamline current processes as well as make information available to company executives.
• Designed and developed several systems in ASP.NET and SQL Server to help streamline their overall processes and dataflow.
• Designed and implemented a Web Service to pull in datasets from the existing JD Edwards system for use in other systems.
• Designed several reports in SQL Server Reporting Services (SSRS) for review by the executive committee.
• Designed an import/export utility to allow them to manipulate orders in an existing applicationPerformed database administration on SQL Server 2000/2005.

Addison, IL

• Started on the Implementation team, writing custom applications and database queries for various project managers’ needs. After company structure changed was moved to product design and development.
• Worked extensively with various tools for development including: ASP.NET (C# and VB), MS Access, SQL Server, SQL Server Reporting Services, Visual SourceSafe 6.0
• Designed several ETL (Extract, Transform, and Load) data loading systems using ASP.NET, SQL Server DTS packages, and stored procedures
• Worked with the end-users and administrators to design the layout and formatting of the import/export flat files for several different applications
• Trained end users on how to utilize the import/export applications that I designed
• Designed and automated import/export processes using DTS packages and stored procedures to allow files to be imported automatically off of remote sites

Vernon Hills, IL

• Worked with a team of four other developers to develop the flagship application for the company separated into five separate modules. The project was written in.NET with both SQL Server and Oracle backends.
• Developed and designed a completely dynamic reports and charting system that allowed users to create their own reports by automatically creating SQL statements and dynamically creating the visual aspect of the reports.
• Developed a middle tier server (one for SQL Server, one for Oracle) that sent a serialized XML dataset from the database server to the client application
• Primary DBA for the development team

Libertyville, IL

• Responsible for all modifications and enhancements made to a robust Accounting package, as requested by the client. Installed the modifications to the software at the client site and made changes to the software.
• Made modifications and enhancements for an existing accounting software package called Traverse, a software package written in a Microsoft Access front-end with SQL Server backend
• Traverse used several MDB files working together as 9 separate modules to make one single application
• Performed database administration for SQL Server 2000, 7.0
• Developed a customized documentation tracking system in Access 2000 to document any changes to the existing software or the creation of standalone programs

Itasca, IL

Worked in the Data Resources department creating reports based on information requested by the client using Microsoft Access 2000 and Excel 2000. Acquired the data for the reports from a Tandem mainframe server using SQL. Wrote several scripts in VBA (Access 2000 and Excel 2000) to automate the creation of reports. Exported the reports to a PDF file and.