Sql Server Manager
Resume:
Robert M. Kainer
Houston, TX 77036
********@*****.***
SUMMARY
Results-oriented IT PROFESSIONAL with dual degrees, seeks Software
Applications Developer opportunity that applies technical strengths
combined with significant expertise as follows:
< 15+ years in diverse positions for manufacturing/distribution companies,
prominent legal firm, medical facility, and software
developers/marketers, with proven results in administering technical
assignments and achieving optimal productivity through resourceful use of
time and resources.
< Demonstrated proficiencies in project lifecycle management, encompassing
the design and implementation of routine/complex and e-commerce
solutions.
< Experienced in object oriented design/development; expertise in .NET,
Visual Basic, C#, SQL, Crystal Reports, UNIX shell scripting; extensive
background with MS SQL Server; internet-based programming and
technologies such as ASP/ASP.NET, Javascript/VBScript, HTML, XML, CSS,
Microsoft Sharepoint; experience with data modeling.
< Solid background in operating platforms, ranging from Windows and UNIX to
Macintosh and VAX/VMS systems; experienced with leading-edge hardware
including workstations, servers, PCs.
< Superior abilities in logical design, analysis, and troubleshooting, with
skills in anticipating and resolving issues prior to errors causing
downtime; highly analytical and focused on precise tasks at hand; keen
attention to detail without sacrificing on-time and quality objectives.
< Consummate team player capable of working independently to achieve
business and personal goals, performing with high competence and meeting
allocated timelines in challenging work environments; quickly master new
and advanced skill sets; characterized as tenacious and persistent.
< Excellent communication and interpersonal skills; easily establish
cooperative relationships with staff across the organizational spectrum;
good listener able to facilitate a broad range of users through
identifying and resolving problems with software applications and
operating systems.
CAREER OVERVIEW
SENIOR APPLICATIONS DEVELOPER
6/06-Present
WOOD GROUP/GE OIL & GAS PRESSURE CONTROL
HOUSTON, TX
Provide ERP system applications development and database programming for
manufacturing and distribution company marketing wellhead and pressure
control equipment to the oil and gas drilling industry. Activities include
development of custom applications within Infor Syteline 7/SL8 ERP systems,
including design and development of user interfaces/forms, custom VB.NET
programming, and writing of backend SQL Server stored procedures, triggers
and indexes; Crystal Reports development; adding modifications and
extensions to existing system functionality; interfacing of ERP system data
to MS Office applications; maintaining, enhancing and adding features to in-
house developed C#/Winforms and DevExpress controls-based reporting
applications.
< Designed, developed and implemented custom Rental Order Management
application within the Syteline 8 ERP system, eliminating company need
for licensing and use of 3rd party rental order management software, and
providing higher level of integration with the main ERP system
< Designed and developed Financial Reporting definition user
interface/tools within SL8 ERP system, providing accounting users a
highly configurable and flexible means of creating Excel spreadsheet
reports on various general ledger accounts based on user-defined
selection criteria.
Robert M. Kainer
Page Two
< Designed and developed capability within the SL8 ERP system for
performing full text search of user notes entered within the system, a
capability not available in the native ERP software, providing
significant enhancement to part lookup for engineering users
< Key developer role in successful system implementation and upgrade from
Syteline 5 to Syteline 8 ERP system, including conversion/refactoring of
legacy custom applications and reports from Progress-based to VB.NET/SQL
Server-based system.
PROGRAMMER ANALYST
7/98-5/06
PUFFER-SWEIVEN
STAFFORD, TX
Provide proactive support, applications development and database
administration/programming for this manufacturing, assembly and
distributing company that markets process control equipment to the chemical
industry. Responsibilities range from developing, maintaining, debugging,
configuring and optimizing software/systems to installing and testing
product upgrades.
< Design applications in C and Unix shell script for processing and
providing user interfaces to database, adding extensions, enhancing and
modifying existing code and functionality to meet evolving requirements.
< Develop automated report generation programs in SQR for scheduled and "on
demand" user reports to facilitate timely business decisions and
maintenance of daily operations.
< Write SQL database stored procedures for web and ERP applications backend
processing.
< Support and implement programming and enhancements for ASP/HTML-based
customer service website, enabling clients to track orders and verify
status of equipment repairs.
< Provided DBA technical support to development project implementing Oracle
11i E-Business suite, including software components installation and
configuration, database backup and cloning, configuring database network
connectivity across multiple platforms (Oracle/Sybase/SQL Server),
tablespace/filesystem management, and running of database diagnostics for
applications debugging and testing.
Solo projects included:
< Planned, programmed and implemented first program for automating vendor
pricing updates with transition from manual operation; staged new
application through Access, enabling export of data to business database
and expediting process, while facilitating timely control of inventory
price increases.
< Developed and wrote program for validating data on freight invoices
processed through EDI; application established automated process for
accounting and shipping/receiving departments to clarify and verify
accuracy of data.
< Enabled centralization of account information and facilitated
accessibility by sales/marketing teams through programming of new web-
based business account planning application; included data modeling on
SQL Server to establish table data relationships and providing process
for defining/registering data on business objectives/goals between
internal departments.
SENIOR ENGINEER - SOFTWARE
2/98-6/98
SIMULATION SCIENCES, INC.
HOUSTON, TX
Assigned to administer project for centralizing network of 8-10 Sun Unix
workstations for this developer of chemical process simulation software
targeted to industrial markets.
< Transitioned servers and desktops from R&D programming to IT
responsibility; updated operating systems and debugged legacy C code to
ensure functionality; established server backup applications; systemized
user accounts; and administered all systems, network nameservers and
network filesystems.
SYSTEMS ENGINEER
8/93-1/98
HALE & DORR LLP, COUNSELORS AT LAW
BOSTON, MA
Provided system administrative and database programming support in this
major corporate/commercial law firm of 200+ attorneys and a substantial
staff of support employees. Designed GUI-based 4GL applications, developed
programs for generating reports from legal databases using SQL, C, and
Ingres Report Writer, and provided technical support and software
installations/upgrades for VAX and HP-Unix operating systems and NCS
Trustware applications.
< Participated in planning and implementing project for migrating majority
of in-house applications from VAX to HP-UX platform; designed and
developed HTML/Perl/CGI based applications for firm intranet.
Robert M. Kainer
Page Three
SYSTEM MANAGER
9/92-8/93
CERNER CORPORATION
BILLERICA, MA
Provided operating system support for this software developer of medical
database applications; designed and
implemented in-house system management procedures, scripted automated
backup routines, troubleshot and
debugged performance issues and maintained security system.
< Wrote user interfaces and scripts for software installations; managed and
provided technical troubleshooting for terminal and servers on Windows
workstations and PCs.
SYSTEM MANAGER
9/90-
8/92
MASSACHUSETTS GENERAL HOSPITAL
BOSTON, MA
Maintained and provided troubleshooting for VAX operating system and
medical database applications, administering user support and ensuring
performance integrity, installing/testing software and system upgrades.
OTHER EXPERIENCE
Programmer / Analyst for Texas Department of Highways & Public
Transportation, Austin
Provided operating system support for statewide network of VAX/VMS systems
running CAD/CAM applications,
including software installations, upgrades, and system customizations, day-
to-day system maintenance, performance management, and user support.
Developed and maintained programming for automated application of software
updates and customizations.
TECHNOLOGY SKILLS
Programming Languages: Visual Basic (VB.NET, VB6, VBA); C#; SQL/T-SQL; UNIX
Shell scripting (C, Bourne, Korn, awk/sed); C; DOS scripting; Progress 4GL;
Ingres 4GL; VAX DCL
Internet Languages/Technologies: HTML; ASP/ASP.NET; Javascript; VBscript;
XML/XSL; Cascading Style Sheets (CSS); Microsoft Sharepoint; Nintex
Workflow; CGI Scripting; Perl; IIS - Internet Information Services
Reports Generation Languages/Utilities: Crystal Reports; SQR; Ingres Report
Writer
Database Systems/Protocols: MS SQL Server 2000/2005; Sybase; MS Access;
Oracle; Ingres; ADO/ODBC
Productivity Tools: MS Visual Studio 2005/2008/2010; SQL Server Management
Studio; Visual SourceSafe; SourceGear Vault; DevExpress Controls; NUnit
Unit Testing suite; MS Office Suite; MS Sharepoint Designer; Incase CASE
Tools; Tivoli Maestro
Operating Systems: Windows 7 /XP/Vista; UNIX (Sun Solaris, HP-UX); MAC-
OS/OSX; PC-DOS; VAX/VMS
Hardware: Dell Servers/PCs; Apple Macintosh; SUN Workstations/Servers; HP
Mainframe
EDUCATION / PROFESSIONAL TRAINING
The University of Texas at Austin:
Bachelor of Arts degree with Honors, major in Computer Science - 1984
Bachelor of Music degree with High Honors, major in Music Theory - 1982
Oracle DBA Fundamentals / 11i Install, Patch, Maintain Oracle Applications
- 2005
Web Development with Active Server Pages and Building XML-Based Web
Applications - 2002
C++/Visual C++/Object Oriented Design - 1998
Continuus Code Management System Developer and Build Manager Courses - 1998
Ingres SQL Fundamentals, 4GL for Application Developers, and Report Writer
Courses
HP-UX UNIX Fundamentals and System Administration for Multi-User Systems
DEC VAX/VMS Advanced System Management
Contact this candidate