Alex Amaral Email & Phone Number

Worked in an engineering team working on data logger devices on electric busses and trucks. Worked to adapt existing telemetry logger data pipeline architecture to use Python Spark and Databricks Delta Table architecture and notebooks instead of on-site servers. Helped plan and execute code migrations, converted code for cloud migration including database migration of existing telemetry database, and was produced code notebooks with analysis, documentation, and charts to provide insights from live streaming data received from truck telemetry loggers in the field. Worked to plan, develop, test, and validate new data pipelines and dashboards as opportunities for analysis came up.Worked with team to provide data and analysis as needed with the goal that users become comfortable enough to get their own data as needed from the provided data pipelines and dashboards. Wrote documentation and code notebooks with in-line markdown documentation sometimes as "demo" notebooks to make it clear what the analysis was with runnable code snippets to verify function and purpose.Wrote code notebooks with full explanations of methods and data to encourage discussion, provide clear explanations, and facilitate repeatable research through providing live code to test and verify.

Troy, Michigan, Us

The Chief Data Scientist and Technical Manager is a multi-functional role responsible for identifying all the technical requirements to ensure that data flows from raw sources into analytics dashboards and applications in order to ensure that business units can get value from data collected in the field by utilizing Data Science products and internally-developed toolchains. To accomplish this, the Chief Data Scientist and Technical Manager will identify required roles and make hiring decisions to ensure that development and maintenance needs are adequately covered so that development roadmaps can be kept to schedule.This role will also provide technical insight to the team about intended product functionality, business needs, customer needs, potential new technologies and strategies, and will be able to make application stack technology selections based on each product’s use-case and needs as well as the skills within the team. This role will work directly with this software development team to ensure that all existing VIPR knowledge and progress is passed down so that new development can start in earnest with a full understanding of the existing codebase, it’s abilities, and areas where it needs to be improved, product roadmaps, and prioritizing new features and bugfixes.Ultimately, once all development and maintenance needs are covered for software development, this role will focus on Research and Development, growing the Data Science capability of the organization, which may include hiring Data Analysts for day-to-day business needs requiring a data resource, and for hiring Data Scientists to focus on large-scale analysis for the purpose of providing metrics for marketing, grant proposals, or identifying issues requiring engineer review.

Poway, Ca, Us

Software development for data collection and analysis of truck telemetry from data loggers. Writing ETL Python code for bulk data collection from REST APIs, live websocket data feeds, spinning up Linux OS VMs to compartmentalize application processes, designing scalable PostgreSQL table structure with TimescaleDB hypertable architecture, building automated ETL Python scripts to load database tables on a cron schedule, building charts and dashboards with Plot.ly and Dash, building and maintaining full stack informatics applications using Flask and Django, performing advanced data analysis to identify and diagnose problems in the field that require service technician attention or engineer review. Creating user-focused dashboard applications and live data monitor displays to summarize complex data simply and provide tools to simplify custom user investigation by engineers, technicians, and project managers.

San Diego, California, Us

Maintaining, documenting, updating, refactoring, and replacing legacy Python and R code, Jira API calls, CSV config files, and Oracle queries to perform statistical parametric analysis, generate bin wafer maps, and include in automated Excel and Word reports to be uploaded to Jira tickets for engineer review and release to the next stage of production. Using industrial supply chain data, parametric test data, production ticketing system data, and feedback from floor managers to ensure production lot data continuously loads to move shipments on time. Diagnosing, categorizing, documenting, and anlyzing data issues and working with multiple business areas to ensure chronic causes of problems are addressed and resolved. Integrating new data types into production flows, and writing new analysis scripts to facilitate engineer review of materials, or to diagnose newly-identified issues and ensure data quality and consistency through automated validity checks based directly on data spec documents. Writing new scripts to facilitate production and prevent outages through a focus on high reliability coding practices and a target of “zero maintenance” to ensure that new scripts are not the cause of delays in production. Scripts to automatically diagnose and categorize data issues so that the production floor can immediately start resolving issues without needing to wait for an analyst to investigate and respond. Creation of process flow diagrams, script documentation, systems analysis, and report writing to summarize important updates and issues and presentations to key stakeholders who may not be versed in programming or scripting in order to communicate key conceptual takeaways and discoveries to ensure that problems can be addressed objectively and resolved consistently.

