Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

LATHEESH RAVI

Halifax,NS

Summary

  • 6 Plus years of overall experience in Business Intelligence and Data Analytics tools.
  • Hands on experience in Snowflake, Apache Airflow, SQL Server, SSIS, SSAS, SSRS, PowerBI, SAP BOXI 3.1 (Administration, Universe Designer and Web-Intelligence), Adaptive Planning (Corporate Performance Management) and designing Data modelling & Data Warehousing.
  • Extensive working experience in the requirement gathering, analysis, design, implementation, enhancement and testing in Business Intelligence applications.
  • Provided support to customer application systems that met their needs.
  • Identified solutions to their business problems and resolved their issues.
  • Self-motivated and capable of performing multitask, while maintaining a desire and in concert with the company’s vision and focus.
  • Designed and modeled complex warehouse applications.
  • Expertise in Data migration/conversion projects using SQL & ETL tool.
  • Extensive working experience in Healthcare, Retail & Real estate domains.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Senior Software Engineer

RESMED HALIFAX ULC, MatrixCare
07.2023 - Current
  • Involved in a proof of concept project to migrate data from on-prem SQL server to Snowflake.
  • Created streams, tasks & roles in Snowflake.
  • Used Apache Airflow to orchestrate the workflow and created DAG's using Python code.

Software Engineer

RESMED HALIFAX ULC, MatrixCare
08.2022 - 06.2023
  • Involved in creating end-to-end business intelligence solution for skilled nursing facility.
  • Involved in the development of MyData and MyAnalytics proprietary tools
  • Responsible for data modeling, ETL development (using SSIS) and SSAS tabular model creation.
  • Responsible for creating complex BI metrics using DAX query language for AR, census and clinical data from skilled nursing facility.
  • Created multiple data visualizations, reports and dashboards using Power BI desktop and published to the PBI service.
  • Created PBI gateway connection to access the on-premises servers and scheduled data refresh.
  • Implemented Row Level Security (RLS) in the SSAS tabular to restrict data at different levels of the organization.

Software Engineer

MATRIXCARE INDIA PRIVATE LTD
01.2017 - 07.2022
  • Involved in creating end-to-end business intelligence solution for skilled nursing facility.
  • Involved in the development of MyData and MyAnalytics proprietary tools
    Responsible for data modeling, ETL development (using SSIS) and SSAS tabular model creation.
  • Responsible for creating complex BI metrics using DAX query language for AR, census and clinical data from skilled nursing facility.
  • Created multiple data visualizations, reports and dashboards using Power BI desktop and published to the PBI service.
  • Created PBI gateway connection to access the on-premises servers and scheduled data refresh.
  • Implemented Row Level Security (RLS) in the SSAS tabular to restrict data at different levels of the organization.

Education

Bachelor of Science - Computer Science

Pallavan College of Engineering (Anna University)
Chennai, India
04.2010

Skills

  • BI Tools : Apache Airflow, Power BI, SSIS, SSAS, SSRS, Mobile Report Publisher
  • Database : Snowflake, Microsoft Azure, SQL Server 2008/2012/2016 and Oracle11g
  • Query Language : Snow-SQL, T-SQL, MDX & DAX
  • Programming: Python
  • Others : Budgeting & Planning tool – Adaptive Planning

Certification

Microsoft Certified Azure Data Engineer Associate [Feb’2022]

Microsoft Certified Azure Data Fundamentals [Jan’2022]

Timeline

Senior Software Engineer

RESMED HALIFAX ULC, MatrixCare
07.2023 - Current

Software Engineer

RESMED HALIFAX ULC, MatrixCare
08.2022 - 06.2023

Software Engineer

MATRIXCARE INDIA PRIVATE LTD
01.2017 - 07.2022

Bachelor of Science - Computer Science

Pallavan College of Engineering (Anna University)
LATHEESH RAVI