Vijay Potharaj

215-***-****

Professional Summary

Overall 9 years of IT experience and 7 years of experience as a Data

warehouse Consultant in the Information Technology with strong exposure

to financial and various other industries

Expertise in software analysis, design and development of applications

providing business intelligence Solutions using business objects product

suite like Supervisor, Designer, Broadcast Agent, Web Intelligence, Info

view, Zabo and other Data warehousing tools in DSS.

Hands on experience in Business Objects XI-R1/6.x/5.x with experience in

Supervisor, Designer, Reporter, BCA Server (Publisher and Scheduler), Web

Intelligence 2.5/2.6.1/6.0, Info view, Application Foundation, Dashboards

and Schema Design

Good Experience in building Business Objects Universes and creating

reports with multiple data providers using personal data files, stored

procedures and free hand SQL methods

Experience in Crystal Reports 8.0 & 9.0

Good knowledge and experience using Oracle 8i/9i/10g, MS SQL Server 2000,

Sybase and Query Analyzer.

Experience in developing SQL, PL/SQL procedures and other components of

database applications

Experience in installation, administration and upgrading both versions of

BO (desktop and server products) on Windows environment

Strong exposure to Object Oriented methodologies like UML

Excellent Business writing skills in writing Business requirements

document, USE Case Specifications, Functional Specifications, Systems

Design Specification (SDS), Systems Requirements Specification (SRS),

Data Dictionary, Business Continuity Plan (BCP)

Exceptionally motivated and skilled in effective time management and

meeting user requirements with uncompromising detail

Excellent team player, interfacing across business and technical groups

and ability to work independently and highly motivated. Exceptional

ability to quickly master new concepts and applications

Experience in coordinating with multiple teams and Strong Analytical and

problem solving skills

Excellent interpersonal, communication and presentation skills

Education:

. BS in Arts (Economics)

Technical Skills

Operating System: Windows 98/2000/NT/ 2000 Server UNIX,

