SUMMARY

• SAP BI consultant with over 9 plus years of IT experience in SAP BW version 3.5, NW 2004s BI 7.0, 7.4 experience and 3 years of Business Objects experience.
• Around 3 years of experience in SAP HANA Enterprise Development.
• Experience with various source data replication mechanisms, (ETL/SLT/Trigger based).
• Experience in designing the data modeling in different levels in End2End SAP HANA solutions.
• Technical proficiency in various areas of SAP BI/BW like Modeling, Extraction, Reporting with expertise in handling implementation and Support projects, resolving user incidents.
• Experience with SAP HANA Data Provisioning and using SAP LT Replication Server (SLT)
• Experience with Data Extraction Transfer Loading (ETL) using SAP BOBJ Data Services 4.0
• Experience with SAP HANA Data modeling using Attribute View, Analytic View, and Calculation View.
• Experience in using the SQL scripting V 2.0 in Calculation Views to fulfill the complex business needs.
• Knowledge of SAP HANA SPS 09/10/11 including good hands on work experience in HANA modeling.
• Experience handling integration between multiple systems for reporting - SAP ECC, SAP BW, BOBJ integration
• Experience with SAP HANA Migration & Optimization HANA sizing and performance tuning.
• Experience with SAP HANA Administration including managing schemas, data model objects, import/export content.
• Experience with SAP HANA Security including User Management, Roles, and Privileges.
• Extensive front-end experience with BEx Query Designer, Experienced in BW-BO integration development using BOBJ tools - Universe DesignerTool, Information Design Tool, WebI, Xcelsius/Dashboards, QaaWS, Live Office & Crystal reports, CMC.
• Experience in BOBJ 4.0, 4.2 versions with BI Launch Pad.
• Expertise in Design, Development and Deployment of Business Objects solutions for Corporate reporting requirements and involved in a full life cycle implementation of SAP BI/BO.
• Experience in building universes, developing reports and analyzing OLAP data. Worked in various BO environments linking data from multiple sources, applying several functionalities and using various Data Providers. Trained users in producing documents and running queries. Worked with various teams for different tasks. Tested reports for validating and verifying data.
• Trained End Users in SAP Business Objects tools like Universe, Web Intelligent, Dashboard/ Xcelsius 2008.

TECHNICAL SKILLS

Business Reporting: Business Objects 4.2, 4.0, 3.1, Central Management Console, Central Configuration Manager, Info view, ABAP, Web/Desktop/OLAP Intelligence, Designer, Administrator, Dashboard Manager, Crystal Reports 2008/XI, Xcelsius 2008/4.5, Reports and Xcelsius Data Visualization, Live Office, QAAWS, Import Wizard, SAP HANA 1.0, 2.0

Dimensional Data Modeling & ETL: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling,, SAP Business Objects Data Integrator XI 3.1/R2, SAP HANA 1.0, 2.0, SAP ECC 6.0

DataBase Management Systems and Tools: Oracle 11i/10g/9i, DB2 8.2/8.0, MS SQL Server 2008/2005/2000 , MS Access 2000, Open SQL, SQL * Plus, PL/SQL and Oracle DBMS Packages, SQL Developer.

Languages/Web/Mobile: SQL, My SQL, HTML, XML

Application Tools: MS Word, MS Excel, MS PowerPoint, MS Project

Other Tools: SAP BODS 4.0

PROFESSIONAL EXPERIENCE

Confidential - Hopkins, MN

Sr.SAP BI Back End Developer

Environment: S/4 HANA, SAP HANA 2.0, SAP ECC 6.0, BI 7.01, 7.3, 7.4 BOBJ 4.1, BODS 4.2, Microsoft Power BI

Responsibilities:

• Architect, Design and Develop near real time Data Warehouses and BI solutions using SAP HANA.
• Translate Complex business requirements into scalable technical solutions meeting Data Warehousing standards.
• Extensive SAP Implementation experience using AGILE & ASAP methodologies with Project Preparation, Blueprint, Realization, Final preparation, Go Live and Post Implementation Support.
• Expertise in SAP HANA data modeling using Attribute View, Analytical View, Calculation View, CDS Views, Stored Procedure, SQL Scripting, Table Functions, Decision Tables and Analytical Privileges.
• Strong knowledge and expertise in Data provisioning techniques SAP SLT, DXC, SDA & SDI.
• SLT table replication configuration for enterprise HANA which includes table replication, data filtration (Include programs), table columns selection, Data load conditions and Table replication partitions. Identifying table size before replication which will help to take table replication decision.
• Configured Smart Data Access (SDA) in HANA in order to access big tables into SAP enterprise HANA views instead of SLT replication.
• Expertise in Native HANA hands-on development experience creating SAP HANA information models.
• Proficient in interpreting and writing complex SQL Procedure and translating business needs into Data Modeling and Reporting Solutions.
• Understanding of SAP OTC processes, standard best practices, and key integration points with FICO and PTP processes.

