SUMMARY

• Around 16 years of IT experience and around 12 years of experience in SAP which includes 11 years of experience in Business Information Warehouse (BW/BI) and SAP HANA Certified.
• Project Management: Managed BW/BI Implementation projects.
• Risk Management, Cut - over activities, and Go-live support.
• Strong noledge of best practices and methodologies
• Business Areas - SD, MM, FI-CO.
• BW- InfoCubes design, InfoSources, InfoObject maintenance, ODS Objects, DSOs, Hierarchies, Multi providers, Update rules, Transfer rules, Infopackages, DTPs and Write-Optimized DSOs.
• BW Reporting - Business Explorer Analyzer, Query Designer, Web Reporting, Crystal Enterprise Management Console.
• Experience in Design and Development of Queries, Reports and Workbooks, Web Reports publishing using BEx Broadcaster.
• BW operations - Data load management, event processing, Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Load), Monitoring, Remote Cubes, and Open Hub Service, Performance Tuning, Aggregates, BW Transports.
• Testing - Master/Transaction data testing.
• Conducted training sessions for users in BW reporting.
• Methodology - Solution Manager, ASAP
• SEM-BPS -Transactional InfoCube, Planning Environment, Planning Functions, Planning Layouts, Planning profiles, Planning Folders.

TECHNICAL SKILLS

ERP: ECC 6.0/5.0,CRM 5.0, SAP R/3 - 4.6 B, 4.6C, 4.7

Business Warehouse: Nw2004s (BI 7.0/7.3) SEM-BPS, BPC, SAP BW 3.5/3.1C/3.0B/2.1C

Languages: ABAP/4, C, C++, JAVA, SQL, COBOL

Databases: HANA1.0, DB2, IMS-DB, ORACLE 9i/8i

OS: Sun Solaris 8, Confidential -UX 11.0

Reporting Tools: BEx, Webi, Crystal Reports10, BO/Xcelsius, BI 4.0

Mainframe: JCL, VSAM, FILEAID, TSO, ISPF, MVS, CICS

Office Tools: MS-Office

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Sr. BI Consultant

Responsibilities:

• Design and Implementation of BI 7.0 and upgrade to 7.3
• Created Write-Optimized DSOs, and Direct Update DSOs.
• Worked on Real- Time data and Hybrid Providers.
• Created Transformations and Data Transfer Process(DTP) on DSO and InfoCube
• Created BO Reports using Webi and dashboards using Xcelsius.
• Testing of BI InfoObjects, DSOs, Cubes and Data validations
• Created reusable structures, Restricted Key Figures, Formulas and BEx Reports and published in Web
• Created Extractors for Site Master and Article Master Data Loads.
• Created Stock and Movements cubes and Valuations DSO and data loaded using no marker update.
• Worked on Stock Initialization, Movements, and Revaluations extractions and worked on Marker Update.
• Created Daily Sales Reports and Finance Reports(G/L Balances and Gross Margin)
• Created Multiproviders and all reports are based out of MPs and are published in portals.
• Involved in creating iViews in Enterprise Portal using Portal Content Administrator.
• Worked on Cut-over activities and data validations and post. go-live support.

Environment: BI 7.0/7.3,BEx, ECC 6.0, BI 4.0, Xcelsius, Web

Confidential, Andover, MA

Sr. BI Consultant

Responsibilities:

• Design and Implementation of BI 7.0 with ECC source
• Created Write-Optimized DSOs, and Direct Update DSOs for APDs.
• Created Sales History Infocubes and logical partitioning on each cube
• Created Transformations and Data Transfer Process(DTP) on DSO and InfoCube
• Created BO Dashboards for Sales reporting using Xcelsius.
• Infocubes partitioned based on 0CALMONTH .
• Testing of BI InfoObjects, DSOs, Cubes and Data validations
• Created reusable structures, Restricted Key Figures, Formulas and BEx Reports and published in Web
• Created Extractors for Site Master and Article Master Data Loads.
• Created Stock and Movements cubes and Valuations DSO and data loaded using no marker update.
• Activated datasources 2LIS 02 BX, 2LIS 02 BF and 2LIS 02 UM and worked on Stock Initialization, Movements, and Revaluations extractions and worked on Marker Update.
• Worked on BI Security using Analysis authorizations (RSECADMIN).
• Created Process chains and automated daily loads for Transaction and Master Data loads.
• Created Multiproviders and all reports are based out of MPs and are published in portals.
• Involved in creating iViews in Enterprise Portal using Portal Content Administrator.
• Worked on Cut-over activities and data validations and post. go-live support.
• Involved in BW 7.3 Upgrade.
• Delivering the BI support project in Philips for Visual Integral Profitability of Philips for Philips Healthcare sector (VIPP-PH).
• Requirement gathering, Resource planning, Incident resolution, Problem solving and issue tracking etc.
• Supporting Dash Board reports created using Xcelsius and Crystal Enterprise.
• Performance improvements using BIA Accelerator. BIA Indexes creation on Infocubes.
• Weekly status reviews and updates to the relevant stakeholders of the project.
• Issue tracking and root cause analysis of severity1 incidents in VIPP-PH project.

