Jayashree Yandra

Experience

• 

  NTT DATA

  Jul 2019 - Aug 2022

  •Ingested data from PostgreSQL, data warehouses, and REST APIs ensuring 100 % data consistency and availability for analysis.•Addressed client's unique data challenges, and implemented indexing and SQL query optimization strategies.•Prepared detailed BI reports to provide insights enabling stakeholders to track trends and improve order fulfillment by 16%. •Analyzed time series data to predict sales trends, which led to 14% lower inventory costs, achieving 3X better order management & optimized warehouse management by incorporating features like seasonality, promotional events & holidays.

  • Information Technology Senior Associate

    Jun 2020 - Aug 2022

  • Information Technology Associate

    Jul 2019 - Jun 2020
• 

  Juiy Mobility Technologies Private Limited

  May 2023 - Jul 2023

  Data Science Intern

  •Optimized data preprocessing workflows for financial data from loan applications using Python and SQL reducing processing time by 20%. Improved data quality by 15% by handling missing values, outliers, and inconsistencies elevating analysis.•Automated data pipelines leveraging Python to streamline the ETL of data from PostgreSQL & AWS.•Engineered comprehensive analytics dashboards, utilizing Tableau to visualize key metrics and performance indicators facilitating expedited evaluation of new customer applications, providing insights into creditworthiness, loan terms, and risk factors by focusing on relevant metrics such as geospatial profile, LTV, repayment schedules, and credit scores. Show less

• 

  University at Buffalo

  Feb 2024 - now

  Data Analyst - Graduate Research Assistant

  • Built web scraping and data analysis pipeline to collect news articles from over 1500 media outlets focusing on socio-political events. Utilized Python, advanced SQL, APIs, and SEO backlinks for preprocessing.•Developed a sophisticated data schema model to aggregate article data by linking relevant articles with incident details and created interactive Tableau dashboards to visualize the impact of media influence on peer-to-peer private lending behaviors.•Applied machine learning algorithms using TensorFlow and scikit-learn to improve textual data analysis by 22%. Show less