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
- 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
-
- 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
-
- Indigena BPMN Diagrams
- Utilized Microsoft Visio to create the Business Process Model Diagrams according with all process flow
-
- 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
