Summary
Overview
Work History
Education
Skills
Affiliations
PROJECT 3
ROLES & RESPONSIBILITY:
PROJECT 2
ROLES & RESPONSIBILITY:
PROJECT 1
ROLES & RESPONSIBILITY:
Timeline
Generic

KEERTHIKA MATHI

Chennai

Summary

An extremely capable and self-assured IT specialist with 3 years of total experience and 2+ years of relevant experience in data analytics, including strategic planning, design, development and flawless execution of Microsoft Power BI solutions.

Overview

3
3
years of professional experience

Work History

Systems Integration Analyst

Athena Health
Chennai
12.2023 - Current

Process Associate

ADP India
Chennai
10.2021 - 12.2023

Education

MBA - Finance

Alagappa University
Chennai
04-2024

Master of Arts - Business Administration

University of Madaras
Chennai
12-2023

Skills

  • POWER BI DESKTOP
  • POWER QUERY EDITOR
  • POWER BI SERVICE
  • DAX CALCULATIONS
  • DATA MODELING
  • DATA VISUALIZATION
  • POWER BI REPORT SERVER
  • TABLEAU
  • SQL
  • ORACLE
  • ADVANCED EXCEL

Affiliations

  • Having 3+years of Experience in IT Industry with 2 years of Experience in Microsoft Power BI, Power BI Service and BI Reporting.
  • Experienced in using Different Modes and in getting data from different data Sources into Power BI.
  • Experienced in Handling Data Transformation Techniques using Power Query Editor.
  • Experienced in Creating and Implementing Data Modelling using Append, Merge and Relationships in Power BI.
  • Specialized in Creating Visualization using Different Charts and customs charts in Power BI Skilled in Creating Interactive Reports and Dashboards in Power BI Desktop and Service using Filters, Slicers and Synchronized Slicers.
  • Experienced in Creating Calculated Columns and New Measures using DAX Queries.
  • Skilled in Creating Interactive Reports and Dashboards using Different Techniques such as Drill Down and Drill Through and Hierarchy as well.
  • Experienced in Implementing Row Level Security and Object Level Securities both Static and Dynamic Using DAX in Power BI Desktop and Power BI Service as well.
  • Working on DAX functions like Date & Time, Information, Filter & Value, Logical, and Text. Experienced in Implementing Incremental and Full Refresh and Scheduling them in Power BI.
  • Experienced in Implementing Gateways and Knowledge in Workspace Roles in Power BI and Power BI Service.
  • Good in Writing DAX functions/Queries as well in Power BI.
  • Knowledge in Writing SQL Queries using Joins, Views etc. to get data into Power BI.

PROJECT 3

DOMAIN : Integration System analyst

 PROJECT TITLE : Patient Data Analysis

 CLIENT : Innovacare

 ENVIRONMENT : Power BI & SQL Server

 DESCRIPTION: 

InnovaCare Health provides high quality senior healthcare through our family of practices and providers across central and northern Florida

ROLES & RESPONSIBILITY:

  • Understanding knowledge of design principles and fundamentals of healthcare.
  • Imported data using import mode in Power-BI desktop.
  • Transformed data using various options in Power Query Editor like Choose column, Remove Column, Group by, merge queries and append queries, Etc.
  • Created calendar view calculated columns in Power pivot using DAX. Managed relationships in the tables and created data models in model view.
  • Created various interactive Reports and dashboards.
  • Implemented Row level security on data. Created Bookmarks and buttons in layouts.

PROJECT 2

DOMAIN : Process associate

PROJECT TITLE : E-service Demonstration Analysis

CLIENT : Technosoft Solutions

ENVIRONMENT : Power BI & SQL Server

DESCRIPTION:

Our specialty at Techno-soft Solutions is developing cutting-edge technology for the healthcare sector, guaranteeing smooth integration and top-notch patient care. Discover our expertise in developing advanced Healthcare Software Development services.

ROLES & RESPONSIBILITY:

  • Analysis of the specifications and requirements provided by the clients.
  • Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
  • Unit testing the packages.
  • Working with the control flow tasks such as Execute SQL Task, File System Task…etc. ➢ Creating stored procedures to use as the datasets for the Report Design.
  • Report parameters included single valued parameters, multi-value parameters.
  • Developing of Different Reports like Table, Matrix, Charts in different levels.
  • Good interpersonal communication, client interaction skills.

PROJECT 1

DOMAIN : Process associate

PROJECT TITLE : Data Analysis

CLIENT : TERADATA

ENVIRONMENT : Power BI & SQL Server

DESCRIPTION:

Teradata is one of the popular Relational Database Management System. It is mainly suitable for building large scale data warehousing applications.

ROLES & RESPONSIBILITY:

  • Improve application's performances.
  • Prepare documentations for database applications.
  • Memory management for database systems.
  • Develop database schemas, tables and dictionaries.
  • Fix any issues related to database performance and provide corrective measures.

Timeline

Systems Integration Analyst

Athena Health
12.2023 - Current

Process Associate

ADP India
10.2021 - 12.2023

MBA - Finance

Alagappa University

Master of Arts - Business Administration

University of Madaras
KEERTHIKA MATHI