Sign in

IT Data Management Hands On Professional

Prior Lake, Minnesota, United States
January 09, 2017

Contact this candidate

Scott Barsness IT Professional Data Management & Architecture

***** **** *** ******, ** 55378 651-***-****

Entrepreneurial, innovative Information Technology professional with broad-based management, leadership, technical and communication skills, paired with a broad understanding of the critical technologies, persistence on aligning IT strategies to corporate goals and objectives with the belief that the most important thing is the delivery of business value. Notable Accomplishments:

Architecting Master Data Management Marketing Customer MDM solution Roadmap, Enterprise Data Management functions, Infrastructure strategy, Reporting and Analytics.

Architecting and designing MDM solution using Microsoft Master Data Services.

Reduced costs for compliance data feeds and other business units centralizing data movement using Data integration strategy.

Transitioned firm to employ Data Management Services change management system for applications development slashing time-to-deliver by 50%.

Implemented rigorous development and testing processes decreasing software defects by 60%.

Slashed production support processes by 50% along with reducing production support overhead costs with implementation of methodology processes and change/release management system.

Facilitated and maintained enterprise information architecture for unified access to structured and unstructured data across multiple data sources, including data warehouse and machine data.

Designing ODS/Data Lake with Hadoop HDFS files system building Data COE for business.

Spearheading of flagship product from Oracle to Mongodb within Azure IAAS building out replica sets within 3 global and regional data centers.

Designed and implemented data solutions using Master Data Management principles and tools.

Designed and implemented data governance and quality initiatives ensuring consistent translation and usage of data.

Partnered with leaders and team members across the business to design and institute practices that will drive the appropriate levels of rigor and quality in enterprise information architecture.

Analytical professional skilled in successfully building relationships and promoting synergy across business lines to drive comprehensive business approaches that enhanced profitability. Areas of Expertise include:

Strategic Planning & Forecasting

Multi-Million Dollar Projects

Revenue & Profit Growth

Business Development\Cloud

Relationship Building

Project Management

Solid Database Management Big Data

Staff Training & Leadership

Vast Software Expertise

Experience & Notable Contributions

MERRILL CORPORATION • 02/10/2015 – 09/16/2016

Database Manager

Work with Oracle and Merrill team on Oracle licensing renewal and sourcing on master agreement reducing million dollar-licensing fees, team working on project process management and eliminating the order taking process, building best practices, standards and project workflows on how to work with and involve DBAs on projects.

Completed million dollar project migration and upgrade of Oracle eBS environment from 11i to R12 with complete data center uplift 3 tier eBS environment from DC to Fujitsu Cloud, currently managing six 3 tier environments.

Managed team of DB Engineers (production and development DBAs) on site, off site, across the globe consisting of Administration, High Availability, DR, SDLC, DBLC, Change Management, On-call support and Performance optimization.

Save Merrill Corporation thousands of dollars in licensing costs by consolidating business unit SQL Server environments, reducing footprint of SQL Server Standard and Enterprise Edition instances.

Build business case on resource planning proving the need for more DB Engineers to support heterogeneous environment of Apps (eBS) DBAs, SQL Server, Oracle, MySQL, Mongodb, Lawson and Data Architect resources.

Migrate Oracle VMware and Rac environments from Oracle 9.0 and 11g to 12c on new 4 Oracle Database Appliances (ODAs) to reduce million dollar-licensing fees; plan, architecture and design new Mongodb platform in Azure Cloud using IaaS for flagship products migrating from Oracle to Mongodb within multiple DCs and regions with multi-tenant and global and regional replica sets within Azure.

Implement DevOps process working with product Senior Management team and DB Engineers to meet demand and accelerate sprint processing by working with, sitting with, and designing with developers to implement Agile sprints.

Implemented SDLC process of gathering requirements and designing necessary documents around Mongodb required Config, MongoS, Mongodb DB nodes, OpsManager, Replica sets, backup servers, index documents, queries documents and collection documents within MS Azure Pivotal Cloud Foundry micro-services and API layer.

