SUMMARY

• About 8+ years of extensive Techno - Functional experience in SAP HANA, SAP BI/BW, SAP BOBJ/BI and SAP BODS which includes 4 end to end implementations
• Certified on ITILV3, SAP BI 7.0, and SAP HANA 1.0 SPS04.
• Excellent front-end and back-end skills with SAP BI/BW 3.5 to BI 7.0 & 7.3, SAP BO 4.0, 4.1 and SAP BODS 4.0, 4.1.
• Experience in modules like SD, FI-CO, MM, HR and strong emphasis on Business Warehouse
• Implemented full life cycles using ASAP methodology across various modules of (SD, FI-CO, MM) in SAP BI/BW that includes gathering business requirements, analyzing the business process, performing AS-IS Analysis, Identifying and analyzing the Gaps, Implementation, Designing, Configuration, Customization
• Experience in writing ABAP User Exits for transaction data and complex routines in Start Routine, End Routine, Rule types and Formulas
• Experience in preparing Functional specification and Technical specification documents.
• Knowledge on Enterprise Architecture and Project Management Portfolio.
• Experience on Native HANA and SAP BW powdered by HANA
• Experience on SAP Native HANA Data Provisioning (LT, DS), Data Replication, Modeling and Reporting
• Have a good knowledge on SAP HANA Architecture & Landscape
• Involved in designing Dataflow from SAP ECC 6.0 to SAP HANA Database
• Experience in User Management and Analytical privileges
• Involved in Transporting HANA Views from Dev to Pro using Delivery Units
• Have hands on experience on modeling in creating Attribute, Analytic and Calculation Views
• Worked extensively with CE function
• Worked on all kinds of Join Types in SAP HANA
• Experience in creating Stored Procedures, Triggers, Decision Tables, Temporary Tables and History Tables.
• Worked on mixed scenarios between BW and HANA
• Experience in Designing the BW models specific to HANA
• Worked on Composite Providers, Transient Providers and Analytical Index
• Worked on Open ODS and Advance DSO
• Worked on BEx Query Snapshot
• Experienced with creating, modifying and activating Info Areas, Info sets Info-Objects, DSOs, Info-Cubes and Multi-Providers according to the reporting requirements
• Expertise in Data Source enhancements like Loading, Scheduling, Monitoring, Process Chains Maintenance, Reporting
• Extracted data using BW extraction structures such as LO Cockpit, CO-PA, FI and Generic & Standard Extractors
• Experience in BI Performance Tuning by maintaining Aggregates, Compression, Partitioning, and Indexing of Info Cubes
• Created BEx Reports providing insight of Business Intelligence to aid the analysts in decision-making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Customer Exit
• Distributed data from an SAP BW system into external data marts, analytical application using Open Hubs and APD
• Expertise in Business Objects 4.1, 4.0 (CMC, CMS, CCM), Universe Designer, Information Design Tool, QaaWs, Import wizard, Publishing Wizard, Business Views, Xcelsius/Dashboard Designs, Crystal Reports 2011/2008, Web Intelligence and SAP BO Design Studio
• Responsible forcreating mapping and transformationspecifications based on the business requirements from various business teams and implemented inBODS jobs.
• Expertise in creating a Universe using Universe Designer/Information Design Tool from various Source Systems and exporting them onto Infoview/BI Launch Pad
• Hands on experience on working with Report Conversion Tool and Upgrade Management Tool
• Experience in Linking Universe, Canned/Adhoc Reports, Scheduling and Processing of reports
• Extensively used Calculations, Variables, Prompts, and Sorted inputs, Drill down, Slice Dice, Alerts, Input Controls, Tracking Changes, Sorting and Ranking for creating interactive reports
• Expertise in creating Charts/Graphs like Dual Axis, Combined Column and Line, Surface Chart, Stacked Column, Pie with Variable Slice Depth and Cross Tabs too
• Extensively worked on documenting and formatting reports. Have exported them to PDFs published them on BI Launch Pad
• Competency in all phases of the project from Analysis, Design, Development, Configuration, Testing, as well as Documentation, and providing End-User training. Experience in analyzing and creating Stored Procedures, Unit testing, System testing, Integration testing and User Acceptance Test throughout the project

