SUMMARY

• Over 12 years of experience in IT.
• Experienced as a SAP BI/BW and SAP BOBJ consultant with 4 full life cycle implementations and Post Production experience in design, development and implementation of SAP BW and SAP Business Objects application.
• In - depth working Knowledge of integrating SAP NetWeaver BW on SAP HANA in combination with SAP Business Objects BI 4.x
• Involved as a key member of project teams through all phases of Implementation - Project Preparation, Blueprint, Realization, Go-live, and Post implementation support.
• Working knowledge of SAP reporting from ECC modules such as FI-CO, IM-MM, SD, PM, HR and SRM and SCM.
• Experienced in multidimensional data modelling and working knowledge of both relational and non-relational database design concepts
• Experience in both BW 3.5 and BI 7.x data modeling.
• Expertise in development and maintenance of both standard and custom BW data models.
• Scheduling of batch job and load monitoring using process chains during production support.
• Experienced in universe design using IDT and UDT.
• Report development experience using SAP BW Bex Query Designer, BW BEx analyzer, SAP Business Objects WEBI, Crystal Reports, Analysis for Office and Analysis for Office OLAP
• Experience using data visualization tools such as SAP Lumira, Design Studio and Tableau
• Experienced in Performance tuning techniques using aggregates, compression, Query read modes, Indexes and logical Partitioning.
• Working Knowledge of SAP Business Objects Analysis for Office and OLAP
• Capable of working independentlyas well as in a team.
• Ability 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, SAP BI 7.x 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 and SQL 2008SAP Business Objects XI R3, SAP BOBI 4.0, BOBI 4.1, SAP Solution Manager

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SAP BI-BOBJ

Responsibilities:

• Developed SAP BW Infocube for Sales Overview reporting
• Developed data loading strategies (ETL) such as Infopackage, Transformation and DTP to load data from ECC (LO Cockpit) to Sales Overview cube in BW
• Build a Multiprovider using a combination of DSO and Infocube
• Created CKF, RKF, Variables and Structures in BEx Query designer based on report requirements
• Developed Web Intelligence reports (WEBI) using SAP BW BEx Query as datasource
• Used a combination of variables, Functions, Formulas, Calculation Contexts, Filters, Input Control, Merged dimension and drill - down to enrich the design of custom webi report
• Build and formatted webi report by applying Breaks, Sections, Query Filters, Ranking, Sorting, Charts and Conditional formatting (Alerts)
• Responsible for report bursting (Scheduling and Publication)

Environment: SAP BW 7.4, SAP ECC SAP BOBI 4.2, SAP LUMIRA

Confidential, Sacramento, CA

SAP BW/HANA - BOBJ Consultant

Responsibilities:

• Worked on SAP BW on HANA - BOBJ integration.
• Worked on financial transaction data of Contract Accounts Receivable and Payable for the Public Sector within PS-CD (Public Sector - Collection and Disbursements) module of SAP - ECC.
• Worked on HANA integration with SAP BW 7.4
• Design & Creation of HANA Attributes views, Analytic views and Calculation views
• Creation of Composite Providers to link the HANA Models, Multi-Providers in BW.
• Mapping of HANA View fields from the Calculation Views into the specific fields in BW system
• Created report to show the Schedule of Proportionate Share for Employers of CalSTRS.
• This report is to assist employers in meeting the requirements of GASB 74.

Environment: SAP BW 7.4, SAP ECC 6.0, SAP HANA 1.0 SPK9 SAP BOBI 4.2 (WEBI, CRYSTAL REPORTS)

Confidential, Portland, OR

SAP Lumira Dashboard Developer

Responsibilities:

• Used HANA views (Calculated views) as source data for Lumira Reports and Dashboards
• Worked with private views, query views and reuse views in HANA Live Browser
• Activated HANA Live content within HANA Live Browser
• 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, SPS9. SAP LUMIRA 1.29, SQL 2008, SAP HANA Live 1.0 SP8.

Confidential, Stamford, CT

SAP BI/BW - BOBJ Lead

Responsibilities:

• Translates Business needs to requirements by conducting requirement gathering sessions with end users
• Developed several webi reports based on functional requirement
• Developed BOBJ reports using SAP BW Queryas datasource.
• Created BOBJ universes using Information Design Tool (IDT).
• Developed Insurance treaty and Claims analysis workbook using SAP Business Objects 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/HAHA - BOBJ Consultant

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 for Office
• Building HANA Views (Attribute, Analytical & Calculation Views).
• Integrated SAP HANA with BOBI reporting tools.
• 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
• 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 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.
• Involved in all post and pre migration checks during during system upgrade to HANA
• InfoCube conversion to HANA Optimized Infocubes using RSMIGRHANADB transaction code
• Performed SAP HANA Data Provisioning using SAP LT Replication Server (SLT)
• Created Attribute view on master data table and Calculation view to determine net profit on Sales data.
• Created Analytic View (Sales Analytic View) based on SAP HANA table
• Created Analytic Priviledges for HANA security roles
• 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 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, SP7. ECC 6.0, DESIGN STUDIO v1.4

Confidential, Dallas, TX

SAP BI Lead

Responsibilities:

• Handled SAP post go live support ativities such as break/fix issues, change requests and enhancements in SAP BW.
• 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.
• Activated and installed Business Content datasources 2LIS 03 BF (Material movement from Inventory management), 2LIS 03 UM - Material Revaluations and 2LIS 03 BX (Stock Initialization for Inventory Management) to load data into Material movements infocube 0IC C03. Created BEx query based on the infocube to report on Inventory turnover and analyze warehouse stock.
• Implemented various performance tuning techniques such as Infocube compression, Aggregates and Index to improve BW report performance.
• 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 interactive visual analytics reports using Tableau to display 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.

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

Confidential, NA. Charlotte, N.C.

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.
• Worked on data extraction from SAP BW infoproviders 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 relates to BW.
• Worked on onshore-offshore 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, Newport News, 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.
• 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 BW based on old data flow in BW 3.x format.
• 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 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.
• Developed 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 change 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:

• Responsible for requirement gathering to generate business blueprint
• 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.
• Developed SAP BW Bex query and used same to feed data to Crystal Report
• 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.
• Created dashboards with Xcelsius 2008 dashboard designer.
• Created highly formatted Crystal report for management to displayed Asset Maintenance activity for the previous year in review

Environment: SAP BI 7.0, ECC 6.0 & Business Objects Enterprise XI Release 3.0, Crystal Reports 2008, Xcelsius 2008.

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 and Calculated Key Figures.
• 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 BI/BW Consultant

Responsibilities:

• Loaded master and transactional data from SAP R/3 and Flat Files.
• Involved in System Integration Testing (SIT) and User Acceptance Testing (UAT)
• Created Infospokes to extract data from Infocubes to external data mart 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
• Used the standard SAP extractor 0HR PY 1(Payroll Data - Transaction data) to extract, transform and load data to the Payroll Data infocube 0PY C02.
• Created a BEx Analyzer report to display all wage types and the cumulated payroll results for each month.
• Activated and installed InfoCube (0PA C01) - Headcount and Personnel Actions.
• Used datasource 0HR PA PA 1 (Headcount - Transaction data) and 0HR PA 1( Personnel Actions- transaction data) to load data into the cube.
• Generated a report displaying various employee's data for a given month
• 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 and formulas.
• Worked on performance tuning activities like aggregates, indexing, Info Cube Compression and query monitoring.

Environment: SAP BW 3.5, SAP BI 7.0, SAP R/3 4.6, ECC 6.0.