SAP BW Consultant Resume, Profile and CV's

EXPERIENCE SUMMARY:

 

Name of Consultant	Douglas Ayers
Skills – Architect Level -       Team Lead -       Developer	Requirements Gathering/Definition SAP BW 3.5, 7.0 / SAP Business Objects 3.5, 4.0 Business Objects Dashboard Universes, Web Intelligence (Webi Reports) xCelsius Dashboards Crystal Reports BW Query, Bex, WAD, SAP Authorizations, ABAP programming ETL Custom Data Extraction Real Time Embedded Software (Automotive Engine) Unix Admin I follow PMP Processes, SAP ASAP, Kimbal, Waterfall Process and my own best practices I have created along the way
SAP Projects	14
Total Software Projects	144
Software Development Cycles	Over 2500
Years Software Experience	34 years software programming/development experience
Years SAP Experience	8
Global Project Experience	Yes (128 global projects)
Project Management Experience	Yes
Present Location	Huntsville Alabama (I travel 100%)
Visa Status	U.S. Citizen / Japan Work Visa
Security Clearance Status	Active (PPT)
Availability	Immediate
Rate + Expenses	Negotiable
Relocation	Willing to Travel 100 % or Relocate depending on duration
Industries worked with	Medical Device Maker, Manufacturing, Food, Retail, Telecom, U.S. Military, U.S. Govt., Public Sector, PC Design and Manufacturing
Quality Systems Compliances	FDA, MDD, AIMDD, CMDR, MHLW, ISO-9000, DQS
Languages	English – Native Japanese – Intermediate
Formal Education	Master of Business Administration (MBA), Bachelor of Science, Computer Engineering

 

EXPERIENCE DETAILS:

 

 

1/2013 – 5/2013             Boston Scientific, Boston MA ( Corp-to-Corp – SAP BW Consulting, Inc.

                                        [2 contract renewals])

                                        Position:     SAP BW / BI SOFTWARE TEST LEAD / Coordinator

Customer:   Boston Scientific

Project:       BW Ops Remediation Project

 

Client Name	Boston Scientific, Boston Massachusetts
Functional Role	Formal Software Testing Train up on FDA, MDD, AIMDD, CMDR, MHLW Compliance Requirements Develop Formal Software Test Scripts that are CFR Title 21 Part 11 Regulations Compliant. Developed Reusable Test Script Templates Execute Software Test Scripts Review Test Scripts of Fellow Testers Report defects found during formal testing
Industry	Medical Device Manufacturing
Roles	Formal Test Script Developer Formal Test Script Execution Problem Reporting
Metrics (KPI’s)	Developed 3 Score Metrics to assess quality of development
SAP Sub-Projects	none
Team Size	2 testers plus Manager, 1 developer
Start Date	1/2013
End Date	5/2013
Location 1	Boston Massachusetts
Location 2	India
Security Clearance Required	No
SAP Tools	SAP BW 731, BEx Query Designer, BEx Analyzer, Microsoft Word, FDA Compliance Training to CFR 21 Part 11 regulations

 

 

Responsibility: Information Systems (IS) Group

 

• Consult with the Manager of Information Systems Group to understand Testing Requirement
• Received required internal FDA compliance training in CFR 21 Part 11 Regulations Compliance
• Reviewed Past Project Testing Materials for ideas
• Reviewed Customer Requirements Documentation and created Testing Trace Matrix to map test cases to individual requirements
• Received Log on Id’s to customers SAP BW Systems version 731
• Discovered the BW Developer had no system design documentation
• Reverse engineered existing SAP BW System landscape and used VISIO to create a system wide Architecture Drawing detailed enough to reveal development errors and issues. The drawing was said to be the “Best Thing we have ever seen around here”. The drawing came in handy later on when the developer was trying to solve critical design issues.
• Created a reusable format Test Script Template that was FDA Regulation CFR Title 21 Part 11 compliant. Some individual test scripts had over 200 test steps. 100+ test steps was average.
• Developed over 30 Test Scripts covering 3 functional business areas: Labor Efficiency, Scrap and Yield, Inventory.
• Conducted numerous informal passes of each Test Script. Bugs and Issues found with the development was reported to the IS Manager and decisions were made as to what priority the developer should give to fixing each issue found through my testing.
• Continued to work with the Manager and BW Developer and Co-Tester to continuously refine the triangle of Requirements, Development and Test Scripts through feedback.
• A Significant Improvement in SAP BW System quality was achieved through use of my formal test scripts.
• Due to the level or issues found, had to be detail oriented in the most meticulous way.
• Discovered other benefits of using a formal test script to evaluate Quality on multiple dimensions a person might be interested in measuring. Test Scripts are useful objective tools.
• Finished the project after several Formal Rounds of Testing and all test scripts PASSED with no issues found.
• Critical to the success of formal testing was the fact I was an experienced BW Developer writing the test scripts to check the work of a junior and offshore BW Developer.

 

