Skills

• 13 ASP.NET AJAX WinForms C VB.NET LINQ Web Services
• 6 MOSS 3.0 / SharePoint 2007/2010
• 18 SQL Server Oracle Sybase MS Access
• 15 SQL Server Reporting Services SSRS Crystal Reports
• misc VBA Excel Outlook WMI Infragistics DevExpress Enterprise Library
• 1980 - BSc Rutgers College of Engineering Engineering Club President

Work Experience

C VB.NET JavaScript ASP.NET MVC 4.5 SQL Server 2012 SSRS Developer Contractor Confidential

• Akcelerant provides a best-of-breed Lending Collections web site solution to over 500 Institutions Credit Unions in ASP.NET SQL Server 2012.
• 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.
• 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

Confidential

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

Confidential

• 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
• forms and access levels are stored in SQL Server 2012 tables
• Built basic lists and insert-update functions with ADO.NET in WinForms DataGridViews with right-clickable rows that persist Partial Partial Details data in SQL Server 2012 tables via stored procedures.
• Built Crystal Reports file to a strongly typed ADO.NET dataset with related tables from my SQL Server stored procedure with an XML list parameter to produce shipping labels prescription labels that look like what you see from your own pharmacy.
• Created a class inheriting from ComboBox to create a smarter Intellisense ComboBox so that user s keystrokes are limited to ComboBox members.

Confidential

• Performed software development tasks problem solving on a legacy ASP.NET web site.
• Enhanced C VB.NET Web Services JavaScript Oracle stored procedures packages.
• The assignment was related to my earlier work at Merck from August 2009 - August 2011.

Confidential

• Tools Visual Studio 2010 SQL Server 2008 Oracle 10g Subversion Sharepoint Designer
• Created the Identity Delta Tracker C Console Application Oracle Database.
• Reads an ADAM Identity Management Database. Inserts and updates Oracle Employee Records with different organizational and location attributes. Emails results and .NET software error stack trace info for pinpoint error tracing. Worked with the Control-M Team to schedule the console once a week.
• Created the Compliance11 Delta Tracker C Console Application Oracle Database.
• SQL selects the Identity Delta Tracker Database for employees pertaining to compliance. Inserts and updates Oracle Employee Records with different organizational and location attributes to mirror the vendor database. Performs C automation to create PGP Encrypt FTP transport results to the external Compliance11 Vendor. Emails results and .NET software error stack trace info for pinpoint error tracing. Worked with the Control-M Team to schedule the console once a week.
• Created the Compliance 11 Watch List Processor C Console Application
• Reads an Excel 2003 file into a .NET DataTable. Performs C automation to transform create PGP Encrypt FTP transport results files to the external Compliance11 Vendor. Emails results and .NET software error stack trace info for pinpoint error tracing. Worked with the Control-M Team to schedule the console once a week.
• Inherited the Compliance Risk Assessment Tool C WinForms Application.
• Persists state in a SQL Server 2008 Database. Took over the project on day 1 of first production release. Emails .NET software error stack trace info for pinpoint error tracing. Made extensive WinForms enhancements complex data editing and stored procedure additions. Rekeyed the database and stored procedures for multiple years of data.
• Created the Custom Web Utilities C IIS 7.0 web site and redirection sites

• User browses to http //compliance11 redirection site routes to web page.
• Or user clicks vendor email URL with query string info.
• Windows authenticated user is translated to email address vendor key.
• A URL is constructed with query string info then is PGP encrypted.
• Page redirects to encrypted URL to redirect auto login and place user at the emailed external Compliance11 vendor sub web page.

• User browses to http //Intellum redirection site routes to web page.
• Windows authenticated user is translated to keycode vendor key.
• A URL is constructed with query string info and POSTed to vendor.
• POST results are used to create URL to redirect auto login user into external Intellum vendor site.

• User loads 7 different Excel 2003 Excel files related to Employees in Buildings and Floors into a network share data source folder.
• Files are consolidated into one CSV file so employee errors and omissions can be easily identified eliminated from Building Floors systems.
• Emails results and .NET software error stack trace info for pinpoint error tracing.
• Created the SDE Timesheets C IIS 7.0 Web Site
• SDE is an EMC asset management tool with its own SQL Server 2005 Database. Created new SQL Server views functions stored procedures and CTE SQL. Create new IIS 7.0 WebForms project with user controls DataGridViews and ObjectDataSource binding to allow user to persist days worked on a monthly basis. Managers and CIO Office users can do the timesheets for their groups. Emails results and .NET software error stack trace info for pinpoint error tracing.
• Software support of legacy systems
• Performed content updates on Sharepoint 2007 pages using Sharepoint Designer document lists navigation lists and web part HTML content editors. Ran Unix scripts in Citrix windows. Performed basic FTP file management on Vendor folders.

Confidential

