Anu Ram Email & Phone Number

Glenwood Springs, Co

• System requirements for BW 7.3 upgrade.• Work with BW security team to upgrade to Analysis authorizations. Successful functional testing for Broadcasting, queries, workbook and backend objects. • BW on HANA database migration. Migrating the required DSOs and cubes. • Post migration clean and optimization to save 25% of disc space on new BW 7.3 BW on Hana system.• Created Manager dashboards using Design studio BICS connection. Created executive dashboards with Dashboard designer ( Xcelsius ). • Requirements definition for Backlogs, Open order, FO order by buckets, Delivered quantity, Actual delivery quantity, • Source data and dataflow analysis on BW side. Define enhancements on the ECC side of the LO Cockpit datasources. ( 2lis_11_vascl and 2lis_11_vcscl )• Designed and built EDW datawarehouse for Schedule line, open order and VBFA data. • Consistency issues for Schedule level data from LO extractor. Resolution proposed for a new generic data source. Introduce custom lookups on BW side for data from generic datasource.• Issue with multiple PGI’s identified and resolved. • Custom logic on ECC side for deriving schedule level data from item level data analyzed, proposed and implemented via a ABAP FM call in the extractor enhancement user exit.• Frontend report delivery using BO tools – 4 WEBI Web Intelligence reports using BICS and Explorer infospace delivery via SAP BI mobile app and Explorer app. • Project scope definition and documentation for approval via Sharepoint process• Involved in escalating tickets regarding performance issues and load failures.

Hickory, Nc

• Analyzed and corrected production issues as they occurred in the SAP BW system.• Involved in escalating tickets regarding performance issues and load failures.• Monitored Info Package data loads, analyzed reason for failures and edited Info Packages manually to resolve issues.• Used Process Chains to schedule data loads from SAP SD, MM and HR to BW.• Created and activated ODS, Info Cubes, Info Sets, Multi-Providers, Transformations and DTPs.• Created ODS for incoming sales orders according to sales organization, distribution channels, ship-to-party customers, materials and vendor line items etc.• Uploaded master data and transactional data from SAP SD, MM, and HR via data staging to Data Source, ODS and Info Cubes. • SD – Order, Delivery Billing and Overview; COPA – DataMarting across COPA Cube in EU and US across Sales Orders, Production Costs and Production Order Settlements• Developed Transfer rules, update rules & worked on update routines.• Created Datamarts for DP and SNP APO system loads.• Open hub destinations for billing data to SAAS systems. Custom transforamtiosn for the SAAS customer numbers and product categories.• Created Info packages to load the data and schedule background jobs.• Created Aggregates, Compressed Info Cubes, Updating DB Statistics Regularly and rebuilding missing indexes for increasing the Query Response.

Charlotte, Nc

• Involved in migrating old data model BW 3.5 to new data model BI 7.2.• Involved in the design, development and extraction of the data from R/3 system and flat files in to BW system from SD and MM modules using LO Cockpit extraction methods.• Analyzed the Info Cubes and ODS objects to meet the reporting needs of the client.• Loading of transaction data to the business content Info Cube from Info Sources like 2LIS_11_VASCL, 2LIS_11_VAHDR for sales, 2LIS_13_VDHDR, 2LIS_13_VDITM for billing, 2LIS_12_VCHDR for order.• Experience in the creation of the setup tables for the LO Cockpit extraction.• Created process chains for periodic upload of the master data as well as the transactional data.• Extensively worked on SAP CRM as a source system for generating reports using BEx Query Designer.• Involved in the monitoring data transfers from source systems into BW using PSA.• Developed reports on the MM cubes to check the price variance for materials from different vendors.• Created reports on SD cubes for displaying sales figures and incoming orders.• Experience in creating formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures for developing complex custom reports.• Involved in the creation of the dash boards for sales, purchasing and delivery using Web Application Designer.• Involved in Open Hub Destination to store data from SAP BI to local databases for ad-hoc reporting purpose of ERP users.• Created Info Spokes to retrieve data from BI to Flat File using Open Hub Service Concept• Developed Reports based on Datamart for customer self servicing.

Miami Fl

• Extensively worked on SAP FI-AR, FI-GL, COPA, SCM and generated reports using BEx Analyzer.• Extensively worked on Query building, filtering, free Characteristics, RRI-Jump queries, Restricted Key Figures and variables, Query variants using BEx Analyzer. • Created virtual key figures and calculated key figures to satisfy the reporting requirements.• Designed and developed the open hub service to export the master data to the database tables and also to the 3rd party tools (external Oracle database).• Worked extensively on currency conversion techniques at transfer rules, update rules and query level.• Developed flexible reports using flat files and navigational attributes in BEx analyzer to facilitate the analysis in a drill down mode.• Extensive knowledge of BW extractors from the R/3 system and working knowledge of SAP structures, object dependencies and tables.• Worked on creating aggregates and BI accelerators, applied compression and partitoning techniques to tune the query performance.• Worked on data conversion to combine the Old PCA Data with the New GL data.• Created Reports such as Revenue, OPEX, COGS, COPA to tie the data to the New GL.• Worked extensively on COPA Line Item, COPA Gross Margin and COPA Period vs Period reports.• Lead data architect for the implementation of an initial enterprise-wide financial data warehouse/Basel II datamart. Created the Data & ETL Architecture Reference document and guided RAD sessions between reporting, modeling, mapping and ETL teams. • Worked extensively with FI reports like, Pulling ECC Sets Hierarchies (GS03) into BI (using tcode BW07) for the Income statement reports and balance sheet reports.

Hyderabad Area, India

 Analyzed and corrected production issues as they occurred in the SAP BW system. Involved in escalating tickets regarding performance issues and load failures. Monitored Info Package data loads, analyzed reason for failures and edited Info Packages manually to resolve issues. Used Process Chains to schedule data loads from SAP SD, MM and HR to BW. Created and activated ODS, Info Cubes, InfoSets, Multi-Providers, Transformations and DTPs. Used Error DTPs to fix load errors, correct them and upload them again. Created ODS for incoming sales orders according to sales organization, distribution channels, ship-to-party customers, materials and vendor line items etc. Uploaded master data and transactional data from SAP SD, MM, and HR via data staging to Data Source, ODS and Info Cubes. Created Visio diagrams showing the data flow from ECC to BW for user community. Developed reports using BEx Analyzer and Web Application Designer (WAD). Developed flexible queries using Variables, Filters, Free Characteristics, Conditions and Exceptions in BEx Query Designer to facilitate data analysis. Performed various tuning techniques (aggregates, compression and partitioning) to optimize the query and data load performance. Uploaded Transaction Data from the Flat File as the Source System. Good understanding of FICO and COPA.