OBJECTIVE

• Highly experienced and skilled Database/BI specialist with a unique and unparalleled passion for creating elegant, high - performing SQL code for OLTP and multidimensional Database environments. Eager to utilize 24 years of IT experience including 20 years working with Microsoft RDBMS and BI technologies to help clients and colleagues achieve their strategic objectives.

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

SQL Performance Tuning Expert/ SQL Developer

Responsibilities:

• Served as the SQL Server Performance Tuning Expert tasked with optimizing the stored procedures, functions and ad-hoc SQL the runs Donnelley Financial’s Arc Reporting platform, a .Net/SQL driven Financial reporting platform used for SEC filings
• Designed and documented an advanced testing methodology for performing "before and after" stress testing when making changes to functions and stored procedures
• Rewrote poorly performing, cursor-based T-SQL queries to leverage highly optimized set-based code reducing query time from minutes/hours to seconds or even milliseconds
• Assisted with re-writing code to leverage new SQL Server 2016 T-SQL features such as advanced window functionality, new built-in string functions, columnstore and memory optimized indexes, and memory-optimized code
• Identified and remediated application design flaws which inhibited parallel query execution, further improving stored procedure and function performance by a factor of 10+
• Identified and tuned SSIS packages which includes remediating poorly performing ad-hoc T-SQL, stored procs and functions
• Leveraged SQL Execution plans, DMV's, open source tools such as Brent Ozar’s First Responder Kit and sp whoisactive, Idera to identify and tune poorly performing queries
• Providing performance tuning related mentoring, training, documentation and “lunch and learns” as needed

Confidential - Chicago, IL

Senior DBA/Performance Tuning SME

Responsibilities:

• Was hired by the Database Manager to establish a PerfOps team with another member of her DBAs - focused specifically on ensuring the fasted SQL code possible was released into Production
• Established and documented T-SQL, SSRS and SSIS coding best practices for fellow DBAs and dozens of developers across multiple teams including Data Science, Business Intelligence and Automation
• Provide DBAs, Data Scientists and Developers with advanced SQL training and mentoring, specifically on how to write superior functions, stored procedures and ad-hoc SQL while leveraging advanced set-based SQL principles for writing leaner, faster code while also leveraging new SQL Server 2016, 2017 and 2019 T-SQL features
• Used SentryOne for identifying the slowest and/or most expensive queries and tuned them as needed, often reducing execution time from hours or minutes to seconds or milliseconds and dramatically reducing the amount of SQL code required

Confidential - Chicago, IL

Senior Database Developer

Responsibilities:

• Worked on a team of two architects, one BI Developer and a Junior Developer to leverage the MS BI stack and provide operational reporting, BI and advanced analytics to Loan Officers, Underwriters, Vice Presidents and C-Level executives
• Served as the company T-SQL/PostgreSQL performance SME establishing SQL coding best practices and mentoring programmers of all skill levels how to replace bloated and poor performing queries with lean, re-usable, ridiculously fast and mathematically sound SQL code
• Performed most DBA related tasks for GR's on-prem and AWS SQL Server instances (2008-2017); this included establishing and enforcing best practices, performing most HA/DR related work, new SQL Instance setup and configuration, troubleshooting, performance monitoring, metadata management and overall system tuning
• Created two SQL “libraries”; one for streamlining common database administration tasks and one for handling a variety of ETL, reporting and analysis related tasks including handling complex date logic, navigating hierarchical data structures, text cleansing/mining/analysis and natural language processing
• Was responsible for choosing our department’s source control system to manage all SQL Server related DDL, DML and DCL code in our local Git and remote GitHub repositories
• Was actively involved in the selection, screening and hiring and mentoring of new Developers

Confidential - Rosemont, IL

Senior Database Architect

Responsibilities:

• Built a customized, high-performing hierarchical SQL Server schema utilizing adjacency lists, nested sets and binary sort paths for fast data retrieval and manipulation
• Was responsible for developing SSIS packages to support AJRR BI/DSS needs
• Developed scripts for performing high-level text analysis for the purposes of data cleansing, transformation and deduplication
• General performance tuning and application of SQL Server 2008R2 and 2016 systems

Confidential - Chicago, IL

BI/DW Developer

Responsibilities:

• Responsible for planning, developing and maintaining Confidential /O Confidential 's small business data warehouse for reporting using SSIS 2012 (including MDS and DQS) on SQL Server 2012/2014 instances with a primary emphasis on performance tuning and data quality
• Dramatically improved the performance of slow ETL loads and reporting queries by rewriting and redesigning the associated functions, stored procedures, ad hoc queries, and views. Further improved performance by redesigning and creating new clustered and nonclustered rowstore indexes including filtered indexes, indexed views and columnstore indexes
• Responsible for identifying and implementing new SQL Server features designed to improve query performance; this included utilizing new T-SQL language enhancements, performing in-memory optimization, and performance tuning with Extended Events

Confidential - Chicago, IL

Information Management and Analytics Consultant

Responsibilities:

• Design and develop end-to-end Microsoft BI solutions utilizing SSRS, SSIS and SSAS for some of Slalom's largest clients including two of the largest software companies in the world
• Utilize my T-SQL expertise to identify and remediate poorly performing SQL queries
• Took the lead in developing and documenting the T-SQL best practices that Slalom consultants and architects use when delivering or enhancing data warehouse/BI solutions
• Worked on one project where we created an AWS Redshift-based Data warehouse solution
• Provide new Business Intelligence consultants with mentoring and training

Confidential - Chicago, IL

Sr SSRS/BI Developer

Responsibilities:

• Responsible for converting several dozen reports developed in Crystal Reports into dynamic SSRS based (2008 R2) reports using T-SQL, MDX, .Net CLR, XML and XSLT
• Served as the resident SME on performance tuning stored procedures, functions, T-SQL scripts, indexes and SSIS packages; frequently rewrite stored procedures to run in seconds instead of minutes (or even hours); recently cut ETL load time from over 9 hours to under 5 hours
• Took the lead initiative in developing and designing a metadata-driven dynamic sorting/grouping/breaking architecture for Spenser Stuart OLTP and OLAP based SSRS reports
• Assisted and mentored ETL and SQL developers responsible for developing SSIS based ETL packages to support our data warehouse/Business Intelligence (BI) system and reporting architecture