|
|
SQL - Years of experience:7
|
|
SQL is a must while working with a SQL database. First time I used SQL was during my studies at Technical University of Kosice, where I developed a small application for my personal use. However the first major application that used SQL was the reporting application I developed at Sideria-Istota ZZP. From there I used SQL in numerious projects.
|
|
December.2004
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
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]
|
* * *
|
March.2004
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]
|
* * *
|
January.2004
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
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]
|
* * *
|
September.2002
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
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
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]
|
* * *
|
July.2001
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]
|
* * *
|
May.1997
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]
|
* * *
|
|
|
