SUMMARY:

• Tableau Developer Over 14+ years of IT & Analytics experience, A Skill Set Ranging from Data Analysis & Visualization, Exploratory data Analysis, Business Intelligence/Data Warehousing Industry solutions with expertise in Tableau Desktop, Tableau Server, SQL, R, SSIS (SQL Server Integration Service), SSRS (SQL Server Reporting Server).
• 14+ years of experience in Business Analysis , Data Warehousing , Data Mining , Data Analysis focusing on Design, Development , Implementation and Testing of Business Intelligence and Data Analytics applications .
• 6+ years of extensive experience in Tableau Desktop , Tableau Server , Tableau Public , Tableau Online , and Tableau Reader in various versions of Tableau .
• Experience in Software Development Life Cycle ( SDLC ) that include duties like providing documentation on design, testing and migration from development to production.
• Performed extensive GAP analysis in the project.
• I was involved in building views , dashboards , storyboards , publishing interactive reports and dashboards, and scheduling reports using Tableau server .
• Worked on row level security and user filters to restrict data for particular users.
• Worked on extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, Groups , Hierarchies and Sets to create detail level summary reports.
• Expertise in the concepts of Data Warehousing , Data Marts , ER Modeling , Dimensional Modeling , Fact and Dimensional Tables .
• Performed Tableau Server admin duties , add users/groups from Active Directory , and schedule instances in Tableau Server including weekly data dump.
• Experience in creating aggregates, sets, Joins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters.
• Excellent understanding of Data modeling ( Dimensional & Relational ) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases ( Oracle ), OLAP SAP BW, MS Excel , MS Access , Teradata and DB2 .
• Provided training to different business users about the use of the tool developed. Provided 24/7 production support for Tableau users .
• Extensive experience in designing and development of various dashboards, reports utilizing various 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 business/client requirement.
• Administered user, user groups, and scheduled instances for reports in Tableau .
• Extensive experience on building Analytic Dashboards using Tableau .
• Experience in configuring reports from different data sources using data blending . Prepared backups using Tabadmin and Tabcmd commands .
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XML and HTML .
• Expert in Strong understanding of dimensional data modeling , Strong SQL optimization capabilities, Metadata Management ( Connections , Data Model ).
• Solid understand of SQL and understand and have worked with various data source types like Oracle , SQL server , Excel , etc.
• Improved Reports performance in Tableau using extracts and context filters .
• Involved in Server Administrator -Experience in installations , upgrades , general admin / maintenance activities.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS:

Reporting Tools: Tableau Desktop 2019/2018.x/10.x/9.x, Tableau Reader, Tableau Server 2018.x/10.x/9.x, SSRS, Oracle Reports/Forms, OBIEE, XML publisher

Databases: Oracle SQL/PLSQL 8i/9i/10g/11g/12c, Teradata, SQL Server

DWH / BI Tools: Informatica, SQL Server Reporting Services (SSRS), SSIS

Operating System: Unix Shell scripting, Linux, Window NT/XP

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007, Lotus Notes

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, C, C++, C#, XML, HTML, CSS, JavaScript, DHTML, HTTP, Shell Scripting

Tools: SQL Developer, PL/SQL Developer, TOAD, SQL* Loader, SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Tableau, Power BI.

PROFESSIONAL EXPERIENCE:

Confidential - Milwaukee , WI

Sr. Tableau Developer/Admin

Responsibilities:

• Interacting with Business Architecture and Reporting Manager, gathering the requirements according to client needs.
• 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.
• Responsible to Create Dashboards for Open and Closed Analysis, Retention, Loss Ratio, Current Portfolio management using Tableau Desktop and Server.
• Involved in migration reports from Sap BO to Tableau and involved in Data extraction and transformation to Oracle BI to Tableau.
• Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
• Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL packages in Informatica.
• Implemented Installation and Upgrading of Tableau Desktop 2019.x /10.5 and Tableau Server. Involved in license management SLA's with Tableau support.
• Manage the application's users, groups, and integration with Active Directory.
• Involved in reviewing business requirements and analyzing data sources from Excel/MySQL, Redshift for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Experience in taking back ups and restoration of Tableau repository.
• Maintaining server activities, user activity, and customized views on Server Analysis. Gather, analyze, document requirements & understand functionality of application and work on large datasets.
• Extensively designed, developed and tested visualization solutions using best practices for Tableau report development.
• Worked as Tableau SME in migrating the dashboards from Excelreports and Business objects to Tableau Dashboards also responsible for the design, development and production support of interactive data visualizations used across the company.
• Hands on experience using advanced analysis, Actions, Calculations, Parameters, Background images, Maps, Groups, Hierarchies and Sets to create detail level summary reports and Dashboards using KPI's
• Working on improving views and making them more meaningful and maintaining high data integrity.
• Published, customized reports and dashboards, report scheduling and assigned appropriate permission sets for Tableau server logons and security checks.
• Resolved performance issues and worked for better scalability and availability of Tableau server. Extensively used Custom SQL queries to better import and manipulate data.
• Prepared proof of concept for best practices in Tableau deployment and visualization.
• Assist managers in meeting client expectation by monitoring timely delivery of daily, weekly and monthly deliverables.
• Publishing Reports, workbooks & data source to the server and export the reports in different Formats.
• Effective oral and written communication. Ability to engage meetings/calls with clients/counter parts in other groups.

