Bill is an experienced project/team lead, system & software architect, and network security designer with 19+ years of systems experience.  His industry experience includes retail and institutional inventory management, online mall and store creation and administration, insurance, pharmacy management & processing, chemical manufacturing, retail loan processing, media advertising, high-volume paper processing, oil/gas, and telecommunications.  He has experience with large custom development using both iterative and waterfall methodologies.

Technical Skills

Languages: Java, Perl, Objective-C, Pascal, Ruby, Ruby on Rails, PHP, SQL, C/C++, RPG/400, SYNON, JavaScript, VBScript, Visual Basic, AppleScript

Databases: MS SQL Server (w/DTS, stored procedures), MySQL, DB2, Core Data, Oracle, MS Access

Methodologies: Scrum, FDD (Feature Driven Development), XP, RUP (Unified Process), Waterfall, Architected Solutions (Arthur Andersen), Crystal Method

Networking: TCP/IP, Virtualization, network design including redundancy, load balancing and failover techniques, CISCO ACL router programming

Security: Firewall & security design and implementation (primarily with Check Point FireWall-1), iptables, ipchains

Operating Systems: Mac OS X, OS/400, Unix/Linux (Red Hat/Fedora, Ubuntu, Solaris, Free BSD), Windows Server, 2000, XP, 95/98

Project Management Tools:  MS Project, Basecamp, Omni Plan, Project Office

Graphics Tools: Omni Graffle, Visio, Photoshop

Professional Experience

An Ohio-Based Regional Consulting Company

Senior Architect

September 2002 – Present

Served as Lead Data Architect for a global Salesforce.com rollout (North and South America, Asia, and Europe).  This project was the first prioritized project to come from the Enterprise Architecture initiative mentioned below.  Responsibilities included: gathering data requirements from each of the eight (8) data sources that were to be converted, mapping the data requirements to the functional requirements, mapping elements from each origin source to the Salesforce.com data model, and performing the migrations.  In addition coordinating de-duplication efforts with Dun & Bradstreet and negotiating the global contract process for additional data cleansing tools to be used once the migrations occurred in each region.  The data team consisted of four (4) people working in remote locations.

Performed as project lead for an Enterprise-wide data cleanliness strategy for a $700MM software development company.  This project included examining the issues with primarily Customer and Product data across all departmental units, where data was shared as well as the islands and silos where it was not.  Recommendations from this initiative included: appointment of a Data “Czar” as well as a team of stewards whose primary responsibilities were to coordinate data cleansing across all applications and contexts within the company and to establish ownership of basic data entities such as Customer, Product, and Employee.  Additionally, investment in a data hub technology was recommended to enforce the policies set forth by the stewardship team.

Built a Ruby application using the Twitter API that facilitates timesheet and expense entry via remote locations utilizing whatever mobile device the user may have.  The application is a proof-of-concept for other methods of internal information access from disparately located resources.

Built the technical portion of an Enterprise Architecture process for a $700MM software development company that helped their IT department visualize and prioritize projects against a 12-36 month roadmap.  The role included investigating the business needs of the 15 departmental units and correlating those needs into coherent project streams to be acted upon in an Enterprise manner.  Additionally, all technology usage was mapped from an application, data, and infrastructure perspective to find where systems were unknowingly linked, thus dependent upon changes each of the departmental units wanted to undertake.  Cost, resource, and execution plans were put together for the prioritized projects as well as a governing process to continue bi-annual execution of the Enterprise Architecture.

Designed and developed a web-based information repository and data access tool using PHP, MySQL, and SQL Server to query and modify census information from the Marketing Data Warehouse for LexisNexis.  The system has access to over 15 million records across 75 tables and is integrated with the departmental wiki to provide user and technical documentation.

Developed a data migration and data management solution based in perl for a large legal information provider.  The series of programs combined data from multiple sources and multiple databases (SAS, Teradata, and SQL Server), scrubbed the content, then homogenized the output into a single Census data warehouse for the purposes of reducing mailing errors and providing a cleaner and more accurate repository for the company’s marketing functions.  The perl effort also included the creation of common functions that will also support the next phase of the project which will incorporate web access to the Census data.

Brought formalized procedures, processes, and discipline to the Marketing Information & Analytics department within a Dayton-based information provider revolving around source code control, project management, data architecture, standards implementation, and internally focused service-level agreements (SLAs).

Established the requirements for a business continuity/disaster recovery (BC/DR) plan for a $500MM financial company located in the Midwest.  The plan including identification of critical processes, technologies, and personnel; selection of a hot-backup site, and a documentation/training regimen to keep the BC/DR plan relevant and current.  The outcome of this effort was an RFP used for the vendor selection for the partner to actually carry out the requirements.  I marshaled the vendors through process, performed an evaluation of the proposals, the made a recommendation to the executive committee as to the best fit.

Provided testing, documentation, and training for a Michigan reinsurer for a custom developed Sharepoint assessment application.  Tasks included creating and executing test scenarios, creating help text using Adobe RoboHelp, and assisting in delivering application training to the end users.

Acted as project manager for the iterative requirements gathering process for the commercial lines department of a public, Cincinnati-based insurance company.  Our charter was to gather requirements for the BOP line-of-business while mentoring the client in transforming their traditional waterfall systems process towards a more “RUP-like” set of repeatable procedures.

Arthur Andersen

Senior Manager

January 2000 – August 2002

Performed an assessment for a the data center of a large international insurance company to determine performance issues that were being experienced on their AS/400 based WebSphere applications and to compare their current practices against establish best practices for large-scale data centers.

