Requests
0
0
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
SHAZAM Network - ITS, Inc.Data Architect
Feb. 2024 - May. 2026• Perform analysis of current EFT warehouse based on DMBOK-V2.0 Knowledge areas. Convert results into DMM maturity scores and recommend adjustments for next phase into an Enterprise Model.
• POC Azure Data Factory ETL pipeline development.
• POC Azure Fabric analytics pipeline.
• Data Governance (Team Lead / Primary Architect / Lead Architect) DMBOK-2.0 Standard and Non-Invasive Data Governance Techniques
o Build a corporate business Taxonomy using Ovaledge mapped to various data sources such as Core Data Systems
o Involved in the architecture surrounding the implementation of Purview for Data Classification and Data Protection.
o Build an ETL pipeline using SSIS which maps data from Bank Core Data transactional data in iSeries to an Enterprise Data Warehouse located in mySQL which merges multiple banks’ data into an integrated schema.
o Build a Star Schema EDW using Kimball methodology using DBSchema and DBeaver for the iSeries schema with Type-2 dimensions.
o Build Data Quality pipeline from source transactional to EDW including data cleansing methods in SSIS for data consistency, conforming, and timeliness.
o Build a set of PowerBI analytical reports which perform descriptive analytics for both the above Data Quality component and the EDW.
• SharePoint Online (Team Lead / Primary Architect / Lead Architect)
o Build a set of PowerAutomate workflows for Risk Management which
Migrate transactional list data into a conformed normalized data model in SQL Server
Build a series of workflows which, supported by various PowerApp forms, allow multiple business units (54) to perform yearly risk reviews and synchronize and calculate risk ratings calculations into a Master SharePoint list.
Allow management to automate Architecture Review Board meetings along with automation into Outlook and Teams.
Build a system of workflows which manage Project data for the Shazam PMO, producing list and library data for use in the PMO SharePoint Hub.
Build a set of workflows which move archived on-prem documents from multi-site libraries into SharePoint online PMO libraries, including the implementation of the Shazam corporate records management policy for document archival and deletion.
• Lead training for the Architecture team in basic principals of Database design based on the curriculum from my UCSD course, recorded for Shazam community at large.
• Microsoft certification Azure Data Fundamentals 2025
• Training on using Graph databases (Neo4J/AuraDB) to build more efficient paths for internal AI connections using CoPilot.
County of San DiegoSr. Data Architect
Dec. 2019 - Jan. 2024Greater San Diego Area• SRSP (Shallow Rent Subsidy Program) using predictive analytics (see below) to determine which customers are most at risk of becoming homeless, in order to subsidize their monthly rent.
• Bring Data Quality Profile activity into PowerBI for analytics against Data Quality Profile KPIs.
• Produce IDQ Informatica Data Quality Scorecards to notify when profile metrics exceed thresholds.
• Hook to various public web services in PowerBI to profile USPS address validation, email sending capability, etc.
o Introduce DG to a newly formed DG Committee, establishing a Vision Statement, Measurable Goals, Structure (Working Groups, Data Stewards, etc.), and initial DG Policies in the following DMBOK Wheel areas:
Data Quality (Dimensions: Completeness, Consistency, Integrity) using DQAF (Data Quality Analytics Framework)
Master Data (IBM MDM tool)
Data Modeling (Mega Hopex)
Data Analytics
Predictive Analytics
• Use SPSS Modeler and SPSS Statistics to build and test various predictive models (Random Trees, CHAID, A/S Tree, Bayes Network, etc.) to predict Homelessness in our customer base using various demographic and program participation independent variables as well as aggregate features and BINs built from base features.
• Use SPSS Analytics and SPSS Modeler to bring results of above models to create a weighted mean Risk Rating for Homelessness, then bring this feature and various demographic features into Kmeans and TwoStep-AS clustering model to create important demographic clusters of 55+ customers with high risk (Mean Risk Rating + 1 STD) of homelessness.
• Push above SPSS results into PowerBI to offer “What If” prescriptive analytics to determine probabilities of Homelessness based on demographic categories (location, mean median monthly income, etc.).
• Design SharePoint lists for Project Closure documents from DocVault, created a PowerApp to enter and validate data mined from the documents, and visualized generated KPIs via PowerBI.
Fairfield ResidentialSr. Data Manager
Jun. 2016 - Nov. 20195510 Morehouse Drive, Suite 200 │ San Diego, CA 92121Lead a team of database developers, dbas, and SharePoint Developers.
DAMA-DMBOK Data Governance Expertise
Data Architect specializing in building layered data platforms from Transactional to Semantic to Analytics.
SharePoint Migration Expert.
Union BankSharePoint/BI Architect Vice President
Aug. 2012 - Apr. 2016San DiegoSharePoint 2010 / 2013; InfoPath; Workflow; PerformancePoint; PowerView; MS BI Stack (SSRS, SSAS, SSIS), SQL Server 2008 R2 / 2012, vb .net back code solutions for InfoPath data entry SharePoint sites. Fed sc. A and B data validation systems. SharePoint integration with LPS loan origination and servicing software systems.
SharePoint360Business Intelligence Architect
Aug. 2011 - Jun. 2012Downtown San Diego• Multiple installations and implementations of SharePoint 2010 Farms, covering all areas including BI (SSRS and PerformancePoint), BCS to SharePoint charts and dashboards, workflow, database to list integration via SSIS, SSRS using SharePoint integrated mode, etc.
• Expertise in connecting Oracle Primavera Contract Management (CM13) and Project Scheduler (P6) to SharePoint for use in Project Management and Contract Management dashboards
University Of California San Diego ExtensionAdjunct Faculty
Apr. 2011 - Feb. 2015Data Design and Modeling
Prometheus Labs, IncData Warehouse Architect (Consultant)
Sep. 2010 - Apr. 2011Build multiple SSIS packages for ETL to various layers of ODS and Data Warehouse.
Consultant on designs for both ODS model and Star Schema warehouse models.
Design Object model, logical model, and physical model for a metamodel based on the SSIS object model which will be used to map SSIS metadata to relational data sources. The intent is to use this metadata to auto-generate SSIS packages using pre-defined patterns for ODS and data warehouse data integration.
ICW Group, IncEnterprise Data Architect
Jan. 2008 - Aug. 2010Lead a team of Data Architects, DBAs, and SQL Developers
Designed and built a multi-tiered data platform which included OLTP databases, OLAP data warehouses, and an Enterprise Operational Datastore SQL Server 2005/2008. This ODS (XboX) was built using the ACORD 1.13.0 standard data model for Property, Casualty, and Surety. ER Studio 9.x
Certified in ACORD insurance standard as an ACORD Certified Expert. This includes certification by the AICPCU in insurance industry knowledge for IT.
Designed an enterprise conceptual information model in UML 2.1 for ICW insurance lines of business, which include Auto, Workers' Compensation, Surety, and Special Properties. Mapped the conceptual model for WC to the logical model for the ACORD ODS. Enterprise Architect 7.5
Responsible for building a taxonomy for ICW insurance terms used by the Enterprise Conceptual model. Enterprise Architect 7.5
Designed stored procedure interface to and from the ACORD ODS for use by an enterprise Cloud service layer written in Java running on Tomcat on a mainframe Linux partition. SQL Management Studio / TOAD for SQL Server
Designed and coded various SSIS packages which accomplished multiple tasks:
Implemented replication of a 60GB transactional database using a hub-spoke architecture, eliminating SQL Server data replication.
Integrated transactional data from Policy Management System into ODS for use by historical data conversion processes.
Validated transactional data extracts from Claims Management System, transformed said data using various data cleansing algorithms.
Validated data transformation load data prior to loading into SAP Billing, Account Balance, and Claims systems for new SAP implementation.
Data integration packages to-from mainframe and hybrid ODS.
Responsible for in-house data architecture Wiki content.
Consultant to Enterprise Information team for Business Objects reports against their Auto Data Mart and Enterprise Data Warehouse.
Prescription SolutionManager - Data Warehouse Team
Jan. 2007 - Jan. 2008Lead a team of Data Architects, DBAs, and ETL Developers
Design and build a 3 terabyte traditional data warehouse consisting of Staging, ODS, and DW, and Data Mart environments.
Establish design, development, and configuration standards.
Support existing data mart development via Informatica ETL and logical/physical designs.
Coordinate in-house team with off-shore development team.
Design standards for SOX compliance for DW and ancillary systems. Tools used for this project include ER/Studio, ISeries Navigator, Informatica 8.1 Powercenter and PowerExchange, and DB2 V5 R3 on as/400 iSeries.
PfizerSenior Information Architect
Jun. 2003 - Mar. 2006Managed team of 8 - 10 developers, testers, and technical writers with annual budget of $500K.
Provided development and implementation of local applications for Discovery and Pharm. Sci. Provided implementation of global products. My responsibilities included designing and implementing the data models for persistent storage necessary for each of these systems. These applications included:
Automated dry compound archive management system.
Major server consolidation project from Agouron to Pfizer
Automated Pharm. Sci.laboratory information system.
Global validated LIMS system using Labware LIMS.
Member of global team which produced a global set of best-practice standards for an Informatics Operating Model. Lead a sub-team which has improved and trained local groups on this model.
Led local team to promote best-practice standards for development group within site informatics.
Primary database analyst for global data warehouse downstream applications project.
Implemented an informatics portfolio management tracking system in Excel and VBA for use by local La Jolla informatics management team.
Intch is a Professional Networking App for the Future of WorkSee more people like Steve on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
1027651 people
17
Application Developer @ Nile27
16
Manager Solution Consulting @ Alkami Technology
16
Program Manager @ DISH Network
114241 people
19
Manager @ Epic Force
27
It person @ Texas Systems Admin
17
Marketing Director