Summary:

Around 9 years of IT experience as SAP BW/BO consultant with expertise in 24x7 BW Production Support, Implementation, Upgrade and front end reporting with BEx Query Designer, Web Application Designer, Webi, Xcelsius Crystal Reports, SAP Solution Manager and Pre sales activities including Team Lead experience

TECHNICAL EXPERTISE:

• Good experience in Requirement Gathering, Gap Analysis, Design, Development, Testing, Maintenance, Troubleshooting, Documentation and Performance Tuning
• Complete life cycle implementation, with experience in all areas of SAP BW viz. Data Modeling, Extraction, Staging and Reporting
• Data extraction from SAP R/3 ECC into BW using different extraction structures. Implemented various BI solutions in logistics area SD, MM, financial area GL, AP, AR and controlling area CCA, PCA and CO-PA
• Proficient in Data Modeling using BW extended star schema models. BW Design - Info Cubes, DSOs, Info Sources, Info Object maintenance, Info sets, Hierarchies, Multi providers, Update rules, Transfer rules, Transformations, Info Packages, DTPs
• Strong Production Support experience Good at Process Chain maintenance, Housekeeping activities and troubleshooting with quick turnaround in fixing the issues
• Expertise in Data load monitoring, Process Chain scheduling, Data source Enhancement, Data Extraction, loading Full /Delta , Data Mart and Open Hub Service, Performance Tuning, Aggregates and Transport Organizer
• Extensively worked on design and development of Queries, Reports, Workbooks using BEx Query Designer, Analyzer, Report Designer, dashboards using WAD and Business Objects tools viz.Webi, Xcelsius, Crystal Reports
• Experience in Integrating and extracting data into Business Objects environment from SAP BW system. Created and modified several Webi/Xcelsius/Crystal reports per user requirements
• Good experience in migrating data flows from SAP BW 3.5 to BI 7.x and implementing new functionalities of BI 7.x
• SAP Solution Manager expertise includes Project Management, Blueprinting, Configuration and Testing
• Working knowledge of SAP BI 7.3 and HANA modeling
• Assisted in ongoing communications to SAP and BW end-users on business process and systems changes, and issue resolutions.
• Documented functional and technical specifications for Production Support and Change Requests for Project enhancements.
• ABAP knowledge of enhancing various data sources, customer-exit variables, creating transfer update rules, start, end and expert routines
• Created and modified Crystal Reports using SAP BEx queries Universes
• Good Experience in Xcelsius using Liveoffice, QAWS Connectivity and using BICS Created QAWS connectivity to Universe for refreshing Xcelsius with current data
• Performance tuning of Queries by maintaining Aggregates, Compression, Partition, Indexing and use of Statistics
• Involved in Presales activities like working for various proposals, walk through and case studies
• Conducted training sessions on SAP BW/BO and Solution Manager

PROJECT DETAILS

Confidential

Role: SAP Consultant

Environment: SAP BW 3.5/ 7.0 /7.3, Business Objects 4.0 Web Intelligence, Xcelsius, Crystal Reports, Design Studio

Responsibilities:

• Leading project team and sub team activities to ensure timely deliverables
• Actively participated in all customer meetings and provided status updates on data availability, critical issues, system performance etc.,
• Handled several high priority tickets related to various BW areas viz. Extraction, Data Loads, reporting and BW data validations against ECC source data
• Planned and executed the month/year end outage activities as part of maintenance team
• Involved in daily, weekly and monthly monitoring jobs which include monitoring data loads, aggregate fillings, roll ups, process chain maintenance and taking corrective actions, wherever necessary
• Resolved various data load issues and documented the fixes as how-to guides to the team
• Extensive experience in enhancing the data model viz. Data source, InfoSource, InfoCube and other BW Objects
• Created InfoSources for transactional data, master data/ texts, attributes, and hierarchies
• Created and Maintained Transfer Structures, Communication Structures and developed routines in transfer rules and update rules for the key figures as well as characteristics
• Extensively worked on Transport organizer
• Created and modified several BEx queries using Condition reporting, Exception highlighting, Restricted key figures, Calculated key figures, Variables, Filters, Free Characteristics using BEx Query Designer, RRI Report to Report Interface , Structures, Cell definitions etc., and Web Application Designer using web items like Tabs, Charts, Tables etc.,
• Worked with BEx Broadcaster to distribute workbooks to the end users
• Uploaded data into APO InfoCubes and conducted data validations with BW cubes
• Created various data sources on planning areas and extracted the forecast data into BW for reporting on actuals and planned values
• Created process chains in BW ,APO systems and automated various tasks using different process types viz. scheduling Info Packages, ABAP program, calling remote process chain, reporting agent
• Improved system performance by process chain modifications, re designing the data flows, data retention and backup plans etc.,
• Designed Universes using BW data and R/3 data sources and developed reports in Webi, Xcelsius Dashboards and Crystal Reports using reporting functionalities like Drill, Filters, Alerts, Formulas, Variables, Multi Data Providers, Ranking, Merging, Sections, Query Panel, Report Panel, Formatting etc.,
• Good Experience in Xcelsius using Liveoffice, QAWS Connectivity and using BICS
• Created Crystal Reports using SAP BEx queries Universes
• Created and maintained functional and technical specification documents adhering Quality Regulations

