OBJECTIVE:

To seek a challenging career in a professional company wherein my knowledge and skills in data and report design are utilized to the fullest extent and which provides with opportunities to grow with the company

EDUCATION:

Masters of Science
Bachelors of Technology

SKILLS:

Business Intelligence: Business Objects 6.5.1/ XI R2/ XI 3.1 (CMC, CCM, Designer, Infoview, Web Intelligence, Desktop Intelligence, Crystal Reports XI R2, Import Wizard, Live Office), Crystal 9/2008
Languages : C, Data Structures, SQL, PL/SQL
Database : Oracle 8i/9i/11g, DB2 9.0
Operating Systems : Windows 98/2000/XP/7, Windows 2000/2003 server
ERP Tools : SAP BW 6.5
Application : Siebel 7.0, Cicero 5.1/6.2, Quality Center 8.0/9.0/9.2, ScheduALL V4.64
Dataware Housing : DataStage 7.5, Data warehouse concepts, E-R Data model, Dimensional Data Model.
MS Office : MS Word, Excel, PowerPoint

EXPERIENCE:

Confidential,LOS ANGELES, CA, USA NOV. 2007-Till Now
Sr. Business Objects Developer/Consultant
Sony Pictures Entertainment is a entertainment company whose business starts with planning a movie till releasing the movie in theaters and followed by releasing products into market. The vertical which I worked in is Home Entertainment. The main purpose of the Home Entertainment is to get the right information into the product (Blu-ray, DVD, UMD), which is made available in the market for rental or selling purpose to the end customer. The project which I worked is mainly a planning application which requires Reporting Applications to know the deadlines of the work need to be done and what information is required to create a product etc.

• Involved in gathering functional requirements from end users.
• Involved in designing and building Universe from Oracle data source.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the integrity of the Universes.
• Created connections for Universe and exported the universe to the CMS.
• Created Derived tables to handle complex queries and also used @prompts within the query.
• Implemented All prompt in two ways:- 1) by creating an ALL object in the universe and 2) Overriding the SQL in the query panel of the object in the universe.
• Created Cascading prompt which helps the Business users to narrow down the selection criteria.
• Used various @Functions like @Prompt, @Where, @Select, and @Variable.
• Implemented Row level and Object level restrictions for different group requirements.
• Created Equi Joins, Theta Joins, Outer joins, and shortcut joins between tables.
• For creating Outer Joins between tables, ANSI 92 was set to YES.
• Found loops in universe, by setting the cardinalities between tables.
• Created Contexts and Aliases for resolving Loops and checked the Integrity of the Universe.
• Created predefined filters in universe which in turn used in reports.
• Tested objects in the universe by dragging objects into query panel in designer and checked the query generation.
• Optimized the universe by creating shortcut joins, so that the number of tables are reduced which in turn increases the query speed.
• Increased the performance of the universe by setting Array Fetch size in the Universe parameters.
• Implemented Row level & Object level security for different user group requirements.
• Created Web Intelligence reports as per business requirements based on Universe.
• Modified the existing Web Intelligence reports to meet the changing business requirements.
• Fixed the defects reported by Users in Web Intelligence, Desk I and Crystal XIR2 reports.
• Created new reports using Business objects functionalities like Slice and Dice, Sections, Breaks, Formulas etc.
• Used Cross Tab, Vertical and Horizontal tables in creating reports.
• Used Report level filter to restrict the data to that particular report.
• Used multiple data providers and synchronized the data using Merge Dimensions option in generating a Web Intelligence report.
• Created Alerts to highlight the information in different colors based on condition.
• Created union query, which always return nulls, so that “No Data Retrieval” returned message is avoided.
• Created report variables to handle report level calculations.
• Used extended context operators like ForEach, ForAll and In to specify the context.
• Used Userreposponse() function on every report to show the user selected values.
• Implemented report level security by using @variable(‘BOUSER’), so that the user can see only his/her related information in the report.
• Created Adhoc reports for data analysis purpose by users.
• Created Open document syntax to call a detail report from a Summary or Main report.
• Created Open document syntax for several reports and the URL is given to the application developer, so that the report can be called from the application by passing necessary input parameters.
• Experience in creating Metrics and Analytics to create Dashboards for better decision.
• Created metrics, rules and goals and included them in dashboards by using predefined analytic templates.
• Created new Crystal Reports based on Universe and also by writing Free hand SQL.
• Created Sub reports in the crystal reports.
• Used Cross Tabs in creating crystal reports.
• Created parameters and formulas in order to meet the report requirements in crystal reports.
• Written conditions for conditional formatting and suppressed the fields based on conditions in crystal reports.
• Modified and fixed existing Crystal Reports as per business changes and/or defects.
• Inserted Group in crystal reports.
• Used BLOB images and OLE objects in the crystal report.
• Showed HTML information in crystal report.
• Overcame the limitations of HTML in crystal reports like new blank line and bullet points.
• Extensively used Free-Hand SQL to create Web intelligence and Crystal Reports.
• Created functions and packages in PLSQL based on Business needs.
• Created indexes in order to increase the query performance in the report.
• Involved in Production Support.
• Trained end users on how to run reports and use different options within the report like sorting, exporting to PDF or excel, scheduling etc.
• Created a document on how to schedule a report and sent to the users as requested.
• Tested reports before moving to Testing environment, where the report will be tested by the end user.
• Migrated Universe and Reports across the servers/Repositories (Development to Testing and then Testing to Production) using Import Wizard.
• Used Central Management Console to assign users to different groups for security reasons.
• Involved in testing team for testing Business Objects Upgrade from UNIX platform to Windows Platform.
• Involved in taking Knowledge Transition for multiple applications.
• Created and enhanced crystal 9 reports for ScheduALL application, which is a vendor application.
• Created Operational Process Document for the applications which I involved in Knowledge Transition.
• Working closely with Performance Engineering team to improve the performance off Universe and Reports.

