SUMMARY

• Over 7 years of IT experience as an SAP BI/BOBJ consultant implementing SAP BI solutions for SD, MM, IM, FI, COPA, Purchasing and PP modules, leveraging SAP BEx Suite and SAP BO Suite - Advanced Analysis, WebI, XCelsius, Crystal and Deski.
• Extensive knowledge of SAP BI 7.0 integration with Business Objects Enterprise and BO OLAP Analysis tools - Web Intelligence, Dashboard Design Tool (SAP BO-BI 4.0)/Xcelsius 2008 (Dashboard), Live Office, Information Design Tool (SAP BO-BI 4.0)/Universe Designer, BI Launch Pad ( SAP BOBI 4.0)/InfoView.
• Experience using the BODS data integration tool with multisource environments.
• Experience in administrative tasks like creating users, groups, security, and scheduling reports.
• Exposed to various phases of project from Planning, Blueprinting, GAP Analysis, Development, Integration Testing, UAT, Cutover, Go-Live and Hypercare.
• Expert in following SAP ASAP Methodology and understanding Best Practices.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice andDice, Drilling methodology, prompts, Filters, Ranking, Sections, and Breaks.
• Experience in dimension modeling using Entity Relationship (ER), Multi-Dimensional/Star Schema and Extended Star Schema models.
• Proficient in various modes of extraction supported by SAP BW - mySAP Service API, DB Connect, XML, Flat files and extraction from 3rd party ETL tools.
• Installation, activation and enhancement of Standard Business Content for various industry verticals and horizontals like Financials, Logistics, CRM, and Sales Planning.
• Experience in LO Cockpit extraction, delta extraction using V3, Direct Delta and Queued Delta.
• Experience in SAP BO Universe design and Reporting (WEBI, DESKI, Crystal, XCelcius) based on OLAP (SAP BW/BI) and OLTP Systems.
• Experienced in development of Custom Reports, Dash Boards, Formatted Reports, Ad-hoc Reports and Exception Reporting.
• Proficient in SAP BO Report scheduling, Event Creation, Busting/Publication Program to Schedule Reports to run on periodic bases.
• Experience in writing Functional Design documents, Technical Specifications for data models, ETL and process flows.
• Hands on experience with Transformations including Start, End and Expert Routines.
• Expertise in working with BEx Analyzer in building Queries using Calculated Key Figures, Restricted Key Figures, Variables, Conditions, Exceptions and Aggregations.
• Expertise in handling Production Support issues with data loads, trouble shooting, Change management, Process Chains Monitoring and Transport Management.
• Performance tuning in BW using Aggregates, Compression and Partitioning.
• Performance tuning in BO using @Functions, identifying and resolving loops, Joins, Cardinalities.
• Experienced with OLAP functionalities like Scope of Analysis, Drill Analysis and Slice & Dice.
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Exposure to new reporting tools BO Analysis, BO Explorer.

TECHNICAL SKILLS

ERP Versions: ECC 6.0/ECC 5.0 and SAP R/3 - 4.7 / 4.6C

Net Weaver Versions: SAP BI 7.0, 7.1 (NW 2004s) and SAP BW 3.5 / 3.1C/ 3.0

Reporting Tools: SAP BO 4.0, BEx Suite, WAD, Business Objects 6.5, XI R/2 and XI R/3, XCelsius, Crystal Reports, WEBi, DESKI, Advanced Analysis

Modeling Tools: Microsoft Visio, Microsoft Project, Information Design Tool

ETL Tools: Informatica 5.0, IBM DataStage

Database: Teradata, Oracle 9i/8i, MS Access, SQL Server 2004/2005

Operating Systems: Microsoft Windows 2000/XP/Server 2000, OS2, Linux, UNIX, DOS

Other Tools: MS Project, MS Office, MS Visio, HP Quality Center, Mercury Tools, JavaScript, XML, Remedy, Citrix

PROFESSIONAL EXPERIENCE

Confidential, PA

SAP BO Consultant

Environment: SAP BO 4.0/3.1, WebI, IDT, UDT, XCelsius, BI 7.0, BEX Queries

Responsibilities:

• Involved in requirements gathering, development, testing and migration to Production environment.
• Developed Technical specifications, design documents and cutover procedures.
• Worked with the Corp BI team to support the Windows 7 upgrade of SAP BO XI 3.1 and SAP BO 4.0.
• Worked on developing Finance KPI Webi reports on GL, AP, AR and T&E.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, prompts, Filters, Ranking, Section, and Breaks.
• Worked on windows 7 image testing for both SAP BO 4.0 and SAP BO XI 3.1
• Tested all applications and there functionality of all the client tools in both SAP BO XI 3.1and SAP BO 4.0 (Web Intelligence Rich client, IDT, UDT, QAAWS and widgets.)
• Tested the BI launch pad and Info view in the Windows 7 environment.
• Worked with cross team members in resolving data issues and configuration issues.
• Was involved in retirement of old production system and migrating to a newer production system.
• Worked on remedy to resolve existing tickets in BW.
• Interacted with the users to resolve and better understand the issue and to provide them with resolutions to the tickets.
• Was involved in the daily and weekly status meetings to provide better understanding of the day to day work progress.
• To Resolve and fulfill SAP BW Incidents and service requests raised by business users and provide timely resolutions and updated them back in remedy once they are resolved.
• To Support the day-to-day data load monitoring, manual loading, Process chain corrections and resolve performance issues.
• To Troubleshoot the BW system and implementing corrective actions, including identifying and developing for break fix and long term improvement and stability.
• Work with administrators to optimize report performance via database tuning.
• Work with security team to implement authorizations for BI reporting.
• To perform unit, integration, application and regression testing, as well as support and participate as needed in user acceptance testing, debugging, resolving defects and production validation activities.
• Interact with end users and related teams on creating new Ad-hoc reports, data analysis and corrections, problem solving depending on the requirements.

Confidential, Aliso Viejo, CA

SAP BOBJ Consultant

Environment: SAP BO 4.0, IDT, WebI, Live Office, Crystal, Jitter Bit 4, SQL Server, Intacct, Sales Force, FI

Responsibilities:

• Involved in requirements gathering, design, development, testing and migration to Production environment and post go-live support of the Financial Package.
• Involved in the development of the various Universes for FI General Ledger, Special Ledger, Order Detail, and AR Payments.
• Developed multi-source universes using IDT (Information Design Tool) with SQL server, Intacct and Sale force Data connections.
• Designed Data Integration processes using Jitterbit and Intacct to interface the company’s Locker box Data to create AR Payments.
• Interacted with the cloud data using the Intacct XML gateway. Developed various XML codes and DTD’s to send and receive information from Intacct data base from cloud server.
• Developed Webi reports for the client Financial Package Data.
• Developed various Financial Dashboards for company’s Total Revenue, Gross Profit, EBITDA, OP-EX, COGS, Recurring and Non Recurring Revenue.
• Developed Reports for TTM (Trailing Twelve Months) Revenue, YTD Revenue and ITD Revenue.
• Provided drill downs in all the reports for various divisions, Locations, Products and Groups.
• Developed combined Queries to merge the data from various universes.
• Scheduled Webi reports and published them BI launch pad and LIVE OFFICE.
• Migrated Webi Reports from Development to QA/Production Environments using LCM(Life Cycle Manager)
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, prompts, Filters, Ranking, Section, and Breaks.
• Wide experience in analyzing, designing and developing dashboards.

Confidential, Santa Ana, CA

SAP BI/BO Consultant

Environment: BI 7.0, SAP BO 4.0, WEBi, Crystal, ECC 6.0, SD, MM, PP, IM, FI

Responsibilities:

• Involved in requirements gathering, proto typing, GAP analysis, design, development, testing and migration to Production environment and post go-live support.
• Developed Technical specifications, design documents and cutover procedures.
• Involved in the development of the various cubes for SD, MM, PP and FI.
• Worked with the R2R reporting project team that analyzes Sales, In-Transit, Demand and actual sales for Demand/Supply analysis from involves multiple Sources systems.
• Developed and supported various roll outs in phases for all international territories.
• Migrated the AR Aging reports to WEbi and integrated it with the BO Broadcasting agent.
• Developed the Daily Sales Reporting for US and Europe Regions using BEx workbooks and Macro’s coded in Visual Basic.
• Developed varies reports in the SD area of Order, Delivery and Sales Quantities, top customer analysis etc.
• Developed Queries and workbooks, structures, filters, calculated key figures, restricted key figures, exceptions and conditions for generic as well as a formatted reporting.
• Worked on developing universes using IDT/ Universe Design Tool based on SAP BW/BI BEx queries, DSO’s and Info cubes.
• Worked on developing WEBI, Crystal Reports for Sales and Distribution (SD), Finance and Control (FICO), Production and Planning Modules.
• Worked on Crystal Reports using formulas, Grouping, Parameters, Hyperlinks, Sub Reports, Running Totals and Hierarchies to handle the end user requests.
• Worked on publication to scheduled reports to run on a periodic basis.
• Worked on XCELSIUS Dashboard development using QAAWS on Production Lead Time data to know the Actual and Target Lead times for each MRP Control and Material Groups by Year/Month
• Performed performance tuning for InfoCubes/Queries through Partitioning, Aggregates and compression.
• Worked on LCM (Life Cycle Management) to migrate the objects from development to SIT, UAT and production environments.
• Worked with cross team members in resolving data issues and configuration issues.
• Addressed hyper care Incident tickets based on priority and migrated objects / code to respective environments following client guidelines.

Confidential, Stamford, CT

SAP BI/BO Consultant

Environment: BI 7.0, BW 3.x, SAP ECC 6.0, SD, FI, BO XIR3, BODS, Teradata.

Responsibilities:

• Complete life cycle implementation of SAP BI for SD and FI modules.
• Gathered requirements from users and designed documentation for BI and modeled the custom cube along with activation of business content by performing GAP analysis between blue print and business content.
• Worked with financial users and SME’s to define functions, processes, mappings, implementation and configuration in SAP Account payables, Receivables and General Ledger entries.
• Involved in various development activities for Order Analysis cube, Purchasing cube, Purchasing Forecast Cube and Customer Lead Time Analysis Cube.
• Created Multi Providers on Info Cubes (Orders, Delivery, and Billing for specific queries) and DSO for unique restricted document level data.
• Extracted the transaction data from SAP R/3 (PUR, SD and FI) and flat files to BI using LO Cockpit by maintaining the extract structures, maintaining Data Source, replicating the data sources into BI.
• Enhanced standard BI extractor to include new fields using BADI RSU5 SAPI BADI.
• Worked on performance tuning using BI Statistics, by choosing appropriate query modes and using RSRV to check info cube modeling and data. Created aggregates and indices, deleted PSA tables, DSO Change logs and performed fine tunes routines where necessary.
• Worked with basis team to schedule early watch reports in Solution Manager to monitor BI system.
• Developed report jump targets using RRI (RSBBS) to other reports. Created RRI reports for drilling down from aggregated reporting on cube to line item detail report on DSO.
• Implemented BODS (Business Objects Data Services) and Information Design Tool to integrate data from Teradata, flat files into data target, generated XML to resemble metadata.
• Created Universe using Designer component of BO XIR/3 and exported it to Info view for other users to generate reports.
• Used Business Objects Developer Suite (Publisher View, CMC, Designer, and InfoView) to perform various tasks specific to every component.
• Developed SAP BO XI 3.1 Universe and WEBI Reports for PMO’s using Universe Design tool.
• Designed and developed XCelsius usingUniverse (Query as a Web service), and also used Open Document to drill down from Dash board to detail level of reports created using Web Intelligence.
• Used Import Wizard to migrate Universes from one environment to another environment.
• Created Business Elements, Business Views to use data in CRM, Oracle and generated reports using Crystal Reports.
• Created reports, cross-tab reports using WEBi rich client by utilizing prompts, alerter etc and provided Executive Summary report of Managers and representative performances to directors as dash boards in XCelsius bound to Live Office using prompts.
• Created management reports, audit summaries & financial statement reports using XCelsius.
• Involve in building financial & budgeting reports and applying functions based on requirements.
• Used open hub destination concept to extract data from SAP BW system and loaded it into new Info Provider.
• Worked in Production support and handled batch jobs, load failures, and system issues.

