Business Objects Developer/Reporter
Resume:
Vijay Potharaj
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