Michael Lorz Home 209-***-****

P.O. Box ****

Sutter Creek, CA 95685 http://mlorz.com/Resume ac0g0d@r.postjobfree.com

Professional Profile

Graduated from Chico State University, Chico, California with BS in Computer Science, and strong studies in math. During the course of professional career, I have work experience within R&D environment, with strong links to hardware, software, to accounting, and payroll office and procedures. Then to a casino environment supporting various departments with my programming skills, and customized applications used in the day-to-day operation Then to a DOD manufacturing environment, support as an IT professional, supporting hardware, servers, IP phones, and using my DB/software skills in generating reports, and applications as needed, along with DRP support.

Goals

I would like to support an IT infrastructure within the Sacramento, Stockton, Elk Grove, and Placerville area within California. Using my talents and experiences in an organizational and operations support. Maintaining servers, databases, and supporting new, and existing application development from client, web based, to smart phone technologies.

Skills

Microsoft Visual Studio 6, .Net 2002/03/05/08/10/12/13 Developer Package, along with SourceSafe.

Microsoft Office, Word, Excel, Access, Publisher, Composer, Visio. Version 2000/03/07/10, MS Network Monitor.

Macromedia Flash, Dreamweaver, Fireworks Version 8.

C, C++, C#, VB, VBScript, JQuery, JavaScript, HTML, HTML 5, ASP, ASPX, AJAX, Entity Framework, LINQ, Web Services, Perl, and Assembly.

Use of DLL, COM, OCX, and services.

SQL 2005/2008/10/12, MS Access 2000/02/03/07/10, Stored Procedures, triggers, tables, views, security, DTS, SSIS, and profiler. Familiar with MySQL, Oracle

Windows Server 2000/2003/2008/2010, IIS, Linux, 811.2B wireless, Report Server, Crystal 6, 8.5, 9, Oracle Virtual Box, and VMware.

Iron Speed 6.2, 7.1.

Fiddler, Chrome Developer.

Windows 2000, XP, Vista, Win 7, Win 8, Win 10 within a client environment.

Accounting A/P, A/R, G/L, J/V, Billing, Banking data exchange such as 401K, PosPay.

Excellent knowledge of hardware and utilization of associated test equipment.

Very good understanding of networks, switches, routers, DNS, DHCP, Routers, gateways, and AD.

Understanding of MAS500 DB, UltiPro, Aristocrat, and Oasis DB.

Strong believer in agile development.

Administrator of Team Foundation Server 2010.

Familiar with Eclipse, Android Studio within the Android platform, using Java.

Familiar with SharePoint 2003, and SSRS.

Professional Experience

Consultant via Agreeya to

Delta Dental, Contact Center Technology

July 2015 thru Feb 2017

Consultant

Primary Job Functions:

Create/Maintain applications that support reports to supervisors, managers to VP for the call center operations.

Responsible to ensure applications could process data from HRMS, EIVR, Aspect, eWFM, and MS Access databases.

Responsible to supply reports on departmental performance, in relation to other departments.

Reviewed aspects from manual process, to an automated process.

Notified users when servers were having issues, power outage, network bottle-necks, service level performance issues, etc…

Consulted operations on how to increase efficiency.

Reason for leaving, contract expires in December 2016.

Administrated development SQL Server, assisted testing migration of production servers to newer levels.

Performed ad-hoc queries to research data.

Goldenbear Ins. as a Senior Program Developer.

Nov 2012 thru Nov 2014

Developer/DBA Administrator.

Primary Job Functions:

Administrator for IIS, and Server 2008. Managed user access via Active Directory.

SQL Administrator for SQL Server 2008R2.

Administrator for Microsoft Team Foundation Server 2010.

Mentor to others on administration, and programming within C#, JQuery, JavaScript, Web services, and usage of SQL, Stored Procedures, Tables, Triggers, and proper DB design.

Programmed the web applications using AJAX, JQuery, Google's tools such as Google maps, LINQ within applications tables, plus much more. Integrated MS Entity Framework with web forms, and used LINQ to access data.

Created a JQuery library for all the web applications. Controlling data inputs, page element properties, security features, field formatting.

Created a Drag and Drop feature, dropping into folders.

Creating a web portal to allow agents obtaining quotes.

Creating an ESP (Enterprise Software Package) to interface all aspects of a policy lifecycle, from submitting quotes, binding, renewal, and endorsements.

Project was canceled.

Forte Holdings, El Dorado Hills, Ca

Feb 2012 thru Sept 2012

Senior Developer

Primary Job Functions:

Using VS2005, .NET VB Debug tools to determine application issues with the within Chiro 8000 application, and resolve them.

Migrate current Chiro 8000 to its next level of VS2010 .Net VB adding new features.

Investigate operational functionality reported problems, and report them to management using VS2005 VB.

Modified SQL database to support the Chiro 8000 application.

Be a mentor to staff on SQL server 2005, 2008, and VS 2005, and VS 2010.

Create various application reports using VS2005 Active X reporting tools.

Used MS SourceSafe to control source code.

Collected requirements for the migration for the Chiro 8000 from version 13 to 14.

