ASHOK BABU

Sr. TABLEAU DEVELOPER / ADMINISTRATOR

Employer Details:

Ganesh

ac6sqf@r.postjobfree.com

972-***-****

SUMMARY:

Over 8 years of experience in IT industry as BI Developer, Tools including Tableau, QlikView, Hyperion and Business Objects with strong background in Databases and Data warehousing.

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

Created Dashboards for the Top-level Management like the Trend Analysis, What-if Analysis using Tableau and BO Dashboards

Introduced Tableau to Client’s to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business decisions.

Created Dashboards using multiple BI Tools with Drill-Down capabilities using Dashboard prompts, Local and Global Filters.

Effectively collaborated with cross-functional team (IT, commercial, and customer) to deliver a new real-time recommendation solution based on SQL/Python analytics, BI Dashboards, and mobile tablets.

Experience in training Business users through online and in-class sessions.

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

Excellent understanding of concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases Oracle, Teradata, Vertica, MS Access and client/server applications.

Have working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems

Having strong analytical, logical, Communication and problem-solving skills. Ability to adapt to new technologies by self-learning.

Experience in Insurance, Educational, Banking and Financial Service Domains and ability to analyze big data.

Good Understanding of Big Data and Hadoop technologies (Hive, Pig, and Spark), experience in loading, processing and extracting data in Hadoop environment.

Extensively involved in the ETL layer development.

Knowledge of QlikView and OBIEE reporting tools. Supervised Vizql and WGSQL processes to test the system stability and performance.

Ability to work independently, excellent communication and strong team-building management skills.

Extensively worked on databases like Oracle, SQL Server, and Teradata.

Experienced in leading a small team and Knowledge in Medical Information domain (Health Insurance and Clinical Data concepts).

TECHNICAL SKILLS:

Reporting Tools

Tableau, QlikView, Hyperion IR, Business Objects, Endeca, Alteryx

Database

Teradata, SQL Server, Oracle, Hadoop

Languages

SQL, PL/SQL, Hive SQL, R Scripting

Data Modeling Tools

Star Schema, Snowflake Schema, OLAP, OLTP, SQOOP

Operating Systems

Windows NT, UNIX/LINUX

PROFESSIONAL EXPERIENCE:

YETI, AUSTIN, TX DEC’2016 TO PRESENT

Role: SR TABLEAU DEVELOPER / ADMINISTRATOR

Performed multi-faceted roles; not only responsible for creating dashboards, reports etc., but also directly working with executives to solve their problems. Presented demos to user groups and worked with Business users directly, and then converted the requirements into a workable solution. Analyzed, developed and completed critical reporting for departmental and executive needs.

Defined architecture for Tableau and established Dev/QA/Prod environments.

Responsible for security configuration including user/ group setup, permissions, security roles, configuration of trusted ticket authentication.

Setup new projects, security groups, roles and administer users for all supported platforms.

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

Monitored Tableau Servers for its high availability to users and provided availability accordingly.

Worked on Tableau Server upgrades for new versions.

Managed Tableau extracts on Tableau Server and administered Tableau Server.

Provided Tableau Demo’s to on boarding users.

Created report schedules on Tableau server and developed monthly reports and dashboards.

Used Azure SQL Data warehouse which facilitated reading, writing and managing large data sets residing in distributed storage.

Analyzed data in the Azure SQL Data Warehouse along with working on determining additional fields and data points that need to be added.

Managed SQL infrastructure from SQL server to SQL database through SQL Server Management Studio (SSMS).

Designed and implemented the logic for cut-over strategy in data warehouse for migration of reports from Epicor to SAP BO.

Responsible for data integration of Epicor and SAP BO and data management.

Defined best practices for Tableau report development and developed data visualization dashboards with best practices.

Designed, modelled & built Daily Sales Report and Order Book Report in Tableau which are critical reports for senior management.

Wrote test cases and QA the work developed.

Provided Production support for all the Tableau reports.

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

ENVIRONMENT: Tableau Desktop, Tableau Server Administrator, SAP BO, Hadoop/Hive, Azure SQL Data warehouse, SSMS, Epicor

BIOGEN, CAMBRIDGE, MA DEC’2015 TO DEC’2016

Role: SR TABLEAU DEVELOPER/ ADMINISTRATOR

Involved in a wide variety of business intelligence and data analytics efforts, including the development and support of existing applications, portal products and custom SaaS solutions. In addition, assisted in building the infrastructure to support future systems integration efforts. Consulted with a diverse cross section of internal and external business users to understand their business needs and translated those business needs into functional specifications and technical requirements. Report Authoring/Development experience using various tools like Tableau, QlikView, Endeca, and Business Objects.

