PROFESSIONAL EXPERIENCE

Technical Project Manager/DBA

Disney Consumer Products

Glendale, California

2008 - 2009

As Technical Project Manager, managed the migration and upgrade of Oracle 9i databases to Oracle 10i and SQL Server 2000 databases to SQL Server 2005. Managed the OPA North America Stationery project and release. Projects completed on schedule and under budget.

As DBA, tuned the SQL Server database performance of the Online Product Approval (OPA) system. Participated in the Microsoft SQL RAP and implemented the recommended changes to server configuration settings and application code. Documented the changes and wrote Best Practices for SQL Server application programmers.

As DBA and solution architect, designed an archive process for OPA then coded, tested and implemented the solution.

As DBA and data modeler, created the new Global Distribution Portal (GDP) system database.

Projects completed on schedule and under budget.

Production problem identification and resolution.

Designed and developed an index maintenance utility for consistently optimum performance.

Project Manager/DBA

Korn/Ferry International

Century City, California

2005 - 2007

As Project Manager with a team of 10-15 people and DBA for the Searcher/FutureSearch executive recruitment applications, and subsequently the Searcher Express .NET project:

Project phases completed on schedule.

Worked closely with the two business units to understand the goals and purposes of each phase of the project, including data conversion, unified code-base leading to a .NET implementation.

Developed and maintained stored procedures.

Documented high-level data flows.

Production problem identification and resolution.

Prepared implementation plans.

Performance tuning.

Technical Lead/DBA

Countrywide Home Loans

Agoura Hills, California

2003 - 2005

As a consultant on the Status Mart and Odyssey projects, I was a part of the team of database administrators that converted the system from Microsoft SQL Server to Oracle.

Spearheaded the implementation of a software development lifecycle.

Responsible for the design and implementation of an authentication and authorization subsystem.

Demonstrated how analysis should be performed, what information should appear in early analysis documents and how these should be used in later phases of the lifecycle.

Improved overall architecture of the system through data re-modeling and re-architecture.

Instituted “best programming practices” within program templates to improved consistency and maintainability, and shortened training time for new staff.

Imbedded performance tuning improvements within code templates.

Technical Lead/Management Consultant/DBA

IndyMac Bank

Pasadena, California

2000 - 2002

Advised senior and executive management regarding the strengths and limitations of various technologies and on the planning of programs, projects and tasks.

Contributed to the growth of full-time IT personnel through mentoring, making training recommendations to management, and designing improvement programs for managers.

Primary technical contact between IndyMac and Microsoft concerning all production SQL Server problems.

Supervised the DBA group during the manager’s absence

Architect for the customization of Empower, Eastern Software's loan origination system.

Designed and developed a distributed database solution to manage the location of loans

Organized and managed the release of all software to production.

Documented coding standards and methods of code review.

Mentored development DBAs and developers on writing efficient SQL code.

Responsible for production blocking, deadlocking, poor performance and scalability concerns affecting the website and internal loan origination system.

Technical Lead/DBA

Countrywide Home Loans

Calabasas, California

1997 - 1999

As a Development Lead for the ADVANTedge Transfer and Transmissions Team, led the development of the subsystem responsible for moving data between FoxPro and DB2 on the AS/400. My team of four developers wrote in C++, Transact-SQL and Visual BASIC. Design reviews of the existing subsystem showed a variety of performance bottlenecks, such as missing indexes on tables, poorly written SQL, and poorly designed interfaces in Visual BASIC.

The Production Systems Department inherited an application called Mortgage Counselor, written in Visual BASIC using Microsoft SQL Server, that was ill-prepared for production use. As a consultant holding the positions of Team Lead and Level 2 Production Support Database Administrator, recommended actions to senior management that would stabilize this client/server system and build confidence among the user community.

Organized the support team, wrote policies and procedures, interviewed and recommended new staff, and participated in employee and consultant reviews.

Reverse-engineered an entity relationship diagram from production using CAST Workbench.

