We provide IT Staff Augmentation Services!

Sap Bo Lead Consultant Resume

SUMMARY:

  • Around 8 years of experience in Business Intelligence and Business Objects (BOBJ) as a technical consultant playing various key roles in Design, Development, Upgrade and Support Projects.
  • Worked across different versions of Business Object tool - BI 4.2,BI4.1, BO XI 3.1/R2/R1/ 6.5.1, SAP BW on Windows and UNIX Environments.
  • Extensive experience and understanding of Data Warehousing, Star Schema, Snow Flake Schema, Dimensional Modeling, Entity-Relationship Modeling, OLTP and OLAP concepts.
  • Worked as Team Lead for creation of frameworks for reporting, dashboards, delivery, scheduling and object retention policies for complex information systems
  • Promote content from development to test to pre-production to production environments using promotion management and Rev Track after testing and user signoff.
  • Experience in business objects administrative activities including creating User groups, restricting documents to certain group of user, Promotion management, setting the access levels and others identical tasks.
  • Responsible for setting the standards and following the best practices in writing codes, test scripts/cases and technical specification documentation.
  • Expert in Information Design Tool (IDT) and have worked extensively creating data foundation and Business layer on database like HANA and Oracle.
  • Setup row level or column level security on universe to restrict data access to certain users or user groups.
  • Experience in BOBJ 4.0/4.1 building universe on top of Cube/DSO using Universe design tool.
  • Extensively Worked on SAP HANA Modeler (HANA Design Studio), Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytic Privileges and Stored Procedures.
  • Worked with SAP engineers to troubleshoot product defects effectively and request hot fixes for critical product bugs.
  • Enable auditing features on each of the business objects servers in production to analyze or track the usage of reports and other actions.
  • Highly worked on implementing automated bursting of Reports via Publication services
  • Performed Proof of Concept and worked on Translation Management in Business Object Tool to provide the multilingual reporting service.
  • Proficient and extensive knowledge on dashboard designing tools like QlikSense /Qlikview/Tableau/Lumira.
  • Proficient in creating Explorer Reports, OLAP Analysis Report on HANA Analytical View, OLAP Analysis On Bex query and Info Cube.
  • Worked on creating Hyperlink Reports by parameterizing URLs with the OpenDocument syntax.
  • Business objects upgrade experience, includes 3.1 to 4.0 and 4.0 to 4.1 to 4.2.
  • Expert Level knowledge in creating Universe based WEBI BOBJ 4.2 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls, hierarchies and drilling in BO, Merged Dimension Feature to combine Universes and creating a single document on the same..
  • Created Custom events, File Events and Scheduled Events in CMC for event based Scheduling of the Reports.
  • Experience in Production Support, resolving severity tickets using a Connect Now ticket management tool and Defect Resolution/CR through HPALM Tool.
  • Provide technical support, guidance and documentation to end users; provide immediate fixes remotely on critical issues
  • Attended Qlikview Developer Class room Training. Created data models and App design using QlikView. Extracted data through multiple data sources in QlikView and generated QVDs as required.
  • Experience in SQL, PL/SQL and very good exposure to Oracle 11g/10g/9i

PROFESSIONAL EXPERIENCE:

SAP BO LEAD Consultant

Confidential, NJ

Responsibilities:

  • Managed entire project lifecycle (BO) - requirements gathering through implementation including: preparing the functional, scope, mapping documents and high level and low level design specification documents
  • SAP BO Team lead for creation of frameworks for reporting, dashboards, delivery and scheduling.
  • Involved in Creating Relational database connection, Data foundation layer, Business layer on top of HANA Views.
  • Extensively Worked on SAP HANA Modeler (HANA Design Studio), Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytic Privileges and Stored Procedures.
  • Created various reports with functionalities like Cross tab, Embedded Summary, Charts, Graphs, and sub reports.
  • Worked in setting up row level or column level security on universe to restrict data access to certain users or user groups for different member firms.
  • Created various Linked and Unlinked Sub Reports and managed the parameters accordingly.
  • Extensively worked on migration reports using Promotion management and transporting objects between BO three tier landscapes through Promotion via CTS and Rev Trac.
  • Configured and enabled the SSO using the Windows AD Authentication.
  • Involved in assigning Business Objects Authentications and Authorizations, Creating/Administrating Users & Groups, designated their Security Levels in CMC, assigned Roles, & Access Levels on the Applications and folders.
  • Created the Test cases, Test Strategies and executed the Unit Testing and the UAT for the Entire environment.
  • Lead the POC for QlikView/QlikSense on HANA Views.
  • Defect resolution through the HPALM Tool.

SAP BO/ BI on HANA Consultant

Confidential, PA

