Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Key Courses and Trainings
Key Courses and Trainings
Generic
Dawnelle Bolden-Brooks

Dawnelle Bolden-Brooks

Summary

Knowledgeable SAP BW and HANA Consultant with experience taking ownership of SAP solutions and related software and services. Talented at managing legacy installations as well as spearheading new deployments. Keen to drive positive movements in revenue and business performance through direct oversight of all branded and related products. Effective at supporting team needs with high-quality code, subject matter expertise and collaboration skills. Skilled programmer and complex problem-solver experienced in data analytics and report writing.

Overview

22
22
years of professional experience

Work History

First Line Manager / SAP BI/BW HANA Consultant

IBM Corporation
11.2018 - Current

As a manager, I champion and advance employees through listening, and empowering, them to take ownership and activate their potential and remove obstacles to achieve goals. The key manager behaviors include asking open-ended questions to help team members gain insights from multiple perspectives, active listening to understand individual needs and preferences, providing timely performance feedback, and consistently recognizing individual accomplishments.

As a BI/BW HANA Consultant, I am responsible for the rollout of technical and functional aspects of the SAP BI / HANA solution. Lead the integrated planning, design, implementation, and support of SAP BI / HANA-based solutions.

Assignment History

10/2019 - To date

8 months

Next Era Energy

SAP BW Coordinator

Project Description: Requirement gathering from Business Analyst. Functionality involved FI, BPC, APO, SD. Design and develop BW solutions aligning with SAP BO design. Solutions involve customizing SAP Extractors, creating generic extractors, designing complex BW data flows, Customer exists and user Interface, onsite coordinator for offshore strength of ~ 6 SAP BW resources and 5 onsite resources. Production cut-over / transport co-ordination.

  • Create and modify Calculation Views
  • Create HANA stored procedures
  • Enhance BW extractors
  • Create/modify SAP BW data flow
  • Manage development work with offshore team
  • Manage IBM onsite resources (review/approve timesheets, performance evaluations)
  • Conduct technical interviews and coordinated onboarding of resources

Contributions:

  • Custom Build of Statement of Cash Flow Solution
  • 3-BW system migrations (HR, APO/SRM/ISC, FI) from on-prem to Cloud (7.5 BW on HANA)
  • BW Finance system migration from BW on HANA to BW4HANA
  • BW4HANA Issues support and mitigation
  • Accomplished multiple tasks within established timeframes.
  • Developed and maintained relationships with customers and suppliers through account development.
  • Monitored and analyzed business performance to identify areas of improvement and make necessary adjustments.
  • Maximized performance by monitoring daily activities and mentoring team members.
  • IBM Focal for PCoE (SAP Incident Management) to help improve current processes
  • Onsite coordinator for offshore and onshore resources for US onsite resources

11/2018 - 10/2019

12 months

Reckitt Benckiser (RB) Group

BI Analysts for North America and Canada

Project Description: Scheduled and led Business Intelligence (BI) deep-dive sessions that followed the initial Fit Change Assessment (FCA) session training the super users received. The purpose of the deep -dive sessions was to review current reports for each area (Sales, Finance, etc.) and document any gaps in reporting. The differences were then examined by the business, BI, BPOs to determine if a change request was required or a current reporting solution could be a viable solution. I gathered the requirements for each change I was assigned. I oversaw the coordination of the other requests to be sure the rest of the team evaluated and gathered information to categorize as a change or a FIT.

  • During the build phase, I worked on designs assigned, meeting with the business, BPOs, super users to gather the full requirements. Once the design was approved I created the technical documents. I then coordinated the handoff with the development team.
  • I created/modified the SIT documents and performed SIT script execution, logged defects, managed the BI defects, and reported on the status of those defects. During UAT testing, I supported the supers users through working sessions, attended trainings, and sharing details of testing only the change request (CR) changes. I analyzed defects and assigned to the appropriate developer and coordinated a further understanding of the issue.
  • Supported the super-users during hypercare; triaged, analyzed and managed incident resolution.

Senior SAP BW And ABAP Developer

Attunity Inc, Data Integration And Big Data Management
03.2017 - 09.2018

Responsible for analysis, design, and implementation of new and existing code within the SAP BW, ECC, HCM, EWM, SCM, CRM, and HANA environment supporting the Replicate for SAP and Gold Client applications.

  • Worked closely with product management and professional services to define requirements for the Replicate for SAP Data Warehouse and the Gold Client Applications.
  • Managed design of General Data Protection Gold Client Application Jira (Agile) issue assigned.
  • Design, develop and sustain program interfaces between SAP, other applications, and business partners.
  • Provided on going production support; including custom programming, bug fixes, patches, enhancement requests.
  • Researched and updated all Jira Agile issues

Senior SAP BW Developer / Team Lead

Organization Industry, MassMutual Financial Group IT
07.2007 - 03.2017

