SUMMARY

• Thirteen (13+) years of professional experience and over 11+ years of experience working in SAP BI 7.0, BW 3.5 BOBJ and BPC, involved in three (4) life cycle implementations involving design and development of BW Objects, Transformations, Business Content configuration, Capacity Planning and Sizing using SAP ASAP methodologies.
• As a BW /BI Senior Consultant responsible for Preparation of Data flows, functional feasibility analysis, Post go live support, activity execution, Preparation of cutover activities, System configuration checks, Quality Assurance to improve performance of the system, New solution handovers in COPA, FIGL, SL, AP, AR, SRM, SCM, SD, QM, MM, PP and HRM modules.
• Expertise in Back - end Business Warehouse Components Extractors, Info Objects, InfoSources, Update rules, Transfer rules, Info Cubes, and Info Packages and front-end Business Warehouse Components Queries, Calculated key figures, restricted key figures, Structures, Variables, BEx Analyzer, BEx browser and web reports.
• Extensively Worked on SAP NW 2004s BI (Transformations & Data Transfer Process), activated Standard Business Content InfoProviders (InfoCubes and DSO’s), Created Transformations and DTP’s.
• Experienced in Business Objects universe designing, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view, and Business Objects Enterprise.
• Experienced in designing and developing the Universe and updating the existing Universes, developing canned/ad hoc reports, scheduling the processes and administering the BO activities using Business Objects XIR2/ BOXI 3.0. Worked on Xcelsius dashboard with Crystal reports, Web Intelligence, business objects data federator and Web Services.
• Expertise in creating, organizing, publishing and scheduling reports using Center Management Console.
• Experienced with OLAP functionalities like Scope of Analysis, Drill Analysis and Slice & Dice

TECHNICAL SKILLS

Reporting: Performed unit testing, system integration testing and user acceptance testing of Crystal Reports. Experienced in using BEx Analyzer, WAD, BEx Browser, work books, Info Set Query, Web Reports, Enhanced reports applying Filters, Conditions, User Exits, Customer modifications, style sheets, graphs and parameter validation.

BW 3.5: BEx (Business Explorer) Broadcaster, Analysis Process Designer, Data Mining.

Data Modeling: Design Data Warehouse (Dataflow), Development (Info Cube, ODS, InfoSets), Configuration of Info Cubes, extractors, Business Content, SAP ASAP methodologies, GAP Analysis.

Extraction: Integration of SAP BW with FI/CO, SD,QM, Extracted Master Data, Transactional Data, Text, Hierarchy using different type of extraction including Generic Extraction and LO extraction from both SAP R/3 and Non-SAP Systems. SEM - Settings for SAP SEM-BPS, Planning Environment and Modeling Planning Area, Planning Level, Planning Package, Planning Profile.

Performance: Fine Tuning (BW Production Go live) Load Management and reporting optimization taking into account various factors like Initialization, then deltas, Avoid Sid’s, indexing, maximum number of parallel processes, minimum number of data records for each data package. Maintaining Aggregates, Compression, partition, and use of BW statistics for the same.

BW Security: Analysis Authorizations, Reporting Authorizations, user profile maintenance BW

BPC: Experience with BPS design, development, support, maintenance and interfaces.

Business Areas: SD, MM, SCM, FI/CO, BPS, APO, BPC

PROFESSIONAL EXPERIENCE

Confidential

SAP BI/BPC System Analyst

Environment: SAP BI 7.0, BOBJ 4.0 and Crystal reports 2012 and SAP ECC

Responsibilities:

• Integration of SAP ECC with SAP Crystal reports 2011.
• SAP Crystal Reports were created with the extraction of data from legacy system to the SQL System.
• Created reports with ODBC and SAP ECC.
• Created Documents to assist WCS about SAP BI and Business Objects report and query creation - especially web intelligence and Crystal reports.
• Responsible for identifying and leading required architecture disciplines on the project.
• Develop functional requirements for changes to business applications and processes.
• Demonstrated project benefits to the business.
• Building BI InfoCubes, ODS, extractor and update programs. Create and maintain ODS's, InfoCubes & Multi-providers.
• Identified and evaluated alternate technical solutions, providing recommendations in the use of new and/or existing technologies.
• Troubleshoot and resolve production problems in BW, Business Objects Universe, WebI and Bex reports.
• Assists WCS organization with SAP BI with Crystal Reports 2012 knowledge at a level of understanding appropriate to their job function, including:
• End-user documentation
• Creations of functional and Technical documents to create Crystal Report
• Deliver training
• Technical documentation
• Knowledge transfer and meet deadlines for the assigned projects and tasks
• BPC -
• Gather the requirements for blue print, build, the Budgeting and Forecasting functionalities.
• Configure data manager extraction from ECC and BI system for the actual data.
• Configure data manager extraction from ECC and BI system for the actual data.
• BPC process chain development to the financial data to staging DSO and to the cube.
• Process chain development to support master data loads from BW to BPC.
• Loading the historical data, opening balances current year data to BPC application from legacy source system.
• Defining and Creating Input Templates.
• Creating and Developing Budgeting Business Process Flows.

Confidential

SAP BI/BOBJ Production Support Lead

Environment: SAP BI 7.0, SAP BOBJ and SAP ECC

Responsibilities:

• Actively Involved in Monitoring and Extraction of the Data from PSA into Data targets.
• As a member in the Support team, involved in completing tickets from client.
• Daily monitoring of Info cubes and ODS objects requests.
• Monitoring of Info packages and process chains.
• Created info packages by populating info cubes by executing Info packages using both the update methods (Full update method and Initialization of Delta update).
• Troubleshoot and resolve production problems in BW, Business Objects Universe, WebI and BEx reports.
• Designed Business objects universe, Business Objects Web Intelligence, Info view and Business Objects Enterprise, scheduling the processes and administering the BO activities using Business Objects XIR2/ BOXI 3.0.
• Modifying BI reports as per the need of the user.
• Identified and evaluated alternate technical solutions, providing recommendations in the use of new and/or existing technologies.

Confidential

SAP BI/BOBJ Project Lead

Environment: SAP BI 7.0, SAP BOBJ and SAP R/3

Responsibilities:

• As a Project lead I was responsible for leading a team of technical consultants for implementing data lifecycle management, migrating 3.x objects to 7.0 and BI Unicode, i.e. Non-English for BI Translation in BI Query Designer.
• Communicate project activities and progress to the business.
• Manage business process activities to ensure that the project meets its objectives on time and on budget.
• Provide leadership to all project phases & change activities.
• Identify project risks and formulate risk mitigation plan.
• Responsible for identifying and leading required architecture disciplines on the project.
• Worked with SMEs to refine solution design alternatives in understanding the proposed business process change.
• Develop functional requirements for changes to business applications and processes.
• Demonstrated project benefits to the business.
• Building BI InfoCubes, ODS, extractor and update programs. Create and maintain ODS's, InfoCubes & Multi-providers.
• Identified and evaluated alternate technical solutions, providing recommendations in the use of new and/or existing technologies.
• Troubleshoot and resolve production problems in BW, Business Objects Universe, WebI and Bex reports.
• Assists others in the organization with SAP BI knowledge at a level of understanding appropriate to their job function, including:
• End-user documentation
• Deliver training
• Technical documentation
• Knowledge transfer and meet deadlines for the assigned projects and tasks

Confidential

SAP BW/BI/BOBJ Module Lead

Environment: SAP BI 7.0, BEx Analyzer, SAP R/3, SD,QM and SCM

Responsibilities:

• As a BW/BI Senior consultant responsible for identifying, planning and executing all activities in support of daily BW/BI operations.
• Lead a team of technical/functional consultants for implementing the SAP BI solution and migration.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe and created BOE reports by accessing real-time information from multiple data sources using data federation.
• Upgrade Coordinator for world-wide upgrade of BW 3.5 to NW 2004s involving two ECC source systems.
• Designed new IP planning functions for sales planning - delete, copy actual, file upload user interface using a web browser, planning application workbooks.
• Involved in the migration Of BW BPS to IP application.
• Developed the Planning Applications for Cost center Planning and Sales planning.
• Designed BEx Broadcaster application for distribution of sales report and tools usage summary report, configured pre - calculated web templates and work books.
• Created reports with Charts (bar chart, Pie chart, etc), Cross-tabs and Sub reports.
• Performed unit testing, system integration testing, and user acceptance testing of Crystal Reports at various levels.
• Designed Business objects universe, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view and Business Objects Enterprise, scheduling the processes and administering the BO activities using Business Objects XIR2/ BOXI 3.0
• Created crystal reports in combination with SAP BI Queries.
• Enabled dynamic report linking by passing Variables (prompts) between reports.
• Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, and Info View.
• Designed and developed the Universe and updating the existing Universes, developing canned/ad hoc reports,
• Created, organized, publishing and scheduling reports using Center Management Console.
• Participated in design review session’s onsite-offshore delivery model to ensure technical designs.
• Coordinated weekly all - hands meetings, status reports and delegating BW activities to fellow team members.

