PROFESSIONAL SUMMARY:

• Successfully working on the challenges in IT for over 7 years in SAP Business Intelligence Reporting and Data ware housing.
• Around 7 years of experience in developing Business Objects XI R3/R2/6i/5i Reports, Crystal Reports 2008/XI and Crystal Xcelsius 2008/4.5 reports.
• Expertise in Business Objects Tools WEBI-Web-Intelligence XI/6.0/2.7x, Desktop Intelligence, Universe Designer and maintaining Securities using CMC/Supervisor.
• Experienced in various streamsof complete Software Development Life Cycle (SDLC) such as Requirement Gathering, Designing, Development, Testing, Migrating, Security Management and Production on various platforms like Windows NT/2000/XP/98, UNIX and Linux.
• Experience in Project Planning decisions with Managers, Business Analysts and Team members to analyze the business process and requirements to meet the purpose of the project.
• Diversified experience in various Business domains like Finance, Insurance, Pharmaceuticals, Retail, Human Resources, Manufacturing & Sales.
• Strong Knowledge in BO Administration and Troubleshooting.
• Experience inBusinessObjectsXI R2/R3 CMC, Administration including not limited to installing and AdministeringBusinessObjectsservers, Configuration, Performance tuning and Optimization of Servers, users, folder, connections and security setup.
• Ability to understand Business & Technical Requirement and to liaise with business users / Business analysts and understand functional specifications and business requirements Documents.
• Experienced in designing and developing the Universe according to user requirements for developing Canned/Ad-hoc reports.
• Expert in Conversion of Desktop Intelligence Reports to Web Intelligence Reports.
• Strong knowledge on Data warehousing concepts, Data mart, Star Schema and Snow Flake Schema modeling, ETL, Fact tables and Dimensional tables.
• Extensive experience inPL/SQL SQL & T-SQL.
• Proven career in Business Intelligence for Designing of Universes on RDBS and developing Reports on diversified Databases.
• Experience with Integration of Business Objects with SAP BW.
• Proven potential in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Expertise in Business Objects Reporting functionalities such as filters, ranking, breaks, sorts, sections/master detail reports, slice & dice, drilling methodologies cross tabs and charts.
• Worked with Crystal Reports for creating complicated reports including parameter based reports, graphical reports, sub-reports, formula based well-formatted reports, analysis reports and data reports along with LOV.
• Experience with SQL tuning & SQL optimization to maximize query performance.
• Experienced in upgrading of Business Intelligence Reports from Business Objects 6.5 to XI R2/R3 Architecture.
• Experience in Migration of Universes and Reports by using Import Wizard from Development to Testing and then to Production environment.
• Experience in writing test scripts and technical specification documents for User Acceptance Testing (UTA).
• Excellent skills to develop User Training Manuals.
• Provided End Users Training to Corporate customers to effectively use the business Objects product functionalities for optimal output.
• Excellent inter-personal and communication skills.
• Well organized team player with the ability to work independently.

TECHNICAL SKILLS:

• Reporting: Tools: Business Objects XI R3/R2/6.5/5.x/4.x, Xcelsius 2008/4.5, Crystal Reports 2008/XI/10/9/8, Web-Intelligence 6.5/2.x, SQL Server Reporting Services, CMC/Supervisor, Performance Management, Board cast agent etc.
• ETL Tools: Informatica Power Center 6.2, 7.1, Bo Integrator
• Operating Systems: Windows 2003/XP/00/98/95/NT, MS DOS, UNIX.
• DBMS: ORACLE 10g/9i/8i, MS SQL Server 2005/2000 and MS- ACCESS 2000, Tera Data, DB2.
• Data Modeling: ERWIN 6.1/4.5/3.5,MS Visio, DB Designer.
• GUI Tools: SAP, Visual Basic 6.0, JSP, ASP, SQL Navigator, Toad.
• Languages: C, C++, HTML, SQL, PL/SQL, T-SQL.

EDUCATION:

• Bachelor’s of Engineering.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH November 09 – Present
Role: Sr. Business Objects Consultant

Description:
Confidential has offices throughout the US. The company is a leading US property/casualty insurer that also provides life insurance and retirement products through its Confidential Financial Services Subsidiaries. The project was developed for the Equities and Insurance division. The project was to design Universes and deploy concerned reports using Business Objects XIR2 and upgrade reports using Business Objects XIR3.

Responsibilities:

• Worked with the end users and higher management to gather requirements for Business requirement and Business Intelligence reports.
• Demonstrated numerous demos to business owner and user community to have a strong understanding about Business Objects application that we developed and the product features.
• Finalized Schemas according to the requirement needed having numerous meeting with ETL Developers.
• Built new universes as per the user requirements by identifying the required tables from different Data marts.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in the Universe design.
• Created hierarchies and customized LOV’s at universe level for the end-user.
• Interacted with universe users and support regularly to generate the required reports and to solve and existing issues.
• Worked with @functions like @prompt, @variable, @select and @where functionalities.
• Applied restrictions on the connections at the universe level so that user can have access to particular Ad group.
• Used aggregate tables, Index Awareness concept to increase Query performances.
• Implemented Security features of Business Objects like row level, object level and report level to make the data secure.
• Involved in integrated testing and user acceptance testing.
• Involved in creating test plans and test scripts for reports testing and test run in Quality Center.
• Expertise in Business Objects Reporting and analysis functionalities such as Filters, Ranking, Breaks, Sections/Sorts, Master Detail Reports, Slice & Dice, Drilling methodologies, Cross Tabs and Charts using list of values (LOV).
• Converted existing Desktop Intelligence Report to Web Intelligence using report conversion tool.
• Created reports like periodic reports, demographic reports and comparative reports.
• Created complex reports using cascading and user objects like measure objects by using aggregate aware functions to create summarized reports.
• Imported/Exported the universes from/to repository to make them accessible to end users.
• Used info view to view, schedule, and keep track of published reports.
• Provided the security access management by creating users/groups and folders.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.
• Experienced in developing Dashboards and promoting the benefits of dashboards to the end users.
• Created monthly and summary dashboards reports for the different domains like membership, contracts, claims payable details etc.
• Responsible for integrated testing and user acceptance testing of Dashboards.
• Involved in creating test plans and test scripts for Dashboards reports testing and test run in Quality Center.
• Responsible for Maintaining the user securities access for the end users from different groups of business and maintained access restrictions for the simple users and power users for other BI Resources.
• Experienced in reviewing reports and presenting to end users and making modifications if required based on user requirements.
• Conducted user training sessions and supported them with their requests for enhancements, modifications and new adhoc reports.
• Used SQL, PL/SQL to maintain the data for reports and validation of the reports.
• Interacted with all the team members to efficiently incorporate development results.
• Provided End Users Training to Corporate customers to effectively use the business Objects product functionalities for optimal output.

Environment: Business Objects Enterprise XIR3/XIR2, Desktop Intelligence, Web Intelligence, Designer, Crystal Enterprise XI, Info View, CMC, CMS, Informatica 8.1, Oracle 10g/11g, SQL Server 2008, MS Access, Windows 2000.

Description:
Confidential is Japan’s second largest pharmaceutical company and ranked within the top 20 in the global market. Confidential is located in Deerfield, Illinois, and is the company\'s North American headquarters.Project involves the design, development and Standardization of Reports to enable business analysts to improve the performance reporting system.

Responsibilities:

• Experience in all the phases of Software Development Life Cycle such as strategy and analyzing, designing, testing and documentation of software products.
• Gathering, designing, and analyzing user reports requirements, meeting business heads for gathering user requirements.
• Designed Universes to support canned and Adhoc Business Intelligence Reports.
• Created Objects and Classes for developing the Intelligence Reports.
• Created user Prompts, conditions, and filters for various reports to specify the reporting parameters to achieve business requirements.
• Developed Hierarchies to support drill down reports.
• Expertise in Business Objects Reporting functionalities such as filters, ranking, breaks, sorts, sections/master detail reports, slice & dice, drilling methodologies, cross tabs and charts.
• Worked on Migration and played a key role in Migration of Business Objects from version 6.5 to XI R2/R3.
• Worked in Setting up groups and users for Business Objects deployment and managed user’s profiles.
• Used Crystal Management Console/Seagate Info to perform administrative tasks related to user groups, accounts, report publishing, folder management etc.
• Deployed reports on the web using Crystal Publishing Wizard and scheduled reports using web desktop and Management Console.
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc by using Chart expert of Crystal Reports.
• Developed various database objects like Tables, Views and Stored Procedures by using SQL*Plus, PL/SQL in Oracle.
• Built dynamic dashboards with live data connecting to CX Drill-Down Universe using QaaWS and Live Office.
• Worked on SQL performance tuning to fix slow running reports.
• Extensively work on scheduling and distributing the documents.
• Provided full support to the end user in production issues.

Environment: Business Objects XI R2/R3, 6.5.1 Suite (Desktop Intelligence, Central Management Server, Central Management Console, Import Wizard), Informatica 8.1, Live Office, QaaWS 3.0, Crystal Xcelsius 4.5/2008, Crystal Reports ,Supervisor, Designer, Reporter, WebI, MS-Visio, Oracle 9i/10g, SQL*Plus, Pro*C, PL/SQL TOAD, MS Access 2000, Sybase, SQL Server 2005, Windows 2003 server/XP.

Confidential, Houston-Katy, Texas February 07 – April 08
Business Objects /Universe Designer

Description: Confidential a unique deep-discount retailer of primarily name-brand consumable general merchandise. It is headquartered in city of commerce, CA. I worked as a Business Objects/Crystal reports developer and created business objects reports for the sales and marketing team in Texas branch office.

