SUMMARY

• Over 7 years of IT experience including 5+ years providing Business Intelligence solutions using Business Objects products and data warehouse applications.
• Technical hands - on expertise using Business Objects (BOBJ) suite of products XI 4.1/3.1/ R2 (Universe Designer, Web Intelligence, Desk Intelligence, CMC
• BI Launch Pad and InfoView) on various relational databases Oracle, Teradata and SQL Server and multi-dimensional databases SAP BI/BW and BEx queries.
• Designing, developing and modifying BOBJ Universes based on Oracle tables
• SAP BEx Queries and developing canned/ad hoc reports using Web Intelligence reports, scheduling the processes and administering the BOBJ activities using Central Management Console CMC.
• Worked extensively in developing and implementing Crystal reports on relational tables like Oracle, Teradata and SQL Server databases, BO Universes as well as SAP BEx MDX Queries.
• Over 3 years of experience in creating interactive & executive dashboards using Dashboard Design, Xcelsius 2008/4.5/3.x on SAP and relational databases.
• Extensive experience in designing Xcelsius dashboards using web service connectors QaaWS, Live Office, BI Web Services and BICS.
• Excellent experience with DW concepts such as star schema, snowflake schema, fact and dimensional tables.
• Two years of experience with data warehousing using Teradata, Oracle 11g/10g, SQL, PL/SQL, Functions, TOAD, Triggers, Views & MS Access.
• Strong experience in all phases of Software Development Life Cycle (SDLC) such as developing, testing, migrating, administrating, security management and production support on various platforms.
• Successfully managed JAD sessions with the business users in design and development of the applications.
• Trained the end users in working with the Business Objects suite of products and provided technical expertise.
• Possess excellent analytical, problem solving, communication, presentation and interpersonal skills to manage and interact with users/customers and groups at all levels.

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Sr. Business Intelligence Consultant

Environment: Business Objects(BOBJ) XI 4.1/R3.1 SP4/SP2 (Interactive Analysis, IDT,BI Launch Pad 4.1, Universegner, WebI Rich Client, CMC, InfoView), BO 3.1 to 4.1 Upgrade, Upgrade Management Tool(UMT), Dashboard Design 6.0, Xcelsius 2008, Crystal Reports 2008/XIR2, Oracle 11g/10g

Responsibilities:

• Work in conjunction with Offspring Solutions Program Manager to ensure project team deliverables as assigned are completed accurately and on schedule in accordance with the project plan.
• Provide technical and functional Business Intelligence and Business Objects expertise and guidance as required by the U.S. Department of Health and Human Services management.
• Part of the Business Objects 3.1 to 4.1 upgrade team involving Planning, Execution and Testing of Universes, Reports & Security.
• Designed and maintained Universes on Oracle tables by defining joins and cardinalities between tables. Addressed cyclic dependencies issues by either applying contexts or creating aliases.
• Created Security restrictions in Universes and applied them to User groups based on Row level security or Object level security.
• Used @functions like @select, @where and @prompt to create prompts that help the user to select the values dynamically.
• Designed .UNX universes in Information Design Tool (IDT) for use in Dashboard Design(Xcelsius), which eliminates the use of QaaWS tool
• Created classes, sub classes, objects, measures, details and conditions in universe level and created variables in report level.
• Used hierarchies in Universe level and used Scope of analysis in report level to drill up and drill down the reports.
• Built WebI reports using tools - Interactive Analysis, Web Intelligence Rich Client and BI Launchpad.
• Built Crystal Reports on BOBJ Universes, Oracle tables and BEx Queries.
• Designed Business Views(BV) to handle various levels of security for Crystal Reports.
• Built interactive Xcelsius dashboards using BI Web Services(BIWS), Live Office, QaaWS for live data connectivity.
• Created reports on web using BI Launchpad and Web Intelligence Info View, distributed the reports to different users.
• Involved in setting privileges to different user groups using CMC Module.
• Designed dashboard template for the enterprise with standard color scheme so as to maintain consistency for all future dashboard developments.
• Worked on scheduled and On-demand dashboards for HR Data using Crystal Reports, WebI & Universes.
• Used OpenDoc methodology to embed multiple .swf files into a parent .swf using SWF loader in Xcelsius.
• Deployed and tested dashboards across environments in BOE.

Confidential, San Clemente, CA

Business Objects Consultant

Environment: Business Objects(BOBJ) XI 4.0/R3.1 SP4/SP2 (WebI, DeskI, CMC, InfoView), BI Launch Pad 4.0, Xcelsius 2008, Crystal Reports 2008/XIR2, Oracle 11g/10g, SAP BI 7.1, SAP Integration Kit 3.1 SP4/SP2

Responsibilities:

• Interacted with different business units to understand the business process and gather specific requirements for data warehousing and reporting.
• Designed BOBJ Universes on relational/non-SAP data sources Oracle 11g.
• Extensive experience in building Web Intelligence reports and charts on SAP and non-SAP Universes.
• Designed BOBJ Universes on SAP BEx Queries and modified the BOBJ OLAP Universes based on the user requirement.
• Used VBA Macros to suppress L00/L01s from the object names in the OLAP Universe.
• Worked on merged dimensions in WebI to merge data from Oracle & SAP data sources.
• Created hyperlinks in WebI, Crystal & Xcelsius using OpenDoc methodology to open detailed reports by passing parameters based on the user selection.
• Built complex Crystal Reports based on SAP BEx MDX Queries and Oracle tables that require sub-totals, cross-tabs, multiple groups, sections, drill down and sub reports for Finance and Work Mgmt divisions.
• Experience working on BICS for Xcelsius dashboards for direct connectivity on BEx Queries.
• Designed Xcelsius dashboards on SAP Data sources with live data connectors like BI Web Services, QaaWS and Live Office.
• Involved in BOBJ administration using CMC for granting permissions and rights to users for viewing, creating, publishing, scheduling reports through Infoview.
• Worked on creating test cases in Mercury quality center for validating data in WebI, Crystal reports and dashboards against SAP BEx Queries,BW Infocubes, SAP ECC data and TOAD for Oracle.

Confidential, Irwindale, CA

Sr BOBJ Developer

Environment: Business Objects(BOBJ) XI R3.1 SP2 (WebI, DeskI, CMC, InfoView), Xcelsius 2008/4.5, Crystal Reports 2008/XIR2.

Responsibilities:

• Interacting with the cross functional users to analyze the business process and gather the specific requirements for data warehousing and reporting.
• Responsible for producing functional and technical specifications documents by capturing the information from the requirements gathering sessions.
• Providing technical BI and BOBJ integration expertise and guidance as required by Confidential management.
• Extensively worked on integrating and extracting data into Business Objects environment from the SAP databases.
• Design and development of Business Objects OLAP Universes on SAP BEx Queries and SAP BW Infocubes.
• Modified the BOBJ OLAP Universes based on the user requirement.
• Customized the OLAP universes by changing the MDX syntax of prompts and created filters with default values in Universe.
• Used VBA Macros to suppress L00/L01s from the object names in the OLAP Universe.
• Building Web Intelligence reports and charts on SAP Business Objects OLAP Universes. Worked on merging dimensions in WebI Rich client and built reports on flat files.
• Created hyperlinks in WebI to open master detail WebI/Crystal report by passing parameters based on the user selection.
• Worked on complex Crystal Reports based on SAP BEx MDX Queries that require running totals, sub-totals, cross-tabs, multiple groups, sections, drill down, sub reports and conditional suppress of sections to make the reports easier for analysis.
• Built static & dynamic dashboards using Xcelsius 2008 with web service connectors like QaaWS and Live Office and BI Web Services.
• Experience working on BICS in Xcelsius for direct connectivity on BEx Queries.
• Created OpenDoc methodology which provides a jump from dashboard to summary level WebI report then to detail level Crystal Report.
• Effectively administered and supervised the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports through CMC and Infoview.
• Data validations of WebI reports, Crystal Reports and Xcelsius dashboards with SAP BW Infocubes and SAP ECC data.
• Worked on creating test cases in Mercury quality center for testing reports and dashboards.
• Experience in user training and extensively involved in understanding the business needs and technical requirements and delivering the required reports within the deadline.

Confidential, Confidential, PA

Sr Business Objects Developer

Environment: Business Objects XI R3.1/R2 (WebI, DeskI, CMC, CCM, Broadcast Agent, InfoView), Xcelsius 2008/4.5, Crystal Reports 2008/XIR2, Teradata, Oracle 10g, PL/SQL, SQL Server 2008.

Responsibilities:

• Interacting with the Business users to analyze the business process and gathered the requirements. Responsible for producing the functional specifications document by capturing the information from the requirements gathering sessions.
• Analyzed the scope of the Supply Chain Dashboard to categorize the KPI’s and Metrics in to three development phases. Developed test cases for each phase to prepare and execute unit, integration and user acceptance testing.
• Designed, developed and maintained Universes by defining joins and cardinalities between tables in Teradata & Oracle. Addressed cyclic dependencies issue by either applying contexts or creating aliases.
• Extensively used the Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for developing Deski & WebI reports as per the supply chain requirements.
• Used @functions like @select, @where and @prompt to create prompts that help the user to select the values dynamically.
• Designed queries using Query as a Web Service (QaaWS) to fetch data into Xcelsius. Developed dynamic prompts in QaaWS used as an input parameter to filter the data by region and by KPI in Xcelsius.
• Created methodology using Open Doc that will embed multiple SWF files into a parent SWF file in Xcelsius.
• Extensively worked on developing static and dynamic dashboards using Xcelsius 2008/4.5 via the live connectors QAAWS and Live Office. Experienced in migrating dashboards from Xcelsius 4.5 to 2008.
• Experience in migration of Universes & Reports from the 6.1 system to XI R2/3.1 using the Import Wizard. Conversion of DeskI documents to WebI documents using the Report Conversion Tool.
• Proficient in creating BOBJ OLAP Universes on SAP BW Infocubes and BEx Queries and using them in Query As A Web Service(QAAWS) for data loading into Xcelsius.
• Experienced in generating Xcelsius dashboards out of SAP BW data where the data is in the form of BEx Queries and Infocubes.
• Experience in developing and implementing Crystal reports on Business Objects Enterprise XI R3.1/R2.
• Created reports on web using Info View Portal and Web Intelligence, distributed the reports to different users.
• Involved in setting privileges to different user groups coordinating with supervisor and DBA using CMC Module.
• Managed the resources, granted permissions to Business Objects product users, Webi users, managed the connections, universes and repository domain.
• Monitored and solved the issues encountered in Universes and dashboards while migration and testing before moving to production.
• Involved in providing Production support to the end users. Dealt with various user issues/technical problems, providing technical support.

Confidential, Houston, TX

Business Objects Consultant

Environment: Business Objects XI R3/R2/6.1 (WebI, DeskI, SDK, CMC, CCM, Broadcast Agent, InfoView), SAP BI 7.0, SAP Integration Kit, BEx Analyzer, BEx Browser, Xcelsius 2008/4.5, Crystal Reports 2008/XIR2, Oracle 10g, SQL PL(DB2), PL/SQL, SQL Server 2008.

Responsibilities:

• Interacted with the Business Users to analyze the business process and gathered the requirements made necessary changes to schema objects to fulfill their reporting and business needs.
• Involved in Installation and Configuration of all Components of Business Objects.
• Designed new Universes using various @functions, aliases, contexts, user objects and modified the existing Universes based on the report requirements.
• Expertise in creation of WebI & DeskI reports, formatting reports, generation of charts, as per user requirements.
• Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.
• Tuned the queries to improve the performance of the existing reports for various functional areas.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Played a lead role in the migration of content from Business Objects 6.1 to Business Objects XI R2. The migration included:
• Setup and initial configuration of XI R2 on Windows 2003
• Migration of Universes & Reports from the 6.1 system to XI R2/3.1 using the Import Wizard,
• Conversion of DeskI documents to WebI documents using the Report Conversion Tool,
• Created reports on web using Info View Portal and Web Intelligence, distributed the reports to different users.
• Extensively used the Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports.
• Managed the resources, granted permissions to Business Objects product users, Webi users, managed the connections, the Universes and repository domain.
• Made custom components for Flex using Flash.
• Experienced in generating static and dynamic Xcelsius dashboards out of SAP BW data where the data is in the form of BEx Queries and Infocubes.
• Proficient in creating OLAP Universes on SAP BW Infocubes and BEx Queries and using them in Query As A Web Service(QAAWS) for data loading into Xcelsius.
• Extensive experience in developing static and dynamic dashboards using Xcelsius Enterprise 2008/4.5 via the web service connectors QAAWS and Live Office.
• Experience using Crystal reports objects in Live Office which will leverage existing Crystal Reports that are based on SAP BI query as a source for Xcelsius.
• Used open document command to pass a parameter to Xcelsius to filter the data.
• Created Hierarchies, complex objects using various @functions, aliases, contexts, Aggregate objects in the universe. Setup user profiles, created BCAs for groups, Categories and Channels using CMC.
• Worked on complex Crystal reports that require running totals, sub-totals, cross-tab, multiple groups, and Conditional display of groups, Combined Queries, Drill Down, and Master Detail to make the reports easier for analysis.
• Developed Stored Procedures Using Oracle PL/SQL programming to improve the performance of the reports using complex queries.
• Developed universe user documentation guide for the end users reference.
• Involved in providing Production support to the end users. Dealt with various user issues/technical problems, providing technical support.
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.
• Training the end users on using the WebI environment by highlighting the user friendly concepts and the ease in developing Ad-hoc reports.
• Provided the end users with easy to read and understand documentation for the WebI reporting tool.