Summary
Overview
Work History
Education
Skills
Timeline
SeniorSoftwareEngineer

Naga Raju Raghavapurapu

Senior Software Engineer (Tableau Developer/ Qlik Sense/OBIEE)
Cary,NC

Summary

PROFFESIONAL SUMMARY: Over 10 years of Combined Industry experience as a Business Intelligence Solution expert with High Proficiency in BI Reporting end to end analysis, design, development and delivery using BI and ETL tools such as OBIEE, Tableau Developer & Qlik sense Developer, Big Data Developer, Scala, Spark, Cloud Support Engineer along with Data Analysis/Business Analysis. System Analysis & Design, Development, testing and implementation of BI/Data Warehousing projects using Tableau, Micro Strategy, Domo, etc. in Insurance, Finance, Banking. Strong Understanding of software Development Cycle (SDLC) phase such as Requirement analysis, Design, Development, Testing and Deployment of Business Intelligence and Database Platforms. Extensive experience in creating UI visualizations with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 2022, 2021, 2020,2019,2018 ,10.x/9.x/8.x/7.x/6. x/5.x/4. x. Implemented Migration Projects from OBIEE to Tableau. Implemented Migration Projects from Tableau to Qlik sense. Skilled in Tableau Reader, Tableau Desktop for data visualization, Reporting and Analysis; Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart. Expertise in designing and creating various analytical reports and dashboards to help us to identify critical KPIs and Facilitate strategic planning in organization. Expertise Configuring Repository, Create/Manage Dashboards, Reports/ Answers and Building Physical, Model and Presentation Layer. Strong knowledge on Hadoop Architecture and Impala Dameon’s such as HDFS, JOB Tracker, Task Tracker, Name None, Data Node and Map Reduce Concepts. Involved in trouble shooting of performance issue which were associated with Tableau Reports. Also Involved in administration tasks such as publishing workbooks, setting permissions, Managing ownerships, providing access to the users and adding them specific AD Groups and scheduled instances for reports in tableau server. Used Scala sbt to develop Scala coded spark projects and executed using spark submit. Hands on experience in Azure Development, worked on AZURE web application, App Services, Azure storage, Azure SQL Database, Virtual Machines, Fabric Controller, Azure AD, Azure search, and notification hub. Extensive involvement in Designing Azure Resource Manager Template and in designing custom build steps using PowerShell. Design and developed Cloud services projects and deployed to Web Apps, PaaS and Iaas. Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall Methodologies, Agile, and Scrum. Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making. Conducted Gap Analysis, created Use Cases, workflows, screen shots and Power Point presentations for the Web Applications. Interviewed SMEs and Stakeholders to get a better understanding of client business processes and authored Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications. Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making. Proficient in creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bubble Charts, Funnel Charts, Bar Charts (Horizontal, Stacked), Bullet Graphs, Area Charts, Scatter Plots, etc. Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports. Exceptional experience in dealing with various databases like Teradata, Hive, Impala, Oracle, DB2, SQL Server, MS Access, and Flat files. Extensively built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data-using Tableau. Experience in Developing, Designing and Support inter active Tableau dashboards. Knowledge in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.l Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R2/2012. Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export. Experience in developing and debugging Stored Procedures and Triggers. Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs. Used tools like MS SQL Profiler, Index Tuning Wizard, Pervasive and Windows performance for monitoring and tuning SQL Server performance. Excellent hands-on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS. Experience in working with different type Dirty Data from Different sources. Experience in working with Data Cleansing technique in ETL procedures. Experience in working with Self Service MS BI end user tools such as Excel 2010 (Power pivot), Performance Point Server (PPS), Power view. Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau. Knowledge Microsoft Power BI, Data zen, DAX expressions, Power View and Power Query integrated with share point. Experience in developing OLAP Cubes by using SQL Server Analysis Services, and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles. Excellent hands-on experience in creating groups and measures, KPIs. Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results. Flexible, enthusiastic and project-oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client. Creating data visualizations and building interactive dashboards using techniques like guided analytics and visual best practices provided by Tableau, which helped the business, get a good handle on the team's productivity. Experience on using tools like Tecta and Putty for Query handling.

Overview

10
10
years of professional experience

Work History

Tableau / Data Engineer Developer

