top of page

CASE STUDIES

How do our clients define success? Faster data response times (as in, today, not next quarter), BI that actually makes sense, getting it right the first time (what a concept!), hitting goals without panic, & working with a team that speaks human - not just SQL. Oh, and let’s not forget cleaner processes, better documentation, fewer support headaches, & saving time, money, & maybe even a little sanity along the way.

background dark blue square.jpg

Colas IS Support

CHALLENGE: Canadian child companies to sunset Explorer (asset management) software and convert to JDE data management & SSRS BI delivery to 

​

  • Data modeled/mapped new JDE data & programmed ETL to ERDW.

  • Redeveloped 18 report suite into 10 shared SQL stored procedures & SSRS financial reports.

  • Championed consistent data rules across tax & non-tax reports.

  • Designed & configured exception report to identify data rule violations for business correction.

  • Trained 10 Business Analysts & 2 Developers in 4 years to maintain & develop data rules.

​

SUCCESS: Provided child companies a report suite with expected cross reference capability, enabling client self service in correcting perceived report issues & reducing IT maintenance/support.

Clients' (many Fortune 500) industries we serve:

  • Banking
  • Civil Construction
  • Claims
  • Credit Card
  • Dairy
  • Education
  • Energy
  • Entertainment
  • Financial Institutions
  • Fraud
  • Healthcare
  • Insurance
  • Internal Audit
  • Manufacturing
  • Marketing
  • Medical Spa
  • Oil & Gas
  • Publishing
  • Property Management
  • Retail
  • Risk Management
  • Transportation
  • Veterinary
  • Worker’s Compensation
client.jpg

Implementation
Partnerships

  • SAP Business Objects Enterprise (version 5.x - BIP 4x) implementations & upgrades, Universe, BOBJ, Crystal Reports & WebI development.
  • SQL Server (2000 - 2019) deployments & upgrades, SSAS, SSIS, SSMS, SSRS & Visual Studio development. 
  • Implement QuickBooks accounting systems & convert/migrate data from legacy accounting systems/processes.
  • Environment assessments including new software/system Proof of Concept (POC) & Return on Investment (ROI) studies.​

  • Eliminate office supply usage, postage & a department of 200 review staff by automating a manual process of 10s of 1000s of printed monthly/quarterly/yearly invoice mailings, implementing stored procedure rules against invoice data to identify exceptions, & posting invoices via web portal for client consumption.

Data
Partnerships

  • Proactively identify data errors & reduce support calls by developing & implementing SQL environment test cases & exception reporting.
  • Data reconciliation in mergers & acquisitions, includes leading JAD sessions, data standardization, definition, modeling & integration. 
  • Improve complex JDE to SQL SSIS ETL process from over 1/3 of a day to 2 hours, documenting 300+ event dependency matrix & providing technical specifications for all of the detailed process/task functionality in only 2 weeks.
  • Reduce transactional process review timeframes from days to hours by creating multi-source comparable system/process data visualizations.​

  • Save 100s of 1000s of resource dollars every year over several years by meeting goals & deadlines in simultaneous roles in all stages of the System Development Life Cycle of a new credit data warehouse after a data service provider change.

  • Redevelop legacy Explorer (construction management software) report suite in SQL Server, championing consistent data rules across the various reports to maintain expected cross references & configure exception reports to identify data rules violations, reducing support & enabling client self service in correcting perceived report issues.

mind.jpg
KPIs.jpg

Analytics
Partnerships

  • Convert complex multi-hour processing JDE/Reports Now financial reports to less than 1 minute SSRS returns.

  • Develop SSAS Tabular cubes & Power BI visualizations, deploying to the cloud.

  • Reduce report batch production times from days/weeks to minutes, increasing individual report performance from minutes to seconds.

  • Increase broader audience usage & decrease IT maintenance by consolidating 100s of SAP reports into 10s of Microsoft reports during a migration/conversion of financial reports between reporting tools.

  • Automate multi-spreadsheet manual data pull/lookup process into consolidated, single source, refreshable, & schedulable SSRS reports.

bottom of page