Resume Promote AWS, Azure, Microservices, .NET Core, API, MVC
Resume:
Resume, Rodney Vinyard, *** Lucky Hill Rd, West Chester, PA 19382
Phone/Text: 973-***-**** ******.*******@*****.***
Senior, Hands-On, Full Stack, Test Driven Software, Database, Developer, Architect, Hard-Core Coder
* 25+ years pro, US Citizen, Active US DoD Secret Clearance
o Bachelor of Science, Rutgers College of Engineering, Engineering Club President
o Web Forms/MVC 12 years, WinForms 20 years, Blazor 6 weeks.
o C# 19 years, VB6-VB.NET 23 years, Python 2 years, Java 5 months.
o SQL Server 27 years, Oracle 9 years, Vertica 6 months.
o Azure 5 Years, AWS 8 months, Cloud Foundry 3 years.
o API Microservices, .NET Core 5 years, MVC 5 years, PowerShell 5 years
o Excel & VBA 15 years, Power Apps 4 months, SailPoint 5 months, LoanIQ 1 year
o Spark & Databricks & Notebooks 2 months
Can do
* Inventive, focused, software designer, hard-core coder, solution provider.
* Effective communicator & writer, who makes teams better & clients happier.
* Click here to see Rodney's LinkedIn Profile
* Click here to visit Rodney's Git Hub
Software Tools Experience
* ASP.NET Core Web API, REST microservices, Google Cloud, AWS,
* Blazor, MVC, AJAX, Razor, DHTML, CSS, WinForms, Console
* C#, VB.NET, LINQ, Python, Flask, Databricks, Spark, Java, Java Script
* SQL Server, Oracle, Teradata, Vertica, SSIS, Entity Framework, ADO.NET
* SSRS, Crystal reports, Excel, ZedGraph, Corda, Infragistics, DevExpress
* Azure DevOps, Git, GitHub, BitBucket, Subversion, Perforce/P4V, TFS, SourceSafe
Work Experience:
Software Developer .NET ASP.Net Web Forms & SOAP Services, SQL Server 2022; CyberArk, https://www.intellibridge.us/ remote, 10/24 – current
IntelliBridge is a sub-contractor with the US Department of Agriculture (USDA). I was background checked and obtained a Public Trust PIV Access Card and USDA Laptop PC (GFE).
Produced a 60 Page USDA GFE Developer Setup Guide with CyberArk steps.
4 days of SAFe Agile training with 80 USDA Teammates. What is SAFe Agile?
I worked on a USDA, home grown, ASP.NET 4.8, SOAP Services, Visual Studio 2022, C# Project that centralizes the USDA Users and Roles in one SQL Server database, for dozens of other USDA software applications.
I managed a Jira Story and delivered automation, for Transform web.config
1. into a .NET ASP.Net Web Site project, and into a SOAP Web Services Project,
2. requiring new Transforms for the base Web.Config, shown below.
a.
3. Out of the box, Visual Studio, can apply each Transform during the Publish operation, but the new USDA Build CI/CD Process, needs to apply each Transform during the Build process, so I changed each .CSPROJ file with a new Configure Transform method, as follows:
a.
I managed a Jira Story and delivered new C#, to measure timings of every nested C# subroutine that each SOAP web service runs. I created a new SQL Performance Logging Table & C# Code that can multithread test load my Timer Wired, SOAP Services beyond expected Production loads, to find inefficient data fetches that need refactoring.
Software Developer .NET Core 6.0 Web API, Bootstrap & jQuery UI, SQL Server 2022; Dataverse, Power Apps, Power Pages, Power Automate – https://dynamotechnologies.com remote, 1/24 – 4/24
Dynamo Technologies is the prime contractor with the US Department of Agriculture (USDA) Forest Service. I was background checked and I obtained a Public Trust PIV Access Card and USDA Laptop PC (GFE).
Lead developer for the public https://plantatree.fs.usda.gov/ web site.
* I used Visual Studio 2022, SSMS & SQL Server Express to run the .NET Core 6.0 Web API, Bootstrap & jQuery site and database locally.
* I created a USDA GitHub branch and to produce a JQuery Version Upgrade via packages.json and npm install and GitHub merged the branch into AWS CI/CD Development, Staging & Production.
Lead developer for the internal Emergency Medical Services Dataverse Model Driven, Power Platform Application.
* Owned the DevOps SDLC for Power Apps, Power Pages (Portal Management), Power Automate & Dataverse, Forms, UIs, Workflows and Processes.
* I solved 30 GitHub problems in Dataverse Tables & related Power Apps Forms, Power Pages HTML JavaScript, Liquid Script & Power Automate Cloud Flows.
* Used Power BI Desktop to query the inherited, not-so-normalized Dataverse.
Via Stack Overflow mm/dd/yyyy, produced a RegEx for mm/dd that I could not find anywhere else:
mm/\.dd with Feb 29
^((0[13578] 1[02]) 0[1-9] [12][0-9] 3[01])) <-31 day months
((0[469] 11) 0[1-9] [12][0-9] 30)) <-30 day months
((02) 0[1-9] 1[0-9] 2[0-9])) <-29 day months
$
mm/dd - forward slash '/' only, no line feeds
^((0[13578] 1[02]) 0[1-9] [12][0-9] 3[01])) ((0[469] 11) 0[1-9] [12][0-9] 30)) ((02) 0[1-9] 1[0-9] 2[0-9]))$
Figured out how to use Visual Studio Code to import all of the Azure-based Power Pages HTML JavaScript, Liquid Script files, into a local folder, to make it easy to use Visual Studio Code to ‘find where the previous Power Platform developer coded & customized everything over the last 2 years’:
i. pac auth create -u https://ClientPowerPortal.dynamics.com
ii. pac paportal list -> result -> <ID>
iii. pac paportal download --path C:\folder -id <ID>
Software Developer & Architect - Blazor, .NET Core 6.0 Web API, Asp.NET Web Forms, ADO.NET, SQL Server 2022, Azure DevOps – https://www.gritterfrancona.com/ remote, 8/23 – 12/23
Gritter Francona is a prime contractor for a project for the US Government Veterans Administration (VA). I was background checked, and I obtained a Public Trust PIV Access Card and VA Laptop PC (GFE).
I spent the first 6 weeks, prototyping Power Apps, Blazor, .NET Core 6.0 Web API, with Swagger, Nswag. VS 2022 & VS Code, via a deep dive tutorial: https://subscription.packtpub.com/video/web-development/978**********
Created an Azure DevOps Git Repo as a Demo, and repaired a legacy, on premises, Windows Server Git Repo for an existing code base.
Used Azure DevOps Boards, SSMS & VS2019 to make changes to an ASP.NET Web Forms, ADO.NET 2022 ASP.NET Web site and SQL Server database.
Invented a data driven Progress Bar for an ASP.NET Web User Control. The prototype database table below, is all Boolean columns, for yes/no, Green/Red, but you can use other data types, for more elaborate progress decisions and bar colors, in the C# middleware code, as shown below:
* Learned javascript/ajax driven popup forms, and text box character counters.
* Schooled the developer manager on how to correct his restrictive text boxes to allow any characters into Nvarchars throughout the database storage and thru the reporting scafolding, very straight forward to retro-fit.
* Noticed that their error handling only informs poor user, so offered an easy, to retro-fit, auto-email of .NET Exceptions, on https://stackoverflow.com/questions/41626307/how-to-continue-page-display-when-catching-page-error-in-asp-net sends email:
Software Developer Azure, Java, SailPoint, SQL Server – http://zigabyte.com/ remote, 1/23 – 6/23
Zigabyte is a subcontractor for the Identity, Credential and Access Management project for the Department of Defense (DoD), Defense Information Systems Agency (DISA).
I was background checked, and I obtained a transferable US Government Secret Clearance, Government Common Access Card (CAC) and DoD Laptop PC (GFE).
Jira Item 1 – I translated a Windows PowerShell script, to Java that HTTP Posts with an SSL Certificate, receives & parses XML fields to a SailPoint client. I added a separate test driver class, to run unit and integration tests.
Jira Item 2 – I created a SailPoint Rule in Java Bean Shell Script that
1. Reads Java SQL Server view records into Resultsets.
2. Creates new SailPoint Workgroups named by SQL record fields.
3. Retrieves SailPoint Identity.Person via SQL EmployeeId.
4. Assigns new SailPoint Workgroup, to SailPoint Identity.Person.
5. Calls SQL Server Stored Proc, to update SQL database.
6. Calls my 3 new SailPoint Rule libraries for reusable 1) Logging, 2) SailPoint Application Configuration JSON Parsing, and 3) SailPoint Identity.Person
Updated Agile Jira Work Items, and operated Java Eclipse IDE, SailPoint IDE and SQL Server Management Studio (SSMS) tools in an Azure Windows Virtual Machine.
Software Developer C#, SQL Server – http://echo.com/ remote, 11/2022 – 12/2022
Created Subversion (SVN) Branches to checkout C# Applications, to get clean builds, for code changes and Unit/Integration Test additions and runs.
Migrated some database objects from an Old SQL Server Database to a new Target Database.
1. Created a SQL Script to populate an empty sandbox Target database with Legacy Objects and New Refactored Objects.
2. Managed everything in a Visual Studio Database Project & Subversion (SVN).
3. Refactored the “flat”, Non-Normalized configuration tables, shown below.
4. Tested to verify that the Non-Normalized and Normalized stored procedures result identically.
Software Developer & Architect Azure Databricks –?https://centricconsulting.com/ remote, 9/26/22 – 10/7/22 (2 weeks)
1. Produced a Detailed Design Document / Roadmap below.
2. Performed hands on, PySpark / Python, Azure Databricks Notebook development
3. Talked to people and updated Azure DevOps Cards in Daily 9am Zoom Scrums.
Databricks ETL Via Legacy Stored Procs - Detailed Design
Goal:
1. 23 Databricks DataFrames need to be
a. Populated from CSV files in Azure Blob Containers.
b. Transformed with the same algorithm that 23 SQL Server #TempTables are transformed via Legacy SQL Server Stored Procedures SPROCs.
c. Downstreamed to an unspecified Azure Delta Lake instance.
Transform Algorithm Options:
1. Detailed Refactoring - Convert all micro SQL details of Legacy SQL Server Stored Procedures to PySpark, Not-SQL-Equivalents for DataFrames
2. Lift & Shift - Read 23 Azure Blob Container CSV Files into 23 Azure DataLake SQL Tables and run the SPROC SQL from Databricks Notebook SQL Cells
3. I was given 8 weeks to finish, produced detailed design in 2 weeks, I advised them that only Lift & Shift could be done in remaining 6 weeks.
Angular & Databricks Home Projects – 8/2022 – 9/2022
1. I spun up a Databricks Cluster on my Azure account
a. Created Azure Databricks Notebooks
b. Created Resilient Distributed Dataset,
c. Created DataFrame,
d. PySpark SQL queries.
e. looked at .NET for Spark
https://learn.microsoft.com/en-us/dotnet/spark/what-is-apache-spark-dotnet
2. Produced an Angular 13 and .NET Core 6.0 solution on my PC:
Federal Home Loan Bank of Cincinnati - Software Developer - Azure DevOps, C#, SQL Server 2016 – remote, 5/22 – 7/22
The Software Upgrade Team operates on all software applications, separate from the Individual Application Teams, for Feature and Bug enhancement Software Development Life Cycle, accross software applications.
The Software Upgrade Team operates in Azure DevOps for:
1. Agile Sprints
a. Daily Standups
b. Sprint Planning & Review
c. Feature Specification, Status Management, and Workflow
2. Source Code Branching, Merging, Pull Request Reviews
Performed Enhancements:
1. Added New Code Coverage Automated Tests for new Features in Test Driven Development (TDD) Visual Studio Framework.
2. Performed Azure DevOps .NET Application changes in VS2019 and VS2022:
1. .NET Framework Version Upgrades, 4.7.2 -> 4.8
2. Log4Net conversion to Serilog,
a. NuGet package changes and C# changes
b. Database Project changes
3. Wiki document upgrades for Developer Application Setup Procedures
a. Development setup for IIS, RabbitMQ on Docker, databases, etc.
Infinera – Software Developer - C# and VB.NET, WinForms, SQL Server 2008, SSRS 2017 – remote, 8/2020 – 12/2021
Infinera manufactures electronic components, thru a very large SAP logistics operation to Receive and Ship. All manufacturing and test data is in dozens of SQL Server 2008 databases. I inherited a C# and VB.NET WinForms Workflow Application stored in Git-BitBucket, that connects the databases, so that technicians can get through their manufacturing & testing workflows.
New product lines often start, new features are often requested, so I delivered detailed specification documents & meetings, delivered SQL Server database configuration changes, and delivered One Click, software releases.
I added a new Release Notes document, available to Users in the UI, to illustrate application changes and who needed them, very helpful for new folks learning the learning the software, and for finding earlier ZedGraphs that were done, similar to some future ZedGraph that they will need to develop. ?
For the first 15 years, the Workflow Application had one set of databases on one network, with server names and credentials, hardwired throughout C# and VB.NET. A need arose to have the app run a second location, within a few weeks, so pretty quick, I had to conjure a way to un-hardwire the settings, to dynamically run from 2 sets of configured settings.
Created dozens of ZedGraphs, from fixed, parameterized SQL blocks, and from a dynamic, “pick tables and fields” UI. Engineering Level Users, are SQL savvy, so in dozens of places, I made the SQL available on the UI, next to the tabular or graphical results, that they can use to tweak & run their SQL
Converted six SSRS 2005 RDL files to VS2017 on SSRS 2017, one RDL with a new conditionally displayed field, in a new Perforce/P4V Workspace code repository.
Portland General Electric – AWS Architect & Developer - Portland, OR (work from home), 2/2021 – 3/2021
* Led a group of legacy developers with no Amazon Web Services (AWS) Experience.
* Discussed AWS Development strategies EC3 vs Lambda, and settled on a Python, Lambda and Step Functions State Machine development strategy.
* Assigned Lambda tasks for
o Python 2 Factor Authentication with a vendor
o Python JSON to XML Transforms
o Python file drop to sFTP for PeopleSoft.
Project Management Institute – Software Developer - ASP.NET Core Web API MVC, Python, Google, Microsoft.Graph, Microsoft 365, Azure, microservices, WinForms, C#, SQL Server, JSON, GIT, Newtown Square, PA, 12/19 – 10/20
With Visual Studio Code,
* produced a Python Flask RESTful microservice
o that wraps a legacy Python machine learning process
o that runs in a Docker Linux container
With Visual Studio 2019,
* produced ASP.NET Core 3.1 Web API RESTful microservices on Azure
o that consume Google Places and Geocode microservices
o and returns the JSON to the Azure caller
* produced a .Net Framework 4.5.2 DLL
o that consumes my Azure microservices above.
o The DLL is consumed by SSIS for database address correction.
o The DLL is consumed by my WinForms Demo Test Harness.
* produced a .Net Framework 4.5.2 WinForms test harness, that lets a user
o enter any global address into my DLL
o receive all of my DLL and Web API JSON result data
o read addresses from UI, Excel, CSV or SQL Server
o write Google corrected addresses to UI, Excel, CSV or SQL Server, multi-threaded or not
* connected a local Microsoft.Graph application to Azure Active Directory & SharePoint 365:
o Created a SharePoint 365 Site
* Name = rodneyworld.sharepoint.com
* Via Microsoft user: ******@***********.***********.***
o Created a .NET Core Console App
o Connected rodneyworld.sharepoint.com to Azure Active Directory
o Connected .NET Core Console App to Azure Active Directory
o .NET Core Console App can read and write the rodneyworld.sharepoint.com folder contents, as shown below:
– JP Morgan Chase Software Developer - ASP.NET Core Web API MVC, microservices, Google Cloud, Cloud Foundry, WinForms, C#, VB.NET, SQL Server, Teradata, Oracle, JSON, Erwin, Excel, API, Subversion, Bitbucket, GIT Wilmington DE, 4/17 – 4/20
Produced ASP.NET Core 2.0 Web API RESTful microservices
* microservices that run on a schedule to read SQL Server Data.
* microservices that deliver the data as HTML in SMTP Email.
* Used Cloud Foundry to push-publish microservices to the JP Morgan Chase GAIA cloud.
Produced .NET Core 3.1 Console Application
* that reads data from Ab Initio, Oracle & Teradata, that cannot be easily JOINed.
* and bulk loads the data into a SQL Server where it can be easily JOINed.
Took ownership of a C#, VB.NET, WinForms application that standardizes the workflow, analysis & approvals of Erwin Models across business units and teams.
* Took command as DBA, and designed the SQL Server database
* 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:
*
Weyandt, LLC – Software Developer - C#, VB.NET, SQL Server & SSRS, remote, 8/16 – 1/17
o Created VS2015 with DevExpress, VS2013 SSRS and SSMS 2016 for SQL Server Azure 2012 software development environments.
o Revised an SSRS report and associated SQL.
o Revised WinForms to layer in “Facility Id” handling.
o Created a new MDI WinForms Project with User Controls.
o 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 – Software Developer - C#, SQL Server, remote, part time, 10/16 – 12/16 (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 – Software Developer - C#, InterSystems Cache Database & SSRS, Ambler, PA, 4/16 – 6/16
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.
2. Delivered 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 – Software Developer - SQL Server, Oracle, Vertica, Python, East Norriton, PA, 7/15 – 1/16
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 – Software Developer – C#, WebForms, AJAX, JavaScript, ASP.NET, ADO.NET, Oracle 11, Collegeville, PA, 5/15 – 7/15
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 & packages, TreeView controls, Datagrids, and complex LINQ search filters to apply Assesments to Product hierarchies, across Market hierarchies.
I delivered new software scaffolding for 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.
Bracket Global – Software Developer – C#, VB.NET, WinForms, Web, JavaScript, ASP.NET, ADO.NET, SQL Server 2008, Wayne, PA, 11/14 – 3/15
Bracket Global delivers Windows based and Web based software solutions and services for Pharmaceutical Clinical Trials customers. www.bracketglobal.com
* 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.
Tools
* Visual Studio 2010
* SQL Server 2008
* SQL Server Profiler
* A Visual Studio .NET “Lite” SQL Profiler
* with VB.NET Source Code & executable
* for test PCs with no SQL Server Profiler tools.
* Team Foundation Server (TFS)
* to link User Stories and Bugs to Source Code Changes
* to review histories of TFS Changesets
* Fogbugz
Training & Documentation
* Completed 85 Master Control Training Modules related to Pharmaceutical Clinical Trials Processes, System Development and Software Development
* Conformed to customer standards for documenting issue resolution in TFS & Fogbugz.
Akcelerant – Software Developer – C#, VB.NET, JavaScript, ASP.NET, MVC 4.5, SQL Server 2012, SSRS, Malvern, PA, 9/14 - 10/14
Akcelerant provides a best-of-breed, Lending & Collections web site solution to over 500 Institutions & Credit Unions in ASP.NET & SQL Server 2012. www.akcelerant.com
I leveraged Visual Studio 2013, SQL Server 2012, SSRS, AccuRev, FinalBuilder, and homegrown tools to feed SQL scripts, web pages, middleware, metadata, and SSRS reports, into “continuous integration streams" for multiple versions of the Akcelerant product lines.
Delivered an SSRS Report & stored procedure to deliver an SSRS Bar Chart Report with Date Range, Daily/Weekly/Monthly parameters and a multi-selectable checkbox parameter like this:
PROCEDURE [duhSchema].[duhStoredProc]
(
@PeriodType varchar(10) = 'Daily' --'Daily' or 'Weekly' or 'Monthly'
,@StartDate as Date
,@EndDate as Date
)
--strip time from start date
set @myStartDate = DATEADD(dd, DATEDIFF(dd, 0, @StartDate), 0)
--strip time from end date & set to tomorrow at 12am
set @myEndDate = DATEADD(dd, DATEDIFF(dd, 0, @EndDate), 0)
set @myEndDate = DATEADD(dd, 1, @myEndDate)
Cloned & re-factored a .NET Nuke ASP.NET.aspx page to
* Upload files into 2Gb varbinary(max) fields in a new database table that I scripted.
* JavaScript validate for the 2Gb file size limit.
Authored Feature Design Documents and scheduled and led QA Feature Handoff meetings.
Used OnTime & Replicon for
* Feature Status, Collaboration, Workflow, & Time Reporting
* Defect Status, Resolution, Collaboration, Workflow, & Time Reporting
* HR-Payroll Reporting
Dow Chemical – Software Developer – C# 4.5, SQL Server 2008, JSON, WinForms, Newark, DE, 4/14 - 6/14
Dow Chemical Engineers use a new C#, WinForms application to model materials properties for the manufacture of semiconductors.
Fixed bugs & produced new functions, new Nevron and Microsoft charts, & new stored procedures in Visual Studio 2012 and SQL Server 2012 Management Studio.
* Collaborated with other software developers via Team Foundation Server (TFS)
* authored and resolved User Stories
* merged software changes into Main and Local software stores
* Deployed multi-selectable ListBoxes on WinForms that
* display results statistics in the Chart control & DataGridViews
* pass XML to ADO.NET stored procs to flexibly search "tblXXX "
exec storedProc '<DocumentElement><Table0> <id>123</id><id>456</id> </Table0></DocumentElement>'
-- storedProc
DECLARE @tempIdTable TABLE(id int) --
if @parameterIdListXML is null
--XML is null, so get all Ids from tblXXX into @tempIdTable
insert into @tempIdTable
select distinct Id from [dbo].tblXXX
else
--XML not null, User multi-selected Id subset, so get XML Ids into @tempIdTable
INSERT INTO @tempIdTable(id)
SELECT row.value('(id)[1 varchar(max)')
FROM @parameterIdListXML.nodes('DocumentElement/Table0') as Tabx(row)
end
Select * from tblXXX where Id in (select id from @tempIdTable)
* Used LINQ to Objects to parse parent-child DataTables into hierarchical, classes
* Deserialized JSON data files into hierarchical, JSON tagged classes
* Displayed the scientific, data hierarchies in a TreeView.
* Revised exception handling to automatically email screenshots to development team.
Specialty Rx – Software Developer – C# 3.0, SQL Server 2012, Crystal Reports, Active Directory, WinForms, Roselle, NJ, 3/13 - 3/14
Specialty Rx pharmacists fulfill prescriptions and log the workflow in vendor software, but the vendor software does not meet Specialty Rx's partial fulfillment needs. For example, if patient needs 30 tablets, and we only have 12 tablets, we send the 12 tablets now, but new software needs to log the 12 tablets & manage the eventual fulfillment of the other 18 tablets.
The software manager and I worked together at Davidsohn in 2007, so he called me again in 2013. We collaborated on and documented his software specifications and I produced the new C# WinForms solution and SQL Server 2012 tables and stored procedures.
* Built the WinForms in a Multiple Document Interface (MDI)
* with custom logic to allow just one instance of each child form type
* that controls full, read only, or no access privileges per child form
? user and group names are managed in Active Directory
* Gets data from Active Directory
Contact this candidate