SKILLS SUMMARY
Senior manager with extensive experience in data resource management with consistent growth in managing people, process and technology. Skilled in managing the planning, development and execution of large scale data warehouse environments. Experienced in technical aspects of data administration including logical and physical data modeling, data flow and database administration; as well as non-technical aspects such as global personnel, budget, outsourcing and project management.
EMPLOYMENT
January 2006-Current
Managed a team of highly skilled database professionals and outsource contractors in support of 1TB+ data warehousing environment. This platform underlies the core web based client reporting portal for one of the largest institutional asset servicing companies in the world.
Geographically diverse team supported a database environment that included implementations of DB2, Oracle, SQL Server and Sybase.
Interfaced with product management, operations, finance, and legal to meet product development and production support requirements.
Created positive relationships with multiple technical and non-technical support groups across line of business and technical layers.
Oversaw the integration of management during merger. Created effective production support model for accounting data platform starting with just one existing resource. Maintained hands on skills while training onshore/offshore resources.
Managed $1M+ outsource budget. Implemented management dashboard process to effectively control rate of spend.
Collaborated on Enterprise Architecture team to produce actionable approaches to managing architectural artifacts.
January 1999-December 2005
Oversaw the design and development of data warehouse.
Developed a 3 pronged approach to data resource management that encompassed structural, procedural and data architecture components.
Managed 5 fold growth of the team through hires and acquisition.
Managed 20 fold growth in data storage in core DB2 warehouse.
Expanded support to cover Oracle, SQL Server and Sybase.
Designed and implemented operational processes for data resource management function that focused on customer service, technical excellence and efficiency.
Developed JSP/Intranet based data dictionary tool.
Conducted classes on our platform, data models, DB2 and SQL.
Implemented extensive DB2 system tuning enhancements resulting in significant reduction in batch runtimes and CPU costs.
February 1995-December 1998
Supervised the application DBA function for performance and analytics.
Implemented several system tuning fixes resulting in significant savings in processing requirements and batch window. Reduced batch run time from 1 hour to 2 minutes for analytics aggregation engine.
Designed and implemented concurrent load mechanism that eliminated the need to take reporting products offline during load processing.
Developed application code for the performance measurement and analytics systems within the asset servicing division.
Optimized early efforts with mainframe connectivity from distributed applications (ODBC/JDBC) by analyzing detailed database traces as well as CLI layer traces.
January 1993-January 1995
Designed and implemented data interfaces feeding a global accounting system installation at a large insurance company.
Developed instrumented ETL interfaces using mainframe sort and transformation tools.
Coded enhancements to retail banking, safe-box and statements processing for a mid sized regional bank.
EDUCATION
Degree Dec 1992
B.A. in Business Administration
University of Maine, Orono, ME
Major: MIS / Minor: Marketing
MILITARY
September 1984-September 1988
U.S. Air Force
Cryptologic Linguist Specialist (Korean)
Top Secret SCI - Security Clearance
TECHNICAL
Databases: DB2 z/OS, DB2 UDB, SQL Server, Oracle, MySQL
Languages: SQL, COBOL, Java, JSP, HTML, C++, VB, REXX
Platforms: Mainframe, AIX, Windows
Tools: ERWin, PowerDesigner, Visio, Protιgι, Embarcadaro DBArtisan, QMF, Insight DB2, Visual Explain, Platinum, Informatica, Syncsort, Eclipse, Actuate, Crystal Reports, Websphere, Tomcat |
