Iyad Yassin - Manager Data Architecture and Analytics, Metrolinx

Feedback from Iyad’s ex-colleagues

Let me see

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

MetrolinxManager, Data Architecture & Analytics

Feb. 2022

MetrolinxAnalytics & Reporting Lead

Jul. 2017 - Feb. 2022Toronto, Ontario, Canada

CASAYAFA Consulting Corp.Principal

May. 2012Toronto, Canada AreaSmart Live Interaction Mart (SLIM™) is smart shopping center idea addressing the concept of multi-channel customer interaction, where store owners can interact with a customer that becomes closer in destination via smartphone or any smart handheld device with sensor. The Big Data and Analytics objectives from SLIM™ : ● Submit all offers and coupons thru the beacon service to any prospect customer. ● Access to basic weekly, monthly, and annual reporting on redemption index KPI. ● Analytics report about customer interaction per ad (offer, coupon, etc) ● Product and offer prediction analysis ● Market competition analysis Implemented Big Data analysis POC in text mining and sentiment analysis by scraping and munging unstructured data for large terabytes data set in a multi node cluster Hadoop using MapReduce, Python, Pig, and, NoSQL MongoDB.

Ontario Ministry of Government and Consumer ServicesAnalytics & Data Management Consultant

Dec. 2014 - Jun. 2017Toronto, Canada AreaManaged the architect of the data management solutions and ETL life cycle for the CFIS and IFIS Financial Modernization projects. Advisory on complex queries, reporting and Data visualization tools. Designed and developed complex interactive scorecard and drill-able reports. Worked closely with business users and development teams and ensured requirements were accurately reflected in the solution design, technical specifications and final solution Involved in all aspects of the project’s SDLC, including analysis, design, development, testing and delivery of the solution. Prepared technical documentation / presentations, and delivered as part of technical knowledge transfer activities.

Rogers CommunicationsBI & Big Data Integration Lead

Jun. 2013 - Nov. 2014Toronto, Canada AreaAssist in analytics and data warehouse design/built for Media Broadcast Management System and TV Media Analysis (Audience Statistics and Ad Sales Marketing). • Built data warehouse dimensional modeling from scratch using Kimball methodology as star schema, hybrid slowly changing dimensions, landing/staging and snapshot fact table. • Presented to the business an innovative Media KPI and strategy to capitalize on BI self-serve concepts. • Designed and developed Media Ad Sales Profitability daily scorecard and reports, by designing and implementing different subject areas OLAP Cubes.

Marsh & McLennan Companies, Inc.MDM & ETL Architect

Dec. 2012 - May. 2013Toronto, Canada AreaProvide consultancy in designing and building the infrastructure and reporting solution, in a team of architects and BI SMEs for Financial Transformation Project, to extract system information from multiple data sources (legacy, ERP, XML and Flat Files) into ODS and EDW using Informatica and ODI and loading into BI systems such as HFM, Planning, Essbase, and OBIEE. • Managed to lead the delivery of build books and best practices templates for the environment build, ETL design, data flows, program specifications, and integration test scenarios. • Developed Informatica Metadata Manager to identify the business modules glossary, entity definition for source and target, and setup data integration metadata catalog.

LafargeBI & Data Warehouse Architect

Jul. 2011 - Nov. 2012Toronto, Canada Area* Managed the architecture and design for Oracle Data Integrator extract/load and integration as comprehensive dynamic metadata solution for ODS layer as CDC and data mart for fact/KPI modules. * Designed data conversion solutions to dynamically enable BA to convert spreadsheet into data mapping, using ODI SDK and Open Tools. * Managed to strategize data governance and data quality approach methods using Oracle Data Quality and Data Integrator. * Provided solutions and recommendation as data architect for the enterprise data warehouse and ETL best practices. * Managed to build BI Apps Finance OBIEE 11g to upgrade from OBIEE 10g, and configure DAC for OOB implementation for the GL, AP, and AR modules that using Hyperion. * Managed to communicate and present to the end users guidance on solutions and reports design. * Created Knowledge Module to support the Data Mart and build slowly changing dimension type 3. * Creating Hierarchal Workflows and Load Plans for two layers, the ODS and Data Mart. * Designed and implemented CDC on the GL model for near real time reporting. * Created capacity planning document, metadata dictionary, ETL operation guidance, Development standard reference, and ETL naming conversion document.

GlaxoSmithKlineAnalytics & Data Warehouse Consultant

