Professional Summary

• SAP Certified Application Associate – Business Intelligence with SAP Netweaver 7.0
  • with more than 10 years of professional IT experience in which 7 plus years experience in SAP BW/BI area.
• Worked on Update rules (BW 3.x), Transfer rules(BW 3.x), Transformations (BI 7.0), Info Object creation and maintenance, ODS (DSO), Info Cubes.
• Extensively used BEx for building Queries.
• Worked on front-end Business Warehouse Components like BEx Analyzer, Query Designer, and Jump Analysis using RRI etc.
• Building custom queries using Variables, Conditions and Exceptions, Restricted and Calculated Keys.
• Extracted data from SAP and non- SAP Source Systems and modeled several Process Chains.
• Involved in three full implementations of BW, which includes Requirement gathering, Data modeling, Data extraction and Reporting.
• Experience in activating standard Business Content, extending and enhancing according to the end-user requirements.
• Worked on LO Cockpit.
• Performed Data Extraction from SAP ECC using extraction structures such as in LO Cockpit, FI and Generic Data Extractions.
• Possess strong technical foundation and the ability to work in a collaborative atmosphere with end-users and members of the development team and Conducted training for end-users and colleagues.
• Good experience working with APD’s.
• BW required knowledge on ABAP coding.
• Good experience creating customer exits on BEx variables.
• Creating query variants in RSRT Transaction code.
• Worked with BW Accelerator (RSDDV), version – SAP Netweaver BI 7.0. Operating System HP-UX.
• Experience in handling navigational attributes.
• Monitored and Supported process chains in production.
• Experience in Remodeling Info Cube and transporting to production system.
• Experience in handling tickets, workflow of tickets and ticket reports in Remedy IT Service Management Suite.
• Experience in monitoring Redwood (Job Scheduling Software & Business Process Automation) jobs.
• Experiencein SAP BO 4.0 WebI report creation.
• Experience in developing BO Universe.
• Experience in scheduling BO reports based on events.
• Experiencein SAP BO Dashboard creation.

Education
Bachelor in Engineering (Industrial Engineering) 
Confidential
SAP Certified Application Associate – Business Intelligence with SAP Netweaver 7.0
Certified Microsoft Professional 

Technical Skills

Business Warehousing: SAP BW 7.0, 3.5, BO 3.1/ 4.0, SAP POSDM

ERP: SAP ECC 6.0, SAP R/3 4.7

BI Reporting: BEx Analyzer, Query Designer, Web Application Designer, WebI, Xcelsius 2008, Dashboard 4.0

Operating System: Windows NT/2000/XP

Programming Languages: ABAP/4, Java, JSP, C#

Databases: SQL Server 2000/2005

Professional Experience

Confidential| NYJan ‘11 – Present
SAP BW Consultant

Confidential is an American group of specialty apparelretailchain stores for women, headquartered in New York City, (7 Times Square Tower, New York, NY 10036). The brand is marketed under four divisions, Ann Taylor, LOFT, Ann Taylor Factory and LOFT Outlet.
Responsibilities

• Developed various Multiproviders for reporting needs.
• Developed several infocubes for various purposes.
• Created info packages and loaded data into infoproviders for both 3.5 and 7.0 versions.
• Involved in the Modeling and development of various BEx reports as per specifications.
• Created DSO’s and loaded data in both 3.5 and 7.0 versions.
• Designed and developed APD’s to move data from Query to DSO.
• Created split APD’s based on query variants to handle large volumes of data.
• Created local process chains to add the split APD variants and finally added the local chains in metachain.
• Moved data from BW to PI using APD’s and custom ABAP code.
• Developed several WebI reports based on different BEx queries.
• Developed Dashboard based on BEx query.
• Hands on experience in scheduling BO reports based on events (Event Based Scheduling).
• Worked closely with Redwood team to automate BW processes.
• Developed ABAP code to notify redwood to trigger process chain.
• Hands on experience in creating alert file manually and programmatically to notify BOBJ scheduler of data load completion.
• Worked closely with SAP Basis team to move data from FTP site to Application server and vice versa based on business requirements.
• Worked with cumulative and non-cumulative key figures in BEx applications.
• Created several user exit variables for various BEx query needs.
• Created several query variants in RSRT Tcode.
• Transported various objects from development server to QA and Production servers.
• Interacted with the management and business end-users to identify business requirements
• Managed and monitored data loads in production.
• Worked with BW Accelerator (RSDDV), version – SAP Netweaver BI 7.0. Operating System HP-UX.
• Experience working in POSDM interface.

Environment: SAP BI 7.0, SAP BW 3.5, SAP ECC 6, BEx Query Designer, BEx Analyzer, BO 4.0, SAP Retail, POSDM.

Confidential| CA Apr ‘09 – Nov ‘10
SAP BW Consultant

Confidential., headquartered in San Diego, Calif., is the largest component of Sony Corporation of America, the U.S. holding company for Sony\'s U.S.-based electronics and entertainment businesses.
Responsibilities

• Involved in various Reports Development.
• Created Infopackages to load the data from DSO to InfoCube.
• Involved in the Modeling of various reports as per the specifications.
• Created InfoCube, Transformation and DTP to load Data from DSO.
• Designed and Created FI and SD related reports using Query Designer.
• Used the Process type Deleting Request from PSA in the Process Chains to delete the Data in PSA Periodically.
• Interacted with the management and business end-users to identify business requirements
• Activated the business content according to the functional requirements
• Extensively involved in data extraction from SAP ECC source system.
• Managed and monitored several data loads.
• Performance tuning of queries using aggregates on Info cubes.
• Designed and developed APD’s to move data from one source to another.
• Extensively used BEx Query Designer, created queries with variables and filters.
• Created several WebI reports based on Universes.
• Created dashboard using Xcelsius 2008.

