Jan Fetyko
Edmond
Oklahoma,73013
USA
Engineer of Electrotechnics
Grad. Date:May 1996
Technical University of Kosice
Major:
Automation of Power Devices
From: November.1999
Programmer/Analyst
Phase2 Development Corp.
4100 Perimeter Center Dr.
Oklahoma City
Oklahoma
73112
USA
Responsibilities

1. Java, JSP, J2EE, Servlets development, using Struts framework to enhance J2EE applications
2. Database schemas analysis and implementation based on project needs (MySQL, DB2, MS SQL)
3. Utilizing HTML, JavaScript, PHP.
4. Development of PC applications utilizing Lotus Notes ver. 4.6 and R5 for MS Windows 95/98/NT/2000/XP
4. Development of Internet applications based on Lotus Notes Domino servers ver. 4.6 and R5

Description

Working as part of a development team, the web application programmer/analyst is responsible for database design, database development and application development using tools such as Java, JSP, PHP, Microsoft SQL Server, MySQL and Lotus Notes. Developer works closely with the project architect and/or project manager to develop software design specifications, develop web based applications and deploy web sites & web based applications according to design specifications.
My official title at Phase 2 is "ScriptFighter".
* * *
From: May.1997
To: October.1999
Programmer and Analyst of database systems
Sideria-Istota ZZP
Zeleziarenska 2,blok 3
040 25 Kosice-Saca
Slovakia


Responsibilities

1. Development of PC applications for Client/Server based system in PowerBuilder 5.0, 6.5 for Windows 95/98/NT. Installation of application software.
2. Development administration and distribution of databases based on system SYBASE SQL Anywhere ver. 5.0 and ASE 11.5
3. Installation and configuration of local TCP/IP networks
4. Windows 96/98/NT 4.0 Installation and configuring
5. Development of operational and financial reporting

Description

While working in a team, getting many inputs from the team, I was given a task to build and maintain an unique application for which I was the analyst, programmer and administrator at the same time. The rest of the team worked on separate corporate wide applications, all of the finished and tested pieces were distributed at once to branches and users.
* * *
  • Java - Years of experience:51/4
  • SQL - Years of experience:7
  • PHP - Years of experience:4
  • MySQL - Years of experience:41/4
  • JDBC - Years of experience:41/4
  • ASP.NET - Years of experience:23/4
  • EJB - Years of experience:1
  • JBoss - Years of experience:1
  • JMS - Years of experience:1
2000-06-01 - Certified Lotus Specialist R5 (CLP)
1998-10-01 - Lotus Domino Developer I.
Phase2 Development Corp.

December.2004
to
January.2005
Summary:Xpediair is another portal for IEC with little bit different functionality and different database backends. My first encounter with Oracle.
  • Database export & import scripts
  • Business logic classes development
  • JSP page development
  • Database mapping

