16612 N 28th PL
Phoenix, AZ 85032
505.793.3339-C
602.534.3115-W
[email protected]
[email protected]
Ianohlander.com

P R O F E S S I O N A L   E X P E R I E N C E

City of Phoenix – Neighborhood Services Department

Phoenix, Arizona                                                                                                2015 – Present

Information Technology Analyst Programmer III – Responsible for the design, implementation and maintenance of Neighborhood Services Department specific applications to support business needs. Assisted the development and implementation of the department’s strategic plan and annual IT Budget plan. Advocated and participated in creating and carrying out departmental policies and procedures. Successfully managed projects include the financial and budgeting aspects of all IT departmental purchases including major department purchases and keeping them within budget. Evaluated, analyzed, and created policies and procedures to improve operations and to implement and manage new programs for the department. Managed complex projects from concept to fully implementation status.

Key Achievements:

• Leverage and extend utility of 25 years old legacy software by writing 20+ processes in Java and C#
• Designed and implemented Cloud based RESTful service in ASP.NET/C# to geocode addresses and coordinates and return comprehensive spatial data currently used by the City of Phoenix Microsoft Dynamics Enterprise Phoenix At Your Service system.
• Designed and implemented REST services in ASP.NET/C# as middleware for City of Phoenix Oracle backend and 3rd Party Vendor Web/Mobile application.
• Designed and implemented middleware process in C# to query, process and transfer data between City of Phoenix Microsoft Dynamics Enterprise Phoenix At Your Service system and Oracle Database/25 years old legacy department software.
• Use ArcMAP, Oracle PL/SQL queries and GIS Spatial Data to create maps to meet Neighborhood Services Department needs.
• Use Oracle APEX Rapid Application Development environment to design and implement new applications to fill business needs gaps in Neighborhood Services Department while awaiting funding to replace legacy Neighborhood Services Department applications.
• Design and implement Esri mapping web applications in JavaScript using ArcGIS API.
• Assisted in development of the department GPOs in Active Directory for Neighborhood Service Department and as administrator of the department’s Active Directory
• Implemented Crystal web server required for creating detail departmental reports, quality assurance reports, performance management reports, various customs reports, and the data in them to identify trends or problems areas.
• Participated in upgrade of SharePoint online department intranet and internet web sites
• Created, tested, and implemented new Oracle schemas, packages, procedures, functions, triggers, and cron jobs in PL/SQL to support 25 years old legacy client-server applications (with unchangeable code base) to add new business logic at the database level.

Oil & Gas Equipment Corp

Farmington, New Mexico                                                                                        2003 – 2015

IT Administrator- Oversaw all IT needs at Oil & Gas Equipment in Farmington, NM. Responsible for all hardware, including servers, desktops, laptops, wireless systems, server room, security access systems, Oil/Gas well automation systems, routers, firewalls, cellular and PRI phone systems. Maintained Domain, Mail, Line of Business, Well Control, and security access servers. Developed and wrote in-house software to fill business needs.

Key Achievements:

• Built, maintained, and monitored the server room, the wireless network, system security, the Domain (AD and GP), Exchange, inter/intra-net websites, backup and other server infrastructure for corporate and satellite locations. Set up
  and supported client workstations and laptops.
• Oversaw and managed upgrades, migrations and integration projects.
• Administered Line-Of-Business software system (Epicor Eagle on Linux server) for all stores, with an emphasis on problem solving and help-desking.
• Administered Supervisory Control And Data Acquisition (SCADA) System monitoring of 1000+ oil and gas wells for customers.
• Developed front-end for SCADA system for desktop (C#/Windows Forms), web and mobile (C#, AJAX and HTML5/JS3, CSS) platforms.
• Developed in-house Microsoft (VBA) and web-based (VBA and C#/.NET) software to meet various company needs.
• Maintained audio-visual equipment, including overhead projectors, laptops and video conferencing equipment.
• Administered and implemented unique routing rules on Cisco Routers using IOS programming language.
• Administered Nortel/Avaya PRI phone system, including programming and installation of handsets.
• Oversaw yearly planning and budgeting of IT projects and needs. Managed all vendors including purchasing and telecom contract auditing for IT expenditures.
• Worked with marketing department writing copy and designing displays in Photoshop and InDesign.
• Attended education courses for Nortel PRI products (2006), CygNet SCADA Systems (2004/7), Epicor LOB system (2005/6/8/9), Windows IT Pro Windows/Exchange Server conferences (2004/5/8).

Freelance Programmer

Casa Grande, AZ                                                                                                    2002 – 2003

Gathered customer needs, requirements and specifications to implemented custom software for clients in Access, Excel, and as Java web application.

Key Achievements:

• Designed Gem Show Reservation Application in Excel with Access database backend for hotel owner.
• Developed Data import tool into Access for Casa Grande Chamber of Commerce utilizing Java.
• Created specialized web browser for South Mountain Community College to gather land parcel information for import into Excel as part of light-rail research project using VB, XML, and SQL.
• Developed database driven website for Casa Grande Internet using JSP/Servlets, Java, and SQL.

E D U C A T I O N

Northern Arizona University

Flagstaff, Arizona

         Bachelor of Science, Bioinformatics and Computational Biology – currently pursuing

Sun Certified Programmer for the Java 2 Platform-                                           2/2002

S K I L L S   &   P R O F I C I E N C I E S

• Advanced experience in Java, C#, and ASP.NET
• Proficient in Razor, VB.NET, VBA, JavaScript, HTML5, CSS and PL/SQL
• Experience in Python, C++, C, IOS, and Assembly Language
• Ability to design RESTful Architecture and develop and maintain RESTful Cloud Services
• Ability to create Esri webapps using Esri map services, Javascript and ArcGIS API
• Ability to direct complex projects from concept to fully operational status.
• Ability to learn and leverage new languages and technologies quickly.
• Goal-oriented individual with strong leadership capabilities.
• Organised, highly motivated, and detail-directed problem solver.
• Proven ability to work in unison with staff, volunteers, and upper management.