Summary:

• Over 7 years of experience in design, development, implementation and testing in SAP BI/BW and SAP R/3 environments.
• Implemented 3 full life cycle BW projects in SD, FI-CO and MM modules.
• Experience in BI 7.0 data modeling, DTP and Transformation process.
• Expertise in development and maintenance of Info Cubes, ODS Objects and Multi-providers, Info Sources, Transfer structures, Transfer rules, Communication structures, Info Objects, Update rules.
• Possess strong back-end data modeling skills, including the design, architecture and data model.
• Performed extensive CO-PA, LO Cockpit and generic data extractions
• Experienced in all phases of BW implementation using ASAP methodology.
• Exposed to all phases of BW implementation like analysis, design specification, development, testing, documentation and trouble-shooting.
• Configured and implemented BW reporting using BEx analyzer/browser, Report Designer and Web Application Designer.
• Expertise in front-end BEx Components such as Calculated key figures, Restricted key figures, Structures, Variables, Conditions, Exceptions and Workbooks.
• Experienced in Performance tuning of queries using aggregates, table partitioning, compression and indexing of Info Cubes.
• Experienced in monitoring the system load and query performance.
• Exceptional ability to quickly master new concepts and technologies.
• Well organized, hardworking and committed to ensure timely delivery of work.
• Excellent communication, presentation, and interpersonal skills
• Capable of working in a group as well as independently.
• Involved in End-User training and documentation.

Professional Experience:

Confidential, Milwaukee, WI June 2008 - Present
Sr. SAP BI Consultant
Environment: SAP BI 7.0, SAP R/3 ECC 6.0, BEx, Report Designer, FI - GL, FI-AR, FI- AP, MM(Inventory Management), Windows NT.

Responsibilities:

• Analyzed and mapped Grede business requirements to SAP BW and wrote Business Blue Print using ASAP methodology.
• Responsible for design and development activities which include Info-providers, Transformations, Routines, Enhancements, Data sources, Master Data, DTP, Data loads, Query & Report design and Transports.
• Implemented FI-GL (General Ledger New), FI-AR (Account Receivables), FI-AP (Account Payables) and IM (Inventory Management).
• Key Finance reports delivered include Grede Income Statements, Consolidated Comparative Operating Statements, Grede Balance Sheet and Director Statements.
• Accounts Receivable reports built include Aging Summary by Customer - All Items, Vendor analysis, Customer Short Payment Items, Aging Summary by Customer - All Items - Net of Short-Pays, Customer due date analysis, Customer Overdue analysis.
• Created Inventory reports which include Vendor & Customer Consignment Stocks, Stock Analysis, Weekly Inventory Report, and Inventory analysis by plant & storage location.
• Used 2LIS_03_BX, 2LIS_03_BF and 2LIS_03_UM data sources for MM implementation of Non-Cumulative Key Figure model.
• Implemented APD (Analysis Process Designer) to capture weekly Inventory snapshots in a DSO. Used a query created on Non CKF Inventory Data target as an input to the APD and output written to DSO.
• Performed Master and Transaction data extractor enhancements to accommodate various client requirements.
• Configured Currency translation for Valuated Inventory values.
• Built Infosets and Multiproviders to meet reporting requirements.
• Performed Master and Transaction data extractor enhancements to meet report requirements.
• Extensively worked with BExAnalyzer, Report Designer to create queries and design reports.
• Extensively worked with BEx to design reports and created queries using variables, conditions, filters, restricted and calculated key figures, formulas.
• Used RRI to jump between the queries for FI reports to display the corresponding accounting documents.
• Worked on performance tuning activities like aggregates, indexing, Info Cube Compression and query monitoring.
• Interacted with users on a regular basis to gather report requirements and formats.

Confidential, Canton, OH Sept 2007 - May 2008
Sr. SAP BW/BI Consultant
Environment: SAP R/3 ECC 5.0, BI 7.0, BW 3.5, BEx Analyzer/Browser, ABAP/4,SD,CO-PA,FI,MM, PP.

Responsibilities:

• Involved in gathering requirements in functional areas of SD, MM and CO-PA.
• Worked on Business Content GAP Analysis to determine the need for developing custom extractors and custom model
• Extensively worked on purchasing data extraction.
• Extensively worked on Transformations, DTPs and Routines, Data loads, Query & Report design and Transports.
• Worked on creating process chains for loading master data and transactional data.
• Developed Trended and non-Trended versions of Revenue reports by Region, Product, Service, and function for managerial analysis.
• Created SD reports for Backorders, On-time deliveries, Daily Sales, Sales Growth, Sales monthly Trend.
• Created info spokes for downloading aggregated data and sending it to forecasting tool legality.
• Worked extensively on Business Content SD Extractors and enhanced datasources to add custom fields for 2LIS_11_VAITM, 2LIS_11_VAHDR, 2LIS_11_VASCL AND 2LIS_13_VDITM.
• Designed generic data extractors to extract customized data from tables and Functional Modules to suit the Business Warehouse model.
• Loaded master and transactional data from source system R/3 and Flat File.
• Activated Business Content Info Sources, Info Cubes, Roles, Queries, and Info Objects.
• Attending to the Production Users BW issues and cases filed in Support Central and providing solutions within a specific time frame; Support any data issues related to the BW data or BW Web and BeX Workbooks being used by the Business Users.
• Daily Data load Monitoring of the BW jobs. Ensuring daily data load from R/3 to BW is successful with the help of mail notification on the status of the load.
• Involved in the implementation of Open-Hub Service to send the daily snapshot data to an external application.
• Worked on LO cockpit for Maintaining extract structures, Info Sources and activating the update.
• Extensively worked with Data Sources, Info Sources, & PSA for Data extraction, transformation and loading from SAP R/3 system to SAP BW
• Involved in escalating high-prioritized tickets regarding extractions, Performance Issues and also load failures.
• Monitoring of Info packages and analyzing the reasons for failure of Info packages.
• Designed complex queries in BEx.
• Web Reporting - Development web reports, web items, customized web templates using web application designer (W A D) and query designer for creating Dash Boards.
• Monitoring of Info packages and analyzing the reasons for frequent failure of Info packages.
• Maintaining Reconciliation's to verify the data in SAP R3 and SAP BW are same or not after the data loads.
• Involved in performance tuning of Queries by maintaining Aggregates, Compression and partition.

Confidential, Hickory, NC Oct 2006 - Aug 2007
SAP BW Consultant
Environment: SAP R/3 ECC 5.0, BW 3.5, BEx Analyzer/Browser, FI-CO, SD, Crystal Reports, ABAP/4.

Responsibilities:

• Involved in gathering requirements in functional areas of FI-AP, FI-AR and CO-PA.
• Analyzed the existing operating concern in SAP R/3 system to create a data source according to reporting requirements in CO-PA.
• Designed and created a data source in CO-PA on line item table.
• Designed and created an Info cube; and also an Info source to extract data from CO-PA in to BW.
• Created transfer rules, update rules, transfer routines and update routines in CO-PA extraction.
• Loaded master and transactional data from source system R/3 and Flat File.
• Activated Business Content Info Sources, Info Cubes, Roles, Queries, and Info Objects and customized Business Content to meet business requirements.
• Developed customer analysis and product analysis reports.
• Worked on Standard LO'S. Installed relevant SAP business content. Used LO cockpit, for extracting sales order information.
• Worked with Profit Center Analytics in Retail infocube i.e. 0RTL_C03
• Customizing of extract structures for SD Sales data sources like 2lis_11_vahdr, 2lis_11_vaitm, and 2LIS_11_VASCL.
• Extensively worked with Data Sources, Info Sources, & PSA for Data extraction, transformation and loading from SAP R/3 system to SAP BW
• Knowledge of different update modes like direct delta, queued delta, Unserialized v3 update.
• Monitoring of Info packages and analyzing the reasons for frequent failure of Info packages.
• Created info Packages and populated info Cubes with initialization and delta loads at predefined scheduled time settings. Used full update methods depending on the requirement.
• Created navigational attributes for certain characteristics for a better drill down option during querying.
• Used BEx Analyzer for designing queries. Defined Variables, Conditions, filters and Exceptions in BEX queries.
• Involved in performance tuning of Queries by maintaining Aggregates, Compression and partition.
• Interacted with users on a regular basis to gather report requirements and formats.

