Resume

Sign in

Senior Data Analyst

Location:
Winnipeg, MB, R3C 0K8, Canada
Posted:
February 20, 2020

Contact this candidate

Resume:

Andrew Robert Bruce

Data Architect / Lead BSA / Master Data Analyst

Member of Ontario Society of Professional Engineers

Chemical Engineering – U. Waterloo – Completed April 1998

Project Management – Master’s Certificate – Completed June 2002

SAP Certified Consultant – Business One 9.0 – Completed March 2014

LinkedIn.com/in/arbruce / Mobile 416-***-**** / mailto:adbv5c@r.postjobfree.com

Summary

10+ years of experience in Master Data analyst, data architect, systems analyst, and data governance subject matter expert within in an Agile environment

Scrum Master expertise including removing blockers, leading planning sessions and daily meetings

Successful end-to-end implementation of Informatica Master Data Management (MDM) solution

3+ years leading technical teams, responsible for balancing multiple time sensitive project deliverables

18+ years total IT software development experience, including architecture, support, software business systems analysis, and project management – following the Systems Development Life Cycle(SDLC) and Agile processes

Big data analysis including AWS, MongoDB, Hadoop, Jenkins automation, data pipelines, JSON, YAML, predictive analytics, algorithms, Python scripting, SSH, Docker containers, and Linux BASH scripting on Data Science Linux clustered nodes

AWS cloud services including AWS APIs, Lambda, IAM, S3, EC2, RDS, AWS Cost Explorer, AWS Budgets, Simple Notification Service (SNS)

Leadership, Management, and Training Qualifications

3+ years of team leader experience

Scrum Master (of a 5 member Agile team)

Highly adept at interacting with technical developers and analysts providing them clear direction and expectations

Master’s in Project Management

Promoted to development leader after one month (in Delta, Greater Vancouver)

Delivered numerous presentations and training sessions to large and small groups

Master Data Management (MDM), Enterprise Master Data (EMD), and Governance

Experienced in MDM maturity assessment leading to a MDM solution road map

Identified MDM tool requirements, MDM vendor landscape, RFI/RFP evaluation, and contract negotiation

Architected Informatica MDM solutions providing business, governance, and technical recommendations

Directed and managed Master Data Management and Data Governance through all phases of the project life cycle including planning, blueprinting, requirements gathering, design, development, testing, and go-live

Lead the analysis of Customer Data Management, including the development of artifacts

Developed and presented written proposals and statements of work to senior management

Conducted multiple whiteboard sessions with clients through the conceptualization, design, and implementation of Informatica MDM

Led Informatica MDM projects with blended onshore/offshore teams

Experienced in Informatica MDM implementation:

oAnalysing and mastering data from disparate systems and multiple subject matter experts / domains via match and merge / match and link

oArchitecting a canonical golden record (best version of the truth)

oOrchestrating workflow, data load (ETL) and data quality using profiling and statistical research using Informatica multi-domain MDM, Informatica Data Director (IDD), Informatica Data Quality (IDQ), Reference Data Manager (RDM)

oMulti domain implementation including Customer Data Management (CDM) and Product

oCollaborated with the MDM team to develop, test, and deploy master data solution

oUtilizing MDM services to create interfaced solutions (using Informatica SIF)

oEstablishing governance to effectively manage mastered domains

oImplemented Business Process Management (BPM)

oCollaborated with security team, solution architects, and source system subject matter experts as the project data architect

oBuilt MDM web service APIs using Informatica SIF

oDesigning a solution to include MDM domains in an Enterprise Data Lake

oTool Skills: Informatica 10.2; Informatica MDM HUB; Informatica SIF; IDD Design; MSSQL; Oracle PL/SQL; ETL/IDQ; Informatica Data Quality; Informatica PowerCenter

Source Systems Integrated with Master Data (MDM)

SAP

Business

Engineering

Operating and Financial

Insurance

Bill-of-Material

Anderson Water Systems

Guidewire PolicyCenter

SolidWorks CAD

Pippen Technical

Guidewire ClaimsCenter

Autodesk AutoCAD

Dagg Construction

Oracle PeopleSoft

AutoCAD Electrical

Oracle EDW (Enterprise Data Warehouse)

