PROFESSIONAL SUMMARY:

• Over 11 years of experience in IT and SAP BW/BI as a Techno - Functional Consultant and Analyst with 4 full life cycle implementations and Post Production experience in design, development and implementation of SAP BW and SAP Business Objects application.
• Involved as a key member of project teams through all phases of Implementation - Project Preparation, Blueprint, Realization, Go-live, and Post implementation support of SAP BW projects.,
• Working knowledge of SAP reporting from ECC modules such as FI-CO, MM, SD, PM, and HR.
• Experienced in multidimensional data modelling
• Experience in both BW 3.5, BI 7.0 & 7.3 data modeling.
• In-depth working Knowledge of integrating SAP NetWeaver BW on SAP HANA in combination with SAP Business Objects BI 4.x
• Expertise in development and maintenance of both standard and custom data models such as Info Cubes, DSO Objects and Multi-providers.
• Scheduling of batch job and load monitoring using process chains.
• Experienced in SAP BW front-end BEx query components such as calculated key figures, restricted key figures, Structures, Formulas, Variables, Cell definition, Conditions and Exceptions.
• Experienced in Performance tuning techniques using aggregates, compression and indexes.
• Experienced in design and development of BOBI reports using SAP Business Object Toolsets (Universe designer, IDT, Webi, Xcelsius & Crystal reports for Enterpise)
• Prepared ad-hoc end user reports and analysis using WEBI Intelligence with SAP BW queries as datasource
• Experience using data visualization tools such as SAP Lumira, Dashboard 4.0, Tableau and Design Studio
• Working knowledge of both relational and non-relational database design concepts
• Working Knowledge of SAP Business Objects Analysis for Office and OLAP
• Capable of working independently as well as in a team.
• A bility to engage with multiple development projects concurrently and working to tight deadlines
• Highly motivated, eager to learn new concepts/skills.

TECHNICAL SKILLS:

• SAP BW 3.5
• BI 7.0 & BI 7.3 SAP HANA SAP R/3 4.6 4.7
• ECC 6.0; SAP LUMIRA
• DESIGN STUDIO 1.3
• TABLEAU 8.4 and 9.0
• SQL 2005. JD Edwards
• SAP Business Objects XI R2
• SAP BOBI 4.0
• Livelink
• Solution Manager

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

SAP Lumira Dashboard Developer

Respo nsibilities:

• Liaised with super users to gather business requirements for reporting purposes
• Enhanced SAP BW datasources to include newly required fields
• Developed SAP BW BEx queries as data sources to SAP Lumira
• Developed dashboard reports using SAP Lumira to include all the required KPI’s
• Created a Storyboard using Geo Bubble Chart, Column chart and Line Chart to depict trend analysis in Sales by region, Top products and Monthly Sales to track the sales data of the parent company and its local markets.
• Created Analytic views and Calculation views in SAP HANA
• Performed data replication into SAP HANA tables
• Created Time hierarchy, Calculated dimensions and Filters in SAP Lumira

Environment: SAP BW 7.4, SAP ECC 6.0, SAP LUMIRA 1.29, SQL 2008, SAP HANA 1.0 SP7

Confidential, Stamford, CT

SAP BI/BW - BOBJ Lead

Responsibilities:

• Translates Business needs to requirements by conducting requirement gathering sessions with end users
• Responsible for SAP BW - BOBJ integration by building universe on top of BW info providers using BICS connection
• Developed several webi reports based on functional requirement
• Developed BOBJ reports using SAP BW as datasource.
• Created BOBJ universes using Information Design Tool (IDT).
• Developed Insurance treaty and Claims analysis workbook using MS Analysis for Office
• Developed Executive Level Tableau Dashboard visualization for Senior Management
• Developed Crystal Reports using Crystal Reports for Enterprise 4.1
• Performed data reconciliation and resolved variance issues between ECC and BW
• Developed webi intelligence reports as per clients’ request for insurance reporting requirements.
• Provided level 1 production support role for both SAP BW and SAP BOBJ related issues.

Environment: SAP BW 7.3 SP8, ECC 6.0, SAP BOBJ 4.1, IDT, Tableau 9.0

Confidential, Enon, OH

SAP BW - BOBJ Lead

Responsibilities:

• Participated in meetings with users to determine requirements and scope.
• Scheduled and monitored data loads via Process chains on daily basis
• Developed Sales analysis workbook for Speedway gas stations using SAP Business Objects Analysis, edition for Microsoft Office.
• Created various information models in SAP HANA such as Attribute view on master data table and Calculation view to determine net profit on Sales data
• Performed SAP HANA Data Provisioning using SAP LT Replication Server (SLT)
• Developed data modelling in SAP HANA studio and consuming the views in SAP BW
• Created Ad hoc query and reports on refinery maintenance costs with SAP Business Objects Analysis, edition for OLAP
• Developed Highly formatted custom reports using Crystal reports for Enterprise.
• Created Dashboards reports with Tableau based on SAP BW data
• Created a dashboard report to display sales analysis using geographic graph and pie chart to depict regions with high volume of sales.

Environment: SAP BW 7.4, ECC 6.0, SAP BOBJ 4.0. SAP LUMIRA v1.29, TABLEAU v1.8

Confidential, Philadelphia, PA

SAP BW on HANA Consultant

Responsibilities:

• Held meeting with end user to gathered business requirements.
• Assisted in data modelling in SAP HANA studio and consuming the views in SAP BW
• Created Attribute view on master data table and Calculation view to determine net profit on Sales data as part of modelling scenarios in HANA studio
• Imported Sales Data (flat file) into HANA table
• Responsible for enhancement of SAP BW objects based on new requirements
• Imported SAP BW Infoproviders into SAP HANA Studio as analytical model
• Created Analytic View (Sales Analytic View) based on SAP HANA table
• Publish SAP HANA Analytic Views to SAP BW as Transient Providers
• Created a Composite Provider based on Transient Provider and DSO
• Developed BEx Query and Workbooks on top of Composite Provider
• Created an Analytic Privilege based on Analytic View
• Created dashboard reports using Design Studio to display the total sales for the previous year based on regions
• Developed a dashboard report which outlines the sales for each product group for each region to enable top level management identify any sales trend
• Created a Storyboard using Geo Bubble Chart, Column chart and Line Chart to depict trend analysis in Sales by region, Sales by products and The total monthly Sales

Environment: SAP BW 7.3, SAP HANA 1.0, SP3. ECC 6.0, DESIGN STUDIO v1.4

Confidential, Dallas, TX

SAP BW - BOBJ Lead

Responsibilities:

• Handled SAP post go live support ativities such as break/fix issues, change requests and enhancements in SAP BW.
• Performed data reconciliation and resolved variance issues between ECC and BI.
• Revised, modified and enhanced profitability (CO-PA) reports such as Sales Margin Report, Revenue Detail Report, Capital Expenditure Report, Profit & Losss Conventional Report and Profit & Loss Perfomance Report based on new change request.
• Implemented various performance tuning techniques such as Infocube compression, Aggregates and Index to improve BW report performance.
• Responsible for data integration between SAP BW and SAP Business Objects
• Developed Crystal report against SAP BW query
• Developed highly formatted Crystal Reports using several KPI’s to analyze trends in the performance of each division.
• Created Excel-based interactive visual analytics with dynamic charts displaying the total sales for the previous year based on regions, divisions and net sales. The dashboard included all the required KPI’s and metrics to analyze trends in the performance of each division.
• Developed ad hoc/interactive webi intelligence reports as per clients’ request
• Used SAP BW info cube to create reports via SAP Business Objects Analysis Edition for OLAP.

Environment: SAP NETWEAVER BW 7.0, ECC 6.0, SAP BOBJ 4.0, Tableau 8.1

Confidential, NA

SAP BI/BW Lead

Responsibilities:

• Resolved BW ticket issues raised in Solution Manager.
• Provided level 1 support role in resolving production related issues to Business users.
• Monitored data load via Process Chain on a daily basis.
• Troubleshoot and subsequently fixed failed data load as part of production support activity.
• Applied various performance tuning techniques to BW front end.
• Assisted end users to troubleshoot data doubling issues in BW Reports.
• Customized new General Ledger data sources within SAP R/3 Financials (0FI GL 14) and extracted same to BW reports such as Line Items detailed report and Trial Balance report.
• Worked on Open Hub to extract data from ODS, and transfer the data to external data marts using Open Hub Service.
• Performed a full-fledged analysis to assess the performance of the BW server and proposed recommendations regarding performance improvement techniques.
• Recommended and applied database performance issues as related to BW.
• Liaised with offshore counterparts to expedite resolution of BW issues with high priority.

Environment: SAP BW 7.3, ECC 6.0, SAP Solution Manager.

Confidential, W. Virginia

SAP BW Lead

Responsibilities:

• SAP BI Project Lead tasked with overseeing successful migration of all BW 3.5 objects to SAP BI Net weaver 7. X during the upgrade.
• Assigned responsibilities to individual team members during project implementation
• Responsible for data source migration and reports migration.
• Worked closely with client resource to plan the upgrade activities.
• Liaised with the Basis team during BW System Copy/Refresh activities.
• Performed all pre and post Upgrade activities before and after the upgrade using SAP recommended Best Practices
• Activated various BW objects such as InfoObjects, Info cubes, DSO, Multiprovider, Update Rules and Transfer Rules before and after the upgrade.
• Developed Process Chains and monitored the ETL process.
• Transported all objects from development environment to QA for testing.
• Performed re-initialization of master data and transaction data Loads after system refresh.
• Scheduled the monthly BW Extraction of FICA open and cleared Items from ECC to BI based on old data flow in BW 3.x format.
• Performed the cutover tasks in QA and production.
• Conducted an end user training to familiarize the client with the new features of SAP Netweaver Business Intelligence 7.0.

Environment: SAP BW 3.5, SAP Net weaver BI 7.0, ECC 6.0

Confidential, Houston, TX

SAP BI/BW DEVELOPER

Responsibilities:

• Worked on Profit Center Accounting & Cost Center Accounting areas in the Controlling Module with emphasis on Financial Management and Controlling reports
• Used BEx Query Designer/Analyzer to developed report in controlling areas such as Overhead Cost Controlling, Product Cost Controlling and Profitability Analysis.
• Created various manufacturing reports such as Variable manufacturing report, Variable cost per unit report, and Plant variance report to evaluate Manufacturing segments.
• Used Combination of Variable, Filters, Conditions, Exceptions, Calculated Key Figures, and Restricted Key Figures to develop workbooks to analyze Plan Amount vs. Actual Amount, Plan Quantity vs. Actual Quantity of Cost Centers
• Modified existing BW reports based on new user request
• Created aggregates on hierarchy to improve query performance
• Enhanced existing multiprovider to meet new reporting demand
• Used BEx Query designer to developed query to calculate Foreign Exchange Impact.

Environment: SAP BW 7.0, ECC 6.0

Confidential, Rosemead, CA

SAP BI - BOBJ Lead

Responsibilities:

• Interacted with the different Business Users during requirement gathering.
• Analyzed the end user requirement with the existing system generated documents and performed GAP analysis.
• Worked on integration of SAP BW with BOBJ (Business Objects) for the purpose of developing various Business Objects Reports using SAP BW as the data source.
• Developed several webi reports based on functional requirement.
• Extracted activity data maintenance notifications into the notification infocube and created report based on the infocube in Plant Maintenance (SAP PM) module.
• Developed several Business Objects reports and used same to perform knowledge transfer to end users.
• Build a Business Objects OLAP universe on top of BI Query.
• Created dashboards with Xcelsius 2008 designer.
• Created Excel-based interactive visual analytics, dynamic charts and groups as part of business presentations using Crystal Xcelsius
• Created highly formatted Crystal report for management to displayed Asset Maintenance activity for the previous year in review
• Mentor the Business User to effectively use Business Object tool to create their own ad-hoc reports.

