EXPERIENCE SUMMARY

• 9.9 Years of rich experience in information technology which involves various implementations,development and support of business applications in SAP BW/BI and BO.
• Experienced in the design, development and configuration of BW projects.
• Experienced in Business Intelligence Data Integration, Modeling, Extractions, and Reporting.
• Experienced in Full life cycle implementations of Data warehouse (BI) projects.
• Hands - on support of BW including areas of Application Maintenance and Performance Tuning.
• Experience in working with various versions of SAP and BW the latest being ECC 6.0 and 7.0 respectively.
• Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying Extended Star Schema modelling principles in Data Design, and used expert knowledge of data warehousing concepts.
• Worked on Data Loads, Reporting related issues and Performance issues, designing the Info cubes, ODS Objects, Info Sources, Info Objects, Transfer Rules, Update Rules, Data Sources, Queries, Variables, User Exits, Process Chains and Data Extraction from different Source Systems.
• Expertise in building the Universes Designer, developing the reports usingBusiness Objects - WebI, Dashboard designer and Crystal reports.
• Highly proficient experience in SAP Business Intelligence, HANA, BODS and Business Objects, this includes good exposure to Implementation, Development and Support.
• Strong knowledge on SAP BI Modelling, Extraction and reporting which includes BEx suite and BO Reporting Tools.
• Expert in building HANA Enterprise and BW on HANA Landscape from Data Provisioning to Reporting.
• Strong work experience on integrating HANA Enterprise, SAP BW on HANA and BOBI tools.
• Proficient in loading data from different sources to HANA using SAP Data Services with good exposure to all the transformation available, repository creations and scheduling the jobs in Management Console.
• Excellent knowledge in gathering business requirements, analyzing the business process, Implementation, Designing, Configuration, Customization, Unit/Integration testing, Go-live and Post-go-live support.
• Leading offshore HANA team at client location which is responsible for providing HANA Solutions globally.
• Extensively worked on query development and formatting techniques in both BEx and Web Application Designer (WAD) of key BW reports and created Web Templates. Designed Info Sources, activated Pre/Post transformation rules, scripted extraction routines for master data, texts and hierarchies.
• Experienced in implementing BI-SD, BI-MM, BI-FI and BI-CO.
• Experienced in Creation of Routines (SAP ABAP) in Various Update Rules, Transfer Rules and Transformation to meet the business requirements.

TECHNICAL SKILLS

Environments: SAP BI/BW 7.0, 7.3, 7.4 SAP B04.0, BEx 3.5, SAP HANA 7.0 Office Analysis, ECC 6.0, 7.0 Net weaver

Programming Languages: HTML and SQL

Database: Oracle, SQL Server, (OLTP & OLAP), HANA.

Operating Systems: Windows Server 2003, 2008.Unix&Linux.

PROFESSIONAL EXPERIENCE

Confidential, IL

SAP BI/ BO Consultant

Environment: SAP BW 7.3, 7.4,on HANA NW Versions

Responsibilities:

• Worked for troubleshooting based on data load failure by viewing the Process monitor.
• Involved in short dump analysis and analyzed the short dumps to resolve the issues.
• Monitoring the data loads daily, weekly and monthly as per the business check list.
• Involved in creating event triggered process chains.
• Handling the tickets of various priorities posted by the user following and confining to the SLAs by maintaining work history until they are resolved.
• Involved in data validation and reconciliation activities to check consistency of data between BW and R/3 source systems.
• Worked for data load and performance tuning activities like Aggregates, Compression, indices, Multiproviders and statistics.
• Enhanced CO Data sources as per the business requirements
• Creating and maintaining the technical documents for all the support activities.
• Co-ordination with onsite team for various project related issues.
• Worked on reloading activities to extract data from R/3 to BI as per the client’s requirement.
• Maintaining the daily and weekly data load status
• Load master and transactional data through RFC & Flat Files.
• Configration of standard dash boards and score cards as per the requirement.
• Performed data consistency check after loading data into staging layers.
• Partispated on weekely status calls with the client.
• Schedule the Process chain based on Ultimo and Monitoring of data loads.
• Monitor the tickets based on the priority worked on tickets and update the ticket status to onsite team.
• Worked on data loading issues and report related issues
• Expertise in Bex-Involved in creation of reports using Conditions, Restricted Key figures and Customer exit variables
• Business requirement gathering from the business users, analysis and design.
• Created and maintain the users, assigned the appropriate roles to the users
• Worked on Unicode conversion.
• Worked on building HANA Enterprise and BW on HANA Landscape from Data Provisioning to Reporting.
• Worked on integrating HANA Enterprise, SAP BW on HANA and BOBI tools.
• Loading data from different sources to HANA using SAP Data Services with good exposure to all the transformation available, repository creations and scheduling the jobs in Management Console.
• Excellent knowledge in gathering business requirements, analyzing the business process, Implementation, Designing, Configuration, Customization, Unit/Integration testing, Go-live and Post-go-live support.

Confidential, Lexington, KY

SAP BW Consultant

Environment: ECC 6.0, SAP BW 7.3, on HANA Cloud NW Version

Responsibilities:

