ERP Systems Administrator Resume

SUMMARY:

7+ years of experience accounting for private equity, 3+ years of experience accounting for various credit products (bank loans, credit derivatives, credit/loan funds, MBS/ Confidential, etc.), 6+ years involved in development of traditional Confidential .
Held various positions in both technology and investment accounting/operations roles with ability to bridge existing gaps and communicate effectively to both sides.
Expertise gathering requirements and modeling processes for the development of new systems to streamline operation of traditional and alternative investment strategies.

TECHNICAL SKILLS:

General Ledger Systems: Great Plains, Solomon, Platinum, FRX, Oracle ERP, Expandable ERP

Languages: MS Excel/MS Access VBA, T - SQL, PL-SQL, Visual Basic.Net, C#.Net, BPMN, XML, Matlab

Databases: SQL Server 2008/2012, Oracle 11, MS Access, Advantage

Reporting & Integration Packages: MS Reporting Services (SSRS), Crystal Reports 2008, MS Integration Services (DTS/SSIS), Actian/Pervasive Data Integrator (DI), Dell Boomi

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

ERP Systems Administrator

Responsibilities:

Responsible for organization ERP system supporting accounting and operational business units across North America, Europe, and Asia.

Confidential, Dana Point, CA

Co-founder, Business Analyst

Responsibilities:

Co-founder of software vendor providing integrated accounting products for alternative investment firms, mezzanine funds, credit opportunity funds, real estate opportunity funds, Confidential managers).
Responsible for developing investor and fund accounting business requirements for domestic and offshore entities.

Confidential, Santa Ana, CA

Quantitative Analyst

Responsibilities:

Responsible for investor/counterparty payment calculations and investor reporting on Confidential issuances, portfolio credit default swaps, and credit hedge/opportunity funds.
Prepared Financial Statements including investment positions, accrued interest, FAS 91 effective yield amortization calculations, and interest rate swap unrealized appreciation(depreciation).
Determined system requirements and developed VBA Excel model to calculate impact of CDS trades/substitutions on underlying CSO tranche subordination.
Model used in conjunction with Structured Credit Desk. Incorporated Bloomberg API into model.
Worked with Confidential, offshore corporate structures, unit trusts, master-feeders, separately managed accounts, and separate portfolio companies (SPC). Reviewed Indentures, Promissory Notes, ISDA Swap Confirmations, etc.

Confidential, Tustin, CA

Sr. Securities Analyst

Responsibilities:

Responsible for investor/counterparty payment calculations and investor reporting on residential and commercial MBS issuances, repurchase agreements, and real estate CDOs.
Developed cash flow model stress tests incorporating interest rate and prepayment rate shocks, and default analysis via Excel and Wall St. Analytics.
Modeled/administered CMBS issuances involving Whole Mortgage Loans, Senior/Pari Passu/Junior Participation Interests, and Companion Loans. Modeled/administered $3 billion CMBS Issuance (the majority of debt financings used via The Blackstone Group purchase of CarrAmerica Realty, the largest office financing transaction at the time).

Confidential, Calabasas, CA

Sr. QA Analyst

Responsibilities:

Responsible for stress testing system accuracy for all cash, money market, and fixed income transactions via creation of automated scripts and manual test plans.
Assisted in the development of system functional specifications for the FAS133 hedging effectiveness compliance module, Cash Flow Forecasting module (regression, seasonality, etc.), Value At Risk (VaR) module, and FX module (Forward trades, Currency Options, and swaps).

Confidential, Van Nuys, CA

Programmer Analyst

Responsibilities:

Responsible for converting GUI of legacy UNIX/COBOL system to client-server (VB/SQL Server).
Project lead for converting legacy reports to Crystal Reports; managed junior staff members.
Developed Binomial Interest Rate Tree based Option Adjusted Spread (OAS) module.
Responsible for maintaining portfolio performance/composite benchmark module (e.g. Modified Dietz, IRR, error tracking, etc.).

Confidential, Century City, CA

Loan Servicing Specialist

Responsibilities:

Generated mortgage payment statements including principal & interest, and tax and insurance escrow payments, demand statements, payoff amounts, and performed escrow analysis.
Responsible for the creation and monthly reconciliation of general ledger journal entries regarding mortgage/REO payments consisting of P&I, escrow, payoffs, and cash flow. Developed FRx reports.
Assisted with asset management functions such as valuations, cash flow projections, operating statement analysis, and property audits.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship