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