Ajanth Raju

Roles and Responsibilities:

• Architected and implemented a globally scalable, cloud-based data solution on Azure, empowering MB customers with enhanced data accessibility and analytics.
• Developed a containerized, Python-based automation tool, deployed via Azure App Service, to streamline EL pipeline creation and management.
• Designed and published RESTful APIs, enabling customers to dynamically create, delete, and execute data pipelines for seamless data source onboarding from diverse systems into the Azure cloud, significantly reducing onboarding time, and increasing data agility.

Skill Set:

• Azure Data Factory, ADLS Gen2, and AKV.
• Azure App Service.
• Python, and FastAPI.
• AKS, Azure Container Registry (ACR), Docker.
• Cloud Architecture.
• Data Lake Design.
• API development.

Client: Mercedes-Benz Research and Development India, Pvt. Ltd.

Roles and Responsibilities:

• Designed and implemented data pipelines to ingest data from diverse on-premises and cloud sources into the EXtollo data platform, supporting global manufacturing analytics.
• Developed robust ETL batch pipelines to load processed data into the data lake, ensuring data quality, and accessibility.
• Established real-time streaming solutions using Azure Event Hubs to ingest raw data from manufacturing units, enabling immediate insights.
• Engineered ETL pipelines with Databricks and PySpark to refine and transform data for accurate, efficient business reporting.
• Successfully migrated large datasets from ADLS Gen1 to ADLS Gen2, optimizing performance and scalability.
• Migrated legacy PowerShell data pipeline scripts to Azure Data Factory, improving efficiency and maintainability.
• Conducted a detailed impact analysis of destination systems, identifying and addressing framework and pipeline changes during the ADLS Gen2 migration.
• Updated the Audit Balance Control framework and pipeline datasets to ensure compatibility with the new ADLS Gen2 structure.
• Created and executed data copy pipelines to facilitate seamless data transfer from ADLS Gen1 to Gen2.

Skill Set:

• Azure Data Factory (ADF)
• Azure Data Lake Storage (ADLS Gen1 & Gen2)
• Azure Event Hubs
• Azure Databricks
• ETL/ELT Pipeline Development
• Data Migration
• Streaming Data Processing
• PowerShell Scripting (Legacy)
• Data Lake Design
• Audit Balance Control Framework

Client: British Telecommunications (BT)

Roles and Responsibilities:

• Developed and maintained the GIB data warehouse application, replicating billing data, and generating critical feeds/reports.
• Automated data processing and report generation through robust UNIX shell scripting.
• Engineered PL/SQL packages, procedures, and functions to deliver business-critical data feeds.
• Designed and implemented Ab Initio graphs for complex billing and payment report generation, enabling customer access via a web portal.
• Built and scheduled Hadoop jobs (Hive, Sqoop, Pig) using Oozie for efficient data processing and analysis.
• Successfully migrated and upgraded the Rating and Billing Manager (RBM) from version 5 to 9, addressing data and reporting changes across the billing platform.
• Conducted an impact analysis of source system changes, implemented necessary DDL modifications, and ensured accurate data replication.
• Adapted existing scripts to accommodate RBM upgrade changes, ensuring consistent data delivery to downstream systems, and the web portal.
• Ensured data integrity during large-scale data migrations.

Skill set:

• Oracle PL/SQL (11g, 12c).
• UNIX Shell Scripting.
• Ab Initio (Graphs, Data Transformation)
• Hadoop (Hive, Sqoop, Pig, Oozie)
• Data Warehousing.
• Data Migration.
• Billing and Payment Systems
• Spark