SUMMARY

• Business Intelligence Consultant with total 12 years of experience in Business Objects 6.5/XIR2/XIR3.1/4.0, Xcelsius 4.5/2008 & Crystal Reports.
• Experience with Installing and Administration of entire hardware, and software products like Tomcat, and Apache (Clustered and Standalone environments).
• Worked with server team to provide them with list of specifications need to build the servers for BO4.0.
• Worked with Developers to consolidate the Business Objects repository before migrating to BO4.0.
• Experience in performance tuning, identify and resolve performance bottlenecks at various levels like source, target, mappings, and session.
• Experience in writing system documents, technical documents, and user documentation and also writing training materials helpful for end users.
• Strong exposure to Software Project Development full life cycle and batch processing.
• Installed and configured all the three environments (DEV/QA/PROD) with Business Objects XIR2/XIR3.2 with Apache and Tomcat as web and app servers on windows and Unix servers.
• Expertise 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 & Cascaded List of Values & Prompts. Experience in creating Universe by using views created over different data providers SQL Server, Oracle, DB2, MS Access.
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods. Hands on experience on linking universes and Implementing object level and row/Column level security during the universe design.
• Experience in implementation of Business Objects management in Financial, Banking, Pharmaceutical, Sales & Marketing and Supply Chain Management sectors.
• Worked on Web Intelligence to develop, publish and schedule thin client reports. Created ad - hoc reports with multi prompts to retrieve required data for the user and to minimize unnecessary load on the server.
• Developed complex reports in WEBi and DESKi using date functions, Calculations, formulas & Filters and link reports and perform drilling using Open Doc function in InfoView. Performed Slicing/Dicing, Multi Tabbing, Cross Tabbing, Drilling, and Scheduling and created Master Detail Reports.
• Hands on experience developing Dashboards using Xcelsius for What if Analysis, Interactive Dashboards, Decision Support and other purposes. Adopted various methods to get the data into Xcelsius like Live Office, QaaWS, Web Services & XML and created several dashboards.
• Designed and developed Complex reports using Crystal Reports XIR2/2008 using formulas fields, parameter fields, Group selection, record selection, and Crystal syntax. Wrote Crystal Syntax Formulas to calculate the Percentages and Summaries based on the group levels. Developed ad-hoc reports for end users.
• Expertise in Data Source Migration Wizard, Central Configuration Manager, Report Conversion Tool.
• Experience in designing and development of Star Schema, Snowflake Schema and creation of Fact Tables and Dimension Tables.
• Actively Involved in Data Quality Analysis, Auditing, Matrix Gathering, ROIs Analysis and Standardization of Data.
• 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.
• Excellent analytical and documentation skills with ability to communicate at all levels.
• Diversified experience in implementing Business Objects reporting applications. Excellent technical, logical and problem solving capabilities.
• Ability to work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS

BI Tools: Business Objects 6.5/XIR2/XIR 3.1, Web Intelligence, Designer, Desktop Intelligence, InfoView, CMC, CCM, Import Wizard, Report Conversion Tool, Xcelsius 4.5/2008, QaaWS, Live Office.

Database: SQL Server 2000/2005, Oracle 9i/10g.

Operating Systems: Windows 98/2000/XP/NT/Vista, Linux, UNIX.

Languages: SQL, PL/SQL, C++/ C#, Java, T-SQL

Other Tools: Microsoft Office, MS Visio, Adobe Distiller.

PROFESSIONAL EXPERIENCE

Confidential

Business Objects Administrator / Developer

Responsibilities:

• Responsible for promotion of report, universes and maintaining the environments for Dev, Test and Prod.
• Converted old crystal reports into Webi reports with added functionality of input controls and options of drilling down.
• Responsible of maintaining universes and SME for reports and issue.
• Analyzed existing database and Designed Universe by using Designer and made changes as required.
• Responsible for gathering requirement from supervisors and develop complex reports using WebI.
• Created detailed reports and worked with team members on understanding the requirements.
• Worked with team members in resolving issues with universes.
• Attended team meetings to discuss the automation of reports.
• Created reports and scheduled to be delivered to different executives.
• Created complex reports in WebI, using formulas, variables, Filters, Date Functions and helped end users in understanding the report.
• Used merged dimension and created various reports from different data providers. Used Open Doc function to link several reports.
• Performed Slicing and Dicing, Drill Down on reports.
• Created templates to standardize the structure of corporate documents.
• Used Alert in various reports according to user requirement.
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts.
• Responsible for maintaining the environment and provide support to users.
• Worked with user issues and provided solutions across the environments for user issues.
• Used toad to verify results as well as fixing reporting issue.
• Maintained HP executive scorecard and links of Webi with it using open doc.

Confidential

Business Objects Architect

Responsibilities:

• Responsible for maintaining the environment and provide support to users.
• Worked with user issues and provided solutions across the environments for user issues.
• Provide solutions to different groups on reporting and connection issues.
• Work in SUSS group to provide solutions and support for the different tribal businesses.
• Responsible for designing the Dev server and providing SSO across the business.
• Maintained the UAT server and provided support for SSO and other user and reporting issue.
• Analyzed existing database and Designed Universe by using Designer and made changes as required.
• Responsible for gathering requirement from supervisors and develop complex reports using WebI.
• Part of a group that worked on creating reports for Executive level.
• Created detailed reports and worked with team members on understanding the requirements.
• Worked with team members in resolving issues with universes.
• Attended team meetings to discuss the automation of reports.
• Created reports and scheduled to be delivered to different executives.
• Created complex reports in WebI, using formulas, variables, Filters, Date Functions and helped end users in understanding the report.
• Used merged dimension and created various reports from different data providers. Used Open Doc function to link several reports.
• Performed Slicing and Dicing, Drill Down on reports.
• Created templates to standardize the structure of corporate documents.
• Used Alert in various reports according to user requirement.
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts.

Confidential

Business Objects Administrator / Developer

Responsibilities:

• Analyzed existing database and Designed Universe by using Designer and made changes as required.
• Responsible for gathering requirement from supervisors and develop complex reports using WebI.
• Part of a group that worked on creating reports for Executive level.
• Created detailed reports and worked with team members on understanding the requirements.
• Worked with team members in resolving issues with universes.
• Attended team meetings to discuss the automation of reports.
• Created reports and scheduled to be delivered to different executives.
• Created complex reports in WebI, using formulas, variables, Filters, Date Functions and helped end users in understanding the report.
• Used merged dimension and created various reports from different data providers. Used Open Doc function to link several reports.
• Performed Slicing and Dicing, Drill Down on reports.
• Created templates to standardize the structure of corporate documents.
• Used Alert in various reports according to user requirement.
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts.
• Responsible for maintaining the environment and provide support to users.
• Worked with user issues and provided solutions across the environments for user issues.