Data Analyst

Summary

Data and business systems analyst with a proven track record in data analytics, service transition, and change management. The ability to relate to both technical and non-technical audiences and management teams, as well as a strong knowledge of project processes and IT infrastructure, has resulted in effective liaisons between business and IT teams. Seeking opportunities to leverage my analytics knowledge in a business setting.

Skills

Data Analytics: R, Python, SQL, QlikSense, Google Charts, Docker, Kubernetes

Project Methodology and Tools: Agile, JIRA, Confluence, SharePoint

Operating Systems and Databases: Windows, UNIX, Linux, MS SQL Server

Certifications: ITIL v3 Foundations, ArcSight ESM Security Analyst (AESA)

Education & Qualifications

Master of Science in Population Medicine (Concentration in Data Science) Sep. 2015 – Feb. 2018

University of Guelph, Department of Population Medicine, Ontario Veterinary College (OVC)

Bachelor of Science in Computer Science (Minor in Mathematics) Sep. 1999 - May 2003

Graduated with Honors (Magna Cum Laude)

Hartwick College, Oneonta, New York

Professional Experience

Senior Data Analyst Mar. 2019 – Present

RBC Capital Markets (RBCCM), Toronto, Ontario

As a member of the RBC Elements team, render support for equity analysts seeking insights from alternative datasets.

Support or refute analyst hypotheses by wrangling, analyzing, and visualizing curated data with data science tools and techniques (e.g., ggplot and the tidyverse library, plotly, Pearson and Spearman correlation, Hamming and Cosine distance).

Contribute to client-facing RBC Insight products, such as Digital Intelligence Strategy - the most read report of 2021 - and reports pertaining to COVID’s impact on the mining and travel industries, retail point analysis for Canadian telecom providers, and online sentiment analysis for consumer staples brands.

Data sources include Alexa and SimilarWeb (website traffic), AppFigures (mobile app data), Brandwatch (social media data), Google Scholar and PubMed/PMC (clinical trial data), amongst others.

Data Analyst (Consultant) Mar. 2018 – Feb. 2019

Royal Bank of Canada (RBC), Toronto, Ontario

As a member of the Data & Analytics (DNA) team, rendered support for the Capital Markets Analytics Lab:

oDeveloped and implemented data collection and analytics systems which optimized statistical efficiency and quality, including acquisition, filtering, cleaning, and visualization of alternative datasets (social media, geolocation, website traffic, news) from primary and secondary sources.

oConducted data analysis via statistical techniques, including correlation studies and regression modeling, in order to identify and interpret trends and patterns in complex data sets.

Gained exposure to data warehousing techniques, principles, and tools, including ETL (Extract, Transform, Load) processes, physical and logical data models, and Teradata database utilities.

Successfully utilized R and associated packages in acquiring data via Google Cloud and vendor APIs, including the extraction of stock risk metrics from daily time series data spanning 11 years and 137 stock tickers - provided standard and 5D visualizations of the metrics via the ggplot and plotly packages.

Graduate Research Assistant Sep. 2015 – Dec. 2017

University of Guelph, Department of Population Medicine, Ontario Veterinary College (OVC)

Data extraction of surveillance data and weather data from the Environment Canada and Weather Underground websites - utilized SQL scripts and R packages in data cleansing and aggregation.

Data mining and analysis of the surveillance and weather forecast dataset using time series and clustering methods (ARIMA, ARMA, and KNN), Random Forest, Classification and Regression Trees (CART), and Artificial Neural Network models – identified seasonal and trend components; utilized variable importance measures in identifying weather variables strongly associated with infection risk and disease spread.

Text mining, association rules, and data visualization to identify key themes and patterns in datasets.

Social network analysis of equine movement data, including in-degree/in-strength and in-strength/out-degree measures indicative of infection risk and disease spread.

Communication of results via scientific manuscripts, including publications in the Preventive Veterinary Medicine and Transboundary and Emerging Diseases journals.

Senior Application Support Analyst (Consultant) May 2015 – Sep. 2015

BMO Financial Group, Toronto, Ontario

Rendered infrastructure and application support for the BMC Remedy ARS 7.5 ITSM system, including the system mid-tier (application and web servers - Windows Server OS/IBM WebSphere), and end-user web and desktop clients.

Resolved SSH Tectia issues for incoming BMC Remedy feeds.

Maintained retail back-office business managed apps (BMAs) written in VBS and VBA, including daily, weekly, and monthly tasks, as well as yearly audits and re-certifications.

Successfully transitioned daily FileNet Panagon batch jobs from a local drive to a network drive.

Ensured Remedy account setups and modifications were addressed within 1 business day, as opposed to the 5 business days set out in the Service Level Agreement (SLA).

Application Analyst (Consultant) Jun. 2014 – Dec. 2014

BMO Financial Group, Toronto, Ontario

