SUMMARY

• 10+ years of experience in SAP BI/HANA/BOand SAP ECC design and Integration of LO, MM, FI, CO, BPC, PP, HR, HCM, and SD modules.
• Involved in Business Content Activation, Enhancement of data sources and writing user exits (Master data and transaction data) on R/3 and BW
• Extensively involved in setting up of procedures for extracting data from SAP R3 by using Generic Extraction and Customizing FI by using enhancements
• Implemented4 full life cycle SAP BW/BI projects.
• Working noledge of SAP ASAP methodology in Software Development life cycle (SDLC).
• Worked in FI, SDand MM modules creating and working on Data store objects and infocubes
• Created Process chains for Master data and transaction data loads.
• Loaded Transaction Data and Master Data via Flat files
• Extended Transaction data & Master data by appending new data elements using enhancement component
• Involved in creating and maintaining Info Cubes, DSO, PSA, Info Objects, Info Areas, MultiProviders, Data Sources, and Info Packages.
• Expertise in building the Universes Designer, developing the reports usingBusiness Objects - WebI, Dashboard designer and Crystal reports.
• Highly proficient experience in SAP Business Intelligence, HANA, BODS and Business Objects, dis includes good exposure to Implementation, Development and Support.
• Strong noledge on SAP BI Modelling, Extraction and reporting which includes BEx suite and BO Reporting Tools.
• Expert in building HANA Enterprise and BW on HANA Landscape from Data Provisioning to Reporting.
• Strong work experience on SAP BW on S4 HANA and BOBJ tools.
• Proficient in loading data from different sources to HANA using SAP Data Services with good exposure to all the transformation available, repository creations and scheduling the jobs in Management Console.
• HANA Analytics including HANA Live solutions. Design and Develop complex HANA Scenarios using Attribute, Analytical and Calculation Views. HANA Data provisioning using SAP LT Replication Server (SLT), Sybase Replication Server or Data Services, DXC. Deploy HANA based Solutions for real-time reporting. Advise customers on using the right Applications/tools/approach for HANA. Application Optimization for S4 HANA
• Experience in creating planning solutions in WAD including data binding in WAD.
• Excellent noledge in gathering business requirements, analyzing the business process, Implementation, Designing, Configuration, Customization, Unit/Integration testing, Go-live and Post-go-live support.
• Leading offshore HANA team at client location which is responsible for providing HANA Solutions globally.
• Transporting the objects from Dev Server to Prod Server
• Managed user Authorization & roles (PFCG)
• Experience inABAP programming in ECC 6.0
• Participated in GO LIVE and Production support
• Generated reports using BEx (Business Explorer) with variables, exceptions, restricted key figures, calculated key figures, conditions, formulas, RRI interfaces, filters, and drilldown methods.
• Scheduled Process Chains for full and periodic data loads
• Expertise in building the Universes Designer, developing the reports usingBusiness Objects - WebI, Dashboard designer and Crystal reports.
• Lead and manage teams responsible for designing, developing and supporting the SAP RICEFW (Reports/Interfaces/Conversions/Extensions/Forms/Workflow) objects
• Expertise in SAP BW 7.4 on HANA,7.3, 7.1 & 3.5 configurations, Reporting and OLTP Extraction.
• Experience in Business content activation, Data Extraction, Generic Extraction, Data Load Scheduling, Monitoring, Info cubes, Info Source, LIS and LO Cockpit
• Proficient in 3-Tier SAP BW Architecture including Extractors, Info Objects, Info sources, ODS Objects, Info Cubes, Info Packages, Open Hub and Hierarchies
• Participated in all phases of life cycle including Requirement Gathering, Development, Testing, Deployment solutions, Post production Support, Documentation, User training in SAP BW (Front-End)
• Extensively worked on transporting objects between BW system environments and corresponding SAP ECC systems.
• Experience in design and development of Queries, Reports, Workbooks and Web reports publishing BEx Query Designer, BEx Analyzer and Web application designer (WAD).
• Excellent communication skills and ability to work effectively in fast paced environments
• Ability to manage all facets of the System Development Life Cycle

