SUMMARY

• 7 Years of experience as a SAP BI/BO Consultant with hands on BW 7.0 & 7.3, BO XI3.1 and BO XI 4.0 Analysis, Development, Solutioning and Testing.
• Implemented 7 End to End projects based on various technologies like SAP BW 7.0 &7.3,BO XI 3.1 &4.0
• Hands on exposure for Co - coordinating the project as Lead from client location.
• Extensive hands on experience in BI Data modeling including BEx reports, WAD.
• Hands on experience on SAP BW on creating Infoobjects,ABAP Tables, Infoproviders(Infocube, Dsos,Infoset, MultiProviders),Sap BEx reports,transformation routines, customer Exits, Process chains, Aggregates, secondary indexes, flat file data sources, BADIs and APDs.
• Worked on various extractors including generic and standard extractors using various delta functionalities.
• Expertise working with Business Objects tools: Business Objects XIR3.1 Designer, Web-Intelligence, Crystal Reports, and Xcelsius, Advance Analysis on OLAP
• Extensive hands on experience in making Business Object Xcelsius Dashboards, and Crystal Reports. Mapped BEx report into Xcelsius using XML, LiveOffice, QAAS connections.
• Developed various Charts and Graphs like Bar chart, Line graphs, Pie charts, and Numeric Axis etc by using Crystal Reports and Web-Intelligence.
• Possessed extensive knowledge of problem solving techniques and excellent analytical skills coupled with good communication and interpersonal skills describing a committed team player.

TECHNICAL SKILLS:

Domain: SAP BI 7.0 &7.3 / SAP BO XI 3.1 & 4.0

Tools: SAP BI BEx Query Designer, BEx Query Analyzer, Web Application Designer, BI Data modeling, Extractors(Generic, Standard)SAPBO Dashboard Designer(Xcelsius),Advance Analysis, Crystal Report,WebIntelligence

Database: MS SQL, Oracle

Dash boarding Tools: Dashboard Designer(Xcelsius)

PROFESSIONAL EXPERIENCE:

Confidential, OH

SAP BI/ BW Lead

Responsibilities:

• I started working for this project as offshore BW lead, where my main responsibility was to handle a team of 5 BW resources at the same time getting requirements from Onsite lead and assigning and helping offshore team in resolving issues they face. I was responsible for BW offshore delivery in this position. After the development phase, I am currently in US as a Onsite lead of the Project.
• I am responsible here for coordinating with offshore team as well as working with clients to make them understand the technical aspects of the Application better and helping them with any BI issues.
• I am directly involved in designing the BW data flow as per business requirement, Designing ABAP program logic for various customer exits along with transformation Includes required in the reports as well as transformations.
• Designed and developed very complex BEx Report which analyzes forecast data KPIs as per Business requirement
• Written ABAP codes for Transformation routines to handle complex requirements.
• Developed BO reports using Xcelsius and Advance Analysis Tools
• I am responsible for handing Business Issues in onsite as well as guiding offshore team to deliver BW requirements on time.

Confidential

SAP BO/BI/BW Developer

Responsibilities:

• Handling the World’s Second largest SAP Net weaver portal (After SAP Portal) click level data.
• Interacted with Business Users to gather the Requirements and Business logics
• Developed generic data source using generic delta functionality.
• Used various extractors to extract data from source system to BW.
• Designed the logic of the ABAP program to read portal trace files and updating the application and project name while matching with the application master data tables maintained using the PCD URL.
• Developed SAP BI InfoObjects (characteristics and keyFigures), DSO and InfoCubes, Infosets, Multiproviders.
• Designed and developed Custom Units in 0Unit InfoObject.
• Designed and developed APDs to directly load data to the direct Update DSOs
• Worked various features of BEx reports including exception aggregation, Condition, Cell restriction, including Customer exit and Replacement type path variables
• Worked on currency translations in BEx reports
• Worked on RRI of BEx Reporting
• Developed Process Chains for data loading for various Data Targets.
• Designed and developed BEx Report which analyzes total time spent, unique user ID, Unique Session IDs, No of Clicks along with drill down functionality.
• Designed the ABAP Program logic for calculating total time spent by any user for different applications running in Portal.
• Transported developed objects from DEV to Quality to PROD environment.
• Developed single Advance Analysis Report on the BEx Queries developed using BICS connectivity of SAP BI 4.0 which provides user greater depth of Analysis and as these reports are more appealing so it gives Users a whole new experience of Business Objects reporting capabilities.

Confidential

SAP BO/BI/BW Developer

