Name of Consultant
Skills – Architect Level -       Team Lead -       Developer -       Project Planning - Project Management	I am thoroughly experienced working with all parts of SAP BW, Business Objects and Crystal Reports on versions 3.x, 4.x & 7.x   Managing a software development project and doing work at the same time. Requirements Gathering / Definition Customer Interface between end users and developers Customer Education   SAP BW 3.5, 7.0, 7.3 /SAP Business Objects 3.5, 4.0 Business Objects Dashboard design and realization 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, Factory Maintenance I follow PMP Processes, SAP ASAP, Kimbal, Waterfall Process and my own best practices I have created along the way
SAPProjects	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
Visa Status	U.S. Citizen / Japan Work Visa
Security Clearance Status	Active (PPT)
Availability	2 week notice
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, Automotive
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             Position:     SAP BW / BI SOFTWARE teST lEAD / Coordinator

Customer:   

Project:       BW Ops Remediation Project

 

Client Name
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
SAPSub-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 critical to project success.
• 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             Position:     Project Manager

Customer:   

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

 

Client Name
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
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             Position:     SAP BW / BI & SAP Business Objects Consultant

Customer:   

Project:       Olympus Project – Webi, xCelsius Business Warehouse requirements

 

Client Name
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
SAPSub-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             Position:     SAP BI/BW Reporting Education

Customer:   

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

 

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

 

The Customer 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 classroom 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           Position:     SAP BW / BI & SAP Business Objects Consultant

Customer:   

Project:       Business Objects – Management Dashboard Project

 

Client Name
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 CrystalReports – 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 theSAPIntegration 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 forSAPBW 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 SAPBW 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 ofSAPBW 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           Position:     SAP BW Consultant

Customer: 

Project:      Business Intelligence - Business Objects Management Dashboard Project

 

Client Name
Product	Business Objects - Management Dashboard
Industry	IS- Retail; Grocery Food Retail, Mfg., Warehouse Distribution
Roles	SAPBW 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
SAPSub-Projects	1
Team Size	3
Start Date	9/2009
End Date	12/2009
Location 1	HuntsvilleAlabama
Location 2	Remote
Security Clearance Required	no

 

 

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

• Developed initialSAPBW 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 Position: SAP BW 3.5 & BI 7.0 Consultant

Project:            Special Projects

Security Clearance:      Active Government Security Clearance

 

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

 

 

Responsibility #1:     Report Conversion

• ConvertedSAPBW 3.5 Reports toSAPBI 7.0 Reports

 

Responsibility #2:     Visitor Tracking and Reporting

• Reporting forPAS(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, Multi-providers, 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 CUSTOMER Finance team.

 

Responsibility #4:     SAP BW Training

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

 

 

9/24/2008 – 4/17/2009 Position: SAP BW Consultant

Project:            (Core Financial)

Security Clearance:      Active

 

Client Name
Product 1	US Government Travel Manager
Product 2
Product 3	Core FinancialSAPBW Data Warehouse Maintenance
Product 4	Agency Wide Functional And Technical Data Model
Industry	National Security – Nuclear
Roles	SAPBW 3.5 &SAPBW 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	HuntsvilleAlabama
Security Clearance Required	Yes

 

 

Responsibilities:     SAP BW 3.5 & 7.0 Consultant

• Active Government Security Clearance
• US Government Travel Manager
  • Investigated and fixed end user reporting complaints
  • Travel
    • 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
  • Core FinancialSAPBW Data Warehouse
    • I supportedSAPBW 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

• SAPBW Data Model
  • Reverse Engineered CustomersSAPBW Core Financial Legacy System.
  • Analyzed and Drew in minute detail CustomersSAPBW Data Model and associated ABAP software.
  • Delivered Customers 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 otherSAPBW developers with a clear view, for the first time, of the completeSAPBW Architecture which had been developed ad-hoc over the years.

-    Provided a blueprint for Customer's SAPBW Data Warehouse upgrade project

-    Indicated where efficiency improvements can be made.

-    ReducedSAPBW development time by several months resulting in customer savings.

 

7/9/2007 – 5/30/2008      Position:          Sr. SAP BW PM

Project:            Govt. ERP Project

 

Client Name
Product 1	SAPBW Data Validation Project Manager
Product 2	SAPPS (Project Systems) Data Extraction
Product 3	Legacy SystemSAPBW Production Support
Product 4	SAPBW Trainer
Industry	Military
Roles	SAPBW 3.5 toSAPBW 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
SAPSub-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. Customer’s San DiegoSAPBW 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 Customer base (5) involved in the Customer 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.
  • Customer 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 Customer 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 builtSAPBW 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 Customer Base’sSAPBW production legacy system. This is the current local BW system that is to be replaced after the Customer 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       Position:          SAP BW / SAP HR - contractor

Project:            ISIS / ECC 5.0 BW HR Upgrade Project

 

Client Name
Product 1	SupportSAPr/3 4.6C toECC5.0 upgrade
Product 2	SAPBW 3.5 to BI 7.0 Upgrade
Product 3	SAPHR: Human Resources Custom Reporting
Industry	Telephony
Roles	SAPBW 3.5 toSAPBW 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	PhoenixArizona
Location 2	ChicagoIllinois
Security Clearance Required	no

 

 

• SAPR/3 4.6C toECC5.0 upgrade (23 countries).
• SAPBW 3.5 to BI 7.0 upgrade.
• BuiltSAPBW back-ends & queries for the following functional areas:
  • HR: Human Resources (HR)
  • Mastered theSAPHR module andSAPHR –SAPBW 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             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
• BuiltSAPPortal Server –AMDAthlon 64x2, 3-GIGRam, 70 GIGx2 - Dual Raid HD Arrays, CD-ROM, Floppy Disk, Microsoft Windows 2003 for Small Business OS, MY SQL, Java SDK 1.3.1,SAPEP 5.0.

 

12/2003-10/2004            Position:          BUSINESS PLANNING CONSULTANT

 

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

 

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

                                   

                                    Position #1:      SAP VEGA PROJECT ABAP DEVELOPER

 

• ABAP developer on the DelphiSAPVEGA Project

 

Position #2:      Real Time Embedded Software Engineer (Car Engine)

 

• 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 ANSI 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:

 

SAPBusiness Warehouse,

SAPAPD(Analysis process designer),

SAPIntegrated Planning,

SAPABAP,

Business Process Design,

DataWarehouse Design,

DataModeling,

DataExtraction,

ODS Objects, InfoCubes, MultiProviders, Characteristics,KeyFigures, MasterData,

DataMart,

OpenHUB,

Infospoke,

BEx Query,

WebEnabled Queries,

Portal PUBLISHING,

BEx Broadcaster,

Mobile Devices,

User Security,

User Authorizations,

gisMAPINTEGRATION

dATARECONCILLIATION

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

SAPBW, BPS, ABAP,APD, HR, PS,  Netweaver, Business Objects, XCELSIUS, IBM Cognos 8, CRYSTALREPORTS, MAYA, MEL