SUMMARY

• Sr. SAP Consultant with 10 Years of experience in analysis, design and development of SAP BW/BI, HANA, BODS, BOBJ applications.
• Expertise in SAP HANA Platform Edition, SAP HCI, BW, BOBJ & BODS. Worked in 4 full life cycle implementations, support of SAP HANA based solutions including Data Modelling, SAP ECC, SAP Data Services, SAP Business Warehouse (BW), and SAP BI/Business Objects in large and complex environments.
• Experience as a BW HANA Consultant working on HANA studio along with multiple data provisioning - Data Services and SLT, DXC to extract data from SAP and NON-SAP systems.
• Extensively worked in Implementation, Maintenance Production Support projects and have in-depth exposure in technical as well as functional areas like CRM, SRM and ECC includes SD, MM, PP, PM, QM and FI/CO and HR modules augmented by strong testing skills acquired from various project experiences.
• Extensively worked on ECC Logistics data extraction for SD, MM Inventory, PP etc.
• Extraction from (CRM, SRM, Logistics, SD, MM, FI, PP, HR and Generic): Source systems (SAP, Non-SAP like SQL data using DB Connectivity, Web Services, and Flat File).
• Extensively worked on BO data services designing data flows, BO reporting with Webi, Crystal reports, Explorer.
• Extensively working on BW on HANA new developments creating HANA models, and Optimized BW modelling objects like Advance DSO, Composite Providers, Open Views etc. Rectifying the alerts on HANA studio.
• Worked on Integration Planning BW-IP by developing Real-time (Virtual) Cubes, Planning Functions, and making available the Planning Data and developed the Planned Report.
• Extensively worked on Performance tuning at 3 levels in SAP BW - Database level resolving table space issues, Modelling level-data loads performance optimization and Frontend Report level - Query optimization.
• Maintaining Cutover Steps post and pre transportation of SAP objects used for development and enhancements.
• Transports include Transportation of BI/BW and R/3 Objects, collected objects in Development System and transported throughout the System landscape using Revtrac.
• SAP HANA Database revision upgrades, refreshes and data base Administration (fine tuning, parameter changes, memory configurations, and start/stop).
• Involved in Full life software development lifecycle (SDLC) implementation of Business Intelligence applications using SAP BI/BW, HANA & BO (UDT, IDT and WEBI).
• Extensively Worked on Smart Data Access (SDA), defining Joins, Attribute view, Analytical views, calculation views, entity views, table functions, SQL procedures, formula functions and other calculations and restrict measure.
• Worked on development, maintenance, and heavy customizations on ETL tools like full loads, Delta loads.
• An enthusiastic, highly self-motivated, Excellent Technical, Interpersonal and solid communication skills with the ability to interact with end-users and managers and Experience in requirement gathering and Training End-users.

TECHNICAL SKILLS

Languages: Python, R, MATLAB, SAP ABAP, Java, C & C++

Software and Tools: SAP ERP, SAP BI /BO/ PI, SAP MM/ SD/ FI / QM, Eclipse, HANA

Reporting Tool: BEx, WAD, BOWEBI / XCELSIUS/ BOE/ Design Studio/ Crystal Reports

Cloud Platform: SFDC, IBM Watson Studio, AWS, COLAB

Data Base: MySQL, DB2

API: Tensor Flow, Keras, SAPI

Web Services: SAP ABAP WS, Java WS, Apache WS

PROFESSIONAL EXPERIENCE

SAP/HANA Consultant

Confidential

Responsibilities:

• Understanding the functional and business requirements by participating in User discussions.
• Preparing project specific technical specifications, DTP design documents, unit test documents and estimation of efforts required for new change requests.
• Extensively involved in end to end development from CRM area to BW system.
• Worked on new developments on BW on HANA system creating HANA views calculation view, analytical view and reports.
• Rectifying the alerts or issues on HANA system.
• Extensively worked on logistics extraction of SD, Inventory, MM, PP, HR other modules. Worked extensively on creating Badi's, User exits, Function Modules for customized ECC and CRM Data sources, transformation routines, end routines, start routines, DTP routines, Field routines customer exits.
• Worked intensively on upgrading SAP Systems - ECC 4.6 Ver to ECC 6.0 and SAP BW 7.0 Ver to SAP BW 7.3 Ver which includes managing ECC system delta loads cleaning and re setup.
• Extracted the third-party data (SQL data) through DB connectivity and flat file data to BW system.
• Developed WebI reports and Bex Reports for business use.
• Developed process chains as per the requirement and maintained auto-scheduling of process chains which includes - ECC background jobs as well as ECC events auto trigger.
• Collecting the Objects in transport requests for which changes made in ECC, CRM and BW and importing them across landscapes (from development to QA and Prod accordingly).
• Handling the Level 3 support issues within agreed SLA's which include analysing (RCA) and resolving any data load failures, break fixes in production, performance issues, and support issues
• BO Upgrade from XIR2 to BI 4.1 SP05 P4 and responsible for applying service pack and fix pack to BO installation and deployed WAR files after upgrade.
• Transferred CMC data between old (XIR2) to new version SAP BI 4.1 SP05 P4 either through CMC/BIAR File/Import Wizard.
• Apart from promoting info objects, used Life Cycle Manager to create, copy, Edit and scheduled a job.
• Validate the installation by checking the public folders, Reports in Personal folders, Groups, Row level security, Scheduling and by running some sample reports.
• Create a repository and security domain with user groups and security implementation.
• Designed and developed SQL SPs and absorbed /consumed from BO WEBI and Design Studio.
• Designed and developed various complex logics in SQL And SQL SCRIPTS to achieve the output faster and in efficient way.
• Created Universe on the GLOBAL Data warehouse involving thousands of tables and various SPs.
• Used optimised SQL queries to see the Universe doesn't have Traps and Loops.
• Well-versed in all the SQL statements like DML, DDL and functions, which make Development tasks very fast and optimistic.
• Migrated the Sales, Customer, Billing, Material and Open Orders data table from SQL Server to Hana 1.0 using SQL Queries.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users, creating and publishing reports and implement Folder and object level restrictions.
• Helped design processes for deployment and migration of customer reports from development to testing to production.
• Assist with the creation of the Business Objects XI environment addressing best practices, process and tool questions and documenting the technical information.

SAP BI/BO Development Lead

Confidential

Responsibilities:

• Manages and develops the developments of reports in Business Objects which include managing a team of in house and third-party developers, leading a team and working largely on own initiative.
• Contribute to creation of requirement catalogues and High-Level Designs.
• Produce Detailed Designs (Functional & Technical Specifications) that meet the agreed requirements and are deliverable and supportable.
• Produce project estimates in line with defined estimating models and processes.
• Interact with management and business Decision-makers to identify business requirements. Documented the reporting needs of the Business Service and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Responsible for analysing the scope of Requirement and the Impact analysis for all major enhancements & incidents.
• Prepared functional and technical specifications based on the business requirements.
• Attended MIM (Major incident Management) calls and meetings to update the status of the major incidents.
• Extensively worked on Business Information Warehouse Info Cubes, DSO's, Info Objects, Multi providers, Data Sources, Transformations and DTP's.
• Extensively used Open Hub Service functionality to distribute data from SAP BI to other non-SAP data systems.
• Expertise in maintaining Process Chains & Meta Chains for automating data loads.
• Extensively involved in creation of BEx Reports. Worked on Calculated Key Figures Restricted Key Figures, Free Characteristics, Filters and Customer Exists.
• Good understanding and experience of various components of SAP HANA,
• Extensively Worked on SAP HANA Data Modelling using Attribute Views, Analytic Views and Calculation Views (both Graphical & SQL script based) & SAP HANA Data Provisioning using SAP LT Replication Server (SLT).
• Extensively worked on Analytical Privileges, Procedures and decision tables.
• Extensively involved in writing SQL scripts in HANA Studio
• Extensively worked on BICS for accessing SAP BW 7.0 queries to Webi Client.
• Was part of testing when is system upgraded from SAP Business Objects 4.0 to 4.1.
• Conducting training for Business users on SAP BI BEx Queries and help them build adhoc queries.
• Extracted the standard Business Content as well as worked on creating Info Sources, InfoObjects, and Infocubes, ODS Objects, transformations and process chains.

