SUMMARY:

• Highly skilled from working on dozens of complex database & programming projects in: Access, Excel, Visual Basic and SQL Server 2000 thru 2012.
• I have extensive data design and modeling experience with joins, stored procedures, indexes, views, Confidential - SQL, PL-SQL, SSIS, SSRS, SSAS, VB/VBA, graphs, parameters, charts, pivots, and I always complete full project documentation.
• Availability to interview - Immediately for a phone interview or technical screen.
• Able to use Skype/FaceTime if employer is not in Charlotte metro area.

TECHNICAL SKILLS:

Macintosh, OS X 10.4; Classic 9.2, 8, 7.x

Windows server,TCP/IP, DNS, DHCP, IIS, Terminal Services, Active Directory

Windows client Win8, Win7, Vista, XP Professional

Microsoft Access 2010, 2007, 2003, 2000

SQL Server 2000, SQL Server 2005, SQL Server 2008 (R2), SQL Server 2012, SSAS (OLAP, Kimball), SSIS, SSRS

SQL and dynamic SQL, views, table design, stored procedures, joins, indexes, parameters, data marts, OLTP tuning and performance optimization, Management Studio (SSMS), Business Intelligence Development Studio (BIDS)

Visual Studio / VSTO 2008, 2005, 2003

Visual Basic / VB.NET 2008, 2005, 6.0

Visual Basic for Applications

Used with MS Excel & MS Access

Microsoft Excel 2013, 2010, 2007, 2003, 2000

Microsoft Word 2013, 2010, 2007, 2003, 2000

SharePoint 2010, Team Foundation Server

HTML, XML, Media Wiki 4.0, metadata, web page design

PROFESSIONAL EXPERIENCE:

SQLSERVER DEVELOPER

Confidential, Charlotte, NC

Responsibilities:

• CreatednewSQLServer 2012 scripts, databases, tables, pivots, functions & stored procedures for tracking hundreds of HRIT internet applications over any time period for response time and availability.
• Implemented SSIS scripts capable of creating entire database and importing Oracle data automatically.

SQL SERVER&SSRS DEVELOPER

Confidential, Charlotte, NC

Responsibilities:

• Utilized Business Intelligence Project designer and Visual Studio 2008 to develop SSIS ETL jobs and SQL 2008 R2 SSRSreports for use with SharePoint &Broadridge financial asset management software.
• Completed table design, data modeling and field mapping from legacy 4 TBSybase SQLdatabases.
• Updated dozens of Confidential -SQL tables, views & stored procedures with complex joins and user parameters.
• Optimized stored procedure performance and Excel output formats based on user acceptance testing.

SQL DATABASE CONSULTANT

Confidential, Hillsboro, OR

Responsibilities:

• Migrated Microsoft Excel files, VBA code, Access databases to new SQL Server 2008 databases.
• Streamlined Excel dashboard graphswith PowerPivot tables and links to SSASdata warehouse.
• Created SSIS ETL scripts for cleanup of data imports;improveddocumentation, version source control.

MYSQLDATABASE ADMINISTRATOR

Confidential, Beaverton, OR

Responsibilities:

• Implemented storefront with sales to date ofover 1,300 quality collectibles, books, music CDs & DVDs.
• Interacted with customers and used their suggestions to add new categories and better shipping options.
• Managed all databases using MySQL 5.0 and SQLyog 9.5; initiated targeted marketing campaigns.

SQLDBA&SSRSDEVELOPER

Confidential, Portland, OR

Responsibilities:

• Added execute-on-demand functionality for Great Plains Dynamics 10 accounting database updates.
• EnhancedSQL Server 2005 performance by minimizing blocking andadding indexes to all databases.
• Designed indexed views and parameterized Confidential -SQLstored procedures for Cognos 8 BI data warehouse hosted ona SharePoint web sitefor end-user access to60 months of accounting data by unit & period.
• OptimizedSSRSad-hoc unit report execution time from 3 minutes to less than 10 seconds.
• RedesignedExcel profitability dashboards and combined 7 data sources into reports withSSIS routines.
• Completed numerous SQL analysis projects for external auditors, HR, Marketing, Controller and CFO.

BUSINESS INTELLIGENCE DEVELOPER

Confidential, Beaverton, OR

Responsibilities:

• Improved and supportedthe Build-a-Report Business Intelligence application on SQL Server SSAS cubesthat used Excel pivot tablesandSSRS reports withmarketing data fromall Confidential product lines.
• Added new SSAS cubes for European data; verified integrity of 9 million new NPD records imported monthly; added display constraints on data sets with less than 35 records. A pivot table user interface allowed data filtering by region of the country, product line, customer and drill downs to any product.

ETL/VBA LEAD DEVELOPER

Confidential, Sandy Springs, GA

Responsibilities:

• DesignedETL routines to convertExcel files from drop folders into weekly & monthly interactive dashboard reports. Wroteuser-defined functions & VBAclass modules for use in future project phases.
• Supervised VBA code development for 2 other programmers for entire software development life cycle.
• Identified additional sources for over $3 million inunbilled monthly texting revenue.

SQL BUSINESS ANALYST

Confidential, Reno, NV

Responsibilities:

• Consolidated and updated Access 97 and 2002 databases for use in SSAS/OLAP Data Warehouse.
• Developed Confidential -SQL queries, stored procedures and DTS packages for importing EDI customer records.
• Generatedhealth careinsurance ad-hoc reports in SQL Server 2005 Reporting Services (SSRS).

SQLDATABASE DEVELOPER

Confidential, Blue Diamond, NV

Responsibilities:

• Designed a new Access 2003 database with unique indexes; wrote dozens of SQLstored procedures.
• Modeled BPB’s entire sheetrock production line from converted Excel calculations in old spreadsheets.
• Generated screens to capture all possible reason codes for down time, maintenance and product culls.
• Linked Access data to Excel graphs with VBA to generate AS/400 reports &shift summary dashboards.
• Prevented costly production line shutdowns by proactively tracking daily loss reasons and trends.