Understanding Oracle Reports & query and re-structure it as per Vertica DB.

Re-designing Tables, Projections and partitions for Best output. Working on HP Vertica -
database designer for best query optimizer.
Migrated Jasper based report to Tableau Dashboard, for Client’s best output and to
function as on real time.
Working with Kafka team to load Real time data (every 5 min, data processing (ETL) and
displayed to Dashboard, This helps client to identify any glitch/problem in TV
Channels/Show in Real time (Team Biggest Achievement till now is Customer now can
Identifying and fixing there issues/Services in a Minute rather than waiting for a Day).

M1 (Mobile-One) is third largest telecoms operator of Singapore. As per telecom veracity,
customers frequently switch/Port from one Network Provider to other. M1 wants to
predict who all customers can leave there service in coming months, so that they can call
all such customers and provides them best offer to avoid their Porting – A Data Scientist
Project.

Contribution : Understanding How Machine Learning Algorithms works, mapping Data Science Team

requirement to Vertica Logical Schema.
Working with Data Science Team, Writing SQL-ETL process to cleanse data as per Data
science team for their analysis and prediction.
Building Shell script that can communicate between various SQL for Prediction Parameter.
Develop Tableau Dashboards as a scatter Plot to showcase Customers churning
Percentage per month with Details like: Customers Main Reason for churning, issue
Report, etc.

Mapping source system with Vertica DB with Logical Schema and Physical Schema.
Writing SQL’s according to Vertica’s Cluster architecture (WOS, ROS, HA) for Vertica’s best
output.
Performance Tuning: Involved in Projection and Segmentation for all tables to make query
work as real-time. Support Bug fixes, run-time failure and daily catchup, restoring activity.
Table Partition for effectively maintaining data/retention period and license in-check on
daily basis.
UAT teams to analyze and resolve opened defects. (As per urgent requirement, I took
responsibility & quickly learned Tableau and migrated manual report to Tableau
Dashboard, for Client’s best output and to easily do analysis, as my First Project).

Swisscom is Switzerland TV corporation, where clients want to migrate there data from Oracle To HP Vertica Column-based Storage. They specifically concern about SQL query performance to view Daily Dashboards and capture any TV/ Network related issue.

Ncell is a Telecom company of Nepal and provide wide range of services. Here clients has too many source system and they wants to capture all systems of data in One access database that can provide real-time analysis and can view business main KPIs in visual format.