Resume -- Data Warehouse and Business Intelligence Professional

Posted by on | |

PROFESSIONAL PROFILE
Service minded Business Intelligence professional with real world experience leading project efforts, analyzing and documenting business requirements, managing business intelligence and IT project in multiple industries and developing and administering reporting tools. Business leader recognized for delivering solutions that exceed customer requirements. Unique blend of technical knowledge, business acumen, and leadership skills. Known for leading initiatives, designing solutions, and consistently playing a critical role on key company BI initiatives.

Additional expertise includes:
  • Gathering key information
  • Identifying business needs
  • Analyze information requirements
  • Broad understanding of Business Intelligence best practices
  • Personable, easy going
  • Analysis and architecture of system design, code and/or strategy
  • Developing reports and BI solutions
  • Effective documentation
  • Create and troubleshoot reports
  • Large scale BI implementations

SELECTED ACCOMPLISHMENTS
  • Analyzed the business needs providing detailed documentation of system requirements.
  • Developed a project plan and led a migration project
  • Managed the Request for Proposal process ending in a successful decision on consulting partners
  • Led a team to successfully implement the “impossible” software migration.

TECHNOLOGIES
  • Business Intelligence:
    • Cognos
      • ReportNet
      • PowerPlay
      • Framework Manager
    • Oracle Hyperion OBIEE+
      • Interactive Reporting
      • SQR
      • Essbase
      • Shared Services
      • Workspace
    • Microsoft BI Tools (SSIS, DTS)
    • Informatica
    • Data Warehouse
      • Design
      • Data Marts
      • Dashboards
      • Visio
  • Databases
    • Oracle
    • SQL Server 2000 - 2008
    • DB2
    • MySQL
  • Developer skills
    • VB.NET
    • VB Script
    • SQR
    • BAT
    • PHP
    • JavaScript
    • HTML
    • CSS
    • Joole/MS Office automation and macros
    • Java
    • Customize blog sites
  • Microsoft Office/OpenOffice
  • Business Objects BPC (formerly Outlooksoft CPM)

EMPLOYMENT

Business Intelligence Analyst II, AmeriCredit / GM Financial
Arlington, TX, 2010-present
  • Administer, maintain and develop solutions for BI and Financial Application systems
    Software Engineer III / BI Developer, HealthMarkets
    North Richland Hills, TX, 2008-2010
  • Worked with Claims department to create data models and reporting solutions to meet regulatory requirements exceeding expectations and delivering early.
  • Analyzed Service Desk reporting utilizing Query Analyzer and migrated reports from a SQL Server Reporting Services environment to a Hyperion environment.
  • Administered Hyperion system leading to acknowledgment and resolution of 90% of all Incidents within agreed upon service level agreement (SLA)
  • Trained users and led Hyperion User Group Meetings increasing utilization of the data warehouse
  • Trained and coached users increasing user productivity and reducing report generation time from days to minutes
  • Created ad hoc reports, analyzed data, developed ODS solutions for quick resolution to customer tickets
  • Designed, developed, and supported Business Intelligence solutions for compliance and customer retention resulting in simplified compliance processes and increased persistency (SQL Server and Oracle environments)

Senior Programmer Analyst/Application System Analyst, Texas Health Resources
Arlington, TX, 2006- 2008
  • Analyzed, developed a project plan, documented current system (Visio), managed the Request for Proposal process, recommended consulting partners, and led a team of five to completion of a Hyperion migration project
  • Utilized Microsoft SQL Server Query Analyzer to analyze and administer the Hyperion system repository and reports, and develop and debug code used in Hyperion reports
  • Made suggestions for further adoption of Hyperion Business Intelligence at THR, provided support and training to new users, and managed the web system resources as the growth took place
  • More than doubled the number of reports, thereby providing a more effective financial analysis tool for Decision Support, Central Business Office, and Human Resource users
Business Intelligence Consultant, 1Answer Solutions
Denver, CO, 2005- 2006
  • Managed customer relationships while developing Business Intelligence solutions
  • Created reports with Hyperion SQR and Hyperion Interactive Reporting reporting tools against Microsoft SQL Server, Oracle, Essbase, and other well known databases
  • Consulted on eight successful projects migrating SQR reports, conducting Hyperion SQR training classes, and building dashboards using Hyperion Intelligence within the allotted time frame and budget
**Clients included the finance arm of an international auto manufacturer, marketing department of well know cruise ship operator, a Sarbanes-Oxley project with a popular home furnishing company, among others
Graduate Student Summer Intern, Professional Datasolutions Inc.
Temple, TX, 2004
  • Delivered network and technical solution for yearly PDI convention, 100% preparations on-time
  • Provided desk-top support, troubleshooting hardware, software and network problems
Web Developer and Business Instructor, Omne Educational Resources
Houston, TX, 2002
  • Taught classes helping students grasp and utilize key business software
  • Successfully developed and designed a computer-based grade and attendance system using HTML, VB Script and MS SQL Server
  • Provided the first new grading system for the school in many years while returning an ROI of over 15%
Training Developer, Compaq Computer Corporation
Houston, TX, 2001 – 2002
  • Designed, developed, implemented and supported Compaq Enterprise Business Group’s training database (MS SQL Server/Access) and online training site (ASP/FrontPage)
  • Developed training materials on technical and non-technical subjects utilizing MS PowerPoint and web technologies for delivery
  • Mastered intricacies of multiple topics and trained employees on the subjects

EDUCATION

Master of Science in Information Systems (MSIS)
and Master of Business Administration (MBA)
Baylor University, Waco, Texas

Bachelor of Science in Marketing
University of Utah, Salt Lake City, Utah


COMMUNITY INVOLVEMENT

Church service volunteer
  • Outreach to local community, developing website for annual nativity display.
  • Coordinated service projects, organized activities, mentored members, taught classes, served as outreach director and supervised 30 teams charged with monthly visits to church families
  • Worked on multiple general church committees tasked with overall church management

Eagle Scout & Blazer Scout Leader, Boy Scouts of America




Last updated: 02/09/2011