Sap Data

AMITHSA MEHARWADE SAP HANA Certified Consultant

*******.***@*****.*** SAP BO Webi Certified Consultant

SAP BW/BI/BW ON HANA Consultant

Professional Summary:

Ten years of overall SAP experience. SAP HANA Experience with C_HANAIMP131 (SAP HANA Application Associate) Certification, SAP BI/BW/BOBJ Experience with C_BOWI_40 (SAP Business Objects Web Intelligence 4.0) Certification. Strong experience in SAP BODS.

Implemented 2 Full Life Cycle Implementation in SAP HANA.

Implemented 2 Full Life Cycle Implementation in SAP BOBJ.

Implemented 3 full life cycle implementation in SAP BW BI 7.0/7.3/7.4 BW projects (including BW on HANA) for SD, FI/CO and MM modules in all phases like Gap analysis, Blue-printing, Design specification, Realization, Testing, Documentation and Production Support.

Expertise in BOBJ reporting suite of products including WEBI, Crystal Reports, Xcelsius /Dashboard Design, Information Design Tool(IDT)/Universe Design Tool(UDT), CMC, SAP Design Studio and SAP BO Explorer.

Extensive Experience in developing data models in SAP BW 7.4 on HANA and HANA SP2/SP7.

Involved in building reports using SAP BO 4.0 tools on SAP HANA data models.

Strong experience of different layers in SAP HANA Architecture, different editions of SAP HANA SOFTWARE, SAP HANA data modeling using Attribute View, Analytic View and Calculation Views & SAP HANA Data Provisioning using SAP LT Replication Server (SLT).

Strong experience in different types of SAP HANA Security Authorizations, different types of users in SAP HANA, Transports (Server, Client), Direct Extractor Connections.

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

Strong experience of SAP BW on HANA.

Proficient in all phases of BW application development including Data extraction, Transforming Data, Loading data and Reporting.

Proficient in interpreting and writing ABAP routines.

Expertise in using Dashboard and Data Discovery Tools like Design Studio, Lumira, Tableau etc.

Excellent hands-on experience on BW reporting Tools- BEx Web Designer, BEx Analyzer, BEx Query Designer, BEx Broadcaster.

Performed Data load management, Scheduled Start Process of process chains, triggering Process Chains based on Events, Data source Enhancement, Extraction of OLTP data, Loading (Full /Delta Up-Load), Monitoring, creating Remote Cubes, understanding Data Mart, Info Spokes and Open Hub Service.

Extractions – Extracted data from Logistics (SD, MM, and PP etc.), FI, CO-PA, Generic data sources (RSO2), Flat File, Non- SAP systems.

Rich experience in maintaining Aggregates, Performance Tuning, Partitioning, Compression, Indexes, BW Statistics, BW Job Scheduling, Testing BW Reports, Cut-over activities, Go-Live Support, Production Support, End-user training and Documentation.

Extensive experience of Standard Info Cubes, Info Object and Info Sources, Web reporting, Extraction, Transfer Structures, Transformations, Data Store Objects (DSO), Info set, Multi providers, Hierarchies, Business Explorer (BEx) and Archiving.

Worked extensively on standard and custom defined LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration and customization.

Performance Tuning -Evaluated statistical performance and suggested recommendations to SAP basis support team for optimization. Improved data load and query performance by doing Compression, Aggregates, Creating Indexes, Creating Statistics on cubes etc.

Reporting - Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, conditions, RRI and Jump queries etc.

BW Security - Defined authorization, user profiles, creation of Users and Roles and access.

BODS (SAP Data Services – ETL Tool) – Data Migration (Flat File to Flat File, Flat File to Database, Database to Flat File, Database to Database), configuring data-stores to connect to various sources like SAP, Microsoft SQL Server 2012, system configurations, single user instance, multi-user instance, configuring Jobs (Batch and real-time), extracting the meta data, DS Management Console. Basic knowledge on Information Steward.

BODS (SAP Data Services – ETL Tool) Landscape –Check in and check out of BODS (SAP Data Services – ETL Tool) objects between Local Object Repository and Central Repository.

Created Conditions, Scripts, global variables and local variables. Strong experience on Data Integrator, Data Quality and Platform Transformations.

