Manager Tableau
Resume:
Swetha Konanki
Tableau /BI Developer
Professional Summary:
* ***** ** ***** ** 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 and Tableau server
Worked on development of Dashboard and visualizations for key performance indicators to empower the Top management and assist decision making.
Hands on experience on Tableau Desktop, Tableau Server and Tableau Prep.
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.
Extensive experience working with Tableau Software as a dashboard developer.
Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters
Implemented dynamic measures, dynamic column selection in Report Studio.
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.
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 Competencies:
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, MS SQL Server 2000/2005/2008/2012, SSMS, Import Wizard, MS Access and DB2.
Reporting/Analytic Tools: Tableau (Desktop2020.1/2019 +/2018+/10.x/ 9.x/8.x Server,Online,Tableau Prep
Productivity Tools: Jira, Remedy, Microsoft Excel, Word, PowerPoint, OneNote, Notepad ++
SDLC Methodologies: SAFe AGILE, Kanban & Waterfall Methods
Educational background:
Master of Business Administration from Sri Venkateshwara University, India
Bachelor of Science from Sri Venkateshwara University, India
Professional Certifications:
Tableau Desktop Certified Specialist
Professional Experience:
Client: Doosan Companies, Statesville, NC
Duration: Oct 18 – Oct 20
Role: BI Developer (Tableau and SQL)
Doosan is a manufacturing client and are mainly into construction equipment. They have different brands like Doosan, Bobcat, Geith, Portable Power etc.
Responsibilities:
Interacting with Business Architecture and Reporting Manager, gathering the requirements according to client needs.
Worked on the development of Tableau 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.
Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
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.
Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc.
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.
Utilized Python programming language to automate the Excel tasks such as VLOOKUPs, Null Value Handling and Pivot Tables
Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
Created scripts to create new tables, views, Materialized views, queries for new enhancements in the application using Toad.
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.1,2019.2,2018.2,10.2, Tableau server,Tableau Prep, Analytics V11, Framework Manager, Query Studio, Oracle 11g, Toad, SQL Developer, MS Visio, Jira, Confluence
Client: Blue Cross Blue Shield of North Dakota, Fargo, ND
Duration: Oct 15 – Sep 18
Role: BI Consultant (Tableau)
Noridian Mutual Insurance Company is an insurer headquartered in Fargo, North Dakota. It offers health, dental, and life insurance, under several brands, including Blue Cross Blue Shield of North Dakota, which is the largest health insurance provider in the state of North Dakota
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 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.
Client : KAO Brands
Company : IBM, Bangalore
Duration : Jun 11 – Mar 13
Role : QA Analyst
Description:
KAO Brands is a global leader in Consumer Products. They own Cosmetic, Skin Care, Hair Care, Saloon, Human health care, Fabric, Home Care and Chemical products.
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.
Client : DSI (DAIICHI SANKYO INC)
Company : PARITAS, Hyderabad
Duration : Jun 09 – May 11
Role : QA Analyst
Description:
DAIICHI SANKYO is a global leader in pharmaceutical innovation, dedicated to improving health and adding to the balance of life for patients worldwide. It established in 2006 by the merger of two 100-year-old Japanese pharmaceutical companies, Daiichi Sankyo, Inc. (DSI).
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.
Used SQL for Querying the Oracle database in UNIX environment
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.
Contact this candidate