Confidential

SAP BI/BOBJ Technical Lead

Environment: SAP BI 7.0, BEx Analyzer, SAP R/3, SD, and ABAP

Responsibilities:

• Lead a team of technical/functional consultants for implementing the SAP BI solution and migration.
• Defined work packages and technical specifications for design, development, testing and roll-out.
• Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content. The main cubes developed are Customer (0SD C01), Sales Overview (0SD C03), Delivery Service (0SD C04), Purchasing Data (0PUR C01) and Vendor Evaluation (0PUR C02).
• Worked with functional consultant for mapping the source data (R3/non R3) to target DataSources in BI. Defined the initial sizing requirements based on source data volume estimates.
• The team configured Custom cubes, Transfer rules, Transfer Structures, Update Rules, ODS, Cubes, Aggregates, queries and workbooks.
• Worked with the users for defining the reporting needs and helped design/develop flexible queries and pre-calculated reports using BEX reporting features like variables, exception and conditions in Sales and Purchasing areas. Created SAP BI reports which include Plan/Actual revenue comparison, Order and sales value by sales representatives and Vendor delivery efficiency.
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing. Tuned queries using Partitioning, Aggregates and Multi providers.
• Designed and developed the Universe and updating the existing Universes, developing canned/ad hoc reports, scheduling the processes and administering the BO activities using Business Objects XIR2/ BOXI 3.0.
• Expertise in creating, organizing, publishing and scheduling reports using Center Management Console.
• Gathered requirements from functional users in Sales and Purchasing for cross functional analysis.

Confidential, Rochester, NY

SAP BI/BOBJ Technical Lead

Environment: SAP BW 3.5, BEx Analyzer, SAP R/3 FI/CO and SD

Responsibilities:

• Lead a team of technical/functional consultants for implementing the SAP BI solution and migration.
• As a BW/BI Consultant responsible for identifying, planning and executing all activities in support of daily BW/BI operations.
• Analyzed and mapped Business Process to BW and create blueprints using ASAP methodology. SAP BW Modeling/Architecture/Reporting.
• Responsible for develop logical data models, ETL Specifications, Source to staging.
• Responsible for Data conversion from TM1 to SAP BW.
• Configured and customized applications for FI/GL, HCM, COPA, SD and MM modules.
• Functioned as a SAP BW Planning team lead of three consultants.
• Involved in technical and business analysis aspects of BW data warehouse project development, creation of test plans and scenarios, testing, and implementation; including significant hands-on work.
• Depending on department and project needs, support functional and technical design efforts, including data flow diagrams and multi-dimensional data models.
• Review design documents to identify improvement opportunities.
• Applied technical skills and functional experience to keep project ahead of schedule, under budget and to the fullest satisfaction of the customer.
• Source system analysis, business content check, generic extractor on custom tables for automatic master data scheduling for employee.
• Designed Business objects universe, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view and Business Objects Enterprise, scheduling the processes and administering the BO activities using Business Objects XIR2/ BOXI 3.0 and Worked on Xcelsius dashboard with Crystal reports,
• Created Xcelsius dashboards with Crystal reports, Web intelligence and Web services.
• Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration.
• Created reports with Charts (bar chart, Pie chart, etc), Cross-tabs and Sub reports.
• Performed unit testing, system integration testing, and user acceptance testing of Crystal Reports at various levels.

Confidential

SAP BW/BOBJ Developer

Environment: SAP BW 3.5, BEx Analyzer, SAP R/3, SD and MM, EP

Responsibilities:

• Actively Involved in Monitoring and Extraction of the Data from PSA into Data targets.
• As a member in the Support team, involved in completing tickets from client.
• Daily monitoring of Info cubes and ODS objects requests.
• Monitoring of Info packages and process chains.
• Created info packages by populating info cubes by executing Info packages using both the update methods (Full update method and Initialization of Delta update).
• Developed Customized Info Objects and applied transfer rules and compounding.
• Developed Info Sources which uses flat files from app server and applied constants, subroutines in transfer structures.
• Initiating extract process in BW at regular intervals of time.
• Loading Data from Flat File (as the Source System.) in to BW.
• Resolving urgent user issues - helpline activities.
• Designed Business objects universe, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view and Business Objects Enterprise, scheduling the processes and administering the BO activities using Business Objects XIR2/ BOXI 3.0 and Worked on Xcelsius dashboard with Crystal reports
• Modifying BW reports as per the need of the user.
• Developed Multi cubes which interacts with basic cubes with identification.
• Developed Update rules to update Info Cube and applied aggregates.

Confidential

