William F. Meng
8902 Sharon Rd                                                                                                                                            
marasys@earthlink.net
Newburgh IN 47630

Summary
A well organized analyst and former programmer with a knack for numbers and experience in fast paced environments where multitasking and customer service is the norm. His experience with databases and graphics, as a developer, manager and analyst gives him a unique perspective into the art of automating reporting and analysis.
Additional expertise includes: specifications writing, solution development, and implementation planning over the entire SDLC, business analysis, requirements analysis and business process improvement, including work process/work flow analysis, functional requirements analysis, object oriented design, engineering/reengineering, systems analysis, systems engineering, software engineering, documentation, client server/mainframe/legacy systems conversion, project/product management, planning, application design, etc.

DATA ANALYSIS: Correlation analysis, binomial distribution, percentiles, standard deviation, rankings, trend analysis, spherical gridding, least squares, 5th order polynomials.

PM METHODOLOGIES: SDLC, Phased Approach, Waterfall, Prototype
APPLICATION AREAS: Accounting, Decision Support, Distribution, Engineering, Finance, Graphics, Inventory, OLAP, Real Time, Sales, Scheduling, CRM, ERP
SYSTEM ENGINEERING: Modeling and Simulation, Interface Design, V&V, Functional Analysis, Requirements elicitation, analysis and management, Volere
SOFTWARE ENGINEERING: Structured Analysis, Structured Design, Object Oriented Analysis, Object Oriented Design, Object Oriented Development
DATABASES: Oracle, Access, R:Base, Revelation, ODBC, multi-dimensional, star schema, data warehouses, data mart, data mining, data analysis, data modeling, DFD, ERD, ODBC, SQL, PL/SQL, stored Procedures, triggers, SQL *Plus, Oracle Navigator, TOAD
DESKTOP OS: DOS, Windows 2000/98/95
DESKTOP SOFTWARE: Visio, Rational Rose, MS Office, MS Project, P+, Corel Draw, Corel Paint, DTP, ErWin, SQL *Plus, Oracle Enterprise Navigator
SERVER OS:
Windows XP/2000/NT, UNIX, MVS,VM
LANGUAGES: Visual Basic, VBA, QuickBasic, FORTRAN, PL/1, PL/M, C, C++, VBA, ADO, RDO, COM
OTHER:
Extensive customer service, support and pre-sales experience. Over fifteen years at customer facilities. Training of technical personnel in classroom environment as well as informal training in workplace environment. Documents written include business plans, specs, user manuals, technical illustrations and technical documentation.

Experience

US Geological Survey(Federal Government) Rolla MO 5/07-present Database Developer
Working with users to define workflow process, then develop a workflow/database/archive application while evaluating suitable COTS. Website development for a contract management system using Oracle 10g, Application Express, TOAD, originally developed in a client-server environment. Required understanding of various data models, sources of information and the process of entering data from existing paperwork. Also mentored junior programmer.

Mead Johnson (Pharmaceutical) Evansville IN 2/06-6/06 Contract Programmer
Working with Business Analysts, enhancing call center applications involving file transfers to external databases and GUI modifications, using Clarify, Oracle, PL/SQL, Unix and Windows.

Accenture (Energy distribution and management) Folsom CA 11/05-12/05 Contract Developer
Working at CAISO, I met with users to determine requirements and developed a test data generation tool, using Excel/VBA which extracted data from an Oracle database, manipulated the data, and generated output for Quick Test Pro to test web browser and the backend application.

Marasys Inc. (Engineering, Software) Hayden ID 2001-05 Product Manager, Consultant

  • Using TC2000 I developed several technical analysis strategies to improve swing trading profitability in stock trading, with the goal of a one percent profit per day.
  • Analysis, design and development of a personal accounting system using Excel, macros and VBA.
  • Analysis, design and development of an Excel modeling tool for cash flow of a startup business using macros and VBA.
  • Database application development of a dynamic scheduling algorithm for use in a job shop where scheduling involves mating manpower and machines in a specific sequence, using ORACLE, SQL *Plus and PL/SQL stored procedures developing use cases, process and data models and generating data to prove the model
  • Data mining applicatin development using relational and dimensional(star) modeling, mining at levels ranging from SKU to various departments. Using Oracle, SQL *Plus and PL/SQL, developing stored procedures to optimize matching SKUs and track higher level dimensions.
  • Data modeling and development of several desktop databases using Access as baselines for project bidding
  • Market research, concept and prototype development of a remotely controlled consumer product employing the stage-gate process. Design tools included Corel Draw and TurboCAD.
  • Concept and product development and marketing research of a mechanical hand tool utilizing the stage-gate process, surveys and focus groups. Design tools included Corel Draw and TurboCAD.
  • Requirements gathering, data modeling and design for a pension planning database driven web application employing Visio, Rational Rose, SQL Server, UML and XML. I designed a process, a concept of operation and web forms for web users to log in to the company website, update their company data in the online database and generate planning schedules using a proprietary Excel spreadsheet.

