Livecareer-Resume
Jessica Claire
  • Montgomery Street, San Francisco, CA 94105
  • H: (555) 432-1000
  • C:
  • resumesample@example.com
  • Date of Birth:
  • India:
  • :
  • single:
Summary
  • Hands-on analyst experienced in report creation and automation. Extensive direct communication with CEO, CFO, COO, CTO, CIO, Controllers, Director of SCM, Director of Manufacturing and VP of Sales
  • Advanced database user in data manipulation, management and querying
  • Advanced user of Excel, Experienced SQL coder, excelling in researching how to accomplish complex logical queries, novice Visual Basic programming (VBA)
  • Experienced in financial planning and modeling, multi-business unit reporting, month end close
Accomplishments

Century Payments Cornerstone Award Winner

Experience
V.P. Database Application Developer / Business Reporting, 2012 - Current
Materion Delta, UT,
  • Design and develop database objects, indexes and optimized queries in support of proprietary mortgage origination application (DDL & DML)
  • Adhere to waterfall and agile software development models
  • Interact with front end business users and managers to develop, maintain and distribute KPI reports
  • Follow strict deployment schedules and protocols within 20 development environments, 20 test environments, load stress environment and production
SSRS Developer - TSQL Coder / Analyst, 2011 - 2012
Columbus Data Services City, STATE,
  • Develop stored procedures for extracting requested information from SQL databases
  • Compile detailed reports and create ad hoc reports with SSRS
  • Analyze complex data systems and document data elements, data flow, relationships and dependencies
  • Interpret user requirements and implement a solution to suit their needs
Senior Financial Analyst SQL Analyst / Report Writer, 2009 - 2011
Century Payments, Inc City, STATE,
  • Assimilate new processor data into existing 100 table db schema, audit existing data feeds and communicate the implementation of new requirements including testing and validation of new and existing data
  • Create analytical reports and models representing operational metrics and financial results to all levels of internal users
  • Leverage knowledge of corporate data and relationships to improve existing projects, initiatives and corporate wide understanding of information
  • Portfolio valuation analysis and preparation, including observing deactivation rates, cash flow cycles and other empirical historical data which might help the valuation
  • Forecast performance of newly created business channels
Senior Cost Accountant, 2007 - 2009
BancTec, Inc City, STATE,
  • Forecast $1.4M of annual inventory reserves and present analysis to Sr. VP and Director of Operations resulting in 99% reduction of account variance and improved resource planning
  • Support manufacturing and supply chain management with operational analytics resulting in transparent monthly metrics including weekly purchase price variance forecasts, cycle count and scrap reports and an inventory reserve forecast package
  • Provide budgeting and forecasting support to Sr. VP, Director of Operations and Director of Manufacturing
  • Maintain local instances of custom databases for business needs
Financial Analyst: Valuation & Risk Monitoring (Mortgage Servicing Rights), 2006 - 2007
EMC Mortgage Corporation/JPMorgan City, STATE,
  • Analyzed 400,000 serviced loans by calculating additions, pay downs, conditional prepayment rate speeds ("CPRs"), net present values ("NPVs"), servicing fee rates and delinquencies
  • Collaborated with multiple parties such as the trade desk, Bear Stearns Financial Analytics and Structured Transactions group (FAST) and unbiased third parties to verify valuation results of our Mortgage Servicing Rights ("MSRs")
  • Identified and explained valuation variances from multiple parties to top level internal managers and external auditors to prevent negative adjustments
  • Oversaw trade activity and reconciled balances related to mortgage backed securities composed of Fixed, Scratch & Dent and Adjustable Rate Mortgages
Senior Risk Analyst: Hedge Correlation and MSR valuations, 2005 - 2006
First Horizon Home Loan Corporation City, STATE,
  • Performed IRR valuations and stratification of 600,000 loans in MIAC software modules
  • Tracked hedging activity in accordance with FAS 133 and FAS 140 guidelines
  • Prepared P&L report packages analyzing our MSR asset's reaction to market conditions
  • Prepared generic valuations of MSR portfolios for auditors tracking our valuation methods
Senior Accounting Analyst: Multiple Progressive Titles, 1999 - 2005
Verizon Services Organization, Inc City, STATE,
  • Learned and implemented RAMIS (JCL/SQL) syntax to retrieve financial data, initiate, test and control system enhancements for our UNIX driven inventory database
  • Created and tested new accounting control table logic and provided intra-office end user support
  • Provided inventory accounting controls support to Verizon affiliates which outsourced their process to us
  • Prepared SEC report narrating capital/expense ratios for multiple entities and provided director with monthly employee expenses analysis
  • Narrated monthly, quarterly and annual account variances for $1.2B inventory related activity, $500M annual WIP activity and $125M annual un-invoiced receipt accruals
  • Developed reports for SEC filing by clearing annual accruals of $2.2 billion and analyzing and collecting $3 billion in individual records
  • Supported FP&A through researching activity based job costing data and communicating business fluctuations with FP&A, auditors and internal management
  • Responded to customer inquiries, handled in excess of 100 pieces of mail weekly
  • Assisted with compliance reporting of escheats for 35 Verizon legal entities
Education
BBA: Finance & Management, Expected in 1998
-
Texas A&M University - College Station, TX
GPA:

Finance & Management Double Major

Skills

SAP 8 years, Advanced Excel 17 years, databases and SQL 17 years, SSRS 1 year, IBM mainframe applications and batch processing 4 years, RAMIS 2 years, FOCUS 1 year, Assorted query analyzer products 4 years, Monarch 2 years, Business Objects 1 year, AutoTester, PeopleSoft beginner, Fidelity beginner, Tableau beginner, Gretl beginner

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Disclaimer

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score
could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

73Average

resume Strength

  • Length
  • Personalization
  • Strong Summary
  • Target Job

Resume Overview

School Attended

  • Texas A&M University

Job Titles Held:

  • V.P. Database Application Developer / Business Reporting
  • SSRS Developer - TSQL Coder / Analyst
  • Senior Financial Analyst SQL Analyst / Report Writer
  • Senior Cost Accountant
  • Financial Analyst: Valuation & Risk Monitoring (Mortgage Servicing Rights)
  • Senior Risk Analyst: Hedge Correlation and MSR valuations
  • Senior Accounting Analyst: Multiple Progressive Titles

Degrees

  • BBA

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in: