May 2024 - Present
Built an advanced executive Power BI dashboard for the SVP, serving as one stop for Collections KPIs & business performance; aggregated $1B+ data from multiple sources using SQL, created stored procedures and reported in Power BI, emphasizing accuracy & intuitive design
Orchestrated a Paymetrix dashboard using Power BI and SQL to integrate multiple large data sources. Performed comprehensive analysis of 75K+ accounts, assessing the impact of the profitability index and real estate scores to determine the financial viability of legal pursuits
Integrated 5 data sources to develop a centralized report for Admin team, delivering & monitoring key Collections statistical metrics such as inbound calls, YoY analysis etc. Applied RLS to boost performance & team productivity, saving 70+ hours/year on manual reporting
Automated PBI exceptions tracking report for 16 high-risk violations across email, text and call; developed optimized SQL queries, stored procedures for daily audit logs, and an interactive monitoring report, enhancing compliance visibility and reducing regulatory risk
Conducted knowledge sessions for my team on using ADO to log & track daily tasks; acted as the primary POC for VP-level reporting by importing ADO data & building a Power BI dashboard, delivering performance insights across the team to improve functional transparency
Presented at Data Walk alongside 21 interactive exhibits, leading my team’s project on enhancing member experience, decoding member behavior, and optimizing operations through tested contact strategies—engaging 650+ attendees to look beyond numbers, translating strategy into action and insights into measurable impact
Trained 75+ analysts through live, hands-on sessions on ADO, Power BI, and SQL— fostering collaborative analytical approaches, driving cross-product and cross-team collaboration, and empowering participants to advance their expertise and career growth in data analytics
Handled 30+ ad-hoc requests – maintaining existing reports, data pull requests, file drop requests and effectively communicating trends & analysis to stakeholders and management; mentored 2 colleagues by offering direction and constrictive feedback in weekly check-ins
August 2022 - May 2024
Designed and implemented a name-matching model utilizing Python and Natural Language Processing (NLP) for the integration of two databases to support IRS tax verification
Created course structure, introduced real world case studies for practical implementation of concepts, conducted weekly lab sessions for courses - Object-Oriented Programming using Python, Data Science Techniques and Data curation
Conducted office hours/doubt sessions for undergraduate students
Conducted in-person Lab session to assist students with course work and digital curation & web archiving tool such as Conifer
August 2023 - December 2023
Built ETL pipelines with PySpark to integrate 50K+ housing prices records from 2 data sources, reducing data extraction errors by 30%
Implemented robust data cleaning, preprocessing, and exploratory data analysis to draw meaningful insights for further evaluation and model creation
Coordinated analysis of 2008 recession & COVID19 impact by optimizing time series models (ARIMA, SARIMAX, LSTM) for precise housing price predictions and trend analysis, achieving a 25% decrease in error metrics (RMSE, MEA) compared to regression models
Crafted a Tableau story and demonstrated model performances, insights & recommendations to senior management
June 2023 - August 2023
Administered requirement analysis, created, managed, and conveyed product backlog and user stories in product meetings using storyboards, resulting in process improvement and efficiency hike by 20%
Orchestrated re-sampling methodology to increase user retention rate, employed data modeling to formulate pricing strategies and identify strategic partners, resulting in a 30% network expansion for the client: facilitating 25% increase in Global market penetration
Proactively managed requirements and facilitated change through qualitative & quantitative data analysis, interviews, and surveys
Leveraged Power BI for user behavior analysis, shaping marketing strategies, resulting in a 20% boost in customer acquisition
June 2023 - August 2023
Spearheaded market research/analysis, thereby creating situation statements and project roadmaps, guiding to successful product launch
Employed elicitation techniques, managed requirements, and maintained traceability, driving alignment with business goals
Established a plan to create SQL database, accelerating customer data access, analysis, and retrieval by 30% for improved product development and visualized the Key Performance Indicators (KPIs) in Excel and Tableau to recommend solutions for identified business requirements
September 2022 - December 2022
Worked with university’s dining services to strategically design their menu with an ultimate goal of reducing greenhouse gas emissions and calories intake by 70% by 2030
Defined functional requirements for analytics and business intelligence (BI) solutions, created product roadmap & user stories, analyzed and validated data with statistical analysis (Excel, R) and data visualization (Power BI) and reported to stakeholders for university-wide strategic initiatives
Built an application with PowerApps for UMD’s dining services to track food-related greenhouse gas emissions
Created a data analysis framework with Excel, R, and Power BI. Presented insights, guiding university strategies and projecting ~8% CO2 emissions drop in 8 years
September 2019 - July 2022
Led Azure Percept DK delivery (600+ global partners) with cross-functional teams for User Acceptance Testing, maintained performance metrics, measurements, methods, and targets, and examined trends to evaluate operational efficiency
Engineered a robust SQL database structure for analyzing and consolidating 50K+ transactional records; executed data cleaning protocols and optimized SQL queries, resulting in a 70% reduction in errors, enhancing accuracy for profitability analysis
Collaborated with UX and development teams for software testing, studied feedback, identified improvements using root cause analysis, adhered to the SLA, thereby enhancing product development, and yielding a 30% increase in application efficiency and responsiveness
Developed 10+ Power BI dashboards with DAX for data modeling, unifying sources for cross-domain analytics & insights
August 2018 - December 2018
Analyzed the customer feedback data using Sentiment Analysis (NLP and Python) to understand needs of rural customers
Identified the demand for data preprocessing to enhance the quality and effectiveness of analysis processes, performed text preprocessing (tokenization, stemming, stop-word removal, POS tagging) enhancing data analysis and insights
Usage of Jio mobile phones rose by 20% in rural areas with appropriate resource allocation and sales and marketing efforts