BHALCHANDRA TEMBHURNE

• Collaborated with cross-functional teams to identify data requirements and solutions.
• Implemented data governance practices to ensure data quality and compliance.
• Optimized existing data workflows, across MS BI and AWS - Airflow to enhance performance and reliability.
• Optimized existing database structures to improve scalability, efficiency, and performance.

• Spearheaded design of data framework using SQL Server to enhance dataset access speed.
• Engineered ETL architecture with Microsoft BI Suite, significantly reducing execution time and development costs.
• Migrated legacy reporting systems to Power BI, improving accessibility and business intelligence.
• Led multiple infrastructure migration and upgrade projects, ensuring performance quality with zero downtime.
• Developed sustainable design models with SSAS Tabular to integrate diverse data aspects.
• Collaborated with stakeholders to streamline data requirements and enhance delivery processes.
• Mentored junior engineers, fostering skill development and knowledge sharing within team.
• Implemented engineering strategies that improved production efficiency.

• Developed data warehousing solutions in agile environment using full DW suite, enhancing report generation time by 85%.
• Led creation and deployment of ETL workflows with SSIS, improving data transfer rates by 90% through CDC and SQL partitioning.
• Crafted dimensional and relational model designs in SSAS, achieving 80% faster turnaround from legacy reports.
• Pioneered interactive tool for reconciling claims, identifying $2 million in discrepancies annually, boosting financial accuracy.
• Engineered CLR functions within stored procedures to automate file system tasks, reducing manual errors and improving turnaround times by 40%.

• Simplified the existing ETL architecture and elevated the performance of the process by 70%.
• Developed a multi-dimensional cube tailored to business requirements, streamlining data modeling for Datamarts and reducing reliance on custom MDX by over 50%, enhancing user experience with the self-reporting system.
• Augmented data-quality by identifying the existing data issues, that were in the system over 4 years, which also included trouble shooting performance issues at the server level and provided the resolution for the issues.
• Orchestrated data acquisition from 10+ governmental agencies and private entities, uncovering critical insights that provided deeper understanding of client needs and service offerings; findings led to targeted improvements in reporting efficiency.

• Collaborated with cross-functional teams to identify inefficiencies in bi operations, resolving major user experience issues during peak periods.
• Architected multidimensional analysis service cube and tabular cubes, deprecating over 70 SSRS subscriptions and 20 reports.
• Executed a sliding window technique using SQL partitioning, enhancing ETL operations while managing fact table growth over 9 billion records.
• Implemented an innovative partitioning strategy to process more than 10 million records per load cycle, ensuring stable performance across varying data volumes.

Details Available on LinkedIn:

www.linkedin.com/in/bhalchandra-tembhurne