- Designing and developing new business initiatives- Acting CISO overseeing ISO 27001 compliance (March 2018-present)- Maintaining legacy ChainDrugStore.net data architecture (see previous job description below)Technologies: ASP.NET MVC, .NET Core, C#, Entity Framework, SQL Server, Azure

- Managing and improving PAC drug pricing architecture- Managing design and development of PAC Pricing Analytics Workstation web siteTechnologies: ASP.NET MVC, .NET Core, C#, Entity Framework, SQL Server, Amazon AWS

Software and database architect for SeniorLiving.net- Design and develop new web architecture based on ASP.NET MVC 4 and SQL Server 2012, using technologies and components including C#, Entity Framework, Unity, AutoMapper, and GitHub- Salesforce.com development including custom Apex classes and triggers, SOQL, and workflow rules- Maintain and improve existing LAMP (Linux, Apache, MySQL, PHP) web architecture- Administer Amazon AWS cloud hosting environment (EC2, S3, CloudFront, CloudWatch)- Develop data integration between SQL Server, Salesforce.com, and MySQL using SSIS and CozyRoc

- Supporting ChainDrugStore.net client (see previous experience)- Designing database architecture for commercial projects- Implementating data models using SQL Server 2008 R2- Implementatiing .NET data access layers using Microsoft Entity Framework- Managing CITI's Microsoft Partner Network membership

- Managed team of database developers and DBAs and worked with fellow managers to write technical requirements documents, create project timelines, provide man-hour estimates, establish project costs and budgets, and allocate development resources- Met with customers to provide a technology overview and document custom project requirements- Developed initial SQL Server database design working with project architect- Wrote C# .NET application to convert existing Oracle data into new SQL Server data model- Responsible for additions and modifications to database design, including maintaining ER diagrams, tables, views, constraints, indexes, schemas, and .NET data tier code in C#- Developed and optimized over 500 complex SQL stored procedures, user-defined functions (UDFs), and report queries- Made extensive use of XML functionality, including FOR XML, XML datatype, XPATH, XQUERY, XSD schemas, and XSLTs- Configured and implemented SQL Server full-text indexing, SQL Server Agent jobs, and operator email alerts using Database Mail- Created complex DTS and SSIS import and export packages to automate loading of data and file creation- Developed several web-based drill-down reports using SSRS- Wrote data-driven console application using C# and XSLT to create, queue, and send scheduled email and fax alerts to website users based on account preferences- Developed functionality using SQL, XML, and XSLT to submit pharmacy data to federal NPPES system to obtain HIPAA-mandated unique pharmacy identifiers- Wrote database build scripts using SQLCMD to deploy database changes in sync with front-end development builds; automated database build process in TFS- Managed migration from SQL Server 2000 to 2005, and from 2005 to 2008. Assisted with code migration from .NET Framework 1.0 to 1.1, from 1.1 to 2.0, and from 2.0 to 3.5- Debugged ASP.NET and C# code using Visual Studio .NET

- Managed several NCR Teradata and Microsoft SQL Server 7.0 environments- Developed and optimized complex SQL queries for updating and retrieving customer data- Designed data-driven PHP web sites for issue logging & report generation- Updated and maintained a Java-based web site monitoring application- Monitored Windows NT and Unix applications in a 24x7 operations center

Worked in Kyoto, Japan, office to help draft and evaluate U.S. and European patent applications for electronics and related technologies.

Worked alternating semesters during college (total work experience of one year) developing object-oriented, data-driven applications using Visual Basic, Borland Delphi, and Microsoft Access.