SUMMARY

• Over 8 years of total IT experience in SAP BW 7.3/7.0/3.X, SAP BO 4.0, XI 3.1 with excellent Project Management, Business Analysis and strong Communication Skills
• Involved in all phases of project life cycle starting from requirement gathering till post go - live support which includes 3 SAP full life cycle implementation projects.
• Strong experience in Business Objects 4.0/XI 3.1/XIR2/6.x/5.x.
• Expertise in building the Reporting Applications from scratch with OLAP/OLTP environments.
• Extensive work experience in application development, customization & configuration of various Data Models in SAP BW/BOBJ. Hands-on experience on SAP BOBJ Tools like Crystal Reports, Xcelsius, Web Intelligence, PM Dashboards.
• Expert in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test (UAT) and data accuracy test.
• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
• Extensively worked in Crystal Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, drilling reports, analysis reports, data reports along with Dynamic LOV using Business View Manager.
• Ability to analyse existing systems, conceptualize and design new ones, and deploying innovative solutions with high standards of quality.
• Involved in all the phases of project using ASAP Methodology which includes AS-IS, TO-BE, BBP, Configuration, Testing and Go-Live activities.
• Experience with successfully managing all aspects of Development, Testing, Migration, Implementation and Production Support using SAP BO BI Platform 4.x, Business Objects XI 3.x, BW 7.x/3.x
• Good Knowledge in SAP HANA data modeling using Attribute View, Analytic View and Calculation View
• Good Knowledge in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
• Excellent cross-functional knowledge of FI/CO, SD, MM and PP modules in SAP R/3.
• Worked extensively in business processes across various SAP functional modules like Travel Management, Case Management, Spend Performance Management, PM, MM etc.
• Expertise in the front end business warehouse components like BEX analyzer, Query designer, Universe, Web Application Designer, Web Reports, WEBI, X-Celsius (Dash Boards).
• Excellent Production Support Skills including Data loads, Reporting related Issues, Archiving, Performance Issues, and Data Compression Activities
• Hands on experience on both Load performance tuning and Report performance tuning by creating DB Statistics, Aggregation, OLAP Cache, Compression, Indexes and Partitioning
• Hands on experience on KPI Analysis and Identifying the Value Drivers for the Client’s Business Process.
• Very fluent with business process documentation and end-users training/knowledge transfer.
• Demonstrated ability to complete multiple assignments simultaneously and maintain high standards of client organizations.

TECHNICAL SKILLS

ERP Tools: SAP ECC 5.0/6.0, SAP R/3 4.6 C/4.7 Enterprise, (Business Areas MM, SD, PP and FI/CO)

Business Intelligence Tools: SAP BI7.3, SAP BI7.0, SAP BW 3.0b, 3.1, 3.5

Reporting Tools: SAP BO enterprise XI, SAP BOBI Platform 4.0, Crystal Reports 2008/2011, Xcelsius 2008/2011, Crystal Reports for Enterprise, Query Builder, BEx Analyzer, WAD, Report Designer, Enterprise Portal

Programming Tools: C, ABAP/4, JAVA, SQL, PL/SQL, HTML, and VB 6.0.

Operating Systems: WINDOWS 2000 Server, WINDOWS NT 4.0, UNIX, WINDOWS XP/98/95 and LINUX.

Databases: ORACLE 8i, DB2, MS ACCESS, SQL Server and Teradata

Presentation/Utility Tools: MS-Office, MS-Project

PROFESSIONAL EXPERIENCE

Confidential, Bentonville, AR

SAP BOBJ/HANA Architect

Responsibilities:

• Involved in full life cycle implementation of SAP Spend Performance Management (SPM) and SAP Travel Management module including Gap Analysis, Blue-Printing, Design, Development and Testing of Security Authorization.
• Created many Proof of Concepts to help understand the requirement with the Business and also to analyze the performance issues in the design
• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
• Involved in gathering the reporting requirements by conducting workshops for crystal and Webi Reports and also designed the backend flow for SAP BW 7.3.
• Installed SAP SPM Starter Kit and perform initial configurations and customizations.
• Worked on POC for getting the correct data design for the new Crystal Enterprise Reports.
• Created hybrid info providers to get data displayed on the fly.
• Used the wizard to create the data flows in SAP BW 7.3.
• Created generic extractor using function modules, views, tables to extract data into SAP BW 7.3
• Worked with Basis to guide them in setting up the BOBJ landscape and integrated with SAP BW landscape.
• Involved in doing the entire configuration required for SAP BW and SAP BOBJ integration.
• Involved in creation of Master BEx Queries for Crystal Reports.
• Connected Webi with SAP 7.3 using BWCS connectivity and created reports on top of it.
• Designed the strategy for BO enterprise security on the top of SAP BW Security for Folder level access to different end users.
• Raised OSS notes and worked closely with SAP tech teams in resolving bugs in the current version of the Crystal Enterprise.
• Successfully migrated all the reports to the three systems available as part of the landscape using LCM.
• Worked on Dashboards to display summary-level business data in a rich and intuitive format.
• Designed interactive and dynamic dashboards with the KPIs using the categories and components of Dashboards.
• Created interactive Dashboards using different scorecards, chart types and tables.
• Experience in using OpenDoc to call child reports from parent reports in Dashboards.
• Exclusively used QWAAS and Live Office to import data to spreadsheet and develop visually rich dashboards.
• Work with client counterparts in assessing existing reports and recommend KPI and design strategy and roadmap for future system.
• Manage deliverables and communicated the project level updates to leadership team and global counterparts
• Managed system development, testing, cutover and post go-live support using an onshore-offshore delivery model.
• Supported Functional Unit Testing and Integration testing of delivered Reports.
• Took part in the preparation of Project plan, user acceptance testing.
• Facilitated collection of user requirements, business requirements
• Regular interaction with the functional team and end users to understand their Reporting Requirements and creating related informational document
• Worked with the client team to perform “As Is”/ “To Be” analysis, GAP analysis, feasibility analysis, prototyping, unit and integration testing.
• Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team while doing their testing process.
• Involved in creating the functional specification documents and functional unit test scripts as per the design.
• Actively involved in developing UTC (Unit Test Scripts) for Travel & Expense BI Ad hoc Report which was rolled out as part of Phase I release and other ECC objects with quick turnaround time maintaining zero delinquency
• Took part in the preparation of Functional Unit Test cases as well as user acceptance testing for both Audit BI report and T&E Adhoc BI report.
• Followed up on the defects regularly to meet the deadlines.
• Prepared and analyzed the existing architecture
• Worked with functional team to perform extensive testing on queries before coordinating the production change requests (transports) with SAP Basis team.
• Personally trained over 20 users on Web Analyzer, BEx Analyzer and workbooks.
• Developed different Data Targets for GL/AR/AP data and T&E and handling the data transformations specific to Countries at the Transformations and DTPs.
• Participated in the Data Reconciliation Activities in Post Implementation Process and fixed different Data Loading and Reporting Performance Issues by taking suitable measures.
• Involved in solving the User Generated Tickets without missing the SLA.
• Prepared and analyzed the System Statistics information and Proposed various Performance Tuning Techniques and Implemented on Approval.
• Involved in monitoring the successful running of the Process Chains, taking Measures and Correcting the Data Load Errors.
• Involved in creating the country specific local chains and Global Meta chains keeping in view the dependencies of different loads on different jobs in the Heterogeneous Landscape and handled the Scenario with the help of Events and Interrupt process type.
• Completed training with u-Perform documentation software.

Environment: SAP BI7.3 SP5, SAP ECC6.0 EHP5, SRM, SPM 3.0, SAP BOBI Platform 4.0 SP7, Crystal Enterprise 4.0 SP7, Webi, Dashboards 2011 SP7

Confidential, Tallahassee, FL

SAP BW/BOBJ Lead

Responsibilities:

• Involved in full life cycle implementation including Blue-Printing, Gap/Overlap Analysis, Design, Development and Testing phase.
• Responsibilities included handling various activities of the project like information gathering, analyzing the information gathered, documenting the functional or business requirements.
• Involved as a key member of project teams through all phases of realization, go-live, rollout and post implementation support of SAP BW in FI and CRM modules
• Involved in gathering the reporting requirements for Establishment and Compliance Reports.
• Extensively involved in designing the BI data flows based on the inputs provided by the functional teams.
• Designing of Technical Specs based on the Functional Specs.
• Configuring CRM system to get data into SAP BI systems.
• Creating Generic Extractors using function modules and also making them delta enabled.
• Enhanced data sources 0CRM SALES ACT 1 and 0CRM SRV CONTRACT H with custom fields and populated with user exits.
• Actively involved in UAT defect resolution with quick turnaround time maintaining zero delinquency
• Involved in SAP BI Pilot Cutover activities
• Performed BI data loads and Validations in Mock-IV and Pilot BI Systems
• Pro-Actively involved in Performance Tuning of huge volume of data loads in Pilot BI System especially for ZCD BMST and ZCOBPID loads by configuring the SNRO settings for data packages and tweaking the indexes.
• Responsible for stabilizing the ‘BATCH SCHEDULE’ process run through OPCON tool used by Client and helped in smooth transitioning and successful hand shake between CRM, Interfaces, BI and DQXI processes.
• Published the Crystal Reports from Crystal Tool to SAP BW and SAP BO Enterprise
• Identified the Standard content for the BW Reports and activated them from the BW Business Content.
• Worked with Basis to guide them in setting up the BOBJ landscape and integrated with SAP BW landscape.
• Involved in doing the entire configuration required for SAP BW and SAP BOBJ integration.
• Used SAP BW Publisher Service to publish the Crystal Reports from Crystal Tool to SAP BW and SAP BO Enterprise.
• Designed the strategy for BO enterprise security on the top of SAP BW Security for Folder level access to different end users.
• Integrated SAP BW with Crystal Reports and created Crystal reports based on Bex Queries.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to create reports which is accurate and easier for the analysis.
• Created Cross tab reports, Charts, Drilldown reports, Formulas, hyperlinks, Percentage reports, Prompts using Crystal Reports 2008.
• Configured SAP BW Publisher Service to publish Crystal Reports from Different landscapes of BW to BOE server.
• Helped Security team in setting up roles in BOE server for end users.

Environment: SAP ECC6.0, SAP CRM 2007, SAP BI7.0 EHP1 SP6, SAP BO enterprise XI 3.1 SP2 FP 4, Crystal Reports 2008 SP2, Xcelsius 2008 SP2, SAP Integration Kit XI 3.1 SP2 FP4

Confidential, Houston, TX

SAP BI/BO Techno-Functional Lead

Responsibilities:

• Implemented Sales and Profitability Analysis project in SAP configuring BW.
• Involved in all phases of project from Blueprinting, Configuration, Development, Integration Testing, Cutover, and Training to Go Live.
• Involved in designing and configuring the Data Model for BW.
• Authored Data modeling documents and Process Flows.
• Assisted responsible teams in developing Custom Cubes using the Standard Info Cubes 0SD C04 (Deliveries info Cube) for Sales back order reporting purposes.
• Helped gather requirements for developing flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information. Developed SD Queries.
• Sales Back Orders
• Total future orders
• Shipped pieces by GI date
• Involved in creating the Functional and technical specification documents and developed the objects as per the design.
• Involved in gathering the reporting requirements for FI, AM, MM by conducting workshops.
• Worked on LO-Cockpit Extraction for the Inventory Management i.e. 2LIS 03 BX, 2LIS 03 BF, and 2LIS 03 UM. Enhanced the BW extract structure for the Inventory Management Data Source using RSAP0001. Also worked on the function modules related to these enhancements i.e., EXIT SAPLRSAP 001, and EXIT SAPLRSAP 002 for customizing the extraction for the transaction data as well as the master data
• Involved in IT discussions to guide them on the Server Sizing for setting up the SAP BOBJ landscape.
• Involved in creating the Info providers, Info sets, Multi Providers, Transformations, DTP’s, Info packages and Process Chains for SCM (Supply Chain Management) - ‘Inventory Management’ and ‘Procurement’ module implementation.
• Involved in Creating the Generic data sources and generic deltas by using function modules using ABAP.
• Helped ABAP team in understanding the requirement to develop ABAP Program which would trigger the RSCRM BAPI Extract dynamically and automated the process by including it in daily process chain and also creating ABAP Program to delete previous day’s requests from Info Cube dynamically and including it in the Process Chain.
• Involved as a key member of project teams through all phases of realization, go-live, rollout and post implementation support of SAP BW in FI and CRM modules
• Involved in Designing the Delta Extraction and Loading Mechanism for the data from the Source Systems keeping in view of various Performance Aspects.
• Created ABAP programs to activate the transformations in BW 7.0 and DTPs in Quality System.
• Created universes on top of legacy databases according to end user requirements and Designed Webi reports on top of them.
• Configured BOE server to publish Webi reports in BOE.
• Configured live office to refresh the data on a periodic basis.
• Configured Xcelsius and created multiple dashboards based on Webi reports.

