SUMMARY

• More than 7 years of Information Technology work experience in Implementation, Upgrade and Support in SAP BI/BW/HANA.
• 7+Years of SAP BW/BI experience, which includes Data - Modelling, Data Extraction, Data Loading, Scheduling, Monitoring, Reporting and Performance Tuning.
• Extensively worked on designing/creating InfoObjects, InfoSources, Transfer structures, Communication structures, Standard and Custom InfoCubes, Data Store Object (DSO).
• Having precise expertise in understanding the R/3 and ECC 6.0 System and considerable experience in SAP BW/BI, documenting, design and Analysis of reports Using BEx Analyser.
• Working experience on performance tuning using Aggregates, Rollup, Compression, Partitioning & Indices
• Used BEx Analyzer as a front-end tool to build queries and reports.
• Expertise in report generation-worked on BEx-Analyzer in building Queries and created custom Queries using RKF, CKF, conditions, exceptions, variables and created aggregates for frequently used queries.
• Around 4 years of extensive experience in SAP HANA-Data Modeling, Data Provisioning, Reports development in various reporting tools.
• Solid comprehension of HANA functional building design/bas. Professional knowledge in Design, Development and Deployment of SAP HANA Information Models.
• Expert knowledge on Pre-sales activities such as inquiry and quotation, and major business activities such as Pricing, Billing, Shipping, Transportation, Availability check (ATP), Credit Management, Partner Determination, Output Determination, Bill of Materials and Variant Configuration.
• Good Knowledge of Data Provisioning and replicating data from source system to HANA Database using SLT, Sybase Replication Server and Business Objects Data Services. (Trigger based, Log based and ETL).
• Building complex ETL Data flows/Jobs in SAP Business Object Data Services 4.x and in Informatica Power Center 9.x by implementing Source/Target CDC and extracting SAP standard business extractors from SAP ERP systems
• Good learning in Configuring and importing Metadata and Data from source framework utilizing SLT, BODS (ETL) and Sybase Replication.
• Comprehensively worked as a SAP HANA Modeler (HANA Design Studio) for Designing Schemas, Creating Packages, Attribute View, Analytical View, and Calculation view, Analytic Privileges, Stored Procedures and CE Functions.
• Worked on creating Level Hierarchies and Parent Child Hierarchies in Attribute Views.
• Performance tuning by creating Calculation Views with the SQL Scripting.
• Knowledge of creating Calculated Attributes, Calculated Measures, Counters, Variables, Input Parameters in the views
• Worked on report Unit Testing, Layout and Integration Testing.
• Used SQL Function Editor for creating Calculation Views.
• Performing Mass Copy and Mass Activation of information models
• Worked on Importing and Exporting Landscapes, Tables and Models, Documentation, User Management, Backup and recovery in SAP HANA.
• Comprehensive work experience on HANA Security Models.
• Hands- on expertise on SAP HANA LIVE Rapid Deployment Solution.
• Worked on HANA data as Pivot tables in Microsoft Excel via MDX provider.
• Used Business Objects Explorer to file data stored in HANA DB.
• Worked on using Information Design Tool in order to create Relational Connection, Data Foundation and Business Layer and extracted the data in HANA through Business Objects Crystal Reports, Business Objects Dashboard Design, Business Objects Web Intelligence (Webi), Business Object O Analysis.
• Development, Testing, Documentation, Requirement analysis, End user documentation, Data extraction, Data modeling, Data loading, Reporting and Production Support. Involved in building reports using SAP BO and integrating BO and BI with HANA.

TECHNICAL SKILLS

TOOLS: HANA 1.0 SP6 SP7, SAP NetWeaver BI 7.4, BW 7.4, SAP BODS 4.x

BUSINESS MODELING: HANA Design Studio, Data Services Workbench, Universe designing, Information Design Tool (IDT)

BI REPORTING TOOLS: BEx Reporting, Web Application Designer, Report DesignerBusiness Objects (XI 3.1/BI 4.0), Dashboards (Xcelsius)Crystal Reports, Live office and Webi.

ETL TOOLS: Informatica, Business Objects Data Integrator/Data services, SAP LT Replication Server, Direct Extractor Connection

LANGUAGES: C, C++, Java/J2EE, C#.NET, SQL, PL/SQL

WEB TECHNOLOGIES: HTML, XML, Dreamweaver, Flash, JavaScript, CSS, PHP, JSP, REST

OPERATING SYSTEM: MS Windows 2000/XP/7, UNIX, Linux, AIX

DATABASES: SAP HANA 1.0, MySQL 5.x, MS Access, Oracle 12c

PROFESSIONAL EXPERIENCE

SAP HANA/BW CONSULTANT

Confidential, Saint Paul, MN

Environment: SAP HANA 1.0(SP7), BODS 4.2, SAP BW 7.4, SAP BOBI 4.2, SAP ECC, IDT, SAP LT Replication Server, DXC, SAP SD, MySQL

Responsibilities:

• Involved in collecting requirements, Interacted with prospective clients to gather their analytical requirements, which are very important to customer.
• Conducting workshops to gather the business requirements.
• Responsible for understanding end user requirement and convert into functional requirement and involved in preparing project plan.
• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Extracted data from non-SAP source system using DB connect and flat files interface.
• Created Transformation Routines, Start Routines, End Routines as per the requirement and for the lookups from one DSO to other. Testing and Debugging of routines.
• Designed DSO’s for SD module for Sales Header, Sales order Item, Billing Items, Schedule line, Sales History, Sales Quota, FI/GL etc.
• Build ETL mappings to load Customers data from SAP BW application tables for Confidential ’s various business units into HANA tables.
• Responsible for SAP HANA Data provisioning using SAP LT replication server (SLT) and data server.
• Performed SLT transformations and enhanced tables with missing fields.
• Performed data loads via SAP BW extractors (DXC) to HANA from legacy BW.
• Used SAP BO Data Services 4.2 for Data Replication.
• Created complex transformation’s in BODS data flows as per modeling requirements.
• Designed & Developed custom DataSource, InfoSource, Extractor and InfoCube to fulfill user requirements extensively in SD and PS.
• Enhanced standard DataSource and populated values using User Exit.
• Developed Transfer rules, Update rules and Start routines using ABAP to in corporate Business logic and perform data manipulation.
• Extensively worked on transporting objects between BW system environments and corresponding SAP ECC.
• Developed data loading strategies for master data, transactional data and delta uploads.
• Responsible for HANA POC to Validate the Master Data and Transaction data Tables with multiple Analytical View, Attribute View, Calculation View, Restricted Measures and Calculated Measures.
• Worked on creating Attribute, Analytical and Calculation (Graphical and SQL) views using SAP HANA modeler.
• Worked on tables such as KNA1(General data in Customer Market), T001(Company Codes), T005T(Country Names), T005U(Taxes: Region Keys), TCURC(Currency codes), TSPA(Sales Divisions), TSPAT(Sales Divisions: Texts), TVKO(Sales Organizational), decision tables and connecting tables to decision tables in SAP HANA.
• Analyzed the requirements and designed the reports based on the business requirements and deployed by using the best practices in HANA as recommended by the SAP.
• Prepared functional specification for the development of Reports, Interface, Conversion, Enhancement, and Forms. Prepared unit test scripts and checklist to be included in the functional specification.
• Build BO universes on top of HANA calculation views and developed Webi reports and dashboard reports using IDT.
• Established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Provided support to Sales and Distribution Team with drafting functional requirement specifications (FRSs) for customer master, quotation processing, sales order processing, consignment processing, billing, returns processing, contract processing, rebates processing, and backorder processing.
• Configuring pricing procedure, condition types, access sequence, and built custom pricing tables.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

SAP HANA/BO/BW CONSULTANT

Confidential, Austin, TX

Environment: SAP BI 7.1, HANA Studio, BEx Query Designer, SAP ECC, SAP BODS, SAP LT Replication, SQL, IDT 4.0

Responsibilities:

• Building of the Information Models such as Attribute Views, Analytic Views and Calculation Views according to the business requirements.
• Worked on implementation of Calculation Views using SQL Scripting and SQL Procedures.
• Manage all technical development for BW system, which includes the Staging Area and Data Extraction Services.
• Successful completion of loading data into SAP HANA DB using SAP BODS from SAP ECC.
• Performed data loading from non-SAP tables with complex transformations via SAP Data Services (BODS) into SAP HANA tables with a mix of SLT replication.
• Schedule, performance and monitored periodic data loads from ECC to BW system, delta loading and DSO Loading process.
• Helped in configuration of extractions from ECC and flat files.
• Created all kind of reports on top of the created Information Models, Universes, IDTs such as Fulfillment Rate Report, Sales Credit Memo Analysis, Sales Order Time Analysis, Billing Document Analysis and Sales Item Status Analysis.
• Accomplished report migration from BW 3.5 reports to BI 7.1 and higher.
• Worked extensively on LO data extractions using LO Customizing cockpit using (LBWE) and uploaded standard Extract structures for SD sales and QM applications.
• Installed relevant SAP business content. Used LO structures for extracting Sales Order and Delivery Billing information.
• Involved in creation and maintenance of InfoObjects, InfoCubes, DSO, PSA, Info Source, Application Component, Data Source, Communication Structure, Transfer Structure, Transfer rules, Update rules, Update methods, Info Packages, Info Spokes.
• Installed objects from Business Content as well as customized InfoObjects, InfoCubes, DSOs, Transfer/update rules according to the client requirements.
• Good exposure on Schemas, Table definitions, Attributes, Measures & Hierarchies in HANA.
• 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.
• Migrated the created Information models from Dev to Quality and Dev to Production using Transport Organizer through Delivery Units.
• Performed tasks in HANA Sand Box environment to model views and Hana Information Composer.
• Developed SQL scripts and functions for complex reusable scenarios in HANA.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Created HANA Information models for CRM Sales reporting.
• Experience in designing, developing, maintaining and optimizing the Universes using both Designer Tool and Information Design Tool (IDT 4.0).
• Created all kind of reports on top of the created Information Models, Universes, IDTs such as Fulfillment Rate Report, Sales Credit Memo Analysis, Sales Order Time Analysis, Billing Document Analysis and Sales Item Status Analysis.
• SAP BI reporting and solutions SAP Implementation methodology and best practice Working on techniques of Data lineage and tracking the data from source system to its target, working with types of SAP BI data models like relational, Star Schema etc.
• Created HANA Information models for CRM Sales reporting.
• Worked with large volumes of data and being able to build summary tables for the dashboard.
• Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Implemented intensive logic in SQL Scrip to optimize the retrieval of data from HANA database.

SAP BOBJ/BW COSULTANT

Confidential, Washington, DC

Environment: HANA 1.0 SP5, SAP ECC, SAP BOBJ, SAP BODS, HANA Administration, Webi, Dashboards, IDT

Responsibilities:

• Installed HANA 1.0 and solely integrated it with Business Objects and Business Objects Data Services
• Installed BOBJ 4.0 and BODS 4.0 and configured SAP and Windows AD authentication for Business objects enterprise.
• Creation of Technical specifications and standard modeling documents for SAP HANA.
• Involved in Support and Monitoring activities after go-live.
• Replicated the ECC content in HANA using data provisioning by gathering and analyzing the requirement.
• Performed full and delta loads based on MD5 checksum and scheduled workflows.
• Monitored, Debugged and followed ETL best practices for efficient data loading.
• Imported Flat files using SAP HANA import wizard.
• Involved in creating and maintaining Info Cubes, Data Store Objects, PSA, Info Objects, Info Areas, Multiproviders, Info Sources, Data Sources, and Info Packages.
• Data extracting from the Source system and Generic Extractions for all the logistics data.
• Involved in Info Cube maintenance i.e., Compression, Roll-up for Aggregates.
• Complete automation of all BI Daily, Weekly and monthly loads (Info Package Scheduling) using Process Chain.
• Worked extensively with BEx Query Designer, BEx Analyzer for developing reports, analysis, and Web reporting.
• Experience with implementation, configuration and solving of module-level issues in MM, SD.
• Development of the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0.
• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Created Attribute, Analytical and Calculated views as per the requirement needs.
• Created procedures in HANA Database.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• Worked closely with WEBI Reporting team on the requirements.

SAP HANA/BI/BO MODELER

Confidential, Pleasanton, CA

Environment: SAP HANA 1.0, SAP BI, SAP BEx Explorer, SAP BO 4.0, MS Office

Responsibilities:

• Responsible for building BI objects that include Info Objects, DataSources, Transformations.
• DataSource Objects are created for staging for AP, AR line item data, multi cubes and Infosets are created to satisfy reporting requirements.
• Customizing and Activation of Business Content for Accounts payable, Accounts Receivable, Profitability Analysis, General Ledger, Human Resource, Cost Center Accounting, CRM activity items cube as per the requirement of the client.
• Working on HANA studio in order to build Attribute View, Analytic View, Calculation View and Schemas.
• Development of SQL scripts and functions for complex reusable scenarios in HANA.
• Successfully completed building Universes, retrieving data using Universes and creating reports using Business Objects and Web Intelligence Tools.
• Involvement in entire Business Objects application suite and in design, development, testing and implementation of Webi, Xcelsius and Crystal Reports for the models created in HANA studio.
• Responsible for creating connections to the BEx queries in BW system through the BICS network layer in the Information design tool (IDT).
• Exported the universes to the Repository as per the client requirement.

SAP BI/BO CONSULTANT

Confidential, Bartlesville, OK

Environment: NW 2004S, BI 7.0, ECC, BO XI 3.1, BEx

Responsibilities:

• Successfully completed an entire life cycle Implementation of SAP BI that includes Data Extraction, Data Modeling, Reporting, Workshops and Blue print documents.
• Worked on developing BI data models and designs, configuring custom, analyzing BI reporting requirements, developing detailed reporting specifications.
• Actively involved in BI 7.0 Upgrade Testing.
• Involved in Interacting with functional team to resolve the issues in the given objects.
• Also involved in Development of technical specifications for the developments assigned.
• Extracting and Customizing existing Human resource Info cubes, DSO & Multi providers.
• Performed Logistics, controlling and profitability (CO-PA), Human Resources and Generic extractions throughout the project.

SAP BO DEVELOPER

Confidential

Environment: BO XI R2.0 Info View, Web Intelligence, Administrative tools like CMC, CCM, Universe Designer, Instance Manager, Query Builder and Oracle 10g

Responsibilities:

• Monitoring scheduled reports through instance manager.
• Responsible for deletion of long running reports and maintain the load balance by pausing the reports.
• Responsible for Monitoring the BO application server’s availability.
• Responsible for Performing the Monthly maintenance of the BO application servers that includes the down time and the re-booting using Central Management Console (CMC) and prepare the monthly tracking metrics.
• Changing and adding report logics for existing reports.
• Maintenance of different Universes as per the requirements.
• Responsible for resolving any unplanned issues caused at production downtimes.