Confidential

Role: SAP BW Consultant

Environment: SAP BW 3.5/ 7.0

Responsibilities:

• Involved in Blueprint and Requirement gathering phase and Identified the gaps w.r.t standard BW content and the report requirements
• Gathered requirements for dashboard creation, analyzed the existing data flows, and suggested modifications/ enhancements Implemented enhancements to the existing applications to cater to the cash flow dashboard requirement
• Creation of BW objects viz. Info objects, DSOs, Cubes, Multiproviders and the corresponding data flows for different Cash Flow Categories in NA and Global regions to facilitate reporting
• Worked on various Data Sources related to General Ledger, Account Receivables, Billings, Sales, and Deliveries
• Created queries on InfoCubes and extensively worked on BEx Query Builder objects viz. Filters, Structures, Exceptions, Free Characteristics, Restricted Key Figures, Calculated key figures, Exceptions, Conditions and RRI - Jump queries, Structures, Cell definition etc.,
• Worked on WAD 7.0 for creation of Dashboards with web items like tabs, charts, tables etc.,
• As part of technical upgrade, Supported BASIS team during the Post Refresh and pre-upgrade activities of the Development, Quality and Production Environments
• Involved in activities like deleting temporary tables, ensuring up to date DB statistics, checking for the inactive objects and re-scheduling loads/process chains
• Post upgrade activities like activation of source systems, checking the Info Sources, activating transfer structures, re-scheduling loads and process chains and addressing issues in log file
• Involved in preparing Test Plans, Test Cases, and Upgrade cutover plan

Confidential

Role: SAP BW/BI Consultant,

Environment: SAP BW 3.5/7.0, SAP Solution Manager 4.0

Responsibilities:

• Involved in implementing enhancements to the existing application as per the requirements
• Gathered requirements from client, analyzed existing data flows and provided GAP analysis with the needed modifications/ enhancements
• Worked on various Data Sources related to General Ledger, Account Receivables, Billings, Sales, and Deliveries
• Included additional fields in the extract structures for Custom extractors to extract data from ECC, APO into BW in the Logistics Extract structure-customizing cockpit
• Created and customized the existing Info Cubes, DSOs, Multi Providers and Info Sets.
• Created Communication Structure, Transfer rules, Transfer routines, InfoCube and ODS Objects for Flat file Extraction
• Extensively worked on DTPs, Transformations, Info Packages and PSA
• Created and maintained aggregates, rollup of data using process chains, after the successful extraction of transaction data
• Involved in managing of InfoCube, which involves InfoCube content, performance issues like Indexes, Statistics, Compression of InfoCube and Rolling up the data to the aggregates
• Extensively worked with PSA in Monitoring and the Data Transfer from R/3 Source System into BW
• Develop flexible queries using BEx Reporting tools using filters, navigational attributes etc., to facilitate data analysis in drill down or summarized way to give detailed levels of information
• Used RRI to drill down from InfoCube pre-queries to detail DSO result set queries
• Extensively worked on BEx Query Designer using Calculated and Restricted Key Figures, Restricted characteristics, Structures, Variables, Exception and Conditions for the queries
• Worked on Currency Conversion at transformation level as well as at reporting level
• Used BW statistics and Query monitor tools to improve the performance of queries
• Conducted unit testing and facilitated integration and user acceptance testing of the newly developed reports
• Created and maintained functional and technical design documents adhering to quality processes

Role: SAP Solution Manger Consultant

Responsibilities:

• Analysis of administration information assigned to project team members
• Analysis of assignments like Documents, Transactions etc., in the Project Structure that had been added during the project
• Configuration Settings for Document Management
• Mapping of Technical Objects to the Process Structure in Solution Manager
• End User Training for Solution Manager usage

Confidential

Role: Trainee

Responsibilities:

• Requirement analysis, proposal preparation and responses to RFPs and RFIs
• Analysed RFP requirements against proposed outlines to ensure compliance and responsiveness to the customer's issues and needs
• Co-ordinated with team members and conducted meetings with SMEs to gather inputs based on the requirements
• Prepared sales and Business Plans in close association with Project managers so as to develop the business operations
• Reviewed proposal sections including estimation and pricing to ensure requirements are adequately addressed
• Marketing collateral development including whitepapers, brochures, one pager service offerings and business presentations, customizing solutions to client specific requirements
• Conducted final reviews and internal evaluation of proposals
• Prepared several walkthroughs and case studies for client presentations