Senior BI Analyst - Tableau & Power BI Expert

RONEN NKANSAH

Atlanta, GA 571-***-**** *******@*****.***

PROFESSIONAL SUMMARY

Senior Business Intelligence Analyst with 8+ years of specialized expertise in Tableau and

Power BI development, administration, and enterprise analytics. Proven track record designing

200+ interactive dashboards across Fortune 500 organizations, managing BI infrastructure for 800+ users, and driving self-service analytics adoption. Expert in translating complex business requirements into actionable insights through advanced visualizations, performance optimization, and data governance implementation.

CORE COMPETENCIES

Tableau Expertise: Desktop (LOD expressions, table calculations, parameters, sets), Server/Cloud administration, Tableau Prep, TabPy integration, REST API automation, performance optimization, SAML/AD authentication

Power BI Expertise: Desktop (DAX, Power Query/M), Power BI Service, Report Builder, workspace management, gateway configuration, row-level security, custom visuals, Azure integration

Data & Analytics: SQL (T-SQL, PL-SQL, Teradata), ETL (Alteryx, SSIS, DBT), Python, data modeling, data governance, requirements gathering, stakeholder management

Technical Stack: Snowflake, AWS (RDS, Aurora, Athena, Redshift), Azure, Teradata, Oracle, SQL Server, SharePoint, Jenkins, ServiceNow

EDUCATION

Central University college

BSc in Computer science 2013

PROFESSIONAL EXPERIENCE

Senior Business Intelligence Analyst

Johnson & Johnson New Brunswick, NJ 08/2023 - Present

Lead enterprise-wide BI initiatives developing 60+ interactive dashboards in Tableau and Power BI for C-suite executives across pharmaceutical, medical devices, and consumer health divisions

•Manage Tableau Server and Power BI Premium infrastructure supporting 800+ global users with 99.9% uptime, implementing row-level security, SAML authentication, and HIPAA compliance controls

•Design advanced visualizations using LOD expressions, complex DAX measures, and dynamic parameters for supply chain analytics, financial reporting, and clinical trial monitoring

•Architect end-to-end BI solutions integrating Snowflake, Azure SQL, SAP, Salesforce, and REST APIs with automated extract refreshes and data quality frameworks

•Develop Python-based predictive analytics integrated via TabPy for demand forecasting and customer churn prediction using scikit-learn

•Build automated ETL pipelines using Azure Data Factory, Alteryx, and DBT reducing manual processing by 50%

•Implement CI/CD practices using Tableau REST API and PowerShell, reducing deployment time from 2 hours to 15 minutes

•Establish BI Centers of Excellence defining best practices, design standards, and governance policies adopted globally

•Train and mentor 200+ business users through comprehensive programs, increasing selfservice adoption by 75%

•Partner with C-suite to translate strategic requirements into analytics solutions, conducting bi-weekly executive briefings

•Key Achievement: Developed AI-powered demand forecasting dashboard saving $2M annually; received Innovation Excellence Award

Senior Data Analyst/Tableau Lead

MIDMARK Traverse City, MI 10/2021 - 08/2023

•Managed end-to-end Tableau Server environments (2021.1-2023.1) including installation, multi-node HA configuration, upgrades, and security hardening for 500+ users

•Administered 15 sites with role-based access control, implemented comprehensive governance policies enhancing compliance by 25%

•Designed 50+ interactive dashboards with advanced LOD expressions, dynamic parameters, and hierarchical drill-downs for real-time revenue cycle insights

•Optimized server performance including extract refresh optimization (40% faster), VizQL tuning, and background task scheduling

•Automated data transformation using DBT and Snowflake with dimensional modeling, reducing maintenance efforts by 40%

•Created 100+ database objects (stored procedures, functions, CTEs) enhancing query performance and data refresh reliability

•Developed ETL solutions integrating Alteryx, Python, and Tableau Prep for seamless pipeline automation from 30+ sources

Designed executive KPI scorecards tracking patient volume, revenue per procedure, collection rates, and denial management

Built mobile-responsive dashboards optimized for tablets and field sales representatives

•Delivered comprehensive Tableau training programs to 100+ users across finance, operations, and clinical departments, driving 60% increase in self-service adoption

•Created reusable templates and calculation libraries standardizing development and reducing creation time by 50%

•Key Achievement: Developed denial management dashboards reducing claim denial rates by 15%, saving $3M annually

