Data Engineering Machine Learning
Resume:
*** ***** ***** **** **************@**************.***
Havertown, PA
Douglas Osborne, MSCS
PROFESSIONAL SUMMARY
Prolific agile SQL Architect with over 30 years of professional data engineering experience developing on all tiers for large-scale software projects. Pursuing a career with a nimble and exciting organization. Skilled at developing solutions for demanding clients and devoted to the ever-changing nature of data and software development. Delivering the right data to the right people at the right time.
TECHNICAL SKILLS
Languages/Tools: MS-SQL, Visual Studio, VS Code, C#, VS VB.NET, and ASP.NET. I am currently investigating Python and Machine Learning. Red-Gate Products – SSMS Tools.
Databases: MS-SQL 6.5 - 2025, Visual FoxPro 3-9
Source Control: GitHub/Bitbucket/SourceTree. JIRA. Frequent Confluence author.
PROFESSIONAL EXPERIENCE
04/15/24 – 10/24/25 Cody Systems Pottstown, PA
Tasked with developing a migration process to export the existing data from over 300 police departments hosted on Oracle to an Azure-based cloud utilizing MS-SQL and Entity Framework.
Lead Data Engineer – Data Services
The initial effort was begun under Fabric, utilizing Azure Data Factory and Dataflow Gen2 orchestration.
Redirected development to SQL 2022. Coded and implemented the framework for this transformation via SQL 2022. The final project migrated, cleansed, and relationally linked data from 273 tables, utilizing a Raw/Stage/Production naming convention within Azure Cloud, which mimics the initial medallion architecture.
Helped train and oversee two former Oracle programmers' transition to MS SQL. Developed and instituted SQL templates to assist in the transition and standardize the coding standards.
Developed the interface and process to map data from the Oracle tables to the new SQL tables via a dynamic SQL solution.
Inferred relationships via data discovery with the front-end engineers and resolved missing and duplicated data
Used BCP to create spreadsheets to align missing and mapped data points to their new instances since the former system did not enforce relational integrity. The output enabled personnel to map their existing data to the parallel structure in the new solution, with no loss of granularity, while preserving the accuracy of the existing legal data.
Interfaced production changes via external tables to allow for seamless insertion and update operations in a Production environment with minimal downtime.
Utilized GitHub for Source Control, JIRA for task assignment, Confluence for solution documentation, and Zoom for messaging.
The final version of the process would complete data migration and validation within a 6-hour blackout window for most agencies.
CJIS certified 2024/2025
Passed FBI background check
09/05/17 – 04/15/24 Signant Health/Bracket Global Blue Bell, PA
Develop and maintain the company's Clinical Data Pipeline, with the final implementation of the process generating over 132 million analytical records per day and continuing to grow.
Architect – R & D Data Engineering 09-202*-**-****
Implementing CDC under Azure SQL to reduce the load on data transfers from other databases, allowing us to capture and report changes almost immediately for our Blinded Data Analytics report and Sponsor Extracts.
Go-To SQL SME. Implemented and followed HIPAA and GDPR compliance standards.
Architect – Data Engineering 07-202*-**-****
Developed an orphan detection system to automate the reporting of incorrect data relationships. Led to the creation of over 395 foreign keys for processing speed and relational integrity.
Created an automated system that analyzes a database and generates all the SQL creation scripts in a rerunnable fashion to be utilized by the daily build process. Running this against our largest undocumented database created 7,800 SQL scripts, which were added to the Bitbucket repository, saving over three man-months of manual scripting time.
Created a technique to transfer closed study data from our transactional system and move it to a retired database to free up system resources and reduce costs.
Our data processing strategy evolved from a daily backup-and-restore batch to a real-time upsert pattern, ensuring data is always current and available for analysis, with our data analytics spanning every time zone.
Currently pioneering an effort to implement CDC to speed the data processing mentioned above by a magnitude or more, as well as adding to the concurrency of the data.
Engineering a process to automate the generation of clinical data extracts for our sponsors. This process will help remove the burden currently handled by five full-time data engineers.
Increased the Blinded Data Analytics population from 42 million to over 95 million records generated daily. This data is responsible for over $20m in revenue. Data is cleansed via SSIS packages into Raw, transformed to Staging, and then aggregated to a Snowflake schema Data Warehouse daily.
We are working with the cloud team to add a Snowflake Data Lake to our reporting efforts.
Assisted the DevOps team in transferring all SQL from 2008/2012 code to SQL 2019 across the enterprise. Ours was the first development team to migrate to SQL 2019
Assisted in running the daily agile standup for our offshore team of 2 full-time employees and five contractors in the Philippines, Romania, and India.
Prolific SQL scripter.
Working to become SAFE certified.
SQL Team Lead – Data Engineering 10-2019 thru 07-2021
Helped form a new team within the company tasked with cleaning and trending our clinical data.
Developed a 3-tier data warehouse where we process and combine data from several disparate data systems. Implemented SQL error notification via a company Slack channel.
Architected, coded, and maintained a Blinded Data Analytics table to 42 million rows of clinical data refreshed every morning and utilized by the Data Science Group for their clinical reporting.
SQL Team Lead – Technical Delivery 09-2017 thru 10-2019
Upgraded all aspects of SQL code for the Technical Delivery team. Held scrums over MS Teams.
Tasked with auditing an Axovant genetic therapy trial to exclude mid-study data changes from the original clinical capture to determine if these modifications contributed to the study's failure. Further enhanced this one-off investigation into the corporate auditing standard – now used for every study audit. Timeline for the audit process decreased from 26 hours to 17 minutes.
Developed the SQL Standards document.
•Adheres to Good Clinical Practices (GCP), 21 CFR Part 11, and other regulatory requirements as required.
06/04/12 – 09/04/2017 NRG/Energy Plus Company Philadelphia, PA
Senior Database Engineer – Data Services
Architected the national correspondence solution for a Fortune 200 company, deriving and delivering all legal changes of contract terms between our six brands and over 1 million customers. Handling over 8000 events a day via SSIS and utilizing two external print vendors via SFTP to render the completed electronic contracts.
MS-150 Team Lead 2013-2017, Houston-Austin race.
01/31/11 – 06/01/12 Rovi/Tivo Radnor, PA
Senior Database Engineer – Data Engineering
Charged with maintaining and enhancing databases supporting all major film and TV studios, as well as Microsoft, Google, Amazon, Comcast, and Netflix.
Worked with Fox and Microsoft to address concerns of duplicate entries in the video catalogs for on-demand offerings.
Established SQL Standards, performed code reviews, and published short internal articles.
07/10/06–01/30/11 Advisorport/PNC/Bank of NY-Mellon King of Prussia, PA
06/15/09 – 01/30/11 - Database Architect
Lead technologist addressing all SQL server inefficiencies across all clients.
05/10/08-06/15/09 - Lead Architect – Client - JPMorgan Chase – Fortune 20
Direct two teams of developers solely servicing JPMorgan Chase, architecting all custom software and maintenance releases.
Oversaw the transition from Lipper to MorningStar for their Stock, ETF, MF, and CEF products, all accounts, positions, transactions, and performance.
11/20/06 - 05/10/08 Database Architect/System Architect
Lead architect for the SQL performance team, developing a framework to minimize the overhead of multi-page searches for ADVISORport.com.
Developed a SQL paging system which reduced response times from an initial 93% sub-second responses to 99.90% sub-second for a system handling over 2.5 million requests a day.
Architected the SAML interface to our system, allowing Edward Jones to become a client.
Added a cohesive error reporting system to both our SQL and VB frameworks to address the mistakes that were previously going undiagnosed and uncaptured in both the front and back ends
07/10/06 - 11/20/06 Database Architect
Data Architect for the acquisition of JPMorgan Chase, transferring all mutual fund and investment vehicles from FundQuest and NFS into ADVISORport's managed account services.
Migrated the failing and behind-schedule project from Access to SQL 2000, bringing on over 4.18 billion dollars’ worth of investments on time.
Created a generic corporate migration process for all conversions of outside investment vehicles utilizing DTS packages and SQL stored procedures.
05/2004 – 07/07/2006 CardioNet/Phillips Conshohocken, PA
Senior Data Systems Analyst
Lead .NET Architect for the company's infrastructure framework.
Analyzed the various data sets and data flows within the branches of the nationwide corporation.
Leveraged this knowledge to create Advantage, an application used by every department to track all aspects of interaction between the company and its customers. Each department sees a customized view of the data intrinsic to its operations.
Coded the supporting data collection services in DTS to poll six different servers in real time to gather and aggregate metrics, which were used to feed the Advantage system 24/7/365.
12/2003 – 06/2004 PDP Enterprises Villanova, PA
Senior Programmer Analyst
Lead consultant on several contracts with local businesses.
Analyzed, evaluated, and reengineered an application for Northwestern Human Services from VB.NET to C# to speed up data access via SQL 2000 to the 35,000 remote users.
02/2003 - 12/2003 InfoMC Conshohocken, PA
Senior Programmer Analyst
Participated in the evolution of the company's eCura™ product line from VFP to C# and ASP.NET.
Worked with a third-party development partner in designing the workflow of user requests for services and materials across all stages of the enterprise via a weighted queuing system, allowing concurrent requests to be reviewed and acted upon by both preset and dynamic department criteria.
Rewrote a third-party menu control to utilize a single class with no view state to cut the overhead on page reposts from 78k to 0, having a significant impact on the application's response time.
Researched and implemented HTTP tunneling via XMLHTTP calls to an ASP.NET component. This technique enabled the front end to process the user's request in the background, updating menu links and validating navigation requests before they were invoked.
05/2002 – 02/2003 GCom Solutions Aston, PA
Senior Programmer Analyst
Architected product development.
Architected, researched, and programmed the company's C# and ASP.NET print portal for the company's Digital Printing Service customers.
Designed and recoded http://www.gcom2.com, utilizing consistent presentation techniques across the company's three lines of business.
10/2000 – 04/2002 Visalign/Vis.Align West Chester, PA
Senior Programmer Analyst/ DBA
Consulting Role - Managed and integrated SQL 2000, Cache, and Sybase databases for Citadel Federal Credit Union, unifying all data sources within a local 13-branch 454-million-dollar credit union.
The CRM application presents bank personnel with a 360-degree view of all member service utilization and profitability. The system analyzes the upsell potential of financial, insurance, and investment products in real time to personalize the customer–service member interaction.
Primary data architect. Implemented over 150 DTS packages and 75 stored procedures to load and maintain all data in semi-real time from several internal and external data sources.
Designed a data dictionary program in VFP 6 to document all data sources. During the analysis of each system, we uncovered several data discrepancies in the Cache's database. Worked with the bank MIS director to address these concerns to the analysts at USERS, and the team implemented the change in the subsequent release of the Cache application.
The $ 2.4 million project achieved a 79% GPM and the highest customer satisfaction rating of any completed eBusiness project at Vis.align - Citadel Case Study.
11/1999 – 10/2000 PDP Enterprises, Inc. Villanova, PA
Senior Programmer Analyst – various consulting roles
Nurtured the paying web client base from 0 to over 10.
Selected over a team from PricewaterhouseCoopers to transfer all data from a HP3000 mainframe into a data warehouse for Northwestern Human Services in its Y2K migration.
Uncovered over $70,000 in unbilled or misbilled claims during the data migration.
Supervised the daily acquisition of over 800 MB of patient and treatment demographics.
http://www.shopthearea.com/ - Rescued a failing e-business website by implementing West Wind Web Connection, utilizing VFP, SQL 2000, and Web Pages. The site went live 3 days after I joined the project.
Developed a web interface to Money Mailers™, giving the direct mail advertiser its first Internet presence in the Philadelphia region.
06/1999 – 11/1999 InfoMC Plymouth Meeting, PA
Senior Programmer Analyst
Lead developer of PROVA™, a provider-credentialing system for Managed Behavioral Health Care.
Transitioned concept from spec to HTML proof of concept to working system with West Wind Web Connection within 4 months.
06/1996 – 06/1999 Stores Automated Systems/Triversity/SAP Bensalem, PA
Senior Programmer Analyst
System Integrator for the Targeted Customer Marketing Loyalty program Allegiance™.
Architected and implemented the processes utilized to import and transform historical financial and sales data into the data warehouse for the Allegiance™ product.
Implemented Electronic Funds Transfer software for experience™, which encompasses Credit, Debit, EBT, and Check fund transfers.
Worked on the first touchscreen Point of Sale system in the USA.
05/1995 - 06/1996 Medical Database Systems Conshohocken, PA
Senior Software Analyst/Team Lead
Architected and stood up MedBase, a multi-corporate medical practice management system.
Took product from conception to market in only 10 months.
Set standards for a three-person R&D team.
11/1991 – 05/1995 Advacare/Healthworks Alliance King of Prussia, PA
Software Engineer
Developed Alliance Plus, a PMS that captured and managed patient demographics and incidents of illness for both medical and clinical records with a real-time interface to the Laboratory Information System.
Integrated a real-time interface between Alliance Plus and FoxMed practice management software, facilitating data transfer between the two.
Interfaced with PCE Express, a Pennsylvania Medicare and BC/BS electronic claims package.
Implemented the only third-party lab interface to Smith Kline used by Malden and Carney Hospitals in Massachusetts to submit clinical requests.
Designed the interface for electronic claims transmission to ENVOY with ICD-9 and CPT-4 codes.
08/1989 – 11/1991 Versyss Norristown, PA
Software Engineer
Created the electronic medical claims system for PA BC/BS and PA Medicare.
Developed and implemented Delaware's claim/referral network, serving over 500 providers.
Partnered with US Healthcare (now Aetna) to develop their automated referral system for participating HMO providers. Optimized and verified ICD-9 and CPT-4 coding.
10/1987 – 08/1989 SONEX Corporation Philadelphia, PA
Software Engineer
Developed the real-time traffic control system installed at over 10 cities (including Mesa, AZ, Norfolk, VA, and Orlando, FL), utilizing FORTRAN and Assembly language.
EDUCATION
MS COMPUTER SCIENCE, Villanova University, Villanova, PA – 1998
Independent Study: "Developing an In-Process Server to Transport Legacy Applications to the Twenty-First Century". Elected to Upsilon Pi Epsilon, The Honor Society in Computer Sciences at Villanova University in 1997.
BS Computer Science, Lafayette College, Easton, PA – 1987
BA Economics and Business, Lafayette College, Easton, PA – 1986
Boards
Philadelphia SQL Server User Group (PSSUG)
Actively getting the group up and running post-COVID at the Microsoft Malvern MTC.
Theta Chi – Alpha Omega – Lafayette College
Helping oversee ongoing development efforts and possible chapter recolonization.
CERTIFICATIONS and TRAINING
AED/CPR Certified
Expires: 2026-03-21 ID: 01GGLOP RedCross.org
Brent Ozar
Live Class Season Pass (no VM) – 2019 – lifetime – the best SQL training hands down!
Erik Darling
SQL Server Performance Engineering
Learn T-SQL With Erik
PASS Conferences/DEVCONs
Grapevine, TX – 2005/New Orleans, LA – 2000/Orlando, FL – 1998/San Diego, CA – 1997
Microsoft SQL/PSSUG
Board member of the Philadelphia SQL Server Users group in various roles
Tuning Your Biggest Queries - Adam Machanic
SQL Server Tools for Query Tuning - Grant Fritchey
MicroEndeavors Training
SQL Server Implementing a Database Design – Chuck Urwiler
Visual FoxPro Advanced Developers Training – Chuck Urwiler
FoxPro Developers Training – Melissa Dunn
Outside Interests
On and off MaxPreps.com football reporter for St Joseph's Preparatory School Football team.
Member of PhillyDotNet Users Group
REFERENCES
Jonathan Chandler
Technical Delivery Manager – Entech
**********@*******.***
Gregory Christie
VP UI Engineering Radix IoT
****************@*******.***
Jonathan Newell
Staff Software Engineer – unnamed Tier 1 Cyber Security Corp
**********@*******.***
Contact this candidate