Senior BI Consultant Resume Example Microstrategy

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 2015Microstrategy - Menlo Park , CA

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 2015Mastech Digital, Inc. - Harbor City , CA

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 2011Zippin - Indianapolis , IN

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 2009Bickford Senior Living - Lincoln , NE

BI Analyst
January 2007 to January 2009Fidelity 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 2006Wellington 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 2004MACKENZIE FINANCIAL - City , STATE

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 ScienceUniversity 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/MathematicsConcordia University - City, State, CanadaComputer 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

Resume Overview

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

Senior BI Consultant Resume Example

DISCLAIMER

How this resume score could be improved?

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes