Jared Westover Email & Phone Number

Indianapolis, In, Us

Chicago, Illinois, Us

Key Responsibilities & Accomplishments:Database Development & Optimization:• Created and modified complex stored procedures for OLTP and reporting, improving data access and system efficiency.• Collaborated with developers to write efficient T-SQL stored procedures, views, and functions, enhancing application functionality.• Implemented Query Store in SQL 2017 environments to pinpoint low-performing queries, significantly improving performance.• Tuned poorly performing queries by creating nonclustered, filtered, and columnstore indexes, boosting query performance and reducing resource consumption.Reporting & Analytics:• Designed and implemented on-premises and cloud-based Power BI infrastructure for the Tax business unit, enhancing reporting capabilities.• Designed SSRS paginated reports, providing actionable insights into application performance.• Served as the technical data lead for the Tax business unit, managing pull requests and conducting initial data modeling reviews to ensure data integrity.Cloud & Infrastructure Management:• Assisted in performance troubleshooting for massive datasets in Azure SQL DB, reducing query execution times.• Implemented a range of Azure resources, including SQL Managed Instances, Azure SQL DBs, and Data Factory pipelines, to streamline data processing and integration.

Chicago, Illinois, Us

Key Responsibilities & Accomplishments:- Designed and implemented on-premise and cloud Power BI for the Tax business unit.- Created and modified complex stored procedures used for OLTP and reporting purposes.- Served as technical data lead for the Tax business unit. This role included pull requests and initial data modeling reviews.- Assisted in performance troubleshooting for massive data sets on Azure SQL DB.- Coached developers in writing T-SQL stored procedures, views, and functions.- Designed SSRS paginated reports, allowing insights into application performance.- Implemented Query Store in SQL 2017 environments, pinpointing low-performing queries.- Tuned poorly performing queries by creating nonclustered, filtered, and columnstore indexes.- Implemented various Azure resources, including; SQL Managed Instance, Azure SQL DB, and Data Factory.

Draper, Ut, Us

Specializing in creating educational content and technical tutorials on a variety of SQL Server and data-related subjects, including:T-SQL Programming & Optimization: - Capturing Logic with Stored Procedures in T-SQL - Handling Errors in T-SQL - Troubleshooting Your First Low-Performing T-SQL Query - Optimizing Query Performance with Columnstore Indexes - Mastering Recursive Queries in SQL ServerReporting & Visualization: - Implementing SSRS Report Layouts - SSRS Data Visualization Playbook - Load Data into Microsoft ExcelSecurity & Best Practices: - Securing and Maintaining Stored Procedures in T-SQL - Upgrading Your T-SQL Interview Skills

Newark, De, Us

Key Responsibilities & Accomplishments:- Managed the Project Online environments, which involved supporting over 300 IT and business users.- Designed a suite of interactive reports using SSRS for the Project Delivery Office. These reports provided critical insights to IT Executives.- Created a process using SSIS importing Excel workbooks used by multiple Application Development teams containing initial Project Estimates.- Maintained all operations related to several instances of SQL Server 2014/16, including database backups, index maintenance, and user security.- Configured an ETL process for the Project Online reporting database using an OData connection with SSIS and SQL Jobs.- Utilized SharePoint Designer to create and maintain complex Project Web App (PWA) and standard workflows.- Administered most aspects of Visual Studio Team Services.

Us

Key Responsibilities & Accomplishments:- Designed stored procedures, primarily used for importing and exporting data. Requirements included creating file headers/footers, archiving files processed, and creating error logs.- Created a series of logging stored procedures to allow import modification tracking without using database triggers for SOX compliance.- Coached junior developers on creating T-SQL objects.- Other duties included: create & deploy reports with SSDT, modify existing SSIS packages for importing/exporting data, and scripting database objects to deploy.- Created an application with C# converting documents to PDF with a distinct naming convention and folder structure.

Indianapolis, In, Us

Key Responsibilities & Accomplishments:- Produced complex business reports in SSRS dealing with home mortgages.- Constructed views, materialized views, functions, packages, stored procedures, triggers, and sequences in Oracle 11.- Developed and supported custom ETL applications that load specific loan-level action events.- Assisted in the development of a new OLTP application using WPF, C# & Toad 12.- Improved vendor SLA process through a series of SQL objects, packages, views, and tables. Providing precise loan level details for the collateral underwriting team in mortgage banking.- Designed a series of new Oracle database validation procedures for vendor invoice payments.- Developed, tested, implemented, and supported custom DBMS jobs within an Oracle 11 environment.- Created technical and business documents related to the implementation of a new Oracle schema.

Alpharetta, Georgia, Us

Responsible for supporting and developing the corporate and product websites for the ERP and CRM lines of the business. This required working extensively with the Marketing, Sales, Support and Education departments to maintain and enhance the CRM and Case Management Systems; which were heavily integrated with one another using web services, SQL Integration Services (SSIS), and import utilities. Additionally, I assisted in creating processes around the SDLC lifecycle including change control, code reviews, and programming best practices which reduced production deployment issues by 90%.Key Responsibilities & Accomplishments:- Mentored and trained a team of analysts on application deployment best practices, located in India.- Managed internal change request triage meetings to review application code changes before deploying them to production.- Partnered with various business units to gather requirements and align technical solutions with business efficiencies, noting the varying business objectives.- Modified and created SQL stored procedures, triggers, views and analysis cubes within the corporate data warehouse.- Maintained system integration processes within data warehouse utilizing SSIS.- Created and modified reports for Sales, Marketing & Support utilizing SSRS 2005 and Crystal Reports.- Administered IIS for external and internal facing customer sites.- Developed the internal facing case management system using C#.- Headed a project to move www.compiere.com from a Linux/Apache platform to Windows 2008/IIS 7.5 while configuring a server farm to offload the JBoss Compiere application.- Aligned with the Marketing and Infrastructure groups to replace legacy www.consona.com sites with a Drupal and PHP platform. Implemented Drupal with MSSQL 2008 R2 (Mirroring) & IIS 7.5.

Indianapolis, In, Us

- Managed a team of 12 Support Engineers and Team Leaders located in both the United States and India.- Acted as a liaison for Customer Account Managers to resolve hot customer accounts and issues.- Designed and maintained the department budget in PowerPlan; while constantly monitoring employee expenses.- Worked with the Support Team Leaders to formulate individual objectives for the department Analysts and Engineers.- Frequently led department meetings to address questions related to support process, original initiatives and department goals.- Maintained frequent contact with troubled and challenging customers via phone, email, and in person.- Worked directly with the Customer Loyalty Advocate in resolving critical customer account issues for a mutually beneficial outcome.

Indianapolis, In, Us

- Managed and mentored a team of 6 Support Engineers.- Provided quarterly and yearly performance reviews, one on one coaching and frequent feedback.- Conducted ERP and SQL specific education classes.- Facilitated communication for temperamental customer accounts; while being a central point for case escalations.- Collaborated with Product Management for input on design and release plans for future software updates.- Administered and supported the external facing M2MVIP.com customer portal.- Visited several customer sites to troubleshoot performance, configuration & user experience issues.

Bachelor'S Degree, Information Technology

Education record