Summary

• Strong leader with more than fifteen years experience in the technology field and over 10 years as an Architect, Administror, Analyst and Developer in manufacturing / healthcare / automotive / communications / financial / insurance / logistics and retail environments, including serving as direct CIO report for several multi-billion dollar global companies.
• For many years, I've been engaged in large scale data warehousing modeling, analysis, design, development, and performance tuning for 1 TB implementation of data warehousing and BI analysis and Big Data for the departments of education for the states of Louisiana and Michigan, as well as similar architectures for other large commercial organizations. I have extensive experience in big data, from desktop to complex multiple integration and ETL, as well as analyst and consultant in diverse business backgrounds for worldwide to workgroup organizations.
• As a specialty I work with Microsoft, Oracle, IBM, NoSQL and open source product stacks - DB's large scale high availability with multiple data centers , data warehousing design, turning, problem solving, ETL , Modeling ER/Win, and many others , Analysis SSAS Cubes, PowerPivot, PowerView, SAP, SAS, BO, etc. , integration, XML, SOA, and BI reporting. I also have strong background with enterprise application systems such as SAS and SAP as well as very large scale Sharepoint 2007, 2010, 2013 implementations.
• Proven ability to create, sell and manage successful personnel and projects with mission critical company and vendor management needs. Responsible for creation and implementation of policies, procedures and documentation for: SDLC, budget, SOW, schedule and project / program management. Currently pursuing PMP certification.

Experience

Confidential

Served as the Solution Architect, Data Architect, Data Base Consultant and Modeler for various companies.

Main clients include: Direct Supply, United States Department of Veterans Affairs ,Cooper Standard AutoMotive, University of Michigan Health Systems, Associated Bank, ITT and Borders Group.

Main Responsibilities:

• At Cooper Standard Automotive Tier 1 automotive worldwide supplier, provided solution expertise - system review architectural and performance , procedural and practice recommendations for the consolidation of SQL Servers supporting 90 sites and multiple instances worldwide.
• For the United States Department of Veterans Affairs, provided solution expertise - system review architectural and performance , procedural and practice recommendations for the nationwide integration of utilization management UM for the Veterans Administration Health System. Utilizing Microsoft best practices and technology, including SQL Server 2005: database, integration, analysis and reporting services - along with Office - to insure that the VA UM system provides top level performance and stability.
• For the University of Michigan Health System, provided expertise for launch of computer based patient ordering for the health system composed of multiple consolidated clustered / replicated SQL Server 2005 SAN based environments with Oracle legacy systems data feeds. Analyzed existing systems profiling usage and capacity trends for SQL and Oracle OLTP and OLAP oriented data bases and warehouses.
• For Stone Plastics, created a solution to analyze manufacturing data PLCs, computers, machines, etc creating a dashboard of BI reports, charts, etc. utilizing MOSS 2007 workflows, IronSpeed web development and Dundas charting components.
• Led Check 21 data base remediation for Assoicated Bank. Administered over 50 6.5, 7 and 2000 SQL Server and Oracle servers. Consultant for all aspects of database administration, including data modeling and enterprise reporting. Database Transformation Services DTS included designing new DTS programs and debugging existing programs. Reviewed and recommended architectures, procedures and code for enterprise operation and process improvement.
• At HealthMaster, responsible for architecture, analysis and automation of X12 EDI HIPAA 837 billing system using Microsoft MSF practices and technologies including Biztalk 2004 with VB.NET 2003 and C .NET 2003 for extraction, transformation and loading ETL of large scale X12 data sets and Visio Enterprise Architect for UML and data modeling. Methodologies conformed to MSF and CMM Level 5 Optimizing continuous process improvement.
• At ITT, was esponsible for architectural analysis and creation of data base design, processes, procedures and documentation for construction of an infrastructure system capable of integrating existing worldwide Active Directory e-mail , VPN, WAN and other systems for single point reporting and chargeback for a worldwide base of over 39,000 users. Technologies included DTS for extraction, transformation and loading of data from a variety of different platforms and vendors using procedures conforming to standards fulfilling CMM Level 3 Defined guidelines.
• At St. Johns Health System, was esponsible for creation of procedures and documentation installation guides, Run book, etc. for installation and operation of data center level SQL Server 2003 enterprise clustered database software for large scale multiple enterprise application system environments.

Direct Assignments

Confidential

