Summary
Overview
Work History
Education
Skills
Certification
Onsite Exerience
Timeline
Generic

Jayapriya Elangovan

Chennai

Summary

Experienced Power BI Developer with a strong background in data retrieval and transformation from various sources including MS SQL and Azure SQL. Demonstrated proficiency in creating interactive dashboards and visualizations, employing DAX for advanced analytics and time intelligence functions. Successfully implemented row-level security and scheduled refreshes in Power BI service to enhance data accessibility and monitoring of KPIs. Expertise in utilizing Power Query Editor for data modeling and creating custom visuals to meet specific reporting needs.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Power BI Developer

TCS Software Services
11.2022 - Current

Systems Engineer

Construction Progress Report for Serco Construction Company
11.2022 - Current
  • Company Overview: Serco Construction company is a construction company which constructs Industries, Bridges, Buildings with all other modern techniques of construction.
  • Retrieved data from different sources like MS SQL, AZURE SQL, Excel etc.
  • Worked on various data transformations using Power Query Editor.
  • Worked on Snowflake Schema data modelling.
  • Created Measures using Aggregate Functions like Sum, Avg, Count & calculate etc.
  • Created expressions using DAX to perform Time Intelligence analysis using Date add, Same period last year Function etc.
  • Created various interactive dashboards and visualizations, using both inbuilt visuals and also custom visuals like Infographic chart, Bullet chart etc.
  • Created dynamic visuals using DAX functions.
  • Created bookmark and selections.
  • Created schedule refresh in Power BI service.
  • Created alerts in dashboards for monitoring KPIs.
  • Create the Row Level Security in Power BI.
  • Serco Construction company is a construction company which constructs Industries, Bridges, Buildings with all other modern techniques of construction.

Analyst Programmer

Ramco Systems
Chennai
02.2019 - 11.2022

02.2019 - 11.2022
  • Revenue Management System (RMS) managing more than 1 million customers with 9 lakh customers has been billed every month in Durban developed using SQL and PLSQL.
  • Experience in Client-Server application development using Oracle 19c, sql developer, Mysql, SQL
  • Plus and SQL
  • Loader.
  • Effectively made use of Table functions, indexes, table partitioning, collections, cursors and Materialized views.
  • Developing web-based applications using DB2 Server integration using Java.
  • Developed complex database objects like stored procedures, functions, packages, and triggers using SQL and PLSQL.
  • Loaded Data into Oracle Tables using SQL Loader and Unix commands.
  • Worked with various teams to deliver user-friendly products.
  • Ability to solve complex problems, strong analytical skills, and the ability to trace issues to the root source.

Education

Bachelor of Computer Science -

Anna University
04-2017

Skills

  • Power BI
  • Power BI Service
  • DAX studio
  • Data flows
  • Power BI Report Builder
  • MSSQL Server
  • DB2
  • PLSQL

Certification

  • DB2 11.1 Fundamentals for LUW - IBM Certified Database Associate
  • Java SE 8 Programmer - Oracle Certified Associate

Onsite Exerience

Project    :  eThekwini Municipality   Duration  : JUN 2019 - AUG 2019 & JAN 2020 - FEB 2020   • Location  :  Durban, South Africa

Timeline

Power BI Developer

TCS Software Services
11.2022 - Current

Systems Engineer

Construction Progress Report for Serco Construction Company
11.2022 - Current

Analyst Programmer

Ramco Systems
02.2019 - 11.2022

02.2019 - 11.2022

Bachelor of Computer Science -

Anna University

Similar Profiles

CREATE PROFILE
Jayapriya Elangovan