Technical Support Software Engineer

Frank Rustyak

Principal Software Engineer - Actian Corporation

Farmingdale, NY

********@*****.*** - 631-***-****

Seeking hands-on position to suit my skills. Pursuing neAw challenges in a real-world production environment. Seeking open, friendly atmosphere where ideas can be exchanged and hard work shows in tangible results. I offer management experience and technical experience in SQL/Relational Databases and Database Administration, T-SQL, Query Optimization, Triggers, Stored Procedures, Query Tracing, Database Backup and Restore, C#/.Net/ASP.Net programming, C/C++ programming, and technical support. I have Systems Administration experience, having worked with Active Directory, Sonicwall Network Administration, and Avaya IP Office telephony. Team player with excellent communication skills. In addition, I have working experience in multiple Operating Systems, including Unix and Windows NT/2000/XP environments. Seeking full-time employment with a group of people who are professional and dedicated to what they do, in a fun and fulfilling atmosphere. Need a sense that my work is valuable to the company. Ideal company is one that fosters an open environment among its employees. It encourages excellence without stifling the spirit, camaraderie, and creativity that makes the company successful. Authorized to work in the US for any employer

WORK EXPERIENCE

Principal Software Engineer

Actian Corporation - November 2013 to Present

Provide telephone and email technical support for Ingres, Actian's relational database product, including development tools. This encompasses severe cases where systems are down, to advice and troubleshooting on database design, backup and recovery, application development, and query optimization. Duties:

Reproduce and solve problems encountered by the customer. Skills required to perform this function:

- Build and populate databases with pertinent data

- Write SQL to create tables, alter tables, retrieve and modify data according to the customer's needs. SQL was in ad-hoc queries and also in stored procedures

- Write Embedded SQL within C and C++ programs

- Performance optimization through properly constructed queries, database design, table design, and setting of database tuning parameters (memory, cache, etc).

- Connect to databases, retrieve and update data via ODBC using third-party applications, such as MS-Access, MS-Excel, and Active Server Pages created with MS-Visual Interdev.

- General knowledge of Windows NT/2000/XP and Unix (Linux, HP, Solaris, AIX)-Create and troubleshoot applications developed in OpenRoad, a GUI application development program. Director of Information Technology

Federated Payment Systems - Melville, NY - March 2006 to November 2013 At Federated Payments we specialize in serving the payment processing and merchant account needs of small to medium size businesses. Our mission is to offer our clients an expansive and diverse suite of processing solutions that will fuel the success of their business while developing a long-standing relationship through outstanding service and support.

IT department includes Application Development, Helpdesk, and Server and Network Administration. As the Director, duties included supervising the employees and assigning and overseeing tasks within the department, as well as getting involved directly, hands-on, with the various hardware and software applications as outlined below. Currentlty also the SQL Server DBA for the Company. APPLICATION DEVELOPMENT:

Sql Server 2000/2005/2008

TSQL

Query Optimization

Management Studio and Enterprise Manager

Stored Procedures

Triggers

Database Design

Query Traces and Performance Optimization

Database Backup and Restore

Design and implementation of Maintenance Plans

SSIS/DTS packages used to run a number of daily data processing jobs Visual Studio .Net 2005/2010, ASP.Net, C#, .Net 2.0/3.5/4.0 Oversaw team of developers that designed, built, and maintained Web-based and winforms applications:

-Telemarketing application used for cold-calling potential customers.

-Boarding application to manage primary database of new and existing customers

-Helpdesk ticketing system for our Support department

-Report mailer used to email monthly residual reports to dozens of sales reps. Originally build using Visual Basic 6 and MS-Access, application was rewritten in C# and SQL Server. MS-Access 2000, 2003

Created Data Access Pages to manage Independent Sales Office (ISO) Sales Rep information Crystal Reports

-Various reports used by accounting to pay commissions and residuals to sales reps. Installed and maintained Buzilla to track bug fixes and Subversion for Source Code Control. HELPDESK, SERVER AND NETWORK ADMINISTRATION:

Installed and maintained company's IT assets, including approximately 20 servers running Windows Server 2003 (32 and 64 bit), SQL Server 2000 and 2005, Active Directory, SonicWall Network Appliance for Network Administration and Configuration, Ipswitch Imail server, Avaya IP Office phone system, approximately 100 desktop computers running Windows XP Pro and the software required for Federated employees to accomplish their daily tasks.

Application Developer

