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
