Andy Ryan Email & Phone Number

New York, New York, US

• Promoted to Senior Sales Operations Analyst March 2023.
• Revamped pipeline and booking reporting by developing a Power BI dashboard, providing clear visualizations of company progress and enhancing decision-making processes.
• Partnered with senior leadership to deliver quarterly reports on target attainment and QoQ/YoY performance for board meetings.
• Developed a dashboard for the Senior Vice President of North America to track AE bookings, win rates, open pipeline, and product sales performance. Enabled the SVP to manage sales rep rankings and monitor individual AE.
• Improved reporting efficiency by creating saved SQL views in Snowflake, reducing reliance on direct Salesforce queries. Streamlined the process for writing custom fields in SQL, enhancing speed and simplicity compared.

New York, New York, US

Stamford, CT, US

• Created and presented a live revenue dashboard for our Strategic team to follow daily progress toward monthly goals; dashboard doubles as source for compensation team.
• Created new territories for new account managers.
• Report on monthly sales KPI’s for CEO and the leadership team.
• Run ad hoc reports in SQL and report using Excel Pivot tables or PowerBI for VP of sales and leadership team.
• Trusted with sales operations duties in place of manager who was on paternity leave during the initial months of the Covid 19 pandemic. Assumed all sales operations responsibilities after manager’s departure from the.

Austin, Texas, US

Austin, Texas, US

• Designed and presented to department leadership, a sophisticated Tableau dashboard that visualizes and provides insights on the Resume product metrics, operations and vendor/moderator decisions (error rates and.
• Used Tableau to analyze success/failure rates of system rules that were incorrectly putting hundreds of accounts into moderation. Error rates declined by up to 90%.
• Perform in-depth investigation of companies to yield insight on communication with job seekers.
• Created lesson plan and trained team how to use SQL for data analysis.

• On-site contractor at Apple Inc.
• Designed and presented to leadership, a Tableau dashboard which tracked air, hotel & car travel data and trends. Converted a 30-slide quarterly spreadsheet report into a 5-tab visualization for department leadership.
• Designed Tableau dashboard to track weekly performance of virtual payments challenges.
• Trained and supervised team in Costa Rica to manage nearly $1 million in credit card data reconciliation.
• Reconciled virtual credit card travel expenses for Apple job candidates and retail employees.
• Produced ad hoc data reports for financial analysts.

Miami, FL, US

• KEY PROJECTS
• Presented recommendations on animal testing alternatives for Global Citizenship Program while maintaining profit potential. Gained leadership and project management skills leading team from project inception to day of.
• Demonstrated leadership by pitching and persuading team collaboration in support adoption of personal event-organizer business idea for final project. Qualitatively explored market share for such services. Conducted.
• Performed foreign direct investment (FDI) analysis of Brazilian economy:(See LinkedIn PROJECTS section)
• Researched Starbucks' international operations and explored business model. Focused on International trademark disputes in China. (See LinkedIn PROJECTS section)

• Managed personal portfolio, trading stocks and options on a weekly basis.
• Analyzed income and balance statements of multiple companies for future opportunities.
• Assessed past performance and risk to determine future upside potential of individual securities.

Washington, DC, US

• Ensured approval of 100+ media publications for Press Secretary in collaboration with House Administration Committee regarding regulatory approval of district media communications.
• Drafted detailed weekly committee hearing analysis, reporting results straight to congressman and authored correspondence letters addressing public concerns.
• Trained 6 interns on task delegation, job role definition, and tour procedures. Collected, analyzed, and interpreted relevant press clipping for Congressman.

Master Of Business Administration (Mba), International Business

Intermediate Sql Bootcamp

Sql Bootcamp Workshop, Sql

Bachelor Of Arts (B.A.), Political Science

Media And Democracy

Pre-University Study Abroad Program