SUMMARY

• 6+ years of extensive Tableau experience in enterprise environment, in Tableau as a developer and analyst.
• Extensive Tableau experience in enterprise environment and Tableau administration.
• Experience includes technical support, troubleshooting, dashboards design and monitoring of system usage.
• Expert in Data Visualization development using Tableau to create complex, instinctive, and imaginative dashboards.
• Expertise in using Tableau Server,Tableau Desktop and Tableau Public.
• Preparing dashboards using calculations, parameters in Tableau.
• Worked on the development of dashboard reports for the key performanceindicator(KPI) for the top management.
• Expert in creating universes on OLAP BW, Oracle, SQL server, Teradata, DB2
• Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations in Tableau.
• Experience including analysis, modeling, design, and development of Tableau reports and dashboards for analytics.
• Good Experience with Teradata and Semantic Views
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill - through and Drill-down reports using SSRS
• Extensively worked on SSRS and delivered complex reports from different data sources such as SQL Database and Cubes.
• Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, sorting, sets, Transformations, filters.
• Experienced working with Water Fall and Agile Scrum projects for Dashboards development.
• Blended data from different information sources by utilizing connecting component as a part of Tableau Desktop.
• Expertise in Tableau Desktop Development, inconvenience shooting, report design, execution tuning, determining issues and distributed dashboards, exercise manuals in Tableau Server.
• Designed Tableau Data Extracts for improving visualizations perform better.
• Hands-on improvement helping clients in making and adjusting worksheets and information representation dashboards in Tableau.

TECHNICAL SKILLS

BI Tools: Tableau 9.0/Tableau 9.3, 10.5.7,MS Office (Excel, Access etc.), Qlik view, SSRS

ETL Tools: Microsoft server Integrated services

Testing Skills: Test Plan creation, Test Case Design, Test data preparation, Test execution, Defect management, Test reporting, MES, Test Manager, Test Automation script writing,GUI and API Testing.

TestTools Scripts/Languages: QTP 10.0, UFT 11.5, Selenium IDE 2.50, WebDriver, TestNG, Cucumber,sharepoint.

Databases Technologies: MS SQL Server 2012,Teradata sql Assistant, OLAP and OLTP, SQL*Plus, TOAD, SQL*Plus, SQL*Loader, MYSQL

Operating System: Windows Family, Mac

Other Tools: Visual Studio 2012, Sharepoint 2013MS PowerPoint, MS Excel, TOAD, HP Quality Center 10, MS SQL Server Management Studio, SSIS, QA

PROFESSIONAL EXPERIENCE

Confidential, Des Monies, IA

Connectivity Operational Health Team

Responsibilities:

• As part of this effort, researching what we can automate to reduce our dependency on manual reporting methods.
• I have participated with that process definition and help define how we move to automation once they become familiar with our existing workflow.
• The two primary tools leverage are Tableau for dashboard development and Microsoft SharePoint for content retention.
• I’m responsible for engaging with our internal Connectivity governance team to solicit requirements, develop approaches (through a combination of documentation and prototyping) of solutions, documenting those solutions (for support and sustainment) and implementation.
• Familiar with strong data analysis skills (SQL)to develop queries and logic within Tableau.
• Good project management skills (delivery focused, and strong follow-up).
• Strong communication and relationship management skills to support re-engineering discussions.
• Remedy Asset management (Remedy is our data SOR), creating process flows MS Visio.
• Extensively worked on various Tableau desktop 7.x/8.x/9.x/10.x/10.5.7 versions, Tableau Server, Tableau online, Tableau reader.
• Expertise in SQL Server Integration Services and SQL Server Reporting Services (SSRS) and with good knowledge on SQL Server Analysis Services (SSAS)
• Experience in creating dashboards using calculations, groups, sets, parameters, calculated fields, and hierarchies.
• Experience in creating filters, quick filters, data source filters, global filters, context filters and user filters
• Extensive experience in creating Calculations (Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting) using Tableau Desktop.
• Data blending to create views combining data from multiple data sources.
• Strong knowledge of Software Development Life Cycle (SDLC) methodologies like waterfall, Agile Scrum.
• Experience in developing reports and deploying reports in SSRS using Report Wizard, Report Builder and Report Manager.

Environment: Tableau Server 8.x, 9.x, Tableau Desktop 10.5.7, Teradata 12,Sharepoint,Visio 2010,word2010,Snag it,Remedy(for asset patterns within installed base)

Confidential, Des Monies,IA

Tableau Report Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Experience with the design and development of Tableau visualization solutions.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Define requirements and work with partners to monitor critical exectution data elements to ensure accuracy and timeliness.
• Participate in process design and provide necessary subject matter expertise to define key performance materics, dashboards and scorecards.
• Define and report on metrics related to data quality for campaing execution data.
• Provide metadata requirements and work with partners to implement use of a standardmetadata too for marketing.
• Ensure business metadata for campaign execution data is documented, updated, and reviewed on a regular basis.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Good Experience with Teradata and Semantic views.
• Mentored business power users to create reports/dashboards using Tableau desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Developed of key indicators and the appropriate tracking reports with graphical and written summations using summary and Annotations to assist in the quality improvement initiatives.
• Created quick Filters, customized Calculations, Conditional formatting for various analytical reports and dashboards.
• Involve in OTCS M&O Sharepoint sites design requirement.
• Prepare Design and Techinical specifications document related to new requirements on OTCS M&O Sharepoint 2010 and 2013 sites.
• Worked on data blending and linking in case of merging different sources.
• Created a dual-axis chart with multiple measures and Synchronize the scale as per the need.
• Performed Tableau type conversion functions when connected to relational data sources.
• Created incremental refreshes for data sources on Tableau server.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau Server 8.x, 9.x, Tableau Desktop 10.5.7, Teradata 12, SQL Server 2012, PL/SQL, SQL Developer, SQL Server 2012, Control-M,Visual Studio 2012

Confidential, Charlotte, NC

Tableau Report Developer/Sharepoint Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Experience with the design and development of Tableau visualization solutions.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard, supported more than 20 client companies' general business reports and benefit plan administration processes.
• Developed different type of reports including: Sales Report, Client Contact Report, Accounting Statement Report, Employee/benefits census report, Benefits statements report, Enrollment count summary report, Billing report and other insurance/payroll/COBRA file transfer reports by using SSRS and SQL Server 2008/2012.
• Developed Sharepoint-Hosted Apps, provider Hosted Apps for Sharepoint 2013 using Visual Studio.
• Used Windows Azure for to host provider hosted apps of Sharepoint 2013.
• Used client object model for developing any solution related to Sharepoint sites.
• Designed, Develop and deployed Inforpath forms on the list with custom fields and validations.
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.
• Created and maintained SSIS ETL packages to extract data from different systems, and load variety of large volume data into data warehouse from different sources like flat file, Excel file.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using Tableau desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Developed of key indicators and the appropriate tracking reports with graphical and written summations using summary and Annotations to assist in the quality improvement initiatives.
• Created quick Filters, customized Calculations, Conditional formatting for various analytical reports and dashboards.
• Worked on data blending and linking in case of merging different sources.
• Created a dual-axis chart with multiple measures and Synchronize the scale as per the need.
• Performed Tableau type conversion functions when connected to relational data sources.
• Created incremental refreshes for data sources on Tableau server.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau Server 8.x, 9.x, Tableau Desktop 8.x, 9.1, Teradata 12, SQL Server 2008, PL/SQL, SQL Developer, Sharepoint 2013, SQL Server 2008, Control-M

Confidential, Raleigh, NC

Tableau Developer

Responsibilities:

• Worked closely with regulatory department users to create reports/dashboards using Tableau desktop.
• Gone through various levels of dimensionalities to execute the reports with different result sets.
• Created extract files for improving the Performance.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Encounter claims data on an ETL testing
• Designed and developed custom ETL processes to populate the data warehouse and downstream data marts
• Extracted data from internal data warehouse system to SSRS
• Tracked trouble ticket request for request made by end users
• Created ad-hoc reports
• Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization
• Analyzed data models, data relationships, and dependencies for greatest optimization
• Designed and developed stored procedures, queries and views necessary to support SSRS reports
• Performed functional and performance QA testing
• Performed a complete re-design of all the Oracle Triggers and Packages using Toad.
• Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the Physician Financial Transparency Reporting.
• Wrote complex SQL queries to retrieve data from the database and see patterns and relationships in data.
• Designed SQL SSIS Packages to extract data from various data sources such as Excel spreadsheet, and flat files into SQL server for further Data analysis and Reporting by using multiple transformations provided by SSIS such as data Conversion, conditional split, insert, merge and union all.
• Writing audit queries and summary reports to ensure data loading is done correctly.
• Identified data issues and provided recommendations for resolution to ensure optimal performance.

Environment: Tableau 9.0, Tableau Server,Teradata, MS SQL Server 2012/ 2014, MS SQL Server Integration Services (SSIS), Microsoft Visual Studio, MS Excel, Toad for SQL Server.

Confidential

Tableau Developer/Admin

Responsibilities:

• Interviewed and researched various student bodies across the countries and collected use cases.
• Managed use cases as user stories in JIRA Agile to deliver the project in Agile Scrum methodology.
• Responsible for the overall solution design from the data collection to visualization.
• Managed data into several analytical data models and designed Star Schema for dashboards.
• Developed data blending techniques using Tableau Data Blending options for combining multiple data sources.
• Created user friendly Dimensions, calculated objects and measures for prospective students to visualize through self-service approach.
• Created various interactive customized dashboards and stories.
• Applied various types filters like Data source filters, Quick filters and Context filters.
• Created table calculations, calculated fields and parameters.
• Publishing sheets and dashboards to Tableau Public and cloud hosting.
• Developed complex reports and visualizations using Tableau Desktop as per requirements.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Executed and tested required queries and reports before publishing.
• Validate the data for each report and review the reports.
• Generated high detail oriented views using multiple measures, Individual Axes, Dual Axis and Custom Geo-coding.
• Worked with several prospective students and validated the use cases and benefits.
• Enhanced several new features and published.

Environment: Tableau Desktop 8.x, Tableau Server, MS Excel, Oracle, TOAD, Windows