• SUMMARY:
• Over 8+ years of experience in Business Objects BI 4.0/XI 3.1/XI R2/6.x/5.x with extensive knowledge in all phases of Software Development Life Cycle (SDLC).
• Involved in Analysis, Planning, Building, Testing, Migration, Maintenance, Support and Enhancing complex Business Objects Universes, Reports and Dashboards for the Enterprise Data environments.
• Migration Specialist Migrated from Business Objects earlier versions to XI R2, XI 3.1 and from
• XI 3.1 to BI 4.0
• Experience in Optimization and Performance tuning of new and existing Business Objects universes, reports.
• Worked Extensively on Desktop Intelligence, Web Intelligence, Web Intelligence Rich Client and Crystal Reports.
• Expertise in planning, designing, developing, maintaining and distributing Universes using Universe Designer Tool (UDT) and Information Designer Tool (IDT).
• Hands on experience with Linked universes and Multi source universes.
• Implemented Object level, row level security using Universe designer and view level security implementation in IDT Business layer.
• Created and implemented security for users and groups inside the CMC and assigned the access levels as per the organizational guidelines.
• Extensively worked on latest features in Business Objects BI 4.0 SP4.
• Proficiency in Scheduling, Publishing and Distribution of Business Objects reports.
• Sound knowledge of Data Warehousing Design Methodology, Data WarehouseConcepts.
• Good experience on Crystal Reports Development including working with complex report designs.
• Worked on developing reports using Crystal Reports XI using Business Views and Universes as data providers.
• Expertise in converting Desktop Intelligence Reports to WEBI Reports.
• Expertise in converting .UNV universe to .UNX universe using Information Designer Tool.
• Expertise in writing complex and optimized SQL queries using joins.
• Experience in Crystal Xcelsius to create interactive dashboards by using QaaWS and Live Office and integration to the BO WEB Portal.
• Sound Knowledge of OLAP universes sourced from SAP Info Cubes and BEx queries
• Sound knowledge of creating BICS connection through IDT and CMC
• Experience in working on several data sources like Oracle, Teradata,DB2, SQL Server, SAP BW
• Expertise knowledge in Incident Management, Problem Management, Change Management, SLA Management, IT governance and Release management processes
• Expertise in Unit test, Environment test of the BO reports, Dashboards and Universes.
• Ability to adapt to new technologies very quickly and has excellent troubleshooting and problem solving skills.

EDUCATION:
Master of Science in Computers

TECHNICAL SKILLS:
BI Tools:
Business Objects (BI 4.0/XI 3.1/XIR3/XIR2/6.x/5.x),BI Launch pad, Infoview, Interactive Analysis(Web Intelligence),Web Intelligence Rich Client, Desktop Intelligence, Report Conversion Tool, Information Design Tool, Universe Designer, Business View Manager, Crystal Reports 2008/2011, Crystal Report for Enterprise, Xcelsius 2008, Dashboard designer, Live office, Query As A Web Service (QaaWS), Voyager, Import Wizard, Life Cycle Management (LCM), Promotion Management, SDK, Central Management Console, Central Configuration Manager
Operating Systems
Windows NT /2000/XP/2003, MS-DOS, UNIX
Languages
C, VSCOBOL, C++, SQL, PL/SQL
Databases/Source
Oracle 10g/9i/8.x/7.x, MS Access 2000, Teradata 6.0/13.0, IBM DB2, MS SQL 2000/2005/2008, SAP BW
Tools
MS Office Suite, Toad 7.4, Oracle SQL Developer, Teradata SQL Assistant,Service Center, MS Project Management, ADMS, Clarify.

PROFESSIONAL EXPERIENCE:

Organization: Confidential, Sept 2009 – Present
Client: Confidential,
Role: Senior BI-BO Consultant
Description: Confidential,is the world’s largest operator, franchisor and licensor of convenience stores with approximately 40,900 outlets worldwide of which more than 8,400 are in North America. 7-Eleven also is one of the nation\'s largest independent gasoline retailers. The name 7-Eleven originated in 1946 when the stores were open from 7 a.m. to 11 p.m. Today, offering customers 24-hour convenience, seven days a week is the cornerstone of 7-Eleven\'s business. 7-Eleven focuses on meeting the needs of convenience-oriented customers by providing a broad selection of fresh, high-quality products and services at everyday fair prices, speedy transactions and a clean,friendly shopping environment. Each store\'s selection of about 2,500 different products and services is tailored to meet the needs and preferences of local customers. Stores typically vary in size from 2,400 to 3,000 square feet and are most often located on corners for great visibility and easy access.

Responsibilities:

• BI Model migration to Business Objects BI 4.0
• Identify list of tables, joins, calculated columns and reports in BI Data Warehouse model.
• Used secured database connection; create new Unx Universes from BI Data warehouse models.
• Used BI 4.0 Information Designer Tool to design Universes, joining tables, creating prompts and applies Contexts and Aliases to remove loops
• Created folders, sub folders same as BI warehouse Model hierarchy
• Created Objects (Dimension, measure, Attribute) for all the tables and update business name and description for all the objects.
• Created calculated Attributes as per the BI model definition.
• Publish/Retrieve .unx Universes from/ to repository to make them accessible to end-users.
• Created WEBI reports from BI model reports using corresponding Universes.
• Conducted Review meeting with BI model owner to review Universe for corresponding BI Model.
• Migrated Universes and WEBI reports to QA and Production using Life Cycle Management Console (Promotion Management)
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Work with Business Analysts and Database Architect to identify database relation for the business requirement.
• Designed, Developed and Maintained Universes by defining joins cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Defined and Created Hierarchies as per the business rule for the reports to be viewed at selected reporting level.
• Developed various Complex Ad hoc and Complex Canned Reports Using Mainly Universe (UDT and IDT) as the main Data Provider.
• Interacted with users to know their approach and assist in developing and modifying Reports accordingly.
• Extensively used various techniques like Sectioning, Ranking, Filtering, breaking to develop the report.
• Created different types of reports such as Master/detail, Cross Tab, Bar charts, 3D charts and Pie charts.
• Converted .UNV universe(XI 3.1) to .Unx universe (BI 4.0) using Information Designer Tool.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Used Alerts to draw attention to a particular block of data by highlighting it.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Generated several Templates in WEBI.
• Did the performance tuning on universes and reports to increase performance.
• Used Crystal Xcelsius to create interactive dashboards by using QaaWS and Live Office and integration to the BO WEB Portal.
• Created OLAP universes sourced from SAP Info Cubes and BEx queries in SAP BW
• Created BICS connection through IDT and CMC for WEBI reports.
• Exported reports into XLS, PDF, CSV and XML formats as per the client requirement.
• Used Scheduler for scheduling and distributing the documents.
• Used Life Cycle Management console (LCM) to take BIAR files for backup.

Environment: Business Objects BI 4.0/XI 3.0/3.1 - Universe Designer, Information Design Tool (Unx), Web Intelligence, Web Intelligence Rich Client, Life Cycle Management, CMC, Crystal Reports, Crystal Dashboard Designer, Xcelsius, Live Office, Teradata 13.0, SAP BW, Teradata SQL Assistant, MS SQL Server, Service Center, MS Project Management, ADMS and Clarify.

Organization: Confidential, Sept 2006 – Aug 2009
Client: Confidential,
Role: Senior BO Developer
Description: Confidential,is a global manufacturer and marketer of high-quality brand-name products for consumers throughout the world, based in Downers Grove. Sara Lee Businesses are Sara Lee Food & Beverage, Sara Lee Foodservice and Sara Lee International. Sara Lee has a wide offering of high quality consumer products throughout the world. Most of its international and local brands hold leading positions in their markets. In many countries Sara Lee also provides coffee systems and food products via the foodservice channel. Sara Lee has three different warehouse management applications Pkms, Imrex and Infinium. All these three applications perform following functions: Order Management, Inventory Management, Warehouse Management, Traffic Management, and System Functions. The team Provides production support, Maintenance and enhancement for warehouse management applications and Manufacturing applications.

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements for building Business Objects Universes and Reports.
• Created technical specification document for creation of Universe, Joins, Contexts, and Cardinalities of the tables.
• Analyzed business requirements and created Universes based on user requirements for the reports
• Involved in full life cycle of Business Objects reporting Application.
• Designed, Developed, new Universe and maintained existing Universes.
• Used Aggregate awareness in universes.
• Resolved issues during designing such as loops, Cartesian product due to fan trap and chasm traps.
• Developed and Deployed Desktop Intelligence, WEBI Reports through Infoview.
• Involved in Weekly/Monthly/Quarterly batch cycle monitoring.
• Involved in exporting/importing the documents to/from the CMS
• Created Crystal Reports using Universe
• Created custom and ad-hoc reports.
• Expertise developing Derived tables in the Business Objects Universe to build complex queries
• Worked extensively on business objects enterprise architecture, migration of Crystal Reports
• Applied Number, Currency, Date, Time, and Date/Time Formatting to the Crystal Reports
• Created Crystal Xcelsius Dashboard from SAP data stored in a MS Excel spreadsheet sourced through Crystal Reports or Web Intelligence LiveOffice, Query as a Web Service (QaaWS).
• Developed widgets for the Dashboards and reports for the reports.
• Expertise in analyzing user’s UAT findings and provided solutions to their queries.
• Involved in Unit test, Environment test of the BO reports (Deski and WEBI), Dashboards and Universes.
• Acquired an excellent understanding and work experience of EXCEL functions in Xcelsius
• Provided 24x7 production support.
• Migrated the universes and reports from Dev to QA and then to Production environment using Import Wizard.
• Documented parameters, fields, and logic used for developing of reports and universe.

Environment: Business Objects Enterprise XI R2/XI 3.0/3.1(Designer, WEBI, Desktop Intelligence, Rich Client, Import Wizard, CMC), Crystal Xcelsius 2008, Oracle, Toad, Live Office, QaaWS, Service Center, ADMS, Clarify.

Organization: Confidential, Apr 2006 – Aug 2006
Client: Confidential,
Role: BO Developer
Description: Confidential, provides a suite of communications services to customers in its serving areas. EMBARQ, which is expected to rank among the Fortune 500, brings common-sense ideas, reliable service and a renewed commitment to the communities it serves. EMBARQ focuses on offering its customers practical, innovative products and competitive pricing. The company has 20,000 employees and operates in 18 states offering local and long distance voice, data, high speed internet, wireless and entertainment services.
Responsibilities:

• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Created Universes by defining connections and retrieving data from database.
• Created Aliases and Contexts for solving the Join Problems in Business Objects.
• Created New Classes and User Objects in designing the universes.
• Exported the universes to the Repository to make resources available to the users.
• Scheduled various reports on Daily, Weekly and Monthly basis in into other server through FTP.
• Created Charts to display summary data using universe as main data provider.
• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports in
• Planned, coordinated and executed Business Objects Deployment for end-users.
• Published reports using Info View, and training users for ad-hoc reporting.
• Created Crystal Xcelsius Dashboards using different chart types and maps.

Environment: Business Objects BO 5.x/6.x/XIR2/3.0 (Supervisor, Designer, Reporter, Broadcast Agent, Web Intelligence and Info View), Crystal Reports, Crystal Xcelsius, MS Access, Oracle 8.x/9i, SQL, PL/SQL, Windows 2000.

Organization: Confidential, Feb 2004 – Mar 2006
Client: Confidential,
Role: BO Developer
Description: Confidential,is the Internet\'s largest specialized provider of discount accommodations worldwide. Hotels.com provides discount accommodations in more than 8,000 premiere properties in over 350 major destinations in North America, the Caribbean, Europe and Asia. Its Internet booking engine enables consumers to quickly and efficiently compare price, quality, location, amenities, and availability of hotel rooms, and confirm reservations online within seconds.

Responsibilities:

• Created a new universe using Designer based on the new reporting requirements.
• Detected cardinalities and resolved the loops using contexts and alias.
• Involved in gathering Business Principles and Standardization for Reports.
• Developed several complex reports (include multiple grouping, drilldown, parameter fields, formulae) and retrieving data from more than one database using Crystal Reports.
• Worked on complex reports that require running totals, sub-totals, sub-reports, cross-tab and conditional display of groups, fields, messages.
• Created, managed & formatted standard reports, master/detail reports and cross tab reports using Report Manager.
• Created design for running multi-flavor reports; Date, Weekly and Monthly.
• Worked extensively with the major functionality of Crystal Reports like Nested Groups, Static Parameters, Cascading Parameters and Alerts.
• Published reports using Crystal Management Console.
• Scheduled reports by setting the run-time parameters and charted by customizing the options.
• Created reports using Free hand SQL, Breaks, Alerter, Filters, Sorts, Query Prompts and Drill Down/Up to analyze the customer data.
• Involved in Unit and Integration Testing on reports and then exported them to Schedule Manager for Scheduling and Refreshing.
• Provided 24/7 Production support.
• Modified existing universes and WEBI reports as per Business requirements.
• Created and worked on Row level security, Object level security and various predefined security settings depending upon users and group needs using Supervisor
• Scheduled and monitored reports by using Broadcast Agent.

Environment: Business Objects BO 5.x/6.x/(Supervisor, Designer, Reporter, Broadcast Agent, Web Intelligence and InfoView), Crystal Reports, Crystal Xcelsius, MS Access, MS SQL SERVER 2000, SQL, PL/SQL, Windows 2000