SUMMARY:

Confidential has wide - ranging experience designing, developing and integrating business intelligence solutions. He possesses valuable experience with a broad spectrum of analytical tools and concepts. With a lifelong background in the combination of art and technology, Confidential not only provides creative solutions, but consistently delivers them above and beyond client’s expectations.

PROFESSIONAL EXPERIENCE:

Confidential

Confidential is a health and wellness education company that was looking for a solution to both internal and external reporting needs. A more centralized, self-service style of reporting was needed where disparate data sources slowed the development of client facing reports. MicroStrategy was chosen as part of that solution. Efforts were also directed towards replicating existing BusinessObjects reports as the full transition to MicroStrategy was underway.

• Architected data mart to conform seven disparate data sources into one centralized repository
• Created and loaded table structures based on data mart design
• Constructed SSIS ETL packages to automate the population of data mart structures
• Designed large-scale document that sources from data mart to provide clients an annual report that covers a wide range of information, from program participation and satisfaction to return on investment breakdown
• Assisted the conversion of 100+ BusinessObjects reports deemed critical for operations
• Oversaw development of extremely large-scale MicroStrategy documents including the Annual Report and Population Profile Report
• Designed and developed data structures to support the population profile report, providing each of Confidential 's clients with a breakout of their company's leading health risks and conditions
• Provided assistance in the implementation of a new 3-tier database environment and corresponding MicroStrategy tiers
• Lead testing efforts around document and report conversion development
• Aided report developers with best practice instruction and issue resolution

KEY TECHNOLOGIES:

• MicroStrategy
• SQL Server
• SQL Server Integration Services
• Microsoft Visual Studio
• PowerDesigner

Confidential

Confidential is a wholesale financial services company headquartered in Austin, Texas, selling technology and marketing products to credit unions and small regional banks. The business had recently adopted MicroStrategy, including its newest Mobile components, for a wide array of applications; from sales in the field to routine operational reporting.

• Constructed initial MicroStrategy environment (Intelligence, Web, and Mobile servers)
• Configured development environment metadata and data sources
• Administered MicroStrategy environment, including user creation and LDAP linkage
• Served as MicroStrategy architect for all schema creation and modification
• Acted as Mobile Lead Facilitator during Mobile QuickStrike with MicroStrategy's GDC
• Provided GDC developers with access, requirements, and all schema modification
• Developed profitability dashboard showcasing each institution's asset and product performance
• Hosted learning sessions covering all components of MicroStrategy 9
• Offered solutions for performance enhancements to existing data sources

Key Technologies:

• MicroStrategy
• SQL Server 2008

Confidential

Confidential needed a fleet of reports in MicroStrategy to address everyday intelligence needs. Multiple subject areas were addressed from marketing to revenue and merchandise performance. A new Netezza environment was also put in place to provide performance lift over the existing SQL Server environment. Replacement of reports from legacy systems was also a primary focus.

• Developed a combination of new reports and documents, increasing daily insight
• Served as administrator for entire MicroStrategy environment
• Replicated existing reports from SSRS and other legacy systems
• Performed testing and validation of new and converted reports
• Installed and configured Narrowcast server
• Created Narrowcast services for all district and region managers
• Managed ETL efforts to migrate existing data into a new Netezza Data Warehouse
• Assisted DBA with tuning and improved configuration of Netezza environment
• Provided continuing enhancements to existing, large scale Documents
• Personally upgraded all servers and tiers to MicroStrategy 9.3
• Key Technologies:
• MicroStrategy
• SQL Server 2008
• SQL Server Management Studio
• SQL Server Reporting Services
• SQL Server Integration Services
• Netezza
• Microsoft Excel

Confidential

Saxon was a mortgage servicing company that was trying to convert its existing operational database and reports to a much more dimensional environment. The end goal of all efforts was a more robust and deeper reaching reporting solution, utilizing MicroStrategy.

• Served as administrator for entire MicroStrategy environment
• Lead efforts to convert 200+ 3rd party reports into internal MicroStrategy reports
• Assisted testing and validation of converted reports
• Architected several disparate areas of business into one centralized Project
• Supported end users by providing report enhancements on demand
• Provided hands-on training to employees who desired additional knowledge of the tool

Key Technologies:

• MicroStrategy
• SQL Server
• SQL Server Management Studio
• SQL Server Reporting Services
• Microsoft Excel

Confidential - Project Gemini

Project Gemini was a process of converting an existing, paper-based, finance and HR system to a complete PeopleSoft environment. Oracle BI was utilized for reporting on top of the new PeopleSoft/EPM environment.

• Customized out-of-box EPM repository to work with both PeopleSoft and existing OBIEE environment
• Created a series of dashboards to replace annual and monthly financial reports
• Installed and administered OBIEE development environment
• Utilized existing security structures for SSO functionality
• Assisted efforts to upgrade existing PeopleSoft environment to current version
• Directed testing and validation of all reports developed

Key Technologies:

• OBIEE
• Oracle Enterprise Performance Management (EPM)
• PeopleSoft
• Oracle 10g & 11g
• Toad for Oracle

Confidential

The BIS dashboards are a collection of fifteen dashboards that provide information on all operations under the Global CTO. These range from project spending and talent acquisition to system uptimes and logged incidents.

