Sql Server Management

Andrew Slotnick

*** ***** ******, ********, ** **611

510-***-**** ( *************@*******.***

[pic]

Summary of Qualifications

. Four (4) years of contract design, RFP development, contract analysis,

and grant administration in the public and private sectors.

. More than six (6) years total experience in legal and information

systems.

. Paralegal Certification

Professional Experience

Administrative Office of the Courts, State of California

Contracts Specialist (Contractual) Jan 2008 to present

San Francisco, CA

Developed RFPs, contracts and contract amendments. Drafted contracts for

sourcing and procurement of varied services, e.g. software development;

project management; consulting. Reviewed SOWs against existing agreements.

Prepared business procedure documentation. Prepared confidentiality

agreements. Report design, maintenance from contracts database. Formatted

PDF documents for transmission. Other responsibilities:

. Sourcing of services in the government division which administers all

Superior Courts in California;

. Communicated with internal project managers and vendors on all aspects

of contracts;

. Administered on-going contracts and grants as to pricing and vendor

performance;

. Drafted statements of work, payment schedules, detailed descriptions

of deliverables; and

. Handled design, use and support of databases for contract and proposal

management.

LawFinance Group, Inc.

Contracts Administrator (Contractual) September 2007 to December 2007

San Francisco, CA

Drafting commercial lending and purchase contracts for small lender; UCC

Financing; Access, SQL Server database design and reporting. Other

responsibilities:

. Drafting and maintenance of lending agreements to contracting

attorneys;

. Analyzed financials of contracts; and

. Advised on contract management database modifications.

Citigroup

Contracts Specialist July 2006 to September 2007

Concord, CA

Drafting and composition of commitment letters, guaranties, corporate

resolutions, and credit agreements for real estate lender. UCC financing

statements and collateral statements securing lines of credit. Corporate,

LLC entity structure and documentation. Supported CRMs based on SQL Server,

Access; SQL. Other responsibilities:

. Prepared business procedures; documentation;

. Communicated with internal staff and contractors regarding regulatory

issues, establishment of UCC financing statements; and

. Supported contract management database.

Clorox

Legal Policy Analyst (Contractual-Kelly Law Registry) February to June

2006

Oakland, CA

. Reviewed corporate policies for governance compliance. Used Microsoft

Word, Excel.

. Drafted corporate human resources policies.

. Communicated and reviewed policies with management.

Gilardi & Co. (via Nelson Staffing)

Litigation Data Analyst (Contractual) 2005

San Rafael, CA

Analyzed data for class action information system vendor. Processed

securities client data imports, exports with Microsoft Access, SQL Server.

Query, macro, report expert. VBA user.

. Analyzed, queried, prepared reports from Access database tracking

plaintiffs in consumer class actions.

Avaya, Inc.

Technical Writer 1999 -- 2001

Dublin, CA

Online help and product description design for customer relationship

management software on SQL Server. Wrote database reports in SQL for

application testing. Other responsibilities:

. Prepared online and printed guides to Avaya customer relationship

databases;

. Tested and documented customer usage of databases; and

. Communicated and reviewed content with software engineers.

Computer Skills

. MICROSOFT OFFICE: WORD, EXCEL, ACCESS, POWERPOINT; ROBOHELP;

FRAMEMAKER; ACROBAT, PDF design

. Databases: SQLSERVER; ACCESS; SALESFORCE

. ORACLE 11i Financials

. Internet Legal Research: LexisNexis, Westlaw

Education

. San Francisco State University 2003 -- 2005

Received Paralegal certification from ABA-approved program (complies

with Bus Code 6450)

. Golden Gate University 2001 -- 2003

Graduate program in Taxation; coursework in tax law and research

. San Francisco State University, B.A., English Literature

Contact this candidate