SUMMARY:

• Overall 8+ Years of experience in Tableau Desktop 10.1, 10.2, 9.3, 8.x /Server and SQL server, creating highly interactive Data Visualization reports and dashboards.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• Proficient in creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bubble Charts, Funnel Charts, Bar Charts (Horizontal, Stacked), Bullet Graphs, Area Charts, Scatter Plots, etc.
• Extensively built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data using Tableau.
• Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
• Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.
• Experienced professional having thorough knowledge of SQL Server, Dashboards, Reports, Teradata, Excel and desktop management.
• Expert in strong understanding of dimensional data modelling, Strong SQL optimization capabilities, Metadata management i.e., Connections, Data model and VizQL model
• Hands on Experience on Google Big Query (Google Cloud).
• Created Tables in Google cloud using Big Query. Extracting the data from the Google Cloud for reporting on Tableau.
• Proficient in Dimensional Modeling using Kimball and Inmon methodologies for Star and Snowflake schema designs of Data Warehouse and Data Integration projects.
• Outstanding knowledge in writing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Hands - on experience in trouble shooting, Performance tuning of reports and resolving issues within Tableau Dashboards and worksheets.
• Experience with Relational Databases in a SQL/Oracle Server environment
• Experience with MS SQL Server Reporting Services (SSRS), (SSIS) MS SQL Server Integration services, MS SQL Server Analysis Services (SSAS).
• Impeccable attention to detail & accuracy, handle process information, business models and needs.
• Skilled at handling requirements, analysis, maintenance support. Self-motivated and goal oriented with high degree of flexibility, creativity, resourcefulness, commitment and optimism.

PROFESSIONAL EXPERIENCE:

Confidential - Cleveland, OH

Sr. Tableau Developer

Responsibilities:

• Worked on Planning, Designing, Publishing of new Dashboards for the Managers and Director to analyze the metrics along with improving and upgrading the existing reports.
• Worked closely with the team of data analysts and planned the data staging according to the requirements and using views and custom SQL queries.
• Created summarized reports for Sales, Production, Commission to analyze the different metric performances and effects on overall profit, loss or expenditure.
• Created reports for the representatives of the company and interacted with the representative trainers for the feedback on the reports created.
• Also created reports for analyzing individual performances of the agencies through trends and scatter plots to identify the outliers.
• Used analytics like LODs, KPIs, Viz in tooltips, forecasting, maps to present detailed reports on risk factors, seasonal competitions and market trends for the department.
• Used different data sources from Microsoft SQL, DB2, excel sheets, Microsoft Power pivot and Tableau Prep cleaned files using data blending or cross database joins.
• Involved in publishing the dashboards to server with email enabled for certain thresholds as notifications to the users.
• Involved in planning and migrating SSRS reports to Tableau Dashboards for the Department.

Environment: Tableau Professional 10.5, 2018.1, Tableau Server 2018.1.1, MS SQL Server 2016/2014/2012 , MS SQL Server Reporting Services, TFS, MS ACCESS, DB 2, Tableau Prep 2018.2

Confidential - Providence, RI

Tableau Developer

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Involved in conversion of Micro strategy reports to Tableau Workbooks.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Salesforce, Oracle, Teradata and SQL Server.
• Developed LOD reports on various KPI's.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Performed UNIT testing and help the UAT testing team to performing various testing scenarios.
• Fixed the JIRA tickets raised during the UAT testing.
• Created incremental refreshes for data sources on Tableau server.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost.

Environment: Tableau 8.1.x, 9.x, SQL Server 2012, PL/SQL, SSAS, SSRS, Jira, Microsoft Visual Studio 2010.

Confidential - Morris Plains, NJ

Tableau Developer

Responsibilities:

• 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.
• Built Strategic, Analytical and operational dashboards using Tableau.
• Developed Wrapper in Python for instantiating multi-threaded application.
• Involvement in end-to-end activity of dashboard development from requirements gathering to deployment phase.
• Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.
• Worked in ASDW team where solved issues raised by the front-end users and worked on the Tableau reports per the user's requirements.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Tableau integration for enhanced experience for the users.
• Created extracts and published data sources on tableau Server for the users from various databases in Green Plum. Used complex joins and validated them by running and tuning long SQL queries.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data