BI Tools: Business Objects Suite (BO Supervisor, BO Designer, BI Tools

Business Object XI R2 /6.x/5.x (BO SDK, Web

Intelligence 2.5/2.6, InfoView 1.0, Designer,

Supervisor Business Miner 4.2, Broadcast Agent,

XI (CMC, CMS, Designer, and Desktop

Intelligence), Crystal Reports 9.x/XI

Data Modeling: Erwin 3.5.2

ETL Tools: Informatica 5.x/6.x

RDBMS: Oracle8x/9x/10g, MS SQL Server 7/2000, MS Access98/2000

Languages: C/C++, Basic, SQL,

GUI Tools: Dream weaver, VB 6.0,

Web/Application Server: IIS, Apache Tomcat

Professional Experience

Franklin Templeton Investments, Dublin, California

Oct 09 - Dec 12

Business Objects Developer

Responsibilities

. Developed Reports for Various Mutual funds, Separate Accounts,

Composites and Hybrid Accounts.

. Created International OMNI Reports with Multiple Reports in One Single

Template

. Interacted with BO Universe Developers and Data Modelers to resolve

the reporting issues

. Developed Dresdner Reports for Onetis Number and Investar Number

. Involved in discussions for building the Institutional Business

Universe and Product Universe

. Prepared Documentation while creating the Objects and predefined

conditions in the universe

. Analyzed Data using Slice and Dice and Drill Mode, etc. and Formatting

Reports.

. Created Condition filters for object types such as Dates and for

objects, which have multiple codes to choose from.

. Created Templates for standardizing the Structure of Corporate

Documents.

. Worked extensively with the major functionality of BO like Breaks,

Alerters, Filters, Sorts, Query Prompt and Drill filters.

. Experienced in Implementing Business Objects Reports, Business Objects

Designer, Web-Intelligence and XI R2 Reports.

. Responsible for creating Metadata in BO XI R2 Designer.

. Tested Objects in the Universe to ensure the correct Mapping of the

Objects.

. Test Resolved Loops and Contexts to ensure the results from Query.

. Work closely with Data Warehousing team to ensure Integrity of Data.

. Created Contexts, Joins, Aliases for Resolving Multifaceted loops.

. Data Validation from source to Data warehouse to WEBI Reports and

Analytics.

Environment: BO XI R2 (CMC, CMS, CCM, Designer, Deski, WebI) ORACLE 9i,

PL/SQL, TOAD, Windows 2000 Server

Becton, Dickinson & Co, NJ

June 08 - Sep 09

Business Objects Consultant

Responsibilities

. Participated in requirements gathering, analysis and structured

Business Intelligence platform based on user requirements.

. Created functional requirement specifications through end-user

meetings and analysis of business requirement documents.

. Involved in Installation, Configuration, Deployment of Business

Objects Suite

. Involved in setting up users through Supervisor and assigning

privileges to these users to meet security requirements

. Setting up object level and data level securities on the universes to

various groups and users using supervisor.

. Created Universes from multiple data sources which were coming from

different databases

. Created predefined conditions, prompts and custom hierarchies in the

process of building the universes

. Resolved issues like loops by creating aliases and contexts as

required to remove the cyclic dependencies

. Exported the universes to dev, test and prod domains to make resources

available to the users.

. Creating standard full client/WebI reports, created canned and ad-hoc

Reports Using Business objects user module.

. Created reports using Business Objects features like Slice/Dice, Drill

Down, @Functions, Cross tab etc.

. Formatted the reports as per the Users requirements using all the

facilities in Business Objects, which allows the users to analyze the

data.

. Scheduled and Monitored Reports through using BCA. Training to end

user and power users.

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

analyzing its performance before moving into production.

. Developed several thin client reports.

. Involved in installing Web Intelligence, creating users, user groups

and categories

. Created users and groups using Central Management Console (CMC) and

assigned privileges to different groups and users.

. Applied row level and object level securities to different groups and

users in the designer wizard

. Migrating existing BO universes and reports to BOXI using Import

Wizard

. Converted the existing full client reports to WebI docs using report

conversion tool

Environment: Business Objects 6.5(Supervisor, Designer, Reporter), Web

Intelligence, BCA, JSP, 3 Tier BO, BO XI r2 (CMC, CMS, CCM, Designer,

Deski, WebI) ORACLE 9i, PL/SQL, TOAD, Windows 2000 Server

.

BELLSOUTH, Atlanta, GA Oct 06

- Mar 08

Business Objects Consultant

Responsibilities:

. Worked with Business Objects Supervisor for creating repository,

creating and managing the universes, creating categories, creating and

managing the users, giving access permissions for Business Objects

Reports.

. Responsible for the System Study & Business Requirements Analysis &

Documentation.

. Installation of Broadcast Agent, Broadcast Agent Publisher, Auditor.

. Designing Business Objects Universes and reports.

. Installation of Business Objects 5.1.8 (Full Client)/Administration

. Installed Web Intelligence (Thin Client) and set up in a clustered

environment.

. Responsible for the Dimensional Data Modeling and populating the

business rules using mappings into the Repository for Meta Data

management.

. Installation of Application Foundation / Administration

. Created variables, formulae and detail objects at report level

. Designed, developed, maintained and tested universes for supporting ad

hoc queries and canned reports

. Actively worked with the end users in finalizing the Functional

Specifications.

. Created detailed Technical Specifications for each mapping based on

these Functional Specs.

. Written maps for daily data loads.

. Created, and optimized Business Objects Universes using Designer 5.1.8

. Created Universe Classes, Objects, Measure Objects, Conditions, Joins

. Resolved Chasm, Fan traps and Loop problems

. Used Aggregate awareness in universes.

. Created the reports using Business Objects functionalities like

Queries, Slice and Dice, Drill down, @Functions, Cross Tab,

Master/Detail and Formulas etc.

. Developed complex queries using different data providers in the same

report

. Scheduled pre-canned reports through Broad Cast Agent Publisher for

distribution and printing.

. Creation of Dashboard and Score Cards using Dashboard Manager.

. Monitoring Business Metric.

. Created and deployed Web I Reports through Info View.

. Created custom authentication using Lotus Notes database for Web

Intelligence using Active Server Pages and Web Intelligence SDK.

. Configuration of Business Objects & Application Foundation

. Customized configuration of Business Objects - Web Intelligence by

fine-tuning and Optimization for good performance.

. Provided technical assistance/support to analysts, business community

and responded to inquiries regarding errors, problems, or questions

with programs/interfaces

. Worked with flat files, Oracle and SQL server 2000 as sources.

. Leveraged Explain Plan and TKPROF to improve query performance.

. Analyzed Test Cases and Test Plans. Involved in unit and system

testing.

Environment: Business Objects Suite, MS SQL Server 2000, Oracle 9i, PL SQL,

Toad, Windows 2000, ASP, WebI

Caterpillar Inc, Peoria, IL

Oct 05 - Sep 06

Business Objects Developer

Responsibilities

. Interacted with end-users and business analysts to identify and

develop business requirements and transform it into technical

requirements and ultimately responsible for delivering the solution.

. Analyzed existing databases and designed & modified existing universes

using Designer module.

. Resolved issues like loops by creating aliases and contexts as

required to remove the cyclic dependencies

. Created predefined condition, prompts and customized LOV's in the

process of building the Universes.

. Comparing business logics with existing Crystal Reports

. Configuration and maintenance of print and page servers and server

group.

. Developed and supported Business Objects reporting system for various

Business units.

. Publishing HTML reports on BO Publisher

. Created various reports using Universes as the main Data providers

related to the departments such as sales, marketing and revenue. These

reports were generated using the functionalities of Business Objects

such as Master/Detail, Slice and Dice, Cross tabs, Drill Down,

@Prompts, Functions and Formulae to analyze the data.

. Created a set of Ad hoc reports with Business Objects and finally

deploying them in Web Intelligence.

. Analyzed SQL code to ensure Business Objects queries the correct data

from the database.

. Responsible for knowledge transfer, training sessions with end users

to teach them the basic fundamentals to work on Reports.

. Produced reports and exported to Excel based on user requirements.

. Created number of standard reports and queries based on existing

classes/objects.

. Created, maintained & supported Business Objects reports in Web

Intelligence Info View.

. Analyzed reporting requirements and translated them into canned

reports.

Environment: Business Objects 5x, MS SQL Server 2000, Oracle 9.0, SQL

Navigator, Windows NT, and Excel

CSC CIGNA Systems, Voorhees, NJ

Jan 04 - Apr 05

Customer Support Technician,

. Provide call center coverage to troubleshoot and resolve hardware

issues, multi software issues, multiple operating system issues, multi

platform mainframe, password resets, NT domain resets, and remote

dialing issues for VPN, resolve LAN printer problems.

. Responsible for re-enabling ids on the AS400 that are in disabled

status and ending active jobs for users.

. Responsible for documenting cases using "Vantive" application.

. Responsible for escalating calls to proper teams when calls cannot be

resolved in a timely manner.

Environment: MS Dos, Windows 2000, XP and NT, Exposure to Oracle-7, MS

Word, PC Anywhere, Symantec Ghost, Vantive, Internet Technologies, Norton

Anti-Virus.

CIGNA Tel-Drug, Horsham, PA

April 02 - Dec 03

Help Desk Analyst,

. Responsible for first level helpdesk support answering, evaluates, and

prioritizes incoming telephone calls.

. Responsible for voice mail and e-mail requests for assistance from

users experiencing problems with hardware, software, networking, and

other computer related technologies.

. Responsible for Logs and tracks calls using problem management

database, and maintains history record and related problems.

. Responsible for Documentation, Troubleshoot basic network and client

problems (OS Application and TCP/IP). Work extensively with Heat Help

Desk application for problems tracking, reporting and trending.

Environment: MS-Dos, Windows NT, MS Access 2000, Internet Explorer 4.0, OS

Application TCP/IP, HEAT Help desk Application.

STATUS: US Citizen

References are Available upon Request:

Contact this candidate