Certified Business Objects Developer,Tableau,, BO Universe, BO Report

Beneeta Jeyaseelan

eGrove Systems Corporation

*****@*********.***; Ph: 732-***-****

Summary

Over 7 plus years of analysis, design & implementation of different Data warehouse projects in Banking, Retail and Publishing sectors with Expertise in data warehousing projects with extensive usage of Business Objects XI 3.1, XIR2 (Desktop Intelligence, Universe Designer, CMC, BO Dashboard Builder, WebIntelligence, Import Wizard, LCM), BI4.1 (Webi report development and universe designer), Tableau, SQL, ORACLE, and various BI tools.

3+ Years of Experience in Agile Software Development Methodology/Scrum processes including Creation, Estimation of tasks, backlog maintenance and sequencing in JIRA dashboard, burndown charts, releases, estimating tasks, retrospective meeting and setting up sprint milestones etc.

BO Universe Enhancement, migrations of Universes and Reports among different environments like Development, QA and Production

BO Reporting - Creating Universe based reports, Freehand SQL and creating Ad-hoc report and scheduling reports.

BO Performance and optimization - Universe Reengineering and Performance Improvement of Reports.

BO Supervisor - Having good experience Creating users and user groups and maintain different domains in repository

Worked in all the phases of SDLC Lifecycle.

Writing technical documentation related process and handling of documents using Confluence.

Academic Qualification:

Bachelor Degree in Engineering – B. E.(Electrical and Electronics), Anna University. India – Year 2009.

Certifications:

Infosys Certified Programmer Business Objects XI3.1.

Certified Microstrategy Report Developer. Undergone vendor training in Microstrategy for project design, report development and dashboard designing.

Achievements:

Developed a real-time reporting solution that will perform the payment reconciliation on the fly and reduced manual effort. In turn this solution removes the penalty fee risk to zero.

Attained new business to Infosys by Identifying risks and performance issues for enterprise reporting and performed Re-engineering of the current reporting environment (universe) to client.

Proposed service improvements for the betterment of the lifecycle management process

Automated configuration control processes and version control to organization specific configuration control tool improving efficiency by 25%.

Technical Skills:

BI Tools

Business Objects XI 3.1 - Desktop Intelligence, Web Intelligence, Universe Designer, Import Wizard, Life Cycle Manager, Dashboard Builder, BI4.1 – Web Intelligence and Universe Builder.

Tableau.

Secondary Skills

Microstrategy Enterprise Reporting, SQL Server Reporting Services.

Databases

Oracle9i-11g, SQL

Professional Experience:

Senior BO Developer, Infosys Feb 2010-Dec 2017

Project Name:

PepsiCo – Crystal reports to WebI reports conversion

Client:

PepsiCo

Business:

PepsiCo is a global leader in food and beverage industry.

Description:

BO Reports developed are used to conduct analysis that may increase its competition power and create areas of opportunity by producing accurate and consistent reports and analysis ensuring consistency between the systems. The reports has tables, charts, crosstabs and graphs that represent the trend of the current and historic business data from various dimensions which helps in efficient decision making.

Role:

Senior BI Developer.

Technology:

BI4.1 report development, Oracle 11i, Tableau.

Responsibilities:

Designed and Developed Universes against Oracle warehouse

Reports requirements gathering by Communicating with users & Team and designed technical and functional specifications.

Developed different BO reports using data providers like, Universe, Free hand SQL.

Scheduling & maintaining reports in CMC also using file watchers (Event Based Reporting)

Designed and developed ad-hoc reports

Supporting users and do the analysis as per requirements

Creating & Migrating the reports, testing them in different environments (Dev, UAT & Prod)

Dashboards designing with Tableau.

Project Name:

Business Intelligence Support - Enterprise Business Objects Reporting

Client:

Elsevier

Business:

Elsevier is a leading Journals publishing company which publishes science and medical journals.

Description:

Business Objects is used for reporting on the various applications used in Elsevier for publishing. Some of the main applications interfaced with Business Objects for reporting are

Oracle Financials: Financial application used within Elsevier for Account receivables/Payables, General Ledger. All the financial information within Elsevier has been maintained within this application. Instrumental in creating reports for the

Business Community to review the financial information in the system.

PPM: Product Planning and Management. Application to manage production process of Books.

MAXIM: Application that manages the advertisements that are being placed in the books/journals of Elsevier publications.

