Alejandro Castillo
Germantown,MD
Overview
4
4
years of professional experience
Work History
Case Manager, Data Analyst
Community Support Services
10.2019 - Current
- Created new procedures of development during the COVID-19 period
- Planned a variety of meetings with new strategies for individuals with disabilities
- Led activities for beneficial support aspects of families and clients.
- Coordinated essential services for clients, resulting in improved overall well-being and self-sufficiency.
- Monitored ongoing cases closely, adjusting case management strategies as needed based on evolving circumstances or new information.
Warehouse Logistic Manager
Canteen
- Audited employee benefit plans to verify compliance for 25+ employees with plan assets
- Investigated new resources for maintaining machinery at the warehouse
- Produced complete documentation of past and new inventory.
- Managed cross-functional teams, ensuring smooth coordination between warehouse operations, procurement, and shipping departments.
- Trained new staff on job duties, company policies, and safety procedures for rapid onboarding.
- Conducted research to address shipping errors and packaging mistakes.
Civil Engineer Intern
Ecomuni Construction and Engineering
- Managed project management for buildings infrastructure in commercial locations
- Developed documentation for spending and machinery utilization for civil engineers using pivot tablets
- Updated blueprints by implementing new measures for house development and construction
- Worked along with industrial and civil engineers to find new implementations of machinery in proper projects.
- Utilized state-of-the-art software tools to create detailed engineering drawings, facilitating seamless project execution.
- Contributed to successful project delivery by maintaining meticulous documentation throughout each phase of the design process.
Business Analyst Intern
Bank of America
- Produced data analysis to observe risk in many investment transactions
- Documented risk analysis using Python, and pivot tables
- Learned coding skills with R, and RStudio followed by implementation of Python and SQL
- Presented new strategies to maintain budget in spending transaction for infrastructure.
- Assisted in data analysis and interpretation to support business decision-making processes.
- Developed detailed reports for management, providing insights into project progress and potential opportunities.
- Performed quantitative analyses of financial data to assist in budgeting, forecasting, and performance monitoring efforts.
Billing Specialist Intern
Duron's Law Firm
- Helped with documentation from existing and new clients
- Attended several courts cases and meetings with attorneys
- Utilized SQL to determine number, age, location costumers represented in court for past 4 years and new customers in current year.
- Ensured compliance with industry regulations by staying up-to-date on changes in billing rules and guidelines.
- Developed customized reports for management, providing valuable insights into trends, anomalies, and opportunities for improvement in the billing process.
Agricultural Engineer Intern
Syngenta Co
- Shadowed agricultural engineers how to update and put into work irrigation systems around land
- Updated medical records for animals in a local farm where milk in one of the main sources of exportation in Central America
- Planted a variety of common grains in a local rural area with machinery
- Took seminars with agricultural engineers to understand development of agricultural and resource economics.
- Assisted farmers in adopting innovative technologies for enhanced productivity and profitability.
- Utilized remote sensing technology to monitor crop health, informing timely intervention strategies for disease prevention or treatment.
- Streamlined post-harvest storage procedures to reduce spoilage rates while maintaining product quality during transportation or distribution phases.
Education
Master of Science - Cybersecurity And Information Assurance -Present
Western Governors University
Millcreek, UTBachelor of Science in Economics -
University of Maryland
College Park, MDAssociate's degree in Accounting and Finance -
Montgomery College
Rockville, MDSkills
- SQL
- Tableau
- Data Analytics
- Data Visualization
- Python
- Pivot Tables
- Excel
- PostgreSQL
- Bilingual (English, Spanish)
- Structural Analysis
- Data Validation
- Process Mapping
- Database Maintenance
Data Analytics Training
- Data Analytics Certificate Course, Break into Tech
- SQL: Querying and Managing Data, Khan Academy
- Tableau Creator, Tableau
Data Analytics Visualization Projects
- Product Revenue Dashboard, Identified stores with the lowest and highest sales rates, quantified revenue by product, and identified average revenue by account; published a Tableau dashboard to track KPIs.
- COVID-19 Rates Dashboard, Quantified COVID-19 vaccination rates over time, by country, and by income group; published a Tableau dashboard to visualize results.
- Superstore Sales and Profitability Executive Dashboard, Quantified sales, profitability, profit ratio, and sales per customer. Visualized profit ratio by city on US map. Quantified monthly sales by segment and category over time by profitable vs. unprofitable orders.
- Electronics Store Database Design, Designed an electronics store database using SQL and analyzed statistics by product.
- Furniture Store Sales Analysis, Quantified sales rates per category, group, date, and purchase location, and determined most and least profitable store locations.
Timeline
Case Manager, Data Analyst
Community Support Services
10.2019 - Current
Warehouse Logistic Manager
Canteen
Civil Engineer Intern
Ecomuni Construction and Engineering
Business Analyst Intern
Bank of America
Billing Specialist Intern
Duron's Law Firm
Agricultural Engineer Intern
Syngenta Co
Master of Science - Cybersecurity And Information Assurance -Present
Western Governors University
Bachelor of Science in Economics -
University of Maryland
Associate's degree in Accounting and Finance -
Montgomery College