Bhagavathi S Pandian

BI_BO Developer

Mob : 540-***-****

acgi3u@r.postjobfree.com

Summary :

. Over 6.5 years of experience in Information technolgy with strong work

experience as Business Objects Developer.

. Extensive experience in Analysis, Design, Development, Implementation,

Deployment and maintenance of Business Intelligence applications.

. Knowledge of Datawarehouse Concepts and metholodies.

. Expertise in Business Objects enterprise Products (Universe Designer,

Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM) and

its deployment

. Expertise in identification of Business and Data requirements and

converting them into conceptual and logical data models.

. Experience in building and retrieving data using Universes, Personal

data files, and creating complex ad-hoc Reports using the Business

Objects suite applications.

. Extensively used advanced reporting functionalities such as Master

Detailed,Drill, Filters, Ranking, Sections, Graphs and Breaks.

. Hands-on experience in developing

Analytical Dashboards using Xcelsius withQaaWS and Live

Office connectivity.

. Strong database experience in using Oracle 10g/9i/8i, MS SQL Server

2008/2005, MS Access

. Exposure to Dimensional Data modeling- Star Schema

modeling andSnowflake modeling.

. Participated in all phases of Software Development Life Cycle

SDLC(Requirement Analysis, Design, Development, Testing and

Documentation).

. Possess excellent communication, decision-making, Problem Solving,

Analytical, and Interpersonal skills with result oriented dedication

towards goals. Capable of working as a Team Member or Individually

with minimum supervision.

Technical Summary:

Business Objects Tools: Business Objects XI 4.0, XI 3.1/3.0, XI R1/R2,6.5,

Web Intelligence XI 4.0, XI 3.1/3.0/XI R2, Universe Designer XI 4.0,XI

3.1/3.0,XI R2, Desktop Intelligence, InfoView, CMC, Import wizard, Report

Conversion Tool, Data Integrator 11.5/XI 3.0, Xcelsius 2008, Query as a Web

Services(QaaWS), Live Office,Xcelsius, Crystal Reports and ETL Informatica

Powercenter.

Databases : Oracle 10g/9i/8i/8.0, MS SQL Server 2008/2005, MS Access.

Data warehousing : Star-Schema Modeling, Snowflakes Modeling, FACT, dimension

tables.

Windows Utility : MS-Word, MS-Excel and MS-PowerPoint.

Programming Languages : SQL, PL/SQL, JAVA, HTML, C, C++

Dimensional Data Modeling Tools : Dimensional data modeling using Erwin

modeling (Erwin 4.1/4.0/3.5.5/3.5.2), Physical & Logical Data Modeling,

multidimensional modeling, Snowflake Schema/ Star Schema modeling

(Normalization / De-Normalization Techniques), Erwin, Visio.

Experience :

Inova Health Systems, VA

Role: Sr.Business Objects Developer

Oct'13 - Sep'14

Inova Health Systems is a major health care provider in Northern Virginia.

The Supply chain Data Ware House receives data feeds from disparate

clinical, financial, and operational information systems. Business Objects

suite is used to mine, analyze and report on this data to retrieve the key

metrics required to measure and thereby reduce costs, streamline operations

and improve patient care by management.

Responsibilities:

. Inventory, Accounts Payable and Purchase Orders were the different

subject areas within the data warehouse.

. Used advanced universe functionalities like Derived tables, Index

Awareness, custom LOVs.

. Created custom hierarchies to aid in Drill-Through analysis of WebI

documents and built cascading prompts.

. Participated in the complete development lifecycle: analysis,

design, build and test reports

. Created several complex Web Intelligence and Desktop Intelligence

reports to help management to track and monitor contract, commodity

and price compliance.

. Created reports linking several universes for different subject

areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory

for seamless reporting.

. Created user Prompts, Conditions and Filters and used Alerts to

improve the readability of the report. Extensively used

Calculations, Variables, User Objects in the creation of reports.

. Created User Prompts, Conditions and Filters to improve the quality

of report generation.

