Craig L. Email and Phone Number
Craig L. work email
- Valid
- Valid
- Valid
Craig L. personal email
- Valid
- Valid
- Valid
Craig L. phone numbers
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
-
Enterprise Data Warehouse DeveloperService Coordination IncGilford, Nh, Us -
Enterprise Data Warehouse DeveloperService Coordination Inc Apr 2024 - PresentFrederick, 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. -
Senior Data EngineerMan Numeric Aug 2022 - Feb 2024Boston, 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. -
Senior Sql Server Developer/ArchitectVital Data Technology, Llc Mar 2021 - Aug 2022Newport 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 -
Senior Sql Server Developer/DbaCasenet Apr 2012 - Jan 2021Rockville, 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 -
Manager Of Implementation EngineeringCasenet Mar 2007 - Apr 2012Rockville, 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. -
Data Services ManagerBehavioral Health Network Jan 2005 - Mar 2007Springfield, 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 -
Sr. Database Developer/AdministratorBehavioral Health Network Jan 2001 - Jan 2005Springfield, 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 -
Lead Sql Server Database AdministratorAnthem Aug 1999 - Jan 2001Indianapolis, 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
Craig L. Education Details
-
Notre Dame College - Manchester NhHistory
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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial