Our Work

Python, Databricks Spark, Azure Kubernetes, Azure Libraries, SQL Server

CCPA & Data Compliance
An end-to-end solution including customer request entry portal and a complex request orchestration workflow. It also included an automated mechanism for data retrieval and deletion across multiple platforms.

Create a comprehensive solution to handle CCPA related requests for end customers

Delivered a complete solution in less than 3 months which addressed all aspects of the CCPA mandate. Customers were able to put in their requests for data information and deletions as well as opt outs as soon as the law was in effect

HDFS, HIVE, PYTHON, Tableau, Kyvos

Advanced Analytics
Leverage advanced analytics techniques coupled with machine learning to properly categorize the bill line items for each consumer to facilitate better understanding of who the customers are and their spend patterns. This solution will help not only drive strategic initiatives but also with potential customer retention.

With hundreds of millions of customers and monthly billing, coupled with local, state and national regulations create a huge problem for finance analysts to categorize revenue based on line items so that appropriate resources can be allocated to transform the network moving forward. This problem is further exacerbated by customers moving from one product portfolio to another and multiple billing systems.

After data collection, cleansing and, applying advanced analytics techniques, a data set of 400+ million rows can be categories in around 4 hours.

Oracle, DB2, SQL Server, Jaspersoft, Power BI, Redis, ETL

Analytic Product Architecture and Design
Architect and design a highly available, customized and scalable data mart with all the necessary tools for data/knowledge workers to execute various analytical workloads – including reports, dashboards and advanced analytic uses

Create architecture and design for an entire analytics subsystem for ACI’s marquee product – Universal Payments

Built the architecture and design for a sustainable and scalable reporting system for a multi-tenant, best of the class cloud bases product in 6 weeks

Collibra, Mulesoft, Python, Azure Databricks

Data Governance Platform and Program
Started with data discovery and classification. A comprehensive tool selection exercise followed. Picked Collibra as tool of choice. Stood up the environment, built Collibra operating model. Built Mule flows for data ingestion and created lineage along with data categorization

Design and build Data Governance platform to be used by the entire company. This is the first ever DG initiative, built and run company wide

Fully operational Data Governance platform was built from ground up. Ingested and built lineage for thousands of data assets. Built processes and procedures around Data Governance. Ongoing projects to add additional use cases

Slider

Here is a sampling of our projects...

sei-small

CCPA & Data Compliance

Project Type: CCPA Compliance Framework

Business Need

Create a comprehensive solution to handle CCPA related requests for end customers

Solution

An end-to-end solution including customer request entry portal and a complex request orchestration workflow. It also included an automated mechanism for data retrieval and deletion across multiple platforms.

More Information...

Results

Delivered a complete solution in less than 3 months which addressed all aspects of the CCPA mandate. Customers were able to put in their requests for data information and deletions as well as opt outs as soon as the law was in effect

Infrastructure and environment:

Python, Databricks Spark, Azure Kubernetes, Azure Libraries, SQL Server

More Information...
aciup-small

Analytics Product

Project Type: Traditional Analytics Product

Business Need

Create architecture and design for an entire analytics subsystem for ACI’s marquee product – Universal Payments

Solution

Built the architecture and design for a sustainable and scalable reporting system for a multi-tenant, best of the class cloud bases product in 6 weeks

More Information...

Results

Delivered a complete solution in less than 3 months which addressed all aspects of the CCPA mandate. Customers were able to put in their requests for data information and deletions as well as opt outs as soon as the law was in effect

Infrastructure and environment:

Oracle, DB2, SQL Server, Jaspersoft, Power BI, Redis, ETL

More Information...
vz_small_rgb_p

Data Science Platform Build

Project Type: Big Data and Data Science

Business Need

Create architecture and design for an entire analytics subsystem for ACI’s marquee product – Universal Payments

Solution

Build and maintain highly available, customized and scalable big data cluster with all the necessary tools for data/knowledge workers to execute various jobs.

More Information...

Results

Built and continuing to mature data lake with multiple domains; machine learning workloads and spark workload

Infrastructure and environment:

Hadoop, Jenkins, Gitlab, Docker

More Information...
sei-small

Data Governance Platform and Program