Confidential - Corona, CA

Sr. SAP BI/HANA Consultant

Environment: SAP BI 7.0, 7.02, Contact Net, SAP HANA 1.0, 2.0, BODS 4.2, BOBJ 4.0, ECC 6.0

Responsibilities:

• Deep understanding of HANA Architecture, SAP BI Suite and Hadoop.
• Experience with Agile implementation methodology and working in a globally distributed team structure.
• Experience in creating SAP HANA Information models such as HANA views (Attribute, Analytics and Calculation views) with graphical and SQL scripting, procedures Schema management, Data provisioning technology including SAP LT Replication Server, SDA (Smart Data Access), Data Services (BODS), Troubleshoot and resolve technical issues, Debug, Tune and Optimize report performance.
• Developed Attribute views, Analytic views and Calculation views for Sales and Finance tables replicated from ECC to HANA via SLT.
• Experience of working with BW models in HANA eclipse environment such as Composite providers, Advanced DSOs and using BW objects exposed as HANA views.
• Experience developing end to end data flows for all the data models.
• Created Analytical privileges to control the data for the various business requirements.
• Applied Security and Administration by creating the Users and Roles for the Organizational level visibility.
• Leads Prototyping and Testing activities, ensures Technical documentation is accurate and leads Design and Code reviews.
• Provides daily support and resolves complex or highly complex technical issues after Go-live period related to WEBI and Dash Board reports. Works with SAP Principle Developer to define system Scope, Objectives and Solutions based on user needs and Documents detailed Design of Components/Aspects of the software.

Confidential - Santa Clara, CA

SAP BI/BOBJ/HANA Consultant

Environment: ECC 6.0, SAP Business Objects Enterprise 4.0, Information Design Tool, Interactive Analysis, SAP HANA 1.0, BODS 4.0

Responsibilities:

• Involved in Architected and Designed solutions for replacing the old SAP BW system with SAP HANA Enterprise using SLT and BODS.
• Built HANA models for SAP SD, GL, FI-AR, FI-AP, and Inventory and built reconciliation queries between SD, FI-GL and Inventory.
• Integrated SAP and Non SAP Data through SLT and Data Services into HANA DB
• Built complex SQL Procedures to fulfill specific customer requirements.
• Involved in hybrid concept between BW powered by HANA and HANA enterprise.
• Hands-on experience working with SAP BW on HANA features, Standard and Custom SAP BW Extractors, Complex transformations using ABAP, advanced DSOs, Composite providers, exposing BW models as HANA views, Mixed scenarios, HANA Analysis process in BW and LSA ++.
• Created Transient Providers and Analytical Index to import HANA Models into BW using T-Code RSDD HM PUBLISH.
• Experience in SAP HANA security including User management, Roles and Privileges.
• Extensively used the Bex Query designer and Analyzer for customizing and troubleshooting queries for creating the foundation for reporting out of Business Objects.
• Developed 5 Complex Interactive Analysis reports involving multiple Bex queries to a single report, Calculated Key Figures, Restricted Key Figures, Hierarchies, and Reports with Input Controls etc.
• Created OLAP Universes on SAP data (Info cubes / BEx queries) and Relational Universes on Non-SAP data using the Information Design Tool.
• Designed a Multi-source Universe using the Federated Layer Concept in the Information Design Tool.
• Worked with Admin Team to integrate Dashboards, Reports into Enterprise Portal and BI Launch Pad for end user access.
• Created Complex WEBI reports for Finance and Accounting, Sales, Merchandizing and Marketing and Operations.
• Extensively worked with the performance issues at Query Level and Report level by Creating Prompts, Creating derived tables and also making the customized Query to the Report generated Query.
• Applied Row level and Object level securities to different groups to restrict the data in Supervisor module.
• Trained business users on the different tools present in the Business Objects platform for the future handling of the reports developed using staggered training methodology.

Confidential - Florida

SAP BW/BOBJ Consultant

Environment: ECC 6.0, SAP Business Objects Enterprise 4.0, Information Design Tool, Interactive Analysis, Dashboard Designer, ABAP, Advanced Analysis for OLAP and Microsoft Office BI Launch Pad,, Business Objects Explorer, BIWS, Query Browser

Responsibilities:

• Involved in complete life cycle implementation which includes Gathering Requirements, Analysis, Data modeling, Design specification, Development, Data extraction, Reporting, Performance tuning, Unit testing, Trouble-shooting, Integration and acceptance testing, Documentation and Maintenance.
• Going through the Technical Specification and performing GAP Analysis.
• Involved in creating the Custom Cubes and Extracted data from SAP R3 system for various Info Cubes including Billing, Sales, Delivery, FIGL, FIAP and Purchasing.
• Uploaded Master data and Transactional data from SAP R/3 via Data staging to PSA, ODS and Info Cubes.
• Handled tickets regarding extractions, Performance Issues and also load failures like monitoring of Info packages and analyzing. Worked on incidents related to CS data flow.
• Created Info cubes, DSO, Multiprovider based on Sales, Inventory and Financial reports.
• Designed BEx and BO Queries using Structures, Cells, Variables, Static and Dynamic Filters, Restricted and Calculated Key Figure in Query Designer.
• Design, and create Universes and reports for the Sales, Billing, Material Management, Financial system using Business Object at front end and SAP BW as back end.
• Created complex WEBI reports with multiple queries, Custom Sql, using Complex functions, merging dimensions at report level, Drill down, Drill up, Drill across and Complex filters etc.
• Worked as an administrator in creating users and folders and managed access privileges in windows.
• Developed Universes on the top of Bex Query’s.
• Created Xcelsius Dashboards for Sales and Product level data based on Product Age & Usage using various components of Xcelsius.
• Extensively usedCalculations, Variables, Break points, and Sorted inputs, Drill down, Slice and Dice, Alerts inCreating Reports, Formatted old reports, Generated charts and Bars etc. as per user requirements usingXcelsius 2008.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Trouble shooting and tuning of the reports to reduce the performance time of the reports.
• Tuned the queries to improve the Performance of the existing Reports for various functional areas.
• Applied security features of Business Objects like report level & object level security in the Universe so as to make the sensitive data secure.
• Created Dashboard, Spread sheet Table, Score card, Chat, Selectors, Check box, using the Xcelsius components.
• Created universes, classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.
• Resolved loops and Traps, created complex Reports, Cross Tab and Master Detail reports by using BO Functionalities like Slice and Dice, Drill Down, Variables, Filters, Breaks, Alerter and other features.
• Utilized LCM (Life Cycle Management) tool for promoting/migrating WEBI reports and Universes from development to production environment.

Confidential

SAP BW Associate Consultant

Environment: SAP BI 3.5, 7.0, ECC 6.0, SAP Business Objects Enterprise 4.0, Business Explorer (BEx), Crystal Reports Enterprise 2011, ABAP, Information Design Tool, Interactive Analysis, Dashboard Designer, Advanced Analysis for OLAP and Microsoft Office BI Launch Pad, QAAWS, Live Office, Business Objects Explorer .

Responsibilities:

• Involved in full life cycle implementation, which includes Gap Analysis, Requirements Gathering, and Blueprinting, Development, Testing, Reporting, Go-live and Post Go-live support.
• Understood the business challenges and translated them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
• Enhanced Business Content to meet the requirements and created custom Info Source/Data Source, ODS, and Info Cubes.
• Involved in security and technical upgrade to BI 7.0 during the implementation of BO 4.0 in Co - Ordination with Basis team.
• Involved in modules majorly Accounts payable (AP), Accounts Receivable (AR), Sales and Distribution (SD) in order to enter billings in R/3 tables and pulling to BW for reports to end users and sales team by customizing them as per the client requirement.
• Performed LO-Cockpit extraction to pull data from ECC SD modules into BI system extracting the Header and Line item data from the Sales and Distribution modules Sales Order 2LIS 11 VAHDR / VAITM, Shipping/Delivery 2LIS 12 VCHDR/VCITM and Billing 2LIS 13 VDHDR/VDITM.
• Designed and developed various BI Objects like Info objects, Multi providers, Info cubes, DSOs, (Direct update, Write-optimized, Standard) Extractors for Sales, AR, AP.
• Used APD’s (Analysis process designer) in generating files and reports for project Sustainability and sales force team by doing complex routines (ABAP) and critical joins according to end users and sales team requirements in a quick time.
• Worked on BI Related ABAP (Start Routine, End Routine, Customer Exit, User Exit, Generic Data source Using Functional Module).
• Modify customer exits using CMOD, SMOD transactions.
• Writing ABAP code in BW routines for transformation or modifying source data, filter data etc.
• Creation and transportation and scheduling of Process Chains.
• Monitoring the data loads from various source systems by means of process chains/batch jobs.
• Maintaining reconciliation’s to verify the data in SAP R/3 and SAP BW after the data loads.
• Worked on Performance Tuning Techniques like Creating a process chains to delete PSA and Change log Table on regular intervals.
• Created BEx queries for reporting on Info Cubes, Info Sets, DSOs and Multi Provider.
• Created Daily Sales Reports which involves Daily Sales Orders, Order Reasons, Customer Group and other important sales data.
• Created Daily Invoicing Report involving all import billing data and created Daily Back Order Report involving import sales, material and date.
• Worked on Query building, Filtering, Free Characteristics, Restricted Key Figures and Variables using BEx Analyzer.
• Involved in Performance Issues like Creation of Aggregates, Compression & Partitioned the Info cube to improve the query response.