Data Project

Andrew S. Wallace

** ************ **. ******** ** 07737 ● 732-***-****

*******@*****.*** ● https://www.linkedin.com/in/andrewswallace

Selected Highlights

Accomplished technologist with experience in Architecture and Development on a broad range of Data Warehousing and OLTP applications.

Extensive experience in the Financial Services Industry. Business knowledge of Global Financial Institutions, Hedge Funds, Major Exchanges, and Market Data.

Proven track record in Project Management, including planning, prioritization, and adherence to time lines with a demonstrated ability to bring in projects on-time and within budget.

Expert in the architectural design and execution of Enterprise Data Warehouses and Data Marts utilizing the Kimball or Inman methodologies.

Expert level PL/SQL development.

Deep experience collecting requirements for Data Warehousing, Business Intelligence, Master Data Management and online transaction processing.

Expert level knowledge in the area of database technology on a wide range of platforms. With a particular focus on Oracle Data Warehouse features, performance tuning, and architecture.

Thorough understanding how to provide horizontal or vertical scalability in the ETL, Database and Reporting infrastructure. Conceptual understanding of MPP and Columnar databases.

Demonstrated abilities in the design and implementation of complex Extract, Transform and Load (ETL) programs using technology from Informatica, Oracle and Tibco.

Responsible for delivery of Cognos Business Intelligence including dashboards and reporting.

Capabilities include Database Architect, Data Warehouse Architect, relational and dimensional data modeler, and application programmer.

Strong knowledge of requirements definition and facilitation. Proficiency in data analysis with the ability to summarize impacts of findings.

Experience with full system development life cycle of data warehouse and enterprise-level OLTP projects.

Areas of Expertise

Logical & Physical Data Modeling Database Architecture Data Migrations

Database Design/Administration Database Development Database Conversions

Extract Transform & Load (ETL) Performance Tuning Database Platform Selection

Oracle PL/SQL Oracle Replication Oracle High Availability

Oracle Certified Professional (OCP) Oracle Enterprise Manager Informatica

Oracle Exadata Trading systems TOAD

Technical Summary

Oracle Exadata, Enterprise RDBMS v 5 - 11g, Sybase ASE 11.9.2 - 12.5 (2002), MS SQL

Informatica, Oracle Warehouse Builder,

ERWin, ER/Studio, Rational Rose, Visio, Toad, SQL*Plus.

Oracle PL/SQL, Sybase Transact-SQL(2003)

Red Hat Linux, Windows: XP Unix: Sun Solaris, HP-UX (2000), Tibco

Cognos 8.4 Business Intelligence, Report Studio, Query Studio and administration.

Microsoft Project and Office tools.

Professional Summary

UBS 01/2010 – Present

Sr. Data Warehouse Consultant

ARisk is the firm wide Risk Aggregation platform providing a global view of all market risk of at UBS. Loads exceeding 4 billion rows a day from 30 plus systems feed a 200TB Oracle database.

Performed the architectural review of current state and provided a road map and implementation plan for the next generation architecture. Analysis included enumerating possible architectures and the evaluation of the future state.

Redesigned the ETL workflow of the risk fact table to achieve a performance improvement from a baseline throughput of 5 thousand rows per second to 250 thousand rows per second with current volumes at 100 million per second.

Improving data extraction rates from 500 thousand rows per second with the existing platform to a proven capacity of 32 million per second on the new linux platform.

Architected and migrated ARisk twice first from solaris to linux and then to Oracle Exadata.

Responsible for design and development of the event driven automation of Data Readiness. The state of loads from various front-office systems is translated immediately into nodes in the business hierarchy ready for reporting and downstream processing.

Extended the readiness functionality with JMS messaging from within the database.

Responsible for partitioning strategy and development of all database housekeeping facilities. Including creating, compressing and dropping partitions, data retention, and maintenance of statistics.

Highbridge Capital Management 2/2008 – 10/2009

