Modified and enhanced UI/UX aspects of a proprietary Andon system,
written in C#, using Visual Studio and MS SQL Server.
Created and implemented SQL queries and rules to automate ERP report
generation and distribution. Maintained and modified existing Visual
FoxPro programs accessing SQL Server to create daily dynamic lists
of users to receive customized emails with embedded Crystal Reports.
Designed and developed a mobile web application allowing users to
create free accounts with limited information, or upgrade to
subscription based accounts with greater depth of information, to
build a personal profile around 'talent and skill keywords' for
inclusion in a versatile relevance search function which was then
available to other subscribers and talent agents and managers.
Perceived a niche, specified, designed and coded a web application
system that creates, for subscribed users, custom javascript code to
place on their web page that interacts with details in their
subscription account to send instant notifications of the web page
being visited by a browser.
Defined, structured and programmed a sophisticated web based online
wine ordering system, validating or negating order requests against
a backend database for complex business rules dealing with the
exclusion of dry county and shipping ability, linked with Google
Wallet API for purchases.
Envisioned and constructed a data driven system for monetizing free
WiFi hotspots utilizing rotating ads displayed based upon current
time, premium advertising client positioning, user response forms
and return incentives.
Conceived, devised and developed a mobile web application which
allowed subscribers, via PayPal API, to create an account and manage
unique URL's with associated photos and information about a related
home for use in Real Estate signage and marketing.
Produced hundreds of wine label design concepts along with finished
press ready art for Napa Valley private wine bottling customers.
Designed logos, branding and web sites in addition to laying out
high resolution artwork for printed marketing materials including:
direct mail postcards, brochures, business cards, email signatures,
email blasts, banners, listing presentations, car vinyl and magnets.
Responsible for the video production of hundreds of 'Virtual Open
House', MLS (Multiple Listing Service) compliant, video tours
including: videography, photography, storyline composition and
script, voice over recording and cleanup, and video editing within
iMovie, Premiere or Blender to output multiple video formats.
Nielsen, Inc. (Scarborough Division - Arbitron, Coral Springs,
Florida)
2017 - 2019: Senior Analyst
Analysed and re-coded existing Visual Basic, FoxPro, Access and
Microsoft SQL Server based programs to improve UI/UX, processing
speed and efficiency, reducing over all required time by almost 480
man hours (12 weeks) a year. Also wrote 500+ pages of user
documentation.
Devised and developed a 'problem character fix' module that
automatically handled, according to maintainable data driven
business rules, any unexpected ASCII character found on all incoming
data and produced a report of characters found, character location
and subsequent replacement.
Designed and rewrote several programs that had previously been
copied and modified for each new release, to a single reusable
program accessing a table driven release structure and corresponding
data to eliminate confusion and allow for backward compatibility.
IDLogistics (IDL), Dayton OH
1999 - 2001: Senior Software Engineer
Team lead involved in a full stack implementation of a globally
integrated 'dynamic product' ordering and manufacturing system,
written as a Windows Application interfacing to Oracle, encompassing
domestic and foreign manufacturing facilities, complex global user
rights and permissions, multiple order receiving and entering
methods including fax, email and EDI, linked customer catalog tables
for bar code, price and variable data as well as multiple
manufacturing methods.
Information Engineering Corp (IEC), Dayton and Cincinnati OH
1998 - 1999: Software Developer
Designed and developed both ASP (Active Server Pages) running on
Microsoft IIS and COM objects written with Visual Basic 6.0
interfacing with an Oracle database, which generated dynamic SQL
queries and returned resulting data via the object's properties or
methods and displayed and modified Oracle data.
Developed a dynamic web site utilizing Visual Interdev and Front
Page running on an NT server with Microsoft IIS, MS SQL Server.
Active Server Page technology dynamically builds HTML pages based
upon the current client profile, their product subscriptions, and
data driven product structures.
MONARCH MARKING (Avery Dennison), Dayton, OH
1994 - 1997 Service Bureau Division: Programmer / Developer
Worked as part of a team which designed, developed, tested and
implemented a Windows application, written with Delphi 2.0 (Object
Pascal) running on Win95 /NT platform, which retrieved, processed,
transmitted and tracked daily orders for multiple domestic and
overseas production facilities.
Solely responsible for the design, development, testing, and
implementation of a complete variable print imaging application
written in Clipper 5.2 that replaced existing licensed print engine
software and was more streamlined, intuitive, and easier to maintain
globally. The system merged variable text and graphics with data
driven image templates and then calculated appropriate step and
repeat arrangement for offset plate layout, defining run quantity
for least waste, and output direct to plate digitally either via
Autologic (ICL RIP) or Postscript.
Designed and developed a utility application to perform tasks such
as Postscript font downloading, graphic image management, and
imagesetter calibration.
Specified and created an image converter that converted TIFF images
from one compression format to another.
Licensed Florida Real Estate Sales Agent (Voluntarily Inactive)
Oracle - Developer/2000 Foundation and Forms I
Oracle Education, Indianapolis Education Center
Oracle - Introduction to Oracle: SQL and PL/SQL using Procedure
Builder and Advanced SQL and SQL+
Oracle Education, Cincinnati Education Center
Education
Ohio Institute of Photography, Commercial Photography Major
Vandalia-Butler Senior High School, Vandalia, OH. Art/Graphic
Design, Honors Math
Accepted into Purdue College of Mechanical Engineering and scheduled
to begin classes.
However, I relocated at the request of my then current employer
offering a major career opportunity.
Steven Mikel - Dark Roast Paintings
Galleried, international fine artist specializing in coffee based
watercolors.
For more information perform a web browser search:
'Steven Mikel' Coffee