SUMMARY

• Total 8 years of diversified experience with 6 years of experience in System analysis, design, development, Data Warehouse, implementation and maintenance of client server applications, providing Business Intelligence and OLAP solutions to Financial, Healthcare, Banking and Insurance Sectors.
• Experience in Tableau versions 8.x, 9.1.12,10.x, 2018.x, 2019.x,2020.1
• Deep experience in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Worked a great extent with Tableau Extracts, Calculation, Parameters, Background images, Maps, Trend lines, Statistics, Filters, Contexts, Data Source Filters, Advance analysis Actions, Functions, Hierarchies, Sets, Groups, Data Blending to create detail level summary report and Dashboard using Tableau's Advanced Capabilities.
• Expert in evaluating data models to design Tableau solutions and responsible for developing interactive data visualizations.
• Expertly handled data modeling relational, dimensional and star schema and data retrievals using Universes, Personal data files, stored procedures and Freehand SQL methods.
• Experienced in Agile Scrum Methodology to implement project life cycles of reports design and development.
• Involved in many aspects of the SDLC including requirements gathering, proof of concept delivery
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Broad experience on building dashboards using Tableau and Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Created Complex, Standard reports, master/detail reports and cross tab reports using functionalities such as Section, Breaks, Alerts, Drill features, Filters, Ranking, Query filter, Report filter, Sub queries, Combined queries, Tables Vertical/Horizontal, Crosstabs, Charts, Section, Break, Drill, Slice Dice, Grouping, Alerts, Ranking, Advanced queries, List of Values and Customized Hierarchies etc.
• Designed, Developed and Maintained Universes using features such as Objects, Classes, Cardinalities, Aliases for resolving Loops, functions like prompt, select, where, variable, checked the Integrity of the Universes, Contexts, Joins, Filters, Conditions, List Of Values LOV, Linked Universes, Security, Derived tables etc.
• Created various complex dashboards including the dashboard navigations using Actions, Quick filters, Parameters, Sets, Groups, Hierarchies, Bins, calculated fields, table calculations. Worked on complex out of the box charts including Funnel chart, Pareto chart, Donut chart, Waterfall chart, Venn diagrams etc.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Proficient in all phases of the systems development life cycle, including requirements Definition, Data Conversion, System Implementation, System Testing and Acceptance.
• Proficient in Building compelling, interactive dashboards in Tableau that answer key business questions
• Installed and upgraded Tableau server and server performance tuning for optimization.
• Experience in writing complex SQL queries to perform End - to-End ETL validations and support Ad-hoc business requests.
• Experience in documenting the testing process using MS-Office tools including MS-Word, MS-Excel, and MS-Project.
• Excellent rapport with developers, testers in all the projects and worked in close collaboration with team members to ensure enhancement of software quality.
• Excellent team player with very good communication skills, problem solving abilities, Leadership Quality and determination to learn new technologies and maintain positive relationships at all business levels.

TECHNICAL SKILLS

BI Tools: Tableau Desktop, Tableau Server, SSRS, SSAS

ETL Tools: Informatica Power Center, SSIS, Power BI

Databases: Oracle, MS SQL, MS Access, DB2, Amazon Redshift

Data Modeling: ER/Studio, Erwin, MS Visio

Languages: T-SQL, PL/SQL, HTML, XML

OS: Windows and Unix

Front End tools: MS Project, MS Office, Visible Analyst, SharePoint

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr Tableau Developer

Responsibilities:

• Involved in Data asset Inventory to gather, analyze, and document business requirements, functional requirements and data specifications for Member Retention from sources MS SQL.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements.
• Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting.
• Created different KPI using calculated key figures and parameters.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.
• Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
• 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.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Wrote SQL scripts for pre & post session processes and to automate daily loads.
• Scheduled extract refresh for weekly and monthly reports.
• Worked on administrative task such as setting permissions, managing ownership and providing access to the users.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Environment: Tableau Desktop 2018.x, 2019.x,2020.1, Tableau server / Administrator, Informatica Power Center, SQL Server, MS Office, Windows Server.

Confidential, Cincinnati, OH

BI Developer

Responsibilities:

• Interacted with Business users, Business Analysts to understand reporting requirements and transform them into technical specifications.
• Design and develop Tableau visualization solutions.
• Design interactive dashboards in Tableau Desktop and published them to Tableau Server.
• Effectively used data blending feature in tableau to get data from various data source.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Prepared test cases for Unit testing created various test cases to validate the data, performance and look feel of the reports.
• Install upgrade Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Prepare Dashboards using calculations, parameters in Tableau.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing Dashboard and preparing ad-Hoc Reporting.

Environment: Tableau Desktop 10.x,2018.1 Tableau server / Administrator, SQL, Amazon Redshift, Visible Analyst, MS Excel, Windows Server.

Confidential, Columbus, OH

Tableau Developer/Tableau Admin

Responsibilities:

• Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop publish them to server.
• Fine \tuned SQL Queries for maximum efficiency and performance.
• Designed and implemented data warehouse architecture for corporate circulation data warehouse. Subsequent data marts, extracts and reports were sourced from the architecture of conformed facts and dimensions
• Migrated data from different sources text-based files, Excel spreadsheets, and Access to SQL Server databases using SSIS.
• Created Drill-down and Sub-Report using SSRS. Monitored the performance of the reports.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Built dashboards for measures with forecast, trend line and reference lines.
• Published Workbooks by creating user filters so that only appropriate teams can view it.

Environment: Tableau Desktop 9.1.12, Tableau server / Administrator, MS SQL, Flat Files, Microsoft Excel, MS Access, Windows server.