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.
QUALIFICATIONS
- 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
PROFESSIONAL EXPERIENCE
Confidential |
Data Architect Principal Leader |
- 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 |
- 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 |
- Designed, developed, and managed several product databases for development teams
- Provided consulting services to customers which included Goldman Sachs and AIG
|
Confidential |
Database Administrator |
- 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 |
- 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
|
TECHNICAL SKILLS AND CERTIFICATIONS
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 |
Certifications: | DB2, SQL Server |