Now you can Instantly Chat with Ravinder!
About Me
Ravinder Singh has over 13 + years of experience in Implementation , Application Maintenance , Analytics Implementation ,SAP BI Consulting and project management . He also has strong Analytics skills specifically in Data Warehousing.Expert in rela...
Show MoreSkills
Portfolio Projects
Description
Summary of Roles & Responsibilities
- Technology used in the project , SAP BW with ABAP, SAP HANA , & small portion of BW4HANA
- Managing a project of 20 member team, roles and responsibility involves planning different phases of project ( design , development , testing & Go- Live phase , resource management and project financials .
- Experienced in Requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
- Assessed project requirements defined by customer, including desired reports and performance expectations. Involved in Business blue print and technical specification. Developed Technical Design Documents including GAP Analysis.
- Architecting reporting requirements into BRD (Business requirement Document), technical design and development as per SAP Standard practice.
- Data Extraction - Expert Data Extraction from ECC and experience on enhancement and creating generic data source.
- BI Design - Info Cubes design, Info Sources, Info Object maintenance, ODS Objects, ADSO, Info sets, Hierarchies, Multi providers, Composite Provider, Update rules, Transfer rules, Info Packages using AWB. Proficient in Data modeling using BW extended star schema models.
- Experience in Hierarchies, Authorizations, BW Statistics, Archiving, Process chains and Open hub. Worked on Data Extraction from 3rd Party Tools, like Data Stage.
- BI Reporting - Experience in Design and Development of Queries, Reports, Workbooks, Business Explorer Analyzer, Query Builder, Info Set Query, Web Reporting, RRI and Broadcaster.
- Worked on Performance tuning of Queries (SAP BW) by maintaining Aggregates, Compression, partition, indexing of info cubes and use of statistics for the same. Developed reports using different performance variables such as filter and prompts for better report functionality and quicker response time`.
- Worked on Performance Tuning of Data Loads.
- Expert in APD’s (Analysis Process Designer) Solutioning
- ABAP - Reporting, User Exits, Customer modifications. OLTP Extraction from SAP R/3 into BW using different extraction structures. Functional expertise in SD, MM, PLM & Data Stage Extraction, In-depth knowledge of reporting flow from R/3 to SAP BW.
- Expertise on HANA Views, Calculation, Attribute & analytic views.
- Created HANA Views to provide cost visibility for all cost center and cost elements related to total conversion cost (fixed and Variable) across all client manufacturing plant sites.
- Expert on HANA ALM tool which is used for capturing native HANA transports, expert on BW Transports management, Rev-Track.
Description
Project Responsibilities:
- Playing a Role of Technical Architect for BW (Suit) & HANA.
- Technology used in the project , SAP BW with ABAP, SAP HANA , & small portion of BW4HANA.
- Provided expertise in functional and technical architecture design for the entire solution and for all integrations built within an Accenture clientele IT system.
- Explored packaged software gap resolution options.
- Developed Hana views for client problem statements.
- Acted as a subject matter support (SME) for performance tuning of the production system.
- Participated in client code migration pre – requisites training.
- Conducted requirement analysis of major IT application HR modules.
- Implemented the Object Data model and workflow process.
- Participated in production deployment.
- Acted as a subject matter expert, utilizing understanding of technical architecture design of complete landscape.
Description
- Technology used in the project , SAP BW with ABAP, SAP HANA , & small portion of BW4HANA .Played a role of technical architect, which involves Designing solutions and implementing.
- Led a team for requirement gathering and preparing HLD high level Design documents
- Included proposed solution to TDD technical detail documents.
- Involved in Management side of project which involves planning the resources for development and deployments activities.
- Extensively worked on APD’s (Analysis Process Designer) Solutioning.
- Developed and enhanced User Exits and customer exits for report requirement, worked on performance tuning.
- As a part of continuous Improvement of the project, worked on performance tuning of data loads.
- As a part of continuous initiative implemented solution for improving Process chain load time and fixed issues which was causing Process chain failure at regular intervals.
- Created a POC for Credit risk flow which was developed in BW 7.0 and we have moved the flow on BW on HANA objects.
- Performed cutover activities in production before Go-live.
- Given a Demo to client for final solution and trained users how to use the tool.
Description
Project Responsibilities:
- Technology used in the project , SAP BW with ABAP, SAP HANA , & small portion of BW4HANA.
- Responsible for Requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
- Assessed project requirements defined by customer, including desired reports and performance expectations. Involved in Business blue print and technical specification. Developed Technical Design Documents including GAP Analysis.
- Inscribed BRD (Business Requirement Document) and TDD (Technical Detail Document) for project.
- Designed the solution for data extraction from Sap and Non- SAP sources to show logical view of data in reports.
- Designed & implemented, ADSO’s, Composite Providers, Routine, Hana Views, completed data model and BEx reports for KPIs.
- Created Automation of D4SA reports for Canada and USA, D4SA reports was generated manually by users.
- Handled Cutover activities before Go live.
- Supported Users during UAT and interacted with users for defect closures.
- Supported Hyper care for two weeks.