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, BigData integration.

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 Bay Area

Consultant

Responsibilities:

• Database Development: SQL Server 2008R2, 2014
• T-SQL stored procedures, functions, views, DDL, DML
• Data modeling RDBMS enhancements
• SSIS, TFS, SQL Schema Compare

Confidential, CA

Consultant

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

Long term Consultant

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 legacy, homegrown, built and bought internal and external cloud-based applications and data sources connecting platforms like .NET, IIS, Apache, java, Oracle, MySql, Marklogic, SiteCatalyst, and multiple other cloud-based vendors from e-mail solution providers to Amazon EC2 instances and CRM datastores.

Confidential, San Francisco, CA

Consultant

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

PositionConsultant

Responsibilities:

• 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

PositionConsultant, Senior Developer

Responsibilities:

• Built and managed approximately 5 Novell servers for their legal department
• Desktop support
• Printers support
• Database development and reporting using Oracle and Borland ReportSmith
• Designed and built their first enterprise and world-wide email network for Confidential Bank