Alan Wang Email & Phone Number

New York, NY, US

Goshen, Indiana, United States

• Partnered with key business stakeholders to gather business requirements for email marketing analytics using Microsoft D365 and ClickDimensions
• Collaborated with senior data engineer to update ADF and Synapse pipeline to load business required 450+ data points not currently captured within the existing pipeline
• Adjusted 8 stored procedures to transfer new data from landing to staging, conducting data quality audits to ensure accuracy and consistency
• Redesigned data models within the DBO and DW environment, implementing those design requirements across 12 tables and effectively managing over 4 million records
• Coordinated with business area stakeholders to create an interactive PowerBI dashboard, leveraging engineered data and providing 7 valuable business insights into email marketing campaigns

West Lafayette, Indiana, United States

• Orchestrated the development of a real-time database update system, reducing manual intervention by 30% and showcasing a commitment to operational efficiency with expert database management
• Led the creation and implementation of a robust global database for comprehensive data on global weather conditions, sea states, and civilian air, resulting in a 40% enhancement in data retrieval speed
• Engineered the optimization of SQL queries and database performance, achieving a substantial 20% reduction in query execution time and enhancing overall system responsiveness

West Lafayette, Indiana, United States

• Designed visually compelling dashboards using Tableau, transforming complex datasets into insightful visualizations for stakeholders, resulting in a 28% increase in data comprehension and informed decision-making
• Streamlined data procedures for precise tracking and identification of 200+ potential students interested in minors, resulting in a 15% surge in new minor declarations and optimizing of recruitment processes
• Executed in-depth data analysis in Excel to recommend high-potential candidates for the minor, contributing to a targeted marketing campaign that achieved a 30% increase in minor applications

West Lafayette, Indiana, United States

• Applied advanced analytics for venues and events planning, optimizing space allocation and achieving a notable 10% reduction in costs and a 5% improvement in operational efficiency
• Developed predictive models for event attendance and resource utilization, contributing to proactive decision- making and resulting in a 12% increase in overall event attendance and participant satisfaction
• Collaborated with the engineering team to integrate venue-specific data into the planning process, enhancing logistics precision and ensuring the successful execution of high-profile events with minimal disruptions

Bachelor Of Science - Bs, Business Analytics And Information Management, Gpa: 3.6 / 4.0

Activities and Societies: AKPsi, Boilermaker Consulting Group, BAIM Association, Boiler Blockchain

High School Diploma