Summary
Overview
Work History
Education
Skills
Certification
Personal Details
Travelling & Videography
Timeline
Generic

ARUN PAWAR

Summary

Professional with strong analytical and problem-solving skills, well-versed in data modeling, SQL, and ETL processes. Drive impactful insights through data visualization tools like Power BI and QlikView. Reliable team player focused on collaboration and delivering results, adaptable to changing project requirements. Excel in turning complex data into actionable business strategies.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Data Migration/ BI Developer

IBM Pvt Ltd, Pune, India
10.2023 - Current
  • The project is involved in Migrating data from PLM database environment to Aras Data base Environment using SQL Server 18.
  • Have developed multiple complex SQL Queries for data migration as per client requirement.
  • Have worked on Three structure architecture for data migration including Agile/Extraction/Active Layers in the source side and Aras layer in destination side/A.
  • Have implemented query optimization for the data migration
  • Created power bi recon reports for the data migration
  • Handling technical challenges with BI Tools.
  • Have learned new technologies as per the business needs work on Major Power BI Report which has used multiple different data source environments.
  • Project Title: PMI – Data Migration
  • Client: Philip Morris International
  • Skills: SSIS ETL, SQL Server 17/18, SSRS, Power BI
  • Tools: SSIS ETA, SQL Server 17/18, Power BI. JIRA tool

QlikView Developer

IBM Pvt Ltd, Pune, India
02.2022 - 10.2023
  • The project is involved in loading data from SQL Server 17/18/CRM database environment to QlikView
  • Have developed multiple reports on QlikView as per client requirement.
  • Have worked on Adhoc report which requires to create complex SQL query based on the client requirements
  • Have implemented new changes in existing reports along with Data Model changes.
  • Created Extract, Transformation and Data model based on the requirements.
  • Have optimized the reports to improve the overall performance.
  • Handling technical challenges with BI Tools.
  • Have learned new technologies as per the business needs work on multiple SSRS Reports.
  • Have learned new technologies as per the business needs work on Major Power BI Report which has used two different data source environments.
  • Project Title: US Heathcare
  • Client: Amerisource Bergen Corporation
  • Skills: QlikView 12.1, SQL Server 17/18, SSRS, Power BI, CRM database
  • Tools: QlikView 12.1, SQL Server 17/18, CRM database.

QlikView Developer

Tata Consultancy Services Limited (TCSL), Mumbai, India
12.2019 - 10.2021
  • The project is involved in loading data from SQL Server 17/18/CRM database environment to QlikView
  • Have developed multiple reports on QlikView as per client requirement.
  • Have implemented new changes in existing reports along with Data Model changes.
  • Created Extract, Transformation and Data model based on the requirements.
  • Have optimized the reports to improve the overall performance.
  • Have successfully deployed all the reports based on backlogs.
  • Managing with Teams across cross locations.
  • Involved in Analytical and Design complexities for project.
  • Handling technical challenges with BI Tools.
  • Have worked on Adhoc report which requires to create complex SQL query based on the client requirements
  • Project Title: US Heathcare
  • Client: Amerisource Bergen Corporation
  • Skills: QlikView 12.1, SQL Server 17/18, CRM database
  • Tools: QlikView 12.1, SQL Server 17/18, CRM database.

QlikView Developer

Tata Consultancy Services Limited (TCSL), Mumbai, India
04.2018 - 11.2019
  • The project is involved in loading data from DataStage environment to QlikView
  • Have developed several reports on QlikView as per client requirement.
  • Have implemented new changes in existing reports along with Data Model changes.
  • Have migrated the data source from data lake to CMS database.
  • Created Extract, Transformation and Data model based on the requirements.
  • Have optimized the reports to improve the overall performance.
  • Have successfully deployed all the reports based on sprints.
  • Managing with Teams across cross locations.
  • Involved in Analytical and Design complexities for project.
  • Handling technical challenges with BI Tools and ETL.
  • Experience of working in Agile methodology.
  • Have developed QlikView NPrinting Reports and Distributed to the respective Business Groups via Email.
  • Project Title: US Mfg. and Automobile
  • Client: Fiat Chrysler Automobile
  • Skills: QlikView 12.1, Qlik Sense, QlikView NPrinting Version 16 and 19, SQL.
  • Tools: QlikView, Qlik Sense, QlikView NPrinting, SQL Query Editor.

QlikView/Qlik Sense Administrator

Tata Consultancy Services Limited (TCSL), Mumbai, India
01.2017 - 04.2018
  • QlikView/Qlik Sense Management Console monitoring
  • Data extraction from SAP-BW, Excel.
  • Daily reports construction and distribution to its key users
  • Working with clustered environment.
  • Manage security for all QlikView applications.
  • Incidents initial investigation.
  • Responsible for resolving QlikView/Qlik Sense Production server related issues.
  • Upgradation of QlikView/Qlik sense.
  • Project Title: Reporting Support
  • Client: Cargotec
  • Skills: Informatica Power Center, QlikView, Qlik Sense, SQL.
  • Tools: QlikView, Qlik Sense

Trainee

Tata Consultancy Services Limited (TCSL), Trivandrum, India
09.2016 - 12.2016
  • Data ware Housing Concepts.
  • Creation of Tables in Oracle.
  • Creation of Mappings in Informatic PowerCenter.
  • Creation of Business Object Reports and dashboard.
  • Team building skills
  • Business Oriented Skills.
  • Program Name: Initial Learning Program (ILP)
  • Description: Tata Consultancy Services conducted Initial Learning Program to groom new joiners into working professional for IT industry.
  • Skills: Data warehousing, SQL, Business Data Visualization.
  • Tools: Informatica PowerCenter 9.6.1 SQL Developer and BI Tools.

Education

Bachelor of Engineering - Electronics and Communication

Govt. Engineering College
06.2016

Standard XII / H.S.C - Science

Govt. School for Excellence
06.2012

SSC X - undefined

Govt. School for Excellence
06.2010

Skills

  • ETL development
  • Dashboard creation
  • SQL Development
  • Business intelligence tools - QlikView, QlikSense & Power BI
  • Data modeling
  • Project documentation
  • Software development tools: JIRA, confluence
  • Agile development methodologies
  • Data migration using SSIS
  • Cross-functional collaboration

Certification

  • QlikView for Beginners - Practical QlikView (Udemy) - 2017-11-14
  • Become an Expert of Qlik Set Analysis (Udemy) - 2018-05-08
  • Power BI – The Ultimate Orientation (Udemy) - 2018-06-12

Personal Details

English
Hindi

Travelling & Videography

My hobby combines travelling and videography, allowing me to explore new places while capturing meaningful moments through my lens. Travelling enriches my understanding of different cultures, landscapes, and lifestyles—it brings excitement, adventure, and learning to my life. Videography complements this passion by enabling me to tell visual stories, whether it's a serene mountain sunrise or the bustling streets of a new city. I enjoy editing these videos to creatively showcase my experiences, helping me relive them and share them with others. This hobby not only improves my technical skills but also fuels my creativity and curiosity.

Timeline

Data Migration/ BI Developer

IBM Pvt Ltd, Pune, India
10.2023 - Current

QlikView Developer

IBM Pvt Ltd, Pune, India
02.2022 - 10.2023

QlikView Developer

Tata Consultancy Services Limited (TCSL), Mumbai, India
12.2019 - 10.2021

QlikView Developer

Tata Consultancy Services Limited (TCSL), Mumbai, India
04.2018 - 11.2019

QlikView/Qlik Sense Administrator

Tata Consultancy Services Limited (TCSL), Mumbai, India
01.2017 - 04.2018

Trainee

Tata Consultancy Services Limited (TCSL), Trivandrum, India
09.2016 - 12.2016

Standard XII / H.S.C - Science

Govt. School for Excellence

SSC X - undefined

Govt. School for Excellence

Bachelor of Engineering - Electronics and Communication

Govt. Engineering College

Similar Profiles

  • Anand Godbole

    Anand GodboleAnand Godbole

    Junior Executive at Johnson Controls India Pvt Ltd, Pune, IndiaJunior Executive at Johnson Controls India Pvt Ltd, Pune, India

  • Shrinivas Behede

    Shrinivas BehedeShrinivas Behede

    Head of Finance (Senior Manager ) at Sapa Extrusion India Pvt Ltd Formerly Known as Sapa Precision Tubing Pune Pvt. Ltd.Head of Finance (Senior Manager ) at Sapa Extrusion India Pvt Ltd Formerly Known as Sapa Precision Tubing Pune Pvt. Ltd.

  • Abhijeet Sarode

    Abhijeet SarodeAbhijeet Sarode

    Associate Scientist at Monolom India Pharma Pvt. Ltd.Hinjewadi,PuneAssociate Scientist at Monolom India Pharma Pvt. Ltd.Hinjewadi,Pune

  • PRADEEP KUMAR S M

    PRADEEP KUMAR S MPRADEEP KUMAR S M

    Data Migration Engineer and Ab Initio and Data Stage Developer at WIPROData Migration Engineer and Ab Initio and Data Stage Developer at WIPRO

  • Raviteja UPPU

    Raviteja UPPURaviteja UPPU

    Power BI Developer | Data Analyst & Data Engineer at Cognizant TechnologyPower BI Developer | Data Analyst & Data Engineer at Cognizant Technology

CREATE PROFILE
ARUN PAWAR