Gary Whelan Email & Phone Number

Vancouver, British Columbia, Canada

- Integration of a new finance data platform.- Modelling and forecasting trading activities for cash flow.- Process automation.- Data Visualisation- Database management- Ad hoc analysis - Writing and leveraging complex SQL queries to solve business questions for senior management.- Data quality.- Leveraging the latest snowflake cloud applications such as Sigma for various tasks such as reporting, visualisation and workflows.- Regulatory reporting

Vancouver, British Columbia, Canada

As a Standard Parts Catalog Data Analyst, I work in a team that oversees the creation and management of commercial off the shelve and fabricated parts in a catalog. Working with Engineering, Production, and other stakeholders, I oversee the creation of new parts with data accuracy, consistency and ensure that configuration is maintained across all systems. My main duties and achievements are below:• Took over ownership of the entire project and oversaw 50% project completion in under 25% of the project timeline, in an unfamiliar industry.• Managed multiple commodity groups in parallel with each other, ensuring all deadlines were met.• Introduced and implemented business intelligence tools for KPI metrics and process automation.• Presented analysis, findings, suggestions and solutions on a weekly basis to facilitate standardization meetings.• Developed a macro enabled, new part request form for use as an interim solution during development.• Created and maintained Power BI dashboards, taking data from various sources to monitor commodity management and overall project completion.

County Dublin, Ireland

Working as part of the ITS Resourcing team within the Project Management Office (PMO) firstly as a portfolio analyst before progressing to the functional analyst role within the team. The team works closely with business relationship managers, project managers, team leads, middle and senior managers daily. My main duties and some achievements within the team are as follows:• Automation of PMO processes through Power Bi.• Developing live dashboards used by Senior Managers on a regular basis.• Creation and maintenance of an interactive KPI pack that is used by the head of IT Delivery monthly.• Automating the monthly headcount report which has saved over 30 hours a month.• Service Line cost tracking report. Previously, this was manually run once a month, taking up to 2 days to generate. Now fully automated with up to date information by the day.• Management of the team mailbox. Managing various Stakeholders at all levels. Managing both critical and BAU quarterly change requests. Leading the year end process.

County Dublin, Ireland

As a portfolio analyst on the ITS Resourcing team, my duties were to facilitate the portfolio analyst resource on the team which I later progressed to in August 2019. This role featured more operational tasks such as:• Management of the SAP Portfolio and Project Management tool.• Training new ITS Staff & Partner Project Managers on the SAP PPM system.• Demand and Capacity reporting. Liaising with various stakeholders such as, Project Managers, Finance, Vendors.• Management of the ITS Resourcing mailbox. Averaging 50 queries a week.• On-boarding and off-boarding of staff and contractors.

Ennis, Co. Clare

• Consistently achieved top sales within the company • Crafted exceptional customer experience. • Tailored solutions for all clients.

Ennis Co. Clare

• Handle high volume cash transactions.• Manage stores liability.• Providing excellent Customer Service.• Liaising with Head Office daily on all day to day business matters.• Preparing & executing bank lodgements.• Opening & closing of premises.

Head Office Dublin

• Maintain an accurate view of Demand and Capacity for IT resources. • Develop an accurate schedule of work based on project phases (as detailed in the PMO Framework) • Management / administration of time-sheet system, reporting. • Portfolio level forecasting / re-forecasting and utilization reporting. • Examination of Pre-Tender Qualification Questionnaires for the resourcing framework. • Drafting sections of the RFT that will be sent out to vendors. • Assisted in developing a database of up to date projects including current phases and budgets.

Bachelor'S Degree, Data Analytics, 1St Class Honours

Higher Diploma In Science In Data Analytics, Information Technology, First Class Honours

Level 8 qualification in Data Analytics Modules • Business Analysis and Communication • Business Data Analysis • Programming for Big Data.

Bachelor Of Science (Computer Science & Information Technology), Computer Science & Information Technology, Honours

Computer Systems Fundamentals of Electronic Engineering Next-Generation Technologies I Programming 1/Algorithms I Mathematics Principles.

Leaving Certificate (Honours), Maths/English/Irish/Geography/German/Agriculture Science/Biology, Leaving Certificate (Honours)

Activities and Societies: Represented St. Flannan's College in Football & Hurling.