SUMMARY

• 8+ years of industry experience encompassing wide range of skill set, roles and industry verticals with hands on experience in SAP BI/BW Analysis, Architecture, Design, Development, Deployment, Performance Tuning, Go-live and Support activities.
• Extensive experience in working with Business Stakeholders, IT Infrastructure teams and Development teams to capture business requirements. Expert in identifying the ways the end users want to analyze data and design data access solutions satisfy the business requirements.
• Involved in two full life cycles of BW implementations with upgrade implementation, Extensive experience in 24x7 support projects involves addressing several end users tickets, production issues, implementing tasks for adding value to business, and monitoring the loads and other warehouse activities.
• Excellent skills in System Analysis, Documentation and Designing the Technical Specifications of the Processes.
• Extensive experience in working with Finance, CO-PA and logistics application modules such as SD, MM & PP, SAP CRM, HR & APO.
• Developed InfoObjects, InfoSources, InfoPackages, ODS, InfoCubes, MultiProvider, Virtual Cubes, Remote Cubes, Info sets etc.
• Expertise in various modeling strategies and involved extensively in implementing standard delivered objects from Business content.
• ABAP/4 programming involves, excellent debugging skills, enhancing various data sources, enhancing customer extractor programs, preparing various customer-exit variables preparing various objects in customer namespace, developing classical, interactive reports.
• Extensive experience in Lo Cockpit, Flat file, Generic, FI & CO-PA Extractions.
• Experienced in improvement of data loading performance by PSA partitioning & parallelization of loads
• Hands-on Experience in the design and development of Info Cubes, Multiproviders, DSOs, APDs, Process Chains etc.
• Created and maintained multiple Aggregates on InfoCubes and performed Rollup and Compression.
• Hands on experience in the BW Upgrade from 3.5 to BI 7.0.
• Experience in enhancing datasource as per user requirements.
• Worked extensively with BEx Query Designer, BEx Analyzer and Web Application designer.
• ABAP Programming experience in Reports (Classical & Interactive ALV’s), Function
• Modules, Have in depth knowledge of Data Dictionary Objects, Dialog programs.
• Experience in QA Life Cycle, including preparing Test Cases and testing the developed programs (Unit testing, Integration testing, Regression testing, System testing).
• Expertise in debugging and solving tickets.
• Experience in working with onsite offshore model.
• Good interpersonal skills, effective communication skills with excellent team playing capabilities.

PROJECT SUMMARY

Kiewit, Omaha, NE Jan 2011 – Date
SAP BW developer
Responsibilities:

• Worked on redesigning of ERTB Sales Order, Billing and allocation project, pulling delta from R/3 to staging environment and then into Integration layer, Worked on Batch Design for Sales Order, Billing and Allocation Delta pull into staging layer and Integration layer.
• Interacted with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Worked closely with the Corporate Consultants in providing Functional Specifications to enhance the current and develop new.
• Created Info Packages to do Full, Initial, and Delta extraction for both Master data and Transaction data with dynamic selection criteria where needed.
• Created Process Chains to automate the data load and data target administration and monitored the processes.
• Involved in Setting up and Monitoring Process chains for the complete data extractions and Loading.
• Performance tuning at data loading, reporting before Go-Live. Analyzed performance statistics and recommended improvements.
• Worked on Design & Development on BW / CRM and FI related BI objects & queries.
• Created Multi cube based on Sales order and Billing cubes. Created
  Infosets on ODS objects for detail level reporting for Jump queries
  (seamless drill thru reports).
• Created TODS objects to load closed Sales orders schedule line level data from standards ODS partitions holding sales order data at grain level.
• Created InfoCubes in Analytical layer to load sales Schedule line data from TODS objects in Integration layer for EMEA region.
• Worked extensively with data sources 2LIS_13_VDHDR, 2LIS_13_VDITM, 2LIS_11_VAITM, 2LIS_11_VASCL.
• Expert in data extraction from R/3 utilizing the CO-PA extraction utilizing ODS to stage data prior to transferring ODS contents to info cubes.
• Created Info Sets, assigned user groups to the Info Sets and also defined Info Set queries. Create exception evaluations for queries. Designed multiple drill-through reports from BEx Queries, ODS Objects.
• Generated BO exclusive reports in BEx Query Designer using filters, calculated key figures, and restricted key figure.
• Scheduling daily, weekly and monthly reports, adding users and folders and assigning security rights in CMC.
• Created Infospokes to extract data from SAP BW and provided it to
  various non-sap data targets.
• Handled postproduction support and development of new design cycles simultaneously.
• Created transfer routines, start routines and User Exit to lookup master/transaction data and populate key figures and Characteristics.
• Extended the extract structures by adding new fields and populating them with the User Exits.

