ARINDAM BHATTACHARYYA

Sr. Consultant – Data Architect Analytics Data Governance MDM

Contact : 416-***-**** ● adc8ro@r.postjobfree.com ● LinkedIn Profile ●Toronto, ON Availability: Aug 21 2023

Profile Summary

Over 20 years of modernization experience in bridging the enterprise analytical perspective with the holistic view of strategizing, solutioning and implementation of Data and Analytics, Master Data and Governance.

In-depth industry and functional work experience of Government, Healthcare, Banking, Insurance, Manufacturing and Telecom domain.

Experience working with C level executives and IT delivery groups for design thinking and ideation, executive sponsorship and planning activities, stakeholder alignment, RPF submission and scoring, solution and delivery planning for BI digital transformation and modernization and cloud migration initiatives.

Designed data architecture for data lakes, warehouse, and marts; Master Data Management; Data lineage, catalog and security, visualization and advance analytics solutions to provide self-service digital experience.

Hands-on tools and technology expertise in Industry models and frameworks, data modeling, integration and ETL, governance, BI and Analytics using structured, unstructured, legacy, rest and streaming data from very large volume and complex data sets.

Performed due diligence, proof of concepts, buy build assessments, technology and vendor selection, presentations to business clients and sponsors, program, and delivery management.

Delivered Data and Analytics programs successfully meeting customer’s expectation with tight timelines and budget.

Analytics and Data Science

Power BI, Tableau, Cognos Analytics, Databricks, SPSS, SAS Visual Analytics, Neo4J Graph Analytics, Data Meer

Integration, Data Quality & Governance

Informatica Power Centre, IGC, Azure Purview, IBM DataStage, Infosphere Information Analyzer, Collibra, Informatica MDM

Database and Storage

SQL Server, Snowflake, Oracle, DB2, Hive, Azure Synapse, Databricks Filesystem, ADLS G2

Data Modeling / Industry Models

Erwin, MS Visio, Power Designer 12, Infosphere Data Architect, Unified Data model for Healthcare, HL7 FHIR, FIBO, Automotive, Party, Product and Account models

Scripting / Languages/ Others

PL/SQL, T-SQL, Unix-Shell Scripting, Python, Hive, Spark, Azure DevOps, Airflow, Stonebranch scheduler

Certifications

Certified Business Intelligence Professional, TDWI

Certified IBM Cognos Administrator, IBM

Microsoft Azure Fundamentals

ITIL V3 Foundation, APMG, UK

Project Management Professional, PMI, USA

PRINCE2 Foundation, APMG, UK

Education

Master of Science in Information Technology, Don Bosco University, Guwahati, India - 2012

Bachelor of Science – University of Calcutta, Kolkata, India - 1994

Work Experience

Client: Canada Deposit Insurance Corporation Jun 2022– Aug 2023

Project: Payment Systems Modernization - Azure Analytics

My Role: Sr. Data Architect – Contract (Full-Time)

Environment: Erwin Data Modeler, Azure SQL DB, Azure Synapse DB, PowerBI, ADLS Gen2, Dataverse, Databricks

Collaborated with Platform and application teams for designing the cloud architecture for Data platforms, server storage, content and ensuring proper sizing and configuration of Azure Data Lake environment for shifting the applications from on-Prem to cloud.

Articulated solution and design principles for Data Governance, Cataloging and PII marking using Azure Purview for Data Governance and cataloging requirements.

Analyzed all Data components for intake and target states, data management constructs and data lineage including any transformations, metadata management, processes for managing master and reference data.

Performed data modeling in Power designer tool for Staging and Datamart following layered architecture.

Created strategy for data center migration to Azure cloud based as part of Legacy Modernization program including a combined approach of rehost, re-platform, rebuild based on feasibility, cost, and other factors.

Teamed with security and network architecture team for Cloud security related to hosting of Cloud native datastore and apps in Azure Public cloud.

Built the strategy and roadmap for data and analytics migration from On-Prem to Azure considering the existing legacy infrastructure, assumptions, and constraints for new COTS application, designed Synapse and Databricks pipelines to loading of data into Azure Blob and Synapse database for analytical and reporting.

Conceptualized Lakehouse solution for hybrid data management architecture for various types of workloads, i.e., structured, un-structured and streaming data processing including delta lake architecture, machine learning and real-time analytics.

Client: Manitoba Public Insurance Oct 2020– Mar 2022

Project: Legacy Modernization Project - Azure Analytics

My Role: Analytics Solution Architect – Contract (Full-Time)

Environment: Azure Synapse, Azure Purview, PowerBI, SQL Server 2016/ 2019, SSIS, Azure Databricks

Developed cloud-based data and analytics solution architecture and data migration strategy. Worked with Enterprise Architecture involving security, infrastructure, DBA and business teams to develop a Corporate Data Analytics Strategy for adoption of new cloud-based technologies.

Built strategy and roadmap for data and analytics migration from On-Prem to Azure Cloud Services considering the existing legacy infrastructure, assumptions, and constraints for new COTS application, designed Synapse and Databricks pipelines to loading of data into Azure Blob and Synapse database for analytical and reporting.

Created Solution Architecture for enterprise Data Governance on Azure Purview platform involving Data sourcing from legacy and cloud sources, working with business champions to identify CDEs and create data catalog, glossary including semantic, operational, and business metadata and draw lineage.

Designed conceptual, logical, and physical data models using Erwin and Power-Designer tools. Configured and Implemented Logical Data Warehouse using Polybase technique on Azure dedicated and serverless SQL pool to complement a physical data mart to enable Self-service BI.

Created PowerBI tenant settings as administrator for Security and other access level controls, built PowerBI pipelines for PowerBI datasets and reports. Created PowerBI dataflows with complex DAX functions for ingesting data into PowerBI.

Defined row-level security roles and filters within Power BI Desktop using the enhanced row-level security editor based on user group and roles. Created PowerBI pipelines to support UAT and CICD processes.

Client: RBC Insurance, Mississauga, ON Jan 2019 – Oct 2020

Role: Enterprise Data Governance and Quality Lead - Contract (Full-Time)

Environment: Datastage 11.7, DB2, SQL Server, Hive, Parquet, Spark, Python, Infosphere Governance Catalog, Tableau 10.5, IBM Infosphere Data Architect, IBM Information Analyzer, Datastage, Infosphere MDM (Product/ Party/ Reference Data), Collibra IMR / Lineage / Catalog, Datameer

Created data governance architecture framework, roadmap, strategy, guiding principles, design, and delivery for enterprise data across multiple domains adopting scaled agile framework methodology.

Worked closely with Solution Architects, Application Architects and Subject Matter Experts and IT to develop Data Governance and Data Quality framework and solutions and define indicators of data quality metrics and ensure compliance with policies and standards.

Established Data council’s communication plan and accountability for ownership and stewardship and implemented Collibra IMR for issue tracking, resolution and reporting of DQ issues for RBCI IFRS17 program.

Led a team of 7-8 resources to develop data Quality Rules in IBM Information Analyzer to evaluate data standards for critical data elements based on quality metrics and thresholds that identify gaps and ensure compliance for IFRS17.

Designed Datastage parallel jobs and workflows for data ingestion from Data Lake and transformation, execution of Information Analyzer DQ jobs and automation schedules using Stonebranch.

Built Data Quality Reports and executive Dashboards using Tableau based on IADB and exception databases.

Established Data Governance delivery standards, tools, practices, quality and security checks for PII/PCI and PHI information, controls, and documentation to continuously to detect, remediate, and prevent invalid data values by implementing proper data quality checks and controls.

Participated in data governance and quality audits to measure and assure adherence to established standards.

Created Information catalog, Glossary and data lineage using Apache Atlas (for data lake), Infosphere Governance Catalog and Collibra, data models for analytics databases.

Built executive and senior management presentation decks for IFRS17 Data Governance, Data Lineage, Quality and Controls roadmap, architectural design and flow, pros and cons of approach, tools, cost benefit analysis, Data council triage for Issue management and Resolution.

Client: MOHLTC- Planning Architecture and Financial Management, Toronto, ON Apr 2018– Dec 2018

Role: Sr. Solution Architect (Consultant), Enterprise Data Analytics - Contract (Full-Time)

Environment: UDMH Industry Model, Infosphere Governance Catalog, Fasttrack, Power BI, Infosphere Data Architect, PostgreSQL, Hortonworks, Infosphere MDM (Product/ Party/ Reference Data), Azure Cloud Platform, Cognos Analytics 11.0.7

Created reference architecture for centralized data lake to ingest, integrate data from legacy and non-conventional source systems and applying HL7 FHIR specifications for various integration points to build Enterprise Data using Data Vault technique.

Technology options assessment for various components of reference architecture and prepared recommendations and migrated Cognos 10.2 to Cognos 11.0.7.