TECHNICAL SKILLS

Environment: s: SAP BI/BW3.5, 7.0, 7.3, 7.4 SAP B04.0, BEx 3.5, SAP HANA 7.0 Office Analysis,Fiori, ECC 6.0, 7.0 Net weaver(MM,SD,FI - GL,FI CA&CO) Qlickview BI

Programming Languages: HTML and SQL

Database: Oracle, SQL Server, (OLTP & OLAP), HANA.

Operating Systems: Windows Server 2003, 2008.Unix&Linux.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SAP BI/ HANA Solution Architect

Environment: SAP BI 7.3, 7.4 on HANA & ECC 6.0, SD, MM, FI, APO,QA Business Objects, BODS& BEx (WAD, Query Designer, Web Reports)

Responsibilities:

• Handling the tickets of various priorities posted by the user following and confining to the SLAs by maintaining work history until they are resolved.
• Involved in data validation and reconciliation activities to check consistency of data between BI and ECC.
• Worked on data load and performance tuning activities like Aggregates, Compression, indices, Multiproviders and statistics.
• Data modeled COPA extractor and enhanced additional fields which are not available in the COPA datasource.
• Worked with Business content extractors for General Ledger, Account Payables & Account Receivables to extract data from ECC System
• Created custom extractors using ABAPto pull required data from various tables
• Created cubes, DSOs andMulti-providers to store data and reporting
• Created BEx and Webi reports
• Created start, end and expert routines as needed
• Created both Functional and Technical design documents
• Expertise in transporting objects from Dev to Production across Landscapes
• Worked extensively on BEx Analyzer and created queries using BW-Reporting Variables, Navigational attributes, Exceptions, Conditions in queries to facilitate Data analysis in a drill down or summarized way to give detailed levels of information.
• Maintained reconciliations of the reports and verified the data in SAP ECC and SAP BI for the data loads.
• Customization of reports as per theClient's requirements.
• Worked on data loading issues and report related issues
• Expertise in Bex-Involved in creation of reports using Conditions, Restricted Key figures and Customer exit variables
• Created and maintain the users, assigned the appropriate roles to the users
• Worked on Hana upgrade.(* Many integrating apps(Hyperion) ETL, Backend, Reporting Hana 7.4 upgrade ABAP, Hana optimization POS DM 1.0 changes in Hana 7.4 Dataflow, cube optimization greenfield approach PCA Delta migration BW modeller (future Hana Modeler) tool, open DS view, EhP5 to EhP7 standard/custom extractor SAP PI integr platform DSS, File integrations, RSS)
• Worked on building HANA Enterprise and BW on HANA Landscape from Data Provisioning to Reporting.
• Worked on integrating HANA Enterprise, SAP BW on HANA and BOBI tools.
• Loading data from different sources to HANA using SAP Data Services with good exposure to all the transformation available, repository creations and scheduling the jobs in Management Console.
• Excellent noledge in gathering business requirements, analyzing the business process, Implementation, Designing, Configuration, Customization, Unit/Integration testing, Go-live and Post-go-live support.
• Involved in Unit testing, me.e. to monitor the data whether it loaded correctly or not, checking the PSA, tables etc.
• Performed responsibilities of conducting regression testing, script management, and preparing test suites
• Assigned the tasks of debugging and documenting manual test cases
• Responsible for reviewing test progress and update the status to the project lead
• Handled responsibilities of developing system verification plans and testing user acceptance
• Assigned the tasks of performing functional and system regression testing under the instructions of senior staff
• Performed other job responsibilities as assigned under the instructions of senior staff
• Involved in HANA Analytics including HANA Live solutions. Design and Develop complex HANA Scenarios using Attribute, Analytical and Calculation Views. HANA Data provisioning using SAP LT Replication Server (SLT), Sybase Replication Server or Data Services, DXC. Deploy HANA based Solutions for real-time reporting. Advise customers on using the right Applications/tools/approach for HANA. Application Optimization for HANA

