Danasekaran Shanmugam

Data Solutions and Engineering:
Delivering the Enterprise Data Platform (EDP) to CityFibre, UK by building
AWS Data-Lake and Snowflake Data warehouse/Data Mart to use as a
source to build Customer Insight, Network Build BI dashboards and
multiple downstream systems with resulted in a reduction of more than
~30% in the costs of storing & managing of data and pipeline
management.
Roles & Responsibility:
 Designed Metadata Driven Ingestion Framework architecture to ingest
diverse data sources into AWS and Snowflake.
 Collaborated with cross-functional teams to convert the complex
business requirements into scalable data-marts,
 Implemented Configurable alerting & monitoring mechanism to
proactively identify & resolve issues.
 Proposed & negotiated to establish Data-Ops team to address the
ingestion issues within SLA timeframe.
Data Platform Modernization:
Deliver modernized data platform for Verizon's Consumer and Mass
Business unit by creating a new data environment on Google Cloud
Platform (GCP) and transitioning data from the current Teradata data
warehouse to GCP.
Tools and Technologies:
Cloud Storage, BigQuery, TPT, BTEQ, BQ SQL Translator, Composer, DAG,
DataProc, DataFlow, Pub/Sub, Functions
 Teradata Parallel Transporter (TPT) utility to generate TPT extraction
batch script for Teradata table partition and store in Storage bucket
(GCS) to use by transfer job.
 Apply right partition in Teradata table, to avoid huge storage usage in
local system to generate TPT extraction script from Teradata.
 Create required tables in BigQuery with right partition and cluster.
 Converted BTEQ (Basic Teradata Query) query into BigQuery SQL format
using BigQuery SQL Translator.
 Developed a metadata-driven data ingestion pipeline to directly
transfer data feeds from the source to BigQuery, starting from the
specified cutoff date.
Ask-BI (Generative AI RAG):
Developed a streamlined AI tool to Verizon, USA using GCP Vertex AI
(Gemini Model), Llama-index and required embedded model & vector
database. Which will capable of generating SQL queries and charts for a
prompt using existing modernize data-warehouse. This tool is designed to
empower the Corporate Finance user group, enabling them to swiftly
generate ad-hoc analytical reports.
Tools and Technologies:
GCP Vertex AI Vector-Search, Gemini 1.5 Pro LLM, Cloud Storage, BigQuery,
Python, LlamaIndex, Streamlit, Hugging Face - distilroberta-base
Embedding Model
 Designed architecture, work with techno-functional team to explain
components, and gain arch approval.
 Developed the user-interface using streamlit python library.
 Developed core engine using LlamaIndex, BigQuery, Gemini 1.5 Pro and
Vector Database.
 Transitioned to production after successful alignment of output with
technical & business requirements.

Daimler - Germany - Sales Operation Reporting
Vertical Sales Operation Reporting:
Constructed and delivered Data Warehouse using Azure DataBricks and
Business Intelligence (BI) reports for Vertical Sales Operations at
Mercedes Benz Germany.
Tools and Technologies:
Azure DataBricks, ADLS, Azure Analysis Services (AAS), Blob Storage,
PySQL, Power-BI
 Working on ADF Pipelines to Load raw data from ADLS BLOB storage to
Databricks trusted table.
 Creating Azure Databricks Notebook for Bronze, Silver and Gold Layer.
 Mentor the team member on creation of complex metrics development
of data marts on Azure.
 Lead the Data visualization team to develop dashboards from
inception, leveraging Power BI.
 Work with Product owner to identify the priority requirements for next
quarter.
 Developed self-service dashboard for VerSo team to create adhocreports.
 Worked with Scrum master and developer to deliver the agreed
dashboard on sprints basis.
 Took complete ownership of VerSo Sales dashboard delivery.
Cummins Engine Business Unit:
Worked with Senior Personnel to Ramp-up the new project Data Platform


Modernization (DPM) for Engine Business Unit Cummins - USA.
Ingested Sales, Budget and Forecasting data for different business verticals (EBU,
DBU, PSBU...etc) in Cummins.inc and generate Direct Engine Sales
Analysis/Planning and forecasting BI Analytical Reports to make data
driven decisions.
Tools and Technologies:
Azure Data Factory, Synapse Analytics, Analysis Services, OBIEE 11g,
Power-BI
 Involved in discussions with Client to understand/gather the project
requirement & create the detailed design document.
 Analyse the existing Physical, Business Model Mapping layer and
Subject Area in OBIEE and create the data model in Azure Analysis
Services.
 Developed Dashboards with the details of Actual Engine Sales,
Preliminary & Final forecasting and Annual Operation Planning to help
the Demand Manager and Sales admin team.
 Developed Data Ingestion pipeline using Azure Data Factory to ingest
data from existing Oracle DW to Azure Synapse.

Verizon Data Services - USA - CPM (Maintenance)
Corporate Performance Management is a Data Warehouse and Analytical
Reporting platform for Corporate Finance Group to generate financial
reports Like, IS, BS, CF…etc. It is a “Single source of truth” for different
business units like Verizon Business, Corporate Finance, Consumer Mass
Market…etc.
Tools and Technologies:
OBIEE, Hyperion Essbase, ODI, Oracle Data Warehouse, RPD, AWS Services
 Enhance the reports based on Change request by adding/Modifying the
metrics shown in reports.
 Develop Subject area in OBIEE RPD using Essbase multi-dimensional
cube, DW Tables and views.
 Create Data migration pipeline using AWS Glue to ingest data from
Existing Oracle DW to AWS Redshift.
 Replicate the existing RPD and Report to use the AWS Redshift as new
source.

Corporate Performance Management (Development)
Corporate Performance Management is a Data Warehouse and Analytical
Reporting platform for Corporate Finance Group to generate financial
reports Like, IS, BS, CF…etc. It is a Single Source of truth for different
business units like Verizon Business, Corporate Finance, Consumer Mass
Market…etc.
Tools and Technologies:
 Design & Develop the Physical/Logical/Presentation Layer of OBIEE
Repository using BI Admin Tool.
 Create and Maintain Session and Repository Variables.
 Develop Dimensional Hierarchy and Level Based Measures
 Create iBot to send reports in mail and improve the performance of the
report by cache seeding.
 Develop Interactive dashboards, Different Chart views and Reports
using OBIEE Answers.
 Create Summary dashboard to show the identified KPIs to give high
level picture to C-Suite executives.
 Work with ODI, Essbase Team to ingest data and create multidimensional
cube.
Quantus
Quantus is a BI Analytical reporting platform for Verizon Services
Operations Team (VSO) to analyse the Customer Payment Projection
score, Behaviour score, Collection & Discount details…etc. It is used by
Front office representatives and mid-level management.
Tools and Technologies:
 Design & Develop the Physical/Logical/Presentation Layer of OBIEE
Repository using BI Admin Tool.
 Create and Maintain Session and Repository Variables.
 Develop Dimensional Hierarchy and Level Based Measures.
 Create iBot to send reports in mail and improve the performance of the
report by cache seeding.
 Develop Interactive dashboards, Different Chart views and Reports
using OBIEE Answers.
 Create Summary dashboard to show the identified KPIs to give high
level picture to mid-level executives.
 Work with ODI, Essbase Team to ingest data and create multidimensional
cube.