MAS/MAS SCOPUS: Bibliographic system that maintains citation counts of journals/books/authors.

AFP: Author Feedback Program

SIS: Sales Information System

Marketing Systems: Campaign management

eTax: Taxation system within Elsevier

PTS: Production Tracking System for Journals

Electronic Warehouse: Central warehouse for all the Production systems within Elsevier

Role:

Onsite Project Lead, Senior BI Developer.

Technology:

Business Objects XI3.1, Oracle 11i, Serena Dimensions (CC)

Responsibilities:

Creating, developing, maintaining and testing the Universe for running the queries against the Database.

Involved in Installation and Configuration of all products of Business Objects.

Created Repository and assigned privileges to users and groups. Performed Content Management (25 universes, 18 applications, 500+ reports) and user management (2000 business users) and rights management.

Performed universe creation and enhancement for the report changes requested and new reports development. Analyzed the existing database and designed Universes using Designer module.

Used various data providers like Freehand SQL and Stored Procedures to extract data from different sources and tuned for better performance. Resolved loops by creating Aliases & Contexts and checked integrity of universes.

Involved in development and deployment of Reports with complex logic and calculations.

Release Management – Performed release planning, implementation and post deployment support. Experienced in using Life Cycle Management tool and Import Wizard for moving universes, reports, users and security setup between environments like Dev, UAT and Prod.

Configuration Control and Version Control Anchor – Set up configuration control process for enterprise reporting enhancement requests.

Worked with SAP vendor for architecture design and issues resolution.

Sub Projects –

a. Created Dashboards in Business Objects XI 3.1 Dashboard Manager.

b. Migration Testing from Business Objects XI R2 to XI 3.1

c. Installation and service pack upgrades of BO XI3.1

Project Name:

OPSBANK II Enterprise Reporting Set Up

Client:

Elsevier

Business:

Elsevier is a leading Journals publishing company which publishes science and medical journals.

Description:

OPSBANKII application handles the data of the sources and publications of Elsevier at source, volume, issue and article level and captures the input and output activities of the company. Business Objects reports running on OPSBANKII application data pre-processed on an ETL layer helps in decision making of the company from various dimensions.

Role:

Senior BI Developer.

Technology:

Business Objects XI3.1, Oracle 11i, Serena Dimensions (CC)

Responsibilities:

Reengineering of the universe and performance tuning of reports has been proposed and implemented successfully.

Twenty BO Reports has been developed on the reengineered universe, tested on Dev, UAT and Prod environments and delivered successfully to the customer.

Deployment and Security Set Up – Performed security set up for delivery of critical OPSBANK reports and for migration of legacy reports from legacy system. Set up run and delivery schedules. Prepared plans to handover to support team

Business Value Additions -

a. Prepared Data Model for OPSBANK II reporting environment for reference of reporting team as a critical addition to client knowledge base.

b. Automated configuration control processes and version control to organization specific configuration control tool.

c. Set up FTP storage space for report schedule delivery.

d. Set up Elsevier, CBS and Infosys knowledge space for OPSBANK II Reporting on share point.

Project Name:

Global Aggregated Disclosure (GLAD) Reporting.

Client:

Royal Bank of Scotland, London

Business:

The Compliance Monitoring team has implemented Global Aggregated Disclosure application (GLAD) for disclosure of substantial shareholdings, as well as to other internal and external parties to satisfy any information requests. Its data sources are the Bank’s golden sources for equity trading positions and Bloomberg for listed securities.

Description:

Business Objects reporting application has been used to filter and enhance the data received

from GLAD Application. The Compliance team then provides reports to the RBS Share Aggregation Unit for disclosures.

Role:

BI Developer.

Technology:

Business Objects XIR2, Oracle 11i.

Responsibilities:

Reports requirements gathering and designed technical and functional specifications.

Setting up and Customizing BO servers.

Customizing Infoview

Designing and Developing the Universe schema.

Creating & Migrating the reports & SQL scripts, testing them in different environments (Dev, UAT & Prod)

Developed different BO reports, like Exception reports for excluding securities, Exposures report for reporting trades that breach certain pre-defined conditions. The reports were built using Universe and Free hand SQL (To Improve Performance).

Scheduling & maintaining reports using event based conditions to be triggered after the batch run is complete.

Maintaining BO CMC module (Repository, users etc)and supporting full life cycle.

Profiling and applying security for the reports at object level to lock down the data such that users can view the data that only they have rights to.

Contact this candidate