SUMMARY:

• Having 13 plus years of Extensive experience as Senior SAP Consultant on SAP Native HANA, SAP BW/SAP BW on HANA, SAP BO, SAP B4HANA, ABAP/4 and SQL with experience on implementation and support projects including data modeling, extraction and report creation.
• Experienced in end to end life cycle implementations in various industries for SD, MM, FI/CO, HR/HCM, Oil & Gas, and QM modules and followed ASAP methodology.
• Extensively involved in Technical development, Transition management, solution consultant, and Leadership management/Offshore Coordinator.
• Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, partitioning.
• ABAP - Reporting, User Exits, Customer modifications. Proven success in performing all reporting features, OLTP Extraction from SAP R/3 into BW using different extraction structures. Functional expertise in SD, MM and FI/CO. In-depth knowledge of reporting flow from R/3 to SAP BW.
• Worked Routines (Start, Field, End and Expert routines). Ability to identify the suitable routine based on the scenario.
• Expertise in design and development of Generic Data Source Extraction using Table, View, and Info set Query, Domain and Function Module with Full and Delta functionality.
• Expertise in Info Package and DTP routines, Debugging, Performance tuning of various objects, Code reviews and designed the documents for best practices in BW environment.
• Worked with the project team and multiple end-users to resolve accounting issues and identify opportunities for business process improvements. Provided production support in BW reporting.
• Hands on exposure in writing complex transformations in BODS.
• Hands on experience in the design, development of SAP Data Services (BODS) jobs depending on the customer requirements.
• Experienced in providing training to the users and coordinating cross-functional teams.
• Experienced in creating system and User documentation as per the business requirements.
• SAP Lumira - Deploy the standard graphing techniques of visualization for bar charts, line charts, histograms, pie charts and scatter plots.
• Modeling - Extensive experience in BI Architecture, Extended Star-Schema, Multi- Dimensional Modeling, Data Flow Strategy, Defining Dimensions, InfoCubes, Composite Providers, Hybrid InfoProviders, Virtual Providers, Advanced DataStore Objects, Open DSO, SAP HANA-optimized DSOs, SAP HANA-optimized Infocubes, Multiproviders, Symantic Partition Objects (SPOs), InfoSets, DataSources, InfoSources, InfoObjects, PSA and DSOs.
• Expertise in designing, developing, configuring, installing SAP BW objects DataSources, InfoSources, InfoObjects, ODS/DSO, InfoCubes, Multiproviders, InfoSets, InfoSpokes / Open Hub destinations, APDs, Transfer Rules, Update Rules, Transformations, Start / End / Expert Routines, DTPs, InfoPackages, Process Chains and Activation & enhancing the business content.
• Customizations - Experience in activating standard business content, extending and enhancing InfoCubes according to the requirements, Datasource enhancements, User Exit Variables (CMOD), Virtual Key Figures and Start Routines.
• Extensive experience in designing and developing Extractors, Tables, Views, Extract Structures, Function Modules in SAP ECC/CRM and legacy systems.
• Retraction data from BPC to BW for various modules like SD, Finance and project systems by using APD tool
• Solid experience in Data Modeling, Extraction, Cleansing, Loading, Scheduling, Monitoring, Delta Management and Reporting.
• SAP BW IP - Characteristic relations, Data slice, planning functions, planning sequence, FOX coding
• BEx Reporting - Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, R/RI, Ad-hoc Queries and Web application designer, Web Items.
• Production Support - Extensive experience in support, Data Loads, Validation and Troubleshooting of Transaction and Master Data, Change Management, Transport Management, Roles & Security, System Checks, Performance Tuning and Process Chains.

TECHNICAL SKILLS

ERP Package: S/4 HANA, SAP R/3 ECC 6.0, 4.7 E.

SAP Module: SAP Native HANA & SAP BW on HANA, SAP BW 7.4, 7.3, 7.0 and 3.5, MM, SD, FICO, HR/HCM, COPA, Bank Analyzer and QM.

