Alin Airinei


11743


Email: alin.airinei924@gmail.com              LinkedIn: https://www.linkedin.com/in/alin-airinei/
            
GitHub: https://github.com/Al-1n             Portfolio: https://al-1n.github.io/portfolio/



Summary


Data Analyst with a background in Physics and hands-on experience in SQL, Excel, Power BI, and Python. Skilled in financial and business analytics, dashboard development, data modeling, and performance reporting. Adept at transforming complex datasets into clear, actionable insights that support strategic decision-making. I bring strong analytical abilities, meticulous attention to detail, and a drive for continuous improvement.



Education


Bachelor of Science in Physics, Stony Brook University



Skills


Analytics and BI Tools: Excel, Power BI, Tableau, Streamlit
Programming Languages: Python, SQL, C++, Fortran
Databases: Microsoft SQL Server (T-SQL), MySQL, PostgreSQL
Development: Visual Studio Code, Jupyter Lab
Operating Systems: Linux, Windows
Version Control: Git

Curently Learning

SAP Business Analyst Professional Certificate - ERP processes, supply chain & finance modules, SAP analytics fundamentals
Agile Project Management (Google Agile Essentials) - Scrum, Kanban, iterative development practices



Portfolio Projects


  1. T-SQL Database Management - SQL Server VS Code

Built a structured reference library of T-SQL queries for the AdventureWorks2022 database.
• Developed examples covering joins, aggregations, CTEs, window functions, stored procedures, and transactions
• Documented database restoration processes and best practices for SQL Server
• Organized SQL scripts for clarity, reusability, and onboarding efficiency

Project Page

2. Excel Financial Statement Analysis - Microsoft Excel

Designed a suite of Excel workbooks focused on financial performance evaluation.
• Built models analyzing cash flow, profitability, efficiency, capital structure, solvency, and growth
• Created sensitivity tools including NPV scenario analysis and ROI calculations
• Applied advanced Excel functions, pivot tables, charts, and structured financial modeling

Project Page

3. Power BI Financial Performance Dashboards - Power BI Desktop

Developed Power BI dashboards to analyze company-level financial metrics.
• Modeled datasets to analyze profitability, operational efficiency, cash flow performance, and ROI
• Built interactive dashboards with KPIs, trend visuals, ratio analysis, and drill-down features
• Demonstrated data modeling and visualization design

Project Page

  1. Machine Learning Predictive Models - Python XGBoost

Built and optimized gradient boosting classifiers for early diagnosis and imbalanced datasets.
• Improved recall from 0.64 to 0.89 using threshold and hyperparameter optimization
• Achieved up to 15% increased F1-score and 10.7% improved AUPRC across XGBoost, LightGBM, and CatBoost
• Produced a full technical report with analysis, methodology, and performance benchmarks

Full Report Project Page

5. Employee Attrition Analysis - Tableau

Analyzed attrition trends for a mid-sized tech company to support retention efforts.
• Identified key patterns based on age, salary bands, gender, department, and job role
• Highlighted high-risk groups and recommended strategies for addressing turnover
• Built interactive dashboards to communicate insights clearly to stakeholders

Project Page



Volunteer Experience


Volunteer Youth Soccer Coach
Huntington, NY
April 2023 to Present

• Planned and executed practice schedules for two teams, improving player performance through structured, age-appropriate training sessions.
• Coordinated tournament logistics, including assembling rosters, raising funds, and managing reimbursements to cover tournament fees.
• Communicated effectively with parents, club officials, and league representatives to resolve scheduling conflicts, provide updates, and address team needs.
• Led player recruitment through advertising, social media outreach, and organizing and running tryouts.
• Fostered a collaborative environment by working with coaches, trainers, and club officials to manage schedules and ensure compliance with league requirements.



Relevant Coursework


Financial Management Specialization - Duke University
Supply Chain Analytics Essentials - Rutgers the State University of New Jersey
Data Science Specialization - IBM
T-SQL Bootcamp - Packt