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.
• 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.
• 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.
• 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.

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.
• 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.