SUMMARY:

• Over 20 years in information technology specializing in data architecture, management, development and analysis with proven success in architecting and implementing enterprise data systems. In - Depth knowledge and experience with data modeling, database development, database administration, ETL, reporting, infrastructure planning, architecture, and application integration services and strategies. Experienced manager of enterprise data architectures, network and email infrastructure projects, senior analyst and senior developer/consultant.
• 20+ years’ experience as a Database Architect, Database Developer, Database Administrator
• Experience leading and participating in technical design, development and implementation of solutions using SQL Server Database with other platforms and related technologies, SQL Server Integration Services/ETL, SQL Server Reporting Services
• Architectural experience in SOA and EAI enterprise solutions with web services
• Experience eliciting requirements, creating functional and technical specifications with diagrams for use cases and documentation
• Expert SQL Server database development configuration, administration and performance tuning
• Extensive experience with SQL Server data analysis and modeling
• Excellent communication, consensus building, troubleshooting, problem solving and analytical skills

TECHNICAL SKILLS:

Database Technologies: SQL Server (2012, 2008, 2005, 2000, 7.0) including SSIS, SSRS, Oracle database, .NET, C#, CLR, ODBC/OLEDB ADO.NET/Native client, linked servers, fluent in XML/XSLT, Service Broker.

Development Tools/Languages: Expert knowledge of T-SQL, Web Services, .NET C#, Agile project management, Microsoft Visual Studio, SQL Server Management Studio, Office technologies/APIs, Salesforce API integration.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Director, Database Operations

Responsibilities:

• Database Development and Administration using SQL Server 2008R2, RDBMS including SSIS, SSRS
• T-SQL development included stored procedures, functions, views, DDL, DML and deployment scripts
• Data modeling RDBMS enhancements to ETL processes for multiple internal use marketing databases
• SQLCLR .Net and C# development

Confidential, San Francisco, Bay Area

Database Architect/Developer

Responsibilities:

• Database Development using SQL Server 2008R2, 2014 RDBMS including SSIS, SSAS, SSRS, and Team Foundation Server
• T-SQL development included stored procedures, functions, views, DDL, DML and deployment scripts across five environments for in house applications and databases
• Data modeling RDBMS enhancements to multiple internal use databases
• Developed process for discovering schema differences across environments using MS-Build and SQL Schema Compare

Confidential, Sacramento, CA & New York, NY

Database Architect/Developer

Responsibilities:

• Designed and built Medicaid DSRIP database system managing provider and organizational participation and compliance in the federal program
• Analyzed requirement and built data models for databases and decision support systems for the Medicaid DSRIP initiative
• Built reporting infrastructure and data access and manipulation services using SQL Server 2014, .NET C# and the Codeworks Application Server software. Datasource connections included SQL Server to Excel and text files.

Confidential, New York, NY

Enterprise Database Architect

Responsibilities:

• Designed and developed many scalable, integrated, high-performance database solutions using Microsoft, Oracle, MySQL, Java and web service platforms and applications
• Led technical design and development of management reports to integrate data from multiple systems together for strategic and tactical analysis
• Solutions included data import/ data quality systems and data analytics systems related to the management of publisher subscription data with diverse internal application integration
• Solutions also included EAI and SOA designs utilizing web services - both SOAP and REST
• Designed, developed and implemented a high-performance access control DBMS for digital rights management and logging in real time but asynchronous OLTP and OLAP reporting systems using SQL Server, CLR and Service Broker message queuing that met transaction performance requirements (TPS) for speed and reliability
• Securely integrated many diverse legacies, homegrown, built and bought internal and external cloud-based applications and data sources connecting platforms like .NET, IIS, Apache, java, Oracle, MySQL, and multiple cloud-based vendors from e-mail solution providers to Amazon EC2 instances.
• SSAS data warehousing, build data models for subscription and access control analytics.

Confidential, CA & San Francisco, CA

Manager, Systems Administration

Responsibilities:

• Built and managed approximately 20 servers including DNS, web, database and load-balancing appliances
• Managed a team of three sysadmins and one network administrator that built and supported the initial BUZZSAW.COM web presence
• SME for maintaining enterprise, world-wide, Microsoft Exchange email network
• Designed architecture and implementation of database backup strategy, disaster recovery and high availability for SQL Server clusters and Oracle databases/data. These were based on SLAs from management as advised.

Confidential, San Rafael, CA

Consultant

Responsibilities:

• Responsible for Windows network server and desktop support
• Built and managed approximately 10 servers for their credit algorithms development group
• Designed and built automated desktop rollouts using sysprep
• Printers and desktop support
• Supported MS Exchange e-mail servers and network

Confidential, San Francisco, CA

Consultant, Senior Developer

Responsibilities:

• Built and managed approximately 5 Novell servers for their legal department
• Desktop support
• Printers support
• Responsible for Windows network server and desktop support, Email Network Architect
• Database development and reporting using Oracle and Borland Report Smith
• Designed and built their first enterprise and world-wide email network for Confidential Bank