Post Job Free
Sign in

Data Project Manager

Location:
Vaughan, ON, Canada
Posted:
April 28, 2018

Contact this candidate

Resume:

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.



Contact this candidate