Over 6+ years of seasoned experience as a consultant working in MS SQL BI development and production environments with various BI tools including T-SQL, SSIS, SSAS, SSRS, Power BI, and Tableau. Designed and developed OLTPs, OLAPs as well as detailed reports within various industries such as technology, healthcare, insurance, and banking. Facilitated communication between technical teams and business stakeholders, ensuring clear understanding of financial data requirements and solutions. Conducted thorough domain analysis to understand new financial models and align data solutions with business needs. Explained complex financial data and SQL-driven insights to non-technical stakeholders, supporting informed decision-making. Pioneered the development of stored procedures, triggers, user-defined functions, and views for handling different business logic in T-SQL. Proficient in writing dynamic SQL scripts to perform bulk operations in the OLTP environment. Experience in Extracting, Transforming, and Loading (ETL) using tools like export/import data and SQL Server Integration Services (SSIS). Spearheaded a project to optimize database performance by implementing efficient table partitions, reducing query response time for large datasets.