Lead Tableau Developer & Data Analyst Resume
4.00/5 (Submit Your Rating)
NY
SUMMARY:
- 9+ years of experience in Information Technology with focus on Data Visualization, Story Telling, Data Analysis, Business Intelligence, and Client/Server System Architecture.
- Hands - on with creating solution driven datasets via visual joins and queries in Tableau along with views, dashboards, and stories comprising various chart types including Heat/Tree/Geo Maps, Line/Bar/Pie Charts, Scatter Plots, and Bullet Graphs in Tableau Desktop versions 7.x/8.x/9.x/10.x/2018.x/2019.x/2020.2.
- Created interactive dashboard using techniques for guided analytics and visual best practices to convey the story inside the data to vast range of audience including C-Level Management Team and end users.
- Well versed in requirement gathering/analysis, design, development, testing, and production rollover of projects.
- Built and expanded reports available for both internal support and external customer reach, which included increasing the scope of data extracted and better utilization of Business Intelligence and analytical reporting.
- Defined best practices for Tableau adaptation including design and manage Tableau Platform Data Integration, Governance Strategy, and Center of Excellence (CoE).
- Expert in Tableau Server administration including setting up users and groups, creating row level security using user filtering and groups, enabling Single Sign-On using SAML, and scheduling data refresh instances and subscriptions for health monitoring.
- Work independently with no/limited supervision in tighter schedules and delivering results.
- Trained end client and business users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.
- In depth knowledge of Software Development Life Cycle (SDLC).
TECHNICAL SKILLS:
- Tableau Desktop, Tableau Prep, Tableau Reader, Tableau Online, Tableau Server, Cognos, SharePoint, Business Objects
- Modeling & Programming Tools Alteryx, SQL, UNIX Shell, HTML, CSS, JavaScript, MS Visio, Denodo for Data Virtualization
- Utilities MS Office Suite, MS SharePoint, MS Project, MS FrontPage, MS Money
- Databases Oracle 10g/11i, Oracle, MS Azure SQL Server, Sybase, Business Objects, Salesforce, Google Analytics, Amazon Redshift, MongoDB, Netezza, Cognos, Hadoop Cloudera & HortonWorks Hive, Snowflake, Denodo, MS SQL Server 2012 R2, MS Access
- Platforms Windows 7/8/2003/NT, Win Server 2008/2012 R2, Mac OS, DOS, UNIX, Linux, Ubuntu, Citrix
- Networking TCP/IP, VPN, LAN/WAN Technologies
- Security Webgate, Tier Architecture, SAML, SSL, Token-Based Authentication, Active Directory, AWS, Microsoft In-Tune, VMWare Airwatch
PROFESSIONAL EXPERIENCE:
Confidential, NY
LEAD TABLEAU DEVELOPER & DATA ANALYST
Responsibilities:
- Key role player to start company-wide change in reporting and built visuals that opened doors to never before seen cross program enablement to increase patient care and provide one-stop solution for financial reporting.
- Created Pharmacy, Professional, and Facility claims roster from various programs that enable cross marketing of products directly to end-consumers for growth of revenue in terms of claims and patient care.
- Generated valuable insight by showcasing initial claims Dashboards to Marketing which lead to providing data that was used to market a local event happening within 2 weeks of demo. The one-on-one session with Marketing team turned into valuable outcome of increased number of patients that wouldn’t have known about local event without the help of Tableau.
- Fine-tuned reports to ensure performance by either utilizing Tableau’s Hyper extract or benchmarking performance recording and working with DBA’s to fine-tune database for optimal performance.
- Created and demonstrated additional claims and organizational operations reports to finally un-cover the link between patient and program and how to better leverage programs for incoming patients by cross referrals that in-turn generate bottom line revenue.
- Created Visit Counts Dashboard, Denial Claims Dashboard, and Program Census Dashboard to further connect departments and break-down silos to achieve free-flow of critical data across the organization.
- Utilized Tableau Prep and Alteryx to cleanse and prep data before adding visual insights.
- Created and migrated reports from existing Cognos system into Tableau and provided further drill-down capabilities that Cognos was lacking. Updated existing eCW eBO reports in Cognos to allow better drill-down capabilities.
- Implemented Row Level security by creating user filters on Tableau Server and creating User Tables in Database to block confidential data from users that remains invisible without the loss of performance.
- Successfully upgraded environment from 10.5 version to 2019.1 version. Provided wide ranging system administration in a multi-platform environment. Created Business Continuity plans to ensure High Availability and reports to perform daily system monitoring.
- Implemented Tableau Server back-up scripts and weekly restarting of application via PowerShell and Windows Task Scheduler.
- Environment: Tableau Desktop & Server 10.5/2019.1/2020.2, Alteryx 11.x, eCW, SQL Server, Hortonworks Hadoop, Excel, eClaims, Cognos
Confidential, NJ
LEAD MANAGER/DEVELOPER - BUSINESS INTELLIGENCE TABLEAU
Responsibilities:
- Manage Tableau environment within the firm, including deployment of Tableau Servers in INT/Test & Prod environments and handle 1000+ user flow on daily basics. Played key role in taking firm’s Tableau utilization from infancy stage of 10 ad-hoc reports to more than 220 productionalized, state of the art dashboards. Handle scaling and performance tuning improvements existing reports and environment for the firm including maintaining 99.98% of up-time. Reduced business inquires turn-over time for any topics related to Tableau from 1 business day to half hour solution.
- Trained 150+ business users from 27 various LOB’s on Tableau Desktop to drive self-service and adaptation of Tableau as tool for quick report churning which used to take 3 to 6 months previously when handled by IT.
- Implemented Architecture build out of end-report viewing from Token-based authentication via Webgate auth to SAML(SSL) auth implementation for Single Sign-On from all devices along (iOS and Android) with Tableau Server upgrades from 8.x to 2018.x
- Defined best practices for Tableau adaptation including design and manage Tableau Platform Data Integration, Governance Strategy, and building Center of Excellence (CoE).
- Restricted data for particular users using row level security and user filters via Tableau Server groups.
- Deployed reports utilizing SAML auth to external vendors in a multi-tenant environment without allowing them to tunnel into Confidential network. Worked with Architecture team to conduct extensive Pen Testing to sure Tableau Server and met requirements for external facing clients.
- Participate in the user requirement gathering and design meetings. Translate business needs into reporting and analytic requirements.
- Partnered with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts and recommended improvement strategies for normalizing datasets by building new Data Mart allowing data enrichment.
- Analyze and massage data for better performance by visual joining tables, blending, and selecting required data to build state-of-the-art Tableau Dashboards.
- Utilized Alteryx and Denodo for Data Blending in order to cross join data from different sources like Salesforce, Google Analytics, MongoDB, Netezza, Oracle, SQL Server, Excel, Hadoop, etc. into a single data source output in form of TDE (Tableau Data Extract) to be utilized for creating meaningful dashboards. Ran POC utilizing Snowflake to test performance of existing reporting.
- Environment: Tableau Desktop/Server 8.2/9.2/10.2/2018.1, MS Azure SQL Server, Salesforce, Google Analytics, MongoDB, Netezza, Oracle, SQL Server, Excel, Cloudera Hadoop, Win Server 2012 R2, Denodo, Alteryx, Snowflake, SAML, Webgate, AirWatch
Confidential, NY/NJ
SENIOR TABLEAU DEVELOPER
Responsibilities:
- Created stunning visuals to monitor product line performance for brands labeled under Diageo. Tracked Depletions by Brand Variants for Fiscal Year for YoY% Changes, Location Variants by Countries, On/Off Premise mixed performance and overall tracking financial changes. Project required immediate turnaround and I was able to deliver results within 2 months.
- Converted existing student grade tracking reports from Cognos to Tableau and delivered additional filter capabilities to reports for Laureate, Inc. Travelled to MD to gather requirements and train end-users on Tableau.
- Spoke to business team to understand the scope of the project and implement changes on daily/weekly into the reports, dashboards, and scorecards being produced in Tableau Desktop.
- Present data discovered via Tableau to stakeholders along with providing a guide on how to navigate through Scorecards and utilize filter’s to drill-down on data within Tableau.
- Perform quality assurance and document data gap findings to be further analyzed and cross-check with raw data.
- Created views with complex calculations that included count between set of values in given dimension, count not equal to values, avoid null values, current/last year totals, future prediction based on current and previous metrics, along with monthly running totals, as well as using Table Calculations.
- Maintain documentation for modifications made within relevant dashboard development phases including tracking and performing data governance testing.
- Trained Cognos, Business Objects, Salesforce, and MS Excel report developers on how to utilize Tableau and customize to their need with step-by-step walkthrough of Tableau Desktop and Tableau Server.
- Environment: Tableau Desktop 8.2/8.3, Tableau Server 8.2/8.3, Salesforce, Hadoop Hive, Cognos, MS Excel, Win Server 2012 R2
Confidential, NJ/NY
LEAD TABLEAU DEVELOPER
Responsibilities:
- Developed robust Tableau Dashboards for Confidential and drug performance and market share.
- As a Visual Report Developer/Data Architect, primary role was to take data and put it into a way that Tableau likes; understanding what the needs are and reverse engineering existing reports. Understand the problem being asked so that Tableau can be configured to visualize an answer.
- Created KPI scorecards for evaluating primary TRx sales vs. other products and competing TRx in the market.
- Work with SQL tables and joins and bring them into Tableau with multi-layer data blending.
- Collaborate with data source systems and Subject Matter Experts (SMEs) to identify data issues and data gaps.
- Build complex reports to be re-used by refreshing data that contained advanced calculations, parameters, action filters, and table calculations. Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.
- Environment: Tableau Desktop 8.1 & 8.2, Tableau Server 8.1 & 8.2, Salesforce, Hadoop Hive, Cognos, MS Excel, MS SQL Server 2012 R2, Win Server 2012 R2, Active Directory
Confidential, JERSEY CITY, NJ
TABLEAU DEVELOPER
Responsibilities:
- Scope of the project was to enhance the Mobile Banking App’s systematic processes which were associated with Personal Banking division. Developed Tableau Dashboards for app usage data based on login time status, usage of pay bill capability, and transfer money to get better understanding of future enhancements.
- Created numerous dashboards in Tableau Desktop based on the data collected from Mobile Banking App by importing and blending data from MS Excel and CSV files along with MS SQL Server Databases.
- Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
- Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
- Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the Mobile App usage with Quick Filters for on demand needed information with just a click of a button.
- Environment: Tableau Desktop, Tableau Server, MS SQL Server, MS Excel, CSV, Win Server 2008 R2, Active Directory
Confidential, MORRIS PLAINS, NJ
BUSINESS TABLEAU ANALYST/DEVELOPER.
Responsibilities:
- Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
- Gathered and analyzed business requirements, consulted with end users and business representatives, documents requirements into BRD’s and provided test cases for end user testing.
- Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
- Environment: Tableau Desktop, Tableau Server, MS SQL Server, MS Excel, MS Access, Win Server 2008 R2, Active Directory
Confidential, NJ
BUSINESS/DATA ANALYST
Responsibilities:
- Evaluated annual credit reviews for a portion of Confidential ’s portfolio and recommended analyzed data to Credit Committee for appropriate credit risk rating decisions.
- Gathered and analyzed both legal and credit data sets, performed due diligence on deals, consulted with credit associations and business representatives, and financial ratios for the preparation of credit reviews.
- Translated clients’ needs into usable mapping and coding instructions and created functional requirements document and mock ups for reporting.
- Environment: MS Excel, MS SQL Server, UAT, BRD, FRD, SQL Queries, Flow Chart
