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,
Mexico.
John ("Juan") Xuna
1239 Hillsboro Mile, Hillsboro
Beach, FL 33062
Phn. (954)
I-am-Xuna [that is (954) 426-9862]. Fax. (954) 426-9331
Email: Xuna@MSN.com URL: www.1stToNone.com
Objective: To
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.
Relocation: 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.
Required Salary: Negotiable. Minimum $58,000. ( Less if working from “ virtual office ”.
More if “ road warrior ”, or relocation required)
EDUCATION |
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.
SPOKEN LANGUAGES |
Spanish, English, Portuguese and French
COMPUTER:
Languages and DBMS Engines
|
C, 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 ...
WORK EXPERIENCE (at
present) |
www.IndependentTech.com Current
Employer : INDEPENDENT
TECHNOLOGIES Corp.
Since early 1998 Senior Software Developer. Company HQs are in Omaha, NE. R&D center is in New London, MN.
(3 ½ years) 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.
SUMMARY:
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.
C&C®
-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
Receivables).
I had as many hats on as any
Program Manager can thing of having, in other words, I was:
1)
Project Lead – Who would commit to aggressive
and achievable milestones and dead lines.
2)
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 application’s
usage.
3)
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 original
specs.
4)
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).
5)
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.
6)
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 improves
performance.
7)
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.
8)
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 specifications.
9)
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.
WORK EXPERIENCE (past) |
www.LodgeNet.com LODGENET
ENTERTAINMENT Corp. (800) 257-2345.
1994-1997 Manager of International Licensing. 808 West Ave. North, Sioux Falls, SD
57104
(3 years) 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 and
Venezuela.
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 -----------
www.DairyTEK.com
1991-1994, WI, PR ANIMAL SCIENCE SOFTWARE INTERNATIONAL (414) 793-1420.
Also
during early 80’s President
and Owner/Developer. 2011
East River St., Two Rivers, WI 54241
(8
years) 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 and
"Decade 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.
In
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 "Pioneer".
Ten
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 D.M.I.S.". I 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 the GUI.
For 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)
www.StorTek.com STORAGE
TECHNOLOGY Louisville, Colorado.
1986-1991, CO 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).
Started
as a COBOL and SAS Programmer at their Puerto Rico plant. Transferred to the
headquarters in Louisville, CO, in 1988 as Test Software Engineer.
If 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
----------- x
-----------
For
more Information you could visit the following websites:
www.1stToNone.com … Proud of being a PC's software pioneer! It displays résumés and
references.
www.IndependenTEK.com … I created this tri-language site to cater to our company's
foreign clientele.
www.MonaXuna.com … I developed this site for my wife. It is an Art Gallery with ASP forms and online database.
www.StrategicNames.com … I own about 50 domain names, some of which can be bought via this
site, that I designed.