Requests
11
0
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Canadian Border Service AgencyData Architect / Modeler
Nov. 2023Ottawa, Ontario, Canada · RemoteProject Description: The purpose of this project was to introduce a new modelling layer to the CBSA overall enterprise model which would better connect the Enterprise Architecture layer to the Project Solution Layer. This layer to be developed was named the Conceptual Model Layer and the purpose is to standardize the individualized nature of each project’s architectural documentation in a way that it can clearly be captured in the Enterprise Model. Tasks Performed: • Perform extensive research on the Enterprise Architecture of CBSA and the tools used to document it. This included learning the strengths and weaknesses of the Enterprise Model. • Perform extensive research on the Data Governance and application and database models which were more at a practical level. Determine how common a language was used to document these models and document the gap between the current state and a future state in which a conceptual model layer could be introduced. • Create artefacts and framework templates for all modeling approaches on the Enterprise Conceptual modeling layer. This included modeling using Entity-Relationship (ER), Functional Modeling and Object-Oriented approaches. • Created a formal criteria and best practices questionnaire used for selecting a modelling approach at the Project Solution and Conceptual Modeling layer. • Provide impact analysis on the current Data Governance areas and generate a roadmap for how to make the transition from Enterprise level Data models to Solution or Conceptual level Data models. Environment: ERwin, DrawIO, MS Visio; Qualiware, SparX EA, SAP Powerdesigner, Oracle Developer Data Modeler; Visual Paradigm, Lucidchart, Vertabelo, Navicat Data Modeler, Aqua Data Studio, Hackolade, ER/Studio, BPwin, Umlet
Investissement QuébecData Architect / Modeler
Nov. 2022 - Nov. 2023Montreal, Quebec, Canada · HybridProject Description: The purpose of this project was to provide guidance to the organization on data governance. Investment Quebec has many disparate databases and data sources all created by different people at different times. The purpose of this role was to standardize the vision of data within the organization as well as standardize their approach to data modeling. Tasks Performed: • Responsible for developing Modeling Diagrams for metadata repositories in support of Data Governance containing data dictionaries, vocabularies and glossaries. • Took on a special project to create data models, following SAP PowerDesigner methodologies and best practices, to provide an accurate picture of the data behind the legacy SYGIC which was developed in-house using Oracle.
• Created a Business Conceptual Model of the existing SYGIC system, based on Object Oriented Approach/Modeling. This Model included Use Case Diagrams and Business Data Classes Diagrams which were created and documented in detail. • Reverse engineered the SYGIC system to generate a Physical Data Model using SAP PowerDesigner 16.7. The legacy system was a collection of 620 tables with no order or documentation. • Primary data source architecture and data modeling from Physical Data Model to Logical Data Model was performed using SAP PowerDesigner 16.7.
• Worked with Oracle for SELECT troubleshooting and reverse engineering of the legacy system. • Utilizing MS Azure DevOps in Agile process mode for planning and project management purposes including creating User Stories and Tasks. • Stored project documents using MS SharePoint. Environment: Oracle, Azure, PowerDesigner, SAP
Health Canada | Santé CanadaData Architect
Dec. 2022 - Mar. 2023Ottawa, Ontario, Canada · RemoteProject Description: Health Canada has modernized the data sources used by and Oracle driven front end application from legacy Oracle to modern MS SQL Server 2019. Because of this migration of data sources, the Oracle application is no longer operational. The purpose of this project was to re-create views in SQL Server to provide the inputs the legacy Oracle application is expecting to get it operational again. Tasks Performed: • Gathered business and technology requirements of the Oracle application and related data source connections. • Performed a detailed analysis and comparison of both the legacy Oracle 10g data model and the new SQL Server 2019 data model to understand and document the differences. • Utilized MS SQL Server to create views of the modernized database which would mimic the legacy Oracle tables and/or views such that they would be usable by ORA.
• Performed physical data modeling with DBeaver
• Created ETL scripts using MS SQL Management Studio to transform data and publish as a SQL view where required by the expected Oracle data sources. • Gathering business requirements Environnent: SQL Server 2019, DBeaver, Oracle 11g
Emploi et Développement social Canada (EDSC) / Employment and Social Development Canada (ESDC)ETL Developer
May. 2021 - Nov. 2022Greater Ottawa Metropolitan AreaProject Description: As ORACLE ETL Consultant, has involved in PL/SQL programing, Data Modeling and support and maintenance activities of the in-house ETL solutions. Tasks Performed:
• Performed analyses of business requirements, existing data models and support and maintenance documentation
• Architected, developed, updated, supported and created the PL/SQL statements/ SP/ packages; • Created and updated project documentation including Data Models as well as Static and Behavior-Based UML diagrams and/or based on ORACLE Modeling approach
• Perform system testing
• Update and Create Documentation within an Agile/Scrum environment. Environment: Windows, UNIX base ORACLE server, ORACLE SQL Developer, Oracle Data Modeler, Erwin, Toad;
Indigenous Services Canada | Services aux Autochtones CanadaData Modeler / Data Warehouse Architect / BI Developer
May. 2019 - Mar. 2021Montreal, Quebec, CanadaProject Description: As lead Data Warehouse Architect and Modeler, data modeled and lead the support, maintenance and development of an in-house Data warehouse was designed to aggregate data from over of 50 data sources spanning the Canadian government and external partners. The data being mined and reported on was health case data relating to ingenious people, a large scale, nationwide, enterprise project. Tasks Performed:
• Performed analyses of business requirements
• Architected, developed, updated, supported and created the Data Warehouse and related Data Marts. This included performing the transition from a Kimball model to a Corporate Data Model (Inmon)
• Created and updated project documentation including Data Models as well as Static and Behavior-Based UML diagrams
• Reverse engineer multiple diverse data models contained in custom in-house systems currently in place at SIA in order to create ETL models and scripts to load the Data Warehouse, Data Marts and Data Lake. • Perform system testing
• Update and Create Documentation within an Agile/Scrum environment. Environment: Windows, MS SQL Server, SSIS/SSRS/SSAS, ORACLE, EA (Sparx Enterprise Architect), TOAD, MS Visio, C#, .Net;
Department of National DefenceDatabase Systems Analysis and Support of LCCS Land Combat and Control System
Sep. 2018 - Dec. 2018Ottawa, Canada AreaProject Description: The purpose of this group was to maintain new release of LCCS - an assembly of custom and COTS applications which were in place to assist the Army with deployment and training exercises. Those system were highly complex and very poorly documented requiring a high level of reverse engineering. Tasks Performed:
• Perform analyses of business requirements
• Create and update Data Models, Static and Behavior based UML diagrams
• Perform Installation and Configuration of database systems and COTS systems
• Reverse engineer data models of COTS and custom systems in place at DND for update and renewal
• Perform System testing
• Update and Create Documentation
Canadian Space Agency | Agence spatiale canadienneDevelopment Team Leader
Jun. 2017 - Jan. 2018Montreal, Canada AreaProject Description: The MPT system is the primary software for specific Mobile Servicing System (MSS) Mission Planning and Support (MPS) tasks and is required to generate the MSS Graphical User Interface (GUI) Configuration Files, Recon File planning products and more specialized documentation for each Recon File development cycle. Tasks Performed: • Analyzed requirements and the existing software solution to understand all change requests and new features required
• Provided leadership to a development team of 2 resources including code review and acceptance testing
• Performed project management tasks including scheduling and prioritization of tickets • Liaised with the client in both English and French to lead the team
• Developed an MS Access based project management tool for tracking project progress.
Department of Justice Canada | Ministère de la Justice du CanadaBI/Data Conversion Specialist
Nov. 2016 - Feb. 2017Ottawa, Canada AreaProject Description: Worked within the enterprise data warehouse and BI solution to support DOJ’s corporate dashboard and ad hoc reporting needs. The primary goals were to increase transparency, accuracy, performance, and long-term maintainability. Tasks Performed: • Performed analyses of business requirements;
• Extracted and transformed MS SQL and Oracle data from primary information systems into the Department of Justice Business Analytics Warehouse and Reporting System using custom developed ETL processes. This task included developing and writing these ETL processes and associated SSIS scripts in order to facilitate data loading from legacy analytics and reporting systems, then the updating, cleanup, and conversion of that data into the newly implemented MS SQL Server based Business Analytics Warehouse and Reporting System;
• Designed Extract Transforming and Load data processes and performed data modeling.
• Performed P-SQL & T-SQL SQL programming
• Developed SSRS reporting and UI forms (C#)/VB design Environment: AGILE/SCRUM, UML, MS SQL, ORACLE, C#, SSRS/SSIS/SSAS
Department of National DefenceApplication Architect
May. 2015 - Sep. 2016Ottawa, Canada AreaProject Description: The AEWSC has developed and maintained several internal software applications. These systems have been found to be outdated and this project consisted of developing a single Business Intelligence solution which would collect and report on all reprogramming and testing of EW systems. The system was developed using an Oracle 9i database with a Microsoft .Net user interface and gathered data from multiple disparate sources. Tasks Performed:
• Analyzed and reverse engineered the existing applications which were largely undocumented.
• Made the recommendation to management to consolidate the applications into a single Business Intelligence system.
• Performed extensive data modeling of the new combined dataset including performing conceptual and logical data modeling.
• Performed all systems analysis, architecture and application development services for the new Business Intelligence projects, architecture and development of the Oracle and .Net based system. • Worked with a team distributed across the country to effectively deliver projects by developing, programming and scripting extensive queries, triggers and stored procedures in SQL in order to manipulate and report on data as needed to produce meaningful results for the Electronic Warfare programming and testing end users. In addition, architected, developed and wrote ETL scripts in order to extract, transform, load and analyze MS Excel workbooks and spreadsheets, Oracle 9i, MS SQL Server and MS Access database data from the Electronics Bus On Line Analysis, the Remote AMES Terminal, the Memory Loader and Verifier, the MDL/UDF Engineering Test Analyzer and other EW systems, then cleaned up and updated this data for conversion into the target Business Intelligence system environment which was being developed to handle all EW testing and reprogramming
NBT-AD (Bulgaria)CEO, Application Architect and Project Manager
Jan. 2003 - Mar. 2015BulgariaProject Description: NBT®BNBREPO is the main product offering of NBT-New Bulgarian Technologies (NBT-AD). It is a Business Intelligence system based upon multiple technologies including MS Access and the MS SQL Server Business Intelligence suite. The system has been architected developed, customized and implemented for multiple banks in Bulgaria and the EU to manage required regulatory financial and banking reports in Bulgaria. The core system is database independent such that, for each client implementation, it is re-developed using that customer’s internal database. The system has been re-developed to run on multiple versions of MS Access, SQL Server, Oracle and DB2. Major clients included INGBANK, CITIBANK, BNP-PARIBAS, ISH BANK, SOCIETE GENERAL, and Raiffeisenbank among others. Tasks Performed: • Performed the systems analysis and application architecture services for the NBT®BNBREPO BI solution, which consisted of 3 modules using the technology already in place for each client including MS Access, SQL Server or Oracle. This included preparing concept of operations documents and determining technical requirements for each installation of the NBT®BNBREPO BI solution and creating the related relational databases for each client. The three modules were:
o Nonstandard Data Collection Module – This module includes the ETL processes which draw the data needed for regulatory reports from the entire information stream of the bank. Customized data conversion, data migration and data quality assurance routines and strategies were created and finalized for each client, in order to meet client needs for the conversion of bank data from legacy systems to the new NBT®BNBREPO BI solution.
o Analysis Module – the accumulated data is processed, formatted and checked for mistakes and discrepancies. o Standard Reporting Module and User Interface – the set of standard required financial reports for any banks, plus the interface with the regulatory institution (BNB).
BAMCOmember of CA
Jan. 2002 - Dec. 2005organize and work with IT consultancy community
ING BANKconsultant
Jan. 1997 - Dec. 2005as Leader of NBT-AD
CITIBANK BulgariaConsultant
Jan. 1997 - Dec. 2005through NBT-AD
BNP Paribas BulgariaConsultant
Jan. 1995 - Dec. 2005as Leader of NBT-AD
Pireous Bank BulgariaConsultant
Jan. 1993 - Dec. 2005through NBT-AD
UBBBISERA consultant
Jan. 1998 - Dec. 2000Developed and implemented custom application for interface between KAPITY and BISERA
Stopanska Banka 1995consultant
Jan. 1990 - Dec. 1993Developed full functionality Banking Information System on C with b-tree based own database. Implemented in 14 branches. 1995 develop a BIS on MS Access 2.00, Not implemented
Intch is a Professional Networking App for the Future of WorkSee more people like Plamen on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
163467 people
18
Inventory Analyst @ Lowe's Home Improvement
18
Software developper
17
Business & Marketing Consultant @ Kate Wratten & Co.
24290 people
18
Inventory Analyst @ Lowe's Home Improvement
18
Service Desk Technician @ Stewart Title
15
Data Analyst/Digital Marketing Startegist