SUMMARY:

• Database & Software Development
• SharePoint Training Facilitator
• Extract/Transform/Load (ETL) Developer
• DataMart/Tableau/Report Developer
• Enterprise Risk Management (ERM) Advisor
• ITIL/Best Practice Resource
• Business Analyst/Project Manager
• Hospital and Marketing Industry Expert
• Computer and Software Sales

TECHNICAL SUMMARY:

• Visual Studio 2010 - 8 SSIS Packages created for ETL (Extract, Transform, Load). Primary focus to refresh daily data from Oracle 11g to SQL 2012 for reporting. Access VBA, SSIS and VB.NET are all used and incorporated daily.
• Visual Studio 2012 - 10+ WPF VB.NET Applications allowing utilities and processing directly to end user to update DataMart interactively. DSN-less connections except for Oracle 11g
• IIS Server conversion/migration from 2003 to 2012 hosting ASP.NET custom built application and conversion of .NET v2.0 to v4.0
• SSMS 2008-2012 used extensively - CRUD (Create, Retrieve, Update, Delete) permission on all SQL Server Datamart objects except scheduling SSIS which only DBA’s from IBM can schedule per Kaiser’s SLA.
• SharePoint MOSS-2013 Admin 10+ sites Full Control - Access(VBA), Excel(VBA) and Visio 2013
• Tableau 8,9 & 10 - 100+ sheets, dashboards & stories - 3 years

TECHNICAL SKILLS:

• SharePoint 2013, MOSS, 2003
• SQL Server 2012, 2008, 2000, 97;
• MCDBA - SSDS/SSIS, SSRS, SSAS, SMS
• Oracle 11g
• ASP.Net, VB.Net; VBA; VB Script, Delphi.Net; Delphi
• Visual Studio; InfoPath; SharePoint
• Tableau 9.3.5, 10.1
• Python 3.6.0
• Net Objects; PHP; ASP; HTML
• IIS; Apache 2+
• BMC Remedy 5.5, 7.6; Siemens: Invision, LCR, EDM, Confidential, Soarian

PROFESSIONAL HIGHLIGHTS:

Technology Consulting Lead

Confidential, Arvada, CO

Responsibilities:

• Provide data architectural leadership in developing enterprise data/process models.
• Design, develop and implement databases, create software and utilities, assist in production support and deliver and document an effective overall system with a solid understanding of dynamic processes and potential change in scope during this process.
• Arching goal is to provide an effective environment for benchmarking, automating reporting/metrics and identifying dynamic shifting scope to help improve processes.
• Support multiple interfaces linking Remedy with APO & BI DataMart and SharePoint.
• This gives BP’s the ability to immediately address data concerns through various interfaces.
• Created dashboards using Tableau and presented to enterprise on SharePoint.

Data Analyst

Confidential, Arvada, CO

Responsibilities:

• Contracted and hired for same role as FTE Technology Consulting Lead for Availability Program Office (above)

Business Analyst

Confidential, Denver, CO

Responsibilities:

• Worked as a liaison among stakeholders to elicit, analyze, communicate, and validate requirements for changes to business processes and information systems.
• Provided analysis and documentation of requirements, gaps, issues, risks, and enhancements.
• Validated scope and objectives through shadowing and research.

Lead Webmaster - Web Team

Confidential, Denver, CO

Responsibilities:

• Built new portal/site migrations of SharePoint 2003 to MOSS (500+ sites).
• Train subject matter experts and employees on web site administration, design and best practice methods.
• Responsible for long term Access/Excel databases and integrate with SharePoint for larger collaboration efforts. SME for all use of MS Access .
• Provided extensive workflows using SharePoint Designer.

Lead Application Analyst

Confidential, Denver, CO

Responsibilities:

• Responsible for the creation of SQL Server 2000 Confidential Warehouse functions, stored procedures, executive view indicators and OLAP cubes on a large-scale data warehouse/mart for the hospital.
• Streamlined processing by creating VBA automation to process and format data for reporting.
• Provided several reports for the top level of management for finance and accounting.
• Created and delivered over 400+ special projects and reports for immediate agency and community and public health services.

Programmer

Confidential, Littleton, CO

Responsibilities:

• Developed plug-ins in Delphi 5&7 using packages to improve Retail Pro 8.5 functionality.
• Started with DLL's and migrated to BPL technology.
• Created various user interfaces in VB6, which allows the setup and maintenance of merchandise used by these packages.

Owner

Confidential, Arvada, CO

Responsibilities:

• Managed six full time employees in the IT/DP section of marketing/direct mail facility.
• Worked closely with sales, project management to ensure successful delivery of projects.
• Implemented various marketing programs
• Developed and improved all automated maintenance plans.

Application Analyst

Confidential, Denver, CO

Responsibilities:

• Created and implemented first web based patient and family education program to distribute materials during patient care.
• Program still currently active and used by agency in 2012.
• Automated reporting using macros and VBA code.

Database/Network Administrator

Confidential, Denver, CO

Responsibilities:

• Developed and coded database projects, DBA & SA for agency.
• Migrated database objects from test to production platforms. Developed applications for help desk in VB with a SQL server backbone.