PROFESSIONAL SUMMARY:

• SAP certified BW/BI/HANA consultant around 16 years of professional experience which includes 10 years in SAP HANA,SAP BI/BW7.4,BI 7.3,BW 7.0, BOBJ4.0/4.1 versions and worked on SAP BW ABAP& SAP BPC & SAP BPS & IP
• Worked on gathering requirements and structure for the application.
• Modeled and design the application on SAP BW/HANA space
• Communicate to SAP via OSS for problem solving
• Worked on design technical solution and writing technical Specs for BI solutions.
• Worked on planning and executing of BI developments, testing and hyper care support for the clients.
• Worked on support issues, documentation the issue with co - ordination with offshore team members
• Trained on TABLEAU, QLIKVIEW and trained & worked on Lumira & reporting strategies on SAP BW powered by HANA
• Successfully lead technical teams in both SAP BI/BW and R/3 implementations. Worked on both onsite and offshore resource models.
• Strong communication skills with demonstrated ability to coordinate activities with offshore team, business, and functional leads spread across the US, Europe and Asia.
• Expertise in 4 full-cycle implementation projects in ASAP methodology starting from requirements gathering, design, development, testing, production, go-live, and post go-live support.
• Worked in 5 support and 2 up gradation projects and 1 rollout project.
• Strong experience in SAP FI-CO(AP,AR, GL,AA,FM,GM,PC,CCA),HR( LSO,Benefits,OM,Payroll) SD, MM,CRM and SCM modules.
• Extensive experience in acquiring data from SAP and non-SAP source systems including flat-file, UD connect and DB connect from Oracle database tables, also worked on HR Workday module
• Strong experience in BI 7.4, developing Info objects, DSOs, Info cubes, Multi providers and Info providers.
• Experience in activating and customizing Standard Business Content (BI Content) following SAP Best Practices guidelines, extending and enhancing using User Exits according to the end-user requirements.
• Capable of creating highly complex transformations including development in ABAP/4 Programming, comprising of Start routines, Field routines, End routines for data load processes involving multiple layers of data targets. Also worked on development of datasources based on Query and View in generic extraction scenarios in SAP ECC 6.0
• Extensive experience in collecting all the developed objects (Infoproviders, Queries, Roles, Workbooks, DSO, and Infocubes) for transport using STMS and automating and monitoring data loads using Process Chains.
• Strong expertise in reports development using BEx Query Designer and BEx Analyzer. Created complex Formula Variables, Calculated Key Figures, Restricted Key Figures, Exceptions, and Conditions to facilitate business requirements.
• Highly experienced in creating Cube Compression as aggregates, Cube partitioning, and creating indexes for optimization and better performance of BW BEx Queries.
• Extensive experience in developing complex analytical reports using BOBJ tools that includes Webi, Universe Designer, Business Objects Launchpad (Infoview), Dashboard Designer (Xcelsius), CMC, and Crystal Reports.
• Extensive experience in performing UT, UAT and system testing on developed objects. Also having experience in Solution Manager, SM7, Service now, OVSC tool and BMC remedy tool.
• Highly experienced in troubleshooting and optimization of data loads and query performance.
• Involved in Post-Production support that includes monitoring of process chains and data loads, reconstruction of data targets in case of failed loads, rescheduling of process chains, debugging of transfer and update routines.
• Good exposure to Project Management activities and involved in all the phases of Project Management & experience of helping Practice Heads/Sr Managers in building the Proposals and handling requirement gathering workshops.

TECHNICAL SKILLS:

Datawarehouse: SAP BW 7.4/SAP BI 7.3,SAP BW 3.5 SAP ECC 6.0,BO4.0/4.1

Programming Languages: C, C++, ABAP/4

Web Development: HTML 5, CSS, JavaScript, XML 1.1, Visual Basic, Script Logic

Databases: MySQL Server 5.5, MS Access 2010, MSSQL Server 2008 R2

Software Development IDE/Tools: SAP Enterprise Portal (EP 6), Portal Content Studio, SAP Solution Manager (SOLMAN) 7.1, ServiceNow (SNOW), MS Visual Studio 2010

Reporting tools: BEx Query Designer, BEx Analyzer, BEx Web Application Designer (WAD)BO Launch pad (Info view), Universe Designer,Tableau,Qlik ViewCMC, Information Design, WEBI, Lumira

Software Suites: MS SharePoint, MS Office (Visio, Excel, Word, PowerPoint)

PROFESSIONAL EXPERIENCE:

Confidential, Ft. Lauderdale, FL

SAP BW/HANA/BI Analyst

