Senior Data Analyst - SQL Developer with 7+ Years Experience

ARUN PRASAD V

***************@*****.*** +91-909*******

Bangalore-India

PROFESSIONAL SUMMARY

Data Analyst / SQL Developer with 7+ years of experience in SQL Server, Snowflake, and data analytics. Proven track record of optimizing queries, building scalable data pipelines, and delivering actionable insights through Power BI dashboards. Strong expertise in ETL processes, database administration, and performance tuning across large-scale datasets.

KEY SKILLS

Data Platforms: Snowflake, SQL Server, MySQL

Visualization: Power BI, Excel Dashboards

Languages: SQL, T-SQL, PL/SQL

ETL Tools: SSIS, DBT

Concepts: Data Modeling (Star & Snowflake Schema), Data Warehousing

Core Strengths: Query Optimization, Performance Tuning, Indexing, Data Analysis PROFESSIONAL EXPERIENCE

TCS – Data Analyst

Apr 2022 – Feb 2025

Project: Barclays (Banking Domain)

Monitored and managed 100+ daily batch jobs, ensuring 99.8% SLA compliance

Reduced incident resolution time by 30% through root cause analysis using Splunk logs

Handled 1M+ transaction records daily, identifying and resolving data inconsistencies

Improved onboarding issue resolution efficiency by 25% through proactive analysis Project: AIG (Insurance Domain)

Analyzed large datasets (5M+ records) to identify trends and improve reporting accuracy

Developed SQL queries and data validation checks, reducing data errors by 20%

Collaborated with business teams to deliver insights, improving decision-making speed Dalvkot – Database Administrator

Oct 2020 – Mar 2022

Project: HMS (Healthcare Management System)

Managed MySQL databases handling 500K+ records, ensuring high availability

Implemented backup and recovery strategies, reducing data loss risk by 40%

Optimized queries and indexing, improving database performance by 35%

Migrated data from SQL Server to MySQL with zero data loss Project: IMS (Inventory Management System)

Configured MySQL replication (Master-Slave), improving system reliability by 99% uptime

Reduced query execution time by 25% through performance tuning

Automated database monitoring tasks, reducing manual effort by 30% KAG India Pvt Ltd – Software Developer

Oct 2018 – Mar 2020

Project: OMS HR System

Developed stored procedures and views, reducing report generation time by 40%

Built optimized SQL queries, improving data extraction efficiency by 30%

Automated reporting workflows, saving 15+ hours/week Project: Stock Application

Designed and maintained indexes, improving query performance by 35%

Reduced report cycle time by 25% through automation and query tuning First Source Solutions Ltd – Senior Process Associate Oct 2015 – Oct 2017

Delivered 50+ ad-hoc reports/month with 100% SLA adherence

Created Excel dashboards, improving reporting efficiency by 20%

Performed SQL data import/export operations for business reporting POWER BI & SNOWFLAKE EXPERTISE

Developed interactive Power BI dashboards with real-time insights

Designed Snowflake data warehouse schemas (Star & Snowflake)

Built and optimized complex SQL queries, CTEs, and window functions

Implemented ETL pipelines using Snowflake and DBT

Managed Snowflake objects (tables, stages, streams, tasks) TECHNICAL EXPERTISE

Advanced SQL development (joins, subqueries, CTEs, window functions)

Performance tuning using indexing and execution plan analysis

Database backup, recovery, and maintenance

Data migration and ETL pipeline development

EDUCATION

MCA – Prince Shri Venkateswara Engineering College (2010–2013) BCA – NMSVN Arts & Science College (2007–2010)

TARGET ROLES (OPTIMIZED KEYWORDS)

Data Analyst

Data visualization, Power BI dashboards, data analysis, reporting, business insights SQL DBA

Database administration, backup & recovery, performance tuning, replication Snowflake Engineer

Snowflake architecture, data warehousing, ETL pipelines, DBT, cloud data platform DECLARATION

I hereby declare that the above information is true to the best of my knowledge. Arun Prasad V

Contact this candidate