EXPERIENCES

PRINCIPAL TECHNICAL SPECIALIST TRIALCARD (C2C)

NOV 2022-PRESENT

Design and implement data pipelines using MSSQL 2019 and SAP DI. Supports the overall mission of the company to prroide technical innovations to the Life Sciences industry.

TECHNICAL LEAD NATIONSBENEFITS

JUNE 2022-OCT 2022

Led the technical workload to manage the benefits for Anthem’s 2023 plan. Updated existing SSIS packages to handle 1.6M members using techniques to avoid exhausting TempDB and overcoming C# FIleStream memory limits. Other duties include assisting BAs with reading 834 EDI segments, direct client interaction and ownership of the technology from SFTP, processing to acknowledgements.

DIRECTOR APPLICATION DEVELOPMENT APOLLOMD

JUNE 2021-JULY 2021

Led small team to ingest emergency department HL7 data from trading partners using Biztalk and RESTful APIs, transforming them into Snowflake and SQL Server.

SR. ETL ENGINEER CARESOURCE (C2C)

JANUARY 2021-MAY 2021

Created new SSIS packages, T-SQL and PL/SQL stored procedures in new features of the flagship Claims Processing solution. Created reports and visualizations with SSRS and Tableau.

LEAD ETL ENGINEER ADVANTASURE (C2C)

SEPTEMBER 2019-APRIL 2020

Designed next generation Claims Processing system using SFTP with Global Scape, ELT/ETL using Azure Data Factory and SSIS, automation with Control-M and storage in SQL Server. Also operated as team lead and hands on engineer of the ETL workload. Created Tableau visualizations of claim’s status.

SR. DATA GOVERNANCE ENGINEER ALLSCRIPTS (C2C)

MAY 2019-JULY 2019

Developed solutions to close data gaps in Enterprise Data Applications and Orchestrations (ELT). Updated complex stored procedures (dynamic SQL) to improve the data quality of eight EHR domains. Authored SSIS Fuzzy Logic packages and C# “read ahead” functions to improve data quality.

SR. ETL ENGINEER FREIGHT HANDLERS, INC (C2C)

JANUARY 2019-FEBRUARY 2019

Quickly migrated interfaces to the legacy ERP system to Dynamics 365. Migrated 100+ PowerShell scripts to manageable and high performing SSIS packages and Python scripts. Updated Power BI visualizations to provide better insight into scheduling and loss.

PRINCIPAL CONSULTANT MICROSOFT

FEBRUARY 2003-JANUARY 2018

Led a team of 20+ creating a Commercial Real Estate trading desk for GMAC using C#, MTS and SQL Server. Led implementation of white label units at Deutsche Bank and Credit Suisse. At the time it was the largest professional services engagement at Microsoft.

Contributed technical components to the Silverlight Player used by NBC to stream the 2008 Summer Olympics. The 13+M streams resulted in 290M page views. The highest total for an Olympics at the time.

Created cubes and reports with SSAS and SSRS from Eclipsys’ RCM product. The insights gained improved claims and billing by 8 days.

Partner Strategy Consultant to Accenture’s HealthCare Operating Group in the USA and Canada assisting in $1B+ projects.

Participated in the development of DDL and DML used by the UK’s National Healthcare System. The implementation led to free health care throughout the United Kingdom.

Designed HA MSSQL Cluster for State Farm’s P&C Claims on MSSQL saving $25M annually.

Authored HTML5 components for APNews.com.

Technical Lead for ADP’s Auto Dealer app on Windows Mobile.

Authored HTML5 components for PETA.com.

Contributed C++/Unity components to the Temple Run app et al.

Designed AccuWeather’s Location Services for Windows Mobile.

Contributed HTML5 components to AARP.com.

Designed WeatherBug’s Location Services for Windows Mobile.

Contributed technical components to GEICO.com. Led monthly C#/.NET learning modules on site.

SENIOR CONSULTANT MICROSOFT

DECEMBER 1999-JANUARY 2003

Authored stored procedures (T-SQL) for Exelon’s new credit evaluation system.

Authored ASP.NET and C# pages for TD Bank’s new customer site.

Authored new Biztalk integration pipelines for Sunoco’s data warehouse.

Modeled new data structures for TV Guide’s data warehouse.

Led Astra Zeneca team creating multi-therapeutic area portals and analytics with SharePoint, ASP.NET and C#.

BUSINESS SYSTEMS MANAGER PFIZER

JANUARY 1995-DECEMEBER 1999

In a Hands-On role, led employees and contractors migrating RCM, CRM and SFA data from AS/400 to MSSQL. Used log shipping and DTS (precursor to SSIS) to Transform and Load data to SQL Server 6.5 and SSAS. Created Sales reports using Crystal Reports, Business Objects and Excel.

LOGISTICS SPECIALIST - USMC RESERVE

JUNE 1989– JUNE 1995

Member of a Global Logistics team supporting Marine Expeditionary Forces.

EDUCATION

B. S. COMPUTER SCIENCE (IN PROGRESS)

AUGUSTA UNIVERSITY, AUGUSTA, GA

SEPTEMBER 1987-PRESENT

SEAN VANDEMARK

DATA ENGINEER

PROFILE

IT Professional with 27 years of experience including data engineering, software engineering, project management and professional services.

CAREER CONTRIBUTIONS

MCS 90+% Utilization

Microsoft Gold Award

Consistently exceeded expectations at Microsoft

CONTACT

Email

LinkedIn

484-***-****

Wilson, North Carolina 27893

TECHNICAL SKILLS

Tools

Visual Studio

VS Code

SSMS

SSIS

BIDS

Eclipse

TFS

Git

Jira

SAP DI

Languages

C, C++, C#

Java

HTML/JavaScript

PowerShell

T-SQL

PL/SQL

PostgreSQL

Databases

SQL Server

Oracle

MySQL

MariaDB

MongoDB

Cloud

Azure IaaS

Azure PaaS

Azure SQL Database

Azure Data Warehouse

Azure DevOps

Azure App Service

Business Intelligence & Reporting

Power BI

SSRS

Business Objects

Tableau

Crystal Reports

SSAS

Contact this candidate