PROFESSIONAL SUMMARY:

• Over 14 years of IT experience including 10 years of experience in Design, Development, Implementation, project management and Production Support for Business Applications in SAP Business Intelligence/Warehouse (BI 7.X/3.X) with SAP R/3 (4.X/ECC 6.0),and Business Objects 3.X/4.0
• Extensive experience in Modeling, Data Extraction/Loading (ETL), Reporting, Portal Reports, Analysis Process Designer (APD), Web Templates, BI Admin Cockpit, Information Broadcasting
• Proficient in Business Objects(3.X and 4.0) Reporting using Web Intelligence(Webi),
• Experienced in building OLAP universes and Connections
• Involved in gathering, analysing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports .
• Knowledge on Dashboard Builder to create pie chart analytic, Bubble chart analytic, create dashboard(xcelsius), Designing Corporate Dashboard and schedule data refresh
• Experienced in creating process chains and information packages to load data to various information providers.
• Well experienced in performance tuning using Aggregates & Roll - Up, Compression of InfoCubes, Indexes, and BW Statistics.
• Custom data extraction from legacy systems using flat files.
• Sound Functional Knowledge on SAP Sales and Distribution module and IS- Retail
• Proficient in installing business contents (in BI 7.0/3.X) and enhancements of DataSources
• Build Abap extractors /Enhance extractors, start routine, end routine using Abap programming
• Expertise in designing and implementing BEx queries using Calculated Keyfigures, Restricted Key Figures, Filters, Variables, Structures, Exceptions, Conditions, and Workbooks..
• Very fluent with business process documentation, data flow diagrams and end-user training / knowledge transfer.
• Well experienced in go-live and post-production support.
• Highly experienced working with Solution Manager and Transport Management System
• Excellent Project Management skills
• Strong Communication skills, problem solving skills and ability to adapt to new technologies.
• Sound knowledge of SAP Business Warehouse on SAP HANA.

PROFESSIONAL EXPERIENCE:

Confidential, Boise, ID

BIG Data Project

• Design and Development of Usage Decision reports from SAP QM Business content datasources
• Design and Development of BW data model to extract Quantitative and Qualitative data from ECC
• Design and Development of data models to report various action and warning limits with respect to QM data
• Design and Development of custom data sources to report Material movement and Control limits data
• Built BW data model to report Batch Attributes and Batch Attribute change data
• Implemented FI GL Advanced DSO data flow solution
• Implemented Purchasing Header and Detail Advanced DSO data flow solution
• Created Calculation views for existing DSOs
• Worked on SLT replication

Confidential, Milwaukee, WI

Purchasing Procurement Project

• Design Development of Supplier Count reports to help business to evaluate the count of current active parent suppliers.
• Design and development of Good Receipt Reports to let the business analyze the Purchase Volume Analysis at Purchase order and Material level. This report will provide details at Vendor level which can be drilled down by region, company code, profit center, vendor and vendor attributes.
• Material Price Variance reports - Provide GL level details to business and improve visibility and provide the business with the analytical capabilities of the Business Warehouse tool in doing the monthly Material Price variance and Savings on Purchases
• Design and development of PO details Analysis Reports to provide business with open/close POs. details
• Design and development of Spend Reports and Payment term analysis reports
• Design and development of On time Shipment reports to enable to business to analyze shipment performance by a particular plant
• Design and development of Schedule Agreement reports to Provide detail of Service Agreements (SA’s). These will include Summary and drill down detail reports of Open and Closed SA’s

Confidential, Milwaukee, WI

Chain P&L BO reports Project

• Convert Old BO reports using BW data model to create new BO reports
• Responsible for creating Business Objects universes and reports to provide information on Chain P&L and Mix data
• Successfully migrated universes and reports from development to test to production.
• Developed Universe for STR retail authorization table
• Worked on modification of Universes
• Analyzed client requirement and prepared Dashboard specification document
• Worked on conceptual design of the Dashboard
• Developed Universe for STR retail authorization daily semantic table
• Developed webi report for Chain p&l mix report
• Developed webi report for Chain P&L Mgmt Unit and Accounts report
• Worked on Universe creation on Commercial P&L infocubes
• Worked on Universe creation on finance Bex queries

Confidential, Milwaukee, WI

MCBC Migration Project

