SAP BW/HANA Consultant Resume Example

• Built solution strategy for multiple business intelligence projects - Finance (RTR), Master Data, Purchasing (PTP), and Sales (OTC).
• Worked with global business and IT stakeholders to analyze reporting needs and initiated appropriate application development.
• Prepared and presented solution proposals to the leadership.
• Provided project management oversight, best-practice guidance for architecture design and development.
• Monitored requirement management, change management, Issue and risk management.
• Led integrated BI solution project teams of developers and analysts.
• Collaborated closely with developers to verify understanding of design requirements
• Reviewed development work to ensure adherence with standards and mandatory test units
• Worked on publishing BEx Reports to Cognos portal.
• Streamlined design and development of new and existing reporting solutions to fulfill client's business requirements.
• Guided release strategy of global SAP reporting solution in multiple release cycles.
• Demonstrated leadership and adaptability when facing unique challenges from each project release.

Technical Environment: SAP ECC (PP/MM/SD/AP/AR/SRM/QM/SCM) , SAP BI 7, BEx Designer 7.0, BEx Analyzer, , ABAP, IBM Cognos, QlikView, TIBCO, HP QC, SAP SOLMAN, MS Office 2007, MS Project 2010.

• Worked closely with Business owners, stakeholders to create user requirement specification, functional and technical design documents.
• Lead the work on design and development of Nalco Global Dashboard solution.
• Designed, developed and enhanced BW architecture to meet global data warehousing and reporting solution.
• Extensively worked on ABAP enhancements in BW for transformations, functional modules start routines, APD's, Expert routine, BEx variables, and Extractor programs.
• Managed the Integration effort of SAP BW with SAP and Non-SAP sources for consolidation and harmonization of global data for reporting.
• Extensively worked on BI 7.0 Data Warehousing Workbench: designing functional/physical data model, backend configuration, testing, cutover/go-live planning, and production support.
• Migrated BW 3.5 DataSources; retrieved data from Service API (SAPI), generated, generic, and custom ABAP DataSources.
• Performed load performance analysis/optimization of data warehouse through BI Statistics, Clustering/ Reclustering, Partitioning/Repartitioning & Remodeling functions of InfoProviders through redesigning.
• Performed query performance analysis and optimization/tuning through data model, query definition, Aggregates, BI Accelerator , OLAP Cache, Database Statistics, Virtual Characteristics & Key figures, time-dependent master data, non-complex authorization & delta caching.
• Lead - Designing, developing and supporting frontend enterprise reporting, Dashboards/Management Cockpits, queries, query views/elements, Report/Report Interface, Currency Translation, Unit of Measure (UOM) conversion through Business Explorer (BEx) Query Designer, BEx Analyzer and Workbook design, BEx Web, formatted reports, Web Application Designer, Report Designer, Visual Composer, and Information Broadcasting.
• Worked on broadcasting SAP BEx queries into Microstrategy and integrated BEx queries to Enterprise Portal.

Technical Environment: SAP ECC (FI, COPA, Supply Chain- SD, MM), SAP BI 7, SAP Enterprise Portal 7.0, BEx Designer 7.0, BEx Analyzer, BPC, CRM, SQL Server, ABAP, MS Office 2007, Microstrategy, MS Project.

• Worked with CIO, Business and Solution architects to gather and analyze requirement.
• Guided PMO on overall coordination and supervision of the design resource and activities.
• Presented various security design alternatives to the stakeholders and built a prototype.
• Determined and developed design activities for the SAP BI security solution.
• Owned and managed Functional design and Technical design of the solution.
• Completed documentation and Executions Logs in compliance with the CIO Delivery Model.

Technical Environment: SAP BI 7, BEx Designer 7.0, BEx Analyzer, SAP ECC (Finance, Project Systems), Integrated Planning, ABAP, MS Office 2007, MS Visio 2007.

• Worked closely with business owners to gather requirements and prepare User requirement specification, Functional specifications, Design specifications and Configuration control documents.
• Worked on SAP Business Intelligence (BI) Data Modeling- Design of Info objects, ODS, Info Cubes, Queries, Info sets, Multi-providers, APD's and Update and transfer rules.
• Performed Extraction, Transformation, loading and consolidation of CRM data to BI to support analytical reporting.
• Enhanced Business content data sources and also created custom transaction and master data sources to fulfill SAP CRM – BI Reporting.
• Developed ABAP Routines to enhance BI objects.
• Created Queries, Workbooks, and Dashboards using BEx Designer, Analyzer and VB scripting for reporting purposes.
• Wrote complex queries/formulas and create Calculated Key figures, Restricted Key figures, Custom Reporting Formula/Text Variables in BW Query Designer to generate required Reports.
• Extensively worked on integrating VBA macro programming with BEx analyzer to create extremely complex analytical reports in Excel.
• Involved in integrating BEx queries to enterprise portal.
• performed unit test and defect resolution for defects arising during testing phase.
• Worked on Go-Live preparation and post Go-Live support of reporting solution.

Technical Environment: SAP BI 7, BEx Designer 7.0, BEx Analyzer, SAP ECC 6.0 Supply Chain (SD, MM), CRM 6.0, ABAP, SAP Enterprise portal 7.0, BOBJ 3x , MS Excel 2003, MS Visual Basic 6.5.

• Developed and managed a complete solution to segregate Nortel historical data for Nortel and all divestiture companies.
• Worked closely with the business owners/users to create user requirements, functional specifications, design specification.
• Provided guidance on project plan, development notes, resource and time estimation.
• Managed a team of two developers to realize the development effort.
• Created BW security/authorization detailed design for divestiture companies.
• Developed Open Hubs, DTPs, transformations, update rules and modified DSO's, Infocubes, Multiproviders and queries to meet new divestiture requirements.
• Performed ABAP enhancement for BI objects.
• Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases.
• Involved in BO and SAP BI integration - designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.
• Created completed test scripts, data reload plan, go live documentation.
• Performed defect resolution in Unit Test (UT), System Test (ST), Integration testing and User Acceptance Test (UAT).
• Performed post-go live support, knowledge transfer.
• Technical Environment: SAP ECC 6.0 (Supply Chain- SD, MM), ABAP, SAP BI 7, BEx, BOXI 3.0 /XIR2, Web Intelligence XI 3.0, BO Integration XI 3.0.

• Facilitated requirement gathering sessions by interviewing business owners / users and prepared User requirement
• specification, Functional specifications as part of the Business Analytics Team.
• Created training, data modeling and technical documentation for the business users.
• Involved in UAT and System Testing prior to go-live.
• Provided production support functionality for financial planning / reporting users after the implementation.
• Trained users in using BI reporting tool for maximum efficiency.
• Developed BI Supply chain reports and Financial reports for COPA & Integrated planning data.
• Created Queries, Workbooks, and Dashboards using BEx Designer and Analyzer for reporting purposes.
• Wrote complex queries/formulas and created Calculated Key figures, Restricted Key figures in BW Query Designer to generate required Reports.
• Developed, updated and maintained SAP BI reports and end-user training manuals specific to the financial planning
• department of PepsiCo.
• Created universes, classes and objects by retrieving the data from SAP data sources and involved in defining the necessary connections.
• Used Business Objects Developer Suite (Publisher View, CMC, Designer, and InfoView) to perform various tasks specific to every component.
• Created Design specifications and Configuration control documents based on User specifications.

Technical Environment: SAP ECC 6.0, SAP FICO, SAP BI 7, BEx, BI IP, BOXI 3.0.

