Summary
Overview
Work History
Education
Skills
Project Experience
Certification
Declaration
Timeline
Generic

Sunethra T R

Bengaluru

Summary

  • Data Analytics professional with over 9 years of total IT experience including 5+ years of experience working with visualization tools Power BI, DAX, and SQL.
  • Experience gathering and translating end user requirements into effective & efficient Reports and Dashboards.
  • Experience including analysis, design, development of reports and dashboards for analytics.
  • Develop Power BI reports, Custom Visuals, Groups Creation and effective dashboards after gathering and translating end user requirements.
  • Imported data from multiple data sources into BI Tools, created relationships between data, created calculated columns and measures using DAX.
  • Experience in creating different visualizations like Line, Bar, Histograms, Scatter Plot, Waterfall Chart, Bullet Graph, Heat maps, tree maps etc.
  • Experience in publishing reports to Power's services and setting up the necessary connection details and scheduling.
  • Imported data from multiple data sources into Power BI from various data bases like SQL Server, Oracle & Excel etc.
  • Implemented Role Based Security as part of security in Power Bi.
  • Expertise in designing Report templates, bar charts, graphs and pie charts based on the data.
  • Developed various operational Drill-through and Drill-down reports using BI.
  • Good hands on experience in creating SQL Server database objects like Tables, Constrains, Joins, Sub-Queries, CTE, Stored Procedures, User Defined Functions, Views, Indexes.
  • Skilled at assessing client needs, working in groups, Leading the team, suggesting ideas that enhance efficiency and performance, implementing technology solutions and training end users.
  • Having experience in creating new measures for YTD, MTD, QTD, and YOY growth analysis in power bi desktop.
  • Experience in working with Azure services such as – Azure Storage, Azure Lake Storage, Azure SQL Database, and Azure Data Factory.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Senior Associate System Management

Kyndryl
Bengaluru
09.2021 - Current

Associate System Management

IBM India Pvt Ltd
Bengaluru
09.2018 - 08.2021

Analyst

AXA Business Service Pvt Ltd
Bengaluru
08.2015 - 09.2017

Education

Bachelor of Business Management -

KLE Society’s S Nijalingappa College
Bengaluru
05.2015

Skills

  • Power BI
  • MySQL
  • Azure SQL Database
  • Fabric Lakehouse
  • Fabric Warehouse
  • Semantic Models
  • Power Apps
  • Power Automate
  • Azure Data Factory
  • Power BI Dataflow

Project Experience

Project #1

Client                       : First American | US Title Insurance 

Technology/Tools   : Power BI Desktop.

Duration                  : Nov 2021 to till date

Description

First American (India) is a Global Capability Center (GCC) of the First American Financial Corporation (US), a leading provider of title insurance, settlement services, and risk solutions for real estate transactions since 1889 First American also provides title plant management, home warranty, and banking, trust & wealth management services. With locations in Bangalore, Hyderabad and Salem, FAI delivers software development, back-office and knowledge-processing operations to support First American’s global operations in US, UK, Australia & Canada.
Responsibilities:

  • Data gathering
  • Gathering data from a structured database where actual transactions take place.
  • Survey and feedback information collected from sales and marketing team
  • Data Modelling.
  • Data Cleaning in power query editor
  • Complete responsibility on Database designing
  • Maintained complete structured database (MYSQL)
  • Applied Custom conditional formatting with help of Color by Rules in Power BI for Matrix & Table.
  • Developed Power BI reports from multiple data source
  • Created Bookmarks to move from one page to another page based on requirements like moving forward and backward navigations.
  • Implemented DAX (Data Analysis Expressions) functions for Calculated columns and measures.
  • Experience in developing Visualization reports and dashboards using Power BI.
  • Involved in developing weekly reports.
  • Published weekly reports to Business users.
  • Designed power BI data visualization utilizing maps, scatter charts.
  • End to end process to deliver the project
  • Published Power BI Reports
  • Worked on On-Premises Gateway to refresh the data source.

Project#2 

Revenue Analysis dashboards

Client                     : First American

Technology/Tools: Power BI Desktop, MYSQL Database and Azure

Description:
  Demonstrated an understanding of data analysis and visualization techniques to create an intuitive and effective revenue analysis dashboard, resulting in improved financial performance and data-driven decision-making.

Responsibilities:

  • Created Bookmarks/Page Navigations as per the requirement.
  • Creating workspace as per the business requirement and creating gateways and scheduling daily refresh.
  • Providing access for workspace and app level to the admin and dev team to load the files in different instances.
  • Implemented KPI’s in Power BI dashboards.
  • Gained knowledge on Power Apps integration & Power Automate.
  • Implemented DAX functions for Calculated columns and measures.
  • Designed power BI data visualization utilizing, maps, scatterplots.
  • End to end process to deliver the project.
  • Optimize the performance of these reports in terms of time to refresh and size of the reports.
  • Migrated on premises data to Azure Storage/Azure Lake Storage.

Certification

  • AWS Solutions Architect - Associate (AWS SAA), https://www.credly.com/badges/eac5fb7c-efc1-4e70-a3fc-48eec83bae09/public_url
  • AWS Certified Cloud Practitioner, https://www.credly.com/badges/2a1dfb3b-c9b7-476c-93fa-2aaa496b8b08/public_url
  • Microsoft Certified Azure Fundamentals, https://www.credly.com/badges/13cff630-c1ad-4957-813f-9dab85776038/public_url
  • IBM Certified Database Associate, https://www.credly.com/badges/9184cff7-0c98-46c6-b0e0-686c2f609569/public_url
  • Machine Learning with Python -Level 1, https://www.credly.com/badges/cfa3a2ab-b5b1-4d07-aff6-c45281382965/public_url

Declaration

I hereby declare that the above-mentioned information is correct and I bear the responsibility of the correctness of the above mentioned.

Timeline

Senior Associate System Management

Kyndryl
09.2021 - Current

Associate System Management

IBM India Pvt Ltd
09.2018 - 08.2021

Analyst

AXA Business Service Pvt Ltd
08.2015 - 09.2017

Bachelor of Business Management -

KLE Society’s S Nijalingappa College
Sunethra T R