Professional Summary

Over ** years of IT experience in Analysis, Design and Development of Client – Server and Web based Business Intelligence and Data Warehousing applications.

Extensive experience in all phases of the Software Development Life Cycle (SDLC) such as Requirements Gathering, Analysis, Design, Implementation, Maintenance and also involved in the Production Support.

Analyzes business and technical processes, documents business requirements, defines changes to business processes and assists in modifying them, configures, tests and implements enterprise-wide business systems. Interviews business partners to define detailed business requirements

SAP Business Objects:

Extensive experience in Business Objects BI 4.1/4.0/XIR3.1/XIR2/6.x tools like Information Design Tool/Designer, BI launchpad/Infoview, Web Intelligence, Desktop Intelligence, Dashboard Design, Explorer, Advanced analysis CMC, CCM, Import Wizard, Life Cycle Manager, Report Conversion tool and implementation of Business Applications in SAP BW 3.5/BI 7.0/7.3/7.4 and ECC, CRM, SCM, APO, SD, MM, PA, FI/CO, HR- ABAP 4/5 programming.

Worked with Crystal Reports 2008/2011 for creating complicated reports including parameter based reports, graphical reports, sub-reports, formula based, well-formatted reports, analysis reports, drilling reports, data reports along with LOV.

Extensively worked in Business objects reporting using Xcelsius, Webi and Crystal Reports.

Expertise in designing Universe using Derived Tables, Aggregated Tables using Aggregate Awareness, Index awareness, contexts.

BEx Reporting:

Worked in front-end Business Warehouse components for Queries, Workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, Ad-hoc Queries, BEx Analyzer, Query Designer, Web application designer (WAD), Information Broadcaster. Extensively worked on Complex reports such as Reports on Virtual Key figures, Dashboard/Cockpit reports, RRI etc.

Created OLAP Universes on BEx queries and BI Info Providers.

BW Modeling and Extractions

Extensively worked in modeling and configuring back-end components including infoset query Extractors, Info Objects, Start and end routines, Hierarchies, InfoSources, Update Rules, Transfer Rules, Transformations, InfoCubes, MultiCubes, Multi Providers, Remote Cubes, Transactional Cubes, Data Marts, ODS/DSO, InfoSets, InfoPackages, and Data Transfer Process (DTP) and their types.

Worked on the extraction of data’s from LO cockpit-SAP R/3, FICO and MM to BW

BW ON HANA

Extensively worked on BW on Hana objects such as Composite Provider, ADSO’S and Ods View and optimized existing objects to Hana optimized objects such as DSO’s and Cubes.

Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.

Native HANA

Handled HANA POCs for my existing clients

Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)

Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.

Worked on different provisioning that includes ETL based, SLT based and Flat File techniques.

Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies

Data extractions from SAP and Non SAP sources into HANA using SLT, DXC and BODS

Good experience in creating Executive dashboards for management showing summary metrics for the Key performance Indicators (KPI’s).

Efficient in Optimizing, Debugging and testing SQL queries and stored procedure written in different databases.

Strong Communication, Organizational and Interpersonal Competencies along with Detail-oriented and problem solving skills in the technology arena.

Technical Skills:

Business Intelligence

Business Objects BI 4.0/XI R3.1/R2/R1/6.x, Business Objects Data Services XI 4.0,Xcelsius 4.5/2008, SDK, Crystal Reports 2008/XI/10/9, SAP BEx, Web Application Designer (WAD),Design Studio 4.0, Central Management Console, Central Configuration Manager, Universe Designer, Desktop Intelligence, Web Intelligence, Webi Rich client, Import Wizard, Report Conversion Tool, Translation Manager, Query As A Web Service (QaaWS), Performance Manager, Crystal reports Enterprise, Auditor, Crystal Report Explorer, Dashboard manager, Tomcat

Databases

Oracle 11g/10g/9i/8i, Teradata, IBM DB2 UDB 8.0/7.0, MS SQL Server2005/2000,HANA

Data Warehouses

SAP BI 7.4/7.3/7.0, SAP BW 3.5 / 3.1C / 3.0B

ERP Packages

SAP R/3 4.6, ECC 6.0, SAP Net Weaver 2004s,SAP ABAP 4/5

