Summary
Overview
Work History
Education
Skills
Linkedin
Academic Projects
Timeline
Generic

Varun Kapoor

Noida,Uttar Pradesh

Summary

Over 5 year of experience in building BI application utilizing MySQL , SQL Sever , Power BI, ADF. Strong engineering professional graduated from CDAC and Microsoft Certified Associate Data Analyst. Excellent understanding of business operations and analytics tools for effective analysis of data. Skilled in Databases, Business Intelligence, Data Analysis, Power BI, Power Apps, Power BI Data Flows, MDX and Python. Proficient knowledge of statistics, mathematics, and analytics. Proficient knowledge of statistics, mathematics and analytics. Developing intelligent Machine Learning based products helping business take strategic decisions based on actionable insights from data and leading innovation and developments across different verticals.

Overview

4
4
years of professional experience

Work History

Senior Data Engineering Analyst

Optum
Noida, Uttar Pradesh
04.2022 - Current
  • Migrated the SSIS ETL process to Azure Data Factory.
  • Developed ETL process using the Azure Data Factory Pipeline & Data flows.
  • Developed Logic Apps in Azure to automate the process of uploading the csv files to sharepoint folder on regular interval.
  • Developed Financial report like P&L,WFC with MTD,QTD,YTD & TY views for better visibility of data for stakeholder's with the flexibility of slicer to change Month, Year & other financial parameters.

Data Engineering Analyst

Optum
Noida, Uttar Pradesh
03.2021 - 04.2022
  • Developed complex financial reports in Power BI by pulling data from Essbase.
  • Developed Multidimensional Expressions(MDX) query to fetch data from Essbase and feed into Power BI.
  • Developed Data flows in the Power BI service for fast processing of huge data.
  • Developed Power Apps for the User Commentary based on the insights from Dashboard.
  • Developed complex logic for projections in MS SQL Server with the use of stored procedures.
  • Use Power BI supported external tools(Tabular Editor, Dax Studio) for creation of calculation groups and formatting.
  • Created ETL process using SSIS.
  • Contributed in the development of SOP documentations for the dashboards.
  • Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

Associate Software Engineer

Icreon Communication Pvt Ltd.
Noida, Uttar Pradesh
10.2018 - 03.2021
  • Developed comprehensive reports based on marketing, sales trends, and demographic data analysis.
  • Developed appropriate advanced analytical models/applications to lead to insightful and forward-looking solutions.
  • Developed Power BI reports and dashboards from multiple sources using Data Blending .
  • Explored Data in variety of ways and across multiple visualizations using Power BI.
  • Developed customer calculated measures and column using Data Analysis Expressions(DAX) in Power BI to satisfy business needs.
  • Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
  • Directed data transformations and transitions using Pentaho .
  • Managed data quality issues during ETL processes.
  • Developed team communications and information for Client meetings.
  • Maintained log information in Text file to Tracking Errors and recording transition execution. Created Configuration for source and target.

Software Engineer Trainee

Icreon Communication Pvt Ltd.
Noida, UP
04.2018 - 10.2018
  • Developed custom reports and dashboards and deployed them on server using Power BI.
  • Utilized Power Query in Power BI for data cleansing and data manipulation.
  • Created schedule refresh and installed on-premises data gateway.
  • Developed complex SQL queries using stored procedures, common table expression(CTEs), temporary table to support Power BI reports.
  • Developed drill through, cross-report drill through, drill down reports in Power BI.

Education

Post Graduation Diploma - Big Data Analytics

Centre For Development Of Advanced Computing
Pune
02.2018

Bachelor of Technology - Computer Science & Engineering

IMS Engineering College,Ghaziabad
Ghaziabad
05.2017

High School Diploma -

XII
Dayawati Modi Academy, Rampur
04.2013

Skills

  • MySQL
  • MS SQL Server
  • SSIS
  • Azure Data Factory
  • Power BI
  • Logic Apps/Power Apps
  • Pentaho
  • DAX
  • Python/R

Linkedin

www.linkedin.com/in/varunkapoor95

Academic Projects

Effect of macroeconomic variables on Indian stock market (2018)-

  • The macroeconomic variables have considerable influence, both positive as well as negative, on the performance of the corporate sector of the economy. The objective of this project was to find the influence of such variables on the Indian stock market through time-series analysis and data reduction technique of factor analysis
  • Tech used: Python, R, Tableau

Student Performance Analysis -

  • This project is based upon the academic performance of students in two different classes. I showed the simplicity of predicting student performance using different techniques

Sports Data Analysis -

  • The project includes sports data analysis with essentials of big data and Hadoop to analysis player's ranking and performance in leagues.

Timeline

Senior Data Engineering Analyst

Optum
04.2022 - Current

Data Engineering Analyst

Optum
03.2021 - 04.2022

Associate Software Engineer

Icreon Communication Pvt Ltd.
10.2018 - 03.2021

Software Engineer Trainee

Icreon Communication Pvt Ltd.
04.2018 - 10.2018

Post Graduation Diploma - Big Data Analytics

Centre For Development Of Advanced Computing

Bachelor of Technology - Computer Science & Engineering

IMS Engineering College,Ghaziabad

High School Diploma -

XII

Similar Profiles

CREATE PROFILE
Varun Kapoor