SUMMARY

• 10+ years of experience in SAP, Includes HANA 1.0 SP7, BW/BI 7.0, 7.3 data warehousing, BO 4.O, 4.1 Webi and IP. Involved in 4 End to End implementation Project (design, development, and deployment). Having Support experience as well.
• Has versatile experience in areas of requirement gathering, gap analysis, design, implementation, validation and has played the roles of HANA/BW/BI/BO Application Developer.
• Played Role as SAP HANA Senior Consultant in End to End Implementation project as Application Architect.
• Played Role as SAP BW Senior Consultant in End to End Implementation project as Application team member.
• Implemented SAP HANA models and developed custom attribute views, analytical views and calculation views.
• Implemented Std Cubes, DSO and developed Custom data flows as per the requirement.
• Fair knowledge on ABAP, which enables to implement various coding and debug other custom functionalities in BW.
• Experience in SAP HANA Data Modeling and Data Provisioning using BODS and SLT.
• Involved in 4 End to End implementation Project in MM, FI, AA, HR and CRM (TPM). (design, development, and deployment).
• 3+ Years’ working experience in HANA.
• Strong experience in designing SAP HANA Models
• Implement: Create database schemas, Attribute View, Analytic View, Calculation View, develop scripts and establish data feeds (SLT & BODS).
• Experience with HANA modelling for SAP (ECC, BW) and Non - SAP data sources.
• Working experience on SAP HANA Platform SP 07/08/09.
• Modelling of SAP HANA objects and developed Attribute Views, Analytic Views with various join conditions and calculation views using both Graphical and SQL script based methods.
• SAP HANA programming including SQL, SQL Script, and CE Script.
• Proficient in creating Calculated Columns, Restricted Columns, Filters, Hierarchy, etc.
• Creating Functions and Stored Procedures using SQL the Editor
• Working knowledge of HANA LIVE
• Experience working for corporations across diversified industry verticals includes Manufacturing, Chemical and CPG.
• Having very good knowledge on CRM TPM and TPO application.
• Having knowledge on SAP DSIM (Data Signal Management) Data modeling powered by HANA.
• Deep knowledge of business processes and requirements in the areas of integrated sales, marketing, and trade promotion management.
• Experience working with HANA optimized SAP BW Cube’s and DSO’s.
• Knowledge on connections between SAP HANA and Business Objects using JDBC, ODBC, BICS and ODBO.
• Strong ABAP programming and debugging skills. ABAP in Data dictionary, DataSource enhancements & user exits in R/3 & BW, Routines in Transformation, Transfer and Update rules. User Exits for custom variables etc.
• Proficient in OLTP extractions of SAP LO-Cockpit, FI, MM, HR and CRM, generic extraction, flat files.
• Experience on ETL Tools to extract source data & Data profiling, Transformations and loaded into target repository and checking the data quality of the loaded data in the warehouse
• Extensively worked in designing and configuring back-end components including Extractors, InfoObjects, Hierarchies, InfoSources, Update Rules, Transfer Rules, Transformations, InfoCubes, MultiProviders, ODS/DSO, InfoSets, InfoPackages and Data Transfer Process (DTP).
• Expertise in DataSource Enhancement, User Exits, Loading, Scheduling, Monitoring, Process Chains, Open Hub Service, Authorizations, User Profile Maintenance, Reporting Agent, Enterprise Portal Integration, Information Broadcasting and alert monitor.
• Expertise in Production Support issues which involved debugging ABAP routines, Data loads, Validation and trouble shooting of Transaction Data and Master Data, Change management, Process Chains Monitoring, Transport Management, Roles & Security, System Checks.
• Expertise in working with BEx Query Designer in building Queries. Extensively created Calculated Key Figures, Restricted Key Figures, Formula Variables, Conditions, Exceptions, Aggregations, Cell editors, Customer Exit Variables and Structures for developing complex custom reports.
• Extensively worked on publishing reports to roles and portal, broadcasting workbooks, reports to end-users. Experience in providing the security using Authorizations for various requirements.
• Experienced in Business objects universe designing (OLAP Universes), Business Objects Web Intelligence (Webi), Business View Manager, InfoView, Explorer and Business Objects Enterprise (BOE).
• Excellent experience in creating BO Xcelsius dashboards and KPI’s to large-scale multi-layer reports.
• Involved in End-User training on Navigating reports, Post Go-Live maintenance manuals, Web Application Designer, Portals.
• Documented functional specifications, technical specifications, test cases, test results and production support documents.
• Excellent Documentation, communication, verbal, and problem solving skills. Proficient skills to communicate effectively with Team members, developers, clients and end users in a diverse environment.
• Involved in creating UAT test scripts and Sessions with the analysts and given training in using the Advance Analysis tool.
• Achieved Bronze Title from the SCN towards the contribution (Articles) to SAP-BW/BI Capability.