Other Ways I helped the Customer: SAP BW Design/Development, Unix Scripting, SQL, ABAP programming

 

• Used my past SAP BW Developer and Software Engineering Experience to help the customer overcome several technical obstacles beyond my tester role.
• Customer was stuck on how to interface the BW system with the source system data. Recommended a Direct Connection. This was rejected by the source system owner. So then provided my Unix Scripting Expertise to advise customer on how an existing Unix Script was functioning and what customer would need to do to modify their unix script to pull data from the source system for this particular project.
• Used my knowledge of SQL programming and ABAP programming to read some 10 year old software routines and to explain to the customer and BW Developer what the routines were doing. A typical question is “How is this report generating this data”? So I would read the software, map it out, and then explain to the customer what it was doing. This helped overcome several technical points.
• In BEx Query, there were several Logic Statements (AND, OR) that the developer did not understand and could not develop. So used my software engineering experience to point the problem out to the developer and second to design a solution in Query Designer for the developer that would actually implement the required Logic. Later on in testing, added Tests for the correct implementation of the logic.
• It’s quite possible that without me stepping in to offer advise outside the tester role that the project could have stalled or failed at least twice. I can say that the end users would not have been happy with the output they would have received otherwise.

 

4/2012 – 7/2012             SAP BW Consulting, Freetown IN [Internal Project]

                                    Position:     Project Manager

Customer:   SAP BW Consulting, Inc

Project:       BTIMS Project (Business Telephone, Internet, Mobile Apps)

 

Client Name	SAP BW Consulting, Inc
Functional Role	Project Manager Train up on PMP processes Conduct a formal project by the book
Industry	Telephony, Internet, Mobile App Development
Roles	Project Manager Responsible for Delivery
SAP Sub-Projects	none
Team Size	1
Start Date	4/2012
End Date	7/2012
Location 1	Huntsville Alabama
Location 2	none
Security Clearance Required	No
Tools	Project Management PMP processes

 

 

Responsibility: Project Manager, Internal Projects

 

• Identify problems with existing Consulting Kit solution
• Wrote Project Charter and pitched the project to the company President for approval.
• Project was approved with additional constraints added.
• Identified all stakeholders.
• Gathered Requirements from all Stakeholders
• Wrote the Scope Management Plan
• Performed Market Research from all National Telecom Providers
• Created a Work Breakdown Structure, WBS Dictionary and Activity List
• Created a Vendor Evaluation sheet based on the WBS Structure.
• Several rounds of visits to all Telecom providers in local area. Had each vendor to give me product, system and service demonstrations. Answer questions.
• Evaluated Vendors identifying the strengths and weaknesses of each vendor based on how close to and how many of each of our requirements they each could meet.
• Discussed findings with stakeholders.
• Scored each vendor to come up with an objective evaluation of each.
• Based on vendor data, put a time and cost estimate to the WBS.
• Used Critical Path methods of forward and backward pass to develop a budget and timeline for the project.
• Pitched the budget to the President for formal project approval and financial commitment.
• Received Budget Approval for the life of the 2 year vendor contract as well as signature authority to sign contracts with vendors.
• Selected the best vendor. No vendor could meet 100% of our stakeholder requirements. However only 1 vendor could meet all but 1 of our requirements related to signal. It was later found that we actually could get a signal in this particular location. So 100% of our requirements were actually met.
• Signed Contracts with vendors.
• Purchased and configured Smart Phones, Hot Spots and iPads.
• Set up Management Dashboards on Vendor websites.
• Set up Auto-billing
• Registered Devices in asset tracking system and mailed each device to the assigned user.
• To date, I have heard no complaints on our service. A highly successful project.

 

 

3/2011 – 3/2012             Lenovo, Raleigh NC ( Corp-to-Corp – SAP BW Consulting, Inc. [4 contract renewals])

                                    Position:     SAP BW / BI & SAP Business Objects Consultant

Customer:   Lenovo (former IBM PC division)

Project:       Olympus Project – Webi, xCelsius Business Warehouse requirements

 

