SUMMARY

I am an architect, lead software engineer, DBA, and periodic CTO who is able to analyze and assess business practice and flow, identify problems, and offer comprehensive solutions, as a part of general requirements analyses. My four decades of IT experience encompasses most roles and all aspects of system lifecycles. I have architected and engineered enterprise and general businessthin web and thick desktop clients, including their services, besides applicationsand data warehouses. Likewise, I have developed significant new technologies in unfamiliar arenas. I quickly absorb and use new languages, tools, and methodologies. As an exacting coder, I also provide high-quality, easy-to-use, consistent, sustainable, and clean results, which are timely and within budget. I also have ownership, executive, management, accounting, technical writing, graphics and publishing experience. My character, integrity, reliability, strong work ethic, and quality results are mentioned in available reference letters.

Experience

Confidential

Web UI Architect and Developer

Environment.VS 2013 Ultimate, TFS online, JIRA Windows Server 2012 R2 Hyper-V IIS 8 and Express CouchDb and CouchApp SQL Server 2014 Enterprise ODBC C .NET 4.5 and earlier RESTful web services, LINQ, ADO.Net, HTML5, Microsoft ASP.Net MVC5, Bootstrap, CSS, JQuery, Pjax.Mvc4, AJAX, PixIt, JSON, JavaScript, etc.

Projects and Activities.Reggie business application. Developed and enhanced responsive Web UI features e.g., lock screen, time out to lock screen, charts, etc. . Maintained and created CouchApp documents reports , lists and views, along with corresponding charts using d3, NVD3, morris.js, etc. . Built Development and Test Hyper-V VM servers.Scrum Product Owner for Reggie, and JIRA Administrator.

Confidential

Senior Architect and Lead, .NET / ECM / SQL Server.Consultant, 40 hours per week.

Environment.VS 2013 and 2010 editions and TFS Windows Server 2012 and 2008 R2, 7 and XP Pro IIS 7.5 and 6 SQL Server 2012 and 2008 R2, and Oracle 11g SharePoint Cognos ODBC SMTP Batch Jobs EMC's ECM products Captiva 6.52 InputAccel and Dispatcher, ApplicationXtender AX 6.52 with Silverlight-based WebXtender, and Silverlight-based AX Skelta WorkFlow 6.52 VRS software and hardware in-built , ScandAll PRO and document scanners 7-Zip various image editors and converters and Microsoft Hyper-V and VMware Workstation. C and VB.NET 4 and 3 .NET 4.0, 3.5 and 2.0 , Visual Basic for Applications VBA 6 , JC in WorkFlow , RESTful and SOAP-based web services Oracle Web Methods, AX web services, Windows Communication Foundation , COM to integrate .Net with VBA , LINQ, ADO.Net and ADO, ASP.Net, MVP, Microsoft MVC5, CSS, AJAX, JQuery, HTML5, etc.

Projects and Activities. Senior and primary architect and team lead in developing multiple complex Enterprise Content Management ECM Enterprise Service Bus ESB solutions for domestic and international enterprise use around EMC's Captiva and ApplicationXtender AX enterprise server software. These solutions compass domestic and international Accounts Receivable AR and Accounts Payable AP invoices and statements, Export and Import documents, Payroll and AP time cards, Customer Service CS purchase orders, etc., besides related roles and responsibilities. These efforts include both one-time ETL of historical documents and data from FileNet and Cypress, enabling retirement of the latter two from the enterprise, and scheduled ETL from RightFax, into the various ECM solutions. All these solutions and their individual libraries , which are n-tiered, incorporate SMTP email facilities for comprehensive automated notifications and messages to respective parties and stakeholders configurable granular, multi-threaded logging of all activities and results encryption of sensitive Ids and passwords and complete Active Directory AD integration. Much of this is web-enabled, meaning there is a fairly even mix between desktop and web interfaces.

