SUMMARY

• 6+ years of IT experience Specialized in Data visualization, Dashboard Development, Implementation, testing of software applications to support reporting and Business Intelligence Initiatives.
• Extensively worked on various Tableau desktop 10.x/19.x/20.x versions, Tableau Server, Tableau online, Tableau reader.
• Experience in creating rich interactive visualization reports and dashboards in Tableau Desktop and server utilizing LOD, Filters, Actions, Parameters, sets, Groups, Extracts, Data Blending, Page Trails.
• Extensively involved in the development of various interactive dashboards and reports such as Dual Axis, Pie - charts, Heat Maps, Waterfall Charts, Bar Graphs, Bubble charts, Box plots, Tree Maps.
• Extensive experience in publishing Tableau dashboards to Tableau Server.
• Extensively involved in creating users, user groups, roles, scheduled instances for reports in tableau server.
• Extracting data from data sources like SQL server, Oracle and Excel files for getting data to Tableau for creating various dashboards.
• Worked with various teams in gathering user needs and documenting them in business requirement documentation.
• Extensively involved in Unit, System, User Acceptance Testing also involved in performing data validation for the dashboards that are generated from various data source.
• Worked on MS Visio for database design and development of Entity Relationship Diagrams.
• Effectively utilized various Tableau features such as Dashboards, Stories, Quick POCs and worked with senior managements in analyzing the data trends, well utilized future forecasting option.
• Solid understanding on Microsoft SQL Server Integration Service (SSIS), SQL Server Reporting Service, MS Access, MS Excel, MySQL.
• Proficient in developing Stored Procedures, Triggers, User Functions, SQL joins, Sub queries.
• Excellent knowledge in developing Drill down and Drill through reports in SQL Server Reporting Services.
• Extensively worked on various filters such as Data Source filter, extract filter, Context filter, Measure filter and global filter.
• Extensive Knowledge in Media, health care provider management.
• Extensively involved in performance tuning of reports and involved in resolving issues related to tableau server.
• Experience in report development, testing and publishing on to TableauServer.
• Experience in Creating Users, Groups and Projects on TableauServer, Involved in Tableau server upgradation activities.
• Experience in data modelling techniques like Snowflake Schema, Star schema, Fact, and dimension tables.
• Strong knowledge of Software Development Life Cycle(SDLC) methodologies like waterfall, Agile.
• Strong Individual contributor, good team player, problem solving skills, ability to work under pressure, fast learner.

TECHNICAL SKILLS

BI Tools: Tableau Desktop, Tableau server

MS office tools: MS Word, MS Excel, Power Point

Web Technologies: HTML CSS, XML, XSLT, JSON

Databases & Tools: Oracle SQL and PL/SQL, Toad, SQL Developer

Operating System: Windows, Unix

File system: CSV, Text file, MS Access, MS Excel, PDF

PROFESSIONAL EXPERIENCE

Confidential, MD

Tableau Developer

Responsibilities:

• Worked with the Business Analyst, Provider management teams, Outreach teams for gathering reporting requirements.
• Involved in installation of Tableau desktop 9.3, Tableau server 9.3.
• Worked on latest versions of Tableau 10.x.
• Created visualization prototypes based on the reporting needs in the initial stages and demonstrated them to business to collect feedback.
• Created Tableau data visualization using Bar graphs, Pie charts, line graphs, Tree maps and heat maps, and tabular graphs.
• Developed Executive Level Tableau dashboards to identify the overall costs, expenses and KPI's of the industry by using BI tool Tableau 2018.1.
• Involved in migrating all the dashboards from version Tableau 10.5 to Tableau 2018.1.
• Interacted with Strategic Development Team, Business analyst and Nurse Managers to analyze business needs and developed technical specifications.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Created and published dashboards through Jenkins to the Tableau Server and Cloud application.
• Involved in writing. yaml and .py script to deploy Tableau Dashboards.
• Created an export data feature to allow users to download the dashboard data and create their own reports.
• 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.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau through connecting to PostgreSQL on AWS platform.
• Developed Tableau workbooks to perform Last Month, Current Year, trailing 6 months and trailing 12 months to show the variance analysis.
• Involved in creating API filters for the Tableau Dashboards in the Cloud environment.
• Involved in scripting (JavaScript) to integrate with Tableau.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Interacted with the existing database developers and DBA to understand the existing schema.
• Created dashboards for measures with forecast, trend line and reference lines. created different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Created Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau for the analysts.
• Worked with Git repository to pull or push the working files to the Bit Bucket.
• Good understanding and Worked under Agile Environment and tools such as JIRA, Bit Bucket, Confluence.
• Worked on Tableau’s other ODBC connection by creating user, system DSN for resolving MarkLogic date filed issues.
• Generated PDFs for various dashboards for contracted partners conference.
• Created production deployment and implementation plans, generated data extracts in Excel files for MDM teams to load in good views.
• Prepared files for test, for updating current views in MarkLogic.

Environment: Tableau 10.5/10.3, Hyper extracts, Tableau server, Jira, MarkLogic, MS Excel, Oracle, SQL.

Confidential, NJ

Tableau Developer

Responsibilities:

• Interact with business subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business needs.
• Building, publishing interactive reports and dashboards, scheduling reports using server.
• Created calculated fields, parameters and action filters for building dashboards and worksheets in tableau.
• Building Tableau dashboards using stack bars, lines, dual combination, heat maps, tree maps, symbol maps, filled maps, horizontal bars according to deliverable specifications.
• Effectively used data blending feature in tableau.
• Designed and developed graphic rich visualizations with Drill Down and Drop-Down menu option.
• Develop adhoc reports for users.
• Defined best practices for Tableau report development.
• Involved in automation of jobs in Tableau.
• Working on data sources such as Oracle and Hive.
• Hands-on experience assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled Full/Incremental refreshes of dashboards depending on the business requirements for data sources on Tableau Server.
• Involved in creating Tableau reports using complex custom SQL queries.
• Involved in designing new projects and execute them with minimal human resources.
• Experience Depth in POWER BI With Tableau Background.
• Administered Tableau server and helped in tuning of server.
• Involved in gathering information from clients and Monitoring the Team.
• Worked with MySQL and optimization of SQL Queries.
• Created semantic/metadata layer in Tableau.
• Created executive dashboard with KPI visualization (1-2 dashboards, 4-8 KPIs)
• Created underlying drill through detailed reports
• Created Wide variety of dashboards.
• Involved in creation of aggregated tables using OLAP data source (DW)
• Worked with customers, internal and external, to define and document the scope and functional requirements for data and reporting needs.
• Involved in backup of tableau server and optimization of server performance
• Closely worked with manager for designing the requirements.
• Integrated Jasypt encrypted data into tableau and integrated special passwords for viewer to look the sensitive data.
• Worked in integrating the tableau into mobile applications.
• Configuring the analysis for scheduling auto emails from Tableau automation.

Environment: Tableau 10.5/10.3, Hyper extracts, Tableau server, Jira, Marklogic, MS Excel, Oracle, SQL.

Confidential

SQL Developer

Responsibilities:

• Interacted with Team and involved in Analysis, Design and Developing databases using ER Diagram, Normalization, and relational database concepts.
• Involved in Design, Development, and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan).
• Applied Normalization rules in designing the database.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Developed database objects like Tables, views, stored procedures, indexes etc.
• Tuned SQL statements using views and Stored Procedures.
• Rebuilding the indexes at regular intervals for better performance.
• Wrote various stored procedures for application development.
• Wrote SQL Scripts to select the data from the source. Designed and implemented data access stored procedures and triggers for automating tasks.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery.