David J. Patz

**** **** *** ***** ***********, CO 80031

720-***-**** acr6kf@r.postjobfree.com

SUMMARY

Management

12+ years of technical management experience developing and hiring quality resources both domestic and offshore development teams. Managed development teams of 16+ database and C# developers to provide highly secure web services for N-tiered application development using Agile/Scrum methodologies. Additionally, managed projects from Canada with 7 off-shore developers from India.

Project Management

Strong written and verbal skills, including proposals and presentations. Skilled at communicating with end users and interpreting business needs into technical specifications; customer and quality focused individual. Managed development teams using Scrum methodologies, test driven development and provided accurate project timelines.

Database

14+ years’ experience MS SQL Server 05/08/12 as Developer and DBA. 3 years. OLAP (Analysis Services), 9 years. MS Access, dBase, 2 years MySQL. Experienced with architecting large databases, hundreds of tables, 2+ Terabyte in size used with highly transactional applications. Proficient at using T-SQL: stored procedures, functions, triggers, views, foreign keys, indexes & constraints, DTS and SSIS packages. Solid understanding of relational database concepts including normalization and data integrity. High availability failover solutions such as clustering and log shipping. Database mirroring with SQL 2005 and 2008. MySQL to SQL Server integration and experience migrating data from Oracle to SQL Server.

Application Development

Utilized full-Microsoft Stack of technologies with over 7 years of programming experience using VB-6, 4 years. C# and VB.net, ASP.net JavaScript, 6 years Cold Fusion 1.5 to 7.0, VB Script, Application VBA. Experienced with developing a code base that is highly scalable and maintainable. Full life-cycle development, writing of requirements and building design documents. Created CLR assemblies in SQL 2005 using C# and deployed to multiple production environments.

Reporting

7+ years of architecting automated reporting solutions (front/back-end) for the user communities using Excel, HTML, Access 97-2010, Crystal Reports 8.5, 9.0, and with extensive use of VBA and VB. Extensive use of metadata for producing user-driven reports. These reports were displayed using Microsoft Reporting Services and ASP.net.

PROFESSIONAL EXPERIENCE

11/1999 – Present: Bizzapp Business Solutions – Westminster, CO

Senior Consultant, Architect, Senior Data Analyst

• Designed, developed and integrated application using the Microsoft full product suite.

• Consulted in various industry verticals such Health Care, Financial, Telecom, Inventory Control, Customer Relationship Management and Order management systems.

• Built and maintained strong business relationships with customers and vendors while increasing sales revenue by $2.5MM.

• Re-architected an online inventory management system previously built 8 years prior to SaaS, DaaS. The new system interacts with 3rd party accounting packages while utilizing remote handheld devices using web service layer. Increased field productivity by 10x.

• Project managed application development efforts utilizing offshore resources; delivered project on-time and under budget by $250K.

• Developed route delivery invoice and inventory system in windows CE for the Hand Held 7400. The application scanned bar codes, tracked inventory, invoices and transferred data to PC database and replicated data to corporate office in Canada. Utilized .Net technologies to communicate with hand-held devices and PCs.

10/2014 – 07/2015: Bank of America Merchant Services - Charlotte, NC

AVP, Data Governance & Business Controls

Oversaw enterprise data quality of over 120 data feeds coming from several sources from external partners and internal data sources to end user within finance and sales.

Managed development team utilizing full Microsoft stack of products to integrate and automate data feeds, applications and reporting through full-life cycle agile development.

Identified Key Business Elements and implemented data quality standards, monitoring data feeds both internal and external and building business control standards to ensure quality and accuracy of all data feeds through ETL process.

Developed SharePoint customer project intake forms to help track incoming projects with extensive workflows to manage the approval process. This increased resolution time and accountability by 3x and provided timely customer response rate by 5 days.

Consulted with other department-heads that have data and application needs to best determine existing applications or OTS evaluation and recommendations.

09/2011 – 10/2014: Bank of America Merchant Services - Charlotte, NC

AVP, Manager Business Information