Confidential,Irving Texas Oct 2009 – Jan 2011
SAP BW consultant
Responsibilities:

• Worked extensively on the design, development and maintenance of the BW solution.
• Analyzed the requirements, worked on gap analysis and identified existing business content as well as areas for enhancements.
• Extracted Master data and Transaction data from CRM into BW.
• Activated the Business Content data sources in CRM system.
• Designed & Created CRM related data models in BW.
• Conducted several workshop sessions with users during the requirement gathering.
• Created
• Designed backend and report for Project and Territory Management system.
• Extracted CO data to incorporate overhead Cost controlling and Cost Center Accounting data in BW reports.
• Worked extensively with Logistics data sources 2LIS_12_VCHDR, 2LIS_12_VCITM, 2LIS_08TRTLP.
• Created several ABAP user exits for Bex reporting purposes
• Developed reports for Business profitability analysis, Profitability summary by product hierarchy, customer purchase summary, Profitability detail by product hierarchy, Profitability summary by customer, actual price realization comparison, Profitability summary by geography, Profitability summary by customer and product.
• Extensively worked on Enhancing ECC Logistics data sources using ABAP user exits.
• Extensively involved in creating Info objects, Data Store Objects, Transformations, Info cubes, Multi providers. Involved in enhancing the data sources and write the ABAP coding to populate the enhanced fields. Involved in writing routines and customer exits
• Responsible for the evaluation of the current system and defining the scope of the BW project for cost controlling and developing extractors and reports.
• Worked with Inventory datasources like 2LIS_03_UM, 2LIS_03_BF, 2LIS_03_BX.
• In-charge of loading and monitoring data in to the cubes for the sales, delivery and invoicing as Part of Order to Cash implementation.
• Performed Production Support Activities to take care of loading Adjustment files for supporting month end closure. Resolved several production support issues like fixing load failures during the execution of process chains.
• Managed several Go-Lives by coordinating with various cross functional teams and Project Management teams and creating Plan for the Go-Lives.
• Worked closely with SAP by opening High and medium messages whenever an issue is encountered
• Improved data loading performance for sales and delivery by limiting data packet sizes, scheduling index deletion and rebuilding jobs as well as through ABAP tuning. As a result of these efforts data loads were conducted successfully within half the time.
• Modified both generic SAP R/3 extractors as well as LIS and LO-Cockpit extractors.
• Responsible for quality assurance on the extraction side and for implementing required modifications.
• Implemented reporting requirements by developing BEx-queries for the areas mentioned.
• Developed reports using ALV grid technology for accounts payable department for cost controlling and reconciliation.

Environment: SAPBW7.0, ECC 6.0,HR, SD,APO, PS, Bex Analyzer, Bex Browser Oracle 8.0, SQL Server, Windows NT, SCM4.0, Web template, Workbooks

Confidential, NJ Jul 2008 – Sep 2009
SAP BW Consultant
Responsibilities:

• Worked on different phases of implementation from project analysis, process design, blue print, configuration, prototype, data loads, unit testing, integration testing, power user training and production support.
• Worked with the BASIS team on installing the SAP BW BO Integration kit.
• Worked on the Upgrade of the BW from 3.5 to BW 7.0.
• Involved in the Implementation of BW 7.0 with Focus being mainly on Finance data models
• Coordinating with clients to mine corporate data to identify, analyze and integrate data from multiple sources and turning data into useful information using BW.
• Extensively worked on testing all the ETL processes in different landscapes after the upgrade to make sure data loads are working fine.
• Interacted closely with Basis team to formulate working plan for the Pre Upgrade, Upgrade and Post upgrade phases.
• Performed a major role in End User Training with BW Queries & new Functionality available with BW 7.0.
• Extensively involved in Design review sessions and project planning sessions for European Go live.
• Created and maintained multiple Info cubes for the FI module.
• Loaded data into standard Info-cubes 0FIAP_C03 and 0FIAR_C03 using ODS objects 0FI_AP_O03 and 0FI_AR_O03.
• Enhanced the 0FI_AP_1, 0FI_AP_2 data sources.
• Created Process chains for all the data models created and scheduled them using Control M.
• Consistently followed Sap's best practices when developing the data models.
• Created Complex workflow report which displays the total number of outstanding workflows and the corresponding approvers.
• Created a complex effective tax rate report which displays the Intercompany and third party sales for several customers for low tax rate jurisdictions.
• Extensively worked on creating drill down reports from the main report to display line item details. Interacting with management and the end-users to identify the business requirements and documented them.
• Incoming sales data are extracted to SAP BW cube for currency conversion reporting to handle the different currency.
• Strong expertise in Data Modeling, Data Cleansing, Data Governance and Data Quality using BW ETL techniques.
• Involved in creation of role based security and authorization for certain Info Cubes and Info Objects.
• Used BEx conditions and exceptions functionality to highlight the entries in management reports.
• Designed Process chains for automating the delta loads, aggregate rollups and change runs.
• Developed a standard reports and saved them in workbooks.
• Trained end users extensively with various capabilities in BEx and Web Reporting.

