SUMMARY:

• U.S Citizen with 4 years experience in Business Objects 6.5.1, XIR2, XIR3.0, XIR3.1, XI 4.0.
• Hands on development Experience on Business Objects XI 4.0
• Experience in Designer, Desktop Intelligence, Web Intelligence WEBI Rich Client, Info View, Dashboard, Scorecards, Central Management Console, Xcelsius.
• Experience using SQL Developer, TOAD, OLAP, Oracle 10g/9i, SQL Server 2000, Access.
• Expertise in gathering the business requirement and building Universes, free hand SQL methods and creating complex ad-doc reports.
• Extensive experience in administration and supporting Business Objects servers and services.
• Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness using Business Objects Designer.
• Created Drilldown Reports, Sub Reports, On-Demand Sub Reports, Label Reports, Chart Reports, Dash Boards, Styles and GUIs.
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
• Broad knowledge in optimizing/enhancing SQL sentences, reports and tables.
• Excellent technical, logical and problem solving capabilities.
• Pro-active team player, committed to providing quality deliverables with strong analytical skills.
• Created Free-hand SQL and Ad-hoc reports in Business Objects Experience using Microsoft Excel, PowerPoint, PDFs interaction with Business Objects.
• Operating Systems
• Windows 95/98/XP/Vista/2003
• RDBMS
• Oracle 10g/9i/8.i, MS SQL Server 2000,2005, MS Access
• OLAP and Reporting
• Business Objects XI 4.0/R3.0/R2/6.x (CMC/Supervisor, Information Design Tool/Designer, Business Object/Desktop Intelligence and Interactive Analysis/WEBI
• Scripting Languages
• SQL,Java Script and VB Script
• Other Tools
• Toad, Visio, MS Office

Professional Experience

Seatadvisor CA January 2012-July 2012
Business Objects Admin/Developer

Environment: Business Obejcts XI 3.1, Oracle 11g, Linux, CMC, Designer, Web Intelligence, SQLPLUS, Import Wizard.

Responsibilities:

• Helped client to migrate from legacy reporting system (Free hand SQL reports) to Business Object.
• Created Universe on existing Data Warehouse.
• Created Reports to replace existing Classical Reports.
• Successfully setup BOE environment in QA on UNIX Server.
• Successfully setup Auditing Database for all Environments (Development, QA, and Production)
• Implemented data security through row level security option of Designer.
• Extensively use Aggregate Awareness and @Prompt for query optimization.
• Created Universe Filters to restrict query Data.
• Implemented cascading prompts to help users to select correct LOV (Patrons, Clients, Event, Performances, and Venues) values for their corresponding organization.
• Used Case Statements to create custom dimension bucket and measure calculations as per business requirements.
• Created linked Universes.
• Responsible for moving BI content (Universe and Reports) from one environment to other (Development, QA, Production) through Life Cycle Manager and Import Wizard.
• Created Users, Groups and granted rights on Reports, Universes, Folders and Universe Connections.
• Worked with QA team for Universe and Reports testing.
• Responsible for server maintenance and patching.
• Remotely conducted end user training for Webi..
• Created various Webi reports through Merge Dimensions, Multiple and Union queries to address client's complex reporting requirements.
• Scheduled reports to run on daily basis in PDF and EXCEL format.
• Created custom report with free hand SQL.
• Leveraged client requirement to create jump off reports using OpenDoc from their external portal and passed user's selection for optional and mandatory prompts.
• Dynamically hide reports block based on user selection of prompts.
• Formatted reports using different techniques such as Break, Sections, and Charts.
• Extensively interacted with end users for development of new and modification of existing reports.
• Raised tickets with SAP for product defect (Bugs).

Confidential, VA August 2010 - November 2011
Business Objects Consultant
Environment: Business Objects XI R2, Windows Server 2003 , SQL Server 2003, Oracle 10g, Designer, Web Intelligence, Business Objects XI 4.0
Responsibilities:

• Involved in the POC testing and Migration of Business Objects XIR2 to Busienss Objects XI 4.0.
• Hands on experience on Business Objects 4.0 Report development using interactive analysis (WEBI).
• Developed sample Universe in Business Objects 4.0using Information Design Tool (Universe Designer).
• Translated business requirements into technical deliverables.
• Developed reports in WEBI XI for GL with multiple breaks and sections.
• Created reports for PNL, Balance sheets for monthly and quarterly reports.
• Created reports for Inpatient, outpatient, provider type for Wiscon State Health Care project.
• Participated in the development of a new data warehouse for Medicate payment systems.
• Rolled out Live Office in the Environment.
• Developed reports in txt and CSV formats using Desktop Intelligence for Finance users.
• Created a new report template to pick customer account and automated invoicing procedure by running this new report in an Event based Publication.
• Heavily interacted with the End user for the requirement gathering and translated Business requirement into technical document.
• Created reports with Pie charts, Bar graphs with drillable tables to mimic dashboard reports.
• Prototyped and developed dashboard in Xclesius 2008 using Qaaws and Live Office.
• Provided level 2 support for multiple business applications mainly Business Objects production.
• Provided support for the existing corporate reports for finance, Purchasing, Payroll, AP and AR.
• Successfully supported, maintained and developed new universes.
• Prioritize, analyze and troubleshoot application issues.
• Perform efficient proactive communication across functional groups.
• Work closely with the various functional groups withinthe departmentto achieve project success.
• Managed new service and enhancement tickets.
• Monitored tickets for Service Level Adherence responding appropriately.
• Took ownership of issue investigation and resolution.
• Provided unit and integration Acceptance testing of configuration undertaken.
• Attended business application training sessions as scheduled and Conduct end user training as per assignments.
• Used online system to log, update, and follow up on assigned business application issues until issue is resolved and closed.
• Tested Life Cycle Manager for version control.
• Demonstrated new XI Report bursting to the management.

Confidential, NYC January 2010 - August 2010
Business Objects Consultant.
Environment: Business Objects XI 3.1, Windows Server 2003 (VM), SQL Server 2003, Oracle 10g, Designer, Web Intelligence, Xcelsius 2008.
Responsibilities:

• Actively participated in the team JAD sessions and provided inputs to improve environment.
• Involved in Installing and configuring Business Objects XI 3.1.
• Migrated existing 6.5 repositories to the newly built BOE 3.1 Environment.
• Created migration checklist to validate reports which are migrated from Integration to Production.
• Imported users and groups from the Active Directory and deployed new security structure for XI environment.
• Created templates for standardizing reports using company logo, header and footer settings, color coding, fonts and maintained consistency in viewing cross-tabs, blocks in report.
• Synchronized reports using data from multiple data providers in Web Intelligence by merged dimensions functionality.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects Reports.
• Implemented Row & Object level security for different user group requirements.
• Used Free-Hand SQL Data Providers to import Tables not present in the Universe.
• Created Joins, Context and Aliases for Resolving Loops in the Universes.
• Involved in Resolving Problems like \'Chasm Trap\' and \'Fan Trap\'.
• Checked the integrity of the universe schema for any errors in objects, joins, conditions, loops and cardinalities of the universe.
• Linked summary reports and passed prompt values to open document to obtain more detail information.
• Enhanced reports which include standardizing format of report content, redefining query filters and prompts, linking summary report to a set of detail reports.
• Attended to user requests in enhancing reports and fixing bugs, providing solutions for existing bugs and redefining newer concepts for better features.
• Implemented reports in Production from Integration after user approval in test Environment.
• Used @Functions such as @Prompt- to restrict return values and to enter prompt, @Select- to reuse the select statement of another object, @Variable- to restrict the currently logged user etc.
• Helped document all software, hardware and infrastructure process.
• Conducted an analysis on the matching criteria for regional mapping of data from other systems based applications.
• Optimized queries used in Business Object for Web Intelligence.
• Distributed Documents inside and outside of the business using Central Management Console and administration for scheduling the Reports (rep, wid, pdf, excel, text and html format).
• Create Dashboards using Xcelsius 2008 to monitor business performance, insightful analytics and role based dashboards with Live data (QaaWs, Live Office, XML, Flash Variables).
• Conducted Business Objects and Web Intelligence trainings to client's users.

Confidential, NJ November 2008 - December 2009
Business Objects Consultant.
Environment: Business Object XI R3.1, INFOVIEW, Web Intelligence, MS-Excel, MS- Word, SQL Server 2005.

• Involved in migration reports from 6. 5 to BOXI R2.
• Created new security structure for Business Objects and implemented folder based security.
• Migrated Universe data restrictions from supervisor to Universe Designer.
• Created backup procedures for the environment through SAN replications and Weekly BIAR file backups.
• Responsible for moving content from one environment to another for full life cycle of new development.
• Clustered Business Objects server with DR Business Objects server to leverage failover.
• Used publications with report bursting to leverage daily mass report generation requirement.
• Designed report templates for the report company standards.
• Analyzed specs and database model to generate the reports for the sign-off specs.
• Created different types of reports, such as; Master/Detail, Cross Tab and Chart.
• Created Dashboards Score Cards and UI's using Xcelsius.
• Used various data sources for live data feed for Xcelsius such as QaaWS, Live Office, XML, Flash Variable, Excel XML maps.
• Created jump off reports functionality for WEBI from Xcelsius using opendoc function to leverage detailed to granular level drill down.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Deski.
• Created various formulas for the calculations for pricing in the reports.
• Created Static and Dynamic Parameter fields for the filtering of the data.
• Wrote procedures for the complex reports and list of values for the parameters.
• Connected to Business Objects Repository as a Business View and created reports.
• Created Business Objects Web Intelligence reports and published on the INFOVIEW.
• Used Drill down Group Levels, Conditional formatting, Alerter, Alternate row shading futures and created Label reports for Providers and Subscribers.
• Published report to Enterprise server, to get the report access from INFOVIEW.
• Used Team Track to track the status of the report by developer, state and comments.

Confidential, NY October 2007 - September 2008
Business Objects Developer.
Environment: AIX, WebSphere, SQL, Oracle 10g, Business Objects 6.5 - XI 3.0
Responsibilities

• Developed General Ledger and Accounts receivable universes using Designer.
• Provided cascading prompts in the reports as well as the Universe to create more interactive reports for the users.
• Extensively wrote PL/SQL procedures to get data from Oracle 8i database.
• Troubleshooted problems and customize the application according to the specifications of the analysts.
• Developed and scheduled reports in Web Intelligence on recurring basis.
• Wrote a full functional specification document for the security implemented in Business Objects.
• Created complex Universes and report for GL, AP and AR.
• Customized Rapid Marts of GL, AP and AR.
• Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap using Multi Parse SQL.
• Created Custom Hierarchies for several groups.
• Created detail and summary reports, used to fold/unfold sections corresponding to breaks in current blocks.
• Used Toad to verify data pulled by the report is correct compared to the database data and also to verify the joins used in designing the universe are correct.
• Developed complex reports in Business Objects using multiple data providers.
• Created graphical representation of Webi reports such as bar charts, pie charts etc.
• Implemented extensive use of derived tables in the process of building reports.
• Developed hierarchies according to demand to support drill down reports.
• Improved query performance by implementing aggregate awareness.
• Involved in Star Schema customization / Design session.
• Developed new WEBI reports in XI.
• Created interactive reports in Xcelsius with the summary level data.
• Created score cards in the Xcelsius.
• Developed new reports along with modifying existing reports to support new and additional Business requirements.
• Used prompts, alerts, drill down analysis as per the end user requirements.
• Developed Database connections, SQL joins, loops, views and aggregates.
• Used Shared and Global variables to pass data from Main report to Sub report & Vice Versa.