Tableau Developer Resume
Memphis, TN
SUMMARY
- Around 8+years' experience working in IT industry with document delivery SQL/ETL developer and Tableau report
- Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
- Around 8+years' experience working in IT industry with SQL/ETL developer and Tableau report document delivery.
- Involved in full life cycle implementation, which includes Gap Analysis, Requirements Gathering, Development, Testing, Reporting, Go live and Reconciliation.
- Experience in using Tableau functionalities for creating different Requests, DAX technology, Filters, Chart, Interactive dashboards with Page and Dashboard Prompts.
- Implemented and designed dashboards using Qlik view, Qlik sense.
- Strong Experience in Performing data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
- Using Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, Teradata Administrator, SQL Assistant, Pmon/View Point, Data mover)
- Extensive experience as Micro Strategy Developer, Architect & Administrator building projects and creating reports and Dashboards using Micro Strategy, Narrowcast Server, Micro Strategy Desktop, Micro Strategy Web, Micro Strategy Intelligence Server.
- Expertise in Desktop creating and integrating Micro Strategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes.
- Created Tableau Scorecards, Dashboards, Heat maps using show me functionality.
- Proficient in design and development of 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, Gather Requirements from Key Stakeholders other local and Global filters per the end user requirement.
- Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
- Experience with MPP and columnar database like AWS Redshift.
- Experience with Big Data methods, topologies and tools, such as Map/Reduce (e.g. AWSEMR), Apache Spark, etc., preferred.
- Extensive knowledge in Dimensional Data modelling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modelling.
- Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau.
- Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps. Effectively used Data blending feature in Tableau.
- Expertise in technologies like Data Warehouse (DWH), Data Visualization and Business Intelligence Concepts and BI Tools.
- Worked on Informatics tool Source Analyser, Data Warehousing designer, Mapping Designer, Workflow Monitor, Workflow Manager OBIEE and Repository Manager.
- Highly proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
- Experienced in all aspects of Software Development Life-Cycle (SDLC) from inception to delivery including requirements gathering, use cases, functional specification, design, estimation, implementation and debugging, documentation and maintenance.
- Expertise in Business Intelligence (BI)/ data warehouse (DWH) concepts, designs, SSRS/SSAS, and project implementations.
- Good knowledge of data warehouse (DWH) Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
- Hands on experience in developing reports and visualization against SAPHANA.
- Hands on installing, using and troubleshooting various software applications.
- Good knowledge on C, C++ programming language, DBMS, DAX technology, RDBMS and Visual basic concepts.
- Worked with Different Databases like DB2, Teradata, Oracle, Microsoft SQL Server, Microsoft Access databases, Excel Spreadsheet etc. Hands on experience on Tableau Server administration including cloud based services.
- Able to work independently has a good interaction with team members.
- Good at understanding the client requirements and giving best solutions.
TECHNICAL SKILLS
Programming Languages: C, C++, JAVA, Visual Basic, SQL, QA, Oracle PL/SQL, Linux, UNIX shell scripting, Java, JSP, HTML, JavaScript, JIRA, T-SQL, PL/SQL, ASP .NET.
BI Tools: Business Objects, WebI, Crystal Reports, Xcelsius, TableauServer,Toad, Tableau Desktop, TableauPublic,TableauReader, Power BI.
ETL Tools: INFORMATICA, Data Stage.
RDBMS/DBMS: MS-Access, DB2, MS SQL SERVER, MYSQL, Teradata V2R6, DB2, Oracle, Sybase.
Database: SQL Server, Oracle, OLTP, OLAP, MS SQL Server Enterprise, Manager, SQL Query Analyzer, Web Services.
Database Tools: TOAD, SQLDeveloper, SQL Plus, SQL Loader.
SQL Server: Business Intelligence Development Studio (BIDS) SSIS/SSRS, SQL Server Management studio (SSMS), Visual Studio, Power BI.
Data Modelling: MS Visio, Rational Rose. Xml.
Web Designing: DHTML, HTML, XHTML, XML.
Methodologies: Software Development Life Cycle, Agile, Waterfall, Data Modelling Logical/Physical/ Dimensional, Snow Flake Schema, ETL.
Utility Packages: MS-Office Suite, MS-Excel.
Version Control: Team Foundation Server (TFS), Visual Source Safe (VSS), GIT, Securefx.
Operating System: Windows Family, DOS, UNIX, Linux, Mac.
PROFESSIONAL EXPERIENCE
Confidential, Memphis, TN
Tableau Developer
Responsibilities:
- Actively participate in review meetings with Project Manager to ensure that the development of projects meet business and system requirements for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
- Designed views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
- Created Heat Map showing current service subscribers by colour that were broken into regions allowing business user to understand where we have most users vs. least users.
- Build dashboard using parameters, sets, groups and calculations.
- Involved in creating a dual-axis bar chart with multiple measures.
- Generated report schedules on Tableau server.
- Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
- Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
- Created actions, parameters, Filter Local, Global and calculated sets for preparing dashboards and worksheets using Tableau Desktop.
- Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
- Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
- Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
- Worked as Tableau architect in standardizing Tableau for enterprise wide deployment.
- Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
- 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.
- Collaborated with analysts, statisticians, data scientists and coders on global complaint data using Microsoft Excel
- 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.
- Experiences on Tableau7.x, 8.x, 9.x, 10.x tools include Tableau Desktop, Tableau Reader, Tableau Public, and tableauServer.
- Wrote and modified various Stored Procedures used in the application using T-SQL.
- Schedule and maintain packages by daily, weekly and monthly in SQL Server Agent.
- Perform quality assurance checks and update databases to ensure data integrity.
- Performance optimization of the data warehouse by identifying and assisting in correcting EDW/BI performance bottlenecks and debug database, application or data content related issues.
Environment: Tableau Desktop, Tableau Server, Microsoft SQL Server, Salesforce, Visual Studio, SQL Server Integration Services SSIS, SQL Server Reporting Services SSRS, Actuate Decommissioning, C, Microsoft Visio, MS Access, Excel.
Confidential, Palo Alto, CA
Tableau Developer
Responsibilities:
- Assisted in complete Life Cycle including Design, Development and Testing
- Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided
- Deployed the generated reports onto the report server.
- Formatted the reports using the Global variables and expressions.
- Cleaned the data and generated graphs in Microsoft Excel.
- Upgraded the existing server versionto Tableau 10.4 and successfully migrated existing workbooks and data sources
- Deep experience with the design and development of Tableau visualization solutions.
- Background in installing and upgrading of Tableau server and server performance tuning for optimization.
- Involved in license management SLA’s with Tableau support.
- Defined and created procedures to install Tableau desktop in silent mode.
- Worked with SSIS Packages on SQL Server 2012 and SSIS packages on SQLServer2008 for the automation of day to day Maintenance Jobs.
- Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
- Extensively used Alteryx for giving Data analysis and BI software with SQL Server.
- Wrote SQL code with multiple joins to pull the data from multiple Oracle Database. Optimized and automated the query in Alteryx
- Developed Tableau Data Extracts for dashboards by creating ETL workflows in Alteryx from multiple data sources and customized data
- Defined best practices for Tableau report development.
- 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 in Tableau.
- Strong hands on experience using Teradata utilities (SQL, Fast Load, Multi-Load, Fast Export, T-pump and Visual Explain and Queryman) and Teradata parallel support.
- Created Parameterized reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRS using SQL Server.
- Understanding of relational database structures, theories, principles, and practices.
- The ability to interact professionally with a diverse group, including executives, managers, and LOB.
- Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
- Designed and Developed matrix, tabular, parametric and Sub Reports in the SQL Server Reporting Services 2012.
- Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while maintaining the accuracy of the core information content that is being communicated
- Proof-read all documents and maintain accuracy of information and preparing SOP.
- Responsible for Developing a Dashboard and preparing ad-Hoc Reporting.
- Managed and created and altered Databases, Tables, Views, Indexes, and Constraints with business rules using T-SQL.
- Developed complex Stored Procedures, Triggers, User Defined Functions based on the requirement
Environment: Tableau Server, Oracle SQL Developer, SQL server, HPQC, Oracle, java platform, Teradata, Microsoft office, Business objects, SQL, PL/SQL, T-SQL.
Confidential
Tableau Developer
Responsibilities:
- Designed automated scripts in PL/ SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
- Exposed to data conversion from different data sources to SQL Server 2012 using SSIS.
- Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2012.
- Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS),
- Developed and maintained graphs, tables, slides and document templates for the efficient creation of reports.
- Interacted professionally with diverse group of professionals in the organization including managers and executives.
- Experienced in standardizing Tableau for shared service deployment.
- Developed Standard Operating Procedures (SOP) for Monitoring.
- Extensively used data blending, embed functionalities in Tableau.
- Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
- Building, publishing customized interactive reports and dashboards, report scheduling using
- Tableau server.
- 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.
- Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPIs.
- Gathered user requirements, analysed and designed software solution based on the requirements. Interacted with Business Analysts and Data Modellers and defined Mapping documents and
- Design process for various Sources and Targets.
- Defined best practices for Tableau report development and effectively used data blending feature in tableau.
- Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
Environment: Tableau Server, Oracle SQL Developer, SQL Assistant, Oracle, java platform, Teradata, Microsoft Office, Business objects, SQL, PL/SQL, T-SQL.
Confidential
Tableau Developer
Responsibilities:
- Designing and developTableauReports, Documents, Dashboards and Scorecards for specified requirements and timelines.
- Developed various reports based on customer requirements.
- Experience on KPI (Key Performance Indicators).
- Prepared Dashboards using Calculations, Parameters inTableau.
- Designed visualizations using Different Data views like bar charts, Trend lines, Cross-Tab, Scatter-plots and bullet graphs.
- Customizing the Data views & implementing the various charts like Waterfall, Bump and Funnel charts.
- Created customized and interactive dashboards using data sources and custom objects.
- Understanding the KPIs and Requirements Documents.
- Involved in creating dashboards by extracting data from different sources.
- Working withTableauDesktop.
- Created dashboard using parameters, sets, groups, and calculations.
- Measure Value fields to create visualizations with multiple measures and dimensions.
- Involved in creating of data blending in case merging different sources.
- Involved in creating a dual-axis bar chart with multiple measures.
- Involved in creating calculated fields, mapping, actions, and hierarchies.
- Participating Daily, Weekly and Ad-hoc meetings.
- Involved in end to end implementation of reporting projects.
- Publishing the dashboards onTableauServers.
- Preparation of Test Scenarios, Test Cases, and Execution of Test Cases.
- Attending the weekly Status call with the onsite team.
- Deployed reports in production.
- Created end to end Active Reports.
Environment: Tableaudesktop, Table Server, MS Office, Oracle11g, SQL, Windows.
Confidential
Software Engineer
Responsibilities:
- Worked with various data sources such as Oracle, SQL Server, Hadoop, ODBC and flat file sources
- Created, maintained & scheduled various reports in SSRS such as Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
- Expert in connecting multiple data sources in Power BI to implement working reports.
- Hands on experience in developing reports and dashboards visualization.
- Developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power Point. Slicer, Pivot chart, Pie Chart, Macros.
- Expert in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis using Power BI desktop.
- Expert in creating multiple kind of Power BI Reports and Dashboards.
- Created and deployed Matrix, Grid, Chart, and Gauge Reports utilizing SSRS. Created parameters for SSRS reports as well as drill-down and interactive sorting capability.
- Implemented subscriptions and snapshots in the SSRS Report Manager.
- Researched problems thoroughly to diagnose the root cause by pulling data from multiple Sources, Developed Reports and dashboards using Power BI .
- Expert in creating Score Cards, Metrics, Power View/MAP and Pivot Tables using Office 365.
- Expert in creating multiple kinds of Report in Power BI and presented them using Story Points.
- Created SSIS package to pull all events and programs data from database server and SharePoint lists.
- Hands-on experience assisting users in creating and modifying worksheets and data visualization dashboards.
- Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
Environment: Tableaudesktop, Table Server, Hadoop, SSRS, Power BI, MS Office, Oracle11g, SQL, Windows.
