N

Nihaal Yanamandra

About

Detail

Data Analyst
Dallas, Texas, United States
Contact Nihaal regarding: 
work
Full-time jobs
Starting at USD7k/month

Timeline

work
Job

Résumé

Jobs verified_user 0% verified
  • AmerisourceBergen
    Data Analyst Intern
    AmerisourceBergen
    Jun 2022 - Aug 2022 (3 months)
    Created dashboards to generate weekly sales reports to communicate business insights to stakeholders using PowerBI Developed and automated numerous stored procedures for the monthly sales database which increased efficiency by 40% Created mapping documents for weekly sales which streamlined the processes to access the documents by 20% Groomed 15+ stories for the IT Data and Analytics team on Azure DevOps to ensure smoother weekly stand-ups Managed data feeds on the SSMS platform using MySQL for Optus Account an Australian based telecom company Improved database efficiency by up to 10% through automating of 5+ stored procedures using MySQL Streamlined the ETL automation process for millions of rows and columns, resulting in time savings of 5
  • Infosys Ltd
    Data Analyst
    Infosys Ltd
    Jan 2021 - Aug 2021 (8 months)
  • C
    Marketing Data Analyst
    Captiwit
    Jan 2020 - Dec 2020 (1 year)
    Conducted statistical analysis to identify market trends which helped in acquiring new clients using Excel and Tableau Created effective marketing campaigns using Google Analytics, Ads, and SEOs, achieving a 10% revenue increase for clients Identified key business critical parameters which helped improve lead generation by 15%, acquiring 12+ clients Facilitated core Agile ceremonies in a team environment, including Sprint Planning, Daily Standup, Sprint Review, and Sprint Retrospectives, ensuring comprehensive reporting on 100% of the tasks and activities assigned to the Scrum Team
Education verified_user 0% verified
  • Cognitive SAS
    Google Business Intelligence Professional Certificate, SQL and Relational database 101
    Cognitive SAS
  • The University of Texas at Dallas
    Master of Science
    The University of Texas at Dallas
  • Coursera
    Google Data Analytics Professional
    Coursera
  • Microsoft
    Microsoft Azure Al Associate
    Microsoft
  • University of Mumbai
    Bachelor of Engineering
    University of Mumbai
  • G
    Google Business Intelligence Professional Certificate, Google Data Analytics [IMAGE] Professional
Projects (professional or personal) verified_user 0% verified
  • E
    End to End SQL Scripting for Indian Railways database
    Created an end-to-end database from scratch, integrating raw data into Visual Studio Code based MySQL database Developed an ER diagram for Indian Railways Database with 30,000 trains in the Central Zone of Indian Railway Conducted thorough data cleaning in Excel, eliminating 575 duplicates, 350 null values, and filtering outliers Designed a streamlined MySQL database based on the ER diagram, reducing redundancy by 20% Significantly improved data accessibility by achieving up to 200% faster retrieval through the created database
  • C
    Cargo Aviation Analysis of Airlines using Tableau and Excel
    . Analyzed global airport cargo data for performance insights and industry trends, supporting strategic decision-making . Utilized Excel's advanced capabilities, including pivot tables, for precise cargo operations parameter refinement and analysis . Evaluated the strategic significance of these routes, providing actionable insights for optimizing routes and business strategy
  • D
    Data Visualization of Indian Startups using Python
    . Accomplished in impactful presentations, fostering team collaboration for Python based data visualizations • Presented start-up distribution visuals: 48% commercial services, 1.5% healthcare, during COVID-19 peak (Jan 21-May 21) Applied Python libraries including Matplotlib, Seaborn, NumPy, and Sci-kit to execute the visualizations Produced diverse visualizations including Pie, Line, Box, Scatter, and Histogram to showcase project results with impact
  • P
    Pricing Analysis of Airlines using Tableau
    • Developed a comprehensive dashboard utilizing a dataset of 539,383 flights to analyze and identify the pricing in USA. • Employed aggregate functions and measurements to identify the pricing parameters across various destinations. • Utilized filters and calculated fields to identify the most and least expensive flight days and regions across the USA. • Presented the pricing analysis using pie charts, box plots, histograms, scatter plots, and line charts.
  • C
    Cargo Aviation Analysis using Tableau
    • Analyzed global airport cargo data for performance insights and industry trends, supporting strategic decision-making. • Focused on key metrics including Average Revenue per Flight, Average Yield, Load Rate, and Revenue per Load. • Utilized Excel's advanced capabilities, including pivot tables, for cargo operations parameter refinement and analysis. • Accurately identified the Top 3 routes by evaluating key performance metrics and strategic significance.
  • F
    Forecasting and Revenue Analysis for Ecommerce website using
    • Built interactive PowerBI sales dashboard showcasing $1.5M annual revenue based on large-scale analysis in Excel. • Forecasted 21% increase in annual mobile revenue through 2025 via years historical website data. • Evaluated top contributing Regions, analysis of purchase frequency, Sales Method, Product Type through Pivot Tables.