Responsibilities:

• Worked on design technical solution and writing technical Specs for BI solutions.
• Co-coordinating with client for the requirement and proving them the test result for the object.
• Worked on planning and executing of BI developments, testing and hyper care support for the clients.
• Worked on support issues, documentation the issue with co-ordination with offshore team members
• Successfully completed the SAP HANA implementation with side car approach.
• Build the Information view for SAP sales and Inventory with real time data
• Designed and build ETL process using BODS and SLT
• Worked on SAP HANA Administration, Performance Optimization.
• Modeling using Different types of views, SQL, SQL.
• Expert in data modeling and provision & Well verse with semantic layer
• Very good understanding of the required reporting tools for SAP HANA like BOBJ including Crystal report, WEBI
• Created and published stories in Lumira server, cloud and lunch pad
• Experienced in designing the Universe and worked BO Security
• Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
• Restricted data for particular users using Row level security and User filters
• In SAP BI 7.3, In Finance (Accounts Receivable), worked on Datasources 0FI AR 4, 0FI AR 6, and 0FI AR 10, and Infocubes 0FI AR C03, 0FI AR C02 and DSO 0FI AR O03 and 0FI AR O06.
• Involved in Extraction of Data from SAP ECC to BW using LO Cockpit for Sales Order Header, Sales Order Item, Billing, Delivery and Purchase.
• Validating and testing the data in BI Cubes, DSOs (Data Store Objects) with respect to the PSA, extract checker (R3-RSA3), and the associated R3 tables such as FAGLFLEXA, FAGLFLEXT, BKPF, BSEG, BSAK, BSIK, BSAD, BSID
• In New General Ledger, extensively worked on the New GL Balances Datasource 0FI GL 10 that extracts the totals records from the leading ledger in the new General Ledger.
• Using the delta method to transfer each new status of the changed line item on the Datasource 0FI GL 14.
• Implemented BW statistics administration to check the process chain and info provider load
• Worked on the New GL Transaction Figures Infocube 0FIGL C10 that contains all the transaction data (transactions figures) from the leading ledger in new General Ledger Accounting that was loaded from the ECC system.
• Loading data and building queries on the Info cube 0FIGL R10 using the Remote Cube to select current data in real time as it is not necessary for the data to be replicated in InfoProviders.
• Creating New GL Balance Display Queries 0FIGL C10 Q0001 to analyze the transaction figures in the G/L accounts.
• Performing drilldowns and setting filters on this query using the characteristics Segment, Profit Center, Value Type, Functional Area, Cost Center, G/L Account, and Fiscal Year/Period.
• Created and modified the WEBI report based on the BEx query.
• Representing the BW/BI team for PR(Problem Review) meeting and providing the updates to the management.
• Working on all the performance tunings for ABAP coding for routines and extractors.
• End to End implementation payment history report with weighted average arrears.
• Created BADI for more than 30 data sources and Customer BEx Exits.
• Resolving errors and exceptions in the BI system during transport by analyzing the transport logs in SE09
• Performing Unit Testing, Integration Testing, and User Analysis Testing. Writing and uploading test scripts to HP Quality Center (HPQC) 10.0. Identifying and resolving defects during execution of the scripts to promote to production.
• Providing Hypercare and Post-Production support and monitoring background job logs and job statuses in the SAP BW system.

Confidential, Santa Clara, CA

SAP BI/BW Lead Analyst

Responsibilities:

• Worked on planning and executing of BI developments, testing and hyper care support for the clients.
• Worked on support issues, documentation the issue with co-ordination with offshore team members
• Worked on development of BI objects, testing the object to move the changes to Quality environments
• Developed visualization reports in Lumira from HANA database, excel sheet and SAP BW.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Design Dashboards using Filters, Parameters and Action Filters
• Worked on SAP HANA Administration, Performance Optimization, Modeling using Different types of views, SQL, SQL Script topics
• SAP HANA Data provisioning using SAP Landscape Transformation and SAP Data services, DXC, Flat File up loader, SAP HANA architecture.
• Worked on BO 4.0 like Information Design Tool, Interactive Analysis Desktop and Launch Pad.
• Expert in data modeling and provision & Well verse with semantic layer
• Expertise in SAP BW (Business Warehousing, BW Administration, BW Extractors, ODS, Info Cubes, Info Sources, InfoObjects,and BEx Reporting), SAP Applications Integration with non SAP
• Worked on the data sources 2LIS 01 S261, 2LIS 12 VCITM, and 2LIS 12 VCSCL to model and load data to the BW system.
• Extensively used Calculated Keyfigures 0SD C04 CK001,0SD C04 CK002, 0SD C04 CK003, 0SD C04 CK004, and 0SD C04 CK005to calculate the total number of delays between confirmed and actual delivery dates over the total number of schedule lines.
• Enhanced Quotations Infocube 0SD C05 to view general figures for quotations, including the Number of Quotations created, Net and gross value of the Quotations and the Number of Quotations rejected. Also calculated the success rate of quotations by comparing quotation and order quantities.
• Gathering the requirement from the end users.
• Created the TCE Non Oracle Parts report
• Involved in data loading, Testing the Integration, Data Consistency and the Reports
• Worked on End routine to derive the plant from the Business Group in Transformations
• Worked on the include program to get the required dates for variables.
• Working on creating all BO reports from BEx Query
• Checking the Code in Transformations, Start & End Routines.

