Shubham Sharma

Responsible for management of data warehouse for all 23 circles of Vodafone and Airtel operator (Daily 20+ crores projected call records). Provide data and descriptive analytics to support workforce processes and initiatives based on relevant internal data and external data sources. Develop reporting that aligns with business objectives and provide actionable, relevant, and timely insights to three major telecom clients. ETL design and deployment to extract clean data from all 23 circle servers to central internal repository for analysis and reporting MIS. Worked on SQL queries and shell scripts to automate reports which indicate major KPI thus countering manual efforts and time by 95%.

Involved in developing Power BI Dashboards ,Reports on the Talent Acquisition and Progressive sales infotech for the client. Designed and built dashboards and reports by importing data from excel and Power App,SQL. Knowledge in DAX,M query,Power BI service,Visualization. Knowledge in Database Mysql and SSIS. Performed extensive analysis on raw research data and synthesize comprehensive summaries and clear insights using SQL ,python and hadoop hive. Assisted in identifying target cohorts ,creating Datapipelines and building Dashboards for promoting various products and services. Identifying target Cohorts, creating datapipelines and creating master model table and JSON related to the campaign. Creating KPIʼS for analysis and documentation relaled to the campaign. Creating Voila Dashboard. ETL experience utilizing SQL querying skills (Mysql and Linux) and unit testing methodologies. Worked on ETL concepts of data flow, data enrichment, data consolidation, change data capture and transformation. Worked on Hive in Hadoop using mysql.