Created enterprise data governance model for shared business domains, enable the reuse of metadata (data dictionary), cataloging and maintenance (stewardship).

Designed data model for Patients, Drugs and Reference lookup domains based on data from LTC, Hospitals, Primary and Secondary Care, Mental Health, and Addiction Care.

Built Analytics and Visualizations in PowerBI and Tableau for LHIN wide Narcotics Monitoring system, Dementia Cohort Capacity and possible overstay, Fraud detection of billing and claims and other use cases.

Created Data objects based on transformation rules using PowerBI DAX functions.

Client: Toronto Police Services, Toronto, ON Feb 2016 – April 2018

Role: Solution and Data Architect Consultant, Enterprise Business Analytics - Contract (Full-Time)

Environment: IBM Datastage 11.5, Infosphere Governance Catalog, Infosphere Fast Track, DataStage, IBM Cognos 10.2.2/ 11, Infosphere Data Architect, DB2, SQL Server 2014

Led a team of 9 technical members to perform data assessment of key legacy source systems, external information sources including unstructured and streaming data and identified business entities and attributes for enterprise information hub for operational, predictive, and real time analytics.

Build the solution road map and blueprint for data capture and transfer to centralized repository, data quality, data governance and information security.

Collaborated with business team and designed conceptual model, business glossary using IBM IGC and created reports for complete data lineage from source to Data warehouse.

Created data governance catalog extensible framework to define and register new assets in catalog for enabling business users for better information understanding, explore assets in the catalog.

Created data governance rules and policies for attributes and elements of data mapping and transformation.

Created mappings, rules and scripts in Infosphere Fast track to be converted to ETL mappings in Datastage Infosphere Datastage 11.5.

Migrated and redesigned the existing SSIS packages to Datastage as part of Enterprise common ETL platform.

Created Big data architecture framework using Kafka to receive unstructured and streaming data from radio calls, weather forecasts, social media, geo-based data.

Created workflows in NiFi to integrate the structured and unstructured data into HDFS system for analytics purpose.

Designed Cognos Framework manager packages and Cognos Transformer cubes for strategic analytics and reporting.

Build new reports, analytics, and story lines in Cognos 11 environment.

Architected organization level data level security based on organization groups, hierarchies, information sensitivity etc. for dashboard and report level drill and content access.

Performed Cognos, Tableau installation and configuration and created and mapped namespaces, designed visualization application layout, analytics access and distribution mechanism and other administrative activities.

Travelers Insurance (Consultant) Toronto, ON March2015– Feb 2016

Role: Senior Consultant - IBM Cognos and QlikView Analytics - Contract (Full-Time)

Environment: MS Visio, Erwin 9, DB2 9.1, IBM Cognos 7.5 and Cognos 10.2, Oracle 11G, QlikView

Designed and performed Cognos development for visualizations such as dashboards and scorecards using Cognos Workspace and Workspace Advanced and enabling business cases for Policy, Payments, and Underwriting and Fraud analytics.

Designed interactive dashboards for end users and mobile users for self-service analytics and data exploration using Qlik Sense and QlikView reports.

Captured and integrated data sources directly from traditional and big data sources using Hive and Spark to continuously feed into Qlikview QVD files for interactive analysis and visualizations.

Designed reporting metadata model using Cognos Framework Manager and performed Cognos administration activities.

Performed Data warehouse and Data Mart design in Power designer tool, activities for ETL and database development activities including PL/SQL coding (procedures, functions, packages, and triggers)

Designed Framework manager metadata models and created cubes using Cognos Transformer based on DMR techniques for financial, planning, budgeting, analysis, and other self-service BI requirements.

Created Cube based reports in Cognos Power play for self-service BI for slice and dice, drill analysis etc.

Lead the technical team for development lifecycle, UAT and handling production support issues and migration from Cognos 7 to Cognos 10.

Ministry of Health and Long-Term Care (Consultant) – Kingston, ON April 2014 – March 2015

Role: IBM Cognos BI Specialist - Contract (Full-Time)

Environment: Power Designer 15, DB2 V 9.1, IBM Cognos 10.1 on Solaris, Oracle 11G, SQL Server 2012

Performed business requirement analysis, specification and architectural design and validation.

Enabled business team to conceptualize BI& advance analytics and related business cases.

Architected reporting and analytics dimensional model using Power designer, multi layered metadata in Cognos Framework Manager.

Designed security model based on Cognos user group and role level using Cognos namespace.

