Joel Ramos

Data Analyst @Wood Mackenzie

Calgary, AB, CA

During my role as a Data Analyst, I optimize reporting capabilities by developing MS SQL queries to efficiently pull data from internal databases, supporting Research Analysts\' needs. Additionally, I lead efforts to integrate third-party data by developing Oracle SQL and Python queries, ensuring comprehensive data sources for dashboards and reports. I also conduct regular data integrity checks to enhance the accuracy and reliability of internal databases.Notable accomplishments:• Improved data acquisition by creating Python scripts to scrape historical data from third-party providers and government websites, specifically for oil and gas information.• Streamlined service requests by designing and implementing Data Team\'s service request process using MS Forms and Power BI.• Increased team productivity visibility by developing and deploying Power BI dashboards, providing insights into Data Team\'s performance.• Improved efficiency by redesigning internal processes, reducing redundancy, and achieving 50% faster process completion rate.

Mount Royal College

Project Management Extension Certificate

AMA University

Bachelor of Science (BS)