Bhanu Sinha

Data Management Consultant

Republic Services

Sep 2024 - Current (1 year 10 months)

Analyzed query usage patterns for OTC self-service project using SQL in Snowflake to identify user behavior and reporting gaps. Led data migration and ingestion of 10+ InfoPro tables from on-prem systems to Snowflake, ensuring accurate data transfer. Reduced data standardization time by 90% by automating manual processes using Microsoft Copilot and Python. Built Streamlit applications on Snowflake for corporate and field users to support self-service analytics and data governance. Developed dbt models and custom views on InfoPro and OFC tables to serve as data sources for Streamlit applications. Established code documentation and ownership standards for production deployments, improving maintainability and team knowledge sharing. Collaborat

S

Senior Business Analyst

Safe Streets

Apr 2024 - Aug 2024 (5 months)

Standardized KPI definitions and ensured data consistency across departments through a centralized data dictionary initiative. Led migration readiness for Snowflake by conducting stakeholder interviews for process mapping and defining KPIs. Developed executive Tableau dashboards used for company-wide equipment sales and campaign performance reviews. Analyzed campaign performance metrics, uncovering an 8% decrease in gross margin despite an increase in gross revenue. Enabled removal of inefficient campaigns by presenting key findings to senior leadership, driving $100,000 in savings.

T

Business Analyst Co-Op

Tucson Water

May 2023 - Dec 2023 (8 months)

Achieved a 10% increase in customer satisfaction scores by analyzing customer feedback and survey data using Excel and R. Performed data validation, anomaly detection, and preprocessing using Python and Excel, reducing data preparation time by 90%. Created enterprise data flow diagrams in Visio with 15 cross-functional teams to identify and resolve data inconsistencies. Reduced the scheduled project timeline by 18% and streamlined workflows by identifying duplicate efforts in Azure DevOps. Delivered Power BI reports on employee learning preferences to senior executives to support LMS platform decisions.

Senior Analyst

KPMG

Jan 2019 - Jul 2022 (3 years 7 months)

Led a SOC-1 engagement for a global bank spanning 12 regions and 191 applications, communicating high-risk findings to stakeholders. Recommended 5 access management KPIs by analyzing application log data in Power BI, strengthening data security monitoring. Improved QA testing efficiency by using customized SQL queries for focused log analysis and Excel-based full-population testing, eliminating sample bias and reducing overall testing time by 15%. Built end-to-end data flow diagrams, mapping how data moved across claims platforms, IAM tools, and BI reporting layers, improving transparency and audit readiness. Created project status reports using Excel and Power BI, enhancing project tracking and insight generation across 4 global teams. Col

About

Detail

Timeline

Résumé