We provide IT Staff Augmentation Services!

Bw/bi Consultant Resume

5.00/5 (Submit Your Rating)

Sacramento Area, CA

SUMMARY:

  • Twenty years of experience in managing and optimizing business operations and reports in various industries • Spent last 7 years in technology area working with SAP Business Warehouse(BW), reporting using SAP Business Objects(BOBJ) tools • Successfully managed functional requirements and development technical solutions to key BI Projects.

TECHNICAL SKILLS:

Database: SQL (MICROSOFT SQL SERVER 2012), SAP BW

Data Discovery and Visualization Tools: SAP Lumira (Visual Intelligence), SAP BOBJ Predictive Analytics, Qlikview, Tableau, Alteryx, Microsoft Power BI.

BW powered by HANA: created ADSO s and New Composite Providers in Eclipse based HANA Studio. Converted classical DSO s and InfoCubes to ADSO s and MultiProviders to New Composite Providers.

Presentation Tools: HANA Information Modeling. (Attribute View, Analytic View, and Calculation View)

Business Objects: Design Studio, Crystal Report, Web Intelligence, Dashboard Design (Xcelsius), UDT, IDT, SAP BOBJ Analysis - Edition for Microsoft Office, BEX Analyzer

ERP: Material Master (MM) Customer and Pricing Master Data (SD) Procure to Pay FICO Sales Order to Cash (SD) Production Planning and Execution (PP, MRP) HCM

Knowledge: ABAP 4.0; Core JAVA (jdk1.8.0 111, jre1.8.0 111); IDE Eclipse Oxygen.

PROFESSIONAL EXPERIENCE:

Confidential,Sacramento Area,CA

BW/BI Consultant

Responsibilities:
  • Performed BW DEV and QA systems testing post Unicode conversion and BW Upgrade from 3.x to 7.4.
  • Rectification of Master Data ATTR, TEXT, HIER against BW production system to ensure consistency.
  • Applied SAP Notes and Activated DataSources in ECC DEV to be used to re-develop data models in BW DEV system.
  • Migrates 3.x DataSources, InfoSources, and Transfer Rules to BW 7.4 Unicode environment.
  • Created Transformations and mappings using BW Production system as reference.
  • Re-developed Master Data Daily Chains under the Unicode and upgraded environment to include DTP’s in the chain.
  • Tested sample transactions data in BW QA and validated the data with ECC T-codes.

Confidential,Richardson,TX

SAP BOBJ Design Studio Analysis Application Developer

Responsibilities:
  • Using SAP BOBJ Design Studio version 1.6, SP 1, Patch 2, created Analysis Applications linking Bex query data from TKI.
  • Applying Analytic Components, Basic Components, and Container Components to create a dashboard with crosstabs and charts.
  • Applying Java Script API to control the process logic and functionalities of components, such as dynamic visibility, filtering dimensions, pop-up windows, etc.
  • Using CSS to change the style and color of Texts, Components, and/or background of the entire Application.

Confidential,Phoenix, AZ

SAP Lumira Developer /Consultant

Responsibilities:
  • Consuming Analytics Queries generated by CDS views in SAP S/4 HANA to create visualizations.
  • Integrate Lumira into Fiori Launch pad by creating xswidget and xsappsite in HANA XS Project using HANA Studio.
  • Using SAP Lumira Desktop 1.31, developed Visualizations and Stories using Sales & Distribution Data.
  • Created Datasets by acquiring data through SAP BW Data Acquisition Connector Extension for Bex query data and through local flat files, prepared, cleansed and harmonized data by converting data types and using Merge and Append functions.
  • Created Datasets by acquiring data through connections via SAP BOBJ Universe and SAP BOBJ Universe Query Panel Extension (QPE).
  • Created Datasets by downloading HANA offline data from HANA Analytic View.
  • Created visualizations to include a variety of Chart types: Line, Bar, Pie, Trellis, Heat Map, Tree Map, Geo Map, Tag Cloud, Cross Tab, Water Fall, Scatter Plot, etc.
  • Created Reference Lines for Bar and Line Chart types; created Additional Calculations such as Moving Average and Difference in Line Charts.
  • Created forecast using Lumira’s embedded SAP Predictive Analytics and Regression in Line Chart.
  • In visualizations, blended data by using Lumira’s Link Dataset function to apply measures from different datasets and created Custom Calculations and Conditional Formatting in Cross Tabs to gain business insights; and created Year over Year Line Chart based on datasets of different years.
  • Composed Stories with visualizations, with Input Control for selected Dimensions to control graphs on a Story page to show different perspectives.
  • Created Filter Links in Stories to apply Input Control uniformly to different Charts based on different Datasets.
  • Created a hyperlink embedded with company logo to direct users to company’s website.
  • Scheduled data refresh/update by enabling Lumira Agent.
  • Exported Story in PDF format with Appendix for team members to share.
  • Saved documents to BOBJ BI platform.
  • Clearly communicate with business and IT users by interpreting and explaining the visualizations/charts, stats, and Story Boards to ensure complete understanding of Lumira Documents.

BW Developer/Business Analyst

