We provide IT Staff Augmentation Services!

Senior Bi Manager/technical Advisor Resume

3.00/5 (Submit Your Rating)

Atlanta, GA

SUMMARY:

Deeply experienced and accomplished Senior - level IT professional with 30 plus years of extensive Fortune 100/500 client IT experience delivering Financial, Telecommunications, Manufacturing and Business Intelligence & Data Warehousing computer solutions. A self-starter with reputation for high quality deliverables, expertise in data and solutions architecture and a heavy focus on client satisfaction. Proven ability to scope projects as well as translate user’s priority business needs into technical requirements and technology solutions. Excellent analytical, client service, innovation, and management skills and strong ability to communicate information across multi-disciplinary teams. Expert in resolving client-facing data issues, and executing critical strategic initiatives within corporate business environments. Agile Scrum Master Certified and over 6 years of Agile/Waterfall Project Manager experience in EDW/Big Data environments.

AREAS OF EXPERTISE:

Big Data Cloud/On-Premise

Enterprise Business Intelligence

Strategic Planning/Analysis

Engagement Management

Software Development Lifecycle

Financial/Metrics Modeling

Enterprise Architecture

Advanced SQL & BI Tools

Business Intelligence Analysis

Process Improvements

BI/DW, Data Governance

Program Management

Data Warehousing/Integration

Data Visualization/Modeling

Business Intelligence Reporting

Agile/Scrum Master Certified

Project Innovation/Process

Employee Training, Mentoring

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Senior BI Manager/Technical Advisor

Responsibilities:

  • Successfully managing multiple Global Reservations System applications Projects in an Agile/Waterfall environment from Inception thru Implementation in multi-team/cross-functional environment. These projects are part of IHG replacing their legacy Hotel Reservations System across their entire global hotel chain portfolio.
  • Project Charters, Project Plans/Schedules/Budgets/Tracking, Resources, Solution Architecture Design, Risk, Change, Project Scope, Project team meetings, Project Status to Leadership. Project Descriptions:
  • GRS V2 R8 Low-Level Design, Products & Attributes, Reservations Data models, Operational & Analytical data requirements
  • Solution Architecture design reviews, Data Model Architecture design/reviews
  • GRS V2 SLA Reporting multi-data source, data integration, Google Cloud/On-premise, Hadoop/Teradata data ingestion and Reports/Dashboards project
  • Data Model/Architecture, Software Solution Architecture reviews in Big Data Ingestion Hadoop/Hive, Teradata EDW environments
  • Six data sources ingestion via REST API, SFTP file servers for SLA Reporting
  • GRS V2 R8 Data Architecture solution/design in Google Cloud/Hadoop/Teradata data environment
  • Data Model/Architecture, Software Solution Architecture reviews in Big Data Ingestion Inspection Framework, Hadoop/Hive, Teradata EDW

Confidential, Atlanta, GA

Senior BI/DW Project/Program Manager

Responsibilities:

  • Sr. Agile Project Manager on multiple projects managing resources for Discovery Q1 Release Microstrategy Dashboards/Reports enhancements from Requirements through Implementation, assist with Discovery MSTR and Splunk/Redshift DB technical support, AWS.
  • Successfully managed and delivered two Q1 Releases 1.0, 1.1. Implementations of the Discovery Microstrategy Dashboards/Reports enhancements to approximately 300 users.
  • Organize and lead Analytics project related meetings including Global IT Monthly Steering Committee
  • Create/manage CCFS Analytics Master Project Plan, overall budget $2.5 million.
  • Create/Maintain CCFS Project Milestone records in Salesforce.com cloud application

Confidential, Boston, MA

Senior BI/DW Manager/Sr. Technical Advisor

Responsibilities:

  • Evaluated leading BI Software solutions IBM Cognos BI, SAP Business Objects BI and six software consulting vendors to architect and implement ADP’s first Enterprise Business Intelligence Data Warehouse focused on Denovo/ Confidential reporting.
  • Confidential Reports and cube conversion and automation, data cleansing, enhance departmental BI for enterprise.
  • Conducted meetings with software principals and consulting vendors to review proposals, business requirements and technical specifications.
  • Created multiple SWOT Analysis presentations for the ADP Executive Leadership team for final decision. Established Data Governance/MDM solutions approach in SQL Server DQM/Jira Confluence tools.
  • Successfully assembled/presented SWOT Analysis/Architecture Overview and presented to Executive leadership to drive decision for BI/DW Software platform and consulting team. Reviewed vendor proposals and made final recommendation for IBM Cognos and QueBit consulting (chosen by Executive Sponsor). Prepared initial Agile/Waterfall project plans and managed projects from inception Project Phase I kick-off through Implementation Phase on-time/on budget.
  • Successfully managed End-to-End project Consulting team from requirements, design, development, testing, documentation and implemented ADP’s first ever foundational Business Intelligence Enterprise Data Warehouse in a IBM Cognos10 and MS SQL Server environment with 300 users integrated with existing Confidential system. ADP is a billion dollar Dental Practices services provider. Successfully Created/Managed/Delivered the company’s Enterprise Data Warehouse and Data Governance Roadmap for Executive.leadership and user data foundation for the BI/DW.