Environment: BI 7.0/7.3 Flat Files, BEx, WAD, ECC 6.0, BI 4.0, Xcelsius, SAP BPC 7.5

Confidential, Akron, OH

Business Process Architect

Responsibilities:

• Prepared the Road map of SAP BI and EDW.
• Provided Solutions for Critical BI issues.
• Involved in Risk Management and Issue tracking status.
• Design and Implementation of BI 7.0 with ECC source and Legacy source (Flat File).
• Created Staging DSO, DSO Delta for Sales History Data for different years
• Created POSDM DSOs and Inventory Stock and Movements Cubes for Retail Implementation.
• Created a Data Validation reports in FI and POSDM.
• Created Sales History Infocubes and logical partitioning on each cube
• Created Transformations and Data Transfer Process(DTP) on DSO and InfoCube
• Infocubes partitioned based on 0CALMONTH .Created Filters on DTP for each year data separately
• Derived KPIs Total Sales, Average Tire Sales for Goodyear business
• Testing of BI InfoObjects, DSOs, Cubes and Data validations
• Created reusable structures, Restricted Key Figures, Formulas and BEx Reports and published in Web for Good Year Daily Sales, Preventive Maintenance, Service Sales, Daily Feed, Consumer Tire Retail report for different brands Good Year/Dunlop/Kelly Tires
• Created Extractors for Site Master and Article Master Data Loads.
• Created cubes for Operating Statement, AOP and FI-GL and Gross Margin.
• Created Write-Optimized DSOs for PODM Data, Inventory data and Gross Margin.
• Created Stock and Movements cubes and Valuations DSO and data loaded using no marker update.
• Activated datasources 2LIS 02 BX, 2LIS 02 BF and 2LIS 02 UM and worked on Stock Initialization, Movements, and Revaluations extractions and worked on Marker Update.
• Created Billing Documents, Billing Conditions DSOs and Infocubes.
• Created G1258 (Inventory cycles) report and Physical Inventory reports and data validated against MBEW table and MSEG tables.
• Created reports for Daily Sales Analyzer, Car Count, and Gross Margin Daily Tracker.
• Daily data loads support for Sales and Gross Margin with flat file source data.
• Created Process chains and worked on automation with File trigger event and used Autosys for Load process.
• Created Outbound feeds for Bonus Calculations, Sales Tax, and Car count for SMG( third party vendor)
• Created Multiproviders and all reports are based out of MPs and are published in portals.
• Worked on BI Security using Analysis authorizations (RSECADMIN) for Site and District.
• Created Broadcaster settings and distributed FI-GL Balances Summary report and Car Counts reports on daily basis.
• Involved in creating iViews in Enterprise Portal using Portal Content Administrator.
• Applied OSS Notes and worked on OSS messages with SAP.
• Worked on Cut-over activities and data validations and business to sign off.
• Created APD (Analysis Process Designer) for outbound feeds.

Environment: BI 7.0/ Flat Files, BEx, WAD, ECC 6.0, Portals

Confidential, NJ

TEMPPrincipal Consultant

Responsibilities:

• Implementation of BI 7.0 on CRM 5.0 for CRM Complaints
• Created BI Production Sales data Infocube which gets data from R/3 for Material and Plant
• Created CRM Complaints DSO object and CRM Complaints Infocube using 0CRM COMPLAINTS me datasource
• Created Transformations and Data Transfer Process(DTP) on DSO and InfoCube
• Generated Web reports on CRM Complaints to calculate the Parts Per Million(PPM)
• Loaded data for 0BPARTNER to separate the Business units data for Food Services and Food Contacts
• Created Process Chains and DTP to load Master Data and Transaction Data for DSO and Infocube

Environment: BI 7.0, CRM 5.0, ECC 6.0, WAD

Confidential, NJ

TEMPPrincipal Consultant

Responsibilities:

• Involved in the upgrade from BW 3.5 to BI 7.0 and tested the configuration of all objects in BI system.
• Created Transformations and Data Transfer Process(DTP) in BI 7.0 for PCA and CCA cubes
• Created InfoCubes, InfoSources, Transfer structures, Transfer rules, Communication structures, Update Rules and Process Chains and Aggregates.
• Data Load Monitoring and fixing the load problems in Master Data and Transaction Data for PCA, CCA, Shipments, Inventory Management, Asset Accounting, Material Ledger, AR, AP, COPA, BPS, and APO Demand Planning(DP) and Supply Planning Network(SNP) and Product Costing and Service Orders and Notifications cubes.
• Extensively Used Process chains and all jobs are controlled by a UC4 scheduler.
• Data load problem resolution using Remedy trouble ticketing system.
• Performance tuning using Aggregates, Compression, Query tuning using RSRT, RSDDSTAT.
• Web Reporting and posting Portal messages.
• Enhancements to the existing Product Costing Cube.
• Crystal Enterprise folder maintenance using Management Console
• Crystal Enterprise folder maintenance using Management Console
• Created Transformations on PCA and CCA cubes
• Created Data Transfer Processes (DTP) and used in process chains.
• Enhancements to the existing Product Costing Cube.
• Crystal Enterprise folder maintenance using Management Console

Environment: SAP BW 3.5, /7.0 R/3 ECC5.0 (MM, SD, FI-CO), SEM 4.0, BEx Analyzer, WAD

Confidential

Sr. Consultant

Responsibilities:

• Managed the Project team, assigned work and metrics reported to Client.
• Communicated Weekly status updates to client with the tasks analysis, scope and risks if any.
• Discussions with VP on SOW and scope of the project.
• Completed the feasibility study of the current business process functional specifications and identified the relevant areas for customizations.
• Involved in upgradation of BI from BW 3.1C to BW 3.5.
• Tested the System Configuration Settings for all Objects in BW 3.5 System
• Implementation of BW PCA for UPI ( Confidential, UK) with 0EC PCA 1 DataSource.
• Regression Testing of Project Juice (PeopleSoft to SAP Migration) BW.
• Created InfoCubes, InfoSources, Multi-Providers, Transfer structures, Transfer rules, Communication structures, Update Rules.
• Implemented Deltas for PCA and FI-SL by applying OSS Notes to R/3 4.6c which does not support Deltas.
• Scheduled and monitoring of data loads from R/3 during Quarter close activities for CCA, FI-GL and PCA and SPL cubes.
• Extensively worked on Process Chains, created Daily Monitoring chains using RSPCM of Financial Data Loads for PCA, CCA, FI-SL and FI-GL.
• Worked on Master Data Attributes and Hierarchies for Profit Center, Account, and Company Code data.
• Transported BW objects from Development to QA for testing using Lotus Notes MDM process and created Kintana CCP ticketing to move transports to BW Production (Change Management Process).
• Performed various tuning techniques (aggregates, statistics and Query Cache) to optimize the query performance.
• Developed flexible queries on MultiProviders using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Involved in gathering of business requirements for, functionally designing, and testing related reports, interfaces, conversions, and enhancements for SEM/ BPS.
• Design of Transactional Infocube for BPS and Monitoring batch schedules for BPS jobs.
• Support of SEM/BPS in production and worked on the resolution of issues related to batch scheduling, interfaces, conversions, reporting.
• Worked on Locking issues and added variables for new BPS users for PCA and CCA layouts.
• Created a Infospoke to for BPS data.
• Worked on administering training, executing data conversion in BPS.
• Worked on Supply Chain Management (SCM), BW Canada InfoCubes and ODS for POS (Point of Sale), Item-Level ODS,BO History InfoCubes.
• Worked on ZZSL5A loads and Process Chains for SCM BW.
• Loading CINRAM files to ODS.
• Created Views and Web Templates for PCA Work Books by using WAD.

