Data Architect

Professional Summary

**+ years as an Data Architect

9+ years as BI end-to-end Solution Architect

20+ years of experience as Database Administrator/DB Developer/ in diverse environments

Extensive experience in data modeling (conceptual, logical and physical) in DW and OLTP environments

Expert in MS SQL Server technologies: DB, SSIS, SSAS, SSRS, Power BI

Technical Summary

Software MS SQL full stack (DB, SSIS, SSRS, SSAS, PowerBI), Oracle, SharePoint, Tableau

Languages T-SQL, PL/SQL, Python

Project Management Tools MS Project, Jira, Confluence, Gantt charts

Databases AWS Redshift, MS SQL (v.7-v.2019), Oracle (v.8,1 – v.9.2), MySQL(v.5.1)

Data Modeling tools CA Erwin, Embarcadero ERStudio, Sybase PowerDesigner, Sparx EA

Hardware PC, Cloud (AWS, Azure), Mainframe

Applications BI solutions, DQ framework, SharePoint based applications

Industries Finance, Mining, Education, Health care, Aero space, Gaming, Marketing and research

Operating Systems Windows (v.2000 – v.2016), Linux Ubuntu v.11

Methodologies Waterfall, Agile, Scrum, Hybrid, Fujitsu Macroscope

Professional Experience

Coast Capita Savings Surrey, BC December 2019 - present

Coast Capita Savings is a member owned financial co-operative federal credit union. Enterprise Architecture team consists of 20+ solution, application, network, cloud and data architects responsible for major innovations and initiatives.

Enterprise Data Architect

Project: SkyNet, TSP

SkyNet is a new generation of Enterprise Data Warehouse and Data Lake, which supports new cloud based platform and id a source for all future analytics and AI/ML initiatives, based on Inmon methodology.

TSP (Technology Service Partner) is a role which I have as technology liaison between Enterprise Architecture and Product and Marketing departments.

Technology used: AWS (Redshift, S3, Athena), Sparx Enterprise Architect

Wenco International Mining Systems Richmond, BC July 2018 – December 2019

Senior Architect - Analytics

Wenco International Mining Systems, Ltd. is a Canadian technology company that develops, manufactures, and distributes computer systems to manage and control surface mining equipment. It is a provider of fleet management and machine guidance technology to the mining sector.

Project: AVOCA

Avoca is the analytics platform for today’s mining industry. It connects the dots among all mining data so user can explore it the way it has always wanted. All mine’s software comes together in Avoca. Mine planning, fleet management, plant control, productivity maps, KPIs. Avoca blends all these systems’ data in a ways to create interactive dashboards with charts, maps, and diagrams.

Logical/Physical Data Modeling (design, reverse engineering, validation, implementation) and DB maintenance for Data Warehouse

Develop ETL using MS SQL SSIS

Prepare and create Data extracts using Tableau Server

Create deployable packages for end users environments

Information flow and data mapping documentation

Technologies used: MS SQL Server v.2016(DB, SSIS), Tableau Sever v.2018- 2019, E/R Studio v.9, Power BI, Python v.3.7, C#

Industry Training Authority Richmond, BC May 2015 – June 2018

Manager DW & BI

ITA is a Crown Corporation that leads and coordinates B.C.’s skilled trades system by working with employers, employees, industry, labor, training providers and government to issue credentials, manage apprenticeships, set program standards and increase opportunities in the trades.

Project: ITA’s Business Intelligence Platform

ITA’s Business Intelligence Platform is comprehensive reporting system which provides all organizational KPIs, key reports and delivers ad-hoc information to all parties.

In collaboration with stakeholders, strategic planning, architecture, design and implementation for Enterprise Data Warehouse and BI solutions

Chairing BIG (Business Intelligence Group – Corporate BI Excellency Center) and coordinating efforts to achieve MDM and Data Governance goals

ETL process design and development (MS SSIS)

Initial and ongoing DW DB data modeling (logical, physical)

Technologies used: MS Windows v.2012, MS SQL Server v.2016 (DB, SSIS, SSRS), Power BI, MS Dynamics CRM v.2015, SharePoint v.2016, Erwin v.9.2

PHSA - Provincial Health Service Authorities Burnaby, BC September 2011 – May 2015

Senior Database Analyst

Provincial Health Services Authority is a publicly funded health service provider in the province of British Columbia. Other health authorities in the province have a regional jurisdiction. PHSA is unique in Canada as the only health authority having a province-wide mandate for specialized health services.

Projects: Provincial Occupational Health BI platform, WHITE, WMO

WHITE is web-based system that centralizes information on incident tracking and case management for the BC health authorities. WMO is analytical/reporting system based on WHITE data, used by all Heath Authorities in BC.

BI team lead

Reporting system architecture and authoring (SSRS & SP in integrated mode with Kerberos authentication over multiple ADs)

ETL process design and maintenance (stored procedures, MS SSIS)

Data Quality Framework design and implementation

DW DB modeling, maintenance and implementation (Kimball)

MS SQL Transactional replication over multiple ADs

Technologies used: MS SQL Server v.2008 - 2012, Visual Studio v. 2008, Share Point v.2010, Erwin v.9, Tableau v.8-9

Electronic Arts (EA) Burnaby, BC Aug 2010 – Sept 2011

Data Architect

Electronic Arts is a world leader in gaming industry.

Project: EBISU, later known as Origin

Origin is online gaming, digital distribution and digital rights management platform.

Conceptual, logical and physical DB modeling for new applications (OLTP and DW)

DB programming (stored procedures, functions, triggers)

DB performance tuning and optimization (SQL profiling)

ETL process design

Baseline development standards

Disaster recovery plan, data retention and archiving plan

Maintain data dictionary

Technologies used: AWS, MS Windows 2008R2, Linux Ubuntu v.11, Oracle 11g, MS SQL Server 2008, MySQL 5.1, Apache Cassandra (NoSQL), Pentaho BI Server (Spoon, Kettle, Weka)

Vision Critical Vancouver, BC Dec 2009 – Aug 2010

DBA

Vision Critical is online research company which combines interactive technology, strategic research and panel expertise.

Projects:

SPARQ: powerful survey based platform, which collects customers’ insights

Firefly: enhanced web-based research tool, enabling customers to conduct holistic research

Rhino: 2nd generation of survey tools, based on new MS .NET platform

Phoenix: BI solution which integrates SPARQ, Firefly, Rhino

Regular ongoing DB maintenance and administration on production servers in cluster environment

Physical DB modeling for existing and new applications

DB programming (stored procedures, functions, triggers)

DB performance tuning and optimization

MSIS and MSAS packages/jobs design and maintenance

Author of internal DB development standards and DB disaster recovery strategy

DB documentation

Technologies used: MS Windows v.2008, MS SQL Server v.2005,2008 in cluster environment, Oracle 11g, Oracle RAC, Linux, .NET 3.5, ERWin 7.2

Certifications and Training

UBC Sauder – Executive Education Program 2015-2017

Multiple TDWI courses 2008-2018

Education

University of Belgrade, Yugoslavia 1993

Faculty of Management Science

B.Sc. in Computer Science and Business Administration

References

Available upon request

Marinko Pasic

101-7495 Sandborne Ave.

Burnaby, BC V3N 4V4

Phone: 604-***-****

Email: *************@*****.***

Contact this candidate