Poche’ designed ETL code used to support reporting in SAS Visual Analytics. The ETL code was designed as a series of SAS macros so that it could be easily applied to all divisions’ data within DMDC. Poche' designed the code and trained both SAS team members and DMDC analyst to implement the macros into their ETL processes. The ETL code was designed to extract data from SQL Server, transform the data, and load it into Hadoop and LASR Server for use in SAS Visual Analytics.
Comments