Brian Meredith Email & Phone Number

Mission, KS, US

Manchester, NH, US

• Created or modified ETL pipelines in Azure Data Factory (ADF) for the Enterprise Data Warehouse team.
• Performance tuned poor performing SQL stored procedures to require fewer reads and less execution time, speeding up ETL load times.
• Trained team members on SQL Server functionality, best practices and gave performance tips and development guidance.
• Introduced using SQL Server Change Tracking (CT) to help with incremental loads and greatly improve checks for deleted source data.
• Lead team efforts for a major university wide systems change over. This involved meeting with other teams, figuring out the work to be done, identifying dependencies, and developing and refining the team’s cutover.

Kansas City, KS, US

Created or modified ETL pipelines in Azure Data Factory (ADF). Performance tuned poor performing SQL stored procedures. Improved nightly ETL processing to be more reliable and performant. Worked with server team to improve database setup and performance. Added alerting on job outcomes, and added High Availability to Integration Runtimes and Data Gateways.

New York, New York, US

• Identified and quantified a major avenue for expense reduction. AACER relies on getting federal court data at a nominal fee. In an effort to reduce this cost, discovered an expenditure segment that fully accounted for.
• Developed a modification to daily client reporting that saved several hours of time. This resulted in a near perfect report delivery, and garnering glowing comments from the clients, happy to have their data even.
• Stood up SSRS and SSIS for AACER. Previously no enterprise type reporting was available, and all data needs were either serviced by manual data retrievals or went unfulfilled. By working with users and creating simple.
• Improved SQL processes by working with the development team to create simple, performant SQL code standards. In addition, proactively searched for poorly performing queries, usually through Brent Ozar’s sp_Blitz.

Clinical Reference Laboratory is the largest privately held clinical testing lab in the US. They specialize in doing toxicology screening for pre-employment and continual compliance screening for industries regulated by the Department of Transportation. Additionally they perform a wide variety of screening for some of the largest health and life insurance.

Kansas City, MO, US

PRIMARY RESPONSIBILITIESWrite Data SelectionsUse TSQL to pull data required by Marketing Dept to contact customer base. This includes modifying existing code structure to make it more accurate and performant. Also work with other departments to help them crystalize what data they truly want, alerting them to data considerations of which they may be.

• I analyze SQL databases and create SSRS reports. The primary purpose is to find ways to grow the business and to recoup missed opportunities. I currently work in the Marketing department, as they require speedy and.
• Increased new product funding by almost $3 million, a gain of 14%. A unique system was in place to keep call center staff from being overwhelmed by customer volume that artificially increased lending standards in a.
• Created and maintained Marketing SSRS Reports. Worked with the Marketing and Operations departments to develop new SSRS reports, providing a deeper insight to leads and funding flow. Worked to correct issues in the.

Master Of Arts (M.A.), Economics

Bachelor Of Arts (B.A.), Economics