About

Sahil Bansal is a Business and Data Analyst professional with 4.93 years of experience in collecting, managing, and converting raw data into usable information. He is currently working as a Specialist Data Architecture at Fiserv, where he is responsible for transforming data of credit unions from old legacy systems to new product Portico. He is extensively implementing advanced SQL and ETL for transforming data. Prior to his current role, Sahil worked as a Business Intelligence System Analyst at Synamedia, where he created an Enterprise Data Warehouse from scratch using Inman and Kimball. He worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support. He established new workflow processes that resulted in 70% speed gains for the company. He migrated data from Cisco to Synamedia and Local to Azure cloud. He created Data Models, Schemas in Enterprise Architecture, implemented power automate to automate manual tasks, and created 30+ reports in Power BI from scratch and managed 45+ on an Ad hoc basis. Sahil also worked as an SQL Developer cum Business Intelligence Engineer at L&T, where he gained experience as an MS SQL Server Developer & Administrator in Production, Development, and Staging Environments. He has expertise in scheduling Backup and Restore and Maintenance plans using SSMS, creating SQL objects like tables, stored procedures, views, Indexes, triggers, and scheduling Database tasks – Jobs, Schedulers, Alerts, Emails, Notifications. He also has knowledge in ETL Extracting, Transforming, and Loading data from various heterogeneous data sources Data using OLE DB connection by creating various SSIS packages. He used Microsoft SQL Server Migration Assistant (SSMA) for automatic database migration to SQL Server from Oracle and other databases. Sahil has a Bachelor's Degree in Computer Science from Chandigarh University and is currently pursuing a Master of Business Administration - MBA in Physics, Chemistry, Maths from NMIMS, which he expects to complete in August 2024. Sahil's tech stack includes SQL, ETL, Data Warehouse, DevOps, Azure, Integration, Infra, Backend, and Software Engineer. He is a highly skilled professional with a proven track record of delivering quality results in his previous roles.