We provide IT Staff Augmentation Services!

Senior Bi Consultant Resume

Crescenta, CA

SUMMARY:

  • Senior Business Intelligence developer and project manager, with extensive experience in software analysis, design, development, testing, quality assurance, implementation, documentation, training, and all areas of project management including SDLC and Agile development.
  • Over 15 years of Business Intelligence experience in report development, dashboard development, analysis, and administration, including the Cognos 10 and Cognos 8 BI Suite: Report Studio, Active Reports, Framework Manager, Analysis Studio, Query Studio, Metric Studio, PowerPlay, Transformer, and Cognos Connection. Also experienced in Tableau analytics & dashboards and Microsoft SQL Server Reporting Services (SSRS).
  • Over 15 years experience in SQL, including Oracle, Microsoft SQL Server, MySQL, and Sybase.
  • Over 10 years experience in project and team management, including project management, team management, project budgeting, project tracking, staff and contractor hiring, staff management, onshore/offshore project management, time tracking, and standards and procedures.

SKILL:

  • Cognos Report Studio, versions 8.0 - 10.2
  • Cognos Metric Studio, versions 8.0 - 8.3
  • Cognos Analysis Studio, versions 8.0 - 10.2
  • Cognos Active Reports, versions 10.0 - 10.2
  • Cognos Query Studio, versions 8.0 - 10.2
  • Cognos Framework Manager, versions 8.0 - 10.2
  • Cognos Connection, versions 8.0 - 10.2
  • Tableau, version 9.3
  • SQL Server Reporting Services, version 2012
  • PL/SQL ETL
  • Transact-SQL ETL
  • Oracle Database, 9i, 10g, 11g
  • Microsoft SQL Server, through version 2012
  • SAP Sybase
  • Microsoft Access
  • Claris Framework Manager
  • Oracle MySQL
  • SQL Server Management Studio
  • Quest TOAD
  • Microsoft Query Analyzer
  • Embarcadero DBArtisan
  • Microsoft Visio
  • Computer Associates ERwin
  • Oracle JD Edwards EnterpriseOne Enterprise Resource Planning (JDE E1 ERP)
  • NextGen Healthcare Electronic Health Record (EHR)
  • Siebel Customer Relationship Management (CRM) - Finance, Marketing, Call Center
  • Siebel Analytics
  • Siebel Marketing Analytics
  • WordPress, through version 3.7.9
  • HTML, through version HTML5
  • CSS, through version CSS3
  • JavaScript, through version 1.6
  • ASP, through version 3.0
  • PHP, through version 7.0
  • Java, through version SE 6
  • Adobe Photoshop CC, through version 2015
  • Adobe Photoshop Lightroom, through version 5
  • Adobe Illustrator CC, through version 2015
  • Adobe Acrobat Distiller, through version 6
  • Atlassian JIRA (Agile Issue & Project Tracking)
  • Hewlett-Packard Test Director (Quality Assurance)
  • ManageEngine ServiceDesk Plus (Help Desk)
  • Altiris Express (Help Desk)
  • Serena TeamTrack (Process & Issue Management)
  • Agile Development Methodology
  • Scrum Development Methodology
  • System Development Life Cycle (SDLC) Methodology
  • Standardized PMO Methodologies & Project Deliverables Documentation
  • Project Task Planning & Estimation
  • Resource Planning & Estimation
  • Project Budget & Actual Planning & Tracking
  • Project Status Reporting
  • Microsoft Project, through version 2013
  • Microsoft PowerPoint, through version 2013
  • Microsoft SharePoint & SharePoint Administration, through version 2016
  • Microsoft Word, through version 2013
  • Microsoft Excel, through version 2013
  • IBM Notes Social Edition, through version 9.0
  • Compuware Changepoint (Time & Budget Tracking)

PROFESSIONAL EXPERIENCE:

Confidential, Crescenta, CA

Senior BI Consultant

Responsibilities:

  • Independent consultant providing design, development and project management consulting services to a range of clients in the Southern California area.
  • Specializing in Data Warehouse and Business Intelligence technical and project lead solutions with Cognos Series 8 and 10, including architecture (Framework Manager), report development (Report Studio, Analysis Studio), cube design and development (Transformer, PowerPlay), and metric analysis, design, development (Metric Studio), technical and end - user training (Report Studio, Query Studio, Cognos Connection), and support services (Cognos Connection, audit reporting, batch processing, performance improvement, bug fixes and enhancement support).
  • Developed claims balanced scorecards, vendor performance dashboards, and metrics data and analytics for Vendor Engagement Management team at major health care company, using SQL queries, T-SQL stored procedures, Tableau 9.3, and Microsoft SQL Server Reporting Services (SSRS) against Microsoft SQL Server 12 databases.

Confidential, Crescenta, CA

Senior BI Consultant

