OVERVIEW:

• More than 5 years in SAP BW/BI development and implementation and testing.
• Implemented 2 full life-cycle projects.
• Managed projects as a Senior BW/BI consultant.
• Expertise in implementation, preparation, blueprint, realization, final preparation and Go-Live using ASAP Methodology.
• Experienced in SAP BI 7.0 & BW 3.5 versions.
• Experienced in design of technical specifications, with functional interaction.
• Expertise in Administrative workbench, Data Modeling, OLTP data extraction, Report Creating and Writing with BEX Query Designer, BEX Analyzer and Browser, Process Chain, Performance Tuning, Data loading and Data Monitoring tools and techniques.
• Experience in writing test Plan, test strategy, test cases and different testing methodologies.
• Extensive experience from varied clients in the testing methodologies of SAP projects
• Expertise in Integration Testing, Functional Testing, Regression Testing, User Interface Testing, Product Testing, Installation Testing, Compatibility Testing, Performance (Load & Stress) Testing, Parallel Testing, non-E2E Testing, GUI Testing, User Acceptance Testing (UAT), Black Box, Transaction Testing, In-stream Testing, Cross-Stream Testing and Automated Testing.
• Rich experience on the application manual testing and as well as Application Automation Testing using Mercury.
• Strong PC/spreadsheet skills, excellent multi-tasking and organizational aptitudes, effective communicator and problem solver.
• Experienced in review & analysis of Business Requirements, Development, Functional Specifications, and Detailed Design of the Application as well as Formulation of Test Plan based on the Design Document and User Requirement Document.
• Proficient in automating QA processes using Mercury Quick Test Professional.
• Experienced with BI 7.0 Data Modeling, Data Acquisition, Transformations, Monitoring, Reporting, Data Distribution, Data Extraction and Data Warehouse Workbench.
• Strong in Performance Analysis and Tuning in Data Loading and Reporting for improving query response time using Statistics, Rollup, Partition, Indices, Aggregates, Compression, Partitioning and Statistics .
• Extensively worked with generic and Business content extractors including enhancement of the extractors using User Exits and troubleshooting data extraction issues.
• Experienced with the creation and maintenance of Info providers such as ODS, Info Cubes, Multi Providers, DSO, and Info Sets.
• Data loading scheduling and monitoring data loads with Full, Delta Init & Update and Full Repair Request.
• Experienced in data extraction from LO-Cockpit, HR, CO-PA, FI, Generic data sources and non-SAP Sources (FLATFILES, DB CONNECT).
• Experienced in scheduling and monitoring data loads and in designing process chains for Monthly/Weekly/Daily loads.
• Expertise in the technical capabilities of BI 7.0 (Transformations, DTPs etc.)
• Experience in Data modeling using Info Cube, Multi Provider, DSO, Transfer rules, Info Set, Data Sources, Expert Routines and Start Routines.
• Experience in Installation of Business Content Objects.
• Experience in construction of customized Info Objects, Info Cubes, and DSO objects.
• Sound Knowledge in SAP BW Integration Planning using Transactional Info cubes.
• Expertise to modify reports and write rule using ABAP.
• Knowledge of creating Process Chains for Automation of processand Better Performance.
• Enhanced Data Sources and Created Generic Data Sources as part of Extraction.
• Expertise in Analysis process Designer for BI.
• Worked extensively with BEX Query Designer, BEX Analyzer and Browser, Report Designer for developing reports, analysis, and Web reporting including Web Application Designer, Web Templates, and Dashboards.
• Excellent communication skills and takes active participation in knowledge distribution and guidance.
• Constantly learning and upgrading skills with the advances in the field and excellent team member.
  

Skills:

ERP Packages :

ECC 6.0 and SAP R/3,SAP FI/CO

Data Warehouse :

SAP BI 7.0 and SAP BW 3.5

Reporting and Testing Tools:

BEx Reporting(Analyzer, Query Designer), Web Reporting(WAD)and Crystal Reports, Portal, Mercury Quality Center, Quick Test Professional

Languages:

C, C++, Java, Visual Basic, SQL, PL/SQL.

Web Technologies:

HTML, JavaScript, XML.

Operating Systems:

Windows, Unix

Databases:

SQL Server, MS Access

Other Tools :

MS Project, MS Office, Mercury Testing Tools

WORK-EXPERIENCE:

Confidential, Glenview, IL July 2010- Present

Confidential, manufactures and markets packaged food products, including snacks, beverages, cheese, convenient meals and various packaged grocery products. The company is headquartered in Northfield, Illinois, a Chicago suburb. It sells the products to consumers in approximately 160 countries. The Company operates three segments: Confidential, North America, Confidential, Europe and Confidential, Developing Markets. Confidential, markets its products under various brand names, including Kraft, Oscar Mayer, Philadelphia, Maxwell House, Jacobs, Nabisco, Oreo, Milka, and LU.

