Chris Bhansali
Boston,MA
Summary
Results-driven Business Intelligence Analyst with expertise in SQL and Python, honed at Cohesity Inc. Achieved a 30% reduction in manual data preparation through automated ETL pipelines. Skilled in data modeling and business process improvement, I excel in delivering actionable insights and fostering data-driven decision-making across teams.
Overview
3
3
years of professional experience
Work History
Business Intelligence Analyst 2
Cohesity Inc.
Boston, USA
01.2024 - Current
- Built automated ETL pipelines using Python and SQL integrating Salesforce, Certinia, Smartsheet, and Workday HR data into Snowflake, reducing manual data preparation by 30%.
- Developed dimensional data models and semantic layers standardizing KPIs, facilitating scalable analytics across departments.
- Implemented dynamic Row-Level Security (RLS) with Workday organizational hierarchy data, ensuring secure role-based access to analytics dashboards.
- Modeled Workday HR data to build organizational hierarchy datasets powering utilization and workforce analytics dashboards used for capacity planning and operational performance tracking.
- Designed and maintained Power BI and Tableau dashboards delivering real-time visibility into utilization, bookings, backlog, and revenue metrics across Sales and Professional Services teams.
- Migrated enterprise dashboards from Power BI to Tableau, redesigning data models and enhancing reporting performance for improved analytics access.
- Built a centralized SharePoint document ingestion system using Python and Microsoft Graph API, automating metadata extraction and ingestion into SQL databases.
Business Intelligence Analyst Intern
Veritas Technologies
Santa Clara, USA
06.2023 - 12.2023
- Developed Python-SQL data transformation workflows to prepare Salesforce Professional Services data for analytics and forecasting.
- Built forecasting dashboards that empowered Sales Engineering and Professional Services teams to effectively monitor pipeline and service performance.
- Migrated enterprise Power BI dashboards and SQL datasets, ensuring 99.9% accuracy in KPI validation to support data-driven decision making.
Education
Master of Science - Applied Business Analytics
Boston University
01.2024
Bachelor of Science - Business Administration
University of London
01.2021
Skills
- Business intelligence analysis
- SQL programming
- SQL querying
- Python programming
- ETL development
- ETL pipelines
- Data warehousing
- Data modeling
- Dimensional modeling
- Dashboard development
- Tableau and DAX
- Snowflake and Power BI
- BI tools expertise
- Data quality management
- Large dataset manipulation
- KPI frameworks
- Database management
- Workflow analysis
- Business process improvement
- Requirements gathering
- Custom reporting
- BI roadmap
- Data security
- Business analysis
- Data security
Personal Information
Relocation: Open to Relocation
Timeline
Business Intelligence Analyst 2
Cohesity Inc.
01.2024 - Current
Business Intelligence Analyst Intern
Veritas Technologies
06.2023 - 12.2023
Master of Science - Applied Business Analytics
Boston University
Bachelor of Science - Business Administration
University of London