OLAP Reporting tools: SAP BEx Analyzer, WAD, Business Objects WEBI, SAC and Lumira

DATA Replication Methods: SDI, SDA, SLT & BODS

Data Modeling Tool: HANA Studio

Databases: SAP HANA and Oracle 8i

Programming Languages: PL/SQL Script, and SAP ABAP/4.

PROFESSIONAL EXPERIENCE:

Confidential, San Rafael, CA

SAP HANA Expert/Data Modeler

Responsibilities:

• Design objects in WEB IDE for HANA on XS Advanced Server using HDI Containers, GIT Hub, MTA, Synonyms, Table Functions, CDS Views, Stored Procedures and SDI Flow Graphs.
• Worked in building ETL flows with HANA SDI/SDA (Smart Data Integration/ Smart Data Adapters) to extract both SAP and non-SAP data into SAP HANA 2.0 platform.
• Integrate different sources system and handle various types of data migrates to SAP HANA.
• Redesign existing BW objects to Native HANA objects.
• Involved in Technical Specification development based on Functional Specification, testing and training.
• Leveraged the capability of currency conversion in HANA 2.0.
• Define technical activities on upgrades and maintenance planning for SAP HANA.
• Analyze and tune Analytic data models and data flows for performance improvement.
• Designed multi sourced Group Reporting for management needs, sources include S/4 HANA, Oracle.
• Designed and developed Reconciliation billing dashboards using SAC.
• Importing & Exporting HANA content from development, testing environment to Production environment using HANA life cycle management.
• Perform and coordinate Cut Over activities
• As part of production support fixed issues along with the necessary documentation.

Confidential, San Jose, CA

Senior SAP HANA Consultant

Responsibilities:

• Working with users and cross teams (PO & BA) to gather requirements and Translating Functional Specifications into Technical Specifications.
• Designed enterprise data model and Developed HANA solutions involving the following to incorporate the business logic as much as possible within HANA to prepare KPIs and business-measures, ADSO objects from BW, Native HANA Views/tables, Stored procedures, Graphical & SQL Calculation Views using Input Parameters, Cascading &Currency Conversion
• Design, architecture planning, develop and support new Mappings and Data flows for SAP HANA.
• Involving in HANA Information models, Designing Schemas, Creating Packages, Calculation view, Analytic Privileges, SQL Scripts, Stored Procedures, Sequences, HANA Table Design, CDS views, AMDP, SDI and Flow Graph and HANA data loading from diverse sources.
• Working with large data volumes including structured and unstructured data
• Work in building ETL flows with HANA SDI/SDA (Smart Data Integration/ Smart Data Adapters) to extract non-SAP data into SAP HANA 2.0 platform.
• Creating SDI workflows to transform data from Hadoop source to Bank Analyzer target tables.
• Implementation of BI/Analytics/data warehousing solutions, and in-memory solutions using SAP HANA in on premise/cloud/hybrid scenarios.
• Worked on SAP BW on HANA - CDS Views, all aspects of HANA Modelling, Graphical and SQL Views.
• Working on create reports on SAP HANA analytic views using SAP HANA MDX provider.
• Implementing SAP HANA Analytics on Cloud.
• Effectively applies PayPal methodology and enforces BI implementation standards.
• Analyzing and Performance tuning on Analytic data models and data flows and involved in Performance improvement of SAP HANA Views.
• Write the SQL Scripts, stored procedures and integrate them in the views.
• Used HANA Live and created copies of the Query views and modified them according the requirement.
• Serves as an internal Subject Matter Expert on one or more of the Bank Analyzer finance modules.
• Demonstrates accountability and contributions to the successful realization of PayPal goals.
• Build and maintain effective dashboards, visualizations, reports, and analytics using Tableau technologies for real time analysis.
• 24x7 On-call production support, troubleshooting, resolving critical production issues & root cause analysis.