Environment: SAP ECC6.0, SAP BI7.0, FI, MM, SD, BEx Analyzer, SAP BO enterprise XI 3.1 SP2 FP 4, Crystal Reports 2008 SP2, Xcelsius 2008 SP2, SAP Integration Kit XI 3.1 SP2 FP4

Confidential, CA

SAP BW Senior Consultant

Responsibilities:

• Involved in full life cycle implementation including Blue-Printing, Gap/Overlap Analysis, Design, Development and Testing phase.
• Responsibilities included handling various activities of the project like information gathering, analyzing the information gathered, documenting the functional or business requirements.
• Worked with the client team to perform “AS-IS”/ “TO-BE” analysis, GAP analysis, feasibility analysis, prototyping, unit and integration testing.
• Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team while doing their testing process.
• Involved in creating the functional specification documents and functional unit test scripts as per the design.
• Drive service excellence and client value through analytics, best practices, quality principles, best in class technology and tools, process and productivity benchmarking for the healthcare industry.
• Gathering end-user requirements for reports, scorecards, dashboards in implementing KPI's (Key Performance Indicators) and operational/ad-hoc reports.
• Involved in Developing the Dashboard to build the Partner functions for their business analysis based on country rollouts.
• Involved in gathering the reporting requirements for FI, AM, MM and HCM by conducting workshops.
• Identified the Standard content for the BW Reports and activated them from the BW Business Content.
• Involved in creating the Functional and technical specification documents and developed the objects as per the design.
• Involved in Code development in ECC and BW as and when required as per the customization requirements.
• Involved in handling the complete BI Security at the BEx level and used BEx queries as the Basic layer for the Crystal Reports.
• Worked with Basis to guide them in setting up the BOBJ landscape and integrated with SAP BW landscape.
• Involved in doing the entire configuration required for SAP BW and SAP BOBJ integration.
• Involved in creation of Master BEx Queries for Crystal Reports.
• Used SAP BW Publisher Service to publish the Crystal Reports from Crystal Tool to SAP BW and SAP BO Enterprise.
• Designed the strategy for BO enterprise security on the top of SAP BW Security for Folder level access to different end users.
• Involved in creating the Info providers, Info sets, Multi Providers, Transformations, DTP’s and also Info packages for PM (Practice Management) module implementation.
• Involved in Creating the Generic data sources and generic deltas by using function modules using ABAP.
• Responsible for development of ABAP Program to trigger the RSCRM BAPI Extract dynamically and automated the process by including it in daily process chain.
• Involved in creating the Workbooks and Queries using BEx Analyzer and also worked extensively in creating the Web Templates using WAD to build the Dashboard.
• Worked extensively in installing the BI Statistics and Performance monitoring.
• Worked in building the dashboard for the modules FI-CO and HR.
• Monitoring of the data load jobs and process chains maintenance for info packages.
• Responsible for Analysis, Development, Testing and User acceptance

Environment: SAP ECC6.0, SAP BI7.0, FI, MM, SD, BEx Analyzer, and WAD SAP BO enterprise XI 3.0 SP2 FP 4, Crystal Reports 2008 SP2, Xcelsius 2008 SP2, SAP Integration Kit XI 3.0 SP2

Confidential, Bellevue, WA

SAP BW Consultant

Responsibilities:

• Involved in redesigning entire FI-AA Data Model for BW to in corporate ALM (Asset and Liability Management) data from R/3.
• Responsible for BW Back-End Data Load Extractions in Asset Accounting.
• Worked extensively with Asset Transaction Data Extractors like 0FI AA 11 & 0FI AA 12 and
• Asset Master Data Extractors like 0ASSET ATTR TEXT, 0ASSET AFAB ATTR, 0ASSET CLAS TEXT, 0DEPREC KEY TEXT.
• Worked with FI-AA, FI-GL, redesigned Info cubes, ODS, Aggregates, Info sets and defined queries in the BEx Analyzer and presenting the result in workbook and integrating the workbook with BEx Browser.
• Extracted data, initialized delta for uploading of transaction data from R/3 systems. Enhanced Data sources 0FIGL 01, 0FIGL 04 and involved in designing user exits.
• Involved in creating Transports for the AWB objects and Queries using Transport Connection.
• Configured Process Chain API’s to get a list of Process Chains, to start a Process Chain, to monitor the Execution State of Process Chain Run.
• Involved in Upgrade activity from BW 3.5 to Netweaver version on SAP BI 7.0.
• BI 7.0 Upgrade Activities include Upgrade Strategy planning, OSS, Consistency Checks, Upgrade Phases, post-upgrade checks, Conversions and adjustments, rescheduling jobs, support packs, etc.
• Involved in the Pre Upgrade & Post Upgrade Activities for BI Plug-In Upgrade on the R/3 from 2003.1 SP 10 to 2004.1 SP 12
• Extensively worked on the new features of BI 7.0 (NW 2004S) like Data Transformations,Data Transfer Process, Remodeling of the Info Cubes, Data Store Objects and the New Data Sources.
• Extensively worked on Start routine, routines in the transformations and End routine.
• Migrated 3.x Data sources to BI Datasources.
• Migrating Library Items from 3.1C to 3.5 and from 3.5 to 7.0
• Worked with Security team to define the New Analysis Authorization concept.
• Provided support for data load, validation, performance monitoring and tuning.
• Responsible for the creation of BI Naming Convention document.
• SAP BW Data warehouse Architecture Design, Physical and Logical data modeling
• BW Reporting, Business Content, Generic extraction.
• Worked on LO-Cockpit Extraction for the Inventory Management i.e. 2LIS 03 BX, 2LIS 03 BF, and 2LIS 03 UM. Enhanced the BW extract structure for the Inventory Management Data Source using RSAP0001. Also worked on the function modules related to these enhancements i.e., EXIT SAPLRSAP 001, and EXIT SAPLRSAP 002 for customizing the extraction for the transaction data as well as the master data.
• Worked on custom reports like vendors without materials, materials without vendors, spend data by material group, consolidated spend history, and purchase price variance.
• Customized Info Objects to match report requirements by creating variables in BEx and creating Info Cubes based on the data content. Created Multi Cubes such as Demand cube, Supply Cube and Inventory Cube.
• Analyzed and Mapped Business Processes to BW and wrote Business Blue Prints using ASAP methodology. Analyzed and activated Relevant Business Content and setup R/3, Flat File and BW as source systems. Reconciliation of data from various sources including legacy systems as Present Data ware houses.
• Involved in Upgrade activity from BW 3.5 to Netweaver version on SAP BI 7.0.
• Performed Regression Testing in different servers when new patches are applied.
• Involved in Weekly, Monthly, Quarterly and Annual Data Loadings and performed Repeat Deltas, Repair Full Requests on need basis.
• Provided support for data load, validation, performance monitoring and tuning.
• Developed reports using query designer, BEx analyzer and web application designer.
• Configured use of restricted key figures, structures, variables and calculated key figures in queries.
• Created conditions, exceptions and filters for query evaluations, including follow-up actions for mail and reporting agent.
• Worked with Web Application Designer (WAD) to create templates for presenting the Bank Balance sheet, P&L account, Income statements.
• Created a BEx query for presenting various reports to report the demand plan by planning area.
• Used Report Designer to publish the reports in portal.

Environment: SAP BW 3.5, SAP R/3 4.7 Enterprise, SAP BI 7.0, ECC 5.0, FI-AA, HR, MM, SD, BEx Analyzer, and WAD.