PROFESSIONAL PROFILE:

Around 10 years’ experience in SAP BW/BI implementation, SAP HANA, SAP HANA LIVE, SAP ABAP,SAP Business Objects (BO), SAP PCM which includes 7 full Life Cycle Implementations and Production support following ASAP methodologies in various domains like Retail, Travel, healthcare, Oil & Gas, Chemical, Telecom and Manufacturing. Extensively worked in the areas of Sales and Distribution (SD), Finance (FI) and controlling (CO), SRM, CRM, HR, PP, Materials Management (MM), Inventory Management (IM) and Warehouse Management (WM) and have in - depth business process knowledge.

SUMMARY:

• 8 Years’ Experience in SAP BW/BI with 6 Full life Cycle Implementations.
• 3 Years’ Experience on SAP HANA with 4full life cycle Implementations and HANA LIVE.
• 5 Years in SAP Business Objects (SAP BO 3.1, 4.0).
• 2 Year Experience in SAP BODS 4.0, 4.1.
• 1.5 year Experience in SAP PCM 10.0 and FIM 10.0
• Experience in Multi-dimensional Model in SAP BI 7.3
• Experience in Data Extraction and Data Flow within SAP BI 7.3 NW 2004S
• Experience in New Data source Concept of BI 7.3
• Experience in Transformation in BI 7.3(ETL)
• Experience in DTP (Data Transfer Process)
• Experience in UPGRADING DATAFLOWS FROM 3.X TO BI 7.3
• Experience in Business Content
• Experience in Administration of Info Cubes and Aggregates
• Experience in BI Accelerators, DSO (DATA STORE OBJECTS).
• Experience in Virtual Cubes and Multi Providers
• Experience in DATA EXTRACTIONS (ETL)
• Experience in ECC Extractions Using BI 7.3 Data flows
• Experience in Generic Extractions.
• Experience in Business Content Extractions
• Experience in CO-PA Extractions
• Experience in LO-COCK PIT Extractions (LOGISTICS)
• Experience in FI-SL Extractions (Financial special purpose ledger)
• Experience in PERFORMANCE TUNING.
• Experience in BI Enterprise Reporting, Query Designer.
• Experience in Navigating On Reports, Key Figures.
• Experience in CHARACTERSTICS and Attributes
• Experience in Exceptions and Conditions
• Experience in ADVANCED REPORTING Topics
• Experience in RRI (report to report interface)
• Experience in Bex Analyzer and Bex Web Analyzer
• Experience in Web Reporting using new Web Application Designer
• Experience in SAP BW 7.4.
• Experience in Data Extraction and Data Flow within SAP BW 7.4 NW 2004S.
• Experience in New Data source Concept of BW 7.4
• Experience in Transformation in BW 7.4(ETL)
• Experience DTP (Data Transfer Process) from 3.X TO BW 7.4
• Experience in Business Content UPGRADING DATAFLOWS
• Experience in Administration of Info Cubes and Aggregates
• Experience in DSO (DATA STORE OBJECTS) Virtual Cubes and Multi Providers.
• Experience in Data Provisioning using FLAT FILES
• Experience in Data Provisioning using BODS 4.0 (ETL Based Experience in Approach - Building AGILE Data Marts)
• Experience in Building Data Flows in Designer (to Load the Data to SAP HANA).
• Experience in Loading the Data from diff files to SAP HANA using SAP BODS (Text files, spread sheets, XML files and COBOL copybooks).
• Experience in Loading the Data from SAP BW 7.3 to SAP HANA using SAP BODS (Open Hub Tables, DSO tables etc).
• Experience in Loading the Data from Non-SAP Source Systems to SAP HANA using SAP BODS.
• Experience in loading data from CSV, MySQL.
• Experience in Exporting to Binary and CSV
• Experience in Creating a schema in SAP LT
• Experience in Replicating SAP system tables with SLT
• Experience in Real-time replication from ECC to HANA with SLT
• Experience in Building Data Flows in Designer (to Load the Data to SAP HANA).
• Experience in Creating an attribute view
• Experience in Creating an analytic view
• Experience in Creating a calculation view
• Experience in Creating Attribute Views with Hierarchies
• Experience in Using Create View GUI
• Experience in Calculated columns in an Analytic view
• Experience in Calculated columns in an Attribute view
• Experience in Using Variables with Analytic views
• Experience in Using Decision Tables with update values
• Experience in Using Decision Tables with return values
• Experience in Creating Tables: Row Store vs Column Store
• Experience in Example Calculations in Columns and Views.
• Experience in HANA, Reporting Layer and Connectivity options
• Experience in SAP Business Objects BI 4.0
• Experience in Designing Complex Universes in IDT based on HANA Tables and HANA Views.
• Experience in WEBi 4.0 on HANA.
• Experience in Crystal Report for Enterprise with HANA
• Experience in Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
• Experience in SAP Business Objects BI 4.0 Explorer
• Experience in Designing Information Space based on SAP Experience in HANA Information Model using BO Explorer 4.0
• Experience in Exploring the Data using BO 4.0 explorer based on Information Spaces created on HANA
• Experience in Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection).
• Responsible for first line PCM development
• Experience with SAP PCM 10
• Experience with PCM integration to SAP BW
• Experience with SAP PCM system design principles, including: Application design (including structure and dimensionality
• Experience with SAP FIM / PCM integration
• Experience with SAP Data Services
• Experience with PCM Build/design complex input schedules
• Experience with BI team in developing and enhancing PCM Jobs using Enterprise Scheduling Software (UC4)
• Experience in Information Design Tool(IDT)
• Experience in Universe Designer Tool(UDT)
• Experience in Web intelligence
• Experience in Dashboard Design Tool
• Experience in BI Launch Pad
• Experience in SAP BO 4.0, BW 7.3 Integration
• Experience in SAP BO BI 4.0 SAP HANA INTEGRATION.
• Experience in SAP LUMIRA
• Experience in sap ABAP Reports, ABAP Object oriented programming, Enhancements, BADIS, DATA Dictionary.
• Load Monitoring
• Tracking issues
• Tickets handling activities via the Remedy, Service Manager.
• Experience with sap data Services 4.x.

TECHNICAL SKILLS:

ERP Packages: SAP ECC 6.0, R/3 4.6

Expertise: Programming, problem solving, Design patterns, Research and development, Mentoring/, Testing

SAP Modules: BW, HANA, BO, BI-ABAP,BODS Data Services, SQL (For HANA)

Modules: HR,SD,FI,CO,PP,MM,SRM,CRM,IM,WM

Platforms: Windows, SUSE Linux (Only HANA DB relevant activities)

Databases: HANA 1.x, Oracle 11g/10g/9i/8i/8.0, MS SQL Server 2000/7.0, MS Access,DB2,Teradata

SKILL:

SAP BI-BW - 3.5, 7.0, 7.3,7.4 (on HANA)

SAP BO - 3.1,4.0

SAP ECC - 4.6,5.0,6.0

SAP BODS - 4.0, 4.1

SAP HANA - 1.5

SAP PCM - 10.0

SAP Netweaver - 2004S

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SAP BI/BO/HANA Architect

Environment: SAP ECC 6.0, SAP HANA, SAP BI 7.4, SAP BO 4.0, SAP BPC 10.0, SAP PCM 10.0

Responsibilities:

• Working very closely with internal client team as well as with the implementation team.
• Will be walking into the very early stages of the project and will be responsible for blueprinting, requirement gathering, design, strategy and eventually the build of SAP HANA.
• Experience in Hadoop when there is a large volume and format of data that is unpredictable/undefined.
• Experience in using Data Services to interact with SAP HANA and Hadoop,
• Experience In Hadoop, Using Map Reduce, HIV, and HDFS.
• Performed Perform predictive analytics on top of SAP HANA using SAP Predictive analysis tools, and also using open source technologies on top of SAP HANA.
• Will be leveraging SAP BW with BPC alongside HANA and also installing SAP HANA studio and HANA Live
• Experience in Understanding the Business requirements & convert them into Blueprint
• Experience in Defining the Design Documents for the HANA Models
• Experience inEssential Configurations for SAP ECC Accelerations using SAP HANA
• Experience in Translating Functional Specifications into Technical Specifications
• Experience in Translating the Business KPIs into HANA & Define the Reporting Layouts
• Translate the Business KPIs for Dashboards & Define the dashboard Layouts.
• Responsible conducting workshops, providing long term strategy and directions, developing base line and detailed scoping and working with functional teams and steering committee closely. Manage team of 15 team onsite and offsite.
• Technical development on BW data providers, EDW architecture, configure SMS, single single-on, configure BODS to extract non-sap databases to BW data providers, develop complex reports, develop complex Webi reports and dashboards using BI4.0 tools.
• Responsible in high level deliverables to implement SAP HANA and BW are System Blueprint, Detail Design Documents, Configured System, Configured interfaces, Test Plans/Test Data/Test Results, User, Technical Documentation, and Future Roadmaps.
• Expert in understanding of the complete Architecture (Data loading, Data modeling & Reporting)
• Expert in SAP HANA extraction from SAP BW/SAP-ECC/Non-SAP Data sources using SLT, Data Services and SAP HANA Direct Extractor Connection (DXC).
• Designing and Developing real time operational reports using HANA live
• Working with Calculation views of VDM's (Virtual Data Models)
• Working extensively with Private Views, Reuse Views and Query Views
• Modeling customized views using Query view in suite on Hana
• Analyzing customized views using Hana Live Browser
• Creating report on customized views using SAP Lumira
• Creating reports on customized views in Web Intelligence(WebI)
• Generating reports that are accessible from mobile devices like phone and iPad
• Experience in SAP HANA data modeling using HANA Studio
• Defining the SAP HANA components (ECC Tables and Non ECC sources to replicate) Replication Process Define HANA Views (Which are basis for Data Reporting/Analysis), Defining the Data Analysis components in BOBJ Define Reporting aspects, analysis components. Reporting Decision Tree, Creating BW and HANA Use cases. Report Rationalization, Defining Strategy and Direction.
• Data Integration architecture, Define Project Plan, Governance model, Identify the various teams and their responsibilities.
• Implementing SAP HANA solution: SAP HANA Hands-on Experience
• Modeling (Analytic, Attribute and Cal. Views), Data provisioning, Complex SQL Statements
• Configure SLT, creating schemas, Implementation of transformation rules by maintaining table IUUC ASS RUL MAP on the LT server, Configuration for non-SAP source system, within the LT replication server, defining RFC connection to source system, defining DB connection to HANA system, defining no. jobs for data replication, SLT issues and resolution on jobs.
• Created Analytic Privileges, Calculated Attributes, Complex Calculation views, SQL Scripting, created Procedures using SQL.
• Direct Extractors(DXE) in BW 7.3 (Ex: Sales Order Item Content) using Data Provisioning
• Developed Reports using Universe (Webi, Explorer, dashboard and analysis tools)
• Connecting non-sap DB using BODS to HANA DB
• Migrated MS SQL Database into SAP HANA
• Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Developed complex SQL scripts in Calculation views
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application
• Involved in SAP HANA Security including User Management, Roles, and Privileges
• Reporting, Accessing Analytical and Calculation views from EXCEL.
• Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.
• Developed Web Services for SAP HANA database and deliver to ASP.NET developers to consume data in .net based applications
• Maintaining Users and Authorizations
• Monitoring with SAP HANA Studio, Monitoring with DBACOCKPIT
• SAP HANA Direct Extractor Connection Setup & Configuration
• Responsible SAPBW 7.3 /BI 4.0 Deliverables- (BODS, Webi, Dashboard Designer tools)
• Defining the SAP BW/BI components (ECC Tables and Non ECC sources to replicate) Replication Process Defining the Data Analysis components in BOBJ Define Reporting aspects, analysis components. Reporting Decision Tree, Creating BW and BI Use cases.
• Data Integration architecture, Define Project Plan, Governance model, Identify the various teams and their responsibilities. Design and Develop Executive Dashboards (Customer, profitability, monthly and weekly financials)
• Extracted Data from FI/CO, SAP HR, SAP Payroll, SAP OTC, CATTS and CRM Modules to BW.
• Dashboard Development using Dashboard Designer-Monthly Dashboard (KPIs Balance Sheet Summary by GL Account & Amount, Inventory, Headcount, Cash flow, Conversion Cycle, Working Capital, Capex and Rona)
• Profitability Analysis Dashboard (KPIs - By Customer and Product and shows profit Vs. Sales analysis, Plant Analysis Dashboard (KPIs COGS breakdown, Material Value and Actuals, Over time and Benefits, Payroll, Sales and General Admin by Cost Center, Labor Detail)
• Profitability Dashboard ( KPIs Customers and Products with interactive graph on user click)
• Weekly Dashboard (KPIs P&L Highlights, Balance Sheet Summary, Inventory interactive Graph).
• Strong Analytics/Data warehouse experience usingSAP Business Objects Data Services/ Data Integrator
• Strong experience in the integration ofBODSwithSAP modulesandNon-SAP data sources.
• Strong experience in usingBODSas an external system for ETL betweenECCandBI.
• Created complexJobs, Work Flows, Data Flows, and Scriptsusing various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Strong experience in cleansing the data usingData Qualitytransforms.
• Proficiency in data warehousing techniques forSlowly Changing Dimensionphenomenon, surrogate key assignment andChange Data Capture.
• Extensively usedData Services Management Consoleto schedule and execute jobs, manage repositories and perform metadata reporting.
• Data modeling (Dimensional & Relational) concepts includingStar-schema modeling, Snowflakes modeling, fact and dimension tables.
• Installed and Configured Business Objects Enterprise Suite, Business Objects Data Services/Data Integrator/Data Quality & Data Insight with proper IQ and OQ documentation.
• Experience of working on HANA projects related to Business Suite on HANA - ECC,CRM,SCM and APO
• Worked as Solution Architect with progressive experience in Design/Development and Consulting in SAP specializing in SAP HANA 1.0 SP06, SAP Net Weaver Business Warehouse & Business Objects Reporting Tools.
• Experience in SAP BW/BOBJ with subject matter expertise in Business Intelligence domain integrating to SAP HANA.
• Experience includes end to end Implementations, support, and upgrade, roll up projects as well as solution Architecture and Pre Sales.
• Authoring Presenting Business Cases, Investment Areas, and Architectural Views to demonstrate value of technology/initiatives.
• Building SAP HANA Strategy& Managing a team of Architects and developing a go-to market strategy for SAP HANA including demand generation, marketing propositions.
• Pre-sales Specialist with knowledge on strategic SAP HANA/BW implementations.
• Propose unique strategy on adopting HANA, more specific to customer Business case
• Ability to Re-Architect the current BI solution with SAP HANA as Database, BW as EDW layer & BO BI as Analytics solution.
• Having expertise in delivering HANA projects like BW on HANA Implementations,
• Adopt and follow SAP’s roadmap on various products like Design Studio, Predictive Analytics & SAP Lumira.

Confidential, Houston, TX

Sr.SAP BI/BW HANA Consultant

Environment: SAP ECC 6.0, SAP HANA, SAP BI 7.3, SAP BO 4.0, SAP SCM

Responsibilities:

• Worked as Solution Architect with progressive experience in Design/Development and Consulting in SAP specializing in SAP HANA 1.0 SP06, SAP Net Weaver Business Warehouse & Business Objects Reporting Tools.
• Experience in SAP BW/BOBJ with subject matter expertise in Business Intelligence domain integrating to SAP HANA.
• Experience includes end to end Implementations, support and upgrade, roll up projects as well as solution Architecture and Pre Sales.
• Data Provisioning using FLAT FILES
• Preparation of data, designing and implementing HANA analytical models, data provisioning into HANA tables, and designing and implementing BO reports on HANA data.
• Data Provisioning using BODS 4.0
• Building Data Flows in Designer (to Load the Data to SAP HANA)
• Data Modeling
• Creating Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
• SAP HANA SQL
• HANA, Reporting Layer
• WEBi 4.0 on HANA
• Migration of BW to HANA.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
• Strong Analytics/Data warehouse experience usingSAP Business Objects Data Services/ Data Integrator
• Strong experience in the integration ofBODSwithSAP modulesandNon-SAP data sources.
• Strong experience in usingBODSas an external system for ETL betweenECCandBI.
• Migration from BW to BW-HANA.
• Done the migration with PCA - Post Copy Automation Tool which is an automated solution for delta queue cloning and synchronization on the production systems for BW on HANA migrations based on a BW system copy.
• Rapid database migration of BW on RDBMS to BW on HANA
• BW on HANA fresh installation and moving only the required, data models & content, in the process optimize and cleanup the BW system
• Carving out a part of large BW and moving only relevant content (like for a business unit or region)
• HANA as real time, high value agile/custom data mart and later migrating BW to BW on HANA
• New projects, initiatives on new BW on HANA installations.
• Performs activities required after the initial system copy of a SAP NetWeaver BW system reliable.
• Done with post migration activities.
• Worked on creating Data Models - Creating Info Objects, Data source, Info package, DTP, Transformations, DSO, Info cubes, Multi providers etc. and optimized the relevant objects for HANA in accordance with LSA++ Architecture.
• Worked in ABAP routines - Start routine, End routine, field routine and Expert Routines in transformations - written codes for master data look-up, filtering data based on complex conditions, used function module for various conversions, etc.
• Created Transient Providers, Composite providers to import native HANA models to BW and also exported cubes to HANA Studio to leverage HANA optimized BO reporting tools.
• Created Open Hub Destination to load the BW data to 3rd party system.
• Created, published and scheduled reports as per requirement on BO OLAP analysis, Explorer and Webi.
• Implemented cells, workbooks and OLAP variables (like Customer exits, formula variables etc.) in BEx.
• Created and scheduled Master data and Transactional Data chains to automate data load process.
• Extensively worked on Business Objects (BO) integration with BW for reporting requirements.
• Extensive experience on developing Web Intelligence Reports and Crystal Reports.
• Experience in Business Objects universe designing (OLAP Universes), Business Objects Web Intelligence (Webi), Business View Manager, InfoView, and Business Objects Enterprise (BOE).
• Created Functional Designs and Technical Design documents based on real-time report
• Requirements to be implemented on HANA enterprise along-with requirements of accelerated BW based reports.
• Worked on data provisioning from Teradata systems using Data Services and from SAP ECC using SLT servers.
• Worked on creating Attribute views, Analytical views & Calculation views based on requirements and data-warehousing standards.
• Worked on SQL based authorizations and CE functions.
• Worked on row level authorizations & hierarchies.
• Created trend reports by combining imported SAP BW data models (InfoCubes) with historical data and real-time data from HANA models.
• Consumed HANA models into Explorer, Advanced analysis, Crystal and Webi reports.

Confidential, Houston, TX

SAP BI/BW HANA Consultant

Environment: SAP ECC 6.0, SAP HANA, SAP BI 7.3, SAP BO 4.0, SAP SCM

Responsibilities:

• Worked on the SAP HANA POC project.
• Preparation of data, designing and implementing HANA analytical models, data provisioning into HANA tables, and designing and implementing BO reports on HANA data.
• Designing SAP HANA Tables, HANA models (Attribute Views, Analytical Views and Calculations Views) for Sales and Inventory scenarios.
• Developed complex SQL scripts in Calculation views.
• Worked on Schemas, table definitions, Attributes, Measures & Hierarchies in HANA.
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application.
• Involved in SAP HANA Security including User Management, Roles, and Privileges
• Reporting, Accessing Analytical and Calculation views from EXCEL. Strong Analytics/Data warehouse experience usingSAP Business Objects Data Services/ Data Integrator
• Strong experience in the integration ofBODSwithSAP modulesandNon-SAP data sources.
• Strong experience in usingBODSas an external system for ETL betweenECCandBI.
• Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.
• Creating Attribute Views, Analytical Views, and Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios.
• Expert in understanding of the complete Architecture (Data loading, Data modeling & Reporting)
• Expert in SAP HANA extraction from SAP BW/SAP-ECC/Non-SAP Data sources using SLT, Data Services and SAP HANA Direct Extractor Connection (DXC).
• Experience in SAP HANA data modeling using HANA Studio.
• Experience in working with HANA Graphic modelling tools
• Experience in working with SQL Modelling tools
• Experience in working with connecting tables and Decision tables
• Experience with standard SAP HANA Rapid Deployment Solutions (RDS)
• Experience with HANA LIVE
• Experience Query and report development using Explorer, Analysis, Webi & Lumira
• Experience in Creating an attribute view, analytic view and calculation view by using SQL Script.
• Experience in Creating Attribute Views with Hierarchies
• Experience in Using Create View GUI
• Experience in Calculated columns in an Analytic view and an Attribute view.
• Experience in Using Variables with Analytic views
• Experience in Using Decision Tables with update values, return values
• Experience in Creating Tables: Row Store vs Column Store
• Experience in Example Calculations in Columns and Views.
• Experience with SAP BO Data services & SLT replication methods.
• Experience in Data Provisioning using FLAT FILES, BODS 4.0 (ETL Based Experience in Approach - Building AGILE Data Marts)
• Experience in Building Data Flows in Designer (to Load the Data to SAP HANA).
• Experience in Loading the Data from diff files to SAP HANA using SAP BODS (Text files, spread sheets, XML files and COBOL copybooks).
• Experience in Loading the Data from different SAP ERPS (like ECC, CRM) using SAP BODS to DSAP HANA for COPA, FI, Sales, Purchasing, Marketing, Opportunity and Service Scenarios.
• Experience in Loading the Data from SAP BW 7.3 to SAP HANA using SAP BODS (Open Hub Tables, DSO tables etc).
• Experience in Loading data from CSV, MySQL.
• Experience in Creating a schema in SAP LT
• Experience in Replicating SAP system tables with SLT
• Experience in Real-time replication from ECC to HANA with SLT
• Experience in HANA, Reporting Layer and Connectivity options
• Experience in Designing Complex Universes in IDT based on HANA Tables and HANA Views.
• Experience in WEBi 4.0 on HANA.
• Experience in Crystal Report for Enterprise with HANA
• Experience in Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
• Experience in SAP Business Objects BI 4.0 Explorer
• Experience in Designing Information Space based on SAP Experience in HANA Information Model using BO Explorer 4.0
• Experience in Exploring the Data using BO 4.0 explorer based on Information Spaces created on HANA
• Experience in Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection).

Confidential, CINCINATI, OH

Sr. SAP BI/BOBJ HANA Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, FI, SD, MM, HR, BEx, Business Objects 4.0

Responsibilities:

• Involved in full cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Activated Business Content for Accounts payable (AP), Accounts Receivable (AR), General Ledger (GL), Cost Center Accounting (CO-CCA), Purchasing and customized them as per the client requirements.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Multi providers, Info Sources, Info sets, Time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Implemented FI cubes such as 0FIAR C02, 0FIAR C03, 0FIAP C03, and ODS such as 0FIAR O03, and 0FIAP O03 with proper transfer rules and update rules.
• Extracted Master and Transaction Data from Flat files and loading into Info Objects, DSOs and Info Cubes.
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC Generic Extractions and also in BI data modeling like Start Routines and End Routines.
• Created Aggregates on Info Cubes to improve the query performance.
• Created BEx queries for reporting on Info Cubes, Info Sets, ODS and Multi Provider.
• Created calculated and Restricted Key Figures, Structures, Conditions, Filters and Cell Definitions within queries, maintained Query settings and tuning.
• Migrated Data Sources from 3.x to 7.0. Modified the business content update and transfer rules to transformation rules.
• Extracted Master and Transaction Data from Flat files and loading into InfoObjects, DSOs and InfoCubes.
• Worked on FI - GL, FI-AR, FI- AP, FI- AA, COPA data sources for extraction and loading of data from FI to BW.
• Creating queries for the cluster using Query Designer involving Calculated and Restricted KFs, different Variables, Conditions, Exceptions, Filters etc.
• Created custom Info Cubes for company wide Sales, Delivery, Billing and Purchasing with various aggregate periods (business day of the year, business day of the month etc.)
• Created and Maintained DTP and Info Package for Loading. Created, Maintained and Monitored Process Chains for periodic loads of Master data and Transaction data from ECC system to Data Targets using various process categories and process types.

Confidential, Franklin Lakes, NJ

Sr. SAP BI/BW Consultant

Environment: SAP Net weaver 04s (BI 7.0), ECC 6.0, CO, FI-GL, SD, BEx Analyzer.

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
• Interacted with the Business Users to analyze the business process and gathered the requirements.
• Designed functional and Technical specifications for Implementation and Development of BO XI R2 over SAP BI.
• Involved in BW 3.5 to BI 7 upgrade processes and was responsible for design, development and extraction from R/3 Source system and flat files to BW for FI & CO.
• Extensively worked on SD Info Cube 0SD C03 and data sources 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VCITM and financial data providers, multi provider’s 0FIAP M40 data sources 0FI GL 40 according business needs in SAP BI.
• Involved in development, integration testing, UAT to Go live production support of OTC, RTR reports.
• Created new info providers in SAP BI depending upon the end user needs.
• Developed extract structures and Data Sources in Financial Accounting to facilitate the data extraction to
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC generic extractions and also in BI data modeling like Start Routines and End Routines.
• Extensively worked on BEx reporting and workbooks using RRI, cell definitions, variable offsets, exceptions, conditions.
• Master and Transaction Data extraction from Flat files and loading into Info Objects, DSOs and Info Cubes.
• Performed analysis, design, development and implementation of standard/customized Info Cubes and DSO Objects for SD, FI and SCM modules.
• Created intermediate write optimized DSO Structures and APD’s in BI7.0 to improve performance while loading AP data.