Name: SIVA NAGA SRIKAR YANDAPALLI

Cell : 732-***-****

Email: acx3sx@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/srikarsiva

Summary of Experience:

Over all 8 years of experience in analysis, design and development and administrating reports using Tableau.

Wide knowledge and experience using MSSQL Server, DB2, Pervasive SQL, and, Oracle 11.

Experience in SQL server all version including 2012,MSBI-SSAS (SQL Server Analysis Service), SSIS (SQL Server Integration Service), SSRS (SQL Server Reporting Service),

Experience working with Tableau 7.x 8.x and 9.X.

Interacted with IT and Business Team at various levels and coordinated meetings during the different cycles of the project.

Tableau development skillset including visualization development, use of parameters, and report optimization.

Security configuration including user/group setup, permissions, security roles, configuration of trusted ticket authentication

Experience with designing complex dashboards taking advantage of all tableau functions including data blending, actions, parameters, etc.

Develop canned / Ad-Hoc reports and complex dashboards in Tableau as needed.

Ability to use custom SQL for complex data pulls

Good knowledge of tableau server, administrative functions, installation

Supported the development of Data Warehousing and BI solutions in support of the cross-functional teams

Designed and lead development of a state-of-the-art dashboard

Experienced in working on Tableau (Desktop, Server, Reader), creating Dashboards and Reports using different functionalities

Create a wide variety of analysis including comparisons, trending and what-if analysis.

Proficient with Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, Density Chart, etc.

Experienced in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.

Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.

Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

Develop and generate standard and ad hoc reporting capabilities from new and existing data sources

Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.

Experienced in developing rich Interactive report, dashboards and other user interface elements integrating various reporting components from multiple sources.

Experience in dynamic fields and dynamic filters, dynamic sort.

Publish a visualization to Tableau Server

Include data extracts and schedule updates when publishing to Tableau Server

Have strong knowledge of database management in writing complex SQL queries.

Extracting data from different sources connecting them and used the same to create dashboards.

Created visually compelling and actionable interactive reports and dashboards

Extensive experience database trouble shooting and performance tuning.

Complete basic installation of Tableau Server

Find the minimum requirements for installing Tableau Server

Manage product keys.

Experience in Development and Support of Business Intelligence and reporting solutions

Strong SQL Skills related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.

Technical Skills:

Tools

Tableau Desktop 9.X/8.X/7.X, Tableau Server, Tableau Reader, SAP BO,SSRS,SSIS,SSAS

Operating systems

Windows XP, Windows Server 2003/2008, UNIX

RDBMS

Oracle, SQL Server, MS Access

Languages

SQL, HTML, C

Methodologies

Complete Software Development Life Cycle, Waterfall, Agile, Iterative, Scrum

Professional Experience:

Client : Advocate Health, Chicago, IL

Period : Sep 2016 – Till Date

Role : Sr. Tableau Consultant

Roles and Responsibilities:

Involved in publishing of various kinds of live, interactive data visualizations dashboards, reports and workbooks from Tableau Desktop.

Created connections to Hadoop Hive and work with data/time data as well as test the connection Hadoop cluster.

Gathered user requirements analyzed and designed software solution based on the requirements.

Created dashboards to track the financial assets so that we can manage the assets according to location.

By delinquency dashboard we can monitor and view through location and time.

Worked on LOD 's and Parameters and filters. Worked on Excel based reports used power pivot.

Maintain Traffic and deployment of dashboards on to web using Tab server. Experience in developing various reports like List reports, Crosstab reports, Maps. Import Users from various sources. Configuring failover and gateways.

Enabling security to the VIZ. Backup Extracts and refreshing extracts and creating backups.

Worked on Tableau server for dashboard publications.

Worked on deployment of reports using REST services, JavaScript.

Used Custom SQL filters to connect to oracle database.

Worked with Netezza database to implement data cleanup, performance-tuning techniques.

Experience with Netezza Database integration with Informatica and load process with Netezza bulkload utilities like Netezza Bulk reader and Bulk writer.

Designed and developed interactive dashboard.

Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.

Client: CNO Financial Group, Carmel, IN.

Period: Dec 14 – Aug 16

Role: Tableau Consultant

Roles and Responsibilities:

Participated in the user requirement gathering and Design meetings.

Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.

Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Administered Sites, user, user groups, and scheduled instances for reports in Tableau.

Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Effectively used data blending feature in tableau.

Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters using SQL Server Reposting Services (SSRS).

Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Drill down Reports.

Designed Complex SSIS packages to load the data from different sources like Oledb, Excel, Flat Files and DB2 etc. into various Data warehousing system.

Interacted with offshore BI development team, for distribution of work.

Translate business needs into reporting and analytic requirements.

Build interactive dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently

Worked on the development of Dashboard reports for Key Performance Indicators for the top management

Rebuilding existing Reports into Tableau Visualizations with user and action filters.

Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle).

Ensured data accuracy and reliability of reports.

Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and MS Excel.

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Interacted with customers on a regular basis to resolve issues.

