Most Relevant
Home Up HTML format


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:          URL:

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)



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


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)            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.  


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 -----------


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 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)      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.

  1. I wrote SAS programs to retrieve data, and then combine it, to generate Annual Labor Standards Reports.
  2. Implemented a database for the Disposition of Electronic Boards (either Rework/Refurbishing or Scrap).  It used an innovative curve fitting –Hermite Polynomial- algorithm that I created (ROSI system).
  3. Developed in C language a Channel Emulator (code-named Chameleon) to diagnose our solid-state memory devices.
  4. Wrote AUTO-MDL (code-named Toucan), this was probably the most critical piece of software that I created at STK. It was in C, with CURSES windows, and UNIX OS.  It interfaced with users, particle counters, bar-code readers, …
  5. Developed the AUTS-Tape (Automatic Unit Test System for Tape Products) to allow for automatic unmanned testing and data collection from Tape Transport units, and from their corresponding Control Units.

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:                       Proud of being a PC's software pioneer! It displays résumés and  references.                             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.


    Juan Xuna    Stuart, FL 34997

"LEGACY WEBSITE": Will remain unaltered for the foreseeable future.

     Phn: (772) 324-1123       Fax: (561) 210-1370        Email: