About:

This is a site I put together primarily to demonstrate my C# ASP .net MVC capabilities.

Please also check out the ttt link in the nav bar at the top for a TicTacToe game I made in DotNet Core.

And please check out the PhnToWrd link in the nav bar at the top to see a cool app I built in Python using Django.

Thanks

As Director of Data Operations, I was responsible for the entire IT infrastructure of a small company (Sharecare). I took their operation from a spreadsheet process to a database on a local server and then to a RackSpace remote server and then to AWS EC2. Along the way, I arranged for off-site backups, data warehouses for fully automated reporting, and transitioned the company to a new front-end, developed by an outsourced consulting company, also hosted in the cloud. In addition, I transitioned the company from single line data entry to bulk load from multiple purchased sources. At this company, and another company (Nike), I instituted hundreds of quality control processes to ensure that the data is sound. In many of my roles (Nike, SmartEnergy, OdysseyRe, PIA), I gathered information from all parts of the company, from the president on down, to understand the project goals.

I am a results-focused and self-motivated leader with many years of experience in all aspects of database and ETL technology. I am an expert, Microsoft Certified, database designer and administrator specializing in custom, complex ETL and in automating the generation of informative, actionable reports to identify important trends and track KPIs.  I have expertise in designing correctly normalized databases, data warehouses for efficient reporting, triggers, stored procedures and functions as well as user interfaces for easy and accurate input and output of data and automated, scheduled emailing of all reports.   I am extremely skilled with a wide range of reporting tools including Tableau, PowerBI and SSRS.

As a senior database developer and ETL and SQL expert, I am proficient with many different ETL tools including SSIS and Informatica and many database types including Snowflake, Redshift, Postgres, MySQL, SQLite, Oracle and SQL Server. I have expertise in building ETL processes incorporating complex business logic rules while importing data into SQL databases from many disparate sources.  I have written many queries and T-SQL stored procedures that utilize windowing functions, aggregation, CTEs, correlated sub-queries, etc.  At my companies I am the go-to person for query optimization and have identified and resolved many issues that were not detected by others.

In addition to data related capability, I am a proficient coder in Python, C#, Dot-net, Java, JavaScript, XML, HTML, CSS, VBA, PowerShell, VBS and other languages.  I have built many front-end applications both for my companies and just for fun.  I have implemented version control systems, including GIT, at several companies.  I have also made many AI models for my companies to identify new marketing opportunities that were previously undetected.  I am a team leader and contributor adding value to companies both as a member of a team, a team leader, and as an individual contributor.  I am experienced and comfortable working with people at all levels of a company from the lowest level up to the president.

As an experienced and successful project manager, I handle projects from end to end, gathering requirements from technical and non-technical customers and prospective users in an agile CI/CD environment and ensuring the results are exactly what is desired.  I am the documenter of choice at my companies and have received kudos for my excellent, clear, and professional customer-facing documentation.  I am proficient and experienced at generating Jira tickets, requirements documents, flow diagrams, database diagrams, Architectural Decision Records (ADR), meeting notes, how-to guides and data lineage as well as all the other artifacts that are necessary for successful project completion.  I am a quick learner and always willing and eager to take on new responsibility and learn what I need to know on my own time.