Architect an end to end solution for reporting across four business units that use separate software solutions.Implement an operational data store (ODS) to keep snapshots relevant data in of each of the source databases taken on 10 minute intervals to provide more precise tracking of changes in all systems.Develop fully configurable SSIS packages to populate the ODS tables and process data from the ODS into the warehouse.Researched and demoed several dashboard platforms, ultimately leading the final product decision.Create data models in Qlik Sense for the enterprise data warehouse and legacy reporting sources to provide improved data discovery tools to the enterprise.Design and implement a complex security model fully integrated with Active Directory to restrict the records made visible in Qlik Sense to various users and user groupsManage the performance and guide the task list for 2 resources in Database department.Oversee consultants providing 24-hour database monitoring, guiding budget allowances and project engagements.Continue to administer and monitor the health and performance of all databases across the enterprise.

Designed a data warehouse to store operational and accounting information.Implemented an ETL process with SQL Server Integration Services to process updates from various sources (SQL, CSV, XML)Developed Analysis Services cubes to provide business users with ad hoc reporting capability via PowerPivot in ExcelCreated and maintained a catalog of SSRS reports for internal and external users.Formulated automated maintenance plans for index maintenance, proper backup solutions and updated statistics.Optimized existing stored procedures and implemented methods to identify poor performers for review.Implemented log shipping and transactional replication to create near real time copies of production databases to decouple reporting and ETL processes from user requestsDevised a branching model in Git for internal Developers and oversaw the transition from Visual SourceSafe.Set up SVN repos to store project work that required exclusive locking.

Developed Windows & web services to facilitate integration of the TMS system with accounting systems & web applications.Designed and implemented a driver portal website through which users could access their own settlement reports & view information about their performance.Created pixel perfect SSRS reports to serve as invoices and rate confirmations and the functionality to generate these reports on demand through the application.Continued to provide application support, fix bugs, and implement new functionality in the TMS.Automated the release process of the TMS and supporting applications and services and implemented a system to allow for more rapid and reliable rollbacks to previously released versions.

Developed T-SQL stored procedures to provide necessary data for a TMS application.Implemented necessary functionality in data access, business logic and UI layers of the n-tier design.Assisted with quality assurance testing and system deploymentsProvided user support and rapidly fixed bugs in the TMS