OLEG GRIGORIEV Toronto, ON, M*M *T*

647-***-****

adyrwe@r.postjobfree.com

1

Data/BI/Solution Architect, Team Lead

Accomplished professional with advanced experience in all phases of SDLC, including: requirements management, functional, and technical design, development, QA, implementation and support. Expertise in enterprise grade Reporting & Analytics Solutions, BI\Data Warehouse\ETL design, implementation and support, ERP\CRM, Finance. Outstanding interpersonal, training and cross functional skills. CORE OF COMPETENCIES

• Data Warehousing (15 years)

• Data Integration and ETL (15 years)

• Data Modeling and Master Data Management (15+ years)

• Business Intelligence (15 years)

• Analytics, Data mining, Machine Learning and Statistic (10 years)

• ERP (CRM, SCM, MRP, Finance and Accounting, Financial Planning and Budgeting) (15+ years)

• Cross platform integration (15+ years)

• Team Management (15 years)

• Software Development Life Cycle (15+ years)

• Utilities (4 years)

• Telecommunication (10+ years)

• Finance and accounting (15+ years)

PROFESSIONAL EXPERIENCE

Shaw / Freedom Mobile (Toronto) Jan 2017 – Present Data Architect/Project Lead

Overseeing the architecture, design, development, unit testing, and implementation of EDW (on premise and cloud tier), Big Data Analytics projects; On-going work to bring Data Warehouse to a level of maturity; Hands-on role (analyzing, data modeling, data profiling and mastering, creating design documents, quality assurance and post-implementation support);

• Plan, direct, and lead of multiple projects to ensure adherence to established objectives, timelines and budget. Support implementation of Government compliance EDW components life cycle in Agile Kanban environment.

• Implement and maintain Data governance rules for master data, business processes & cross functional integration. Creating and maintaining data dictionaries, data model diagrams, data mapping documents, operational procedures and related documentation.

• Created system and procedures to track data lineage form source systems and ETL streams to MSTR data visualization components.

• Collaborate with data analysts, business stakeholders, and analytics practitioners to understand requirements. Facilitated project meetings related to integration of source systems – SingleView, Oracle EBS, RIQ (Retail system), IFRS with Enterprise Data Warehouse.

• Analysis, prototyping, documenting, and implementing new requirements from senior management of Marketing, CBM, Finance, Network operations by creating new tables and Data Marts in integration (CLDM) and semantic(dimensional) layers of EDW.

• Lead the modeling, design and implementation for semistructured, relational and dimensional data for a range of use cases targeted reporting solutions and applications. Modification and customization existing Teradata CLDM model (Erwin) for Data Warehouse per business needs;

• Created and maintained sematic layer model (conceptual, logical and physical) of EDW by combining dimensional and unstructured data with Microstartegy metadata. Automation of change tracking process for Freedom Mobile specific customized CLDM and semantic model.

• Created new business areas of EDW model specific to Freedom Mobile business and not a part of baseline CLDM (Tab, IFRS, etc).

OLEG GRIGORIEV Toronto, ON, M2M 3T8

647-***-****

adyrwe@r.postjobfree.com

2

• Architect data transformation, preparation, and data movement processes for a variety of scenarios for enterprise-grade ETL workflows connecting multiple structured and unstructured endpoints. Created Database views (logical and materialized) for semantic layer for various DataMarts.

• Created mapping documents to be implemented in-house and offshore by Cognizant. test Informatica ETL mappings; Manage and continuously improve data workflows and query performance.

• Designed and implemented IFRS 15 and Operational Revenue Data Marts for revenue assurance group, ARPU calculation, analysis and reporting.

• Created Subscriber Activity DataMart for Marketing and Customer care for analysis and customer base management.

• Developed data standards and policies for EDW day-to-day loading and archival process. Analyzed for long term data access (ability to pull data due to growth) and disk space capability.

• Analyzed process to improve performance by looking into scheduling tool (Tidal) & Informatica plugins. Develop processes to monitor and troubleshoot manual and automated data preparation and data movement processes.

Environment – Linux, Oracle Exadata, Teradata CLDM, SQL Server, OLAP, Informatica, Pentaho, NoSQL, Data Lake, AWS S3, EMR, DynamoDB, Snowflake, Microstrategy, Tableau, Erwin, Tidal, OLTP, SingleView, Oracle EBS, RIQ, Scorecard, RIQ, IFRS, ScoreCard, Kanbanize. Rogers / Mobilicity, Toronto, Canada

Data Architect, EDW/BI Lead, Jul 2010 – Jan 2017

• Leading of internal Reporting & Analytics development, implementation and support

• Involved in business users training and request queue management, assisting in BRD/CR preparation and reviewing

• Promoting unification and standardization in BI development and implementation. Maintaining standards of BI Lifecycle management using Agile Scrum methodology on Atlassian JIRA, JIRA Agile platform.

• Performing research for cross platform BI solutions, preparing infrastructure to support the organization BI needs