Client Name	Lenovo, Raleigh North Carolina (Former IBM PC division)
Functional Role	Customer Facing Requirements Gathering and Documentation Customer Education of Software Project Management Customer Education of Software Design Methodology Customer Education of Requirements Definitions Customer Education of Waterfall Process Development  Methodology Advocate for the Customer when developers said something was impossible Assist customer with Requirements definitions of: Management Scorecards, Management Dashboards, Webi Reports, xCelsius Dashboards, BEx Queries, HANA education
Industry	IS- Retail; PC Laptop, Desktop, Workstation Makers, Customer Service Center, New Product Development Group, Mature Market Sales Organization.
Roles	Customer Requirements Interface Handle all BW requirements related questions for Service Group, Product Group, Mature Group and communicate those to China development team
Metrics (KPI’s)	Several Thousand
SAP Sub-Projects	Olympus Release, Wave 1, Wave 2, Victory Release
Team Size	Over 100 BW developers in China
Start Date	3/2011
End Date	3/2012
Location 1	Raleigh North Carolina
Location 2	Beijing China
Security Clearance Required	No
SAP Tools	SAP BW 3.5 & 7.0, Web Intelligence 3.5 & 4.0, SAP CRM, SAP Plant Maintenance, HANA

 

 

Responsibility #1: Service Group Business Unit ( 7 business processes - Call Center, Depot & Parts, Field Service, Logistics, Service Marketing, E2E)

 

• Assist Department Head in understanding the capabilities and limitations of SAP Business Warehouse, xCelsius and Web Intelligence
• Assist customer in developing departmental reporting requirements
• Assist customer in the requirements gathering process, documenting those requirements and discussing BU requirements one-on-one with the China development team members
• Assist customer in formulating and developing test scripts for the delivered software
• Assist customer in hand-on testing of delivered software (SAP Webi Reports)
• Tested software deliveries for conformance to requirements and for bugs and errors
• Assist customer in trouble shooting errors and differences between source data in SAP CRM system and SAP BW system and SAP Webi Reports.
• Assist customer in logging bugs and defects in Mercury quality system for correction.
• Performed Cross BU alignment and resolution on interdepartmental software issues

 

Responsibility #2: Product Group Business Unit (PC, Workstations, Servers, Peripherals )

 

• Assist customer in understanding the capabilities and limitations of SAP Business Warehouse, xCelsius and Web Intelligence
• Performed Cross BU alignment and resolution on interdepartmental software issues
• Assist customer in developing departmental reporting requirements
• Attended weekly and daily conference calls with Beijing Development team to resolve team questions and to clarify software requirements
• Tested software deliveries for conformance to requirements and for bugs and errors
• Created training Powerpoints and gave training webinars on SAP Business Objects
• Customer wanted to know if it was possible to collect sales data on each unit sold rather than being summarized in bulk at the country level? I advised customer it was quite possible to collect transactional level sales data on each unit sold using SAP BW. Assisted customer to develop a list of 75 attributes and features that the end customer can see and are aware of such as hard drive size, color, etc. Used my management consulting hat to assist customer to create requirement specifications for the sale-by-sale attributes reports providing drill down and summary level reporting on specific products or product families. This was new information never before available to this customer. This allowed the customer to know what products were hot sellers and in which markets and what products to drop from the product line or which hot selling products to offer in new markets. This was information and a capability never before possible to this customer.
• Developed some best practices for the best way to create xCelsius Dashboards
• Developed some best practices for how to convert dashboard formats between xCelsius and Webi reports
• Developed a best practice for Requirements Gathering and Specification for xCelsius Dashboards and Webi Reports. My techniques reduced the requirements gathering process from typically a 2 month process with this customer to a 3 week process (a 5 week reduction).

 

Responsibility #3: Mature Group Business Unit (i.e. North America, Canada)

• Performed Cross BU alignment and resolution on interdepartmental software issues
• Read software specifications and Created Test Director test plans for upcoming Mature Group software release
• Advised customer what was possible or not possible for SAP BW & Business Objects

 

Responsibility #4: RSD group

• Attend daily and weekly conference calls
• Perform Cross BU alignment to resolve issues
• Created training material
• Trained co-workers
• Created internal Microsoft Access Cross BU KPI Database. The Customer’s Internal development team in China had actually implemented over 42,000 different KPI’s. Many of them were repeats of the same thing with slight variations in definitions. The question is how do you get a handle on 42,000 KPI’s for 1 company? I inventoried all the requirements documentation, all the Webi Universes, all the Webi Reports, all the embedded formulas within the delivered Webi Reports and I created an Access Database called the Cross BU KPI Database. I also used 1 intern to help me gather this information. The database allows people to search for a particular KPI, identify all the different variations of that KPI, identify all the different reports each KPI was located in, identify which BU owned that report as well as gave end users the ability to update descriptions for any given KPI. The database allowed me to upload information in bulk or 1 KPI at a time. The database also allowed Developers to identify which reports would be affected by changes to any particular KPI.
• This customer did not have a project folder which is a basic element of any project. Because of this the customer was suffering from information hiding and had a terrible time keeping all team members updated and almost no one had the latest revision of any documentation. So I made a preliminary list of folders I recommend the customer should have in a project folder. I also asked every team member what folders they though they needed or would like to see. I then organized the folder list into logical software releases. I then identified a globally visible publicly available internal database. I then asked my intern to create all the different project folders on my list in the order as I had it. The next task was to load a critical mass of project documentation into the project folder. This is still ongoing even though I am not there anymore.

 

