Andrew James
Alexandria,VA
Overview
10
10
years of professional experience
Work History
Data Engineer
DCI Solutions
06.2022 - Current
- Builds data pipelines using Python on Airflow to create models and workflows for the client's workspace
- Automates the monitoring of data health system checks and data integration in a classified environment using PySpark
- Develops software in PySpark with the product development team and debugs issues related to software or model performance
- Developed data integration for client that allows them to receive a live feed of intelligence reporting and data to then ingest into Palantir Gotham.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
- Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
- Provided technical guidance and mentorship to junior team members, fostering a collaborative learning environment within the organization.
- Developed custom algorithms for advanced analytics, driving actionable insights from large datasets.
- Increased efficiency of data-driven decision making by creating user-friendly dashboards that enable quick access to key metrics.
- Proactively identified opportunities for process improvements, addressing inefficiencies through innovative solutions and implementing best practices in the field of data engineering.
- Implemented real-time data processing solutions for timely decision-making and improved customer experience.
- Conducted extensive troubleshooting to identify root causes of issues and implement effective resolutions in a timely manner.
- Managed identification, protection and use of data assets.
- Collaborated with data scientists to develop machine learning models by providing the necessary data infrastructure and preprocessing tools.
Space Systems Engineer
Mobius
08.2019 - 06.2022
- Developed various Python codes for quick turnaround solutions, including a trajectory generator that displays scenarios in SIMDIS, a code that generated a raid in STK and then converted that raid into a Jasper scenario, a code that generated the defended area charts for the battlespace study and converted the charts into a SIMDIS defended area chart which would allow users to see it in 3D and allow them to overlay radar coverage to get a better understanding of the scenario
- Developed an efficient process for secure data transfers, which has saved time for development work and has allowed for a detailed accountability process keeping the data organized for company security regulations
- Developed algorithms to model and simulate missile defense scenarios in Python with an integration with STK, as well as numerous C++ scripts and codes to facilitate the analysis process
- Defined a process for version control and software updates using GIT with the help of the Information Technology team which will assist the analysis team with ensuring that their software is updated, and their codes are organized within a version-controlled repository
- Created an algorithm in Python that takes the results file of an analysis simulation to automatically run and create a PowerPoint metrics package showing measures of effectiveness for the scenario simulated
- These packages were briefed to high up seniors within the DoD
- Developed the Model Based Systems Engineering (MBSE) pathfinder in Phoenix Model Center, a model that wrapped several algorithms to produce an assessment on a missile defense scenario
- This model was demonstrated for several seniors within the DoD and many of them pushed for integrating the model into the analysis process and for coordinating with other offices to see how it could benefit them
- Developed an algorithm in Python that facilitates the analysis of the life cycle for space-based sensor and weapon activities for the Ballistic Missile Defense System (BMDS)
- The algorithm incorporates concept definition, analysis of alternatives, demonstration and assessment, requirements definition, and technology insertion
- Developed tool in Python that performed an error analysis on position, velocity, and time gap for a scenario of a threat raid
- With this tool, the analysts were better prepared for life cycle analysis when dealing with satellite constellations and sensor activities for the BMDS
- Created interactive web graphs, using a Python and PowerPoint integration code, illustrating data for sensor systems and embedded these graphs within a presentation that was briefed to customer seniors
- These graphs allowed the customer to see sensor performance and characteristics and allowed for further analysis by other scientists.
- Evaluated new tools and technologies for possible integration into existing infrastructure environments.
- Documented system configuration, mapping and processes.
Thermal Imagery Scientist
National Geospatial Intelligence Agency
03.2017 - 08.2019
- Developed an automated tool in Python that applies machine learning algorithms, cloud applications, and Hypertext Transfer Protocol posts/requests to automatically generate key results regarding weapons of mass destruction issues for the intelligence community
- Prior to the implementation of this automated tool, scientists performed this function using inefficient manual processes
- Implementing this tool greatly reduced the time required to generate results and achieved more accurate and reliable estimates compared to human analyst results
- This tool uses open source Python coding and is inherently scalable
- Because of this scalability, the tool can automate analysis for other intelligence issues
- Assisted in building a Python tool that performed a trend analysis of an extensive dataset regarding certain issues for the intelligence community
- The tool is currently being adapted and improved so that data scientists and analysts are able to employ it and generate results for predictive analysis
- Once this tool is implemented, data scientists and analysts will no longer have to rely on outside sources for data that is already obsolete
- Built multiple tools that use Python coding and Matlab scripts that were integrated with other colleague's automation initiatives to be used in analytical reporting
- Mentored and managed two interns' projects that required algorithm development to address issues for the intelligence community
- These algorithms applied various statistical modules within Python, as well as generated results that were reported to high level seniors.
Systems Engineer II
Raytheon
11.2016 - 03.2017
- Provided operations and maintenance support for the Intelligence Community
- Supported a 24-hour per day, 7 days a week operations team that performs and provides assistance in support of vehicle operations activities
- Completed required training and maintained certification to execute real-time command and control activities and monitor vehicle and ground system telemetry
- Reported anomalous performance and interacted with other team members to validate operational requirements performance.
Sensor Engineer
BAI Inc
11.2014 - 10.2016
- Analyzed documents on Russian technological capacity, synthesized complicated technical data into a presentation, and presented it to clients at Washington Navy Yard and Pentagon
- Analyzed and tracked Russian overflight imagery of U.S
- Facilities and consolidate data into briefs that are submitted to these facilities
- Analyzed potential Open Skies Treaty digital sensors to assess capabilities and purposes and to ensure compliance with the Treaty
- Presented training briefs to U.S
- Naval facilities on Treaty on Open Skies overflights and their impact, and trained facilities to plan for, and protect their assets from, overflights
- Served as certified member of the Navy's Chemical Weapons Convention Challenge Inspection response team
- Attended an overflight imagery processing event at Wright Patterson Air Force Base to analyze the Navy's imagery analysis process changes as a result of improved Russian technology and resolve any areas of concern during imagery processing; and submitted these conclusions, along with predictions on how imagery processing will continue to evolve, in an After Action Report
- Conducted research on infrared technology and submitted a paper detailing suggested U.S
- Specifications for Treaty on Open Skies infrared sensors, which was later accepted by the Office of the Secretary of Defense as the official position of the U.S
- Represented the Navy in Open Skies working groups at the NGA, during which, representatives from all services discussed Russia's new Open Skies technological capacity and drafted updates to the treaty guidelines to accommodate these updates.
Project Engineer
Phoenix Technical Solutions
09.2014 - 10.2014
- Created an improved Engine Repair Manual
- Updated bill of materials databases
- Wrote new standard operating procedures for more efficient engine operation and assembly
- Trained and oversaw new employees in the operation and maintenance of Diesel engines.
Education
Bachelor of Science - Aerospace Engineering
Purdue University
West Lafayette, IN05.2014
Skills
- ArcGIS
- C
- C
- CNC Programming
- Computer Aided Manufacturing
- GitLab
- Julia
- MATLAB
- Python
- STK
- Spark
- SQL
- REST API
- Data Pipeline Design
- Data Migration
- Big Data Processing
- Data Modeling
- Spark Framework
- Scripting Languages
- Data Governance
- Data Analysis
Related Training
Amazon Web Services Workshop, Herndon, VA, 10/01/18, Trained on many of the AWS Services including, Amazon Sagemaker, S3, and Cloud Formation by exploring several use cases and working with datasets that were commercially available. The use cases included data analytics, comprehending social networks from text, building a real time analytic dashboard, and video analytics., Created an Amazon Sagemaker notebook instance and an Amazon S3 bucket for storing training data and model artifacts. These services were used to evaluate a dataset as well as perform data analysis through count vectorization. This exercise was performed with Jupyter Notebook which was used for downloading training data, building models, training models, and deploying them., Performed Exploratory Data Analysis (EDA) and trained a Neural Topic Model using Jupyter Notebook. Launched a Sagemaker training job using social media data and analyzed the trained model to infer patterns., Created analytic dashboards using Amazon Quicksight to analyze and visualize data stored in S3 buckets. Detected data formats in an automated fashion by building a crawler with Amazon Glue as well as queried tables that Glue generated., Generated an Amazon EC2 key pair for SSH into instances that were created in the AWS account and changed permissions for the key file using Linux.
Timeline
Data Engineer
DCI Solutions
06.2022 - Current
Space Systems Engineer
Mobius
08.2019 - 06.2022
Thermal Imagery Scientist
National Geospatial Intelligence Agency
03.2017 - 08.2019
Systems Engineer II
Raytheon
11.2016 - 03.2017
Sensor Engineer
BAI Inc
11.2014 - 10.2016
Project Engineer
Phoenix Technical Solutions
09.2014 - 10.2014
Bachelor of Science - Aerospace Engineering
Purdue University
Similar Profiles
Stevie PryorStevie Pryor
Software Engineer/Project Officer at DCI-SolutionsSoftware Engineer/Project Officer at DCI-Solutions
CHRISTINE ESTRADACHRISTINE ESTRADA
Account Manager at DCI INT'L I.T SOLUTIONS & SERVICES CORP.Account Manager at DCI INT'L I.T SOLUTIONS & SERVICES CORP.
Danyell HicksDanyell Hicks
Terminal Manager at Boasso Global / DCITerminal Manager at Boasso Global / DCI
Adam SandersonAdam Sanderson
Director, Operations, Plans, and Strategy at Office of the Assistant Secretary of the Army for Acquisitions, Logistics, and TechnologyDirector, Operations, Plans, and Strategy at Office of the Assistant Secretary of the Army for Acquisitions, Logistics, and Technology
Joshuah TincherJoshuah Tincher
Construction Crew Leader at Titan Erosion ControlConstruction Crew Leader at Titan Erosion Control