SUMMARY OF QUALIFICATIONS
Database Architect – Skilled in assessing corporate data requirements and selecting appropriate architecture to meet tactical and strategic requirements. Strong background in banking systems.
Software Engineer / Product Developer – Proven development skills on Microsoft SQL Server, Data Transformation Services, and XML-enabled middle tier.
Database Administrator (DBA) – Experienced establishing Oracle database infrastructure (including backup policies and ongoing performance monitoring) for enterprise system.
Pre-Sales Technical Specialist – Skilled at developing and delivering customer presentations and briefings, developing RFP responses, and creating high level staffing plans. Respected for ability to translate highly technical concepts and product features to business customers, and the ability to think and react quickly in any situation.
Team Leader – Capable of coordinating a variety of projects (data architect, database design, system consolidation or implementation), managing diverse teams to successfully deliver solutions.
Author and Professional Contributor – Published several articles for trade journals regarding secure coding practices for database-driven systems. Professional interests include: Data Management Issues in Banking, Privacy Regulations, Application of Database Architecture to Organizational Strategy.
PROFESSIONAL EXPERIENCE
NATIONAL CONSULTING FIRM, Multiple U.S. Cities 2006 – Present
Senior Data Architect
Serve as a database architect and data quality specialist, with responsibility for designing and directing data solutions for Master Data Management and Enterprise Data Quality Assessments. Clients include Fortune 100 companies in the consumer packaged goods, medical equipment, and utilities industries involved in ERP implementations and consolidations. Prepare pre-sale materials for presentation to customers. Present project updates to project sponsors at customer headquarters.
* Team Lead and Data Architect in a Master Data Management project for a multinational consumer packaged goods company. Led team of five engineers to deliver data profiling, data quality analysis, and master data management database design. Provided data quality assessment of multiple SAP installations’ vendor, customer and product master data. Delivered consolidated Master Data Management logical model for vendor and customer subject areas. Directed delivery of metadata and product data models.
* Developed Practice training materials for technical specialists and data architects delivering Master Data Integration projects to clients. Training materials are being adopted throughout the practice.
* Designed template methodology, project plan, and resulting deliverables for the practice’s data assessment offer.
* Delivered Information and Business Rule Assessment for a leading clothing manufacturer. Led team of five data architects.
* Currently serving as a business analyst in the assessment of Data Integration needs, as part of an ongoing ERP implementation, for a medical equipment company.
REGIONAL UNIVERSITY 2003 – 2006
Enterprise Database Administrator (DBA )
Served as DBA during the university’s transition to Oracle-based Student Information System. Established policies and procedures for implementation and ongoing management of Oracle systems by the Information Services Group. Managed 12 Oracle databases, four Oracle Application Server installations, one Discoverer server, one Oracle Warehouse Builder installation, and a central Grid Control management console.
* Facilitated development of enterprise system data security policy. Coordinated with application vendors and user community to establish best practices for user data access. Met with system administrators to establish developer servers and define developer access requirements.
* Promoted good application development practices by introducing source control software to enterprise application development.
* Established backup, retention, and recovery policies for enterprise database application. Implemented RMAN backup/duplication processes.
* Secured the enterprise application above and beyond delivered application security via Oracle Advanced Security (transport encryption), user resource limits, password validation functions, and user auditing. Audited databases for compliance with Center for Internet Security (CIS) standards for enterprise databases.
INTERNATIONAL SOFTWARE FIRM 1998 – 2003
Database Architect
Responsible for guiding product line data architecture for a retail banking solution provider. Products included Teller, New Accounts, Internet Banking, and Customer Relationship Management (CRM) software. Presented products’ technical architecture to existing and prospective customers. Facilitated discussions regarding products’ ability to meet clients’ strategic objectives. Translated users’ functional requirements into technical implementation strategies.
* Designed and led development of database-driven rules engine for a new retail banking product. Guided the new product through beta site implementation process.
* Architected database schema for New Accounts banking application. Integrated product offerings with data services of CRM and Call Center applications.
* Planned and implemented XML usage into data and middle tier of Teller, CRM, and New Accounts solutions in response to SQL Server 2000’s support of XML.
* Researched coding patterns to prevent compromise of database-driven web applications. Audited existing Internet applications’ risk of SQL Injection, Cross-Site Scripting, Session Replay, and Information Disclosure. Tracked SQL Server coding and configuration security issues.
* Developed data-bound .NET Winform treeview control. Specialized .NET intrinsic and 3rd-party controls to meet application-specific requirements. Designed and coded business-layer COM components for Proof-of-Concept model.
TOP-TIER BANK, WA 1997 – 1998
Systems Engineer – Applications
Began as a student intern, assisting in the implementation of an enterprise data warehouse, providing data cleansing, and creating a data dictionary for Redbrick data warehouse. Hired full time as a Systems Engineer, with responsibility for managing multiple department software development projects. Directed the design of a multi-site, database-driven Intranet application to process security requests. Designed and implemented Microsoft Access management reporting systems used by the Collection Department. Led interactions with external neural net provider, serving as primary technical contact for joint data mining project.
EDUCATION
REGIONAL UNIVERSITY, WA
B.S. Computer Information Systems, summa cum laude, 1999
IBM Certified Solution Developer, Websphere Information Analyzer, 2007
Oracle 10g Certified Professional (OCP), 2006
Microsoft Certified Solution Developer (MCSD) – Charter Member, 2002
TECHNICAL SKILLS
SQL - Oracle – Perl – Secure Coding – SQLServer – Visual Basic – XML – C# – Microsoft Office Suite (Word, Access, Excel, PowerPoint) – MS Project
PROFESSIONAL CONTRIBUTIONS
Professional Advisory Board, Regional University, Computer Science Department, 2004, 2005
Publishing credits for print and online media regarding SQL Injection, secure forms authentication, and secure database coding.
Technical Editor for more than 15 books including Guru’s Guide to SQL Server Stored Procedures, XML, and HTML, published by Addison Wesley Publishing Company (January 2002), and .NET e-Business Architecture, published by Sams Technical Publishing (November 2001) |
