Data Analyst Business

MARK MACCUISH

**** *** ** **, ******* AB - 403-***-**** - ********.****@*****.***

EXPERIENCE

Applications Analyst/Business Analyst – Business Services: Calgary Stampede (Calgary, AB) (2022) – 4 month contract

Provided first hand user support for the roll out of an accreditation system to allow users access to the park during stampede. Provided application and technical support for the Accreditation system application. Analysis of databases and use of SQL to update and transform into a working cloud-based system. Power BI to produce reports when needed. SharePoint and Salesforce were used to align, gather, organize and analyze information across all departments to be unified into a single database. Ensured all users needs were met in a timely and efficient manner. Helped test, design, document and implement an efficient company wide accreditation system. Provided first hand technical support to all end users and documented, identified and reported on any issues or problems that would require further technical development.

Senior Data Analyst – Pipeline Integrity: ROSEN (Calgary, AB) (2017-2022) – 5 years

Utilized 10+ years of Pipeline Data Analysis to perform advanced analysis of ILI inspection. Interpretation, assessment and reporting of pipeline inspection data adhering to client specific needs. Interpreting MFL, UT and Geometry pipeline inspection data to determine defects location and depth on oil and gas pipelines. Diagnosing and troubleshooting database-related issues. Correlating analysis results to inspection data from previous runs. Assisting with QA/QC processes. Producing reports of ILI tool analysis results as per client requirements.

SQL and database analysis used extensively within reporting procedures to pull data from different tables and to produce comprehensive reports based on the ILI findings.

Ultrasonic Wavelength Detection (UT/UWD) – Level 2

Magnetic Flux Leakage (CDP/MFL) – Level 2

Geomatic Anomaly Analysis (GEO) – Level 1

Field Service Technician – 2 years.

2 years helping load and unload ILI Smart Pigs. Use of GIS and GIS related software to understand locations of pipelines, safety routes, terminals, and other access points along the pipeline for data retrieval. Familiar with extracting data for the Data Preparation teams. Familiar with the entire safety process from loading and unloading smart pigs from start to finish.

Data Analysis: Baker Hughes Inc. (Calgary, AB) (20015-2016) – 1 year

MFL Data Analyst responsible for ILI pipeline inspection. Responsible for detailed analysis of pipeline features. Responsible for defect sizing and reporting as per ILI and client specifications. Use of in house software and SQL to analyze data structures.

Data Analyst: GE Oil and Gas (Calgary, AB) (2009-2015) – 6 years

Data analysis of pipeline data as per ILI inspections. Forecasting of pipeline integrity, business analysis and reporting analysis. Data analysis using SQL technologies.

Creation of relational databases to store data to be used in reporting. Using SQL to query and maintain the database.

Updating data structures according to customer specifications. Creation of large detailed reports for clients to use in analysis of pipeline integrity or for repairs

Help Desk Technician: Niagara Region (Municipal Government) (St. Catharines, ON) (2007-2009) – 2 year

Tier 1 and 2 IT Help Desk. ITIL v2 (2007) was used to coordinate and collaborate efficient and cost effective IT solutions and resources for all end users. Provide end user support for various software and hardware related issues in a professional and timely manner. Monitor and respond to all incoming IT / Help Desk questions and escalated issues when needed. Provided and helped support daily IT issues for all employees. Helped provide solutions to streamline Help Desk such as introduced LogMeIn and other 3rd party IT Support applications.

Technical Support / Help Desk: Belmar and Associates (St. Catharines, ON) (2006-2007) – 1 year

Use of Microsoft Dynamics and Salesforce CRM software to help engage customers and to help create a stable sales and marketing relationship with customers. First hand end technical and user support for the Mortware ™ software development team. Responsible for customer acquisition, interaction and technical support and all Mortware ™ related queries and questions. Remote login to clients to troubleshoot any problems, questions or queries.

Hardware / Software Installations: IBM Canada (Niagara Falls, ON) (2007-2008 – Casual)

Responsible for de-install and installation of computers, networks, and software/hardware upgrades to various systems. Set up of Lan/Wan at various locations. Installation of various computer systems and POS terminals as per client specifications. Set up of WAN/LAN networks via Windows Server.

EDUCATION

BACHELOR OF COMMERCE – INFORMATION TECHNOLOGY MANAGEMENT (ITM) – Ryerson University (Toronto, ON) - 2002-2007

Major in Systems Development and Implementation. Minor in Database Design.

INTERNATIONAL STUDENT EXCHANGE – Napier University (Edinburgh, Scotland) – 2004-2005. Took part in an international exchange program for the duration of one year.

SKILLS

PowerBI, Tableu, SiSense, Sharepoint, Database Analysis, Data Analysis, Salesforce CRM / ERP, Reports/Reporting, Data Integration and Migration, TCP/IP, SAP, ERP, SAP Work Manager, VoIP, Novell Netware, C++, Visual Basic, ASP.NET, PLSQL, Windows Server 2000, SQL, ERP (SAP R/3 ERP), Java Programming, Microsoft Access, Work Manager, Active Directory, Excel, ACCPAC, Networking, Application Development, Database Analysis, Systems Analysis & Design, Managing Information Systems, ERP.

OTHER

I play competitive soccer year around (indoor/outdoor). I am an avid chess player. I worked with and volunteered with the Big Brother Big Sister corporation of Canada.

Contact this candidate