Jeff Gamiao

Led the design, implementation, and integration of Power BI, Fabric, Salesforce, and DocuSign. Built ingestion/transformation/storage monitoring and implemented BI governance with RLS/OLS and automated refresh/reporting workflows.

Migrated SSIS packages to Azure Data Factory, implementing ETL pipeline development and monitoring. Applied Upsert and Medallion Architecture (Bronze/Silver/Gold) using a self-hosted integration runtime and optimized performance for reliability and cost.

Developed Power BI tracking reports/dashboards and implemented administration, security, and governance including tenant configuration, refresh controls, and data masking. Managed connectivity/refresh issue resolutions and supported data source administration across BI and data platforms with GDPR-aligned documentation and cutover planning.

Provided Power Platform project planning/roadmaps and implemented end-to-end Power BI (desktop, query, embedded/builder, service, gateway, and REST API). Built and migrated KPIs and dashboards, including SAP data preparation/migration and BI governance features such as incremental refresh, security, masking, and deployment pipelines.

Provided consulting as a Data Analyst/Engineer with Power Platform, DocuSign, and Salesforce support for multiple local and international clients.

Administered Salesforce CRM/CRM Analytics and built automation using Apex, flows, and OmniStudio components. Implemented DocuSign e-detailing integrations aligned with CFR Part 11 and delivered recurring KPI reporting dashboards across Salesforce, Tableau, Power BI, and Qlik.

Monitored and analyzed client impact to Omgeo/DTCC software application availability and performed incident risk management with RCA and post-mortems. Built downtime analytics and automated report metrics while supporting SIEM deployments and ETL/data visualization from on-prem and cloud sources.

Managed post-trade SSI projects for cross-border and non-U.S. securities and FX cash transactions while maintaining data quality, privacy protection, and regulatory compliance. Produced recurring BI dashboards/visualizations and supported risk, data migration, automation, and client onboarding workflows.

Provided client-facing desktop application support and supported SAP data migration via remote installation. Managed application cutovers and deployments across test/production/DR, coordinated UAT, and performed live trade data migration and post-issue escalations with supporting documentation.

Performed POS quality assurance using regression testing and Selenium. Reviewed and modified test scripts based on test case specifications and converted test-case documents into RTT test scripts while documenting errors.

Supported HR and SAP legacy data migration cutover activities, including normalization, modeling, and database design work. Ensured confidentiality and continued testing and monitoring as the migration was expanded to multiple brands.

Completed a minor in Management as part of the Bachelor in Commercial Science program from 2000 to 2001.

Completed a Bachelor in Commercial Science with a major in Computer Science from 1994 to 1998.