Responsibilities:

  • Involved in gathering business requirements from user and understanding the business logic.
  • Worked as a Team Lead for Business Object reporting, Involved in Onsite - Offshore Support Module coordination to ensure 24/7 support.
  • Responsible for understanding end user requirement and involved in preparing project plan.
  • Handled the Conversion of reports based on legacy BW to HANA BW System.
  • Created HANA views for the material master tables for master data reporting, Sales Distribution/Pricing catalogue Contract Compliance exception Report.
  • Lead the POC on Translation Management in Business object to provide the multilingual reporting services globally.
  • Experience working with Information Design Tool for building Business layer on top of HANA views and Universe on top of Cube/DSO.
  • Worked on the issues in Business layer on HANA Views such as Key And text display for the PLACEHOLDER variable on Views.
  • Developed Audit reports for the BO Repository by using/Modifying Audit universe.
  • Involved in end to end development of Business Object reports.
  • Designed, developed, maintained and tested universes for supporting ad hoc queries and canned reports according to the business requirements.
  • Developed Dashboards on Qlik Sense/Qlik View/Lumira/Tableu.
  • Designed the BEx Queries in the BW Environment.
  • Developed WEBI Reports on UNX, UNV, BICS, Excel as a datasource
  • Developed Explorer Reports on HANA to handle huge amount of data anlaysis., also developed OLAP analysis and hyperlink reports.
  • Developed WEBI reports for Visualization of data including Pie Charts, Line charts, Graphs.
  • Implemented automated bursting of Reports via Publication services
  • Created Complex Reports by combining two or more universe through Merged Dimension Functionality to avoid any Backend flow changes
  • Provides Estimates for design, test and implementation phases, ensuring Quality and accuracy is maintained.
  • Created detailed standard documentation containing all technical steps and prepared end users training documentations, also provided training to users for the self-servicing functionality of business object reports.
  • Involved in Modifying and Performance tuning of the Existing Reports.
  • Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
  • Maintained Technical Design Documents for Universes and Reports.
  • Developing testing strategies for efficient and error free testing (like preparing Unit Test plans and doing Unit Test reviews).
  • Developing Custom solutions for the issues/defects encountered by business users.
  • Creating Custom events, File Events and Scheduled Events in CMC for event based Scheduling of the Reports, creating Notifications for all the Scheduled reports for their success and failure.
  • Defect Prevention activities using CHARM.
  • Experience with CHARM change management tool to follow the Process involved in migrating objects from lower landscape to higher.
  • Experience with MAXIMO and Connect now ticket management tool for the efficient support structure.

SAP BO/ BI on HANA Consultant

Confidential, PA

Responsibilities:

  • Analysis & Study of Business Requirements, Technical & Functional Specifications.
  • Creating Universes and Webi Reports in Business Objects.
  • Migrating Reports/Universes/Connections from One Environment to another Environment.
  • Creating the Technical Design Documents for Universes and Reports.
  • Developing testing strategies for efficient and error free testing (like preparing Unit Test plans and doing Unit Test reviews).
  • Solving queries/issues raised by users.
  • Resource Management and Onsite-Offshore coordination.
  • Doing Impact analysis of the new requirement or change request on the existing programs initiated by the client.
  • Developing suitable solutions, alternatives and options.
  • Constructing or Changing the Reports/Universes as per requirements provided by the clients
  • Developing Custom solutions for the issues/defects encountered by business users.
  • Providing Estimation/Efforts for the various Change Requests and New Development Activities.
  • Communicating with Client.
  • Defect Prevention activities using HPQC(HP Quality Control).

SAP BO HANA Consultant

Confidential

Responsibilities:

  • Worked on Deski to Webi Conversion tool.
  • Converted all the DESKi reports to Webi Reports.
  • Resolved the issues encountered during the conversion and the functionalities which was not able to get convert to WEBI Reports.

SAP BO HANA Consultant

Confidential

Responsibilities:

  • Involved in collecting requirements, Interacted with prospective clients to gather their analytical requirements.
  • Responsible for understanding end user requirement and involved in preparing project plan.
  • Analyzing the requirement and preparing the execution plan.
  • Created Online Surveillance report on Oracle Timesten server.
  • Preparing Reports as per client requirement. (Tools Used - BO 6.5) on Stored Procedure.
  • Resolving current issues related to Reports
  • Creation of Tables/Packages/Procedures/Views(Tools Used- SQL Navigator & TOAD).
  • Created shell scripts to load data from file to table.
  • Performance tuning of SQL Procedures.
  • Support in daily Operation of Confidential and United stock exchange.
  • Analyzed SEBI Business Requirements and created Materialized Views for the Reporting need.
  • Created BO reports for the United Stock exchange Currency Module.
  • Created new repository, Users In BO 6.5
  • Experienced DB2 BO reporting.
  • Solving queries/issues raised by users.
  • Creating the Technical Design Documents for Universes and Reports.
  • Developing testing strategies for efficient and error free testing (like preparing Unit Test plans and doing Unit Test reviews).

Hire Now