SUMMARY

• 7 years experience in Business Objects XI R3/R2/R1/6.5//5.1
• Experience with Business Objects XI R2 components like Central Management Console (CMC), Central Configuration Manager (CCM), Import Wizard, Report Conversion Tool, Enterprise Performance Management, Live Office, Query as a Web Service, Xcelsius.
• Demonstrated excellent interpersonal skills and communication skills during identification of user requirements.
• Created complex universes and optimized existing ones for shorter query run times.
• Experience in migration from previous versions of Business Objects and Crystal Reports to Business Objects XI R2
• Extensively worked on creating and designing reports using BO Full Client, WebI and Crystal XI R2
• Created metrics, goals, and all kinds of analytics and dashboards using Application Foundation, Dashboard Manager, Performance Manager, and Xcelsius.
• Experience in web publishing and scheduling documents.
• Strong background in datawarehousing, data modeling, and reporting.
• Efficient in testing SQL queries and stored procedures.
• Established analytical capabilities with good problem solving skills.
• Excellent resolution and documentation skills.
• Good team player with organizational and project management skills.
• Capable of working in a team and/or individually, self - motivated.

TECHNICAL SKILLS

Business Objects Tools: Business Objects XI R3/R2/R 1/6.5/6.1/5.1 , Web Intelligence, Broadcast Agent, Application Foundation, Enterprise Performance Management, Desktop Intelligence, Crystal Reports XI, CMC, CCM, Crystal Xcelsius, Live Office

Database(s): DB2, ORACLE 10g/9i/8i, MS SQL Server 2000/2005, MS Access

Web/Application servers: IIS, Apache Tomcat

Data Modeling: Star Schema, Snowflakes Modeling

Programming Languages: SQL, PL/SQL, Fortran, Pascal, HTML 4, ABAP/4

Platforms: Windows 95/98/2000/2003 / NT/XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Business Objects Consultant

Responsibilities:

• Worked with business analyst on user requirements and wrote functional and technical requirements documents.
• Modified and enhanced existing universes, and implemented aggregate awareness
• Created complex Webi and Crystal reports according to user requirements
• Created corporate dashboards to display KPI reports.
• Validated report data through datamart and “Sales Page” CRM front end and back end database.
• Migrated reports, dashboards and universes from Development environment to QA, Staging and Production environments.
• Mapped Windows Active Directory groups and users to Business Objects.
• Created and maintained users, groups, folders in accordance with the requested security model.
• Scheduled reports on daily, weekly and monthly basis through a database trigger file.
• Maintained Development, QA, Staging and Production BO XI R3.1 environments.
• Created Disaster Recovery environment.
• Trained users and developers on Business Objects applications.
• Provided support to resolve users' daily problems with Business Objects.

Confidential, Indianapolis, IN

Business Objects Consultant

Responsibilities:

• Met with business users to understand their requirements.
• Created complex reporting and metrics universes with many alias tables, contexts and derived tables.
• Implemented row level security on universes through Security Management.
• Trained business users on Webi and Crystal reports.
• Designed and developed complex Webi reports with multiple data providers, sub-queries, calculation contexts and multiple layers of drill downs.
• Created Crystal reports with cross-tabs, prompts, drill-downs, summary and sub reports.
• Built interactive dashboards on Xcelsius using live office and query as a web service.
• Created metrics and analytics using Dashboard and Analytics tools.
• Created Corporate Dashboard from interactive Xcelsius dashboards, analytics and webi reports.
• Implemented user role security model on universes, reports and dashboards in accordance with the users’ requirements.

Confidential, New York, NY

Business Objects Developer / Administrator

Responsibilities:

• Installed Business Objects XIR2 on multiple servers
• Set up, configured and maintained BO XI R2 in Development, Staging and Production environments.
• Installed service packs and hot fixes, and also different fonts like Japanese and barcode fonts.
• Prepared SOPs (Standard Operating Procedure) for installation processes.
• Monitored performance, disk space, memory and CPU usage in all BO environments.
• Worked with migration team to ensure that migration from BO 6.5 is done flawlessly.
• Mapped Windows Active Directory groups and users to Business Objects.
• Worked with new project teams to initiate and help develop new projects.
• Migrated reports, dashboards and universes from Development environment to Test and Production environments.
• Maintained users, groups, folders and created new ones in accordance with the existing security model.
• Created reports out of Activity universe to keep track of user actions and application usage
• Created complex universes with derived tables and advanced features like Aggregate Awareness and Security Management
• Created complex Webi and Deski reports with sub queries, multiple linked data providers, calculation contexts, multiple level drill downs and cascading prompts.
• Maintained and modified existing crystal reports and created new ones.
• Scheduled reports for different users either through report bursting or raw level security coming from universe or database.
• Created metrics, analytics and corporate dashboards using Performance Management tools.
• Created analytics and dashboards on Xcelsius using live office and query as a web service.
• Trained users on Business Objects applications
• Provided support to resolve all kinds of problems users encountered with Business Objects

Confidential, Jersey City, NJ

Business Objects Developer / Administrator

Responsibilities:

• Met with business users to understand and gathered requirements and created technical specification documents.
• Created Agent Reporting and CRDM universes that addressed the business requirements of the merged company.
• Used advance features in Designer like Aggregate Awareness to accommodate the aggregate tables in the datamart and Security Management to apply object and raw level security.
• Optimized existing universes and reports for shorter query run times.
• Created numerous WebI and DeskI reports using the above universes that met the end user needs.
• Validated these reports for data accuracy using other database development tools.
• Scheduled the reports to automatically refresh and distribute to various destinations.
• Developed a Corporate dashboard containing multiple analytics and reports for the executive team to monitor KPIs.
• Created analytics and dashboards on Xcelsius.
• Migrated Crystal Reports to the XI R2 environment resolved the issues encountered in the process.
• Created complex crystal reports and linked them to WebI and DeskI reports to present in the dashboard according to user needs.
• Supported the administrator in installing patches, migration, LDAP configuration, setting user privileges and access restrictions, and resolving server issues.
• Trained users about Business Objects tools and functionality and in the process of creating reports using WebI.
• Involved in customizing the Infoview home page using Business Objects Enterprise SDK.
• Provided support to resolve issues that users encounter when creating Ad-Hoc reports.

Confidential, Wilsonville, OR

Business Objects and Dashboard Technical Lead / Administrator

Responsibilities:

• Installed Business Objects Enterprise on both server and client machines and Enterprise Performance Management on the server machine.
• Troubleshot Business Objects services’ problems through Central Configuration Manager.
• Contacted users to understand the business and gather requirements for the Corporate Dashboard
• Created universes, universe objects, classes, filters and prompts.
• Mapped Windows Active Directory groups and users to Business Objects and applied different security levels
• Implemented row and object level security depending on user rights.
• Created Metrics, Goals, and various analytics based on these metrics and goals.
• Created a Corporate Dashboard with menus and sub menus using Dashboard Builder to organize the analytics in an intuitive manner.
• Provided production support for the existing crystal reports and modified them when needed.
• Created interactive WebI reports with sections and drop down filters that were used to navigate from the analytics for detailed information.
• Linked multiple Webi reports with Open Document linking.
• Scheduled the metrics, analytics, and WebI reports to refresh automatically every day.
• Used drill down feature for multiple level drilling down in WebI reports.
• Applied complex conditions and used calculation and extended contexts in WebI reports
• Migrated whole BO environment from development to test and from test to production servers.
• Backed up CMS and Performance Manager Repository schemas as well as Input and Output File Repository Folders for safety and version control.
• Tested the accuracy of data by directly querying the database by writing SQL code on SQL navigator

Confidential, Durham, NC

Business Objects Developer

Responsibilities:

• Interacted with users on a daily basis to gather requirements for the Corporate Dashboard.
• Created Metric universes which were a reflection of Siebel application the company used and dependent on various databases such as DB2, Oracle, SQL Server and MS Access.
• Created Metrics, Goals, and various analytics such as “Interactive Metric Trends”, “Speedometer”, Pareto Chart”, “Metric List”, “Top Slices’…etc. based on these metrics and goals
• Created a Corporate Dashboard with menus and sub menus using Dashboard Builder to organize the analytics in an intuitive manner.
• Created interactive WebI reports that were used to navigate from the analytics for detailed information.
• Linked multiple full client reports, WebI reports and analytics when there is big volume of data to present at one time.
• Scheduled the metrics, analytics, WebI and full client reports to refresh automatically every day.
• Maintained and modified existing full client reports according to needs of users and created new ad-hoc WebI and full client reports.
• Used drill down feature for multiple level drilling down in WebI reports.
• Used calculation and extended contexts extensively in both webi and full client reports
• Used charts like 2D and 3D, tables, cross-tabs in the both webi and full client reports.
• Applied complex conditions both in full client and webi, combined queries and sub-queries, linked multiple data-providers
• Validated the data and tested the accuracy by running simple queries in Business Objects and directly querying the database by writing SQL code on Quest Central for DB2 and SQL*Plus for Oracle databases.

Confidential

Business Intelligence Analyst

Responsibilities:

• Collected user requirements, conceptualized and designed universes and reports.
• Managed users/groups as BO supervisor involving multiple domain and multiple repositories.
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Implemented various security settings including row level/document level and customized predefined settings for users and groups.
• Created Deski reports with complex variables and formulas involving calculation contexts.
• Linked multiple data-providers, used combined queries, sub-queries, user-objects, and free-hand SQL for customized and specialized reports.
• Extensively used BO reporting functionalities like slice & dice, drill-down, cross-tab, @functions, Master/detail, breaks and extended syntax.
• Automated document scheduling, publishing, and distribution through Broadcast Agent.
• Conducted report testing and validation.