We provide IT Staff Augmentation Services!

Bo Delivery Specialist Resume

EXPERIENCE SUMMARY:

  • 8 Years of IT Experience with 7 years in Business Objects tools.
  • I had worked extensively as BO Consultant in Data warehouse tools like Business Objects XIR2, XIR3.1, BI 4.1, and Dashboard Designer using Design Studio, Crystal Xcelsius 4.5, and Crystal Reports in both Onsite and Offshore model.
  • I have worked primarily in Manufacturing, Pharmacy, Telecom and Retail Domains.
  • My Technological expertise are Universe Design, Report Development and Design Studio Dashboard Development using BI tools.
  • In my previous assignment at Confidential, as a BO Consultant I am involved in SAP BO BW related development and sustain activities providing end - to-end solution in various stages of the project.
  • Possess high enthusiasm and unique ability to effectively learn the client’s business requirements and in the implementation of information systems.
  • Exposure to formal quality processes, strong foundation in SDLC Concepts.
  • Experience of developing Dashboards with SAP HANA, Bex Queries using Business Objects Design Studio.
  • Experience in developing Webi reports from universe and different source systems.
  • Designed and developed Business Objects universes (Reporting Universe) using UDT, IDT.
  • Experience in SAP Business Objects (BOBJ) Administration & Security
  • Experience in SAP BO Crystal Reports designing
  • Experience in supporting SAP BO/BODS applications.
  • Experience in designing BW queries using Query Designer.
  • Extensively worked in Web intelligence using combined query functions, sub queries, Grouping, Custom sorts and Calculation contexts.
  • Extensively worked in Designing (Defining Joins, Dimension, Measure, LOV, Hierarchies, Derived tables, Indexes and Resolving Loops and SQL Traps, Custom SQL) and Managing Universes (Linking, Deploying, and Securing & Maintaining) and involved in tuning the universe to meet performance and Multidimensional analysis.
  • Managed CMC, Repository, Web Intelligence, Desktop, Destination, Program Job and Event Servers and Designed security model for users to access the report.
  • Hands on Experience in Scheduling, working with LOV Objects and Deploying a System and Hands on Experience in Migrating BO 5.x & 6.x to BO XIR3 Using Import Wizard Workshop
  • Publishing and Scheduling objects through CMC and Mapping third-party accounts to Business Objects Enterprise
  • Extensive knowledge in designing the schemas in Dimensional modelling, SQL tuning and in Data warehouse Concepts and Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures written in Oracle and SQL Server.

TECHNICAL SKILLS:

OLAP Tools: Business objects 6.5.2 / 5i, BO XIR2,XIR3.1,BI 4.1,Crystal reports XI,2008, Crystal Xcelsius 4.5, CMC, Business Objects Design Studio 1.6, SAP BW 7.5,HANA

ETL Tool: SAP BODS (3.2),BODS 4.0

Operating Systems: Windows 98/2000/XP/7

Data Bases: Oracle 10g, Ms SQL Server 2008

Package Application: Callidus Software (TrueComp Reporting & Analytics)

Languages: C,C++, C#.net,ASP.net, HTML,SQL/PLSQL

Workflow tools: MS-Excel, MS-VISIO, MS-PowerPoint, MS-Word

ASSIGNMENTS:

Confidential

BO Delivery Specialist