Responsibilities:

  • Developed reports and dashboards, upgraded report software versions, wrote and maintained SQL views and procedures, developed TL/9000 quality management report suite, provided audit reporting and production support for telecommunications testing and services management company, using Cognos BI versions 8.4, 10.1 and 10.2 against Microsoft SQL Server and Oracle data warehouses.
  • Developed reports, enhanced, supported bug fixes, trained business users in report development, provided production support, and wrote report and system documentation for workers compensation insurance company, using Cognos BI version 8.4 against Microsoft SQL Server data warehouse.
  • Provided BI departmental and project management, including project estimation, project tracking, project status reporting, vendor management, enhancement and bug tracking, report development, report enhancements, report bug resolution, framework creation, enhancements and maintenance, metrics development, power user training, and production support for healthcare services company, using Cognos Framework Manager, Report Studio, Query Studio, and Metric Studio versions 8.3 against Microsoft SQL Server data warehouse.
  • Developed and enhanced reports, resolved bugs, trained power users, provided administrative server production support, and supported end-users for telecommunications testing and services management company, using Cognos Report Studio and Query Studio version 8.3 against Oracle data warehouse.
  • Developed and enhanced reports, resolved bugs, and trained power users for simulation software technology company, using Cognos Report Studio, Analysis Studio, and Query Studio versions 8.2 and 8.3 against Microsoft SQL Server data warehouse and Cognos Planning databases.

Confidential, Orange, CA

Reporting Manager

Responsibilities:

  • Ensured the timely and accurate generation of all corporate internal reporting, consistency and standardization amongst the various types of reports and databases.
  • Managed Cognos 10.1 and Oracle SQL reporting tools used by the department.
  • Managed team of 4 reporting analysts.

Confidential, Orange, CA

Reporting Manager

Responsibilities:

  • Developed complex reports using bursting, exception reporting, and other advanced techniques.
  • Analyzed, interpreted and reported financial and operational performance trends from various channels & departments, identifying areas performing outside of expected results.
  • Developed efficiencies to increase the effectiveness of reporting and consolidate and maintain departmental reports used internally and externally.
  • Maintained a reporting schedule and documentation of reporting procedures. Generate and maintain control documentation of reporting procedures to comply with governance audits and regulatory requirements. Built audit process to ensure data integrity and efficiency.

Confidential, Pasadena, CA

Project Manager

Responsibilities:

  • Managed number of projects including Siebel 7.7 Upgrade, Home Construction Lending Submission Support Representatives Integration Project, Online Home Equity Application Project, and Consumer Bank Cross-Sell Marketing Analytics Project. Project scopes up to $2.2 M and 45 participants, with reporting up to COO/CFO/CTO level.
  • Partnered with Corporate Program Management Office (PMO) to deliver required SDLC methodology, including documentation, project plans, budgets, project reporting, executive presentations and approvals.
  • Managed projects using in-house Siebel staff, in-house interdepartmental staff, and external consulting staff. Managed Accenture, Cognizant, and Oracle consulting staffs to deliver Siebel projects using combinations of both onshore and offshore staffing.
  • Managed report development staff of 3 to deliver CRM and sales related-reporting using Cognos suite of products.

Senior Analyst/Lead

Confidential

Responsibilities:

  • Designed and developed key suite of sales performance reports, including pipeline, rate lock, funding, and CRM customer activity reports.
  • Primary applications included Cognos Impromptu, PowerPlay, ReportNet, Cognos 8.0, Framework Manager, Microsoft SQL Server, Siebel, JavaScript, and HTML.
  • Provided Data Warehouse consulting in the areas of analysis, design, development, testing, training, and support.
  • Specialized in Cognos BI solutions including PowerPlay and Impromptu.

Confidential, El Segundo, CA

Lead, Application Systems

Responsibilities:

  • Developed PowerPlay cubes and reports and Impromptu reports against Oracle data marts.
  • Designed data marts and wrote data mappings for Oracle data warehouse to data mart ETL processes. Supervised Informatica ETL development.
  • Developed conforming dimensions, corporate data dictionaries, BI standards, and best practices as member of corporate project teams.
  • Managed implementation activities, including security software installations, end-user training, and software documentation.

Systems Specialist

Confidential

Responsibilities:

  • Developed PL/SQL ETL programs using Sybase stored procedures to create and maintain operational data stores for advanced Impromptu reporting.
  • Developed PowerPlay cubes and reports and Impromptu reports from Sybase operational data stores and application systems.
  • Trained developers and Power Users on advanced use of Cognos reporting tools.
  • Applications included Point of Sale, Competitive Retail Sales Tracking, Marketing Demographics, Design and Development, Product Line Review Planning against Sybase databases.

Confidential, Crescenta, CA

Software Consultant

Responsibilities:

  • Developed Data Warehouse Sales Reporting cubes and reports using Oracle, PowerPlay and Impromptu for a biotechnology company ( Confidential ).
  • Developed Warranty Tracking system, Accounts Payable interface, Defect Tracking, and other applications work for a manufactured housing and recreational vehicle manufacturing company ( Confidential ).

Confidential, Crescenta, CA

Software Consultant

Responsibilities:

  • Converted custom insurance application from FileMaker Pro to Microsoft Access for a small business insurance broker in Portland, Oregon
  • Coordinated insurance package software installation for a small Orange County business insurance broker
  • Applications included Cognos Impromptu reporting.

Confidential, Pasadena, CA

Systems Supervisor

Responsibilities:

  • Applications included Policy, Invoicing, Claims, Sales Call Reporting, Work Management, Customer Relationship Management and Accounting.
  • Software included PowerBuilder and Cognos PowerHouse.
  • Databases included Sybase, Microsoft SQL Server, and HP Image.

Confidential, Culver City, CA

Systems Supervisor

Responsibilities:

  • Applications included Policy Underwriting, Claims, Sales Call Reporting, Work Management, Customer Relationship Management and Accounting.
  • Software included Ellipse (3-tier Client Server), Gupta SQL Reporting, Cognos PowerHouse and Cognos PowerPlay.
  • Databases included Sybase, Microsoft SQL Server, and HP Image.

Hire Now