Surya Anakala

Phone : 732-***-**** Email: adhjil@r.postjobfree.com Linkedin : www.linkedin.com/in/suryaanakala

Over Fifteen Plus YEARS of experience in SAP HANA, SAP DWC, SAP SDA, SAP IRPA, SAP BI/BW, Business Objects, Visual Composer and various SAP technologies. Expert in SAP BW/BI Integration with APO, IP, HR and CRM. Strong Domain Experience in the Areas of Consumer Electronics, Food & Beverages, Life Sciences, TPO, Manufacturing and Blockchain.

SAP HANA:

Experience working on HANA PS 12 to HANA 2.0 SP 3 Upgrade.

Experienced building solutions on Native HANA and BW on HANA.

Experienced building HANA artifacts on tables from multiple systems.

Experience converting any SQL based object on traditional DBs to HANA based SQL objects.

Extensive SQL experience and performance tuning.

Experience building SQL Scripts when required.

Experienced building HANA artifacts on exposed BW objects.

Experienced using SLT from SAP systems.

Experienced working on Smart Data Access using oracle and other databases.

Experienced build hybrid reporting solutions on BW on HANA.

Very strong in data modeling ad performance optimization.

Experience working on Live models.

Time generation in HANA studio, SQL scripts for calculating Time characteristics in HANA views.

Good understanding HANA DB & Analytical security.

Experience and understanding of Analytical Privileges.

Schema mapping in HANA studio for Export and Import transports from different lifecycle systems. Export and Import of HANA views between different lifecycle systems through Developer mode as well as through Delivery unit.

Worked on POC for S/4 HANA Embedded Analytics based on CDS Views for S/4 HANA.

Worked on HANA LIVE Content, HANA LIVE View Browser, HANA Live Extension Assistant

Worked on Cloud analytics, Smart Data access to access non sap and non SQL data base.

SAP BI / BW / BO Expertise:

Worked in four SAP BW/BI full life cycle implementations, as well as upgrades. Analyzed feasibility study for NW 2004s BI for Upgrade.

Worked on Blueprint, Data Modeling, Designing, Documentation, Development to till Go Live and Support

Extensive experience and expertise in SAP BI/BW Extraction, Modeling and Reporting (i.e. Back-end and Front-end). Good at implementing SAP BW and BOBJ with different SAP data source

Expert in SAP BI Business Explorer and SAP BI Web Application Designer. Worked on SAP Business objects including Universe Design, Web Intelligence, Crystal Reports and Excelsius.

Experienced with providing users with access to data by building reports and queries using tools including SAP BW BEx Query Designer/Analyzer, Crystal Reports, Business Objects WebIntelligence, and/or other enterprise reporting tools.

Strong in Configuration of Data targets, Data sources, Info objects, Key figures and Multiproviders

Configured of Transfer Structure, Transfer Rules, Start routines, Transfer routines and Update routines

Construction of Info cubes, ODS, Remote Cubes, Multicube & Configuration of Transfer and Update rules

Strong on End-to-End SAP BW Configurations and Customizations from Extraction

Active participant in transferring and synchronizing projects between ARIS and Solution Manager

Experienced in developing ABAP programs BAPI, EDI, ALE, IDOC, and RFC interfaces.

Serves as liaison between application development team and technical operations staff

Worked with Java scripts and Cascading Style Sheets for redesigning the SAP Design Studio components color and font size as per the client’s design team specifications.

Experienced in html coding for controlling of Components in SAP Design Studio.

Experience in developing Story boards and Info Graphics using SAP Lumira.

BI Integration Expertise:

Strong APO, HR CRM & BW Reporting Experience.

Good in Data Extraction from APO live Cache from DP and SNP planning areas. Familiar with APO 4.1/5.0 systems with its embedded BW 3.5 and BI 7.0 systems.

Good Knowledge in Payroll, Benefits, Personal Administration, Org. Management and Public Sector Management.

Familiar with CRM5.0 systems with its embedded BW3.5 and BI7.0 systems. Good Exposure on Business Partner Relationships, Territory Management and Project Systems. Other Expertise:

Focuses on reuse, granularity, modularity, composability, componentization and interoperability or applications and technologies

Understands and adheres to standards and compliance requirements (both common and industry-specific)

Services identification and categorization, provisioning and delivery, and monitoring and tracking

Demonstrates strong proficiency in both principles and execution of data modeling and solution architecting

Strong Knowledge in Blockchain and SAP integration .

Certification:

Certified in Uipath Advance level

Certified in Automation Anywhere Advance level

Certified in Blockchain from Linux/Hyperledger

Certified in Cybersecurity

Certified in SAP – Hana. SAP -BW, SAP BOBJ

Technical Skills

RPA

Uipath, Automation Anywhere, Blue Prism, SAP-RPA

SAP

SAP HANA,SAP HANA- SDA SAP NetWeaver 2004s BW 7.5 BI7.3 BI 7.1 Ehp1/7, SAP BW (3.5/3.1C/3.0B), Visual Composer, SAP BOBJ/BO (XI 3.1/R2/6.5), SAP ECC (6/5), SAP R/3 (4.7/4.6C/4.6B/4.5B), Portal KM, Solution Manager /ARIS, Design Studio 1.6, Lumira 1.3, Lumira 2.0, SAP Blockchain.

Operating Systems

Sun Solaris, HP-Unix, Win NT 4.0, Windows 95/98/2k/XP

RDBMS

Oracle 9/8.x, MS SQL Server 2000, MS Access

Tools & Utilities

ABAP/4, SQL, JAVA, IDOC, RFC’s, Informatica / Cogno

Professional Experience

Houston ISD SAP BW Architect Aug’2019 – Till Date

Involved in preparing the BW environment for Pre & Post Migration steps to HANA.

Migrating exiting info providers to HANA optimized providers.

Worked on building new BW objects that are optimized for HANA.

Optimization of transformations for HANA.

Design and development of HANA views for reporting based existing Oracle GIC reports.

Pre and post migration testing.

Responsible for analyzing the GIS Data mart and replicating DOI (Division of interest) related reporting.

Used SQL extensively for testing the data and comparing between Oracle and HANA tables.

Responsible for analyzing existing SQL & PL/SQL Stored procedures and ABAP programs related to exiting GIC data mart to replicate the logic in BW.

Used Calculation Engine functions for some of the reports for improving performance.

Created procedures to replicate the GIC database procedures.

Responsible for creating generic extractors

Worked on implementing ETL for Production Revenue Accounting.

Worked on design and development of DOI (Division of Interest) module related extractors and reporting objects.

Building HANA optimized data models to replace ORA reporting in Oracle to HANA and BW.

Development of extractor related to DOI and check write process.

Optimization of query reporting for HANA.

Optimization of tables for performance in HANA studio.

Implemented the BW workspace in 7.5 the Planning modeling for updating to the BW system.

Implementing planning and forecast IP PAK. Using manual planning and planning functions with fox formulas. The planning reports are delivered using Design Studio and Analysis for Office tool.

Supporting users and their requirements in functional areas like Order to Cash, Procurement, Inventory and Production planning.

Planned and executed in all aspects of the upgrade from the initial cost and effort estimation to testing and Go Live.

Involved and executed the following phases of the project like System and Resource availability and planning, verify all SAP prerequisite notes, landscape validation, pre-upgrade tasks, technical upgrade tasks and post upgrade validation.

Complete re-designing of the existing landscape using composite providers and Advanced DSO’s. Converted existing cubes and infoproviders into adso’s and used them in composite providers.

Extensive usage of BWMT eclipse for the creation of reports and data models.

LyondellBasell SAP BW Support lead Aug’2018 – Jul’2019 date

Environment: SAP BW 7.5, SAP Bex,Hana, BOBJ,Power BI

Responsibilities:

Responsible for replacing part of oracle based data models in HANA.

Hybrid approach in data acquisition and exposing of models in HANA.

Responsible for extracting data from SRM and building HANA artifacts on the base tables in HANA.

Experience deploying RDS/embedded analytics for COPA as part of HANA Live.

Customization of the Models in HANA Live for NOVA.

Responsible for establishing the best practices in a mixed scenario.

Responsible for establishing best practices of building models over HANA.

Involved in analysis and replacement of existing ETL on Informatica.

Optimization and rationalization of BW models to replace existing Oracle reporting community.

Transformation of existing Business layer logic from Oracle functions to HANA Functions and Models.

Move the source of critical Business reports from Oracle based Universes to HANA based universes.

Migrating exiting info providers to HANA optimized providers.

Creation of SQL based and graphical Calculation views to replace part of ETL look-ups.

Extend/Customize the HANA Live content by modifying the Calculation views and adding new tables and new fields

Power BI Desktop to create dashboard /Reports and launched in SharePoint

MDX Blocks/Core blocks SAP Hana /Blockchain Integration Lead Jul’2018 – Jan2020

