Vamshi

Senior Tableau/Power BI Developer

Email: ade3wu@r.postjobfree.com

Phone: (210) - 714 - 0281

SUMMARY

8+ years of IT industry experience in implementing all phases of the Software Development Life Cycle (SDLC), including Business Requirements Gathering, Design, Development, Testing, and Implementation of Data Warehousing/Business Intelligence Applications.

Extensive experience in Tableau Desktop, Server, Reader, Public and Mobile in various versions of Tableau 6.x/7.x/8.x /9.x/10.x (Desktop, Server, Reader, Mobile) as a Developer and Analyst.

Expertise in Power BI, Power BI Pro, Power BI Mobile.

warehousing, Data mining, DBMS and Data Modeling using Confidential SQL Server 2014/2008 R2, SSIS, SSRS and SSAS.

Expertise in OLAP and OLAP Cubes in SSAS.

Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.

Expert in creating and developing Power BI Dashboards in to rich look.

Knowledge in all types of Database migrations with all the versions of SQL Server.

Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations.

Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.

Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.

Developed OLTP system (s) and involved in creating facts, dimensions and Star Schema representation for the data mart.

Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.

Strong knowledge of Business/Process Data flow in organizations and experienced in Data modelling concepts.

Sound knowledge of Health Care,Technology,Retail, Finance domains.

Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.

Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH,SQL, Physical, logical database design and Performance tuning.

Strong understanding of Data Warehouse concepts, Star Schema, Snowflake Schema, Business Process Analysis, Physical and Logical data modeling.

Extensive experience in various reporting objects like Facts, Attributes, Hierarchies, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL, PLSQL to provide definition, structure and to maintain data efficiently.

Effectively used Data Blending feature in Tableau.

Converted metric insight reports to Tableau reports.

Strong experience in consolidating data from different data sources like Oracle, SQL, Hbase, Teradata, SQL and cloud.

Worked on different table calculations for different Scorecards.

Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and dashboard using KPI's.

Involved in license management SLA's with Tableau support.

Converted existing Crystal Reports and Xcelsius into Tableau Dashboards.

Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.

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

Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Administered (site) user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.1 to Tableau 9,10.

Built complex formulas in Tableau for various business calculations.

Resolved various performance issues and analysed the best process distribution for different projects.

Experienced in creating calculations (creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting,) using Tableau Desktop.

Strong Knowledge in all phases of Software Development Life Cycle (SDLC)of Tableau.

Extensively worked with large databases in Production environments, UAT, and DEV environments.

Identifying data for any new projects/analysis and Responsible for data quality, accuracy and timelines. Extensively worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema (in source code control) and Entity relationship diagrams from business requirements.

Interacted with the "End-Users" by interviewing them and preparing appropriate questionnaire to better understand their needs.

Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and bullet chart.

Hands on experience in writing SQL, PLSQL Queries.

Distributed Tableau reports using techniques like Packaged Workbooks, PDF etc.

Worked closely with reporting team for deploying Tableau reports and publishing them on the Tableau and Share point server.

Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation.

Experience in Migrating databases from SQL 2008 R2 to SQL 20114.

Education:

Bachelors in Computer science Engineering, JNTU, INDIA .

Technical Skills:

Operating System

Windows 95/98/2000/XP/Vista/7.

Databases

SQL Server Reporting Services(SSRS),MS SQL Server (2005/2008/2008 R2/2014), Data Transformation Services(DTS),MS-Access, SQL Server Integration Services(SSIS),Oracle 8i/9i/10g/11g, SQL Server 08/12, MS Access.

Reporting

PowerBI2.x,Tableau10/9/8.2/8.0/7.0, Cognos 8.4, Qlikview10.0, SAP BO

Visualization Tools

Power BI 2.x,Tableau 10x, 9x, 8.x, 7.x, Qlik Sense

Web Technologies

XML, HTML.

IDE

TOAD, SQL Developer.

