William S. Hansen

Own and modernize the SQL Server databases and data pipelines behind the Pharmacy division's ordering, pricing, and reporting systems. Re-architect legacy processes into modular, configuration-driven solutions; build and integrate data pipelines from EDI, CSV, and API sources; and resolve data-quality and performance issues to deliver trusted, timely data.

• Re-architected a legacy pharmacy order-splitting pipeline into modular, configuration-driven components during a McKesson pharmacy-management-system migration — isolating each source’s unique formatting load into uniform staging tables so changes to one don’t impact the others, and driving business logic from configuration tables. Cut the time to enable new pharmacy pricing models and account structures from days to minutes with configurations and no code changes.
• Designed a regression-testing and validation framework that reprocesses production orders in an isolated test database and compares results to production outcomes — importing point-in-time pricing availability for validation — ensuring pipeline changes preserve data accuracy.
• Built multi-340B-account order allocation logic that fills orders across prioritized discount-eligible buckets by availability, falling through to Group Pricing Organization (GPO) — supporting granular tracking for federal (340B) audit requirements.
• Engineered an automated data pipeline on McKesson's EnterpriseRX API to synchronize 300–500 patient records daily, eliminating manual data entry and reclaiming over 500 hours of operational time annually.
• Generated vendor-specific EDI 850 purchase orders for the pharmacy drug-ordering system, integrating 340B and Group Pricing Organization (GPO) workflows into a resilient, configurable ordering process.
• Played a key role in migrating to a new McKesson pharmacy management system through application integration and data migration.
• Improved query performance under production constraints by restructuring T-SQL to leverage existing indexes — narrowing to indexed keys before joining back for columns, and benchmarking CTE versus temp-table approaches to select the most efficient.

First dedicated database developer at a leading asset management firm, joining at ~$10B AUM and building the database practice from the ground up as the firm grew to ~$100B+ assets under management, supporting enterprise data integration, SSIS ETL/ELT workflows, and SSRS reporting solutions. Designed and implemented data models and ensured secure data access through effective use of roles, stored procedures, functions, constraints, user defined data types, and views. Supported multiple SQL Server databases and developed new databases. Collaborated with cross-functional teams to ensure accurate, timely delivery of financial data. Partnered with users and data vendors to onboard new data sources with real-time, hourly, daily, and monthly delivery.

• Served on the business continuity team, executing biannual disaster-recovery failover tests — validating recovery-time and recovery-point objectives, application integrity, and failback — and authored remediation runbooks for scenarios such as database corruption.
• Built a unified Security Master dataset integrating and prioritizing real-time and nightly batch financial data from Bloomberg and Bank of New York Mellon (BNYM), using hierarchical prioritization logic to resolve conflicts and fill missing values — creating one source of truth traders and analysts relied on for decisions.
• Re-architected a fragile, decade-old Bloomberg real-time trade feed into a deterministic, order-independent pipeline, eliminating hours of weekly manual reprocessing, then reprocessed and validated 10 years of historical transactions where accuracy was critical for SEC audit compliance.
• Engineered a configuration-driven file-transfer framework storing SFTP connection details with encrypted credentials in the database, eliminating custom SSIS setup per connection and enabling password and path changes without modifying code.
• Built a configuration-driven parser for Bloomberg Security Master positional files handling 6 asset-class layouts, replacing hard-coded logic and enabling new data fields to be added through configuration.
• Increased operational efficiency and 24/7 support capability by migrating nightly data monitoring offshore.
• Effectively integrated multi-source data (APIs, JSON, XML, flat files) into a centralized data warehouse.

Optimized database performance and enhanced ETL and reporting solutions for a global investment firm. Reduced query execution times 30% by refactoring T-SQL queries and indexing strategies, provisioned new financial forecasting data sources to daily ETL processes to eliminate backlogs, and expanded the data available to business users.