Developer Sql Server

Suzanna Cole

*** ***** ***** ******* ****, CA ***69 Phone: 503-***-**** ********@********.***

Introduction

Having worked with computers and Microsoft Office applications for over 10 years, I have experience in many different business environments. I have strong organizational skills with the ability to multi-task, but also recognize the importance of prioritizing individual tasks in the interest of achieving company objectives. Whether working independently, or with managers or team members, I believe strongly in good communication. I am a fast learner, quickly understanding requirements and always looking for ways to improve my work.

Work Experience

Dalton Management, Inc, Beaverton, OR

Financial Data Analyst - 7/09–Present

Analyzed data requirements for investment data application

Cleaned and corrected Excel spreadsheet data for entry into database

Automated import of data from web application

Produced data summary reports to maximize cost savings

Consolidated multiple Excel spreadsheets

Created forms and lists with drill-down for summary financial data

Produced user documentation

Tigard-Tualatin School District, Tigard, OR

Data Analyst - 7/10-10/10

Consolidated spreadsheet data and data from over a hundred Access databases into less than a dozen compact and efficient databases

Created complex queries, reports, charts and graphs that combined data from Oracle, SQL Server data warehouses, Excel spreadsheets, website data downloads and other sources

Streamlined graph and chart production using VBA and automation techniques

Esco Corporation, Portland, OR

Data Analyst - 12/07–3/08

Built various reports and auditing tools to aid managers in dealing with Oracle migration issues

Saved hours of work through automating daily tasks

Developed Excel macros to import data from database

Analyzed, audited and tracked financial data (sales, pricing, invoice) from Oracle data warehouse for management reports

Part of a group involved in optimizing the internet B2B site

Designed VBA classes to search, find and correct errors in XML and EDI order and invoice files

Portland Public Schools, Portland, OR

Data Clerk - 4/05–8/07

Developed database program for high school fall registration and spring check-out and other databases as required

Generated reports as needed for principal and vice-principals using eSIS (district-wide software)

Maintained student enrollment, transcripts and other student information

Produced master schedule of classes, teachers and rooms for the next school year

Hollywood Video, Wilsonville, OR

Developer (Boly-Welch) - 10/04–01/05

Full life cycle development of MS Access database client/server application for Facilities Department to monitor service maintenance for over 2,000 stores nationwide

Created user manual and participated in corporate in-house training on the new system for Field Managers, Field Engineers and corporate Coordinators

InterKnack, Bellevue, WA

Web Developer (Maxim Group) - 2/01– 4/01

Designed and created web application using ASP with SQL Server

Wrote catalog import system for importing catalogs in text format to tables in SQL Server using objects and XML

Wrote documentation and custom web page to aid in system installation

Microsoft, Redmond, WA

Web Developer (Excell Data) - 2/00–11/00

Developer on the MS Commerce Server 2000 team

Worked extensively with XML data islands and converting data to and from XML, ASP code and COM objects.

Wrote and debugged ASP, JavaScript and HTML code

Optimized and tuned SQL Server queries

Best Consulting, Seattle WA

Developer - 12/98–12/99

Various programming and web development assignments including UW Physicians, Western Wireless

Part of 6-person development team upgrading ASP web application to ASP/VBCOM with JavaScript

Todd Pacific Shipyards, Seattle WA

Developer (Mindpower) - 10/98–12/98

Worked with engineering division to design and develop change notice tracking system using MS Access

Delivered the runtime application within two weeks of start.

Puget Sound Energy, Bellevue, WA

Developer (Independent) - 4/98–9/98

Designed software to manage gas lease customers, enabling manager to enter and track contracts, changes and updates

Programmed word merge capabilities to generate customized contracts

Innova Corporation, Tukwila, WA

Developer - 7/97–4/98

Maintained, supported and upgraded mission-critical databases in high-growth manufacturing environment

Designed and developed reporting tools for various corporate groups

Persuaded management to migrate from a legacy database to Oracle

Functioned as the project leader for major ERP solution research, RFP and demos

Washington Natural Gas, Seattle WA

Administrative Assistant - 11/96 – 7/97

Coordinated efforts of company representatives, dealers and customers

Designed and developed client/server database application to process mailing letters, customer replies and follow-up through sales and service installation

Skills

Microsoft Office automation: Access, Excel, Word, Outlook, Power Point

SQL Server, Oracle SQL; database design, tools, queries

Graphics forms, reports and program interface design

Technologies: VBA, SQL, ADO, XML; VB.NET, ASP, JavaScript

Education & Training

BA, Ambassador College, Pasadena, CA

2 quarters psychology, Cal State LA

Systemation: Fast Start to Systems Analysis

Oracle applications (EBS) training

Contact this candidate