Open to opportunities

Johan Peralta

@johanperalta

Data Architect with 20+ years designing governed data platforms, scalable models, and BI products for measurable business impact.

United States

Message

What I'm looking for

I’m looking to enable teams and stakeholders with trusted, well-governed, strategically aligned data capabilities—building scalable architectures, reliable pipelines, and BI products that improve decision quality and accelerate time-to-insight.

I am a Data Architect with over 20 years of experience delivering data solutions that drive measurable business outcomes. I design scalable data architectures, models, and analytics ecosystems that improve decision quality, accelerate time-to-insight, and reduce operational friction.

In recent work, I led Microsoft Fabric adoption and Power BI reporting modernization, built automated pipelines consolidating enterprise inputs, and migrated solutions from SQL Server to PostgreSQL in MS Fabric to improve scalability and performance. I also strengthen data governance and KPI standardization, and I apply generative AI platforms (Copilot, ChatGPT, Gemini, Claude, Perplexity) to streamline data modeling, accelerate architecture documentation, and enhance metadata management and AI-assisted decision frameworks.

Experience

Work history, roles, and key accomplishments

Senior Data Architect

Child Mind Institute

Nov 2023 - Feb 2026 (2 years 3 months)

Led enterprise data engineering initiatives, including Microsoft Fabric adoption and Power BI reporting modernization across multiple sources. Built automated data pipelines and improved governance by standardizing auditable KPIs, and migrated SQL Server solutions to PostgreSQL in Microsoft Fabric for better scalability and performance.

Microsoft Fabric Power BI DAX AWS Azure Data Governance PostgreSQL ETL ELT

Data Architect & Engineer

Kyndryl

Sep 2021 - Apr 2023 (1 year 7 months)

Contributed to Kyndryl Internal Audit’s data lake implementation on Azure and supported Collibra for data governance and management, including metadata loading, lineage, and business glossary setup. Migrated IBM Internal Audit BI applications to Azure and redesigned Supplier Compliance Audit workflows to cut execution time from 2 weeks to under 5 minutes.

Microsoft Azure Collibra Power BI DAX Data Governance Data Modeling ETL ELT Data Integration

Data Architect & Modeler

IBM

Feb 2010 - Aug 2021 (11 years 6 months)

Developed enterprise data models and information lifecycle management strategy for IBM Internal Audit, including data strategy and architectural guidelines for cloud adoption. Provided architecture, design, and proof of concept for data pipelines to ingest into IBM cloud environments and operated the IBM Financial Crimes Insight application to detect high-risk transactions.

IBM Infosphere MDM Enterprise Data Modeling Data Cataloging Data Lifecycle Management Data Pipelines Proof of Concept IBM Financial Crimes Insight Database Architecture Data Strategy

Database Architect & Modeler

IBM

Jun 2008 - Jan 2010 (1 year 7 months)

Led IBM SDM Application Operational Data Store design for BI reporting and analytics, including OLAP logical data modeling and logical/physical model development. Built data integration workflows for dimensional reporting and contributed to ETL design and operations, while mentoring junior data management team members.

OLAP Data Integration ETL Dimensional Reporting Database Architecture Data Modeling BI Reporting SDLC Query Performance Inputs

Data Architect (Datamart)

IBM

Nov 2003 - May 2008 (4 years 6 months)

Led IBM GBS North America Datamart consolidation, supporting data gathering, staging, and management for business applications and reporting metrics. Performed data modeling and database design reviews, created logical/physical models in IBM Rational Data Architect, and developed data transformations using PL/SQL, stored procedures, and user-defined functions.

Data Modeling Pl SQL Stored Procedures User Defined Functions