Data Analyst, Product and Risk Analytics

June 2023 – Present

• Performed comprehensive credit risk assessment on a $100M loan portfolio using Python, Pandas, NumPy, BigQuery SQL, and Tableau; employed Decision Trees, Random Forests, XGBoost by utilizing Bureau, Clarity, LexisNexis data to identify key risk indicators, which led to a 17% reduction in potential losses through targeted risk mitigation strategies.
• Leveraged CK LB MBE (Credit Karma Model Building Environment) – Jupyter Notebooks for data preprocessing, analysis on population sample, applicants, and tradelines (Equifax, TU, Experian) datasets to identify credit attributes contributing to overall higher delinquency rates.
• Utilized Chi – square tests, ANOVA, and Recursive Feature Elimination (RFE) to validate the statistical significance of variables, ensuring model reliability and optimizing the feature selection process.
• Developed data-driven risk strategies and revamped grading mechanisms using swap sets, cohort analysis, and time series analysis; reduced overall risk exposure by 12% through optimized financial metrics such as ALR, RAY and Delinquency %.

Data Analyst/Data Engineer

January 2023 – June 2023

• Part of modernizing National Grid’s DWH platform by migrating legacy Oracle DWH to Snowflake Cloud Datawarehouse and sunset MicroStrategy by migrating reports to Power BI project.
• Migration of 47 Downstate DataMart’s – Active (14), Inactive (33) – Lift and shift of 33 inactive DataMart’s from 8370 tables into Snowflake staging layer.
• Migrated all active data ingestion flows (688) from Informatica (Downstate) to Matillion for all active DataMart’s using Python and SQL
• Used SQL to replace existing transformation logic in Oracle procedures with Snowflake.

Developer (Capstone Project)

August 2022 – December 2022

Redfish Server Implementation using OpenAPI

• DMTF’s Redfish is a standard designed to deliver simple and secure management for converged, hybrid IT and the Software-Defined Data Center.
• Created the database tables and initialized the data for Account, Session, Task, Root, and Event services from the mockups bundle.
• Built a Redfish Event Service protocol, that enables the communication between IoT devices.
• Worked on Spring Boot Server and used OpenAPI to generate code for some of the endpoints.
• Used testing frameworks such as JUnit and Mockito for unit testing of java applications.

Junior Data Analyst

July 2020 – June 2021

• Conducted data analysis using Data Wrangling, Python automation, and SQL optimization on Snowflake data warehouse.
• Performed Exploratory Data Analysis (EDA) using Pandas and NumPy for predictive modeling, applying statistical techniques to derive meaningful conclusions and recommendations.
• Created Python scripts for task automation, including generating daily reports and facilitating email communications.
• Collaborated on reusable code and Data Pipelines, enhancing analytic efficiency by 15%, tracked project progress with JIRA, and organized project-related materials in Confluence.