SUMMARY

• Having 10+ years of experience in IT industry, with 8+ years of in SAP BODS, Business Objects HANA and BW and 2 years in Microsoft .NET and Software Testing
• Experience in Implementation, Support, Maintenance & Development
• Involved in Analysis, Design, Development, Testing, Implementation and Support phases of the Projects for both SAP BW,BO,HANA, BODS and Microsoft .NET
• Extensively worked on BW Composite Provider, ADSO, Info Cubes, DSO Objects, Info Objects, Info Sources, Data Sources, Transformations, DTP’s, Multiproviders, Transfer rules and Update rules
• Good Knowledge in Generic extraction and LO Extraction
• Extensively worked on Web Analyzer and BEx Query Development for Reports creation.
• Experience in CO - PA extraction process and have reports built on it
• Proficient in handling errors error’s occurred during Profitability Analysis (CO-PA) data loads
• Familiar loading data to CO-PA data targets COPAo01B and COPA T02A
• Involved in Business Objects Administration creating users and groups, scheduling reports, publishing reports, planning security, authentication and single sign-on in for the reports developed using Business Objects 4.2/4.0.
• Used Open Hub Services to push data out of SAP BI using BODS
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality in BODS.
• Used Data Integrator and Platform Transforms extensively in BODS
• Worked extensively with Sales & Distribution team to design data migration from Legacy system to SAP using BODS
• Knowledge in OBIEE 11 reporting concepts
• Implementation, Upgrade and administration experience in Business Objects suite
• Tableau desktop and server experience
• Exporting and Importing meta data in Native HANA and expertise in managing Native Hana modeling concepts
• Good experience on PL/ SQL(DDL,DML,DCL, Stored procedures) using Native HANA as a Database
• Good experience with all the Data Provisioning techniques (SDI,SLT, DXC, and SAP BODS), Modeling constructs (Attribute, Analytic, and Calculation) and Reporting solutions (BOBJ Suite of tools) with SAP Native HANA information models as a source.
• Built Analysis Office reports (AO) on Hana information models
• Experience in handling the Business Objects modules Designer, Web Intelligence, Central Management Console and InfoView, Crystal Reports, Lumira and Design Studio
• Experience in Data Visualization tools LUMIRA,TABLEAU
• Good knowledge in Universe designing, developing and generating complex, Adhoc Reports, Business views, List of values, reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks. SME in Dashboards, Best Practices in Dashboard Design, KPI Formulation & Web Reporting, developing information spaces and exploration sets in BOBJ
• Exposure in Oil & Gas, Pharmaceutical, Retail, Telecommunication, Production and Sales Data Warehouses.
• Good analytical, problem solving, communication skills.
• Proficient in Data Analysis in BI
• Followed Agile development technique while building solution
• Involved in Business continuity planning activities during unplanned shutdown
• Good knowledge in Eclipse based BW/4HANA & S/4 HANA

TECHNICAL SKILLS

ERP Packages: SAP BW 7.0, 7.3, 7.4, ECC 6.0

Business Intelligence Tools: SAP Business Objects (WebI, Crystal reports 2013),AO,OBIEE

Data Visualization: BO Lumira 1.31,2.0 Design Studio 1.6, Tableau 10,10.3

ETL Tools: BODS 4.1, 4.2, Business Objects Data Integrator

Data Replication Technique: SLT, DXC

Databases: SAPHANA SPS 11, HANA 2.0, Oracle 10g, SQL Server 2008/2012

Microsoft Technologies: .NET 2005, C#

Programming Languages: ABAP/4-BW

PROFESSIONAL EXPERIENCE

Confidential

SAP Adminiastrator

Environment: SAP HANA 1.0, BODS 4.2, BI 4.2, Tableau, BW 7.4

Responsibilities:

