Our clients' (many Fortune 500) industries include:

• Financial Institutions

• Fraud

• Healthcare

• Insurance

• Internal Audit

• Manufacturing

• Marketing

• Oil & Gas

• Publishing

• Property Management

• Retail

• Risk Management

• Transportation

• Worker’s Compensation

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 POC & 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 & posting invoices via web portal.

DATA PARTNERSHIPS:

• Proactively identify data errors & reduce support calls by developing & implementing SQL environment test cases.

• 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 SDLC 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.

BUSINESS INTELLIGENCE 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.