Design, development and support of Mobile Marketing OLAP DW system. DW enhancement and BI Analytics reporting for latency/performance, traffic, campaign and billing. Data Warehouse process improvements focusing on ETL, partitioning, materialized views, SQL tuning and logs.
- DW ETL process to convert router non-relational data in to fact and dimension model. Daily volume of 25-30 million rows.
- Various batch processing of scheduled marketing campaigns for analysis and billing. Volume 5 to 10 million rows.
- Automated Star Service monthly billing process using shell script, PL/SQL and ETL processes.
- Development of customer facing latency and performance reports for marketing campaign.
- ETL job using Talend File delimited and positional metadata, tMap, tFilterRows, Row generator, tLogRow and output to Oracle database or data file
- Analysis and design of real time data refresh and new BI reporting platform using Vertica (Analytical DBMS) and Tableau for data visualization
- internal and customer facing portal.