SAP BW BI Consultant
Ali & Sons Co LLC
Total years of experience :13 years, 3 Months
Contribution/Roles and Responsibilities:
• Monitoring Daily, Weekly and Monthly data loads by means of Info Packages and
Process Chains and resolving the errors, which occurred during data loading, data
transfer etc.
• Interacting with the onsite coordinator to analyze and resolve the errors which
occurred during data loading and for clarifying the queries regarding the tickets
posted by him.
• Worked on loading of master data and transaction data from SAP R/3 to SAP BW
• Handled tickets with different priority and never missed the SLA
• Interacting with the client during the weekly status meetings.
• Updating the client on the status of the tickets posted by him
• Creating Technical Specifications based on the functional specifications
• Worked extensively on Data ware house workbench (RSA1OLD/RSA!) and customized Info Objects, Info Cubes, DSO, Info package, Info sets and Multiproviders.
• Identify Content extractors from the ECC system and activating in ecc and replicating in BW/BI System
• Installed Business Content activation for objects Info Areas, Info Object Catalogs, Info Objects, DSOs, Info Cubes, and Multi Providers as per the requirement.
• Created Info Packages, Transformations and DTPs to load the data from SAP source system in to SAP BW/BI.
• Worked on creation of Generic Data sources using extraction with Tables.
• Migrating BW content objects like datasources, transfer rules, updates rules from 3.x data flow to 7.x dataflow.
• Involved in Transport of objects over the landscape, releasing request, unlocking objects from other TR and creating packages.
• Created Queries, Customizing the reports by using variables, exceptions, and conditions, restricted and calculated key figures, Formulas, and Conditions In queries.
• Testing & validating as per requirement functionally & technically.
• Conducted End user training.
Additional Contribution:
• Creating user in SAP BW system.
• Creating roles, assigning it to users.
• Moving Transport request in landscape.
• Giving report authorization to users, assigning report to roles.
• Publishing reports on portal, creating portals roles, iViews, worksheets, pages in EP
Project (BI Implementation)
Client : Kenna Metal, USA
Role : Team Member (SAP-BI Consultant.)
Period : Jul’ 2011 to Till date.
Contribution/Roles and Responsibilities:
• Designed, developed and modified Info objects, DSO objects and Info-Cubes.
• Involved in creating technical documents with reference to functional specification.
• Extracted the data from Lo data sources for sales and purchase areas.
• Extensively involved in Design and Creating Processes Chains to automate the
process of loading data into data targets.
• Involved in uploading both Master data and Transaction Data from the source system into the SAP BI.
• Loaded the data from R/3 to BI using Initialization with delta update and full update
methods.
• Involved in Business Content activation for objects like cube, data store objects,
Transactional cubes and MultiProvider etc.
• Involved in validating data consistency in reporting with Data Target against PSA
after loading them to data targets.
• Involved in extracting data from R/3, flat file through transformations, DTP.
• Made changes to existing cubes, ODS, reports as per the business change or the
user requirements.
Project (BI/BW Support):
Client: P&G, USA
Role : Team Member (SAP-BW/BI Consultant)
Period : Oct’2010 to June 2011
Contribution/Roles and Responsibilities:
• Involved in documentation of various objects.
• Self-confident & able to change according the required atmosphere
Involved in monitoring various loads for Process chains and Info packages
• Worked extensively on BEx Analyzer and created queries using Variables, Free
Characteristics, Filters, Exceptions, Conditions, Calculated, and Restricted Key Figures & generated workbooks.
• Worked on Creating Aggregates, Compressions, Indexes, and parallel setups for
Data loading to improve performance and utilize data effectively.
• Monitoring the different loads of master and transaction data from ECC to BW
systemand involved in validating the load failure tickets
• Involved in resolving various tickets related to queries from end-user side
• Involved in escalating high-prioritized tickets regarding extractions, Performance
Issues and also load failures.
• Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or
not after the data loads
• Bachelor of Technology in Computer Science Engineering from Azad College of Engineering and Technology, JNTUH, Andhra Pradesh, India (2006-2010) with 66.00%
• Intermediate - Intermediate Board of Education from St Domnics' Jr College (2004-2006) with 68.8%.
• SSC - Board of Secondary Education from New Model High School, (2003-2004) with 72.0%.