Confidential, Shreveport, LA

SAP BW/HANA & Analytics Manager

Responsibilities:

• Created information objects like packages, attribute views, analytic views and calculated views to develop model that supports Order to Cash (OTC) flow.
• Been responsible for communication with functional team for clarifications required on source tables.
• Worked on modeling concepts like hierarchies, restricted and calculated columns, filter operations, variables and input parameters
• Created calculation view with star join from different source views.
• Worked on Analytic Privileges to restrict data at row-level access.
• Replicated MM & SD source table’s from SAP ECC to SAP HANA using SLT.
• Experienced over import and export functionalities to get models and FLAT files (CSV) into HANA studio to create information models.
• Worked on HANA team for implementation and deployment of the solution which includes functional areas of Procurement, Quality.
• Views generated in HANA can be consumed by Design studio and dash boards.
• Designed and developed the Profit Centers Transaction Data Infocube 0PCA C01 containing all of the period totals for profit and loss accounts and balance sheet accounts from (PCA), which were loaded from the affiliated source system(s).
• Working on creating BO reports from BEx Query report in SD,FI,HR modules
• Analyzing the Inactive Info objects, cubes, DSO’s and delete/Activate/Modify the Objects in the development system.
• Involved in Testing the Integration, Data Consistency and the Reports before and after Up gradation.
• Checking the Code in Transformations, Start & End Routines.
• In Asset Accounting, worked on the Datasource 0FI AA 11 to supply the transaction data and annual plan values for fixed assets
• Managing and co-coordinating the external vendors for the requirements and regular supports
• Creating sale, process and analytical reports for Sales force team based on requirements.
• Involved in Up gradation from 7.3 to 7.4 SAPA HANA Compatibility objects
• Worked on the Commitment/Actual and Budgets Infocube 0FIFM C01 that contains all the transaction data transferred to the source system, for the budget (overall budget, annual budget, and periodic budget), and for the assigned funds, as well as commitments/actuals postings).
• Created Overall Budget Queries 0FIFM C01 Q001 that shows the budget planner which overall budget is posted in an FM area and in a budget version.
• Developed Universes in BOBJ and reported on Sales Revenue and PSR daily reports .
• Tested and Validated BEx Query report, Transport requests and Process chains .
• Developed Generic Data source to bring the data from Custom tables of R/3 to BI.
• Using Function modules Se37 and Se38 for enhancing Customer exits for Transaction data.
• Installed new BI statistics content and included them into batch job scheduling process.
• Coordinated with Basis & performed transports, performance tuning, bugs fixing and applied OSS notes

Confidential, NY,NY

SAP BOBJ/BW/HANA Lead Consultant

Responsibilities:

• Worked on a POC for Native HANA
• Involved in Up gradation from 7.3 to 7.4 SAPA HANA Compatibility objects
• Emptying all the Queue’s during down time and Re-initializing the Delta’s.
• Analyzing the Inactive Info objects, cubes, DSO’s and delete/Activate/Modify the Objects in the
• Involved in testing the Integration, Data Consistency and the Reports before and after Up gradation.
• Checking the code in transformations field, start, end & expert routines
• Extensively worked on SD, MM & FI modules to extract the data from SAP ECC to SAP BW systems.
• Worked on LO extractors 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 12 VAHDR, 2LIS 12 VAITM, 2LIS 13 VAHDR, 2LIS 13 VAITM, 2LIS 02 HDR, 2LIS 02 ITM & 2LIS 02 SCL.
• Designed and developed cubes and DSO 0SD C01 (Customer), 0SD C02 (Delivers), 0SD C03 (Deliveries), 0SD O01 (Order Items), 0SD O02 (Returns Items), 0SD O03 (Returns Items) adding purchase order no and item no and 0PUR C01 (Purchasing Data)
• Executed Infocubes for FI AP, FI AR and Vendor invoice payments and created DSOs to extract data

