Santa Clara University

Sofia University

University of St. Thomas

Cretin-Derham High School

Senior Data Engineer at Nike

Capital One

Senior Data Modeler

Reverse-engineered legacy Informatica PowerCenter 9 and 10 workflows, Oracle objects, Korn shell scripts, SAS load scripts, and Autosys jobs used to integrate product pricing data from SAP R, SAP BW, and SAP HANA into SAS Markdown Optimization.  Documented ETL logic in Confluence.  The project to rebuild this interface based on Snowflake, Python, and Airflow was canceled, so I was reassigned to other teams to perform maintenance programming in Java and Python.

Nike

Senior Data Engineer

Provided guidance throughout the implementation of Denodo 8.0 over Netezza and Snowflake data sources for advanced analytics using Tableau and Cognos.  Designed, developed, and tested base views, derived views, and associations.  Mentored junior developers.

Planet Fitness

Responsible for enterprise BI architecture and strategic roadmap.  Designed scalable, robust solutions for development teams, using both on-premise and cloud-based technologies. Reviewed software designs and program code.  Mentored junior personnel in best practices and proper design. Authored standards and guidelines for Informatica ETL development and design. Defined corporate standard for naming data objects.  
•	Using AWS and Denodo virtualization, designed and developed a cross-platform metadata monitoring system to identify technical debt in the proprietary system tables of Oracle, SQL Server, and Informatica implementations.
•	Spearheaded the implementation of GitHub Enterprise to replace Perforce.
•	Created and maintained enterprise data model.
•	Designed and developed a sophisticated synthetic data system capable of producing realistic data sets for customers, products, orders, etc. with local language awareness and no PII.
•	Designed and built GDPR database for tracking sensitive enterprise data elements.
•	Designed web service-based integrations between enterprise applications, including ServiceNow, SAP, and Ariba to enforce GDPR protocols.
•	Performance tuned hundreds of Informatica sessions and optimized existing ETL solutions.
•	Built Python utilities to...
	•	Automate the tuning of Informatica sessions.
	•	Automate the deletion of outdated deployment groups in Informatica.
	•	Actively monitor QlikView jobs to identify failures and long-running tasks, then raise an alert in ServiceNow when necessary.  
•	Designed and implemented secure, web-enabled canonical views over enterprise application databases (e.g., SAP ECC, RevPro, enterprise data warehouse) to assist users in troubleshooting data lineage problems.

Autodesk

Data Architect

Developed a proof-of-concept Big Data solution using Hadoop and Hive running in Amazon’s Virtual Private Cloud (VPC).  Generated detailed data models and business process models representing Autodesk’s entitlements programs.

Proposed complete business intelligence architecture (hardware, ETL, DW, BI) for Motorola’s new MOTOBLUR service.  Requirements involved 100s of terabytes of loosely structured data sourced from widely distributed MySQL databases and Java web service logs.  Cloud computing solution design based on Hadoop (HDFS/MapReduce).

Motorola Mobile Devices

Data Warehouse Architect

Designed and implemented operational data store (ODS) and strategic enhancements to VeriSign’s enterprise data warehouse.  Developed implementation plan for upgrading and combining multiple Informatica PowerCenter repositories.
• Consulted with CIO and Enterprise Architect to devise BI roadmap for VeriSign, including software development life cycle (SDLC) policies and procedures, coding standards, and naming conventions.
• Built Oracle 10g ODS integrated with multiple source systems (e.g., Oracle EBS, GeoTrust, ECAS).  In addition to source system-specific objects to support operational reporting, the ODS also provided source-independent, canonical structures to facilitate DW integration and high-level operational reporting.
• Devised and implemented BI aggregation strategy for data warehouse.  Retrofitted data warehouse with conformed dimensions.
• Re-architected legacy Engineering data mart loads (shell scripts, PL/SQL) with Informatica ETL.  Incorporated Engineering data mart objects into EDW.
• Built near-real-time interface between external commerce XML files and Oracle 11i, including Linux Bourne-again shell (BASH) scripts for file-handling, ETL execution, and error-handling.
• Replaced existing PowerCenter 5.1/First Logic customer data cleansing interface with PowerCenter 8.1/Business Objects DQXI.
• In support of VeriSign’s 360º Customer reporting initiative, designed and developed summarized reporting metrics, pre-formatted for dashboard consumption.  Coded Oracle PL/SQL package as an API between summarized reporting tables and web services.
• Programmed Oracle 10g PL/SQL stored procedure to trace Informatica metadata tables (OPBs) to identify and auto-update Sequence Generators based on maximum key values of target tables.
• Identified a low-risk, low-downtime strategy for upgrading and merging three sets of Informatica repositories (i.e., 5.1, 6.1, and 7.1) running on three different platforms (Windows 2000, HP Unix, and Linux) to PowerCenter 8 on Linux.