TECHNICAL SKILLS

Data Warehouse: BW 7.4, 7.3, BI 7.0, BW 3.5

DBMS: HANA, DB2, Oracle, Microsoft SQL Server, MS Access and Teradata

Languages: C, SQL, ABAP/4, JAVA,HTML5

ERP Packages: SAP ECC 6.0, R/3 4.7, R/3 4.6

Reporting Tools: BEx Reporting, Web Application Designer (WAD), BWA, Business

Objects: BOBJ (XI R2, 3.1), BI 4.0, 4.1, Xcelsius

Dashboards/Dashboard: Design & Crystal Reports 2008/Crystal Reports 2011, EXCEL, BO Analysis office, SAP Business objects explorer, SAP Visual Intelligence, Predictive Analysis Tool, SAP Lumira. SAP BO Design Studio

PROFESSIONAL EXPERIENCE

Confidential, PA

SAP HANA/BW/BI Consultant

ENVIRONMENT: SAP HANA SP 08, SAP BW 7.3, 7.4, ECC 6.0, SAP BI Platform 4.0, 4.1, BO Design Studio.

RESPONSIBILITIES:

• Involved in designing the functional and technical specs for the ECC 6.0 and HANA Models.
• Involved in SLT for replicating the data from ECC 6.0 to HANA.
• Involved in Provisioning of Data from BODS into Native HANA
• Experience in using HANA as a Data Mart
• Have created and generated the Documentation form HANA into PDF format
• Experience in SAP Native HANA data provisioning using SAP LT Replication Server (SLT) and data services and Flat files.
• Worked on BW powered by Hana.
• Designed and developed custom Hana optimized DSO objects, and activated Transformations for these data targets and evaluates data.
• Experience in SAP HANA security including user management, roles and privileges
• Created In memory optimized info cubes and DSOs.
• Created Information spaces for Hana optimized info cubes.
• Modeling HANA views for BW 7.4 master data and transaction data.
• Created Advance DSO and Open ODS
• Experience in SAP Native HANA data modeling using Attribute View, Analytical view and Calculation view where non BW sources where used.
• Involved in hybrid concept between BW powered by HANA and Native HANA.
• Created Transient Providers and Analytical Index to import HANA Models into BW using T-Code RSDD HM PUBLISH.
• Composite Provider in HANA eclipse.
• Involved in transport of HANA views from Development to Production using Delivery Unit.
• Worked on SAP BO Design Studio and developed reports and exported to Mobile Devices using QR Code.
• Involved in Information Design Tool - Created Relation connection and OLAP connections, creation of data foundation, Business Layer for Hana reporting
• Worked on Query Snapshots using T-Code RSDDB
• Created Explorer reports for BW HANA views.
• Created Web Intelligence reports for HANA views.

Confidential

SAP HANA/BI Consultant

ENVIRONMENT: SAP HANA SP5, SAP BI 4.0, 4.1 and DASHBOARDS 4.0, 4.1

RESPONSIBILITIES:

• Involved in designing the functional specs for the CART Application.
• Developed a high level design and technical specs for the CART Application.
• Involved in Data Modeling activities for using Native HANA as a Data Mart.
• Experience in SAP Native HANA data modeling using Attribute View, Analytical view and Calculation view.
• Involved in information design tool - creation of data foundation, universe for Hana reporting.
• Used SAP BOBJ reporting tools for creating reports on top of SAP HANA.
• Used Query as a Web Service to get the data from Webi reports to Dashboards.
• Used SAP DASHBOARDS 4.0 and created four Dashboards for different solutions namely: Executive Finance Dashboard, Executive Customer Dashboard, Executive Operations Dashboard and Churn Analysis Dashboard.
• Reporting on SAP LUMIRA and BO Explorer.
• Developed IPAD version of Dashboards.
• Involved in CART application certification by SAP AG.

