Summary
Overview
Work History
Education
Skills
References
Timeline
Generic

Bhoj Raj Pandey

Sr. Data Analyst
Windsor,MD

Summary

Data Analyst with 7+ years of experience driving business impact through data insights across finance, telecom, and automotive industries. Skilled in SQL, Python, Tableau, Power BI, and cloud platforms (AWS, GCP). Adept in ETL development, data visualization, process mining, and dashboard creation. Experienced in Agile methodologies and cross-functional collaboration with engineering, product, and compliance teams. Known for simplifying complex datasets and aligning analytics with strategic goals.

Overview

8
8
years of professional experience

Work History

Sr. Data Analyst

Wells Fargo, MD
11.2023 - Current
  • Designed and automated scalable ETL pipelines using Python and Alteryx to streamline multi-source data processing.
  • Developed Tableau dashboards to track funnel performance and financial KPIs, improving data accessibility across teams.
  • Applied process mining in Celonis to identify workflow bottlenecks and reduce cycle times.
  • Conducted ERP Discovery Phase: mapped business processes, assessed system readiness, and supported vendor selection.
  • Standardized data definitions and validated API data flows to ensure compliance with regulatory and internal standards.
  • Mentored junior analysts and enforced best practices for documentation and data governance.
  • Facilitated cross-departmental data workshops to align goals, refine metrics, and accelerate dashboard delivery.
  • Collaborated with engineering and data architecture teams to define KPIs and enhance data model reliability.
  • Built API monitoring tools using Postman and JSON scripts to validate data transactions across Salesforce and internal apps.
  • Conducted regression testing in collaboration with QA teams using automated Selenium scripts integrated with Jira workflows.

Operational Data Analyst

Ford Company, MD
01.2021 - 10.2023
  • Built predictive models (Linear Regression, XGBoost, KNN) to forecast residual vehicle values, enhancing pricing strategy.
  • Created dashboards using Power BI and Tableau, contributing to $10M+ in revenue optimization.
  • Led experimental design (A/B testing) for marketing initiatives, enabling data-backed decision-making.
  • Managed scalable data workflows using BigQuery and Vertex AI on GCP.
  • Automated recurring analytics processes using Alteryx, reducing manual hours by 35%.
  • Integrated telematics and auction data sources to improve vehicle lifecycle forecasting models.
  • Worked with finance teams to create scenario-based simulation models for remarketing strategy testing.
  • Used Qlik Sense and Looker to track vehicle depreciation trends across different regions and product lines.
  • Collaborated with inventory planners and IT teams to integrate Snowflake data models with custom-built demand dashboards.
  • Deployed version-controlled model artifacts using Git and facilitated CI/CD workflows for analytics code in collaboration with DevOps.

Sales Data Analyst

T – Mobile, MD
02.2018 - 12.2020
  • Analyzed national sales data, built forecasting models, and drove territory-level performance improvements by 15%.
  • Created interactive dashboards using Tableau and Power BI for leadership visibility.
  • Automated reporting pipelines using Python and SQL, cutting report delivery time by 40%.
  • Performed churn and ARPU analysis to optimize customer retention and upsell strategies.
  • Integrated external market data to identify white space and improve segmentation models.
  • Supported regional leadership in sales operations reviews by preparing KPI scorecards and insights briefs.
  • Participated in CRM system enhancement sessions to improve data quality and sales reporting accuracy.
  • Conducted root cause analysis using Excel Power Query and SharePoint data to identify sales bottlenecks.
  • Built mobile-friendly dashboards for field sales teams using Power BI Embedded APIs.
  • Documented BRDs and UAT test cases for quarterly CRM system upgrades in collaboration with business and tech teams.

Education

Bachelor of Science - CS and Data Science

University of Maryland Baltimore County

Master of Science - Physics

Tribhuvan University

Skills

- Languages & Querying: SQL, Python (Pandas, NumPy), Excel (Power Query, Pivot Tables)

References

Reference upon Request

Timeline

Sr. Data Analyst

Wells Fargo, MD
11.2023 - Current

Operational Data Analyst

Ford Company, MD
01.2021 - 10.2023

Sales Data Analyst

T – Mobile, MD
02.2018 - 12.2020

Master of Science - Physics

Tribhuvan University

Bachelor of Science - CS and Data Science

University of Maryland Baltimore County

Similar Profiles

CREATE PROFILE
Bhoj Raj PandeySr. Data Analyst