Professional Summary

• Sr. SAP BI/BO consultant having over 8 years of professional experience which includes over 7 years of SAP BI/BW experience, 2 years of SAP BO experience and 1 year of SAP ABAP experience.
• Experienced in Pharmaceuticals, Automotive, Financial Services, Retailing, Food processing, Manufacturing, Energy, Technology, Oil and gas Industries.
• Having very good technical skills, functional knowledge of SAP ECC application areas like SD, MM, and FICO and Planning Tools: BPS, IP.
• Experience using BWA (Business Warehouse Accelerator) extensively.
• Involved in 3 full cycle implementations, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Delivered optimized solutions which helped in reducing the processing time and thus improving the efficiency of the Business Process.
• Handled End User and Corporate Trainings for SAP BW 3.5/BI 7.0/BI 7.3.
• Excellent communication skills and Won Appreciation from the clients worked.
• Subject Matter Expert to explain technical terms, single point of contact to provide solution to clients operating with a strong sense of urgency.
• Ability to work under pressure with cross-functional, cross-geographic and cross- cultural teams. Exceptional ability to quickly master new concepts and technologies.

SAP BI 7.0 Expertise

• Worked with the creation of Info Objects, Data sources, Transformations, Data Transfer Process, Info cubes and Data Store Objects.
• Worked with Process Chains to monitor the data loads and ensure quality data.
• Worked with all the DTP processes to extract the data from the PSA.
• Worked on Error Handling procedure.
• Proficient in OLTP extractions of SAP LO-Cockpit, SD, FI, MM, APO, generic extraction, flat files & using DB Connect for legacy data.
• Implemented the data extraction process on BI 7.0 that includes installation of the Business content, creating data transfer processes (DTP) using the graphical UI provided by new BI 7.0 features.
• Developed Start routines, End routines and Expert Routines using ABAP to incorporate Business logic and perform data manipulation.
• Using BEx Query Designer to define complex queries, defining Exceptions, Conditions which are later deployed in variety of scenarios like Excel workbooks and web applications.
• Expertise with BI reporting for Data Analysis with BEx Analyzer, Web Application Designer (WAD) and implementing BEx Queries, Variables and Workbooks.
• Migration requirements related to BEx Query Designer, BEx Analyzer and BEx Web Application Designer.
• Knowledge in creating Multi providers and Info sets.
• Experience in Performance Tuning using Aggregates, Rollup, Multi Providers, Indexing, Partition, and Compression.
• Knowledge in SAP BI 7.0 security authorization concepts: create authorizations, profiles, assign profiles to users etc.
• Worked on the Planning scenarios for financial and sales applications using IP.

SAP BW 3.5 Expertise

• Extensively worked on different types of Info objects, Data sources, Info Sources, Info packages, PSA, Info Cubes, ODS, Multi providers, Info sets, Business content, Update rules, Communication Structure, Transfer rules.
• Undergone Implementation of BW which includes Data Loading (Full /Delta Up-Load), Scheduling, Monitoring, Process Chains, Performance Tuning, Data marts.
• Activated, Installed and Extended Business Contents based on Gap Analysis established on user requirements.
• Expertise in Data Loading (Initial / Delta Up-Load), Scheduling, Monitoring.
• Worked extensively in Front-end Business Warehouse Components like Queries, Calculated key figures, restricted key figures, Structures, Variables, Exceptions and Conditions.
• Worked extensively on Data Extraction from SAP R/3 using LO Extraction, Scheduling, Monitoring, BEX Analyzer, BEX Browser, Workbooks, and Report-to-Report interface.
• Creating Line item dimensions, optimizing data loads, defining Info Cubes aggregates, Roll-ups, Compression, Info cube Partitioning, indexing, Remodeling, query optimization.

SAP BO Expertise

• Universe Designer: creation of universe from BI Info Cubes, queries and databases.
• Web Intelligence: creation of reports from universe and formatting of reports.
• Info View: creating corporate dashboards from dashboard builder in info view and link your reports to the dashboard.
• CMC: create and give access to other applications and maintain user authorizations etc.
• Query as a web service: created the query and publish the query as a web service.
• Xcelsius/Dashboard: created excellent dashboards.
• Crystal reports: create the reports from SAP BI Info Cubes and create the report from query as a web service.
• Dashboard builder: created corporate dashboards and link the reports to the dashboards and linked the dashboards to the dashboard.
• Used the Information Design Tool (IDT) to establish connection and created different resources for BO Reporting. Created WEBI Report, OLAP Analysis report, Crystal report, Dashboard (Xcelsius) and Live Office Reports.

• ERP: SAP ECC, SAP R/3.
• Data warehouse Tools: SAP BI 7.3, SAP BI 7.0, SAP BW 3.5, SAP BO 4.0 and SAP BO XI 3.1.
• Languages: ABAP/4, C, C++, Java, VB, HTML, DHTML.
• Operating System: Windows 95/98/NT/XP.
• GUI: SAP GUI.
• RDBMS: Oracle9i.

Professional Experience

Confidential, TN Jul 2012 - Till date
Role: Sr. SAP BI/BO Developer
Responsibilities

• Generated the Technical Design Documents for Procurement, New-GL and CCA.
• Implemented Reporting Financials for Profitability Analysis.
• Implemented Hybrid Provider for CCA to get direct access to data from ECC and replicated data from SAP BI.
• Created reports on Purchasing Data Cube in existing flow.
• Activated Business Content specific to the requirement.
• Created Virtual Provider in SAP BI 7.3.
• Used the Information Design Tool (IDT) to establish connection and created different resources for BO Reporting. Created WEBI Report, OLAP Analysis report, Crystal report, Dashboard (Xcelsius) and Live Office Reports.
• Created Dashboards, WEBI Report and Crystal Reports.
• Created OLAP Analysis Report.

Environments: SAP BI 7.3, SAP BO 4.0, SAP ECC 6.0.

Confidential, NJ Nov 2011 - Jun 2012
Role: Sr. SAP BI Developer
Responsibilities

