Associate Analytics Consultant

• Apr 2021 - Present

Data Analytics Consultant

• Dec 2018 - Apr 2021

Full details in Resume.Ricoh: o Replace Senior Business Analyst while she was on maternity leave to inherit all Alteryx workflows and processes that occur in Ricoh. o Develop workflow to parse all SQL tables used in all Alteryx workflows and to know which users have access to them on Gallery and when they were last run.o Upgrade Alteryx Servers.Lendlease: o Assist leading development team for Salesforce data by creating workflows that reads data from shared OneDrive locations to create new sites/projects/activities/equipment and update existing entries in Salesforce and store incrementally in PostgreSQL database.o Created major workflow processes including a daily process that parses purchase order request from Excel files that validates key IDs and loads them into staging tables and into Salesforce.o Created several Power BI reports by transforming data in PostgreSQL tables to summarize the project finances, timesheets and tracking target/actuals for performance.WPP:o Designed a dashboard in Tableau for their sales division to analyse client invoices to determine overdue invoices and to track sales over time.Department of Finance:o Developed workflows and chained analytic apps for the Federal Budget to allow users to submit their proposed budget and parse excel files detailing requested budget for projects/programs from all Government Departments to be written into SharePoint.o Deploy and maintain workflows in dev/test/training/prod environments by creating dynamic and adaptable connectors to allow smooth transition between these environments.South West TAFE:o Connect to finance tables in Alteryx and transform and manipulate data to answer key business questions (when students are exiting the enrolment process, how prevalent are duplicate applications) and other metrics.o Create comprehensive Tableau dashboards to visualise an overview of company’s finances, budgets, and staffing.