SUMMARY

• SAP HANA, SAP BW 7.3 and SAP BI 4.0 Certified Consultant wif around 10 Years of experience in SAP BI/BW/BOBJ and SAP HANA.
• Experience working on 3 End - to-End Full Life cycle implementations wif strong understanding of Business Requirements, Business process flow, System process modeling, System analysis using ASAP methodologies.
• Experience as SAP BW/BO/HANA Architect/Techno-functional Lead Consultant in Migrating, Configuration, Data Modeling, Extraction, Performance Tuning and reporting of data in SAP BW and Business Objects.
• Having good Functional and Technical knowledge in Order Management, BI Content Extractions LO SCM,PLM,SRM(SD, MM, PP, QM, PM, PS,EHS), HR, CRM, SAP-FI/CO (General Ledger, AR, AP, Special Ledgers, CCA, PCA and Product Costing) and CO-PA.
• BW Areas of expertise Modeling: Experience inSAPBWData modeling of Info Cube, Multi Provider, Composite Provider, Open ODS Views, Info Objects, Semantically Partitioned Objects (SPO’s), Data source, Start Routines, End Routines, Transformation & DTP, Process Chains, Open Hub Interfaces and APD’s.
• Extraction (ETL): Expertise in LO Cockpit Extraction, Generic Extraction, Flat file data Extraction for Master and Transactional data, Activating Data sources, Transporting Data sources, setting up of V3 updates, deleting setup tables and filling up of Cluster tables, Customizing and Enhancement of Extract structures.
• BI Reporting: Expertise in BEx Designer, BEx Analyzer, Web Application Designer, Conditional reporting, Exception highlighting, restricted key figures, calculated key figures, Variables, Filters, Free Characteristics, Structures and RRI (Report to Report Interface).Experience working wif Cross-Functional Analytics and Operational reports from SRM, MM and AP subject areas.
• BW-ABAP: Expertise in writing Start/End/Expert routines, Function Module based Extraction and creation and enhancing Customer Exit Variables, BADI Enhancements.
• Performance Tuning: Performed Data load and query performance optimization evaluating statistics data by suggesting required Cache Parameter settings, compression, aggregates and partitioning where required.. Experience on (BWA-Accelerator) Indexes generation and setting up ADK & NLS Data Archiving Jobs and (RSDBBUFF,BWCCMS, ST02) Buffer Monitoring and Tuning.
• Authorizations: Proficient inBWsecurity and authorizations and created reporting roles and maintained security at Info-Object levels for users wif good understanding on Analysis Authorizations.
• Integrated Planning (BW-IP): Expertise in creating teh planning applications using BI Integrated Planning, creating teh Planning models, Aggregation levels, Variables, Data Slices, Characteristic Relationships, Planning functions & Planning Sequences, Input enabled Queries and FOX Code Implementation.
• Upgrade and Migration: Experience in multiple Upgrade projects from 7.x to later Versions. Recently Upgrade experience from BW 7.3 SP09 to 7.4 SP10 project and previous BW Migrations from 3.x to 7.x Migration.
• SAP Business Objects: Experience in various versions-BO4.x, BOXI 3.x and allBOcomponents- Information DesignTool (IDT), Web Intelligence (WEBI), Universe Designer, BI Launch Pad (InfoView), Xcelsius (QaaWS, BICS, Live Office), Desktop Intelligence, Promotion Manager (Import Wizard), Publishing Wizard.
• Extensively worked on Designing, Developing Business Objects Universes wif various functionalities like Aggregate navigation, row level and table level Securities, cascading LOV's.
• Experience in creating Web Intelligence (WebI) reports for Adhoc reporting and publishing them to Business Objects Enterprise, migrating/upgrading teh reports fromBOXI 3.1 toBO4.x.
• Hands on experience in advancedSAP BO4.x tools like Analysis for OLAP, Analysis for Office,Design Studio,SAPBOexplorer,SAPMobile, Dashboard Designer, Crystal Reports for Enterprise 4.0 on top ofSAPBI 7.0/7.3 using BEx queries, BICS connections.
• Experience in creating complex WebI reports wif multiple queries, custom SQL, using complex functions, merging dimensions at report level, drill down, drill up, drill across and complex filters
• Expertise in creating Xcelsius Dynamic Dashboards usingSAPBI data/ BEx Queries.
• Proficient on using Dashboard Designer Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.
• Expertise wif DesignStudio Componentslike charts, crosstabs, pop-ups, filter panel, tabstrip, and dropdown box to create visually appealing reports. Sound knowledge ondesignstudioscripting language which is used to create advanced interactive applications.
• Expertise in designing Complex Crystal Reports including Cross-tab, Conditional, Drill-down/summary, Top/Bottom N, multiple Sub reports, Conditional formatting, Summaries and Complex formulae.
• Experience in CMC Administration activities like creating and managing repositories, monitoring/granting, permissions and rights to users, user groups through Central Management Server.
• SAP HANA: Good understanding of various components of SAP HANA and In-memory database concepts like Column store, row store, attribute vector, delta merge functionalities.
• Experience in creation of Schemas, table definitions, Attributes, Measures & Hierarchies inSAP HANA.
• Good Understanding on Data Modeling, Data Provisioning, Data Optimization and Authorization aspects of SAP HANA 1.0.
• Experience onSAPHANAData Modeling using Attribute Views, Analytic Views and Calculation Views (both Graphical & SQL script based) &SAPHANAData Provisioning usingSAP LT Replication Server (SLT).
• Strong Knowledge on using SQL CE Functions in SAP HANA for pushing data intensive logic to teh database.
• Good Understandingof SAPHANAsecurity including User Management, Roles and Analytic Privileges.
• Knowledge in identifying, testing and documenting of SAP application controls in compliance wif Sarbanes Oxley Act (SOX) and FDA compliance regulations.
• Experience in ASAP, AGILE and SDLC delivery project Methodologies for Implementation.
• Technical and functional expertise well augmented by excellent analytical and interpersonal skills, wif teh ability to interpret business requirements and transform into technical deliverables.