Environment: SAP Hana, SAP Blockchain, SAP IRPA. SAP Webi, Design Studio, Lumira, Cisco Data hub, Cloud analytics.

Responsibilities:

Involved in understand the requirements of Stake holder and business.

Developed Mapping document between SAP to HANA, Legacy to HANA. Hana to Blockchain

Developed Calculation views on top SAP and Non-SAP system by using smart data access.

Created Json script to extract blockchain information from mongo DB and created Mapping document to integrate with Hana views.

Created flow of data into DATA HUB which is built in Azure cloud.

Written Conditional SQL scripts for data access and send it to cloud.

Created cloud analytics and dashboard for business and stake holders.

Involved in Cloud security and designing data level access depending on business roles.

Houston ISD SAP BW Technical Lead Mar’2016 – Jul2018

Environment: SAP 4.7, 4.6C, BW 7.5,, ABAP/4, Oracle 8.0, UNIX, Bex Analyzer, SD, MM, FI, CO-PA, Design Studio 1.6, Lumira 1.3, Lumira 2.0.

Responsibilities:

Analyzed, designed and implemented OLAP cubes and reports in SD, MM and FI/CO modules based on end-user requirements.

Designed, developed and implemented Info Sources for BW.

Responsible for Sales and Distribution, Purchasing, Inventory Management, FI and CO InfoCubes.

Extraction for LIS, LO Cockpit, SD, FI-GL, FI-SL and CO-PA modules.

Used BW Content extractors to extract data from SAP R/3 to BW. Generic R/3 Data Extraction.

Created/Modified Info-Sources for Master Data (Attribute and text) and Transaction Data.

Modified the user exits to populate the custom fields added to the Datasources. V3 Updates, controlled by pull/push principle from OLAP system.

Created/Modified and activated Transfer Rules and maintained Communication

Structures.

Created and Scheduled Info-Packages for Delta Initialization and Delta data loading.

Set the Update Rules for InfoCube and uploaded data into the InfoCube.

Developed ODS object to load transaction data from Infosources and defined update rules.

Loaded transaction data into PSA, updated data to ODS from PSA and activated ODS for reporting.

Created Info-Packages group to schedule Info-Packages to load master data.

Developed reports in Bex Analyzer/Web Application Designer. Used enhancement-RSR00001 for user Exits for Bex Reporting.

Developed custom Bex Queries against the InfoCubes and ODS objects using Bex Analyzer.

Extensively used calculated and restricted Key Figures. Created variables for the queries.

Created Drill through Queries from summarized InfoCube report to detail ODS data.

Published reports on the Web using BW Templates.

Trained Power users on utilizing, developing and administering BW Queries.

HANA View POC for PBF of Public sector.

Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.

Created Functional document specification and Design requirement specification for the reporting requirement.

Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).

Developed dashboards in Design studio connecting to SAP HANA views and BEx queries directly. Had to develop Universe in situations where Ranking was not a possibility in Design Studio.

Linked the WebI reports to Design Studio dashboards and managed passing the parameters from Design Studio to WebI report prompts.

Created Dash board using Design studio 1.6, and upgraded Lumira dash board from 1.3 to Designer 2.0

I was extensively involved in user trainings and created HOW TO documents for end users. I was involved in setting End user support system.

Statoil USA SAP BW/PRA/BO Consultant July2015 – Feb’2016

Environment: SAP BW 7.3, SAP Bex and SAP PRA, Jib link,Hana, BOBJ

Responsibilities:

Analyzed, designed and implemented OLAP cubes and reports in PRA and Jiblink modules based on end-user requirements.

Designed, developed and implemented Info Sources for BW.

Used BW Content extractors to extract data from SAP R/3 to BW. Generic R/3 Data Extraction.

Created/Modified Info-Sources for Master Data (Attribute and text) and Transaction Data.

Modified the user exits to populate the custom fields added to the Datasources. V3 Updates, controlled by pull/push principle from OLAP system.

Created/Modified and activated Transfer Rules and maintained Communication

Structures.

Created and Scheduled Info-Packages for Delta Initialization and Delta data loading.

Set the Update Rules for InfoCube and uploaded data into the InfoCube.

Developed ODS object to load transaction data from Infosources and defined update rules.

Loaded transaction data into PSA, updated data to ODS from PSA and activated ODS for reporting.

Created Info-Packages group to schedule Info-Packages to load master data.

Developed reports in Bex Analyzer/Web Application Designer. Used enhancement-RSR00001 for user Exits for Bex Reporting.

