TRACY L. BOUSE
*** ***'s Walk ? Auburn Hills, MI 48326 ? 248-***-**** ?
ablr25@r.postjobfree.com
BACKGROUND
I am a professional with expertise in data analysis and reporting. I work
quickly and accurately analyzing and supplying information to a variety of
different departments and senior executives on key performance indicators.
I also have extensive experience in the budgeting process for expense and
revenue.
PROFESSIONAL EXPERIENCE
DYKEMA GOSSETT, PLLC, Detroit, MI FINANCIAL REPORTING
MANAGER [2008- Present]
. Responsible for all productivity and financial reporting for large law
firm (300+ attorneys) to include billable hours, billings & collections,
and expense budget to actual analysis
. Coordination of annual revenue/expense budget setting procedures for firm
. Development of standard billing rates for all attorneys/timekeepers
. Lead administrator for transition of reporting software and all reporting
output to Business Objects/Business Intelligence
. Handle the design and creation of improved performance management
reporting using a variety of different software, using mostly Business
Objects/Business Intelligence
. Maintain web based intranet reporting page for all attorneys and
executives
. Assist member attorneys with ad hoc data requests needed to manage
practice group performance and practice development expenses
. Assisted in establishing Business Intelligence profit module for the
firm. Create and analyze profit and net income reporting from attorney
level to total firm
GMAC MORTGAGE, Troy, MI
SENIOR FINANCIAL ANALYST [2000 - 2008]
. Acted as a liaison between Business Development department and IT in
determining use of mortgage origination computer programs (PILOT,
Lendscape, Eclipse) as a tracking device for business sources, including
involvement in writing business requirements, supplying properly formatted
data sets, and testing functionality
. Acted as the point of contact between Business Development managers and
Corporate Accounting Department in cases of cost/budget concerns or
questions
. Kept business units informed of any production/financial reporting issues
and status of those issues
. Forecasted phone volume and mortgage production for specific marketing
campaigns / sweepstakes
. Business plan forecasting of operational budget, sales production
. Extracted data employing Business Objects for use in performance
management reporting
. Designed, created and distributed all business development performance
and activity reports to senior executives. Includes weekly and monthly
reporting
. Analyzed market opportunities for GM Dealers and GM Suppliers for
business development, using contact management software, CRM
(Salesforce.com, Siebel)
. Compared market opportunity to actual performance metrics to identify
open areas for concentration
. Applied self created matching system for the relation of marketing
programs directly to call volume / mortgage production to discern program
viability. Successful in identification of over $120 million dollars in
mortgage production volume
. Monitored Profit & Loss statements for 5 cost centers
PROGRAM ADMINISTRATOR [1997 - 2000]
. Managed mortgage lead data tracking in contact management program (ACT)
. Prepared lead tracking and call volume reports for senior management
. Telephony manager responsible for the creation and maintenance of a
nationally routed 800 line for lead distribution
. Assisted in the creation of marketing materials for direct mail and
marketing campaigns
. Responsible for the collection, distribution and tracking of marketing
leads from direct mail programs
. Analyzed trend changes in call volume and mortgage production to discern
viability of marketing programs
MARKETING COORDINATOR [1994 - 1997]
. Managed team of marketing coordinators whom ensured correct pricing and
lock term for mortgage loans
. Managed team of individuals responsible for mortgage loan file setup to
include the ordering of credit, appraisal, and flood certificates
. Responsibilities included all of the Michigan retail mortgage branch
network, National Direct Lending, as well as all National Relocation loans
CROSSLAND MORTGAGE, Troy, MI
MARKETING COORDINATOR [1992 - 1994]
. Worked with all mortgage brokers to ensure proper mortgage rate pricing
and lock time
. Operational manager for the office
EDUCATION
OAKLAND UNIVERSITY, Rochester, MI
BACHELOR OF SCIENCE IN MARKETING
SKILLS
. Very proficient in Microsoft Word, Excel, Power Point and Business
Objects Desktop Intelligence
. Intermediate skills with Microsoft Access
. SQL- Good understanding of the language and the ability to write queries
and link tables