CREDIT SUISSSE
New York
03.2016 - Current
  • Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Tableau
  • Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements
  • Prepared Tableau reports in various subject areas like Materials Procurement Savings, Bill of Materials, Customer Service Index, Employee Productivity and Employee Safety
  • Played critical role in establishing best practices for tableau reporting by conduct meeting with the clients for gathering reporting requirements; identify the KPI’s and developing POC Dashboards
  • Involved in developing a linear regression model to predict a continuous measurement for improving the observation on wind turbine data developed using spark with Scala API
  • Developed Hive Queries for the Analysts
  • Used Spark and Spark-SQL to read the parquet data and create the tables in hive using the Scala API
  • Involved in converting Hive/SQL queries into spark transformations using Spark RDD’S
  • Experienced in working with spark eco system using spark Sql and Scala queries on different formats like text file, CSV file
  • Used Scala Sbt to develop Scala coded spark projects and executed using spark submit
  • Good experience in writing spark applications using Python and Scala
  • Implemented Spark using Scala and utilizing Data frames and Spark Sql API for faster processing of data
  • Expertized in implementing Spark using Scala and Spark SQL for faster testing and processing of data responsible to manage data from different sources
  • Designed and Configured Azure
  • Deployed and Configured Azure Virtual Networks (Vnets), subnets, Azure network settings, DHCP address blocks, DNS settings, Security polices and routing
  • Exposed virtual machines and cloud services in the Vnets to the internet using Azure External Load Balancer
  • Worked on Microsoft Azure (Public) Cloud to provide IaaS support to client
  • Create virtual machines through PowerShell Script and Azure portal
  • Responsible for estimating the cluster size, Monitoring, and troubleshooting of the Spark data bricks Cluster
  • Experience in developing Spark applications using Spark-SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats for Analyzing & transforming the data uncover insights into the customer usage patterns
  • Developed Complex dashboards and used advance chart visualizations in Tableau like Pareto Chart, Dual Water Fall charts, Axis, Bullet Graphs, Bubble Charts, etc
  • To assist business users in solving complex problems
  • Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes
  • Groups, hierarchies, sets to created summary level and detailed Reports
  • Connected Tableau server with SharePoint portal and setup auto refresh
  • Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports
  • Wrote Custom SQL scripts for creating aggregate tables and generating views
  • Worked on understanding of relational database structures, theories, principles and practices
  • Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access
  • Created Data extract for cloudera odbc data source and pulled the data through Tableau to create the Interactive Dashboards and Storyboards
  • Worked with Microsoft Power BI, Data zen, DAX expressions, Power View and Power Query integrated with share point
  • Successfully administered users, user groups, and scheduled instances for reports in Tableau
  • Upgraded Tableau server from 8.0 to 9.0 in DEV and QA along with Migration of reports
  • Developed a SSB BI Landing Page for all the reports and authored user guides of Tableau reports for the user community
  • Designed and developed various analytic reports / dashboards using Tableau
  • Participated in RAD sessions with the stakeholders and technical units for business requirement gathering followed by Agile approach
  • Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement
  • Built Complex Reports using advanced reporting functions like with YTD calculations, MTD calculations, percentage differences, sets and groups etc
  • In Tableau
  • Built Excel, Qlik View and Domo reports in tableau
  • Involved in dashboards on SAP HANA views and publishing the HTML files/reports back to XS server on SAP HANA
  • Developed and documented technical architecture, system design, performance test results and other technical aspects of the implementation
  • Resolved various performance issues and analyzed the best process distribution for different projects
  • Assisted power users in Tableau dashboard development
  • Administered user, user groups, and scheduled instances for reports in Tableau
  • Administered and provided production support for Enterprise-wide Tableau application consisting of multiple key functional business domains
  • Environment: Tableau (Desktop/Server), Teradata, Hadoop, Hive, Teradata SQL Assistant, Python, Teradata Administrator, Adobe Analytics, Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint).

Tableau Developer

USINE Technologies
Hyderabad
06.2011 - 05.2014
  • Responsible for gathering/refining requirements from the customer for developing reports in Tableau
  • Worked closely with end users in identifying and implementing right set of business criteria to convert raw data into meaningful information
  • Collaborate with business leadership to identify potential areas of analysis
  • Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports
  • Prepared dashboards using calculated fields, actions, parameters, groups, sets and hierarchies in Tableau
  • Created Webi reports using custom SQL queries and converted them to tableau dashboards for advanced visualizations
  • Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc
  • In a single dashboard by using parameters
  • Displayed multiple measures like Individual Axes, Blended Axes, and Dual Axes
  • Effectively used data blending feature in Tableau to combine the data from different sources like Adobe marketing cloud into a single report
  • Defined best practices for Tableau report development
  • Designed multiple dashboards for CDI, helping them to convert from manual reporting
  • Found efficient ways to make tables and graphs that were visually easy to understand and at the same time maintaining the accuracy of the core information content
  • Designed and developed various complex SQL Queries, Stored Procedures, Views, and User Defined Functions to implement the business logic
  • Used SQL queries at the custom SQL level to pull the data in Tableau desktop and validated the results in Tableau by running SQL queries in Teradata SQL Assistant
  • Presented the findings, graphs to c- suite, replicating the process across various customer segments
  • Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created Tableau functional design document
  • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop
  • Administered and provided production support for enterprise-wide Tableau application consisting of multiple key functional business domains
  • Participated in the retrospective meetings and next sprint planning meetings.

Education

Masters - Information Systems

Stratford University

Bachelor - Mechanical Engineer

JNTU K University

Skills

TECHNICAL SKILLSundefined

Timeline

Tableau / Data Engineer Developer

CREDIT SUISSSE
03.2016 - Current

Tableau Developer

USINE Technologies
06.2011 - 05.2014

Masters - Information Systems

Stratford University

Bachelor - Mechanical Engineer

JNTU K University
Naga Raju RaghavapurapuSenior Software Engineer (Tableau Developer/ Qlik Sense/OBIEE)