Andrew Wang Email & Phone Number

Bellevue, Washington, United States

• Senior Analyst on City of Bellevue's new Business Consulting Services team.- Define the new business and IT consulting team within City of Bellevue's ITD. Manage the entire project pipeline bridging non-technical groups with technical solutions.- Collaborate with stakeholders to understand complex business needs and requirements and translate those into functional requirements and technical specifications.- Lead the analysis effort, including gathering, documenting, and analyzing business requirements and processes.- Work closely with cross-functional teams to develop project plans, estimates, and timelines.- Act as a subject matter expert for business processes and technology solutions, providing guidance and recommendations to stakeholders.- Deliver options analysis, gap analysis, workflow analysis, and business process reengineering.- Develop and maintain project documentation, including requirements, functional specifications, use cases, and test plans.- Develop and execute test cases to ensure successful delivery of technology solutions.- Provide leadership and guidance to junior business analysts and other team members.

Renton, Washington, United States

• Lead analyst in Market Intelligence & Product Definition group supporting Product Marketing, Aftermarket Engineering, Sales, and TRP departments. Report directly to Executives for all market research requests.- Develop custom SQL within Snowflake for ad-hoc requests to visualize Market Intelligence data for executives and stakeholders. Support all projects and BI initiatives with technical expertise.- Create Tableau dashboards for the entire Parts division to support market research projects and manage data governance for different views in the dashboard collection.- Query, maintain, and analyze data provided by MacKay, ATA, and our other info providers.- Prepare Tableau maps and Excel reports of Parts Sales Potential in support of Truck Division Dealer Development proposals and analyses.• Program manager for the entire Dealer Expansion program, managing $2.5m to support and grow PACCAR’s Kenworth, Peterbilt, TRP, and international sub-divisions. Support the entire Dealer Network active on the program.- Add and assist 200+ active dealers to the program generating $ multi-millions in incentive-based annual sales with the sales team.- Coordinate process improvements for all steps of the program, decreasing lead times necessary to process benefits for new dealers added to the program.- Oversee cross-functional communication on multiple organizational levels ranging from external dealers and suppliers to internal merchandising, sales, customer service, parts orders, TRP, international, accounting, marketing, and executive teams.- Use necessary business acumen to further manage communicating with global stakeholders, budgeting, enforcing approval process, setting qualifications, auditing reimbursements, cross-department conflicts, implementing program changes, and more.

Renton, Washington, United States

• IT/BA: Full systems exposure from working with back-end developers to front-end business users. Usage of Salesforce, Tableau, Snowflake, WorkBench, Microsoft Azure, Gearset within role to build new, manage existing, and fix broken business processes. On call nature of roll allowed exposure to varying IT issues. Led Intro to Python team trainings for my department.• Salesforce Admin: Performed UAT testing, created reports, worked on enhancements from Salesforce users, wrote standard work documents, and developed process flows. Spearheaded new implementations from developers into all departments of business.• Customer Service: Supported thousands of external clients, as well as all internal departments of PACCAR Parts for hundreds of varying business issues. Served both as point of contact, as well as back-end admin in all cases.

Greater Boston Area

Heavily involved in working alongside DetraPel at MassChallenge's Seaport location.

Framingham, Massachusetts, United States

• Operations: Planned product testing and performed quality assurance on outbound products, ensuring correct orders were shipped daily without faulty products. Assisted with a multitude of daily business processes.• Marketing: Managed B2B and B2C inbound marketing by building the CRM database from Excel files into HubSpot’s platform. Observed key marketing metrics to monitor growth. Assisted in content/ads creation as well as digital marketing strategy.• Business Development: Performed sales outreach as the main, new customer acquisition operator for DetraPel, generating hundreds of leads per week. Acted as the customer-facing contact for most B2B clients. Acted as the liaison at MassChallenge, a top startup accelerator. Pitched to seasoned executives and interested investors, as well as obtained mentors for the company.

Babson Park, Massachusetts

• Entrepreneurship: Created a startup for capstone project. Pitched to investors for venture funding and completed entire startup process, from ideation to exiting the company. Donated proceeds to charity.• Finance: Formulated budgets, calculated operating costs, breakeven, product margin, pricing, and more.• Marketing: Created website and used Google Analytics to monitor growth. Set marketing KPIs, created physical and digital marketing content.• Operations: Designed the written product and managed supplier relations including but not limited to: supply chain management, inventory tracking, overseas communication, and more.

Bellevue, Wa

• Customer Service and Sales: Worked on retail floor selling clothing and accessories, stocking/managing inventory, along with improving customer experience and assisting in issues regarding customer service. High sales numbers during each of my shifts.

Greater Seattle Area

Leadership role for 100+ students and 30+ mentors in daily operations. Managed sponsor relations and $150,000+ in annual donations with companies such as Google, Microsoft, and Boeing. Worked closely with technical subgroups as well as business subgroups to balance activities.

Masters Of Science, Business Analytics

Bachelor'S Degree, Marketing/Marketing Management, General, Undergraduate

Activities and Societies: Babson CODE, Babson/Wellesley/Olin Rock Climbing Team, Babson MMA Group, Dean's List

Business Administration And Management, General

Activities and Societies: NSLC Participated in a two-week Business, Entrepreneurship, & Leadership course held at Northwestern University..

Entrepreneurship/Entrepreneurial Studies

Attended a three-week summer intensive college course, learned B2B and B2C skills, and practiced general business management. Focused.

Student, Business/Commerce, General

Student, General Studies