Environment: SAP BW 3.5/3.1C, BI 7.0, R/3 4.6C (FI-CO, SD, MM), SEM 4.0

Confidential, Houston, TX

BI Consultant

Responsibilities:

• Involved in Project Development and Go-Live.
• Worked extensively on LO extraction for Sales Billing Documents, Purchasing Data, and Inventory Management.
• Created ODS and loaded flat file for Rebate Calculation according to Purchase organization, distribution channels, ship-to-party customers, material and vendor line items.
• Process Chains development (Master Data Attributes, Texts, Hierarchies and Transactional Data) for Sales, Rebate, Purchasing, and Inventory data.
• Scheduled the Process Chains for master and transactional data loads.
• Used V3 update for delta for uploading data from R/3 to BW in specific intervals.
• Transported BW objects from Development to Q&A and production.
• InfoCube compression on Inventory Cube to optimize the query performance.
• Extensively worked on BEx Analyzer and Web Application Designer.
• Created various BEx reports for Sales Billing Documents, Purchasing, FI-GL, and Inventory Management.
• Training to end users in query development-using BEx.

Environment: BW 3.5, SAP R/3 4.7 FI-CO/MM, SD

Confidential, MI

Sr. SAP BW Consultant

Responsibilities:

• Implementation of BW using Extended Star-schema according to the data requirement.
• Completed the feasibility study of the current business process functional specifications and identified the relevant areas for customizations.
• Created and activated InfoCubes, InfoSources, Multi-Providers, Transfer structures, Transfer rules, Communication structures, Update Rules (both ODS and InfoCube level) and conversion techniques.
• Worked extensively on standard and custom defined CO-PA and LO extractors.
• Extensively used LO extract structures and data sources in material management to facilitate the data extraction to BW.
• Made enhancements according to the requirements and wrote ABAP routines in Transfer rules, Update rules and Start routines.
• Involved in design, development and extraction from R/3 systems and flat file for FI/CO, MM and SD.
• Created ODS for incoming sales orders according to sales organization, distribution channels, ship-to-party customers, material and vendor line items.
• Uploaded master data and transactional data from SAP R/3 via data staging to PSA, ODS and InfoCubes. Worked with data flows from R/3 to BW.
• Used V3 update for delta for uploading data from R/3 to BW in specific intervals.
• Transported the objects from Development to QA for testing.
• Extensively used process chains to automate the process of loading data into data targets.
• Performed various tuning techniques (aggregates, statistics and partitioning) to optimize the query performance.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Worked on RRI jump queries, web publishing and ODS queries.
• Configured alert monitor, Job schedule monitor, Exceptions handling and user role maintenance.
• Involved in creation of role based security and authorization for certain InfoCubes and Info Objects.
• Training end users in query development-using BEx.

Environment: SAP BW 3.1C, SAP R/3 4.6C, FI/CO, SD, MM, BEx, Web Application Designer

Confidential

Team Lead

Responsibilities:

• Created and Activated Communication Structure, Transfer Structure, Transfer rules and Update Rules.
• Data extraction from SAP R/3 using LO Cockpit and Generic extractors with generation and maintenance of Extract structures, data sources and transfer & update rules.
• Design and development of Infocubes, Multi providers, ODS.
• Data and reporting analysis and modeling for BW Extended Star Schema.
• The Cubes and ODS developed are Sales, Customer, Deliveries InfoCubes, Sales Order ODS, Revenue ODS, Shipment ODS and Backlog ODS.
• Created custom and modified standard Info Objects based on Master and Transactional data from SAP and flat files into BW.
• Created Aggregates to improve the Query performance.
• ODS creation and maintenance for data manipulation and for drill down reporting
• Developed several queries and the workbooks using BEx Analyzer according to end users requirement.
• Created Roles and Authorization objects in security.
• Worked on Infoset Queries.
• Worked on BEx Analyzer (RRMX). Created queries using BW-Reporting Variables, Navigational attributes and Filters.
• Involved in the Process chain maintenance.

Environment: SAP BW 3.1C, SAP 4.7, SD.