Scott Miller

Data/Systems Analysis and Business Analysis Consultant at Genesis10

Location
Greater Minneapolis-St. Paul Area
Industry
Information Technology and Services

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you and Scott Miller know in common
  • Get introduced to Scott Miller
  • Contact Scott Miller directly

View Scott's full profile

Scott Miller's Overview

Current
  • Data/Systems Analysis and Business Analysis Consultant at Genesis10
Past
Education
Connections

100 connections

Scott Miller's Summary

Business/data analyst with programming experience, MBA, and PMP certification. Self-directed, dedicated professional with over 20 years of information systems and business experience, from software development to marketing to project management in the mortgage, financial, retail, manufacturing, energy, and nuclear energy industries. Talented at understanding technical complexities and then communicating issues and potential solutions simply and concisely to internal and external project stakeholders at all levels, demonstrating a combination of business savvy and technical abilities. Results-oriented leader with vision to implement projects successfully through the software development life cycle within time and budget constraints.

Scott Miller's Experience

Data/Systems Analysis and Business Analysis Consultant

Genesis10

Privately Held; 1001-5000 employees; Information Technology and Services industry

June 2012Present (2 years 4 months) United States

Client: Enclarity – Healthcare Information (6/2012 – Present)
Data/Systems Analysis and Business Analysis Consultant

- Documented business rules, logical data model, business requirements, and functional specifications for ProviderPoint 6.0, the company’s flagship system that validates, corrects, and augments clients’ provider listings (MySQL).
- Created a template for current and future business rules that could be used by business users for reviewing system functionality and by Development and QA for easily identifying changes and dependencies on those changes.

Privately Held; 501-1000 employees; Information Technology and Services industry

April 2010June 2012 (2 years 3 months)

Data/Systems Analysis and Business Analysis Consultant

- Mapped data from internal data sources (SQL Server) and third party workflow system (eMason) to an operational data store (ODS) to support operational and regulatory reporting. Scrubbed data, inferred duplicate workflow events, created views that served as a pseudo-data mart for reporting specialists, and wrote validation scripts to test the solution.
- Solved complex problem of correctly assigning counts, balances, revenue, and expenses from one system and set of portfolio definitions to Investor Reporting portfolios defined in separate system.
- Automated investor performance reporting by untangling interdependent spreadsheets, using DataDefractor to automatically import data from semi-structured data sources, and reconciling data across reporting databases (Oracle and SQL Server).

Privately Held; 51-200 employees; Management Consulting industry

October 2007September 2009 (2 years)

Client: Deluxe Corporation – Business Intelligence (1/2008 – Present)
Business Analysis and Data Analysis Consultant

- Developed over 200 source-to-target mappings, including source queries, for extract, transform, and load (ETL) processes that moved customer and order information for 13 brands from flat files and Oracle, SQL Server, and DB2 databases to the enterprise operational data store (ODS), enterprise data warehouse (EDW) and data marts to support list extract and call center reporting.
- Delivered mappings and provided support to 10-15 ETL (Informatica) developers, both onshore and offshore (India).
- Worked as liaison to the business and with data architects to creatively overcome several source data issues in order to get complete, accurate, and business-relevant data to the ODS.
- Created test cases, identified rich set of test data, and wrote verification queries to test solution as data moved from source to ODS to EDW to data marts.

Client: Deluxe Corporation – Business Process Outsourcing (10/2007 – 3/2008)
Business Analysis Consultant

- Documented role-based access, non-public information, and privacy impact assessment (PIA) for reports and associated processes being outsourced to India as part of business process outsourcing (BPO) initiative.
- Created matrix of role-based access vs. inputs, outputs, and tools that is used by both the business and IT security.

Project Management Consultant

Otterbase

Privately Held; 201-500 employees; Staffing and Recruiting industry

January 2007October 2007 (10 months)

Client: Nuclear Management Company (NMC) – Application Services (1/2007 – 10/2007)
Project Management Consultant

- Coordinated and planned all activities associated with transfer of fleet applications from managing company to buyers of two nuclear power plants.
- Served as central contact for virtual team of technical experts, responding to requests for code and data, negotiating priorities with Application Services Manager, scrubbing data before transfer, and working with Network Services Manager to transfer third party software licenses and account for fleet hardware.

Project Management Consultant

Analysts International

Public Company; 501-1000 employees; ANLY; Information Technology and Services industry

20042007 (3 years)

Client: Pearson NCS – Desktop Software (11/2004 – 12/2006)
Project Management Consultant

- Coordinated 8-12 member product teams and 2-8 member engineering teams on multiple forms/scanning projects with budgets of $200,000-$500,000.
- Used earned value analysis to support progress reporting for senior management.
- Led product/project roadmap development that aided planning and budget processes.
- Recommended process changes to phase review system (PRS) and managed successful pilot project.
- Process changes resulted in increasingly predictable schedules and budgets (<10% variance).

Client: Best Buy – e-Commerce (2/2004 - 10/2004)
Project Management and Business Analysis Consultant

- Coordinated all online store changes required for Sarbanes-Oxley compliance for online retailer.
- Developed functional requirements specification, use cases, report requirements, and tax calculation model for digital coupon project (e-commerce).
- Documented alternatives to solve complex problem, bridging gaps between business requests, legal requirements, and technical constraints.

Project Manager

Digital River, Inc.

Public Company; 1001-5000 employees; DRIV; Internet industry

20032004 (1 year)

Project Manager and Business Analyst

- Consolidated control and documented requirements for mandatory value added tax (VAT) changes on Digital River and Shareware e-commerce platforms. Project team of the quarter, Q2 2003.
- For key (gold) client, documented requirements for e-commerce platform functional changes and added project management rigor to site development projects.

Consultant

BORN

Privately Held; 501-1000 employees; Information Technology and Services industry

July 1999April 2003 (3 years 10 months)

Client: Thomson - West – Human Resources (5/2002 - 12/2002)
Project Management and Business Analysis Consultant

Client: CHS, Inc. – Propane (9/2001 - 1/2002)
Business Analysis Consultant

Client: CHS, Inc. – Propane (10/2000 - 1/2002)
Project Management, Business Analysis, and Database Programming Consultant

Client: CHS, Inc. – Transportation (12/1999 - 7/2000)
Project Management and Business Analysis Consultant

Client: CHS, Inc. – Refined Fuels Distribution (12/1999 - 7/2000)
Project Management Consultant

Client: Techies.com (8/1999 - 9/1999)
Project Management and Programming Consultant

Product Manager, Core Team Leader, Programmer

Datacard

Privately Held; 1001-5000 employees; Computer Software industry

July 1993June 1999 (6 years)

Project Manager and Programmer - Healthcare Company (5/96-6/99)

Marketing Product Manager and Core Team Leader - QuikWorks Image Capture System (7/93-4/96)

Teaching Assistant

University of Minnesota

Educational Institution; 10,001+ employees; Higher Education industry

July 1992June 1993 (1 year)

Senior Systems Programmer

Unisys

Public Company; 10,001+ employees; UIS; Information Technology and Services industry

May 1989June 1992 (3 years 2 months)

Software Engineer

ETA Systems

June 1984April 1989 (4 years 11 months)

Scott Miller's Skills & Expertise

  1. SDLC
  2. Business Analysis
  3. Requirements Analysis
  4. Software Project Management
  5. Vendor Management
  6. Business Intelligence
  7. Data Warehousing
  8. PMO
  9. SharePoint
  10. PMP
  11. Project Management
  12. Data Analysis
  13. Microsoft SQL Server
  14. SQL Server Management Studio
  15. Oracle SQL
  16. MySQL
  17. DB2
  18. Microsoft Office
  19. Visio
  20. Data Modeling

Scott Miller's Education

University of Michigan

B.S., Computer Engineering

19801984

Contact Scott for:

  • career opportunities
  • consulting offers
  • expertise requests
  • reference requests
  • getting back in touch

View Scott Miller’s full profile to...

  • See who you and Scott Miller know in common
  • Get introduced to Scott Miller
  • Contact Scott Miller directly

View Scott's full profile

Not the Scott Miller you were looking for? View more »

Viewers of this profile also viewed...