SUMMARY:

• A competent professional with 10 + years of experience of experience in SAP BW/BI and ABAP/4 with various Modules like DFPS, FICO,HR,MM, PP,PS,QM,PM, SD,PM, LO - Cockpit, FI-SL and Generic Extractors with 4 Full life cycles in BW,FICO, HR with the SAP practice of Big 4 consulting company.
• Over 3 years of experience modelling on SAP In-memory technologies of SAP HANA.
• Technical expertise on BW data modelling which includes creation of complete data flow from Data Sources to Info providers, using update rules, transfer rule and transformations, loading data using Info packages and DTPs and automate the data loads using Process Chains, implement routines at different levels.
• Strong experience in Implementations of BW 7.x which includes Data-Modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring, LO-Cockpit, Info-cubes, Multi-Cubes, SPOs, DSO objects, Info Packages, Transformations and DTPs, BEx- Analyzer and BEx Query.
• Experience in creating custom extractors and Generic Extractors and extensively involved in enhancing of the Data Source.
• Designed queries in BEx Query Designer and created workbooks in the BEx Analyzer using conditions, structures, calculated and restricted key figures, character variables, formula variables and text variables.
• Extensive Experience in Native HANA and HANA Studio all aspects Data modeling scenarios Attribute View, Calculation View and Analytical View.
• Deep Understanding & expertise in SAP In-Memory HANA Architecture, Column store, row store tables in SAP HANA studio.
• Extensive Experience in activities of developing schemas, importing table definitions, adding connections.
• Experience with HANA scripts while creating complex SQL views for custom based HANA applications including BO integration with SAP BW Native HANA.
• Developed solutions in HANA with various scenarios including multiple parameters, variables, binding parameters/ variables from top to bottom and vice versa.
• Extensive experience in Production support, Data loads, Validation and troubleshooting of transaction data and Master data, Transport Management, Roles & Security, System Checks, Performance tuning and process chains.
• Expert in BO Design studio, Analysis, Fiori,,Lumira, Desktop Intelligence, Web Intelligence Rich Client, Information Designer Tool/Universal Design Tool, BI Launchpad, Data Services, Dashboard Manager, Crystal Reports, Central Management Console etc.
• Good exposures in BO 4.0 & 4.1 new features like multiple data source connectivity, processing data from structured & unstructured sources, data quality & metadata assessment and transform the data to user's preferred format etc.
• Designed reports with complex sub reports, cross tabs, Drill down, formulas, functions, parameters, multiple grouping, running totals, charts, graphs, mapping, conditional formatting.
• Worked on data dictionary objects like Tables, Structures, Views and Domains.
• Proficient in generation of Classical Reports, Interactive reports, BDC, Smart forms, Adobe forms, ALE/IDocs.
• Performing SAP System Configuration, writing functional requirements for custom development, performing appropriate system tests (Unit Testing, Regression Testing, User Acceptance Testing), writing system/user documentation, and training end users on functionality.

SKILL:

• SAP ECC
• BW3.x
• 7.3
• BW7.4
• 7.5 on HANA
• HANA1.0
• BW/4HANA
• BPC10.0
• SAP S/
• 4 HANA
• Bex Query Designer
• Bex Analyzer
• BOBJ 3.1 / 4.0
• Webi
• Fiori
• Design Studio SDK
• Universe Designer
• Analysis Edition for OLAP
• ABAP
• UML
• IBM Datastage
• Informatica Power center
• SAP CRM
• SAP ISU
• SAP SCM
• SAP SucessFactors
• SaleForce
• HP UFT
• LoadRunner
• TAO
• ALM
• QC
• Microsoft Visio
• Power Designer
• SQL
• Oracle
• SQL server
• DB2
• Apache HADOOP
• Analytics
• Microsoft Word
• Microsoft Excel
• Microsoft PowerPoint
• Test
• UAT
• Incident troubleshooting
• Requirement gathering
• DOORS
• Functional specification
• Technical specification.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

SAP BW/BOBJ HANA Consultant

Responsibilities Included

• Gathered Business Requirements and Conducted Gap Analysis to Implement DFPS and BW building an LSA ++ best practice implementation architecture for Enterprise Data Warehouse.
• Created Technical specifications and standard modeling documents for SAP BW for the complexity of the process design is related to the functionality provided by the DFPS (Defense Forces Public Security) solution.
• Interacted with Business users to understand, analyze and gather business needs and convert them to technical specifications.
• Worked on all areas of SAP BW from extracting data using custom extractors / ECC/ Flat files .
• Created numerous DataSources, DSO's, Cubes, MultiProvider for loading Customer/Vendor Data from ECC.
• Created Custom extractions using T Code RSO2, wrote transformation routines and user exits using ABAP to meet user requirements and to ensure optimized extraction and load performance.
• Created the ETL process for data being extracted from legacy systems into SAP BW
• Encompassing all steps of ETL process, (DataSources, DSO's Cubes, MultiProvider) Loaded Data to PSA using Data Services.
• Automated loading process by creating process chains.
• Created Open Hub for extracting data from DSOs.
• Gathered Business requirements then recommended and designed reports in Bex and BOBJ based on reporting functionality.
• Created End User Reports in BEx and Worked extensively with BEx Query Designer .
• Design of Queries using restricted key figures, calculated key figures, Variables, Filter, Free Characteristics, Exceptions, Conditions and Cell Editor .
• Created BEx reports to be used as source for WEBI BOBJ
• Create user reports in WEBI 4.0 using BICS connection on Bex .
• Re-Developed an existing dashboard completely in Design Studio and made compatible for Mobile.
• Created Unit Test Plans and complete Testing of Developed Objects and Reports.

HANA Implementation:

• Provided go-live and post-live support, Coordinated with the team to resolve post go live integration issues.
• Validated possible reporting solutions, using Various SAP provided Virtual Data Models and HANA Live Content for Operational reporting .
• Prepared Plan for Validation and Transformation & Assist in documenting and managing the BI project plan.
• Worked on importing SAP BW Models in to SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.
• Worked extensively on SLT to replicate the data from BW to native HANA.
• Demonstrated to the end user's utilization of the HANA views in the front end tools such as Tableau and SAP Business objects - Web Intelligence.
• Loaded the Data from Different Files such as Flat Files, Spread Sheets, and XML Files etc. to SAP BW on HANA.
• Worked on designing SAP BW data Flows (DSOs, Transformation, and DTPs) on the BW on HANA database Scenarios and imported them to the HANA studio tool.
• Developed various HANA Models/Views, using non SAP Source system for real time data reporting requirement in Financial Month End Closure reporting
• Design, build and deploy the provisioning of SAP data into SAP HANA platform to support real time report replacing BW extractors.
• Design, build and maintain virtual data model (SAP HANA views) using SAP HANA Studio.
• Developed Virtual Provider with BW objects upon HANA Models to use Navigational attributes and Master data related to BW Objects.
• Responsible for building different Data Models (Attributes, Analytical and Calculation Views) in SAP HANA extracting data from multiple sources.
• Developed Composite Provider to combine both data from BW & HANA and designed BEx queries upon these Composite Provider.
• Transported various HANA views to higher landscapes.
• Worked on Performance Optimizations by using Input Parameters to avoid the performance breakdowns.
• Create Open ODS View using SAP HANA Smart Data Access as Data Source from S/4HANA and Combined other Info providers using Composite Provider

Environment:, SAP ECC, SAP BW 7.4, 7.5 On HANA, SAPS/4 HANA, Fiori, Business Objects 4.2 SP2 Business Explorer (BEx), MS SQL Server, Netezza Enterprise Portal, Web Intelligence, Dashboard Design, BI LaunchPad, BICS, SAP Design Studio.Business Area: DFPS, FICO, SD, HCM, PP, MM, SCM, CRM

SAP BW Consultant

Responsibilities Included.

• Worked with the Subject matter experts in gathering reporting requirements from business partners, developed design specifications, Technical Specifications, Mapping Documents, and Unit test script documents.
• Responsible for gathering business requirements, creating business and technical requirements specification for configuration of MM (Material Master) & FI (Financial) using standard templates.
• Successfully tested SAP MM cycles Procurement (PO creation, Release of POs, Transfer Order processes cycles and Invoice, Credit memo) in addition to some of the SAP SD scripts
• Configured Integration FI - GL with Sales and Distribution module, and related GL account determination through access sequences.
• Designed and developed back end architecture and all BW elements to host the data from multiple ERP implementations.
• Involved in multi-dimensional data modeling, developing InfoObjects, InfoCubes, Aggregates, ODS objects, PSA, DataSource (OLTP Source), InfoSource, Communications Structure, Transfer Structure, MultiProviders, InfoSets, and customizing standard Business Content .
• Extraction (ETL) of master data and transaction data from R/3 MM, FICO and SD Data Sources and data transfer from multiple SAP and non-SAP Source Systems through Direct Update and Flexible Updating.
• Created Unit Test Plans and complete Testing of Developed Objects and Reports.
• Worked on functional upgrade / migration of BW 3.5 data flow to BI 7.0.
• Worked with Quality Assurance business resources to complete System and Integration Testing.
• Performed Cross functional testing on various modules
• Provided go-live and post-live support. Coordinated with the team to resolve post go live integration issues as well as hyper care issues.

Upgrade/HANA Project

• Gathered and analyzed the requirements, preparing technical design documents.
• Involved in creation of calculation views using SQL Scripting, creation of users, roles, creation and assignment of analytic privileges.
• Configured SLT, created new SLT schema, replicated the data from SAP ECC and non-SAP data, modified the SLT transformation filtered, and added new fields with logic before data loading.
• Monitoring and optimization of the replication process in SLT.
• Designed of Queries using restricted key figures, calculated key figures, Variables, Filter, Free Characteristics.
• Worked on BW 7.4 dataflows, developed semantic partitioning objects, migrated data flows using the BW migration tool, and created hybrid providers for real time reporting.
• Worked with the stake holders and functional team to deliver the technical design and documentation.
• Extensive experience in data modeling and developed analytical views for the transactional data, attribute views for the master data, and calculation view in HANA studio.
• Established best recommended strategies for SAP HANA and BOBJ .
• Created universes on HANA views - Hybrid, and analytical and migrated and developed WEBi and Dashboards.
• Designed and developed universes in Information Designer tool from multiple SAP BW datasources.
• Worked on dashboard development using Design Studio with BW OLAP sources as the back-end.
• Created HCM dashboard using Design Studio serving as a hub for all HCM reporting purpose.
• Created universes on HANA views- Hybrid, and analytical and migrated and developed WEBi and Dashboards.
• Created Unit Test Plans and complete Testing of Developed Objects and Reports
• Worked with Quality Assurance business resources to complete System and Integration Testing

Environment: Business Objects 4.1 SP6, SAP BW 7.4, Business Explorer (BEx), MS SQL Server, Netezza Enterprise Portal, Web Intelligence, Dashboard Design, BI LaunchPad, QaaWS, BICS, BIWS, IDT, LCM, Fiddler, Mobile BI, JAVA, Angular JS, Business Area: PP, MM, SCM, CRM

SAP BW Consultant

Responsibilities Included

• Involved in procure-to-pay ( P2P ) processes for Purchase Req, Purchase order, goods receipt and Invoicing.
• Worked on BI 7.0 Data Warehousing Workbench: designing functional/physical data model, backend configuration, testing, and production support of InfoObjects, InfoCubes, Data- Store Objects (DSO), MultiProviders, InfoSets, Virtual Providers, Open Hub Services, and InfoSpokes.
• Created Transformations, DTPs, Info Packages, DSO's for staging and Cleansing purposes and Info Cube for Reporting purposes.
• KPI & Report requirements analysis Developed ODS, Cubes for FI, HR, PR, MM using the extractors and External Systems.
• Configured Reporting Agent, roles, Web reports, exceptions, variables, cells in formula, formatted reporting in Query Designer & executed queries in BEx Analyzer.
• Created Unit Test Plans and complete Testing of Developed Objects and Reports.
• Prepared and Executed Test Scripts for both Unit and Integration Testing.
• Provided Post Go-live production support

Environment: Business Objects 4.1 SP6, SAP BW 7.4, Business Explorer (BEx), MS SQL Server, Netezza Enterprise Portal, Web Intelligence, Dashboard Design, BI LaunchPad, QaaWS, BICS, BIWS, IDT, LCM, Fiddler, Mobile BI, JAVA, Angular JS, PP, MM, SCM, CRM

SAP Consultant

Responsibilities Included.

• Lead a team of technical/functional consultants for implementing the SAP HR, FI, BI solution and migration.
• Coordinated work and personnel at various locations onshore as well as offshore.
• My responsibilities include requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
• BI Design - Info Cubes design, Data Sources, Info Object maintenance, ODS Objects, Info sets, Hierarchies, Multi providers, Transformations, Info Packages using AWB. Proficient in Data modeling using MDM and BW extended star schema models.
• Experience in ETL i.e. Data Extraction, Data Transferring, Data Loading such as SAP BI
• BI Reporting - Implemented the Design and Development of Queries, Reports, Workbooks, Business Explorer Analyzer, Query Builder, Info Set Query, Web Reporting, Reporting Agent and Broadcaster.
• BW operations - Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load) Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.
• Performance tuning of Queries (SAP BW BEX) by maintaining Aggregates, Compression, partition, indexing of info cubes and use of statistics for the same.
• Reporting Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, Conditions, RRI, and Jump queries.
• Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, partitioning.
• Customizations - Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, transformations creation, Business Content Activation
• Participated in identifying and implementing continuous business process improvements in planning, month-end closing, and consolidation.
• Documented functional and technical specifications for production support and project enhancements.
• Assisted in ongoing communication with BW end-users on business process and systems changes, and issues resolutions.
• Analyzed business/system requirements and process flows and creating Functional Specification documents based on discussions with client core team members.