• Performing requirements gathering, analysis, prototyping and transformation into BI solution conceptual design, evaluating alternatives.

• Executing business processes and data flow analysis, modeling and optimization. Providing data quality and accessibility assurance. Conducting master data management and data governance.

• Undertaking logical and physical design of large relational and multidimensional EDW, data storage building and optimization. Conducting metadata design in Cognos/Microstrategy .

• Architecting data integration procedures including ETL processes, data integration scripts to support data exchange between different data providers: AMDOCS, SAP, POS, Scorecards, payment processing systems, in-house EDW.

• Data mining predictive models building, training and accuracy improvement using MS SSAS and Microstrategy.

• Involved in quality assurance, production deployment and change management procedures. Performing production support and enhancement.

• Guiding maintenance, administration, performance tuning of BI, EDW, Data Integration Servers. Technical leadership in successful design, implementation and support of various BI and data integration projects, including:

• Usage and network analysis, subscribers porting

• CBM and retention, promo campaign management, sales analysis.

• Procurement and Inventory Management, Shipment, Activation.

• Subscriber Lifecycle modeling and forecasting (prime in automation) OLEG GRIGORIEV Toronto, ON, M2M 3T8

647-***-****

adyrwe@r.postjobfree.com

3

• Subscriber Churn and Tenure predictive modeling,

• AR payments reconciliation (prime in automation),

• Prime in credit card payments fraud predictive modeling,

• Revenue calculation and validation (prime in automation),

• Commission accrual and validation, dealer fraud management (prime in automation),

• Consolidated financial reports (prime in automation),

• Data integration between external provides AMDOCS, Sandvine, Ericsson, SAP, POS, Ingram, TIO, Admeris, Chase and EDW.

• Prime in data integration between AMDOCS and chatr migration portal.

• Subscribers communication automation for chatr migration

• Subscribers data migration from AMDOCS to chatr CWP. Environment and platforms: Oracle, MS SQL, MySQL, Cognos, Microstrategy, MS SSAS, MS SSIS, Pentaho DI, Data Mining, AMDOCS, SAP, Scorecards, POS, JIRA, JIRA Agile, HPSM BI Vision Inc., Toronto, Canada

DW/BI Architect, 2009 - 2010

Leading Technical architect in EDW/BI development in all phases of BI Solution lifecycle for different industries. Performed requirements analysis, EDW design and implementation. Designed and customized existing ETL, data cleansing and data integration solutions for various environments such as: Informatica Power Center, ODI, and Pentaho. Provided BI metadata design and end user layer development including reports, dashboards, business events and scorecard on Cognos, SAP BO, OBI EE platforms. Supervised ETL, Data Integration and Business Intelligence environment installation, customization and performance optimization. Environment and platforms:: Oracle AS, Apache, TomCat, Informatica, Oracle Data Integrator, Cognos, SAP Business Objects, OBI EE, APEX, ErWin, Sybase Power Designer, Oracle RDBMS, MS SQL, Teradata, MySQL.

Key projects and achievements:

Designed unified BI solution for Retail and Wholesale industry on following platforms: Cognos /OBI EE/ SAP BO, Informatica/Pentaho, Oracle/Teradata/MS SQL/MySQL. This system allows significantly reduce implementation cost due to unified approach to BI System design and flexible data integration procedures. FORS DC, Moscow, Russia

Solution Architect, 2005 - 2008

• Acted as lead solution tech architect across 3 projects; performed numerous offsite operations: requirements definition and prototyping, modeling and creating data storages, developing and optimizing ETL jobs, implementation, support and upgrading.

• Facilitated all stages solution lifecycle, including: environment rolling-up, performance tuning, customization, metadata layer design, constructing operational store, EDW and data marts. Environment and platforms:: RedHat, AIX, Oracle AS, Weblogic, Apache, TomCat, Informatica, Teradata, Oracle Grid, Oracle Warehouse Builder, Oracle Data Integrator, OBI EE, SAP Business Objects, Mictorstrategy, Oracle Data Miner, Oracle Utilities, SunGard, ErWin/BpWin, ARIS, Sybase Power Designer, IBM RSA, Case Wise, Atlassian JIRA.

Key projects and achievements:

• Designed, created, and implemented Integrated Utilities Billing System that operates with more than 10 million Moscow residents.

• Developed and implemented self-serve BI reporting system for performance management and financial analysis.

• Developed and implemented solution for Moscow City Budget analysis and forecasting to optimize budget planning and performance.

EDUCATIONAL AND PROFESSIONAL TRAINING

Data integration solutions, Certificate (2009)

Toronto College of Technology

Customer care and Billing: Functionality for Implementers, Certificate (2007) OLEG GRIGORIEV Toronto, ON, M2M 3T8

647-***-****

adyrwe@r.postjobfree.com

4

Oracle University, Russia

Postgraduate Course in Shipbuilding Automation and manufacturing management (1994) Kaliningrad State University, Russia

Bachelor Degree in Computer Science (1987)

Kaliningrad State University, Russia

Contact this candidate