Sprint PCS (Wireless Telecomm) Overland Park KS 6/00-12/00 Contract Business Analyst
As a member of a requirements team, gathering requirements and data modeling for the data warehouse department of IT, building data marts for internal organizations. The specific tasks included meeting with end users and IT managers to develop data warehouse reporting requirements, data mapping, writing of requirements documents using Excel, Word, and VISIO, and discussions with developers and data systems personnel to determine schedules and design feasibility, and obtaining user signoffs. Systems involved were UNIX servers, ORACLE, SQL *Plus, NT Network, and Windows 95 PCs.

Summit Information Systems (Financial) Corvallis OR 2000 Contract Programmer/Analyst
I was a member of a team debugging and making enhancements to all aspects of a 3 tier financial software package for loan origination and teller functions for credit unions using Visual Basic.

Varco-Pruden (Manufacturing) Memphis TN 1998-99 Contract Programmer
Conversion of a Unix/Oracle/SQL Forms based production control system to Windows NT/Oracle/Visual Basic. I designed & modified 50 programs using Sheridan and Apex add-ins with RDOs and ODBC, converting SQL queries and designing GUIs to maintain a consistent look and feel across all programs, while using SQL *Plus to create and maintain test data.

Software Innovators Inc. (Consulting) Little Rock AR 1998 Contract Project Coordinator
Tracking the progress of 10 programmers performing Y2K remediation on 500 programs for a health insurance company. Using MS Project consolidating projects & exporting data to Excel for graphics generation in reports to client

Marasys Inc. (Consulting) Coeur d'Alene ID 1/97-3/98 Product Developer
As Product Developer, I gathered requirements from potential end users, and using Visual Basic and Access I developed a prototype scheduling package for non-profit organizations gathering requirements from use cases, performing OO design (DFD, ERD), GUI design, process and data modeling with Erwin(IDEF0, IDEF1).

Semitool Inc.(Semiconductor Equipment) Kalispell MT 1995-1996 Software Engineer
Responsible for the development and worldwide installation and maintenance of software for the company's products at major semiconductor companies, reducing their costs. Responsibilities included systems integration, integration testing and stress testing of furnace software with client-server systems and products. Position involved extensive travel to customer sites, working with other customers and other vendors.

Marasys Inc. (Software) Los Gatos CA, Coeur d'Alene ID 1990-95 Product Manager
I founded the company to develop and publish Colorcube, an OLAP data visualization tool using color to highlight data, useful to quickly analyze data. As Founder and Product Manager I performed the following functions:

Product conception & definition Corporate Model Distribution Channel
Requirements Gathering Corporate Management Product change management
Product development Business Model Version control
Market Analysis Business Plan development Personnel
Risk Analysis IP strategy Product Packaging

United Technologies (Aerospace) San Jose CA 1988-1989 Contract DBA
Developing and maintaining networked relational databases using Revelation and Advanced Revelation (SQL) for the QA department. Designing and developing a workflow management system using Advanced Revelation, re-engineering the process model and data modeling for the redesigned database while installing and maintaining Novell Netware.

Marathon Systems (Consulting) Campbell CA 1982-88 Consultant
Consulting with various companies in Silicon Valley, my analysis, design and development projects included:

  • A technical analysis system for stocks and derivatives based on the Apple II for an investment advisor.
  • Data Analyst for GE Nuclear, loading engineering data into the data base for a nuclear power plant
  • Developing an early OLAP tool as an enhancement to a minicomputer-based application for an electrical distributor.
 Prior Employment

GCA Corporation (Semiconductor equipment) Sunnyvale CA 1981-82 Senior Systems Analyst Real-time software and user interface development for company's product line
Lockheed Missiles & Space Corp.(Aerospace) Sunnyvale CA 1980-81 Programmer/Analyst/Project Leader Maintenance of graphics and project management software, requirements gathering and database design (HIPO, WBS) for a distributed requirements tracking and project management system.
Calspan Field Services Inc. (Government contracting) Arlington VA 1978-79 Systems Analyst Requirements gathering, macro analysis, data modeling and conversion planning for an upgrade of the Defense Intelligence Agencys IT department.
General Electric (Aerospace) Valley Forge PA 1974-78 Systems Engineer/Planner, Senior Programmer/Project Leader
As an operations planner in a near real-time satellite ground station, planning, performance monitoring and reporting on daily and long range activities in a major government run intelligence gathering system.
ERP like GIS/cartographic/scheduling software development for the intelligence community

Education

BA Mathematics, Economics minor Southern Illinois University, Edwardsville Ill.
Software Course University of California, Berkeley Ca.
Business Courses University of Pennsylvania, Philadelphia Pa.
Business Courses Carnegie Mellon University, Pittsburgh Pa.

Member number:1388
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 1999 Software Contractors' Guild, Post Office Box 257,Nottingham, NH USA 03290-0257