Languages

Java, C, PL/SQL,. T-SQL, PL/SQL, SSIS/SSRS, SQL PLUS, MSSQL.

Work Experience:

Client: Merck, Branchburg, NJ Jan’2018 to till date

Role: Sr.Tableau/Power BI Developer

Responsibilities:

Effectively interacted with Business Analysts and Data Modelers to define requirement document and design processes for various data sources and reporting needs.

Gathered, Analyzed, and transformed business requirements of the Client into logical and physical BI solutions.

Analyzed the existing Tableau data model, script logics and the ETL business logic for the existing Tableau applications.

Worked with Agile, Scrum methodology in the system development process and used TFS as part of process that resulted in optimizing employee's time to finish the tasks, thus enhancing employee efficiency.

Experienced in the analysis, design, and build effort for Tableau data visualizations and created dashboards and reports that meet ongoing business requirements.

Consolidated data from Oracle, MySQL, MS Access and Excel sheets.

Built and published customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server.

Strong experience in data visualizations and built the UI as per the customer need.

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

Developed Power BI model used for financial reporting of P & L and Headcount.

Designed and documented the entire Architecture of Power bi Poc

Automated Power Query refresh using power shell script and windows task scheduler.

Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.. .

Expertise in writing complex DAX functions in Power BI and Power Pivot.

Scheduled Automatic refresh and scheduling refresh in power bi service.

Weekly presentation to the business users about the reports and their changes as required.

Worked on all types of transformations that are available in Power bi query editor

Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.

Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.

Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages.

Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.

Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager

Created Reports using Charts, Gauges, Tables, matrix.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.

Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.

Desktop which added more user-friendly navigation and drill-down features.

Worked with advance analysis such as Table Calculations, Calculated fields such as KPI's using various functions (SUM, IF, MAX, MIN, AVG, ATTR, DATE Functions, etc), Parameters, Sets, Background Images, Logos, Totals, Forecast, Trend Lines, and Dual Axis to make robust reporting.

Creatively communicate and present models to business customers and executives, utilizing a variety of formats and visualization methodologies

Involved in the installation of Tableau Desktop & Tableau Server 2018.1

Migrated Tableau server from 2018.1 to 2018.3

Administrator and Server Site Administrator (versions 8 through 10.5)

Integrated Open source analytics software R to Tableau desktop

Created Advanced Charts using Tableau Desktop like Box and Whisker plots, Bullet charts, Waterfall charts for measuring the Sales growth by different departments within the company

Worked on solving performance and limit queries to the workbooks that when it connects to live database by using a data extract option in Tableau

Worked with Microsoft Excel, relational data sources and Hive data sources to blend and create dashboards in Tableau

Worked on the installation of patches, security administration and access controls in the tableau.

Created and edited the update schedules, managed scheduled update tasks on Tableau server

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

Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.Embedded Tableau reports/dashboards on to the external web pages.

Worked closely with Java UI team to integrate Tableau reports to company web portal

Investigate new data sources and identify data quality issues and potential value

Created URL Actions to navigate from one Dashboard visual to another Dashboard for a smooth eye-catching presentation along with using Tableau Data Extracts for better performance on rendering the visualizations.

Effectively used data blending feature in Tableau when there were more than one database's involved. Wrote basic custom SQL for tables with the help of DBA and basic joins for back-end level of data blending.

Defined best practices for Tableau Report development by adhering to style guidelines and making visual pop-out. Worked with the DBA and IT to grant and administer users, user groups, and scheduled instances for reports in Tableau Server.

Executed and tested required queries and reports before publishing and performed quality analysis with data validation by comparing raw data in SQL/Excel to Tableau Dashboards.

Created Tableau Scorecards, Dashboards using stack bars, bar graphs, scattered plots, geographical maps, line/pie graphs, and gantt charts.