Environment: SAP BI 7.0, SAP ECC 6, BEx Query Designer, BEx Analyzer, SD, and Finance, BO 3.1.

Confidential|CA Jan ‘08 – Feb ‘09 
SAP BW Consultant

Confidential Corporation (LIFE) is a global biotechnology tools company dedicated to improving the human condition.
Responsibilities:

• Responsible for gathering requirements and report specifications from the business and creating technical specifications.
• Responsible for modeling and handling of SAP BW 3.5 objects (MultiProviders, InfoCubes, InfoObjects, ODS, Transformations, DTP’s, and Process Chains).
• Knowledge of different update modes - Direct delta, Queued delta, unsterilized v3 update.
• Involved in modification for FIreports.
• Working on loading processes and delta concepts.
• Working on Core SAP business processes: FI-AR, FICO, SD and experience in BW implementations of these modules
• SAP BW Load monitoring and troubleshooting.
• Wrote ABAP Routines as per user requirements.
• Involvedwith performance tuning of queries by maintaining aggregates, 
  compression.
• Worked extensively on administration workbench (RSA1), customized Info-Objects, Info Sources and Info Cubes.
• Monitoring of Info packages and analyzing the reasons for failures of
  Info packages.
• Created generic extractors for customer-defined tables.
  • Developed various data extraction procedures for master data For attributes, texts and transactional data (full and delta) using LO Cockpit.

Environment: SAP BW 3.5, SAP BI 7.0, BEx Query Designer, BEx Analyzer, SAP FI, SD.

Confidential, Ohio Jan ‘07- Dec ‘07
SAP BW Consultant

Confidential’s is a publicly traded company. The company’s operations are divided into four business segments: North American Consumer, Lawn Service, International Consumer and Global Professional. The Company is headquartered in Ohio for over 131 years, and is the world\'s largest maker and marketer of horticultural and turf products. Its garden and indoor plant care items include grass seeds, fertilizers, herbicides, potting soils, and related tools. Brand names include Ortho, Miracle-Gro, Hyponex, and Turf Builder.

Responsibilities

• Involved in the implementation of BW for SD module.
• Worked extensively on Administrative Work Bench (AWB).
• Activated standard business content cubes: Sales Deliveries (0SD_C02), sales Overview cube (0SD_C03).
• Customized Info Objects, Info Sources and Source Systems to load data into Info Cubes using Transfer and Update rules.
• Used PSA for checking data quality before loading and used BW monitor for troubleshooting problems during Loading.
• Monitored Process Chains to load InfoCube, ODS, aggregate, rollup.
• Extract Master data and Transaction data from SAP R/3 system and historical data from flat files.
• Used LO Cockpit extensively. Extracted data from SD Module uploaded data to sales deliveries and sales Overview cubes through 2LIS_11_VASCL, 2LIS_11_VAITM, 2LIS_11_VAHDR using V3 update.
• Used ODS to stage the data before transferring the ODS content to the info cube and have done ODS Reporting to give details of delivery items and schedule line items.
• Created MultiProviders to view transaction data from different cubes.
• Improved data loading and query performance by compression and indexing.
• Created Aggregates for Sales Order cube and Sales Delivery cubes to improve the query performance.
• Worked on BEx-Query Designer to create Queries.
• Used Filters, Free Characteristics, Calculated Key Figures, Restricted Key Figures, Variables, Exceptions, Conditions and Report to Report Interface.

Environment: SAP BW 3.5, SAP R/3 4.7, BEx Query Designer, SD, FI.

Confidential, NJ Jun 2005 – Nov 2006 
SAP BW Consultant

Confidential provides advanced energy-efficient solutions for all segments: road lighting, office & industrial, hospitality and home. Philips is also a leader in shaping the future with exciting new lighting applications and technologies such as LED technology.

Responsibilities

• Exposed in to full lifecycle right from BW configuration, modeling, analysis, design specification, development, performance tuning and maintenance
• Activated business content objects as per the design requirements.
• Extensively used BW standard business content extractors to extract data from SAP R/3 to BW and performed enhancements to accommodate business needs.
• Worked extensively on standard and custom defined LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order and delivery billing information.
• Created transfer and communication structures, transfer rules, update rules for ODS and InfoCube level
• Used Start routine to transform the data and load in to data targets.
• Performed loading of transaction data into info Cubes and master data (Attributes/Texts) into ODS and Info Objects.
• Used ODS objects to store external data and update it to various data targets.
• Created Aggregates and indexes for Info Cubes to improve performance.
• Scheduled data extraction, transfer rules, update rules, deleting indexes, creating Info Package, creating indexes and roll-up aggregates using Process Chains.
• Experienced in creating restricted and calculated key figures to report YTD information.
• Generated standard reports using BEx query Designer and Published reports on web.
• Customized the Business Content Queries to analyze the Quotations/Orders data.

Confidential, Sep ‘04 – May ‘05
San Diego, CA 
Software Developer
BranchNet provides access to a core of functionalities for financial advisors to run their business and serve their clients. The Account Forms Browse in BranchNet is used to search for an existing client or account record in the Account Forms database. You can search by multiple criteria including by name,
SSN, client phone number, program and/or registration type, and account status. After you execute the search, you can modify record, print forms, change account status, or add a new record.
Responsibilities:

• Designed dynamic web pages using web pages using C#.
• Developed a Web Service for smooth searching of keywords.
• Implemented stored procedures in SQL Server 2005.

Environment: C#, ASP. NET, ADO. NET, Windows 2000 Pro, SQL Server 2000, JavaScript and XML