Client’s AS400 system didn’t regulate data consistency or provide a user-friendly experience. In working closely with the executive team an end-to-end data solution was agreed upon; Microsoft stack on the backend with Qlik Sense empowering users on the frontend. A SQL Server Database environment was implemented to ingest AS400 data. [...]

Our client wanted to determine active vs. dormant databases, their overall performance and utilization, and any consolidation/decommissioning opportunities. Our analysts reviewed the entire environment using network listeners for a high-level preliminary analysis before diving into details of each database instance. The following attributes were defined for output and visualization in [...]

Client had an immoveable deadline to retire their legacy data warehouse and migrate 15,000 existing Cognos reports to a new Oracle data warehouse. Combining usage reports and interviewing report users reduced reports to 2,000. Decomposing reports down to their root elements was conducted, and a matrix of all base elements [...]

"Y&L analysts were brought in to eliminate data integration failures. An in-depth analysis of system logs was conducted, the server and network infrastructure was reviewed and validated, the integration process and code was reviewed, and data tables were analyzed for improvement. " "The team incorporated various changes including table indexing [...]