Critical member of 2014 $5MM cost reduction challenge due to previous year’s successes.

Provide timely analysis of large datasets of both financial and transaction based information utilizing internal databases and flat-files.

Instrumental part of 2013 $4MM challenge; investigated outside systems such as VISA to identify areas of savings. Systems included VISA, TSYS, CBOS and FirstData Front-End processing systems with final saving to bottom-line of over $7MM.

Integral part of 2012 $6MM cost savings challenge team; identified inactive accounts in various platforms and systems. The final outcome exceeded expectations with saving close to $7MM in year to the bottom line.

Produced month-over-month billing reporting to help identify areas that were exceeding thresholds and metrics related to call-center activity.

Spearheaded the conversion of over 16K Discover accounts to new full-service platform, while maintaining and coordinating efforts with Project and Relationship Managers.

06/2008 – 06/2010: DigiData Corporation – Broomfield, CO

Manager Core Services/Sr. Production Database Administrator/Architect

Managed Core Services Team of 16 - C# and database developers to provide overall Vault services to eight different applications and millions of users throughout the world.

Utilized SaaS model allowed for multi-tenant & multi-lingual “Vault” environments, utilizing proprietary cloud storage to be accessed throughout the world. Different brandings were utilized for various customers and platforms such as Smart TV, IPhone & Android Smartphones apps, PC/MAC and various web browsers.

Developed and nurtured new customer relationships in with several – 3+ week trips to Madrid, Spain while managing new development efforts, upgrades and release cycles with development teams in both Europe and the United States.

Built an overall load testing strategy of the products, and coordinated these efforts with team in Broomfield while working from Spain.

Coordinated database and web services release from development to QA, staging and production reducing deployment time from 5 hours to less than an hour.

Implemented full-life cycle development using Agile methodology; Lead SCRUM meetings to keep projects on-track and within budget.

Developed a data warehouse using SSIS packages to transform information into staging tables then on to historical tables to then be used for customer reporting. Additionally added centralized warehouse for complete Business Intelligence (BI) data analysis.

Maintained 2-terabyte OLTP database in high availability for cloud storage applications. Performance tuned database by utilizing SQL Profiler, Performance Monitor, Query Analyzer and various other tools as required to maintain accountability.

Integrated new product ideas into existing web services and database design while maintaining data integrity while migrating to new structures.

Designed and built several SQL 2008 Active/Passive clustered environments for high availability systems utilizing RAID 5 and RAID 10 disk arrays for new clients running on Sun hardware.

PREVIOUS EXPERIENCE

Cartasite – Team Lead, Sr. Database Administrator/Developer

Lockheed Martin – Manager/Sr. Developer

Qwest Communications – Lead Financial Business Analyst

HealthTrans - Sr. Business Data Analyst/Programmer

Broadiant Corp – Technical Manager

IBM – Data Analyst and Reporting

EDUCATION

Bachelors of Science, Business Administration / Management (Double Major)

University of Phoenix at Tucson and Phoenix, AZ, Dec 1996 - GPA 3.5/4.0

Associate in Applied Science, Information Systems / Avionics Systems Technology (Two Degrees)

Community College of the Air Force, Maxwell Air Force Base, AL, Jun 1995

Honor Graduate - Information Managers School, Keesler, MS

CERTIFICATIONS/LICENSES/CLASSES

Maintaining a Microsoft SQL Server 2005 Database – Course 2780

Tuning and Optimizing Queries Using Microsoft SQL Server 2005 – Course 2784

Programming with Microsoft Visual Basic .NET – Course 2373

Java Programming Class – Course SL-275

Licensed to sell Health and Life Insurance in Colorado

Fast Track to Cold Fusion, Advanced Cold Fusion and Spectra (5day)

Microsoft Administration Class (1 day)

A+ certified

MILITARY SERVICE

United State Air Force, 2/86 – 5/95, Staff Sergeant / E5 – Honorable Discharge

PROFESSIONAL AFFILIATIONS

Steeplechase at Foxcreek HOA Board of Directors

Vice President and Community Manager

Contact this candidate