|
|
|
|
Blog
Your Categories
Job Search Skills Recommendations
Recommendations
Dan supervised a team of three and played a leading role in designing, developing and enhancing very large mail and email marketing databases for a number of our clients. This work ranged from moderately to extremely complex. For example, one client system comprised over 2,000 individual programs, over 500 jobstreams, and over 750 files. Dan performed this work to the highest standards, usually meeting or beating goals despite changeable client specifications and often very short lead times. Dan was effectively both a technician and a business analyst, able to communicate well with both non‑technical clients and software developers. Dan is a quick learner and an excellent problem solver. He was a principled, valued employee of this company. I particularly recommend Dan for work requiring analysis, attention to detail and creative problem‑solving.
|
Skills
Made processes more efficient:
- Enhanced the string manipulation and array handling in an Upper/Lower case utility to change it from an overnight utility to one that could be accomplished in hours, or less.
- Developed a utility to make standard menu options utilized by production staff automated and repetative, driven by a parameter file containing options for the various elements.
System Monitorying / Notification tools:
- Developed a utility to periodically scan the system display of jobs to look for those needing attention and taking appropriate action, including emailing and text messaging appropriate personnel.
- Developed a report to monitor for files that may reach maximum capacity.
Conversion of printed reports:
- Created a utility to convert reports (spool files) to emails with variable parameters.
Data Visibility / Cleansing:
- Developed a variable / customizable File Statistics report with numerous options for report on the contents of files field by field.
- Developed a variable / customizable file data checking utility to verify data against pre-defined acceptable ranges and/or values.
- Enhanced a custom in-house developed utility for scrubbing data using pre-defined options. This utility reported on and/or repaired various data issues with address, name, postal and email fields.
- Developed custom ETL processes to import divergent data into standardized transactions for database update.
Many more not yet documented...
Direct Marketing & Fulfillment systems:
This included managing Direct Marketing databases doing address standardization, updates from various divergent sources, fulfilling consumer requests for literature and creating marketing lists, email blasts and lasering or inkjetting marketing materials.
Client Industries included those in Travel, Tourism, Software, Financial and Gaming.
Real Estate Information:
This involved the consolidation of Property, Sales and Title information from vaious business and government agencies into databases. Products in various media where created with this data including Microfiche, CD Rom and printed reports and/or mailing labels.
Clients were Title companies, Real Estate agencies, Insurance and any others with a need for property information.
I have programmerd in COBOL on various platforms.
My most recent experience is with COBOL/400 on an iSeries (AS400) with both OPM and ILE COBOL.
Previously I programmed in Pro*COBOL with embedded SQL accessing an Oracle database. This was on a VAX/VMS platform.
I also worked briefly, on an internship, on a IBM 4341 Mainframe system in COBOL with CMS. (and also in Fortran).
I also have a little experience with Realia COBOL in a PC environment.
My past 13 years of development have been on an iSeries platform.
Software I have developed on this platform has been in COBOL (OPM and ILE), Query/400 and CLP.
I am also skilled with various utilities on the platform like PK/400, Mailtool and Group-1 postal software; and integrating them with various applications.
I have created various systems level tools for the iSeries; including Job Schedulers; Data checkers, scrubbers and statistics reports; job MSGW monitors with email and text messaging notifications; process watchdog that watches for when something does not happen; and custom sign-on screens. In creating these I've used DDM, System API's, IFS, Data Areas (*DTAARA) and custom code in CLP, COBOL and Query/400.
I am experienced with Screen Design Aid (SDA) for simple table maintenance applications to full blow multi-file database views. I have also done many Data File Utility (DFU) screens.
I had worked with Oracle versions 6 and 7 (including a version upgrade!) for 8 years.
I did various data/table maintenance and updates and reporting/product upates in the Real Estate Information industry using SQL and Pro*COBOL with embedded SQL.
I also had some training as an Oracle DBA.
Job Search
I was laid off in September 2009, so I am now available for new opportunities in iSeries Development, COBOL Programming, Business Analyst, Direct Marketing and/or Database Development/Administration.
Please contact me if you feel I would be a good fit for your organization!
I've worked with a good team of people in my current position over the last 13 years and would like to find another organization and people just like it.