Vishal Bhomia
Verified Expert in Engineering
Software Development Lifecycle (SDLC) Developer
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
Experience
- Stored Procedure - 9 years
- SQL - 9 years
- Software Development Lifecycle (SDLC) - 9 years
- T-SQL (Transact-SQL) - 9 years
- Data Warehousing - 7 years
- Data Visualization - 4 years
- Microsoft Power BI - 3 years
- Sisense - 3 years
Availability
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
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.
Data Engineer
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.
Data Engineer
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.
Senior Software Engineer
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.
Associate Consultant
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.
Software Engineer
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.
Experience
Data Visualization for eCommerce Giant's Leaders
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
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
Education
Specialization in Artificial Intelligence
IIIT, Banglore - Banglore
Bachelor's Degree in Information Technology
Rajasthan Technical University - Rajasthan
Certifications
Machine Learning
IIIT, Banglore
Skills
Libraries/APIs
Google Maps API
Tools
Microsoft Power BI, Microsoft Visual Studio, SSAS, Excel 2016, Microsoft Excel, Sisense, PyCharm, Tableau
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, 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
Frameworks
ASP.NET
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring