SUMMARY:

• 8+ years of total SAP IT experience in requirement gathering, technical analysis, Estimation, design, development & implementation of business applications for Manufacturing, Transportation, Banking, Insurance, Oil & Gas, Utilities.
• Strong experience in SAP BI/BW Net weaver 7.4/7.3 concepts & implementation.
• Strong experience in developing data models in HANA, SAP ABAP ECC 6.0, Business Objects 4.0/XI 3.1/XIR2/6.x/5.x.,BEX query, Business Objects data services XI/3.2/4.0.
• Actively involved in End to End Implementations, up gradation, Support & Configuration, and Rollout of SAP MM, FI & SD projects.
• Worked on creating complex workspace and analysis of data using Tableau & WEB Intelligence.
• Expertise in building the Reporting Applications from scratch with OLAP/OLTP environments.
• Worked on Solution Validation specifications & Release Management, Hyper - care and Support.
• Involved in successful migration of SAP BW & ECC objects to SAP HANA.
• Good experience in SDLC, Agile & SCRUM methodologies &Life Cycle.
• Expert in Process & Data modelling and implementing them under both traditional BW as well as SAP HANA environment. Also experienced in data management and master data management related technologies
• Worked on Interfaces, Enhancement, and Reports, Data dictionary Objects, debugged Standard programs based on business requirement and worked on performance improvement.
• Involved in writing complex routine using ABAP programming, Function Modules & IDOCS.
• Worked on Interfaces, Enhancement, and Reports, ABAP Data dictionary Objects, debugged Standard programs based on business requirement and worked on performance improvement.
• Experience in modelling and activating standard business content, extending and enhancing using user exits according to the user requirements. Creating Info Objects, Info object Catalog, Composite providers Info cubes, DSO objects, Info Sets, Multi-Providers, Application Component, Info Sources, Data Sources, Update Rules, Transfer Rules, Communication Structure, Transfer Structure, Info Packages, Info Package Groups, Process Chains, PSA, Transformations, Data Transfer Process (DTP)
• Used Business Content extensively, loaded statistical data using (BC) Technical Content. Extracted data from ECC, classification system, through Web service and Flat File. LO Cockpit Extraction, Generic Extraction, Flat file Extraction for Master data and Transactional data, and Activating Data structure, transports data sources, customizing and Enhancement of Extract structures and extractors
• Creation of Batch process and scheduling load jobs in parallel, Process Chain Maintenance
• Expertise in Reporting with BOBJ WEB Intelligence, Business Explorer using BEX Analyser, BEX Query Designer, Tableau, Web Application Designer, Condition Reporting, Exception highlighting, developed Queries, queries using Variables, Structures, conditions, exceptions Filters, Free Characteristics, Calculated Key figures, and Restricted Key figures and RRI (Report to Report Interface)
• Performed data modelling and developed Analytical views, Attribute views and the calculation views in HANA Studio.
• Involved in data replication from SAP ECC to SAP HANA via SAP Landscape Transformation (SLT)
• Involved in requirement gathering, creating functional specifications and technical specifications and providing it to the team for the objects to be developed. Involved in Setting up essential configurations for SAP ECC accelerations using SAP HANA like Information Modeller
• Designed the Information Models for HANA & HANA Models to provide analytics solutions on Business KPIs
• Provided the solution for Data Security & Access model.
• Identified attribute & measures, Hierarchies
• Experienced in Configuring Data Services for Data & Metadata Import & also Configuring the Information Modeller.
• Assisted BI Team to define HANA Modelling standards and best practices, release management process, validation & testing process etc.

• Worked on writing complex ABAP routine for retrieving data, data load issues & bad data, Exits, function modules etc.
• Worked extensively on SAP scripts & smart forms
• Worked on Report (Interactive and classical)
• Implemented ALV reports
• Worked on Performance improvement of the objects (improved performance of the programs by40%).
• Worked on issues related to BAPI & BADI, IDOC’s, and LSMW.

PROFESSIONAL EXPERIENCE:

Confidential

SAP Consultant

Responsibilities:

