Vibhu

WORK EXPERIENCE

AXTRIA Mar 2022 – Nov 2022

InsightsMAx – Senior Data Engineer

• Identified required dimensions and facts for the dimension model and used Erwin tool to develop conceptual models based on requirements

• Developed data pipelines for input datasets to be used in ML algorithms with the help of Pyspark, S3 and EMR

TATA CONSULTANCY SERVICES Aug 2016 – Mar 2022

Telecom BI DWH migration to Telecom BI Datalake – Data Engineer

• Environment migration from Oracle DWH to Hadoop Datalake

• Involved in optimized data aggregation and data ingestion jobs development using Spark-SQL

• Development of automated ETL processes across millions of rows of data, which reduced manual workload by 40% monthly

Telecom BI Datawarehouse – Data Engineer

• Developed Data Mapping, Governance, Transformation and Cleansing rules for architecture involving OLTP and OLAP

• Ingested data from disparate sources using a combination of BODS, Oracle SQL DB procedures, Python and Shell scripts to create data views to be used in BI tools

• Developed semantic layer for dashboards, visualizations, and interfaces with Oracle database to deliver meaningful and actionable insights

Telecom network Datawarehouse – Data Architect

• Performed data modeling using Oracle SQL Developer tool and developed an end-to-end database solution for network data warehouse application for a leading telecom company in India

• Worked with client to understand business needs and translate those business needs into actionable reports using SQL and Oracle DB procedures, saving 15 hours of manual work each week

• Introduction of Self-Healing data pipeline into system to ensure insertion of noise-free data into data warehouse

DIA-LUT Framework – Data Modeler/ Data Analyst

• Conduct Design discussions and meetings to come out with the appropriate data model at the lowest level of grain for each of the dimensions involved

• Reverse engineered the reports and identified the data elements, dimensions, facts, and measures required for enhancements of existing reports

• Prepared ETL technical mapping documents for each mapping for future developments to maintain SDLC

Indus Dashboards – ETL Developer

• Monitored pre-decided ETL jobs written in SAP BODS and SQL Procedures and ensure resolution of discrepancies

• Involved in different phases of SDLC to analyze, design, coding and implementing high quality scalable solutions as per business requirements