Data Architect Principal Leader Resume

SUMMARY:

A highly experienced and professional Data Architect, Database Administrator, and Software Engineer with extensive depth of knowledge in database design and development as well as in software development, committed to exceeding business requirements and company expectations.
An effective, organized individual who works well both independently and on teams.
Extensive experience working with all aspects of Property and Casualty insurance software
Manage database environments, from planning stages through implementation and support
Excellent analytical and problem solving skills
Work well with all levels of business
More than 30 years in the IT industry including 15 years as a DBA and 10 years as an architect in development and production environments

TECHNICAL SKILLS:

Operating Systems: IBM z/OS, Windows 7, Windows XP, Windows NT, Unix, AIX, Solaris

Software: Eclipse, Visual Studio, ERwin, ASG - Manager Products, Microsoft Office, CICS, TSO/ISPF, JCL, SPUFI, QMF, DOS, ENDEVOR, MVS, EXPEDITER

Databases: DB2 z/OS, DB2 LUW, DB2 SOLARIS, SQL Server, PostgreSQL, MySQL

Languages: Java, Visual Basic, C#, JavaScript, VBScript, Google Visualization Tools, COBOL, Assembler, ASG-Manager Products Procedure Language

Web: JavaScript, VBScript, HTML, CSS, Java, JSP, Servlets, XML

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect Principal Leader

Responsibilities:

Provided database related consulting and services to customers including database design, database implementation and maintenance (establishing new databases and applying various customer specific changes), database object definitions, and the tuning of the databases in order to achieve optimal performance
Traveled to various locations to troubleshoot database performance related issues and provide additional consultation to customers
Worked closely with development teams on database design
Automated processes by writing many Java, VB .NET and C# .NET applications for performing various tasks which resulted in significantly reduction of turnaround time
Developed tools for generating data definition language (DDL) from the database
Consulted with customers regarding essential data model design as it pertains to components of the model
Rewrote all Visual Basic programs to accommodate Microsoft SQL Server 2008 no longer supporting SQL - DMO
Migrated databases from SQL Server 2005 to SQL Server 2008

Data Architect

Confidential

Responsibilities:

Designed and developed the Data Modeling Design browser-enabled system
Performed various database related tasks which included database design, database implementation, and database object definitions and modifications for internal customers
Modified Manager Products Data Dictionary to include several new "clauses" for capturing various types of metadata
Created a new instance of SQL Server 2005 on a server that already contained SQL Server 2000
Migrated customer databases from SQL Server 2000 to SQL Server 2005
Worked closely with customers to provide design concepts and aid in the development of the systems

Computer Scientist - Database Manager

Confidential

Responsibilities:

Designed, developed, and managed several product databases for development teams
Provided consulting services to customers which included Goldman Sachs and AIG

Confidential

Database Administrator

Responsibilities:

Designed and developed SQL Server databases for the PMSCiSolutions division
Worked extensively on evaluating database and development tools for the Series III and S3+ development teams

Lead Database Analyst / Programmer

Confidential

Responsibilities:

Assisted in the design and development of database systems for Series III customers
Recommended performance improvements for production customers which enhanced response time
Managed a group of programmers