John Hacker Email & Phone Number

Pontiac, Mi

Sterling Heights, Mi

The sole provider of support for maintenance and enhancement of existing VB.NET website for the generation of insurance quotation packets. Created a new website for the generation of insurance quotes in C#, SQL, and Microsoft MVC. Created contact list management software for a retiree organization. Designed and implemented several C# based Windows Forms applications to perform specific data transport and translation of data for various trading partners.

Redford, Mi

Converted existing website from .NET to a multilingual client side AngularJS and Bootstrap based site using C# web services for data interactions.

Dearborn, Mi

Developed user interface in ASP.NET with AngularJS for a complex web based user management system for an existing product.Designed web based service backend to perform data update operations for user management system.Performed bug fixes and improvements to existing legacy code in C#.

Ann Arbor, Mi

Sole provider of support and development for multiple, undocumented custom production systems utilizing over 50 databases and almost 2000 tables.Administered multiple SQL servers including maintenance, upgrades and optimizations.Designed and developed various production tracking programs in C#, allowing real time monitoring of production floor activity.Provided 24/7 support for production systems.Completed a long term initiative to reduce the data footprint across the databases from 1.6 TB to 600 GB.Improved system stability across multiple processes and implemented real time monitoring of mission critical production systems implemented as a C# Windows service.

Dexter, Mi

Designed, maintained and supported a server application for handling requests from an Android application to facilitate phone sales for recycling. Reverse engineered cell phone ROMs to remove branded components for resale to third party carriers and created various applications to facilitate debranding and reprogramming of cell phones.Created a client server application in C# that retrieved and tracked cell phone states to insure all phones were no longer associated with the original purchaser.

Toledo, Ohio Area

Maintained and supported a SQL Server 2008 based system for evaluating the retention metrics of automotive dealerships in a database involving hundreds of millions of rows Improved the evaluation process to reduce the monthly processing time from 30 hours to under 6 hoursPerformed custom data imports using SSIS and custom queries to handle a large number of customer data formatsPerformed data analysis and created custom reports using SQL Server 2008

Ann Arbor, Mi

Acquired skills in ASP, SQL, JavaScript, VBScript, XML, and XSL.Developed an ASP and SQL web based application for platform independent code library management. XML and XSL were also used to store and display data to the user. The system encompassed the storage, retrieval, maintenance, and user reviewing of various in-house developed code modules for ease of re-use throughout the company.Provided EDI data requirements consulting services in bringing a large scale EDI implementation project on-line.

Plymouth, Mi

Designed, maintained and supported an application for the evaluation of insurance claims to determining their eligibility for reimbursement under Medicare part D using C#, WPF MVVM, fluentNhibernate and LINQ to SQL Designed and maintained a number of tools for the purpose of reporting and support of the evaluation processPerformed custom data imports using SSIS and custom queries to handle a large number of custom data formats

Design, implementation, maintenance and support of back end web systems related to mortgage origination as well as web based UI applications for supporting them. The position required close work with internal business clients to gather requirements leading to the design and implementation of solutions in a fast paced environment. Responsibilities included unit testing, support of live systems and ongoing maintenance of several projects at the same time.

Design and implementation of developer tools for creating fully fully featured Windows Installer based Software installers. Design and implementation of software for modelling software based on it's installation footprint. The position required requirements gathering and close work the QA staff to insure a high quality product for end users. Additionally, close coordination with the documentation staff was required to provide clear documentaton for the end users and to make the product as easy to use as possible.

Design and implementation of a rules based engine to manage the rendering of mortgage closing documents. The position required close work with internal clients to determine requirements as well as extensive unit testing and support of live business systems.

Ann Arbor, Mi

Coordinated design and implementation effort for updating and enhancing a C/C++/Star view Windows based EDI translator to 32-bit Windows. This included updating the StarView base libraries to take advantage of 32-bit windows, as well as updating the interprocess communication to use TCP/IP Sockets instead of DDE, and the storage management to use ADO. Responsibilities included design, implementation, and project management of development, build, testing, and deployment issues.Participated in effort to design a fully configurable COM/DCOM based EDI translator. Effort included extensive research and design work into a plug and play software architecture using TCP/IP connections, with fully integrated configuration, error reporting and error handling.Completed numerous debugging and integration related projects across a large variety of packages and platforms. Maintained EDI software on IBM mainframes in C. Maintained and enhanced C++/Starview based EDI translator under 16 bit Windows. Maintained and enhanced C++/MFC based barcode printing and scanning software for automotive label printing.Led DOS EDI translator team, as well the team responsible for working with customers to develop specifications and implementation for custom reporting solutions related to EDI integration.Worked on a DOS based EDI translator written in COBOL to design and implement a completely user configurable multilingual user interface and reporting system. Enhanced product to allow easy integration of new interface features into existing custom designs. Senior Technical Support RepresentativeResponsible for the resolution of customer issues, questions, and concerns. Extensive software and hardware troubleshooting required. Developed numerous utilities in C, C++, and VB to help resolve customer issues more quickly. Also created extensive documentation and reference materials to train new technicians and enhance productivity.