818-***-****

Los Angeles, CA

ad2d0x@r.postjobfree.com

Git

LinkedIn

www.fjalali.com

Google Scholar

WORK EXPERIENCE

Web Developer – Freelancer

- Developed an e-commerce website using Django as backend with the following features o Custom user models to extend the default User model o Product models and views

o Categories and media files

o Carts and checkout

o Orders and payments with payment through PayPal

o User authentication - registration, login, tokens o Account activation and password reset

o Reviews and ratings

o Deploying the app on AWS Elastic Beanstalk

- Developing a pavement management system web application. This web application has the following features/components.

o Django is used as the backend to handle engineering logic o Django-tenants used to create multi-tenancy so each client has its own domain and schema o Postgres used as the database. Django-tenant used with one database and several schemas to store client data

o Leaflet used to generate maps, showing streets with different attributes such as distress rating o CSS and bootstrap are used for styling

o JavaScript is used at the client-side, along with Django template o AJAX calls are used for asynchronous retrieval of data from Django views

- Assisted in development of a CRM for cell phone repair shops (currently in use) o Written using PHP (XAMPP)

o Connected to Twilio and MobileSentrix through API for client messaging and search parts and orders, respectively

o Created crawling to get essential phone information from GMSArena

- Created a personal blog to organize my resume information o Django is used as the backend to handle the routing logic o A simple database in Postgres designed to represent various parts of a typical resume with different tables and relationships

o Nginx used as the reverse proxy server, and Gunicorn used as the WSGI to run the Django application

o The Django application deployed on DigitalOcean with a Linux-based deployment 2018-2023

Data Engineer / Project Manager – Fugro USA Land Inc., Newport Beach, CA

- Developed a Python application to calculate a composite index known as Pavement Condition Index consisting of over 120 different variables, involving complex logic.

- Created performance dashboards for clients using Power BI, Jasper Server, and AGOL, enabling clients to gain insights into their massive road distress data.

- Developed Python scripts to streamline conversion of standard distress delivery spreadsheets into XML and JSON formats, for importation into management system software. 2021-2023

- Created a pipeline in Python to automatically collect certain shapefiles from a server location, then create a master shapefile, joining with collection data which is gathered using API from Salesforce.

- Developed interactive Esri dashboard showing all data collection activities by Fugro with daily updates

(over 300,000 centerline miles surveyed annually). The solution was created by analyzing data resided in Salesforce, collected through API and sent to Esri Online through API.

- Developed cartographic scripts with Arcpy in ArcGIS Pro to automate creation of maps with consideration of panning, scaling, title and comment adjustments, when consistent maps are needed for many sites to be created in a short amount of time, programmatically.

- Developed Python scripts to convert over 20 years of historical GIS data (i.e., 150 million data points) between different LRS systems for Manitoba Infrastructure.

- Managed asset/pavement management projects for the listed cities using software platforms such as AgileAssets and PAVER.

- Conceptualized, planned, and executed the automated data collection for New Mexico Aviation project for 48 airports. Project duration 4 years and fee $2 million.

- Led the pavement group in all technical aspects to implement a new pavement management system in AgileAssets for the province of Manitoba, Canada. Project duration 9 months and fee $1 million.

- Trained Manitoba staff on AgileAssets in weeklong training sessions.

- Developed bespoke software manual for Manitoba Infrastructure.

- Developed pavement performance models for Alaska Department of Transportation using 20 years of historical data and updated the maintenance decision tree and performance models in AgileAssets system.

- Helped other staff in preparing/editing/improving proposals. Project Engineer – Nichols Consulting Engineers (NCE), Fountain Valley, CA

- Supported Pavement Management Programs (PMP) across southern California for the County of San Diego, Orange and several cities.

- Prepared Pavement management programs using StreetSaver & Paver programs.

- Performed field reviews for quality control of walking, windshield and automated inspections.

- Conducted pavement walking inspections per ASTM D6433 (OCTA certified inspector).

- Conducted pavement designs for cities of Stanton, San Marino, Redondo Beach.

- Performed analyses to resolve linkage issues between the street inventory and shape file.

- Produced PCI and PMP related maps in Esri ArcGIS Pro and AutoCAD software.

- Connected through API to import and upload data, as it can be a future trend in PMP works.

- Gathered and analyzed asset data such as imagery through services such as Mapillary API. 2020-2021

Research & Teaching Assistant – National Center for Asphalt Technology (NCAT) at Auburn University, Auburn, AL

- Supported the national pavement preservation pooled fund study TPF-5(375) as a principal data analyst. Developed much needed performance curves for innovative preventive treatments.

- Experienced pavement inspector. Performed data-driven pavement forensic studies applied on NCAT’s preservation sites located on a low-volume road, Lee Road 159, and a high-volume road, US-280.