Responsibilities:

  • Worked on developing EWM Analytics Dashboards using SAP HANA and BW Bex Queries.
  • Worked on Source to Pay, Vendor Cleansing Dashboards for Confidential Supply chain management.
  • Worked using Confidential Specific Design Studio template in developing the Dashboards.
  • Worked on developing Sustain KPI Dashboard for GSPR team using SAP BI Design Studio, Dashboard deals with different KPI’s related to the sustain activities for Confidential .
  • Sustain KPI Dashboard involves key functionalities of Design Studio like On Boarding screen for users to select the required KPI’S, Lasso charts, Keep/Exclude for the Infocharts, Global Filters, Show/Hide targets on click of icons, navigation from summary to details tab on click of charts etc.,
  • Worked on CSS files for different requirements of the app like hiding infochart legends, adding Icons, modify panel borders, removing chart labels, override conditional formatting for waterfall charts etc.,
  • Sustain KPI Dashboard has different design studio components like Dropdowns, Grids, Text Boxes, Radio buttons with switch between different views of the data, Navigation panel for users to analyze the data.
  • Incorporated functionalities like export and feedback about the app by the users.
  • Developed Sustain KPI Dashboard as Auto Responsive to make the app fit as per the user’s screen resolution.
  • Worked for Confidential Waters North America- VISICOM Reporting, NWNA Visicom Reporting deals with MARKETING AND SALES Department of NWNA.
  • Reports are designed to capture the daily activities of sales representatives visiting the customers and the activities they perform in the field.
  • Developed complex webi reports like NWNA Productivity, NWNA KARI and OP Market review reports using HANA based universe.
  • Developed Webi reports using calculation contexts, subqueries, combined queries, relative date functions, merged dimensions, hyperlinks, passing values from one query to other query in the query panel. etc.,
  • Worked on developing NGBS Dashboard for NGBS team using Design Studio, Development involves Cost Savings and Cost per FTE charts with comparison between previous and current years across different centers and streams.
  • NGBS Dashboard involves key functionalities of Design Studio like Lasso charts, Keep/Exclude for the bar charts and Waterfall charts, Global Filters, Tiles showing the summarized key figure values etc.,
  • NGBS Dashboard has different design studio components like Dropdowns, Grids, Text Boxes, Radio buttons with switch between different views of the data.
  • Developed NGBS Dashboard as Auto Responsive to make the app fit as per the user’s screen resolution.
  • Worked on Task summary report using webi, this report deals with all the tasks Involved in implementing a change request as per Confidential Standards.
  • Developed the report using outlines, sections and hyperlinks.
  • Worked on ADMS Dashboard delivering 5 key KPI’s for the client using web intelligence and Information Design tool.
  • Creating Web Intelligence Reports from universe, BICS connection and Excel source files.
  • Creation of Universe using IDT, UDT from Database, Excel and BW Source systems.
  • Created Monthly Governance KPI Dashboard with stacked column chart using BICS Connection, Excel Data sources for Confidential and TECHM management.
  • Worked on Webi reports with charting, Grouping, Sorting, Alerting, Field highlighting, Drill-Down, Parameter prompts, Used Cascading LOV’s.
  • Worked on predefined conditions, Scope of analysis, Alerters, global and report filters, Hyperlinks and Element linking and combined queries.
  • Worked on analysing Incompatible objects, worked on creating merged dimensions .
  • Created Dimensions and Measure Objects, Resolved Loops and Traps, used List of Values, Applied Restrictions on Objects, used @Functions, Hierarchies, Derived Tables.
  • Worked on creation of new secured folders for Markets.
  • Working on Service requests for project specific requirements.
  • Worked with business users, involved in gathering requirements for the development and Functional Specs from the Market.
  • Created the Technical Specification and build specs for creating the Webi reports and universe.
  • Developed vertical, horizontal, Cross tab reports as per the Functional Specs.
  • Testing of the developed reports for Format data, database accordingly for UAT.
  • Deployed the reports, universes, and connections.... etc. to different environments after the validation of market.
  • Packing of the BIAR files using the Import Wizard, Promotion Management and deploying accordingly as per the request.
  • Gathered the information for scheduling of the developed reports as per the markets for different users accordingly to the Timings.
  • Analysing the maintenance issues and providing the solution for the tickets.
  • Pointing the report connections as per the BW required systems.
  • Involved in testing the reports. Tested and verified the result set of SQL query of the Web intelligence reports in database with application.
  • Scheduling of the Reports as per user requirements.
  • In, Maintenance involved in detecting the issues in the universe and tuning as per the user request, performed the check Integrity and exported to the repository.
  • Involved in Hyper Care support activities for maintenance and on different AG’s for supporting process.

Solution Environment: Oracle 12g,SQL server 2008, SAP BI 4.1, SAP BW 7.4,Windows 10,HP Service Manager

Confidential

BO Support Analyst

Responsibilities:

  • Incident management for all types of severity tickets raised by the customers with in the SLA time provided by the client.
  • Supporting BO- universe, WEBI, Xcelsius and crystal reports for about 20 client applications.
  • Supporting BODS for ETL applications by analysing the job failures in production environment and providing solutions in time.
  • Creating change tickets and submitting approval mails to the respective teams whenever a change is planned on BO/BODS environment for a specific task.
  • Working on different service requests raised by the client in all the DEV/TEST/PROD environments.
  • Working on monitoring the servers for memory usage to alert when required and the Usage is high.
  • BODS Code migration between DEV - TEST- PROD environments by Using the. atl files provided by the application team.
  • BO universe and reports migration between DEV - TEST- PROD environments by Using the import wizard.
  • Working on minor development enhancements for BO and BODS when required for the client at a particular application.
  • Involved in CMC user security setup and report publication and scheduling activities for all types of reports involved in the application.
  • Involved in the all kind of maintenance activity like user creation, user restriction, folder level maintenance, server maintenance, instance maintenance etc., through CMC (Administrator).
  • Involved in restarting the SIA and Tomcat servers in all the environments to reflect any changes done or to resolve any issues.
  • Monitoring the report schedules in production environment to alert if any discrepancies found in the deliveries.
  • Involved in enterprise account creation for users and assigning them to the group with appropriate access levels required.

Solution Environment: IBM Maximo Tool, Oracle 10g,SQL server 2008,IBM DB2 client,BOXIR3,BO4.0 (Designer, Web intelligence, Crystal Reports, CMC, Performance Management-Dashboard Designer), Data Integrator BODI 3.2, Crystal Xcelsius 4.5, Windows XP

Confidential

BO Consultant

Responsibilities:

  • Functional design Walkthrough and Technical documentation for reporting requirements
  • Design and development of complex Reports using Crystal Reports 2008 and Oracle 11g
  • Writing Packages, Stored Procedures using Toad and SQL Developer
  • Validation of Reports and SQL queries.
  • Integration of Reports in Callidus Portal into Reporting and Analytics
  • Implementation of Reports in Business Objects - Central Management Console (CMC).
  • Unit test case preparation and unit test case execution
  • Code migration between QA and DEV and UAT environments.
  • Involved in the Product Testing, Integration Testing and defect fixing.
  • Interaction with TrueComp and Informatica team for datamapping and ETL requirements.
  • Involved in CMC user security setup and report publication activities.
  • Involved in publication tools for schedule and send the reports to user’s inbox and user’s mailboxes as a bulk of classified reports.
  • Involved in the all kind of maintenance activity like user creation, user restriction, folder level maintenance, server maintenance, instance maintenance etc., through CMC (Administrator).

Solution Environment: Oracle 10g,PL/SQL,BOXIR3 (Crystal Reports, CMC,Import Wizard),Informatica, Truecomp, Windows XP

Confidential

BO Consultant

Responsibilities:

  • Communicating with Business Users to understand and consolidate reporting requirements across functional areas like sales and finance
  • Understanding the user Requirements and involved in Low Level Technical Specification documents for all the Webi and crystal reports.
  • Generated metadata and Universe from BODI/DS
  • Developments of Crystal Xcelsius components Grids, Pie charts, Bar Charts for those components.
  • Created QWaaS connectivity to Universe for refreshing Xcelsius with current data Designed Universes out of Transient ODS and Persistent ODS for Adhoc and Standard Reporting respectively and Involved in Preparation of BO Factory assets for Confidential and created traceability matrix for report objects
  • Created charts using combined query and sub query approach and used merge dimension for multiple data providers and synchronised drilling between different blocks.
  • Created Hierarchy for the LOV in Designer and used Cascading LOV in Web intelligence and also created Reusable LOV, Reusable filters and used Custom SQl in Designer.
  • Created the webi reports using Business Objects functionalities like Alerter, sorts and Creating the Formulas and Variables, Using conditions, functions.
  • Designed Reusable interactive objects and used Derived tables and involved in setting up Multidimensional analysis, granting access to Universe, Object level security, Setting Restriction Priorities and also worked with multiple designers & metadata Integration.
  • Used outer joins to retrieve the data and used self-joins, Complex joins and sub queries to meet the report requirement.
  • Designed crystal reports as per client requirements.
  • Developed stored procedures and performed execution for crystal report data population.
  • Involved in CMC user security setup and report publication activities

Solution Environment: Oracle 10g,BOXIR3 (Designer, Web intelligence, Crystal Reports, CMC, Performance Management-Dashboard Designer), Data Integrator BODI, Crystal Xcelsius 4.5, Citrix, Minitab, Windows XP

Confidential

BO Consultant

Responsibilities:

  • Design and Development of Business Objects Universe from Database and WEBI reports
  • Involved in the universe level table mapping document, which includes the all the list of tables to be part in the universe, mapping details, ER diagram details, Join level mapping to compare with the core table in the DB, data flow in the DB, universe level hierarchy details.
  • Tested Context in Designer for inferred, incompatible and ambiguous queries and applied restriction on object and created time hierarchy and custom hierarchy on the objects
  • Involved in different type of report creation like various kinds of formulae, variables, crosstab, and user defined prompts as per the user choice.
  • Involved in setting a default destination for the Program Job server and event based scheduling and involved in creating categories.
  • Created link between parent and child report and created drill down, up, by, across & to detail and involved in setting scope of analysis and used multiple cross tabs to meet the report requirement.
  • Involved in the Product Testing, Integration Testing and Bug fixing.
  • Involved in creating rules and automated dashboards using performance management scheduler and created selectors (List box selectors, radio button and drill down functionality using crystal Xcelsius.
  • Hands on experience in Import Wizard for creating the BIAR files which promotes into client UAT server.

Solution Environment: Oracle 10g, Data Integrator BODI, BOXIR2 (Designer, Web intelligence, CMC, Performance Management-Dashboard Designer, Citrix, Windows XP)

Hire Now