Data & Analytics Leader Data Architecture Business Intelligence

Frank J Tirone

Morris Plains, NJ

*******@*****.*** 973-***-**** www.linkedin.com/in/frank-j-tirone

Professional Summary

Strategic Data and Analytics Leader with over 20 years of success in designing and leading enterprise-scale data platforms, cloud migrations, and governed analytics ecosystems. Trusted advisor to Fortune 500 clients in healthcare, finance, and education. Proven ability to lead global teams, accelerate insights (7x pipeline speed), and rescue failing BI initiatives. Certified in Snowflake, Informatica, and Fivetran.

Professional Highlights

Turned around failing analytics projects across healthcare, education, and financial verticals.

Delivered 40% faster report load times and 7x faster data processing pipelines.

Designed secure, governed analytics platforms enabling enterprise-wide adoption.

Mentored teams, managed global resources, and supported $MM data initiatives.

Core Competencies

Data & Architecture: Enterprise Data Architecture, Data Integration & ETL, Cloud Data Platforms, Data Governance & Security

Tools & Automation: Informatica, dbt, Power BI, Fivetran, Power Apps, Power Automate, DevOps, CI/CD

Leadership & Delivery: Agile/Waterfall/Hybrid, Stakeholder Engagement, Team Leadership

Professional Experience

Dynamic Computer Consultants — Founder & Principal Consultant

Feb 2025 – Present

Actively consulting full-time since February 2025

Providing data architecture and analytics consulting for healthcare, finance, and enterprise clients.

Leading projects involving Snowflake, Azure, dbt, Informatica, Power BI, and MDM platforms.

Recently focused on advising clients on data strategy, governance, and AI integration initiatives.

Previously engaged in short-term and fractional data projects through DCC while working full-time in other roles.

CTI Data – Data Analytics and Architect Leader

Jun 2022 – Feb 2025

A consulting firm specializing in advanced data and cloud analytics solutions for enterprise clients.

Key projects included:

Fairfield University – Lead Data & Analytics Consultant

Nov 2024 – Jan 2025

Migration to Workday Higher Education Software & Student Information Systems.

In collaboration with the client, we designed a Snowflake-based Lakehouse that integrates Workday, Banner, Raiser's Edge, and Slate.

Automated ingestion of over 60 Workday tables and archived more than 6,900 legacy tables.

Developed secure Power BI dashboards; implemented CI/CD.

Tech: Oracle, Snowflake, SQL Server, Informatica IDMC & CDGC, GitHub, Banner, Workday.

Outcome: Enhanced reporting accuracy and governed data access.

KPMG – Lead Designer & Data Architect

Oct 2024 – Nov 2024

Qlik to Power BI Migration and Enhancements.

Built a Power BI role-based access framework with dynamic RLS.

Migrated 23+ Qlik reports to Power BI; reduced load times by 40%.

Tech: Power BI, Snowflake, SQL Server, Azure Active Directory.

Outcome: Delivered scalable, secure reporting with improved user experience.

MultiPlan – Principal Data & Analytics Consultant

Aug 2024 – Sept 2024

Informatica Secured Data Provisioning and Marketplace.

Served as Project Manager, planning and initiating the project.

Tech: Informatica (Mass Ingestion, Marketplace, CDI), Snowflake, Databricks.

Outcome: Delivered scalable, secure reporting with improved user experience.

Blueprint Medicines – Principal Data & Analytics Consultant

Jun 2024 – Aug 2024

New Drug Launch: Scalable Analytics Data Model, Optimized Data Integration & Processing, Enhanced Business Intelligence & Reporting.

Developed Snowflake model and Power BI semantic layer.

Automated ingestion; built three data models and 12 tables.

Tech: Snowflake, Fivetran, dbt, Power BI.

Outcome: Enabled real-time KPI visibility for distribution across European markets.

Ethos Veterinary Health – Principal Data & Analytics Consultant

Jan 2024 – Jun 2024

Onboard NVA (National Veterinary Associates).

Built a scalable ingestion system for 100 hospitals, improving data reliability.

Delivered operational dashboards and regional revenue tracking.

Tech: MySQL, Snowflake, dbt, ADF, Power BI, Power Automate, Power Apps, Azure Storage, Azure Batch, Python.

Outcome: Unified analytics and streamlined financial oversight.

Ethos Veterinary Health – Lead Consultant

Oct 2022 – Sep 2023

Built a scalable Enterprise Level Data Warehouse system for 15 hospitals, improving data reliability.

Automated NetSuite revenue and ADP payroll processes.

Standardized governance across multiple systems.

Tech: MySQL, Snowflake, dbt, Power BI, NetSuite, ADP, Power Automate, Power Apps, Azure Storage, Azure Batch, Python.

Outcome: Reduced costs, improved data-driven operations.

Baylor College of Medicine – Lead Data & Analytics Consultant

Oct 2022 – Sep 2023

Led the implementation of the IICS Data Hub, incorporating API integrations for Press Ganey and MedHub.

Delivered audit-ready pipelines and curated repositories.

Tech: Informatica IICS (CDI, CAI), SQL Server, MedHub API, Press Ganey, Azure, Secure Agent, SAP Hanna.

