CONSTANTIN FLESSAS

e-mail ac6vk1@r.postjobfree.com

Phone 850-***-****

TECHNICAL EXPERIENCE

Software

• Languages( C/C++, C#, Java, Junit, javascript, Assembly{Power/2/PC, 80x86, mips}, Fortran, HTML, VB, vbscript )

• Scripting( ksh/csh/bash/perl/wscript, filemaker)

• IDE( Visual Studio, Dreamweaver, Eclipse, cset++, Visual Age, Borland c++, Turbo Pascal, XL Fortran, sccs, rcs, perforce, make, ant )

• WEB( Jquery, AJAX, JSON, XML, .NET, JSP, ASP, vbscript )

• Encoding( endianess, Unicode, utf, rfc1345, NLS )

• OS( Aix, Irix, Linux, SunOS, DigitalUnix, Windows, cygwin, MCP )

• Networking( TCP/IP, Ethernet, firewalls, inet, sniffers, winpcap, sockets )

• Databases( SQL Server, DB2, Oracle, mysql, pl/sql )

• Appservers( WAS, Weblogic, tomcat, IIS)

• Buisness( Websphere Product Center, Trigo, Webservices, GDS, 1Sync, Workflow )

• Bugs( dbx, gdb, javacore, httptrace/unit, bugtrack, ClearQuest, RightNow, Retain )

• 3D( WebGL, three.js, OpenGL, DirectX, maya )

Hardware

• Platforms( IBM RS6000, SGI, DEC Alpha, PC, UltraSPARC T2, LPAR )

• Networks( FDDI, 10-base2/T/FX )

EMPLOYMENT

Mar 2012 – Feb 2018 Pensacola State College Pensacola, FL, USA

Computer Systems Analyst

Web Application Development:

Duties: Create a new custom web application to track information for the HPOG grant program. Create rich HTML forms for data entry using JQuery, with asynchronous backend communication using AJAX and JSON. Provide backend services with ASP Vbscript. Interface with the MS SQL Server with the ADODB Api. Implement custom validations with notifications, data input filtering, full error handling and XML mapping.

Accomplishments:

• Code and support HPOG 2.0 grant management app from beginning to grant close. One month for initial release on time. Full functionality was provided for participant records Add/Edit/View, Case Notes, Budget and service tracking, statistics and projection reports.

SQL Server Developer/DBA

Duties: Document and implement schema design changes for new modules and enhancements to existing design. Trace and fix issues in existing T-SQL procedures and triggers. Code and test new T-SQL procedures, tables, indexes and constraints. Create SQL to periodically check for data consistency issues and missing records in related tables. Run deadlock detection, trace root cause and code fix using transactions and rollback and try catch. Improve performance by implementing table variables to replace temp tables where appropriate. Trace long running SQL using explain plans and DMS views. Create indexes and periodically update statistics. Setup email and text alerts for all significant error types. Monitor error logs, and dynamic management views sys.dm_. Delete and create replication snapshot distributions. Monitor and trace replication progress, pausing and rebuilding when schema changes occur. Recover from runaway log space growth by clearing table replication locks. Monitor and trace job performance, implement design changes to reduce execution time. Trace execution errors in complex interdependent multi procedure jobs by setting step output to db and file. Import external data using BULK INSERT from various sources, update format file when necessary.

Accomplishments:

• Created realtime DB HTML5 monitor based on WebGL. Text to speech for error messages and DM_ graphs correlated to users SQL currently running.

• Support Student Management system, several procedure issues causing data corruption affecting student intake.

Apr 2010 – Apr 2011 RCC Santa Clara, CA, USA

Software Engineer

FileMaker Development:

Duties: Create Filemaker and Java modules, processes, forms and reports. Trace and fix problems with existing filemaker databases. Import and migrate data into filemaker resolving data cleansing, character encoding and performance issues.

Accomplishments:

• Develop system to automatically process PayPal purchase transactions, create and send HTML emails for Invoices and software keys.

Apr 2004 – Apr 2010 IBM Foster City, CA, USA

Software Engineer

Performance Engineering:

Duties: Perform code and implementation performance analysis and review. Benchmark and analyze use cases, identify low hanging fruit through monitoring and tunning the HW, O/S and DB. Generate quick prototypes to explore creative low impact solutions to bottlenecks. Recommend specific Code and script changes with accurate predicted performance improvement. Diffuse critical customer situations

Accomplishments:

• Improved single and multi edit page response time by a factor of 10x (below 2s) by implementing floating inputs and send on change.

Development:

Duties: Handle line items for releases and create required design documentation. Divide items into smaller sub tasks and provide detailed estimates. Follow Agile development principals, SCrum, streamlining scope and small iterations. Checkin using perforce, pair program and peer reviews. Perform code level impact analysis and create new Junits. Code using eclipse and hotswap feature. Perform significant unit testing, provide documentation and release note updates. Fix bugs, handle CQ cases, negotiate with QA for closure, provide testing recommendations.

Accomplishments:

• With minimal bugs, I completed a major release delivery line item to improve UI performance.

DB2/Oracle Development/DBA:

Duties: Generate and analyze lock reports for blockers, deadlocks and lock escalation. Write shell scripts, sql and pl/sql to identify and cleanup database corruption and help with problem determination. Identify perf issues with iostat, vmstat, nmon, traces, snapshots and explain plans. Optimize sql using hints, changing indexes, stats gathering, partitioning, multi dimensional clustering, etc.

Accomplishments:

• Solved several complex Oracle and DB2 corruption issues. Provide process and fixes for Oracle index flipping issues causing severe performance degradation.

Technical Support:

Duties: Analyze java source code to identify and fix bugs. Deal with bad checkins and multiple code branches using p4. Trace thread deadlock and memory leaks using javacore and heapdump. Debug custom widgets, interpret and modify application code. Debug and analyze problems and generate steps to reproduce related to WPC, its scripts, WAS, GDS, 1Sync, Webservices and Portal.

Accomplishments:

• “The Best of IBM Award" for Outstanding technical support on critical issues

• "MEANS Service Award" For Outstanding Accomplishments In Service

Customer Service

Duties: Represent the department on customer calls, manage escalations and provide timely status updates. Follow-up with relevant people to solve cases. Debate with engineering/PM to provide customer with a timely fix. Formulate a close relationship with customer and travel onsite. Clearly document problems, actions taken and next steps. Make sure all cases follow strict ISO process and track case statistics.

Accomplishments:

• Managed several customers who experienced severe go-live delaying problems without having them escalate. I showed empathy and hard work in resolving their issues, with regular status reports and detailed action plans.

• had to push back several ERs by exposing underlying flaws in the logic of the request and discovering technical limitations.

Apr 2003 – Apr 2004 Trigo Brisbane, CA, USA

Software Engineer (purchased by IBM)

Technical Support

Duties: Analyze java source code to identify and fix bugs. Deal with bad checkins and multiple code branches using p4. Trace thread deadlock and memory leaks using javacore and heapdump. Debug custom widgets, interpret and modify application jsp’s. Debug and analyze problems and generate steps to reproduce related to WPC, its scripts, WAS, GDS, 1Sync, Webservices and Portal.

Accomplishments:

• Identified root cause of duplicate spec occurrence cause by custom inheritance, formulated fix, presented and debated fix with customer to bring their issue to resolution.

Customer Service

Duties: Represent the department on customer calls, manage escalations and provide timely status updates. Follow-up with relevant people to solve cases. Debate with engineering/PM to provide customer with a timely fix. Formulate a close relationship with customer and travel onsite. Clearly document problems, actions taken and next steps. Make sure all cases follow strict ISO process and track case statistics.

Accomplishments:

• Successfully handled largest most demanding customer for one year through several high impact, long running issues.

Sep 2002 – Sep 2003 SSS Montreal, Quebec, Canada

Computer Systems Analyst

Development:

Duties: Write a real-time interface program to allow an ENS Image Generator to be incorporated into Thompson and CAE simulators. Provide detailed design and time estimates for tasks.

Accomplishments:

• Created a PC program using VisualC++, MFC and Winpcap, packet formatting and data conversions coded as indicated by the ICD, milestone dates were reached on time.

Sep 1994 - Sep 2001 CAE Montreal, Quebec, Canada

Computer Systems Analyst

Development

Duties: Port product to new platforms and OS's. Develop enhancements, fix bugs and create programs to help support and satisfy project requirements. Optimize the product code using performance tools, compiler options, and code changes. I used sccs and rcs to checkin code changes and fix problems with custom branches. Provide guidance, technical assistance, and system design details, for the OS, internal APIs, and applications.

Accomplishments:

• Created a device driver for a PCI IRIG card on AIX 4.3

• Wrote a bug tracking app with front end cgi scripts and a mysql database.

• Wrote a visualization program for AIX timing and trace viewing.

• Wrote RS232 interfaces for (micro/elotouch, ups, scsi switch, and GPSIC panel).

• Wrote socket modules using (DLPI, udp, kinet and custom drivers).

• Traced perf bottleneck due to new Matrix X modules and successfully reduced execution time to previous levels.

• Design to improve network transfer protocol speed by a factor of 10x.

• Traced cause of motion system crash to the AIX syncd causing 10ms jitter, provided design and helped code move from JFS to direct LVM io.

• Provided design and helped code AIX disk imaging program using ioctls.

Support

Duties: Provide telephone, on site, and in field product and OS support on multiple unix platforms and debug any hardware or software problem. Quickly learn new systems and technologies newly added to the vast area of technical knowledge covered by the product. Resolve difficult intermittent problems in a limited time frame, analyze and fix system crashes, and real-time jitter.

Accomplishments:

• Field trips to Japan, Korea, China, Germany, and the US to fix intermittent problems, clear snags, and perform upgrades. Customers were always very happy with the work.

• When engineers were stuck with unsolvable problems I was often the one called in to fix them. I was known for sticking on a problem until it was solved, and for solving problems quickly.

System Administration

Duties: Benchmark systems and peripherals to predict product runtime and spare time. Support all aspects of and resolve all problems with the server, peripherals, and the OS. Define procedures and write scripts to install the OS, its components, and system peripherals. Implement security standards, ISO9001 procedures and prepare servers for Y2K.

Accomplishments:

• Implemented DOD C2, and SECMAN1 security standards

• Gathered Boeing 737 simulator realtime perf data and accurately predicted sufficiency of IBM F50 to replace 595 by comparing perf data and machine specs.

• Evaluated, installed, and supported Xstations (IBM x130- NS2800e, NCD hmxpro-nc900, JCC XfaceC)

• Fixed NFS problems (auth, DNS, real-time lag and locking).

• Examine AIX dumps and traces to find root cause of system crashes, freezing, and real-time jitter.

• Created C shell scripts to backup, install and configure AIX, its components, peripherals, and custom applications.

EDUCATION

Aug 1991 – Dec 1995 Vanier College Montreal, Quebec, Canada

• DEC Computer Systems Technology

PERSONAL

• Fluent in English and French.

• I am a United States born citizen

• Hobbies: 3D graphics, computer games, kung-fu

E-MAIL ac6vk1@r.postjobfree.com

PHONE 850-***-****

Contact this candidate