Overview
Work History
Education
Skills
Timeline
Summary
Generic
Bhanu Suraparaju

Bhanu Suraparaju

Milwaukee,Wisconsin

Overview

6
6
years of professional experience

Work History

Technology Analyst

Infosys Ltd.
06.2022 - 01.2024
  • Involved in full project life cycle implementation (requirement gathering to production) QlikView and Qlik Sense dashboards
  • Involved in designing the data models, extracting & transform the data from heterogeneous data sources like QVD les, Excel, SQL Server, binary QVW, Inline & txt lies in creating the QlikView and Qlik Sense dashboards
  • Connected to different ODBC, OLE DB data sources (SQL Server) and at last create and scheduled different complex reports as per given business requirements by leveraging the basic components of Qlik Sense
  • Created multiple tab dashboards
  • Created Pivot tables, Trend graphs, Bar graphs, Stacked Graphs, containers and so on
  • Extensively worked with Qlik Sense functions, objects, Set Analysis, and Variables to generate different kinds of charts
  • Also generated QVD les by writing scripts in Qlik Sense applications
  • Worked on Qlik sense new objects Maps, KPI and object and document extensions for wire frames, and proof of concept applications
  • Worked on NPrinting Tool and created Pixel Perfect customized reports as per the client requirements using the rich NPrinting reporting features
  • Distributed QS reports using NPrinting in the form of Excel/PDF/Power Point/Word etc
  • To users
  • Gathered report requirements and determined the best solution to provide the results in Power BI reports to support organizations strategic decisions
  • Worked on DAX query to create calculated columns and calculated measures based on Requirements
  • Developed Power BI dashboards, visualizations, and interfaces with SharePoint and SSRS to deliver meaningful and actionable insight
  • Set up and ran Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway
  • Published Power BI Reports in the required originations and made Power BI Dashboards available in web clients
  • Involved in creating data visualizations like Clustered Column Chart, Line Chart, Slicer, Gauge Visualization etc
  • With Power BI
  • Utilized Power BI gateway to keep dashboards and reports up to date with on premise data sources
  • Developing visual reports, dashboards and KPI scorecards using Power BI desktop Integrate Power App with Power BI to enable the write back feature from Power BI
  • Sharing of Power BI reports and managing workspaces in Power BI service
  • Developed custom Power Apps and Power Automate Flows to automate business processes and streamline operations
  • Created views, triggers, user defined functions to incorporate the flow of business and automated stored procedures
  • Coded and tested SQL queries based off the persistent table using Inline Views, Dynamic SQL, Merge statements
  • Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.

Data Analyst

Rock Technologies
10.2017 - 06.2022
  • Worked as a technical resource for specific departments or functional areas
  • Worked cross-functional with leadership, program managers, and other stakeholders to understand and achieve business priorities
  • Developed Migration project from Qliksense to Tableau
  • Develop, maintain, and manage advanced reporting, analytics, dashboards, and other BI solutions
  • Elicit business requirements and develop measurement plans for strategic programs
  • Collect and analyze data through manual and automated collection methods
  • Having knowledge in Tableau prep builder
  • Translate abstract data into easily digestible and highly visual Tableau dashboard applications and executive-level report deliverables
  • Collaborate with other analysts, data engineers, and data scientists to provide exceptional customer support to our internal stakeholders
  • Analyze large data sets and translate abstract data into highly visual and easily digestible
  • Developing new versions of reports in Tableau by loading different types of data sources
  • Analyzed existing requirements with end user and documented them for Tableau
  • Created different Action filters, Parameters, and calculated fields to create the most complicated dashboards
  • Created Hide/Show condition sheets based on business requirements
  • Working on new requirements, new enhancement in developed tableau applications and doing monthly and quarterly maintenance of existing tableau dashboard
  • Worked with Tableau administrator in managing Production, Test and Development environments
  • Creating user groups, adding users into them, and providing permissions/access to respective groups to specified tableau applications at screen level
  • Involving daily manual refreshing all tableau dashboards once backend final Reporting table is got refreshed
  • Automated most of the dashboards as part of daily refresh
  • Involved in Row Level Security (RLS) and Column Level Security (CLS) tasks in tableau applications
  • Worked End to End project (Developing, SIT, UAT, Testing, Production, Admin Related tasks, creating user groups, providing permissions to users for specified screen level)
  • Involving Tableau Production Deployment
  • Providing Tier 1 support for Tableau issues reported by departmental or group personnel
  • Providing all users permissions on tableau server
  • Highly skilled Tableau Administrator with extensive experience in developing and implementing data visualization solutions that drive business growth
  • Proven track record in optimizing Tableau Server performance, reducing server downtime, and improving data accuracy and availability
  • Perform and document data analysis, data validation, and data mapping/design
  • Review and improve existing systems and collaborate with teams to integrate new systems
  • Conduct unit tests and develop database queries to analyze the effects and troubleshoot any issues
  • Troubleshoot and resolve Tableau Server issues
  • Develop and maintain Tableau security roles and permissions
  • Develop and maintain Tableau workbooks, Tableau data extracts, Tableau data visualizations, Tableau data models, Tableau calculations, Tableau data blending
  • Setting up the Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway
  • Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI
  • Created Power BI Visualizations and Dashboards as per the requirements
  • Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc
  • In Power BI
  • Designed and developed Tabular Model Cubes
  • Developed calculated columns and measures using complex DAX
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server, and Flat files
  • Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic
  • Created SSIS packages to integrate the data coming from flat files
  • Migrated SSIS Packages from old to new versions during data migration
  • Optimized queries by looking at Execution Plan for better tuning of the database
  • Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports
  • Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services
  • Created SSIS packages for loading data from SAP BW/BI to SQL Server
  • Performed database backup and deployment to the production server
  • Involved in modifying existing DataStage and Informatica Jobs for better performance
  • Worked on POC to migrate existing on-premises BI platform to Azure Cloud
  • Worked on Azure cloud in spinning of new resources under resource group
  • Worked on Azure Data factory to load the data from on premise to Azure Data Lake.