• Tasked with creating a suite of dashboards for Confidential Global CTO
• Provided greater visibility to all KPIs that are supplied by the CTO’s direct reports
• Created fourteen dashboards from a set of eleven independent sources
• Consumed sources ranging from monthly spreadsheets to hourly warehouse loads
• Constructed the MicroStrategy project architecture
• Assisted ETL efforts in designing the project’s central warehouse
• Hosted extensive user testing sessions for each individual dashboard
• Gathered requirements for future enhancements from users during testing
• Administered the MicroStrategy environment

Key Technologies:

• MicroStrategy
• Oracle 10g, Essbase
• DbVisualizer
• Control-M
• Microsoft Excel

Confidential - Project Advantage

Project Advantage combines the six separate sources that provide all of Confidential 's sales and promotion data into a single reporting environment.

• Multi-source project for the purpose of combining Confidential ’s six primary reporting data sources
• Developed reports and dynamic dashboards for each of six sources
• Lead performance enhancement activities between MicroStrategy and Teradata
• Gathered requirements and routine feedback from end business users
• Performed live demonstrations of the project for other sectors of the business
• Filled the role of Administrator for the Confidential ’s entire MicroStrategy environment

Key Technologies:

• MicroStrategy
• Teradata, DB2, Oracle 10g
• BusinessObjects XI

Confidential - National Stores Dashboard

Worked through major, show-stopping issues to allow Cottonwood’s BI team to demo their dashboards and gain adoption of the MicroStrategy platform internally.

• Supported Cottonwood developers in first use of MicroStrategy 9
• Migrated MicroStrategy 8 projects and objects to MicroStrategy 9
• Rebuilt existing dashboards to provide better functionality
• Corrected any outstanding formatting issues
• Enhanced existing schema with transformation objects

Key Technologies:

• MicroStrategy
• SQL Server

Confidential - PrePaid Reporting

Created a data mart to track prepaid phones usage, churn, features and subscribers. The majority of data was provided by Ericcson, the manufacturer of the phones being reported upon.

• Architected MicroStrategy project to provide users with a dynamic reporting tool
• Met with business users to gather and determine reporting requirements
• Designed and developed reports, fulfilling user’s requirements and wish lists
• Managed object migrations to AT&T’s MicroStrategy environment
• Lead live presentations of Web reports to users for review
• Maintained and validated all views pointed to the data mart’s tables
• Defined business logic to guide the ETL process

Key Technologies:

• MicroStrategy
• Teradata
• SQL Assistant

Confidential

Confidential is a furniture retailer with over 1000 stores nationwide. Executive management makes business decisions based on key performance indicators. Taking further initiative to utilize their existing data warehouse, Confidential helped create reports to support the decision making process, taking advantage of new functionality available in MicroStrategy.

• Gathered requirements and functional specifications from business stakeholders including executive board members
• Designed Executive Information System based on MicroStrategy 8.1.1 DHTML technology
• Developed custom Executive Information System Framework utilizing the MicroStrategy Web and Visualization SDK
• Built specialized reports and report objects to support Executive Information System
• Managed deployment of custom Executive Information System Framework to executive team
• Supervised and administered all changes to the EIS Framework

Key Technologies:

• MicroStrategy
• IBM DB2

Confidential - Save Desk Reporting

For this project, AT&Trequired an entirely new solution for analyzing their own Save Desk’s performance. The final solution provided the client with the capability to analyze customer value characteristics over the three months leading up to and the three months following the save event.

• Developed more dynamic and effective reporting for AT&T’s Save Desk data
• Architected the evolution of elements from logical database to user-end reporting
• Maintained technical design documentation
• Created and executed data validation processes
• Worked with client to provide user friendly reports
• Migrated project to client’s own MicroStrategy environment
• Provided ETL support to ensure reporting accuracy
• Delivered quick troubleshooting and explanation throughout User Acceptance Training

Key Technologies:

• MicroStrategy
• Queryman
• Sybase Power Designer
• Teradata

Personal Dashboarding Project

• Created interactive enterprise dashboards based on MicroStrategy report data
• Designed attractive skins for placement on various client’s current dashboards
• Developed a method of refining stock MicroStrategy dashboards into customized documents
• Currently working towards enterprise dashboards that exceed the appeal of standard designs

Key Technologies:

• MicroStrategy
• Adobe Flex
• Adobe Flash
• Adobe Fireworks
• Adobe Photoshop

TECHNICAL SKILLS:

OLAP Client Tools

• MicroStrategy 8.x, 9.x, 10.x
• OBIEE
• Business Objects XI

Data Integration Platforms

• Informatica PowerCenter
• Business Objects Data Integrator
• Microsoft SSIS

RDBMS

• Teradata
• IBM DB2
• SQL Server
• Oracle
• Netezza

Database Query Tools

• DbVisualizer
• Queryman
• TOAD
• RazorSQL
• SQL Assistant

Data Modeling Tools

• Sybase Power Designer
• CA Erwin
• Microsoft Visio

Visual Design Tools

• Adobe Creative Suite
• Adobe Flex
• Adobe Flash
• Adobe Fireworks
• Adobe Photoshop
• Adobe Illustrator
• Adobe InDesign
• Eclipse
• BIRT
• GIMP