Javier Barreto

Experienced Engineer with wide knowledge and Key skillsets in SQL-based systems development, architecting, configuration, analysis, and maintenance while ensuring cost-effective execution, Led a group of Database Administrator/developer, QA and tester for different projects related with all type of databases’ Data Migration, Data Reconciliation, Data Clean and QA with 20+ years of proven success in relational database systems management for notable corporate entities.

Notable systems experience:

• Led different groups through my career executing projects for diversity of companies which include mines, Corporation, banks, Construction, Insurances, Communications, tourism, Sciences, retail and other.
• Execute data Migration, data transformation and data Reconciliation for big corporates like Stemcell technologies, Teck Resources, GeoPacif, Concert Properties, Surewerx, ICBC, Telus, Vancity, Rocky Mountaineer, RCABC and Loblaw companies using SSIS, Grid Tools, Oracle Loader, SQL load.

Data Integration Specialist                                                                                                                               Vancouver, BC

Concert Properties                                                                                                                                             October 2022 – Today

• Provide technical expertise in resolving a variety of complex problems and issues related to data transformation, verification, migration, integration and analysis
• Support users for different applications like Yardi, VTS, HR, Payroll, P2P, Kofax, Account Payable, Payments, Invoices, Yardi Senior and Ceridian.
• Led the project for migration and Upgrade FROM SQL SERVER 2014 TO SQL SERVER 2019 and Azure  Cloud
• Maintenance of different reports using Crystal Report and SSRS.
• Create linked services between Yardi (different servers) and SQL server database.
• Generate synonyms for different databases to create process with ETL between different sources and target.
• Create and maintenance ETL processes between Azure Data Factory and different apps (Yardi, VTS, etc)
• Create logic app for ADF containers
• Upgrade SQL SERVER from SQL 2014 to 2019 and to AZURE Data Factory
• Data Storage for Azure and develop ETL process Using ADF
• Create Pipelines for Azure Data Factory
• Clean up database in SQL server
• Managing on-premise Data Warehouse for different dashboard and reports
• Developed with Visual Studio different ETL process
• Using SSIS for data Analytics
• Create Manual for all the process at Concert Properties
• Migrate data from different sources to SQL SERVER using tools like DMA (Data Migration Assistant)
• Add, modify and delete users on SharePoint for different structures at Concert.

Senior Data Engineer                                                                                                                                         Vancouver, BC

Stemcell                                                                                                                                                                March 2021 – May 2022

• Provide technical expertise in resolving a variety of complex problems and issues related to data transformation, verification, migration, integration and analysis
• Support stakeholder in use the BI tools under SAP environment 
• Generate and developed reports and dashboard using Power BI
• Work with power BI DataMart and dataflow
• On-premise data warehouse maintenance
• Extract, transform y Load data from different sources (PDD, SQL Server, Access Database, excel sheets and Google sheets) into the PLM environment (SAP)
• Extract data from different table of SAP, TRANSFORM it and LOAD into PLM
• Created Risk assessment for PLM Migration Project
• Created User Guide Migration to PLM, document that get all steps on the migration.
• Used different tools for ETL between SAP environment, Google sheets, excel, SQL Server and Access to PLM – SAP
• Import and Export data through Azure to SNOWFLAKE and DBT databases from different sources
• Worked under AWS
• Took training in snowflake and DBT

Data Transformation / Data Migration / DBA                                                                                              Coquitlan, BC

SureWerx                                                                                                                                                              July 2020 – Feb 2021

• Provide technical expertise in resolving a variety of complex problems and issues related to data transformation, verification, migration, integration and analysis
• Validate and compile data from different sources to SQL server 2016 environment
• Transform more the 10000 products with different subcategories to load into the InRiver App
• Create queries to update and transform data using SSIS
• Generate and developed reports and dashboard using Power BI, Generate business report
• Do ETL processes for different categories and tools Import from Azure databases
• Work with power BI DataMart and dataflow
• Export data for different SKUs to the new format in the PIM project
• On-premise data warehouse maintenance
• Generate and load data according with the business rules into the new database structure.
• QA more that 10000 products and made exception values to be fixed into the new system
• Work online using FortiClient VPN
• Do Backups for different databases, upgrade database to 2019
• Participate in the scrum

Business Data Analyst                                                                                                                                        Vancouver, BC

International Institute of Business Analysis                                                                                                  Nov 2019 – March 2021

• Meets on monthly basis with members of International Institute of Business Analysis for SQL and Analytics skill development

