Vaibhav is available for hire
Hire VaibhavVaibhav Agrawal
Verified Expert in Engineering
Data Analyst and Developer
Mumbai, Maharashtra, India
Toptal member since January 4, 2024
Bio
Vaibhav is a seasoned professional skilled in Microsoft Power BI and SQL who turns raw data into actionable insights. With expertise in seamless database integration, he creates dynamic visualizations that empower businesses to make informed decisions. Committed to excellence, Vaibhav optimizes data models for efficient strategies, showcasing innovation and proficiency in the dynamic field of data analytics.
Portfolio
Adishwara Finnovation Pvt. Ltd.
Microsoft Power BI, Microsoft Excel, SQL, Data Analysis, Windows 10, Teamwork...
Indus Net Technologies
Microsoft Power BI, Microsoft Excel, Azure, SQL, Data Analysis, Management...
GRRAS Solutions Pvt
Python 3, Microsoft Excel, NumPy, Pandas, Machine Learning, MATLAB, Windows 10...
Experience
- Windows 10 - 7 years
- Microsoft Power BI - 3 years
- Data Analysis - 3 years
- Microsoft Excel - 3 years
- Teamwork - 3 years
- Data Analytics - 3 years
- SQL - 2 years
- Python - 1 year
Availability
Part-time
Preferred Environment
Windows 10, Microsoft Excel
The most amazing...
...project I've led was a ground-breaking Microsoft Power BI project that revolutionized real-time analytics and earned accolades for efficiency.
Work Experience
Senior Data Analyst
2023 - PRESENT
Adishwara Finnovation Pvt. Ltd.
- Developed a Microsoft Power BI solution using DAX and Power Query to automate the monthly manual Excel work involved in the communication between investors and the non-banking financial company (NBFC) during the securitization process.
- Created a master data file by consolidating information from diverse and varied data structures across multiple Excel files, employing macros to streamline the process and ensure compatibility with the database.
- Generated a critical audit matters (CAM) or teaser report encompassing concise summaries, product details, financials, credit ratings, and shareholding patterns.
- Leveraged SQL Server Management Studio (SSMS) for efficient database development, administration, and maintenance.
- Designed and implemented robust ETL processes using SQL Server Integration Services (SSIS).
- Implemented strategies in SSMS and SSAS to optimize database performance, ensuring efficient query execution and analysis.
Technologies: Microsoft Power BI, Microsoft Excel, SQL, Data Analysis, Windows 10, Teamwork, Research, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), ETL, SSAS
Data Analyst
2021 - 2023
Indus Net Technologies
- Designed a Microsoft Power BI report for a pharmaceutical company, showcasing sales data and top products by region. I also implemented row-level security for data confidentiality and handled data cleaning, integrity, and modeling.
- Collaborated with the data architect to oversee the data pipeline within Azure services. I leveraged flat and CSV files to construct data models and develop a Microsoft Power BI report.
- Conducted data transformation, including adding calculated columns, managing relationships, creating different measures, removing rows, replacing values, and splitting columns.
- Created bookmarks, buttons, selections, calculated fields, parameters, and hierarchies using Microsoft Power BI.
- Developed and maintained SQL databases, handling schema design and normalization. I created and optimized stored procedures and functions to enhance database functionality.
- Worked closely with stakeholders to gather and understand business requirements for reporting and analysis.
- Teamed with cross-functional groups, including database administrators, data architects, and business analysts.
- Integrated Microsoft Power BI with SQL databases to extract and visualize data effectively.
- Partook in data migration projects, including data extraction, transformation, and loading processes.
- Identified and resolved SQL-related issues and errors.
Technologies: Microsoft Power BI, Microsoft Excel, Azure, SQL, Data Analysis, Management, Teamwork, Windows 10, Research, CSV
Python Developer and Data Engineering Intern
2020 - 2021
GRRAS Solutions Pvt
- Created a Bangalore house price forecasting model with uncleaned, unbalanced data. This required applying exploratory data analysis, ensemble methods, and linear regression to tackle outliers and measure model performance.
- Performed data wrangling, visualization, scattering, and collection using Python modules, including NumPy, Pandas, Matplotlib, Seaborn, and scikit-learn.
- Leveraged Flask and Django for website creation using Python and Visual Studio.
Technologies: Python 3, Microsoft Excel, NumPy, Pandas, Machine Learning, MATLAB, Windows 10, Scikit-learn, Teamwork, Python, Research, Matplotlib, Seaborn, Flask, Django, Visual Studio
Experience
Financial File Report
This project involved developing a Microsoft Power BI solution using DAX and Power Query. This solution automated the monthly manual Excel work involved in the communication between investors and a non-banking financial company (NBFC) during the securitization process.
Education
2020 - 2022
Master of Business Administration (MBA) in Information Technology
Swami Vivekanand Subharti University - Meerut, India
2017 - 2020
Bachelor of Fine Arts Degree in History
Bundelkhand University - Jhansi, India
Certifications
NOVEMBER 2023 - PRESENT
Power BI
TestDome
OCTOBER 2023 - PRESENT
15 Days of Power BI – Complete Microsoft Power BI Bootcamp
Udemy
SEPTEMBER 2021 - PRESENT
Applied Data Science with Python – Level 2
IBM
MAY 2021 - PRESENT
Data Science Foundations – Level 1
IBM
MAY 2021 - PRESENT
Python for Data Science
IBM
MARCH 2021 - PRESENT
Microsoft Technology Associate – Introduction to Certified Programming Using Python
Microsoft
Skills
Libraries/APIs
NumPy, Pandas, Scikit-learn, Matplotlib
Tools
Microsoft Power BI, Microsoft Excel, MATLAB, SSAS, Seaborn, Visual Studio
Languages
SQL, Python 3, Python
Paradigms
Management, ETL
Frameworks
Flask, Django
Platforms
Azure
Storage
SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS)
Other
Research & Analysis, Data Analysis, Teamwork, Windows 10, IT Project Management, Data Analytics, Machine Learning, Information Technology, Research, CSV
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring