SUMMARY

• Exceptionally talented, value - driven professional offering 16 years of experience in database design, optimization, enterprise architecture and software development.
• Verifiable achievements using innovative techniques and leading-edge technologies to increase performance, efficiencies and interoperability.
• Excel in providing solutions that deliver outstanding business value. Uniquely adept in creating a novel blend of inventive solutions and products while pushing the envelope.
• Zealous for cutting-edge technological business solutions.
• Experience in the Microsoft software stack, database architectures and designs, data modeling, .Net technologies, web services, web and software development.

TECHNICAL SKILLS

Operating Systems: Windows Server /NT, XP, Vista, Windows 7, 8, 8.1, VMS

Software Microsoft SQL Server: 6.5-2012, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Service Broker, Virtual Server, Hyper-V, VMWare Server, IIS, Visio, XML Spy, Embarcadero ER-Studio/DBArtisan/Change Manager, ERWin, Red-Gate Products, Exchange 5.5-2013, Dreamweaver, Expression Web, MS Office, PostgreSQL

Programming Languages: C#, C++, C, Visual Basic (VB6), T-SQL, HTML, DHTML, JavaScript, VBA, Assembler, JQuery

Technologies: SOA, SAAS, SSAS, ETL, ASP.Net, Web services, WCF, WWF, Entity Framework, Linq, AJAX, MVC, SOAP, REST, XML, XSL, XSLT, XQuery, XPath, ADO, ADO.Net, ODBC, OleDB, DAO, Cisco IOS, OLTP, OLAP, Business Intelligence (BI), Star Schema, Data Warehouse/Mart, ODS

Services and Protocols: TCP/IP, Active Directory, DNS, WINS, HL7, DICOM, DHCP, SMTP, POP3, IMAP, FTP

PROFESSIONAL EXPERIENCE

Confidential - Westlake, OH

ETL Architect / SQL Developer

Responsibilities:

• SQL Server 2012 used as the backend data store with SSIS 2012 as the ETL platform
• Performance tuning and streamlining of processes and workflows.
• Loading of complex datasets and structures into SQL Server 2012 from flat files and PostgreSQL databases.

Confidential - Cleveland, OH

Data Architect / ETL Architect / DBA

Responsibilities:

• Data architecture, schema and environment analysis.
• Server performance analysis, tuning and issue mitigation
• Audit of current SQL environments providing recommendations and solution paths for nightly ETL workflow, backup/restore strategies, replication enhancements/options, logical and physical architecture and schema design.
• Consultant on planned move from departmental environment to ITD enterprise data center
• Advisor on architecture and DBMS upgrade ( /14) options, advantages and improvements
• SQL Server subject matter expert

Confidential - Richfield, OH

ETL Architect / Data Analyst

Responsibilities:

• Designed and implemented the required ETL strategy, stored procedures, functions, triggers and table schema.
• Developed the extract file specifications and layouts. Led coordination of specs with other teams.
• SQL Server and SSIS subject matter expert.
• Developed a unified application in C# for the business to manage all aspects of the benefits statement generation.
• Integrated a detailed logging and auditing scheme into the base extraction and application workflow providing unprecedented workflow, performance and troubleshooting metrics.

Confidential - Brecksville, OH

OLTP / OLAP / BI Consultant

Responsibilities:

• Designed and implemented database architectures, data models using ERWin and ER Studio and SSIS ETL strategies utilizing advanced SQL Server features consisting of partitioning, clustering, indexed views and filtered indexes.
• SQL Server Subject matter expert.
• OLTP, OLAP and BI architect and modeler.
• Troubleshooting of ETL, T-SQL, infrastructure and SAN performance issues.
• Championed the inclusion of change data capture for application notifications and data warehouse loading.
• Implemented a distributed Service Broker solution for inter-application communication using transport and dialog security secured using certificates.
• Developed the client website for realtime access to system load information, alerts, state, configuration and administration using C#, ASP.Net 3.5, AJAX and WCF.

Confidential - Hudson, OH.

Chief Data Architect, Data Modeler, SQL Server DBA

Responsibilities:

• Spearheaded SOA architecture initiative utilizing cutting-edge Microsoft technologies; WCF, C#, MVC creating a reusable common architecture focused on scalability, reliability and interoperability.
• Redesigned core database HL7 schemas and procedures reducing HL7 network traffic by 60%, support calls by 50% with performance gains over 500%.
• Introduced virtualization into the development and testing cycles. Allowed Testing to archive verification setups per application reducing setup time from hours to minutes.
• Development can be sand-boxed resulting in better concurrency.
• Initiated, developed and implemented a strategy to migrate the core products from the SQL Server 2000 platform to SQL Server 2008. Core product performance increased 10%-22%.
• Optimized core products data schemas, procedures, triggers and functions increasing performance up to 2500%.
• Championed the adoption of an SSRS architecture into the product lines to replace hard-coded Crystal Reports.
• Consequently standardizing reporting across products, eliminating custom development time and allowing customer self-service reporting.
• Advocated the adoption of SSIS as the primary ETL path for product upgrades and installations replacing a VB6 coded utility.
• Conducted SQL Server and T-SQL training for developers and select customers resulting in development that is more robust and stronger customer relationships.
• Key evaluator in selecting a French pharmaceutical application for integration into the product line allowing the company to move into the multi-billion Euro French hospital space.
• Retained high profile at risk customers by troubleshooting product installations.

Confidential - Westlake, OH

Data Architect, SQL Server DBA, Network Administrator, Senior Developer

Responsibilities:

• Key designer for delivery systems supporting real-time posting and invoicing increasing cash flow.
• Data Architect designing all data schemas for company initiatives; Order Management, Accounts Receivables, Billing, Invoicing, Customer Relations Management (CRM), Collections, Deliveries and Routing.
• SQL Server (6.5-2005) DBA charged with maintaining over 10 database servers housing over 100 databases with sizes up to 80GB in 7 development environments.
• Project lead and designer of an intra/extranet web portal framework and applications connecting geographically diverse districts for customer service, dispatching, batch auditing and real-time satellite messaging.
• Portals allowed access to company-wide customer data in SQL Server from a legacy VMS system synchronized nightly.
• Conceived and implemented a custom ASP.net based CRM solution supplanting a limited VMS application.
• Call center productivity rose 30% and call times fell 50% with representatives having access to all account information, real-time deliveries, truck statuses and transactions.
• Lead designer of an order management system focused on real-time entry, access to all fuel orders, route, and delivery information.
• The system was paramount to the success of the satellite communications initiative. CSRs and Dispatchers have a direct communications link to all drivers in the fields.
• Introduced SSRS into the company supplanting an antiquated HTML based reporting portal. The availability of critical BI information rose from nightly to real-time.
• Initiated the migration from DTS to SSIS for all ETL operations.