Charan V

Business Data Analyst @Zimmer Biomet

US

Collaborated with cross-functional teams to gather and document business requirements (BRD, FRD, SRS) and translated them into analytical solutions aligned with strategic goals. • Developed and optimized complex SQL queries and stored procedures to extract, transform, and validate data from large relational databases (MS SQL Server, MySQL), ensuring 99.9% accuracy in reporting. • Designed and implemented ETL pipelines using tools like Azure Data Factory and SSIS, reducing manual data processing time by 40% and enabling scalable data integration. • Conducted A/B testing, trend analysis, and impact assessments to support business cases, resulting in data-driven recommendations that improved process efficiency and customer engagement. • Partnered with QA and development teams to define and execute UAT test plans, validate data logic, and ensure successful deployment of analytics tools and system enhancements. • Performed data cleaning, validation, and modeling activities to enhance data quality, streamline reporting workflows, and support accurate forecasting and budget planning. • Delivered clear and concise insights to stakeholders using SWOT, GAP, and cost-benefit analyses, influencing leadership decisions in operations, sales strategy, and customer experience initiatives. • Streamlined reporting processes by creating automated Excel-based dashboards with advanced macros and Power Query, reducing manual reporting effort by over 50% across multiple departments. • Collaborated with product, marketing, and finance teams to perform KPI tracking and ad hoc analysis, enabling leadership to make data-backed decisions that led to a 10% improvement in operational efficiency.