Responsible for data modeling as related to BW, design, maintenance, enhancements, modifications, production support, and project-related development of BW components in support of HR, FI, SRM, and custom (legacy systems, SQL database, etc.) non SAP modules. This includes the ability to research and solve technical problems using SAP OSS as well as troubleshooting performance issues.  Data modeling solutions includes SAP delivered objects and customized objects. Coding solutions are developed using ABAP and object orientated programming. Other responsibilities include mentoring, training, development, and production support.


Key Projects:

Technical Lead BW Upgrade 7.0 to 7.3 / BW Upgrade 7.3 to 7.4 / BW HANA Migration

  •  Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.    

Developer of customized COBRA Eligibility implementation

  • Requirements gathering, development and implementation of customized BW solutions to satisfy COBRA Eligibility for agents.
  •  Created functional and technical specs, including Gap analysis and test plans
  • Data was pulled from existing BW DSO into a consolidate COBRA Eligible DSO
  • Complex start and end routines were used to determine if an agent is eligible for COBRA coverage who was involuntarily terminated
  • Open Hub was used to extract eligible agents

 Lead Developer on custom project for our Marketing Division

  • Requirements gathering, development and implementation of customized BW solutions to modernize the marketing capabilities for our Career Agent System to be able to measure level of success by marketing program and campaigns
  • Created functional and technical specs and documentation
  • Developed custom extracts, DSOs, InfoCubes, MultiProviders, InfoSets and Master Data
  • Created Class Modules and ABAP Programs for processes used throughout the project design
  •  Created process chains driven by complex maestro job stream scripts

Technical Lead for HR Enhancements, Projects and Process Improvement Initiatives

  • Support and implement enhancement solutions
  • Cross train colleagues on enhancement work
  •  Enhance end users’ understand of BW reporting by hosting group and individual working session and creating user-friendly documentation.
  • Resolve system issues from “business as usual maintenance” to corporate request for addition functionality.

Developer of customized procurement (SRM) implementation

  • Requirements gathering, development and implementation of BW in the SRM area.
  •  Assisted with go-live validation and support of queries, process chains and master data
  • Performed requirements gathering and documentation
  • Created functional and technical specs
  • Created required DataSources, DTPs, InfoProviders, and Complex Custom End Routines for data consolidation
  •  Created process chains for transaction data loads

Implementation of SAP Learning Solutions (LSO)

  • Enhanced SAP Delivered extractors and objects to support LSO report needs
  •  Created functional and technical specs, including Gap analysis and test plans
  • Created class implementation for CMOD user exit includes as not to create contention with modifying the same user exit
  • Moving/modifying existing code in user exit include and moving into a class/method format.
  • Complex regression testing was required
  • Flatten the org structure (each records has layer 1 – 12 on one record) for both “at time of” and “current” activity dates
  • Pulled in contractor master data from delimited file that was created from by R3 for Information Security

Conversion of 3.5 InfoSpoke to 7.0 Open Hub

  • Performed requirements gathering and documentation for FI InfoSpokes
  •  Created functional and technical specs, including Gap analysis and test plans
  • Converted complex InfoSpoke BADIs to Class Modules that could be called by the Open Hub extraction.
  •  The currency conversion check box did not work
  • Wrote ABAP code to move the source package into a global internal table and converted the currency (this functionality does not currently work in the DTP)
  • Converted a delta InfoSpoke into a full Open Hub
  • Used 2 DSOs 1) Current load 2) Historical Loads to create a suedo delta for the Open Hub extraction from the 1st DSO.
  • Used the program Beyond Compare to compare the InfoSpoke and Open Hub Technology extract results.

Conversion of 3.5 to 7.0 objects

  • Converted 3.5 DataSources to 7.0 DataSources
  •  Converted complex update and transfer rules and start routines to 7.0 transformation (start, end, expert routines) and DTPs.
  • Created process chains to automate loads that are triggered by complex maestro job streams

Automated Engineer

MASS MUTUAL FINANCIAL GROUP
03.2006 - 07.2007

Responsible for creating, maintaining and executed automated test scripts using Quick Test Professional (QTP) software.


Key projects:.

  • Proactively recorded scripts that tested agent facing portal which identified several areas that had not been tested through manual test cases.
  • Create a QTP script that was used to recreate performance automated test scripts.

Developer

SOLUTIONS BY COMPUTER, Rental Management Software Company
07.2005 - 03.2006

As the discipline to create customized reports matured I managed my time between support and new product development.

  • My role in the development area was to create extensive and complicated financial and most commonly used reports for a new windows based product (using a database called Cache and SQL).
  • Key projects:.
  • Report developers for their new windows product development.

System Analyst

SOLUTIONS BY COMPUTER, Rental Management Software Company
06.2002 - 07.2005

Responsible for researching and resolving customer issues, installing the software and hardware necessary to run the rental management software, and training customers on how to use and report off of the system.


I am very proficient in the area of Structured Query Language (SQL) and was responsible for writing, testing and deploying some of the most complicated customer requested reports through the front end reporting tool Crystal Reports. Later support also included training users on how to create their own custom reports.


