Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
Ruby Magnuson
Download Resume Format
Ruby Magnuson
magnuson.ruby@yahoo.com
503-755-9876 (home)
612-
964-1230 (mobile)
January,
2012
Ladies and Gentlemen:
I am an experienced Enterprise
Information Architect, Data Architect, Data Warehouse Architect, Data Quality
Analyst, Business Analyst, Database Administrator, Data Modeler, Process
Modeler, BI Developer, ETL Developer, and Project Manager with over 30 years of
experience. I have enclosed my resume as
a first step in exploring the possibilities of employment.
Four more recent experiences include developing
mappings and workflows in a Data Warehouse environment, performing Data
Warehouse and Data Quality health checks, designing and implementing data
reprocessing of incorrect transactional records, designing and implementing of
quality measures, and identifying and constructing the information flows from
Operational applications to ODS and Data Warehouse data structures and
processes including Staging, Certification and Launching using the Informatica
suite of tools (Power Connect, Power Exchange, Power Center, Power Analyzer).
I bring a focus on communication and
quality to all aspects of the information development life cycle.
Thank you for your consideration.
Sincerely,
Ruby Magnuson
Professional
Summary
Mr. Magnuson has thirty-four years of
progressive IS experience primarily in relational IBM DB2/UDB, SQL Server,
Oracle, and Sybase environments. He is especially proficient as an Enterprise
Information Architect, a Data Architect, a Data Quality Analyst, a Data
Warehouse Architect, and a Project Manager or as a Business Process
Improvement Analyst. He has served in many IS functions including Enterprise
Information Architect (Data and Process), Project Manager, Database
Administrator (DBA), Data Quality Analyst and ETL and BI Developer. Further
qualifications include extensive experience in Insurance, Investments, Retail
Credit, Banking, Manufacturing and Analytical Laboratory industries. He is a
Certified Practitioner of Inventory Management (CPIM) in a closed looped
manufacturing environment and has participated in numerous MRP, MRP II, CDI,
MDM, SCM, CRM, SFA, ERP and Data Warehousing initiatives.
Mr. Magnuson has excellent
interview skills, is a strong team player, and has proven communication
skills, providing him with the ability to effectively work and communicate
with a variety of audiences.
Project
Experience
As a Data
Architect for GE Aviation – July 2011 – Present, principally Teradata:
·
responsible
in part for the 3NF model for the go forward Aviation Data Warehouse and the
semantic or consumption layers using the Teradata mLDM and MDM practices..
·
responsible
in part for the completeness of the Source Inventories and the mappings to
the new models.
·
Responsible
for the designing of a Data Quality Management set of rules and measures
based on the content of the incoming source data.
As an ETL Lead for a
Sportswear Apparel organization (Columbia Sportswear Company) 2010 – June,
2011, principally SQL and Teradata;
·
created the 1st Informatica development
group to support Power Center, Power Exchange, Informatica Data Quality and
Data Explorer, SAP and SFA adaptors, etc.
Duties included hiring, training, work direction and planning for
multiple $1 million dollar efforts.
As the Data Architect for
a webmail servicing organization (Yesmail.com) 2009 – 2009, principally
Oracle;
·
developed a go forward 3NF Data Model
to accommodate multiple serviced Clients.
Worked with sister companies to develop data models to meet their
client’s needs.
As an ETL Developer for a
Health Information organization (WebMD) 2009 – 2009, principally SQL, Oracle
and Teradata;
·
Developed the movement of Health Coach Information
to the Data Warehouse. This included
the movement of source into warehouse data, audit and control table
structures for process control.
As an Information
Architect / ETL Developer working remotely for a consulting firm on
assignment in Canada 2009 – 2009, principally SQL, XML and Oracle;
·
Designed and developed the movement of external
supplier invoice data from a web-based source application to the client
secured server to be moved into supporting tables, altered by a workflow
application and posted into QBYTE.
This included the movement of source data into warehouse data, audit
and control table structures for process control.
As an Information
Architect and ETL Developer for a Worldwide Hospitality organization (Carlson
Hospitality Worldwide) 2007 – 2009, principally Oracle, Teradata, XML and
file based systems;
·
Designed, developed and implemented the movement
of Reservation, Travel Agent and Property information to and from an external
3rd party vendor for payment of fees. This included the creation of normalized
table structures with control tables for audit ability and monthly financial
reporting and reconciliation.
·
Designed, developed and implemented the movement
of frequent Guest Earning and Award information for a Frequent Guest
Program. This included the creation of
normalized table structures, dimensional table structures and control tables
for process control.
As an Information
Architect, Project Leader, Business Liaison, Business Analyst, and BI
Developer for a Fraternal organization (Thrivent Financial for Lutherans)
2006 - 2007, principally UDB, SAS Datasets and file based systems;
·
Led, designed, consulted and implemented the
movement of Advice information from internal and external OLTP applications
to ODS applications. This included
developing an Abstract data model allowing for disparate external data
sources to be certified and stored in a single data structure. Developed a SAS EG reporting process to
report and graphically display key performance measures using the abstract
model.
·
Assisted in developing the “roadmap” of Advice
related efforts for the next 8 quarters.
·
Performed numerous data quality checks to provide
(DB2, VSAM, IMS, UDB)
·
An assessment of Data Quality (Reference Data,
Data Awareness, Data Values and Ranges, and Metadata)
·
A go forward plan for looking for interim, midterm
and longer term quality initiatives, benchmarks and costs
·
General consultation in ETL, BI and data
architecture.
As an Information
Architect for a manufacturing and retail organization (Select Comfort) 2006,
principally Oracle and file based systems;
·
Designed, mentored, developed and implemented the
movement of information from OLTP applications to ODS applications.
·
Helped mentor and develop team members with their
skills in logical, physical and dimensional data modeling.
·
Helped mentor and develop team members with their
skills in Informatica data movement.
As a Project Manager for a
Financial organization (Dain Rauscher) 2005 – 2006, principally DB2, VSAM and
file based systems;
·
Identified history and messaging requirements for
a conversion to ADP.
·
Interviewed, hired and assigned work tasks to team
members.
·
Maintained the project plan to be consolidated
into the program plan.
·
Coordinated data inventories from source
applications to conversion mappings.
As an Information
Architect and Data Quality Analyst for a Worldwide Hospitality organization
(Carlson Hospitality Worldwide) 2005 - 2006, principally DB2, Teradata,
Oracle, SQL Server and file based systems;
·
Designed, mentored and implemented the movement of
information from OLTP applications to ODS applications and the interaction
with a Customer Data Hub. These included normalized table structures that
sourced operational data, sent the data to a CDI web service, received the
acceptance or rejection of information and updated the operational system.
·
Sent and received for reporting Reservation and
Stay information to the corporate Teradata EDW.
·
Created the standard ETL process (editing,
rejection, mapplet creation) for each ODS layer.
·
Created the CHW data naming conventions.
·
Standardized content for all reference data.
·
Maintained WebFocus Master File definitions.
As an Information
Architect for a Fraternal organization (Thrivent Financial for Lutherans)
2003 - 2005, principally DB2, IMS, VSAM, Datacom, UDB, SQL Server and file
based systems;
·
Designed, mentored, developed and implemented the
movement of information from OLTP applications to ODS applications.
·
Helped mentor and develop team members with their
skills in logical, physical and dimensional data modeling.
·
Assisted in creating the Thrivent data naming
conventions.
·
Standardized content for all reference data.
·
Maintained Power Analyzer semantic layer and
Business Objects Universe definitions.
As the Manager of
Information Management for a medium sized Banking organization (TCF Bank)
2001 – 2003, principally Oracle, VSAM and file based systems:
·
Designed, developed and implemented the movement
of information from OLTP applications to ODS and Data Warehouse
applications.
·
Helped mentor and develop team members with their
skills in logical, physical and dimensional data modeling.
·
Maintained Power Analyzer semantic layer and
Oracle End User Layer definitions.
·
Developed specifications and information flow for
a Java based Contact Management application.
·
Created control table where new products could be
added or new qualifications could be put into place without changing the Java
code.
·
Created Oracle and Informatica semantic layers for
reporting from the mormalized and dimensional table structures.
As an Enterprise Information Architect for a Fraternal organization
(Lutheran Brotherhood) 2000 - 2001, principally Datacom, IMS, VSAM file based
systems;
·
Facilitated the Enterprise view of Data,
Information and Knowledge including structured and unstructured data types
for eventual migration of legacy applications (mainframe and distributed) to
an Enterprise Information environment.
·
Helped develop data and process design principles
and project plans to support the new environment.
·
Performed a thorough analysis of the Investments
division for data and process improvement opportunities.
As a Process Control
Specialist for a large Banking organization (US Bank) 2000 - 2001,
principally DB2, UDB, VSAM and file based systems;
·
Assisted in the architecture of the front office
view for 1400 bank branches.
·
Performed requirements gathering, data and process
modeling, specification writing, project plan facilitation and testing.
As a Database Architect and Data
Modeler for a medium sized Banking organization support company (DCA) 2000,
principally Oracle and file based systems;
·
Helped address data model and
database concerns regarding insurance product offerings.
As a Database Administrator and Project
Leader for a global scientific and manufacturing organization, (3M) 1999 -
2000, principally Oracle, Delphi and file based systems;
·
Designed and built an
application that records the progress of global Analytical Requests
throughout their life cycle.
·
Performed requirements gathering, logical data
modeling, physical data design, table creation, process modeling, data base
administration, and project leadership.
·
Made extensive use of BLOB tables to support the
storing and retrieval of Request findings whether they were text,
spreadsheet, drawing, audio, or video.
As an Information Architect and Project Leader for a large retail
credit organization (Target) 1997 - 1999, principally DB2, UDB, VSAM, ACCESS
and file based systems;
·
Designed and built a Credit Fraud application
resolving Claimant disputes with their accounts that are determined to be
fraudulent.
·
Performed project chartering and scope, logical
data modeling, technical data design, process and procedure creation,
navigation development, window development and code generation.
As a Data and Process Modeler for a large retail asset protection
organization (Target) 1996 - 1997, principally DB2, UDB, VSAM, ACCESS and
file based systems;
·
Helped design and build a reporting application
that records the details of incidents (crime) against the organization.
·
Performed logical data modeling, technical data
design and interface development.
As a Data and Process Modeler for a large retail asset protection
organization (Target) 1995 - 1996, principally DB2, UDB, VSAM, ACCESS and
file based systems;
·
Helped deign and build a reporting application
that records the details of investigations (potential crime) against the
organization.
·
Performed logical data modeling and technical data
design.
As a Business Process Consultant for a large banking organization (US
Bank) 1993 -1995, principally DB2, UDB, VSAM and file based systems;
·
Identified and gathered client requirements,
developed system specifications, and coordinated client activities including
development and support for new product releases.
·
Developed process flow requirements across the
banking institutions in 13 states.
·
Developed test plans, test cases, and development
implementation strategy for the project. Consulted in development of
Graphical User Interface (GUI) standards.
·
Applications developed included Consumer and
Commercial Credit Authorizations systems for banking products using ACAPS as
the scoring and decisioning tool, Consumer and Commercial Deposit systems,
and relationship management systems.
As a Data Base Administrator (DBA) for a local manufacturer of test
equipment (MTS Systems) 1993 - 1994, principally Progress and file based
systems;
·
Responsible for installing and fully supporting a
Progress relational database.
·
Developed and implemented data base standards.
·
Developed uniform standards dictated for ISO 9001
certification.
·
Developed course curriculum for IS personnel in
relational technology. Performed DBA duties regarding usage and performance
of the database and its development tools.
·
Developed disaster recovery plans across a
multi-national organization.
·
Helped develop specifications for the procurement
and implementation of a Configure to Order (CTO) tool and a Computer Aided
Software Engineering (CASE) tool.
As a Master Systems Builder for a
student loan servicing organization (EduServ) 1992 – 1993, principally DB2,
VSAM and file based systems;
·
Designed and supported the
delinquency and collateral systems that deal with the service’s liability in
the event of delinquency on the part of the borrower.
·
Performed team lead functions
as the related to team building, education, development, and promotion to
production of five major subsystems of delinquency.
As a Project Leader for a
global manufacturer of farming and construction (Case) 1988-1992, principally
IDMS, VSAM and file based systems;
·
Led the procurement and implementation of CASE
technology to drive the development of a multinational Dealer Business
application.
·
Performed as the Project Leader for the
development of Master Production Scheduling and Final Assembly Scheduling
applications.
|
Areas of Expertise
Skills
20 + yrs Data Analyst
20 + yrs Business Process Analyst
20 + yrs Data Modeler / Architect
15 yrs CASE Developer / Mentor
15 + yrs Project Leader / Manager
10 + yrs Developer
10 + yrs Conversion Mapping
10 + yrs Warehouse Building
2 yrs
Database Administrator
Industries
7 yrs Manufacturing
7 yrs Insurance
1 yr Marketing
8 yrs Government
5 yrs Retail
5 yrs Banking
Technical Environments
IBM Mainframe, MVS,
TSO/ISPF, CICS, MS Windows 95/98/NT, Oracle, SQL Server
Technical Tools
Database: DATACOM, DB2
(UDB), SQL, IMS, IDMS, SYBASE,
PROGRESS, ORACLE, TERADATA
Design
and development: INFA POWER CONNECT, INFA
POWER CENTER, SYBASE POWER DESIGNER, METADATA MANAGER, DATA ARCHITECT, POWER
DESIGNER PROCESS ANALYST, SYSTEM ARCHITECT, ERWIN, COOLGEN, COMPOSER, IEF,
ADW, IEW, EXCELERATOR,
PL
SQL, SQL, COBOL II, MICROFOCUS COBOL, RPG, PL1, FORTRAN
Reporting: SAS EG, INFA POWER
ANALYZER, BUSINESS OBJECTS, DISCOVERER, EZTRIEVE, WEB FOCUS, CRYSTAL
Application: MAC PAC, FIN
PAC, COPICS, MAPICS, MSA, AMAPS, CINCOM, CULLINET, FOURTH SHIFT, HOGAN,
BANKPRO, CAMS, SHAW
Content
development: Microsoft Word
(Windows), WordPerfect
Graphics: Microsoft PowerPoint, Lotus Freelance,
Visio
Project
management: Microsoft Excel, Microsoft
Access, Microsoft Project
Communication: Microsoft Outlook, Microsoft Mail, Lotus
Notes, TAO
Web
& Connectivity: Netscape, Internet Explorer
Education
University of Wisconsin, School of Business
BA in
Information Systems
Certified Practitioner of
Inventory Management APICS
Yourdon and DeMarco’s
Structured Analysis and Structured Design
Ralph Kimball Dimensional
Data Modeling
Martin’s Information
Engineering
COOLGEN Object Oriented
Analysis and Design
COOLGEN Component Based
Design
IEF ISP (Information
Strategy Planning)
IEF BAA (Business Area
Analysis)
IEF BSD (Business System
Design),
Ernst &Young Navigator
Arthur Andersen’s Method 1
|
Letter of Recommendation for
Ron Magnuson
TO
WHOM IT MAY CONCERN
It is with great
pleasure that I have an opportunity to write a letter of recommendation for Ron
Magnuson pertaining to a subject area that I have worked in for over ten
years. I have known and worked with Ron
now for the past six months. I want to
emphasize how important his background is in the areas of Enterprise
Architecture, Database Management, and in the area of Meta Data. I thought I knew everything there was to know
about meta data. It is always enlightening
to have a fresh source of knowledge that incorporates new and visionary information
in a subject area.
Ron came to this
company with highly demonstrated skills in the area of Database Management and
Enterprise Architecture. He orchestrated
and presented in a most professional manner an enterprise package to senior management
that truly outlined a new architecture for Lutheran Brotherhood. His knowledge of meta data and how to
implement and develop operational data stores and data warehouses has generated
a renewed awareness of the need to validate the trustworthiness of legacy
data. He clearly demonstrated to senior
management the methods for "scrubbing business data" and how to
uncover the gold amid the dross of legacy information that brings new interest
to methods of quality assurance. His
knowledge of the value of meta data and in the standardization of data elements
that describe rules, principles and guidelines for classifying, attributing,
naming, and creating data elements has shown the way for developing and
maintaining our application systems.
Ron has an infinite
knowledge in the areas of Enterprise Architecture and Database Management. His professionalism and high regard for
quality developed systems is equaled by no one that I have worked with in the
past 40 years. Those that will have the
opportunity to work with Ron will surely benefit from his work ethics,
knowledge, an importance of standardization and reusability and sharing of
data.
Sincerely,
Arthur (Skip) Meinhardt
Architecture Standards and Research Analyst
Lutheran Brotherhood
Apr 17, 2001
Download Resume Format
0 comments:
Post a Comment