Andrew Mackenzie work email
- Valid
- Valid
- Valid
Andrew Mackenzie personal email
- Valid
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".
-
Business Intelligence ArchitectAppcues Aug 2018 - PresentBoston, Massachusetts, Us -
Sr. Business Intelligence AnalystEmc Mar 2014 - Aug 2018Round 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 -
Product ManagerEmc Jan 2013 - Mar 2014Round 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. -
Business Intelligence AnalystEmc May 2010 - Dec 2012Round 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. -
Techzone Student ConsultantVillanova University Aug 2009 - May 2010Villanova, Pa, UsMostly 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
Andrew Mackenzie Education Details
-
Northwestern UniversityPredictive Analytics -
Villanova UniversityEconomics
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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial