Manager Data

PROFESSIONAL SUMMARY:

> Software Developer with proven 8 years of experience in Analysis,

Coding, Debugging and Testing of Business Applications, focusing on

Business Intelligence and Data Warehousing.

> Strong Skills in Business Intelligence Reporting using SAP

Business Objects XI 4.x/3.1/3.0/R2/6.x,

Crystal Reports, Explorer and XCelsuis.

> An expert in SQL, Database architecture, UNIX and Reports design

utilizing Business Objects and Crystal Reports.

> Had good experience on ETL Tools - Informatica Power Center, Power

Connect, Power Exchange, Power Center Web Services, Metadata Manager,

Custom SQL and PL/SQL for Data mart building and Data warehousing.

> Experience in Business Systems and Requirements Analysis &

Documentation especially in the Financial, Insurance and

Telecommunications Industry.

> Worked with End-To-End implementation of Data warehousing team and

Strong understanding of Data warehouse concepts, Technology using Star

Schema, Snowflake Schema and Multi Dimensional Model in respective to

query and analysis requirements.

> Installed and configured WEBI/AFS on both UNIX and NT using Tomcat and

Apache.

> Experience in building universes, stored procedures, free hand SQL and

creating complex and ad-hoc reports using Business Objects.

> Experience in building Dashboards (which displays Key Performance

Indicators - KPIs) and Scorecards using Dashboard Manager.

> Created complex and sophisticated Business Object Reports that had

multiple tabs and multiple data providers, drilldown, slice and dice

features using Business Objects (Reporter and Explorer).

> Strong knowledge in building queries on different types of Data

Providers like Universes, Personal data files, Stored Procedures, Free-

hand SQL, XML files and Web connect.

> Worked with Business Users to analyze the business process and made

necessary changes to schema objects to cater their reporting needs.

> Experience in creating and managing access restrictions in the

Universe to define the row based security

> Used the access restrictions to define the Object level security for

developers and Power users

> Worked on databases Oracle 11g/10g, Teradata V2R6.2, Netezza 3.0, SQL

Server 2000/2005 and DB2.

> Experience in integration of various data sources like Oracle,

Teradata, SQL Server, IBM MQ-Series, Flat Files, XML files, Microsoft

Visio Files, COBOL files, Legacy Systems (Mainframe, AS400) into the

data warehouse.

> Extensively used SQL, Transact SQL and PL/SQL to write Stored

Procedures, Functions, Packages and Triggers.

> Good knowledge and understanding of Scheduling tool Autosys, ESP and

Apwrox.

> Involved in re-designing or customizing the existing Views and Stored

Procedures to suit the reporting needs.

> Performed data validation by Unit Testing, System Testing, Integration

Testing and Regression Testing.

EDUCATION:

Master of Computer Aplications (MCA) from University of Madras, India in

April 2002.

Technical Skills:

Business Business Objects XI 4.x/3.1/3.0/R2/6.x, Central

Intelligence Management Console, Central Configuration Manager,

Tools Universe Designer, Information Design Tool, Web

Intelligence Rich Client, InfoView, Desktop Intelligence,

Crystal Reports, XCelsius, Explorer, Import Wizard,

QAAWS.

ETL Tools Business Objects DataServices, BO Data Integrator,

Informatica PowerCenter, Master Data Management

Data Modeling Erwin 4.0/3.5.2, MS-Visio, ER Studio

Tools

Scheduling Tools Autosys, ESP, Tidal 6.0/5.3

Databases SAP, Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008,

Teradata V2R4/V2R6, DB2

Database Toad for Oracle10g, SQL*Loader, Embracedo Rapid SQL,

Utilities DBArtician

Languages C, C++, K-Shell, SQL, PL/SQL.

Helpdesk Tools Remedy

Operating Systems Windows 2008/2003/NT/2000/XP, MS-Dos, Unix

PROFESSIONAL EXPERIENCE

SAP America Inc,Newtown Square,PA May 2011 -

Till date

Sr.BO Consultant

Responsibilities:

> Fixed software bugs and interacted with developers to resolve

technical issues.

> Used Slice and Dice, Drill Down, Filters, Conditions, Cross Tab,

Master Detail and Formulas etc and developed Hierarchies to support

drill down reports.

> Created Cardinalities, Contexts, Joins and Aliases for resolving

Loops and checked the Integrity of the Universes.

> Write Complex Queries including JOIN relationship (Inner and Outer)

for extracting the data according to the requirements of Reporting

Group; also tune the queries to improve the time limit to run.

> Experience in Created derived tables in BO Universe designer.

> Designed, developed and tested the reports based on data generated by

