Summary:

• More than 10 years of IT experience, easily adapts to various environments and very effective communication and interpersonal skills.
• Over 9 years of experience in Crystal Enterprise XI/10/9.0, Business Objects 3.1, XI R2/6.x/5.1, Business Objects Designer, Reporter, Supervisor, Infoview, and Web-Intelligence XI R2.
• Well versed in Business Objects (XI, 6x and backwards) with experience in Supervisor, Designer, BCA Server (Publisher and Scheduler), Web Intelligence 2.5/2.6.1/6.0, Infoview, Crystal Enterprise 10/XIR2, Performance Management, Dashboards, Auditor and Schema Design.
• Extensive experience in developing Complex Reports using Sub-Reports and Cross Tab Reports and Dash Board Reports using Crystal Reports
• Good knowledge of security structure (open system and closed system) Business Objects XI/XI R2 version.
• Working and designing reports on XI R2
• Creating Business view manager and Universe on XIR2
• Working on web report and Desktop Intelligence for XI R2/R3.
• Worked on Web Intelligence to develop and publish thin client reports.
• Good knowledge in creation of Dashboard and WEBI reports.
• Created Dashboards to monitor business performance, insightful analytics, role based dashboards.
• 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.
• Good knowledge and experience in using Oracle 9i/8i, MS SQL Server 2000, Teradata and Enterprise manager, Query analyzer.
• Knowledge in building, Extraction, Transformation and Loading (ETL) Informatica and Data Stage.
• Experience in installation, administration and upgrading versions of BO both desktop and server products on both Windows and UNIX environments.
• Created Graphical and Statistical reports of different Natures and Types.
• Experience in upgrading from version 5.X to 6.X and also proficient with the features of Business Objects 6.5, XI.
• Excellent knowledge in migration of Business Objects 6.X to XI R2.
• Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and free hand SQL.
• Good knowledge of SAP workflow Integration with BO XI R2

PROFESSIONAL EXPERIENCE

Confidential,CT Mar 09 - Current
Architect/ Sr. Business Objects Developer

Responsibilities:

• Responsible for Maintenance & Support of System reports and Universe.
• Colleting Requirements from the IVR team, Analyzing, Documenting, Building, exporting Universe to Repository, building OLAP and Crystal reports in Info view and testing reports.
• Responsible for the data quality in System reports.
• Worked as an architect, define universe, ETL tools and Flow of data from database to BO universe
• Plan Implement and develop BO/ universe (3.1)
• Scheduling the reports through CMC, Monitoring and Converting Reports to PDF.
• Working knowledge on Linux OS, Developed reports on Linux OS
• Working knowledge on Java/J2EE,EJB, JavaScript and Struts
• Installed and configured Oracle & Business Objects Products for IVR report users.
• Created different types of reports like Master/Detail, Cross Tab and Chart Using WEBI XI and Crystal Reports XI. Used Slice and Dice and Drill down. As a part of report development created the reports using universes as a main data provider and using the Powerful business objects functionality\'s like @ functions, user response and formulae\'s.
• Experienced in Migrating from Windows to Linux OS and from BO XI R2 to BO 3.1
• Used Prompts in reports to create more interactive reports for the Users.
• Established user groups and users and assigned privileges.
• Tuning of universe, created views to tune up reports and universe.
• Production Support and gave training to the Users on how to generate the reports using WEBI XI and Crystals Reports XI.
• Train users to use the tool and create Ad-hoc business objects reports (With my own documentation)
  Involved in the complete Data Warehouse design process.
• Wrote PL/SQL, store procedure, View for tuning of Universe and Reports

Environment : BO XI 3.1 (Designer, Web Intelligence, Info view, Import Wizard, Report Conversion Tool, CMC), Crystal Reports XI, 4.5, Oracle 10g ,Unix/Linux,J2EE,Siebel 8.0,Agile Methodology,Websphere,EJB.

Confidential, Jun 08 - Feb 09
Desk I Report Developer

Responsibilities:
Financial Reporting/Wealth Management

