Objective

To work as a SAP BI/BO Consultant

• Experience in installing and configuring SAP integration Kit with BO, integration of Crystal Reports with SAP BW and reporting based on BW Cubes, Info sets, R/3 tables
• Proficient in Business Objects Reporting flavors in WebIntelligent, Crystal Reports and Xcelsius for both SAP and Non SAP sources
• SAP BI-BO Experience in building Universes and Reports by extracting data from SAP BEx Query and SAP BW Cubes
• Extensive experience in Business Objects reporting, in the context of developing the Universe using the Universe Designer and the Analytics using, Xcelsius, Webi and Crystal
• Worked extensively on BEx Analyzer, Query Designer, Report Designer, Web Application Designer, Crystal reports, Web Intelligence, Live Office and Xcelcius
• Accomplished SAP BI/BW professional with over 3 years of SAP BW/BI experience as Consultant, designing, developing, modeling, implementing and supporting various facets of the SAP BW product covering FI-CO and CRM functional areas. Well versed in associated technologies and tools such as BEx, WAD, Portal, FTP
• Hands on experience with Front-end Business Warehouse Components which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures, Cell editors
• Capable of working in teams as well as individually, with little or no supervision. Quick learner, hard working, customer oriented with good inter-personal, verbal and written communication skills

• Technical : SAP BW 3.5, SAP BI 7.0, SAP R/3 4.6x, ECC 6.0
• Functional : SAP FICO, SAP CRM
• Reporting Tools : SAP BEx, WAD, Analyzer
• RDBMS : SQL Server
• Business Objects Tools: SAP Integration Tool Kit with BOXI 3.1, WEBI, DESKI, Universe Builder, Query as a Web Service, Live Office, Crystal Report, Xcelcius
• Other Applications: MS Excel, MS Access, MS PowerPoint, MS Visio, FrontPage

• SAP BW 3.5
• SAP BI 7.0

Confidential,is the world’s leading source of intelligent information for businesses and professionals. TR combine industry expertise with innovative technology to deliver critical information to leading decision makers in the financial, legal, tax and accounting, healthcare, scienceand media markets.

Role: SAP BO Consultant Duration: Mar‘09 – Mar’10
Project Description/Scope: The scope of the project was to build customized reports according to end user requirement
Environment: SAP BO 3.1, SAP BI 7.0, Crystal Report, Xcelcius, Web Intelligence, Live Office, Widgets, Import Wizard

Responsibilities/Deliverables:

• Involved in different phases of Software Development Life Cycle like requirements gathering, preparation of technical specification documents, designing and developing reports, unit testing
• Interacted with the Business Users to analyze the business process and gathered the requirements
• Gathered the User Requirements and prepared documents like detailed Functional Design Documents and Report Design Documents for Webi and Webi-Rich reports
• Experience in installing and configuring SAP Integration Kit with BO, integrated crystal with SAP BW and built reports based on BW Cubes, Infosets, R/3 Tables
• Developed semantic layer (SAP BO Universe) according to the business model and report requirements from SAP and non-SAP datasources. Created specific BO Universes based on SAP BI Sales Document Cubes namely, ZSD_C05, ZSD_C03 and non-SAP database DB2 for Sales related items not covered in SAP BI like sales promotion, marketing, incentives, campaigns etc.
• Created Purchase Document Universe based on BEX Queries (ZPUR_C04 Cube) to report directly on Vendor/Vendor master data
• Defined BO classes, objects in the non-SAP datasource Universes. Defined Cardinalities, Contexts, Joins and Aliases and resolved loops. Checked the Universes for integrity and exported to the Repository to make resources available to the users and groups and created Adhoc Reports by accessing the Universe
• Experience in designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC
• Complete understanding of Crystal Report Processing Model of three-pass reporting method to generate reports
• Generated simple and complex formatted Crystal Reports and delivered them via web, e-mail, MS Office
• Experience inserting data in Live Office Document (especially Excel) from Crystal Reports and Web Intelligence content stored in BusinessObjects repository. Manupulate data in Live Office excel spreadsheet to make it the source for creating Xcelcius dashboads
• Generated Xcelsius dashboad based interactive reports by using Tabset, Trend Analyser and Multiple graph reports like pie, bar, column charts and published them to the infoview
• Created Widgets to display KPIs
• Experience in creating Dynamic Cascade prompts using Business View Manager
• Used Import Wizard to migrate Universes from one environment to another environment
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool

Confidential,
Role: SAP BW Consultant Duration: Feb’08 – Dec ‘08
Environment: SAP BI 7.0, SAP FICO

Responsibilities/Deliverables:

• Analyzed the requirements, identified the gaps, mapped the legacy fields to BW info objects, and identified the suitable business content for FI, CO modules and had the standard info cubes, DSO and multicubes and various other relevant objects installed and activated.
• Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content. The main cubes developed were 0FIAR_C02 (Account Receivable: Transaction Data), 0FIAP_C03 (Accounts Payable), 0CCA_C11 (Cost and Allocation)
• Built custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures. Deep knowledge and experience with Query Builder, BEx Analyzer, RRI - Jump Queries and Web Application Designer. Experience with InfoSet queries.
• KPI/Metrics- Identified and gathered the requirements for the KPI Metrics. Some of the KPI Reports were (a) Financial Statements (0FI_GL_4) like P&L, Balance Sheet, Cash Flow, (b) DSO, Top 5 customers (0FI_AR_4), (c) Vendor Evaluation, Top 5 Vendors (0FI_AP_4),
• Data source enhancements, generic extractors, configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation.
• Trained the end users and power users on BI front-end toolsets such as BEx analyzer, query designer.
• Development of business process documentations.

Role: SAP BW Consultant Duration: Oct’06 – Jan’08
Environment: NW04S, BW 3.5, custom data extraction, BW model

Responsibilities/Deliverables: Leadership role for BI. Project plan, collaboration with project leadership, and mentor on all BI aspects.

Responsibilities include:

• Interacted with business end users to gather requirements and transformed them into a data model with the concept of Extended Star schema.
• Analyzed business reporting requirements that could be satisfied with SAP business content and installed the necessary objects.
• Identified data sources based on end-user reporting requirements, and created Info Cubes, extracted data from different modules like FI/CO, CCA, and COPA data.
• Extracted data from SAP R/3 using BC, Generic extractors and also from flat files.
• Creation of RRI jump queries (FI-GL queries to drilldown from CUBE level to ODS level and then to R/3 level), web publishing and ODS queries.
• Configuration of alert monitor, Job schedule monitor.
• Designed queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to required level of information in BEx Query Designer.
• Created reports from Controlling, Financial Accounting, General Ledger Accounting, Profit Centre Accounting, COPA cubes and multi-providers.
• Created complex reports like P&L Reports, Balance Sheet Reports, Causal Track Reports, Cost Centre Reports, Cash flow Reports, Trial Balance by Profit Centre Reports, KPI Reports, Capital Employed.
• Worked on SEM, BCS and BPS Cubes to create several Financial Reports.
• Created reports for Actual, Budget, Last Year, Current Year, and YTD and Variances data.
• Used advanced query features like cell editors, jump queries (RRI), global structures etc.
• Created dashboards using WAD with different kinds of graphs and charts
• Trained power users on BW data query, extraction and reporting.
• Development of business process documentation.
• Provide application support to departmental power users.
• Trained the end users in the Financial Team.
• Functional and Technical specifications documentations for BW reports.
• Improved performance of existing queries and reports by creating Aggregates, Compression and Partition etc. Tuned BW Info Cubes, aggregates, OLAP cache and query performance. Created indexes, database statistics, aggregates, efficient queries, modified the data transfer parameters, etc.
• .Achievements:
• Met the client requirements by ensuring on time delivery of the solution without compromising on the requirements.
• Provided timely advice and leadership for developing BI reporting solutions.
• Managed the project from requirement gathering to testing during realization phase.
• Developed custom BI web applications for financial reporting.
• Mentored company employees to assume day-to-day leadership of the project.
• Considerably reduced the time spent by the employees for analyzing the financial reports from 60-70 hrs a week to 40 hrs.

Role: SAP BW Consultant Duration: Feb ’05 – Aug’06
Environment: Version ECC 6.0, SAP BW 3.5, FI/CO, CRM, BEx Analyzer/Browser, WAD
Project Description/Scope: Assigned as BI Consultant for several SAP BI implementations, at the following client sites:
Florida Department of Revenue, Child Support Enforcement, Tallahassee, Florida, USA
The Home Depot, Monterey, Mexico
Noble Drilling Inc, Houston, TX, USA
Warner Chilcott Inc, New Jersey, USA and Puerto Rico

Responsibilities/Deliverables: Accountable for the full project life cycle with emphasis on the translation of the user requirements into specifications for complex logical data models, source data capture from various source systems to BW, data integrity and over all data warehouse design.

• Analyzed the requirements, identified the gaps, mapped the legacy fields to BW info objects, and identified the suitable business content for FI/CO, CRM, modules and had the standard info cubes, ODS and multi-cubes and various other relevant objects installed and activated.
• Implemented Standard Business Content Info-Cubes like Accounts Receivable Line Items (0FIAR_C03), Accounts Payable Line Items (0FIAP_C03), Costs and Allocations (0CCA_C11) for full costs on cost centers (plan, target, actual, etc.)
• Extracted and uploaded data into Info-Cubes from Data Sources like GL Line Item, Accounts Receivables, Accounts Payable, Cost and Allocation
• Built the master and transactional data process chains and scheduled accordingly to upload data into info providers.
• Optimized the performance of data targets (Info cube, ODS, Multi-cubes) by loading the data through proper selection criteria and maintained the request for each data load to compress it in the future.
• Developed standard document templates and standard practices for every object that is developed. Mentored the users and support groups on the design, data model and maintenance of the objects.
• Improved performance of existing SAP BW Queries and reports by creating Aggregates, Compression and Partition etc. Monitored BW Statistics and tuned BW Info Cubes, aggregates, OLAP cache and query performance. Created indexes, database statistics, aggregates, efficient queries, modified the data transfer parameters, etc.
• Extensively involved in publishing the Reports to Portal for the end users to access them.

Role: Education Co-ordinator Duration: Mar ’04 – Aug ‘04
Responsibilities/Deliverables:

• Reports and Queries on MS Access and Excel.
• Compile and transform data from all satellite branches and send it to HQ.
• Co-ordinate activities such as Special Events with Teachers and Volunteers.
• Manage Fund Raising Programs like BOWL-A-THONS, Golf Tournaments etc.

Role: Director Duration: 2001-2003
Responsibilities/Deliverables:

• Managed and executed strategic Internet marketing, advertising and publicity.
• Managed Consulting Sales, HR activities, P & L management.
• Member of the Katy Chamber of Commerce.
• Managed technical resources and their career development activities such as on time training, strategic planning and budgeting.

Role: Developer Duration: 1999 - 2001
Responsibilities/Deliverables: Supported design, development, implementation of EnGenius, a power management software. Supported the post implementation activities and maintenance of the software. This product was developed using PowerBuilder 5.0 and MS SQL Server 6.5
.

Role: Developer Duration: 1997 - 1999
Responsibilities/Deliverables: Designed and developed a prototype of the system using techniques of inheritance, user objects, user events, menus, and functions. Go-to Person for the user support. Supported and enhanced three Products: HEDGER (Risk Management System) and GASMAN (Gas Management System) and POWERQUEST (Power Management System) using PowerBuilder 5.0 and MS SQL Server 6.5.

Associate Company Secretary with specialization