JaiKiran Reddy Mekala
Hyderabad
Summary
Data Analyst with two years of experience leveraging Python for data manipulation and analysis, and SQL (including MySQL) for database querying. Proven ability to visualize data effectively using Tableau, and a solid understanding of cloud platforms (AWS, Snowflake, Redshift, Amazon S3) for data storage and processing. Experienced in applying NoSQL principles, conducting A/B testing, and utilizing critical thinking to derive actionable business insights.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Junior Data Analyst
realsoft technologies LLC
Virginia
03.2024 - 04.2025
- Integrated user behavior (Python/Pandas) and marketing (SQL/Oracle) data to reveal a 5% higher long-term user retention rate from specific acquisition channels, informing customer lifecycle management.
- Developed three Tableau dashboards (SQL) visualizing critical KPIs, leading to a 15% reduction in system downtimeand a 10% improvement in application response time within one month for Operations & Development.
- Automated daily sales data ingestion using Python scripts on AWS Lambda, improving data availability by 3 hours daily (now 9 AM) and reducing manual errors for faster Sales & Marketing insights.
Data Analyst Intern
Codinza
Kerala
01.2022 - 01.2023
- Python automation streamlined data cleaning, cutting the team's time by 50%, and minimizing errors.
- Highlighted a 25% onboarding drop-off via SQL/Python analysis, informing proposed user flow improvements.
- SQL-driven data audit cleaned datasets (1,000+ duplicates removed, 8% less missing data), and enhanced accuracy via business rule validation, improving reporting.
Education
Master of Science - Information System & Technology - Data Analytics/Engineering
University of North Texas
Denton, TX USA04.2025
Bachelor of Science - Computer Science Engineering
Amrita Vishwa Vidyapeetham
Kollam, India05.2022
Skills
- C
- Python
- SQL
- NoSQL
- MYSQL
- Tableau
- AWS
- Snowflake
- Redshift
- A/B testing
- Amazon S3
- Critical thinking
Projects
E-Commerce Customer Experience Enhancement,
- Enhanced online shopping experience using GCP (GCS, BigQuery) for scalable data and efficient analysis.
- Integrated advanced algorithms for faster product recommendations.
- Developed and deployed personalized recommendation models using GCP Machine Learning Engine, increasing conversion rate by 5%.
Healthcare Analytics: Diabetes Detection
- Leveraged Pandas and NumPy for data manipulation, and applied statistical techniques (hypothesis testing, correlation) to identify key diabetes risk factors and patterns in healthcare data
- Enhanced the accuracy of diabetes risk prediction by implementing advanced machine learning algorithms, including a highly effective classification model like Random Forest, enabling early intervention and improved patient outcomes
Certification
AWS Certified Developer – Associate
Timeline
Junior Data Analyst
realsoft technologies LLC
03.2024 - 04.2025
Data Analyst Intern
Codinza
01.2022 - 01.2023
Master of Science - Information System & Technology - Data Analytics/Engineering
University of North Texas
Bachelor of Science - Computer Science Engineering
Amrita Vishwa Vidyapeetham
Similar Profiles
Wesam BakarWesam Bakar
Flutter Developer at RealSoft Advanced ApplicationFlutter Developer at RealSoft Advanced Application
Jhoner Esteban SilvaJhoner Esteban Silva
Software Developer at Maravir Technologies LLC D.b.a. Vates TechnologiesSoftware Developer at Maravir Technologies LLC D.b.a. Vates Technologies
Sydney McCannSydney McCann
Sales Intern at Marco Technologies LLCSales Intern at Marco Technologies LLC
Abhiram BarikAbhiram Barik
Architect at ZscalerArchitect at Zscaler
Sridhar BikkinaSridhar Bikkina
Senior Analyst -Dynatrace Administrator at StateStreet (HCL-Lead Engineer)Senior Analyst -Dynatrace Administrator at StateStreet (HCL-Lead Engineer)