Data Analyst/Tableau Developer/Admin

Charitha Sr Tableau Developer/Admin

CONTACT# : 614-***-****

E-mail : ********@************.***

PROFESSIONAL SUMMARY:

Over 7 years of IT experience in System analysis, design, development, Data Warehouse, implementation and maintenance of client server applications, providing Business Intelligence and OLAP solutions to Health Care, Financial, Retail and Banking Sectors.

5+ years of experience in working with Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 10.x/9.x/8.x.

2+ years of experience in various BI tools like Crystal Reports, MSBI Suite.

1+ years of experience in working with unstructured data creating workflows in Alteryx Designer with documentation and implementation of the processed data.

Expertise in web integration of Tableau Reports with HTML or Asp.Net.

Good usage of Tableau JavaScript API for performance improvement of web page.

Extensive Tableau Experience in Enterprise Environment and as Tableau Administrator. Experience including technical support, troubleshooting, report design and monitoring of system usage.

Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.

Involved in creating dashboards by using Level of Detail concept (LOD’s).

Implemented Tableau/Oracle BI security at the Data (Data security) and Object (Roles and Permissions) security.

Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse

Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems

Expertise in getting the data from different data source such as flat files, Excel, Microsoft SQL server, MySQL, T-SQL, PL/SQL, Netezza, AWS, Teradata as well as OBIEE.

Produced attractive visuals/dashboards to convey the story inside the data.

Experience in writing complex SQL queries to perform End-to- End ETL validations and support Adhoc

Business requests.

Experienced in requirement gathering, marketing/consumer analysis, design, development, testing, and production rollover of reporting and analysis projects.

Installation and configuration of Tableau Primary Gateway servers & Worker servers

Tuned the performance of VizQL, Data Engine and Back ground task engines.

Created python scripts to migrate dashboards and data extracts from Dev to UAT and UAT to Production.

Created server monitoring dashboards using Postgres repository to measure performance and usage at server level.

Responsible for Tableau Environment, Security, Architecture setup.

Worked on POC for setting up Tableau on AWS (Amazon Web Services) to provide a cost effective solution.

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

Customized the Tableau landing page with site listing as icons and descriptions

Constructed the reports page for internal strategy group with standardized custom right and left side sections within Tableau

Extensive experience in Tableau Administration Tool for Configuration adding users managing licenses and data connections scheduling tasks embedding views by integrating with other platforms like SharePoint

Involved in publishing of various kinds of interactive data visualizations dashboards and work books from Tableau Desktop to Tableau Servers

Hands on experience in deploying & publishing dashboards using Tableau migration scripts.

Expertise in performance tuning of the Tableau infrastructure including the application configurations and the interaction, effective utilization of the hardware platform including memory, and CPU resources.

Design, develop, and implement Tableau Applications for Financial Planning and Budgeting models with complex requirements.

Experienced working in both Agile/Scrum and SDLC based development environment.

Involved in conducting daily scrum calls within team and sprint meetings with stake holders.

Excellent communication skills in both written and oral along with ability to tell a story through data.

Ability to interact professionally with a diverse group including executives and managers.

TECHNICAL SKILLS:

BI/Visualization Tools: Tableau Desktop 8.x/9.x/10.1.1, Tableau Public 8.x/9.x, Tableau Reader 8.x/9.x, Tableau Server 8.x/9.x/10.1.1, Crystal Reports, Big Data Analytics, MSBI Suite (SSAS, SSRS).

ETL Tools: Informatica, SSIS, Alteryx Designer 11.7.4, Alteryx Server

Programming: SQL, UNIX Shell, XML, HTML, C, C#, NET, Java, Java Script API, Asp.Net VB.

Utilities: MS Office Suite, TOAD, MS SharePoint, MS Project

Databases: Oracle 8i/10g/11g, DB2, Postgre Sql, Teradata, Netezza, AWS, Cloudera Hadoop, SQL Server 2008 R2, MS Access, MS Excel, MS SQL Server 2005

Platforms: Windows7/8/2003/NT, MS Server 2008 R2, Mac OS,

Methodologies: Agile, Devops, Scrum, Complete Software Development Lifecycle, Application Lifecycle Management, JIRA Suite, Iterative and Waterfall

PROFESSIONAL EXPERIENCE:

CLIENT: KeyPoint Credit Union - Santa Clara, CA

DURATION: October 2016 - Current

ROLE: BI Solution/Tableau Developer

Project Description:

KeyPoint Credit Union is a Silicon Valley credit union dedicated to providing its members in the Bay Area, state of California and beyond with the products and services they need to improve their financial standing. We implemented new project named “Big Data” project which would be a great scope for more ETL Development and Reporting. As a BI Solution/Tableau Developer, I am involved in all phases of SDLC from data warehouse implementation to Business Intelligence report creation using Alteryx 11.7and dashboard development by creating data visualizations in Tableau 10.1.

