Sap Data

AMIR INANLOU

SAP HANA/SAP BI Consultant

*******@*****.*** . 425-***-****

SUMMARY

I am a certified and highly skilled SAP HANA, SAP BW, SAP BPC and Business Objects consultant with more than 10 years of experience in consulting. I have successfully implemented SAP projects with various clients in Canada, United States and Asia-Pacific countries. I have an extensive experience in SAP HANA Data Modeling, Data Services Batch Job processing, BW Bex Queries, Universe Design, Interactive Reports and Dashboards. I have a comprehensive understanding of SAP ERP Modules and the underlying business processes that complement my technical skills. I will bring a diverse range of qualities and experience that I have gained over the last 10 years of my career in variety of industry sectors.

TECHNICAL SKILLS

SAP:

●Hands on experience with SAP BI 4.x (Business Objects), SAP Business Objects Design Studio 1.6 and SAP Lumira

●Completed SAP MM Boot Camp

●Experienced and certified in SAP HANA Data Modeling (Attribute, Analytic, Calculation views and Store Procedures)

●Knowledge of ERP Profitability Analysis (CO-PA)

●Strong knowledge of Business-Objects Installation (XI R1, XI R2, XI 3.x, BI 4.x ), Architecture, Sizing and Scaling on Windows operating systems

●Working experience with BI Mobile 4.x (Play-Book 2.0, iPad)

●Hands on experience with BW 7.x (Query Design and BW Bex Analyzer)

●Trained on SAP BPC 7.x & 10 (Business Planning Consolidation)

●Certified in Solution Manager 7.0

●Strong knowledge and experience with Data Services 3.2 & 4.0

●Expertise in Data Modeling using Information Design Tool (SAP BI 4.x)/Universe Designer (XI R1, XI R2 and XI 3.x)

●Expertise in Web Intelligence (XI R1, XI R2, XI 3.x, BI 4.x) Reporting Tool, Crystal Report (XI R1, XI R2, 2008 and 2011), Business-Objects Advance Analysis (XI 3.x, BI 4.0) and MS Advance Analysis (1.x and 2.0 )

●Hands on experience with Xcelsius (4.5, 2008), Business-Objects Explorer (XI 3.x and BI 4.x) and Voyager (XI R2 and XI 3.x)

IBM/MS/Oracle:

●Strong knowledge of IBM Cognos 7, Reporting Services and Hyperion

Database and Data Warehouse:

●SAP HANA SPS 10 (In-memory Computing, New-DB), SAP BW

●Oracle, DB2, SQL Server (2005 and 2008) and Access

●Database and Data Warehouse Concepts (Star Schema, SAP BW and OLAP Technologies)

Query Languages:

HANA, MDX, PL/SQL, T-SQL

PROFESSIONAL EXPERIENCE

Industry: IT COMPANY – Seattle, WA USA

Project Scope: Financial Reporting

Role: Sr. CFS Finance BI Consultant Duration: MAY 2019 – SEPT 2020

Responsibilities:

Extracted data out of ERP system and created SAP BPC Dimensions (ACCOUNT, ACCOUNT_COGS, ACCOUNT_EXP, AUDITRAIL, CHANNEL, CUSTOMER, GEOGRAPHY, INPUTCURRENCY, PRODUCT…) and Models (EXPNSE, COGS and AMAGRIN) for propose of repotting with SAP BPC tool and SAP EPM. Revenue and Budget forecast and reporting are done by extracting ERP data and combining it with data input from partner in Plancast. After adding require business rule and calculation in Alfred, The data is send to MS Sales Cube for Revenue forecast and Reporting while the same data is also send to Mercury for Budgeting.

Achievements:

●Analyzing and extract and load ERP Data (FICO) to BW (BPC), Plancast

●Combine ERP Data and Plancast data (data entered by partners), Add business rule and require calculation to MS Sales for Revenue purpose and Mercury for Budgeting

●Used SAP BPC model Expense, COGS and AMARGIN for reporting purpose using EPM

●Used MS Sales and Mercury Cubes for purpose forecasting and reporting Using Nexus reporting technology

Industry: IT Company (Applied Big Data cloud technology) – Vancouver, BC Canada

Project Scope: HR Solution on Cloud

Role: Sr. Business Intelligence Analyst Duration: Dec 2017 – APRL 2019

Responsibilities:

Analysing Client’s Business Processes, Business Rules by conducting Data Discovery call. Gathered Requirement and Mapping clients’ data to HR Modules (WFA, WFP, Talent Acquisition, Talent Management and Learning) on cloud. Extracted, Transformed and Load client’s data through in house developed ETL tool (ESL & DLD). Used a semi SCALA language which is a Domain Specific Language (DSL) to create custom metrics and applied refine Business Rules to extract maximum analytical capabilities and provide a generic version of workforce analytic.

Achievements:

●Analyzing and extracting Business Processes and Business Rules through Data Discovery Call

●Gathered requirements by conducting Data Dictionary calls.

●Mapping and Loading clients’ data to HR Modules (WFA, WFP, TM, TA and Learning)

●Creating Custom Metrics by applying refine Business Rules

●Create routine Load

●Troubleshooting Application

●Providing training to clients

●Creating and Managing JRA tickets

●SuccessFactors & Workday HCM

Industry: Consulting Company – Seattle, WA USA

Project Scope: Financial Reporting

Role: SAP S/4 HANA & SAP BPC 10.0 Modeller Duration: Oct 2016 – May 2017

Responsibilities:

Analyzed Business processes and gathered requirements. Created and optimized views (Analytics and Calculation) & BW (Info provider and Multi Provider), reports and dashboards using SAP HANA, Tableau, SAP Business Objects Design Studio, Web Intelligence and Lumira.

Achievements:

●Gathered and analyzed requirements for new dashboards and reports

●SAP S/4 HANA (Views)

●SAP BW /4 HANA

●SAP BPC Model

●Using SAP BI 4.1(Webi, Design Studio and Lumira) as well as Tableau

Industry: Retail – San Francisco, CA

Project Scope: Financial Reporting – Retail

Role: SAP S/4 HANA Modeller, BW Bex Query and Report Designer Duration: Feb 2016 – Sept 2016

Responsibilities:

The purpose of this project was to extract data out of legacy system DCMS and Transform base on well defined business rule. Map and Load it into ECC. Then, Create Info objects, Info Provider, Multi Provider and Bex query to report on finical health of the company. SAP BI 4.2 Web Intelligence, AFO, EPM and Bex analysis used for reporting.

Achievements:

●Gathered, analyzed business processes and developed requirements for migration of data from legacy system DCMS into ECC

●Extract and transformed data using business rules.

●SAP BW

●SAP BPC Model

●Map and load data using SAP PI

●Created Info Objects and Info Provider and Bex Query

●Developed Financial reports using Bex Analyzer, AFO, EPM and Web Intelligence

Industry: Consulting Services – Harwich, MA

Project Scope: SAP HANA Modeller

Role: SAP HANA Modeller/SAP Modules Duration: Mar 2015 – Sept 2015

Responsibilities:

The purpose of this project was to gather and analyze business processes and rules. Develop requirements document for reporting on different process area (Procurement to Pay, Sales to Procurement, Order to Cash, Master Recipes, Equipment Overview, Pricing). To do so, data and metadata had to be transported from ERP and loaded into SAP HANA using SLT. SAP HANA Live for SAP ERP (Predefined Calculation views) was used to create Calculation views for different process areas (Process Order, Master Receipts, Material Contract, Service Agreement). Universes were built for creation of Web Intelligence report and dashboards.

Achievements:

●Gathered, analyzed and developed requirements for different process areas (PTP) in ERP

●Configured SLT for replicated (using Transport and SLT) ERP data and metadata into SAP HANA

●Used SAP HANA Live for SAP ERP to create Calculation Views

●Created Universe using Information Design Tool

●Created reports and dashboard using Web Intelligence and SAP Business Objects Design Studio 1.6

Industry: Global Transport Services - Singapore, Singapore

Project Scope: Supply Chain Management – EPM

Role: SAP BPC on HANA/ Report Developer Duration: Sept 2013 – Nov 2014

Responsibilities:

For planning, budgeting, forecasting and management/financial reports, requirements gathered from business users and stakeholders. With the collected information, a prototype was designed and developed based on a model for confirmation and understanding of the requirements using EPM 10.0 platform. The development of the prototype also included the design and development of a Data Model, Data Model, Input Schedules, Script Logic/BADIs and Reports. The same business requirements, scenarios and documentation were used to create the detailed business Blueprint. Then, the consolidated income statement and the SAP CoA items were designed and revamped to the income statement line items.

Achievements:

●Gathered requirements from users

●Developed blueprint based on known requirements

●Migrated Data from different Sources to SAP HANA using Data Services and SLT

