Summary
Overview
Work History
Education
Skills
Languages
Certification
Hobbies and interests
Timeline
Generic

Swetha Aanikyala

Bangalore

Summary

Data Analyst with proven experience in transforming raw data into actionable insights using SQL, Python (Pandas, NumPy), and Excel. Skilled in data cleaning, analysis, and visualization to support business decision-making. Strong foundation in financial reporting and analytical thinking, enabling accurate data interpretation and problem-solving. Passionate about leveraging data to drive efficiency and business growth.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Data Analyst

Award Infotech
Udupi
12.2024 - Current

Assisted in managing data lifecycle processes from collection to cleaning.
Collected and cleaned raw data through SQL, Python, and Excel.
Ensured accuracy and consistency of datasets during analysis.

Assisted in automating reporting tasks to enhance efficiency.
Created dashboards that presented insights to stakeholders.
Supported data validation and trend identification efforts.

  • Utilised SQL, Python (Pandas, NumPy), and Excel to clean and transform raw data, ensuring accuracy and usability.
  • Optimised SQL queries to extract, join, and analyse large datasets from multiple sources.
  • Conducted data analysis and validation to identify trends, anomalies, and business insights.
  • Execute automated data processing and reporting tasks using Python scripts, eliminating manual effort and enhancing efficiency.
  • Built interactive dashboards and reports to enhance data-driven decision-making.
  • Conducted data cleaning and preprocessing using pandas to enhance data integrity and facilitate structured analysis.
  • Collaborated with stakeholders to define business requirements and deliver analytical solutions.
  • Generated weekly and monthly reports to enhance strategic decision-making and operational efficiency.
  • Facilitated resolution of customer inquiries to enhance service delivery.

Accountant, Financial Reporting

Mahalakshmi Souharda credit cooperative limited
Bangalore
10.2018 - 11.2024
  • Prepared and maintained financial statements, ensuring accuracy and compliance with accounting standards.
  • Facilitated monthly, quarterly, and annual financial closing processes to ensure accuracy and compliance.
  • Analysed financial data to uncover trends, variances, and discrepancies.
  • Ensured accuracy of financial records through meticulous account reconciliation and resolution of discrepancies.
  • Facilitated audit activities by compiling comprehensive financial documentation and detailed reports.
  • Ensured compliance with accounting standards and policies through collaboration with cross-functional teams.
  • Managed journal entries, ledger updates, and financial reporting within accounting systems.

Education

Bachelor of Science - Bsc IT

KSOU
Bengaluru, KA
01-2012

Intermediate - Bi PC

S. G. M. COLLEGE
Nellore, AP
01-2005

Secondary School / High School -

NARAYANA HIGH SCHOOL
Nellore, AP
01-2003

Skills

  • Data analysis & Exploration
  • Data Visualization (Power BI / Tableau / Excel)
  • Data Cleaning & Preprocessing
  • SQL optimization
  • SQL (Joins, Aggregations, Query Optimization)
  • Python (Pandas, NumPy)
  • Excel (Pivot Tables, VLOOKUP, Advanced Formulas)
  • Data Validation & Quality Checks
  • Dashboard Creation & Reporting
  • ETL (Extract, Transform, Load) Basics
  • Logical thinking
  • Business Insights & Reporting
  • Problem solving

Languages

English
Proficient
C2
Kannada
Proficient
C2
Telugu
Proficient
C2
Hindi
Upper Intermediate
B2

Certification

Data Analyst Program – JobAaj Learnings

  • SQL (Zero to Hero)
  • Python (Core + Data Analysis with Pandas & NumPy)
  • Power BI (Beginner to Advanced)
  • Tableau (Beginner to Advanced)
  • Excel (Complete Mastery)
  • Dashboarding (Looker Studio)

Hobbies and interests

  • Exploring datasets, solving analytical problems, learning new data tools, and creating dashboards

Timeline

Data Analyst

Award Infotech
12.2024 - Current

Accountant, Financial Reporting

Mahalakshmi Souharda credit cooperative limited
10.2018 - 11.2024

Bachelor of Science - Bsc IT

KSOU

Intermediate - Bi PC

S. G. M. COLLEGE

Secondary School / High School -

NARAYANA HIGH SCHOOL
Swetha Aanikyala