Tony Jianqi Yu Email & Phone Number

Boston, MA, US

• Leverage SQL and visualization tools to effectively analyze and transform proprietary Network and Market data into actionable insights for clients and internal teams, facilitating informed decision-making.
• Facilitate the development and implementation of the client's new Target Marketing strategies, leveraging data analytics and market research to enhance subscriber acquisition, ultimately driving greater client success.
• Pioneer the exploration and refinement of innovative data combinations, laying the groundwork for future development and strategic initiatives, to drive competitive advantage and sustainable growth.

• Analyzed and interpreted network performance data on internet service providers (ISPs), delivering comprehensive reports and findings directly to clients, ensuring accurate and actionable insights.
• Collaborated within a team to develop and deliver impactful monthly and quarterly presentations to clients, effectively communicating key performance metrics, trends, and recommendations.
• Proactively addressed ad-hoc requests from diverse client teams, providing timely and insightful responses and conducting demos on utilizing our internal SQL-based tool to extract network and market performance data.

• Conducted in-depth research on key industry events, utilizing SQL and Excel to automate the updating process of a bi-weekly fiber overbuilder tracker, ensuring accurate and timely information for decision-making.
• Collaborated on the development of an internet outage detection tool, aimed at improving clients' and internal teams' understanding and tracking of current and recent internet service disruptions, facilitating.
• Developed industry-specific term resource pages to facilitate the onboarding process for new hires, providing them with valuable knowledge and ensuring a smooth transition into the company's work environment.

Boston, Massachusetts, United States

• Analyzed complex broadband disruption incident data and transformed it into concise and engaging data stories by SQL and Excel and using visualization tools (i.e. Tableau).
• Crafted and presented comprehensive, long-term data analysis to key internal stakeholders at the conclusion of the internship.
• Conducted external research to reinforce analysis and supported the client team by delivering key deliverables, including attending client calls to receive feedback.

• Developed and analyzed 3,000+ study abroad student data using Tableau and SQL
• Managed 1,500+ application profiles using TarraDotta (CRM System) to complete data profiling
• Maintained a knowledge base of the evolving study abroad product offerings and advertise study abroad through designing posters, building websites, and hosting events; coordinate over 25 inquiries per week to connect.

Waltham, Massachusetts, United States

• Designed, conducted, and analyzed parent surveys using Qualtrics, Excel, and Tableau.
• Recommended potential partnerships and structures to help achieve long-term sustainability.
• Conducted needs assessment to define the scope of work resulting in BJEP implementing our recommendations across all areas of inquiry.
• Developed digital marketing strategy to increase enrollment and revenue.

Nashville, Tennessee, United States

• Analyzed 3000+ customer data and built predictive models using Excel to evaluate new patient growth opportunities and identified future target markets more efficiently; attended Chamber of Commerce events to network in.
• Developed new marketing strategies based on consumer insights; enhanced vision exam booking rate by 20%
• Created an outsourcing and sales project to transform a mature product; discussed project updates weekly with the CEO and the management team; increased the product and company's publicity and customer engagement

Master Of Science - Ms, Business Analytics, With Distinction

Activities and Societies: Member of University Chorus, Graduate Outdoors Club; leader of InterVarsity Christian Fellowship.Relevant.

Bachelor Of Arts - Ba, Major In Business, Magna Cum Laude

Activities and Societies: Memebr of Concert Choir and Chamber ChoirRelevant Coursework: Calculus I, Managerial Economics, Organizational.