Environment: Tableau Desktop (2018.x /2019.x/10.x), Tableau Server (9.x/10.x), Hyper, Informatica, Flat files, Oracle, Sql Server, SQL*Plus, TOAD, Windows 2010, Tableau Data Prep, Alteryx

Confidential - Great Neck, NY

Tableau Developer

Responsibilities:

• Worked on the development of Tableau Dashboard reports for Key Performance Indicators for the top management.
• Worked extensively to implement different performance improving techniques like adding data source filters, context filters, creating extracts etc.
• Automated weekly Flash Sale dashboards using Tableau and excel.
• Generated various reports and analysis as per business needs.
• Tracked daily incoming user data using Adobe analytics.
• Used Action filters, Parameters and LOD calculations, Quick Table calculations, Sets, etc. for preparing dashboards and worksheets in Tableau.
• Fired complex high-level queries using SQL server to help business decide the marketing strategies.
• Developed 360-degree sales tool for business users using multiple panels and parameters. Collaborated with Senior Data engineer to develop a new system of data collection on Salesforce using Tableau.
• Experience working with Extract & Live connections with high data volumes and connecting to multiple data sources like Oracle, MS Access, Excel, and My SQL using Data Blending.
• Extracted the multiple tables/data from oracle database and generated reports by using Tableau Desktop.
• Prepared backups using Tabadmin and Tabcmd commands
• Created a report using multiple tables connecting to oracle database.
• Worked and generating various workbooks and dashboards extracting data from various Data sources such as Oracle, SQL Server and data files using data blending and joins.
• In depth knowledge of Software Development Life Cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment.
• Regularly accessing JIRA tool and other internal issue trackers for the Project development.
• Mastered in designing and deploying graphical rich visualization with drilldown options.
• Strong working knowledge in software development methodologies like Agile, Waterfall across the span of various projects.
• Spearheaded the organizations efforts in creating actionable business intelligence reports in Tableau and established business intelligence reports in Tableau and establishing an effective Tableau implementation strategy.
• Participation in all phases of the software development life cycle including designing, coding, testing, deploying, and providing production support of application solutions.
• Created Tableau mobile dashboards to use via Tableau mobile application.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
• Supporting multiple projects for marketing department: banners, GUI, email blasts, promotional materials, retractable banners, product cards, gif animated and extra.
• Clearly displayed consumer insights for the products in the form of report, dashboard. Involved in contributing ideas during team brainstorming activity.
• Creating New Schedules and checking the tasks daily on the server, maintaining server activities, user activity, check security configuration and customized views on Tableau Server.
• Managed Tableau server tasks like publishing dashboard on server, creating user profiles, subscribing, scheduling full refresh, assigning user roles and permissions and managing user security roles.
• Build custom time frame dashboards to compare any date range of one period with another.
• Scheduled Tableau dashboard for full refresh on the Tableau server and manage security.

Environment: Tableau Desktop 9.3.3/10.3 SQL server/Oracle, Windows 10.

Confidential - Appleton, WI

Tableau Developer

Responsibilities:

• Involved in gathering requirements from the Business Users and produce technical, functional specifications for the reporting system. Study and understand the Business Scenarios of the existing systems, understanding the data and validating the data by applying the current business rules
• Analyzed data sources form Excel/Oracle SQL Server for Design, Development, Testing, and Production rollover of reporting and analysis projects within Tableau Desktop. Responsible for security configuration including Group setup, Permissions, Security roles and configuration of trusted ticket authentication.
• Worked on administration tasks like adding workbook Permissions, Ownerships and User filters.
• Effectively used data blending feature in Tableau to connect different databases like Oracle, MS SQL Server, SQL and Excel.
• Responsible for Efficient Data Model Design by creating views and accessing them in the report by blending across different data source.
• Built functionalities by writing condition to in corporate with various metrics and hands on experience in Level-of-Detail (LOD) expressions such as daily profit Key Performance Indicators (KPI), Percent of total, Yearly trending analysis and Root cause behavior.
• Created Relationships, Actions, Data Blending, Filters, Parameters, Hierarchies, Calculated fields, Sorting, Grouping, Live connections and in-memory in both Tableau and Excel.
• Developed Tableau data visualization using Pareto&, Combo charts, Heat maps, Box and Whisker Plot, Scatter Plots, Geographic Map, Cross tabs, Histogram, Pie charts etc.
• Used Tabadmin and Tabcmd commands in creating 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.
• Created a Row Level Security and shared the reports with Functional/Business users. orked on groups, sets, different Advanced Analytical calculation functions including Table calculations and Window Calculation.
• Used live connection with Netezza and Oracle database schemas to provide near real-time data.
• Migrated Tableau Dashboard from version 9.3 to 10.3 and adding users to the AD group. Used Tableau Desktop to create various analysis worksheets, including customer analysis and equipment analysis.
• Provided support for Tableau developed objects and sound understanding the tool administration.
• Use SSIS to extract, transform and load data directly from different source systems that includes flat files, Excel, Oracle and SQL Server.
• Extracted data from different data sources like SQL Server, MySQL and Tableau Server and created queries based on the requirement to provide data visually.
• Written Custom SQL to support Business requirements.
• Fine Tuning SQL to improve performance of report and extraction times of data extract.
• Experience in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Executed and tested required queries and reports before publishing. Documented complete server architecture and solutions to Troubleshoot performance, Scheduling, and server related issues.
• Actively interacted with the stakeholders to guide them and acquaint them with the various visualization Charts that was used in the dashboard.

