CLOSE OVERLAY

Paul Lundgren

TITLE

Database Administrator, SUDAS

PHONE

515-294-8103

EMAIL

paullund@iastate.edu

AFFILIATIONS

InTrans, SUDAS

About Paul

Paul Lundgren is a Database Administrator for the Institute for Transportation, assigned to work on the Iowa Public Works Service Bureau project. He has a background in computer science and communications, and has worked in the fields of data analysis, report development, quality assurance, and customer service. He is a native Iowan who has lived in Ames since 2000, and is in his second position with the University, having worked as a computer technician in the Veterinary Medicine building.

Education


  • AAS, Hamilton College, Mason City, IA
  • BA, Communications, Western Illinois University, Macomb, IL
  • AA, Liberal Arts, Southeastern Community College, West Burlington, IA

Professional Certifications


  • Microsoft Certified Solutions Associate – Database Development, SQL 2016
  • Foundation-Level QA Certification, American Software Testing Qualifications Board
  • CompTIA A+ Desktop Technician

Software & Hardware Experience


  • ETL development using SQL Server, SSIS, and Alteryx in a combined Salesforce and MSSQL environment (3 years)
  • Writing queries for SQL Server, including Teradata, Microsoft, and Oracle platforms (5 years)
  • Developing reports in SSRS, MS Report Builder, Power BI, and InfoMaker report development software (5 years)
  • MS Office Suite 2007–2016, expert level user of Word, Excel, and PowerPoint (10+ years)
  • Microsoft Windows 95-Windows 10 troubleshooting (10+ years)
  • MS SharePoint for documentation and forms creation (2 years)
  • Adobe Acrobat Professional (5 years)
  • XML and HTML development (2 years)

Professional Experience


Wells Fargo, Data Consultant (April 2020–present)

  • Writes complex SQL queries in Teradata for data analysis and transformation
  • Creates data analysis reports in Microsoft Excel
  • Creates and maintains complex ETL processes with SSIS to move data between servers so as to measure key performance indicators for marketing campaigns

 Intoxalock, Data Analyst/Report Developer (September 2019–April 2020)

  • Writes complex MSSQL queries for data analysis and transformation
  • Creates data analysis reports in SSRS and Microsoft Power BI
  • Advises the engineering department on historical patterns of system performances of small-scale mechanical and digital devices

Holmes Murphy & Associates, ETL Developer (November 2018–September 2019)

  • Developed workflow packages for insurance benefits department
  • Created new database structures in MSSQL for ETL processing
  • Wrote complex MSSQL queries for data analysis and transformation
  • Assembled ETL workflows in Alteryx for transferring data between MSSQL and Salesforce.
  • Performed quality assurance testing in Salesforce front-end environment

Amerigroup Iowa, Business Information Analyst (June 2017–November 2018)

  • Worked in the finance department to produce Medicaid reporting and data analysis
  • Produced advanced, ad-hoc T-SQL queries for reporting purposes
  • Assembled data within Excel, using pivot tables, charts, and trend lines
  • Provided low- to high-level analysis of financial trends for the finance director and company executives

Wells Fargo Financial Services, QA Analyst (April 2017–June 2017)

  • Worked within a 15-member team with a high degree of collaboration to ensure accurate deployment of internal content management system
  • Examined source and targeted files in HTML and XML to verify accuracy of translation to new content system
  • Used Access and Excel for error tracking and reporting

Iowa State University, Ames, IA, Support Specialist II (January 2015–February 2017)

  • Implemented new Oracle PL/SQL-based browser management and billing software system for animals cared for in the ISU’s Lab Animal Resources department
  • Created custom business reports for end users using Oracle SQL Developer 3 and 4, within SSRS
  • Generated ad-hoc SQL queries as needed for multiple lines of business and analytic requirements
  • Created new views and stored procedures for new system requirements
  • Made periodic recommendations to the director of Lab Animal Resources and the Attending Veterinarian on technology issues and system performance
  • Collaborated with database administrators to implement database upgrades in coordination with the software vendors
  • Gathered end-user requirements, documented them, and either passed them on to the software vendor or developed and implemented them myself
  • Performed basic and advanced modifications to the program’s layouts in XML, per requirements gathered from end users
  • Conducted in-house training and continuing education sessions for university personnel, including veterinarians, bookkeeping personnel, and animal caretakers
  • Served as CorePlus Coordinator for the Lab Animal Resources department, maintaining and troubleshooting department computers and peripherals

Xpanxion, LLC, Ames, IA, QA Tester (February 2013–December 2014)

  • Executed test cases and test plans including executing SQL scripts in testing environment.
  • Performed comparison queries between T-SQL and PL/SQL
  • Verified and prioritized defects and determining their severity
  • Updated knowledge base for client project using various tools, including MS Excel, Microsoft Test Manager, Google Drive, and SharePoint

Senior Forms Developer

  • Developed PDF reports using Sybase SQL Server
  • Delivered QA products under deadline
  • Used web-based business analysis software to report to team leaders and other project members

Ortho Computer Systems, Ames, IA, Software Support Representative (May 2000–January 2013)

  • Provided phone support of multiple proprietary software programs across a wide variety of platforms
  • Conducted over 150 trainings for customers’ office staff on the implementation of proprietary software both on-site and company sponsored training environments
  • Trained new employees on software
  • Managed software issues across departments
TOP