VP Data Warehousing and Business Intelligence

Responsible for delivery of Data Warehouse and Business Intelligence Solutions at Highbridge.

Subject areas built include General ledger, financing, trading events, risk metrics, market data, golden copy security master, and pricing.

Managed the design and construction of a Kimball style Enterprise Data Warehouse using Informatica for ETL and Oracle RAC for the database. Staging and integration layers were used to populate the star schema and conformed dimensions.

The solution leveraged Change Data Capture to provide near real time Data Warehousing.

Initiated the Business Intelligence Enterprise reporting initiative. Performed product evaluations and implemented Cognos. Managed requirements gathering and implementation of report and dashboard development.

Provided Platform Selection, Governance Procedures, Best Practices and Standards.

Solid experience in team leadership and project management. Managed a team of eight including project planning, performance reviews and career development.

American Stock Exchange 5/2007 – 2/2008

Data Warehouse Director

Directed the architecture and construction of the AMEX Enterprise Data Warehouse (EDW) of all trading activity for all exchanges in the Equities and Options markets.

Provided Project Management and Information Architecture strategy for Regulatory & Surveillance.

Managed Oracle and Informatica resources in the analysis, development and production support of the Enterprise Data Warehouse.

Decreased data loading latency of consolidated quotes from delayed batch mode to near real-time loading.

Drawing upon deep practical experience provided thought leadership in the form of standards and application of templates in the areas of standard documentation methods, process diagrams, ETL mappings, logical and physical enterprise data modeling, and meta data management.

Analyzed business requirements through interaction with AMEX and NASD / FINRA users, business process analysis and workflow analysis with the end goal of articulating the requirements in such as way as to lead to technical solutions.

Responsible for technical and project leadership for the development of the Enterprise Data Warehouse for Equity and Options activity for Regulatory & Surveillance.

Created the dimensional data model for exchange traded options quotes from OPRA.

Directed the strategy for slowly changing dimensions and conforming dimensions.

Oversight of ETL performance tuning with the largest load exceeding 3 Billion records per day.

Merrill Lynch – VLDB Consultant 2/2007 - 4/2007

Provided strategic guidance to Merrill Lynch in the selection of a VLDB platform, as part of the Center of Excellence for Very Large Data Base (VLDB) team.

The VLDB platform evaluation included creation of a Request for Proposal (RFP) and scorecard process to quantify how well the database platforms cover all the functional aspects of the client’s data warehouse requirement which included traditional database and database appliance vendors. .

New York Stock Exchange – Sr. Database Architect Consultant 4/2006 - 12/2006

As part of the Enterprise Architecture Group, participated in all phases from design to implementation of the Corporate Information Factory (CIF) project. An Oracle Data Warehouse of post-trade activity from the various NYSE real-time systems.

Achieved high-speed data loading of real-time exchange activity data into the CIF, for surveillance, research and capacity planning. Instrumental in the turnaround of the project, and the mainframe was shut down on schedule with a cost savings of over $5 million.

Designed and coded the ETL infrastructure to load the System Order Database, Consolidated Quotes and Trades and others into the CIF, a combined daily load of 600 Million rows or 150 GB per day, with a total database size of about 100TB. All jobs run within 1 hour utilizing the grid architecture with Oracle 10G RAC on Red Hat Enterprise Linux.

Gather and analyze trading related data to make sure there is sufficient system infrastructure and capacity to support daily trading and trend analysis.

Main technology features utilized include Oracle partitioned tables, external tables, Advanced PL/SQL, Real Application Clusters, Red Hat Linux, and k-shell.

Delta Dental Insurance - Senior Database Consultant 8/2003 - 3/2006

Leverage the most up to date Oracle features where appropriate in the development of a Health care Insurance Claims system.

Develop ETL and integration processes using: Oracle Warehouse Builder, and custom PL/SQL to Extract Transform and Load legacy data into the operational data store and Data Warehouse.

