SUMMARY:

• Steadily Progressing professional with 10+ years of experience in Information Technology in SAP BW 7.0 with IP, APO - DP & SNP, 7.4 on HANA, who has extensively worked with Accelerated SAP Methodology in 4 Full Cycle BI Implementations + Reporting from design, implementation and support.
• Thorough understanding of SAP BEx tools and SAP BOBJ tools like Dashboards, Webi, Explorer and Analysis editions and other reporting using Tableau, Klipfolios and Fiori.
• Successfully managed SAP BW projects using Dev/Ops strategy combined with Agile - SCRUM methodology.

PROFESSIONAL EXPERIENCE:

Confidential

Software Engineer

Responsibilities:

• Worked on ARIS for SAP to build an Enterprise Architecture using Business Process Management.
• Broad Functional experience in Automotive, Manufacturing, Finance and Health Care & Retail sectors.
• Experience in working with all the new feature of BW 7.4 and BW on SAP HANA, with all upgrade, migrate and integration scenarios from lower level version objects using the best modeling solution.
• Proficient in understanding the Next generation data base management system which is SAP HANA (In memory data base) and various use cases related to SAP ERP and SAP BW.
• Exposure and knowledge to latest versions of SAP HANA 1.0 SP 09 and various features in it.
• Good exposure and hands on experience with Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction), DB connect and Flat files. Good knowledge on SAP BODS connectivity’s, extractions and loading in to HANA Database and BODS core functionalities like Jobs creation and data transfer methodologies and Repository managements.
• Proficient in extracting the data from SAP R/3 system. Expert in LO Cockpit & Generic Extraction.
• Expert in design, develop on standard and custom Info cube, DSO objects, info object catalogs, Infoobjects, Transformation, Info package, DTP, Data source, Characteristics, Key figures, Multiproviders, Business content Installations, AODSO, Process chains, Semantic Partition Objects, Composite Providers.
• Worked on various planning models using SAP IP for Sales Forecast, Financial Forecast, Supply Forecast.
• Worked extensively on Business Explorer Suite tools -BEx Query Designer, BEx Web Application Designer, BEx Analyzer & BEx Web Analyzer and exposed the same to Business Objects Suite and Tableau.
• Excellent skill set in building queries using Reusable Query structures, filters, Restricted Key Figures, Calculated Key Figures, formulas, conditions, and exceptions.
• Create process chains and monitor data loads through email configuration and thereby reducing the frequent visit to production server.
• Extensively worked on Webi Scheduler and Precalc Server Set up and broadcasted reports to email.

Confidential

LEAD CONSULTANT

Environment: SAP BW 7.4 on HANA, HANA 1.0 SP09, SLT, BODS, BO AAO, BO Webi

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, and Reporting and Testing process.
• Deployed Function specs, Technical specs as per the Templates specific to Quality Standards.
• Installed LO extractors for Sales for Info Cubes, Info Source and Info Objects as per the Client Requirements.
• Created & Scheduled Info Packages and populated DSO objects & Info cubes with full update and Delta Update
• Worked on creation Queries, calculated key figures, Restricted Key figures, Structures, Variables to enhance the reporting features.
• Implemented conditions and restriction in the reports based on the requirements, Developed Workbooks.
• Designed and developed process chains for master data loads and transaction data loads
• Involved in User Manual preparation and End User .
• Created and maintained queries in BEx Query Designer, BOBJ Webi and BO Analysis Office for reporting.
• Shared knowledge to team members for different objects and maintained healthy people relationship management, to maintain teamwork.
• Attending day by day meetings like Internal Review Meeting, Quality status and Client Review Meetings.
• Interaction with Key Business Users to blueprint BW Planning Scenarios and various reporting needs.

Confidential

BW TECHNICAL CONSUTANT

Environment: SAP BW 7.4 on HANA, HANA 1.0 SP09, SLT, BODS, BOBJ AAO, Tabuleau, Design Studio, WebI

Responsibilities:

• Review the functional specification document with Business and Technical Architects to understand the current landscape, scope, connections and mapping document.
• Create and Migrate Data sources using Tables and Views for extracting Master and Text Data.
• Collected, released and imported the BI Objects from Development to Acceptance to Quality boxes
• Direct interaction with the business users
• Create and maintenance of Info Objects, DSO, WODSO, Cubes, Transformations, DTPs, Data Sources
• Created and maintained queries in BEx Query Designer for analysis and web reporting respectively which are published in Enterprise Portal
• Fine tuning of the performance issues by handling the indexes, aggregates and compression
• Shared knowledge to team members for different objects and maintained healthy people relationship management, to maintain teamwork
• Attending day by day meetings like Internal Review Meeting, Quality status and Client Review Meetings.
• Interaction with users to resolve BW reporting issues
• PSA Data Deletion on daily, weekly and monthly basis
• Involved in data validation to check report consistency with Data Targets and the source system.
• Detailed testingof SAPHANAdata modelling - Attribute View, Analytical View and Calculation view.
• Worked on currency conversion in HANA models.
• Used SDA (Smart data access) to access data from HPS Enterprise HANA views to PMT BW HANA Composite provider for integrated reporting.
• Used calculated columns, Variables, Parameters, Decision Tables and Restricted Columns.
• Used Open ODS and Advanced DSOs and Composite providers to integrate HPS data to PMT reports.
• Worked on Self-service reporting tools like Tabuleau (Visualization), BO AAO (Reporting tool).
• Designed the Data Model, Data Provisioning through BODS and Hi Fidelity Wireframe models for UI5 Report and Design Studio Reports.

Confidential

BW EXPERT CONSULTANT

Environment: SAP HANA, SAP BI 7.0, and SAP BW 7.4, SAP IP, BO AAO, and WebI, Design Studio

Responsibilities:

• Successfully Helped customers to their Requirements Elicitation.
• Active contributor in architecting solutions for the upgrade and migration from BI 7.0 to BW 7.4 on HANA.
• Plan, review and execute migration tasks for SAP BW pre-HANA functions.
• Experience withSAPHANAupgrade cockpit to handle data modelling, transformation and Reporting needs.
• Worked onQuick Sizer - a Web-based tool designed to make the sizing of the SAP BW environment.
• Participated in all phases of the customization process including Analysis, Design, and Coding, Test & Debug.
• Participated in project management activities including scheduling the development, test and release phases.
• Coordinating with BASIS for accommodating the changes in requirement.
• Check Master Data consistency before and after upgrade.
• Check inconsistencies with RSZ* Tables in BI and remove any inconsistency.
• Extensive performance Tuning of Data loads suitable for HANA database.
• Migration of all ABAP development work and related transformations routine.
• Good understanding and exposed to Precalc Services for Report broadcasting.
• Experience in automating Data loads using process chains and Meta chains for BW.
• Complete knowledge on User Authorization concepts in BW for restricted access in Reporting & View roles.

Confidential

LEAD CONSULTANT

Environment: SAP BW 7.0, BOBJ WebI, Design Studio

Responsibilities:

• Develop conceptual prototypes, identifying operational requirements, determining security architecture, data architecture and application architecture define and determine metadata strategy.
• Analyzing data acquisition and mapping, designing data transformations and cleansing.
• Involved in creation of various 4-tier operational Business Objects Design Studio dashboards and Webi Reports.
• Created top management dashboards for Finance, Sales, Procurement area with acute Business insights.
• Used standard and custom dashboard functions like print, email, save and refresh, back and clear functionalities.
• Interaction with Key Business Users to gather BW reporting needs.
• Used highly summarized data models like 10- dimensional info cubes and APD layers to stage data in BW.
• Maintained cache memory in BW system for optimum performance based on query usage statistical history.
• Customized ABAP code for variety of technical user parameters like default values, recently used, login authorization, user validation, hierarchy view, restricted data view by location and responsibility.
• Optimize the data model by Harmonization, Compression, Indexing and Consolidate techniques.
• Effectively include advanced features and additional functionality based on existing application Knowledge
• Select and Suggest salient features available in the technology to be used for the development of the system
• Understanding and documenting business definitions of data to develop the data model.

Confidential

TEAM LEADER

Environment: SAP BW 7.0, SAP APO, BEx Anayzer, Portal, Precalc Server, Non - SAP interfaces

Responsibilities:

• Solving the tickets raised by the users within the SLA Periods.
• Providing daily Production Support from Offshore (Approximately 60 Daily Loads)
• Resolving critical production failures & informing the client with reason & how it was rectified.
• Maintaining the Log sheets updated on a daily and weekly basis.
• Discussing the issues with Onsite Team members & plan for work on daily basis.
• Analysis of load performance issues and suggesting a solution to improve performance of loads and report.
• Monitoring daily and weekly running chains and resolving the issues.
• Testing of all developed solutions
• Re-initialization of business area in case of inconsistency in data targets.
• Worked on Dashboardreporting using Portal and BOE snapshot reports.
• Involved in transports of Info objects, Info cubes, ODS objects, Queries, Web templates from Development to Quality Servers

Confidential

LEAD CONSULTANT

Environment: SAP BW 7.0, SAP APO - SNP, BEx Anayzer

Responsibilities:

• Implementation of new Sales Inventory Operations planning process and report. The major functions are related to Inventory Handling, Demand Forecasting, Supply processing and Distribution networking.
• The major function is to generate Sales Inventory Operations planning report which help the user to control the flow of Supply Chain process.
• The Sales Inventory Operations Planning report enables the user to get the consolidated status of Demand, Inventory and Supply for each product of Honeywell Specialty Materials Fluorine Products business.
• Ensuring the development process is carried out by following Software Development Lifecycle (SDLC) procedures; milestones are met as per the schedule.
• Would be responsible to understand the ISC business process and effectively manage the project as per Honeywell Specialty Materials or PMT specific standards and guidelines
• Detailed study of client’s business strategies and goals to design architecture of the system for future scalability
• Design the system in such a way that Keane’s framework for Retail solutions would be utilized to the core thus leveraging maximum benefits of the framework
• Enhance the existing data cubes to include additional fields which are required for Sales inventory operations planning report
• Created Mega Sales Inventory Operations planning report and Mini Sales inventory operations planning report
• Plan, Improve & Modify the underlying architecture in the project to attain the direction of instant reports with instant data using BWA.
• Work & Modify existing reports from SAP BEx to SAP BOE Dashboardreporting using Portal and BOE.
• Map the APO (DP and SNP)data to BW online and make them available in reports for easy planning and tracking
• Performance tuning of queries using compression, aggregation and partitioning etc. and performance tuning of system to improve data load and system response time in order to achieve the value for business from BW.
• Grant restricted access to the users in Enterprise Portal to maintain strict view.

Confidential

LEAD CONSULTANT

Environment: SAP BW 7.0, SAP APO - DP, BEx Anayzer

Responsibilities:

• Design APO - DP Plan data movement process and prototyping data movement, designing Meta data process and designing technical environment and prototype technical components.
• Development of Function module to extract Demand Planning area from planning book.
• Create Planning Info objects and setup master data and add to Planning DSO and Info-cubes to store transactional data and transformation for mapping DSO and Info cubes
• Creating Multi-provider to combine forecast data and actual data
• Involve in transports of Info objects, Info cubes, ODS objects, Queries from Quality to Production Servers
• Help the users on understanding BW reports and customize instantaneously according their needs.
• Creating customized workbooks for users to execute the report.
• Creating a Remote cube to facilitate ad-hoc reporting and use for validation purpose.
• Manage the development environment, code and unit test the modules and establish integration.

Confidential

QUICK SOLUTIONS LEADER

Environment: SAP BW 7.0, BEx Reporting

Responsibilities:

• Worked on Enhancements Requests to modify DSO / Info cube / Reports
• Restructuring Existing cubes to include the Cost Model data from ECC.
• Develop custom extraction routines for FSCM loads and reporting from ECC.
• Develop O2C, P2P, B2R, Inventory Reporting for various business users.
• Modification to existing Data Source as per requirement
• Created and maintained queries in BEx WAD for analysis and web reporting to publish in SAP Enterprise Portal
• Developed Custom Generic Data Sources through Views & Work on BW objects to extract LIS/LO Cockpit, Generic, OLTP & Flat file extraction of real- time data from R/3.

Confidential

TEAM LEAD

Environment: SAP BW 7.0, SAP IP, BEx Reporting & Portal

Responsibilities:

• Develop Language dependant objects for multi users needs.
• Develop and execute IP based functions (standard and formula based) to meet customer needs.
• Find operational gaps in the project and assist the client by suggesting suitable ideas to resolve them.
• Actively involved in Unit Testing, PAT after Delivery and close the defects gap by transporting as required.
• Develop Reports, WAD and language dependant texts tightly integrated to the corresponding reports and queries.
• Grant restricted access to the users in Enterprise Portal to maintain strict view.
• Monitor monthly-jobs before account settlement process in process chains.
• Ticket based analysis for any production related issues regarding data coordination.
• Monitor Project performance on a weekly and monthly basis to maintain good health.
• Conduct project related for the team to check individual knowledge.
• Identify the working knowledge of associated systems lying with SPRING to know the architecture and technical details at the input and output nodes.
• Developed Custom Generic Data Sources through Views
• Worked with Early Watch Reports for improving the loading and Query Performance
• Extensively worked on end to end Testing using HP QC
• Interacted with Client very frequently understanding the requirement for creating various type of reports
• Worked with Performance related issues like Aggregates, Partitioning and Compression
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages
• Developed load strategy and created process chains to schedule the loads on daily, weekly and monthly
• Involved in setting up the procedures for extracting the data from ECC by using the LO COCKPIT and GENERIC extractions

Confidential

TEAM LEAD

Environment: SAP BW 7.0, SAP IP, BEx Reporting & Portal

Responsibilities:

• Full implementation of Projects Systems Data for BW reporting
• Design and Develop reports based on the specifications provided by the client
• Uploading master and transaction data from flat files and SAP cProjects
• Worked on Generic Extraction and Flat file Extraction & Testing of all developed solutions.
• Identifying the data in the source environment and Mapping the data to the BW environment
• Created and maintained queries in BEx WAD for analysis and web reporting to publish in SAP Enterprise Portal
• Worked on Dashboardreporting using WAD and developed Dashboard reports.
• Involved in transports of Info objects, Info cubes, ODS objects, Queries, Web templates
• Created the Process Chains to automate the loading process.
• Experience in automating loads using process chains and use of BW Monitor to supervise
• Monitoring daily and weekly running chains and resolving the issues.
• Played different roles like SCMA (Software Configuration Management Authority) and SDM
• (Service Desk Manager) proactively.
• As SCMA, involved in Project related QMS documents and Version Controlling and co-ordinate the Project Process Monitoring audits at Project level.

Confidential

BW ADMIN

Environment: SAP BW 7.0, SAP IP, BEx Reporting & Portal

Responsibilities:

• Capturing the information and producing the deliverables from the business requirements gathering sessions
• Understanding and documenting business definitions of data
• Developing the data model
• Monitor the data loads from various source systems like R/3, CRM, SEM and APO by means of process chains.
• Analyze the errors in the data loads and report to the corresponding team.
• Mange master data, text and hierarchies.
• Mange the data targets by having the correct and up to the date data.
• Reconstruct the data requests from PSA in case of data load failure.
• Roll up data from info cubes to aggregates, edit and maintain the aggregates.
• Re-initialization of business area in case of inconsistency in data targets.
• Study and analysis of cross transporting.
• Ensuring integration testing of data from various sources
• Documentation in the area of change management.
• Ticketing, which include investigation of error or any change request
• Documentation in the area of change management.
• Ticketing, which include investigation of error or any change request
• Played Quality Team Lead role to maintain the version control for the deployed code in production.
• Delivered the work items through the Software Quality Assurance process on time without any slippages.
• Providing Production data load support
• Publishing key data stored in BI through BI Web reporting

Confidential

Responsibilities:

• Bridge the IT-Business gaps, by developing Enterprise Architecture Models viz. Business Process, Business Rules, System Interface for various application systems thereby leading to Integration.
• Identify and depict the core purpose of an application system as a process model. Further drill-down of these high level models to individual processes.
• Depict the Business Rules of an application system in a model with useful information like Error messages, Field/ Form level validation etc
• Implement Sales and Inventory Reports for US & European Region
• Analyzed Business Objects Templates, Query and Reports and identified the gaps in the business requirements and functional needs.
• Designed the data migration steps from database to universe
• Involved in business meetings and discussions to examine the requirements.
• Conduct weekly status meetings