Confidential, Lexington, KY

SAP BI/HANA Lead

Environment: SAP BI 7.3, 7.0 & ECC 6.0, FI, CO, HR, HCM, SD, MM, SCM, SRM, WM, PM, IM, AFS, POSDM, BPC, Business Objects, BEx (WAD, Query Designer, Web Reports)

Responsibilities:

• Identified and Installed the Business content data sources, info sources, ODS Objects and info providers
• Extracting data from R/3 to BW using LO, Generic& Flat File extraction.
• Worked with Business content extractors for General Ledger, Account Payables & Account Receivables to extract data from SAP R/3.
• Worked with Business content extractors for General Ledger, Account Payables & Account Receivables to extract data from SAP R/3.
• Creation of Routines in Transformation to meet the business requirements.
• Creation of Info cubes, ODS, Multi Providers and Info sets.
• Analyze the data model/data mart to design the universes for OLAP and Relational DBs.
• Involved in data warehousing to achieve optimum user requirements and created structure of different universes.
• Resolved the loops and tested the designed universes on relational database in Business Objects designer.
• Used drill-down analysis in Business Objects, which will allow the user to view data at a more detail level and from different angle.
• Developed the Revenue (Premiums), Expense (Claim Payments) and Profitability reports with multiple data providers in Business Objects.
• Used ABAP coding for start, end and expert routines
• Used Open Hub & info spokes to extract data from BW to 3rdparty systems
• Involved in creating custom transactions for end users to trigger events when system goes to production
• Worked on HANA Live solutions. Design and Develop complex HANA Scenarios using Attribute, Analytical and Calculation Views. HANA Data provisioning using SAP LT Replication Server (SLT), Sybase Replication Server or Data Services, DXC. Deploy HANA based Solutions for real-time reporting. Advise customers on using the right Applications/tools/approach for HANA. Application Optimization for HANA
• Involved in the collection of objects in development and transporting them to Quality for testing and eventually to production
• Involved in troubleshooting failed transports and recollection
• Involved in writing scripts and unit testing using HP Quality center
• Involved in end user training and creating training material.
• Excellent experience in the star schema model
• Worked with Universe designer based on SAP Business Warehouse/ Bex data in Excel form and based on project requirements
• Created Alerts, Ranking and Drill down Reports based on Sales, Customers and Status.
• Created User prompts, Conditions and Filters to improve report generation.
• Created BEx Queries and universes for BOBJ reports

Confidential

SAP BW/ABAP Consultant

Environment: SAP BI 7.0 & ECC 6.0, FI, GAAP, CO, HR, SD, MM, PM, OCM, SCM, BEx (WAD, Query Designer, Web Reports)

Responsibilities:

• Business requirement gathering from the business users, analysis and design.
• Identified and Installed the Business content data sources, DSOs and info providers
• Extracting data from ECC to BI using LO, FI, COPA and Generic extraction.
• Worked with Business content extractors for General Ledger, Account Payables & Account Receivables to extract data from ECC
• Involved in Designing of Modelling Technical Specs, Report Technical Specs.
• Enhanced Business Content data sources according to the user requirements
• Created info Cubes, DSO, Transformations and DTP for Data Loading through Process chain from Source System.
• Involved in the Unit Testing and Integration testing.
• Involved in post implementation Support, Bug fixing, maintenance and trouble shooting.
• Extensively involved in Production Support by loading Daily loads/Weekly loads into the BW system from different source systems.
• Involved in BWA index activities on Data loading and Query performance.
• Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management for SD Application.
• Created and worked on daily basis with LO-Cockpit, Generic Data Source, Info Source, Transfer Rules, Update Rules & Info Package.
• Designed Info Sources, activated Pre/Post transformation rules, scripted extraction routines for master data, texts and hierarchies.
• Setup procedure for extracting R/3 data for Customers, Sales Order, Delivery in Sales and Distribution (SD) using LO-Cockpit.
• Installed Business Content Info Cubes, Info Sources from BW Side.
• Involved in Info Cube maintenance me.e. Compression, Aggregates and Roll-up.
• Actively and regularly involved in Load Monitoring of Daily, weekly and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Created and maintained Users
• Created and Maintained Analysis Authorizations
• Assigned User Authorizations and user Roles to Users.
• Implemented Process chain Alerts for Failed processors.
• Created bucket reports based on requirement.
• Resolved Performance issues..