TECHNICAL SKILLS

• SAP BW - 7.4 7.3 7.0 3.5 (SAP Certified).
• SAP BI 4.0 (SAP Certified).
• SAP HANA - 1.0. (SAP Certified).
• SAP ABAP
• Buffer Monitoring Tool (BMT)
• BWA
• NLS
• BEx Query Designer
• BEx Analyzer
• Web Application Designer.
• BW integration wif Logistics SD FI AR AP QM PP MM
• CRM
• HR
• APO.
• SAP BW- Integrated Planning.
• Design studio
• SAP Lumira
• Vistex.
• Business Objects 4.0 (Information Design Tool
• Universe Designer
• Webi
• AOLAP & Dash boards).
• SAP BPC.
• BODS
• Tableau and HADOOP.
• Other Tools: HP Quality Center 10.1
• HP Service Manage 9
• Control M.

PROFESSIONAL EXPERIENCE

Confidential - Houston,TX

Sr.SAP BW/HANA Consultant

Environment: SAP BW 7.4/7.3/7.0, BW 3.5, SAP BI 4.0, BO DS, SAP HANA 1.0, SYBASE IQ, SAP Enterprise Portal, ECC 6.0, BW-Integrated Planning, SAP BPC, SAP ABAP, BEx Analyzer, WAD, WEBI, HP Quality Center 10.1, HP Service Manager 9, Control M, Rev track, SOX Compliance, Crystal Reports, Xcelsius, Designstudio, Live Office.

Responsibilities:

• Interacting wif business Decision-makers to identify business requirements and Document reporting needs of teh Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Was responsible forBWtechnical architecture, design and report delivery, requirements analysis, analysis of complex reporting requirements, data modeling/design, Business Objects installation and development,SAPBWsecurity design and dashboard design.
• Gather requirements from end users and managers on reporting and dashboard needs.
• Responsible for designing teh templates for capturing teh Functional and Technical Specifications.
• Worked on enhancing teh existing EDW architecture (BWSP: Business warehouse scalability & performance) for teh global GSAP systems comprising of 24+ countries.
• Was Responsible for Project WAHED delivery for Shell Crystal-MI BW system.
• Worked independently coordinating wif Functional Consultants and Business users for End-to-End delivery of Project Wahed, right from Requirement gathering, Gap analysis, Functional specifications design, Technical specification design, Realization, Testing and go-live.
• Design and Development of reports, modeling BW data objects (Info cubes, DSO, Composite providers, Info-objects) & creating teh ETL flow from GSAP R/3.
• Played a Key role in US Fuels pre and post Go-Live activities and post production support for Shell systems.
• Enhancing teh standard extractor, creating generic extractor based on views & function modules.
• Worked on Upgrade Project for GSAP (Global SAP) for SPS Upgrade for Shell from 7.3 SP 09 to 7.4 SP 10.
• Periodic maintenance of production landscape, data archival, BIA indexing, Compression, rebuild aggregates, automation of critical activities of Production Support team like ramp up and ramp down of jobs during any system downtime, Set up alert mechanism for any job failures, delays in data refresh SLAs.
• Analyzing and resolving delta extraction issues, in case of any corrupted delta, plan for data correction in case of any issues by reloading millions of records wif minimal impact to business process and reporting.
• Preparing test scripts and cut over activity check list for system upgrades, coordinating and planning for Source System upgrades wif different teams, Hot Pack Upgrades (as perSAP recommendations) forBIsystem, Delta queue clearing before upgrade, prepare Transport list and schedule for fixing post upgrade issues, post-upgrade ramp up of system, sanity checks and validations, co-ordinate and move fixes for upgrade related issues.
• Analyzed reporting requirements and recommend right reporting tools in Business objects for operational, analytical and strategic reports.
• Analyzed currentSAPandSAPBWlandscape to determine existing BEX queries and cubes that can be utilized in teh Business Objects space
• Enhancements and bug fixes involving routine logic updates, BEX report changes, changes in ETL logic Onsite-Offshore coordination and knowledge transition.
• Create advanced complex reports in BI 4.0/4.1 Universes and dashboards by applying strong technical knowledge of features and functions of Business intelligence tools.
• Worked on US Fuels specific WEBI Universes/reports, A-OLAP reports involving development of BICS connections to SAP BW on Oracle, wif a legacy system on SQL server and MS access.
• Extensively used Information Design Tool (IDT) for universe design and maintaining universes.
• Collect user requirements and design universes accordingly.Develop complex queries using filters, navigational attributes in IDT to facilitate data analysis in a drill down or summarized way to give detailed levels of information in WEBI, Crystal Report, Dashboard (Xcelcius) and Explorer.
• Used various components ofDesignStudiolike charts, crosstabs, pop-ups, filter panel, tabstrip, and dropdown box to create visually appealing reports.
• Worked on creating webi reports wif Variables, Prompts, Breaks, sections, and Custom SQL functions as per Report specifications.
• Defined and prepared data delivery designs and provide development support to leverage technology investments to support business needs
• Analyzing data and reporting requirements to recommend and design solutions through teh creation of appropriate database structures, reports and query structures.
• Design Universe for Ad-hoc and enterprise reporting using Information Design Tool and implement Data Layer and Business layer as per teh business requirements.
• Provide estimates for Report and Universe development.
• Primary responsibilities included report conversion from BRIO to BO, validating functionality, and addressing issues in report formatting and field population.
• Understand and identify teh correct resources to halp define and validate both requirements and specifications.
• Collaborate wif teh business to gather and define teh business requirements, business definitions, process flows, dashboard design, and report design to create business intelligence solutions
• Effectively collaborated wif project managers, business analysts, quality assurance, and other team members.

Confidential

Sr.SAP BW/BI/BO Consultant

Environment: SAP BW 7.0/7.3,BW 3.5, SAP HANA, ECC 6.0, ABAP, SAP CRM 7.0, SAP BW-Integrated Planning, BEx Analyzer, BEx Browser, WAD, SAP BI 4.0,Web Intelligence, Xcelsius Dashboards, SAP Enterprise Portal, HPQC, HP Service Manager 7.

Responsibilities:

• Performed LO extraction to pull data from R3 intoBWsystem extracting Header and Line item data from teh Sales and Distribution (SD) module (Sales Order 2LIS 11 VAHDR/VAITM, Shipping/Delivery 2LIS 12 VCHDR/VCITM and Billing 2LIS 13 VDHDR/VDITM).
• Experience organizing process chains wif transaction RSPC and analyzed process chain load for optimal performance issues and updates for necessary automation process requirement.
• Created Generic Data source in BW using function module to flatten Customer Hierarchy and add them as navigational attributes to Customer Info-object and generate export data source for external systems.
• Worked on Currency Conversions wif customer exit variables on Time Period based Exchange rate Type Calculation in teh reports.
• Extensively used ABAP Routines in Transformations to load and update data into Data Targets.
• Reconciliation of BI reports wif teh ECC & legacy data as wells as teh reports.
• Worked on inventory management and was responsible for inventory management data loads.
• Worked on CRM Extraction and Data source enhancements and Data Flow changes.
• Experience implementing break/fixes, report enhancements, debugging, troubleshooting and performance tuning (load failures/deadlocks) on various complex issues
• Worked closely wif teh supply chain business users in understanding teh requirements for new BI reports and changes involved as part of production support of existing BI reports.
• Used Variables of type characteristic variables, text variables and formula variables wif processing types as User Entry/ Default Value, Replacement path and Customer Exit.
• Checking teh daily time schedule for teh run & ensuring that teh jobs are finished wifin teh specified time frame. Informing teh clients about teh success/ failure of teh loads as soon as teh activity is finished.
• Collecting and Releasing transports (BW and BEx). Worked wif basis team for space related issues, establishing RFC connections to various source systems, applying required notes, moving objects from development box to QA and Production.
• Worked on Planning models, Aggregation levels, Variables, Data Slices, Characteristic Relationships, Planning functions and Planning Sequences and Input enabled Queries using BI-integrated planning.
• Used BICS connection to develop reports based on teh OLAP universe.
• Used Promotion Management to promote teh content wifin teh BO Landscape.
• Created reports using different BO functionalities such as combined queries, drill down, crosstab, master detail and formulae.
• Created Info providers & BEx queries to simulate/validate results achieved from Design Studio reports.
• Architected teh Re-org of BW objects to maintain standards.
• Created BOBJ OpenDoc report linking.
• Created brakes, filters at different levels of teh reports and applied ranking in teh Webi reports.
• Scheduled reports and created alerts as requested by users.
• Created and documented Test Scripts for users to use during UAT.
• Created Webi & Crystal Reports based on teh end user requirements and made changes to existing queries based on ad-hoc changes.
• Interacted wif teh business team/users for any technical issues/fixes in teh production environment.
• Gathered Security requirements for teh reports in different modules such as Finance, Sales, Supply Chain and Service.
• Performed volume user testing to confirm teh production system sizing to accommodate additional users.
• Troubleshoot teh issues related to teh language text display in teh reports - for Latin countries.
• Worked on performance tuning of reports, Security Setup, Assign roles, User folder security and other administration tasks.

Confidential

SAP BW/BO Consultant

Environment: SAP BW 7.0, BW 3.5, CRM 7.0, ECC 6.0,BEx Analyzer, WAD, BOXI R3.1, Xcelsius 2008, ABAP4.

Responsibilities:

• Analyze and configure BW/BI 7.0 data environment to facilitate custom reporting and data analytics solutions.
• Interact wif Business users to gather requirements, prioritize work, develop enhancements to teh existing system, coordinate testing, and perform change management/training for BW Reporting and applications.
• Develop and drive teh implementation of BW best practices and standards for teh team.
• Worked in teh realization of complete reporting solution in Procure to Pay (P2P) area.
• Teh Reporting included Cross-Functional Analytics and Operational reports from SRM, MM and AP subject areas.
• Worked on CRM Datasources like 0CRM SRV PROCESS H, 0CRM SRV PROCESS me, 0CRM OPPT H, 0CRM OPPT me and wif ECC data sources like 0FI AP 4, 2LIS 02 HDR, 2LIS 02 ITM, 2LIS 13 VDITM and its corresponding DSOs and Cubes.
• Created Generic Extraction from user defined tables and created transformations using ABAP routines.
• Perform routine program modifications, performance tuning, problem solving, debugging, and unit testing.
• Analyzed collective performances of various queries to improve performance.
• Used LO cockpit for ECC data extractions wif Queued Delta mechanism.
• Enhanced and used standard SAP extractors to pull P2P data in BI.
• Worked on OPEX Trend analysis reporting and CAPEX reporting
• Created process chains using various processes to automate data loading, activation of DSO, compression, drop and create indexes, Archiving, roll up, attribute change run and DB statistics etc.
• Extensively used Reporting functionalities like RRI’s, Cell definitions and Customer exit variables.
• Maintained Documentation (Functional Specs, Technical Specs, Test scripts) at different stages of teh project.
• Extensively worked inSAPLive Office to create connections b/w WEB me and Xcelsius Dashboards.
• Extensively worked onSAPQAAWS used in mapping data directly from Universe to Xcelsius Dashboards.
• Created Xcelsius Dynamic Dashboards overSAPBI data.

