Current Skills: Development Areas: C and VB.NET windows services, console and client/server applications, ASP.NET, ActiveX .dll creation, COM Interop, 2 and 3 Tier program design and creation, dynamic and static form and report design and creation, PL/SQL - T-SQL - SQL embedding, aggregate functions, view creation, parameterized stored procedures, sub queries, joins and unions Languages: Visual Basic .NET, C and VB 6.0, ASP .NET 3.0, SQL, PL/SQL, T-SQL, XML, XPATH, HTML, JavaScript API's: ADO.NET, ActiveX, ADO, OLE Automation, CDO, Jet, COM, TCP/IP sockets, SSI, CSS, FileNET, IDM3.2, AJAX, JQuery Development Tools: Visual Studio Suite 2012, 2010, 2008, 2005, 2003 6.0 Databases/DBMS: Oracle, SQL Server, Access / SQL Server Enterprise Manager, Embarcadero RapidSQL 7.5 Contract Programmer/Analyst Project Work: Completed Excel macros for processing incoming tradeshow and accounting data Created new desktop application viewing/integrating GP Dynamics data and data from previous system Enhanced existing Finance Group ASP.NET data cube application: o Creating a show/hide functionality for some controls depending on host internal or external o Added logging using log4net o Changed some of the error trapping to bubble up exceptions to users Completed Data Cube desktop User Manager application o added password hashing o added autocomplete features for some of the fields Enhanced Finance Group ASP.NET Trade Show management application o Added datafilters for the data display and a JQuery panel to show/hide the data entry area on Trade show data page o Adding datagrid sort by column functionality and dropdownlist data population dependent upon previous user input on Accounting data input page o Added client-side data validation on both pages Learn Salesforce API minimal Completed VBA coding for updating/formatting spreadsheet from database and .csv file data Developer/Application Support Confidential Duties: Administrator for DocFinity document management system version 9.0 Maintain, modify and write new programs collecting incoming data streams documents and metadata Perform level 2 and 3 Service Desk analysis Maintain data reporting for Service Desk metrics Participated in process definition and creation for Service Desk Project Work: Created .NET 3.5 console application process for new data stream home inspection documents, insert documents and metadata into the document management system Created a .NET 3.5 console app to parse document data going out to print vendor to remove PPI personal information data .i.e. SSNs, telephone numbers and so forth Worked with one of our architects to create a new COM application to monitor email boxes, retrieve email and attachments, create a .pdf and insert into Docfinity Modified/Updated 2 existing .NET 2.0 applications accepting incoming data and documents to reflect new business requirements and to accommodate SQL 2008 update. Both these applications also insert documents and metadata into the document management system. Programmer/Analyst - Confidential Duties: Support of FileNET VB6/COM application document image viewer and its attendant index data via embedded SQL. Support of data feed applications and intranet web applications Project/code management via ClearCase and Mercury Creation and support of Web applications in ASP.NET C and VB Report creation and data analysis on FileNET document s metadata using PL/SQL and T/SQL RapidSQL RDBMS adhoc and persistent Management of client data images and metadata during new client account creation and existing client conversion Project Work: Convert VB.NET 1.1 data feed applications from services to console applications current company standards decree feed applications be amenable control by Control-M or Windows Scheduled Tasks function. These applications add and update imaging metadata via embedded SQL and stored procs. Upgrade of data feed applications from VB6/COM and VB.NET 1.1 to .NET 2.0 so they would have current and supportable runtimes. Web application ASP.NET to create barcodes images drawn by the .NET Image and 2D drawing functions as a bitmap and then converted to a .TIFF image via the MS Imaging codecs. Creation/maintenance of Backend application C for portal ASP.NET used for access to enterprise-level work item management Creation of 2 new feed applications projects were designed by our team have a middle tier engine which interacts with the database or document repository, sends emails, manipulates data and writes to the event log, with a dual front end 1 a console application amenable to control by Windows Scheduled Tasks function and 2 a GUI so the application can be run manually or registry settings can be changed and other similar tasks. Started analysis of VB6 code in the document image viewer for conversion to .NET Contract Programmer/Analyst Confidential Rewrite of Patriot Act Data Collection Touchpoint server side application An analysis of this application, which was crashing after running for 4 or 5 consecutive days, revealed the data engine was reproducing itself every time the application accepted data and eventually crashing the server. The data collection interface was rewritten to correct this. Data massage, normalization and insertion stored procedures T-SQL were written and implemented for the Touchpoint. Also worked with the in-house team to stream line the front end application used for data entry. Upgrade of several intranet websites from ASP 3.0 to ASP.NET Programmer/Analyst - Confidential Last project consisted of working on and supporting online application s called MediaQ. The items below represent some of the parts of the application Created a number of console applications / windows services to access and parse XML data via HTTP Webresponse in ASP.NET and data pushed to us by news providers. Constructed a hierarchy SQL Server stored procedures to store data in various databases for the above applications/services. Built various online applications to access data using ASP.NET and ASP 3.0, using PayPal for one time users. Created ASP.NET EmailAlerts application for registered users Converting MediaQ ASP 3.0 to ASP.NET ongoing at the time of my departure Also worked with Autonomy IDOL server Bayesian inference engine for data summarization, categorization and clustering. Developer - Confidential Created a web-based database application allowing customers with a funded account to search for data and produce reports html or ascii text conversion of CGI code/Msql back-end to ASP 3.0/Access 2000 back-end. Restrict access by login, customer account fund level Conversion of website from Unix .shtml format to Windows ASP 3.0. This site was originally designed to run on an Apache web server we took over hosting and since we're a Windows shop the markup language and code had to be converted to run on IIS 5.0. Added web-based database application Access back-end for their customers to store emergency data for the above site. Designed and implemented reporting container/application for Accpac accounting package using Visual Basic 6.0 and Crystal Reports 9 Developer Edition. Design VB form for user data input and CR9 viewer the form lists all reports in a given folder and presents input choices based on report chosen. Making database connections, using ODBC and ADO connection methods over the life of the project. Design multi-table database views and/or Crystal Queries maximize connection speeds where possible. The Visual Basic component is a parameter input/CR wrapper for all intents and purposes. The database component for this project was Accpac Pro, an accounting package. In it's original form it was a FoxPro 7.0 database, hence the ODBC connections and Crystal queries. Designed of an Access 2000 Project .adp with SQL Server 2000 back-end for Juris 2.04 Law Firm database application. Upgraded to SQL 2000 and stored procedures on the SQL server. Data conversion from Cobol-Based flat file format to SQL Server 2000 using proprietary tools from Juris and the SQL Server DTS application Conversion from VB 3.0 / Access 2.0 back-end to VB 6.0 / Access 20002Upgrade of application design from 2 to 3 tier