Environment: Tableau Desktop 9.3.3/10.3, Tableau Reader 10.3,MS SQL Server, MS Access 2016, Oracle11g, MY SQL, Teradata, HTML, SQL Server Management Studio, Microsoft Office Suite (Word, Excel, PowerPoint, Visio).

Confidential

Data Analyst/ Tableau Developer

Responsibilities:

• Proficient in designing of the Data modeling (Dimensional & Relational) concepts like Star Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Developed SQL Procedures, Queries and objects for consumption by Tableau.
• Experience working with Extract & Live connections with high data volumes and connecting to multiple data sources like Oracle, MS Access, Excel, and My SQL using Data Blending.
• Good in creating Reports that include Filters, Charts, Scorecards, Drilldown and Drill.
• Created several types of visualizations using Sets, dynamic sorting etc.
• Involved in testing the SQL Scripts for report development, Dashboards, Scorecards and handled the performance issues effectively.
• Implemented best practices following the company standards in smart techniques in Tableau.
• Performed basic statistical analysis for creating and presenting quality reports.
• Engaged in all client meetings at the time of BRD.
• Created proof of concept for better data integration process.
• Installation and Configuration of Tableau Server and Tableau Desktop on Windows.
• Strong ability in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Involved in custom geocoding reports.
• Extracted the tables/data from oracle database and generated reports by using Tableau Desktop.
• Created Relationships, actions, calculated fields, sorting, groupings, live connections, and in memory in both Tableau and excel.
• Strong understanding of Data warehouse concepts such as Star Schema, Snowflake, Data Modelling, Business Process Analysis.
• Optimized SQL scripts to improve the efficiency on the database.
• Created filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.
• Worked and generating various workbooks and dashboards extracting data from various Data sources such as Oracle, SQL Server and data files using data blending and joins.
• Very Good Understanding and Experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Strong working knowledge in software development methodologies like Agile, Waterfall across the span of various projects.
• Environment: Tableau Desktop version-9.0/9.1 & 10.0/10.2, SQL server/MySQL, Windows 9.

Confidential

Data Analyst

Responsibilities:

• Collaborated with project managers and business owners to clearly define specific business needs, expectations and timelines for Business Intelligence projects.
• Working on data migration projects involving Cloud & Big data technologies like Microsoft Azure data Lake, Azure SQL data warehouse, AWS, Apache Spark, Azure data Factory, Azure Service Bus, Azure Functions.
• Building complex ETL pipelines for On-Premise systems using Microsoft SQL Server Integration Services (SSIS).
• Working on Kanban board in JIRA and following agile methodology in solution development.
• Developing report dashboards using Microsoft PowerBI, Microsoft SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and Microsoft Excel.
• Maintaining and reporting operational KPIs on items such as performance, service incidents and tickets set forth by the business team.

Environment: Microsoft Azure, Microsoft BI tools, AWS, Python, SQL

Confidential

Data Analyst

Responsibilities:

• Extracted data using T- SQL from the SQL server database. Interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.
• Used Microsoft Excel (Pivot Tables, VLOOKUP, Pivot Chart, Power Pivot, and VBA) to perform a descriptive analysis of customer's data and share the results with business managers to help them in marketing communication.
• Responsible for preparing metrics and reports for weekly and monthly metrics review, created visually impactful dashboards using Microsoft Power BI with different descriptive analysis to deliver insights on trends to business manager.
• Performed ETL testing to ensure that data correctly extracted and loaded to the target

Environment: T-SQL, TABLEAU, EXCEL, CAD, MATLAB Describe your responsibilities and achievements in terms of impact and results. Use examples, but keep it short.