Sap Data

Location:

Posted:

March 01, 2016

Resume:

SAP BI / BW / BO/HANA SPECIALIST

SAP Certified Business Intelligence Professional offering 5 years of solid experience, with expertise in SAP BI / BW / BO Solution Design & Development, Project Execution and Production Support

Current domain concentration includes Accounts Receivables & Accounts Payable, General Ledger, Order Management, Procurement and Inventory Management modules

Profile Summary

Skilled in full life-cycle implementation of various versions of SAP viz. SAP R/3, ECC6.0, SAP BI 7.1, SAP BI 7.0, SAP BW 4.0, WebI Rich Client, Xcelcius, SAP R/3+SAP BW, SAP BASIS, SAP Security, SAP BI and SAP Business Processes (Order to Cash, Procure to Pay and Production Planning & Control), SAP BW 4.1

Experience in developing data models in HANA 1.0 SP2

Hands on experience on PL SQL

Strong understanding of OLAP, In-memory methodology

Expertise in the front end business warehouse components like BEX analyzer, Query designer, Universe,Web Application Designer, Web Reports, WEBI, XCelsius (Dash Boards)

Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks

Sound understanding of full SAP BW / BI Solution Design & Development from business requirements analysis stage to architecture design including development, assessment of existing SAP BW / BI implementations, and providing advice on structural improvements in the areas of performance, usability, architecture, processes and organization.

Proficient in working on SAP BW/BI components and ETL Process like creating Info Cubes, Multi Providers, Remote Cubes, Transactional Cubes, Data Marts, Info Source, Info Package, Data Source, Info Objects, ODS (DSO), Update Rules, Routines, Transfer Rules, Process Chains and Event Management for Automation Process, Transformations in BI 2004s

Knowledge in BW Accelerators, Star Schema,Extended star schema, Dimensional and Fact tables.

Experience in the OLTP extraction of data of SAP LO-Cockpit, MM,generic extractions,Enhancements and extraction from flat files, non-SAP systems and DB connect.

Expertise in the front end business warehouse components like BEX analyzer, Query designer, Universe,Web Application Designer, Web Reports, WEBI, XCelsius (Dash Boards).

Good Knowledge in SAP HANA data modeling using Attribute View, Analytic View and Calculation View.

Good knowledge in Direct Extractor Connections.

Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.

Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)

Have good hands on experience in ETL and Data Cleansing applications using Infomatica Power Center, Oracle Warehouse Builder, Data services/ BODI, and PL/SQL

Ability to work directly with business analysts to translate functional design into technical specifications. Excellent client interface skills as a trusted advisor while leading an implementation team through all the phases of project delivery and maintaining constant alignment of the solution to changing business needs

Strong leader and a team player with strong analytical, problem solving, interpersonal skills resulting in on-time and on –budget delivery.

Work Experience

Converse – Senior BI Analyst (June 2015 –Present)

SAP BI with HANA and Business Objects implementation

Designing, configuring, implementing & supporting complex SAP’s BW solutions, front-end to back-end; designing, implementing & supporting complex extraction, transformation and loading of SAP BW Data. Designing and developing reports using BW 3.5 and 7.0 with HANA as database

Developed analytical, attribute and calculation views using SAP HANA.

Enhancement of existing reports, report testing and validation.

Creating BO Webi reports, BOBJ universes on top of HANA views using IDT

Teras Consulting – Freelance SAP BW/BO Consultant (Feb 2015 –Apr 2015)

SAP BW with HANA implementation

Developed analytical, attribute and calculation views using SAP HANA.

Pricewaterhouse Coopers, (PwC) India – Senior SAP BW/BO Consultant (2012 –Dec 2014)

Project/Client Management

Working with Senior Management and Business Users to define goals, scope and deliverables resulting in an approved project plan. Regular client communication of progress and risk.

Leading all phases of the project life cycle including analysis, design, development, testing, deployment and post-production support/maintenance. Track deliverables and manage project risk.

Developing technical architecture and high level design for development projects; creating and managing technical documentation including unit, integration & acceptance test plans, support documentation and end user documentation; ensuring adherence to and enforce day-to-day support policies and service level expectations.

SAP BW

SAP BI

Implementing objects as per the front-end and back-end design documents, data loading and building queries based on various InfoProvider using filters, restricted key figures, exceptions, variables & structures and RRI

Installation and deployment of Business content objects, LO extraction, Generic extraction and customization and enhancement of the extract structure to support business needs

Managing technical implementation of SAP systems entailing mapping of business requirements (As-Is & To-Be Analysis) and track and manage changes

Handling all Support Issues, Transport Requests, Defects, and Release Management; participating in client meetings, conference calls and discussions; chairing/leading multiple client level meetings; updating and maintaining the Project Schedules and deliverables.

Planning, scheduling, reviewing and implementing changes on remedy adhering to Change Management Process; administering User Creation, Deletion, Locking/Unlocking and Authentication; checking the missing authorizations, roles and maintaining profile

Recent Projects/Clients include:

Client: Municipal Corporation of Greater Mumbai, Mumbai

Period: Since Nov’13-Dec’14

Role: Business Analyst for SAP BW

Job Responsibilities

Worked closely with stakeholders to analyze business requirements, and define target SAP BI/BW solution architecture and associated technical specifications & implementation plan.

Designed analytical and attribute views on monsoon data in HANA Modeler to enable MCGM to forecast monsoon patterns and develop contingency plans.

Assisted SAP Basis in data provisioning into HANA system using SLT server.

Performed analysis and design; wrote technical specifications; configuration and programming in the SAP/BI environment, including testing and implementation.

Built and enhanced BI objects such as Info Objects, Info Cubes, Info Sources/Data Sources, Master Data, Transformations, DSO, Extractors, Infosets, Aggregates, Process Chains, user Exits.

Delivered data models to extract data from SAP ECC and development of ABAP objects with SAP BW.

Responsible for programming, testing, debugging, and documenting highly complex ETL applications using SAP BW and ABAP routines/transformations.

Understood business requirements, determined implementation strategy and translated into reports that conform to reporting best practices and standards.

Developed unit, integration, and performance test plans.

Worked on user management, security roles and user profile management.

Effectively presented information in the form of formal presentations and regular status to management and business partners.

Organized training sessions with the stakeholders.

Responsible for performing many phases of the software development lifecycle including technical research, requirements analysis, high level and technical design, unit testing and deployment using Business Objects, Crystal Report in Window/Oracle Database environment.

Client: Commercial Tax Department, Raipur

Period: Jul’13 – Oct’13

Role: SAP Business Objects Developer

Job Responsibilities

•Designed universes against the different database, defining the necessary connections and Exported them to specified universe domains

Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documents them textually or within model.

Created standard and Ad hoc reports using Business Objects functionality's like Slice and Dice, Templates, Drill Down, @Functions, Cross Tab, Master Detail and Formula's, Breaks and Custom Sorts in reporting

Created dashboards using Xcelcius

Responsible for creating the reports (On demand, Ad-hoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab, graphical, etc) on Web Intelligence tool

Client: GMR Group, Bangalore

Period: Dec’12 – Jun’13

Role: SAP BW Developer

Job Responsibilities

Collaborate proactively with various stakeholders to gather requirements in order to recommend and develop solutions.

Responsible for programming, testing, debugging, and documenting highly complex ETL applications using SAP BW and ABAP routines/transformations.

Data modeling on SAP BW 7.x LIS Extractors – SD, PP, MM, PM, COPA Extractors.

Delivered data models using BW data modeling tools and developed Info cubes, DSOs, Multiproviders, Info sets.

Responsible for designing, leading and implementing metrics and KPI dashboard solutions using WEBI/XCELCIUS.