Environment: Tableau 10.x, Power BI 2.x Tableau Server 10.x, Microsoft SQL Server 2014, Alteryx,ERwin r8, Toad 8.7, T-SQL.

Zoetis – Exton, PA Sep‘2016 – Dec ‘2018

Role: Sr. Tableau/Power BI Developer

Responsibilities:

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

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

Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.

Experience with the design and development of Tableau visualization solutions.

Designed incremental loads to populate the data mart with checksum and timestamp techniques.

Created master-child packages to consolidate data from data sources into SQL server with execute package tasks, enabling modular programming.

Implemented package configurations on development, test, and production environments utilizing parameters.

Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.

Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.

Created SSAS cubes with KPIs and aggregation for the front-end analysis team.

Utilized multi-dimensional and tabular model in analysis services to pull and generate reports directly from in-memory from back-end relational data sources.

Designed SSRS reports for in depth business analyses.

Designed expressions to calculate, group, filter, parameterize, and format report contents.

Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau.

Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.

Provisioned VMs with SQL Server on cloud utilizing Microsoft Azure and setting up communication with the help of endpoints.

Migrated enterprise database to Microsoft Azure with Redgate and azure data factory.

Helped to develop backup and recovery strategy for databases on virtualization platform utilizing Microsoft Azure.

Perform thorough unit testing on all relevant platforms to ensure proper implementation.

Designed SSAS Cube and developed MDX queries for Analysis.

Responsible for Developing a Dashboard and preparing ad-Hock Reporting.

Working knowledge on Tableau Server / Administration.

Developed complex SQL scripts database for creating BI layer on DW for tableau reporting.

Identify new metrics and enhance the existing KPI's.

Dashboard Visualization through Tableau BI application.

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

Created actions, parameters, Filter Local, Global and calculated sets for preparing dashboards and worksheets using Tableau.

Effectively used data blending, filters, actions, Hierarchies feature in tableau.

Defined best practices for Tableau report development.

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

Executed and tested required queries and reports before publishing.

Converted metric insight reports to tableau reports.

Working extensively with Tableau Business Intelligence tool to develop various dashboards.

Working extensively using Excel to validate the data and use as the source data files.

Analyzing the data using Statistical features in Tableau to develop trend analysis.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

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 publishes or extracted to server.

Design and development of various reports and dashboards that can be easily accessible through Tableau App in I pads, iPhones, and other smart mobile phones.

Environment:Power BI 2x,Tableau Desktop, Tableau server / Administrator, Oracle 10/11g, Microsoft Excel, MS Access, Microsoft office MS SQL SERVER 2014, SSIS, SSAS, SSRS, SQL Profiler, Windows XP / NT / 2000/2003, Microsoft Access

United Airlines, Philadelphia, PA Nov ‘2014 – Aug’2016

Senior Tableau Consultant

Responsibilities:

Involved in translating the business questions and business requirements to actual and final dashboard technical requirements

Used Tableau for the data / business predictive analysis, for trending, for finding the pattern of data over the period of time

Created Tableau Reports for the different Modules to help the business to take Critical Decisions.

Building the customized and interactive tableau dashboards using multiple data sources

Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.

creating and managing extracts

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

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

Worked with various versions in Tableau, Tableau Server, Tableau Public, Tableau Reader and Tableau Online

Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in version 9.0 – 10.0

Experience with Tableau Online and Server

Using TABCMD and TABADMIN

Created worksheets and dashboards by using custom queries and multiple tables.

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

Experience interacting/collaborating with a multi-functional product teams; Business Lead, R&D, and Data Infrastructure teams

Effectively used data blending feature in tableau.

Defined best practices for Tableau report development.

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

Develop and maintain Tableau dashboards, and schedule, distribute, and run reports

Executed and tested required queries and reports before publishing.

Developing Standard and Create reports using Tableau Desktop.

Extensive usage of Amazon web services (AWS) for connecting to the data sources on cloud using Amazon redshift services.

Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.

