HARISHWAR REDDY Email id: ***********@*****.***
Sr. Tableau Consultant. Ph no: 662-***-****
Overall 9 years of experience in IT industry as BI Lead Developer with Tableau and Business Intelligence tools with strong background in Databases and Data warehousing concepts.
Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
Designed several Business Dashboards using Tableau Desktop, Tableau server and hosted them across the client servers.
Installed Tableau 10.5 Version and worked on 64bit operating system. Compared and tested with previous versions. Observed the advantage of improved Data engine with usage of .hyper format.
Connected to IBM DB2 and IBM Big-Insights Data bases using SSL Authentication.
Worked on Hyper, Power Trend lines, nested projects and viz in Tooltip
Experienced in Creating the extracts, published data sources to Tableau server, refreshed extract in Tableau server from Tableau Desktop
Experience in Design, Development, Integration, Implementation and Maintenance of MS Business Intelligence and Tableau Platforms like Tableau Desktop, Tableau Server and Tableau Reader in Various Versions of Tableau 10.5/10.4/10.3/10.2/10.0
/9.2/9.1.
Expertise in resolving the reports, dashboards, performance issues and implementing best practices using Tableau.
Installed Tableau Server in a Distributed Environment and worked on Worker Nodes and added additional worker nodes.
Experience in Publishing and Sharing Workbooks, Data Sources with User Filter to Tableau Server, Setting Schedules, Subscriptions, Authorization and Permissions, incremental refresh extracts and updating server data that are using extracts.
Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices
Expertise in ETL tools like SQL Server Integration Services (SSIS) and Relational Database Management Systems.
Develop Alteryx Workflows for routine and ad-hoc activities.
Develop Tableau dashboards for data discovery and routine reporting needs.
Maintain existing SAS based workflows and develop/implement process for transition to Alteryx.
Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
Expertise in all phases of data warehousing lifecycle along with implementation and testing of software products.
Extensive experience on using SQL for Tableau and in writing parametrized queries for generating Tabular reports, formatting report layout and expressions.
Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
Worked on creating interactive, real-time dashboards using drilling downs and customizations.
Experienced in interaction with business users to gather requirements, training and co-ordinate with them in various phases of projects to provide end-to-end solutions.
Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
Utilized all Tableau tools including Tableau Desktop, Tableau Reader and Tableau Public. Strong understanding of project life cycle and Software Development Life Cycle(SDLC) methodologies.
Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.
Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Joins, Keys and Data Import/Export.
Expert in design/development using Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
Strong data analysis expertise in the field of Financial Analysis, Financial Modeling, Capital Markets, Industry Research and Product Development
Excellent in SQL and modify/enhance existing SQL queries, improve Query Performance.
Excellent verbal/written communication skills and can perform well both independently and as a team player.
Ability to quickly master new concepts/applications & identify operational deficiencies and system improvements. Strongly self-motivated, willing to assume responsibilities & very detail oriented. Excellent at communication, analysis & presentation.
Skills Set:
Operating Systems: Linux, UNIX, MAC OS, Windows XP/Vista/7
Software Packages: MS Office (Word, Excel, PowerPoint, Visio, Project), Rational Rose.
Programming Languages: SQL, PL/SQL, T-SQL, C.
Web technologies: HTML, CSS, JavaScript.
Database Servers: MySQL, MS Access, Oracle 9i/10g, SQL Server 08/10, Teradata,
Netezza.
Processes/Technologies/Tools: Waterfall, Agile, RUP, Clear case, Change Management, Use Cases, Workflow, and UML.
BI Tool: Micro Strategy, Tableau, DOMO.
Tableau Desktop 10.5/10.4/10.3/10.2/10.0/9.3/9.2/9.1
Used various Tableau versions to create visualizations appealing to end users and customers
Tableau Server 10.2/10.0/9.3/9.2
Installation and configuration of Tableau server on various versions, Service pack upgrades, Version upgrades and end to end architecture design.
Professional Experience
Citi Group, Tampa, Florida. Mar 2017 – Till Date
Sr. Tableau Developer
Responsibilities:
Installed and Worked on latest version of Tableau 10.5.
Designed, developed and tested various Tableau dashboards such as Scorecard, marketing dashboards, usage reports and various Ad-Hoc reporting solutions using Tableau 10.0.1 and 10.3.
Perform data visualization development using Tableau to create complex, intuitive, innovative dashboards and reports.
Involved in publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers.
Analyzed data requirements, application and processing architectures, while designing, developing, amending, and optimizing database designs to satisfy client needs.
Gathered functional and non-functional client requirements to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
Daily data pull and testing using SQL queries.
Developed dashboards using Custom SQL queries, and various data sources using data blending techniques.
Good SQL reporting skills with the ability to create SQL views and write SQL queries.
Performed End to end testing using SQL Queries in Oracle.
Provided training sessions to business users on how to use Tableau reports.
Developed POCs for business users displaying various functionality and visualization.
Update and maintain various release documentation, and JIRA tickets.
Maintained multiple version of Tableau dashboards using SVN.
Schedule reports, administer users and user groups for workbooks, data sources and views in Tableau.
Worked with ETL team on designing Oracle tables for multiple projects, data analysis and SQL Query transform.
Analyzed the data using Statistical features in Tableau to develop trend analysis like context reports based on Daily, MTD, last one month, and YTD date fields.
Identified opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion
ExxonMobil, Houston, Texas. Jun 2015-Feb 2017
Sr. Tableau consultant
Responsibilities:
Deep experience with the design and development of Tableau visualization solutions.
Created extracts, published data sources to Tableau server, refreshed extract in Tableau server from Tableau Desktop.
Used various ETL tools to extract data into Tableau Desktop and data wrangling using SSIS in data preparation phase.
Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
Created External filter, internal filter and Context filter to improve performance.
Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
Used data connectors that are already available in Tableau, to read any site that publishes data in JSON, XML, or HTML.
Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.
Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
Created parameters and quick filters.
Created sets to display top products based on their sale.
Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
Created Dashboards with interactive views, trends and drill downs.
Published Workbooks and Dashboards to the Tableau server.
Combined visualizations into Interactive Dashboards and publish them to the web.
Created groups and users in Tableau server
Implemented new features in Tableau 9.1 to the existing Workbooks and Dashboards.
Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users
Cervello, Dallas TX Jul 2013 – Apr 2015
Tableau Developer
Worked closely with business leaders, and end users to define operational report templates and aid in their use.
Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
Setup and configuration of Tableau server in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
Used SAML for configuration of Tableau Server SSO supplementing Kerberos authentication on the side
Setup trusted authentication in Tableau server and pass requests from Web server
Worked heavily using Tabadmin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
Designed and setup user security for the entire landscape to facilitate Windows AD login.
Used Tableau Cmd for various Dashboard migrations from one environment to another.
Setup of Distributed Server environments for load balancing and organized respective primary and worker nodes in the server cluster
Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
Used TabJolt and JMeter to assess the performance and made sure dashboards and CPU usage have been taken care of.
Provided the supporting role in designing the Security Architecture in the Tableau.
Used Administrator tools like Urban Code and used JIIRA to move the objects from one environment to another environment.
Used JMeter and TabJolt to do performance testing in Tableau Server.
Used Tabadmin tools and Tableau Cmd for setting up security profiles for various User groups, sites, and perform multiple server level activities.
Analyzed and processed complex data sets using advanced querying, visualization and analytics tools like Python, SAS EG, SAS EM.
Used Numpys and pandas to do advanced analytics in Python.
Integrated tableau desktop with R and performed analytics.
BJC Healthcare, St. Louis, MO Sep 2011-Jun 2013
Tableau Developer/SQL Developer.
Responsibilities:
Design interactive dashboards in Tableau Desktop and published them to Tableau Server.
Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps.
Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
Published Workbooks by creating user filters so that only appropriate teams can view it.
Users to interpret functional requirements into report specifications. Involving in writing complex SQL queries to verify data from Source to Target Performed data validation testing writing SQL queries
Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS)
Accountable for creating financial Reports and Dashboards. Application has been designed driver-based planning - an approach that bases financial forecast on operational drivers supports Companies performance management. Created rolling forecast based budgeting, this will help FP&A team to plan ahead and more often and updated forecast with actuals. Developed several data input forms for Capex, Workforce and Financial statement planning.
Had conducted deep dive meetings with the business users to understand the current automation process and Ad hoc jobs for budget/forecast calculations.
Target Corporation, Minneapolis, MN Oct 2009– Jul 2011
Tableau Developer/ BI Developer.
Responsibilities:
Extracting data from different sources connecting them and used the same to create dashboard
Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
Creating data blending in case of merging two different datasets.
Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling
dashboards to deliver actionable insights.
Analyzed the source data and handled efficiently by modifying the data types.
Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports.
Generated context filters and used performance actions while handling huge volume of data.
Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
Used Sheet filters to produce multiple chart types in a single view.
Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
Documented various business requirements, deployment plans and prepared various users guides to facilitate the users to learn and adapt to the new systems.
Organize requirements into high level Use Cases and Low-Level Use Case Specifications and modeled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio
Developed product for Working Capital Management. The product is connected to a live database (S&P Cap IQ). The data is pulled from the database into the excel which is fed into tableau. Calculations are performed in tableau for working capital. The product is fully automated, when the company ticker is changed, the data will update automatically according to the input.