Programmer Analyst Front-End

JOSEPH J. MC DONNELL (JOE), U.S. CITIZEN

**** *********** ***. #***

Lisle IL 60532

mcdonnejj@ gmail . com

224-***-**** cell/text

CAREER SUMMARY

Developed both RDBMS scripting ETL back-end and GUI front-end applications through the complete SDLC in multiple application domains (manufacturing, cellular, trading) with a variety of technologies. PROGRAMMING LANGUAGES, ECOSYSTEMS, BIG DATA WRANGLING, APIS Python (numpy, pandas, Spark), C/C++/Perl (regexes, fileIO), Linux shell scripting (ksh, bash), MATLAB/Octave, Java, SQL, JavaScript, jQuery, Node.js, Connect, Express, PHP, RESTful APIs MARKUP LANGUAGES AND DATA INTERCHANGE FORMATS

HTML, XML, JSON, Various EDI Transaction Sets, CSV, TSV, XLS, MAT, generic binary RELATIONAL DATABASE MANAGEMENT SYSTEMS (RDBMS)

mySQL, msAccess, Oracle, Informix, Sybase, decRdb, ibmDB2, ibmSQL/DS, SQLite, msSQLserver OPERATING SYSTEMS

MICROSOFTWINDOWS (NT, Y2K, 98, 95, 3.1, MSDOS), UNIX (LINUX, CYGWIN, SUNOS, SOLARIS, DIGITAL UNIX, IBM AIX), DEC MICROVAX/VMS, IBM VM/CMS, IBM MVS, IBM DOS/VSE HARDWARE

Intel x86 CPUs, IBM RS6000, DEC VAX/microVAX, Arduino, 8051 Microcontroller. EXPERIENCE

Group Developer

Jump Power prev. LLC of Jump Trading, Chicago, IL

3 years 2 months

Developed and maintained Python, Perl, Java, MATLAB, and bash shell ETL scripts to extract data from external web sites, then load transformed data into a mySQL database. The data was used for daily virtual electrical power trading activities in 5 (five) markets. Programmer Analyst

TEKsystems for Jump Power/Jump Trading, Chicago, IL 4 months

“TEKsystems” W2 at “Jump Power/Jump Trading”, developed and maintained Python, Perl, Java, MATLAB, and bash shell ETL scripts to extract data from external web sites, then load transformed data into a mySQL database. The data was used for daily virtual electrical power trading activities in 2 (two) markets.

Solutions Developer

Acxiom Corporation (now Ensono), Downers Grove, IL 1 year 3 months

Developed/customized Oracle data warehousing technical solutions to provide data files to 3rd party vendors to drive vendors' multi-channel campaigns. Programmer Analyst

TEKsystems for Acxiom Corp., Downers Grove, IL

7 months

"TEKsystems" W2 at “Acxiom Corp.”, worked on Oracle data warehousing and job scheduler projects. Unix Script Conversion Specialist

Encore for The Clearing Corp., Chicago, IL

3 months

Worked on series of mini-projects to migrate Unix Perl and ksh sub-systems from Sybase to Oracle. Systems/Programmer Analyst

U.S. Bankruptcy Court, Chicago, IL

10 months

Developed & maintained customizations to IL North Branch bankruptcy court's Case Management (CM) and Electronic Case Filing (ECF) systems. Developed and maintained Perl and Unix shell scripts for monitoring and reporting on Informix DB status (lock monitoring, log buffer space usage, etc.), Solaris system status (disk space usage, large PDFs, etc.), and CM/ECF status (EDI file well formed tags, etc.). Developed Python scripts to reconcile CM records between Visual FoxPro & Informix. Programmer Analyst then Senior Analyst

CellularOne/Cingular Wireless, Hoffman Estates, IL 4 years 8 months

Developed Unix shell scripting (ksh and Perl) ETL applications, and Oracle DB client-server GUI data- entry/presentation applications with VB, Object Pascal (Delphi), and Java, through the complete SDLC. Associate Software Development Engineer

bioMérieux Inc., Hazelwood, MO

3 years 2 months

Developed and maintained Oracle Pro*C, Unix shell, VBA, VB4-6, DCL and SAS programs. COMPLETED EDUCATION

Certificate, Web Development, DPU IPD Loop Campus (Fall 2017), Chicago, IL Certificate, Embedded Systems, IIT CPD Rice Campus (Summer 2012), Wheaton, IL Certificate, Data Warehousing, IIT CPD Rice Campus (Summer 2007), Wheaton, IL Bachelor of Science - Computer Science, University of St. Francis, Joliet, IL Associates Arts and Science - Engineering, Joliet Jr. College, Joliet, IL

Contact this candidate