SUMMARY

• Over 10 years of SAP experience in Business Intelligence and Business Objects along with facilitating and training experience.
• Extensive experience in BI/BW implementation/configuration (Installing Business Content, Designing, creating and maintaining MultiProvider, InfoCubes, ODS/DSO Objects, InfoSources, InfoObjects, InfoObject catalog, Infosets, Transformations and Transfer/Update rules/ABAP routines)
• Good in data modeling and re - modeling of the existing flows were taken care.
• Very good experience in BEX query designer. Created Custom Queries using Conditions, Exceptions, Variables, Exception Aggregates, RRI - Jump queries and created aggregates on Cubes to improve the query performance.
• Experience with Post-Production support including process chains and data loads, reconstruction of data targets in case of failed loads, rescheduling of process chains, debugging of transfer and update routines.
• Thorough knowledge and experience with business requirements gathering & analysis, gap assessment, development of functional and technical specifications, data modeling, loads scheduling, testing, Reports development and user training and support.
• Strong Data Warehousing experience using Business Objects XI (Designer, Xcelsius, Crystal reports 2008, Query as a Web Service, Web Intelligence, Info View).
• Proficient in using Central Management Console, Info View, Crystal Enterprise, Xcelsius, Live Office and Business Objects tools (Universe Designer, Webi, Deski and QaaWS).
• Experience in defining queries, generating drill-down report in Crystal Report.
• Technical hands-on expertise in using Business Objects 4.2, 4.1, 4.0, XI r2/ r3 / 3.1.
• Experience with SAP BI 4.1 (upto 4.2) Tools like BI launch Pad, IDT, Dash Board Design 4.0, Interactive Analysis and Analysis for Office etc..
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Expertise in developing reports using Crystal Reports on top of SAP Cubes, Queries, DSO, Tables and Universes
• Embedded flash files (Xcelsius), Webi report on to Crystal reports.
• Used various charts like pie chart, bar chart, doughnut chart, line chart and customized as per the need of the client.
• Grouping, Sectioning, Summarizing, Filtering and Slicing and Dicing were carried out efficiently in the reports developed using CR.
• Formula fields and Parameter fields were created for specific needs.
• Supplying data to flash files with the help of flash data expert and flash parameters were carried out on the report.
• Hyper-linking, insertion of images and sub-reports were handled in the reports
• Suppressing, Hiding, Underlay functions were used for effective format of the report.
• What-If Analysis concepts were formulated in the developed reports.
• Cross-Tab feature, Ranking, Top N details were furnished in the reports.
• Expert in building reports with alerts.
• Expert in Business Objects Administration, Security, Server Maintenance, Tuning, Upgrading, Patching
• Expert in developing and delivering training material to end users (both online and face to face) including executives.
• Experienced in data mapping and GAP Analysis between source and target Data in BODS as per the blueprint.
• Experienced in assisting and preparing technical specification document.
• Transformation of existing data onto SAP using BODS.
• Expert in Design, Develop, Unit Test all ETL routines in BODS.
• Very proficient in modifying and creating new Data Services jobs
• Good understanding of Data Cleansing Process

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SAP BI Lead

Responsibilities:

• Implemented SAP Analytics Cloud successfully.
• Created Models and Stories on HANA live connection.
• HANA Modelling.
• Created Attribute, Analytical, Calculation Views in HANA.
• Maintained existing .unv universes
• Created new Universes using UDT and IDT in BO 4.0
• Familiar and proficient with creating filters, families, classes, using contexts, aliases in Universes to avoid any loops, traps or cartesian products.
• Implemented multiple calendars in the universes by modifying time dimensions and reworked all reports to display in multiple calendars.
• Created new Webi reports based on the Universes and modified existing webi reports to improve performance.
• Very proficient with CMC
• Performed admin activities like promoting the reports, Universes using Promotion
• Management (Formerly LCM).
• Created user profile groups to email burst WebI reports to the users in pdf format using publication.
• Scheduled the publications based on the user field mapping in the publication to send user specific data.
• Migrated reports and universes between environments using LCM, Promotion Management in CMC (4.1)
• Maintained schedule and publication for webi reports.
• Familiar with bursting reports to users.
• Lead the upgrade project to BO 4.1 in DEV, TEST and PRODUCTION.
• Installed and implemented Explorer 4.1
• Created Information Spaces using Universes
• Created View Sets and maintained scheduled indexing of information spaces.
• Maintained and implemented security for all BOBJ tools in CMC.
• Created user groups and used AD user groups
• Implemented row level security in BOBJ on the Universe Level.
• Successfully upgraded BI environments to 4.1 and 4.2 BI Suite (also installed/implemented Design Studio).
• Successfully implemented HANA(with AWS) on BIP
• Developed HANA Views to be used in webi and also built universes, information spaces on top of analytical view and calculation views
• Also working on a POC for Business Objects Cloud and Digital Boardroom.
• Experienced in developing and delivering End User Training.

Confidential, Salt Lake City, UT

Senior SAP BO Consultant

Responsibilities:

• Interacting with the business users in identifying the requirements, prototyping the reports,
• Design and development of the reports.
• Understood the Business and gathered the requirements from the business and functional users.
• Involved in one Full Lifecycle Implementation using ASAP methodology which includes
• GAP Analysis, Requirements gathering, Blue Printing, Development, testing, Reporting, Go-
• Live and Post Go-Live support.
• Involved in installation of SAP BO 4.0 SP4.
• Design & Development of IDT universes with calculated measures and custom filters.
• Creating user groups for WebI & Crystal report email bursting with user specific data.
• Performance tuning the explorer indexing for non-accelerated version. Reduced indexing time from 4 hours to less than an hour for 2 million records.
• Created report design documents, using user training Manual.
• Working with the security team in identifying the user groups and setting up access levels for different user groups.
• Created a curriculum outlines according to course requirements in collaboration with IT
• Training Team.
• Prepared course Outlines in collaboration with IT training and Analytical team.
• Provide a weekly status report to the IT team.
• Extensively involved in training users in Web intelligence, Crystal Reports, and Xcelsius through training led scenarios.
• Business analyst experience: interacted with end users, functional/technical experts and management to identify analyze and develop the reports that meet the business needs.
• Coordination with all the users / functional Leads of all modules and gathering the requirement for BI reports.
• Configured Business Objects client tools on user machines.
• Built the new universes as per the user requirements by identifying the required data from
• SAP BI (Business Intelligence / Business Warehouse).
• Involved in performance tuning and optimization on business objects universes by creating aggregate tables.
• Extensively worked on creating contexts for the Universe based upon the Business Flow.
• Worked on Universe designing, developing and generating complex, Adhoc, dashboard
• Reports (with dynamic visibility, created filters, combo boxes), Business views, List of values along with User Acceptance Test and data accuracy Test.
• Performed Integrity testing of Universes(Universe Structure checking, Objects Parsing, Join
• Parsing, Conditions Parsing, Cardinalities checking, Loop checking and Contexts checking) after any modifications to them in terms of structures, classes and objects.
• Exported the universes to the Repository to make resources available to the users.
• Updated and maintained existing universes based on changing user requirements and changes in data source.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Generated various numbers of reports on a daily, weekly and monthly basis using
• Business Objects Report module.
• Worked with testing team in validating various reports.

Confidential, Framingham, MA

SAP BOBJ/BODS Consultant

Environment: SAP ECC, Business Objects 4.0, XI Rel2/Rel3, Designer, WebI, Import Wizard, Crystal Reports XI, Oracle 11g/10g, TOAD, Windows 2000, SQL Server 2005, SDK, Java Scripts, Java PVCS, Visio, SAP BW Infocubes, Xcelsius, Dashboards.

Responsibilities:

• Documented the user requirements into Functional Specs and Technical Specs.
• Created Data Services ETL jobs to load source data from to target table.
• Created Data Services for data cleansing and data standardizing.
• Worked with a Team to develop a complex universe and generated reports exclusively using Full client.
• Administering the entire Business Objects Suite including BO reports/Data Services management console, Data Services repository management and also configured tools like FirstLogic.
• Created and Maintained Data Services local and central repositories.
• Developed Data Integrator jobs and Data Quality workflows.
• Extensively involved in Data cleansing and standardizing using Multi Plug-in transforms in Data Quality.
• Created Universe using SAP BW Infocubes as Data Source and configured Classes and Objects based on the InfoCubes.
• Involved in Designing and Development of Universes, Classes and objects which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Detected loops, and checked the Integrity of Universes. Created Classes, Objects, Hierarchies. Created Prompts, and Filters and used Aggregated Awareness function.
• Created Derived Tables in the Universe to create frequently used reports.
• Converted Legacy .NET reports and some Crystal Reports to WebI Documents.
• Created Cascading List of Values at universe level for the Organization Hierarchy to be used in Hierarchy Prompt for various reports.
• Used Contexts and Aliases to resolve Chasm Traps and Fan Traps.
• Built complex formulas in the WebI documents to accommodate business rules and report Formatting.
• Created Several Standard reports WebI Documents for various Departments, which uses refresh on Open so that each time Prompts are presented to the users to select the report Criteria.
• Created reports in Crystal, WebI and Deski using all the functionalities (@ Functions, Case Syntaxes, Open Doc.
• Involved in using Job Server in creation of batch jobs. And also involved in Performance tuning at source, transformation, and target levels.

Confidential, Atlanta GA

SAP Business Objects Data Services Reports Developer/Trainer

Environment: Data Services XI 3.2,SAP BI 7.0, BEx Query Designer, Universe Designer, Xcelsius 2008 Enterprise.

Responsibilities:

• Created DS Jobs to develop reports for Material Usage, Billing, Account and Equipment Information.
• Worked on Active Customer Data Cleansing, and loading data back in to Data Warehouse using Data Services.
• Created Jobs in Data Integrator to load the data from spread sheet which has been validated by other teams in General Mills in to Data warehouse and also made this job incremental
• Created DS extract jobs to extract data RDBMS tables to SAP BW system and also exported the job execution parameters to SAP BW system.
• Worked on performance Tuning of long running jobs used techniques like pushing down operations to database level, Degree of Parallelism, collect statistics to monitor jobs.
• Scheduled and Monitor jobs using Data Integrator Management console.
• Worked on various Data Integrator transforms like Table Comparison, Map Operation, History Preserving, Row generation, Key Generation, Pivot, Validation, Query transforms.
• Created Scripts like starting script and ending script for each job, sending the job notification to users using scripts and declaring the variables local and Global Variables.
• Responsible for testing the ETL jobs in QA before moving them to Production.
• Created training material and held briefings/training sessions with end users.
• Facilitated multiple webinars as well as face to face briefings.
• Assisted Project Manager with coming up with the training curriculum.
• Responsible for providing agenda for refreshers and hot topics based on feedback from end users.
• Created PowerPoint presentation and Computer Based Training Initiatives.

Confidential, Princeton, NJ

SAP Business Objects Data Services Developer/Trainer

Environment: Business Objects Data Integrator XIR2 Accelerated 11.7.2.2,Business Objects XI R2(Supervisor, Designer, Reporter), WebI, Cystal Report 2008API, Xcelsius 4.5,DB2,MS Access, Windows 2000 Server, Unix, Oracle 9i, SQL*Plus, PL/SQL, TOAD, Erwin 3.1.

Responsibilities:

• Interacted with Project Manager and Business Analyst to understand the requirements and modified universe to cater report specifications.
• Interacted with business analysts and End client to understand technical and functional requirements for creating new Job. Written Data Services/Data Integrator Scripts for File existence check, Daily incremental read, Daily Incremental update, workflow level Script read, workflow level Script update, workflow level Error Handling and Job Dependency.
• Defined database Data Stores to allow Data Services/Data Integrator to connect to the source or target database.
• Used Business Objects Data Services/Data Integrator for ETL extraction, transformation and loading data from heterogeneous source systems.
• Created Data Services/Data Quality workflow to clean and standardize names and address using USA and multi plug-in address transforms.
• Extracting Data from different sources like SAP ECC and flat files and loading them into requested target flat files, excel sheets, Oracle Tables in Data Services/Data Integrator.
• Integrated DQ workflows with DI ETL jobs with cleansing and matching logic.
• Cleaned data from different sources and matching among the source data and matched against the corporate data to find the Master and subordinates and avoid duplicates entries into the system.
• Created Scripts like starting script and ending script for each job and declaring the variables local and Global Variables.
• Defined separate data store for each database to allow Data Services/Data Integrator to connect to the source or target database.
• Tune the simple and complex transformations in Data Flows.
• Used Business Objects Data Services/Data Integrator interactive debugger to test the jobs and fixed the bugs.
• Created different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Documented the deviations from the original specifications and employed Enhancements on complex reports and also optimized the usage of user objects, conditions and universe level filters and also write test cases and test scripts to validate the queries.
• Conducted multiple focus groups to get the feedback from end users
• Created training material based on the feedback in the form of self initiated training
• Proposed a new and effective method of training to shorten the length of the training and covering the key pain points.

Confidential, Memphis, TN

Sr Business Objects Consultant

Environment: Business Objects XI Rel2/Rel3, Designer, WebI, Import Wizard, Crystal Reports XI, Oracle 10g, Windows 2000, SQL Server 2005, Xcelsius, Dashboards.

Responsibilities:

• Documented the user requirements into Functional Specs and Technical Specs.
• Involved in Designing and Development of Universes, Classes and objects which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Detected loops, and checked the Integrity of Universes and also Created Classes, Objects, Hierarchies.Created Prompts, Filters and used Aggregated Awareness function.
• Built complex formulas in the WebI documents to accommodate business rules and report Formatting.
• Created Several Standard reports WebI Documents for various Departments, which uses refresh on Open so that each time Prompts are presented to the users to select the report Criteria.
• Prepared Documentation to understand how the reports will work and how to use the functionality with step by step also called as Data maps.
• Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.
• Created customized Web Intelligence reports as a source data for Live Office to Integrate Xcelsius on Corporate dashboards.
• Involved in Installation of Crystal Xcelsius, Query as Web Service, Live Office Add in (Client) and created dashboards.
• Created different types of Dashboards according to end user requirements Using Crystal Xcelsius.
• Changed the info view page layout by adding new features like the company details instead of the Business Objects logo by using the customization methods.
• Used User response function in BO to capture the Prompt Answers and displayed them in the Report.
• Applied Complex Alerter (Conditional Formatting) for a report, which has Critical Missing fields for the Missing Field Reports.
• Defined User Hierarchies so that report users can Drill from Summary report to Detail report.
• Performed GAP Analysis to bring more Data for the Business users according to their needs. After completing GAP Analysis, assisted Various Department in how to get the required Data through ETL process.

Confidential, Jersey City, NJ

Business Objects Consultant

Environment: Xcelsius 4.5/ 2008, Deski, Designer, SQL Server 2003

Responsibilities:

• Involved in the requirement gathering, documentation and business discussions with the client.
• Designed and developed the wire frames for the dashboard reports.
• Enabled bi-directional data flow. The Xcelsius dashboards were input enabled and passed the selection to the BI queries through WS and the WS populated the resultant data onto the Excel embedded in Xcelsius.
• Extensively used Web Service connection and also used Flash variable to input values to the dashboard.
• Used multiple WS connection and ingeniously made WS calls for various selection with optimized performance.
• Developed various Sales perspective dashboards viz Sales Overview, Sales by Sales Person, Sales by Product line and Sales by Region.
• Developed dashboards for Production, Balance Sheet, Top N Customers, AR analysis, Inventory, Bad Debt.
• Extensively used various components including Gauges, Scorecards, Charts (Pie, Bar, Column, Line, Combination charts, Maps and other selection boxes) which best suit for the analyzation.
• Made use of alerts in gauges, charts, scorecards and maps with dynamic band ranges which varies with selection made by other components. (what-if-analysis)
• Intuitively displayed the key KPIs for the respective dashboards for better analyzation.
• Developed to analyze data of various periods selected such as Monthly, Quarterly, Year to Date, Annual for CY, PY and PY-1.
• Further filtrations can be done in various dashboards with respect to the Divisions, Versions, Industry and Channel.
• Enabled Drilling from one component (pie, bar charts, scorecards and maps) to another with ease of use to the user.
• Maintained themes and color coding though out all dashboards.
• Made cosmetic changes as per the users requirement.
• Developed Pop-up windows, alerts like traffic light, multi colored line charts (actual in one color and the budget in another from the month where actual ends), User instructions displayed as a dialogue window by hovering on the respective windows help
• Enabled data to be displayed when hovered on the charts.
• Dashboards includ visualization of the business process as Sales Funnels, by displaying the different stages involved and the opportunity of sales persons.
• Changes been executed as per the end users need.
• Trained end users on navigation of the UI.
• Full training was given to the end users development team for the maintenance of the dashboard reports.
• Development and Training documents were prepared and furnished to the team.

Confidential

BO Consultant

Environment: BOE XI, Universe Designer, Xcelsius 4.5, Deski, Import Wizard, SQl Server 2003.

Responsibilities:

• Interacted with Business Analysts, Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Interacted with the Data Warehouse team and suggested ideas to improve the model which can help improve the performance of generating reports.
• Analyzed data from the data source before designing the universe.
• Created the repository and defined the users and privileges for the Users to access the system and taken care of the security for the repository data.
• Created derived tables at the universe level to reduce the complexity of universe building.
• Enabled BEx queries to be available for reporting using Business Objects.
• Created Universe using the standard and supplied ad-hoc queries.
• Worked with the functional team in adding various fields to the standard queries and made use of it in developing Universes.
• Created new universe connection with Teradata and created a universe on top of it and consumed data to Webi
• Used Web Intelligence, Infoview, reporter and explorer for querying, reporting and analysis tasks.
• Involved in testing and fixing issues in Universes, Reports, Objects, Conditions and LOVs List of Values.
• Used predefined conditions and prompts to filter the data in the universes.
• Applied Multi dimensional analysis like slice and dice, drill functions on the reports.
• Used various techniques like Breaks, Sorting, Ranking, Report Filtering, Query Filtering, Alters and sections to develop the WebI reports.
• Generated various numbers of reports on a daily, weekly and monthly basis using WebI and DeskI.
• Provided security in the Universe by updating the SQL to recognize and authenticate the BO User while querying.
• Created Calendars in CMS and scheduled reports to run on weekly, biweekly or monthly basis, according to end user requirements.
• Exported the reports to PDF and Excel formats.
• Created Web Intelligence reports, graphs and charts facilitating drill down.
• Maintained and modified the existing reports depending on the user requirements.
• Pointed some of the reports to the new universe, tested and deployed them into production.
• Improved the performance of the reports by identifying the issues and recommending aggregate tables and creating indexes.
• Recommended changes to the existing universes.
• Created Hierarchies to facilitate drill down.
• Defined cardinalities, Checked integrity, Detected loops and resolved them by using aliases and contexts to remove the cyclic dependencies.
• Developed Ad hoc reports using Business Objects.
• Resolved loops by creating aliases and contexts using Business Objects Designer.
• Trained and mentored less experienced BO and Crystal Reports developers on building their skills to assist in the development and testing of new reports.