SUMMARY:

• Around 9+ years of Experience in SAP BW v7.3, v7.0 involving 4 Full Life Cycle Implementations, Migration, Enhancement and Support projects.
• Infosys certified in SAP BW, SAP BO and Agile Methodology
• Hands - on Knowledge on BCS, Integrated Planning and Business Objects reporting tools.
• Effective Leadership skills: Experienced in leading technical teams efficiently and in managing cross-functional teams effectively as well as coordinating third party vendors.
• Ability to work independently with minimum supervision.
• Effective communication and presentation skills, Quick adaptability and systematic approach towards work.
• Current Role: Subject matter expert and Team Lead effectively managing 10+ team members via Onsite-Offshore model.
• Expert Knowledge on Modeling, Extraction and Reporting areas of SAP BW/BI.
• Exposure to HANA Studio and development of HANA related objects.
• Knowledge on BW ABAP to write transformation level Routines and Function Modules.
• Involved in complete life cycle implementation of BI projects involving in all phases of life cycle including Requirement Gathering, Analysis, Design, Development, Testing, Deployment of Solutions, Post Go Live Support, Documentation, and User Training.
• Worked extensively on Business content activation.
• Application redesign/retrofits to enable scalable solutions for entire BW reporting landscape
• Landscape management, system governance, Project estimations, planning, solution design, development, testing and cutovers
• Good Knowledge in extraction of data from BW to External systems using open hub destination.
• Extensive knowledge on Reporting using BEx Query designer and BEx Analyzer
• Extensive Knowledge on Transformations and DTP, Transport Mechanism.
• Good Knowledge on BO Universe Creation, Design Studio, WEBI, Crystal Reports and Dashboards.
• Define best practices and ASAP methodologies, design reviews and quality control checks. Anchoring Continuous Improvement and Automation.
• Resolve complex production support issues
• Work on application development, coding as needed for smooth project deployments

PROFESSIONAL EXPERIENCE:

Confidential

Senior Associate Consultant - SAP BW

Responsibilities:

• Define Pre and Post migration activities and coordinating with other teams for the smooth deployment of upgrade project.
• Migration of Replenishment Planning solution in Supply Chain from Middleware to SAP APO.
• Complete redesign of BW solution from the analysis of APO base tables, creation of generic data sources until the development of new reports to match the existing reports.
• Phase 3 implementation of AP reporting solution: To simplify the existing solution with complete redesign of BW back end data flow moving all the report complexity to transformations and eliminate all the bottlenecks at reporting level.
• Vendor Master data enhancement and other minor enhancements.
• Delete aggregates and move any cubes to BIA, which are critical for reporting during the migration phase. Aggregates are not required for BW on HANA
• Compression is performed on all Cubes to make the cube size smaller
• Archiving is performed all the DSO’s which have a considerable amount of data
• Archived iDocs and cleaned qRFC queues. Deleted DTP temporary storage, DTP error logs as much as possible
• Migrated any 3.x flows to 7.x
• Performed BW to HANA migrations readiness check (v2.0) in SAP Note 1729988 and resolve any high priority issues with the help of basis and security team and general check in the tool for DEV, QA, Prod and SB
• After migration, performed connectivity validations, security checks and job scheduling checks (Open Hub Destinations)
• Performed and monitored the parallel run of both HANA and previous BW system to get sync in all the loads until the new HANA system is stabilized. Load performance is compared between two systems
• Ran key queries, reports and dashboards for collection of benchmark statistics and performance, including BEx broadcaster jobs, pre-calculations and workbooks
• Execute key queries identified in above step and reconcile data at summary level and detailed as required
• Deleted all the rollup steps from all the process chains and there will be no BIA or Aggregates needed in HANA
• Collect new HANA performance statistics for dashboards BEx broadcaster, reports, workbooks and analyze performance gains
• Extensively involved in production support by loading Daily loads/Weekly loads into the BI system from different source systems.
• As a part of production support involved in monitoring load failures, delta loads, and monitoring the performance of the system.
• Provided Continuous Maintenance Support like monitoring and optimization, which include loading of reports, data archiving, monitoring of master data and transaction data loads.
• Created and monitored various Process Chains, Managed and monitored data loads, job scheduling and updating DB Statistics regularly and rebuilding missing indexes for increasing the Query Response.
• Implement new change requests from business in weekly release. Gather functional requirements and provide Impact Analysis and Effort estimates to business to agree with the delivery dates.

Confidential

Senior Software Engineer - SAP BW

Responsibilities:

• Build Financial reconciliation mechanism between SAP BW and ECC and deploy.
• Impact analysis and formulate necessary strategies to handle uninterrupted reporting.
• Participated in year-end Rollover to gather requirements from business, do impact analysis and implement changes.
• Modified more than 100 reports according to business requirement.
• Implement new change requests from business in monthly release. Gather functional requirements and provide Impact Analysis and Effort estimates to business to agree with the delivery date.
• Performed most of the BCS tasks as a part of change requests
• BCS: Performed collection and upload of Data using manual and Flexi Upload
• BCS: Performed validations like upload validations basing on the criteria given and Business rule validations basing on the business rules
• BCS: Performed currency translations (local currency to group currency)
• BCS: Performed Inter Unit Eliminations to eliminate the sales or transfers between the LE’S within the Group
• BCS: Consolidation of investments to consolidate the amount of percentage of holdings and to calculate the Net worth in the subsidiary or child companies
• BCS: Performed other BCS tasks like Reclassification, Allocation, Copy Actuals and Balance Carry forward
• Created customized workbooks using multiple queries based on business requirements.
• Performed Unit Testing in development system to ensure there are no bugs in development.
• Involved in redesigning Cubes and DSOs as a part of performance optimization.
• Coordinated with streams like Security, Basis and Change management whenever necessary.
• Performed Regression Testing in Preproduction system.
• Create proper Documentation for all the existing data flows and reports in the system according to the defined process and ensure all changes are captured and documented.
• Interact with users to gain Business Knowledge and understand how the technical landscape will be useful to business and propose solutions to their needs.
• Taken up the analysis of low-level performance areas, and propose solution to business.
• Adherence to process. Performed Internal Audit to make sure it is followed 100%.
• Provide training to new team members about business and system landscape. Also involved in providing technical training.

Confidential

Senior Software Engineer - SAP BW

Responsibilities:

• Main objective of this COPA redesign project is to optimize Report performance, simplify database design.
• Analyzed the statistics of crucial and long running finance reports to check DB and OLAP run time.
• Identified and addressed the pain points at reporting level like long running reports due to un-partitioned cubes, exception aggregation in reports, non usage of OLAP cache, constraints in keeping the COPA cube in BIA
• Identified and addressed the pain points at BI Administration level like deleting/building indexes taking long time, selective deletion and archiving is becoming very difficult. Aggregate volumes are very high.
• Carried out a detailed level of Impact analysis and respective precautions are taken before the start of development to ensure a very minimal disruption to the end-users.
• Partitioned the COPA Cube both logically basing on a Company Code and physically basing on Fiscal Year/ Period and loaded data into respective cubes.
• Created Customer Exit Variables to replace the old COPA cube restriction in any of the finance reports.
• 2011 and 2010 COPA cubes are placed in BI Accelerator and created BIA indexes for both the cubes
• Aggregates are built on other cubes where BIA could not be implemented due to space constraint.
• Modified about 105 finance reports so as to comply with the new changes and tested the overall performance to be improved 89%
• Involved in the Implementation of CFO Dashboard to address various key performance indicators of Business like Gross Sales Value, Sales Volume, and Turnover etc to Chief Financial Officer of HUL ( Confidential Confidential Limited).
• Developed technical specifications based on the functional specifications to ensure the correct development of the solution to satisfy the business need.
• As a Part of Developing Dashboard, created number of APDs to post the values of complex key figures into new Info Provider.
• Used BO dashboards to create a dashboard for CFO Visualization report.
• Extensively used Transformations and DTP to build the complete APD flow from COPA Cube, GL and DSR (Daily Sales Reporting) Multi Provider to new Info Provider.
• Developed Customer Exit Variables by writing CMOD code in order to use them in query to arrive Ten-day period (TDP) values.
• Used both initializations with Delta Update and Full Update methods depending on the requirement.
• Created multiple layers of DSO with standard and direct update, used to stage data before transferring DSO contents to Info Cube.
• Created Aggregates on multiple characteristics of Cube in order to improve the base query performance.

Confidential

SAP BI Consultant

Responsibilities:

• Interacted with management and end-users about the requirements and made GAP Analysis.
• Identifying the needs of customer, modeling the data and defining the Data Sources at OLTP for the SD, MM and FI module.
• Extracted data from FI, SD and MM modules of SAP R/3 and from flat files into SAP BI System.
• Involved in Design, Development of the Business Information Warehouse and enhanced the Business Content Info Cubes and R/3 extractors.
• Used multiple layers of ODS to stage the data before transferring the ODS contents to the Info Cube and worked extensively on Data Marts.
• Activated Business Content for standard SD, MM Info Cubes, Info Sources and Info Objects and enhanced standard Business Content based on client requirements for enhancing data sources for Transaction, master and texts data.
• Created Info Cubes, Aggregates, ODS for incoming sales orders according to sales organization, distribution channels, ship-to-party, customers and materials.
• Created and monitored various Process Chains, Managed and monitored data loads, job scheduling and updating DB Statistics regularly and rebuilding missing indexes for increasing the Query Response.
• Identified the LO, LIS and generic extractors for mapping them with the business requirements, activated and transferred the relevant Data Sources.
• Developed reports using BEx Query Designer and worked on BEx Analyzer.
• Provided Continuous Improvement Support which includes appending fields to the data sources and modifying the Info cubes and ODSs
• Provided Continuous Maintenance Support like monitoring and optimization, which include loading of reports, data archiving, monitoring of master data and transaction data loads.
• Involved in writing start routines, end routines and look-ups for fetching desired data according to the functional Specs.