Robert Wilson Email & Phone Number

Greater Chicago Area

The non-profit startup that I work for is dedicated to teaching using a variety of methods for different ages. The teaching material is prepared and designed to teach multiple learning types. The soon to be website is a subscription based website that promotes education and development using several courses. • Developed the front-end with HTML5/CSS and XML.• Prepared the courses for streaming for the users.• Chose to use Joomla 3.4 as a CMS platform and purity iii as its template, which has incorporated the responsive design of Bootstrap 3.• Flash C56/CC, animation software, and Action Script 3 as its programming language were used to stream the courses to the users.

I created an informational dynamic tracking application which is assessed via MySQL database. It runs under Windows and Linux environment displays U.S. Congress voting records on selected bills.I created a Java Application that monthly automatically:• Extracts files from a governmental transparency website via JSON and write a tab-delimited text file. So far over 7000 files have been extracted.• Loads several MySQL database tables using JPA with Hibernate. Currently the database tables are in excess of 2.3 million entries.• I am sent an email from the Java Application about the success or failure of the loading process into the MySQL database tables and the status of how many files/items were uploaded.Created a front end using C# and another with JAVA using WindowBuilder under Eclipse IDE for GUI development and used JDBC to connect to MySQL. The user can use the application to retrieve information about the voting record of any U.S. Federal Senator and/or House of Representative from any particular state. Once the federal member has been chosen and if any keyword was requested, a list of any Bill (from 2009 – now) will be displayed. Then the user merely has to double-click on the Bill they are interested in and it will display how the federal member voted on said bill (Yeah/Nay).

Chicago

I created a C# executable to downloaded video files from the internet to the desktop or laptop.• Created a XML Web Service client in C# and .NET to access Google’s API web services. • Submitted a request to a video service to download selected video in an Adobe Flash (.FLV) format.

PROJECT: Private Branch Exchange (PBX) Migration and Public Safety Answering Location Identifier (PSALI) conversion.• Software Architect for the transparent migration from Intecom S-80 PBX to Nortel Networks Meridian PBX (private branch exchange) telephone switching system.• Five phases over a three-month period of time and it affected over 520,000 telephone equipment items.• Data entered in EXCEL was checked and loaded into Microsoft Access 97 using EXCEL VBA macros.Visual C++ programs, HLLAPI code, and other EXCEL VBA macros that I created were used to audit and integrate the changes into CBOT legacy system. Any errors or corrections were highlighted by my auditing programs and then investigated and modified by CBOT telecommunications employees.• Programs that I created simulated repetitious procedures needed to handle the workload: CHANGE, TRANSFER, RENUMBER, and DELETE telephone equipment items.• Restructured old Public Safety Answering Location Identifier (PSALI) System to incorporate changes from their new PBX telephone switch system. PSALI transmits information from all dialed 911 calls.PROJECT: TELECOM MONIES ACCESS & Report System (TMARS)• Developed additional auditing reports and converted reporting system between Intecom PBX and CBOT’s billing system.• The new auditing reports and combined with the converted reports and older MARS reports were implemented in the newly created TELECOM MONIES ACCESS & Report System (TMARS). • Created a Visual C++ program to generate auditing reports between SBC’s Public Safety Answering Location Identifier (PSALI) data and CBOT’s E911 PSALI data.

PROJECT: International Commercial Banking Systems• • Created new JAM screens and reports and converted current reports and screens to use the newer JAM version on an UNIX machine.• Using embedded SQL queries from Sybase via stored procedures and triggers to populate the JAM Reports.

PROJECT: MONIES ACCESS & Report System (MARS)• Management Of Network Income, Expense and Services (MONIES) is a telephone billing management system that is implemented in an IBM mainframe. CBOT uses MARS to perform equipment location and telephone number identification for their E911 project. MARS acts as an interface between the Telecom Intecom S-80 PBX telephone switches, the MONIES billing system, and the SBC/Ameritech’s Public Safety Answering Location Identifier (PSALI) systems.• Created a support document and re-engineered an existing Microsoft Access reporting system used to track billing of telephone equipment and telephone usage for all the CBOT member firms.

Phoenix,Arizona

Project: CALNET State Integrated Billing SystemA team was created to work on a telecommunications integrated billing system designed for the State of California state government.• Joint cooperative venture between Pacific Bell, MCI and Telesoft to provide the telecommunications needs for the California state government.• Built an integrated billing system using JAM 7.36 as the front-end where users were on a Windows NT 4.0 system while, using ORACLE 8i as its database on an UNIX operating system.• The JAM Reports were populated by ORACLE using Pro*C SQL queries and triggers.• Participated in performance team, troubleshooting, documentation, developer, team JAM expert, and testing roles.