Setup reports for Bursting, Event Scheduling using Event Studio for delivery automation and Cognos administration activities.

Conducted workshops for design and establishing best practices in Cognos Framework Manager modeling, Cognos Report Studio & Cognos Query Studio reporting tools, Event Studio.

Designed data models for data marts and designed the ETL framework and SQL scripting.

Created stored procedures, functions and packages in T-SQL for custom ETL and data extraction process in SQL Server 2012.

IBM Global Business Services Jun 2010 – April 2014

Managing Consultant – Business Analytics and Optimization (Permanent - Full time)

Client: Children, Youth and Social Services Cluster (CYSSC), Ministry of Children and Youth Services, ON, Canada

Position: IBM Cognos BI Specialist

Core Technologies: Sybase Power Designer 15, Informatica Power Centre 9.5, Oracle 11G, IBM Cognos 10.1 on RHEL 6, Rational Team Concert

Led a team of 15 technical and analyst members to design Cognos BI concept solution leveraging components such as Framework Manager, Report Studio, Query Studio, Event Studio and Cognos Server Administrator

Analyzed Curam source data models and designed target Data-mart models for modules including Intake, Customer, Payments, Claims and others using Power designer tool.

Architected reporting and analytics dimensional model, multi layered metadata in Cognos Framework Manager supporting DMR, authentication and authorization based on LDAP and Go Secure, Bursting, Event Scheduling for report delivery automation.

Created Source to Target Mappings for ETL team including complex transformations from Curam V6 to Reporting Data marts and trained the Reporting team for Curam Functional knowledge.

Architected Cognos BI Server capacity planning to determine CPU cores, PVU licenses for Production and Non-Production environments based on application requirements, complexity, and information volume and shared service requirements.

Built the data architecture solution and design adhering to principles of Zachman framework for conceptual, logical and physical data model and design, how the data will be used and shared, integration, who will be using the data within and outside of the organization, timelines and security guidelines.

Client: Dutch Tax Office,

Netherlands

Position: Infosphere MDM Data Architect

Core Technologies:

Infosphere Data Architect V9.1, IBM Industry Model for Insurance, IBM Infosphere MDM EE 9.x, Infosphere Data Stage, Infosphere Data Quality 9.1

Designed the MDM data inflow architecture from multiple source systems such as payment and collection points, client registration points, government and private agencies and census data.

Leveraged IBM Insurance industry model and modified the data models as per business requirements for Customer and Product domain.

Designing of Business Objects processes in MDM workbench to move data from staging to MDM physical database.

Implemented Suspect Duplicate processing while adding or updating client details using match criteria and collapsing policies.

Provided inputs for creating services layer to cater to Business user’s information requirement and consumption from an Enterprise-wide Single Reliable source.

Analyzed source data quality using Quality Stage and produced analysis reports, data quality dashboards to be able to investigate, cleanse and manage data and information governance.

Data mappings development and administration in Infosphere Datastage.

Client: Ministry of Transportation - Norway Government

Project: Grindgut Auto pass

Position: IBM Cognos BI Architect

Core Technologies:

Infosphere Data Architect, IBM Cognos BI 10.2.1,

Datastage 9.5

Designed Cognos dashboards, scorecards, and alerts for real time monitoring of traffic, congestion, toll station downtime, collection flow from toll agents.

Reviewed Business Requirement Document (BRD) for Completeness, Gather and analyze financial planning, budgeting, and reporting requirements and created Architectural decision documents suggesting various alternatives.

Created Architectural decisions, solution design documents for various approaches of the BI solution and thereby proposing the best option.

Design of Cognos application user’s roles, groups and security and implemented Cognos Dynamic Cubes in Cognos Framework manager to support user’s Self Service BI requirements.

CIBER Inc. Sep 2009 – Jun 2010

Role: Information Management and BI Architect (Permanent – Full Time)

Environment: SAP Business Objects XI R3, Oracle 11G, Erwin Data modeler, Oracle Data Integrator

Created architectural design and blueprints for end-to-end data warehousing and BI implementation.

Designed DWH dimensional model and ETL Framework Design with Hub and Spoke Architecture, information visualization and analytics design through Business Objects dashboards using Xcelsius.

Provided technical advice usage of Materialized Views, partitioning of fact tables for performance improvement, training and mentoring the delivery team.

As offshore project manager performed all project management activities including implementation of iterative and sprint techniques. Project Tracking, communication with steering committee and QA audit.

Independent BI Consultant, Singapore and UK May 2007 – July 2009

