PROFILE:

• SAP BW/HANA/BOBJ Architect with close to 12 years of overall experience. Worked extensively in designing and implementing BI solutions in various SAP Modules like SD, MM, APO, FI, CO, IM, WM and HCM.
• Proficient in SAP BW, HANA, ABAP, BI - IP and also has reasonable exposure to SAP BO Webi, WAD, Advanced Analysis, Explorer, design Studio, Crystal reports, Lumira.
• Involved in 14 full life-cycle BW implementations. Around 9+ years of experience as Lead consultant and successfully performed various roles such as Technical Lead, Analyst, and Developer in all the phases of a project life cycle.
• Experience in Multi-dimensional Model in SAP BI 7.3, Data Extraction and Data Flow within SAP BI, New Data source Concept, Transformation in BI 7.3(ETL), DTP, UPGRADING DATAFLOWS FROM 3.X TO BI 7.3, Business Content, Administration of InfoCubes and Aggregates, BI Accelerators, DSO (DATA STORE OBJECTS) and Virtual Cubes and Multi Providers.
• Experience in DATA EXTRACTIONS (ETL), ECC Extractions Using BI 7.3 Dataflows, Generic Extractions, Business Content Extractions, CO-PA Extractions, LO-COCK PIT Extractions (LOGISTICS) and FI-SL Extractions (Financial special purpose ledger)
• Experience in PERFORMANCE TUNING.
• Experience in BI Enterprise Reporting, Query Designer, Navigating On Reports, Key Figures, CHARACTERSTICS and Attributes, Exceptions and Conditions, ADVANCED REPORTING Topics, RRI (report to report interface), Bex Analyzer and Bex Web Analyzer.
• Experience in Web Reporting using new Web Application Designer
• 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
• Experienced in writing HANA DB procedures and views.
• Experienced in creating HANA Calc Views (Using SQL), attribute Views and Analytic Views.
• Experienced in writing HANA procedures for various merchant processes. For example, Aggregation, Annual Load Calculation, Profiling etc.
• Experienced in analyzing and debugging the DB procedures manually.
• Proficient in creating interfaces between various sources with HANA. For example, Extracting data from XML file to HANA database.
• Experience in executing Data service batch jobs through data services management console.
• Experienced in writing and debugging data service batch jobs using SAP data service 4.0
• Translation of complex utility related requirements into SAP Data Services transformations (e.g. Lookups, complex Joins, Case, functions, pivots, matching)
• Creating Data Services custom functions and scripts in order to improve the reusability of the Jobs
• 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 SAP HANA on Object Event Repository (OER) data
• Experience in SAP HANA Live Browser
• Experience in SAP HANA Live Models
• Experience in Extending HANA Live Views
• Experience in Combining Custom Tables and HANA Live
• Experience in using Analytics Authorization Assistant
• Experience in Data Provisioning using FLAT FILES, BODS 4.0 (ETL Based Experience in Approach - Building AGILE Data Marts)
• Experience in visualizing the data includes creating a document, saving it to a local directory or Lumira Cloud, saving it and sharing in SAP Lumira Team server and BI Platform
• Experience in acquiring the data from different sources such as Excel workbook, text file, copied clip board, SAP HANA, SAP BW, universes, query with SQL
• Experience in editing, refreshing and renaming acquired dataset
• Experience in preparing data such as editing and cleaning data, creating measures and hierarchies, creating a calculated measure or dimension and working with multiple datasets
• Experience in creating, data sorting and filtering data in charts
• Experience in creating dataset from a visualization
• Experience in Forecasting, Linear Regression and Influence analysis
• Experience in managing application extensions
• Experience in Registration of SAP Lumira, Optimizing the memory usage and setting application ps
• 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).
• Experience in sap ABAP Reports.
• ABAP Object oriented programming.
• Enhancements (Customer exit and BADI).
• DATA Dictionary, Function modules and sub-routines, Interfaces.

WORK EXPERIENCE:

Confidential, Baton Rouge, LA

SAP S/4 HANA Analytics Architect

Responsibilities:

• Experience in Fit/gap analysis, business scenario test, cut over, knowledge transfer, walkthrough, go live support Leverage Implementation.
• Designed and Developed FIORI Apps for the S/4 HANA Simple Finance Applications Such as Accounts Receivable, Accounts Payables, Cash Management, Asset Accounting.
• Implemented SAP Fiori UX for S/4 HANA
• Building SAP HANA Strategy & Managing a team of consultants and developing a go-to market strategy for SAP HANA including demand generation, marketing propositions.
• Propose unique strategy on adopting HANA, more specific to customer Business case
• Ability to redesign 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, New York, NY

