Post Job Free
Sign in

Sql Server Quality Assurance

Location:
Concord, CA
Posted:
December 08, 2012

Contact this candidate

Resume:

Candidate Resume - Confidential User

Email: ********@********.***

Address: Address Withheld

City: Concord

State: CA

Zip: 94520

Country: USA

Phone: (

Skill Level: Experienced

Salary Range: $120,000

Primary Skills/Experience:

Educational Background:

Job History / Details:

SUMMARY

A business intelligence (BI) consultant with 10 years proven end-to-end experience. Key strengths include ETL processing, dimensional design and modeling, finance analytics, installs / configurations database administration, and key user (especially Finance) support. Experienced with best practices; knowledgeable in advanced reporting writing techniques. Works well on both large and independently managed project settings.

APPLICATION PROFICIENCY

Cognos BI: Core Cognos 8.4; Core Strengths: Data Manager, SSIS (SQL Server 2005), Framework Manager, Transformer, PowerPlay, Performance Applications (JDE / Oracle Financials); Also: Report Studio / ReportNet, Query Studio, Analysis Studio, Cognos Finance, Cognos Planning

Microsoft BI: Core SSIS (Integration Services), Performance Point 2007 M, A &P; Also: SSAS (Analytical Services), SSRS (Reporting Services)

Database: Core SQL Server (MS Certified); Also: JDE, DB2 (incl. z0s server), Oracle

PROFESSIONAL EXPERIENCE

Dec2004

-Feb2009Senior BI Consultant / ETL Lead

Scope, design and implement data warehouse and analytical application systems within client and consultant-led team environments. ETL, data modeling and system install / config heavy lifting. Work within confines of legacy BI and production environments to define existing business process and data store improvement needs. Client training for back-end administration, development and best-practices. Perform software versioning and platform full-suite upgrades.

NOTE: Merador split into Performance G2 and Senturus in 2008

Alibris

June2000

-March2003

(BI

) Software Engineer

Manage and maintain decision support infrastructure, including the data warehouse, cubes, and analytical applications. Administer database systems and servers, handle decision support system (DSS) quality assurance (QA) functions, and provide business analyst services, including source-system reconciliation, training, communication facilitation and detailed documentation. Revise selected production system coding and process maintenance tasks and provide end user support.

AssetMark Investment Services, Inc

. March2003-October2004Database Developer / Administrator

(MS SQL Server)

First Union / The Money Store

1997-2000IT Technical Analyst II

PROFESSIONAL DEVELOPMENT

Microsoft Certs: SQL Server 2000 MCSE Certified (System Administration [70-228] & Database Design and Implementation [70-229]); Performance Point Server 2007 [70-556]

Cognos Training: Powerplay (Cognos; 2000); DecsionStream (Cognos: 2000); Cognos Finance (Cognos: 2001); ReportNet Fast Track (2005); Cognos8 Advanced Report Writing (2008)

Other: GEAC (2004)

EDUCATION

BS,

Managerial Economics, University of California, Davis, Davis, CA (1997



Contact this candidate