Project Manager/DBA

Allianz Insurance Company

Burbank, California

1996 - 1997

As a Project Manager and developer, I was responsible for the replacement and transition of an existing mainframe worker’s compensation system to a SQL-based system called COSMOS.

Converted the mainframe worker’s compensation system to two Sybase stored procedures, which allowed the company to transition off the IBM mainframe.

As a database administrator on the Data Warehouse Project, I was on the data model design team with senior technical management.

Developed an automated UNIX-based system using Informatica that would extract, transform and load data from the Data Warehouse to specific application databases.

Project Manager

Transamerica Life Companies

Los Angeles, California

1995

As a consultant on the Jefferson Project, responsible for architecture, requirements specification, detailed design documents, data model, development and successful implementation of an annuity sales and customer service system. AT&T Universal Card customers interested in buying the annuity could have monthly annuity contributions automatically billed to their credit card. The client was developed in Visual Basic and the data was stored in DB2 on an IBM 3090, accessed by the client through an MDI gateway. Interviewed, hired and managed four consultants.

As a consultant on the Cost Basis project, a tax reporting application for qualified annuities, I was responsible for designing the work flow of the client application, re-designing the data model, data migration, and implementing the database design in Microsoft SQL Server.

Course Developer

Intel

Sacramento, California

1994

As a part-time consultant, designed a proprietary course for engineers, project managers, project leads and developers at Intel. Intel developed a confidential methodology aimed at managing the ever-changing technology of the computer hardware and software industries. The course was used to announce the release of the methodology and train technical staff how to apply it to internal system development. The course emphasized how to choose project development and deployment products to avoid delivering a new system that employs less than current technology.

PowerBuilder/Sybase Consultant

Southern California Gas Company

Los Angeles, California

1994 - 1995

As a consultant, led the Sybase and PowerBuilder performance tuning effort while providing data modeling and development DBA support for two mission critical projects nearing production: Gas Select Rebuild (GSR) and Measurement Collections System (MCS). Evaluated PowerBuilder code, embedded SQL, general application design, application stored procedures, triggers, indexes, entity relationship diagrams, physical data models and the hardware and software configuration of the HP-9000 Model 877 database servers.

Established disk configuration and database segmentation strategies for improved I/O.

Successfully migrated each development environment from Sybase Release 4.9.1 to System 10.0.1. Identified for developers how the migration would impact existing code.

Designed and taught a "SQL Performance Tuning for Developers" class to both development teams and the data administrators supporting each project.

Established performance monitoring mechanisms for both projects.

Synchronized the physical data models with the databases and established configuration management procedures for the DBAs and project teams.

Technical Management Consultant/Trainer

ARCO Products Company

Los Angeles, California

1993 - 1994

As a consultant to Information Technical Services management, performed technical risk analysis of the company's unique implementation of client/server technology. Investigated the security of the LAN, client/server applications, Sybase, UNIX and Lotus Notes, and VM, MVS, ACF2 and DB2 on the IBM mainframe.

Presented a comprehensive risk analysis to senior management and staff. Recommendations included how to implement centralized userid management, more efficient Sybase security procedures, LAN dial-in access, cross-platform password synchronization and greater security awareness throughout the company.

Designed and taught “Administering Sybase Security” which focuses on security roles and responsibilities and how to perform administration tasks.

Wrote and published in the company newsletter an article for general users about procedures for protecting sensitive data.

Wrote and published memos describing how to protect data from third-party ad hoc query tools and how to optimize SQL code.

EDUCATION

Bachelor of Science, Computer Science Engineering: Michigan State University
Minors: Mathematics, Business Administration and Sociology

Certificate in Business Administration: Hubbard College of Administration

PROFILE

LANGUAGES / SOFTWARE (High familiarity items in bold)

Sybase SQL Server

Versions 4.2, 4.92, 10

HARDWARE / OPERATING SYSTEMS

Project Manager

EDUCATION