Summary
Overview
Work history
Education
Skills
Relevant Project Experience
Certification
Highlights
Quote
Timeline
Generic
ARTHI PAVADAI

ARTHI PAVADAI

Coventry

Summary

Adaptable Data Analyst with more than 9 years of IT experience in Banking domain providing first-class results. Proficient in creating compelling, interactive dashboards using Power BI, enhancing data accessibility and understanding. Strong command over Excel, Power BI, enabling data manipulation and analysis. Looking forward to leverage my skills and experience to guide business decisions.

Overview

9
9
years of professional experience
2
2
Certification

Work history

IT analyst

Tata Consultancy Services
Bangalore, India
04.2019 - 07.2022
  • Analyzed project specifications and developed data-driven technology solutions that consistently met or exceeded performance expectations
  • Conducted Quality checks by thorough testing to identify and resolve bugs, ensuring optimal software performance
  • Mentored junior developers, fostering professional growth and enhancing team productivity
  • Created and maintained comprehensive data analysis documentation, facilitating effective knowledge sharing and collaboration among team members

Senior Software Engineer

Tata Consultancy Services
07.2017 - 03.2018
  • Analyzed fault data to identify common issues and provided actionable insights to design and development teams, resulting in a 20% reduction in issue resolution time
  • Monitored and analyzed bug report data, ensuring a 95% resolution rate within 48 hours, which upheld high software quality standards and minimized project timeline disruptions
  • Conducted data analysis on testing results and coordinated with the quality assurance team, leading to a 25% reduction in post-release defects and ensuring the delivery of robust software

Software Developer

Tata Consultancy Services
10.2013 - 02.2017
  • Performed detailed analysis of Mainframe zOS job performance data to identify optimization opportunities, resulting in a 20% reduction in batch job processing time and enhanced system efficiency
  • Generated adhoc reports for business requests, maintaining a 98% accuracy rate in data validation to provide stakeholders with high-quality insights for informed decision-making.
  • Analyzed and streamlined reporting processes, resulting in a 30% reduction in report generation time and increased efficiency in the overall reporting workflow

Education

Bachelor of Technology - Electronics and Communication Engineering (First Class with Distinction)

Pondicherry Engineering College
Puducherry

Skills

  • SQL (SQL Server, MySQL)
  • Microsoft Power BI
  • Excel (Lookup, Conditional Formatting, Pivot Tables)
  • Python (Pandas, NumPy)
  • Microsoft Azure
  • NET framework
  • C#, C, C
  • Mainframe (COBOL, JCL, DB2)

Relevant Project Experience

Sales Data Analysis EDA | SQL  May 2024 

● Utilized SQL to analyze order details of Pizza sales and gain insights on what it takes to improve the sales 

● Used Subqueries and Join techniques for detailed data analysis 

● Provided insights on Customer Preference, Sales Trends and Operational Efficiency and did Market research to identify the  industry trend in sales.  

HR Data Analysis | Power BI   April 2024 

● Created a dashboard with Power Bi to help HR, understand the current trend of employee working days and absence insights 

● Transformed and processed client’s data by using DAX and Excel to ensure data completeness and validity 

● Provided technical insights on how the HR can fully utilize their data to know about working pattern and employee wellness 

● Visualized the data to get more benefits on capacity planning, team building activities and Infrastructure management 

Online Retail Store Analysis | Excel  Mar 2024 

● Utilized Excel Pivot tables to represent aggregated measures and built pivot charts for data visualization 

● Performed data cleaning and text analysis to successfully identified the major sales location and products  

● Provided Annual sales report and insights with strategic solution to increase customer satisfaction and sales for the upcoming  year 

TATA Data Visualisation: Empowering business with  the effective Insights Feb 2024 

● Utilized Power BI to visualize the data to identify key business intelligences that can improve sales performance 

● Transformed and filtered data by using Power Query Editor to improve data quality and completeness 

● Loaded and visualized data with various charts to identify major key metrics that can help in business decisions 

Career Break 2023- 2024 

● Childcare and Relocation 

● Upskilled in Data Analysis and Visualization tools through courses and certification 

● Utilized Excel, SQL, Python and Power BI for Data Cleaning, Analysis, Modelling and Visualization for personalized projects with  real time data

Certification

  • Microsoft Azure Fundamentals (AZ-900)
  • Microsoft Power BI Data Analyst (PL-300)

Highlights

  • Completed 4 months of on-site work in the Netherlands, gaining valuable customer relationship management experience
  • Recognized as a Contextual Master by TATA Consultancy Services for deep knowledge in Banking Mainframe software architecture and implementing the process improvements
  • Led a team of 10+ members as Chapter Lead, overseeing their technical skills match with project requirements and update on technology advancement.
  • Served as Scrum Master for two teams in a short-term capacity, facilitating agile processes and team collaboration

Quote

Believe in yourself

Timeline

IT analyst

Tata Consultancy Services
04.2019 - 07.2022

Senior Software Engineer

Tata Consultancy Services
07.2017 - 03.2018

Software Developer

Tata Consultancy Services
10.2013 - 02.2017

Bachelor of Technology - Electronics and Communication Engineering (First Class with Distinction)

Pondicherry Engineering College
ARTHI PAVADAI