Resume

Sign in

Data Governance and Quality/ MDM/ Data Modeling/ ETL/ Analytics

Location:
Toronto, ON, Canada
Posted:
May 15, 2020

Contact this candidate

Resume:

ARINDAM BHATTACHARYYA

Senior Consultant - Data and Analytics

Data Governance and Quality/ MDM/ Data Modeling/ ETL/ Analytics Solutioning and Project Management

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

Profile Summary

20 years of industry experience in solution design and architecture for information management, data and analytics, Master Data Management, BI migration for clients in the Government, Healthcare, Social and Community Services, Banking and Financial services industries.

Collaborated with senior management, business groups and IT groups for requirement analysis, feasibility, planning and articulate solution options with alternatives, budgeting, delivery planning for BI digital transformation and modernization.

Designed logical and physical architecture for data lakes, warehouse and marts; Master Data Management; visualization and advance analytics solutions with focus on end to end automation, user 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.

An effective communicator with commitment to exceed expectations, meet deadlines, and collaborative teamwork.

Analytics and Data Science

Cognos Analytics, Power BI, Tableau, QlikView, R, Knime, SPSS, SAS Visual Analytics, Neo4J Graph Analytics, Datameer

ETL, Integration and Governance

Informatica Power Centre, Infosphere Data Governance, IBM Datastage, Infosphere Information Analyzer, Collibra Catalog/ Lineage, Infosphere MDM

Databases and Big Data Platform

Oracle 8/9i/10g/11g, DB2, Hive, Parquet, Netezza, Informix, SQL Server 2012, Enterprise Hadoop Stack (Hortonworks), IBM Bluemix, Digital Health Cloud Platform (Azure)

Data Modeling / Industry Models

Sparx EA, Erwin 7.2, MS Visio, Power designer 12, Infosphere Data Architect, Infosphere Governance Catalog, Unified Data model for Healthcare, IFSDM, HL7 FHIR

Scripting & Languages

PL/SQL, Unix Scripting, Python, R, Hive, Spark

Certifications

Certified Business Intelligence Professional, TDWI

Certified IBM Cognos Administrator, IBM

Big Data Specialization, UC San Diego

ITIL V3 Foundation, APMG, UK

Project Management Professional, PMI, USA

PRINCE2 Foundation, APMG, UK

Education

Master of Science in Information Technology, Don Bosco University

Bachelor of Science (Physics Major) – University of Calcutta

Professional Experience

Client: RBC Insurance, Mississauga, ON Jan 2019 – Present

Role: Solution Architect, Enterprise Data Governance and Quality

Environnent

Key Contributions

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

Created data architecture frameworks, strategy, policies, guiding principles and data governance roadmap for enterprise heterogenous data across multiple domains

Performed product recommendations based on key components and architectural design for enterprise Data lake Governance

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

Created Data Quality Reports and executive Dashboards using Tableau based on IADB and expection databases

Established Data Governance delivery standards, tools, practices, quality checks, controls and documentation to continuously to detect, remediate, and prevent invalid data values by implementing proper data quality checks and controls

Functional understanding of Insurance business and products for Life and Annuity, Claims, Reinsurance and Wealth management, brokerage and commissions with in-depth understanding of FSDM/FSLDM Industry models

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

Creation of 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

Environnent

Key Contributions

UDMH Industry Model Indus, IBM Bluemix, Datastage 11.5, Infosphere Governance Catalog, Fastrack, Power BI, Tableau, Infosphere Data Architect, PostgreSQL, Hortonworks, Infosphere MDM (Product/ Party/ Reference Data), Azure Cloud Platform, Cognos Analytics 11.0.7

Produced architecture solution options, recommendations and multi-year project blueprints for Data Lake, MDM, EDW and Data Marts on Cloud infrastructure

Created reference architecture for cloud-based 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)

Deployed physical sandboxes on Azure Cloud Platform and IBM Cloud/Bluemix for Data Lake (PostgreSQL, Infosphere MDM, Hortonworks, Hive, Apache ORC, Spark) and Analytics (Cognos/Tableau/ PowerBI) and analyzed various use cases feasibility, cost, support model for these infrastructures

