Shiva Korrapati
Tableau Developer
Email: ac4jmc@r.postjobfree.com
Ph: 773-***-****
Summary
Tableau Developer with 7+ years of experience in IT industry in creating and implementing effective strategies for developing Business Intelligence and Data with good background in Databases and Data warehousing concepts.
Worked closely with Business during conversion of Business objects reports and dashboards to tableau.
Created Dashboard's using multiple BI Tools with Drill-Down capabilities using Dashboard prompts, Local and Global Filters.
Excellent understanding of concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases and MS Access
Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
SQL Server and Oracle Database development experience using tables, triggers, views, packages and stored procedures in PL/SQL & T-SQL. Strong RDBMS fundamentals.
Experience in managing Repository, Sources, Target Databases and developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
Configured the tableau server to use active directory authentication so that the client`s users could directly log in.
Experience with different SQL server business intelligence tools such as SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),
Implemented flexible view of dashboard by using Datazen and tableau.
Involved in almost most of the concepts in tableau like sets, grouping, parameters, highlight actions, Calculated fields
Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.
Created relationship between two different Data Source's by using Data- blending.
Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
Improved Reports performance in tableau using extracts and context filters.
Built reports using Tableau using Excel and Qlikview.
Determines the requirements of the business, user and also produced the workflow process and diagrams with the help of Microsoft Visio and other Microsoft applications.
Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills
Education:
Bachelors from Kakatiya Institute of Technology and Science, Warangal
Technical Skills:
BI tools
Tableau (Desktop & Server) 10.x/9.x/8.x, Alteryx, Business Intelligence Development Studio SSIS/SSRS
Business Analysis
Requirement analysis, data flow diagram, flowcharts, business process modeling & improvement, functional requirement Analysis, source to target mappings, gap analysis, cause and effect analysis, decision tree.
Methodologies
UML, Agile Modeling, SDLC model, Waterfall model, Spiral model, Use Cases
Office Suite
MS Office, MS Excel, MS Word, MS Visio, MS Project, Outlook, Open Office
Programming
C, C++, Java, Visual Basic, UML, SQL and T-SQL
Databases
MS Access, MySQL, SQL, XML, PL/SQL, Oracle, Teradata
Operating Systems
WIN XP, WIN 2000, Windows NT 4.0, Linux, Unix
Data modeling
ER Diagrams, Conceptual, Logical & physical modeling.
ETL Tools
Talend, SSIS
Client: TIAA, Charlotte, NC Jan 2016- Present
Title: Tableau Developer
Responsibilities:
Involved in Business meetings that involve Planning, Defining and Designing data based on the requirements of the business and provide them with necessary documentation.
Investigated the possible reasons behind the fallout in the dollar amount in core to cash process.
Documented the possible scenarios for fallout and prepared wireframes for the Dashboard.
Involved with backend Database team to prepare Fact Table as required for the development of dashboard.
Worked both on Tableau Desktop and Tableau Server.
Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.
Optimized Indexes, Views, Stored Procedures and Functions using T-SQL.
Created Schedules and Extracted the data into Tableau Data Engine.
Involved in almost most of the concepts in tableau like sets, grouping, parameters, highlight actions, Calculated fields
Used Data Blending concept to join different tables as required.
Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
Worked on Alteryx to prepare Ad-hoc reporting based on the given specifications and requirements.
Developed different Dashboards for different levels to capture fallout.
Automated the schedules so that new data refreshes automatically.
Connected Tableau to Amazon Redshift cluster which allowed to easily access the cloud storage and perform data visualization for that cloud data.
Worked on Agile Environment
Environment: MS SQL Server 2012, Tableau, Tableau Server, Alteryx, Oracle, T-SQL Microsoft Excel, Amazon Redshift
Client: PNC Bank, Pittsburg, PA July 2014– Oct 2015
Title: Tableau Developer
Responsibilities:
Involved in requirement s gathering for the development in Tableau
Worked with Backend team to understand the data extensively
Developed Engineering Dashboard implemented Drill across and drill down functionality by using Dashboard actions.
Worked on Tableau Desktop
Used talend to create Source to Target mapping documentation that allows the system to properly extract the data and use it as input data for Tableau.
Involved in almost most of the concepts in tableau like sets, grouping, parameters, highlight actions, Calculated fields
Implemented Donut chart to study Network Health across all regions.
Implemented Control chart to study the health conditions on different dates across all regions
Implemented Bar chart to find out the top problem causing metrics on overall Health condition.
Presented the Dashboard to client by visualization Techniques so as to have nice look and feel.
Provided Tableau training for the functionality on Dashboard.
Environment: Tableau, Talend, Microsoft Excel
Client: Chase, Columbus, OH Dec 2013–June 2014
Title: Tableau Developer
Involved mainly in creating financial static reports, worked on Tableau Desktop and Server
Responsibilities:
Involved in requirement s gathering for the development in Tableau
Worked with SAS team to understand the data extensively
Involved in building financial reports in Tableau so as to have nice look and feel.
Worked both on Tableau Desktop and Tableau Server
Involved in almost most of the concepts in tableau like sets, grouping, parameters, highlight actions, Calculated fields
Worked on one of the largest dashboard in tableau 9*9=81 sheets dashboard where we utilized maximum size of the dashboard
Involved in data blending with dummy data to have perfect alignment of rows and columns
Created static customer list as per the requirement
Worked on Agile Environment
Environment: Tableau, SAS, Tableau Server, Microsoft Excel
Client: RCR Technology Corp, Indianapolis, IN Jan 2013 – Nov 2013
Title: Tableau Developer
Responsibilities:
Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
Wrote SQL queries for producing data for reports.
Designed and developed two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes. .
Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
Participated in preparing detailed technical documents from the functional specifications.
Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
Created Complex workbooks and Dashboards by connecting to multiple data source using data blending.
Created Tableau scorecards, dashboards, Heat maps using show me functionality.
Good Experience in publishing reports and dashboards to Tableau server.
Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
Published Reports, workbooks & data source to server and exporting the reports in different Formats.
Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.
Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
Environment: Tableau, Talend, SQL Server, T-SQL, Microsoft Excel.
Client: Tech Mahindra, Hyderabad, India Oct 2010–Jan 2013
Title: Business Objects Developer
Roles and Responsibilities:
Analyzed business needs, created and developed new functionality to meet real time data integration that facilitated decision making.
Involved in information gathering from end user and analyzing the data to developed ER diagram, data dictionaries, and flow charts.
Actively participated in the requirement analysis, database design and modeling.
Designed universes, classes, checked cardinalities and detecting loops using Business Objects Designer.
Created and configured database for development and production environments in SQL Server.
Created tables in SQL Server 2000
Developed stored procedures and database triggers using SQL Server.
Database and log backups & restoration, backup strategies, scheduling the backups. Backing up System & User Databases and restoring them when necessary.
Loaded the SQL Server database using Bulk Export and Import.
Created database for production environment In SQL.
Environment: SQL Server 2000, Business Objects.