Post Job Free

Resume

Sign in

Data Sap

Location:
Braintree, MA
Posted:
January 19, 2016

Contact this candidate

Resume:

Jagannath

SAP BI, BW

996-***-****

acs53n@r.postjobfree.com

Consulting Skills

Over 4+years of IT experience in Implementation, Upgrade, Maintenance and Support in SAP BI/BW. Extensive experience in SAP BW - Data Modeling, Report development and expertise in Performance tuning.

Experience on SAP Business Objects Reporting XI R3 CMC, Designer, Info view, Web-IntelligenceXI & ABAP.

Experience in creating Universe and WEBI Reports, worked on Crystal Reports.

Worked extensively on BEX Analyzer and created various Queries and workbooks

Generated reports on Info Providers and Multi providers using Structures, Restricted Key Figures, Calculated Key Figures, Cell editors, Characteristic Variables, Text Variables, Formula Variables, Exceptions, and Conditions.

Design and development of Standard and Custom Info Cubes, Info Object and Info Sources, Extraction, Transfer Structures, Multi-Providers, Process Chains, Operational Data Store (ODS), Open hub service, User Exists and Business Explorer (BEx).

Understanding of standard SAP modules (SD, MM,PP, QM, FI,CRM)

Expertise in Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, Data Mart and Open Hub Service and BW Transports.

Expertise in creating and maintaining Process Chains and Meta Chains for automating data loads.

Generated reports on InfoProviders and Multiproviders using Structures, Restricted Key Figures, Calculated Key Figures, Cell editors, Characteristic Variables, Text Variables, Formula Variables, Exceptions, and Conditions.

Experience in Automation of master data and transactional data loads, Managing and maintaining R/3 Master Data, Performance and tuning on query level, back end level and on Data target level.

Worked on Designing the Web Reports and published in Web Portals

Handling of the production support tickets and resolving them as per the ticket priority and transporting them into Quality and Production environments.

Ability to work as a part of team, independently and quality conscience.

Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

ABAP programming: to write various routines, debug production support issues which are letter case, string loadings etc.,user exits, to send complicated errors to abap team.

EDUCATIONAL QUALIFICATION:

B.Sc from Sri Venkateswara University.

PGDCA from sharptech .

COA from global infotech.

TECHINICAL SKILLS:

ERP Packages : SAP R/3 Ecc 6.0

Data Ware Housing : SAP BI 7.3, 7.0

Reporting tools : Bex, WAD, BO

Database tool : SQL*PLUS, TOAD

Database : ORACLE 10g, 9i, 8.0

Programming language: ABAP/4, PL/SQL, COBOL, LOTUS 1-2-3

Range of experience:

Presently working in Wipro, Bangalore from June, 2013 to till date.

Previously worked in Wipro, Bangalore from Nov, 2011 to May, 2013.

Previously worked in Aditya Birla minacs from June, 2010 –Sept, 2011.

Previously i have an experiance of Telecom, finance & insurance domains.

Client Engagements

Nike,Wipro

Sr. SAP BW/BI CONSULTANT 06/13– till date

Nike is the leading American Company that is engaged in the design, development, manufacturing and worldwide marketing and selling of footwear, apparel, equipment, accessories and services. The company maintains a profit margin several times higher than competitor designer brands. Here the SAP BW has played a vital role to assist the Company's to analyze the Complete Business growth.

Contribution

Full life cycle implementation, which involve design, development, extraction and reporting of the data from R/3 system and flat files in to BW system using LO Cockpit Extraction methods for SD & MM modules.

Analyzed Info Cubes and DSO to meet the reporting needs of the client.

Observing all periodic schedules like daily/weekly and monthly is successful.

Analyze the errors occurred while uploading the data if the request fails and make the latest data available in data target.

Modeling

Data modeling techniques like Transformations, DTP’S, Data migration, DSO and structuring the info cubes as per the requirements.

Activation of SAP Business Content for LO Data like SD & MM Info Cubes and Data Sources for Master and Transactional data.

Created Multiprovider such as Demand cube, Supply Cube and Inventory Cube.

ETL:

Setup Tables for the LO Cockpit extraction.

Used T.code 0LI7BW to create setup tables based on the document range for the LO-Cockpit extraction.

Performed V3 update using LBWE to get the data from the outbound queue of the R/3 system to the delta queue of the BI system.

Extracted data from MM inventory (2LIS_03_BF data sources) modules and validated

Extracted data from 0FI_AP_4 and 0FI_AR_4 for money transactions.

Process Chains for periodic upload of the master data as well as the transactional data are created.

Formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures are created for developing complex custom reports.

Reporting:

Integrating SAP Business Objects with SAP BI data sources.

Responsible for Designing and developing new Universes over existing SAP BW systems

Business Object Universe, Business Objects Reports and Business Objects repository has been extensively used.

Created and designed documents (technical and functional) for BEx Queries, Universe, Webi Business Objects functionality like slice and dice, drill down, cross tab, master detail tables and formulas are used in the reporting.

Responsible for designing new BEx queries and also performed modifications to existing queries using BEx Query Designer as part of query analysis and performance tuning.

Responsible for Universe Design with SAP BW Data Sources and BEx Queries.

Universes and webi queries are developed for various functional areas of high level reports group.

Customized LOVs in Universes for quicker performance of reports.

Joins, Contexts, and Aliases are written for resolving Loops and Universe Tuning and checked the Integrity of the Universes.

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

Reports like “confirmed quantity”, “item purchase orders”,” quantities delivered” and” purchase order values “are created up on clients request.

Changed the universe parameter settings to optimize the performance of universe.

According to the customer information created complex report using Universe as main data provider.

Developed reports on the MM cubes to check the price variance for materials from different vendors.

Conducted Testing - Unit, and participated in Functional, Integration, and User Acceptance.

Reports developed on SD cubes for displaying sales figures and incoming orders

Exported the universes to the Repository making resources available to the users.

Linked the Universes to share the common components between the universes.

Mass Mutual Insurance, Wipro

SAPBW/BI Consultant 10/11 – 05/13

Mass Mutual Financial Group is a global, growth-oriented diversified financial services organization offers a broad-based portfolio of financial products and services, including mutual funds, money management, life insurance, annuities, disability income insurance and long-term care insurance. Scope of project was to build Data Mart for claims division, which would meet reporting requirements of all business functions within scope of operations.

Contribution

Involved in the development of the user requirements, testing, initial phase of production and thereby possessed a good understanding of complete life cycle implementation.

Involved in upgrading the BW 3.5 to BI 7.0.

Performed detailed analysis to improve the Performance of Cubes using compression, Aggregates and Involved in Production Support.

Implemented SAP BI 7.0 for SD & MM modules and expert in designing data flow from R/3 to BI system.

Modeling

Designing and Development of the Business Information Warehouse and enhancing the Business Content Info Cubes and R/3 extractors using ABAP/4.

Identifying the customer needs, modeling the data and defining the Data Sources at OLTP for the SD & MM module.

Activated Business Content for standard SD, MM Info Cubes, Info Sources and Info Objects and enhanced standard Business Content based on client requirements for Transaction, master and texts data

Expert in Data modeling techniques like Transformations, DTP’S, Data migration, DSO and structuring the info cubes as per the requirements.

Analyzed the PP info cube and DSO objects to meet the reporting needs of the end user.

ETL

Extensively involved in performance tuning of the info cubes by using Aggregates, Indexes, Partitions and Compression techniques.

Worked extensively on standard and custom defined LO extractors. Used LO extract structures and data sources in sales material management to facilitate the data extraction to BW/BI system.

Extracted data from SD and MM modules of SAP R/3 and from flat files into SAP BI System.

Used multiple layers of DSO to stage the data before transferring the DSO contents to the Info Cube.

Transported the objects from Development to QA for testing.

Wrote Business Logic at transformation levels in BW and worked on Data Cleansing, Data Mapping, Data Formatting and Data Conversions.

Used both initializations with Delta Update and Full Update methods depending on the business requirement.

Generated and maintained aggregates and rollup activities on SD Info cubes as part of the Info Cube Management.

Created and monitored various Process Chains, Managed and monitored data loads, job scheduling regularly and rebuilding missing indexes for increasing the Query Response.

Reporting

Report development on manufacturing modules on MM.

Used RRI (Report-Report Interface) in order to get detailed information about Sales orders.

Wrote reports in SD Open sales Order report, which covers all organization levels, delivery status, shipping figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.

Reports like Confined Quantity and Item Purchase orders, Purchase Order quantities delivered, Purchase order Values are created.

Created Conditions, Exceptions, Structures, and Variables to use them in BEx Reporting.

Extensively involved in the Performance Tuning of Info Cubes and Query reporting.

Modified existing queries on various Info Cubes related to SD and HR-Payroll.

Extensively worked on Query building, filtering, free Characteristics, Restricted Key Figures and variables, Query variants using BEx Analyzer.

Designed Universes and classes by Business Objects XI 3.1 enterprise tool and build all the objects required for WebI reporting which performed selecting, joining tables, cross tab, ranking, and alerter functions.

Reviewed all SAP MM reports and carried out modifications as per Clients requirements.

Designed and deploy ad-hoc reporting functionality using WebI.

Idea, Aditya Birla Minacs

Associate Consultant. 06/2010– 09/11

Idea cellular is one of the largest Mumbai based network of customer touch points. It provides 2G, 3G services and smart phones etc.

Contribution

Involved in the development of the user requirements, testing, initial phase of production and thereby possessed a good understanding of complete life cycle implementation Analyzed and translated the client’s business requirements and functional specifications into technical specifications, data flow diagrams and data models.

Co operated with the Client’s process teams in identifying and documenting necessary KPI and reporting requirements to build a reporting architecture.

Modeling

Building and enhancing BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set and Open Hub.

Data Source Objects are created for staging for multi providers and Info sets are created to satisfy reporting requirements.

ABAP programs are used to populate user exit variables.

ETL

Standard extractor and generic extractors are designed to meet the reporting requirement of defining relationship between demand and supply.

Start routines, end routines are used to cleanse the data before updating into Info Cubes.

Schedule, performance and monitor periodic data loads from SAP R/3 to BW, delta loading and DSO Loading process.

Automatic deletion of requests Info Packages and dynamic selection criteria, Help design system landscape.

Creating and moving Transports from Development to QA

Maintained Process Chains to automate and schedule the data loads.

Reporting

Integrated BO with SAP ECC and SAP BI 7.0 to build Universes.

Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.

Developed Business Objects Universes with classes, objects and condition objects.

Hierarchies are implemented to support drill down reports.

Worked on creating HR reports on Headcount, No of Personal actions and Change in Staffing Level.

Contexts and Aliases are created to resolve chasm and fan traps in Universes.

Joins strategies are created while designing the universes.

Customized queries using navigational attributes and filters in BEx analyzer and used customer exits as per client requirements.

Using complex queries reports are created where universe is the main data provider for reporting

Using Left outer join and inner join, Info sets are created and used for reporting.

Several complexes-cross tab reports and sub-reports are published using Crystal Reports and Business Objects Reporter.

Designing, reporting templates with BEx Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition.

Expertise in using entire Business Objects XI application suite and Involved in design, development, testing and implementation of Webi.

Cross tab and Drill down options are enabled using

Enabled/Disabled different servers in Central Configuration Manager and Central Management Console.

Webi Reports have been created deployed through Info View.

Trouble shooting and tuning of the reports.

Assisted end users writing reports and performing Ad hoc Queries.



Contact this candidate