Confidential, Atlanta, GA

Senior BI Manager/Technical Architect

Responsibilities:

  • Business Intelligence (BI) tool evaluation project for Project Portfolio Management data reporting project.
  • Modeled project financials/metrics data and dashboards in Tableau 10, QlikSense and SiSense for the IHG Executive Leadership team.
  • Successfully managed/modeled Data Export/Import from Smart Sheet project portfolio data sources.
  • Completed Analysis/Modeling/Preparation and Dashboard prototyping in multiple tools (Excel, QlikSense, Tableau, SiSense) from Requirements through Proof-of-Concept Dashboards and hand-off to Tableau consultants.

Confidential, Atlanta, GA

Senior BI/DW Project/Program Manager/Technical Architect

Responsibilities:

  • BI/DW Sr. Program/Project Manager/Sr.BI Architect Sr. BI PM responsible for managing/delivering seven (7) BI EDW Data Integration Projects plus a major Global Trade Compliance BI/EDW Phase I & II Project, Chemical Sales Consolidated Reporting JDE, ROSS, SAP ERP data, Electronic Health & Safety history data projects. SQL Server 2012, IBM DataStage ETL.
  • Successfully captured all business/technical Requirements BI technical design/architecture designs/reviews.
  • Created/Managed all (7) MS Project Plans (Agile/Waterfall), managed project issues and task tracking (Power Steering), Daily/Weekly project status, Communication of Requirements and Status with Business/Technical staff, Technical Issues resolution, and meeting planning/leading. Managed a team (3) ETL IBM DATASTAGE resources and (2) IBM Cognos reports developers and (1) Business Analyst per project requirements on SQL Server 2012. Delivered all strategic projects on-time, on-budget.

Confidential, Atlanta, GA

Senior BI/DW Project Manager/Technical Architect

Responsibilities:

  • Senior Technical Project/Program Manager and Sr. Solutions/Data Architect Data Strategy Team engaged with Data Governance Metadata Management (MDM) program Informatica PowerCenter SE 8x, Golden Gate,, iLOG, ActiveVOS (Workflow Mgmt.), CA-Repository, IBM Infosphere v8.5/7, IBM Netezza, Teradata 12x/13 over CIM - Customer Info Management System), Oracle 11g environments Oracle Data Relationship Mgmt. (DRM11.1.2).
  • Executed special project for Data Strategy Team analysis of Teradata tables/data analysis. Created project impact checklist for use by DS team.
  • Achieved CIM (Customer Information Management) System in-depth analysis for Data Strategy Director/Team initiative to gauge project impacts to CIM and successfully delivered critical Impact Checklist for the Program Management Office (Front Door) evaluation.
  • Successfully gathered requirements and created Solution Approach/High-Level Design for Data Governance project working with eight cross-functional teams to deliver IBM Infosphere MDM/Netezza DW.
  • Created/Managed/Delivered Solution Approach and Design for ActiveVOS Oracle DRM (Hierarchy Management) Workflow Integration project.

Confidential, Atlanta, GA

Senior BI/DW Architect/PM

Responsibilities:

  • Developed/converted SAP Business Objects XI and Oracle OBIEE 10 BI Publisher sales/financial performance reports
  • Manage/Develop automated Menu Price updating project in Genio ETL tool on team of 3 developers, 1 PM.
  • SAP Data Integrator Netweaver /Oracle 10g/11g, Genio ETL design/development, Oracle OBIEE, BI Publisher (complex SQL), Business Objects. Base Camp Agile Project Management
  • Successfully converted/delivered 27 key Business Objects XI Restaurant KPI/Location Financial Comparison reports (complex SQL queries ranking/percentiles, 100 pg. data templates, report bursting) into Oracle BI Publisher/Oracle Answers ad hoc reports 10g for web deployment on company portal. Analysis/design/develop subset of above for Mobile sales reports in BO XI and BI Publisher.
  • Successfully Managed/developed ETL project to automate restaurant Menu pricing changes previously taking 1-2 weeks to accomplish manually execution in minutes via automated process.
  • Invented and patented design for ergonomic wrist rest product for laptop/desktop computers.
  • Provided new product creation, design, manufacturing and sales and marketing.
  • Successfully invented new ergonomic computer accessory product successfully selling on Confidential .
  • Developed business and marketing plans, sales calls to retailers including C-level execs and positioned product for automated on-line sales and fulfillment on Confidential .

