Bi/bw Techno/functional Development Resume
Sunnyvale, CA
PROFESSIONAL SUMMARY:
- 22 - years SAP experienced Project Manager/technical lead/Technical Analyst/Technical Developer resource with Native HANA/SQL Script/ABAP/Object ABAP/Dialog ABAP/BW developer/JavaScript/Data Modeling/debugging/Native HANA and BW Installs
- Project Manager with the largest project I had 10 direct reports and coordinated efforts of over 60 people located in 7 different time zones and 5 different countries
- Business Functional in finance, manufacturing, sales and distribution, planning, budgeting, (MBA)
- 15 years’ experience managing the off-shore/on-shore model to move projects forward
- Leverage SAP delivered reports from HANA Live and BW Standard Business Content
- Have worked 15+ years with all parts of SAP BW
- Skilled with both working with people and technology to work-through difficult tasks
- Taught HANA and 22 other classes for SAP America
- Managed the install and key debugger of code problems for a client’s spin-off company
- 625 servers were duplicated / migrated to the new environment
- Hands-on architect and lead developer for projects leveraging Native HANA, HANA BW ABAP reporting in all requested SAP Functional Reporting Areas to leverage a business solution
- Work includes initial hardware purchase and setup
- Specific tasks include focusing on the acquisition and implementation of ECC business rules then coding HANA Views, SQLScript, ABAP extractor builds and enhancements, analysis to create joins for report friendly data structures for BEx, Excel, Business Objects Confidential Queries, BW on HANA
- Large stabilization and optimization project of a HANA Database at both BASIS and application
- Using SQL Script and HANA templates to develop database metrics reporting for optimization
- Automated the task with Confidential
- The goal was to leverage the technology in a holistic way to meet business needs beyond just the fast technology through specific business need matching with summary tables
- Project Manager for a company split of a commodity business to a separate business unit
- Project Manager Completing SolMan upgrade to 7.2 SPS07 that will leverage SAP Focused Run
- Managing issues with the BASIS guided procedures
- Project Manager from evaluation of HANA from the Purchase, install, go-live at two sites
- Manage with both an understanding of the business (MBA training) and technology (coding)
- When managing I try to understand what others in the group need to learn to be successful
- Debug Master Data issues as they relate to the software install / patching
TECHNICAL SKILLS:
- Working with HANA Starting with HANA BW pre-release in 2009 as
- Developer with both graphical and SAP SQL Script modeling/programming
- Using ABAP on a HANA database to access HANA views
- Over 15 years Hands-on SAP BW / BW ABAP / ABAP Development / Support / Lead Experiences
- Analyze business requirements, architect the solution by creating BW report friendly data structures and summary tables with pre-calculated key figures for DSO/Cube reporting. Joins and ABAP transformations, spec writing, design, model, configuration, develop ETL with data cleansing routines, and reporting solutions to the most complex business requirements.
- Business user interaction to implement the solutions and work with the development team to knowledge transfer what developers need to know to be successful
- Management presentations about options to make solutions real/project turn-around skills
- Involved in the turn-around of many projects with my experiences in BW ABAP/Data Dictionary/ data structure relationships to get the needed data available to solve the business reporting problems
- Project work includes business interviews / requirements gathering for ECC and BW development, configuration, realization, creating reusable test data sets, and testing as an individual contributor and/or lead, transport management design reports, develop reports, design ETL loads, design business data warehouse, verify developer's warehouse design, write ETL specs for developer, write reporting specs for developer, write business requirement specs, write functional requirements spec, develop automated reusable test script suites
- Started working with the SAP product in 1993; including working directly for SAP in late 1990’s
- Techno-Functional BI Back-end / Front-end Lead with 20 years of SAP experience; 14 years experiences with BI / BW (started working with “SAP BIW” while working directly for SAP in 1998)
- Working as hands on tech lead for teams as large as 10, including managing team members that are off-shore; coordinated efforts on two projects.
- Set-up development team infrastructure: development standards, performance metrics, writing and running test strings, debug critical issues, reporting to senior management
- Techno/Functional with emphasis on tech side design and implement with BI/BW, BPS, and ECC
- Set-up repeatable test environments/development standards/metrics/writing and running test strings/debug/training users
- Working with the BPC Lead Developer to specifications, evaluation of specifications, query designer/WAD/BEx Worked with functional/end users in MM, SD, FI/CO, capital and operational budgeting, PSA, HR/HCM InfoTypes, GM, PS, and RE modules S/4 HANA using ABAP Fiori drill down tiles SQL to support
- Order to cash, procure to pay Confidential Crystal Reports and Confidential evaluations ST12 for extractor optimization of ABAP / SQL, ETL, transformations, routines (start, end, at InfoObject level)
- Understanding of the ECC business processes/requirements/technical process work with the config and developments
- Work analysis, SPRO config issues, user exit enhancements, build ECC to BW recon reports, develop test strings, build generic extractors for BW reporting, build BW reports
- HPQC Test tool for keeping track of test dependencies and metrics reporting
PROFESSIONAL EXPERIENCE:
BI/BW Techno/Functional DevelopmentConfidential, Sunnyvale, CA
Responsibilities:
- Working low level BASIS / Linux tasks to install and configure SAP BW and BPS
- Co-designed and wrote in ABAP a SOX compliant password rotation program
- BW Design Paper collaboration about overall BW design
- Finance collaboration about overall scope for month-end reporting
Confidential, Houston, Texas
SAP Project Manager
Responsibilities:
- Lead the effort to migrate 625 SAP Systems to the new company based in Belgium
- Managed 10 direct reports and coordinated the efforts of over 60 people during the 6-month project
- Worked low-level ABAP / BW errors from migration to help the technical process
- Migration of HANA system to a new environment
- Solution Manager PM for migration to release 7.2 SPS07 upgrade
- HANA Application optimization and stabilization work for the client’s HANA BW system of record database
- HANA is the company’s month-end system of record - highly visible.
- Reviewed their system, developed HANA SQL Scripts to analysis how the system is used, and in the process of optimizing performance
Confidential, Houston, Texas
HANA Developer
Responsibilities:
- Project manager and lead developer for reworking HANA coding to have the results both correct and complete
- Many programs once used in production needed reworking from the original implantation
- One supply/demand matching program Converse estimates will generate $30M in additional revenue
- Data Dictionary work for HANA optimization using summary tables
Confidential
HANA Developer
Responsibilities:
- Project Manager to re-work a detailed go-live plan
- HANA Developer/implementer and debugger to repair a HANA upgrade
- Hands-on technical lead and developer of the revised go-live project plan
- Train existing staff and other developers
- Repair BW system
- S/4 HANA Simple finance support/Fiori Support
Confidential, Houston, Texas
HANA Developer
Responsibilities:
- Project Manager for the install and staff training of a new HANA product
- Created and implemented the
- Helped develop a HANA product for the utility business
- Lead HANA Developer and debugger - managed 4 people as a hands-on lead
- Trained existing staff - 15 people - on how to be a HANA developer
- S/4 HANA Simple finance
- Fiori / OData / Gateway / HANA Live
- S/4 HANA Simple finance support/Fiori Support
Confidential, California
HANA Developer/Trainer
Responsibilities:
- Developed Architecture that started with the purchase to the implementation of HANA SLT setup
- Analyze and develop Inception to Date reporting (ITD) for funding to an SAP HANA friendly format for historical reporting and current SAP Funds Management (FM) Budget Actual / AP, and commitment items
- Train staff and guided efforts of 8 people
- Explored Amazon Web Services (AWS)
- BO (BODS)Data Services for migration
Confidential
BI/BW Techno/Functional DevelopmentResponsibilities:
- Define function specifications to architect with tech specs for Hardware Performance Management to create history reporting in BW with trend analysis and excess inventory costing for material optimization.
- Using BW on HANA and BW SLT / HANA Studio.
- Confidential as the report presentation layer.
- 100% custom solutions / extractors using tables, views, function calls, and InfoSets.
- Very large / complex transformations ported to BW ABAP to run on the HANA box for performance.
Confidential
BI/BW Techno/Functional DevelopmentResponsibilities:
- Debug transformation rules to solve consolidation reporting dependencies.
- Enhancement pack install for BW to support BPC 7, including the development of test plan and test scripts.
- Work with business to ensure the data reconciles to ECC.
- Engaged with process decomposition.
- Working with process chains, application process designer (APD), data load verification, BPC verification, with updates to management.
- Sub-project to sync QA with production.
- Project required developing an understanding of client revenue recognition process to functional test QA before moving to production.
Confidential
SAP Instructor
Responsibilities:
- Training Optimal new hires about SAP Functional Consultant skills (what they need to know to be successful).
Confidential
BI/BW Techno/Functional DevelopmentResponsibilities:
- Working with a team if 3, architect / process de-composition to complete the optimizing of long running BW Extractors for Vistex Chargeback processing; extract run-time went from 23 hours to 4 hours. Using mostly transaction ST12 for analysis then CMOD modifications / process flow re-architect and re-implement.
- Verification routines reconciled using Confidential
- Ad hoc support issues that need fast local resolution using ABAP
- Architect a holistic plan / project plan for a BW reinstall about security / patch level / testing. Isolating key issue to be worked on to solve duplicate GUID problem in BW production. Running meetings to discuss issues.
- Presentations to top management of both IBM and the client about both issues and issue resolution
Confidential
BI/BW Techno/Functional DevelopmentResponsibilities:
- Provide advanced training / assist in developing a project plan / scope-of-work for revenue recognition using SAP BW.
Confidential
BI/BW Techno/Functional DevelopmentResponsibilities:
- Visual Composure with ABAP to build budget forms; working ABAP exit from VC. Working with ABAP user exits. Creation of test data. Working with SAP OSS about new product problems. Training two of the clients ABAPers to work with VC.
Confidential
BI/BW Techno/Functional DevelopmentResponsibilities:
- Working with the client’s BASIS group, documenting new product problems and working issues with the client and SAP America OSS. Developed Visual Composure models for updating transaction cubes through BEx queries using IP (Integrated Planning).
- SAP delivered a new product, PBF (Public Sector Budget Formulation). Set up the internal development environment, worked with SAP America about the new product problems.
Confidential
Support Techno-functional Lead
Responsibilities:
- Project Manager for 5 direct reports and 20 indirect reports go-live repair project
- Concentrated in BW CCA (cost center accounting expense cut-off), Cost of Ownership, and Inventory valuations. On the functional side: FI/CO, MM, SD, CRM, HCM.
- Solved any SAP Business or technical issue with either config or development in any application area the client presents. Analysis of business problem, design of solution, implementation of solution - either config changes or coding changes - and fully documented test results.
- Led a small team, enhancements and supporting two go-live releases - all issues that would come up in BI/BW, FI/CO, and MM. Example tasks are for BW expense cut-off Cost Center Accounting (CCA), Equipment Cost of Ownership, IDOC issues, and reconciliation to ECC using GR55 reports. For FI allowing duplicate invoice posting with exit RRGGBR00, asset depreciations, Report Writer, and IFRS/USGAAP consolidations. For MM Inventory Validations including MIGO and FS10N reconciliations. Also supported GTS (Global Trade System) go-live issues.
- IFRS Configuration for consideration for asset / company value
- Used HPOV HPQC support tools for ticket tracking / QA testing
- There were 1,000's of support incidents solved about go-live/year-end/and IFRS.
- Worked almost all the time in Germany with the off-shore group in India. Some work from the USA with meetings in both European and India time zones.
- SOX (Sarbanes-Oxley Compliance) for SOD (Segregation of Duties) constraints
- Worked huge number of overtime hours to solve problems from the development turnover which were impacting the client’s business
Confidential, New York
BI/BW
Responsibilities:
- BW Optimizations using BW statistics, ST03N transaction, aggregates, indexing, and pre-calculated key figures to optimize query response times. Final go-live QA of reports; nightly load knowledge transfer. Client strategy conversations about work going forward.
- BW Optimizations using BW statistics, ST03N transaction, aggregates, indexing, and pre-calculated key figures to optimize query response times. Final go-live QA of reports; nightly load knowledge transfer. Client conversations about work going forward.
Confidential, Baton Rouge, LA
BW FI/CO Project Systems/Grants/Real Estate
Responsibilities:
- Managed 3 client resources / created the training and development work plan
- Techno/Functional hands-on lead leveraging business understanding into new SAP BI/BW developments.
- State of LA Real Estate Holdings, working with asset management and insurance for RE holdings; building depreciation.
- Business Objects evaluation - developments with Confidential
- The work required a functional understanding of the business to developing reporting that can only come from BI.
- Set up standards/code libraries/test environment for the client developers. Setting up reconciliation reporting. Data clean-up routines for both valid chars and dates.
- Worked with BW 3.x business content and BW 7.x for current developments. Migration of master data loads for text to BW 7.x.
- Functional/conversion work with Grants and project systems.
- Business Object evaluation.
- Built cubes, ODS/DSO creation, extracts, legacy data migration and data cleaning, data loading/DTP, data modeling, batch loads, real-time extracts, query design/development, variable exits, BAPI extractor calls, Report to Report Interface (RSBBS), Data-Sourcing, ABAP for BW, BAPI calls, PS, GM, FM, FI, CO, RE, WM, and capital/operating budgeting. Hierarchy creation and implementation.
- Full end-to-end development: BW intro presentations, requirements gathering, data modeling, test data creation, BW ABAP extractor logic, BW ABAP CMOD variable exits, and ODS/CUBE/Query, training client's staff.
- The work required a functional understanding of the business to engage in the developments.
- Presentation to the client groups for their initial introduction to BW reporting. That is, what BW does for a project about making information from data.
- Worked with BW 3.x business content and BW 7.x for current developments. Migration of master data loads for text to BW 7.x.
- Built cubes, ODS/DSO creation, extracts, legacy data migration and data cleaning, data loading/DTP, data modeling, batch loads, real-time extracts, query design/development, variable exits, BAPI extractor calls, Report to Report Interface (RSBBS), Data-Sourcing, ABAP for BW, BAPI calls, PS, GM, FM, SD, MM, FI, CO, SD, BW, RE, WM, and capital/operating budgeting. Hierarchy creation and implementation.
- Business Object evaluations.
