Hire Me
QR Code for Data Modeling
mobile bookmark huh?

Data Modeling

Data is the most important asset of an organization.
As the most basic element of information, a company cannot operate without reliable accessible data. It is the foundation of virtually every decision made by every employee from front line reps to the chairman of the board. Building and maintaining systems for collecting, retrieving and analyzing accurate data is critical.

As a project manager, I’ve led the implementation of many data management systems. I’m skilled in all areas of strategy and planning and am capable of recommending appropriate technologies to meet expressed business needs. As a back-end, middleware and front-end developer, I understand the purpose of each role on a complex data management team.

Data Modeling

Data Modeling is the disciplined planning of an information system. Through participation on several enterprise projects, I’ve documented a Rapid Data Modeling System based on the principles of software engineering, yet streamlined for quick deployment using common business rules. My approach enables non-technical application users and business managers to actively participate in the development process, yet developers receive adequate technical instructions to build complex applications. My system can be modified for custom projects or installation of off-the-shelf products.

Seven Rapid Data Modeling Phases

I: Mission Definition
Build the team, define roles and responsibilities and agree on goals and objectives to guard against scope creep.

II: Current System Analysis
Separate manager and user interviews. Define current process of entry and retrieval. Perform Gap Analysis and Reverse Engineering.

III: Structure and Relationship Definition
Define field definitions, primary/foreign key relationships, schematic layout.

IV: Business Rules Definition
Management and User follow up. Define validation systems.

V: Views Definition
Define various user-level access (i.e. developers, DBAs, management, support, customers, suppliers, etc.). Define the Visual Identity to ensure a consistent intuitive user interface.

VI: Integrity Review
Identify and eliminate risks to integrity of structural, data and security.

VII: Deployment Plan
Develop testing plans for user acceptance, performance, load balancing. Develop data migration plan. Develop launch plan (i.e. parallel operation, bug tracking, emergency rollback processes, support team hand-off, etc.)

About Me

I am an executive-level interactive producer specializing in social media, online community management and buzz marketing for national accounts. I provide agency support & client service across multiple industries. I love integrated campaign strategy, working with creative teams, kicking-off projects and driving them through launch.

I am currently working at Charles Schwab in Austin, Texas.

Read more

Left Brain
SEO, media strategy, web analytics, web application architecture, server architecture, e-commerce platforms, data modeling
  Right Brain
SEM, creative strategy, social media, community management, WOM / buzz marketing, online memes, online brand stewardship

Contact Shannon

Shannon Swenson
Austin, Texas
512-472-3090 x1

hello [at] shannonswenson [dot] com