Data Sales
Resume:
Summary:
** ***** ** ** ********** in SAP Business Intelligence.
Proficient client interaction skills in understanding business requirements, designing technical solutions, building the solution and presenting to Client Leadership Team
Extensive experience in managing the quality assurance activities in software product companies, preparing functional test plans, unit test plans, unit & system test cases, executing test cases and certifying the software work product on various platforms.
Sound analytical and problem-solving skills and ability to learn new technologies quickly.
Excellent professional experience in Software Development Life Cycle that includes requirement gathering, design, project implementation, system test and implementation and production support.
Extensively worked in the functional business areas like Sales & Distribution (SD), Finance (FI), SAP CRM, Inventory Management (IM) and Material Management (MM)
Prepared training material for Business to improve their efficiency in running day to day transactions.
Experience in Retail, Manufacturing, Pharmaceutical, Utilities and Software industries
Experience in coordinating with business to document end to end test scenarios, map them to test cases or write new test cases for business testing.
TECHNICAL SKILLS
ERP Packages: ECC 6.0, SAP R/3 - 4.7 / 4.6C
Data Warehouse: SAP BW 7.4 BI 7.0, SAP BW 3.5
Reporting Tools: Bex Explorer, Bex Analyzer, SAP BO
Languages: ABAP/4, SQL
Office Tools: MS Excel, MS Word
Operating Systems: Windows 2000/XP/Vista/7
SAP BW 3.5, BI 7.0 and BW 7.4
Data Modeling
Strong understanding of dimensional modeling, data warehousing concepts and methodologies and leading full-lifecycle Business Intelligence and Data Warehousing projects.
Extensively worked on creation of InfoObjects, Hierarchies, InfoSources, Update Rules, Transfer Rules, Transformations, ODS/DSOs, InfoCubes, InfoSets, MultiProviders and Data Transfer Process (DTP).
Expertise in Creating, Scheduling and Monitoring Process Chains.
Worked on various ABAP routines that Includes at InfoPackage`s, DTP`s, Expert routine, field level, Start, End routine and Expert routines for transformations, Function modules, Exit variables, etc.
Datasource enhancement using FM, Enhancing the Standard extractors with ABAP
Experience in upgrading SAP BW 3.5 to BI 7.0/7.3.
Experience in the creation of the Virtual Infocube and write logic to extract based on the report selections.
Improved data load and query performance by using BI Accelerator (BIA), Compression, Aggregates, Indexes, optimizing Data packet size.
Experience in error stack analysis and cleanup.
Worked extensively with Transport Management using BW Transport
Data Extraction
Installed and configured the extractors, Data sources, info sources and info providers.
Experience in data extraction using LIS, FI, CO-PA, Generic extractor, flat file extraction.
Worked on all type of data source enhancements using the customer exits and function modules.
Reporting
Experienced with BW’s BEx Analyzer, WAD and Bex Query Designer.
Worked with all kind of BEx elements such as Conditions, Exceptions, Variables (User input, Replacement path, and Exit variables), Structures, Restricted and Calculated Key Figures, Aggregations, and Report to Report Interface
SAP Business Objects (SAP BO 3.1 and 4.0)
Experience in creating Universes with Measures, Dimension objects, Join conditions, Filters, LOV's, Cardinalities, Aliases, Contexts, Hierarchies, functions, Aggregate Awareness using SAP Business Objects Designer
Education:
Bachelor of Technology from JNTU (J.B .Institute of Engineering and Technology), India
Professional Experience
Name of the Company: Sparc Innovations Inc.
Project: Amtrak - Delaware, USA Sep 18 – Feb 21
Responsibilities:
Had taken the lead responsibility for the support project.
Was involved in monitoring load failures and Delta loads and responsible for Incident management, change requests and
monitoring the performance of the System
Broadcasting of daily sales report and promptly fixing the issues in case of any failures.
Interacting with client to gather the business requirements for change requests and converting them into
Technical specifications
Supported all kinds of reports like weekly, monthly and daily, End to End Inventory, Sales and the master data.
Coordinating and managing the activities with team
Involved in query optimization and performance tuning of data on BW.
Interacting with client to gather the business requirements for the change requests.
Understanding the Functional specifications of the change requests and converting them into Technical specifications
Broadcasting of daily sales report and promptly fixing the issues in case of any failures.
Coordinating and managing the activities with team
Involved in query optimization and performance tuning of data on BW.
Environment: SAP BW 7.4, SAP ECC 6.0, BEx Query Designer and BEx Analyzer
Name of the Company: Infosys Limited
Project 1: Daiichi Sankyo (Pharmaceutical) - New Jersey, USA Oct 15- Dec 16
SAP BW Consultant
Responsibilities:
Had taken the lead responsibility for the support project.
Was involved in monitoring load failures and Delta loads and responsible for Incident management, change requests and monitoring the performance of the
System
Involved in SAMPLE allocation management to the sales representatives based on the hierarchy which involved integrated planning.
Broadcasting of daily sales report and promptly fixing the issues in case of any failures.
Interacting with client to gather the business requirements for change requests and converting them into Technical specifications.
Supported all kinds of reports like weekly, monthly and daily, End to End Inventory, Sales and the master data.
Coordinating and managing the activities with Offshore team
Involved in query optimization and performance tuning of data on BW.
Remodeling of Infocube dimensions by checking the fact to dimension table.
ratio
Environment: SAP BW 7.3, SAP ECC 6.0, BEx Query Designer and BEx Analyzer
Project 2: SANDOZ (Pharmaceutical) - New Jersey, USA Jan 10-Sep 15
SAP BW Consultant
Responsibilities:
As a part of production support involved in monitoring load failures, Delta loads, Incident management, change requests and monitoring the performance of the system.
Managed and worked on Production incidents based on priority.
Worked almost on every kind of problem being faced during extraction and data loading and succeeded in providing the resolution for all the problems encountered.
Interacting with client to gather the business requirements for change requests and converting them into Technical specifications.
Supported the system with the concepts like weekly, monthly and daily, End to End Inventory, Sales and the master data.
Coordinating and managing the activities with offshore team.
Involved in query optimization and performance tuning of data on BW Performance improvement by implementing the Historization, Partitioning and Archiving of Infocubes
Remodeling of Infocube dimensions by checking the fact to dimension table ratio.
Identified the 3.x data sources and migrating to 7.0 data sources.
Environment: SAP BW 7.0, SAP ECC 6.0, BEx Query Designer and BEx Analyzer
Project 3: Adidas Group - Hyderabad, India Jan 09-Dec 09
SAP BW Consultant
Responsibilities:
Interacting with client to gather the business requirements for the change requests.
Understanding the Functional specifications of the change requests and converting them into Technical specifications
Extensively worked on SD Datasources in Logistics application area (2LIS_11_VAITM, 2LIS_12_VCITM, 2LIS_13_VDITM)
Worked extensively on the Error stack handling across the system.
Worked on the concepts like Retail Weekly Inventory snapshots, Monthly Inventory snapshots, Retail store Traffic count and the Daily inventory movements.
Extensively worked in designing and creation of the complex report on the top of Sales, Inventory, Traffic count and pricing data flows, developed Jump reports using RRI to call the detail reports.
Extensive usage of the constant selection in the reports for showing the different granularity levels of data in the same report.
Involved in Unit Testing of individual data flows and system integration testing of the complete data flows.
Historization concept for the performance improvement in the system
Execution of archiving solution for the DSOs and the cubes to client
Involved in effort estimations for change requests and enhancements.
Implemented RBO rollouts for 2 countries (China and Malaysia)
Development and Loading master data and transactional data from Flat file and RBO system to BW system.
Performed Unit testing and Integration testing on the developed objects by using other country reference.
Involved in the creation of new data flows, re-modeling and Process Chains.
Environment: SAP BW 7.3, SAP Retail and SAP POS DM, BEx Query Designer and BEx Analyzer
Project 4: Analog Devices Inc. (ADI) - Hyderabad, India May 08 – Jan 09
SAP BW Consultant
End-End Implementation Project
The Project involved an end-end implementation from Modeling to Reporting. It consisted of enhancements to the custom based extractors, development of generic extractors based on table/view/Function Module, modeling of info objects, DSO’s, info cubes, Multi cubes, and building reports based on different requirements.
Responsibilities:
Reviewing of the functional requirements document and designing and creation of technical document
Development of the data flow in the BW 3.5 and in SAP R/3
Extensively worked on creation of InfoObjects, Hierarchies, InfoSources, Update Rules, Transfer Rules, Transformations, ODS, InfoCubes, InfoSets and MultiProviders
Created process chains for periodic upload of master data, transactional data, and text data and scheduled and monitored the data loads with delta and full update mechanisms.
Developed BEx queries for reporting on Info Cubes, InfoSets, ODS and Multi Provider by defining Structures, Variables, Formulas, Exceptions, Selections, Navigational Attributes, Conditions providing drill down functionality in reporting.
Worked with all the types of data sources like Generic extraction and LO extraction.
Performing Unit testing and Integration testing.
Providing support for UAT, moving the transports to the production environment, giving Post implementation support as well as resolution of issues that occur in these phases.
Involved in creating process chains and scheduling the loads through process chains.
Unit testing and Integration testing of the data flows
Preparation of technical specifications, Unit test scripts and analysis documents
Improving query performance by creating aggregates, optimizing query definitions & properties
Tuning of all types of routines (start, expert, end, update routines) and exit variables.
Creation of secondary indexes in the DSO’s for the lookup statements in the routines
Implemented the Error stack analysis for the complete solution.
Environment: SAP R/3 4.7, BW 3.5, BEx Query Designer, and BEx Analyzer
Project 5: British Petroleum, Bangalore, India Sep 07- Mar 08
SAP BW Developer
End-End Implementation Project
Responsibilities:
Formal walkthrough and review of the technical document and development of the data flow in the BW 3.5 and in SAP R/3
Worked in Data Modeling of InfoCubes, ODS, MultiProviders, Info Objects, Update Rules, Transfer Rules, InfoPackages, and Infosources
Worked extensively on the ABAP part in the areas like Start routine, update routine and exit variables.
Created process chains to load master data and transactional data.
Created formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables, structures, RFK’s and CKF’s for developing complex custom reports.
Set up extraction using LO (LBWE) Execution Cockpit & V-3 updates
Extracted the data using extractor 2LIS_11_VAITM (Sales order Item Data) to data targets.
Have worked with creation of generic data source based on the SAP R/3 tables
Performing Unit testing, Integration testing, support for UAT and cutover activities
Involved in Go-live and hyper care of the project.
Environment: SAP R/3 4.7, BW 3.5, BEx Query Designer, and BEx Analyzer
Infosys Training (Jun’07 - Sep’07)
Tools: SAP BW 3.5
Description: Undergone initial training on different modules like RDBMS, Programming fundamentals, Analysis of Algorithms, Software Development Methods, Java, UNIX and Computer Hardware and System Software Concepts. After an initial training on SDLC fundamentals I was inducted into the SAP-BI practice at Infosys which covered BI fundamentals like data modeling, creation of BW objects, transformations in BW 3.5
ACHIEVEMENTS
Have received SPOT awards in for exceptional performance.
Have received ESTEEM Award for my first project British Petroleum.
Have been an active participant in SAP SDN forums and stood as Top 11th Global contributor in SDN forums. Also been Top 1 in the BEx Reporting Area
Have published a white paper in SDN related to Information Broadcasting.
Received multiple Client Appreciations.
Contact this candidate