• Designed Reports with formulas, Grouping, Parameters, Selection criteria to handle the report requests.
• Created different types of Reports including the Cross-tab, Conditional, Top and Drill-down.
• Worked with Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV Business Objects
• Lead a team of 4 members, for the up-gradation and maintenance of universe
• Analyze the reporting requirements with the business users in JAD sessions and come up with the technical specifications for the BO Reports
• Generating the Standards and templates for the reports and the universes
• Creating, maintaining and modifying the universes using Business Objects designer
• Solved Universe problems (Loops, Fan and Chasm Traps)
• Creating, maintaining and modifying the business critical reports using the Desktop Intelligence(DeskI) and Web Intelligence(WebI)
• Develop reports based on the subject area, using Universes as the main Data providers.
• Designed DeskI Reports with formulas,Grouping, Parameters, Selection criteria to handle the report requests.
• Created different types of DeskI Reports including the Cross-tab, Conditional, Top and Drill-down.
• Worked with DeskI Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice (Sizing), Drill Down, Cross Tab and Master Detail.
• Created trend reports with charts and drill down on charts.
• Providing Users Support to create ad-hoc reports on Webi.
• Involved in performance tuning of Business Objects Report which are running significantly slower
• Solved many Universe problems (Loops, Fan and Chasm Traps)
• Create, deploy, and manage reports for Fannie Mae, features that enable you to extend and customize functionality.
• Used IBM Data Stage as ETL tool on Linux system.

Environment : BO XIR2 (Designer, Desktop Intelligence, Info view, Import Wizard, Report Conversion Tool, CMC, Dashboard Manager), Crystal Reports XI, Xcelsius 4.5, Oracle 10g ,Unix/Linux,J2EE,Siebel 8.0,Agile Methodology, IBM Data Stage.

Confidential, Dec 07 - May08
Sr. Crystal Report Developer
Confidential,of America, Hartford, CT (Phoenix) is the fourth largest mutual life insurance company in the United States, Phoenix Life Insurance and its subsidiaries provide almost three million people with life and disability income insurance, retirement services and investment products. The company also supplies employee benefits programs to five million participants, including life, health and dental insurance, as well as qualified pension plans. The project involved supporting the existing infrastructure and developing new Crystal reports as well as Webi & Deski reports.

• Design complex Web Intelligence and Desktop Intelligence Reports with cascading prompts.
• Involved in creating and managing users, groups, folders and published reports using crystal management console, exporting and scheduling of reports using Crystal Enterprise and generated WEB Reports by Info view.
• Designed reports according to the specifications using DeskI Reports XIR2/R3 for New Business Discounting, Group Sales Reporting, Concur Disbursement, Regional Closings etc applications
• Created parameterized DeskI reports and customized existing reports for presentations using Cross-Tab reports, Sub-reports, Visual Basic syntax to create formulas for the reports
• Extensively involved in creating parameters and record selection formulas to allow the users to filter the data
• Lead a team of 5 members
• Extensively involved in writing various formulas for Calculations and combining the Data.
• Involved in writing Custom Functions to be used in other Functions.
• Created formulas using Crystal and basic syntax.
• Trained the end users in working with the DeskI Reports user module and provided technical expertise.
• Ran queries using Toad for analyzing data for different reports.
• Worked on the SQL tuning and optimization of the Crystal reports.
• Responsible for creating requirement specification documents for reports on ‘Optimal Business Process’ application.
• To analyze the security needs both from a resource and application data standpoints
• Created and modified the designing and building dashboard reports using Xcelsius for various financial groups using the Universe as a main data provider
• Assess current environment BO XIR2 environments to analyze the security requirements. Also perform needed analysis on BO XI R2 environment

Environment: Business objects 6.2, XIR2, Crystal Enterprise XI R2/R3, Oracle 10g/Teradata, SQL Server 2000, IBM DB2 8.1, Teradata V2R5, Toad, UNIX, .net.

Confidential,FL Jan 07 - Nov 07
Sales Tracking System
Business Objects Developer

Project Description:
Confidential,is a one of the big organization for FMCG in the world. The main objective of this project is to analyze the sales data for their products and customers. Project is Creating and maintaining POS Sales and J& J BI Universes, Reports for Sales and Distribution, Implemented the Dimension and Cell level security to the Universe. After thoroughly testing the Universes developed Reports using Business Objects Tool.

Responsibilities:

• Analyze the reporting requirements with the business users and come up with the technical specifications for the BO Reports
• Generating the Standards and templates for the reports and the universes
• Creating, maintaining and modifying the universes using Business Objects designer
• Integrated BO Universe with SAP Data Source using Data Integrator.
• Developed Deski and Webi reports extracting data from FI/CO and CO-PA module of SAP to track profitability.
• Developed Crystal reports for SCM and Consumer Packaged Goods (CPG).
• Solved Universe problems (Loops, Fan and Chasm Traps)
• Creating, maintaining and modifying the business critical reports using the Desktop Intelligence
• Develop reports based on the subject area, using Universes as the main Data providers.
• Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice (Sizing), Drill Down, Cross Tab and Master Detail.
• Created trend reports with charts and drill down on charts.
• Providing Users Support to create ad-hoc reports on Webi and Excel (using Live Office)
• Data Stage to migrate data for reporting purpose.
• Involved in performance tuning of Business Objects Report which are running significantly slower
• Designed WebI Reports with formulas, Grouping, Parameters, Selection criteria to handle the report requests
• Created different types of WebI Reports including the Cross-tab, Conditional, Top and Drill-down.
• Developed User Interface Forms in Business Objects using Visual Basic Macros (BOSDK).
• Involved in migrating universes and reports from BO6.5 to XI R2.
• Documenting the entire effort. The documents generated during the process were Requirements Specifications, Design Document, Project Planning, Change History, Unit testing documents, and System testing documents.

Confidential,IL Feb 06 - Dec 06
Financial Reporter
Business Objects Developer

Responsibilities:

• Analyze the reporting requirements with the business users and the QA team and come up with the

technical specifications for the BO Reports

• Generating the Standards and templates for the reports, interfaces and the universes
• Creating, maintaining and modifying the universes using Business Objects designer.
• Also created linked Universes and universes using multiple databases/data providers.
• Solved many Universe problems (Loops, Fan and Chasm Traps)
• Published Crystal Reports on Crystal Enterprise - Portal, the Intranet Web and tested their performance which helped the end users to view them in HTML/Acrobat/Excel/Word Document formats.
• Worked with Crystal Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• Creating, maintaining and modifying the business critical reports using the Desktop Intelligence
• Develop reports based on the subject area, using Universes as the main Data providers and develop some reports using Excel (.xls), Access, and Dbase file (.dbf) as a data provider.
• Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice (Sizing), Drill Down, Cross Tab and Master Detail.
• Created trend reports with charts and drill down on charts.
• Customer Intelligence Dashboard provided trending, alerting and forecasting of Sales Metrics by Product Analysis, Region Analysis , Customer Analysis and Organizational Analysis
• Performed both Unit and System integration testing of the Data marts.
• Involved in performing the tuning of Business Objects Report which are running significantly slower
• Maintained the Supervisor module in the absence of the lead.
• Gave training sessions for the users. Trained how to create Webi reports using Info view (Java Report Panel) and also trained the users on using the Alerter, Prompts, etc.
• Used Application Foundation to build the dashboards for the Business users and placed on the Intranet.
• Scheduled reports using BCA to distribute the reports via server, scheduled some reports using SQL Scheduler.
• Used to receive the requests from the user through the Test Director. This tool was also used as the knowledge base.

Migration Responsibilities:

• Used Import Wizard for the Migration process. Migrated users, universes, reports, securities etc from 6.5 to XIR2.
• We follow different procedures to migrate linked universes
• Upgrade the database from SQL Server 2000 to SQL Server 2005
• Changed the universe connection from ODBC to OLE DB
• Used Report Conversion Tool to convert the Deski reports into Webi and maintained the folders in the Info view.
• After the migration, ran the check integrity for all the universes and fix divergences
• Reformatted most of the Webi reports as all Deski features are not supported by Webi
• Worked with CMC when migrated from 6.5 to XIR2.
• Used Data Stage as ETL tool to migrate data.

Environment : BO 6.5 (Designer, Business Objects, Supervisor, BCA), XIR2 (Designer, Desktop Intelligence, Info view, Import Wizard, Report Conversion Tool, CMC, Dashboard Manager), Crystal Enterprise 10.0, Xcelsius 4.5, SQL Server 2000, SQL server 2005, Unix, Data Stage.

Confidential,NJ Sep 05 - Jan 06
AC System
Business Objects Developer
The project is development of Universes and Reports for Financial Reporter for UBS. The requirement is to gathering the data and reporting requirements of the Corporate Representative Team, which is currently being handled by Brio.

Responsibilities:

• Performing an initial study on the reporting needs by meeting the Representatives.
• Analyze the reporting requirements with the business users and come up with the technical specifications. This includes the documents for getting the data from the SAP and also the technical specifications for the Business Objects Reports
• Generating the Standards and templates for the reports, interfaces and the universes.
• Involved in creating the Universes for five different representatives like RIM, Telephony, Quality Assurance, Processing and Application Administrators.
• Involved in identifying the canned reports for each of the universes and creating the specifications for the same.
• Involved in creating the business critical reports for Processing Reps, Application Reps and RIM Reps
• Creating, maintaining and modifying the business critical reports using the Business Objects Reporting Module.
• Constructed simple to complex reports which involved the usage of sub queries and correlated sub queries in conjunction with @functions and functions that would generate complex calculations, as well as format the report.
• Created multi master-detailed reports together with the usage of slice-and-dice and drill modes for multi-dimensional analysis of the data retrieved.
• Involved in Analysis, Development, Testing, and Maintenance and Resolved problems during implementation.
• Resolved most of the issues within universes that had loops embedded among the tables using aliases and contexts.
• Providing user support and training in using Report Designer for creating Adhoc reports.

Environment: Business Objects 5.1, Oracle 8.1.6, Webi 2.5,Unix

Confidential,India Jan 05 - Sep 05
Migration of Universes & Reports
Sr Business Objects Developer
The project involved in developing the Universes for the business and also generating the reports. I was also extensively working in developing the reports for Sales and Investment Management division.We had 3 different environments (Development, Quality Assurance, and Production). Ultimate aim of this project is to provide Business users and customers’ reference data for sales and investment divisions.
My role in the project is to identify and analyze the Business Requirement and modify the existing universes that would be used for adhoc-reporting. The role involved developing, maintaining, creating, and migrating the universes and reports for Business Users, Portfolio Management, Sales, and Customers.

Responsibilities:

• Analyzed the requirement and transformed into technical aspects.
• As a part of Universe designer team, created Semantic Layer, went through the two different levels of Database.
• Resolved loops, chasm and fan traps using contexts, aliases and integrity checks
• Created Classes and Objects taking the information from the database. Also created measured objects. Checked the Cardinalities, Contexts, Joins and Aliases for resolving Loops and Integrity of the Universes.
• Exported the universes to the Repository to make the resources available to the users.
• Published the Full client reports to the corporate documents for the users to view them in Infoview.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae’s etc.
• Exporting the Reports to the Broadcast Agent and Used the Broadcast Agent to Schedule, Monitor and Refresh the Reports.
• Involved in production Support and also trained the users

Environment: Oracle 8i, MS Access, Business Objects 6, SQL, Windows NT, Web Intelligence 6.0, Broadcast Agent

Business Intelligence: Business Objects XI R2/R3 Central Management
Console (CMC), Designer, Infoview, Desktop Intelligence, Business Objects 6.x Suite Supervisor, Web Intelligence, Import Wizard, Data Modeling Erwin 3.5.2, Crystal Reports XI/10/9.0, Crystal Xcelsius 4.5, Performance Management, ZABO.
RDBMS: Oracle 9i/10g, SQL Server 2000/2005, Teradata,MS Access,Datastage.
Operating Systems: Sun Solaris, Linux 6.2/7.0,Windows 2003/ 2000/ 95/ 98/ XP, IBM AIX, Windows NT 4.0, MS DOS.
Server Environment: IIS 5, Web Logic 8, Apache 2.x,1.x, and Tomcat 4.0x/4.1x.
Languages: C#, JSP, VB6, SQL, PL/SQL,Java J2EE.
Application Software: Adobe Works, MS-Office Suite.
Data Modeling: Star Schema, Snowflakes
Web Technologies: HTML, DHTML, PHP, Perl, AJAX, CSS, VB-Script.
Front End Tools: TOAD, SQL Navigator.
Scripting Languages: UNIX Shell Scripting
ETL Tool: Informatica 7.1,Data Stage.