Sql Server Manager

Location:

Phoenix, AZ

Posted:

July 30, 2017

Contact this candidate

Resume:

Mark A. Woodrick

Mobile: 480-***-****

**********@*****.***

Objectives

Innovative leader of business intelligence, infrastructure architect, designer and developer with over 34 years’ experience, offering extensive hands-on and team management experience in enterprise class projects within the Healthcare, Banking, Aerospace, State Government, Electric Power and Automotive

(logistics) industries. Proven capabilities include the following;

• Proven ability to leverage the corporate vision into line of business and tactical objectives.

• Deliver results beyond the strategic roadmap.

• Latest skills listed below in big data, virtualization / visualization, web services, Cloud (Azure, AWS), communications and consumer technologies.

• Expertise with a wide variety of computer hardware, development platforms and software applications.

• Provides thought leadership on architectural designs and methods, business alignments, component- based development and the use and/or development of common frameworks resulting in the creation and deployment of enterprise-class solutions.

• Proven developer of relational/non-relational databases within a healthcare, finance, and manufacturing environments.

• Possess excellent verbal communication and programming skills.

• Proficient in Agile, Scrum, Iterative, and Waterfall methodologies:

• Demonstrated expertise in resolution management, exemplary leadership, and positive goal-directed communication skills.

Education

Bachelor of Science in Computer Information System 1994 - 1997 University of Phoenix - Phoenix, Arizona

Additional areas of interest and course work in mathematics and science Masters of Science in Computer Information Systems 1998 - 2000 University of Phoenix - Phoenix, Arizona

Additional areas of interest and course work in database design and Methodologies. Programming

AWS (EC2, S3, RDS), HQL, VQL, WPF, WCF, J2EE, MDX, DAX, Jscript, C#, R and RStudio Statistics, VB.Net, Java, PHP, PERL, HTML, ASP, T-SQL, PL-SQL, VBScript, SOQL some F#, Python, Jython, PG-SQL and Micrsoft Azure.

Platforms

Microsoft Windows (all versions), Windows Server 2012, AWS w/ EC2, S3, RDS and ElasticSearch, Postman, Splunk, Cloudera, Hadoop, Sun Solaris, UNIX, Linux, DOS, MVS, OS/2 and Linux Redhat. 2

Work Experience

Ready Logistics – Cox Auto Logistics (contract) January 2017 – Present Business Intelligence Lead, Architect and Data Modeler

(6 months)

Other Duties: Cloud Infrastructure, Developer, Agile Leader, Administrator, Architect/Database Designer, BI and Analytic Leader.

Led the Business Intelligence team in designing a cloud based solution for the Data Analytic group. This includes setting up and configuring Tableau Server, DynamicNav, and PowerBI.

Coordinated efforts for server setup with our infrastructure team for new virtual servers in the I/O Data space.

Initial scope was to externalize operational reporting from Salesforce as a reporting platform to a cloud based analytic platform.

Worked with the Infrastructure team to identify vulnerabilities such as; Untrusted domain and ACL issues between the business segments.

Created a virtual ‘Staging’ environment in AWS EC2 and RDS (Oregon Region) due to cost limitations in the IO data space.

Coordinated the SSIS creation and deployment initiative for the Data Governance team to ensure Data continuity from the landing zone through the Operational Data Store and subsequent Bounded Context (CQRS) to support the event-driven architecture.

Trained, setup and guided the team in proper use of JIRA from an Agile Methodology (Cafe). Led the estimation planning efforts for the BI team to ensure we kept on track for our biweekly sprint burndowns and to keep the backlog health inline.

Coordinated the review and technological direction of the current infrastructure from dedicated DC servers and began the initiative for moving to a cloud-based solution.

Coordinated with Cox Enterprises shared services team and other BU’s to create service-level accounts to resolve the domain trust issues by using other BU’s as a hop to/from Cox.

We delivered sourcing objects to support the data analytic team for proceeding descriptive, prescriptive and predictive analytics. Worked with and designed Tableau dashboards using the new Provider source.

Thought leader in designing, implementing, and configuring departmental infrastructure, Database structure, and good security practices.

