SUMMARY:

• I am a highly skilled database / reporting developer who specializes in delivering accurate, intuitive, and complex database and reporting solutions.
• My experience includes over 8 years experience working with complex database and data warehouse systems and leveraging tools such as Excel, Access, Crystal Reports, MS Reporting Services, and MS Analysis Services.
• My SQL skills give me the ability to work with large data sets from multiple sources and combine them into meaningful results.
• And I have a talent for understanding the needs of the end - user and a high degree of aptitude for using my skills to meet and exceed my client’s goals.

TECHNICAL SKILLS:

• 5+ years experience with Windows Operating Systems
• 5+ years experience with Microsoft Access
• 5+ years experience with Microsoft SQL Server
• 3+ years experience with Visual Basic
• 3 years experience with Microsoft Analysis server
• 3 years experience with Crystal Reports
• 2 year Microsoft Reporting Services

PROFESSIONAL EXPERIENCE:

Confidential, Renton, WA

Database Consultant

Responsibilities:

• Performance Tuning of Consona’s Intuitive ERP system on SQL Server 2005.
• Development of User Defined functions for date calculations and string manipulation.
• Customization of forms and reports in Consona’s Intuitve ERP system integrated with an Microsoft Access framwork.
• Creation and modification of new triggers, stored procedures, pass-through queries, and ad-hoc sql scripts.
• Reformatting and customization of most canned reports in Intuitive ERP system.
• Modificaiton of code in various modules of Intuitive ERP using VBA.

Confidential, Monroe, WA

Database Administrator/Developer

Responsibilities:

• Improved inventory control system and job turn around time by creating visibility to problems such as assembly to subassembly detail linking.
• Reduced lead time required to order material by providing supplier’s with forecast of requirements.
• Development & Maintenance of legacy Microsoft Access reporting system.
• Migration of Access Reporting system to SQL Server Reporting Services and Sharepoint.
• Performance optimization of 100 Gb Vantage ERP system and custom reporting solution including elimination of redundant indexes.
• Implementation of Data Warehouse and Business Intelligence including Ad-hoc reporting using SSAS and cubes.
• Introduced Dashboards and Scorecards with ASP .net.
• Improved slow performing queries and reports through index tuning and rewriting of stored procs.
• Customization of Vantage ERP system using VB .Net.

Confidential, San Diego, CA

Senior Database Analyst

Responsibilities:

• Redesigned source data system structures for more effienct OLAP processing.
• Created new data objects for use in data warehouse and OLAP cubes
• Tweaked existing and created new indexes to increase data warehouse performance
• Created new dimensions, measures, and calculated measures for use in data warehouse and OLAP cubes like Play Preference, Week of Day preference, Max Tier, Max Rank, etc
• Tied data together from different source systems in order to get a better picture; for example tied hotel stays to casino trips, offer redemptions to casino trips
• Created lots of Excel automated reports using Visual Basic for Applications.
• Started conversion of reports to Microsoft Reporting Services
• Looked at GIS reporting (ArcMAP) using demographics data
• Started conversion of SQL Analaysis Services 2000 to SQL Analysis Services 2005

Confidential, San Diego, CA

IS Specialist/Database Admin

Responsibilities:

• Maintained SQL Server databases in excess of 100 Gb
• Tuned indexes to drastically improve system performance and eliminate time-outs
• Increased Slot system availability to about 99% uptime
• Implemented row-locks on archive jobs and end of day table trims to avoid system degradation
• Implemented new maintenance plans that improved system performance
• Setup log shipping for minimized down-time in the event of a system failure
• Implemented interface into AS400, SQL servers, and other systems
• Setup MOLAP cubes for slot analysis
• Used DTS to collect key data and prep data for SSAS
• Appended to slot system with custom databases
• Created data warehouse for custom reporting solution using Crystal Reports 9 and MS Excel.
• MapPoint for GIS reporting.
• Made reports available over intranet using Crystal Enterprise
• Windows CE mobile development for Custom slot floor applications
• VB/VB .Net/ ASP .net development for custom application solutions.

Confidential, Las Vegas, NV

Database Analyst

Responsibilities:

• Administered Slot Tracking System in 24x7 casino environment.
• Managed casino slot configuration and casino floor changes.
• Exported data using Microsoft Access in order to keep track of slot statistics, revenue, games, themes, player statistics, conversions, promotions, progressives. Jackpots, participation, multi-games, inventory and other data.
• Migrated databases to Microsoft Access 2000 from older versions of Microsoft Access.
• Made data available using Access forms, reports, & queries
• Developed Microsoft Access & Excel applications using ADO and Windows API including W2G taxable winnings application for slot floor.

MIS Operator

Responsibilities:

• Supported Casino & Hotel as well as administration operations
• Administered and maintained Novell network & HSI point of sale system.
• Exported data from point of sale system into Excel reports using VBA & ADO
• Monitored jobs and queues on AS400
• Responsible for daily backups

Confidential, Spokane, WA

GIS Intern

Responsibilities:

• Helped small department develop utilities and applications for the county and police department
• Developed with Microsoft Visual Basic 6, Microsoft Access 97, and ESRI Map Objects
• Added new functionality to existing applications
• Converted DAO code to ADO with Access databases
• Developed new queries and reports with Microsoft Access
• Debugged and tested modifications to various applications