Leonard Kats

Leonard Kats
763-447-1326 • lkatsmeow@gmail.com
Qualifications Summary:
• Full cycle of software systems development, implementation, and maintenance
• Versed in project delivery methodology: discovery, scoping, execution, project management
• Delivered multiple database designs, implementations, reporting systems
• Strong business process analysis, data modeling, extraction, transformation skills

Technologies and Environments:
Oracle, SQL Server, .NET, Visual Studio, Borland C++ Builder and JBuilder, MS Access, MS Office
Protocols and Platforms:
RS-232/485, OPC, Modbus, CAN OPEN, TCP/IP, COM, Industrial SQL, Wago, Siemens, GE FANUC
Languages:
C#, VB.Net, PL/SQL, VB/VBScript/VBA, Transact SQL, Visual FoxPro, SAS JMP, C/C++, Java, COBOL, Structured Text, InTouch Scripting

PROFESSIONAL SUMMARY

Senior Staff Program/Project Manager, Seagate Technology, Bloomington MN 2013-2015
Program/Project Manager, EDW reporting system with 1,200+ internal customers
• Conducted Voice of the Customer meetings to gather requirements
• Prioritized requirements (musts vs. wants) for customers and developers
• Created design and functional specifications for system components
• Led customer training sessions in system design, capability
• Assigned work to developers
• Used C#, VB.Net, PL/SQL, Web Services in a 3-tier application to mine an Oracle Enterprise Data Warehouse

Staff Software Engineer, Seagate Technology, Bloomington MN 2009-2013
Lead Developer, EDW reporting system with 1,200+ internal customers
• Used C#, VB.Net, PL/SQL, Web Services to refactor the management tier of an Oracle based system for simplicity, scalability, extensibility
• Expanded application feature set, reporting capability, chart types
• Mentored and directed junior engineers in coding, system design, architecture
• Trained extended team members in .Net and application architecture
• Conducted C# classes for extended team members
• Led team scrum meetings, user support and training sessions

Staff Equipment Engineer, Seagate Technology, Bloomington MN 2003-2009
Lead Developer for Wafer Manufacturing Equipment Characterization, Fault Detection, Cost Savings, and Run to Run Control
• Used C#, RS-232, TCP/IP to monitor 21 Cryogenic pump parameters in real time. Worked with DBA to design long and short term storage tables and data definition tables to automatically notify equipment engineers via email and pager when warning levels reached or exceeded. Wrote specs for development of browser based (IE 7) interface which allowed engineers to view collected data, adjust limits, export data to Excel for analysis, and print reports. System saved $13K per month vs. existing outside vendor contract
• Used C#, TIBCO message bus, XML to create a real time dashboard display for operators in clean room. System eliminated equipment and WIP idle time by enabling operators to distribute equipment load more efficiently, track process time, pre-stage WIP, and locate lots at locations throughout the factory floor. System reduced WIP rack time by 81%
• Achieved annual savings of $187K by working with team to design and implement software / hardware system that allows interruption of metal deposition process to permit rework and minimize scrap. System used VB 6, Structured Text, Wago I/O modules and PLC.
• Used VB 6, Wonderware InTouch 7.11 and 8, and XML to save $84K per year by creating solution that eliminated operator error by delivering process recipes directly to equipment on factory floor. Solution also sped up production by reducing operator steps to launch process.
• Eliminated 2 days of testing from production time by modifying vendor software to run high vacuum chamber leak test before metal deposition process start. Project used Wonderware InTouch 7.11 script
• Led implementation effort for numerous in-house hardware & software Six Sigma projects to attain significant cost savings, reduce scrap, increase equipment utilization
• Used XML, SQL, VB 6, SECS/GEM, DDE, COM to deliver enterprise compliant systems for APC, R2R control, FD, and recipe delivery
• Taught SQL DML class to fellow Equipment Engineers to improve their data analysis skills. Used Excel and VBA to write example queries against SQL Server 2000 for class material
• Tools Utilized: C#, VB 6, Wonderware InTouch 7.11/8 and Industrial SQL, SQL Server 2000/2005, Oracle, SECS/GEM, RS-232, COM, DDE, Wago I/O, Moeller I/O, CAN Open, CodeSys, Structured Text, Function Blocks, MS Excel

Software Application Developer, Crossworks, Inc., Hopkins MN 2002-2003
• Tools Utilized: Java (Borland JBuilder 8), SQL Server 2000, Oracle 8i

Lead Software Engineer, Eltec Inc., Minneapolis MN 1994-2002
Managed software development lifecycle of major projects for key clients, from discovery to installation and support. Clients included the U.S. Postal Service, U.S. Army, Northwest Airlines, 3M, West Publishing, Morton Salt Automotive Division, Ford Motor Company, NSI, G. Heileman Brewing Company, and West Publishing
Tools Utilized: C, C++, PL/SQL, Transact SQL, VB, Visual FoxPro, Oracle, SQL Server, Access, ODBC, Visual SourceSafe, Wonderware InTouch and InTrack, SBT, Paradox

Programmer/Analyst, Federated Insurance, Owatonna MN 1990-1994
Lead Developer for Commercial Accounts Processing System (CAPS+) front end
• Tools Utilized: COBOL, Metaview, Supra, dBase, MVS, CICS, JCL, VSAM, XPEDITOR

EDUCATION

B.S. in Computer Science ? University of Wisconsin
Cloudera Certified Developer for Apache Hadoop ? August 2013
Six Sigma Green Belt ? Seagate Technology
Six Sigma DFSS DMAIC methodology ? Seagate Technology
Six Sigma DWSS IDOV methodology ? Seagate Technology
LEAN Manufacturing ? Seagate Technology
Page 1 of 3

Additional Info BACK TO TOP

Current Career Level: Experienced (Non-Manager)

Years of relevant work experience: More than 15 Years

Date of Availability: Immediately

Work Status: US – I am authorized to work in this country for any employer.

Active Security Clearance: None

US Military Service:

Citizenship: US citizen

Target Company: Company Size:

Target Locations: Selected Locations: US-MN-Minneapolis

Relocate: No

Willingness to travel: Up to 25% travel

Languages: Languages Proficiency Level
English Fluent
Russian Fluent