. Scheduled Reports using scheduler Infoview as well as CMC.

. Key metrics 'procure to pay cycle times', 'diversity spend', 'cash

discounts captured and missed'

spanning across different subject areas has been re-created using

Xcelsius.

. Consolidation of reports by groups/regions and designing templates

catering to the needs of sourcing/financial analysts & material and

cost specialists.

.

Providing support for the users on application usage and conducting

training walk through of salient features of the application.

Environment: Oracle 10G, Business Objects XI 4.0/3.1, Web Intelligence and

Infoview XI R2, Desktop Intelligence, CMC, Import Wizard, Universe

Designer, PL/SQL Developer, Windows 2003 advanced server.

Kaiser Permanente, LA, CA

Jul'12 - Sep'13

Role: Business Objects Developer

The main objective of this project is to develop Web Intelligence Reports

wherein the data from the users are loaded in the Informatica table. This

sorted data is being used for BO reporting. Depending upon the user

requirements, the Universe is built using the most relevant tables and the

reports are generated with certain conditions which is required for the

report.

Responsibilities:

. Gathered requirements from users and documented it as mockup reports

and technical specification documents.

. Actively interacted with various functional groups, project teams and

other stakeholders to effectively understand the business requirements

and create documentation.

. Refined data findings and interpret again to drive data-based insight.

. Provided guidance on what data to capture; how to map data needs to

business questions.

. Held meetings with internal and external teams (business, QA, dev,

vendor) to drive consensus across business and system needs.

. Created process flow diagrams and use cases.

. Created business requirement document and Functional specification

document and got sign-off from various stakeholders.

. Engaged in JAD sessions with development team and involved in User

Acceptance Testing.

. Involved in deployment of various releases and bug fixes.

. Designed Libraries and Report Templates which is used by other reports

. Created new reports, Master Detail Reports and Parameterized Reports

using Sequential, Conditional, Group and Parallel Reports sections

. Extensively worked on Page Level Security, Data filter, Combined Data

Stream, Data Sorter and other objects

. Published Crystal Reports on to Business Objects Infoview and provided

access to the end users.

. Created User test cases and ran SQL to test report values and to

reconcile values of our reports with existing operations report.

. Created test scripts for testing reports.

. Created presentations to discuss the process flow and mockup reports.

. Created training guide for end users.

. Used Remedy tool Remedy Incident Management and Service Management.

. Worked in a matrix environment wherein teams where present in an

onsite-offshore model.

Environment: Business Objects XIR3.1,BO 4.0, MS-Excel, Oracle 10g.

Bakers College,MI

Jul'11 - May'12

Role: Business Objects Consultant

The major objective of this project is to create Web Intelligence Reports

with the data avaliable from the informatica table. The Reports are created

in accordance with various criteria for technical analysis based on the

history of records.The Universe is created with the historical data and the

reports are generated with the usage of the most relevant tables.

Responsibilities:

. Interacted with Business Users, Business owners to know their

Business requirements in developing and modifying Universes and

Reports accordingly.

. Involved in gathering, analyzing, and documenting business

requirements, functional requirements and data specifications

for Business Objects Universes and Reports.

. Working on the SQL tuning and optimization of the Business Objects

reports.

. Applied security features of Business Objects like row level, report

level & object level security in the universe so as to make the

sensitive data secure.

. Designed and maintained complex Universes, resolved loops by

creating aliases and contexts.

. Exported the ad-hoc ready universes to the for making semantic

layeravailable to the users.

. Extensively used the @functions and Aggregate Aware feature. Worked

on back end views, tables required by the business objects

universes.

. Created and defined the Hierarchies for various reports based on the

Business rule of the Organization.

. Created Xcelsius dashboard for executive view covering selected KPI

for the business function

. Created WSDLs using Query As a Web Service (QaaWS) from different

Data sources.

. Migrated Xcelsius dashboards and deployed QaaWS to the new servers

and fixed the hyperlinks and excel spreadsheet to be compatible in

new environment.

. Troubleshoot errors for reports, dashboards, and universes. Fixed

them to work as per the business needs.

. Created complex reports by linking data from multiple data

providers, stored procedures and functionalities like Union Queries,

Drill Down, Master Detail, Custom Sorts etc.

. Extensively worked with Ranks, Alerter, filters, prompts, variables

and calculation contexts in designing reports.

. Built WebI reports Provided OLAP functionality and worked

extensively with data warehousing.

. Set up groups and users for Business Objects deployment.

. Created the Web Intelligence Report and used Events for Daily/Weekly

/Monthly Scheduling of the reports.

. Extensive testing and migrating the reports or objects from

development to Production system.

. Developed testing scripts and test cases. Extensively tested

Business Objects reports, dashboards and other Business Objects

Applications in new environment.

. Involved in performance testing of all the reports, which helped in

analyzing its performance before moving into production.

Environment: Business Objects XIR3.1, WebI, Xcelsius, Universe Designer,

Oracle 8i/9i, PL/SQL, Windows XP/7.

Bank of the West, Thousand Oaks, CA

Mar'10 - May'11

Role: Business Objects Reporting Developer

The .Net based web application is used by the bank for negotiating and

recording the details of the OTC contracts with their high profile clients.

The details captured in the application are used by various downstream

users through a data warehouse for netting and collateral management, for

calculating risk parameters, for trade compliance and maintaining a global

ledger.

The aim of the project was to build Web Intelligence Reports for analysis

of Bank Inventory, Operations, Finance and Portfolio Management. The

Universe and Reports built were used by businesses across the country at

various branches.

Responsibilities:

. Actively involved in requirement gathering sessions and created

necessary documentation for the technical audiences' in-order to

develop the reports.

. Created source to target mappings and provided pseudo-SQL and

transformation logic for various report elements.

. Worked with internal business partners and cross functional teams (ETL

Informatica) to prepare and maintain a seamless execution of BAT/UAT

activities.

. Created documentation for use cases and technical specifications.

. Created the BRD and FSD and got it validated from the Business.

. Created User test cases and ran SQL to test report values and to

reconcile values of our reports with existing operations report

. Worked in Onsite-offshore model.

Environment: Business Objects 3.0, SQL, MS-Excel, Erwin

Expedia Inc., Bellevue, WA

Oct'09 - Mar'10

Role: BO Analyst/Requirements Analyst

The aim of the project was to build Global Marketing Dashboards for

Marketing Analysis across various time-slices like week, month, quarter and

year. The reports were distributed across the organization and the

dashboards which were built from the reports were scheduled to be run on a

daily basis.

Responsibilities:

. Responsible for requirements gathering for creation of reports and

Universes and conducted gap analysis between requirements and existing

Universes.

. Tuned SQL to improve the performance of report execution.

. Created both static and dynamic dashboards using Xcelsius.

. Planned and designed web services using QAAWS to feed Xcelsius as a

data provider.

. Extensively used Live Office to import web Intelligence documents to

Excel and created Dashboards using Xcelsius.

. Created periodical reports: daily, weekly, monthly, quarterly, annual

reports

Environment: Business Objects XIR2, Xcelsius 2008, CMS, Ms-Excel,

Oracle10g, SQL, PL/SQL, Apache Tomcat Server

Wipro Technologies Limited, Bangalore

Jul'07 - Aug'09

Client: British Telecom

Role: PLSQL developer

NEO-DSG: The DSG team is responsible for maintaining all the systems,

interfaces and environments applicable to the NEO project. The code

developed by the development team is taken up from CM Synergy; its then

built and deployed on to various Web logic servers. DSG is also responsible

for building up new environments and making them ready for testing.

Environment: SQL, Oracle 9i, Clarify CRM Thin Client and Thick Client,

UNIX, Excel, Word, PowerPoint, Eclipse

Education:

Bachelors of Engineering in Electrical and Electronics, Under Anna

University, India.

Current Location :

Richmond, VA - 23294

Contact this candidate