SUMMARY:

Over * years of IT experience with extensive SAP R/3, BW and BOBJ hands on experience.

* **** ************** ********** ** SAP BW and BOBJ.

Experienced in BW ETL, Data modeling, Architecture plan and Business blue print.

Configuring system Landscape, sizing estimation, propose best practices.

Expert in performance tuning of BEx queries using Indexes, aggregates, Cube compression and partitioning.

Expert in BOBJ Reports using Universe and WEBI, Dashboard and Crystal Reports.

Worked closely with basis and security teams to define the roles, security and transport.

Very familiar in SD, MM, PM and FICO for application specific and Generic data source creation

Strong understanding of SDLC process which includes Design, Development, Testing and Implementation.

Highly motivated team player with strong communication, organizational and analytical skills.

Worked in teams and adhered to the planned development time frame.

Exposure to HANA, SAP Lumira and Hadoop.

Technical Skills:

SAP Systems: SAP R/3 ECC 6.0, 4.7 and CRM 6.0.

SAP-R3 Modules: SD, MM, PP, PM, FICO and CRM-TPM.

Data Warehousing: BW 7.3, 7.0 and BW 3.5.

Reporting Tools: BEx, Business Objects (BOBJ 4.x), Universe, Webi.

Database: HANA 1.0, Oracle 10g and SQL Server 9.0.n

Employment History

Novartis, Parsippany, NJ Oct 12 – June 15

Sr. BW/BOBJ Consultant

SAP ECC 6.0, BI 7.0/7.3, BOBJ 4.0

Responsibilities:

Developed complete BW system which includes gathering requirements, analysis and data modeling.

Designed, developed and implemented new BI model for the SHAPE-OTC Project.

Worked with various standard as well as custom BW objects for FI, CO, SD, and MM of ECC.

Performed LO-Cockpit extraction to pull data from ECC SD modules into BI system extracting the Header and Line item data from the Sales and Distribution Modules.

Worked on customization and enhanced the extract structure to support business needs.

Created user exit to enhance the data source fields for reporting requirements.

Designed and developed various Data targets such as DSO, Infocubes, Infoobjects, Multiproviders and Infosets using Datawarehousing Workbench.

Debugging the Extractor checker, Transfer rules and Update rules.

WEBI Reports and BEx reports created from all the data models.

Built Universes against BW infocubes, Dso's and Multiproviders.

Developed Webi Reports against Univeerses and Bex Queries.

Profound knowledge in using Information Design Tool, created joins and resolved loops.

Worked with Datamarts, Generate export Datasource and Replication.

Created Infopackages for Init, Delta and Full loads for both Master data and Transaction data.

Extensively performed huge data loads into DSO and Infocubes from ECC as well as the legacy systems.

Developed Queries to access data from various BW Infoproviders using BEx query designer.

Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures.

Production support (on call) by monitoring the daily loads, troubleshooting the issues & fixing the errors.

Created process chains for automation of data loading and other activities.

Improved query performance using compression, aggregates and creating partitions.

Trained the client's technical as wells as the business teams on how to use the ongoing application.

Worked with the security team to evaluate and create the required Roles and authorization.

Dole Packaged Foods, Westlake Village, CA Jun 11 - Sep 12

Sr. SAP BW Consultant

SAP ECC 6.0, BI 7.0, CRM/TPM 7.0, BOBJ 4.0

Responsibilities:

Involved in business requirement, blue print, data modeling, design and development for the TPM project.

Created real time planning cube for storing different types of spend type planning data.

Attended meeting with SAP team for design review, raised many OSS messages for problem solving.

TPM Related master and transaction data were extracted using ETL (Extraction, Transformation and Loading) from CRM, ECC and automated thro process chain.

Data extracted from CRM for Budget Posting, Fund Posting and Claims.

Data source enhanced using ABAP code.

BW activities involved in Cube Design, DSO, Transformation, DTP, Data loading from CO-PA, LO-Cockpit, Generic Extraction, Flat File loading was extensively used.

Performance tuning for Planning Cube, BEx query and Data Loading was performed.

Worked in the full cycle of TPM, TFM and TCM.

Various reports created using BOBJ tool.

Create WEBI reports by using Business Objects functionalities like Alerter, Drill Down/up, Sorting, Ranking, Sections, Data Tracking, Cross tab and Calculations etc.

Developed reports based on Actual Revenue Accrual Reports Vs Forecasted Accrual Reports.

End user training given to use WEBI reports.

Hyper Care extensive support after Go-Live for solving Production related issues was handled.

NBC Universal, Englewood Cliff, NJ Nov 10 - Jun 11

SAP BI Consultant

BI 7.0, SAP ECC 6.0, Oracle 10.2

Responsibilities:

Worked with the users to get the requirements, performed gap analysis, created functional, architectural designs, reviewed Data Modeling designs with functional team.

Participating and finalizing the functional requirements from the business users.

Responsible in converting the functional requirements to technical designs.

Data extracted from SD, MM and FI/CO modules, Developed custom function module extractors and used ABAP routines in transformations.

Participated in design reviews, spec reviews, code reviews, test plan reviews.

Worked on customization and enhanced the extract structure to support business needs.

Performance Tuning - Evaluated statistical performance and provided recommendations for optimization.

Improved data load and query performance by doing compression, aggregates, and partitioning.

Created Open Hub interface to transfer data from BI to Flat Files to load to an external system.

Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, roll up and attribute change run etc.

Perdue Farms Inc., Salisbury, MD May 10 - Nov 10

SAP BW Developer

BW 3.5, 7.0, SAP ECC 6.0, CRM 5.0, Oracle 9i and UNIX

Responsibilities:

Worked as BW consultant for Data Model design as part of BW/TPM/ECC implementation project.

Data extracted from CRM system for promotion, fund, claim and master data.

Worked with several users for gathering requirements and transformed them into functional spec.

Installed, activated, implemented and enhanced various Business content objects for FI (GL/AP/AR) of ECC.

LIS data extractions are moved to LO-Cockpits for better performance.

Worked on customization and enhanced the extract structure to support business needs.

Created Functional Spec document and Detailed Design document.

BI Production support for Finance, Logistics, MM, Inventory modules.

Daily data load activities, User interaction, Function release and Regression testing every quarter.

Involved in BW installation on testing various BW objects.

Worked on Dispute Case, Fund Posting, Claim and COPA data model.

Created write-optimized DSO, real time Infocube, basic cube and multi providers.

Created Universe, Webi reports for Sales Vs. Plan and limited experience in Dashboards.

Created Process chain and transport, also installed BI content, data sources.

Given end user training and production support.

Labor Dept, Scranton, PA Aug 09 - Apr 10

SWIF (State Workers Insurance Fund)

SAP BW Developer

BW 3.5, 7.0, SAP ECC 4.7, Oracle 9i and UNIX

Responsibilities:

Workshop attended for end-user requirements gathering, developed prototyped functional BW System using ASAP methodology.

Installed the BW Objects from BI Content and made it active version with its entire dependent objects.

Created detailed Functional Design and Technical Specification documents before finally developing in the Development System.

Extracted fund data from 0PU_IS_PS_41, 0PU_IS_PS_42 and its related master data.

Handled the design and development of CO-PA Profitability Analysis cube in Controlling and Profit center accounting as part of SAP FICO BW implementation.

LIS Extraction performed using V1 and V2 update for logistics data reporting.

Transported the Objects from Development server to Quality and Production servers.

Performance Tuning including Cube Compression, Aggregates, Partitioning, Indexing and installing BW Statistical Business contents objects.

Created Process Chain to load Master Data and Transaction Data.

Written the ABAP code in InfoPackage to load data for particular fiscal period.

Extensively used BEx analyzer, created queries with variables, filters and condition.

Broadcasting BEx query views to the different group of users.

Involved in BW installation/migration and supporting the basis team.

Prepared user Training Manuals and conducted user training before go-live.

GE Silicones, Albany, NY Jul 08 - Aug 09

SAP BW Consultant

BW 3.5, SAP ECC 5.0, MS-SQL 9.0

Responsibilities:

PI, KPI and Business Subjects were identified and documented in the business blue print.

ASAP methodology strictly followed in every aspects of design, testing and implementation.

Involved in Star-Schema design, data loading, Query creation for SD - Order to Cash, PP –Procure to Pay, Inventory and FICO.

Wrote ABAP coding for start routines, transfer rules, update routines and validation programs.

Created lot of process chains, transport request, complex BEx reports, Web Templates and iViews.

Reports like Issue Vs Stock, Good Receipts repetitive manufacturing, Material Consumption, Stock Development – Quantity and Value were created.

Daily Sales, Back order, Sales Analysis, Incoming order reports were created.

Worked on Data Loading & Monitoring through process chains.

Responsible for transporting the Requests into Quality and Production System.

Contact this candidate