Confidential, AZ

SAP BI Consultant

ENVIRONMENT: SAP BI 7.0, SAP ECC 6.0, SAP Business Objects/BOBJ XIR2, XIR3, SAP BI Platform 4.0 SP4

RESPONSIBILITIES:

• Extensively worked on BI 7.0 data modeling and Extraction along with BIBO Integration.
• Involved in functional team meetings to discuss end user requirements.
• Worked on Business Content for, CRM, Sales and Financial Info Cubes to meet with user requirements
• Responsible for loading Plan/Actual Master data (Texts, Attributes and Hierarchies)/Transaction data from ECC Data Sources and from Flat Files.
• Used the Business Content Sales Overview Info Cube 0SD CO3, for overall Sales Analysis.
• The transaction data is loaded from different Source Systems using the Info Sources 2LlS 01 S260 Sales Order, 2LlS 01 S261 Delivery, 2LlS 01 S262 for Billing Document and 2LIS 01 S263 for Sales Order/Delivery using LO-Cock Pit.
• Maintained extract structures for Sales & Distribution generated data sources & activated the extract structures for the above modules. Scheduled data uploads in cockpit.
• Worked on Time dependent Master data.
• Created a cube to provide reports on the backorders. Sales Document: Backorders ZSD C14.
• Worked on FI-COPA Cubes to store the information for the next level usage.
• The Important cubes used were: Published Key figures, CRM marketing, Consumer Products industry.
• Extensively worked on several kinds of COPA structures: Net sales, Contribution Margin, Operating profit.
• Worked on different levels of reporting required for SD Order intake reports and FI Cash flow reports.
• Analyzed the differences between different kinds of Order intakes in Sales and Distribution.
• Revised existing AP Cash Flow reports to analyze net payment, payment overdue etc.
• Modified existing queries on various Info Cubes related to SD.
• Extensively worked on Query building, Filtering, Free Characteristics, Restricted Key Figures and Variables, Query variants using BEx Analyzer.
• Designed Dynamic dashboards using Xcelsius.
• Worked on SAP BOBJ reporting tools for creating reports.
• Designed and Developed BO reports for Budget Input Application using Web.
• Worked with BEx to generate Queries and embedding them into Workbooks and also published the queries onto the web using Free Characteristics, RRI-Jump Queries, Calculated and Restricted Key figures, Filters, Variables and exceptions.
• Extensively used the Web Application Designer for creating customized templates using web items like Table, Chart, Filter, Map, Web Broadcasting and more.
• Extensively used the wizard in WAD and published the reports on Enterprise Portal as I Views.
• Worked with BEx Broadcaster to schedule monthly sales reports as e-mail to the users.
• Published reports both by using BI Launch Pad

Confidential, PA

SAP BI/BO Consultant

ENVIRONMENT: SAP BI 7.0, SAP ECC 6.0, CO, BEx and Business Objects/BOBJ XI R2.

RESPONSIBILITES:

• Responsible for design, development and extraction from R/3 source system and Flat file to BW.
• Extracted the data using LO Cockpit Extraction from the Data Sources to populate the Custom Info Cubes that evaluates quantities and values for sales orders, deliveries and returns, and invoices.
• Activated Logistic cockpit extractors for sales, billings and purchasing modules and enhanced them to capture the additional information not part of the extractor.
• Extracted Data from Purchasing and Material Management.
• Designed custom cubes and Operational Data Sources, developed delta management functionality and optimal use of update rules keeping query performance in view.
• Used delta update mechanisms for uploading the data to BW from R/3 in specific intervals.
• Extracted Standard Data Sources 0PM MCOST ASSET UTIL, 0PM OM OPA 1, 0PM OM OPA 2, 0PM OM OPA 3, 0PM PRM PLCS 1, 2LIS 17 I3OPER, 2LIS 17 I0ITEM using LO- Cockpit extraction methods for Transactional data and enhanced them to meet the reporting requirements.
• Performed LO - Cockpit extraction for Maintenance orders, Planned Cost Maintenance, Plant Maintenance Orders.
• Created Reports using Webi Intelligence used multiple sources to create reports, Combined Queries, Slice and Dice, Drill Down, cross tab and Master Detail Reports.
• Created Reports using all the BOBJ functions like Drill Down, Prompts, and Dimensional and Measure variables to show accurate Results.
• Created alerts, filters and inserted Breaks in designing reports.
• Used prompts and cascading Prompts to make the reports confined to a particular case as per the business Requirement.
• Created reports in Crystal Reports by using BEx Queries from SAP BW.

