Welcome to old.kevinp.net|Resume - Kevin's Programmer/Analyst Resume

Objective

To provide an organization with original quality custom in-house business automation software applications, or money-making software products developed from the ground up using Visual Basic .NET/6.0, ASP, PHP, JSP, FLASH, and Windows Scripting for Microsoft Windows networks; Well-rounded for small to midsize emerging business unit; project based contract work acceptable; relocation acceptable.

Software Development Skills

• Programming Languages and Environments

  FLASH MX 2004 Timeline or ActionScript movies, Visual Studio .NET 2003/2005, Java Server Pages using Resin or Tomcat, Microsoft ASP, PHP, Visual Studio\Basic\InterDev 6.0 Enterprise Edition, Crystal Reports, Windows Scripting Host, VB\J Script and JavaScript, KIX logon scripts, Windows Shell Batch Scripts, FrontPage\Document Object Model (DHTML), and graphics with Macromedia Fireworks\Adobe Photoshop.

• COM Automation and Microsoft Technology

  Class modules (OOP), Windows ActiveX UserControls (OCX), ActiveX (DLL); Windows Installer SDK, Visual Studio Installer, WiX; MS Access, MS Outlook, MS Excel, MS Word, Attachmate EXTRA!, & PCOMM Object Models; ODBC, OLE DB, CDO, DDE, Comm. & Internet Controls, Printer Object, & MS Resource Kit tools.

• Web Services and 3-tier enterprise Client\Server Desktop database applications

  PHP SOAP, WSDL, DOM XML, XML-RPC, MS SOAP V3; T-SQL; SQL DDL, DML, & DMO; ADO, ADOX; VB Interface with SQL Server, MySQL, Oracle, AS400, or Access via ADO; VB Automation of MS Access using ADO & Access Object Model; MS Access VBA.

Work Experience

Resercom G.P.        Irving, Texas        Senior Software Developer

• Developed from the ground up a Point Of Sale Integration software system that injects an online order into Aloha TableService and QuickService POS systems that run in restaurants. Technologies used are PHP Web Services, Microsoft SOAP, MS XML Core Services, MS WMI, and Aloha SDK Automation.
• Developed a new software application that prints online orders on any Point of Sale thermal printer. Network printing is enabled programatically.
• Developed a PHP SOAP Web Service.
• Modified PHP/PEAR DB Objects and Data Forms online ordering server software.
• Designed and maintained MySQL databases.

SOCCENT        Tampa, Florida        Technical Report Writer

• Developed an automation tool that reads file names located anywhere into a Microsoft Access database anywhere on the network.
• Developed a Microsoft Word macro that populated form fields in templates based on user input; macro loaded a custom user form.
• Developed a Microsoft Word macro that automated obtaining data by reading other Word documents.
• Developed a Microsoft Powerpoint macro that automated exporting slides as images.

RIA SE FTW        Fort Worth, Texas        IT Specialist

• Automated Microsoft Outlook via VBA by writing inbox emails to a flash drive for import into a proprietary computer network; Automated searching of key emails and separating them into specific directories.
• Install and troubleshoot ActiveIdentity CAC/PKI hardware and software for users; familiar with ActiveIdentity SDK and Microsoft CAPI.
• set up new users, repaired computers and printers, troubleshoot software and configuration problems on NMCI network.
• Administer and troubleshoot AMAG Technology software security system for all users.
• Detailed accounting of computing inventory; solved inventory issues.

SCA Promotions, Inc.        Dallas, Texas        Software Developer

• SCA FTP File Counter (FTPFC): Automation of a business process that manages hundreds of data files uploaded to an FTP server. This application performs functions like tracking, counting and managing entries, moving, and categorizing of files. Visual Basic Windows based multi-user application with security features. Three distinct applications comprise the system. Developed from the ground up. Works over a WAN. Permanent and maintenance free solution.
• Developed from scratch Touch Screen kiosk games that utilize bar code scanner, magnetic stripe reader, thermal printer, and signature pad. Completely graphics driven. VB controls are not visible. Developed Animation for attract mode and game play. Database connectivity to SQL Server. Administration mode allows view of game play statistics and performs game administration tasks. Several types and varieties of games.
• ActiveX controls designed for developers that install onto Microsoft's Visual Studio IDE. Onscreen keyboard, and keypad. Robust and feature rich controls. End User Interface is all graphics. Set properties at run-time or via Property Pages at design-time. Methods and properties called at run-time.
• Automation of HTML based emails. 100% customizable and personalized email application developed from scratch. Developed a test application to send to clients to demonstrate service before kiosk game shipped to client.
• Interactive Voice Response programming using Dialogic D4/PCI hardware and system tools, and Artisoft's Visual Voice Pro development environment. IVR system takes input via phone, reads database, and provides output to caller. System takes input from caller and records data to database.
• PHP and MySQL web page development and Javascript input validation. Cross-browser platform development: client-side javascript application compatible with Mozilla engine and IE.
• Custom built MS Office macros.
• Daily HelpDesk PC support to end users.

Rushmore Financial Group        Dallas, Texas        Programmer/Analyst

• Online Subscriber Agreements Web based application (Exchange Agreements) using Java Server Pages over a secure connection. Connected to SQL Database via JDBC and used Resin 2.1 as JSP Servlet host. This application is Netscape and Mozilla compatible. Active PDF Toolkit used to generate 4 dynamic PDF documents from data stored in database; very user friendly; excellent presentation/interface; data validation; does not write duplicate records; traps and handles the back button; error handling and reporting including sending administrative emails; multiple ways for customer to contact us including sending comments; 16 page application.
• Exchange Agreements Fulfillment and Research Utility is a web based JSP reporting interface into the Exchange Agreements. Major features are to search the database, view all record data, specialized queries, and view PDF documents.
• Designed Free Demo JSP webpage and added client side JavaScript data validation, and customized web tracking. Generated reports tracking page hits and succesful demos signups.
• Designed and developed a JSP Web-based Express Application that captured prospective customer contact information for the Marketing Dept. to call customer and setup account over the phone; Separate web based application served as the interface for Sales Reps. to view captured data.
• Designed and developed web pages using JavaScript and DHTML.
• Modified and made improvements to Online New Account Application. For example, installed a Contact Capture feature that allowed Sales Reps. to call customer if application is incomplete.
• Modified Level I JSP web-based trading application. For example, added client-side JavaScript that dynamically changed controls like drop down boxes.

Kairos Consulting LLC        Dallas, Texas        Contract Programmer

• PRMRCM Process Relationship Management - Relationship Configuration Manager: Developed a rich ActiveX client Windows application and a Windows control (DLL) that runs in a Web browser or another Windows application using Visual Basic .NET. The latest ADO.NET data access components from the system.data namespace were coded into a class wrapper using a class module to meet the specific needs of the application. Object-oriented design.

Morgan Stanley        Dallas, Texas        Systems Development Analyst