Responsibilities:

• Interacted with Business Users and Business Analyst to gather the Requirements and Business logics.
• Implement the Use cases for new crystal reports.
• Design the crystal reports as per the Use Cases.
• Assist in planning, designing, and implementing of Crystal Reports.
• Created Infoarea, Infoobjects, DSOs, MultiProviders.
• Extracted Data from Sap R/3 to SAP BW using COPA and LO cockpit extractors.
• Used standard as well as custom extractors.
• Used generic delta functionalities to pull only the changed records.
• Worked on transformation routines, including field routines, start and end routines.
• Captured and transported various BW objects including ABAP Programs from DEV to QA and Prod.
• Designed SAP BEx Reports, on Multiprovider.
• Created Crystal reports upon BEx reports and MS SQL.
• Created sub reports using Crystal reports.
• Created summery level Crystal Reports for the Dashboard and detail Reports for Detail Analysis which can be opened from the Dashboard using OpenDoc Link.
• Uploaded crystal reports to Infoview.
• Used LiveOffice to connect Crystal reports on infoview to Dashboard.
• Used parameters in Liveoffice connections.
• Used various trigger option like when value changes and when value becomes in Xcelsius Dashboard

Confidential

SAP BO/BI/BW Developer

Responsibilities:

• Directly coordinating with user to gather the new requirements and working with existing issues
• Actively involved in discussion meetings and requirements gathering
• Interacted with all levels of end users to develop requirements for in house and presentation quality reports
• Developed SAP BEx reports.
• Integrated SAP BEx reports to Xcelsius Dashboard through XML connectivity.
• Developed BSP application which will provide SAP BEx reports in XML format.
• Involved in transporting the Xcelsius objects along with BEX reports and BSP application Objects from Dev-Quality-Production.
• Developed the Dashboard by using various features of Xcelsius such as drilldown functionality, Dynamic visibility and different trigger options available.
• Applied single sign on the Dashboard for different users.

Confidential

SAP BI/BW Developer

Responsibilities:

• Directly coordinating with user to gather the new requirements and working with existing issues
• Actively involved in discussion meetings and requirements gathering
• Interacted with all levels of end users to develop requirements for in house and presentation quality reports
• Developed SAP BEx reports.
• Worked on generic and standard extractors, currency conversions.
• I was involved in process chain creation, its maintenance.
• Developed various bw objects(Infoobjects, DSOs, cubes, multiproviders, Info sets, open hub destination), including complex Bex reports.
• Was involved in hierarchy data loading and maintenance..
• Was involved in capturing various BW objects and transporting them from Dev to QA.
• Worked on Jump queries using Report to report interface.

Confidential

SAP BO/BI/BW Developer

Responsibilities:

• Responsibilities included requirement gathering, Project Scoping, Blue Prints, data modeling, plan/scheduling data input from source systems, interface with users for standard reports, gap analysis, and associated solutions
• Directly coordinating with user to gather the new requirements and working with existing issues
• Actively involved in discussion meetings and requirements gathering
• Interacted with all levels of end users to develop requirements for in house and presentation quality reports
• Developed SAP BEx reports.
• Worked on generic and standard extractors, currency conversions.
• I was involved in process chain creation, its maintenance.
• Developed various BW objects (Infoobjects, DSOs, cubes, multiproviders, Info sets, open hub destination), including complex BEx reports.
• Was involved in hierarchy data loading and maintenance..
• Was involved in capturing various BW objects and transporting them from Dev to QA.
• Worked on Jump queries using Report to report interface.

Confidential

SAP BI/BW Developer

Responsibilities:

• Master Data & Transactional Data transfer from R3 sources.
• Ensured that the data from the flat files were loaded properly into BW.
• Extraction and loading of SAP R/3 data such as Sales and distribution, Financial accounting.
• Created Financial Reports like cost center, profit center, Balance sheet etc.,
• Created BW reports for monthly sales analysis, customer orders trends analysis, cross-functional analysis using SD and FI data, etc.
• Maintaining Generic Data sources.
• Checked the transfer rules and the structures so as to ensure that the fields of the staging table were mapped properly with the info objects.
• Enhancing and fine-tuning the existing BEx reports.
• Extensively worked on BW Administration Workbench
• Checked the update rules.
• Created info packages for scheduling the data loading process.
• Monitored the data loading in the info cube.
• Actively done extraction, transformation and loading of data from SAP R/3, and Non-SAP systems to BW.
• Sourced data from R/3 Tables and flat files to load data into info cube.
• Created BEx Reports on the actual cube.