SUMMARY

• Close to 7 years of professional experience in ETL, Data warehousing, Data modeling and Business intelligence solutions usingSAPBW, HANA,BWon HANA, Reporting tools.
• Extensively Worked onHANAdesign studio in Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytic Privileges and interfacing with SAP and Non - SAP systems.
• Expertise in designing BWmodels and managing ETL process of data warehouse, data services, migration, transformation and cleansing the legacy system data via BODS.
• Certified in SAP HANA Application Associate (C HANAIMP151) with 90% score.
• Knowledge of S4 Hana. Enabling high-speed real time data without any constrains.
• Optimization of Business Processes with real time execution in SAP S4 Hana.
• Worked on upgrade projects of SAP R/3 4.6 to ECC 6.0 and Enhancement packs from EHP 4 to 7.
• Technically experienced in using OLAP tools Business Warehouse 7.0 and Business Objects XI 4.0
• Expertise in Business Objects Products (Designer, Information Design Tool (IDT), Desktop Intelligence, Web Intelligence, Crystal Reports, Info View & CMC) and its deployment
• Expertise in Universe designing/developing and generating reports with complex, business views, ad-hoc reports, dashboards, list of values (LOV) along with user acceptance test (UAT)
• Knowledge about the integration of SAP Business Object tools with SAP BI/BW.
• Experienced in creating reports with Filters, Formula, Groups, Parameters, Charts, Flash Objects, etc.. using Crystal Reports
• Expertise in creation of Standard reports, Cross-tab Reports, Sub Reports and Drill Down Reports using Crystal Reports.
• Extensive experience in BW Modeling- Info Cube & DSO design, 7.0 & 7.3 Info Sources, Info Object maintenance, Hierarchies, Multiproviders, Info Packages, Transformations, DTPs, Update and Transfer rules.
• Extensively worked on BW Extractions - LO extractions, Generic Extractions, data extraction from flat files for Master Data and Transaction Data
• Extensively worked on BW Reporting - BEx Query Designer, BEx Analyzer, and Web Application Designer. Created custom queries using Conditions, Exceptions, Filters, Calculated Key Figures, Restricted Key Figures, Variables & Structures
• Highly versatile; quickly master new roles, responsibilities, technologies, and environments
• Strong knowledge in Python, SQL, and Matlab.
• Excellent communication, analytical, interpersonal, and presentation skills, expert at managing multiple projects simultaneously

TECHNICAL SKILLS

ERP/CRM: SAP ECC 6.0, R/3 4.6C

Data Warehousing: SAP BW 7.0/7.31, BO XI 4.0

ETL Tools: SAP BO Data Services

Languages: C, SQL, PL/SQL

Databases: Oracle, MS SQL Server, MS Access

Operating Systems: Win 7/XP/NT/2000/9x, Unix/Linux, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

SAP HANA CONSULTANT

Responsibilities:

• Hands on experience in creating Attribute, Analytic and Calculation views as per the requirements.
• Worked on replicating data from SAP/Non SAP sources to target system using SAP landscape transformation (SLT), Businessobjects data services (BODS), DXC and Flat file uploader.
• Involved in Enhancement Package EHP7 for S4 Hana implementation.
• Developing user interface SAP Fiori, allowing personalized, modern and consistent user experience across the applications in S4 Hana.
• Created virtual tables in HANA from other databases using Smart data access (SDA).
• IntegratedHana Information views with reporting tools like SAP Lumira, MS Excel, crystal reports, Web intelligence, Explorer, Analysis for OLAP and Dashboards using SAP design studio.
• Experienced in data modeling like Info objects, Info providers, Info sources, Data sources, Transformations routines, DTP, DSO using data warehouse workbench.
• Migrated the developed HANA models cross the system landscape from Development to QA etc.
• Worked with different type of joins Inner Join, Left outer join, Right outer join, Referential join and Text Join while creating HANA Calculation Views.
• Created Calculated Columns, Restricted Columns and Input Parameters for dynamic selections and leveraged stored procedures and Functions
• Good Knowledge inSAPHANA security including User Management, Roles and Privileges.

Environment: SAP HANA, BO XI 4.0 and Oracle

Confidential

SAP BW Consultant

Responsibilities:

• Worked extensively in creating BW objects like info objects, DSOs, Info cubes.
• Created and managed dataflow using DTP, transformations and info packages
• Experienced in extracting data from source systems and flat files into BW.
• Generated reports in WEBI, Analysis for office and Crystal reports.
• Worked in Generating Dashboards in BO Design Studio.
• Involved in Full cycle Implementation of integrating the functional areas MM,SDand PP with BI/BW.
• Responsible for Design of data models, comparing the model with delivered contents and implementing the business logic with delivered contents along with modifications.
• Good functional knowledge of Sales & Distribution (Sales Orders, Deliveries & Billing), MM (Purchasing), FI and general business process ofSAPR/3.
• Activated Sales and Distribution, Purchase Info cubes and DSO objects from the Business content and customized according to business needs.
• Performed statistical setup for purchase, Sales, Billing and Shipment and extracted the data to BW.
• Created sales, product margin & profitability analysis reports using data from BW Info cubes
• Tested all the standard SAP functionality and Custom SAP functionality of CUMI. This included business scenarios and a list of special functions.
• Developed DSO object, Info sets and multi cubes for the COPA with Sales order to suit the query requirement
• Extraction of data from SAP R/3 for various info cubes including Sales Center performance data, Statistical Key Figures info cube, Regional Sales, Sales Overview Info cube, Customer Data Info cube, Material Data info cube, Corporate View Info cube and various other info cubes.
• Extracted transaction data from R/3 toBWfor sales on a daily basis and master data for Customers on a weekly basis using delta initializations and delta loads.
• Worked on job schedules for loading data and monitoring Process Chains to run periodic loads and other processes.
• Extensively used Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Involved in support activities for Daily Load monitoring, daily process flow consistency, recover failed data loads
• Worked with Calculated Key Figure, Restricted Key Figures, Filters, Conditions, Free Chars and Variables etc.
• Expertise in ETL activities like Data Extraction, Data Modeling and Loading
• Data Source Enhancement according to customer requirement.
• Involved in frequent client meetings to discuss project status.
• Improved query performance and data load using aggregates, compression and partitioning techniques.

Environment: SAP BW 7.0/7.31, ECC 6.0, BO XI 4.0, Oracle