Project Type: Data Governance

Business Need

Design and build Data Governance platform to be used by the entire company. This is the first ever DG initiative, built and run company wide

Solution

Started with data discovery and classification. A comprehensive tool selection exercise followed. Picked Collibra as tool of choice. Stood up the environment, built Collibra operating model. Built Mule flows for data ingestion and created lineage along with data categorization

More Information...

Results

Fully operational Data Governance platform was built from ground up. Ingested and built lineage for thousands of data assets. Built processes and procedures around Data Governance. Ongoing projects to add additional use cases

Infrastructure and environment:

Collibra, Mulesoft, Python, Azure Databricks

More Information...

Jaspersoft

Project Type: Jaspersoft POC

Business Need

Integrating visually appealing reports and dashboards to increase usability of the banking application was the key for this customer. The solution needed to be sustainable and grow with the rest of the product line.

Solution

Data Ninjas helped identify clear business drivers for this customer. Once the business drivers were identified, Ninjas went to work to identify technical requirements for a proof-of-concept.

The POC involved creating reports and dashboards using Jaspersoft and integrating them with core UI elements using visualize.js to conform to the exact look and feel of the application.

Once, the POC was complete, the customer was ready to move forward with the implementation with best practices helping them

More Information...

Microsoft

Project Type: Full BI/DW Lifecycle Implementation

Business Need

Rapidly growing healthcare organization needed quick ramp up to fulfill business demands for data and analytics. A trusted core of the data and analytics platform had to be built in a short time.

The same platform needed to support multi-tenant file management system for sharing healthcare data across providers/insurers/third parties

Solution

Data Ninjas provided solution architecture services to start the project. Key goals were idenfied and shortrun timeframes were established

Using Agile methodology, four week sprints were planned and executed thereby delivering trusted data using the right archiecture methodology and bite-size chunks.

Ninjas also helped with establishment and running of data governance program for this customer

More Information...

Jaspersoft

Project Type: Jaspersoft Implementation

Business Need

The customer needed a group of Report developers to implement many Jaspersoft Reports within a short period of time.

Solution

Data Ninjas helped with requirements collection with the Business and Product Management team. Agile methodology was followed during the implementation and all reports/dashboards were deployed to production

Ninjas implemented themes and styles according to the UI Framework document provided by the customer. Integration with Active Directory and configuration of JasperReport Server to support a Token based SSO authentication system was also achieved.

 

More Information...

Microsoft

Project Type: SSIS/SSRS Implementation

Business Need

Integrating visually appealing reports and dashboards to increase usability of the banking application was the key for this customer. The solution needed to be sustainable and grow with the rest of the product line.

Solution

Data Ninjas helped identify clear business drivers for this customer. Once the business drivers were identified, Ninjas went to work to identify technical requirements for a proof-of-concept.

The POC involved creating reports and dashboards using Jaspersoft and integrating them with core UI elements using visualize.js to conform to the exact look and feel of the application.

Once, the POC was complete, the customer was ready to move forward with the implementation with best practices helping them

More Information...

Jaspersoft

Project Type: Jaspersoft POC

Business Need

This customer needed to move from legacy BI platform to Jaspersoft in a short amount of time. The "conversion" mechanism had to be identified quickly so that a overall cost and timeline can be determined

Solution

Data Ninjas understood the existing Use Cases and implemented a quick POC to confirm that Jaspersoft BI Suite was a solid solution.

During the POC, Ninjas did substantial Knowledge Transfer on Jaspersoft technology while implementing few reports and Dashboards.  Those artifacts were quickly embedded into the web application for a full proof of concept.

 

More Information...
kelly-moore

ERP Reports Migration

Project Type: Reporting

Business Need

Recreate Oracle Reports Using Jaspersoft. Nearly 80 reports had to be migrated/re-created in Jaspersoft to comply with the ERP upgrade.

Solution

Templates for reports were created. Basic report design was agreed upon with the customer. Data access was provisioned and all report queries were standardized

More Information...

Results

Nearly 80 reports were migrated/converted and unit tested and ready for user acceptance testing in a matter of 2-3 weeks

Infrastructure and environment:

Jaspersoft, Oracle DB

More Information...