Bentley AutoPLANT

IBM ICM (Incentive Compensation Management for Brokers)

Bentley Microstation

(2D and 3D modeling)

BaaN IV

Data Architect and Business System Analyst Qualifications

10+ years data architecture analysis, including tables, relationships, ER-diagrams, and spreadsheets

10+ years of experience with SQL Server including versions 2005, 2008 R2, 2012, and 2014

5+ years of experience with Oracle including PL/SQL Developer 11 and 12

Business process analysis and organizational change management experience gained via numerous iterations of software implementations

Stakeholder management by gathering user requirements, analysing impacts, developing work breakdown structures,, issue and decision management, creating functional design specifications, and data governance

Data modeling experience, including Data Warehouse Design, and ETL

Threat modelling and application security patches / updates including cross scripting and https

Created logical database design followed by the physical database design

Architecture Frameworks: TOGAF and Zachman Framework – since 2005

Master data integration and data process flow expertise (from database to database)

Career total number of start-to-finish implementations: 9

Information Security, Data Privacy, and Risk Mitigation Qualifications

AES 256, AES 128 block size; AES 256, 192, 128 key size

Risk identification and evaluation

AWS Cloud Security: IAM Role, IAM Policy, KMS (Key Management Service), EC2 .pem Private Key, Volume Encryption, Cloud shared security model

Browser add-ons: Privacy Badger, Browsec, HTTPS everywhere

Router configuration

Cross site scripting, SQL injection

Search engines: DuckDuckGo, searX, Startpage

Encrypted Instant Messengers: Signal, Wire, Linphone

SSH private key and public key authentication

Encrypted traffic

SSL certificates

Identity management

Tor browser, Invisible Internet Project (I2P)

Linux: Kali, Qubes OS, Tails

Two factor authentication (2FA) / Multifactor authentication (MFA)

Password managers: Dashlane, LastPass

VPN configuration

Proactive security, document protection

WebRTC browser IP leak prevention

PuTTY, SCP, and SFTP

White hat penetration testing (pen testing)

SAP/ERP (Supply Chain Logistics) Consultant Qualifications

6+ years of ERP / Supply Chain experience including SAP, BaaN IV, and Epicor

SAP certified consultant with expert Supply Chain knowledge for Order to Cash processes, including

oSales Orders –> Inventory –> Delivery –> A/R Invoicing –> Receipt of Cash

oPurchase Orders –> Goods Receipt P.O. –> A/P Invoicing –> Outgoing Payment

Epicor 9.05 Go-Live consultant and report developer including SSRS and Crystal Reports

Data migration experience, including data loading from source systems, as well as Extract-Transform-Load (ETL)

BI and Financial Reporting Qualifications

4 years of BI experience – Oracle, SQL Server, BIDS, SSIS, SSRS, and Crystal Reports analysis and development

Created Crystal Reports and SSRS Reports for accounts payable, accounts receivable, and operations

Complex Oracle SQL queries

Web and Desktop Software Development Qualifications

5 years of development experience using ASP.NET and Visual Basic .NET 2.0 / 3.5

3 years Agile C# (.NET 3.5 / 4.0) development – Specialty: Finding code on the internet which closely matches the problem at hand, copying it, and then adapting it to quickly solve the current problem (using existing code also increases code quality)

PROFESSIONAL EXPERIENCE

Wawanesa Insurance, Winnipeg, MB Jan 3, 2017 – Present

Master Data Analyst, Senior Systems Analyst:

Orchestrating workflow, data load (ETL) and data quality (using Informatica MDM, IDD, IDQ, SIF, and PowerCenter) using data modeling best practices

Source systems / applications in the solution:

oGuidewire PolicyCenter

oGuidewire ClaimCenter

oOracle PeopleSoft

oOracle EDW (Enterprise Data Warehouse)

oIBM ICM (Incentive Compensation Management for Insurance Brokers)

Presentations to approval bodies including Wawanesa Business Intelligence (BI) Working Group

Providing training, job aids (documentation), and material orientation to promote solution adoption

Identified and documented existing Product Structure Master Data governance processes including BI Working group and BI Steering committee flow charts and swim-lane diagrams