Confidential, Columbus, OH

SAP BI/BO Consultant

Environment: SAP BI 7.0, ECC 6.0, SAP BO XI 3.1, WEBi, Deski, QAAWS, Crystal Reports, XCelsius 2008, SD.

Responsibilities:

• Participated in meetings with SME’s and business users to better understand the requirement and the existing data model.
• Involved in the development and support for Pricing Analyzer tool via SPA BW open-hubs.
• Designed and developed the Pricing Cube and sourced the data from CO-PA, A/R, Freight Analysis Cubes, Sample Orders, Invoice Condition history, Rebates and Consignment ODS.
• Tested the result set of DSOs and created BEx query based on the requirement and used it to develop universe using Designer component of BO XIR3.2
• Used RRI jump queries for drilling down to other queries and ECC transactions.
• Identified objects to be merged from different data providers at report level and created Webi reports leveraging prompts, conditions and alerter.
• Created variables, filters, exceptions, calculated key figures, restricted key figures, global and local structures.
• Managed transports across the environments, fixed the transport log upon failures.
• Created custom defined Cost Center Reports and SD Reports for Global Net Sales, Global Monthly Spread, Plan/Actual Periods, Analysis - Top N Vendors, Actual Cost Situation, and Analysis- Top N Internal Orders.
• Activated and modified SD Business Content Queries: KPI Overview Logistics Year-to-Date and Logistics Performance Trend Last 12 Weeks.
• Created custom defined queries, query views and integrated Filters, Free Characteristics, RKF, Business Content Variables, CKF, Exceptions and Conditions.
• Installing and configuring Business Objects, Web Intelligence and other Components of Business Objects.
• Exported Business Objects reports to WebI to be published on the Intranet, Created thin client reports through Info View.
• Involved in creation of 10 baseline universes / 45 WEBi reports
• Developed Reports with parameters, Sub-Reports, cross-tabs and charts based on Stored Procedures and Queries by using Crystal Reports.
• Designed the professional dashboards using Crystal XCelsius, QAAWS, and Live Office.
• Generated reports using stored procedures and generated Parameterized, Drill down reports.
• Resolved Loops using contexts created Dimension, Detail and Measure objects and exported Universe to the repository.
• Created Hierarchies on time, Customer, vendor and GL account.
• Created pre-defined conditions and Prompts as per requirement.
• Created reports for multi - Dimensional analysis using all Business Objects functionalities like Multiple Data Providers, prompts, Slice and Dice, Drill Down/Up/By.
• Scheduled and Distributed reports to different users by using CMC, Info View and Publisher
• Involved in designing and developing complex Web Intelligence, Client, and Ad Hoc reports for corporate data, which was stored in the Oracle database.
• Creating complex full client and Web intelligence reports using graphs, pie-charts and multiple data providers on daily, weekly, monthly and quarterly basis Reports using Business Objects XI R2.

Confidential, Memphis, TN

SAP BI/BO Consultant

Environment: BW 3.5, SAP ECC 6.0, SD, PUR, FI, BO XI, Windows XP, WebI

Responsibilities:

• Involved in gathering business requirements from users & business analysts for designing functional and tech specs.
• Customized business content Info Sources, Info Cubes and activated business content to meet business requirements.
• Created multi providers on Info Cubes (orders, delivery, and billing for specific queries) for unique restricted document level data.
• Extracted transaction data from SAP R/3 (PUR, SD and FI) and flat file to BW using LO cockpit by maintaining the extract structures, maintaining Data Source and replicating the Data Sources.
• Implemented a framework of templates, restricted key figures, calculated key figures and variables to implement common reporting structure.
• Analyzed, designed, built and tested reports while working directly with end-users and technical members of a data warehouse team.
• Involved in creating reports and its publication to corporate documents.
• Designed the Universe and exported it to the repository.
• Interacted with Project Manager and other resources in understanding the requirements and report specifications.
• Used the Broadcast Agent console for auto refreshing of Business Objects Documents.
• Defined and created dimension objects, conditions, user and measure objects to capture complex formulae.
• Worked on Web Intelligence to develop and publish thin client reports.
• Created the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice & Dice, and Drill Down
• Maintained the access & security of users.
• Interacted with Business Analysts and end users to develop standard and ad-hoc reports according to functional specifications.
• Testing Phase:
• Involved in Manual Testing of the application by developing Test Cases, Test Scripts using Quality Center by reviewing the business.
• Involved in developing UAT, Integration testing test plans.