Environment: Desktop 8.1, Tableau Server, MS Office Suite, SQL Server, SAS, SSRS, SSIS, MS Excel, Sales, Teradata.

Confidential - Riverwoods, IL

Tableau Developer

Responsibilities:

• Have been working in the Student loan department with DWH team to migrate the data from legacy system to Finacle.
• Experience in Building customized Interactive Reports, Views and Dashboards as per end user requirement.
• Hands on experience in creating Joins and Blending data from heterogeneous sources.
• Proficient in design and development of various dashboards, reports using Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts etc.
• Implemented Quick Filters, Cascading Filters, Context Filters and Data Source Filters while handling huge volume of data.
• Having experience in identifying, analyzing and interpreting trends and patterns in complex data sets.
• Proficient in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Mastered the ability to design and deploy rich graphic visualizations with Drill Dow, Drop-Down menu option and parameters using Tableau Desktop.
• Created solution driven dashboards by developing different types of charts including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs and Histograms in Tableau Desktop.
• Worked on creating visualizations using custom hierarchies, groups and merged data from multiple sources using the data blending technique with in the tableau workbook.
• Knowledge in Data warehousing concepts such as Star Schema & Snowflake schema etc.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community. Created conditional filters and Action links to filter the data on dashboard.
• Used various types of aggregations like sum, average, count, count (distinct), median, minimum, maximum, percentile and std. deviation, etc. to build strong informative dashboards.
• Developed Tableau workbooks to perform year over year, YTD, QTD and MTD type of analysis.
• Hands-on development in assisting users by creating and modifying worksheets to get best data visualizations.
• Written complex SQL queries using Joins, nested sub queries, Set Operations, aggregation and Advanced OLAP Functions.
• 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.

Environment: Tableau Desktop 8.x, SQL Server, Finacle banking product, Oracle, HiveQL, Teradata, SQL Assistant, Abinitio, Tivoli Workload Scheduler, SecureCRT.

Confidential

SQ BI Developer

Responsibilities:

• Involved in gathering the requirements and identifying the key performance metrics for end users.
• Designed new data sources for developing analytical reports from multiple data sources like Microsoft SQL Server, Microsoft Access.
• Developed SQL Scripts for creation of various Database Objects (Stored Procedures, Indexes, Triggers, and User Defined Functions)
• Developed complex queries using joins and sub-queries and Created multiple views and queries.
• Involved in Extract, Transform and Load (ETL) process framework.
• Involved in user interface design and developed scripts to support business needs.
• Designed and Developed dynamic dashboards and enhancements to existing reports and capabilities in alignment with business needs.
• Worked on designing and developing various reports using different chart visualizations like Gantt charts, bar graphs and bullet graphs.
• Managed Metadata and Extracts using Tableau Desktop and published the Data source to the Tableau Server.
• Created bar charts, tree maps, bullet charts and Gantt charts.
• Created ad-hoc reports and Dashboards according to User requirements.

Environment: Microsoft Access, SQL Server Management Studio, SQL server, Visual Basics, Crystal Reports, Tableau Desktop 8.x, Tableau Server.

TECHNICAL SKILLS

Business Intelligence Tools: Tableau Desktop 10.0x, 9.x, 8.x, Tableau Server, Business Objects 4.0, 4.1 and SAP BI 7

ETL Tools: Informatica Power Center, Power Exchange, Data Modeling, IDQ

Languages: python, IBM DB2, HTML, SQL, PL/SQL, XML, C, C++, VB 6, VBA, VB.NET, C .NET, HTML, SQL

Databases: Oracle10g, SQL Server 2005, 2008R2, IBM DB2, Teradata, MS Access

Operating Systems: Windows XP, Windows 7, Windows Server 2005/2008