SAP BW Consultant

Environment: SAP BW 3.5, SAP R/3, ABAP

Responsibilities:

• Experienced in bringing Master Data and Transactional data from both Flat Files and R/3 to BW.
• Designed and developed Basic InfoCubes to extract data from ODS Objects for BEx reporting.
• Performed data extraction using LO COCKPIT (LBWE)
• Designed Generic data extractors to extract and transform the data to suit the Business Warehouse model.
• Data loading was monitored and the failed data packets are analyzed and manually edited in PSA (mostly for invalid characters) and re-loaded into ODS.
• Maintaining Work History for all the tickets until it is closed down.
• Actively Involved in Monitoring and Extraction of the Data from PSA into Data targets.
• As a member in the Support team, involved in completing tickets from client.
• Daily monitoring of Info cubes and ODS objects requests.
• Monitoring of Info packages and process chains.
• Developed Customized Info Objects and applied transfer rules and compounding.
• Developed Info Sources which uses flat files from app server and applied constants, subroutines in transfer structures.
• Resolving urgent user issues - helpline activities
• Modifying BW reports as per the need of the user.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Created info sources, info packages and schedulers to extract data from R/3.
• Created transfer rules and update rules for info cubes and custom master objects.
• Experienced in Creating and Customizing Info Cubes, Multi-Cubes, ODS.

Confidential

SAP BW Developer

Environment: SAP BW 3.0, BEx Analyzer, SAP R/3, SD and MM, EP

Responsibilities:

• Gathered business requirements and defined deliverables along with functional analysis and worked with SAP R/3 technical and SMEs in the business areas.
• Implemented Standard Business Content InfoCubes like Line Item (0FIAR C03), Payment History (0FIAR C05), and Cost and Allocation (0CCA 11) and customized those using Update Rules. Created ODS, InfoCubes and MultiProvider for queries.
• Extracted and uploaded data into InfoCubes from DataSources like Cost and Allocation (0C0 OM CCA X), Internal Order (0C0 OM OPA X), Account Receivable (0FIAR AR 4) and Account Payable (0FIAR AP 4) for the FI & CO modules from the Business content.
• Responsible for design, development and extraction from R/3 Source system and flat files to BW for FI & CO.
• Worked with functional consultant for mapping the source data (R3/non R3) to target DataSources in BW.
• Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx. Worked with users to understand their reporting needs. Generated Export DataSources to transform data from one InfoCube to other InfoCube.
• Scheduled Daily/Weekly/Monthly data loads.
• Managed and monitored data loads with full upload and delta mechanism.
• Created Infoset for master data to enabling querying on data.
• Created summarized reports which includes display of Plan/Actual variance measures, analysis of full cost by cost center, overdue analysis, and analysis of payment history.
• Developed and Tested Web Reports for drill down functionality including updating rules and transfer rules & verifying queries.
• Create and extensively used Info spoke to feed data to data marts.
• Extensively involved in the scheduling and monitoring using process chain in Administrative Workbench.
• Monitoring and implementing the solutions to the errors in the Production System.
• Worked on performance of queries and performed various tuning techniques using Compression, Aggregates and MultiProviders.

Confidential

SAP BW Technical Consultant

Responsibilities:

• Actively Involved in Monitoring and Extraction of the Data from PSA into Data targets.
• As a member in the Support team, involved in completing tickets from client.
• Daily monitoring of Info cubes and ODS objects requests.
• Extracted Data from Shipping LO Extract structures 2LIS 12 VCHDR and 2LIS 12 VCITM. Created Info package for both Initialization and delta and loaded in to 0SD C02 Deliveries and 0SD C04 delivery services.
• Extracted data from Sales Billing Extract Structures 2LIS 13 VDHDR and 2LIS 13 VDITM and created InfoPackages for initialization and Delta to feed 0SD C05 sales Offers/Orders InfoCube
• Monitoring of Info packages and process chains.
• Created info packages by populating info cubes by executing Info packages using both the update methods (Full update method and Initialization of Delta update).
• Developed Customized Info Objects and applied transfer rules and compounding.
• Developed Info Sources which uses flat files from app server and applied constants, subroutines in transfer structures.
• Initiating extract process in BW at regular intervals of time.
• Loading Data from Flat File (as the Source System.) in to BW.
• Developed Multi cubes which interacts with basic cubes with identification.
• Developed Update rules to update Info Cube and applied aggregates.
• Monitoring Data load failures through RSMO t.code, if load fails, we can get details from details tab of Monitor, then solving failures using different t.code like ST22, SM37, SM12 basing on type of error message we got.