BI Development Lead (Business Objects)

Confidential

Responsibilities:

• As a BI Development Lead manages the development of reporting in BusinessObjects which include managing a team of in house and third-party developers. This is a Work Level 5 role which involves leading a team and working largely on own initiative.
• Contribute to creation of requirement catalogues and High-Level Designs.
• Produce Detailed Designs (Functional & Technical Specifications) that meet the agreed requirements and are deliverable and supportable.
• Review designs, Plan and manage the build phase from colleagues, partners and 3rd parties ensuring all designs (specifications) are consistent with Boots Business Objects development standards.
• Produce project estimates in line with defined estimating models and processes.
• Assist with project go-live activities, pilot and issue resolution. Escalate issues to project manager in a timely manner. Identify issues and risks, suggesting appropriate action. Monitor development against plan and costs.
• Liaise with other projects and teams to integrate solutions, and participate in peer reviews. Do quality reviews of all products, or ensure these are done. Assist in the production of test plans, including for systems developed by partners and 3rd parties; plan, prepare for, manage and carry out the testing. Ensure that quality & defect logs are maintained.
• Carry out, or oversee, unit testing. Provide guidance to support teams in the resolution of production incidents. Assist with the production of the Service Definition Documents as required.
• Provide knowledge transfer to support. Develop strong relationships with peers in the business and in IT
• Adhere to Boots Performance Leadership guidelines. Line management of developers
• Lead and motivate your team, providing coaching and guidance. Ensure your team are clear on their responsibilities, arrange regular 1-2-1’s to offer feedback on performance and utilise Boots career development options.
• Inspire team to continually improve ways of working. Provide support for the team by arranging Team and Management meetings. Number of defects identified in test / production
• Compliance with Boots BusinessObjects development standard.

BW and BOBJ Consultant

Confidential

Responsibilities:

• Onsite technical consultant and lead responsible for client interaction for requirement gathering, design, build, and coordinate with team members in offshore
• Communicate with the Business for requirement gathering of Unit Cost reports like Gross Opex, Employment, Materials, Electricity, and Maintenance etc.
• Communication with other vendors for access and impact analysis.
• Create technical specifications from functional requirements.
• Build prototypes of the reports in test environment. Design prototype of the dashboard in Xcelsius.
• Responsible for designing Infocubes, DSOs and other Infoproviders and the related data flow, and development of BEx Queries using Customer Exit, Authorization, Replacement path and Text variables, etc. optimization of system performance if we use BEX queries.
• Responsible for creating BO Universe and Web I and crystal reports.
• Testing and transport to quality and production system. Coordinate UAT sessions.
• Maintain documents for all process followed during the implementation cycle.

BW and BO Consultant

Confidential

Responsibilities:

• Project lead responsible for interaction with the Business
• Communicate with the proponents on Requirement specifications
• Design high level diagram Responsible for migration of Infocubes, DSOs, DTP’s and other Infoproviders and the related data flow, Extraction using Standard and Generic data sources and development of BEx Queries using Customer Exit, Authorization, Replacement path and Text variables, etc. catering to PS Module.
• Manage user authorizations using BW Analysis Authorization
• Develop documents for each phase involved in project the life cycle.

SAP BI Consultant

Confidential

Responsibilities:

• Reconciliation the data in BW with the source system data
• Monitor Process Chains to automate the data load process
• Enhancements to the existing data flow.
• Attend daily, weekly calls and update Business on status.
• Attend CAB meeting for transports and get the approvals.
• Used SOLMAN to store documents, Raise CR.
• Raised fire fighter ID to perform activities.

SAP BI Consultant

Confidential

Responsibilities:

• Responsible for development of Queries and Workbooks.
• Creation of transport request and transporting them.Enhanced the process chains.
• Loaded the data into regional system from different sources and then from different regions to Global system in a timely manner so that the data is available in reports.Corrected data loading issues.
• Extracted the data from APO, R/3 and CORE (Oracle system), BI and flat files.
• Maintain mappings in DSO’s from location to business unit and business unit to end market.
• Transported the objects from development system to test system and then to production system.
• Worked with planning books to reconcile the data with BI and APO.
• Raised CR’s and updated the details of the CR’s in SOLMAN (Solution Manager).
• Successfully finished the transition of the project to WIPRO and still helping them and monitoring them in resolving issues and UAT.
• Scheduled the overall batch load schedule for the data warehouse, setting up batch jobs, triggering events, use of event chains.
• Created Info sources for Master Data and Transactional data, assigned Data Source to Info source, Created transformations, DTP’s.
• Conducted WebEx session for knowledge transfer.
• Implemented different reports to see the forecast accuracy and stability and also to analyse the SPOT orders based commercial and operational view.
• Studying the User requirements, Preparing High Level Technical Specifications, Preparing Technical Specification, Preparing Unit Test Strategies, Test Cases, Test Plan, Coding and Testing the Unit Test Plan, Documenting the Test Results and Train
• Aggregated the CUBES to see the updated reports.
• Included OCALQUARTER in Sales Orders and Billing Infocubes to improve the load performance
• Assigned the roles to the users so that they can view the reports in Portal (OneView).
• Worked on Reconciliation issues and resolve the data issues in BW system.
• Responsible for development of Queries and Workbook.

SAP BI Consultant

Confidential

Responsibilities:

• Used different extractors like, 0FI GL 6, 0CO OM CCA 9, 0EC PCA 1, 0FI AP 4, 2LIS 13 VDITM, 2LIS 02 ITM, 2LIS 02 SCL etc to extract data.
• Extracted data from Different source systems like SAP R/3, Flat Files, APO and Oracle system.
• Uploaded and downloaded the mapping data through FTP
• Created/ Modified Process chains to load master and transaction data.
• Scheduling, Monitoring the process chains and error handling if any.
• Maintaining G/L, Cost Centres and Cost Elements in Hierarchy.
• Maintained Mapping tables.
• Raised change requests (CR’s) based on user requirement.
• Part of Data refresh activities:
• Solved user queries for data discrepancy from R/3 to BI.Created info-packages and DTP’s to load the data.
• Reconciled the reports.
• Modified the existing reports based on user requirements.
• Created the users and assigned the roles based on the country.
• In order to improve the data load performance executed housekeeping activities like cube compression, creating indexes, PSA deletion (To improve the table space), Statistics etc
• Solved day to day data loading issues which occurred due to RFC, incorrect mapping, authorizations issues, etc

SAP BI Consultant

Confidential

Responsibilities:

• Created and customized DSOs, Infocubes, Info-Objects and MultiProviders and InfoSets.
• Attended CAB1 & CAB2 Meetings.
• Scheduled Daily/Weekly/Monthly data loads as per business requirement.
• Analyzed and corrected production problems also done the root cause analysis to avoid similar issue in future, raised Change requests and worked with SolutionCenter to resolve the issue.
• Uploading the documents in Solution Manager (SOLAMAN) for Change request, any new user creation or if the role of the user is changed.
• Resolved customer reported issues, contacted users through emails and phone for UAT.
• Extracted required master data from the Data Source to PSA to DSO object and then to the cube.
• Creation of Tickets at the time of load failures to keep the record of the error.
• Creating Info Package to create Process chains and Scheduling of data loading Full/Initialization/Delta upload methods
• Notifying the user on the success/failure of the daily or adhoc loads as soon as the activity is finished.
• Implemented OSS note to fix the issue. Contacted SAP to resolved critical issues.
• Debugged the Routine to fix the issue and was able to find the route cause and fixed to avoid it in the future.
• Also involved as a member with transition team as a SME (Subject matter expert) in the Transition Activity which was delivered to the third party vendor (WIPRO) and successfully completed the transition and involved in different phases of transition like primary support, secondary support, Hands on, and stabilization.
• Resolved reporting issues.
• Have done the data refresh activity during cutoff activity from production system to regression system.
• Reconciliation of data between R/3 data and BI data.
• Uploading data from PSA manually in to the data targets during the data load issues and performing repair full request.