Mohan Krishna Email & Phone Number

Involved in performing production support activities like Ticket Analysis (open/close report, Resource Utilization Report of the support team. Handled the tickets of different severities by following (SOP) star operating procedures and never missed the service level agreement (SLA).Processing all the 1st level Development Support tickets, forwarding those tickets which are beyond the scope.Maintained the work history for all the tickets until it is closed down.Actively involved in Rectification of Load failure Errors like Master Data Loads, Transactional Loads.Involved in Data Integrity Check to verify the data in SAP R/3 and SAP BW are same or not after the data loads.Data loads using Process Chains.Daily Monitoring of Info cubes, Info Objects, and ODS objectInvolved in PSA maintenance.Involved in publishing the process hand book for the support activities.Created Restricted Key figures & used all these key figures in BEx to create a report that looks same as in R/3.Involved in monitoring and production support activities using ZDAILY, ZWEEKLY & RSPCM.

SAP R/3 ECC6 and SAP-BI/BOBusiness Area : SD & MMResponsibilities:Customized Sales Overview (0SD_C03), Purchasing Data (0PUR_C01) as per the client's requirement and enhanced the DataSource and loaded into the data targets.Created Process chains for Master data and Transaction data loads to automate the data loading in the organization and these process chains were scheduled for periodic loads.Configured and extracted Inventory management data from LO Cockpit extractors by making use of the SAP defined DataSource like 2LIS_03_BF, 2LIS_03_BX, 2LIS_03_UM.Development of Transformations, DTP, Data Sources (flat file source system), Update Rules and Transfer rules for BI data flow and 3.x data flow.Creation and maintenance of BI objects (Info Cubes, DSO objects, Infoset, Multi Providers).Scheduling and periodic monitoring of extractions through Info Packages and Process ChainsInvolved in documentation for the mapping, technical specifications, data validations and Test cases.Created Universe, classes and objects by retrieving the data from various data sources and defining the necessary connections.Involved in migration and deployment of the universes and reports across multiple domainsUsed Business Objects Developer Suite (Publisher View, CMC, Designer, and Info View) to perform various tasks specific to every component.Creating standard full client reports and Web I reports. Project #1Title : NOVA CHEMICALS CANADA

SAP BW, SAP-R/3, SAP-BOXI.Responsibilities:Created Info Cubes, Info Sources, update rules, Data Sources and replicated Data Sources.Experienced in Designing of queries, workbooks from Info Cubes.Created Communication structures, transfer structures, transfer rules & update rules for the info cubes and the ODS.Installation of Business Contents objects as per Business Requirements.Involved in extracting data from SAP R/3 using Generic Extraction.Created characteristic and key figure Info Objects from the Standard Content, customer defined and loaded into Info objects, ODS objects, Info Cubes, Created Info Packages, scheduling and monitoring.Transported the developed BW objects to quality and production.Actively involved in monitoring the data transfer from source system into BW.Data uploading from R/3 & non R/3 Systems (Oracle / Flat Files).Support, Optimization and revamping of scheduling and monitoring the system.Problem resolving related to data loading and query performance.Optimization of major cubes with aggregates and compression.Involved in creation of reports using Query Designer such that by using Conditions, Exceptions, Free Characteristics, Restricted Key figures, calculated key figures, user entry Input Variable and formula Variables.Created OLAP universe on top of the OLAP Data Sources (SAP BW Info cube, Queries)Designed Xcelsius Dashboards on QAAWSCreated standard reports using Crystal reports on OLAP Data sources.