SUMMARY

• Over 7+ years of experience in Design, development and implementation of Business Intelligence Applications using Business Objects Enterprise (XI4.x / XI 3.1 / XI R2) and BI/BW implementation.
• Excellent work experience of Web Intelligence, Universe Designer, Crystal Reports, Import Wizard, Central management Console (CMC), Migrated BOXI R2 to BOXI 3.1Business Objects reporting system.
• Excellent understanding of Normalization and demoralization of schemas, designed star schemas wif snow flake dimensions
• Developed Universes on STAR / Snow Flake schemas of the Data Marts, Extensively used tables, views, stored procedures and functions for complex reports.
• Experience in interaction wif the Business Analysts, identifying the needs & the requirements of the system and involving in requirement study of the system, Strong Knowledge wif Star Schema and Snow Flake Schema Data Models.
• Proven ability to grasp business needs, evaluate priorities, and apply computer technologies to deliver practical enterprise solutions, Implemented and provided training in using Business Objects Suite of products and generated a report for end users wifin a few hours to a day wif minimal instructions.
• Performed Unit and Integration Testing of Reports and Universes and migrated objects from development to QA to production using Import Wizard.
• Involved in 3 Full life Cycle implementations of BIBO projects and one full life cycle implementation of BI project.
• Experienced wif SAP methodology, including project preparation, gathering requirement, business blue print, realization, post user support and end user documentation and training under deadlines.
• Extensive experience in business processes across the following modules: FI/CO, MM, SD, PP, SRM, CRM and APO Demand Planning functions.
• In - depth knowledge of BW Data Architecture.
• Data modeling: Business Information components skills in Data modeling like Info Objects, Info Providers, Info Sources, Transformation routines, DTP, DSO, start and end routines using data warehouse workbench.
• Data Extraction: Proficient in Data Extraction from SAP R/3, flat files and BW using extraction structures such as LO-COCKPIT and Generic Extractors.
• Experienced wif BW Reporting: Expertise in Front-End Business Warehouse components like Query development, Reporting agent, Calculated and Restricted key figures, structures, variables, BEx analyzer, Web Templates, WAD, Web Reports and Jump analysis.
• Experienced in Web Intelligence, Business Objects universe designing, Business Objects Desktop Intelligence, Business View Manager, Info View, and Business Objects Enterprise (BOE).
• Expertise in Integrating Business objects tools wif SAP BI/BW and designing Universes.
• Expertise in building Multi Providers, multi cubes and Info sets as required by the query.
• Extensive experience in query and load performance using aggregates, Rollups, Indexes, partitions and Info-cube Compression techniques. Evaluated statistical performance on OLAP using BW statistics.
• BW Transports: Frequently involved in monitoring the extractors, data loads and reports before going into production and transporting the BW objects Developments into quality and finally to production.
• Experienced wif Unit Testing on the complete data flow of the model developed from source system through BI, user acceptance testing and data validation testing and prepared documentation. Planned the cut over activities before go live and performed the downtime activities.
• Involved in documenting functional specifications, technical specifications, test cases, test results and production support documents.

TECHNICAL SKILLS

Data Warehouse: SAP BW 3.5, SAP R/3, SAP BI 7.0

R/3 Interfaces: EDI, ALE, IDOC, and BAPI

Operating Systems: Windows 95/98/2000/XP/Vista/Windows 7, MS-DOS.

Languages: ABAP/4, C, C++, SQL

BI and Reporting Tools: Business Objects 4.0,XI R3/XI/XIR2/XI3.1/6.5/, DesignerWEBI, CMC, Xcelsius 2008, Dashboard, Info view, Crystal ReportsData Integrator XI, Data Services.

Database: Ms-SQL, Oracle10g, MS Access

PROFESSIONAL EXPERIENCE

Confidential, Camp Hill, PA

SAP BO Developer

Responsibilities:

