SUMMARY:

• A Competent professional with more than 14 years of experience in SAP HANA, BW, ABAP, BPC.
• Worked on native HANA projects, SAP BW projects, BW/4HANA or B4HANA Hybrid scenario projects, S4HANA Embedded analytics projects and BW - BPC integration projects.
• Worked as Techno functional lead for HANA/BW Implementations, for various domains like Pharma, Utilities, Healthcare, Retail, Finance, Sales and distribution.
• Designed & developed various SAP HANA information models like Attribute views, Analytic views, Calculation views, Analytic privileges, Roles, Stored procedures, SQL scripting, Table functions, SDA/SDI Flow graphs, XSJS, XS jobs, Java Script, ODATA services, HANA XS Advanced (XSA), HDI containers, XSODATA, custom tables in SAP HANA Studio and SAP Web IDE.
• Extensively used HANA SQL Script imperative language features like Variable Declarations, Control statements like IF statement, CASE, looping statements (FOR), Arrays, Cursors, Triggers, Exception or Error Handling, window functions, System views, Library functions, PAL, AFL, BFL, Sequences and Dynamic SQL.
• Performed complex Hana modelling using Joins (Temporal and Dynamic), Union, Rank, Currency/unit conversion, Hierarchies, Calculated/restricted columns, Variables/Input parameters, HANA application Life cycle management (HALM), Change and transport system (CTS), Import, Export, Multi-level partitioning (Hash and Range), performance tuning and analysis using Visualize plan, Expensive statement trace, Diagnosis files, Delta merge.
• Created SAP BW advanced DSO’s (ADSO), Composite providers, Open ODS views, Hana analysis process (HAP), Master data Info objects, Star schema, Process chains, Data store objects (DSO), Info cubes, Multi providers, Info sets, Virtual providers, Transient providers, Analytic indexes, APD’s, Open hubs, Aggregation levels, Transactional/Planning info cubes.
• Extensively worked on SAP BW Transformations, DTPs, Start, End and Expert routines, Field level routines using HANA SQL Script, ABAP runtime, SAP HANA Runtime, ABAP Managed data base procedures, object-oriented ABAP, Error handling, Error stack, Master data attributes, Texts, Hierarchies, Debugging, Monitoring, Full and Delta loads, security, roles, transports and LSA++ architecture.
• Developed BEX or BW Queries, Restricted Key Figures, Calculated Key Figures, Variables with User Entry, Default Value, Replacement Path, Customer Exit, HANA exit, Formulas, Filters, Default values, conditions, exceptions, cell restrictions, Exception aggregation and non-cumulative key figures.
• Developed simple and advanced ABAP CDS views (Core Data Services) using several annotations, advanced ABAP CDS table functions, VDM’s (Virtual Data Models) using HANA SQL Script.
• Created Basic (Fact & Dimension), Composite and Consumption CDS views (Core Data Services) along with Query views and ABAP Managed CDS table functions (AMDF) using S/4HANA embedded analytics.
• Very good knowledge and understand of SAP HANA Analytics Cloud (SAC), S/4HANA cloud, SAP cloud platform cockpit (SCP) WEB IDE and Business Application studio (BAS).
• Used various data provisioning methods like SLT, SDA/SDI, BODS, Files and various SAP BW extractors LO, COPA, Generic extraction, Data source enhancement, ODP-ODQ and DXC.
• Experience working on data lake and pulling data from various sources using several adapters like Big data Hadoop and perform data transformation and data ingestion.
• Worked on reporting tools like Business objects (BOBI) Analysis for Office, WEBI, Crystal reports, Design Studio, Lumira and Tableau to create reports and dashboards.
• Experience on business requirements gathering, functional specifications, technical specifications, blue print, effort estimations, design, architecture, implementation, unit and integration testing, support and maintenance, agile SCRUM methodology, sprint execution, JIRA.

PROFESSIONAL EXPERIENCE:

Confidential, Burlington, NC

SAP HANA Consultant

Responsibilities:

• End to End native Hana implementation of Confidential turnaround time project.
• Designed and architect complex, custom HANA solutions end to end, translating complex requirements in an optimal HANA design and created De-normalized tables in HANA to provide better analytical capabilities with star schema model.
• Experience with real time replication into HANA with SDI (Smart Data Integration) work flows to transform data from source to target using adapters such as Hadoop, DB2 & Oracle.
• Created stored procedures to load the data from one table to another de normalized table.
• Used SQL script imperative programming language features like arrays, exception handling and inserted the record counts, error messages into log tables.
• Unloaded the data from main memory and moved to the secondary storage, for historical cold data, leaving the hot and warm data in main memory.
• Partitioned tables using multi-level partitioning techniques like hash in the first level and range partitioning in the second level, to improve the query performance.
• Developed table functions, to implement percentile/window functions and consumed them in the Hana calculation views.
• Passed input parameters, filters to the lowest table level in table functions using advanced SQL script features like Dynamic SQL, Apply filter.
• Extensively worked on the performance improvement of the calculation views using plan visualizer tool and M SQL PLAN CACHE tables.
• Created complex calculation views and used various alternative ways to RANK node to ensure filters are passed to the lowest table level.
• Transported the objects from one development to quality, stage and production using native HANA application life cycle management HALM).
• Created xsjs java script files and xs jobs to schedule the stored procedures on daily, weekly and monthly frequency.
• Debugged stored procedures in HANA Web IDE using break points and analyzed the data in the intermediate scalar variables and table variables.
• Created analytic privileges and implemented row level security using classic and SQL analytic privilege options.
• Created unique key index on top of the data base tables to improve the performance.
• Analyzed the performance of the Query/Calculation views using Explain Plan and make use of the Visualization Plan tools to graphically analyze the execution plan and where the process takes more time. Deep dive of logs and trace files and analysis of expensive statements.
• Developed advanced Java Script code to schedule multiple xsjobs in parallel and reduce the time to load the data into the denormalized tables.
• Used dynamic SQL features, to pass input parameter selections of calculation views into table functions.
• Developed various BODS Designer Components- Projects, Jobs, Work flows, Data Flows, Scripts, Data Stores and Knowledge on Data Quality Transformation.
• Scheduled BODS jobs for batch loading of data on daily, weekly basis using BODS CMC.

Confidential, Malvern, PA

SAP BW/HANA Consultant

Responsibilities:

• End to End native Hana implementation of sales order fill rate project.
• HANA Architect & delivery lead of project, that accounts to 1.7 Million of Revenue.
• Replicated ECC data into HANA using SLT (SAP Landscape Transformation Replication Server) and extracted non-SAP data into HANA using SAP BODS.
• Developed Calculation views and table functions on top of the base tables in SAP HANA.
• Delivered high performance analytic dashboards using Tableau.
• Used ETL tool Talend to load the data from non-SAP source systems.
• Developed table functions and used standard SQL functions & user defined scalar functions to perform intermediate calculations.
• Created stored procedures to stage the data into custom tables, to avoid performance issues.
• Created several complex calculated columns to meet the business requirements.
• Translated functional specifications into technical specifications and ensured a comprehensive data warehouse design.
• Extracted data into BW using ODP (Operational Data provider) extractors.
• Created advanced DSO’s, open ODS views and composite providers.
• Provide ongoing support of the existing BO Reporting, Data Services and BW systems.
• Implemented various performance tuning techniques in HANA.
• Transported objects from development to quality and production using SAP HANA Life cycle management CTS (Change and transport system).
• Retirement of various BW models and implement the model and logic in native HANA.
• Single point of contact for sales order fill rate reporting for entire North America.
• Extracted data from various S4/HANA systems (Simple Finance, Simple Logistics).
• Very good understanding of SAP S4HANA Embedded Analytics Architecture.
• Created Query views on top of composite ABAP CDS views and consumed in SAP Lumira.
• Created users, analytic privileges, roles and assigned roles to users to implement security in HANA.
• Extensively worked on SAP BW reporting tools like BEX analyzer, BEX Query designer, work books.
• Created Restricted Key Figures, Calculated Key Figures and Variables with User Entry/Default Value, Replacement Path and Customer Exit, Formulas, Filters, Default values, conditions and cell restrictions.
• Created advanced DSO’s, composite providers, open ODS views, Hana analysis process (HAP).
• Extensively worked on DTPs, Transformations, Start, End and Expert routines using HANA SQL Script.
• Involved in Transactional/Master data loading, Scheduling, creation/monitoring of process chains and resolving of various data load errors.
• Experience in transporting BW objects from Development to quality and Production.

Confidential, Neenah, Wisconsin

SAP HANA Consultant

Responsibilities:

• HANA Architect & delivery lead of project, that accounts to 1.0 Million of Revenue.
• Created custom tables in HANA with UNIQUE Index and performed multi-level partition with Hash partition in the first level and Range partition in the second level.
• Unloaded the tables from memory, for historical cold data and loaded into memory when required, based on Dynamic Tiering hot, warm and cold data principles.
• Created input parameters and variables to filter the data and also Used “Procedure/Scalar Function” to populate the default values of the input parameters.
• Created various calculated columns, restricted columns, counters wherever necessary.
• Used temporal joins to model the data, based on time dependent master data attributes.
• Performed delta merge operations on tables to merge the committed entries from the table’s delta storage into its main storage.
• Created Level Hierarchies and Parent Child Hierarchies in HANA.
• Used several system views in HANA like object dependencies, change entries and SQL plan cache.
• Developed Sequences to generate sequential numbers and used in procedures to avoid complex loops.
• Implemented Currency/Unit conversions in HANA using standard currency conversion tables.
• Scheduled BODS ETL jobs to Load data into SAP HANA Database from source system.
• Designed data flows in SAP BO Data Services for different source systems and merging them.
• Collected all the HANA content/modelling objects into change request and used Application Lifecycle Management to attach the objects to SAP transport request through SAP CTS (Change & Transport System) and transported modelling objects from development to quality and Production.
• Technical design and development of the HANA information models.
• Developed 6 high quality reports for immediate business needs.
• Successful Go Live for 15 markets and received feedback from the business as one of the reports with highest number of business users.
• Coordinated business analysts and onsite/offshore team members to deliver the project on time without any customer escalations.
• Received several appreciations from the customer for the effective communication and high-quality deliverables.
• Used advanced SQL scripting like dynamic SQL, arrays, cursors and developed scripted calculation views.
• Developed table functions and stored procedures for moving the data from one table to another table.
• Developed customized input parameters and complex calculated columns to handle key business requirements.
• Developed several Graphical and SQL Script calculation views.
• Developed Analysis for office reports and Fiori dashboards.
• Implemented Analytic privileges for row level security.

Confidential, Cherry Hill, New Jersey

SAP HANA Consultant

Responsibilities:

• End to End Hana implementation of American Business KPI project.
• Onsite delivery lead of VDM phase1 project, that accounts to 1.2 Million of Revenue.
• Replicated tables from ECC into HANA using SLT (SAP Landscape transformation).
• Gathering requirements from business by conducting product backlog sessions.
• Followed Agile SCRUM methodology with 3 weeks sprint execution time.
• Proposed architecture based on the functional design of device management, revenue, Accounts receivable, tax and customer service.
• Replication of base tables from ECC into SAP Hana using SAP SLT.
• Developed various performance tuning methods like Union Pruning via Pruning configuration table, Join Pruning using “Optimize Join Columns”, Union pruning via constant selection and improved Performance of the calculation views.
• Created Calculation views (Cube & Dimension) based on the nature of the data.
• Created scripted calculation views for scenarios not possible with graphical approach.
• Developed complex calculated columns to handle various revenue categories.
• Developed AO reports on top of the HANA information models.
• Created Fiori tiles using ODATA Services generated from the Hana calculation views.
• Generated ODATA services for various KPI’s of the American Business.
• Consumed SAP HANA information models in the SAP BW system using virtual provider and built historical data snapshots.
• Fetched data from the SAP BW DSO’s into SAP Hana views, for end user fiori reporting.
• Handled performance related issues of the calculation views.
• Published BOBJ reports to the portal, for easy access to the users through BI Launch pad.

Confidential, Collegeville, PA

SAP BW/HANA Consultant

Responsibilities:

• Implementation of the BW/4HANA Hybrid scenario.
• Implemented BW implementations using advanced Layered and Scalable architecture (LSA++).
• Consumed BW info providers in HANA combining native HANA models with BW data models using composite provider, in B4HANA hybrid scenario projects.
• Implemented HANA based BW transformations and created SQL Script (AMDP) ABAP Managed Database Procedures and ABAP managed data base functions (AMDF).
• Developed complex dashboards using design studio tool.
• Delivered 3 phases of EIS reports to reduce the inventory levels at the site and market levels.
• Migration of the database from Oracle to the SAP HANA after upgrade.
• Involved in the pre cutover activities of the HANA migration.
• Used SAP best practice of System creation via production copy (“safe side”) approach.
• Designed BO WEBI reports for info providers using BICS connection.
• Involved in Unit testing, System testing and User acceptance testing.
• Involved in Customer presentations from Onsite and working on the modifications.
• Worked on the conversion of selected info cubes and DSO’s to “In memory optimized”.
• Actively participated in the post migration activities.
• Removal of unnecessary info cubes to improve the query performance.
• Consistency check of various objects of BW after migration to the HANA database.
• Created planning cubes, aggregation levels using SAP BW Business planning simulation (BPS).
• Enhancement of the existing master data & transaction data extractors.
• Building interfaces like APD’s for the outbound systems like AURORA & LEGS.
• Created the Safety stock optimization dashboard for the inventory analysis.
• Created the BOBJ transports in the development system through Central Management Console (CMC).
• BOBJ transport movement from development to the quality and production systems.
• Created various BOBJ reports for the LEGS project using WEBI as front-end tool.
• Worked on the BW related ABAP, wherever customizations are necessary.
• Worked on end-to-end implementation of the Historical inventory project with BW as back end and BOBJ tools at the front-end reporting.
• Educating the end users and provide the necessary training in accessing the newly created BOBJ reports through BI Launch pad.
• Interacted with users in understanding the requirements and build SAP BW data flows and BO reports.

Confidential, Charlotte, NC

SAP BW/BPC Consultant

Responsibilities:

• Design and develop the BPC reports and input schedule according to business requirements.
• Loading Transaction Data using a Flat File, NW BI Info Cube using Standard Data manager Packages.
• Exposure in extracting data from Heterogeneous data sources like R/3 BI servers
• Created Data manger packages for data loading activities and used to call script logics to perform complex calculations.
• Created multiple models and dimensions based on business requirements.
• Maintained master data and created required properties in Dimensions.
• Prepared the Business user training manual for interfaces have done.
• Provided user training about to explain planning templates.
• Involved in preparing technical documentation for all BPC objects.
• Created the technical specifications from the functional specs received.
• Worked on EPM reporting to drill through from balances to line items.
• Exposure in extracting data from Heterogeneous data sources like R/3 BI servers.
• Transported various objects from Development to Production.
• Performed the regression testing to check the consistency of the data in special use system.
• Worked on the SPO’s for different partitioning criteria.
• Prepared the Business user training manual for interfaces have done.
• Involved in preparing technical documentation for all BW objects.
• Created Process chains for loading both Master data and Transaction data
• Worked on creation of roles and authorizations to business users.
• Report development according to technical specifications which includes Hierarchical functionality, prompts, formatting features of the tool.
• Development of objects like info cubes, DSO’s, SPO’s and Open hubs.
• Transport repackaging during go live time.
• Sending Effort estimates for the new change requests.
• Developed complex reports using query designer and reported through WEBI and Bex analyzer.
• Involved in Performance Issues like Creation of aggregates, Partitioning and Compressed the Info cube to improve the query performance
• Created Process chains for loading both Master data and Transaction data
• Created transformation and conversion files to import data into BPC from data in any format from any source system.

Confidential

SAP BW Consultant

Responsibilities:

• Created the technical specifications from the functional specs received.
• Writing Test Scripts, conducting Unit Testing and documenting the results.
• Worked on EPM reporting to drill through from balances to line items.
• Exposure in extracting data from Heterogeneous data sources like R/3 BI servers
• Transported the objects from Development to Production.
• Performed the regression testing to check the consistency of the data in special use system.
• Worked on the SPO’s for different partitioning criteria.
• Prepared the Business user training manual for interfaces have done.
• Provided user training about to explain planning templates.
• Involved in preparing technical documentation for all BW objects
• Involved in Performance Issues like Creation of aggregates, Partitioning and Compressed the Info cube to improve the query performance
• Created RKFs, CKFs, and Variables with User Entry/Default Value, Replacement Path and Customer Exit, Formulas, Selections, Structures, RRIs, Authorizations, Filters and Web templates.
• Created Process chains for loading both Master data and Transaction data
• Worked on creation of roles and authorizations to business users.
• Report development according to technical specifications which includes Hierarchical functionality, prompts, formatting features of the tool.
• Development of objects like info cubes, DSO’s, SPO’s and Open hubs.
• Transport repackaging during go live time.
• Sending Effort estimates for the new change requests.
• Developed complex reports using query designer and reported through web and Bex analyzer.
• Updating the Process Chain status in the portal.
• Performing pre & post implementation maintenance activities, when there is a system down time for maintenance.
• Experience in transporting objects from Development to Production.
• Handling CRs for enhancing the process chains, data flows and queries.
• Resolved the reporting related defects and coordinated with the users.
• Handled post cutover and pre cutover release management activities.