Sql Server Project
Resume:
Cris E. Creswell
***** ******* ****** ***** ****: 904-***-**** / Cellular:
Jacksonville, Florida 32223 **********@*******.***
QUALIFICATIONS:
. 20 plus years of experience performing operational and financial
analysis of data
. 19 overall years of SQL experience (report creation, complex
reporting, queries, etc.)
. 16 years of mortgage banking experience in default servicing, investor
accounting, corporate accounting, and other servicing functions
. 12 years of SQL programming experience (databases, reports, queries,
stored procedures, etc.)
. 10 years of experience designing highly complex database reports
. 20 years of SQL querying tools experience, working with Toad and SQL
Server Management Studio proficient at use of 2000, /2005 /2008 and
2012
. 3 years of Crystal Reports experience.
. Experience developing complex reports against LPS Desktop Application
. Exposed to 2008 SSRS and SSIS
. Experience in use of LPS MSP Applications, including Passport and bulk
data extracts
. Completed Mortgage Banking Association coursework in Default
Servicing, Loan Administration, Secondary Marketing, and Quality
Control
. Experienced at business analysis and project related activities
. Effective and efficient written and verbal communication with all
levels of an organization
. Experienced at process analysis and process improvement
. Experience working with Visio in process flow documentation.
. Experienced with training operation, accounting, and human resource
professionals on advanced techniques and functions in spreadsheets
(i.e. pivot tables, v-lookups, and macros) and database applications
EDUCATION:
. BS, Business Administration, Ohio University (Concentration:
Production Management and Quantitative Analysis)
FURTHER EDUCATION:
. Florida State College of Jacksonville
. Oracle Database Administration
. SQL & PL/SQL Programming
. VB Net Programming
EXPERIENCE:
July 2013 to August 2013
Randstad Technology / Wells Fargo
Consulting - Process Analysis
. Performed review of governing rules and regulations pertaining to
Consumer Finance Protection Bureau, Dodd-Frank Legislation and Make
Home Affordable changes to determine potential impact on default
mortgage servicing operations and MSP system changes.
. Project Cancelled Due to Budget Cuts
May 2012 - May 2013
Lender Processing Services Default Services, Jacksonville, Fl
Senior Reporting Analyst
. Worked on a team dedicated to servicing multiple clients default
activities.
. Responsible for working with subject matter experts and other
stakeholders on the development and refinement of functional and
technical requirements, for providing validation files and finally for
deployment and testing of solutions both in user acceptance testing
and in final post production review.
. Within production environment developed stored procedures and Crystal
Reporting for company servicing approximately 50 % of the mortgage
market industry.
. Responsible for assisting in developing reports during transition of
business model from Outsourcing to Select Services. Developed
reports critical to billing, reconciliation of multiple clients
portfolios and for implementing changes reducing amount of time
required to perform critical functions.
. Performed tuning of reports to allow reports to be delivered within
specified servicing agreements with clients and internal operations.
. Responsible for mentoring junior developers on development of stored
procedures and report development.
January 2011 - May 2012
PNC Mortgage, Jacksonville, FL
Senior Business Analyst
. Worked on a team dedicated to default reporting
. Wrote SQL code using Oracle Developer and SQL Server Management Studio
both 2005 and 2008
Against production databases containing in excess of 100 millions of
records.
. Created complex SQL database reports (data extracts, stored
procedures, multiple joins, etc.)
. Responsible for meeting with subject matter experts and stakeholders,
for creating functional and technical requirements, for responding to
inquiries from developers, for creating testing requirements, for
producing validation files used in user acceptance testing and for
approval of solutions to production.
. Responsible for reporting to the Office of Comptroller of Currency,
regarding mortgages and home equity product.
. Responsible for providing direction on development of automated
solutions related to reporting. Advised developers both locally and
nationally on changes necessary to improve reporting results. Advised
management on risk associated with meeting required deadlines.
Developed testing procedures.
. Perform rating agency reporting including Standard and Poor's, and
Fitch
. Manage data modification reporting involving both core and HAMP
modifications.
. Worked with Sarbanes Oxley internal auditors preparing analysis
related to Trouble Debt Restructure for corporate assets.
. Created and published various investors reports on modification
activity
. Responsible for the OCC mandated remediation of access databases
moving existing processes from legacy Access 2003 to SQL Server 2008
R2.
August 2009 - January 2011
JP Morgan Chase, Jacksonville, FL
Mortgage / Business Analytical Manager
. Worked in the external reporting group
. Wrote PL SQL and SQL code using TOAD against Oracle databases against
production databases containing in excess of 100 million records.
. Responsible for external reporting to Office of the Comptroller of
Currency.
. Performed rating agency reporting: Moody's, Standard and Poor's, and
Fitch
. Worked involved migrating SQL Server databases reports and LPS
passports to Oracle enterprise data warehouses.
January 2008 - December 2008
National Audit, Jacksonville, FL
Business Analyst
. Wrote reports for internal and external auditing purposes
. Used SQL Server 2005 and MS Access.
. Developed and supported multiple database reporting applications
including automation of dashboards, used for reporting operational and
financial results to internal and external clients
. Worked with all levels of the organization to streamline processes
whereby creating cost savings and process efficiencies
. Developed PowerPoint and other graphical presentations for both senior
management and external client meetings
April 2005 - November 2007
Kemper, a Unitrin Company, Jacksonville, FL
Data Analyst II
. Performed statistical reporting and data analysis using DB2 and Access
to analyze complex data and to create internal reports
. Responsible for reporting approximately $1 billion in premiums related
to property and casualty insurance to ISO and TICO, this was
approximately 20 million records annually
. Created reports for multiple company portfolios, coordinating with
sister companies on complex transactions and reporting requirements
involving commercial and private insurance portfolios
January 2003 - April 2005
First American National Default Outsourcing, Jacksonville, FL
Quality Control Specialist and Reporting Analyst
. Used SQL Server, Access, and Oracle databases to create reports for
internal and external clients related to multiple clients default
activity: loss mitigation, foreclosure and bankruptcy.
. Performed quality review of internal processes assuring for accurate
and timely reporting in an efficient and cost effective manner.
January 2000 - January 2003
Contract Assignments and Self-Employment Engagements
. Responsible for project work in mortgage banking, finance, insurance,
retail, and transportation industries
. Developed key reports essential in re-establishing normal business
processes for national automated appraisal service lost during
reorganization
. Developed Crystal Reports, working with Oracle, SQL Server, and local
Access databases, resulting in the ability to resume monthly billing
of $1 million in revenue
. Developed Microsoft Access databases and spreadsheets creating feeds
for People Soft Human Resource modules (this was essential for the
population of pay schedules for over 100,000 employees located
throughout the store, warehouse, and manufacturing operations for
southeast regional grocery chain)
. Responsible for reconciliation of payroll systems for two major
transportation companies (one of these resulted in the recovery of $2
million in overpayments to railroad employees)
. Directly affected profitability of business unit by creating multiple
use spreadsheets which reduced the time multiple users were spending
in reconciliation efforts. Project resulted in the booking of $3
million in receivables not previously recognized.
January 1999 - December 1999
HarvestOne Funding, LLC, Jacksonville, FL
Staff Accountant and Servicing Specialist
. Responsible for all daily and month end functions related to startup
firm involved in agricultural lending
. Created financial statements, bank and general ledger reconciliation,
accounts payable, and receivable
. Responsible for all loan servicing activities
March 1992 - December 1998
Merrill Lynch Credit Corporation, Jacksonville, FL
Investor Accountant
. Performed reporting activities related to multiple mortgage based
investor portfolios with balances of upward of $3 billion and monthly
remittances of $40 million
. Analyzed data using Access
. Developed reports and wrote queries using Access / SQL
. Worked with traditional, non-conforming, and home equity products
. Worked with secondary marketing on creating security schedules and
transfer of loans to REMIC, FNMA, Private Investors
. Responsible for the setup of new loans produced internally and managed
activities related to acquisitions
. Experienced with LPS investor accounting modules: set up investors and
bank accounts, transfer of loans, and reconciliation of cash accounts
Contact this candidate