Utility Tools

Erwin 6.1/4.5/4.1/4.0, Toad 8.5.1

Programming Languages/Web technologies

Visual Basic 6, PL/SQL, HTML, JavaScript, MS Front Page, Tomcat Apache Web Server, IIS 7.0/5.0/4.0, ABAP 4

Environment

Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Novell

NetWare 4.11/3.61, Win 3.x/95/98, Win 2003, Win XP. MS-Dos, Win NT, Red Hat Linux.

Education

Bachelor of Technology in Computer Science Engineering, JNTU, Hyderabad, India

Professional Experience

Zimmer Biomet, Warsaw, IN Apr’15 to Till Date BI HANA Developer

Biomet, Inc. was a medical device manufacturer located in the Warsaw, Indiana business cluster. The company specialized in reconstructive products for surgeries and operating room supplies. In 2015, Biomet became part of the new company Zimmer Biomet.

Involved in Full life cycle of Business Intelligence Application such as Requirements Gathering, Analysis, Development, Testing and Production Support in both BO, BW and HANA.

Active Participation in roadmap development and responsible for project implementation.

Creation of Configuration in SLT (SAP Landscape Transformation) and replicated the data from

source system to SAP HANA system.

Monitoring and optimization of the replication process in SLT.

Creation of Attribute views, Analytic views, Calculation Views based on replication data in

HANA modeler.

Optimization of the modeling using Calculation Engine (CE) operators in SQL Script.

Involved in documentation such as Technical and Functional specification for both BW objects and BO reports.

Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application

Involved in creating BW on Hana objects such as Composite Provider, Advance DSO’S and Open ODS view.

Involved in loading the data from ECC and Flat Files which are coming from 22 ERP’s throughout the world.

Involved in creating data sources, info packages, data transfer process and process chains on BW system for the SD,PTP, AP and AR process areas.

Involved in transformations by writing ABAP code for Start routines, End routines and Field level routines.

Created BEx queries for all the Sales, AP and AR reports and also involved in writing the CMOD code for few variables based on the user requirements.

Involved in coding CMOD for the character restrictions which includes Customer Exits, Single/Multiple values, mandatory/optional variables based on the user requirements.

Involved in creating the Web I reports by using the BICS connection which includes filters, input controls (such as text boxes, List Boxes, Check Box, Double sliders for both single and multi-select), merge dimensions and custom variables.

Creation of Analytic privilege and applied restrictions on the Information views.

Creation of Procedures for complex modeling.

Restricted access to data by assigning relevant Roles to Users based on user profile.

For data analysis, Information spaces created in Explorer based on HANA Information views.

Universe file creation in Information Design Tool (IDT) based on HANA Information views.

Environment: SAP BI 7.x, SAP HANA Studio 2.X, ECC 6.0, BEx 7.x, SD, PTP,FI-AP, FI-AR, Business Object BI 4.X

Dart Container, Mason, MI Sept ’13 to Mar’15

BI Techno Functional Consultant

Dart Container Corporation of Mason, Michigan, United States is the world's largest manufacturer of foam cups and containers, producing about as many as all competitors combined.

Involved in Full life cycle of Business Intelligence Application right from requirements gathering till the deployment of the reporting system on to the production.

Involved in writing the Functional specifications and Technical Specifications for BEx queries,

Business Object reports, Universes, Extractions and loading data.

Worked on the extraction of data’s from LO cockpit-SAP R/3, FICO and MM to BW

Designed and created Multiproviders, Info Cube, DSO, Info set, enhance extractors, transformation, DTP and Info package.

Performed various techniques to improve the performance load by eliminating unnecessary processes, reducing data volume to be processes and Deploying parallelism on all available levels by using Aggregates, Compression, partition, indexing of Info cube.

Understood the uses of SAP RDS premium content for BW on HANA.

Worked closely with the Basis team to guide them in the HANA migration.

Executed Pre-Migration tasks to prepare BW system database export.

Executed Post-Migration tasks after migration to SAP HANA.

Converted standard DSOs and Info Cubes to HANA optimized objects.

Tested the BW data targets and reports before and after migration.

Collected statistics of data loading, data activation and report runtimes for comparison,