Engaged MDM technical and business stakeholders (requirements and architecture) for Customer Data Management and Product data modeling

Documented current state (collaborated with ETL and ESB developers) and designed future state MDM processes (As-Is and To-Be) documenting gaps

Collaborated with the security team to create the following security documentation:

oSecurity impact + third party risk assessment (Informatica 3rd Party Risk Assessment Matrix)

oRegulatory compliance

oCyber Threat Risk Assessment

Cleansed and de-duplicated data allowing the data to become trusted data

Identified, fixed, and monitored data quality problems

Analysed and documented affected Microstrategy reports

Skills and Tools: Informatica MDM, Informatica IDQ, Informatica RDM (Reference Data Management), Informatica PowerCenter (for ETL), Oracle Enterprise Data Warehouse (EDW), PL/SQL queries, PL/SQL Developer v12.0.1, Microstrategy, Sonic Enterprise Service Bus (ESB), Guidewire Insurance Suite (including PolicyCenter and ClaimCenter), Oracle PeopleSoft, IBM ICM (Incentive Compensation Manager for Brokers), Jira, Visio, Office, UML, Adobe, Confluence, SharePoint, Data Architecture, Data Governance, Master Data Management, System Development Life Cycle, Waterfall development process, Agile development process

Big Data Engineer and Analyst:

Designed and developed solutions supporting Predictive Modeling Data Science Analytics

Scrum leader and point of contact for external teams

Provided VIP service and technical support to Data Scientist and Actuaries

AWS REST API development using Python

BASH scripting for Big Data Analysis

Requirements gathering and creation of document artifacts and data model illustrations

Assisted with Machine Learning, algorithms, and application development

Developed project plans, schedules, and work break down for Data Lake ingestion via API

AWS Cloud security implementation including volume encryption, IAM Role, IAM Policy, KMS

Skills and Tools (On Premises): MongoDB, JSON, YAML / YML, Linux BASH scripting including Ansible (playbooks), Hadoop HDFS, Python, Docker, Jenkins automation, Bitbucket, SourceTree

Skills and Tools (AWS Cloud): API development, Lambda, IAM, S3, EC2, RDS, AWS Cost Explorer, AWS Budgets, Simple Notification Service (SNS)

arbruce.net Technical Services, Toronto, ON Oct ‘09 – Dec ‘16

System Analyst and Data Analyst:

Customers

oOleumm8, Toronto, ON

oAxia, Calgary, AB

oOzGroup, Calgary, AB and New York, NY

oWSIB (Worker’s Safety and Insurance Board), Downtown Toronto, ON

oRegency Fireplace, Delta, BC

oAlliance Films, Toronto, ON

oITI Pack Systems, Burlington, ON

orePlan, Downtown Toronto, ON

oCollege of Family Physicians of Canada, Mississauga, ON

Solution Architecture + System Analysis:

Implemented master data modelling and metadata management best practices

Validated Logical and Physical data models, traceability, data requirements and design artifacts

Consulted management developing strategic planning documentation

Met with clients to understand their problems and their business impact

Provided clients stakeholders with recommendations on improving information flow

Created business requirements and functional specifications, including swim lane diagrams

Met with client end-users; Developed gap analysis documentation

Recommended data architecture changes and new report creation methods, reducing report creation time by 25%

Extract Transform Load (ETL), data migration from source systems

Clarified and documented user specifications and requirements

Provided financial systems support and administered financial application security, including CODA

Followed and implemented ITIL and TOGAF (The Open Group Architect Framework) methodologies

UML and Object Oriented software development, including Agile processes

Mathematical optimization

Implemented cloud architecture solutions using Microsoft Azure

Met with end users, and project stakeholders identifying project requirements

Designed ER diagrams and conceptual models using ERWin

Data Management + Software Development:

Implemented modifications to legacy software code as requested by end-users

Created tables, stored procedures, functions, and indexes within SQL Server 2008 R2 and Oracle

Extracted data warehouse data using SQL and SAP Crystal Reports, meeting reporting requirements

Provided data-services via the creation of stored procedures, views, indexes, and functions, using SQL Server 2008 R2, and SQL Server 2012 RDBMS

