Data Sap
Resume:
Monalisa Jena - SAP BI BO Consultant Mobile: +**
Email: ****.************@*****.***
MBA Graduate having 3+ years of experience in SAP BI 7.0, BW 3.5. Involved in Two
support and One Implementation projects as a SAP BI Consultant.
PROFESSIONAL SUMMARY:
• Expertise in designing of BI components like Master data Info Objects, Info cubes,
DSO, Multiprovider, Infoset, DTP, Open Hub Destination, Remodeling, Re-
partitioning, Transformations, Info Package, Data Sources, Communication
Structures, Transfer Rules and Update Rules.
• Involved in maintenance and creation of SAP BW/BI objects as per user
requirements.
• Hands on Experience and Technical Proficiency in Data Extraction, Generic
Extraction.
• Having knowledge on creation of Generic Extractor Data sources using DB tables,
functional module, views.
• Business content objects installation and Transportation of objects across
Landscape.
• Extensive Knowledge on LO Enhancement using different Update modes.
• Having good knowledge in various logistics application like SD, MM, IC.
• Expertise in Data Loading (Initial / Delta Up-Load), Scheduling and Monitoring
Process Chain.
• Extensively worked with Performance tuning techniques based on the BW statistics
– Aggregates, compression, remodeling, indexing .
• Having knowledge on APD (Analysis process and Design) and Real Data
Acquisition model (RDA).
• Expertise in up-gradation and Migration of Objects from BW 3.5 data flow into BI
7.0
• Having Detail knowledge of BEX Components for designing of BEx queries with
Calculated Key figures, Restricted Key figures, Variables, Conditions, Exceptions
and work book creation.
• Having knowledge on SAP Business Objects suite of products like Universe
Designer, Web Intelligence and Crystal Reports, Xcelesius dash board.
• Having Knowledge on ABAP Routines including Start Routine, End Routine,
Expert Routine, Update Routine, Transfer Routine etc.
Technical Skills:
ERP Skills SAP R/3, ECC 6.0
Data Warehousing Skill SAP BW 3.5, SAP BI 7.0, SAP BW 7.3
Reporting Skill BO 3.1, BO 4.0
Programming Language SAP ABAP
Operating System Window Server 2000, XP, Window 7
Educational Details:
MBA from UP Technical University, Greater Noida, NCR With CGPA as 67% .
BSC from Utkal University, Bhubaneswar, Odisha with CGPA as 77%.
XII from CHSE Board, Bhubaneswar, Odisha with CGPA as 70%
X from BSC Board, Bhubaneswar, Odisha with CGPA as 88%
Project1: (Implementation)
Client: Dabur India Duration: October 2013 – Till Date
Dabur India Limited is the fourth largest FMCG Company in India. It is a leading
consumer good company with interest in health care, cosmetics and food industry. It has
implemented centralized SAP ERP system to reach the distributor and stockiest for
capturing secondary sales data.
Developed technical specifications based on the functional specifications to ensure
the correct development of the solution to satisfy the business need.
Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data,
Material Management into BI.
Extensively involved in setting up of procedures for extraction data from SAP r/3
source system by using Generic Extractions & Customizing LO Cockpit. Defining
Extract Structure, Transfer Structure, replicating Data source, Mapping
Transformations, customized Info cube.
Used both initializations with Delta Update and Full Update methods depending on
the business requirement.
Enhanced the LO data sources as per requirements with various update mode .
Installed SAP Standard Business Contents from SAP BW and SAP R/3 Systems.
Involved in creating generic data sources using table and views.
Expertise in configuring and Implementing SAP-BI and creating BI components like
Info Objects, Data Sources, Info Cubes, DSO’s, PSA, Info Objects, Info Areas,
Info Packages and DTPs.
Involved in creating routines such as start routine, end routine, update routine etc to
customize the data as per the user requirements .
Involved in transport management system to transport objects from one environment
to another environment.
Exposure on Data loads on which run daily and weekly basis and various process
chains that are running in BI 7.0 system.
Extensively worked on BO report generation using crystal report and universe
designer.
Involved in daily client meeting to track the project status.
Project2: (Production Support & Maintenance)
Client: Friends Life Duration: April 2012 to June 2013
Friends Life is a provider of pensions, investments and insurance with a heritage of over
200 years. Our key business lines are corporate benefits, individual protection and
retirement income.
Role & Responsibilities:
Worked on tickets based on priority.
Day to day management of Info objects (DSO, Multi providers, Info cubes, Info
objects).
Involved in deletion of PSA, change log table, compression of the cube, deletion of
unused bookmarks, process chain log deletion in order to improve system
performance.
Used open hub to export data from BI to External systems (flat file, table, 3rd party
tool).
Created Info packages and DTP; scheduled them in order to load Master and
Transactional data from SAP R/3 as well as flat file source system into BI.
Monitoring and scheduling the process chain according to the customer requirement
using the transaction SM37.
Designed various bex Reports using bex analyzer based on Formulas, Selections,
Calculated Key Figure and Restricted Key Figure.
Enhancing the existing reports as per the new requirement using bex browser and
Web Application Designer (WAD).
Monitoring Data load activities and recovered failures in Dev, Quality system as a
part of unit testing.
Actively involved for the preparation of process documents.
Project 3: (Production Support)
Client: Origin Energy Duration: May 2011 to March 2012
Origin Energy formed in February 2000, as a result of a demerger from the Australian
conglomerate Boral Limited, in which the energy business was removed from the
building and construction materials business to form the new company.
Roles & Responsibilities:
Scheduling & Monitoring daily, weekly, monthly data loads.
Responsible for handling change request and production tickets.
Involved in Maintaining & Tracking of system generated tickets & customer
generated tickets.
Actively communicated with client for resolving dead locks.
Responsible for reconciliation of data load in sap R/3 and sap BI.
Daily monitoring of Info cubes, DSO object requests and process chain.
Involved in performance tuning like aggregates, compression.
Worked on enhancement of Info cube using remodeling technique.
Analyze the cause of failure of process chain and info package error.
Contact this candidate