Blair Morgan

• Data Owner of 1.4 Billion guest-facing Identity records used by the entire Disney company.
• Architected a new Identity Data Lakehouse using Databricks with an overall goal of reducing costs by 40%, improving data reliability for various Business Segment consumption by 75% and accelerating decision-making process across those specific business segments.
• Managed a team of 8 data engineers that implemented the new Data Lakehouse which included 35+ new identity objects that fed several segmented based Databricks Unity Catalog(s) and migrated legacy systems based upon old RDBMS systems to the new data lake
• Implemented real-time streaming architectures for faster, more accurate decision-making capabilities.
• Implemented comprehensive monitoring and alerting systems for proactive issue resolution in production environments.
• Improved data quality by implementing ETL processes and data cleansing techniques.
• Increased departmental efficiency by implementing standardized coding practices across all team members'' projects.
• Enhanced data pipeline efficiency with the optimization of SQL queries and indexing strategies for Delta tables

• Developed and maintained a comprehensive data dictionary to facilitate data governance efforts across the organization.
• Provided support for end-users in accessing and utilizing the data warehouse effectively, addressing any concerns or issues that arose.
• Kept current with industry trends in order to suggest innovative solutions for enhancing overall performance of the Data Warehouse ecosystem.
• Played an instrumental role in successful migrations from legacy systems to modern Data Warehouse platforms by creating detailed migration plans and ensuring minimal disruption to business operations.
• Maintained and developed new ETL processes for the Disney's existing legacy data warehouse and other legacy systems using SQL Server 2000/DTS combined with JScript/VBScripts tasks.
• Developed key ETL processes for the ESPN Fan Relation Management Project (FRM) which included the extraction, transformation and loading of data several of Disney’s Operational Data Stores (ODS) and their Data Warehouse using SQL 2000 and SQL 2005.
• Developed and loaded Web Analytics data feeds from both Omniture (now Adobe Analytics) other 3rd party vendors.
• Mentored junior level ELT developers throughout this entire FRM project.
• Collaborated with cross-functional teams to gather requirements for data warehouse design and development.

• Responsible for the daily management, for production support, server and data administration of 200 MS SQL Server database servers for Microsoft’s Passport Environment.
• Participated on the Passport Data Warehouse "Virtual Team" developing the main ETL processes using SQL 2005 SSIS and developed the main CUBE/Multi-Dimensional tables for their OLAP Environment.
• Mentored junior developers through regular 1-on-1 meetings, providing guidance on best practices, coding standards, and career growth opportunities.
• Enhanced system performance with thorough code reviews, debugging, and optimization techniques.
• Improved systems with addition of new features and infrastructure.
• Provided educational expertise and mentoring to junior team members.
• Implemented continuous integration and deployment strategies for faster release cycles and improved application reliability.

• Conducted thorough analysis of system requirements to develop tailored database solutions that met organizational needs effectively.
• Reduced server load by implementing partitioning strategies that optimized storage allocation and resource usage.
• Facilitated communication between IT departments, ensuring smooth collaboration on database projects across the organization.
• Consistently achieved project milestones ahead of schedule through effective task prioritization and time management skills.
• Principle engineer responsible architecting Webtrends' click-stream analytical data storage.
• Developed Webtrends Live “single schema” database design and all associated stored procedures (approx 100), triggers and all DRI using Erwin version 3.52.
• Architected and orchestrated the migrating Account/Data from their old database environment to their new data warehouse environment (process of moving 3+ million tables “old schema” down into normalized database with 75 tables.
• Consistently delivered high-quality database solutions on time and within budget, earning recognition from management for excellence in job performance.
• Analyzed current processes within the organization to identify opportunities for streamlining related workflows using advanced features available within modern databases.

• DATABASE ADMINISTRATOR - Microsoft Corp (GNS Group)

– Responsible for developing and implementing a database sort-order conversion for Microsoft’s Internet Travel site, Expedia.com, American Express’s, Continental and Northwest Airlines Web Sites. Developed Expedia’s first ELT processes to extract transform and load eight different reservation systems’ hotel data into one source for Expedia’s HotelFinder database used by the EXPEDIA.COM and American Expresses AXI Web Site Responsible for production support, server and data administration of 16 database servers running a mix of Microsoft Windows NT v4.0 and 5.0 with SQ: Server 6.5, 7.0 and Shiloh (SQL 2000). Monitor and maintain the current PerfCol and Event Collector processes; perform daily maintenance on NT Servers, SQL Server databases, nightly collections, batch jobs, database dumps and backups.

• Database Developer - Microsoft Corp (Expedia.com)

– Responsible for developing and implementing a database sort-order conversion for Microsoft’s Internet Travel site, Expedia.com, American Express’s, Continental and Northwest Airlines Web Sites.

– Responsible for developing and implementing a database sort-order conversion for Microsoft’s Internet Travel site, Expedia.com, American Express’s, Continental and Northwest Airlines Web Sites.

– Developed Expedia’s first ELT processes to extract transform and load eight different reservation systems’ hotel data into one source for Expedia’s HotelFinder database used by the EXPEDIA.COM and American Expresses AXI Web Sites

• Database Developer - Advanced Fesearch Systems

- Responsible for database development and maintenance work for an OLTP Health Care Case Management/Utilization Management Software Package.

- Responsible for optimizing stored procedures for several different clients, installation of referential integrity and provided database support to ARS's clients for Microsoft SQL Server v6.5 SP2.

- Created network/web implementation plan for connecting ARS's LAN up to an ISP using a Cisco Router(s) and a CSU/DSU via 256KB Frame Relay line. xResponsible for optimizing stored procedures for several different clients, installation of referential integrity and provided database support to ARS's clients for Microsoft SQL Server v6.5 SP2.