Oct. 2008 - Jun. 2011Toronto, Canada Area* Contributed in a large worldwide global program to implement Siebel CRM system and enterprise reporting strategy utilizing extensive custom solutions in Informatica, ODI, OBIEE, and Kalido MDM. * Designed solutions for Insight business to integrate KPI, web services, and contextual reporting that granted added value, and fashions innovative domino effect. * Managed to lead the configuration team to build the infrastructure/environment for the data warehouse system (OBI server, ETL server, MDM server, and web server). Developed the OBIEE metadata layer and assist with OBIEE report and dashboard development. * Presented technical guidance to ETL and BI reporting developers and testers to develop, execute and document complex data validation, test scripts, and unit tests. * Perform GAP Analysis related to data models and ETL, to create high-level and detailed design documentation that maps client requirements into Siebel Analytics/OBIEE functionality. * Oversaw SWAT sessions to tackle and resolve overall production performance bottleneck in ETL and data warehouse. * Managed to design and build the infrastructure servers (application server, ETL server, web server, and data warehouse) using AIX, RAC, F5, https, and high availability technology.

Fujitsu CanadaData Architect & BI Team Lead

Oct. 2004 - Sep. 2008Edmonton, Canada Area* Delivered world-class business and technology solutions that enable clients to become high performance businesses, through designing a solution using Siebel Analytics/Oracle OBIEE to achieve a defined business outcome. * Defined and analyzed corporate 24 critical KPIs (HR, Finance, Pharmacy, and Cardiac). * Provided solution to integrate Oracle EBS 11i and OBIEE, to resolve data level security hierarchy. * Designed and developed a complex corporate a weighted average target and threshold interface to incorporate timely based KPI measures scorecard and dynamically navigate to the right action. * Created and designed a framework methodology for the enterprise data model. Presented data integrity and data quality within the enterprise data model and worked with system architect to ensure physical design meets business and architecture requirements. * Presented best practices to mentor analysts and users on optimal data management. * Managed system migration project and Oracle database upgrade project from 8i to 10g for 25 databases on Sun Solaris and Fujitsu PrimePower. Deploy RAC environment in Oracle 10g for 14 different applications, and configure Oracle Automatic Storage Management. * Implemented Oracle10g Data Guard as physical standby for critical mission production database.

Investors GroupData Analyst & ETL Consultant

Mar. 2003 - Sep. 2004Winnipeg, Canada Area* Incorporated critical solutions to reduce cost and storage for a large data warehousing by utilizing Oracle partitioning effectively. Created and designed optimal physical design for the enterprise data warehouse using star schema and snowflake. * Managed in-scope functional and technical requirements based on design documents including data structures, data mapping, and related performance tuning. Provided schema version management and validation such as User Accepting Testing (UAT) and Functional Integration Testing (FIT). * Designed and developed data validation test cases, scripts for business logic, data profiling, and mapping rules. * Designed ETL routines to transform mainframe data structure into dimensional model to support Mutual Fund sales performance reporting system.

ENMAXDBA Team Lead

Apr. 2001 - Mar. 2003Calgary, Canada Area* Managed 4 developers to deliver web content data quality interface to support stakeholders reporting. * Designed and analyzed ETL process from flat files to Oracle Database and provided data modeling and system analysis for the data warehouse database to extract business logics * Challenged to enhance PL/SQL performance by remodeling, and tuning queries with indexing optimization and memory data collections. * Offered excellent estimates and forecasts as input into the scheduling process

Computer Network SystemsDatabase Development & Oracle Technical Consultant

Apr. 1996 - Mar. 2001United Arab Emirates* Managed the Oracle Practice department; pre-sales activities including (proposals, quotations, budgeting, and consulting) and post-sales activities including (presentations, coordinating projects and implementing solutions). * Planned and performed major data migrations including risk assessment, consulting and purchasing. * Designed solutions to move a client from a basic electronic storefront Web design to dynamic web site. * Technical consulting for Oracle Forms, Reports, Designer (2000 & 6i), Oracle Discoverer, JDeveloper, Oracle Application Server, and Oracle Portal 3.0 * Created content management application and managed to develop over 200 Oracle Forms and Reports * Managed live migration from open VMS mainframe to Oracle 7.3 * Implemented Different backup & recovery strategy for both data and application.

Intch is a Professional Networking App for the Future of Work

300k+ people

130+ countries

AI matching

Get Intch if you'd like to

📝

Get Recommended to New Customers

👋

Connect with Like-Minded People

💸

Raise Capital

🚀