SUMMARY:

• I have hands - on professional software development and system architecture experience with the following tools and technologies:
• 18 years using SDLC methodologies (Waterfall, Agile, SCRUM, XP)
• 17 years of SQL Server (version 4.21 through 2016 and Azure)
• 16 years of Visual Studio (through 2015)
• 12 years of .NET (through 4.6.2)
• 12 years of OOP, OOD, OOA
• 12 years of ASP.NET
• 11 years of Web Services
• 9 years of XML
• 9 years of C#
• 7 years of VB.NET
• 7 years of JavaScript
• 5 years of WCF, SOA, and APIs
• 5 years of AJAX
• 5 years of Telerik RadControls
• 5 years of Crystal Reports (prior to 2001)
• 4 years of SharePoint (through 2010)
• 3 years of Oracle and PL-SQL
• 3 years of Entity Framework, LINQ
• 3 years of SSRS, DTS, ETL
• 2 years of Web API, REST, JSON, SoapUI, Postman
• 2 years of jQuery, HTML5, and CSS3
• 2 years of SSIS, SSDT
• 2 years of NUnit, MS Test Framework, TDD
• 1 year of Git, JIRA, BitBucket, SourceTree, Python
• 1 year of ASP.NET MVC, Azure, Bootstrap, Handlebars
• 1 year of AWS SDK, MySQL, Java, Objective-C, C, C++
• In addition, I have extensive professional experience in all phases of the software development life cycle, including:
• Identify, analyze, update/re-engineer, document, and automate business processes.
• Gather and document requirements from stakeholders and users.
• Translate requirements into functional specifications, design specifications, and technical solutions.
• Identify entities and attributes, and design database objects.
• Author high and low level design documents, including system components, services, data flow, use cases, and integration designs.
• Design and develop distributed, service-oriented systems and APIs using the full stack.
• Create development, testing, staging, and production environments and processes for configuration, build, and deployment throughout.
• I am a highly motivated, hard-working professional possessing an exceptional combination of technical, analytical, business communication, and interpersonal skills and am committed to delivering the highest quality business solutions and commercial products using cutting-edge technology, design patterns, and best practices.

SKILLS:

Technologies: .NET 1.1 - 4.5, Windows DNA, COM, COM+, MTS, DCOM, ActiveX, ASP, MSMQ, SOAP, CDO, ADO, ADO.NET, Active Directory, ADSI, LDAP, CDONTS, OO40 (Oracle Objects for OLE), XMLDOM, SAX, ODBC, OLE DB, DB-Lib, MAPI, Win32, MDAC, RDO, Windows Script Components, HTTP, Web Services, .NET Remoting, WCF, WF, SharePoint 2003-2010, AJAX.

Languages: C#, VB.NET, Visual Basic, VBA, XML, UML, ANSI SQL-92, Transact-SQL, PL/SQL, Perl, MIDL, Visual C++, BASIC, PHP, Java.

Scripting: JavaScript, JScript, VBScript, ActiveX (DTS), VBA, Windows Scripting Host, jQuery, Prototype.

Databases: MS SQL Server (through version 2014), Oracle, Sybase, Informix, DB2, Access, dBase, FoxBASE, FoxPro, Paradox, MySQL.

Web Development: ASP.NET, AJAX, .NET User Controls, WebParts, .NET Custom Controls, XML, XSL, HTML, DHTML, CSS, Active Server Pages (ASP) 1.0-3.0, WSS 3.0 (Windows SharePoint Services), MOSS 2007, SharePoint (through 2010), ASP Classes, ADO 2.5 RDS, Remote Scripting, Behaviors (JavaScript, DHTML), Web Classes, DHTML, JavaScript, ASP components, ASP Scriptlets.

Platforms: Windows Server 2012, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2003 R2, Windows 2000 Server, Windows 2000 Advanced Server, Windows NT Server and Workstation, BackOffice Server, SCO Unix, MVS, OS/400, OS/2, Novell Netware, Banyan Vines, Windows (3.x, 95, 98, ME. 7, 8, 8.1), PC-DOS, MS-DOS.

