9 Ontur Lane
Hot Springs Village, AR 71909-6105
(Hot Springs/Little Rock, Arkansas metro area)
Summary: | Database | Website |
---|---|---|
Developer | ✓ ✓ | ✓ |
Administrator | ✓ | ✓ |
My speciality is Microsoft SQL Database Developer, but my real strength and value is the breadth of my experience. Whether you want a short-term contractor to get your shop into shape, or a long-term staff member to keep it that way, I will figure out how to do what you need done. I am equally comfortable as a lone operative, team leader, or team member.
Excel Pivot Table Best Practices for Loading Data Directly from SQL Server
Transact-SQL, ASP.Net, JavaScript, PowerShell, VB, XML, XSLT, HTML, CSS, C#.Net
Microsoft SQL Server 2016, Oracle 12c, MySQL 5, Windows Server 2012R2 (IIS 8.5), VMWare 5.5
Microsoft Visual Studio/TFS 2015, SourceGear Vault, SolarWinds DPA, TeamViewer
Antelope, CA — In coordination with TrueCourse Solutions (a business and IT management consultancy), I help CPUC manage the current administrator of the California LifeLine program.
In coordination with BMIsmartCloud (formerly ComputerStuff4You), I handle a wide variety of integration and conversion projects.
McClellan, CA — Conduent is a Business Process Outsourcing company spun off from Xerox.
Skills Used: Microsoft SQL 2008R2, SQL 2012, SQL 2016, SSIS, SSRS; TFS 2010, TFS 2015, ASP.Net, JavaScript, C#.Net, XML, SQLCLR, SOAP web services, SoapUI, PowerShell, Windows Server 2008R2 (IIS 7.5), Windows Server 2012R2 (IIS 8.5), AWS, VMWare
McClellan, CA — Xerox inherited State and Local contracts when it acquired ACS.
Antelope, CA — In coordination with ComputerStuff4You (an IT services company), I handled a wide variety of integration and conversion projects.
Skills Used: Microsoft SQL 2000, SQL 2005, SQL 2008R2, SQL 2014; ASP.Net, JavaScript, Visual Basic, Oracle 10g, Oracle 11g, Oracle 12c, PowerShell, FreePBX, MySQL, Excel VBA and Pivot Tables, Microsoft Access 2003, Access 2007, Access 2013, SalesForce SOQL/SOSL, SharePoint 2007, SharePoint 2010, Windows Server 2008 (IIS 7), Windows Server 2008R2 (IIS 7.5), Windows Server 2012R2 (IIS 8.5), AWS, VMWare, SourceGear, XML, XSLT, Praxis EMR, HL7, eMDs Medisoft and Lytec PM, Azalea EHR, SOAPware, Sybase Advantage, PostGres, TotalMD, DBISAM, SQL Server Migration Assistant (SSMA)
Sacramento, CA — CapRadio.org is a regional non-profit high-traffic content-rich public website, with audio streaming, podcasts, and RSS, based at Sacramento State University.
Skills Used: Microsoft SQL 2000, SQL 2005, SQL 2008, SQL 2014; ASP.Net, JavaScript, JQuery, Google Analytics, PowerShell, Umbraco CMS 4, XML, XSLT, Visual Basic, Windows Server 2003 (IIS 6), Windows Server 2008 (IIS 7), Windows Server 2012R2 (IIS 8.5), SourceGear Vault, IceCast, MusicMaster
Citrus Heights, CA — Repo Remarketing serves small lenders such as Credit Unions, simplifying the process of finding, recovering, and selling the vehicles of borrowers in default.
Skills Used: Microsoft SQL 2000, SQL 2005; ASP.Net, JavaScript, JQuery, Google Analytics, Visual Basic, Excel VBA and Pivot Tables, SalesLogix 7.5 CRM, Windows Server 2003 (IIS 6), Windows Server 2012R2 (IIS 8.5), Microsoft Exchange 2007, Exchange 2013, VMWare, Visual Source Safe, SourceGear, SOAP web services
Citrus Heights, CA — Optimized monthly data import and reporting processes, using Confio Ignite (now Solarwinds Database Performance Analyzer).
Granite Bay, CA — Created ASP.Net/JavaScript/SQL 2005 intranet CRM (Customer Relationship Management) database, upgraded from Access 2003/SQL 2000. Maintained and improved C#.Net client program for managing the process of IRS Section 1031 tax-deferred exchanges, in a database integrated with CRM, accounting, paperless document tracking, and address verification databases. Automated Word merges for monthly statements mailings. Extracted and formatted data for IRS e-filing (1099-INT). Setup VSS for source control, and Accounting document control. Automated daily status emails to clients, and alerts for accounting inconsistencies. Implemented SQL trigger audit trail, Excel Pivot Table reports.
Fair Oaks, CA — Designed and optimized SQL 2000 database for import, de-dup and publish of a million records per year of foreclosure data, from one nationwide and multiple regional vendors. Integrated with Goldmine 6.7 CRM database to drive ASP/JavaScript website and intranet. Implemented SQL trigger audit trail on published data, customers’ saved search criteria, and data delivery via web or email. Automated daily import of monthly recurring credit-card billing status from authorize.net payment gateway.
Folsom, CA — As a contractor in the teller-incentive department, optimized SQL 2000 DTS (Data Transformation Services). Developed table-driven system for parallel job execution, to run DTS packages as input files become available. Improved ASP/JavaScript intranet.
Kihei, HI — Synchronized SQL 2000 database of this vacation-activity reseller with the DBISAM database of activitylinksystems.com, using SQL views to minimize web changes, and Access to transfer data. Improved ASP/JavaScript websites.
Pleasanton, CA — Led the team for a CRM/Accounting intranet, using SQL 7, ASP/JavaScript, and Excel Pivot Tables. Used SQL triggers to implement a complete audit trail for customer and loan information. Upgraded ePASS Business Center (corporate datacenter) from SQL 6.5 to 7; migrated data from subsidiary to corporate datacenter. Setup hot-backup servers for reporting, fault-tolerance and disaster recovery; exported binary data to reduce database size. Defined XML schema for data transfer. Improved Access97 database used for data entry.
Walnut Creek, CA — Maintained the Onyx CRM (Customer Relationship Management) database on SQL 6.5, through two major upgrades with minimal downtime. Put VSS source control, data consistency and duplication checks in place. Integrated with ASP/JavaScript websites; created intranet IT trouble-ticket system.
Walnut Creek, CA — Maintained the Onyx CRM database on SQL 6, improving processes and adding business rules as required. Improved integration with Platinum accounting system. Created reports using Access97, and Excel Pivot Tables. Integrated with ASP/JavaScript website for tech support, with email notification.
Emeryville, CA — Became familiar with the organization of the system tables in relational databases (Sybase, Oracle, Microsoft SQL 4.2 and 6, and Informix). Wrote tools in TCL, portable between UNIX and NT. Created UNIX Shell, sed and perl scripts to automate capturing development databases, generating change reports from ClearCase source control, and extracting important error information from installation log files.
Walnut Creek, CA — Developed tools to parse and document C programs, using a TCL-like scripting language, C code, Shell and sed scripts, and batch files (portable between UNIX and DOS). Identified and solved weather data reception problems in Real-Time UNIX on Navy ships, increasing the error-free data rate eight-fold.
New York, NY — Created and maintained programs in C and Assembler (portable between DOS PCs and PDP mini-computers), to recover documents from obsolete computer systems, keeping visual formatting intact.
Bachelor of Electrical Engineering, The Cooper Union, New York, 1989.
Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Implementation and Maintenance, 2011 (MCP 2012)
Active in Sacramento SQL Server User Group; presented at SQL Saturday 2012 and 2014 and 2015.