San Francisco, California, Us

Manipulating, organizing, and standardizing data. Performing QA on data sets by analyzing input data, output data, and written code against processing requirements and historical data to elucidate apparent and non-obvious data issues. Primarily writing SAS scripts and macros, but also writing bash, awk, MySQL, PHP and Javascript on an as-needed basis. Coming up with means by which to automate day-to-day tasks as well as cleaning up commonly-encountered issues and writing a custom library shell scripts to handle common data-related tasks and processes.Performing data wrangling by writing custom scripts, then performing process improvement by generalizing scripts/creating templates, then automating template insertion and script calls, then automating data scanning and analysis to automatically generate template content and script calls to facilitate context-aware automation. Continually expanding and extending functionality, scope, and efficiency of generalized scripts and eliminating edge-case bugs with error-checking code and extensive testing.Continually working to improve task automation efficiency, congruency, and scope, while ensuring that project work is completed in a timely manner. Coordinating with team members to complete distributed data processing and QA the work of others. Solving complex and specific data-related problems by planning and executing programmatic algorithms that allow the automation of future client updates. and adjusting previous code to match current requirements if future data arrives inconsistent with previous format.Reading, interpreting, breaking down, and adapting legacy code in order to learn purpose, algorithm, and specifics behind code to reuse it in current needs. Interpreting code from various authors, from various teams, with various styles and established practices. Adapting code written for a specific proprietary software platform for reuse in another proprietary software platform.

Learned a great deal about the creation and maintenance of a database-driven website, the ins and outs of using xml and xslt to create extensible templates to systematically organize the content, structure, and style of a website, and a great deal about effective strategies for using scripts to simplify and automate otherwise overwhelming tasks to increase overall productivity.Used xml documents to organize metadata on scientific data sets. Used Linux command line to perform basic data wrangling operations. Used Excel and complex formulas to accomplish a number of data collection, analysis, and visualization tasks.Learned the basics of Linux command line operations as well as the basics of database-driven web applications and how to load data into a database using SQL or database administration applications.Learned a lot about basic data wrangling, data cleanup, and data manipulation needed in order to get raw data into a format where it can be loaded into a database application.Learned to follow the standards and practices of two separate managers simultaneously, along with time management in order to budget my time effectively to keep the work hours even across the board.Worked to collect and organize metadata for a wide range of scientific studies that provided us data that we cataloged and hosted available freely for public use.Helped perform research for some labs by volunteering for field work and providing analysis of collected data.

Learned a great deal about the day to day needs of a limnological research lab. Participated in physical construction of field equipment and programming them. Spent the majority of my time reorganizing and standardizing datasets from the past 50 years to the present, figuring out the most effective means by which to convey the data through SURFER 3-dimensional contour plots, and re-editing and re-creating either as requested by the lead scientist.

Participated in ecological research. Helped process samples and handled lab and field equipment. Helped in the field setting up and taking down experiments. Gained a first hand knowledge of many lab and field procedures and techniques.

Participated in cancer research. Helped process samples and handled lab equipment. Learned how to maintain cell cultures, practice sterile technique, isolate RNA and DNA, and use a spectrophotometer to check RNA purity. Gained a first hand knowledge of many general lab procedures and techniques.

Worked temporarily for Dr Pattee as a CGI movie creator to illustrate techniques described in his upcoming instructional manual. Used Cinema 4D to create animated 3D movies in order to demonstrate proper techniques for performing medical procedures on patients.

Bachelor Of Science, Aquatic Biology

Certificate - Website Development, Certificate - Website Development, Programming And Scripting, Computer Science And Information Technology

Computer Science, Biology, General Education