Juzer A. Email & Phone Number

Vaughan, On, Ca

Toronto, Ontario, Canada

Investment & Private Wealth Data Management Subject Matter Expert, data and analytics strategy advisory services to Clients in Capital Markets, Finance & Banking primarily focused on Modernization & Migration from On-premise SQL and Oracle to cloud solutions specifically Snowflake, Azure and AWS. Supporting Investment Finance, Risk, Compliance and Front Office.For a Research Organization, created data strategy that established an understanding of current state of data management, target state modern data platform, Data governance and Organizational Readiness with a multi year implementation plan with anticipated investments.Created data strategy, reference architecture, defined subject areas, MVP and product execution roadmap. Delivery organization structure, data governance plan and defined roles & groups to support enterprise wide data governance for major Canada Research Organization.Created target state Azure Machine Learning architecture for a building material supplier from Vancouver.Created data migration strategy & roadmap for a mission critical Operational System for a large Canadian Rail network operator from Calgary.Conducted current state assessment, created target state architecture, migration plan and roadmap from on premise to Snowflake and Master Data Management vendor for a large Canadian Investment Management pension plan. Advised, assisted and created a detailed roadmap to mature #investmentdatamanagement including replacing #pace environment with #Masterdatamanagement, #Referencedatamanagement & #datawarehouse on #SnowflakeCreated a data strategy and capability maturity roadmap for a large 3PL. conducted extensive interviews with Senior Leadership Team, many workshops, built consensus on current state, future state and step by step roadmap to get there.Advised a large Canadian Retailer looking to scale 10x with real time data integrations between #Salesforce, #InformaticaCloud, #Omni #Manhattan, #Oracle #Retailsuiteofservices.

Toronto, Canada Area

Primary responsibility for driving business through optimal use of our data assets. Providing leadership and direction for Investment Data Architecture and Engineering including stakeholder management & data delivery leading a high performing team of Architects, Designers, Data Engineers, Data Analysts direct and consulting reports. Responsible for leading a team to design OPTrust Investment Data Warehouse for reporting by Front Office.- Supporting Total Fund reporting for Capital Market, Real Estate, Private, Infrastructure & Hedge Funds- Capital Markets Group - Supporting trade flows and reporting, Security Master, Bloomberg, DLPS, Bloomberg Trade parsing- Investment Finance and Total Fund Risk including Risk Modelling, Risk Reporting and Analytics, responsible for providing our daily portfolio to MSCI Risk Metrics for Risk Analytics and producing daily Investment Risk Reports.- Investment Compliance responsible for providing our daily portfolio to FundApps for public market positions and Consensys for Options and Futures- Investment Performance Management and Analytics - Data Management in Eagle Pace, responsibility for maintaining Security Master and loading daily Positions for Performance Management and Analytics.Data Quality, Data Reconciliation between multiple systems, - Architecture and Delivery of OPTrust EAADP (Enterprise Advanced Analytics and Data Platform) | Microsoft on premise and Azure stack including Databricks- Market Data Management responsibility for market data providers, including, Bloomberg, S&P, TSX, TMX, FTSE Russel and more. Included budgetary responsibility and keeping track of data usage from multiple business partners while finding opportunities to strategically increase data usage while maintaining or reducing spend on market data. Leveraged a team to build tools to track data costs, and build framework to optimize data acquisition through an integrated data strategy with business buy-in.

Toronto, Ontario, Canada

Wearing multiple hats including leading multiple teams to deliver Data and Analytics on cloud:- Technical Architect- Solutions Architect- Tech Lead Azure and AWS data and analytics implementationsClient EngagementsConsulting Manager - Government Client - OttawaNov 2018 - PresentManaged Resources CAD400k+- Leading end to end delivery of a large data and analytics program implementation including --Denodo for Data Virtualization--Power BI for Data Visualization--Paxata for Self Service Dataprep--SAS Viya for Analytical data modelling--HDP on AzureScope: defining required VMs, integration with AD, Kerberized environment, platform installation, configuration and integration with existing on perm and cloud systems.

Toronto, Ontario, Canada

Tech Lead - Amazon Web Services Proof of Technology- Migrating home grown Enterprise Data Lake applications and Sunlife data to AWS EMR and S3.- Accountable for moving enterprise datalake and applications running on EDL to AWS. Solution ArchitectAccountability for end-to-end Solutions Architecture and design for multiple large BI and Analytics projects leveraging Datalake and SQL Servers for storage, spark and Informatica for ETL and Zeke for scheduling. Programs and Projects Solutions Estimations- Accountable and responsible for effort estimations for various data solutions. Presenting effort estimations to senior leadership, client and engaging resources to deliver end to end data product. Estimated and delivered many solutions ranging from $50,000 to $500,000Big Data Architect - Big Data Center of Excellence- An architect of Hadoop CoE, part of the team responsible for design, deployment and operationalizing of Hadoop data lake and associated capabilities including data ingestion, data organization, data exploration​ and analysis using Hadoop native technologies, spark and Scala, pig, hive and sqoop. Created Ranger implementation design aligning with Sunlife's security requirementsConducting multiple vendor and tool evaluations, from initial assessment to PoC and recommendationsWorking on operational framework creating SLAs including formalizing data and user on-boarding processesWorked on capacity planning and data and user growth on Enterprise Data Lake as a direct input to cluster upgradeCreated standards for Curated and Derived data layers on HDFS including defining HDFS folder and Hive Naming conventionsTech Lead HDP 2.3->2.6 upgrade

Oakville, On

