SUMMARY:

• Have architected and developed numerous SQL Server databases for: global web services, global merchant bank account sales, global sales teams, social networking, artificial intelligence testing, HR benefits, financial investments, ISP traffic, CRM, finance reconciliation, and payroll. Includes SOA web service layers, reporting databases, system integrations, database ports, Hadoop integrations, standardization and PHP to .Net ports.
• Have full life - cycle experience with architecting, requirements gathering, analysis, design, mockups, pilots, development, implementation, configuration, rollouts, troubleshooting, enhancements, maturing, and maintenance for object-oriented ASP.Net web sites, web services, Windows Forms, reporting systems, databases, and class libraries. Includes multi-tier systems, system integrations, mentoring, standardization, and project troubleshooting.
• Experienced in cost-effectively implementing empirically-proven ‘best practices’, delivering robust and standardized database and application systems, offering ease of maintenance and extensibility. Skilled with predicting future requirements, maturing applications, optimizations, mentoring and troubleshooting.

TECHNICAL SKILLS:

Database & Web Servers: Microsoft SQL Server - DBA Architect/Developer up to version 2016, Oracle, Hortonworks Hadoop HDP 2.4, DB2 UDB, MySQL, IIS 8.5 to 5.0

Languages, Development Environments, Technologies & Tools: Microsoft Visual Studio .Net 2015 to 2003 IDE, Microsoft .Net Frameworks 4.6.2 to 1.1, C#, VB.Net, ASP.Net, ASP, XHTML, HTML, AJAX, JavaScript, jQuery, AngularJS, Bootstrap, JavaScript libraries, MVC, Web Forms, Web Controls, Web Services (REST, WSDL, SOAP), Windows Forms, WCF, T-SQL, LINQ, XML, XSLT, HTTP, CSS, Responsive UI, Globalization and Localization, SSIS, DTS, SSRS, SSAS, Tableau, Crystal Reports, Visio, UML, TFS, SourceSafe, Install Shield, API/SDK’s and 3rd party controls/components such as Telerik, DevExpress, ComponentOne etc.

PROFESSIONAL EXPERIENCE:

.Net & SQL Server Senior Software Engineer

Confidential, Tampa, FL

Responsibilities:

• Full-stack full life cycle support for any and all clients.
• Work included requirements, analysis, design, development, deployment, maintenance and maturing of:
• A .NET/SQL Server/Hadoop system, that retrieved hourly global web server logs from forty plus servers around the world. The log’s data structures were parsed and standardized, compressed and backed up to a file server, ported into Hadoop. Teradata was also parsed into a rapid-response reporting database that served a client facing visual dashboard. Notable here was developing a robust bleeding edge C# interface to a Hadoop teradata database, 6 SQL Server databases, in-memory file compression and streaming limiting server hard-drive IO, and master/agent Windows services with full accountability and monitored logging..
• Advertisement constructor/scheduler program and databases, that serves sites such as eBay.com, Walmart.com and SamsClub.com, handling 5 million plus page views per day. 10K+ lines of code.
• Product/price feed constructor/scheduler program, database and Windows Service, serving Walmart.com, handling 5 million plus page views per day.
• An events constructor/scheduler program, serving Walmart.com.
• Class library and database providing centralized exception logging for all web sites and server applications.
• Web service that returned merged results from a Yellow Pages, Yelp etc search, and a related return from a database of preferred vendor’s lists.
• Web service and database service providing geo services, such as zips within x miles range etc.
• Common service and object-oriented .Net class libraries across all apps, for business processes, business rules, data access, and proactive exception handling. In the fast moving marketing industry, extensibility, stability and maintainability were high concerns.
• Master Page, AJAX, jQuery, JavaScript, HTML5, Flash, and CSS based web forms, and Windows Forms utility applications. jQuery functionality such as watermarking, auto-complete, etc.
• Primary technologies used were IIS 7 & 8.5, SQL Server 2014, 2012 & 2008R2, Hortonworks Hadoop HDP 2.3, Teradata, JSON, Microsoft .Net Frameworks 4.6.2 to 3.5, Visual Studio .Net 2015 to 2008 (due to legacy apps support), ASP.Net, C#, VB.Net, CSS, MVC, Web Forms, Web Services, Windows Services, AJAX, jQuery, JavaScript, JavaScript libraries, Adobe Creative Suite 6.0 Master Collection, TFS, and SourceSafe.

.Net & SQL Server Senior Developer

Confidential, Clearwater, FL

Responsibilities:

• Full-stack full life cycle architect and developer of the Transition’s Squinty globalized multi-language microsite at LifeLessSquinty.com, LifeLessSquinty.ca, and UnevieSansGrimacer.ca.
• Work included requirements, analysis, design and development of:
• A small web-oriented secure SQL Server 2008R2 database, enforcing data integrity.
• Service and object-oriented .Net class libraries for business processes, business rules, data access and proactive exception handling.
• Master Page, AJAX, jQuery, JavaScript, and CSS based web forms with specialized CSS localizations. jQuery functionality such as watermarking, auto-complete, image cropping, etc.
• Primary technologies used were IIS 7, SQL Server 2008R2, Microsoft .Net Frameworks 4.0, Visual Studio .Net 2010, ASP.Net 4.0, C#, CSS, Web Forms, Web Services, AJAX, jQuery, JavaScript, Adobe Creative Suite 5.0 Master Collection, TFS 2010.
• 100% remote telecommute work, with bi-weekly QA and staging updates, from fully established MSDN home office, including redundant internet, firewalls, servers and workstations; source repositories; virtual test beds; automated backups; etc.

.Net & SQL Server Senior Developer

Confidential, Tampa, FL

Responsibilities:

• Senior developer enhancing Confidential ’s flagship product, Clarity ENR - Election Night Results.
• Work included extensive analysis of complex system issues, including data-intensive client-side JSON/JavaScript, AJAX, Web Services, .Net refactoring, database integrity, indexing and query optimizations.
• Support of older PHP Asset Management module.
• Primary technologies used were IIS 7, SQL Server 2008, MySQL 5.1, JSON, Microsoft .Net Frameworks 4.0/3.5/2.0, Visual Studio .Net 2010, ASP.Net, C#, VB.Net, CSS, WCF, Web Services, SSIS, SSRS, XML, AJAX, jQuery, JavaScript and TFS.

.Net & SQL Server Lead Developer (contract)

Confidential, St. Petersburg, FL

Responsibilities:

• Full-stack full life cycle lead developer of the Confidential portal.
• Work included requirements, analysis, design and development of:
• Portal class library that allowed a user to have multiple portals open within multiple browser tabs, while maintaining session state for each tab.
• CSS/theme based portal site, with full AJAX and JavaScript polish.
• Object-oriented .Net class library layers for business processes and rules, data access and proactive exception handling.
• SQL Server 2008 tables, stored procedures, functions and reports.
• Enhancement to credit card processing classes for secure code.
• This was a full .Net port and rewrite of an extant PHP site.
• Primary technologies used were IIS 7/6, SQL Server 2008, SSRS, SSIS, Microsoft .Net Frameworks 4.0/3.5/2.0, Visual Studio .Net 2010/2008, ASP.Net, C#, CSS, WCF, Web Services, XML, AJAX, jQuery, JavaScript, and TFS.

SQL Server & ASP.Net Architect, Lead Developer & Mentor

Confidential, St. Petersburg, FL

Responsibilities:

• Full-stack full life cycle architect and lead developer of the global multi-language merchant account lead referral online application, serving over 500 customer banks and branches.
• Work included requirements, analysis, design and development of:
• A web-oriented secure SQL Server 2008 database, enforcing extensive data integrity with tables, triggers, stored procedures, views, column encryption, functions, SSIS packages, jobs, maintenance cycles, and backup/restore policies.
• World-wide, multi-language SQL Server Reporting Services framework.
• Service and object-oriented .Net class libraries for business processes, business rules, data access and proactive exception handling.
• Master Page, CSS and theme/skin based web forms with high-integrity data functionality, AJAX and JavaScript.
• Mentoring in Microsoft SQL Server and .Net best practices re software and hardware architecture, design, development, documentation, maintenance, enhancements and code security; including scalability, extensibility and maintainability considerations.
• Supported extant PHP site.
• Primary technologies used were IIS 7/6/5, SQL Server 2008, SSRS, SSIS, Oracle 11g, Microsoft .Net Frameworks 3.5 and 2.0, Visual Studio .Net 2008, ASP.Net 3.5/2.0, VB.Net, C#, CSS, Web Forms, Windows Forms, WCF, Web Services, XML, AJAX, jQuery, JavaScript, Adobe Acrobat, Visio Enterprise, Access 2007, and Visual SourceSafe 2005.

.Net & Oracle Lead Developer

Confidential, Largo, FL

Responsibilities:

• Full-stack full life cycle lead developer of the worldwide sales force administration web site.
• Work included requirements, analysis, design and development of:
• A fully developed, high transaction, secure SQL Server 2008 database, enforcing extensive data integrity with tables, triggers, stored procedures, views, data types, functions, SSIS packages, jobs, maintenance cycles, backup/restore policies.
• Service and object-oriented .Net class libraries for business processes, business rules, data access and proactive exception handling.
• Master Page, CSS and theme/skin based web forms with high-integrity data functionality, AJAX and JavaScript.
• Mentoring in Microsoft SQL Server and .Net best practices re software and hardware architecture, design, development, documentation, maintenance, enhancements and code security; including scalability, extensibility and maintainability considerations.
• Primary technologies used were IIS 7/6, Oracle 10g, Microsoft .Net Frameworks 2.0 and 3.5, Visual Studio .Net 2008, ASP.Net 3.5/2.0, VB.Net, CSS, Web Forms, Windows Forms, AJAX, JavaScript, Adobe Acrobat, Visio Enterprise, Access 2007, Visual SourceSafe 2005, DevExpress & Telerik .Net toolsets.

SQL Server & ASP.Net Architect, Lead Developer & Mentor

Confidential, Palm Harbor, FL

Responsibilities:

• Full-stack full life cycle architect and lead developer of the core engine for Confidential .
• Work included requirements, analysis, design and development of:
• A fully developed, high transaction, secure SQL Server 2008 database, enforcing extensive data integrity with tables, triggers, stored procedures, views, data types, functions, defaults, SSIS packages, jobs, maintenance cycles, backup/restore policies, and upgrading from SQL Server 2005 to 2008.
• Service and object-oriented .Net class libraries for business processes, business rules and web services, including login; roles; automation - emails, membership maintenance, data maintenance, etc.; data access and proactive exception handling.
• Master Page, CSS and theme/skin based web forms with high-integrity data functionality, JavaScript and AJAX enhancements.
• Visio UML design and documentation.
• IIS implementation and setup.
• Training and mentoring of a junior developer in Microsoft SQL Server and .Net best practices re software and hardware architecture, design, development, documentation, maintenance, enhancements and code security; including scalability, extensibility and maintainability considerations.
• Primary technologies used were IIS 7/6/5, SQL Server 2008/2005, SSRS, SSIS, Microsoft .Net Frameworks 2.0 and 3.5, Visual Studio .Net 2008, ASP.Net 3.5/2.0, C#, VB.Net, CSS, Web Forms, Windows Forms, AJAX, JavaScript, WCF, Web Services, XML, LINQ, Adobe Acrobat, Visio Enterprise 2002, Access 2007 and Visual SourceSafe 2005.
• 100% remote telecommute work.

SQL Server DBA & SOA Architect & Developer

Confidential, Dunedin, FL

Responsibilities:

• Full-stack architect and developer of database and web service SOA layer, servicing Impact-i.com sites and 3rd party sites, while establishing and mentoring on Microsoft best practices regarding:
• SQL Server database designing for web sites and web services.
• .Net solution frameworks, object-oriented coding, and documentation, c) enterprise-class data access.
• Enterprise-class standardized proactive 3-tier exception handling; i.e. database, web server and JavaScript/client tiers.
• Visual SourceSafe usage and code security.
• Refactored and stabilized the SQL Server replication implementation; optimized extensive SQL Server jobs; upgraded three 2000 databases to 2005, and designed and implemented a stable backup and disaster recovery plan for the four WAN SQL Server servers.
• Web service SOA layer was full life cycle, including data integrations with Microsoft Dynamics GP & SL (Great Plains & Solomon).
• Supported PHP sub-sites, including porting to .Net.
• Primary technologies used were SQL Server 2005 & 2000, SSIS, Microsoft .Net Frameworks 3.5/3.0/2.0/1.1 , IIS 6 & 5, Visual Studio .Net 2008/2003, ASP.Net, VB.Net, C#, CSS, WCF, Web Services, SOAP, XML, XQuery, AJAX, JavaScript, LINQ, Visio and SourceSafe.
• 40% remote telecommute work, i.e. 2 days offsite/3 days onsite; as part of a two year restructuring plan aimed at reducing the central office overhead by 75%.

SQL Server & ASP.Net Architect, Lead Developer & Mentor

Confidential, Dunedin, FL

Responsibilities:

• Full-stack full life cycle architect and lead developer of the new online CBT commerce site IQTtesting.com. Site consists of:
• Object-oriented modules for testing, registration, proctor, rater, client, administration and maintenance.
• An internet-based .Net Windows Forms administrative application.
• Work included requirements, analysis, design and development of:
• A ‘master page’ structure design under the Microsoft .Net Framework 1.1; i.e. before Microsoft’s Master Pages was released near the end of 2005.
• A fully developed, high transaction, high security SQL Server 2005 database, enforcing extensive data integrity, including tables, triggers, stored procedures, views, functions, DTS/SSIS packages, jobs, maintenance cycles, backup/restore policies, and upgrading from SQL Server 2000 to 2005.
• .Net class libraries for business processes, web services, shopping cart, credit card processing, automated email, data access and proactive exception handling.
• Web form interfaces with high-integrity data-entry functionality, including extensive JavaScript and AJAX interface enhancements.
• IIS 6 implementation and site setups.
• SQL Server hardware analysis, purchase, build and rollout.
• Training and mentoring of developers in Microsoft SQL Server and .Net best practices re architecture, design, development, documentation and maintenance, including scalability, extensibility and maintainability considerations.
• Primary technologies used were IIS 6 & 5, SQL Server 2005 & 2000, SSIS/DTS, Microsoft .Net Frameworks 2.0 & 1.1, Visual Studio .Net 2005 & 2003, VB.Net, C#, CSS, Web Forms, Windows Forms, Web Services, JavaScript, AJAX, Adobe Acrobat, Visio Enterprise 2002, Access 2003 and Visual SourceSafe.
• 20% remote telecommute work, aimed at establishing effective and practiced critical staffing, capable of functioning from remote locations during emergencies such as hurricanes.