Robocom Systems International - Massapequa, NY - March 2005 to October 2005 Began conversion of RIMS warehousing software from legacy database system to .Net. Wrote windows application in C# to display continuously updated warehousing information on Adaptive Display's 4-line LED Marquee Displays.

Software Engineer

Computer Associates International - 2002 to October 2004 Provide enhanced technical support for Computer Associates' eTrust Policy Compliance security products. eTrust Policy Compliance performs scans on target computers for security vulnerabilities. GUI front-end communicated with agent systems using sockets over TCP/IP. Some scans were hard-coded into the product using Unix and Windows API calls (for example, to gather user and group information). Other checks were done using Visual Basic scripts (Windows environments) and Unix Shell scripts for Unix targets. Still more vulnerabilities were detected using an in-house utility called 'fixcheck', written in C++ which has a similar functionality to the Microsoft Baseline Security Analyzer. The fixcheck utility uses the same msssecure.xml file, which is downloaded automatically by the eTrust Policy Compliance from Microsoft. eTrust Policy Compliance is written in C++ and C, with components written with Perl, Unix shell scripts, XML, and VB scripts.

Duties:

- Product enhancements and Bug fixes - Diagnose and fix problems within the product. Methods of diagnosis included:

- Adding my own code to trace program execution

- Analyzing stack dumps and core dumps.

- Compiling and building the product from the source code using C++, XML, Perl, Rogue Wave Studio and Toolkit, and InstallShield Developer. Some source code was ANSI C while other code was object-oriented design in C++ with inheritance.

- Assist lower-level support with highly technical questions about the product. This often involved analyzing the source code to determine specific details about the product's operation. Software Developer, Support Specialist

Computer Associates International - Islandia, NY - June 1995 to October 2004 Responsibilities

Support of Ingres Relational Database. Troubleshooting customer issues. Skills Used

Ingres DBMS, C, C++, Unix shell scripting

EDUCATION

Bachelor of Science in Computer Science

SUNY-Stony Brook Stony Brook - Stony Brook, NY

1990 to 1995

SKILLS

Sql Server (8 years), Avaya (8 years), Database Administration (10+ years), Network Administration (8 years), SQL (10+ years), SonicWall (8 years), IT Management (8 years) MILITARY SERVICE

Service Country: US

Branch: US Marine Corps

Rank: Corporal (E-4)

Rifleman, Cobol Programmer, Small Systems Specialist ADDITIONAL INFORMATION

Skills:

- C++ programming using GCC on Unix environments (HP, AIX, Solaris)

- C++ programming using Visual C++ in Windows

- Source code control using Visual SourceSafe and Harvest

- Embedded SQL written in C++ on Unix platforms, used to query Oracle and Sybase database Data Dictionary catalogs for necessary information

- XML used in the mssecure.xml security bulletin file

- Visual Basic scripts, Unix Shell scripting, Windows Batch file used to run vulnerability scans as well as to retrieve the latest security bulletins from the Computer Associates website

- Rogue Wave Studio and Toolkit to build the GUI front-end for the product

- General knowledge of Unix (HP, AIX, Solaris) and Windows NT/2000/XP 1996-2002 Ingres Technology Consultant

Provide telephone and email technical support for Ingres, Computer Associates' relational database product, including development tools. This encompasses severe cases where systems are down, to advice and troubleshooting on database design, backup and recovery, application development, and query optimization. Duties:

Reproduce and solve problems encountered by the customer. Skills required to perform this function:

- Build and populate databases with pertinent data

- Write SQL to create tables, alter tables, retrieve and modify data according to the customer's needs. SQL was in ad-hoc queries and also in stored procedures

- Write Embedded SQL within C and C++ programs

- Performance optimization through properly constructed queries, database design, table design, and setting of database tuning parameters (memory, cache, etc).

- Connect to databases, retrieve and update data via ODBC using third-party applications, such as MS-Access, MS-Excel, and Active Server Pages created with MS-Visual Interdev.

- General knowledge of Windows NT/2000/XP and Unix (HP, Solaris, AIX)-Create and troubleshoot applications developed in OpenRoad, a GUI application development program. 1995-1996 Ingres Quality Assurance

Testing of new releases. Perform standardized tests on product, determine if abnormal test results are expected or bugs to be fixed.

1994-1995 Computer Operator (part-time), Estee Lauder, Melville, NY

- Overseeing of Mainframe and HP systems

- Processing of batch jobs

1986-1990 United States Marine Corps

Small Systems Specialist

Administration and Maintenance of PC computer systems. This includes repair/troubleshooting, and maintaining the hardware and software inventories on base.

Contact this candidate