LiveCareer-Resume

v p database application developer business reporting resume example with 20+ years of experience

Jessica Claire
Montgomery Street, San Francisco, CA 94105 609 Johnson Ave., 49204, Tulsa, OK
Home: (555) 432-1000 - Cell: - resumesample@example.com - - -
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
2012 to Current
V.P. Database Application Developer / Business Reporting 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
2011 to 2012
SSRS Developer - TSQL Coder / Analyst 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
2009 to 2011
Senior Financial Analyst SQL Analyst / Report Writer 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
2007 to 2009
Senior Cost Accountant 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
2006 to 2007
Financial Analyst: Valuation & Risk Monitoring (Mortgage Servicing Rights) 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
2005 to 2006
Senior Risk Analyst: Hedge Correlation and MSR valuations 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
1999 to 2005
Senior Accounting Analyst: Multiple Progressive Titles 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
Expected in 1998 to to
BBA: Finance & Management
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

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

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:As seen in: