Ricardo Gomez
Houston
Summary
Developed skills in collaborative, fast-paced business environment, specializing in data analysis and process optimization. Excels at identifying inefficiencies and devising data-driven solutions, with strong competency in project management and stakeholder communication. Seeking to transition into new field to apply and expand these transferable skills.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Power Markets Analyst
Oxy
05.2023 - Current
- Developed data-driven solutions leveraging Power BI, Power Automate, and Power Apps, and AI Builder, reducing manual processing time of various data entries by up to 50%.
- Integrated the Smart Meter Texas (SMT) API for real-time energy usage insights for energy traders.
- Designed a 25-year forecasting report to assess proposed Low-CI project impacts on load and emissions, enhancing long-term planning efficiency.
- Developed a custom Power App for emissions calculations, streamlining project assessments and reducing manual data entry time.
- Attends 36 ERCOT committee meetings annually, staying informed on NPRRs and market policy changes to provide strategic insights and ensure alignment with Oxy’s goals.
- Served as the Energy Manager for a Chicago plant, overseeing energy price forecasting, and cost monitoring.
- Collaborated with cross-functional teams to identify opportunities for process improvement and increased efficiency.
- Improved internal knowledge sharing by developing comprehensive documentation outlining standard operating procedures for various tasks.
Consultant: Solutions Specialist – Data Visualization Developer
Deloitte
03.2022 - 05.2023
- Analytical and technical consultative expert tasked with supporting a large healthcare client
- Align with organizational policies, procedures, and practices
- Identify problems and requirements with current reporting
- Innovative in developing and designing new solutions to meet their reporting needs, including dashboards and reports
- Successfully utilize Power BI to develop and launch practical and cost-effective solutions
- Ensure on-time completion of each project within scope and to exact specifications
- Direct high-level strategic planning to assist the client in tracking and analyzing a $600M+ budget and $2B of estimated benefits
- Leverage subject matter expertise to develop a Portfolio Services Benefit Power BI Dashboard for the client
- Achieved recognition in the form of an award for performance excellence from the project's Managing Partner
- Thorough and detailed while extracting, transforming, and loading data from multiple Excel spreadsheets with Power Query and M functions
- Experienced in building and designing websites, applications, and products
- Closely collaborate with internal stakeholders in the development and design of reports of client dashboards
- Align with the JIRA Software Development Lifecycle to develop Power BI and Paginated reports for a state government client
- Detailed and complete in writing and fixing SQL queries to extract data from Oracle IBM SQL DB2
Data Engineering Analyst
Shell Oil Company
01.2020 - 01.2022
- Exhibited strong analytical expertise to assist in developing an in-house upskilling platform for approximately 800 data practitioners across Shell by deploying Azure learning environments
- Exhibited excellence, strength, and technical acumen while working with service managers to deliver a service from IT to the organization
- Surveyed users and redeveloped and redesigned services based on user experience feedback, data, and survey scores
- Utilized Databricks and Power BI to validate ETL pipelines for Trading and Supply data migration projects
- Implemented an Azure Data Solution needed to pass the Microsoft Exam DP-200 successfully
- Conceptualized, developed, and deployed an Information Management workstream using Microsoft Power Apps and Automate
- Power Automate: Created automated and scheduled Power Automate flows that utilized various connectors to complete routine and mundane tasks
- Automations leveraged loops, conditions, and apply-to-each actions
- Power Apps: Created SharePoint integrated Canvas Applications
- Apps connected to multiple data sources and contained complex Power Fx functions that ran smoothly without delay
IT Project Analyst
Shell Oil Company
01.2018 - 01.2020
- Demonstrated the ability to think strategically and critically to develop and deploy work processes to collect over 100,000 UX surveys annually and analyzed the data using SQL Server & Power BI
- Achieved successful objectives, including identifying $16M+ In annual savings in productivity
- Thorough and detailed in obtaining a user response rate of ~60% from over 40 IT Help Desks globally
- Instrumental in negotiating a $3M+ contract by collecting, cleaning, and extracting value-added information critical to the negotiations
- Exhibited excellence, strength, and technical acumen while consulting with several IT teams at Shell to modernize their reporting solutions by creating actionable visualizations for up-to-date insights
Education
BBA - Management Information Systems
University of Houston
Houston, TX05-2018
Skills
- Power BI (Data Visualization, DAX, M)
- Data Modeling & ETL Processes
- AI & Process Automation (Power Automate, AI Builder)
- Power Markets & Energy Analytics
- Energy Forecasting & Load Analysis
- Business Intelligence & Data Strategy
- Process Improvement & Automation
- Azure (DevOps, Data Solutions)
- Jira & Agile Methodologies
- Cross-Functional Collaboration
- Training & Mentoring
- Executive Reporting & Presentation
Certification
- Microsoft Certified: Data Analyst Associate
- Microsoft Certified: Azure Fundamentals
Timeline
Power Markets Analyst
Oxy
05.2023 - Current
Consultant: Solutions Specialist – Data Visualization Developer
Deloitte
03.2022 - 05.2023
Data Engineering Analyst
Shell Oil Company
01.2020 - 01.2022
IT Project Analyst
Shell Oil Company
01.2018 - 01.2020
BBA - Management Information Systems
University of Houston
Similar Profiles
Mario GuerreroMario Guerrero
Operations Manager at OxyOperations Manager at Oxy
Keith BlackKeith Black
Equipment Technician at OXYEquipment Technician at OXY
Cody MixxCody Mixx
Chemical Operator at OXYChemical Operator at OXY