Fernando Rodriguez Email & Phone Number

Philadelphia, Pa, Us

Walnut Creek, California, Us

Functioned as Bytecode's expert in the modern data stack, leading the development, implementation, and on boarding of the Analytics Engineering Group.Implemented and optimized robust data pipelines using a modern data stack. For example implementing Fivetran, dbt, Snowflake/Snowspark and AWS Lambda functions to automate the ingestion and aggregation of multiple data endpoints, significantly improving data accessibility, processing speed, and overall reporting capabilities at large non-profit.Restructured and optimized BigQuery reporting models for a large biomedical company, resulting in a dramatic improvement in query performance. By reducing a 250GB query to approximately 200MB, I significantly lowered cloud computing costs and improved data retrieval times, providing the company with a much more efficient and cost-effective analytics infrastructure.Led the deployment of AI and machine learning models using BigQuery AI and Vertex AI for high-impact proof-of-concept projects, addressing complex data challenges for clients in the logistics and healthcare sectors. These models enabled predictive insights and optimized operational processes, paving the way for future AI-driven implementations.Developed cloud functions and add-ons for multiple clients to further expand their data capabilities and their BI connectivity including calling Prophet from dashboards and further enhancing Looker's download capabilities to allow for encryption, SSH-SFTP and direct messaging of users.Designed and develop Airflow DAG's both for ETL process but also for delivery of reports to multiple stakeholders. The streamlined reporting pipeline allowed for improved communication, reduced manual overhead and timely delivery of critical data.Provided technical expertise across multiple industries, helping both clients and coworkers leverage the modern data tools like dbt, Snowflake, BigQuery and Looker/Superset to drive better decision-making.

Walnut Creek, California, Us

Worked with small start-ups to large companies helping them understand their data, enable their developers, and provide expertise in both the modern data stack and generating actionable insights from their data.Implement data pipelines using the modern data stack including Snowflake, Big Query, Redshift, Fivetran, Airflow, Stitch, dbt, Looker, Tableau and Superset.Work in cross functional teams for clients to identify reporting needs, best ways to implement workflows for data transformation and identify cost savings opportunities.Manage short to long term engagements, identifying resources necessary, deliverables and allocation of time for small data teams.Develop reporting tools using a variety of SDK's using Typescript and React, interacting with Looker API endpoints. Create custom visualizations using D3.Implement python scripts to provide security, content, and user security in a Looker environment, as well as rapid deployment of microservices.Provide training for both developers and business users in both LookML and Preset, and create internal training materials for Bytecode’s consultants on topics like Python Looker Intergraiton, DBT startup, Javascript Event Capture and complex SQL logic.

Pittsburgh, Pa, Us

Led a team that provided business intelligence, operational analysis and engineering support to over 70+ domestic and international sites. Spearheaded rollout of telematics across TMS fleet and data analytics to help track performance of 6,000+ pieces of equipment.Developed automated processes for CAPEX projection of a $35M budget combining fleet, operational and OEM data. Designed IoT industrial mobile scales to provide weight information to production systems. Created simulation tool for layout of scrapyard operations based on historical data.Handled rollout of electronic reporting for auditing purposes regarding TMS Maintenance Operations. Created interactive dashboards for maintenance expense tracking, cost allocation and equipment operational cost per hour.

Pittsburgh, Pa, Us

Glassport, Pa, Us

Milwaukee, Wi, Us

Created a distributed computing program using Condor/MATLAB that used genetic optimization to design compliant systems for a number of tasks with ideal motionAnalyzed resulting optimization data to identify trends in generation of compliant mechanisms for diverse assemblies; insights allow quicker generation of systems given a certain task and geometryIdentified and applied mathematical constraints to guarantee robustness and success of designed systems

Milwaukee, Wi, Us

Designed and led lab experiments and projects focused on failure mechanics, component selection and design for a junior/senior level design of machine elements course.Lectured, graded, and mentored junior and senior students in dynamics of mechanical systems courses and design of machine elements.

Notre Dame, In, Us

Led experiments and discussions to teach the basics of microcontroller programming and electronic systems to junior mechanical engineering students.

Notre Dame, In, Us

Designed an electromechanical infinitely variable transmission for power flow control of a compressed air-gasoline hybrid system for start-stop applications.Prepared and presented a report on the state of the art of compressed air systems and infinitely variable transmissions.

Bachelor Of Science (Bs), Mechanical Engineering

Master Of Science (M.S.), Mechanical Engineering