SUMMARY

• Business Intelligence Consultant with a skill set of Business Objects 6.5.1, XIR2 and XIR3, Business Objects Live Office, Query as a Web Service and Data Integrator 11.7/Informatica 811.
• 9 years of IT experience in the Business Objects and Data Analysis, Reports Development & Data warehousing.
• Experience and Strong understanding of SAP BW integration with Business Objects.
• Efficient in working with Oracle 9i/8i, MS SQL Server 2000/7.x running on Windows 2000/XP.
• Expert in design and implement a BI 7.0 solution (including BOBJ).
• Experience in designing and implementing ETL process, Transformation Mappings and loading using Data Integrator 11.5/Data Services/Informatica 811.
• Experience in Designing, Building and Maintaining the Universes, resolving the issues like loops and Traps using Alias and Context, designing complex objects using @prompt, @ Aggregate aware function.
• Expertise working on Business Objects, including Crystal Reports and Webi.
• Having good knowledge and working experience with Xcelsius Dashboards .
• Business Analyst in requirements gathering and generating ad - hoc reports for the managements Decision Making Process with MIS Functionalities to support the BI & DSS.
• Excellent understanding of Normalization and demoralization of schemas, designed star schemas with snow flake dimensions.
• Expertise in Migration of Repository (Universes, Reports, Security, categories etc) to Business Objects XI from previous versions of Business Objects.
• Expertise with Business Objects 5.x/6.1b/6.5,XI Business Objects products (Supervisor, Designer, Reporter) and Business Objects Server Suite (Info View, WebI, BCA).
• Excellent knowledge in SQL and coding PL/SQL Packages, Procedures.
• Procedures, Test Case Design and Execution, Modification Requests.
• Expertise in conducting corporate trainings for the end users
• Being a key project player, observed a full Life Cycle of a project, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.

TECHNICAL SKILLS