Confidential

SAP BW/ABAP Consultant

Environment: SAP BI 7.0 & ECC 6.0, FI, GAAP, CO, HR, SD, MM, PM, OCM, SCM, BEx (WAD& Query Designer)

Responsibilities:

• Gathered information from end-users based on their needs
• Developed BW objects such as Info Objects, Info Cubes, Data Sources, and Info Sources
• Extracted from legacy applications using DB Connect & XML
• Responsible for data loading dat includes master data and transaction data
• Uploaded master and transactional data from files and SAP as the OLTP source
• Implemented SD MM&FI Modules developed ETL Flows.
• Installed SAP Standard Business Contents from SAP BW and SAP R/3 Systems.
• Involved in designing in reports
• Involved in solving Data loading Performance issues and issues raised by the testing team during the testing phase.
• Worked extensively on LO Cockpit Extractions. Loaded the data from r/3 to BW and used Initialization with delta updates and full updated methods.
• Involved with performance tuning of Queries by maintaining Aggregates, Compression, partition and Indexing of Info cubes.
• Installed SAP Standard Business Contents from SAP BW and SAP R/3 Systems.
• Hands on experience in creating and automating processes with Process chains, Master data Info packages and back ground jobs etc.
• Expertise in transporting objects from Dev to Production across Landscapes
• Worked extensively on BEx Analyzer and created queries using BW-Reporting Variables, Navigational attributes, Exceptions, Conditions in queries to facilitate Data analysis in a drill down or summarized way to give detailed levels of information.
• Maintained reconciliations of the reports and verified the data in SAP R/3 and SAP BW for the data loads.
• Involved in Unit testing, me.e. to monitor the data whether it loaded correctly or not, checking the PSA, tables etc.
• Customization of reports as per Client's change requirements

Confidential

SAP BW/ABAP Consultant

Environment: SAP BW 3.5 NW Versi SAP R/3 4.6C, SAP BW 3.0B,3.5, BEx (WAD, Query Designer, Web Reports), SAP BW Scheduler

Responsibilities:

• Business requirement gathering from the business users, analysis and design.
• Identified and Installed the Business content data sources, DSOs and info providers
• Extracting data from ECC to BI using LO, FI - CA FI SL, COPA and Generic extraction.
• Worked with Business content extractors for General Ledger, Account Payables & Account Receivables to extract data from ECC
• Involved in Designing of Modelling Technical Specs, Report Technical Specs.
• Enhanced Business Content data sources according to the user requirements
• Created info Cubes, DSO, Transformations and DTP for Data Loading through Process chain from Source System.
• Involved in the Unit Testing and Integration testing.
• Involved in post implementation Support, Bug fixing, maintenance and trouble shooting.
• Extensively involved in Production Support by loading Daily loads/Weekly loads into the BW system from different source systems.
• Involved in BWA index activities on Data loading and Query performance.
• Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management for SD Application.
• Created and worked on daily basis with LO-Cockpit, Generic Data Source, Info Source, Transfer Rules, Update Rules & Info Package.
• Designed Info Sources, activated Pre/Post transformation rules, scripted extraction routines for master data, texts and hierarchies.
• Setup procedure for extracting R/3 data for Customers, Sales Order, Delivery in Sales and Distribution (SD) using LO-Cockpit.
• Installed Business Content Info Cubes, Info Sources from BW Side.
• Involved in Info Cube maintenance me.e. Compression, Aggregates and Roll-up.
• Actively and regularly involved in Load Monitoring of Daily, weekly and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.