SUMMARY:

• Over 20 years of experience designing, developing and supporting various database applications.
• Willing to lead projects at all levels from conception thru implementation.
• Enjoys working with and mentoring others in computer technology.

TECHNICAL SKILLS:

Methodologies: Agile/Scrum, Data Warehousing (Kimball/Inmon), ORM.

Databases: Microsoft SQL Server 2012/2008/2005/2000/7, Oracle 12c/11g/8i/7.3, CA IDMS 12/10.2, IBM DB2

Languages: T - SQL, C#, VB.Net, Visual Basic/Access/VBA/ADO/COM/ASP, XML, Oracle PL/SQL, IBM OS/JCL/COBOL II/74/68, CA IDMS/R+ADS/O, JavaScript, Sybase PowerBuilder, Java, C/C++

Applications: Microsoft VS/TFS 2013/SSIS/SSRS/SSAS, BizTalk 2006 R2, Idera Diagnostic Manager/SQLsafe, Dell Toad for SQL Server/Spotlight for SQL Server, Embarcadero ER/Studio Data Architect / DBArtisan, Red Gate SQL/Data Compare + SDK, Microsoft Office/Navision, Adobe Photoshop CS6/5.5, Subversion, GIT, Informatica, SQL*Plus, SQL Developer, Crystal Reports 8/9.

PROFESSIONAL EXPERIENCE:

Confidential, California

Senior SQL Server Database Developer

Responsibilities:

• Maintain multi-branch ER Diagrams (logical and physical) for both SQL Server 2012 and Oracle 12c using Embarcadero ER/Studio Data Architect.
• Review SQL Coding for performance and optimize for SET-based vs. ROW-based processing.
• Troubleshoot SQL Server 2008/2008R2/2012 performance issues using SQL Diagnostic Manager.
• Develop and maintain Flexera InstallAnywhere custom database installer project for mutli-software package SQL Server / Oracle / Cognos / DataStage database installations in customer environments.
• Conducted training sessions SET-based vs. ROW-based design and coding changes.

Senior Database Administrator

Responsibilities:

• Administrated over 100 SQL Server database servers (SQL Server 2012 SP1, 2008 R2 SP1, 2005 SP4, 2000 SP4) including SIOS DataKeeper-clustered AWS Cloud-hosted SQL Server 2012 database instances.
• Maintained daily backup job checks using custom VB.Net tool to scan all completed jobs for errors.
• Used Idera SQLsafe to compress/encrypt database backups.
• Built clustered SQL Server 2012 SP1/2008 R2 SP1 SQL Servers with SSIS/SSAS/SSRS.
• Managed SQL 2000 legacy database servers (backups, index rebuilds, checkdb).
• Supervised on-site installation of licensed purchased copy of NCR’s asynchronous key-secured SQL Server 2012 database payment solution for customer Publix (Florida-based supermarket chain).
• Administrated Crystal Reports 9.

Data Architect

Responsibilities:

• Designed and maintained SQL Server 2005 ODS ETL data feeds and 2008 OLAP Cube for historical data reporting across 12 facilities spanning 4 states and two countries with UTC date tracking using Kimball Enterprise Data Warehouse Bus Architecture.
• Designed location-separated, AsOfDate-driven ETL for laboratory tooth milling XML data capture into an ODS from 3 milling locations (California, Nevada and Arizona) with stale data feed identification.
• Designed import FedEx ETL for storing delivery data into ODS with conforming address dictionary lookup logic to provide inbound package visibility to production managers.
• Designed weekly SSIS ETL to export previous week’s dental lab order product shipments to 3rd party carrier data consolidator with subsequent week SSIS ETL import of multiple carrier invoice data into ODS for logistical analysis and reconcile of carrier rate and shipping charges.
• Maintained SSRS Reports connected to backend data warehouse star schema and OLAP cubes.
• Optimized stored procedures from RBAR into set-based solutions saving hours of process time.
• Maintained, reviewed and enforced corporate SQL Development Standards stored in SQL Wiki website.
• Developed C# / RedGate SQLCompare API Winform application to detect enterprise database DDL object differences between source location and all remote locations.