• Handling priority/problem tickets/incidents/ housekeeping activities
• Monitoring and Scheduling process chains.
• Handling RFC’s through Service now tool
• Created Native HANA information models Attribute, Analytical and Calculation Views
• HANA Application Lifecycle Manager (LCM) to transport Native HANA Models
• Worked on Explain Plan Tables, Visual Plan, Sql Tracing as part of Performance tuning in Native Hana
• Configured and Replicated the data from SAP / Non-SAP sources to SAP HANA using SAP Landscape Transformation (SLT),extracted external system data using SDI/SDA
• Built graphical Calculation views using Table functions as datasource for complex calculation in Native HANA
• Worked on performance optimization of SQL Query/Models using Explain Plan, Visualization Plan and Expensive Statements trace
• Good experience in working on HANA optimized Calculation Engine functions(CE functions datasource access & relational operators)
• Built Calculation views on virtual tables with Smart Data Access(SDA) mechanism in HANA
• Converted Attribute and Analytic view to Calculation views to reduce data transfer between engines in HANA
• Created Sql script based calculation views
• Configured and Replicated the data from SAP / Non-SAP sources to SAP HANA using SAP Landscape Transformation (SLT)
• Analyzed and fixed real time replication server SLT delta failures in HANA
• Followed Best practices/Performance tuning in designing and building HANA information models
• Transport HANA model objects using HANA ALCM Source to Confidential systems
• Functional verification activities of Development, Quality and Integration systems
• Enhancing reports in LUMIRA and Webi, working on Lumira 2.0 proof of concept source as HANA
• Worked on linking Datasets and Building and Publishing Lumira Stories to BI Platform
• Created reports including formatting options such as Chart, Grouping, Sorting, Alerter, Ranking, Breaks, Sections, parameterized prompts.
• Involved in Unit and Integration Testing on reports and then exported them to Schedule Manager for Scheduling and Refreshing.
• Modified existing BO universes and WEBI reports as per Business requirements.
• Created Crystal reports when needed and exported to enterprise repository in order to make Crystal reports accessible.
• Support Business objects WEBI reports, Universe handling issues through incidents
• Production support - ensure all BO reports have run and delivered to clients on time
• Worked on Data integration transforms History preserving, Table comparision, XML pipeline
• Setting up of Data store connection to read source data from multiple source systems in BODS
• Extensively used BODS Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Created BODS Jobs, Work Flows, Data Flows, and Scripts using various Transforms(Integrator, Quality and Platform) to successfully load data from multiple sources into a desired Confidential
• Extracted larger volumes of data(SDI) using ABAP data flow transform into HANA DB in BODS
• Retrieved data using SQL Select statements as part of performance tuning in Data services 4.2
• Worked on scripts while reading files from a folder using WHILE Loop in Data services
• Extensively worked on data validation and reconciliation BW, ECC, BO, HANA, DATASERVICES

Confidential

Environment: SAP BODS, BO 4.0, Tableau, HANA SPS 11, IP, BPC 10.0, BW 7.0

Responsibilities:

• Involved in Confidential BO BW transition from IBM to CapGemini
• Handling priority/problem tickets/incidents/ housekeeping activities
• Monitoring and Scheduling process chains.
• Handling RFC’s through Service now tool
• SAP process area’s involved SD,CRM,HR, Treasury & Payments, Accounting & Controlling, Plant O&M
• Classic and Sql script Analytic privileges and assign users to restrict accessing data native hana
• Business Objects reports on HANA modeling constructs(analytic, Attribute & Calculation views)
• Created Data Visualization dashboards using embedded Excel sheet integrated with BEX Queries.
• Worked on complex reports that require running totals, sub-totals, sub-reports, cross-tab and conditional display of groups, fields, and messages.
• Created, managed & formatted standard reports, master/detail reports and cross tab reports using Report Manager.
• Developed crystal reports and performed unit testing
• Migration of BO reports, folders and universes from one repository to other repository
• Support Business objects WEBI reports, Universe handling issues through incidents
• Developed and executed unit test and integration test plan for BO reports
• Created various dashboard reports.
• Making use of SQL transform to read data from source system i.e Oracle
• Setting up of Projects, Jobs, workflow, dataflow and make them uniquely grouped while moving across different environment in BODS
• Extensive use of Data integrator and platform transforms such as Key generation, Table comparision, Case, Merge, Validation, sql, Query for transformation
• Migrate data for SAP FICO and HCM module objects such as Vendors, Customer, Materials, Purchase orders, Cost Centers, Profit Centers, Transactional data such as AP, AR, GL to single system ECC 6.0 in BODS
• Worked on Data Services Management console to create users and grant privilege to access repositories
• Created local and Central repositories to manage data consistency in BODS
• Extensively worked on PL/SQL script in creating native hana calculation views

Confidential

Environment: SAP BODS, BI7.3, Sql server

Responsibilities:

• Involved in designing technical specification document for PES BW
• Involved in build phase of the project
• Developed BI data flows using FLAT file extraction
• Responsible for creation of test scripts and documentation
• Involved in Data Loading & Process chain Monitoring
• Involved in unit testing, test case reviews and documentation
• Created Crystal reports when needed and exported to enterprise repository in order to make Crystal reports accessible
• Design and Develop BODS batch jobs for Material Master, Purchase orders, Asset Master and Batch Determination
• Use of Try-catch and while- loop transforms during splitting records in multiple files in BODS
• Use BODS conditional clauses such as where, group by, order by while restricting records
• Generating Tab delimited output file as per load program
• Publishing Data Quality report for quickly status meeting and decision making
• As per data quality report assist business users to modify and correct the data
• Following are Objects worked as part of data reconciliation activity: PO vendor master, Asset PO,WBS master, asset location, cost center in BODS

Confidential

Environment: SAP BI7.3,BOXI R3,Sql server

Responsibilities:

• Involved in requirements gathering, designing technical specification document for Project Systems
• Involved in BUILD and UAT phase of Project Systems Module(Master Data and Transaction Data)
• Responsible for creation test scripts and documentation
• Involved in planning and co-ordination of tasks
• Involved in Report testing, test case reviews and documentation
• Involved in unit testing, test case reviews and documentation
• Migration of existing in SSIS to Crystal reports from scratch
• Migrated the reports using LCM and import wizard
• Developed and executed unit test and integration test plan for BO reports
• Creation and maintenance of BO Universe and reports
• Worked on CMC module in creating user groups and folders and managing security in BO