Extracted data from a variety of sources including BI systems and perform detailed data analysis.

Took a lead role in developing and publishing reports, dashboards, presentations, and tools to aid consistent tracking of Enterprise KPIs.

Collaborated with IT to Deliver/Enable Solutions using Agile/Fast Track methodology.

Involved in extracting data from source to HDFS and importing data from HDFS to Hive using SQOOP

Documented experience as a BI Analyst specifically with Tableau software – both Tableau Desktop & Tableau Server.

Created Advanced Tableau Dashboards, SQL Queries and SQL Optimization experience.

Worked extensively on G8 Dashboard viewed by Top 8 executives of the company to analyze business and take decisions accordingly.

Applied security features of Business Objects like row level, report level object level security in the universe to make the sensitive data secure.

Performed thorough analysis, unit testing and integrated testing with other applications of database objects before deployment to the production server.

Provided Production support to the G8 Dashboard on a daily, weekly and monthly basis.

Participated in daily stand-ups (Sprint planning sessions) on daily design and development effort.

Gathered requirements and plan milestones in the development and implementation phases of the project lifecycle.

Created a data integration application using Python which integrates the excel files using VLOOKUPs and help the team automate the aggregation process

Processed Python scripts and converted the data files in a format readable by Tableau to use as Tableau data extracts (TDEs).

Developed Python Scripts to load data into Tableau accordingly and worked with multiple data connections including Hadoop/Hive by data blending.

Performed incremental and full refreshes to the TDEs based on appropriate schedules and provided necessary authentication.

Resolved tickets in JIRA and updated them on a daily basis.

Performed data validation of the results in Tableau by validating the numbers against the data in the database to maintain data integrity.

ENVIRONMENT: Tableau Desktop 9.3/9.2, Tableau Server 9.3, Tableau server 9.2 / Administrator, Python, QlikView, Endeca, Business Objects, Hadoop/Hive, SQOOP

CAPITAL ONE AUTO FINANCE, PLANO, TX MAY’2015 TO NOV’2015

Role: SR TABLEAU DEVELOPER/ ADMINISTRATOR

Project responsibilities are for the definition, design, construction, integration, testing, and support of reliable and reusable software solutions, addressing business opportunities. These include systems analysis, creation of specifications, coding, testing, and implementation of application programs and data interfaces. Responsible for overall Tableau design of dashboards, including interfaces with other applications and systems. Assures that application designs are consistent with industry best practices application attributes including scalability, availability, maintainability, and flexibility

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 so as to ensure that refreshes are performed as required.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps and Gnatt charts.

Queried various ODBC connections such as Teradata, Oracle SQL Developer, and SQL Server to modify dashboards accordingly.

Worked extensively on Daily performance reports to showcase prior day’s performance and trending towards key metrics at team level and across associates.

Published Workbooks by creating user filters so that only appropriate teams can view it.

Designed Market intelligence report which depicts State market shares and Auto counts data and modified the report according to defect tracker.

Documented and modified user groups for Tableau reports as per Hierarchy which included National, Divisional, Regional, Teams and Associate Levels respectively.

Formulated and executed best practices for those Tableau reports developments.

Installed and configured Tableau desktop 9.0 along with silent mode features and migrated Tableau reports from 8.3 to 9.0 Version.

Performed testing on reports in Tableau server 9.0 and compared to Tableau server 8.3 by participating in tracking and monitoring Tableau server 9.0 performances.

Assisted in mapping of server nodes for Tableau server deployments.

Managed production environment and prepared Standard Operating Procedures (SOPs).

Implemented SalesForce performance testing of Tableau integrated tabs after making Salesforce and Tableau views interact with each other.

Studied server architecture and analyzed scheduling related issues.

Conducted platform performance tests and implemented Tableau platforms accordingly.

Documented and maintained system designs and Tableau technical aspects.

Evaluated performance test results and developed technical architecture.

ENVIRONMENT: Tableau Desktop 9.0, Tableau server 9.0 / Administrator, Tableau Server 9.0, Tableau Online, Teradata, SQL Server, SalesForce.

REACHLOCAL, LOSANGELES, CA NOV’ 2014 TO MAY’ 2015

Role: SR TABLEAU DEVELOPER

Project is a proof of concept (POC) to an existing senior management dashboard stood up in Tableau using data sources in analytics database. Transitioning plan from SQL server to data mart was constructed eventually with necessary drilldown levels. Produced project plans, architecture diagrams, technical and training documentation as required by the management as a part of POC