- Utilized advanced automation techniques to improve work efficiency where sizable repetitive tasks are needed to be handled on a regular basis; as a case in point, automation of crack mapping which is implementable in a hassle-free overnight operation.

- Supported “Civil Engineering Materials” undergraduate course and “Design and Production of Asphalt Paving Mixtures” graduate course for seven consecutive semesters.

- Provided laboratory report writing tutorials and guideline with special emphasis on enhancing students’ writing skills leading to high quality written reports. Provided ample feedback on reports to pave the way for students’ future career success.

- Dissertation Research Project

2017-2019

- National Partnership to Determine the Life Extending Benefit Curves of Pavement Preservation Techniques, Pooled Fund Study TPF-5(375), MnROAD/NCAT Joint Study. Role: Principal Data Analyst Principle Investigator: Adriana Vargas Funding: $4.8 million Sponsorship: DOTs: AL, AR, CO, GA, IL, KS, KY, MD, MI, MN, MO, MS, NC, NY, OK, PA, SC, TN, TX, WI, and WV; and Federal Highway Administration (FHWA) and Foundation for Pavement Preservation (FP2). Civil Engineer – SBR INTERNATIONAL EPC COMPANY, Sheikh Bahaee Science & Technology Park, Isfahan, Iran

- Assisted in land development, access road and drainage design for a national-scale industrial plant, resulted in successful design and construction of the project for the largest iron ore production facility in Iran (Gol-E-Gohar) (Google Maps link). As a result, the design team was awarded a second contract for a second plant.

- Designed railway extension sections for Iran Steel Company expansion project. Assisted in surveying of the existing railway tracks, design connector parts along with new site development for the expended sections (Google Maps link).

- Assisted in land development for a railway station, and also in design of railroad tracks (geometry and pavement) for Zarrin Shahr, Iran railway station (Google Maps link). The land development included access road design, parking design, green space design, loading platform design, retaining wall design, and finally drainage design.

- Worked on several civil engineering projects worth millions of dollars. Handled tight deadlines and successfully delivered implementable designs. As such, promoted to the lead designer position for a small design team. Responsibilities included proposal preparation, project coordination, conceptual and detailed designs.

- Gained experience through contracted projects. Most projects required an initial grading plan, design of roadways for longitudinal and vertical profiles, detailed corridor making, cross sections, and also typical cross section showing areas in vicinity of roads (right-of-way area), retaining walls, and finally parking and green space designs according with the industry design standards (AASHTO, etc.).

- Actively participated in frequent road and railway project revision/troubleshooting sessions and project progression visits to advance project goals and to satisfy client needs. Proactive in anticipation of future needs to minimize project complaints.

- Conducted geometric (using Civil 3d) and pavement (Pavement ME) design trainings for junior engineering staff and interns, saving the company about $15,000 in external training costs. 2013-2017

EDUCATION

Ph.D. in Civil Engineering

National Center for Asphalt Technology at Auburn University - Auburn, AL Dissertation Research: Establishing stochastic performance models for preventive treatments and quantifying the life-extending benefits

2017-2020

Master of Science in Transportation Engineering

Isfahan University of Technology, Isfahan, Iran

Thesis research: Assessing pavement damages due to heavy freight vehicle operations using weigh-in-motion data

2010-2013

Bachelor of Science in Civil Engineering

Arak University, Arak, Iran

Emphasis: Transportation Engineering

2005-2009

CODING/SOFTWARE/FRAMEWORK EXPERTISE

Programming Languages: Python, JavaScript, PHP, VBA, MATLAB, .Net C# (AutoCAD) Web Development: Django, Html, CSS, Bootstrap

Database: PostgreSQL, MySQL, Oracle

Visualization: Power BI, Tableau, Jasper

GIS: ArcMap, ArcGIS Pro, AGOL Geoprocessing tool development using ArcPy, GeoPandas and ArcGIS API, Leaflet Statistical: SAS, JMP, SPSS, R

Road, Rail and Land Development: AutoCAD Civil 3D, Autodesk Storm and Sanitary Analysis, and Autodesk Vehicle Tracking Pavement Management: Cartegraph (certified), AgileAssets (certified & trainer), Paver™, StreetSaver® Pavement Analysis: AASHTOWare Pavement ME, PerRoad, PerRoadXpress, Kenlayer, WESLEA, AASHTO-93 pavement design, WESDEF, and BAKFAA, Elmod

AWARDS

Kenyon Fellowship, National Center for Asphalt Technology (NCAT) 2017-2019 George & Betty Luger Fellowship, Auburn University 2017 Civil Engineering Department Fellowship, Auburn University 2017 Iran National Scholarship Awards for Bachelor and Master of Science Studies 2005 & 2010

Contact this candidate