• Worked on extraction, transformation & Loading (ETL) process, data quality management, process flows.
• Worked on reporting requirements into technical design and development.
• Created Info providers & BEX broadcasting queries to simulate/validate results achieved from reports.
• Extensively worked on designing/creating Info Objects, Info Sources, Transfer structures, and communication structures, Standard and Custom Info Cubes, Data Store Object (DSO).
• Worked on creating Info Objects, Info object Catalog, Composite providers Info cubes, DSO objects, Info Sets, Multi-Providers, Application Component, Info Sources, Data Sources, RRIs Update Rules, Transfer Rules, Communication Structure, Transfer Structure, Info Packages, Info Package Groups, Process Chains, PSA, Transformations, Data Transfer Process (DTP). Monitoring APD Deployment & process chains on daily basis and resolving the errors and issues in process chains on priority basis.
• Involved in the production support, Scheduling Start Process and Process Chains of Events, Data source Enhancement, Info Cubes, Data Mart and Open Hub Services, fixing errors and daily ETL Data load (Full/Delta up-load).
• Monitoring of the BW jobs and designed Process chains for Daily, Weekly, Bi-Monthly and Monthly data loads.
• Expertise in BW Performance Tuning: Performed tuning measures of Queries by maintaining Aggregates, Roll up, Compression, partition, Process chains, indexing of info cubes and use of statistics for the same. Also, used variety of techniques to boost the performance of BEX Query.
• Worked on custom, standard and generic extractions.
• Having precise expertise in understanding the R/3 and ECC 6.0 System and considerable experience in SAP BW/BI, documenting, design and Analysis of reports Using BEX Analyser.
• Performed LO Cockpit extraction, Knowledgeable in LIS, Generic and CO-PA extraction.
• Expertise in Report Generation. Worked extensively on BEX Analyzer in building Queries using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and created aggregates for frequently used queries.
• Knowledge On WEB Reporting, Reporting Agent, Open Hub Concept.
• Experience in Data loading, Monitoring and Scheduling using Process Chain.
• Extensively worked on Enhancements for populating the records to the newly added components in the Data sources.
• Worked on Data Source Enhancement according to customer requirement.
• Wrote ABAP routine to retrieve data according to the requirement in the transformations, worked on exits, function modules to get the required output.
• Worked on debugging complex codes to find out issues with code and performance issues
• Wrote complex ABAP codes under routines for production issues like lower case issue, garbage data issue, data mismatch etc., Worked on debugging & writing exits.
• Extensively worked on LO Extraction Cockpit to extract Logistics data from Source System( R/3)
• Worked with transactional Data Info sources to load data from SAP R/3 and Flat Files into SAP BW.
• Involved in activating Business content for Standard info Cubes, Info Source& Info Objects of sales and Distribution as per the Client Requirements.
• Created and Maintained Data Sources, Transfer Structures, Communication Structures, Transfer Rules and Update Rules for Info source, DSO objects and Info Cubes.
• Created Info Packages and Info Package Groups and scheduled them in order to Load Master Data and Transactional data from SAP R/3 as well as Flat File Source Systems into BW.
• Created Transfer rules, update rules using ABAP routines and Formula builder while creating Cubes and ODS.
• Worked with SAP BW & HANA Administration, Performance Optimization, Modelling using Different types of views, SQL, SQL, Script topics in HANA Studio.
• Worked on LSA++ architecture with BW 7.4 on HANA and HANA Studio using ADSO, Open ODS Views, Transient, Virtual, and Composite Providers
• Created Design Documents for the HANA Models, both Functional & Technical specifications to build up the objects and to provide the team to work on
• Worked with PSA in Monitoring the Data Transfer from Source System into BW.
• Involved in Performance Issues like Creation of aggregates, RollUp and Compressed the InfoCube to improve the query response.
• Involved in solving the tickets regarding extractions, Performance Issues and also load failures.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Maintaining Work History for all the tickets until it is closed down.
• Developed Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Accessed and transformed massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Worked on development of WEBI BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions.
• Implemented Open Doc to drill down to detail WEBI report from Xcelsius Dashboard.
• Designed, developed Universes and WEBI Reports.
• To inform the onsite people if there any deadlocks.
• Resolved Customer reported tickets through email and phone.
• Worked on Global BW solution from multiple SAP R/3 system with varying designs into a common BW reporting template
• Provided trainings & knowledge transfer regarding daily production activities to the members.
• Created Dynamic Dashboards using SAP BI data/ BEX Queries. Worked on Dashboard Designer Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.
• Wrote complex ABAP codes for data retrieval in BW transformations, debugged the code for finding out the issues.
• Modified BW queries in to generate WEBI reports using BI Launch Pad in BO
• Developed WEBI reports on SAP BEX Queries using BICS in WEBI Rich client.
• Created monthly and summary reports in WEBI 4.0 for the different domains like Finance, Marketing and HR domains.
• Worked on writing test scripts & unit testing for objects which are developed.
• Created Marketing and Finance Dashboards for FP&A, Inventory Management and Cost Centre Accounting data.

