SUMMARY

• 8+ years of strong IT industry experience in Analysis, Design, Development and Implementation of Applications.
• Experience in Data Visualization in and Insight generation projects using Tableau and Integration of Tableau Dashboards.
• Gathered requirements and data from multiple sources like SAP, SharePoint lists and created the design document.
• Table joins and data blending techniques used to collate the data.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie - charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. and other making use of actions, other local and global filters according to the end user requirement.
• Extensive knowledge in various reporting objects like Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Parameters etc.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Developed Tableau Desktop based interactive dashboards & Stories using - Drill down menus, Context Filters, Calculated functions, Parameterized and Linked reports.
• Utilized Alteryx, Informatica and all the Tableau tools including Tableau Desktop/Server, Tableau Online, Tableau Public, and Tableau Reader extensively from 7.x to the latest 2021.2 versions.
• Created Dashboards and configured Tableau Tool in all the three Environments (DEV, QA and PROD).
• Extensive experience of working in SharePoint OOB, Office365, SharePoint Online, Power BI, Google Analytics and Ability to communicate effectively with business and development teams as well as non-technical users.
• Provide innovative solutions, and deliver improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.
• Looked for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development
• Experienced with working on Agile/Iterative development teams.
• Outstanding analytical and problem-solving skills, capable of learning modern technologies quickly.

TECHNICAL SKILLS

Visualization Tools: Tableau Desktop 2021.2/ 2020.1/2019.1/2018.1/10.5 , Power BI

ETL Tools: Alteryx, Informatica Power center Express

Language: SQL, C#, Asp.Net, HTML, CSS, Python, Java Script.

Data base: SharePoint List, SAP, MS Excel, MySQL, MS Access, Google Sheets, Oracle 8i/9i/10g, Salesforce.

Other Tools: Visual Studio2013, .Net Crystal report SP Designer, Microsoft Office 365, Microsoft Visio, SAP, SharePoint online.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Tableau Analyst

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from SharePoint, MS Excel, MS Access, and SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Analyze data and generate reports in Tableau Desktop based on requirements.
• Analyzed existing requirements with Stakeholders/End Users and clearly documented them for Tableau.
• Developed parameter and dimension-based reports, drill-down reports, and charts.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Automated Weekly/Monthly manually created reports in excel to daily refreshed Dashboards in Tableau.
• Executed and tested required queries and reports before publishing dashboards.
• Created interactive dashboards using Actions, Quick filters, Hierarchy (drill down) and Parameters.
• Connected multiple data sources like SharePoint lists, salesforce, Excel using data blending, unions and joins in tableau.
• Published secured workbooks by creating user filters so that only appropriate teams can view reports.
• Provided support once dashboards to publish if there were any data changes, system changes, or requirement changes.
• Consulted regularly with internal customers on application, development, project status, new project proposals and software-related technical issues.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers.
• Collaborated on all stages of systems development life cycle, from requirement gathering to production releases
• Provided innovative solutions, and deliver improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.

Confidential

Sr. Tableau Analyst

Responsibilities:

• Gathered requirements from the executive Organizational and non-organizational members for the Daily, Weekly and Monthly Score cards which were previously done using SQL and Excel and converted them into Automated Scheduled reports using Tableau.
• Involved in installation and Configuration of Tableau Server, creation of Tableau Sites, adding Users in Tableau Server in and Enterprise environment.
• Created complex Dashboards using Parameters, Filters, Sets and Groups.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions
• Created numerous tableau Worksheets and Dashboards based upon the direct Adhoc requirements from the Higher-level Executives.
• Analyzed data from various sources and formatted it into graphs.
• Developed geographic maps showcasing demographics broken into profit and income category that showed content viewed by individual customers across all content providers
• Implemented row-level security for all the Tableau Dashboards and used Advanced Table calculations.
• 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.
• Involved in using complex multiple data sources such as SQL, Flat Files, MS Excel and MS Access, Oracle, SQL Server for designing and modeling of Tableau application.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Published Workbooks by creating user filters and applied privacy fields so that only appropriate teams can view it.
• Involved in Production Support of various business applications in trouble shooting and issue resolution.

Confidential

Sr. Tableau Analyst

Responsibilities:

• Involved collaboratively with business stakeholders and users to define processes for business analytics.
• Evaluated business requirements to design and build standard dashboards using multiple sources of data.
• Created and maintained documentation around data handling activities and reporting processes.
• Dashboards are prepared using best practices to improve dashboard, performance and utilized extract data sources whenever required.
• Joined data from multiple data sources like SQL server/ Excel using Tableau blending Techniques.
• Reviewed and validated data to determine the accuracy of reporting logic.
• Created functional and technical documentation related to business intelligence solutions.
• Interpreted quantitative and qualitative data, identifying and analyzing results and trends.
• Created Dashboards showing retail KPI’s for WTD, MTD, QTD, Quarterly and YTD
• Developed, monitored, and delivered refined reporting.
• Actively observed in data quality and data accessibility
• Designed and delivered ongoing analysis to provide users and key business stakeholders with insights to make decisions.
• Liaison with various technical and non-technical clients
• Monitored and reviewed periodic reports.
• Worked to continually enhance internal controls, maintain updated documentation of current departmental policies and procedures, and lead change initiatives and process improvements.

Confidential

Tableau Developer

Responsibilities:

• Involved during the design phases to gather the functional and technical requirements to document them.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Worked to create the consolidated data set from different data sources using data blending and joining features of Tableau.
• Used my deep experience with the design and development of Tableau visualization solutions using Aggregate Functions, Filters, Trend lines, and Parameters.
• Coordinating between client and development team, bridge the gap in transferring knowledge of functional business requirements to technical for Tableau Reporting - data profiling requirements and including handling daily status calls with client.
• Graphs, Dashboards and Stories used to convey the analysis of overall Performance.
• Assisted the deployment team with deployment of the Dashboard on Tableau Online.
• Building, publishing customized interactive reports and dashboards with Tableau.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Worked on creating Cross Tab, Heat Map, Scatter Plots, Pie Chart and Bar Charts, Dual Axis.
• Assisting with the creation, monitoring & reporting of progress against plans and identify corrective actions.
• Monitoring operational jobs on daily basis, managing incident when errors or exceptions occurs, Oversaw unit and system tests UAT (User acceptance test) and assisted users with acceptance testing.

Confidential

Software Engineer

Responsibilities:

• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Works with external organizations to gather requirements and resolve issues. coordinating for user acceptance testing, and go-live of the web forms
• Gathers data requirements, and develops business glossaries and data dictionaries.
• Responsible for research, design, document, and modify software specifications throughout the production life cycle.
• Post go-live responsibilities involved Training end users on Underwriting, Claims, Accounts, Reinsurance, Reports, Queries, Intranet Portal and Mobile application.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Wrote SQL queries to extract data from various data sources into the Visualization tool, and Excel reports.
• Coordinated many out of the box solutions like Hide and Show dashboard selector and used Window functions in Tableau
• Migrated all the important Dashboards like Sales/Margin Dashboard, KPI Dashboard etc. from excel to SharePoint.
• Synchronized primarily on creating Web forms in SharePoint in Claims module.
• Coordinated with functional teams on requirement gathering and coordinated with back-end teams for maintenance and performance tuning.