I am Prajwal Jagre, Master’s student at UT Dallas, majoring in Business Analytics and Artificial Intelligence.
I served as a Data Analyst at Accenture, where I led cross functional teams to optimize SQL queries, AWS data pipelines, delivered insights to stakeholders with BI tools.
My technical skills include Python, SQL, MS Excel (Pivot Table, V-H-X Lookup) , Power BI (Adv DAX Queries), Snowflake, DBT, Alteyrx.
A little more about myself:
I am a very chill guy, I like commenting on very unusual stuff, sounds funny, but things like these are the only way to know little more about people. Connect with me to get to know me more.
β’ Led a cross-functional team to optimize ETL processes using AWS services and refining SQL queries, achieving a significant improvement in application speed, reducing processing time by 25%.
β’ Designed and optimized data pipelines that processed 120 Terabytes of raw data, used Amazon S3 for data storage and employed AWS Lambda for automation, leading to 40% improvement in data processing speed.
β’ Optimized data modeling by integrating DBT with Snowflake, enhancing scalability and improving data processing speed by 30%, leading to faster and more efficient analytics for stakeholders.
β’ Built machine learning models to predict key business metrics, employing machine learning regression techniques such as Decision Trees and Customer segmentation, resulting in data-driven decision-making for marketing strategies.
β’ Empowered clients and stakeholders by documenting the findings and delivering comprehensive insights through Power BI dashboards to drive promotions, resulting in increased sales by 30%.
β’ Optimized loan lending processes by preparing detailed spreadsheets, utilizing pivot tables for data organization, and implementing data-driven strategies which improved loan approval time by 20%.
β’ Categorized applications using machine learning classification techniques, reviewed loan requests to determine financial reliability and creditworthiness of potential borrowers by 15% which led to decrease in loan default rates by 10%.
β’ Utilized Tableau for data visualization to extract maximum value form mortgage application data such as approval rates, trends., further presenting the analysis to senior management.