Eunice

Designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.   Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of the reporting and analysis projects within Tableau Desktop. Understanding the project scope, identifying activities/ tasks, task-level estimates, schedule, dependencies, and risks, along with providing inputs to the Module Lead for review

• Extensively used TabAdmin and Tabcmd commands in creating and restoring backups of Tableau repository.
• Managing and supporting the migration of objects from development to production environments.
• Implemented row-level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Setting up an active directory on the tableau server for the effortless password management for the single sign-on in Salesforce and the embedded dashboards.
• Planning, scheduling, and deploying tableau server installation.
• Developing storytelling dashboards in Tableau Desktop and publishing 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.
• Is an active part of a larger internal open-source community of developers at Hearst

Technologies and Skills:  Tableau, Salesforce, Python, ETL Tools, R, Statistical Modeling, Snowflake, AWS, SQL Server, Oracle, NiFi, Hive, Teradata, UAT, Open Source, Machine Learning, WhereScape

Performed administration tasks including managing Tableau server task schedules, granting access, managing extracts, and end-user installations. Worked with programmers, engineers, and management heads to identify process improvement opportunities, propose system modifications, and devise data governance strategies. Prepared final analysis reports for the stakeholders to understand the data-analysis steps, enabling them to take important decisions based on various facts and trends.

• Built and published customized interactive reports and dashboards, along with report scheduling using the Tableau server.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for users using Row-level security and User filters.
• Developed Tableau visualizations, Ad-hoc reports, and dashboards using Tableau Desktop.
• Created complex functions, scripts, stored procedures, and triggers to support application development.
• Tested databases and perform bug fixes.  Provided authentication and authorizations for Database. Maintained Test log and Writes Test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT)

Technologies:  Tableau, UAT, Data Analytics, Ad-Hoc Reports, Excel

Created configuration files to deploy the SSIS packages across all environments. Defined best practices for Tableau report development. Responsible for Developing Dashboard and preparing ad-Hoc Reporting.  Well-versed in SSIS development and warehouse environments

• Designed implemented and maintained physical and business data mapping
• Designed SSIS for data warehousing environment and automation of batch cycle
• Automated monthly excel reports into Tableau Workbooks and Dashboards
• Ensured compliance with standards for documentation by liaising with the base team
• Configured systems on an ad-hoc basis and created test plans and tested system improvements to optimize efficiency
• Prepared Dashboards using calculations, and parameters in Tableau. Involved in exploring, designing, building, and
  deployment of high-level and rich dashboards for decision-making of critical metrics using Tableau.
• Used Alteryx for data preparation and then tableau for visualization and reporting.
• Designed and developed ETL workflows and datasets in Alteryx.
• Wrote Python scripts to sync the most frequently used tables from the Oracle Production DB server to MongoDB, which
  is read by web services for downstream app consumption.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions, and packages to migrate data from
  SQL Server database to Oracle database. User JavaScript API to customize the views selects, filters, dates, and times.
• Generated Tableau dashboards with combination charts for a clear understanding
• Participated in the troubleshooting and fixing of inaccurate reports; perform root cause analysis on inaccurate
  report numbers and provided recommendations on how to avoid future issues.

Technologies:  SQL, PL/SQL, Oracle, JavaScript, APIs, Tableau, MongoDB, Python, Alteryx, ETL, SSIS

Created and Developed dashboards for Credit Risk use cases to understand new promotion effectiveness, trend detections, Seasonal forecasting, and cannibalization. Worked on administration tasks like adding workbook Permissions, Ownerships, and User filters. Consistently attended meetings with the client subject matter experts to understand functional business requirements. Coached and developed a distributed team of business executives and technical professionals regarding Agile roles, routines, and responsibilities resulting in a more thorough understanding of Scrum.

• Provided user training on the key dashboards
• Provided detailed documentation on the Analytical deliverables
• Used Industry-standard design templates for POS use case analysis.
• Performed data profiling in the ETL and table creation process before connecting to Tableau.
• Used trend lines extensively for correlating different KPIs for new product launches.
• Created custom Functions (Date range, Time functions, Logical functions) in the reports.
• Scheduled extract refresh and subscriptions for weekly and monthly reports.
• Integrated Tableau dashboards into internal web portal using VB Scripting.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled
  Maps and Symbol Maps, Pareto charts according to deliverable specifications.
• Extensively worked on different types of filters. Preparing reports for the management stating trends, patterns, and predictions using relevant data