Developed custom Bex Queries against the InfoCubes and ODS objects using Bex Analyzer.

Extensively used calculated and restricted Key Figures. Created variables for the queries.

Created Drill through Queries from summarized InfoCube report to detail ODS data.

Published reports on the Web using BW Templates.

Trained Power users on utilizing, developing and administering BW Queries.

Created reports on Business Objects Analytic office and Design studio.

Involved in BI 7.0 implementation and extensively worked to deliver BI reports on Plant Maintenance module

Attended workshops to gather business requirements from the process team, Based on the Report Functional Documents created Data Flow Functional Documents and Diagrams for whole backend and frontend requirements.

Replicating HANA DD02L(table names), DD02T(tables description),DD08L(table relations) Initial tables into HANA from ECC

Created HANA Attribute, Analytic, Projection & calculated views based on the requirement

Worked with Projection & Aggregation node in HANA Calculation views

Worked with Copy & Derived options while creation HANA objects

Worked with Start Routine, End Routine, Expert Routine, Multiple Update Groups And also Temporary storage of standard DTP.

Involved in performance Tuning aspects like Aggregation, Compression, partitioning, OLAP cache, indices, Line item dimension, Read mode of query, Repair of objects in RSRV to check the consistency in the entire Schema.

Used standard content Data sources 2LIS_03_BX, 2LIS_03_BF and 2LIS_03_UM to load data to the Inventory data.

Implemented custom data warehouse layer with Data store, info providers and multi provider based on reporting requirements.

Utilized new BI 7.0 transformations and DTPs for all new developments.

Developed numerous custom data sources using database views and custom function modules.

Developed process chains to automate the initialization and delta updating of all data.

Published iView’s to the Enterprise Portal to be used by external business partners to access BI data.

Created over BEX queries and assigned them to roles by department.

Created Hierarchies on calculation Views in Hana like profit center, cost center.

Created Webi reports and Crystal report on top of Hana views.

I was extensively involved in user trainings, and helping user understand how PRA Dashboard works

Rush Enterprises, New Braunfels SAP BW/BO Consultant April2015 – June2015

Environment: SAP 4.7, 4.6C, BW 7.4,, ABAP/4, Oracle 8.0, UNIX, Bex Analyzer, SD, MM, FI, CO-PA, Lumira

Responsibilities:

Analyzed, designed and implemented OLAP cubes and reports in SD, MM and FI/CO modules based on end-user requirements.

Designed, developed and implemented Info Sources for BW.

Responsible for Sales and Distribution, Purchasing, Inventory Management, FI and CO InfoCubes.

Extraction for LIS, LO Cockpit, SD, FI-GL, FI-SL and CO-PA modules.

Used BW Content extractors to extract data from SAP R/3 to BW. Generic R/3 Data Extraction.

Created/Modified Info-Sources for Master Data (Attribute and text) and Transaction Data.

Modified the user exits to populate the custom fields added to the Datasources. V3 Updates, controlled by pull/push principle from OLAP system.

Created/Modified and activated Transfer Rules and maintained Communication

Structures.

Created and Scheduled Info-Packages for Delta Initialization and Delta data loading.

Set the Update Rules for InfoCube and uploaded data into the InfoCube.

Developed ODS object to load transaction data from Infosources and defined update rules.

Loaded transaction data into PSA, updated data to ODS from PSA and activated ODS for reporting.

Created Info-Packages group to schedule Info-Packages to load master data.

Developed reports in Bex Analyzer/Web Application Designer. Used enhancement-RSR00001 for user Exits for Bex Reporting.

Developed custom Bex Queries against the InfoCubes and ODS objects using Bex Analyzer.

Extensively used calculated and restricted Key Figures. Created variables for the queries.

Created Drill through Queries from summarized InfoCube report to detail ODS data.

Published reports on the Web using BW Templates.

Trained Power users on utilizing, developing and administering BW Queries.

Responsible in optimizing the data load process to minimize load time and fix the causes of load failures.

Used reusable structures, exceptions, variables, filters, restricted and calculated Key figures for reporting.

Creation of BO universes in IDT on top of HANA calculation views.

Creation of WEBI reports on top of BO universes.

Testing the data in the models end to end and support the business users with any questions.

Built Process Chains to run data validation before loading Excel files and to load delta load for R/3 data.

Created Initialization Procedures for extraction of Logistics data from R/3 to SAP Business Warehouse.

Configured the Extract structure, V3 schedules and Delta Management of standard Logistics Extractors – Sales, Purchasing, Inventory.