Converted legacy Microsoft Word VBA applications from Microsoft Office 2007 to Office 2010 facilitating communication with 3270 IBM mainframe

Performed data analysis, data analytics, data mining, and other data scientist tasks

Designed and implemented Chase Paymentech credit card XML web services payment system API enabling annual Ontario doctor professional fee payments by web site

Skills and Tools: ERWin, UML, REST, SOA, Web Services, ASP.NET, Responsive Web Design, SharePoint Reporting Services, Microsoft Azure Cloud Services PaaS, SQL Azure, SQL Server 2008 R2, SQL Server 2010, t-SQL, noSQL, MySQL, SAP Crystal Reports, SSRS, SSIS, SSAS, Data Warehouse (DWH), ETL, Cube Design, MDX, TFS, Microsoft Excel, Power Pivot, VBA macros, Office 2010, 3270 IBM Mainframe, XML, JavaScript, AJAX, jQuery, AngularJS, MS Project, WordPress, CODA 12, Epicor 9.05, SAP Business One 9.0, Agile, SDLC, Waterfall, SaaS, MVC, ITIL, TOGAF, Zachman Framework, Data Architecture, Data Governance

Certified SAP Consultant at ProjectLine Solutions, Saskatoon, Saskatchewan Dec ‘13 – Jun ‘14

Solution Architect; Systems Analyst; SAP Implementation Leader:

New implementation customers include

oPippin Technical, Saskatoon, SK

oDagg Construction, Saskatoon, SK

Supported numerous other existing customers by telephone, email, and face-to-face

Solution Architect + Data Governance + Master Data Management:

Investigated, analysed, and implemented customer requirements and expectations

Imported Master Data from legacy system into SAP

Executed complex SQL queries, extracting business data from the transactional database

Worked with business partner team members to identify work flow and data flow processes

Updated master data price lists, business partners, inventory, warehouses, the item master, and item groups

Worked on multiple concurrent projects in parallel with various non-flexible deadlines

Met users - learned expectations prior to developing customized SQL queries and reports

Backed up customer databases prior to all modifications

SAP Implementation Leader:

Certified SAP Business One 9.0 consultant

Deployed SAP software to customer’s servers, then immediately applied latest SAP patch

Configured SAP add-ons: Integration Framework, CoreSuite, and Enprise Job Costing

Taught users to navigate the system, and demonstrated the application capability via WebEx

Implemented Chart of Accounts and Advanced GL Account Determination

Interacted with accountants, providing reporting solutions, including Profit and Loss

Developed customised Crystal Reports including Sales Quote and AR Invoice

Posted journal entries, and defined posting periods

Developed and corrected financial reports, including cash management reports, within perpetual inventory systems

Skills and Tools: SAP Business One 9.0, Crystal Reports, SQL Server 2012, t-SQL, SAP HANA data services, SAP HANA Studio, Data Architecture, Data Governance, Master Data Management

CITIZENSHIP, EDUCATION, CERTIFICATION, FRAMEWORKS, AUTHORSHIP, and VOLUNTEER

Canadian Citizen

University of Waterloo – Chemical Engineering – Completed April 1998

Member of OSPE (Ontario Society of Professional Engineers)

Project Management – Master’s Certificate – Completed June 2002

SAP Certified Implementation Consultant – Business One 9.0 – Completed March 2014

SOA Casualty Actuarial Society Financial Mathematics Exam FM/2 – Wrote Dec 2017

Zachman Enterprise Architecture Framework – started 2006

TOGAF (The Open Group Architecture Framework) – started 2013

Co-Author zdnet.com/article/bandwidth-the-new-frontier-of-cloud-computing 2015

Datathons:

oData for Good, Calgary Distress Center Calgary 2015

Hackathons:

oHacking Heath, Bringing Innovation to Healthcare Toronto 2013

oEDU App Challenge Calgary 2015

oStart-up Weekend, Powered by Google Entrepreneurs Calgary 2016

oManitoba Open Data Innovation Challenge Winnipeg 2018

oGovernment of Manitoba Open Innovation Challenge Winnipeg 2018

YouTube:

o“How to make friends in Canada” Special Guest

oYouTube.com/watch?v=fx3Gs285uyM Winnipeg 2019



Contact this candidate