Prepared Sales Collaterals, delivery training and required documentation for SAP Qualification.

Creation of Configuration in SLT (SAP Landscape Transformation) and replicated the data from source system to SAP HANA system.

Creation of Attribute views, Analytic views and Calculation Views based on replication data in HANA modeller.

Creation of Analytic privilege and applied restrictions on the Information views.

Restricted access to data by assigning relevant roles to users based on user profile.

Created Information spaces in explorer based on HANA Information views.

Environment: SAP HANA 1.0 SP7,SAP BI 7.3, ECC 6.0, BEx 7.x,SD,PTP,HCM,FI,CO, Business Object BI 4.1, Xcelsius 4.5/2008,Design studio 4.0, Crystal Reports 2011,Designer, Web Intelligence, Launch Pad, CMC

Alexion Pharmaceuticals, Cheshire, CT May’13 to Sept’13

BO/BW Lead Developer

Alexion Pharmaceuticals, Inc. is a global biopharmaceutical company focused on developing and delivering life-transforming therapies for patients with severe and life-threatening rare diseases. They have 2 own products in the market for aHUS and PNH.

Involved in gathering, analyzing, and documenting business requirements, functional requirements, data specifications for Business Objects Universes and Reports and support the Technical Development Specifications for SAP BW database and reporting objects.

Implemented new concepts and technologies that are available in the Data Warehousing Workbench for process design and data modeling

Created Data Transfer Process (DTP) to transfer data within BI from PSA (Persistence staging area)

Performed migration of emulated data source with Export and without Export

Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 7.0 to 7.4

Implemented Start and End routines within Transformations

Designed Complex Queries, Transfer Rules, Update Rules, Extracted Hierarchies and Created Aggregates

Enhanced Info cube with remodeling concept to make changes, without having to reload data

Involved in BI implementation include BI configuration, requirement gathering, configuration, extraction setup, functional and technical design, data modeling, extractor setup and developing BI objects

Designed and created custom Multiprovider, Info Cube, DSO, Info Set, enhance extractors, transformation, DTP and Info package

Worked extensively with SAP Portal team to link reports to Organization’s Information Portal

Analyze SAP Business Content components when delivered, relevant to Client and its subsidiaries projects including initiation of new projects

Document test plans and complete Unit Testing of developed reports

Worked with General Ledger and Accounts Payable data sources for extraction and loading of data from FI to BW

Created different Ad-hoc and Complex Canned Reports using Master/detail, Cross Tab and Charts for graphical representation in the reports

Created Queries, Calculations, Variables, Breaks, Section, Ranking, Filtering, Sorting, and Formatted Presentation Styles (Graphical) and Alerter’s to draw attention to a particular block of data by highlighting it. Most of the reports involved using multiple data providers, Free hand SQL, 3D chart Pie charts, Formula and formatting using slice and dice panel.

Publish, distribute and schedule Web Intelligence reports using Info view.

Responsible for improving the Business Objects query performance by tuning the Queries, Database and server parameters.

Provided end user and production support after deploying the application into the production environment. Also provided extensive support for the users on application usage and trained users in the functionality of the software.

Environment: SAP BI 7.3, ECC 6.0, BEx 7.x,FI,CO,CRM, SAP ABAP 5,Business Object BI 4.1, Xcelsius 4.5/2008,Design studio 4.0, Crystal Reports 2011,Designer, Web Intelligence, Info View, CMC,SQL, PL/SQL, SQL Server 2008, Windows 2007

District of Columbia Access System (DCAS), Washington, DC Aug’12 to April’13

BO/BW Lead Developer

The District of Columbia Access System (DCAS). DCAS will be a state-of-the-art health and human services solution that provides the District’s Health Benefit Exchange a new integrated eligibility system for Medicaid, private health insurance and other programs with new case management capabilities that span programs and agencies.

Involved in Full life cycle of Business Intelligence Application right from requirements gathering till the deployment of the reporting system on to the production.

Review and validate data loaded into the data warehouse for accuracy and at the same time, interacts with user community to produce reporting requirements.

Extensive experience in writing the documentation for Technical Specifications and functional requirements.

Involve in BO universe design and on integration of SAP BW and SAP BO using SAP integration Kit.

