ADRIAN ARREOLA

***** ** ****** ***** ** #***

Wilsonville OR 97070

E-mail: abhhfp@r.postjobfree.com

Phone: 503-***-****

OBJECTIVE: Seeking a position as data analyst or database design.

* *****S

. Expert in data analysis, data processing, using Excel and MS Access

VBA macro automation, SQL queries and SAP Crystal Reports.

. Proficient in the use of Excel functions to perform statistical

analysis and data manipulation using string functions.

. Ability to design relational databases in MS Access and SQL server

using ERM and RDBMS model, SQL programming language, and database

indexing.

. Proficient building Web based database applications using ASP.Net,

Active Data Objects, and Visual Studio .Net Framework and IIS web

server.

. Experience working with web based management systems Work Force

Management (eWFM & Aspect).

2 WORK EXPERIENCE

Internal Support Operations, HSBC, Tigard, OR, 03/10 - Present.

Created dashboard ad-hoc reports using Excel lookup and conditional

functions to calculate statistical ranking and streamline reporting for

performance and scheduling optimization from data retrieved from eWFM

systems. Provided customer service support regarding credit card approvals,

fraudulent transaction, identity theft situations, account activations and

credit increase approval evaluations.

Customer Service, ACS, Tualatin, OR, 01/05 - 04/07.

Processed activations and troubleshooting of wireless devices. Process lost

and stolen handset requests for wireless phone accounts. Processed payments

over the phone and handled escalated call for potential fraud.

Internal Support Group, BPC, Lake Oswego, OR, 04/04 - 11/05.

Assisted financial analysts developing Excel VBA macro automation to

streamline production of financial schedules, data extraction, and data

manipulation.

Processed raw data provided by clients in text format to migrate data to

repository databases using VBA string functions. Created SQL queries and

developed relational databases with MS Access and SQL server. Developed

windows based database applications using Active Data Objects.

Projects 2007-2009 & 2002-2003:

Worked in projects as an independent contractor developing CRM, payroll

solutions and incident reporting systems for small businesses as well as

large organizations such as Foothill Community College using web based

databases with MS Access, SQL server, ASP.net IIS web servers and .Net

Framework.

Education 1998-2001:

B.S. Management of Information Systems, SJSU, San Jose, CA, 1998-2001.

Contact this candidate