JOHN A LOFGREN

Escondido, California

acxwo4@r.postjobfree.com

760-***-****

SUMMARY

Database Developer/Administrator with thirty years experience with both software development and system administration.

Database Developer/Administrator for Silver Spring Networks.

SQL Server Database Administrator for WellPoint, Freight Capital.

SQL Server Reporting Services for SunTrust Mortgage, Dept. of Veterans Affairs and Honeywell International.

Server and workstation administration at Digirad Corporation.

Planned and implemented the server, workstation and network environment for the Unisys Rancho Bernardo manufacturing plant.

Server administration, server configuration and software development for Unisys clients.

Expertise in disaster recovery planning and implementing fault tolerance.

Has a Master’s Degree in Computer Science.

SKILLS

Databases

Transact-SQL

SQL Server Integration Services (SSIS)

SQL Server Reporting Services (SSRS)

Microsoft SQL Server database administration

Active Directory queries and updates using LDAP

Programming Languages and Tools

.NET Framework, C#, Visual Basic, Visual Studio

PowerShell, Perl

Excel programming using VBA and .NET

TortoiseSVN Subversion

Astera Centerprise Data Integrator

System Administration

SQL Server

Windows Server

VMWare

Active Directory

Dell KACE K1000 Management Appliance and K2000 Deployment Appliance

Clustered Servers

SharePoint, IIS

Exchange Server

Veritas NetBackup, Symantec Backup Exec

Dell Compellent SAN, EMC SAN

Local Area Networks

DNS, DHCP, TCP/IP

Disaster Recovery Planning, Fault Tolerance

PROFESSIONAL EXPERIENCE

Silver Spring Networks, Escondido, CA

June 2014 – November 2016

Database Developer/Administrator

Developed C# programs and SSIS packages to import utility company customer billing records into SQL Server databases. Electric, Water, and Gas utilities periodically uploaded their account and billing records to an FTP server as CSV files. The format of these files was unique to each utility and required custom programs and SQL scripts to be written to convert their data into a consistent format to be validated and then inserted into each utility’s database. Once uploaded, the data could then be analyzed for meter tampering by the customer or an incorrectly installed or configured meter.

The software was written as a multi-tenant application which was most commonly run on corporate servers, but was sometimes installed on the utility’s own servers.

Administered corporate database servers.

Wrote PowerShell scripts to manage files, certificates, database servers, and read utility files to verify data loading. Wrote C# unit tests and integration tests.

Managed the SSRS report server. Managed the VMware hosts and virtual machines.

WellPoint, Inc., Richmond, VA

July 2013 – June 2014

Database Administrator – Contractor

Maintained two SQL Server 2008 R2 servers used by the Decision Support Services group within the Health Management Corporation (HMC) subsidiary of WellPoint. Managed backup and recovery, SQL Server agent jobs. The servers were used for Access and SSRS reporting. Used T-SQL and PowerShell for management. Devoloped SSRS reports showing call center performance metrics.

Freight Capital, Carlsbad, CA

December 2012 – April 2013

Database Administrator – Contractor

Setup twelve SQL Servers in preparation for migration of applications and databases to new, hosted server environment. Wrote PowerShell scripts to handle all periodic maintenance and backup tasks and to remove old backup files while retaining yearly, monthly, and weekly archives. Setup SAP BusinessObjects Enterprise server to host and schedule Crystal Reports generation. Wrote SQL stored procedures to handle queries for Crystal Reports when the Crystal Reports data filtering and aggregation was too slow.

Digirad Corporation, Poway, CA

June 2011 – October 2012

Senior Systems & Applications Analyst

Managed Windows Servers running as VMware Virtual Machines with Dell Compellent SAN storage. Wrote PowerShell scripts to manage servers, update and query Active Directory. Administered Dell KACE K1000 Management Appliance to track inventory of corporate workstations. Wrote VBScripts to administer workstations through the K1000. Deployed software through K1000. Captured and deployed workstation system images through Dell KACE K2000 Deployment Appliance. Tracked workstation assets through K1000 database and Active Directory queries. Developed Astera Centerprise workflows to import XML files into SQL database. Administered SharePoint 2007 and SharePoint 2010 servers.

SunTrust Mortgage, Richmond, VA

September 2010 – June 2011

Analyst - Contractor

Wrote SQL queries against the corporate mortgage tracking databases and designed SSRS reports for SunTrust Mortgage management. The reports are used to track the workflow in handling problem mortgages. Used T-SQL, SSMS, Visual Studio, BIDS, SSRS 2005, SSRS 2008.

Science Applications International Corporation (SAIC)

October 2009 – May 2010

Sr. Programmer/Analyst

Contractor at the Department of Veterans Affairs Austin Automation Center. Wrote reports against data warehouse holding records of ten years of medical encounters at VA hospitals and clinics nationwide. Some tables had 800 million records. Many of the reports were used for data validation; null counts or counts of discrete values. Used T-SQL, SSMS, Visual Studio, SSRS 2008.

Unisys Corporation

June 2006 – March 2009

Senior Consultant

Consultant for Unisys customers as system administrator and software developer.

Setup SQL Server 2000 and IIS for Honeywell International for SSRS reporting on their LANDesk computer asset databases. Wrote SSRS reports using T-SQL, SSMS, stored procedures, and Visual Studio. Heavy use of dynamic SQL so that reports could be run against any of two dozen database servers collecting asset information worldwide. Imported HR data so employee information could be matched against computer login data.

Unisys Corporation

February 1982 – June 2006

Business Support Services Senior Analyst

Lead analyst supporting servers, desktop workstations, and the local area network for the Unisys Rancho Bernardo manufacturing plant with about 750 employees.

Developed programs and scripts to automate tasks related to system administration using Visual Basic, T-SQL, Oracle SQL, Perl, VBScript.

Researched, designed, installed and configured new systems and then trained other team members on their management and use.

Participated in corporate-wide teams, planning and standardizing services such as Active Directory and Exchange.

Developed and tested Disaster Recovery plans for site, including file servers, Exchange servers, and database servers.

Designed and wrote a MS SQL database and Visual Basic applications for comparing computer asset information from a wide variety of sources including DNS, DHCP, Active Directory, WINS and the corporate computer asset database. This system as intended for use in matching up workstation information when no single system collected all of asset data such as MAC address, IP address, computer name, and login names.

EDUCATION

Master of Science, Computer Science, West Coast University, Los Angeles, 1984

Bachelor of Science, Electrical Engineering, California State University Long Beach, 1979

PROFESSIONAL CERTIFICATION

Microsoft Windows SharePoint Services 3.0 – Configuration

VMware Certified Professional on VMware Infrastructure 3 (VI3)

Contact this candidate