I work with Microsoft based technologies to deliver DW/BI portal solutions founded on the MS self service pathway. This includes governance, guidance, development and strategic direction for architectural design, installation and implementation of large scale solutions for interal and external business needs. These solutions embrace the Microsoft service paradigm of a proven commercial foundation utilizing technologies such as SQL Server, SSAS, SSAS, SSRS, DQS, MDM and many others. I work across all aspects and levels within an organization from C-Level through mentoring junior personell.

Confidential

For the largest health care logistics company, part of the team leading innovation and support for this organization for 100 operational DBs as well as multi-TB BI and Enterprise Data Warehousing based on large SQL Server DB infrastructure.

Confidential

Provided analysis and consulting services for review and development of improvements to existing and new development for Enterprise Data Warehouse, OLAP OLTP systems and new mission critical systems to meet business needs for a variety of clients including the non-regulated utilities of Wisconsin and Chicago. SDLC TFS as a large part was a crucial element in allowing tracking, buildout of products and management reporting.

Confidential

Responsible for auditing, performance and design review and developing improvements for legacy Data Warehouse and OLTP systems and new mission critical systems to meet business needs for primary business departments for a leading commercial trucking logistics company. Trained and mentored existing DBA and development teams in scalability and cloud based impacts of future company directions.

Confidential

For Johnson Controls Incorporated, I was responsible for data modeling, SSDS / SSIS / SSAS / SSRS design and reporting development for a board level pilot project in cooperation with Microsoft Corporate. Using Kimball based DW design for integration with multiple source vendor systems, designed and implemented from source input via ETL to staging and reporting systems for this pilot.

Confidential

Responsible for physical design of the data warehouse for the state of Michigan Department of Education. Using Kimball based data modeling and DW design for integration with multiple source vendor systems, designed and implemented from source input via ETL to staging and reporting systems for this longitudinal data system for K-12 education statewide.

Confidential

For the Louisiana Department of Education, I led reporting and analytics for statewide Longitudinal Data System project. Using Er/Win and other modeling tools and techniques, responsible for modeling, design and development of reporting standards and practices for state and federal OLDS requirements, working with, and adding significant capability to, Kimball group enterprise partners creating similar solutions for the Lousiana Department of Education.

Confidential

• Responsible for SharePoint security, backup / recovery processes, configuration, administration and support of SharePoint farms. Responsible for performance, configuration and application issues. Also responsible for large SQL Server 2008 R2 clusters including database, integration, analysis and reporting services.
• Environment: SQL 2008 R2 Clusters, SSIS, SSRS, SSAS, Cognos, JDE, Sharepoint 2010, PowerPivot 2010, PerformancePoint 2010, Windows 2008, iSeries

Confidential

Responsible for datacenters comprised of 7, 2000 and 2005 SQL Server, Oracle and DB2 servers hosting an enterprise .com HA composed of multiple data centers hosting 12 high end 32 and 64 bit servers in a distributed clustered replicated / mirrored environment. Lead for all SQL Server 2005 installation, migration, planning, test and implementation processes and groups for database SSDS , integration SSIS and reporting SSRS projects, including multi terabyte partitioned data warehouse and ODS stores and Symantec I3 performance warehouse. Reviewed and recommended architectures, procedures and code for enterprise administration, operation and process improvement.

Confidential

Managed a variety of projects including leading the architecture for the largest 20 member Microsoft Internet enterprise application development with particular critical QA and implementation needs for Exel, a leading logistics company. Initiated best practice methodologies, creating uniform standards, guidelines, procedures, and processes for a clustered Windows 2k load balanced .NET based server farm environment. Methodologies conformed to CMM Level 3 Defined and CMM Level 4 Managed disciplines. Provided top level problem resolution for major customers in implementation and operational support of CA products and services. Technical lead for internal worldwide document and process management for program management office PMO and ISO certification.

Confidential

Reporting to the CIO, provided technical expertise, procedures and education to the Systems and Programming staff, to architect and create from scratch a cost effective development and operations environment allowing staff to concentrate on providing business solutions, not solving technical problems. Responsible for development and maintenance of data base and data communications: methodologies, standards and procedures, hardware and software identification and procurement, data base design, extraction, transformation and loading ETL , program requirement specifications, backup and recovery, performance tuning and operations monitoring. Responsible for procurement and installation of data center hardware and software for multiple system clustered environments.

