Gadhamsetti Krishna Chaitanya

Detail-oriented Data Analyst with 3+ years of experience analyzing large datasets, optimizing SQL queries, and building data visualization dashboards. Experienced in transforming business requirements into data-driven insights, and collaborating with cross-functional teams. Skilled in Python, SQL, PySpark, AWS Glue, and Snowflake for building scalable data pipelines and analytics solutions. Strong focus on data quality, performance optimization, and delivering actionable insights to support strategic decision-making.

• Python for Data Science, IBM, Mastered Python programming fundamentals, including data structures, functions, and libraries. Gained proficiency in data analysis using libraries like Pandas, NumPy, and Matplotlib. Developed skills in data visualization, creating clear and informative charts and graphs. Applied Python to real-world data science problems, including data cleaning, analysis, and interpretation.
• Google Analytics Individual Qualification, Google, Gained expertise in Google Analytics, including setting up tracking, data collection, and analysis. Mastered the use of key metrics, reports, and dashboards to monitor website performance. Developed skills in segmenting audiences, tracking user behavior, and identifying trends. Learned to create and interpret custom reports to optimize digital marketing strategies. Enhanced ability to measure ROI and make data-driven decisions for improving online presence.
• Advanced SQL Certified, HackerRank, Demonstrated expertise in complex SQL queries, database management, and data manipulation through HackerRank's Advanced SQL Certification. Proficient in writing optimized queries for data analysis, reporting, and problem-solving. Experienced in using advanced functions, joins, sub-queries, window functions, and performance tuning to handle large datasets efficiently.
• Power BI Virtual Case Experience Participant, PwC Switzerland, Engaged in PwC Switzerland's Power BI Virtual Case Experience, a self-paced program designed to enhance proficiency in data visualization and analytics using Microsoft Power BI. Developed interactive dashboards and reports, transforming complex datasets into actionable insights. Gained hands-on experience in defining Key Performance Indicators (KPIs), calculating measures, and presenting data-driven recommendations.

• House Price Prediction Using Python and ML, Developed a machine learning model to predict house prices based on various features., Conducted data preprocessing, feature engineering, and exploratory data analysis., Trained and optimized models like Linear Regression and Random Forest., Achieved accurate predictions using Python, Scikit-learn, and Pandas., 03/01/22, 05/31/22
• Data Extraction and Text Analysis using Python, Pandas, and NLP, Developed a system for extracting, cleaning, and analyzing textual data from various sources using Python., Utilized Pandas for data manipulation and NLP libraries (NLTK, Scikit-learn) for sentiment analysis, keyword extraction, and topic modeling., Created visualizations to present insights and stored results in a structured format., 12/01/22, 02/28/23
• Business KPI Tracker, Developed a SQL-based reporting system to track 15+ core KPIs for Sales, HR, and Finance., Created an interactive Power BI dashboard connected to MySQL, enabling real-time access to data for 20+ stakeholders., Integrated anomaly detection scripts in Python, reducing undetected metric discrepancies by 30%., 04/01/23, 08/31/23
• Sales Data QA Dashboard, Built a Power BI dashboard to monitor data quality, highlighting top 5 recurring data issues in sales transactions., Designed SQL scripts to detect duplicates, null values, and outliers in 1.2M+ rows, cutting reporting errors by 25%., Delivered automated QA reports to sales and QA teams, improving error resolution speed by 40%., 10/01/23, 12/31/23
• Marketing Campaign Optimization (Simulation), Analyzed campaign performance using SQL joins and aggregations on 500K+ customer records., Identified high-performing segments that increased simulated campaign ROI by 18%., Created a Power BI dashboard comparing A/B test results, enabling faster decision-making for campaign rollout., 02/01/24, 05/31/24
• HR Analytics Using SQL and Power BI, Queried MySQL database to extract employee performance data for 500+ employees across departments., Built interactive visualizations to track attrition trends, reducing IIR reporting preparation time by 50%., Defined and implemented 5 new HR KPIs with input from HR managers, aligning reporting with business needs., 01/01/25, 05/31/25