TECHNICAL SKILLS

• Senior, Hands - On, ASP.NET Core Web API MVC, Google Cloud, AWS, Azure, C#, VB.NET, WinForms, WebForms, MVC, SQL Server, Oracle, Teradata, Vertica, SSRS, Crystal Reports, Developer, Team Leader, Hard-Core Coder, System Integrator
• Seeking role as C#/VB.NET, Google Cloud, AWS, Python, SQL Developer remote or near West Chester/KOP/Philadelphia PA, Wilmington, DE
• 40 years of productive software architecture, design, coding & deployment.
• Inventive, focused, software designer & hands on, hard core coder.
• Effective leader & communicator who makes teams better & clients happier.
• ASP.NET Core Web API MVC, Google Cloud, AWS, AJAX, WinForms, Console, Web, C#, VB.NET, LINQ, Web Services
• Python, Django
• MOSS 3.0 / SharePoint 2007/2010
• SQL Server, Oracle, Vertica, Artiva, Sybase, MS Access, SSIS
• SQL Server Reporting Services (SSRS), Crystal Reports, Excel misc VBA, Excel, Outlook, WMI, Infragistics, DevExpress, Enterprise Library, Windows Server 2003, 2008

PROFESSIONAL EXPERIENCE

Confidential

Software Developer

Responsibilities:

• that consume Google Places and Geocode web services that consume AWS S3 Bucket and File Transport services that wrap the subscription costs to Google and AWS. that consumes my Azure services above.
• The DLL is consumed by SSIS for address correction.
• The DLL is consumed by a WinForms Demo Test Harness.

Confidential

Software Developer

Responsibilities:

• Designed the SQL Server database and wrote the ASP.NET Core Web API and C# Interfaces to parse Teradata, Oracle, and Ab Initio Data into my new SQL Server Database for data that could not previously be joined.
• Produced WinForms, consoles, shared components, SQL Server stored procedures & objects.
• Erwin Automation: Data Transformation, Erwin SCAPI, Erwin REST API, ModelMart, TreeView checkbox granulation and filtering of Erwin Entities & Attributes
• APIs: Sharepoint, Excel, Zip, Subversion, WebRequest, JSON
• Collaboration: SharePoint, application release notes, user guides, Bitbucket.
• Mitigated Excel and Erwin COM Object problems, to reduce memory leaks.
• Wrote complex SQL Server stored procedures that accept ADO.NET DataTable arguments via user-defined, database table types, to filter data via SQL JOINs to the table arguments:

Confidential

Software Developer

Responsibilities:

• Created VS2015 with DevExpress, VS2013 SSRS and SSMS 2016 for SQL Server Azure 2012 software development environments.
• Revised an SSRS report and associated SQL.
• Revised WinForms to layer in “Facility Id” handling.
• Created a new MDI WinForms Project with User Controls.
• Create a new .NET console application to extract, transform and load (ETL) JSON file data into legacy and new SQL Server tables.
• Created new .NET Middleware and SQL Server Database tables, indexes, foreign keys and stored procedures to persist the new JSON data.
• Coded blocks of stored procedure calls & SqlBulkCopy database work in .NET transactions.
• Figured out how to pass a long .NET DataTable to a stored procedure with a SQL Server User Defined Table Type parameter.
• Created the .NET template class hierarchy for the JSON structures so that each JSON file can be de-serialized into the class hierarchy via one VB.NET statement.

Confidential

Software Developer

Responsibilities:

• Compress all (e.g, TimeDetail files shown above) data into one database table
• Dump each file’s CSV data into a dynamically created, matching, temporary, all VarChar, temp table in SQL Server
• Automatically scan all the data rows to automatically determine the non-VarChar columns, i.e. bit, int, long, float, date, etc.
• Dynamically build & execute CREATE TABLE SQL to create each Typed database table like this: dynamically build and execute INSERT INTO SELECT statements to transform and transport the CSV Data into the Typed Tables with TRY CAST Columns like this:

Confidential

Software Developer

Responsibilities:

• Created two, new SSRS reports and associated SQL that…
• ODBC connect to InterSystems Cache databases used by Artiva CRM. with multiple parameters via hardwired or database driven values.
• Deliver default and multi-selectable, visible or not, report columns:
• Created a new C# console application framework with reusable classes and interfaces that performs four major functions:
• Creates an HTML formatted SMTP email report from a combination of Windows folder Disk statistics, and a stats file downloaded from Linux.
• Creates an email report from an ADO.NET DataTable converted to CSV and attached to the email.
• Reads an Excel XLSX file into ADO.NET DataTables converted to multiple CSVs attached to the email.
• Downloads 3 large zipped files from Linux, unzips the files, parses files into multiple files for different record types and chunks large files into smaller files based on configurable file sizes and record counts, and uploads the small files to Linux.

Confidential

Software Developer

Responsibilities:

• From scratch, I wrote all of the Python to meet the Vertica needs.
• Copied DDL & data to Oracle & SQL Server as a Python product line for future Vertica, Oracle, SQL Server DataBurst clients on Linux/Windows.
• Designed, refactored & created new Python & SQL components:
• Python for Cleaning Raw Tables.
• Python for Integrating Cleansed Tables.
• Python Workflow Engine for running SQL Blocks, Python Blocks and parent/child Workflow Blocks.
• Created a convention of configuration tables for reuse in any ODBC compliant, target, client database.
• The Python uses SQL Templates and dynamically assembles SQL, then executes the SQL to transform data.
• Raw Data -> Cleansed Data -> Integration Data -> DataMart Data
• I wrote a lot of Python:
• Python (PYODBC) SQL cursors and transactions.
• Python job and SQL statement logging with performance analytics.
• Python try-catch exception handling with emailed stack traces.
• Python case-insensitive Linux file handling.
• Python Introspection to allow table driven Python method dispatch and execution.
• As a Team leader, I drove the efforts of QA & another Developer/DBA.
• Software Tools:
• Python Tools for Microsoft Visual Studio 2010 (PVTS) to craft Python 3.4 and to run code on Windows and to debug on Linux.
• DBVisualizer, Oracle SQL Developer & SQL Server Management Studio to craft Vertica, Oracle & SQL Server database objects.
• WinSCP to move Python from my Windows PC to target Amazon Web Service (AWS) Linux servers.
• PuTTY to run Python in a Linux window.

Confidential

Software Developer

Responsibilities:

• Created, repaired & re-factored VB.NET, C# and SQL in UI, middleware & data tiers
• Refactored, large file, encryption-decryption buffering.
• Added and changed ASP.NET and JavaScript functionality, for example:
• Wrote a Custom Behavior.SelectionClientEvents pointing to new Javascript that forces an Infragistics.WebHierarchicalDataGrid.RowSelectionChanged server-side, postback, only if user clicked on the top Level Zero Hierarchy on DataGrid.
• Repaired old & created new aspx & ascx .NET & Infragistics components.
• Reorganized dozens of Try Catch blocks to correct exception bubbling to Logs and UIs.
• Created and modified SQL Server tables, relationships & stored procedures.
• Wrote SQL scripts to poke Production data, in cases where UI Screens are not available.
• Wrote self-aware, “bulletproof” SQL scripts to upgrade metadata table data, columns & constraints that drive different functions per Client, User, Role, UI, Version, etc.
• Backed up and restored SQL Server databases.