SUMMARY

• Experienced database professional with a background in design, development, administration, reporting, analysis and Business Intelligence. Expertise with SQL Server. Experience in business analysis for development of complex databases for facilities, clinical, sales, investment, banking, military, and document management.
• SQL Server analysis, design, development and administration (7 through 2014) 16 years.
• Report development - 16 years

TECHNICAL SKILLS

• DBA, database developer, BI development, business analyst: SSIS, SSAS, SSRS
• Business Objects Crystal Reports, SAS (Proc SQL)
• T-SQL
• C# for SSIS packages
• SharePoint administration
• Office automation
• ER Studio, ERwin
• Maximo - Facilities
• Siemens Automation Systems - Facilities
• Microsoft: Azure, COSMOS, DSL, PDW

PROFESSIONAL EXPERIENCE

Confidential , Redmond, WA

Database Developer /Analyst

• Data warehouse development, analysis, ETL and reporting related to Intellectual Property, software piracy and licensing. Excel reporting, Power Pivot, Query, Map. Azure, and Parallel Data Warehouse.
• Commercial Right Licensing Initiative: Analyze data sources to develop efficient cross department solutions.

IEB Security: data analysis, COSMOS, ETL, SSRS and ad hoc reports for Xbox security, DBA for ETL and SSRS servers.

Confidential

SQL Server DBA/SharePoint Admin

• Applied DoD STIGs to SQL Server and SharePoint farms. Applied patches, implemented a backup and restore plan. Modified installations to conform to best practices. Created new 2010 farms to upgrade 2007 farms.

Confidential

• Analyzed test and development environments, deployment process and SSIS ETL and made recommendations for improvements.

Business Intelligence Developer

Confidential

• Gather requirements from Army customers and develop solutions. Design, develop and maintain SQL Server 2008 databases, SSIS packages, SSAS databases, and SSRS reports. Integrate data sources and reports with SharePoint. Projects include: J3 - theater wide drawdown reports, SIGACTS reports; J4 - track equipment for asset visibility, material readiness, and restricted items. Explore using BCS3 to track equipment shipments and supply point inventories; J5 - Operational Assessments; J7 - base closure and corrective action plans; CG - ROC Drill for RDoF. DBA for clustered servers. Created Access front ends and automated PowerPoint slide shows from SSRS reports.

Confidential, Redmond, WA

Database/System Engineer, Analyst

• Redesign, troubleshoot, and maintain ETL: SQL Server stored procedures, jobs and SSIS packages that process terabytes of web “click” data for Hotmail, Search, Spaces and Messenger email campaigns and churn analytics. Primary database engineer for fifteen servers that host multiple data warehouses. Develop, monitoring to stabilize system. Work with customers to improve reporting and application dev team to improve application performance. Admin routines: version deployments, backups, performance tuning, security patches. Results: exceeded SLA, campaigns ran on time, reduced time required to manage servers.

Confidential, Seattle, WA

Database Warehouse Specialist II

• Redesign and maintain ETL from DB2, Oracle and other sources to SQL Server and SSAS databases for SSRS reports used across US to process loans. Create and maintain stored procedures and MDX. Create and maintain SSRS reports and SSAS cubes. Manage two IIS/SSRS servers hosting hundreds of SSRS reports. Convert 2000 to 2005(SSRS, SSIS, SSAS). Work with customers to translate business requirements into code for reports. Admin routines: backups, performance tuning, security patches. Improved ETL to exceed SLA. Improved report speed. Eliminated inconsistencies in reports.

Confidential, Redmond, WA

Technical Writer

• Technical writer for relational engine topics for SQL Server Books Online. Wrote topics with T-SQL examples, corrected documentation errors, supported customers for 2005. Wrote new topics for 2008.

Database Engineer

Confidential

• DBA for 150+ databases on two, two node clustered servers supporting web sites for Windows Lifecycle Test (Vista test group). Maintained jobs/DTS/SSIS imports/replication that synced these databases with Windows, component, feature and HR databases. Performance tuning.
• Database designer/developer on tools team. Designed database to manage Windows development documents. Wrote stored procedures to interact with Windows and SharePoint UIs, a Web service and custom Windows file manager, monitor and security services. Wrote/modified T-SQL for database owners.
• SQL Server 2000 to 2005 conversion with DTS to SSIS conversion.

Confidential, Seattle, WA

Analyst, SQL Server Developer, DEV DBA

• Gathered business requirements. Designed and developed SQL Server databases (stored procedures, triggers, DTS packages, jobs) for compliance review of loans. Setup and administered development server.
• Documented business rules implemented in the code and the database design.
• Redesigned Access front-end to use ADO to connect to this new SQL Server back-end.

Result: group had a faster and more secure loan risk review process. Reporting, user account and value list administration were more efficient.

Confidential

Analyst, Report Writer

• Created reports with Excel (pivot tables), SAS (Proc SQL), and Queryman on NCR Teradata data warehouse for managers of marketing campaigns to plan campaigns and evaluate campaign effectiveness.

Confidential, Seattle, WA

SQL Server Developer, Crystal Reports Writer

• Created Crystal reports and T-SQL stored procedures for management of new distribution center for the Southwest USA for shipping, receiving, transportation schedules and costs, inventory audit, evaluation of warehouse employee performance.
• Maintained data dictionary and wrote documentation for distribution center databases.
• Gathered requirements and designed a database for importing, storing and reporting on state tax data.
• Developed a tool for Treasury using MapPoint to compute banking costs to choose a bank for each new Confidential store.
• Made modifications to facilities database to support GL Account management.
• Made modifications to database used to track permits for all Confidential stores in USA.

Confidential, Tacoma, WA

SQL Server Analyst, Developer

• Gathered business requirements. Analyzed data sources. Cleansed data.
• Documented business rules. Wrote functional specifications..
• Set up development and test servers. Designed and built a SQL Server database that imports (jobs and DTS) and aggregates data from other SQL Server, OLAP, Sybase (SalesLogix), Access and Excel data sources to support U.S. sales commission reporting. Wrote MDX and T-SQL stored procedures.
• Wrote step-by-step documentation for users and documented code for maintenance programmers.
• Designed and built Access reporting front end for this SQL Server backend. Used DMO to execute stored procedures..

Result: Quarterly report process that took up to 40 hours was reduced to a few minutes and was more accurate.

Confidential, Seattle, WA

Analyst, SQL Server Developer, Access Developer

• Designed SQL Server product orders database.
• Wrote T-SQL stored procedures (for web application and Access front end) with documentation.
• Redesigned Access front-end to use ADO to connect to this SQL Server back-end.

Result: New web UI uses stored procedures instead of ad hoc SQL. Sales staff can monitor and edit orders with Access UI more efficiently.

Confidential, Seattle, WA

Analyst, Access Developer

• Designed and developed a clinical case report form database for PC Tablets in compliance with 21 CFR Part 11 (using Access). Schema migrated to SQL Server.
• Interviewed researchers and clinicians, designed a data model based on existing paper forms.
• Wrote step-by-step documentation for users and documented code for maintenance programmers.

Result: Proof of Concept. Process of collecting patient data at multiple sites can be moved from paper to electronic data entry, eliminating manual validation while complying with FDA regulations.

Confidential, Seattle, WA

System Analyst/Programmer II

• Designed a directory database for national science groups and a reporting database for bio-statistical group to evaluate performance of sites participating in international vaccine trials using data exported from various science groups.
• Designed a database to consolidate multiple Access, Excel and flat file department data sources into a single database. Incorporated Excel Pivot tables into this UI. This allowed administrative staff to share data more efficiently and export data to other users for reports and web sites. Modeled database based on user interviews. Trained users and wrote documentation. Programmed Excel tools.
• Automated Reflection to download department accounting data from Center’s UNIX server into an Access database replacing a manual process.

Confidential

DBA, System Analyst/Programmer I

• SQL Server DBA/application administrator for a facilities maintenance/work order/incident reporting application. Trained and supported office staff in the use of this application. Created and modified Crystal and Brio reports.
• Planned software and hardware needs for department. Setup and administered NT4/W2K server and SQL Server. Implemented maintenance plans including backups, security, service packs and upgrades, all with documentation. Coordinated Center IT support for Facilities department.
• Migrated Maximo database from Access to SQL server using DTS. Diagnosed problems with existing queries. Scrubbed data. Defined and modeled business rules for implementation within this application. Debugged installation and worked with vendor to resolve issues.
• Created Crystal Reports to track incident resolution, work order costs, employee productivity and customer service, manage labor and report on department activity to Center management.
• Designed/implemented plan for facilities part of JACHO certification for Seattle Cancer Care Alliance.
• Automated download of financial data from legacy UNIX database into department database eliminating most of the labor involved in interdepartmental chargeback process. Automated a data import from the HR database and a data export to Accounting for work order back charges. Automated material issuance for Preventative Maintenance work orders and automated various tasks with Unisyn Automate. Implemented electronic time card data entry by operating engineers replacing paper forms.
• Developed an improved database process for documenting, testing and troubleshooting the alarm system that protected the Center’s lab freezers..

Engineer

• Administration of building automation system. Created custom forms for building automation system UI. Used PPCL language (version of FORTRAN) to operate building automation system and Lab Data Acquisition System.