Tableau Developer / Administrator Resume
St Louis, MO
SUMMARY
- Over 8 years of experience in Software Development, Implementation and Maintenance of Business Intelligence (BI) and Database Platforms.
- Experience in Software Analysis, Design, Development and implementing core business software applications.
- Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in versions of Tableau.
- Hands on Experience in Data Management with expert skills in SQL, SSIS & SSRS.
- Experience in Tableau server installation, configuration and administration & experience in creating Tableau Mobile dashboards.
- Extensive Tableau experience in Enterprise Environment and Tableau experience including technical support, troubleshooting, report design and monitoring of system usage.
- Involved in Full Life Cycle Development of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.
- Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
- Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
- Experience in creating aggregates, hierarchies, filters, table calculations, calculated measures.
- Ability to connect to different data sources from Tableau, presenting the good Visualization of data, Different way of using the filters and parameters.
- 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.
- Involved in the installation and configuration of Tableau server. Have also configured distributed installation for Improved Performance.
- Created and migrated Workbooks and Dashboards from one environment to another and created users, groups and domains from Active directory and created different License level for each User.
- Have taken backup of the server on a regular basis by using Tabadmin commands and have also used Tabcmd commands on regular basis.
- Extensive experience in working with Relational databases (RDBMS) such as Oracle, SQL Server, HP Vertica, Teradata and MS Access.
- Good skills in testing and debugging and knowledge of ETL procedures and strategies to extract data from different source systems.
- Have used different Mark types and Mark properties in views to provide better insights into large data sets.
- Good usage of Tableau JavaScript API for performance improvement of web page.
- Extensive experience in gathering requirements, gap analysis, design, development, testing and implementation of the ETL / Data warehouse projects.
- Hands on experience with Big Data technology like HIVE(HQL) and implementing Tableau on cloud service like AWS.
- Well versed with Excel, MS Project, MS Office, MS PowerPoint for creating reports and analyzing data on large datasets using Pivot Tables, Vlookup and conditional formatting.
- Quick learner, Proactive, self - motivator and highly adaptable to challenging work assignments/roles.
- Regular communication with Client on gathering the requirements, discussions and in resolving the issues & concerns.
- Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
TECHNICAL SKILLS
- T-SQL
- PL/SQL
- HQL
- HTML
- JAVA/J2EE
- JavaScript
- Data Visualization
- Business Intelligence (BI)
- Software Management and
- SDLC
- ETL
- Data Collection.
- Data Modeling-Logical/Physical/Dimensional
- Star/Snowflake Schema
- OLAP
- SDLC (Waterfall
- Agile
- Iterative)
- MS SQL Server Enterprise Manager
- MS-Office
- SQL Server Management
- MS Visual Studio
- RDBMS SQL Server 2008/2012/2014
- Tableau Desktop
- Tableau Server
- SSIS
- SSAS
- SSRS
- MS Power BI
- SQL Server Management Studio
- SQL Server Enterprise Manager
- SQL Server Profiler Import and Export Wizard
- Business Intelligence Development Studio (BIDS)
- Tableau.
- MS Visio
- MS Project
- MS Office (Word/ excel/ Access/ PowerPoint).
PROFESSIONAL EXPERIENCE
Confidential, St. Louis, MO
Tableau Developer / Administrator
Responsibilities:
- Part of Digital marketing and Analytics team, responsible for building complex Tableau reports by connecting them to Excel files, Hive/Hadoop, Oracle, MS SQL & HP Vertica.
- Interacting with business stakeholders to understand their decision-making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.
- Develop, execute and analyze ad-hoc reporting and market research for VOIP and BVOIP services and accreditation to advocate for additional resources, new policies, reverse ineffective mandates for better customer experiences.
- Installed and monitored Tableau server on AWS environment.
- Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client Confidential a glance, also interact with data as necessary
- Delivered dashboards tracking viewership, HUT and Advertising sales for DirecTV.
- Created dashboards for System Services Company to measure performance of their field engineers and manufacturer defects.
- Adding permissions to various users and adding them to the specific reports on the tableau server everyday based on the requests.
- Experience in developing Power BI reports & effective dashboards after gathering and translating end user requirements.
- Experience in creating dashboards, volume reports, operating summaries, presentations and graphs.
- Experience in creating calculated measures and columns with DAX in MS Power BI Desktop.
- Good knowledge using advanced calculations, Custom Visuals and Groups Creation using MS Power BI Desktop.
- Experience in publishing reports to app.powerbi.com and setting up the necessary connection details and Scheduling.
- Experience in creating Executive Dashboards in PowerBI.com using Tiles from reports.
- Worked with transforming huge volume of data out of and into Hadoop/HiveQL.
- Automated hive queries to join data from different sources and analyzed the data.
- Configured Cache settings which improved the performance of the dashboards and report schedules and created Custom Hierarchies to meet the Business requirement on Tableau server.
- Created Workbooks and dashboards for analyzing statistical billing data 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.
- Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, custom functions usage, and multiple grouping reports in Tableau.
- Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views Confidential once.
- 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.
- Involved in integration of Tableau JavaScript API Filters in OCX web application.
- Installed patches on server and documented upgrade plan form Tableau 9.0 to Tableau 9.3.
- Connected tableau server with SharePoint portal and setup auto refresh.
- Processed large Excel source data feeds for Global Function Allocations and loaded the CSV files into Oracle database with TOAD utility.
- Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
- Maintained Test log and wrote Test Evaluation and Summary Reports.
- Redesigned the data source having data from different sources into one SQL Server and to tableau.
- Used Tortoise SVN as version control tool.
- Followed the Agile methodology to implement the application and used rally as agile tool.
- Participated in discussions for Tableau Server architecture design on Cloud, enhancing performance, scalability and high availability.
Environment: Tableau, Power BI Desktop, Oracle 11g/10g, MS SQL Server 2014/12, HP Vertica, HIVE, T-SQL, PL/SQL, Toad 10.0, SVN, AWS, MS Excel, Rally
Confidential, Springfield, IL
Tableau Developer / Administrator
Responsibilities:
- Involved in designing and deploying rich graphic visualizations with Drill Down and Drop Down menu option and parameterized using Tableau.
- Performed descriptive and predictive statistics on warehouse data and responsible for different forecasting operations.
- Maintained data integrity and data quality among all the databases across the Teradata platforms.
- Gather requirements from business users, created technical specifications, estimation documents.
- Developed multiple dashboards/reports using various charts like Bar, Stacked Bar, Line, Dual-axes charts, Geo-Maps, Histograms, Heat Maps etc.
- Designed and developed Tableau reports, dashboard and metrics to Support Claims Reporting and Business Intelligence strategy.
- Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
- Performed Data filtering and troubleshooting of database activities, diagnosed the bugs and logged them in version control tool.
- Performed source data analysis and captured metadata, reviewed results with business. Corrected data anomalies as per business recommendation.
- Performed the batch processing of data, designed the SQL scripts, control files and batch files for data loading.
- Performed the Data Accuracy, Data Analysis, Data Quality checks before and after loading the data.
- Actively involved in creating a custom portal design hosting Tableau workbooks using JavaScript API.
- Worked on back end ETL process to provide the reporting framework for developing reports.
- Created different Interactive views in workbook to visually analyze data per client requirements.
- Used different Mark properties in views to provide better insights into large data sets.
- Used Data Blending, groups, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
- Developed and retrieved various Ad-hoc reports for the finance to match on deposit numbers.
- Created Dashboards with different Action filters, interactive views, trends and drill downs.
- Involved in creation of groups and users in Tableau server using Active Directory settings.
- Star Schema and Dimensional Data modeling was used in creating data mappings between various data sources to the EDW.
- Participated in daily stand-ups with clients on daily design and development effort.
- Generated reports with SQL queries and prepared test scripts and documented user training modules.
- Worked closely on RCA, Problem Management, Incident Management and Change Management using BMC Remedy tool.
- Extensively involved in doing user acceptance testing (UAT) and generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
Environment: Tableau Desktop/Server, MS SQL Server 2008/2012, SQL, Teradata 13, Teradata SQL Assistant, SOAP UI, BMC Remedy, HP Quality Center, JavaScript
Confidential, Tempe, AZ
Tableau Developer
Responsibilities:
- Main objective was to work with the business to design the best possible solutions from data warehouse design, ETL, reports, cubes, pivot tables and dashboards.
- Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
- Embedded live Tableau dashboards on PowerPoint presentations, keeping the slides always updated.
- Monitored payouts, hit frequencies and revenues using SQL queries, employing root cause analysis to identify issues. Used statistical tests to ensure data quality.
- Created several SSIS packages using advanced transforms, lookups, fuzzy lookups, and script components.
- Created test SQL scripts and provided presentation documentation for review with the business.
- Produced custom, on demand BI reports for the Business Development and Content Acquisitions Team.
- Used SSIS in two different projects to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
- Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
- Have setup stand alone and distributed Tableau Server to publish and distribute dashboards easily.
- Mentored business power 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 link to link data from different connections together on one dashboard and to filter data in multiple views Confidential once.
- Data collection and leveraging on data manipulation teams for required data.
- Identify new metrics and enhance the existing KPI’s.
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Created actions, data blending, Hierarchies, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets with tableau.
- Analyzed various reports, dashboards, scorecards in MicroStrategy and created the same using Tableau desktop server.
- 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.
- 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.
Environment: Tableau (Desktop, Server), SSIS, Teradata, SharePoint, Windows, ETL, SQL, PL/SQL, MS Project, MS Office suite (Word, Excel, PowerPoint).
Confidential
BI Developer
Responsibilities:
- Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
- Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
- Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
- Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
- Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
- Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
- Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
- Gather and analyze the business requirements and then translate them to technical specifications.
- Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
- Optimized the performance of queries with modifications in T-SQL queries, eliminated redundant and inconsistent data, established joins and created indexes whenever necessary.
- Experience in writing Ad-hoc queries for Business analysts to extract required daily data, analyzing existing data and performing the data migration.
- Experience in generating on-demand and scheduled reports for business analysis or management decision.
- Configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
- Worked on everyday tasks and tickets based on priority levels from TFS and saved/updated all scripts related to the tasks in TFS using Visual Studio.
- Documented all database objects, procedures, views, functions & packages for future references.
- Organized Error and Event handling by giving Precedence Constraints, Break Points, Check Points, Logging and viewers in SSIS.
- Merged Data from Heterogeneous Data stores and Legacy System implementing SSIS on the System.
- Configured the report viewing security for various users Confidential various levels using SSRS Report Manager.
- Played a major role in production support of SSAS cube and SSIS jobs.
- Involved in writing MDX queries and performance optimization of the SSAS cubes.
- UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse and data marts
- ImplementedIncremental load, usedEvent Handlersto clean the data from different data sources
- Data blending implemented on databases and generated interactive dashboards.
- Created package to transfer data between OLTP and OLAP databases.
- Used cascaded parameters to generate a report from two different Data Sets.
- Involved withQuery Optimizationto increase the performance of the Report.
- EmployedFiltered Indexesto improve query performance and reduce the storage and maintenance cost.
Environment: SQL Server 2008/2012, SSAS, SQL Server Integration Services 2008, Oracle 11g, SQL Server Reporting Services (SSRS) 2008, PL/SQL, Microsoft Visual Studio 2010, Share point server.
