SUMMARY:

• Visualization: Business Objects Dashboard Designer, Design Studio, Web Intelligence, Web Application Designer
• Reporting & Analytics: Business Objects Analysis for OLAP, Business Objects Analysis for Office, BOBJ Explorer, Lumira, BEx Query Designer, BEx Analyzer, Power BI, Power Pivot, VBA advanced integration wif MS excel
• Big Data, SAP BW 7.4, ECC 6.0, BW on HANA
• Data Modeling: OLAP, Multi - Dimensional Data Warehouse Design, InfoCubes, DSOs, MultiProviders, InfoSets, InfoObjects, Data Flows, MS Access
• ETL: DB Connect, DB2, ODBC, flat file loading, mySQL data loading, DataSources, InfoSources, Transformations, Data Transfer Processes (DTPs), ABAP routines, InfoPackages, V3 delta queues, LIS extraction cockpit, Setup tables & initialization
• Reporting & Analytics: Business Objects (Dashboard Designer, Design Studio, Web Intelligence), Pivot Tables, BEx Query Designer, BEx Analyzer, Web Application Designer, advanced integration wif MS excel
• Load automation & monitoring: Process Chains, Analysis Process Designer
• Administration: RSECADMIN, Analysis Authorizations, Broadcasting & Distribution
• BPC Netweaver Version 7.5 & 10.1 wif EPM add on
• Application/Model Development & Dimension Management: Application sets, Member sets, hierarchies.
• Data Acquisition: transformation files, conversion files, packages, package links, script logic
• Input Schedules & Reporting: EVDRE control panel (ranges & expansion), Current View features, data submission.
• SAP Roles & Authorization configuration and administration in SAP ERP, BW, CRM, SRM, and portal
• Data level security design and development (row based security)
• Sarbanes-Oxley testing and remediation
• Goverance, Risk and Compliance tools (Approva, APM, and D2C)

PROFESSIONAL EXPERIENCE:

Confidential

SAP Data Specialist

Responsibilities:

• Master data cleansing and preparation for migration to new SAP S/4 HANA system
• Analyze over 18,000 counterparty records to determine if they are matching entities
• Analyze transactional history for thousands of customers & vendors to determine if they are still active
• Develop and maintain Power BI reports to manage master data delta updates in preparation for project go-live
• Develop prototype Power BI and Power Pivot reports to track business partner activity and changes to master data
• Prepare mass upload files for master data test loads
• Validate & cleanse pricing condition records in SAP S/4 HANA test environment
• Prepare upload files for pricing condition records

Confidential

SAP/BI Project Manager

Responsibilities:

• Designed and developed reporting solutions for sales and purchasing for SAP BI 7.4 greenfield implementation
• Worked closely wif finance, sales, and purchasing departments to gather reporting requirements and test reporting solutions
• Managed SAP support team tasked wif the client, stabilizing the system, and resolving issues following a new SAP implementation
• Held weekly internal status meetings to review and improve support processes
• Held weekly ticket review meetings and monthly steering committee meetings wif client
• Managed SAP hosting and support projects for multiple clients
• Managed transition period and noledge transfer for new SAP support projects

Confidential - Raleigh, NC

Business Intelligence Team Lead

Responsibilities:

• Implementation team lead in pilot project to set up a Business Objects front end reporting environment on top of an SAP BW 7.4 backend
• Designed & developed performance analytics and reporting processes for commercial analytics team
• Combined multiple data sources into a comprehensive reporting and analytics solution using Business Objects (Design Studio, Web Intelligence, and Business Objects Explorer)
• Designed and developed Business Warehouse data modeling and ETL solution to combine data from multiple source systems and optimize it for reporting and analysis
• Worked closely wif business users and SMEs to and redesign legacy reporting and analytics solutions and automate manual processes used to support them

Confidential - Westmont, IL

Business Intelligence Team Lead

Responsibilities:

• Lead Architect in client facing role on full life cycle SAP BW 7.3 Implementation that coincided wif new SAP ECC 6.0 implementation
• Designed and developed data models, ETL processes and reports using standard content and custom enhancements for PP, CO, QM, MM, SD, AR, AP application components
• Leveraged Data Flows and other new BW 7.3 functionality to streamline ETL processes and maximize efficiency in data warehouse and reporting layers
• Designed process chains to automate nightly data loads

Confidential - New Braunfels, Texas

Business Intelligence Team Lead

Responsibilities:

• Implemented SAP HANA on BW: pre-project assessment and sizing, clean up obsolete or redundant data from PSAs and DSOs, collect baseline statistics for data loads and query performance, convert data mart layer to HANA optimized InfoCubes, functional testing and validation, review existing data flows to implement “quick wins” where possible and make recommendations for future LSA design.
• Lead Architect for full life cycle BW 7.0 Implementation
• Upgrade from BW 7.0 to BW 7.3
• Implemented BPC 7.5 for SAP NetWeaver: Designed staging cube as source for transactional data into BPC applications, set up conversion and transformation files, created validation queries in to compare BW source data (BEx) to BPC application data, redesigned and Implemented new budgeting process using Input templates.
• Designed and automated dealership financial statements along wif electronic submission files as required by various OEMs including Peterbilt, Ford, and International.
• Performance tuning at query and cube level for faster reporting
• Installed Business Content for SD, AR, GL, FICO, MM, LIS application components
• Consolidated data from multiple source systems using flat file loads & DB connect and made consolidated reporting available in both BW and BPC
• Worked wif supply chain SMEs to define and develop custom reports relating to purchasing, inventory valuation, goods movements
• Enhanced material master & other master data extractors to include customer specific fields required for reporting
• Performed business analyst functions to translate reporting requirements and business rules for Supply Chain Management, Sales & Distribution, and General Ledger Accounting, into ETL specifications
• Developed custom transaction & master data extractors for DBM industry solution (Dealer Business Management) for which standard content did not yet exist
• ABAP code in user exits to populate append fields in extract structures
• Built complex, multi-layered data models using DSO’s InfoCubes, InfoSets, & MultiProviders wif sophisticated transformation routines & DTP’s as required to produce reports to specifications
• ABAP transformation routines to assign values to custom characteristics and key figures
• Developed custom characteristics, key figures, InfoCubes, Datastore Objects, & InfoSets
• Configured the Logistics Extraction Cockpit (LBWE) for Billing, Purchasing, & Inventory controlling
• Initialized setup tables and scheduled delta queue processing for purchasing, inventory controlling, and billing applications
• Developed or oversaw development of all BW reports
• Developed large process chains to load transaction data into PSA and various data warehouse layers
• Created Analysis Process Design to load direct update DSOs from a BEx query
• Scheduled background jobs to maintain PSA tables to reduce database size and growth rate

Confidential

Consultant

Responsibilities:

• Developed reports and analytical tools relating wif BEx Query Designer and BEx Analyzer enabling detailed variance analysis of budget vs. actual overhead costs.
• Captured complex business rules using Restricted Key Figures and Calculated Key Figures.
• Designed BW security solution for workbench and analysis authorizations for client working in a shared environment wif another Business Unit.
• Assisted in Data Modeling effort to capture current overhead reporting requirements wif consideration given to future roll-outs to other business areas.
• Built InfoCubes using Key Figures and Characteristics grouped into logical reporting dimensions, Built DataStore Objects, and MultiProviders.
• Assisted in Data ETL design to load data from SAP and non-SAP systems and load into the PSA and subsequent InfoProviders.
• Created transfer routines to populate additional characteristic values from flat file loads
• Developed custom VBA application to consolidate offline budget data for over 200 cost centers into a single flat file to be loaded in BW.

Confidential - Grand Prairie, TX

SAP Security Team Lead

Responsibilities:

• Enabled end users to perform job functions as a late addition to the project team in a dynamic production environment.
• Worked wif core team members to define requirements and remediate segregation of duties conflicts prior to the project go-live.
• Configured security for FI, CO, MM, CS, PP, PS, QM, and SD modules to meet organizations complex requirements and control objectives.
• Developed CATT script to load employee HR data.
• Provided support across all functional areas for legacy data migration and validation.

Confidential

SAP Security Consultant

Responsibilities:

• Designed and modified roles using profile generator to meet production support requirements.
• Supported user provisioning and emergency access requirements.
• Approva configuration across multiple landscapes, BW security design, SAP production support, risk assessment, risk monitoring, change control, user administration.

Confidential - Wichita, KA

SAP Security Team Lead

Responsibilities:

• Led security configuration effort to convert several business processes in order-to-cash and production cycles to SAP. Project required major development and configuration efforts in FI, SD, PP, MM, and QM modules
• Remediated existing segregation of duties conflicts and data access risks
• Designed and carried out integration test plan for security and documented results in Test Director.
• Used profile generator to create over 100 new security roles to accommodate over 5,000 new users.
• Resolved lingering issues from previous upgrade from version 4.6C to 5.0.

Confidential, Houston, Texas

SAP Security Consultant

Responsibilities:

• SAP User Administration Process Upgrade - Initiated and led a project to redesign the user provisioning procedures and documentation tools. The project provided additional process controls for user administration, enhanced communication and support for business process owners, and reduced processing time for access change requests.
• Risk Configuration - Configured client’s risk analysis tool (APM) to identify new segregation of duties conflicts and sensitive access issues defined by business process owners. The project enabled the risk tool to identify current risks and perform risk simulations to proactively identify potential risks associated wif change requests.
• Basis Security Re-design - Configured security in R/3, BW, EBP, XI, and Solution Manger systems. Project included identifying and defining all Basis access risks, creating Basis security roles using Profile Generator, remediation of highly sensitive Basis access, and document change management procedures.
• HR Security Re-design - Implemented HR security access changes for 700 users.
• Joint Venture Security Design - Configured security for a new joint venture company. The project leveraged the client’s existing R/3 system to provide functionality to joint venture users while restricting their SAP access to the only JV Company’s data.