Data Analyst Quality

SUMMARY

Nithish Goud Podeti

Data Analyst

USA +1-910-***-**** *************@*****.*** LinkedIn GitHub 5+ years’ experience as Data Analyst renowned for expertise in modernizing data mining techniques and ensuring data accuracy. Played a pivotal role in research, utilizing Python, SQL, Tableau, and ETL frameworks to develop insightful reports and visualizations. Excellence and proficiency in data analytics makes me an invaluable asset to any organization striving for data-driven success. EXPERIENCE

Data Analyst, Doublene, USA Sep 2023 – Present

• Modernized data mining and exploratory analysis, identifying patterns, trends, and correlations in large datasets, leading to a 25% increase in the understanding of behavioral health outcomes and program effectiveness.

• Collaborated with the Data Team to guarantee data accuracy, completeness, and consistency through data quality checks and resolution of data issues, achieving a 15% reduction in data errors.

• Contributed to data-driven research projects by collecting, organizing, and analyzing data, resulting in a 20% improvement in the evaluation of programs, interventions, and policies.

• Developed and documented ETL strategy to populate the Data Warehouse from various source systems, increasing data accessibility by 30%.

• Improved predictive accuracy by 40% through data collection, cleaning, wrangling, and machine learning model development in Python.

• Collaborated with the solutions team to create client reports using Big Query and SQL stowed Procedures, contributing to a 50% increase in successful client engagements.

• Implemented ETL processes using SSIS, SSRS, SSAS, and Informatica, reducing manual effort by 35% and improving efficiency. Data Analyst, Vaivu ResourceQ services Pvt Ltd, India Sep 2020 – Sep 2021

• Advance and implemented data quality checks that reduced errors in reports by 12%. Created customized reports connected to reporting servers using Power BI, enhancing decision-making efficiency by 20%.

• Orchestrated the cleaning and organization of data into Tableau & Tableau Prep through data mining processes and ETL, resulting in a 25% improvement in data accuracy.

• Designed a star schema using SQL Server to enhance data warehousing capabilities, increasing query performance by 30%.

• Reduced downtime by 15% by creating, modifying, and troubleshooting SQL queries, stored procedures, and jobs for seamless data management.

• Enhanced data analysis speed by 40% using Python libraries like Pandas, NumPy, Seaborn, SciPy, Matplotlib, and Scikit-learn for data preprocessing. Data Analyst, Techecy, India Oct 2019 – Aug 2020

• Establish various capacity planning reports utilizing Python packages such as NumPy, Matplotlib, Scikit-Learn, and SciPy, presenting data graphically and aiding in strategic planning and decision-making, resulting in a 15% increase in forecasting accuracy.

• Engaged extensively in data profiling, mapping, and cleansing, ensuring data quality and integrity, which facilitated a 20% improvement in analysis and reporting accuracy.

• Contributed to database management by writing, testing, and implementing triggers, deposited procedures, and functions using PL/SQL, optimizing data retrieval and storage processes, and reducing query time by 25%.

• Conducted exploratory data analysis on large and imbalanced datasets using Python, providing critical data insights and strategic directions, supporting data-driven decision-making and resulting in a 30% improvement in solution implementation.

• Spearheaded data visualization initiatives using Tableau to generate comprehensive reports, improving the clarity of complex data insights communicated to stakeholders by 40%.

PROJECTS

Restaurant Database Management system Boston, MA Database management system Sep 2022 – Dec 2022

Built a user interface to manage the restaurant application's database, and prepared a UML diagram in third normal form. Crafted the database design using SQL to enable the application to conduct CRUD operations.

Co-ordinated 15 warehoused procedures, Triggers, Functions, Views, SQL queries and used FLASK, HTML to build the application.

Collected 1000 students’ data and uploaded in to the Database for the project. Hotel management system Boston, MA Database management system Sep 2022 – Dec 2022

Constructed ER diagram, Relational schema using MySQL, workbench and executed over 15Views, Triggers.

Formulated a reservation cancellation system using Random Forest, Decision Tree and Gaussian Naive-Bayes with 85% accuracy.

Conducted EDA on over 50,000 rows for getting arrival month, Customer type, Market segments generating over 10.

insights and built Dashboards showing reservations of the customer on particular date using Tableau and PowerBI. TECHNICAL SKILLS

• Specializations: Data wrangling, Data visualization, Statistical Analysis

• Programming languages: SQL, PL/SQL, Python, R

• BI Tools: Tableau, PowerBI, Qlik, Looker

• Databases: MySQL, MS SQL Server, PostgreSQL

• Libraries: Pandas, NumPy, Matplotlib, Plotly, Seaborn, Scikit-learn, ggplot2

• Big Data: Hadoop, Spark, Apache Airflow

• Cloud Technologies: AWS (S3, Glue, EC2, Redshift, Athena)

• ETL: Data Profiling, Data Integration, Data modelling VTA1 S3

• Modelling Tools: Git, ER/Studio, Oracle Data Modeler, SSRS, SSIS

• Project Management: Microsoft Office Suite (Project, Visio, Excel, PowerPoint), Jira, Confluence

• Soft Skills: Team Workflows, Project Management, USI Best Practice, Fast-Paced, Work Skills, Integration Skills, Risk Management, Marketing Skills EDUCATION

Master of Science, Data Analytics Engineering Sep 2021 – Aug 2023 Northeastern University, Boston, MA

Bachelor of Science, Electrical and Electronics Engineering Sep 2016 – Aug 2020 Jawaharlal Nehru Technological University, Hyderabad, India

Contact this candidate