Matthew David Elgert
email: mdelgert@yahoo.com website & blog: http://www.vessea.com
Skills
Summary:
Database: Microsoft
SQL/Reporting/Analysis Server 7/2000/2005/2008, T-SQL, DTS, SSIS, Oracle
8/9/10, PL/SQL, IBM DB2, SAP 4.6/5.0/4, MySQL 4/5
Technologies:
SharePoint 2003, 2007,
Crystal Reports 8.5/9/10/11, TCP/IP/LAN/WAN/VPN/DNS/Active Directory, Windows
NT 4.0/2000/2003/2008 Server, Microsoft Exchange 5.5/2000/2003, VMware ESX
2/3/4, Microsoft BizTalk 2006/2009, RedHat Enterprise 3/4/5, Ubuntu Server
6/7/8, Linux, UNIX, IIS 5/6/7, Apache, VERITAS Backup Exec 7/8/9/10/11d, Adobe Master Collection CS 3/4
Languages: C#, VB.NET, ASP.NET, ADO.NET,
.Net Framework 1.0/2.0/3.5, Visual Studio 6/2002/2003/2005/2008, Java, J2EE, Eclipse IDE, PHP 4/5, HTML, DHTML, XML, XSL, CSS
Version
Control: Microsoft Visual Source Safe 6 & 2005, SVN, TortoiseCVS
Methodologies: SDLC,
RUP, RAD, Waterfall, Agile and Scrum
Professional
Experience:
Insight
Enterprises - Tempe, AZ April
2007 - Till Date
Sr. Software
Engineer
Description:
Enterprise-scale ecommerce website
hosting terabytes of data and billions of dollars of financial information.
Responsibilities:
- Worked with executive officers, directors, managers, developers
and enterprise accounts owners with software designs
- Gathered requirements, interviewed subject matter experts,
developed technical specifications.
- Designed, maintained, migrated, backed up, restored and upgraded
enterprise scale SQL Server databases
- Database Development and Scripting of Stored procedures,
Functions, and Triggers
- Develop, optimize and troubleshoot existing and new procedures,
functions and SSIS packages from MSSQL 2000 to MSSQL 2005 for enhancement
and conversion to existing and new packages for maintenance.
- Responsible for the design, development, testing and deployment of
job workflows using DTS, SSIS and TSQL for existing internal ISIS-R
re-deployment for internal and external customers for web based
application.
- Designed SQL Server 2000/2005 DTS, SSIS, SSRS, user defined
functions, triggers, views, stored procedures, jobs and optimized existing
stored procedures for web performance.
- Responsible for designing majority of web-based reporting and user
interfaces on http://www.insight.com utilizing C#, ASP.Net, VB.net, Visual Studio
and Java
- Designed special request reports for the following large revenue
generating accounts
- Designed core backend data exchanges and responsible for reducing
overhead code up to 75%
- Increased customer facing reporting performance up to 400% using
development best practices
- Managed production websites, databases builds, code reviews, led and
mentored developers
Environment: SAP 4.6C, ECC 5.0, SAP R/3, BW/BI, Microsoft
SQL/Reporting/Analysis Server 2000/2005/2008, SSIS, DTS, Visual Studio
2005/2008, .Net Framework 2.0/3.5, C#, ASP.Net, VB.NET, T-SQL, Microsoft
BizTalk 2009, Adobe Master Collection CS4, Crystal Reports 11/12, Oracle
10/11g, PL-SQL, MySQL 5, DotNetNuke 5, SharePoint 2007, JAVA, JavaScript, JQuery, J2EE,
Eclipse IDE, SVN, TortoiseCVS, VSS 2005, Windows 2003/2008, IIS 6/7, UNIX,
Apache and RedHat Enterprise 5
Provest - Tampa, FL
August
2005 - April 2007
Sr. Software
Engineer
Description: Enterprise
data exchanges for a legal case management system.
Responsibilities:
- Worked with third party vendors, led and mentored developers to
integrate data exchanges
- Gathered requirements, interviewed subject matter experts,
developed technical specifications.
- Database Development and Scripting of Stored procedures,
Functions, and Triggers
- Develop, optimize and troubleshoot existing and new procedures,
functions and SSIS packages from MSSQL 2000 to MSSQL 2005 for enhancement
and conversion to existing and new packages for maintenance.
- Responsible for the design, development, testing and deployment of
job workflows using DTS, SSIS and TSQL for existing internal ISIS-R
re-deployment for internal and external customers for web based
application.
- Designed SQL Server 2000/2005 DTS, SSIS, SSRS, user defined
functions, triggers, views, stored procedures, jobs and optimized existing
stored procedures for web performance.
- Designed APIs, WCF, SOAP, Web Services and XML interfaces
- Analyze requirements and provide accurate effort assessments and
delivery estimates
- Perform root-cause-analysis of database failures implement quick
fixes and long-term solutions
- Designed web-based case management user interfaces and reporting
applications utilizing C#, VB.net, and ASP.net
Environment: BizTalk 2006, DotNetNuke 4, Microsoft
SQL/Reporting/Analysis Server 2005, T-SQL, Visual Studio 2005, C#, ASP.Net, VB.NET,
ASP.NET, WCF, Windows 2003, IIS 6, Apache, VSS 2005, PHP4, MySQL 4, Linux, and
Ubuntu Server 8
Honeywell - Phoenix, AZ July
2004 - August 2005
Sr. Software
Engineer
Description:
Aviation safety reporting system.
Responsibilities:
- Worked with aviation engineers to collect requirements and
specifications for reporting system
- Responsible for decision making regarding application designs and
architecture
- Designed and implemented web-based user interfaces and reporting
application utilizing VB.Net, ASP.Net and Crystal Reports
- Analyze and optimize performance for retrieving and storing large
amounts of data
- Database development, data modeling, table design, physical
design, and procedures
- Database Development and Scripting of Stored procedures,
Functions, and Triggers
- Develop, optimize and troubleshoot existing and new procedures,
functions and SSIS packages from MSSQL 2000 to MSSQL 2005 for enhancement
and conversion to existing and new packages for maintenance.
- Responsible for the design, development, testing and deployment of
job workflows using DTS, SSIS and TSQL for existing internal ISIS-R
re-deployment for internal and external customers for web based
application.
- Designed SQL Server 2000/2005 DTS, SSIS, SSRS, user defined
functions, triggers, views, stored procedures, jobs and optimized existing
stored procedures for web performance.
- Create and maintain technical documentation
Environment: Crystal Reports 10/11, Business Objects, Oracle 10g,
PL/SQL, TOAD, Windows 2003, IIS 6.0, Microsoft SQL Server 2005 and T-SQL
Arizona
Department of Water Resources - Phoenix,
AZ June 2003 - July 2004
Sr.
Developer/Contractor
Description:
Water safety and quality geographic information system.
Responsibilities:
- Worked with scientists to gather water safety specifications for
database design and reporting
- Support researchers and scientists in mining data stored in the
databases
- Research, implement best practices, methods and standards for
database management
- Designed and implemented web-based user interfaces and reporting
application
- Troubleshoot code defects and deploy timely fixes
Environment: Microsoft Visual Studio 2002, C#, ASP.Net, VB.NET,
Microsoft SQL/Reporting/Analysis Server 2000, T-SQL, and Microsoft Visual
Source Safe 6
Wells Fargo - Portland,
OR March
2002 - June 2003
DBA/Contractor
Description:
Credit risk assessment application.
Responsibilities:
- Managed backups, restores, security and performance issues
- Maintain the rolling deployment of database code to development,
QA, and production environments
- Provide support for applications and developers that require
database access
- Assist in the research and resolution of technical issues raised
by the development staff and/or end users
- Installation, upgrades and patch management of database
environments
Environment: Microsoft SQL 2000/Reporting/Analysis Services,
T-SQL, Microsoft Visual Studio 2002 and Microsoft Visual Source Safe 6, UNIX,
DB2, Oracle 9, PL-SQL and VERITAS Backup Exec 8/9
Tokyo Electron
Labs - Tempe,
AZ June
2000 - March 2002
Developer/Contractor
Description:
Semiconductor patent assessment application.
Responsibilities:
- Collaborate with scientists to integrate user requirements into
patent application
- Deploy software and data to production environments
- Analyze workflow scenarios in a heterogeneous in multiple
application environments
- Designed and implemented web-based user interfaces and reporting
application
- Develop processes and documentation
Environment: Microsoft SQL/Reporting/Analysis Server 2000, T-SQL,
Windows 2003, IIS 6, Microsoft Access 2000, Microsoft Visual Studio 2002 and
Microsoft Visual Source Safe 6
Andre Balazs
Properties - New York, NY,
Los Angeles & Hollywood, California
June 2002 - January 2007
Sr.
Enterprise Architect
Description:
Hotel management systems.
Responsibilities:
- Managed, backups, secured, financial and high profile client data
- Coordinate vendors and purchase orders of millions of dollars IT
infrastructure for new and existing hotels
- Work with vendors with application and hardware compatibility
issues
- Provide pre-implementation feedback on database designs
- Migrate databases between servers
- Monitor transaction log shipping to various disaster recovery and
reporting servers
Environment: VMware ESX 3/4, DotNetNuke 4, Oracle 8/9/10, PL/SQL,
UNIX, Windows NT 4.0/2000/2003, IIS6, Microsoft SQL/Reporting/Analysis Server
2000/2005, T-SQL, C#, VB.NET, Visual Studio 2005, .Net Framework 2.0, Microsoft
Visual Source Safe 6, Crystal Reports 9/10, Mitel - Private branch exchange
(PBX), Profit Watch, Opera Property Management System (PMS), Vingcard Guest
Keycard System, Micros Pont of Sales (POS), On-Command In Room Entertainment,
Tesa, ADP, Kronos, BarTech - Minibar Systems, and VERITAS Backup Exec
8/9/10/11d
King &
Associates - Carefree, AZ Jan
2000 - Jan 2005
Sr.
Enterprise Architect (side work)
Description:
Bankruptcy case management system.
Responsibilities:
- Manage, backups, restores, recoveries, maintain overall data
integrity and secured trillions of dollars of bankruptcy data
- Perform database optimization and tuning and ongoing capacity
planning
- Design and implement back-end requirements for applications
containing large amounts of data (terabytes)
- Coordinate purchase orders of IT infrastructure and implementation
- Worked with accounts on data imports (Edison Brothers Stores,
Inc., Electro Mechanical Solutions, Inc.,
- House2Home Inc., Money's Financial, LLC, Sorg Incorporated and The
FINOVA Group, Inc.)
- Day to day operation and maintenance of enterprise database
platforms
- Manage source control of scripts and code to different
environments
Environment: VMware ESX 3/4, DotNetNuke 4, Oracle 8/9/10, PL/SQL,
UNIX, Windows NT 4.0/2000/2003, IIS 6, Microsoft SQL/Reporting/Analysis Server
2000/2005, MySQL 4/5, T-SQL, C#, VB.NET, Visual Studio 2005, .Net Framework
1.0, Microsoft Visual Source Safe 6, Crystal Reports 8.5/9, SAP R/3 and VERITAS
Backup Exec 8/9/10d
Apogee
Software Systems - Carefree, AZ March
1994 - Jan 2004
Sr. Systems
Engineer (side work)
Description:
Core web-based infrastructure and consulting on the following projects.
Responsibilities:
- Marnell Corrao, Las Vegas,
NV. - Developer/Contractor,
April 1999 - June 2000
- America West Airlines - Tempe, AZ. - DBA/Contractor, February
1998 - April 1999
- Mayo Clinic - Scottsdale,
AZ - DBA/Contractor, January
1997 - February 1998
- Bank Of America,
Phoenix, AZ - DBA/Contractor, December 1996 -
January 1997
- Arizona Public Services, Phoenix, AZ
- Developer/Contractor, September 1995 - December 1996
- Arizona Department Of Economic Security - Phoenix, AZ
Contractor, October 1994 - September 1995
- Coordinate purchase orders of IT infrastructures and
implementations
- Performance tuning techniques on complex data loads/data
conversions as well as reporting performance issues
- Responsible for resolving change requests and other assigned tasks
by (SLA)
- Insure proper backup procedures are accomplished for successful
data recoverability
Environment: VMware ESX 3, DotNetNuke 1,2,3 (CMS), Windows NT
4.0/2000/2003 Server, Microsoft SQL 6.5/7/2000, ASP, Crystal Reports 8.5, IIS
5, Microsoft Exchange 5.5/2000/2003, SAP R/3, Windows 2000/2003 Enterprise,
Microsoft SQL Server 7.0/2000, T-SQL, .NET, IIS 5, Microsoft Exchange
5.5/2000/2003 and VERITAS Backup Exec 7/8/9