Process Improvement
Data Services
Information Systems Administration
Information Management Services
~
Leveraging the most from your systems
Organizations today are rife with various stand alone applications, information systems, databases, and enterprisey solutions. To get your money's worth, those systems need to work in harmonious unison.
Once systems improvements have been made, they need to be maintained
Creating or updating database/warehouse schemas, creating ETL processes, creating reports, dashboards and KPIs
Before beginning any project, an assessment on current processes should be analyzed
During my career I've designed, built and maintained a myriad of databases, data warehouses, ETL solutions, business processes, QC routines, dashboards, reports, websites, and analyst toolkits for every part of the data ETL pipeline.
​
My experiences have been for multi-billion dollar CAPEX projects for major oil companies to consulting with small family owned businesses, from Enterprise Oracle and SQL Server clustered data centers to a desktop Access databases.
​
Most of my expertise is in the Microsoft stack, but I'm not afraid of conquering technologies on other platforms.
Experience
~
I'm good with data
~
20
Years of Experience
4
International Companies
2
Fortune 100
Skills
Schema design for OLTP and OLAP
Database/Datawarehouse ETL
Database/Datawarehouse development
Business process design and improvement
Project management methodologies (PMI)
Project management life cycle
ITIL change management
Managing remote teams
Process documentation
Systems administration
Development
Development: T-SQL, I-SQL, VBA, VBScript, .NET: .ASPX, VB, C#
Markup Languages: XML, HTML, XHTML
Visual Studio 2010/2013/2015 IDE
BIDS/SSDT for BI development in VS IDE
MS MDS & DQS
Administration
MS SQL Server RDBMS: 7.0/2000/2005/2008/2012/2016
Borland Interbase 6.0 RDBMS
MS IIS 5.0, 6.0 & 7.x
Active Directory, LDAP (Group Policies, DCs, Domain deployment)
Intergraph SmartPlant Foundation 3.x, 4.x (SPF)
Windows SharePoint Services 3.0
Microsoft Team Foundation Server
Microsoft System Center
Software
MS SQL Server SSIS & SSRS (2008/2012)
Oracle 9i/10g Relational Database Management System
Windows 95/98/NT/2000/XP/Vista/7/8.1/10
Windows 2000, 2003/2008/2012 server
Reporting suites/systems: Business Objects, Crystal Reports, Tibco Spotfire, Tableau, SSRS, MS Power BI, MS Power Pivot, iBank, Grasp, Travel Man
MS Office 97/2000/2002/2003/2007/2010/2013/Office 365 (MS Word, MS Excel, MS Access, MS PowerPoint)
MS Visio 2000/2007/2010
Lucidcharts
Intergraph SmartPlant for Owner/Operators (SPO) solutionware
Intergraph SmartPlant Instrumentation/Intools (SPI)
Primavera Expedition, Primavera P6 v7
Liquid Planner
Microsoft Project 2010
SharePoint 2003/2007/2010/2013
Documentum
PDMC
Trams Back Office
VMware ESXi, VM Player, VM Converter
Oracle Virtual Box
Walkinside 3D Modeling
TechNet Knowledge-Base
Mindjet MindManager Pro 6.0, 7.0, 8.0, 2012
Camtasia Studio 6.0
LAMP Stack (rudimentary)
Jira
ServiceDesk Plus
Zoho