SUMMARY

• Over 7 years of experience in Business Intelligence with 6 years of Business Objects XI R3.1/ R3/ R2/6.5, Designer, Desktop Intelligence, Web Intelligence Rich Client, Info View, Dashboard Manager, Central Management Console, Crystal Reports 10/2008, Crystal Xcelsius 4.5/2008, Query As A Web Service, Live Office and 1 year Experience in BI 4.0.
• Experience in Designing, Building Universes with Multiple Fact Tables and Created Measure and Dimension Objects, Join conditions, Filters, LOV’s, designing complex objects using @variable, @prompt,@ Aggregate aware functions as per the universe best practices using Designer and Information Design Tool.
• Experience in resolving the issues like Loops and Traps using Alias and Contexts using Business Objects Designer.
• Strong Experience in Data Modeling and ETL(SSIS, SSAS, Informatica, SAP BW) Process/Job/Scheduler.
• Created Derived Tables and Aggregate Tables to improve the performance of the query.
• Hand On experience in linking the universes and implementing column and row level security in the universe.
• Extensively involved in Creating Adhoc & Canned Reports from multiple Data Providers.
• Strong Knowledge in Creating DeskI and WebI Reports by using various Business Objects functionalities such as Tracking, Drill, Sort, Filters, Ranking, Graphs, Sections and Breaks.
• Strong Knowledge in writing complex logic SQL/P SQL Queries.
• Knowledge of Creating Complex reports by linking data from Multiple data providers using the functionalities like Combined Queries.
• Scheduling and Publication Reports using Business Objects Info View.
• Strong Experience in Creating Crystal Xcelsius Visualizations by fetching the data using Query As A Web Service (QAAWS), Live Office into the Xcelsius Dashboard.
• Worked on Crystal Reports 2008/10 and extensively used conditional formatting and complex formulas to create various reports and used Business Views for Dynamic prompts.
• Utilized DI Designer for designing the ETL jobs and scheduled through the job server.
• Experience with Data warehouse and Data Marts like Star schema and snowflake schema, Fact and Dimension tables.
• Excellent understanding of Normalization (OLTP) and De - Normalization (OLAP) of schemas designed star schemas with snow flake dimensions.
• Extensive Knowledge in all phases of Software Development Life Cycle (SDLC) like Developing, Testing, Migrating, Administrating, Security Management and Production Support in Business Intelligence.
• Working Experience with Health Care, Investment, Insurance, Pharmaceutical and Retail Clients.
• Extensive experience in administrating and supporting Business Objects servers and services.
• Good knowledge in overall BO XIR 3.1/3/2/6.5 application architecture and able to design, deploy, support the application architecture.
• Created a Clusters, deployed application on the server, Configured WindowAD and administered Single Sign On (SSO).
• Created/Administered Users & Groups designated their Security Levels in CMC, assigned Roles, & Access Levels on the applications and folders.
• Experience in Migration of reports from BO XIR2 to BOXI3 and BI 4.0 and successfully resolved the issues after the migration.
• Creating Custom, Schedule & File Based events to support Scheduling of Reports.
• Good analytical and documentation skills with ability to communicate at all levels.

TECHNICAL SKILLS

Languages: MaxL, ESSCMD, C, C#, ASP.NET

OLAP Tools: Business Objects XI R3/ R2/ 6.5, Designer, Deski, Webi, InfoView, Crystal Reports 10/2008/XI, Crystal Xcelsius 4.5/2008, Query as a Web Service, Live Office, SAPBW, Dashboard Manager, CMC, CMS.

Database: Essbase, SQL Server 2000/2005, Oracle 9.x/10.x, Teradata and MS Access

Data Modeling: Star Schema (ROLAP), Snow flake schema

Software Applications: MS Office, Informatica Power Center.

Markup Languages: HTML, DHTML, XML

Operating Systems: Windows XP/2003/2000/NT/98, MS-DOS, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

Responsibilities:

