SUMMARY

• I have expertise in legacy upgrades and integration, Business Intelligence, Workflows/InfoPath and Reporting Technologies (SSAS, SQL Server Reporting Services (SSRS) (2005 - 20012), Crystal Reports (4 - 12), Cognos 10.1 – 10.2, Tableau 7 - 8, Panorama, QlikView, GoodData and others) and noledge of cutting edge Microsoft Technologies. 15 Years of experience in ETL and effecting disparate system integration employing tools ranging from early custom development to SQL Server 2005/2008/2012, SSIS, SSAS, SSRS, SharePoint (2003, 2007, 2010 & 2013), Microsoft Dynamics, GP, and MS Biztalk 2006 and 2008, Relativity, SFDC (FORCE.COM, APEX).
• Microsoft BI Stack: Extensive use of SSIS including a project (Sokolove Law) where I replaced Datastage with SSIS. Extensive experience with SSRS and SSRS in SharePoint (Sokolove Law, US Army, Pfizer, Red Back Mining). SSAS supporting self-service Excel Power Pivot. 2012 PowerView.
• Design, Implementation and Support of Amazon AWS (EC2, S3, Glacier, EBS) and Microsoft Azure. In two sites I designed using Hyper V and a private cloud.
• Excellent communication skills; ability to communicate goals, ongoing activities, requirements, specifications and business tasks; whether the medium is a presentation, a paper memo, an email, a website or a blog.

TECHNICAL SKILLS

• LANGUAGES/DATABASES/TOOL SETS: MS SQL 6.5, 7.0, 2000, 2005, 2008 R2 and 2012 (T-SQL/Stored Procedures/Power Pivot/Power View), MS SQL 2014 in test, Azure, VS .NET, Visual Tools – Sharepoint (2003 & 2007 & 2010, 2013), Infopath and Workflows, Visual Basic 3.0 through VB.NET 4.X, Visual Studio through 2012/.NET, ASP.NET, .NET Framework 1.X, 2.0, 3.X, 4.X, DTS / ETL / SSIS / SSAS / SSRS. BIZTALK, WF, WPF and WCF, Altova Tools. Business Objects (3,4,6.5,XI) Tools/Custom Controls, HTML & Composition Packages, ActiveX Internet Controls, Java/J++/J#, XML, C#, DHTML, Ruby on Rails, DNN, Dreamweaver & Flash, CSS, Silverlight / Expression Studio, Installshield, MS Access, Oracle Experience, CGI Scripts - Perl4/5/6, Foxpro, PowerBuilder, Sybase SQL Anywhere, Erwin, Infomodeler, Embarcadero (dBartisan, ERStudio, Rapid SQL), Business Intelligence, Reporting and Forensic IT. Experience with SAP. Dundas BI Dashboards and Dundas SharePoint Chart and Gauges, Telerik, Infragistics, BI Delivery to Phone / Tablet Social Networking / Blog Development. Jitterbit, Toad Data Modeler and Data Point

Environment:

•  Windows Servers (LAN Manager through Windows Enterprise 2003, 2008 and 20012, Hyper-V and other support servers. NOVELL, Ubuntu, UNIX, Xenix,, Exchange (all versions), IIS, Apache, E-Commerce Server, Windows XP and Vista. I work with Cisco, Fortigate and Watchguard routers and Symantec, Retrospect, Red Gate SQL, Backup Exec, AppAssure..Security: Symantec (Desktop & Enterprise), Trend Micro, McAfee, Microsoft Forefront, router based packages. VPN and specialized web security packages. HIPAA, ERISA and SOX regulatory compliance.

PROFESSIONAL EXPERIENCE

• Tasked to Review, Analyze, Retire and rebuild Infrastructure while maintaining Legacy and targeting maintenance of current operations while, expanding scope and moving key CRM application from 10 year old operational CRM system, in parts, to SalesForce Core linking back to new back-office system of ODS MS SQL databases, supporting 4 reporting systems; Cognos 10, Crystal, Tableau and SSRS, Goal was a consolidated and Automated BI System.
• I supported and extended the Intranet and Customer facing extranet SharePoint Portal creating an improved indexing tool set with enhanced search for a 6 TB legal document database, critical to main LOB, and created customized components utilizing .NET tools, Upgraded to SharePoint 2010 and built a whole series of BI components for specialized data reporting and access in near real time, building out the back end Datamart with CDC and complex views for reporting. All controlled by Roles in Active Directory. Built out, customized and took through testing a 2013 SharePoint Installation.
• After the analysis stage and planning for Legacy we retired 10 physical servers, regularized and expanded our Amazon AWS presence and built out a VMWARE 4.X Installation with a physical installation of 4.X VSPHERE and 3 Physical servers supporting 192 GB RAM; all this supporting 40+ VMs replacing everything from 2005 through 2008 Server and SQL. 6 Months later we switched to 5.X which allowed RAM expansion and SQL 2012. I was directly responsible for a growing Amazon AWS installation, supporting Social Media Data, Software Development needs and a Microsoft Azure site that supported Data Marts for reporting.
• I led/executed the effort to identify a product, test and install/replace Backup Exec with AppAssure. Reduced maintenance (required by large quantity of tape swaps) 80% with no off hour presence local requirement or tape bays.
• I supported MS GP for Finance; including ETL transfers to the ODS. I installed, upgraded and supported the Visual Studio 2012->TFS environment used by straight line development at Sokolove Law and the Social Media Environment (AWS based) at D50 Media.
• In 2012 we began the effort to replace our TEMPprincipal .NET CRM system, Pivotal, with Salesforce. Tested two products in situ (Microsoft Dynamics and SalesForce. Management chose SFDC as the CRM, I led/executed the effort to identify a product, test and install a near real time ETL product (Jitterbit) that would both allow us to constantly stream data to and from SalesForce and the Legacy System. A growing percentage of functions were replaced by SalesForce with the information returned to the Legacy CRM system both for operation, archiving and reporting use. By 2014 the Local CRM system would be in SalesForce and the same near real time ETL, Jitterbit, software would be morphed into a support system to stream data to a planned ODS (Operational Data Store) This would contain Operational and Back-Office Databases which would tan automatically present feeds to support everything from a Data Warehouse to the four reporting engines to real time Dashboard Feeds to SharePoint.
• I led/executed the effort to identify, test, install and support a new high end reporting product for the Analytics Group. The product was Tableau and it is currently in use both for Analytics and reporting. I built out the needed servers, installed Tableau, built out needed Data Marts and the Repository, designed the first 25 reports, trained the two point people for the users and acted as general oversight for the product.
• I managed, designed and tested SSIS to replace Datastage. All the while I supported analysis, ETL dBs and Reporting covering everything from government table intakes to operational reporting to Google Analytics.