Siva

Data / Analytics Architect
placeholder
Location Hyderabad
view-icon
Total Views5
availability
Shortlist0
back in time
Member since10 Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 18 Year
  • Cost
    Hourly Rate$15
  • availability
    AvailabilityMore 1 Month
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnJanuary 27, 2023
Key Skills
Data ModelingData WarehousingSnowflakePower BITableauSQL
Summary

 

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.

Copyright : 2022 – OnBenchMark All Right Reserved.
Request Demo