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,Houston, TX Feb 2010 – Present
Confidential,SAP BW Analyst
Environment: SAP BI 7.0, BW 3.5, SAP R/3 ECC 6.0, BEx, FI-CO, SD, CCS, SEM-BPS, SEM-BCS, DB2 UDB V9, SAP BI Accelerator.
Responsibilities:

• Analyzed the current state ETL (Extraction, Transformation and Loading) of the BI 7.0 system to identify performance issues pertaining to extraction, loading and front end reporting across all modules.
• Performed a full fledged analysis to assess the performance of the BW solution and the completeness of the current BW architecture in satisfying user needs and its alignment with leading practices.
• Recommended architecture administration and performance related improvements based on the findings from the assessment and delivered a strategic roadmap to achieve the proposed future state architecture.
• Current state analysis of the system includes Source systems, BW system landscape, Infoproviders, Data modeling, Transformation logic, Reports usage and Administration.
• Analyzed modeling and performance compliance for Infocubes, DSO’s, Multiproviders, Infosets, Process chains and made recommendations accordingly.
• Recommended performance improvement measures relevant to InfoCubes such as Compression, Statistics, Partitioning, Indexing, Aggregates and Multi Dimensional Clustering which is a unique DB2 feature.
• Proposed a data archiving plan based on data requirements for reporting and historical information. Proposed Near Line Storage System for archiving historical data.
• Proposed changes to process chain as complex, nested, and hard to administer Local chains and a Master Meta chain were used.
• Recommended functional upgrade to BI 7.0 for certain data flows to take advantage of the new functionalities like DTP and Transformation to improve load performance.
• Proposed Enterprise Data Warehouse architecture for the future state with defined layers such as IDL (Inbound Data Layer) using Write Optimized DSO’s, TDL (Transformation Data Layer), RDL (Reporting Data Layer) and ODL (Outbound Data Layer).
• Analyzed the usage of all reports in the system and recommended an admin process to clean up unused reports including user created queries.
• Analyzed the response times of reports with run times greater than the acceptable limit and recommended performance tuning measures to improve report response times.
• Documented the current state analysis of the system and recommendations for improving data load and query performance.
• Prepared technical documentation for all BW objects: InfoCubes, DSO’s, Process Chains, Multiproviders, Queries and Workbooks.
• Involved in documenting the future state architecture recommendations, strategic roadmap for functional upgrade and integration with Business Objects.
• Recommended to make necessary changes to reduce load on BI Accelerator.

Confidential,Milwaukee, WI June 2008 – Dec 2009
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 BEx Analyzer, 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

• 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, DB2 UDB V9, C++, HP Unix B.11, Sun Solaris 8.0, Windows 2000/XP/NT 4.0/98/95