Responsibilities:

Created Dashboards and visualizations using Tableau for several teams and delivered demo sessions to expand the tools reach in the IT environment.

Experience in working with Alteryx Designer and Alteryx Server.

Prepared data sets which are required for dashboard development using Alteryx Designer

Performed Data Blending by using Alteryx and also used for advanced Data Analytics.

Redesigned the data source having data from different sources into one SQL Server and to Tableau.

Created users, user groups and maintained user access rights in Tableau.

Performed Admin tasks such as monitoring DB services, Tableau Server running with optimal performance,

Monitoring licenses, monitoring user activity/sessions, consulting Tableau to define bugs in patches etc.

Created Architecture Design documents and Technical Specifications Documents

Connected Tableau to various databases and performed live data connections, query auto updates on data refresh etc.

Provided technical support to all team members during project execution

Performed reports/dashboards performance optimization

Involved in User Training documentation of Tableau dashboards.

Helped in testing and impact assessment on dashboards with changes to the data warehouse.

Created test documents that help in validating reports and dashboards in QA.

Single member who handled both ETL - Alteryx and Tableau Reporting operations

Created IVR (Input Validation Process) reports for the client which helped the client in identifying control totals for the data and also the exceptions in the data.

Developed crucial ETL which automatically populates the required time periods in Databases every month which reduced team effort significantly (Also reducing Runtime to good extent).

Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents

Involved in report and dashboard requirement gathering from the end users to define accurate requirements.

Good understanding of the customer business and implementing the same over to the reporting needs.

Created complex Tableau reports with multiple queries, custom sql, complex functions, merge dimensions,

Drill down/up/across/through, complex filters etc.

Environment: Tableau Server 10.1.1 and Tableau Desktop 10.1.1, Oracle 10g and 11g, SQL Server 2012,

Alteryx Designer 11.7.4, DW/BI, SQL/PLSQL, Windows Server/professional, VISIO.

CLIENT: Johnson and Johnson, NJ

DURATION: December 2015 – September 2016

ROLE: Sr. Tableau Developer

Project Details:

Johnson & Johnson is a company of enduring strength. We credit our strength and endurance to a consistent approach to managing our business, and to the character of our people. This project is about the Health Check Analysis of projects available in Johnson and Johnson. Using Tableau developed Health Check reports across each Segment to measure PMx plan standards at tasks/effort, dependencies, resources and project status level (schedule risks).

Responsibilities:

Developed dashboards, work books and data views depending upon the business requirements and published in Tableau Server

Created actions in worksheets and dashboards for interactivity and to compare data against different views

Monthly

Reviewed and evaluated KPI's, e.g. MTD, YTD, WTD, and Rolling 12 Yearly

Customized geocoding, created calculated fields and applied filters

Extensively used data blending, embed functionalities in Tableau

Worked on the requirement gathering of the reports.

Experience in performance tuning of reports in Tableau

Worked with Source System Subject Matter Expert (SME) to ensure that the extracts are properly mapped.

Used SQL for data mapping and querying.

Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.

Created queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.

Analyzed the database tables and created database views based on the columns needed.

Created dashboards displaying sales, variance of sales between planned and actual values.

Extensive experience in creating dashboards using calculations, parameters in Tableau.

Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.

Mastered in different formatting techniques, using Annotations and Mark Label.

Developed effective and interactive Dashboards using Parameters and Actions. Created dataflow diagram and documented the whole data movement process.

Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents

Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing & Deleting Users and activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.

Good understanding of Devops model and usage of this model to maintain the bridge between cross functional teams.

Devised an approach to analyze, summarize, and graphically display complex data for senior managers to quickly grasp the key inferences from the data to support strategy and policy decisions.

Environment: Tableau 9.2.4/9.3, Tableau Server 9.2.6, Cloudera Hadoop (Hive, Impala), Devops, SQL Server, Java Scripts, SSRS, Excel and other internal data source applications

CLIENT: Fannie Mae - Ashburn, VA

DURATION: August 2014 – November 2015

ROLE: Sr. Tableau Developer

Project Description:

Fannie Mae provides reliable, large-scale access to affordable mortgage credit in communities across our nation. We are the leading source of funding for housing in America, which means more people can buy or rent a home. We are focused on sustaining the housing recovery, improving our company, and leading change to make housing better. The objective of this project is to create an ecosystem of business users to create and manage their own Tableau dashboards switching away from excel, develop new dashboards from a new data warehouse to answer business questions and share with the respective group for further analysis and decision making; and to create a custom portal to host their dashboards.

