PROFILE:

• SAP BI/HANA Consultant with close to 10 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 HRM.
• 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 6 full life-cycle BW implementations. Around 5+ years of experience as Lead consultant and successfully performed various roles such as Technical Lead, Analyst, Developer in all the phases of a project life cycle.
• 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 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 preferences
• 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 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
• 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.
• Energy, Utilities
• Investment Banking
• Media, Television and Online Web Analytics
• Stock Exchanges, Trading Systems
• Processes and ticketing transactional processing,
• Capital Markets Banking, Loans, Hedging
• Clearing, BACS and Payment processing.
• Banking and ATM processing.
• Retail and Point Of Sale Transactional processing.
• Health & Leisure (Fitness/Sports) Membership Retail
• Travel industry airline, hotel, car and rail booking
• Global Language and Currency Data Warehousing

WORK EXPERIENCE:

Confidential, Sanjose, CA

SAP BI/BW HANA Team Lead

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 Training, 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 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 preferences
• 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, Dallas, TX

SAP BI / BWHANA Team Lead

Responsibilities:

• Managing 7.5 Million Budget with 23 onsite and 13offsite resources, Responsible in providing SAP architectural guidance and responsible for the design, build, and test of content deployed through the SAP BI 4.0, SAP BW 7.3, SAP HANA 1.0, BOBJ Tools for reporting, BPC and MDG.
• 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.
• 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, Houston, TX

SAP BI/BW/HANA Consultant

Responsibilities:

• SAP HANA POC: Extraction from SAP and Non-SAP using BODS, Analytical Views and Calculation Views using Information Module, SAP BW on HANA.
• Created attribute, analytic and calculation views for Sales and Procurement modules as part of the current POC.
• 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 training & 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 references

Confidential

SAP BI/BW Consultant

Responsibilities:

• Designing and building InfoObjects, InfoSources, ODS objects, Infocubes, update rules, update routines, and appending structures in SAP BW 3.5 environment like legal consolidations transactional cube.
• Creating and loading hierarchies via flat files on FS Item (Dimensional/Analytical P&L, Balance Sheet, Income Statement, Cash Flow for consolidations), Consolidated Unit, Consolidated Group in BCS and Global Product Platform, Sales Channel, Brand, Trade Partner in BW.
• 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.

Confidential

Business Intelligence ETL Development Specialist

Responsibilities:

• As a Senior BW consultant Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, unit testing (UAT) to Go live production support.
• Accountable for BI reporting for Sales, Billing and Finance modules.
• Worked with NIKE COE Architecture governance project and played an active role in the SAP BW upgrade project from BW 7.0 to BW 7.31 and the front end from 3.5 to 7.0.
• Actively involved in testing before and after technical upgrade till go live.
• Interacted with the business process owners and the end users to gather the issues in the upgrade and to resolve it and also involved in the KT sessions with the end users.
• Checked for inactive Update & Transfer Rules and activated the same. All inactive and update rules which are not required were deleted.
• Checked for inactive Multi-providers and activated which are required and deleted which are not required.
• Converted Query variants from 3.5 to 7.0 in all the systems using RSR MIGRATE VARIANTS and validated entries between RSRVARIANTDIR and RSRPARAMETRIZA
• Resolved the issues with variables with replacement path before and after aggregation with the program RSR VAR REPPATH AGGREGATION to remove the red X values in the columns.
• Resolved the issues of ITAB DUPLICATE KEY because of the inconsistency in the Multi-provider mappings by rebuilding the Multi-provider.
• Resolved the workbook single query refresh issue as it is obsolete in the front end greater than 7.0 and provided the KT sessions to the end users.
• Performed the inconsistency checks on the Bex tables with the ANALYZE RSZ TABLES and dealt with the duplicate query elements.
• Closely worked with testing department for developing and implementing test scripts.
• Performed Unit, Integrity tests and data consistency was verified with ECC 6.0.
• Added additional field ZZVASIND to the SO line item extractor 2LIS 11 VAITM which is already available in the table VBAP and the communication structure MCVBAP.
• Built a custom extractor to do a full pull of PIR mode of Transportation data from the SAP table ZTMM PIR DEF, Default to SMAART Via Teradata and BW.
• Created a process chain to reduce the manual activity of the 7 info packages one by one in sequence to load the data for partner function from Sunday to Friday except on Saturday.
• Performed LO-Cockpit extraction to pull data from ECC SD modules into BI system extracting the Header and Line item
• Dara from the Sales and Distribution(SD) modules Sales Order “ 2LIS 11 VAHDR/VAITM”, Shipping/Delivery” 2LIS 12 VCHDR/VCITM” and Billing “2LIS 13 VDHDR/VDITM”).
• Created Transformation Routines, Start Routines, End Routines as per the requirement and for the lookups from one DSO to other. Testing and Debugging of routines.
• Designed DSO’s for SD module for Sales Header, Sales order Item, Billing Items, Schedule line, Sales History, Sales Quota, FI/GL etc.
• Involved in Performance enhancement features such as Cube Indexing, maintaining Aggregates, Rollups and cube Compression.
• Handled Various Post Production Support Issues related to Short Dumps, Data Loading, Monitoring, Database Space.
• Created setup tables for the LO-Cockpit extraction, performing V3 update using LBWE to get the data from the outbound queue of the ECC system to the delta queue of the BI system.
• Created custom queries to compare and show sales according to region and cost center for the company products.
• Created reports to evaluate open items by due date for accounts receivable through BEx analyzer.
• Developed reports using query designer, BEx analyzer, Webi and xcelcius.
• Created customer exit/authorization variable, Restricted variable with BEx offset.
• Published the reports on the web using Web Application Designer using the wizard as well as drag and drop web items like ad-hoc, table and filter for creating customized web templates according to the user requirements.
• Extensively created Formula Variables, Conditions, Exceptions, Exception Aggregation, Cell editors, Customer Exit Variables and Structures for developing complex custom BOBJ reports.