• Analyzed MolsonCoors data model and identified new info objects that need to be created.
• Developed new attributes and added to the existing infoobjects in MillerCoors system
• Designed and implemented data flow for Shipment Number for freight cost. Developed routines for filters
• Implemented data flow for Transportation Volume Header 2lis 08TRTK, Activated business content and developed routine for custom date (Goods Issue Date)
• Implemented data flow for Transportation Volume Item. Installed Business content 2lis 08TRTLP
• Implemented Time Entry reports using business content
• Designed - Planned shipments multiprovider for reporting
• Implemented data flow for Carrier performance in Transportation
• Migrated Carrier performance reports and Yard reports
• Built DSO objects, Info cubes, Info sets and BEx reporting using SAP BW 7.0.
• Performed extraction, transformation, and loading of data (ETL) by preparing SAP R/3 for SAP BW and defining the loading strategies, initial and delta data loads using PSA (TRFCs), loading data via flat files and staging BAPI, and scheduling and monitoring data loads.
• Translate the reporting requirements into a documented technical design for SAP BW
• Created Multi-provider and Info Sets and performed reporting on them.
• Performed day-to-day responsibilities including analysis of data requirements and translation of these requirements into dimensional data models, with an emphasis on actual implementation in BW.
• Developed custom Info Cubes as per design specifications in order to meet the business user requirements.
• Designed and optimized the queries (top customers, monthly incoming orders and revenues, product analysis, and returns) and analyzed the data using BEx Analyzer.
• Customized standard report templates to meet client requirements. Worked with Template Objects / Web Items (tables, charts, Role menu, Query view Selection, etc.)
• Loaded master data and transaction data into the warehouse via the DW workbench. Test the solution by loading data, verifying mapping, verifying data values, reconciliation to the source, proper aggregation of key figures, etc.
• Reported and analyzed data using SAP BW Business Explorer, defined queries, and delivered data from various sources in an organized fashion using BEx Browser.

Environment: SAP BI 7.0, BW 3.5, R3 4.7, ECC 6.0

Confidential, Milwaukee, WI

Edison HR Project

• Standard Business content InfoObjects were used for design of BW HCM Master Data (OM & PA) as per requirement
• Enhanced 0EMPLOYEE, 0HRPOSITION and 0ORGUNIT InfoObjects
• Infoobjects like 0EMPLOYEE, 0ORGUNIT, 0HRPOSITION, 0PERSON, 0SALARYLV, 0EMPLSTATUS, 0JOB, 0PERS AREA were installed from Business content
• Created custom master data infoobjects
• All Personnel Administration (PA) Custom InfoObjects were created under the InfoArea Personnel Administration’ (0PAPA)
• Assignment of InfoObjects to Basic Master Data Characteristics as Attributes.
• Enhanced 0EMPLOYEE ATTR to populate badge number from PA0040 table
• Enhanced 0HRPOSITION ATTR to populate job from the table hrp1222.
• Enhanced 0HRPOSITON ATTR to populate PA ( Personnel Area) and PSA (Personnel Subarea )
• Created infosources and assignment of datasources for Master data infoobjects
• Developed Team data, Seniority, Contact info reports on 0EMPLOYEE
• Developed data flow for Head count report and Org Structure report

Confidential, Milwaukee, WI

STOUT Migration - Testing and Validation Project

• Create test scenarios for Interface validations
• Tested East ECC with BW Production system data
• Tested West ECC with BW Production System data
• Validated Finance, Shipping, billing data in BEx reports
• Created test scripts
• Tested portal reports
• Majority of the work involves testing Backend and Front end objects and Interfaces and Bex reports and all data loads
• Reported and analyzed data using SAP BW Business Explorer, defined queries, and delivered data from various sources in an organized fashion using BEx Query Designer.
• Created and maintained queries in BEx Query Designer and reports in portal.
• Involved in understanding the business process, studying the application and interacting with developers to create test cases and scripts using Mercury Quality Center.
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Tested company specific custom transaction codes
• Tested back-end flow, info providers, open-hub data in SAP front-end tool.
• Tested user exits to support clients’ specific business process.
• Tested front-end portal reports with Multi provider.
• Involved in Unit testing, integration testing, regression testing and UAT testing.
• Reported bugs through Mercury Quality Center and interacted with developers to assist in resolving the issues.
• Conducted Defect Review meetings with analysts, users and developers to discuss defect reports.
• Handling onsite and offshore testing team.
• Developed Test Matrix to report testing status on a daily basis.
• Responsible for reporting the status to the project manager on weekly basis.
• Tested data that flows to other systems
• Execute/Tested all the process chains
• Tested the transport path from Dev/QA/Prod Support/Production Systems

