Resume

Tableau Data

Location:

Media, PA

Posted:

March 30, 2020

Contact this candidate

Resume:

VENKATA KAJA

***-***- **** adci54@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 7+ years of experience in Requirement Gathering, Analysis, Documentation, Design, Development, Testing, and Implementation in Business Intelligence and Software Applications.

6+ Years of extensive Tableau Experience in Enterprise Environment, in Tableau as a Developer, Administrator and Analyst.

Proficient in Installing, Configuring and Administration of Tableau Server and good understanding of Tableau architecture, design, development and end user experience

Good Knowledge in Users and Group Management, Licensing and Data Connections, Web data connectors, Scheduling in Tableau Server.

Create/Modify/Manage server task Scheduled data refresh on Tableau Server for increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Good in creating complex formulas, Level of Detail Expressions and complex calculations within Tableau to meet the needs of complex business logic.

Extensive knowledge of Tableau Server Concepts like tabcmd, tab admin, creating/ adding users, sites and projects, managing licenses and data connections, scheduling tasks.

Extensive knowledge in creating various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters, aggregates, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.

Hands on experience in content migration between environments with high level enterprise tools like TabRESTMigrate, EDT.

Good Knowledge in Automating and implementing Server level activities like Triggering and Scheduling extracts with coordination with ETL and DB jobs.

Diversified experience in implementation of BI systems with in Healthcare, Finance, Pharmaceutical, Insurance, Accounting and Telecom sectors, etc.

Expertise in gathering, analyzing and documenting Business Requirements and Data Specifications.

Experience with Alteryx to collect the required data from large complex databases.

Hands on experience on Hortonworks and Cloudera Hadoop environments.

Expertise in testing Data Warehousing jobs (Informatica, SSIS, Data Stage) and applications, Business Intelligence reports (OBIEE, SSRS, Business Objects, BEx, Tableau, Cognos), Java based applications, Quality Assurance and management, Risk, Compliance, Data management, Internal audit and Enterprise risk management projects and programs.

Experience in developing reports from various sources like Oracle, PL/SQL, MS SQL Server, Access, and DB2.

Experience in working with Operating Systems like Windows and UNIX.

Train the users on the BI practice within the organization.

Highly skilled, self-motivated team player, outstanding organizational, excellent communication and interpersonal skills with result-oriented dedication towards goals.

TECHNICAL SKILLS:

Business Intelligence: SAP Business Objects XI R4.x/3.x/XI R3/XI R2/6.x/5.x, SAP HANA, WebI XI R2/6.x/2.x, Infoview, CMC, Designer, DeskI, Crystal, Xcelsius, Tableau, Qlikview Dashboards, Scorecards, Hadoop Ecosystem.

RDBMS: Oracle 10g/11g/12c, SQL Server, MS Access, Visual Studio, ERP, Teradata, Hadoop, Impala, Jira Data.

ETL Tools: Informatica Power center/ Power mart, SSIS, Alteryx.

Software/Tools: Designer/Developer 2000, TOAD

Languages: C, C++, Java, SQL, PL/SQL, SQL Plus, R-Programming, ANSI SQL, VB, Unix Shell Scripting, Kernel Programming.

Internet Technologies : JSP, XML, HTML.

Operating Systems: Windows, UNIX.

Education Qualification

Bachelor of Technology in Electronics and Instrumentation Engineering.

Amrita Vishwa Vidyapeetham, Bangalore India.

Master of Science in Industrial Engineering

University of Texas at Arlington, Arlington-Tx-USA

Certifications:

Certified Tableau Desktop Specialist

PROFESSIONAL EXPERIENCE

Comcast Cable Corporation, Philadelphia-PA July 2019 – Current

BI-Tableau Reports Developer/Analyst

Responsibilities:

Involved in requirement gathering and analyzing business requirements from mobile team.

Designing and developing visualization solutions for clients according to specifications.

Working in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.

Translating business requirements into report visualization, design documents. Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.