Confidential, Secaucus, NJ

SAP BW Consultant

Environment: BW 3.5, SAP R/3 4.7, SD, MM, PP, PUR, FI

Responsibilities:

• Participated in user meetings to discuss project concept, design, and schedule. Worked with different users to gather business requirements and transformed them into a data model using Extended Star Schema model.
• Extensively involved in the enhancement of BCT Data Sources and development of Generic Data sources.
• Customizing Standard InfoSources 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 13 VDITM, 0FI AP 4 from the Business Content for Sales order and deliveries Transactional data.
• Created Info-Packages group to schedule Info-Packages to load master data.
• Wrote ABAP/4 routines to enhance business content Data Sources to meet the business requirements.
• Query development using the BEx Analyzer, BEx Browser and WAD functionality of BW. Developed flexible queries using filters, conditions, navigational attributes, calculated key figures and restricted key figures to facilitate data analysis in a drilldown or summarized way to give detailed levels of information per business application and user requirements.
• Created drill through queries from summarized Info Cube to detail ODS data.

Confidential, Okemos, MI

SAP BW Consultant

Environment: SAP BW 3.5, R/3 4.7, SAP BO 6.5, WEBi, SD, COPA, PCA, CCA and FI

Responsibilities:

• Participated as member in pilot BW implementations team in USA and contributed towards logical data modeling of Info cubes and ODS.
• Developed ODS and Info Cubes for sales and controlling areas like procurement, cost center, order status and sales overview.
• Designed Info Sources, activated transfer and update rules, scripted extraction routines using ABAP for master data, texts and hierarchies.
• Used LO extract structures for extracting sales order, delivery-billing information.
• Extended standard business contents based on client requirements using User Exit and Function Module.
• Enhanced and modified the application-specific and generic data extractors.
• Set up source systems to load both SAP/R3 and non-SAP transaction data to BW.
• Created and scheduled Info Packages for Full, Delta Initialization, and Delta updates to load both master and transaction data. Created process chains to automate the data load and data target administration.
• Extensively involved in designing complex queries for open sales order analysis, vendor performance analysis, delivery analysis, past-due sales orders, outbound shipping, and general ledger reports.

Confidential

SAP BW Consultant

Environment: SAP BW 3.1c, SAP R/3 4.6C, SD, FICO BEx

Responsibilities:

• Experience on designing Infocube, ODS, Multipoviders, Infoobjects, designed Dimensions in InfoCubes, Partitioned InfoCube by 0CALYEAR.
• Expert in data loading from Data Staging PAS, ODS, Infocube and Designed Transformations between DSO objects and InfoCube.
• Worked on FI-AP Business content and installed Line item and transaction data cubes (0FIAP C03, 0FIAP C02) from Data sources (0FI AP 4, FI AP 1) respectively.
• Extracted the data (Delta Load) using extractor (LO, COPA Extraction) 2LIS 12 VCSCL (Sales-Shipping: Schedule Line Delivery), 2LIS 13 VDITM (Billing Document Data: Items), 2LIS 11 VAITM (Sales Order Item Data), 2LIS 03 BF for material movement, 0PUR C01 Purchasing to Data Targets in BW and enhanced the data source.
• Created new infocubes as per client ZSD CQ01, ZSD CQ02 Cubes.
• Designed and executed queries in the BEx with calculated and restricted key figures, variables, structures, exceptions, conditions and RRI features.
• Created Web templates using Web Application Designer (WAD).
• Query performance improvement and monitoring using aggregates and RSRT transaction.
• Worked with security people to create new Roles for BW.
• Involved in Transport Request, Developed technical specifications, worked on RRI, web reporting.