Steve Tollefson Email & Phone Number

Scottsdale, Arizona

• Responsible for entire corporate office and production cloud IT infrastructure, including application and database administration, design and development, customer systems integration and support, network and server administration, and end-user support.• Perform network administration and design for corporate office and SunGard cloud, which includes installing, configuring, and maintaining servers running SQL Server, Exchange, .NET websites and Remote Desktop.• Created a SQL Server interface with Sabre’s CrewTrac crew management system that extracts flight, duty, and crewmember data. The data is then combined into layovers by crewmember using airline business rules and sent to a SQL Server OLTP database. By developing our own custom interface we were able to save approximately $250,000 in Sabre licensing fees.• Recently oversaw the migration of our SunGard datacenter platform from a physical rack to SunGard's VMware cloud product, resulting in a savings of approximately $50,000 in hardware and software refresh costs while maintaining the same monthly spend.• Led migration project of Nortel BCM 400 phone system to Avaya IP Office, which involved going through a detailed pre-planning and design process, installing new Avaya IP Office hardware and network switches, and programming the IP Office for both DID and customer service groups utilizing redundant telecom providers. Eliminating a long distance T1 and adding unlimited long distance to our existing analog lines, which were then used for the default outbound call center route, resulted in monthly cost savings of over 65%.

Phoenix, Arizona

• Designed and maintained SQL Server databases that facilitated reporting and fed healthcare applications. • Provided requirements, design and implementation direction for consultants developing PowerBuilder client/server applications for internal use. One such application resulted in savings of over $25,000 in yearly mainframe fees by bringing the data locally and creating a data entry and reporting interface.• Developed applications that automated SQL Server report procedures, allowing employees to run reports on demand.• Created data extracts used for analysis, NCQA and various outreach programs to CIGNA Healthcare members.

Phoenix, Arizona

• Microsoft SQL Server DBA and developer responsible for creating SQL stored procedures to automate ETL processing.• Sole developer on a project that created an ETL process to extract data from a healthcare platform, EPIC, which was loaded into a SQL Server data warehouse to be used for MIS reporting.• Provided Microsoft Access and SQL support as a technical consultant for Finance members in the Medical Economics department.• Administrator of Windows NT network that included building NT servers and workstations and providing PC hardware and software support.

Phoenix, Arizona

• Part of a four person client/server development team that created a SQL data depository of bank loan information using various mainframe source systems accessed through QMF/DB2.• Contributed to development of Visual Basic and Microsoft Access applications used by banking analysts to reconcile depository data and create essential MIS reports.• Performed systems analysis for new projects, including data analysis and database design.• Administrator of Novell network, Windows NT servers, and user PCs.

Phoenix, Arizona

• Installed software and peripherals, upgraded and repaired workstations, resolved problems with Windows and OS/2.• Trained employees to use Microsoft Office software applications.• Performed NetWare 3.12 administration.