Tableau – Good knowledge of various Tableau components, Tableau Architecture (SQL connector, MDX connector, VizQL compiler), capabilities of Tableau and Advantages of Tableau, Live Vs Extraction connection, Global Filter Level Vs Local filter level,

Good experience on using SAP SUPPORT PORTAL – To create SAP Incidents, tracking the response from SAP and making maximum utilization of already existing SAP notes to fix SAP system issues.

Strong knowledge on Big Data Solutions and SAP HANA - HADOOP Integration. Good knowledge of HANA XS, proficient in JavaScript and developing User Interfaces with SAP UI5 (or open UI5), Operational Data Provisioning (ODP).

Presentations - Conducted workshops and presentations to validate business requirements and solutions with the end user community. Developed business process documentation.

Excellent verbal and written communication skills, ability to work independently as and when required and highly Self-Motivated.

Technical Summary

SAP-BW/BI Migration from 3.x to 7, Migration from 7 to 7.3, Migration of BI 7.3 from traditional DB to HANA DB, Data Warehouse workbench (RSA1OLD/RSA1), Process Chains, Logistics Cockpit, Query Designer (3.X/7), Web Application Designer (3.X/7), BEx Analyzer (3.X/7), BEx Broadcaster, BW Modeling in SAP HANA Studio in Eclipse Platform, Operational Data Store.

SAP HANA SAP HANA1.x to SPS09, SAP HANA Studio, SAP HANA DB, SQL, SLT, Sybase Replication Server, SAP Lumira/Predictive Analysis, SAP DXC (Direct Extractor Connection), SAP BW on HANA, SAP HANA Live, Smart Data Access, BW Modeling in SAP HANA Studio, SAP HANA XS.

BUSINESS OBJECTS SAP Business Objects BI 4.0/4.1/3.1/XI R3, SAP Business Objects Business Intelligence Platform, SAP UDT/IDT, SAP Analysis for Office, SAP Analysis for OLAP, SAP BO Explorer, BI Launchpad, Crystal Reports for Enterprise, UDT, IDT, CMC, Dashboard (Xcelsius), Design Studio 4.x, Webi 3, x, 4.x, BODS 4.x, Information Steward, Data Service Management Console DSMC.

SCRIPTING LANGUAGES SAP Design Studio Scripting Language, SAP Data Services Scripting Language, SQL Scripting, Java Script, Tableau VizQL Scripting.

TICKET MONITORING Service-Now, ITSM, Remedy, Coach

TESTING TOOLS Mercury Test Directory Tool, HPQC

JOB SCHEDULER CA Autosys 11.3.6, IBM Tivoli Maestro 8.3

SAP-APPL SAP SD, SAP FI/CO, SAP MM, SAP SRM, CO-PA, Assets

DATABASE HANA, ABAP Data Dictionary, Oracle, MySQL, SQL Server, MS-Access

ENVIROMENT Windows XP/NT/7, Linux, UNIX (Solaris)

OTHER SKILLS SAP BPC, SAP BPS, SAP IP, Tableau, Hadoop, Alteryx, Informatica (ETL Tool), PL/SQL, C, C++, XML, Java, HTML, MSOffice, MS Excel, MS Word, MS PowerPoint, MS Visio.

PROFESSIONAL EXPERIENCE

SAP HANA BOBJ BW Lead

LEXMARK Dec 2014 to Feb 2016

Environment : SAP HANA SP7, SAP BW 7.4 SP5 in Eclipse Platform, SAP BO Analysis Office 2.0, SAP EHP 6.0, Autosys Job Monitoring Tool 11.3.6, Coach Ticket Monitoring Tool, SAP BODS (SAP Data Services) 4.0, Tableau, SAP BO Analyses OLAP, SAP Lumira, Webi 4.0. SAP HANA Live, Information Design Tool (IDT), Design Studio.

Responsibilities:

Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.

Quickly redeploying the views from HANA QA to HANA Production environment during cutover activities.

Exporting/Importing packages using Delivery Units.

Created multiple schemas and table definitions.

Involved in business and Architecture discussions.

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

Resolving user incidents like changes in layout of views, filtering data, correcting the logic, bringing more fields in the view, etc.

