Siva

Projects Roles and Responsibilities

Client/Industry: Multiple US & UK Clients

Duration: Jul 2022 – Till Date

Technology: IBM Cognos Analytics 11.7, IBM Cognos Analytics 11.2, Power BI, Snowflake,ADF,Azure SQL DB, AWS Athena, Glue,AWS QuickSight

Role: Data Visualization Architect

Team Size: Varies by client

·        Upgraded IBM Cognos 11.7 to 11.2 on 8 servers.

·        Configured security, SSL and SSO

·        Migrated 20 Cognos Reports to PowerBi.

·        Gathered business requirement for new implementing PowerBi Solution.

·        Created HLD’s for PowerBi Implementation with Snowflake EDW.

·        Updated Data Models for data visualizations.

·        Installed & Configured IBM TM1 Clients and configured for SSO

·        Created tables on AWS Athena using Glue

·        Accessed in IBM Cognos Analytics and PowerBi for Dashboards.

·        Created Data Pipelines in ADF and loaded in Azure SQL DB.

Client/Industry: Bank, UK

Duration: Jan 2022 – June, 2022

Technology: IBM Cognos Analytics 11.7, IBM Cognos Analytics 11.2,IBM PA, Power BI, Snowflake, SQL Server

Role: Data Visualization Architect

Team Size: 3

·        Analyzed Audit DB in Cognos environment and identified frequently used reports and submitted Audit analysis report to the client.

·        Upgraded IBM Cognos 11.6 to 11.2 on 5 servers.

·        Configured security, SSL and SSO

·        Migrated 1100 Cognos Reports to PowerBi.

·        Gathered business requirement for new implementing PowerBi Solution.

·        Built dashboards using PowerBi Desktop and could service.

·        Updated Data Models for data visualizations.

·        Implemented enhanced data security in PowerBi

·        Enhanced Dimensions and Cubes in PA Architect

·        Enhanced PA Dynamic Reports

·        Updated Rules and TI scripts to meet enhancement requirements

Client/Industry: Public Sector (Law Enforcement)

Duration: Dec,2021 – Jan, 2022

Technology: IBM Cognos Analytics 11.7, IBM Cognos Analytics 11.2, Power BI, Azure SQL DB, ADF

Role: Enterprise Architect - Data

Team Size: 3

·        Upgraded IBM Cognos 11.7 to 11.2 on 11 servers.

·        Configured security, SSL and SSO

·        Migrated Cognos Reports to PowerBi for one department.

·        Gathered Business requirement and implementing PowerBi Solution.

·        Built dashboards using PowerBi Desktop and cloud service.

·        Created dataflow architecture for various data integration point with ADF and Azure SQL DB.

·        Installed PowerBi Gateway and pulled data from onprem SQL ServerDB in to Azure SQL DB.

·        Created Data Models and Templates for data visualizations.

·        Implemented enhanced data security in PowerBi

·        Finding correlation in data to discover meaningful insights with PowerBi Capabilities.