SUE GALL
********@*****.***
East
**th
Street,
Austin,
Texas
78702
Cell:
512
897
6534
SUMMARY
Data
analyst
with
experience
in
non
profit
and
regulatory
environments
seeks
business
analyst
position.
Experienced
tester
of
in
house
and
web
based
database
solutions.
Skilled
at
writing
SQL
queries,
creating
and
executing
test
plans;
gathering
user
specifications,
and
organizing
and
presenting
data.
Ability
to
manage
projects
from
start
to
finish;
a cknowledged
for
excellent
customer
s ervice
s kills.
PROFESSIONAL EXPERIENCE
TEXAS RELIABILITY ENTITY, INC ., Austin, Texas (2010 – present)
Texas
Reliability
Entity
is
responsible
for
ensuring
the
reliability
of
the
bulk
electric
s ystem
in
the
Electric
Reliability
Council
of
Texas
(ERCOT)
region.
Legal Analyst
Go
to
p erson
for
webCDMS,
a
web
based,
cross
regional,
compliance
tracking
database.
Performed
•
user
acceptance
testing
of
major
releases.
Answered
s taff
and
outside
user
data
entry
questions.
Presented
webCDMS
topics
a t
internal
operations
workshops.
Acknowledged
b y
users
for
excellent
support.
Legal
department
lead
for
SharePoint
2010
migration.
IT
d epartment
liaison
responsible
for
•
gathering
legal
d epartment
specs,
testing
SharePoint
functions,
writing
user
instructions,
conducting
ongoing
training
s essions,
and
implementation.
Created
and
executed
test
plans
for
troubleshooting
issues
during
SharePoint
migration.
Worked
•
with
IT
d epartment
to
resolve
issues.
Developed
user
workarounds.
Discovered
issues
that
affected
company
wide
rollout
in
time
for
IT
to
revise
rollout
processes.
Data
analyst
for
operations
workgroups.
Created
Access
databases
and
wrote
SQL
queries
to
•
generate
monthly
metrics
for
board
of
d irectors,
data
syncs
with
headquarters,
and
internal
analysis
of
operations
activities.
Wrote
SQL
queries
to
join
data
from
d isparate
Excel
s ources
for
cross
team
projects,
and
to
•
compare
b efore
a nd
after
data
during
major
releases,
ensuring
data
integrity.
Participated
in
cross
regional
working
group
to
create
database
business
rules.
•
Participated
in
compliance
audits,
which
included
requesting
and
evaluating
evidence
and
•
completing
a
d etailed
report.
Technology
s kills:
Microsoft
Office
2010
and
2013
(Word,
Excel,
Access,
PowerPoint,
and
Outlook);
•
SharePoint
2010;
Colligo
Contributor
( client
interface
to
SharePoint);
webCDMS
(compliance
tracking
database).
Sue Gall ********@*****.***
FIRST BASE DATA SYSTEMS, Austin, Texas (2007- 2008)
First
Base
provides
custom
FileMaker
database
d esign
services
to
Austin
and
Central
Texas.
Senior Developer
Built
and
modified
databases
for
s mall
business
clients
using
Agile
d evelopment
method.
•
Tested
databases
b efore
rollout.
•
With
owner,
met
with
clients
to
assess
needs
and
gather
specifications.
•
Created
storyboards
to
h elp
clients
visualize
how
the
d atabase
would
work
and
to
involve
them
•
more
actively
in
its
d evelopment.
Wrote
supporting
documents,
including
user
instructions,
scripts
for
a
s eries
of
five
minute
training
•
videos,
and
a
proposal
for
an
internal
billing
system.
Performed
quality
assurance
testing
on
databases
b efore
rollout.
•
Presenter
to
local
user
group
on
using
F ileMaker
as
a
front
end
for
S QL
databases.
•
Technology
s kills:
FileMaker
6
9;
Certified
F ileMaker
Developer
8
9;
Microsoft
Word,
Excel;
Mac
a nd
•
PC.
SCHLOTZSKY’S, Austin, Texas (1998-2007)
Schlotzsky's
is
a
fast
casual
restaurant
chain
with
locations
in
37
s tates
and
3
foreign
countries.
Database Administrator (2003-2007)
Wrote
SQL
queries
for
sales
reports
of
company
owned
stores
and
for
data
migration
from
•
FileMaker
to
SQL
Server.
Created
a
trademark
database
to
track
renewal
dates
of
Schlotzsky's
owned
marks.
•
Programmed
alerts
to
Legal
staff
of
expiring
contracts
and
projected
s tore
openings.
•
Designed
d etailed
reports
for
litigation
support,
royalty
management
and
executive
reviews.
•
Technology
s kills:
Microsoft
SQL
Server
2000,
FileMaker
Pro
and
Server
4
5;
Microsoft
Word,
Excel;
•
Mac
and
PC
Database Technician (1998-2003)
Maintained
a
central
database
of
store
locations,
sales,
franchise
contracts
and
communications
•
with
customers
and
franchisees.
Hired
to
organize
100+
supplier
contracts
for
expiration
date
tracking
in
a
central
database,
to
•
reduce
litigation
risk
and
improve
cost
management.
Technology
s kills:
FileMaker
4
5;
Microsoft
Word,
Excel;
Mac
and
PC.
•
•
EDUCATION/PROFESSIONAL DEVELOPMENT
M.L.S.,
Kent
State
University,
Kent,
Ohio
B.A.
English,
The
Ohio
S tate
University,
Columbus,
Ohio
Austin
Community
College
(ACC)
courses
in
relational
databases,
4.0
GPA.
•
Edward
Tufte
workshop
on
visual
display
of
information
•