KRYSTAL A. BATTS
Dallas, Texas 75254
*****@********.***
COMPUTER SKILLS
Microsoft Office Suite, T-SQL, PL/SQL, Access, Visual Basic, XML, Business
Objects, MSP, Visual Studio, Toad, SQL Server Management Studio 2005 &
2008, Visio
EXPERIENCE
PRO Unlimited/First American Mortgage Services, Westlake, Texas (06/2013 -
08/2013)
Contractor/Business Systems Analyst
* Met with decision makers, system owners, and end users to evaluate
business and functional database
requirements necessary to meet business needs.
* Evaluated the efficacy and efficiency of existing system relative to
current and future business needs.
* Identified and established scope and parameters of systems analysis in
order to define outcome criteria
and measure-taking actions.
* Served as liaison between business unit and technology team to assure
optimal communications
regarding the ongoing technology effort.
Fannie Mae, Addison, Texas (05/2010 - 04/2013)
Sr. Business Manager/Analyst
* Partnered with consulting team to conduct and present the outcomes of
various critical process analyses,
identifying opportunities for operational and customer satisfaction
improvements.
* Lead contact for third party technology team and responsible for
maintaining a comprehensive
understanding of key deployment needs, statuses, escalations, and the
business benefits of all projects.
* Lead contact for third party escrow and reporting teams to assure the
rapid resolution of all escalated
issues. Successfully analyzed escrow and corporate advance
transactions for compliance with corporate
submission requirements.
* Developed SQL statements to extract data sets from large, complex, multi-
table relational databases for
analysis of servicer performance.
* Developed and maintained routine management reporting.
* Applied appropriate analytic methodologies to report servicers'
performance relative to KPI metrics on
a monthly basis.
* Worked with Portfolio Managers and Management team to identify and
develop analyses that quantified
servicing performance weaknesses, particularly regarding Early Stage
loan delinquencies and Loss
Mitigation timelines.
* Assisted internal analytics team with forecasting quarterly delinquent
loan volume expectations based
on YoY, seasonal, and other economic trends.
* Collaborated with multiple internal and external teams to define data
requirements and utility to support
various types of servicer performance analyses.
* Developed and implemented effective/strategic business solutions through
research and analysis of data
and business processes.
* Participated on cross-corporate teams commissioned to develop strategic
solutions around data needs,
comprehensive data management, and reporting systems.
* Participated on Technology Sub-Committee and assisted in evaluating
reasonability of technology needs
and the related costs.
EXPERIENCE (cont)
Fannie Mae, Addison, Texas (05/2010 - 04/2013)
Sr. Business Manager/Analyst
* Functioned as a liaison to internal departments and a consulting firm to
support the processes for
tracking open issues and updating/maintaining the contract in place
with the firm.
* Assisted with monitoring the deployment and utility of a key loss
mitigation system designed to
accelerate the completion of loan workout activities.
* Collected functional business requirements for FTP design and worked
with programmers to deploy and
test new tool.
Fannie Mae, Addison, Texas (09/2009 - 04/2010)
Project Manager
* Analyzed company activities, processes, and business rules to establish
Early Advance Funding
procedures and controls.
* Developed SQL statements to extract datasets from various Fannie Mae
systems, including Falcon,
DARTS, and Oracle.
* Lead contact for all servicers and internal partners regarding Fannie
Mae processes, business
requirements, and data requirements surrounding the efficient
implementation and maintenance of the
Early Advance Funding program.
* Developed and distributed reporting to servicers regarding any Early
Advance Funding activities that
were not aligned with their formal agreements.
* Conceptualized, constructed, and maintained Access databases used for
tracking, forecasting and
reporting on servicer Early Advance Funding utilization and to monitor
the servicers' compliance with
contract terms.
* Conceptualized and developed the full reconciliation process for the
Early Advance Funding program,
through which over $1 Billion was transacted.
* Gathered business requirements and developed a comprehensive
understanding of drivers that governed
software needs and selection.
* Conceptualized and mapped business processes that needed to be created
to support Early Advance
Funding activities.
* Defined the data triggers that activated any management decisions needed
to preserve an effective Early
Advance Funding process.
* Evaluated servicers' Early Advance submissions for data integrity and
reasonableness prior to
management issuing wire approvals.
TEK Systems/Fannie Mae, Addison, Texas (01/2009 - 09/2009)
Contractor/Business Analyst
* Partnered with systems teams to support the development of new
applications by providing
requirements and guidance.
* Conceptualized and developed an Access database to track and report
contractors' productivity relative
to management requirements.
* Developed SQL statements to extract data sets from various relational
databases.
* Developed and distributed both routine and ad hoc management reporting.
* Documented business requirements and created flowcharts of existing
processes.
* Responded to the needs of management and external entities for data and
analytical support.
* Translated business needs into technical requirements and ensured
requirements conformed to overall
objectives and specifications.
* Established and maintained methodologies to ensure on-going integration
of processes affecting
customer Operations.
EXPERIENCE (cont)
TEK Systems/Fannie Mae, Addison, Texas (01/2009 - 09/2009)
Contractor/Business Analyst
* Identified and pursued technological and process improvements to enhance
overall process effectiveness
and efficiency.
* Coordinated the execution of special projects that required timely
feedback from multiple contractor
servicer support teams.
* Responsible for end-to-end ownership of assigned projects.
First American Subordinate Lien Outsourcing, Westlake, Texas (06/2007 -
10/2008)
Sr. Business Analyst
* Evaluated system enhancement needs and initiated requests to programmers
accordingly.
* Used T-SQL to develop and maintain stored procedures and triggers in web-
based database.
* Used T-SQL to develop both internal and client reports with detailed
analysis in web-based database.
* Interfaced with end-users to collect business requirements for reporting
needs.
* Worked with business and IT partners to align technology solutions with
business strategies.
* Formatted and imported client loan files into inventory tracking system.
* Tested new import applications developed by third party system
technicians.
* Initiated corrections/updates on system tables as needed (T-SQL).
* Analyzed operations to determine opportunities to automate processes
(i.e., loan inventory
reconciliations, mortgagor payment postings).
* Developed and modified XSLTs to accommodate new and existing import
processes (XML).
Extyr/TXU Energy, Dallas, Texas (11/2006 - 06/2007)
Contractor/Sr. Operations Analyst
* Successfully conceptualized and constructed an Access database to
streamline a $1 Million monthly
commercial billing process pending the implementation of a permanent
software solution.
* Reviewed commercial contract terms for billing determinants.
* Designed new Access databases to accommodate the implementation of new
commercial billing
processes.
* Modified existing Access databases for commercial manual billings as
assigned such that statuses,
approved receivables, and waived fees may be tracked for management
reports.
* Provided billing instructions and formatted files for uploading into
billing system.
* Generated commercial billing reports detailing switch-away activity and
the cost impact.
* Created detailed, written procedures for new and existing processes as
assigned.
* Interfaced with Sales management and Systems personnel to determine
process goals/improvements that
required technical solutions.
Dual Access, Inc., Houston, Texas (4/2005 - 11/2006)
Office Manager
* Coordinated investor financing with title companies, loan officers, and
internal office contacts.
* Created online database to facilitate improved property status tracking,
company expenses, and sale
commissions.
* Worked with appraisers around Houston to evaluate property values prior
to initiating formal appraisal
requests.
First American Real Estate, Dallas, Texas (10/2003 - 4/2005)
Property Tax Research Team Lead/Database Administrator
* Trained and resolved escalated research cases for team composed of 24
members.
* Lead contact for client regarding escalated and unique research cases.
* Researched customer inquiries regarding delinquent property taxes, tax
sales, and escrow accounts.
EXPERIENCE (cont)
First American Real Estate, Dallas, Texas (10/2003 - 4/2005)
Property Tax Research Team Lead/Database Administrator
* Maintained and improved production database (Access) to facilitate
management report and individual
team members' performance tracking.
* Performed daily quality reviews to ensure staff was responding
effectively and timely to customer
inquiries.
* Distributed workloads to team members and assisted with establishing
productivity goals.
* Prepared quarterly Power Point presentations for client, detailing
current task volumes, property tax
forecasts, and year-to-year volume comparisons.
EMC Mortgage Company/Bear Stearns, Irving, Texas (1/2000 - 5/2003)
Accounting Analyst
* Analyzed corporate advance expenses for recoverability or write off
potential.
* Reconciled general ledger accounts totaling $1 Billion in loan
inventory.
* Successfully researched and resolved approximately $500 Million of
interest income that was
incorrectly booked on the general ledger.
* Prepared monthly interest income forecast associated with $1 Billion in
loan assets each month.
* Provided external auditors with reconciled asset schedules and
supporting information for income
projections each quarter.
* Investigated overhead expenses that may be correctly billed to
mortgagors or to investors.
* Created Access databases to streamline general ledger research
processes.
* Provided Bear Stearns asset management dept. with loan inventory
reconciliation based on most recent
sale and purchase transactions tracked in inventory database (Access).
* Performed journal entries to book interest income on EMC-owned loan
portfolios.
* Audited loan portfolios for potential acquisition qualification.
* Generated daily reconciliation schedules for Bear Stearns P&L
accountants and the local management
team.
* Performed expense reclassing journal entries to correspond with mortgage
industry expense
recoverability guidelines.
* Assembled monthly reports detailing outstanding claims and accumulated
overhead by department.
* Created PeopleSoft queries for accounts payable group upon request.
EDUCATION
Spelman College
Atlanta, GA
BA, English
University of Texas at Dallas
Dallas, Texas
MPA, Public Affairs