Extracted Data from Existing BI Info Providers and ECC Custom Data Sources using Generic extraction and also using Flat files.

Extend the Business Content Data sources using Enhancements and populate the appended fields using User Exits. Create custom Info Source/Data Source, DSO, and Info Cubes for Data extraction, transformation and loading from SAP R/3, FICO system to SAP BW.

Designed and created custom Multiprovider, InfoCube, DSO, Infoset, enhance extractors, transformation, DTP and Info package.

Worked extensively on OLAP and OLTP tools.

Worked extensively on implementation and extracting from CRM to BW and reporting on them.

Used Analysis Process Designer Data from different data sources in the BI system and gathered data from different data sources combined, transformed, and staged for analysis in several individual steps and resaved in data targets in the BI system

Migrated Business Objects XIR3 content (users/user groups, Universes, reports) into Business Objects BI 4.0 environment using the Upgrade Management Tool.

Responsible for Identifying Business Requirements from end-users. Perform GAP analysis against Business Content. Modeling various objects like Info Object, Info Source, Info Cubes and DSO Object.

Implement various Performance Tuning techniques to increase the performance of Queries by Creating Aggregates, Partitioning and Compression of info cubes.

Environment:SAP BI 7.3, ECC 6.0, Bex 3.x, 7.x,FI,CO,CRM, SAP ABAP 5,Business Object BI 4.0/XIR3.1, Business Objects Data Services XI 4.0, Xcelsius 4.5/2008,Design studio 4.0, Crystal Reports 2008,Designer, Web Intelligence, Info View, CMC,SDK, Oracle 11g, SQL, PL/SQL, SQL Server 2008, TOAD, Erwin 6.1, Windows 2007

Bon-Ton, Inc, York, Pennsylvania Sep’12 to Aug’13

BI BW BO Lead Developer

The Bon-Ton Stores, Inc. is a regional department store company based in York, Pennsylvania, chiefly operating 275 stores, including 11 furniture galleries, in 23 states throughout the northern UnitedStates. Other chains operated by The Bon-Ton include Bergner's, Boston Store, Carson Pirie Scott, Elder-Beerman, Herberger’s and Younkers.

Extensive experience in writing the documentation for Technical Specifications and functional requirements.

Interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.

Involved in upgrading the environment from BW 7.0 to 7.3

In BFC Involved in Collect, consolidate and publish account statement data and configure the application for your consolidation needs.

Involved in BFC, dimension Concepts, Collecting Data, Monitoring the Consolidation Process, Initializing Consolidation, Consolidating, Creating Manual Adjustments, Analyzing Data,Initializing a New Data Collection, Configuring the Structure Creating Data Entry Schedules.

In BFC, Configuring the Category Scenario, Configuring Ledgers for Manual Adjustments, Creating Data Analysis Reports, Initializing New Data Collection, Configuring Security

Implemented new concepts and technologies that are available in the Data Warehousing Workbench for process design and data modeling

Worked extensively on OLAP and OLTP tools.

Worked on the extraction of data’s from LO cockpit-SAP R/3, FICO and MM to BW

Created Data Transfer Process (DTP) to transfer data within BI from PSA (Persistence staging area)

Performed migration of emulated data source with Export and without Export

Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.5 to 7.0

Implemented Start and End routines within Transformations

Designed Complex Queries, Transfer Rules, Update Rules, Extracted Hierarchies and Created Aggregates

Enhanced Infocube with remodeling concept to make changes, without having to reload data

Involved in BI implementation include BI configuration, requirement gathering, configuration, extraction setup, functional and technical design, data modeling, extractor setup and developing BI objects

Designed and created custom Multiprovider, InfoCube, DSO, InfoSet, enhance extractors, transformation, DTP and Info package

More experience in working on Logistics module for extracting the data from the source and writing the transformations on it.

Worked extensively in gathering the CCAR requirements and done extractions related to the FI module.

Worked extensively with SAP Portal team to link reports to Organization’s Information Portal

Analyze SAP Business Content components when delivered, relevant to Client and its subsidiaries projects including initiation of new projects

Document test plans and complete Unit Testing of developed reports

Worked with General Ledger and Accounts Payable data sources for extraction and loading of data from FI to BW.

Used SAP ABAP in writing the writing the transfer routines in info objects, expert routines in transformations and in process chains, DTPs and INFO Packages for data selection.

Involved in Sales Re Design, Created new DSO for more granular Data and created new Infocubes for the special purpose of Reporting

Defined and Created Hierarchies as per the business rule for the reports to be viewed at selected reporting level. Checked the Integrity of the Universes and exported the Universes to Repository for making available to users.

Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.

Performed various techniques for performance both in BO and BW.

Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.

Used Input controls, report elements, drill filter, Timedim to accomplish complex requirements.

Involved in designing EXEC_DASH Board universe for all the reporting Needs

Involved in Designing Xcelsius Graphs using QAAWS.

Created parameterized Crystal Reports and customize existing reports for presentations using Cross-Tab reports sub-reports, Running Totals, used Crystal syntax to create formulas for the reports.

DevelopedCrystal Reports and formatted the same with respect to the requirements. Added parameters, special fields, formulae and used multiple data sources to create the reports.

Created Reports using Crystal reports formulas, Grouping, Parameters to handle the end user requests from Tables, Stored Procedures, Views and Command Objects.

Involved in displaying data from legacy systems andrelational databases and also in creating, modifying reports using tables, views, functions and stored procedures.

Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.

Environment: SAP BI 7.3/7.0, ECC 6.0, FI,CO, CRM,SD, MM, Asset Accounting, Logistics, Inventory and COPA,SAP ISU,SAP ABAP 4/5,Business Object BI 4.0/XIR3.1/XIR2, Xcelsius 4.5/2008, Crystal Reports 2008,Designer, Desktop Intelligence, Web Intelligence, Info View, CMC, Oracle 11g, SQL, PL/SQL, SQL Server 2008, TOAD, Erwin 6.1, Windows 2003 and UNIX

Tetra Pak Inc, Vernon Hills, IL Jan’11 to Sep’12

Sr BI BW Developer

Tetra Pak is one of the world's leading suppliers of food processing and packaging systems. Tetra Pak is known for innovations in long-life carton packaging systems including aseptic technology, which keeps even the most sensitive food products safe, naturally fresh and nutritious without the need for refrigeration or preservatives. The aim of this project was to give support to the Business Executive in decision making and identifying key factors like the total sales revenue in week wise, month wise, quarter wise and year wise based on the region and the sales amount.

Interacted with Business Users and End Users to know their Business views in developing and modifying Universes and Reports accordingly.

Analyzed business model and created BI Architecture plan, created Business Functional Specifications, Functional Design Specifications, and Detailed Design Specifications

Extensive experience in writing the documentation for Technical Specifications and functional requirements.

Assisting the client, through analysis of their existing system, challenges, and business needs

More experience in working on Logistics module for extracting the data from the source and writing the transformations on it.

Facilitate meetings in the business area to gather and review business requirements and to translate requirements to technical teams.

Communicate effectively with management to enhance their understanding of the opportunities and limitations of information systems.

Experience on ABAP coding in BW, Start Routines, Update Rules, Transfer Rules, User Exit and Customer Exit variables, and also Start Routine and End Routine in BI 7.0/7.3.

Documented the reporting requirements, dashboard design requirements by thorough interactive sessions with Business users by building prototypes for developing the interactive executive level dashboards.

Involved in Full Life Cycle Implementation of BI 7.0 along with an up-gradation of clients present SAP BW 3.5 to BI 7.0/Net Weaver 2004s and Performance analysis.

Interacted with the Management and Business End-Users to identify business requirements and actively involved in implementing ASAP methodology.

Customized/designed Data Flow right From ECC, CRM to BI and further.

Extensively Worked on SAP ECC Extraction of Financial data, CO-PA and Sales & Distribution Lo-Cockpit.

Worked with FI Cubes to enhance the performance (Modeling, Data load) from other systems and did currency conversions for Country specific.

Worked on CO-PA extraction. Extracted Line Item data from GL, AR and AP.

Used start routines whenever possible for process transformations. Custom extractors were created for FI, SD, MM by using ABAP.

Created DTP’s to load data from Flat File via Data Source into Staging DSO and in initialize by Full & Delta process.

