Keywords: database, DBMS, ERD, schema,
Oracle, CLI, ODBC, JDBC, SQL, 3-tier, three-tier, ADO,
C++, J++, VB, Java, GUI, visual, “stored proc”, COM, applet, threads,
international, Latin, Spanish, España, Spain, French, France, Quebec, Portuguese, Portugal, Brazil, Brasil, Uruguay, Argentina,
John ("Juan") Xuna
1239 Hillsboro Mile, Hillsboro
Beach, FL 33062
(954) I-am-Xuna [that is (954) 426-9862].
Fax. (954) 426-9331
participate in the development of telecomm/software projects (Client/Server,
C++, J++, Databases, Internet). Background
in Telecommunications, Software Development, and Finance. Full-time or Contract.
Preference would be to work within 30 miles from Hillsboro Beach that
includes Boca Raton, Fort Lauderdale, Coral Springs, etc.
After November 1st, I could contemplate relocating to
another city, or State.
Negotiable. Minimum $58,000.
( Less if working from “ virtual office ”.
More if “ road warrior ”, or relocation required)
GPA 3.696 Master of Science,Telecommunications Engineering. University of
Colorado. Boulder, Colorado.
GPA 3.495 Bachelor of Science in Electrical Engineering. University of Puerto
Rico. Mayagüez, Puerto Rico.
Spanish, English, Portuguese and French
C++, Java, Visual C++, Visual J++, SAS, Prolog, Cobol, Fortran, Assembly, ...
MFC, WFC, RNI, JNI, J/Direct, Java/COM,
OLE, ActiveX, Oracle, Informix, ODBC, JDBC ...
Current Employer :
INDEPENDENT TECHNOLOGIES Corp.
early 1998 Senior Software Developer.
Company HQs are in Omaha, NE. R&D
center is in New London, MN.
ITC manufactures test-sets used by cable operators and telephone
companies, and markets upgrades for payphones as well as other miscellaneous
parts. We also develop application software for telcos.
I am trusted to work from home-office in Florida. I developed for our
main Client (SPRINT) a major Oracle application, written in Visual
C++, under Windows NT and with ODBC
connectivity. The program -called C&C®
(Contracts and Commissions)- calculates commissions due on 60,000 public
phones, and administers the 50,000 contracts of those phones.
It can be easily adapted to work with any other RDBMS engine.
To deploy the system I was relocated to Kansas where –for about two
years- I had an office at the Client’s headquarters (in Overland Park). Currently
working on Java projects (Visual J++ / COM) under Windows
NT, and JDBC connectivity to databases. I do also have responsibilities
with international sales of our software, and telecomm. products.
C&C® can be looked at as the first stage of an -eventually- full
blown DATA WAREHOUSE system. Hundreds of thousands of revenue/charge
streams are loaded into C&C® from several DATA MARTS (such as CDR - Call Detail
Reports, and other mainframe repositories). The data is not too clean,
therefore C&C® has a built in ETL module (Extraction, Transformation
and Performance) with automatic cleansing tools.
Mainly, it (a) extracts data from data banks; (b) validates the data,
tags it (a different commission rate could be applied later to each tag), and
removes inconsistencies; (c) then logs the purified data on a DATA STORE.
The users can now apply its built-in processing tools to calculate the
commissions multi-dimensionally (that is, the commissions due on a (i)
phone basis, on a (ii) contract basis, and on a (iii) payee basis). A
contract can have any number of phones. A contract's commission may be
payable to none, one, or many payees. To complicate matters, a payee can
be beneficiary of commissions paid on several contracts (what in our relational
database terminology we call a many-to-many tables-relationship). C&C® has built-in querying tools to analyze results. It
also has many predefined queries and reports. C&C®
thus becomes an intricate part of the department operations, as well as a
DSS (Decision Support System) to the Management of this Payphone Division.
On a monthly basis,
commissions' results are automatically loaded on several logs (repositories)
from where they can be analyzed with data mining tools.
-integrated with our Wesroc®
product (a Payphone Management
and Administration System)- then becomes a
full DATA WAREHOUSE for the Payphone Division. Not just the
Sales Department can benefit, but also Marketing, Parts Inventory, Repairs,
Box-Collection Dispatching, as well
as Product Pricing (which now has commission tiers' homogeneity across
geographical areas), and Accounting (better control of Payables and
I had as many hats on as
any Program Manager can thing of having, in other words, I was:
Project Lead – Who would commit to
aggressive and achievable milestones and dead lines.
SME (Subject Matter Expert) – Who
needed to expand quickly his knowledge of Telco’s CDR (Call Detail Reporting),
to be able to discuss with the client-company the most subtle details of
Business Analyst – Making sure the
business rules are correctly interpreted and implemented, and that the program
has all the needed features, some of which had not even been contemplated on the
Data Modeler Designer - At ITC we did
not have CASE tools (Computer Aided Software Engineering), such as Popkin or
Rational Software. Therefore the
building of the ERD (Entity Relationship Diagrams) and all the METADATA had to
be done the old fashion way, by brain power.
Of course, with some help from utilities built-in on the Microsoft SDK
framework (Systems Development Kit).
Data Loader – Although I could
count on help from administrative personnel at the Client's premises, for that
support to be effective it was paramount to be in close proximity with them.
Therefore, I relocated to an office at their headquarters in Overland Park, KS.
During the first stages of development though, the client had not seen
the program yet, meaning that the developer had to be data loader as well.
Application Programmer – No
question. I had to come up to speed
in C++, and acquire adequate dexterity and knowledge on MFC (Microsoft
Foundation Classes) and Visual C++ in
no time. Also I had to refresh my SQL, which was needed to write embedded code,
as well as the "stored procedures" that would trigger execution of
processes directly on the server, and so making the client thinner, what
Application Tester - I would have to
do the TPC Benchmarks (Transaction Processing Performance). Design the tests, and create the test data sets that would
exercise -if possible- all branching of the design’s flowchart . And do all
the time-consuming analysis of test results. Indeed, very tedious and labor intensive functions that would
normally require -a least- one full time engineer to do these tasks alone.
Technical Writer – Regardless of
how friendly the application is, and how well documented the source code is, a
trail of documents have to be created a long the way, such as the Progress
Reports. And finally a User
Manual will have to be written for the Client to understand how the program
operates, on how it is that it meets and complies with the required
Trainer – After all of the above
had been done, I had to be ready to give training seminars on the
program. Not just to users on the
Client's premises, but also submit to code reviews (accolades and
criticism) from peers at ITC headquarters, to learn from their input, and for
them to also learn from your achievements.
LODGENET ENTERTAINMENT Corp. (800)
Manager of International
West Ave. North, Sioux Falls, SD 57104
Moved from Colorado to South Dakota, and started international operations
for LodgeNet (a leader in pay-per-view, "on-demand" systems, for the
hospitality industry). Negotiated the signing of all hardware and software
technology licensing agreements with business partners in Latin America and
Asia. LodgeNet's systems have been
successfully deployed in Japan, Korea, Brazil, Panama, Peru, Dominican Republic
Position reported directly
to CEO (Tim Flynn) and COO (Scott Petersen).
Responsibilities included: Search for
"Licensees", review their operations and proposals, qualify
those candidates, recommendations to CEO/COO, negotiate Letter-or-Intent /
Licensing Agreement, migration of technology (software localization, software
licensing, permits), export's clearance, determination of harmonized codes,
coordinate training and technical support, quotes preparation, analyze and
report on sales statistics, accounting on royalties and remittance taxes.
I got disconnected from software development at a critical time, when
there was an ever-accelerating introduction of software products. Despite my excellent
exposure to databases, I often thought that my software days were over
----------- x -----------
WI, PR ANIMAL SCIENCE SOFTWARE INTERNATIONAL (414)
during early 80’s President
2011 East River St., Two Rivers, WI 54241
For eight years I developed -in "C"- applications software
for the agribusiness industry. The software packages were integrated database
management systems, applied to the operation of a dairy farm.
"XUNA D.M.I.S." (c)1981
D.M.I.S" (C)1991). COPYRIGHTS:
TXu 74-195, TXu 90-917, TX 3-260-709
" Animal Science Software InternationaI ", Two Rivers, WI, and
" Scientific Software ", Old San Juan, PR, were eventually closed due
to lack of venture capital. Farmers
in Wisconsin and Puerto Rico are still using these packages.
the beginning of that era when microcomputers were introduced, I founded
"Scientific Software" (Sept. 1978,
Suffolk County, NY). The first
applications I developed were computer graphics programs.
Two years later, I resigned from British Airways were I had been a
Telecommunications Officer for four years, sold my house on Long Island, NY, and
moved to Puerto Rico where I dedicated full time to the development of database
applications for "micros". In
September of 1981 I formally introduced at a farmer's conference my first
database application. It was
named "XUNA D.M.I.S." (a Dairy
Management Information System). At
the time, it was considered -by officials in that industry- to be the most
powerful herd-administration tool, and decision support system (DSS), a farming
operation could have. Please visit
on my website www.1stToNone.com the page titled
years later I founded another company ("Animal
Science Software International", Two Rivers, WI),
and in September of 1991 I introduced to farmers in Wisconsin a PC version of
the DMIS, this version was named "Decade
developed the database engine in C-language.
Windows was not yet what it was to become, and -furthermore- for future
migration to other non-Windows mid-range platforms I chose "Vitamin
C" (library that was very popular in those days on minis) to build
lack of venture capital (and despite great accolades from farmers and trade
publications) I had to close down both operations within a couple of years of
founding these entrepreneurships.
----------- x ----------
(4 ½ years)
STORAGE TECHNOLOGY Louisville,
Test Software Engineer (Co).
2270 South 88th St., Louisville, CO
StorageTek, a leader in data storage devices.
I worked as senior Test Engineer involved in the development of critical
software, to test: tape, disk and
solid-state storage devices (programs were written in C-Language under a UNIX
operating system. Informix
was the DBMS).
as a COBOL and SAS Programmer at their Puerto Rico plant. Transferred to the
headquarters in Louisville, CO, in 1988 as Test Software Engineer.
requested I could fax a 4-page description of duties and accomplishment
at STK (both in Puerto Rico and Colorado plants).
I left voluntarily to re-start entrepreneur-ship in Wisconsin
developing dairy-farm software (June 1991-1994)
For more Information you could visit the following websites:
… Proud of being a PC's
software pioneer! It displays résumés and
… I created this
tri-language site to cater to our company's foreign clientele.
… I developed this site
for my wife. It is an Art Gallery
with ASP forms and online database.
… I own about 50 domain
names, some of which can be bought via this site, that I designed.
"LEGACY WEBSITE": Will remain unaltered for the foreseeable future.
Phn: (772) 324-1123 Fax: (561) 210-1370 Email: Xuna@MSN.com