SAN DISK Device Design India Ltd
Total years of experience :17 years, 6 Months
Incorporated LAT, NA, APAC & EMEA regions customer for POS design
•Architected the model in Revenue recognition for SANDISK
Leading the offshore team
•Involved in up gradation of FI Module for global integration of Avaya ERP
This is a new Implementation. Involved in Blue printing and Design of Data model.
•Lead the BI Team of 5 Members.
•Involved with BCS team in generating the Reports
As a BI Consultant responsible for remodeling, performance tuning and new developments for the various requirements in SD, FI, MM, PS & PP
•Installed all the standard content and developed the new Bex Reports for SD, MM & PP
•Worked extensively with BCS Team and developed many custom queries like Consolidation Report, Segment Report Etc
•Demonstrated the use of BO for the client.
PG & E
As a BI Consultant responsible for remodeling, performance tuning and new developments for the various requirements in Work Management, Sales & Distribution, Finance, Controlling and ongoing enhancements to existing modules
•Created function module extractor to extract data from COSB table as the business content extractor is not extracting service contract Information.
•Create and a design APD process to load transactional ODS.
•Utilized the Analysis Process Designer (APD) to populate summary cubes using complex queries on other cubes.
•Utilized the Analysis Process Designer (APD) to perform custom calculations of projected inventory levels.
•Doing various types of Performance improvements in both Data Loading and Query performance.
•Created Various Reports in FI GL like fixed-period statement about items not directly related to cash, plan version line items for aggregated or individual posting periods for one or more general ledger accounts.
•Build Custom Extractors for FI Asset Accounting and Tax minute based extractors because current Standard extractor are supporting only day based extraction.
•Participated in the complex development part of the allocation process and feature calculations.
•Involved in patch upgrades both in SAPBI and ECC system.
•Created various Cross Functional Repots for FI GL and Inventory.
•Using Bex broadcaster, distributed the customized reports by region and exported to the Enterprise portal.
•Created various reconciliation reports to reconcile the ECC, BI and Variances Data in the single report using remote and custom extractors.
•Worked as Queue manager to distribute the tickets among the team. Maintaining the Work History for all the tickets until it is closed down.
•Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
•Developed Function Module to convert Local Currency to Base currency.
•Created Various Virtual Characteristics and Key figures as per the reporting requirements
Bex Query Designer for Bonus Reports, Marketing Reports and Attrition & Opera Reports (For End Users) using variables calculated key figures and restricted key figures.
•Performance Tuning SAP BI system for faster execution by maintaining aggregates, Pre-Calculated Web Templates, OLAP & portal iview cache.
•Facilitated Go/No Go checkpoint meetings with team members and management.
•Liaise with Basis regarding performance/space/general running of the system
•Worked extensively on LO, CO-PA and Generic extraction.
•Involved in BW 3.5 to BI 7 upgrade processes.
•Responsible for design, development and extraction from R/3 Source system and flat files to BW for FI & CO.
•Used BO Data Integrator to extract data from various sources.
•Created various webi & full client reports.
Schwan’s Food
Working with business users to understand, analyze, and document their requirements, including reporting and other information needs.
•Carrying out SAP BW delta load, Info package creation, update rules, modifying communication structures, and day-to-day transport support.
•Defining quires using Bex Query Designer for Bonus Reports, Marketing Reports and Attrition & Opera Reports (For End Users) using variables calculated key figures and restricted key figures.
•Performance Tuning SAP BI system for faster execution by maintaining aggregates, Pre-Calculated Web Templates, OLAP & portal iview cache.
•Facilitated Go/No Go checkpoint meetings with team members and management.
•Liaise with Basis regarding performance/space/general running of the system.
•Training the power users on utilizing, developing, and administer BW Queries.
•Responsible for Delivery of around 12 reports in Productivity and COPA.
•Extensively worked on WEBI reports.
•Developed Crystal Reports from SAP BW (Business Warehouse) using BEx Query as the extraction tool
for User requirements gathering, Business Blueprint, Realization and Testing Phases
•Designed and developed complete metrics in BW for integration of a new plant in Europe, which went live in R/3.
•Uploaded Material Master Data, Vendor Master Data, Customer Master Data.
•Participate on teams and projects to understand business needs, design and recommend solutions, and provide support on the evolving BI environment.
•Interface to the business users to develop an understanding of the business processes and user requirements at a depth sufficient to recommend, architect and implement an appropriate BI solution to meet business needs and address the enterprise BI vision within the company.
•Worked extensively on LO, CO-PA and Generic extraction.
•Involved in BW 3.5 to BI 7 upgrade processes.
•Responsible for design, development and extraction from R/3 Source system and flat files to BW for FI & CO.
•Used BO Data Integrator to extract data from various sources.
•Created various webi & full client reports.
•Designed the universe.
•Integrated the webi reports with JBoss SOA application
Key person involved in the Phase II Reporting Strategy, Data model designs, Data mapping, Extraction logic, Report playbacks, Test Scripts and Performance Tuning
•Involved in the Restatement Process for the SD, TPM and FI.
•Involved in BW 3.5 to BI 7 up gradation processes.
•Responsible for designing interface for Material Master, Vendor Master and Customer Master to push data to MDM.
•Worked extensively on BI/BW Scorecards, Dashboards and Adhoc Reports using BEx, WAD, BEx Report Designer, BW Web API, JavaScript, iViews.
•Put together strategy for transports and documentation techniques.
•Developed Volume Ranking Report.
•Involved in designing and technical configuration on Federated Portal.
•Leveraged BI 7 features to improve report model and load performance
•Analysis of data requirements & translation of these requirements into dimensional data models using star schema and extended star schema data modeling techniques, with an emphasis on actual implementation in BW.
•Experience in providing Reporting, Security, Transport and Go-Live strategy.
•Created data objects for the reporting areas, which includes building all structures within BW that supports the reporting, such as Extractors, Generic Extractors, Logistics Cockpit, DataSources, Info sources, Transfer Rules, Update Rules, Info packages, Info package groups, Info objects, ODS, Info cubes, Queries, Variables, Calculated key figures, InfoSet Queries, Workbooks, Analyzer, Browser, ITS, 3rd party reporting tools (Business Objects, Crystal), Roles, Transports, etc.
•Experience in extracting data from SAP R/3 (SD, MM, PP, FICO, HR) new dimension products like CRM, SCM, SEM, & BW using different data extraction structures such as LIS, LO Cockpit, CO-PA, EC-CS and maintaining delta queues.
•Worked from Functional/Business specifications and developed BW Reports primarily using BEx. Integrated SAP BW queries into Web Reports and into SAP Portal.
•Experience in working with ETL tools such as Informatica PowerCenter 8.1, 7.2, and Business Object’s Data Integrator
•Good knowledge of master data processes, data standards and how they relate to the business, particularly in the areas of materials, sales, vendors and finance.
•Worked closely with the Enterprise Architecture team to ensure that data objects are delivered in accord with the enterprise data warehousing strategy and design.
•Performed testing and tuning activities, including strategies around aggregates, indexes, compression and partitions.
•Extended Standard Business Contents based on client requirements using UserExits.
•Documented Test Plans and complete Unit Testing of Developed Objects and Reports