WorkflowedAP Invoices Solution. Created and maintain ECM solutions for AP invoices received at the Denver global corporate headquarters through various location-based PO boxes and email inboxes. Unlike the earlier stopgap solution, index data is OCR'd from each invoice, manually corrected, and then used to retrieve additional index data using an AP Data Objects library each invoice document is then stored with itscorresponding index data in an ECM AX silo, and its URI, to facilitate subsequent retrieval, is exported via Oracle Web Methods thus, this solution is Oracle-integrated. All indexed non-three-way i.e., two-way, manual and non-PO invoices are routed through manual ECM workflows Skelta-based for handling by appropriate corporate buyers and requisitioners, administrators and approvers, before being made available to the Oracle accounting backend for processing status information is simultaneously back-populated to AP silo indexes along the way. Once backend processing is completed for a three-way or other workflow-approved invoice, an Oracle accounting-assigned voucher number, or a rejection status, is finally back-populated to the AP silo index.

AP Invoices Reporting. Enabled reporting through IBM Cognos of all ECM-housed AP invoices data, to include comprehensive accounting histories from workflows . Silo- and workflow-based data are integrated and refreshed hourly via SSIS . F

ileNet AR and AP Replacement Solutions. Created and maintain an ECM solution to add scanned AR invoices and their corresponding index data to a new AR AX silo data using an AR Data Objects library . Corresponding URIs to facilitate easy retrieval of invoices from the AR silo are exported to an Oracle backend accounting system via Oracle Web Methods . Also, Filenet-sourced AR and AP invoices and their indexes data have been imported into corresponding ECM silos, retiring Filenetfrom the enterprise. API AR Invoices and Statements Import Solutions. Created and maintain a robust daily-scheduled enterprise ETL console application to add AR invoices and statements, along with their respective indexes data all contained in daily .zip archives produced by API Outsourcing from uploaded accounting data to corresponding ECM AX silos via AX web services and using the AR Data Objects library . Extracted API-produced documents and index data files are archived for configurable time-periods. Corresponding URIs to facilitate retrieval of AR invoices not statements are likewise exported to the Oracle backend accounting system. Also, created scheduled Windows batch jobs batch scripting that use 7-Zip's command-line interface to test and extract data from valid downloaded archives, with results fully logged.

Import and Export Documents Solutions. Helped to architect, created and maintain separate ECM solutions to house domestic imports and international exports documents in AX silos . Imports and Exports email inboxes are respectively monitored for incoming emails with attachments, which are then swept into ECM and automatically indexed.

Cypress Replacement Solutions for Payroll, AP, and Customer Service CS .TimeCards and RightFax faxes .Backend AP Invoices. Developed and maintained a stopgap ECM solution for scanned AP invoices no workflow , which are first placed in an Oracle accounting backend. To mitigate manual work, index data is retrieved in real-time from Oracle, and corresponding URIs to facilitate quick retrieval of these invoices from their AP AX silo are then pushed via Oracle Web Methods to Oracle. This solution, along with its below successor, supplants an older Cypress-based system. Payroll and AP TimeCards. Created theTimeCards application to automatically email new time-cards data on-demand e.g., bi-monthly and HTML5 formatted to managers and supervisors, so that they may verify amounts paid to their many employees for Payroll and Accounts Payable, removing this functionality as well from Cypress. CS-Received Purchase Orders. Developed and maintained ECM solutions to automatically import purchase orders and their attending RightFax XML data into a partially-indexed CS AX silo on a scheduled basis , as well as to enable CS representatives to then fully index those in a corresponding ASP.Net application backed by a WCF service. Architecturally, this involves an MVP pattern in a Service Component SOA, SQL Server staging of documents and indexes in tandem with their separate placement in an AX silo, AX web services, and a CS Data Objects library with Oracle integration e.g., to pull lists of customers , besides AD integration for group-based roles and access rights. Having entered these into an Oracle accounting backend, CS may then retrieve them from ECM as needed. The import ETL console application portion of this solution will also be used to import the historical POs and their index data form Cypress, enabling retirement of the latter from the enterprise.

