We provide IT Staff Augmentation Services!

Bi Architect And Senior Consultant Resume

Portland, OR

CAREER SUMMARY:

I have over 22 years of BI and Data Warehouse experience. In that time I have assisted many small to large fortune 500 companies enhance or build and implement their Enterprise Data Warehouse and BI environments. I am proficient in all aspects of data warehousing, have excellent communication skills, and work well in both a team environment or Independently. My duties have varied from lead architect, to project manager, to senior developer. I have worked in all facets of data warehousing from the long term strategic projects to the shorter term tactical projects. I have led and or participated in all phases of the project life cycle from gathering user requirements, to design, thru development, and implementation. In this time, I have worked with many tools but specialize in the Microstrategy line of products

SKILLS SUMMARY:

Business Intelligence and Data Warehouse

Data Analysis

Development of User/Business Requirements

Leadership

Project Management

System Development Lifecycle methodology/Agile

SQL

Data Modeling

Microstrategy Architect/Report Developer

SOFTWARE/HARDWARE:

BI Software: Microstrategy Product Suite (20 yrs) - Consisting of Desktop, Architect, Web, Intelligent Server, Enterprise Manager, Narrowcaster, Administrator, Object Manager, and Mobile Cognos (3 Yrs) Business Objects(3) Crystal Rpt(2 yrs) Microsoft Repoting Services(2 yrs) Microsoft OLAP Services (2 yrs) Esperant(2 yrs) Brio(2 yrs) Actuate(2 Yrs)

Databases: Oracle (12 Yrs) SQL Server (18 Yrs) Teradata (6 Yrs) DB2 (3 Yrs) MS Access (7 Yrs)

Languages: SQL (22 Yrs) Visual Basic(4 yrs) Power Builder(3 Yrs)

PC Software: SQL Server Management Server SQL Plus SQL Navigator Teradata SQL Assistant RoboHelp 4.0 WinSql, ODBC Erwin Toad

Office: Microsoft Word Microsoft Power Point Microsoft Project Microsoft EXCEL

WORK EXPERIENCE:

Confidential, Portland, OR

BI Architect and Senior Consultant

Responsibilities:

  • Heavy involvement in the overall Microstrategy architecture and the supporting data model
  • Developing sophisticated mobile applications, Visual Insight dashboards, and complex documents
  • Utilizing version 11.2 of the Microstrategy suite against a SQL Server Backend database

Confidential, Foster City, CA

BI Architect and Senior Consultant

Responsibilities:

  • Responsible for all modifications and maintenance of dashboards that were run and distributed via narrowcaster to various users throughout the country
  • Handled all narrowcaster setup and maintenance of subscriptions and users
  • Utilizing version 11.2 of the Microstrategy suite of tools against a DB2 database

Confidential, Portland, OR

Microstategy BI Senior Consultant

Responsibilities:

  • Worked with the merchandising business unit to evolve their suite of reports and dashboards
  • Developed very complex and involved dashboards and metrics
  • Assisted in developing a sophisticated mobile application for the merchandising group
  • Created a rich set of dashboards and reports for Customer Analytics
  • Utilized version 9.2.1 of the Microstrategy platform against a Teradata backend database

Confidential, Portland, OR

BI Architect

Responsibilities:

  • Acted as the primary Microstrategy architect with various clients to install, design, and build their Microstrategy environments
  • Design, built, and implemented many complex and sophisticated reports and dashboards
  • Utilized version 9.1 of the Microstrategy platform on a SQL Server 2008 backend database

Confidential, Portland, OR

Microstategy BI Senior Consultant

Responsibilities:

  • Worked with Microstrategy clients to implement, build, and enhance their Microstrategy environment
  • Developed a Microstrategy mobile application to track sales performance across business units
  • Responsibilities include all facets of data warehousing and business intelligence
  • Utilized version 9.02 of the Microstrategy platform against a Teradata backend database

Microstategy BI Senior Consultant

Confidential, Las Vegas, NV

Responsibilities:

  • Led a project to implement Microstrategy at a leading slot machine manufacturer
  • Worked with client to develop user requirements, data requirements, and report designs
  • Handled all aspects of the actual Microstrategy development from administration, to architecting, to report and dashboard development. Project consisted of extensive flash dashboard development
  • Utilized version 9.01 of the Microstrategy platform running against SQL Server

Confidential, Atlanta, GA

Microstrategy BI Senior Consultant

Responsibilities:

  • Responsible for most of the Architecting duties within Microstrategy and assisting with the development of the data model to work optimally with Microstrategy
  • Other primary focus was to develop various reports and dashboards for the Merchandising group
  • Extensive dashboard development using both flash and non - flash rendering dashboards
  • Utilized version 9.01 of the Microstrategy suite of tools and Teradata as the backend database

Data Warehouse Architect

Confidential, Beaverton, OR

Responsibilities:

  • Responsible for the overall design and implementation of the EDW(Enterprise data warehouse)
  • Worked in the BI Group and utilized SQL Server, Informatica, and Microsoft SSRS

Confidential, Phoenix, AZ

Microstrategy BI Senior Consultant

Responsibilities:

  • Main focus for over 4 years was on designing and building highly sophisticated reports and dashboards using the Microstrategy suite of tools for the various business areas
  • Led 5 major reporting projects as the Microstrategy Architect, Project manager, and lead report developer. Led a team of 4 report developers and 3 ETL developers
  • Projects revolved around many of the key business areas like CRM, Merchandising, and Finance
  • Projects involved sourcing data from SAP, Peoplesoft, Manhatten, and JD Edwards application databases. Data Warehouse was initially Oracle and then the last year was Netezza

Hire Now