●Created Attributes, Analytic and calculation views

●Developed Reports and Dashboard

Industry: HealthCare - Boston, MA

Project Scope: Cost and Profit Centers Reporting

Role: SAP HANA Modeller/Information Designer/ Reporting Duration: May – jul 2013

Responsibilities:

For cost and profit center reporting around geographic dimensions, data and metadata were extracted, transformed and loaded from ERP system, Hyperion and flat files into SAP HANA SPS04 using Data Services and SLT. Then, Attribute, Analytical and Calculation views were created using the SAP HANA Studio SPS04. Universes built with Information Design Tool for purpose of web Intelligence reporting.

Achievements:

●Successfully extracted, transformed and load data and metadata from SAP ERP system, Hyperion and flat files into SAP HANA

●Created views (Attribute, Analytic and Calculation views) around cost and profit centers

Industry: Consulting Services, Mississauga, ON (Accenture)

Project Scope: SAP HANA Training

Role: SAP HANA Trainer Duration: April 2013

Responsibilities:

Training was given on SAP HANA SPS05 to one of the Global leader in BI Services and Consulting. The training included SAP HANA Architecture, Look/Feel of SAP HANA Studios, Data Provisioning (Data Services and SLT), Modeling (Attribute, Analytic, and Calculation Views), Reporting and User Management (User, Role and Analytic Privileges)

Achievements:

●Successfully delivered one week training on SAP HANA SPS 05 for one of the Global Leader in BI Consulting

Industry: Consulting Services, Vancouver, BC

Project Scope: Supervisor 101

Role: Supervisor 101 Trainer Duration: Mar 2013

Responsibilities:

I planned, coordinated and delivered one week course on Team Management, Performance Management and Transitions Management that indented to help supervisors and managers with 0-3 years of experience across regions and workforce.

Achievements:

●Successfully planned, coordinated and conducted one week training on Team Management, Performance Management and Transitions Management that was designed to help managers and supervisors to meet the challenges that global companies are facing across region and workforce today

Industry: Retail - Toronto, ON

Project Scope: ECC/SAP HANA/BI 4.0

Role: SAP HANA Modeller/Universe Designer Duration: sep – Dec 2012

Responsibilities:

For detail interactive P&L reporting on SAP HANA CO-PA and CCA, Cost Center, Profitability, master data in ECC and Flat file format were analyzed. CO-PA Accelerator was designed and customized for data model in SAP HANA to give a real-time access to profitability reports and dashboard.

Achievements:

●Successfully extracted data and metadata from ECC, flat files and Teradata into SAP HANA

●Created views (Attribute, Analytic and Calculation Views)

●Designed universe using Information Design Tool

●Developed Web Intelligence reports and dashboard using SAP BI 4.0

Industry: Financial Institution – Montreal, Quebec

Project Scope: BW Bex Query/Universe/Report/Dashboard – Post-Sales

Role: BW Bex Query and Universe Designer Duration: May – jul 2012

Responsibilities:

Requirements gathered analyzed, developed and documented for managerial and financial reporting. Based on requirements, InfoObejects, InfoCubes and BW Bex queries were designed and developed in BW 7.x System. Managerial dashboard and Web Intelligence financial reports were developed using universe build on BW Bex queries.

Achievements:

●Successfully analyzed, developed and verified requirements for 11 dashboards and 21 reports

●Developed BW Bex Queries

●Developed OLAP universes for 11 dashboards and 21 reports

Industry: Retail - Toronto, ON

Project Scope: Profitability (CO-PA) Analysis)

Role: SAP HANA Modeller/Universe Designer Duration: Mar – Apr 2013

Responsibilities:

The purpose of this Pre-Sales was to demonstrate the performance of SAP HANA. Therefore, metadata and data was extracted from ERP and Teradata into SAP HANA SPS04 using Data Services and SLT. SAP HANA studio was used to develop data models (Attribute/Analytical/Calculation Views) for purpose of reporting. Web Intelligence reports and dashboard were created for demo purpose.

Achievements:

●Significantly reduced data fetching time and number crunching; and improved performance for ERP reports (Profitability Analysis) and dashboards

Industry: Manufacturing - Waterloo, ON

Project Scope: SAP HANA POC – Pre-Sales

Role: SAP HANA Modeller/Universe Designer Duration: Feb 2012

Responsibilities:

BW 3.x System was analyzed for replication of master and transactional data of Blackberry handset activation. Data and metadata replicated into SAP HANA SPS02 using the SAP Data Services. SAP HANA SPS02 Studio used to model data (Attribute and Analytical views). Universe designed and developed for OLAP reporting. By utilizing the OLAP universe, Web Intelligence report, Explorer info space and Dashboard developed for Playbook 2.0. SAP GUI was installed on Playbook 2.0.

On this project, I did manage a team of 4 consultants where I identified a subject area for demo purposes.

Achievements:

●Successfully developed and demoed performance of Reports, Dashboards, and Explorer Info Space against SAP HANA views on Playbook 2.0

Industry: Retail - Toronto, ON

Project Scope: SAP BI 4.0 Workshops – Post-Sales

Role: Trainer Duration: Jan 2012

Responsibilities:

Workshop planned, organized and ran for SAP BI 4.0 on the client site. SAP BI 4.0 training material developed and delivered for Information Design Tool, MS Advance Analysis, Business-Objects Advance Analysis and Web Intelligence. I explained how information flows over the system when users sign in and view reports on demand or schedule, and BICS connectivity to BW Bex query was demonstrated using CMC admin page.

Achievements:

●Successfully organized, planned and ran SAP BI 4.0 workshop on the client site

Industry: HealthCare - North Shore, IL

Project Scope: SAP BI 4.0 Product Demo and Training – Pre-Sales

Role: Trainer and Developer Duration: Jan 2012

Responsibilities:

SAP BI 4.0 was demoed on the client site. Helped the client to plan the transition from IBM Cognos 8 to SAP BI 4.0 and address all of client’s concerns.

Achievements:

●Successfully demoed SAP BI 4.0 product suite

●Trained and addressed client concerns with transitioning from IBM Cognos to SAP BI 4.0

Industry: Business Software Solution Provider - Palo Alto, CA

Project Scope: Modeling Data using SAP HANA SPS01, Developing universe and dashboard

Role: SAP HANA Modeller/Universe/Dashboard/Test Case Developer Duration: oct – Dec 2011

Responsibilities:

For Workforce Planning Solution software, transactional data replicated from BW System into SAP HANA SPS 01 using Data Services 4.0. Master data flat files were load into SAP HANA SPS01. Attribute, Analytic and Calculation views were used to model data in SAP HANA SPS01 Studio. Workforce Planning Solutions dashboards were developed and tested using test cases.

Achievements:

●Replicated transactional data from BW to SAP HANA using Data Services 4.0 through Open-Hub

●Designed Attribute, Analytic and Calculation views using SAP HANA SPS01 Studio

●Developed Workforce Analysis dashboard and test cases

Industry: HealthCare – Salt Lake City, Utah

Project Scope: BI 4.0 Product Demo and Workshop

Role: Post-Sales Duration: sept 2011

For SAP BI 4.0 workshop, I developed the training material for IDT, MS Advance Analysis, Business Objects Advance Analysis and Web Intelligence. I also organized, planned and ran SAP BI 4.0 workshop to help the client to adapt the new SAP BI 4.0.

Achievements:

●Successfully organized, planned and ran SAP BI 4.0

●Addressed client concerns with transitioning from IBM Cognos to SAP BI 4.0

Industry: Business Software Solution Provider - Vancouver, BC

Project Scope: Solution Architecture - Developing RKT Learning Material for BI 4.0 FP3

Role: Developer Duration: Jun – Aug 2011

Responsibilities:

I developed and designed RKT learning material for SAP BI 4.0 FP3 Crystal Enterprise, Web Intelligence and Explorer.

Achievements:

●Developed and designed RKT learning material on BI 4.0 FP3 (Crystal Enterprise, Web Intelligence and Explorer) for SAP internal and external clients

Industry: Business Software Solution Provider - Mumbai, India

Project Scope: Solution Manager 7.2 (E2E Solution Support)

Role: Tester/Test Case Developer Duration: Feb – may 2011

Responsibilities:

Test cases were developed for SP03 BI monitoring in SAP Solution Manager 7.2. Also, SP03 BI monitoring in SAP Solution Manager 7.2 was tested, and errors reported on GTP system.

Achievements:

●Successfully executed test cases developed for BI monitoring SAP Solution Manager 7.2

●Reported error into GTP system

Industry: Software Solutions Provider – Newtown Square, PA

Project Scope: Trained/Developed Reports and Dashboards

Role: Trainer and Developer Duration: Aug – Dec 2010

Responsibilities:

I organized, planned and ran workshop on Business-Objects XI 3.2 (Architecture, Universe Design, Web Intelligence Reports, Xcelsius Dashboards, Explorer and Live Office). OLAP universes were built on BW Bex queries for developing Web Intelligence reports and dashboards.

Achievements:

●Successfully trained marketing and sales team on Business-Objects XI 3.2 tool sets

●Gathered requirements and developed marketing and sales reports and dashboards

Industry: Local Government - San Antonio, TX

Project Scope: Solution Architecture - Installation/Migration from Business-Objects XI R2 to XI 3.2

Role: Architecture Duration: Jul 2010

Responsibilities:

Business Objects XI 3.2 was installed, sized and scaled on development, test (VMware Machine) and production environments. Security Architecture was setup in all environments, and SAP integration Kit (SAP connector) installed. Content (reports, users, groups and objects) migrated from exiting Business Objects XI R2 environment to the newly installed Business Objects XI 3.2 environment.

Achievements:

●Successfully installed, sized and scaled Business-Objects XI 3.2 in development, test and production environments

●Migrated content from Business Objects XI R2 to Business Objects XI 3.2 environment

●Mapped Window Active Directory

Industry: Consulting Services – Redmond, WA

Project Scope: Business Objects Installation/Migration/ BI Development

Role: Solution Architecture/Application Developer (BI Consultant) Duration: Jan 2006 – may 2010

Responsibilities/ Achievements:

Dashboard:

●Installed Xcelsius 4.5 and Xcelsius 2008

●Gathered and analyzed requirements from users and stakeholder

●Created analytic templates and scorecards to demonstrate the concept

●Used Dashboard Manager and Xcelsius 4.5 to create various business dashboards using dynamic XML, Web Services and Excel data connectivity

●Provided the best practice for Business Objects Performance Manager and Scorecard Framework

●Created universes for PM/Scorecard reporting

Reports:

●Designed reports with various levels of complexity using Web Intelligence XI R1, XIR2, and XI 3.x

●Provided the best practices on implementation of the universe based approach to create report using Web Intelligence

●Created sample universes and reports to demonstrate the concept

●Converted Hyperion Reports to Web Intelligence reports

Universe Design:

●Gathered, designed and maintained universes requirements where scalability and maintainability were paramount

Crystal Reports:

●Created advanced reports using Crystal Reports

●Converted Cognos Reports to Crystal Report

●Converted Hyperion Reports to Crystal Report

Voyager:

●Used Voyager to explore and Analysis OLAP data

●Created multi-dimensional data set analysis and a full range of functions that addressed Business and Financial questions

Installation/Migration and Sizing:

●Installed Business-Objects XI R1, XI R2 and XI R 3.0

●Scaled, sized and balanced the load

●Analyzed requirements and implemented Architectural Design of Business-Objects Enterprise XIR1, XIR2 and XI 3.x and BI 4.0

●Used auditing information to optimize Deployment and Architecture

SDK:

●Developed and customized info view to display, view, schedule, and search all Web Intelligence and Crystal reports with Single Sign On

ETL:

●Extracted and transformed Data (Business Objects Data Integrator) from Oracle, Hyperion and other key data sources (including Access and Excel if required)

●Designed and implemented Batch-Mode Processing

●Extracted, transformed and loaded data from the staging areas or ODS schema into Rapid Data Mart (dimensional schema)

●Applied complex business logic to the source data using PL/SQL procedures to move data from the transactional systems to the staging areas or ODS schema

TECHNICAL TRAINING

SAP Certification and Courses:

SAP BI (Business Objects) 4.1

SAP Business Objects Design Studio 1.1, 1.6

SAP Lumira

SAP FI ECC 6.0 Boot camp

SAP SD ECC 6.0 Boot camp

SAP MM ECC 6.0 Boot camp

BW Boot-camp 7.3

SAP HANA SPS10 (Certification)

SAP HANA Live

Ramp-Up Coach (Certification)

ASAP 7.0 (Certification)

ERP Profitability Analysis (CO-PA)

BPC 7.5 & 10

BW 7.x

SAP BI 4.0 FP3

BI Mobile 4.x

SAP Data Services 3.2 & 4.0

SAP Solution Manager 4.0 (Certification)

ACADEMIC EDUCATION

Bachelor of Computer Science Jan 2000 – Aug 2003

Simon Fraser University

Burnaby, British Columbia – Canada

Computer Science Program Jan 1999 – Dec 1999

Douglas College

New Westminster, British Columbia - Canada

Contact this candidate