Joel Lopez

Dedicated and detail-oriented professional with a background in business analytics and experience in Python, HTML, CSS, and Excel. Proven ability to analyze data, develop insights, and create solutions to complex problems. Seeking to leverage analytical skills and a collaborative approach in a role that allows for personal growth and contributes to organizational success. Committed to fostering innovative ideas and driving efficiency in dynamic environments.

Google Data Analytics

• Data Preparation and Visualization: Cleaned and organized data using spreadsheets and SQL; created visualizations with Tableau and Google Data Studio.
• Statistical Analysis and Problem-Solving: Applied basic statistical concepts to interpret data and identify trends, making data-driven recommendations.

Google IT Automation with Python

• Python Programming: Gained proficiency in Python for automating common IT tasks, including scripting and troubleshooting.
• System Administration: Learned techniques for managing system operations, using command-line tools, and automating system configurations.
• Version Control and Automation Tools: Developed skills in using Git and GitHub for version control and implemented automation solutions to enhance operational efficiency.

Google Cybersecurity

• Fundamentals of Cybersecurity: Developed a strong understanding of core cybersecurity principles, including threat analysis, risk management, and security protocols.
• Network Security and Monitoring: Learned to implement security measures, monitor network traffic, and identify vulnerabilities using industry-standard tools.
• Incident Response and Recovery: Acquired skills in responding to security incidents, conducting forensic analysis, and developing effective recovery plans to minimize impact.

IBM Data Analyst

• Data Preparation and Cleaning: Mastered techniques for collecting and preprocessing data, including handling missing values and outliers to ensure data integrity.
• Exploratory Data Analysis: Developed proficiency in exploratory data analysis (EDA) to uncover insights and patterns, utilizing Python libraries.
• Business Insights and Decision Support: Learned to translate data findings into actionable business insights, enhancing strategic decision-making through effective reporting and presentation skills.

LinkedIn Excel Essential Training

• Fundamental Excel Skills: Acquired foundational knowledge in Excel, including navigating the interface, entering data, and utilizing basic functions and formulas for calculations.
• Advanced Functions and Techniques: Developed proficiency in advanced Excel features, such as VLOOKUP, data validation, and automating tasks with macros to enhance productivity and efficiency.

Python Password Analyzer Project-

Developed Python scripts to analyze and attempt to crack encrypted passwords from a specified file. The project involved:

• Password Matching Functionality: Implemented a function to compare guessed passwords against encrypted values, reporting matches along with relevant details such as line number and encrypted output.
• Automated Password Guessing: Created a function to systematically try various password combinations using multiple strategies:Utilized a predefined list of common passwords to identify potential matches.
  Explored a comprehensive word list to enhance guessing accuracy.
  Generated character combinations of different lengths for a more exhaustive search.
  Combined words with numbers and capitalized versions to increase the likelihood of success.
  
• Performance Reporting: The application tracked the total number of attempted passwords, providing insights into the effectiveness of different guessing strategies.

This project showcased problem-solving skills, Python programming proficiency, and an understanding of basic encryption techniques in a practical context.

Python Text Analysis Project-

Developed a text analysis application that processes and analyzes literary works to provide recommendations based on textual similarities. Key features included:

• Text Processing: Implemented techniques to enhance text analysis by stripping punctuation, removing common stop words, converting text to lower case, and employing stemming algorithms.
• Literary Recommendation Engine: Created a recommendation function that identifies and suggests the most similar literary work based on user input, utilizing a dictionary to map file names to their respective titles for user-friendly output.
• Data Handling: Managed and analyzed text files, employing efficient data structures for storing processed text and ensuring accurate comparisons between literary works.

Collaborative Business Initiative: Recycling Project-

Developed a sustainable business idea focused on recycling in collaboration with a group, aiming to generate revenue while promoting social good. Key activities included:

• Concept Development: Designed a business model that addresses recycling challenges, promoting environmental sustainability while ensuring profitability through innovative solutions.
• Team Collaboration: Worked effectively with team members to gather insights, conduct market research, and refine the recycling concept, fostering a collaborative environment for innovative thinking.
• Presentation Skills: Created and delivered a compelling PowerPoint presentation that outlined the recycling business idea, highlighting its environmental benefits and financial projections, effectively communicating the vision to stakeholders.

Web Development Project: Dice Roller Application

• Developed a web page that simulates rolling a six-sided die based on user input for their favorite number (1-6) and a roll count (1-100).
• Implemented input validation to ensure numbers are within specified ranges, with automatic adjustments for invalid entries.
• Displayed key statistics including total rolls, average, and frequency of each die outcome, emphasizing the user's favorite number using inline styling.
• Utilized JavaScript for interactivity and DOM manipulation, and created an external stylesheet for enhanced design.

Business for Social Good Group

• Engaged with a college group focused on exploring ways to integrate social responsibility and ethical practices into business models.
• Facilitated discussions on innovative strategies for creating positive community impact while maintaining profitability.
• Collaborated with peers to share insights and develop actionable ideas for promoting sustainability and social equity in business practices.

Excel Data Analysis Project on Borrower Default Risk

• Analyzed borrower demographic information and default risk by creating pivot tables to assess charged-off rates across income levels, DTI ratios, FICO scores, and home ownership, visualizing findings through bar charts.
• Conducted detailed calculations using Excel functions, including average income for specific occupations and charged-off rates, providing insights into lending trends.
• Developed scatter plots to examine relationships between interest rates and charged-off rates, including regression analysis to predict outcomes.
• Created new variables for income, DTI, and FICO categories, enhancing data analysis and segmentation for improved risk assessment.