SUMMARY OF EXPERIENCE

Tapashi is a certified SAP BI 7.0 Developer with 5 + years of experience in all phases of SAP Implementation such as Requirement gathering ,Analysis, Blue-printing, Realization, Technical Design, Development, documentation, Testing, Support & maintenance, training, Performance tuning.She is a strong experience with SAP SD, FI/CO, IS Utility, Retail POS and HCM Modules
Strong experience in extracting data from SAP and Non-SAP Systems
Certified in SAP HCM.
Well versed with ASAP methodology.
Good knowledge in info types , info groups in HCM
Has successfully completed multiple life cycle SAP BI implementations and was as a key member of several project teams through all phases of implementation of SAP BW in SD and HR modules.
Demonstrated expertise Extensive experience in Standard Business Content of Various business modules and Custom InfoCubes, InfoObjects and Web reporting, Extraction (LO Cockpit, Generic Extractions), Transfer Structures, BI Transformations, Infopackage, Multiproviders, Data transfer process, Data Store Objects (DSO).
Proficient in data design models- Star Schema and Extended Star Schema model.
Functional Modules – SD, FI,MM, CRM, & HR
Have created Flatfile.
Data Reconciliation – Developed Data Reconciliation process to find the deviation between R/3 and BW Data in various modules like Actual, Commitment and MM- Purchasing & POS.
BW Reporting - Strong Experience of BEx Query Designer, Calculated & Restricted Key Figures Conditions, Exceptions, Variables, Queries on Multi Providers, Web Application Designer (WAD) .
Experienced on testing.
Experienced on transportation.
Have worked on Process chain.
ABAP debugging
Appreciated for organizing training to share knowledge of core HRM and SAP HCM and SAP BI.
Appreciated for getting the business requirements from the client effectively.
Have worked on Bex Analyser.
Business Objects: Experience in building Universes and Creating Complex and Ad-Hoc Reports using Web Intelligent and Xcelsius.
Capable of working independently with minimum supervision as well as in a team.
Highly organized with proven skills to perform several tasks and assignments within the scheduled time. Dedicated and customer satisfaction oriented. A team player working effectively with group in accomplishing objectives. Have exemplary Communication and Presentation skills. Communicates effectively with all levels of management

TECHNICAL SKILLS:
ERP: SAP BI 7.0 ,(Certified) SAP HCM ECC 5.0(Certified), SAP CRM 5.0, ECC 5.0(SD,MM, FI/CO),SAP SRM,SAP BO,POS
Programming Languages: C++
OLAP Reporting tools: SAP Business Explorer (BEx) Analyzer, BEx Browser, Web reporting, SAP BO Operating Systems: Microsoft Windows 9X/ NT/2000/XP
Other Tools: MS-Office

RELEVANT ENGAGEMENTS AND PROJECTS:

Confidential,Ohio. USA.

Duration: 08/2011-Till date
Role: SAP BW Analyst

Scope: SAP HCM ECC 5.0, SAP BI 7.0

Project Description: Confidential, is a world largest Tire maker company. This is an End to End implementation of the SAP BWBI of the HR of Bridgestone-Firestone.

Contribution/Roles:

• Involved in multi-dimensional data modeling, developing Info Objects, Info Cubes, ODS objects, MultiProviders, and customizing standard Business Content.
• Extraction (ETL) of master data and transaction data from R/3.
• Involved in preparing the technical design document of DSO, info cube ,Transformation, Process chain, Report etc,
• Worked on customized reports according to Bridgestone specification
• Worked on Designing and scheduling of Process chain
• Involved in preparation of Test Pan.
• Worked on Unit test plan
• Working on Functional Test Plan, Integration Test plan, Performance test plan, and System Test plan.
• Working on writing test scripts.

Confidential,Accenture Bellevue. USA.

Duration: 01/2011-07/2011
Role: SAP BW Consultant

Scope: SAP IS Utility, SAP BI 7.0, Oracle, and SQL

Project Description: Washington State’s oldest local energy utility, Puget Sound Energy serves more than 1 million electric customers and 750,000 natural gas customers in 11 counties. A subsidiary of Puget Energy, PSE meets the energy needs of its customers. This is a End to End implementation of the trading operations of Puget Sound Energy system.

Contribution/Roles:

• Involved in gathering Business Requirements and preparation of Information Template used for identifying data elements for future reporting needs.
• 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.
• Involved in creating the Business Blueprint documentation
• Involved actively in preparing the dataflow design.
• Involved actively designing the Star schema, DSO.
• Have worked on Transformation, Start routine, End routine.
• Involved in preparing the technical documentation of the cube and DSO and the customised report.
• Involved in preparing the technical design document of DSO, infocube and Report.
• Worked on conditions, Exception, variables, calculated and restricted key figures, Offset in developing BEx reports.
• Independently design the model and technical document of process chain.
• Independently create the design Process chain and schedule as per the client requirements
• Creation of customized infocube, Infoobjects,DSO and Multiprovider
• Preparing the report layout according to client requirements
• Involved in building the customised report.
• Independently worked on testing, writing test scripts and test cases for all the BI objects.

Confidential,USA.

Duration: 11/2010-01/2011
Role: SAP BW Consultant

Scope: SAP-BI POS, FI/CO, SAP SD, MM, BO; Windows 2000 / XP, SAP-ECC 5.0

Accomplishments/ Results:

• Gather and assess business information needs and prepare system and reporting requirements.
• Review and validate data loaded extracted, loaded, and transformed into the data warehouse for accuracy.
• Weekly POS (Wal-Mart, Sams Club, lowe etc.) data validation.
• Loading data manually on business requirement.
• Troubleshoot business issues and bring potential options to realization.
• Installed and activated the SAP BW Standard InfoCubes, ODS, InfoSources, InfoObjects, BEx Reports and Web templates.
• Worked on resolving tickets and task.
• Regularly meet with the user for the task prioritasition.
• Provided expert solution on issues where customer faced problems.
• Loading flat file according to the request of the user.
• Developed infopackage & DTP for the data loads.
• Manually loaded data from source to target.
• Ensure to timely delivery of weekly and monthly report.
• To ensure team maintains timely movement of data into the data warehouse through management of data loads, resolving technical and timing difficulties as needed.
• Capture and analyze business needs and strategic information requirements
• Develop detailed analysis and design specifications with the Business Intelligence Application Developer and Data Architect
• Maintains support documentation for business users.
• Analyze and document business processes, business rules and metrics.
• Ensure to close the ticket within target period.

Confidential,
Duration: 08/2009 -04/2010
Role: SAP BI Consultant

Scope: SAP-BI ; FI/CO,SAP SD,COPA BO; O/s: Windows 2000 / XP, SAP-ECC 5.0

Project Description: Confidential,is the global group of energy and petrochemicals companies with around 102,000 employees in more than 100 countries and territories. The project is to support BI reports for and FI & SD module.

Accomplishments/ Results:
.

• Worked on variables, calculated and restricted key figures in developing BEx reports.
• Used ODS to stage data before transferring the ODS contents to the INFOCUBE.
• Involved with performance tuning of Queries by maintaining Aggregates, Compression, partition.
• Involved in escalating high-prioritized tickets regarding extractions, Performance Issues and also load failures.
• Maintaining Work History for all the tickets until it is closed down.
• Have share knowledge on SAP BW to the team member.
• Process chain monitoring
• Extensively worked on testing, writing test scripts and test cases
• Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the data load.
• Involved in performance tuning
• Created BEx (Business Explorer) and Web (WAD) reports with exceptions, conditions, restricted and calculated key figures in SAP BW
• Worked extensively on standard and custom defined LO extractors. Used LO extract structures and data sources in Sales to facilitate the data extraction
• Developed numerous queries based on calendar day week, month and year in order to obtain any combination of reports from the info cubes
• Modified several reports with exceptions and conditions based on customer requirements
• Executed periodic Reconciliation between SAP BW and R/3.
• Running the financial report on RSRT and Bex Analyzer.
• Worked with the FI datasource like 0FI_AA_11 and 0FI_AA_12
• Reloaded data from source to target as per the dataflow which include selective Deletion/Loading/Activation of DSO, full repair load, IC, reinitialisaton of IP, Reconstruction of MD if required & Deletion of active table etc.
• Developed infopackage for the data loads.
• Provided expert solution on issues where customer faced problems.

