Decision Support Analyst

Charles C. Fobian

***** ***** *** . ***** ******, UT 84095

801-***-**** . *******.******@*****.***

Summary of Qualifications

Experience Solving Complex Problems

Knowledge of T-SQL and Databases

Knowledge of Data Warehousing

Technical Skills

Microsoft SQL Server 2005 and 2008 R2

General Data Warehousing and Dimensional Modeling Using Ralph Kimball

Method

Business Objects Data Services

SQL Server Reporting Services

Microsoft Office Products including Word, Excel, PowerPoint, Outlook, Visio

HTML, PHP, JavaScript, C#

Software Development Life Cycle

PROFESSIONAL EXPERIENCE

2012-Current

Select Portfolio Servicing Inc., Salt Lake City, Utah

Decision Support Analyst

. Write queries using T-SQL and SQL Server Management Studio 2008 R2 to

extract data based on various business units' needs

. Create ad-hoc reports using T-SQL and SQL Server Reporting Services

. Conduct maintenance on existing reports including query optimization

for faster results

. Create and maintain reports for different ratings agencies

2007-2012

Select Portfolio Servicing Inc., Salt Lake City, Utah

Investor Reporting Analyst

. Created databases to improve the functionality of how data is

presented to clients

. Created ad-hoc reporting as clients' needs dictate

. Assisted in development of analytical tools to enhance reporting

methods and increase both productivity and efficiency

. Corresponded with Investment Banks and provide detailed reports for

investor review

. Underwrote mortgage loans to ensure they meet the necessary criteria

to qualify for programs to improve customer's circumstances

2003-2007

Inter-Media Advertising, Encino, California

Data Manager

. Managed monthly reporting needs for a large direct mortgage lender's

marketing team

. Pioneered ad-hoc reporting for the entire department, resulting in

more timely and accurate data

. Oversaw ditech.com's phone data for all advertising efforts to gain

deeper understanding of return on investment and budget allocation

Education

Bachelor of Science in Information Systems

University of Utah, Salt Lake City, UT

Contact this candidate