enterprise transaction, financial and customer information systems using

Business Objects with different sources such as Oracle, SQL Server, DB2

and MYSQL.

> Used Derived table in Universe for small requirements like creating

union view of 2 transaction tables or adding a simple calculated

column in the Universe

> Defined conditions using @bouser functionality to apply mandatory

security filter on the respective class or universe

> Designed the FCT and Shared dimension classes as per the business

requirements defined @Prompt functions in the universe to record

user selected prompt and perform the calculations in the universe

based on the user input.

> Using Import wizard or LCM to migrate the Universe from one env to

other env

> Created restricted or custom LOV's in the universe objects as per

the request from the user community

> Defined Cascading LOV's between 2 columns in the hierarchy

> Defined business custom hierarchies to facilitate the drill down

and drill up functionality in Webi

> Involved in the designing and building of Universes, Classes and objects

and exported universe across different environment domains from

Development to Production.

> Built WebI reports using various Web Intelligence features like alerters,

hyperlinking, sections, breaks, sorts, formulas, functions and operators.

> Worked on migrating BO full client reports from BO XI R2 to BO XIR3 using

the Import wizard to import existing User accounts, Groups, Categories,

Universe, Reports(Desktop Intelligence and Web Intelligence), Connections

and Universe restrictions to XIR3 environment.

> Experience in trouble shooting the performance issues in WebI reports.

> Worked on building Explorer information spaces against universes

connected to SAP BW and non SAP data sources.

> Scheduled periodic refresh of the Explorer spaces and setup end user

security to access the Explorer space.

> Created relational connections to an ERP data Source to retrieve

data into the existing universes.

> Created reports on BEx Web Application Designer and also enhanced

the web reports which were created in BEx Query Designer.

> Worked on building dashboards in Xcelsius using Live Office

Connectivity and also created WSDL's using Query as a Web Service

(QaaWS) from different data sources to build Xcelsius dashboards.

> Created Xcelsius Dashboards from Crystal Reports built against BEx

queries as the data source and automated the Xcelsius dashboards

using Business Objects Live Office to extract data stored on the

scheduled Crystal Reports.

> Worked with different sources such as Oracle, SQL Server, DB2,

MYSQL, SAP BW and Flat files to build Crystal/WebI reports.

> Created Crystal Reports with ole object extracting image file from

the database and URL links and customized the formatting of the

Crystal Report using formula's at the section level.

> Created formula's for Crystal Report and stored it on the Crystal

repository to be used across the organization and also created

custom formulas to display RGB colors in Crystal Reports.

> Created Crystal Reports with dynamic grouping based on parameters

and also created On-Demand Crystal Sub reports.

> Exported Crystal Reports into various formats XML, PDF, HTML, EXCEL

and WORD for users.

> Trained all the users of the Reports using Info View and exporting

reports to various formats.

> Extensively used the CMC in setting up security in BOXI and also

managed security configuration for various reports, folders,

connections, applications and universes.

> Scheduled the reports daily, weekly, monthly, quarterly and also on-

demand using the event server on CMC.

Environment: Business Objects Enterprise XI 4.1, 3.x, Crystal Reports,

Oracle, SAP BI, SAP BO Explorer, BO Information Design Tool, BO Metadata

Management, BEx Query Designer, BEx analyzer, BEx Web application Designer,

BO Voyager, Designer, Web Intelligence, Desktop Intelligence, Xcelsius and

Windows.

Devon Energy, Houston, TX

Oct 2009 - April 2011

Sr.BO Consultant

Responsibilities:

> Responsible for maintaining Development, Testing and Production

Repositories and providing round the clock support during Production

stage.

> Responsible for Creating and Maintaining Users/Groups, Universes,

Repositories, Connections and Security Policies.

> Responsible for Creating Complex and Multi Dimensional reports using

Master/Detail, Cross Tab, Slice, Dice and Sub Queries.

> Used Alerters, Filters, Breaks, Sorts and Rankings in the reports.

> Interacted with Business Analysts and end users to design Standard and

Ad-hoc reports according to functional specification.

> Involved in upgrading and testing existing Business Objects XI to

business Objects XI 3.1.

> Involved in taking requirements, writing specifications for generation

of report.

> Used Business Objects Web Intelligence tool for deploying analysis

reports on Internet.

> Involved in Repository, SQL and WebI tuning for better performance.

> Created reports using Universe, Free-Hand SQL, Stored Procedures and

Data providers.

> Created multiple Universes and resolved Loops by creating table

aliases and contexts.

> Created Dashboards and Scorecards using framework of Application

Foundation.

> Involved in writing VBA Macros, Add-Ins, and custom scripting for

batch processing.

> Linked different Universes using Kernel Master and component

approaches.

> Designed complex reports based on discussions with user groups and

created various objects using built-in @functions (like @prompt,

@select, @where, @aggregate), complex SQL queries and joins

> Published and retrieved documents through Info view.

> Used the Broadcast Agent Server to Schedule, Refresh. Monitor the

Reports using Report bursting technique.

> Supported the users with their Business Objects related problems.

Environment: Business Objects XI R3, Crystal Reports XI, Info View, Web

Intelligence, Designer, Import Wizard, CMC, BODI, SQL Server, Oracle and

Windows.

Visualsoft Technologies Ltd., India

Aug 2006 to Sep 2009

Client: Liberty Mutual, UK.

Sr. Associate/BO Developer

Responsibilities:

> Designing and building of Universes, Classes and Objects based upon

revenue, cost, performance and customer management systems.

> Resolution of loops, fan traps, chasm traps using contexts and aliases

and its combinations, checking of cardinalities, maintaining integrity

of the Universes.

> Built Universes using Business Objects Designer.

> Created reports using Business Objects for business requirements.

> Created Reports showing the sales in a particular Year, Quarter and

Month using Business Objects.

> Designed the Universe by creating the Business Objects data model,

selecting/joining tables, Indicating cardinalities, created aliases

to resolve the loops, used Aggregate function and created the objects

which are grouped into classes based on Business Functionality.

> Used SQL against the database to check data retrieved.

> Created data extraction queries for the Oracle database.

> Created Reports using the Universe, Stored Procedures and Free Hand

SQL as the Data providers.

> Created the reports using Business Objects functionalities like Drill

Down, Cross tab, Master-Detail, Formulas etc.

> Formatted Reports as per the user requirements using extensively the

functionalities in Business Objects, Used Slice and Dice, Drill Down,

Filters, Conditions, Cross Tab, Master Detail and Formulas etc.

> Developed Hierarchies to support drill down reports which allows the

users to analyze the data.

> Involved in full life cycle of Business Objects reporting application.

> Used Web Intelligence for web based query and reporting.

> Involved in Importing/Exporting the Universes to repository to make

available to the end user.

> Published reports using Infoview and training users for ad hoc

reporting.

> Implemented reporting using n-vision, Crystal Reports, Business

Objects.

> Implemented security among the Business Object tools using Supervisor

> Provided end user support and problem resolution for various issues

related to BO.

> Created LOV's for the universes for quicker performance of reports.

> Interacted with the various users for reporting requirements.

Environment: Business Objects XI R2/6.5, Crystal Reports 10.0/XI, Web

Intelligence, Dash Board Manager, BO Designer, CMC, Oracle 9i, SQL, PL/SQL,

UNIX and Windows.

Visualsoft Technologies Ltd., India

Oct 2004 to Jul 2006

Client: ATIC, USA

Associate/BO Developer

Responsibilities:

> Involved in gathering, analyzing, and documenting business

requirements, functional requirements and data specifications for

Business Objects Universes and Reports

> Interacted with Users to know their approach and assist in developing

and modifying Universes and Reports accordingly

> Involved in designing and building Universes, Classes and objects and

defining the necessary connections

> Extensively involved in writing complex and nested SQL queries to

extract data, using free hand SQL statements and stored procedures

> Extensively used the Designer Module to implement Universe, Joining

the Tables, Create Prompts and queries, parsing the Objects

> Involved in Designing Universes and resolving issues like, Chasm Trap,

Fan Trap using Contexts and Aliases

> Exported the universes to the Repository in order to make the

resources available to the users

> Worked on the Kernel approach during linking of the universes

> Created metrics and worked extensively with the Application Foundation

modules to meet the requirements of higher level analysis

> Interacted regularly with end users and generated reports using

Business Objects functionality such as Queries, Slice and Dice,

Master/detail, Cross Tab, Drill Down, User Responses and Formulas

> Extensively used alerts and filters in reports.

> Published and scheduled Business Objects Reports to users using

Broadcast Agent and Scheduler

> Provided OLAP functionality and worked extensively with Data

warehousing

> Developed Full Client (ZABO) reports and Web Intelligence (WebI)

reports

> Analyzed the requirements and created reports using Crystal Reports

> Set up groups and users for Business Objects deployment and managed

user profiles using Supervisor

> Created Business Objects Repository.

Environment: Business Objects 5.0/6.5, Web Intelligence, Designer,

Supervisor, Broadcast Agent, ZABO, Oracle 9i, DB2, PL/SQL, Windows.

Contact this candidate