SUMMARY

• 8 years of experience with Business Objects (BOBJ) XI R2, 3.0, 3.1 and 4.0, Crystal Reports XI R2/2008, Xcelcuis 2008/Dashboard Design and hands on experience with IBM Information Server / Datastage ETL / Informatica ETL.
• Performing business objects lead role for Business Objects Systems Migration (XI R2 to 3.1 to 4.0), Report/Dashboard development projects
• Performing business objects administrator role for Business Objects System Migration Projects and Production Systems handling more than 500 users
• Experience with DB2, Oracle & SQL Server relational databases & data warehousing systems
• Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using IBM Information Server Datastage ETL / Informatica ETL
• Expert in designing, developing, maintaining and optimizing the Universes using Designer module.
• Designing, developing and modifying BOBJ universes and expertise in creating various complex web, desktop Intelligence reports for business users scheduling the processes and administering the BOBJ activities using Central Management Console CMC.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks by linking the data sources from multiple providers.
• Expertise in working with all the modules of Business Objects like Supervisor, Designer, BO User, Web Intelligence, Desktop Intelligence, CMC, CMS, BCA, BO SDK and Crystal Reports.
• Excellent experience in creating interactive & executive dashboards using Dashboard Design, Xcelsius 2008 on relational databases.
• Extensive experience in designing Xcelsius dashboards using web service connectors QaaWS, Live Office and BI Web Services.
• Substantial experience in Business Objects Migration (XIR 2/3.0/3.1/4.0 ).
• Effectively administered and supervised the Business Objects environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• Knowledge about Business Objects Security Model and experience with Business Objects Security Implementation (Row level, Object level and Command level).
• Extensive experience in migrating Single/Multi Server deployment on Windows/Linux from XI R2 to Business Objects Enterprise (BOE) XI 3.1 and XI 3.1 to 4.0 and importing R2 deployment into 3.1 to 4.0
• Experience in creating folders/categories, users groups and setting user rights and managing security in Central Management Console (BOXIR3, BOXIR2) and BI 4.0.
• Experience with Installing and Administration of entire hardware, and software products like Tomcat, and Apache (Clustered and Standalone environments).
• Installed and tested the BI4.0 application.
• Worked with server team to provide them with list of specifications need to build the servers for BO 4.0.
• Worked with Developers to consolidate the Business Objects repository before migrating to BO4.0.
• Strong experience in advanced Document Scheduling using Broadcast Agent, distribution and troubleshooting including: Report Bursting, publishing over the World Wide Web, creating and managing Categories using Info View and Broadcast Agent.
• Excellent experience with DW concepts such as star schema, snowflake schema, fact and dimensional tables.
• Strong of experience analysis, design, development and implementation of Relational database and Data warehousing systems using IBM Datastage 8.0/8.1 (Information Server, Web Sphere).
• Excellent experience in designing, developing, documenting, testing of ETL jobs and mappings in server and parallel jobs using Datastage to populate tables in Data warehouse.
• 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

Business Objects Lead /Administrator

Environment: Business Objects (BOBJ) XI 4.0/R3.1 SP5/R2 SP1 (BI launch pad, Universe Design tool, Promotion Management tool, Central Management Console, Web Intelligence, Web Service Query, Version Management, Auditing, Information Design Tool - IDT, Dashboards, Universe Designer, WebI Rich Client, CMC, InfoView), Dashboard Design 6.0, Xcelsius 2008, Oracle, DB2 8, 9 and 10, Red Hat Linux 4 & 5, Tomcat 5.5, IBM Data stage ETL

Responsibilities:

• Understand business functional requirements and reporting tool functionality; synthesize the requirements and business intelligence capabilities into functional specifications; prepare technical specifications; and develop and test the final product. The solutions contain ad-hoc query, drill-down, slice and dice capabilities, static reporting, managed queries, and dashboards
• BO Upgrade from XIR2 to BI 4.0 and also responsible for applying service pack and fix pack to BO installation and also deployed WAR files after upgrade.
• Ensured all the environments are in synchronization and checked supported environments and hardware requirements from the Products Availability Report (PAR) document for the new installation.
• Identify the servers for Installation, Decluster the server without Apache Tomcat installation. Test CMS and CCM of independent servers, Performed Parallel installation BOXIR2, BOXIR3 and BI 4.0 on a Clustered environment.
• Uninstalled BOXI R2 from the server to install and Removed Registry Entries with keywords such as Business Objects, business objects, busobj, bobj, Crystal Decisions, Designer, Desktop Intelligence, Web Intelligence etc before the installation.
• Transferred CMC data between old (XIR2) and new version either through CMC/BIAR File/Import Wizard.
• Migrated Universes, Reports, and Securities from the Development to Production environment after System Integration Testing (SIT) and then followed by Customer Acceptance Testing (CAT). Used Import Wizard for the Migration process across the environments.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users, creating and publishing reports and implement Folder and object level restrictions.
• Importing the groups and users from windows Active Directory into Business Objects and granting the users and groups with appropriate rights trough Central Management Console.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users
• Designed and maintained Universes on DB2 tables by defining joins and cardinalities between tables. Addressed cyclic dependencies issues by either applying contexts or creating aliases.
• Created reports using Business Objects functionalities like queries, slice and dice, drill down, cross tab, master detail reports, formulas, etc using BI Launchpad and Web Intelligence Info View.
• Used various @Functions like @Aggregate Aware, @Prompt, @Script, @Select, @Variable and @Where
• Used hierarchies in Universe level and used Scope of analysis in report level to drill up and drill down the reports.
• Designed .unx universes in Information Design Tool (IDT) for use of Dashboard Design (Xcelsius), which eliminates the use of QaaWS tool.
• Built Xcelsius dashboards using Live Office, QaaWS and BI Web Services for live data connectivity.
• Optimizing Universe - Analyze the report SQL for unnecessary joins, Analyze report query for indexes, Use Aggregation for measures, Use partitions for high volume fact tables, Configured Array fetch size in Universe Options screen, Universe Analysis for Shortcut joins which play important role in performance, Index Awareness, Universe cleaning (make sure LOV is disabled for measures & unnecessary dimension objects) and Try evaluating join by sql universe parameter
• Used the Promotion Management to import existing user accounts, groups, categories, WebI documents, universes, connections and universe restrictions to BI 4 environment.
• Used Publishing feature to send daily/invoice e-statements to huge number of users
• Created Access Restrictions for individual users/groups with Connections, Controls, SQL, Objects, Rows in the universe and Row Level Security for users using Where clause
• Provided end user and production support after deploying the application into the production environment.

Confidential

Business Objects Lead /Administrator

Environment: Business Objects (BOBJ) XI 4.0/R3.1 SP3 (WebI, DeskI, CMC, InfoView), BI Launch Pad 4.0, Xcelsius 2008, Oracle, DB2 8, 9, 10, Red Hat Linux 4, 5, Tomcat 5.5 and Datastage ETL

Responsibilities:

• Work in conjunction with Solutions Program Manager to ensure project team deliverables as assigned are completed accurately and on schedule in accordance with the project plan.
• Designed and maintained Universes on DB2 tables by defining joins and cardinalities between tables. Addressed cyclic dependencies issues by either applying contexts or creating aliases.
• 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
• Involved in the creating the reports using BI Launchpad and Web Intelligence Info View. Created the Reports (Master/Detail, Brake, Cross Tab, Chart, and Templates) in Business Objects using the Universe as the main Data Provides and writing the Complex queries including Sub-Queries.
• Used the Publishing wizard to export different document types as objects to different folders in CMC.
• Created reports prototypes using Web Intelligence BI 4 for user presentation.
• Trained the Business Users in report creation and also new features of Business Objects BI 4.
• 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 Xcelsius dashboards using Live Office, QaaWS and BI Web Services 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 coordinating with supervisor and DBA using CMC Module.
• Worked on scheduled and On-demand dashboards for Gaming Data using 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

Business Intelligence Lead Developer

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

Responsibilities:

• Involved in requirements gathering from the business users to build the reporting application.
• Closely worked with business stakeholders as well as the BI Application Team developers and analysts to develop guiding principles and best practices
• Designed Universe by creating the Business Objects Data Model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects like Dimensions, Details and Measures which are grouped into Classes and checked the integrity of the universe.
• Created Hierarchies to setup dimensional hierarchies for multidimensional analysis
• Created Customized Hierarchies, complex objects using various @functions, Aggregate objects in the universe.
• Used Aggregate Navigation to setup alternate aggregate tables and used to specify incompatible objects
• Defined Customized LOVs, Predefined Conditions, Dynamic Filters and Dynamic Conditions in universe. Examples, Select Trailing N Weeks, Prev Year 1 Weeks Sales, 1 Week Sales, Prev Year 13 Weeks Sales, 13 Week Sales, Prev Year 26 Weeks Sales, 26 Week Sales, FYID (Previous), FYID (Current), Enter Date Range (Last Week), Cal Week To Date, Cal Month To Date, Cal Qtr To Date, Cal Year To Date
• Designed cascading prompts in the universe to filter the list of account names based on the business units.
• Created reports using Business Objects functionalities like queries, Slice & Dice, Drill Down, Cross Tab, Master/Detail and Formulas etc.
• Created & Used Linked universe to get core classes/objects - Kernel approach (core universe is not hidden), Master approach (core universe class & objects are hidden according to relevance), Component approach (merging 2 universe to one) - universes are linked in Universe Parameters screen
• Used derived tables - created nested derived tables using @DerivedTable and its advantage create derived table using already created derived table
• Resolved Chasm traps, Fan Traps & Loop problems.
• Used hyperlinks in webi to open another report, dimensional hiding/conditional column hiding on webi reports
• Used Scope of Analysis and Drilling - Single Dimension Drilling in Headings, Multiple Dimension Drilling in Cross Tabs & Drilling in Charts
• Used Scope of Analysis in report level & Custom Hierarchies in universe level
• Designing Xcelsius dashboards using web service connectors QaaWS, Live Office and BI Web Services.
• Created users and groups and applied row level and objects level securities using Central Management Console.
• Performed universe optimization for universes existing/newly created.
• 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.
• Develop departmental design policies and procedures.
• Address and resolve routine design issues using standard issue resolution methodologies.
• Identify opportunities for continuous improvement of design, development, and integration processes.

Confidential

Business Intelligence Lead Developer

Environment: Business Objects XI R3/R2 (WebI, DeskI, SDK, CMC, CCM, Broadcast Agent, InfoView), Xcelsius 2008/4.5, Crystal Reports 2008/XIR2, SQL Server

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.
• 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.
• Extensive experience in developing static and dynamic dashboards using Xcelsius Enterprise 2008/4.5 via the web service connectors QAAWS and Live Office.
• 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 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.

Confidential

Business Intelligence Developer

Environment: Business Objects R2 (WebI, DeskI, SDK, CMC, CCM, Broadcast Agent, InfoView), Xcelsius 2008/4.5, Crystal Reports 2008/XIR2, IBM DB2 8.1, DB2 PL, Red Hat Linux 4 and Tomcat 5

Responsibilities:

• Worked extensively with the Business Analyst team in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.
• Exported universes to the Repository for making resources available to the users.
• Extensively used the Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports.
• Designed, developed and Maintained Universes by defining joins, and cardinalities between tables. Addressed cyclic dependencies issue by either applying contexts or creating aliases.
• Involved in designing brand new universes in the BO XI R2 environment. The universes were designed to satisfy both Ad-hoc and canned reporting purposes.
• Used @functions like @select, @where and @prompt to create prompts that help the user to select the values dynamically.
• Analyzed migration strategies for Business Objects Universes and reports across multiple Business Objects Repositories (Development, QA and Production).
• Migrated from Business Objects earlier versions to XI R2.
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.
• Created many complex WebI and full client reports which include special field, user variables and complex calculations using report level contexts (In context & Out Context).
• Developed, tested and implemented new DB2 PL, Functions and Stored Procedures, Triggers etc.
• Scheduled jobs and reports through Broad Cast Agent server for automation on timely fashion, Daily, Monthly reports, file watcher reports.
• Involved in providing Production support to the end users. Dealt with various user issues/technical problems, providing technical support.
• Responsible for coding, unit testing, design and code review and maintaining system documentation.
• 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.
• Recommended and implemented design changes to warehouse, fact tables and indexes to improve query performance.

Confidential

Business Intelligence Developer

Environment: Business Objects XI R2 Enterprise, IBM DB2 8.1, Windows 2003 Server, Informatica 7.1.3

Responsibilities:

• Work closely with Business Analyst team to create the necessary BO reports to replace the existing legacy system reports, creating detailed templates for Business/users needs and educate them to utilize the report for business requirements, Adhoc, report modifications, BI query objects.
• Administrate and Configure Business Objects Environment with respect to the project plans.
• Administration of Business Objects environments including monitoring, security administration, performance management and capacity planning. Administrate user privileges, user groups and Universe development.
• Designed the conversion project for the existing Legacy Reports in to the Business Objects Webi Reports and work closely with Architects to upgrade the existing BO version to BO XI R2 system. Interpreted meaning and relevance from raw data and perform detailed analysis and transforming in to the powerful Webi Reports.
• Responsible for gathering and conducting analysis, developing functional & technical designs solutions. Coding, Reviewing, Formatting, Testing, Bug fixing & Integration with different classes. Analyzing system functionality requirements, documents and scope of the work.
• Schedule jobs and reports through Broad Cast Agent server for automation on timely fashion, Daily, Monthly reports, file watcher reports.
• Perform Unit test, UAT, Smoke test on the reports. Perform complete analysis on the life cycle of the project. Forecasting the issues, Project evaluation, Report usability and analysis.
• Data quality testing, assisting with user acceptance testing. This includes in building enhance and deploy new and existing Business Objects reports/universes as required as well as assist team in delivering complex Adhoc analysis and reports via the data warehouse.
• Worked Extensively on Informatica (Designer, Workflow) for data extraction, transformation and loading.
• To analyze inputs and devise strategy based on best practices and future supportability.
• Assist my team members in troubleshooting, diagnosing and resolving complex Business Object problems to ensure high performance and minimal disruption of critical systems.
• Creation of technical and user documentation preparation of Migration document from development environment to production system.
• User Training on ad-hoc reporting and Demonstrations for various universes at sites.

Confidential

BO Reporting Developer

Environment: BO 5.1.6, BOE XI R2, DB2, Microsoft Windows Server 2003

Responsibilities:

• Attended user meetings to clarify/analyze the user requirements.
• Migrated the reports, universe, universe connections, users, user groups, folders, events, calendars, server groups, servers using the Import wizard from BO 5.1.6 to BO XI R2.
• Updated User groups and granting user rights to users.
• Migrating the universes, reports, documents from DEV to QA to Prod using import wizard.
• Converted Desktop report to Web reports using report conversion tool.
• Designed, developed and managed universes.
• Used optimization strategies for improving the performance.
• Created new classes & new objects in designing the universes, Importing/Exporting the universe from/to repository to make it accessible to end users.
• Created metrics and dashboards/ Performance management for high level management for the analysis of the business.
• Created the Business Objects reports (webI, deskI) for analysis, and forecast.
• Scheduled reports on daily and weekly bases.
• Performed both unit and integration quality assurance testing prior to release.
• User Training on ad-hoc reporting and Demonstrations for various sites.
• Attending user calls and finds solutions to high-level issues (on-call support).

Confidential

Enterprise Series Database/PL Lead Developer

Environment: Linux 4.2 Update 4, DB2 9.1 Fix Pack 2, Apache HTTP Server, Jakarta Tomcat Connector Module, JBoss Application Server, Apache Ant, C, J2EE, and FaircomCtreePlus servers.

Responsibilities:

• Analysis of the existing system functionalities.
• Analysis of the new requirements that is specific to the Lotteries.
• Design, development and implementation of the new functionalities for the Washington Lotteries.
• Writing the test cases and Unit testing.
• Making the host code to interact with Terminal and the ESIPS GUIs.
• Releasing the software to the QA system and the customer acceptance testing and providing the technical support.