Plan, Design and Mentor Data Sciences team on best practice of scale out model for SQL Server DW stack, MDM, Master Data Services, SSRS, SSIS, SSAS and OLTP/OLAP Reporting applications to create COE with centralized and consolidated footprint and cut costs.

Work on (COE) center of excellence data management proof of technology project providing integration and management of data within a data lake and ODS new environment designing/building building necessary data stores for business units to complete further analytics of their data using Cloudera Hadoop HDFS.

GREEN TREE SERVICES • 4/20/2014 – 2/5/2015

Database Manager

Managed heterogeneous environment consisting of AS400 DB2, Oracle and SQL Server, taking over DBA management role from AVP learning environment, DBAs, MIS and BI teams. Planned and organized Oracle upgrades from 10g to 11g as well data guard for new DR capabilities, organizing SQL Server upgrades from 2005 to 2008 R2 and 2012 and worked on strategy of upgrading all servers and database instances from 2005, 2008 R2 and 2012 to 2014.

Strategized processes to implement performance tuning and analyze best practices for business and application development teams, implementing new best practices, standards, policies and procedures within the SQL Server environment. Worked with DBAs on new daily, weekly and monthly DBA tasks assessed and developed long-term strategic goals for production databases in conjunction with data owners and department managers.

Correlated with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures, designing and implementing short and long-term strategic plans to ensure that database capacity meets existing and future requirements.

Developed, implemented, and maintained policies, procedures, and associated training plans for database resource administration and appropriate use, installed and configured relevant network components to ensure database access as well as database consistency and integrity.

Responded to and resolved database access and performance issues, monitoring database system details within the database, including stored procedures and execution time; worked with DLP team to design and implement system, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

Built MDM solution using MS DQS, SQL Server, SSIS, SSAS and Power Bi tools with DBA team and Data Sciences team working on designing and building up stream enterprise Data Sciences solution working with Marketing and Sales Force teams to provide necessary information to ask questions and to make better business decisions.

CANADIAN PACIFIC • 11/02/2013 – 4/01/2014

Enterprise Data Warehouse Manager

Insourced new EDW team and applications from outsourced environment, creating new enterprise data warehouse infrastructure, people, process and technologies; worked with team of IT personnel to consolidate five existing data warehouses from Oracle, SQL Server, SAP DW, DB2 and other databases to centralized Oracle environment utilizing Informatica as enterprise ETL tool and Oracle 11g as backend database.

Spearheaded process to build new Data Warehouse team consisting of ETL Developers/Architects and Data Architects with business case for these resources to design new Data Warehouse and Data Marts for enterprise and business units.

Spearheading Informatica MDM solution along with business case on Data Governance and Data Quality.

BEST BUY • 10/31/2011 – 11/01/2013

Senior Manager Enterprise/Information Architecture

Provided leadership and direction to the Business and IT aligning data with business goals and objectives, led and implemented new guiding principles, frameworks, reference architectures and best practices; worked with other Architects spearheading Data Governance program and worked with IT on new Data Governance area of practice getting business to be owners and sponsors and key decision makers while formulating governance councils, committees, data stewards and best practices.

Defined Enterprise Information Architecture vision, strategy, principles and standards, got buy-in from stakeholders, management, business partners, and propagated throughout the company.

Provided framework, stewardship, governance and decision making for management of data for project development teams, business users and other stakeholders; balanced short-term versus long-term actions, strategic versus tactical requirements, while continuing to move forward towards the strategic vision.

Delivered road map to achieve the vision, building an enterprise managed information environment for operational and transactional data and for transforming that data into information to support business analysis and reporting. At the enterprise level, the architect wants to provide a consistent view and usage of operational data across multiple applications and to rationalize data and information storage to minimize duplication and simplify access.

Developed enterprise data management methodology and standards, and promoted to both technology and business throughout the company, working on and leading a team consisting of IT and Business users to implement new MDM strategies helping achieve consistency, accuracy, integrity and semantic consistency of master data assets in support of key business and IT initiatives towards successful migration of SOA environment.

Architecting and helping design Data Governance solutions, committees, stewards, council and domains.

Designing from Architecture team Marketing data mart solution to build customer data mart consisting of behavioral data generated from experiences. Selection and scoring of MDM solution vendors as well introduction of data management framework consisting of Data Governance, Information Architecture, DQ, MDM, DW, Metadata and Information security.

MEDICA • 05/26/2009 – 10/31/2011

IT Architect

Led IT Architect Health Management project designing strategy with the business, partners and peers to allow Medica members to participate in and take Health Assessment, Goals and Lessons integrating data to and from vendors into a Health Management operational data store; designed strategy to integrate system of record data from COSMOS and UP systems for eligibility, member, customer, group, and claims data.

Served as Lead Architect working on data integration patterns, best practices, data governance and BI strategy, Lead Architect designing data store of UP data SOR of Customer, Policy, Member, Provider and Claims data based on daily files received from UHG, Lead Architect working on designing strategy of BUS Architecture for multiple Data Marts, Lead architect working with peers to help design Architecture principles along with people process and technology to gain that synergy with the business.

Designed and maintained data marts and MDW (Medica Data Warehouse) environments, was Lead Architect with Cognizant (offshore and onshore) integrating and designing multi-million dollar project within Health Management directing, leading JAD sessions, strategizing and mentoring business and consultants; worked with IT peers and center of excellence solutions to realize the importance of information, which is an asset to the corporation and the realization that of need to start, manage data and integration patterns of data.

Worked with business and portfolio managers to collaborate with, identify and define business subject areas and information needed based on operational or analytical; coordinated and implemented EDW BUS mart processes re-architecting existing data marts to start pulling data from subject area and source ODS environments.

VIRACON • 11/19/2007 – 05/2009

KForce Sr. Management Consultant

Spearheaded phase II of DW/BI strategy consisting of Microsoft Office SharePoint 2007 and Performance Point 2007 server to be a part of enterprise data warehouse Bus Architecture strategy, providing leadership and long-term vision of development and management of enterprise data warehouse architecture and Roll out ProClarity, using PAS and SharePoint 3.0 for phase I until discovery process was completed for MOSS.

Mentored Senior Management and staff regarding business value of what BI brings and provides to the business and IT.

Managed and maintained business case, project, project plan, proof-of-concept, and proof-of-architecture strategy success, working on data consolidation strategy using SSIS to integrate data from legacy system, Oracle, and SQL Server to SQL Server 2005 master data management repository for Data Warehouse system of record.

Performed hands-on developing all databases on SQL 2005, ETL using SSIS, Cubes using SSAS, Reports using SSRS, briefing books using ProClarity, SharePoint for management of documents, Dashboards, reports, and PPS 2007 monitoring for dashboards and scorecards integrating with ProClarity Analytic Server.

CHS • 10/2007 – 11/2007

Growe Technologies Sr. Management Consultant

Planned, coordinated, directed, designed and worked with IT resources from CHS to understand current data management environment and determine issues or concerns existing regarding data, management of data, and accuracy and consistency of data.

Created working document outlining an enterprise data management strategy that suggested strategies required to add value and how to be successful with these strategies; made sure working document outlined need for significant business sponsorship with clear business drivers, mandates, objectives and milestones.

VIRACON • 02/2007 – 10/2007

KForce Sr. Management Consultant

Ran planning, implementation and mentoring of Viracon IS staff using Kimball method of implementing enterprise data warehouse strategy within SQL Server 2005 environment, directing and leading staff through the SDLC steps of iteration phased approach on implementing data marts starting at the finest grain of sales orders at package delivery line level.

Implemented data integration process using SQL Server replication to staging system then SSIS to load data of Viper system consisting of customer relationship management data and order management system data to enterprise data mart, mentoring staff and setting direction following Microsoft DW Toolkit with SQL Server 2005 as the enterprise database management system and ProClarity as presentation.

Set up data governance, best practices, standards and procedures along with why this is important to IS and the business now and in the future; mentored IS resources on importance of data as asset to Viracon and how this data adds value to the business within the Data Warehouse environment.

DIGINEER • 09/2006 – 12/2006


As Senior Consultant within Enterprise Data Management practice working on SQL Server migrations from SQL 2000 to SQL 2005 worked with and partnered with clients to help implement data management strategies; completed assessment for client requesting help identifying issues reducing costs with one of their mission critical applications with identification of space organization on SAN, SQL server configuration changes plus index processing and maintenance.

LIFE TIME FITNESS • 03/2006 – 09/2006)

Data Systems Manager/Sr. Management Consultant

Spearheaded and directed enterprise architecture team along with Senior Management in management and direction of data management and data warehouse management, including setting priorities, best practices, coordinating, standards, policies, and procedures; provided Senior technical leadership to IS and enterprise group with future direction of DRP, fault tolerance, BCP, server consolidation, data architecture, data modeling, data integration, master data management, business intelligence, data warehousing, and database administration best practices along with where all of these add value to the organization.

Established new department, Data Systems Management of data architects and database administrators mentoring what each role is, the value of each role, and responsibilities of each role; formed partnership with business clients and departmental peers on what services DSM was providing, what services clients would like DSM to provide, and what services DSM no longer needs to provide.

Managed all aspects of the Cognos Finance data mart project including sourcing of data, ETL development, profiling of data, quality checking of data, design, and implementation; formulated plan to partner with business to pull all customer data from distributed environment to implement one version of the truth of customer data for new Salon spa application system.

RBC DAIN RAUSCHER • 03/2003–03/2006)

Head of US Brokerage Data Management Services

Oversaw and spearheaded all IT Data Management functions including management of heterogeneous database environment, vendor relationships, technical support, data warehouse / application development and support, financial monitoring and disaster recovery planning; established need for data management department along with managing operating budget and direct activities of 13+ staff.

Challenged to improve productivity and reduce costs through improved uses of technology, authored plans and strategies to centralize data movement and software development processes along with consolidate/upgrade servers and establish consistent standards to eliminate unstable, highly mixed operating environment; authored best practices, methodology for DW/BI/Application systems to increase productivity and availability of mission/business critical applications.

Implemented change control and process documentation for all aspects of the business including new database development and database upgrades, deployed database, hardware monitoring system including multi-tier paging alerts for system issues and initiated metadata management strategy focusing in on business needs to store business data information in centralized location for all business units.

Challenged to improve productivity and reduce costs through improved uses of technology. Authored plans and strategies to centralize data movement and software development processes along with consolidate/upgrade servers and establish consistent standards to eliminate unstable, highly mixed operating environment.

Architected, designed and implemented Data Integration strategy using Ascential software Data Stage, Profile Stage, Quality Stage, Meta Stage and Audit Stage to centralize and manage data integration.

Education & Training

• Mongodb Training • Think IT Leadership Certification • Programming Certificate, North American College • Business Management Training • Professional Management Training • Effective Communication & Listening • Professional Writing • SQL DBA Training • Data Modeling • Data Governance • Data Integration • Data Architecture • Enterprise Architecture, • Mergers & Acquisitions • Agile Methodology Training


Mongodb, MySQL, Oracle, Oracle eBS, Lawson, SQL Server, SQL, SSIS, SSAS, SSRS, DWS, MDSE, ProClarity, MOSS 2007, SharePoint, TOAD; Informatica, Erwin, Cognos Reporting Suite, Oracle Business Intelligence Enterprise Edition, Agile, SDLC, Sybase, MySQL, TIBCO, SAS, JAVA, HTML, XML, E-Commerce, B2B, B2C, Teradata, Neteeza, Lite speed, Spotlight, Power BI, MDM, ODS, DW/BI

Contact this candidate