Microsoft Office Sql Server

Beverly Andrews

aczm6e@r.postjobfree.com

Seasoned SQL programmer with extensive experience across a number of database products including SQL Server 2008, Oracle, MySQL, Informix and Access in a number of roles: requirements gathering, designing, programming, implementation and support. Strong communication skills, attention to detail and sharp analytical skills combined with a firm knowledge base of programming techniques (traditional and object-oriented) deliver results.

Sharepoint, Blackbaud/Convio, T-SQL, SQL Server 2008, SSRS, SSIS, C#, Excel, Windows, Windows XP, MiSys Tiger, Access 2007, Excel 2007, VBA, Microsoft Office, SPSS, HP networked printers, OS X, Adobe Photoshop CS2, OS 9, HTML, Excel, Oracle 9i, SQL/P SQL, SalesForce, Windows ME, Javascript, Microsoft Office, Windows NT, CRM software, Lotus Notes, PowerPoint, SPSS, Cerner, CompuRecord, Sharepoint

Sr. Marketing Database Analyst April 2016 – Present

YP, Glendale CA

Coded, maintained and managed sales model in HP Vertica.

Ad hoc reporting and report automation development with SSIS/SSRS.

Advise as to data flow and process design for top purchased category project.

Manage email list generation for over 50+ campaigns to date.

Data Analyst August 2013 – April 2016

Children’s Hospital Los Angeles, CA

Redesigned, coded (C#), and implemented the Anesthesiology QA grading and scoring system from Access 2003 to a SQL Server 2008 housed system that uses SSRS, SSIS, stored procedures and functions for storage and report generation.

Provide ad hoc SQL queries and create scheduled reports by request.

Update and maintain Access 2007 database interface creating new forms, SQL server tables and queries.

Designing Palliative Care Database using SQL Server 2008

Systems Data Manager October 2010 – June 2013

CauseForce Hollywood, CA

Upgraded the client reporting system from a pastiche of Excel spreadsheets macros and perl scripts to a SQL Server 2008 housed system that uses SSRS, SSIS, stored procedures and functions for ETL, report generation and distribution.

Provide ad hoc SQL queries and reporting on request for KOIs.

Managed the Adobe Flex based Online Check-In deployment during event season.

Podiatry Research Coordinator June 2010 – October 2010

St. John’s Well Child and Health Clinics Los Angeles, CA

Preliminary Podiatry study research, design, ad hoc analysis and reporting using Excel. Findings were used in a report for the Funders meeting. Evaluated the two primary clinic systems for managing care and payments for the podiatry to help the managers understand the issue of data integration across the two systems.

Administrative Analyst, Social Services November 2009 – January 2010

Apple One/UCLA Rape Treatment Center Santa Monica, CA

Created Biller Grant tracking system using Access 2007 and VBA: gathered requirements, designed database and forms, wrote queries, assisted with testing and documentation. The system allowed the RTC to track services rendered to their patients in order to maintain a grant.

Graduate Assistant, Social Science Labs August 2008 – June 2009

University of California, Irvine Irvine, CA

Assisted students with computer issues and questions on Word, Excel, PowerPoint, SPSS and HTML editors, and flash drives; printer maintenance.

Teaching Assistant Positions Spring 2007 & Summer 2008

Social Science 3A (Basic Applications)

University of California, Irvine, CA

Taught Microsoft Office advanced features, basic HTML instruction and SPSS.

Introduction to Digital Art (Photoshop) Fall 2006

Taught Adobe Photoshop, developed lessons and provided grading assistance.

Data Analyst February 2005 – September 2005

NetRatings,Inc. Seattle, WA/Milpitas, CA

Wrote and adapted Oracle SQL/PL SQL scripts, procedures, packages and Excel formatting macros and developed Excel VBA interactive reports.

EDUCATION:

Santa Monica College Santa Monica, CA

Health Care IT Project Management Certification 2011

University of California at Irvine Irvine, CA

Art Computing Engineering Program MFA 2009

State College of New York at Buffalo Buffalo, NY

Dual Bachelor of Science Degrees in Computer Information Systems and Economics

Contact this candidate