Scripting in Python and R for Machine Learning algorithms and data wrangling activities

Designed MDM 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 powerful data discovery and visualization app based on information from data lake using Kibana on Elasticsearch service

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

Role: Solution and Data Architect Consultant, Enterprise Business Analytics

Environment

Key Contributions

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.

Designed EDW atomic layer, Dimensional data marts in Infosphere Data Architect using Data Vault technique

Performed Data quality analysis and reports for various source system using Infosphere Information Analyzer

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

Created Spark SQL queries for analytics from HDFS sources.

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

Migrated existing reports and re-created dashboards (workspace) from Cognos 10.2 environment to Cognos 11 environment

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

Performed ETL development in IBM Data stage and using Netezza SQL for data warehousing

Installed and provided guidance to infrastructure team for installation and support of Infosphere Server installation and support

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

Role: Senior Consultant - IBM Cognos and QlikView Analytics

Environnent

Key Contributions

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

ETL development in Talend and A environment using standard design methodologies

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

Analyzed and developed the report layout structures, complex calculations and drill options and tuned the underlying queries

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

Environment

Key Contributions

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

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 Curám source data models and designed target Data-mart models for modules including Intake, Customer, Payments, Claims and others using Power designer tool

Designed Relational Reporting Database for operational report and Star model data mart for analysis and supporting Self Service BI requirements following best practices of Kimball methodology

Helped business team to conceptualize and created visualizations for BI & advance analytics and enabling business cases (covering functional and non- functional use cases)

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

Performed and provided guidance documentation to OPS staff for Cognos 10.1 installation on IBM web server on AIX environment

Conducted workshops for Design and establishing best practices in Cognos Framework Manager modeling, Report/Query Studio, Report Bursting, Event Studio and Customization using Java scripts

Created Source to Target Mappings for ETL team including complex transformations from Curám V6 to Reporting Data marts and trained the Reporting team for Curám 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

Reviewed Cognos Developers work for Report and Query Studio and provided IBM Proven Practices recommendations

Designed and validated the test plan for unit/system/UAT and non-functional test plan and business use cases test plan and test cases based on reporting interfaces, distribution, performance and report data and security

Performed upgrade from Cognos 10.1 to Cognos 10.2.2

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

Used Netezza SQL to maintain ETL frameworks and methodologies

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

Designed and created ETL mappings and workflows in Datastage to move data from source systems to staging area

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.

Performed data analysis and quality monitoring and reporting using Infosphere Information analyzer

Client: Norway Government, Ministry of Transportation BI System (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

Performed tool comparisons for ETL and Data Integration tools to propose best fit for the solution. 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

Created solution for ingesting of big data from log files, streaming sources, social media into BigInsights Hadoop platform to build analytics

CIBER Inc. Sep 2009 – Jun 2010

Information Management and BI Architect

Client

Key Contributions

County of Santa Clara,

California

Role: BI and Data Architect / Project Manager

Technologies:

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

Created Project deliverables and ensured that all deliverables are completed in timely manner using Agile methodology

Performed delivery review with QA and client team and scrum with delivery team

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

Technical Lead, BIDW

Client

Key Contributions

Novartis, East Hanover, NJ

Jan 2007 – Apr 2007

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

Lexmark, Kentucky

Apr 2006 – Dec 2006

Project Manager for the BI AMS project

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

Nissan North America

Sep 2005 – Apr 2006

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

Project management activities such as SOW creation, Milestone Plan, Lesson Learned and Project Archival Process, and End Project Audit

Oracle Financial Services (i-flex limited) Feb 2003 – Aug 2005

Associate Consultant

Client(s)

Key Contributions

Home Credit, Moscow

AccBank Bank, Dublin, Ireland

Diamond Bank, Africa

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

Senior Software Engineer

Key Contributions

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

Assistant Manager, Systems

Key Contributions

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.

Tools/ Technologies worked on: Oracle 8i / Developer 6/ PL/SQL / Fox plus/SCO UNIX

Technical Skills



Contact this candidate