Contact Information:

***** ******* ***** **.

Austin, TX 78717

Telephone 512-***-****

E-mail: actg51@r.postjobfree.com

Skype ID: pluvisoilla

GTalk ID: pluviosilla

CARREER SUMMARY:

Systems Programmer for IBM, Microsoft and various startups

Professor of Computer Science at 2 different Mexican universities

Lead Technical Writer in Storage and Buses (USB, IEEE1394, PCI) documentation for the Microsoft WDK (Windows Driver Kit team)

Owner and Manager of a Nearshore Software Consultancy

Excel VBA Consulting

Microsoft Certified Visual Basic Professional

SAS 8.2 Certified Programmer

Salesforce Certified Developer

LANGUAGES: Visual Basic, VBA, Salesforce Apex, Force.com VisualForce Markup language, R-o-R (Ruby on Rails), C, C++, Java, JSP, JavaScript, PHP, Flash Action Script, Visual Basic, Expect, TCL, Prolog, Lisp, Yacc, Lex, Awk, Sed, Pascal, Fortran, Bourne Shell, Korn Shell, C Shell, Perl, SQL, XHTML, Assembly Language for Intel Processors.

TOOLS: Excel (complex formulas, VBA, statistical analysis), MATLAB, SAS, R, Stata, Adobe Framemaker 10, Microsoft WDK XML document tools, Adobe Creative Suite: Photoshop, Dreamweaver, Abby Fine Reader, Visio

EXPERIENCE:

10/2015 to present SWBC, Business Analyst and Excel VBA Programmer

Developing Excel VBA macros to automate repetitive data entry tasks. Algorithms to implement business rules governing the tracking and assignment of insurance policies. Extensive use of API developed by IBM for accessing legacy AS400 systems with Excel VBA. Development of a report generation tool in VBA that does SQL queries on an Access database and generates formatted spreadsheet reports.

9/2010 to present Excel VBA (& macro) Consulting

Independent Excel VBA consulting, working for a wide variety of financial professionals and other Excel-literate customers who need help adding more sophisticated functionality to their applications or porting to new versions.. Some examples:

oProject: analysis of credit compliance and speed of paydowns by state.

oExcel Programming Techniques: VBA program that parses and analyses raw payment data to determine average time to loan paydown and percentages of aggregate paydowns by state. Reports in bar charts.

oProject: calculation of wins, losses and yield-to-date, as well as daily and monthly leveraged, cumulative and max. cumulative returns, incorporating draw downs.

oExcel Programming Techniques: macros and standard financial formulas for calculating present and future value

oProjects: parsing, aggregation and reporting in pivot tables of patient emergency incident data

oExcel Programming Techniques: used data source based on dynamic tables and complex table accesses (using multiple levels of indirection data-driven vlookup) to aggregate and report the data in pivot tables.

Familiarity with Excel’s statistical functions and data analysis tools, scatter plots, linear regressions

9/2010 to 12/2010 Excel Experts & Jon Pearsons Ass., Milwaukee, Wisconsin

Contract employment as Excel VBA consultant working with two different Excel consultancies. Did Exel VBA programming & problem solving and created complicated Excel Macros and pivot tables for Excel-literate customers who needed help adding more sophisticated functionality to their applications or porting to new versions.

7/2006 to present: EtherPros, Orizaba, Veracruz, Mexico

Owner and manager of a software outsourcing consultancy in Mexico doing web application development in R-o-R (Ruby on Rails), Java, .NET, Adobe Flash, FLEX, ActionScript 3.0, Objective C and PHP.

7/96 to 6/06: Microsoft Corporation, Redmond, Washington.

Programmer Writer III (8 years) on the Windows Device Driver Kit (WDK) team writing documentation for Windows device driver writers. Lead writer in following technologies: storage, USB, HID, PCI, 1394, SMB bus, Secure Digital (SD) Card and Smart Card. I am the author of approximately 85% of the USB documentation in the WDK, including the entire section on USB Power, all the material dealing with the USB generic parent driver and USB interface collections. I also wrote the section on Secure Digital Card devices, and about 50% of the storage documentation, including all of the storage port driver documentation. In addition to my principal areas of responsibility, I made many contributions to the general Kernel documentation.

You can see examples of my published technical writing at the following links:

oUSB Power Management:

http://msdn.microsoft.com/en-us/library/ff540132.aspx.

oWireless Mobile Communication Devices:

http://msdn.microsoft.com/en-us/library/ff538833.aspx,

C++ developer (1 year) on SMS (BackOffice) team. Implemented software responsible for accessing machines across a LAN for purposes of acquiring various sorts of software and hardware configuration data then processing and passing that data on to other components of SMS.

Visual Basic developer (1 year) on Visual Basic QA team.

03/88 to 03/91: I.B.M.., Austin, Texas:

Design and coding of the parallel printer device driver for the RISC/6000.

Development of version 3.1 of IBM's RISC/6000 AIX Operating System. Ported the X Display Manager (xdm) from X11.3 to X11.4.

Modification of AIX commands to make them conform to the Defense Intelligence Agency's C1 and B1 standards for secure operating systems and work on making X window managers compliant with DIA's Compartmented Mode Workstation Standard (CMW). Represented IBM at TSIG (Trusted Systems Interoperability Group), in the Secure X windows special interest group.

EDUCATION:

M. S. Computer Science, University of Texas at Dallas, Richardson, Texas (1984).

B. A. Physics, cum laude, University of Tennessee at Knoxville, Tennessee (1980).

Salesforce Certified Developer (April 2013)

Brainbench certification in SAS 8.2 (October 9, 2012)

Passed Certification Exam in Visual Basic 4.0 (May 1997)

SECURITY CLEARANCES:

None at present. Secret clearance granted by D.I.S.C.O. in April, 1982 now expired.

SPECIAL SKILLS:

Speak fluent Spanish, some (very rusty) French, and some (very rusty) German. I also have some familiarity with Classical Greek, Latin, Hebrew, and Nahuatl (Aztec).

Contact this candidate