SUMMARY

• Having 4+ years of IT Experience in design, analysis, development of Tableau Developer in Manufacturing, Retail and Financial industries.
• Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau Tableau 6.x/7.x/8.x/9.x/10.x Desktop, Server, Mobile, and Public, Micro Strategy, Business Objects and SSRS.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Experience in facilitating Joint Requirement Planning JRP sessions with Business User Groups, conducting Joint Application Development JAD sessions with IT Groups.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Managed cross - functional teams through Software Development Life Cycle.
• Created dashboards using different types of charts like bar chart, line chart, dual axis charts, pie charts, map charts with layers, funnel and pyramid charts etc.
• Hands-on experience with Tableau suite of products- Server, Desktop, ETL, OLAP analysis and reporting processes using Tableau, MS SQL Server 2005 and BO. Working knowledge of ETL processes of SSIS Packages, MS DTS, OLAP analysis SSAS cubes and SSRS reporting applications (Operational and Business Intelligence).
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Strong skills with Business Intelligence application stack including Tableau Desktop/Tableau Server/Tableau Public/SSIS/SSAS/SSRS, Performance Point Server, multi-dimensional cube building, OLAP/MOLAP and have the solid experience in data warehousing/BI environments. strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• 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.
• Outstanding knowledge in Microsoft Office suite MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Deep experience with the design and development of Tableau visualization solutions.
• Working on generating various dashboards in Tableau server using various sources such as Teradata.
• Experience setting up and managing Tableau Server with large volumes of data.
• Setting up Tableau data sources. Filters, blending, joins for optimum performance and Trouble-shooting issues

TECHNICAL SKILLS

Tools: Tableau Desktop 10.5/9.x/8.2,8.1,8.0/7.X/6.X, Tableau Server, Tableau Reader, Tableau online, Tableau Administration, Spotfire, Power BI, Qlik Sense, Alteryx

Operating systems: Windows XP/2003/2007, Windows Server 2003/2008, UNIX

Programming Languages: HTML, SQL, T-SQL,PL/SQL, Java, J Query, C and C++, knowledge of Python

Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, MS Access 2000, Teradata, Oracle 11g/10g/9i/8i/8.0.

Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Erwin

Methodologies: Complete Software Development Life Cycle, Waterfall, Agile, Iterative, Scrum

Operating Systems: UNIX, Linux, Ubuntu and Windows

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer

Responsibilities:

• Used different type of Transformations for Data Conversion, Sorting and cleaning the data from different sources into Company format.
• Automated SSIS Packages using SQL Server Agent Jobs and Windows Scheduler .
• Created complex Stored Procedures , Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created Parameterized, Cascaded, Drill-down, and Drill-through reports using SSRS .
• Responsible for data preparation, data blending, and the creation of data models / sets using Alteryx
• Designed, built, and tested several complex workflows in Alteryx
• Experienced coding and modifying SQL/ETL/Alteryx based on dashboard requirements in Tableau Designing and developing data source, dashboards in Tableau
• Developed highly polished executive level dashboard prototype regarding total sales views, and Top Payers
• Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions, and provided an interactive reporting environment in the developed dashboards.
• Created Bar Charts, pie charts, box plots, scatter plots for patient statuses, sales, and payers illustrating the total value change with respect to several weeks ago data.
• Created Star schemas, Snowflake schema, fact and dimension tables, logical and physical modeling.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Implemented Tableau Online to enable cloud implementation of analytics developed on Tableau desktop, and to make dashboards available on the cloud platform being implemented by the client.
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the POC.
• Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.
• Extensively using Alteryx tool to combine and prepare data and then exporting as TDS source.
• Developed the Reports like Patient Status Metrics, Top Payers, Top Prescribers on Total Patients, Dormant Patients, Days Between Refills, Active Patients, and Total Shipments by Prescriber, Etc.
• Validated data between Tableau and Oracle Database by writing SQL queries.
• Created schema on Tableau by joining different tables to eliminate materialized views and flat structures on oracle database.
• Published finished Dashboards to tableau online.
• Involved in tables design in Oracle data base.

Environment: Tableau (Desktop/Server), Alteryx, SQL, ETL, Adobe Analytics, Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, Greensboro, NC

BI tableau developer/ Data Analyst

Responsibilities:

• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created dashboards by extracting data from different sources and created dashboard using parameters, sets, groups and calculations in Tableau Desktop.
• Created interactive dashboard using filter, highlight and URL.
• Created calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
• Gathered Business Requirements and conversted them as Use caces.
• Installed, Configured and setup Tableau environment in the organization.
• Connected Tableau to Sharepoint as data source.
• Worked on creating Microstrategy VI Dashboard for reporting mangers as POC.
• Used Microstratgey OLAP I-Cube to update Tableau extracts.
• Worked with Teradata database and extracted data using Alteryx and developed POCs by building reports and dashboards using Tableau 10 to demonstrate quick wins.
• Incorporating weekly changes of the data source files by integration into Tableau data sources for timely leadership reporting.
• Creating reports to show migration activities by monthly release, business functions and IT projects.
• Blending multiple data sources for single dashboard in Tableau.
• Conducted presentations and Demo on behalf of BI team.
• Participated and coordinated daily stand-ups with clients on design and development effort.
• Created data visualizations using Charts, drill-down, parameterized controls using Tableau.
• Extensively used calculated fields for different logics for Trend.
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis. Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Generated the test plans specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope. Prepared test scripts and documented user training modules.
• Maintained Test log and created Test Evaluations, Summary Reports.
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Provided Ongoing support to BI applications running in production & troubleshoot any issues.

Environment: s: Tableau (10.0.20, 10.1.22), Oracle11, IBM Netezza, Teradata, SQL Server, Toad Datapoint,SQL developer, Microstratgey 9.xx

Confidential

Jr. Tableau Developer

Responsibilities:

• Administered user, user groups, and scheduled instances for reports in Tableau.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Tableau Desktop, Tableau server / Administrator, Oracle 10/11g, Microsoft Excel, MS Access, Microsoft office MS SQL SERVER 2008, SSIS, SSAS, SSRS, SQL Profiler, Windows XP / NT / 2000/2003, Microsoft Access.
• Converted metric insight reports to tableau reports.
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.
• Creating dataflow diagram and documenting the whole data movement process.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
• Created Backup scripts to take periodic backups for the content on Tableau server.
• Developed SQL Server Impersonation for Impersonation Requirements, How Impersonation Works,
• Impersonating with a Run as User Account, Impersonating with Embedded SQL Credentials.
• Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing Deleting Users and Activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.
• Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server

Environment: Tableau (10.0, 10.1),Power BI 2.XX, Oracle11, IBM Netezza, Teradata, SQL Server, Toad Datapoint, SQL developer, JAMS

Confidential

Data Analyst

Responsibilities:

• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and scheduling of the dashboards.
• Created and Published Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated Tableau dashboards for sales with forecast and reference line.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to Tableau Server
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Design data visualizations and layout for marketing performance dashboard in Tableau.
• Upload dashboard to Tableau server and facilitate its use by internal stakeholders
• Optimize Google Analytics campaigns and configuration and provide analysis using built-in reports and API.
• Work as liaison between data science team and marketing team to provide marketing with data resources
• Provide strategic recommendations for targeted marketing content

Environment: SQL Server 2008/2012, MS Excel, Tableau Desktop 8.2.2, MS Access 2008