Financial Services
Hospitals and Health Care
Real Estate and Equipment Rental Services
Technology, Information and Media
Active

Amol B

Data Analyst

About Me

Data Analyst with 4+ years of experience, including at Airbnb, analyzing 5M+ user interactions to drive a 7% lift in booking conversion. Expert in SQL, Python, and BI tools to deliver insights and optimize product performance. MS in Information Technology, UT Dallas (2025). Proven record of building scalable analytics pipelines and dashboards that reduce reporting time by 75% and improve forecasting accuracy.

Jurisdiction

United States

Experience

Seniority LevelMid-Senior level
Years of Experience6-10 years
Current StatusActive
Data AnalystBNY Mellon
2026 - Present

● Scaled Power BI dashboards across 300K+ financial transaction records, enabling real-time risk and compliance visibility for 8+ stakeholders and supporting Q1 financial planning decisions. ● Enabled ~30% faster ad hoc insights by leveraging BNY's Eliza AI APIs to accelerate financial workflows and support business decisions. ● Orchestrated Apache Airflow pipelines on Azure within Agile sprints, automating data ingestion and strengthening data governance.

Product Data AnaystAirbnb
2021 - 2023

● Performed funnel analysis on 5M+ user events using SQL (CTEs, window functions) and Python, uncovering drop-offs to inform A/B testing and regional pricing strategies, contributing to a 7% increase in booking conversion. ● Optimized Snowflake SQL queries through clustering and query tuning, reducing dashboard runtime from 20s to 7s across 130+ analytics workloads, improving dashboard responsiveness for stakeholders. ● Built Tableau dashboards to track platform KPIs and A/B testing results, improving demand forecasting accuracy by 9%. ● Designed dimensional models in Snowflake integrating platform and marketplace sources, standardizing KPI definitions across 6 business squads and improving consistency of executive insights and decision-making. ● Reduced production report inconsistencies by 30%, implementing automated data validation, quality checks, and schema tests in dbt throughout 40+ Snowflake warehouse tables. ● Improved pipeline reliability by managing 8 automated SSIS ETL workflows with error logging and traceability across business reviews. ● Led stakeholder review sessions with cross-functional teams, translating business questions into SQL insights that informed 15+ product and pricing decisions, documenting KPIs in Jira and Confluence.

Data AnalystRobosoft Technologies
2020 - 2021

● Analyzed 1.4M+ transactional and user-behavior records from MySQL and Google Analytics 4 leveraging SQL and Python, generating weekly KPI reports for 18 product and marketing stakeholders to monitor performance. ● Developed 23 Power BI dashboards with DAX and SQL to centralize business performance metrics, enabling leadership to review insights faster and reducing executive analytics delivery time by 75%. ● Integrated 9 operational sources through Python (Pandas) and REST APIs into centralized analytics tables in an Azure cloud platform, supporting 30+ BI requests with 99%+ accuracy. ● Identified high-risk customer segments through predictive churn modeling in Python (Pandas, scikit-learn) on Snowflake, driving a 12% improvement in campaign targeting effectiveness. ● Audited 220K+ records with Alteryx workflows, improving accuracy and ensuring compliance with governance and SDLC standards

Skills

Core skills0
Languages2

Languages

Hindi
English