SUMMARY:

• SAP BW/BOBJ/HANA Technical Leader w/ 10 Years Hands on Experience Data Modeling/Loading Reporting Performance Enhancement Data Extraction Analytical Problem Solving End to End Implementations
• Data Quality Transformations Business Requirements Business Processes BI Process Chains Strong Communication Skills
• Team and Relationship Builder Root cause identification and Analysis of Performance Issues Extensive knowledge of SAP Business Objects Platform (all versions) Experience working with ABAP
• Data flows, BI Process chains and Open hub extracts.
• Experienced, skillful, and results oriented SAP Senior Business Intelligence consultant bridges the gap between business processes and Information Systems solutions, demonstrating a track record of progressive responsibilities.
• Creates SAP HANA Data Models (Attribute View, Analytic View, and Calculation View) and row level data security, including User Management, devising customized roles for all user types.
• Implements multiple full life cycle projects with SAP modules, including FI, SD, MM, COPA, and others from the LO Cockpit.
• Experienced and highly skilled in a wide range of SAP Business Intelligence applications ranging from process mapping/problem definition to technical solution design, build, test, and deploy.
• Regularly performs root cause analysis of performance issues to solve complex BW technical and functional problems.
• Talented and highly experienced in data extraction from SAP R/3/ECC6 using generic extraction. HANA data provisioning from ECC and SCM using SLT.
• Partners and collaborates with business to translate business challenges into business requirements, resulting in designing, developing, and deploying complex SAP BW, Business Objects, and SAP HANA solutions that exceed business expectations.
• Skilled with business objects reporting tools, specifically analysis for office, design studio, Lumira and web intelligence.
• Demonstrates organization, communication, and translation skills in driving effective business requirements, focusing on interpersonal skills in working with end users and other IT professionals.
• Twelve years IT experience with a concentration of 10 years SAP BW, 7 years BOBJ, and 4 years of SAP HANA hands on experience, reflecting progressive information technology experience in SAP - BW.
• Highly skilled in Data Extraction from SAP R/3 ECC6, using Generic Extraction. HANA data provisioning from ECC and SCM using SLT. Created information views to support SCM and other reporting solutions.
• Implemented multiple full life cycle projects with various modules of SAP including FI, SD, MM, COPA, and other modules in the LO Cockpit.
• Demonstrates knowledge in a variety of industry business process areas of SAP, OTC, SAP P2P, SAP R2R, SAP MM, SAP PP; possesses expert knowledge in using Process Chains to automate and monitor data load processes.

TECHNICAL SKILLS:

Tools: SAP, BW, HANA, BOBJ covering BW 3.5 - BW 7.4, BOBJ XI3.1-4.1, WEBI, Crystal Report 2011, Crystal Enterprise, Dashboard, Xcesius, QaaWS, Live Office, BEx, and Lumira

Operating Systems / Software: Oracle 9.1, 10g, 11g, DB2, MS SQL, BI 7.X, Business Objects X13.1, 4.0, 4.1 SAP IK XI 3.1

PROFESSIONAL EXPERIENCE:

Confidential - San Antonio, TX

SAP BW/BI/HANA Lead

Responsibilities:

• Data Modeling: Builds SAP HANA Data Models (Attribute View, Analytic View, and Calculation View) and row level data security. Uses Transient Provider in BW on HANA DataMart Modelling; HANA optimized objects and composite provider in realizing business requirements; employs BW on HANA methodologies such as ADSO, Composite Providers Open ODS Views, ODP Extractors, SLT configuration and SLT load monitoring. Delivers BW data models and BOBJ reports in SAP BW on HANA environment in SAP areas MM, FI, and SD.
• Data Inconsistency: Implements a forward lookup on the main F1 Integration DSO, using a routine in the transformation to resolve data inconsistency by enabling the collection of new and changed records by delta loads.
• Major Data Load and Reporting Issues: Conducts a system performance evaluation, resulting in the redesign of a major info-cube and the implementation of Semantically Partitioned Object (SPO). Analyzes and resolves a nonexecutable reporting issue resulting in the identification of bad code from the info-code transformation, followed by the modification of the query with user exit variable, accomplishing the proper outcome.
• Uncompounded and Remapped Master Data Objects: In the resolution of data issues found in reporting, adds a data source to a report data flow. Additionally, creates and coordinates a cutover plan to drop and reloads the historical data to correct data issues with the reports.
• Complex Reports: Designs and develops in SAP BI, Business Objects WEBI, using BO universes (using IDT), Qwaas, and Dashboards, Crystal Report 2011, Crystal Enterprise and Lumira.
• Built a complex Geospatial dashboard with Lumira for employee headcount and Analysis
• SAP BW on HANA: Delivers specific modelling using LSA ++, Composite Providers and exposing BW objects in HANA Views, and Operational Data Provisioning.

