
Vishal Bhomia
Verified Expert in Engineering
Software Development Lifecycle (SDLC) Developer
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
Availability
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
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.
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.
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
Skills
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
Education
Specialization in Artificial Intelligence
IIIT, Banglore - Banglore
Bachelor's Degree in Information Technology
Rajasthan Technical University - Rajasthan
Certifications
Machine Learning
IIIT, Banglore