Highlights:

• Seventeen years general IT experience, five years management experience, ten years of teaching college level classes.
• Ten years of experience in the IT industry specializing in the field of Data warehousing and BI.
• Ten years of teaching and development Microstrategy (ver 4.3 to 9, hot fix 1).
• Ten years of experience at architecture, administration and development levels in MicroStrategy products including MicroStrategy Desktop, Administrator, Intelligence Server, Web, Narrowcast Server and mapping to client machines.
• Ten years of Data warehousing experience with expertise in Data Modeling, OLAP tools and SQL.
• Proficient in Microstrategy using Oracle 9, Informix, DB2, Teradata, SQL Server 2000 and MS Access.
• Manage IT projects for 10 years. Data Warehousing and BI groups.

BI Tools: Microstrategy 9/ 8.1.1/8.0.1/ 7.5.3/ 7.5.1/ 7.2.3 / 6.0, Business Objects, MS Reporting Services
RDBMS:Teradata, DB2, Oracle 8, 9i, Informix, SQL Server 2005, MS-Access, DB2
ETL:SQL Server DTS and SSIS packages, SQL Scripting, Informatica
Languages: HTML, XML, PL/SQL, SQL, Visual Basic, JCL, COBOL
Utilities:Teradata Administrator, TOAD, QMF, SQL Plus, Erwin, Visio and Power Designer
OS: Windows 9x/2000/NT/XP, Mac OS, Unix- Solaris, Linux

Employment:
Confidential, Enterprise Data Warehouse Architect - contractor August 2008 – September 2009
Kansas City, MO

• Facilitate projects and work with Business Analysts and customers to define project requirements.
• Manager of ETL group for Data loaded to OPS, Reporting, and Enterprise data warehouse. Responsible for enterprise data architecture.
• Building logical and physical data models. Operational, Datamarts, and EDW.
• Design efforts for technical platform, Lead technical standards. Design data models to desired reporting capability using Power-Designer.

Confidential, Enterprise Data Warehouse Architect - contractor April 2008 – August 2008
Dallas, TX.

• Setting up Narrowcast for dashboard reports, Admin users and groups to ready clients for Microstrategy Audit.
• Teach clients conversion of reports from Microstrategy to MS Reporting Services w/ SSRS.
• Designed architecture for technology solutions by applying industry best standards of architectural practices.
• Troubleshot clients ETL using SSIS and creating and updating DTSX scripts.
• Evaluate data warehouse using SQL Server 2005 using SSAS, SSIS and give recommendations to client.
• Building logical and physical data models. Design data models to desired reporting capability using Erwin.

Confidential, Sr. Microstrategy Developer & Data Architect October 2006 to March 2008
Roanoke, TX

• Gather user requirements and create documentation for management sign-off.
• Lead recommendations to upper level management on use of tools across enterprise.
• Designed architecture for technology solutions by applying industry best standards of architectural practices.
• Responsible for implementing enhancements and/or fixes to existing reports.
• Lead employees to assist them in understanding requirements and development activities.
• Write strategic vision and insight related to the IT Data Management Group, including reviews of emerging technologies which may benefit the FARETS business line.
• Engage team members to work collaboratively and effectively in creating and fixing data models.
• Manager of BI group, Data warehousing, ETL, and BI reporting staff.

Confidential, eLearning, Business Intelligence, Microstrategy- contractor April 2006 to August 2006
Columbus, OH

• Create documentation and course materials for Microstrategy eLearning Web 8.0.2 classes.
• Setup and taught eLearning Microstrategy classes using Breeze (web-cast) application.
• Architect Microstrategy 8.0.2 projects and create all Microstrategy objects for training, development and production.
• Gather user requirements and apply to MSI metadata layer.
• MSI freeform SQL and read, understand data models to apply to user requirements
• Use Teradata SQL assistant to validate data for user acceptance.
• Configure Enterprise Manager 8.0.2 projects and ETL for development, QA, and production.

Confidential, Data Warehouse Architect & Microstrategy – consultant October 2005 to March 2006
Kansas City, MO.

• Lead recommendations to upper level management on use of tools across enterprise.
• Mentor/Lead team members on Microstrategy I-Server, Narrowcast Server, Desktop, and Web, version 8.0.1
• Load and configure Narrowcast server 8.0.1, setup services, schedules, etc. for enterprise distribution.
• Architect Microstrategy projects and object development - reports, filters, metrics, etc. (v 8.0.1 r2).
• Develop custom applications and integrate data from other applications.

Confidential, Microstrategy Administrator & Developer (contractor to TxDot) October 2004 to Sept. 2005
Austin, Texas

