ASHWIN PUTCHA
acy2od@r.postjobfree.com
https://www.linkedin.com/in/ashwin-putcha-1a79584/
Over 13+ years of experience in designing, development, and E2E implementation of Information Technology Systems in SAP BW/BI/HANA and ECC it includes 5 E2E Implementations on SAP BI/BW and 2 E2E implementation on HANA and development. Hands on experience in leading all stages of system development efforts, including requirements definition, design, architecture, Testing and project based efforts while managing, motivating, and guiding team.
.
The following is a Skill Matrix and Summary of those contract and Positions.
SKILL MATRIX & SUMMARY
YEARS OF EXPERINCE AT GLANCE
EDW (Enterprise Data Warehouse’s)
PROJECT ROLES
ROLES
YRS
LEVEL
Information Modeling & information Processing
12+
Advanced
PROJECT STAGES/DELIVERABLES
STAGES
YRS
LEVEL
Realization & construction
5
Advanced
Deployment
5+
Advanced
Integration
5+
advanced
SPECIAL SKILLS
SKILLS
YRS
LEVEL
SAP BI/BW Architecture,ETL
12
Advanced
Bex Explore (BEX)-Queries, Excel & Web Reporting
12
Advanced
SAP BPS/SAP IP
2.0
Intermediate
SAP ABAP
9
Advanced
HTML,JAVA,C++,VBA,SQL
5
Advanced
MS Access
2
Advance
Windows -XP,2000,NT
2
Intermediate
SAP BOBJ
3 yrs
Intermediate
SAP HANA
2.5 yrs.
Intermediate
BI Analysis Tools:
Cognos,Qlikview,Tableau, Lumira
3yrs
Intermediate
SAP BPC
0.8
Intermediate
INDUSTRIES
SECTORS
YRS
LEVEL
Public Sector and Non-Profit Organization
5
Advanced
Pharmaceuticals
.6
Advanced
Manufacturing
4
advanced
Telecommunication
.4
Advanced
Oil Industry
.7
Advanced
Chemical
1.5
advanced
Auto Industry
1
Advanced
Highlights:
In Year 2014, Trained in Business Objects and HANA sponsored by Michigan State University
In Year 2016, Attend Project Management Training sponsored by Michigan State University.
In Year 2013, Trained in Cogno’s Reporting sponsored by Michigan State University.
In Year 2007, presented the proof of concept on Open Hub Service (2004s) & APD (Analysis and process designer) to IBM India PVT.LTD.
In Year 2006, Trained in BI-Delta Reporting & Enterprise Data Warehousing SAP Net Weaver 2004s BI 7.0, SAP BW (3.5), Advanced BW Reporting (3.5) and SAP BW Performance & Administration (3.5) conducted by SAP India and sponsored Videocon PVT.LTD.
From June 2004 to Jan 2006, Involved in various workshops conducted by ITC InfoTech, giving presentations on SAP BW to various clients for promotion, providing BW assistance in various pursuits made by ITC InfoTech and mentoring BW action learning consultants
Summary:
Experience in IT industry with over SEVEN years of SAP Business Warehousing/Business Objects and ABAP 4.x experience. Proficient with planning, design implementation, troubleshooting and performance tuning support of SAP Business Information Warehouse Reporting and BOBJ Reporting.
Worked on SAP HANA implementation projects with both Native HANA and SAP BW on HANA Landscapes based on HANA ASAP 8 Methodology
Good Knowledge on HANA Live Reporting
Strong experience in the integration of BODS with SAP modules and Non-SAP data sources.
Strong experience in using BODS as an external system for ETL between ECC and BI.
Working Knowledge in SAP BI 7.4 and knowledge of HANA modeling and data provisioning
Working Knowledge creating Attribute, Analytical and Calculation views using SAP HANA modeler
Good Knowledge on Hana Privileges.
Experience in Requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
BW Upgrade experience of Migrating Frontend solution such as Queries, Workbooks & Web reports, Unit of Measure migration with BI 7.0, successful implementation and Delivery.
Good Knowledge Transport cycle/projects for CHARM system
BI Design - Info Cubes design, Info Sources, Info Object maintenance, ODS Objects, Info sets, Hierarchies, Multi providers, Update rules, Transfer rules, Info Packages using AWB. Proficient in Data modeling using MDM and BW extended star schema models.
Primarily focused on Front end reporting (Work books, Web templates, Dashboards) on SAP BW along with its integration with SAP Portal, KM and third party tools like Business Objects and Crystal reports.
Experience in Integrating and Extracting data into Business Objects environment from the SAP BW database system. Created WEB Intelligence Reports, Formatting reports (BOBJ), as per user requirements.
Experience with HANA scripts while creating complex SQL views for custom based HANA applications including BO integration with SAP Native HANA.
Good Exposure in Fiori with employee user Experience.
Working Knowledge creating Attribute, Analytical and Calculation views using SAPHANA modeler.
Generates the BEx Reporting between actual data and planned data and facilitating the clients to analyze the Business scenario. Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.
Experience in Hierarchies, Authorizations, BW Statistics, Archiving, Process chains and Open hub.
BI Reporting - Experience in Design and Development of Queries, Reports, Workbooks, Business Explorer Analyzer, Query Builder, Info Set Query, Web Reporting, RRI, Reporting Agent and Broadcaster.
Activating delta extractors for funds management, working with delta queues and analyzing impact of delta process on R/3 transactions. Enhancement of standard BW extractors in the areas of Accounts Receivable, Accounts Payable) to get the fund information from BSEG.
Good working knowledge in LSA and LSA++
Good working Knowledge on HANA Live Reporting.
Performance tuning of Queries (SAP BW BEX and Cognos) by maintaining Aggregates, Compression, partition, indexing of info cubes and use of statistics for the same. Developed reports using different performance variables such as filter and prompts for better report functionality and quicker response time.
Strong experience in reporting with SAP BW info providers such as Info objects, Cubes, Queries. Expertise in reporting with Cognos 8 tools on different SAP R/3 functional areas combining data from different R/3 function modules (SD, FICO, MM) in BW.
Implemented SAP BW core business rules (Security (roles), Calculated Key figures, Restricted Key figures, Query variables) in Cognos tools. Integrated Cognos Reporting with BW functional areas for detailed reporting.
Configured Cognos Connection (portal) and performed Metadata modeling in Framework Manager. Created models and published packages with Framework Manager and combined data from SAP BW and Non SAP BW data sources for reporting. Exceptional ability to quickly master new concepts and technologies.
Working Knowledge in SAP BI 7.4 and knowledge of HANA modeling and data provisioning
Capable of working in a group as well as independently with excellent communication skills. Strong production support experience, good at trouble shooting with quick turnaround in fixing the issues.
Experience in Data-Provisioning techniques
BW Skills:
BEx Worked Extensively in BEx Analyzer in building Queries, saving it in Workbooks (Excel work Sheets). BW Expertise in SAP BW components like Info Cubes, Multi providers, Info Source, Info Objects, Update Rules and Transfer Rules, Which Includes Data Modeling.
Reporting Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, Conditions, RRI, and Jump queries.
Web Reporting Developed Web reports, Web items, customized Web templates using Web application designer (WAD) and query designer.
Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, partitioning.
Customizations - Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation, Direct and Flexible update of Master data.
Experience in the technical and functional system upgrade from BW 3.1C to BI 7.0 (NW2004s). Business Area: FI-CO, SD, MM, PP.
BI operations - Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Remote Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.
ABAP - Reporting, User Exits, Customer modifications. Proven success in performing all reporting features, OLTP Extraction from SAP R/3 into BW using different extraction structures. Functional expertise in SD, MM and FI/CO. In-depth knowledge of reporting flow from R/3 to SAP BW.
Production Support:
ABAP - Reporting, User Exits, Customer modifications. Specifications for Documented functional and technical production support and project enhancements.
Worked with the project team and multiple end-users to resolve accounting issues and identify opportunities for business process improvements. Provided production support in BW reporting.
Participated in identifying and implementing continuous business process improvements in planning, month-end closing, and consolidation. Documented functional and technical specifications for production support and project enhancements. Participated in change management activities.
Assisted in ongoing communication to SAP and BW end-users on business process and systems changes, and issues resolutions.
TECHNICAL SKILLS:
ERP: SAP R/3 ECC 5.0, 4.7/4.6c/4.5/4.0,EH6,EHP7
ETL Tools: SAP BW 7.4, Datastage.
Reporting Tool: BOBJ WEB Intelligence, Cognos 8.x/7.x, TM 1 (Impromptu, PowerPlay), Business Objects XI 3.1(Web Intelligence, Xcelsius) BEx Reporting, Web Reporting & BW 3.5/3.x/2.x,, Crystal Report 7.X/8.X.
Data Modeling Tool: HANA Studio.
SAP Modules: HR, SD, MM and FI/CO., APO, PP,
Operating System: Windows 7, 2000, NT, 98, XP, MS-DOS, Sun Solaris.
GUI: Visual Basic, Developer 2000, and SAP GUI.
Programming Language: SAP ABAP/4, JAVA and Visual Basic.
Databases: Oracle 9i/8i, SQL Server and MS-Access, Hana
Presentation Tools: MS-Office & MS-Project.
PROFESSIONAL EXPERIENCE:
SAP BW Consultant
Employer: Oscar-LLC.Com Aug’2016-Present
Client: Air Products.
Environment: SAP NWs 7.4 (SP 13), ABAP, HANA, FI-GL, MM, SCM, BPC, APO, Bex,BOBJ
Perform and document gap analysis. Prepare estimates for Global SAP and BW system Integration project
Understand design documentation including the high-level data model and understand the complexity and dependencies and plan the timelines for development based on the resource availability.
Designed, developed and implemented enterprise-level Business Intelligence solutions to address ongoing business strategies
Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool
Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
Responsible in providing leadership, guidance, and mentoring for a team of 3 Business Intelligence members
Work closely with businesses to understand issues and requests for enhancements
Good working Knowledge in HP Quality Center (HPQC)
Identify technical alternatives for addressing issues and meeting requirements identified
Design, Build, Test and Deploy components to resolve issues and address requirements identified
Liaison with R/3 process teams and other application teams to understand how data that is sourced from these systems is processed and what business rules have been applied so it can be effectively utilized to enhance reporting and analytical solutions and resolve issues
Work effectively with cross-functional teams within Global IT to ensure delivery of efficient solutions and to assist in problem identification and resolution
Monitor, analyze and resolve issues with BI solutions
Support and perform cutover activities and tasks (tasks related to implementation of development objects or project deliverables in multiple systems)
Copying Info provider data from HANA DB to MYSQL DB using DB connector
Used the standard BICS connection to connect to the BW server to access BW objects and BEx queries
Manage with Offshore Manila team to manage and coordinate Task
Conduct regression testing and take corrective actions as needed to ensure that existing BI solutions are not negatively impacted by changes in business rules and functionality
Lead weekly status meetings with the team to monitor progress.
Liaison to business and top management.
Estimate project resources, timelines and budget.
SAP BI Architect
Employer: Oscar-LLC.Com June’2010 – Aug’2016
Client: Michigan State University (Implementation and Upgrade)
Environment: SAP NWs 7.4 (SP 12), SAP NWs 7.0, Enterprise Portal, ABAP, SAP-HCM, PAYROLL, HANA
Worked with the users to get the requirements, performed gap analysis, created functional, architectural designs, reviewed Data Modeling designs with functional team
As a part of the NW 7.01 to NWs 7.4 SP12 upgrade team performed various Pre and Post upgrade activities supporting the basis teams as wells user groups
Use BW Administrator Work Bench (AWB) for configuration, process design, preparation of configuration and development specifications.
Involved in Collaborating with Client managers, DBA's, Reporting team, Business users and other Stake holders to understand SAP HANA, the existing landscape and identify key business use cases for the Proof of Concept POC
Replication of the selected tables of HR tables from ECC to SAP HANA. Performed transformations during the replication process.
Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool
Manage client expectation and status reporting.
Conducting data profiling to identify & analyze data quality issues.
Implemented BW-HR reporting for HR users. Created report for Headcount, Payroll and Benefits BEX Reporting.
Setting up procedure to extract R/3 data for HCM using Generic extraction, customize according to client request.
Involved in pre and post upgrade activities related to NW 7.4 including SPAU.
Monitor daily tickets and follow up with users regarding current status or close out incident tickets that were completed.
Implemented the BI 7.0 concepts of Transformations and DTPs using the existing datasource migration and involved in up gradation and migration from BW 3.5 to BW 7.0
Perform Data Integrity Check to verify the data in SAP R/3 and SAP BW.
Initiate extract process in B/W at regular intervals, change the Logical Business date so that the extracted data gets updated into B/W staging areas - ODS.
Responsible for connectivity between BI & ECC systems.
Solved problems encountered during the process using OSS notes.
Configure STMS for the newly installed SAP ECC6.0 Landscape.
Assist SAP Basis teams to troubleshoot issues and implementations.
Set and resolve authorization object level data and problems in various modules like HR.
Develop Process Chains to load HR Master Data and transaction data, schedule the process chains for daily, weekly and monthly loads.
Documented BW (backend and frontend) process flows into various folders on SharePoint utility drive.
Design Process Chains and UC4 jobs for data loads.
Responsible for data extraction from PY Cluster tables Payroll and Time Management (PCL2) using standard functional modules.
Resolve short dump error and message log errors with Basis team.
Analyze and correct production problems in the SAP BW system to provide high degree of customer service to end users and business units.
SAP BI/BW Report Developer (2010) Jan‘2010- June’2010
Employer: Ling Technologies, Manassas, VA
Client: Sara Lee (Implementation)
Environment: NW 2004s BI, Enterprise Portal, ABAP, Net weaver, PP, FICO, BEX, MM, SD
Activation of the Business Content for Plant Maintenance (PM), Purchasing (MM), customizing them as per the client requirement
Responsible for data-modeling, data extraction, generic extraction, data loading, scheduling, monitoring and reporting for the MM and PP modules.
Responsible for design, development and extraction from R/3 Source system and Flat File to BW for MM and PP modules and work with data flows.
Activated cubes sales overview and delivery service info cubes using data sources for Sales Orders, Deliveries and Billing Documents (Header, Item and Schedule Lines).
Design developed a Model for Consolidation and Design and developed a Driver Based Planning Model
Provided technical assistance and support to the client's users as well as the off shore team.
Performed structural and functional enhancements to data sources with necessary user-exits for master as well as transaction data in R3. Extracted data into BW from SAP R/3 and files.
Worked on the Vendor analytics of SAP SRM (EBP) to support the reports like E-Procurement Account Assignment, Bid Invitations and Bids, Procurement Process-Single Documents, Purchase Contracts - Single Documents and Shopping Carts - Single Document
Responsible for writing update routines and transfer routines by using ABAP.
Utilized delta update mechanisms for uploading the data to BW from R/3 in specific intervals.
Extended extract structures by adding new fields and populating them with the user/function exits.
Responsible for performance analysis, testing, and tuning. Developed aggregates and indexing strategies.
Deployed below list of reports along with other developments
New PO's/PR's in the last week/Month/Quarter
Aging PO's with No Activity
Current Open PO's
PO's with Remaining Balance
Offshore team Responsibilities:
Ensure deliverable are prepared to satisfy the project requirements, schedule.
Coordinate and track the reviews, documentation, test activities
Facilitate problem solving and collaboration
Establish meeting times, places and agendas, Ensure discussions and decisions lead to closure.
Lead SAP BI/BW with MDM Architect Oct‘2009- Jan ’2010
Employer: Ling Technologies, Manassas, VA
Client: Kraft Foods (Implementation)
Environment: NW 2004s BI, Enterprise Portal, ABAP, Net weaver, MDM, FI, CRM
MDM Responsibilities:
Built material repository and integration of MDM with BI data staging environment.
Responsible for building import and syndication maps and enhanced them.
Created new assignment and validation rules in compliance with business.
Tested and verified data with remote key maps and IDOCS.
Involved in regression and load testing, transportation form development server to production server and building rules, strategies and transformations for identification of duplicates.
Removed duplicate data in the data manager manually and used MDM workflow.
Syndicated data to an XML file using syndicator and logged defects in peer review defect log document.
BI Responsibilities:
Analyzed and configured Info Objects, Info Cubes, Info Sources and Source Systems within the Data Warehouse Workbench.
Created look ups for DSO to cube at Info Provider level.
Designed queries on multi providers and jump queries
Mean Time between Failures (MTBR)
Mean Time to Repair (MTTR)
Responsible for Unit Level Testing and regression testing, data consistency check in reports and bug fixes.
Extended extract structures by adding new fields and populating them with the user/function exits.
Handled data load errors and provided solutions by root cause analysis.
Created Data sources on CRM which includes Outbound Customer Contacts, CRM Marketing Element, Trade Promotion, and Target Groups – Business Partners.
Analyzed CRM Market Campaign Planner process as well as the related data in the CRM, ECC and legacy BW systems.
Lead SAP HCM BI Techno/Functional Consultant June’09- Oct’09
Employer: Ling Technologies, Manassas, VA
Client: Whirlpool (Development)
Environment: SAP BI Net weaver 2004S, ECC 6.0, FI, HCM, BW, BEX
Gathered data from functional consultants and responsible for data model in OLAP.
Created a data provider including cubes, multi-providers and pulled the date for the queries,
Responsible for extraction, transformation and loading and support job scheduling for reporting.
Resolved query performance issues using transactions such as RSRT and RSRTRACE.
Customized HR reports using variables such as user exit, and function modules for info types PA0000, PA0002, PA0003, PA0015, PA0021, PA0167 and PA0168.
Created roles, work sets, pages and assigned to users according to client requirement.
Developed process chains to load HR Master Data and transaction data and scheduled the process chains for daily, weekly and monthly loads.
Loaded master data and transactional data from ECC and flat files to BI.
Used aggregates, compression, and partitioning techniques to improve data load and query performance.
Involved Oracle DB2 and Create Custom tables through ABAP and pushed data into SAP BW.
Analyzed BI Data Load Schedules for HR Master Data and transaction data.
Activated and implemented various Business Content Master Data and Info Providers.
Extended business content data sources with client specific requirements and created required custom user exits for data extraction.
Created custom data source and required custom user exits for data extraction, info source and custom update routine for data transformation.
SAP BI Techno/Functional Consultant
Employer: I9 Technology April ‘2008- Nov’2008
Client: I9 Technology, NJ (Development)
Environment: SAP BI Netweaver 2004S, ECC 6.0, FI, EP, BW
Designed specifications and developed programs to meet business requirements.
Developed and scheduled Business Content data extraction from SAP R/3 source system and data load procedures.
Setup flat file extractions for legacy data, assigning DataSources to the InfoSource, defining Transfer Structure, and metadata maintenance for the InfoSource and source system.
Enhanced existing reports and creation of ad-hoc reports.
Worked extensively on administrative workbench in data modeling, scheduling and monitoring.
Developed InfoCubes, ODS, MultiProviders, InfoSources and InfoPackages.
Customized ODS, Info Cubes, Multi cubes and other BW objects based on the business requirements.
Utilized ODS to stage the data before transferring the ODS contents to the Info Cube.
Created drill through queries from summarized InfoCube to detail ODS data.
Developed front-end queries and reports using BEx Analyzer and BEx Browser.
Extensively used 0FIGL_C10 cube for ‘Profit Center Variance Analysis’ annual reporting.
Designed and developed process chains (RSPC) for master data loads and transaction data loads with the help of info packages.
Created process-chains to automate data loads, rollups into aggregates, creation and deletion of indexes to improve load performance.
Designed and developed SAP NW2004s in the areas of SAP Portal Administration and Visual Composer.
Created User Admin, Content Admin and System Admin.
Built aggregates to improve query performance.
Bhrigus Solutions, Hyderabad, India
SAP BI Techno/Functional Consultant Sept’2007 – March’2008
Client: Vivimed Pharma (Implementation)
Environment: SAP BI Netweaver 2004S, ECC 6.0, SD, MM, EP, HR
Created reports with Restricted Key Figures, Calculated Key Figures, Exceptions, Conditions, Variables and Filters.
Customized standard report templates to meet client requirements by working with template objects and web items including tables, charts, role menu and query view selection, etc...
Created web reports through report template in WAD (Web Application Designer).
Extended the extract structures by adding new fields and populating them with the user/function exits.
Transported installed objects to development system, testing and to production.
Created info packages, scheduled and monitored transaction data upload.
Worked extensively on info cubes, info sources, info objects, multi cubes and ODS objects.
Implemented LO structures for purchasing, inventory, filled setup tables for Init loads and scheduled V3 updates using cockpit after initialization of delta processes.
Developed Operational Data Store (ODS) to stage the data before transferring it to the info cubes.
Responsible for extraction, transformation and loading of R/3, legacy and flat file systems.
Wrote ABAP code during data process in start routines, transfer routines and in modifying reports in backend.
Vcentric Solution, Hyderabad, India
Team Lead SAP BW Techno/Functional Consultant May’2007- Sept’2007
Client: Aramco. (Development)
Environment: NetWeaver 2004 BW, Enterprise Portal, ABAP, SAP R/3, SD, MM, FI/CO, BPS
Involved in different phases of business blueprint. Analyzing the business process, interacting with end user, key persons identifying their reporting needs.
Worked in NetWeaver 2004s BI components which includes Upgradation, Data modeling,, Data acquisition, Data transfer process, Transformation, Data distribution, Data store objects(formerly ODS Objects), Process chain.
Created roles, work sets, pages and assigned to users according to client requirement.
Created SAP Business system connects to the back end.
Worked with performance tuning methods using Aggregates, compression, roll-up and Query performance.
Created different types of routines and user exits with the help of ABAP.
Generic Data Extraction for extracting Transactional and Master Data using views/tables.
Created jump queries to navigate directly from one query to another query.
Installing Business content as and when required.
Building of Process chains and scheduling of data loads for both delta and full uploads in preparation for go-live.
Checked for data consistency and modified the data in PSA before loading them to data target.
Created queries using Filters, Free characteristics, Restricted Key figures, conditions, exceptions and Variables.
Worked extensively in creating Transactional Info cubes for BPS Layouts.
Worked extensively in developing BPS Layouts includes creation of Planning Profile, Planning Area Planning Level, Planning packages and Planning Layouts.
Worked on Data slices maintenance in Planning Areas.
Worked on variables creation in Planning Areas.
Maintained Characteristics and Key Figures selection.
Maintained Layout Category (KF in Data or Lead Column)
Maintained Layout settings for Characteristics and key Figures.
Worked extensively on LO-Cockpit, CO-PA, FI-SL extractions.
Creation of Open Hub,such as Info spoke and created a destination for the Particular Data Target
IBM GLOBAL SERVICES, Hyderabad, India.
Senior SAP BI Techno/Functional Consultant Jan’2007- April’2007
Client: Ericsson (Development)
Environment: Netweaver 2004s BI 7.0, BW 3.5, ECC 6.0 HR, MM, PP, SD, FI/CO, Outlook
Analysis and development of objects as per client requirements.
Automated the data uploading through process chains.
Major responsibilities included Data loading/Monitoring/performance.
Optimization of major cubes with aggregates and compression.
Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not, after the data loads
Activated/rolled up Aggregates on most cubes and created new aggregates according to reporting needs.
Defined housekeeping jobs on regular periodicity
Created different types of routines and user exits with the help of ABAP.
Generic Data Extraction for extracting Transactional and Master Data using views/tables.
Created jump queries to navigate directly from one query to another query.
Installing Business content as and when required.
Involved in Business Content Activation, Enhancement of data sources and writing user exits (Master data and transaction data) on R/3 and BW.
Designed and developed process chains (RSPC) for master data loads and transaction data loads with the help of Info Packages. And these Process chains are scheduled for periodic loads
Videocon International Ltd, Aurangabad, Maharashtra.
SAP BI Manager. Feb’2006- Dec’2006
Client: Videocon and Thompson (Implementation)
Environment: BW 3.5, SD, MM, PP, BPS, PM
Performed Data Extraction and Data staging using, Lo Cockpit. Loaded the data from R/3 to BW and used Initialization with delta update and full update methods
Extensively worked Logistic Modules such as, Plant Maintenance, Material Management.
Extensively worked on PM datasource such as Maintenance Notifications - Items :(2LIS_17_I0ITEM), Maintenance orders: (2LIS_17_ORDER) and cubes 0PM_C03
The transaction Data is loaded from Different Source Systems using the Info Sources 2LiS_03_BF Material Movement, 2LiS_03_BX Material Stock, and uploading master data from business partners like Partner ID number, Master Records, Standard Address.
Compressed and Roll-Up the data in data targets
Involved with performance tuning of Queries by maintaining Aggregates, Compression and Indexing of InfoCubes
Creating new Roles, Work sets, iViews and Pages
And having good working knowledge on mySAP EP and worked with iviews, Pages, Worksets, Roles & Roles Assigning and Administration
Worked on Calculated and Restricted Key Figures, Filters, Structures, Exceptions and Conditions for the queries.
Worked on administration workbench, InfoSources, InfoCubes and ODS objects.
Checked for data consistency and modified the data in PSA before loading them to data target.
Created MultiCube for specific queries of MM. Incorporated transfer rules for Info Cubes and customized update rules using ABAP/4. Extended