Understand business requirements, determine implementation strategy and translate into reports that conform to reporting best practices and standards.

Worked on SAP Business Objects 4.0 (Universe Designer/IDT, Dashboard designer, QAAWS, BIWS, WEBI Rich Client, Import Wizard, CMC, Info view etc.) and SAP BW Environments.

Client: Essar Oil, Mumbai

Period: Aug’12 – Dec’12

Role: SAP BW Developer

Job Responsibility

Responsible for designing, leading and implementing Reporting solutions.

Responsible for BW architecture and data modelling, i.e designed data models for BI Info Cubes, DSO objects, and Multiproviders. Designed custom Data sources, Info Sources and Data targets.

Implementation of SAP BW LO modules – LIS Extractors using ETL process.

Implementation of SAP BW Financial Accounting, COPA - AP, AR, GL and SL

Collaborate proactively with various stakeholders and brand managers to gather requirements in order to recommend and develop solutions.

Implemented and delivered enhancements to extractors using the ETL routines. Configured SAP Business Warehouse to best support business requirements

Studied the Processes, Data flow, Work flow, Control Procedures, and reporting aspects of the existing systems in order to do Business Process Reengineering.

Drilldown Analysis Requirements and Dash Board analysis of BW reports, publishing of the Web reports Defining Data Sources for Generic Data Extraction creation and designing Business and Technical specifications.

Executed and integrated system unit testing to validate that the business requirements are met by the SAP system; documents unit testing results

Extensively worked on Query Designer and Web application designer to create Queries to forecast sales, budget and delivery analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.

Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing. Tuned queries using Partitioning, Aggregates and Multiproviders.

General Motors, GM India – Assistant Manager (Aug 2011 –July 2014)

Assisted in Purchasing for Global Purchasing and supply chain department with General Motors

Acted as Client facing contact for SAP BW 7.0 Implementation with the implementation vendor.

Interaction with the end users during the requirement gathering phase and preparation of test cases for report testing and development scenarios.

Extensively worked on Query Designer and Web application designer to create Queries to forecast accounts payables, supply chain and Materials management using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.

Emerson Network Power(May 2010-October 2010)-Intern

Worked on Oracle UPK, to document the business processes.

Got exposure to Oracle apps procure to pay as well as order to cash business processes.

Past Experience

County of Los Angeles, Los Angeles CA - SAP Net Weaver 7.0, SAP ECC 6.0, Unix

Microsoft, India - JavaScript and ASP.NET

HCL Comnet Ltd. India -Systems Analyst

Polaris Software Labs Ltd. India - Software Developer

Education

M.S. (Engineering Management) from University of Southern California - 2010

B.E. (Computer Science) from University of Mumbai - 2006

SAP Certifications

SAP America HANA Certification - 2015

SAP Certified Application Associate in Business Intelligence with SAP NetWeaver 7.0 - 2012

SAP America Academic Alliance Certificate from University of Southern California - 2010

Professional Affiliations

Member of Viterbi Graduate Student Association at USC

Member of Information Systems Association and Computer Society of India

Personal Details

Migrating to the US in April 2015. Available immediately.

Technical and project addendums available on request

Technical Addendum

Queries, Calculation & Restriction of Key Figures, Structures, Variables, Exceptions, Conditions, Crystal Reports, Authorizations, User Profile Maintenance, BEx Analyzer, Info Set Query, RRI, Web Reporting and Workbooks

Extracting Data from SAP R3/ECC, non-SAP systems and flat files

OLAP reporting in BW and implementation of BEx Analyzer

Development of reports, analysis and Web reporting using BEx Query Designer & BEx Analyzer

SAP Installation, SAP Web Dispatcher, SAP Router Configuration, Transport Management System Configuration

SAP Implementation, SAP SD, SAP MM, SAP PP Integration for Business Processes

Mapping of As Is-To Be system requirements for SAP MM up gradation from SAP R/3 4.7 to ECC 6.0

