SUMMARY

• 9+ years of total IT industry experience in analysis, design, testing, development and implementation of data analytics using various BI tools.
• 5+ years of experience with hands on Tableau desktop, Tableau Prep and Tableau server.
• Worked on development of Dashboard and visualizations for key performance indicators to empower the Top management and assist decision making.
• Proficient in Tableau data visualization tool to analyze and obtain insights into large visually compelling and actionable interactive reports and dashboards.
• Responsible for building and managing the self - serve platforms and assisting power users with complex scenarios
• Extensive experience working with dimensional data models (ODS and EDW) as well as normalized models
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Developed KPI’s and dashboards based on reports, spreadsheets and charts.
• Extensive knowledge on various reporting objects like Hierarchies, Filters, Calculated fields, Sets, Groups, Parameters, etc., in Tableau.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters
• Experienced in performance tuning and optimizing of the reporting solution.
• Good understanding about various data warehousing concepts including ETL technologies like Informatica
• Worked effectively on Change Management, Problem Management, Configuration Management and Release Management Processes and developed reports to see the performance of those processes under Business perspective.
• Experience in end-to-end project implementation
• Extensive experience in Analyzing requirements; writing Test Plans and Test Cases for positive and negative testing.
• Collaborate with business users and guide them with best practices on data visualization initiatives across the board.
• Extensive experience in Troubleshooting, debugging data issues and work towards resolving them
• Self-starter, motivated and detail-oriented developer who can lead, train and consult with business and database developers

TECHNICAL SKILLS

Tools: Tableau Desktop, Tableau Server, Tableau Prep Builder Informatica

Languages & Scripting: SQL, PL/SQL, Python, Manual testing & QTP

Databases: Oracle 10i, 9i, 8i, Teradata, SQL, PL/SQL, Amazon Redshift, Spark SQL, Wed Data Connector, MS SQL Server 2000/2005/2008/2012 , SSMS, Import Wizard, MS Access and DB2