• Worked closely with business owners to gather requirements and prepare User requirement specification, Functional specifications.
• Created Design specifications and Configuration control documents based on User specifications.
• Closely worked on Application team to realize BI reporting requirements.
• Installed and activated Business content for SCM (Sales/MM/Purchasing) and Service Management (Technical services), QM.
• Configured APO Demand planning BW to enable historical sales data analysis.
• Worked on BW Data Modeling- Design of Info objects, ODS, Info Cubes, Queries, Info set, Multi-providers and custom Update and transfer rules.
• Created flat file data sources, Performed extracting, Transforming & loading of flat files to BI.
• Enhanced Business content data sources and also created custom data source, performed CMOD enhancement to fulfill user requirements.
• Developed ABAP Routines to enhance BI objects, enhanced business content and created custom data sources.
• Created Queries, Workbooks, and Dashboards using BEx Designer and Analyzer for reporting purposes.
• Wrote complex queries/formulas and created Calculated Key figures, Restricted Key figures, Custom Reporting Formula/Text Variables in BW Query Designer to generate required Reports.
• Involved in creating Security/Authorization for BI reporting.
• Worked with test group and business users to perform unit, Integration, user acceptance testing.
• Involved Support Activities for Daily Load monitoring, daily process flow consistency, recover failed data loads.
• Involved in training end-users and BI support team.

Technical Environment: SAP NetWeaver 2004s, ECC 6.0, SCM, APO, QM, PM, CRM-SM, SAP BI 7.0, BEx 7.1, Oracle 10.2.0.2.0, and Windows NT 5.2.

• Worked with business owners to gather requirements and converted them into comprehensive & scalable Technical
• Design Worked with the Project Manager to break down design specification into specific tasks.
• Worked on BW Data Modeling- Design of Info objects, ODS, Info Cubes, Queries.
• Performed extracting, Transforming & loading flat files in BW ODS
• Created BW – external Database connectivity to extract data into BW.
• Worked with Oracle, SQL Server DB and wrote some complex queries.
• Wrote complex queries/formulas and created Calculated Key figures, Restricted Key figures in BW Query Designer.
• Worked with test group and business users to perform unit testing, user acceptance
• Involved in post go-live support of reporting solution.

Technical Environment: SAP BW 3.5, SAP R/3, BEx 3.5, SQL, TOAD 7.5, WebMethods 6.5, HP UNIX, Hyperion, Oracle 9i, and Windows NT.

• Primarily responsible for creating a Reporting solution using SAP BW.
• Interacted with Business Owners/Users to gather requirement specification.
• Created complete data model specifications, SAP BI sizing documentation.
• Involved in creation of Architecture Design Document (ADD) and System Design Documents (SDD), Technical
• Design Document (TDD), Business Process Procedures (BPP), Business Design Documents (BDD).
• Installed and activated standard SRM business content objects for reporting in SAP BI.
• Customized the standard extractor's , performed CMOD enhancements, created custom InfoCubes, ODS's, Multiproviders, update rules, transfer rules and other relevant objects in-order to meet the end user reporting requirements for SRM and MDM data.
• Wrote ABAP Routines to enhance BI objects to achieve desired results.
• Used Flat file mode to extract data from SAP MDM.
• Extensively used Bex analyzer and designer. Created queries, variables, RRI, Restricted Key Figures, Calculated Key Figures, Conditions, Variables, Structures and exceptions
• Worked with formatted reporting using Visual Composer
• Defined base configuration settings for Development, QA and Production environment BI Servers.
• Involved in BW-Administration work for scheduling background jobs, creating BW Security, user profiles, roles, authorizations, Monitoring and extensive performance tuning work on databases.
• Created Reporting Authorization Objects and assigned these objects to roles for securing the data to the InfoObject Level.
• Developed and designed formatted, company-wide reporting (Enterprise Reporting) using the BEx Report Designer and Business Objects.
• Generation of printable formats for Web templates using WAD, queries, query views, and reports, which can then be sent to printers via portals and spools.
• Involved in integrating the BI content to portals and developing pre-calculated workbooks and distributed them across the company profile using portals
• Performed defect resolution in Unit Test (UT), System Test (ST), Integration Test and User Acceptance Test (UAT).
• Built the Master and transactional process chains, Metachains to schedule daily data loads.

Technical Environment: BI 7.0, SAP R/3 4.7, BEx, SAP NetWeaver, ECC 6.0, SRM 5 (EBP), SAP EP 7.0, SAP PI (XI) 7.0, SAP MDM 1.0, Oracle 10g, Sun Solaris 10, Business Objects, Crystal Reports.

• Worked on implementing OTC Reports.
• Provided maintenance support on RTR, PTP reporting solution.