BI Consultant and Project Manager

Client

Key Contributions

Kiln Insurance

London, UK

Nov-2008 to July – 2009

BI Technical Project Manager

Identified major milestones and detailed work breakdown structure for project deliverables.

Prepared Project plan and reviewed with Project steering committee.

Prepared and reviewed Source to target mapping document for ETL.

Performed mapping, dataflow, workflows and ETL schedule script in BO Data Integrator, creation of local and central repositories.

Create BO Universe Design and design of reports in Web and Desktop Intelligence.

Created Stored Procedures, Functions and Packages for Custom ETL in SQL Server 2008.

BT Global Services

Newcastle, UK

Jan-2008 to Nov – 2008

Business Objects XI R2 Administrator

Gathered requirements and transformed to matching solution components.

Created HLD and LLD for Reporting and Analytics Solution. BOXI Universe Design, Report Design, Content Management, BOXI administration support.

Business Objects Server Installation, IIS configuration, Performance Checkup, Clustering of Services, Content Planning and Management.

Canon Singapore

Singapore

May 2007 to Dec 2007

Business Objects Architect & Administrator

Creation of KPI for Business Objects Dashboards, Crystal Reports, Scorecards and Performance Management components.

Designing of Dashboard, PM, Scorecards in BO Performance Manager.

PL/SQL programming for transformation and updating of Reporting Database from external sources.

Wipro Technologies Sep 2005 – Apr 2007, Bangalore, India (Permanent Full-Time)

Technical Lead, BIDW

Environment: Oracle 10/11, Business Objects, Informatica ETL

Participated in client workshops and develop POC for BI system for clinical trial team.

Assisted client to develop business cases for the project and developed a Quality Assurance Plan and key Customer Acceptance criteria.

Designed framework for the new BI architecture, Design of Report folders, user groups, security for Cognos 8.4 implementation.

Created Power cube in Cognos Transformer and created cube-based reports using Cognos Powerplay.

Project Manager for the BI AMS project including deliveries such as SOW creation, Milestone Plan, Lesson Learned and Project Archival Process, and End Project Audit

Implemented ITIL techniques for support services activities for multi technology and platform environments for L2 and L3 tickets.

Created BI reports and dashboards using MicroStrategy and scheduling of reports in Narrowcast Server.

Created Subject Area wise data marts and identified and designed common business objects among them.

Business Objects Universe design, Content Planning, user groups, report scheduling and broadcasting criteria.

Oracle Financial Services Feb 2003 – Aug 2005 - Bangalore, India (Permanent Full-Time)

Associate Consultant

Environment: Oracle 10/11, Business Objects, Oracle Forms and Reports

Flexcube implementation technical lead for major banking projects in Africa and Europe

Responsible for requirement study at onsite, co-coordinating with offshore development team for architecture design, development

Designing Dimensional Models for data marts from FLEXCUBE core banking system for Flexcube Reporting

Business Objects 6.5 Universe and Report design and development, performance tuning of reports

Conducted training on Business Objects for bank’s support team and business users.

Scheduling for test/mock implementation, UAT, and Live Cut-off and conversion.

Nucleus Software July 2001 – Jan 2003 New Delhi, India (Permanent Full-Time)

Senior Software Engineer

Environment: Oracle 10/11, Business Objects, Oracle Forms and Reports

Led a team of 7 members for implementation of Loan and Deposits modules and providing post implementation support. Preparation of HLD, LLD based on Functional Specifications. Provided 24X7 supports for after implementation support, End of Day Operations support. Forms and Reports layout designing using Forms 6.0/ Reports 6.0, PL/SQL coding (procedures, functions, packages, and triggers) and integration of Modules with General Ledger.

Tata Global Beverages Aug 2000 – June 2001 Kolkata, India (Permanent Full-Time)

Assistant Manager, Systems

Environment: Oracle 8i / Developer 6/ PL/SQL / Fox plus/SCO UNIX

As a senior developer participated in the study of Legacy system, Feasibility Study, Process Modeling, Application Designing, Forms and Reports Designing, PL/SQL coding (procedures, functions, packages, and triggers) and Integration of Modules. Developing Tools for Data migration using SQL* Loader and input from Fox plus to new Oracle database.

As an associate DBA, I was involved in designing of Schema, loading data scripts using SQL loader, writing stored procedures, triggers, materialized views, synonyms, partitioning, backup, and recovery scripts.

Technical Skills

Contact this candidate