SUMMARY

• SAP BO Consultant with 8+ years of experience in Data Warehousing and SAP Business Objects / Business Intelligence reporting which includes Business Objects Reporting Development, Business Objects Administration, Migration/Up - gradation and Support projects.
• Extensively worked on SAP Business Objects (Universe Design, Web Intelligence, Crystal Reports, Dashboards)
• Extensively worked End to End on all phases ofSAPBW/BI project lifecycles including Analysis, Architecture, Design, Development, Data Extraction, Staging, Transformation, Presentation, Testing, Cutover/Go-Live Planning, User Training, Knowledge Transfer, Deployment, Production Support and Change Management.
• Have been performed as a Developer, Analyst and a Tester in complete SDLC end to end implementation projects, Support and Enhancements projects.
• Have worked on SAP Business Objects Data Services (SAP BODS) ETL background.
• Have experience in developing reports with SAP BI/BW, SAP HANA sources.
• Worked as a Technology Lead and having strong Competency in Software Development Life cycle (SDLC) phases including Requirement analysis, design, development, SIT/UAT testing, Quality Assurance, deployment, maintenance and Production Support.
• Experienced in Data Modeling, Star/ Snowflake schema modeling, Fact and Dimension Tables, Physical and Logical data modeling using Erwin 7.2/4.0/3.5, Toad Data Modeler, Microsoft Vision.
• Worked as a Data Analyst in Retail domain, expertise in understanding Business and suggesting various solutions to the Client/Customer.
• Involved in complete SDLC process which includes Design and providing solutions.
• Experienced in documenting requirements, data flows, elements of business cases.
• Experience in running the sprint planning, daily scrums, reviews and retrospectives.
• Ability to analyze data, abstract the data exchange into coherent requirements, for the development and testing teams.
• Collaborated with the development and testing teams to refine/validate the requirements.
• Collaborated with testing services to create system testing & non-functional testing scenarios.
• Preparing business documents like FSD (Functional Spec Document), HLD (High Level Design), LLD (Low Level Design).
• Experience in creating Universes with measures and dimensions objects, join conditions, Filters, LOV, Cardinality, Aliases, Contexts, and Aggregate Awareness using Business Objects Designer
• Experience working with tabular data, have clear understanding of difference between structured and unstructured data, difference between primary and foreign key, can work and think in rows and columns and being able to visualize/interpret this data and the flow of data.
• Participating in your change control process for all planned application and technical activities
• Maintaining and testing processes related to business continuity.
• Having SAP BO infrastructure setup experience which includes setup a new BO environment, upgrading the existing system and maintaining the existing environments.
• Experience in Installation/Administration of BO application, Scaling the BO Architecture, Setting up the BO cluster Environment and single sign on and Migration of BI4.0 to BI4.1 and XIR3.1 to BI4.0
• Expertise in BO system Administration including Software deployment, Installation, Infrastructure maintenance, Creating and managing groups and user profiles, BO Security setup, BO content migration,
• Documentation, Production Support and user training.
• Support and troubleshoot production systems as required, optimizing performance, and resolving production problems
• Perform problem solving, debugging, and unit testing for multi-tiered SAP BI/BO landscape.
• Expertise in Clustering/ Un-clustering the servers based on the environment requirement.
• Expertise in monitoring of system loads, enhancement of reports and queries, and ongoing support tasks.
• Handle implementation/upgrade, administration and maintenance of Design Studio deployment.
• Promoting changes through the landscape by using SAP Business Objects Promotion Management
• Involved in upgrade of Business Objects versions and patches.
• Good knowledge in authentication configurations of windows AD, SAP and LDAP authentications
• Have expertise in BOBJ Web Intelligence reporting, Crystal reports, Xcelsius Dashboards.
• Have expertise in Web Intelligence reports with Universe Designer Tool (UDT), Information Design Tool (IDT), SAP BI/BW Bex queries, and Excel source based reports.
• Expertise working with Data Integrator 6.5.1/XI Designer creating DI Workflows and Jobs and executing them in Dev and Test Environments.
• Used Live Office and QaaWS (Query as a Web Service) to feed live data into Xcelsius 2008 to show product portfolio.
• Expertise in Crystal Reports development with IDT and UDT, free hand SQL queries, stored procedures.
• Experience in Xcelsius dashboards creation with UDT, IDT universe, Webi Report extract, Crystal Report extract, live office extracts and web service URLs.
• Design, develop, and deploy dashboard using Xcelsius/Dashboard Designer using live office, query as web service and SAP BI connections.
• Experience in Live Office report extracts by using Web Intelligence reporting.
• Expertise in Tableau report development with SAP BI/BW Bex queries, Excel source, free hand SQL queries.
• Have experience in Design Studio reports development with SAP HANA, SAP BI/BW.

TECHNICAL SKILLS

Data Ware Housing Tools: Business Objects XI3.1/XI3.0/XIR2/6.x/5.x, Universe Designer, Web Intelligence, Desktop Intelligence, Info view, CMS, CMC, Live Office, Import Wizard, Report Conversion Tool and QaaWS, Crystal Reports 2008/XI/X, Xcelsius 2008, Dashboard Builder, Predictive Workbench 3.1/3.0, Bex Query Analyzer, Broadcast Agent Server

Operating Systems: Ms-Windows, Linux

ETL Tools: Data integrator XI, SAP BW 7.0, 3.5

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, MySql 5.1, IBM DB2, MS Access

Languages: HTML, PL/SQL, SQL

Workflow Tools: MS-Excel, MS-PowerPoint, MS-Word

Reporting Tools: Xcelsius 2008, Crystal Reports 2008, WebI

ERP: SAP BW 3.1C/3.0B, SAP R/3 4.6C/4.7

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Business Objects Consultant

Responsibilities:

• Part of Credit Portfolio Information Services (CPIS) team directly coordinating with high-end user to gather the new requirements and working with existing issues.
• Responsible for the System Study & Business Requirements Analysis & Documentation.
• Actively worked with the end users in finalizing the Functional Specifications. Created detailed Technical Specifications for each mapping based on these Functional Specs.
• Worked directly for Chief Credit Officer (CCO) and given solution of complex Analysis in shape of Rating Agency and Board Materials.
• Projects successfully implemented in production under ICRS are Non-Performing Analysis, Homebuilders and Credit Management Package.
• Designed & Implemented security architecture for Credit Reporting System.
• Involved in Data Modeling and Oracle Database
• Designed Universes for Integrated Credit Reporting System.
• Created various User defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data.
• Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where).
• Resolved Chasm, Fan traps and Loop problems.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Performed integrity testing of the Universes (Universe Structure checking, Object parsing, joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.
• Prepared complex reports like Financial reports, HR reports, Standard and Ad-hoc reports using Web Intelligence 3.1, Desktop Intelligence 3.1 and Crystal Reports 2008
• Created reports based on General Ledger, Credit Product Group and Market Segment categories
• Created many reports according to the loans, commitments and outstanding to know the exact amount of change in each loan
• Created reports like Residential and Business Customers reports.
• Created reports like Reports by Period, Demographic reports and Comparative Reports.
• Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• Used Xcelsius to Visualize and to enhance the data presentation along with developing dynamic charts and graphics.
• Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the user’s reporting needs.
• Involved in performance tuning and optimization on Business Objects Universes by creating Aggregate tables.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Performed unit testing, system testing and user acceptance test (UAT) for universe, reports and security management.
• Developed universe user documentation guide for the end users reference.

Environment: Business Objects XI 3.1/3.0, Crystal Reports 2008 SP3, Import Wizard, Conversion Tool, Web Intelligence XI 3.1, Desktop Intelligence XI 3.1, Xcelsius 2008 SP3, Designer, Info View, Toad 9.0, Oracle 10g, SQL, PL/SQL and Windows XP

Confidential, Riverdale, MD

Business Objects Consultant

Responsibilities:

• Work with business users and analyze the Reporting Requirements and Metric Analytics to come up with the technical specifications for the BO Reports from different sources.
• Building universes on top of SAPBW- Bex Queries using SAP Authentications.
• Worked on building Xcelsius Dashboards on top of universes build using SAP Integration Kit.
• Used QAAWS and Live office functionalities of BO to pull Data from SAP Universes.
• Experience in using QAAWS connections in Xcelsius with Refresh on Load option which enables pulling of Live Data from Universes as well as Web Intelligence reports on Demand from Data base.
• Design and develop various universes and configure Joins, Cardinalities, Loops, Contexts and Shortcut Joins
• Created Xcelsius dashboards for visual understanding of information and publish to BO Enterprise
• Created Xcelsius components like charts, menus and containers
• Mining data and performing statistical analysis using Predictive Workbench
• Work on Performance Manager to create various Metrics, Analytics and use Dashboard Manager to build Corporate Dashboards.
• Created different kinds of analytics including Gauge Analytic, interactive Metrics Trend and Metrics List
• Created Rules for Dashboard Manager like Events, Conditions and Actions
• Adopting strategies for List of Values involving customizing the list of values, Cascading list of values and exporting the List Of Values with the universe
• Use LCM (Life Cycle Manager) for exporting BO Objects from one environment to other.
• Use Database Expert, Group Expert, Select Expert, Section Expert to create different Crystal reports
• Use Section Expert with Conditional Formatting to create Hide / Suppress Summary Reports Developed and Converted Complex DESKI Reports to BOXIR2 - WEBI Using Report Conversion Tool.
• Migrated reports from 6.5 to XIR2 using Import Wizard.
• Used CMC (Central Management Console) to manage the universes, users/groups, reports and Security model to objects
• Designed Star and Snowflake schemas for Equities, Fixed Income, Client Coverage and Deals subject areas using Dimensional modeling and Erwin.
• Combine data from different sources and linking data providers (Merging)
• Design and deploy the security model for Analytics and Corporate Dashboards
• Worked extensively with the major functionality of BO like Breaks, Ranks, Variables, Alerters, Formulas, Calculated data items, Filters, Sorts, and Query prompt.

Environment: Business Objects XI R2/6.5, Oracle 10g/9i, SQL Server 2005, Info view, Crystal Reports XI, Web Intelligence XI, Xcelsius, SAP BW, SAP Integration kit QaaWS, Predictive workbench.

Confidential

Business Objects Consultant

Responsibilities:

• Designed / developed Crystal reports from number of different data sources with number of formats including PDF, spreadsheet, or graphic using Crystal Report XI
• Developed Standard, Summary, Cross Tabs, SQL, grouping, sub reports, summary detail reports, linking sub reports, Custom Formatting Techniques in Crystal Reports Environment.
• Developed new reports using stored procedures, enhanced the existing reports for performance and data accuracy.
• Developed reports in Crystal XI with Oracle, SQL Server, Stored procedures, views, customized SQL, Universe.
• Coding and Design of User Interface, Business Logic, Integration Design Reports and Queries.
• Responsible for Integrating Business Objects with SAP BW with Portal Integration kit to publish the reports onto the Enterprise using BW/R3 portal.
• Worked with the business unit to define, develop prototypes for SAP BW reporting.
• Modified BW queries in the Crystal reports using BW query designer with Crystal XI R2 professional tool.
• Experienced in working with Business Explorer (Bex) and publishing the reports on web using Web Reporting tools.
• Extensively work on Query Designer and Web application designer to create Queries for financial reports, budget and delivery analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
• Developed queries from SAP Info cube using Bex Query Designer and applying filters, free characteristics for slice and dice techniques.
• Developed reports from SAP Info cube by using Bex Analyzer, applied filters, variables, parameters/prompts.
• Worked on transports of BW queries, objects from Development, Test and Production Environments.
• Responsible for developing test cases, business validation rules for verification and validation of data quality.
• Experience in building Dashboards using SAP NetWeaver BW connection to create metrics, score cards, rules, alerts, goals and insightful analytics using Xcelsius.
• Strong Knowledge in SAP BW, ECC 6.0, SAPR/3

Environment: Business Objects XI R3.1 (Designer, Desk I,Web I, Import Wizard, Publishing Wizard), Business Objects XI R2,Xcelsius2008,SQL Server 2000/2005, Oracle 10g/9i, PL/SQL, Window 2003 Server/XP, SAP BW 3.x, SAP BI 7.x

Confidential

Business Objects Consultant

Responsibilities:

• Involved in requirements gathering from the business users to build the reporting application.
• Installed and configured Business Objects XI R2 on Development, Test and Production Environments.
• Enabled/Disabled different servers in Central Configuration Manager and Central Management Console.
• Created users and groups and applied row level and objects level securities using Central Management Console.
• Installed and configured Business Objects XI R2 using Tomcat and Apache as Application and Web Servers.
• Applying latest patches, service packs onto the testing and production environments under change management process by sending communication outages to users.
• Worked with System Administrators to troubleshoot the Business Objects Services after the application patches have been applied.
• Managed and Configured Servers (File Repository Server, Report Application Server,Web IntelligenceServer, Destination Job Server, Program Job Server, Event Server)
• Worked with End-To-End implementation with Data warehousing team and Strong understanding of Data warehouse concepts Star Schema, Snowflake Schema and Multi-Dimensional Models for query and analysis requirements.
• Experience in building Universes, retrieving data using Universes, Personal data files, Stored procedures, Free hand SQL methods and creating complex ad-hoc Reports using the Business Objects and Web Intelligence modules.
• Createduniverses, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Resolved table-linking problems like Chasm traps and Fan traps using Aliases and Contexts.
• Created several Classes, Objects, Conditions, and Measure objects
• Involved in migration and deployment of theuniversesand reports across multiple domains.
• Creating Full client and WebI reports.
• Involved in requirements study, design reviews and analysis of input/output flow.
• Provided end user and production support after deploying the application into the production environment.
• Contributed to Quality Assurance (QA) test design
• Designed MetricUniversefor Performance Management products.
• Created metrics, goals and analytics for display in corporate dashboards for business user consumption.
• Developed dashboards and scoreboards for detailed analysis.
• Worked with QA and User Acceptance Testing (UAT) managers to determine requirements for test environment and UAT planning.
• Responsible for UAT execution process including test planning, Defect Tracking, Defect assessment and impact analysis
• Business Objects Enterprise authentication, scheduling, publication and automation of reports.
• Responsible for creating training documentation.
• Coordinated and participated in the successful implementation of the application and performed validation in production environment prior to the users, to ensure the validity of code, tables, views, reports and user interface.
• Documenting the production and development environment changes made on the web servers.
• Used the Import wizard to import existing user accounts, groups, categories, WebI documents,universes, connections anduniverserestrictions to BO XI environment.
• Created reports prototypes usingWeb IntelligenceXI for user presentation.
• Trained the Business Users in report creation and new features of Business Objects XI R2

Environment: Business Objects XI R3.1 (Designer, Desk I,Web I, Import Wizard, Publishing Wizard), Business Objects XI R2, Data Services XIR3.2,Xcelsius2008,Business Objects 6.5 (Supervisor, Designer, Reporter), SQL Server 2000/2005, Oracle 10g/9i, PL/SQL, Window 2003 Server/XP

Confidential, Columbus, OH

BO Developer

Responsibilities:

• Used Business Objects Designer to maintain Universes, identifying Measures, Details and other dimensional objects.
• Extensively worked with Business View Manager for developing Business Views, dynamic Cascading Prompts
• Created many reports with Crystal Reports X with Business Views as data source
• Involved in creating the repository for Performance Management and creating different Analytics/Metrics and statistical functions on the metrics (time-rolls ups, moving averages)
• Designed the Corporate Dashboard Security on measures/metrics/analytics using the Access Restrictions in the universe
• Created critical visualization using Business Objects Crystal Xcelsius for the Business Dashboard.
• Used Crystal Report’s to feed data to Crystal Xcelsius Visualization an XML file as a data source.
• Resolved inconsistencies using aliases/contexts to maintain universe integrity and check for loops and traps including chasm trap and fan traps
• Created Crystal Reports using Crystal reports Formulas, Grouping, Parameters, Selection criteria to handle the customer’s requests from Tables, Stored Procedures, Views and Command Objects
• Create Hierarchy groups with Group Expert and Group Selection Formulas in Crystal Reports Use Conditional Formatting, Format Painter, Report Alerts and Suppress features of Crystal Reports to format the report
• Created Sub-Reports (Unlinked / Linked, In-place / On-Demand) with Shared Variables between the main report and the Sub-report in Crystal Reports
• Created cross-tab reports using Cross-tab expert in Crystal Reports
• Worked extensively with the major functionalities of Business Objects like Alerter, Group By, Query Prompt, Drill Filter, Indexes, Breaks, Sorts, Ranking, and Calculation using the Slice and Dice panel.
• Use Changed-Data-Capture (CDC) to extract only new or modified data and update the target system including handling overlaps and preserving generated keys Troubleshoot power users reports with errors like (#Computation, #Multivalue, #Alerter, #Error, #Err, #Overflow, #Unknown)
• Created Users/Groups, roles and assigned required rights to them. Involved in the administration of Management Console for implementation of security at Report level, Folder level and Object level by assigning rights and required access level as per business requirement.
• Responsible for Code Migration from development to testing, testing to production including managing data connections to different databases.
• Worked with different types of transformations like Query, SQL, Date-generation and validation.

Environment: Business Objects XI R3.1 (Designer, Desk I,Web I, Import Wizard, Publishing Wizard), Business Objects XI R2, Data Services XIR3.2,Xcelsius2008,Business Objects 6.5 (Supervisor, Designer, Reporter), SQL Server 2000/2005, Oracle 10g/9i, PL/SQL, Window 2003 Server/XP

Confidential, Texas

BO Developer

Responsibilities:

• Assisted the IS - Utilities (ISU) functional team in creation of Functional Specifications for the analytical reports.
• Creating Technical Specification documents and Data Model Design documents.
• Installed Business Content Objects for the areas of PM, MM, Product costing and customized them according to the requirement.
• Involved in the design, development of Info Cubes, Multi-Providers, Operational Data Store (ODS), Aggregates, Info Objects, Data Sources, Info-Sources, Transfer rules, Update rules, Transformations and DTPs.
• Configured data sources in R/3 by using LO cockpit, initialized setup tables. Schedule and implemented delta mechanism for periodic loads.
• Created effective reports utilizing various objects of Business Explorer including Restricted Key Figures, Calculated Key Figures, Exceptions and Conditions.
• ABAP programming in Customizing extractors, start routines and User Exits.
• Developed Process chains for Master data and Transaction data in the areas of MM, PM and Customer Service.
• Created Business Objects reports, Queries with constant interaction with the end users.
• DevelopedSAPBusiness Objects Universes and used Web Intelligence Tool to provide effective reports.
• Extensively Worked on Crystal Reports.
• Generated Reports based on time like Year, Quarter, Month, Week based on Geographic and Comparative reports.
• Created complex dashboards on BEX Queries using Query Browser in Dash board designer 4.0
• Exclusively used QAAWS and Live Office to import data to spreadsheet and develop visually rich dashboards.
• Utilized Business Objects functions like cross tab and drill methodologies in linking multiple data providers.
• Generated ad-hoc reports by linking systems and interfaces

Environment: Business Objects XI R3.1 (Designer, Desk I,Web I, Import Wizard, Publishing Wizard), Business Objects XI R2, Data Services XIR3.2,Xcelsius2008,Business Objects 6.5 (Supervisor, Designer, Reporter), SQL Server 2000/2005, Oracle 10g/9i, PL/SQL, Window 2003 Server/XP

Confidential, California

Software Engineer

Responsibilities:

• Involved in collecting the user requirements.
• Designed newuniverseand maintained existinguniverseaccording to the user requirements.
• Created and managed users/groups and assigned privileges using supervisor module.
• Created MultipleUniversesin Designer using different databases like SQL Server, MS Access and DB2.
• Exported theuniversesto the Repository making resources available to the corporate users.
• Improved system performance in data access by fine-tuning SQL statements and joins.
• Created user specific classes and objects and maintained object level security at the designer level.
• Developed complex SQL code to enable user queries to the database for data access, using triggers.
• Involved in full life cycle of Business Objects reporting applications.
• Created Master-Detailed reports using Drill down/up functionality for the Decision Support System regarding the company’s products.
• Created complex prompts and conditions in theUniverseusing @Functions and CASE statements.
• Created complex reports using various functionalities as prompts, slice and dice, drill down, break, formulae, calculations, cross tab and master details.
• Created Webi Reports and deployed them using Info View.
• Trouble shooting and tuning of the Existing Reports.

Environment: Business Objects XI R3.1 (Designer, Desk I,Web I, Import Wizard, Publishing Wizard), Business Objects XI R2, Data Services XIR3.2,Xcelsius2008,Business Objects 6.5 (Supervisor, Designer, Reporter), SQL Server 2000/2005, Oracle 10g/9i, PL/SQL, Window 2003 Server/XP