• Migrated complete Data warehouse data marts from XI R2 to 3.1 SP2 and finally with migration wizard migrated to SAP BI 4.0 with installation of patches.
• Configured all the Core Servers in CMC to improve the server performance and also configured .XML files in tomcat and web app folder.
• Gathering Requirements, Drafting specifications, Design, Development, User Acceptance Testing and Production Roll Over.
• Involved in Clustering, Load Balancing and network configuration of Business Objects Servers
• Good understanding and involved in installing and deployment of SAP BI 4.0 and Business Objects XI R3.1 on all windows platform.
• Strong Business knowledge in Transportation, Sales, Accounts Payable and Receivable, Freight Rate System, HR Data.
• Set up SSO with Window AD authentication for Business Objects users.
• Established user groups and users and assigned privileges and managed the complex user security in the universe and in CMC.
• Created Universes for Adhoc reporting from scratch using Business Object Designer and Information Design Tool with more than one connection,(project, data flow, cnx, cns and business layer)
• Developed Complex universes, custom and canned Web Intelligence reports and Multi Tab Dynamic Dashboards
• Involved in creating Star Schema for Multi-Dimensional modeling within an enterprise wide Data warehousing effort.
• Created complex prompts at the universe level like @prompt, @select, @where, @variable and @aggregate.
• Interacted with end users, regularly in order to generate the reports required. Various Business Object reporting functionalities were used such as Slice and Dice, Master/detail, User Response function and different Formulas
• Created Complex Dashboards and Score Cards using using Crystal Xcelsius.
• Created several Webi, Xcelcius Reports and Dashboards based on user requirements.
• Created dashboard visualization by using the Xcelsius 2008 by fetching the data through Live Office, Query as a Web Service and Flash Variables.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill down, Cross tab, Master detail, Merge Dimensions etc.
• Created a complex filters Date range, YTD, QTD and MTD
• Generated List of Values (LOV’s) from lookup tables for Web Intelligence reports.
• Created classes, aliases, simple reports and complex reports using cascading prompts, objects, etc.
• Developed reports using filters, prompts, sorts, groups, free hand SQL and multiple data providers.
• Worked extensively with (@select, @aggregate aware, @where, and @prompt) to overcome the problems with database when integrating with Business Objects.
• Expert in managing System Management Tools like CCM, CMC, Import Wizard and Publishing Wizard
• Involved in the ETL team for performing the transformations rules.
• Creating aliases, contexts to resolve loops, cardinalities and integrity checks of the universe.
• Involved in Knowledge transfer and conducted user training sessions for the end users.

Environment: Business Intelligence, Business Objects XI 3.1 SP2 / XIR2, Oracle, SQL server, DB2, Outlook, MS Excel and MS.

Confidential, IL

Business Objects Developer/Administrator

Responsibilities:

• Gathering Requirements, Drafting specifications, Design, Development, User Acceptance Testing and Production Roll Over.
• Interacted with end users, regularly in order to generate the reports required. Various Business Object reporting functionalities were used such as Slice and Dice, Master/detail, User Response function and different Formulas.
• Created new Business Objects users and User Groups using Business Objects CMC Module.
• Business Object Universe, Business Objects Reports and Business Objects repository were used extensively.
• Created Universe level objects and measures using the business rules provided.
• Involved in Administration of Business Objects.
• Deployed Scheduled, Published, Developed and tested reports on BOXI R3.1 Production Servers.
• Maintained user security on the BO Universes.
• Web I Reports are created and deployed through Info View and Customized Webi Front end.
• Complex Crystal XI Summary as well as Detail reports are created based on business request.
• Created Auditor reports and tracked user access of reports and Universes.
• Created Dashboards and Speedo meters for churning analysis-using Xcelsius.
• Customized the dashboards for better manageability of overall performance
• Performed data validation and analyzed test results.
• Maintained and Applied patches to Development, UAT and Production Servers to keep them in sync.
• Worked with Business Users to develop system requirements, analyze data Elements and continuous end-user support.
• Used scheduler to run recursive reports Daily, Weekly, Monthly as requested by the end users and stores the output in their inboxes.
• Created numerous Alerts that are executed based upon certain conditions.
• Extensively involved in creating Parameters and Record Selection Formulas to allow the users to filter the Data using Crystal XI.
• Created different categories to simplify it to the users to locate the reports.
• Utilized DI Designer for designing the ETL jobs and scheduled though the job server

Environment: Business Objects XIR3.1, Crystal Reports XI/10, Xcelsius, InfoView, Universe Designer, SQL Server2008

Confidential, Deerfield, IL

Business Objects Consultant

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Involved in gathering, analyzing and documenting business requirements and translated Business requirements into Functional requirements.
• Headed the offshore team of Reports Developers, developed the reports as well as got them done by team on time for the releases.
• Designed, developed and managed Universes in Business Objects Designer for generating Adverse Event reports for Pharmacovigilance department.
• Worked with Crystal Reports for creating complex reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with Dynamic LOV.
• Resolved issues related to performance of LOV’s and Reports.
• Created Xcelsius Visualizations and published them to business objects Enterprise, which showed key performance indicators graphically.
• Created Dashboards using Dynamic data from data source options such as query as a web service and live office.
• Using live office imported Web Intelligence reports in Excel and Created Xcelsius visualization based on these reports.
• Extensively used CMC (Central Management Console) for the creation of Users, User groups, Folders and granted permissions based on their usage levels.
• Responsible for managing BO Servers, Sessions and Licensing using CMC (Central Management Console).
• Responsible for scheduling of Business Objects reports to SharePoint as PDF and XLS.
• Trained developers on steps involved in actuating reports, universe and user’s across different environments like DEV, QA and PROD.
• 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.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
• Documented the steps of installing and configuring the Business Objects Enterprise for the IT department to build the servers when we have releases.
• Developed Universe user documentation guide and System Design Specification guide for the end users reference.

Environment: Business Objects XI R3 (CMC, Designer, Deski), Webi (Reporter, Info View), Crystal Reports, Xcelsius 2008, Oracle 10g, Tomcat, AQT.

Confidential, Arlington, VA

Business Objects Developer/Administrator

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.
• Involved in planning strategies for upgrading Business Objects from R2 to R3.
• Installed Business Objects XI R3 & Tomcat on Unix Server and configured the same.
• Led a migration from Business Objects XI R2 to Business Objects XI R3 for the department IT. The migration included:
• Involved in design of architecture to support full-lifecycle development of universes and reports.
• Setup and initial configuration of XI R3 on Windows 2003 using Oracle as the repository database.
• Migration of content from the XI R2 system to XI R3 using the Import Wizard.
• Conversion of Desktop Intelligence documents to Web Intelligence documents using the Report Conversion Tool.
• Integration of XI R3 with Windows Active Directory for authentication.
• Mapping of the XI R2 security requirements to the XI R3 security model.
• Set up Windows AD and SSO authentication for Business Objects users.
• Designed, developed and managed Universes in Business Objects Designer for generating the pay roll reports for sales, marketing reports for marketing group users.
• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Responsible for creation of various reports which includes weekly reports, bi-weekly reports, reports by Group, reports by Product and Sub-product.
• Created Ad-hoc reports using Business Objects functionalities like Cross Tab, Master Detail, Slice & Dice and Drill Down, etc.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Defined Aliases and Contexts to resolve loops in the universes.
• Addressed Chasm trap and Fan Trap using Multi Parse SQL
• Created and worked on Row level security, Object level security using Designer and various predefined security settings depending upon users and group needs using CMC.
• Created several users and groups inside the CMC and implemented the access levels as per the best practices.
• Responsible for documentation of various stages in development including Design, debug, maintenance etc.
• Linked the Universes to share common objects. Updated and maintained Universes based on changing user requirements and data source changes.
• Developed Xcelsius presentations/visualizations for profitability Analysis, Distributor Sales Analysis, Monthly Sales Analysis, Forecasted Sales What if Analysis.
• Interactive visualizations were made for executives to visually evaluate different scenarios by adjusting key variables.
• Built multi variable what-if analysis bar charts for all information at one glance about all product lines of the company.
• Key player in improving the performance of the Business Objects reports.
• Involved in trouble shooting of various reporting errors.
• Created Business Objects reports, Queries with constant interaction with the end users. Trained end users in understanding the reports. Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.

Environment: Business Objects XI R3 (CMC, Designer, Deski), Webi (Reporter, Info View), MS SQL Server 2005, Teradata, SAP DS, Xcelsius 2008, Tomcat, Windows 2003.

Confidential, New York, NY

Bo Developer

Responsibilities:

• Gathering Requirements, Drafting specifications, Design, Development, User Acceptance Testing and Production Roll Over.
• Interacted with end users, regularly in order to generate the reports required. Various Business Object reporting functionalities were used such as Slice and Dice, Master/detail, User Response function and different Formulas.
• Created new Business Objects users and User Groups using Business Objects CMC Module.
• Business Object Universe, Business Objects Reports and Business Objects repository were used extensively.
• Created Universe level objects and measures using the business rules provided.
• Created complex views to overcome loops and contexts.
• Derived Tables, Aggregate awareness are used in universes.
• Involved in building the data repository.
• Involved in Administration of Business Objects.
• Deployed Scheduled, Published, Developed and tested reports on BOXI R2 Production Servers.
• Maintained user security on the BO Universes.
• Web I Reports are created and deployed through Info View and Customized Webi Front end.
• Complex Crystal XI Summary as well as Detail reports are created based on business request.
• Created Auditor reports and tracked user access of reports and Universes.
• Created Dashboards and Speedo meters for churning analysis-using Xcelsius.
• Customized the dashboards for better manageability of overall performance
• Performed data validation and analyzed test results.
• Maintained and Applied patches to Development, UAT and Production Servers to keep them in sync.
• Worked with Business Users to develop system requirements, analyze data Elements and continuous end-user support.
• Used scheduler to run recursive reports Daily, Weekly, Monthly as requested by the end users and stores the output in their inboxes.
• Created numerous Alerts that are executed based upon certain conditions.
• Extensively involved in creating Parameters and Record Selection Formulas to allow the users to filter the Data using Crystal XI.
• Created different categories to simplify it to the users to locate the reports.
• Extracted, Transformed and loaded the delta/change in the OLTP to existing Data warehouse
• Utilized DI Designer for designing the ETL jobs and scheduled though the job server

Environment: Business Objects XIR2, Crystal Reports XI/10, Xcelsius, InfoView, Universe Designer, SQL Server2005, and Windows Server2003.

Confidential, New York, NY

Business Objects Developer

Responsibilities:

• Involved in Installation and configuration of Business Objects Tool suite.
• Developed canned reports using Crystal Reports.
• Used formulas, sub-reports, parameters to develop canned reports.
• Created Users, User group and assigned them privileges as instructed.
• Migrated Report and Universe from Business object E 6.5.1 to Business Objects XI R2.
• Closely work with Database Administrators to validate month end data process for reporting needs.
• Enhanced the existing universe by adding new Dimensions and Measures as requested.
• Checked the Integrity of the universe for each addition.
• Managed the User Security in the Universe and CMC
• Exported the universe to the Repository for users to build ad-hoc.
• Created Aliases and Context to resolve loops, defined the cardinalities as defined in data model.
• Created Measure and Conditional Object in the Universe
• Created Hierarchies and Customized List of Values (LOV) in the Universe.
• Created various classes, objects and also tested them with the data model as reference.
• Developed various Adhoc and Canned Reports using DESKI, WEBI and Crystal Reports.
• Created Hierarchies according to the business rules for viewing data at selected level of detail.
• Worked extensively with @functions (@select, @prompt, @where) to overcome the problems with database when integrating with business objects.
• Resolved issues related to RDBMS flaws such as Fan Trap, Chasm Trap using BO multi parse SQL functionality.
• Preformed troubleshooting, diagnoses, and solved Hyperion Essbase related issues.

Environment: Business Objects XI R2, Desktop Intelligence, Designer, Universe Builder, Supervisor, Admin Console, Infoview, Webi, Transact-SQL, Crystal Reports.

Confidential, Santa Clara, CA

Business Objects Developer

Responsibilities:

• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Developed the stored procedures to increase the system performance.
• Problem resolution and status updating to the Onsite co-coordinator
• Involved in Installing the Business Objects, Web intelligence and Broadcast Agent Server.
• Involved in creating the Repository, creating Users, User Groups and assigned privileges to the users using Supervisor.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Designing and developing universe for report generation.
• Resolved the loops, cardinalities, contexts and checked the Integrity of the Universes.
• Exported the universe to the Repository to make resources available to the users
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces
• Created user defined objects including dimensions and measures for complex financial calculations.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces
• Prepared user documentation for hands on training of end user community
• Designed application by integrating product knowledge with client requirements.
• Synchronized reports using data from multiple data providers in Web Intelligence by merged dimensions functionality.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, master/detail, cross tab, charts and alerts for creating Business Objects reports.
• Involved in resolving problems like ‘Chasm Trap’ and ‘Fan Trap’.
• Checked the integrity of the Universe schema for any errors in objects, joins, conditions, loops and cardinalities of the Universe.
• Enhanced reports which included standardizing format of report content, redefining query filters and prompts, linking summary report to a set of detail reports.
• Used @Functions such as @Prompt to restrict return values and to enter prompt, @Select- to reuse the select statement of another object, @Variable- to restrict the currently logged user etc.

Environment: Business Objects 6.5, Oracle 8.1.6, Windows NT.

Confidential, Minneapolis, MN

Business Objects developer

Responsibilities:

• Involved in the design and development ofUniverses, Classes, Objects and Conditioned Objectsfor Business Analysis and Report Generation.
• Used different functionalities of Universe such asCardinalities, Contexts, JoinsandAliasesfor resolving Loops and Checked theIntegrityof the Universes.
• CustomizedhierarchiesandList of Valuesin the Universe for providing drill down options in the reporting environment.
• Implemented row level and object level security using Supervisor for different users.
• Usedaggregate awarenessfunction to enhance the performance of the universe.
• Exported the universes to theRepositoryto make resources available to the users.
• Created the reports usingmultiple Data providerslike universe,free hand SQL, Excel etc.
• Created the reports usingBO functionalitiessuch as drill down reporting, slice and dice,@functions,master-detail reporting,sorting.
• Worked withranks, promptsand variables in designing reports in full client and thin client.
• CreatedAlertersusing Business objects to highlight columns based on business criteria.
• UsedBroadcast Agentto distribute the reports to different users.
• Provided complete documentation and presentation to help users in developing various reports using different functionalities and methods used in creation of reports.

Environment: Business Objects 6.5, SQL Server.

Confidential, Chicago, Illinois

Hyperion Essbase Developer

Responsibilities:

• Provided Hyperion Solutions for the clients.
• Executed Data Migration from financial sources to Hyperion Essbase database.
• Extensively used Hyperion Essbase 6.5 to design and modify outlines to meet the client’s business requirements.
• Performed Dynamic Dimension Building and Data Loading using Rules Files.
• Created transparent, linked, and replicated partitions to improve the scalability, reliability, and performance of databases.
• Created Excel-sheet reports for clients through Essbase Excel Add-In.
• Customized retrieval on Excel sheets through efficient use of Essbase Query Designer.
• Developed and manipulated Calculation Scripts to improve Essbase database performance.
• Defined ESSCMD and MaxL automation backboned by OLAP Server to run batch scripts for backups.
• Performed Essbase Optimization Tuning and administered Cache Management.
• Professionally responded to demands and deadlines in a positive manner.

Environment: Hyperion Essbase 6.5, Excel Add-In, Query Designer, Windows 2000, OLAP Server, ESSCMD, and MaxL