Alan Jordan
Microsoft Certified Professional
(775) 338-7574

To minimize spam, please type the following address into your email:

Thank you.

• Regular Expressions
• XML for .Net Developers

• Sarbanes-Oxley Information
• Business Process Management
• Links to Useful Resources
• Information on Wireless
• Information on RFID

Productivity and Cost Reduction Success Stories:

• Developed and enhanced a variety of "COM objects" that are used by Group One, LLC to enable electronic trading of stock options on the Pacific, Chicago, Philadelphia and AMEX Exchanges. The system enabled traders to make trades within 5-10 seconds instead of 1-2 minutes. In addition to eliminating the need for support “runners” the system allowed traders to make more trades and helped to build client loyalty. Also, it prevented the loss of clients who would otherwise migrate to firms that had electronic trading.
  
• Created pallet configuration spreadsheets for Intuit’s salespeople to use when they visited major accounts like Sam’s Club and the procedures for uploading these into a database where the information was consolidated and reported, with the result being that the production of the right mix of Turbo Tax, Quicken and various other products could be properly planned. Internal estimates calculated over at over $1Million of sales gained by optimum configuration of pallets.
  
• Developed PSD Metrics Generator: Used Brio Query to extract information via ODBC from a FIREMAN Red Brick regional database in Singapore and massage the database within Access 97 for Hewlett Packard. Developed sophisticated queries in Brio Query (similar to Business Objects) and used Brio Executive Information System (EIS) tabs to automate the charting of Access 97-processed data. Senior management used this system to eliminate $570,000 in unnecessary labor for service calls, parts ordering and shipping.
  
• Full Lifecycle development of a Commissions Calculations program for the executives of Remedy Corporation using Access 2000, enabling the private and rapid calculation of sales-based bonuses, thereby motivating sales managers to meet and exceed their quotas.
  
• Created a story board using Power Point for Trigon Blue Cross & Blue Shield that allowed management to preview the screens that would be presented to users in a new producer compensation system. As a result, changes were made early on that precluded six developers working for six to eight weeks unnecessarily, an estimated savings of $126,000.
  
• Extracted Workmen’s Compensation claims data from a California Casualty mainframe program, massaged the data and distributed it to a customer, enabling California Casualty to keep a major account from switching to the competition.
  
• Updated a tool that assisted with creating of a program that helped in the consolidation of credit risk information when Wells Fargo and Norwest merged, enabling the proper analysis of risk, and avoiding contingent losses of $15 to $20 million that would have been caused by extending too much credit to particular customers.
  
• Extracted rules from legacy code used to calculate and distribute producer compensation, for preparation of a centralized flexible component based system for Trigon Blue Cross & Blue Shield. Helped to design a tool to automate extraction of business rules from COBOL code. This saved over 1,500 man hours in developer time.
  
• Used Brio and Apple Script to extract information from an Oracle database for Apple Computer, and place it into master Excel spreadsheets that were used to track Y2K compliance and remediation. Used VBA to filter the data for each Functional Team Leaders (FTL), produce individual Excel Spreadsheets and distribute these to each FTL’s folder on a Local Area Network. Without this support, many of the Y2K bugs would not have been fixed, and there would have been gross customer dissatisfaction.
  
• Coordinated three off-shore teams of programmers who are developing components (DLLS, OCXs) in Visual Basic and Access with the end result of producing custom databases and web sites at a savings of over $125,000 as compared to in-house development for clients.
  
• Developed an Electronic Contract program for Hewlett-Packard that uses VB 5.0 with Active Data Objects (ADO), Access 97, Excel 97, and API calls to GEM32.DLL, HP-proprietary middleware, to produce an Electronic Contract in Excel 97. Significant labor savings were realized because contract preparation time was reduced by 90%.
  
• Coordinated a team of four people (two off-site) that allows users to track properties, loans, and collateral for transactions in Japan for GMAC Commercial Mortgage - This program provides a clear understanding of risks, thereby avoiding the assumption of loans that were unlikely to be repaid. It also identifies the best exit strategy for various loans precluding tens of millions of dollars of write offs in cases of potential default.
  
• Converted 250,000 Word Perfect Documents to Word-For-Windows documents so Dade-Behring could comply with Federal Regulations and continue to receive $20,000,000 in government contracts. Without this process, it would have taken between two and five man years to open each document copy it to the new program, assure that all of the graphics, and special characters retained integrity when the conversion was made and contracts would have been lost for non-compliance. (Some of the graphics and fonts would change, and this could provide misinformation that can not be tolerated.)
  
• Provided backup production support and maintenance programming for VISA International to support Citibank’s needs for an electronic bill payment system. Developed turnkey back up and restore program using a combination of DOS and Wise Install Program for an electronic-payment system that uses 32 separate executables. Developed a comprehensive installation kit for applications under Windows for Workgroups and Windows NT 4.0. Converted Crystal Reports to ASCII reports.
  
• Developed a tool to computerize the Change Management process DecisionOne (formerly Bell Atlantic Business Systems) sold to General Electric Nuclear Division. Supervised a team of four. The program uses a Change Evaluation Calculator to assess risks associated with a proposed change, saving over $450,000 in inappropriate hardware and software implementations.
  
• Full Lifecycle development of a tool that allows managers to compare tables that were downloaded and massaged before uploading to the mainframe for Cahners Business Information. The application facilitates checking on a record-by-record and column-by-column basis and saved six people 20 hours a week in data-schema verification procedures. As these people were used in other capacities, it is realistic to say that $150,000 was saved.

Marketing & Sales Success Stories:

• Grew Add-Effect Associates, Inc. from $300,000 to $2,000,000 plus by writing trade books that were sold by direct mail to corporations at an average price of $99 and selling consulting services to Fortune 1000 companies that purchased these books and attended seminars that presented the material in the books.
  
• Generated $400,000+ in additional annual premium for Occidental Life Insurance (now Transamerica Life) by revising the business-to-business telemarketing presentations and implementing procedures that eliminated 16-19 minutes of “hold time” per hour for agents.
  
• Sold computer maintenance contracts of $20,000+, software and computer maintenance for this $13 Million branch office of Sears Business Services. Achieved 175% of quota. Developed telemarketing lead-generation approach that created a flow of leads for over 40 salespeople and resulted in $5,700,000 in additional service contract sales over a 2 year period.