7/2011 – 9/2011             Enterprise Horizon Consulting Group ( Corp-to-Corp – SAP BW Consulting, Inc.)

                                    Position:     SAP BI/BW Reporting Education

Customer:   Florida Army National Guard

Project:       GFEBS – General Funds Enterprise Business Systems Go-Live Project

 

Client Name	Florida Army National Guard
Product	BI Reporting – End user education and training
Industry	U.S. Military (ARMY), Public Sector
Roles	SAP BI Reporting Training
Metrics	none
SAP Sub-Projects	none
Team Size	2
Start Date	7/2011
End Date	9/2011
Location 1	St. Augustine Florida
Security Clearance Required	Yes, PPT

 

The Florida Army National Guard will go live with GFEBS (gee-febs) September 2011. The users are all new SAP users and they wanted me to give them training on how to work with the BI reports.

 

Responsibility #1: SAP Business Warehouse Intelligence Reporting Training

• Developed user requested presentation / Training materials to help the end users to get up to speed as quickly as possible with the BI reports.
• Presented the end user training in a class room setting.
• Worked one-on-one with end users to get them up to speed on their BI reports
• Developed a “Cheat Sheet” of the various 200 or so BI reports delivered for GFEBS. The cheat sheet has quick links to the actual report as well as a quick synopsis of each report.
• BI Reporting Cheat Sheet is useful as a quick desk reference guide to help customer locate the right report quickly and launch it without having to spend time sorting through the GFEBS to find a suitable BI Report which could take a long time.

 

 

4/2010 – 10/2010           TNT-Technologies, Inc. Atlanta Georgia ( Corp-to-Corp – SAP BW Consulting, Inc.)

                                    Position:     SAP BW / BI & SAP Business Objects Consultant

Customer:   Grace Kennedy, Jamaica

Project:       Business Objects – Management Dashboard Project

 

Client Name	Grace Kennedy Jamaica
Product	Business Objects – Management Dashboard
Industry	IS- Retail; Grocery Food Retail, Mfg., Warehouse Distribution
Roles	Project Lead Design Standards – Design lead SAP Business Warehouse 3.5 / Business Intelligence 7.0 – Design Lead Business Objects – Design Lead Web Intelligence – Design Lead Crystal Reports – Design Lead BW BEx Query – Design Lead, ABAP – Design Lead ETL Custom Data Extraction – Design Lead Inventory Business Content – Lead
Metrics	Sales, Inventory, MRP Control
SAP Sub-Projects	3
Team Size	5
Start Date	4/2010
End Date	10/2010
Location 1	Huntsville Alabama
Location 2	Remote
Security Clearance Required	no

 

Grace Kennedy Jamaica, is the largest grocery store chain in Jamaica with a multi-national distribution chain. Customer needed a Business Objects Management Dashboard to automate and cut cost of reporting day-to-day operating activity and this is what my team proposed, designed, developed and successfully delivered.

 

A Business Intelligence - Business Objects management dashboard requires understanding of the customer’s business, the metrics the customer uses to manage their business and the customer’s ERP systems. These 3 areas of understanding are combined in a graphic form and presented to management in semi-real time using Business Objects, Live Office, Crystal Reports, BW BEx Query and a BW/BI data warehouse.

 

Responsibility #1: SAP Business Warehouse Intelligence / Business Objects Dashboard (Project Manager / Lead).

• Got customer requirements, designed initial Business Warehouse solution, Business Objects dashboard, did final R/3 to BOBJ dashboard data validation.
• Set standards for design, naming conventions, and made final decisions considering the alternatives.
• When junior team members did not know how to do something, I taught them how, then monitored them while they built the BW 3.5 back-end objects, ETL/DTL custom extractors, ODS’, Cubes, Multi-providers and Process Chains for SD, MM, Inventory and MRP Management dashboards.
• Led weekly team meeting with customer and client.
• Tracked, managed implementation schedule with customers.

 

Responsibility #2: Business Objects Dashboard (Design / Developer / Lead)

• Dashboard layout and design, graphic chart selection.
• Data selection controls
• Chart selection controls
• Set up parameter passing
• Drove requirements for Crystal Report feeds.
• Personally built Crystal Reports to pass data from BW/BI BEx Query to xCelsius.
• Pulled R/3 data, conducted Dashboard Data validation
• Ensured that the SAP Integration Kit with MDX driver was installed correctly
• Ensured the entire tool chain was up and running properly and working.

 

