SEARCH

Senior BI Consultant Resume Example

Resume Score: 80%

Love this resume? Build Your Own Now
SENIOR BI CONSULTANT
Summary
Focused and meticulous Software Engineer with over 25 years IT experience, proficient at problem recognition and resolution, offering superior skills in Business Intelligence (BI) Data Modeling and Architecture, innovative BI solution development, Agile BI/DW Project Implementation and Lean/Six Sigma Process Improvement Methodologies.
Highlights
WebFocus OBIEE RPD & Report Oracle SQL Oracle PL/SQL Agile BI/DW LSS Continuous Improvement Tableau JavaScript
Experience
Senior BI Consultant
August 2015 to December 2015 Blue Cross Blue Shield Mississippi - Flowood, MS
  • Produced complex web reports using extensive HTML/CSS.
  • Remediated reports with DB2 and Netezza data sources as required.
  • Coordinated with QA testers from end-to-end testing phase to post-production validation phase.
Senior BI/Reporting Software Engineer
July 2011 to June 2015 Fidelity Investments - Westlake, Texas
  • Coordinated migration several WebFocus Reporting applications from version 7.7.x to version 8.103 with off-shore team.
  • Developed OBIEE BI Metrics for Security Pricing Business Process Work-flow monitoring, and Second-Level System Support Processes.
  • Developed Logical Data Model, contributed to ETL work-flow and constructed Star-Schema Dimensional model.
  • Supported Reporting applications for Cash Management, Transfer Agents and Mutual Fund Management and drove continual improvement by re-engineering legacy code.
  • Transitioned from SDLC Methodology to Agile Methodology incorporating LEAN Practice especially as it applies to BI Development.
BI Developer/Analyst
January 2011 to July 2011 LeanLogistics - Holland, Michigan
  • Contracted to convert 100 reports from MS Access to Web Focus 7.7.
  • Developed functional specifications for a single multi-profiled report engine to replace multiple variations of MS Access reports individually customized for multiple users.
  • Designed the Logical Data Model to support the customization based on user profiles.
  • Constructed the Web Focus code to integrate the report engine into the user work-flow to provide customized PDF and MS Excel reports.
  • Produced PDF-embedded trending graphs both for on-screen and Report Caster Scheduled use.
Principal Consultant, BI Developer
September 2004 to December 2009 KEANE INC - Boston, Massachusetts
BI Analyst
January 2007 to January 2009 Fidelity Investment Services
  • for the Compliance Business Unit; converted over 20 Regulatory-required Compliance reports from PC-Based BRIO, JavaScript, Access, Excel platform to WebFocus with formatted Excel output reports and scheduled by ReportCaster.
  • Created WebFocus Dashboard that provided reports in Excel, PDF and HTML formats.
  • Creating rolling 12-month Compliance Metrics Report with WF Dynamic OLAP design that gave 'slice-and-dice' and 'drill-down' functionalities.
  • Modified dashboard programs to allow access to WebFocus Internal files to invoke the ReportCaster Utility and save output to the ReportCaster Repository to fulfill a short-term 'archiving' requirement.
January 2004 to January 2006 Wellington Wealth Management
  • Completed Technical Specification Document and developed COGNOS Powerhouse enhancements for the.
  • Corporate Actions and Security Pricing Business Applications during migration from previous legacy systems.
  • Develop reports for the migrated enterprise-wide environment using ORACLE Reports Developer.
Software Analyst/Developer
July 2002 to July 2004 MACKENZIE FINANCIAL - Toronto, CANADA, Ontario
  • Created the Technical Specification Document for a major enhancement to the MPower Fund Accounting System.
  • Lead Developer for MPower System COGNOS Powerhouse software enhancement.
  • Project Lead for the conversion of the Fund Partnership Information Network system from C-ISAM to ORACLE 8 and created all shell scripting used in this conversion.
  • Created the Trades Upload functionality from Mackenzie Financial to the BLOOMBERG Trading System.
Education
Lean Six Sigma : Continuous Process Improvement Currently enrolled in Green Belt Certification Yellow Belt Certification Skills Training : Continuous Education OBIEE RPD Development and Administration (Oracle Corp.) Informatica PowerCenter Level 1 (Informatica Corp.
Master of Philosophy (M. Phil : Computer Science University of The West Indies (U.W.I. BARBADOS) Computer Science Bridgetown, Barbados, West Indies Computer Science Thesis "The Theory of Highly Available Distributed Systems (HADS)" not submitted.
Bachelor of Computer Science : Computer Science/Mathematics Concordia University - Montreal, Quebec, Canada Computer Science/Mathematics
Skills
Agile, BLOOMBERG, BRIO, BI, Business Process, C-ISAM, Cash Management, COGNOS, Compliance reports, Continuous Improvement, conversion, CSS, ETL, Financial, Focus, Focus 7.7, functional, Fund Accounting, graphs, HTML, DB2, Informatica, JavaScript, Access, MS Access, MS Access, MS Excel, Excel, migration, enterprise, Network, OLAP, ORACLE, Developer, Oracle PL/SQL, Oracle SQL, ORACLE 8, PDF, Powerhouse, Pricing, Processes, Process Improvement, Project Lead, QA, re-engineering, Reporting, requirement, SDLC, shell scripting, Six Sigma, Specification, Tableau, Trading System, validation, Work-flow
Build Your Own Now

Resume Overview

Companies Worked For:

  • Blue Cross Blue Shield Mississippi
  • Fidelity Investments
  • LeanLogistics
  • KEANE INC
  • Fidelity Investment Services
  • Wellington Wealth Management
  • MACKENZIE FINANCIAL

School Attended

  • University of The West Indies (U.W.I. BARBADOS)
  • Concordia University

Job Titles Held:

  • Senior BI Consultant
  • Senior BI/Reporting Software Engineer
  • BI Developer/Analyst
  • Principal Consultant, BI Developer
  • BI Analyst
  • Software Analyst/Developer

Degrees

  • Lean Six Sigma : Continuous Process Improvement Currently enrolled in Green Belt Certification Yellow Belt Certification Skills Training : Continuous Education OBIEE RPD Development and Administration (Oracle Corp.) Informatica PowerCenter Level 1 (Informatica Corp.
    Master of Philosophy (M. Phil : Computer Science
    Bachelor of Computer Science : Computer Science/Mathematics

Advertisement

Similar Resumes

View All

SAP BO BI Consultant

FTS International

Atlanta, Georgia

Posted 1659 days ago