Your Name

• 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

• Gathering user requirements analysis and designing software solutions based on requirements.
• Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.
• Conducted independent statistical analysis, descriptive analysis, hypothesis testing and logistic regression.
• Provided assistance for health care projects through SAS statistical and analysis software tools.
• Assisted in development of Data formatting and cleaning criteria from various data sources.
• Writing complex statistical calculations for report and performing future predictive analysis using tableau.
• Extensively used advanced chart visualizations in Tableau like Dual Axis, Bar chart, Pareto Chart, Heat Maps, Tree maps etc., to assist business users in solving complex problems.
• Created complex formulas and calculations within Tableau to meet needs of complex business logic.
• Defined best practices for Tableau report development and effective use of data blending and data joining features in tableau.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for weekly and monthly dashboard reports on Tableau Server using TABCMD.
• Experienced with Performance Tuning and Optimization of Rendering Time on Visualizations and Dashboards
• Strong SQL skills including complex queries, unions, multi-table joins.
• Experience in backend server programming, web services, micro services to integrate with UI and databases.
• Performed Gap analysis by identifying existing systems, documenting enhancements to meet end state requirements.
• Created dashboards and reports for ad-Hoc Reporting.

Environment: Tableau Desktop 2018/2019.x, Tableau server / Administrator, SQL Developer, SQL 2008

• Oversee performance of Design to develop technical solutions from Analysis documents
• Gathered Business Requirements, interacted with Users, Project Manager and SMEs to get better understanding of Business Processes
• Analyzed source systems and created Business Requirement Document (BRD)
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
• Created best visualizations reports as per business requirements using Tableau desktop professional edition.
• Blended data using multiple data sources (primary and secondary)
• Enabled tableau Actions to drill down from Dashboard to worksheet
• Extensive experience on creating trend reports including forecast and trend lines
• Configured incremental data refresh for data sources
• Prepared BI Interactive Dashboards using calculations, parameters in Tableau
• Background in installing and upgrading of Tableau server and server performance tuning for optimization
• Configured AD security using tableau server
• Responsible for authorizing users based on their privileges
• Involved in migration activities related to Tableau across environments
• Designed filters, power prompts, and complex financial calculations for various analytical reports
• Implemented security in reports according to employee groups and roles according to requirement and was involved in deployment process
• Expertise in connecting to Oracle and SQL databases and troubleshooting

Environment: Tableau Desktop/Tableau server 9.x/10.x, TabCMD, SQL Developer, SQL 2008, Oracle 10g, MS Access, Windows Server, Microsoft Office

• Worked as SQL Developer and establish strong relationships with end users and technical resources throughout established projects
• Worked closely with development team to provide support for database objects (stored procedures/triggers/views) and performing code review
• SQL Server Developer will work closely with Application Developers to ensure proper design and implementation of database systems
• Database administration including performance monitoring, access management and storage management
• Partners with development teams/vendors to provide reporting on in flight software development projects
• Create, develop and maintain SQL processes for channel performance data warehousing
• Closely working with development manager and onsite team to deliver solutions

Environment: SQL Server 2005/2012, Windows 2000, 2003 Server, MS Access, Excel, Frontbase, InfoPath 2003/2007, ESX 2.X, 3.X, SSIS, Reporting Services