Responsibility #3: Crystal Reports (Design / Developer / Lead)

• Converted customer requirements into BI / BOBJ dashboard prototypes.
• Converted BOBJ dashboard requirements into Crystal Reports.
• Designed, built and tested Crystal Reports.
• Validated Crystal Reports against BW / BI data
• Validated BW / BI data against R/3 data to ensure data accuracy.
• Drove requirements for SAP BW BEx Query designer.
• Created, Built, Tested, Debugged SAP BW Queries

 

Responsibility #4: SAP BW BEx Query designer (Design / Developer / Lead)

• Converted Crystal Reports requirements into SAP BW queries.
• Designed, built and tested BW queries.
• Validated BW / BW BEx Query results against R/3 to ensure data accuracy.

 

Responsibility #5: SAP BW data warehouse (Design / Developer / Lead)

• Installed Business Content for: Sales, Inventory, MRP.
• Learned from customer how to use the R/3 tools for Sales, Inventory Control and MRP.
• Continued development of SAP BW data warehouse for Inventory and MRP Controller.
• Developed naming strategies Inventory and MRP controller objects, BW Queries, Crystal Reports and Business Objects.
• Built BW Objects, Tables, Cubes, DataSources, and Process Chains.
• Wrote Custom Datasource Extractors, Update rules and Transfer Rules using ABAP
• Froze system during weekend, loaded Inventory data (took 10 hours), loaded historical Inventory data using flat files which I created from R/3 downloads.

 

9/2009 – 12/2009           TNT-Technologies, Inc. Atlanta Georgia ( via Corp-to-Corp - SAP BW Consulting, Inc.)

      Position:     SAP BW Consultant

Customer:  Grace Kennedy, Jamaica

Project:      Business Intelligence - Business Objects Management Dashboard Project

 

Client Name	Grace Kennedy Jamaica
Product	Business Objects - Management Dashboard
Industry	IS- Retail; Grocery Food Retail, Mfg., Warehouse Distribution
Roles	SAP BW 3.5 – Lead SAP BI 7.0 - Lead BI BEx Query – Design Lead / Trainer ABAP – Lead ETL/DTL Custom Data Extraction – Lead Sales Business Content – Lead Basis - Support
Metrics	Sales
SAP Sub-Projects	1
Team Size	3
Start Date	9/2009
End Date	12/2009
Location 1	Huntsville Alabama
Location 2	Remote
Security Clearance Required	no

 

 

Responsibility #1: Develop SAP BW Data Warehouse for IS-Retail.

• Developed initial SAP BW 3.5 Sales Data Warehouse
• Developed system wide object naming strategy.
• Built all BW Objects, Tables, Cubes, DataSources, InfoPackages and Process Chains
• Wrote custom ABAP functions for populating fields in custom DataSources
• Loaded data into SAP BW / BI data warehouse

 

Responsibility #2: Basis support .

Their Basis person was weak and not up to the job. To save the project, I spent 3 weeks in October troubleshooting BW problems that were BASIS or Unix issues. So after troubleshooting the problems and determining the BASIS fix myself, I informed the BASIS person step-by-step how to fix the problems. This was not my job but if I did not do that, the project would have failed in October. Instead I was able to finish the project successfully and make happy customers.

• Troubleshoot and fix EDI Partner issues
• Troubleshoot and fix IDOC message passing problems
• Teach Basis person how to do Transports.

 

 

7/27/2009 – 8/14/2009 (ORNL) Oak Ridge National Laboratory, Oak Ridge Tennessee

                                       (www.sapbwconsulting.com)

 

                                    Position:          SAP BW 3.5 & BI 7.0 Consultant at ORNL

Project:            Special Projects

Security Clearance:      Active Government Security Clearance

 

Client Name	Oak Ridge National Laboratory
Product 1	SAP BI 7.0 Report Conversion
Product 2	Site Visitor Tracking and Reporting
Product 3	SAP BW/FI Report Demo Project
Product 4	SAP BW 3.5 and SAP BW 7.0 Training
Industry	National Security - Nuclear
Roles	SAP BW 3.5 to SAP BI 7.0 Report Conversion BW BEx Query – Lead ABAP – Lead ETL/DTL Custom Data Extraction – Lead
Metrics	Report Conversion, Visitor Tracking
SAP Sub-Projects	1
Team Size	3
Start Date	7/27/2009
End Date	8/14/2009
Location 1	Oak Ridge, Tennessee
Security Clearance Required	Yes

 

 

Responsibility #1:     Report Conversion

• Converted SAP BW 3.5 Reports to SAP BI 7.0 Reports

 

Responsibility #2:     Visitor Tracking and Reporting

• Reporting for PAS (Visitor Management System)
  • Developed a reporting strategy that involved doing math and calculations on dates
  • Developed a custom ABAP extract function to pull 189 different tracking dates from the source system and assigned these dates to both Key Figures and Characteristics
  • Built Characteristics, Key Figures, DSO’s, InfoSets, Multiproviders, and Queries
  • Programmed Report Designer 7.0, using mathematical operators (not a normal capability).
  • Developed several end-user reports based around these dates

 

Responsibility #3:     SAP BW – FI/CO Report Demo Project

• BI/BW Demo for Core Finance
  • Architected, Implemented and Presented a BW reporting solution for Core Finance
  • Extracted data from home built financial reporting system
  • Developed a BW FI data warehouse for the Demo
  • Developed BI 7.0 Reports as a Demonstration Project for the ORNL Finance team.

 

Responsibility #4:     SAP BW Training

• Gave one-on-one SAP BW Training to ORNL Staff
• Got them up to speed on how to write their own BW / BI Queries on BEx.

 

 

9/24/2008 – 4/17/2009 (NASA) Oakwood University Huntsville Alabama (www.oakwood.edu)

 

                                    Position:          SAP BW Consultant

Project:            NASA Enterprise Application Competency Center NEACC (Core Financial)

Security Clearance:      Active

 

Client Name	NASA
Product 1	US Government Travel Manager
Product 2	FEDTraveler.com
Product 3	NASA Core Financial SAP BW Data Warehouse Maintenance
Product 4	Agency Wide Functional And Technical Data Model
Industry	National Security – Nuclear
Roles	SAP BW 3.5 & SAP BW 7.0 Report Development Problem Investigation and Fix Reverse Engineer Legacy System Data Model Design / Development
Metrics	Finance
Team Size	178
Start Date	9/24/2008
End Date	4/17/2009
Location 1	Huntsville Alabama
Security Clearance Required	Yes

 

 

Responsibilities:     SAP BW 3.5 & 7.0 Consultant at NASA

• Active Government Security Clearance
• US Government Travel Manager
  • Investigated and fixed end user reporting complaints
  • FedTraveler.com
    • Investigated and fixed end user reporting complaints
    • Reverse engineered the current system, recommended multiple design improvements
    • Developed and Presented a complete end-to-end integrated design solution for FedTraveler.com
  • NASA Core Financial SAP BW Data Warehouse
    • I supported SAP BW Reporting and Issue resolution for the following Core Financial areas:

-    Accounts Payable

-    Accounts Receivable

• Historical Reimbursable Reports

-    Budget Execution

• Budget Document Detail
• Funds Distribution
• Plan vs Actual
• PY Budget Structure
• Cost Management

-    Cost Management

• Full Cost
• Contractor Reported Cost
• Cost Over Obligations/Downward Adjustments
• Cost Pool Reconciliation
• Historical Labor Reports

-    General Ledger

-    Official Labor

-    Purchasing

-    Travel

-    Standard Management Queries & Reports

• SAP BW Data Model
  • Reverse Engineered NASA’s SAP BW Core Financial Legacy System.
  • Analyzed and Drew in minute detail NASA’s SAP BW Data Model and associated ABAP software.
  • Delivered NASA’s first and only Agency Wide Technical and Functional Data Model Drawings.
  • My Data Model Drawings have had many positive effects:

-    Reduced End User complaint investigation response time significantly; typically from 1 week to a few hours.

-    Provided all other SAP BW developers with a clear view, for the first time, of the complete SAP BW Architecture which had been developed ad-hoc over the years.

-    Provided a blueprint for NASA’s SAP BW Data Warehouse upgrade project

-    Indicated where efficiency improvements can be made.

-    Reduced SAP BW development time by several months resulting in customer savings.

 

7/9/2007 – 5/30/2008      (U.S. Navy) SAIC San Diego (www.saic.com)

 

                                    Position:          Sr. SAP BW PM

Project:            Navy ERP Project

 

Client Name	U.S. Navy
Product 1	SAP BW Data Validation Project Manager
Product 2	SAP PS (Project Systems) Data Extraction
Product 3	Legacy System SAP BW Production Support
Product 4	SAP BW Trainer
Industry	Military
Roles	SAP BW 3.5 to SAP BW 7.0 Report Conversion BW / BI BEx Query – Lead ABAP – Lead ETL Custom Data Extraction – Lead APD: Analysis Process Designer – Expert Level
Metrics	AM: Asset Management; CO: Controlling; FI: Finance; FM: Funds Management; GL: General Ledger; MM: Materials Management (PO, PR); PS: Project Systems; SD: Sales and Distribution; TM: Travel Management; WFM: Work Force Management
SAP Sub-Projects	4
Team Size	7
Start Date	7/9/2007
End Date	5/30/2008
Location 1	San Diego, California
Security Clearance Required	Yes

 

