SUMMARY

• Certified SAP BW/BI Techno - Functional Consultant.
• 10 years' experience with SAP Business Warehouse / Intelligence including both backend cube development and front-end reporting experience in Business Objects.
• 8+ years’ experience with BI 7.x.
• 6+ years’ experience in developing SAP BO BI 4.2 using the full suite of BO tools; WEBI, Analysis for Office/OLAP, Design Studio and Lumira.
• 2 years of experience with SAP BW on HANA.
• 4 Full Life Cycle Implementation with SAP BW including both backend cube development and front-end reporting experience in Business Objects.
• BW 7.4 experience in extracting data from the function modules - SD, MM, FI/CO, SCM - DP, PM, PP, BI-IPs, HR LSO
• Experience in developing SAP BO BI 4.2 Universes, Web Intelligence, Crystal Reports, Dash boards.
• Data modeling with SAP BW on HANA with HANA Studio and HANA Views.
• Extensively Worked on SAP HANA Modeler, Designing Schemas, Creating Packages, Attribute / Analytical / Calculation views, Analytic Privileges, Stored Procedures and CE Functions.
• Strong expertise in SAP HANA Data Provisioning/Replication techniques like SLT, SAP BODS 4.0/4.1
• Experience on BW 7.4 on HANA and HANA Modelling using ADSO, Open ODS Views, Smart Data Access, Transient, Virtual, and Composite Providers.
• ABAP coding and debugging skills, code performance tuning
• Experience with SAP BW/BI Authorization Analysis and with SAP BW-Integrated Planning
• Experience in BW / BOBJ Administration with Analysis Authorization & Single Sign On and performance tuning activities.
• Strong Knowledge on the Change & Transport Management of BW objects across the Landscape
• Expertise in Performance Tuning & Optimization
• Experience in the handling Operations & Maintenance activities in BW Production system (Production Support activities like Data loading, Batch Job Monitoring & Troubleshooting)
• Experience in Platform Upgrades & Regression Testing of the BW Platform
• Expertise in BI Integrated Planning
• Researching and Implementing OSS Notes
• Proficient in developing and executing test scenarios including regression testing, utilizing SAP related software testing tools where appropriate
• Strong tracking, coordination and project planning skills

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SAP BW BI Analyst

ENVIRONMENT: SAP NetWeaver 7.4, SAP BOBJ 4.2, SAP ERP 6.0, HANA, Enterprise Portal, Solution Manager

RESPONSIBILITIES:

• Extracted the data from SAP ECC for the FI/CO, SD, CRM, and Procurement and configured the InfoObjects, InfoCubes, DSO, MultiProviders, Process Chains, DataSources.
• Created generic data sources with the function modules, COPA as per the requirement.
• Developed adhoc reports with Web Intelligence reports, story boards with Lumira, Crystal reports and dashboards on top of BEx queries.
• Experience in administration with Single Sign On between SAP BW and SAP BI BOBJ.
• Created Process chains and done performance tuning activities like DB statistics, Indexes, Line Item dimensions.
• Developed/configured Transformations, DTP’s, Start & End Routines to meet requirements at optimum performance
• Created the Test cases, Test Strategies and executed the Unit Testing and the UAT for the Entire environment.
• Open hub destination is used to transfer the data from BW to COGOS.
• Developed SAP BW Objects leveraging LSA/LSA++ Architecture.
• Supporting BI Integrated Planning - switching the cube - loading/planning, unlocking the users.
• Providing the SAP BO WebI Tool training to the End users.
• Resolving tickets with in SLA, CRQ for L2 tickets to enhance the reports
• Monitoring and performance tuning the process chains.
• Perform other related duties given by Client Manager.

Confidential

Sr. SAP BW BI Consultant

ENVIRONMENT: SAP HANA SPS 11, SAP NetWeaver 7.3, SAP BOBJ 4.1, SAP ERP 6.0

RESPONSIBILITIES:

• Development and support of reporting solutions usingSAPBusiness Information Warehouse (BW), Business Objects Business Intelligence (BI).
• Architected the solutions from a technical standpoint to ensure flexible and robust reporting solutions.
• Scheduling & Monitoring of Daily, Weekly and Monthly Process Chains.
• Involved in solving Customer Issues within SLAs
• Work from the functional/business requirements to design and developBWobjects (install standard objects, enhance existing objects, and create custom objects) like info objects, business content, info sources, data targets, transfer rules, update rules, BEx queries etc.
• Installed and configured BOBJ 4.2 Environment.
• Implemented Migration process for Business Objects BI 4.1 to 4.2 such as readiness assessment and deployment plan, Migration and system Upgrades, Co-Existence Planning, Deployment services and Education delivery.
• Developed Complex Universes by linking different data sources.
• Fine-tuned universes and reports by creating aggregate tables and filters.
• Developed the highly summarized dash boards using Dashboard design
• SAPBWdata modeling and BOBJ universe design, Reporting tool(BOBJ) such as Webi, Design Studio, Dashboard and SAP Lumira.
• Document test plans. Execute unit testing of development objects and reports. Work with business resources to complete integration and user acceptance testing.
• Involved in all phases of a Project life cycle including analysis, design, development, testing, and deployment of solutions.
• Developed data flow diagrams, functional design and technical design documents for BI Solutions.
• Installed/configured the Business Content - SD, MM, HR, FI Info Providers.
• Developed/ configured the InfoObjects, InfoCubes, DSO, MultiProviders, Process Chains, DataSources.
• Generated various Drill down reports and Alerts. Business Intelligence reports using Web Intelligence module.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.
• Worked with the users for defining the report needs and helped designing queries using Bex.
• Created complex formulas to support various business functionalities using crystal reports.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Worked on Real Time Info Cube and Data source object and also new and enhanced administration and monitoring features.
• Extracted the data from SAP ERP into BW through Generic, LO Cockpit, Business Content and COPA Data sources for the functional areas like SD, MM and FI-CO
• Implemented Single Sign On between SAP BW and SAP BO BI
• Providing the SAP BO Webi Tool training to the End users
• Created Queries with BEx User Exit Variables, Restricted Key Figures, Calculated Key Figures etc.
• Perform other BI related duties given by BI Country Manager

Confidential

SAP BW / BI

ENVIRONMENT: SAP NetWeaver 7.0, SAP Business Objects BI 4.1, SAP ECC 6.0, Tableau 8.1

RESPONSIBILITIES:

• Collaborate with business clients and requestors to analyze requirements and to define, develop and configure proposed solutions
• Collaborate with BI Administrators, Developers and Analysts for successful development of BI reporting and analysis solutions.
• Define an overall data warehouse and business intelligence strategy, data architecture, data models, and related standards
• Design the Architecture, SAP BW (Info Providers, Multi Providers, Info Cube, DSOs etc.) as backend and SAP BO (Universe, WebI), Tableau as Front end.
• Extracted the data from SAP ECC into BW through Generic, LO Cockpit.
• Develop security and authentication standards for the organization.
• Support BI tools upgrades in development, testing and documentation.
• Providing the SAP BO Webi Tool training to the End users
• Diagnose and resolve BI tool capacity issues and recommend strategies to improve performance and capacity of BI tools.
• Implemented Single Sign On between SAP BW and SAP BO BI
• Responsible for management of the project operating budgets as assigned.

Confidential, Houston, TX

Sr. SAP BI BW Consultant

ENVIRONMENT: SAP NetWeaver 7.31, SAP Business Objects BI 4.1, SAP ECC 6.0, SAP SCM 5.10, DB Connect - ORACLE, MERIDIUM. UD Connect - COGNOS, ARIS BI Modeler

RESPONSIBILITIES:

• Scheduling & Monitoring of Daily, Weekly and Monthly Process Chains.
• Involved in solving Customer Issues within SLAs
• Worked in Upgrade projects and also at several downtimes
• Involved in all phases of a Project life cycle including analysis, design, development, testing, and deployment of solutions.
• Developed data flow diagrams, functional design and technical design documents for BI Solutions
• Developed very complex Queries in BEx with BEx User Exit Variables, Restricted Key Figures, Calculated Key Figures, Structures, Conditions, Exceptions etc
• Activated/customized the Business Content, developed/configured Info Cubes, DSO, MultiProviders, Process Chains, Enhanced the Data Sources, developed Generic Extractors (APO, ECC, Oracle) as per business requirements
• Responsible for the requirement gathering, Analysis, Design, Data Modeling, Developing the BI objects, Data Extraction, Data Loading, Scheduling, Monitoring, Process Chains, creation of Queries.
• Developed & implemented SAP BO Universes, Web Intelligence (Webi Reports) and Xcelsius Dashboards
• Gathered business requirements, interacted with business analysts and the End Users.
• Worked extensively with the Business Objects Designer in preparing Universes from the warehouse database.
• Created and maintained around Lumira, Design Studio and Web Intelligence reports.
• Providing the SAP BO Webi Tool training to the End users
• Used BW Statistics, Query Monitor, Aggregates, Compressions, Line item dimensions to improve the loading & Query performance
• Interacted with senior management and business leaders to elicit business and technical information in order to produce high quality decision making solutions.
• Responsible for defining and driving the use of standards for BI work and review the quality of the development work, Housekeeping activities and TR create/release through Solman.

Confidential, Houston, TX

SAP BI Consultant

ENVIRONMENT: SAP NetWeaver BI 7.0, ECC 6.0, HP-UNIX, Oracle

RESPONSIBILITIES:

• Ensure the creation of solutions will address quality, performance, availability, scalability, and integrity
• Conducted Gap Analysis and gathered end user business requirement for HR LSO modules.
• Interacted with business users, business analysts and process team to gather Business Requirements and analyzed the requirements to develop the BI solutions
• Developed Business Blueprint, Configuration Document and Technical Specifications.
• Used standard cubes and created customized cubes and DSO’s according to the requirement.
• Installed and activated business content objects such as Info Cubes, Data Store Objects, Queries and Transformation Rules etc for HR LSO module. Developed BEx Report, Workbooks and Web Based Queries.
• Designed Web templates and Dashboards for CEO level reporting.
• Formatted BEx queries by using Report designer tool as per the END User requirement.
• Developed Web Application Designer reports by using client standard templates for BEx reports and Report Designer reports.
• Identified Roles and Authorization for various queries.
• Transported various objects across the system landscape.
• Performed Unit test and data reconciliation for LSO module, along with the functional consultant.
• Process Chains where created for Transaction Data, Master Data (Attribute, Text and Hierarchy) for different data flows across all modules.
• Created end user and power user training manuals, LLD’s, HLD’S and support documents.
• Worked along with developed LSO reports, successful Go live HR LSO modules.

Confidential, KY

BI Offshore Lead

ENVIRONMENT: SAP NetWeaver BI 7.0, ECC 6.0, Windows Server 2003, MS SQL

RESPONSIBILITIES:

• Attended BI Workshops in Design Phase.
• The Business Intelligence Reporting Strategy serves as a guide throughout the remainder of the current project, as well as subsequent implementations. Major topics addressed within this deliverable include Methodology and Standards, Technical and Procedural Reporting Infrastructure, Business Intelligence Organizational Structure, Organizational Readiness/Change Management, and Report Tool Selection Processes.
• Business Intelligence Technical Architecture Design provides the steps to create the appropriate system landscape and technical architecture for the data warehouse system.
• Data Warehouse Extractor Design is a completed extractor design and definition for each source system and used to create the technical specification.
• Data Warehouse Infocube Design validates the star schema design through the info cube design in such a way that maximizes query performance while meeting information requirements.