• Involved in requirement gathering for the project.
• Involved in the migration of the reports from BO 2.0 to BO 4.1 using the Promotion Management Tool.
• Analyzing business requirements.
• Analysis of the environment.
• Interacted wif Business Users to know their Business views in modifying Universes and Reports accordingly.
• Tuned and enhanced existing universes.
• Modified universes to accommodate complex database design approaches.
• Created the regression testing documentation for the 49 reports and 15 Universes.
• Analyzing business requirements.
• Involved in the migration of the reports from BO 2.0 to BO 4.1 using the Promotion Management Tool.
• Validated all the 15 Universes after migration from Oracle to SQL.
• Testing in Development and SIT environment for DMM reports.
• Well versed wif database functionalities. Universe required sound knowledge of Oracle and SQL capabilities and semantics.
• Implemented complex functionality in both universe and report level using SQL.
• Resolved the errors in the SQL scripts like concat, NVL, NVL2, Decode, substr, rounding function etc.
• Created the Universe deployment documentation and Reports deployment documentation for the users.
• Performed the UAT testing of the DMM reports.
• Performed reports testing by comparing DEV and UAT to resolve the issues and errors in the DMM reports.
• Implemented complex functionality in both universe and report level using SQL.
• Experienced in writing SQL and understanding PL/SQL.
• Interacted wif Business Users to know their Business views in developing and modifying Universes and Reports accordingly.
• Involved in the requirement gathering for the project.
• Involved in gathering business rules to develop logical models.
• Analyzing business requirements.
• Documented user requirements, translated Functional requirements into Technical Requirements.
• Demonstrated several demos to business owner and user community to have a strong understanding about Business Objects application dat we developed and product features.
• Worked on WDQI design documentation. Created the mock-ups for the 10 policy questions to be answered by the Webi reports.
• Analysis of the environment and connections
• Involved in creating the technical documentation for Data Encryption of PII based on the $Universe.
• Converted business requirements in business/technical requirement documents.
• Developed universes to accommodate complex database design approaches.
• Implemented complex functionality in both universe and report level using SQL.
• Involved in creating the report mapping document wif ETL team.
• Created the WDQI Universe Model document.
• Implemented Filters, conditions in the Universe to the run the Reports quickly.
• Tuned and Enhanced Universes wif SQL Queries for the Report Performance.
• Created user defined @prompts and complex conditions at Universe level for better performance.
• Involved in creating the WDQI reports. We created reports on ‘Return on Investment’ (ROI) and ‘Supply and Demand’ (SD). ROI have 6 reports and SD have 4 reports.
• Interacted wif technical and non-technical users to gather, document and implement reporting Requirements.
• Worked in the Team closely wif Functional Architect, DBA and Analysts to get a clear understanding on the Application.
• Created the measures for the reports.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Generated Reports from Different Data Providers in Business Objects using a Normalized Schema Database.
• Created highly formatted reports to visually represent data.
• Validated measures, suppression logics, report layout, data errors.
• Created document for WDQI universe deployment and report deployment.
• Prepared Documentation to understand how the reports will work and how to use the functionality wif step by step.
• Created test cases and performed them for WDQI - ROI and SD reports.
• Validated the ROI and SD report as per the deliverables in SIT environment.
• Regression testing for all the reports in Dev, SIT and UAT.
• Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.
• Supported and trained users in developing and ad-hoc reports.

Confidential, Richmond, VA

SAP BO Developer

Responsibilities:

• Involved in gathering business requirements and implemented logical and physical data modeling using star and snow flake schemas in a data warehousing environment of Oracle and SQL Server
• Used Business Objects IDT 4.0 to build multi source universes, resolved loops and Chasm trap in the database schema, Involved in performance tuning and optimization on Business objects Universes by creating Aggregate aware objects
• Worked on converting number of desktop intelligence reports to Webi reports
• Provided support to the converted Deski Reports
• Developed dashboards using query as a web service and live office to merge data from multiple data providers
• Managed offshore team, provided them wif onsite assistance of gathering requirements from the end users onsite.
• Migrated from Business Objects 3.1 to Business Objects 4.0 used UMT and promotion manager
• Configured cluster of BOBJ 4.0 server to use Windows AD as single sign on and BIG IP as load balancer
• Interacted wif Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing Universes
• Created Snow-flake dimension for summary tables
• Updated and maintained existing Universes based on changing user requirements and based on changes in data source.
• Created new classes, objects and made structural changes to Universes in Designer which includes adding new objects, updating tables and joins

