Margaret G. Ralph
15930 SE 46th Place
Bellevue, Washington 98006

I BRING SUCESSFUL BUSINESS SOLUTIONS BY:
 * Identifying company requirements of both external and internal customers
 * Identifying business and process change requirements that are necessary
 * Capturing, analyzing, validating and documenting all customer, business and
process requirements
 * Communicating customer, business, and process requirements to other
departments (e.g. Marketing, I.T. Systems 
 Development, Audit & Compliance)
 * Identifying, testing and evaluating alternative solutions to business
problems
 * Ensuring that all deliverables mapped back to each business requirement

PROFESSIONAL PROFILE (10 YEARS)
 * I am a successful Senior Business Analyst, a communicator, and a facilitator
of change,within company organizations, acting as a bridge between internal and
external customers, stakeholders, and business solution providers
 * I effectively create innovative and cost-effective solutions to company
business problems by applying my understanding of both company's business and
technical issues and most importantly, by identifying expected future
requirements

TECHNICAL SKILLS

 * PerformancePoint Server & Dashboard Designer
 * T-SQL Query commands
 * SharePoint Server / MOSS
 * Microsoft SQL Server 2005/2008: Analysis Services, Reporting Services
 * SQL Server Business Intelligence Development Studio - Analysis, Reporting, &
Integration Services
 * ProClarity Report Designer
 * Siebel Analytics 7.5, 7.8 Analytics Data Warehouse Consultant:
 * Siebel 7.5, 7.8 Certified Consultant & Business Analyst

Microsoft Corp., WA 
08/2008 - 09/2009 
Sr. Business Intelligence Analyst

Summary: Member of Client Services Media Services Business Management team
responsible for operational analysis, reporting, testing, documentation and
business intelligence.

Activities and Achievements:

 * Create and maintain MTS Premier Media Services DISPLAY Dashboard and
Scorecards for United States, Europe and Asia using Performance Point Designer
and SharePoint Lists

 * Create and automate SSRS revenue reports by linking monthly revenue excel
reports to Media Services DISPLAY scorecard KPI metrics

 * Create and execute necessary SSIS packages to drive reporting and data
alignment between Media Services

 * Engage with Enterprise level Development teams to create Business
Requirements Documents, review Functional Specifications, and validate data
through formal and documented User Acceptance testing for MTS reporting and
platform solutions

 * Analyze all Media Services Active Account activities using SQL queries on the
backend database and MDX expressions on the Data Warehouse OLAP cubes, creating
Excel Analysis Reports and listings on SharePoint

 * Refine the PerformancePoint Application by leveraging new technology for
Media Services Scorecards through the inclusion of Trend Charts and Strategy Maps
linked to KPIs on Media Services Dashboards

Microsoft Corp., WA 
11/2007 - 08/2008
Sr. Business Intelligence Analyst

Activities and Achievements:

 * Kicked-off initial discovery phase performing analysis on SMS&P international
reports exploring alternative architect solutions consolidating 'duplicate OLAP
cubes' across several SSAS and physical SQL databases into one centralized data
mart within the Enterprise Environment

 * Consolidated worldwide sales information, inventory, reseller and customer
data within Microsoft's MS Sales, creating internal tools to provide a single
solution optimized for complex online analytical processing (OLAP) queries

 * Integrated business solutions creating PerformancePoint Application;
designing dimensions, member sets and properties, creating Scorecards, KPIs,
Dashboards for various departments with the SMS&P division

 * Documented and designed the physical, logical and presentation schema of all
the integrated business rules and business logic within the [PA] Analytics
Environment.

Microsoft Corp., WA 
07/2007 - 10/2007 
Senior Data Analyst

Activities and Achievements:

 * Performed analysis and extensive data mapping from various upstream data
sources using SQL query results (from backend databases). 2nd Phase: Design
appropriate dimensions and hierarchical levels based on end user reporting
requirements

Business Intelligence Developer Program 
09/2006 - 06/2007: One Year Certification Program

Total 45 Credits:
 * Multi Dimensional Business Analysis
 * Data Warehousing
 * Data Mining
 * Dimensional Modeling
 * Data Visualization
 * Statistical Analysis

Eagle Creek - Inc. 
08/2005 - 08/2006
Principal Siebel Analytics Analyst 

Activities and Achievements:

 * BI Project Lead for 6 team members delivering detailed specifications on how
to best integrate various customer, sales, and product tables from disparate data
sources for Pitney Bowes Inc. creating a beta pipelined data processing engine.

 * Developed and documented functional specifications and system design
specifications for their system database(s) upgrade for Siebel Analytics 7.5 to
7.8.

Additional Employment History:
 * Microsoft Inc - 12/04 - 07/05 - Microsoft MMS and CRS Siebel Analytics
Analyst
 * T-Mobile Inc - 09/03 - 09/04 - Senior Data Warehouse Analyst
 * Microsoft Inc - 02/03 - 07/03 - Senior Analytics Product Manager
 * AT&T Inc - 09/02 - 12/02 - Senior Functional Analyst
 * Siebel Inc - 10/00 - 07/02 - Siebel Analytics Business Analyst

EDUCATION

 * Immaculata Junior College Washington D.C.: Elementary Education
 * University of Washington Extension Program: Data Communications
 * Siebel University: 2000 - 2002: Certified Siebel Analytics Architect
 * Kimball University: 2003 - 2005: Certification Microsoft Data Warehouse in
Depth
 * Bellevue Community College: 2006- 2007: Certification Business Intelligence
Analyst

REFERENCES:
 * Upon Request