SUMMARY:

• Data Warehousing professional specializing in SAP BW, BI (Business Intelligence), and SAP HANA with extensive experience bringing order to chaos in the Order to Cash (OTC) and Supply Chain Management (SCM) areas. Five SAP R/3 implementations, five SAP BW implementations, and three upgrades.
• SAP HANA certified.
• ABAP Workbench - (Data Dictionary Objects, Fields, Tables)
• Characteristics (MM)
• Characteristics and Key Figures (BW)
• Classification (MM) - Material and Batch
• Customer Master (SD)
• Document Flow (SD, MM)
• Extractors (BW) - 0material, 0customer, and custom
• Flexible Analysis (LIS and SIS)
• InfoCubes (BW)
• Informatica PowerConnect (Data Extraction)
• Intra Company Orders (Stock Transport Orders)
• Integration Test (WinRunner)
• Knowledge Transfer
• Material Documents (MM)
• Material Groups (SD,MM)
• Material Master (MM)
• Material Stock Types (i.e., Blocked, Consignment)
• Material Types (MM)
• Milestones (PS)
• Movement Types (MM)
• MRP (MM)
• Networks (PS)
• ODSs (BW)
• OSS Notes
• Partner Functionality (SD)
• Physical Inventory/Cycle Count (MM)
• Projects (PS)
• Sales Documents (quotes, orders, delivery documents, billing documents)
• Standard Analysis (LIS and SIS)
• Unit Test
• Create custom extractors.
• Initialize delta loads for SAP provided content.
• Transfer global settings from R/3 to BW.
• Configuration of Material Master data; material types, material groups and number ranges
• Configuration of Customer Master data including account groups and partner functions.
• Configuration of material master and customer master field selection
• Functional support of data mapping and data conversion
• Developed classification structure.
• Configuration of characteristics and check tables.
• Extension of BW 0material to include classification and custom data.
• Extension of BW 0customer to include custom data..
• Configuration of Plant and Storage Locations.
• Configuration of Intra company orders (stock transport order)
• Setting for physical inventory and cycle counting
• Field selection configuration for movement types
• Configuration of sales organization, division, and channels.
• Verification of document flow.
• Defining valuation control, valuation areas, valuation classes, valuation grouping codes
• Automatic MM-FI account posting configuration for material movements
• Reporting
• Configured custom BW InfoCubes and ODSs and supporting InfoPackages and extractors.
• Configured custom BW characteristics and key figures
• Activated SAP provided BW content - InfoCubes, ODSs, InfoPackages, extractors, characteristics, and key figures
• Created BW BEX master queries for customization by power users.
• Use of Informatica PowerConnect to extract R/3 data to custom databases
• Use of UDC and 3rdParty DB connect to extract data into SAP BW from non-SAP sources.
• Creation and use of WinRunner scripts to load data
• ABAP sourced flat files.

TECHNICAL SKILLS:

SAP BW 2.1C to 7.4 (15 years)

SAP R/3 3.1H to ECC 6.0 (20 years)

SAP HANA (1 year)

SAP BEX Analyzer (5 years)

INDUSTRY EXPERIENCE

Semiconductor Industry (15 years)

Manufacturing (7 years)

Entertainment (1.5 years)

Pharmaceutical Industry (2 years)

Food Processing (1.5 years)

Oil and Gas (1/2 year)

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Managing Consultant - SAP BW and HANA

Responsibilities:

• Implement and customize Collections and Disputes Business Content.
• Advised and assisted issue resolution including ABAP correction for upgrade BW 7.01 to 7.4.

Confidential

SAP BW Lead

Responsibilities:

• Determined and lead execution of pre and post upgrade/migration functional tasks.
• Managed development of FICA document based Meter to Cash metric.

Confidential

SAP BW Subject Matter Expert

Responsibilities:

• Primary author of Space Management Strategy Document.
• Analyzed and determined approach for Top 30 tables in ECC, BW, and CRM systems.

Confidential

SAP BW Solution Architect

Responsibilities:

• Developed implementation roadmap, drafted project plan, defined tasks, implemented business content, executed custom ABAP development, trained and supervised three developers.
• Lead Blueprint sessions and designed Data Marts for Billings, Bookings, and Backlog.
• Initiated data governance process, identifying data owners and stewards.

Confidential, Fremont, CA

Principal Consultant, SAP Business Intelligence, Data Warehousing and HANA

Responsibilities:

• Conducted two Business Intelligence Project Design Review and Quality Assurance Audits.
• Supported multiple project pursuits through TCO (Total Cost of Ownership) calculations.

Confidential

SAP HANA Solution Architect, Data Modeler and BusinessObjects Universe Designer

Responsibilities:

• Designed and developed data marts in SAP HANA for storing business use case data.
• Designed and developed BusinessObjects Universes used in Webi and Crystal Reports presentation layer.

Confidential

SAP BW Subject Matter Expert

Responsibilities:

• Analyzed 30 SCM (Supply Chain Management) and 20 HCM (Human Capital Management) reports for source data in SAP ECC (Enterprise Central Component) system.
• Performed gap analysis to SAP BW Business Content extractors and created technical specifications for custom extractors.

Confidential

Reporting Lead

Responsibilities:

• Lead blueprint phase to refine requirements into a list of deliverable functions specifications.

Confidential

SAP BW Developer

Responsibilities:

• Created Supplier Metrics Workbook using SAP BW Information Broadcasting to distribute Dashboard and detailed Vendor listings via e-mail.

Confidential

SAP BW Solution Architect

Responsibilities:

• Designed and implemented SAP BW data warehouse supporting Business Objects Webi and QlikView as presentation layers.
• Implemented 20+ data marts including SAP SD (Sales and Distribution), SAP MM (Material Management), SAP PP ( Production Planning) Production Orders, Vistex (an SAP bolt-on for Claims processing), and SAP FI (Finance) Accounts Receivable, Accounts Payable, and new General Ledger, COPA (Cost Controlling - Profitability Analysis ) and COPC (Product Costing).

Confidential

Business Analyst Consultant

Responsibilities:

• Analyzed 100+ legacy reports across three systems to consolidated requirements into less than 10 functional specifications supporting the OTC (Order to Cash) process.
• Championed standardization in presentation through a common style sheet and standardized layout.
• Created and enforced common metadata for reporting terms through a central data definition dictionary.

Confidential, Chicago, IL

Manager, SAP Business Intelligence

Responsibilities:

• Provided 400% greater visibility for client's project managers into the project's largest cost driver - payments to vendors.
• Enhanced extractors to join accounts payable documents to controlling documents through finance document Cross-Company Posting Transaction in a BI 7.0 environment
• Reestablished credibility with client by executing the principals of software development project management (requirements definition, functional design, technical specification, unit test, integration test, and implementation.

Confidential

SAP Business Intelligence Lead

Responsibilities:

• Data Governance
• Access to Data (Security)
• Meaning of Data (Metadata)
• Master Data Management
• Data Quality (Reconciliation)
• Report Development
• Data Flow Architecture
• User Interface

Confidential

SAP BW/BI (Business Intelligence) Team Lead

Responsibilities:

• Managed functional design process from data mapping of technical source to hand off to Offshore team for design, in a merger of an Oracle based data warehouse and a legacy BW 3.0c system into a BI 7.0 environment.
• Supervised work of one on-shore and five off-shore resources creating functional design.
• Managed design requirements of 123 identified development objects in six subject areas (Sales, CRM, Forecast, Budget, Inventory, Commissions, COPA).

Confidential, New York, New York

Senior Consultant SAP BW

Responsibilities:

• Created comprehensive task list for technical upgrade from SAP BW 3.5 to BI 7.0 (NetWeaver).
• Lead Blueprinting process for requirements, established UAT (user acceptance tests) for upgrade acceptance.
• Lead Blueprinting process to identify requirements and prototype solutions using SAP BW 3.5 SD (Sales and Distribution) business content as well as efforts to define master data (ie “Title”, “Territory”) in SAP R/3 and BW.
• Re-architected SD business content, leveraging SAP business content data sources, exporting the data through Open Hub InfoSpokes to a Teradata database, and retuning the data through Remote InfoCubes for presentation and security through SAP BW.
• Lead Realization process implementation through Go-Live and stabilization.
• Lead process blueprinting. Authored BW design principles guidance document for the project.
• Assessed requirements to optimize reporting source (R/3 vs. BW). Determined resource requirements for R/3 ABAP and BW development.
• Architected SEM BPS (Business Planning and Simulation) solution .
• Developed SEM (Strategic Enterprise Management) Balanced Scorecard prototype.

Confidential, Livingston, CA

BW Functional Analyst (System Analyst)

Responsibilities:

• Created four custom InfoProviders (one InfoSet, one InfoCube, and two MultiProviders)
• Created five BEX reports.
• Supported 132 InfoCubes and MultiProviders (data marts) with associated extractors for the MM (materials management), SD (sales and distribution), and FI (finance) modules in SAP R/3.
• Initialized V3 update for the Logistics (LO) cockpit
• Managed data flow through process chains.
• Performance tuning through aggregates.
• Troubleshooting data inconsistencies.

Confidential, Corona, CA

BW Functional Analyst (System Analyst)

Responsibilities:

• Established standards and practices for BW development.
• Directed development efforts and executed code reviews for six developers.
• Activated 39 SAP standard content ODSs (operational data stores) and InfoCubes (data marts) with associated extractors for the MM (materials management), SD (sales and distribution), and FI (finance) modules in SAP R/3. Configured custom and standard extractors in BW IMG.
• Created six custom ODSs and InfoCubes.
• Integrated SAP R/3 direct sales and non-SAP CARS/Imany indirect sales (chargeback) data using 3rd Party DB Connect.
• Created PL/SQL queries for custom extractors from Oracle databases.

Confidential, Newport Beach, CA

Developer

Responsibilities:

• Split MES data for Skyworks Solutions spin off. Created data map, developed implementation tools and techniques, and successfully revalued inventory to meet SEC requirements.

Confidential, Milpitas, CA

Programmer/Analyst

Responsibilities:

• Activated SAP BW provided content and created custom targets - InfoCubes, ODSs (Operational Data Stores), and extractors..
• Implemented SAP® R/3 3.1H SD (sales and distribution) and MM (material management) modules as member of project team.
• Configured SAP® R/3 material classification and characteristics.
• Designed and developed custom data marts using MS SQL Server 7 or Oracle® 11 databases using Informatica PowerCenter ETL (extraction, transformation, and loading) tool. .
• Led successful implementation of Promis 5.x MES (manufacturing execution system) costing module.

Confidential, Manteca, CA

Senior Cost Analyst

Responsibilities:

• Implemented Promis cost module for work in process (WIP) valuation and variance reporting for an electronic assembler.

Confidential, Newport Beach, CA

Cost Analyst

Responsibilities:

• Supervised the production and inspection of chips in a unionized environment.
• Initiated use of Promis report writing module to create customized activity, yield, and equipment utilization reports.