SUMMARY:

• Over 10 years professional experience in Tableau 7.x/8.x/9.x/10.x/2018.x, Tableau Server, Tableau reader and MS SQL Server, Oracle PL/SQL
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage
• Hands on experience on deploying and scheduling reports to generate all daily, weekly, monthly and quarterly reports including status. Established best practices for enterprise Tableau environment and application intake and development processes.
• Developed and modified drill - down, drill-through, linked reports, subreport, charts, Formulas, parameterized reports, Navigation reports and dynamic reports using Tableau.
• Developed story telling dashboards in Tableau Desktop and published them on to TableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
• Proficient in creating solution driven dashboards by developing different chart types including Dual Axis, Crosstab, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs and Histograms, Funnel Charts, Box Plots, Waterfall Charts, and other making use of actions, other local and global filters according to the end user requirement
• Strong skill set in implementing forecasting, Data Blending, Customized queries, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau desktop
• 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
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Experience working in Agile & System Development Life Cycle (SDLC)
• Extensive knowledge in various reporting objects like attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups and parameters
• Strong advanced tableau developer skills such as nested calculation, table calculations, parameters, geographic mapping, data blending, and extract optimization
• Thorough understanding of Kimball/Inman strategies, KPI, Data mining structures
• Expert in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Well versed in implementing Data blending, Replace references, customized queries and advanced visualizations in Tableau
• Hands-on experience in developing, testing and deploying complex SSRS reports. Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.
• Outstanding analytical and problem-solving skills communicating effectively to accomplish all project deliverables in a fast-paced environment.

PROFESSIONAL EXPERIENCE:

Confidential, Troy, MI

Sr. Tableau Developer

Responsibilities:

• As Sr. Tableau Developer, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
• Solving P1 issues for the users in the production.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Created and maintained SOX documentation required for critical financial file systems.
• Mentored and trained less tenured Business Analysts for their development.
• Use tools such as SQL and Insync for investigation of issues and work closely with our Actuarial and Underwriting Customers.
• Managed projects ranging from large to small.
• Created, maintained and queried relational database (MS Access) . Understand and use SQL regularly for problem analysis.
• Member of a team that created the proof of concept for the selection of the ETL tool (BI tool) . Sat with vendors and evaluated vendor tools during the proof of concept.
• A member of the team that designed and created the infrastructure for a Data Store which was used for conversion and routing of information created outside of the company and moved to Safeco data source.
• Created specifications for the conversion of data outside of Safeco into legacy data. Learned and understood complexities of outside systems and was able to convert into Safeco terms.
• Work and communicate daily across departmental boundaries.
• Proven strong analytical and problem solving skills.
• Team member of the data warehousing initiative - conducted interviews with high level management about their data warehousing needs.
• Willingness to learn new technologies. Enjoy working on the technical side as well leading project efforts.
• Created incremental refreshes for data sources on Tableau Server.
• Created report schedules, data connections, projects, groups in Tableau Server.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Created Ad hoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used Excel, flat files, CSV files to create Tableau Ad hoc reports.
• Design interactive dashboards in Tableau Desktop and published them to Tableau Server.
• Ability to work independently and deliver around tight timelines.
• Coordinate with multiple technology teams on production releases and related administrative tasks.

Environment: Tableau Desktop 2019.2/2019.1/2018. x/10.5, Tableau Server 2019.1, MS Office Suite, SQL, T-SQL, PL/SQL, MS-Excel, MDX, DAX, OLAP Cubes, Microsoft Analysis Services.

Confidential, Virginia

Sr. 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 Tableau 7.x, 8.x, 9.x, 10.x tools include Tableau Desktop, Tableau Reader, Tableau Public, and tableau Server.
• 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, Providence, RI

Tableau Developer

Responsibilities:

• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analysis and front-end display
• Monitored project status to meet milestones and resolved issues with data quality or the ability to deliver to timescales or estimates
• Scheduled SSIS Packages, stored procedures and reports with SQL server agent and Windows batch file commands based on time interval to load many data
• Created Error and Performance reports on SSIS Packages and alerts for successful or unsuccessful completion of scheduled jobs using SQL Server Agent Job Task and Event Handlers
• Generated Tableau Dashboards with quick/context/global filters, parameters and calculated fields on Tableau reports to visualize the trend and distribution of data using Tableau
• Built nested formulas in Tableau for various business calculations
• Used Tableau for creating a matrix and tabular, drill down, drill through, sub-reports and parameterized reports based on requirements
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions
• Designed, created and deployed ad hoc reports, drill down reports, drill through reports, tabular reports, form reports, multi-column reports, matrix, as well as charts in Tableau requested by the end user
• Used Power Pivot when requested to display analysis result with visual

Environment: Tableau Server, Tableau Desktop 9.x, SQL Server 2012, SQL Server Management Studio (SSMS), MS BI Suite (SSIS), SQL Server Data Tools (SSDT), Visual Studio 2010, MS Office Suite 2010 (Excel, PowerPoint, Word)