Dinesh
***********@*****.***
Experience summary:
SAP Certified Consultant Over 10 years of experience in SAP Native HANA and BW HANA/Business Objects and BW ABAP experience.
Capable of working in a group as well as independently with excellent communication skills. Strong production support experience, good at trouble shooting with quick turnaround in fixing the issues.
Experience in Requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
Extensive knowledge in Insurance, Health Care, Utilities,Oil and gas industries.
Worked in Object transport activities and resolved issues to move the Developments to live
Experienced in extracting data from SAP R/3 (FI/CO, MM, SD) and BW using different extraction structures and also Generic extractors (Table, View)
Experienced with implementation of SAP HANA projects, Data Provisioning using SLT, Modeling and Reporting, Writing PL/SQL Scripts and implementing Stored Procedures.
Hands on experience in HANA modeling. Experience in creating Attribute views, analytical view and calculation views.
Designing of HANA models for building an application for Sales Report, Pricing Report and Billing Report.
Configured and Extracted data from SAP ECC using BODS and SLT methods of Data provisioning.
Worked on HANA backend components like, composite providers, open ODS views, Advanced DSOs
Hands-on BI IP solution expertise, with ability to design in the BI IP Planning objects.
Experienced in BI-IP (Integrated Planning) tool – development of Real Time Infocubes, Multiproviders, aggregation levels, filters, planning functions, planning sequences Input ready queries and variables.
Active participation in all phases of BW/BI project including requirements gathering, modeling, design & development, extraction of data, reporting, performance tuning and deployment.
Created reports on external Databases using Smart Data Access (SDA from extracting data from external systems
Developed dashboard reports using SAP Lumira to include all the required KPI’s
Expertise in analyzing, designing, creating and maintaining InfoCubes, DSO objects, Openhubs, Multi Providers, Extract Structures, OLTP Extraction (Transaction Data, Master Data).
Expertise in Flat file, Generic DataSource, LO Cockpit, and COPA extraction
Experience in preparing the functional specifications document according to the business requirements and converting functional specifications into technical specifications document.
Expertise in using Query Designer, Analyzer and Web Application Designer for reporting.
Expertise in Performance tuning of Queries by maintaining Aggregates, Compression, Partition.
Created BO Reports on top on Bex Queries using BICS Connection
Monitoring of loads and handled the tickets raised by users.
Implementation of BW which includes Data-Modeling, Data Extraction, Generic Data Extraction, Data Loading, LO Cockpit, Bex Query, Expertise in Business content services
Involved in setting up the procedures for LO Cockpit, Involving Activating the Business Content Data Sources, Maintaining the Extract Structure, Generating the Data Source, Activating the Data Source and Enhancing the Data Source.
Performed many systems outages without any failure.
Reconciliation of data and coordination with the Informatica, Qlikview and BO Team for report issues and provided solution.
Managed a Team Size of six for 24*7 Production support work and responsible for or Application support activities, Enhancement deliverables.
Defined LSA architectures in implementations for optimizing usage of standard business content.
Consumed BEx reports in Design studio
Expert in building HANA Enterprise and BW on HANA Landscape from Data Provisioning to Reporting.
Created Start Routines, Field Routines and End routines as per requirement.
Experienced in every phase of BW/BO project implementation (User requirements analysis, data modeling, Objects activation) and development in BW, enhancements using user-exits, query design and Implementation, Initial load from source systems, periodic update process chains.
Experienced in developing detailed design documents, technical design documents, dataflow diagrams, test plan documents for unit/acceptance/integration testing, user training documents, and production support documents.
Certifications
Completed AHM 250 (American Health Care Management) Functional certification.
Completed HANA C_HANAIMP141 Certification (Certification 015655571)
Education
Bachelor of Engineering in Information Technology Nagarjuna University.
TECHNICAL SKILL SET
Languages C, C++, SQL
Databases HDB, SQL Server 2012
Operating Systems MS-DOS and Windows NT/2000/2007/
ERP SAP BW 3.5/BI 7.0, 7.3, 7.4,SAP R/3, ECC 6
Reporting Tools Business Objects XI 3.1, 4.1, Webi, BEx
Visualization tools SAP Lumira 1.29, SAP Design Studio 1.5
Tools Remedy, Service now ticketing tool, Track It.
Professional Experience:
Client: Orora Packaging solutions
Role: Sr SAP HANA Consultant
Duration: July 17 till date
Environment: SAP BW 7.5, ECC 6.0 Ehp6 and HANA 1.0 SP09,SP10,Analysis for
office, BEX Query Designer
Responsibilities:
Developed Sales order status reports,Delivery status reports on top of Information views.
Worked on Pricing conditions and derived Open quantity and delivered quantity that involved complex condition.
Involved in scheduling stored procedures using HANA XS engine and troubleshooting the related issues.
Developed Sales Rep Invoice reports using stored procedures and automated them.
Extensively worked on Scriped Calculation views.
Client: Irvine Company
Role: SAP HANA Consultant
Duration: May 17 to July 2017
Environment: SAP BW 7.4, ECC 6.0 Ehp6 and HANA 1.0 SP09,SP10,Analysis for
office, BEX Query Designer
Responsibilities:
Developed Calculation views by joining ECC tables and SQL Server tables.
Improved data loading performance by using recursive process chain methods.
Created Analysis for office reports on top of HANA Views.
Extensively worked on ADSOS and Composite Providers.
Client: GE Industrial solutions
Role: Sr SAP HANA Consultant
Duration: Sep 15-Till date
Environment: SAP BW 7.4, BO 4.0, Oracle, ECC 6.0 Ehp6 and HANA 1.0, SP09, SP10,
Informatica, Qlikview
Description: GE Industrial was a division of General Electric. It provided a broad range of products and services throughout the world, including appliances, lighting and industrial products; factory automation systems; plastics, silicones and quartz products; security and sensors technology, and equipment financing, management and operating services.
Responsibilities:
Used SAP FI, SD, and MM data to build HANA information models for user consumption (Calculation Views).
Experience on SAP Native HANA Data Provisioning Data Replication, Modeling and Reporting
Involved in creating information models for FI scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios.
Migrated Attribute and Analytic Views to Graphical Calculation Views.
Created Custom Views on top of ECC on HANA and BW on HANA as per the requirements.
Built Composite Infoproviders using BW HANA optimized Infoproviders along with HANA Views
Created custom tables in HANA database for maintaining monthly snapshots of the report.
Worked extensively with SQL scripting using calculation views and attribute views.
Created incidents, OSS messages with SAP regarding the issues with the tool/application.
Transported HANA Views from Dev to Quality
Experience in creating Variables and Input parameters in the Hana calculation views and assigning master/transaction data tables for the LOVs
Experience in utilizing the Visualize Plan (Planviz) to optimize the HANA Queries thus achieving better reporting performance
Implemented Recursive process chains dynamically taking input from TVAR table.
Great experience in BO integration testing and created dashboards using design studio.
Requirement gathering and analyzing scope of performance improvement in existing applications
Handled many outage activities without any failures.
Provided new solution without disturbing existing solution.
Handled weekly CAB calls and successfully moved approved CR’s to production
Client: Express Scripts International
Location: Parsippany, NJ
Role: SAP BW HANA Consultant
Duration: Sept 13 to Sep 15
Environment: SAP BW 7.0,7.3, 7.4,BO,R/3,Cognos,Mainframe. BEX Query Designer, Informatica, Design Studio.
Description: Express Scripts provides integrated pharmacy benefit management services including network-pharmacy claims processing; home delivery pharmacy services; specialty pharmacy benefit management.
Responsibilities:
Developed many sales and Insurance specific reports using BEX Query Designer.
Involved in getting the user requirement from the business for the new enhancements and converting into techno-functional document for the developers.
Organized end user training and preparation of training manuals
Created dashboard reports using Design Studio to display the total sales for the previous year based on regions
Worked on Dashboard Designer and Design studio(1.4)
Created dashboard reports using Design Studio to display the total sales for the previous year based on regions
Created of WebI reports using BEx OLAP connection (BICS connection)
Migrated BW into HANA in a Sidecar Implementation
Developed Universe using IDT (Information Design Tool) on different types of data sources.
Responsible for 24*7 Production support and enhancement tasks.
Working with SAP BI and BOBJ Business users, Project managers, and involved in requirement gathering, analysis and creation of best practice architecture.
Created SAP Business Objects SAP BW 7.3 Roadmap document, functional and technical specifications for seamless integration and reporting.
Worked with SAP BO, BI, Basis, and R/3 teams and involved in providing integrated solutions.
Replicated Table Structures and data from source system to HANA Studio using SLT server for FI-GL reports as part of HANA implementation.
Implemented complex HANA models for various CRM reporting requirements using HANA sidecar implementations.
Worked closely with functional and business team on implementing the first HANA data models to improve critical reports performance.
Created complex Calculation views by using SQL script and Graphical Interface.
Created BO- webi reports directly on calculation views of SAP HANA.
Worked on SAP HANA Security including user management, roles (SQL roles and Repository roles) and privileges. Created and modified packages for the roles and transported to corresponding systems.
Built interactive and visually appealing analytics in Design Studio using Rich set of controls buttons, list boxes, drop-down, crosstabs and charts
Published and customised many Insurance reports as per requirement.
Created Transient, Composite providers on HANA Views using BW Modelling on HANA.
Creation of Real Time Infocubes, Multiproviders, aggregation levels, filters, planning functions, planning sequences Input ready queries and variables.
Translated the business KPIs into dashboards and defined the dashboard layouts.
Created Information models for ECC tables on HANA Studio and created variables, calculated columns, applying filters and worked with input parameters.
Client: Medco Inc
Location: Franklin Lakes, NJ
Role: SAP BW/BO Consultant
Duration: Aug 12 to Sept 13
Environment: SAP BW 7.0, BO,R/3 Cognos,Mainframe, Informatica. BEX Query Designer
Description: Medco is a US Pharmacy Benefit Manager. Medco provides pharmacy services for private and public employers, health plans, labor unions, government agencies, and individuals served by Medicare Part D Prescription Drug Plans.
Responsibilities:
Translated functional specs into technical designs and submitted to P&G board for review.
Provided detailed estimates for design and development activities.
Conducted weekly development meetings with the team to monitor progress..
Developed Info cubes, DSO’s and multi providers as per the project requirements.
Performed OLTP Extraction from SAP R/3, Oracle tables and views into BW using Generic data sources.
Created of WebI reports using BEx OLAP connection (BICS connection)
Extract the data from SAP ECC from SD, APO, MM, FI/CO,PS systems by using business content and generic data sources.
Provided necessary help to SAP Basis team to configure RFC connections between ECC and SAP BW System.
Created front end and back end design documents
Created custom defined ABAP programs to generate flat files in the application server as per the customer naming convention guidelines.
Created Start routines, end routines and field routines.
Client: AXA Group solutions
Location: Winterthur, Switzer land
Role: Sr SAP BW/BI Consultant
Duration: Aug 11 to Aug 12
Environment: SAP BW 7.0,R/3, and Mainframe. BEX Query Designer,
Description: AXA is a French multinational insurance firm headquartered in Paris that engages in global insurance, investment management, and other financial services.
Responsibilities:
Involved in installing Business Content for standard info objects, Info Sources, and Info Cubes.
Completed Insurance Specific knowledge transfer sessions in client’s place (Switzerland) and imparted the gained Business knowledge .
Populated custom Info Cubes by using Generic Extractions from Z tables.
Responsible for BI core Insurance applications, which are required by the agents and sales professionals for day-to-day business.
The applications are created for monitoring the periodical sales activities, analysis of profit center.
Developed various BI objects like Info objects, Info Cubes, Data store objects, and Multi providers as per requirements.
Daily meetings with the onsite team and coordinating the work among the team members.
Involved in transportation of objects and performed Business Acceptance Test in Quality system.
Designed and developed process chains for master data loads and Transaction data Loads and these Process chains are scheduled for periodic loads.
Extensively involved performance maintenance like Info cube compression.
Client: IBM Global Services
Location: Bangalore, India
Role: SAP BW Consultant
Duration: May 08 to Aug 11
Environment: SAP BW 3.5, R/3. BEX Query Designer, WAD
Responsibilities:
Responsible for full cycle implementation, requirements gathering, solution recommendation and organization and fulfilment of resources. Responsible for system setup, configuration, data model, data mining and development.
Involved in business content installation. Involved in business meetings concern to requirement gathering.
Performance issues like line item dimensions, compression of info cube and rolling up the
Creation and maintenance of aggregates, Partitioning and extensively worked on improving performance.
Involved in unit testing, Integration testing and prepared test cases for UAT.
Handled Transport activities from Development to Quality and resolved Transport errors.
Involved in the cutover activities for Go-Live.
Tracing problem to ECC and resolution, setting multiple source systems including flat files.
Written Start Routine and end routine at Transformation level.
Thoroughly testing the Data loads and reporting execution time in Testing phase.
Prepared Impact Analysis document
Worked on Transformation routines and field level routines as per the requirement.
Involved in Performance Issues like Creation of aggregates, Partitioning and compressed the Info cube to improve the query performance
Extracted data sources from SAP R/3 using ‘LO’ extraction and generic extraction.
Designed and developed process chains (RSPC) for transaction data Loads and these Process chains are scheduled for periodic loads
Maintenance of documentation for all the new developments, the production support issues resolved, daily log of the Process Chains, Process followed, Issues faced and Learning for further reference