TECHNICAL SKILLS

ERP: SAP R/3 ECC 6.0, MM, IP, APO, FIGL, AP, AR.

Data Warehousing: SAP Net Weaver 2004s and BW 7.0, 7.3, 7.4) HANA 1.0.

Reporting Tools: SAP BO 4.0/4.1 BEx Analyzer, BEx Query Designer, Analysis Tool, Dashboard Design Tool.

Databases/BI: SAP HANA, Oracle and DB2.

DWH Concepts: OLTP, OLAP, Star Schema, Extended Star Schema.

Languages: C, C++ and SAP ABAP.

Operating System: Windows NT, Windows 2000, Windows XP, Windows 7

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

HANA Architect

Responsibilities:

• Extensively worked in implementing SAP HANA 1.0 SP09.
• Loaded Data into SAP HANA from ECC using SLT and Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Worked on SQL scripts using Calculation View and to debug the issues.
• Integrated Tableau with HANA Virtual models.
• Developed the SAP HANA models in the SAP HANA environment.
• Integrated SAP BO Analysis Office with SAP HANA models for operational reporting.
• Assess different customizing options for SAP HANA models for customer-specific scenarios.
• Worked on FI-AP, AR, GL and Profitability modules real time reporting using data load with SLT to SAP HANA and design virtual models.
• Imported BW in-memory DSO in to Native HANA as analytical views by push method.
• Worked on WM, IM and Field Sales modules non real time reporting using BW on Hana data loads and design virtual models.
• Hands on experience in developing and modelling the various modules of SAP and non-SAP related in HANA Studio.
• Enhanced the SAP delivered existing HANA Models based on the requirement.
• Developed the attribute views, analytical views.
• Developed Calculation views (joining more than two views and Standard tables).
• Created Variables on Calculation views to restrict the data based on requirement.
• Created Input Parameters on Calculation views to pass the logic dynamically to the views.
• Loaded the data from ECC to HANA Data base by using SLT.
• Integrated HANA views in BO Analysis office and Tableau as front end tool/presentation layer.
• Developed the SQL scripts to load the data in to staging tables to increase the virtual data model performance.

Environment: SAP BW on HANA, SAP Native HANA as Side Car and SAP BO Analysis Office, Tableau, SAP

Confidential, Lexington, KY

SAP Analytics Consultant

Responsibilities:

• Involved in overall system design with project team gathering requirements and discussed design road map and related issues.
• Involved in Implementation of SAP HANA Standard Operational RDS for Finance, Sales, and Inventory.
• Replicated tables from ECC using SAP LT data provision into HANA Studio and Partition of Finance tables BSEG, FAGAFLEXA, and BKPF to increase performance.
• HANAmodeling including creating schemas and importing source system metadata, and developing Information Models with Attribute Views, Analytical Views and Calculation Views.
• Deployed and activated standard Attribute Views, Analytical Views, Calculation Views, SQL Scripts.
• Created custom Attribute Views, Analytical Views, Calculation Views for sales and inventory reports.
• Data Provisioning, Monitoring and Troubleshooting data loads inSLT & HANAenvironment. Data replication / extraction strategy intoHANAusing SLT, BODS.
• Worked on different reporting tools onHANABO reporting tools, BO Explorer, Webi, Dashboards
• In-depth knowledge and hands-on experience ofHANAsecurity/user setup configuration & setting up HANA Analytical privileges to restrict access to the specific HANA views.
• Setting preferences for modeler,HANAstudio.
• Leveraged the SAP HANA data model based upon the SAP Operational Reporting RDS. This includes business models, views and reports for Financials, Sales, Purchasing and Shipping.
• Developed universes on top of information models using Information Design Tool. Created complex Web Intelligence reports using universes.
• Migrated HANA content from development to Production environment.
• Analyzed business reporting requirements that could be satisfied with SAP business content and delivered cubes and installed the necessary objects.
• Worked with several users, and interacted with them to gather requirements, and transformed them into a data model with the concept of extended star Schema.
• Using Business Objects as front end tool for Reporting
• Extensively working on FICO module including different applications such as Cost Center Accounting, Account based COPA, Product Costing, Accounts Payable, Accounts Receivable, New General Ledger, Travel and Asset Accounting.
• Working on Open Hub for proving data to other systems
• Data Modeling based on BW Extended Star Schema as per the Business requirement.
• Designed and built InfoObjects, InfoCubes, DSO, Multi providers based on business requirements and prepared a Design documents.
• Created transformations and Data Transfer Processes to load data from PSA to Target.
• Modified standard and created custom data sources, InfoObjects, DSO and Infocubes.
• Used LO and Business content extractors to extract data from SAP ECC 6.0. Also used Flat file extraction from other data sources.
• Configured and customized Vistex Global Claims and Agreements that's integrated within SAP sales and distribution module.
• Involved Up gradation from BI 7.0 to BW 7.3 version.
• Transporting from development box to QA & Prod.
• Conducted Training sessions for Users and prepared Training Material.

