Might be available
(Updated 2020-03-07)Software Developer
San Diego, CA, USA
Native English, Intermediate Spanish, Beginner French
- 20 years of SQL Server experience
- 10+ years of experience with .NET, C#, VB.NET, ASP.NET
- Over 20 years of professional development experience
Skills (87)
Business
Developer
Migration
VB.NET
TESTING
Senior
PLC
Waterfall SDLC
ADO.NET
system
Visual Basic
.NET
SQL
SKILLS
OOP
SOA
Experience
DATABASE MODELING
Manager
ENGINEER
ERP
OBJECT ORIENTED PROGRAMMING
SQL Server 4.21-2016
C#
STORED PROCEDURES
Analyst
Project
SOFTWARE
ARCHITECTURE
professional
Analytics
Query
data
ASP.NET
DOCUMENTATION
JSON
JavaScript
Bus Process Re-engineering
PROJECT PLANS
API
SCRIPTING
XSLT
Web API
Azure SQL Database
AWS
Data Migration
Git
Microsoft Access
REST
JQuery
SYBASE
INTEGRATION
WCF
VBSCRIPT
ECOMMERCE
ETL
WINDOWS SHAREPOINT SERVICES
PERFORMANCE TUNING
TEST CASES
VB6
Agile
VBA
IIS 6.0-8.5
AWS SDK for .NET
Offshore Teams
Web Services
DTS
MySQL
XML
Jira
UNIT TESTING
SharePoint 2007-2010
oracle 7.0-9.2
SSRS
Virtualization
Azure
PL/SQL
SSIS
Python
XML/XSL
TFS
RUP
TDD
Azure Websites
bootcamp
SAS
VISUAL C++
Summary
Over 20 years as a professional software developer. Recent experience in the following tools and technologies:
• Languages (C#, VB.NET, SQL, JavaScript, Python)
• RDBMS design and development (SQL Server, MySQL, Oracle)
• Service layer development (WCF, SOAP, Web API, JSON, REST, XML Web Services)
• Web development (ASP.NET, jQuery, Handlebars, SharePoint)
• Cloud development (AWS SDK for .NET, Amazon EC2, Azure Websites, Azure SQL Database)
• Tools (Git, Visual Studio, TFS, JIRA, Bitbucket, SourceTree)
• SDLC methodologies (Agile, Scrum, Kanban, Waterfall)
I have extensive professional experience throughout the software development life cycle:
• Gather and document requirements from stakeholders and users
• Identify, document, analyze, re-engineer, and automate business processes
• Translate requirements into functional specifications, design specifications, and technical solutions
• Author high-level and detailed design documents, including system components, services, data flow, use cases, and integration designs
• Design, develop, test, debug, and deploy multi-tier web-based, database, and distributed service-oriented solutions using the full stack
• Create development, testing, staging, and production environments and processes for configuration, build, and deployment
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.
Professional Experience
2017-06 - Present
I've spent the last two (2) years studying blockchain technology, trading the cryptocurrency asset class, and developing automation to support my trading processes.
• Design and development of discretionary and automated trading systems, strategies, and indicators.
• Cryptocurrency asset technical analysis; Bitcoin price and market expert.
• Developed and backtested successful strategies for trading and investing in these unregulated, highly volatile markets dominated by smart money, whales, and bots.
• TradingView indicator and strategy development in PineScript.
• Automated signal and notification development in C#, Python, and PineScript.
• Tax accounting projects (C# program for automated creation of IRS Form 8949; C# program for reconciliation and accurate reporting of margin trading activity to IRS)
• Software - Visual Studio 2015-2019, C#, PineScript, Web API, JavaScript, jQuery, Solidity, Python, TradingView, SQL Server 2014.
2016-10 - 2017-05
Senior Software Engineer for a manufacturer of smart parking meters. Assigned to the DMS (Data Management System) team.
• End-to-end design and development of stories, features, and special projects/tools (pages, controls, stored procedures/functions, data access layer, business logic layer, service layer, client script, markup). Full-cycle hands-on development (ASP.NET, C#, T-SQL, JavaScript, jQuery, Bootstrap, CSS3, HTML5).
• Bulk of time spent working JIRA tickets (new development, enhancements, maintenance, fixes) and troubleshooting deployments. Worked closely with team members, DBAs, testers, and stakeholders to ensure JIRA tasks completed and released in the current sprint. Issue fixes, build fixes, and release testing.
• Management of project/tasks and source code using JIRA, Git, Bitbucket, and SourceTree. Extensive use of command-line tools to resolve issues. Created Python program to pull data from JIRA API for Tableau reports.
• Agile team (10-15 people) - daily standup, two-week sprints, Kanban board, code review, design sessions, swarms.
• OWASP Training.
• Software – IIS 6.0-8.5, Visual Studio 2013-2015, SQL Server 2012, .NET 4.5x, C#, ADO.NET, Entity Framework, LINQ, ASP.NET 4.0-5.0, Web API 2.0, REST, JSON, AJAX, XHTML, XML, JavaScript, T-SQL, jQuery, jQuery UI, HTML5, Bootstrap, CSS3, Python, MapR, JIRA, Git, Bitbucket, SourceTree.
2015-06 - 2015-12
• Design and development of T-SQL stored procedures, functions, SSRS and Report Builder reports, utility scripts; unit, integration, and system tests.
• Responsible for writing T-SQL procedures to identify and price vehicle trips as defined in BAIFA detailed design document. Hundreds of business rules had to be coded into discreet SQL modules to articulate vehicle trips in a toll lane; uniquely identify vehicles / transponders / license plates; account for lane controller failure; apply rules from the pricing modules; and bill vehicle owners.
• Extensive query and performance tuning of the real-time toll system's complex vehicle tracking and pricing algorithms.
• Responsible for enhancements of ELN emulator application to current BAIFA specification and database schemas.
• Large team (20-30 people). Direct access to Systems Architects, DBAs, and senior staff. Code reviewed via impromptu meetings and design sessions. Daily builds.
• Software - SQL Server 2014, SSRS, Report Builder, Visual Studio 2013, C#, ASP.NET, ADO.NET, JavaScript, Dimensions CM, Windows Server 2012.
2010-01 - 2015-01
• Designed and developed solution to automate the transfer of data files from a secure Cisco's FTP server to Technicolor's Amazon S3 buckets using C#, MySQL, MSMQ, and the AWS SDK for .NET.
• Created and managed Amazon EC2 instances running Windows Server 2012 and MySQL 5.6.
• Created MySQL databases and objects for storing information about scheduled task runs, FTP file and version information, job packaging/execution, file transfers from the FTP server to AWS S3, and tracking of data resources for loading onto Technicolor servers. Authored all stored procedures and SQL scripts.
• Personally developed a multitude of C# programs/libraries including, but not limited to, FTP client helper, scheduled job creation, large file multipart splitting/joining, interaction with MSMQ, end-to-end and staged file transfer, job failure tracking and retry management, logging, common data access layer.
• Created unit, integration, system tests, and full test environment for end-to-end workflow testing.
• 3-person team (Developer, Project Architect/Manager, Team Lead). Daily meetings with project manager. Periodic code review with Team Lead. JAD sessions with stakeholders and dependent project staff.
• Software - Visual Studio 2013, C#, MySQL 5.6, AWS SDK for .NET, Amazon EC2, AWS S3, MySQL Workbench, MySQL Connector/NET, .NET Framework 4.52, MS Test Framework.
2013-01 - 2013-01
• Design and development of network device identification, matching, and bulk import tools for Proficio Inc. (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 Fusion Media (a La Jolla, CA based boutique software development firm). Worked on a small team as the principal full-stack developer. Created an ASP.NET 4.0 web application project, a Web API 2.0 project (with RESTful services), and a SQL Server 2014 / Azure SQL Database. Created and configured all three projects in Azure. On-demand deployment to Azure using TFS. Daily stand-ups and status with project stakeholders. Used C#, Visual Studio 2013, ASP.NET 4.0, ADO.NET, Entity Framework, LINQ, HTML5, CSS3, Web API 2.0, JSON, REST, SoapUI, Postman, jQuery, jQueryUI, Handlebars, MS Test Framework, SQL Server 2014, Azure SQL Database, Azure Websites, and Team Foundation Server (TFS) 2013.
• Design and development of bulk insert processor in C# for Auxilio, Inc. (an Orange County, CA based reprographics service provider). Solution eliminates deadlocks and contention in mixed-use OLTP/Reporting database serving hundreds of users. Identified problem space (SQL Server database debugging) and architected technical solution (designed distributed system, documented specifications components, services, and data flow). Tools employed include Visual Studio 2010/2012, ASP.NET, ADO.NET, Message Queue, C#, LINQ, Telerik RadControls, AJAX, JavaScript, CSS, SQL Server 2008 R2.
• Design and development of ETL jobs for Auxilio Inc. Created SSIS packages for scheduled bulk import into a SQL Server 2005 database. Project required creating a different SSIS package for each source schema. Auxilio's customers are large hospitals and can have many different data sources.
• Design and development of a reporting system for Auxilio that delivers MS-Excel reports to an Active Directory users' inbox. Solution deployed in an ASP.NET user control. Reports were delivered on-demand via SMTP (C#) or scheduled via Database Mail and SQL Agent. Created using Visual Studio 2010/2012, ASP.NET, C#, VB.NET, ADO.NET, Entity Framework, LINQ, Telerik RadControls, JavaScript, AJAX Control Toolkit, T-SQL, CSS, SQL Server 2008 R2, IIS 7.5, Excel/VBA, SpreadsheetGear, and MS-Excel templates.
• Design and development of ASP.NET 4.0 web site for Auxilio using C#, VB.NET, LINQ, Telerik RadControls, MSChart, SQL Server 2005, SQL Server 2008R2, ADO.NET, NUnit, AJAX, JavaScript, AJAX Control Toolkit, T-SQL, HTML, and CSS.
• Design and development of decision support "dashboard" for Auxilio using C#, VB.NET, ASP.NET, ADO.NET, AJAX, MSChart, NUnit, SQL Server 2005, T-SQL, HTML, and CSS.
• Design and development for The Ignition Network (a Chicago, IL based digital media and marketing company) using Visual Studio 2010/2008, C#, ASP.NET, LINQ, MVC 4.0, Entity Framework, LINQ, WCF, SOAP, SoapUI, jQuery, JavaScript, ADO.NET, AJAX, NUnit, XML, and SQL Server 2008. Participated in development of SOA advertising and promotions platform (WCF on SQL Server). Created APIs, web services, and web sites for multiple Miller/Coors campaigns and digital design partners (e.g., Razorfish, Digitas). Managed offshore development team in Minsk, Belarus. Led daily stand-up via Skype.
• 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, ADO.NET, SSRS, T-SQL, CSS, VMware Workstation 7.1.
• Design and development of ASP.NET 4.0 web application for Sequenom Inc. (a San Diego based Biotech). Application automated access to FreezerWorks database test samples using C#, XML Web Services, SQL Server 2008, .NET Framework 4.0, ADO.NET, JavaScript, jQuery, AJAX, XML, Telerik RadControls, T-SQL, CSS, and HTML.
• SharePoint Design and development for Learning Evolution (a San Diego based eLearning company). Learning Evolution clients utilize a learning management system (LMS) to create and store training content. Team I worked with implement that content in highly customized SharePoint sites. Design and development of SharePoint .NET Framework Class Libraries, AJAX-enabled ASP.NET pages, T-SQL stored procedures, and SSRS reports to display CMS and database content in SharePoint pages.
• Design and development of ASP.NET 2.0 web application accessing SharePoint content and deployed in the Blackberry browser for a Fortune 500 client of Learning Evolution.
• Design and development of SQL Server 2005 Reporting Services reporting applications hosted in SharePoint for Fortune 500 clients of Learning Evolution.
• Additional Software - IIS 6.0-8.5, Visual Studio 2013, Visual Studio .NET 2012, Visual Studio 2010, Visual Studio 2008, Visual Studio 2005, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, Azure SQL Database, Windows Server 2012 R2, Windows Server 2008 R2, Windows Server 2003 R2, .NET Framework (2.0/3.0/3.5/4.0-), Web API 2.0, ASP.NET (2.0/3.5/4.0), SharePoint Designer, WSS 3.0, MOSS 2007, SharePoint 2010.
2007-02 - 2008-02
• First project -- end-to-end architecture and hands-on development of automated data cleansing process using ASP.NET, VB.NET, XML, T-SQL, DTS, and SQL Server 2000. Solution replaced resource-intensive manual cleansing of utility meter location data. Waterfall methodology (requirements definition document, functional specification document, wireframes/paste-ups, use cases, and system architecture/design documents). Created test plan and test cases. Created deployment plan and schedule. Responsible for all development tasks (wrote all code), daily builds, and deployments to testing. Close interaction and communication with the data cleansing working group and a business systems analyst.
Second project - successfully completed development of unfinished SharePoint/.NET work authorization management system. Entergy has a Java client used at nuclear power plants to add and update work authorizations. These work authorizations are stored in SharePoint for Nuclear Regulatory Commission compliance. I was the 6th developer to attempt to fix this cumbersome system. The completed solution included (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 staging areas for file transfer into SharePoint document libraries, and (5) a pair of ASP.NET Web Services that execute .NET SharePoint components to perform extensive file and folder operations. I wrote Oracle PL/SQL stored procedures to update tables containing new authorizations and metadata deltas. I rewrote the .NET Windows Service that accesses those Oracle tables. I wrote .NET code using the SharePoint namespaces for multiple Visual Studio projects. Each of these projects required debugging, enhancements/fixes, and integration into the delivered working solution.
• Third project - Developed a custom content management system (CMS) 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 users for content creation.
• Software - Visual Studio 2005 Team Suite, Visual Studio .NET 2003, IIS 6.0+, SQL Server 2000/2005 Enterprise Edition, Oracle 9.2, SharePoint Portal Server 2003, SharePoint Framework Classes, Informatica, XML Web Services, Windows Server 2003 Enterprise Edition R2, .NET Framework 2.0 & 1.1, ASP.NET 2.0 & 1.1, ADO.NET, VB.NET, C#, XHTML, HTML, XML, XSLT, AJAX, JavaScript, PL/SQL, T-SQL, SSRS, Documentum, Web Publisher, Active Directory.
2006-06 - 2007-01
• Created proof of concept SharePoint solution for Intuitive Analytics, an ISV selling an MS Excel add-in into Wall Street Investment Banks. Solution consists of a SharePoint (WSS v3) team site for fund managers and analysts to collaborate on derivative scenarios and accounts. Clients of the Investment Bank would access another SharePoint (MOSS) 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.
2005-04 - 2006-04
• Project management and hands-on development of public and private ASP.NET webs and SQL Server databases.
• Migrated dunham.com from classic ASP to ASP.NET. Implemented stored procedures, user controls, page-specific and common business logic layer classes, compact data access layer component, cross browser support. Applied Microsoft migration best practices.
• In addition to the dunham.com migration, I developed an ASP.NET portal to all six (6) Dunham sub-sites, and participated in the hands-on development of each.
• Also created SQL Server 2000 and 2005 databases, indexes, stored procedures, triggers, DTS packages, and nightly batch scripts using T-SQL.
• Gathered and documented requirements. Authored functional specification. Created detailed project plans and schedules for all Dunham software development projects.
• Software - ASP.NET, C#, SQL Server 2005 Enterprise Edition, SQL Server 2000 Enterprise Edition, T-SQL, DTS, SQL Agent, JavaScript, HTML, XML, XSLT, 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.
2004-05 - 2005-01
• 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 Verizon Online's Software Fulfillment Platform (SFP).
• Worked on Verizon Updates. Much like Windows Update, this ASP.NET site is a single source for all Verizon Online software applications and updates and is a front-end for SFP.
• I also developed an ASP.NET website 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.
• Software - Visual Studio .NET, SQL Server 2000, ASP.NET, ADO.NET, Subversion (SVN), KANA, ActiveX, ASP, VB6, C#, VB.NET, IIS, MS Windows 2000 Advanced Server
2003-07 - 2004-04
• One web application is the UI 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.
• The second web application is the service layer containing multiple XML Web Services for accessing 3rd party data providers like Mappoint.net.
• 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, MS Windows 2000 Advanced Server.
2002-06 - 2003-06
Led team in end-to-end development of two (2) intranet web sites for the State of California, Department of Corporations. Project lifecycle was managed using a modified waterfall methodology and implemented using ASP.NET, VB.NET, and SQL Server 2000.
• Web 1 - Ported functionality of eighteen (18) DOS-based Clipper and dBase programs and data to a single consolidated web application used by the Financial Services Division (FSD).
• Web 2 - A consumer complaint tracking web application used by all divisions in the DOC.
• Development duties - As lead developer, I designed framework components and pages, security model, disaster recovery plan, and legacy data migration plan; solely responsible for development and management of multiple SQL Server 2000 databases and objects therein; developed all T-SQL stored procedures, functions, triggers, utility and test scripts; created legacy data migration scripts, DTS packages, and scheduled SQL Agent jobs; ASP.NET development using VB.NET, JavaScript, HTML, and CSS; lead code review, applied Microsoft development best practices, and enforced State Of CA DOC IT standards.
• Project Management duties - Created project plan. From the detailed requirements and design documents I created a work breakdown structure of all development and test tasks and loaded them into MS Project. Tasks were broken into 1-4 hour subtasks and assigned to resources. Using dependencies and predecessors I created a project schedule and Gantt chart. Responsible for day-to-day project management including modifications to project plan, task scheduling, resource assignments.
• Business Systems Analyst duties - For complaints web I 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 and data ownership, complaint assignments, and functional procedures / rights / responsibilities for processing throughout the complaint life-cycle. The details of this collaboration were documented and encapsulated in use cases. For both webs I gathered, defined, and documented detailed requirements and functional specifications for review and sign-off.
• 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, MS Project, Windows 2000 Advanced Server.
(Additional experience information available upon request)
Academic Background
1982-02 - 1984-12
1979-09 - 1981-12