Environment: Business Objects XIR2/ XI 3.1 (CMC, Designer, Desktop Intelligence, Infoview, Import Wizard, Crystal Reports XIR2, Dashboard Manager, Performance Manager), Crystal 9, DataStage 7.5, Oracle 9i/11g, PL/SQL Developer, TOAD, Quality Center 9.0/9.2, ScheduALL, Windows 2003 Server.

Confidential,COLUMBUS, OHIO, USA MAY 2005-OCT 2007
Business Objects Developer
(Registered in Curriculum Practical Training (CPT, means to work officially in a company) in Illinois Institute Of Technology, Chicago)
Nationwide Financials is one of the biggest companies in USA with wide range of business areas. The project which I worked involved creation of report is for Policy Selling division of Nationwide Financials.

• Meeting with end users & Business Users of different departments to meet their requirements in reporting.
• Involved in setting privileges to various user groups coordinated with supervisor using Supervisor Module.
• Involved in the designing and Building of Universes using Oracle as data source.
• Created classes and objects and gave business names and logically grouped them together.
• Linked Universes to share the Universes which had common dimension tables, classes and objects.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Used different @Functions like @Prompt, @Select, and @Where.
• Create custom LOVs(List of Values) and custom Hierarchies for drilling down to lower levels in the reports.
• Created Derived Tables to handle complex queries.
• Applied row level and object level securities to different groups and users using Designer.
• Responsible for designing the reports according to client requirements.
• Created the reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula etc.
• Used multiple data providers such as Universe and free hand SQL in generating report.
• Responsible for developing all types of reports including Cross-tab reports using Crystal Reports 9.
• Involved in production Support and gave training to the users.
• Created full client and WebI reports. Modified the existing reports by adding new columns based on requirement.
• Involved in Migration of Business Objects system from version 6.5.1 to Business Objects XIR2.
• Responsible for migration of Users, Universes, Connections, Full Client / Web I Reports from the existing version 6.5.1 to XIR2.
• Involved in testing Universes and Reports throughout the migration process.
• Used Report Conversion tool to convert the Desk I documents into Web Intelligence documents.
• Created new users in XI R2 using Central Management Console and set restrictions, assign privileges based on their profiles.
• Created Web I reports with more than 10 data providers and synchronized the data using the merge dimensions option.

Environment: Business Objects 6.5/XIR2 (CMC, Designer, Infoview, Import Wizard, Crystal Reports XIR2), Oracle 9i, Crystal 9, Cicero 5.1/6.1, Siebel 7, TOAD, Quality Center 8.0, Windows 2000 Server.

PROJECTS:

Agile Manufacturing, Illinois Institute of Technology, Chicago Aug’06-Dec’06

• This project gives the complete information about agile manufacturing including, definition, commercial applications, pros & cons, etc.

Performance Test on GE MS9001E gas turbine for DLN-1 Nozzle, Bharat Heavy Electricals Limited (BHEL), Hyderabad, INDIA. Nov’03-March’04

• Conducted experiments using DLN-1 nozzle in GE MS9001E gas turbine to reduce poisonous gases like NOx when compared to conventional nozzle used in gas turbine.

Conservation of Energy in Manufacturing, Indian Institute of Foundrymen (IIF), Hyderabad. May’04-June’04

• Researched energy usage and prepared a report on ways to use energy efficiently at over 40 companies

Thermal Power Plant Model, SreeNidhi Institute of Science & Technology June’02-July-02

• Designed a model to show how different components in a thermal power plant work to produce electricity.
• Awarded second prize for this project.