Dan Newton

Dan Newton

Database Administrator at TUSD

Location
Tucson, Arizona (Tucson, Arizona Area)
Industry
Computer Software

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you and Dan Newton know in common
  • Get introduced to Dan Newton
  • Contact Dan Newton directly

View Dan's full profile

Dan Newton's Overview

Current
  • Database Administrator at TUSD
Past
  • Database Engineer at HealthTrio
  • Sr. Computer Systems Architect at Raytheon
  • Database Administrator at Knowledge Computing
  • Principal Database Administrator at ScriptSave
  • Database Administrator at Captaris
  • Program Developer / Database Programmer at Arizona Mail Order
  • Operations Analyst at Mileage Plus
  • Reports Specialist at AT&T American Transtech
Education
Connections

208 connections

Dan Newton's Summary

* Extensive database administration and SQL coding, focusing on SQL Server data extraction, transforming, and loading (ETL) as well as automation of data handling.
* Experienced with all aspects of transforming data into business intelligence (BI) with various reporting suites.
* Have successfully managed employees in the database / business intelligence areas.

Dan Newton's Experience

Database Administrator

TUSD

Educational Institution; 5001-10,000 employees; Education Management industry

June 2014Present (4 months) Tucson, Arizona

Database Engineer

HealthTrio

Privately Held; 51-200 employees; Computer Software industry

April 2012June 2014 (2 years 3 months) Tucson, Arizona Area

Database Engineer
August 2013 to June 2014

Database Services Specialist
April 2012 to August 2013
* Working with SQL Server 2008 and 2012 Integration Services (SSIS). Major points involve variable data sources and logins, decrypting passwords, looping through servers, variables, shredding recordsets, and logging results and errors.

Sr. Computer Systems Architect

Raytheon

Public Company; 10,001+ employees; RTN; Defense & Space industry

January 2007April 2012 (5 years 4 months) Tucson, Arizona Area

Sr. Computer Systems Architect -- Supply Chain
March 2009 to April 2012
* Create reports and dashboards with Xcelsius and Crystal Reports. Use SAP Business Explorer (BEx) Query Designer as data source.
* Help with flow, validity, automation, and presentation of information.
* Investigating new reporting formats such as Silverlight (using Visual Studio 2010, Deep Zoom, and PivotViewer).
* Administrator of Kinaxis RapidResponse - supply chain management and operations management software.

Business Intelligence Analyst -- IT
January 2007 to March 2009
* Perform a variety of data warehouse reporting functions.
* Develop and modify corporate reports; verify information integrity; and design BI dashboards, scorecards, charts / graphs, drill-downs, and dynamic reports.
* Knowledge areas include data marts, reporting, OLAP design, and analytics.
* Use Oracle 10g, Oracle Discoverer, Toad, Cognos, and Informatica.

Database Administrator

Knowledge Computing

August 2006January 2007 (6 months) Tucson, Arizona Area

* Led move in migrating Coplink database from SQL Server to Oracle 10g and 9i. Converted by hand 40,000 lines of SQL code, covering 280 stored procedures and 80 functions, moving from T-SQL to PL/SQL.
* Main tools used were Toad and SQL*Loader.

Principal Database Administrator

ScriptSave

Privately Held; 51-200 employees; Health, Wellness and Fitness industry

March 2002August 2006 (4 years 6 months) Tucson, Arizona Area

* Led move to new data warehouse format and indexing, decreasing query time and size of databases. Critical project since tables contained up to 150 million records each.
* Created back-end data-marts for Business Intelligence dashboards for use with Business Objects and SQL Server Reporting Services.
* Automated all data importing/exporting to DTS/SSIS packages and stored procedures.
* Set up all database maintenance and backup/restoration processes.
* Managed small team of one junior database administrator and two report developers.

Database Administrator

Captaris

Public Company; 5001-10,000 employees; OTEX; Computer Software industry

19992002 (3 years) Tucson, Arizona Area

* In charge of data migration project for new company-wide Customer Relationship Management (CRM) program with 360+ users. Moved all automated triggers to SQL Server.
* Maintained SQL Server databases - performed operations such as optimizations, backups, standardization, data transformation services (DTS), and data scrubbing.
* Instituted snapshot replication between business sites, created decision-support database to free resources of live database.
* Created users and maintained security, both Windows based and SQL Server based.

Program Developer / Database Programmer

Arizona Mail Order

July 1997September 1999 (2 years 3 months) Tucson, Arizona Area

* Created productivity tracking program in Visual Basic which allows management to comprehend exactly what 260 customer service employees accomplish during any time period. This allowed for clearer understanding of productivity, problem areas, and accurate goal setting, which has led to completely revamping employee evaluation.
* Created OLAP just-in-time inventory planning system to help plan inventory levels and needs.
* Trained 30 users on aspects of databases such as report running, importing of data via SQL and Visual Basic from AS/400, Call Management System, and data entry.
* Managed one data-entry employee.

Operations Analyst

Mileage Plus

June 1996July 1997 (1 year 2 months) Tucson, Arizona Area

* Oversaw database management for entire call center. Created databases, reports based on need. Ensured databases were properly maintained and data was accurate.
* Tracked monthly productivity of 240 employees using multiple databases and CMS.
* Interpreted report data, made recommendations to improve operating efficiency.

Reports Specialist

AT&T American Transtech

Public Company; 10,001+ employees; T; Telecommunications industry

June 1993June 1996 (3 years 1 month) Tucson, Arizona Area

* Responsible for researching, compiling statistical reports to summarize call center's productivity by using Call Management System, Excel, Access.
* Responsible for reporting on four programs with roughly 200 telemarketers on a daily/weekly/monthly/project-to-date basis.

Dan Newton's Skills & Expertise

  1. SQL
  2. SQL Server
  3. T-SQL
  4. Stored Procedures
  5. SSIS
  6. ETL
  7. Star Schema
  8. Databases
  9. Database Design
  10. Business Intelligence
  11. Data Warehousing
  12. Crystal Reports
  13. SAP BI/BW
  14. Web Intelligence
  15. Social Media
  16. Web 2.0
  17. Healthcare Information Technology
  18. Data Mining
  19. Market Basket Analysis
  20. Microsoft SQL Server
  21. SDLC
  22. Disaster Recovery
  23. PL/SQL
  24. Software Project Management
  25. Program Management
  26. Visio
  27. Database Administration
  28. Visual Studio
  29. SQL Tuning
  30. Visual Basic
  31. Architectures
  32. Architecture

View All (32) Skills View Fewer Skills

Dan Newton's Certifications

  • Microsoft Certified IT Professional ﴾MCITP) - SQL Server 2005

    • Microsoft
    • License A368-0006
    • June 2006
  • Microsoft Certified Technology Specialist ﴾MCTS﴿ - SQL Server 2005

    • Microsoft
    • License A368-0007
    • March 2006
  • Microsoft Certified Database Administrator (MCDBA) - SQL Server 2000

    • Microsoft
    • License A229-9218
    • June 2001
  • Microsoft Certified Professional (MCP)

    • Microsoft
    • License A229-9215
    • January 2001

Dan Newton's Education

University of Arizona

B.A., English

19891992

Contact Dan for:

View Dan Newton’s full profile to...

  • See who you and Dan Newton know in common
  • Get introduced to Dan Newton
  • Contact Dan Newton directly

View Dan's full profile

Not the Dan Newton you were looking for? View more »