Resume

Sign in

Data Sql Server

Location:
Carmel, Indiana, United States
Posted:
February 20, 2018

Contact this candidate

Resume:

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.



Contact this candidate