Environment: SAP BW on HANA, SAP HANA 1.0 (SP5), SAP BW 7.3, SAP Business Objects BI Platform 4.0, ECC 6.0, CRM, SRM, SCM, Vistex

Confidential, Houston, TX

SAP HANA Developer

Responsibilities:

• Understanding the existing SAP BW Models and documenting the business flows in SAP HANA.
• Developed the Attribute Views based on Master Data Tables in the SAP ECC.
• Developed the Analytic Views based on Transaction Data Tables in the SAP ECC for SD, FI, Plant Maintenance, and SRM modules.
• Created Row or Column based Custom Tables based on the structures in SAP ECC and populated the data using SQL statements and Flat Files import function in HANA Studio.
• Created the Analytic Views based on the Info cube models in SAP BW/BI system.
• Created the Graphical Calculation Views by including the Analytic views using Unions, Projections and Joins based on the business logic.
• Worked on designing SAP BW data Flows (DSOs, Transformation, and DTPs) in the BW (on HANA database) Scenarios and imported the DSOs, Info cubes to the HANA studio tool.
• Created the necessary Calculated Attributes, Restricted Measures, Calculated Measures and Input Parameters using the HANA studio tool.
• Used the HANA studio Functions like Conversion, String, Mathematical and Date to suit the business requirements in Calculated Attributes and Calculated Measures.
• Involved in importing the BW models from SAP BW system (using HANA DB) to the HANA Studio as Analytic views and Calculation Views.
• Imported and exported the HANA Models from development to Production system using Delivery Units.
• Reconciled the data with the existing BW Reports with the new HANA Models.
• Called the Calculation View to BO 4.0 IDT Tool to create Universes.
• Created the Visualization Reports in Explorer 4.0 based on the Analytic Views, Calculation views and Universes using measures and Facets on the Information Spaces.
• Created Dashboard reports using Design Studio and Dashboards (Xcelsius).

Environment: SAP HANA 1.0 SP05, SAP BW 7.3, SAP ECC, SAP BO WebI, AOLAP

Confidential, Fresno, CA

SAP BW/BI Consultant

Responsibilities:

• Involved in Discussions with the client regarding Business Requirements.
• Identified and installed the BI content objects related to Billing, Inventory, and Budget (COPA).
• Extracted data from ECC using the Logistics procedure for Sales and Inventory.
• Extracted historical MSSQL data for Sales and Budget using the UD Connect.
• Involved in writing Start Routines, Field Routines and end routines.
• Enhanced the Billing and Inventory Data Sources according to requirements.
• Developed Queries using RKFs, CKFs, Exceptions, Variables, Conditions, Cell editor, Replacement path, Formula collusion etc.
• Developed ABAP Code for Year-to-Date and Period-to-Date in CMOD.
• Transported all the ECC and BI Objects from Development to Quality and Production Systems.
• Created, Scheduled and Monitored Process Chains for the above flows.
• Involved in UAT with the Business Users in BI Quality system.
• Re-designed the Objects and made changes to the Flows and Reports to meet Requirements after UAT.
• Configured the OLAP Connection for BW server on the Central Management Console(CMC).
• Created the Data foundation, Business layer and published the universe to WebI.
• Created the Reports Using the BO WebI tool on the universes.
• Created the BO WebI reports by calling the BEx Queries using BICS connectivity.
• Created the Tab - wise reports for on the Sales and Billing in WebI.
• Worked on Dashboards(Xcelsius) for Visualization Reports.

Environment: SAP BI.7.0, BEx Designer, BEx Analyzer, SAP ECC 6.0.

Confidential

SAP BW/BI Senior Consultant

Responsibilities:

• Involved in design, analysis and end to end development on identifying KPI's and gathering requirements for Sales, Revenue, enhancing multiple standard and generic extractors
• Created user-exit variable for Planning periods based on user entry, developed expert routines and end routines.
• Worked on multiple enhancements in within BI and CRM source system.
• Developed new/enhanced custom Transactional/Master data Extractors, InfoObjects,DSOs,InfoCubes, MultiProviders, Transformations, Info Packages, DTPs and scheduled the load via process chains
• Enhanced data sources usingUser Exits, extracted data fromCRM system from Data sources and genericextractors, ran Delta update with Numeric Pointer, Timestamp and Calday
• Enhanced SD extractors and relevant objects adding a new partner function and modified existing reports to accommodate new fields and functions
• Converting high-level design specifications to detailed functional and technical specifications.
• Used Administrator Workbench to create Data Sources, Info Objects, and, Info Cubes, DSO objects, Info sets, Multi-providers, update rules and transfer rules.
• Data extraction from CRM source system and Flat files.
• Created generic data sources to extract data from various data sources to achieve end-user requirements.
• Excellent communication and management skills and ability to work as part of a team
• Used Process Chain and the Reporting Agent to automate data loading, delta uploads, Performance tuning, printing and Exception reporting.
• Designed aggregates for performance improvement of existing queries.
• Scheduling, Monitoring and transporting objects in Dev, QA, Prod systems.
• Developed queries using BEx analyzer. Create variables, calculated and restricted key figures, filters and conditions in BEx query designer.
• Automated the error handling which triggers the email to the intended recipients in case of the erroneous records.

Confidential

SAP BW/BI Consultant

Responsibilities:

• Understand the user requirement Recommend the best solution for the problem Create the necessary technical specification.
• Provide the solution and enhance the current solution so that user’s requirement is met
• Responsible in creation of InfoCubes, InfoSources, replicated DataSources, loaded Master Data From flat files and from OLTP, Multi providers and ODS objects.
• Create the BEx and Web reports for user Co-ordinate the transport activity from Development to Quality and then to production
• Good knowledge of master data processes, data standards and how they relate to the business, particularly in the areas of materials, sales, vendors and finance.
• Activated SAP delivered Business contents.
• Involved in enhancing few master and transaction data extractors while developing the data flow For reporting needs
• Recommend the best solution and test the solution and help user in UAT
• Run and Monitor the Process chain and resolve the error.
• Created ODS update rules and InfoPackages to load data, installed Business Content, created Aggregate InfoCubes.
• Developed custom extractors to extract data out of custom tables in R3.
• Uploaded master and transactional data from flat files, SAP BW and SAP R/3.
• Responsible in solving performance-related issues.
• Created and maintained queries in BEX Analyzer and BEX Web application Designer for analysis and reporting with Workbook and Web Reporting respectively.
• Involved in creation of reports using BEX Query designer such that the execution time is evenly distributed throughout the report by using free characteristics, restricted keyfigures,
• Calculated keyfigures, Variables, Exceptions, Navigational Attributes, Text Variables, Filters, Structures and Conditions.

Confidential

SAP BW/BI Software Engineer

Responsibilities:

• Involved in setting up of procedures for extracting data from SAP R/3 by using Generic Extraction.
• Created Info Cubes, Data Store Object for various Functional Areas.
• Created queries in the BEx Query Designer, Report Designer and deployed.
• Used BI7 features like DTP to load the data from PSA to Data Target.
• Used Data Transfer Process for Transferring the Data to the Targets.
• Weekly presentation to inform about the progress and status. Extensively worked in many Performance issue improvements in both loading and Execution activities by maintaining aggregates, Indices, compression and partition.
• Involved in all kind of Production Support activities
• Monitor the daily loading/transforming and report generation processes and rectified/solved the failures occurred within the SLA
• Involved in resolving the Incidents and Handled CR's
• Data Load Monitoring and Incident Management. Incident Resolution, Problem identification/resolution and resolve data load failures to ensure data availability as per SLA.
• Solving production requests and resolve data load issues and ensure that data availability
• Delivering good solutions within specified time.
• To avoid the future failures for such cases, design, developed& documented the solution for first time users
• Propose that to the client and document that into the Work Request.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Hands on experience in Information Broadcasting.

Confidential

Software Engineer

Responsibilities:

• Worked extensively on Administrator warehouse workbench (RSA1). Designed and developed Info Objects, Info Cubes, ODS and Multi providers.
• Involved in preparing Technical Design Documents, Unit Test Cases and Results.
• Involved in Work Reviews.
• Created Update Transformations.
• Involved in creating Cubes, Created Process Chains to automate the process of loading data into Data Targets.
• Involved in Collection of objects& Transport the same from Development (BW Dev) to Quality (BW QA).

Confidential

Junior Software Engineer

Responsibilities:

• Analyzes SAP requirements; designs and codes ABAP programs to meet the specifications.
• Identify system deficiencies/errors then develop and implement effective solutions
• Developed new reports as a new requirement
• Performs complex ABAP programming, testing and debugging functions related to the implementation of SAP modules
• Work with functional colleagues to understand functional design requirements, preparing technical specifications,
• Support and help functional persons to perform integration testing
• Bug fixing/change the existing code due to new requirements/build a new code etc.