Candidates About

Rodney Vinyard

Senior, Hands-On, .NET, Python, C#, VB, WebForms, WinForms, XML, SharePoint, Oracle, SQL Server, Vertica, SSRS, Crystal Reports Developer, Team Leader, Hard-Core Coder, System Integrator

·         Seeking C#/VB.NET, Python, SQL Developer

·         Seeking remote job or near West Chester/KOP PA, Wilmington, DE location.

·         37 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.

·         Click here to visit Rodney's Blog

Yrs     Skills

---      ------

16    ASP.NET AJAX, WinForms, Console Apps, C#, VB.NET, LINQ, Web Services

 1     Python, Django

 6     MOSS 3.0 / SharePoint 2007/2010

21    SQL Server, Oracle, Vertica, Artiva, Sybase, MS Access, SSIS

18    SQL Server Reporting Services (SSRS), Crystal Reports, Excel

misc  VBA, Excel, Outlook, WMI, Infragistics, DevExpress, Enterprise Library, Windows Server 2003, 2008

1980 - BSc, Rutgers College of Engineering, Engineering Club President

Work Experience:

Weyandt, LLC – C#, VB.NET, SQL Server & SSRS Developer, remote, part time, 8/2016 – 1/2017 

• 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.

Created new JSON Schema files and .NET code to validate the JSON Data.

RCM Technologies, LLC – C#, SQL Server Developer, remote, part time, 10/2016 – 12/2016  (120 hours total)

I created a C#, “CSV -> SQLServer Transformer", with a WCF Service Library that can service Windows or Web Forms. 

Let’s say a person, can "design/specify a Data Warehouse", by simply exporting a group of "views as CSV", into one file folder:

Big Picture:  My automation automatically creates the Data Warehouse & transforms and transports the data from the CSV folder shown above.

Details: My automation can allow a user to create and point to Database Schemas where the CSV data will be transformed and transported.

My “Schema-Table focused” stored procedures do all of the database work, except for the dynamic CREATE TABLE SQL building, easier to debug in C#.

My automation loops thru the CSV folder, with CSV files as shown above to

• 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:

Radius Global Solutions – C#, InterSystems Cache Database & SSRS Developer, Ambler, PA, 4/2016 – 6/2016

Created two, new SSRS reports and associated SQL that…

1. ODBC connect to InterSystems Cache databases used by Artiva CRM.

with multiple parameters via hardwired or database driven values.

1. 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:

1. Creates an HTML formatted SMTP email report from a combination of Windows folder Disk statistics, and a stats file downloaded from Linux.
2. Creates an email report from an ADO.NET DataTable converted to CSV and attached to the email.
3. Reads an Excel XLSX file into ADO.NET DataTables converted to multiple CSVs attached to the email.
4. 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.

HighPoint Solutions – SQL Server, Oracle, Vertica, Python Developer, East Norriton, PA, 7/2015 – 1/2016

I re-engineered the HighPoint Solutions DataBurst data warehousing software product into Python to fit into Teva Pharmaceutical’s Vertica database environment. 

• 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.

Pfizer – C#, WebForms, AJAX, JavaScript, ASP.NET, ADO.NET, Oracle 11 Developer Contractor, Collegeville, PA, 5/2015 – 7/2015

Pfizer Business Operations teams use a mission critical, Products Dossier Web Application hooked to an Oracle Database that manages all Product Portfolio Hierarchies, in Development or in Commercial Release, across all Global Markets.

I delivered new & changed web pages, user controls, classes, data models, Oracle stored procedures, TreeView controls, Datagrids, and complex LINQ search filters to apply Assesments to Product hierarchies, across Market hierarchies.

I delivered software scaffolding with Oracle, C#, ADO.NET, LINQ for Entities, AJAX, JavaScript and Team Foundation Server (TFS).

I delivered strategy, specifications & software development, collaborative demos, documentation, and communications for local and offshore teams.