Description
Professional Summary: * Have 8+ years of Data warehousing experience with Business Intelligence Tableau 8.0/ 7.0, OLTP and OLAP Microsoft SQL Server, SSRS, SSIS as a Developer in various companies. * 5 years of extensive Tableau Experience in Enterprise Environment, in Tableau 8x to 10x as a developer and Administrator. * Created 1000+ worksheets and 200+ Dashboards in large BI environments using Tableau. * Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, Security Concepts, calculations and Relationships. Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards. * Reports development using various reporting tools like Tableau, 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. * Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository. * 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 8.1 * Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects. * 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. * 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.
Accomplishments
Highlights:
Keywords
