Vishal Bhomia, Developer in Pune, Maharashtra, India
Vishal is available for hire
Hire Vishal

Vishal Bhomia

Verified Expert  in Engineering

Software Development Lifecycle (SDLC) Developer

Location
Pune, Maharashtra, India
Toptal Member Since
October 13, 2021

Vishal is a technically sophisticated professional with a decade-long experience as a data engineer with proficiency in business intelligence and data analysis, having extensive hands-on experience in Microsoft SQL, Power BI, and data orchestration. He has created data pipelines for diverse lines of business like banking, healthcare, and insurance. Vishal is proficient in query optimization and improving the data orchestration process with a deep knowledge of C#.NET, Python, SSIS, and SSRS.

Availability

Part-time

Preferred Environment

SQL, SQL Server Data Tools (SSDT), SQL Server Integration Services (SSIS), Microsoft Power BI, Microsoft Visual Studio, PyCharm, Python, SQL Triggers, SQL Server 2017, Sisense

The most amazing...

...thing I have developed is a warehouse and its related set of reports around banking risk weight assets, eventually reducing the manual efforts for risk analysis

Work Experience

Senior BI Developer

2022 - PRESENT
Perch Insights
  • Developed end-to-end data pipelines, connecting to several sources and integrating all the sources to create a single source of truth for easy and efficient reporting.
  • Developed automated housekeeping jobs to reclaim unwanted resources.
  • Enhanced and improved the standards to be followed for report development and insight generation.
Technologies: RDBMS, Sisense

Data Engineer

2022 - 2023
Digital Bulldogs, LLC
  • Provided an easy and user-friendly solution to manage and generate reports with flexible filtering options.
  • Shifted the client from a cumbersome power apps platform to the new Python-based web application, which is far more flexible, fast, and scalable.
  • Enabled the client to generate self-servicing reports reducing overall efforts and time to generate reports by different dimensions.
Technologies: Data Engineering, Reports, Business Intelligence (BI), Dedicated SQL Pool (formerly SQL DW), Azure SQL Data Warehouse, Data Architecture, Azure Active Directory, Automated Data Flows

Data Engineer

2020 - 2022
Standard Chartered
  • Developed a detailed RWA analysis tool that includes data retrieval, transformation, and loading, following an automated schedule to populate data warehouse and refresh reports. The tool helped more than 250 finance experts make better decisions.
  • Deployed and developed a valuation model that was designed to gather input from various sources and evaluate a business unit in the bank. This resulted in the future valuation of the bank's assets and liabilities.
  • Automated many data analysis activities, reducing overall analysis time and manual intervention and errors.
Technologies: SQL, SQL Server Integration Services (SSIS), Microsoft Power BI, C#.NET, Requirements Analysis, Data Warehousing, Data Cleaning, Data Analysis, Data Visualization, SQL Stored Procedures, Stored Procedure, SQL Functions, SQL DML, SQL DDL, Microsoft Data Transformation Services (now SSIS), Software Development Lifecycle (SDLC), Data Engineering, Visualization, Data Modeling, Relational Databases, Data Cleansing, Data Loading, Database Analytics, Data Analytics, Dimensional Modeling, RDBMS, Entity Relationships, Relational Database Design, Relational Data Mapping, SQL Server Analysis Services (SSAS), SSAS, SQL Server 2019, ETL, Dashboard Development, C#, Database Schema Design, Database Design, Logical Database Design, Business Intelligence (BI), MSBI, T-SQL (Transact-SQL), Excel 2016, Microsoft Excel, Microsoft SQL Server, Data Extraction, CSV, MySQL

Senior Software Engineer

2019 - 2020
Evolent Health International
  • Replaced a SQL-based engine with a Python-based engine for calculating a members' risk score based on suspect conditions, age, gender, and similar other criteria.
  • Developed automated process to load new suspect conditions and models for Medicare and Medicaid from CMS each year.
  • Analyzed and resolved deadlocks that were causing a lot of delay in processes and also resulted in re-running of the whole process.
Technologies: Python, SQL, SQL Server Integration Services (SSIS), Query Optimization, Requirements Analysis, Data Warehousing, Data Analysis, SQL Stored Procedures, Stored Procedure, SQL Functions, SQL DML, SQL DDL, Indexing, Microsoft Data Transformation Services (now SSIS), Software Development Lifecycle (SDLC), Data Engineering, Data Modeling, Relational Databases, Data Loading, Database Analytics, Data Analytics, Dimensional Modeling, RDBMS, Entity Relationships, Relational Database Design, Relational Data Mapping, SQL Server Analysis Services (SSAS), SSAS, Software Troubleshooting, ETL, SQL Server 2012, Dashboard Development, C#, Database Schema Design, Database Design, Logical Database Design, Business Intelligence (BI), MSBI, T-SQL (Transact-SQL), Excel 2016, Microsoft Excel, Microsoft SQL Server, MySQL, PostgreSQL

