Alexander Mackey Email & Phone Number

Germantown, Md

Served as the main point of contact for multiple clients. Developed a deep understanding of their business challenges, recommended predictive models and A/B tests, provided guidance and interpretation for valuable insights and optimized solutions.Led a team of up to four direct reports, including developers and business analysts, providing consistent feedback, coaching, and training. Successfully guided them to achieve individual and team objectives, and enhanced our capability to simultaneously service a greater number of clients.Contributed to initiatives aimed at standardizing, simplifying, and documenting data warehousing and direct marketing campaign processes, allowing new team members to quickly integrate and contribute value.Drafted and refined client account agreements, including statements of work, master services agreements, pricing structures, and data governance policies.

Germantown, Md

Onboarded new clients and projects by: gathering program or request requirements, identifying and implementing relevant data sources and data cleansing processes, creating client-specific data warehouse and data transformations / enrichments, creating automated reports focusing on data quality and marketing campaign results, collaborating with our internal Analytics department to design and create customer profile and behavior prediction models, and setting up acquisition direct marketing campaigns with custom suppressions, selections, and creative assignment.Led strategic client meetings to support account development and growth opportunities, providing recommendations and insights on results, trends, and A/B test performance for four direct marketing clients.Developed and standardized a method in T-SQL to optimize postage efficiency in the selection process, resulting in an average of 20% reduction in postage cost.Conducted exploratory data analysis on first and third-party data sources to assess their relevance and uncover actionable insights.Used SQL, Excel, Python, ArcGIS, SSRS, Power BI for analysis and reports, PowerPoint for presentations, and Jira for project management.

Germantown, Md

Built data mart extraction processes for direct marketing campaign selection and results analysis by developing dynamic SQL procedures, functions, and processes.Increased coverage of the data warehouse to include a comprehensive collection of attributes, transformations, and metrics to be used and evaluated by Analytics.Created a documentation template for each marketing campaign with descriptions of selection strategies and campaign objectives; accompanied by distributions of selections and creative assignments broken out for future reference.Designed, created, and implemented a cost-effective direct mail re-engagement campaign, targeting the prior week's most desirable responders who did not yet convert, ultimately becoming client’s most successful campaign type.Designed, created, and implemented a direct mail prospecting campaign to target the most desirable neighbors of recent conversions using geography data types in T-SQL.

Germantown, Md

Prepared SQL scripts and stored procedures in Microsoft SQL Server Management Studio for production automation.Developed and tested new SQL ETL scripts, QC processes, and metadata for client data feeds.Troubleshoot and monitor automated production tasks and escalated issues when necessary.Executed and evaluated direct marketing campaign selection processes.

Las Vegas, Nevada

• Conducted interviews for potential promoters• Conducted daily meetings to inform promoters about upcoming events and monitored their performance throughout the day and night• Scheduled promoters’ shifts for 3 venues

Las Vegas, Nevada Area

• Conducted interviews for potential promoters• Conducted daily meetings to inform promoters about upcoming events and monitored their performance throughout the day and night• Compiled data from multiple promotion sources using Excel for owners

Blacksburg, Va

• Quickly and efficiently prepared and up-sold cocktails and other food and beverages for customers• Collected and processed payment and using Aloha POS system• Implemented Facebook page & other methods to help market & promote the bar

Blacksburg, Va

• Provided computer troubleshooting and basic support for all students in engineering• Provided support for the initialization of the tablet PC requirement for freshmen• Created website for simpler support

Las Vegas, Nevada Area

• Ensure and educate public safety for patrons and for members of the community• Learn, understand, and delegate staff rotation, cleaning duties, and schedules through shadowing and mentoring

Bs, Business Information Technology: Decision Support Systems

High School Diploma, Systems Technology Support