William Riel Mendoza (Willy)
Phone Numbers:	 [Send email to request phone number] 75.5394 (cell),  [Send email to request phone number] 63.5156 (home)
Home Address:	19051 E. Orangepath Street, Glendora CA 91741
Emails:	[Send email using form at bottom] (personal)

Personal Web Page:	http://www.wmendoza.com 


Summary of Competence.
I have many years and of a SENIOR level in software development, heavy business
and system analysis skills, writing documents, many levels of testing skills,
strong documenting skills, and database design skills in the mainframe
environment. Secondly, I have a JUNIOR/INTERMEDIATE skill in
client-server-database development. I  AM OPEN TO ANY JOB OPPORTUNITY WHERE I CAN
BEST SUPPORT THE COMPANY IN ITS GROWTH. They can be roles as an Application
Developer, Database Developer, System or Business Analyst, System Liaison,
Tester, VBA Developer, Software Sales, Report and Technical Writer.

Client: Visual Studio 2005 & 2008, SQL Server Management Studio Express, C# .Net
Programming, Visual Basic 6, VB.Net, Crystal Report, Windows XP, NT, & Vista,
Microsoft Office 2003  & 2007 (Word, Excel, Access, Project, Power Point, Visio),
Macromedia MX (Dreamweaver,  Flash, Fireworks, FreeHand),  HTML, HTTP, FTP, XML,
PHP Programming. Prior skills include Java programming, C programming, C++
programming.
Databases: DB2, SQL Server 2005/2008, MySQL 5.0, SQL Server Enterprise Manager,
MS Access. Prior skills include Oracle 8, SQL, PL/SQL, MS SQL, QMF, IDMS (DB/DC,
DMLO, OLQ, Debug).
Mainframe. COBOL II, COBOL 370, Assembler 370, C, C++, CICS, DYL280, VSAM,
IDCAMS, Expediter. Prior skills include Omegamon, BMC DB2, File-Aid (Standard &
DB2), Abendaid, DataExpert, Intertest, Viasoft (SmartTest, SmartDoc, Insight),
JCLPREP, DOS/VSE, DOS, CMS, RPG III, Librarian, OS/390, Z/OS, TSO/ISPF.
 
Technical Experiances.
DataTrace	Programmer Analyst	Santa Ana, CA	January 2001 – April 2009
Analyst:
	On projects, lead or attend meeting with users and/or developers to
discuss and initiate upcoming projects, its progress, and plans for the
implementation of the project. Use of SDLC Guide.
	Talk to users to resolved issues that they encountered during the
development phase, QA test and production.
	Wrote exploratory documents, System Design & Proposal documents, and
Implementation Plan documents, DB2 & SQL Server Table Design Document. Tools uses
are VISIO, WORD, EXCEL, ACCESS, PROJECT.
Client:
	Converted DB2 to SQL Server 2005 T-SQL. Analyze, define, and convert
DB2database and tables to SQL Server. Wrote bulk-load scripts to populate the
tables. Wrote Stored Procedures, Triggers, and Functions to complement the
mainframe process.
	Wrote a reusable C# .Net Class that provides a common connection to the
SQL Server and the database.
	Wrote a reusable C# .Net Class that accepts sign-on information from
our client, match the information and create an XML response of user access
defaults from data in the SQL Server tables (utilizing its stored procedures &
functions). I also insert the sign-on information into the tables.
	Wrote a reusable C# .Net Class that accepts Change County request from
our client applications, read the SQL Server Tables (stored procedure &
functions), builds & returns an XML response about the new County.
	Maintained and operated ten (10) Visual Basic 2003 Web Scrapping window
applications that goes to Government websites and downloads the HTML documents to
extract the Title Property information, Title Owners information, Tax
Information, and Legal Document Images. Title information is stored in the My SQL
while the images are stored in a local folder. At the end of the process, the
information are formatted into data streams and distributed to the various
departments while the image are ftp-ed to department folders.
	Wrote a Visual Basic 6.0 Windows application that consolidated many
in-house client support applications. It’s able to build & send HTTP request with
XML document to the mainframe & accept an XML response or HTML response. It’s
able to retrieve & show the files from an ftp server, build new broadcast message
in HTML, and post it in the ftp server. It’s able to connect to various websites
for research.
	Wrote a Monitor Server Web application that HTTP request to the
mainframe and receives an HTML document to show. Wrote the mainframe application
to wrap HTML response document with javascript.
	Developed a MS Access with VBA codes for an inventory of applications,
their relationships to one another, the systems where to execute.
Mainframe (COBOL/CICS/DB2/ASSEMBLER):
	Data Trace provides services on Title Information, Property
Description, and Property Tax information. The data and business process is done
in the CICS mainframe but the service request comes from many platforms such as
Business-to-Business (B2B), 3270 CICS, Jacada 3270 emulator, & Windows. The
service request can be submitted in a data stream or XML document and the service
response are returned in data stream, HTML, XML. Client can submit their service
request and XML document using the HTTP connection to the CICS mainframe.
Response is also returned using the same connection.
	Wrote the TIPS service which provides the end-users with Property
Profile Description and Property Sales Comparable. It includes the conversion of
VSAM files to DB2 tables.
	Maintain the Monitor Server Events, Monitor Server Statistics, &
Monitor Station systems. These are three reports on system activities. Service is
requested using HTTP protocol to the CICS mainframe and receives back an HTML
(Javascript) document that is presented in IE.

Experian	Technical Consultant (Permanent Employee)	Irvine, CA	June 1999 –
January 2001
Analyst:
	Attend meeting with users and team member to discuss the project, its
progress, and plan for its implementation.
	Wrote documents on how to convert Tandem COBOL programs and VSAM files
to C/C++ programs & DB2 tables.
Client:
	Converted the COBOL Tandem progams to C/C++ programs. The programs has
the extended C commands for CICS & DB2. It is a Consumer Letter Grading system.
	Wrote a Visual Basic 6 Testing Tool window application that accepts
data stream file or pasted data text, submits an HTTP request with the data
stream to the mainframe and receives a data stream that is presented in a window
text box.
	Wrote a MS Access with VBA codes to store business rules and these
business rules are ftp-ed to the mainframe where it is loaded in a DB2 table and
processed by CICS applications.
	Wrote a Microsoft Project with VBA codes that completes the entries of
a given project from resources.
Mainframe:
	Wrote mainframe CICS/COBOL & CICS/C/C++ TCP/IP Child Server
applications that provides for the initial communication between the PC server &
the mainframe applications, & eventually accept server requests, submit the
requests to the proper mainframe applications, and return the responses back to
the server for client presentations.

Home Savings of America (HSA)	Consultant (Permanent)	Irwindale, CA	January 1983
– June 1999
Analyst:
	On projects, lead or attend meeting with users and/or developers to
discuss and initiate upcoming projects. Meetings sessions are JAD, GAP, project
planning, plan the implementation, and brainstorming. Use of SDLC Project Guide.
	Talk to users to resolved issues that they encountered during the
development phase, QA test and production.
	Write System Design, Detail Design, Proposal documents, and Conversion
Documents (i.e. IDMS TO DB2, Merger files).s
Mainframe: (COBOL/CICS/DB2/Assembler):
	Y2K Lead Developer in a team of four. Converted COBOL, ASSEMBLER, CICS,
DB2 Saving, Banking, & Loan systems.
	Customer Information System Lead Developer. It’s a repository of
Customer Names, Addresses, various Accounts Types & their relationship to the
accounts.
	Lead Developer in converting the Customer Information System from IDMS
DB/DC/ADSO to CICS/DB2 Lead Developer.
	Heavily involved in many other conversion such as DOS/VS/VSE to MVS/OS,
data from other banking institutions.
	Wrote reusable modules in ASSEMBLER and COBOL to (1) Read (sequential
and random), Update, Delete VSAM records; (2) to take a freeform record and parse
them into Customer Names, Bank Titles, Street Address, City, State, & Zip (it was
a large application that I subdivided them into multiple CSECTs to avoid
addressability issue), DB2 Access.
	Responsible for development and maintenance of  the General Ledger
system, Banking, Savings, & Loans systems, Interest Calculation system & Interest
Payment system, Financial Systems.
Client:
	Wrote a MS Access with VBA codes to keep track of all our mainframe Y2K
conversion applications.
	Created standard form in MS Word form by embedding VBA codes.
Farmers Insurance	Intermediate Programmer	Los Angeles, CA	March 1981 – January
1983
Mainframe: (COBOL/CICS/DB2/Assembler):
	Provide maintenance to the Truck Insurance Policies & the development
of the Annual financial Report system. 90% of the applications were written
and/or  maintained in ASSEMBLER.

Personal	Developer	California	On-Going
	Wrote an Asynchronous Web Service window application (utilizing
delegate) to submit simultaneously web addresses. The application is written on
C# & VB.Net. The completed web searches and the web data are shown in a windows
form.
	Wrote a Web Parser window application that accepts an entered website,
retrieve the web document, and parse HTML tags in the web document, count the
tags, and show the value of the name-value HTML tags. The application is written
in C# & VB.Net.
	Wrote a Mail Delivery windows application that automatically sends an
email with an attached report when ready it is ready.
	Wrote a Visual Basic 6.0 application that embed Excel documents,
populates the document with data from the MS Access database, and produce an
Inventory Crystal Report. Transferred VBA/Excel processes to the new VB6/Excel
application.
	Wrote a Visual Basic 3.0 Lot Tracker application with connection to MS
Access database and Crystal Report.
	Wrote various Visual Basic .Net Windows applications, ASP .Net
applications, Crystal Reports while training in Mt .Sac College. Some of the
applications involved SQL Server access & updates. The desktop development tool
is the Visual Studio 2008. Wrote & completed Game Project that does 21 Card, Dice
Craps, & Card Red Dog.
	Wrote various Java Business applications while in training in Mt. Sac
College. The desktop development tool is JBuilder.
	Real Estate Principles and Real Estate Practice completed in Mt. SAC
College.
	Wrote PHP & My SQL web applications while training in CalPoly Pomona.
	Wrote personal website in PHP, My SQL, D/HTML, javascript. The desktop
development too is Macromedia Dreamweaver & Flash, Fireworks.
(http://www.wmendoza.com)

Education and Training.
Mt San Antonio College: VB .NET 2008 Advance Programming; VB.NET 2005
Programming; Java Programming; Real Estate Practice; Real Estate Principles.
Business Analysis: Fast Start for Business Analysis (HSA); Fast Start in Project
Management (HSA); Methodology Guide (HSA); SDLC (HSA).
Mainframe Programming: COBOL, Assembler, RPG II (LA Computer Learning Center).
Client Programming: Java Intro & Programming (Covina Tri-Community); C/C++ Intro
& Intermediate Programming (CalPoly Pomona).
CalPoly Pomona: Web Specialist using PHP & My SQL (CalPoly Pomona); Oracle
Programming & Administration.
Covina Tri-Community: Web Development using HTML, JavaScript, Flash;
Introduction to Networking Technology OSI Model (Covina Tri-Community).
College: AB-Economics (University of San Carlos, Cebu City, Philippines 1980).