Oracle PL/SQL Development, VMS, VB
Resume:
Paul D. Black
Lakemore, OH 44250
Email: **************@*****.***
SKILLS
Languages
•Swift (iOS),Uniface, Oracle PL/SQL, MS SQL Server/T-SQL, WinBatch, Unix Shell, HTML, XML, ASP, VBScript, JavaScript, C++, C, Visual Basic with COM, PIC BASIC, FORTRAN, Pascal, COBOL, Assembler, DECVoice Builder, Delphi, Pascal, MS PowerScript, Unix Shell Script.
Web/Multimedia development tools
•Director 8 Shockwave studio by Macromedia
•Flash, Photoshop/ImageReady, Fireworks
•Dreamweaver 4.0, MS Visual Interdev, NetObjects Fusion
Networks/Hardware/Operating Systems
•Installation and setup of Windows 2000 Server/2000 Pro/XP/9x systems
•Desktop maintenance and repair.
•Development on NT/Windows TCP/IP networks, Sytek Broadband LAN, Reliance Automate LAN, DECnet and TCP/IP on Ethernet
•PC Graphics Adapters, MicroVAX, VAX, DEC Alpha/Open VMS
•Windows Vista/XP/2000/NT/95, Windows 2000 server/NT server, VAX/VMS, UNIX, MS-DOS
Database
•MS SQL Server (V6 to 2012) logical and physical design, modeling, development and some Administration, T-SQL Programming of stored procedures, DTS Packages, SSRS
•ORACLE PL/SQL Programming, Logical design, modeling, development, and installation on Windows 2000
•IBM U2 Database (text based)
•Microsoft Access design, development, and administration, ADO, and DAO
•ORACLE/RDB, VAX DBMS, SQL/Services (client server), Interactive SQL, Imbedded SQL, SQL Module Language, ODBC
•Design/development of custom memory-resident database
Other Tools
•MS Outlook, Excel, Access, Word, FTP, self-extracting zip,
•Visual Sourcesafe, CMS (Code Management System), Visual Studio
EDUCATION AND CERTIFICATIONS
•B.S. Mathematics/Computer Science, Lawrence Technological University, G.P.A 3.9 out of 4.0
•A+ Certified, Course work in Windows
•Class Work in C++, Object Oriented Programming, Database Design
PROFESSIONAL EXPERIENCE
May 2015- Present – Independent Consultant
•Conversion of transcript data from VAX/VMS files to CSV text files
•Design and creation of SQL Server database and Loading of above data into SQL Server
•Modification of applications written in C on Open/VMS, using Oracle RDB database, SQL Modules.
Jan 2012 to May 2015 – Rohrer Corp, Sr. Programmer/Analyst
Software Development using Uniface Integrated Development Environment (learned new), WinBatch (learned new), MS SQL Server 2008, 2012 in a mostly Windows environment (some Unix). Software and hardware support for five plants in GA, PA, OH, AZ, and IL, Set up virtual machines using VMWare (learned new), thin-station Wyse clients, Axis print servers (learned new). Networking using Active Directory and assorted tools. Set up of Custom scale systems w/ Zebra printers, custom hardware and software. Analysis and design of replacement shipping system (CMS Worldlink replacing Clippership).
Sept. 2011 to Nov. 2011 – KForce contracted to Snap-on Tools, Sr. Programmer/analyst
Short term Data Analysis project preparing for a new version of Electronic Parts Catalog.
Nov. 2008 to June 2011 – Cuyahoga Community College. Programmer/Analyst III
Development of new and enhancements to existing Oracle Applications (including Banner and Web Tailor/Self Service) using PL/SQL, Oracle Forms, Oracle Web Toolkit for web applications, Unix Shell, Pro C, TOAD, DCL (Digital Command Language), Using Open VMS on a HP Alpha Server. Conversion to HP-UX (UNIX) on HP servers. Development of Unix shell scripts, development and/or modifications of SQL scripts and Pro-c source code as necessary. SQL Server 2008, development of reports in SQL Server Reporting Services (SSRS).
ASP .NET training.
Oct. 2008 to Nov. 2008 – Western Reserve Contracted to CBIZ
Conversion of older proprietary database to SQL Server.
July 2008 to Sep. 2008 – Oxford and Associates contracted to Cuyahoga Community College, Oracle Database Developer.
Enhancements to existing Oracle Applications (including Banner) using PL/SQL, Oracle Forms, Pro C, TOAD, Report Builder, DCL (Digital Command Language), Using Open VMS on a HP Alpha Server.
April 2008 to July 2008 – Yoh IT contracted to Fidelity National Field Services, Oracle Database Developer.
Responsible for the enhancements and modifications to existing Oracle Web Applications and Stored Procedures using Oracle PL/SQL, Oracle Reports, TOAD and Serena.
March 2008 to April 2008 – Oxford Consulting Group Contracted to Sterling Commerce, Programmer/Analyst
Responsible for the enhancements of Sterling’s WebForms product using ASP, JavaScript, HTML,
SQL Server 2005.
Aug. 2007 to Feb. 2008 – Modis contracted to OEConnection, SQL Server Developer
Assisting in migration of data from legacy to new SQL Server 2005 including Discovery and analysis of data. Development of Schema, T-SQL scripts, Database design and normalization, triggers, indices, and constraints. Development of stored procedures for database access and transformations. Development of Instead-of-triggers to enable bridging between old and new databases.
Nov. 2006 to Aug. 2007– Custom Business Solutions contracted to United Bank &Trust, Web/SQL Programmer
Responsible for the development and enhancement of bank intranet using ASP, Visual Studio .NET, SQL Server 2005, JavaScript, and HTML. Database design, development, and administration using MS SQL Server. Created development test web site and test database in SQL server. Setup and configuration of IIS. Modified code to dynamically choose the database.
May 2005 to Nov. 2006 – Headwaters/Tapco Group, Web Developer/Programmer, SQL Server Administrator, Network support.
Member of the network support group. Duties include SQL Server administration and development, design and programming of systems in ASP, JavaScript, HTML, CSS, PIC Basic/Ohm, in a Windows and Unix environment, some U2 database development, IIS setup and configuration, administration of McAfee security software for entire network. Desktop, network, and end user support including MS Outlook, Custom software, printers, installation of operating systems and application software.
Jan 2005 to March 2005 – Anatech, Ann Arbor, MI Contracted to Pfizer
Maintenance of current websites using ASP and JavaScript. Development of forms using Adobe Acrobat and MS Word. Gathering of requirements from customers on upcoming changes to shipping site.
Nov. 2004 to Jan 2005 – GTech, Dearborn, MI Programmer/Analyst, Oracle Development. Contracted to General Motors Advanced Technology Vehicles, Troy, MI
Migration of Benchmark and Tear Down application to New Oracle database. Application developed using MS Access front end and Oracle backend, Visual Basic. Modifications to Visual basic code, Access Forms, Queries, Oracle tables, and Controls. Hired for short term; project delivered on time.
April 2004 to October 2004 – Excell Data WA, Microsoft Web Developer, Contracted to Ford Motor Co.
Redesign and implementation of the Fleet web site (http://www.fleet.ford.com) using ASP, VBScript, Visual Studio, JavaScript, CSS, XML, MS SQL Server 2000, IIS setup and configuration, and ORACLE 9i Database in a Windows networking environment. Implemented persistent cookies for security. Other tools include MS Office, PVCS, and Mercury Test Director. Includes communications with customers to define requirements, design of new applications. Instrumental in the ongoing maintenance of existing systems.
Dec. 2002 to April 2004 - Independent Consultant
•Web development, design, requirement gathering, and programming for various small businesses and individuals using NetObjects Fusion, Dreamweaver, Fireworks, and Visual Basic 6.0. Development performed in Windows 2000 and Windows XP environments.
•Peer–to-peer networking/Windows 2000 Server/2000 Pro/XP/9x setup and configuration providing connectivity to multiple computers and the internet. Setup and configuration of wireless routers, DSL and Cable modems. Support, setup and configuration of desktop systems, networks, firewalls, email clients, etc.
•Desktop maintenance and repair
Oct. 2002 to Dec. 2002. InfoLab, Ann Arbor, MI – SQL Server Database Administrator
Design and development of T-SQL stored procedures. Design of large-scale database. Created tables, indexes, constraints, and DTS packages.
June 2000 to July 2002, Access Technology Services, Ann Arbor, MI- Systems Engineer
•Design, development, and administration of SQL Server database, stored procedures, and front end database access modules.
•Demonstrated team leadership and innovation. Design, development, and enhancement of web based systems and database using HTML, XML, ASP, VBScript, Visual Basic/COM, C++, JavaScript, MS Interdev, MS SQL Server/ADO, Database Design/Admin, Cybercash e-commerce software. Systems developed on NT network using IIS Web Server. Sites include im3.imagemaker360.com, www.imagemaker360.com, www.atechservice.com.
•Conceived, designed, and developed Downloadable virtual tours to client desktops using Visual Basic/COM.
•Conceived, designed, and developed Auto-Posting (automating posting of customer’s virtual tours to desired sites with customer-specific information) reducing programmer development time from days to minutes for individual customers in about 80% of the cases. Drastic savings of programming time were realized.
•Conceived, designed, and implemented development methodology, test procedures, and version control for IT department which was non-existent. This increased reliability of systems, reduced errors propagated to production, increased IT staff productivity.
•Developed Multimedia presentations and active web content using Macromedia Director 8 Shockwaves Studio, Flash, Adobe Photoshop/Imageready, and SoundForge Audio Editor for training of customers.
•Web design/layout using Dreamweaver and Photoshop.
•Worked closely with customers and upper management in the resolution of problems and customer service.
•Designed and developed Downloadable Virtual Tours from im3.imageker360.com, enhancing the company’s product web-site and usability to customers.
•Innovation, design, and development of editable customer-specific email notifications with imbedded variable information. This allowed customer support to define different email content and format to meet varying needs saving hours of valuable IT staff time and money.
Nov. 1998 to June 2000 - Consultant
Worked as an independent consultant in Web design and development using C, Visual Basic, HTML, ASP/VBScript, and JavaScript. Some work in Delphi using MS SQL Server in an NT environment.
May 1995 to Nov. 1998, Sirco Associates contracted to Detroit Edison - Programmer/Analyst
•Learned all the below skills for web development with no experience. They handed me a server and said: “Do it.” I did it.
•Web application to allow police and fire to report power problems via the Web using HTML, ASP, IIS server (installed and configured), MS Jscript, VBScript, some Oracle PL/SQL and Designer 2000, Some (2 months) Oracle database. System developed in a Windows/NT environment.
•Real-time, client server telephony system using Microsoft Access, Visual Basic, DECVoice, DECVoice Builder, ACMS, DECForms, DECTrace, ORACLE/RDB SQL and SQL Module Language. Design, normalization, and implementation of new database. System developed in C for twenty eight front end Voice response units (VAX) and two back end database server nodes.
•Design and development of an application to simulate the load on back ends during an actual storm and various other applications.
•Developed database and user applications using MS Access, Visual Basic and ODBC connections to ORACLE/RDB. Documentation written in Microsoft Word.
•Developed ‘Nearest Customer Office’ application for Edison’s telephony system. Application was commended for excellence and reliability.
•Drastically increased up time of system during storm outages. Achieved goals of 40,000 calls/hour.
February 1995 to April 1995, ServoTest Systems, Inc. - Programmer
Real-time control/data acquisition system for Hydraulic test rigs in PC environment, PC’s networked with VAX Station and DEC Alpha via Ethernet. Physical and software configuration of Ethernet network using DEC Pathworks. Software development using Microsoft C, C++, and some assembler. Physical setting up of hydraulic test systems.
August 1990 to February 1995, CDI Computer Services - Programmer/Analyst
April 1992 to February 1995 on contract to Ford Motor Co. Analysis, design, and/or development of various software systems, Experience includes:
•Design, creation, and administration of remote VAX RDB database to be accessed in client/server environment from UNIX nodes via SQL/Services. Defined database security, and transaction scope. Developed library routines in C++ to remotely access data.
•Gathering of user requirements, analysis, and design of Engineering Analysis system to perform statistical comparison of real-time and simulated data. Developed mathematical orthogonal error band paradigm for data comparison. System implemented in C on VAXStation 4000 under DECWindows/Motif. Wrote system documentation using DECWrite and VAX Document.
•Design and development of portable message utility to be used in multi-platform environment. Written in C for VMS and UNIX.
•Design and development of a language parser/compiler to produce stimulus files used in the generation of simulated EEC (Electronic Engine Control) module signals for real-time testing of EEC software. Developed using C for VMS and UNIX.
•Responsible for the enhancement of Data analysis system providing statistical analysis on emissions data for Powertrain engineers using VAX FORTRAN, SMG, RS1, RDB, DECForms, MMS, and CMS. Automation of system maintenance tasks.
August 1990 to April 1992 contracted to Digital Equipment Corp. Analysis, design, and development of high speed, real-time, data acquisition system for Powertrain system analysis for Ford Motor Co. Experience includes:
•Design and development of customized memory-resident database and database primitives.
•Design and development of mathematical routines, graph plotting package, and various functions to manipulate data at run time.
•Development of run time scripts and modifications to script processor (We developed our own script language for test engineers to design custom tests).
•Design and development of custom editors, Generic file editor, and various tools to dynamically manipulate data at run time.
•Set up communications to emulate PC on DEC Workstations to remotely run on board diagnostic software and automatically initiate emulated PC (Soft PC) from run-time scripts.
•Provided system and user documentation using VAX Document.
•Designed and taught training classes.
System implemented using DECWindows, VAX FORTRAN, FDL, FMS, Labstar/GKS, CMS, and other VMS utilities. System implemented on MicroVAX 3900 networked with VAXStation 3100’s via Ethernet/DECnet.
October 1988 to August 1990. Compuware Corp.
November 1989 to August 1990 on contract to Rouge Steel. Responsible for the enhancement and maintenance of a real-time Level II process control system in a CIM environment for the manufacturing of specialty grades of steel. Duties include the analysis, design, and implementation of enhancements. System implemented on a MicroVAX 3500 using VAX FORTRAN, Assembler, various VMS utilities. Experience includes:
•PLC communications via. Reliance Automate LAN. Modified communications drivers.
•Communications with peripheral and laboratory equipment via. Sytek Broadband LAN.
•Inter-process communications and synchronization in VAX/VMS. Mathematical models for process guidance.
•RS1 for statistical process. Custom form package.
•Some system management and hardware maintenance duties where required.
October 1989, assisted in debugging a factory floor system to display and modify engineering drawings and production plans using COBOL and Knowledgebuild (4GL).
October 1988 to September 1989 contracted to Digital Equipment Corp. Duties include the development and installation of a factory floor data collection system for Williams International, a manufacturer of cruise missile engines. Experience includes:
•Design and normalization of relational database. Design and development of software modules.
•Developed barcode application
•System implemented using Knowledgebuild, VAX COBOL, IDMS/SQL relational database, and FMS in a VAX/VMS environment.
•Assisted in installation of system at customer site. Security clearance required. Several contract renewals.
Aug. 1988 to October 1988. Epcom Corp.
Aug. 1988 to Oct. 1988, development of a real-time force monitoring system using Microsoft C on IBM PC’s. Developed low-level C code to interface with the force monitoring card, the A/D converter, and to create screens. Priced, bought, and installed software on PC’s.
Jun. 1988 to Aug. 1988 Epcom Corp. contracted to Digital Equipment Corp.
Developed Insurance Tracking system using VAX COBOL, DBMS (Network model database), TDMS.
SUMMARY
I have 27 years of varied professional experience in all phases of the software life cycle including several years in Engineering, real-time process control, and shop floor applications plus 8 to 9 years of IT experience in the development of Internet/Web/Distributed technologies and Client Server technologies in a Microsoft environment.
I have extensive experience in MS SQL, VAX (ORACLE)/RDB (including design, database creation, and tuning) plus development and design experience in ORACLE. I am a motivated self starter with strong problem solving, analytical, interpersonal, communication, presentation and testing skills.
Contact this candidate