Activated and Customized profit center accounting cubes, accounts payable cubes/accounts receivable cubes. Created Multi-Providers on Sales, Deliveries and Billing Info cubes.

Involved in the design and development of Profitability Analysis (PA) Cube in Controlling (CO) and Profit Center Accounting (PCA) as part of SAP FICO implementation. Created process chains to automate data loading process.

Worked on BEx Analyzer, BEx Browser and WAD (Web Application Designer) tools to generate reports related SD and MM.

Used BEx Analyzer to Create Queries with Variables, Filters, Calculated Key Figures, Restricted Key Figures, Exceptions, Conditions with Charts and Worksheets.

Developed customer exit for variables and coded in user exit for BEX reporting.

Handled performance tuning of queries using Aggregates, Table Partitioning and Indexing of Info Cubes.

Involved in transportation of objects to target systems and handled transport related issues.

Designed, Developed and Maintained Universe Designer by defining joins and indicating cardinalities between tables in star schema (fact and dimension table) from data warehouse,creating Aliases to resolve the Loops, subdividing into Contexts to remove cyclic dependencies.

Created Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.

Created complex reports using complex variables, multiple breaks, sorts, cascading prompts, decode objects etc. Extensively used breaks for white spaces and sections for better navigability.

Tested all the reports with different scenarios like query balancing, look and feel and formatting of the reports based on the specifications.

Responsible for SQL tuning and optimization using Explain Plan, Indexes and optimizer hints.

Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes.

Environment: SAP ECC 6.0, BI 7.0/ BW 3.5, SD, Logistics, MM, FI,CO, CRM, BEx Analyzer, Web Application Designer (WAD), ABAP/4,SAP ISU, Business Object XI 4.0/3.1, Crystal reports 2008, Unix shell scripts, Xcelsius 2008, Designer, Desktop Intelligence, Web Intelligence, Info View, CMC, Informatica 8.1, Teradata V2R7, SQL, PL/SQL, SQL Server 2008, SQL Assistant, Erwin 6.1, Windows 2000/XP.

Wyeth Pharmaceuticals, New Jersey Oct‘09 – Dec’10

Sr. BO BW Developer

Wyeth is a research-based, global Pharmaceutical Company responsible for the discovery and development of today’s most innovative medicines. Wyeth has a long history of pioneering developments in pharmaceuticals and biotechnology. The Project includes creating the reports to monitor the sales of the various products as per the region and by pulling the historic data from the EDW (Enterprise Data Warehouse)

Involved in all phases of Software Development Life Cycle. Gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.

Extensively used BEx analyzer, created queries with variables, filters, exceptions, conditions, calculated key figures, restricted key figures.

Created RRI so that the user can jump from one report to the other.

Developed several queries and the workbooks using BEx Analyzer according to end users requirement for SD (billing document, deliveries, planned sales/ actual sales).

Involved in activating the Master Data sources and loaded the master data in SD and MM areas.

Created and maintained the info cubes in SD for Billing, Deliveries and Sales Orders Overview.

Worked on Info Objects, Data Sources, ODS and Info Cubes to facilitate corporate reporting

Worked on the extraction of data’s from LO cockpit-SAP R/3 to BW

Extensively worked in extractions, LO-Cockpit extraction 2LIS_02_ITM, 2LIS_13_VDHDR and others using V3 update.

Responsible for building and maintaining the Info Cubes / Info Providers, in Purchasing for Purchasing Data (0PUR_C01), Vendor evaluation (0PUR_C02) from the standard Business content. Created transfer rules, update rules and the start routines wherever required.

Maintained and created aggregates to improve the performance.

Created complex Universes and Reports and Checked the Universes for Integrity and exported them to the Repository to make resources available to the users and groups.

Created predefined condition, prompts and customized LOV’s in the process of building the Universes.

Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.

Extensively created reports in WEBI and DESKI module and implemented drill down features and created reports including horizontal table, vertical tables, forms and charts.

Created reports on web using Info View Portal and published the reports on the World Wide Web to different users.

Created several Classes, Objects, Conditions, and Measure objects

Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.

Resolved loops, defined contexts and aliases to resolve loops and also tested them to ensure that correct results are retrieved.

Resolving join path Problems like ‘Chasm Trap’ and

Contact this candidate