• Develop, deploy, administer, maintain, and troubleshoot Microsoft Windows NT 4.0 and 2000 domain servers, and workstations. Build, configure, and repair servers, workstations, and network hardware.
• VB 6.0 2-tier database interface application named Funds Processing Archives Research Utility (FPARU) that interfaces into daily proprietary databases using MS UDA technologies: OLE DB, and ADO to search for and display images of customer deposit transactions that were made into their account over the last 3 years. Uses third party ActiveX component Wang Image. The Scripting Runtime Library?s FSO COM Object Model and MS Flexgrid are key components. Advanced features include aggregate filtered searching, and NT group security. PLEASE NOTE: I was the sole developer. This application was developed from scratch from the ground up by studying the business need. The benefit was that it became an integrated in-house custom reliable enterprise application because it linked remote data servers into one user interface via WAN UNC. It replaced an unreliable non-networked application that was used to build the data. In other words, this application separated two distinct roles - the program that builds and populates the database and the database interface. The core application was developed and tested in two weeks. Advanced features were added later. The proprietary databases were Visual FoxPro DBF files, which were implemented hierarchically on a file system.
• VB 6.0 2-tier DBMS application consisting of two programs and a SQL Server data source. CheckWriter Workstation Download & Processing Utility (CWWDPU) is the first program that automates by downloading data records (customer checks) from the mainframe via EXTRA!, etc. It then imports this and a related data report into the database via the scripting runtime library. The user can list records, modify, export, and set business options. The first program serves to manage the creation, populating, and settings of fields in the tables of the database. The second program CheckWriter FedEx Overnight Database (CWFODB) is the archive interface to the database for researching, aggregate filtered searching, printing, setting additional business options, noticing trends and patterns, and viewing compiled statistics. Heavy use of COM Automation, FSO Scripting, and ADO. Eight reports were generated by using the Printer Object, which worked better than using Crystal Reports. PLEASE NOTE: I was the sole developer. This application automated and streamlined the process which considerably improved productivity and efficiency and it greatly reduced the chances of human error. This application is commercial quality with several screens. Every possible feature was added in by employing option screens, or the menu bar. This application pulled in data from disconnected sources and maintained it in one centrally accessible database. Also, it connected to an external database to retrieve branch information. The database architecture was simple were each table was a business date that maintained transactional data. The primary key of each table was the Tracking Number. A complex feature was viewing all the days in a month. This procedure was accomplished programmatically by using ADO, not using SQL. Once the month recordset was constructed programmatically, I then populated the Microsoft FlexGrid, which displayed in a screen with vital statistics. This application was production ready in three months.
• VB 6.0 stand-alone application named Text File Print Monitor (TFPM) that monitors a user specified directory and prints a text file once it is copied into that directory to any specified system printer. The program moves printed files to a printed subfolder. The program provides all relevant status and statistic details about events that have occurred. The Printer Object is the component I used to gain access to all system printers.
• MS Access custom VBA applications: Branch Liaison Contact Database (BLCD) and Guaranteed Paperwork (GP). GP is a single user single PC data entry database where the user inputs data records to be stored and to later print time sensitive analysis reports of that data. Also includes automation of MS Outlook. These two applications are single-file, single-user, and single-workstation applications.
• VB 6.0 Automation of EXTRA! to modify, execute, and download IBM TSO/ISPF JES EZ-Trieve mainframe jobs automatically. As the sole developer, this utility combined several manual steps into one click of a button. It improved productivity by automating a repetitive bulky manual task. This utility made it simple such that a non-technical person can do the work.
• Routinely programmed EZ-Trieve (IBM mainframe JES language) to download raw data (client account records). I then produced custom advanced MS Jet SQL queries of account records from Morgan Stanley branches for Branch Manager and Financial Advisor use; Exported and imported client data between MS Access and Excel; formatted MS Excel spreadsheets using macros to e-mail to branches.
• ACATS Data Entry: Brought new Financial Advisors into the firm by entering in all of their clients into a custom MS Access database. Portions of this process were automated using Visual Basic and VBA scripts. This client data was used to mail merge form letters and related documents using MS Word.
• Published monthly reports: Short Safekeeping, Checkwriter Benchmark, and Margin Extensions which utilized formulas, charts, graphs, and advanced features of MS Excel and MS Access including VBA scripts.
• Performed local desktop PC Support and telephone support of remote sites; Resolved technical, computer configuration, computer hardware, and specific technical policy issues with internal on-site and remote employees. Answered questions about properly using Desktop Software like Microsoft Office and stepped callers through specific procedures; Conducted a computer training class.

Bank of America, N.A.        Dallas, Texas        Loans\Tax\Retail Customer Service Representative

• Interpersonal skills: solving customer issues especially irate customers without a request for a manager.
• Answered in-bound customer telephone inquiries; researched and resolved customer and account issues.
• Reconciled and performed account maintenance on accounts including retail loan accounts.
• Sales skills: Explained and upgraded customers to more appropriate products and services offered by the bank.

Education

The University of Texas at Dallas        Richardson, Texas

• Bachelor of Science in Computer Science.
• College Programming projects all written in C or C++:
  • Arithmetic Expression Evaluator; handles parenthesis, & order of operations; linked list implementation.
  • Interactive DOS based drawing program; Similar to LOGO in the Apple II days.
  • Computer assisted learning program for arithmetic operations: +, -,*, /.
  • Data Type implementations for linked list data structures: Stacks, Queues, Binary Trees, and Heaps.

Texas A&M University        College Station, Texas

Navarro College        Corsicana, Texas

• Organized and implemented a paper recycling program.

Personal Attributes

Professional, organizing, communication, leadership, and problem-solving skills; Detail oriented; Client oriented; Efficiently automates business processes through technology; Always improving technical skills.

Military

US Navy and COMPACFLT        Fort Worth, Texas        Specialist

• Successful and rewarding experience; Security clearance.
• Consistently and professionaly performs unit tasks.
• Continuous improvement of unit functions and processes.

USFK CFC        Seoul, South Korea        Specialist

• Automation of MS Word that takes a UNC path as input and opens all Word Docs in path and performs a find and replace provided via user interface.
• Automation of MS Excel that adds, deletes, and modifies hyperlinks based on searching for files on a UNC path provided as input.
• Utility that converts RTF docs to Word docs.
• Developed a method to generate Word docs based on data from a database that reduced user input error.

CTF-74        Yokosuka, Japan        Specialist

• Developed a MS Excel form based utility that computes the difference in days, hours, and minutes of two Military Date Time Groups that are entered as input.
• Developed a MS Excel macro that computes Local and Zulu DTG's and automatically updates when user inputs data into MS Excel. Variables in macro allow IT staff to modify features of macro.
• Discovered a technique to propagate views in a proprietary military application.

---