Environment: Business Objects Enterprise XI 3.1, SAP BI 7.0, BW 3.5, ECC 6.0, Business Explorer (BEx), Oracle 10g, SQL Server 2005, Netezza, Crystal Reports, Universe Designer, Web Intelligence, Xcelsius, QaawS, Live Office, Visual Composer, BOBJ Explorer, Data Integrator, Microsoft SharePoint Portal; FI-CO, AP, QM, SD, MM, WM

SAP Consultant

Responsibilities Included.

• Responsible for gathering business requirements, creating business and technical requirements specification for configuration of HR, MM and FI (Financial) using standard templates.
• Primary liaison between the business owners and technical team.
• Re-Configured Company code, Plant, business areas(4), Fiscal Year Variant, Posting period variant, Open posting periods,( Periods are opened for the fiscal year through the posting period variant) Tolerance group for employees, Tolerance group for (vendor / customer).
• Execute Testing on Interfaces: Customer Master, Item Master, Sales Order History
• Performed Cross functional testing on various modules.
• Developed ODS, Cubes, MP for FI, HR, PR, MM using the standard extractors and External Systems
• Collaborated with teams (BW) and ABAP worked along with them to log the defects and notified the bugs to the developer.
• Involved in data Analysis, Cleansing and Upload the HR master data from Legacy systems to SAP system.
• Used ABAP for transforming some of the HR data to support report level calculations
• Development Test scripts in HP Quality Center for Unit, System and Integration Testing.

Environment: SAP BW 7.0, SAP BEx Query Designer, SAP BEx Analyzer, SAP FI, SAP POSDM, SAP ECC 6.0