• Conducted requirements gathering workshops with key business users to understand existing challenges.
• Reviewing the functional specifications and generating the technical specification and design with gap analysis.
• Conducted end user training on BEx Query Designer and Analyzer.
• Helped coordinate meetings on project status, open issues, and overall progress to goal.
• Worked with functional team to perform extensive testing on queries before coordinating the production change requests (transports) with SAP Basis team.
• Involved in end to end design and development of Sales and Operations development starting from extraction to front end reporting.
• Used BWA to improve the query performance.
• Perform analysis and recommendation for implementing BWA (Business Warehouse Accelerator).
• Performed extensive Performance Tuning in the system (BW Statistics, DB Statistics, Compression, Aggregates, Partitioning and Repartitioning.
• Created Exception and Customer Sales Operations Reports.
• Created Start, End and Expert routines according to the requirement.
• Created Multi providers and enhanced queries for optimal performance.

Environments: SAP BI 7.0, SAP ECC 6.0.

Confidential, Scottsdale, AZ Aug 2011 - Oct 2011
Role: Sr. SAP BI/BW Consultant
Responsibilities

• To accommodate P2P process in BI, Extracted data using FM extractor from ECC to BI and then modeled IP s in BI and generated reports on top of MP.
• Developed Static and Dynamic cubes for GL reporting.
• Modeled Mail AR and Premium Billing aging and details cubes.
• Extracted data from Aging cubes to files using OHD.
• Generated reports for Mail AR and premium billing.

Environments: SAP BI 7.0, SAP BW 3.5, SAP ECC 6.0.

Confidential, Charlotte, NC Jun 2011 - Aug 2011
Role: Sr. SAP BI Consultant
Responsibilities

• Involved in High level Design & development of SAP BI Backend Data modeling and Frontend Reporting.
• Conducted requirements gathering workshops with key business users to understand existing challenges.
• Created OHD for extracting data from different source DSOs for different ledgers.
• Created alternate Hierarchies for 0COSTCENTER and 0PROFIT_CTR master data and loaded through flat file.
• Created Average Daily Balance variance reports to compare BI and Source System data.
• Ensure that all periodic schedules like daily/weekly and monthly are successful.
• Analyze the errors occurred while uploading the data if the request fails and make the latest data available in data target.

Environments: SAP BI 7.0, SAP ECC 6.0.

Confidential, Alpharetta, GA Jul 2010 - May 2011
Role: SAP BI/BO Consultant
Responsibilities

• Extracted data using view from ECC to SAP BI and modeled IPs and then generated Road Permit Status, Road permit Stock and Nil Permits reports on them.
• Extracted data using view from ECC to SAP BI and modeled IPs and then generated Labor Cost analysis report on it.
• Modeled IPs and generated Sales Comparison Report for Yearly, Monthly, Weekly and Daily.
• Created start routines, End routines and Transformation rules according to the requirement.
• Validating user input in the initial screen of the sales report using Customer Exit.
• Ensure that all periodic schedules like daily/weekly and monthly are successful.
• Analyze the errors occurred while uploading the data if the request fails and make the latest data available in data target.
• Installed relevant business content objects as and when required.
• Conducted requirements gathering workshops with key business users to understand existing challenges.
• Understand the client requirements and developing the Reports and dashboards using business objects tools.
• Building of the Universes for the reports using Business Objects Designer.
• Successfully Integrated SAP BI with SAP business objects XI3.1.
• Developed Various Reports in Web intelligence to track Sales periodically.
• Organized data in reports by using filters, ranking, alters and sorts.
• Created Crystal Reports with hierarchies and Filter.
• Developed highly formatted reports using Crystal Reports on top of BEX Queries.
• Created, designed and implemented Universes, WebI, Crystal Reports and Xcelsius Dashboards.

Environments: SAP BI 7.0, SAP ECC 6.0, Business Objects XI 3.1.

Confidential, City of Buffalo, NY Jun 2009 - Jul 2010
Role: SAP BI/BO Consultant
Responsibilities

• Designed and developed new BI models optimized for reporting and satisfying the business needs.
• Created Generic data source to extract Sales activities transaction data for
  reporting to sales activities analysis such as Sales Activity status, Customer, Start & End of sales Activity.
• Generated pending PO and PR report.
• Performance tuning of queries & data load by maintaining query read mode,
  Aggregates, Index & Statistics & Compression.
• Involved in Transporting the BI objects from development server to Quality
  server for Integration & Pre- production testing before UAT.
• Detected/resolved data Cardinalities and loops, checked integrity of Universes.
• Involved in developing Universe and reports on SAP BI including DSO, Info Cubes, Multi Providers and BEx Query development.
• Measure Objects and dimension objects were created keeping in view of the end-user requirement.
• Defined business objects standard reports & ad-hoc reports and Created report templates for consistency in the look and feel of the reports.
• Developed complex reports using Business Objects functionalities like Slice and Dice, Drill down, Cross Tab, Master detail and Formulas etc.
• Implemented dynamic charts and graphs in dashboards to improve look and feel using Xcelsius.

Environments: SAP BI 7.0, SAP ECC 6.0, Business Objects XI 3.1, 4.0

Confidential, Greenville, SC Dec 2008 - May 2009
Role: SAP BI Consultant
Responsibilities

• Responsible for data extraction, reconciliation and reporting.
• Responsible for loading time dependent and time independent master data and hierarchies.
• Created Start routines and End routines using ABAP in transformations to update characteristics and key figures in the Info Cubes.
• Performed Remodeling on already existing Info Cubes to add new key figures and characteristics.
• Designed process chains for daily master data loading, transactional data loading from ECC.

Environments: SAP BI 7.0, SAP ECC 6.0.

Confidential, India. May 2008 - Nov 2008
Role: SAP BI Developer
Responsibilities

• Created & Scheduled Info Packages and populated DSOs, Info cubes with full and Delta Update.
• Uploaded Transaction Data from the Flat File as the Source System.
• Used Write-optimized DSO’s for staging huge volumes of data.
• Created a routine to select a file dynamically on Application server which comes from portal to SAP BI every day.
• Created Factory calendar for scheduling the Info package on particular day of a week at particular time interval.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Wrote routines to handle Invalid characters.

Environments: SAP BI 7.0, SAP ECC 6.0.

Confidential, India Apr 2007 - Apr 2008
Role: SAP BI Developer
Responsibilities

• Involved in all phases of Implementation of Secondary Sales Analytics Project in Britannia.
• Developed ABAP Routine at Info Package Level to schedule the daily delta loads automatically in background at particular time intervals.
• Developed IOS, DSOs, Info Cubes and Multi providers to model the data in BI and loaded the data from MS-SQL using UD Connect.
• Developed ECO (Effectively Covered Outlets) reports as per the client requirement.
• Developed ABAP routine in Transformations to calculate Universe Count.
• Extracting Master & Transaction Data using Generic Data Sources from OLTP.
• Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
• Developed validation program in Process chains to generate Error log on File validation, Invalid data and Availability of Master data.
• Involved in Info Cube maintenance i.e., Compression, Roll-up.
• Designed various types of Queries and generated reports using BEx Analyzer.
• Environments: SAP BI 7.0, SAP ECC 6.0.

Confidential, Singapore Jan 2007 - Mar 2007
Role: SAP BI Developer
Responsibilities

• Reviewed system statistics and other measures to identify the need for aggregates, indexes, compression and other performance improvement techniques.
• Responsible for compression and partition of certain cubes for enhanced performance.
• Proposed archiving strategy for future based on Time characteristics.
• Improved query performance and data load using OLAP cache.
• Created Variables, Restricted Key figures, Calculated Key Figures, Filters in the BI Queries. Built code for specific User exit variables and replacement path variables to capture the requirement for Year-to-date, Quarter-to-date and Month-to-date.
• Implemented the real time cubes, aggregation levels, CVCs, planning functions, fox formulas and planning sequences for IP applications.
• Designed and developed process chains (RSPC) for transaction data loads with the help of info Packages.

Environments: SAP BI 7.0, SAP ECC 6.0.

Confidential, Saudi Arabia Jun 2005 - Dec 2006
Role: SAP BW Developer
Responsibilities

• Design, Review & understanding of technical specification / functional specification.
• Development of BW Objects as per the technical specification by adhering to Quality Standards.
• Design and development of Freight Costs visibility reports in BW. This involved requirement analysis from the client, design of ODS, Cube, reports etc.
• Created Transfer Structure, Communications Structure, Transfer Rules and Update Rules for Info Sources, ODS objects and Info Cubes.
• Generated transactional Data sources and Master Data Info sources (Texts, Attributes).
• Extensively worked on LIS in extracting master data and transaction data from SAP R/3 and loaded into SAP BW.
• Created Multi providers and enhanced queries for optimal performance.
• Created Info Packages and Info Package Groups and scheduled them in order to load Master Data and Transactional Data from SAP R/3 as well as Flat File Source Systems into BW.
• By using the generic extraction tool extracted data from source system and also performed delta operations to meet client requirements.
• Extensively worked on Query building, Structures, RKF, CKF and Variables using BEx Analyzer.

Environments: SAP BW 3.5, SAP R/3 4.7.

Confidential, India Jun 2004 - May 2005
Role: SAP ABAP Developer
Responsibilities

• Developed an ALV report providing the information about sales order details for a particular sales document number and further navigates to the material master and sales order transactions when you select particular item fields.
• Developed an ALV list which gives purchase order header and item details for a particular order number and date.
• Developed a daily material receipt report, which gives detailed list about the goods receipt as per the plant details, storage location and movement type.
• Developed application using Module Pool which gives sales order and customer details for a particular customer using controls with validations and search helps.
• Developed an interface which will transfer the purchase order details from legacy system to SAP system by using the standard BAPI.
• Generated a BDC program to migrate material details from legacy system to
• SAP R/3.
• Implemented a BADI enabling a value range checks for document type through create material transaction.
• Implemented a function exit to Predefine Sold to Party for every order type and sales area values that has provided in sales order create transaction.
• Modified standard layout set of MEDRUCK for purchase order as per the client specification.

Environments: SAP R/3 4.7.

• M.C.A in Computer Science from Confidential, India.