Juan Vasquez Email & Phone Number

Orlando, Florida, United States

 Collaborated actively with digital commerce sales managers, accountants, product managers, andother teams within the company to provide support for open-ended questions and data analysisopportunities that could present solutions for different questions, upcoming or ongoing projects. Utilized Tableau and Power BI to create management reports and dashboards that displayed salesperformance and customer opportunities to support running all digital commerce accounts (suchas Amazon, Home Depot, Lowe’s, and others) Collaborated with IT to establish API (for Amazon and Home Depot accounts) and EDIconnections on SQL server. Created an auto scheduled refresh database for all internal data of sales to feed all reports anddashboards created for all digital commerce accounts. Assisted IT in designing and maintaining external and internal data pipelines, tables, and viewsin Snowflake, SQL server, Microsoft Azure for all digital commerce accounts. Created databases with multiple data sources from customers to extract meaningful data insightsfor Amazon, Home Depot, Lowe’s, and Tractor Supply. Co-led analyst peer groups to drive culture and further garner company-wide interest in dataanalytics. Presented data analysis and provided recommendations to all digital commerce salesmanagers and leadership.

Melbourne, Florida, United States

• Conducted quarterly data analyses with Rock Gym Pro, Excel, and R to providerecommendations for better business and marketing decisions, as well as for creating in-gymservices and events. This allowed for attraction of new clientele, as well as record-breakingincrease in membership retention and sales.• Provided support to the CFO in analyzing business cases, and conducted risk analyses to assist ininvestment decisions.• Identified potential financial risks and conducted due diligence in the investigations forbusiness cases.• Utilized excellent time management and project management skills to successfully oversee andmanage over seven projects from planning to completion. These projects resulted in a 20% increasein revenue for both Melbourne and Miami locations.• Built three financial models to run different business scenarios and ensure profitabilityfor the company.• Created and developed business plan proposals by conducting annual forecasting, budgeting,reporting, and preparing end of the month financial reports. Projected earnings were met eachtime.• Aided General manager in handling administrative tasks to further improve operations andincrease efficiency of the gym in terms of staffing, training, products, and services.• Proposed, aided in creation, and managed marketing strategy plans, sales programs, and gymimprovements which aided in attracting new members.• Created new services that utilized the newly renovated and modernized gym to remaincompetitive and in line with top name rock climbing facilities.• Organized and implemented job roles and functions across all 14 employees.• Created data visualizations for quarterly marketing studies and examined customer demographicsfor better management and decision making.

Miami-Fort Lauderdale Area

• Helped to create, assist, and manage a re-building plan for the business to changeinfrastructure, increase sales, membership retention, and revenue.• Created data visualizations for advertising and demographic studies to aid in targeting the• Created training programs and services that utilized the improvement to modernize the gym.This has allowed for the gym to remain competitive and in line with top name rock climbinggyms.correct audience for marketing campaigns.• Implemented better cleaning and data collection methods to increase efficiency.

Miami/Fort Lauderdale Area

•Coached multiple youth athletes every year for yearly USA Climbing Nationals Championshiprock climbing competition.• Incorporated 10 years of route setting experience to set challenging routes for the team tofurther increase their climbing skills and abilities.• Communicated professionally with parents and family of team members. Aided in creation of aparent-leader group which further increased team-bonding among the team.• Served as a mentor and educator to troubled youth seeking lifestyle changes and was a trustedsource of support for the climbing team.• Brought forth advanced knowledge of coaching techniques in relation to human behavior.• Planned group work to encourage team-building skills.• Worked well independently and on a team to solve problems.• Developed multiple mental and physical climbing training sessions for all range levels.

Miami/Fort Lauderdale Area

Xuzhou, Jiangsu, China

Bachelor'S Degrees, Economics

Activities and Societies: President and co-founder of the FIU Rock Climbing Club and Captain of the FIU Rock Climbing team. Former.

General Education Degree, Study Of Chinese Language

Activities and Societies: Active member of the Student Council for international students. Professor's and Administration Assistance. Full.

Associate'S Degree, International Relations And Affairs, Gpa 3.4

Activities and Societies: Member of the Chinese Club.