Case Studies

See our winning results in data analytics and business intelligence

CASE STUDY 1

Challenge

Needed a solution to assist with a complex Data Warehousing project.

Solution

Provided a process for developing business-class applications and creating highly visible and enterprise level reports for stakeholders to gain insight into the business.

Key Deliverables

Partnered with IT and business leadership to develop applications for internal use. Aligned with BI team members to define development specifications and created data loads and reports that were high quality while ensuring their ability to automatically refresh the report more easily.  Created the necessary SQL objects/models to support a range of ad-hoc and standard reports/dashboard in Power BI, Tableau and Excel. Frequently responded to customer/stakeholder’s feature requests and feedback. Responsible for all the ETL (Extract, Transform, and Load) Process from various data sources using SSIS packages.

CASE STUDY 2

Challenge

Evaluate, ETL, and Warehouse 100+million row datasets for use in direct, tabular, and PowerBI reporting solutions consumed by Executive and field business managers worldwide.

Solution

Working closely with data set owners, collected, built, and managed data from multiple SQL DB systems, securely moved very large datasets using Azure Cloud Services, and built reporting data systems supporting multiple deliverable/reporting technologies.

Key Deliverables

Partnered with data source owners spanning many different teams to collect and warehouse datasets. Built and managed all ETL (Extract, Transform, and Load) Process from various data sources using SSIS packages as well as custom scripted code.  Created the necessary SQL objects/models to support reporting front ends (both relational and tabular). Engaged with business owners to design and develop PowerBI and Excel reporting supporting monthly business rhythms worldwide.

Business owners can effectively track all aspects of overall business performance from multiple perspectives including performance against sales/usage targets.  Reporting includes granular customer engagement detail with drill down to service usage and historical usage charting.

CASE STUDY 3

Challenge

Needed a solution that could effectively and efficiently operate company systems by ensuring a robust and sustainable data architecture.

Solution

Created and maintained a data architecture that supports warehouse requirements which provide for expansion given budgetary constraints and availability of data and skilled resources. Led the creating, enforcing standards and procedures for bringing in application sources to ensure integration of system through data-warehouse design.

Key Deliverables

Ensure that each application database system data-load into the data-warehouse is operating properly and meets the company processing requirements. Worked to minimize database ETL jobs downtime, monitor, fine tunes, creating new processes to audit the job performance. Ensure the integrity and accuracy of the data on Genesys, LDR/Guidewire, PDR/mainframe DB2 and warehouse tables.