Summary
Overview
Work History
Education
Skills
Languages
Projects
Languages
Timeline
Generic

MURALI AVVARI

Bangalore

Summary

Dynamic and organized Data Analyst with four years of experience utilizing a variety of programs to generate data-driven insights and improve organizational processes. Expert in creating and optimizing databases, forecasting trends & patterns, as well as designing capability-driven data visualizations. Led projects to increase revenue growth and customer satisfaction by 25% & achieved error-detection accuracy of 95% across all data sources.

Overview

4
4
years of professional experience

Work History

Data Analyst I

MIAC Analytical Services Pvt Ltd
Bengaluru
01.2023 - 10.2023
  • Developed comprehensive test plans and strategies for VeriFi, outlining testing objectives and methodologies.
  • Employed techniques to optimize Excel performance, including disabling automatic calculations, reducing cell formatting, and minimizing formula usage.
  • Implemented data slicers and advanced filtering in Excel to extract relevant subsets of data, enhancing data exploration.
  • Supported client inquiries and provided assistance in understanding data reports.
  • Collaborate with clients and cross-functional teams to define reporting requirements and provide continuous support to address their data needs.

Data Analyst III & II

MIAC Analytical Services Pvt Ltd
Bengaluru
01.2023 - 01.2023
  • Implement data visualization tools like SSRS to present findings and insights, facilitating data-driven decision-making.
  • Performed some reports and created visualizations using Tableau and Power BI to create visually compelling and interactive data visualizations that facilitate data-driven decision-making.
  • Successfully imported large data sets into Excel, handling data from diverse sources, such as databases, CSV files, or web services.
  • Employed techniques to optimize Excel performance, including disabling automatic calculations, reducing cell formatting, and minimizing formula usage.
  • Implemented query optimization techniques to improve database performance, reducing query executions & formula usage.
  • Supported client inquiries and provided assistance in understanding data reports.
  • Proficient in conducting rigorous testing using VeriFi software to ensure compliance with quality and security standards.

Jr Data Analyst

MIAC Analytical Services Pvt Ltd
Bangalore
08.2019 - 01.2021
  • Strong expertise in database management, including creating, modifying, and optimizing database structures.
  • Maintained comprehensive documentation of SQL queries, data processes, and report generation procedures.
  • Strong knowledge in using Tableau and Power BI to create visually compelling and interactive data visualizations that facilitate data-driven decision-making.
  • Proficient in conducting rigorous testing using VeriFi software to ensure compliance with quality and security standards.
  • Supported client inquiries and provided assistance in understanding data reports.

Education

Bachelor of Technology - Electronics and communication Engineering

Vellore Institute of Technology (VIT University)
Vellore, TN, India
11.2018

Skills

  • SQL
  • Excel
  • Power Bi
  • Python
  • SSRS
  • Tableau
  • Client support
  • Testing

Languages

  • English
  • Kannada
  • Telugu
  • Tamil
  • Hindi

Projects

executionss

VeriFi:

 VeriFi is a comprehensive due diligence software for the banking and lending industries, designed to control all aspects of the due diligence process. This application module consists of four different applicatiVeriFIlled VeriFI, VeriFi Admin, VeriFi Management VeriFi Sync. The Company is mainly focused on Mortgage and Finance sector. This application helps to perform the due diligence process between Banks and Investors in USA and some parts of UK. Successfully integrated SQL Server Reporting Services (SSRS) with the VeriFi application to provide a seamless and efficient reporting solution. Designed and developed custom reports tailored to the specific needs of VeriFi users, enhancing the application's functionality. Integrated VeriFi with various data sources, allowing real-time data retrieval and report generation directly within the application.

 Merged and integrated data from various sources like SQL, Excel, Oracle to create a unified dataset for analysis. Performed various testing procedures to enhance the performance of the application. Provided client support to understand the process of entire VeriFi Module applications and reports. Involved in development throughout the application and interacting with Development team to enhance the application performance and to resolve the Bugs. Automated VeriFi testing processes, reducing testing time by 40% and minimizing the margin for human error.

Languages

Telugu
First Language
English
Proficient (C2)
C2
Hindi
Upper Intermediate (B2)
B2

Timeline

Data Analyst I

MIAC Analytical Services Pvt Ltd
01.2023 - 10.2023

Data Analyst III & II

MIAC Analytical Services Pvt Ltd
01.2023 - 01.2023

Jr Data Analyst

MIAC Analytical Services Pvt Ltd
08.2019 - 01.2021

Bachelor of Technology - Electronics and communication Engineering

Vellore Institute of Technology (VIT University)
MURALI AVVARI