Confidential, Shelton, CT

SAP HANA Consultant

Responsibilities:

• Determine HANA landscape including server sizing to meet the clients’ BI needs.
• Experience working on HANA Optimized Info Cubes, HANA Optimized ADSO's, Open ODS views Composite Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA.
• Built BW data models to extract data into ADSO layer and make it available for HANA.
• Extensively worked on Attribute Views (Standard, Time and Derived), Analytic and Calculation Views (Graphical and Script based), Creation of Hierarchies, Variables and Input parameters.
• Creating a roadmap for HANA Analytics and implementing BI solutions using HANA Analytics
• Coordinating with SAP cloud team for ensuring smooth operations of BI tools hosted on Cloud
• Worked on Operational Reports of various type of Datasets which includes SAP/Non-SAP source systems worked with: Sales Invoices, Vendor Invoices, and Inventory Balances & Inventory Movements.
• Created Calculation Views by using various nodes like Aggregation, Join, Union and Projection.
• Work closely with HANA cloud team to ensure that the SLA’s are met.
• Data modeling using Hana Modeler - Create scripted and graphical calculation views
• Extraction of data from ECC to HANA using SLT for replication of tables
• Work closely with SAP Business users to understand Claims management scenarios and create HANA Models that would be consumed by Webi to create Dashboards.
• Extensively worked on SAP HANA SQL scripting in the development of scripted based calculation view models Worked on Performance monitor / Tuning Hana Views.
• Reporting against OLTP data source.
• Define security for HANA models bases on Roles
• Lead and mentor team comprising of onshore and offshore HANA and Business Intelligence report developers.
• Expert in creating SAP HANA Views using Tableau dashboards
• Developed multi-data source challenging reports by merging data from multiple Data Sources using Web Intelligence WEBI and Power BI

Confidential, VA

Senior SAP BW/HANA Consultant

Responsibilities:

• Worked closely with the end users on a day-to-day basis for their reporting needs. Created Architecture documents for the BW implementations with the naming standards.
• Worked on upgrade of BW 7.3 to BW 7.4 on HANA database.
• Created Info objects, DSO’s, and Cubes & Multi providers as per the data modeling. Defined several transformations as per the need.
• Responsible for implemented Event Management to enable BW Reports including BW extraction related configuration in SCM system
• Worked closely on DMO activities as part of migrating BW 7.4 on HANA.
• Migrated data from SAP & NON-SAP Source systems to HANA data base using data provisioning as SLT replication, BODS and DXC methods.
• Involved in carrying out pre-migration and post-migration activities for SAP BW on HANA.
• Extensively worked on post migration Hana Optimization on HANA Studio.
• Managed, Configured and Performed Transports between multiple BW environments. Defined practices for BW transport management. Created multiple process chains for Delta & Full Data sources. Troubleshooting data and technical issues related to SAP BW.
• Provided support for data load, validation, performance monitoring and tuning. BW Data load scheduling, monitoring and troubleshooting data extraction / load problems
• 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
• Proposed solution and implemented for the split of flash sales and P&L reports as per the new business requirement.
• Worked on calculation views using PL/SQL script for complex logic interpretation.
• Created Attribute, Analytical, Calculation and Scripted calculation views with PL/SQL Scripts for the reports.
• Extracted data from the APO extensively for forecast snapshots to a comparison report.
• Created Advanced DSO, Composite provider and Open ODS view using HANA studio.
• Created new dataflow like InfoCubes, DSO’s and Open hubs to meet client reporting requirement
• Developed Start/end routines at transformations to achieve period conversion and legal entity logic
• Created tables using graphical and SQL statements.
• Expertise to creating Hybrid providers are based on the combination of DSO’s and Info Cube using BW on HANA Created multiple automated reports and dashboards sourced from data warehouse using Tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau desktop.
• Expertise created schemas and tables created on HANA, attribute view, analytical view and Calculation views using HANA Studio.
• Created Calculation & Analytical views for the Realtime data using with HANA Studio.
• Loaded data from flat file and SAP Tables using BODS
• Involved in Data Services jobs, workflows and data flows, Transforms and Perform analysis of ETL requirements.
• SLT used to load from SAP sources to HANA database
• Used Open Hub Services to push data out of SAP BI using SAP data services.
• Worked on SAP HANA data provisioning and using SAP LT replication server (SLT).
• Created structure and unstructured package to organize views
• Imported tables into HANA from SAP tables.
• Involved in creation WEBI and XCelsius reports.
• Created reports on top of HANA database connecting through online and offline mode using with Tableau.
• Created calculated measures and attributes also time characteristics and geographic hierarchies.
• Replicated Tables from SAP and non-SAP sources using SLT and BODS.
• Created restricted columns, calculated column, input parameters, and variables.

Confidential

SAP BW/HANA Consultant

Responsibilities:

• Led and mentored the project team from both technical and functional perspectives including solution development, requirements identifications, testing, and project management to achieve project timelines.
• Responsible for the Development and Support of the SAP Data Services Jobs to Load the SAP ECC and SAP BW Data into the SAP HANA and create data models
• Creating of HANA Calculation views as per KPI's defined
• Had created HANA-optimized DataStore Object.
• Had created HANA-optimized Infocube for faster reporting, to accelerate data loads, simplify data modeling and to allow faster remodeling of structural changes.
• Had created Virtual Infoproviders in BW on top of BW and HANA Model.
• Had created Transient Infoproviders for SAP BW OLAP Functions to report on SAP HANA Analytic and Calculation Views.
• Had worked on Graphical Data Modelling.
• Had designed advanced Infoproviders like SPO, Hybrid, Transient Infoproviders and composite Infoproviders.
• Worked on upgrade of BW 7.3 to BW 7.4 on HANA database.
• Has created ABAP Routines in transformations for lookup, imperative logic and for performance improvement.
• Gathered Business Requirements from SD module and Conducted Gap Analysis, Designed & Developed custom Data Source, Info Source, Extractor, Info Cube and ODS to fulfill user requirements.
• Developed Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation.
• Experienced in data provisioning from SAP and non-SAP system using SAP BODS data flows and ABAP flows.
• Experienced in cleansing the data using Data Quality transforms using SAP BODS also involved in writing ABAP code in InfoPackages to bring in data according to business needs Created batch jobs using DI transforms in BO Data Services tool. Involved in Unit testing of the jobs. Understood and Review the jobs designed in BODS. Prepared the jobs description documents. Implementing the technical document using BODS.
• Created project plan for existing SAP BW landscape for upgrade and migration to SAP HANA.
• Performed LO-Cockpit extraction to pull data from ECC SD modules into BW system extracting the Header and Line item data from the Sales and Distribution modules.
• Developed attribute views, Analytic views and Calculation views for Sales, Inventory and Finance tables replicated from ECC to HANA through SLT.
• Expert in tuning the performance of PL/SQL queries and ETL process.
• Led Dashboard Design Project and was responsible for delivering few major dashboards
• Prepared Cut over activities for BW Hana migration and executed them during go live.
• Designed and developed different Extraction-Transformation components using SAP Business Objects Data Services and loaded into different target DBs like SQL Server and Oracle.
• Daily Monitoring of Active batch jobs, which triggers BODS jobs and BOBJ schedules.
• Extensively worked on mappings with BODS Transformations like Map Operation, Table Comparison, History Preserving, Key Generation, Pivot, and Reverse Pivot, Merge transformation, Case and Validation transform.
• Developed and Modified jobs/Workflow/dataflow using SAP Business Object data services tools based on business requirement.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Variables, Formulas, Filters, Sorts, Query prompt and Hyperlinks in WebI.
• Involved in responsible for ETL batch for different SAP and Non-SAP Environments using SAP data services.
• Created web intelligence reports by using different formatting options.
• Conducted training sessions for end users about using Business Objects and creating ad-hoc Reports.

Confidential

Senior Soft Ware Engineer

Responsibilities:

• Designed and developed multiple BW InfoCubes and multi-providers to analyze Service Process, Activities, leads and opportunities.
• Created and maintained Info Cubes, Data Store Objects, Info Objects, Multi Providers, Info Sources, Data Sources, Transformations, Data transfer Process and Info Packages.
• Worked on configuration of account-based and costing-based CO-PA and the CO-PA planning framework.
• Designed the Data Model, Logical and Physical Data Models in the HR/HCM functional area.
• Analyzed business-reporting requirements that satisfy with SAP Business Content and installed the necessary objects for Business Content payroll data cube (0PY C02).
• Worked on Payroll data, Employee-Specific Payroll Data & Time and Labor Data.
• Designed documents based on functional documents as per the client requirement like HR and FI/CO.
• Extracted Client Specific Data extraction process from Ledgers and profitability analysis
• Activated data sources on SAP R/3 system and extensively involved in setting up of procedures for extracting data from SAP R/3 by using Customizing LO Cockpit, User-Exit programs as per the end user requirements and CO-PA extraction.
• Created G/L Hierarchy in SAP R/3 using SPRO and extracted them into 0GLACCOUNT in BW
• Filling up the setup tables, loading data into BI, and resolving the load failures Responsible for Data Reconciliation and consistent loads.
• Worked on Remote Cubes to support real time data. Extracting required data from the Data Source of PSA to DSO.
• Created process chains for data loading, delta uploading and periodical PSA deletion.
• Configured and created custom PCA reports in CO module.
• Generated complex reports to analyze Costing-based Profitability Analysis (Financial) are the form of profitability analysis that groups costs and revenues according to value fields and costing-based valuation.
• Responsible for Data Reconciliation and consistent loads.
• Created Employee level detailed queries for Decision Support Managers with yearly, quarterly, and monthly comparisons and Percentages.
• Transported Objects of cubes from Development to Quality for Testing and Production System during Cut-Over Phase.
• Created Web Templates and Web reports for labor quantities by Partner activity type for all the Cost Centers using WAD.
• Created OSS message for the problems encountered during the realization phase.
• Improved performance by creating Aggregates, Compressions, Partitions and Indexes used BW statistics and RSRV.

Confidential

Senior SAP BW/BO Consultant

Responsibilities:

• Created technical objects as per the requirements and designed in compliance with standards and procedures. Ensured on time defect free delivery. Ensure the code satisfies the design specifications and complies with project standards.
• Involved in implement the SAP 3.x data flows into SAP 7.x transformation upgrade project.
• Analyzed the scope of the project for Frontend and Backend objects which will impact by BW Upgrade
• Transporting the developed and changed objects from development system to different system Landscape
• Responsible for critical issues handling related to data loads, performance issues and data mismatch.
• Managing the tickets from the business as part of incident management.
• Worked on SD changes, incidents and operations.
• Monitoring of process chains as daily, weekly and monthly data loads using RSPCM.
• Rectification of job failures because of source system errors, duplicate records, change run failures, ODS activation problem and invalid characteristics.
• Resolved of daily user issues such as errors in the reports, mismatching of data.
• Manual loading of InfoPackages from flat files based on demand from the users.
• Maintained work history for all the tickets until it is closed down.
• Involved in rectification of load errors in master data and transaction data loads.
• Performed performance tuning activities for data loads by reducing data packet size, indexing, aggregates and compression.
• Worked on start routine and end routine as part of data flow change.
• Expertise on subset of the data services functionality that allows you to access, integrate, transform and delivered trusted data using Business Objects (BOBJ) Data Integrator.
• Designed and Developed Business Objects universes and star schema data models.
• Created universe using context, aggregate aware and derived tables.
• Created WebI reports using prompts, drill down, Crosstab and Multiple Data Providers.
• Hands on experience and training on dashboard design and advanced reporting using SAP BO XCelsius.

Confidential - Atlanta, GA

Senior SAP BW/BI Consultant

Responsibilities:

• Requirement gathered, designed and analyzed - Work with users to identify and advise on existing info structures updated by business events in R/3. Identify potential uses and conduct functionality gap-analysis.
• Involved in Technical Specification development based on Functional Specification.
• Extensively worked in Business Information Warehouse in creating Infocubes, DSO Objects, Multiproviders, Transformations, DTP, Data Sources, Characteristics & Key figures.
• Data loading using complex Transformations, start routines, end routines, Info sources and DTP’s
• Worked on Logistics Cockpit and extracted data with V3 updates. The data included Sales Order, Delivery, Shipment, Billing, Purchase, Goods Movement, and Stock Revaluation.
• Involved in developing RRI Jump Queries for detailed analysis like Sold-to-Party, Pricing, and Margin & Sales to Date at Material Level information.
• Worked on the Order-to-Cash, O2C Dash Boards Reports in the portals.
• Prepared project related documentation during the different stages of a project.

Confidential

SAP BW/BI Consultant

Responsibilities:

• Designed and developed multiple BW InfoCubes and multi-providers to analyze Service Process, Activities, leads and opportunities.
• Designed Technical documents based on business requirements in SD, MM, Financial Management and Controlling and QM modules.
• Analyzed, Designed, development, coding and implementation of standard/ customized Info Cubes and DSO (ODS) Objects for MM, SD and FI-CO modules.
• Upgraded, enhanced and supported activities from BW 3.5 to BI 7.0 in Nw2004’s.
• Multi-dimensional modeling, data analysis, data warehousing concepts, trends and best concepts.
• Activated of Data sources on SAP R/3 system and extensively involved in setting up of procedures for extracting data from SAP R/3 by using Customizing LO Cockpit, User-Exit programs as per business requirements.
• Extracted Data specific to the client from General Ledgers - 0FIGL C01 and 0FIGL C02 to SAP BI System.
• Statistical Setup for the LO-Cockpit and used the V3 update for Delta Management.
• Managed and Reviewed Projects and Internal Orders using CO-PA Order and Project Accounting
• Prepared annual Forecast and Budget utilizing CO-PA Profitability Analysis and Investment management.
• Worked on Remote Cubes to support real time data. Extracting required data from the Data Source of PSA to ODS
• Wrote Start, expert and end Routines using ABAP code as per the end user requirement.
• Worked on break point of debugging when transferring the data from PSA to Data Target like DSO and Info Cubes.
• Worked on Fox formulas & currency translators and Calling function modules dynamically.
• Variable adjustments & maintain characteristic relations using with the IP.
• Designed SAP BI reports on Fixed Assets for project management aspects and Sponsor and Funder’s perspective as per the business requirement.
• Extracted the data from a database to non-SAP systems using Open Hub Extracts.
• Created BI security authorizations from Info Cubes into user security roles.
• Generated complex reports on cumulative balance in financial general ledger using query designer.
• Designed and developed purchasing analysis detailed queries for spend analysis and payables analysis of finished products on specific time period.
• Developed various comprehensive reports on material groups, invoiced amounts and number of deliveries for Purchasing Analysis and Sales Order, Order Tracking for Sales Analysis.
• Extracted the data from non-SAP Application to SAP BI system through BAPI (Interface).
• Interacted with SAP Basis Team regarding BW Transport requests.
• Created Query Prompts, calculations, Conditions & Filters, Prompt Pages using Report Studio
• Implemented Process Chains to schedule automatic data loads and applied business rules for loading data to Info Cubes and DSOs in BI.
• Created Aggregates, Compressions, Indexes, Multi Cubes and parallel setups to improve the query performance.
• Created detailed web reports for end users using Web Application Designer.