AP Data Objects. Architected and developed a COM-enabled .NET data library for simultaneous C and JC use of data objects in AX Skelta WorkFlow scripting and forms steps respectively , as well as VBA use in Captiva Dispatcher modules primarily Recognition and Validation . This configurable library via its own .dll.config file fully encapsulates a corporate SQL Server ECM staging database, which sits between the global AP Invoices ECM solution and an Oracle accounting backend purchase orders, vendors, and sites staging data, as well as new vouchers data, is refreshed daily for ECM indexing use while ECM-solution acquired invoices indexing data is staged for subsequent retrieval and processing by the Oracle accounting backend. Solely architected and created this SQL Server ECM staging database, with its tables and many stored procedures. The AP Data Objects library also automatically retrieves real-time Purchase Order accounting data via an Oracle Web Method when the staging database is insufficiently current.

AR Data Objects. Architected and developed a .NET data library for use with AR ECM solutions. CS Data Objects. Architected and developed a .NET data library for use with CS ECM solutions.

Cryptograpic Library. Developed AES encryption capabilities to secure passwords and any other sensitive, potentially exposed ECM data.

SMTP Library. Architected and developed sophisticated, fully-featured synchronous and asynchronous multi-threaded email capabilities.

Other Roles and Responsibilities. SQL Server installation, database creation, and administration, as a SQL Server database architect and DBA. Windows Server installation, configuration and administration of seven ECM servers , including installation, administration, and patching of EMC's Captiva and AX ECM server products.Denver-area Network Administrator i.e., at Gates Corporation's global headquararters .

Confidential

Architect and .NET Technical Lead

Environment.VS 2010 Ultimate, Windows Server 2008 and 2003 and XP Pro and IIS 7.5, SAS database XML , Mercurial / TortoiseHg.C 4 and .Net 4.0, WCF, LINQ, ADO.Net, CSS, AJAX, HTML, JQuery, GhostDoc, etc. Other: CMS Supervisor 16.2 and 14 components.

Projects and Activities.CMS Reports Extractor. Greatly enhanced CenturyLink's CMS Reports Extractor multi-threaded console application designed to call CMS Supervisor components in near-real-time to generate HTML-based management reports for the enterprise. The application runs 24x7 but had been randomly dying due to apparent network hardware issues and for other uncertain reasons. Enhancements and fixes included enabling automatic failover recovery for connection- and server-down scenarios, automatic multi-server targeting, improving multi-threading robustness, adding comprehensive filtered logging using my own custom-built logger, adding thorough external application configuration, and creating application and corresponding web site installers setup projects along with installation documentation. I also laid the ground work for CenturyLink to convert this application to Windows Server 2008 service with corresponding ASP.Net web metrics. XML Data Editor. Architected this n-tier ASP.Net web application to edit SAS-derived datasets ESB these are retrieved and posted as XML through RESTful WCF services, which themselves call stored processes programs via the SAS/IntrNet Broker CGI part of the SAS Application Dispatcher . The editor is based upon an MVP design pattern, and Microsoft's XSD.exe tool and XML Schema Designer were employed to create the correlating XSDs as well as generate portions of the model.

Confidential

Architect and .NET Senior Software Engineer.Consultant, 40 hours per week.

Environment.VS 2010 Ultimate and TFS, ReSharper 5.1, Windows Server 2008 and XP Pro and IIS 7, SQL Server 2008 R2 SSBS, SSRS , VMWare ESX Server.C 4 and .Net 4.0, Windows Communication Foundation WCF , LINQ, ADO.Net, CSS, SpecExpress and the MS Enterprise Library Validation Application Block, SandCastle, GhostDoc, etc. Other: Tandem SQL MX and SQL MP , SQLXpress, and RazorSQL.

Projects and Activities.Logging Service. Develop logging service and corresponding SQL Server database with Broker Service for message-based queuing for VISA DPS' enterprise applications' audit reporting this is primarily based upon expression trees and cached dynamic methods compiled lambda expressions , ADO.Net, etc. WCF Services REST and non-REST . Architect and develop corresponding WCF Services. DPS Debit Processing Services enterprise Risk Services Manager RSM upgrade. Added critical new features to VISA's RSM multi-tier ASP.Net Web application property categories, custom date range for fraud rules, range-based values and validation, etc. , which is based upon a custom MVC pattern and employs Tandem SQL for its data tier.