Environment: SAPBW7.0, ECC 6.0, HR, SD,APO, PS, Bex Analyzer, Bex Browser Oracle 8.0, Windows NT, SCM4.0, Workbooks

Confidential, Infosys Technologies Ltd, Dec 2006 -Jun 2008
SAP BW developer
Responsibilities:

• Interacting with management and the end-users to identify the business requirements and documented them.
• Worked on Inventory handling and material movement (Article) to Distribution center and Customer.
• Involved in the design and development of Info Cubes. Responsibilities include development of new Info Cubes & Enhancements to the existing functionality as per the user requirements.
• Involved in the design and development of InfoCubes and ODS objects in SD, MM & FI applications.
• Defined Complex reports by defining complex ABAP Routines to get the fiscal period automatically based on the calendar day entered.
• Developed most of ABAP to code the logic in start routine so as to optimize loading times.
• Written ABAP code for functional enhancements for Transactional Data.
• Worked extensively with 2LIS_11_VAITM, 2LIS_11_V_SSL & 2LIS_02_SCL extractors.
• Extracted data from FI-GL data sources 0FI_GL_4 and 0FI_GL_6 to load data into custom infocubes.
• Developed Custom GL InfoCubes using the standard Info Cubes 0FIGL_C01 and 0FIGL_C02.
• Created Info Sets, assigned user groups to the Info Sets and also defined Info Set queries. Create exception evaluations for queries. Designed multiple drill-through reports from BEx Queries, ODS Objects.
• Extracted the Purchasing details for Pre- packs from R/3 to BW.
• Provided support for data load, validation, performance monitoring and tuning. BW Data load scheduling, monitoring and troubleshooting data extraction / load problems using LO Cockpit and COPA.
• Report delivery is via the web using queries, web templates, and security-based roles.
• Scheduling Info packages for loading Master Data and Transaction Data & Monitoring.
• Configuration work has included Infoobjects, Info Cube, Transfer Rules, Update Rules, Roles, Queries, Web Templates, ABAP, etc
• Extracted purchasing documents and inventory data from R/3 using LO cockpit, implemented Report-to-Report Interface and R/3 thrill-through for drill down analysis, and developed SAP BW reports for performing the analysis of purchasing documents and inventory management
• Uploaded master data and transactional data from SAP R/3 via data staging to PSA, ODS and Info Cubes. Worked with data flows from R/3 to BW.

Environment: SAP R/3 4.6C, BW 3.5, SAP Portals, MM, FICO, BEx Analyzer, BEx Browser, ABAP Query, Oracle 8.0, Windows NT.

Confidential May 2004-Nov 2006
SAP BW developer
Responsibilities:

• The reconciliation of data between BW and R/3 systems & Trouble Shooting
• Monitoring the periodic global data load (daily, weekly and monthly).
• Change run and aggregate maintenance. Conversion of info package groups in to process chains. Request for Change issues related to reports & ETTL
• Enhanced complex start routines at Update rule and transfer rules, and ABAP routines at info package selections.
• Involved in analyzing Client’s data from OLTP systems related to cost center, profit center accounting and Materials management.
• Extracted Data from various Data Sources related to financial accounting.
• Uploaded data for analysis into InfoCubes, ODS Objects, and Master data tables by triggering initialization, delta and full update methods to implement a performance oriented, periodic data transfer strategy.
• Used Process chains, Event chains and Info Package Groups for sequential background scheduling of Master Data and Transactional Data.
• Extensively involved in data maintenance by creating and maintaining Aggregates, Indices, Aggregate Indices, and DB Statistics.
• Used BW statistics and System administration Assistant for measuring system performance and implemented various strategies for fine-tuning query and load performance.
• Executed queries against various Info Providers in BEx reporting environment using BEx Analyzer, BEx Browser, and BEx Web tools.
• Configured various Settings in Reporting Agent for Reporting Exceptions and Printing Query Results as Background Jobs.
• Web-enabled various queries using SAP BW Web Publisher with and without wizard, and also by launching the query in web browser.

Environment: SAP BW 3.5B, R/3 4.6C, SD, MM, FI/CO, BEx Analyzer, BEx Browser, WAD Web Template, ABAP Query, Windows NT.

Education
Bachelor of Technology,2004; J.N.T.U; .