William (Bill) Myers Professional Experience

Graduated from Rose-Hulman Institute of Technology

Professional certifications: MCSD, MCSP, CSP, CTM


User Impact Business Areas Supported Responsibilities Technical ExperienceTraining

"You don't meet any of our requirements, but I can give you five minutes." I thought that this was only a line for movies, but in five minutes I convinced the personnel manager to grant a full interview. I didn't meet ANY of the advertised requirements! I got the job because I demonstrated that I could apply my experience to their job and learn what I needed to know.
I look for similarities between what I already know and what is required.
Example of a Recent Project:
The vendor told the our management that the "normal" time for programming the extracts to upload to the web site was two weeks. We sent our first test files in two days. The scheduled extract, web triggered extract, the web site to maintain the support tables and display the audit trail was in production in 8 work days, w/o overtime. Quote from the vendor: "No company had ever been able to put this process into production that fast".


User Impact: I put myself in the user's place when designing systems. At my suggestion, systems were written or functions added to systems under construction that had a major impact on the organization, such as:

  • trade confirmations - first phase in production 8 days from start,
  • web based trading system - first phase in production 20 days from start,
  • revising invoice layout and content (eliminated customer complaints),
  • premium analysis ($4,000,000+ potential savings to GM),
  • response time (screen turnaround from 2 minutes to 3 seconds),
  • triggered product price changes (profit increased $2,000,000 per year),
  • reduced scrap,
  • prevented product recalls,
  • 80% reduction in union grievances,
  • increase in employee suggestions, etc.

Users usually benefit from numerous unprojected benefits. Small projects can have a huge impact. I recently suggested and wrote an Excel macro that eliminated double keying tens of thousands of accounting entries per month. I worked about 4 hours on the macro.


Responsibilities Held: I am primarily a systems developer who has other responsibilities that sometimes require unrelated skills.
  • Project leader and system development for 71 systems (propose, design, database design (dba), program, testing, document, prepare manuals, implement, support),
  • Audits,
  • Prepared budgets,
  • Prepared and distributed billings,
  • Wrote standards and procedures,
  • Researched and developed new techniques,
  • Site Coordinator (hundreds of users),
  • Help Desk 2nd tier expert support,
  • Developed training courses,
  • Instructor,
  • Technical training for new employees.

Responsibilities include development and support of trading, credit risk and web based systems, plus providing technical assistance in areas of expertise. Current software used includes asp, asp.net, other web tools, Oracle, PL/SQL, SQL Server, WebFocus, MS Access, Excel, Visual Basic, Visual Basic for Applications, HTML, plus other Microsoft programs.


Areas of Business Supported:

It's surprising how many concepts and techniques transfer from one line of business to another and the number of appearantly different tasks that have similar processes.

  • Trading - Power and Gas,
  • Credit Risk,
  • Confirmations,
  • SOX,
  • Accounting/Settlements,
  • Cost Accounting,
  • Internal Billing,
  • Data Analysis and Auditing,
  • Contract Proposals,
  • Engineering,
  • Forecasting,
  • Information Center,
  • Insurance,
  • Invoices,
  • Manufacturing (tracking systems, quality control),
  • Blueprint Library,
  • Personnel,
  • Training,
  • Phone Book & Yellow Pages
  • Newsletters.

Technical Experience Developing systems using:
  • Oracle and PL/SQL,
  • ASP, ASP.NET and VB.NET,
  • SQL Server (certification),
  • MS Access (certification),
  • Excel (certification),
  • Visual Basic for Applications (certification),
  • FOCUS and WebFocus,
  • Windows,
  • Lotus Notes,
  • Databases (relational, network and hierarchical),
  • GUI and Web interfaces,
  • Batch processing,
  • MS Word,
  • Novell and NT LAN's,
  • SQL,
  • FORTRAN, COBOL, PL/1, BASIC,
  • Online processing,
  • IBM PC's and mainframes,
  • Mainframes,
  • MVS and VM/CMS,
  • distributed systems with coordinated outlying and central databases.

Training:

  • Power Trading 101
  • UML conference 2004
  • asp.net
  • Attended Agile conference 03, presented at SUMMIT 2004 at New Orleans,
  • Attended Microsoft TechEd'94, TechEd'95 and TechEd'96, VB & Access'98
  • JAVA World Wide Tour,
  • Deming Quality course,
  • Tom Peters seminars,
  • PowerPoint,
  • Presentation Techniques,
  • Microsoft's Mastering series - Visual Basic,
  • Books (dozens), latest HTML and JavaScript programming.

  • CASE tools,
  • Object modeling tool OMT,
  • ORACLE and ORACLE Forms,
  • Microsoft Mastering Series - Application Design, Visual Basic
  • EDS Basic Leadership,
  • Project Management,
  • Extended Relational Analysis.

Most knowledge has been obtained through self training using manuals and books (I actually read these from cover to cover). It is easier to find things in a help file if one is first aware of what can be done.

Of course, Google is one of the most important developer tools.

 


My customer once asked that my employer increase my billing rate instead of asking for a discount.

Return to Home Page

1997-2015 William W. Myers All rights reserved.
Please direct comments or questions to: myersww@att.net