SUMMARY

• 9+ years of IT experience in Business Intelligence tools including: SAP Business Objects XI3.1/XIR 2/6.5/6.0/5.1/5.0 , Business Objects Designer, Supervisor, BCA, Info view, Web Intelligence, Desktop Intelligence and Xcelsius 2008.
• Experience in SAP Business Objects migration from 6.5 to XIR2 and from XIR2 to XIR3 using Import Wizard, Report Conversion tool, Publishing Wizard, building Universe using Universe Designer, building reports using Desktop Intelligence and WEBI reports(Web Intelligence), experience in working on Central Management Server (CMS), Central Management Console (CMC), Central Configuration Manager (CCM), Auditing.
• Have knowledge in SAP Business Objects Business Intelligence platform 4.0/4.1
• Have knowledge with new version of business objects with tools BI Launch Pad, SAP Business Objects Dashboard Design, SAP Business Objects Interactive Analysis, Information Design Tools and Universe Design Tool
• Good skills in data modeling. Expertise in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, fact and dimensional table design, physical and logical data modeling.
• Performed several full Lifecycle implementations of Business Intelligence products.
• Interactions with the executive team for the latest trends in BI and evaluations and recommending and implementing the best practices.
• Utilized the team resources, developed the plans, designed the architecture and completed various implementations.
• Designed the architecture of the Application, data models and structures and made them efficient to the business model.
• Experience building Xcelsius dashboards, universes, retrieving data using universes, SAP personal data files, stored procedures, free hand SQL methods and creating complex ad hoc reports using the Business Objects and Web Intelligence modules.
• Have knowledge on the PL/SQL for doing quality review of the developed reports and dashboard. Also used while troubleshooting production issue or for doing performance tuning of reports.
• Set up the dimensions, roll ups and hierarchies in the planning applications.
• Have knowledge of web publishing and scheduling documents using broadcast agent. Managed resources such as universes, repositories and distribution of documents.
• Created complex reports by linking data from multiple sources using functionalities such as: combined queries, slice and dice, drill down, master detail.
• Involved with the identification of facts, measures, dimensions and hierarchies.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to a vast users for viewing, creating and publishing reports and implement Row and object level restrictions.
• Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections).
• Responsible for Created user - groups in CMC and implemented the security model on the groups created.
• Developing effective QlikView data models.
• Developing front end applications using QlikView technology.
• Utilizing scripting language to meet complex business requirements.
• Utilizing QlikView Publisher capabilities.
• Excellent leadership, technical, logical, and problem solving capabilities.
• Ability to adapt to changing professional work environment to implement software solutions in an efficient manner
• Had inlvove in POC and presales kind of activities for new project initiatives.
• Excellent writing and oral communication skills, Sales, management, billing, reporting and executive writing skills.

TECHNICAL SKILLS:

Business Intelligence(ETL/BO): SAP Business Objects Business Intelligence platform 4.0/4.1BI Launch Pad, SAP Business Objects Dashboard Design, SAP Business Objects Interactive Analysis, Information Design Tools and Universe Design ToolSAP Business Objects XI3.1/XIR 2/6.5/6.0/5.1/5.0 , SAP BO Designer, SAP BO Desktop Intelligence (DESKi), SAP BO Web intelligence (WEBi) and SAP BO Rich Client, Import Wizard, Report Conversion Tool, Central Management Console, Business Objects Xcelsius 4.5/2008QlikView, Developing effective QlikView data models, Developing front end applications using QlikView technology. Utilizing scripting language to meet complex business requirements and utilizing QlikView Publisher capabilities.IBM WebSphere DataStage Designer, Adminsitrator

RDBMS: Oracle 9i/8i, SQL Server 2008/2005, IBM DB2 8/9PL/SQL

Methodologies: Star Schema, Snowflake schema, Kimball, Immoh

PROFESSIONAL EXPERIENCE:

Confidential

Business Objects Technical Lead

Environment: SAP BO XI 3.1, Qlikview, IBM DB2 v8, IBM Datastage 8.x, MS SQL Server 2008, SAP Xcelsius 2008

Responsibilities:

• Past 4 years working on many end to end different projects developing data marts for various reporting projects. Designing, developing and testing of reports, dashboard and in some cases ETL jobs in different parts of the operations team at bank.
• Primarily responsible for Reports/Dashboard deliverables for the reporting projects which falls inConsumer/Retail LOB.
• Flexible enough to play different roles according to the requirement of the projects.Analyzer/Designer:
• Gather business requirements and translate them into technical design and documentation used for Development.
• Understanding the Business requirements from application development perspective and develop reporting datamart.
• Get involve in concept definition sessions for gathering requirements and provide inputs on the architecture and design of system. Also understand the reporting needs of the clients and design efficient reporting data marts.
• To use the Visio or the Microsoft excel for designing the logical model for the project.
• Work with manager on new business initiatives and planning along with the resource management.
• Co-ordinate development, testing effort with offshore team and production deployment.Developer:
• SAP Business Objects - WEBi, DESKi, Xcelsius, Designer using these tools have built reports/dashboards for fulfilling business requirements
• Based on the Data mart, designed and developed a Business objects universe using custom hierarchies, Solved Join Path problems like loops, Fan Traps and Chasm Traps using alias and Contexts, Used Aggregate awareness and Index awareness for performance tuning. Build Linked universes using Kernel approach.
• Created several canned as well as adhoc customer reports and worked on requirement for designing and development of complex reports.
• Generated analytical reports using Slice and Dice, Drill down, Cross Tab, complex formula using @Functions and @Prompts, use of graph and charts.
• Developed reports from multiple data providers and used merged dimensions.
• Report link is implemented using Open document functionality so multiple reports can be interlinked within each other logically.
• To work with the team in optimizing the existing code in production an also make team follow new learning into the new developments. Ex: Query Tuning using Aggregate Awareness, Short Cut joins, Custom SQL at Universe level for faster retrieval of data and better reporting performance. Also working with DBA's to perform tuning at Table level by creating index.
• Highly Interactive Dashboard completely based on dynamic user input and varying amount of information to analyze without limitations being provided to the user.
• To create Static as well as Dynamic Xcelsius dashboard, with Live Office, QaaWS, Flash Variables in backend as per the new requirement and support the existing dashboards.
• Dashboards Using Advanced Multiple Drills Down, Dynamic Visibility, and Alert Features were designed to support Complex Requirement Scenario.
• Designing and implementing a parallel and server jobs also implemented SCD logic.
• To design the ETL mapping document (Low Level Design) for the source table to target tables (data mart tables).
• Providing input on proposing, evaluating, and selecting appropriate design alternatives which meet requirements and are consistent with our current standards and processes
• Extracting, transforming and loading data into QlikView applications
• Developing, testing, debugging QlikView applications
• Migrating code across development and testing landscapes
• Creating publisher jobs

Confidential

Senior Business Objects Developer

Environment: SAP BO 6.5, BO XI R2, DESKi, WEBi, Designer, Oracle 9i

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications for business objects universes and reports.
• Created Universe level objects and measures using the business rules provided.
• Setting up the security levels to the users in universe module like row level and object level security.
• Designed and developed the Functional Analysis and Technical Design like Joins, Shortcut Joins, Contexts, and Cardinalities of the tables and structures of the Universe.
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies like fan traps and chasm traps.
• Importing and Exporting the Universes to repository to make it accessible to end users.
• Extensively used QAAWS to retrieve the SAP BI data from the universe objects.
• Interacted with the Business Analysts to gather the requirements and developed prototypes in the form of PDF’s or Power Point Slides of the Dashboards for the initial presentation to the users.
• Developed WEBI reports in Business Objects XI R3.1and Xcelsius Dashboards in Xcelsius 2008.
• Developed multiple dashboards so that the user can navigate from one dashboard to the other.
• Expertise in developing drill down reports and hyperlinked reports.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data providers.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Created multiple Flash variables in Xcelsius and used them to pass data from one dashboard to other.
• Resolved the production tickets within specified time lines.
• Used multi value components like line charts, bar charts, stacked column charts and combination charts, and single value components like gauge, slider, dial and progress bars in the development of the Dashboards.
• Extensively used slice and dice, filtering and ranking to create cross tab and master/detail reports.
• Involved in formatting sections, tables, inserting and organizing multiple breaks.
• Extensively worked on drill mode to view data in different Perspectives.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors etc.

Confidential

Consultant

Responsibilities:

• Installed and Configured Business Objects on Both Client and Server Installations.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Converted reports from 6.5.1 to XIR2 using the report conversion tool.
• Created user defined @prompts and complex conditions at Universe level for better performance.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Generated Reports from Different Data Providers in Business Objects using Oracle Database.
• Created Compound Analytics, Charts and Goals on the Dashboard Manager.
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements.
• Created Cascading Prompts on the Reports.
• Implemented Filters, conditions in the Universe to the run the Reports quickly.
• Created single sign-on for many reports using the URL functionality to access them directly for upscale users.
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Created Views, Stored Procedures and validated data for the Performance.
• Created hundreds of reports in thin client and full client using all the functionalities
• Used the Export option for the Reports to schedule them in Broadcast Agent Server and sent the scheduled reports via Email, Text and Excel formats.
• Used the Broadcast Agent Server to Schedule and Monitor the Reports.
• Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.
• UAT was one of the important processes that we had developed during this project.
• Creation of complete security model with rights according to Business Requirement.
• Creating new Universes as per Business Requirement in BO 6.5 as well as in BO XIR2 and also make modification in the existing Universes
• Resolving join path problems (solving loops & traps)
• Migration of existing repository objects to BO XIR2 and carrying out UTP for same
• Create reports based on universes, personal data providers and stored procedures, using complex sub- queries, linking data providers, in DESKi as well as in WEBi.
• Created WEBi reports having the drill features with different scope of analysis
• Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections).
• Responsible for Created user-groups in CMC and implemented the security model on the groups created.
• Scheduling of Event based reports, Publications, Program Objects, Object Packages, etc.
• Performing Single-Pass report Bursting (i.e. Publication) for reports displaying granular level data

Confidential

Report Developer

Responsibilities:

• Involved in the Requirements gathering, Development, UAT, and Production support phases of Business Objects Report development.
• Installed the Business Objects version 5.1.3.
• Involved in preparation of Detailed Design Documents
• Generated the Business Object Reports using the universes as the main Data provider
• Developed complex queries including Sub queries, Unions, Intersect and Aliases
• Created User Objects including Dimensions, Details and Measures
• Reports were formatted to the users according to the user requirements using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, @Functions and Formulas
• Created Master Detail and Cross Tab reports to view the data in an analyzed way
• Involved in the creation of Prompts for Fiscal Year, Quarter and Date range
• Organized data in the reports inserting Filters, Sorting, Ranking and highlighting data using Alerts
• Extensively used Designer to design various universes for different business groups.
• Created complex reports using cascading prompts, decode objects, etc.
• Created user groups and managed access privileges using Business Objects Supervisor.
• Designed, built, maintained Business Objects universes and repository.
• Extensively used Web Intelligence Info view for exploring querying, reporting and analysis tasks.
• Used Broadcast agent for scheduled, batch processing of Business objects and Web intelligence documents. Scheduled daily/monthly reports and performed report bursting using Broadcast Agent Server
• Designed, built, and maintained Business Objects universes.
• Authorized user access to one or more universes, created restrictions on objects and classes based on universe privileges.
• Created prompts in report to restrict data fetch and ease data load.
• Developed various metadata and operational definitions.
• Customized Business Objects web interface (intranet) to access the enterprise reports developed in Business Objects full client.
• Troubleshoot the problems and customized the reports according to the specifications of the analysts.
• Extensively used Web Intelligence Info view, reporter and explorer for querying.
• Created detail and summary reports, used to fold/unfold sections corresponding to breaks in current blocks.