SUMMARY

• Result oriented SAP Techno - Functional consultant with 8 years of experience in SAP BW/BI and currently working on SAP BI 7.4 on HANA platform.
• Mainly focused in design, development, implementation and support of SAP applications for different modules including FI-CO, HR, SD, MM, PP, PS and PM.
• Involved in 2 implementation projects in SAP HANA 1.0.
• Having 3+ years of experience in SAP BO reporting tools.
• Involved in 3 full lifecycle implementations for different modules in SAP BW including SD, MM, FICO, HR, PS and PP, which involved all phases such as gap analysis, blueprinting, realization, data extraction, data modeling, data loading, production support, testing, documentation, requirement analysis, end user documentation, reporting and go-live check.
• Experienced in creating attribute views, analytic and calculation views in HANA studio.
• Experienced in importing and exporting BW models into the HANA studio.
• Knowledge in Data Provisioning, Data Loading and Data profiling in SAP HANA Studio.
• Experienced in BPC integration with BW.
• Experienced with ABAP models related to BW.
• Proficient in data extraction from SAP ECC (FICO, HR, MM, SD, PM and PS), flat files and BW using extractors such as LO Cockpit, COPA, FI and Generic Extractors.
• Extensively worked on Business Information Warehouse Info Cubes, SPO’s, DSO’s, and Info Objects.
• Proficient in performance tuning techniques which involved the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques
• Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer, Web Application Designer, Web Reports, Webi, Xcelsius and dashboards) for queries, workbooks, calculated key figures, restricted key figures, filters, conditions, exceptions and have good knowledge on variables and its processing types.
• Experienced in BOBJ 4.1 version with BI Launch Pad, SAP Business Objects Dashboard design, Webi and Analysis for Excel.
• Extensively worked on importing various BW models into HANA studio.
• Actively contributed in cutover activities for SD, MM, PS and FICO modules.
• Skilled in dealing with production support issues, which involved debugging data loads, process chains and monitoring and scheduling data loads.
• Strong planner and organizer with demonstrated ability to develop business solutions that increase productivity, efficiency and profitability.
• Excellent team player with good analytical and problem solving skills, good technical writing skills.
• Good communication skills, strong decision making skills, organizational skills and customer service oriented.

TECHNICAL SKILLS

SAP: R/3 4.5, 4.6C, 4.7, ECC 6.0

Net Weaver: SAP BI 7.4/7.3, BW 3.5, SAP HANA

Other Tools: SQL*Plus, MS Office XP, MS Visio, MS Project, Power Term

Programming Languages: C, C++, SQL, HTML and PL/SQL

Web Servers: Tomcat, BEA Web Logic, IBM Web Sphere, Microsoft IIS

Data bases: Oracle10g/11i, DB2, SQL Server and MS Access

BI Tools: BW, BEx Query Designer, BEx Analyzer Web Intelligence, Design Studio 1.1, Business Objects XIR4.0, Xcelsius 2008 and Crystal Reports 2008

PROFESSIONAL EXPERIENCE

Senior SAP HANA Developer

Confidential, Dallas-Texas

Responsibilities:

• Develop HANA Models to Validate the Master Data and Transaction data Tables with multiple Analytical View, Attribute View, Calculation View, Restricted Measures and Calculated Measures
• Created analytic and complex calculation views using SAP HANA modeler.
• Involved in Load testing of various calculation views with HANA BASIS DBA Team.
• Experience in SAP HANA Data provisioning using SAP LT replication server (SLT) and data server.
• Worked on SAP HANA Data provisioning, Delivery Units and Schema Mapping.
• Experience in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables, using system-generating joins.
• Information Modeling in SAP HANA and Report Generation in BOBI 4.0 for Sales and Distribution module towards Comparative Analysis for Actual Sales and Planned Sales.
• Data Replication using BODS 4.0
• Synchronizing Planning Info Providers within the BW PCA Copy Methodology.
• Execute migration from traditional DWH to HANA.
• Experience implementing Rapid deployment solutions and modify HANA models.
• Information Model Designing using HANA Studio.
• Created Procedures to populate in Tables using Analytical and Calculated views.
• Created roles and assigned them to users of HANA.
• Stored data in columnar and row store in Database.
• Creation of multiple Graphical Calculation Views including Projections, Joins and Unions
• Worked on Catalog schemas with System Tables, Content Packages and Roles in the Security Folder.
• Worked On SAP HANA Data Provisioning, Delivery Units and Schema Mapping.
• Review and QA deliverables of the team.
• Involved in BW system administration tasks.
• Experience in Creating and executing Data Service Job in SAP BODS to populate HANA.

Environment: SAP HANA, BW 7.3, ECC 6.0, ABAP/4, SD, MM, Inventory Management, Production Planning, WAD, Business objects 4.0 and EP

SAP HANA Developer

Confidential, Greensboro-NC

Responsibilities:

• Environment: SAP BI 7.3 on HANA, Finance and General Ledger Accounting, BPC.
• Worked on SAP BI 7.3 on HANA platform.
• Worked on business requirements gathering and gap analysis to identify gaps that existed from standard business content.
• Involved in SAP data modeling by new HANA models and data analysis by building standard and custom BW solutions such as Info Cube design and creating custom semantically partitioned objects (based on Info Cube and DSO), DSO’s and Info Objects.
• Installed business content and worked on FI data sources 0FI GL 14, 3FI GL 0L TT, 3FI GL DL TT and 3FI GL SL TT.
• Worked on different update modes for uploading data from SAP R/3 to BW.
• Involved in data loading, job monitoring and created process chains for automating the process.
• Worked on in/outbound interfaces.
• Utilized Open Hub service to distribute data to other systems (Hyperion and BPC).
• Collected all the developed objects and released the TR’s.
• Created queries using BEx and then generated universes and reports using Webi.
• Created BI reports and BEx reports on Business Objects tools such as Webi, Crystal and Design Studio and see to the performance issues on both of them.
• Enhanced FI-GL data sources and populated the data from them.
• Worked on transformations and wrote simple routines in ABAP.
• Involved in performance tuning by creating indexes and aggregates
• Created financial and accounting reports in BEx Query Designer in BI

SAP HANA BI Team Member

Confidential, Jersey City-NJ

Responsibilities:

• Environment: SAP HANA 1.0, BI 7.0
• Involved in developing the Attribute Views based on Master Data Tables in the SAP ECC.
• Created the Analytic Views based on the Info cube models in SAP BW/BI system.
• Involved in creating 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) on the BW on HANA database Scenarios and imported them to the HANA studio tool.
• Involved in importing the BW models from SAP BW system (using HANA DB) to the HANA Studio.
• Knowledge in SQL, PL/SQL, HANA SQL Script, Stored Procedures.
• Worked on assigning Analytic Privileges to Views in HANA.
• Knowledge in triggers, sequences and synonyms in HANA studio.
• Knowledge in HANA authorization concepts.
• Knowledge in creating Users and Roles in SAP HANA.

SAP BW BOBJ Team member

Confidential, Jersey City-NJ

Responsibilities:

• Environment: SAP BI 7.0, SD, MM
• Developed several standard and customized master data Info Objects/texts, Info Cubes, DSO and Multi Provider according to specifications provided by the clients
• Performed LO-Cockpit extraction to extract the header and line item data from SD module (Sales Order “2LIS 11 VAHDR/VAITM”, shipping/delivery “2LIS 12 VCHDR/VCITM”, and billing “2LIS 13 VDHDR/VDITM”)
• Extracted master data/transactional data into BI landscape (data from both SAP R/3 and external source systems) with custom extractors, modifications, enhancement of business content extractors, generic extractors, transports and process chains
• Utilized Web Intelligence for web based query and reporting
• Created BI reports on Business Objects tools including Web Intelligence, Desktop Intelligence, Crystal Reports and saw to the performance issues on both of them
• Uploaded vendor master data from MM in SAP as OLTP source and worked with different tables data ECC in SAP project system as well
• Enhanced customized data targets Info Cube, ODS and Multi Provider
• Created Info Packages and populated Info Cubes with initialization and delta loads
• Developed specific queries based on user requirements
• Designed and developed process chains (RSPC) for master data loads and transaction data loads.
• Customized Multi Provider and added necessary object from different DSO’s and Cubes according to client requirement for generating reports
• Wrote complex business documentation such as IDD and TTD

BI Team Member

Confidential

Responsibilities:

• Environment: SAP BW and ECC
• Involved in data loading, job monitoring and created process chains for automating the process
• Installed business content
• Worked on different update modes for uploading data from SAP R/3 to BW
• Configured data sources in R/3 by using LO Cockpit (LBWE) and initialized the setup tables
• Participated in resolving failures that occurred when delta update was going on from one data target to another
• Rectified database errors and timestamp errors
• Involved in performance tuning by creating indexes and aggregates
• Checked consistency of Info Object in RSRV
• Involved in load monitoring using RSPC, RSMO, SM37 and SM50
• EXPERIENCE (CONTINUED)
• Informed onsite people if there were any deadlocks and communicated with the customer
• Improved query performance using various performance tuning methods
• Resolved tickets regarding extractions, performance issues and also load failures

BW Team Member

Confidential

Responsibilities:

• Environment: SAP BW, MM, PP, SD.
• Developed several customized Info Objects, Info Cubes, DSO and Multi Provider according to specifications provided by the client.
• Involved in data loading, job monitoring and created process chains for automating the process.
• Installed business content.
• Worked on different update modes for uploading the data from SAP R/3 to BW.
• Configured data sources in R/3 by using LO Cockpit (LBWE) and initialized the setup tables.
• Participated in resolving failures that occurred when delta update was going on from one data target to another data target.
• Rectified database errors and timestamp errors.
• Involved in performance tuning by creating indexes and aggregates.
• Checked consistency of Info Object in RSRV.
• Involved in load monitoring using RSPC, RSMO, SM37 and SM50.
• Informed onsite people if there were any deadlocks and communicated with the customer who posted the ticket.
• Improved query performance using various performance tuning methods.
• Resolved tickets regarding extractions, performance issues and also load failures.