Summary
Overview
Work History
Education
Skills
Timeline
Generic

Stephanie Castillo

Bristol

Summary

Dynamic FP&A Analyst with a proven track record at RTX, excelling in strategic financial planning and variance analysis. Adept at delivering data-driven management reports and fostering collaborative teamwork. Recognized for reliability and accountability in executing financial projections and enhancing budgetary processes, driving informed decision-making across the organization.


Overview

18
18
years of professional experience

Work History

FP&A Analyst

RTX
07.2023 - Current
  • Executes financial analysis, research, budgets, and forecasts to support business plans.
  • Responsible for developing analysis and projections and conducting small projects.
  • Executes financial analysis, research, budgets, and forecasts to support business plans.
  • Reviews, analyzes and interprets financial and budgetary reports to develop observations and preliminary recommendations.
  • Develops P&L, balance sheet and cash flow analysis and projections.
  • Develops analysis on budgets, forecasts, inventory, and / or sales margins.
  • Provides interpretation of financial data in spreadsheets, charts, and reports.
  • Audits financial practices to ensure accuracy and compliance with regulations, laws and standards.
  • Analyzes and prepares annual budget for payroll related and other cost centers for Enterprise Services corporate finance (spring and fall brochures included for Payroll, Procurement, Vendor Master, etc.)
  • Monthly preparation, analysis and presentations for Latest Estimates (actuals vs. budget) for cost centers under ES (Payroll, Procurement, Vendor Master, etc.)
  • Monthly, quarterly and year end journal entries required for general ledger closing for related cost centers
  • Quarterly and year-end accruals analysis and journal entries for contractors and vendors related to ES corporate finance
  • Creates Purchase Orders (including but not limited to initiating PO requests, ES Intake forms, etc.) by working with cost center owners, contracts department, and Procurement team in order to efficiently create POs in lieu of manual processing of
    invoices in WPR (SAP invoicing system)
  • Conducts small-scale projects, ad hoc project requests
  • Manual processing invoices for related ES related cost centers

Robert Half Senior Accounting Contractor

Robert Half
03.2020 - 06.2023
  • Prepare latest estimate templates for year-after-year analysis
  • Prepare and process international salaries monthly reclass
  • Prepare company-related merger analysis and process journal entries, if applicable
  • Prepare and process month-end, quarter-end and year end journal entries including Cost Element reclass and accrual entries by cost center
  • Generate analytical accounting reports as needed by management
  • Provide accounting, financial, and administrative support for Corporate Payroll and related business units involving contractor and vendor invoices
  • Initiates Purchase Order (“PO”) process for Corporate Payroll and related business units
  • Coordinate and provide training for other business units in handling initial PO setup process
  • Coordinate and provide training for other business units in handling invoice submissions in WPR/SAP
  • Process contractor and vendor invoices for Corporate Payroll and related business units
  • Troubleshoot vendor master related setups and inquiries for SAP/WPR
  • Collaborate with Vendor Master Team to ensure vendor payment
  • Track contractor invoices for billing and accrual entry purposes using SAP PRO & SAP APEX
  • Collaborate with vendors to resolve billing/payment issues

Senior Accounting Specialist

Pratt & Whitney
05.2017 - 06.2019
  • Administered the financial requirements for the GP7000 collaboration agreements which included processing timely invoices and wire payments and provided financial reporting packages that meet contractual obligations with collaboration partners
  • Performed monthly closing entries and reconciliations supporting the revenue and risk sharing agreements with collaborators
  • Analyzed and reported account information for monthly closing meetings with Engine Alliance program office
  • Provided and maintained customer relations and support which included a visit to MTU in Munich, Germany as a result of MTU’s aftermarket agreements
  • Forecasted collaborator balance sheet and P&L accounts in support of quarterly OMM and monthly management letters
  • Supported collaboration accounting special projects as required on a monthly & quarterly basis, GAAP and ASC 606 revenue recognition related journal entries and adjustments, SOX testing of procedures and controls, provided audit request support

Senior Accounting Analyst

ESPN
04.2014 - 05.2017
  • Reconciled Disney domestic and ESPN International daily commercial spots in ESPN in-house system and in a third party
    system Wide Orbit.
  • Generated and sent ESPN and Disney monthly invoices to clients
  • Completed sales requests including but not limited to post air adjustments, credit adjustments, reissues of invoices, contract
    changes, current month adjustments and cosmetic changes
  • Maintained and completed Disney monthly account reconciliations and assists in other monthly/quarterly report
  • Provided mandatory auditing and SOX related samples and testing
  • Maintained and created inventory analysis, per inquiries billing, miscellaneous billing and manual invoices thru SAP
  • Assisted with quarterly closing process: journal entries and post close financial reporting
  • Engaged as point contact between Disney ad sales teams, commercial traffic teams, and the Disney credit department
  • Was responsible for building platform between Wide Orbit and NCS/SAP for automatic revenue journal entry process

Senior Accountant

SS&C Technologies
10.2007 - 07.2011
  • Responsible for fund accounting daily accruals, cash entries and other general ledger adjustments, monthly accruals and
    closing entries, daily NAV, position and bank reconciliations
  • Presented and prepared financial statements on an annual basis in a deadline-oriented environment while ensuring statements
    conform to Generally Accepted Accounting Principles (GAAP)
  • Part Time Accountant January 2013 - July 2013


Education

Bachelor of Science -

Fordham University
Bronx, NY
05-2004

Skills

  • Strategic financial planning
  • Reliability & Accountability
  • Data-driven management reporting
  • Variance analysis expertise
  • Effective time management
  • Proficient in managing multiple tasks
  • Clear and concise communication
  • Interpersonal skills
  • Collaborative Teamwork

Timeline

FP&A Analyst

RTX
07.2023 - Current

Robert Half Senior Accounting Contractor

Robert Half
03.2020 - 06.2023

Senior Accounting Specialist

Pratt & Whitney
05.2017 - 06.2019

Senior Accounting Analyst

ESPN
04.2014 - 05.2017

Senior Accountant

SS&C Technologies
10.2007 - 07.2011

Bachelor of Science -

Fordham University

Similar Profiles

CREATE PROFILE