Andrew Mackenzie

Andrew Mackenzie Email and Phone Number

Business Intelligence Architect at Appcues @ Appcues
Andrew Mackenzie's Location
Boston, Massachusetts, United States, United States
Andrew Mackenzie's Contact Details

Andrew Mackenzie personal email

About Andrew Mackenzie

Experienced Data Analyst & Team Lead working in the information technology and services industry.Skilled in predictive analytics, machine learning, data analysis, Python, Snowflake, AWS, Bedrock, R, NodeJS, SQL, ETL, DBT, database administration, data pipeline development, semantic business intelligence layers, Tableau, and Looker.Earned a Bachelors in Economics from Villanova University and a Masters in Predictive Analytics from Northwestern University.I've never stopped developing new skills and have always found a way to become a heavily-depended-upon problem-solver on every team I've ever worked on. And all for one primary reason: my answer to "Can you make this happen?" is always "Yes".

Andrew Mackenzie's Current Company Details
Appcues

Appcues

View
Business Intelligence Architect at Appcues
Andrew Mackenzie Work Experience Details
  • Appcues
    Business Intelligence Architect
    Appcues Aug 2018 - Present
    Boston, Massachusetts, Us
  • Emc
    Sr. Business Intelligence Analyst
    Emc Mar 2014 - Aug 2018
    Round Rock, Texas, Us
    • Developed an automation scheme using Windows Server 2008, Python, Selenium, VBA, and Task Scheduler to screen scrape online data sources, query databases, and load the data into dashboards, reports, and my team's own "data mart", drastically simplifying my team's analyses, allowing us to connect new sources of data to drive new insights, and reducing time-to-results by up to 95%. Visualization of the reports was done via Excel, PowerPoint, and Tableau.• Developed with Excel and VBA, tested, and maintained a web-published tool which enables all VMAX3 customers to obtain budgetary quotes for future VMAX3 system upgrades.• Analyzed VMAX install base data to determine eligible systems for a “tech refresh” program being executed by the EMC enterprise sales division.• Mentored and guided junior members of the analytics team through various analyses.• Maintained a “VMAX Dashboard” excel tool which reduces the time required to perform many analyses of VMAX sales data by up to 90%.• Managed a small team (4 members total) of analysts. Held team meetings. Coordinated and assigned tasks. Trained new team members.• Performed data analysis and reporting with MSSQL, PostgreSQL, Python, VBA, Tableau, and Excel.• Set up and administered windows server and linux VMs, and MSSQL and PostgreSQL databases
  • Emc
    Product Manager
    Emc Jan 2013 - Mar 2014
    Round Rock, Texas, Us
    • Gathered, prioritized, and documented requirements for a web application for automated ordering and upgrading of VMAX Cloud Edition. Built, with Excel and VBA, a testing tool against which all development was tested to verify accuracy. • Gathered, prioritized, documented, requirements for, and managed development of the “Service Level Designer”, through which account teams use performance data to determine the service levels required for applications. The application was web based, written in JavaScript on the NodeJS platform. Development followed the Agile process.• Gathered, prioritized, and documented requirements for “Power Calculator” presales tool.• Developed a tool in VBA to assist the field system implementation process for Cloud Edition.• Supported Cloud Edition sales opportunities through daily interaction with field resources.
  • Emc
    Business Intelligence Analyst
    Emc May 2010 - Dec 2012
    Round Rock, Texas, Us
    • Developed and updated “VMAX 10K Metrics” package on a quarterly basis using OBIEE, Excel, and VBA, which provided a detailed snapshot of the VMAX10K business globally.• Developed, maintained, and updated “Five-Year-Plan” and annual planning budgets and revenue forecasts for VMAXe and VMAX 10K.• Assisted VMAX product management in the development of requirements by providing detailed quantitative analyses on disk storage markets and the VMAX business.• Ran queries from Oracle Business Intelligence (OBIEE), used excel, and wrote code in VBA on a daily basis.• Leveraged corporate consulting resources and research vendors like IDC and Gartner to research disk storage segments of the cloud market, BRIC countries, and specifically China.• Developed a field-facing corporate positioning presentation for the VMAX 10K product.• As a member of the “VMAX 10K Deal Desk”, performed pricing analyses and recommended optimized system configurations for competitive deals that were submitted by the field.• Built VMAX demo environments for EMC World 2011 using VMware vSphere 4.1.• Developed configuration rules for VMAX Cloud Edition, and the “Configuration Tool” with which all Cloud Edition BOMs were configured during the first eight months after release.• Modeled, with Excel and VBA, thousands of permutations of VMAX system configurations to identify “worst-case” scenarios, margin & TCE impacts, and to inform pricing & positioning.
  • Villanova University
    Techzone Student Consultant
    Villanova University Aug 2009 - May 2010
    Villanova, Pa, Us
    Mostly virus removal and laptop hardware and software repairs. I can swap out a dell D630 motherboard in 7 minutes, and an E6400 in 9 =)

Andrew Mackenzie Skills

Data Analysis Microsoft Excel Visual Basic Powerpoint Product Management Obiee Python Analysis Microsoft Word Vmware Java Excel Word Sas Programming R Linear Regression Regression Analysis Cluster Analysis Microsoft Sql Server Databases Reporting And Analysis Financial Analysis Statistical Data Analysis Data Structures Json Web Scraping Postgresql Report Building Database Administration Team Management Pgadmin Technical Translation Enterprise Storage Emc Storage Solutions

Andrew Mackenzie Education Details

  • Northwestern University
    Northwestern University
    Predictive Analytics
  • Villanova University
    Villanova University
    Economics

Frequently Asked Questions about Andrew Mackenzie

What company does Andrew Mackenzie work for?

Andrew Mackenzie works for Appcues

What is Andrew Mackenzie's role at the current company?

Andrew Mackenzie's current role is Business Intelligence Architect at Appcues.

What is Andrew Mackenzie's email address?

Andrew Mackenzie's email address is am****@****ail.com

What schools did Andrew Mackenzie attend?

Andrew Mackenzie attended Northwestern University, Villanova University.

What are some of Andrew Mackenzie's interests?

Andrew Mackenzie has interest in Guitar, Programming, Skiing, Exercise, Technology, Civil Rights And Social Action, Politics, Education, Data Science, Investing And Markets.

What skills is Andrew Mackenzie known for?

Andrew Mackenzie has skills like Data Analysis, Microsoft Excel, Visual Basic, Powerpoint, Product Management, Obiee, Python, Analysis, Microsoft Word, Vmware, Java, Excel.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.