Jonathan Stewart Email & Phone Number

Columbus, Oh, Us

Lincoln, Rhode Island, Us

Columbus, Oh, Us

Principal consultant delivering true high-end business intelligence solutions on various platforms from SQL Server to Teradata and Tableau to PowerBI.

Columbus, Ohio, Us

A Microsoft Certified Partner for more than a decade, HMB helps mid-to-large-sized enterprises leverage technology solutions to meet business objectives. HMB's intuitive, experienced team provides businesses with technology consulting and IT services that help its clients accelerate time to market and gain a competitive advantage quickly and efficiently.

Hanover, Md, Us

Manufacturing/Retail Company - Introduced the concept of an Operational Data Store that will feed their eventual Data warehouse.Created multiple SSAS tabular cubes to meet their growing reporting needs.Enhanced SSRS strategy and built multiple complex reports.Introduced the benefits of ad-hoc reporting using the Microsoft BI Stack and educated users on how to get the most out of it.Converted multiple Crystal reports to SSRS.Provided break/fix support for their SQL Servers.Implemented compression on production SQL Servers saving over 80% of disk space.Tuned the servers for their best performance on the virtual machines using Perfmon, VMWare stats and best practice guides.

San Diego, California, Us

Large Financial Company - Worked on creating an active disaster recovery solution for the Integrated Consumer Data Warehouse using Teradata Unity and Data Mover technologies.Created complex stored procedures and macrosDeveloped automated SVN solution using TortoiseSVN, WinSCP and Putty technologies.Co-developed the logical model used for the back end of the custom Data Mover framework.Wrote custom scripting to enable automation of multiple Unix based processes.Created very complex custom spreadsheets that eased customer creation of new Data Mover jobs and facilitated testing.Used Viewpoint to monitor testing, speed and troubleshoot Data Mover jobs.Large Regional Bank - Worked on a project converting a SQL Server Data Warehouse to Teradata using Teradata’s proprietary data model.Worked with on site and with offshore team to create mapping documents from multiple sources to be used in the creation of the semantic layer. Created, debugged and tested semantic layer views.Converted SQL Server stored procedures to Teradata, optimizing them for the parallel architecture in the process.

New Albany, Oh, Us

Co-developed logical data warehouse tables and fully developed physical model using Kimball methodology.Developed UM,CM, and DM data marts from requirements to fact tables and reports.Developed entire ETL solution for an incremental and historical data warehouse using SSIS and third party tools such as Pragmatic Works’ Task Factory, CozyRoc and Bids helper where applicable.Developed SSRS strategy and built multiple complex reports.Developed SSAS strategy and built multiple cubes for quick business decision processing.Used table partitioning and data compression as integral parts of data warehouse.Provided detailed documentation on entire data warehouse, including objects, data flow and data lineage.Led database migration from SQL Server 2005 to SQL Server 2008 R2.Implemented TDE encryption on servers.Designed and migrated core replication system from SQL Server 2000 to SQL Server 2008. Created test servers, performed regression testing and developed migration plan to move to SQL Server 2012.Performance tuned multiple troubled procedures and jobs by taking a baseline with profiler and server-side traces, and Perfmon and providing solutions to fix bottlenecks and rewrite needed queries while adding and removing indexes as needed.Tuned the servers for their best performance on the virtual machines using Perfmon, VMWare stats and best practice guides. Developed EDI mapping strategies using SSIS to normalize claims and clinical data.Mentored others DBAs and developers on the same techniques.Trained and mentored developers in proper SQL design by having small workshops and design sessions. Developed a maintenance solution that allowed daily maintenance in a small window. Migrated Biztalk to SSIS for file import/export processing.

New York, New York, Us

Led database migration from SQL Server 2000 to SQL Server 2008.Designed and migrated core replication system from SQL Server 2000 to SQL Server 2008.Re-architected multiple databases using 3-rd normal form. Implemented standards via new documentation.Converted reports from Accuate and Access to SQL Server Reporting Services. Provided recovery during multiple critical outages.Developed a robust disaster recovery solution including a detailed backup plan. Automated numerous daily tasks.Created numerous reporting server reports.Performance tuned multiple procedures and jobs with most have a 50%+ improvement.Provided Sybase support for Apollo system.Supported Oracle database systems for web products.

Columbus, Ohio, Us

