SUMMARY:

• SAP BOBJ/BW/HANA consultant with over 9 years of experience in SAP Business Intelligence & Business Objects with 4 complete lifecycle implementations involving data modeling, developing Views, designing BEx queries, configuration, report/dashboard development and performance tuning.
• Extensive front - end experience with BEx Query Designer; Experienced in BW-BOBJ integration development using BOBJ tools - Universe Designer, Information Design Tool, WebI, Xcelsius/dashboards, SAP Design Studio, SAP Lumira
• Designed several dashboards leveraging various visualization components (Gauges, Interactive Charts, Alerts, and Scorecard etc.).
• Experience in working with integrating SAP BOBJ BI tools with SAP BW and SAP HANA.
• Experience with SAP Design studio 1.6/1.5.
• Extensive experience with dashboard design with focus on UI and UX.
• Experience in Administration activities on CMC.
• Managed Users and Groups from CMC (Central Management Console).
• Interacted with business users for the requirements of management reports & dashboards.
• Created dashboards with interactivity with Crystal Reports and WebIntelligence for detailed level data
• Extensive experience in Tableau Desktop including Tableau Tableau 9x.
• Worked on CMC to create User-groups and worked on security rights.
• Experience implementing best practices for LCM, Promotion Management.
• Deploying SAP Design studio applications from dev to qa to prod using LCM.
• Experience in Administration activities on CMC.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Defining best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
• Responsible for building the Tableau visualizations for Sales Insights, Asset Management, Customer Demographics, Project Management Metrics.
• Experience in creating Webi for standard report requirements.
• Experience in Scheduling webi reports.
• Worked on CMC to create User-groups and worked on security rights.
• Trained resources in BOBJ tools like SAP Dashboards to support BOBJ applications.
• Highly experienced in creating complex queries in BEx Designer/ Analyzer using Conditions, Exceptions, Filters, Calculated Key Figures, Restricted Key Figures, Variables, Structures, and RRI.
• Actively involved in supporting the various issues addressed by the Users from the client side and providing them with required solutions.
• Created HANA Composite provider on Calculation views.
• Created Attribute views, Analytical views, Calculation views.
• Extensive experience in development and implementation of BO solutions involving SD, MM, FI-AR, FI-AP, FI-CO areas.

TECHNICAL SKILLS:

SAP BW/BI: SAP BW 7.4, BPC 10.0, SAP BI 7.0, SAP BW 3.5, 3.1b, 3.0

BOBJ Applications: BOBJ 4.0, Business Objects XI 3.1, Design studio 1.5, Advanced Analysis, Edition for office, Lumira, Xcelsius 2008, Dashboard designer 4.0, Crystal Reports 2008, Crystal Reports Enterprise 4.x, Live Office, Information design tool, Universe Designer, WebI 4.0, QaaWS, BICS, BOBJ Explorer XI 3.1, CMC, Info View/BI Launch PadSAP ERP: SAP ECC 6.0/5.0, R/3

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SAP BOBJ/ HANA Consultant

Responsibilities:

• Developed Webi Reports For Upstream research Company involving First Incurred Costs and measures.
• Developed Upstream Research Company First Incurred Dashboard in design studio.
• Developed design studio applications for Development Company involving Opex measures and Allocated Measures.
• Developed webi reports to drilldown at detail transaction upto cost center levels using Open Doc Links .
• Gathering requirements as part of Business Focus Project In developing webi reports and Design studio Dashboards.
• Developed bex queries for upstream research company to consume in JOBS dashboard and FirstIncurred Dashboard.
• Conducted knowledge transfer and training sessions to BI support team
• Worked on webi reports for JOBS reports to calculate YTD spends by different functions.
• Created formulas and variables in webi for formatting reports.
• Worked on scheduling Webi reports.
• Used block filters and report filters in webi to give different Slicing’s within same report.
• Created CSS files to link Design studio applications.
• Promotion of Content in Business Objects using LCM Jobs.
• Created HANA composite providers on CA views to be for BOBJ reports and dashboards.
• Involved in Modeling of HANA models.

SAP BOBJ/ BW Consultant

Responsibilities:

• Designed LIFE OF FIELD Dashboard in design studio 1.5
• Created Dashboard to measure statistics of field wells and history of equipment’s at fields.
• Used Geo map component to locate fields.
• Created P25 Dashboard which helps management to track cost reduction targets.
• Designed Technical and Functional specifications for Life of Field Dashboard.
• Knowledge transfer and training sessions to BI support team in Singapore.
• Created BEx reports, BICS connections to source Dashboard.
• Worked with GEO MAP components in Design studio.
• Created CSS files to link Design studio applications.
• Created Users and assigned required roles for authorization of P25 Dashboard.
• Promotion of Content design studio applications using LCM Jobs.

BOBJ/ BW Consultant

Responsibilities:

