Todd Niquette

Summary:

•** years of experience in software development, with a variety of methodologies: Waterfall, Iterative, Six Sigma, Agile.

•Extensive experience with a wide array of development team configurations (from two members to twenty), with as many as three Business Analysts and 70% offshore.

•Cooperated with a wide variety of Enterprise Architecture data analysts; designed data repositories of all sizes and complexities; each of them passed some of the most stringent QA (data naming standards, Third Normal Form, etc.) in the business.

Technical Skills:

•Web Technologies : JavaScript, J2EE, WebSphere

•.NET Technologies : ASP.NET, SOAP, Web Services

•Development Tools : Visual Studio 2005, VB6, WAS

•Languages : COBOL, JCL, TACL, perl, Java

•Markup Languages : HTML, XML

•Database : MS SQL Server 2012, MSAccess, Oracle 10g, HP Integrity Server

•Source Control Tools : Endevor, Dimensions

•Web Servers : Apache Tomcat

•Operating Systems : Windows (all), SUSE & RedHat Linux, BeOS

•Designing Tools : SharePoint Designer 2013

•Browsers : IE 11/10/9/8/7/6, Google Chrome, Firefox, Safari

•Others : BMC Control-M, CA Eureka Strategy, iWave Integrator

Professional Summary:

SELF-EMPLOYED

June 2012-present

Role: Independent Contractor

Projecst: Server builds, Network troubleshooting, some ITSM consulting on intermediate releases of ServiceNow).

Department: varies

Environment: Windows Server 2008 R2 and 2012, ServiceNow

Roles and Responsibilities:

•Worked with many individual clients on an informal basis for nearly all of their IT needs – general troubleshooting of hardware, software and network

•Consulted with several firms on ITSM/ServiceNow, mainly in conjunction with several former team member who are currently working for Fruition Partners of Chicago, a Top 5 ServiceNow consulting firm.

•One former colleague/protégé developed a custom query solution in Jelly, which won Fruition’s “Innovation of the Year” award for 2012-2013.

•On contract to USPS via Northrop Grumman for ServiceNow enhancements, Jan-Feb, 2017.

•Consulted with Navitus Health Services on K2 (Connectus) CRM, June-July 2018

HENNEPIN COUNTY, MINNEAPOLIS, MN April 2015 - Dec. 2015

Role: Principal Software Specialist

Department: IT Operations

Environment: Windows Server 2008 R2 and 2012 running as VM; SUSE Linux 12 and Red Hat Enterprise Linux for special projects.

Roles and Responsibilities:

•Assisted Director of IT Operations with definition of Hennepin County's IT Service Management (ITSM) practice - principally hardware monitoring, Event Management and disaster recovery (DR) policies.

•Configured logfile and monitor (pulse) heuristics for the County's virtual server assets in Splunk.

•Developed several iterations of Hennepin County's server assets in a custom searchable database to explore possible ways of converting to a standard CMDB.

•Examined previously completed Proof of Concept for Microsoft SCCM as possible centralized tool for Incident, Event, Change and Config Management.

•Updated and partially redesigned existing SharePoint database listing various server and other hardware assets (primarily switches and routers).

•Provided mentoring for interns and more junior team members on subjects such as Event and Incident Management and the various software development disciplines.

TARGET CORPORATION, MINNEAPOLIS, MN

May 2008 - June 2012

Role: Technical Architect

Project: Enterprise IT Service Management implementation in HP Service Desk 4.5 (HPSD), later ServiceNow (Helsinki).

Description: Iterative development of all custom features and enhancements in the Change, Work Order, Incident, Config and Problem modules, with 24 x 7 second-tier support of same.

Environment: Windows Server 2003, Oracle 10g and Citrix for HPSD; Web for ServiceNow.

Roles and Responsibilities:

•Organized and implemented all development activities in Target's IT Service Management system of truth in the form of three major releases per year, with smaller ad-hoc releases as needed.

•Attended Target's Change Advisory Board (CAB) to provide input on all major planned production implementations and their possible impacts to existing infrastructure.

•Performed all tuning and maintenance of HPSD's Oracle 10g backend, including a new (and largely untested) backup feature which populated an entire second DB instance (tested to 30 seconds latency) to allow in-depth data mining without impacting performance in the operational data store.

•Developed an entirely separate database and front-end Web GUI in Struts, from scratch, for the purpose of maintaining an alternate CMDB of 250,000+ devices at Store locations, which were under third-party service contract and therefore not under central Change control.

•Developed and maintained three separate batch jobs for ETL (data import) into HPSD (later ServiceNow): one for new Config items from a custom Excel workbook, one for third-party updates to the Store device CMDB, and one for changes to Workgroup assignments from PeopleSoft.

•Developed and maintained seventeen (17) "live" integrations between HPSD and other systems, principally using iWave Integrator 5.20's Web Services adaptor running on Apache Tomcat: fifteen between the Incident module and various other ticketing systems (four of them at other companies, such as AT&T) to keep Incident data in sync, two between the Change module and the IBM mainframe - one for processing COBOL and JCL implementations in Endevor, the other to implement new Generation Data Groups (GDGs) in the production mainframe filesystem.

•Performed evaluations of eight possible replacements for HPSD in a full-scale Proof of Concept; ServiceNow was eventually chosen due to its ease of use, scalability and exclusive implementation of readily-available, open-source (Java-based) Web components.

•Led the technical effort to port Target's entire ITSM solution from HPSD to ServiceNow in an Agile project from September 2011 - June 2012. No custom functionality, in either the front-end screens or the back-end integrations with other systems, were lost in the process. This implementation went on to win ServiceNow's "Innovative Solution of the Year" Award for 2013.

