Logistics Specialist Data Engineer
Resume:
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
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