Follow approved life cycle methodology.

Automated Tableau Extracts with TabCMD for more reliability and avoid queue on Tableau Server.

Trained users on site administration by providing step-by-step guidance from basics to advanced functions.

Developed Visualizations using Cross tables, Bar Charts, Pie Charts, Donuts Charts, Maps, Line Charts, Scatter Plots and Filters, Marking, Drill Down, Hierarchies and Coloring, Calculated Columns and Custom Expressions using Tableau.

Performance Tuning and Optimization.

Understand data modeling based on specifications.

Coordination with business and technical teams on Analytics, problem-solving, time management.

Work with Agile/Scrum development methodology.

Defect analysis and assisting QA team in testing the reports and fixed the defects.

Assisted users in UAT

Environment: Tableau Desktop2019.2, 2018.3, Tableau Server 2019.2,2018.3, Tableau Prep, SQL Server, Cloudera-Impala, Vertica, MS Office tools.

Harvard Pilgrim Healthcare (NTTDATA), Quincy-MA

BI-Tableau Development Advisor Mar 2019 – Present

Responsibilities:

Involved in requirement gathering and analyzing business requirements from clients

Providing best practice solutions on designing and developing of front-end BI applications and Visualization solutions for clients according to specifications.

Assisted Admins in Administrating user, user groups, and scheduled instances for reports in Tableau.

Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Performing Migration of workbooks between different environments using TabRESTMigrate.

Designing the Reports as per client Requirement and created the reports using assigned data sources .

Visualized the objects created in Teradata using Tableau to demonstrate data and visual analysis.

Working in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.

Translating business requirements into report visualization, design documents.

Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.

Build prototypes for demonstration and illustration purposes for peer groups, business partners, senior leaders followed by design, deployment and on-going enhancements.

Creating and Scheduling AutoSys jobs to trigger Tableau extracts in sync with DB jobs

Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections

Coordination with business and technical teams.

Defect analysis and assisting QA team in testing the reports and fixed the defects.

Assisted users in UAT

Environment: Tableau Desktop 2018.1, 2019.1, Tableau Server 2018.1, Tableau Prep, Teradata, MS Office tools.

Comcast Cable Corporation, Philadelphia-PA Oct 2018 – Feb 2019

BI-Tableau Reports Developer/Analyst

Responsibilities:

Involved in requirement gathering and analyzing business requirements from mobile team.

Designing and developing visualization solutions for clients according to specifications.

Working in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.

Follow approved life cycle methodology.

Trained users on site administration by providing step-by-step guidance from basics to advanced functions.

Performance Tuning and Optimization.

Understand data modeling based on specifications.

Coordination with business and technical teams on Analytics, problem-solving, time management.

Work with Agile/Scrum development methodology.

Defect analysis and assisting QA team in testing the reports and fixed the defects.

Assisted users in UAT

Environment: Tableau Desktop 10.3, 2018.3, Tableau Server 10.3, Tableau Prep, SQL Server, Cloudera-Impala, MS Office tools.

The Scotts Miracle-Gro Company, Marysville – OH

BI-Tableau Developer /Analyst Aug 2018 – Sept 2018

Responsibilities:

Involved in requirement gathering and analyzing business requirements from clients

Providing solutions on designing and developing of front-end BI applications and Visualization solutions for clients according to specifications.

Designing the Reports as per client Requirement and created the reports using Excel file and BOBJ.

Visualized the objects created in SAP HANA using Tableau to demonstrate data and visual analysis.

Working in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.

Trained users on site administration by providing step-by-step guidance from basics to advanced functions.

Coordination with business and technical teams.

Defect analysis and assisting QA team in testing the reports and fixed the defects.

Assisted users in UAT

Environment: Tableau Desktop 10.5, Tableau Reader, Tableau Public, Tableau Server 10, SAP HANA, SQL Server, MS Access, MS Office tools.

Agency for Health Care Administration (State of Florida), Tallahassee - FL

