OVERVIEW

• Over 5 years in SAP BW/BI development and implementation.
• Implemented 2 full life-cycle projects.
• Managed projects as a 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.
• 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:

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

Data Warehouse:

SAP BI 7.0 and SAP BW 3.5

Reporting Tools:

BEx Reporting, Web Reporting and Crystal Reports.

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,Emeryville, CA May 2008-March3010

• 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 IDocs and 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.
• 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.
• 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.
• 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, Browser, WAD), SAP BW Business Explorer.

Confidential,Shoreview, MN. Feb 2007-April 2008

• 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 the 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

• 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 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 using 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 Jan2004-Sept 2005
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)