Outcome: Delivered a Data Hub framework and enhanced governance, resulting in a 60% reduction in survey processing time.

Cognizant – Data Analytics and Architect Leader

Sep 2019 – Jun 2022

Spearheaded strategic business intelligence and analytics initiatives across multiple Fortune 500 clients.

Key projects included:

oPutnam Investments (Dec 2021 – Jun 2022) – BI Reporting Expert and Architect: Led the development of MicroStrategy and AWS Redshift strategies.

oRJ Reynolds (Jun 2021 – Dec 2021) – BI Lead: Oversaw trade marketing reporting and team mentoring.

oKeyBank (Nov 2020 – May 2021) – BI Consultant: Upgraded MicroStrategy and stabilized the platform.

oAvangrid (Apr 2020 – Nov 2020) – QA and Reporting Lead: Delivered QA and reporting for Big Data project.

oMiscellaneous (Jan 2020 – Mar 2020) – Internal projects.

oUBS (Nov 2019 – Dec 2019) – Big Data Architect: Resolved ETL performance issues.

oBarclays (Sept 2019 – Nov 2019) – MicroStrategy Architect: Migrated reporting to Dossiers with Hadoop integration.

Tech: MicroStrategy, Snowflake, Hadoop, AWS Redshift, Amazon Athena, Spark SQL, Python

Outcome: Delivered stable, scalable enterprise BI environments.

Dynamic Computer Consultants — Founder & Principal Consultant

Jan 2016 – Aug 2019

Sompo International (May 2019 – Aug 2019) – Senior MicroStrategy Architect: Consolidated systems into SQL Server Data Mart.

Situs Inc. (Nov 2018 - Dec 2018) – Senior Architect Consultant: Designed MicroStrategy reports and dashboards.

Audible (Amazon) (April 2018 – Oct 2018) – Report Developer Consultant: Migrated data to AWS Redshift; built dashboards.

Citibank (Mar 2016 – Jan 2018) – Lead Reporting Consultant: Directed enterprise reporting strategy.

Coach (Jan 2016 – Mar 2016) – Senior Mobile BI Consultant: Delivered executive-facing mobile BI solutions.

Tech: MicroStrategy, SQL Server, AWS Redshift.

Outcome: Empowered self-service analytics and modernized BI platforms.

Wyndham Hotel Group – Manager, BI Development

Sep 2012 – Nov 2015

Led MicroStrategy BI development for 25–50 projects.

Delivered mobile and dashboard solutions aligned to strategic KPIs.

Tech: Oracle, MicroStrategy.

Outcome: Enhanced visibility into enterprise performance.

Software By Design – Senior BI Architect

Jul 2010 – Sep 2012

Delivered MicroStrategy implementations for enterprises.

Led the development, training, and implementation of dashboard solutions, including change management.

Tech: MicroStrategy, SQL Server.

Outcome: Strengthened reporting maturity and user adoption.

AIG Enterprise Risk Management – Senior DBA

Jul 2007 – Jul 2010

Managed Oracle/SQL Server SDLC; led SOX compliance initiatives.

Directed DBA teams and automated environment deployments.

Tech: Oracle, SQL Server.

Outcome: Improved deployment speed and compliance.

CommonHealth – Business Intelligence Analyst

Aug 2005 – May 2007

Improved ETL reliability and reduced load time by 62%.

Introduced CDC methods and upgraded platforms.

Maintained MicroStrategy reporting.

Tech: SQL Server, DataStage, MicroStrategy.

Outcome: Boosted pipeline efficiency and data quality.

Fisher Chemical – Data Warehouse Administrator

Apr 2003 – Jul 2005

Led BI architecture, system security, and LIMS upgrades.

Delivered backup, recovery, and performance tuning services.

Tech: Oracle, SQL Server, IBM AIX.

Outcome: Improved availability and resiliency.

Organon USA – Project Manager, DW Development

Apr 1999 – Mar 2003

Led compliant data warehouse development.

Oversaw project planning, design, development, and testing.

Tech: Oracle, SQL Server, UNIX.

Outcome: Enabled timely access to sales and marketing intelligence.

Education

Montclair State University – B.S. in Computer Science and Mathematics (Dean's List)

Technical Skills

Databases: Snowflake, SQL Server, Oracle, PostgreSQL, MySQL, Sybase, AWS Redshift, Amazon Athena

ETL/ELT: Informatica IDMC/CDI/CAI, dbt, ADF, Fivetran, DataStage

BI Tools: Power BI, MicroStrategy, Cognos, Tableau

Automation: Power Automate, Power Apps

Languages: SQL, PL/SQL, Python, Scala

Cloud Platforms: Azure, AWS, Azure Batch, Azure Storage

Big Data: Hadoop, Hive, Spark SQL, Cloudera

DevOps: GitHub, CI/CD

Certifications

Snowflake – SnowPro Core Certified (2024)

Informatica – CDGC & CDMP Certified (2024)

Fivetran – Certified Technical Partner (2024)

Oracle – OCA Certified

MicroStrategy – Certified Engineering Principal (MCEP), Mobile Bootcamp Graduate

AI Generalist - Generative AI Masterminds INTL (2025)

Contact this candidate