Work Experience

Business Solutions Analyst

Brookline Bank | USA Jan, 2024 - Present

  • Diagnosed 45+ business user’s operational bottlenecks and proactively recommended new features in existing banking platform through process mapping and data flow diagrams for Deposit, Loans, Risk, and Anti Money Laundering (AML) teams.
  • Architected and automated Customer Complaint Resolution System for the bank’s Compliance department, cutting complaint resolution time by 47% and maximizing customer reviews from 3.7 to 4.5 stars in 4 months.
  • Conducted ATM transaction volume analysis for 60+ branches and projected 18% revenue increase through performance forecasting.
  • Automated challenging workflows using Smartsheet and PowerBI, reducing monthly invoice approval time from 16 hours to 2hours/month.
  • Created PowerBI dashboard automation for leadership to perform actual costs vs budget analysis for 55+ banking apps, driving process improvements,cost management and operational performance.

Business Intelligence Analyst Intern

Bangor Savings Bank | USA Jul, 2022 - Dec, 2022

  • Led analysis, design, development, testing, and implementation of an enhanced banking reporting feature, saving 19 hours/week in retrieving customers, transaction and loan information.
  • Analyzed 100k+ rows of financial data using SQL, developed SQL Server ETL data migration and integration solutions, reducing multiple report’s load time from 15 minutes to 2.5 minutes.
  • Developed product backlog, acted as a liaison between business line, developers, and IT teams. Coordinated story grooming sessions and project schedules, prioritized backlog, and defined acceptance criteria, aligning delivery timelines and budgets.
  • Collaborated with 12+ stakeholders through interviews, gathered and documented business requirements, identified KPIs, ensuring alignment with organizational goals.
  • Coordinated User Acceptance Testing (UAT) by partnering with business users and creating and executing test cases that resulted in proactively identifying and resolving 13 bugs before launching the reporting feature

Business Analyst

Rentastico Pvt Ltd | India Feb, 2020 - Jul, 2021

  • Partnered with Product Owner to understand the product vision and to define a product roadmap following SDLC for a travel website in Asia with 1 Million+ estimated users.
  • Performed market research and competitor analysis to understand targeted audience’s pain areas, crafted customer journeys, process flow diagrams, workflows using Visio and suggested Top 6 MVP features based on market insights.
  • • Leveraged Agile methodologies, built prioritized product backlog with epics, user stories in JIRA, enhancing sprint cycle efficiency by achieving a 90% sprint goal success rate.
  • Coordinated 8+ projects simultaneously, liaising between Asian business teams, developers, and North American UX/UI vendors to synchronize requirements, achieving a reduction in avg response times for critical queries by 1 business day.
  • Facilitated product/sprint reviews for project stakeholders communicating benefits, identifying potential risks, and mitigation strategies while gathering crucial stakeholder feedback.

Business Data Analyst

VSigma IT Labs | India Oct, 2019 - Feb, 2020

  • Gathered 10K+ rows of customer review data from multiple sources and eliminated discrepancies
  • Analyzed 10K+ customer reviews for North American telecom carriers using Python and SQL, identified and documented the trends for contract termination or switching to competitor’s network
  • Presented key findings and insights to senior leadership using interactive dashboard in Tableau to demonstrate top 3 reasons such as poor coverage, plan cost and device offerings to drive data driven business decisions

Education

Northeastern University, USA

Masters in Data Analytics Engineering Aug 2023

Relevant Coursework:

  • Business Analytics
  • Data Warehouse and Business Intelligence
  • Software Engineering
  • Project Management
  • Data Visualization
  • Data Management for Analytics

Projects

Yelp Data Migration and Insight Analysis

Github
  • Designed GCP data engineering pipeline to extract Yelp data, store in GCS via Apache Beam, and transform/load into BigQuery with Data Fusion.
  • Built a Tableau dashboard with 10+ visualizations for business insights, focusing on user engagement and income/restaurant density analysis.

Workspace Optimization

Github
  • Devised a database integration approach that consolidates an office’s infrastructure and supplies cost by 22% through allotting workspaces to employees only on a requirement/ reservation basis
  • Analyzed 10,000+ open-source workspace records, crafting SQL queries and subqueries, implementing triggers, constraints, and views for optimized data access and processing efficiency.

Fatal Police Shootings in USA

Github
  • Targeted data wrangling and data visualizations using ggplot library in R on a dataset with more than 8,000 records and 26 columns by performing cross-tab analysis over various indicators and trends based on the fatal encounters
  • Formulated an interactive dashboard in Tableau and identified the major cities, threats, races of the deceased, and reasons of every fatal shooting in the US by a police officer since Jan 1, 2015
Check out my tableau public profile!

Leadership

Divisional President

Street Cause – GRIET | India Apr, 2018 – Jun, 2019

  • Raised over $10,000 and provided support to 1500+ underprivileged and differently-abled individuals by managing a team of 60 students and organizing impactful events and fundraisers for self-employment opportunities.
  • Bestowed with Best Divisional President Award.

Graduate Teaching Assistant - Data Integration & BI

Northeastern University | USA Jan, 2023 – May, 2023

  • Mentored graduates, demonstrating expertise in building robust data pipelines on Talend, PostgreSQL and Google Cloud Platform (GCP).
  • Guided teams on key aspects of data warehousing, covering dimensional modeling (Star/Snowflake), data security and workflow optimization.