S rinu Boddeti Mobile no: +91-960*******
SAP BW/BI CONSULTANT Email:
m *.********@*****.***
Professional Summary:
Have 3.1 years of experience in IT industry in SAP-BW/BI involved in full life cycle
i mplementation projects and Production Support projects for various clients.
Consulting skills:
• Good Knowledge in Data warehouse concepts.
• Good Knowledge on BW/BI Architectures.
• Working and understanding of the accelerated ASAP methodology and Tools.
• Experience in working with Modeling, configuration and customization of BW objects
i ncluding Info Cubes, ODS Objects, Info Objects, PSA, Info Sources, Info Packages,
T ransfer Rules, and Update Rules.
• Expertise on BI 7.0 – Transformations, DTP’s, Write Optimized DSO, Data
Reconciliation in DS, Remodeling on Info cube, and Real-Time Data Acquisition
(RDA).
• Good knowledge in wri ting Routines as per the Client’s requirements.
• Expertise in activation and Enhancement of standard Business Content objects.
• Expertise in OLTP extractions from SAP R/3 using SD, FI and Generic Extractions.
A lso extracted data from the f lat files.
• Expertise in migration of BW-3.x data f low into BI-7.0.
• Excellent Knowledge on LO Extraction using different Update modes.
• Extensive experience in support, automating loads using process chains and use of
B W Monitor to supervise data loading and performance tuning.
• Good in handling performance related issues like Aggregates, Compression,
Parti tioning, Indexes, and Rollup.
• Involved in dist ributing data from an SAP BW system into f lat files to support
external analytical applications using Open hub service.
• Expertise in developing reports in BEx Designer using Fil ters, Calculated Key
F igures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, and
Report to Report Interface (RRI).
• Expertise in setting up of Information Broadcasting to email reports to users and
automated the process by scheduling on periodic basis.
• Have knowledge of reporting using Business Objects.
• Have knowledge of reporting using Crystal Reports.
• Good knowledge on BO administration activities like Creating/Maintaining Users,
Assigning r ights to the users, Creating/Maintaining Profiles and Profile Values,
Scheduling documents to certain recipients, Creating Folders etc.
• Highly motivated individual and a team player with strong organizational,
p resentational and analytical skills. Also very quick learner of any new technology
and concept.
• Have knowledge on Remodeling concept of Info Cube and DSO.
• Have knowledge on Reparti tioning concept of Info Cube and DSO.
Educational Background:
• Master of Computer Applications from Andhra University, Visakhapatnam.
Technical Skills:
• Data Warehousing : SAP BW3.5 and SAP BI 7.0
• ERP : SAP R/3 4.6, SAP Net weaver 2004 and ABAP/4.
• Languages : C, C++.
• Operating Systems : Windows 2003/XP.
• Reporting Tool : Business Explorer.
P rofessional Experience:
• Working as BW/BI consultant for Envision Enterprise Solutions Pvt L td from
J ul’2011 to ti ll date.
Client Engagements:
Project1
Client : Masqati Dairy Products (Hyderabad).
Employer : Envision Enterprise Solutions Pvt L td.
Environment : SAP BI.7.0, SAP R/3 4.6C and Windows XP/2000.
Duration : Sep’12 to ti ll date.
R esponsibilities in Implementation:
• Based on customer requirements prepared business documents and converted to
f unctional specifications.
• Explained the business requirements to end users and proposed technical
requirements to meet the customer requirements.
• Worked on all Landscapes like development, testing, quality & production system
d uring the Implementation.
• Conducted various meeting with business and management team to have a good
hands on the Development f low.
• Ensured to meet the deliverable guide lines within the time frame.
• Worked with different source systems while loading into OLAP System.
• Handled important tasks like t ransportation, developing objects during the
i mplementation.
• Worked on the performance issues with the help of OSS notes.
• Involved in team meetings like Client meeting, In ternal meeting about the status
pending works or for Issue resolution or for business up gradation etc.
Responsibilities in Support Project:
• Performed data volume management in testing & production system.
• Worked on small scale and medium scale projects like enhancements to old project or
new f low.
• Worked on documentation of project which I involved in Small scale or medium scale
p rojects
• Performed monthly activities like selective deletion, PSA deletion, f lushing queues
etc.
• Involved in ABAP related to BI such as wri ting routines and debugging of code
t hrough DTP.
• Involved in every day support, monitoring the production batch, resolving the batch
t ickets etc
• Involved in Top Down approaches while there was any data mismatch or documents
d iscrepancy.
• Communicated with teams like data warehousing, I2 team, DB2 teams, BASIS
Team, SD Team, M M Team etc.
• Involved in data Scheduling, uploading full data and delta data into providers,
Monitoring and error handling.
• Monitored daily jobs and resolved issues without SLA breach.
• Worked on f lushing queues while doing logistics t ransport import precautions .
• Performed Production Outages like handling the production batch, Delta queue
d raining etc.
• Performed posting documents manually by using problem Id, while there was any
d iscrepancy between source system & SAP BW/BI System.
• Worked on all severity tickets in batch t ickets and user t ickets too.
P roject2
Client : JSW (Jaigarh).
Employer : Envision Enterprise Solutions Pvt L td.
Environment : SAP BI 7.0, ECC 6.0, BEx Analyzer and Windows XP/2000.
D uration : Jul’11 to Aug’12
Responsibilities in Implementation:
• Created Requirement Document (RD) from Business Requirement Document
(BRD) with detailed level documentation during Requirement Phase.
• Involved in Requirement gathering, Reviews and User Acceptance Testing.
• Involved in Work Request Plan (WRP) to gather Functional and Technical Specs.
• Expertise in configuring and Implementing SAP-BW and creating BW components
l ike Info
Objects, Data Sources, Transformations, Info Cubes, DSO’s, Mul tiproviders, Info
Packages,
DTPs, Queries, Calculated Key Figures, Restricted Key Figures, Variables, and
S tructures etc.
• Involved in tuning works like creating aggregates, compression, Line I tem
D imension etc.
• Loaded Flat File into SAP-BW system for Monthly financial data and yearly planed
data.
• Created Process Chains by using various process types for Daily loads and on
demand Loads.
• Worked on the performance issues with the help of OSS notes.
• Involved in DVM (data volume management), created process chains to purge the
data and also manually deleted the data.
• Worked on special functions like Open Hub Destinations.
Responsibilities in Support Project:
• Monitoring nightly load process chains and resolved issues during process chain
execution.
• Loaded On demand process chains based up on business user request and monitored
Process chain to get the results without having SLA breach.
• Involved in Disaster Recovery Testing in Disaster Recovery System (DRS).Compared
D isaster
Recovery System with Production System by having test cases.
• Involved in data Scheduling, uploading full data and delta data into providers,
Monitoring
&E r ror handling.
• Performed various tuning techniques (Data Volume Management) like PSA deletion,
Aggregates, Compression etc.
• Evaluated Project wise aggregates for every 6 months and deactivated unnecessary
aggregates and created new ones.
• Efficiently handled the EOM (End of Month) activities for daily loads.
• Resolved various issues according to clock timings and avoided Service Level
A greement
(SLA) breach.
• Extensively involved in data source enhancement in LO extraction. Added data fields
f rom
Table to data source.
• Worked on f lushing queues while doing logistics t ransport import precautions.
• Involved in Transporting Objects during deployment along with BASIS team to
t ransport
objects sequentially during go live period.
• Solved issues manually on production box and created various process types for
automatic
Process in development box and t ransported to quality box.