George Ramsdell

Experience

• 

  Microsoft

  Principal Data Scientist (Functioning as Principal Analytics Engineer)

  Apr 2017 - Present

  • Microsoft Business Applications Group
  • Independently architected and developed comprehensive Cloud Resource Management Data Mart from ground up, serving 400+ users across Dynamics 365 and Power Platform organizations
  • Designed and implemented Azure Spend dimensional and tabular models, enabling deep cost analysis and optimization across the platform
  • Developed sophisticated C# ETL Metadata framework integrating multiple data sources (SQL, Azure REST APIs, Kusto) into unified platform, enabling rapid expansion of data coverage
  • Collaborated with platform engineering teams to surface and analyze previously untapped infrastructure metrics, leading to enhanced resource optimization
  • Created custom React JS dashboard with curated Power BI reports, democratizing data access across Business Applications group
  • Built end-to-end analytics solution tracking 4M+ databases, driving data-informed capacity planning and cost optimization
  • Achieved industry-leading gross margins through development of automated monitoring and optimization tools while supporting exponential platform growth
  • Maintained and evolved entire platform as sole developer, delivering enterprise-scale impact with lean resources
• 

  The Walt Disney Company

  Senior Software Development Engineer

  Mar 2010 - Mar 2017

  • Independently developed comprehensive hosting infrastructure reporting platform supporting Disney.com, ABC.com, ESPN.com, and Theme Parks
  • Built and maintained $10M monthly cloud chargeback system tracking AWS, Azure, and Google Cloud spending
  • Received Star Performer award for successfully migrating enterprise CMDB from CA ServiceDesk to ServiceNow
  • Developed SSIS based ETL Metadata framework, enabling myself to perform work typically requiring 3-4 engineers.
  • Created innovative dashboard framework using AngularJS, enabling near real-time infrastructure monitoring
  • Staffed and led a team of 2 vendor engineers to support and expand the platform while maintaining lean operational efficiency
• 

  Brooks Sports

  Senior Business Intelligence Data Analyst

  Apr 2009 - Apr 2010

  • Rescued failed sales reporting project, delivering successful implementation as sole technical resource
  • Architected and deployed SharePoint-based reporting platform serving entire sales organization
  • Optimized OLAP cube usability and performance through collaboration with Data engineering team.
• 

  Chase

  Staff Reporting Developer - Corporate Fraud Investigations

  Aug 2008 - Mar 2009

  • Selected for critical post-acquisition transition team, successfully migrating 7 years of sensitive Corporate Fraud Investigation data one month ahead of schedule
  • Collaborated one-on-one with Chase counterpart to architect data mapping strategy and develop migration scripts
  • Created parallel reporting systems while maintaining existing functionality, ensuring seamless transition for investigators between platforms
  • Delivered flawless transition execution ahead of timeline, earning maximum performance and transition bonuses
• 

  Chase

  Staff Lead Reporting Developer - Market Risk Management

  Mar 2007 - Jul 2008

  • Designed, developed, and engineered a Market Risk Management dashboarding website from end to end as a solo effort.
  • Replaced prior failed systems to provide centralized reporting for $4B+ in portfolios, empowering traders with on-demand risk matrices for $6B in market value.
  • Deployed the platform to Washington Mutual’s trading floors on both the East Coast and West Coast, providing a critical tool for decision-making.
  • Built a scalable solution, including database design, Meta Data ETL Framework pipelines, and a web-based user interface, delivering real-time insights to stakeholders.
• 

  Washington Mutual

  Technology Manager II - Retail Bank Performance Analytics

  Jun 2005 - Feb 2007

  • Led lean team of 5 developers to create FC Web reporting portal, replacing failed legacy solution
  • Scaled the platform from 240 initial users to 6,000 daily active users (DAU) and 20,000 monthly active users (MAU) across 2,400 branches within the first year, driven by word-of-mouth adoption
  • Designed and implemented comprehensive performance analytics system tracking sales, operations, and profitability metrics
  • Built platform from open source foundation, demonstrating innovation and cost-effective solution delivery
  • Delivered end-to-end solution including database design, ETL pipelines, and web-based user interface supporting 500+ concurrent users
  • Managed full project lifecycle including hiring, architecture, development, and deployment
• 

  Washington Mutual

  Technology Manager II - Home Loans

  Feb 2002 - Jun 2005

  • Led a team to design and implement a custom Test Automation framework, reducing regression testing from five weeks to four days.
  • Provided technical leadership for Business Objects, Credit Risk Tracking, and Remedy systems.
  • Managed performance/load testing for mortgage origination and business intelligence systems.
  • Authored comprehensive project documentation, including vision statements, end-user manuals, and project plans.