Tools: MS Visual Studio versions 2015, 2013, 2012, 2010, 2008, 2005, 2003, 2002, 6.0, and 97. 16+ years of experience.

MS SQL Server versions 4.21 - 2014: design, development, and administration experience includes OLTP, OLAP, SQL-DMO, data warehouses, data marts, feed stores, analysis services, MDX, ADOMD, OPENXML, replication, Transact-SQL (T-SQL), OLE Automation Stored Procedures, OLE DB Distributed Queries, DTS, SQL Profiler, Performance Tuning, RAID subsystems, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS). 17+ years of experience.

Oracle: RBMS v7.0 - 9.2, PL/SQL, SQL*Plus, OO4O, Designer/2000, Forms, and Reports. 3+ years of experience.

Web Development: SharePoint 2010 Server, SharePoint 2010 Foundation, MOSS 2007, WSS 3.0, SharePoint Portal Server 2003, IIS (Internet Information Server) 2.0-8.5, Visual Web Developer, Visual Studio (versions .NET 2002 through 2015), Visual InterDev, HomeSite versions 4.0 and 4.5, Cold Fusion, Dreamweaver UltraDev version 4, Bowstreet Business Web Factory, KANA Knowledge Server, Commerce Server, Site Server, Site Server Commerce Edition, FrontPage. 12+ years of experience.

Modeling/CASE: ERwin/Open, ERwin Model Mart, Erwin/ERX, Visual Modeler, System Architect, Visio, Rational Rose, Rational Unified Process, Jacobson Use, Booch Method, SDLC, P+, MSF, Agile, Extreme, SCRUM. 15+ years of experience.

Reporting: SQL Server Reporting Services (SSRS), Crystal Reports, Crystal Info, MS Access (remote automation), MS Excel, and MS Word (VBA, HTML), WinQL-SQL, Monarch, and VB (code components). 15+ years of experience.

Miscellaneous Tools: Sybase SQL Server version 4.9, PowerBuilder (3.0, 6.0 and 7.0), Sybase Jaguar Application Server, Exchange Server 5.5 & 2000, Microsoft Visual C++, Visual SourceSafe versions 4.0 - 6.0, PVCS, MS Repository, Developer Studio, Internet Explorer 2.0-6.0, ActiveX SDK, SQL-Programmer versions IX and 2000, MS Visual Data Tools, Platform SDK, .NET Framework SDK, MSDN, MS Project, NT 4 Option Pack, BackOffice Server (4.0 & 4.5), BackOffice 4.5 Resource Kit, MS Installer, Wise Installer, SQL2000 XML View Mapper, XSL Debugger, Active Directory SDK Tools (e.g., LDIF), InstallShield 8, AJAX Control Toolkit.

PROFESSIONAL EXPERIENCE:

Senior Software Engineer

Confidential, San Diego, CA

Responsibilities:

• End-to-end design and development of stories, features, and special projects/tools (DB objects, stored procedures, SQL and Python scripting, service layer, APIs, data access layer, business logic layer, code-behind, markup, and client script).
• 90% of my time spent writing code (SQL, C#, JavaScript, HTML, CSS, and Python), working JIRA tickets, and troubleshooting deployments.
• Balance of time spent on design, review, and process improvement.
• Management of project/tasks and source code using JIRA, Git, BitBucket, and SourceTree.
• Created Python scripts that access JIRA API for project reporting.
• Extensive use of command-line tools to resolve issues.
• Agile team - daily standup, two week sprints, code review, design sessions, swarms.

Software: IIS 6.0-8.5, Visual Studio 2013-2015, SQL Server 2012, NET Framework 4.5x, C#, ADO.NET, Entity Framework, LINQ, ASP.NET 4.0-5.0, Web API 2.0, REST, AJAX, XHTML, XML, JavaScript, T-SQL, jQuery, jQuery UI, HTML5, CSS3, Python, MapR, JIRA, Git, BitBucket, and SoruceTree,.

Principal Developer

Confidential, San Diego, CA

Responsibilities:

• Design and development of data integration solutions for Technicolor’s acquisition of Cisco’s set-top box division. Projects included 1) a C# executable running as a scheduled task that performs discovery of new and changed data files on Cisco’s FTP server; 2) a C# executable running as a scheduled task that packages files for download from the FTP server into jobs in a queue; and 3) a C# executable containing a custom FTP over TLS client triggered by #2 that downloads from Cisco’s FTP and uploads to an Amazon AWS S3 bucket.
• Created custom multipart files-splitting feature for downloading very large files. Tools included Visual Studio 2013, C#, AWS SDK, Amazon EC2 instances, MySQL 5.6, MySQL Workbench, .NET Framework 4.52, and MS Test Framework.
• Design and development of complex long-running processes, jobs, stored procedures, test applications, and SSRS reports at TransCore for the Confidential Lane Network Toll System using SQL Server 2014 and T-SQL.
• Design and development of network device identification, matching, and bulk import tools for a cloud security service company using SQL Server 2012, Visual Studio 2013, T-SQL, and C#.
• Design and development of proximity marketing web application for Confidential using C#, Visual Studio 2013, ASP.NET 4.0, Entity Framework, LINQ, HTML5, CSS3, Web API 2.0, REST, SoapUI, Postman, jQuery, jQueryUI, Handlebars, MS Test Framework, SQL Server 2014, Azure SQL Database, and TFS 2013. Worked on a small team as the principal full-stack developer. Created ASP.NET 4.0 web application project, RESTful Web API 2.0 project, and SQL Server 2014/Azure SQL Database. Created and configured all three projects in Azure. Daily deployment of SQL2014 to Azure SQL DB changes.
• Continuous integration of Web and Web API projects to Azure Websites using TFS. Daily stand-ups and status with project owner.
• Design and development of a serialized bulk insert processor for Confidential based reprographics service provider) that eliminates deadlocks and database object contention for over 100 users.
• Identified problem space and architected technical solution (designed distributed system, documented specifications components, services, and data flow), Tools employed include Visual Studio 2010/2012, ASP.NET, Message Queue, C#, LINQ, Telerik, AJAX, JavaScript, CSS, and SQL Server 2008 R2.
• Design and development of ETL jobs for Confidential.
• Created SSIS packages for scheduled bulk import into SQL Server 2005 database.
• Project required creating different SSIS package for each source schema.
• Design and development of a reporting system for Confidential that delivers MS-Excel and web-based reports to an Active Directory users’ inbox.
• Performed needs analysis and end-to-end architecture using Visio for UML, use cases, data flow, and system design diagrams. Solution uses SQL Agent to schedule report delivery and was created using Visual Studio 2010/2012, ASP.NET, Entity Framework, C#, VB.NET, LINQ, Telerik RadControls, AJAX, JavaScript, AJAX Control Toolkit, T-SQL, CSS,.SQL Server 2008 R2, IIS 7.5, SpreadsheetGear, and MS-Excel templates.
• Design and development of ASP.NET 4.0 web site for Confidential using C#, VB.NET, LINQ, Telerik RadControls, MSChart, SQL Server 2005/2008R2, NUnit, AJAX, JavaScript, AJAX Control Toolkit, T-SQL, and CSS.
• Participated in development of SOA advertising and promotions platform (WCF on SQL Server).
• Created APIs and web sites for multiple Miller/Coors campaigns and digital design partners
• Design, development, and administration of SharePoint solutions for local software development consulting company using SharePoint 2010, Windows Server 2008 R2, SQL Server 2008, SQL Server 2005, ASP.NET, C#, Visual Studio 2010, WCF, WF, SSRS, T-SQL, CSS, VMware Workstation 7.1.
• Design and development of ASP.NET 4.0 web application for Confidential using C#, Web Services, SQL Server 2008, .NET Framework 4.0, JavaScript, jQuery, AJAX, Telerik RadControls, T-SQL, CSS.
• Design and development of SQL Server 2005 Reporting Services reports for Confidential (a San Diego based eLearning company) using C#, ASP.NET, MSChart, SQL Server 2005, and SSRS 2005. Also responsible for installation, troubleshooting, and administration of Report Server.
• Design and development of decision support “dashboard” for Confidential based reprographics service provider) using C#, VB.NET, ASP.NET, MSChart, NUnit, SQL Server 2005, T-SQL, CSS.
• Design and development of Web Content Management System for a local university.
• Migration of legacy web content into SharePoint Publishing site.
• Design and development of ASP.NET 2.0 web application accessing SharePoint content and deployed in the Blackberry browser for Fortune 500 client of Confidential (a San Diego based eLearning company).
• SharePoint Design and development for Confidential. Learning Evolution clients utilize a learning management system to create training content. Developers implement that content in highly customized SharePoint sites. SharePoint .NET Framework Class Libraries, AJAX-enabled ASP.NET pages, SQL Server stored procedures, and SQL Server Reporting Services reports to display CMS and database content in SharePoint pages.
• Design and development of SQL Server 2000 and 2005 Reporting Services reporting applications hosted in SharePoint for Fortune 500 clients of Confidential (a San Diego based eLearning company).
• Developed DAL (data access layer), T-SQL stored procedures, BLL (business logic layer), Service Layer, Web Services, and AJAX-enabled pages for ASP.NET web applications.
• Assisted in iOS development of multiple AppStore applications (Mobile Deposit, Mobile Receipt). Also responsible for build and release of commercial imaging product that is the core technology used by the mobile applications.
• Performed new development and maintenance of NET-based applications for Confidential a producer of commercial software products in the banking vertical market. The product, Dupe Detective, prevents posting duplicate payments to customer accounts and sending duplicate payments to banking exchange partners.
• Developed .NET components in C# to facilitate Active Directory authentication and authorization for Confidential a producer of commercial software products in the banking vertical market. Implemented Confidential Names technique for accessing Active Directory group membership and DirectoryServices framework classes for binding and searching Active Directory.