Confidential

SAP BW/BI Associate Consultant

Environment: SAP BI 7.0 (2004S), ECC 6.0, SAP CRM, BEx Analyzer, WAD, ABAP4.

Responsibilities:

• Extensively worked in teh backend development, deployment and support of multiple SAP BW projects like: CRM BW Reporting, HR Reporting.
• Work involved daily BI process chain monitoring and break fix, resolving BI incidents, model defects and application infrastructure requests.
• Worked in resolution of a myriad of BI issues like TRFC errors, delta breakages, failure in IDOCS, failures due to short dumps, delayed data loads, invalid PSA entries and troubleshooting missing documents in BI etc.
• Worked on standard SAP content for BW statistics analysis and Build Statistics queries that halp in teh query and workbook runtime statistical analysis.
• Worked extensively on G/L reconciliation in addressing teh issue of G/L totals not getting summed up to zero for certain periods and profit centers.
• Experienced in raising effective OSS messages for issues that needed SAP halp.
• Extensively worked in account based COPA reconciliation and worked wif SAP in tackling teh problem of missing COPA documents in BI.
• Run Extractor checker RSA3 for Data validation from ECC Tables and reconciliation wif PSA Data in BW System.
• Extensively worked in G/L line items and G/L totals month end reconciliation to inform teh business that all FI data is reconciling before they start month end reporting.
• Build efficient aggregates on info cubes to improve teh BI query runtimes as part of BI performance optimization.
• Checking teh system performance and database size through DB02 and cleansing teh PSA Data Accordingly by creating automated Process chains for PSA and Change log deletion Housekeeping activities based on retention periods.
• Built BEx queries wif Restricted Key Figures, Calculated Key Figures, Structures, Cell-definitions and Customer Exit Variables.

Confidential

SAP BW/BI Associate Consultant.

Environment: SAP BI 7.0 (2004S),ECC 6.0, Business Explorer (BEx), BEx Analyzer, WAD, ABAP4.

Responsibilities:

• Implemented BI for application areas Materials Management (MM), Sales & Distribution (SD), Project Systems (PS), Plant Maintenance (PM) and Finance (FI).
• Worked closely wif business users in understanding teh requirements for new BI reports.
• Involved in Standard Business content objects activation and creation of several Custom Info-objects, Info-cubes, DSO’s, Multi-providers, Info-sets, Datasources, Open Hub Destination.
• Data source activation in RSA5, Enhancing additional fields to Data sources and populating teh same by business logic using ABAP Code.
• Involved in LO Extraction, Generic Extraction using Function Module, FI and COPA Data Extraction wif necessary field enhancements as per teh business requirements.
• Used both initializations wif delta update and Full update methods depending on teh business requirement. Setting up teh V3 Jobs and Delta queues.
• Creating Process chains as local chains and including them to teh meta-chain and maintain proper scheduling sequence based on data loading dependencies.
• Extensively worked on setting up authorization objects, roles, transporting them, and involved in testing reports based on various roles.
• Created several Calculated Key figures, Restricted Key Figures, structures, variables to enhance teh reporting features.
• Implemented conditions and restrictions in teh reports based on teh requirements. Used Hierarchies in teh reporting to provide drill down features.
• Designed and developed reports wif filters and free characteristics. Designed and provided RRI reporting.
• Involved in transporting teh BW objects from development system to QA for unit testing and integration testing.
• Transport teh objects from Development to Quality till Production wifout any major issues.
• Managed and monitored several data loads, captured teh errors and corrected teh bugs and applied several OSS notes for teh errors encountered while loading teh data.