Support development and object-relational mapping for persistent objects with TopLink.

Raised productivity and quality by generating a PL/SQL Data Access Object layer in PL/SQL.

Adopt Open Source design patterns and utilities such as PLDoc, log4PL/SQL and utPLSQL in the interest of producing quality code.

Utilize Oracle Streams, Change Data Capture and Log Miner for data integration solutions.

Application development using HTML DB and Oracle Web Agent (mod_plsql) and XML DB.

Rational Unified Process utilized in the project lifecycle. Rational Rose is used for Object modeling, and ClearCase and ClearQuest for UCM.

Logical and Physical Database modeling accomplished using ERWin and Rational Rose.

Completed database migrations from Oracle8i to Oracle9i.

Participate in analysis, design and review of Use Cases and business requirements.

Reuters - Senior Database Architect 2/2002 - 8/2003

Responsible for Database activities for the New York office for requirements internal and external to Reuters. Providing database architecture, development and administration in the design and implementation of business solutions.

Architect High Availability, Standby and Failsafe databases, Import/Export and Unix Scripting for various Wall Street clients.

FlowBiz Project: Responsible for the Rendezvous Persistence Architecture of an enterprise web trading platform developed for JP Morgan/Chase. Provide Database expertise throughout including: Database Architecture, logical and physical database design, Tibco Active Database configuration, database, table and stored procedure creation.

Performed migrations from Sybase to Oracle and Oracle to Sybase using the Oracle Migration Workbench and manually.

Used Tibco BusinessWorks for Extraction Transformation and Load (ETL) of data warehouses.

Tibco Finance Technologies Inc. - Senior Database Architect Consultant 12/1998 - 2/2002

MCM Contribution Server Project: Developed and supported a real time market news contribution system. Solution included Oracle Advanced Replication and CLOB data indexed for searches, using the Context Option.

BARS Project: Participated in the development phase of a Booth Automated Routing System for the American Stock Exchange/SIAC that was to be based the TIB/Exchange product.

Leveraged knowledge of Oracle and Sybase internals for Performance Tuning.

Database cloning for creation of development environments and migrations.

Merrill Lynch & Co. - Senior Systems Consultant 09/1995 - 12/1998

Systems Development for Merrill Lynch Defined Asset Funds. The Portfolio Management system of equity and fixed income Mutual funds and a Decision Support data mart.

Database administration and capacity planning responsibilities for Oracle and SQL Server on Sequent Unix and Windows NT. Physical data modeling using ERwin.

Designed, implemented and supported an inter-company database environment using an Oracle Distributed database, Oracle Replication and Connection Manager.

Data Warehousing / ETL with Platinum InfoPump scripts for scheduled data transformation.

Developed Asynchronous PL/SQL execution facility using DBMS_PIPE package similar to Advanced Queuing.

Created facility for generation of PL/SQL Packages for encapsulation of DML on 400 tables.

AT&T - Database Consultant 09/1994 - 09/1995

Performed as Oracle Database Administrator on multiple projects, including physical and logical data modeling with ERWin, PL/SQL, performance tuning, disaster recovery.

Church & Dwight Inc. - Database Consultant 09/1993 - 09/1994

As Database Administrator, designed and developed decision support databases on HP/UX for Arm & Hammer Sales and Marketing division.

United Parcel Service – Sr. Programmer Analyst 12/1990 - 09/1993

Application development and analysis of performance issues in a client/server environment including: SQL optimization, OS/2 Database Manager (DB2/2).

Prudential Insurance - Programmer Analyst 09/1987 - 12/1990

Oracle Database application development for Decision support and batch processing for Insurance and investment services projects.

Education

Stevens Institute of Technology, Hoboken, NJ

Master of Science ● Management Information Systems

Fordham University, Bronx, NY

Bachelor of Science ● Computer Science

Contact this candidate