Monitoring HANA system to make sure replication to HANA Tables are up and running daily.

Created SAP HANA data models using Attribute View, Analytic View and Calculation View. Created CE Script and HANA Stored procedures using SQL Script.

Reporting BW Queries built on top of Virtual Providers and Composite Providers using Analysis Office 2.0.

Created Technical specifications and standard modeling documents for HANA.

Using smart data access, accessed data between HANA systems, HANA system and Hadoop. Gained knowledge on setting up Smart Data Access with other systems.

Performed Real time configuration in BODS (SAP Data Services) like associating repository with web administrator, enabling adapter communication etc. and monitoring real time services in web administrator.

Worked on Message Source and Message Target scenarios in BODS (SAP Data Services).

Created jobs, workflows, data flows, configured data sources, used lot of query transformations, performed check-in/check-out of BODS (SAP Data Services) objects from/to central repository, used DI transformations such as Query, Validations, Case transforms etc.

Used SQL to Create, Drop, Alter other DB Admin rights on HANA DB Schema and its objects.

Created Calculation views on remote data sources using Smart Data Access.

Replicated data using SLT and created models as per requirement.

Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and

Development.

Worked with security team and helped users setting up Analytical Privileges.

Acquired HANA views from SAP HANA system, acquired Universes from IDT, business data from user provided excel sheets and csv files and combined data multiple csv files when creating data set in SAP Lumira. Created visualizations on input data. Composed infographic and report stories with various input controls like checkboxes, drop down, radio button etc.

Creating visualizations and stories in SAP Lumira as per user requirements by applying necessary formatting, creating calculated measure, showing data label options, creating geographical hierarchies, creating time hierarchies, solving inappropriate data on various types of graphs like Geo Choropleth graph, Geo Bubble chart, Geo Pie chart, Tree Map, Heat Map and Bubble chart.

Created reports in Design Studio by extracting data from various multi-dimensional sources.

Published report stories in SAP Lumira Cloud and SAP Lumira Server to users.

Interpreted SAP generated views in SAP HANA Live to get the base tables of HANA database to find the suitable required tables for replication in SAP HANA. Worked on SAP HANA Live tool – Filters, Favorites, overview of fields, used cross reference to see base tables, using view in SAP Lumira, using view in SAP Analysis office and used the Generate SLT file feature to find the base tables for a view.

Involved in support and monitoring activities after go-live.

Installed trial version of Tableau Desktop version with One-year license and created Tableau Dashboard to provide Daily batch status to users.

SAP HANA BOBJ BW Lead

NATIONAL GRID Apr 2014 – Nov 2014

Environment : SAP HANA, SAP BI 7.4 SP5 on HANA DB, Admin Cockpit (BI Admin Package 1.0), SAP EHP 6.0, SAP BO Analysis OLAP, BOBJ Reports- Webi & Dashboards.

Responsibilities:

Single point of contact for Client in Onshore. Leading a team of size 5.

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio

Created HANA modeling scenarios – Creation of schemas, tables – columns/row, SQL Script

procedures, loading data into table, developed Attribute View, Analytical View and Calculation Views Graphical and SQL Script – CE Functions based views for report requirements.

Gained strong knowledge of RDS on HANA.

Migrated HANA content from development, testing environment to Production environment using delivery units.

Created CE Script for calculation views and Stored procedures using SQL Script in HANA database.

Developed HANA Column based tables and SQL Script Procedures, Loading data into table definitions, suspending data loads, resuming data loads.

Adding user to SAP HANA System, Exporting/ Importing SAP HANA packages.

Involved in SAP HANA Security including User Management, Roles, and Privileges.

Created OpenODS views and Composite providers using Eclipse Based modeling using field based modeling.

Participated in project planning sessions with project managers, business analysts and Team members to analyze business requirements and outline the proposed solution.

Designed and Document Universe and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies.

Created Full client, Webi and Crystal Reports based on the END Users and Business requirements and Modified the existing Reports based on the specifications and requirements.

Analyze the reporting requirements with the business users and the QA team and come up with the technical specifications for the BO Reports.

Involved in Building universe, Inserting tables, Detecting joins, Detecting cardinalities and checked the integrity.

Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.