Designed integration systems between multiple 3rd party applications, SQL Server and AS400.Created data mart to be used to phase out AS400 repository. Migrated multiple applications to SQL Server 2005.Migrated Multiple SQL Servers to SQL Server 2005. Integrated SQL Server with AS400, Lotus Notes and Windows Active Directory environments to facilitate efficient business practices.Developed a robust disaster recovery solution including a detailed backup plan. Automated numerous daily tasks.Created numerous reporting server reports.

Provided in-depth performance tuning resulting in an 18% reduction in CPU use across all servers and significant reduction in stored procedure runtimes utilizing indexing and procedure rewrites.Redesigned database architecture to be easily scalable.Implemented capacity planning of SQL Servers to enable proper scaling of hardware and SAN space.Developed a robust disaster recovery solution including a detailed backup plan. Created program to train employees on SQL Server 2005 and develop new DBAs from with-in the company.Created database standards and ticketing system to increase efficiency in dba workload.Consolidated multiple reporting databases and began a migration to a data warehouse.Automated numerous daily tasks.Installed, upgraded, administered, troubleshot, and provided 24/7 support for a multi-terabyte, high transaction web site running SQL Server 2005.

Installed, upgraded, administered, and troubleshot commercial and infrastructure corporate level database environments using Microsoft SQL Server 2000 and SQL Server 2005 and Reporting Services. Developed a migration plan for all corporate and 3rd party applications. Developed, implemented and completed SQL Server 2005 data warehouse migration. Project. Converted 300+ DTS packages to SSIS with complete rewrites taking advantage of new features. Reduced run times for the load by 40%.Created scripts to automate daily processes and administration. Provided heavy performance tuning and reviewing of code, substantially reducing runtime and cost exponentially by analyzing plans and creating indexes or rewriting when needed.Supported and participated in the development of both desktop and web applications using SQL Server 2000/2005 and the .Net framework. Developed change management process.

Us

Installed, upgraded, administered, and troubleshot commercial and infrastructure corporate level database environments using Microsoft SQL Server in active/passive and active/active clustered environments.Created and updated numerous DTS packages using ActiveX scripting to load IIS logs from web servers with many updates showing over 100% performance improvements. Created standards documentation for installations, disaster recovery, and database design.Created comprehensive database monitor using .NET technologies.Created, maintained and monitored scheduled applications and events.Supported, and when possible, participated in the development of both desktop and web applications.Mentored junior database administrator in the aspects of design, disaster recovery and performance tuning.Created successful Analysis Services proof of concept.Began database implementation of Commerce Server, SharePoint Services, and Business Desk.

Dublin, Oh, Us

Installed, upgraded, administered, and troubleshot commercial and infrastructure corporate level clustered database environments using Microsoft SQL Server, Sybase Adaptive Server, Sybase Replication Server, and DB2 UDB primarily in Windows NT/2000 environments and also UNIX environments comprised of over 80 production and 300 development servers spanning 5 continents supporting countless end users. Responsible for maintaining data integrity of these systems including managing MSSQL replication and Sybase Replication Servers.Managed installations, upgrades, maintenance, disaster recovery plans and 24/7 production support for offerings including Commerce: Network, Commerce: Exchange, NetCool, NetIQ, Gentran, and many other proprietary applications all running Microsoft SQL Server, Sybase ASE, and DB2 UDB all in clustered environments. Managed corporate databases for E-commerce offerings requiring 24/7 production uptime. Created, maintained and monitored scheduled applications and events.Supported and, when possible, participated in the development of all applications leveraging the databases including both desktop applications and web applications.Performed the migration of numerous SQL 6.5 & 7.0 and Sybase 11.92 Databases.

Created and maintained multiple databases in a SQL Server 7 environmentDesigned packages to move data between SQL Servers and AS/400 systems using Microsoft DTS. Provided 24/7 support for databases, servers, and custom application.Provided level 3 help desk support for custom application and Windows 95/98 and Windows NT.Designed and implemented company intranet site using Visual InterDev.Developed and designed databases for numerous projects.Programmed custom apps with software developers.Designed and implemented backup & recovery process.Developed and implemented a security plan on Windows NT and SQL Server.Automated numerous daily processes.Provided 24/7 break/fix support

Bachelor’S Degree, Information Technology

Education record