Responsibilities:

Interacted with business users in gathering, analyzing and documenting the business requirements and translate them into technical specifications.

Created technical specification documents related to Tableau design and architecture.

Created several Tableau data extracts with prebuilt calculations, parameters and sets to enable end users to easily utilize the extracts as semantic layer to create their own workbooks.

Involved in Tableau Server Installation and Configuration, creating users, groups, and projects and assigning access levels.

Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.

Created various highly interactive dashboards and data visualizations reports for Ad Sales and Program Finance departments.

Developed multiple reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.

Actively involved in creating a custom portal design hosting Tableau workbooks using JavaScript API.

Created responsive workbooks for IPad /PC orientation views.

Worked with end users in creating complex dashboards in an iterative process.

Created several automated scripts to backup, restore and auto sync Windows AD users.

Performed tuning of Tableau workbooks and extracts to make them functional with large sets of data.

Conducted training sessions for Tableau Power users to use it as a Self-service BI tool.

Managed and coordinated with offshore team on deliverables.

Environment: Tableau 8.2/9.1, Server and Desktop, Postgre Sql, Teradata, Big Data Analytics, IBM Spark, Scala, SQL Server 2012, Oracle 11g, SQL/PLSQL, Windows Server 2012, VISIO.

CLIENT: McKesson, Charlotte, NC

DURATION: January 2014 – July 2014

ROLE: Tableau Developer

Project Description:

McKesson Corporation is the oldest and largest health care services company in the nation. They serve more than 50% of American hospitals, 20% of physicians and 100% of health plans, and as the largest pharmaceutical distributor in North America, they deliver one-third of all medications used there every day. The project is to design, develop and maintain interactive dashboards using Tableau for analyzing key performance indicators such as sales by suppliers and segmentation, inventory management, global revenue and profits, etc.

Responsibilities:

Gathered user requirements, analyzed and designed software solution based on the requirements.

Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.

Prepared Business Requirement document and then converted business requirements into technical designs.

Responsible to Deliver Proof of Concepts using AWS, understanding customer business

Designed standardized DataMart with aggregated data, calculated metrics to suffice the source data need for various Tableau Reports and worked with ETL developers, DBAs, Data Modelers to implement the same in Development, Test and Production environment.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality and publishing them to tableau server and tableau Online.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Created report schedules on Tableau server and Tableau Online.

Created complex formulas and calculations within Tableau to meet the needs of complex business logic

Created and assisted users in Tableau dashboard development.

Defined best practices for Tableau report development and effectively used data blending feature in Tableau.

Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.

Creating users, groups, projects, Data connections, settings as a tableau administrator.

Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment including AWS.

Maintaining server activities, user activity, and customized views on Server Analysis.

Manage the application's users, groups, and integration with Active Directory.

Good SQL reporting skills with the ability to create SQL views and write SQL queries.

Integration of Tableau reports with Asp.Net web applications and usage of JavaScript API for performance improvement.

Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Involved in testing the Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau (Desktop / Server), Oracle, MS SQL Server, SQL, Toad, Unix, Teradata, SQL Assistant, MS Visio, AWS, Informatica, Java Script API, Asp.Net VB, MS Office Suite (Word, Excel, PowerPoint)

CLIENT: Ascendum - Bangalore, Karnataka, India

DURATION: July 2011 - October 2013

ROLE: SQL Developer

Project Description:

Ascendum is a global information technology solutions company that works with SMBs and enterprise level

Organizations, including many Fortune 1000 companies, to help them solve their business challenges. The project was to develop an integrated data mart for HR and to complete data warehouse lifecycle project.

Responsibilities:

Involved in Database design, creation and maintenance of Databases.

Managing the use of disk space, memory & connections by monitoring.

Created tables and views.

Created functions, stored procedures, triggers and constraints using T-SQL.

Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.

Server & Application fine-tuning & trouble shooting.

Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.

Recovered the backups of SQL Server production databases in test server environment.

Analyzed poorly performing SQL queries to improve application performance.

Handling the trouble tickets which come into an application from the users based on the priority level.

Developed Complex queries to retrieve the data as per client requests based on certain parameters and restrictions.

Used Exception Handling extensively to display the error messages in the application.

Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.

Experience in report writing using SQL Server Reporting Services(SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Coordinating with peer groups for Network, Infrastructure and Data Center Operations.

Built SSRS report to support reporting needs.

Developing and processing of SSAS cube.

Helping team members in developing the packages.

Monitoring the team and their work so that the tasks are completed in time.

Environment: MS SQL Server 2005/2008, Windows 2000 Advanced Server, VB 6.0, and XML. Crystal Reports, SSRS, SSIS

Contact this candidate