Environment: SAP BI 7.0, ECC 6.0 & Business Objects Enterprise XI Release 3.0, Crystal Reports 2008, Xcelsius 2008, Live Office, Query-as-a-Web Service

Confidential, Houston, TX

SAP BW Architect

Responsibilities:

• Participated in meetings with end-users across the globe to determine the requirements and scope of various financial reports to be developed.
• Created test cases during SIT phase and conducted UAT testing with end users
• Worked on various data sources in the SAP R/3 Financials such as 0FI GL 4 (General Ledger: Line Item data source), 0FI GL 1, (General Ledger: Transaction figures) 0FI AR 5(Account Receivable: Payment History), 0FI AP 4 ( Accounts Payable: Line Items)
• Loaded transaction data and initialized deltas for FI - GL Line Items
• Design & developed several BEX Query reports such as AP/AR Operational reports, Monthly Payment Discount Statistics, Payment with Duplicate Amounts and Invoice dates, Vendor Open and Cleared Items report and Customer Open & Cleared Items report.
• Worked on BEx Analyzer to developed financial reports such as General ledger Line Item details report and Trial Balance report
• Used BEx analyzer to develop and facilitate data analysis using Filters, Navigational attributes, Calculated and Restricted Key Figures
• Worked on Query Designer to create Queries in calculating DPO (Days Payment Outstanding & DSO (Days Sales Outstanding) using Restricted Key Figures, Calculated Key Figures and Customer Exit Variables.
• Translated the BW Reports to Cyrillic texts (Russian language) for Russian end users.

Environment: SAP BW 3.5; SAP BI 7.0, SAP R/3 4.7, ECC 6.0, HP QC.

Confidential, Houston, TX

SAP BW - BOBJ Lead Developer

Responsibilities:

• Loaded master and transactional data from SAP R/3 and Flat Files.
• Performed database modeling using entity relationship model
• Data load Monitoring of BW jobs.
• Building a Sales Dashboard Using SAP Xcelsius
• Developed webi reports for management
• SAP BW data source enhancements.
• Involved in System Integration Testing (SIT) and User Acceptance Testing (UAT)
• Created Multi providers to enhance the reporting base
• Created Infospokes to extract data from Infocubes, to external datamarts using Open Hub Service.
• Extracted and loaded data from SAP R/3 into Sales Overview InfoCube ( 0SD C03) using Info source 2LIS 11 VAHDR- Sales Document Header data, Info source 2LIS 12 VCHDR-Delivery header data and 2LIS 13 VDHDR - Billing Document Item data
• Developed Process Chain to developed data loading strategies for master data and transactional data
• Created DSO for drilldown reporting for Asia Pacific Regional user(APR)on Global operations for Hydrocarbon Management and Lubes Supply Chain reports
• Extensively worked with BEx to design reports and created queries using variables, conditions, filters, restricted and calculated key figures, formulas.
• Worked on performance tuning activities like aggregates, indexing, Info Cube Compression and query monitoring.
• Loaded data from JD Edwards

Environment: SAP BW 3.5, SAP BI 7.0, SAP R/3 4.6, ECC 6.0, SAP Business Objects XI. R3, JD Edwards.

Confidential, Houston, TX

SAP BW trainee

• Posting of journal entries
• Accounts Payable/Receivable.
• Invoiced; debited/credited accounts.
• Bank Reconciliation
• Assisting with month end financial statement review
• Maintenance of Petty cash treasury account