Confidential, Milwaukee, WI

Sr.SAP BI/BW Lead

Responsibilities:

• Responsible for smooth transition of migrated projects to BW production system.
• Capacity Management - Review space growth of BW production and non-production environment based on Early Watch Report and recommended and completed process improvements.
• Successful completion of year end processing
• Client interaction to gather requirement and deliver quality work.
• Responsible for successful completion of all the BW data updates for business
• Executed and completed all the upgrade/patch related testing.
• Incident management and change request management.
• Coordination and execution of critical finance closing activities.
• Debugging and fixing data load issues, Delta Queue Management.
• Enhanced standard extractors like FI Gl and CO order.
• Worked extensively on Bex reporting.

Confidential, Atlanta, GA

SAP BI/BW Consultant

Responsibilities:

• Responsible to gather business requirements from the business users
• Worked on Logistics Cockpit and extracted data with V3 updates. The data included MM, PP & CO Extractions.
• Taken Care of the Pre & Post Cutover activities for the data of MM & PP.
• Involved in changing the Existing data model of an Info Cube by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources from SAP R/3.
• Involved in the Basis (performance, clearing the tRFC’s) and Security (provided the role name to assign to the users, checking the user authorizations and roles) issues.
• Involved in taking the responsibility of the development till the go-live of the reports.
• 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.
• Issue resolution associated with BI Accelerator and built indices
• Involved in creating Start Routines & End Routines(Abap) as per the Business requirement.
• Analyzed, Designed, development, coding and implemented multiple DSO, BW infocubes and multi-providers
• Designed production process for Archiving
• Successful completion of regression test for BW support pack 15
• Interacted with SAP to resolve problems while applying BW support pack 15
• Designed and automated data loads using process chains
• Performance tuning of the production environment.

Environment: SAP BI 7.0, BW 3.5, ECC 6.0

Confidential

SAP BI/BW Consultant

Responsibilities:

• Responsible for all the Production Support Activities performed at Offshore and meeting the SLA.
• Successfully completed a SIX SIGMA project - “Data Load Process Enhancement in Confidential SAP Business Warehouse Project”
• Successful implementation of Six Sigma methodology in Weekly Data Load to ensure error free load
• Performed the transformation and loading process from OLTP to SAP BW system.
• Replicated source system in BW to made available SAP R/3 data source in BW system. Designed and developed ODS objects to carry out a precise analysis of data.
• Used start routines, routines for transfer and update rules using ABAP.
• Extended transaction data Sources by appending new data elements using enhancement component RSAP0001 and used the function exit EXIT SAPLRSAP 001.
• Designed and developed info cubes, Info Sources and loaded data from R/3to BW
• Designed and Automated the full Weekly Data load using a single Parent Process chain
• Implemented the process of using check list to review the Daily, Weekly and Monthly Data Loads
• Designed and Automated the Monthly Data Load using Process chains to meet the SLA
• After analyzing the dependencies of all the master data and transaction data, all the manual loads have been automated (to avoid human errors) and optimized which resulted in good quality of data
• Implemented new validation process by having validation queries for critical data loads
• Successfully Completed Regression Tests for various patches applied in BW side.
• Successfully Completed Regression Tests for R/3 4.7 Enterprise upgrade
• Successfully Completed Regression Testes for 3.5 Upgrade for all the servers
• Successfully Completed Regression Testes for BI 7.0 Upgrade for all the servers in a short duration of time
• Successfully Completed Year End Processing Loads for three consecutive Years (FY2005,FY2006 and FY2007)
• Designed and Implemented PSA cleanups for all the production process chains to avoid space issues
• Designed a document to capture all the data load issues in Production
• Responsible for creating Jira tickets and provide solutions related to production support issues
• Reduced the Induction time of new joiners in to Production support team
• Responsible lead member of the production support Interview panel
• Create/Enhance and maintain all the Data Load documents

Environment: SAP BW 3.X, SAP R/3 4.6C, BEx Analyzer/Browser