Responsibility #1:     SAP BW Data Validation PROJECT MANAGER

 

• Data Migration Validation,
• Built Migration Extract Files to keep the U.S. Navy’s San Diego SAP BW Legacy Production System running and functional.
• Led a team of 7 BW consultants responsible for testing every record of every field of every file from every Navy base (5) involved in the Navy ERP common system migration project, approximately 10,000 data objects.
• Developed BW processes which achieved a high degree of standardization, repeatability and scalability which was important for this project and a significant level of data quality and customer satisfaction.
• Developed BW, APD and ABAP data quality assurance processes that assure 100% data quality, a key military specification.
  • Navy expressed deep appreciation for the results achieved
  •  As part of my BW Data Validation Project Manager role, I wrote 4 white papers:
    • BW Data Validation Architecture
    • BW Naming Standards
    • BW Data Validation Process Chain Architecture
    • BW Data Validation Automation
  • Developed BW Architecture and Naming Standards for: Scalability, Traceability, Audibility, Self-Managing, Self-Documenting, and Simplicity
    • Designed BW Architecture Design which can scale to any dimension (Vertically or Horizontally) and is currently scaled to 5 Navy Bases, 11 functional areas, over ten-thousand data objects, 310 APD data validation models and approximately 108 process chains and is infinitely expandable. 
  • I designed and built SAP BW back-ends & front-end queries for the following 10 functional areas:
    • AM: Asset Management (AM)
    • CO: Controlling (CO)
    • FI:   Finance (FI)
    • FM: Funds Management (FM)
    • GL:  General Ledger (GL)
    • MM: Materials Management (MM)
    • PS:  Process Systems (PS)
    • SD:  Sales and Distribution (SD)
    • TM:  Travel (TM)
    • WFM: Work Force Management (WFM)
  • Wrote ABAP test routines for over ten-thousand data objects
  • Architected and implemented process chains for automating the data validation BW processes, scripts and reporting queries.
  • Developed automated object naming tool which cut out 99% of the naming effort and freed up significant additional development time.

 

Responsibility #2:     Build Data Extract Files

 

• Developed data file extraction routines to extract R/3 Project Systems data using InfoSpokes.

 

Responsibility #3:     Local BW Production System Support

 

• Responsible for the existing San Diego Navy Base’s SAP BW production legacy system. This is the current local BW system that is to be replaced after the Navy ERP project “Go-Live”.
• Optimized memory management which freed up around 340 Gig of memory space.  This increased system up-time toward 99.999%.
• Responsible for Year End Closing and Fiscal Year Change Over

 

Responsibility #4:     Local BW Trainer

 

• Redesigned the BW Architecture to be easy to understand.

 

1/2/2007 – 2/9/2007       Insight Communications, Inc. (www.insight.com)

 

                                    Position:          SAP BW / SAP HR - contractor

Project:            ISIS / ECC 5.0 BW HR Upgrade Project

 

Client Name	Insight Communications
Product 1	Support SAP r/3 4.6C to ECC 5.0 upgrade
Product 2	SAP BW 3.5 to BI 7.0 Upgrade
Product 3	SAP HR: Human Resources Custom Reporting
Industry	Military
Roles	SAP BW 3.5 to SAP BW 7.0 Report Conversion BW BI BEx Query – Lead
Sub-Projects	3
Team Size	1
Start Date	1/2/2007
End Date	2/9/2007
Location 1	Phoenix Arizona
Location 2	Chicago Illinois
Security Clearance Required	no

 

 

• SAP R/3 4.6C to ECC 5.0 upgrade (23 countries).
• SAP BW 3.5 to BI 7.0 upgrade.
• Built SAP BW back-ends & queries for the following functional areas:
  • HR: Human Resources (HR)
  • Mastered the SAP HR module and SAP HR – SAP BW interfaces.
  • Implemented Generic Extractors. Maintained the communication structure and transfer rules, InfoSources and InfoProviders. Built ODS objects, InfoSets, InfoCubes, Characteristics and Key Figures. Optimized BW data loading.
  • Designed and implemented HR reports for Benefits, Health Insurance, 401K savings plan and others.

-       Published reports to the Portal.

-       Provided technical trouble shooting on outstanding R/3 to BW Heat Tickets.

 

10/2004 -8/2006             Network Vista, Inc.  (www.networkvista.com)

 

                                    Position:     IT Software development, business operations support