Implemented the Object-Level Security and Row-level security in Universe. Implementing the Table Mapping in Universe to restrict certain data in a table to only one group of users.

Designed and developed extensive Business Objects reports like Simple, Complex, Cross Tab using multiple Queries, Prompts, combination chart and tables.

Created Standard Reports utilizing all the features on Web Intelligence in BOE XI 3.1 like Optional Prompts, Functions, and Alerters etc.

Created complex reports using Merged Dimension and multiple data providers and synchronized the data providers by linking the common objects to create the common report.

Extensively worked on Unix Shell Scripting.

Developed SAP HANA Analysis Process (SAP HAP) in BW on HANA Environment.

Responsible for creating the Webi reports (On demand, Audit Reports, Ad-hoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab, graphical, etc.).

Extensive knowledge in architecture design of Extract, Transform, Load environment using SAP BODS

SAP HANA BOBJ BW Lead

EASTMAN KODAK Sep 2013 – Mar 2014

Environment: SAP BW 7.3, SAP HANA 4.0 SP2, SAP EHP 6.0, Tivoli Maestro Job Scheduling Console Feature level 8.3, Fix pack 6, SAP Business Objects v XI R2 SP2,XIR3.1 SP3, Xcelsius 2008,Live Office, Crystal Reports vR2, SAP BODS (SAP Data Services) 4.0, Tomcat v5.0.27,v5.5,DB2 v8.2,v9.5,Oracle 10g, SQL,PL/SQL, Unix Shell Scripting.

Responsibilities:

Migrated BW Cubes and DSO’s from traditional Oracle Database to HANA Database using

RSMIGRHANADB.

Cleared PSA’s for data loaded already loaded to DSO’s, deleted the aggregates, compress the E

and F tables in all Infocubes, remove data from unused DSO’s and Infocubes, remove data from

statistical cubes by using the program RSDSTAT_DATA_DELETE, clean up background information stored in RSBATCHDATA etc. as part of migration activity.

Migrated in memory Cubes and DSOs to Hana studio and modified as per requirement to create Calculated and Analytic views.

Learnt about tools ZBW_HANA_MIGRATION_COCKPIT and ZBW_HANA_CHECKLIST to support migrating BW systems to SAP HANA.

Involved in moving Information models to BW as transient provider and created Reports.

Worked mainly on creating/monitoring Maestro Tivoli Schedules/Jobs.

Email client is IBM Lotus notes - Release 8.5.1. Worked on SIR (System Investigation Requests) and DCR (Data Center Requests).

Participated in project planning sessions with project managers, business analysts and Team members to analyze business requirements and outline the proposed solution.

Designed and Document Universe and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies.

Created Webi and Crystal Reports based on the END Users and Business requirements and Modified the existing Reports based on the specifications and requirements.

Analyze the reporting requirements with the business users and the QA team and come up with the technical specifications for the BO Reports.

Involved in Building universe, Inserting tables, Detecting joins, Detecting cardinalities and checked the integrity.

Created universes, classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.

Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.

Implemented the Object-Level Security and Row-level security in Universe. Implementing the Table Mapping in Universe to restrict certain data in a table to only one group of users.

Designed and developed extensive Business Objects reports like Simple, Complex, Cross Tab using multiple Queries, Prompts, combination chart and tables.

Created, maintained and modified the business critical reports using the Web Intelligence.

Created Standard Reports utilizing all the features on Web Intelligence in BOE XI 3.1 like Optional Prompts, Functions, and Alerters etc.

Created complex reports using Merged Dimension and multiple data providers and synchronized the data providers by linking the common objects to create the common report.

Extensively worked on Unix Shell Scripting.

Responsible for creating Webi reports (On demand, Audit Reports, Ad-hoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab, graphical, etc.).

SAP BW HANA BO Consultant

LEXMARK Apr 2012 – Aug 2013

Environment: SAP BI 7.0; SAP BI 7.3, Windows XP, SAP EHP 6.0, ABAP/4. BWA 7.2, SAP HANA 4.0 SP2 and BOBJ 4.0 – Webi & Dashboards

Responsibilities:

Single point of contact for client and business users at onsite for any Business Intelligence related

issue.

Provided support to BW system during BI 7.3 upgrade and EHP6 upgrade.

Gathered and analyzed the requirement to replicate ECC content in HANA using Data

Provisioning.

Provided support of SAP HANA system after SAP HANA Go-Live.

Worked with Basis team consistently to fix Replication issues in SLT systems.

Established the best modeling and recommended strategies for BOBJ environment and architecture for SAP HANA.

Trouble shooting invalid data issues in BOBJ reports running on HANA.

Cleaning up of invalid characters in BW system, by finding the source of data and requesting source team to correct it from their end.

Complete awareness of BI 7.3 features (Limited PSA Data Edition Flexibility, Start/End

Routine feature in 7.3, Process Chain options like skip, open hub features, BWA, checking BWA Alerts etc.).

Made sure Reorg of BWA Indexes was executed on every weekend without conflicting with

creation of BW Indexes job.

Resolved issues during EHP6 upgrade – No data for 0FI_AA_12 data source,2LIS_03_BF

incorrect key figures, delta failure of Sales data sources 2LIS_11_VAITM, 2LIS_11_VAHDR,

DSO yellow requests issue etc.

Involved in continuous improvement of the BW system and performance enhancement of data

loads and reports.

Created and maintained Semantic Partitions.

Involved in integration of BOBJ4.0 and BODS (SAP Data Services) 4.0 with SAP HANA 4.0

Created technical specifications and standard modeling documents for HANA.

Migrated HANA content from development/testing environment to production environment using

delivery units.

Created Universes on top of HANA calculation views and developed Webi reports and

Dashboards using IDT (Information Design Tool).

Performed data modeling and developed Analytical views for the transactional data, Attribute

views for master, and the calculation views as final model in HANA studio.

Loading data into table definitions, suspending data loads, resuming data loads. Creating

information objects (packages, attribute views, analytics views, calculation views, Graphical and SQL based script).

Used Remedy Ticket Monitoring Tool. Tracking the issues and resolution of Incidents as per the process.

Process Chain Monitoring. Load monitoring and jobs scheduling in SAP BI so as to facilitate users with timely business reports.

Co-ordinate the status with offshore team and assigning tasks to concerned team members.

Raised high/very high SAP messages during critical moments. Coordinated with SAP Engineer and resolved the issues on time.

Got exposure to APD’s. Designed and Developed few APD’s.

Did Performance improvement of the system by creating weekly housekeeping chains for

compression, PSA/CHANGE LOG deletion chains, cleaning unnecessary old data from the cubes/dso’s, tuning the code in start/end routine, loading only the appropriate needed for business, checking the fact to dimension table ration in SAP_INFOCUBE_DESIGNS and modifying the cube design to improve data load performance, creating and refreshing DB indexes, DB statistics etc.

SAP BI/ BW Consultant

HERSHEYS Feb 2012 – Mar 2012

Environment: SAP BI 7.0, WAD 7, Query Designer 7, Windows XP, SAP ECC6.0.

Responsibilities:

Debugging of all the inconsistent WAD reports and BW Queries and fixing the bugs.

Communicating with business users and getting the appropriate data needed from the end users

and modifying BEx Queries and WAD reports to meet user’s needs.

Mainly worked on Structures and Cells. Made high utilization of inbuilt functions in WAD.

Part time Process Chain Monitoring and fixing production issues.

SAP BW BO Consultant Jul 2011 – Jan 2012

CLOROX

Environment: SAP BI 7.0, Analyzer 7, Query Designer 3.5, Query Designer 7, Windows XP, SAP ECC6.0, ABAP/4.

Responsibilities:

Developed BW Objects based on the Functional Specifications and Layout provided by the end users.

Created Queries based on OTC, R2R, ME, S2P, F2S modules. Mainly worked on OTC (Order by Status) and R2R (Inventory Value cost by Materials, Trade Fund Accrual, Inter Intra Instance Markup) reports. Worked with VF03, MC.9, MB03, ME23N Tcodes

Enhanced data sources, wrote functional modules.

Used CONVERT_TO_LOCAL_CURRENCY, CONVERT_TO_GLOBAL_CURRENCY, FIRST_DAY_IN_PERIOD_GET etc. functional modules and RSIMPCURR program.