I was part of a team that was created to interface between two computer based online training administration systems. • Re-engineered the back-end of a third party’s training facilitator system, National Education Training Group (NETg) to run TCP/IP socket calls.• The processes of Adding, Updating, Deleting, Granting, Revoking, Changing of Passwords, and Resetting of Passwords were implemented in a C executable that I created.• These changes were relayed to a Microsoft Access 97 database via HTTP calls to several worldwide NT Servers through ISAPI Programming for Microsoft’s IIS (Microsoft web server application software).• I also developed a C++ program that would interface between the new Training Administration System (TAS) and the legacy NETg system. Through TAS any Motorola employee could register for a computer based online training NETg course from any Motorola work site in the world.• ORACLE triggers were used to insert into specified ORACLE tables. Those tables were watched by UNIX cron jobs to run C++ executables that in turn would register that Motorola employee to that specific NETg course.

PROJECT: Single Source Dividend (SSD) and Electronic Verification Inquiry and Surveillance System (ELVIS)I converted two financial reporting applications from JAM 5 to JAM 7.35.• Both SSD and ELVIS applications required extensive enhancements due to new user requirements. Several screens had to be created to handle the new requirements.• The users logging in via JAM GUI screens accessed INFORMIX using ODBC drivers and then would able to SEARCH, UPDATE, ADD, or DELETE data from the INFORMIX tables. Triggers were implemented for auditing purposes.• Added printing capabilities via Visual C++ for all the screens and made both applications year 2000 compliant.

I established a TCP/IP socket connection from a firewall server to multiple host servers. Either a random number generator or a load balancing routine would determine the selection between these host servers.• I developed a program in C that would map HTTP traffic to several front-end servers inside a firewall via TCP/IP socket programming on a UNIX server.• Either a random number generator or a load balancing routine would determine the distribution of the socket connections to the host servers.• Created a daemon process that would report load balancing from the host in the external table into a file, so that the firewall proxy program could use it.

I was part of a team to program integration between a legacy order entry system and the new order entry system.• Helped develop a Middleware application written in ANSI C that would function as an ORB (Object Request Broker) to connect the Distribution Management system with their legacy mainframe.• Using functions off of the new Distribution Management system during key events issued by the users, certain information would be sent to the ORB via TCP/IP Sockets connected to a specific port.• The ORB would determine the type of transaction via Perl scripting and connect to the legacy mainframe using HLLAPI macros.• The data from the IBM mainframe would be sent to the user using the TCP/IP Socket connections.

I was part of a team that was responsible for creating a trouble ticket interface application using Remedy as the GUI and database connections to Oracle.• Created a trouble ticket interface application using Remedy as the GUI and database connections to Oracle.• The information collected was parsed via a C++ program to be used among the five other GUI applications.• I worked closely with other developmental groups whose applications were interfacing with ours. I gathered data requirements, product evaluations to determine the strengths and/or limitations, and was a key liaison with the users.• Over 200 Customer Service Representatives would use this application was to notify other departments about the customer’s call either relating about equipment, billing information, network problems, activation of new services, or general information.

I was part of a team that helped develop a Client/Server application that would track dairy components from their Oracle database.• My team developed the GUI front-end screens using JAM 7.0. JYACC Application Manager (JAM) is used for GUI development and data management of the screens and reports that interface with the end-user.• My team created the stored procedures and triggers that were used to relay queries to the Oracle database and information back to JAM screens. This GUI application is running on a HP-UNIX system.• The users would run SEARCH, UPDATE, ADD, or DELETE queries from the ORACLE tables from this GUI application.

PROJECT: Motorola Employee Directory (MED)I was a Project Leader that developed a ‘411’ application that is using a GUI front-end screen and TCP/IP Socket program to connect to the INFORMIX database server. This application was deployed over two different platforms (Windows, and Macintosh) to over 140,000 employees.• After a few interactions of GUI front-ends (PowerBuilder, Microsoft Visual C), Visual C++ was chosen to be used as the Windows front-end.• I used C and Visual C++ to program the client TCP/IP socket executable; which was compiled into a WinSocket DLL.• My team and I used C and INFORMIX ESQL/C to program the server TCP/IP socket executable on an AIX UNIX server. The server TCP/IP socket executable dynamically created INFORMIX SQL queries sent by the client. UNIX cron jobs were used along conjunction with Perl scripts.• My team and I also created the client TCP/IP socket executable for the Macintosh front end.