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
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
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
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
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:
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