GAP Analysis of existing extractor’s custom fields with business content extractor fields (ECC 6.0).

Delivered BEX to OBIEE (Oracle Business Intelligence Enterprise Edition) team.

Created transports requests from Development environment to Quality and Production environment. Maintained transport requests for GO-LIVE. Made sure that all the BW objects were moved to production during GO-Live successfully.

Cut-Over Experience. Experience with Interaction with BASIS.

Maintained corporate (write optimized) DSO’s for most of the modules.

Was part of HYPERCARE production support team. Have Trouble shooting experience.

Creation and maintenance of process chains.

Have done ECC Enhancements, written End Routines and Infoobject level routines. Mainly look-ups.

Multi-level (nested) calculations performed for each key figure in the report.

Data model performance analysis (Routines, Multi Layered DSO).

Validation of BW reports.

Experience with HP Quality center.

SAP BI / BW Consultant

PG & E Jan 2011 - May 2011

Environment: SAP BW 3.x, SAP BI 7.0, BEx Anaylzer 3.5, Analyzer 7, WAD 3.5, WAD 7, Query Designer 3.5, Query Designer 7, MS SQL Server 2000, Windows XP, Linux, SAP ECC6.0, ABAP/4.

Responsibilities:

Worked in production support team. Mainly worked in Reporting team. Provided support to End Users. Resolved issues through phone and by connecting to their system using Netmeeting.

Expert in ITSM (Incident/Ticket monitoring) tool.

Resolved all types of High Priority, Medium Priority and Low Priority incidents within SLE between Capgemini and Warner Bros.

Developed/Built Queries using 3.5/7 Query Designer.

Worked on Change Requests related to WAD 7, Query Designer (3.5/7) and changing Workbook (3.5/7) settings.

Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in

ECC-BI CMOD, Generic Extractions and also in BI data modelling like Start Routines and End Routines

User Demo, Presentations on BI Reporting.

Worked a lot on BW 3.5 and BI 7 Workbooks based on Multiproviders.

Helped Migration team in testing BI 7 Workbooks after migration. Resolved issues related to BI 7 Workbooks.

Compared the discrepancy between BW Reports and R/3 side (ECCS, CASH, FINANCE, PS).

Tcodes mainly used – GD13, GD20, FBL3N, KS13, KS03 etc.

Created Charm requests using zcharm in SMP (Solution Manager Production).

Was involved in 3 Regression Testing’s and one GO-LIVE

Broadcasting of 3.5 and 7 reports to end users. Fixing Broadcasting related issues by checking

Job Logs and checking Broadcasting settings.

Coordinated with basis to handle broadcasting related issues.

Involved in Debugging VBA code, especially during Migration and installed necessary patches or upgrades to make the Workbooks run normally.

ACCENTURE SERVICES PVT LTD, BANGALORE, INDIA July 2006 – July 2008

JUNIOR SAP BI/ BW Consultant

Environment: SAP R/3, 4.7EE, BW 3.5, BEx Analyzer, ABAP/4, Windows 2000/NT.

Responsibilities:

As a part of implementation team, involved in gathering user requirements and data modeling

using Extended Star Schema Concepts.

Installed relevant SAP business content.

Designed and customized data models and Info Cubes for Sales order.

Used ODS to stage data before transferring ODS contents to Info Cube.

Used ABAP Routines (Start Routines, Update Routines) in Update rules and Transfer Rules

to Update Key Figures in the Info Cubes.

Created Multi cube based on Sales order and Billing cubes.

Responsible for design, development and extraction of data from R/3 Source System and Flat

Files to the BW system and created various Info package to enable data transfer.

Worked on creation of Aggregates for the Info Cubes and hierarchies to access data in an

efficient and ordered level.

Developed various reports for forecast comparison. Designed, Developed and integrated reports using Crystal Reports.

Monitoring daily /weekly/monthly loads and solving loading issues.

Involved in weekly maintenance issues as part of performance team.

Training end-users on utilizing, developing and creating BW Queries.

Education

Master of Science in Computer Science, 2009

San Diego State University (SDSU), CA.

Bachelor of Engineering in Computer Science, 2006

Bangalore Institute of Technology, India.

Contact this candidate