Vaibhav Pawar
Navi Mumbai
Summary
Analytical and detail-oriented data analyst with over 6 years of experience in extracting valuable insights from complex datasets. Proficient in data manipulation, statistical analysis, and data visualization techniques. Skilled in utilizing Excel, SQL, VBA, and Power BI to interpret and communicate data-driven findings to drive informed business decisions.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Willis Towers Watson ( on Payroll of CareerNet Technologies Pvt. Ltd)
07.2023 - Current
- Developed dashboards with Power BI to monitor key performance indicators.
- Leveraged SQL queries to extract, transform and load data into databases.
- Maintained documentation of all the processes related to Data Analysis.
- Developed VBA applications to automate data processing tasks.
- Created recurring as well as ad-hoc reports as requested by various departments within the organization.
Data Analyst
Erulearning Solutions Pvt Ltd
03.2022 - 05.2023
- Created daily, monthly, and weekly reports, providing comprehensive insights and analysis to support strategic decision-making and business operations.
- Successfully migrated the reporting process from Excel to Looker Studio Dashboards and Redash Dashboards using SQL and BigQuery.
- Created Power BI Dashboards.
- Automated recurring tasks and processes using VBA macros.
Analyst
Nomura India Pvt Ltd
09.2020 - 02.2022
- Creation and delivery of Excel reports.
- Creation and extraction of Webi reports using SAP Design Studio
- Creation of Power BI Dashboards
- Automate recurring tasks and processes using VBA macros.
Analyst
eClerx Services Pvt Ltd
03.2018 - 09.2020
- Creation of Excel based revenue as well as web traffic related schedule reports.
- Data extraction from SQL database, OLAP Cube, Omniture tool as per client requirement.
- Creation of Excel reports using extracted data from multiple data sources (SQL, OLAP cube, Omniture).
- Creation of VBA based excel automation to automate schedule as well as ad- hoc reports.
- Updating SSIS package, automated excel report as an when required.
Education
Bachelor of Engineering - Information Technology
University of Mumbai
08-2016
Skills
- Advanced Excel
- Power BI
- SQL reporting
- VBA
- BigQuery
- Redash
- Looker Studio
Certification
- Data Science Prodegree from Imarticus Learning
Timeline
Senior Data Analyst
Willis Towers Watson ( on Payroll of CareerNet Technologies Pvt. Ltd)
07.2023 - Current
Data Analyst
Erulearning Solutions Pvt Ltd
03.2022 - 05.2023
Analyst
Nomura India Pvt Ltd
09.2020 - 02.2022
Analyst
eClerx Services Pvt Ltd
03.2018 - 09.2020
Bachelor of Engineering - Information Technology
University of Mumbai
Similar Profiles
Nitin Vishwanath PatilNitin Vishwanath Patil
Senior Business Analyst at Willis Towers Watson Pvt. LtdSenior Business Analyst at Willis Towers Watson Pvt. Ltd
Leena KararLeena Karar
Senior Analyst - Corporate Risk & Broking at Willis Towers Watson Pvt. Ltd.Senior Analyst - Corporate Risk & Broking at Willis Towers Watson Pvt. Ltd.
Heena SapraHeena Sapra
Administrative Assistant at Willis Towers Watson India Pvt. Ltd.Administrative Assistant at Willis Towers Watson India Pvt. Ltd.