• MSI 7.5.3 and 8.0 report development, project architecting, report and architect troubleshooting, SQL modification and tuning system administration.
• Upgrade Microstrategy Narrowcast, web, and I servers. Configure Narrowcast and I Severs for Web portal and email.
• Load and run Scan MD and MD Doctor for DB2 metadata. Create tables and setup ETL for DB2 data warehouse.
• Teaching Microstrategy Desktop, Web and I-Server Admin 7.5.3, train the trainer and end user classes.
• Architect Microstrategy projects and object development - reports, filters, metrics, etc.
• Interviewing qualified candidates and making hiring recommendations

Confidential, Microstrategy Administrator & Developer - contractor August 2004 to October 2004
Austin, Texas

• Develop Data Models and DDL’s for MSI projects using Erwin and Visio.
• MSI 7.x.x report development, Project architecting, report troubleshooting, SQL Modification and tuning system administration.
• Performance evaluations and clean up metadata to improve performance.
• Modify reports to shorten execution times. Setup Microstrategy Enterprise Manager and the ETL process.
• Administer users and groups for Microstrategy Audit.

Confidential, Microstrategy Administrator & Developer- contractor August 2002 to July 2004
Overland Park, Kansas

• Manage and setup Enterprise Manager, Security filters, and administer over 14,000 users in two large MSI environments.
• Develop MSI projects (Prototype and Production) using MicroStrategy 7i Desktop.
• Upgrade MSI v 5 - 6, v 6 – 7.1.1, v 7.1.1 – 7.5.0, v 7.5.0 – 7.5.1 on Desktops, Intelligent and Web Servers.
• MSI 7.x.x report development, Project architecting, report troubleshooting, SQL Modification and tuning system administration.
• Database used: Oracle, Informix, MS Access, SQL Server 2000.
• Project Management, managing all aspects of BI projects
• Support 40 plus MicroStrategy projects in a production environment.

Confidential, Systems Development and Design - consultant March 1999 to August 2002
Gardner, Kansas

• Upgrade MSI 6 - 7.x.x, report development, Project architecting, , SQL modification and tuning system admin.
• Developed objects for datamart and data warehouses for H&R Block and Sprint’s CRM project.
• Microstrategy tools used on projects: Agent, Architect, Web, Object manager, Warehouse monitor.
• Teaching Microstrategy MSI Agent and Web 6 & 7 and Livelink 8 & 9, for Sprint, H&R Block.
• Development Microstrategy course books for Sprint, MSTR Web and Desktop.
• Development and support of databases for N.Y.A.B. and Yellow, NT Network support.
  
  Confidential,Adjunct Professor, Staff Development Instructor June 1994 to August 2004
• Overland Park, Kansas
• Teaching college credit hour classes and college staff on Microsoft Office and Microsoft Windows, Computer Hardware, Network Essentials, MS Project 2002, Linux Red Hat, UNIX, Project Management.
  
  
  Confidential, Educational Consultant May 1997 to March 1999

Overland Park, Kansas

• Taught Operating System, Database and Application software, DSS tools (Microstrategy), Data Warehousing concepts.
• Developed courseware for staff training (NT Admin, DSS tools (Microstrategy)).
• Development and support of datamart and data warehouse, system Admin, Windows NT Administration 4.0.
  
  Confidential, CSG Trainer, Migrations - contractor October 1996 to May 1997

Overland Park, Kansas

• Taught Windows NT and HP Open Mail, classroom and individual training.
• Developed courseware for staff training (NT training), schedule class times.
• Windows NT Administrator, Troubleshot hardware and software.

Confidential, Systems Analyst February 1996 to September 1996
Lenexa, Kansas

• System Administrator, Installed and troubleshot Windows NT Workstation and Server 3.51, 4.0.
• Installed and troubleshot Microsoft Office Professional, Rumba, Oracle, and UNIX.
• Taught staff development classes.

Confidential,National Academy of Railroad Sciences April 1993 to February 1996
Overland Park, Kansas
Systems Technician, Computer Networks

• System Administrator, Novell NetWare 3.12.
• Troubleshot hardware and software.
• Taught staff development classes in Microsoft Office, cc Mail, and Macintosh 7.5.
• Developed data bases using dBase IV and FileMaker Pro.

Certified MicroStrategy Report Developer and Project Designer

Microsoft Certified Professional (MCP)
Windows XP Pro & Server 2003, Network Essentials, Enterprise

Microsoft Certified Trainer (MCT)
Microsoft class (MOC) 803 Admin.

Certified NetWare Administrator (CNA)
Novell NetWare

Education:
BA in Computer Science
Master in Educational Technology
Degree, Computer Programmer (MIS)