Developed highly polished executive level dashboard prototype regarding total budget views, churning, new acquisitions and value changes for budgets.

Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions, and provided an interactive reporting environment in the developed dashboards.

Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the total value change with several weeks ago data.

Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.

Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.

Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.

Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.

Worked on building queries to retrieve data into Tableau from MySQL Workbench and developed T-SQL statements for loading data into Target Database.

Implemented Tableau Online to enable cloud implementation of analytics developed on Tableau desktop, and to make dashboards available on the cloud platform being implemented by the client.

Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management as part of the POC.

Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.

Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.

ENVIRONMENT: Tableau Desktop 8.3, Tableau server / Administrator, Tableau Online, MySQL Workbench.

RESOLVITY, IRVING, TX AUG’ 2013 TO NOV’ 2014

Role: TABLEAU BI DEVELOPER

Project is to Convert Hyperion IR 8.3.2 to Tableau 8.1 Developed New and Converted Hyperion Reports and Dashboards to Tableau in multiple Business areas like Claims, Policy and Billing, which helped the management to make better decisions. Dashboards/Score card was provided as the interface to run reports at various levels (summary/Detail reports/Snap shot of inventory calls) and show different views like Reports, pivots and charts. Converted agent reports and dashboards to Tableau

RESPONSIBILITIES:

Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.

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.

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

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images and Maps.

Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.

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

Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.

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.

Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.

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

Involved in creating dashboards and reports in Tableau 8.1 and Maintaining server activities, user activity, and customized views on Server Analysis.

Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

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

Experienced in Automation using UNIX Shell Scripting including strong Database & UNIX OS troubleshooting.

ENVIRONMENT: Tableau Desktop 8.1, Tableau server / Administrator, Hyperion IR, SAS, SQL developer, UNIX Shell Scripting, Unix/Linux

EASTERN NEW MEXICO UNIVERSITY, PORTALES, NM FEB’ 2012 TO JUL’ 2013

Role: TABLEAU DEVELOPER

Worked in FUND Reporting Unit, which are used by Major Gifts Officers, Annual Fund Officers, Planned Giving Officers, and other management development staff to monitor the Fundraising progress to date, so that fundraising efforts can be analyzed in a uniformed manner across the university Designed and developed complex Dashboards, Pivots, Reports, Charts and Data models using Tableau Designer.

RESPONSIBILITIES:

Upgraded tableau 7.0 to tableau 8.0. And gathered requirements, analyzed from raw data.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.

Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.

Worked on motion chart, Bubble chart, drill down analysis using tableau desktop for Amazon.

Involved in created stored procedures, views, and custom sql queries to import data from sql server to tableau.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.

Analyzed data using MS Excel using VLOOKUPs, pivot tables, charts and VBA.

Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.

Ability to work quickly and under tight delivery deadlines with focus on details.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Published dashboards on Tableau server for the user community to access through web portal.

ENVIRONMENT: Tableau Desktop 8.0/7.0, Tableau server / Administrator, SQL developer, VBA, Microsoft Excel 2007, MS Access, Microsoft office 2007.

FIRST TENNESSEE BANK, MEMPHIS, TN DEC’ 2009 TO JAN’ 2012

Role: DATA ANALYST/BI DEVELOPER

RESPONSIBILITIES:

Extracted the data from various data sources such as databases, CSV files, and Excel documents transforming the data into standard format (QVDs) and load the data so that it is available for analyzing and creating reports.

Designed Schema using dimensions, fact, logical, physical, alias and extension tables.

Developed QlikView scripts to load the transformations and make enhancements to the user interface of the desktop application.

Prepare UNIX shell scripts for testing the application.

Installed and configured QlikView 9.0. Assisted in upgrading from QlikView 8.2 to version 9.0.

Application processed tables with over 10 million records. Experience in scripting QlikView Set Analysis and Macros.

Eliminated synthetic keys using QVD concatenation and by renaming the fields.

Wrote scripts and created batch files for automatic running of QlikView scripts.

Converted the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.

Performed data analysis after conversion using procedures or functions in PL/SQL.

Used SQL Developer for developing and managing PL/SQL scripts.

Designed user interface and prepared layouts for the system using QlikView.

Involved in the developing of star schema and snow flex schema dimensional data model.

Used MS Access and QlikView extensively as reporting tools and to create user build specifications and customized QlikView reports

ENVIRONMENT: QlikView, MS Excel, MS Access, PL/SQL, SQL Developer, UNIX Shell Scripting

Bachelor of Technology from GITAM University, Visakhapatnam, India

Contact this candidate