Created user groups in Cognos Connection from Active Directory groups

Knowledge of Enterprise HANA, SAP BW, Teradata, Hadoop as data sources for creating of Tableau Reports

Built various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.

Develop new Tableau visualizations based on the business need

Developed parameter driven WebFOCUS projects, reports, charts, and graphs Drilldown reports for managers.

Good Experience in working on Tableau data analysis as Tableau Analyst and building, developing the Tableau development dashboards as a Tableau Developer and Publishing the developed Tableau dashboards to Tableau server with security and authentication as a Tableau Administrator.

Provided user support for existing WebFOCUS infrastructure.

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

Creating DB views for the reporting purpose.

Designed and Developed Complex Active reports and Dashboards with different data visualizations using Tableau desktop on customer data.

Developed Technical requirements, design requirements and user acceptance documentation by placing Screen shots of actual Report and tested report in documentation.

Deployment of defect free code while managing the timeline set for the project.

Made my own content, which diminish the Man endeavors for minimizing the Tableau Workbooks from Higher Version to Lower Versions.

Designed Data model for custom Repository development, Business model mapping and OBIEE prompts and Dashboards.

Advanced knowledge of Self - Service analytic / ETL tools, specifically Alteryx Designer.

Developed a Python Script, without the accessibility of Tableau server, information refreshing will happen consequently alongside Security.

Developed Power Shell Script, which naturally makes PPT out of the Tableau Server and Send it to Business Users.

Develop presentation materials for the Tableau dashboards, documenting best practices

Involved in creating data blending in case of merging different sources, used Alteryx for Data blending for Tableau.

Worked on tableau python Libraries like tabdocumentapi, tableauSDK to automate the Tableau Administration and Documentation activities.

Worked on Integration of SQL Server, Power Shell, and Postgre SQL to develop Dynamic Scripts.

Extensive practical knowledge in importing data for use in reporting software (Tableau & Looker) graphs, and flowcharts.

Working on JavaScript to make the Tableau administration activities easy.

Working on tabdocumentapi that helps to create the tableau technical document easy with single Click.

Environment: Tableau 9.x, Teradata, SAP Business Objects 4.1/4.0, IDT, UDT, WEBI-BI: SAP BW Query Designer, Analyzer, Teradata SQL Assistant, Teradata Administrator, SQL BI Suite (SSRS / SSAS) 2012, Sharepoint.

AIG – Fort Worth, TX Jan 2012 –Nov’2014

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

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.

Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Involved in creating interactive, parameterized dashboards by extracting data from different sources using data blending and applying actions - filter, highlight and URL.

Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots and Bullet Graphs.

Liaison for project managers, managers, directors, and stakeholders.

Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation for end users.

Conducted gap analysis for re-engineering, and upgrading the current system where ever necessary.

Developed, derived and clarified functional specifications and Use cases.

Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).

Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.

Developed mappings and workflows in Informatica to extract data files used as source for various Tableau reports.

Involved in modifying Teradata stored procedures and performance tuning of various Teradata/Oracle tables, Informatica mappings to improve the performance of Tableau reports/Dashboards.

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

Involved in writing Test Cases, procedures, reports and approval of software release.

Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing.

Designed and Developed Complex Active reports and Dashboards with different data visualizations using Tableau desktop on customer data.

Developed Technical requirements, design requirements and user acceptance documentation by placing Screen shots of actual Report and tested report in documentation.

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

Created Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time

Involved in data conversion to provide reporting capabilities as per the requirement.

Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.

Validated the reports before publish reports to Tableau server, troubleshoot Tableau reports, dashboards, etc

Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.

Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau (Desktop /Server)9x, Oracle, SQL Server, DB2, SSIS, SQL, Toad, Unix, MS VISIO, Control-M, Erwin, Teradata SQL Assistant, Teradata Administrator, SQL, Share Point, Agile-Scrum, Informatica, Autosys, CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite.

Contact this candidate