Summary
Overview
Work History
Education
Skills
Timeline
BusinessDevelopmentManager
Prasanth Arasavilli

Prasanth Arasavilli

Data Analyst
Preston,UK

Summary

Experienced and detailed-focused Data Analyst with 6 years of experience in data lifecycle and tools associated with it. Proficient in Data Science, Data warehousing, Azure services, Data Visualization, and ETL methodologies. Applied ML algorithms and statistical analysis using Python and R for improved decision making. Bringing in the ability to identify valuable insights, problem-solving, and adapting to latest technologies

Overview

7
7
years of professional experience
5
5
years of post-secondary education

Work History

Data Analyst

NCO Europe LTD
UK
03.2024 - 10.2024
  • Utilized Python, SQL and data science methodologies for exploratory data analysis
  • Automated business deliverables using Power BI and Power Automate techniques
  • Led a team to apply Machine Learning, statistical analysis and automation techniques which reduced implementation duration by 50%
  • Developed stored procedures using advance SQL to automate data extraction, necessary aggregations and modelling.
  • Created a dashboard that visually represented key business metrics KPI's and published to Power Bi service, allowing for quick and informed decision-making by management

Data Analyst

Barclays LTD
UK
01.2023 - 09.2023
  • Explored a range of Azure services including Azure Data Factory, Azure SQL Database, Azure Blob Storage, and Azure Synapse Analytics to build and manage data pipelines and storage solutions
  • Applied statistical methods to resolve data discrepancies and improved data quality significantly and reduced data issues by 70%
  • Collaborated with business users and translated user-driven stories into meaningful and interactive reports using DAX, measures, etc. with increased client satisfaction
  • Created data models and documented data flows to improve system architecture and data quality

Technology Analyst

Infosys LTD
Banglore
01.2021 - 10.2021
  • For the depreciation process of inactive clients using Python, SQL, identified data containing Personal Identification Information (PII) and presented the PII report to SMEs to clear 10 million records
  • Developed Python scripts for data extraction from Snowflake, Hadoop Mongo DB, SharePoint, MySQL, etc., and scheduled Unix scripts to set up required updates/alerts.
  • Managed and trained a team to use Python, Power BI to validate the data and perform quality checks

Senior Project Engineer

Wipro LTD
Delhi
06.2017 - 12.2020
  • Configure ETL applications & develop data pipelines between DWH and ETL
  • Designed Ab initio continuous graphs and plans to load data continuously and fix any data issues immediately on the go
  • Created a parameter set that can be reused in different circles
  • Built SQL queries, views, stored procedures, and Python scripts required for the reconciliation of the data received and automated reconciliation process for data Received vs Loaded that reduced human effort
  • Worked with complex and large datasets and fixed multiple data issues and re-loaded rejected records into databases like Oracle, MySQL, Teradata, and Hadoop file system using SQL

Education

Masters - Data Science

University of Essex
Colchester, ESSEX
10.2021 - 10.2022

Bachelors - Electronics & Communication

GVP SOE
Visakhapatnam, India
06.2012 - 05.2016

Skills

Programming languages : Python, R, Java, Pyspark

Timeline

Data Analyst

NCO Europe LTD
03.2024 - 10.2024

Data Analyst

Barclays LTD
01.2023 - 09.2023

Masters - Data Science

University of Essex
10.2021 - 10.2022

Technology Analyst

Infosys LTD
01.2021 - 10.2021

Senior Project Engineer

Wipro LTD
06.2017 - 12.2020

Bachelors - Electronics & Communication

GVP SOE
06.2012 - 05.2016
Prasanth ArasavilliData Analyst