Senior Data Scientist - Engineer

2/2020 – 1/2023

Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of the data warehouse.
Intensively worked with Loan data, created over 100 BI reports about Loan Funding,
Healthcare Patient and Insurance Data, Pipeline Acidity, Milestones, Performance, and KPIs using Power BI, Tableau and SSRS
Designed and Deployed Drill Down \Drop down and parameterized\summarized reports using Tableau
Converted legacy report to automated \performance tuned tableau reports by hide unused columns, bring only needed data, minimize batches, pre-calculation, avoid nested calculations, minimized quick filters using tableau query optimization
For Power BI/Tableau dashboards Used Extract connection, data source filter, rolled up to maintain granular data, used views to implement custom SQL.
Created all types of reports using date\logical\aggregate \ window functions such as find, split, DATEADD, MAKEDATE, now, COUNTD, total, IFF, WINDOW_SUM etc.
Heavy performance tuning duties every day of reports, optimizing stored procs.
Based on the business requirements, created logic and indexed tables/views/stored Procedures.
Used JSON data with json functions and applied Row Low Level security
Created many pipelines to load data from data lake\blob into synapse using look-up activity, for each activity, if conditions, windowing etc.
Used window functions to achieve the best results to solve complex TSQL querying issues.
Designed ETL packages dealing with different data sources (SQL Server, Flat Files, Rest API, SOAP and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up and Merge Join as required using SSIS.
Used ETL to implement the Slowly Changing Transformation to maintain Historical Data in the Data warehouse.
Actively participated in migrating on-premise SQL Server schemas to the cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments;

Data Science

12/2017 – 11/2019

Extracted and Loaded SharePoint Lists and Surveys Data into SQL Server Database with SQL Server Integration Services and built around 45 reports and Dashboards with Power BI, SSRS, and Excel
Worked extensively on system analysis, design, development, testing, and implementation of projects.
Management Procedures, and Project Plan.
Good knowledge of the dimension, fact tables and designing the Data-Mart using Star schema.
Always received excellent feedback from clients for my work and performance.
Successfully Completed 3e training, excellent knowledge of conversion related to small/medium/large law firms.
The client-focused experience was able to handle and complete complex conversions, and strong knowledge of legacy data of law firms and 3e data.
Strong knowledge, excellent experience in Creating SSRS /Power BI reports, excellent DAX language skills such as logic, arithmetic calculations etc.
Strong problem-solving skills, can solve any complex TSQL issues

Business Intelligence (BI), Microsoft SQL Server Analysis Services (SSAS)