Data Analyst Analytics

KEERTHI YALAMANCHILI

+1-812-***-**** ********************@*****.*** LinkedIn

Education

Masters in Data Science, GPA (3.5/4) Aug 2023 – May 2025 Indiana University Bloomington, Indiana, USA

Relevant Courses: Data Mining Advanced Database Concepts Statistics Applied Algorithms Data analytics for research Cloud Based Analytics AWS Data Visualization Advanced Database Technologies Visual Design Social Media Informatics Bachelors in Electronics and communication Engineering, GPA (3.64/4) June 2017 – July 2021 Anurag Group of Institutions, Hyderabad, India

Relevant Courses: C Programming Object Oriented Programing Cloud Computing and IOT Big Data Analytics Probability Theory and Stochastic Process Computer Networks Experience

SOCIETE GENERALE - Data Analyst Sept 2021 July 2023

• Enhanced onboarding client tools and API integrations, streamlining data collection and reporting processes.

• Creating Pop up error messages, made fields editable on different screens, made fields optional for categories mentioned in the story refinements by the product owner.

• Optimized complex SQL queries using indexing, partitioning, and execution plans, reducing query execution time by 40%. Developed stored procedures and triggers for automated financial data processing, ensuring GDPR compliance.

• Collaborated in agile sprints, optimizing API and batch automation workflows, improving system efficiency by 15%. SonarQube Vulnerabilities:

SQL injections, Log injections, LOG 4j issue fix, Violations

• Resolved long on-going bugs and actively contributed to Craft practices, achieving a 10% reduction in tech debt during sprints. Development of Airflow Spring Batch (E2E Onboarding report)

• Designed and implemented automated ETL pipelines using SQL and Airflow, reducing data processing time by 35%.

• Automated report automation in target folders within Spring Boot applications when Spring Batch runs through Airflow.

• Conducted data quality checks, resolving inconsistencies in data pipelines, and improved report accuracy by 15%. JAVA 8 migration for spring batch applications: From 1.8.0_25 to 1.8.0_192

• Performed root cause analysis on a dropdown compatibility issue in Spring Boot batch applications; identified the conflict with the Java home path, implemented a reroute to a compatible webpage, and resolved a major security vulnerability through targeted API and feature testing.

Skills

Database Management: SQL, MySQL, PostgreSQL, Microsoft Access, ETL pipelines, Query Optimization, Indexing Data Analysis: Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn, TensorFlow Programming Python, Data Structures and Algorithms, C++, Java, SQL, Web Scraping Data Visualization: Power BI, Tableau, Matplotlib, Looker, KPI Analysis, Dashboard Development, BI Reporting Big Data & Cloud: AWS (EC2, S3, RDS), Airflow

Tools and Platforms: Git, JIRA, Excel (Pivot Tables, VLOOKUP, Macros), Pgadmin, Intellij, Eclipse, REST API, Graphql, Springboot Certifications Cloud certification in AZ 900, MATLAB Machine Learning Onramp, SQL Associate certificate Projects

Enhancing Online Payment Fraud Detection: Nov 2023 Dec 2023

• Conducted extensive exploratory data analysis (EDA) to evaluate classification techniques such as KNN, Logistic Regression, Decision Tree, and boosting algorithms, optimizing model accuracy to classify fraudulent payments and enhance internet payment security. Real Estate Explorer: The Analysis of Real Estate Listings on Zillow Via Web Scraping: Jan 2024 Feb 2024

• Leveraged web scraping and API integration to efficiently clean, process and analyze the KPIs, and visualize real estate data from Zillow. Built interactive Power BI dashboards, visualizing real estate pricing trends, increasing stakeholder decisions. Data Analyst Research (Intern) – Indiana University: June 2024 July 2024

• I assisted a professor in a paid internship research program, Collected and processed IPO prospectus data (2016–2018) using Python, APIs, and web scraping. Cleaned and structured data for analysis to support a predictive model on post-IPO layoffs. AWS Capstone: Secure and Scalable Web Infrastructure: Sept 2024 Nov 2024

• Designed highly available AWS architecture leveraging RDS, EC2, IAM, and Secrets Manager. Implemented bastion host and NAT Gateway for secure access to private networks. And configured Application Load Balancer (ALB) for traffic control and optimized security settings.

• Built multi-tier AWS architecture with EC2, RDS, Auto Scaling, and ELB for improved reliability. And Integrated AWS Pricing Calculator for cost analysis and resource optimization.

Contact this candidate