Zander Ilagan

Multi-talented Analyst specializing in Excel, Google Analytics, Google Tag Manager and Microsoft Access. Well-versed in due diligence, valuations and statistical analysis. Prepares models, forecasts trends and gives presentations. Detailed in data analysis and reporting for audits, trend determination and financial planning. Intelligent, insightful and pragmatic with resourceful and detail-oriented approach. Versed in SQL, Python, AWS and familiar with all facets of operations.

Object-Oriented Programming for Business (CIS 3090)

• Utilized Google dataset to practice future prediction on revenue of mobile devices
• Defined mining structure to support modeling using Tableau, Google Tag Manager, and Google Analytics
• Train models by populating them with selected data, or a filtered subset of data

Big Data Analytics (CIS 4567)

• Analyzed gaming dataset consisting of 16k units with Pyspark to predict what country and what genre of game would thrive in the future
• Applied regression and clustering to dataset to compare top 5 countries
• Utilized AWS and gathered info with 94% accuracy that US would generate $1.1 billion dollars in video games alone in the next 5 years

Advanced Data Analytics (CIS 4680)

• Examined ice cream dataset containing over 30k units on Jupyter to determine what ingredient and what brand is top
• Utilized data mining, machine learning, pattern matching, forecasting and visualization
• Concluded research with findings of 96% accuracy

Google Analytics, Google- Aug 2020-Present