Candidates About

 

Vani

Tableau Developer

 

 

SUMMARY:

 

·         8 years of Data warehousing experience with Business Intelligence Tableau 8.0/ 7.0, SAS, OLTP and OLAP Microsoft SQL Server, SSRS, SSIS as a Developer in various companies.

·         Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0, 8.1, 8.2 and 9.0 as a developer

·         Extensive knowledge in creating wide number of Dashboards and worksheets in large BI environments using Tableau 9.0/8.1/8.0/7.0.

·         Good hands on experience in handling Master tickets and resolving issues of users.

·         Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, Security Concepts, calculations and Relationships.

·         Experience in developing and implementing tableau changes such as upgrades and migration.

·         Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards.

·         Reports development using various reporting tools like Tableau, SAS and SSRS.

·         Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.

·         Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.

·         Involved in creating Dashboards as needed using Tableau Desktop and Tableau Server.

·         Experience in creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts 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, other local and global filters according to the end user requirement.

·         Involved in installation of Tableau desktop 8.0, Tableau server Application software

·         Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.

·         Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.0 to Tableau 9.0

·         Expert in modeling, Extraction Transform Loading (ETL) using DTS and SSIS.

·         Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.

·         Proficient in handling parameterized reports in SSRS.

·         Good knowledge on scripting languages like R and python.

·         Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling

·         Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server

·         Extensive Dimensional Modelling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables.

·         Good ability to Provide 7/24 Production Support for Tableau

·         Good ability to work independently and well in a team

·         Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.

·         Creating users, groups, projects, Data connections, settings as a tableau administrator.

·         Created visualization for logistics calculation and department spend analysis.

·         Developed Ad-hoc ETL, reports requirement runs.

·         Expertise in gathering the requirements from the business users, coordinating the deliverables end to end with the technical team.

 

EDUCATION:

 

Bachelors in Computer Science and Engineering - INDIA.

 

TECHNICAL SKILLS:

 

 

PROFESSIONAL EXPERIENCE: 

 

 

Description: Barclaycard is a credit card provider. Barclay holds many clients for providing its banking services. We need to develop the new dashboards, maintain and enhance the existing dashboards and publish to production. As ongoing project dealing with multiple projects on quarterly basis.

 

Responsibilities:

 

·         Involved in reviewing business requirements and analyzing data sources from SAP HANA for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

·         Worked directly with business customers to build reports, dashboards and ad-hoc reports.

·         Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

·         Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.

·         Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop. 

·         Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.

·         Good knowledge on scripting languages like R and python.

·         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 like to link data from different connections together on one dashboard and to filter data in multiple views at once.

·         Participated in Preparing Detailed technical documents from the functional specifications. 

·         Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.

·         Executed and tested required queries and reports before publishing dashboards.

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

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

·         Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.

·         Created Workbooks and dashboards for analyzing statistical billing data using Tableau 9.0

·         Created multiple visualizations like Heat Maps, Bar Graphs and Bullet Graphs.

·         Preparing Dashboards using calculations, parameters in Tableau. 

·         Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.

·         Good ability to Provide 7/24 Production Support for Tableau

·         Good ability to work independently and well in a team.

·         Integrated R studio with Tableau to generate reports based on the client requirements.

 

Environment: Tableau Desktop 9.0, Tableau Server, MS Office Suite, Teradata, MS Excel,Rstudio.

 

 

Description: Texas Instruments incorporated designs, Manufactures and sells semiconductors to electronics designers and manufacturers worldwide. It operates in two segments Analog and Embeded processing. Analog segment offers power products to manager power requirements in various levels using battery management solutions. Embeded segment offers products for use in various markets, principally industrial and automotive.

 

Responsibilities:

 

·         Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.

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

·         Collaborated with front-end and backbend developers using agile best practices and GIT to develop efficiently as an organization.

·         Develop a scalable architecture for staging and loading data using Oracle database.

·         Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Oracle.

·         Extracted data from SAP source system using DB connect and flat files interface.

·         Extracted data from SAP (FI & PCA extractions) and legacy systems (using DB connect). Involved in Generic Extraction of PCA data.

·         Worked extensively to debug the existing SAP program and modify the code using modification assistant to customize the program as per requirements.

·         Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using Tableau.

·         Designed and developed stored procedures, queries and views necessary to support Tableau reports.

·         Served as a SSRS 2000 Reports Developer and SQL Server Developer in support of Service Management System.

·         Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.

·         Used different Mark types and Mark properties in views to provide better insights into large data sets.

·         Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.

·         Used Tableau for creating tabular and drill down, drill through, and parameterized reports based on the requirements.

·         Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.

·         Integrated the tableau reports to other portals.

·         Provided reporting solutions for OLTP and OLAP systems.

·         Published Workbooks and Dashboards to the Tableau server.

·         Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.

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

·         Combined visualizations into Interactive Dashboards and publish them to the web.

·         Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users

Environment: Tableau 8.0/9.0, Tableau server, Oracle 11i, SQL, TOAD, Windows 2003/XP, UNIX.

 

 

 

Description: Point 72 assets management is a firm investing in the public equity markets for long as well as short equity strategy to make investments. Also involves in financing, managing Directors sir counterparts relationships and dir crying its contract negotiations across the products. Involves in managing all external broker relations.

 

Responsibilities:

 

·         Oversee the performance of design to develop technical solutions from Analysis documents.

·         Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel.

·         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.

·         Involved in creating views, stored procedures, and custom SQL queries to import data from SQL server to Tableau.

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

·         Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.

·         Tableau Logs - Reviewing the Server logs for any errors or security issues that are unexpected.

·         Performance Logs - Reviewing the performance metrics to determine if the baseline exceeded or for the slow points during the day that need to be reviewed.

·         Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.

·         Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.

·         Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.

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

·         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.

·         Oracle Backups - Checking/Verifying all the backups to validate that they were successfully created.

 

Environment: Tableau Desktop10.0, Tableau Server, Oracle SQL Server R2, MS Excel, SQL.

 

 

Description: The HI-Exchange Project dealt with development of an online HIE (Health information exchange) and a secure web portal to enable authorized Franklin Square Hospital providers to have fast and easy access to patient's electronic health record. The HI-Exchange web portal features EMR functions and decision Support tools for better care management. The project dealt with development of a Health Care Cost Containment Integrated Clinical System and implementation of an automated inter-operable web application that tracks patient medical history and health care plans via Viewer application and Electronic health records. The Viewer/EHR system provided online access to mobile patient records and improved communication in public health. 

 

Responsibilities:

 

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

·         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 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.

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

·         Involved in Data profiling, data analysis and data visualization with SAS new features, tools and technologies including SAS Visual Analytics.

·         Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.

·         Creating visually compelling and actionable interactive reports and dashboards.

·         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.

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

·         Experience in developing Drill through and Drill down reports, parameterized reports, linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS).

·         Setup and Monitor MySQL Slave replication in Multi master and slave environment and providing HA solutions.

·         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.

·         Follow SOPs and administration guidelines for server upgrades, backups, patching, performance tuning, and security and administration of the applications.

·         The individual will be using administrative guidelines and industry best practices to administer Tableau Server.

·         Involved in troubleshooting and performance tuning of reports and r