Confidential,INDIA

Duration: 11/2008 -08/2009

Role: SAP BI Consultant

Scope: SAP-BI/BO; SAP SD, Windows 2000 / XP

Accomplishments/ Results:

• Involved in gathering Business Requirements and preparation of Information Template used for identifying data elements for future reporting needs.
• Experienced on Gap analysis.
• 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
• Involved in creating the Business Blueprint documentation
• Activated available Business Content for the Sales Module. Created/modified InfoObjects, ODS, Infocubes, Transformations.
• Appreciated for organizing training to share knowledge of core HRM and SAP HCM and SAP BI
• Played an active role in designing data flow model.
• Creation of customized infocube, DSO and Multiprovider
• Involved in making the report layouts for the queries given by the client.
• Have created customized query in query designer and installed standard query.
• Worked on BEx Reporting which includes creating queries, use Conditions, exceptions, variables, calculated key figures, and restricted key figures.
• Worked on designing the Universe in BO.
• Extensively worked on Web Intelligent for importing the different BI Reports in SD Modules.
• Worked exclusively on Xcelsius for interactive Dashboards for analysis of Quarterly and Yearly sales.

Confidential,
Duration: 11/2007 -09/2008
Role: SAP BI Consultant
Scope: SAP-BI/BO; SAP SD,SAP HCM, Windows 2000 / XP

Project overview: Confidential, is the global leader in flash memory cards, from research, manufacturing and product design to consumer branding and retail distribution. Implemented SAP BI Solution. This is a Global Roll-Out Implementation Project. Implemented project in Europe and USA.

Accomplishments/ Results

• Interacted with the project managers & leads of the functional teams from client side to understand their requirements.
• Interacted with client team member for the development of business blue print specifications.
• Coordinated with team members for distribution and understanding of developments
• Provide knowledge transfer on Business Object solutions including Rapid Mart Solution to rapid implementation BI from other Legacy systems.
• Extracted data(Employee Payroll & Time) into BW from HR Module
• Worked extensively to map HR (PA and PD) data on legacy system to current BW system with emphasis on processing employee master data.
• Installed and modified HR Business Content InfoCube Headcount and Personnel Actions (0PA_C01) and created MultiProvider to extract employee data (Identification, Organizational Unit, Business Area, Personal Area) and monthly utility consumption from Excel files to analyze the consumption pattern and raise alerts to the management.
• Scheduling BW jobs, monitoring these Schedules on Process Chains and BW monitor
• Designed and developed Basic cubes, ODS.
• Worked with mapping the source data (R3/non R3) to target data source in BW.
• Worked extensively on administration workbench. Analyzed InfoCubes created and maintained aggregates to improve the performance.
• Worked on testing
• Designed and Developed several reports in BEx analyzer and Query Designer.
• Created Conditions, Exceptions, Structures and Variables that are used in BEx Reporting.
• Development of Dashboards using Crystal Xcelsius

Confidential,INDIA
Duration: 04/2006 – 10/2007
Role: SAP Consultant

Scope: SAP-BW. SD,HCM, SAP-ECC 5.0

Project Overview: The overall objective of this project is to assist Palsons Drugs in the design, build, and deployment of an SAP solution that will improve its business processes and support future growth

Accomplishments/ Results:

• Involved in configuring Personnel action.
• Defined employee group and subgroup.
• Set the integration between PA and OM.
• Defined pay scale types and areas for each personal area. Defined pay scales, levels and standard pay increase.
• Whorked in requirement gathering and Gap analysis.
• Stored data from R/3 tables into ODS objects through PSA to perform detailed level reporting.
• Actively involved in requirement gathering
• Involved in multi-dimensional data modeling, developing InfoObjects, InfoCubes, Aggregates, ODS objects, Datasource (OLTP Source) MultiProviders, and customizing standard Business Content.
• Extraction (ETL) of master data and transaction data from R/3.

EDUCATION:
Master of Business Administration
Bachelor of Arts, Economics