Alex Ramos-Hernandez Email & Phone Number

San Francisco, California, Us

Assessed, Designed/Architected, Implemented financial & banking-institutions digital infrastructure to leverage VGS proxies. Deep knowledge in packet analysis, bytestream manipulation (Efficient algorithm), encryption, TCP, HTTP, SSH, proxies, AWS services (Transfer Fam), Airflow, Kubernetes. All around great communicator to varied audiences, worker, and team player. Like to lead by example and take ownership of my projects to put out great work. Prefer Functional over OOP but employ both!

Oakville, On, Ca

Designed and created production middleware & automations to solve complex business logic related to geospatial, financial & numerical data derived from sensors pertinent to all models and types of vehicles and transportation infrastructure. Mitigated and contributed to resolution of entrenched flaws both in external and internal systems via systematic root cause analysis methodology, leveraging complex SQL and rapid (python) scripting that led to improved architectures that consume/expose APIs.Created various modular command-line automation tools that reduced error and improved delivery of custom-formatted data derived from fusing various APIs' response (eg. example salesforce, myadmin, mygeotab, google, powerbi, google maps APIs - for the latter, leveraged postgres server database connectivity using odbc. leveraging Javascript, C#, & python tooling among others to accomplish this.Implemented ETL (Extract, Transform & Load) pipelines to clean large-volume datasets. Created complex and reusable SQL queries w/ time series analysis and regex to allow easier diagnostic of a user-specified activity. Produced automated excel / google spreadsheets / PDFs reporting. Set up cloud server infrastructure (w/ Terraform, in GCP ) within Linux environments. Experienced and comfortable working with: Big-query SQL, pandas, pydantic, flask, javascript. familiar setting up IaC w/ Terraform targeting Azure, GCP and AWS clouds. Proposed detailed architectures to replace legacy monolith systems to instead use docker-deployed web-apps w/ Postgres + React frontend with flask APIs. Mentored junior colleagues on python development best practices using git utilizing a paired programming philosophy. Python-specific workflow: poetry, requests, asyncio, black, jupyter nb, airflow, rst-based auto-documentation sphynx. Enjoyed producing efficient and robust code that scaled well within a microservices architecture.

Oakville, On, Ca

Provided guidance to partners seeking to add their software integrations in the Marketplace & ensured quality assurance and adherence to technical criteria was met throughout the rigorous technical vetting process. Developed key software integrations to enhance our core SaaS platform (primarily used to manage geospatial data products) using JavaScript within nodeJS framework. Documented these using various formats inclusive of architecture diagrams & API sequence diagrams in SVG format (Inkscape/Figma). Provided analysis and technical solutions to emergent software problems by reviewing code, and evaluating API calls (mine SQL w/ Python & pandas to analyse geospatial datasets and validate events). Often debug .NET (C#) / Python & JavaScript based integrations that leverage Geotab's SDK. Collaborate with technical committee and developers to update SDK documentation on github . Implemented efficient large-data processing algorithms to reveal insights from vehicle sensor data: e.g. potential fuel loss events observed from abnormal fuel-sensor readout.

Oakville, On, Ca

Investigated, troubleshooted, and identified resolutions or escalated to software development issues pertinent to our SaaP platform and the embedded system Geotab offers, A vehicle GPS tracker that connects via OBDII port and leverages GPS, WiFi, cellular (2G, 3G, 4G) and other sensor-data. Pertinent to the above tasks, extensive use of Javascript, SQL (google BigQuery), Postgres, Node, Linux Server, Intel Dashboards (redash) & Colaboratory - Jupyter python scripts was made all the while maintaining customer relationships throughout the resolution of escalated problems. Created custom 'Add-Ins' using HTML, JS, CSS to add value to the end customer experience of the SaaP. Assisted marketplace partners and other integrators to resolve software issues.Contributed extensively to the community forums to resolve technical questions.

Calgary, Ab, Ca

As part of the engineering team, I was accountable for supporting the development of underground/overhead electrical-distribution designs for new builds/repairs/overhauls of Toronto Hydro owned infrastructure . With previous experiences in Nuclear plant electrical design & quality control supervision, I was able to quickly adapt to the standards, technologies, and procedures used/required by Toronto Hydro and Valard construction. Beyond quickly learning the best practices of design and supporting the engineering team, I also wrote (Python, Sikuli) scripts to automate the creation of BOMs and other documentation, thereby made these processes 5 times quicker than previous manual-only methods.

Niagara Falls, Ontario, Ca

• Audited high and low voltage systems inclusive of: UPS(s), accumulator batteries, PLC(s), security & fire systems, motors, transformers, switchboards, cabling, lighting, and receptacles.• Managed master documentation certifying tests, controls and inspections of critical systems. • Excelled as lead customer interface during activities related to close-out audits of the RWSB.• Identified and developed innovative filing and organizational practices to increase efficiency.• Consulted and collaborated with design agency engineers to resolve non-conformances.

Toronto, On, Ca

• Provided rapid resolution to contingent events as member of interdisciplinary engineering unit. • Coordinated repair/replacement of electrical and I&C systems and/or their components.• Authored peer-reviewed design products to analyze, catalog, and resolve complex problems. • Oversaw safety, standard, and procedural adherence during design and project execution phase.• Liaised with procurement and supply chain to properly select and expedite arrival of highly engineered items.

Toronto, Ontario, Ca

• Received United Way grant ($10,000) to development a youth STEM program. • Designed and instructed introductory STEM curriculum to eight youth (aged 11-17) for 10-weeks.• Oversaw purchasing of materials, accounting, and self-auditing/reporting to grant donors. • Instructed subjects including: circuit analysis, electronics, soldering, python game development and Arduino robotics. Successful final projects included 4x4 LED cubes, synthesizers & simple robots.

Hamilton, Ontario, Ca

• Supported logistics during three school terms for over a dozen large-scale university events.• Volunteer Coordinator of two "Welcome Week" events; distributed $30 gear for 20,000+ students.• Provided event supervision, coordinated volunteers in setup and take-down of venues including inflatable tents, chairs, podiums, AV equipment, collapsible tables, signage.• Assisted event managers to ensure safety, quality, and smooth running of large-scale events.