Confidential, Orlando, FL May 2006 - Sept 2006
BW Consultant
Environment: SAP R/3 4.6c, BW 3.5B, SD, MM, FI/CO and ABAP/4, Windows 2000/NT.

Responsibilities:

• Worked on LO Cockpit extractions, to load data to different infoproviders like InfoCubes, ODS objects for different applications.
• Carried out several data loads by executing info Packages using both the update methods i.e. full update method and initialization with delta update.
• Activated InfoSources for transaction and master data. Assigned source systems to the InfoSources and updated.
• Created custom data targets, update rules, transfer rules and info sources.
• Created info Packages and populated info Cubes with initialization and delta loads at predefined scheduled time settings. Used full update method based on the requirement.
• knowledge of different update modes - direct delta, queued delta, Unserialized v3 update
• 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.
• Worked on creating Partitions and Indexes for infocubes to improve performance.
• Validated the data in the files coming from R/3(MM, SD and FI) side.
• Helped in creating some BW based roles and authorizations.
• Created navigational attributes for certain characteristics for a better drill down option during querying.
• Loading transaction data (5 million records each month and a total of 60million records) and master data from flat files.
• Created process chains to load the statistical cubes daily.
• Created aggregates on the required cubes.
• Designed complex queries in BEx.
• Worked extensively with Web application designer. Expertise with all the web items and also worked with several customized style sheets.
• Performed the role of reporting developer by developing several reports based on the end-user requirements.
• Developed several reports based on the requirement and also helped in trouble shooting and rectified the BW errors.

Confidential, Kansas City, MO Aug 2005 - April 2006
Sr. SAP BW Consultant
Environment: SAP R/3 4.6C, SAP BW 3.0B, BEx, FI/CO, SD, Oracle 8i, Windows 2000.

Responsibilities:

• Analyzed and mapped business processes to BW and wrote Business Blue Print using ASAP methodology.
• Extensively worked on FI/GL, FI/SL, SD extraction and reporting in SAP BW.
• Built Insurance related reports on Gross and Net Claims, Active Claims - Disbursements count and average outstanding, Inter company Retro Inwards/Outward technical balances, Allocation process monitoring- yield throughput, GL account variance.
• Successfully tested cross-company, multi-currency postings and reporting in local, group, and transaction currency. Handled Currency Conversions for Global reports showing worldwide sales and Consolidated reports.
• Created open payments, Collections outstanding, Aggregate stop loss rolling interest schedule and net benefit reports.
• Created Start Routines to identify weekly and monthly open documents from the cube and delete the redundant data packages using record update character.
• Responsible for implementing claims count cube for summarized claims, collections and Billing Information. Also required to create Multiprovider on GL, Claims count and Accounting Engine Info cubes.
• Created Consolidated and unconsolidated company specific balance sheet and P & L reports.
• Developed status infocube to keep track of claim status and validated the multicubes with status cube.
• Created Forecast ODS, Infoset and Claims history cube using data source from R3 and DB Connect.
• Created ODS and loaded 12 million records.
• Calculated sizing estimate for each InfoCube and ODS.
• Developed the Process Chains to automate the data load of transaction, master data and aggregates.
• Extensively used BEx analyzer, created queries with variables, filters, formulas, restricted and calculated keyfigures. Used RRI to jump between the queries.
• Extensively worked on performance tuning activities like aggregates, indexing, partitioning, Info Cube Compression and query monitoring,
• Provided extensive end user training and resolved issues.

Confidential, Elkhart, IN Nov 2004 - July 2005
SAP BW Consultant
Environment: SAP R/3 4.5C, SAP BW 3.0B, BEx, SD, FI-CO, Oracle 8i, Windows 2000.

Responsibilities:

• Exposed to full lifecycle right from BW configuration, modeling, analysis, design specification, development, performance tuning and maintenance
• Involved in Business Blue Print using ASAP methodology
• Performed extensive FI-GL, AP, AR, CCA, PCA and CO-PA extractions. Used CO-PA structures for sales trace overview to facilitate the data extraction to BW
• Extensively used BW standard business content extractors to extract data from SAP R/3 to BW and performed enhancements to accommodate business needs.
• Created Balance Sheet - Monthly and Quarterly Breakdowns, Profit & Loss Reports for financial accounting needs.
• Created Sales reports like Monthly Sales, Sales Growth, and Revenue by location and by product.
• Analysis included reviewing SAP R/3 FI functionality, transactional data, CO-PA configuration & functionality.
• Created transfer and communication structures, transfer rules, update rules for ODS and InfoCube level
• Created custom CO-PA Cube, ODS, Data Mart to satisfy business requirements.
• Developed designs dealing with currency conversions as per the user requirements
• Managed and monitored several data loads. Optimized load performance by adjusting the packet sizes
• Extensively used BEx analyzer, created queries with variables, filters. Used RRI feature to jump between the queries to analyze the data
• Interacted with business users to analyze the requirements of reports

Confidential, Natick, MA. Dec 2003 - Oct 2004
SAP BW Consultant
Environment:SAP R/3 4.0B, BW 3.1, BEx, ABAP/4, FI/CO, SD, MM, PP, Windows 2000.

Responsibilities:

• Involved in implementation of SAP BW for financial and logistics modules
• Interacted with end-users to gather business requirements and transformed them into technical work plan
• Extensively used BW standard business content extractors to extract data from SAP R/3 to BW.
• Extracted the purchasing data for Fulfillment Rate report, variance report, etc
• Created reports like Inventory status report, Inventory aging report and Actual Vs Production Plan report on PP and Inventory Management data.
• Administering through BW workbench. Involved in end to end design and construction of BW objects
• Responsible for design, development and extraction of data from R/3 and flat files. Assign data sources to the InfoSource and metadata maintenance for the InfoSource
• Monitored data loads with full update and delta mechanisms for both master and transaction data
• Created aggregates to improve the query response. Configured use of variables, exceptions, conditions
• Used BEx to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures. Worked on currency conversion as per the user requirements
• Created Drill through queries from summarized InfoCube to detail ODS data
• Involved in training for end-users on utilizing, developing and to administer BW queries

Confidential, Denver, CO May 2002 - Nov 2003
SAP BW Consultant
Environment: SAP R/3 4.0B, SAP BW 3.0B, BEx, ABAP, SD, FI.

Responsibilities:

• Analyzed business reporting requirements that could be satisfied by SAP BW info Cubes of SD. Activated relevant business content.
• Created custom reporting. Created a custom Multi cube on the Order.
• Modified update rules and transfer rules to incorporate changes according to client requirements.
• Data extraction from generic data sources as well as application specific data sources in SAP R/3.
• Managed data loads from R/3 and flat files into BW.
• Involved in gathering requirements and analysis for Open Order functionality and also on Billing, Booking and shipment requirements for Sales and distribution.
• Extensively used LO cockpit enhanced data sources like 2LIS_12_ITM, 2LIS_12_Vahdr and also created Generic data sources.
• Developed Custom built cubes for Daily Shipment analysis and open order functionality
• Developed process chains to load master as well as transactional data.
• Developed reports in BEx Analyzer and created new web templates; developed shipment analysis reports by material, by delivery type, Quantities shipped and dollar value.

Education and Certifications:

• BS: Electronics & Computer Engineering.

Software Skills:SAP BW/BI 7.0, 3.5, 3.1C/3.0B, SAP R/3 4.6C, ECC 5.0, 6.0, FI/CO, SD, MM, PP, BEx Analyzer, Report Designer, Web Application Designer, ABAP/4, Crystal Reports 8.5, Oracle 8.0, 10g, SQL Server 7.0, C++, HP Unix B.11, Sun Solaris 8.0, Windows 2000/XP/NT 4.0/98/95