• Cut unnecessary operating costs by 90%
• Grew customer base 30% in 2 months
• Installed and configured and successfully launched a Customer Invoicing/Collection system for www.NetworkVista.com.
• Named VP Marketing and Sales February 2006.
• Provided remote overnight Help Desk customer support
• Built SAP Portal Server – AMD Athlon 64x2, 3-GIG Ram, 70 GIGx2 - Dual Raid HD Arrays, CD-ROM, Floppy Disk, Microsoft Windows 2003 for Small Business OS, MY SQL, Java SDK 1.3.1, SAP EP 5.0.

 

12/2003-10/2004                        Sunbelt Business Brokers of Hawaii

 

                                    Position:          BUSINESS PLANNING CONSULTANT

 

• Completed 7 Business Plan projects covering 11 distinct industries with this Business Broker.
• Licensed Real Estate Salesperson - State of Indiana - 8/2006

 

11/1991-11/2003            Delphi Delco Electronic Systems, Japan

                                   

                                    Position #1:      SAP VEGA PROJECT ABAP DEVELOPER

 

• ABAP developer on the Delphi SAP VEGA Project

 

Position #2:      Software Engineer

 

• 12 years experience real time embedded software engineer, project manager, Unix Administrator.
• Over 120 end-to-end real time embedded software projects completed.
• Real Time engine control for 4, 6, 8 cylinder gasoline and diesel engines in Automatic and Manual transmission configurations.
• Managed / Balanced / Handled 4 to 6 simultaneous software projects in any given year.
• Worked in 8 bit and 32 bit assembly language and Ansii C and C/C++.
• Wrote the engine control software for the Chevrolet Silverado and GMC Sierra 6.6L Dmax diesel engine software. The Chevrolet Silverado was the #1 selling vehicle in North America in 2003 the last year I worked on this software that was over 500,000 lines of code long.
• Worked in global software automotive projects for 12 years with teams in Japan, Indiana, Luxembourg, Korea, Singapore, Melbourne Australia and China.

 

                                    Position #3:      Lead Internal Auditor

 

• Supervised 3 employees
• Conducted approximately 120 Software Quality Assurance Process Audits
• Licensed Internal Auditor – Lloyd’s registry of quality assurance.

 

                                    Position #4:      Sun and Unix system and Unix tools administrator

 

• Achieved 100% uptime availability for 12 years 24X7x365

 

                                    Position #5:      Software Sales

 

• Repackaged what had formerly been given away as packaged services
• Achieved incremental revenues of approximately $90,000,000.00 on a company wide basis.

 

                                    Position #6:      New Employee Trainer

 

• Trained 15 International Service Personnel
• Developed extensive On-The-Job structured training manuals
• I’m a pretty creative engineer.

 

 

10/1990-11/1991            General Motors Corp.

                                    Position:           Assistant Chief Power House Engineer

 

• Supervised 12 unionized Powerhouse Repairmen and Boiler Firemen.
• Ensured the safety of the powerhouse
• Responsible for generating and providing critical utility services vital to the plant
• Licensed Stationary Engineer

 

05/1985-10/1990            General Motors Corp.

                                    Position:           Plant Maintenance Supervisor

 

• Supervised 33 unionized maintenance and preventive maintenance skilled trade workers daily. These were my own daily people. The whole maintenance dept. had over 400 maintenance personnel all of whom I supervised from time to time over the years.
• Supervised over 100 production employees on the car Head Rest production line periodically for several years.
• Responsible for ensuring 100% production capability of all machines at all times throughout the factory.
• Strong background in automotive industrial process automation.
• Project Manager on $30+ multimillion dollar in-house production line construction projects within and outside this factory.

 

 

 

technical SAP SKILLS:

 

SAP Business Warehouse,

SAP APD (Analysis process designer),

SAP Integrated Planning,

SAP ABAP,

Business Process Design,

Data Warehouse Design,

Data Modeling,

Data Extraction,

ODS Objects, InfoCubes, MultiProviders, Characteristics, Key Figures, Master Data,

Data Mart,

Open HUB,

Infospoke,

BEx Query,

Web Enabled Queries,

Portal PUBLISHING,

BEx Broadcaster,

Mobile Devices,

User Security,

User Authorizations,

GIS MAP INTEGRATION

DATA RECONCILLIATION

Assembly, ANSI C, C/C++, UNIX, LINUX, SQL, UNIX SCRIPT, Certified Internal  Auditor,

SAP BW, BPS, ABAP, APD, HR, PS,  Netweaver, Business Objects, XCELSIUS, IBM Cognos 8, CRYSTAL REPORTS, MAYA, MEL