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.

Portfolio

Standard Chartered
SQL, SQL Server Integration Services (SSIS), Microsoft Power BI, C#.NET...
Digital Bulldogs, LLC
Data Engineering, Reports, Business Intelligence (BI)...
Evolent Health International
Python, SQL, SQL Server Integration Services (SSIS), Query Optimization...

Experience

Availability

Part-time

Preferred Environment

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

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

Data Engineer

2020 - PRESENT
Standard Chartered
  • Developed detailed RWA analysis tool including data retrieval, transformation, and loading, following an automated schedule, to populate data warehouse and refresh reports. The tool helped more than 250 finance experts to make better decisions.
  • Deployed and developed a valuation model which was designed to gather inputs 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 which reduced the overall analysis time and reduced 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

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), Azure SQL Data Warehouse (SQL DW), Data Architecture, Azure Active Directory, Automated Data Flows

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

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.

Languages

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

Paradigms

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

Storage

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

Other

Software Development Lifecycle (SDLC), Data Engineering, Relational Database Design, SQL Server 2019, 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, Azure SQL Data Warehouse (SQL DW), Data Architecture, Automated Data Flows

Frameworks

ASP.NET

Tools

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

Libraries/APIs

Google Maps API

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