Craig L.

Craig L. Email and Phone Number

Enterprise Data Warehouse Developer @ Service Coordination Inc
Gilford, NH, US
Craig L.'s Location
South Hooksett, New Hampshire, United States, United States
About Craig L.

Senior level database professional with 25 years of experience in database development, administration and architecture. 20+ years in the healthcare technology field. Several years designing and working with Cloud/SaaS offerings and Application Management services. Comfortable working with agile/scrum methodology as well as traditional waterfall.● Especially skilled at T-SQL development (including dynamic SQL) for reporting, scripting and ETL activities; database design/architecture; and data warehousing● Proven ability to turn business requirements into usable, scalable database designs● Skilled in Replication; Disaster Recovery/Business Continuity planning; and mock DR event preparedness. High Availability experience using Mirroring, Log Shipping, Replication and AlwaysOn Availability Groups● Extensive knowledge of DBA tasks including backup/recovery, sizing; SQL Mail; and performance tuning● Understanding of disparate health care systems (Claims, UM, DM, Provider, Care Management, HEDIS measures, ICD-10)● Knowledge of Crystal Reports; SSRS; and JasperServer● Experience developing, populating data marts using Star and Snowflake schemas● SQL Server 2012; 2014; 2016; 2017 and 2019● Microsoft Azure - adding, managing SQL Server VMs and SQL Server as a Service● Experience with Python/Pandas/DataFrames● Knowledge of financial data sets - MSCI, Bloomberg, QAI/Refintiv● Job scheduling and job flow management with Control-M

Craig L.'s Current Company Details
Service Coordination Inc

Service Coordination Inc

View
Enterprise Data Warehouse Developer
Gilford, NH, US
Craig L. Work Experience Details
  • Service Coordination Inc
    Enterprise Data Warehouse Developer
    Service Coordination Inc
    Gilford, Nh, Us
  • Service Coordination Inc
    Enterprise Data Warehouse Developer
    Service Coordination Inc Apr 2024 - Present
    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.
  • Man Numeric
    Senior Data Engineer
    Man Numeric Aug 2022 - Feb 2024
    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.
  • Vital Data Technology, Llc
    Senior Sql Server Developer/Architect
    Vital Data Technology, Llc Mar 2021 - Aug 2022
    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
  • Casenet
    Senior Sql Server Developer/Dba
    Casenet Apr 2012 - Jan 2021
    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
  • Casenet
    Manager Of Implementation Engineering
    Casenet Mar 2007 - Apr 2012
    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.
  • Behavioral Health Network
    Data Services Manager
    Behavioral Health Network Jan 2005 - Mar 2007
    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
  • Behavioral Health Network
    Sr. Database Developer/Administrator
    Behavioral Health Network Jan 2001 - Jan 2005
    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
  • Anthem
    Lead Sql Server Database Administrator
    Anthem Aug 1999 - Jan 2001
    Indianapolis, Indiana, Us
    ● Data Warehouse Modeling, Extract and Load Improvements● Complex Report Development● SQL Server and Oracle Administration● DB Performance improvement and optimization

Craig L. Skills

Databases Database Design Microsoft Sql Server Data Warehousing Sql Ssrs Etl T Sql Crystal Reports Mysql Software Development Sdlc Healthcare Information Technology Healthcare Stored Procedures Team Leadership Html Access Business Intelligence Software Implementation Health Insurance Technical Leadership Team Building Relational Databases Sql Tuning Query Optimization Saas Hipaa Data Architecture Agile Methodologies Performance Tuning Database Administration Olap Healthcare Management Jasper Reports Ireport Integration Software Development Life Cycle Sql Server Reporting Services Transact Sql Sql Server Sql Server 2000 2008 Database Architecture Healthcare It Requirements Analysis Replication

Craig L. Education Details

  • Notre Dame College - Manchester Nh
    Notre Dame College - Manchester Nh
    History

Frequently Asked Questions about Craig L.

What company does Craig L. work for?

Craig L. works for Service Coordination Inc

What is Craig L.'s role at the current company?

Craig L.'s current role is Enterprise Data Warehouse Developer.

What is Craig L.'s email address?

Craig L.'s email address is cl****@****ech.com

What is Craig L.'s direct phone number?

Craig L.'s direct phone number is +160354*****

What schools did Craig L. attend?

Craig L. attended Notre Dame College - Manchester Nh.

What are some of Craig L.'s interests?

Craig L. has interest in Politics, Science And Technology, Arts And Culture.

What skills is Craig L. known for?

Craig L. has skills like Databases, Database Design, Microsoft Sql Server, Data Warehousing, Sql, Ssrs, Etl, T Sql, Crystal Reports, Mysql, Software Development, Sdlc.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.