SAP S/4 HANA Analytics Architect

Responsibilities:

• Experience in Fit/gap analysis, business scenario test, cut over, knowledge transfer, walkthrough, go live support Leverage Implementation.
• Designed and Developed FIORI Apps for the S/4 HANA Simple Finance Applications Such as Accounts Receivable, Accounts Payables, Cash Management, Asset Accounting.
• Implemented SAP Fiori UX for S/4 HANA
• Building SAP HANA Strategy & Managing a team of consultants 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 redesign 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

SAP HANA Architect

Responsibilities:

• 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).
• Experienced in writing HANA DB procedures and views.
• Experienced in creating HANA Calc Views (Using SQL), Attribute Views and Analytic Views.
• Experienced in writing HANA procedures for various merchant processes. For example, Aggregation, Annual Load Calculation, Profiling etc.
• Experienced in analyzing and debugging the DB procedures manually.
• Proficient in creating interfaces between various sources with HANA. For example, Extracting data from XML file to HANA database.
• Experience in executing Data service batch jobs through data services management console.
• Experienced in writing and debugging data service batch jobs using SAP data service 4.0
• Translation of complex utility related requirements into SAP Data Services transformations (e.g. Lookups, complex Joins, Case, functions, pivots, matching).

Confidential, Houston, TX

SAP BI/BW HANA Architect

Responsibilities:

• 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).
• Experienced in writing HANA DB procedures and views.
• Experienced in creating HANA Calc Views (Using SQL), Attribute Views and Analytic Views.
• Experienced in writing HANA procedures for various merchant processes. For example, Aggregation, Annual Load Calculation, Profiling etc.
• Experienced in analyzing and debugging the DB procedures manually.
• Proficient in creating interfaces between various sources with HANA. For example, Extracting data from XML file to HANA database.
• Experience in executing Data service batch jobs through data services management console.
• Experienced in writing and debugging data service batch jobs using SAP data service 4.0
• Translation of complex utility related requirements into SAP Data Services transformations (e.g. Lookups, complex Joins, Case, functions, pivots, matching)
• Creating Data Services custom functions and scripts in order to improve the reusability of the Jobs
• 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 analysisPlant 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).
• Experience in SAP HANA Live Browser
• Experience in SAP HANA Live Models
• Experience in Extending HANA Live Views
• Experience in Combining Custom Tables and HANA Live
• Experience in using Analytics Authorization Assistant
• Experience in visualizing the data includes creating a document, saving it to a local directory or Lumira Cloud, saving it and sharing in SAP Lumira Team server and BI Platform
• Experience in acquiring the data from different sources such as Excel workbook, text file, copied clip board, SAP HANA, SAP BW, universes, query with SQL
• Experience in editing, refreshing and renaming acquired dataset
• Experience in preparing data such as editing and cleaning data, creating measures and hierarchies, creating a calculated measure or dimension and working with multiple datasets
• Experience in creating, data sorting and filtering data in charts
• Experience in creating dataset from a visualization
• Experience in Forecasting, Linear Regression and Influence analysis
• Experience in managing application extensions
• Experience in Registration of SAP Lumira, Optimizing the memory usage and setting application ps
• Worked as Senior Consultant 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.
• 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 SAPNetWeaver BW system reliable.
• Done with post migration activities.
• Developed more than 200 FI/CO, OTC reports for current rollout 10, worked on complex SQL Statements, broadcasting these reports, complex comparative and trend reports.
• Created OLAP Universes, using different sources and multisource universe, managing universe with data foundation and business layers and optimization techniques using IDT tools. Used BICS for most the reports.
• Worked to increase scheduled reporting capacity, improving web response speeds, CMS (central management server) configurations, CMS clustering across subnets, working with QAAS. Used Combined Queries, created query based on another query, calculation contexts, creating formulas and used string functions.
• Resolved lot of issues with BI4.0 upgrades (SP02 to SP04)
• IT1, IT2, IT3 and UAT testing with functional leads, train functional users and planning to rollout BI and BW.
• Integration between APO and BW, loading the data from ECC to APO-BW cube using Standard extractors and generic depending on your data.

