Raphael Rueda Email & Phone Number

Colombia

United States

As a data analyst in my office, I play a pivotal role in extracting, cleaning, and analyzing data to provide insightful reports that drive understanding of our office's performance. Leveraging Python, I utilize Pandas for efficient data manipulation and management, while also employing Matplotlib and Seaborn for comprehensive data visualization. These libraries enable me to create informative charts, graphs, and plots that effectively communicate trends and patterns within our datasets.For web scraping tasks, I utilize Selenium to automate data extraction from various online sources, ensuring we have access to up-to-date information critical for our analyses.In terms of web development, I use Streamlit to develop interactive data applications and dashboards. This platform allows me to create user-friendly interfaces that facilitate easy data exploration and interpretation for stakeholders across different departments.For deployment, I rely on Docker and Azure DevOps to ensure seamless and scalable deployment of our data applications, ensuring they are accessible and reliable for users.Additionally, Excel and Power Query remain essential tools in my toolkit, especially for data cleaning and transformation tasks where their robust functionalities help maintain data integrity and enhance usability.Overall, my role revolves around transforming raw data into actionable insights through rigorous analysis, clear visualization, and informative reporting, thereby driving informed decision-making and optimizing our office's performance.

United States

Developed a Python Selenium script to automate the extraction of real-time data from a law firm's Laravel PHP website, focusing on case management metrics. CSV files containing detailed case information, including creation timestamps, status updates, and completion timestamps, were downloaded.Processed and cleaned the extracted data using Microsoft Excel, leveraging Power Query for transformation and structuring. Implemented a query function to import data from the downloaded CSV files and utilized Excel's Power Query feature to clean and transform the raw data into a structured format suitable for analysis.Designed and implemented an interactive dashboard within Excel to visualize key performance metrics, including case drafting time, status distribution, and case progression dynamics. Excel's pivot tables, charts, and conditional formatting rules were employed for data visualization and analysis.The dashboard was utilized by higher hierarchy management, including attorneys, for real-time reporting in management meetings, providing insights into operational efficiency and performance. Engaged in an iterative feedback loop with the immigration paralegal and management to identify and prioritize specific metrics for measuring legal assistant performance and case status accurately. Continued refinement of the dashboard based on evolving data requirements and feedback from stakeholders.

United States

Served as an intake and sales specialist, assessing immigration cases eligibility, retaining clients, and handling payments. Utilized Google Apps Script, Google Calendar API, and Python Selenium to develop a CRM call log tool in Google Sheets, quadrupling data capture rates. Expanded database to encompass 16 dimensions of potential client metadata. Facilitated effective communication of insights for informed decision-making. Implemented robust database for detailed analysis and marketing insights, integrated with Looker Studio dashboard for seamless analysis. Automated report generation and streamlined client acquisition processes. Integrated with case management systems and Google Calendar for direct profile and event creation. Enhanced workflow efficiency through Google Apps Script automation. Ensured accountability and oversight over tasks assigned to virtual assistants. Reinforced commitment to accurate reporting and efficient task management through transparent processes and integrated systems.

Colombia

Offered private tutoring sessions in thermodynamics, fluid mechanics, and materials science to university engineering students, catering to diverse college students from various colleges and faculties across the city.Provided independent, personalized math and physics instruction to high school students requiring additional one-on-one tutoring.Designed customized lessons in math, physics, and engineering subjects like statics, dynamics, and strength of materials to civil, electrical, and mechanical engineering undergraduates, preparing students for projects, proofs, and tests through personalized instruction and tutoring.

Colombia

Proficient in Customer Relationship Management (CRM): Effectively managed billing and sales inquiries from AT&T customers, utilizing advanced CRM systems to navigate accounts, address concerns, and process transactions swiftly and accurately.Exceptional Communication Skills: Demonstrated strong verbal and written communication abilities in providing clear and concise explanations of billing details, sales offers, and service options to customers, fostering positive interactions and resolving issues promptly.Problem Resolution Expertise: Developed a keen aptitude for troubleshooting and resolving complex billing discrepancies, sales inquiries, and service-related issues, employing analytical thinking and resourcefulness to ensure customer satisfaction and retention.Sales and Revenue Optimization: Leveraged product knowledge and persuasive communication techniques to identify upselling and cross-selling opportunities, contributing to increased revenue generation and the achievement of sales targets within the AT&T customer service environment.