Responsibilities:

• Developed, formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping using business objects reports.
• Maintained Universes for supporting Ad hoc and canned reports.
• Worked on building Universes from Sybase database.
• Created filters (condition objects) to improve the report generation.
• Implemented solutions for complex queries, sub-queries, and Aggregate functions for reports.
• Set object level security, row level and command level restrictions using Supervisor to restrict sensitive client information to relevant departments.
• Designed universes in BO Designer by retrieving data from database, defining the necessary connections and exported them to specific universe domains.
• Implemented various types of joins including equi-join, outer-join, theta-join, defined cardinalities and resolved issues like loops by creating aliases and contexts to remove the cyclic dependencies.
• Developed Cross Tab Reports and Sub Reports by using Crystal Reports.
• Worked on Sub Totals, Running Totals according to report requirements.
• Converted existing Desktop Intelligence Report to Web Intelligence using report conversion tool.
• Created different reports, and made modifications in the system as per user’s requirement.
• Developed various reports based on Multiple Parameters and Prepared Test Plans and Test Cases for all the Reports and documented the Results.
• Implemented import wizard & publishing wizard for migration of reports & universes.
• Instrumental in Starting the Dashboard Reporting structure to visualize Key performance indicator (KPI’S).
• Created Metrics, Scorecards and Speedometer reports.
• Designed Crystal Reports with dynamic content & Custom UI.
• Scheduled Crystal Reports and Implemented dynamic cascading prompts.

Environment: BO6i/XI, BO Designer, CMC, Crystal Reports 10, Crystal Xcelsius 4.5, Web Intelligence, Desktop Intelligence, Sybase, Tera data, Tomcat Server, Excel2007, MsAccess2007.

Confidential, Seattle, WA July 05 – January 07
Business Objects /Crystal Reports Developer

Description:
Confidential is one of the largest Health Care providers in Washington State in the United States. This Project deals with Health Physics Society (HPS) & Service Planning Area (SPA) Applications of GHC. The objective of this project is to provide complete prospects and renewal health policies information of HPS & SPA in form of ad hoc reports. These two applications include developing universe and reports for contracts, renewals, marketing and underwriter process associates in HPS & SPA Applications. It also involves the enhancements for existing reports in SPA. Reports are developed in Business Objects 6.5 for renewals of existing policies, for prospects and for Group Profiles.

Responsibilities:

• Participated in requirement gathering, analysis and structuring of Business Intelligence objects reports based on user requirements.
• Involved in the creation of various report formats including Master/Detail Reports, Sub Reports and Cross Tab Reports and published them via the Crystal Enterprise.
• Created Crystal reports with cascaded multiple prompts.
• Managed Users (using CMC created user and assign the different level of access, delete user). Also created folders and provided access to different users.
• Created folder and subfolders for different categories such as Sales & Marketing, Contracts, Membership, Underwriting, Claims of reports and which helped in providing access to the users.
• Created hierarchies from providing drill down options for the end-users.
• Created context, alias to resolve the loops in the universe.
• Modifying the existing universes, adding new objects editing joins, mapping the existing objects with renamed tables
• Created monthly and summary reports for the different domains like membership, contracts, claims payable details etc.
• Created number of formulae, conditional display of fields for complex calculations and used them in different sub reports.
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc.
• Involved in integrated testing and user acceptance testing.
• Involved in creating test plans and test scripts for reports testing and test run in Quality Center.
• Worked on performance tuning of universe and reports.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.

Environment: Business Objects 6.5 (Supervisor, BCA, Data Integrator, Web Intelligence, Designer), Informatica, Toad, Oracle 9i & Windows 2003 Server.

Confidential March 04 - June 05
Jr. Business Objects Developer

Description:
Confidential is leading global online travel company. The project was built in New York by Deloitte. I was part of the off shore team in India. I worked as a Crystal Report/Business Objects developer and created business Intelligence Reports for the sales, marketing and seasonal Demand.

Responsibilities:

• Developed universe using designer module in Business Objects.
• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
• Created hierarchy and conditions at the designer level.
• Created complex reports by linking data from multiple sources, using functionalities like Slice and Dice, Drill Down, Master Detail, etc.
• Used different data providers in a single report and implemented synchronization.
• Created hierarchies from providing drill down options for the end-user.
• Created daily, weekly, monthly and quarterly reports for the management team and field operation managers using Business Objects reports.
• Creation of different types of reports such as master/detail, cross tab and chart for trend analysis. Used filters, conditions, calculations in the reports created.
• Used Crystal Reports for developing reports directly on SQL server tables using cascading prompts and sub reports.

Environment: Crystal Reports 8, Business Objects 5.1.7, Designer, Reporter, BCA, Informatica, SQL Server 2000, & Windows NT