• Designed North America Supply Chain management Dashboard in design studio 1.4
• Created Dashboard to represent Sales Quality performance metrics .
• Design Master /detail Dashboard with Design studio by connecting to bex queries
• Designed Technical and Functional specifications for SCM Scorecard.
• Designed Analysis process designer to source data into A/P DSO to consume into Design studio applications .
• Designed PPC Sales Dashboard in Design studio 1.4
• Given Knowledge transfer and training sessions to BI support team .
• Created bex reports, BICS connections to source Dashboard .
• Hands on SAP lumira.
• Modeling of infoproviders to provide data for SAP BOBJ applications .
• Implemented Design studio applications using Archius ChartsPlus components.
• Installation of 3rd party components for design studio on BOBJ server.
• Created Account model to load flat files for planning data.
• Created CSS files to link Design studio applications.
• Created Jobs, Work flows and Data flows according to the Business requirements and implemented the business logic.
• Created Process chains to load from flat files and load planning and actual data into reporting DSO.
• Testing of Advanced Analysis 2.0 workbooks.
• Involved in Testing of BOBJ Upgrade to 4.1
• Promotion of Content design studio applications using LCM Jobs.

SAP BOBJ Lead Consultant

Responsibilities:

• Created Attribute views, Analytical views, Calculation views Graphical.Created Restricted measures, Calculated measures, variables, input parameters in Analytical Views.
• Designed “Supply governance Dashboard, Production Assurance Dashboard”.
• Dashboard represents KPIs including, Incidents and request throughput, MTRS, Project closure customer satisfaction, CSAT/CSI, FTEs.
• Developed designed specifications and interacted with BU’s in collecting requirements and designing dashboard.
• Created webi reports for REMEDY queries to supply data to dashboard.
• Designed REMEDY unx universes.
• Designed “HR Management Dashboard” & “Global service Networks” using BIWS connection.
• Created Context, Alias to resolve the Loops in the universe.
• Modified the existing universes, adding new objects editing joins, mapping the existing objects with renamed tables.
• Created new Connections and editing existing to run the report in different databases like test, development.
• Detected cardinalities and checked the Integrity of Universes
• Designed Applications using Design studio and published to SAP BW.
• Modified the existing universes, adding new objects editing joins, mapping the existing objects with renamed tables.
• Provided transition documents and have given training to users in using the Interactive capabilities in dashboard.
• Used Open doc functionality to drill into detailed reports from Dashboards.
• Designed Technical specifications for designing dashboards and Reports in SAP BO.
• Designed “Field Services Dashboard” & “Service Delivery Dashboard” Representing outage, Incident and change metrics using Query browser and performing WHAT IF analysis.
• Built Multi layered dashboards using flash variables.
• Designed TGRC RISK index Dashboard representing metrics like Vulnerability management-Average age of issues across all platforms and Business units.
• Designed “Global networks” application using Column Combination and waterfall charts by connecting to HANA analytical views.
• Hands on experience with design studio. Connected to different data sources such as universe (Unx) and bex queries.
• Created drill down webi reports using open doc functionality.
• Leveraged bex queries to build webi reports.

SAP BOBJ/BW Consultant

Responsibilities:

• Designed “KPI DASHBOARD” with BICS connectivity to bex queries. Dashboard designed with column charts, stacked bar charts, combinational charts and gauges using Dynamic visibility.
• Dashboard represents company KPIs like Net production, Net Tertiary Production, Lifting cost, Lease operating Expenses, Capital expenses.
• Representing the colors in dashboard using Denbury standard colors dynamically.
• Developed Mockup designs and interacted with users in collecting requirements and redesigning dashboard.
• Created bex queries using bex query designer.
• Used query browser to make connections to dashboard.
• Evaluated different approaches of developing dashboard considering the best practices.
• Created OLAP connections in CMC.
• Created Webi reports on bex using BICS and published BIWS.
• Designed dashboard by consuming BIWS
• Designed what if analysis to check the effect of change in LOE and BOE in lifting costs.
• Given training and created design documents for support and transition.

SAP BOBJ Lead Consultant

Responsibilities:

• Designed “Pricing Defensibility and Pricing Corridor Dashboard Using Dashboard Designer 4.0 with BICS connectivity”.
• Processed the data retrieved from BICS connection in spreadsheet using VLOOKUP, IF, SUMMIF, AND, CONCATENATE and other excel supported functions in Dashboard.
• Used 3rd party components such as Centigon essential bundle.
• Used Single and Multi selectors, Stacked charts, combination chats, Dual sliders etc. in developing the dashboard.
• Developed Bex queries as source to Dashboard using CKF and RKF’s.
• Retraction of data from BPC to SAP BW Using Analysis Process Designer.
• Modeled Reporting infocube.
• Tested reports and Dashboard for validating and verifying data.
• Transporting Dashboard from Dev to QA to PROD using LCM.
• Gave training sessions to folks at CSC for SAP Dashboard designer.
• Developed technical documents used for support transition.

SAP BW/BOBJ Consultant

Responsibilities:

• Developed “BACK POCKET REPORT” for sales Reps in web Intelligence 4.0 and Crystal Report for Enterprise 4.0 using BICS connectivity.
• Involved in Requirement gathering and developed Technical specs for BOBJ reporting on top of SAP BW.
• Involved in production support team and provided end user training.
• Designed Bex queries using query designer on sales and accounts receivable area.
• Created OLAP connections using IDT.
• Designed Universes for sales data in Information design tool.
• Designed On demand crystal reports using crystal report for enterprise 4.0.
• Designed and published workbooks using Analysis for Microsoft Excel.
• Configured Analysis workspace using Analysis for OLAP.
• Created a publication object to schedule the documents in CMC.
• Designed and developed enterprise dashboard /scorecards.
• Experience in working Dashboard Designer 4.0 to display summary-level business data in a rich and intuitive format.
• Used OPEN DOC functionality to link web Intelligence documents.
• Using LCM transported the content from DEV to QA and from QA to PROD.
• Published reports to CMS and scheduled the documents in CMC.
• Tested reports for validating and verifying data.

SAP BI/BOBJ Consultant

Responsibilities:

• Designed, created, and implemented Universes, WebI Reports, Crystal Reports, QaaWS and Xcelsius Dashboards using best practices.
• Designed and configured BW queries and workbooks utilizing BEx functionality.
• Created reports in BEx Query Designer.
• Developed top 10% & bottom 10% customer’s dashboard using WebI, Live Office and Xcelsius.
• Developed complex dashboards using Dynamic Visibility functionality.
• Hands on BI launch pad.
• Developed FI Accounts Receivable aging report in webi.
• Interacted with users for customized and standard reports, gap analysis and associated solutions.
• Created multi-layered Xcelsius dashboards to display various components and included Filters, List View, table, Line, Column and Pie charts.
• Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP BI/BW, ECC systems as per the system landscape.
• Interacted with Project manager and end-users in architecting reporting solutions by understanding the requirements and writing universe, report and Dashboard specifications.
• Created BEx reports using filters, calculated key figures, and restricted key figures for use in BOBJ Tools like Universe Designer, webi, Dashboard designer.
• Created OLAP Universes on SAP data (Infocubes / BEx queries)
• Used Information design tool and SAP analysis edition.
• Created detailed reports with Drill-down capability using Web Intelligence in InfoView, worked on Ad hoc Query, Reporting, and Analysis.
• Broadcasted reports (Crystal and WebI) to individual recipients using InfoView scheduling functionality.
• Created roles/iViews in SAP portal for the users to access webi reports using single sign on.
• Used Import Wizard / Life Cycle Management (LCM) tool and transported objects - dimensions, measures, details, universes, connections, calendars, publications from Development to Testing to Production Systems.
• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Functions, Cross-Tab, Master Detail and Formulae.

SAP BI/BOBJ Consultant

Responsibilities:

• Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP BI/BW, R/3 systems as per the system landscape.
• Interacted with Project manager and end-users in architecting reporting solutions by understanding the requirements and writing universe, report and Dashboard specifications.
• Involved in installation and configuration of BO Enterprise XI components, Xcelsius, Crystal Reports, Live Office, SAP BI/ BOBJ Integration Kit.
• Requirements gathering, data modeling, planning/scheduling data extraction from source systems.
• Created OLAP Universes on SAP data (Infocubes / BEx queries).
• Created detailed reports with Drill-down capability using Web Intelligence in InfoView, worked on Ad hoc Query, Reporting, and Analysis.
• Broadcasted reports (Crystal and WebI) to individual recipients using InfoView scheduling functionality.
• Created detailed crystal reports using Formulas, Parameters and Grouping functionality.
• Created and enhanced InfoProviders, MultiProviders, Transformations, and Data Transfer Process and extensively worked on designing process chains.
• Enhanced the existing master and transaction data extractors in SAP R/3.
• Created BEx queries for reports in areas like Finance, Manufacturing and Inventory Management.
• Developed flexible queries using filters, navigational attributes, variables in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Used Import Wizard / Life Cycle Management (LCM) tools and transported objects - dimensions, measures, details, universes, connections, from Development to Testing to Production Systems.
• As a part of Production support involved in monitoring load failures, Delta loads, documenting and monitoring the performance of the system.
• Involved in End User-Training documentation, conducted User Acceptance events.

SAP BI Developer

Responsibilities:

• Created Generic extractors/Cubes/ODS/objects in BI.
• Involved in creating Data Sources, Info sources, and Transformation.
• Involved in extracting the data from SAP R/3 and Flat Files to SAP BI.
• Involved in activating various Business Content objects for extracting Master Data and Transactional Data from SAP R/3 into SAP BI.
• Enhanced existing master data and transactional data extractors.
• Worked extensively with loading Transactional data.
• Created Multi providers by defining to utilize the existing data of the Basic Cubes and enhance reporting flexibilities.
• Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to the required level of information.
• Worked on Restricted Key Figures, RRI Calculated Key Figures, Exceptions, Conditions, Variables and Filters.