- Constructed detailed parameterized data flows using Custom SQL and recipes on Data Prep, designed data plans for duplicating data across multiple instances, and created BigQuery datasets on Google Cloud Platform to automate Tableau data sources for analytical teams
- Undertook end to end analytics tasks for multiple projects by developing comprehensive product reporting, identifying KPIs for executives, designed data models on MS Visio through, and storytelling via Tableau dashboards
- Migrated SSRS Reports into Tableau dashboards, by redesigning them to serve as interactive global reports using PostgreSQL database
- Implemented a KPI Health dashboard by blending complex data sets from Sales data, Heap (user behavior), Dyna trace monitoring tool, Adobe Analytics and ServiceNow to showcase health of digital KPI metrics for leaders
- Forecasted sales data including accuracy rates by the type of forecast models into a Tableau dashboard containing outputs from machine learning algorithms stored in Oracle, which drove high priority business decisions
- Developed a comprehensive product dashboard for a crowd sourcing platform to track activity of users by setting up a fully automated ETL script using Alteryx
- Managed the implementation of an end-to-end solution of a Global Tableau dashboard for detailed analytics for an asset storage system to gather and convert data from various instances (Asia, Europe, China, North and Latin America) with different databases (MySQL, Maria DB, Oracle, SOLR), store daily extracts from those instances (json files) into Amazon’s S3 system, test the file formats, and develop the comprehensive automated KPI dashboard to enable leadership track the usage statistics of assets uploaded and downloaded into the Company’s system
- Developed a detailed functional dashboard by setting up unit and system test environments for a virtual beauty application
- Implemented a Tableau web data connector with Dyna trace API to reduce analysis time and track system health
- Built report prototypes using sample data, querying databases for data sets, scan data log files, enable performance recordings, and set up logical databases on Amazon Athena and Oracle to allow data querying of raw data
- Actively utilized agile methodology through Atlassian JIRA tickets and Kanban boards to communicate with project teams for task tracking and providing detailed end to end reporting documentation on Atlassian Confluence
- Implemented metrics, filters, reports, dashboards and also created advanced chart types, using calculations to manipulate the data and enable user driven parameters for visualizations and drilled down level of detail using sets
Environment: Tableau (Desktop/ Server) 10.x/ 20.x/21.x, Alteryx Designer 2019, Amazon Web Services (Redshift, Athena, S3), Google Cloud Platform (BigQuery, Data prep, Data studio), Adobe Analytics, Heap, Google Analytics, Dyna trace, Oracle 10g, Toad for Oracle, SQL Developer, DBeaver, Maria database, MySQL, MS SQL Server, PostgreSQL, MS SQL Server Reporting Services, MS Visual Studio 2010