Responsibilities:

• Serving as BW/BI Senior Tester for front end/back end and Report Designer.
• Majority of the work involves report designing for sales business processes integrating with COPA and testing SAP BI for SD (STC, OTC) module.
• Reported and analyzed data using SAP BW Business Explorer, defined queries, and delivered data from various sources in an organized fashion using BEx Query Designer.
• Created and maintained queries in BEx Query Designer and reports in portal.
• Involved in understanding the business process, studying the application and interacting with developers to create test cases and scripts using Mercury Quality Center.
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Tested company specific custom transaction codes and created sales order, billing documents using SD t-code such as VA01, VA02, VL01N, VL02N and VF01 for testing purpose.
• Tested back-end flow, info providers, open-hub data in SAP front-end tool.
• Tested user exits to support clients’ specific business process.
• Tested front-end portal reports with Multi provider.
• Involved in Unit testing, integration testing, regression testing and UAT testing.
• Reported bugs through Mercury Quality Center and interacted with developers to assist in resolving the issues.
• Conducted Defect Review meetings with analysts, users and developers to discuss defect reports.
• Handling onsite and offshore testing team.
• Developed Test Matrix to report testing status on a daily basis.
• Responsible for reporting the status to the project manager on weekly basis.
• Actively involved in daily triage meetings, weekly walkthrough meetings, to verify the status of the testing effort and the project as a whole.

Environments: SAP BW 7.0, SAP R/3 (COPA, SD), BEx (Analyzer, Query Designer), BI Portal, SAP BW Business Explorer.

Confidential,Emeryville, CA May 2008-May2010

Confidential, is a multinational pharmaceutical company based in Basel, Switzerland, ranking number three in sales among the world-wide industry Confidential, engages in the research, development, manufacture, and marketing of healthcare products worldwide. Its Pharmaceuticals division engages in the research, development, manufacture, distribution, and sale of pharmaceuticals in various therapeutic areas. The company’s Vaccines and Diagnostics division offers preventive vaccines and diagnostic tools. Its Sandoz division offers prescription medicines, as well as pharmaceutical and biotechnological active substances.

Responsibilities:

• Served as BW Consultant.
• Built DSO objects, Info cubes, Info sets and BEx reporting using SAP BW 7.0.
• Performed extraction, transformation, and loading of data (ETL) by preparing SAP R/3 for SAP BW and defining the loading strategies, initial and delta data loads using PSA (TRFCs), loading data via flat files and staging BAPI, and scheduling and monitoring data loads.
• Uploaded cost center data (CO-PA) into cost center for analyzing actual and plan data, replicated data sources, and made delta uploads using time stamp method.
• Translate the reporting requirements into a documented technical design for SAP BW
• Created Multi-provider and Info Sets and performed reporting on them.
• Performed day-to-day responsibilities including analysis of data requirements and translation of these requirements into dimensional data models, with an emphasis on actual implementation in BW.
• Developed a custom Info Cube as per design specifications in order to meet the business user requirements.
• Designed and optimized the queries (top customers, monthly incoming orders and revenues, product analysis, and returns) and analyzed the data using BEx Analyzer.
• Customized standard report templates to meet client requirements. Worked with Template Objects / Web Items (tables, charts, Role menu, Query view Selection, etc).
• Created web reports through report template in WAD (Web Application Designer).
• Loaded master data and transaction data into the warehouse via the DW workbench.
• Test the solution by loading data, verifying mapping, verifying data values, reconciliation to the source, proper aggregation of key figures, etc.
• Optimized the Integrated planning application in many ways like using workbooks for planning, save time on each layout, save the time on planning and enabled the back up process on a nightly basis to protect the planning data.
• Reported and analyzed data using SAP BW Business Explorer, defined queries, and delivered data from various sources in an organized fashion using BEx Browser.
• Created and maintained queries in BEx Analyzer and BEx Web Application Designer for analysis and web reporting respectively published in Enterprise Portal.

Environments: SAP BW 7.0, SAP R/3 (COPA), BEx (Analyzer, WAD), SAP BW Business Explorer.

Confidential,Shoreview, MN. Feb 2007-April 2008

Confidential, provides various personalized printed products, promotional products, and merchandising materials to small businesses and financial institutions in the United States, Canada, and Europe. The company operates in three segments: Small Business Services, Financial Services, and Direct Checks. Deluxe is based in Shoreview, Minnesota and has 33 facilities in the U.S. and 3 locations in Canada to conduct its printing and fulfillment, call center, and administrative functions.

Responsibilities:

• Served as SAP BW Consultant
• Responsible for Designing Business Intelligence solutions using SAP BI 7.0, to meet the Daily operational and analytical reporting demands of the business.
• Performed analysis, design, development and implementation of standard/ customized Info Cubes and ODS Objects for SD, MM, and FI/CO modules.
• Responsible for Designing the requirements, system development and Training.
• Responsible for Transportation of objects and suggested the Basis Team To apply the new patches in the system.
• Developed and modified reports using ABAP coding.
• Extract the data from Different Source systems (SAP R/3, MSSQL).
• Worked on FI-AR Accounts Receivable, FI-AP Accounts Payable, FI-AA Asset Accounting, CO-OM Overhead Cost Controlling, CO-OM-CCA Cost Center Accounting, Costs and Allocations.
• Migrated Data Sources (Master and Transaction) from 3.x version to BI 7.0 Version.
  Implemented the Macros in the workbooks, based on the Requirements.
• Architect workbook Hierarchies for Income Statements, Balance, Cash flows and other functionality.
  Implemented use of Aggregates; also investigated Info Cube physical segregation with ABAP Exits.
• Configuring of customized objects for better performance (NW 2004s).
• Developed ABAP routines in transformation rules/start-end routines NW 2004s (BI 7.0).
• Developed Function modules and user exits in Data modeling and also for reporting purposes NW 2004s.
• Schedule the batch job using Process Chains.
• Implemented the Planning Applications for Balance Sheet Planning, Cost Center Planning and Profit Planning.
• Created and maintained queries in BEx Analyzer and BEx Web Application Designer for analysis and web reporting respectively published in Enterprise Portal.
• Customized standard report templates to meet client requirements. Worked with Template Objects / Web Items (tables, charts, Role menu, Query view Selection, etc).
• Created web reports through report template in WAD (Web Application Designer).

Environment: SAP BI 7.0 (Net weaver 2004s), SAP ECC 6.0, Oracle 9i, MSSQL and AS/400.

Confidential, LA, CA Dec 2005 to Jan 2007

Confidential, is a global leader in packaging and packaging solutions. It provides packaging solutions to the healthcare, personal care and beauty, food, beverage, home and garden, tobacco, and commercial print industries worldwide. Confidential, was founded in 1888.

• Served as BW Consultant
• Work with IT Middleware and Data Architect resources to understand the source system (non SAP) and data.
• Built DSO objects, Info cubes, Info sets and BEx reporting using SAP BW.
• Performed extraction, transformation, and loading of data (ETL) by preparing SAP R/3 for SAP BW and defining the loading strategies, initial and delta data loads using IDocs and PSA (TRFCs), loading data via flat files and staging BAPI, and scheduling and monitoring data loads.
• Extract the data from Different Source systems.
• Worked on Off Cycle payroll, Simulation payroll and different types of payroll reports.
• Worked on different types of PA Actions like hiring, rehiring employees, Org Assignments, terminating employees and Intern/Contractors.
• Created Multi-provider and Info Sets and performed reporting on them.
• Performed day-to-day responsibilities including analysis of data requirements and translation of these requirements into dimensional data models, with an emphasis on actual implementation in BW.
• Developed a custom Info Cube as per design specifications in order to meet the business user requirements.
• Designed and optimized the queries (top customers, monthly incoming orders and revenues, product analysis, and returns) and analyzed the data using BEx Analyzer/ Browser.
• Developed prototypes on web reports using WAD.
• Wrote and modified different update/transfer rules, data lookups, transformations and manipulation through ABAP coding.
• Loaded master data and transaction data into the warehouse via the BW administrator workbench.
• Reported and analyzed data using SAP BW Business Explorer, defined queries, and delivered data from various sources in an organized fashion using BEx Browser.
• Worked extensively with Info type maintenance transaction codes PA 20, PA 30, PA 40.
• Used Transaction codes SM37 to view jobs and SE38 for individual jobs.
• Tested BN Info types 0171(general benefits), 0167(health Plan), 0168(Insurance Plan), 0169(Savings Plan), 0236(Credit Plans) and 0379(Stock Purchase Plans).
• Involved in SAP HR Master Data Maintenance including Employee details change, starting up new employee, termination, pay scale increment report

Environments: SAP BW, SAP R/3 HR, BEx (Analyzer, Browser), SAP BW Business Explorer.

Confidential, Punjab, India Jan2005-Sept 2005
Confidential, is an IT and HR Consultancy Company. It deals in SAP, Customize software development, Web development and HR Consultancy, delivering cross-industry and vertical solutions, global planning and deployment, customization and integration services, and Help Desk support to SAP B1 customers worldwide.

SAP Implementation

• Served as BW Consultant.
• Activated business content.
• Loaded master data and transaction data into the warehouse via the BW administrator workbench.
• Reported and analyzed data using SAP BW Business Explorer, defined queries, and delivered data from various sources in an organized fashion using BEx Browser. Created ten queries for financial reporting.

EDUCATION:

M.C.A (Masters of Computer Applications)
B.C.A (Bachelor of Computer Applications)