Data Office

Erica Isabel Bruns

*****.*****@*****.*** - 301-***-****

Professional Experience

Standard & Poor's, Data Strategy & Operations, Bethesda, MD

Data Analyst Feb 2007 - Sep 2009

. Analyzed and monitored quality of data sets containing residential and

commercial mortgage-backed and asset-backed securitizations to be

published on ABSXchange, S&P's primary structured finance cash flow

modeling platform for use by both regulatory agencies and financial

institutions for valuation, portfolio management, and cash flow

projection as part of the re-release team

. Managed RMBS loan level data project; compared loan level data to

reported aggregate data and ran cashflow analyses to ensure accuracy

of data being published; advised a team in the United Kingdom

regarding loan level data issues

. Managed a data extraction project; assigned out and reviewed templates

created locally; assigned out, reviewed, and published data files

created by three third-party data vendors in India and Vietnam;

addressed or supervised other team members' responses of extraction

issues identified by teams abroad

. Successfully supported SF Power project to train Credit Rating and

Information Services of India Ltd. (CRISIL) and Zenta to take over

data extraction originally performed exclusively by Synesii

International, LLC and ensure that they match Synesii's level of

accuracy; monitored quality of data extraction and advised teams on

data issues

. Tracked and maintained records of work done locally and abroad for

senior management's analysis and metrics

. Resolved data issues on ABSXchange raised by clients in a timely

manner (within 48 hours)

. Regional focus: Western Europe

Case Western Reserve University, International Student Services, Cleveland,

OH

SEVIS Coordinator May 2003 - Aug 2005

. Oversaw data management and IT functions to promote more efficient

office practices

. Identified and resolved discrepancies in student records by contacting

appropriate admissions offices, academic departments, or school

registrars; performed monthly audits

. Created and maintained a comprehensive 68 page Office Systems Manual

that easily steps a new user through the use of the Case ISIS

University Registrar system, fsaATLAS immigration office database

application, and the relationship between these systems and the U.S.

government's Student & Exchange Visitor Information System (SEVIS)

. Handled the office budget, including preparing forecasts and assisting

in planning the next fiscal year budget

. Hired, trained, and supervised Student Employees and trained

Department Assistants

. Conducted and coordinated software training for the ISS staff

. Maintained links between this office's fsaATLAS system, the University

Registrar, and SEVIS

. Served as liaison with University Information Technology Services

. Generated F and J visa immigration documents for international

students

. Overhauled and maintained the office website; updated and reorganized

immigration regulations (such as work authorization, travel alerts,

automatic visa renewal options, and NSEERS changes) and incoming

student guides to be more user-friendly

. Prepared annual Open Doors Report (international student statistics

sent to the Institute of International Education)

Carnegie Mellon University, Civil & Environmental Engineering

Department, Pittsburgh, PA

Computing Facilitator May 2000 - Apr 2001

. Configured/reconfigured Windows mixed environment computers

. Maintained hardware and software for 250+ computer systems

. Troubleshot system hardware problems

. Ordered and installed equipment

. Trained staff to use new equipment

. Supervised facilities labor

Education

Case Western Reserve University, Cleveland, OH

Bachelors degree in Computer Science 2007

Minor in Management Information & Decision Systems

Carnegie Mellon University, Pittsburgh, PA

Undergraduate studies in Information Systems 1998 -2000

Additional Information

Languages: English and Spanish (both native)

Skills: SQL, MS Office suite (Excel, Access, Word, Power Point,

Outlook), MS SQL Server, pgAdmin, MS Visio, UML, Adobe Acrobat

Professional, Mercury Quality Center software, new user

training, PeopleSoft ERP used for budget & queries, C++, HTML,

Javascript, Visual Basic, Visual Studio .NET, UNIX, Linux,

fsaATLAS and SEVIS RTI used for office and government

immigration databases

LinkedIn profile: http://www.linkedin.com/in/ericabruns

(This profile includes 4 recommendations, and I have an additional

recommendation from my last manager at S&P that I would be happy to

provide.)

Contact this candidate