LAKSHMI PRASANNA DANDU
Wilmington
Summary
Results-driven Data Analyst/SQL Developer with extensive experience in SQL optimization, data warehousing, ETL, and business intelligence. Adept at designing efficient database solutions, automating processes, and leveraging analytical tools to drive data-driven decision-making. Expertise in SQL, Python, Power BI, and cloud databases, ensuring data integrity and operational efficiency.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Data Analyst/SQL Developer
ITC Infotech
05.2023 - 05.2024
- Developed custom stored procedures, reducing data processing time by 40%
- Created data validation scripts, minimizing production data errors by 95%
- Implemented database security measures, ensuring compliance with industry standards
- Analyzed customer purchasing patterns using Python & SQL, improving retention by 15%
- Built Power BI dashboards to visualize sales trends and identify revenue opportunities
- Conducted statistical analysis using Python to define KPIs and provide insights to stakeholders
SQL Developer
TCS
01.2012 - 01.2017
- Optimized slow-running queries by 75% using indexing, partitioning, and query refactoring
- Developed ETL pipelines using SSIS/Python to integrate data from multiple sources
- Designed data warehouse solutions to improve business intelligence reporting
- Automated database maintenance tasks, reducing manual efforts by 30%
- Built Power BI reporting solutions in collaboration with analysts and engineers
- Led data migration (ETL) projects from legacy systems to Teamcenter using SQL
- Reduced SQL query execution time, significantly improving processing efficiency
Education
B.Tech - Electronics & Communication
Shri Vishnu Engineering College for Women
01.2011
12th -
Sri Chaitanya Junior College
01.2007
10th -
Jnanananda Public School
01.2005
Skills
✅ SQL Query Optimization & Performance Tuning
✅Stored Procedures, Functions, Triggers
✅ Database Design & Normalization
✅ ETL & Data Migration (Informatica)
✅ Data Warehousing (Snowflake, Redshift, BigQuery)
✅ Reporting & BI Tools (Power BI)
✅ Cloud Databases (Azure SQL, AWS RDS, GCP BigQuery)
✅ Scripting (Python, PL/SQL)
✅ Predictive analytics
✅Web scraping
✅ Agile & Version Control (Git, JIRA)
✅Sentiment analysis
✅Google analytics
✅Machine learning
✅Data modeling
Certification
- Completed Accenture North America Data Analytics and Visualization Job Simulation focused on advising a hypothetical client using advanced data cleaning, modeling, and storytelling techniques.
- SQL Competency Certificate
- Data Analysis with Python Developer Certification - freeCodeCamp
- Certificate in Data Analytics & Machine Learning with Python - ONLEI Technologies
Timeline
Data Analyst/SQL Developer
ITC Infotech
05.2023 - 05.2024
SQL Developer
TCS
01.2012 - 01.2017
12th -
Sri Chaitanya Junior College
10th -
Jnanananda Public School
B.Tech - Electronics & Communication
Shri Vishnu Engineering College for Women
Similar Profiles
Rajasekaran RamarajRajasekaran Ramaraj
Lead Consultant at ITC Infotech India LtdLead Consultant at ITC Infotech India Ltd
Ashwanth RamAshwanth Ram
Test Automation Engineer at ITC infotechTest Automation Engineer at ITC infotech
PUBALAN ANANTHANPUBALAN ANANTHAN
Service Desk Lead at ITC InfotechService Desk Lead at ITC Infotech