Developed complex transformation in BW using expert routine for data loading.

Worked extensively in ABAP programming for start routines, end routines, User exit variables and Data Source enhancements using function modules as well as BADI’s. Worked on performance tuning of Data loads etc.

Created Dash board using Design studio 1.6, Lumira 1.3

I was extensively involved in user trainings. Help users to understand OTC and OTD cockpits and trained them to understand order life cycle management.

Anadarko Petrolium, Houston TX SAP BW/BI- HR Oct 2014 – March2015

Environment: SAP Net weaver 2004s BI 7.4, SAP ECC6.0 (EHSM),Spot fire,Crystal reports Tableau 9.2

Responsibilities:

Played key role in building data for EHSM solution, and Contracting employee information, and T_Code usage auditing report

Involved in extracting data from 6 different source systems for EHSM Investigation

Configured FILE t-code to store the file in Application server through APD’s for Work order summary report which built in Spot Fire

Worked on Upgrade from SAP BI 7.1 to SAP BW 7.4.

Worked in Support team for fixing reports which were built earlier .

Worked in Creating Crystal Reports for EHSM and SAP Usage audit report.

Working Business Objects upgrade project for SAP BO 4.1.

Created a Dashboard on Rig Safety by using HSM module using Tableau.

Trained users in using dashboard and know about accident ratio at rigs

Implementing planning and forecast IP PAK. Using manual planning and planning functions with fox formulas. The planning reports are delivered using Design Studio and Analysis for Office tool.

Supporting users and their requirements in functional areas like Order to Cash, Procurement, Inventory and Production planning.

Planned and executed in all aspects of the upgrade from the initial cost and effort estimation to testing and Go Live.

Involved and executed the following phases of the project like System and Resource availability and planning, verify all SAP prerequisite notes, landscape validation, pre-upgrade tasks, technical upgrade tasks and post upgrade validation.

Complete re-designing of the existing landscape using composite providers and Advanced DSO’s. Converted existing cubes and infoproviders into adso’s and used them in composite providers.

Extensive usage of BWMT eclipse for the creation of reports and data models.

Installed BC - Sales and Trade Promotions (Planned + Actual) in SU (0CP_SLSCA) and Promotion Knowledge Base (0CP_SLSC8)

Customized planning areas CP: Sales and Promotions Plan/Actual (4TPM8000) and CP: Sales Planning with Promotions (VM) (4TPM9000)

Dairy Farmers of America, Kansas City, MO SAP BW/BO/HANA Consultant March2014 – Oct’2014

Environment: SAP Net weaver 2004s BI 7.3,SAP BOBJ 4.0 (WEBI/OLAP/Crystal Reports) SAP HANA.

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.

• Designed, developed and managed Universes in Business Objects Designer for generating the pay roll reports for sales, marketing reports for marketing group users.

• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.

• Created Universes by defining connections and retrieving data from database.

• Creation of reports like Residential and Business Customers reports, Service charge validation Reports, Monthly paper bill Reports

• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.

• Created New Classes and User Objects in designing the universes.

• Generated various reports on Daily, Weekly, Monthly and Yearly basis.

• Created and modified the Crystal Reports for various financial groups using the Universe as a main data provider.

• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs. Some of these reports are extremely complicated and retrieve data from multiple data sources

• Created Charts to display summary data using universe as main data provider.

• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.

• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.

• Defined Aliases and Contexts to resolve loops in the universes.

• Created User Conditions and Filters to improve report generation & readability of report and displayed the summary of data by creating Charts.

• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.

• Extensively used Calculations, Variables, Break Points, Drill, and Slice and Dice for generating reports.

• Involved in creating various reports by extracting data from Data Marts

• Created reports using Oracle Databases and Personal Data File Providers.

• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.

• Involved in Architecting the entire BI-HANA solution with mixed approach data Flow design involving SAP ECC and other legacy systems as source systems and using BW powered by HANA as Enterprise Data warehousing application by utilizing existing extractors to load transactional data into DSO objects to formulate Analytical views, Attribute views and Calculation views (Using HANA Studio/Modeler Perspective) exposed to frontend layer implemented with SAP BO.

• Configuring SLT for CO-PA tables (CE1-CE4) to enable faster and real time reports.

Working knowledge in LT replication server configuration and Functional usage of SLT.

Involved in migrating existing standard Info Cubes, DSO’s and SPO’s to HANA-Optimized Info Cubes, DSO’s and SPO’s respectively.