Confidential

Led the development team for SuperGlue , a version control, distribution releasing, and tracking system for the Mopar Diagnostic System MDS . The system maintains the software residing on the four CD's and hard disks in each MDS unit, installed at the many thousands of Chrysler dealers world wide.

Skill Sets

• Engaged in large scale data warehousing modeling, analysis, design, development, and performance tuning for 1 TB implementation of data warehousing and BI analysis and Big Data for the departments of education for the states of Louisiana and Michigan, as well as similar architectures for other large commercial organizations.
• 15 years experience as Architect, Modeler and DBA for SQL Server 6.x-2012 , Oracle 7-10g , DB/2 and other vendors.
• Managed large 20 teams including sub-contractors - delivering multi-million dollar cross-functional, high priority enterprise-wide IT projects including implementation of policy procedures using CMM, PMI and UTIL practices and tools. 10 years of technical leadership.
• 10 years experience writing complex stored procedures for one or more of SQL Server 2000, Oracle8i or DB2/UDB.
• 10 years of SQL, Perl and PL/SQL.
• 10 years of VB and C programming.
• 5 years of C programming.
• 5 years of UNIX shell script programming.
• 3 years in a J2EE environment.
• 10 years of experience to SDLC practices and tools including Team Foundation Server, MS Project Source Safe, Rational Tools, Mercury Tools, PVCS, Compuware, BMC, CA, etc.
• Demonstrated vendor management and executive liaison capabilities.
• Expert understanding of ERP systems including MS Dynamics CRM, Finance, etc. , SAP, JD Edwards, Peoplsoft and others.
• Expert understanding of modeling data and EAI application tools and processes Power Designer, Er/Win, ER/1, Systems Architect, and Visio VEA , physical schema properties, triggers, stored procedures, and database backup, restore and recovery processes.
• Expert understanding of performance and service agreement methodologies and implementation and vendor tools, including Tivoli, Unicenter, Symantec, Tealeaf, etc.
• Experience with metadata management tools such as Ascential'sMetaStage, Informatica'sSuperGlue, CA Advantage Repository PR/MVS or PR/OEE , ASG Rochade, Adaptive, MetaMatrix and DAG MetaCenter.
• Expert understanding of data clustering SQL Server 2000 , server farms Windows 6.5-2003 and Unix , load balancing SQL Server, Windows and Sybase Unix and data communications DirectConnect, MQSeries
• Expert understanding of extraction, transformation and loading ETL processes DTS, InfoPump, DT/Studio, etc.
• Expert understanding of current Microsoft enterprise level system / infrastructure design / development suites Visual Studio 2003 / 2005, Visio for Enterprise Architects 2003 VEA , Orchestration Designer for Business Analysts 2004 ODBA , BizTalk 2004, SharePoint 2003, MSF, etc.
• Strong understanding of data-warehousing/OLAP and ERP packages in particular PeopleSoft and Lawson - also SAP, Oracle, and Siebel.
• Stong understanding of IronSpeed web application creation and Dundas charting.
• Strong understanding of document, image, and content management / workflow systems FileNet, Documentum, SharePoint, Content Management Server, etc. .
• Ability to automate administration tasks, perform capacity planning, performance monitoring and tuning and administer security.
• Strong optimization skills Cast Software, MS SQL Profiler, Embarcadero, SQL Power, etc. , especially with high volume databases >300GB and large, distributed J2EE systems.
• Administration on AIX/Solaris/HP/LINUX/Windows Server recovery skills important .
• Experience using Object Oriented Methodologies, Java, Visual Basic, C/C , JDBC and ODBC.
• Significant O/S experience in Windows Server, UNIX and Linux platforms.
• Ability to think big and grasp the overall picture.
• Extensive experience in big data, from desktop to complex multiple integration and ETL, as well as analyst and consultant in diverse business backgrounds for worldwide to workgroup organizations.
• Worked with Microsoft, Oracle, IBM, NoSQL and open source product stacks - DB's large scale high availability with multiple data centers , data warehousing design, turning, problem solving, ETL , Modeling ER/Win, and many others , Analysis SSAS Cubes, PowerPivot, PowerView, SAP, SAS, BO, etc. , integration, XML, SOA, and BI reporting.
• Strong background with enterprise application systems such as SAS and SAP as well as very large scale Sharepoint 2008, 2010, 2013 implementations.