Lead the development team in agile whiteboard design sessions. Helped define User Stories, Work Items, Tasks, Issues/Bug fixes to better track the design iterations (i.e. burn downs, etc.).

-- Tools and Technology:

AWS (EC2, S3, RDS), ElasticSearch (Event-driven architecture), Postman, Windows Server 2012, MSSQL Server 2016/2014, BI Stack, Tableau 10.x, JIRA, Team Foundation Server, VS Suite (2015), MS Office Suite (2013), O365, PowerBI, Adobe Analytics, PowerBI, Microsoft Project, Salesfore, and Agile (Epics, Stories, etc.). 3

TriWest Healthcare Alliance (contract) June 2016 – November 2016 DW Manager, EDW Architect and Sr. Data Modeler

(4 months – Prep for IBM Transition Team)

Provider\Claims Architect/Designer, Database Designer, TDS Admin, Agile Other Duties: SQL Developer, Requirements, DA, BA, Tableau, and ERWin Modeler

Led the Enterprise Data Warehouse team for the Veterans Administration Provider Services.

Created the SSIS ETL Framework (via BIML) and lead the effort for the Data Governance team to ensure Data continuity from the landing zone through the Operational Data Store and subsequent EDW (Star Schema).

Trained, setup and guided the team in proper use of Team Foundation Server from an Agile Methodology. I led the tea shirt size estimation planning efforts. Setup and assisted the EDW Manager and Director about the Agile lifecycle.

I setup a POC Trello Collaboration to ensure a cohesive coordination of the teams during the system development lifecycle.

I created numerous SDLC template documentation to further assist both TriWest and the transitioning IBM team in further documenting the "what" and "how" of the existing process.

We delivered on the slice of the Provider Services EDW for predictive and descriptive analytics. Worked with and designed Tableau dashboards using the new Provider source.

Designed, implemented, and configured several departments IT Infrastructure, Database Administration, Infrastructure and Engineering.

Lead the development team in agile whiteboard design sessions. Helped define User Stories, Work Items, Tasks, Issues/Bug fixes to better track the design iterations (i.e. burn downs, etc.).

-- Tools and Technology:

MSSQL Server 2008R2/2012, SQL Server BI Stack, Tableau 9.3/10.0, Team Foundation Server, VS Suite (2012), MS Office Suite (2013), PowerPiviot/PowerView, CA ERWin, BIML, Microsoft Project, and Agile (Epics, Stories, etc.). 4

Nationwide Insurance (contract) February 2015 – April 2016 Sr. Program/Project Development Lead

(1 Year 2 months)

RAPID RDS Architect/Designer, Database Designer, Administrator, Developer (WS) Other Duties: Infrastructure Designer, Provisioning, Agile, PowerPivot, Tableau, ERWin Modeler

As a member of the Program Leadership I provided input and direction to the executives regarding the technology approach.

Designed several semantic layers in both virtualization tools such as Denodo and visualization toolsets like Tableau, PowerQuery, PowerMap, PowerPivot, and Business Objects to deliver enterprise class predictive, prescriptive, and descriptive analytics.

Designed several MDOLAP, OLAP SSAS cubes (with asdatabase deployments), SSIS (with biml\ispac deployments) and SSRS reports. Expert in MDX and DAX for cubes and BIM’s

(tabular).

Designed and aligned the 64 bit development platform with 64 bit tools, integrations to Oracle 10g/12c and SQL Server 2012.

Created high level designs for our project to interact with the vendor product through web services (SOAP, REST, WSDL, etc.) using insurance industry standards of ACORD XML and XSDs

Designed, implemented, and configured several departments IT Infrastructure, Database Administration, Infrastructure and Engineering.

Extracted from multiple data sources into our development environments (via Sqoop (SQL + Hadoop)). Also worked in the HDFS and created Hive queries.

Lead the development team in agile whiteboard design sessions. Helped define User Stories, Work Items, Tasks, Issues/Bug fixes to better track the design iterations (i.e. burn downs, etc.).

Coordinated and organized the Informatica PowerCenter/Data Quality training, 9.5 to 9.6 migration and new repository builds, and Informatica client tool upgrades plus server and local connectivity’s.