Test Data Management / Data Migration                                                                                                     North Vancouver, BC

ICBC                                                                                                                                                                        Feb.– Jun. 2019

• Created queries using Oracle developer, DB2 (Squirrel) to validate all processes between sources and BI reports
• Designed and executed test cases for the claim center, executive, exception, and operational reports in Jira
• Generated data mapping for different reports 
• Developed Data Model for the tableau dashboard
• Created new data definition language 
• Validate and compile  data from sources to staging through to Tableau report and dashboard development
• Analyze claims, crash, vehicle, stats and interpreted results for the transformation rules
• Transformed Data from Claim Centre Oracle and DB2 databases
• Provide technical expertise in resolving a variety of complex problems and issues related to data transformation, verification, migration, integration and analysis
• Loaded Data into pre-production environment
• Imported/Exported Data from Oracle and DB2 Databases in staging environments and later into to testing and pre-production environments, Import and Export data from Azure databases
• Analyze with the team in the scrum about any rock block in the development

Database Administrator (DBA) / Data Cleansing                                                                                         Langley, BC

Roofing Contractors Association of British Columbia                                                                                 Dec. 2018 – Feb.2019

• Gathered and processed information from stakeholders
• Developed data models and DDL for CRM 
• Evaluated and analyzed data in order to clean it
• Created reports for actives and inactive customers using SSRS
• As a DBA, created queries and Stored Procedures to eliminate duplication in the SQL Server Database
• Working with Microsoft Dynamics 365
• Cleaned and standardized duplication for Guarantee, Cities, Street addresses and Phone for customer profiles

Data Migration / ETL Development Specialist                                                                                              Vancouver, BC

GeoPacific Consultants Ltd.                                                                                                                              Nov. – Dec. 2018

• Categorically gathered and processed end-user information
• Extracted and analyzed data from QuickBooks
• Made the DDL for the new environment 
• Transformed data in accordance to business formats and guidelines
• Loaded data to Sage 50 Database
• Used SSAS to ETL development
• Create queries with SQL on QuickBook and Sage50
• Imported/Exported data from QuickBooks To Sage50 using data loader and ETL processes
• Migrated data for Customer, Inventory, Personnel, timesheet and other to Sage50

Data Integrator / ETL Developer / Data Migration / DBA – Team Lead                                                 Vancouver, BC

Rocky Mountaineer                                                                                                                                            Nov. 2017 – Oct. 2018

• Participated in the creation of dashboards for different report through the company using Tableau and Power BI reports
• Evaluated, analyzed and integrated data from SQL Server databases, Travel studio, Drupal, and Marketo to identifies changes need by Rocky Mountaineer in the Integration plan.
• Developed ETL process for IAM (Identification Management) project from Agencies, Agents, Guest, Passengers to different objects at Salesforce (Account, Contact, Lead, Booking, Account groups)
• Created DDL and data models for all sources into the new Salesforces environment
• Created data mapping from different sources (Travel studio, Drupal and Marketo) to Salesforce as target
• Created a comprehensive user-guide to critically analyze all Rocky Mountaineer datasets
• Provide technical expertise in resolving a variety of complex problems and issues related to data transformation, verification, migration, integration and analysis
• Guide was merged with RM stakeholder data management documents and helped established models for the actual state of the RM before key data migration
• Test Leader for multiple projects including smoke testing, functional testing, unit testing, and QA
• Created and execute Test Cases for GDC, IAM Projects
• Developed the technical guide for IAM ETL process
• Gathering Information from Marketo, Marketing Dash board, Salesforce working different projects for CRM and Identification management
• Developed apps in Python for executive dashboard
• Worked with Jira, Confluence and Trello
• Created physical and logical data model for ODS, Cognos reports and different projects with RM
• DBA administrator for production, staging, development and test environment in 202 servers at Rocky Mountaineer, with SQL server and Azure databases
• Monitored all databases and supported troubleshooting
• Installed databases and monitoring performance for Azure cloud
• Created and maintained replication and clustering for different SQL servers and Azure databases
• Created queries with SQL server 2012, 2016 and 2017
• Imported/exported Salesforce data using data loader and ETL processes
• Coach and advice co-workers in different aspects of the full life cycle for ETL processes
• Create IAM Manual user guide

DBA Team Lead / Management Associate                                                                                                    Delta, BC

Indigena Solutions LP - Accenture                                                                                                                   Nov. 2012 – Apr.  2017

