Software Development Services
Tools For Power Programming™
http://www.SevenStarTech.com

Robert D. Hajicek
777 Briar Lane n Catawissa, MO 63015
Phone 636.399.2265 n Fax 877.606.3818
Email Addr: 
rob@SevenStarTech.com

Introduction

SevenStar Technologies has a two-fold mission:

I.  Serving the software development needs of corporations, specializing in:

  • Desktop applications
  • Database design and implementation
  • Internet / Intranet / Website design and development
  • User interface design
II.  Creating and nationally marketing development tools for visual developers.
  • I have developed and continue to market two add-on productivity tools for Visual Basic: Object Briefcase™ and StarPrint/VB™. I am currently working on the .NET versions of these products, which requires a complete rewrite.
  • My approach to marketing these tools is to automate most of the day to day aspects, allowing an average of 4 out of 5 days available for custom software development services. My expertise in creating cutting edge tools for developers assures you that I have a deep understanding of these technologies—expertise that you can leverage for your own strategic business needs.

Consulting Services

With over 18 years of professional experience in software and systems development, I have the background to help meet the new and challenging needs of businesses as they implement client/server and internet technologies.

With extensive experience designing software architectures, databases, and dealing with the myriad of connectivity issues, I am comfortable in project leadership, business analysis, software development and web page design roles. 

Having excellent commercial art and graphic design skills, I have a sharp eye for professional web-page and user interface design

My disciplined quality conscious approach and communication skills allow me to work in team settings as well as alone, whether on or offsite.

Specializations

Full Project Life Cycle
  • Client / Server Architecture
  • Website and Internet Development
  • Project Leadership
  • User Interface Design 
  • Scope Estimation
  • Data Flow Analysis
  • Process Modeling 
  • Performance Tuning
  • Data Modeling
  • Technical Writing
  • Database Administration
  • SQL Optimization
  • User and Developer Training
  • Technical Support and Maintenance
  • Order Entry
  • Inventory / Accounting
  • ERP / JIT
Windows Technologies
  • Visual Basic 3 / 4 / 5 / 6
  • Visual Basic.NET
  • Web Services
  • SQL Server 6.5 / 7.0 / 2000
  • Microsoft Transaction Server
  • HTML / ASP / VBScript
  • MS-Access
  • Exchange / CDO
  • Delphi / BDE / Paradox
  • ODBC / OLE DB
  • Oracle (non-DBA)
  • Progress 7
  • SAP
  • EHLLAPI
  • MAPI
  • Crystal Reports
UNIX Systems
  • Progress 6 RDBMS
  • System Administration
  • Shell scripting
  • Netware for UNIX
  • FTP / Telnet
  • Socket Communications

(Although not having worked with Linux, my Unix background would allow me to learn Linux very quickly if needed.)

Macintosh
  • Omnis 5
  • Omnis 7
  • Hypercard
  • Pascal / QuickDraw
  • TCP/IP
  • Serial & ADB Communications

(My Macintosh skills are not up to date, but with my 5 years of Macintosh development background, I would be able to get quickly up to speed.)


Not on the list? My breadth of experience and exposure to many other technologies and databases allows me to quickly pick up new or different platforms, development environments, APIs, or languages.

Spotlight on Systems Developed

Complex Pricing System

Designed and Implemented a complex pricing and contract cost system for wholesale, commercial, and government sales.  Includes data entry, reporting, and the ability to customize and export data to Excel.  Wrote in Visual Basic 6.0 accessing MS-SQL Server 2000 with MS-Office integration.

Web Shopping System

Developed all business logic to support a web-based shopping system for a large office supply products distributor.  Utilized Visual Basic 6.0, Microsoft Transaction Server, and MS-SQL-Server 6.5.  All business logic being called by ASP Pages using JScript.  

Internet Web Development

Resume submission system for a large corporation.  Designed using ASP pages and VBScript running on IIS 2.0.  Integrated with CDONTS to send all submitted resumes to a human resources automated processing system.

Order Entry System 

Maintained and enhanced a multi-faceted order entry system.  Capabilities include dealer dropship, vendor dropship, return-authorizations and complex price, cost, and freight options.  Worked in Visual Basic 6.0 accessing MS-SQL Server 2000.

Workflow Systems Architect

Development of complete workflow processing between independent accounting, order entry, purchasing, and warehousing systems.  Written in Visual Basic 5.0 using Microsoft Transaction Server (MTS) and MS-SQL-Server 6.5.

 

Intranet Web Development

Created and maintained various systems:  international capabilities database, sales enhancement, company directory, etc.  Worked on ASP pages using HTML and VBScript running on IIS 2.0 accessing Access and MS-SQL Server 6.5 databases.

Sales Lead Processing System

Project leadership, scheduling, and training of staff. Design of system architecture, database, and reusable software components. Wrote all specifications and documentation of system.

Utilized Visual Basic 5.0 with MS-SQL Server on multiple Windows NT 4.0 servers.

One-stop Communication Services Shopping System

Worked on a for a regional telephone company.

Utilized Visual Basic with Oracle Objects for OLE connecting to an Oracle7 server on Windows NT 3.51.

Insurance Assessment Tracking System