Provided a strategy and direction to a $250MM leading, short-term loan originator for the replacement of a PICK-based legacy system in favor of a BEA WebLogic/J2EE-based architecture.  My responsibilities included the selling of the work, management of the project team and providing the technical subject matter expertise in performing the “due diligence” assessment of their current technologies as well as the high-level design for the proposed network and software infrastructure.

Successfully spearheaded the firm’s initiative to establish a global alliance between Andersen and BEA Systems.  My responsibilities were global in nature and included coordinating lead exchanges between the two companies, account mapping for joint sales efforts, driving influenced revenue goals, and acting as the firm’s BEA advocate.

Designed an Intranet architecture for a $350MM concrete construction company to allow all tasks related to construction project management to be performed from a common HTML interface. The project used SQL Server as its primary data source as well as JDEdwards data housed on an AS/400.  COM components and MTS were used to facilitate access to data and our designed API layer.

Led a project team of five (5) people in order to implement a program management office (PMO) for a Fortune 500 investment information company.  The PMO encompassed all projects related to the deployment of a new billing system for several locations nationwide.

Led the project and served as technical expert on a system assessment and recommendation for a Fortune 500 investment information company to determine their ability to offer EBPP (Electronic Bill Payment & Presentment) services to their clients.  In addition, I created the plan by which they could offer these services within their existing architecture and denoted where and how to extend their existing Open/VMS Pascal architecture to include a more open BEA/WebLogic/J2EE base.  In order to do this, I leveraged the appropriate EAI technologies and providing a common interface to the underlying heterogeneous environment by employing a portal philosophy.

Cadre Computer Resources

Assistant Vice President, Product Development

September 1994 – November 1999

Designed, developed, and implemented a full e-commerce solution using perl (with DBI/DBD extensions), Oracle, and UNIX (Solaris and Red Hat). This system was comprised of over 150,000 lines of code, 65 tables and contained the following capabilities:

Multiple merchants & multiple malls (multi-org)

User tracking and registration

Multiple and persistent shopping carts

Inventory tracking

Multi-currency & multi-lingual

Complex pricing (based on user identity, purchase volumes)

Shipping, handling, & taxes

Hooks for credit card processing using CyberCash and SkipJack

Designed and developed a simple e-commerce site to allow a local entrepreneur to sell his invention on the Internet. The web site allows customers to place and track order status. Although the site was actually simple (1 product + tax + shipping), its design allows for future growth by incorporating a transaction tracking system and order maintenance and fulfillment programs.  This is in anticipation of additional products due in 2000, as well as heavy order loads (from 10 orders/wk to 300-500 orders/week).  This site was written in perl over an Oracle database.

Migrated our company from an AS/400-centric consulting organization to an Internet security and e-commerce consulting organization by developing and executing a business plan that detailed appropriate target markets, product and service mix, marketing plans, as well as required staffing models and technology architecture.  A $500,000 investment was turned into a viable $2MM+/year business within two years.

Designed, developed, and implemented an intranet for a nationwide institutional pharmacy. The original specification was to enforce purchasing contract compliance of 130+ nationwide pharmacies.  Pharmacies would submit their purchase order to the central office for approval before sending them to the suppliers. The project included networking (Ascend w/channelized T1s for incoming data calls), Ethernet (in a traditionally Token-Ring world), UNIX (in a traditionally AS/400 world), Perl and Oracle for back-end processing, RADIUS for authentication, and HTML for the user interface. In the first12 months, the intranet received over 85,000 phone calls, transferred over 5 million purchase requests, and saved the company $2.3 million in overcharges.

Designed, developed, implemented (and actually sold a couple of copies) of an asynchronous communication package for the AS/400.  The product was able to perform XModem and YModem file transfers from PCs to the host AS/400.  Written in SYNON, it included a custom-built, interpretive scripting language complete with symbol tables, static and dynamic variables, conditional processing, and a document management system to be able to store, receive, send and process files on a schedule determined by the user.  The product was primarily used for communicating with state Medicaids and insurance companies for claims payments.

Designed, developed and deployed the master file maintenance, data distribution, order fulfillment, and billing communication modules of Omnicare’s OASIS pharmacy management system.  All work was done in SYNON and at one time, held the distinction as the largest SYNON RPG model ever constructed (over 8 million lines of code).

American Exploration

Senior Analyst

May 1993 – May 1994

Designed and wrote an oil/gas well ownership and land management program for the AS/400 to determine which entities owned the various different levels of an oil/gas well so that appropriate compensation could be given.

Used Paradox to build a program for tracking well locations and productivity.

DuBOIS Chemical / Diversey /UniLever

Programmer; Senior Programmer; Project Manager; Team Lead

August 1988 – May 1993

Designed, developed and implemented an entire inventory system for a chemical manufacturing plant.  The system included modules for inventory (raw material and finished goods), bill of materials (w/mixing instructions), order entry, distribution, and purchasing/receiving.  The system was implemented at the Dallas location, and then replicated it at plants in New Jersey and California.  The system was originally written in dBASE III+, and then converted to Clarion.  Data translation programs of corporate mainframe data were written in Pascal and C.

Designed, developed and implemented a series of programs to calculate the air emissions of the company’s plants.  Measurements were done on particulates, non-organic compounds, and heavy metals.  The output was used for EPA reporting.

Responsible for maintaining and developing new modifications for the corporate distribution and manufacturing system on the AS/400.  Modules of responsibility included inventory, purchasing, distribution, warehouse management, and manufacturing. Maintenance work was done in RPG; new development was done in AS/SET.  All systems used the Pansophic management package.