Andy Kurti
****.********@*****.*** • 718-***-****
Professional Summary
Data Analyst with 2+ years of experience leveraging Excel, SQL, Power BI, Tableau and advanced analytics with R to drive business insights, optimize performance, and increase revenue. Proven track record of improving operational efficiency by 20% and boosting customer retention by 15% through data-driven strategies. Adept at collaborating cross-functionally and delivering actionable visualizations. Seeking to apply expertise in predictive modeling and emerging technologies to solve complex challenges. EXPERIENCE
Elite Travel Group – Data Analyst (Remote) October 2022 – Present
● Examine customer behavior, demographics and booking patterns to develop targeted strategies, leading to a 15% rise in customer retention and a 12% revenue growth within six months.
● Collaborate with sales and marketing teams to evaluate campaign effectiveness, leveraging tactics to enhance promotional strategies, achieving a 17% increase in peak-season customer acquisition.
● Utilize SQL to analyze tour sales performance across different regions and optimize marketing spend using Excel, boosting sales by 13% in underperforming regions and improving marketing ROI by 15%.
● Perform seasonality analysis on tourist arrival data using R to predict future trends through regression models, resulting in a 20% increase in operational efficiency.
● Create interactive Power BI dashboards and use SQL to monitor and analyze across marketing, customer, finance, and sales metrics, providing leadership with real-time insights and reducing costs by 8%. Pro-Service Agency LLC – Tax Preparer January 2020 – June 2021
● Streamlined tax preparation by inputting financial data into ATX and QuickBooks for corporate and personal returns.
● Managed client records (W-2s, 1099s, bank statements) with meticulous organization ensuring precise labeling, filing, retrieving.
● Performed monthly reconciliations of general ledger, bank accounts, credit card statements, etc maintaining 100% accuracy.
● Delivered follow-up client communication to request missing information and answer inquiries. Elite Travel Group – Accounting & Finance Intern June 2019 – Sept. 2019
● Gathered, recorded, stored, and analyzed financial data, ensuring weekly and monthly financial reports.
● Managed accounts receivable by issuing invoices, tracking aging reports, and sending payment reminders for overdue payments.
● Created weekly and monthly cash flow projections, forecasting expected cash inflows and outflows.
● Improved efficiency through cost-benefit and cost-effectiveness analyses, unlocking cost savings, revenue growth, market expansion. TECHNICAL SKILLS
● Programming: SQL, R (Proficient), Python (Familiar)
● Data Visualization: Power BI, Tableau
● Office Suite: Microsoft Office (Word, PowerPoint, Excel – MOS Certified)
● AI Tools: ChatGPT, GPT-4, OpenRefine
EDUCATION & PROFESSIONAL CERTIFICATIONS
● Baruch College, Zicklin School of Business – New York, NY
M.S. in Business Analytics (Data Analytics Concentration) - GPA: 3.55 May 2022
BBA in International Business (Minors: Finance, Economics, History) - GPA: 3.33 August 2019
● Microsoft Office Specialist: Excel Associate & Excel Expert (Office 2019)
● Tableau Certified Data Analyst