SUMMARY:

• Over 20 year’s progressive experience in Information Technology field.
• Senior Database Architect / Lead Database Developer for WEB and n - tier applications. Team and Development Lead positions on several large team ($20M+) projects. Responsible for technology selection and recommendations in many of these projects. Vast experience and ability to work in any and all phases of the Software Development Lifecycle (SDLC). Infrastructure and hardware specification/design to support underlying software and security was also my responsibility in many projects.
• Demonstrated expertise in problem determination and resolution of Databases experiencing performance, scalability and stability problems or loss of data and/or transactions.
• IIS and SQL Server Expert called upon several times to resolve performance and/or code problems in conjunction with Microsoft Consulting Service (MCS) and technical support services
• Application experience includes Financial, Banking, Accounting, Workflow, Document Management, Imaging, Trading, Document Delivery, Reporting and E-Business
• Extensive experience with commercial RDBMS including MS SQL Server, Oracle and Sybase
• ERWin, VISIO and S-Designer used for Data Modeling (ERD Diagrams) and Database forward / reverse engineering
• Extensive experience designing and creating OLTP databases, writing stored procedures and triggers along with optimization. Database experience also includes designing and creating Star Schema OLAP/Data Warehouse databases. Strong TSQL and PL/SQL coding skills along with query optimization and performance tuning
• Experience with numerous development methodologies (Waterfall, Agile, Scrum, Spiral, RAD, etc.)
• Excellent oral and written communication skills

TECHNICAL SKILLS:

Database: SQL Server, Oracle, Sybase, DB2, TSQL, PL/SQL, ANSI SQL

ETL: DTS, SSIS, SQL

Reporting: Crystal Reports, SSRS

Data Modeling: ERwin, S-Designer, Visio

Web: .Net Framework, ASP.Net, C#, VB.Net, Web Services, IIS 6/5/4/3, HTML, DHTML, DOM, XML, XSL, XSLT, XPATH, CSS, ASP, VB Script, JavaScript, Java, Visual InterDev 1.0/6.0, Windows Media, Microsoft Site Server, LDAP, ADSI, Microsoft Exchange.

Distributed nTier Systems: .Net Framework, C#, VB.Net, MS Visual C++ 6.0, Visual Basic 6.0/5.0, COM+, COM/DCOM, Microsoft Transaction Server (MTS), MSMQ, Java

Client/Server: .Net, C#, Visual Basic 3.0/4.0/5.0/6.0 , VC++

Object Modeling: Rational Rose, RUP, UML

Operating Systems: Windows 3.x, Windows 95, Windows NT 3.51, Windows NT 4.0, Windows NT 4.0 EE, Windows 2000 (all versions), Windows XP, Windows 7, Windows 8, Windows Server 2003

EXPERIENCE:

Confidential, Irvine, California

Database/Software Engineer

Responsibilities:

• Upgraded operations Database from SQL Server 2000 to SQL Server 2012.
• Created DDL scripts to build the tables, indexes and constraints. Created DML scripts to build the stored procedures and triggers.
• Used DTS to export data via Confidential files and Confidential with stored procedures to export data via XML files.
• Utilized DTS and TSQL to import the data into the new database.
• Redesign and rewrite Confidential online contract system.
• Designed and created a system to import candidate information and resume from any job board (Monster, Dice, etc.) into Confidential candidate management system in real time.
• Designed and developed a new system to import data from various clients Vendor Management Systems. The data being imported was financial (timesheets, invoices, checks, etc.) which was imported directly into Confidential accounting system. Also imported client candidate requirements into Confidential requirement management system.
• Redesign and rewrite of classic ASP online timesheet system to ASP.Net and C# which included numerous enhancements and new functionality.
• Resolve complex issues in existing systems and applications for Confidential clients.
• Recruit and technically screen candidates for Information Technology positions with Confidential clients.

Confidential, Gilbert, AZ

Database/Software Engineer

Responsibilities:

• Requirements analysis and documentation
• Project planning, scheduling and budgeting
• Application and database design
• Resource assignments and timelines.
• Managed application coding and database creation/coding
• Created test plans, manage testing and defect remediation

Technologies used: MS SQL Server 2000, TSQL, WinInet, IIS, ASP and Visual Basic

Confidential, Temecula, California

Database/Software Engineer

Responsibilities:

• Analysis of existing application
• Requirement gathering and documentation of enhancements
• Project planning, time estimates and scheduling
• Application redesign
• Database redesign
• Development of stored procedures and triggers
• Oversee/Lead development of application redesign
• Oversee and assist in testing

Technologies used: Oracle 10g RAC, TOAD, PL/SQL, .Net, C#, Visual Basic, ADO, Windows API and Visual Source Safe.

Confidential, Irvine, California

Database/Software Engineer

Responsibilities:

• Database Design and Development.
• TSQL coding of stored procedures and triggers.
• Support and maintain databases.
• Resolve complex issues in existing systems and applications for Confidential clients.
• Recruit and technically screen candidates for Information Technology positions with Confidential clients.

