Senior Tableau Consultant / Tableau Administrator Resume
Nashville, TN
SUMMARY:
- Confidential has 9 years of experience in Software Development, Implementation and Maintenance of Business Intelligence and Database Platforms
- Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7/8/9/10/2018.
- Extensive experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
- Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps with Tableau desktop.
- Good Knowledge on database concepts and SQL
- Well versed in query optimization for performance tuning and monitoring of processes.
- Experience in creating Tableau Mobile dashboards.
- Experience in Tableau server installation, configuration and administration.
- Expert in creating data sources on SAP BW, Oracle, SQL server, Teradata, Google Analytics, PostgreSQL, Splunk and flat files.
- Ability to connect to different data sources from Tableau, presenting the good Visualization of data, Different way of using the filters and parameters.
- Knowledge on Data Warehousing Concepts.
- Experience with creation of users, groups, projects, workbooks and the appropriate permission sets in Tableau server.
- Experience in creating aggregates, hierarchies, filters, quick filters, table calculations, calculated measures.
- Worked on data warehousing designer tools that include Informatica power center (Source Analyzer, Warehouse Designer, Mapping designer, Mapplet Designer, Transformation developer) and ETL
- Good experience in Software Analysis, Design, Development and implementing core business software applications
- 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
- Created data models involving Tableau Connections & Templates as well as Report development and publishing on Tableau Server.
- Develop and maintain Change Management and Service now policies, Procedures and controls for platform operations including Disaster Recovery (DR), Prod support and Production Environments.
- Gathering the requirement directly from client and provide them the best possible solution to extract and transform their data from system and visualize their data on Tableau. So that they can have better insight of their business.
- Drive collaborative efforts in developing processed and material.
- Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
- Support and track medium and high risk project, providing business impacts, change impact and risk/gap analysis, ensuring all changes are properly planned and well tested
TECHNICAL SKILLS SUMMARY:
BI Tools: Tableau 8x, 9x, 10x, 2018x (Desktop, Server, Reader), SAP Business ObjectsETL Tools Informatica Power Center 10.1.1
Data Bases: Server 2000/2005/2008/2008 R2/2012, Greenplum, MS Access, Teradata, Oracle 11g/10g, Excel Flat files, DB2.
Programming Languages: C, C++, T-SQL
Operating Systems: Windows NT / 2000. Windows Server 2003/2008/2008 R2s Undergoing Splunk, Hadoop
PROFESSIONAL EXPERIENCE:
Confidential, Nashville, TN
Senior Tableau Consultant / Tableau Administrator
Responsibilities:
- Design and create data visualizations (Reports and dashboard) as required to support user stories.
- Work closely with ETL team and Prepare Source to Target Mapping specifications.
- Developing the target Database table as per the requirement by writing the source qualifier Queries.
- Support the Business intelligence Analyst with the understanding of business and data requirements and designing the visualizations for initial concepts and prototypes that can be presented for end users.
- Support Activities to document, evolve and communicate artifacts developed using Informatica and Tableau.
- Developing Ad-hoc reports using Tableau Desktop, Excel.
- Defining, Executing complex/nested SQL Queries.
- Creating Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
- Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
- Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
- Maintaining and administrating the tableau server in all the environments.
- Working closely with Application Team for Identifying the Data Issues and Manage the Implementation of Data Fixes With the Help of DBA. Responsible for the communication from Application Team to DBA.
- Primary point of for questions, problems, suggestions and complaints about the Data Fixes happening on Production.
- Provides updates and ensures the on-going data Fixes on Prod Data Base processes and maintain Documentation.
- Prepare statistics and Trend Reports for all the modules undergoing some change.
Confidential, Houston, TX
Senior Tableau Developer
Responsibilities:
- Responsible for gathering suit of business requirements, download extracts from SAP BW and work closely with ETL team and Prepare Source to Target Mapping specifications.
- Developing the target Database table as per the requirement by writing the source qualifier Queries.
- Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements
- Creating and Writing Custom SQL to get the desired output for building a Tableau dashboard.
- Creating Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
- Developed geographic maps showcasing demographics broken into age, race, and income category that showed content viewed by individual customers across all content providers.
- Developed parameter and dimension based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop.
- Updating TNS entries for oracle as and when needed.
- Prepared architectural documents and presentations for client meetings
- Publishing knowledge base articles in internal portal.
- Coordinating with DBA
- Working as business analysts and touch base with Data Architects regarding the nature of the information processing or computation needs.
- Responsible for developing Tableau based dashboards upon gathering the requirements from the customer.
- Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
- Developed Ad-hoc reports using Tableau Desktop, Excel.
- Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
- Published and Scheduled the Reports in Tableau Server
- Developed and executed unit test cases for code development; includes performance and load testing as needed
- Performance testing of all the reports, which helped in analyzing its performance before moving into production.
- Create different performance metrics of all the reports. Writing Test cases for the data connections, Templates and Reports.
- Documentation of features of the Developed Tableau Dashboards.
- Post production support.
Confidential
Maintenance & Support
Responsibilities:
- Involved in all forms of report development and enhancement activities.
- End to end server administration which involves installations and upgrades.
- Handles User management and Project management.
- Involved in addressing out of space/memory issues.
- Updating TNS entries for oracle as and when needed.
- Handling the outages and environment availability issues.
- Address break/fix or code issues for on boarded dashboards.
- Report migrations from lower environment to higher environment.
- Prepared architectural documents and presentations for client meetings.
- Publishing knowledge base articles in internal portal.
- Coordinating with DBA
- Cleanup, backup and installing new server machines as per tableau recommendations.
- Testing of all the reports across different environments.
- Developing of test dashboards for different types of data sources in the new version.
- Create different performance metrics of all the reports. Writing Test cases for the data connections, Templates and Reports.
- Documentation of new features of the upgraded Version.
- Documentation of all the upgrade Issues with RCA
Confidential
Software Developer
Responsibilities:
- Collecting of all the files and identify the formats.
- Capturing data from all the files and placing it in master file using VB script.
- Testing of file formats and removing of unnecessary data.
- Manual testing of the master data with the data in the Excels.
- Identifying the scope of work and mapping the correct data to it
- Create a Table in database and create a mapping in Informatica to import all the master data into the Table.
- Development of Data connections, Templates and reports On Tableau.
Confidential
Software Developer
Responsibilities:
- Developing the database as per the new calendar definition using Sql developer
- Developing stored procedures, Packages using PL/SQL.
- Attending the status calls and providing update as per weekly status
- Good interaction and timely response to the client.
- Testing of newly added features in the system.
- Update Relevant Documents & Report Progress on Développent.
- Participating in the complete development lifecycle: analysis, design, build and test reports
- Interacted with Business Users, Business owners to know their Business requirements in developing and modifying Universes and Tableau reports .
- Performance testing of all the reports, which helped in analyzing its performance before moving into production. Unit Testing & Régression Testing.
Confidential
Software Developer
Responsibilities:
- Modification of reports as per the requirements.
- Creation of Business Objects reports using the universe as the main data providers and writing the complex queries including sub queries, Unions, Intersection and Aliases.
- Performance tuning to reports.
- Universe restructuring by removing all the unwanted/unused tables in the reports.
- Provide support for XI Migration team.
- Involved in migration of personal documents of users.
- Provide status updates to Managers and to drive the offshore team calls.
- Work with ETL team and database team for few changes in tables.
- Take Knowledge transfer on any new application that is being added in Scope
Confidential
Software Developer
Responsibilities:
- Modifying the database as per the client request using QMF/SPUFI.
- Need to be proactive in taking steps whenever a job abends.
- Data migration from one server to another
- Solving the Issues within SLA.
- Attending the status calls and providing reports as per weekly status
- Good interaction and timely response to the client.
- Analyze & In corporate changes if any to solve the problems faced by business users.
- Involved in Solving Service Requests, Incidents and Master Projects.
- Participate in project status review meetings and report status to the lead.
- Testing of newly added features in the system.
- Update Relevant Documents & Report Progress on Maintenance.
- DRP Testing.
- Primary contact for conversion of FTP process to SFTP process
- Involved in TIMES-PLM Migration by fetching all the data from database and providing the file formats to PLM team