Skills used: [Apache Ant]  [Apache Tomcat]  [Java]  [JDBC]  [JSP, Servlets, Struts, J2EE Java Beans]  [MySQL]  [Oracle DB]  [SQL

* * *

October.2004
to
January.2005
Summary:Phase 2 Development provided International Environmental with web based portal to facilitate the delivery of highly personalized information at the group level. The objective of this project was accomplished by the development of the portal and the integration with backend systems. This portal provides International Environmental an administrative interface to manage workflow and permissions as well as upload and maintain content. The combination of this functionality and personalization gives International Environmental a robust interactive web presence. My role in this project started after it was abandoned by the original developers and reassigned to me. I worked on all the sections of the application (public, admin, portal) to accomplish:
  • Database export & import scripts
  • Business logic classes development
  • JSP page development
  • Database mapping

Skills used: [Apache Ant]  [Apache Tomcat]  [Java]  [JDBC]  [JSP, Servlets, Struts, J2EE Java Beans]  [MySQL]  [SQL

* * *
Mirroring tool

September.2004
to
October.2004
Summary:In a redundant server environment, our company was in need of a mirroring tool that would keep all servers up to date. Due to specific requirements for such a tool I decided to build a set of windows services. These services use "rsync" protocol and XML to check and patch files.
Skills used: [ASP.NET]  [XML / Xerces / JDOM

* * *

March.2004
to
August.2004
Summary:Pioneer Telephone Cooperative, Inc., was formed as a cooperative telephone company in 1953, with four exchanges, four part time employees, and an investment of $50,000, at a time when rural residents had no telephone service. Today, Pioneer Telephone employs over 600 people, our service area covers 76 exchanges, 10,900 square miles, and serves over 50,000 subscribers in 30 Oklahoma counties. Pioneer Telephone has grown into a multimillion dollar corporation, qualifying it as one of the largest telephone cooperatives in the United States.PTCI has identified the need to take their web presence to the next level to better meet the perceived needs othe their customers, maintain market copetetitiveness and gain operational efficiencies that the automation of specific processes can offer. As the only developer I was responsible and achived:
  • Database Design and Implementation
  • Database mapping
  • Backend processing and page code
  • Created code to retrieve News,Stocks and Weather from internet RSS sources
  • Created CMS for all sections of the website

Skills used: [Apache HTTP]  [JavaScript]  [MySQL]  [PHP]  [Redhat Linux]  [SQL

* * *
Taylor Valve Choke Sizer

January.2004
to
June.2004
Summary:Taylor Valve is an inovative company that manufactures valves for fluid and gas transmission. The choke sizing application is a sofisticated set of calculators that can calculate valve sizes based on fluids transported (either a single fluid or multiple fluids mixed). All calculations and results are stored in a standalone SQL based system to provide easy future transformation from a standalone system to internet based system. Each calculator group also has a separate dynamicaly generated print screen. I was the sole developer, my achievements in this project included:
  • Database Design and Implementation
  • Created database mapping classes
  • Created all screens with menus and calculations

Skills used: [Hypersonic SQL]  [Java]  [JDBC]  [Redhat Linux]  [SQL

* * *

November.2003
to
December.2003
Summary:OKGirlTech.org is a state funded effort to equip female students with skills to pursue career of information technology (IT), science, research and engineering. This project has been in production for a year when OKGirlTech.org officials requested changes and enhancements to the existing functionality. Tasks completed:
  • Enhanced messaging functionality
  • Tuned database schema and procedures for best performance

Skills used: [ASP.NET]  [MS SQL Server]  [SQL

* * *
Kimray valve calculator

August.2003
to
October.2003
Summary:Kimray Inc. is a manufacturer of valves, regulators, controllers and so on for pneumatic and hydraulic systems. Aim of this project was to port an existing Palm valve sizing application to Pocket PC and add few enhancements. The chosen development language was eMbedded Visual C++ 4.0, which I had to learn on the fly and fast.
  • I recreated all screens and logic
  • Ported calculation procedures
  • Added Save last values functionality to all screens

Skills used: [eMbedded Visual C++

* * *

September.2002
to
June.2003
Summary:This project is to take Sundowner Superstores through a fresh creative exercise to give this new venture a new and fresh look, but stay tied to the imagery and tradition of the Sundowner brand. This new Venture called SundownerPartsOnline.Com will also require a fully functioning backend system to allow for online eCommerce, displaying of the complete catalog of products, and administrative capabilities so the content can be managed, efficiently. This project will allow Sundowner Superstores to reach a larger market more directly than they are currently able to. After few design sessions with the client and graphic designers I was able to:
  • Design the database schema and implement it
  • Create database to object mapping classes
  • Implement struts as a MVC framework
  • Develop a shopping cart and checkout pages
  • Setup SSL on JBoss and Apache
  • Integrat online payment authorization and transaction

Skills used: [Apache Ant]  [EJB]  [Java]  [JavaScript]  [JBoss]  [JDBC]  [JMS]  [JSP, Servlets, Struts, J2EE Java Beans]  [MySQL]  [Redhat Linux]  [SQL

* * *

August.2002
to
June.2003
Summary:The mission of this project was to rebuild the V2 CS system and to be managed and handled through a web-based interface for access by unit owners, municipality contacts, and service providers in addition to Interon personnel. This system provides more reporting and notification capabilities as well as more automation than previous versions of the CMS console. The new system is simply called ESP.ESP users nclude unit owners, contracted service providers and municipalities and Interon & Little Giant personnel. Anonymous users do not have access to this system.
I contributed to this project by:
  • Helping to design database backend
  • Developed database mapping in VB.NET
  • Tuned performance of database queries
  • Developed multiple windows services (SMTP outgoing mail, Power sewer call handling utilizing a modem handling API, Scheduled data import/export)
  • Created a console based initial data import program

Skills used: [ASP.NET]  [MS SQL Server]  [SQL

* * *

July.2002
to
October.2002
Summary:Petra Industries was looking for a revamp of the look and feel of the current Petra Industries web site and to add functionality to the site. This was accomplished by the development of a new architecture that delivers the content in a clear and concise manner. The public web site data is tightly integrated with the backend intranet based ordering and management system at Petra. Data exchange is accomplished via XML. The new website was developed in Java, JSP, application server of choice is JBoss, database backend MySQL, the hosting platform is Linux.
Coded the folowing features:
  • Created a database schema
  • Developed database to object mapping classes
  • Implemented struts as a MVC framework
  • Developed shopping cart and checkout pages
  • Created integration layer with Petra backend system via XML

Skills used: [Apache Ant]  [Apache HTTP]  [EJB]  [Java]  [JBoss]  [JDBC]  [JMS]  [JSP, Servlets, Struts, J2EE Java Beans]  [MySQL]  [Redhat Linux]  [SQL]  [XML / Xerces / JDOM

* * *

April.2002
to
April.2002
Summary:U.S.A. Digital Communications Inc. is looking to design and deploy a corporate website that will give a corporate preview to the general public and simultaneously serve as a tool to assist in the recruitment of new agents. The growing organization recognizes that by leveraging the Internet they can deliver timely and pertinent content to the end user, as well as recruit sales agents.
In this small project I used PHP as a server side scripting to :
  • Create a little script to email agent sign up information and requests for rates
  • Provide little templating system to put consistent content on multiple pages through include files

Skills used: [Apache HTTP]  [PHP

* * *

October.2001
to
February.2002
Summary:The public web site of Stillwater national Bank uses images extensively. Although images on the web site do not change very often, the client browser had to reload the images after the validation for same image failed. Therefore I was asked to create a so called image pool, which would hold a pool of images in the server memory for fast retrieval, serve images from this memory or from the file system, respond to client browsers validation requests as well as setting cache setting for images on client browsers. This enhancements were successfuly accomplished and provided the needed boost in performance.
Skills used: [Apache Ant]  [Java]  [JSP, Servlets, Struts, J2EE Java Beans]  [XML / Xerces / JDOM

* * *

July.2001
to
March.2002
Summary:The project aim was to redesign the public internet website from a site architecture with very complex system of static HTML pages to database driven content pages with as few templates as possible, lower time spent on maintenance and allow faster future growth and expansion that would integrate smoothly without further worsening the complexity.
Accomplishments:
  • Developed all backend and database mapping Java classes
  • Implemented Struts framework to all MVC elements
  • Created layer based JavaScript event driven navigation with dynamic links
  • Contributed to multilingual database design for easy data entry and data integrity
  • Designed JSP pages and templates for each section
  • Installed and administered IMB DB2 on Linux

Skills used: [Apache Ant]  [Apache HTTP]  [Apache Tomcat]  [IBM DB2]  [Java]  [JavaScript]  [JDBC]  [JSP, Servlets, Struts, J2EE Java Beans]  [Redhat Linux]  [SQL]  [XML / Xerces / JDOM

* * *

July.2001
to
July.2002
Summary:The goal of this project was to enhance the existing Mar-K Quality Products web site by adding over 5,000 individual products to the site through the product catalog and to allow customers to be able to view products and securely place orders through the Internet. This development effort also allows Mar-K Quality Products to post orders placed on the web site directly to Mar-K Quality Products back office systems. Main features: Complete product catalog, Integrated shopping cart, Backoffice order processing, Site interface and navigation enhancement, Administration area, Suggestive Selling / Order Intelligence, Intelligent boxing checkout and pricing, Quick Ordering / Product Search, Specials, Exploded Views of Truck Beds.
Features I provided coding for :
  • Shopping cart
  • Suggestive selling / order intelligence
  • Intelligent boxing checkout and pricing
  • Specials

Skills used: [Java]  [JavaScript]  [LotusScript

* * *
Hertz - E-forms

January.2000
to
June.2001
Summary:With the deployment of e-Forms (paperless approval system) based on a Lotus Notes 4.6 (and later on Lotus Notes R5) system within Hertz Corporation, certain forms require financial approval in addition to the normal approvals required on a given form. This project allows for complete integration of financial approval capabilities with e-Forms. Till end of my involvement with this project, there were over 200 forms with complete Approval routing available in the database starting with a basic vacation days approval to financial approval of equipment purchase.
My main accomplishments in this project were
  • Developed and deployed approval logic used by all forms that require approval
  • Shorted the response time and ease of use for Lotus Notes Clients.

Skills used: [Java]  [LotusScript

* * *
Directors, Inc.

January.2000
to
March.2000
Summary:To enhance Directors, Inc. web presence by providing end users with an interactive “easy to use” catalog and web site, with the JavaScript based shopping cart, online credit card authorization and shipping selection capabilities as well as online product and web site administration. My skills in this project helped me to
  • Create a JavaScript based shopping cart
  • Java classes for Authorize.net credit card authorization
  • LotusScript was also utilizied for many backend tasks

Skills used: [Apache Ant]  [EJB]  [Java]  [JavaScript]  [JBoss]  [JMS]  [LotusScript

* * *
Sideria-Istota ZZP
Integrated Reporting
and Management database

May.1997
to
October.1999
Summary:The core database system of the company is based on a multi relational database from Intersystems Corp. that runs in DOS environment. The aim of the project was the development of a user-friendly application on Microsoft Windows 95 for company managers who would be able to gather useful information to analyze the global financial situation of the company, have the ability to perform various statistical analyses. Utilizing Powerbuilder with Sybase SQL Anywhere database backend a Windows executable with numerous libraries was developed and deployed throughout the company and it's branches. All data was replicated though the branches also to significantly reduce the response time for local clients.
Skills used: [SQL]  [Sybase SQL Anywhere 5.0

* * *