The Challenge
Legacy SAS code prevented new data analytics platform adoption
- Code Migration & Culture Adoption: Legacy outdated SAS Enterprise Guide Code needed to be migrated to the Cloud to accomplish a unified well-governed data and analytics platform.
- Large and complex system: There were over 3000 business users spanning 83 areas ( 15 data producers and 69 data consumers) with over 476 000 lines of code and 457 business data processes to migrate.
- Non standardized Business Units: Several distincts business areas: Cable, Collection, Campaign Management, Revenue Assurance, Credit Risk, B2B Market Insights, B2B Field Marketing.
Our Solution
Leverage AI for Automated SAS Code translation/migration
- We developed a Gen AI automated tool to extract from SAS code all data sources: repositories, tables, and fields used and their function.
- The GenAI tool also provides a sophisticated and thorough documentation of processes including UML diagrams.
- The Gen AI tool translates the SAS Base code to the appropriate cloud-based programming language.
- Manual assessment of user skills and required data history was needed. We also provided hands-on training.
KEY Benefits
Reduction of Adoption Program from 16 months to 4 months
Actual Avg Migration time reduced from 8 to 2 days
$ 600K/year SAS License
$ 400K/year Opex Savings
RESULTS
- Overall Data Processes Run- Performance improvement of 40%
- AI generated Documentation and substantial improvement in data governance.
- Single Platform: Acceleration of Processes adoption by non-technical areas with substantial lower cost of operation.