wrote entirely in MS-Access 97 for a branch of a nationwide insurance broker.  System tracks all school districts in the state of Missouri for insurance purposes.

 
SAP Windows SQL Driver

Project leader: desktop integ. strategy.

Designed an OLE SQL driver for SAP using proper SAP security.

Technologies used: SAP/ABAP, Remote Function Calls, Visual Basic 4.0, OLE Automation, and MS-Office.

Leadership in the UNIX architecture and configuration of the SAP development environment.

Insurance Agency Management System

Project Planning, Database design, and Windows 95 user-interface design. Implemented business rules using 3 tier internal object oriented methodologies.

Written in Delphi 2.0 against Paradox 7.0 on Windows 95.

 

Expert SQL Query Tool

Designed for research engineers to allow them fast and easy access to R&D manufacturing test data.

Provided a graphical environment with automatic SQL generation, execution, display, and export to MS-Office.

Written for Oracle7 on VAX and UNIX using Visual Basic, MS-Access, Q+E ODBC Library, and OLE Automation.

Purchase Requisition Routing System

Created using Microsoft BackOffice/Exchange Server to create and route purchase orders throughout a large corporation.  

 

Sales Graphical Front End

Developed an IBM Mainframe front-end using Visual Basic, EHLLAPI, Access, and Q+E, w/ drag-and-drop technology.

Wrote 200 reusable procedures and 70 pages of documentation for knowledge transfer.

 

Sales Force Automation System

Included complex product configuration system.

Utilized Visual Basic, MS-Access, OLE, Crystal Reports and VIM.

Initial work upscaling the database to MS-SQL Server.

 

Pilot Flight Log System

Fully designed and implemented in 2 weeks for a TWA pilot. Designed for fast data entry and easy customization.  

It includes advanced user interface elements and full reporting capabilities.

Written in Delphi 6.0.

Agricultural Management System

Technical & architectural design for a world class commodities company.

Utilized Progress v7 as the main database and language on Netware and Windows 3.11 platforms.

International Material Management System

Database specification, design, project leadership, and programming.

Development of over 300 programs and installation at 9 US sites occurred after only 5 months.

System and database administration and installation of UNIX computer systems.

Entirely developed using Progress v6.

JIT Manufacturing & Order Processing System

Project Planning & Design of a new strategic Client/Server system.

Business Process Reengineering of JIT product and information flow.

Included an intelligent manufacturing configurator, on-line graphical SOP.

Utilized System Architect in design.

Planned technologies: Progress v6, Visual Basic, ODBC w/ SCO UNIX.

Mfg., Inventory & Quality Management Database Systems

Designed and maintained over 25 different Omnis 5/7 database systems on Macintosh computers:

Inventory Systems, Just-In-Time mfg., quality, labor and cost tracking, barcoding, and photo-typeset serial numbering.

Macintosh Pascal programming as needed to meet project requirements.

Data Access of Financial Data

Implemented using Visual Basic and MS-Access on OS/2.

Macintosh to PC graphics translation software

Developed on the PC using C for electronic circuit documentation.

Custom Laser Printer Driver

Developed on the PC using C for interface with high speed printers.

Touch Screen Kiosk for a Grocery Store Chain

Created a touch screen information kiosk for Cub Foods groceries stores (The Cubputer), in use from 1984 to 1988.

Technical Sales Force Information & Ordering system

Developed database systems on Macintosh’s: Invoicing, Purchasing, and a Technical Sales Force Information system.

Franchising, AP/AR/GL System

Responsible for a large headquarters system, handling 1400 franchises.

Maintained the accounts payables/receivables and GL system.

Feedback

Comments From Client Reviews

"Would hire back in a flash!"

"Pleasant to work with."

"Provided good recommendations, but accepted decisions."

"Creative, extremely quick learner, works fast and accurately."

"Good organization skills, competent with technology."

"Rob’s contributions were well received. He is a valuable resource to have on a project."

"Rob did a fantastic job looking at and solving our questions in a professional and expedient manner."

Letter From A Client

"Rob has far exceeded my expectations. A working program was generated in a timely manner. The program is well designed and very easy to useľ a super job."

MIS Manager

"I would like to congratulate you on the great work you did on the project. It sounds like the feedback you received was extremely favorable. You should be very proud of what you have accomplished, including making our old Marketing Sales system look and feel like a new state-of-the art system. The additional accomplishment of implementing the first client/server windows system here is tremendous! I hope this is the look and feel of everything we implement in the future. It sounds like the users were thrilled, and there is no greater feel of accomplishment after a project like that than happy users. They will now have new expectations of systems we deliver as you have established a new benchmark for comparison."

Previous Consulting Manager

"Rob is an excellent consultant (top 10%) who has great potential due to his strong breadth of skills and his strong ability to cultivate client relationships."

Former Employer

"Good at systems and applications design." "People interface a strength. Strong team player." "Concerned about others problems. Willing to assist, support, and help others." "Takes time to prove out ideas and software. "

Partial List Of Former Clients

  • Cargill 
  • Distribution Management, Inc. 
  • Emerson Electric’s Rosemount division 
  • Maritz 
  • Monsanto
  • Seagate 
  • Southwestern Bell 
  • Starkey Laboratories
  • Talx 

References Available Upon Request