Senior Database Administrator/Architect

Responsibilities:

• Administrated over 320 SQL Server 2005/2000 corporate databases (4 TB+) across 14 servers with ongoing database conversions onto 2 EMC Clarion 12 TB SANs in California and North Carolina.
• Optimized and tuned SQL performance for all SQL objects.
• Developed SSIS packages for loading ad hoc data into BizTalk 2006 R2 transactional databases.
• Configured and administrated Ipswitch MoveIT Central automated file transfer management software for 3rd party file transfers including public/private key management.
• Transactionally replicated common lookup database data to three OLTP databases.
• Setup high-performance mode database mirroring between production and BI ETL staging server.
• Monitored and maintained multiple BizTalk 2006 R2 database environments for 3 applications.
• Developed, maintained and enforced corporate SQL Development Standards.
• Designed backup/purge strategy using Microsoft SQL Server and scheduled C# purge routine.
• Administrated and maintained Production and Development SSRS instances.
• Managed multiple, successful 32 to 64-bit SQL 2000 to 2005 SP2 Enterprise conversion projects.
• Implemented secure zone, synchronous credit card encryption for PCI data security compliance.
• Developed row-level auditing for tracking inserts, updates and deletes into data warehouse.
• Developed abstraction layer support for legacy database structures with automated regeneration.
• Developed SQL Data Dictionary for data warehousing ETL analysis.

Sr. Applications Manager

Responsibilities:

• Managed staff of 2 (plus external contractors) and co-developed successful launch of both SSL-secured, in-frame B2C commerce telephone accessory website for confidential and subsequent website makeover for coordinated corporate launch of confidential.
• Developed and administrated 6 production and 6 test SQL Server 2000 corporate databases.
• Designed business logical schemas using triggers, functions and stored procedures.
• Maintained scheduled/ on-demand data feeds for commerce websites, intranet financial reporting and ad hoc analytical queries using DTS/T-SQL/ODBC/C#/VB/ADO/XML.
• Worked with users and groups to determine and enforce database security.
• Defined, designed and implemented corporate database backup/recovery procedures.
• Architected VB.Net merged inventory label Bill of Materials (BOM) solution for printing item/customer-specific UPC, Country of Origin, SRP and phone-accessory compatibility data.
• Architected Access VBA Phone-to-product compatibility tracking system.
• Architected Access VBA Price List system that extracted Microsoft NAV ERP item unit prices, applied tiered/customer contractual group/item discounts via pricing rule engine, printed price lists and uploaded data to ERP for Sales Order Entry line-item pricing by customer-linked price list.

Senior Programmer Analyst

Responsibilities:

• Team-developed client-server PowerBuilder 7/Oracle 8 theatrical sales system and integrated same to mainframe advertising and multiple external partner data systems.
• Architected mainframe and MS Access VBA/ADO advertising system for budgeting, tracking, and billing newspaper/radio advertising campaigns.
• Architected MS Access VBA/ADO publicity system for tracking movie premiere attendance.
• Acted as FTP Technical Liaison between advertising/graphics departments and external advertising agency for distributing theatrical newspaper advertising images over the Internet via secured ftp.
• Architected MS Access/Excel/VBA cooperative advertising newspaper entry data warehouse that collected and calculated shared advertising terms and costs for over 300 U.S. newspaper markets.

Business Systems Analyst

Responsibilities:

• Architected multi-cycle, multiple job site mainframe manual check system.
• Architected W-2/1099 TAX reporting systems with IRS transmitter certification.
• Refactored project account reporting system for tracking fiscal project gain/loss with ad hoc reporting. Net savings: significantly reduced mainframe process time from 8 hours to 20 minutes.
• Jointly maintained mainframe 6-cycle weekly payroll for hourly employees.
• Developed curriculum and conducted seminars in introductory computing and electronic mail.