SUMMARY:

• Over 16+ years Informational Technology support and development experience with 8 years of SAP Net Weaver BW 7.0 - 7.3 and SAP ECC 6.X with 4 Life Cycle implementations. Excellent technical knowledge of “Backend” BW Development balanced with substantial “Frontend” Confidential 4.x Web Intelligence and Analytical Reporting Skills.A team player with proven ability to influence and foster collaborative relationships to push projects across the finish line. Consistently maintains the highest standards of personal and professional performance with integrity and creativity.
• 17+ years Industry IT development, design and support experience.
• 9 years of SAP BI/BW 7.x “Back-end” design and support.
• 8+ Years Confidential 4.x “Front-end” Self Service Analytical Reporting Development/Training Suite (Tableau, Web Intelligence, Design Studio, and Lumira 2.0.
• SAP Modules: SD, MM, WM, FI-AR, FI-AP, FI-GL, PURCHASING, CRM, LO, ISU and ISA.
• 4 Lifecycle implementations, Bridgestone-OTC; SD, WM, MM. Southwire-SD, Confidential -OTC; SD, CPG and Equifax-FI.
• Domain experience: Pharmaceutical, Medical Device, Utilities Oil & Gas, Public Sector, Manufacturing, CPG industry, Finance, and Aerospace/DoD.
• Project Methodologies; ASAP, Water fall, Agile/Scrum methodologies.
• SAP Training Specialist, Develop technical content, reference materials, guides, and course materials using WPB (Workforce Performance Builder) for end users and Power Users using SAP Confidential Tool Suite including IDT (Universe design, Data Profile Security and Business Profile Security), Web Intelligence, Lumira and HANA Modeling in HANA Studio
• Visualization experiences with Design Studio and Lumira 2.0. Tableau 9-10 SME proficient in acquiring data, cleansing data and creating visualizations for Story Book reports. Conducted numerous stand up classes to train Power Users and Executive level Stake Holders in Self Service Analytical Reporting. Additionally experienced Tableau developer with 3 years of experience in creating complex visualization dashboards

PROFESSIONAL SKILLS:

• SAP BW Back-end Data Modeling with Numerous Projects has given me a Broad experience in BW Architectural, “BEST PRACTICE” Methodologies and Standards; such as the “Agile” and the “ASAP” Methodology as the Road Map to a successful BW implementation.
• Business requirements meetings using Gap Analysis and KPI workshops, applying business functional requirements to technical specification documents, RICEFW functional design development and Solution Manager.
• Multidimensional Data Modeling of Star Schema and Extended Star Schema methodologies.
• Configuration of BW data objects: InfoObjects, Transformations, DTPs, InfoProviders (DSOs, InfoCubes, and MultiProviders), and Process Chains.
• Install and activate BI Content, Build data flow to include Data Sources, IP, PSA, DTP, Confidential, Transformations, Cube and Multiprovider and Process chains.
• ETL, leveraging standard BW extractors, LBWE Extractors and creating Generic Extractors.
• Cut-Over, Stabilization, Post Go-Live and Ticket Resolution support with HP QC.
• Performance tuning, Aggregation, BIA, Compression, DTP and Partitioning.
• SELF SERVICE ANALYTICAL REPORTING: Responsible for the technical design and delivery of visulization reporting solutions for the client. Working closely with members of the Business Intelligence leadership team with Solution Manager to build and deploy end-to-end solutions.
• Confidential Business Suite Technical experience utilizing SAP BO development tools (IDT, Web Intelligence, Design Studio, Lumira and Crystal Reports.
• Created Web Intelligence ILT Content (Instructor Led Training Course) leveraging customized content, plus scenario based exercises using Client BI data
• Tableau developer with 3 years of experience in creating complex visualization dashboards, workbooks and worksheets using different data sources, google sheets, charts, multi-layered maps and multiple input controls.
• Experience with Tableau workbook objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting and other KPI’s.
• Experience in writing Test Scripts coupled with UAT to certify QA using HP Application Lifecycle Management (HPQC).
• Experienced in creating BEx Query Designer complex Reports using RKFs, CKFs and variables.
• Proficient using BODS Basic Query transformations, Advanced Query transformations and Case Transformations.
• Design and build SAP Lumira Discovery documents, story boards and visualizations. Merge Data, Blend Data. Predictive Analytics, using Trellis and to Create Story boards for Self Service Analytical Reporting with Lumira Discovery.
• Experienced using Workforce Performance Builder (WPB) as the SAP Single Source Recording suite for Cross-Training Power Users and to teach the Teacher approach to training large audiences BEx Query Designer and Confidential WEBi.
• Trained “lecture style” on BW on HANA Modeling, to include HANA Attribute, Analytic, and Calculation Views design of artifacts & mechanisms.
• Design and Development of HANA Attribute, Analytic, and Calculation Views to be consumed by Business Objects tool suite.
• Implement: create schemas, tables, compose views, and develop joins at the Data Foundation level and build Advanced Data Store Objects (ADSOs)
• Develop procedures for Attribute Views, Time Attribute Views and Derived Attribute Views
• Familiar with HANA Studio and BODS Data Services using Basic Query transformations, Advanced Query transformations and Case Transformations
• Managing Attribute Mapping, Creating Left Outer Joins and Temporal Joins by connecting Tables with Joins and universe development using IDT.

PROFESSIONAL EXPERIENCE:

Confidential

SAP BO/BW Developer

Environment: HANA 1.0 SP10, BW 7.4, BOE 4.2 Design Studio 1.6Lumira Discovery 2.x, TABLEAU 9 - 10

Business Modules: SD, MM, FI, FIAR, FIAP, SCM, and LO

Responsibilities:

• Expert level in BI Data Modeling Techniques. Visualization tools including Tableau, Lumira
• Tableau developer with 4 years of experience in creating complex visualization dashboards.
• Using Tableau created workbooks and worksheets using different data sources, google sheets, charts, multi-layered maps and multiple input controls
• Confidential 4.X, using the Confidential Tool suite; IDT, WEB Intelligence, Lumira.
• Creating, enhancing and “tuning” of SAP BEx Query Designer Reports,
• Proficient with BEx Analyzer, and training users with BEx tool suite.
• Worked on different Tableau objects like straight tables, line charts, bar charts and pivot tables etc for dashboard design.
• Created the SAP BW Data flow (from Data source to MultiProvider) On the IBM SD Sales Compensation Tool data feed a FF to include the Creation of the BEx Query Designer to be consumed by Confidential Web Intelligence 4.x for Analytical Reporting.
• Supporting the Sales Compensation SD OTC Tool by loading the IBM FF data into the SAP BW data flow through to the “Dream Cube” and MultiProvider. Create BEx Query Designer queries to be consumed by the “Self Service analytical Reporting” with Lumira Discovery..
• Multidimensional Data Modeling of ODS’s, info-objects, Cubes and Multi-providers. Loaded and Activated BI standard business content and enhanced InfoCubes and created Custom Cubes. Defined and set-up hierarchies, Navigational attributes, aggregates and Roll-ups.
• Led in design workshops representing a process or sub-process for a region or Business Unit to define the “Self Service analytical Reporting” with Lumira Discovery.and technical requirements.

Confidential, Atlanta, GA

SAP BO/BW Developer

Environment: HANA 1.0 SP9, BW 7.4, BOE 4.1, BODS 4.2, IDT, Design Studio 1.6Lumira Discovery 2.x, TABLEAU 9 - 10

Business Modules: SD, MM, FI, FIAR, FIAP, SCM, and LO

Responsibilities:

• Experienced using Workforce Performance Builder (WPB) as the SAP Single Source Recording suite for Cross-Training Power Users on BEx Query Designer and to teach the Teacher approach to training large audiences.
• Building executive, adhoc, and custom dashboards and publishing to Tableau server.
• Experience designing reports using BEx Query Designer with Analyzer for training the Business user to include reporting using WEBi and Advanced Analysis. Conducted SAP Tester from Unit testing through to UAT.
• Architect experience, was tasked with the responsibility to design, define, develop, and deliver Global analytical reporting following the ASAP methodology from BW Data flow to Front-end Confidential WEBi reporting to “Self Service analytical Reporting” with Lumira Discovery.
• Worked on different Tableau objects like straight tables, line charts, bar charts and pivot tables etc for dashboard design.
• Created the SAP BW Data flow (from Data source to MultiProvider) On the IBM SD Sales Compensation Tool data feed a FF to include the Creation of the BEx Query Designer to be consumed by Confidential Web Intelligence 4.x for Analytical Reporting.
• Supporting the Sales Compensation SD OTC Tool by loading the IBM FF data into the SAP BW data flow through to the “Dream Cube” and MultiProvider. Create BEx Query Designer queries to be consumed by the “Self Service analytical Reporting” with Lumira Discovery..
• Multidimensional Data Modeling of ODS’s, info-objects, Cubes and Multi-providers. Loaded and Activated BI standard business content and enhanced InfoCubes and created Custom Cubes. Defined and set-up hierarchies, Navigational attributes, aggregates and Roll-ups.
• Led in design workshops representing a process or sub-process for a region or Business Unit to define the “Self Service analytical Reporting” with Lumira Discovery and technical requirements to Develop technical content, reference materials, guides, and course materials using WPB (Workforce Performance Builder) for end users and Power Users.
• Created the test scripts used to test the SD Sales compensation tool for UAT in HPQC.
• Created the Sales model in HANA studio to analyze data real time utilizing the capabilities of HANA. By Creation of attribute view, analytical view, and calculation view.
• Work with end users on the Systems, Applications and Products (SAP) application's integration and functionality; determine those technology inadequacies and/or deficiencies that can affect the functional area's ability to meet the organizational goals.
• Experienced in Collecting and transporting Business Content from Development environment to Quality and Production with all its dependent objects like Cubes, DSOs, ABAP conversion tables, Process chains, Info Sources and Quarries.

Confidential, Collegeville, PA

SAP BO/BW Developer

Environment: BW 7.4, BO 4.1, BODS 4.2, Design Studio 1.5, Lumira 2.x and TABLEAU

Business Modules: SD, MM, FI, SCM, and LO

Responsibilities:

• Enhanced the Design Studio “Operational Dashboard” to display 9 Manufacturing Plant KPI‘s to the User for quick overview of 0Plant status.
• Design and build SAP Lumira documents, story boards and visualizations for manufacturing, SD KPI’s and case studies.
• Worked with end users to explain Tableau workbooks, creating ad-hoc reports
• Recreated BO reports in tableau as per business requirement
• Trained developers on Tableau in terms of best developing and design practices
• Experienced in posting RICEFW Technical documentation to SharePoint to share content
• Lead efforts in UAT and creating custom scripts to certify QA testing using HP-ALM
• SAP Training Specialist, SAP BI/BOBJ, Lead the project, Self-service Analytical Reporting Train the Trainer with Material review and teach back with Instructors.
• Experienced in and executes the development and Cross Training to Power Users of Webi (to create AD-hoc reports) Lumira and Dashboard training courses which are a suite of front-end applications that allow business users to view, sort, and analyze BI data. Extensive Instructional Design experience in SAP Workforce Performance Builder (WPB)
• Created the dashboard that presented the status of 9 highly monitored financial “Budget” SD KPI’s on the Manufacturing and Delivery Metrics view to Develop technical content, reference materials, guides, and course materials using WPB (Workforce Performance Builder) for end users and Power Users.
• Design, create, and document SAP ECC/CRM Order to Cash (OTC, SD) Delivery applications and functionality in support of Customer Service functions
• Led in design workshops representing a process or sub-process for a region or Business Unit to define the overall SD application and technical requirements.
• Created the SD data source extractor to load the Billing data with 2LIS 13 VADHDR loading the data field VBRK.
• Loaded the Billing data and created the data flow for 2LIS 11 VAHDR VBAK from extractor to the Multiprovider Shipping Analytics
• Tasked with the responsibility to design, define, develop, and deliver SD Global Manufacturing for analytical self-service reporting following the ASAP methodology from BW “Back-end” Data flow to the “Front-end” Confidential Web Intelligence (to create AD-hoc reports) and Design Studio.
• Created the training material from actual Client tickets to train Power Users BEx Query Designer.
• Proficient in training Power User and Corporate Executives report creation with BEx Query Designer using RKFs, CKFs and variables.
• Hana Studio Modeling; Using SAP BODS transformed and cleansed COPA data tables KNA1, TOO5U and imported to HANA using Query Transformation to be consumed by dash boards.
• Multidimensional Data Modeling of ODS’s, info-objects, Cubes and Multi-providers. Loaded and Activated BI standard business content and enhanced InfoCubes and created Custom Cubes. Defined and set-up hierarchies, Navigational attributes, aggregates and Roll-ups.
• Strong experience in implementing Web Intelligence Reports using BICS connections Confidential 4.0 - 4.1 using the BEx Queries as the Report Data set and universe development using IDT consumed by “Self Service analytical Reporting” with Lumira Discovery..
• Skilled at developing reports in Design Studio graphical Analytical Reporting with Charts and graphs “Self Service analytical Reporting” with Lumira Discovery..
• Improved data loading performance for Manufacturing KPI’s by enhancing the “Data Source” data set (Restricting data set) and put into place Parallel Processing of the Data Source consumed by Confidential Reports. As a result of these efforts data loads were conducted successfully with reduced loading time to the Design Studio.

Confidential, Wichita, KS

SAP BO/BW Developer

Environment: Tableau 9, BW 7.4, BO 4.1, BODS 4.2, Design Studio 1.5 Lumira and TABLEAU

Business Modules: Business Modules SD, MM, FI, SCM, CRM, SRM and LO

Responsibilities:

• SAP BI Project Lead for the Confidential Project creating the Design Studio dashboards that presented the status of 24 highly monitored financial budget statuses on the Confidential Metrics “Landing Page”.
• Created Report in Tableau 9 as a Confidential budget landing page as a POC
• Created server-based Tableau workbooks(twb), Packaged workbook (twbx), dashboards and applications from scratch based on client needs
• Worked with end users to explain Tableau workbooks, creating ad-hoc reports
• Recreated BO reports in tableau as per business requirement.
• SAP Lumira documents, story boards and visualizations. Supported Web Intelligence Reports feed by Hana views, Developed and enhanced Universes (.unx) created from Oracle Tables that were consumed by “Self Service analytical Reporting” with Lumira Discovery.
• Involved implementing/migrating objects from BW 7.0 to BW 7.3 on HANA. The intent of the project was to develop the Data trust which fed the Confidential “Cost Center” budget dash board. SAP Training Specialist, SAP BOBJ, Self-service Analytical Reporting Train the Trainer with Material review and teach back with Instructors “Self Service analytical Reporting” with Lumira Discovery..
• Using SAP Workforce Performance Builder (WPB) Development of application training course materials to include integration of Business Intelligence policies/procedures and SAP BI Tools BEx Query Designer and data functionality utilizing BEx Analyzer.
• Tasked with the responsibility to design, define, develop, and deliver Global analytical reporting following the ASAP methodology from BW Data flow to Front-end Confidential WEBi.
• Design, develop, validate and integrate reporting and information solutions building dashboards from the scratch Confidential 4.x, using the Confidential Tool suite; IDT, WEB Intelligence, Design Studio and Crystal Reports. Multidimensional Data Modeling of ODS’s, info-objects, Cubes and Multi-providers. Loaded and Activated BI standard business content and enhanced InfoCubes and created Custom Cubes. Defined and set-up hierarchies, Navigational attributes, aggregates and aggregate roll-ups.
• Expertise in developing BI Reports using the BEx (Business Explorer) tool set as the Data set for Business Objects Tool suite and “Self Service analytical Reporting” with Lumira Discovery.
• Strong experience in implementing Web Intelligence Reports using BICS connections Confidential 4.0 - 4.1 using the BEx Queries as the Report Data set.
• Led in design workshops representing a process or sub-process for a region or Business Unit to define the overall SD application and technical requirements.
• Created the Billing Cube, Backorders Cube and the Offers and Orders cube, combined theses cubes into the Billing Analytics cube.
• Using Crystal Reports created the production budget reports for the Cost Centers delivered to the Confidential .
• Hana Studio Modeling; Using SAP BODS transformed and cleansed COPA data tables KNA1, TOO5U and imported to HANA using Query Transformation to be consumed by dash boards.
• Skilled at developing reports in Lumira Story Book graphical Analytical Reporting with Charts and graphs for “Self Service analytical Reporting” with Lumira Discovery.
• Using BEx Query Designer created RKFs and CKFs along with testing using BEx Analyzer to create Customer Satisfaction Report used as SD KPI
• Improved data loading performance for sales and delivery by limiting data packet sizes, scheduling index deletion and rebuilding jobs through Process Chain Configuration. As a result of these efforts data loads were conducted successfully with reduced loading time.
• Experience designing BW Queries and Modeling Data for Business Objects reporting using WEBi and Advanced Analysis.

Confidential

SAP BI/BW Developer-Lead

Environment: HANA 1.0 SP9, BW 7.4, BO 4.1, Lumira, Design Studio and TABLEAU

Business Modules: Business Modules SD, MM, FI, SCM, CRM, SRM and LO

Responsibilities:

• BW technical expertise in Finance extractors and Data modeling in BW
• Created Global Scripts for dashboard, Page Layout and indexing for “On Click” activation, set up the Design Studio Desktop theme and Landing Page.
• Created SAP Lumira documents, Story Boards and visualizations for Sales team and Directors,
• SAP Training Specialist, SAP BOBJ, Self-service Analytical Reporting Train the Trainer using Lumira
• Experienced using Workforce Performance Builder (WPB) as the SAP Single Source Recording suite for Cross-Training Power Users on BEx Query Designer and to teach the Teacher approach to training large audiences
• Architect experience, was tasked with the responsibility to design, define, develop, and deliver Global analytical reporting for the “Sales Compensation Tool” following the ASAP methodology from BW Data flow to Front-end Confidential WEBi
• Created the SAP BW Data flow (from Data source to MultiProvider) On the IBM SD Sales Compensation Tool data feed a FF to include the Creation of the BEx Query Designer to be consumed by Confidential Web Intelligence 4.x for Analytical Reporting.
• Supporting the Sales Compensation SD OTC Tool by loading the IBM FF data into the SAP BW data flow through to the “Dream Cube” and MultiProvider. Create BEx Query Designer queries to be consumed by the Confidential WEBi Analytical reports.
• Multidimensional Data Modeling of ODS’s, info-objects, Cubes and Multi-providers. Loaded and Activated BI standard business content and enhanced InfoCubes and created Custom Cubes. Defined and set-up hierarchies, Navigational attributes, aggregates and Roll-ups.
• Led in design workshops representing a process or sub-process for a region or Business Unit to define the overall SD application and technical requirements.
• Created “Sales Compensation” SD sales financial reports using Crystal Reports 2008/2011
• Back up to OTC SD production, Monitors Billing data loads, researches load failures and resolves issues. Maintains production load schedule and ETL Tester.
• Created the test scripts used to test the SD Sales compensation tool for UAT in HPQC.
• Created the Sales model in HANA studio to analyze data real time utilizing the capabilities of HANA. By Creation of attribute view, analytical view, and calculation view.
• Experience designing reports using BEx Query Designer with Analyzer for training the Business user to include reporting using WEBi and Advanced Analysis. Conducted SAP Tester from Unit testing through to UAT
• Work with end users on the Systems, Applications and Products (SAP) application's integration and functionality; determine those technology inadequacies and/or deficiencies that can affect the functional area's ability to meet the organizational goals.
• Experienced in Collecting and transporting Business Content from Development environment to Quality and Production with all its dependent objects like Cubes, DSOs, ABAP conversion tables, Process chains, Info Sources and Quarries.
• Customized FF extractions ( Confidential ) to transport JDE data into Data flow to PSA, Confidential, and cube and to the MultiProvider, for reporting Analytics.

Confidential, Jackson, MS

SAP BI/BW Confidential Developer-Sr. Lead

Environment: SAP BI 7.3, ECC 6, Business Object 4.1

Business Modules: SD, MM, FI, SCM, CRM, SRM, LO, HCM and IS

Responsibilities:

• Sr. Lead SAP BI/BW BOE Design Studio, FI Analytical reporting of FI-GL, AP, AR, Purchasing and Expenses. Deliverables included enhancing the BW back-end data modeling to the delivery of front-end Analytical Reporting to the “Department of the Treasury” for the Confidential .
• Designed and defined the POC (Proof of Concept) for the State Treasury Departments “Daily Average Cash Balance” report. Experience in BW Financials implementation of General ledger, Accounts payables, SAP Funds Management and Fixed assets modules
• Led in design workshops representing a process or sub-process for a region or Business Unit to define the overall SD application and technical requirements.
• SAP Training Specialist, SAP BEx Query Designer, Self-service Analytical Reporting Train the Trainer
• Convert medium to complex Analysis for analysis for Office OLAP Reports to Web Intelligence and Crystal Reports, development and training in a fast-paced Scrum/Agile methodology environment.
• Skilled at designing and developing reports in Design Studio graphical Analytical Reporting with Charts and graphs.
• Using SAP Workforce Performance Builder (WPB) Development of application training course materials with focus on the BEx Query Designer to include integration of Business Intelligence policies.
• Technical Lead and architect of 8 person team conducting SAP activities from architecture development of BW backend Data Modeling to BI front-end enhancements to be consumed by Web Intelligence and OLAP Analysis Reporting Tools, SD Billing, Logistics and FI.
• Developed BEx Query Designer reports, Training syllabus to “Lecture” train State employees along with BEx WEBi and OLAP Analysis reporting, to Validate data across the BI Landscape.
• Responsibilities for coordination of Team of 7 resources to support and respond to State Reporting issues from Back end, Business Warehouse data loads, to Front end Published Confidential Reports to the Public Web Site.
• Deliverables include creating custom ODS’s, info-objects, Cubes and Multi-providers. Loaded and Activated BI standard business content and enhanced InfoCubes and created Custom Cubes. Defined and set-up hierarchies, Navigational attributes, aggregates and Roll-ups.
• Work with end users on the Systems, Applications and SD Products (SAP) application's integration and functionality; determine those technology inadequacies and/or deficiencies that can affect the functional area's ability to meet the organizational goals and mission requirements.
• Created the State FI Encumbrance model in HANA studio to analyze data real time utilizing the capabilities of HANA, by Creation of HANA Studio attribute view, analytical view, and calculation view.
• Experienced in Collecting and transporting Business Content from Development environment to Quality and Production with all its dependent objects like Cubes, DSOs, ABAP conversion tables, Process chains, Info Sources and Quarries.
• Back up to Production, Monitors Billing data loads, researches load failures and resolves issues. Maintains production load schedule and ETL Tester.
• Improved data loading performance for sales and delivery by limiting data packet sizes, scheduling index deletion and rebuilding jobs through Process Chain Configuration. As a result of these efforts data loads were conducted successfully with reduced loading time.
• Experience designing complex BEx Query designer reports view by BEx Analyzer .
• Maintaining the Data Dictionary to support the Confidential UDT Reporting Structures.
• Design, develop and maintain reporting and analytic elements as required to support BOBJ/BW environments, training users on BO 4.1 environment. Class room led SAP Trainer. Conducted SAP Tester from Unit testing to UAT
• Customized Confidential (LBWE) to transport data into Confidential InfoObjects, Using Extractors

Confidential, West Chester, PA

SAP BI/BW Developer

Environment: HANA 1.0 SP8, SAP BI 7.03, BO 4.1, Design Studio 1.5 Lumira 1.21

Business Modules: SD, MM, FI, SCM, CRM and IS

Responsibilities:

• SAP BI/BW, enhanced the BW back-end Data flow for the Spine, “Life Net” Project by adding an additional data flow to the Data stream and enhanced the PC for the “Open items” Report with SAP Lumira documents, Story Boards and visualizations.
• SAP BI Developer for the Design Studio dashboards that presented the status of financial budget statuses.
• FI Data loading with CO-PA (KEBO) Modeling, Finance extractors and Data modeling in BW and Experienced in APD.
• Developed and delivered additional data streams for the IRB Project. Experience in upgrade (Migration) to BO 4.1 and writing Test Scripts coupled with UAT, 24/7 Production support of Data load activities coordinated with off shore team. Lead efforts in UAT and writing custom scripts to certify QA using HP-ALM
• Led in design workshops representing a process or sub-process for a region or Business Unit to define the overall SD application and technical requirements.
• Responsibilities for deliverables include Creating custom OTC SD Multidimensional Data Modeling of ODS’s, info-objects, Cubes and Multi-providers. Loaded and Activated BI standard business content and enhanced InfoCubes and created Custom Cubes. Defined and set-up hierarchies, Navigational attributes, aggregates and Roll-ups.
• Experienced in Collecting and transporting Business Content from Development environment to Quality and Production with all its dependent objects like Cubes, DSOs, ABAP conversion tables, Process chains, Info Sources and Quarries
• Back up to OTC SD Production, Monitors Billing data loads, researches load failures and resolves issues. Maintains production load schedule.
• Created Spine and Field Equipment Financial manufacturing reports using Crystal Reports 2008/2011.
• Improved data loading performance for sales and delivery by limiting data packet sizes, scheduling index deletion and rebuilding jobs through Process Chain Configuration. As a result of these efforts data loads were conducted successfully with reduced loading time.
• Experience designing SD BW Queries and Modeling Data for Business Objects reporting using WEBi and Advanced Analysis.
• Created the Open Spine model in HANA studio to enable Pharma Reps to analyze data real time utilizing the capabilities of HANA. This involved creation of attribute view, analytical view, and calculation view.
• Maintaining the Data Dictionary to support the Confidential UDT Reporting Structures.
• Design, develop and maintain reporting and analytic elements as required to support BOBJ/BW environments. As SAP Tester for Center of Excellence (COE) conducted testing from Unit testing to UAT.
• Customized Confidential (LBWE) to transport data into Confidential InfoObjects, Using Extractors

Confidential, Wichita, KS

SAP BI/BW DEVELOPER

Environment: SAP BI 7.01, ECC 6, Business Object 4.0

Business Modules: SD, MM, FI, SCM, CRM and IS

Responsibilities:

• Created custom ODS’s, info-objects, OTC SD Billing and Sales Cubes and Multi-providers. Loaded and Activated BI standard business content and enhanced InfoCubes and created Custom Cubes. Defined and set-up hierarchies, Navigational attributes, aggregates and Roll-ups.
• Experienced in Collecting and transporting Business Content from Development environment to Quality and Production with all its dependent objects like Cubes, DSOs, ABAP conversion tables, Process chains, Info Sources and SD Quarries
• Improved data loading performance for SD sales and delivery by limiting data packet sizes, scheduling index deletion and rebuilding jobs through Process Chain Configuration. As a result of these efforts data loads were conducted successfully with reduced loading time.
• Improved data loading performance for sales and SD delivery by limiting data packet sizes, scheduling index deletion and rebuilding jobs through Process Chain Configuration. As a result of these efforts data loads were conducted successfully with reduced loading time.
• Strong functional side experiences using SAP ASAP Methodology coupled with Gap Analysis to in corporate the latest technology to develop business solutions that increase customer efficiency, productivity and profitability.
• Created SD BOM Finance production reports for Center of Excellence (COE) Team using Crystal Reports 2008/2011.
• BW operations: Data load management, ETL, experience in scheduling Process Chains and Loading (Full Init / Delta Up-Load), Monitoring, Data Mart, BW Transports
• Customized Confidential to transport OTC data into Data source to Confidential, Using Extractors (LBWE)
• Created calculated and restricted key figures. Defined default variables, Off-set queries and created Reports using Formula Variables with Processing Type Replacement Paths.