1. General Overview

• Led a group of 18 Database Administrator/developer, QA and tester for different projects related with all type of databases (SQL Server, Oracle PL/SQL, MySQL)
• Created DDL for different projects and developed data models for those
• Generated solution for all projects as DBA
• Worked with Agile methodologies, being the scrum master for different teams and projects
• Created User Guide for Migrate from CRM to IMT – 2016
• Installed and updates different databases and packages like SAP Basis, MaxDB, Sap BI, Linux for AP Netweaver 7.3 and SQL Server 2008 R2, 2012, 2014
• Worked with DataStage for ETL Processes

1.  
2. Indigena Network Security

• Made Indigena’s network security and created control structures according with Indigena structure using Active Directory, mapping to File server, DNS, and print servers under Windows Server 2008 R2
• Created sub-users and groups as part of a Penetration Testing plan for Indigena
• Created test cases UAT for penetration test and security
• Responsible for Indigena’s network security

1.  
2. Indigena BPMN Diagrams

• Utilized Microsoft Visio to create the Business Process Model Diagrams according with all process flow

1.  
2. Indigena Evaluation – Indigena Business Orientation

• Led a group of 7 IT people to determine how Indigena will be in business for future years through application outsourcing
• Created the roadmap from January 2014 and recognized where solidity in knowledge, personnel and tools
• Searched every option and used evaluation criteria to generate the best option(s) for Indigena business
• Evaluated hardware, software, and tools involved in a full life cycle from scratch through to the deployment of an application

Quality Assurance / Data Reconciliation / Business Intelligence Specialist                                           Vancouver, BC

Teck Resources Limited                                                                                                                                     Jun. 2016 – Nov. 2016

• Created scripts for Import and Export those apps using SQL server 2012, 2014, 2016 and Oracle
• Worked with Data Reconciliation, DBA, Data Analysis, Database developers and Test Teams
• Created DDL for users at the mines
• Reconciled Apps of the Dashboard, verified Stored procedure for Incidents apps
• Generated SQL queries to increase the performance of the analyzes working with SQL server 2014 and 2016
• Analyzed all applications with QA, BSA, DBA and developers
• Worked with TFS Team Foundation server 2013, created test cases, bugs, defects for each product
• Suggested tool to implemented and analyzed the data reconciliation
• Reviewed all configuration, fields and format of all product
• Created and generated defects/bugs report to improve the migration of the data for each product

Images Project - Team Lead                                                                                                                             Vancouver, BC

Seaspan Corporation                                                                                                                                          Feb. 2016 – Jun. 2016

• Installed, configured, and setup for Images using WDS, ADK, MDT, DHCP and Hyper-V
• Created a model and guide on how to install, update and modify images using different tools from Microsoft
• Suggested tools to implement and analyze the creation of the images 
• Delivered the images and refreshed PCs to current Seaspan staff

Data Reconciliation Data Migration - Team Lead                                                                                        Vancouver, BC

Vancity Savings Credit Union                                                                                                                           April 2015 – Dec 2015

• Integrated the data from RFS sources to new system T24
• Created DDL and generated ER Data Models and Dimensional models for data and report projects
• Reviewed all configuration, fields and format of all product
• Led the data reconciliation approach for all of the Vancity – BAR project
• Generated and change SQL queries and Store Procedures to increase the performance of the analyses using SQL server 2012, 2014 
• Worked with DM (Data Migration), Data Reconciliation, QA, Data Analysis and Test Teams
• Reconciled 9 Domains of the Data Migration for BAR (Banking application renewal) project
• Analyzed all applications with QA, BSA and DBA, developers and data migration teams
• Work with Agile methodologies, conducting scrum for the team and managers
• Worked with (TFS) Team Foundation Server 2013, creating test cases for bugs and defects in each product
• Successfully suggested software tools to implement and analyze the data reconciliation
• Created scripts and reviewed all configuration, fields and format for all products
• Created The Manual “APPROACH TO RECONCILE DATA MIGRATION” and using it as guide of all reconciliation at Vancity
• Created templates to use as a tool in the data reconciliation such as ‘RISK ASSESSMENT’, ‘SCOPE DOCUMENT’, ‘CONTROL REPORT’ and 'FIELD TO FIELD REPORT' for each of the 128 products
• Created and generated defects/bugs report; using it as a tool to improve the migration of the data for each product

Bachelor Information system and Computer Engineering Universidad Nacional of Colombia