IBM DB2 Universal Database development and administration with DataStage ETL integration and stored procedure development — extensive project experience at Wells Fargo.
Senior DataStage/DB2 UDB developer with Wells Fargo bank and mortgage Enterprise Data Warehouse divisions. ETL developed from OS/390 mainframe source, SQL Server and Oracle sources. Warehouse and data mart development performed in DataStage for Financial Data Mart (FDM), You Owe Me (YOM) Oracle store consisting of 62 transaction based tables, and Timer Operational (TO) SQL Server based store development.
Development of multiple UDB user defined functions and stored procedures used in the support of the data warehouse daily/monthly ETL build process. This is significant in the UDB environment given the complex method IBM has implemented for user defined and stored procedures.
Development of numerous Visual Basic applications interfacing Microsoft Access metadata to UDB. The interfaces allow business users to define, view and update metadata related to range and dimension tables. Actions within the Visual Basic interfaces directly affect (per user action) the UDB environment.
Lead developer in the implementation of an ETL application for mortgage related servicing warehouse. ETL of a single fact table, 52 aggregate tables, 24 range tables and 216 dimension tables. Servicing environment updated on a monthly basis building approximately 120 Gigabytes in 7 hours. ETL application has been in production for nearly 2 years, with full history consuming approximately 1.7 Terabytes of space.
Active Data Warehouse development in Teradata. Warehouse development performed under DataStage and multi-set Teradata tools. Delivery of Shaw loan based origination data through DataStage jobs and compliance base development under Teradata multi-set environment.