Software: IIS 6.0-8.5, Visual Studio .NET 2003, Visual Studio 2005, Visual Studio 2008, Visual Studio 2010, Visual Studio 2012, Visual Studio 2013, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2. SQL Server 2012, SQL Server 2014, Azure SQL Database, Windows Server 2003, Windows Server 2003 R2, Windows Server 2008 R2, Windows 8.1 Ent, .NET Framework 2.0, .NET Framework 3.0, .NET Framework 3.5, .NET Framework 4.0, NET Framework 4.5, ASP.NET (2.0/3.5/4.0), ADO.NET, C#, VB.NET, AJAX, XHTML, XML, JavaScript, T-SQL, Active Directory, DirectoryServices, SharePoint Designer, WSS 3.0, MOSS 2007, SharePoint 2010, SQL Reporting Services (SSRS), Team Foundation Server (TFS) 2013, jQuery, jQuery UI, Entity Framework, LINQ, ASP.NET 4.0-5.0, Web API 2.0, REST, HTML5, CSS3, Git, PVCS, SVN, WCF, WF, iOS, xCode, Objective-C, Cocoa Touch.

Lead .NET Developer

Confidential, New Orleans, LA

Responsibilities:

• First project -- end-to-end architecture and development of ASP.NET web application and automated backend address data cleansing process using ASP.NET, VB.NET, XML, Transact-SQL, Data Transformations Services, and SQL Server 2000.
• Responsible for daily builds.
• Gathered and documented requirements.
• Created wireframes/paste-ups, technical use cases, business use cases, functional specification, and system architecture. Created high-level and detailed design documents.
• Created test plan and test cases.
• Created deployment plan and schedule.
• Second project - completed development of Java/SharePoint/.NET document management system.
• Delivered applications include (1) a .NET Windows Service that transfers documents into SharePoint document libraries, (2) a .NET Windows Service that updates SharePoint document metadata, (3) an ASP.NET web application that facilitates creation of SharePoint document folders and uploading of documents into SharePoint, (4) an ASP.NET web application that facilitates bulk uploading of documents into SharePoint staging areas for file transfer into SharePoint document libraries, and (5) a pair of ASP.NET Web Services that that use of .NET SharePoint components to perform extensive file and folder operations. Performed debugging and maintenance of Java application used at nuclear power plants to add and update work authorizations for NRC compliance. Wrote Oracle PL/SQL stored procedures to update tables containing new authorizations and metadata deltas that are propagated to SharePoint documents by the .NET Windows Service.
• Developed a content management system that enabled users to publish content created in Web Publisher (a web content creation front-end for Documentum).
• The system consisted of an ASP.NET 2.0 (C#) web application with custom controls for publishing content, a component for porting content/documents from a Documentum docbase to the web application content inventory, and XML/XSL templates used by Web Publisher for content creation.

Software: Visual Studio 2005 Team Suite, Visual Studio .NET 2003, IIS 6.0+, SQL Server 2005 Enterprise Edition SQL Server 2000 Enterprise Edition, Oracle 9.2, TOAD, SharePoint Portal Server 2003, Informatica, ASP.NET Web Services, Windows Server 2003 Enterprise Edition R2, .NET Framework 2.0 & 1.1, ASP.NET 2.0 & 1.1, ADO.NET 2.0, VB.NET, C#, NUnit, XHTML, HTML, XML, XSL, AJAX, JavaScript, PL/SQL, and Transact SQL (T-SQL), SQL Server 2005 Reporting Services, Documentum, Web Publisher, SVN, Active Directory, Directory Services.

Lead .NET Developer

Confidential, San Diego, CA

Responsibilities:

• Principal architect and developer for my software development consulting company.
• Created SharePoint, ASP.NET web, and ASP.NET web service solutions for Intuitive Analytics, an ISV selling into Confidential .
• SharePoint (WSS v3) team site was created for fund managers and analysts to collaborate on derivative scenarios and accounts.
• Clients of the Confidential access another SharePoint web (MOSS) I created where workbooks are stored that contain finished analytic data.
• This data is then accessed via Excel Services and is presented to users for analysis, re-calculation, further modeling and discussion.

Software: Windows SharePoint Services v3.0, Microsoft Office SharePoint Server, IIS 6.0+, Visual Studio 2005 Team Suite, Visual Studio .NET 2003, Visual Studio Tools For Office, SQL Server 2005 Enterprise Edition, SQLExpress, SQL Server 2000 Enterprise Edition, Windows Server 2003 Enterprise Edition R2, .NET Framework (1.1, 2.0, and 3.0), ASP.NET (1.1 and 2.0), ADO.NET (1.1 and 2.0), ASP.NET Web Services (1.1 and 2.0), C#, VB.NET, XHTML, XSL, XML, JavaScript, AJAX, T-SQL.

Lead .NET Developer

Confidential, San Diego, CA

Responsibilities:

• I developed a portal to all six (6) Confidential sites, and participated in the hands-on development of each. Was personally responsible for release configurations and builds of all six sites.
• Also created SQL Server 2000 and 2005 databases (designed entire database to 3rd normal form), indexes, stored procedures, triggers, DTS packages, and nightly batch scripts using transact-sql.
• Gathered and documented requirements.
• Created wireframes/paste-ups, technical use cases, business use cases, and functional specification.
• Created high-level and detailed design documents.
• Created test plan and test cases.
• Created deployment plan and schedule.

Software: ASP.NET, C#, SQL Server 2005 Enterprise Edition, SQL Server 2000 Enterprise Edition, T-SQL, JavaScript, HTML, XML, XSL, VB.NET, ADO.NET, Visual SourceSafe 6.0, Visual Studio .NET, .NET Framework, Internet Information Server (IIS), MS Windows 2000 Advanced Server, Windows 2000 Server, Windows Server 2003, Windows XP Professional.

Software Developer

Confidential, Carlsbad, CA

Responsibilities:

• Built web-based installation program in ASP that consumes multiple web services using SOAP. This installation program is a series of ASP pages that use ActiveX controls to investigate a user’s system and perform tasks in preparation of interfacing with Confidential ’s Software Fulfillment Platform (SFP).
• Assisted in creation of multiple Windows Forms applications and ActiveX components for the Help and Support Toolkit CDs shipped to new Confidential FIOS Internet customers.
• I also built a site entitled Confidential Updates.
• Much like Windows Update, this site is a single source for all Confidential software applications and updates and can be seen as a front-end for SFP.
• I also developed a site that consolidates the data contained in KANA Knowledge Server error and warning logs into useful statistics for the purpose of debugging the KANA-scripted templates. This is an ASP.NET web written in C#.
• I have built and successfully deployed to production two (2) full-blown sites whose templates are completely KANA-based. These sites provide detailed knowledge base help content for residential and business long distance customers.
• Gathered and documented requirements. Created wireframes/paste-ups, technical use cases, business use cases, and functional specification. Created high-level and detailed design documents.
• Created test plan and test cases. Created deployment plan and schedule.

Software: ASP, JavaScript, HTML, XML, KANA, C#, ASP.NET, ADO.NET, Visual SourceSafe 6.0, Visual Studio .NET, .NET Framework, SQL Server 2000, Transact-SQL (T-SQL), Internet Information Server (IIS), MS Windows 2000 Advanced Server, and Windows 2000 Server, Windows XP Professional.

Lead .NET Developer

Confidential, San Diego, CA

Responsibilities:

• One is an ASP.NET web that a wireless ISP uses to determine if a prospective customer is within one of multiple regional service areas. Makes extensive use of code behind, user controls, and encapsulation of business and application logic in assemblies. Service coverage feature set is designed to be private labeled and easily deployed on third party IIS Web Server with .NET Framework installed. Site can be deployed with either a SQL Server or MS Access database.
• Gathered and documented requirements. Created wireframes/paste-ups, technical use cases, business use cases, and functional specification. Created high-level and detailed design documents. Created test plan and test cases. Created deployment plan and schedule.
• Software - VB.NET, C#, ASP.NET, ADO.NET, JavaScript, XML, Visual SourceSafe 6.0, Visual Studio .NET, .NET Framework, SQL Server 2000, Transact-SQL (T-SQL), MS Access 2000, Internet Information Server (IIS) 5.0 and 5.5, MS Windows 2000 Advanced Server, and Windows 2000 Server, Windows XP Professional, Windows Server 2003.

Lead .NET Developer

Confidential, Sacramento, CA

Responsibilities:

• Created a consumer complaints tracking and processing web application that is used throughout the Confidential .
• Collaborated with user representatives to model their business processes (validating, re-engineering, augmenting, and creating new as necessary), integrated these processes into a consolidated department-wide process model, identify the portions of their business processes to automate and expose as desired functionality, and create a detailed workflow automation process model describing process / data ownership, complaint assignments, and functional procedures / rights / responsibilities for processing throughout the complaint lifecycle. The details of this collaboration were documented and encapsulated in use cases. Gathered, defined, and documented detailed requirements for review and sign-off.
• Development Duties - As lead developer, built SQL Server 2000 databases, stored procedures, DTS nightly processes and legacy data migration scripts; Assisted in ASP.NET development, performed code review, applied best practices, and enforced IT standards. Design Duties - Designed databases, framework components and pages, security model, disaster recovery plan, legacy data migration strategy, system and network architecture; integrated existing COM+ components.
• Maintained project plan, hired and managed human resources, created delivery schedule where feature sets were dropped to QA for testing every two weeks during development cycle - combining development and test cycles saved us weeks in test and is largely responsible for the successful implementation of both webs under budget. Created deliverables-based payment schedule for signoff by IT management and remittance by contracts department.

Software: VB.NET, ASP.NET, ADO.NET, JavaScript, XML, Visual SourceSafe 6.0, Visual Studio .NET, SQL Server 2000, Transact-SQL, DTS, Internet Information Server (IIS) 5.0 and 5.5, MS Project, Windows 2000 Advanced Server, and Windows 2000 Server.