Responsible for data strategy, hadoop data lake and data warehouse delivery

Toronto, Canada Area

Projects: 1. Data Architect - Enterprise Data Warehouse - A greenfield initiative2. Data Architect - Next Best Action3. Data Architect - Campaign Management Data mart4. Big Data environment provisioningKey responsibilities include:To provide technical and data leadership to the application development group, IT, and the enterprise.Develop and maintain conceptual, logical and physical data models.Create data architecture, data management standards and conventions, data naming standards, and metadata standards.Develop and implement standards and processes for ensuring data quality.Contribute to analysis, solution design, development and implementation of operational and data warehouse projects.Work closely with key client and IT stakeholders in understanding business needs and recommend solutions.Understand business requirements and translate them to the enterprise data and process models.Lead logical data model workshops with business users to derive at a logical data model that correctly reflects the business.Setup the physical data model including all physical database configurations such as indexes, tablespaces, table partitions, table constraints, relationships, etc.Generate DDL script from data modelling tool and to ensure the script’s proper function.Coordinate with database administrators the physical construction of databases for projects and maintenance.

Toronto, Canada Area

• Create the Logical and Physical data model with a data modeling tool like ERWin, Power Designer, etc.• Prepare process models in accordance with the guidelines/conventions of designated process modeling methodology, includes creation and maintenance of process descriptions and glossary of terms. • Facilitate the exposure of process data from functional experts and the user community. • Provide mapping between existing process and proposed replacement processes. • Design and normalize the logical data model to third normal form. • Facilitate the discovery of entities, attributes, relationships, and business rules from the functional experts and the user community. • Prepare fully refined data models in accordance with the guidelines/conventions of the IDEF or equivalent methodology. Develop and manage data models and associated metadata for the enterprise.• Modify the physical data model for efficient data access paths. Generate and execute DDL to create databases, tables, and views.• Identify and create primary indexes, partitioned primary indexes, secondary indexes, join indexes, and all other needed indexes.• Identify statistics columns, and create and execute collect statistics statements.• Identify and create necessary associative tables, data constraints, and multi-value compression.• Recommend and establish standards, guidelines, and procedures for design and maintenance.Projects: Revenue QuebecBell MobilityMark Anthony BrandsRoger's BI RoadmapMcCain's Category Management Project

Toronto, Ontario

Teradata Modeling of Acq, Int and Pres layers in 3NF of a major new data source brought in to EDW.

8200 Dixie Road, Brampton

Data Architect for greenfield EDW initiativeResponsible for creating the BI Datamodelling standard. Leveraged the standard to create logical and physical data models for Oracle and Teradata.ODS-ORACLE (Operational Data Store): Engaged as a data modeler responsible for creating the logical/physical structures for Oracle. The data modeler is the interface between Development and Solution team. Feedback from either team flows through the data modeler and changes are passed from data modeler to the DBAs.ADS-TERADATA (Analytical Data Store): Responsible for interfacing with the business for analysis to capture requirements and create the Logical and physical data model for ADS on Teradata based on Teradata's CLDM.

Toronto, Canada Area

Working on the RSA EDW Phase II in close coordination with client SMEs, my role involved data modeling of the target system particularly, PARTY, LOCATION, and REINSURANCE AGREEMENT subject areas based on Teradata Financial Services Logical Data Model v11. Also, as a BSA, I wrote acquisition and integration layer transformation specifications for the EDW for the above mentioned subject areas. Key deliverables included:• Logical and physical data model• Transformation specifications for ETL development of acquisition and integration layerEnvironment: Erwin 8.x

Toronto, Canada Area

Work with a team of Adastra consultants in the completion of data warehouse and business intelligence development projects which can incorporate some or all of the following components: Business analysis and requirements gathering Logical and physical data models including metadata Source system data analysis Source to target data mapping analysis and design ETL development and Quality Assurance Information delivery development and Quality Assurance Represent Adastra and Liaise with other client groups within the framework of a larger project team to deliver a unified solution

Toronto, Canada Area

Working with multiple stake holder in the Policy Admin System (PAS) Plan Right Project, my role entails understanding the flow of data related to Foresters Plan Right product.As part of the larger EDW-KPI project, my role is to identify and document the flow of data from PAS Operational Data Store (ODS) to EDW and onwards for reporting.My key deliverables includes, detailed mapping specifications from source (PAS ODS) to target (EDW) system and other soft deliverables include:- An understanding of the request/requirement from the user- Identification of the client- Identification of the scope of project- What is the expectation around future volume increases

Toronto

- Working with large data volumes efficiently using SAS, I am responsible for successfully writing and executing ETL test scripts in proc SQL for CIHI's NACRS data base.- Participate in the design of testing strategies/test cases, develop code and test scripts, and provide analytical support ensuring correct and comprehensive testing of new, enhanced and modified NACRS eReport from the NACRS datamart.- Participate in the identification and resolution of important issues relating to the NACRS database to ensure effective operation and maintenance.- Develop and maintain a detailed knowledge of the NACRS database and the tools (e.g. SAS, Excel) used to produce standard and ad hoc outputs.Environment: SAS, Oracle PL/SQL

Master'S Degree, Software Engineering And Management Sciences

Specialization in Software Engineering and Management Sciences Emphasis: Software Reliability Engineering, Software Quality Assurance.

Bachelor'S Degree, Information And Communication Systems Engineering

Activities and Societies: 2008-09 - President IEEE NUST Chapter 2007-08 - Vice-President Student CouncilBachelor in Information Technology.