-- Tools and Technology:

SQL Server 2012, SQL Server BI Stack, Tableau 9.6, OLAP/OLTP, Team Foundation Services, VS Suite (2012), BigInsights/Sqoop, MS Office Suite (2013), PowerPiviot/PowerView, MDX-DAX, SharePoint and Microsoft Project, Agile 6.2

(Epics, Stories, etc.), SCRUM

Ports America (contract) March 2014 – November 2014 Sr. BI DM and EDW Designer/Developer

(9 months)

DM/EDW Architect, TFS Admin, BI Designer/Developer (Stack) and DB Modeler Other Duties: PowerPivot, Tableau, ER Studio Modeler

As a member of the Project Leadership I provided input and direction to developers and the architects regarding development and technological approaches.

Designed and developed Tabular Analytic Models (BIM's), KPIs, Dashboards which met the business needs.

Designed and created technical analysis for pending KPIs from existing Dimensions and Fact tables.

Lead the development team in agile whiteboard design sessions. Help define User Stories, Work Items, Tasks, Issues/Bug fixes to better track the design iterations (i.e. burn down reports).

Designed. Developed, and managed the West Coast Container (WCC) ports and coordinated with the East Coast ports on shipping schedules and GPS coordinates.

Designed and developed the WCC and Procurement SSIS ETL packages for several marts.

Designed and aligned the 64 bit development platform with 64 bit tools, integrations to Oracle 10g/12c and SQL Server 2012.

Designed and developed Tableau reports and dashboards from both the BIM and relational structure.

Setup and designed Team Foundation Server for development and deployment of our BI stack.

Created burn down reports and trained the team to properly manage their project branches and BI deployment packages.

Worked in debugging source code developments to Tier 3 troubleshooting.

Completed detailed management-level PowerPivot / PowerView reports, outputs in VS 2012 and deployed them to the SSRS Reporting Server.

-- Tools and Technology:

SQL Server 2012, SQL Server BI Stack, Tableau 8.1/8.2, OLAP/OLTP, Team Foundation Services, VS Suite (2012), MS Office Suite (2013), PowerPiviot/PowerView, MDX-DAX, SharePoint and Microsoft Project, Agile 6.2 (Epics, Stories, etc.), SCRUM 6

Eldorado Computing Inc. a division of Mphasis February 2009 – November 2013 Sr. Data Modeler

(4 Years 9 months)

Industry: HealthCare/Ambulatory Health Care Services Infrastructure Design, DM Architect and DSS Solutions Other Duties: Systems Infrastructure, Database Design and Business Intelligence

As a member of the Project Leadership I provided input and direction to developers and the architects regarding development and technological approaches.

Developed and reviewed technical and business artifacts which define the architecture of the solution. Ensuring design best-practices for SQL Server and Postgres databases, implement agile methodologies.

Created Actuate and JasperSoft analytics executed against my statistical models for mid-level to senior level management. Created complex analytics and dashboards.

Designed and created new technical analysis for KPI and Executive Dashboards.

Installed and configured a single node of the Hortonworks HDFS with the ability to create Hive queries. HBase and HCatalog was developed by the development team but the analytics was completed by me.

Designed and created new technical analysis requirements (documentation) for query optimization. On-going quality initiatives to optimize existing and new database designs.

Created their operation data store (and data marts) for functional fact tables, analytics using MDX. Took more of an MDOLAP approach from our replicate database. Currently worked on a BCA (business case analysis) of the viability of using Hadoop and a NoSQL approach for outputs.

Considered a technical subject matter expert in SQL Server and PowerShell for data model creation and administration of their custom application.

Designed, developed and deployed SSIS automation against a 2-nodes veritas cluster. Maintained database administration and performed quality initiatives to re-design the Javelina schema. Created an automated SQL Server replication routine to aid in Javelina release process.

Completed detailed management-level reports, outputs and end user forms in Actuate (.rod) and SSRS.

-- Tools and Technology:

SQL Server 2008/2012, Jscript, Python, RStudio, SQL Server Reporting Services

(SSRS), Actuate, JasperSoft Studio, Hortonworks Hadoop/HDFS (single node)/Hive, SQL Server Management Studio (SSMS), SQL Server Integrated Services (SSIS), JIRA, Extraview, Crucible, PacRAT, SQL Server Analysis Services (SSAS), PosrgreSQL/PGAdmin, Pentaho Kettle ETL, Microsoft Visio, OLAP/OLTP, SVN Tortoise, VS Suite, MS Office Suite, and Microsoft Project 7

Healthways Incorporated, Nashville, Tennessee May 2007 – December 2008 Industry: HealthCare Claim Payment System - Core

Software Architect – Database Design, DW, DSS and BI Solutions Expert Other Duties: Systems Infrastructure, SSIS (ETL), SSRS and SSAS

As a member of the Leadership team I provided input and direction to designers and developers regarding the technological approaches.

Designed and created new technical analysis for KPI from statistical models for the Executive Dashboard(s).

Developed and reviewed technical and business artifacts which define the architecture of the solution. Database design best-practices (SQL Server), implement agile methodologies.

Developed SSIS packages and automation deployments as well as Informatica ETLs (Big- data connectors). Implemented SOA principals and initiatives to re-design the CORE schema and created integrations with SFDC and Oracle financials.

Designed and created new technical analysis requirements (documentation) for query optimization. On-going quality improvements to optimize existing and new database designs.

Considered a technical subject matter expert in SQL Server and Powershell administration for the CORE/Vigor application.

Created their operation data store, materialized views, and functional fact tables, analytics using MDX and DMX.

-- Tools and Technology:

SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), SQL Server Integrated Services (SSIS), SQL Server Analysis Services (SSAS), R Console, VB scripting, Microsoft Visio, OLAP/OLTP, Visual Source Safe 2009/TFS, VS Suite, MS Office Suite, and Microsoft Project