Confidential, NY,NY

SAP BOBJ/BW Lead Consultant

Responsibilities:

• Gathering the requirement from business user and Prepared the business blueprint
• Activated the BI contents and created the back end objects DSO,Info cube, Info Object and Multi provider
• Created 6 new LSO reports for LSO(Instruction Information,Pre-Booking For Course Type etc)
• Worked on WAD and created many templates for the customer requirements.
• Created Jump report from BW to BW and also BW report to ECC Transaction for a particular info type.
• Written ABAP code for the HR extractors for populating the data from ECC.
• Driving daily data load calls to ensure support client WCMC achieve agreed SLA
• Driving BI Performance calls and Driving Weekly Incident calls
• Driven BI Upgrade activities from 7 to 7.3 version and preparation for 7.4 version
• Created event based process chain and also flag, monitor etc through ABAP code.
• Worked on BAdi for the LSO extractions.
• Wrote ABAP code in start routines, end routines and field routines.
• Wrote ABAP code in CMOD (RSR00001) for global variables of queries.
• Created Input Variables, Authorization Variables and replacement path variables in BE x Queries.

Confidential, NY,NY

SAP BW/BO Lead Consultant

Responsibilities:

• Worked in designing and development of multiple projects from extraction to reporting in BEx.
• Extensive interaction with the end users, understanding their requirements and implementing the same.
• Worked extensively on data modeling and reporting in BW.
• Developed the Fringe Benefits Report by GL.
• Created the aggregates for a particular query.
• Worked on WAD and created many templates for the customer requirements.
• Created Jump report from BW to BW and also BW report to ECC Transaction for a particular info type.
• Written ABAP code for the HR extractors and FI extractors for populating the data from ECC.
• Created event based process chain and also flag, monitor etc through ABAP code.
• Worked on Solution manager for tracking the incident and worked on semantic keys for DTPs.
• Working on incidents P2, P3, and P4 of mentioned below Applications
• Supporting on SAP FI, HR, SRM BW report like Employee Plan funding report, Employee Basic data report, Research Visibility report
• Supporting on DR Testing activity and on change Request

Confidential

SAP BW/BPS Consultant

Responsibilities:

• Identified data sources based on end-user reporting requirements and created InfoCubes from the data extracted from different modules like SD & MM using LO Cockpit
• Implemented data warehouse layer with DSO to support SD, SCPM and FI-AR document level data storage.
• Implemented new Info-Cubes, multi-providers, and Real-Time cubes to support SD, FI-AR AP reporting requirements
• Developed Aggregation Level, Planning function, Input-ready Query and Planning Application
• Tested above functionality in different systems before go live.
• Providing daily Production Support from Offshore
• Working on incidents P1, P2, and P3 of mentioned below Applications
• Supporting on SAP BPS HR BW report like Activity Forecasting Data Report, Supply and demand report.
• Supporting on YEC activity report, in BPS and MEC activities.
• Supporting on SL Performance Investigation.

Confidential

SAP BW/BPS/IP Lead Consultant

Responsibilities:

• Designed an SAP analytical model for optimization of transport chains
• Providing daily Production Support 8*7 from Offshore (Approximately 900 Daily Loads).
• Working on incidents P1, P2, and P3 of mentioned below Applications
• Supporting on SAP S&D- BW report like Sales and Margin report, Pipe line report.
• Supporting on FINANCE Karma report, ROFO (Rolling Forecast) in BPS and MEC activities.
• KARMA application is majorly used for calculating the Margins on the weekly basis and EBIT per month as Part of the month end process. It is considered to be one of the most critical applications and has got high visibility across management
• Supporting on CL STIP (Speed Transparency in Report) application.
• Working on ROFO, Rolling Forecast of CL using BPS for Cost & revenue Planning
• ROFO application provides the functionality of financial planning to the business users quarterly.
• Processes and data loads are dependent on KARMA, Local Planning tool (GPT). This application is also Critical as the financial planning data goes to Corporate Warehouse which contains the data for all the Business sectors.
• Solved the issues regarding locking problems in BPS that arose during ROFO support
• Working on adaptive changes and problem managements.
• Performing the BI support production role activities like administration scheduling, monitoring & fixing the Bugs.
• Handling & dealing the incidents/interactions/calls raised by business on all priorities.
• Interacting with business, providing the solutions & feedback to the client on the work related activities.
• Continuous monitoring on system to improve the database performances & data quality factors.
• Guiding to the junior resources on work and process related activities & mentoring the resources.
• Sitting for technical evaluation as BI member in Interview panel team

Confidential, Chicago, IL

SAP BI Lead Consultant

Responsibilities:

• Involved in production support which involved maintenance of daily loads
• Worked on Data stage and CRM areas
• Developed report for customer requirements
• Used Open Hub Services to update the DB Tables in Production System
• Involved in design, development of Multi dimensional Data Models and mapping of info source with the data targets using update rules.
• Enhanced the Data Sources.
• Enhancing the queries based on the scope document.
• Successfully driven BI service transition activities and developed Internal BI Teams
• Worked on the CR like adding the new enhanced fields to the query
• Customized & Created Info cubes and ODS objects for various scenarios.
• Created info package, DTP, Transformation, Data Sources, Update rules, and Start routine
• Created Process chain for various module.
• As a SAP BW Lead consultant specializing in data extraction OLTP (R/3) respectively.

Confidential, Chicago, IL

SAP BI Lead Consultant

Responsibilities:

• Written routines in update rules and Created info packages
• Involved in data extraction from COPA
• Creating the process chain for master data and transaction data
• Worked on Data stage and CRM areas
• Developed report for customer requirements
• Used Open Hub Services to update the DB Tables in Production System
• Successfully Involved in SP 18 Up gradation
• Involved extensively developing and modifying the Documentation tasks to upload in share drives
• Extensively Involved in Creating CR’s and transporting them to Production across the system landscape through PTT
• Resolving the issue through using the OVSC and unicenter ticketing tracking tool.
• Worked on small enhancement on Administration workbench objects like Analysis Process Designer, open Hubs & BI Accelerator
• Taking interviews for SAP BI resources for the Sara Lee project as well for IBM.

Confidential

SAP BI Senior Consultant

Responsibilities:

• Deliver current MfgPro business functionality in SAP BW using ECC 6.0 and BI 7.0 tools and techniques
• Leverage on existing Fusion1 capability
• Adopting best practices as exists within Unilever and other organizations
• Reports and KPI delivery options through BI 7.0 suite
• Provide business users with rich user interface to improve their productivity
• Consolidate all HUL systems on the SAP platform and align with Unilever global standards.
• Enable robust and standardized integration between underlying R3 modules, WPC and BI layer leading to reduction in time spent by IT teams on operational / maintenance activities
• Worked on SALES TAX Management System which is an application designed using BW Open hub functionality.
• Configured and activated Business content according to the requirement based on the Application areas.
• Developed Six Info Spokes through Open Hub Services (OHS) on Sales Extract, Purchase Domestic, Purchase Imports, Stock Transfer In, Stock Transfer Out Scenarios and Stock Ledger to export data from the data targets to external logical source.
• Created ODS Objects and Delta Updates from ODS Objects to Info Cubes, Multi providers.

Confidential

SAP BI Consultant

Responsibilities:

• Monitoring Data load failures through RSMO.
• Monitoring Process Chains Daily/weekly/monthly.
• Check Aggregates Rollup.
• Checking data targets are ready for reporting.
• Checking for failed or cancelled jobs in sm37 monitors and BW Monitor.
• Also to note down time taken for loading of critical Info cubes, which are used or reporting
• Monitor and take corrective action depending upon the failure
• Checking SM12 for any locks and Loading any of the missing master data attributes/texts.
• Changing the schedules of process chain as and when required.
• Monitoring the data transfers from Source Systems into BW with Full update and Delta mechanisms.
• Extracting data from SAP R/3 as per requirements, invoices and GIR’s.
• Managing Aggregates, Partitioning and Compressing Info Cube to improve query performance.
• Deleting Change log table data & PSA data.
• Monitoring and Managing of ODS object, Info Cubes and PSA requests.
• Handling tickets regarding extractions, Performance Issues and also load failures as part of tickets raised by L1 team in solution manager.

Confidential

Field Support Engineer

Responsibilities:

• Provides software based solutions for corporate sectors for multiple clients along with business solutions for the industrial sectors, service providers, and al institutes. Also provides all types of SMS solutions And Kiosks
• Analyzing system logs and identifying potential issues with computer systems
• Introducing and integrating new technologies into existing data center environments.
• Performing routine audits of systems and software
• Performing backups
• Responsibility for documenting the configuration of the system
• Troubleshooting any reported problems
• System performance tuning.
• Applying operating system updates, patches, and configuration changes
• Installing and configuring new hardware and software
• Adding, removing, or updating user account information, resetting passwords, etc