Summary
Overview
Work History
Education
Skills
Timeline
BusinessAnalyst
Mohan Myakala

Mohan Myakala

Senior Data Analyst
Hyderabad

Summary

With over 6 years of IT expertise spanning Supply Chain, NBFC, HR, Aviation, and Sales sectors, I specialize in QlikView/Qlik Sense development, reporting, and project management. I excel in managing client requests and overseeing Tableau operations, including scheduling, permissions management, and manual refresh tasks. Additionally, I've played a pivotal role in upgrading Tableau Bridge clients and ensuring seamless data validation. Proactively addressing server downtime, data refresh failures, and user access issues, By optimizing Tableau server efficiency, resolving integration challenges, and managing licenses. My commitment to documentation ensures transparency and adherence to best practices, enabling successful Tableau implementation and management.

Overview

6
6
years of professional experience

Work History

Senior Data Analyst

Indium Software (India) Pvt Ltd
3 2023 - Current
  • Managed client requests for Tableau data source scheduling
  • Handled manual refreshment tasks for Tableau data sources
  • Played a key role in upgrading Tableau Bridge client and troubleshooting issues
  • Conducted validation of Tableau report data against the database
  • Addressed server downtime incidents promptly and effectively
  • Resolved data refresh failures to ensure accurate and timely reporting
  • Assisted users with authentication and access issues, ensuring smooth access to Tableau resources
  • Managed permissions to maintain data security and compliance
  • Proactively addressed performance degradation to optimize Tableau server efficiency
  • Conducted research and resolved integration challenges to enhance Tableau functionality
  • Managed Tableau licenses and subscriptions for efficient resource allocation
  • Implemented monitoring and logging solutions to track Tableau server performance
  • Ensured timely service updates and patching to maintain system integrity
  • Provided regular email updates to stakeholders regarding Tableau system status and updates
  • Maintained comprehensive documentation for Tableau processes and procedures
  • Managed creation and deletion of Tableau data sources to align with business requirements and data governance practices.

Senior Developer

Team Computers Pvt Ltd
04.2021 - 03.2023
  • Analyzing, and documenting business requirements and data specifications
  • Involved in performance tuning of various QlikView applications
  • Gathering data sources like QVD files, Excel and MySQL in developing the QlikView Data Models
  • Used different types of joins to join data from different tables
  • Developed User Interactive Sheets & Reports as per the business needs
  • Implemented Set analysis and used aggregate functions like sum, count and average to provide custom functionality to application
  • Created dashboard which user can analyze the data by product category and individual product
  • Used macro and external portals to send the SMS to numbers
  • Implemented Admin functionalities as well
  • Publishing and Creating Tasks
  • Adding users to the list.

BI Developer

Prasti IT Pvt Ltd
07.2019 - 11.2020
  • Analyzing, and documenting business requirements and data specifications
  • Involved in performance tuning of various Qlik Sense applications
  • Gathering data sources like QVD files, Excel and Oracle in developing the Qlik Sense Data Models
  • Used different types of joins to join data from different tables
  • Developed User Interactive Sheets & Reports as per the business needs
  • Implemented Set analysis and used aggregate functions like sum, count and average to provide custom functionality to application
  • Used Drill down and cyclic group to different charts
  • Created a dashboard which user can analyze the sales by product category and individual product
  • Implemented alternative states for comparative analysis eliminating additional complex coding
  • Used Web connectors and Extensions
  • Reports generated and sent to users by N-Printing and triggered on daily basis
  • Implemented Admin functionalities as well
  • Publishing and Creating Tasks
  • Adding users to the list.

Software Developer

IBM
11.2017 - 06.2019
  • Analyzing and understanding the Business requirements
  • Created QVD’s by importing tables from the database using Qlik view
  • Extracting the data into Qlik view from various data sources like Database tables, QVDs, Excel sheets into QlikView
  • Performing various types of loads like Preceding load, Inline load, Mapping load, Binary load, Resident load, Incremental Load and Cross table load
  • Created reports using Qlik View components like List Box, Slider, Buttons, Charts, Straight tables and Pivot Tables
  • Created Variants, layouts and QVD Generators
  • Worked with variables, Set Analysis, Aggregate functions and Mapping functions
  • Developing the reports with various functionalities like Dynamic visibility, Drill Down group and Cyclic group, Highlighting the data etc
  • Developed Qlik View Dashboard using Chart (Drill Down, Drill up & Cyclic Grouping), List box, Input Field, Table Box and Calendar
  • Drill Information by creating Groups/Cycles in Qlik View
  • Worked on Incremental Loading to reduce the reload time of different applications
  • Applying Security for the developed dashboards at various levels using Section Access
  • Deploying the dashboards to the Server to provide centralized access for the users
  • Working on Qlik Sense Desktop to build POCs for the users
  • Set up a QlikView publisher distribution task, Monitoring of daily jobs in QMC
  • Implemented Section access for region vise users
  • Analysis of the specifications provided by the client and understanding the business
  • Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting using Qlik View 11
  • Involved in Data modeling for Dashboard design
  • Preparing various business reports using various charts like bar charts and pie charts etc
  • Created Dashboards style of reports using Qlik View components like List Box, Slider, Buttons, Charts, and Bookmarks.

Education

Skills

QlikView 1120

undefined

Timeline

Senior Developer

Team Computers Pvt Ltd
04.2021 - 03.2023

BI Developer

Prasti IT Pvt Ltd
07.2019 - 11.2020

Software Developer

IBM
11.2017 - 06.2019

Senior Data Analyst

Indium Software (India) Pvt Ltd
3 2023 - Current

Mohan MyakalaSenior Data Analyst