Arun Bhargava
Bengaluru
Summary
To secure a position where by hard work, dedication and the ability to acquire new skills will advantage any company I work for. Around 8 years of experience with IT Technology. Currently working as Senior Analyst (Data Analyst, Business Intelligence and Project Planning) 3 Years of experience in oracle data integrator. Proficient in working with Transact-SQL DDL and DML Excellent knowledge in ETL (Extract - Transform - Load) using SQL Server Integration Services 2017 (SSIS), DTS, Bulk Insert. Expertise in upgrading from DTS to SSIS packages, Control Flow in SSIS. Experience in designing and developing reports on POWER BI and OLAP (Creating cubes). Experience in DAX Function 1 Experience in Microsoft Azure Experience in Extracting Transforming and Loading (ETL) data from Excel CSV File. Extensive Experience in Writing SQL Queries, Dynamic-queries, Sub Queries, Joins, Stored Procedure, Views , Performance Tuning etc. Key-Skills : MS SQL Server, POWERBI, SSIS, Data Integration, SSRS, ETL, EXCEL, Data Migration , Tableau, Data Warehouse , Data Modeling , Data Analysis , Business Intelligence
Overview
8
8
years of professional experience
Work History
Senior Analyst (Data Analysis and Business Intelligence)
Unique Identification Authority of India (Meity)
DELHI
02.2024 - Current
- Data analysis of fraud transaction
- Create weekly Power bi report of biometric mismatch and liveness failure
- Data cleaning and validation of weekly transaction of FMR-FIR transaction
- Create dynamic SQL queries for analytics team
- Data validation and Cleaning
- Azure Data Factory
- Performance Tuning
- Project Planning and Management
- Defining business requirements and reporting them back to stakeholders
- Documentation – BRD,FRP
- Create Package for data transformation
- Led the introduction of FMR-FIR (Finger Minutiae Record & Finger Image Record) in the authentication ecosystem removing the stand alone FMR-FIR impacting the fraud detection system
- Responsible for supporting & providing guidance to various central ministries/state departments and other organizations for integration of Aadhaar in schemas/applications.
Project Planning Consultant (Data Analyst and Business Intelligence)
BHARAT BROADBAND NETWORK LTD.
DELHI
07.2022 - 02.2023
- Public and Private Partnership (Telecom Domain) – The flagship government project which has an objective of empowering 1.3 billion Indians with affordable internet access and delivery of digital services will cover on estimated 3.61 lac villages, including Gram Panchayats (GPs) across 16 states such as Kerala, Karnataka, Rajasthan, Himachal Pradesh, Punjab, Haryana, Uttar Pradesh, Madhya Pradesh, West Bengal, Assam, Meghalaya, Manipur, Mizoram, Tripura, Nagaland and Arunachal Pradesh.
Assistant Manager (Data Analyst and Business Intelligence)
EXL Service India Pvt. Ltd
Noida
12.2021 - 07.2022
- Global products and platform (Insurance Domain) – Worked on Business intelligence report and dashboard creation for insurance data and also do data analysis for the same
- I am working company model for insurance data
- We do subrogation analytics.
Data Analyst
Department of Rural Development at Ministry
Krishi Bhawan
09.2018 - 12.2021
- DISHA Project - DISHA Dashboard brings data from 44 flagship government schemes to one place for the first time
- This helps government officials at all levels explore and assess key government initiatives for any geographic level, at any time period
- The DISHA Dashboard helps Members of Parliament (MPs), Members of Legislative Assembly (MLAs), and District Officials track the performance of all major flagship schemes in their districts and constituencies.
Programmer
National Transport Project at National Informatics Centre
CGO Complex
04.2016 - 04.2017
Software Developer (Data Integration/ODI)
National Transport Project at National Informatics Centre
CGO Complex
04.2017
Education
PG-DIPLOMA in Advance Computing -
CDAC-NOIDA: Centre for Development of Advanced Computing, INDIA-201309
01.2015
Bachelor of Technology (B.Tech.) in Information Technology -
R.D. Engineering College, Ghaziabad, Uttar Pradesh (Affiliated To Uttar Pradesh Technical University, Lucknow ,Uttar Pradesh)
01.2014
6 Months Industrial Training on Data Integration/Warehousing -
National Informatics Centre, Department of Information Technology, Ministry of Communications & Information Technology, CGOComplex, Lodhi Road, NewDelhi
Skills
- MS SQL Server
- POWERBI
- SSIS
- Data Integration
- SSRS
- ETL
- EXCEL
- Data Migration
- Tableau
- Data Warehouse
- Data Modeling
- Data Analysis
- Business Intelligence
- Data Visualization and Presentations
Accomplishments
Certificate of appreciation given by MINISTRY OF ELECTRONICS AND INFORMATION TECHNOLOGY, PUNJAB CIVIL SECRETARIAT, and CHANDIGARH Migration was completed for all RTO’s of PUNJAB STATE before the target data.
Personal Information
Date of Birth: 05/07/1993
Languages
Hindi
First Language
Hindi
Upper Intermediate (B2)
B2
English
Intermediate (B1)
B1
Timeline
Senior Analyst (Data Analysis and Business Intelligence)
Unique Identification Authority of India (Meity)
02.2024 - Current
Project Planning Consultant (Data Analyst and Business Intelligence)
BHARAT BROADBAND NETWORK LTD.
07.2022 - 02.2023
Assistant Manager (Data Analyst and Business Intelligence)
EXL Service India Pvt. Ltd
12.2021 - 07.2022
Data Analyst
Department of Rural Development at Ministry
09.2018 - 12.2021
Software Developer (Data Integration/ODI)
National Transport Project at National Informatics Centre
04.2017
Programmer
National Transport Project at National Informatics Centre
04.2016 - 04.2017
PG-DIPLOMA in Advance Computing -
CDAC-NOIDA: Centre for Development of Advanced Computing, INDIA-201309
Bachelor of Technology (B.Tech.) in Information Technology -
R.D. Engineering College, Ghaziabad, Uttar Pradesh (Affiliated To Uttar Pradesh Technical University, Lucknow ,Uttar Pradesh)
6 Months Industrial Training on Data Integration/Warehousing -
National Informatics Centre, Department of Information Technology, Ministry of Communications & Information Technology, CGOComplex, Lodhi Road, NewDelhi
Similar Profiles
SUKHWINDER SINGHSUKHWINDER SINGH
Project Manager at Unique Identification Authority of India (NISG)Project Manager at Unique Identification Authority of India (NISG)
Dhaval AmbhireDhaval Ambhire
District Project Manager at CSC E Governance Services India Limited - Meity,Government Of IndiaDistrict Project Manager at CSC E Governance Services India Limited - Meity,Government Of India
RAVI KUMAR SONIRAVI KUMAR SONI
District Manager at CSC E-Governance Services India Limited (MeitY)District Manager at CSC E-Governance Services India Limited (MeitY)
Parth SawantParth Sawant
Product Engineer at JuspayProduct Engineer at Juspay
Bharath Reddy KBharath Reddy K
Lead Securities Analyst at Wells FargoLead Securities Analyst at Wells Fargo