Profile
Energetic, accountable and results-driven individual with 15+ years of DataWarehousing and ETL experience with a track record for continuous career growth and progression. Exceptional understanding and practical experience with BI/DW concepts and methodologies including business requirements, data analysis, dimensional data modeling, BI solution design and testing strategies. This is demonstrated in over 25 BI/DW and Operational projects experience with no project failure.
Experience Summary
20+ years practical expertise in all System Development Life Cycles in telecommunication, financial, media, manufacturing, etc.
15+ years of Data Warehouse and Business Intelligence experience
20+ years of Oracle database experience
6+ years Microstrategy Design, Architecting and Development of BI Solutions
15+ years of experience with ETL Tools
20+ years Data Architecting/Data Modeling for Enterprise and Data Warehouse
25+ projects experienced as team member, team lead, project manager
20+ years experience using SQL, PL/SQL, T_SQL, Programming Languages and Methodologies
10+ years experience in mentoring, training and team leading
15+ years experience in Business management and requirements elicitation
3+ years Big Data Modeling and architecting( Hadoop, Cassandra, Hive, Scoop, Pig, Impala,Spark, Kafka,etc.)
Intensive experience in waterfall, spiral and agile project development methodologies
Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation
Technical Skills
Technologies Microstrategy, Microsoft SSIS/SSAS, OLTP, OLAP, ORACLE BI
BI/ETL Tools Pentaho, Talend Data Integration( Opens Studio), SSIS, SSRS, SSAS, Power Loader, Datastage
Databases Oracle, MS SQL Server, Sybase, DB2,MySQL, PostgreSQL, Visual FoxPro, FoxPro, Dbase, MS-Access, ORACLE Designer, Oracle Developer
Big Data Hadoop, Cloudera, HortonWorks, Cassandra, Hive, Spark, Impala, Pig, Scoop, Kafka, Solr,etc.
Data Modeling Tool Erwin,Toad, Power Architect, Embarcadero ER/studio, Power Designer, PL/SQL Developer, Hora, DQ-Guru, Wabit, Power Loader
Languages SQL, PL/SQL, T-SQL, HiveQL,SparkSql, K Sql, JavaScript, Java, ASP.NET, VB, C#, HTML, COBOL,
Unix shell script programming
Operating Systems Windows, UNIX, MS DOS, RSX
Productivity Tools MS Office, VISIO, MS Project, Open WorkBench
Defect Tracking Tools HP Quality Center 10.00, Assembla, JIRA, Git
Methodologies CDM, AIM, XBRL, XML, SOA, TOGAF, UML, OOP
Education
Bachelor’s Degree in Mathematics and Computer Science
Training & Certifications
Executive Data Science
- A Crash Course in Data Science by Johns Hopkins University on Coursera(Nov 2015)
- Building a Data Science Team by Johns Hopkins University on Coursera(Nov 2015)
- Managing Data Analysis by Johns Hopkins University on Coursera( Dec 2015)
- Data Science in Real Life by Johns Hopkins University on Coursera(Dec 2015)
The Data Scientist’s Toolbox – John Hopkins University by Coursera(2014)
Advanced Data Warehousing, Microstrategy(2011)
Advanced Project Design, Microstrategy (2011)
Advanced Reporting, Microstrategy (2011)
Administration: Configuration and Security, Microstrategy (2011)
Project Design Essentials, Microstrategy (2011)
Report Services: Document Essentials, Microstrategy (2011)
Report Services: Dynamic Dashboards, Microstrategy (2011)
Building Analytic Solutions using Pentaho, PENTAHO and SQLPOWER GROUP Inc.(2007)
Operational Business Intelligence using Pentaho, PENTAHO(2007)
Effective Project Management Program, CENTENNIAL COLLEGE TORONTO (2006-2007)
Oracle Designer 6i-Server Design and Generation, Forms Design and, ORACLE (2001)
Generation, Forms Developer Built Internet Applications, ORACLE(2001)
Oracle 8i Performance Tuning, ORACLE(2001)
Personal Strategies and Principles for Navigating through Change, ACHIEVE GLOBAL, USA(2000)
Oracle - SQL, PL/SQL, Business Modeling Techniques, ORACLE (1997)
Designer/2000- Systems Modeling, Databases Design, ORACLE(1997)
Applications Design, Applications Generations, ORACLE (1997)
MICROSTRATEGY CERTIFIED PROJECT DESIGNER v 9.2.1 - 2012
MICROSTRATEGY CERTIFIED DOCUMENT DEVELOPER v 9.0.1 - 2012
Work Experience
Data Engineer/Data Architect
Bell Canada September 2017-June 2018
Network Big Data Centre of Excellence (NBiG COE)
Project: CAL – Customer Asset List
Leading and performed Data Analysis/ Data discovery process involving CMS, MOI, dHCP and BEDW databases.
Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
Designed data model according with High Level Design, Change Requests, Intakes Documents
Designed and Developed Solution design
Designed PDM ( Physical Data Model) and STM ( Source to Target) Documents
Capture technical metadata through data modeling tools
Designed and developed scripts for generating Consumer tables/files
Participated in JAD sessions involving the discussion of various Consumers needs
Technical Environment: Hadoop, Cloudera, Hive, Impala, HiveQL, SparkSql,ORACLE
Project: Real-Time Intelligence and Network Analytics
Performed Data Analysis/ Data discovery process involving NETS, ITSP and IRS systems.
Designed data model according with High Level Design, Change Requests, Intakes Documents
Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
Cube Design and definition for IPTV Availability Head-End/ IPTV Availability Distribution Central and Atlantic.
Designed and completed STM ( Source to Target) Documents
Capture technical metadata through data modeling tools
Designed and Developed Automatic Capture data procedure for Customer Impact
Designed and Developed Unit Test and Audit procedure for Data Capture and Dashboard Display
Participated in JAD sessions involving the discussion of various Consumers needs
Technical Environment: Hadoop,Cloudera, Hive, HiveQL,Impala, ORACLE, SQL SERVER,Python,Microstrategy
Data Engineer/Data Architect
Sunlife Financial October 2016-May 2017
Data & Business Intelligence Services (DBIS)
Application Operations & Services (AOS)
Project: Data Lake
Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise datastores within a metadata repository.
Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
Designed data models for Data Lake according with High Level Design, Change Requests, Intakes Documents
Designed PDM ( Physical Data Model) and STM ( Source to Target) Documents
Capture technical metadata through data modeling tools
Designed and developed Consumers views
Participated in JAD sessions involving the discussion of various Consumers needs
Technical Environment: Hadoop, Hortonworks, Hive, Scoop, HiveQL, ORACLE, SQL SERVER,DB2, UNIX, Power Designer, Informatica BDE
Project: LICAT ODS
Designed data models for LICAT ODS according with High Level Design, Change Requests, Intakes Documents
Designed Conceptual Data Model, PDM ( Physical Data Model) and STM ( Source to Target) Documents
Designed a DataPoint architecture POC for LICAT ODS
Developed Consolidated Model for ODS
Technical Environment: SQL SERVER, Power Designer, Informatica BDE
Projects: LICAT MSR( Mortgage DM, Real Estate DM, Derivatives DM, PFI DM, Marketable Securities, Gear DW)-
LICAT Implementation into data marts, CRS, AntiFraud, ELITE, Mortgage DM Cashflow Implement
Designed data models for Data Marts according with High Level Design and Requirement Documents
Designed PDM ( Physical Data Model) and STM ( Source to Target) Documents
Capture technical metadata through data modeling tools
Updated Data Model Library
Provided technical assistance to BI/ETL team in implementation models
Technical Environment, ORACLE, SQL SERVER, DB2, Power Designer
Project: JIRA Tickets-Ad-hoc changes in Models to accommodate new requirements
Projects Estimation - Estimated resources for new projects from Data Engineering perspective ( L0,L1,L2)
Data Catalogue - Designed and developed Power Designer metadata extraction procedures
- Stored metadata into catalogue and consolidate them versus physical databases.
C360 Data Model - Designed and developed subject views for consumers
Data Modeler/Architect
CIBC Corporate Centre Technology – EDH September 2015-August 2016
Project: Enterprise Data Hub
Designed data models for Enterprise Data Hub according with High Level Design, Change Requests, Intakes Documents
Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise datastores within a metadata repository.
Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
Participated in JAD sessions involving the discussion of various Consumers needs.
Produced initial iterations of an Enterprise Logical Data Model for the Consumer domain, enabling gap analysis.
Provided Solution design for Informatica BDE Developers
Designed and Architected data governance solution for EDH zones
Designed PDM ( Physical Data Model) and STM ( Source to Target) Documents
Developed ServiceNow Model for EDH ingestion architecture
Liaise with Business/Source team and development to ensure data feeds are proper in EDH
Solution Designing for new in-takes and involving in retrofitting data models
Creating Erwin data models and implement architecture for ETL data Load, Meta data and Error Handling Framework
Create metadata management program with business and technical definitions, data lineage, life cycle, identify authoritative (golden) source, owner, etc., using Scrum Agile techniques
Assisted QA teams in testing processes and procedures
Conduct data model reviews with project team members
Capture technical metadata through data modeling tools
Develop proof-of-concept business and technical solutions for data governance usingTalend tools
Create data objects (DDL).
Mentoring and tutoring juniors data modelers
Technical Environment: Hadoop, Cloudera, Hive, Scoop, HiveQL, COBOL( CopyBooks), ORACLE, SQL SERVER, AS400-IBM Mainframe Files, UNIX, ERWIN, Talend, Informatica BDE
Lead Data Architect March 2015 – June 2015
Explore Data Prognosis, Markham
Client: Beverage importers – Sales Analytics Project
Gathered Business Requirements( High Level BRDs, Functional Specification, Architectural,etc.).
Completed gathering and analysis of reporting solution requirements
Performed Data Sources Profiling and Analysis.
Designed and performed Data Profiling/ Data Cleansing procedures of source systems.
Architected and designed Data Marts, Landing zone, Staging, ETL and Workflow processes.
Provided Source to Target Mappings specifications.
Provided requirement analysis, time estimates, functional specification, design, development, testing for Data Integration process.
Provided ETL architecture, framework and managing scope.
Designed and developed CDC ( Change Data Capture) procedures.
Documented business requirements, functional requirements and conducted source data analysis and solution design.
Performed detail documentation of design, development and deployment.
Lead Architecting and data integration team members to achieve success in design, development and deployment activities.
Coordinated and delivered application development related activities.
Involving and managing change requests/enhancements.
Interacted with core team members, end users & other team members.
Technical Environment: SQL Server 2012, MySQL, Embarcadero ER/Studio, Talent Data Integration,
SSIS, SSAS, Pentaho, Microstrategy Analytics, Tableau, Pentaho Analytics
Data Integration Lead Architect/developer May 2014 – February 2015
L&T Infotech, Mississauga
Client: FUNDSERV Inc. Toronto – FUNDSERV BI/DW Project
Worked closely with enterprise/data architects on Data Vault Architecture Design(datawarehouse).
Make recommendations for the design and development of the data layer while contributing to system architecture.
Provided requirement analysis, time estimates, functional specification, design, development, testing for Data Integration process.
Provided ETL architecture, gathering requirements, designed ETL processes, workflows, framework and managing scope.
Provided Source to Target Mappings specifications.
Designed Staging Architecture.
Designed and developed CDC ( Change Data Capture) procedures.
Documented business requirements, functional requirements and conducted source data analysis and solution design.
Performed detail documentation of design, development and deployment.
Lead data integration team members to achieve success in design, development and deployment activities.
Coordinated and delivered application development related activities.
Provided recommendations on performance enhancements in pre-production and production environments
Developed jobs for one Subject Area( 36 jobs)
Involving and managing change requests/enhancements.
Provided updates of project status to Project Manager.
Interacted with core team members, end users & other team members.
Technical Environment: ORACLE 12g, Microstrategy 9.3.1, Embarcadero ER/Studio, Talent Data Integration
Senior DW/BI Architect Jan 2013 – April 2014
SQLPOWER Group Inc, Toronto
Client: Toronto Real Estate Board – Treb BI Reporting Project
Gathered Business Requirements( High Level BRDs, Functional Specification, Architectural,etc.).
Completed gathering and analysis of reporting solution requirements
Performed Data Sources Profiling and Analysis.
Designed and performed Data Profiling/ Data Cleansing procedures of source systems.
Architected designed Data Marts, Staging, ETL and Workflow processes.
Provided Source to Target Mappings specifications.
Defined Star schema and staging databases enhancements.
Developed, maintained and deployed ETL processes for loading staging area and analytics data-mart.
Document analysis for each Business Intelligence subject area.
Reviewed design, technical, code and issue tracker documents.
Developing and managing the change requests/Enhancements.
Monitoring processes performance, disk space, memory usage.
Designed and developed BI Architecture, cubes, facts, attributes, metrics, filters,
prompts, reports, documents and dashboards.
Assisted with and defined System/Integration/Regression Testing, Client Acceptance Testing.
Provided updates of project status to Project Manager.
Interacted with core team members, various business sponsors and stakeholders.
Technical Environment: MS SQLServer 2008, Microstrategy 9.3.1, Power Architect, ERWin, Talent QC, JIRA,
Pentaho 4.4, SSIS, C#
Senior DW/BI Architect June 2011 – April 2014
SQLPOWER Group Inc, Toronto
Client: DICO Canada – XBRL Analytics
Gathered Business Requirements, functional requirements, workflows.
Performed Data Sources Profiling and Analysis.
Designed functional and conceptual/logical/physical data models
Designed and performed Data Profiling/ Data Cleansing procedures of source systems.
Provided Source to Target Mappings specifications
Developed, maintained and deployed ETL processes for loading analytics data-mart.
Redesigned and developed part of ETL Processes with 200% increase of performances.
Redesigned, developed analytics data-mart for XBRL components.
Designed and developed BI Architecture, cubes, facts, attributes, metrics, filters,
prompts, reports, documents and dashboards.
Designed and developed backup and recovery strategy and procedures.
Designed, developed and implemented processes monitoring system.
Monitoring processes performance, disk space, memory usage.
Provided updates of project status to Project Manager.
Interacted with core team members, various business sponsors and stakeholders.
Involving and managing change requests/enhancements.
Unit testing and integration testing review.
Technical Environment: Oracle 11g, J2EE, Tomcat, Power Loader, Pentaho, Microstrategy 9.3, ERWin, JIRA
Senior DW/BI Architect Jan 2012 – Dec 2012
SQLPOWER Group Inc, Toronto
Client: CBS Seychelles Islands – XBRL Analytics
Gathered Business Requirements, functional requirements, workflows.
Performed Data Sources Profiling and Analysis.
Designed functional and conceptual/logical/physical data models.
Completed gathering and analysis of reporting solution requirements
Designed and performed Data Profiling/ Data Cleansing procedures of source systems.
Provided Source to Target Mappings specifications
Developed, maintained and deployed ETL processes for loading analytics data-mart.
Designed, developed analytics data-mart for XBRL components.
Designed and developed BI Architecture, cubes, facts, attributes, metrics, filters,
prompts, reports, documents and dashboards.
Mantained Microstrategy Metadata.
Provided updates of project status to Project Manager .
Interacted with core team members, various business sponsors and stakeholders.
Involving and managing change requests/enhancements.
Unit testing and integration testing review.
Technical Environment: Oracle 11g, J2EE, Tomcat, Power Loader, Pentaho, Microstrategy 9.3, ERWin, Assembla
Senior DW/BI Architect /ETL Developer May 2004 – June 2011
SQLPOWER Group Inc, Toronto
Client: CTV GlobeMedia Toronto – Data Migration/Integration
Migrated 12 Tv channels data from 5 independent ERP applications on ORACLE and SYBASE into new ERP system( IBMS – Pilat Media U.K.).
Analyzed legacy systems, workflows, business processes, architectures and business requirements.
Designed functional and conceptual/logical/physical data models for Staging and Audit System(Data Mart).
Defined system flows, technical specifications, assembled non-functional requirements.
Designed and implemented profiling and data cleansing procedures.
Provided Source to Target Mappings specifications
Designed staging architecture and ETL interfaces (over 180).
Designed and developed alternative integration solution in Pentaho to accelerate loading process.
Developed post-production reconciliation strategies, Q/A test scenarios.
Designed, developed audit subsystem, building a data-mart, based on main KPI’s for each functional area and related metrics, for legacy systems and new system and analyzed with dashboard system developed with Pentaho and Power*Dashboard.
Provided updates of project status to Project Manager.
Interacted with core team members, various business sponsors and stakeholders.
Involving and managing change requests/enhancements.
Unit testing and integration testing review.
Technical Environment: Oracle 11g, SYBASE, SServer, dBASE, Power Loader, Pentaho, Javascript, Power Architect, SSIS, C#, Toad, ERWin, HP Quality Center 10.00
Senior DW/BI Architect /ETL Developer April 2008 – Dec 2008
SQLPOWER Group Inc, Toronto
Client: SQLPOWER Group Inc : PharmaDW – Pre-Built Business Intelligence Solution for Pharmaceutical Industry
Pre-built solution for pharma industry based on experience of previous projects for Roche Canada and Novopharm.
Worked in the team for architecting the expandable data warehouse model.
Designed and developed ETL interfaces for loading data into datawarehouse (interfaces were developed in two sets: POWER*Loader and Pentaho Data Integration, SSIS ).
Designed and developed pre-defined and ad-hoc reports( Wabit and Pentaho Reporting, Oracle OBIEE 10g.).
Designed and developed pre-defined dashboards( Wabit, Pentaho Dashboards, ORACLE OBIEE 10g).
Provided updates of project status to Project Manager.
Technical Environment: Oracle 10g, Oracle OBEE 10g, Pentaho, Javascript, SSIS, Power Architect, Power Loader, Toad,Wabit, Jira
Senior DW/BI Architect /ETL Developer Jan 2003 – April 2004
SQLPOWER Group Inc, Toronto
Client: WarrenShepell CANADA - EPA DataWarehouse
Tuning and redesigned ETL interfaces (30% improvement in load process).
Verified and validated data extractions, transformations and loads.
Provided updates of project status to Project Manager.
Technical Environment: MS SQLServer 2000
Software Engineer / PM Jan 1994 – Dec 2002
Telekom(RomTelecom), Romania
Client: RomTelecom OTE - Billing Customer Management System
Designed and developed billing and customer service system for the major Romanian telecommunication operator. System was designed to provide anytime calls details within 2 years history, ETL processes for loading call details records from digital and analogic call-collection system(PENTA_CONTA Systems).This operational system was source for financial datamarts and DSS.
Designed and developed interfaces between BCMS and GIS system.
Coordinating technical and human resource requirements for meeting deadlines.
Led Join Applications Development (JAD) meetings and general staff project meetings on a weekly basis.
Technical Environment: Oracle 7.3.3.1, Oracle Forms, Oracle Reports
Software Engineer / PM Jun 2000 – Dec 2002
Telekom(RomTelecom), Romania
Client: RomTelecom OTE - Leased lines management system
Designed functional and conceptual/logical/physical/enterprise data models, elaborated recovery and fallback strategies transformations and loads.
Designed and developed database for service of leased lines, containing leased line network path, equipments, defect management, signalization, etc. system was interfaced with GIS and BCMS( for billing purpose).
Technical Environment: : Oracle 7.3.3.1, Oracle Forms, Oracle Reports
Software Engineer / PM Jan 1994 – Dec 2002
Telekom(RomTelecom), Romania
Client: RomTelecom OTE - HR and Payroll system
Designed, developed, and deployed human resource database and payroll system.
Technical Environment: FoxPro, Oracle 7.3.3.1, Oracle Forms, Oracle Reports
Software Engineer / Oracle Developer May 1999 – March 2002
Independent Contractor
Client: Microplan GmBH Wien-Austria - iNTERWARE system
architected and developed components for iOffice(invoice services, appointments, phones, faxes, emails) and iDIM(documents management) subsystems.
Technical Environment: Oracle 8/8i, Oracle Forms, Oracle Reports
Other SLDC Operations 1994 – 2015
Analysis and Design( Operational Systems)
Analyzed legacy systems, workflows, business processes, architecture and business.
Requirements for development of various IT projects ( integration, migration, DW, data-marts, new systems app.).
Designed functional and conceptual/logical/physical/enterprise data models, elaborated recovery and fallback strategies, used for performing next cycles of projects.
Wrote functional specifications for analysis and strategy stage (functional overview, data requirements, interface requirements, data mapping, etc.).
Development and Programming
Developed more than 500 forms and reports for user interface and administrative tasks.
Developed more than 900 ETL interfaces and procedures for DW and migration projects.
Coded stored procedures, program units, triggers, menus, and data browsers for ad-hoc queries,
Wrote module functional and technical documentation .
Deployed and designed tuning strategies, mentored team members for applying processing techniques.
Supervised and managed up to 45 team members including programmers, analysts,
developers, database administrators and system/network engineers.
Testing and Quality Assurance
Planned and wrote test deliverables such as testing strategies, module integration test plan, system test and integration plan.
Defined and identified performance test scope and scenario for scanning all functionality of procedures.
Designed, developed and executed performance test and created performance test reports.
Implementation/Transition, Training and Maintenance
Prepared conversion strategies, standards and data mapping for database integration, DW.
Designed QA strategies in migration process( audit, KPI reconciliation, etc.).
Conducted training of project team regarding transition and production of new application packages.
Prepared and developed user training materials and trained users on system handling and usage.