Conducted Windows 7 application rationalization and remediation for designated business units within the bank: worked with internal application owners and external vendors to understand an application’s function, network dependencies and installation requirements.

Verified the production status for packaged COTS and enterprise applications (e.g., Tectia SSH, Netezza client) via Active Directory, and deployed such apps via MS SCCM to Windows 7 operating systems.

Worked with the Service Desk and Field Services teams to resolve user application issues post-migration to Windows 7

Surpassed performance expectations by remediating applications for six business units (with user counts of one hundred or more) within the first three months.

Lead Implementation Analyst (Consultant) Mar. 2012 – Apr. 2014

New York State Housing & Finance Agency, New York, New York

Enterprise rollout of the Manage Engine Service Desk Plus system as a replacement for FrontRange HEAT - as project lead, conducted a feasibility study based on product’s cost, suitability for use, and ease of adoption; identified project stakeholders, worked with network engineers and database administrators to setup test and production environments (server setup, MS SQL 2012 database settings, Active Directory feed and field mappings, e-mail server/gateway configuration, notification rules), provided training and overview sessions for end-users, and managed the GO-LIVE process (end-user communication, support, and HOW-TO guides).

Application support and change management for the Housing Data System (HDS) and Emphasys housing applications on Windows Server 2003/2008 operating systems – applied vendor patches via SQL scripts, completed major upgrades, maintained development, testing and production environments, coordinated UAT, change advisory board (CAB) signoffs, and production releases.

Senior Help Desk Administrator (Consultant) Feb. 2011 – Mar. 2012

Shionogi Inc. (division of Shionogi Ltd, Japan), Florham Park, New Jersey

Served as the technical lead for a one-month Windows 7 migration project for 150 users in a distributed sales force team as well as 200 internal users - deliverables included an assessment of the Windows XP environment using BMC Track-It!, Windows 7 compatibility testing with enterprise applications (e.g., ForeCastX, AlignPlus), e-mail and calendar migrations, deployment via MS SCCM 2012, as well as end-user training.

Rendered support for the SAS application, including installation and configuration of Base SAS 9.2 for the sales and clinical data analytics teams, resolution of import/export issues between SAS and Microsoft Office 2010, as well as compatibility issues between SAS, Java, and Windows 7 32/64-bit platforms.

Network Operations Center (NOC) Analyst Jan. 2010 – Jun. 2010

Vigilant by Deloitte & Touche LLP (formerly Vigilant LLC), Jersey City, New Jersey

Represented the Operations team in Vigilant on-boarding sessions for several high-profile clients, including the New York Stock Exchange (NYSE), FBR Capital Markets, and Wawa Inc. Worked with security engineers to understand client rules, queries, and dashboards, and subsequently documented outage procedures and SLA requirements for each client.

Performed installation, configuration, testing and upgrades for Security Incident and Event Management (SIEM) systems: ArcSight Manager, ArcSight Database (Oracle 10g) and ArcSight Console on Windows and UNIX systems.

Utilized VMware VSphere in creating virtual machines for Red Hat Enterprise Linux (RHEL 5 and 6) and Windows Server 2003 operating systems.

Reviewed Java-based logs to determine root causes for abnormal system behavior.

Infrastructure/Data Center Analyst Oct. 2007 – Dec. 2009

Citigroup Inc. (Data Center Operations), Warren, New Jersey

Application support for data center applications utilized at the world’s largest bank, namely:

oTechnology Asset System (TAS, in-house infrastructure inventory tool):

Ensured virtual system installs by system administrators were compliant with Operations & Technology (O&T) standards (e.g., ESX servers in clusters and IBM LPARS in domains).

Daily feed reconciliation with Aperture and the BMC Remedy-based Global Technology Management System (GTMS). Ensured devices entered in either system filtered into TAS and vice versa.

Technical lead for the Technology Asset System (TAS) decommission project - identified key workflow processes for transition to Aperture, including incoming and outgoing feeds from auxiliary sources, table, field mappings, and data discrepancies, potential end-user impacts, and a phased approach to the system’s shutdown.

oAperture (datacenter service & resource management tool):

Served as a liaison between end-users and developers for application issues in the production environment.

Verified integration with the Technology Asset System (TAS), identified inventory gaps in databases using SQL, and initiated reconciliation where necessary.

oHewlett Packard’s Asset Center and Radio Frequency Identification (RFID) technologies:

Co-authored the Asset Center Service Level Agreement (SLA) for outage, change, and problem management – identified key stakeholders (infrastructure, application, and database teams), stakeholder roles and responsibilities, obtained agreement on service levels, maintenance windows, and change advisory boards.

Worked with geographically diverse system administrators, information security, and application support teams in the analysis, design, and implementation of the SSH Tectia public key authentication between Asset Center and the firm's employee data and purchasing systems.

Contact this candidate