Followed agile development methodology.

Edex Systems, Jackson, Ca

Dec 2010 to Feb 2012

Programmer

Primary Job Functions:

Created web based GUI forms, to be used interacting with the State of California Works Compensation department, replacing paper forms.

Created web controls onto various web pages using VS2010, using JavaScript, and JQuery for functionality.

Utilized Css styles to give user controls glamour, and interface feedback.

Created a WSDL service to process XML data to generate a PDF file using VS2010 C#.

ArmorStruxx, Lodi, Ca

Nov 2008 to Dec 2010

Independent Analyst/Programmer

Achievements:

Created web based online pricing catalog.

Created MS Access/SQL based shipping serialization/barcode application to serialize products in association with pallets, and reports, and shipping reports.

Created web portal to track contract, sales order, shipping, costs and more, tracking data from the initial sales order to shipping of the products.

Created Labor Tracking Web Portal to track manufacturing labor costs for product assembly with Crystal reports as a reporting tool.

Responsibilities:

Evaluated new PC systems, security issues, repairing PC/workstations for virus, and hardware issues.

Trained employees on MS Office.

Created applications as required.

DBA, monitoring servers for performance, and any issues that may arise.

Checked server event logs, security, service releases.

Jackson Casino, Jackson, Ca

February 2001 to May 2008

Software Analyst/Programmer II

Achievements:

Created custom Crystal, .net reports for slot, and video managers.

Resolved system crashes of slot machines which generating excessive signal.

Created a web interface application to read meter reading of leased slot machine, and generated supporting reports.

Replacing paper forms to an online web interface increasing productivity and accuracy, this in-turn created audit trails as to who did what and when.

Wrote Zebra card printer drivers to print players/employee cards.

Wrote a web interface application to monitor the gaming floor and associated servers.

Resolved system slowdown during peak hours of operation due to SQL users performing ad-hoc, and poorly designed stored procedures.

Wrote a barcode uniforms management application supporting our wardrobe department, along with supporting Crystal reports. Utilized SQL as a backend, 10 client interface on 5 computers using touch screen/speech/scanner technologies.

Wrote a web document control management program for HR, utilized by all managers. Document control contained an admin control for document control, with SQL backend.

Perform various stored procedures interacting with customized reports using Crystal 6/8.5/9, or MS SQL Reporting.

Wrote custom payroll/accounting application for transmittal of data to financial institutions, using SQL backend with temp tables, and SP.

Wrote interface for USB card swipes for employee ID cards, and credit card interface for processing for our hotel. Generated pre-fill data entry for 3rd party hotel reservation application.

Project leader in providing a barcode coupon promotional redemption application, designing web/application SQL interface used in marketing to production redemption, with security reports.

Investigated questionable gaming transaction within SQL using ad-hoc scripts.

Assisted in Accounting/Payroll backend SQL support, running transactions, designing ad-hoc/SP for custom reports/issues.

Introduced SharePoint 2003 to the casino mangers, then canceled it after 3 months because it was too complex for non-technical end users.

Wrote custom reports using SSRS, but later changed them to Crystal 8 because of speed complaints.

Responsibilities:

Provide SQL design and implementation for all my application. Requirements extended from creating application to project assessment, SQL DB creation, SQL SP debugging, securities, documentation for support, and production server setup.

Internal Webmaster for internal Website, which included company forms, office tools, knowledgebase, phone directory, and events.

Supported 3rd client applications with my programming skills.

Backup for SQL Server support.

Backup for workstation upgrade/resolution support.

New product review.

Supported Crystal, MS Access, .Net and created applications to support various departmental needs.

Department mentor for procedures, departmental direction.

Maintained and designed internal intranet web site as required.

.

Consultant to Micrologica: Mexico

1984-1986

Consultant

Achievements:

Supported UNIX platform, upgrading BIOS, hardware, software, included tape streamer, diagnostic support, and R&D new product development.

Responsibilities:

Evaluated new PC systems, different chip sets, PCBs, products, and different levels of programming, which included device drivers.

Supported BIOS within the motherboard, disk power up diagnostics, boot up, written in M68K assembly.

Support the repair, field service with a stand-alone diagnostics.

Developed trouble shooting tools, written in assembly, C, and shell script.

Other Employment

Test Engineer manager with National Semiconductor Datachecker Division in Santa Clara. Supported manufacturing and Field Service with software programs, tools, and system evaluation.

Precision Instruments, R&D and software department for a mass laser storage unit.

Applied Materials R&D for computer controlled wafer fab line.

Tab Products, R&D for the electronic data entry processing station.

Finnigan Corporation, R&D and manufacturing in diagnostics, testing of Spectrum Analyzers and Mass Spectrometers.

Education

BS Computer Science CSU Chico, Ca.

BS Studies in Math CSU Chico Ca, and CSU Turlock Ca.

Graduate Studies in Computer Science CSU Chico, Ca

AA Computer Science at SJDC, Stockton, Ca.

Various MS classroom certifications toward achieving my MS certification.

References

References are available upon request.

Contact this candidate