Data Analyst Analysis

PRATIK AIRY

+1-234-***-**** ****.********@*****.*** LinkedIn Houston, TX.

SUMMARY

Dynamic and results-oriented data analyst with extensive experience in interpreting and leveraging data for actionable business insights. Eager to contribute analytical expertise, advanced problem-solving skills, and a client-focused approach; as an Analyst. SKILLS

Programming/ Technical Skills – Excel, SQL, R, Python (Pandas, NumPy, Matplotlib, Scikit-learn), Machine learning Data Analysis / Visualization – Data cleaning, EDA, Data Modeling, Forecasting & Predictive Analytics, Power BI, Tableau Tools & Database management – MS Office Suite, Git, Docker, Jira, MongoDB, Snowflake, ETL – (Talend) Customer Service – Relationship building, problem-solving, and verbal/written communication, Data Storytelling WORK EXPERIENCE

Research Experience – Internship Feb 2025 – Present KENT STATE UNIVERSITY

• Researching and developing platform to analyse 5+ CAPTCHA test systems to evaluate fairness, testing 2+ prototypes for inclusive verification methods.

• Working on to building database and 2 interactive dashboards for performance visualization, and collaborate with a research team on inclusive security technology development

Operation Assistant – Part-time Nov 2023 – Dec 2024 RECERATIONAL CENTER – Kent State University

• Coordinated daily facility operations for over 500+ patrons weekly, ensuring 100% compliance with safety regulations.

• Enhanced patron experience by implementing feedback-driven improvements, resulting in a 15% increase in overall satisfaction ratings based on survey results.

Reports Analysis – Project Jul 2024 – Nov 2024

• Analysed 2 years of historical incident data to develop predictive models, achieving 90% accuracy in forecasting staffing needs for incident response.

• Developed predictive stocking models that reduced out-of-stock incidents by 15% and minimized excess inventory by 10%. Data Analyst – Full-time Aug 2022 – Jul 2023

SKY TEX GLOBAL MACHINEIRES - Bangalore, KA.

• Conducted exploratory data analysis (EDA) on 500,000+ records to uncover key operational trends, improving process efficiency by 12%.

• Designed and optimized SQL queries to streamline data retrieval, reducing query execution time by 30%.

• Developed 10+ interactive dashboards in Power BI to visualize performance metrics, enabling leadership to make data-driven decisions that increased quarterly revenue by 8%.

SQL Database Administrator – Internship Jan 2022 – May 2022 ACCENTRO LABELS PRIVATE LIMITED - Bangalore, KA.

• Managed and maintained 10+ SQL databases, ensuring 99.9% uptime and seamless data availability across multiple teams.

• Optimized over 50 complex SQL queries, reducing query execution time by an average of 40% and enhancing overall system performance PROJECTS

Sales Forecasting & Customer Segmentation - Retail Intelligence Dec 2024

• Developed a retail analytics solution integrating sales forecasting and customer segmentation. Applied K-Means & Hierarchical Clustering with PCA for pattern recognition. Built an interactive Power BI dashboard to visualize trends and optimize inventory. Enabled data-driven decision-making for targeted marketing and demand forecasting. Stock Price Prediction – Netflix Apr 2024

• Developed an LSTM model and other time series algorithms in Python to forecast Netflix stock prices, creating a tool for informed investment decisions.

EDUCATION

Master of Science in Data Science Graduated in Dec 2024 Kent State University – Kent, OH

Bachelor of Science in Computer Science Graduated in May 2022 University of Mumbai – Mumbai, MH

CERTIFICATIONS

• Data Science Job Simulation – (BCG) Feb 2025

• Data Analytics Essentials – (Cisco) Jan 2025

• Training in Python with Django – (Questech) Jul 2023

Contact this candidate