Confidential

SAP BI/BO Consultant

ENVIRONMENT: SAP BI 7.0, SAP ECC 6.0, MM, HR and Business Objects/BOBJ 3.1

RESPONSIBILITIES:

• Activated Business Content for Standard Info Cubes, Info Sources &Info Objects of MM and HR-Payroll Modules as per the Client Requirements.
• Maintained extract structures for Inventory and HR. Generated data sources & activated the extract structures for the above modules.
• Designed and developed custom ODS objects, Info Cubes for Inventory data and activated Update rules for these data targets.
• Responsible for job schedules for loading Master data (Texts, Attributes and Hierarchies) for Materials and Sales arenas.
• Created different Reports in MM such as product stock value available based on the product type, bestselling products, Billed selling orders based on territory etc.
• Worked on Inventory cubes for business content DS. Analyzed the requirements to implement Snapshot scenario for cumulative key figures.
• Worked on 2LIS 03 BX, 2LIS 03 BF, 2LIS 03 UM Data Sources.
• Worked on 0HR PT 01 0HR PT 02
• Created Info Packages with Full Loads, Delta loads, Initialization with/without data transfer etc. Tested the data loadings, delta loads and verified data with R/3 side.
• Worked on creating start routines and end routines in update rules to ensure proper loading of data.
• Developed BEx queries for reporting on InfoCubes, InfoSets, ODS and Multi Provider by defining Structures, Variables, Formulas, Exceptions, Selections, Navigational Attributes, Conditions providing drill down functionality in reporting
• Extensively worked on formatting Business Objects/BOBJ reports to meet the user’s requirements using Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Contexts, Alerts
• Extensively Worked with SAP to create connections between Xcelsius Dashboards. Worked on INFOVIEW to create Web Intelligence Reports over BO Universes.

Confidential

SAP BW DEVELOPER

ENVIRONMENT: SAP BW 3.0, SAP R/3

RESPONSIBILITIES:

• Involved as a key member of project teams through all phases of realization, go-live, rollout and post implementation support of SAP BW in FI modules.
• Working knowledge of SAP ASAP methodology in Software Development Life Cycle.
• Experience in working with Standard and Custom Info Cubes, Info Objects, Info Sources, ODS, Multi Providers and performance tuning
• Stored data from R/3 tables into ODS objects through PSA to perform detailed level reporting
• Created Process Chains for data loading, delta uploading and periodical PSA deletion
• Extracted the standard Business Content as well as worked on creating Info Sources, Info Objects, Info Cubes, ODS Objects, Transfer/update rule process chains.
• Installed business content Data Sources for Sales, Billing, and Finance reports.
• Worked on 2LIS 11 VAITM, 2LIS 12 VCITM, 2LIS 13 VDITM, 0FI AR 4, 0FI AP 4.
• Performed Logistics Cockpit configuration and customization for sales order overview and extended the extract structures using user exits to meet the necessary business requirements.
• Uploaded master and transactional data from flat files and SAP as the OLTP source. Worked extensively on administration workbench.
• Created regional Sales Summary cube to Sales, Delivery and billed items information. Used LIS extractors to pull the data from SAP R3 production system.
• Used ODS to stage the data before transferring the ODS contents to the Info Cube, performed ODS reporting to give details of delivery items and schedule line items.
• Designed Info Cubes with daily and Monthly Granularity, extraction from PSA.
• Maintain the list of all the activities for all the tickets until it is closed down. Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Designed and implemented configuration changes for both load performance and query performance optimization.