Jagadeesh Chitturi
Data Analyst
812-***-**** *******************@*****.*** LinkedIn Github
Professional Summary
• Over 5 Years of IT Experience in Data Analysis, Data Mining, Big Data, Cloud Platforms (AWS, GCP, Azure).
• Advanced Data Engineering Solutions: Implemented Big Data Engineering, Data Warehousing, Data Marts, and ETL processes. Experienced in handling and analyzing multi-dimensional data for insights and patterns.
• Programming & Scripting Proficiency: Skilled in Python development for data manipulation, data cleaning, data transformation, and automation of tasks using Python scripting, as well as developing real-time data pipelines.
• Machine Learning & Data Visualization: Experienced in developing machine learning models using Python libraries with proficiency in data visualization tools like Power BI, plotly, and Seaborn for generating key performing indicators(KPIs).
• Database Design & Optimization: Strong expertise in relational database design, schema design for data warehousing (star, snowflake schemas), and implementing data cleansing, normalization, and performance tuning techniques. Technical Skills
Programming: Python, C++, R, Java.
Databases: SQL, MYSQL, PostgreSQL, MongoDB, Hadoop, SSIS, Data Modeling, Databricks. Data Analysis: Pandas, SAS, NumPy, NLTK, Statistical Analysis, Data Cleaning, ANOVA (Analysis of Variance), EDA, Data Reporting, Mathematical Skills, Adhoc Reporting, KPI. Machine Learning: Pytorch, scikit-learn, Linear Regression, Logistic Regression, SVM, K-nearest neighbors, Naive Bayes, Random Forest, Gradient Boosting, Time Series, NLP. Data Visualization/BI: Power BI, Matplotlib, Plotly, Panel, Seaborn, Tableau, Google Looker Studio, DAX. Others: Git, MS Excel, RPA using Blue Prism, Jira, ServiceNow, SAP, AWS, ETL, Azure. Professional Experience
Data Analyst January 2023 - Present
School of Public Health, Indiana University Bloomington Bloomington, IN Next Generation Statistical Model Forecast and Analysis C++, Python, Pandas, Matplotlib, Statistics
• Collaborated as a critical data analyst in advancing epidemic analytics and predictive modeling of viral infectious diseases for the Epistorm project, a $2.7 million CDC-funded initiative.
• Developed a statistical Agent-Based model in C++ to simulate mosquito population dynamics throughout the year with 92% accuracy. It is a reliable predictor for testing the impact of genetically modified agents on population dynamics.
• Implemented a multi-index data frame in python for efficient data exploration to Analyze 200,000 experiment results.
• Leveraged data visualization techniques (heatmaps, time-series plots) using matplotlib, plotly libraries to analyze large datasets (75 million records) and key data patterns and seasonal trends.
• Coordinated with a cross-functional team in project management, ensuring attention to detail, timely project milestones were met, and effectively communicated complex statistical findings to non-technical stakeholders. Data Analyst Intern May 2023 - August 2023
Centre for Epidemiology Public Health (CEPH) Bloomington, IN Data Analytics and Visualization Python, Power BI, Pandas, NumPy
• Orchestrated creating and deploying an interactive data dashboard tailored for an epidemiology research team.
• empowered ten researchers with enhanced data visualization capabilities, saving an estimated 6 hours weekly. Facilitating improved communication and collaboration among team members
• Conducted comprehensive exploratory data analysis on time-series data spanning over five years, creating interactive data visualizations to communicate results; identified patterns that led to a 20% improvement in forecast accuracy. Data Analyst June 2019 – June 2022
Accenture Hyderabad, Telangana, India
• Streamlined data from various applications and sources, performed data cleaning and transformation by converting data and creating new measures for compatibility to create reports using Excel and advanced data manipulation methods.
• Designed Power BI dashboards to visualize KPI metrics and track performance based on ticket-resolving efficiency.
• Spearheaded the execution of an automated ETL data pipeline for streamlining data extraction, transformation, and loading for 45 interfaces in various SAP modules like AP, AR, MM, and BI. Resulted in a 5-hour daily reduction in manual workload.
• Developed an automated ticket-assigning bot that routes over 500 tickets/incidents per day created by the client. It routes to appropriate resolving groups and persons, powered by Machine Learning, and enhances resolution efficiency by 30%.
• Efficient in time management by prioritizing multiple projects, ensuring problem-solving and successful data solutions. Projects
Human Time Use and Mosquito Pattern Analysis Python, Pandas, NumPy, matplotlib, seaborn April 2024
• Leveraged Bureau of Labor Statistics data to identify time-use patterns across demographics (gender, race-ethnicity, income) and work conditions. Utilized data manipulation and analysis techniques to segment user populations.
• Combined spatiotemporal mosquito activity data with human time-use patterns to identify risk factors for mosquito bites. Employed data integration and geospatial analysis skills to assess human-mosquito interaction vulnerability. New York Taxi Hire Data Analysis Python, Pandas, SQL, Maze, Big Query, Power BI July 2023
• Enabled ETL pipeline to extract data from NYC Taxi and Limousine Commission (TLC) with passenger trip information to transform the data into fact and dimension tables for data modeling and load it into BigQuery for data warehousing.
• Built interactive dashboards in Power BI using DirectQuery to connect to BigQuery, enhancing report performance.
• Analyzed over 100,000 rides data to understand transportation demand, pricing strategies, and tourist hotspots. Education
Indiana University Bloomington August 2022 – May 2024 Master of Science in Data Science Bloomington, IN
GITAM University, GITAM Institute of Technology June 2015 – April 2019 Bachelor of Technology in Computer Science Visakhapatnam, AP, India Certification and Awards
• Microsoft Power BI Data Analyst – Professional Certification from Microsoft June 2024
• AWS Certified Developer - Associate from Amazon Web Services.
• Received the ‘Performer of the Month’ award twice at Accenture for developing a data dashboard.