• Identified and Installed the Business content data sources, info sources, ODS Objects and info providers
• Extracting data from R/3 to BW using LO, Generic& Flat File extraction.
• Worked with Business content extractors for General Ledger, Account Payables & Account Receivables to extract data from SAP R/3.
• Worked with Business content extractors for General Ledger, Account Payables & Account Receivables to extract data from SAP R/3.
• Creation of Routines in Transformation to meet the business requirements.
• Creation of Info cubes, ODS, Multi Providers and Info sets.
• Analyze the data model/data mart to design the universes for OLAP and Relational DBs.
• Involved in data warehousing to achieve optimum user requirements and created structure of different universes.
• Resolved the loops and tested the designed universes on relational database in Business Objects designer.
• Used drill-down analysis in Business Objects, which will allow the user to view data at a more detail level and from different angle.
• Developed the Revenue (Premiums), Expense (Claim Payments) and Profitability reports with multiple data providers in Business Objects.
• Extensively worked with formatting the reports according to the user requirements.
• Created reports using WebI and Dashboard design embracing best features available.
• Involved in Performance tuning of report execution in business objects.
• Designed and linked the universes for query reporting and analysis using designer module. Import and export business object’s reports and universes to repository.Used the web intelligence console to monitor the scheduled reports in Broad cast agent.
• Creation of new Reports using Restricted Key figures and Calculated Key figures. Query
• Changes and creation of workbooks as per User Requirements
• Expertise in Creating Process Chain
• Involved in Creating iViews and Worksets in SAP Portal.
• Involved in Activities like process chain monitoring, Production Support and new developements.

Confidential

SAP BW/ABAP Consultant

Environment: ECC 6.0, SAP BW 7.3 versions

Responsibilities:

• Involved in Activities like process chain monitoring, Production Support and new developements.
• Involved in gathering of requirements
• Extensively worked on Early Watch Report.
• Validated data consistency in reports with PSA after loading them to data targets.
• BEx Reports providing insight of Business Intelligence for Business Analyst for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value, Replacement Path, Customer Exit and Authorization Variables.
• Involved in designing, developing Info Cubes & DSO’s
• Creation of info sets and MultiProviders
• Maintained user authrozations to restrict data for end users.
• Daily, Weekely Monthly monitoring the process chains.
• Process Chain Maintenance for master data and transaction data loads.
• Monitoring of loads and analyzing the reasons for frequent failures.
• Expertise in loading huge amount of data within low time.
• Created House Keeping Activities Separately for various flows of Master Data and Transactional data based on the parameters.
• Created and maintained Users
• Created and Maintained Analysis Authorizations
• Assigned User Authorizations and user Roles to Users.
• Implemented Process chain Alerts for Failed processors.
• Created bucket reports based on requirement.
• Resolved Performance issues..

Confidential

SAP BW/ABAP Consultant

Environment: ECC 6.0, SAP BW 7.3 versions

Responsibilities:

• Implemented SD & MM Modules developed ETL Flows.
• Involved in designing in reports
• Involved in solving Data loading Performance issues and issues raised by the testing team during the testing phase.
• Worked extensively on LO Cockpit Extractions. Loaded the data from r/3 to BW and used Initialization with delta updates and full updated methods.
• Involved with performance tuning of Queries by maintaining Aggregates, Compression, partition and Indexing of Info cubes.
• Installed SAP Standard Business Contents from SAP BW and SAP R/3 Systems.
• Hands on experience in creating and automating processes with Process chains, Master data Info packages and back ground jobs etc.
• Involved in query properties for improving the query performance.
• Creating queries on Ageing Buckets reports.
• Expertise in transporting objects from Dev to Production across Landscapes
• Worked extensively on BEx Analyzer and created queries using BW-Reporting Variables, Navigational attributes, Exceptions, Conditions in queries to facilitate Data analysis in a drill down or summarized way to give detailed levels of information.
• Maintained reconciliations of the reports and verified the data in SAP R/3 and SAP BW for the data loads.
• Involved in Unit testing, i.e. to monitor the data whether it loaded correctly or not, checking the PSA, tables etc.
• Customization of reports as per Client's change requirements

Confidential

SAP BW Consultant

Environment: SAP BI/BW 7.0/BEx 3.5 NW Version

Responsibilities:

• Extensively involved in Production Support by loading Daily loads/Weekly loads into the BW system from different source systems.
• Created info Cubes, DSO, Transformations and DTP for Data Loading through Process chain from Source System.
• Involved in BWA index activities on Data loading and Query performance.
• Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
• Created and worked on daily basis with LO-Cockpit, Generic Data Source, Info Source, Transfer Rules, Update Rules & Info Package.
• Designed Info Sources, activated Pre/Post transformation rules, scripted extraction routines for master data, texts and hierarchies.
• Setup procedure for extracting R/3 data for Customers, Sales Order, Delivery in Sales and Distribution (SD) using LO-Cockpit.
• Generated the Data Source from SAP R/3 using LO-Cockpit.
• Installed Business Content Info Cubes, Info Sources from BW Side.
• Activated Data Sources in SAP R/3 using T-code RSA5.
• Maintained Info Cube, Update Rules and Creation of Info Package and scheduling the data into the Data Targets.
• Involved in Info Cube maintenance i.e. Compression, Aggregates and Roll-up.
• Handled the tickets of priority 1, 2 and 3.
• Maintain list of all the activities for all the tickets until it is closed down.
• Actively and regularly involved in Load Monitoring of Daily, weekly and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Maintaining the queue - related to the system generated tickets and customer generated tickets.