William C. Merk

**** ********* *****

Macungie, PA 18062

Primary Phone: 610-***-****

Cell Phone: 484-***-****

Email: abl5ln@r.postjobfree.com

OBJECTIVE

I am seeking a contract position. As this resume shows, my experience with

database technologies will provide you immediate value. I am confident that

I can help your company achieve its objectives.

ACCOMPLISHMENTS

. Saved 120 staff-hours per week by creating a normalized replicated

database, using Access, with region-specific front ends to eliminate

duplication of effort and to conform the data across 9 languages.

. Saved processing time by reading in printed report files in PDF format

for 300 income statements. Utilized ACL to convert data to perform

analysis and run reports for business users.

. Improved processes for tax clients by modifying an existing MS Access

database to clients' specifications.

. Created Access database to enable mutual fund data team to manage input.

This consolidated many separate databases and enabled users to quickly

view and update contact information.

. Converted Access-based time-tracking database system to SQL Server, which

improved transaction processing.

. Created efficiencies for users by connecting Excel databases to Access,

which saved time and effort.

. Simplified command functions in SQL server by rewriting the code,

enabling users to run the commands more easily.

. Took large volume of data and created meaningful business intelligence

charts using Proclarity, which streamlined operations by saving

programming time.

. Edited Access SQL and VBA for Tax Applications code to simplify it for

modifications and improvements, which enabled the system to work faster.

. Trained users on SQL Server to program in T-SQL, which provided the

company more skilled users to work on the application.

EXPERIENCE

Deloitte and Touche, Parsippany, NJ 2005-2010

Senior Consultant

. Built cubes from SQL databases using Visual Studio.

. I started as a Consultant, then was promoted to Senior Consultant, due to

outstanding performance.

Bloomberg LP, Princeton, NJ 1992-2005

Data Analyst

. Created performance monitoring applications on MS Query SQL platform,

utilizing MS Excel pivot tables.

. Created user database to track research items and report on cost of

research.

EDUCATION

LaSalle University, Philadelphia, PA

Major: Computer Information Science

Indiana Institute of Technology, Fort Wayne, IN

Bachelor's Degree, Business Administration/Finance

Applications/Computer Languages, SQL Server, SSIS, SSAS, SSRS, SAS, ACL,

Access, Excel, VBA, MDX, Proclarity, T-SQL

Contact this candidate