César Ignacio Pérez De la Rosa
cesarignac@gmail.com - LinkedIn - GitHub - Brooklyn, NY 11238
Software Engineer
Content:
Education
COOP Careers - Data Analytics Apprentice - June 2024
Engaged in a 16-week apprenticeship program, acquiring expertise in data cleaning, transformation, analysis, and visualization using SQL, Python, and Tableau, alongside continuous professional development.
200 hours of instruction time with a hands-on mastery of data tools, communication training, networking, and client work with actual companies.
City University of New York, Brooklyn College Computer Science - May 2023
Relevant coursework: Python, Web Application Development, Data Structures, Databases.
BS in Computer Science, CUNY Brooklyn College, Brooklyn, NY – May 2023
Technical Skills and Certifications
Certifications: Google Analytics Professional Certificate (Coursera)
Programming Languages & Visualization: React, Express.js, Node.js, Sequelize, TypeScript, JavaScript, Python, SQL, Excel (Pivot Table and Vlookup), Google Sheets, Tableau, Git, Linux Terminal, GitHub, HTML, CSS, Figma, Java, Pug, C++
Languages: Spanish (Native), Portuguese (Fluent)
Work Experience
Cohesive Robotics, Full Stack Web Developer Intern - Jun 2023 – Aug 2023
- Created end-to-end React UI web app to control autonomous robots that polish factory-grade surfaces as part of a demo for the CEO to gain new clients.
- Designed a 10+ table database in SQLite to store product details and surface finishes to connect to Sequelize and Express.js with RESTful APIs for end users to select and identify proper settings for service polishing.
- Designed UI mockup in Figma and presented to 4 company executives to show the impact of the robotic polisher for final implementation with positive feedback on the simplicity of the project itself.
BioMimetic & Cognitive Robotics Lab - Brooklyn College, Full Stack Web Developer Intern - Jan 2023 – May 2023
- Engineered user interface of a website aimed at gathering data on lab-studied animals from external contributors, facilitating valuable data collection for research purposes.
- Worked in tandem with backend developers to define precise user-side data requirements for form creation, guaranteeing accurate data transfer to the server.
- Utilized the Pug template engine and CSS to develop a multi-page user interface, enhancing user engagement and interaction with the application.
Projects
Impact of COVID-19 on NYC High School Education, Tech Stack: Tableau - March 2024
- Collaborated within a team of five to analyze multiple datasets using Tableau, assessing the effects of budget cuts, attendance records, and teacher-student ratios on regent scores and inform citywide educational policy decisions.
- Revealed through data analysis that an average teacher-student ratio of 13 and a budget of over $30.1K per student had minimal impact on the declining regent scores in New York City, providing critical insights to policymakers.
- Delivered a well-received presentation to an audience of over 20 students and instructors, sharing data-driven insights and recommendations for enhancing regents exam scores, which was praised for its structured analysis and clarity.
Squirrel Spotter, Tech Stack: PostgreSQL, Node.js, Express.js, HTML, CSS, JavaScript - Dec 2022
- Developed a PostgreSQL database to efficiently categorize details of squirrel sightings, such as geo-location coordinates, identifying features, and status, enhancing data organization and accessibility.
- Integrated CRUD functionalities with Node and Express, enabling users to intuitively create and update entries on squirrel sightings, improving user engagement and data accuracy.
- Designed a multi-page user interface using HTML, CSS, and JavaScript, delivering an interactive experience for users to report and browse squirrel sightings.
- Deployed a website moving through the entire development process from conception to launch.
- Incorporated user feedback into the development process in order to make the user interaction more intuitive.
- Designed wireframe and mockups using Figma for the website before the implementation phase.