Education

Bachelor of Science - Electrical, Electronics and Communications Engineering

Sree Vidyanikethan Engineering College
Tirupathi, India
06.2017

Skills

  • Power Bi
  • Qlik Sense
  • Qlik View
  • Tableau
  • SQL
  • Windows
  • Visual Studio
  • Github

Timeline

Technology Analyst

Infosys Ltd.
06.2022 - 01.2024

Data Analyst

Rock Technologies
10.2017 - 06.2022

Bachelor of Science - Electrical, Electronics and Communications Engineering

Sree Vidyanikethan Engineering College

Summary

  • Over 8+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, Azure SQL Cloud and all MSBI tools including Power BI.
  • Self-Motivated and possess the ability for critical thinking, analysis, good interpersonal, time management, multi-tasking, and communication skills. Ability to work effectively as a team member and individually. Strong written, verbal communication, and presentation skills. Pragmatic thinker, able to balance user requirements while delivering excellent technical solutions.
  • Hands on experience in MS SQL Server 2016, 2014, 2012 with Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services. Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
  • Experience in Handling Heterogeneous data sources, databases Oracle, IBM DB2, Teradata, and XML files using SSIS. Experience in data migration between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
  • Strong experience in Design, Development, and Deployment of the SSIS packages and SSRS reports using SQL Server DATA Tools 2012/2014/2016.
  • Expert knowledge in SQL Server Package Configuration technique to make Dynamic configurations for SSIS packages and Project deployment model in SQL Server 2012/2014/16.
  • In-depth understanding in client requirement Analysis, Logical design, development, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2016, 2014, 2012, DTS, SSIS, SSAS and SSRS.
  • Hands on experience with SQL programming and Transact-SQL in creating tables, Stored Procedures, triggers, cursors, user-defined functions, views, indexes, user profiles, relational database models, and Complex SQL Queries with inner and outer joins.
  • Experience in tuning the reports that include modifying, testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.
  • Experience in OLTP/OLAP environment and Data Warehouse. Over 8+ years’ experience in Information Technology with proven ability to implement Qlik Business Intelligence solutions aligned with business objectives and innovative analytical reporting.
  • Capable of managing projects while leading cross-functional teams and competent in all aspects of Qlik Development, Administration implementation, Deployment, Testing, and Migration.
  • Around 6+ Years of IT experience in Analysis, design, development administration, and implementation of QlikView and Qlik Sense applications. Extensively worked on QlikView to implement applications as per client requirements.
  • Expertise in QlikView/Qlik Sense performance optimization, QlikView Management console, QlikView Administration, and QlikView Data Modeling.
  • Strong experience in designing and developing dashboards using QlikView/Qlik Sense by extracting data from multiple sources (Oracle, Flat files, Excel, Access).
  • Extensive experience with QlikView sheet objects, scripting, and optimizing applications, and building QVD’s and QVW’s. Worked on different QlikView objects like straight tables, line charts, bar charts, pivot tables Etc.
  • Involved in the Optimization of QlikView Dashboards with a focus on Visualization, usability, Performance, Long- term, Flexibility, Accuracy, and Standardization.
  • Extensive Experience with QlikView sheet objects including multiple chart types, Trends, KPIs, custom requests for Excel Export, Fast Change, and other objects for the Management Dashboard reporting.
  • Extensive Experience in developing User Interfaces and QlikView Dashboards using several sheet objects Chart- Box (Drill Down and Cyclic Group), List Boxes, Input Fields, Table Boxes, Calendars, and Date Islands.
  • Strong Experience in working with various Charts (Pivot Tables, Straight Tables, pie charts, Gauge- Charts, line charts, combo charts, bar charts, scatter charts).
  • Good experience in using the functionality Join, Concatenate, and Keep in the preparation of the QlikView data model.
  • Comfortable using various sources like QVD files, MS Excel, Relational Tables, Binary QVW, Inline, and Txt files in developing the QlikView reports.
  • Developing new versions of reports in Tableau and Qlik by loading different types of data sources. Develop and maintain Tableau dashboards, reports, and data visualizations based on business requirements and data sources.
  • Having knowledge into Tableau Prep.
  • Having knowledge into Cloud Computing tools such as AWS S3, EC2, Redshift & EMR.
  • Having experience into migration project from Qliksense to Tableau and involved into other migration projects like changing the connections string from Hive Data base to Redshift SQL.
  • Combine all the files together into one Input step in Tableau Prep. Professional experience in developing Tableau dashboards and data visualizations.
  • Analyzed existing requirements with end user and documented them for Tableau. Strong proficiency in Tableau Desktop, Tableau Server, and Tableau Online.
  • Solid understanding of data visualization best practices, design principles, and user experience. Create efficient and optimized Tableau data models and data connections for different data sources, ensuring data accuracy and performance.
  • Monitor and maintain Tableau Server performance.

Similar Profiles

CREATE PROFILE
Bhanu Suraparaju