Python, Databricks Spark, Azure Kubernetes, Azure Libraries, SQL Server
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
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
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
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
Here is a sampling of our projects...
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.
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
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
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
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.
Results
Built and continuing to mature data lake with multiple domains; machine learning workloads and spark workload
Infrastructure and environment:
Hadoop, Jenkins, Gitlab, Docker
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
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
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
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
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.
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
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.
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
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