• Worked with stakeholders and lab workers to specify develop deploy the next generation of software solutions on MOSS 2007/2010 Sharepoint Portals ClickOnce WinForms ASP.Net WebForms Oracle 11g and SQL Server 2005 platforms.
• Devised Oracle SQL Server Common Table Expression CTE advanced SQL queries for SQL Server Reporting Services SSRS Reports deployed the reports as Web Parts to the Sharepoint Portal to show weekly sums/counts/averages for the latest n weeks . Reused the same approach that I posted back in 2008 on my http // Rodney Blog
• Authored deployed ClickOnce WinForms C 3.0/VB.NET applications that fetch persist data in a half dozen Merck Oracle and SQL Server Databases to optimize the workflow for pharmaceuticals tubes plates barcode labels lab workers researchers robots and the Merck Data Analyzer API. Wrote Oracle 11g and SQL Server 2005 stored procedures accessed via the .NET Enterprise Library. My windows and web solutions send workflow emails to research teams and send software exception emails with source code line numbers to the support team.
• Wrote software roadmap documents proposals to expose hidden functionality clarify database relationships show system data flows map out earlier software solutions.
• Enhanced deployed WebForms Excel Automation on the gcs.merck.com intranet.
• Created a new. AJAX ASP.NET 3.5 intranet web site for ordering compounds and other jobs that connects to my earlier order fulfillment solution in the lab. The users particularly like the AJAX CollapsiblePanels for organizing the Web UserControls on webpages.
• Research Built deployed C Visual Studio Projects to deliver SharePoint features pages web parts on a Hyper-V VM WSS 3.0 Sharepoint 2007 Team Site.
• Tools Visual Studio 2008 SQL Server 2008 Oracle 11g Visual Source Safe 2005

Confidential

• Treasury Department gave me an Excel file that needed to become an MSAccess database.
• Designed normalized database table structures.
• Coded and reused some C MDI WinForms and components that
• Run processes in separate threads
• thread can update the WinForm controls
• User can start other threads or kill the program cleanly
• insert the data into the hierarchy of database tables. view the database hierarchy in DataGridViews bound to BindingSources bound to DataSets with DataTables with DataRelations.

Confidential

• Designed coded an extendable C Web Scraper console application that automatically downloads an Excel file from a URL so that no daily human web session is needed.
• Studied the ORC Cameron Vendor FIX Protocol Server. Downloaded their C Source code sample application that streams FIX messages. At the time vendor did not offer a C .Net streaming version so I had to figure out a way to pass a C delegate to the C code so that the C vendor code could run C client applications to store portions of the stream into SQL Server tables.
• Re-factored four legacy C WinForms Clients that
• pass a delegate to my new C Managed Financial Exchange FIX Protocol Server. a delegate is a pointer to Client Logic that
• parses each FIX message trader account price quantity etc.
• updates a SQL Server 2005 database via ADO.NET.
• Authored a new C Managed FIX Protocol Server that
• encapsulates the Platform Invoke P/invoke marshalling of unmanaged C data passes Client Delegate through to my new C Unmanaged FIX Protocol Server.
• Authored a new C Unmanaged FIX Protocol Server that
• reuses the ORC Cameron vendor s C code for socket message streaming. runs the Client Delegate Callback logic to process each streamed message.
• Authored a detailed architectural whitepaper on the 3 classes of components above.
• Links FIX Messaging Protocol ORC Cameron Vendor First New York Securities
• Tools Microsoft Visual Studio 2008 SQL Server 2005 Visual Source Safe 2005

Confidential

• Inherited source code for ASP.NET C web sites web services window services Oracle 10g databases SQL Server 2005 databases MSI installers.
• Purchased workstations built VMware Virtual Machine VM development environments for Visual Studio 2008 Visual Source Safe 2005 Oracle 10g SQL Server 2005.
• Recruited interviewed hired four C SharePoint ASP.NET SQL developers.
• Directed developer task assignments software change management.

Confidential

• Joined a re-insurance web site development team
• Installed VM development environment with Windows Server 2003 SQL Server 2005 Visual Studio 2005 Source Gear Vault similar to Visual Source Safe .
• Authored a white paper and prototyped a website that produces Microsoft Word 2007 documents via Microsoft Office Open XML automation.
• Produced JavaScript CSS C ASP.NET SQL Server 2005 components for ASP.NET 2.0 reinsurance web sites.
• Produced SQL Server Procedures Views Triggers Excel Pivot Tables Charts
• Coded SQL Server scripts for Reference Table truncation and parent-child table scrubbing.

Confidential

• Implemented SQL Server Caching Notification on .
• Each web session reads database data from a shared memory cache.
• Radically improved site performance and user satisfaction.
• Minimized large expensive duplicate database data I/O.
• The cache is refreshed only when the database data changes.
• Authored a white paper on the solution for the other developers.
• Added cached data access Excel Export to more than 60 web pages. Authored C classes SQL Server stored procedures and triggers. Optimized enhanced and deployed UIs middleware and data tier.

Tools

Confidential

• Built ASP.NET 2.0 Oracle and Corda objects for AquaLogic/Plumtree web portals.
• Developed 20 portlets/webparts that communicate with each other.
• The navigational/tactical transmitter portlet sends session variables to the graphical/tabular receiver portlets.
• Produced 14 Corda graphs on ASP.NET 2.0 portlet pages
• With generic pop-up enlargement print e-mail Excel export
• Developed 12 ASP.NET 2.0 search/sort/insert/update portlets. Re-factored a C Web custom control to produce Gantt charts daily/weekly/monthly with cost summaries cost details.
• Coded Oracle 9i packages stored procedures functions via SQL Navigator 5.5.
• Authored the SDLC Design Document for the Project