End to end functions on SAP R/3 systems for e.g. role building, configurations, role maintenance, security for new production releases, user creation and troubleshooting

Working with external interfaces e.g. Legacy System Migration, etc.

Central User Administration and SAP Net Weaver for User Management

Use of Linux platform for troubleshooting to enhance the efficiency of the client pipeline and ensured end-to-end connectivity of the data packets

Creation of Aggregation Levels, Planning Filters, Planning functions, Planning Sequences, Data Slices, Characteristic Relationships using Integrated Planning

Planning Functions using Fox programming to process plan/Actual data based on the requirements

Debugging Data load errors, Delta Queue Monitoring, and Extractor Checker by simulating BW asking for data and Customer Exits, Master/Transaction Data Testing

Extracting data from SAP R3/ECC, non-SAP systems, and flat files

OLAP reporting in BW and implementation of BEx Analyzer (Worked with BEx Query Designer, BEx Analyzer for developing reports, analysis, and Web reporting).

Experience in OLAP functionalities like Scope of Analysis, Drill Analysis and Slice & Dice

Experienced in Business Objects Universe Designing, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view, CMC and Business Objects Enterprise and Xcelcius Internships

Others:

SAP BW Versions: 7.3/7.0/3.5/3.0/2.1C.

SAP R/3 Versions: ECC 6.0, 4.6; SAP CRM Versions: 6.0. ; SAP SRM Versions: 6.0.

SAP Business Objects: Business Objects Web Intelligence 4.0, Dashboards 4.0/ Xcelsius. BI 4.1

BW reporting: BEX Analyzer (3.x, 7.0, 7.3), Query Designer (3.x, 7.0, 7.3), WAD (3.x and 7.0) and SAP Portal.

ERP Packages: SAP SD, MM, PP, QM, PM FI/CO, HR and CRM and SRM modules

Operating Systems: Windows 7.0/Vista/XP,UNIX. Databases: Oracle 9.i/8.i.

ANNEXURE

Professional Projects

Title: Emerson Network Power

Location: Columbus Ohio

Period: Jun’10 - Aug’10

Tools Used: Oracle E-Business Suite R12 & Oracle UPK (User Productivity Kit).

Responsibilities:

Undertook close review of existing business functionality using Oracle E-Business Suite

Used UPK to record Business Process Flow documents to be used as reference for end users

Title: County of Los Angeles

Location: Los Angeles California

Period: Dec’10 - Mar’10

Tools Used: SAP Net Weaver 7.0, SAP ECC 6.0, Unix

Responsibilities:

Carried out user authorization and profile maintenance

Applied Kernel patches and support packages

Worked on Transport Management System Operation Modes

Undertook profile maintenance and mass user maintenance

Title: Collaboration with Third Party Communities for VOC Submissions

Period: Jun’09 - Jul‘09

Tools Used: JavaScript and ASP.NET

Project Scope: The aim of the project was to bridge the gap between Microsoft and its millions of users across India. The idea was to acquire useful feedback in form of bugs and fixes concerning products being used on third party websites. The project involved interaction with 500+ 3rd party site users / administrators for gathering information.

Academic Projects

Graduate

Title: Lean Operations

Scope: The project involved implementation of Lean Operations for a Hospitality business in Southern California involving identification of the value chain, process redesign, introduction of flow, pulling up of stable source of information, and optimizing operational performance.

Title: Best Practices New Product Development

Title: Strategic Management of Technology

Scope: Assessment of Hybrid Technology impact on Honda Automobile Engines and its consequences on vehicle performance & environment.

Undergraduate

Title: ADC Portal Project

Site: Reliance Infocom

Period: Jun’05 - May‘06

Scope: The project involved design of database for the ADC Portal Project thereby enabling automated billing settlement across Mobile Service providers. This involved utilization of ASP.net and Oracle database to achieve optimum results. This project helped in replacement of manual tracking to an automated version.

Contact this candidate