Derek Alan Wilson

Work Experience

Engineering Professor, New York City College of Technology - New York, NY

August 2014 to Present

·         Serve as assistant faculty member in the Construction Management and Civil Engineering Department at the New York City College of Technology. Prepare and present lecture material for undergraduate civil engineering courses in fluid mechanics and land surveying. Prepare and conduct laboratory experiments, and grade student assignments and exams.

·         Setup research and development server to run Python web-service in Django, Hadoop data cluster and run Scala applications within Pyspark and NoSQL applications within Pymongo.  Run research applications to access HDFS from Pyspark programs and perform queries on HDFS with Pymongo.   

Python Developer, BNP - Paribas – New York, New York

June 2016 to September 2016

·         Developed Python, Django, Twisted and Asyncio web service applications concentrating in class based views and RESTful API  to analyze and report financial data analysis results and deploy as a Windows service.  These web service applications used Python's multithreading and database libraries in an object-oriented framework to run multiple applications asynchronously and store and retrieve results in a common MSSQL database.  Frontend development to these applications involved Javascript development using Angular/JQuery libraries concentrating in controller and directive constructs to update the web interface dashboard in real-time.

Data Analyst, Verizon Wireless – Branchburg, NJ

May 2015 to August 2015

·         Analyzed geospatial relationships of cost to revenue ratio of cellular service, signal strength between carrier providers and usage volume of cellular network.  Developed Python data analysis tools using Pandas, Numpy, and Scipy to perform multivariate regression analysis on network data. Used Arcgis and Business Analyst to access geospatial databases and MS Access and perform geospatial querying and regression analysis towards determining optimum market areas within cellular network. 

Research Hydraulic Engineer, U.S. Army Corps of Engineers Research and Development - Vicksburg, MS

August 2011 to August 2014

·         Engineer on research project to setup Python web-service on Redhat Linux server using Web2py web framework. Developed backend web modules to access government data servers with Open-Dap, Sensor Observation Service(SOS), and FTP in Python. Developed backend Python interface to MySQL, Postgres and Oracle databases.  Developed backend Numpy and Scipy numerical routines to analyze and process oceanographic and meteorologic data from government sponsored online sources including National Oceanic and Atmospheric Administration (NOAA).  Developed model-view-controller (MVC) web framework in Python, HTML and Javascript.  Developed frontend web pages to present the user's data and downloads in graphical and tabular form using  HTML, Jquery, AngularJS and bootstrap CSS.  Responsible for developing, testing, documenting and marketing these programs to users gaining their feedback and recommendations.

·         Co-leader on research project to analyze production data from dredging fleet.  Developed numerical routines in Python Numpy, Scipy and Pandas to analyze the streaming data from onboard ship computers and sensors.  Developed Oracle database SQL queries to extract, modify and store dredging fleet data from remote data server.  Developed engineering reports using data analysis and linear regression results from Python Pandas and presented results in graphical form using Python plotting utilities.

August 2002 to August 2011

·         Lead engineer on Dredging Knowledge-Base Expert-System to solve dredge project performance metrics based on engineering project and hydraulic pipeline parameters. Developed and tested the programs using Matlab mathematical software, Java, C Language Expert-system, and Python scripting. Responsible for development of program on a web-based interface, comparing program results to operational field data, presenting conference papers and publishing results in a peer-reviewed ASCE journal.

·         Lead engineer on dredging fleet data study to determine viable trends in dredging production and throughput.  Used statistical analysis in Matlab and Java to determine national dredging volume trends and cost data.  Developed engineering reports and published conference proceedings and presented findings at conference.

Applicable Skills

·         Python, Numpy, Scipy, Pandas  (6 years)

·         Pyspark (1 year)

·         Matlab (6 years)

·         Redhat and Ubuntu Linux (12 years)

·         Java (1 years)

·         MySQL, Postgres, Oracle (5 years)

·         Apache web-service (5 years)

·         Django and Web2py web framework (5 years)

·         Javascript, Jquery, Angular JS (4 years)

·         CSS, Bootstrap (4 years)

Education / Certification

·         CompTIA Security+ Certification, April 30, 2013.

·         Ph.D., Texas A&M University, College Station, TX December 2010
Ocean Engineering with Emphasis in Dredging
3.64 overall GPA

·         Professional Engineering License, June 09, 2008.

·         M.S., Auburn University, Auburn, Alabama August 2002
Civil Engineering with Emphasis in Environmental Engineering
3.52 overall GPA

·         B.C.E., Auburn University, Auburn, Alabama August 1999
Civil Engineering with Emphasis in Hydraulic Engineering
3.71 overall GPA

Publications

1.  Wilson, D. A. “A Pipeline Dredge Analytical Program with Comparison to Field Data – A Case Study,” J. Pipeline Systems Engineering and Practice, ASCE (August 2011).

2.  Wilson, D. A. “A Knowledge–Base Expert–System for Pipeline Dredges with Comparison to Field Data,” Ph.D. dissertation, Texas A&M University (December 2010).

3.  Wilson, D. A. “Visualizing Pipeline Dredge Project Schedules Using 4D Animation of Objects in Google Earth,” The Proceedings Western Dredging Association, Phoenix, AZ, June 2009.

4.  Wilson, D.A. “Pipeline Dredge Analytical and Scheduling Program” , Proc. Western Dredging Association, 2008.

5.  Wilson, D. A., “Dredging Knowledge–Base Expert–System”, Proc. World Dredging Congress, 2007.

6.  Wilson, D. A., “Water Injection Dredging in U.S. Waterways, History and Expectations”, Proc. World Dredging Congress, 2007

7.  Wilson, D. A., “Confined Disposal Facility Application For Dredging Operations Decision Support System”, Proc. Western Dredging Association, 2005.

Academic Honors

·         Tau Beta Pi, National Engineering Honor Society

·         Chi Epsilon, Civil Engineering Honor Society

·         Golden Key National Honor Society