Tableau Reports Developer April 2018 – Aug 2018

Responsibilities:

Design, develop, Test, and maintain Tableau reports and dashboards for Emergency Service System (ESS) at AHCA.

Develop various dashboard across application process to analyze the existing opportunity and forecasting model across agency level operations for FL Health Finder (FHF).

Developed Executive Dashboard in FHF would focus on facility compliance with reporting, as well as facility status as it relates to disaster preparedness and information about their status during an event

Worked with users and coordinated with actuate developers to understand and capture data/reporting requirements.

Communicated Project Requirements, Business Issues, Solution and made recommendation.

Utilize Tableau Server to publish and share the reports with users.

Involve in administration tasks such as providing access to the users and adding them to the specific group.

Combined data sources using data blending.

Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Created extensive custom joins for blending data from several different data sources.

Extensively involved in doing user acceptance testing (UAT).

Distribute Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Use different level of Tableau calculations, Level of Detail expressions for calculations and applying complex, compound calculations to different data sets.

Analyze different data sources like MSSQL Server, text files, Excel, XML files from which the Application data is coming and understand the relationships by analyzing.

Involve in trouble shooting of performance issues which were associated with Tableau reports.

Implement performance tuning at all levels like source level, target level, mapping level and session level.

Provided support once the dashboards were published if there were any data changes, system changes or requirement changes.

Environment: Tableau Desktop 10.5.3 Hyper, Tableau Reader, Tableau Public, Tableau Server10.5 Hyper, SQL Server, MS Office tools.

Pfizer INC (IBM) Collegeville, PA

Tableau Developer / Administrator Oct 2017 – Dec 2017

Responsibilities:

Involved in requirement gathering and analyzing business requirements from clients

Providing solutions on designing and developing of front-end BI applications and Visualization solutions for clients according to specifications.

Administered user, user groups, and scheduled instances for reports in Tableau.

Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Designing the Reports as per client Requirement and created the reports using Excel file and BOBJ.

Visualized the objects created in SAP HANA using Tableau to demonstrate data and visual analysis.

Working in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.

Translating business requirements into report visualization, design documents.

Responsible for universe designing and hierarchy building for data analysis.

Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.

Build prototypes for demonstration and illustration purposes for peer groups, business partners, senior leaders followed by design, deployment and on-going enhancements.

Involved in adding users and providing permissions to sites, projects and data source, Load Balancing.

Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections

Add/Edit Sites and corresponding administration right to the site admin.

Trained users on site administration by providing step-by-step guidance from basics to advanced functions.

Coordination with business and technical teams.

Defect analysis and assisting QA team in testing the reports and fixed the defects.

Assisted users in UAT

Environment: Tableau Desktop, Tableau Reader, Tableau Public, Tableau Server9/10, SAP HANA, SQL Server, MS Office tools.

TDS Telecom, Madison, WI.

Tableau Developer / Administrator Oct 2016 – Oct 2017

Responsibilities:

Involved in reviewing business requirements and analyzing data sources form Excel/Oracle-PL/SQL SQL Server for design, development, testing and production rollover of reporting and analysis projects within Tableau Desktop.

Involved in installation, upgrading version, Load Balancing and configuration of tableau server.

Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Developed Courses sales reports, best course sellers’ reports and marketing campaign reports for Marketing department.

Created Heat Map showing course sales by color that were broken into regions allowing business user to understand where we have most sales vs. least sales.

Created dashboard using parameters, sets, groups and calculations.

Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections

Create/Modify/Manage server task Scheduled data refresh on Tableau Server for increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Monitor server activity/usage statistics to identify possible performance issues/enhancements.

Projected and forecasted future growth in terms of number of subscribers by developing Area Maps to show details on which states were connected the most.

Converted charts into Crosstabs for further underlying data analysis in MS Excel.

Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and MS Excel.

Created dashboards for analyzing POS data using Tableau on top of SAP HANA.

Reviewed basic SQL and PL/SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

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.

Created monthly, quarterly and yearly financial reports for Finance department.

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.

Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 9,10, Tableau Server, MS Office Suite, Oracle, PL/SQL, SQL Server, SAP HANA, Salesforce, Microsoft Dynamic CRM.

SOUTHWEST-AIRLINES, Dallas – TX. Jan 2015 – Sept 2016

Tableau Developer/ Admin

Responsibilities:

Involved in requirement gathering and analyzing business requirements from clients

Providing solutions on designing and developing of front-end BI applications and Visualization solutions for clients according to specifications.

Administered user, user groups, and scheduled instances for reports in Tableau.

Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau Server.

Designing the Reports as per client Requirement and created the reports using Excel file and Oracle database.

Visualized the objects created in SAP HANA using Tableau to demonstrate data and visual analysis.

Utilized Alteryx for data blending, data preparation and advanced data analytics.

Working in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.

Executed Hadoop streaming jobs to consume and process terabytes of xml format data.

Translating business requirements into report visualization, design documents.

Responsible for universe designing and hierarchy building for data analysis.

Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.

Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Prepared proof of concept for best practices in Tableau deployment.

Build prototypes for demonstration and illustration purposes for peer groups, business partners, senior leaders followed by design, deployment and on-going enhancements.

Coordination with business and technical teams.

Defect analysis and assisting QA team in testing the reports and fixed the defects.

Assisted users in UAT

Environment: Tableau Desktop, Tableau Reader, Tableau Public, Tableau Server8/9, R, SAP HANA, Alteryx, Oracle 11g, PL/SQL, SQL Server, SharePoint, MS Office tools.

TMHP Austin, TX Aug 2014 – Dec 2014

Tableau Developer

Responsibilities:

Participate in requirement gathering and analysis of Business needs and responsible for creation of Functional Specification Document.

Involved in complete SDLC

Analyze the functional design documents and BUR Documents.

Responsible for creation of Detail design documents for reports and universes.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.

Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

Designed hive data model for staging and target tables.

Involved in Writing HiveQL and applying logic while updating target tables as per business requirement.

Loading data to external systems using Sqoop.

Developed UDFs in java as a utility functions for HiveQL.

Interacted with ETL developers and architects on data load issues and also regarding issues with NSK jobs related to reports.

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.

Responsible for writing unit test cases and documented the unit test case results.

Defect analysis and supported QA team in testing the reports and universes and fixed the defects logged by QA team and responsible for changing the defect status in QC.

Participated in UAT reviews.

Support on existing report and universe design issues.

Environment: Tableau Desktop, Tableau Reader, Tableau Public, Tableau Server8/9, SQL Server, Word, Excel, and Windows 2007.

Cube IT Bangalore-India

BI Developer Dec 2012-Oct 2013

Responsibilities:

Designed and developed MIS reports for strategic production planning, accounts analysis and inventory planning using Microsoft SSIS

Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data.

Used Event Handlers for Exception Handling in SSIS packages.

Supported Production Environment to schedule the packages and make the package dynamic with SQL Server Package Configuration.

Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Created/Updated database objects like tables, views, stored procedures, function, packages.

Designed Change data capture to capture insert, update, and delete activities applied to SQL Server tables, and to make the details of the changes available in an easily consumable relational format.

Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.

Used SQL Server Profiler to trace the slow running queries and the server activity.

Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, Table Variables and Stored Procedures.

Implemented BizTalk solutions and Change Requests (CR) using BizTalk artifacts such as Orchestration, Maps, and Pipelines etc. as per client requirement

Tested, developed BizTalk, SSIS solutions and conducted UAT for performance monitoring, system bug tracking and system integration testing

Provided RCA’s for production environment issues related to BizTalk and SSIS solutions and ensured quick response time in providing rectification measures

Involved in training, knowledge transfer and sharing sessions

Environment: SQL Server, SSIS, MS Excel, Windows Server 2008 R2, Microsoft Biztalk Server, SQL Profiler

Contact this candidate