• In order to improve the performance of data processing by creating complex SQL procedures in HANA and triggered the same from ABAP Programs.

• Involved in consuming HANA models in BW by publishing them as Transient providers.

• Exporting and Importing of HANA models using Transport Connection mechanism.

• Extensively involved in creating TD’s and Build.

• Experience in adding the system, configuration files, and Monitoring logs. Index server, CPU and Memory utilization, Host, Port and other HANA Services.

• Involved in HANA Administration. (i.e. stop and start server, upgrading the HANA to latest version includes HANA DB).

SASOL, Houston TX SAP BW/BI- HR July 2013 – March2014

Environment: SAP Net weaver 2004s BI 7.3, SAP ECC6.0 (HR),

Responsibilities:

Played key role in building data for Success Factors- Head count and Position Data.

Involved in extracting data from 3 different source systems for 0HR_PA_0 ( employee)

0HR_PA_1 (Personnel Actions) and 0HR_PA_OS_1 (Staffing Assignments).

Configured FILE t-code to store the file in Application server through APD’s for Success factor reporting purpose.

Created Staff establishment cubes and reports for Planning Purpose.

Maintained Global Organization Hierarchy in BW for cross client environment.

Loaded flattened Hierarchies in to Master data objects for Org unit and HR position.

Identified issues with Functional process in HR.

Involved in Creating Head Count and FTE reporting and SE Planning reports.

Haliburton, Houston TX SAP BW/BI- BOBJ Consultant May 2011 – June’2013

Environment: SAP Net weaver 2004s BI 7.1, SAP ECC6.0, SAP BOBJ 4.0 ( WEBI/OLAP/ Crystal Reports).

Responsibilities:

Played key role in Battle Red Project, in developing SALES Solution, Value management Solution and Vendavo Pricing solution in BW side.

Lead and contribute to delivery Sales – Contract Consumption Report which is a life Cycle of Master Contract to Invoice which includes Credit and Debit Memos.

Played a key role in developing Time entry Report solution by using CATSDB table.

Involved activating the standard delivered business content of Benefits and

Benefits Area- 0HR_PA_BN_1, and created various workbooks based on Cost and

Participation.

Involved in developing Working Capital Report solution using FI_AP extractor and built a

Custom extractor on BOFK_A for getting Profit Center details for AP Documents.

Involved in developing ZARP Report solution using FI_AR extractor and built a

Custom extractor on BOFD_A for getting Profit Center details for AR Documents after PC balancing is done.

Played a key role in OFF Shore and ON Shore Co-Ordination.

Involved in Designing the solution for Pricing team using A – Tables and Invoice Pricing Condition extractor to replicate similar report that was in Vendavo.

Involved in Building the report solution using Document flow (VBFA) Solution

Involved in enhancing the 2LIS extractors using LBWE and CMOD.

Active participant in at least one full-cycle implementation of SAP BW and BOBJ (from project planning to go-live and post go-live support)

Worked with Business Objects WebI,OLAP.

Played Key role in building Head count actions cube using 0HR_PA_0( Employee source)

Involved in building Personalization cube using 0HR_PA_1

Involved in Building Overtime Report (Cluster B2) cube using 0HR_PT_2 (Actual Personnel

Times)

Played key role in designing, creating and maintaining custom Info Objects, Info Cubes, ODS/DSO, Transformations, Data Sources, Info Sources, Transfer and Communication structures, Multi providers, Remote cubes, Applying filtering conditions, Aggregates, Info Set Queries, Initial, Delta, Full uploading methods, Info Package groups, Process Chains and Job monitoring using ControlM.

Designed Front-end Queries using RRI and BW components like Calculate & restricted key figures, Structures, Variables, Exceptions and Conditions, Workbooks using Bex Analyzer, Bex Browser, and Web Application Designer (WAD).

Played key role to code in ABAP for developing User defined Variable User Exit and Business content data source enhancement user exit.

Worked in Data Conversion & data uploads from legacy system to SAP system using RFC

and DB Connect.

Developed Crystal Reports using sources such as

Sql Server 2008

Universe

SAP BW Queries

SAP ECC Tables

Designed and developed multiple BEx queries which act as the source for Crystal reports.

Developed Crystal reports with SAP BW as Data Source.

Gerdau AmeriSteel, Tampa FL SAP BW/BI/IP- BOBJ VC Consultant May 2008 – April 2011

Environment: SAP Netweaver 2004s BI 7.1 Ehp1/7, IP,SAP BOBJ/

Contact this candidate