We provide IT Staff Augmentation Services!

Business Intelligence Architect Resume

4.00/5 (Submit Your Rating)

Bloomington, MN

PROFILE:

  • Motivated, personable, business professional with talent for quickly mastering and applying technology to solve unusual business problems.
  • Extensive project management, software design, implementation and support experience.
  • Experience in relational database systems, web and application servers, Business Intelligence and Data Warehousing.
  • Project management experience on multiple concurrent projects with varying deadlines, resource availability.
  • Experience identifying and defining the most efficient and cost effective software solution to solve critical business needs.
  • Demonstrated ability to easily transcend cultural differences and work with and manage geographically distributed teams.
  • Thrive in deadline - driven environments.
  • Excellent team-building skills and knowledge transfer skills.

SKILLS SUMMARY:

  • Project Management
  • Commercial Software Implementation
  • Business Intelligence / Data Warehousing
  • Data Profiling and Data Quality
  • Reporting Solutions - Crystal and SSRS
  • Enterprise and Software Architecture
  • Relational Database Performance Tuning
  • ETL Products and Data Warehouse Tools
  • Application Design & Development
  • Agile Software Development

TECHNICAL SKILLS:

Successfully implemented and supported COTS products including: ORACLE Enterprise Business Suite 11 and 12 - ORACLE Business Intelligence OBIEE 11 - SAP Business Objects Enterprise 4.x - Halo Business Intelligence - Halo Source and Prism - Microsoft SSAS, SSIS and SSRS -Crystal Reports -Microsoft Office - Excel PowerPivot, Word, PowerPoint, Performance Point etc.. - SAP Data Integrator 4.x - SAS 9.2, 9.3 and 9.4 - SAS Interchange Technologies 9.4 - SAS Enterprise Guide 9.4 - WebLogic, JBOSS Application Servers 10, 11 and 12

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, MN

Business Intelligence Architect

Confidential, Minneapolis, MN

Sr. Application Server Administration

Confidential, Minneapolis, MN

ETL Designer

Confidential, Plymouth, MN

Sr. Architect

Confidential, Minneapolis, MN

Sr. Technical Architect

Confidential, Denver, CO

Sr. Software Architect

Confidential

Sr. Consultant

Responsibilities:

  • Provided capacity planning, hardware architecture and configuration for:ORACLE Enterprise Business Suite 11g - SAP Business Intelligence OBIEE 11 and 12 - SAS Software Suite - SAP Business Objects Enterprise Edition (BOXI and BODI)
  • Defined and documented 12-18 month roadmap for business intelligence and Data Architecture.
  • Defined and modeled integration of warehouse KPIs to CRM sales tool.
  • Documented current data models for multiple warehouses.
  • Converted 33 metrics and KPIs from old display to new Halo Business Intelligence Prism Portal.
  • Automated system health monitoring, documented support needs and executed project.
  • Authored end-user technical support documents.
  • Authored end user training materials and provided user training when required or requested.
  • Developed training guides and reference tools.
  • Developed ETL using SAP Data Integration and MS*SQL Server SSIS.
  • Developed reporting in SSRS, Crystal Reports, Business Objects and ORACLE OBIEE
  • Vendor negotiation and license management.
  • Provided support for SAS, ORACLE Business Intelligence, SAP Business Objects Enterprise, Data Integrator, ORACLE EBS 11 and 12, Tibco, Crystal Reports, Visionel & Autosys.
  • Removed backend issues and improved processes in Business Objects Data Integrator to eliminate multiple and infrequent errors resulting in error rate reduction of 40% and job performance increase of 35% or more. Fixes involved the Linux System, ORACLE Database fixes and Business Objects configuration changes.
  • Eliminated ORACLE database issues to decrease production job times and system failures from 40% to near 0% and increasing uptime availability and job success to 99.99%.
  • Provided problem solving and investigation skills for chronic configuration, software and incompatibility in the infrastructure.
  • Supported 7 TB Business Intelligence database utilizing ORACLE and ATG. Designed needed improvements and new measurements, provided design docs to developers and managed and supported progress to ensure successful delivery.
  • Designed and wrote many various scripts to automate file movement, monitoring and restart of failed processes and database functions. Utilized Perl, BASH, Awk and Python.
  • Successfully completed conversion of data warehouses and ETL jobs from SSIS and SSAS to Halo Business Intelligence.
  • Managed development team of 6 professionals.
  • I had direct responsibility for the day to day work of local and off-shore development staff.
  • Developed project work breakdown structure, assigned work and tracked progress.
  • Provided team development opportunities and worked with individuals on skills development.
  • Managed technical team of 10 professionals.
  • Planned long term effort of ORACLE EBS conversion and rollout and hired the project team.
  • Managed consultant budget, time and activities.
  • Managed project estimates against time and budget to ensure successful on time delivery.
  • Team Building.
  • Utilized opportunities to cross train other team members when applicable.
  • Frequently held small training sessions to share information with other team members.
  • Created support documentation standards and team reviews to share support knowledge.
  • Implemented peer recognition solutions and provided recognition when appropriate.
  • Mentored junior staff on development and training needs.
  • Provided on site and off site team collaboration activities to build an engaged team.

We'd love your feedback!