Confidential

Business Intelligence Senior Developer

Responsibilities:

• Responsibilities include Production support like handling the data load issues on a day to day basis which includes monitoring, bug fixes and minor enhancements and developing of adhocBEx reports.
• Worked with Business Users very closely to gather the requirements, review the functional specs and help them resolve the production issues by attending various meetings.
• Used the tools like HPSM to resolve the production issues in timely manner.
• Launching the data loads as per client requirement on daily basis.
• Scheduling BW jobs, monitoring these Schedules on Process Chains Monitor and BW monitor.
• Responsible for Monthly Period End process loads for data coming from R/3.
• Data Extraction from R/3 and flat file, loading the extracted data into BW data targets.
• Designed and Developed Process chains for automating the Batch data load of Claims, Premiums, Sales and Expense data coming from Mainframes system.
• Involved in Performance Tuning and Data Maintenance by creating and maintaining Aggregates, Compression, Partitioning and Indexing of Info Cubes.
• Coordinated the BW transport collection using the BW Transport connection on BW side. Managed the transports between Dev, QAS and PRD systems. Validated the transported objects upon transport.
• Generated reports using BEx (Business Explorer) with variables, exceptions, restricted key figures, calculated key figures, conditions, formulas, RRI interfaces, filters, drilldown methods.
• Performed periodic cleanup in PSA. Extracted and loaded data from SAP R/3 into Sales Order InfoCube using Data Sources.
• Effectively handled Flat file and master data loading to the DSO's and Cubes.
• Handled effectively the change requests for the DSO's and Cubes and queries.
• Worked on creating transport requests and Releasing to the test and production servers.
• Resolved many issues that came in production support.
• Coordinated with Users on the BEX queries, maintained Jump targets, variables; assigned workbooks to roles, Configured Bex Browser.

Confidential

Business Intelligence Senior Developer

Responsibilities:

• Involved in requirement gathering from users and Modeled data targets according to the reporting requirements. Worked with teams to discuss/review technical specifications and functional requirements.
• Created and configured Data Source, Transformations, DTP, DSOs, Info cubes, Multiproviders, Info Sets, Open Hub, and managed data loads into Info Providers via Process Chains.
• Based on the project requirement enhanced Data sources and created several routines using ABAP/4
• Used Routines (Start Routines, Update Routines) in Update rules and Transformations, user exits to Update Key Figures and Characteristics in the Info Cubes.
• Experience in web application development and web reporting and extensive experience in Front End BW components like Workbooks, Queries, Calculated key figures, Restricted key figures, structures, variables, Formula Variables, Filters, Restrictions, Conditions, Navigational attributes, Adhoc Reports and Web Reports etc.,
• Transferred data from Info Provider to Flat Files by using Open Hub (Info Spoke) and loaded data to the data targets from different sources (R/3, Flat Files).
• Expertise in the Performance techniques like Performance tuning, Aggregates, Compression, Indexes, Statistics and Rollups (Performance Improvement).
• Involved in documenting Functional specifications, Technical specifications, Test cases, Test results and Production support documents.
• Developed weekly, monthly Quarterly reports on various products based on user requirements.
• Involved Technical documentation for all the Changes End to end and Created new Reports.
• Supported all phases of a project life cycle including analysis, design, development, configuration, testing, and development of solutions, as well as documentation, and end-user training.