Key projects:.

  • Installed and stood up multiple installations and upgrades across the country and Canada.
  • Provided support to customer issues.
  • Wrote, tested and deployed complicated customer requested reports using the front end reporting tool Crystal Reports.
  • Trained customers on how to create their own custom reports using SQL commands and/or Crystal Reports.

Education

Masters of Management Information Systems - undefined

Keller Graduate School of Management

Bachelors of Business - Computer Information Systems

Western New England University

Skills

  • BW on HANA / BW4HANA
  • HANA Studio/Eclipse Tools
  • Expertise in writing user exit and customer
  • Expert Knowledge on creation and fixing BI Process chains and jobs
  • Expert Knowledge on writing Start Routine, End Routine and Field Routines
  • Expert Knowledge on Performance Tuning on ABAP Reports and BI routines and extractors
  • Good Knowledge of BW on HANA
  • Good Knowledge of Business Objects
  • Good Knowledge on Business Planning (BPS)
  • Experience in designing/creating/ configuring Info Objects, Info Source, Transfer Structure, Transfer & Update Rules, Info cube, Communication Structure, ODS, Info packages, Scheduling and Job Monitoring
  • Expert knowledge in BW Reporting Authorization (35) & Analysis authorization in 70
  • Expertise in Reports (Classical, Interactive and ALV), Data dictionary objects, BAPI and User exits
  • Providing solutions including designing data models, extractors and data warehouse
  • Experienced in writing customized extractors and developing datasource
  • Expertise in automating job scheduling, using event triggering and process chains
  • Expert in Migration of 35 version BW objects flow to 70
  • Migration experience BW on HANA to BW4HANA
  • Exposure in creating Data Dictionary Objects and and also expertise in Interface programming techniques using BAPI
  • Expertise in performance tuning of select queries and also routine codes and other reports
  • Worked closely with Business users for gathering requirements and developed reports using BI reporting tools BEx Query Designer

Accomplishments

  • Mentor with The Freedom Mentors (domestic violence awareness and healing group)
  • Microsoft Certified Professional (MCP) - May 2003.
  • Committee Member of SAP Center of Expertise at Mass Mutual Financial Group Trainings.

Timeline

First Line Manager / SAP BI/BW HANA Consultant

IBM Corporation
11.2018 - Current

Senior SAP BW And ABAP Developer

Attunity Inc, Data Integration And Big Data Management
03.2017 - 09.2018

Senior SAP BW Developer / Team Lead

Organization Industry, MassMutual Financial Group IT
07.2007 - 03.2017

Automated Engineer

MASS MUTUAL FINANCIAL GROUP
03.2006 - 07.2007

Developer

SOLUTIONS BY COMPUTER, Rental Management Software Company
07.2005 - 03.2006

System Analyst

SOLUTIONS BY COMPUTER, Rental Management Software Company
06.2002 - 07.2005

Masters of Management Information Systems - undefined

Keller Graduate School of Management

Bachelors of Business - Computer Information Systems

Western New England University

Key Courses and Trainings

SAP Training Pool; 9 week training in multiple areas of SAP; ABAP, BASIS, BW, Security.

BC490 ABAP performance tuning

BW305E SAP query performance tuning

BW362 SAP BW on SAP HANA.

DBW73 SAP BW Delta 7.0 to 7.3

JavaScript Road Trip Par1 and Part 2

SAP HANA Query Optimization

IBM Certified First Line Manager Badge

Energy, Environment & Utilities Industry Jump Start Badge

Energy, Environment and Utilities Insights and Solutions (Silver)

IBM Automation Essentials Badge

Enterprise Design Thinker Badge

BW405 SAP BW/4HANA Query Design and Analysis

BW410 SAP BW/4HANA Data Warehousing

BW430 SAP BW/4HANA Data Modeling

BW450 SAP BW/4HANA Data Acquisition

DBW462 SAP BW/4HANA

HA100 SAP HANA Introduction

HA300 SAP HANA 2.0 SPS05 - Modeling

AWS Certified Cloud Practitioner (expires 11 Nov 2026)

Key Courses and Trainings

SAP Training Pool; 9 week training in multiple areas of SAP; ABAP, BASIS, BW, Security.

BC490 ABAP performance tuning

BW305E SAP query performance tuning

BW362 SAP BW on SAP HANA.

DBW73 SAP BW Delta 7.0 to 7.3

JavaScript Road Trip Par1 and Part 2

SAP HANA Query Optimization

IBM Certified First Line Manager Badge

Energy, Environment & Utilities Industry Jump Start Badge

Energy, Environment and Utilities Insights and Solutions (Silver)

IBM Automation Essentials Badge

Enterprise Design Thinker Badge

BW405 SAP BW/4HANA Query Design and Analysis

BW410 SAP BW/4HANA Data Warehousing

BW430 SAP BW/4HANA Data Modeling

BW450 SAP BW/4HANA Data Acquisition

DBW462 SAP BW/4HANA

HA100 SAP HANA Introduction

HA300 SAP HANA 2.0 SPS05 - Modeling

AWS Certified Cloud Practitioner (expires 11 Nov 2026)

Dawnelle Bolden-Brooks