Confidential, Phoenix, Arizona

Database/Software Engineer

Responsibilities:

• Analysis of existing application
• Requirement gathering and documentation of enhancements
• Database design and creation
• Development of stored procedures and triggers
• Design and development of middle tier components including .Net and web services
• Design and development of numerous custom .Net server controls
• Design and development of user interface.

Technologies used: Microsoft Sql Server 2000, Oracle 8i, TSQL, PL/SQL, ADO, ASP.Net, Visual Basic .Net, Visual Basic 6.0, Microsoft .Net Framework, Microsoft .Net Web-Services, SOAP, HTML, DHTML, XML, XSLT, XPATH, VB Script, Java Script, IIS 5.0, Windows 2000 Advanced Server, Windows XP and Visual Source Safe.

Confidential, Temecula, California

Senior Architect/Project Lead/Application Manager

Responsibilities:

• Requirements analysis and documentation
• Project planning, scheduling and budgeting
• Application and database design
• Application coding and database creation/coding
• Test planning, testing, defect remediation
• Deployment and training.

Technologies used: HTML DHTML, ASP, JavaScript, VBScript, VB, XML, XSLT, XPATH, DOM, ADOMS SQL Server 2000, TSQL, SQL, WinInet, Outlook Object Model, Exchange 2000, LDAPADSI, Visual Source Safe, IIS 5.0 and Windows 2000 Advance Server.

Confidential, Phoenix, Arizona

Senior Architect

Responsibilities:

• Modifications to the source code of the HOW tool’s base objects
• Numerous custom controls created in Visual Basic are used in this new framework
• Created a Security Service and an Audit Trail Service that are part of the new framework
• Trained and mentored the development staff

Technologies used: Visual Basic, Visual Source Safe, HOW, UML, XML, XPATH, DOM, ADO, OLEDB, ODBC, COM+, SQL and DB2 UDB.

Confidential, Temecula, California

Senior Architect/Project Lead

Responsibilities:

• Requirements analysis and documentation
• Project planning, scheduling and budgeting
• Application and database design
• Application coding and database creation/coding
• Test planning, testing, defect remediation
• Deployment and training.

Technologies used: HTML DHTML, ASP, ASP.NET, ADO.NET C#, JavaScript, VBScript, VB, XML, XSLT, XPATH, DOM, ADO, MS SQL Server 2000, TSQL, SQL, Visual Source Safe, IIS 5.0, Windows 2000 Advance Server.

Confidential, Santa Ana, California

Senior Architect

Responsibilities:

• Group Manager and Architect
• Lead JAD sessions with Business Analysts and SME’s
• Design a new Thin Client user interface framework
• Design a new middle tier framework
• Redesign specific subject areas of the database
• Manage development including task assignment, timelines and status reports
• Resolved and stabilized IIS crashing problems. Using load testing tools and exception monitoring tools I resolved complex system issues resulting in the system’s current state of high availability.
• Troubleshooting and optimization of database related performance problems. Correcting these problems included stored procedure (SQL) optimization and/or rewrites, index optimization and in some cases a complete redesign of specific subject areas.
• Member of the First American Enterprise Architecture Group

Technologies used: XML, XPATH, HTML, DHTML, DOM, JavaScript, Java, COM/DCOM, VBScript, Microsoft Remote Scripting, ASP, MTS, COM+, MS SQL Server 7.0/2000, IIS 4.0/5.0, Visual Basic, VC++, ADO, ODBC, OLE DB, TSQL, SQL, Visual Source Safe, ASP.Net, ADO.Net and C#.

Confidential, Van Nuys, California

Senior Architect/Development Manager

Responsibilities:

• Design, develop web site and application
• Managed/Lead the development team
• Trained the development staff in the technologies used
• Extensive optimization to meet aggressive page load time requirements
• Met aggressive schedules to satisfy investor requirements

Technologies used: HTML, JavaScript, DOM, Java, COM/DCOM, VBScript, ASP, MTS, MS SQL Server, Visual Basic, ADO, ODBC, OLE DB, TSQL, SQL, DTS, LDAP and Visual Source Safe.

Confidential, Torrance, California

Senior Architect

Responsibilities:

• I reported directly to the VP of Information Services. There are two sides to the new system.
• A Source Data Load process that receives data on tape, from various sources, processes that data and inserts it into a SQL Server database.
• This data is then presented via web pages for the company’s representatives to view. Both sides of the application are 3-tier using mainly Microsoft technologies.
• There was also a large data conversion from a MS Access database to the new MS SQL Server database.
• The application also interacts with a data warehouse that is an Oracle database.
• It was also my responsibility to train the development staff in using the implemented technologies.

Technologies used: HTML, JavaScript, Java, COM/DCOM, VBScript, ASP, MTS, MSMQ, MS Access, MS SQL Server, Visual Basic, Visual Source Safe, ADO, ODBC, OLE DB, Oracle, SQL and TSQL.