Confidential

SAP BW/BI Consultant

Responsibilities:

• Requirement gathering, design and analysis - Work with users to identify and advise on existing info structures updated by business events in R/3. Identify potential uses and conduct functionality gap-analysis. Identify potential solutions, implement enhancements to existing functionality.
• Worked on Logistics Cockpit and extracted data with V3 updates. The data included Sales Order, Delivery, Shipment, Billing, Purchase, Goods Movement, and Stock Revaluation.
• Created Various Reports in FI GL like fixed-period statement about items not directly related to cash, plan version line items for aggregated or individual posting periods for one or more general ledger accounts.
• Created Multiproviders and InfoSet Queries for Cross-Functional Reporting for FI-AR & Sales, FI-AP and Purchasing.
• Using Bex broadcaster, distributed the customized reports by region and exported to the Enterprise portal.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Developed Function Module to convert Local Currency to Base currency.
• Maintaining Reconciliation’s to verify the data in SAP R3 with SAP BW. Extensively checked the missing values in the BW reports in the R/3 transaction and tables level.
• Created various summarized reports on Cost, Revenue, Service Orders, Stock Usage, Shipp & Bill for Profitability Analysis based on variances of Actual vs Plan data.
• Performed analysis, development and implementation of customized Info Cubes and DSO Objects for HR Head count and Personal Actions.
• Developed customer queries to identify Head count, employee detail report - all, number of personal actions, turnover detail employee report and Attrition reports for HR/HCM Abbott business reporting.
• Scheduled and Automated data loads from R/3 to BI and optimized the load performance by adjusting the pack size, data selections and number of Info Packages.
• Scheduled the Web Templates to make the Info Cubes data Available to the Portal Reports.
• Involved in Training the end users on BEx Queries and customer support to schedule the process chains.
• Transported Objects of cubes from Development to Quality for Testing and Production System during Cut-Over Phase.
• Created Web Templates and Web reports for labor quantities by Partner activity type for all the Cost Centers using WAD.
• Created OSS message for the problems encountered during the realization phase.

Confidential

SAP BI Consultant

Responsibilities:

• Gathered, designed and analyzed - Worked with users and advised them on existing info structures updated by business events in R/3.
• Developed Info Cubes (RSA1) for Inventory Analysis and Service management analysis. The primary cubes were customizations of Material and Slow-moving Inventory.
• Created In and Out Report for Finance Inventory using custom Extractor for Cost of sales for the year. This Report showed all inventory movement in the period.
• Built Custom Extractors for FI Asset Accounting and Tax minute-based extractors.
• Enhanced on New GL Data sources and its associated data Targets.
• Created various Cross Functional Repots for FI-GL and Inventory.
• Created various reconciliation reports to reconcile the ECC, BI and Variances Data in the single report using remote and custom extractors.
• Enhanced to include all texts and key figures, which are missing in the input structure of Info Spoke.
• Extensively rectified/Interacted with all type of data load problems and expertise in the solving the problem.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Developed Function Module to convert Local Currency to Base currency.
• Developed InfoSpokes for Material, Partner Function, Material Sales, End User, Material Unit, Sold-To Party and Material Plant.
• Created Various Virtual Characteristics and Key figures as per the reporting requirements.
• Maintained Reconciliations to verify the data in SAP R3 with SAP BW. Extensively checked the missing values in the BW reports in the R/3 transaction and tables’ level.
• Extensively worked on the Basis (performance, clearing the tRFC’s) and Security (provided the role name to assign to the users, checking the user authorizations and roles) issues.
• Scheduled the Web Templates to make the InfoCubes data Available to the Portal Reports.
• Worked on checking the Authorizations for reporting users, including the authorization objects and authorization values required and proved the suitable information to the Security team.