Jan Fetyko
Edmond
Oklahoma,73013
USA
JDBC - Years of experience:41/4
Since my application development tool of choice is Java, JDBC is the best way to connect to databases. It's a must to be able to set up, test, use JDBC and optionally create a connection pool of JDBC connection to improve performance. I have the oportunity to do all these tasks for almost every project.
Phase2 Development Corp.
IEC - Xpediair Portal

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] 

* * *
IEC - Portal

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] 

* * *
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] 

* * *
Sundowner Superstores

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] 

* * *
Petra Industries

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] 

* * *
Saxon

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] 

* * *