Confidential

SAP BW Consultant

Responsibilities:

• Created Info providers & BEX queries to simulate/validate results achieved from reports. Architected the Re-org of BW objects to maintain standards.
• Worked on Creating Info Objects, Info object Catalog, Composite providers Info cubes, DSO objects, Info Sets, Multi-Providers, Application Component, Info Sources, Data Sources, RRIs Update Rules, Transfer Rules, Communication Structure, Transfer Structure, Info Packages, Info Package Groups, Process Chains, PSA, Transformations, Data Transfer Process (DTP).
• Involved in extracting the data from External Source system SAP & Non SAP system.
• Installing and creating BI objects like info objects, DSOs, Info cubes
• Wrote complex ABAP routine to retrieve data according to the requirement in the transformations, worked on exits, function modules to get the required output.
• Worked on debugging complex codes to find out issues with code and performance issues
• Wrote complex ABAP codes under routines for production issues like lower case issue, garbage data issue, data mismatch etc., Worked on debugging & writing exits.
• Worked on data replication from SAP ECC to SAP HANA via SAP Landscape Transformation (SLT) .
• Created RFC Connection which is used in SLT Configuration.
• Developing SAP HANA data modelling using Attribute View, Analytic View, and Calculation View
• Consuming SAP HANA views on IDT to deliver business layer using web intelligence and have proven experience with reporting specially handling complex scenario's using joins and SQL.
• Worked Extensively on Data Warehouse Workbench and customized info objects, info cubes, DSOs, Data Sources, DTPs, Transformations and multi-providers.
• Worked on creating connection between BODS to BW data load.
• Created data flows, work flows, transformation between the view and BW data source correctly
• Created the jobs and used the job names to get the data extracted from BODS source.
• Involved in Support and Monitoring activities after go-live.
• Experienced in Universes - Built complex Universes geared towards all-encompassing Self-service environments, paying close attention to detail, and adhering to functional requirements. (required)
• Experienced in designing complex canned reports, multiple tabs, multiple queries on a single screen, list and cross-tab reports, charts (line, bar, stacked bar, pie, tabular, cross-tab), hyper linking.
• Involved in enhancements of Data Services Jobs, HANA Models and applying Patches on HANA.
• Involved in business and Architecture discussions.
• Developed Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Accessed and transformed massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
• Collected business requirements and define functional & technical specifications
• Handled a team of 5 and guiding the junior resources to complete the assignments
• Created procedures in HANA Database.
• You use Customer Vendor Integration (CVI) to synchronize between ECC.
• Got deep knowledge of SAP HANA Architecture and managed ETL process for data warehouse
• Implemented SAP HANA Cloud Platform/Portal application solution and HANA cloud solutions for the project.
• Performed data modelling and developed Analytical views, Attribute views and the calculation views.
• Performed hybrid data modelling with SAP HANA Live & SAP BW data integration. Worked on complex hybrid modelling scenarios.
• Wrote complex SQL scripts, stored procedure & functions for the execution of complex calculations inside the HANA database.
• Used SQL scripts as per performance improvement norms making sure each and every query execute efficiently.
• Worked on writing test scripts & unit testing for objects which are developed.
• Experienced in modelling and activating standard business content, extending and enhancing using user exits according to the user requirements
• Worked closely with SAP Technical team on implementing the First Customer's project on HANA.

Confidential

SAP BW Consultant

Responsibilities:

• Worked on architecting reporting requirements into technical design and development. Created Info providers & BEX queries to simulate/validate results achieved from reports. Architected the Re-org of BW objects to maintain standards.
• Created ODS, Infocubes, Multi-providers and infosets and extracted SD data (Data sources Like 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 VASCL) of SAP R3 into SAP BW using LO Cockpit(LBWE) extraction. Extensively worked for Sales Order Review
• Setup and monitored collective run jobs in LO Cockpit
• Monitored loads for SD,MM,FI module from R/3 source system
• Corrected delta load failure for SD, MM, and FI module.
• Scheduled DTP for loading Transactional Data from PSA to Info Provider using process chains
• Extensively used Structures, cell definition, calculated key figures, restricted key figures, new selection, new formula, exceptions and conditions.
• Worked on debugging complex codes to find out issues with code and performance issues
• Wrote complex ABAP codes under routines for production issues like lower case issue, garbage data issue, data mismatch etc., expertise in code debugging, setting break points.
• Wrote routines for production issues like lower case issue, garbage data issue, data mismatch etc.
• Experienced in Universes - Built complex Universes geared towards all-encompassing Self-service environments, paying close attention to detail, and adhering to functional requirements. (required)
• Experienced in designing complex canned reports, multiple tabs, multiple queries on a single screen, list and cross-tab reports, charts (line, bar, stacked bar, pie, tabular, cross-tab), hyperlinking, drill-down and drill-through (required) Integration experience - Experience with connector configuration towards HANA DB (both enterprise and BW), using HANA business layer, utilizing Universe and BICS Connections and Composite model using BW cubes.
• Wrote complex ABAP routine to retrieve data according to the requirement in the transformations. Worked on exits, function modules to get the required output.
• Worked on creating connection between BODS to BW data load.
• Created data flows, work flows, transformation between the view and BW data source correctly
• Created the jobs and used the job names to get the data extracted from BODS source.
• Wrote routines for production issues like lower case issue, garbage data issue, data mismatch etc.
• Worked on BO Administration like scheduling, security, separating power users vs. end users, managing folders and reports, enabling / restricting specific BO Application capabilities based on user group Create Technical specification documents for indicated Business Objects indicated artefacts.
• Worked on troubleshooting design and performance issues.
• Used SQL scripts as per performance improvement norms making sure each and every query execute efficiently.
• Involved in frequent client meetings to discuss project status.

Confidential

SAP BW Consultant

Responsibilities:

• Developed complex WEBI Core measures vehicle report which is used by the organization to track various core measures of the hospitals by month, quarter, and year against the benchmarks.
• Extensively worked on design & development of Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from ECC to BI system
• Creating and managing dataflow using DTP, transformations and info packages and writing Complex ABAP codes on specific routines as per requirements
• Data Source Enhancement according to customer requirement
• Designed and developed queries to generate reports in BEX Analyzer
• Worked extensively on query designer
• Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BI
• Prepared Technical Specification documents for the given Functional designs
• Developed the objects as per the functional requirements and coding standards of the Client
• Performed Unit Testing on the objects.
• Worked on LSA++ architecture with BW 7.4.Involved in requirement gathering, creating functional specifications and technical specifications and providing it to the team for the objects to be developed. Involved in Setting up essential configurations for SAP ECC accelerations using SAP HANA like Information Modeller.
• Wrote complex SQL scripts, stored procedure & functions for the execution of complex calculations inside the HANA database.
• Used SQL scripts as per performance improvement norms making sure each and every query execute efficiently.
• Involved in frequent client meetings to discuss project status.

Confidential

SAP BW Consultant

Responsibilities:

• Custom Data source/Info-cubes/Info-objects for accommodating the global data available across the organization. Used LO Cockpit, Generic, Flat File and DB extractions to retrieve SAP and Non-SAP data for reporting in SD, MM, PP modules and company's legacy systems
• Extensively worked on Enhancements for populating the records to the newly added components in the Data sources
• Prepared the Strategy, Scope and Analysed the Business process to be modelled.
• Creating and managing dataflow using DTP, transformations and info packages and writing Complex ABAP codes on specific routines as per requirements
• Data Source Enhancement according to customer requirement
• Designed and developed queries to generate reports in BEX Analyzer
• Worked extensively on query designer
• Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BI
• Prepared Technical Specification documents for the given Functional designs
• Developed the objects as per the functional requirements and coding standards of the Client
• Designed and developed the data ware house using SAP BO
• Integrated BW with other open systems for events and membership management
• Worked on the data analysis team to aggregate data for predictive analysis for better membership drive.
• Prepared the Strategy, Scope and Analysed the Business process to be modelled.
• Creating and managing dataflow using DTP, transformations and info packages and writing Complex ABAP codes on specific routines as per requirements
• Data Source Enhancement according to customer requirement.
• Monitored loads for SD module from R/3 source system
• Corrected delta load failure for SD module
• Schedules DTP for loading Transactional Data from PSA to Info Provider using process chains
• Extensively used Structures, cell definition, calculated key figures, restricted key figures, new selection, new formula, exceptions and conditions
• Involved in frequent client meetings to discuss project status.