Environment: Business Objects 4.0 Web Intelligence, IDT / UDT Designer, Info view, CMC UMT promotion Manager, Dashboard Design

Confidential, Houston, TX

SAP BOBJ Developer

Responsibilities:

• Created Universe from multiple data source by making use of multiple connections and mapping them in the Data Foundation Layer, created multiple Business Layers, and assigned accessed based on different User groups.
• Involved in Installation and configuration of SAP Business Objects 4.0 and Migrated BO contents from BOXI 3.1 to BO 4.0 using Upgrade Management Tool, Information Design Tool.
• Provided the user training to work independently on the new environment
• Analyzed and re-engineered various reports in BOBJ 4.0 environments.
• Involved in gathering business requirements and implemented logical and physical data modeling using star and snow flake schemas in a data warehousing environment of Oracle and SQL Server
• Created Complex Dashboards usingCrystal Solutions Dashboard and Visualization (XCelsius)
• UsedCrystal Dashboard design and Crystal Presentation Design(both in-built templates and customized templates) to transform complex data in a more consolidated and powerful interactive dashboards
• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, @Functions and more.
• Involved in the troubleshooting of universe schema wif loops, chasm and fan traps, and cardinality problems.
• Created Multiple Custom Hierarchies for several groups to provide drill across functionality.
• Converted reports from desktop Intelligence to web intelligence using Report conversion tool and manual conversion method.
• Implemented Row level and Object Level security as per the user requirement.
• Extensively Designed & Deployed System Reports, Custom Reports, User Report, Ad Hoc Queries by incorporating the functionalities of Sort and Drill Down.
• Designed and Developed WebI Reports using the features like Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down, @Functions and Formulae to analyze the data.
• Created Web Intelligence reports wif multiple data providers like Universes, Personal Data Files and free hand SQL
• Created Interactive Dashboard using Dashboard Designer4.0.
• Used multi value components like line charts, bar charts, stacked column charts and combination charts, and single value components like gauge, slider, dial and progress bars in the development of the Dashboards.
• Performed BO Scheduling - monitoring for scheduled reports & error notifications.
• Regularly took back of reports and Universe using Import Wizard and creating BIAR files.
• Manually performed System Testing, Regression Testing and Functional Testing. Generated Test data for identifying valid data, Invalid data, Partial data, and Bad data using SQL in SQL Server.

Confidential, Oakland, CA

SAP BO Consultant

Responsibilities:

• Responsible for installing Business Objects, Xcelsius and Crystal Report client tools for different users.
• Created Complex Dashboards usingCrystal Solutions Dashboard and Visualization (XCelsius)
• UsedCrystal Dashboard design and Crystal Presentation Design(both in-built templates and customized templates) to transform complex data in a more consolidated and powerful interactive dashboards
• Installed and Configured BO XIR3.1 on multiple servers in various environments.
• An Excel Data Template was designed and distributed to the regional Managers. The regional managers tan populated dis data sheet which was embedded into aCrystal XcelsiusDashboard model to generate the first manual version of the dashboard.
• Custom Data source/Info cubes/Info objects for accommodating the global data available across the organization. Used LO Cockpit, Generic, Flat File and DB extractions to retrieve SAP and Non-SAP data for reporting in SD, MM, PP and FI-CO modules and company's legacy systems.
• Extensively worked on Enhancements for populating the records to the newly added components in the Data sources.
• Prepared the Strategy, Scope and Analyzed the Business process to be modeled.
• Created the Technical specifications for BI Content Modeling for SD, PP and MM modules.
• Installed the BI Content and extended the content to add custom info objects. Modeled and created the end to end connectivity using Custom data sources, info sources and transformations.
• Created generic data sources wif Function module extraction method.
• Created process chains for periodic upload of master data, transactional data, and text data and scheduled and monitored the data loads wif delta update and full update mechanisms.
• Generated month to date and year to date reports for MM and FI and monthly distribution reports for Human Resources.
• Created Aggregates on Info Cubes to improve the query performance.
• Developed transformations wif start routine, update routine and end routine and involved in the creation and maintenance of DTP and Info Packages for loading data in to data targets.
• Created formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures for developing complex custom reports.
• Activating and filling the Aggregates for better Performance.
• Developed BEX reports on Delivery, Billing, Inventory, Account Receivable and general ledger
• Involved in the Issues raised by the End-users.
• Transported BI Objects From Development System to Quality System and to Production.
• Used Query as a Web Service tool, Live Office and generated various WSDLs using the web services, and successfully tested them in the Crystal XCelsius 2008 tool to develop the Dash boards based on the Business requirement.
• Created alerts, breaks, filters and ranks in the report using Webi.
• Developed Reports using BEX Analyzer/Browser, Workbooks to meet the business requirement.
• Designed the data requirements by analyzing the existing Impromptu reports.
• Demonstrated Crystal's strength by enhancing the report performance as much as 70 percent when compared to Impromptu reports mainly by using materialized views and stored procedures to develop Crystal Reports.
• Created Universes over BEX queries and Info cubes of SAP BI using Universe Designer.
• Maintained Process chains to automate and schedule background performance tuning jobs of BI query using Indices, aggregates, Compression and Partition.
• Defined Dynamic Cascading Prompts in Business Views for crystal reports development.
• Involved in developing complex MM related Bobj, Webi reports wif different metrics.
• Used Import wizard to migrate the Bobj reports to different environments.
• Scheduled crystal reports and Implemented dynamic cascading prompts.
• Involved in Testing of Reports for end users.
• Performed flexible and direct update to load transaction and master data.
• Worked on BEX Analyzer, Browser and WAD (Web Application Designer) tools to generate reports related SD, and MM.

Confidential, Dallas, TX

SAP BO Developer

Responsibilities:

• Updated and maintained universes based on changing user requirements, exported Business Objects reports to the repository for sharing purposes, created custom reports like Gross Margin, Accounts Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to User needs
• Created universes, detected Joins, checked cardinalities, created classes wif dimension, detail & measure objects using universe designer.
• Resolved universe problems like Loops, chasm traps, fan traps using alias and context, developed custom hierarchies to support drill down reports, created derived tables in designer to enhance the capabilities and performance of the universe, implemented cascading prompts in universe, worked extensively wif
• @functions (@select, @prompt, @where) to overcome the problems wif database when integrating wif Business Objects, and checked the integrity of the universes.
• Designed universes for finance department to offer reports for billing system and order processing, Created period reports: shift or daily report, weekly, monthly and annual reports.
• Created Canned/Ad-hoc Reports using Webi on a daily, weekly and monthly bases as per the user requirements, created complex reports by bringing data from multiple data sources and combining them using merged dimensions option, extensively used Business Objects reporting functionalities such as sections, tracking, drill, sort, filters, ranking, graphs and breaks.
• Extensively used context operators, along wif other operators and functions to manipulate the display of the report, created several complex variables as per the user requirements, extensively worked on scheduling reports using Info view, exported the reports from Dev to UAT and tan to production using LCM tool.
• Offered Business Objects Webi training to business Users, designed and developed various dashboards for Finance, Marketing and Performance Dashboards wif Xcelsius and BI Widgets for rang of uses.
• Created several users and user groups and assigned them various access levels in CMC, created and deployed security structure according to the client requirements, increased timeouts of Info view and WEBI java report panel, tweaked BOE servers to get optimum performance for the environment
• Helped windows group to create marimba packages to remotely deploy/rollout client tools to end users, participated in the data validation of the migrated reports, clustered Prod and DR machines for failover, deployed Service Pack on BOE servers and created and enhanced file event based publications.
• Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Extensively worked on Data design and Data modeling using Extended Star Schema.
• Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Multi Providers, Info Sources, Info sets, Time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc. Also involved in new features of SAP BI security like Analysis authorization.
• Worked extensively on Profit Center Accounting data sources such as 0EC PCA 1, 0EC PCA 2.
• Implemented FI cubes such as 0FIAR C02, 0FIAR C03, 0FIAP C03, and ODS such as 0FIAR O03, and 0FIAP O03 wif proper transfer rules and update rules.
• Designed functional and Technical specifications for Implementation and Development of BO XI 3.1 over SAP BI.
• Experience in handling SAP Business Objects Data Services.
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC-BI CMOD, Generic Extractions and also in BI data modelling like Start Routines and End Routines.
• Created Aggregates on Info Cubes to improve the query performance.
• Created BEX queries for reporting on Info Cubes, Info Sets, ODS and Multi Provider.
• Responsible for developing Analytical Reports wif multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI.
• Created universes, classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
• Involved in the migration and deployment of the universes and reports across multiple domains.
• Successfully implemented transports of BOBJ in SAP BI environment.
• Extensively Worked in SAP Live Office to create connections between WEBI and Xcelcius Dashboards.
• Followed and implemented ASAP methodology.
• Created Web Planning Layouts in BI-IP using Input Ready Query and Web Application Designer.
• Created (Master/Detail, Cross tab, Chart templates) reports using Crystal Reports.
• Performed unit testing, system integration testing, and user acceptance testing of Crystal Reports at various levels.
• Loaded Master and Transaction data using Process Chains.
• Developed BW reports using BEX Analyzer, created queries wif Variables, restricted key figures, calculated key figures, conditions, exceptions etc.
• Created Multi Providers/Info Set (union/joining DSO, Cubes, and master data objects).
• Created Queries by defining structures, variables, formulas, exceptions, navigational attributes, conditions providing drill down functionality in reporting.
• Defined and modeled queries to satisfy business analysis.
• Excellent team player wif good logical reasoning ability, coordination and interpersonal skills.

Confidential, Dallas, TX

SAP BW/BI Functional Consultant

Responsibilities:

• Responsible for developing BI data models and designs, configuring custom and delivered BI content, analyzing BI reporting requirements, developing detailed reporting specifications.
• Analyzing the Function Inputs. Interacting wif functional team to resolve the issues in the given objects.
• Development of technical specifications for the developments assigned.
• Ensuring a high quality solution for all the delivered objects to the client wifin the schedule.
• Customized existing financial Info cubes, DSO & Multi providers according to business needs in SAP BI.
• Enhanced new Info Objects to be attached/mapped in Info Sources/Communication structures. Changed transformation rules as per customer requirements using ABAP routines).
• Extensively worked on Data source enhancement of business content cube by appending structure, User Exits & Customized Delta built up for the Data sources.
• Created Generic Data source using DB View Extraction method for CRM Master Data.
• Interacted wif CRM Marketing and Sales Business users, attended Workshops and analyzed business requirements for design and development of Pipeline reporting.
• Extracted daily deltas of Cost Center actual from ECC data source 0CO OM CCA 9.
• Extracted Cost center statistical key figure actual for headcount from ECC data source 0CO OM CCA 3.
• Enhanced Activity data source (0CRM SALES ACT 1) in CRM to add custom fields like owner Id and buyer contact fields.
• Created custom Multi Provider to support FIAR users, which is a two-cube structure joining one custom FI (company info) cube wif one business content AR cube, and allowing users to drill down the customer details and ledger accounts.
• Worked on accounts payable cubes 0FIAP CO2 and accounts receivable cubes 0FIAR C03.
• Developed Data Source for CO-PA on basis of operating concern and developed DSO object for the Data sources and generated reports.
• Extracted data from MM modules and uploaded the data into the procurement cubes via 2LIS 02 HDR, 2LIS 02 ITM and 2LIS 02 SCL and activated the appropriate Business Content cube.
• Worked extensively on OTC, TCM, PTP and RTR reporting using BEx.
• Worked on Performance Optimization of CRM reports based on the analysis after implementation of BI Accelerators.
• Modified existing reports to go additional new functionality to end users.
• Query development using the BEX Analyzer/Browser, Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way.
• Also implemented Pre-Calculation of queries using Information Broadcaster, where BI Accelerator doesn’t improve the performance.
• Worked on Web Application Designer and published reports on web.
• Involved in customizing web templates to add multiple tabs.
• Created Query to report on Cost Center Detail dat provides Cost Center manager an overview of the planned costs and plan changes for the selected cost center in the reporting time frame dat covers the previous and current year.
• Extensively Worked in SAP Live Office to create connections b/w WEB me and Xcelsius Dashboards.
• Performed end user training sessions in reporting scenarios, and documented the whole project. Assisted in defining SAP Security Guidelines.