William F. Meng
8902 Sharon Rd
marasys@earthlink.net
Newburgh IN 47630
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
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:
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.