VeriSign, Inc.

Data Integration Architect, Data Warehouse Architect

Designed and built a Regulatory Services data warehouse in Oracle 9i running on Windows Server 2003.  Project terminated prematurely due to municipal budget cuts.
• Designed logical and physical data models using Microsoft Visio.
• Built star schema-based data warehouse tables.
• Developed Oracle PL/SQL package containing all functions and stored procedures needed to load the data warehouse tables from Kiva source system.
• Built a proof-of-concept Employee Synchronization database as a clearing house for contact details, using Microsoft SQL Server, Transact-SQL stored procedures, and DTS.

City of Minneapolis

Data Warehouse Architect, Data Integration

Performed a variety of technical roles throughout the re-design and re-deployment of Agriliance’s data warehouse (ADW Rev. 5), built with Oracle 9i and Informatica 7.1, running on HP Unix.
•	Reverse-engineered existing ETL code to assess accuracy of legacy specifications.
•	Analyzed JD Edwards database tables to determine optimal strategy for sourcing the warehouse.
•	Analyzed legacy data in support of conversion strategy.
•	Architected daily load strategy (e.g., staging and work tables, slowly changing dimension maintenance, error-handling).
•	Designed, developed, and tested ETL mappings, sessions, and workflows.
•	Coded Oracle PL/SQL stored procedures.

Agriliance

Business Intelligence, Data Integration, Data Analysis

Designed and implemented ETL interfaces to external vendors' data files, for purposes of acquiring loan portfolios and feeding out-sourced applications. Sources and targets included Oracle, Sybase, AS/400 sequential files, VSAM, XML, and Unix flat files.
•	Incorporated Informatica's Velocity methodology and mentored developers using PowerCenter 7.1.1 running on IBM AIX. Interviewed candidates for ETL developer positions.
•	Designed and developed complex transformations capable of processing large volumes of records (e.g., tens of millions) in relatively short processing windows.
•	Interfaced with AS/400 sequential files using PowerConnect/PowerExchange and Oracle Gateway (using views over dblinks), and VSAM files via automated FTP.
•	Wrote Oracle PL/SQL stored procedures, assisted in design of database objects. Interviewed Oracle PL/SQL programmer candidates.
•	Converted complex Perl programs into Informatica mappings.
•	Wrote and maintained Unix shell scripts as "wrappers" for executing Informatica sessions from Autosys scheduler.

Green Tree Servicing

Data Integration, Technical Architecture

Collaborated in proposed design of a complete architecture to migrate a very large data movement and ODS legacy system off of a legacy mainframe system and onto a new Unix platform.
•	Performed thorough technical analysis of existing mainframe system and design requirements (e.g., data volumes, network topology, server capacities, fault tolerance and failover).
•	Negotiated pricing with hardware and software vendors.
•	Proposed multiple design scenarios to client, from which the client selected one.
•	Determined labor costs as well as software and hardware costs for chosen solution (e.g., Informatica vs. Ascential DataStage, Sun vs. IBM).
•	Documented all findings, designs, and cost breakdowns.

Piper Jaffray

Technical Architecture

Provided technical leadership to ETL developers as they undertook their company's first deployment of Informatica and Oracle.
•	Leveraged Informatica's Velocity methodology in setting up an efficient, maintainable, and robust environment for PowerCenter 6.1, running on Windows/NT.
•	Conceptual and logical design of source and target objects and process flows, spanning mainframe IMS files, Oracle 9i tables, Microsoft SQL Server tables, Microsoft Access tables, Microsoft Excel workbooks, and ASCII files.
•	Defined ODBC-readable mainframe sources using Striva's Detail Navigator tool (PowerConnect).
•	Developed Informatica mappings, reusable mapplets, tasks, worklets, workflows, and Oracle PL/SQL stored procedures. 
•	Extensive optimization of mappings and sessions (e.g., proper cache sizing, joiner strategies, placement of filters and sorters) to reduce load times from hours to minutes.
•	Mentored junior developers in employing Informatica best practices.

Securian Financial Group

In support of Thrivent's Investments division, assisted a team of developers in their first implementation of Informatica, populating a new ODS. Also collaborated with the Non-Proprietary group to develop new ETL objects and optimize existing objects.
•	Mentored recent trainees in developing efficient, maintainable, and robust ETL software using PowerCenter 6.2 running on IBM AIX.
•	Designed and developed mappings, sessions, and workflows to move data from a variety of sources (DB2, SQL Server, Pervasive SQL, XML, and flat files) into Thrivent's ODS (DB2 UDB) and Non-Proprietary transactional system (DB2 Mainframe).
•	Extensive optimization of mappings and sessions.
•	Worked closely with Data Management staff to design ODS tables, keys, and indexes; optimize SQL queries; and perform REORGs, RUNSTATS, etc, for optimal database performance.
•	Developed Unix shell script for executing Informatica sessions from Maestro scheduler.

Thrivent Financial

Data Integration

As a member of Best Buy's corporate data warehouse team, designed enterprise-wide business intelligence solutions for retail business performance metrics, including margin enhancement.
•	Conceptual, logical, and physical design of data mart objects to support executive dashboard and performance ranking reports.
•	Integrated new subject areas of data (e.g., DB2, Oracle HR, Clarify, third-party customer surveys) into Best Buy's Oracle 8i data warehouse and enhanced existing data feeds (e.g., Oracle 11i GL).
•	Developed data warehouse objects (e.g., materialized views, dynamic views, PL/SQL procedures).
•	Designed and developed ETL processes using Informatica 5.1.1 and mentored junior ETL developers in Informatica techniques.
•	Designed and developed object-oriented Perl programs for data load and validation routines.   
•	Performed traditional Business Analyst functions for all retail business performance metrics.

Best Buy

Business Intelligence, Data Analysis, Technical Architecture, Data Integration

Worked directly under CIO as a senior consultant assisting with corporate IT technology strategy.
•	Performed comparative analysis of various technology suites (e.g., Oracle and Informatica vs. Microsoft SQL Server and DTS) as corporate standard for decision support projects.
•	Designed and developed a DSS solution based entirely on Microsoft out-of-box functionality: SQL Server 7.0, DTS, OLAP, and web-based PivotTables. 
•	Assisted in implementation of Informatica PowerCenter 4.7 and instructed developers.
•	Provided maintenance programming support for customer-oriented, external web-site using active server pages (ASP)
•	Managed projects and gathered requirements from both IT and Marketing to satisfy customer needs.

AristaSoft Corporation

Technical Architecture, Business Intelligence, Data Integration

Collaborated with SGI's global business intelligence development team to productionalize, enhance, and re-engineer their worldwide revenue data warehouse and data mart. 
•	Reengineered Oracle 8 data warehouse to accommodate Oracle 11i data and unpredictable load intervals.
•	Designed, developed, and performance tuned over 200 ETL mappings using Informatica PowerCenter 4.7. 
•	Designed, developed, and documented a centralized, value-based access control system, providing back-end security for sensitive financial data. Required integration with PeopleSoft system to automatically shut off terminated employees' accesses and determine authorization requirements based on employee's position and function.
•	Designed, developed, and documented a web-based workflow tool to process end user requests for access to highly secured data, using Perl and object-oriented CGI and DBI libraries, seamlessly integrated with client's single sign-on authentication technology.
•	Designed, developed, and supported enhancements to SGI's internal, web-based data mining tool (MYOB), which became the core of E.piphany's Insight product.
•	Influenced and complied with department's standard methodologies for design, development, data validation, testing, and documentation. This included a standard for metadata management in Informatica and Erwin.
•	Participated in evaluation and selection process for corporate standard data modeling tool (Erwin was selected over Embarcadero and System Architect)
•	Analyzed business requirements from International Finance, Manufacturing, and International Sales.
•	Mentored one junior Programmer/Analyst. Participated in all interviews and hiring decisions.

Silicon Graphics

Data Analysis, Technical Architecture, Data Integration

Designed and implemented a generic archive and purge utility for managing retention of data in a variety of component testing databases, serving multiple, around-the-clock manufacturing product lines. 
•	Developed SQL Server 7.0 stored procedures.
•	Coordinated with C++ developer to build generic client software based on ODBC.

JDS Uniphase