TARGET CORPORATION, MINNEAPOLIS, MN

August 2003 - May 2008

Role: Sr. Systems Engineer

Project: Info Retriever, the primary merchant reporting/OLAP tool, with 45 different subject areas, arranged across 27 common dimensions.

Description: This tool included Sales, Inventory, Supply Chain, Gross Margin, Gift Registry and forty other subject areas in a single data warehouse. Every new line of business wishing to have their data reported in Info Retriever had to go through a rigorous process of data analysis, which basically amounted to reverse-engineering their whole systems in order to understand exactly what it was they were trying to report.

Environment: Windows VB6 (front end), CA Eureka Strategy (reporting engine), Tandem SQL/MP database (now HP Integrity Server).

Roles and Responsibilities:

•Led development and tuning efforts in the reports interface, based on Axsys (now CA Eureka Strategy) to allow access for 5,000 users (tested to 700 concurrent reports), with the ability to restate historical sales based on various accounting formulas.

•The reporting engine, metadata layers, and database were all administered by custom-developed, mostly command-line tools; this has allowed me to understand how more modern tools like Cognos, MicroStrategy and Microsoft BI work at a much lower level than usual.

•Developed and supported ETL from all stores via MQSeries, COBOL programs which extracted all the useful metrics and attributes from the daily master Sales file, and eighteen JCL jobs with inline SORT routines to summarize the master file into the various levels represented in the data warehouse.

•Supported and tuned TACL scripts, triggered from z/OS to BMC Control-M, to gather the summarized data files over FTP and run another COBOL program on the Tandem Guardian platform (now HP Integrity Server) to cleanse and arrange the data for input into their respective tables.

TARGET CORPORATION, MINNEAPOLIS, MN

March 1999 – August 2003

Role: Programmer

Project: Y2K Compliance and First Call Support

Description: Updated COBOL and JCL to support four-digit years; later took on increasingly complex mainframe coding assignments as needed. Provided 24/7 support of multiple batch jobs on both the mainframe and on the Info Retriever database server. Eventually became responsible for Target’s Weekly Sales & Inventory, Instocks and Top 2500 Items for automatic replenishment every Monday morning.

Environment: IBM z/OS), Tandem SQL/MP database (now HP Integrity Server).

Roles and Responsibilities:

•Took on support of a highly unstable batch process; led efforts in troubleshooting during overnight hours and later tuning analysis.

•Learned TACL and Tandem SQL/MP to support the BI database layer

TARGET CORPORATION, MINNEAPOLIS, MN

January 1999 – March 1999

Role: Programmer Trainee

Project: Y2K Compliance

Description: Trained as an IT Professional by Willard Strindberg of Rensselaer Polytechnic (NY)

Environment: IBM z/OS, MVS, ISPF, JCL, DB2.

Roles and Responsibilities:

•Target’s strategy for Y2K included training from within

•Learned everything necessary to begin updating COBOL programs and JCLs within three months.

TARGET CORPORATION, MINNEAPOLIS, MN

May 1995 – January 1999

Role: Administrative Assistant

Project: Property Development

Description: Store Planning

Environment: DOS 6.22, O/S 2, Windows 3.11

Roles and Responsibilities:

•Performed basic office functions for a team of fixture buyers: typing, filing, and communications with store sites under construction.

•Assisted the Manager of Fixture Purchasing with travel, correspondence and other duties as assigned.

•Later assisted the Director of Store Planning for Mervyn’s California and took on more duties related to the store remodel process.

•Designed and supervised construction of the Mervyn’s Community Closet, a semitrailer converted into a miniature store interior, where underprivileged job seekers could “shop” for interview outfits.

VARIOUS TEMP ASSIGNMENTS, MINNEAPOLIS, MN

June 1994 – May 1995

Role: Administrative Assistant

Project: primarily Dayton’s and UPS

Description: Office management duties as assigned

Environment: DOS 6.2, O/S 2, Windows NT 3.51

Roles and Responsibilities:

•Upgraded all of Dayton’s Store Planning shop with the latest version of Bentley Microstation.

•First line of support for questions on Windows desktop and MS-Office.

•Later assisted in case flow management for UPS Loss Prevention.

APPLETON MEDICAL CENTER, APPLETON, WI

May 1993 – June 1994

Role: Administrative Assistant

Department: Biomedical Tech

Description: Office management duties as assigned

Environment: DOS 6.2, Windows 3.11, HEMS, HECS 1.1, MaintiMizer 1.0

Roles and Responsibilities:

•Performed all office functions for the Biomedical Tech repair team: typing, filing, meeting minutes, purchase orders, etc.

•Managed the hospital’s entire pager account.

•Performed media duties such as videotaping of lectures and surgical procedures.

•Assisted Biomed Technicians in charge of repairing TVs and lesser-rank imaging equipment.

•Converted the shop to a new DOS-based parts inventory and work order system (MaintiMizer 1.0).

COLUMBUS HOSPITAL, CHICAGO, IL

November 1992 – May 1993

Role: Administrative Assistant

Department: Internal Medicine

Roles and Responsibilities:

•Inspected 3,000+ applications for internship program, mainly from overseas.

•Maintained physicians’ schedules.

•Typing, filing and correspondence as assigned.

BEST BUY, APPLETON, WI

April 1992 – November 1992

Role: Sales Assistant

Department: Appliances

Roles and Responsibilities:

•Full-service sales of refrigerators, washers, dryers and garbage disposals.

•Maintenance of customers’ warranty information.

•Regular instruction on construction and mechanical features of various appliances from vendor representatives.

Contact this candidate