Software Engineer Mechanical

John Gerzsenyi

Sugar Land, TX, ***** 281-***-****(Mobil) www.linkedin.com/in/johngerzsenyi ****.*********@*****.***

OBJECTIVE

Senior database consultant bringing 15+ years of experience and skills in data modeling, ORACLE and DB2 applications and system oriented full enterprise life cycle and Agile software development using C/C++ and SQL languages and running on various UNIX operating systems, such as Red Hat, HP-UX, AIX, Solaris.

BUSINESS EXPERIENCE

Senior Consulting Software Engineer – ABB, Sugar Land Jan. 2007-May 2019

Lead team to design database data models, data definitions for Oracle 10g, 11g, 12c DB with SQL Developer and TOAD tools and developed C/C++ application programs for ABB ADMS Energy Distribution System using Agile software development methodology. ABB ADMS system was integrated with SCADA system using ABB developed EMS Transmission System using RabbitMQ messaging.

Following PL/SQL work performed to develop ABB products with Oracle DB objects: created, maintained DB packages, stored procedures, functions, triggers. Provided SQL exception handling code for DB objects. Debugged listed DB objects.

As a developer created, maintained DML code for following Oracle DB objects: schemas, tables, indexes, tablespaces, views, sequences, synonyms, database links.

Worked with Oracle DBA to setup performance measurements like TKPROF and run application program. Captured Oracle tool reports, evaluated it, then modified DB processing code to improve performance. Deployed new code, run it and measured performance again.

Developed Oracle SQL Loader based electrical customer maintenance system using either external comma delimited flat file or Oracle DB table input processing options.

Contributed ABB customer support organization with my deep knowledge of all involved software components to understand and reproduce customer problems in house system to be able provide resolutions.

Solved numerous memory leak as well as performance problems. Recently I made a big Oracle DB bound program 40 times faster having hundreds of program files.

Senior Software Engineer – Tekelec, Morrisville, NC July 2000-Sept. 2006

Developed UML Data Model of all permanently stored MGTS data, including business rules and key assumptions, that clearly showed management what kind of data had been stored and processed and some of data definition had been documented in Erwin diagrams for staff not familiar with UML Data Modeling.

Developed ORACLE Forms and Web Server based prototype to demonstrate feasibility of new MGTS features using ORACLE database system that demonstrated new way to process application data.

Studied closely and made proposal how to employ Web based XML Oracle or alternative MySQL technology for MGTS sold management on clear product development direction using new DB technology.

Senior Software Engineer – IBM, Cary, NC Aug. 1997- July 2000

Developed Rose Data Model of network event surveillance application for both circuit switched and IP based networks that was going to be a base for future event correlation and trouble ticketing system development for Tivoli.

Defined logical data models from physical models and captured and documented business rules into Rose Data Model that documented new DB2 based Tivoli system.

Performed day-to-day DBA functions in development environment for trouble ticket application and used extensive ORACLE 7.3.3 database and Remedy Action Request System 4.0 knowledge that provided direction for system development.

John Gerzsenyi

Sugar Land, TX, 77479 281-***-****(Mobil) www.linkedin.com/in/johngerzsenyi ****.*********@*****.***

TECHNICAL ADDENDUM - COMPUTER SKILLS

Category Experience/Knowledge Level Last Used

Methodology

Agile Expert Current

Database Design Expert Current

Data Modeling Expert 2003

Rational Rose Expert 2000

UML Expert 2000

Software Design Life Cycle Expert 2014

Languages

C Expert Current

C++ Expert Current

Java Intermediate Current

PL/SQL Expert Current

SQL Expert Current

Visual C++ Advanced 2004

Unix scripting Expert Current

Python Intermediate 2013

XML Advanced Current

Operating Systems

Sun Solaris Advanced 2006

Linux Advanced Current

HP-UNIX Advanced 2018

AIX Advanced 2012

Packages

Oracle Forms/Webserver Advanced 2002

DB2 Expert 2000

Remedy Action Request System Advanced 2000

Change Management

ClearCase Intermediate 2004

MS Team Ware Expert Current

EDUCATION

Mechanical Engineer, M.S.E.E., Technical University of Budapest, Hungary

Software Engineer, M.S.E.E., Technical University of Budapest, Hungary

LANGUAGE English, Hungarian

ACTIVITIES Cooking YMCA Gym Do-it-yourself projects around the house

Contact this candidate