I read this article recently here the author Reinald Bormann from Harvey jones system gives and insight about the BI Consultant
Most recruiters daily face the sad reality that there is a serious skills shortage in the local IT industry.
The business intelligence (BI) market is not exempt. With BI going from strength to strength since 2003, market-savvy IT professionals are trying to enter this lucrative market, with many cross-skilling on multiple BI platforms or products.
One of the changes afoot in the market is that companies no longer simply deliver a BI solution and then leave clients to their own devices.more often than not, client/consultant relationships extend well beyond delivering the initial project.
Successful BI consultants must be well-rounded people with solid project experience, preferably across various market sectors.
Successful BI consultants should excel in the following four areas:
* Technical ability
* Interpersonal skills
* Project experience and
* Market knowledge
Technical ability
BI projects are being completed quicker today than they were three years ago, with the result that top BI consultants can work on multiple projects each year.
Properly applying the latest technology should always be a BI consultant's highest priority and, with so many technical components to these solutions, specialising in at least one component is beneficial.
While core skills allow consultants to work on projects other than BI, they should always strive to improve their abilities on other components.
Interpersonal skills
All projects involve interaction between BI consultants, fellow team members and clients.
Interpersonal communication is a vital skill that each BI consultant must master.
The wealth of knowledge contained in BI consultants' heads is not easily transferred.
Effective use of communication skills allows them to share knowledge across the team.
Successful BI consultants also act as mentors and guide internal IT teams through the uncharted waters of their first BI projects. It is BI consultants' role to point clients toward good resources, books and conferences for further education.
Project experience
IT consulting is always evolving. Because project rotation is generally more frequent than in the past, BI consultants must quickly understand new businesses in order to deliver solutions on time and within budget. Getting to grips with unfamiliar businesses is always difficult, but is also very rewarding.
Successful BI consultants leverage their technical capabilities to re-use certain components developed on previous projects.
Essentially, project experience breeds problem identification and reinforces the use of best practice and methodology.
Market knowledge
Just as consultants become comfortable, a new product or toolset emerges, which nine times out of 10 changes the way they deliver. This is not necessarily a bad thing, as successful BI consultants usually make market changes work for them by aligning their technical skills in the new direction.
The release of Microsoft Performance Point Server (PPS) at the end of the year is a very good case in point; most BI organisations are uncertain of the true impact PPS will have in the market, so having skilled BI consultants at hand when the product is released could ensure a significant market share of new BI solutions on PPS.
It should be every BI consultant's goal to be as active as possible in the community. That means attending seminars and Webcasts, taking part in BI forums or using other knowledge-sharing channels.
Conclusion
In today's challenging and demanding BI market, successful BI consultants must be well-rounded and experienced people, able to adapt quickly to various business environments, continuously share knowledge internally and externally, understand future BI market trends and, most importantly, be very sound technically.
If you are lucky enough to have such a person in your employ or can find one, hang on to them tightly with both hands as they are worth their weight in gold.
By Reinald Bormann, BI consultant at Harvey Jones Systems
Tuesday, January 29, 2008
Business Objects-Scheduling Servers
If you have a situation of restarting BO Servers on every Sunday for maintenance purpose you can use this piece of code which will automate BO Servers.
You can add in the scheduled task of the windows,so that it will run at that time.
**************************************************
**************************************************
clse
cho off
echo .
echo .
echo Starting all the BOXIR2 services
echo .
echo .
net start “Central Management Server”
net stop “Connection Server”
net start “Connection Server”
net stop “Crystal Reports Cache Server”
net start “Crystal Reports Cache Server”
net stop “Crystal Reports Job Server”
net start “Crystal Reports Job Server”
net stop “Crystal Reports Page Server”
net start “Crystal Reports Page Server”
net stop “Desktop Intelligence Cache Server”
net start “Desktop Intelligence Cache Server”
net stop “Desktop Intelligence Job Server”
net start “Desktop Intelligence Job Server”
net stop “Desktop Intelligence Report Server”
net start “Desktop Intelligence Report Server”
net stop “Destination Job Server”
net start “Destination Job Server”
net stop “Event Server”
net start “Event Server”
net stop “Input File Repository Server”
net start “Input File Repository Server”
net stop “List of Values Job Server”
net start “List of Values Job Server”
net stop “Output File Repository Server”
net start “Output File Repository Server”
net stop “Program Job Server”
net start “Program Job Server”
net stop “Report Application Server”
net start “Report Application Server”
net stop “Web Intelligence Job Server”
net start “Web Intelligence Job Server”
net stop “Web Intelligence Report Server”
net start “Web Intelligence Report Server”
net stop “WinHTTP Web Proxy Auto-Discovery Service”
net start “WinHTTP Web Proxy Auto-Discovery Service”
echo .
echo .
echo All services has been restarted.
echo .
echo .
pause
**************************************************
*************************************************
Once you written this above statement in the notepad ,save the notepad as a bacth file ("bo.bat").
Then you can add this batch file in the windows scheduled task.so if you want to restart your servers after any any patch install or for any purpose you can use this batch file.
To create a Schedule Task
Go to Start->Settings->Control panel ->Scheduled Task
Now give the path and name of the batch file then schedule it
Once it is done then the servers will get restarted automatically at that particular time.
You can add in the scheduled task of the windows,so that it will run at that time.
**************************************************
**************************************************
clse
cho off
echo .
echo .
echo Starting all the BOXIR2 services
echo .
echo .
net start “Central Management Server”
net stop “Connection Server”
net start “Connection Server”
net stop “Crystal Reports Cache Server”
net start “Crystal Reports Cache Server”
net stop “Crystal Reports Job Server”
net start “Crystal Reports Job Server”
net stop “Crystal Reports Page Server”
net start “Crystal Reports Page Server”
net stop “Desktop Intelligence Cache Server”
net start “Desktop Intelligence Cache Server”
net stop “Desktop Intelligence Job Server”
net start “Desktop Intelligence Job Server”
net stop “Desktop Intelligence Report Server”
net start “Desktop Intelligence Report Server”
net stop “Destination Job Server”
net start “Destination Job Server”
net stop “Event Server”
net start “Event Server”
net stop “Input File Repository Server”
net start “Input File Repository Server”
net stop “List of Values Job Server”
net start “List of Values Job Server”
net stop “Output File Repository Server”
net start “Output File Repository Server”
net stop “Program Job Server”
net start “Program Job Server”
net stop “Report Application Server”
net start “Report Application Server”
net stop “Web Intelligence Job Server”
net start “Web Intelligence Job Server”
net stop “Web Intelligence Report Server”
net start “Web Intelligence Report Server”
net stop “WinHTTP Web Proxy Auto-Discovery Service”
net start “WinHTTP Web Proxy Auto-Discovery Service”
echo .
echo .
echo All services has been restarted.
echo .
echo .
pause
**************************************************
*************************************************
Once you written this above statement in the notepad ,save the notepad as a bacth file ("bo.bat").
Then you can add this batch file in the windows scheduled task.so if you want to restart your servers after any any patch install or for any purpose you can use this batch file.
To create a Schedule Task
Go to Start->Settings->Control panel ->Scheduled Task
Now give the path and name of the batch file then schedule it
Once it is done then the servers will get restarted automatically at that particular time.
Monday, January 28, 2008
A Model Enterprise BI Flow:
A Model Enterprise BI Flow:
1. Enterprise Information Management
EIM builds a trusted foundation for your business decisions by integrating data from many sources and improving its quality.
- Ensure a required data collection model for all processes across all facilities and geographical locations
- If data is in disparate data sources, seamlessly integrate them into a data warehouse through robust sophisticated data integration tools
- Design information universes to define or restrict information visibility to different departments and personnel and balance data access loads.
- Information so presented is semantic and as per the business terminology, insulating the business user from the underlying technical complexities or need for SQL knowledge.
- The ground for single version of information throughout the organization is now created.
2. Query and Analysis
Ad-hoc query and analysis tools allow end users to interact with business information and answer ad-hoc questions themselves, without advanced knowledge of the underlying data sources and structures.
- Analysts can now work on this data using robust visual analytics to ensure that only the relevant information reaches the key managers as desired.
3. Enterprise Reporting
User-friendly visual reporting tools with drag-and-drop, slice-and-dice, and drill-down capabilities allow users to access, format, and deliver data as meaningful information to large populations of information consumers both inside and outside the organization.
4. Enterprise Performance Management
Performance management tools and services help users align with organizational strategy by tracking and analyzing key business metrics and goals via management dashboards, scorecards, analytics, and alerting.
Enterprises adopting such tightly integrated Business Intelligence solution can now robustly resolve their business concerns and move towards leadership position.
Basic Oracle Q/A
1. What are the components of Physical database structure of Oracle Database?.
ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files.
2. What are the components of Logical database structure of ORACLE database?
Tablespaces and the Database's Schema Objects.
3. What is a Tablespace?
A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together.
4. What is SYSTEM tablespace and When is it Created?
Every ORACLE database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.
5. Explain the relationship among Database, Tablespace and Data file.
Each databases logically divided into one or more tablespaces One or more data files are explicitly created for each tablespace.
6. What is schema?
A schema is collection of database objects of a User.
7. What are Schema Objects ?
Schema objects are the logical structures that directly refer to the database's data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions packages anddatabase links.
8. Can objects of the same Schema reside in different tablespaces.?
Yes.
9. Can a Tablespace hold objects from different Schemes ?
Yes.
10. what is Table ?
A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.
11. What is a View ?
A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)
12. Do View contain Data ?
Views do not contain or store data.
13. Can a View based on another View ?
Yes.
14. What are the advantages of Views ?
Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.
Hide data complexity.
Simplify commands for the user.
Present the data in a different perpecetive from that of the base table.
Store complex queries.
15. What is a Sequence ?
A sequence generates a serial list of unique numbers for numerical columns of a database's tables.
16. What is a Synonym ?
A synonym is an alias for a table, view, sequence or program unit.
17. What are the type of Synonyms?
There are two types of Synonyms Private and Public.
18. What is a Private Synonyms ?
A Private Synonyms can be accessed only by the owner.
19. What is a Public Synonyms ?
A Public synonyms can be accessed by any user on the database.
20. What are synonyms used for ?
Synonyms are used to : Mask the real name and owner of an object.
Provide public access to an object
Provide location transparency for tables,views or program units of a remote database.
Simplify the SQL statements for database users.
21. What is an Index ?
An Index is an optional structure associated with a table to have direct access to rows,which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.
22. How are Indexes Update ?
Indexes are automatically maintained and used by ORACLE. Changes to table data are automatically incorporated into all relevant indexes.
23. What are Clusters ?
Clusters are groups of one or more tables physically stores together to share common columns and are often used together.
24. What is cluster Key ?
The related columns of the tables in a cluster is called the Cluster Key.
25. What is Index Cluster ?
A Cluster with an index on the Cluster Key.
26. What is Hash Cluster ?
A row is stored in a hash cluster based on the result of applying a hash function to the row's cluster key value. All rows with the same hash key value are stores together on disk.
27. When can Hash Cluster used ?
Hash clusters are better choice when a table is often queried with equality queries. For such queries the specified cluster key value is hashed. The resulting hash key value points directly to the area on disk that stores the specified rows.
28. What is Database Link ?
A database link is a named object that describes a "path" from one database to another.
29. What are the types of Database Links ?
Private Database Link, Public Database Link and Network Database Link.
30. What is Private Database Link ?
Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.
31. What is Public Database Link ?
Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global object name in a SQL statement or object definition.
3
2. What is Network Database link ?
Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition.
33. What is Data Block ?
ORACLE database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.
34. How to define Data Block size ?
A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and cann't be changed latter.
35. What is Row Chaining ?
In Circumstances, all of the data for a row in a table may not be able to fit in the same data block. When this occurs , the data for the row is stored in a chain of data block (one or more) reserved for that segment.
36. What is an Extent ?
An Extent is a specific number of contiguous data blocks, obtained in a single allocation, used to store a specific type of information.
37. What is a Segment ?
A segment is a set of extents allocated for a certain logical structure.
38. What are the different type of Segments ?
Data Segment, Index Segment, Rollback Segment and Temporary Segment.
39. What is a Data Segment ?
Each Non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.
40. What is an Index Segment ?
Each Index has an Index segment that stores all of its data.
41. What is Rollback Segment ?
A Database contains one or more Rollback Segments to temporarily store "undo" information.
42. What are the uses of Rollback Segment ?
Rollback Segments are used :
To generate read-consistent database information during database recovery to rollback uncommitted transactions for users.
43. What is a Temporary Segment ?
Temporary segments are created by ORACLE when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the system for future use.
44. What is a Data File ?
Every ORACLE database has one or more physical data files. A database's data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the data files allocated for a database.
45. What are the Characteristics of Data Files ?
A data file can be associated with only one database.Once created a data file can't change size.
One or more data files form a logical unit of database storage called a tablespace.
46. What is a Redo Log ?
The set of Redo Log files for a database is collectively known as the database's redo log.
47. What is the function of Redo Log ?
The Primary function of the redo log is to record all changes made to data.
48. What is the use of Redo Log Information ?
The Information in a redo log file is used only to recover the database from a system or media failure prevents database data from being written to a database's data files.
49. What does a Control file Contain ?
A Control file records the physical structure of the database. It contains the following information.
Database Name
Names and locations of a database's files and redolog files.
Time stamp of database creation.
50. What is the use of Control File ?
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.
51. What is a Data Dictionary ?
The data dictionary of an ORACLE database is a set of tables and views that are used as a read-only reference about the database.
It stores information about both the logical and physical structure of the database, the valid users of an ORACLE database, integrity constraints defined for tables in the database and space allocated for a schema object and how much of it is being used.
52. What is an Integrity Constrains ?
An integrity constraint is a declarative way to define a business rule for a column of a table.
53. Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
No.
54. Describe the different type of Integrity Constraints supported by ORACLE ?
NOT NULL Constraint - Disallows NULLs in a table's column.
UNIQUE Constraint - Disallows duplicate values in a column or set of columns.
PRIMARY KEY Constraint - Disallows duplicate values and NULLs in a column or set of columns.
FOREIGN KEY Constrain - Require each value in a column or set of columns match a value in a related table's UNIQUE or PRIMARY KEY.
CHECK Constraint - Disallows values that do not satisfy the logical expression of the constraint.
55. What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
A column defined as UNIQUE can contain NULLs while a column defined as PRIMARY KEY can't contain Nulls.
56. Describe Referential Integrity ?
A rule defined on a column (or set of columns) in one table that allows the insert or update of a row only if the value for the column or set of columns (the dependent value) matches a value in a column of a related table (the referenced value). It also specifies the type of data manipulation allowed on referenced data and the action to be performed on dependent data as a result of any action on referenced data.
57. What are the Referential actions supported by FOREIGN KEY integrity constraint ?
UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data.
DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.
58. What is self-referential integrity constraint ?
If a foreign key reference a parent key of the same table is called self-referential integrity constraint.
59. What are the Limitations of a CHECK Constraint ?
The condition must be a Boolean expression evaluated using the values in the row being inserted or updated and can't contain subqueries, sequence, the SYSDATE,UID,USER or USERENV SQL functions, or the pseudo columns LEVEL or ROWNUM.
60. What is the maximum number of CHECK constraints that can be defined on a column ?
No Limit.
SYSTEM ARCHITECTURE :
61. What constitute an ORACLE Instance ?
SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process.
62. What is SGA ?
The System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance.
63. What are the components of SGA ?
Database buffers, Redo Log Buffer the Shared Pool and Cursors.
64. What do Database Buffers contain ?
Database buffers store the most recently used blocks of database data. It can also contain modified data that has not yet been permanently written to disk.
65. What do Redo Log Buffers contain ?
Redo Log Buffer stores redo entries a log of changes made to the database.
66. What is Shared Pool ?
Shared Pool is a portion of the SGA that contains shared memory constructs such as shared SQL areas.
67. What is Shared SQL Area ?
A Shared SQL area is required to process every unique SQL statement submitted to a database and contains information such as the parse tree and execution plan for the corresponding statement.
68. What is Cursor ?
A Cursor is a handle ( a name or pointer) for the memory associated with a specific statement.
69. What is PGA ?
Program Global Area (PGA) is a memory buffer that contains data and control information for a server process.
70. What is User Process ?
A user process is created and maintained to execute the software code of an application program. It is a shadow process created automatically to facilitate communication between the user and the server process.
71. What is Server Process ?
Server Process handle requests from connected user process. A server process is in charge of communicating with the user process and interacting with ORACLE carry out requests of the associated user process.
72. What are the two types of Server Configurations ?
Dedicated Server Configuration and Multi-threaded Server Configuration.
73. What is Dedicated Server Configuration ?
In a Dedicated Server Configuration a Server Process handles requests for a Single User Process.
74. What is a Multi-threaded Server Configuration ?
In a Multi-threaded Server Configuration many user processes share a group of server process.
75. What is a Parallel Server option in ORACLE ?
A configuration for loosely coupled systems where multiple instance share a single physical database is called Parallel Server.
76. Name the ORACLE Background Process ?
DBWR - Database Writer.
LGWR - Log Writer
CKPT - Check Point
SMON - System Monitor
PMON - Process Monitor
ARCH - Archiver
RECO - Recover
Dnnn - Dispatcher, and
LCKn - Lock
Snnn - Server.
77. What Does DBWR do ?
Database writer writes modified blocks from the database buffer cache to the data files.
78.When Does DBWR write to the database ?
DBWR writes when more data needs to be read into the SGA and too few database buffers are free. The least recently used data is written to the data files first. DBWR also writes when CheckPoint occurs.
79. What does LGWR do ?
Log Writer (LGWR) writes redo log entries generated in the redo log buffer of the SGA to on-line Redo Log File.
80. When does LGWR write to the database ?
LGWR writes redo log entries into an on-line redo log file when transactions commit and the log buffer files are full.
81. What is the function of checkpoint(CKPT)?
The Checkpoint (CKPT) process is responsible for signaling DBWR at checkpoints and updating all the data files and control files of the database.
82. What are the functions of SMON ?
System Monitor (SMON) performs instance recovery at instance start-up. In a multiple instance system (one that uses the Parallel Server), SMON of one instance can also perform instance recovery for other instance that have failed SMON also cleans up temporary segments that are no longer in use and recovers dead transactions skipped during crash and instance recovery because of file-read or off-line errors. These transactions are eventually recovered by SMON when the tablespace or file is brought back on-line SMON also coalesces free extents within the database to make free space contiguous and easier to allocate.
83. What are functions of PMON ?
Process Monitor (PMON) performs process recovery when a user process fails PMON is responsible for cleaning up the cache and Freeing resources that the process was using PMON also checks on dispatcher and server processes and restarts them if they have failed.
84. What is the function of ARCH ?
Archiver (ARCH) copies the on-line redo log files to archival storage when they are full. ARCH is active only when a database's redo log is used in ARCHIVELOG mode.
85. What is function of RECO ?
RECOver (RECO) is used to resolve distributed transactions that are pending due to a network or system failure in a distributed database. At timed intervals,the local RECO attempts to connect to remote databases and automatically complete the commit or rollback of the local portion of any pending distributed transactions.
86. What is the function of Dispatcher (Dnnn) ?
Dispatcher (Dnnn) process is responsible for routing requests from connected user processes to available shared server processes and returning the responses back to the appropriate user processes.
87. How many Dispatcher Processes are created ?
Atleast one Dispatcher process is created for every communication protocol in use.
88. What is the function of Lock (LCKn) Process ?
Lock (LCKn) are used for inter-instance locking when the ORACLE Parallel Server option is used.
89. What is the maximum number of Lock Processes used ?
Though a single LCK process is sufficient for most Parallel Server systems
upto Ten Locks (LCK0,....LCK9) are used for inter-instance locking.
DATA ACCESS
90. Define Transaction ?
A Transaction is a logical unit of work that comprises one or more SQL statements executed by a single user.
91. When does a Transaction end ?
When it is committed or Rollbacked.
92. What does COMMIT do ?
COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed.
93. What does ROLLBACK do ?
ROLLBACK retracts any of the changes resulting from the SQL statements in the transaction.
94. What is SAVE POINT ?
For long transactions that contain many SQL statements, intermediate markers or savepoints can be declared which can be used to divide a transaction into smaller parts. This allows the option of later rolling back all work performed from the current point in the transaction to a declared savepoint within the transaction.
95. What is Read-Only Transaction ?
A Read-Only transaction ensures that the results of each query executed in the transaction are consistant with respect to the same point in time.
96. What is the function of Optimizer ?
The goal of the optimizer is to choose the most efficient way to execute a SQL statement.
97. What is Execution Plan ?
The combinations of the steps the optimizer chooses to execute a statement is called an execution plan.
98. What are the different approaches used by Optimizer in choosing an execution plan ?
Rule-based and Cost-based.
99. What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.
100. What are the values that can be specified for OPTIMIZER MODE Parameter ?
COST and RULE.
101. Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost'?
Presence of statistics in the data dictionary for atleast one of the tables accessed by the SQL statements is necessary for the OPTIMIZER to use COST-based approach. Otherwise OPTIMIZER chooses RULE-based approach.
102. What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
This value causes the optimizer to choose the rule_based approach for all SQL statements issued to the instance regardless of the presence of statistics.
103. What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
CHOOSE,ALL_ROWS,FIRST_ROWS and RULE.
104. What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.
105. What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
This value causes the optimizer to the cost-based approach for all SQL statements in the session regardless of the presence of statistics and to optimize with a goal of best throughput.
106. What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
This value causes the optimizer to use the cost-based approach for all SQL statements in the session regardless of the presence of statistics and to optimize with a goal of best response time.
107. What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
This value causes the optimizer to choose the rule-based approach for all SQL statements in a session regardless of the presence of statistics.
108. What is RULE-based approach to optimization ?
Choosing an executing planbased on the access paths available and the ranks of these access paths.
109. What is COST-based approach to optimization ?
Considering available access paths and determining the most efficient execution plan based on statistics in the data dictionary for the tables accessed by the statement and their associated clusters and indexes.
PROGRAMMATIC CONSTRUCTS
110. What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
Procedures and Functions,Packages and Database Triggers.
111. What is a Procedure ?
A Procedure consist of a set of SQL and PL/SQL statements that are grouped together as a unit to solve a specific problem or perform a set of related tasks.
112. What is difference between Procedures and Functions ?
A Function returns a value to the caller where as a Procedure does not.
113. What is a Package ?
A Package is a collection of related procedures, functions, variables and other package constructs together as a unit in the database.
114. What are the advantages of having a Package ?
Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance (for example all objects of the package are parsed compiled, and loaded into memory once)
115. What is Database Trigger ?
A Database Trigger is procedure (set of SQL and PL/SQL statements) that is automatically executed as a result of an insert in,update to, or delete from a table.
116. What are the uses of Database Trigger ?
Database triggers can be used to automatic data generation, audit data modifications, enforce complex Integrity constraints, and customize complex security authorizations.
117. What are the differences between Database Trigger and Integrity constraints ?
A declarative integrity constraint is a statement about the database that is always true. A constraint applies to existing data in the table and any statement that manipulates the table.
A trigger does not apply to data loaded before the definition of the trigger, therefore, it does not guarantee all data in a table conforms to the rules established by an associated trigger.
A trigger can be used to enforce transitional constraints where as a declarative integrity constraint cannot be used.
DATABASE SECURITY
118. What are Roles ?
Roles are named groups of related privileges that are granted to users or other roles.
119. What are the use of Roles ?
REDUCED GRANTING OF PRIVILEGES - Rather than explicitly granting the same set of privileges to many users a database administrator can grant the privileges for a group of related users granted to a role and then grant only the role to each member of the group.
DYNAMIC PRIVILEGE MANAGEMENT - When the privileges of a group must change, only the privileges of the role need to be modified. The security domains of all users granted the group's role automatically reflect the changes made to the role.
SELECTIVE AVAILABILITY OF PRIVILEGES - The roles granted to a user can be selectively enable (available for use) or disabled (not available for use). This allows specific control of a user's privileges in any given situation.
APPLICATION AWARENESS - A database application can be designed to automatically enable and disable selective roles when a user attempts to use the application.
120. How to prevent unauthorized use of privileges granted to a Role ?
By creating a Role with a password.
121. What is default tablespace ?
The Tablespace to contain schema objects created without specifying a tablespace name.
122. What is Tablespace Quota ?
The collective amount of disk space available to the objects in a schema on a particular tablespace.
123. What is a profile ?
Each database user is assigned a Profile that specifies limitations on various system resources available to the user.
124. What are the system resources that can be controlled through Profile ?
The number of concurrent sessions the user can establish the CPU processing time available to the user's session the CPU processing time available to a single call to ORACLE made by a SQL statement the amount of logical I/O available to the user's session the amout of logical I/O available to a single call to ORACLE made by a SQL statement the allowed amount of idle time for the user's session the allowed amount of connect time for the user's session.
125. What is Auditing ?
Monitoring of user access to aid in the investigation of database use.
126. What are the different Levels of Auditing ?
Statement Auditing, Privilege Auditing and Object Auditing.
127. What is Statement Auditing ?
Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.
128. What is Privilege Auditing ?
Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.
129. What is Object Auditing ?
Object auditing is the auditing of accesses to specific schema objects without regard to user.
DISTRIBUTED PROCESSING AND DISTRIBUTED DATABASES
130. What is Distributed database ?
A distributed database is a network of databases managed by multiple database servers that appears to a user as single logical database. The data of all databases in the distributed database can be simultaneously accessed and modified.
131. What is Two-Phase Commit ?
Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase, a Prepare Phase and a Commit Phase.
132. Describe two phases of Two-phase commit ?
Prepare phase - The global coordinator (initiating node) ask a participants to prepare (to promise to commit or rollback the transaction, even if there is a failure)
Commit - Phase - If all participants respond to the coordinator that they are prepared, the coordinator asks all nodes to commit the transaction, if all participants cannot prepare, the coordinator asks all nodes to roll back the transaction.
133. What is the mechanism provided by ORACLE for table replication ?
Snapshots and SNAPSHOT LOGs
134. What is a SNAPSHOT ?
Snapshots are read-only copies of a master table located on a remote node which is periodically refreshed to reflect changes made to the master table.
135. What is a SNAPSHOT LOG ?
A snapshot log is a table in the master database that is associated with the master table. ORACLE uses a snapshot log to track the rows that have been updated in the master table. Snapshot logs are used in updating the snapshots based on the master table.
136. What is a SQL * NET?
SQL *NET is ORACLE's mechanism for interfacing with the communication protocols used by the networks that facilitate distributed processing and distributed databases. It is used in Clint-Server and Server-Server communications.
DATABASE OPERATION, BACKUP AND RECOVERY
137. What are the steps involved in Database Startup ?
Start an instance, Mount the Database and Open the Database.
138. What are the steps involved in Database Shutdown ?
Close the Database, Dismount the Database and Shutdown the Instance.
139. What is Restricted Mode of Instance Startup ?
An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the RESTRICTED SESSION system privilege.
140. What are the different modes of mounting a Database with the Parallel Server ?
Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database.
Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database.
141. What is Full Backup ?
A full backup is an operating system backup of all data files, on-line redo log files and control file that constitute ORACLE database and the parameter.
142. Can Full Backup be performed when the database is open ?
No.
143. What is Partial Backup ?
A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.
144.WhatisOn-lineRedoLog?
The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the corresponding redo entries temporarily stores in redo log buffers of the SGA are written to an on-line redo log file by the background process LGWR. The on-line redo log files are used in cyclical fashion.
145. What is Mirrored on-line Redo Log ?
A mirrored on-line redo log consists of copies of on-line redo log files physically located on separate disks, changes made to one member of the group are made to all members.
146. What is Archived Redo Log ?
Archived Redo Log consists of Redo Log files that have archived before being reused.
147. What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?
Complete database recovery from disk failure is possible only in ARCHIVELOG mode.
Online database backup is possible only in ARCHIVELOG mode.
148. What is Log Switch ?
The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch.
149. What are the steps involved in Instance Recovery ?
R_olling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo log, including the contents of rollback segments.
Rolling back transactions that have been explicitly rolled back or have not been committed as indicated by the rollback segments regenerated in step a.
Releasing any resources (locks) held by transactions in process at the time of the failure.
Resolving any pending distributed transactions undergoing a two-phase commit at the time of the instance failure.
ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files.
2. What are the components of Logical database structure of ORACLE database?
Tablespaces and the Database's Schema Objects.
3. What is a Tablespace?
A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together.
4. What is SYSTEM tablespace and When is it Created?
Every ORACLE database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.
5. Explain the relationship among Database, Tablespace and Data file.
Each databases logically divided into one or more tablespaces One or more data files are explicitly created for each tablespace.
6. What is schema?
A schema is collection of database objects of a User.
7. What are Schema Objects ?
Schema objects are the logical structures that directly refer to the database's data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions packages anddatabase links.
8. Can objects of the same Schema reside in different tablespaces.?
Yes.
9. Can a Tablespace hold objects from different Schemes ?
Yes.
10. what is Table ?
A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.
11. What is a View ?
A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)
12. Do View contain Data ?
Views do not contain or store data.
13. Can a View based on another View ?
Yes.
14. What are the advantages of Views ?
Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.
Hide data complexity.
Simplify commands for the user.
Present the data in a different perpecetive from that of the base table.
Store complex queries.
15. What is a Sequence ?
A sequence generates a serial list of unique numbers for numerical columns of a database's tables.
16. What is a Synonym ?
A synonym is an alias for a table, view, sequence or program unit.
17. What are the type of Synonyms?
There are two types of Synonyms Private and Public.
18. What is a Private Synonyms ?
A Private Synonyms can be accessed only by the owner.
19. What is a Public Synonyms ?
A Public synonyms can be accessed by any user on the database.
20. What are synonyms used for ?
Synonyms are used to : Mask the real name and owner of an object.
Provide public access to an object
Provide location transparency for tables,views or program units of a remote database.
Simplify the SQL statements for database users.
21. What is an Index ?
An Index is an optional structure associated with a table to have direct access to rows,which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.
22. How are Indexes Update ?
Indexes are automatically maintained and used by ORACLE. Changes to table data are automatically incorporated into all relevant indexes.
23. What are Clusters ?
Clusters are groups of one or more tables physically stores together to share common columns and are often used together.
24. What is cluster Key ?
The related columns of the tables in a cluster is called the Cluster Key.
25. What is Index Cluster ?
A Cluster with an index on the Cluster Key.
26. What is Hash Cluster ?
A row is stored in a hash cluster based on the result of applying a hash function to the row's cluster key value. All rows with the same hash key value are stores together on disk.
27. When can Hash Cluster used ?
Hash clusters are better choice when a table is often queried with equality queries. For such queries the specified cluster key value is hashed. The resulting hash key value points directly to the area on disk that stores the specified rows.
28. What is Database Link ?
A database link is a named object that describes a "path" from one database to another.
29. What are the types of Database Links ?
Private Database Link, Public Database Link and Network Database Link.
30. What is Private Database Link ?
Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.
31. What is Public Database Link ?
Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global object name in a SQL statement or object definition.
3
2. What is Network Database link ?
Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition.
33. What is Data Block ?
ORACLE database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.
34. How to define Data Block size ?
A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and cann't be changed latter.
35. What is Row Chaining ?
In Circumstances, all of the data for a row in a table may not be able to fit in the same data block. When this occurs , the data for the row is stored in a chain of data block (one or more) reserved for that segment.
36. What is an Extent ?
An Extent is a specific number of contiguous data blocks, obtained in a single allocation, used to store a specific type of information.
37. What is a Segment ?
A segment is a set of extents allocated for a certain logical structure.
38. What are the different type of Segments ?
Data Segment, Index Segment, Rollback Segment and Temporary Segment.
39. What is a Data Segment ?
Each Non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.
40. What is an Index Segment ?
Each Index has an Index segment that stores all of its data.
41. What is Rollback Segment ?
A Database contains one or more Rollback Segments to temporarily store "undo" information.
42. What are the uses of Rollback Segment ?
Rollback Segments are used :
To generate read-consistent database information during database recovery to rollback uncommitted transactions for users.
43. What is a Temporary Segment ?
Temporary segments are created by ORACLE when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the system for future use.
44. What is a Data File ?
Every ORACLE database has one or more physical data files. A database's data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the data files allocated for a database.
45. What are the Characteristics of Data Files ?
A data file can be associated with only one database.Once created a data file can't change size.
One or more data files form a logical unit of database storage called a tablespace.
46. What is a Redo Log ?
The set of Redo Log files for a database is collectively known as the database's redo log.
47. What is the function of Redo Log ?
The Primary function of the redo log is to record all changes made to data.
48. What is the use of Redo Log Information ?
The Information in a redo log file is used only to recover the database from a system or media failure prevents database data from being written to a database's data files.
49. What does a Control file Contain ?
A Control file records the physical structure of the database. It contains the following information.
Database Name
Names and locations of a database's files and redolog files.
Time stamp of database creation.
50. What is the use of Control File ?
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.
51. What is a Data Dictionary ?
The data dictionary of an ORACLE database is a set of tables and views that are used as a read-only reference about the database.
It stores information about both the logical and physical structure of the database, the valid users of an ORACLE database, integrity constraints defined for tables in the database and space allocated for a schema object and how much of it is being used.
52. What is an Integrity Constrains ?
An integrity constraint is a declarative way to define a business rule for a column of a table.
53. Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
No.
54. Describe the different type of Integrity Constraints supported by ORACLE ?
NOT NULL Constraint - Disallows NULLs in a table's column.
UNIQUE Constraint - Disallows duplicate values in a column or set of columns.
PRIMARY KEY Constraint - Disallows duplicate values and NULLs in a column or set of columns.
FOREIGN KEY Constrain - Require each value in a column or set of columns match a value in a related table's UNIQUE or PRIMARY KEY.
CHECK Constraint - Disallows values that do not satisfy the logical expression of the constraint.
55. What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
A column defined as UNIQUE can contain NULLs while a column defined as PRIMARY KEY can't contain Nulls.
56. Describe Referential Integrity ?
A rule defined on a column (or set of columns) in one table that allows the insert or update of a row only if the value for the column or set of columns (the dependent value) matches a value in a column of a related table (the referenced value). It also specifies the type of data manipulation allowed on referenced data and the action to be performed on dependent data as a result of any action on referenced data.
57. What are the Referential actions supported by FOREIGN KEY integrity constraint ?
UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data.
DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.
58. What is self-referential integrity constraint ?
If a foreign key reference a parent key of the same table is called self-referential integrity constraint.
59. What are the Limitations of a CHECK Constraint ?
The condition must be a Boolean expression evaluated using the values in the row being inserted or updated and can't contain subqueries, sequence, the SYSDATE,UID,USER or USERENV SQL functions, or the pseudo columns LEVEL or ROWNUM.
60. What is the maximum number of CHECK constraints that can be defined on a column ?
No Limit.
SYSTEM ARCHITECTURE :
61. What constitute an ORACLE Instance ?
SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process.
62. What is SGA ?
The System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance.
63. What are the components of SGA ?
Database buffers, Redo Log Buffer the Shared Pool and Cursors.
64. What do Database Buffers contain ?
Database buffers store the most recently used blocks of database data. It can also contain modified data that has not yet been permanently written to disk.
65. What do Redo Log Buffers contain ?
Redo Log Buffer stores redo entries a log of changes made to the database.
66. What is Shared Pool ?
Shared Pool is a portion of the SGA that contains shared memory constructs such as shared SQL areas.
67. What is Shared SQL Area ?
A Shared SQL area is required to process every unique SQL statement submitted to a database and contains information such as the parse tree and execution plan for the corresponding statement.
68. What is Cursor ?
A Cursor is a handle ( a name or pointer) for the memory associated with a specific statement.
69. What is PGA ?
Program Global Area (PGA) is a memory buffer that contains data and control information for a server process.
70. What is User Process ?
A user process is created and maintained to execute the software code of an application program. It is a shadow process created automatically to facilitate communication between the user and the server process.
71. What is Server Process ?
Server Process handle requests from connected user process. A server process is in charge of communicating with the user process and interacting with ORACLE carry out requests of the associated user process.
72. What are the two types of Server Configurations ?
Dedicated Server Configuration and Multi-threaded Server Configuration.
73. What is Dedicated Server Configuration ?
In a Dedicated Server Configuration a Server Process handles requests for a Single User Process.
74. What is a Multi-threaded Server Configuration ?
In a Multi-threaded Server Configuration many user processes share a group of server process.
75. What is a Parallel Server option in ORACLE ?
A configuration for loosely coupled systems where multiple instance share a single physical database is called Parallel Server.
76. Name the ORACLE Background Process ?
DBWR - Database Writer.
LGWR - Log Writer
CKPT - Check Point
SMON - System Monitor
PMON - Process Monitor
ARCH - Archiver
RECO - Recover
Dnnn - Dispatcher, and
LCKn - Lock
Snnn - Server.
77. What Does DBWR do ?
Database writer writes modified blocks from the database buffer cache to the data files.
78.When Does DBWR write to the database ?
DBWR writes when more data needs to be read into the SGA and too few database buffers are free. The least recently used data is written to the data files first. DBWR also writes when CheckPoint occurs.
79. What does LGWR do ?
Log Writer (LGWR) writes redo log entries generated in the redo log buffer of the SGA to on-line Redo Log File.
80. When does LGWR write to the database ?
LGWR writes redo log entries into an on-line redo log file when transactions commit and the log buffer files are full.
81. What is the function of checkpoint(CKPT)?
The Checkpoint (CKPT) process is responsible for signaling DBWR at checkpoints and updating all the data files and control files of the database.
82. What are the functions of SMON ?
System Monitor (SMON) performs instance recovery at instance start-up. In a multiple instance system (one that uses the Parallel Server), SMON of one instance can also perform instance recovery for other instance that have failed SMON also cleans up temporary segments that are no longer in use and recovers dead transactions skipped during crash and instance recovery because of file-read or off-line errors. These transactions are eventually recovered by SMON when the tablespace or file is brought back on-line SMON also coalesces free extents within the database to make free space contiguous and easier to allocate.
83. What are functions of PMON ?
Process Monitor (PMON) performs process recovery when a user process fails PMON is responsible for cleaning up the cache and Freeing resources that the process was using PMON also checks on dispatcher and server processes and restarts them if they have failed.
84. What is the function of ARCH ?
Archiver (ARCH) copies the on-line redo log files to archival storage when they are full. ARCH is active only when a database's redo log is used in ARCHIVELOG mode.
85. What is function of RECO ?
RECOver (RECO) is used to resolve distributed transactions that are pending due to a network or system failure in a distributed database. At timed intervals,the local RECO attempts to connect to remote databases and automatically complete the commit or rollback of the local portion of any pending distributed transactions.
86. What is the function of Dispatcher (Dnnn) ?
Dispatcher (Dnnn) process is responsible for routing requests from connected user processes to available shared server processes and returning the responses back to the appropriate user processes.
87. How many Dispatcher Processes are created ?
Atleast one Dispatcher process is created for every communication protocol in use.
88. What is the function of Lock (LCKn) Process ?
Lock (LCKn) are used for inter-instance locking when the ORACLE Parallel Server option is used.
89. What is the maximum number of Lock Processes used ?
Though a single LCK process is sufficient for most Parallel Server systems
upto Ten Locks (LCK0,....LCK9) are used for inter-instance locking.
DATA ACCESS
90. Define Transaction ?
A Transaction is a logical unit of work that comprises one or more SQL statements executed by a single user.
91. When does a Transaction end ?
When it is committed or Rollbacked.
92. What does COMMIT do ?
COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed.
93. What does ROLLBACK do ?
ROLLBACK retracts any of the changes resulting from the SQL statements in the transaction.
94. What is SAVE POINT ?
For long transactions that contain many SQL statements, intermediate markers or savepoints can be declared which can be used to divide a transaction into smaller parts. This allows the option of later rolling back all work performed from the current point in the transaction to a declared savepoint within the transaction.
95. What is Read-Only Transaction ?
A Read-Only transaction ensures that the results of each query executed in the transaction are consistant with respect to the same point in time.
96. What is the function of Optimizer ?
The goal of the optimizer is to choose the most efficient way to execute a SQL statement.
97. What is Execution Plan ?
The combinations of the steps the optimizer chooses to execute a statement is called an execution plan.
98. What are the different approaches used by Optimizer in choosing an execution plan ?
Rule-based and Cost-based.
99. What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.
100. What are the values that can be specified for OPTIMIZER MODE Parameter ?
COST and RULE.
101. Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost'?
Presence of statistics in the data dictionary for atleast one of the tables accessed by the SQL statements is necessary for the OPTIMIZER to use COST-based approach. Otherwise OPTIMIZER chooses RULE-based approach.
102. What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
This value causes the optimizer to choose the rule_based approach for all SQL statements issued to the instance regardless of the presence of statistics.
103. What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
CHOOSE,ALL_ROWS,FIRST_ROWS and RULE.
104. What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.
105. What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
This value causes the optimizer to the cost-based approach for all SQL statements in the session regardless of the presence of statistics and to optimize with a goal of best throughput.
106. What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
This value causes the optimizer to use the cost-based approach for all SQL statements in the session regardless of the presence of statistics and to optimize with a goal of best response time.
107. What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
This value causes the optimizer to choose the rule-based approach for all SQL statements in a session regardless of the presence of statistics.
108. What is RULE-based approach to optimization ?
Choosing an executing planbased on the access paths available and the ranks of these access paths.
109. What is COST-based approach to optimization ?
Considering available access paths and determining the most efficient execution plan based on statistics in the data dictionary for the tables accessed by the statement and their associated clusters and indexes.
PROGRAMMATIC CONSTRUCTS
110. What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
Procedures and Functions,Packages and Database Triggers.
111. What is a Procedure ?
A Procedure consist of a set of SQL and PL/SQL statements that are grouped together as a unit to solve a specific problem or perform a set of related tasks.
112. What is difference between Procedures and Functions ?
A Function returns a value to the caller where as a Procedure does not.
113. What is a Package ?
A Package is a collection of related procedures, functions, variables and other package constructs together as a unit in the database.
114. What are the advantages of having a Package ?
Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance (for example all objects of the package are parsed compiled, and loaded into memory once)
115. What is Database Trigger ?
A Database Trigger is procedure (set of SQL and PL/SQL statements) that is automatically executed as a result of an insert in,update to, or delete from a table.
116. What are the uses of Database Trigger ?
Database triggers can be used to automatic data generation, audit data modifications, enforce complex Integrity constraints, and customize complex security authorizations.
117. What are the differences between Database Trigger and Integrity constraints ?
A declarative integrity constraint is a statement about the database that is always true. A constraint applies to existing data in the table and any statement that manipulates the table.
A trigger does not apply to data loaded before the definition of the trigger, therefore, it does not guarantee all data in a table conforms to the rules established by an associated trigger.
A trigger can be used to enforce transitional constraints where as a declarative integrity constraint cannot be used.
DATABASE SECURITY
118. What are Roles ?
Roles are named groups of related privileges that are granted to users or other roles.
119. What are the use of Roles ?
REDUCED GRANTING OF PRIVILEGES - Rather than explicitly granting the same set of privileges to many users a database administrator can grant the privileges for a group of related users granted to a role and then grant only the role to each member of the group.
DYNAMIC PRIVILEGE MANAGEMENT - When the privileges of a group must change, only the privileges of the role need to be modified. The security domains of all users granted the group's role automatically reflect the changes made to the role.
SELECTIVE AVAILABILITY OF PRIVILEGES - The roles granted to a user can be selectively enable (available for use) or disabled (not available for use). This allows specific control of a user's privileges in any given situation.
APPLICATION AWARENESS - A database application can be designed to automatically enable and disable selective roles when a user attempts to use the application.
120. How to prevent unauthorized use of privileges granted to a Role ?
By creating a Role with a password.
121. What is default tablespace ?
The Tablespace to contain schema objects created without specifying a tablespace name.
122. What is Tablespace Quota ?
The collective amount of disk space available to the objects in a schema on a particular tablespace.
123. What is a profile ?
Each database user is assigned a Profile that specifies limitations on various system resources available to the user.
124. What are the system resources that can be controlled through Profile ?
The number of concurrent sessions the user can establish the CPU processing time available to the user's session the CPU processing time available to a single call to ORACLE made by a SQL statement the amount of logical I/O available to the user's session the amout of logical I/O available to a single call to ORACLE made by a SQL statement the allowed amount of idle time for the user's session the allowed amount of connect time for the user's session.
125. What is Auditing ?
Monitoring of user access to aid in the investigation of database use.
126. What are the different Levels of Auditing ?
Statement Auditing, Privilege Auditing and Object Auditing.
127. What is Statement Auditing ?
Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.
128. What is Privilege Auditing ?
Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.
129. What is Object Auditing ?
Object auditing is the auditing of accesses to specific schema objects without regard to user.
DISTRIBUTED PROCESSING AND DISTRIBUTED DATABASES
130. What is Distributed database ?
A distributed database is a network of databases managed by multiple database servers that appears to a user as single logical database. The data of all databases in the distributed database can be simultaneously accessed and modified.
131. What is Two-Phase Commit ?
Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase, a Prepare Phase and a Commit Phase.
132. Describe two phases of Two-phase commit ?
Prepare phase - The global coordinator (initiating node) ask a participants to prepare (to promise to commit or rollback the transaction, even if there is a failure)
Commit - Phase - If all participants respond to the coordinator that they are prepared, the coordinator asks all nodes to commit the transaction, if all participants cannot prepare, the coordinator asks all nodes to roll back the transaction.
133. What is the mechanism provided by ORACLE for table replication ?
Snapshots and SNAPSHOT LOGs
134. What is a SNAPSHOT ?
Snapshots are read-only copies of a master table located on a remote node which is periodically refreshed to reflect changes made to the master table.
135. What is a SNAPSHOT LOG ?
A snapshot log is a table in the master database that is associated with the master table. ORACLE uses a snapshot log to track the rows that have been updated in the master table. Snapshot logs are used in updating the snapshots based on the master table.
136. What is a SQL * NET?
SQL *NET is ORACLE's mechanism for interfacing with the communication protocols used by the networks that facilitate distributed processing and distributed databases. It is used in Clint-Server and Server-Server communications.
DATABASE OPERATION, BACKUP AND RECOVERY
137. What are the steps involved in Database Startup ?
Start an instance, Mount the Database and Open the Database.
138. What are the steps involved in Database Shutdown ?
Close the Database, Dismount the Database and Shutdown the Instance.
139. What is Restricted Mode of Instance Startup ?
An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the RESTRICTED SESSION system privilege.
140. What are the different modes of mounting a Database with the Parallel Server ?
Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database.
Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database.
141. What is Full Backup ?
A full backup is an operating system backup of all data files, on-line redo log files and control file that constitute ORACLE database and the parameter.
142. Can Full Backup be performed when the database is open ?
No.
143. What is Partial Backup ?
A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.
144.WhatisOn-lineRedoLog?
The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the corresponding redo entries temporarily stores in redo log buffers of the SGA are written to an on-line redo log file by the background process LGWR. The on-line redo log files are used in cyclical fashion.
145. What is Mirrored on-line Redo Log ?
A mirrored on-line redo log consists of copies of on-line redo log files physically located on separate disks, changes made to one member of the group are made to all members.
146. What is Archived Redo Log ?
Archived Redo Log consists of Redo Log files that have archived before being reused.
147. What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?
Complete database recovery from disk failure is possible only in ARCHIVELOG mode.
Online database backup is possible only in ARCHIVELOG mode.
148. What is Log Switch ?
The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch.
149. What are the steps involved in Instance Recovery ?
R_olling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo log, including the contents of rollback segments.
Rolling back transactions that have been explicitly rolled back or have not been committed as indicated by the rollback segments regenerated in step a.
Releasing any resources (locks) held by transactions in process at the time of the failure.
Resolving any pending distributed transactions undergoing a two-phase commit at the time of the instance failure.
What are Dimension-Measure-Detail Objects?
When creating universes, universe designers define and qualify objects. The qualification of an object reveals how it can be used in analysis in reports. An object can be qualified as a dimension, a detail, or a measure.
A dimension object is the object being tracked; in other words, it can be considered the focus of the analysis. A dimension can be an object such as Service, Price, or Customer.Dimension objects retrieve the data that will provide the basis for analysis in a report. Dimension objects typically retrieve character-type data (customer names, resort names, etc.), or dates (years, quarters, reservation dates, etc.)
A detail object provides descriptive data about a dimension object (or attribute of a dimension). It is always associated with a specific dimension object. However, a detail object cannot be used in drill down analysis. E.g. Address & phone number can be attributes about the customer dimension.
A measure object is derived from one of the following aggregate functions:Count, Sum, Minimum, Maximum or average or is a numeric data item on which you can apply, at least locally, one of those functions. This type of object provides statistical information. Examples of measure objects include the following:Revenue, unit price etc
A dimension object is the object being tracked; in other words, it can be considered the focus of the analysis. A dimension can be an object such as Service, Price, or Customer.Dimension objects retrieve the data that will provide the basis for analysis in a report. Dimension objects typically retrieve character-type data (customer names, resort names, etc.), or dates (years, quarters, reservation dates, etc.)
A detail object provides descriptive data about a dimension object (or attribute of a dimension). It is always associated with a specific dimension object. However, a detail object cannot be used in drill down analysis. E.g. Address & phone number can be attributes about the customer dimension.
A measure object is derived from one of the following aggregate functions:Count, Sum, Minimum, Maximum or average or is a numeric data item on which you can apply, at least locally, one of those functions. This type of object provides statistical information. Examples of measure objects include the following:Revenue, unit price etc
BO XI R2 Architecture (5 Tier's)
We have five tiers in BOXI
1.Client Tier
The client tier is the only part of the BusinessObjects Enterprise system that administrators and end users interact with directly. This tier is made up of the applications that enable people to administer, publish, and view reports and other objects
2.Application tier
The application tier hosts the server-side components that process requests from the client tier as well as the components that communicate these requests to the appropriate server in the intelligence tier
3.Intelligence Tier
The intelligence tier manages the BusinessObjects Enterprise system. It maintains all of the security information, sends requests to the appropriate servers, manages audit information, and stores report instances
4.Processing tier
The processing tier accesses the data and generates the reports. It is the only tier that interacts directly with the databases that contain the report data
5.Data Tier
The data tier is made up of the databases that contain the data used in the reports. BusinessObjects Enterprise supports a wide range of corporate databases
New Features in BO XI R2
New Features in BO XI R2
It's been few months since Business Objects XIr2 has hit the market. Unfortunately I still haven't got a chance to play my hands on it. Today I was reading about some of the new features provided in XIr2 and I was happy to learn about two new features that were most wanted by almost all the users I have dealt with.
1) To be able to email the reports while scheduling using Broadcast Agent- In previous versions of Business Objects we needed to write some macros and do some tweaks at the server to achieve this. But in XIr2, this feature is built-in to the product.
2) To be able to schedule based on a business calendar- This is very common and very realistic from the user's point of view as the business calendar varies from each company and scheduling goes useless without this feature many-a-times.Business Objects is in the market for almost 10 years but they weren't able to put these features all this time. Thanks to Crystal reports who was bought by Business Objects and brought these nice features into Business Objects products too.
It's been few months since Business Objects XIr2 has hit the market. Unfortunately I still haven't got a chance to play my hands on it. Today I was reading about some of the new features provided in XIr2 and I was happy to learn about two new features that were most wanted by almost all the users I have dealt with.
1) To be able to email the reports while scheduling using Broadcast Agent- In previous versions of Business Objects we needed to write some macros and do some tweaks at the server to achieve this. But in XIr2, this feature is built-in to the product.
2) To be able to schedule based on a business calendar- This is very common and very realistic from the user's point of view as the business calendar varies from each company and scheduling goes useless without this feature many-a-times.Business Objects is in the market for almost 10 years but they weren't able to put these features all this time. Thanks to Crystal reports who was bought by Business Objects and brought these nice features into Business Objects products too.
Glossary Of Business Objects Terms
Glossary Of Business Objects Terms
Aggregate
A calculation that returns totals, percentages, etc. in which any of the following functions are used:
Average, Count, Max, Min, StdDev, StdDevP, Sum, Var, VarP.
Alerter
Used to highlight data based on conditions set for a particular column by the user. Similar to Conditional Formatting used in Excel.
Block
Generic term used to describe tables, crosstabs and charts containing data from the Data Provider in Business Objects.
Business Answer
An operational result that confirms a report’s accuracy in answering the business question.
Business Objects Report
A document produced by Business Objects that contains both data and formatting.
Business Question
The operational, defined question that guides the building of a query or report.
Case Universe
A view or construct of the ODS organized with respect to information found in and associated with the Case folder in CWS/CMS.
Cell
A rectangular formatting object found in or outside of a block. A Cell contains the value of a variable.
Chart
A visual representation of data from the report’s Data Provider.
Class
A collection of related objects contained in the same folder in a Business Objects universe.
Column
A vertical collection of cells, a column usually provides the values for a particular variable.
Condition
A definition designed to exclude undesirable values from a report, leaving only desired values, e.g., Case End Date Is null excludes closed cases.
Constant
An unchanging value against which a variable is compared, e.g., the constant “3” is used in the condition: Focus Age (Years) Greater than 3.
Count
The number of distinct occurrences in a set of values, e.g., a count of 1, 1,1,2,2,5 returns 3.
Count All
Count of all rows (values) in data, e.g., 1,1,1,2,2,5 returns 6.
Crosstab
A two-dimensional representation of data. Variables are displayed in columns, rows, and (usually a count) in the body.
Cube
Another term for the Data Provider where the data from a query is contained.
Custom Sort
Ordering data in sorts other than ascending (A-Z) and descending (Z-A).
Data Provider
A structure in which the retrieved data is stored in the Business Objects document. The embedded data in a Data Provider is displayed in charts, tables, and crosstabs. A report may have more than one Data Provider.
Data tab
The Data tab is used to manage the variables in your report. You can view this list in two different ways. In alphabetical order, all the variables in the document are listed in alphabetical order with the variables in the Variables folder and the formulas in the Formulas folder. By query, variables are grouped into the queries from which they were returned.
Detail
Provides additional information on an associated object. For example, the object Referral Received Date contains the details: Fed Quarter and State Quarter, among others, to assist in determining the number of referrals received during each of those periods.
Dimension
Key objects you are most likely to base your queries on as either Result Objects or in Conditions. Dimensions are typically character-type data (client names, 19-digit numbers, etc.), or dates (DOB’s, start dates, etc.).
Document
A Business Objects file with the extension “rep.” A document contains both data and formatting.
Drill
A method for exploring or displaying data in progressively greater detail. A very powerful function in Business Objects used for “data mining.”
Edit Data Provider
Also known as the Query Panel, where Result Objects and Conditions can be defined.
Extract Date
The day the data was copied from the production CWS/CMS database to the ODS. It is a useful object to include in a report as it shows readers how current the data is.
Filter
Reduces the amount of data displayed to specific values, e.g., a filter on Case Active Service Component may show only Permanent Placement cases.
Footer
The space at the bottom of the page below the report area used to identify your report and add page information to your report.
Formula
The definition of the contents of a cell, e.g., =. Can contain text, functions (e.g., calculating a date 30 days after a start date), operators, and variables.
Function
Functions are used to create formulas and variables. They are predefined routines to return information in a different form. For example, you have a start date of 04/19/00; use the function Year () to return 2000.
Grid
A matrix of lines placed in the background to aid report layouts.
Header
The space at the top of the page above the report area used to identify your report and add page information to your report.
Map tab
The Map tab is used to manage the structure of your document. It has two views: a navigation view which displays a list of all the reports in the Business Objects document, or a structure view which displays a list of all the components in the selected report.
Measure
Numeric data that is the result of calculations performed on a dimension object in the database, e.g., Case Count is a measure of the number of cases in a given cube.
Null
The absence of data in an attribute, where no value is entered. This is different from an attribute that contains a zero, as a zero is a placeholder created by the system. For example, a case end date that has no value is said to be null (an open case).
Object
A unit that represents a variable in a database. Objects have been created to equal fields in the CWS/CMS database.
ODSxx Universe
A view or construct of the ODS organized using the CWS/CMS database physical names for entities and attributes. Classes are organized by entity (table) and contain the objects that match the attributes (columns) for that entity.
Operand
The object value to be searched for. In the condition Focus Age (Years) Equal to 18, the operand is 18.
Operands (Defined)
· You can create a condition that will compare the object with a Calculation. Some of the functions available include sum, min, max, average, and count.
· Create a subquery (All) and Create a subquery (ANY) allow you to create a query within a query; the subquery returns either all or any values, which are then used in the main query’s conditions.
· Business Objects can compare the values of two different objects using Select an object, such as “Case Plan Approval Date Less than or equal to COHP Start Date.”
· Show a list of prompts allows you to reuse an existing prompt. The user has to enter the value only once in order to complete more than one condition using the same prompt.
· Use Show a list of values to display values associated with the selected variable. Case Active Service Component will display Emergency Response, Family Maintenance, Family Reunification, and Permanent Placement. “Show a list of values” queries the database for values; Case Focus Child DOB will find all the birth dates in your county data.
· Type a new constant will allow entry of a specific value. For example, using “Focus Child Age (Years) Equal to,” you can enter a constant of ‘10’ to show children 10 years old.
· Type a new prompt gives you the ability to create a dialog box in which the user enters values for the conditions (dates, unit names, etc.). “Focus Age (years) Equal to Prompt (‘Enter age of child’)” will display a dialog with the title indicated in parentheses.
Operator
The specification of the relationship between the object and the operand. In the condition “Case Start Date Greater than 01/01/01” the operator is ‘Greater than’.
Operators (Defined)
· Between returns values between two operands. “Referral Received Date Between ‘01/01/00 12:00:00 AM’ and ‘06/30/00 12:00:00 AM’” will retrieve only referrals where the received date falls between the two constants (i.e. first half of 2000).
· Not between is the opposite of “Between,” e.g., “Referral Received Time Not between ‘08:00:00 AM’ and ‘05:00:00 PM’” will find referrals received after hours.
· Both is similar to a combined intersect query. The values returned will be equal to both values specified in the operand. For example, if the condition “Case Service Component Both ‘Emergency Response, Family Maintenance’” is employed, result objects will be returned for cases that have had both ER and FM as service components.
· Different from is the opposite of Equal to. It can be used to exclude variables (e.g., Case Intervention Reason Different from ‘Adoption Services’).
· Use Equal to when the desired object must be a certain value. “Equal to” can be used, for example, to indicate a preferred program (Case Active Service Component Equal to ‘Family Maintenance’), or a particular age (Focus Age (Years) Equal to ‘17’).
· Except is equivalent to a combined minus query. Except will return values that are different from the values specified in the operand, e.g., “Focus Gender Code Except ‘U’” will show focus children identified as either male or female, and not ‘unknowns.’
· Greater than, and Greater than or equal to can be used to establish the lower limit of a variable. For example, “Referral Duration Greater than or equal to ‘30’” will find referrals open thirty days or more.
· In list is the expanded form of “Equal to.” Use it when you want a variable that is included in a set of choices. “Placement Facility Type In list ‘Foster Family Home; FFA-Certified Home; Relative Home’” will find any of those Facility Types.
· The opposite of “In list” is Not in list. The variable is excluded from a list of results, e.g., “Placement Facility Not in list ‘County Shelter/Recv Home; Medical Facility.’
· Is null will return only objects that contain empty rows in the database. For example, “COHP End Date Is null” will only show the Result Objects for cases that have an open placement in the database.
· Is not null is the opposite of “Is null.” The object in the condition must have a value in it. “CP Effective Date Is not null” will show results only for cases with an approved case plan on file.
· Less than and Less than or equal to are used to create the upper limits of a variable. “Victim Age (Years) Less than or equal to ‘3’” can be used to find children with referral allegations who are three years of age and younger.
· Matches pattern will find variables that include the same character string. The condition “Focus Last Name Matches pattern ‘Smith%’ will return result objects such as Smith, Smithsonian, and Smithy. You can use the wildcards “%” (more than one unknown character) and “_” (a single character placeholder).
· You can also employ wildcards in Different from pattern. This operator is the antithesis of “Matches pattern,” excluding values that contain the specified character string.
Personal Data Files
Text, Excel, or Dbase files that can be imported into or exported from Business Objects. A Data Provider may be created from a Personal Data File rather than from a query in a Business Objects universe.
Pivot
A method for changing the axis of a displayed table, in which objects in rows are exchanged with objects in columns.
Predefined Conditions
Conditions built by the universe author; these are usually common conditions and included for convenience. For example, the Case universe contains a predefined condition “Open FM Cases Over 1 Year.” You can apply one or more predefined conditions when you build a query.
Prompt
A dialogue box defined by the report writer in a query’s conditions that requires an entry when the report is refreshed or run. Prompts are handy for reports that are run often, but with changing timeframes.
Purge
Empties data from the cube of a report; does not affect report formatting. Purge your data if you want to share a report with another county, but do not wish to include your county’s data in the report.
Query
A process by which data is retrieved from the database. A set of variables to be returned with associated conditions.
Query Panel
A window in Business Objects where report writers can specify the variables to be returned from a database, and the conditions applied to those variables. Also known as Edit Data Provider.
Referral Universe
A view or construct of the ODS organized with respect to information found in and associated with the Referral folder in CWS/CMS.
Refresh/Run
Updates the data in your report to the latest extract from the database. You can refresh all the data in your report or you can refresh individual cubes from the Data Manager.
Report
The focal point of your work with in Business Objects: where you view, analyze, and format data. A report is equal to a page tab in a Business Objects document, and there can be more than one in a document.
Report Manager
A key part of the Business Objects workspace that enables you to manage many different aspects of your work in Business Objects quickly and easily. It has two tabs: the Data tab is used to manage all the variables in your report, and the Map tab is used to work on the structure and formatting of report components.
Result Objects
The area of the Query Panel where objects are placed for the purposes of retrieving values.
Row
A record of a table. A row is created for each record added to the database, e.g., a new case on the case table.
Save And Close
An option available in the Query Panel, which allows the query to be saved without retrieving data. This is very helpful when creating large and/or multiple queries, and you need to save the Query Panel but do not want to wait for Business Objects to retrieve all records.
Scope Of Analysis
A subset of data returned by a query that you would use for analysis in your report. The data for your scope of analysis does not appear in the report until you use it in analysis.
The scope of analysis you can define depends on hierarchies in the universe. A hierarchy, which the designer sets up when creating the universe consists of dimension objects ranked from less detailed to more detailed. For example, the Service Component hierarchy in the Case universe consists of the following dimension objects: Case Active Service Component, Focus Primary Ethnicity, Focus Primary Language, Focus Gender Code, Focus Age (Years), Pri Staff Name Formatted, Case Name, & Case ID Number. You select dimension objects that belong to hierarchies to define the scope of analysis.
Slice and Dice
A user-friendly, graphical way of analyzing data. It displays the contents of the current report, and enables you to:
· Add, move and remove data.
· Switch between block types, e.g., turning tables into crosstabs.
· Build and edit master/detail reports.
· Apply, edit, and remove breaks, filters, sorts, ranking and calculations.
Snap to grid
Activates a grid for positioning blocks and/or master cells with precision. Snap to Grid is a toggle command, which either activates or deactivates the grid. When you activate the grid and move a block or master cell in the report, it is automatically aligned to the closest grid intersection.
Subquery
As part of a larger query, subqueries retrieve data with their own set of conditions, and then apply that data to the primary query in one of three ways. Subqueries can be union, intersection, or minus.
Table
A collection of associated information in a database stored in rows. Tables are also called entities in the CWS/CMS database.
Time encapsulation
A report-writing method by which data is retrieved only for variables during a given period of time. Using prompts in your conditions, as well as taking into account start and end dates, help you define a time encapsulation.
Universe
In Business Objects, a logical construct of classes and objects, and the links connecting them, that defines a view of CWS/CMS data.
Variable
A named formula. Business Objects includes predefined variables (objects) in its universes, or you may create your own variables.
Aggregate
A calculation that returns totals, percentages, etc. in which any of the following functions are used:
Average, Count, Max, Min, StdDev, StdDevP, Sum, Var, VarP.
Alerter
Used to highlight data based on conditions set for a particular column by the user. Similar to Conditional Formatting used in Excel.
Block
Generic term used to describe tables, crosstabs and charts containing data from the Data Provider in Business Objects.
Business Answer
An operational result that confirms a report’s accuracy in answering the business question.
Business Objects Report
A document produced by Business Objects that contains both data and formatting.
Business Question
The operational, defined question that guides the building of a query or report.
Case Universe
A view or construct of the ODS organized with respect to information found in and associated with the Case folder in CWS/CMS.
Cell
A rectangular formatting object found in or outside of a block. A Cell contains the value of a variable.
Chart
A visual representation of data from the report’s Data Provider.
Class
A collection of related objects contained in the same folder in a Business Objects universe.
Column
A vertical collection of cells, a column usually provides the values for a particular variable.
Condition
A definition designed to exclude undesirable values from a report, leaving only desired values, e.g., Case End Date Is null excludes closed cases.
Constant
An unchanging value against which a variable is compared, e.g., the constant “3” is used in the condition: Focus Age (Years) Greater than 3.
Count
The number of distinct occurrences in a set of values, e.g., a count of 1, 1,1,2,2,5 returns 3.
Count All
Count of all rows (values) in data, e.g., 1,1,1,2,2,5 returns 6.
Crosstab
A two-dimensional representation of data. Variables are displayed in columns, rows, and (usually a count) in the body.
Cube
Another term for the Data Provider where the data from a query is contained.
Custom Sort
Ordering data in sorts other than ascending (A-Z) and descending (Z-A).
Data Provider
A structure in which the retrieved data is stored in the Business Objects document. The embedded data in a Data Provider is displayed in charts, tables, and crosstabs. A report may have more than one Data Provider.
Data tab
The Data tab is used to manage the variables in your report. You can view this list in two different ways. In alphabetical order, all the variables in the document are listed in alphabetical order with the variables in the Variables folder and the formulas in the Formulas folder. By query, variables are grouped into the queries from which they were returned.
Detail
Provides additional information on an associated object. For example, the object Referral Received Date contains the details: Fed Quarter and State Quarter, among others, to assist in determining the number of referrals received during each of those periods.
Dimension
Key objects you are most likely to base your queries on as either Result Objects or in Conditions. Dimensions are typically character-type data (client names, 19-digit numbers, etc.), or dates (DOB’s, start dates, etc.).
Document
A Business Objects file with the extension “rep.” A document contains both data and formatting.
Drill
A method for exploring or displaying data in progressively greater detail. A very powerful function in Business Objects used for “data mining.”
Edit Data Provider
Also known as the Query Panel, where Result Objects and Conditions can be defined.
Extract Date
The day the data was copied from the production CWS/CMS database to the ODS. It is a useful object to include in a report as it shows readers how current the data is.
Filter
Reduces the amount of data displayed to specific values, e.g., a filter on Case Active Service Component may show only Permanent Placement cases.
Footer
The space at the bottom of the page below the report area used to identify your report and add page information to your report.
Formula
The definition of the contents of a cell, e.g., =
Function
Functions are used to create formulas and variables. They are predefined routines to return information in a different form. For example, you have a start date of 04/19/00; use the function Year (
Grid
A matrix of lines placed in the background to aid report layouts.
Header
The space at the top of the page above the report area used to identify your report and add page information to your report.
Map tab
The Map tab is used to manage the structure of your document. It has two views: a navigation view which displays a list of all the reports in the Business Objects document, or a structure view which displays a list of all the components in the selected report.
Measure
Numeric data that is the result of calculations performed on a dimension object in the database, e.g., Case Count is a measure of the number of cases in a given cube.
Null
The absence of data in an attribute, where no value is entered. This is different from an attribute that contains a zero, as a zero is a placeholder created by the system. For example, a case end date that has no value is said to be null (an open case).
Object
A unit that represents a variable in a database. Objects have been created to equal fields in the CWS/CMS database.
ODSxx Universe
A view or construct of the ODS organized using the CWS/CMS database physical names for entities and attributes. Classes are organized by entity (table) and contain the objects that match the attributes (columns) for that entity.
Operand
The object value to be searched for. In the condition Focus Age (Years) Equal to 18, the operand is 18.
Operands (Defined)
· You can create a condition that will compare the object with a Calculation. Some of the functions available include sum, min, max, average, and count.
· Create a subquery (All) and Create a subquery (ANY) allow you to create a query within a query; the subquery returns either all or any values, which are then used in the main query’s conditions.
· Business Objects can compare the values of two different objects using Select an object, such as “Case Plan Approval Date Less than or equal to COHP Start Date.”
· Show a list of prompts allows you to reuse an existing prompt. The user has to enter the value only once in order to complete more than one condition using the same prompt.
· Use Show a list of values to display values associated with the selected variable. Case Active Service Component will display Emergency Response, Family Maintenance, Family Reunification, and Permanent Placement. “Show a list of values” queries the database for values; Case Focus Child DOB will find all the birth dates in your county data.
· Type a new constant will allow entry of a specific value. For example, using “Focus Child Age (Years) Equal to,” you can enter a constant of ‘10’ to show children 10 years old.
· Type a new prompt gives you the ability to create a dialog box in which the user enters values for the conditions (dates, unit names, etc.). “Focus Age (years) Equal to Prompt (‘Enter age of child’)” will display a dialog with the title indicated in parentheses.
Operator
The specification of the relationship between the object and the operand. In the condition “Case Start Date Greater than 01/01/01” the operator is ‘Greater than’.
Operators (Defined)
· Between returns values between two operands. “Referral Received Date Between ‘01/01/00 12:00:00 AM’ and ‘06/30/00 12:00:00 AM’” will retrieve only referrals where the received date falls between the two constants (i.e. first half of 2000).
· Not between is the opposite of “Between,” e.g., “Referral Received Time Not between ‘08:00:00 AM’ and ‘05:00:00 PM’” will find referrals received after hours.
· Both is similar to a combined intersect query. The values returned will be equal to both values specified in the operand. For example, if the condition “Case Service Component Both ‘Emergency Response, Family Maintenance’” is employed, result objects will be returned for cases that have had both ER and FM as service components.
· Different from is the opposite of Equal to. It can be used to exclude variables (e.g., Case Intervention Reason Different from ‘Adoption Services’).
· Use Equal to when the desired object must be a certain value. “Equal to” can be used, for example, to indicate a preferred program (Case Active Service Component Equal to ‘Family Maintenance’), or a particular age (Focus Age (Years) Equal to ‘17’).
· Except is equivalent to a combined minus query. Except will return values that are different from the values specified in the operand, e.g., “Focus Gender Code Except ‘U’” will show focus children identified as either male or female, and not ‘unknowns.’
· Greater than, and Greater than or equal to can be used to establish the lower limit of a variable. For example, “Referral Duration Greater than or equal to ‘30’” will find referrals open thirty days or more.
· In list is the expanded form of “Equal to.” Use it when you want a variable that is included in a set of choices. “Placement Facility Type In list ‘Foster Family Home; FFA-Certified Home; Relative Home’” will find any of those Facility Types.
· The opposite of “In list” is Not in list. The variable is excluded from a list of results, e.g., “Placement Facility Not in list ‘County Shelter/Recv Home; Medical Facility.’
· Is null will return only objects that contain empty rows in the database. For example, “COHP End Date Is null” will only show the Result Objects for cases that have an open placement in the database.
· Is not null is the opposite of “Is null.” The object in the condition must have a value in it. “CP Effective Date Is not null” will show results only for cases with an approved case plan on file.
· Less than and Less than or equal to are used to create the upper limits of a variable. “Victim Age (Years) Less than or equal to ‘3’” can be used to find children with referral allegations who are three years of age and younger.
· Matches pattern will find variables that include the same character string. The condition “Focus Last Name Matches pattern ‘Smith%’ will return result objects such as Smith, Smithsonian, and Smithy. You can use the wildcards “%” (more than one unknown character) and “_” (a single character placeholder).
· You can also employ wildcards in Different from pattern. This operator is the antithesis of “Matches pattern,” excluding values that contain the specified character string.
Personal Data Files
Text, Excel, or Dbase files that can be imported into or exported from Business Objects. A Data Provider may be created from a Personal Data File rather than from a query in a Business Objects universe.
Pivot
A method for changing the axis of a displayed table, in which objects in rows are exchanged with objects in columns.
Predefined Conditions
Conditions built by the universe author; these are usually common conditions and included for convenience. For example, the Case universe contains a predefined condition “Open FM Cases Over 1 Year.” You can apply one or more predefined conditions when you build a query.
Prompt
A dialogue box defined by the report writer in a query’s conditions that requires an entry when the report is refreshed or run. Prompts are handy for reports that are run often, but with changing timeframes.
Purge
Empties data from the cube of a report; does not affect report formatting. Purge your data if you want to share a report with another county, but do not wish to include your county’s data in the report.
Query
A process by which data is retrieved from the database. A set of variables to be returned with associated conditions.
Query Panel
A window in Business Objects where report writers can specify the variables to be returned from a database, and the conditions applied to those variables. Also known as Edit Data Provider.
Referral Universe
A view or construct of the ODS organized with respect to information found in and associated with the Referral folder in CWS/CMS.
Refresh/Run
Updates the data in your report to the latest extract from the database. You can refresh all the data in your report or you can refresh individual cubes from the Data Manager.
Report
The focal point of your work with in Business Objects: where you view, analyze, and format data. A report is equal to a page tab in a Business Objects document, and there can be more than one in a document.
Report Manager
A key part of the Business Objects workspace that enables you to manage many different aspects of your work in Business Objects quickly and easily. It has two tabs: the Data tab is used to manage all the variables in your report, and the Map tab is used to work on the structure and formatting of report components.
Result Objects
The area of the Query Panel where objects are placed for the purposes of retrieving values.
Row
A record of a table. A row is created for each record added to the database, e.g., a new case on the case table.
Save And Close
An option available in the Query Panel, which allows the query to be saved without retrieving data. This is very helpful when creating large and/or multiple queries, and you need to save the Query Panel but do not want to wait for Business Objects to retrieve all records.
Scope Of Analysis
A subset of data returned by a query that you would use for analysis in your report. The data for your scope of analysis does not appear in the report until you use it in analysis.
The scope of analysis you can define depends on hierarchies in the universe. A hierarchy, which the designer sets up when creating the universe consists of dimension objects ranked from less detailed to more detailed. For example, the Service Component hierarchy in the Case universe consists of the following dimension objects: Case Active Service Component, Focus Primary Ethnicity, Focus Primary Language, Focus Gender Code, Focus Age (Years), Pri Staff Name Formatted, Case Name, & Case ID Number. You select dimension objects that belong to hierarchies to define the scope of analysis.
Slice and Dice
A user-friendly, graphical way of analyzing data. It displays the contents of the current report, and enables you to:
· Add, move and remove data.
· Switch between block types, e.g., turning tables into crosstabs.
· Build and edit master/detail reports.
· Apply, edit, and remove breaks, filters, sorts, ranking and calculations.
Snap to grid
Activates a grid for positioning blocks and/or master cells with precision. Snap to Grid is a toggle command, which either activates or deactivates the grid. When you activate the grid and move a block or master cell in the report, it is automatically aligned to the closest grid intersection.
Subquery
As part of a larger query, subqueries retrieve data with their own set of conditions, and then apply that data to the primary query in one of three ways. Subqueries can be union, intersection, or minus.
Table
A collection of associated information in a database stored in rows. Tables are also called entities in the CWS/CMS database.
Time encapsulation
A report-writing method by which data is retrieved only for variables during a given period of time. Using prompts in your conditions, as well as taking into account start and end dates, help you define a time encapsulation.
Universe
In Business Objects, a logical construct of classes and objects, and the links connecting them, that defines a view of CWS/CMS data.
Variable
A named formula. Business Objects includes predefined variables (objects) in its universes, or you may create your own variables.
Overview of JOINS in Oracle
Full Outer Joins in Oracle
Among several new features, Oracle has introduced the ANSI standard join syntax. The new join syntax is not only SQL92 compliant, but it is elegant and makes the outer join syntax more intuitive. The biggest advantage of the new join syntax is its support for full outer joins, which is not directly feasible in Oracle8i. In this article I discuss the full outer join feature of Oracle9i, and provide some examples.
An outer join extends the result of an inner join by including rows from one table (say Table A) that don't have corresponding rows in another table (say Table B). An important thing to note here is that the outer join operation will not include the rows from Table B that don't have corresponding rows in Table A. In other words, an outer join is unidirectional. But there are situations when you may want a bidirectional outer join, i.e., you want to include all the rows from A and B:
• rows from the result of the inner join
• rows from A that don't have corresponding rows in B
• rows from B that don't have corresponding rows in A
Let's look at an example to understand this further. Consider the following two tables:
SQL> desc part
Name Null? Type
----------------------------------------- -------- -----------------
PART_ID NOT NULL VARCHAR2(4)
SUPPLIER_ID VARCHAR2(4)
SQL> select * from part;
PART SUPP
---- ----
P1 S1
P2 S2
P3
P4
SQL> desc supplier
Name Null? Type
----------------------------------------- -------- -----------------
SUPPLIER_ID NOT NULL VARCHAR2(4)
SUPPLIER_NAME NOT NULL VARCHAR2(20)
SQL> select * from supplier;
SUPP SUPPLIER_NAME
---- --------------------
S1 Supplier#1
S2 Supplier#2
S3 Supplier#3
Notice above that there are two parts (P3 and P4) that don't have a supplier yet. Also, there is a supplier (S3) who doesn't yet supply any part.
Result of Inner Join
Let's say our company is consolidating all of the parts and the suppliers for managing the inventory of its parts properly, and I was asked to generate a report of all the parts and their corresponding suppliers. So I performed a join of these two tables, which gave the following result:
SQL> select p.part_id, s.supplier_name
2 from part p, supplier s
3 where p.supplier_id = s.supplier_id;
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
The join shown above is an inner join, which results in just the rows that have corresponding rows in both tables. Therefore, the parts that don't have a supplier, or the suppliers that don't supply any part are excluded from the result set.
Result of Outer Join
If we want all parts to be listed in the result set, irrespective of whether they are supplied by any supplier or not, then we need to perform an outer join.
SQL> select p.part_id, s.supplier_name
2 from part p, supplier s
3 where p.supplier_id = s.supplier_id (+);
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
P3
P4
The outer join above lists all of the parts. For the parts that don't have a corresponding supplier, null values are displayed for the SUPPLIER_NAME column. However, not all the suppliers are displayed. Since supplier S3 doesn't supply any parts, it gets excluded from the result set of the above outer join. If we want all the suppliers listed in the result set, irrespective of whether they supply any part or not, we need to perform an outer join like the following:
SQL> select p.part_id, s.supplier_name
2 from part p, supplier s
3 where p.supplier_id (+) = s.supplier_id;
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
Supplier#3
The outer join above lists all the suppliers. For the suppliers that don't supply any part, null values are displayed for the PART_ID column. However, not all the parts are displayed. Since parts P3 and P4 are not supplied by any suppliers, they get excluded from the result set of the above outer join.
Full Outer Join
If we want all the parts (irrespective of whether they are supplied by any supplier or not), and all the suppliers (irrespective of whether they supply any part or not) listed in the same result set, we have a problem. That's because the traditional outer join (using the '+' operator) is unidirectional, and you can't put (+) on both sides in the join condition. The following will result in an error:
SQL> select p.part_id, s.supplier_name
2 from part p, supplier s
3 where p.supplier_id (+) = s.supplier_id (+);
where p.supplier_id (+) = s.supplier_id (+)
*
ERROR at line 3:
ORA-01468: a predicate may reference only one outer-joined table
Up through Oracle8i, Oracle programmers have used a workaround to circumvent this limitation. The workaround involves two outer join queries combined by a UNION operator, as in the following example:
SQL> select p.part_id, s.supplier_name
2 from part p, supplier s
3 where p.supplier_id = s.supplier_id (+)
4 union
5 select p.part_id, s.supplier_name
6 from part p, supplier s
7 where p.supplier_id (+) = s.supplier_id;
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
P3 Supplier#3
P4
Notice the use of the UNION set operator to combine the results of two separate outer join queries, to list all the parts and all the suppliers in the same result set.
New Join Syntax
Oracle introduced the ANSI compliant join syntax. This new join syntax uses the new keywords inner join, left outer join, right outer join, and full outer join, instead of the (+) operator.
The inner join using this new join syntax will look like:
SQL> select p.part_id, s.supplier_name
2 from part p inner join supplier s
3 on p.supplier_id = s.supplier_id;
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
Remember, if we want to retain all the parts in the result set, irrespective of whether any supplier supplies them or not, then we need to perform an outer join. The corresponding outer join query using the new syntax will be:
SQL> select p.part_id, s.supplier_name
2 from part p left outer join supplier s
3 on p.supplier_id = s.supplier_id;
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
P4
P3
This is called a "left outer join" because all the rows from the table on the left (PART) are retained in the result set. If we want to retain all the suppliers in the result set, irrespective of whether they supply any part or not, then we need to perform a "right outer join". That would look like:
SQL> select p.part_id, s.supplier_name
2 from part p right outer join supplier s
3 on p.supplier_id = s.supplier_id;
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
Supplier#3
However, the biggest advantage of the new join syntax is its support for full outer joins. Introduction of the ANSI standard join syntax in Oracle9i greatly simplifies the full outer join query. We are no longer limited by unidirectional outer join, and no longer need to use the UNION operation to perform the full outer join. Oracle9i introduced the full outer join operation to carry out such operations, as in the following example:
SQL> select p.part_id, s.supplier_name
2 from part p full outer join supplier s
3 on p.supplier_id = s.supplier_id;
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
P4
P3 Supplier#3
The above SQL statement is not only smaller in size, it is much more elegant and intuitive as well. This ANSI join syntax is also more efficient than the UNION method of achieving a full outer join.
Among several new features, Oracle has introduced the ANSI standard join syntax. The new join syntax is not only SQL92 compliant, but it is elegant and makes the outer join syntax more intuitive. The biggest advantage of the new join syntax is its support for full outer joins, which is not directly feasible in Oracle8i. In this article I discuss the full outer join feature of Oracle9i, and provide some examples.
An outer join extends the result of an inner join by including rows from one table (say Table A) that don't have corresponding rows in another table (say Table B). An important thing to note here is that the outer join operation will not include the rows from Table B that don't have corresponding rows in Table A. In other words, an outer join is unidirectional. But there are situations when you may want a bidirectional outer join, i.e., you want to include all the rows from A and B:
• rows from the result of the inner join
• rows from A that don't have corresponding rows in B
• rows from B that don't have corresponding rows in A
Let's look at an example to understand this further. Consider the following two tables:
SQL> desc part
Name Null? Type
----------------------------------------- -------- -----------------
PART_ID NOT NULL VARCHAR2(4)
SUPPLIER_ID VARCHAR2(4)
SQL> select * from part;
PART SUPP
---- ----
P1 S1
P2 S2
P3
P4
SQL> desc supplier
Name Null? Type
----------------------------------------- -------- -----------------
SUPPLIER_ID NOT NULL VARCHAR2(4)
SUPPLIER_NAME NOT NULL VARCHAR2(20)
SQL> select * from supplier;
SUPP SUPPLIER_NAME
---- --------------------
S1 Supplier#1
S2 Supplier#2
S3 Supplier#3
Notice above that there are two parts (P3 and P4) that don't have a supplier yet. Also, there is a supplier (S3) who doesn't yet supply any part.
Result of Inner Join
Let's say our company is consolidating all of the parts and the suppliers for managing the inventory of its parts properly, and I was asked to generate a report of all the parts and their corresponding suppliers. So I performed a join of these two tables, which gave the following result:
SQL> select p.part_id, s.supplier_name
2 from part p, supplier s
3 where p.supplier_id = s.supplier_id;
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
The join shown above is an inner join, which results in just the rows that have corresponding rows in both tables. Therefore, the parts that don't have a supplier, or the suppliers that don't supply any part are excluded from the result set.
Result of Outer Join
If we want all parts to be listed in the result set, irrespective of whether they are supplied by any supplier or not, then we need to perform an outer join.
SQL> select p.part_id, s.supplier_name
2 from part p, supplier s
3 where p.supplier_id = s.supplier_id (+);
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
P3
P4
The outer join above lists all of the parts. For the parts that don't have a corresponding supplier, null values are displayed for the SUPPLIER_NAME column. However, not all the suppliers are displayed. Since supplier S3 doesn't supply any parts, it gets excluded from the result set of the above outer join. If we want all the suppliers listed in the result set, irrespective of whether they supply any part or not, we need to perform an outer join like the following:
SQL> select p.part_id, s.supplier_name
2 from part p, supplier s
3 where p.supplier_id (+) = s.supplier_id;
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
Supplier#3
The outer join above lists all the suppliers. For the suppliers that don't supply any part, null values are displayed for the PART_ID column. However, not all the parts are displayed. Since parts P3 and P4 are not supplied by any suppliers, they get excluded from the result set of the above outer join.
Full Outer Join
If we want all the parts (irrespective of whether they are supplied by any supplier or not), and all the suppliers (irrespective of whether they supply any part or not) listed in the same result set, we have a problem. That's because the traditional outer join (using the '+' operator) is unidirectional, and you can't put (+) on both sides in the join condition. The following will result in an error:
SQL> select p.part_id, s.supplier_name
2 from part p, supplier s
3 where p.supplier_id (+) = s.supplier_id (+);
where p.supplier_id (+) = s.supplier_id (+)
*
ERROR at line 3:
ORA-01468: a predicate may reference only one outer-joined table
Up through Oracle8i, Oracle programmers have used a workaround to circumvent this limitation. The workaround involves two outer join queries combined by a UNION operator, as in the following example:
SQL> select p.part_id, s.supplier_name
2 from part p, supplier s
3 where p.supplier_id = s.supplier_id (+)
4 union
5 select p.part_id, s.supplier_name
6 from part p, supplier s
7 where p.supplier_id (+) = s.supplier_id;
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
P3 Supplier#3
P4
Notice the use of the UNION set operator to combine the results of two separate outer join queries, to list all the parts and all the suppliers in the same result set.
New Join Syntax
Oracle introduced the ANSI compliant join syntax. This new join syntax uses the new keywords inner join, left outer join, right outer join, and full outer join, instead of the (+) operator.
The inner join using this new join syntax will look like:
SQL> select p.part_id, s.supplier_name
2 from part p inner join supplier s
3 on p.supplier_id = s.supplier_id;
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
Remember, if we want to retain all the parts in the result set, irrespective of whether any supplier supplies them or not, then we need to perform an outer join. The corresponding outer join query using the new syntax will be:
SQL> select p.part_id, s.supplier_name
2 from part p left outer join supplier s
3 on p.supplier_id = s.supplier_id;
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
P4
P3
This is called a "left outer join" because all the rows from the table on the left (PART) are retained in the result set. If we want to retain all the suppliers in the result set, irrespective of whether they supply any part or not, then we need to perform a "right outer join". That would look like:
SQL> select p.part_id, s.supplier_name
2 from part p right outer join supplier s
3 on p.supplier_id = s.supplier_id;
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
Supplier#3
However, the biggest advantage of the new join syntax is its support for full outer joins. Introduction of the ANSI standard join syntax in Oracle9i greatly simplifies the full outer join query. We are no longer limited by unidirectional outer join, and no longer need to use the UNION operation to perform the full outer join. Oracle9i introduced the full outer join operation to carry out such operations, as in the following example:
SQL> select p.part_id, s.supplier_name
2 from part p full outer join supplier s
3 on p.supplier_id = s.supplier_id;
PART SUPPLIER_NAME
---- --------------------
P1 Supplier#1
P2 Supplier#2
P4
P3 Supplier#3
The above SQL statement is not only smaller in size, it is much more elegant and intuitive as well. This ANSI join syntax is also more efficient than the UNION method of achieving a full outer join.
Resumes of Business objects Developers
Resume 1 :
Title
Business Objects Developer
Primary Skills
Business Objects 4i, Oracle 8i, MS Access, Windows 2000/NT
Location
US-TX-Dallas
RESUME DETAILS
SUMMARY:
• Around five years of experience in Business Objects (4.3/5.0/5i/6i/XI) with around six years of professional experience in I.T. industry
• Worked extensively on modules Supervisor, Designer, Info view, Web Intelligence and Broadcast agent in Business Objects
• Knowledge of new features of Business Objects XI and 6i including Index awareness, Derived tables and Central management console-
• Experience in training Business Objects end users
• Experience on various operating systems including Windows NT/2000
• Knowledge in coding with VBA macros
• Extensively used PL/SQL in writing Stored Procedures, Functions, Packages and Triggers
• Knowledge of Dimensional modeling, Data migration, Data cleansing, Data profiling, Data mining, Data audits and Web reporting features of data warehouses
• Experience in Crystal reports and Crystal Enterprise environment
• Created and maintained complex universes supporting multiple levels of hierarchies for drill down and drill across reports
• Worked with the DBA to create aggregate tables and materialized views to improve the performance of the query by cutting down on the size of the result set at the data provider level-
• Knowledge of Oracle 7.3/8/8i/9i/10g, SQL Server 7.0/2000, Sybase databases, DB2
• Diversified experience in implementation Business objects report management with in Finance, Sales and Marketing, Supply Chain Management sectors
• Successfully implemented export to excel feature in lower versions of business objects using VBA macros
• Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures in Oracle and SQL Server
• Experience in working in a version migration environment from 5i to 6i
• An enthusiastic, project-oriented team player with solid communication and leadership skills. Also with an ability to develop creative solutions for challenging client needs
• Ability to work effectively in a team as well as individually with excellent communication and interpersonal skills. Also has an ability to develop creative solutions for challenging client needs
SKILLS:
Databases: Oracle 7.3/8/8i/9i/10G, SQL Server 7.0/2000, Sybase, DB2, and MS Access
ETL tools: SQL Loader
OLAP Tools: Business Objects (4.3/5.0/5i/6i/XI), Web Intelligence 2.6/6i, Broadcast Agent,
Central management Console, Info view, Designer, Reporter, Supervisor, Crystal Reports
Modeling Tools: ER Studio, VISIO
Data warehousing Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables, Toad,
concepts: DB Artisan, Rapid SQL
Programming Languages: SQL, PL/SQL, JAVA, HTML, XHTML
Operating systems: Windows 2000/NT.
Wells Fargo, Houston, Texas Apr 2005 - Present
Senior Business Objects Supervisor-Developer
Business Objects Report development team
Part of this assignment required for the development of reports for business analysis. These reports would be used to as the backbone in generating ad hoc reports. Another part involved an extensive work with Designer and Supervisor modules. In Designer module, created new objects after working with DBA for data procurement into Business Objects based on user needs. Also created new users and helped in access privilege issues of existing users in Supervisor module.
• Constantly worked with Business users to provide them with the data in form of complex reports and excel sheets for analysis
• Coded a Macro using VBA editor for sending a report as an attached PDF document every time the report is refreshed
• Created user profiles for new business users and also trained in using of Business Objects Reporter module
• Worked with the IT team to bring in the data required into Business Objects Universe so as to make available for super users to create Adhoc reports
• Constantly worked on complex reports providing for a report generation based on user needs
• Created reports based of free hand SQL and Universe objects
• Replicated/Migrated reports created in internal reporting tool, report retriever (an in house reporting system in the company) to Business Objects
• Worked on cross-tab and master detail reports. Also represented the same as line charts/ bar charts / pie charts of the same
• Evaluated the following features of Business Objects XI: Index awareness, Derived tables and Central management console
• Created a Business Objects User's power point presentation for an introduction to first time users and also as a handy guide
• Created several new objects in the Universe based on the report creation requirements.
• Constantly tested SQL for joins and contexts for new object creation. Using Rapid SQL conducted functional testing in the SQL of existing objects.
• Managed Universe consisting of 200 tables, 25 classes and 300 objects.
• Worked with the DBA to create aggregate tables and materialized views to improve the performance of the query by cutting down on the size of the result set at the data provider level
• Created document on usage of Info View for off site users with no full-client Business Object installed on their machines.
• Performed tuning on existing reports for better performance.
Environment: Business Objects 5.1.7, Business Objects Info View (Web I), Report Retriever reports, Visual Basic 6.0, DB2, Oracle, Windows NT
Genintech, California May 2004-Apr 2005
Senior Business Objects Supervisor-Developer
Business Objects Reports development.
• Involved in full project life cycle implementation (requirement gathering to production phase)
• Prepared the following -- business/technical writing of requirements, design templates, development standards document and detailed design documents
• Involved in extensive testing of universes and reports during version migration of business objects
• Involved in performance tuning of Business Objects reports by tuning the SQL using DB Artisan
• Involved in the installation of Business Objects repository, creation of user Ids, implementation of security features and management of the repository
• Extensively created Business Objects reports like matrix reports, tables, Pareto charts and pie charts
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc
• Extensively used Designer to design various universes for different business groups. Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.
• Involved in report bursting using Broadcast agent server
• Implemented row and object level security in business objects supervisor module
• Defined documentation standards including the creation of Entity relationship diagram (ERD) for universes
• Responsible for fitting Business Objects into the Information Architecture of the company as well as creating users privileges with supervisor. Also for developing and maintaining universes
• Managed categories that were created and assigned to documents by users
• Managed the scheduling options stored in the repository and also involved in changing the document descriptions
• Specified the standards/best practices for universes like maintaining design consistency. Also defined standards for tables, charts, etc
• Extensively used breaks for white spaces and sections for better navigation. And created template documents with header, footer and company logo
• Developed various Metadata and operational definitions
• Presented the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily
• Responsible for managing the Business Objects repository.
Environment: Business Objects 6I/XI, Broadcast agent server, Business Objects Web I, DB Artisan, Informatica Power Center 5.0, Crystal reports, Info View, Visual Basic 6.0, DB2, Oracle 9i, Windows NT.
British Petroleum, Houston,TX Sep 2003-May 2004
Business objects Supervisor-Developer
Project is developed for the British Petroleum. The project involves the Design, development and maintenance of Business Objects universes and Reports.
• Implemented the Software development life cycle methodology for creating reports
• Prepared and maintained documentation for understanding universes and reports
• Designed, built, and maintained Business Objects universes for different business groups and also created complex reports
• Authorized the user access to one or more universes
• Created restrictions on objects and classes based on universes privileges
• Used ER Studio to create ER diagrams for information flow analysis
• Developed various metadata and operational definitions. Also enhanced existing reports using sub-queries
• Constantly checked on data load into Business Objects repository working with the ETL team that used SQL loader
• Created User groups, Users, Database connections, Managed user privileges, Import/export of universes in production environment
• Used Broadcast agent for scheduled, batch processing of Business objects and Web intelligence documents
• Created detail and summary reports, used to fold/unfold sections corresponding to breaks in current blocks
• Created prompts in report to restrict data fetch and ease data load
• Scheduled daily/monthly reports and performed report bursting using Broadcast Agent Server
Environment: Business objects 5.1.3, Business Objects Web I, Broadcast agent Server, Oracle8i, SQL Server 7.0/2000, Windows NT.
ZALES, Dallas, Texas Jan 2003- Sep 2003
Business Objects Developer
Project is developed for sales and marketing department of Zales. Data from the data warehouse is used to design and develop reports using Business Objects 5.1.7, Broadcast agent server, Business Objects Web I.
• Involved in the Requirements gathering, Development, UAT, and Production support phases of Business Objects Report development
• Installed the Business Objects version 5.1.7
• Created user groups and managed access privileges using Business Objects Supervisor
• Responsible for Business Objects repository, performed tuning using Toad
• Performed release management of Business Objects reports using Broadcast Agent Server
• Extensively used Designer to design various universes for different business groups
• Designed, built, maintained Business Objects universes and repository
• Extensively used Web Intelligence Info view for exploring querying, reporting and analysis tasks
• Used Broadcast agent for scheduled, batch processing of Business objects and Web intelligence documents.
• Authorized user access to one or more universes, created restrictions on objects and classes based on universe privileges
• Developed various metadata and operational definitions
• Customized Business Objects web interface (intranet) to access the enterprise reports developed in Business Objects full client
• Troubleshoot the problems and customized the reports according to the specifications of the analysts
Environment: Business Objects 5.1.7, Broadcast agent server, Business Objects Web I, Informatica Power Center 5.0, Crystal reports 7.0, Visual Basic 6.0, Oracle 8i, Sybase, Windows NT.
Al Wafaq Training Center, UAE Apr 2000- Dec 2002
Database Developer
Al Wafaq provides training in consulting services in databases, web development and database warehousing.
• Trained IT team in Business Objects 4i.
• Worked extensively in creation of Oracle complex SQL.
• Partly involved in the logical and physical database design
• Created a webpage for the internal users of Al Wafaq to provide user guides coding in JAVA and HTML /XHTML
• Worked with the DBA to support and maintain Oracle cursors, functions, triggers and procedures, packages etc.
• Involved in performance tuning of SQL queries
Environment: Business Objects 4i, Oracle 8i, MS Access, Windows 2000/NT
Certifications
NA
Resume 2:
Professional Summery:
• 6 years of IT experience including 4 years in Business Objects.
• Well versed in Business Objects (XI, 6x and backwards) 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, Auditor and Schema Design.
• Good knowledge in Business Objects XI/XI R2 version.
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
• Worked on Web Intelligence to develop and publish thin client reports
• Created Dashboards using Application Foundation.
• Good knowledge and experience in using Oracle 9i/8i, MS SQL Server 2000, Enterprise manager, Query analyzer.
• Experience in developing SQL, PL/SQL procedures, database triggers and other components of database applications.
• Knowledge in building, extraction, transformation and loading (ETL).
• Experience in installation, administration and upgrading versions of BO both desktop and server products on both Windows and UNIX environments.
• Exposed to Data Warehouse assignments in various domains like Mortgage, Medical services, Sales, Insurance, Financial & Bank, Inventory Distribution, and Production Data warehouses.
• Excellent interpersonal, communication and presentation skills.
Professional Experience
Burger King, Miami, FL Feb'06- Till date
Business Objects Developer
• Interacted with Business Owners to know their Business views in modifying Reports accordingly.
• Initiated DBA interactions for resource requirements and modifications.
• Analyzed which universes and reports have to be modified.
• Detected cardinalities, loops, and checked the Integrity of Universes.
• Modified the existing Universes by merging different Classes and resolving the Loops and Chasm Traps by context.
• Changed List of Values (LOV) in the universe prompts.
• Modified the existing reports according to the new global alignment in the universe.
• Modified reports using the various data Providers like Free Hand SQL, Stored Procedures.
• Good knowledge in Business Objects XI/XI R2 version
• Imported Business Objects Universes, Users and user groups, and reports from Version 6x to Version XI R2 using the Import Wizard.
Environment: Business Objects 6.5.1 / XI R2, WebI 6.5, Designer, Supervisor, Broadcast Agent,
ZABO, Info view, SQL, PL/SQL, SQL Server 2000, Oracle 9i and Windows NT
Washington Mutual, Seattle, WA April'05 -- Jan'06
Business Objects Developer/Designer
• Interacted with Business Users and Business Owners to know their Business views 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
• Design and Development of Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users
• Upgraded Business Objects universes and reports from version 5.1.7 to version 6.5.1.
• Involved in the designing and Building of Universes, Classes and objects
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Worked on the Master, Kernel and Component approach during the linking of universes.
• Created and tested classes and objects to organize the universe.
• Exported the universes to the Repository to make resources available to the users
• Created reports for various Portfolios using the various data Providers like Free Hand SQL, Stored Procedures, VB procedures.
• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc
• Created reports using Info View and ZABO for distribution to users
• Created Schedulers to monitor Broadcast Agent
• Built full client and WEBI reports.
• Set up groups and users for Business Objects deployment. Managed user profiles using Supervisor
• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects 6.0 connected to Oracle 9i data source
• Created Business Objects Repository while building Business Objects solution.
• Published and scheduled Business Objects Reports to users using Scheduler
• Created and Developed Stored Procedures, Packages.
• Created and customized application dashboards using Application Foundation to meet the requirements of higher level analysis.
• Developed dashboards and scoreboards for detailed analysis.
Environment: Business Objects 6.5.1/XI, WebI 6.5, Designer, Supervisor, Broadcast Agent,
ZABO, Info view, SQL, PL/SQL, Application Foundation, Oracle 9i and
Windows NT.
Fidelity Investments, Boston, MA Sep'04 - March'05
Business Objects Developer/Analyst
• Generated reports using Business Objects 5.1 and Crystal Reports 8.0
• Used Business Objects Developer Suite (Broadcast Agent, Supervisor, Designer, Info View), BO Query Designer and Report Designer
• Involved in designing Business Objects Universes, Queries, and Reports
• Wrote ad hoc queries and web reports using Business Objects Suite
• Designed and managed groups and users using Supervisor module and assigned them universes and documents specific to their domains
• Created reports using queries, slice and dice, drill down, @functions, cross tab, master detail, formulas
• Created Complex reports using functions, hierarchies, rank and sorting
• Designed and maintained Complex Universes, resolved loops by creating aliases and contexts
• Used Broadcast Agent to schedule the reports depending on the user profile.
• Good experience in creating customized Dashboards for overall performance.
• Developed Dashboards for detailed analysis
• Data modeling and design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology with confirmed and granular dimensions and FACT tables
Environment: Business Objects Suite, WebI, Crystal Reports, Application Foundation, SQL, and
MS SQL Server 2000 and Windows Platform.
GE Medical Systems, Milwaukee, WI Feb' 03 - Aug '04
Clinical Services Information Systems
Business Objects Developer/Administrator
• Created several Classes, Objects, Conditions, and Measure objects.
• Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc. Developed hierarchies to support drill down reports.
• Scheduled and monitored reports at the server level using Broadcast Agent (BCA).
• Involved in the designing and building of the Universes, Classes and objects for the client requirements.
• Created queries to extract data from an Oracle database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
• Created various standard reports and queries based on the existing classes/objects.
• Exported reports to Excel based on the user requirements.
• Manage Production, Test and Dev environments including installation of patches, security administration and access controls.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions
• Exported Reports to the Broadcast Agent (BCA) Server, and used the BCA to schedule and monitor the Reports and customized the Web Intelligent front-end
• Educated end-users and provided technical support.
Environment: Business Objects 5.x, Web Intelligence, Oracle 8.x, Win2000.
Allstate Insurance Company, Northbrook, IL Mar'02 - Jan'03
Business Objects Designer
• Interacted with Business Users and Business Analysts to gather Information to enhance the Universe.
• Analyzed Existing Universe and Database to enhance the existing Universe and Create new Universe
• Imported existing Universe to modify
• Resolved Loops in Universe by creating Aliases and Contexts.
• Checked Universe for integrity and exported to repository to make it available for user groups
• Created Reports from Multiple data sources from database and Personal files
• Created Master/Detail Cross-Tab and summarized reports to view the data in an analyzed way.
• Formatted the Reports to meet the user requirements using Multi-Dimensional Analysis like Slice and Dice, Drill Down.
• Created Alerts and Implemented Ranking in the reports.
• Worked on Web Intelligence to develop and publish thin client reports
Environment: Business Objects 5.x, Web Intelligence, Info view, Designer, Supervisor,
Broadcast Agent, Oracle 8.x, PL/SQL, Win 2000.
Soul Software Pvt Ltd, India Dec'99 - Jan'02
Programmer/Analyst
• Involved in design, development, and implementation of the application.
• Involved in the creation of GUI for Account Information System.
• Created database tables.
• Connection to database.
• Good knowledge in using Normalization techniques.
• Also involved in Testing Phase of the Application.
Environment: C, Oracle, SQL, PL/SQL, UNIX, and Windows 98.
Education: Bachelor of Engineering in Mechanical Engineering
Certifications
Bachelor of Engineering in Mechanical Engineering
Business Intelligence Tools
BO 5.x,6.x
BO XIR1/R2
Reporter
Developer
Designer
Internet Technologies
Webi
CMC
Infoview
Reporting Tools
Business Objects Reporter
Broadcast Agent Publisher
Info View
Web Intelligence
Web Tools
HTML
Java Script
Data Base
Oracle
MS Access
98/2000
DB2
SQL Server
Languages
Java
C
C++
Oracle
SQL *PLUS
Operating System
Windows 9I/XP/2000
Windows NT
Functionalities
Row-level security
Objects-level security
Master/Detail
Slice and Dice
Drill up/down
Conditions
Filters
Charts
Alerters
LOV
Context
Aliases
Universes
Reports
@Functions
Formulas
Scheduling
Cross tab
UDO
Joins
Resume 3:
OBJECTIVE:
A position as a Business Objects designer or as a developer to use my skills and experience in Business Objects Xi2, Designer module, Reporter module, Web Intelligence 6.5, Broadcast Agent and Business Objects XI,
MS SQL server 2000 and Data-warehousing Technologies.
EXPERIENCE SUMMARY:
Self-motivated and result-oriented professional with five years of extensive experience in IT including 4 years in Business objects.
Extensively worked and used Business Objects 6x/XIR2 - Business Objects Designer, Reporting and Web Intelligence.
Good knowledge a Data-warehouse Environment, decision support, RDBMS, Client/Server.
Expertise in retrieving data using Business Objects Universes, personal data files, like EXCEL, PDF.
Proficient in creating reports using Business Objects XI R2 functionalities such as Queries, Master/Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts.
Proficient in designing and building universes by selecting and joining tables, setting cardinalities and resolving loops by using aliases and contexts.
Worked on Web Intelligence to develop and publish thin client reports.
Experience in installation, migration and upgrading versions of BO both desktop and server products on Windows environment.
Experience in handling complex problems and finding right solutions in time.
Excellent interpersonal, communication and presentation skills.
WORK EXPERIENCE:
Company: Comprobase Inc, VA
Position: Business Objects Developer
Duration: Since September 2006
Environment: Business Objects 6x/XIR2, Web Intelligence, Deski, BO Designer, Oracle, Windows XP.
Responsibilities:
Meeting with department chairs to determine requirements, specifications, and analysis. Working closely with functional system users to document business processes and define system functionality.
Responsible for designing the Universe, created Contexts and Aliases for resolving Loops in the Universes to improve performance.
Linking the Universes to share common objects. Updating and maintaining Universes based on changing user requirements and data source changes.
Extensively used filters, conditions, list of values (LOV), calculations, etc.
Creating different types of reports such as Master/Detail, Cross Tab and Charts.
Creating complex joins like outer joins, equi-join and theta joins and checked the integrity of the Universes.
Applying slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis.
Applied graphical representation of reports such as Bar Charts, Pie Charts as per the end user requirements.
Responsible for designing, building, testing, Universes and Reports through Business Objects XIR2.
Worked on planning future migration to Business Objects XI from 6.x.
Excellent written and oral communication skills to make technical or non-technical material understandable to the users.
Company: GE Medical Systems, Milwaukee,WI
Clinical Services Information Systems
Position: Business Objects Developer
Duration: Aug ‘05 - July '06
Environment: Business Objects XIR2, Web Intelligence, Info view, Designer, Broadcast Agent, Oracle, Windows.
Responsibilities:
Created several Classes, Objects, Conditions, and Measure objects.
Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc.
Developed hierarchies to support drill down reports.
Scheduled and monitored reports at the server level using Broadcast Agent (BCA).
Involved in the designing and building of the Universes, Classes and objects for the client requirements.
Created queries to extract data from an Oracle database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
Created various standard reports and queries based on the existing classes/objects.
Exported reports to Excel based on the user requirements.
Supervise the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions.
Exported Reports to the Broadcast Agent (BCA) Server, and used the BCA to schedule and monitor the Reports and customized the Web Intelligent front-end.
Educated end-users and provided technical support.
Company: Orbitz, Chicago
Position: Business Objects Developer
Duration: Nov’ 04 – June’05
Environment: Business Objects 6.5/5, Web Intelligence, Info view, Oracle, and Windows2000/XP.
Responsibilities-
Responsible for the Designing the universes by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.
Created different types of reports like Master/Detail, Cross Tab and Chart.
Wide usage of Drill mode and Slice and Dice techniques to modify the reports in accordance with the user’s analysis needs.
Managing security by Adding, Enabling, Disabling and Deleting of User/Groups and granting of privileges using Supervisor.
Administering Repositories, Universes, Catalogs, User-control, Categories & Folders.
Used Business Query to load data directly to Excel and also involved in formatting.
Used Broad Cast Agent to schedule reports.
Imposed several Joins, Filters, and Alerters to restrict the unwanted data and highlight the required data.
Resolved loops with Aliases and Contexts.
Involved in migrating the reports from Business Objects 5.x to 6.5.
Provided training to end users to use various functionalities of Business Objects
Good knowledge on Migration of business objects universes and Reports using import wizard and report conversation tool.
Exported the Business objects Reports to be webi so that all users can view on the intranet
Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
Company: Bank One, Chicago.
Position: Business Objects Developer
Duration: May’03 – Oct’04
Environment: Business Objects 5/6, Web Intelligence, Info view, Oracle, and Windows 2000/XP.
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 Reports accordingly
Involved in designing and building Universes, Classes and objects and defining the necessary connections
Involved in generating reports and resolving issues like, drill through two levels & Pivoted the data.
Reviewed all reports that are operating in the production environment with a goal of improving their efficiency
Exported the universes to the Repository in order to make the resources available to the users.
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.
Company: American Modern Insurance Group, OH.
Position: Business Objects Developer
Duration: Nov’ 02 - Apr ‘03
Environment: Business Objects 5x, Oracle, Manual Testing, Windows.
Responsibilities:
Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
Designing new Universes and Modifying the existing Universes, using features like Check Integrity, Aliases, Loops, Contexts, Joins and finally creating the Objects (Dimensions, Measures and Details), which are grouped into Classes.
Upgrading and Maintaining Universes and Reports using Business Objects Best Practices in multiple Environments.
Creating and Formatting the Reports as per the Users Requirements using the features in Business Objects like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and Formulae to analyze the data.
Creating and distributing Report Templates to Users. Web-Enabling the Reports using web intelligence.
Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End User Notes.
Installing the Business Objects and Creating Repository (Security, Universe and Document Domains).
Managing security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using Supervisor.
Generated Test data for identifying valid data, Invalid data, Partial data &Bad data.
Company: ECIL (Electronics co-operation of India Limited)
Duration: Jan’02 – Sep’02
Environment: Simulink, Java, Windows
Responsibilities:
Monitoring and controlling a complete site of a system.
Working with DCS (Distributed control system).with single supplier.
Controlling the site with Programmer Logical Controllers.
Monitor SCADA system performance.
Evaluate, Test and Apply application soft ware updates.
EDUCATION:
Masters in Computer Science from University Of Northern Virginia, VA.
Bachelor of technology, INDIA
Resume 4:
Professional Summary
Five (5+) years of Business Intelligence Systems experience in full life cycle development (gathering requirements, documentation, developing and designing BusinessObjects 6x and XI environments, database design, developing Web Intelligence reports, processing and analyzing data in MS Access, SQL Server 2000, Oracle 9i.
Expert in working with BusinessObjects Reporter, Designer and creating Dashboard Manager using Application Foundation and Web Intelligence.
Experienced with configuring Web Intelligence server and BusinessObjects administration.
Strong background in systems/business analysis for the purpose of gathering, documenting and implementing reporting requirements.
Superior analytical and writing skills, coupled with good communication skills.
Technical Summary
Professional Experience
Yahoo-Inc 01/07 – 04/07
BusinessObjects Dashboard Developer/Reporter - Consultant
Installed BusinessObjects XIR2, successfully installed and ran Publishing Wizard, and Import Wizard.
Restricted different users depending upon the hierarchy.
Created several Corporate Dashboards and Personal Dashboards (making use of certain predefined analytics, user defined analytics).
Created rules, events, Web Intelligence reports making use of several Queries (union, minus).
Developed several complex reports depending up on the metrics and customized several reports into excel, pdf, .csv.
Generated several Templates in Webi / Deski.
Created 500 users with different access rights.
Scheduled the reports on daily wise, monthly wise, weekly.
Used Master/ detail, Filters and Prompt in-order to generate the reports as per the End user requirements.
Used Schedule Manager, Instance manager, and Query builder.
Created several Repositories.
Generated dashboards in such a way user can be able to see the deviation, metric trees, embedded videos in dashboards, linking pages and creating navigation packages.
Environment: BusinessObjects XIR2, Web Intelligence, InfoView, Designer, Schedule Manager, Java SDK, Oracle, SQL Server, PL/SQL, Performance Manager, Dashboard Builder, CMC, Import Wizard, Publishing Wizard, Repository Migration Wizard.
Federal Trade Commission (FTC) 12/06 – 01/07
BusinessObjects Developer / Reporter - Consultant
Met with department chairs to determine requirements, specifications, and performed analysis. Worked closely with functional system users to document business processes and define system functionality.
Responsibilities included designing, building, testing, and deploying Dashboards, Universes and Reports through BusinessObjects 6x.
Worked with Data Warehouse, querying relational and multi-dimensional database structures using SQL and BusinessObjects Reporter.
Configured the Web Intelligence server.
Played a lead role on planning the future migration to BusinessObjects XI.
Designed the Universe, created Contexts and Aliases for resolving Loops in the Universes to improve performance.
Used filters, conditions, list of values (LOV), and calculations.
Linked the Universes to share common objects. Updated and maintained Universes based on changing user requirements and data source changes.
Created different types of reports such as Master/Detail, Cross Tab and Charts.
Created complex joins like outer joins, equi-join and theta joins and checked the integrity of the Universes.
Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis.
Created report development using Crystal Reports.
Created cross-tab, conditional, drill-down, Charts and sub reports using Crystal Reports.
Excellent written and oral communication skills to make technical or non-technical material understandable to the users.
Environment: BusinessObjects RiX2, Web Intelligence, PL/SQL, InfoView, Designer, Broadcast Agent, Migration Wizard, Java, Oracle 10g, Performance Manager.
Global Software Technologies (GST) - VA 03/06 – 11/06
Trainer for BusinessObjects 6.5/XIR2 Classes
As the BusinessObjects subject matter expert, trained the internal GST technical staff in the following areas:
Overview and in-depth “how to” working with BusinessObjects 6.5/XIR2: Reporter (Reports), Designer (Universe), Migration Wizard, WebIntelligence, InfoView, Dashboard, BCA and Administration.
GE Medical Systems 08/05 – 01/06
BusinessObjects Developer/Administrator - Consultant
Created several Classes, Objects, Conditions, and Measure objects.
Created reports using BusinessObjects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc. Developed hierarchies to support drill down reports.
Scheduled and monitored reports at the server level using Broadcast Agent (BCA).
Involved in the designing and building of the Universes, Classes and objects for the client requirements.
Created queries to extract data from an Oracle database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
Created various standard reports and queries based on the existing classes/objects.
Exported reports to Excel based on the user requirements.
Managed Production, Test and Dev environments including installation of patches, security administration and access controls.
Administered and supervised the BusinessObjects environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions.
Exported Reports to the Broadcast Agent (BCA) Server, and used the BCA to schedule and monitor the Reports and customized the Web Intelligent front-end.
Educated end-users and provided technical support.
Environment: BusinessObjects RiX2/X1, Web Intelligence, InfoView, Designer, Migration Wizard, Broadcast Agent, Java, Oracle 8.x, PL/SQL.
Allstate Insurance Company 04/04 – 06/05
BusinessObjects Designer - Consultant
Interacted with Business Users and Business Analysts to gather Information to enhance the Universe.
Analyzed existing Universe and Database to enhance the existing Universe and create new Universe.
Imported existing Universe to modify.
Resolved Loops in Universe by creating Aliases and Contexts.
Checked Universe for integrity and exported to repository to make it available for user groups.
Created Reports from Multiple data sources from database and Personal files.
Formatted the Reports to meet the user requirements using Multi-Dimensional Analysis like Slice and Dice, Drill Down.
Created Alerts and Implemented Ranking in the reports.
Worked on Web Intelligence to develop and publish thin client reports.
Environment: BusinessObjects 6x/XI, Web Intelligence, InfoView, Designer, Supervisor, Broadcast Agent, Oracle 8.x, PL/SQL.
Data Warehouse Programmer / Analyst – Consultant 05/03 – 02/04
Responsibilities included data mart/warehouse analysis, design, and implementation, including business and warehouse requirements.
Worked with multiple data providers and linked these data providers based on the requirements.
Worked on the migration of Web Intelligence documents and published them to the repository in their respective groups and categories.
Created complex reports using Reporter module in Desktop/Web Intelligence functionalities like Slice and Dice, Drill Down, @Functions, Cross Tabs, Master/Detail, and Formulas.
Created templates for standardizing the structure of corporate documents.
Tested reports for accuracy, and troubleshoot report issues including poor performance and bad data.
Analyzed report requirements and developed critical corporate reports based on the Web Intelligence functionality.
Created complex reports using user defined functions, condition objects and used aggregate awareness, short-cut join functions for Query performance enhancement.
Optimized performance and monitored entire BusinessObjects, Web Intelligence reporting system.
Led various data analysis, integration, and testing efforts and ensured compliance with overall enterprise data strategy and standards.
Supported the development of data warehouse metadata repository, and led the prototyping efforts.
Responsible for Web Intelligence server performance tuning, BusinessObjects SDK, and BCA (Broadcast Agent) administration.
Environment: Oracle8i / BusinessObjects 5.0, Web Intelligence, PL/SQL, Windows NT, HTML, Java.
GigaSoft 12/02 – 01/03
BusinessObjects Designer - Consultant
Administered the BusinessObjects systems infrastructure, including installs, upgrades, and troubleshooting, publishing reports using BCA.
Designed and developed Data Models within a data warehouse environment.
Participated in data analysis, primarily using SQL Server and other standard RDBMS tools.
Reviewed all reports that are operating in the production environment with a goal of improving their efficiency.
Developed multi agency reports, using complex logic, to extract information from the data warehouse in a format acceptable to the end users
Supported internal users with BusinessObjects Reports & Web Intelligence portal issues.
Environment: BusinessObjects 6i/5i, Designer, Broadcast Agent, BusinessObjects Supervisor, BusinessObjects Designer, Oracle 8i/9.i, Windows 2000
Maram Software Solutions 02/01 – 10/02
Java Programmer
Project: Online books inquiry system
An Intranet system is designed to give online help to the customers of a library.
Developed excellent search capabilities.
Performed system testing of java modules and components.
Documented java modules and components.
Created, troubleshot and updated code files.
Implemented and tested the system
Environment: J2EE, Oracle, JavaScript, HTML. JSP, Java, PL/SQL.
Project: e-Banking System
Programmer Analyst
Developed online Banking application using Java, J2EE and Oracle 8i.
The main aim of the project is to design and implement a user interface of an e-banking client.
Environment: Java (JSP), Oracle, HTML, J2EE, Tomcat 5.0
Education
Masters in Computer Science
University of Northern Virginia
Certifications
Certified C/C++ programmer from Brain Bench
Brain Bench Certified computer fundamentals with Win XP
Brain Bench Certified in JAVA2 fundamentals
Resume 5:
OBJECTIVE
A position as a Business Objects designer or as a developer to use my skills and experience in Business Objects Xi2, Designer module, Reporter module, Web Intelligence 6.5, Broadcast Agent, Publisher and Business Objects XI, MS SQL server 2000, Oracle9i, and Data-warehouse technologies.
SUMMARY OF EXPERIENCE
5+ years experience in full life cycle development (gathering requirements, documentation, developing and designing Business Objects environments, database design, developing web intelligence reports, processing and analyzing data in MS Access, MS SQL server 2000, Oracle 9i.
Proficient in setting up Repository, creating and managing users and user groups and manage security.
Experience in Data warehousing environment, decision Support, RDBMS, Client\Server and Multi-dimensional database technology.
Expert in programming in free hand SQL, Visual Basic, HTML, XML, JSP for document generation.
Expert in working with Business Objects Reporter and creating Dashboard Manager using Application Foundation and web intelligence.
Strong background in systems/business analysis for the purpose of gathering, documenting and implementing reporting requirements.
Superior analytical and writing skills, coupled with good business and financial acumen.
Good Knowledge in Security Viewer, Import Wizard, Publishing Wizard, Query Builder, Instance manager.
Good follow up on the updates on technologies
TECHNICAL SKILLS
Reporting Tools: Business Objects Reporter XiR2, Designer, Broadcast Agent, SchedulerXIR2, CMC, Import Wizard, Publishing Wizard, Migration Wizard, Web Intelligence, Info View, Query Builder, Instance Manager, Administrator Console.
Languages: Sql*Plus, C, C++, Java, JSP, XML.
RDBMS: Oracle 8.0/8i, 9i, DB2, MS SQL Server 2000
Internet Technologies: Web Intelligence, CMC, INFOVIEW
Operating systems: WINDOWS 9i/XP/NT
WORK EXPERIENCE
Company: Global Software Technologies, VA.
Position: Developer/Designer
Duration: Since April 2003
Environment: Business Objects XI/6i/5i, Web Intelligence 6x, Broad Cast Agent, Business
Objects Supervisor, BO Designer, Oracle 8i/9i, Windows XP/NT/9i.
Project-5
Yahoo-Inc, CA, Jan’07 – till date.
Business Object Dashboard developer /Reporter.
Responsibilities:
Installed Business Objects XIR2, Successfully installed and run Publishing Wizard, Import Wizard.
Restricted different users depending upon the hierarchy.
Created several Corporate Dashboards and Personal Dashboards ( making use of certain predefined analytics, user defined analytics).
Created rules , events, Webi reports making use of several Queries(union, minus).
Developed several Complex reports depending up on the metrics and customized several reports into excel, pdf, .csv.
Generated several Templates in Webi / Deski.
Created 500 users and gave them different access rights.
Good experience in CMC.
Scheduling the reports on daily wise, monthly wise, weekly.
Extensively used Master/ detail , Filters and Prompt in-order to generate the reports as per the End user requirements.
Made use of Schedule Manager, Instance manager, Query builder.
Created several Repositories.
Generated dashboards in such a way user can be able to see the deviation, metric trees, embedded videos in dashboards, linking pages and creating navigation packages.
Environment: Business Objects RiX2, Web Intelligence, Infoview, Designer, Schedule Manager, Java SDK, Oracle, Performance Manager, Dashboard Builder, CMC, Import Wizard, Publishing Wizard, Repository Migration Wizard.
Project-4
FTC, Washington, D.C. oct'06 – Jan’07.
Business Objects Developer/Reporter.
Responsibilities:
Meeting with department chairs to determine requirements, specifications, and analysis. Work closely with functional system users to document business processes and define system functionality.
Responsible for designing, building, testing, and deploying Dashboards, Universes and Reports through Business Objects 6x.
Working with Data Warehouse, querying relational and multi-dimensional database structures using SQL and Business Objects Reporter.
Designing the Universe, created Contexts and Aliases for resolving Loops in the Universes to improve performance.
Extensively used filters, conditions, list of values (LOV), calculations, etc.
Linking the Universes to share common objects. Updating and maintaining Universes based on changing user requirements and data source changes.
Creating different types of reports such as Master/Detail, Cross Tab and Charts.
Creating complex joins like outer joins, equi-join and theta joins and checked the integrity of the Universes.
Applying slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis.
Creating report development using Crystal Reports.
Creating cross-tab, conditional, drill-down, Charts and sub reports using Crystal Reports.
Lead role on planning future migration to Business Objects XI.
Excellent written and oral communication skills to make technical or non-technical material understandable to the users.
Environment: Business Objects RiX2, Web Intelligence, PL/SQL, Info view, Designer,
Broadcast Agent, Java, Oracle 10g, Performance Manager.
GST, Vienna, VA , Mar ’06 - Sep ’06.
Trainee For Business Objects 6.5/XIR2.
Responsibilities:
Working with Documents
Report Structures
Drilling into Reports
Business Objects Universes
Business Objects Universe Contexts
Building a New Document (New Report Wizard)
Building a New Document (Query Panel)
Query Panel Data Types
Data Sets in Documents
Data Providers are Collections of Data Objects
Object Behavior
Inserting Multiple Data Providers
Inserting an Additional Data Provider
Re-Qualifying Data Objects
Un-Linked Data Providers
Linking Multiple Data Providers
Linking Multiple Data Providers
Talking Points
Talking Points
Null Values in Linked Data Providers
Erroneous Results from Multiple Data Providers
Data and Report Contexts
Contexts in Reports
Contexts in Data
Context Operators
The In Operator
In Operator Overrides Existing Report Contexts
In Operator Context Definitions
In Block Example
The Where Operator
Rest of World Example
Where Operator Restrictions
Prompted Rest of World Example
Formulas, Variables And Various Functions
Worked on how to create Dashboards and Concepts of analysis and created several scenarios and also trained people how to overcome certain errors, during creating dashboards and report generation.
How to schedule the reports using BCA, using Info-view, how to increase the performance.
Trained people how to customize the Info-view, CMC.
Project-3
GE Medical Systems, Milwaukee, WI Aug ‘05 - Jan '06
Clinical Services Information Systems
Business Objects Developer/Administrator
Responsibilities:
Created several Classes, Objects, Conditions, and Measure objects.
Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc. Developed hierarchies to support drill down reports.
Scheduled and monitored reports at the server level using Broadcast Agent (BCA).
Involved in the designing and building of the Universes, Classes and objects for the client requirements.
Created queries to extract data from an Oracle database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
Created various standard reports and queries based on the existing classes/objects.
Exported reports to Excel based on the user requirements.
Manage Production, Test and Dev environments including installation of patches, security administration and access controls.
Administer and supervise the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions.
Exported Reports to the Broadcast Agent (BCA) Server, and used the BCA to schedule and monitor the Reports and customized the Web Intelligent front-end.
Educated end-users and provided technical support.
Environment: Business Objects RiX2/X1, Web Intelligence, Info view, Designer,
Broadcast Agent, Java, Oracle 8.x, PL/SQL.
Project-2
Allstate Insurance Company, Northbrook, IL Apr'04 - June'05
Business Objects Designer
Responsibilities:
Interacted with Business Users and Business Analysts to gather Information to enhance the Universe.
Analyzed Existing Universe and Database to enhance the existing Universe and Create new Universe.
Imported existing Universe to modify.
Resolved Loops in Universe by creating Aliases and Contexts.
Checked Universe for integrity and exported to repository to make it available for user groups.
Created Reports from Multiple data sources from database and Personal files.
Formatted the Reports to meet the user requirements using Multi-Dimensional Analysis like Slice and Dice, Drill Down.
Created Alerts and Implemented Ranking in the reports.
Worked on Web Intelligence to develop and publish thin client reports
Environment: Business Objects 6x/Xi, Web Intelligence, Info view, Designer, Supervisor,
Broadcast Agent, Oracle 8.x, PL/SQL.
Project-1
Consultant • Programmer / Analyst May 2003 - Feb 2004.
Description:
The Health Plan Control system is custom specific software designed to plan and monitor “Plan Coverage” for Geographical Regions. HPC maintains coverage specifications, bill of services and user requirement data for online processing of Plan Registration and Acceptance notices. The applications capabilities to customize Plan modification criteria made the system a powerful and generic tool for data maintenance and tuning operations. On-demand and automated report generation was possible to notify non-conforming products.
Responsibilities:
Responsible for data mart/warehouse analysis, design, and implementation, including business and warehouse requirements.
Extensively worked with multiple data providers and linking these data providers based on the requirements.
Worked on the migration of WebI documents and published them to the repository in their respective groups and categories.
Created complex reports using Reporter module in Desktop/Web Intelligence functionalities like Slice and Dice, Drill Down, @Functions, Cross Tabs, Master/Detail, and Formulas.
Created templates for standardizing the structure of corporate documents.
Tested reports for accuracy, and troubleshoot report issues including poor performance and bad data.
Analyzed report requirements and developed critical corporate reports based on the Web intelligence functionality.
Created complex reports using user defined functions, condition objects and used aggregate awareness, short-cut join functions for Query performance enhancement.
Performance optimization and monitoring of entire business objects, Web intelligence reporting system.
Lead various data analysis, integration, and testing efforts and ensured compliance with overall enterprise data strategy and standards.
Supported the development of data warehouse metadata repository, leading prototyping efforts.
Responsible for Web Intelligence server performance tuning, Business Objects SDK, and BCA (Broadcast Agent) administration.
Environment: Oracle8i / Business Objects 5.0, Web Intelligence, PL/SQL, Windows NT, HTML, Java.
Company: GigaSoft, Washington, DC.
Position: Business Objects Designer
Duration: Dec’ 2002 - Jan’ 2003
Responsibilities:
Administered the BO systems infrastructure, including installs, upgrades, and troubleshooting, publishing reports using BCA.
Designed and developed Data Models within a data warehouse environment.
Participated in data analysis, primarily using SQL Server and other standard RDBMS tools.
Reviewed all reports that are operating in the production environment with a goal of improving their efficiency.
Developed multi agency reports, using complex logic, to extract information from the data warehouse in a format acceptable to the end users
Supported internal users with Business Objects Reports & Web Intelligence portal issues.
Environment: Business Objects 6i/5i, Designer, Broad Cast Agent, Business Objects Supervisor, Business Objects Designer, Oracle 8i/9.i, Windows 2000
Company: Maram Software Solutions, Hyderabad, India
Position: Java Programmer
Duration: Feb 2001- Oct 2002.
Environment: J2SE, Oracle, JavaScript, Html.
Description:
MaramSoft provides the planning and implementation IT-enabled processes needed to support business. By focusing intensely on analysis of the IT sourcing needs, an enterprise can ensure that it has access to necessary resources- and even find a way to survive in the marketplace.
Project-2
Online books enquiry Package
Responsibilities:
An Intranet system is designed to give online help to the customers of a library.
Developed excellent search capabilities.
System testing java modules and components.
Documentation of java modules and components,
Creating code files,
Troubleshooting code files,
Updating code files
Implemented and tested the system
Environment: JSP, Java, Java Script, PL/SQL.
Project-1
e-Banking, CMC Ltd.
Responsibilities:
Technologies used are Java, J2EE-including transactions and security, Oracle 8i.The main aim of the project is to design and implement a user interface of an e-banking client, the design could cover day to day operations such as, bundling of a set of payments, or one-time tasks such as, installation of a digital signature-based client. The design is made in such a way to clarify & reduce the number of codes, passwords, etc... That the user is required to remember, Provide good explanation of the security concepts that the user is required to understand, for e.g. “signature file”. These improvements should not weaken security, and the project should not weaken security, and the project should provide some analysis of this. Java applet program design is used to implement a secure e-banking client, for security reasons we made use of various libraries that are provided by java, the browser for the purpose of Security, Authentication and Confidentiality.
Environment: Java (JSP), Oracle, Html, J2EE, Tomcat 5.0
EDUCATION
Masters in Computer Science,
Specializing in: Computer Science
AWARDS AND HONORS
Certified C/C++ programmer from Brain Bench
Resume 6:
EXPERIENCE SUMMARY:
Self-motivated and result-oriented professional with five years of extensive experience in IT including 4 years in Business objects.
Extensively worked and used Business Objects 6x/XIR2 - Business Objects Designer, Reporting and Web Intelligence.
Good knowledge in Business Objects XIR2/6.x.
Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
Proficient in creating reports using Business Objects XI R2 functionalities such as Queries, Master/Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts.
Proficient in designing and building universes by selecting and joining tables, setting cardinalities and resolving loops by using aliases and contexts.
Worked on Web Intelligence to develop and publish thin client reports.
Experience in installation, migration and upgrading versions of BO both desktop and server products on Windows environment.
Created simple cooperate dashboard by making use predefine analytics.
Good knowledge in performance manager, dashboard builder.
Created several metrics and schedule dashboards on weekly bases
Good knowledge about migration i.e. software migration / resource migration / import wizard / report conversation tool
Experience in handling complex problems and finding right solutions in time.
Good interpersonal, communication and presentation skills.
TECHNICAL SKILLS:
Reporting: Business Objects Reporter 5/6x/XIR2, Designer, Broadcast Agent publisher.
Internet Technologies: Web Intelligence, INFOVIEW, CMC.
Operating systems: WINDOWS XP/2000/9i/NT.
Languages: C, C++, Java.
RDBMS: ORACLE, MS SQL Server 2000.
WORK EXPERIENCE:
PROJECT- 5:
GST Inc, VA Sep ‘2006 - Till date
Position: Business Objects Designer /Developer
Responsibilities:
Meeting with department chairs to determine requirements, specifications, and analysis. Working closely with functional system users to document business processes and define system functionality.
Responsible for designing the Universe, created Contexts and Aliases for resolving Loops in the Universes to improve performance.
Linking the Universes to share common objects. Updating and maintaining Universes based on changing user requirements and data source changes.
Extensively used filters, conditions, list of values (LOV), calculations, etc.
Creating different types of reports such as Master/Detail, Cross Tab and Charts.
Creating complex joins like outer joins, equi-join and theta joins and checked the integrity of the Universes.
Applying slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis.
Applied graphical representation of reports such as Bar Charts, Pie Charts as per the end user requirements.
Responsible for designing, building, testing, Universes and Reports through Business Objects XIR2.
Worked on planning future migration to Business Objects XI from 6.5 x.
Excellent written and oral communication skills to make technical or non-technical material understandable to the users.
Environment:
Business Objects 6x/XIR2, Web Intelligence, Deski,BO Designer, Oracle Windows XP.
Project-4:
GE Medical Systems, Milwaukee, WI Aug ‘05 - July '06
Clinical Services Information Systems
Business Objects Reporter/Developer
Responsibilities:
Created several Classes, Objects, Conditions, and Measure objects.
Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc. Developed hierarchies to support drill down reports.
Scheduled and monitored reports at the server level using Broadcast Agent (BCA).
Involved in the designing and building of the Universes, Classes and objects for the client requirements.
Created queries to extract data from an Oracle database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
Created various standard reports and queries based on the existing classes/objects.
Exported reports to Excel based on the user requirements.
Supervise the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions.
Exported Reports to the Broadcast Agent (BCA) Server, and used the BCA to schedule and monitor the Reports and customized the Web Intelligent front-end.
Educated end-users and provided technical support.
Environment:
Business Objects XIR2, Web Intelligence, Info view, Designer, Broadcast Agent, Oracle,Windows.
Project – 3:
Keystone Mercy Health Plan, Philadelphia, PA, Nov’ 04 – June’05
Business objects Developer
Responsibilities-
Designed, implemented, tested and maintained a data warehouse front-end system insight to capture the information like Members, Providers, Claims (Hospital, Physician, and Pharmacy), etc.
Responsible for the Designing the universes by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.
Created different types of reports like Master/Detail, Cross Tab and Chart.
Wide usage of Drill mode and Slice and Dice techniques to modify the reports in accordance with the user’s analysis needs.
Managing security by Adding, Enabling, Disabling and Deleting of User/Groups and granting of privileges using Supervisor.
Administering Repositories, Universes, Catalogs, User-control, Categories & Folders.
Used Business Query to load data directly to Excel and also involved in formatting.
Used Broad Cast Agent to schedule reports.
Imposed several Joins, Filters, and Alerters to restrict the unwanted data and highlight the required data.
Resolved loops with Aliases and Contexts.
Involved in migrating the reports from Business Objects 5.x to 6.5.
Provided training to end users to use various functionalities of Business Objects
Good knowledge on Migration of business objects universes and Reports using import wizard and report conversation tool.
Exported the Business objects Reports to be webi so that all users can view on the intranet
Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
ENVIRONMENT:
Business Objects 6.5/5, Web Intelligence,Info view, Oracle, and Windows2000/XP.
Project – 2:
Bank One, Chicago, IL May’03 – Oct’04
Business Objects Developer / Reporter
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 Reports accordingly
Involved in designing and building Universes, Classes and objects and defining the necessary connections
Involved in generating reports and resolving issues like, drill through two levels & Pivoted the data.
Reviewed all reports that are operating in the production environment with a goal of improving their efficiency
Exported the universes to the Repository in order to make the resources available to the users.
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.
Environment:
Business Objects 5/6, Web Intelligence, Info view, Oracle, and Windows 2000/XP.
Project -1:
American Modern Insurance Group Cincinnati, OH Nov’ 02 - Apr ‘03
Business Objects Reporter/Developer
Responsibilities-
Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
Designing new Universes and Modifying the existing Universes, using features like Check Integrity, Aliases, Loops, Contexts, Joins and finally creating the Objects (Dimensions, Measures and Details), which are grouped into Classes.
Upgrading and Maintaining Universes and Reports using Business Objects Best Practices in multiple Environments.
Creating and Formatting the Reports as per the Users Requirements using the features in Business Objects like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and Formulae to analyze the data.
Creating and distributing Report Templates to Users. Web-Enabling the Reports using webintelligence.
The main Data Providers for the Report generation in Full Client are Universes / Freehand SQL and Universes for Web Intelligence.
Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End User Notes.
Installing the Business Objects and Creating Repository (Security, Universe and Document Domains).
Managing security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using Supervisor.
Generated Test data for identifying valid data, Invalid data, Partial data &Bad data.
Environment:
Business Objects 5x, Oracle, Manual Testing, Windows.
Project:
ECIL (Electronics co-operation of India Limited) Jan’02 – Sep’02
SCADA systems. HYD – INDIA
Responsibilities:
Monitoring and controlling a complete site of a system
Working with DCS (Distributed control system).with single supplier.
Controlling the site with Programmer Logical Controllers.
EDUCATION:
Pursuing masters in computer science from University Of Northern Virginia, VA.
REFERENCES:
Will be presented upon request.
CERTIFICATION:
Certified in Business objects XIR2 @ GST
Title
Business Objects Developer
Primary Skills
Business Objects 4i, Oracle 8i, MS Access, Windows 2000/NT
Location
US-TX-Dallas
RESUME DETAILS
SUMMARY:
• Around five years of experience in Business Objects (4.3/5.0/5i/6i/XI) with around six years of professional experience in I.T. industry
• Worked extensively on modules Supervisor, Designer, Info view, Web Intelligence and Broadcast agent in Business Objects
• Knowledge of new features of Business Objects XI and 6i including Index awareness, Derived tables and Central management console-
• Experience in training Business Objects end users
• Experience on various operating systems including Windows NT/2000
• Knowledge in coding with VBA macros
• Extensively used PL/SQL in writing Stored Procedures, Functions, Packages and Triggers
• Knowledge of Dimensional modeling, Data migration, Data cleansing, Data profiling, Data mining, Data audits and Web reporting features of data warehouses
• Experience in Crystal reports and Crystal Enterprise environment
• Created and maintained complex universes supporting multiple levels of hierarchies for drill down and drill across reports
• Worked with the DBA to create aggregate tables and materialized views to improve the performance of the query by cutting down on the size of the result set at the data provider level-
• Knowledge of Oracle 7.3/8/8i/9i/10g, SQL Server 7.0/2000, Sybase databases, DB2
• Diversified experience in implementation Business objects report management with in Finance, Sales and Marketing, Supply Chain Management sectors
• Successfully implemented export to excel feature in lower versions of business objects using VBA macros
• Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures in Oracle and SQL Server
• Experience in working in a version migration environment from 5i to 6i
• An enthusiastic, project-oriented team player with solid communication and leadership skills. Also with an ability to develop creative solutions for challenging client needs
• Ability to work effectively in a team as well as individually with excellent communication and interpersonal skills. Also has an ability to develop creative solutions for challenging client needs
SKILLS:
Databases: Oracle 7.3/8/8i/9i/10G, SQL Server 7.0/2000, Sybase, DB2, and MS Access
ETL tools: SQL Loader
OLAP Tools: Business Objects (4.3/5.0/5i/6i/XI), Web Intelligence 2.6/6i, Broadcast Agent,
Central management Console, Info view, Designer, Reporter, Supervisor, Crystal Reports
Modeling Tools: ER Studio, VISIO
Data warehousing Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables, Toad,
concepts: DB Artisan, Rapid SQL
Programming Languages: SQL, PL/SQL, JAVA, HTML, XHTML
Operating systems: Windows 2000/NT.
Wells Fargo, Houston, Texas Apr 2005 - Present
Senior Business Objects Supervisor-Developer
Business Objects Report development team
Part of this assignment required for the development of reports for business analysis. These reports would be used to as the backbone in generating ad hoc reports. Another part involved an extensive work with Designer and Supervisor modules. In Designer module, created new objects after working with DBA for data procurement into Business Objects based on user needs. Also created new users and helped in access privilege issues of existing users in Supervisor module.
• Constantly worked with Business users to provide them with the data in form of complex reports and excel sheets for analysis
• Coded a Macro using VBA editor for sending a report as an attached PDF document every time the report is refreshed
• Created user profiles for new business users and also trained in using of Business Objects Reporter module
• Worked with the IT team to bring in the data required into Business Objects Universe so as to make available for super users to create Adhoc reports
• Constantly worked on complex reports providing for a report generation based on user needs
• Created reports based of free hand SQL and Universe objects
• Replicated/Migrated reports created in internal reporting tool, report retriever (an in house reporting system in the company) to Business Objects
• Worked on cross-tab and master detail reports. Also represented the same as line charts/ bar charts / pie charts of the same
• Evaluated the following features of Business Objects XI: Index awareness, Derived tables and Central management console
• Created a Business Objects User's power point presentation for an introduction to first time users and also as a handy guide
• Created several new objects in the Universe based on the report creation requirements.
• Constantly tested SQL for joins and contexts for new object creation. Using Rapid SQL conducted functional testing in the SQL of existing objects.
• Managed Universe consisting of 200 tables, 25 classes and 300 objects.
• Worked with the DBA to create aggregate tables and materialized views to improve the performance of the query by cutting down on the size of the result set at the data provider level
• Created document on usage of Info View for off site users with no full-client Business Object installed on their machines.
• Performed tuning on existing reports for better performance.
Environment: Business Objects 5.1.7, Business Objects Info View (Web I), Report Retriever reports, Visual Basic 6.0, DB2, Oracle, Windows NT
Genintech, California May 2004-Apr 2005
Senior Business Objects Supervisor-Developer
Business Objects Reports development.
• Involved in full project life cycle implementation (requirement gathering to production phase)
• Prepared the following -- business/technical writing of requirements, design templates, development standards document and detailed design documents
• Involved in extensive testing of universes and reports during version migration of business objects
• Involved in performance tuning of Business Objects reports by tuning the SQL using DB Artisan
• Involved in the installation of Business Objects repository, creation of user Ids, implementation of security features and management of the repository
• Extensively created Business Objects reports like matrix reports, tables, Pareto charts and pie charts
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc
• Extensively used Designer to design various universes for different business groups. Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.
• Involved in report bursting using Broadcast agent server
• Implemented row and object level security in business objects supervisor module
• Defined documentation standards including the creation of Entity relationship diagram (ERD) for universes
• Responsible for fitting Business Objects into the Information Architecture of the company as well as creating users privileges with supervisor. Also for developing and maintaining universes
• Managed categories that were created and assigned to documents by users
• Managed the scheduling options stored in the repository and also involved in changing the document descriptions
• Specified the standards/best practices for universes like maintaining design consistency. Also defined standards for tables, charts, etc
• Extensively used breaks for white spaces and sections for better navigation. And created template documents with header, footer and company logo
• Developed various Metadata and operational definitions
• Presented the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily
• Responsible for managing the Business Objects repository.
Environment: Business Objects 6I/XI, Broadcast agent server, Business Objects Web I, DB Artisan, Informatica Power Center 5.0, Crystal reports, Info View, Visual Basic 6.0, DB2, Oracle 9i, Windows NT.
British Petroleum, Houston,TX Sep 2003-May 2004
Business objects Supervisor-Developer
Project is developed for the British Petroleum. The project involves the Design, development and maintenance of Business Objects universes and Reports.
• Implemented the Software development life cycle methodology for creating reports
• Prepared and maintained documentation for understanding universes and reports
• Designed, built, and maintained Business Objects universes for different business groups and also created complex reports
• Authorized the user access to one or more universes
• Created restrictions on objects and classes based on universes privileges
• Used ER Studio to create ER diagrams for information flow analysis
• Developed various metadata and operational definitions. Also enhanced existing reports using sub-queries
• Constantly checked on data load into Business Objects repository working with the ETL team that used SQL loader
• Created User groups, Users, Database connections, Managed user privileges, Import/export of universes in production environment
• Used Broadcast agent for scheduled, batch processing of Business objects and Web intelligence documents
• Created detail and summary reports, used to fold/unfold sections corresponding to breaks in current blocks
• Created prompts in report to restrict data fetch and ease data load
• Scheduled daily/monthly reports and performed report bursting using Broadcast Agent Server
Environment: Business objects 5.1.3, Business Objects Web I, Broadcast agent Server, Oracle8i, SQL Server 7.0/2000, Windows NT.
ZALES, Dallas, Texas Jan 2003- Sep 2003
Business Objects Developer
Project is developed for sales and marketing department of Zales. Data from the data warehouse is used to design and develop reports using Business Objects 5.1.7, Broadcast agent server, Business Objects Web I.
• Involved in the Requirements gathering, Development, UAT, and Production support phases of Business Objects Report development
• Installed the Business Objects version 5.1.7
• Created user groups and managed access privileges using Business Objects Supervisor
• Responsible for Business Objects repository, performed tuning using Toad
• Performed release management of Business Objects reports using Broadcast Agent Server
• Extensively used Designer to design various universes for different business groups
• Designed, built, maintained Business Objects universes and repository
• Extensively used Web Intelligence Info view for exploring querying, reporting and analysis tasks
• Used Broadcast agent for scheduled, batch processing of Business objects and Web intelligence documents.
• Authorized user access to one or more universes, created restrictions on objects and classes based on universe privileges
• Developed various metadata and operational definitions
• Customized Business Objects web interface (intranet) to access the enterprise reports developed in Business Objects full client
• Troubleshoot the problems and customized the reports according to the specifications of the analysts
Environment: Business Objects 5.1.7, Broadcast agent server, Business Objects Web I, Informatica Power Center 5.0, Crystal reports 7.0, Visual Basic 6.0, Oracle 8i, Sybase, Windows NT.
Al Wafaq Training Center, UAE Apr 2000- Dec 2002
Database Developer
Al Wafaq provides training in consulting services in databases, web development and database warehousing.
• Trained IT team in Business Objects 4i.
• Worked extensively in creation of Oracle complex SQL.
• Partly involved in the logical and physical database design
• Created a webpage for the internal users of Al Wafaq to provide user guides coding in JAVA and HTML /XHTML
• Worked with the DBA to support and maintain Oracle cursors, functions, triggers and procedures, packages etc.
• Involved in performance tuning of SQL queries
Environment: Business Objects 4i, Oracle 8i, MS Access, Windows 2000/NT
Certifications
NA
Resume 2:
Professional Summery:
• 6 years of IT experience including 4 years in Business Objects.
• Well versed in Business Objects (XI, 6x and backwards) 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, Auditor and Schema Design.
• Good knowledge in Business Objects XI/XI R2 version.
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
• Worked on Web Intelligence to develop and publish thin client reports
• Created Dashboards using Application Foundation.
• Good knowledge and experience in using Oracle 9i/8i, MS SQL Server 2000, Enterprise manager, Query analyzer.
• Experience in developing SQL, PL/SQL procedures, database triggers and other components of database applications.
• Knowledge in building, extraction, transformation and loading (ETL).
• Experience in installation, administration and upgrading versions of BO both desktop and server products on both Windows and UNIX environments.
• Exposed to Data Warehouse assignments in various domains like Mortgage, Medical services, Sales, Insurance, Financial & Bank, Inventory Distribution, and Production Data warehouses.
• Excellent interpersonal, communication and presentation skills.
Professional Experience
Burger King, Miami, FL Feb'06- Till date
Business Objects Developer
• Interacted with Business Owners to know their Business views in modifying Reports accordingly.
• Initiated DBA interactions for resource requirements and modifications.
• Analyzed which universes and reports have to be modified.
• Detected cardinalities, loops, and checked the Integrity of Universes.
• Modified the existing Universes by merging different Classes and resolving the Loops and Chasm Traps by context.
• Changed List of Values (LOV) in the universe prompts.
• Modified the existing reports according to the new global alignment in the universe.
• Modified reports using the various data Providers like Free Hand SQL, Stored Procedures.
• Good knowledge in Business Objects XI/XI R2 version
• Imported Business Objects Universes, Users and user groups, and reports from Version 6x to Version XI R2 using the Import Wizard.
Environment: Business Objects 6.5.1 / XI R2, WebI 6.5, Designer, Supervisor, Broadcast Agent,
ZABO, Info view, SQL, PL/SQL, SQL Server 2000, Oracle 9i and Windows NT
Washington Mutual, Seattle, WA April'05 -- Jan'06
Business Objects Developer/Designer
• Interacted with Business Users and Business Owners to know their Business views 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
• Design and Development of Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users
• Upgraded Business Objects universes and reports from version 5.1.7 to version 6.5.1.
• Involved in the designing and Building of Universes, Classes and objects
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Worked on the Master, Kernel and Component approach during the linking of universes.
• Created and tested classes and objects to organize the universe.
• Exported the universes to the Repository to make resources available to the users
• Created reports for various Portfolios using the various data Providers like Free Hand SQL, Stored Procedures, VB procedures.
• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc
• Created reports using Info View and ZABO for distribution to users
• Created Schedulers to monitor Broadcast Agent
• Built full client and WEBI reports.
• Set up groups and users for Business Objects deployment. Managed user profiles using Supervisor
• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects 6.0 connected to Oracle 9i data source
• Created Business Objects Repository while building Business Objects solution.
• Published and scheduled Business Objects Reports to users using Scheduler
• Created and Developed Stored Procedures, Packages.
• Created and customized application dashboards using Application Foundation to meet the requirements of higher level analysis.
• Developed dashboards and scoreboards for detailed analysis.
Environment: Business Objects 6.5.1/XI, WebI 6.5, Designer, Supervisor, Broadcast Agent,
ZABO, Info view, SQL, PL/SQL, Application Foundation, Oracle 9i and
Windows NT.
Fidelity Investments, Boston, MA Sep'04 - March'05
Business Objects Developer/Analyst
• Generated reports using Business Objects 5.1 and Crystal Reports 8.0
• Used Business Objects Developer Suite (Broadcast Agent, Supervisor, Designer, Info View), BO Query Designer and Report Designer
• Involved in designing Business Objects Universes, Queries, and Reports
• Wrote ad hoc queries and web reports using Business Objects Suite
• Designed and managed groups and users using Supervisor module and assigned them universes and documents specific to their domains
• Created reports using queries, slice and dice, drill down, @functions, cross tab, master detail, formulas
• Created Complex reports using functions, hierarchies, rank and sorting
• Designed and maintained Complex Universes, resolved loops by creating aliases and contexts
• Used Broadcast Agent to schedule the reports depending on the user profile.
• Good experience in creating customized Dashboards for overall performance.
• Developed Dashboards for detailed analysis
• Data modeling and design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology with confirmed and granular dimensions and FACT tables
Environment: Business Objects Suite, WebI, Crystal Reports, Application Foundation, SQL, and
MS SQL Server 2000 and Windows Platform.
GE Medical Systems, Milwaukee, WI Feb' 03 - Aug '04
Clinical Services Information Systems
Business Objects Developer/Administrator
• Created several Classes, Objects, Conditions, and Measure objects.
• Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc. Developed hierarchies to support drill down reports.
• Scheduled and monitored reports at the server level using Broadcast Agent (BCA).
• Involved in the designing and building of the Universes, Classes and objects for the client requirements.
• Created queries to extract data from an Oracle database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
• Created various standard reports and queries based on the existing classes/objects.
• Exported reports to Excel based on the user requirements.
• Manage Production, Test and Dev environments including installation of patches, security administration and access controls.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions
• Exported Reports to the Broadcast Agent (BCA) Server, and used the BCA to schedule and monitor the Reports and customized the Web Intelligent front-end
• Educated end-users and provided technical support.
Environment: Business Objects 5.x, Web Intelligence, Oracle 8.x, Win2000.
Allstate Insurance Company, Northbrook, IL Mar'02 - Jan'03
Business Objects Designer
• Interacted with Business Users and Business Analysts to gather Information to enhance the Universe.
• Analyzed Existing Universe and Database to enhance the existing Universe and Create new Universe
• Imported existing Universe to modify
• Resolved Loops in Universe by creating Aliases and Contexts.
• Checked Universe for integrity and exported to repository to make it available for user groups
• Created Reports from Multiple data sources from database and Personal files
• Created Master/Detail Cross-Tab and summarized reports to view the data in an analyzed way.
• Formatted the Reports to meet the user requirements using Multi-Dimensional Analysis like Slice and Dice, Drill Down.
• Created Alerts and Implemented Ranking in the reports.
• Worked on Web Intelligence to develop and publish thin client reports
Environment: Business Objects 5.x, Web Intelligence, Info view, Designer, Supervisor,
Broadcast Agent, Oracle 8.x, PL/SQL, Win 2000.
Soul Software Pvt Ltd, India Dec'99 - Jan'02
Programmer/Analyst
• Involved in design, development, and implementation of the application.
• Involved in the creation of GUI for Account Information System.
• Created database tables.
• Connection to database.
• Good knowledge in using Normalization techniques.
• Also involved in Testing Phase of the Application.
Environment: C, Oracle, SQL, PL/SQL, UNIX, and Windows 98.
Education: Bachelor of Engineering in Mechanical Engineering
Certifications
Bachelor of Engineering in Mechanical Engineering
Business Intelligence Tools
BO 5.x,6.x
BO XIR1/R2
Reporter
Developer
Designer
Internet Technologies
Webi
CMC
Infoview
Reporting Tools
Business Objects Reporter
Broadcast Agent Publisher
Info View
Web Intelligence
Web Tools
HTML
Java Script
Data Base
Oracle
MS Access
98/2000
DB2
SQL Server
Languages
Java
C
C++
Oracle
SQL *PLUS
Operating System
Windows 9I/XP/2000
Windows NT
Functionalities
Row-level security
Objects-level security
Master/Detail
Slice and Dice
Drill up/down
Conditions
Filters
Charts
Alerters
LOV
Context
Aliases
Universes
Reports
@Functions
Formulas
Scheduling
Cross tab
UDO
Joins
Resume 3:
OBJECTIVE:
A position as a Business Objects designer or as a developer to use my skills and experience in Business Objects Xi2, Designer module, Reporter module, Web Intelligence 6.5, Broadcast Agent and Business Objects XI,
MS SQL server 2000 and Data-warehousing Technologies.
EXPERIENCE SUMMARY:
Self-motivated and result-oriented professional with five years of extensive experience in IT including 4 years in Business objects.
Extensively worked and used Business Objects 6x/XIR2 - Business Objects Designer, Reporting and Web Intelligence.
Good knowledge a Data-warehouse Environment, decision support, RDBMS, Client/Server.
Expertise in retrieving data using Business Objects Universes, personal data files, like EXCEL, PDF.
Proficient in creating reports using Business Objects XI R2 functionalities such as Queries, Master/Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts.
Proficient in designing and building universes by selecting and joining tables, setting cardinalities and resolving loops by using aliases and contexts.
Worked on Web Intelligence to develop and publish thin client reports.
Experience in installation, migration and upgrading versions of BO both desktop and server products on Windows environment.
Experience in handling complex problems and finding right solutions in time.
Excellent interpersonal, communication and presentation skills.
WORK EXPERIENCE:
Company: Comprobase Inc, VA
Position: Business Objects Developer
Duration: Since September 2006
Environment: Business Objects 6x/XIR2, Web Intelligence, Deski, BO Designer, Oracle, Windows XP.
Responsibilities:
Meeting with department chairs to determine requirements, specifications, and analysis. Working closely with functional system users to document business processes and define system functionality.
Responsible for designing the Universe, created Contexts and Aliases for resolving Loops in the Universes to improve performance.
Linking the Universes to share common objects. Updating and maintaining Universes based on changing user requirements and data source changes.
Extensively used filters, conditions, list of values (LOV), calculations, etc.
Creating different types of reports such as Master/Detail, Cross Tab and Charts.
Creating complex joins like outer joins, equi-join and theta joins and checked the integrity of the Universes.
Applying slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis.
Applied graphical representation of reports such as Bar Charts, Pie Charts as per the end user requirements.
Responsible for designing, building, testing, Universes and Reports through Business Objects XIR2.
Worked on planning future migration to Business Objects XI from 6.x.
Excellent written and oral communication skills to make technical or non-technical material understandable to the users.
Company: GE Medical Systems, Milwaukee,WI
Clinical Services Information Systems
Position: Business Objects Developer
Duration: Aug ‘05 - July '06
Environment: Business Objects XIR2, Web Intelligence, Info view, Designer, Broadcast Agent, Oracle, Windows.
Responsibilities:
Created several Classes, Objects, Conditions, and Measure objects.
Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc.
Developed hierarchies to support drill down reports.
Scheduled and monitored reports at the server level using Broadcast Agent (BCA).
Involved in the designing and building of the Universes, Classes and objects for the client requirements.
Created queries to extract data from an Oracle database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
Created various standard reports and queries based on the existing classes/objects.
Exported reports to Excel based on the user requirements.
Supervise the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions.
Exported Reports to the Broadcast Agent (BCA) Server, and used the BCA to schedule and monitor the Reports and customized the Web Intelligent front-end.
Educated end-users and provided technical support.
Company: Orbitz, Chicago
Position: Business Objects Developer
Duration: Nov’ 04 – June’05
Environment: Business Objects 6.5/5, Web Intelligence, Info view, Oracle, and Windows2000/XP.
Responsibilities-
Responsible for the Designing the universes by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.
Created different types of reports like Master/Detail, Cross Tab and Chart.
Wide usage of Drill mode and Slice and Dice techniques to modify the reports in accordance with the user’s analysis needs.
Managing security by Adding, Enabling, Disabling and Deleting of User/Groups and granting of privileges using Supervisor.
Administering Repositories, Universes, Catalogs, User-control, Categories & Folders.
Used Business Query to load data directly to Excel and also involved in formatting.
Used Broad Cast Agent to schedule reports.
Imposed several Joins, Filters, and Alerters to restrict the unwanted data and highlight the required data.
Resolved loops with Aliases and Contexts.
Involved in migrating the reports from Business Objects 5.x to 6.5.
Provided training to end users to use various functionalities of Business Objects
Good knowledge on Migration of business objects universes and Reports using import wizard and report conversation tool.
Exported the Business objects Reports to be webi so that all users can view on the intranet
Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
Company: Bank One, Chicago.
Position: Business Objects Developer
Duration: May’03 – Oct’04
Environment: Business Objects 5/6, Web Intelligence, Info view, Oracle, and Windows 2000/XP.
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 Reports accordingly
Involved in designing and building Universes, Classes and objects and defining the necessary connections
Involved in generating reports and resolving issues like, drill through two levels & Pivoted the data.
Reviewed all reports that are operating in the production environment with a goal of improving their efficiency
Exported the universes to the Repository in order to make the resources available to the users.
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.
Company: American Modern Insurance Group, OH.
Position: Business Objects Developer
Duration: Nov’ 02 - Apr ‘03
Environment: Business Objects 5x, Oracle, Manual Testing, Windows.
Responsibilities:
Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
Designing new Universes and Modifying the existing Universes, using features like Check Integrity, Aliases, Loops, Contexts, Joins and finally creating the Objects (Dimensions, Measures and Details), which are grouped into Classes.
Upgrading and Maintaining Universes and Reports using Business Objects Best Practices in multiple Environments.
Creating and Formatting the Reports as per the Users Requirements using the features in Business Objects like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and Formulae to analyze the data.
Creating and distributing Report Templates to Users. Web-Enabling the Reports using web intelligence.
Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End User Notes.
Installing the Business Objects and Creating Repository (Security, Universe and Document Domains).
Managing security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using Supervisor.
Generated Test data for identifying valid data, Invalid data, Partial data &Bad data.
Company: ECIL (Electronics co-operation of India Limited)
Duration: Jan’02 – Sep’02
Environment: Simulink, Java, Windows
Responsibilities:
Monitoring and controlling a complete site of a system.
Working with DCS (Distributed control system).with single supplier.
Controlling the site with Programmer Logical Controllers.
Monitor SCADA system performance.
Evaluate, Test and Apply application soft ware updates.
EDUCATION:
Masters in Computer Science from University Of Northern Virginia, VA.
Bachelor of technology, INDIA
Resume 4:
Professional Summary
Five (5+) years of Business Intelligence Systems experience in full life cycle development (gathering requirements, documentation, developing and designing BusinessObjects 6x and XI environments, database design, developing Web Intelligence reports, processing and analyzing data in MS Access, SQL Server 2000, Oracle 9i.
Expert in working with BusinessObjects Reporter, Designer and creating Dashboard Manager using Application Foundation and Web Intelligence.
Experienced with configuring Web Intelligence server and BusinessObjects administration.
Strong background in systems/business analysis for the purpose of gathering, documenting and implementing reporting requirements.
Superior analytical and writing skills, coupled with good communication skills.
Technical Summary
Professional Experience
Yahoo-Inc 01/07 – 04/07
BusinessObjects Dashboard Developer/Reporter - Consultant
Installed BusinessObjects XIR2, successfully installed and ran Publishing Wizard, and Import Wizard.
Restricted different users depending upon the hierarchy.
Created several Corporate Dashboards and Personal Dashboards (making use of certain predefined analytics, user defined analytics).
Created rules, events, Web Intelligence reports making use of several Queries (union, minus).
Developed several complex reports depending up on the metrics and customized several reports into excel, pdf, .csv.
Generated several Templates in Webi / Deski.
Created 500 users with different access rights.
Scheduled the reports on daily wise, monthly wise, weekly.
Used Master/ detail, Filters and Prompt in-order to generate the reports as per the End user requirements.
Used Schedule Manager, Instance manager, and Query builder.
Created several Repositories.
Generated dashboards in such a way user can be able to see the deviation, metric trees, embedded videos in dashboards, linking pages and creating navigation packages.
Environment: BusinessObjects XIR2, Web Intelligence, InfoView, Designer, Schedule Manager, Java SDK, Oracle, SQL Server, PL/SQL, Performance Manager, Dashboard Builder, CMC, Import Wizard, Publishing Wizard, Repository Migration Wizard.
Federal Trade Commission (FTC) 12/06 – 01/07
BusinessObjects Developer / Reporter - Consultant
Met with department chairs to determine requirements, specifications, and performed analysis. Worked closely with functional system users to document business processes and define system functionality.
Responsibilities included designing, building, testing, and deploying Dashboards, Universes and Reports through BusinessObjects 6x.
Worked with Data Warehouse, querying relational and multi-dimensional database structures using SQL and BusinessObjects Reporter.
Configured the Web Intelligence server.
Played a lead role on planning the future migration to BusinessObjects XI.
Designed the Universe, created Contexts and Aliases for resolving Loops in the Universes to improve performance.
Used filters, conditions, list of values (LOV), and calculations.
Linked the Universes to share common objects. Updated and maintained Universes based on changing user requirements and data source changes.
Created different types of reports such as Master/Detail, Cross Tab and Charts.
Created complex joins like outer joins, equi-join and theta joins and checked the integrity of the Universes.
Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis.
Created report development using Crystal Reports.
Created cross-tab, conditional, drill-down, Charts and sub reports using Crystal Reports.
Excellent written and oral communication skills to make technical or non-technical material understandable to the users.
Environment: BusinessObjects RiX2, Web Intelligence, PL/SQL, InfoView, Designer, Broadcast Agent, Migration Wizard, Java, Oracle 10g, Performance Manager.
Global Software Technologies (GST) - VA 03/06 – 11/06
Trainer for BusinessObjects 6.5/XIR2 Classes
As the BusinessObjects subject matter expert, trained the internal GST technical staff in the following areas:
Overview and in-depth “how to” working with BusinessObjects 6.5/XIR2: Reporter (Reports), Designer (Universe), Migration Wizard, WebIntelligence, InfoView, Dashboard, BCA and Administration.
GE Medical Systems 08/05 – 01/06
BusinessObjects Developer/Administrator - Consultant
Created several Classes, Objects, Conditions, and Measure objects.
Created reports using BusinessObjects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc. Developed hierarchies to support drill down reports.
Scheduled and monitored reports at the server level using Broadcast Agent (BCA).
Involved in the designing and building of the Universes, Classes and objects for the client requirements.
Created queries to extract data from an Oracle database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
Created various standard reports and queries based on the existing classes/objects.
Exported reports to Excel based on the user requirements.
Managed Production, Test and Dev environments including installation of patches, security administration and access controls.
Administered and supervised the BusinessObjects environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions.
Exported Reports to the Broadcast Agent (BCA) Server, and used the BCA to schedule and monitor the Reports and customized the Web Intelligent front-end.
Educated end-users and provided technical support.
Environment: BusinessObjects RiX2/X1, Web Intelligence, InfoView, Designer, Migration Wizard, Broadcast Agent, Java, Oracle 8.x, PL/SQL.
Allstate Insurance Company 04/04 – 06/05
BusinessObjects Designer - Consultant
Interacted with Business Users and Business Analysts to gather Information to enhance the Universe.
Analyzed existing Universe and Database to enhance the existing Universe and create new Universe.
Imported existing Universe to modify.
Resolved Loops in Universe by creating Aliases and Contexts.
Checked Universe for integrity and exported to repository to make it available for user groups.
Created Reports from Multiple data sources from database and Personal files.
Formatted the Reports to meet the user requirements using Multi-Dimensional Analysis like Slice and Dice, Drill Down.
Created Alerts and Implemented Ranking in the reports.
Worked on Web Intelligence to develop and publish thin client reports.
Environment: BusinessObjects 6x/XI, Web Intelligence, InfoView, Designer, Supervisor, Broadcast Agent, Oracle 8.x, PL/SQL.
Data Warehouse Programmer / Analyst – Consultant 05/03 – 02/04
Responsibilities included data mart/warehouse analysis, design, and implementation, including business and warehouse requirements.
Worked with multiple data providers and linked these data providers based on the requirements.
Worked on the migration of Web Intelligence documents and published them to the repository in their respective groups and categories.
Created complex reports using Reporter module in Desktop/Web Intelligence functionalities like Slice and Dice, Drill Down, @Functions, Cross Tabs, Master/Detail, and Formulas.
Created templates for standardizing the structure of corporate documents.
Tested reports for accuracy, and troubleshoot report issues including poor performance and bad data.
Analyzed report requirements and developed critical corporate reports based on the Web Intelligence functionality.
Created complex reports using user defined functions, condition objects and used aggregate awareness, short-cut join functions for Query performance enhancement.
Optimized performance and monitored entire BusinessObjects, Web Intelligence reporting system.
Led various data analysis, integration, and testing efforts and ensured compliance with overall enterprise data strategy and standards.
Supported the development of data warehouse metadata repository, and led the prototyping efforts.
Responsible for Web Intelligence server performance tuning, BusinessObjects SDK, and BCA (Broadcast Agent) administration.
Environment: Oracle8i / BusinessObjects 5.0, Web Intelligence, PL/SQL, Windows NT, HTML, Java.
GigaSoft 12/02 – 01/03
BusinessObjects Designer - Consultant
Administered the BusinessObjects systems infrastructure, including installs, upgrades, and troubleshooting, publishing reports using BCA.
Designed and developed Data Models within a data warehouse environment.
Participated in data analysis, primarily using SQL Server and other standard RDBMS tools.
Reviewed all reports that are operating in the production environment with a goal of improving their efficiency.
Developed multi agency reports, using complex logic, to extract information from the data warehouse in a format acceptable to the end users
Supported internal users with BusinessObjects Reports & Web Intelligence portal issues.
Environment: BusinessObjects 6i/5i, Designer, Broadcast Agent, BusinessObjects Supervisor, BusinessObjects Designer, Oracle 8i/9.i, Windows 2000
Maram Software Solutions 02/01 – 10/02
Java Programmer
Project: Online books inquiry system
An Intranet system is designed to give online help to the customers of a library.
Developed excellent search capabilities.
Performed system testing of java modules and components.
Documented java modules and components.
Created, troubleshot and updated code files.
Implemented and tested the system
Environment: J2EE, Oracle, JavaScript, HTML. JSP, Java, PL/SQL.
Project: e-Banking System
Programmer Analyst
Developed online Banking application using Java, J2EE and Oracle 8i.
The main aim of the project is to design and implement a user interface of an e-banking client.
Environment: Java (JSP), Oracle, HTML, J2EE, Tomcat 5.0
Education
Masters in Computer Science
University of Northern Virginia
Certifications
Certified C/C++ programmer from Brain Bench
Brain Bench Certified computer fundamentals with Win XP
Brain Bench Certified in JAVA2 fundamentals
Resume 5:
OBJECTIVE
A position as a Business Objects designer or as a developer to use my skills and experience in Business Objects Xi2, Designer module, Reporter module, Web Intelligence 6.5, Broadcast Agent, Publisher and Business Objects XI, MS SQL server 2000, Oracle9i, and Data-warehouse technologies.
SUMMARY OF EXPERIENCE
5+ years experience in full life cycle development (gathering requirements, documentation, developing and designing Business Objects environments, database design, developing web intelligence reports, processing and analyzing data in MS Access, MS SQL server 2000, Oracle 9i.
Proficient in setting up Repository, creating and managing users and user groups and manage security.
Experience in Data warehousing environment, decision Support, RDBMS, Client\Server and Multi-dimensional database technology.
Expert in programming in free hand SQL, Visual Basic, HTML, XML, JSP for document generation.
Expert in working with Business Objects Reporter and creating Dashboard Manager using Application Foundation and web intelligence.
Strong background in systems/business analysis for the purpose of gathering, documenting and implementing reporting requirements.
Superior analytical and writing skills, coupled with good business and financial acumen.
Good Knowledge in Security Viewer, Import Wizard, Publishing Wizard, Query Builder, Instance manager.
Good follow up on the updates on technologies
TECHNICAL SKILLS
Reporting Tools: Business Objects Reporter XiR2, Designer, Broadcast Agent, SchedulerXIR2, CMC, Import Wizard, Publishing Wizard, Migration Wizard, Web Intelligence, Info View, Query Builder, Instance Manager, Administrator Console.
Languages: Sql*Plus, C, C++, Java, JSP, XML.
RDBMS: Oracle 8.0/8i, 9i, DB2, MS SQL Server 2000
Internet Technologies: Web Intelligence, CMC, INFOVIEW
Operating systems: WINDOWS 9i/XP/NT
WORK EXPERIENCE
Company: Global Software Technologies, VA.
Position: Developer/Designer
Duration: Since April 2003
Environment: Business Objects XI/6i/5i, Web Intelligence 6x, Broad Cast Agent, Business
Objects Supervisor, BO Designer, Oracle 8i/9i, Windows XP/NT/9i.
Project-5
Yahoo-Inc, CA, Jan’07 – till date.
Business Object Dashboard developer /Reporter.
Responsibilities:
Installed Business Objects XIR2, Successfully installed and run Publishing Wizard, Import Wizard.
Restricted different users depending upon the hierarchy.
Created several Corporate Dashboards and Personal Dashboards ( making use of certain predefined analytics, user defined analytics).
Created rules , events, Webi reports making use of several Queries(union, minus).
Developed several Complex reports depending up on the metrics and customized several reports into excel, pdf, .csv.
Generated several Templates in Webi / Deski.
Created 500 users and gave them different access rights.
Good experience in CMC.
Scheduling the reports on daily wise, monthly wise, weekly.
Extensively used Master/ detail , Filters and Prompt in-order to generate the reports as per the End user requirements.
Made use of Schedule Manager, Instance manager, Query builder.
Created several Repositories.
Generated dashboards in such a way user can be able to see the deviation, metric trees, embedded videos in dashboards, linking pages and creating navigation packages.
Environment: Business Objects RiX2, Web Intelligence, Infoview, Designer, Schedule Manager, Java SDK, Oracle, Performance Manager, Dashboard Builder, CMC, Import Wizard, Publishing Wizard, Repository Migration Wizard.
Project-4
FTC, Washington, D.C. oct'06 – Jan’07.
Business Objects Developer/Reporter.
Responsibilities:
Meeting with department chairs to determine requirements, specifications, and analysis. Work closely with functional system users to document business processes and define system functionality.
Responsible for designing, building, testing, and deploying Dashboards, Universes and Reports through Business Objects 6x.
Working with Data Warehouse, querying relational and multi-dimensional database structures using SQL and Business Objects Reporter.
Designing the Universe, created Contexts and Aliases for resolving Loops in the Universes to improve performance.
Extensively used filters, conditions, list of values (LOV), calculations, etc.
Linking the Universes to share common objects. Updating and maintaining Universes based on changing user requirements and data source changes.
Creating different types of reports such as Master/Detail, Cross Tab and Charts.
Creating complex joins like outer joins, equi-join and theta joins and checked the integrity of the Universes.
Applying slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis.
Creating report development using Crystal Reports.
Creating cross-tab, conditional, drill-down, Charts and sub reports using Crystal Reports.
Lead role on planning future migration to Business Objects XI.
Excellent written and oral communication skills to make technical or non-technical material understandable to the users.
Environment: Business Objects RiX2, Web Intelligence, PL/SQL, Info view, Designer,
Broadcast Agent, Java, Oracle 10g, Performance Manager.
GST, Vienna, VA , Mar ’06 - Sep ’06.
Trainee For Business Objects 6.5/XIR2.
Responsibilities:
Working with Documents
Report Structures
Drilling into Reports
Business Objects Universes
Business Objects Universe Contexts
Building a New Document (New Report Wizard)
Building a New Document (Query Panel)
Query Panel Data Types
Data Sets in Documents
Data Providers are Collections of Data Objects
Object Behavior
Inserting Multiple Data Providers
Inserting an Additional Data Provider
Re-Qualifying Data Objects
Un-Linked Data Providers
Linking Multiple Data Providers
Linking Multiple Data Providers
Talking Points
Talking Points
Null Values in Linked Data Providers
Erroneous Results from Multiple Data Providers
Data and Report Contexts
Contexts in Reports
Contexts in Data
Context Operators
The In Operator
In Operator Overrides Existing Report Contexts
In Operator Context Definitions
In Block Example
The Where Operator
Rest of World Example
Where Operator Restrictions
Prompted Rest of World Example
Formulas, Variables And Various Functions
Worked on how to create Dashboards and Concepts of analysis and created several scenarios and also trained people how to overcome certain errors, during creating dashboards and report generation.
How to schedule the reports using BCA, using Info-view, how to increase the performance.
Trained people how to customize the Info-view, CMC.
Project-3
GE Medical Systems, Milwaukee, WI Aug ‘05 - Jan '06
Clinical Services Information Systems
Business Objects Developer/Administrator
Responsibilities:
Created several Classes, Objects, Conditions, and Measure objects.
Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc. Developed hierarchies to support drill down reports.
Scheduled and monitored reports at the server level using Broadcast Agent (BCA).
Involved in the designing and building of the Universes, Classes and objects for the client requirements.
Created queries to extract data from an Oracle database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
Created various standard reports and queries based on the existing classes/objects.
Exported reports to Excel based on the user requirements.
Manage Production, Test and Dev environments including installation of patches, security administration and access controls.
Administer and supervise the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions.
Exported Reports to the Broadcast Agent (BCA) Server, and used the BCA to schedule and monitor the Reports and customized the Web Intelligent front-end.
Educated end-users and provided technical support.
Environment: Business Objects RiX2/X1, Web Intelligence, Info view, Designer,
Broadcast Agent, Java, Oracle 8.x, PL/SQL.
Project-2
Allstate Insurance Company, Northbrook, IL Apr'04 - June'05
Business Objects Designer
Responsibilities:
Interacted with Business Users and Business Analysts to gather Information to enhance the Universe.
Analyzed Existing Universe and Database to enhance the existing Universe and Create new Universe.
Imported existing Universe to modify.
Resolved Loops in Universe by creating Aliases and Contexts.
Checked Universe for integrity and exported to repository to make it available for user groups.
Created Reports from Multiple data sources from database and Personal files.
Formatted the Reports to meet the user requirements using Multi-Dimensional Analysis like Slice and Dice, Drill Down.
Created Alerts and Implemented Ranking in the reports.
Worked on Web Intelligence to develop and publish thin client reports
Environment: Business Objects 6x/Xi, Web Intelligence, Info view, Designer, Supervisor,
Broadcast Agent, Oracle 8.x, PL/SQL.
Project-1
Consultant • Programmer / Analyst May 2003 - Feb 2004.
Description:
The Health Plan Control system is custom specific software designed to plan and monitor “Plan Coverage” for Geographical Regions. HPC maintains coverage specifications, bill of services and user requirement data for online processing of Plan Registration and Acceptance notices. The applications capabilities to customize Plan modification criteria made the system a powerful and generic tool for data maintenance and tuning operations. On-demand and automated report generation was possible to notify non-conforming products.
Responsibilities:
Responsible for data mart/warehouse analysis, design, and implementation, including business and warehouse requirements.
Extensively worked with multiple data providers and linking these data providers based on the requirements.
Worked on the migration of WebI documents and published them to the repository in their respective groups and categories.
Created complex reports using Reporter module in Desktop/Web Intelligence functionalities like Slice and Dice, Drill Down, @Functions, Cross Tabs, Master/Detail, and Formulas.
Created templates for standardizing the structure of corporate documents.
Tested reports for accuracy, and troubleshoot report issues including poor performance and bad data.
Analyzed report requirements and developed critical corporate reports based on the Web intelligence functionality.
Created complex reports using user defined functions, condition objects and used aggregate awareness, short-cut join functions for Query performance enhancement.
Performance optimization and monitoring of entire business objects, Web intelligence reporting system.
Lead various data analysis, integration, and testing efforts and ensured compliance with overall enterprise data strategy and standards.
Supported the development of data warehouse metadata repository, leading prototyping efforts.
Responsible for Web Intelligence server performance tuning, Business Objects SDK, and BCA (Broadcast Agent) administration.
Environment: Oracle8i / Business Objects 5.0, Web Intelligence, PL/SQL, Windows NT, HTML, Java.
Company: GigaSoft, Washington, DC.
Position: Business Objects Designer
Duration: Dec’ 2002 - Jan’ 2003
Responsibilities:
Administered the BO systems infrastructure, including installs, upgrades, and troubleshooting, publishing reports using BCA.
Designed and developed Data Models within a data warehouse environment.
Participated in data analysis, primarily using SQL Server and other standard RDBMS tools.
Reviewed all reports that are operating in the production environment with a goal of improving their efficiency.
Developed multi agency reports, using complex logic, to extract information from the data warehouse in a format acceptable to the end users
Supported internal users with Business Objects Reports & Web Intelligence portal issues.
Environment: Business Objects 6i/5i, Designer, Broad Cast Agent, Business Objects Supervisor, Business Objects Designer, Oracle 8i/9.i, Windows 2000
Company: Maram Software Solutions, Hyderabad, India
Position: Java Programmer
Duration: Feb 2001- Oct 2002.
Environment: J2SE, Oracle, JavaScript, Html.
Description:
MaramSoft provides the planning and implementation IT-enabled processes needed to support business. By focusing intensely on analysis of the IT sourcing needs, an enterprise can ensure that it has access to necessary resources- and even find a way to survive in the marketplace.
Project-2
Online books enquiry Package
Responsibilities:
An Intranet system is designed to give online help to the customers of a library.
Developed excellent search capabilities.
System testing java modules and components.
Documentation of java modules and components,
Creating code files,
Troubleshooting code files,
Updating code files
Implemented and tested the system
Environment: JSP, Java, Java Script, PL/SQL.
Project-1
e-Banking, CMC Ltd.
Responsibilities:
Technologies used are Java, J2EE-including transactions and security, Oracle 8i.The main aim of the project is to design and implement a user interface of an e-banking client, the design could cover day to day operations such as, bundling of a set of payments, or one-time tasks such as, installation of a digital signature-based client. The design is made in such a way to clarify & reduce the number of codes, passwords, etc... That the user is required to remember, Provide good explanation of the security concepts that the user is required to understand, for e.g. “signature file”. These improvements should not weaken security, and the project should not weaken security, and the project should provide some analysis of this. Java applet program design is used to implement a secure e-banking client, for security reasons we made use of various libraries that are provided by java, the browser for the purpose of Security, Authentication and Confidentiality.
Environment: Java (JSP), Oracle, Html, J2EE, Tomcat 5.0
EDUCATION
Masters in Computer Science,
Specializing in: Computer Science
AWARDS AND HONORS
Certified C/C++ programmer from Brain Bench
Resume 6:
EXPERIENCE SUMMARY:
Self-motivated and result-oriented professional with five years of extensive experience in IT including 4 years in Business objects.
Extensively worked and used Business Objects 6x/XIR2 - Business Objects Designer, Reporting and Web Intelligence.
Good knowledge in Business Objects XIR2/6.x.
Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
Proficient in creating reports using Business Objects XI R2 functionalities such as Queries, Master/Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts.
Proficient in designing and building universes by selecting and joining tables, setting cardinalities and resolving loops by using aliases and contexts.
Worked on Web Intelligence to develop and publish thin client reports.
Experience in installation, migration and upgrading versions of BO both desktop and server products on Windows environment.
Created simple cooperate dashboard by making use predefine analytics.
Good knowledge in performance manager, dashboard builder.
Created several metrics and schedule dashboards on weekly bases
Good knowledge about migration i.e. software migration / resource migration / import wizard / report conversation tool
Experience in handling complex problems and finding right solutions in time.
Good interpersonal, communication and presentation skills.
TECHNICAL SKILLS:
Reporting: Business Objects Reporter 5/6x/XIR2, Designer, Broadcast Agent publisher.
Internet Technologies: Web Intelligence, INFOVIEW, CMC.
Operating systems: WINDOWS XP/2000/9i/NT.
Languages: C, C++, Java.
RDBMS: ORACLE, MS SQL Server 2000.
WORK EXPERIENCE:
PROJECT- 5:
GST Inc, VA Sep ‘2006 - Till date
Position: Business Objects Designer /Developer
Responsibilities:
Meeting with department chairs to determine requirements, specifications, and analysis. Working closely with functional system users to document business processes and define system functionality.
Responsible for designing the Universe, created Contexts and Aliases for resolving Loops in the Universes to improve performance.
Linking the Universes to share common objects. Updating and maintaining Universes based on changing user requirements and data source changes.
Extensively used filters, conditions, list of values (LOV), calculations, etc.
Creating different types of reports such as Master/Detail, Cross Tab and Charts.
Creating complex joins like outer joins, equi-join and theta joins and checked the integrity of the Universes.
Applying slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis.
Applied graphical representation of reports such as Bar Charts, Pie Charts as per the end user requirements.
Responsible for designing, building, testing, Universes and Reports through Business Objects XIR2.
Worked on planning future migration to Business Objects XI from 6.5 x.
Excellent written and oral communication skills to make technical or non-technical material understandable to the users.
Environment:
Business Objects 6x/XIR2, Web Intelligence, Deski,BO Designer, Oracle Windows XP.
Project-4:
GE Medical Systems, Milwaukee, WI Aug ‘05 - July '06
Clinical Services Information Systems
Business Objects Reporter/Developer
Responsibilities:
Created several Classes, Objects, Conditions, and Measure objects.
Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc. Developed hierarchies to support drill down reports.
Scheduled and monitored reports at the server level using Broadcast Agent (BCA).
Involved in the designing and building of the Universes, Classes and objects for the client requirements.
Created queries to extract data from an Oracle database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
Created various standard reports and queries based on the existing classes/objects.
Exported reports to Excel based on the user requirements.
Supervise the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions.
Exported Reports to the Broadcast Agent (BCA) Server, and used the BCA to schedule and monitor the Reports and customized the Web Intelligent front-end.
Educated end-users and provided technical support.
Environment:
Business Objects XIR2, Web Intelligence, Info view, Designer, Broadcast Agent, Oracle,Windows.
Project – 3:
Keystone Mercy Health Plan, Philadelphia, PA, Nov’ 04 – June’05
Business objects Developer
Responsibilities-
Designed, implemented, tested and maintained a data warehouse front-end system insight to capture the information like Members, Providers, Claims (Hospital, Physician, and Pharmacy), etc.
Responsible for the Designing the universes by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.
Created different types of reports like Master/Detail, Cross Tab and Chart.
Wide usage of Drill mode and Slice and Dice techniques to modify the reports in accordance with the user’s analysis needs.
Managing security by Adding, Enabling, Disabling and Deleting of User/Groups and granting of privileges using Supervisor.
Administering Repositories, Universes, Catalogs, User-control, Categories & Folders.
Used Business Query to load data directly to Excel and also involved in formatting.
Used Broad Cast Agent to schedule reports.
Imposed several Joins, Filters, and Alerters to restrict the unwanted data and highlight the required data.
Resolved loops with Aliases and Contexts.
Involved in migrating the reports from Business Objects 5.x to 6.5.
Provided training to end users to use various functionalities of Business Objects
Good knowledge on Migration of business objects universes and Reports using import wizard and report conversation tool.
Exported the Business objects Reports to be webi so that all users can view on the intranet
Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
ENVIRONMENT:
Business Objects 6.5/5, Web Intelligence,Info view, Oracle, and Windows2000/XP.
Project – 2:
Bank One, Chicago, IL May’03 – Oct’04
Business Objects Developer / Reporter
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 Reports accordingly
Involved in designing and building Universes, Classes and objects and defining the necessary connections
Involved in generating reports and resolving issues like, drill through two levels & Pivoted the data.
Reviewed all reports that are operating in the production environment with a goal of improving their efficiency
Exported the universes to the Repository in order to make the resources available to the users.
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.
Environment:
Business Objects 5/6, Web Intelligence, Info view, Oracle, and Windows 2000/XP.
Project -1:
American Modern Insurance Group Cincinnati, OH Nov’ 02 - Apr ‘03
Business Objects Reporter/Developer
Responsibilities-
Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
Designing new Universes and Modifying the existing Universes, using features like Check Integrity, Aliases, Loops, Contexts, Joins and finally creating the Objects (Dimensions, Measures and Details), which are grouped into Classes.
Upgrading and Maintaining Universes and Reports using Business Objects Best Practices in multiple Environments.
Creating and Formatting the Reports as per the Users Requirements using the features in Business Objects like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and Formulae to analyze the data.
Creating and distributing Report Templates to Users. Web-Enabling the Reports using webintelligence.
The main Data Providers for the Report generation in Full Client are Universes / Freehand SQL and Universes for Web Intelligence.
Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End User Notes.
Installing the Business Objects and Creating Repository (Security, Universe and Document Domains).
Managing security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using Supervisor.
Generated Test data for identifying valid data, Invalid data, Partial data &Bad data.
Environment:
Business Objects 5x, Oracle, Manual Testing, Windows.
Project:
ECIL (Electronics co-operation of India Limited) Jan’02 – Sep’02
SCADA systems. HYD – INDIA
Responsibilities:
Monitoring and controlling a complete site of a system
Working with DCS (Distributed control system).with single supplier.
Controlling the site with Programmer Logical Controllers.
EDUCATION:
Pursuing masters in computer science from University Of Northern Virginia, VA.
REFERENCES:
Will be presented upon request.
CERTIFICATION:
Certified in Business objects XIR2 @ GST
Subscribe to:
Posts (Atom)
Posts
