Summary
Overview
Work History
Education
Skills
Certification
Websites
Timeline
Generic
Roshan Kumar

Roshan Kumar

gurugram

Summary

Results-driven Data Associate Engineer with strong skills in Azure Data Factory, MYSQL, and data quality checks. Proven ability to design and deploy effective ETL workflows that enhance data accuracy and drive business insights.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Data Associate Engineer

Accenture
Gurugram
05.2022 - 06.2024
  • Cocacola Project
  • Automated ingestion of CSV sales data from SharePoint using Azure Logic Apps, storing in Azure Data Lake Storage (ADLS).
  • Designed and deployed ADF pipelines (Linked Services, Datasets, Activities) for ETL workflows from ADLS to downstream systems.
  • Performed data quality checks in Databricks (PySpark, Pandas), ensuring accuracy, consistency, and completeness of sales data.
  • Implemented Stored Procedure Activities in ADF for transformation and loading into Azure SQL Server, enabling KPI dashboards.
  • Monitored and optimized ADF pipelines, reducing pipeline failure rate and improving load performance.
  • Collaborated with teams to resolve bugs, address data inconsistencies, and manage change requests (CRs).
  • Managed client-reported issues using ITSM tools, ensuring SLA compliance and smooth project execution.
  • Served as the first point of contact for clients, providing updates, handling escalations, and ensuring business continuity.

Data Analyst

Bridgei2i Analytics Solutions
Bangalore
05.2021 - 05.2022
  • Delivered multiple models on time, leading to a 15% increase in marketing efficiency by understanding how much each marketing input contributes to sales and how much to spend on each marketing input. Ascertained the effectiveness of each marketing input in terms of Return on Investment using Python and Pyspark.
  • Provided solutions for better allocation of marketing budget: Identified the most appropriate marketing channel (e.g., TV, Print, radio, etc.) to get maximum returns. Improved execution of AD Campaigns and conducted business scenario testing with the help of Azure Data Factory and Azure Synapse.

Relationship Manager

Tata AIA
05.2019 - 08.2020
  • I have worked as a Relationship Manager, where I provided tailored insurance policy recommendations to HDFC Bank customers. Based on their income and individual needs, I effectively identified and suggested suitable insurance solutions.

Education

Postgraduate diploma - Data Science

Great Lakes Institute of Management
01.2020

Bachelor's in Engineering - Electronics and Telecommunication

Priyadarshini college of Engineering
Nagpur, Maharashtra
06.2017

Skills

  • Data Engineering: Azure Data Factory, Azure Synapse, Azure Data Lake, Azure Storage Account, Databricks, Big Data, Spark
  • Programming & Analysis: MYSQL, PySpark, Pandas,Python
  • Data Operations: ETL Pipelines, Data Quality Checks, Stored Procedures, Data Modeling
  • Tools & Practices: ITSM (Incident, Service Request, Change Request), Agile/Scrum, KPI Reporting

Certification

  • AZ900, 01/24
  • DP 900, 06/24
  • Postgraduate diploma in Data Science, Great Lakes Institute of Management, 2019-2020

Websites

Timeline

Data Associate Engineer

Accenture
05.2022 - 06.2024

Data Analyst

Bridgei2i Analytics Solutions
05.2021 - 05.2022

Relationship Manager

Tata AIA
05.2019 - 08.2020

Postgraduate diploma - Data Science

Great Lakes Institute of Management

Bachelor's in Engineering - Electronics and Telecommunication

Priyadarshini college of Engineering

Similar Profiles

CREATE PROFILE
Roshan Kumar