Associate Consultant

2015 - 2019
Capgemini
  • Automated process of creating new insurance plans thereby reducing the number of issues reported in plan creation significantly.
  • Initiated using a Known Error Database (KEDB) for supporting the insurance application. This helped in resolving issues in a faster and better way.
  • Improved the count of issues resolved per week by automating multiple manual processes and thereby reducing errors as well.
Technologies: SQL, C#.NET, SQL Server Integration Services (SSIS), Stored Procedure, Query Optimization, Requirements Analysis, Data Analysis, SQL Stored Procedures, SQL Functions, SQL DML, SQL DDL, Software Development Lifecycle (SDLC), Microsoft Data Transformation Services (now SSIS), Data Engineering, Relational Databases, Data Cleansing, Data Loading, Data Analytics, RDBMS, Entity Relationships, Relational Database Design, Relational Data Mapping, SQL Server 2012, Software Troubleshooting, ETL, ASP.NET, C#, T-SQL (Transact-SQL), Excel 2016, Microsoft Excel, Microsoft SQL Server

Software Engineer

2012 - 2015
Syntel
  • Developed a timely data archival process that reduced data in the main database and improved the performance of the application.
  • Optimized the application response time by implementing pagination in the ASP pages of the application.
  • Suggested and implemented Lean idea of replacing Google Maps in application with a freeware map with improved features and cost-saving.
Technologies: C#.NET, VB.NET, SQL, SQL Server Integration Services (SSIS), Software Development Lifecycle (SDLC), Requirements Analysis, Data Analysis, SQL Stored Procedures, Stored Procedure, SQL Functions, SQL DML, SQL DDL, Indexing, Microsoft Data Transformation Services (now SSIS), Data Engineering, Relational Databases, Data Loading, Database Analytics, Data Analytics, RDBMS, Entity Relationships, Relational Database Design, SQL Server 2012, Software Troubleshooting, ETL, ASP.NET, C#, T-SQL (Transact-SQL), Excel 2016, Microsoft Excel, Microsoft SQL Server

Data Visualization for eCommerce Giant's Leaders

The independent project created a continuously refreshing dashboard for an apparel eCommerce platform.

The data was fed daily via XML and Excel files and dumped in a data warehouse. This warehouse became the base for dashboards showing region-wise sales trends. Another dashboard was built to deliver a funnel of clicks to sale conversion.

Google Maps API integration

This ASP.NET-based project involved developing a small application that would populate the nearest service provider based on the pin and its corresponding latitude and longitude fetched from Google Maps API.

The service was used to send across a set of service providers and their location to Google Maps and in turn and get the corresponding distance from the location. The nearest few were stored in DB for the end-user to select.

RDBMS for Lead Management

A SQL-based relational database model enabled the organization to store and track the progress and status of its leads. The system was used to send autogenerated alerts for pending actions on leads and highlighted the best sources from which quality and successful leads came in.
2019 - 2020

Specialization in Artificial Intelligence

IIIT, Banglore - Banglore

2007 - 2011

Bachelor's Degree in Information Technology

Rajasthan Technical University - Rajasthan

FEBRUARY 2020 - PRESENT

Machine Learning

IIIT, Banglore

Libraries/APIs

Google Maps API

Tools

Microsoft Power BI, Microsoft Visual Studio, SSAS, Excel 2016, Microsoft Excel, PyCharm, Tableau, Sisense

Paradigms

Database Design, Requirements Analysis, Dimensional Modeling, Business Intelligence (BI), ETL

Frameworks

ASP.NET

Languages

SQL, Stored Procedure, SQL DML, SQL DDL, C#.NET, VB.NET, C#, Python, T-SQL (Transact-SQL)

Storage

Databases, SQL Stored Procedures, SQL Functions, Relational Databases, RDBMS, SQL Server 2012, SQL Server 2019, Microsoft SQL Server, SQL Server Data Tools (SSDT), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), MySQL, Azure SQL Databases, SQL Triggers, SQL Server 2017, Azure Active Directory, PostgreSQL

Platforms

Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW)

Other

Software Development Lifecycle (SDLC), Data Engineering, Relational Database Design, Database Schema Design, Logical Database Design, Query Optimization, Data Warehousing, Data Cleaning, Data Analysis, Data Visualization, Indexing, Microsoft Data Transformation Services (now SSIS), Visualization, Data Modeling, Data Cleansing, Data Loading, Database Analytics, Data Analytics, Entity Relationships, Relational Data Mapping, Software Troubleshooting, Dashboard Development, MSBI, Data Extraction, CSV, Machine Learning, Data Warehouse Design, Interactive Dashboards, Reports, Data Architecture, Automated Data Flows

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