E-Health Partners Incorporated, Atlanta, Georgia (contract) May 2006 – April 2007 Industry: HealthCare/Ambulatory Health Care Services Manager – Information Management and Reporting

Other Duties: Systems and Data Analyst / Reporting Services

-- Tools and Technology:

SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), SQL Server Integrated Services (SSIS), SQL Server Analysis Services, Microsoft Visio 2005, OLAP/OLTP, Visual Source Safe 2005, Crystal Reports 9.0-11.0, Visual Studio.net, Microsoft Project, Microsoft Office Suite

UNISYS Incorporated, Chandler, Arizona (contract) August 2005 – May 2006 Industry: HealthCare/Ambulatory Health Care Services SE II - (HIM) Healthcare Information Management

Other Duties: Systems and Data Analyst / Reporting Services

-- Tools and Technology:

Rational Clear Quest, Clear Case, Crystal Reports 9.0-11.0, Cypress, Visual Studio.net, Microsoft Project, Microsoft Suite

Schaller Anderson Incorporated, Tempe, Arizona May 2003 – August 2005 Industry: Hospitals/Ambulatory Health Care Services Senior Systems Analyst

Other Duties: Business Analyst / Reporting Services Estimated savings: $1.2m annually

-- Tools and Technology:

Info Burst 1.0, 2.0, Crystal Reports 7.0-10.0

Wells Fargo Retail Accounting Division, Phoenix Arizona Sept. 2000 – Dec. 2002 Senior Application Developer

Other Duties: Developer, PM, Administrator, Trainer Estimated savings: $750,000 annually

-- Tools and Technology:

Microsoft SQL Server 7.0 / 2000, SAS, Sybase Power Builder 8.0.1/8.03 Embarcadero DB2, Visual C++, Visual Basic 6.0, VB.net, C#, Active Directory, IIS, Windows XP/NT, 4.0/2000, Microsoft Access 97/2000, Microsoft Suite, Crystal Reports 8.5/9.0, PC Anywhere Visio 2000 RAD (Rapid Application Development) Design Methodology, SEI, Erwin, Visio 2000 and Microsoft Project 2000 TRW Vehicle Safety Systems August 1989 – July 2000 Queen Creek/Arizona

Other Duties: Project Manager / Network Administrator / Technician Programmer Analyst/Development/Hardware Implementation Other Duties: Project Manager / Network Administrator / Technician

