Craig L. Email & Phone Number

Gilford, Nh, Us

Frederick, Maryland, Us

● Managed Azure SQL Instances as well as on-prem SQL Servers.● Developed a suite of stored procedures that handled all data validation for incoming files from the State of MD.● Performance tuned existing stored procedures that decreased import time from hours to minutes.● Worked with front-end teams to create and enhance data dictionaries which assisted in a more efficient new hire training program.

Boston, Massachusetts, Us

● Performed tuning on dozens of T-SQL Stored Procedures that support realtime tradingoperations. Many Stored Procedures now run in seconds instead of minutes.● Responsible for all T-SQL testing/rewrites during 2008 -> 2019 SQL Server upgrade activities.● Developed and implemented a “Database Health Report” suite of jobs that keep up todate information on both the production and DR versions of several mission critical DBsthat can notify the appropriate contacts when this data gets out of synch.● Designed a system in SQL Server using HASHBYTES that enabled the row by row and column by column compare of vendor DBs. This was utilized to confirm that during DB upgrades the historical data was exactly the same and not restated.● Provided a rich set of messages for the operations team that run the daily jobs. Thesemessages share important information about data thresholds as well as providing queriesthe operations team can run themselves. This eliminated approximately 20% of supportcalls to the data team.

Newport Beach, California, Us

● Architected, designed and developed a slowly changing dimension star schema data warehouse structure for a new product offering● Developed T-SQL based APIs to insert data into and retrieve data from this new data warehouse● Reviewed and recommended performance improvements for HEDIS calculation related stored procedures

Rockville, Maryland, Us

● Developed complex T-SQL stored procedures and views for customers' highly customized reporting demands● Designed star and snowflake schema data warehouses for customer data using ROLAP● Managed hosting/cloud facility setup and deployment● Primary managed hosting/cloud facility DBA● Recommended query and index improvements in application to increase performance● Promoted and established Casenet's product being certified for HADR using Always On● Converted poorly performing Hibernate-generated queries into more performant custom T-SQL queries

Rockville, Maryland, Us

● Hands-on Manager of Casenet’s technical implementation team● Primary SQL Server/database resource for the organization● Direct supervision of eight full time employees plus oversight of offshore development team● Responsible for all managerial tasks; reviews, performance plans, escalations, HR issues, etc.

Springfield, Ma, Us

● Prioritized team’s tasks and set project milestones and due dates● Facilitated regular meetings with team members individually and as a department● Mentored a new database developer● Developed user guides● Facilitated training sessions of new applications prior to reaching production status● Increased user adoption rates of the new applications● Reduced amount of hot fixes required to the applications

Springfield, Ma, Us

● Modeled, designed and developed database schema for each application● Coded necessary stored procedures, views and functions for data exchange and reporting requirements● Released a variety of web based applications for our internal users as well as our provider community● Distributed reports in an MS Excel format that requires no user interaction● Rolled out MS SQL Reporting Services which housed a single repository of many reports

Indianapolis, Indiana, Us

● Data Warehouse Modeling, Extract and Load Improvements● Complex Report Development● SQL Server and Oracle Administration● DB Performance improvement and optimization