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
Cloud & Data-warehousing : Azure, AWS, Oracle, Snowflake, MySQL
Data Management & Analysis : SQL, SSRS, SSIS, AB initio, MS Excel, Unix
Data Visualization : Power BI, Tableau, Seaborn, Matplotlib
DS Skills : AI, Machine Learning, Deep Learning, Statistics, NLP
Project Management Skills : Azure, Jira, ServiceNow, GitHub,
Additional Skills : Handling large volumes of data, Problem-solving,
Stakeholder management, Attention to detail, Documentation,
familiarity with data issues and finding KPI's
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