Skills Summary
Strong communication and relationship ASAP and Ascendant Methodology
skills
Strong leadership and management skills Project Planning (Microsoft Project)
Detail oriented and thorough problem Extremely flexible and a team player
solver
Extensive SAP Business Information Project Management of Business Objects
Warehouse (BW) experience (BOBJ) Implementations
Experience
Food & Beverage Company - Atlanta, GA March 31, 2011 - June 24, 2011
Business Intelligence Delivery Manager
. Project Management and leadership in the design of business intelligence
& analytics technology projects through the SDLC process.
. Management of the design of multiple projects in North America (including
Time, Resources, Scope) to support implementation of business
intelligence reporting & analytics capabilities for the business
portfolio.
. Upgrade of BOBJ 3.1 to BOBJ 4.0 and implementation of MOBi application
for PDA devices
. Financial Data Warehouse, combining legacy data for two companies in
order to provide consolidated P&L reporting (BI 7 back-end, BOBJ 4.0
Front-End)
. Consolidated HR Data Warehouse, combining legacy data for two
companies in order to enable consolidated reporting (BI 7 back-end,
BOBJ 4.0 Front-End)
. Communication with all levels of management.
Global Chemical Company -Atlanta, GA July 11, 2005 - March 25,
2011
Global SAP BI & Development Manager
BW 3.5 Implementation/Support & Development Manager for SAP Team
Management Responsibilities
. Management of all SAP BI (BW, BCS, & Business Objects (BOBJ)) initiatives
and resources
. Resource recruiting, mentoring, performance reviews and appraisals
. BI tool evaluation, vendor negotiations, and selection
. Project management of SAP BW 3.5 to BI 7 upgrade
. Implementation management of SAP Business Objects 3.1 (Crystal, Xcelsius,
and Webi)
. Development Manager - management of on-shore and off-shore ABAP
development
. Responsible for the coordination of BASIS activities executed by third
party hosting provider
. Project planning and tracking
Hands-on Technical Responsibilities
. Gathering and documenting BI requirements from the business (ASAP &
Ascendant Methodology)
. Evaluation of standard delivered BI Content, determining gaps that lead
to custom work
. Activation of standard BI Content, to include Datasources, ODS objects,
InfoCubes, and Queries
. Examples areas where content met the requirement: QM, PP, SD, MM-INV, FI-
GL, CCA
. Enhanced business content in some areas using transformations in transfer
rules and update rules
. Development of custom BW configuration when BI Content was not available
. Example areas where custom development was needed: APO, Sales Forecast &
Business Plan, Non SAP data (COPA, FI-GL, CCA), Tariff Management
. Solely responsible for the BW configuration needed for APO Demand
Planning Project
. Development of custom Datasources from SAP ERP tables and/or SAP queries
. Creation of InfoPackages, InfoPackage Groups and Process Chains for data
loads and monitoring
Global Chemical Company - Atlanta, GA July 11, 2005 - March 25,
2011
Global SAP BI & Development Manager Continued...
. High frequency data load requests led to developing a coordinated data
load schedule
. Responsible for troubleshooting all data load failures for both SAP and
non SAP data
. BW BEx Query & BW BEx Browser configuration for every applicable area
within BW/BI landscape
. Queries and workbooks range from simple to very complex (with multiple
formulas, conditions and alerts) - one example of complex included over
60 key figure formulas
. Data reconciliation between newly created BW queries and respective
source system
. Unit, Integration, and User Acceptance Testing (developed and executed
plans)
. BW Security Development (at the InfoCube Level for Super Users and Casual
Users)
. End User Training & Production Support (helpdesk ticket resolution)
. SAP OSS Research for problem solving resolutions
Global Pharmaceuticals Company - Atlanta, GA January 13, 2003 - July 5,
2005
Senior IT Analyst (BW Team Lead)
BW 3.0B Implementation & Support
. BW team lead on global SAP project (BW 3.5)
. BW representative on Global Supply Chain Alignment project (utilizing SAP
R/3, BW, SCM 4.0)
. BW data model review and enhancements
. BW data loads from external systems for Sales & Marketing Data
. Master data volumes: 8M records per Sales Team (5 teams)
. Transactional volumes: 3.5M records a month
. BW data loads from SAP R/3 for Cost Center Accounting (CCA) data
. BW data loads from external Travel & Expense Management System (CONCUR)
. BW report development (BEx Analyzer, BW Web Reports published to SAP
Enterprise Portals
. BW performance monitoring and tuning (data loads and reporting
performance improvements)
. Extensive use of Aggregates to improve reporting performance
Global Insurance Company - Columbus, GA September 2002 - January 10,
2003
BW Team Lead
BW 2.1C Implementation: BW Consultant Team Lead (two consultants, three
client team members)
. Conducted weekly BW team status meetings
. BW report development management and tracking within the following SAP
R/3 areas (Special Ledger, Financial Accounting, Cost Center Accounting,
and Profit Center Accounting)
. Tracked report development in MS Project, then in Access database
. BW report troubleshooting (130 reports, 240 users)
. Issues tracking and resolution (created Access database to track
development issues)
. BW architecture analysis and recommendations for improvements
. BW development troubleshooting (data loads, scheduling, transports,
security, and OSS correspondence)
. Transport maintenance and organization
Paper & Forest Products Company - Atlanta, GA April 2002 - September
2002
Consultant
. Requirements gathering for the centralization of planning and scheduling
reports within SAP
. Test plan creation and training script documentation
. Project plan creation and maintenance for data warehouse project
Information Technology Consulting Firm - Atlanta, GA February 2001 - April
2002
Consultant
Manufacturing/Machinery Company - Peoria, IL
BW 2.1C - APO 3.0 Implementation
. Led eleven member team consisting of both client and consulting resources
. Responsible for preparation and facilitation of functional requirements
gathering workshops as part of global Blueprint
. Developed and presented BW portion of Blueprint for Executive Steering
Committee approval
. Developed and managed full life cycle project plan utilizing Microsoft
Project
. Responsible for configuration necessary to extract and load sales,
shipments, inventory, and order (SSIO) data into Business Warehouse from
legacy systems
. Configured Business Warehouse to consolidate and subsequently feed SSIO
data to SAP's Advance Planner & Optimizer (APO) for demand forecasting
process
. Configured custom DataSources and InfoSources for six transactional
legacy systems
. Created multiple DataSources and InfoSource for master data feeds
. Created custom transfer rules and update rules where necessary for
transformation and cleansing
. Configured multi-level ODS structure for data loads and consolidation
(eleven ODS' required)
. Created nine custom InfoCubes
. Created four MultiCubes for reporting purposes (combining actual and
plan data)
. Created transactional and master data export DataSources necessary to
feed APO
. Created custom variables for reporting purposes
. Designed and created Business Warehouse reports for financial accounting
and forecasting departments
. Developed and managed execution of unit, cycle, integration and
regression testing plans
. Designed and assisted with configuration of security roles and
authorizations for over 350 users
. Coordinated and approved migration of all configuration to test and
production environments
. Assisted with and approved training material design, development, and
delivery
Management Consulting Firm - Alanta, GA July 2000 - February
2001
Consultant
Consumer Goods Company - Boston, MA
APO - BW 2.0B Implementation
. Responsible for currency translation configuration for thirteen countries
. Assisted with the development and execution of integration testing and
cut-over plans
Information Technology Consulting Firm - Atlanta, GA June 1998 - June 2000
Associate Consultant/Consultant
Telecommunications Company - Fairfax, VA
SAP - BW Implementation
. Conducted reporting requirements gathering workshops
. Developed and maintained BW project plan, using ASAP methodology
. Maintained InfoCubes for the following areas: Finance/General Ledger
(FI/GL), Cost Center Accounting (CCA), and Profit Center Accounting (PCA)
. Completed the delivery of 25 custom reports
. Developed custom BW security profiles necessary for 70 users
. Conducted end-user training and provided post implementation support
Information Technology Consulting Firm - Atlanta, GA June 1998 - June 2000
Associate Consultant/Consultant Continued...
Telecommunications Company - Fairfax, VA
SAP End-user Training Team Member
. Developed and maintained training project plan and training schedule
. Developed training materials for the following areas: Materials
Management (MM) - Purchasing, Financial Accounting/Controlling (FI/CO),
Asset Management, and Project Systems
. Assisted client with instructor lead training classes for approximately
100 users
Education
Auburn University, Auburn, AL March 1998
Masters in Management Information Systems
Member of Phi Kappa Phi Honor Society
Birmingham-Southern College, Birmingham, AL January 1996
BS Finance and Management