Confidential, Houston,TX

SAP HANA Architect

Responsibilities:

• Responsible implementing HANA for their month-end closing reports (Operational Reports) and MM Reports out of HANA, Configured SLT with SAP, implemented HANA Overview & Roadmap for vSAP Project, HANA Architecture, Implementing RDS (Rapid Deployment Solutions for FI and SCM), Created HANA Vs BW Vs BI Use cases, Reporting Workshops, giving best and leading practices to implement HANA, BW and BI with FI and SCM implementations.
• Responsible to implement HANA Modeling data like: Creating attribute, analytical and calculation views, more complex information models, view results using BOBJ reporting tools (Webi, Explorer, Dash boarding etc).
• Implemented COPA Scenario as Ramp-up customer and developed 35 reports.
• Hands on experience with HANA landscape using functionalities like data provisioning, Modeling and Administration, and Information Composer.
• 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 visualizing the data includes creating a document, saving it to a local directory or Lumira Cloud, saving it and sharing in SAP Lumira Team server and BI Platform
• Experience in acquiring the data from different sources such as Excel workbook, text file, copied clip board, SAP HANA, SAP BW, universes, query with SQL
• Experience in editing, refreshing and renaming acquired dataset
• Experience in preparing data such as editing and cleaning data, creating measures and hierarchies, creating a calculated measure or dimension and working with multiple datasets
• Experience in creating, data sorting and filtering data in charts
• Experience in creating dataset from a visualization
• Experience in Forecasting, Linear Regression and Influence analysis
• Experience in managing application extensions
• Well versed with replication methods like SAP Landscape transformation and Business Objects Data services.
• Completed various certified courses and participate on various HANA open houses and webinars to keep unto date on technology.
• Comprehensive modeling experience in creating various views like Attribute, Analytic and calculation views.
• Hands-on experience with SQL scripts like stored procedures and CE scripting and well versed with BW7.3 on HANA working functionalities.
• Created Reports on SAP HR, SAP Payroll, SAP FI/CO and CATTS.
• Helped Finance users to close their month-end closing reports, reconciliations, real-time reports etc
• Establish trust-based relationships with key client Business Process Owners and Decision Makers.
• Responsible in providing project estimates, decision documents, strategy documents, kick-off and sign-off from program management on IAs, work closely with PMO office.
• Implemented EDW Architecture, high volume of data from Essbase cubes to HANA and BW, imported hierarchies from MDG and IBM tools, Created Reporting Decision Trees.
• Created Analytical, Calculation and Attribute views, SLT Configuration, replicated DB Tables, Currency conversion, created dashboards and webi reports using BI4.0 tools.
• Accelerated BW and HANA database, used HANA as standalone replicated 3rd party DB and ECC Tables.
• Substantial amounts of time spent accessing data to address critical business questions, complex logic from database content to business data, require complex transformation rules, Business functions like alpha-convert, currency translation, time-dependency, etcwith SAP HANA, Use Business Objects Data Services to connect code block database to SAP BW and SAP HANA, Rationalize billing ERP Systems which should map to BW and HANA
• No Real Time access to transactional systems SAP HANA Solution Provided
• No Real BI solution is usage today at all on legacy systems SAP HANA Solution Provided
• Users have to wait from IT Dept to answer business questions SAP HANA Solution Provided
• Near Real time Data need for Management Reports SAP BW 7.3 Solution Provided
• Performance with Management Reports and Operational Reports from DWH SAP BW 7.3 and SAP HANA Solution Provided (Accelerated solution provided using BW on HANA
• Integration between APO and BW using RFC and loaded data to BW Planning Cubes.
• Connecting to 3rd parties BODS Solution Provided with SAP HANA and SAP BW
• Created SQL in HANA to connect tables using, Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Text Join, Referential Join and Union.
• Created Inner Join Analytical ViewConnecting Tables
• Implement leveled hierarchies,leveraged parent / child hierarchies,created attribute based hierarchies
• Creating Restricted & Calculated Measures in analytical views
• Implemented Financial Accounting Accelerator, Controlling Accelerator, Material Ledger Accelerator, Production Cost Analysis

Confidential, New York, NY

SAP BI/BW/HANA Lead Consultant

Responsibilities:

• Data Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services.
• Replication of the selected tables of SD from ECC to SAP HANA. Performed transformations during the replication process.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Monitoring the replication process using SAP HANA studio and SAP LT replication server for transactional integrity.
• Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE(In memory calculation Engine) studio.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Migrating standard Infocubes to In memory optimized Infocubes using migration Tool.
• Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool.
• Importing the BW Models in to HANA using HANA Studio.
• Consuming the HANA Models in BW by creating the Transient Providers.
• Activation of Standard Master and Transactional Data sources. Maintenance and Activation of LO extractors.
• Deletion of Setup Data and Re-filling the Setup Data after activating the Data sources and checking the same in Extractor Checker.
• Pushing Delta from Outbound Queue to BW Delta Queue Maintenance by activating or executing program.
• Created View and Generic Data sources based on Table and View
• Appended new fields in Standard Data sources and written code for the same in CMOD.
• Extracted Data into BI from various systems like R/3, SRM, SCM and FLATFILE.
• Activated Multi provider and Query from Standard Business Content.
• Experience in understanding of the complete Architecture (Data loading, Data modeling & Reporting)
• Experience 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
• Worked extensively on BI Routines like Start routine, Object routine, End routine and BI report Exits.
• Carried out Data Validation between the source system data and target data and analyzed whether the values are populated correctly.
• Perform Currency Conversion using variables, Info Objects & Fixed value based on the user requirements.
• Transported objects from Development to Quality using Transport Organizer.
• Worked on roles and authorizations and created analysis authorizations in BI security.
• User acceptance tests of BW reports and end-users & go-live support.
• Worked in historical data loading from legacy Oracle system with data migration conversion rules.
• Worked on the post go live cut over activities and support issues.
• Had developed virtual provider using direct access for APO Reports.
• Worked on the all the featured of query designer like QTD, YTD variables, structures, auxiliary cells and cell s

Confidential, Columbus, OH

SAP BI/BW Consultant

Responsibilities:

• Working on data collection, manual posting of data, currency translation, InterUnit eliminations and reconciliations, balance carryforward .
• Built independent sales Info cubes and extracted data from sales modules
• Worked on Operational Data Store (ODS) to stage the data before transferring it to the Info Cubes
• Creating numerous calculated/restricted key figures for KPI calculations, variables as replacement path, customer exit, auth, SAP exit.
• Used aggregates, compression, and partitioning techniques to improve data load and query performance.
• Transported objects from Development to Quality using Transport Organizer.
• Created another infosource to feed this ODS for Movements/Postings from R/3 with information like Suspended, Rejected and Cleaned date and other movements data
• Involved in upgrading cubes from BW 3.5 to BI 7.0

Confidential

SAP BI BWConsultant

Responsibilities:

• Worked as BI/BO consultant and gathered business requirements and deliverables for report requirements along with functional end users in the business areas. And analyzed to identify business content data
• Designed and developed custom Data Sources, Info Sources, Extractors, Info Cubes and DSO'S to fulfill user requirements.
• As part of the performance tuning created aggregates for info cubes.
• Involved in review for various objects and created test case and test plans in different environments.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Worked with ABAP programmers in creating ABAP codes for Transformation routines.
• Performed Master data and Transaction data extractions (SAP) and automated the data loads using Process Chains.
• Analyzed PSA table growth and scheduled weekly PSA and Change Log deletion jobs.
• Universal Design: Universe planning building and implementation, design methodology, development cycle Creating Classes, Objects, schema, store procedures.
• Web Intelligence: Created Advance multiple Reports, Ad hoc query, tables, charts, Complex Filters customized formulas and highly formatted page layouts.
• Dashboard: Creating chart with visualizing data range, Series, interactive model, map with graphics, Query as a Web Service.
• Deployed BO Reports/Dashboards in SAP Enterprise Portal.
• Created Reports with graphical representation such as Bar charts, Pie charts for multidimensional analysis using Explorer, Xcelsius and Dashboard.
• Implemented security features of Business Objects like row level, object level and report level to make the data secure.
• Used multiple data providers such as Universe and personal data files in generating report.
• Extensively worked in INFOVIEW to create Web Intelligence, Desk Intelligence Reports over the Universe Created.
• Experienced in working with Business Explorer (BEx) and publishing the reports on web using Web Reporting tools.
• Used Structures, Calculated key figures, Restricted key figures, selection, Formula, exception and conditions. Extensive experience in performance tuning, aggregates to improve the Reporting performance.
• Developed prototype and presented the demo session for user acceptance.