SUMMARY:

• Having 14 Years of professional experience engaging with the business stake holders to understanding business needs and provide solutions out of 9 years of SAP Business Warehouse experience encompassing a wide range of skill set, roles and industry verticals.
• Worked on SAP HANA implementation projects with both Native HANA and SAP BW on HANA Landscapes based on HANA ASAP 8 Methodology.
• Worked on Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA 1.0
• Experience working on HANA Enterprise Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges.
• Excellent knowledge on: HANA Optimized InfoCubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA .
• Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and InfoCubes.
• Experience in Importing BW models Info Cube, DSO in HANA as Analytical view.
• Good understanding and experience in providing security restrictions on models using Analytic Privileges and assigning to Authorization roles for different types of users in SAP HANA.
• Experience in Data-Provisioning techniques suing SLT SAP Landscape Transformation to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.
• Experience in Configuring and Consuming SAP HANA models in BI clients such as Lumira, Predictive Analysis BusinessObjects Explorer MS Excel.

BW Expertise:

• Implemented 5 end to end full-life cycles using ASAP methodology across various modules in SAP BI/BW projects.
• Worked on Management Work Bench with creating and maintaining Data targets like Info Objects, DSO, Info cubes and Virtual Provides like Info sets, Hybrid Providers and Multi Providers.
• Strong experience in BW 3.x and BI 7.x version and upgrade technical and functional .
• Strong experiences in installing the Standard Business Content objects and enhance them into custom objects based on the business requirements.
• Worked on BW support project activities data loading monitoring and troubleshooting the failures .
• Experience in system maintenance tasks Delta queue cleaning, Setup table deletion validation
• BW load/job automation through process chain and Control-M.
• Worked extensively in SD, MM, PP, and FI Modules.
• Strong in performance tuning Data loading and BEX reports and job failure reduction activities.

BO Expertise:

• Working knowledge and proficiency with Business Objects Reporting tools BI launch Pad, Web Intelligence, Dashboard designer, Dashboard Design, BO Explorer, Crystal reports.
• Working knowledge on creating universes using IDT on SAP HANA views and reports development on the same using Web Intelligence.
• Excellent understanding work Experience of building Complex Universe s of Normalized De-Normalized schemas using Information Design Tool IDT .

PROFESSIONAL EXPERIENCE

Confidential

Title: SAP BOBJ/BW HANA Consultant

Accomplishments:

• HANA and Business Objects Development done across all the business Areas for the BI Projects: Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.
• Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
• Developed data flows and work flow using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.
• Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication.
• Using data provisioning methods like SAP SLT for real time data and Business Object Data Services BODS non sap data Flat file upload and direct extraction connection DXC to acquire the data into SAP HANA Data Mart.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool .
• Develop SQL scripts and functions for complex reusable scenarios in HANA.
• Consumption of HANA information Models in BW by creating Composite and Transient Providers.
• Developed multi-data source challenging reports by merging data from multiple Data Sources using Web Intelligence WEBI .
• Designed Web Reports Using Be Queries BICS Connection .
• Designed developed cross tab reports, reports with sub reports linked unlinked and charts using Crystal Reports.
• Had created reports using SAP BO Analysis Office 1.3 and 1.4 for multidimensional ad-hoc analysis of Headcount Analytics data from SAP BW and HANA in Excel.
• Reports Developed in this Project: Headcount Change in Staffing Level, Human Capital Management Monitor, Leaving Rate, Percentage Distribution of Leavers, Vendor spend analysis
• Worked with LCM Life Cycle Management Console to Transport the Objects In System Landscape Dev, QA and Prod
• Involved in developing and conducting extensive Unit testing, Integration testing FIT , Regression testing, User Acceptance Testing UAT and documentation.

Confidential

SAP BI/BW HANA Consultant

Accomplishments:

• Involved in Collaborating with Client managers, DBA's, Reporting team, Business users and other Stake holders to understand SAP HANA, the existing landscape and identify key business use cases for the Poof of Concept POC .
• Interacted with Business stake holders in order to understand their structured and ad-hoc reporting requirements, User stories, business rules for finance, sales and marketing domains.
• Worked on conducting workshops to go over the new tasks with the system administrators and SAP Basis Consultants and also created an application by application migration approach from SAP BW to HANA system.
• Using Import selective Meta data for SAP BODS 4.1 imported Meta data in the ETL Process prior to on boarding data into sap HANA, created schemas and data provisioned using SAP LT Replication Server SLT .
• Developed Business Object Data Services BODS4.1 jobs to pull external data from Flat files and Oracle into HANA database.
• Developed jobs to complete remediation of legacy data, data quality management, data profiling using both built in and custom functions.
• Worked with various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table Comparison in Platform and DI Transforms and extracted data according to the business rules and Technical Specifications.
• Created master data objects as Attribute views, joined multiple master data tables depending on the requirement, selected key figures and attributes to give context to the master data.
• Involved in creation of Analytical views to support multi-dimensional reporting by joining Fact table data foundation to modeled dimensions attribute views , selected attributes and measures.
• Created Calculation views using data base tables, attribute views and analytic views, in order to address complex business requirements created SQL Script based Calculation views.
• Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE STUDIO
• Used Information Design Tool IDT to create connections to SAP HANA databases, Create data foundations and also created Business layer and publish these connections and layers to Repository.
• Created Dashboard for Supply chain and Inventory executive dashboards using Design Studio.
• Extensive working experience with different components of Designer Studio like Charts, Selectors, Text, Maps and Containers.
• Created reports by connecting to IMCE from SAP Lumira, SAP Business Objects Explorer BEx and MS Excel through ODBO/MDX for multi-dimensional reporting.
• Accessed HANA data as Pivot tables in Microsoft Excel through via MDX provider.
• Enabled Business Objects Explorer to search data present in HANA.
• Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through BOBJ Crystal Reports, BOBJ Dashboard Design, BOBJ Web Intelligence Webi , BO Analysis.

Confidential

SAP BW/BOBJ Architect

Accomplishments:

• Listen to the business stake holders to understand business needs, analyzes complex business requirements, reporting requirements and propose the best solution for them, and convert them into write the functional specification.
• Worked alongside the database administrator and SAP BW consultant to identify the technical names and sources for the KPIs key performance indicators defined by the final user.
• Implemented data security access with Universe level security and report level security also system security access with integrating the Active directory according to design specification.
• Designed a Semantic layer based requirements from business a total of 3 Single source Universes and 2 Multi source enable DB2 AND SQL Server universe using Information Designer IDT for the HCM and FI business.
• Architected and developed 3 financial dashboards Variance Price Exchange, Daily Sales, Profit Loss using Dashboard Designer and connected source data from SAP BW BEx queries using BICS.
• Provided Solutions and Developed 2 HCM Dashboards using Dashboard Designer allowing the leadership teams to analyze headcount, compensation and performance trends and metrics for all levels of the organization and source data feed from Universes using QaaWS export dashboard to mobile server as HTML5.
• Involved and analyzed in creation of 8 Web Intelligence Reports with different functionality like cascading prompts, drilldown, Scope of Analysis, charts, ranking, alerts and implemented with row level security.
• Worked on BEx Query Designer in designing queries using Variables, Navigational Attributes and Structures to facilitate flexible, detailed drill down data analysis to required level of information.
• Created 2 Crystal Reports on BEx queries that were built on BEx Query Designer and wrote complex queries including Sub queries for Supply Chain business areas.
• Migrated 8 Universe designed Universes UNV files into Information Design Universes UNX files using upgrade management tool.
• Worked closely with the Database and ETL team to get required table structures.
• Involved in working with different database environments PROD, DEV, and QA and migration of the universes and reports using LifeCycle Manager. Established a change control for each development.
• Conducted Training sections for all BI Business Users and created end-user training documentation.

Confidential

SAP BI Architect-

Accomplishments:

• Interacted with Business stake holders to know their business needs and effectively develop and modify Universes and Reports.
• Defined row level security at universe level as per user entitlements, this enabled IT to create one report and make it available to global users based on their rights.
• Integrated SAP BW with Business Objects and extracted data from SAP Data sources.
• Provide reporting solutions using 2 OLAP Universes using BOE XI 3.1 - Universe Designer on top of SAP BEx queries, enabled OLE DB for OLAP and InfoCubes / MultiProviders, created/modified classes, objects, dimensions, measures and details.
• The development of a total of 6 reports using Web Intelligence, according to functional specification and write the technical specification for each development.
• Provide complex reports solutions in Web Intelligence using advanced functionality like report level prompts, scope of analysis and ranking data source from DB2.
• Architect and developed a Campaign Marketing Dashboard that measures leads and contacts for different marketing channels. Implemented end to end solution, starting from the Universe, to the Web Intelligence dataset layer, to the Xcelsius Dashboard.
• Follow the company procedures to migrate from the development environment to QA quality assurance all the universes and reports until the production server.
• Provide training to the final users about the correct use of the new business Intelligence elements.
• Involved in Realization, Final Preparation, Go-Live and Post Implementation, developed production support plan and resolved production support issues.

Confidential

Sr. SAP BW/BOBJ Developer-

Accomplishments:

• Worked with SAP BI and BOBJ Business users, Project managers and architects in requirement gathering, analysis and creation of best practice architecture.
• Enabled Single Sign-On SSO feature, imported SAP BI roles into BusinessObjects, enabled automatic imports of SAP BI users, managed users and groups in Central Management Console CMC .
• Worked with Business Users on design changes and deployed Business Objects Rapid Marts, sourced data from SAP, Non-SAP and flat-file datasources.
• Created 5 Universes using Universe Designer, worked with tables, fields and joins, involved in resolving loops by creating aliases and contexts using SAP BEx queries.
• Created/Edit queries and reports in BOBJ - InfoView for multidimensional analysis and trained users on drill-down, cross-tab, triggers, master detail, slicing and dicing, ad-hoc reports by Web Intelligence WebI , Voyager workspace, scheduling and publishing to BO Inbox, email, FTP, .. in multiple formats html, pdf, ActiveX doc,..
• Involved in data extraction from SAP R/3 system, Cognos and Non-SAP systems and scheduled Full Loads / Delta Loads using Process Chains.
• Created Dashboards and Scorecards integrating reports using Business Objects dashboard manager.
• Worked with SAP BASIS team in regards to moving Transport Requests and worked with SAP SECURITY team in providing authorizations for Users by assigning specific Roles.
• Worked with SAP Basis and BI teams and involved in upgrading the SAP BI support package to SP21, installed BusinessObjects Enterprise XI 3.1 Integration for SAP Solutions FixPack 1.x.
• Involved in developing and conducting extensive Unit testing, Integration testing FIT , Regression testing, User Acceptance Testing UAT and documentation.
• Worked with Network Administrators and setup .Net framework on VMware with Windows 2003/2008 Server, creation of SQL server 2008 databases, ODBC connections and Java Run-time Environment for BusinessObjects installation.

Confidential

Sr.BW Developer

Accomplishments:

• Responsible for requirement gathering by working with business and technical users, analysts, Project managers, and involved in analysis and creation of architecture that can be considered 'best practice' and scalable.
• Worked closely with Production Planning PP , material management MM , Sales and Distribution SD , Logistics LE , Financials FI AP, AR, GL teams involving SAP and Non-SAP team members in creating Order-To-Cash, Procure-To-Pay, Point of Sale POS data via DataStage and other integrated solutions.
• Designed Data Marts as per the System landscape, created Functional and technical BW specifications, considered proper data modeling techniques and data management strategies and created Technical BW Specifications for BW Objects.
• Involved in loads initialization in SAP BW system followed by extraction LIS/LO Cockpit extraction, FI, CO-PA extraction from SAP R/3 system and Non-SAP systems and scheduling regular Full Loads / Delta Loads using Process Chains.
• Worked with SAP ABAP team and created code that will result in the highest performance possible.
• Provided Knowledge transfer KT and Training to BW team members and Super Users and guidance to team members on Excel-to-SAP project related to Manufacturing during all phases of project.
• Captured the BW data elements required by the end users and extensively involved in analysis, design, development, configuration, testing, deployment of BW Objects Info Objects, ODS, DSO, InfoCubes, InfoSets, MultiProviders, InfoSources, DataSources and corresponding extract, transformation, communication structures.
• Implemented the BI 7.0 concepts of Transformations and DTPs using the existing datasource migration and involved in up gradation and migration from BW 3.5 to BW 7.0
• Created Service Level Objectives SLOs , Solution Documents with the BW team that will guide the production support team when issues occur.

Confidential

Developer-

Accomplishments:

• Involved in Data-modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring and Reporting for the MM, SD, and FI/CO modules.
• Responsible for Design, Development and Extraction from R/3 Source System and Flat File to BW for MM and FI/CO modules and working with Data Flows.
• Handled assignments in the areas of activating cubes 0SD C01, 0SD C02 and a total of 9 Custom Cubes and 6 pre-delivered cubes were developed as part of the Global Deployment.
• Activated ODS 0SD O05, 0SD O06, 0SD O04 and its standard Queries. 0PUR C01 Purchasing Data and 0PUR C02 Vendor Evaluation.
• Extracted data from MM modules and uploaded the data into the Procurement Cubes via 2LIS 02 HDR, 2LIS 02 ITM, and 2LIS 02 SCL.
• Involved in writing Update Routines and transfer routines using ABAP language.
• Used Delta Update mechanisms for uploading the data to BW from R/3 in specific intervals.
• Created query Variants, Free Characteristics and exceptions for the effective query management.
• Extensively used Calculated and Restricted Key Figures, Restricted Characteristics, structures, Variables and conditions for the queries.
• Defined reports as per reporting requirements, the reports include Purchase Order Summary, Purchase Order Details, Sales Order Summary, Sales Order Details, and Invoice Details.