BI and Reporting Analyst

Proficient Report Writer and data Analyst

Contributed to generating valuable insights that guided informed business decisions.

Instrumental in improving Occupancy% - a key performance metric – by extracting and transforming resourceful web data into reports that facilitated competitive analysis and performance improvement.

Created ETL processes to integrate data for daily, monthly, and ad-hoc reporting.

Senior Care Centers LTC /Abri Healthcare

BI and Reporting Analyst July 2013 to July 2024

Authored numerous Stored Procedures, views and functions for SSIS, SSRS and ad-hoc reporting.

Extensively used SQL queries to validate and tie out financial reports.

Created and maintained SSIS packages for ETL processes.

Designed Power BI reports and dashboards for business leaders to visualize, analyze and improve key performance metrics versus competitors

Blended cross-functional data from finance, operations, accounting and payroll to create a Model and developed Power BI reports that helped analyze actual cost overrun, overspending, staffing enhancements etc.

Well versed with Sage Intacct and Management Reporter financial reporting.

Eyecare Services Partners

MS BI consultant Jan 2019 to March 2019

Led and facilitated technical discussions with multiple vendors.

Developed SQL queries and data models for financial and operational data using SSIS.

Managed data warehouse support and maintenance.

Developed SSRS reports to analyze 8x8 call data using SSRS reports.

Environment: SQL Server 2016

T-System Jan 2012 to June 2013

Associate Developer

Supported HR, Finance, and Template Services with software solutions for care facilities.

Upgraded and secured the “TOrders” Intranet application from VS 2003 to VS 2010.

Created and improved SSRS reports.

Developed SQL stored procedures, views, and functions for SSRS and Crystal Reports.

Implemented Windows and Web services on IIS.

Development Tools: VS 2010, SQL Server 2008. Reporting tool: Crystal Reports 2008 v 12.1, SSRS 2000(VS2003)

Education

Bachelor of Engineering and Computer Science, Bangalore, INDIA

Contact this candidate