Confidential, Reston, VA

Project Manager/Lead BI/DW Reports Architect

Responsibilities:

  • Project: Data Warehouse Architect/Developer/Project Manager for design, development and implementation of PeopleSoft Global HR Data Warehouse application for DIMHRS - Defense Integrated Military Human Resources System
  • Project Manager for Actuate and Cognos8 cubes/reports (2 developers), Ascential Datastage ETL changes (3 developers), and PeopleSoft Application Designer over DB2/UDB AIX Data Warehouse.
  • Worked with cross-functional teams to identify/update functional specs and related design documents for Army/Air Force DIHMRS systems.
  • Worked and communicated with high level officers and C-management.
  • Researched numerous Data Governance approaches/white papers: TDWI, HP BI Master Plan, DataFlux, Talend, Trillium, Informatica, IBM, Teradata).

Confidential, Atlanta

Technical Solutions Architect/Project Lead

Responsibilities:

  • Sr. Consultant/Technical Solutions Architect/Project Lead for Confidential Business Intelligence application outsourcing engagement of Actuate enterprise reporting system utilizing Actuate 8 iserver, ActivePortal, DataMart, VB .NET, C#, IIS, Reporting Services, PeopleSoft 8.8 working directly with a CIO and VP to successfully knowledge transition and outsource their system to Confidential on-shore/off-shore resources.
  • Data Conversion Design Lead Architect for CalPERS project in Sacramento, California CALPers Pension Resumption System (PRS) Oracle 10g project.
  • Worked with cross-functional teams to design Logical/Physical models for new Oracles PRS database and design, develop ETL procedures for DB load utilizing PL/SQL in Oracle SQL Developer.
  • Analyze demographic legacy data, develop design, troubleshoot for data cleansing/consolidation strategy, staging data and ETL loading to final PRS Db. A
  • Project Lead responsibility for Datamart/ Actuate7 /VB .NET/Peoplesoft8/reports and client exit criteria, completing testing prior to taking over application support in Atlanta.
  • Managed 3 contract reporting resources as well as transition knowledge training to offshore Manila resources team for Datamart/Actuate support.
  • Managed Full life-cycle development, production support and interfacing with senior level management.
  • Developed all reporting knowledge transition documentation and cross-trained Manila offshore resources on the application.
  • Solved major data and reporting issues left open previously by internal staff. Managed year-over-year Actuate e.reporting folder re-deployment.
  • Mentored new-hire employees Confidential Business Intelligence boot camp teaching consultants high level overview of Confidential Business Consulting concepts, project methodologies and Business Intelligence practices.
  • Presented SWOT analysis for Endeca and Netezza fast search tools for BI Consulting Group of 400 consultants.
  • Successfully completed legacy Data Conversion and Metadata control technical and ETL PL/SQL design/development/test for critical multi-million dollar Confidential.

Confidential, Atlanta, GA

Lead Architect

Responsibilities:

  • Sr. Reports Architect/PM working on a complex Actuate reporting project Confidential for Callidus Bonus Calc re-engineering project.
  • Full SDLC - working with cross-functional teams to gather Functional Requirements, Create Design, Develop, Test, Document and Implement Actuate7 reports to meet Enterprise Incentive Management Bonus Calculation Project needs utilizing TrueComp, DataMart, Actuate e.Reporting tool.
  • Work with Ab Initio Lead Developer to design IBM DB2 tables and remedy performance issues in order to satisfy acceptable Service Level Agreements.

Confidential

Sr. Lead Reporting Architect

Responsibilities:

  • Sr. Technical Reporting Consultant Actuate 7 e.Reports Developer working on Reporting projects Confidential multiple client sites.
  • Full SDLC - Functional Requirements, Detailed Design, Develop, Enhance, Document, Test, and Implement reports and ETL procedures to meet various clients’ needs utilizing TrueComp/Datamart, Oracle 9i, PL/SQL.

We'd love your feedback!