PROFESSIONAL SUMMARY:

• Over 12 years of IT experience including 9 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 / noledge 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 noledge of SAP Business Warehouse on SAP HANA.

TECHNICAL SKILLS

Data-Modeling: Extensive involvement in gap analysis. Design and maintenance of InfoCubes, Multiprovider, Remote Cubes, ODS objects with consistent star schema and efficient multi-dimensional data modeling techniques. Customization of data sources in CO-PA, LIS, FI/CO and LO Cockpit to match the business requirement.

Data Extraction: Creation and customization of Info Sources, Transfer Structures, Update Rules, Start Routines, Abap programming, and Extract Structures. Scheduling and monitoring of data upload into Info Providers such as Info Objects, ODS, InfoCubes as well as PSA. Automating the data extraction using Process Chains.

Reporting: Building custom queries using Restricted and Calculated Key figures, Variables, Structures, Conditions and Exceptions. Extensive experience with Query Builder, BEx Analyzer, Universe Designer, and Webi. Worked with Info Sets and Info Set queries.

Performance Tuning: Analyzed OLAP and WHM performance using BW statistics. Improved query and load performance using Aggregates, Partitions, Indices, Packet Size, Data Selection and Data Compression.

BW on HANA: In-memory computing (Conventional Vs. In-Memory data base ), Modeling on HANA Studio, (Attribute View, Analytic view, Calculation View ), In-memory optimized DataStore object, In-memory optimized Infocube, Publishing SAP HANA model into BW, Consuming HANA models in BW

Upgrade: Post upgrade support for Upgrade from BW 3.5 to BI 7.0 and security upgrade

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

Responsibilities:

• Design Development of Supplier Count reports to halp 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. dis 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

Responsibilities:

• 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

Responsibilities:

• Analyzed MolsonCoors data model and identified new info objects dat 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

Responsibilities:

• 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

Testing and Validation Project

Responsibilities:

• 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
• 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 dat 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.0Client: World Bank, Chennai, IndiaSep 2004 - Dec 2007

SAP BI/BW Consultant

Confidential

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 World Bank 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 has 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