William S. Hansen

Create, maintain, and improve SQL Server databases, business intelligence reports, and reporting solutions to support the operation of the Pharmacy division at this large non-profit organization. Gather requirements. Identify and resolve data quality and database performance issues. Provide custom solutions to meet changing user and business needs. Ensure the delivery of timely, relevant, and accurate data to stakeholders. Support 2 major databases and provide technical assistance as needed for 8 others. Plan and lead projects. Create and manage SSRS reports.

• Increased report accuracy 15% by partnering with key stakeholders to resolve data quality issues.
• Improved the performance and efficiency of an automated pharmacy drug ordering system by engineering a tool that enabled the generation of vendor-specific 850 EDI purchase orders relating to 340B drug ordering.
• Played a key role in the successful migration to a new McKesson pharmacy management system by performing application integrations and data migrations.
• Streamlined report generation from several minutes to only seconds and increased report readability and accuracy by updating the code for a daily executive sales report.
• Designed and implemented strategies for improving patient experience by adopting EDI file data as the primary data source and introducing early problem detection procedures.
• Advocated for an enterprise data literacy program as a foundation to build a data governance framework.
• Facilitated team performance by presenting on Microsoft Learn and other resources for personal improvement.

First dedicated database developer for a leading ($90B+ assets under management) asset management firm, supporting enterprise data integration, ETL workflows, and 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 ones. Collaborated with cross-functional teams to ensure accurate, timely delivery of financial data. Developed, maintained, and supported SSIS ETL processes, and SSRS reports. Partnered with users and data vendors to onboard new data sources with real-time, hourly, daily, and monthly delivery. Prepared compliance, performance, transaction, and database reports.

• Contributed to the development and deployment of a critical unified Security Master Dataset that integrated and prioritized real-time and nightly financial security data from multiple vendors.
• Improved decision-making for traders and analysts by creating 1 source of truth for financial security metrics. Utilized hierarchical data prioritization logic to fill missing values from 20 sources, ensuring data availability and quality.
• Increased operational efficiency and 24/7 support capability by migrating nightly data monitoring offshore.
• Produced a reusable architecture solution to eliminate the need for custom FTP code for new data connections.
• Enabled automated data pipeline management by implementing a robust, scalable SQL Server framework.
• Completely rearchitected the company's Bloomberg Gateway real-time streaming trade feed to resolve legacy system failures and data inconsistencies while improving system stability and accuracy.
• Reprocessed and validated 10 years of data, ensuring compliance and producing a stable platform with trusted data.
• 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 this global investment management firm. Identified financial stock forecasting data needs. Provisioned new data sources to daily ETL processes. Reviewed underperforming T-SQL queries and stored procedures. Recommended new indexes. Created SSRS reports and maintained existing reports. Collaborated with management to create service level agreement (SLA) auditing reports. Worked with users to identify and gather data requirements and load data into staging and final tables.

• Reduced query execution times 30% by refactoring T-SQL queries and indexing strategies.
• Accelerated the provisioning of financial stock forecasting data sources to ETL processes, which eliminated backlogs of work and improved analytical capabilities.
• Enabled greater decision-making capabilities by expanding the types of data available to business users.