BH Technologies™ Case Study
Managed Services Provides Project Team for Amazon Web Services Data Warehousing Solution
Challenge
Our client, a provider of home loan, loan servicing, and refinance products to consumers and institutional partners in the United States (US), needed streamlined reporting and business processes to maintain accurate data.
Solution
To address our client’s needs, Beacon Hill Technologies deployed a high-functioning, cohesive team, including a program manager, senior program managers, a project coordinator, business analysts, quality assurance specialists, business intelligence (BI) data subject matter experts (SMEs), .NET developers, SQL developers, and Microsoft BI developers.
Achievements
Our team successfully managed the implementation of a Microsoft data solution using Microsoft SQL 2014, SQL Server Integration Services (SSIS), SQL Service Analytic Service (SSAS), SQL Agent, and Master Data Services (MDS)/Data Quality Services (DQS). We also developed and presented comprehensive cost-benefit analysis on Amazon Web Services (AWS) vs. onsite data storage; introduced project documentation standards for project timelines, decision, risk, and issue management, change control, testing, and migration; developed and managed first of its kind business intelligence intake tracking, prioritization, and initiation; designed and implemented resource model that allowed management to project and align resource needs across multiple projects; and managed BI reporting and analytics, Tool Proof of Concept for Microsoft Power BI, Qlik, and Business Objects.
Ultimately, our team delivered three AWS-hosted data warehouse solutions. These implementations eliminated ten legacy data sources, automated regulatory and investor reporting, exposed business processes that were creating data quality issues, and allowed for easy and efficient ad hoc reporting and analysis.