Confidential - Duncan, SC

SAP BI/BO Lead Consultant

Responsibilities:

• Customization: Created Custom Extractor on Custom Tables to extract data for Sales and Customer Analysis reports.
• Custom Cubes and Reports: ZSC C15, ZFIAR C01, Customer Credit History and Payment History cubes. Loaded data from ECC in BW to facilitate the reporting requirements. Created Multi-Providers on A/R and Billing cubes for reports of A/C Receivables and invoice information. Developed customized data sources, and created custom Info Cubes (ZZ SD C01, XX-SD C02, ZZ SD C03) to meet user requirements. Enhanced data sources of Master Data. Created custom InfoCubes, InfoObjects, customized data sources, and reports. Created Custom InfoObjects, InfoCubes, DSO’s, Datasource, and setup data flow to extract data from third party tools like Vendavo, in addition to extracted data with Flat File, from the Legacy System.
• Archiving Skills: Performed object analysis to select objects for archiving and determined the timing of the archival process. Produced logical and physical file parts and created the content repository for archived data storage for archiving identified objects (DSOs) to free up space and improve the performance of the systems.

Confidential, Milwaukee, WI

SAP Bi Lead Consultant

Responsibilities:

• Technical leader on SAP project: Supervised team on SAP activities that included design, development, testing, and implantation. Other areas consisted of business analysis, excellent verbal and written communication skills in communicating technical systematic requirements effectively, and technical design. Orchestrated post production transition of BI Module. Designed and developed foundational data models and architected complex customer extraction using
• ABAP programs, database views, and user exits. Improved performance by reviewing aggregates and constructing new ones, and deleting unused ones. Modified many process chains set up to run batch jobs, replaced sequential processing with parallel processing to improve overall performance.

Confidential - Cincinnati, Ohio

SAP BI Consultant

Responsibilities:

• Master Data: Created one point of truth for Master Data and customer master data objects to be maintained locally. Performed consolidation, extracting domain data from regional systems, intended for continuous audit of Master Data. Enhanced Vendor Master information from SAP reporting in BW to accomplish Parent/Grandparent relationship for the Vendor in BW.
• Defect Repository: Serves as data source to the Open Hub destination and used for automated ticket generation in Service Manager.

Confidential, Plano, TX

SAP BI Lead Consultant

Responsibilities:

• BI Project: Led a 5 person off-shore team in delivering a BI project consisting of the following tasks: object analysis to determine the sizes and rate of growth of the objects to be archived, constructing logical and physical file parts; and, developing a content repository for archived data storage.
• Other deliverables included the creation of secondary indexes and a process chain for the automation of the data archiving process. Improved performance of the systems resulting from data archiving for about 200 DSOs’.
• File System: Employed SAB BW Open Hub Destination to read data from a SAP BW object (DataStore Object) and stored the contents in a staging area for use by external tools. Generated XML file for consumption by Service Manager Web Service Application (SWA) for automated ticket generation.

Confidential, Atlanta, GA

SAP BI/BO Consultant

Responsibilities:

• Reports: Led reconciliation and validation efforts using SAP BEx reports to compare and validate BI data with source data. Constructed user friendly reports with multiple display objects on a single page for web intelligence reports.
• Generated canned reports using BO universe as the data provider. Extensively worked with Xcelsius in the design of Xcelsius dashboards using data connectivity through QaaWS and Live Office. Produced new reports and modified existing reports, with an on-going focus on echoing the business requirements.
• Performed a variety of tasks such as: BOBJ Administration in CMC for Server management; events handling; end user security; development of WEB intelligence; generation of canned reports using BO Universe; and, the design of Xcesius dashboards using data connectivity through QaaWS and Live Office.

Confidential, St. Louis, MO

SAP CI Consultant

Responsibilities:

• Performed end to end implementations of the FI modules (FIGL, AR and AP). Designed and constructed data models for financial, control reporting, and for comparing invoice and services revenue, by reviewing and analyzing business requirements, identifying and closing gaps.
• Additionally, designed and developed data models and reports to illustrate the costs associated with production orders and constructed reports for the analysis of internal earning statements, external earning statements, balance sheets, and profit and loss.

Confidential, Bolingbrook, Illinois

SAP BI Consultant

Responsibilities:

• Developed data models using SAP BW 7.0 objectives such as MultiProviders, Info-cube, InfoObject, Data Store Objects, Transformations, Start Routines, End Routines and DTPs to meet reporting requirements.
• Extensive use of Business Object Enterprise XI reporting tools; designer, Info-view, Web Intelligence, Crystal Reports, and Xcelcius.