1. Opioid and Contraband Detection and Enforcement from China – Risk Based Program Development
Problem Statement: Thousands of people die each year due to opioid overdoses in Canada from China and via violence driven by illegal arms shipments from the USA
Solution: Assurety helped develop a risk-based program by developing the very first Datawarehouse driven by Python and ETLS processing of over six sources of destination related data to predict, detect and stop contraband from coming into the country. We performed statistical analysis of operational data and crime data and several other data sources. Performed regression analysis, covariance analysis and correlation analysis to get the data ready for a machine learning algorithm.
Services from Assurety: Data Science, Data Analysis, ETL processing, AI / Machine Learning Algorithms, Reporting
Technologies: Python, Pentaho, MySQL,
Client: Canada Border Security Agency
2. FAFSA – Free Application for Federal Student Aid System Re-Engineering
Problem Statement: Old system and code was not maintainable and required re-engineering and integration
Solution: Assurety provided technical architecture, solutions architecture, systems engineering and software engineering and maintenance services to re-engineer the FASFSA platform and then provided maintenance services for several years. The bigger challenge was to understand and document all business rules. The solution required integration management and technical expertise.
Services from Assurety: Technical Architecture, Systems Engineering, Software Engineering, Reporting
Technologies: Java, Drupal, Oracle
Client: Department of Education
3. Content Management Migration from IBM WebSphere to Drupal
Problem Statement: Under the Obama Administration Guidelines Department of Education needed to move to open platforms and this challenge included moving all content management applications to Drupal which was new and had many risks associated with security at the time of implementation
Solution: Assurety brought in highly experienced resources who understood migration challenges as well as had expertise in developing solutions in Drupal and providing extra security layer, which was custom built to minimize challenges posed by the Drupal platform at that time. Assurety migrated the whole platform in a two-year period provided technical leadership and direction and implementation services.
Services from Assurety: System Migration, Application Development, Integration, Management, Content Management
Technologies: Drupal, Oracle
Client: Department of Education
4. Marketing Database Development and Campaign Management (CRM)
Problem Statement: USPS Marketing Database and its campaign management had been outsourced to two external companies and USPS wanted to take that responsibility back but was having trouble taking over the project due to many technical and documentation related challenges
Solution: Assurety was brought to engineer a new system which includes USPS marketing data, operational data, tracking data, as well add data from a Credit Bureau (Equifax) and add social media handles from Facebook, Instagram, and Twitter. The goal was to take the data from the old marketing system, transform it for the new system, and add additional data sources to provide a comprehensive campaign management platform for customer relationship management reaching both commercial customers and consumers. Assurety developed the entire system in less than a year, migrated all data from the Terra Data old marketing database into the new Oracle based solution and enhanced its capabilities by developing algorithms to predict events at an address and then to use them to develop campaigns and also share data with marketers without sharing the PII.
Services from Assurety: Data Migration, New Datawarehouse and operational data store development, Predictive Analytics algorithm development and Reporting.
Technologies: Teradata, Oracle (migrated to Oracle), Java, Tableau visualization, SAS regression and Predictive modeling
5. Digital Transformation of the entire Commercial Channel, Customer Experience
Problem Statement: Completely paper driven processes had a huge cost and lack of electronic data didn’t provide efficiency, transparency, and automation opportunities and USPS needed to transform the commercial channel
Solution: Assurety performed business process engineering, mapping current workflows and processes and reengineered them to simplify the customer experience, bring more efficiency to the acceptance, verification and induction processes, and developed an enterprise system that brought in approximately $100M in daily revenues and cutting paper costs and removing errors inherent in manual processes. Assurety’s challenge was also to develop a VLDB (Very Large Database) that was an ODS (Operational Data Store) processing 30-40 Billion rows of data every three to four days and making it scale and provide both transactional efficiency and reporting.
Services from Assurety: Business Process Engineering, Very Large Database design and Development, enterprise Systems Development and Engineering.
Technologies: Oracle, Java, ColdFusion, IBM MQ Series, MicroStrategy, Data IQ
6. Financial Fraud & Contraband Fraud Detection Predictions
Problem Statement: There was a $1.6Billion fraud predicted in the Commercial channel for mail and parcels and there was no data driven risk-based program at OIG and OIG needed SMES and Data experts to develop such a program
Solution: Assurety was hired to bring in a team to develop a program that considered program governance, data governance, Subject Matter Expertise in the commercial channel and technical Expertise with Database Development, Datawarehouse and Datamart and Data lake development, Reporting and ETL expertise. Assurety Developed the system and continues to manage and enhance it today in 2019. The system had detected, identified and caught fraudulent activities in the millions of dollars since its inception and now the system has been enhanced to work with contraband coming in through the ecommerce supply chain into the country. Assurety system has a 98% accuracy in predictions of both contraband fraud and financial fraud with customs fees, shippers and mailers not paying for parcels and mail deliberately.
Services from Assurety: Program Management, Data Governance, Fraud Detection, Expertise, Database and Datawarehouse development and Machine learning (AI) Algorithm development to catch anomalies and update the models to improve detection.
Technologies: SAS, Oracle, Tableau, Teradata
Client: Office of Inspector General
7. Digital Transformation of the Commercial B2B Portfolio
Problem Statement: USPS Commercial business channel management, needed extensive digital transformation to be able to measure performance of the organization and its KPI to cut costs, improve service delivery, improve customer experience and develop new products.
Solution: Assurety was brought to help with strategy and then design and implementation of multiple programs under the portfolio that would allow KPI measurements through digital transformation. This journey included moving from paper-based transactions to digitization, to digitalization, to digital transformation and then to business transformation by re-engineering the digital solutions into a single platform that can support all verticals within the USPS. Then using the data and advanced BI/Analytics to optimize the strategy and decision support and provide avenues to R&D to innovate products, cut operational and transportation costs and to develop deep insights into the customer and improve customer experience.
This was a fifteen-year journey for the USPS and Assurety to provide leadership and direction in re-engineering the business processes and workflows into data driven simplified workflows to enable automation which in turn allowed for cost cuts and product innovation.
Services from Assurety: Business Strategy, Program and Portfolio development, Technical PMO Integration Management, Technical Architecture, Systems Engineering, Software Engineering, Database Engineering, Data warehousing, BI/Analytics and statistical modeling and Reporting.
Technologies: Oracle, Java, Oracle Financials, MicroStrategy