Learn Data Skills
Edward Garcia

Edward Garcia

Senior Credit Analyst

NextEra Energy

Technologies

Insightful strategist, envisioning new possibilities through data foresight.

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

NextEra Energy Resources | Jun 2023 - Present

Development Financial Project Manager, Interconnections

▪ Launched a comprehensive financial analysis framework for a collateral portfolio exceeding $2B, improving forecasting accuracy by 35% and enabling real-time assessment of cash, credit, guarantees, and bonds. ▪ Reduced manual reconciliation time by 65% by automating financial data processes using advanced Excel formulas, Power Query, and Python Scripting. ▪ Developed an interconnection data analytics platform that standardized cost tracking across 300+ projects, enhancing strategic planning capabilities and project controls. ▪ Perform regular audits and variance analyses, directly influencing executive decision-making and improving financial strategies endorsed by VPs and SVPs. ▪ Led a cross-functional initiative with Operations, IT, Credit, Legal, Compliance, and Treasury teams, increasing organizational visibility into interconnections and related financials by 40%, measured by reduced reporting discrepancies and improved capital allocation.
Show More

MN8 Energy | Aug 2022 - Jun 2023

Senior Financial Operations Analyst, Asset Management

▪ Implemented the Yardi Lease Accounting module to manage over $900M in Right of Use assets, achieving annual savings of $50K and improving operational efficiency by 25%. ▪ Rolled out the Yardi Accounts Payable module, reducing manual data entry time by 50% and realizing yearly savings of $126K. ▪ Enhanced financial operations by identifying and executing improvements across Finance, IT, and Operations teams, fostering better cross-functional collaboration.

Goldman Sachs | Dec 2020 - Aug 2022

Financial Operations Analyst, Asset Management

Goldman Sachs Asset Management (GSAM), Credit Alternatives, Renewable Power Group, within the bank's Asset Management Division (AMD), Financial Operations. • Focused on invoice consolidation by partnering with Asset Managers and recommended particular parent entity billing that reduced invoicing volume by 60%. • Constructed a static reporting infrastructure that standardized payables metrics across the company, saving 240 monthly hours of manual reporting. • Partnered with colleagues to systematically drive accounts payable turnover ratio, reducing average days payable ratio from 45 days to 3 days across the entire fleet.

BNY Mellon | Aug 2020 - Dec 2020

Hedge Fund Analyst, Middle Office Operations

• Monitored and reconciled trades on a daily basis, ensuring that all discrepancies were identified and resolved in a timely manner. • Conducted regular audits of trade data to ensure accuracy and integrity. • Collaborated with cross-functional teams, including traders and operations staff, to resolve issues and improve processes. • Assisted with the onboarding of new funds, including the set-up of trade feeds and the reconciliation of historical trades. • Utilized financial systems, such as JDEdwards, to track and reconcile trades. • Worked closely with clients to ensure that their trade data was accurate and up-to-date. • Demonstrated strong attention to detail and the ability to work accurately under tight deadlines.

Marriott Vacations Worldwide | Jul 2019 - Aug 2020

Corporate Accounting Intern, International

• Spearheaded automation of complex bank reconciliation entries through ongoing transactional trend analysis in excel, reducing time needed for closing procedures by 65%. • Methodically analyze multi-currency data before and after Marriott acquisition in the general ledger, to precisely determine variances, including errors in data mapping, and make recommendations to improve workflow. • Reengineered Oracle PeopleSoft data queries for integration of PeopleSoft 9.2 using SQL, reducing time required for data mining by 40%. • Provide Mexico team members with support and reporting for ad hoc requests, including variance detail, data procurement, and assist with month and year-end reports.

Vistana Signature Experiences | Dec 2017 - Jul 2019

Corporate Accounting Intern, International

• Completed entire month end close process (prepared and analyzed monthly journal entries as well as the Balance Sheet and Trial Balance financial statements and Credit Cards in Transit calculations according to US GAAP and Mexican FRS guidelines). • Completed account reconciliations and analysis of critical Balance Sheet accounts and Intercompany accounts. • Worked closely with internal audit ensuring Sarbanes Oxley compliance as well as with external auditors during quarterly reviews for Mexican Statutory audits.

My Education

Take a look at my formal education

Bachelor of Science in Business Administration (B.S.B.A), FinanceUniversity of Central Florida | 2020
Associate of Arts (A.A.), Business Administration and Management, GeneralSanta Fe College | 2016

Powered by

  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free