Responsible for the analysis and design of a suite of products marketed to the utilities damage prevention industry. Heavy analysis, modeling, and design for both data and processes. 
•	Modeled data requirements, conceptual and logical, for entire one-call center and excavator businesses using PowerDesignor.
•	Introduced and established Zachman Framework as corporate methodology for system development.
•	Project managed and led the analysis and design of a communications server to handle fax, modem, email, and printer transmissions (productized for sale to customers).
•	Developed Transact-SQL stored procedures to manage communications data and interface with Visual Basic front-end via ODBC.
•	Optimized Transact-SQL stored procedure in Microsoft SQL Server 6.5. Later, converted stored procedures to SQL Server 7.0.
•	Developed a corporate standard project management template in Microsoft Project.

Sony Group, Tele Atlas

Technical Architecture, Data Integration

Responsible for defining the data warehousing strategy for SGI, across all business functions and geographies. Directly managed team of project managers, business analysts, and programmers. Contributed heavily to the data modeling and design of data warehouses and reporting architectures.
•	Spearheaded enterprise-wide agreement to define critically needed data warehousing architecture providing consistent and accurate data, drastically lower operational costs, and vastly improved flexibility to SGI's fast-changing business model.
•	Took initiative to convince senior management that data warehousing and decision support were critical to the success of major initiatives, resulting in funding for incremental headcount, hardware, and software.
•	Drove ownership matrix to acceptance. Clearly delineated which organizations bore which costs, creating efficient charge-back model, reducing Corporate expenses, and optimizing divisional IT expenditures.
•	Developed data matrix illustrating which business functions depended on which data for decision support, exposing redundant systems, and revealing areas lacking sufficient reporting capability.
•	Responsible for choosing corporate standard ETL. Selected Informatica PowerCenter over Sagent and D2K after formal evaluation.
•	Responsible for choosing corporate standard RDBMS for DSS projects. Selected Oracle over Sybase and Microsoft SQL Server.
•	Responsible for choosing corporate standard OLAP tool. Selected BusinessObjects over MicroStrategy and Crystal Reports.
•	Led cross-divisional task force to define development standards.
•	Concurrently led program to stabilize and repair costly, inaccurate legacy data warehouse, eliminating half the maintenance staff and reducing on-going bugs from over 80 to 2. Rebuilt all of the international data loads using Perl, Sybase BCP, and Sybase Transact-SQL stored procedures.
•	Project managed, designed, and began development of SGI's new revenue warehouse, using star schema in Oracle 8.

IT Manager, Worldwide Decision Support

Located in Neuchâtel, Switzerland, designed and developed executive information systems for SGI's senior management throughout Europe.
•	Employed Business Process Reengineering methodology to best leverage technology to improve data-rich processes in International Finance, Field Sales, and European Manufacturing.
•	Project managed, designed, and developed globalized version of U.S.-oriented decision support system, enabling web-based, ad hoc revenue reporting by country, area, customer, etc. in local currency. Procured SGI Europe's largest server to support reporting. Heavy BusinessObjects and Sybase development, along with CGI, HTML, and Perl.
•	Created software system to automatically calculate European product content, minimizing tariff liabilities at time of shipment. Heavy Progress 4GL and PostScript development.
•	Designed value-based access control architecture to be used with any decision support system throughout SGI. Used Sybase stored procedures, calling themselves recursively to traverse multiple levels of complex conditions.
•	Designed and built shopfloor module allowing reconfiguration of products at any point in manufacturing process. This C program incorporated both Sybase and Progress libraries to connect concurrently to both types of servers, while periodically refreshing client displays.

European EIS Analyst

Manufacturing: Designed and implemented two quality reporting database applications: U.S. and European Manufacturing.  Both used Sybase back-ends, one used a spreadsheet interface, the other used Perl CGIs to generate dynamic HTML. Contributed to modeling and design of SGI's shopfloor database application for materials and process control, also implemented in Sybase.

Senior Programmer

Corporate IT: Designed and implemented SGI's first internal HelpDesk application, Marketing's software partner database application, and lead-tracking database, all using Sybase, C, and PostScript.

Programming Analyst

Contributed to design and development of Sun's Sales Desk suite of sales automation tools (lead-tracking, quote/config), replacing an Ingres-based system with Sybase. Enhanced sales forecasting software. Built backup automation software with Bourne shell scripts.

Paul Broenen, PhD, MBA