SUMMARY

• 14 years of experience in software Industry as a SAP BI/HANA Architect.
• 8 years of experience in SAP HANA 1.0/2.0 and 3+ years of experience in SAP BO.
• 7+ years of architecting and building data systems working with teams as big as 80 and as small as 4 in onsite/offshore model.
• SAP Certified Application Associate - SAP HANA 1.0
• Strong and experienced team player, with excellent communication and interpersonal skills. Proven ability to work independently.
• Able to learn new technologies, concepts and Business processes quickly, evaluate their applications, and apply them to business need when appropriate.
• Involved in development and implementation of SAP BI. Worked extensively on various functionalities of BI. Assist in the solution architecture for a landscape that includes SAP S/4HANA, BI, BW, BPC, HANA, and Fiori.
• Expertise in RRB (Resource Related Billing) scenarios and in DIP profile configuration with multiple industry sectors
• Worked on SAP HANA implementation projects with both native HANA, SAP BW on HANA, BW/4HANA and S4 HANA.
• Worked on Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA 1.0
• Complete Migration of SAP Hana DEV, Test,, Production data from Microsoft on promises to Microsoft Cloud AZURE including building SAP Production system in cloud, installing Host agents, Diagnostic agents, SQL Server, Did Log transfer, and Cut over activities in power Confidential and Visual Studio environments.
• Experienced with SAP ERP data on On-Promise and Cloud Implementations.
• Experience with cloud infrastructure providers (e.g. AWS, GCP, Azure).
• Exposure on SAP ARIBA and S/4 HANA Connectivity with Cloud Integration Gate way(CIG).
• Participate and drive scoping and discovery sessions on customer SAP cloud initiatives.
• Architect secure migration methods to move workloads from On-Premises to defined cloud providers.
• Worked on installations of SAP HANA SDI configurations and SAP HANA cockpit environment.
• Experience with Data Virtualization, Azure Data Lake, Data Factory, HDInsight and Azure Analytics.
• Experience in SAP Business Objects Universe Design, Web Intelligence and Tableau report development. Knowledge on Big Data, Analytics and IoT technologies.
• Experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges.
• Experience with system setup, system refresh, client copies, TMS.
• Excellent knowledge and experience on: HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA, BW/4HANA.
• Good exposure to ABAP tools for S/4HANA - ADT for Eclipse, SAP core ABAP Data Dictionary and latest CDS views.
• Exposure on S4 HANA deployment options and knowledge of new S/4HANA features.
• Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and InfoCubes.
• Excellent issue resolution skills which are raised over BW on HANA migration.
• Experience in Importing BW models (Info Cube, DSO) in HANA as Analytical view.
• Good understanding and experience in providing security restrictions on models using Analytic Privileges and assigning to Authorization roles for different types of users in SAP HANA.
• Experience in Data-Provisioning techniques using SLT (SAP Landscape Transformation) to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.
• Expertise on BW on HANA, HANA LIVE VDM, HANA LIVE Browser, SLT, Information Models.
• Worked on all technical aspects of SAP BI and familiarity with right from SAP BI Administration Workbench.
• Proficiency in analysis, development, implementation of Standard / Customized Info Cubes, DSO, BEx Analyzer, BEx Browser.
• Extensive experience in creating/configuring Info Objects, Transformations, Info cube, Communication Structure, DSO, DTP, Error handling, Info packages, Scheduling, Monitoring.
• Worked extensively on Aggregates, Compression, Partitioning, Navigational Attributes to improve data load and query performance.
• Worked extensively on Extraction (Flat File, Business Content, LO Cockpit and Generic Extractions. Experienced in Activation and Installation of Business Content.
• Experience in creating Queries & Reports in BEx Analyzer, BEx Browser and Customized/Configured Queries using Calculated Key figures, Restricted Key Figure, Filter, Exceptions, Variables, Conditions and Structures.
• Experience in creating web reports using WAD.
• Experience in building Multi Providers as per query needs.
• Knowledge on Process Chains, Performance Tuning, Enhancements, Open Hub Service.
• Worked on SAP ERP green field implementations and designed SAP HANA solution architecture based on client needs. Solid understanding of HANA functional architecture/Infrastructure.
• Strong experience in OLAP/OLTP Data Modeling using Entity Relationship, Multidimensional/Star Schema and Extended Star Schema models.
• Development, testing, documentation, requirement analysis, End user documentation, Data extraction, Data modeling, Data loading, Reporting and Production Support.
• I have worked in Confidential Lab for SAP Solutions on SAP BW, SAP BO and SAP HANA as a core team member. During that period, I have supported them for CO-PA RDS solution for SAP HANA which is presented in SAP Teched 2012 Las Vegas as well.
• Worked on Creating Attribute Views, Analytical Views, and Calculation Views (Graphical, Script) using HANA Studio.
• Experience with SQL Script, PL/SQL, Stored Procedures, Function Calls, Designing tables, data loads and Core Data Services (CDS).Good exposure on XS Advanced features and capabilities.
• Worked on LSA++ architecture of BI 7.4 on HANA, BW/4HANA and tested all the functionalities for BW on HANA migration using DMO.
• Worked with LCM (Life Cycle Management Console) to Transport the objects in System Landscape (Dev, QA, and Prod).
• Having knowledge on creation of WEBI, Explorer, Dash Boards and Excel Reports on HANA Information Models. Created Universes using IDT and Reports using Xcelsius and WEBI on HANA DATABASE (BO XI 4.0).
• Having knowledge on Data Replications SLT and Business Objects Data Services.
• Having knowledge on Data Replication methods ETL (Data Services), Trigger Based and Log-Based Replication.

TECHNICAL SKILLS

ERP Packages: SAP R/3 version 4.6C, 4.7 Enterprise.

Data Ware Housing: SAP BIW versions 3.0B, 3.1c, 3.5 and B.I 7.5, SaP S/4 1610

OLAP Tools: SAP BI/BO 4.0, HANA SPS09/10/11, Webi 4.0

Operating Systems: WINDOWS 2000/2003/NT/XP

Data Bases: Confidential, DB2, Hadoop and HANA 2.0

Languages: ABAP/ 4, SAP HANA SQL Script

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX.

Environnent: SAP BI 7.4, SAP R/3 4.7,AWS and HANA 2.0

SAP ERP/HANA Architect/Consultant

Responsibilities:

• Extensively involved in Project design, roadmap, detail designs and Development approaches.
• Analyzed the requirements, by talking to the functional and end users of the reconciliation system and performed gap analysis.
• Established the best modeling and recommended strategies and architecture for SAP HANA.
• Built HANA information models (Attribute views, Analytical views, Calculation views, and Column/Row based tables) in HANA design studio for efficient data integration. setting-up, and knowledge of the Transport Management System (TMS) enabling changes throughout system environment.
• Defined web-based data access by building consumption models in HANA XSJS (server-side JavaScript) exposing HANA artifacts to client applications.
• Experience in working with BW4HANA with SAP and CDS Views and extractors and SAC reports.
• Created and maintained Business Objects reports in Web Intelligence Info View and BI Launchpad.
• Scheduled daily, weekly and monthly company turnover reports of Web Intelligence as per the business requirements.

Confidential, San Jose, CA

Environnent: SAP HCP, SAP BI 7.4, SAP R/3 4.7 and HANA 2.0

SAP Native HANA Consultant

Responsibilities:

• Leading and implementing multiple native HANA projects in Global Supply Chain domain while closely working with different business users, analysts, strategists and solution managers for Universal Order Visibility (UOV) initiative.
• Implemented cloud\hosting strategy and migrated key business applications to cloud\hosted based.
• Integrate SAP HCM to Success factor and then transfer data to Hana Cloud through Hana Cloud Integrator (HCI).
• Extensively involved in Project design, roadmap, detail designs and Development approaches.
• Architecting and developing complex HANA-XS information models such as Analytic/Calculation Views (Graphical/Scripted), SQL procedures (.hdbprocedure) and CDS entities (.hdb/.hdbdd).
• Integrating and consuming data from Hadoop in HANA for data archiving project using Smart data access (SDA) connectivity. Coordinating with DBA and implementing security.
• Defined web-based data access by building consumption models in HANA XSJS (server-side JavaScript) exposing HANA artifacts to client applications.
• Created reports using Web Intelligence tools with Business Objects Universe as the Data provider.
• Extensively used Web Intelligence reporting functionalities such as Filters, Ranking, Breaks, Formulas and Alerts etc. Developed new reports using Business Objects functionalities like Queries, Cross Tab, and Master Detail etc.
• Recommended best practices and consultative approach for implementing integration using the Hana Cloud Integration platform.
• Created and maintained Business Objects reports in Web Intelligence Info View and BI Launchpad.
• Performed source system/data analysis, data profiling, meta data management using Information Steward. Implemented the generic and specific profiling rules, perform rule binding, build scorecards to assess the data quality and provide the inputs to business for data cleansing.
• Presenting demo’s by showcasing new HANA features and capabilities and how it can efficiently solve client’s current use cases. Coordinating with Informatica ETL team for data integration/data quality and advocating them for efficient data loading strategies.
• Participating in peer design review sessions and also providing recommendations to the client for efficient HANA data modeling strategies

Confidential, Silicon Valley, CA

Environnent: SAP BI 7.4, SAP R/3 4.7, S4 HANA 1709 and HANA 2.0,

SAP HANA Architect/Modeler

Responsibilities:

• Worked with project business requirements and involved in preparation of client SOW and lead project delivery for green field implementations.
• Managed the project processes of the S/4 HANA, SAP ERP (SD, MM, P2P, O2C, and Logistics), Solution Manager 7.2, BW/Analysis4Office/integration scenarios on PO/PI systems.
• Mapped business requirements to the technical architecture design and information model in SAP HANA.
• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
• Managed BODS & ABAP teams to build ETL jobs and load programs and led the migration of data of around 50+ objects across mock cutovers, dress rehearsals, and final cutovers.
• Worked on multi system landscape architecture and integration aspects between heterogeneous system technologies in the areas of HANA Implementation, Modelling, Security & Authorization, Data Provisioning, SAP HANA Administration, reporting.
• Conducted "as is" and "to be" workshops with business SMEs to gather requirements, performed Fit/Gap analysis for P2P/R2R objects - Vendor Master, Source List, finance, Open AP etc.
• Performed source systems analysis, feasibility analysis of the functional requirements. Identified the risks in advance, get the impacted teams together to resolve them before they become issues.
• Involved in creating Packages, Schemas, Tables and Information views like Attribute views, Analytic views, and Calculation views(SQL Script based and graphical based).
• Implement HANA development best practices and develop performance optimized solutions.
• Good exposure on various components of SAP HANA. Worked on SAP LM and CTS++.
• Worked independently with minimal supervision and ensure timely deliverables.
• Developed models in HANA studio and tested by replicating the data using SLT and BODS.
• Worked on HANA stored procedures with parameters from BODS.
• Developed Advanced Models using either by SQL Script or Calculation Engine (CE) functions or CE Operators.
• Designed and Developed SAP HANA artifacts such as Attribute Views, Analytic Views and Calculation Views. Created Composite Calculation views that includes variables, input parameters and calculated columns.

Confidential, San Jose, CA

Environnent: SAP BI 7.4, SAP R/3 4.7 and HANA 1.0, Tableau 8/9.0.

BI/HANA Consultant and SAP HANA Modeler

Responsibilities:

• Involved in creating Packages, Schemas, Tables and Information views like Attribute views, Analytic views, and Calculation views(Sql Script based and graphical based).
• Tested BI reporting performance and data loading performance by reconciling the results in Confidential and HANA databases.
• Good exposure on various components of SAP HANA.
• Worked on latest features of SAP BI 7.4 and fixed various issues after BW- HANA Migration.
• Worked on LSA++ architectures and reduction of staging layers. Designed LSA++ data flows with SPO’s.
• Developed use cases in HANA side car and tested by replicating the data using SLT and BODS.
• Worked on HANA stored procedures with parameters from BODS.
• Designed and Developed SAP HANA artifacts such as Attribute Views, Analytic Views and Calculation Views.
• Created Composite Calculation views that includes variables, input parameters and calculated columns.
• Developed Advanced Models using either by SQL Script or Calculation Engine (CE) functions or CE Operators.

Chicago, IL

Environnent: SAP BI 7.4, SAP R/3 4.7 and HANA 1.0

Responsibilities:

• Tested all the BI existing functionalities are working fine in HANA similar to Confidential database. This will ensure business continuity with planned DB migration.
• Worked on In Memory optimization of cubes for all the functional areas.
• Tested the benchmarking of all the cubes before and after DMO migration to HANA DB.
• Involved in creating Packages, Schemas, Tables and Information views like Attribute views, Analytic views, and Calculation views(sql Script based and graphical based).
• Tested BI reporting performance and data loading performance by reconciling the results in Confidential and HANA databases.
• Good exposure on various components of SAP HANA.
• Worked on latest features of SAP BI 7.4 and fixed various issues after BW- HANA Migration.
• Worked on LSA++ architectures and reduction of staging layers. Designed LSA++ data flows with SPO’s.
• Performed technical smoke tests while HANA DB migration.
• Developed use cases in HANA side car and tested by replicating the data using SLT and BODS.
• Worked on HANA stored procedures with parameters from BODS.
• Designed and Developed SAP HANA artifacts such as Attribute Views, Analytic Views and Calculation Views.
• Created Composite Calculation views that includes variables, input parameters and calculated columns.
• Developed Advanced Models using either by SQL Script or Calculation Engine (CE) functions or CE Operators.

Confidential Brooklyn, NY

Environnent: SAP BI 7.3, SAP R/3 4.7 and HANA 1.0

BI/HANA Consultant and SAP HANA Modeler

Responsibilities:

• Cross checked all the BI existing functionalities are working fine in HANA similar to Confidential database. This will ensure business continuity with planned DB migration.
• Implemented few functional use cases to show case the faster and flexible reporting results to the business process experts.
• Tested BI reporting performance and data loading performance by reconciling the results in Confidential and HANA databases.
• Used control-M tool and triggered end to end loads from source extraction to loading the reporting layer for cross checking the data loading performance and the behavior of loading and observed the change in DSO activation time.
• Participated in LSA++ optimization workshops and designed CCA LSA++ data flow with SPO’s(8 logical partitions are trimmed into 3 logical partitions in LSA++)
• Performed; technical smoke tests while HANA DB migration.
• Developed COPA use case in HANA side car tested by replicating the data using SLT.
• Worked on replicating data using BODS into HANA.
• Created SAP HANA modeling views such as Attribute Views, Analytic Views and Calculation Views.
• Created complex information models using Graphical Approach and SQL Script Methods.
• Created variables & Input Parameters, restricted and calculated measures including various aggregation types such as Min, Max, and Sum etc.
• Create various privileges such as sql privileges, object privilege for the users in HANA Studio.
• Experience in working with Content models, Attributes, Measures and Hierarchies in SAP HANA.
• Provided guidance and advice to SAP Customers, Pre-sales and Solution Architect resources on the development of HANA solutions

Confidential Southbury, CT

Environnent: SAP BI 7.0, SAP R/3 4.7

SAP BI Consultant

Responsibilities:

• Involved in design of Technical Specification based on the Functional specification and interaction with the client while doing the design Functional specs into Technical Specs.
• Involved in Installation of Business Content of Info Objects, Data Sources, Info Sources, Data targets, and Info Providers to load master and Transactional data from SAP R/3 and SAP CRM systems into SAP BI system as per the client requirements by customizing them.
• Worked extensively on LO Cockpit extractions loaded the data from R/3 to BW and used Initialization delta update and full update methods.
• Involved in the development bringing the data from Non SAP source systems into SAP BI system using UD connect and DB connect.
• Involved in developing process chains, extraction, data loading and transformations development activities.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in drill down or summarized way to give detailed level of information.
• Involved with performance tuning of Queries by maintaining Aggregates, Compression, partition and indexing of Info Cubes.
• Involved in Poc Composite area data extraction into BI system with UD (Universal data) connect. In this I successfully extracted the composite area data from different source system other than ECC.
• Involved in the development of Info Cubes, MultiProviders, Operational Data Store (ODS), Aggregates, Info Objects, Data Sources, Info Sources, Info Providers, Transfer rules, Update rules and generic data sources.

Confidential

Environment: SAP BW 3.5, SAP R/3 4.7

SAP BI Consultant

Responsibilities:

• Involved in monitoring the data loads from R/3 source systems by means of process chains.
• Maintaining Work History for all the tickets until it is closed down.
• Verifying the missing data from data targets and reloaded them from source system.
• Involved with performance tuning of Queries by maintaining Aggregates, Compression, partition and indexing of Info Cubes.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the data loads.
• Handled the tickets of priority 1, 2 and 3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
• Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report.
• Involved in escalating high-prioritized tickets regarding extractions, Performance Issues and also load failures.
• Resolved customer reported tickets through email and phone.
• Provided high level of customer service to end users, business units and groups.

Confidential

Environment: .: SAP BW 3.1C, SAP R/3 4.7, SD.

BW Consultant

Responsibilities:

• Involved in developing the Functional reporting requirements of reports and also converting the Functional specs into Technical Specs.
• Developed Generic extractors to extract virtually any R/3 data from Data base tables, views.
• Used ODS to stage the data before transferring the ODS contents to the Info Cube.
• As part of Re-traction, designed Info Spokes to generate the Flat files on to Application server to upload the data to 3rd party commercial cockpits. Extensively used RSCRM REPORT option to extract data from multiple data targets.
• Involved in Installation of Business Content of Info Objects, Data Sources, Info Sources, Data targets, and Info Providers to load master and Transactional data from SAP R/3 system into BW system as per the client requirements by customizing them.
• Worked extensively on LO Cockpit extractions loaded the data from R/3 to BW and used Initialization delta update and full update methods.
• Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in drill down or summarized way to give detailed level of information.
• Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the data loads.
• Provide feedback to team leads on issues that faced during data load activities and work towards resolving the issues.

Confidential

BW Consultant

Environment: SAP BW 3.1, SAP R/3 4.6C

Responsibilities:

• As a member of BW team, involved in gathering user requirements, analyzing the data, Business content Installation and Configuration.
• Gathered reporting requirements and developed the reports for Specific Functional areas and Sales Distribution.
• Involved in the development of Info Cubes, MultiProviders, Operational Data Store (ODS), Aggregates, Info Objects, Data Sources, Info Sources, Info Providers, Transfer rules, Update rules and generic data sources.
• Data extraction using LO and LIS extractors.
• Customizing of extract structures for SD Sales data source like 2lis 11 vahdr and 2LIS 11 VAitm.
• Customizing of extract structures for Purchase orders data source like 2lis 02 hdr and 2LIS 02 itm.
• Knowledge in different update mode like direct delta, queued delta, Unseralized v3 update.
• Worked with Myself Data marts to export the data from cube to another cube before partitioning the cube.
• Involved in developing queries using filters restricted key figures, calculated key figures, and variables for characteristics, key figures and hierarchies.
• Improved query performance using partitioning, aggregation and Cube compression.
• Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the data loads.