K.

Sreedhar
SAP HANA / BODS/ BW/ BI Consultant
Sap.erptech99@gmail.com
Phone: +91-7041263566

Summary:
• Having around 8 years of experience in SAP HANA (4+ yrs.), SAP BODS (4+ yrs.) and SAP BW.
• Expertise on HANA, BODS, SLT, SDA, DXC and Information Models.
• Design, implement, and deploy SAP HANA solutions to achieve defined business goals. .
• Extensively involved in Sap Hana, Bods Pre and post activities.
• Extensively involved in Implementation, Maintenance and Support Projects.
• Developed complex mappings in Data Integrator to load the data from various
sources into the Data Mart, using different transformations like Query, Table Comparison, Merge, Pivot, Reverse Pivot,
Lookup, Key Generation, History Preserving, Date Generation, Map Operation and Validation etc.
• Experience in SAP BW with Sap Data Services and Data Integrator as an ETL tool
• Extensively worked in Analytical View, Attribute View, Calculation View, Analytical privileges, SLT, BODS
integration with HANA.
• Experienced in consuming BW models in to HANA and HANA Models into BW.
• Extensively worked on Open ODS View.
• Extensively worked on Business objects ETL tools such as Data services Designer, Data services Server Manager, Data
services Repository Manager and Data Services Management Console in developing the data models.
• Worked in SAP BO Universe creation, Information Designer Tool, Web Rich Client. Crystal Reports, Lumira.
• Good Communication and Interpersonal skills with the ability to interact with end users, Managers and technical
personnel’s.
• Extensively worked on ECC ALE, Idocs,LSMW and BAPI’s.
• Have good management skills.

Technical Expertise:

SAP HANA SKILLS:

• Expertise on SAP HANA Analytical View, Attribute View, Calculation View,
Analytical privileges.
• Expertise on consuming HANA models
• Expertise on combining custom tables and HANA standard view.
• Expertise on creating a Calculation View using Join, Union and Aggregation.
• Expertise on creating a Calculation View on Attribute view and Analytical view.
• Expertise on inner, left outer, right outer, full outer, text join, referential join.
• Expertise on ECC report pulling from SAP HANA data base using RDS.
• Expertise on extracting data from ECC data to SAP HANA using SLT.
• Expertise on extracting data from different source systems to SAP HANA
Using BODS.
• Having knowledge on SAP HANA Architecture

SAP BODS SKILLS:

• Data Extraction can be done by using SAPBODS3.x, 4.x and configuration different DATASTORES for SAP ECC,
SQL SERVER.
• The Approach for designing the jobs are Construction Job, Load Job..
• Have intensive skill in implementing ETL process from extraction of data from legacy systems to loading in targets like
SAP R/3 system (Using Data services, LSMW programs and standalone custom ABAP programs) after transformation.
This includes analysis and development of mappings and transformations in SAP BODS.
• Developing Reusable and Optimized data flows, work flows, Transformations and Mappings based on the
specifications.
• Extensively worked on Data Services Designer Components-Projects, Jobs, Workflows, Data Flows, Data Store,
Formats and Functions – Custom and standard.
• Experience in Data Quality components of BODS including address cleansing and duplicate matching functionality
• Good knowledge on Data Profiling, Cleansing and de duplication.
• Good knowledge on IDOCS and BAPI.
• Exposure to SQL language and writing queries. Also have good working knowledge on ALE/IDocs.
 • Functional knowledge in MM and FI (AP, AR, and GL) Modules of SAP.
• Have worked with functional team analyzing the requirements and finding the best possible approach to implement
them.
• Experience in reviewing the Functional specifications and Functional mapping designs, attending walk through
discussion.
• Have worked on documentation process (preparing Technical Designs, Unit Test Plan etc.) while developments.

SAP BW/BO Skills:

• Expertise in creating and maintaining Data sources, Info-Objects, Transformations, Info cubes, Data Store Objects,
Data Transfer process, Multi providers, Virtual Providers, Info sets.
• Installed the Business Content Info objects, Info cubes, Info sources as per the requirements.
• Handled errors in Error Stack and then scheduled to Data Targets by using Error DTP.
• Expertise in Data Loading (Full, Initial, Delta Upload), Scheduling, Monitoring.
• Extensively involved in BW object for Transfer rules, Update rules, Info cubes, Operational data store object, Multi
providers, Info sets
• Extensively involved in Migrating Data Sources, Queries from Business Information Warehouse to Business
Intelligence.
• Extensively worked on SAP BO Information Designer, Universe Designer, Web Intelligence Rich Client, Dash
Board Designer, Crystal Reports, QAAWS, and Live Office.
• Extensively worked on SAP BO Information Designer with SAP and Non SAP Sources.
• Extensively involved in creating of Relation and OLAP connections, Data foundation and Business Layer.
• Extensively worked on Prompts, Filters, Functions, Merging, Sub Reports, Variables, Ranking, Tracking in Web
Rich Client.
• Extensively involved in creating Static and Dynamic Dash Boards.
• Extensively involved in creating Dynamic Dash Board using Query Browser.
• Extensively involved in creating WEB I reports on BEX reports.
• Extensively involved in creating Parameters in Crystal reports.

Work Experience:
• Working in Compact Softech Pvt. Ltd., Ahmedabad as a Sr.Software Engineer from Aug,2018 to Till Date.
• Worked in Proffer Information Systems India Pvt Ltd., New Delhi as a Sr.Software Engineer from Sep.2017 to
Aug,2018.
• Worked in Analytix Data Services as a Sr.Software Engineer, Hyderabad from Jan. 2015 to Aug.2017.
• Worked as Consultant at ISoft Infotech Services, Mumbai from June, 2011 to Dec. 2014.

Education:
• Master in Computer Applications (MCA) from KAKATIYA UNIVERSITY.

Organization: Compact Softech Pvt.Ltd, Ahmedabad

Project Title: Bed Bath and Beyond
Client: Bed Bath
Role: SAP HANA/ BODS/BW Developer
Environment: SAP HANA, BW, SAP ECC, SQL Server, BODS 4.x, Flat Files.
Period: Aug’18- till date
Roles and Responsibilities:
• Creation of Attribute views, Analytic views and Calculation Views based on replication data using HANA modeler.
• Worked on Restricted, Calculated Measures, Variables and Input Parameters in Analytic views.
• Created Store Procedure using SQL Script.
• Creation of Analytic privilege to apply restrictions on the Information views.
• Restricted access to data by assigning relevant roles to users based on user profile.
• Created Information spaces in explorer based on HANA Information views.
• Worked on SAP SLT Configuration and Monitoring Dashboard to create schema, monitor tables, monitor connections,
monitor statistics of tables.
• Worked on Hana studio to load, replicate, stop replication suspend and resume tables in Server based table data
provisioning screen.
• Creating different types of jobs in SAP SLT like Real time job, schedule by interval, schedule by time. Managing the
Replication Process Using the SAP HANA Studio.
• Worked on SAP SLT complex table structure changes (change data type or length, add or delete key fields) the trigger
and logging table have to be dropped and recreated. Also on HANA side dropped and recreated to ensure data
consistency.
• Developed Data Services job to pull data from SQL and Oracle into HANA database.
 • Worked with various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table
Comparison in Platform and DI Transforms and extracted data according to the business rules and Technical
Specifications.
• Used SAP BODS to pull data from SQL into SAP HANA.
• Transferring data from Replication servers to SAP HANA using SLT.
• Consuming Cubes, ODS’s into HANA.
• Consuming Hana models into BW using T.P and V.P.
• Based on the specifications, preparing the BODS Jobs and report to the client if there is any defect identified in the
specifications.
• worked on SAP BO Information Designer, Universe Designer, Web Intelligence Rich Client, Dash Board Designer,
Crystal Reports and Live Office

Project Title: Well Care Health Plan

Client: Well Care Health Plan Inc.
Role: SAP HANA/ BODS/BW Developer
Environment: SAP HANA, BW, SAP ECC, Teradata
Period: 2017-18
• Involved in requirement gathering for development, Data modelling and designing reports as per the requirement. Also
Involved in Installing BI Technical Content.
• Installed Business Content for standard Info objects, Info-Sets, Info-Cubes, and Multi-Providers etc.
• Worked extensively on Open hub, APD tools to download data to the Third-Party Tools from BW
• Performed analysis, design, development and implementation of standard/customized Info-Cubes and ODS Objects
• Responsible for planning cut-over activities for the go-live support for the development work.
• Importing KPI from legacy systems and ticketing systems to Power BI via SAP BW InfoCubes.
• Assisting the City’s user base to facilitate their jobs on the Portal for ESS (Employee Self Services) and MSS (Manager
Self Services)
• Publishing Reports on the Portal and creating new Web Templates in WAD for publishing on Portal.
• Created PL/SQL Procedures for large loads special for IS-U (Installation Facts, Contract Accounts)
• Created restrictions on objects and classes based on universes privileges, designed, developed and maintained Business
Objects Universes, generated List of Values (LOV's) from lookup tables
• Created user groups, users, database connections; manage user privileges, import/export of universes in production
environment
• Designed and developed standard reports and summary reports
• Extensively involved in creating of Relation and OLAP connections, Data foundation and Business Layer.

Project Title: Schroders, UK

Client: CGI
Role: Senior Software Engineer
Technology: SAP HANA/BODS Developer
Environment: SAP HANA,BW,ECC, SQL Server, BODS 4.0, BO 4.x and Flat Files
Period: 2016-17
• Primary responsibility of supporting for SAP HANA and BODS
• Expertise on SAP HANA Analytical View, Attribute View, Calculation View, Analytical privileges.
• Expertise on transferring data from Replication servers to SAP HANA using SLT.
• Expertise on extracting data from SQL Server to SAP HANA using BODS.
• Extensively involved in creating of Relation and OLAP connections, Data foundation and Business Layer.
• Interacting with the clients from time to time to discuss the open issues.
• Fixing the High and Medium priority tickets raised by users.
• ECOMPERSATION, MERGETRANSFROM and QUERY TRANSFROM.
• Based on the specifications, preparing the BODS Jobs and report to the client if there is any defect identified in the
specifications.
• Attending daily status calls and scheduled meetings for a code review and for clarifications with clients.
• Created WEBI reports using SAP BusinessObjects functionality's like queries, slice and dice, drill down, cross tab,
master detail and formulae's etc, exported BusinessObject reports to Web Intelligence XI R2 to be viewed by all users
on the Internet, created reports synchronizing data from more than one sources, conducted training for ad-hoc users
• Worked on both Load performance tuning and Report performance tuning by creating DB Statistics, Aggregation, OLAP
Cache, Compression, Indexes and Partitioning
• Extensively worked on SAP BO Information Designer with SAP and Non SAP Sources.

Project Title: Nordea FVP-FDW

Client: Nordea Bank
Role: SAP HANA/BODS Developer
Environment: SAP HANA, SQL Server, BW,SAP ECC, BODS 3.x,BO 3.x , Lumira
Period: 2015-16
Roles and Responsibilities:
• Primary responsibility of supporting for SAP HANA and BODS.
• Expertise on consuming HANA models.
• Expertise on combining custom tables and HANA standard view.
• Transporting objects using HANA Life Cycle Management.
• Well verse with SAP HANA Modeling using Different types of views, SQL, SQL Script.
• Extracted data from different sources such as SAP ECC, Flat files, SQL Tables and Views to load into HANA target
database.
• Expertise on SAP HANA Analytical View, Attribute View, Calculation View, Analytical privileges.
• Expertise on ECC report pulling from SAP HANA data base using RDS.
• Expertise on transferring data from Replication servers to SAP HANA using SLT.
• Expertise on extracting data from Non SAP to SAP HANA using BODS.
• Based on the specifications, preparing the BODS Jobs and report to the client if there is any defect identified in the
specifications.
• Attending daily status calls and scheduled meetings for a code review and for clarifications with clients.
• Created DDL’s, Acquisition and Consolidation Schemas, Views in SQL Server.
• Extensively worked on Prompts, Filters, Functions, Merging, Sub Reports, Variables, Ranking, Tracking in Web Rich
Client.
• Extensively worked on Lumira.
• Analyzed existing Universe and Database to enhance the existing Universe and created new Universe.
• Maintained and Enhanced Universes based on financial database.
• Created Alerts and implemented ranking in reports
• Worked on Web Intelligence to develop and publish thin client reports
• The design process included preparation of flow charts, entity relationship diagrams, designing table structures,
normalization/demoralization and defining integrity constraints

Project Title: Eneco,Nether Lands

Client: Sogeti
Role: SAP BODS Developer
Environment: BODS 3.5, SQL Server, Flat Files, Excel Files
Period: 2015
• Designing Data Flows for extracting data from various sources that included databases, flat files etc.
• Loading data from source files into ECC using IDOC and BAPI.
• Error Handling and creating error reports for reporting the errors in the data to the functional owner.
• Optimizing the long running jobs by using techniques like push down operations, use of Degree of Parallelism,
loaders etc..
• Maintaining standards (naming convention) and Quality.
• Using designer to create source definitions, design targets, create Data Flows and develop transformations.
• Creating Global variables, local variables and Substitution parameters as per the scenario respectively.
• Creating different transformations for loading the data into various database e.g. Query, case, Pivot, Table
Comparison, Validation, Merge, and Key Generation.
• Using BODS designer functions like Look up_ext, decode, Nvl, Gen_row_num functions to attain the required
functionality in the Functional specifications.
• Creating scripts in SQL using BODS Designer as per the requirement.

Project Title: Sales Data Implementation

Client: General Mills
Role: SAP BODS Developer
Environment: SAP BODS 3.x, BW, SQL Server 2008.
Period: 2013-14
Roles and Responsibilities:
• Configured and developed Data flows from Flat files and Oracle system
• Designed the TDs Specs for Designing the DS to BW data flow
 • Applied the Query transformation while loading the data into Target database
• Involved in Configuring the ETL projects into individual Data Services Repositories and maintained Data Stores, Job
Servers
• Identified the SAP Applications and map the data Flows in Data services and extracting the Data into Directly into
DSO object using data services
• Implementing ETL design best practices and formal code migration process
• Performance tuning existing BODI/BODS jobs
• Enhancement of existing BODI/BODS jobs
• Extensively involved in post implementation support of BODI/BODS jobs
• Actively involved in the BODS job Migration process from Development, Test and Production Environments.
• Extensively involved in client interaction & co-ordination from Offshore
• Prepared Unit Test Cases
• Migrated ETL Jobs into Test from Development environment

Project Title: Cost Center Data Mart Implementation

Client: Federated Department Stores, USA
Role: SAP BODS Developer
Environment: BODS, Business Objects XI 3.0, Oracle 10g
Period: 2012-13
Roles and Responsibilities:
• Worked as an ETL Developer to develop BODS objects & involved in the project from realization phase.
• Configured different repositories (Local, Central, and Profiler) and job server.
• Implemented security for Central repository by group and object level.
• Created Data Integrator mappings to load the complete copy of the legacy systems to a staging area.
• Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and
complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge,
lookup etc in Data flows
• Created Data Flows for cleansing master and transactional data.
• Used Data Quality transformations like US address cleansing for cleansing purpose of the master data.
• Configured the mappings to handle the updates to preserve the existing records using History Preserve Transformation
(Slowly Changing Dimensions Type-2)
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs.
• Involved in user training sessions for and assisting in UAT (User Acceptance Testing).

Project Title: ME DWH

Client: Murata Electronics, U.S.A
Role: SAP Consultant
Environment: SAP BW3.X, SQL Server 2005
Period: 2011-12
• Co-ordination with the Business Users to know the existing system, understanding and validating the requirement for
development.
• Creating ETL jobs to move data from heterogeneous source systems into SAP using Data Service (SAP BODS).
• Designing Data Integrator Jobs, Workflow, Data flows, Data Integrator functions and various transformations as part
of development.
• Extensively using Query Transform, Map Operations, Table Comparison, Merge, Case, SQL, and Validation
Transforms in data integrator in order to load data from source to Target Systems
• Worked on optimizing the performance of long running jobs used techniques like push down operations, Use of
Degree of Parallelism, collect statistics to monitor jobs etc.
• Responsible for performing and monitoring and Supporting Unit Testing activities in SAP environment