SUMMARY

• 15 years of IT Experience in SAP which includes Embedded Analytics such as SAP Native Hana, BW/4 Hana ABAP on HANA, SAP Analytics Cloud and Business Objects (BO) following ASAP methodologies in various domains like Healthcare,Retail, Process and Manufacturing Industries.
• Successfully led multiple BI teams and implemented several large accounts of Enterprise on Hana,SAP BW/4 Hana, S/4 Embedded Analytics, SAP Analytics Cloud,BO, (SAP FIORI, TABLEAU, SAC) Projects .
• Responsible for the Technical Architect & Design S/4 HANA, SAP HANA, SAP BW/4HANA, SAP SAP Analytics Cloud project development lifecycle from project preparation, Business Blue Print, realization, final preparation, requirements gathering, functional technical design documents, development, unit testing, Integration testing, Use Acceptance Testing, Go - live and post Go-live support, Cut-over Strategy, UAT testing, postproduction support, and business user training..
• Specialized in Analytics and reporting along with extensive work on the areas of Sales and Distribution (SD), and controlling (CO), SRM, CRM, HR, PP, Materials Management (MM), Inventory Management (IM) and Enterprise Warehouse Management (EWM) and have in-depth business process knowledge.
• Proven experience with providing Proof of Concept (POC) for S/4 HANA, SAP BW/4 HANA and SAP Native HANA with latest Technologies.
• Expert in optimizing views, ETL, Data modeling/warehousing, Data analysis/visualization in SAP Analytics Could. Specializing in Business Intelligence developed through years of technology contracting and consulting roles in large organizations across a diverse range of industries including construction, manufacturing, and retail.
• Expertise on: SAP BW/4 HANA, Advanced DSO(ADSO), Open DSO Views, Transient Providers, Composite Providers, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA.
• Experienced S4HANA developer with strong knowledge in CDS views, Fiori APPs and also BOBI, SAC tools.
• Extensive Knowledge on building HANA views, SLT, SDI/SDA and ETL process using Data Services
• Having good Project management experience, project planning, resource planning, resource estimation, project cost and managing the finances of the project, Migration projects, upgrade projects.
• Led teams across broad technical, financial and business disciplines. Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results.
• As a Lead Architect, demonstrated excellent technical, strategic and interpersonal skills as well as effective communication, leadership, team dynamics and issue resolution capabilities.
• Strong success track helping clients implementing large and complex solutions which best suits their needs.
• Defined processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.

TECHNICAL SKILLS

Database Technologies: HANA, MS SQL Server

ETL Tool: SAP BW/4 HANA, BODS SLT,SDA,SDI

Key Technical Competencies: S/4 HANA, SAP BW/4 HANA, SAP HANA Modeling, SAC,Power BI,Tableue

PROFESSIONAL EXPERIENCE

Confidential

Project Lead

Environment: B/4 HANA,S4HANA, SAC

Responsibilities:

• Participated in Development, Documentation, Requirement analysis, End user documentation, Data extraction, Data modeling, Reporting and Production Support.
• Created stories and Dashboard on SAP Analytics Cloud using BW/4 HANA and CDS views.
• Delivered solution using both the Onshore & Offshore model; streamline the delivery model to deliver value to the customer; managed work load, priorities, schedules, etc. based on the team capacity.
• Experiencd in data modeling and preparing datasets, merging, appending, custom hierarchies, custom calculations, groupings, formatting values, data wrangling, dimensions and measures
• Experienced in creating stories canvas, responsive, grid, Smart Discovery, advanced story designing blending data,formulas, cross calculations, input controls, linked analysis
• Good Exposer in visualizations and their usage charts, tables, maps, filters, dropdown menus, hiding functions, interactive objects, pictures.
• Successfully optimized SAC Dashboard as per business requirements, which was not working in multiple model approach.
• Interacted with functional team and source system owner's regarding data, requirement gathering, Designed technical, Data mapping design documents from business requirements.
• Experienced in developing S4HANA ABAP CDS Views to support BOBI/Fiori APP Reports and Extractors for ETL process.
• Worked on & enhanced standard CDS Views delivered by SAP to fulfill customer specific reporting requirements.

Confidential

Project Lead

Environment: B/4 HANA,S4HANA, SAC

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Interacted with client stakeholders, functional team and source system owner's regarding data to understand business processes and requirements.
• Designed specifications for solution components, evaluating various options (Installation of standard objects, enhancements to existing objects and creation of custom objects)
• Prepared detailed implementation plan with timelines, Executed project as per plan, and ensure defect-free delivery of solution on-time
• Worked with other technical SMEs to develop long-term strategy for sustainable and flexible reporting architecture on top of SAP BW/4HANA and S/4 HANA.
• Supporting users for their reporting needs in the different business areas of Confidential (Trading Business, Finance, and Sales). Enhanced master (Customer, Material) data extractors to meet the new report requirements.
• Reviewed existing BW standard documentation to add some recommendations. Architecting a solution for supporting a requirement for BW/4HANA.
• Designed simple to complex data flows as per the requirement using most of the BI objects (Infoobjects) and infoproviders (Composite Providers,aDSO’s,OpenODsview’s etc.). Used ABAP for transforming some of the HR data to support report level calculations.
• Designed BEx queries for MM, SD, FI and Turnover reporting. Reviewing the existing adoch reports and calculations to work on re-designing them.
• Created generic data source for custom requirement and enhanced data sources as required.
• Built a strong data foundation for finance reporting which involved integration of goods movement and billing conditions data. Defined rules in the logic provided to support tax reporting. Worked on fixing process chains issues while transporting them from one system to other.
• Solving MS-excel export issues from the BI portal. Monitored Process Chain on a Daily basis.
• Prepared estimations for BW implementation activities including Content and CRs for the entire life cycle of project.
• Delegate tasks deliverables for each developer and coordinate activities during realization between
• Customer and Developer.
• Created Advanced DSO’s using eclipse-based modelling using different Model template approach.
• Created Composite providers consuming multiple ADSO’s or ODS view’s by UNION & JOIN functionality.
• Co-ordinated with the Business users for the UAT testing and accommodate the changes in the flow.
• Involved in transporting the BW objects from development system to QA for unit testing and integration.

Confidential

Hana Embeded Analytics Project Lead

Environment: S/4 HANA, WEBI, SAC

Responsibilities:

• Requirements gathering and business meetings to understand Business requirements and identifying gap analysis, and also Involved and organized AS-IS discussions with process owners and end users
• Interacted with functional team and source system owner's regarding data, requirement gathering, Designed technical, Data mapping design documents from business requirements.
• Worked as offshore Technical Lead, which involves ownership of project delivery by handling SAP HANA, technical team members.
• Worked on data modelling for FI, SD, MM modules into S/4 HANA.
• Experienced in developing S4HANA ABAP CDS Views to support BOBI/Fiori APP Reports and Extractors for ETL process.
• Worked on & enhanced standard CDS Views delivered by SAP to fulfill customer specific reporting requirements.
• Experienced in using ABAP components such as Data Dictionary, Table control, Screen Painter, Menu painter, ABAP Query, structures, domain, data element, table maintenance and ABAP CDS in ABAP dictionary, CDS Views, CDS authorization,Odata services creation for Confidential apps SAP Netweaver gateway.
• Good Experience with SAP Hana Studio or Eclipse using the ABAP Development perspective to create and enhance CDS Views.
• Good Knowledge on Analytical CDS View Annotations used within Consumption Views to Aggregate, Filter, define Functions, etc. as well as to how to perform additional view Associations.
• Good Expertise on how to integrate CDS Views with Analytical Consumption Tools including SAP Analytics Cloud, Analysis for Office, Business Objects - Webi, and Fiori Tiles.
• Extensive Experience in analyzing complicated business process and creating Technical Specifications and providing Estimation for the requirements.
• Good communication and inter-personal skills, accustomed to work in a team environment with tight schedules and capable of working efficiently under pressure, manage multiple projects and cross train sub-ordinates in other Functional areas.
• Materials and Enterprise Warhouse management process workflow.
• SAP S/4 Functional knowledge in the areas of logistics Operations and Purchasing and knowledge of the associated tables and transactions.

Confidential

Hana Analytics Lead

Environment: S/4 HANA, WEBI

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development and Reporting and Testing process.
• Understand the requirements (both Functional and non-functional) by going through the specifications and with inputs from Functional Consultants in order to participate efficiently in the Design, Development and Testing phases of the project.
• Designing the application architecture and working closely with ETL team and reporting team to ensure that data flows in and out of HANA to efficiently meet the business requirements
• Worked as offshore Technical Lead, which involves ownership of project delivery by handling SAP HANA, SAP BODS technical team members.
• Participated in business meetings and worked with the functional consultants to analyze the client’s requirements and create Design document
• Developed technical specifications from the functional specifications as per the business needs.
• Worked on SAP HANA modeling (Attribute View, Analytic View, Calculation View), Analytical privileges, Calculation view methods(Graphical and SQLScript View), Stored procedures
• Worked on data modelling for FI, SD, MM modules into S/4 HANA.
• Hands on experience designing CDS Views using ABAP Scripting Editor used by S/4HANA Analytics & BOBJ BI tools
• Worked on & enhanced standard CDS Views delivered by SAP to fulfill customer specific reporting requirements.
• Created custom CDS Views and to satisfy reporting requirements.
• Good Experience with SAP Hana Studio or Eclipse using the ABAP Development perspective to create and enhance CDS Views.
• Good Knowledge on Analytical CDS View Annotations used within Consumption Views to Aggregate, Filter, define Functions, etc. as well as to how to perform additional view Associations.
• Good Expertise on how to integrate CDS Views with Analytical Consumption Tools including SAP Analytics Cloud, Analysis for Office, Business Objects - Webi, and Fiori Tiles.
• Having Strong analytical skills and able to define technical specifications, troubleshoot and debug CDS Views to fulfill business requirements.
• Translate the Business KPIs for Dashboards & Define the dashboard Layouts.
• Designing and Developing real time operational reports using HANA.
• Working with Calculation views of VDM's (Virtual Data Models)

Confidential

Project Lead

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering,
• Interacted with functional team and source system owner's regarding data, requirement gathering, Designed technical, Data mapping design documents from business requirements.
• Developed HANA information views calculation views; Development in SQL - like hdbdd artefacts, procedures, Table functions; Wrote SQL Scripts, stored procedures and integrate them in the views; Developing XSODATA as per the requirement of UI (Angular JS).
• Ability to write SQL scripts and stored procedures, function calls, designing tables, data loads, and building, modifying, and integrating into HANA views
• Strong Experience in Performance Tuning and Query Optimization. Identify bottle neck in performance in terms of reporting.
• Good Knowledge of HANA XS, JavaScript and developing User Interface with Angular JS.
• Hands on experience in using SAP BODS (Business Objects Data Services) and SDA (Smart Data Access) to extract structured/unstructured data from different source systems into HANA

Confidential

Project Lead

Responsibilities:

• Worked as offshore Technical Lead, which involves ownership of project delivery by handling SAP BW on HANA and SAP BO
• Supporting users for their reporting needs in the different business areas of Confidential (Trading Business, Finance, and Sales). Enhanced master (Customer, Material) data extractors to meet the new report requirements.
• Reviewed existing BW standard documentation to add some recommendations. Architecting a solution for supporting a requirement for BW/BI.
• Comprehensive Understanding of the HLD, DDD Documents
• Requirement Gathering and writing Functional specs
• Comprehensive Understanding of the Functional Spec Documents
• Involoving in Data modeling and Design and documentation
• Team work allocation and sending the weekly status reports.
• Using Webi for developing reports using BEX Queries and BICS connectivity
• Working on Dashboards by using SAP Lumira on Hana, BW on Hana
• Prepared and documentation for understanding of Dashboards and reports

Confidential

Project Lead

Responsibilities:

• Provisioned data ETL (SSIS) for SAP HANA which extracts data from flat file systems and load Sql server data to SAP HANA . The POC aims is to demonstrate the ability of the SAP HANA platform to enable accelerated delivery of analytic assets critical to effective, innovative patient care and sound healthcare administration.
• HANA MODELLING - Designing Views (Attribute View, Analytic View, Calculation View), Scripted Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters.
• Involved in various aspect of the software development in HANA i.e. data modeling, Languages such as SQL Script, .hdbtable syntax family (hdbview, hdbsequence,...), Procedures, HANA XS ODATA, Database procedures, security management (user & role creation), bug fixing.
• Worked on Solutioning of BO Reports on SAP BO WEBI 4.2 with SAP HANA 1.0 as Source.
• In Lumira: Connecting local datasource, Using HANA online as data source, Importing Datasets & Modifying them, Building hierarchies within datasets - Geographical Hierarchies, custom hierarchies, Using Compicated Direct SQL to extract datasets from various views in HANA, creating Visualization, filters in Visalization,Composing.
• Had conducted multiple Show and Tell sessions with customer during development phase to indentify and rectify the gaps in project Requirement.
• Displayed reports data in multiple reporting Tools like SAP BO WEBI/SAP Lumira for data validation .
• Delivered the reports with minimal function knowledge.(client doesn’t provide any functional knowledge)
• ON time delivery of reports within a short span of time (On Urgent Basis)

Confidential

Senior Consultant

Responsibilities

• Involved in report analysis of existing architecture at the Confidential Picture Entertainment (SPE) and Capgemini recommended approach for moving into S/4 HANA Finance in phased manner.
• Interacted with the Business Analysts for requirement analysis and created Functional Specification Documents based on the business requirements.
• Evaluated S/4 HANA Integration Frame work like SLT evaluations and Simple Finance Error Handling, Source System Integration, Alternative Integration Frame work, TMS Transport Management System, Integration Solution Management, Integration with MDG Master Data Governance.
• Involved technically in existing LOB system, which are integrated with SAP ECC as target system to receive their financial transaction at summarized level. They have developed 300+ Interfaces to integrate with LOB and third party to have inbounded and outbound data exchange.
• Evaluated non SAP systems integrated with existing Lob system and Interfaces, mostly interfaces designed to map standard process of General Account, Order to Cash and procure to pay. These have standard SAP field mapping to all field for different structure of multiple LOB System.
• Evaluated with existing LOB system to Simple finance migration and system retirement approach like Assess the benefits of rea-time operation reporting and analytics, Assess the benefits of pre-built-in Fiori UX and Business Cockpits, Catalog the ECC solutions by migration or new deployment, Determine the optimal process for migrating 1 to 1,Assess security integration, Assess strategy going-forward for Non-SAP systems

Confidential

SAP BW HANA Consultant

Responsibilities:

• Designed the Business Data Flows with SAP BW LSA++ Architecture using Composite Providers, Virtual Providers, HANA-Optimized Info Cubes & DSOs and Data Sources for the SAP BW on HANA DB Scenarios.
• Converted Several Standard Cube to In-Memory cubes.
• Worked on Agile mythology.
• Involved in forming ETL strategy for Data Loading (Initial/Delta Load) using SAP BODS
• Involved in source system study and designing phase of ETL load into SAP HANA.
• Involved in creation of ETL Mappings & Scripts using SAP BODS 4.1 to load billions of records in SAP HANA Data
• Displayed same report data in multiple reporting Tools like SAP BO WEBI/SAP Lumira/ SAP BO Analysis for Excel for data validation .
• Actively involved in Application performance tuning,implementation of SAP Best Practises,co-ordination with various technical teams within the project.
• Daily / Weekly Status Reporting meetings with Customer Senior Technical Management on Project Development.
• Conduct meetings with core team members to understand the business requirements and complexities in the system.

Confidential

SAP Consultant

Responsibilities:

• Supporting users for their reporting needs in the different business areas of Confidential (Agri Business, Finance, and Petroleum). Enhanced master (Customer, Material) data extractors to meet the new report requirements.
• Reviewed existing BW standard documentation to add some recommendations. Architecting a solution for supporting a requirement for BW/BI.
• Designed simple to complex data flows as per the requirement using most of the BI objects (Infoobjects) and infoproviders (Multiprovider, Infocube, DSO etc.). Used ABAP for transforming some of the HR data to support report level calculations.
• Designed BEx queries for HR Headcount and Turnover reporting. Reviewing the existing HR reports and calculations to work on re-designing them. Created cubes and DSO’s objects for petroleum business. Performed a system wide BEx query clean-up.
• Created generic data source for custom requirement and enhanced data sources as required.
• Built a strong data foundation for finance reporting which involved integration of goods movement and billing conditions data. Defined rules in the logic provided to support tax reporting. Worked on fixing process chains issues while transporting them from one system to other.