OLAP and Reporting: Business Objects XI R3.1/R3.0/R2/6.x (Supervisor, Designer, Deski, Webi, Crystal Report 2008/XI/101, Xcelsius 2008

RDBMS: Oracle 10g/9i/8.i, MS SQL Server 2000,2005,Acess

Application Server’s: Apache Tomcat and Weblogic

Operating Systems: Windows 95/98/NT/2000/XP

ETL Tools: Data Integrator

Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, Florida

Senior Business Objects Developer

Responsibilities:

• Gathered requirements from end users to create universes and reports.
• Involved in setting up database connections, parameters and various need configurations in Business view using business view manager.
• Created Universes, Classes and Objects for management systems Business Objects XI R2.
• Resolving Loops using Aliases and Contexts and check Integrity of the Universe and exported them to the Repository to make resources available to the users and groups.
• Involved in Business Requirements Analysis & Documentation.
• Updated and maintained Universes based on changing user requirements and data source changes.
• Worked on using the import wizard in moving reports and universes from Dev to UAT and to Production environments. Also used Import Wizard to create BIAR files for repository back up.
• Worked extensively with (@select, @aggregate aware, @where, and @prompt) to overcome the problems with database when integrating with Business Objects.
• Used Crystal Report to feed data to Crystal Xcelsius Visualization an XML file as a data source. Also used QaaWS.
• Crystal Report with mixed data (from database and Universe) to leverage the reporting need of a particular environment.
• Created WEBI Reports with multiple variables at report level to get % Average, Boolean etc values. Also created User Defined Variables on report site upon user’s requests.
• Procedures and Queries by using Crystal Reports.
• Generated reports by using Stored procedures and generated Parameterized, Drill down reports
• Created report templates, developed Ad-hoc reports, complex reports (e.g. reports from multiple data sources, drill down capabilities by using Crystal Reports).
• Created Multi tab reports using multiple data providers and applied different Webi functionality such as hiding and filtering tables based on specific prompt conditions. Also used Union, Intersection, minus, Master/Detail, cross tab and Charts using Webi functionalities.
• Created a Detail Analysis Report for Auditing Purposes in Webi. Auditing Statistics were analyzed to check user interaction and login in specific time slot.
• Created Universes, Classes and Objects for management systems Business Objects XI R2.
• Resolving Loops using Aliases and Contexts and check Integrity of the Universe and exported them to the Repository to make resources available to the users and groups.
• Involved in universe creation, testing the new and updated universes using BO Designer.
• Created Report level variables by using Used Variable Editor
• Analyzed the reports using the Drill Through, Slice and Dice
• Created users and assigned them to appropriate folders to give them access levels depending on their rights.

Confidential - New York, NY

Business Objects Developer

Responsibilities:

• Helped client to deploy Business Objects XI 3.0 on 7 different environments (Development, System Test, Performance Test, UAT, Production, SLA, Disaster Recovery)
• Contacted stakeholders on individual basis (owner of the Universes and Reports).
• Discussed with them the security features they require for their Universes, Reports and Folders.
• Created various custom (user defined) security level BO XIR3 to meet the client security requirements.
• Created Users, Profiles, User groups and implemented inheritance based security for all users, groups, folders, categories, reports, Universes and for Publication.
• Migrated repositories from Development, System Test, Performance Test, UAT, Production, SLA and to Disaster Recovery using migration tool by creating BIAR files and moved it to the Destination System. Successfully accomplished proof of concept for Live Office 2008.
• Configured BO servers to support heavy data requirements of the client in Live Office 2008.
• Responsible on the ETL process and implementation using Business Objects Data Integrator ETL tool.
• Created step by step manual for the download, installation and configuration of Live Office 2008 for the end users.
• Created critical visualization using Business Objects Crystal Xcelsius 2008 for the Business Dashboard.
• Used Crystal Reports, Report to feed data to Crystal Xcelsius Visualization an XML file as a data source.
• Crystal Report with mixed data (from database and Universe) to leverage the reporting need of a particular environment.
• Created KPI visualization for the client dashboard using Live data techniques (Query As a Web Service, Live Office, XML) which address the performance of the LOB at the Organization Level.
• Created Ad-hoc Reporting menu in Xcelsius with the use of opendoc URL call procedure.
• Used Flash variables to pass special values to the flash file through HTML.
• Updated Xcelsius UI data on daily basis with a combination of Query as a Web Service and XML.
• Participated in the JAD sessions and successfully developed client’s special requirement for a Webi report to have drill down capabilities. Further dill down of the report is achieved by report linking.
• Gathered requirements from the end users and created new objects in the migrated Universes at user request for their enhanced reporting requirements.
• Created new WEBI reports from scratch for the new reporting requirements.
• Documented complete server settings, including Security, users, groups, server settings, database access, universes, reports for each individual box.
• Preformed training sessions for the end users to ensure ROI. Training includes new interface of InfoView. Infoview navigation.
• Gave a live demo to the end users how to launch a Webi report. How to edit webi report and the query panel objects. How to create a New Webi report in info View and in Webi Rich Client.
• Successfully migrated Crystal Reports from version 6.0 to Crystal reports XI.
• Designed and developed new Crystal reports accessing DB2 and Oracle databases and then published them into the repository.
• Created publications and the various options associated in the publications such as format type, recurring type publications, calendar based publications, trigger based publications.
• Raised product defects and bugs with Business Objects Technical Support, created tickets with them, discussed with the Business Objects Engineer about it. Tracked the tickets progress and successfully acquired the fixes from BO.
• Successfully completed the full life cycle of the project from Dev to Go Live.

Confidential, Midland, MI

Business Objects Developer

Responsibilities:

• Wrote a full functional specification document for the security implemented in Business Objects
• Provided cascading prompts in the reports as well as the Universe to create more interactive reports for the users. Migrated Existing Crystal 9 Reports to Crystal 10
• 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 6.5.1 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
• Was involved in Star Schema customization / Design session
• Installed and configured Business Objects Enterprise 6.5 using Apache/Tomcat.
• Developed reports in 6.5 Web Intelligence
• Fixed wrong data display by the variables because of placement in the report sections and optimized processing time by forcing them to be processed on the last stage of Crystal Processing Engine
• Moved Crystal Reports from various Test Environments to Production (adjusted the database pointer for each environment
• 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
• Developed several Complex Reports, various features used include Multiple Groupings, Drilldown, Parameter fields, Formulas and Conditional formatting using Crystal Reports

Confidential, Lake Zurich, IL

Business Objects Developer

Responsibilities:

• Created reports from various data sources(SQL,ODBC,Oracle,DB2)
• Created reports with Selection Criteria, Grouping, Sub reports, Cross tabs, Standard and Summary.
• Developed universe in Business Objects 6.0 for the Sales and Marketing Department to Analyze Sales and enable Marketing Team to make informed decisions
• Resolved Loops using Aliases and Context. Addressed chasm trap and Fan Trap using Multi Parse SQL. Imported data from Excel to compare Actual Vs Budget
• Created complex reports using functionalities like Slice and Dice, Drill Down, Scope of Analysis, Master Detail. Exposure to MS SQL Server 2000
• Exported reports to the repository for Infoview users.
• Configured Broadcast agent using Supervisor for scheduling reports
• Used Flash variables to pass special values to the flash file through HTML.
• Updated Xcelsius UI data on daily basis with a combination of Query as a Web Service and XML.
• Participated in the JAD sessions and successfully developed client’s special requirement for a Webi report to have drill down capabilities. Further dill down of the report is achieved by report linking.
• Gathered requirements from the end users and created new objects in the migrated Universes at user request for their enhanced reporting requirements.
• Created new WEBI reports from scratch for the new reporting requirements.
• Excellent understanding and work experience of EXCEL functions with Business Query reporting

Confidential, New York, NY

Report Developer

Responsibilities:

• Developed universe in Business Objects 6.5 for the Sales and Marketing Department to Analyze Sales and enable Marketing Team to make informed decisions
• Analyzed revenue by sales person, by product, by services
• Resolved Loops using Aliases and Context. Addressed chasm trap and Fan Trap using Multi Parse SQL. Imported data from Excel to compare Actual Vs Budget
• Created drill down reports in Webi to dill down over individual sales Team and LOB.
• Created Ad-hoc reports with WEBI and DESKI including functionalities like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab Master/Detail various Charts reports and exported to Repository. Configured Broadcast agent using Supervisor for scheduling reports.
• Created templates in Webi and Deski for standardizing the Structure of our Corporate Documents.
• Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters. Also used Cascaded Prompts to fullfill complex conditions described by users.
• Developed Xcelsius presentations/visualizations for profitability Analysis, Distributor Sales Analysis, Monthly Sales Analysis, Forecasted Sales What if Analysis.