Sr. Tableau Developer

Walmart San Bruno, CA 06/2020 - 10/2021

•Led Tableau Server administration ensuring 99.9% uptime with HA configurations, disaster recovery, and enterprise security protocols

•Developed 40+ dashboards for finance, billing, and claims management using parameter actions, set actions, and cross-database joins

•Created FP&A dashboards with variance analysis, scenario modeling, and driver-based forecasting

•Built supply chain analytics tracking inventory turns, supplier performance, and transportation costs with SKU-level drill-downs

•Optimized SQL-based ETL pipelines on AWS (EC2, S3, RDS) reducing data refresh times by 35%

•Troubleshot performance bottlenecks through query optimization, indexing strategies, and extract optimization reducing load times by 50%

•Collaborated with IT teams establishing data governance frameworks and change management processes

•Identified automation opportunities eliminating 20 hours per week of manual reporting

•Developed Python scripts for Tableau workbook deployment and user provisioning using REST API

•Key Achievement: Consolidated 5 Tableau Server instances into unified platform, reducing infrastructure costs by $200K annually

Tableau Developer

KEY Bank Cleveland, OH 05/2019 - 06/2020

•Installed, configured, and upgraded Tableau Server across dev, UAT, and production environments on Windows Server 2016

•Delivered automated deployment scripts using Tableau Server Client (TSC) Python library and tabcmd utilities

•Managed site creation, project hierarchies, user provisioning, and role-based access controls

•Created 25+ financial dashboards analyzing profitability, loan portfolio risk, and branch performance metrics

Built regulatory compliance dashboards supporting Basel III capital adequacy and stress testing requirements

Monitored scheduled extracts, subscriptions, and server performance metrics, resolving 95% of tickets within SLA

•Maintained comprehensive documentation for server architecture, backup procedures, and disaster recovery protocols

•Implemented backup and restore procedures with automated nightly backups and offsite storageTableau Consultant

Bed Bath & Beyond Union, NJ 01/2017 - 05/2019

•Upgraded Tableau Server from version 9.3 to 10.5 with multi-node deployment and load balancing, improving efficiency by 30%

•Configured SAML 2.0 SSO integration with ADFS enabling seamless authentication for 500+ users

•Implemented Active Directory synchronization for automated user provisioning and role assignment

•Converted 100+ Excel-based reports into dynamic Tableau dashboards reducing report generation time by 75%

•Conducted requirement gathering workshops with merchandising, supply chain, operations, and finance stakeholders

•Designed custom chart types: Sankey diagrams, grouped bar charts, donut charts, and bar-in-bar charts using LOD calculations

•Enhanced dashboard performance through extract optimization, query simplification, and efficient filter design

•Provided post-deployment knowledge transfer sessions and created comprehensive user documentation

•Established dashboard usage tracking measuring view statistics and subscription adoption rates

Sr. Tableau Consultant

PayPal Draper, UT 05/2015 - 01/2017

•Created 35+ interactive dashboards blending data from Oracle, SQL Server, Excel, cloud APIs, and flat files

•Designed executive KPI scorecards tracking transaction volume, payment success rates, fraud detection, and customer satisfaction across global operations

•Built real-time operational dashboards monitoring payment gateway uptime, transaction processing times, and API latency

•Developed customer analytics with acquisition funnels, cohort retention, lifetime value, and churn prediction

•Created SQL-based data validation frameworks ensuring dashboard accuracy through reconciliation queries

Migrated legacy Alteryx workflows and Excel reports to Tableau solutions consolidating tool stack

Implemented automated report distribution using subscriptions delivering PDF/Excel exports to 100+ stakeholders

•Conducted exploratory data analysis identifying trends and insights communicated through executive presentations

•Built automated processes for content updates including scheduled refreshes and business rule changes

TECHNICAL ACHIEVEMENTS

Healthcare Analytics Modernization Johnson & Johnson: Led migration of 150+ SSRS reports to Tableau/Power BI serving 1,000+ users, achieving 90% satisfaction scores

Revenue Cycle Transformation MIDMARK: Designed dashboards tracking $500M+ annual revenue with predictive models improving cash collections forecasting by 35%

Enterprise Infrastructure Optimization Walmart: Consolidated multiple Tableau instances, optimized capacity planning, and improved dashboard performance by 40%

Contact this candidate