Reporting/Analytic Tools: Tableau (Desktop 2020.1/2019 +/2018+/10.x Server, Online, Tableau Prep

Productivity Tools: Jira, Remedy, Microsoft Excel, Word, PowerPoint, OneNote, Notepad ++

SDLC Methodologies: SAFe AGILE, Kanban & Waterfall Methods

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Tableau Specialist (Tableau and SQL)

Responsibilities:

• Created Tableau dashboards using the visualizations such as Bar graph, time series line charts, Tree maps, stacked bar charts, bubble charts and donut charts
• Created Technical Design Document (TDD) by discussing with the Business Analyst and the DBA's.
• Added interactivity to Tableau dashboards by making use of Marks cards like Size, color, tooltip and Labels
• Used Measure Names and Measure Values for displaying quantitative information on the dashboards
• Involved in performance tuning of reports that were running slowly. Did performance tuning at the report level, Designer level and database level.
• Discussed with the business users and suggested them of the best visualizations to match with their reporting needs like bar graphs for comparative analysis and line charts for time series analysis
• Performed the Top N analysis of the customers by making use of the Sets and calculated fields in tableau
• Worked with cross-functional teams like data team and business analysts to convert report requirements into actionable dashboards
• Utilized Parameters, Sets, Reference Lines, Cascading Filters and Action Filters to the dashboards depending on the business requirements
• Utilized data blending feature in tableau to fetch data from multiple databases into tableau dashboard.
• Utilized the level of detail expressions in Tableau based on the reporting requirements
• Conducted Tableau training workshops for Business Users as well as Developers on the team
• Applied the fonts and colors by changing the RGB co-ordinates according to the enterprise branding guidelines
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Improved the data retrieval times of the tableau dashboards by making use of the filters and custom sql feature in Tableau
• Displayed KPIs on the dashboards by making use of custom shapes
• Utilized the level of detail expressions in Tableau based on the reporting requirements
• Created Data flow with Tableau Prep for data preparation.
• Cleaned and Consolidated data by using Tableau Prep Builder.
• Performed the data quality testing of the dashboards and worked with the QA team during the defect life cycle
• Published the tableau dashboards to Tableau Dev/UAT/ Production servers during the life cycle
• Utilized the containers in dashboard designer to produce pixel perfect one pager dashboards
• Converted legacy excel reports into Tableau dashboards and published them to Tableau Server
• Worked with Tableau Server administrator during the creation of the projects and access permissions for the users
• Participated the daily scrum calls and stand-up meetings and updated the team with status
• Performed Peer reviews to obtain the necessary approvals from the team members before promoting the code to Production environment
• Distributed tableau dashboards using packaged work books and PDFs to different user community
• Participated the daily scrum calls and stand-up meetings and updated the team with status

Environment: Tableau Desktop 2020.4,2020.2 Tableau Server, Tableau Prep, Amazon Redshift, Analytics V11, Framework Manager, Query Studio, Oracle 11g, Toad, SQL Developer, MS Visio, Jira, Confluence

Confidential, Statesville, NC

BI Developer (Tableau and SQL)

Responsibilities:

• Interacting with Business Architecture and Reporting Manager, gathering the requirements according to client needs.
• Worked on the development ofTableau Dashboard reports for Key Performance Indicators for the top management.
• Created Interactive dashboards with filter actions.
• Identify and establish metadata for various derived attributes, measures and indicators for consistent reporting
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Responsible for data security and obfuscation of data values based on company policies and business rules framework.
• Conduct performance analysis of existing Tableau Servers.
• Monitoring the Tableau server and giving feedback to the client on managing the environment effectively.
• 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
• Responsible for report mockups and fine tuning of reports to help business users better elaborate the requirements
• Build row and column-based security guidelines so that only appropriate teams can view it.
• Interacted with Strategic Development Team & Business analysts to analyze business needs and developed technical specifications.
• Created dashboard designing with effective data visualization of large data volumes from various data sources (SQL server, oracle, spreadsheets etc.).
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Worked with business owners to understand the requirements and documented the stories in Agile
• Used Oracle, SQL server as data sources for designing Tableau Reports and Dashboards.
• Created Tableau scorecards, dashboards using bar graphs, scattered plots, stack bars geographical maps, Gantt charts using show me functionality.
• Created Data flow with Tableau Prep for data preparation.
• Cleaned and Consolidated data by using Tableau Prep Builder.
• Created detailed level summary report using Trend lines, Statistics, log axes, groups, and hierarchies.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Created Indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in regression testing and performance testing of environment.
• Created User Groups and Roles and assign necessary security to Users.

Environment: Tableau Desktop 2020.4 2020.2 , 2019 Tableau Server, Tableau Prep, Spark SQL, Analytics V11, Framework Manager, Query Studio, Oracle 11g, Toad, SQL Developer, MS Visio, Jira, Confluence

Confidential, Fargo, ND

BI Consultant (Tableau)

Responsibilities:

• Business Intelligence solution design, development and process documentation to produce required reporting and analytics deliverables using Tableau
• Created simple report schemas for users to create their own Adhoc reports using Tableau.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Ability to perform data analysis, troubleshoot data integrity issues and trend data analysis
• Created reports with Entitlements in which same report will show different data for different persons.
• Derived various complex calculations and custom SQL reports as per the requirements.
• Extensively used Joins and set operators (Unions, Except, Intersect) in report studio and in Framework.
• Created reports using cascaded prompts, value prompts sections, dynamic filtering, conditional layouts and multilingual reports in Report Studio.
• Developed various Revenue reports - MTD, QTD, YTD, last fiscal year, current fiscal year reports, Occasions, including scorecards and dashboard reports which were mainly developed for the departmental heads and regional heads.
• Ran ETL jobs on demand to process flat files and ad-hoc loads.
• Used Data Quality tool like Informatica Master Data management for data cleansing.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router, Aggregator and lookup Transformations to create mappings.
• Extensively used Informatica client tools to extract data from different sources like flat files and Oracle.
• Developed several complex mappings and reusable transformations to facilitate one time, Daily, Monthly and yearly loading of data.
• Used Informatica Workflow Manager for creating, running the Batches, Sessions and scheduling them to run at specified time.
• Extensive experience in handling reports with multiple measures using dual axes and combined axes.

Environment: Tableau desktop 2018,2019,,9.x/10.4, Windows 2007 Server, MS SQL Server, Teradata, Teradata SQL Assistant, SQL Server Management Studio, HP ALM JIRA, MS Access, MS Excel, MS Power Point.

Confidential

QA Analyst

Responsibilities:

• Responsible for Preparing Test Cases based on the Functional Requirements.
• Reviewed the User Requirement Document and prepared a detailed Test Strategy for the Testing effort.
• Prepared Test Scenarios and Test Cases during the Test Design Phase and got the approval from BA/Client.
• Assist and plan System testing, UAT and regression testing
• Involved in Test Execution, Result Analysis and Defect Reporting in Quality Center (ALM).
• Conducted Regression and Re Testing once defects are fixed.
• Participated in various meetings and discussed Enhancement and Modification Request issues.
• Prepared Test status and Test summary reports.
• Held daily and weekly meeting with the project manager and QA manager.
• Proven ability in proactively identifying and resolving issues.
• Effectively involved in the review of the Test results.

Confidential 

QA Analyst

Responsibilities:

• Performed Regression Testing to ensure the integrated modules co-functioning well in the incremental versions of product and performed End-to-End Testing to ensure the complete integrated product functionalities.
• Participating everyday Stand up/touch base meeting with manager for updating day-to-day work status.
• Documented defects found during the test execution and kept track of the defects by using Quality Center, and performed Regression Testing for the defect fixes in each version update.
• Performed Black Box testing from end user’s perspective.
• Designed and implemented basic SQL queries for QA testing and report/ data validation.
• UsedSQLfor Querying theOracledatabase inUNIXenvironment
• Performed End-to-end defect management of assigned projects. Provided client and developers with detailed reports on testing progress on day to day basis.
• Perform Functional testing and Regression testing.
• Reported and tracked defects found during test execution using Quality Center, afterwards performed.
• Regression Testing for the defects fixed in each update.
• Generating reports every week on Test-Runs, Execution-Flows, and pass/fail test cases and present them to management weekly-review meetings.
• Interacting well with Developers and Managers to co-ordinate job tasks, deliverables to meet committed project deadlines.