-- Tools and Technology:

Microsoft Visual Basic 5.0/6.0, Visual Studio Suite, InterDev 6.0, Visio, ASP, Erwin, Windows 98,VB Script, HTML, VSS, COM/DCOM, Microsoft SQL Server 6.5/7.0, Transact SQL and Microsoft Access 97/2000

Affiliations

11/2015 - Present IEEE Member Electronic Engineering 04/2016 - Present ITFoM Certified SME Source

07/2015 – Present MCP Foundations (MCDBA, MCP)

06/2015 - Present ASQC CQT Member Certified Quality Technician 03/2015 - Present ASQC CMI Member Certified Mechanical Inspector 9

Skills

Name Expertise Last Used Experience

Architecture

SOA (TOGAF) Expert Currently used 8 years

Development

Visual Studio.Net (all versions) Expert Currently used 10 years VS 2012 C# and F# Intermediate Currently used 4 years Java (J2EE, Spring) Intermediate Currently used 2.5 years Big Data

Hadoop (Hortonworks) Intermediate Currently used 4.0 years HBase/HCatalog Intermediate Currently used 3.5 years BigInsight (Infosphere) Intermediate Currently used 2.0 years Hive (HQL) Intermediate Currently used 3.5 years

Database Design

SQL Server (all versions) Expert Currently used 16 years Postgres 8.x/9.x Expert Currently used 5 years

Oracle (10/11g/12c) Intermediate Currently used 4.5 years Teradata Intermediate Currently used 2 years

Data Virtualization

Denodo (5.0/5.5/6.0) Expert Currently used 5 years Data Visualization

Tableau (8.3/9.6/10.0) Expert Currently used 6 years Power BI Expert Currently used 2 years

PowerPivot (PQuery/PMap,PView) Expert Currently used 7 years JasperSoft Studio (6.x) Intermediate Currently used 2.5 years Business Intelligence

MS BI Stack (SSAS-MDX, BIM) Expert Currently used 7 years Crystal OLAP Cubes Intermediate Currently used 1 year ETL/ELT

Microsoft Integration Service (SSIS) Expert Currently used 9 years Informatica PowerCenter (9.5-9.6) Intermediate Currently used 4.5 years Informatica Data Quality (IDQ 9.6.1) Intermediate Currently used 3 years Informatica Analyst Intermediate Currently used 3 years Pentaho Kettle ETL Intermediate Currently used 4 years Reporting

SQL Server Reporting Services (SSRS) Expert Currently used 5 years Microstrategy Expert Currently used 2 years

Business Objects (Dev/CE) Expert Currently used 5 years Administration

JIRA (all versions) Expert Currently used 7 years

Crucible Expert Currently used 1.5 years

Extraview Expert Currently used 2 years

Team Foundation Service Intermediate Currently used 4 years Scripting

Powershell (all versions) Expert Currently used 3 years VB Script Intermediate Currently used 6.5 years

Support Applications

SharePoint 2010/2013 Expert Currently used 7 years HP Service Center Expert Currently used 3 years

HP Clarity Expert Currently used 2 years

BOSS Expert Currently used 2 years

Windows Server Expert Currently used 3 years

Microsoft Office (365) Expert Currently used 6 years Microsoft Project (all versions) Expert Currently used 5 years HP Openview Intermediate 5 years ago 1 year

Configurations

MTS and MSMQ Expert 2 years ago 3.5 years

ASP.net Intermediate Currently used 1 year

Data Modeling

ER Studio Data Architect Expert Currently used 2.75 years Microsoft Office Suite Expert Currently used 6 years Visio (all versions Expert Currently used 3 years

CA Erwin (all versions) Intermediate Currently used 2 year Additional Information

Microsoft SQL Server Certified-all versions

BI Stack (SSRS, SSAS, SSIS) Certified-all versions ASQC CMI Certified

ASQC CQT Certified

Net Development Suite Certified-all versions

Postgres implementation on Windows Certified-all versions System Administration for Microsoft SQL Server Certified MCSE, MCDBA, MCP Certified

Contact this candidate