PROFESSIONAL SUMMARY:

• 10+ years of IT experience and Business Objects 4.2/4.1/4.0/XI3.1/R2/6.5 with experience in CMC, Infoview, Desktop Intelligence, Import Wizard, Designer, Reporter, Web Intelligence
• Experienced the features of Business Objects XI R2, Crystal reports XI R2/2008, Crystal Xcelsius 2008/4.5.
• Experience in building Universes, retrieving data using Universes, Personal data files (MS Access, Excel) and creating complex ad - hoc Reports using the Business Objects Web Intelligence (WebI) modules.
• Experience in Installation, Administration, Design Universe, Reporting (Desktop Intelligence & Web Intelligence) and Migration of Business Objects XI R3/R2 /6.5 .
• Experience in migration of Business Objects from BO XI 3.1 to 4.0.
• Extensive knowledge in Business Objects Full client & thin client environment.
• Worked on Web Intelligence (WebI) to develop and publish thin client reports.
• Experienced in setting up of Repository, creating, managing users and user groups
• Experience in migration from previous versions of Business Objects to its higher version
• Extensively worked in designing, implementing, distributing and maintaining Universes.
• Experience in creating Crystal Reports using Crystal Reports XI/2008 with expertise in developing various standard, graphical, formula based, well-formatted, drill-down, drill through, Summary and Parameters based reports and profound experience in developing complex reports using Sub-Reports (Linked and Unlinked), Cross-Tab, Stored procedures and Views.
• Expertise in developing dashboards using Xcelsius from Live Office. Used Query as a Web Service.
• Strong knowledge in building queries on different types of Data Providers Universes, Personal data files, Stored Procedures, Free-hand SQL, and Web connect.
• Experienced in setting up of Repository, creating, managing users and user groups.
• Good in development of Data warehouse/Data Marts, Data Modeling, designing the STAR and SNOWFLAKE schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Have experience working with databases like Oracle, DB2, Teradata, SQL Server and MS-Access.
• Expertise in Linux, UNIX and Windows environment. Good basic knowledge of Unix Shell Scripting
• Experienced in web publishing and scheduling documents using Broadcast Agent or Publishing wizard.
• Strong background in Data warehouse concepts - ETL, Data modeling, and Reporting
• Proficient in working with error handling and performance tuning to enhance database performance.
• Extensively worked with end-user requirements, business data requirements, analysis and study.
• Unique ability to understand long-term project development issues at all levels
• Strong Business Intelligence implementation knowledge of strategic planning, development and production in various core sectors
• Demonstrated excellent interpersonal skills and communication skills during identification of user requirements.
• Capable of working in a team or individually, self-motivated with good problem solving skills.

TECHNICAL SKILLS:

Operating Systems: Win XP SP2/SP3, Win 2000, Win NT 4.0 and UNIX

Databases: SQL Server 2005/2008/2012, Oracle9i/10g/12C, DB2, Teradata V2R5/V2R4, Toad, MS Access 2000/XP/2007

Programming Languages: SQL, PL/SQL, HTML, C, Java, Java Script, UNIX Borne/K Shell Script, Perl

Web Technologies: HTML, DHTML

Reporting Tools: Business Objects 4.2/4.1/4.0/XI3.1/4.0,6.5/6.0/5.x,Crystal Reports 2008/XI/10/9, Crystal Xcelsius 2008/4.5, Central Management Console (CMC), Central Configuration Manager (CCM), Import Wizard, Performance Management, Designer, Desktop Intelligence, Web intelligence, Crystal Xcelsius 2008

ETL Tools: Informatica 8.6/6.1, SAP Data Integrator/Data Services XI3.0, 3.1, 3.2

Application Servers: Apache 1.3.27, IIS 5.0 and Tomcat 4.0.6

Business: MS Visio and MS Front Page

UML Diagram Tools: Microsoft Visio

Microsoft Tools: Microsoft Office Suite (Word, Excel, Access, PowerPoint, and Outlook

UML Diagram Tools: Microsoft Visio.

Business objects: Business Objects, Web intelligence, Live Office, Desktop Intelligence, Import Wizard, BI Launch Pad, QaaWS, WEBI, SAP BI,FRS,UDT, jco, bics, Universe, PICK, UniData, Pick, Business intelligence, Job scheduling, Universe Designer, SAP BODS,SAP HANA,ODBC, Reinsurance, Data services, Xcelsius, EBP, SPRO, GDPS, CAPM, BRF.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Sr. Business Objects Developer

Responsibilities:

• Performed an initial study of the current reporting application, to finalize the data elements required for reporting.
• Installed and configured BO Software on client machines and created User groups and users of PROD, DEV, TEST environments.
• Created Repository for BO development, created Universes and Complex Reports.
• Involved in working with different database environments and moving of the universes and reports between PROD, DEV, and TEST.
• Created Complex Crystal Xcelsius Reports from the output of Business Objects report data.
• Created Xcelsius dashboards for the ORM (Owner Relation Management) application
• Used QaaWS to provide dynamic functionality.
• Used Sliders, Pie charts, column charts, Gauges, Dials, maps and other features in Xcelsius
• Extensively used Alerts while creating the Dashboards (Xcelsius).
• Added users, user groups and managed the access privileges of the user community using the CMC module
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.
• Maintained universes and Object Oriented Universe Design Techniques, working knowledge of Linked Universes.
• Working on creating Universes, Business Intelligence Layer for end users to develop the Adhoc/Canned reports.
• Designed Metadata Universe by creating the Business Objects Semantic Layer selecting/joining Tables, set cardinalities and creating objects and classified them into Dimensions, Details and Measures and give Business Name and group them into classes and sub classes
• Involved in creating the Aggregate tables at different levels.
• Created user objects including Dimensions, Details, Measures, Filters and Prompts, LOV
• Multilevel hierarchies are set up enabling the drill down functionality.
• Defined Report Level Ranking, Database Ranking and Alerts in Reports based on the specifications.
• Configured the Data services to connect to the SAP R/3.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.
• Created Report Level Variables, Objects and Formula to create new columns based on the result set.
• Resolved issues like Chasm traps, Fan Traps in the universe build by creating contexts and aliases as required.
• Resolved loops by creating aliases, contexts and short cut joins by resolving loops, cardinalities and integrity checks of the Universe before exporting.
• As a part of report development, created the reports using universe as a main data provider and using the Powerful business objects functionalities, and formulae. Involved in trouble shooting of various reporting errors.
• Created the complex WebI reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
• Created a set of Ad hoc reports with Business Objects and finally deploying them in Web Intelligence.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in Reports.
• Worked on Import and Export of the Universes, with the changes in Database Objects by using Import wizard and Designer module.
• Perform ETL processes using SSIS tool for SQL Server Design/Develop complex queries efficiently as per the given business requirements. Worked with Business users to understand the Business Logics as per the need. Worked with Financial data to calculate Comp.
• Generated ad hoc and canned reports for Business objects.
• Developed Crystal reports, which include the following features - parameter fields, formulas, conditional formatting, multiple grouping and running totals
• Developed Crystal reports using various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts.
• Generated various report templates for standardizing the reports throughout the organization.
• Troubleshoots system errors and bugs and rectifies them.
• Involved in Training the Users in using this robust system.

Environment: Business Objects, Web intelligence, Live Office, Desktop Intelligence, Import Wizard, BI Launch Pad, QaaWS, WEBI, SAP BI,FRS,UDT, jco, bics, Universe, PICK, UniData, Pick, Business intelligence, Job scheduling, Universe Designer, SAP BODS,SAP HANA,ODBC, Reinsurance, Data services, Xcelsius, EBP, SPRO, GDPS, CAPM, BRF. SAP Business Objects 4.2/4.1/4.0/XI3.1, Tomcat 5.5.20/5.0.27, Designer XI R3/R2, Desktop Intelligence, Crystal Reports 2008, Xcelsius 4.5/2008, Teradata, SQL, PL/SQL, UNIX.

Confidential, Los Angeles, CA

Business Objects Developer& Data Information Analyst

Responsibilities:

• Involved in Analyzing the End users functional and technical requirements and respective impacts on reports.
• Used Business Objects XIR3 extensively and Involved in Full SDLC (software development life cycle) rules are followed for designing new components.
• Designed, created and maintained Universes for Business Objects and Web Intelligence users using Business Objects Designer Module.
• Created universes by defining Joins, Cardinalities between tables.
• Exposure to Data services Architecture Data services objects, Data services design interface, Data stores, Importing metadata, File format.
• Worked on Metadata Management in storing information about the information and Data Governance.
• Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
• Responsible for creating & managing the Business Objects repository and coordinating/performing universe development.
• Created predefined conditions, prompts and custom hierarchies in the process of building the universes
• Created Contexts and Aliases for resolving Loops and join problems in the Universes.
• Deployed universes in the repository by exporting and importing universes between universe domains, and over different repositories.
• Created Web Based reports using Web Intelligence and Dashboards for various reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
• Created both full client(DeskI) reports and Web I reports using Info view and WebI Rich Client with many features of drill down and alerters and filters.
• Generated various reports on a daily, weekly and monthly basis using Business Objects Report module.
• Created reports using Business Objects functionality such as Slice and Dice, Drill Down, Master/detail, Crosstab, Prompts and Formulas, Breaks, Sorters and Alerters etc.
• Created Universes using @functions like @select, @where, @aggregate awareness and @prompt in the process of building the universes.
• Created derived tables and aggregated tables at the Universe level to reduce the complexity of universe building and increase the performance.
• Created various report specific formulae based on calculation contexts of the report.
• Involved in writing free hand SQL, as data provider for retrieving data when universe doesn’t provide required data.
• Worked with Business Objects Professional services to build a online training material using the SAP Knowledge Accelerator tool for reporting
• Involved in Scheduling reports based on Specific time, events and calendars and in various formats such as Excel and PDF in web Infoview portal.
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Involved with the group which provided support and ideas for migration from BO XI 3.1 to BO 4.0
• Used Central Management Console (CMC) in creating users and groups and assigning privileges to different groups and users.
• Applied row level and object level securities to different groups and users in the designer wizard.
• Created all types of reports using different functionality like Cascading Prompts, Cascading LOVs, Formulae and Grouping.
• Involved with a team in creating Dashboards using various visual analytics, themes to meet corporate standards using XCelsius.
• Designed analytics sales Vs Inventory using the Crystal XCelsius analytics for the high end users
• Created Xcelsius dashboards using Query As A Web Service (QAAWS) and Live Office
• Created multiple Crystal and Web Intelligence reports and transformed into a single dashboard using Xcelsius
• Gave my thoughts and ideas to the data-modeling team in designing a new data mart for future reporting applications in a EDW warehouse.
• Coordinated with BO Admin in managing the Central Management Server to add/delete, enable/disable BO Servers.
• Coordinated with DBA and ETL in solving various technical issues and also to stream-line universe design and optimize query performance
• Worked on Informatica Power Center Source Analyzer, Data warehousing Designer, Mapping & Mapplet Designer and Transformation Designer.
• Conducted presentations training sessions and created training documents for the Business users on the use of Business Objects reporting tool and overview of the Universe.

Environment: SAP Business Objects XI R3/R2, Designer XI R3/R2, SAP Business Objects Data Services XI 3.2, Desktop Intelligence, Web Logic 6.0, Java, Java Script, Business Objects, Web intelligence, Live Office, Desktop Intelligence, Import Wizard, BI Launch Pad, QaaWS, WEBI, SAP BI,FRS,UDT, jco, bics, Universe, PICK, UniData, Pick, Business intelligence, Job scheduling, Universe Designer, SAP BODS,SAP HANA,ODBC, Reinsurance, Data services, Xcelsius, EBP, SPRO, GDPS, CAPM, BRF. Crystal Reports 2008, Xcelsius 4.5/2008, Oracle 10g, SQL, PL/SQL, UNIX

Confidential, Pittsburgh, PA.

SAP BO Admin

Responsibilities:

• Creating reports, Deployment, Clustering, capacity planning, Server sizing, Performance tuning
• Migration and Report life cycle management through different stages of production which includes Web Intelligence, Desktop Intelligence and Crystal Reports for BOXIR1, R2,3.1, BI 4.0
• Migration with Upgrade Management Tool, Import Wizard and Copy Data Source
• Promoting the jobs and versioning using Life Cycle Management (LCM)
• Publishing Objects from different Business Objects tools
• Working on Security Management Model for BOXI3.1, and BI4.0
• Troubleshooting issues related to installation, deployment, web server configuration, scheduling, authentication, rights management and performance tuning
• Configuring Business Objects Auditor on Oracle, SQL and other supported Platform
• Distributed deployment issues in BOXI 3.1 and 4.0
• Scheduling in BOXI3.1 and BI 4.0
• Fixing performance issues on Business objects BOXI3.1 and 4.0 servers
• Deploying on Tomcat, IIS, Web sphere and Weblogic with Apache, IIS as the front end web server
• Installing and configuring of BOXI3.1 and BI4.0 server and testing, load balancing, Disaster recovery
• Implementing Security Features of Business Objects like row level, object level and report level to make the data secure
• Unit testing, system testing and user acceptances test (UAT) for universe, reports and security management for customers
• Testing and Maintenance of BO universes, Web Intelligence, Crystal and Desktop Intelligence Reports
• Configuring and integrating of SAP BW systems with Business Objects
• Configuring SSO and manual with AD, LDAP and SAP authentication on all BO applications,knowledge on third party authentication tools such as Siteminder
• Configuring end to end database SSO with SQL Server, Oracle
• Deploying web applications on different application servers and setting up reverse proxy
• Creating publications of both types i.e. Enterprise recipient and dynamic recipient
• Working on new universe Design Tool Universe Design Tool (IDT)
• Customizing Business Objects Applications like InfoView/CMC

Environment: SAP Business Objects XI R3.1/BI 4.0, Universe Designer, Web Intelligence Rich Client, Java, Java Script, Crystal Reports, Dashboard Designer/Xcelsius, Live Office, Info view/BI Launch Pad, SQL, PL/SQL, Oracle 10g.

Confidential, Charlotte, NC

Sr. Business Objects Developer

Responsibilities:

• System study, interaction with users, management and designing, coding, testing & implementation of the system.
• Involved in gathering user requirements.
• Created the Logical and Physical Model using classic Star-Schema.
• Defined categories of documents for different level of groups.
• Defined Complex Security set up for end users.
• Configured user rights and security.
• Involved in Sizing the BO XI r2 infrastructure.
• Migrated & upgraded Business Objects from 6.5 and Crystal Reports 10 to BO XI r2 Universe designing and establishing BO environment.
• Designing, creating, enhancing, testing BO universe, reports.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports using Business Objects Full Client application.
• System study, interaction with users & management, performance of analysis, designing, coding, and testing & implementation of the system.
• Designed Test cases for UAT of Reports for end users.
• Created the full client and Webi reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Used aggregate awareness in universes and Created Reports employing functionality like Queries, Slice and Dice, Drill down, Functions, Formulae etc.,
• Identified the CTQ (Critical to quality) KPI’s and Metrics as a part of the requirements gathering.
• Worked with the end users to create extensive use cases for the dashboards.
• Tuned the reports for better performance using SQL.
• Designed templates for Webi documents and customized Webi Front Page.
• Involved in Business Objects 6.5 Broadcast Agent and Supervisor.
• Mentored other IT staff & Conducted Corporate training for end users on Business Objects XI.
• Involved in server side components of Zero Administration Business Objects (ZABO) applications.
• Developed functions and procedures and change control documents for BO.
• Linked Webi reports for different hierarchies.
• Mentored other IT staff & Conducted Corporate training for end users on Business Objects XI.
• Trained the user community in making use of universe to create and publish reports.

Environment: Business Objects XIr2/6.5, Web Intelligence, Informatica, ZABO, Desktop Intelligence, Unit Test, CMC, Broadcast Agent Server, TOAD, Oracle 10g, DB2, Xcelsius, WEBI.

Confidential, Overland Park, KS

Business Objects Developer

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing Universes and responsible for analysis on crystal reports migration.
• Used Query Designer in Business Explorer for applying Prompts and filters on top of Info providers.
• Scheduled the reports on daily, weekly and monthly basis by using Scheduler.
• Updated and maintained existing Universes based on changing user requirements and based on changes in data source.
• Used Cascading prompts for geographical hierarchies.
• Used Teradata Utilities to increase the performance on the reports.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Developed Web Intelligence reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints and Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis) using Web intelligence Rich Client.
• Worked extensively with the major functionality of Business Objects like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
• Created Dashboard, Sales figure Dashboard using Xcelsius 2008.
• Migrated Business Objects XI R2 content (users/user groups, Universes, reports) in to Business Objects XI 3.0 environment using the Import Wizard.
• Migrated Crystal Reports 8 to Crystal Reports XI and also responsible for testing and publishing reports.
• Involved in Business Objects Support, Problem Solving, Troubleshooting and developing End user Notes.

Environment: Business Objects XI 3.0/R2, Web Intelligence Rich Client, Xcelsius 2008, Crystal Reports, Infoview, Teradata 13.0, Teradata 13.10, SAP BW, TOAD, Windows 2003 Server.

Confidential, West Des Moines, IA

Business Objects Developer

Responsibilities:

• Analyze the reporting requirements with the business users/architects and come up with the technical Specifications for universe and Business Objects reports.
• Utilized a thorough understanding of available technology, tools, and existing designs and worked on most complex problems where analysis of situations or data requires evaluation of intangible variance factors
• Improved the performance and reduced the coding with the use of @select, @prompt, @where.
• Improved the performance and reduced the coding with the use of @aggregate aware and tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Created Universes on top of SAP BW Info Providers for reporting with Web Intelligence.
• Used Query Designer in Business Explorer for applying Prompts and filters on top of Info providers.
• Administer and supervise the Business Objects environment by monitoring/granting permissions and rights to a vast Users located all over the world for viewing, creating and publishing reports and implement Row and object level restrictions.
• Created reports using free-hand SQL, Stored Procedure, PL/SQL.
• Resolved universe problems such as loops, chasm and fan traps using aliases and contexts by testing the overall integrity of the structure using check integrity.
• Modifying the existing universes, adding new objects, editing joins, mapping the existing objects with renamed tables.
• At the universe level checked whether all the outer joins are created properly and also removed if there are any variables which are not used.
• Implementing Object-level and Row-level security using Manage Restrictions on the developed universe restricting the end-users in accessing certain objects.
• Created Web Intelligence Reports using Webi reports Formulas, Grouping, Parameters and Static/Dynamic Cascading Prompts to handle the customer’s requests from Tables, Stored Procedures, and Views.
• Created Custom Hierarchies for using scope of Analysis and Drill Down options.
• Created the Reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice and Drill Down.
• Improved the performance of the reports by removing any additional filters or alerter on the report. Turned the formula into a variable if it has any multiple uses.
• Developed and executed the Reports using Business Objects XI 3.1
• Used Import Wizard for the Migration process. Migrated users, universes, reports

Environment: Business Objects XI 3.1, Designer, Web Intelligence Rich Client, Crystal Reports 2008, Infoview JIRA,Cognos, CMC, Teradata, MS SQL Server 2008, Oracle 11G, SQL.