Created custom SQL connections and calculated fields within Tableau to facilitate automated production of data visualizations

Published Workbooks by creating user filters so that only appropriate users can view/edit them.

Generated context filters and handled performance issues while dealing with huge volume of data.

Generated tableau dashboards with forecast and reference lines.

Environment: Tableau Desktop 9.3, Tableau Server, Tabadmin, Tabcmd, Tableau Data Engine,SSRS,SSAS,MS Office Suite, SQL Server R2, Oracle, MS Excel.

Client : TD Bank, NY.

Period: Feb 13 – Dec 14

Role : Tableau Developer/Data Analyst

Roles and Responsibilities:

Reported directly to the Senior Manager for EDW and Business Reporting.

Designed and perfected the reporting requirement documents and the tracker logs to track and assign the work packets until they get completed /resolved.

Design Microsoft SSIS ETL Framework to perform tasks synchronously and/or asynchronously.

Worked on MDX Cubes for analysis of the data.

Load data from various sources: Excel, SharePoint 2010, SQL 2008 R2 database, Tom-Tom API. Move data to staging Database apply business rules and Validations along with distribution of error report.

Design and maintain SSRS Reports with stored procedures and SSAS cubes as data sources.

Created Schedules and Extracted the data into Tableau Data Engine.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps

Effectively used data blending feature in tableau.

Defined best practices for Tableau report development.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Converted Metric insight reports to tableau reports.

Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.

Involved in Creating the Schema objects i.e. Attributes, Facts, Hierarchies and Transformations.

Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.

Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.

Used Drilling, pivoting, formatting, page-by, thresholds on the reports.

Generated reports by using custom groups and included consolidations in order to group attributes and customize the reports.

Environment: Tableau 8.2, SAP BO,SSRS,SSAS,Teradata Tableau Server, MS Office Suite, Oracle, SQL, PL-SQL, TSQL, SQL Server 2008, MS Excel.

Client : Thomson Reuters Corporation, New York, NY

Period: Jun 2011 – Feb 2013

Role : Tableau Developer/Data Analyst

Roles and Responsibilities:

Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing and production rollover of reporting and analysis projects within Tableau Desktop.

Design SSRS Reports to test Cubes. And generate data validation reports to monitor daily changes that occurred to Master Data. Tableau 8, reports to validate visualization using cube.

Interacted with business users and performed Gap Analysis of Client requirements.

Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.

Worked closely with business users to create reports/dashboards using tableau desktop.

Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.

Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

Make use of filters and making them local and global accordingly.

Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server.

Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.

Provided customer support to Tableau users and Wrote Custom SQL to support business requirements

Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.

Actively participated in clarification meeting with the Clients.

Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Environment: Tableau Desktop 7 & 8.X, Tableau Server, SQL Server 2008/2012SQL and PL/SQL.

Client : Satyam Computer Services Ltd/Tech Mahindra

Period: Apr 2010- May 2011

Role : Scotia Bank, Report Developer.

Roles and Responsibilities:

Documented and translated business rules from IBM Mainframes into detailed and enhanced version of the distributed environment rules.

Participated in system design and feasibility analysis discussions.

Worked on Data mappings in excel as well as Informatica Data Quality tool to deliver the application level specific rules to the developers.

Analyzed Data Specification Documents (DSDs) and implemented their logic in the form of Informatica mapping design.

Worked with complex Join rules to maintain the integrity between the older versions of the data to the distributed environment.

Involved in creating the Data Flow Diagrams (DFD) in Visio based on the architecture diagram of the application.

Worked on Erwin Data modeler tool to keep track of all changes from ETL perspective and involved in data modelling to update the changes.

Performed extensive analysis of the already existing models and mock-up reports.

Environment: Erwin Data Modeler, MS SQL Server 2008, COBOL, JCL, Syncsort, VSAM, MS Visio and MS Excel.

Client : Satyam Computer Services Ltd/Tech Mahindra

Period: May 2008 – Mar 2010

Role : Database Analyst

Roles and Responsibilities:

Generated reports using SQL from Oracle database, which were used for comparison with legacy system and created Temporary Tables to store the data from Legacy system.

Identified the Objects and relationships between the objects to develop a logical model and translated the model into physical model using Forward Engineering in ERWIN.

Transformations including aggregation, summation construct from operational data source to Data Warehouse.

Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management.

Developed and Monitored the Workflows and responsible for performance tuning of the staging and 3NF workflows.

Designed Data Marts using dimensional modeling and wrote PL/SQL ETL packages with Oracle PL/SQL to extract data from relational data.

Implemented Referential Integrity using primary key and foreign key relationships.

Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions.

Created Entity-Relationship diagrams, Functional Decomposition diagrams and Data Flow diagrams.

Denormalize the database to put them into the star schema of the data warehouse.

Conducted logical data model walkthroughs and validation.

Environment: Erwin r8.2, Oracle SQL Developer, Oracle Data Modeler, SQL Server 2005/2008, Windows XP and MS Excel.

Contact this candidate