Data Analyst Information Technology

Aayush Shirish Desai

+1-469-***-**** *************@*****.*** LinkedIn Portfolio GitHub Anaheim, California Education

The University of Texas at Dallas - Richardson, Texas Master of Science, Information Technology and Management Mumbai University - Mumbai, India

Bachelor of Engineering, Information Technology

Work Experience

ACE Software LLC, Data Analyst Remote, United States June 2023 - May 2024

• Increased operational efficiency by 30% through development and maintenance of 20+ interactive Tableau dashboards for tracking critical business KPIs.

• Reduced data processing time by 70% by automating data collection and cleaning processes using Python scripts and pandas.

• Improved query performance by 40% through SQL optimization, enabling faster data retrieval for analytics tasks.

• Reduced data anomalies by 85% through the implementation of robust data quality and validation procedures.

• Processed 100+ GB of weekly raw data using Alteryx and Python ETL pipelines, delivering actionable insights to stakeholders.

• Drove 5 major strategic initiatives through cross-functional collaboration and data-driven recommendations. Ackerman Center for Holocaust Studies at UT Dallas, Data Analyst Richardson, Texas August 2022 - May 2023

• Improved data collection efficiency by 20% by developing Python scripts for automated extraction from historical archives.

• Enhanced research outcomes by creating interactive Power BI visualizations, leading to 2 new research directions.

• Managed data quality for 50+ large datasets through comprehensive cleaning and validation processes.

• Increased data utilization by 25% through collaboration with 5 research teams on metric definition and documentation. Shree Insurance Solutions, Data Analyst Intern Mumbai, India May 2021 - July 2022

• Developed SQL queries and API-based methods to extract and analyze data, improving claims processing efficiency by 5%.

• Created monthly reports and dashboards using Tableau and SAS, visualizing key performance indicators (KPIs) for underwriting and pricing teams, leading to a 7% increase in policy renewals.

• Identified 1,000+ at-risk policyholders using machine learning to develop predictive models for customer churn prediction.

• Reduced claim payouts by 7% through ad-hoc analysis of 50,000+ policyholder records, supporting risk assessment strategies. GlobalShala Education Pvt. Ltd., Data Analyst Intern Remote, India January 2021 - April 2021

• Conducted exploratory data analysis (EDA) of 11 Ad Campaigns using Python and SQL to visualize data and identify trends.

• Identified Campaign 3 is the least cost-effective with CPC 38 INR, CPR 32 INR, and 383.5 INR revenue, reaching 1,062 people. Skills

• Languages: Python, SQL, SAS, R.

• Librabires: Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn, SciPy, Statsmodels, Plotly, Pyspark, BeautifulSoup, Requests.

• Tools: Tableau, Microsoft Power BI, Microsoft Excel, MS Office, Microsoft SQL Server, Alteryx, AWS, Azure Synapse Analytics.

• Other: Data Collection, Data Preprocessing, Data Modeling, Data Validation, Data Analytics, Data Visualization, Database Management, Data Warehousing, Data Pipeline, ETL (Extract, Transform Load), Machine learning, Predictive Analytics.

• Personal Skills: Good Communication and Teamwork, Strong analytical, critical thinking, and problem-solving. Certifications

• Google Advanced Data Analytics: Google

• Google Advanced Data Analytics: Microsoft

• Oracle SQL Databases: LearnQuest

• Microsoft Azure Data Engineering Associate: Microsoft

• Google Business Intelligence: Google

• Microsoft Azure Data Scientist Associate: Microsoft Personal Projects

Performance Report Dashboard, Microsoft Power BI

• Developed complex data transformations and calculated measures using Power Query and DAX functions within Power BI.

• Identified sales increase of 15% using year-to-date (YTD) vs. prior-year-to-date (PYTD) Key Performance Indicator (KPI). London Bike-Sharing Data Analysis and Visualization, Tableau

• Developed a Tableau dashboard using Python for data extraction via Kaggle API and cleaned 17,414 rows of dataset.

• Analyzed 3.2M bike rides, discovering 20% more use on holidays, with up to 25k rides per day in summer and 5k in winter.

Contact this candidate