Responsibilities:
  • Converted classical BW 7.3 DSO’s, InfoCubes, MultiProviders to BW on HANA objects: ADSO and Composite Provider.
  • Working in HANA Studio (Eclipse environment) to create ADSO and Composite Provider.
  • Gathered end user requirements for business intelligence solutions and reports/dashboards.
  • Developed complete Data Models for various functional modules: Sales and Distribution(SD); Production Planning and Controlling(PP); Inventory Management(IM); Purchasing(MM); Material Ledger/Product Costing(COPC); Financial Accounting-Accounts Receivable(FIAR); Controlling-Profit Center Accounting(ECPCA); Controlling-Profitability Analysis(COPA);
  • For each Data Model, data flow was defined from the source to the BI store by:
  • Performing analysis of ECC data structures, modifying and/or enhancing standard content (BI Content) based on this analysis;
  • Proposing and documenting BW Data Models based on ECC usage analysis;
  • Installing BI Content from different Application Components corresponding to the respective functional modules;
  • Creating DataSources for Master Data (Texts, Attributes, and Hierarchies) and Transaction Data;
  • Creating Transformations for both Master Data and Transaction Data;
  • Creating DSO’s, InfoCubes, and MultiCubes depending on business requirements;
  • Creating Transformations for DSO’s and InfoCubes;
  • Created InfoPackages and DTP’s to load, through PSA, Master Data into Master Data tables and to load Transaction Data via different Update modes, either Full Load or Delta load, depending on the DataSource, into DSO’s and InfoCubes;
  • Created Process Chains and Daily, Weekly, and Monthly Meta Chains to automate data loading processes for Transaction Data and Master Data Change Runs;
  • Installed, enhanced, and sometimes redesigned queries using Bex Query Designer by creating RKF’s, CKF’s and adding new Selections to Structures to answer business questions and provide better insight to business;
  • Using Bex Query Analyzer and SAP BOBJ Analysis - Edition for Microsoft Office, tested query execution results against ECC reports derived by running various T-Codes and achieved conformity on KPI’s between query results and ECC report numbers, demonstrating the final validity of the Data Models.
  • Functional and technical support of SAP Business Warehouse (BW) and Business Objects solutions in the areas of design, configuration, implementation, testing, operation, maintenance, training, support and enhancement to ensure that they are reliable, accessible and meet the needs of business units.
  • Compiled and prepared technical, statistical and/or analytical reports and presentations to business and IT users and interpreted the graphs, stats, and dashboard in common business terms to ensure complete understanding of the reports.

Confidential,Richardson,TX

Business Objects BI Analyst

Responsibilities:
  • Created HANA information modeling using HANA Studio. Created Attribute View, Analytic View, and Calculation View.
  • Created Restricted Measures (Columns), Calculated Measures (Columns), and Variables in Analytic View.
  • Applying SAP BOBJ BI 4.1, created Universes by using IDT.
  • Created Lumira Visualizations and Stories, Crystal Reports of various dimensions by consuming ECC data and through Universes.
  • Created a wide scope of WEBI reports and Dashboard Design models to answer client’s business questions.
  • Leveraging experience and deep understanding of ECC, supported fellow consultants on projects in the ECC modules of FICO, PP, MRP, MM, and SD.
  • Working in the onshore development center actively support all development on current projects in business objects, and Hadoop solutions.
  • In charge of internal business objects and big data training on the newest platform
  • Internal inbound marketing project content contributor and deployment manager
  • Facilitated mapping of customer journey through inbound marketing tools.
  • Documented current and future campaign models and customer journey process flows
  • Published technical blogs on Big Data, business intelligence, and analytics related subjects.

Confidential,Dallas,TX

Business Objects BI Analystc

Responsibilities:

  • Led business objects implementation and continuous support. Converted 150 spreadsheets in sales, finance, logistic and HR into WebI, Crystal and Dashboard for executives.
  • Created centralized hub for corporate reporting for operation managers and field sales representative.
  • In charge of corporate Data cleansing of master data in customers, vendors, and materials.
  • Involved in requirements gathering, development, testing and migration to Production environment.
  • Worked with administrators to optimize report performance via database tuning.
  • Worked with security team to implement authorizations for BI reporting.
  • Performed unit, integration, application and regression testing, as well as support and participate as needed in user acceptance testing, debugging, resolving defects and production validation activities.
  • Interacted with end users and related teams on creating new Ad-hoc reports, data analysis and corrections, problem solving depending on the requirements.
  • Supervised IT team to support the Windows 7 upgrade of SAP BO XI 3.1 and SAP BO 4.1.
  • Worked on windows 7 image testing for both SAP BO 4.1 and SAP BO XI 3.1
  • Tested all applications and their functionality of all the client tools in both SAP BO XI 3.1 and SAP BO 4.1 (Web Intelligence Rich client, IDT, UDT, QAAWS and widgets.)
  • Tested the BI launch pad and Info view in the Windows 7 environment.
  • In Charge of all IT and Operation Budgeting and forecasting each year for maintenance of business and projects.
  • Utilized finance and operation report to increase sales 65% over 3 years.
  • In charge of improving end-to-end business operation support for the company.
  • Managed various projects internally to optimize finance and sales reports.

Operations Manager

Responsibilities:
  • Leader of Warehouse Convergence Project. Created warehouse efficiency by 85% by strategically changing the warehouse floor plan. Redesigned more efficient groupings of products and arranging them strategically based on 15 criteria such as best sold products, complement products, weights and shape, etc.
  • Leader of Logistic Analyzed Project. Streamlined business processes from overseas procurement, to ocean shipping, warehousing, sales and distribution, and customer payment.
  • Supervised Buyers, Warehouse Managers, and Delivery Operators.
  • Managed the logistics of import, particularly ocean shipping and domestic intermodal transport.
  • Monitored inventory levels to correspond to the changing environment of the business
  • Designed and implemented vendor selection process.
  • Directed work team to purchase and delivery of all products within the company.
  • Implemented the Vendor Improvement Project. Evaluated current vendors based on price, quality, product functionality, and timely fulfillment.

Confidential,Dallas,Richardson,TX

Operations Manager

Responsibilities:

  • Financial Accounting, Procurement, Fulfillment, and Production Configuration
  • Project Team Lead from blueprint, development, testing, and mock go live.

We'd love your feedback!