SUMMARY

• Eleven (11) years experience in Information Technology including over 9 years in SAP BW 3.5/7.0/7.3 and BO XI 3.1.
• Experienced in 3 full Life Cycle implementations from design to go - live.
• Expertise in gathering reporting requirements from end users and determine technical design to deliver reporting.
• Architectural Planning, Roadmap & Strategy
• Business Process & Enterprise Data Modeling
• Relational & Dimensional Architecture
• ETL, Presentation Layer & Reporting Framework Design
• Systems & Data Warehouse Development Life Cycle
• Team Training, Mentoring & Leadership Integrate Planning and Consolidation process design
• Report design and development concepts
• Strong knowledge of best practices and methodologies
• Business Areas - SD, MM, FI-CO, PM, HR, EHS.
• 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.
• Conducted training sessions for users in BW reporting.
• Methodology - Solution Manager, ASAP
• BI-IP -Transactional Info Cube, Planning Environment, Planning Functions, Planning Layouts, Planning profiles, Planning Folders and working knowledge of BPC.

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), IP, BPC, SAP BW 3.5/3.1C/3.0B.

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

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

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

PROFESSIONAL EXPERIENCE

Confidential, CORNING NY

LEAD. BW Developer

Responsibilities:

• Designed data model and led team in developing new reports.
• CreatedWebI, Crystal, and Xcelsius reports with SAP data (SD and FI).
• Implemented BO 4.0 with IDT and BICS.
• Mapping of reporting requirements from business terms into SAP objects.
• Creation and maintenance of OLAP universes sourced from BEx queries.
• Writing and editing of SAP BEx queries using Query Designer.
• Writing of test scripts for accuracy, formatting, and performance.
• Currently leading efforts to rewrite the Agent Compensation reports to support the rollout of new application.
• Assist in the review, analysis, and implementation of new reports or system changes as required by new authoritative accounting guidance.
• Worked on Cut-over activities and data validations and post. Go-live support.

Environment: BW 7.0/7.3,BI 4.0, BEx, ECC 6.0

Confidential, Dallas, TX

LEAD Consultant

Responsibilities:

• Actively participated in the blueprint phase of SAP BI project regarding the architecture phase.
• Responsible for the development of strategic documents including the technical specs.
• Performed the data analysis and data modeling for the SAP HR reporting project
• Created Write-Optimized DSOs, and Direct Update DSOs.
• Created BO Reports using Webi and dashboards using Xcelsius.
• Participated in the project estimation and prepared the work breakdown structure (WBS) of projects
• Participated in requirement meetings with clients and stakeholders
• Designed the mapping templates for data extraction and loading and supported ETL developers

Environment: BI 7.0/7.3 Flat Files, BEx, WAD, ECC 6.0, Oracle, BI 4.0.

Confidential, Madison, WI

PRINCIPLE Consultant

Responsibilities:

• Prepared the Road map of SAP BI and IP.
• Created Aggregation levels, Data slices, Planning Functions, Planning Sequences, Filters and variables.
• Created POSDM DSOs and Inventory Stock and Movements Cubes for Retail Implementation.
• 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 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 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, Pittsburgh PA

LEAD Consultant

Responsibilities:

• Monitoring Chains on Daily Weekly, Monthly.
• Loading Master data, Transaction data into the SAP BW on daily basis.
• Handling the tickets raised by the market.
• Worked in BW 3.5 to 7.0 upgrade project
• Involved in report migration from BW 3.5 reports to BI 7.0
• Analyze the errors in the data loads.
• Using Lo cockpit configured and maintained MM data sources.
• Uploading Master and Transactional data from Flat files and SAP as the OLTP sources, worked extensively on Administration workbench.
• Installed Business content as and when required.
• Involved in Creation of reports using BEx Analyzer such that the execution time is evenly distributed through the report by using Free Characteristics, Restricted Key figures, calculated key figures, Variables and Exceptions.

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

Confidential, SECAUCUS, NJ

LEAD 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 Info Cubes, Info Sources, Transfer structures, Transfer rules, and 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.
• 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, CINCINNATI, OH

LEAD 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 (Universal Pictures International, 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.
• 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, LOUISVILLE, KY

SAP 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, WASHINGTON, DC

Sr. SAP BW Consultant

Responsibilities:

• 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, NEW YORK, NY

SR SAP BW CONSULTANT

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.

Confidential

SAP BW Consultant

Responsibilities:

• Created respective update rules with necessary update routines.
• Created the infosources and scheduled several data uploads like initialization with delta updates. Monitored the scheduled background jobs.
• Data extraction from SAP R/3 using LIS, LO, CO-PA and Generic extractors with generation and maintenance of Extract structures, data sources and transfer & update rules.
• As a part of maintenance and as per end users requirement, created new columns in the ODS and InfoCubes and uploaded the same without disturbing the historical data.
• Created Various Complex Reports to in corporate Dynamic revenue data to be updated and reported in tightest possible business cycles (sell-in daily, sell-through weekly, Revenue Trending versus annual/mid-year plan, outlook, forecast versus actual sales).
• Worked extensively on BEx Analyzer (RRMX).
• Created queries using BW-Reporting Variables, Navigational attributes and Filters and also on the Multi Cubes.
• Developed several queries and the workbooks using BEx Analyzer according to end users requirement.
• Created Roles and Authorization objects in security.
• Used RRI jump queries using the transaction RSBBS for drilling down to other queries and R/3 transactions. Mentored the BW users in Handling BEx Analyzer and Browser.

Environment: SAP 4.6C, SAP BW 3.0B, MM, SD

Confidential

ABAP/4 Consultant

Responsibilities:

• Involved in data conversion and data migration from legacy data into SAP R/3 in MM, SD and FI modules (Vendor Master data, Material Master data)
• Uploaded Customer Master using Session Method.
• Developed and Designed forms using SMARTFORMS for MM module like Purchase Order, MIGO, MIRO etc.
• Solved SMARTFORMS printing issues like printing both Arabic and English in forms like Sales Invoice, Purchase Order and MIGO.
• Modified HR time reports calculating short attendance, incorrectly punching, normal attendance etc.
• Developed quarterly sales & production report, report contains quarter wise Production and sales data.

Environment: SAP R/3 4.0B (MM, SD,HR, FI-CO,), ABAP/4