Professional Summary

• 6 years of IT experience specialized in Business Objects XI R2/3.1/4.0, SQL Server 2008, SAP BO BW Integration, Xcelsius 2008, Crystal Reports 2008, Business Intelligence, Data Warehousing, RDBMS (Database), Oracle 9i/10g/11g, Mainframe technologies, MS Office 2007 Suite (Excel, Access).
• Well versed in Business Objects XI3.1 with experience in Universe Designer, Desktop Intelligence XI, Info View, Web Intelligence XI, CMC, Import Wizard, and Publishing Wizard.
• Hands on experience on new SAP Business Objects 4.0 client tools like Information Design Tool, Dashboard Design, BI Launch Pad, Crystal Reports Enterprise etc.
• Created many universes/reports using the SAP BO BW Integration Kit.
• Proficient Knowledge of Business Objects XI 3.1/4.0 Architecture and new features.
• Experience with 2 complete Business Objects life cycle implementations.
• Created Web Intelligence reports (created using SAP BO 4.0) to view them on mobile devices like Apple iPad/iPhone.
• Administration of user rights for Business Objects XI R2/3.1.
• Good experience in Building Universes using various sources like RDBMS, SAP BW Cubes/Queries, Personal data files and Stored Procedures.
• Extensively worked on creating complex, multi-dimensional and ad-Hoc reports using Business Objects Web Intelligence (WEBI) and Desktop Intelligence (DESKI).
• Experience in using other Business Objects tools like Live Office, QaaWS etc.
• Built Dashboards using Xcelsius 2008 to create interactive dashboards used by senior executives.
• Well experienced in writing Complex queries, stored procedures and functions using SQL/PLSQL Programming.
• In-depth understanding of Relational Database Management Systems (RDBMS) and Dimensional Modelling concepts.
• Strong Knowledge of databases like Oracle 11g/10g/9i, IBM DB2, MS Access etc.
• Experience in preparing Business Requirement Documents (BDRs), QA Test Plans, QA Analysis Documents.
• Good knowledge and exposure in Automotive Sector with well attained domain expertise in ordering and logistics arm of automotive sector.
• Knowledge of Healthcare, Semiconductor and Retail domains.
• Ability to work without supervision and meet deadlines, effective problem solving and analytical skills.
• Excellent interpersonal, communication and presentation skills.

Education

Technical Details

• Operating Systems: Windows XP/7, Windows Server 2000/2003, IBM Mainframes (Z/OS,)
• Language: SQL, PLSQL, C, Natural, COBOL and JCL
• Database: Oracle 11g/10g/9i, MS Access, SQL Server 2008, ADABAS and DB2
• Tools & Utilities: MS Office 2007 Suite (Excel, Access), TOAD for Oracle, MS SharePoint, PEEK, Natural Debugger, N2O, Predict and Profiler.
• BI Tools: Business Objects XI R2/XI 3.1/4.0 (CMC, CCM, Designer, Desktop Intelligence, Import Wizard, Publishing Wizard, Web Intelligence), SAP BO BW Integration Kit, LiveOffice, Xcelsius, Information Design Tool, Crystal Reports 2008, QaaWS, SAP Business Objects Mobile App for iOS devices.

Professional Experience

• Actively interacted and scheduled meetings with the business users to gather the reporting requirements and developed design documents.
• Designed security model of reporting system, creating groups, folders, and users in Business Objects.
• Helped Business Objects administrator create users, groups, folders, categories etc.
• Responsible for creation of several WebI Reports, DeskI reports based on Order Entry and Inventory Modules.
• Responsible for creation of publications which burst reports to various regional managers.
• Created several live dashboards using the LiveOffice and QaaWS connections.
• Worked extensively on SQL Server and Oracle databases.
• Created new and modified existingHierarchiesin the universes to meetDrill Analysisof the user's reporting needs.
• Created Crystal Reports by using the direct connectivity options and by using universe.
• Developed Cross Tab Reports, Sub Reports by using Crystal Reports 2008.
• Involved inperformance tuningandoptimizationon Business objects Universes by creatingAggregate tables and using Aggregate Aware function in Universe.
• Involved in the POC of SAP Business Objects 4.0 reporting environment. Helped the core BI team in the upgrade from BOXI 3.1 to BO 4.0.
• Actively involved in improving query performance by Identifying long running queries.
• Extensively used the Input Controls feature in the Web Intelligence to make the reports more user friendly and interactive.
• Created reports with Top N and Bottom N reports to the highlight the high/low performing customers.
• Actively participated in the discussions with ETL team to arrive at data model that works both ETL and Reporting.
• Created WebI reports in SAP BO 4.0 to demonstrate the capability to display on mobile devices like iPhone and iPad.
• Developed multi source universe using IDT based on Inventory and Order Entry Modules.
• Trained users on Business Objects XI 3.1capabilities through the Webex Sessions. Trainees involved various planners & business heads located in various field offices.

Environment:
Business Objects XI 3.1 (Designer, Desktop Intelligence, Web Intelligence, Publishing Wizard, LiveOffice), SAP Business Objects 4.0 (IDT, Web Intelligence, BI Launch pad, Dashboard Design) Xcelsius 2008, Oracle 11g/10g, Crystal Reports 2008, SQL Server 2008, SQL, Toad, MS Excel 2007, Windows XP, Windows Server 2003 .

Confidential
Location: Irvine, CA.
Role: Business Objects Consultant
Duration: Jan'09 - Oct'10
Confidential,. is a multi-specialty health care company focused on discovering, developing and commercializing innovative pharmaceuticals, biologics and medical devices.
Primary Responsibilities:

• Involved in requirement gathering, writing specifications for generation of reports.
• Involved in Writing Detailed Level Documentation for reports and Universe Design.
• Created universe with row level security to restrict the end users (Sales Reps) to view the data applicable to their Sales Territory.
• Designed BO Universes on SAP BW Queries & Info Cubes and developed WebI reports.
• Developed various Ad-hoc reports with complex functions including aggregate aware, @prompt, report level objects, filters and Derived Tables to speed up and fine tune the performance.
• Used the publications for reports bursting.
• Created several universes on Oracle and SQL server database.
• Helped admin managed all CMC content including reports, universes, folders, scheduling and Business Objects application and custom access levels.
• Developed reports in Web Intelligence Rich Client using Excel as data provider and exported as WebI documents into the repository.
• Created Xcelsius dashboards using charts, bar graphs, selectors, Container, Single Value, Accordion menu and map Components and exported to InfoView.
• Extensively used the OpenDocument functionality to link master (Summary) and child (Detail) reports.
• Developed Executive Level Reporting Dashboards using Business Objects Xcelsius with Live Data Connectivity and passed parameters to Web Services (QaaWS) in Xcelsius to generate Critical Business Reports.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colours.
• Used Functions like @Prompt, @Select and @Where and also created custom objects, custom prompts and custom hierarchies to meet the reporting requirements.
• Converted Desktop Intelligence reports to Web Intelligence Reports, using Report Conversion Tool and run them successfully upon refreshing.
• Scheduled several reports to run Daily, Weekly and Monthly as per custom calendars.
• Extensively created and used alerter, rankings, sorts, and drill-down in reports.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors etc.
• Preparation of Technical design document for reports based on the functional specifications.

Environment:
Business Objects XI 3.1 (Designer, Desktop Intelligence, Web Intelligence, Publishing Wizard, LiveOffice, QaaWS), Oracle 10g, SAP BW 7.0, SQL Server 2008, SQL Server Management Studio, MS Excel 2007, Toad, Windows XP, Windows Server 2003.

Confidential
Location: Plano Texas.
Role: Sr. Software Engineer (Offshore)
Duration: Oct'07 - Dec'08
Confidential, is aFortune 500,Americanmultinational corporationheadquartered in Purchase, NY with interests in manufacturing and marketing a wide variety ofcarbonatedand non-carbonatedbeverages, as well assalty, sweet andgrain-based snacks, and other foods.
Primary Responsibilities:

• Involved in Understanding the requirements of end users.
• Worked in the requirements gathering and documentation of requirements.
• Worked with Business Systems Analyst and Application teams to understand the flow of data.
• Reviewing and analysing the data from the operational & relational DB systems.
• Created reports in DeskI and WebI using Business Objects XI R2.
• Conversion and validation of DeskI Reports to WEBI using the report conversion tool.
• Implemented the best practices in building reports, universes, connections and naming conventions and created templates for the functional and technical design phase and build reports using them.
• Build universes on Data marts and Operational Databases for regular reports and Adhoc reporting purpose.
• Created universes using Derived tables to speed up the performance.
• Created different types of reports like Master/Detail, Cross Tab and Chart Using WEBI XI.
• Created the reports using universes as a main data provider and using the powerful business objects functionality\'s like @functions, user response, formulae's and created complex predefined conditions at the universe level.
• Resolved loops, chasm and fan traps in the universe by Creating aliases and contexts in the universe.
• Formatted reports in crystal reports.
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts by using Chart expert in Crystal Reports .
• Converted Desktop Intelligence reports to Web Intelligence Reports, using Report Conversion Tool and run them successfully upon refreshing.
• Scheduled the weekly, monthly, quarterly reports through Infoview.
• Responsible for training, supporting and helping the users building reports and running Adhoc queries using WEBI.
• Advanced WebI reporting including merging of queries from different data providers in to a single report and using sections and breaks. Used filters, conditions and calculations, etc.
• Performed tuning on existing reports for better performance.
• Documentation: Business Requirement Documents, Test Plans, Release Notes etc.

Environment:
Business Objects XI R2 (Designer, Desktop Intelligence, Web Intelligence, Publishing Wizard), Oracle 9i, MS Access 2003, MS Excel 2003, Toad.

Confidential
Location: Sunderland, UK.
Role: Software Engineer (Offshore)
Duration: Sep'06 - Oct'07
Confidential, together with its subsidiaries, engages in the manufacture and sale of automobile products and services. It primarily offers light commercial vehicles, passenger cars, buses and trucks, forklifts, and related components.
Primary Responsibilities:

• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities.
• Worked in the role of coordinator between Onsite and Offshore team.
• Created WebI reports with multiple data providers and synchronized the data using merge dimension option in BO XIR2. Worked extensively with the major functionality of BO like Breaks, Alerters, Filters, Sorts, and Query Prompt and Drill filters
• Applied rankings and created alerts in the listing reports. Used more than one data providers to create some of reports and created user defined objects that will be helpful in the reports.
• Developed various Charts, Graphs and drill down reports
• Extensively used Toad to verify if the data pulled by the report is correct compared to the database data and also to verify if the joins used in designing the universe are correct.
• Created Derived tables to reduce the complexity of the universes and also created prompts to force the users to restrict the data in the process of building the universes.
• Applied row level restrictions in Universesto restrict data that theusers see at user level, when they are doing ad-hoc reporting using Web Intelligence.
• Involved in production support by modifying and correcting production reports. Provided offshore support to business users.

Environment:
Windows XP, Business Objects XI R2 (Designer, Desktop Intelligence, Web Intelligence), Oracle 9i, Toad.